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