```[sql] -- ---------------------------- -- Table structure for ns_promotion_discount -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_discount`; CREATE TABLE `ns_promotion_discount` ( `discount_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', `site_id` int(11) NOT NULL DEFAULT 1 COMMENT '站点id', `site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站点名称', `discount_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '活动名称', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '活动状态 0未开始 1进行中 2已结束 -1已关闭（手动）', `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动开始时间', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动结束时间', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间', `modify_time` int(11) NOT NULL DEFAULT 0 COMMENT '修改时间', PRIMARY KEY (`discount_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1489 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '限时折扣' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_discount_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_discount_goods`; CREATE TABLE `ns_promotion_discount_goods` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', `discount_id` int(11) NOT NULL DEFAULT 0 COMMENT '对应活动Id', `start_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动开始时间', `end_time` int(11) NOT NULL DEFAULT 0 COMMENT '活动结束时间', `goods_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'skuId', `price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品价格', `discount_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '折扣价', `sku_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '商品名称', `sku_image` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '商品图片', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 780 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '限时折扣商品列表' ROW_FORMAT = Compact;