```[sql] - ---------------------------- -- Table structure for ns_promotion_bundling -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bundling`; CREATE TABLE `ns_promotion_bundling` ( `bl_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '組合ID', `bl_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '組合名稱', `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `site_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點名稱', `bl_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品組合價格', `goods_money` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '商品總價', `shipping_fee_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '運費承擔方式 1賣家承擔運費 2買家承擔運費', `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '組合狀態 0-關閉/1-開啟', `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (`bl_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '組合套餐活動表' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_promotion_bundling_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_promotion_bundling_goods`; CREATE TABLE `ns_promotion_bundling_goods` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵', `bl_id` int(11) NOT NULL COMMENT '組合id', `sku_id` int(10) UNSIGNED NOT NULL COMMENT '商品skuid', `sku_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名稱', `price` decimal(10,2) NOT NULL COMMENT '商品sku原價', `sku_image` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'sku圖片', `promotion_price` decimal(10,2) NOT NULL COMMENT '套餐價格', `site_id` int(10) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1260 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '組合套餐活動商品表' ROW_FORMAT = Compact;