```[sql] -- ---------------------------- -- Table structure for ns_weapp_experiencer -- ---------------------------- DROP TABLE IF EXISTS `ns_weapp_experiencer`; CREATE TABLE `ns_weapp_experiencer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL COMMENT '站点id', `wechatid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信号', `userstr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信用户唯一值', `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '添加时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信小程序体验者' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_weapp_goods -- ---------------------------- DROP TABLE IF EXISTS `ns_weapp_goods`; CREATE TABLE `ns_weapp_goods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL COMMENT '站点id', `goods_id` int(11) NOT NULL COMMENT '小程序商品库商品id 非商城商品id', `name` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品名称', `cover_img` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品图片链接', `price` decimal(10,2) NOT NULL COMMENT '商品价格', `status` int(255) NOT NULL COMMENT '商品状态，0：未审核。1：审核中，2：审核通过，3：审核驳回', `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品小程序链接', `audit_id` int(11) NOT NULL COMMENT '审核单id', `sku_id` int(11) NOT NULL COMMENT '商品sku_id', `third_party_tag` int(1) NOT NULL COMMENT '商品来源 0在小程序平台添加的商品 1/2通过api添加的商品', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2340 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_weapp_live_room -- ---------------------------- DROP TABLE IF EXISTS `ns_weapp_live_room`; CREATE TABLE `ns_weapp_live_room` ( `id` int(11) NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL COMMENT '站点id', `roomid` int(11) NOT NULL COMMENT '直播间id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房间名称', `cover_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '房间背景封面', `share_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分享卡片图片', `start_time` int(11) NOT NULL COMMENT '直播计划开始时间', `end_time` int(11) NOT NULL COMMENT '直播计划结束时间', `anchor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主播昵称', `goods` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '直播间商品', `live_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'live_status 101: 直播中, 102: 未开始, 103: 已结束, 104: 禁播, 105: 暂停中, 106: 异常, 107: 已过期', `anchor_img` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主播头像', `banner` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '直播间横幅', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1638 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '小程序直播直播间表' ROW_FORMAT = Compact;