```[sql] - ---------------------------- -- Table structure for ns_promotion_topic -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_topic`; CREATE TABLE `ns_promotion_topic` ( `topic_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', `site_id` int(10) NOT NULL DEFAULT 0 COMMENT '站点id', `topic_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '专题名称', `topic_adv` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '专题广告', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '活动状态 1未开始 2进行中 3已结束', `remark` varchar(255) 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 '修改时间', `bg_color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#ffffff' COMMENT '背景色', PRIMARY KEY (`topic_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '专题活动' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_topic_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_topic_goods`; CREATE TABLE `ns_promotion_topic_goods` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键', `topic_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 '活动结束时间', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT 'skuId', `topic_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '折扣价', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2048 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '限时折扣商品列表' ROW_FORMAT = Compact;