營銷（秒殺） · Niushop單商戶V5開發手冊

```[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;