· 8 years ago · Mar 16, 2018, 12:00 PM
1CREATE TABLE IF NOT EXISTS `CubeCart_coupons` (
2 `coupon_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3 `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
4 `archived` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
5 `code` VARCHAR(25) NOT NULL,
6 `product_id` TEXT NOT NULL,
7 `discount_percent` DECIMAL(5,2) NOT NULL DEFAULT '0.00',
8 `discount_price` DECIMAL(16,2) NOT NULL DEFAULT '0.00',
9 `expires` DATE NOT NULL,
10 `allowed_uses` INT UNSIGNED NOT NULL DEFAULT '0',
11 `min_subtotal` DECIMAL(16,2) UNSIGNED NOT NULL DEFAULT '0.00',
12 `count` INT UNSIGNED NOT NULL DEFAULT '0',
13 `shipping` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
14 `free_shipping` ENUM('0','1') NOT NULL DEFAULT '0',
15 `subtotal` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
16 `description` text NOT NULL,
17 `cart_order_id` VARCHAR(18) DEFAULT NULL,
18 `email_sent` enum('0','1') NOT NULL DEFAULT '0',
19 PRIMARY KEY (`coupon_id`),
20 UNIQUE KEY `code` (`code`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; #EOQ