fluent-cart / database / Migrations / AppliedCouponsMigrator.php

AppliedCouponsMigrator.php in FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler 1.3.27, at database/Migrations/AppliedCouponsMigrator.php

26 lines 635 B

Raw Download Zip

1	<?php
2
3	namespace FluentCart\Database\Migrations;
4
5
6	use FluentCart\Framework\Database\Schema;
7
8	class AppliedCouponsMigrator extends Migrator
9	{
10
11	public static string $tableName = 'fct_applied_coupons';
12
13	public static function getSqlSchema(): string
14	{
15	$indexPrefix = 'fct_acoup_';
16	return "`id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
17	`order_id` BIGINT UNSIGNED NOT NULL,
18	`coupon_id` BIGINT UNSIGNED NULL,
19	`code` VARCHAR(100) NOT NULL ,
20	`amount` double NOT NULL,
21	`created_at` DATETIME NULL ,
22	`updated_at` DATETIME NULL,
23	INDEX `{$indexPrefix}_code_idx` (`code`)";
24	}
25	}
26