云之道知识付费v2 3.1.1独立版小程序系统源码搭建教程

CREATE TABLE IF NOT EXISTS `ims_yzd_kp` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `op` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; CREATE TABLE IF NOT EXISTS `ims_yzd_kp_address` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称', `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号', `province_id` int(11) NOT NULL, `province` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `city_id` int(11) NOT NULL, `city` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `district_id` int(11) NOT NULL, `district` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `detail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `is_default` tinyint(1) NOT NULL DEFAULT 0, `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `update_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, INDEX `is_default`(`is_default`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; CREATE TABLE IF NOT EXISTS `ims_yzd_kp_album` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID', `type_id` int(11) NULL DEFAULT NULL COMMENT '分类ID', `img` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '封面图', `title` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题', `state` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1显示 0隐藏', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '数字越大越靠前,默认排序为先添加的在前', `view` int(11) NOT NULL, `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `update_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `uniacid` int(11) NOT NULL COMMENT '平台ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; CREATE TABLE IF NOT EXISTS `ims_yzd_kp_album_list` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID', `album_id` int(11) NOT NULL COMMENT '相册ID', `img` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '图片', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `update_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0隐藏 1显示', `uniacid` int(11) NOT NULL COMMENT '平台ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; CREATE TABLE IF NOT EXISTS `ims_yzd_kp_annex` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '资料名称', `type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1上传 2链接 3自定义跳转', `file_name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文件名称', `file_url` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '文件链接', `file_id` int(11) NOT NULL DEFAULT 0, `url` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '链接', `url_name` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `type_id` int(11) NOT NULL COMMENT '分类ID', `img` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '封面图', `try_content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '试看内容', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详情', `is_alone_sale` tinyint(1) NOT NULL DEFAULT 1 COMMENT '单独售卖 0不支持 1支持', `price_type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '价格类型 1免费 2付费', `price` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额', `line_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '划线价', `state` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态 1上架 0下架', `uniacid` int(11) NOT NULL COMMENT '平台ID', `form_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联表单的ID', `sales` int(11) NOT NULL DEFAULT 0 COMMENT '销量', `default_sales` int(11) NOT NULL DEFAULT 0 COMMENT '初始起售数', `views` int(11) NOT NULL DEFAULT 0 COMMENT '浏览量', `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序', `add_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `update_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `vip_free_see` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0关闭 1开启', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; CREATE TABLE IF NOT EXISTS `ims_yzd_kp_annex_order` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID', `uniacid` int(11) NOT NULL COMMENT '平台ID', `user_id` int(11) NOT NULL COMMENT '用户ID', `annex_id` int(11) NOT NULL COMMENT '资料ID', `ordercode` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号', `out_trade_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商户号', `total_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单总金额', `total_pay_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单实际付款', `s_remark` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `submit_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '提交时间', `is_pay` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否支付 0未支付 1已支付', `pay_type` int(11) NULL DEFAULT NULL COMMENT '1微信支付 2支付宝支付 3百度小程序支付 4免费领取 5会员免费领取 6字节跳动微信支付 7字节跳动支付宝支付 8字节跳动银行卡支付 9通过课程免费兑换 ', `pay_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付时间', `is_sale` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否过售后时间 0没过 1过了', `cancel_state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '取消订单状态 0未取消 1已取消', `sale_state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否申请售后 0未申请 1申请了', `cancel_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '取消时间', `refund_result` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退款结果 0未退款 1退款成功 2退款失败', `refund_state` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退款状态 0未售后 1售后中 2售后结束', `refund_content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '退款内容', `refund_img` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '退款图片', `auto_cancel_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '自动取消时间', `auto_sales_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '自动过售后时间', `is_form` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否有表单 0没有 1有', `course_id` int(11) NULL DEFAULT NULL COMMENT '如果通过课程兑换的 需要有课