```[sql] -- ---------------------------- -- Table structure for ns_promotion_seckill -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_seckill`; CREATE TABLE `ns_promotion_seckill` ( `seckill_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点id', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '秒杀主题', `seckill_time` int(11) NOT NULL DEFAULT 0 COMMENT '秒杀时间4位（时+分（两位））', `seckill_end_time` int(11) NOT NULL DEFAULT 0 COMMENT '结束时间点', `config_json` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '{}' COMMENT '配置信息', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间', `modify_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '修改时间', `seckill_start_time` int(11) NOT NULL DEFAULT 0 COMMENT '开始时间点', PRIMARY KEY (`seckill_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 5461 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '秒杀活动' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_seckill_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_seckill_goods`; CREATE TABLE `ns_promotion_seckill_goods` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `seckill_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '主键', `seckill_time` int(11) NOT NULL DEFAULT 0 COMMENT '秒杀时间段', `sku_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品id', `seckill_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '秒杀', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站点ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 744 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '秒杀参与商品' ROW_FORMAT = Compact;