云之道知识付费v2独立版-2.9.3

-- -- Table structure for table `ims_yzd_kp` -- DROP TABLE IF EXISTS `ims_yzd_kp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ims_yzd_kp` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `content` longtext NOT NULL, `op` longtext, `time` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ims_yzd_kp` -- LOCK TABLES `ims_yzd_kp` WRITE; /*!40000 ALTER TABLE `ims_yzd_kp` DISABLE KEYS */; /*!40000 ALTER TABLE `ims_yzd_kp` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ims_yzd_kp_address` -- DROP TABLE IF EXISTS `ims_yzd_kp_address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ims_yzd_kp_address` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '用户ID', `name` varchar(255) NOT NULL COMMENT '名称', `phone` varchar(255) NOT NULL COMMENT '手机号', `province_id` int(11) NOT NULL, `province` varchar(255) NOT NULL, `city_id` int(11) NOT NULL, `city` varchar(255) NOT NULL, `district_id` int(11) NOT NULL, `district` varchar(255) NOT NULL, `detail` longtext NOT NULL, `is_default` tinyint(1) NOT NULL DEFAULT '0', `add_time` varchar(255) NOT NULL, `update_time` varchar(255) NOT NULL, `uniacid` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `user_id` (`user_id`) USING BTREE, KEY `is_default` (`is_default`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ims_yzd_kp_address` -- LOCK TABLES `ims_yzd_kp_address` WRITE; /*!40000 ALTER TABLE `ims_yzd_kp_address` DISABLE KEYS */; /*!40000 ALTER TABLE `ims_yzd_kp_address` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ims_yzd_kp_album` -- DROP TABLE IF EXISTS `ims_yzd_kp_album`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ims_yzd_kp_album` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID', `type_id` int(11) DEFAULT NULL COMMENT '分类ID', `img` longtext COMMENT '封面图', `title` longtext 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) DEFAULT NULL, `update_time` varchar(255) DEFAULT NULL, `uniacid` int(11) NOT NULL COMMENT '平台ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ims_yzd_kp_album` -- LOCK TABLES `ims_yzd_kp_album` WRITE; /*!40000 ALTER TABLE `ims_yzd_kp_album` DISABLE KEYS */; /*!40000 ALTER TABLE `ims_yzd_kp_album` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ims_yzd_kp_album_list` -- DROP TABLE IF EXISTS `ims_yzd_kp_album_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ims_yzd_kp_album_list` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID', `album_id` int(11) NOT NULL COMMENT '相册ID', `img` longtext COMMENT '图片', `title` varchar(255) DEFAULT NULL COMMENT '标题', `add_time` varchar(255) DEFAULT NULL, `update_time` varchar(255) 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 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ims_yzd_kp_album_list` -- LOCK TABLES `ims_yzd_kp_album_list` WRITE; /*!40000 ALTER TABLE `ims_yzd_kp_album_list` DISABLE KEYS */; /*!40000 ALTER TABLE `ims_yzd_kp_album_list` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ims_yzd_kp_annex` -- DROP TABLE IF EXISTS `ims_yzd_kp_annex`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ims_yzd_kp_annex` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `title` varchar(255) NOT NULL COMMENT '资料名称', `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1上传 2链接 3自定义跳转', `file_name` longtext COMMENT '文件名称', `file_url` longtext COMMENT '文件链接', `file_id` int(11) NOT NULL DEFAULT '0', `url` longtext COMMENT '链接', `url_name` longtext, `type_id` int(11) NOT NULL COMMENT '分类ID', `img` longtext NOT NULL COMMENT '封面图', `try_content` longtext COMMENT '试看内容', `content` longtext 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) DEFAULT NULL COMMENT '金额', `line_price` decimal(10,2) 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) NOT NULL, `update_time` varchar(255) NOT NULL, `vip_free_see` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0关闭 1开启', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ims_yzd_kp_annex` -- LOCK TABLES `ims_yzd_kp_annex` WRITE; /*!40000 ALTER TABLE `ims_yzd_kp_annex` DISABLE KEYS */; /*!40000 ALTER TABLE `ims_yzd_kp_annex` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ims_yzd_kp_annex_order` -- DROP TABLE IF EXISTS `ims_yzd_kp_annex_order`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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) NOT NULL COMMENT '订单号', `out_trade_no` varchar(255) 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, `submit_time` varchar(255) NOT NULL COMMENT '提交时间', `is_pay` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否支付 0未支付 1已支付', `pay_type` int(11) DEFAULT NULL COMMENT '1微信支付 2支付宝支付 3百度小程序支付 4免费领取 5会员免费领取 6字节跳动微信支付 7字节跳动支付宝支付 8字节跳动银行卡支付 9通过课程免费兑换 ', `pay_time` varchar(255) 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) DEFAULT NULL COMMENT '取消时间', `refund_result` tinyint(1) NOT NULL DEFAULT '0' COMMENT '退款结果 0未退款 1退款成功 2退款失败', `refund_state` tinyint(1) NOT NULL