DROP TABLE IF EXISTS `campaign`;
CREATE TABLE `campaign` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `campaign_name` varchar(100) NOT NULL,
                            `discount_type` varchar(100) NOT NULL,
                            `discount_value_rate` varchar(100) NOT NULL,
                            `customer_type` varchar(10) DEFAULT NULL,
                            `customer_group` int NOT NULL,
                            `discount_diffrent_type` varchar(10) NOT NULL,
                            `value` json NOT NULL,
                            `status` int NOT NULL,
                            `insert_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
                            `shop_id` int NOT NULL,
                            `discount_brand` int NOT NULL,
                            `group_code` varchar(10) DEFAULT NULL,
                            `sort_order` int NOT NULL,
                            `start_date` datetime DEFAULT NULL,
                            `end_date` datetime DEFAULT NULL,
                            `discount_date` datetime DEFAULT NULL,
                            `product_group` varchar(50) DEFAULT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;