云课堂源码-带分销插件-全场景付费音视频内容管理系统源码

<?php $sql=" CREATE TABLE IF NOT EXISTS `ims_muu_classroom_announce` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(10) NOT NULL, `uid` int(11) unsigned NOT NULL COMMENT '操作用户ID', `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '公告类型 1、图片 0、文字', `title` varchar(128) NOT NULL COMMENT '公告标题', `content` text NOT NULL COMMENT '公告描述', `cover` varchar(255) NOT NULL DEFAULT '0' COMMENT '公告图片', `url` varchar(255) NOT NULL COMMENT '公告链接', `sort` int(11) NOT NULL COMMENT '排序', `status` tinyint(2) NOT NULL DEFAULT '0', `create_time` int(11) unsigned NOT NULL COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公告表'; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_attribute` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(11) NOT NULL COMMENT '平台ID', `pid` int(11) NOT NULL DEFAULT '0' COMMENT '上级属性', `title` varchar(90) NOT NULL COMMENT '标题', `cover` varchar(255) NOT NULL COMMENT '封面图', `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `status` tinyint(2) NOT NULL COMMENT '状态，1，正常，0，禁用，-1，已删除', `create_time` int(11) NOT NULL COMMENT '创建时间', `update_time` int(11) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='课程专栏自定义属性表'; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_category` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(10) NOT NULL, `pid` int(11) unsigned NOT NULL COMMENT '上级分类ID', `uid` int(11) unsigned NOT NULL COMMENT '操作用户ID', `title` varchar(64) NOT NULL COMMENT '分类名称', `description` varchar(120) NOT NULL COMMENT '简短描述', `cover` varchar(255) NOT NULL DEFAULT '0' COMMENT '分类封面图', `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序', `status` tinyint(2) NOT NULL DEFAULT '0', `create_time` int(11) unsigned NOT NULL COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='课程分类表'; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_checkin` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(11) unsigned NOT NULL COMMENT '平台ID', `uid` int(11) NOT NULL, `create_time` int(11) unsigned NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_checkin_config` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(11) unsigned NOT NULL COMMENT '平台ID', `config` varchar(255) NOT NULL COMMENT '配置数据', `create_time` int(11) unsigned NOT NULL COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_checkin_total` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(11) unsigned NOT NULL COMMENT '平台ID', `uid` int(11) NOT NULL, `total` int(11) unsigned NOT NULL COMMENT '总签到数', `con` int(11) unsigned NOT NULL COMMENT '连续签到数', `create_time` int(11) unsigned NOT NULL COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_column` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '专栏ID', `uniacid` int(10) NOT NULL, `uid` int(11) unsigned NOT NULL COMMENT '操作用户ID', `title` varchar(128) NOT NULL COMMENT '专栏标题', `type` varchar(16) NOT NULL DEFAULT 'column' COMMENT '类型 默认column', `category_id` int(11) unsigned DEFAULT '0' COMMENT '分类ID', `attribute_ids` varchar(255) NOT NULL COMMENT '自定义属性值', `cover` varchar(255) NOT NULL COMMENT '专栏封面图片ID', `description` varchar(255) NOT NULL COMMENT '专栏描述', `custom_desc` text NOT NULL COMMENT '付费后可查看的内容', `content` text NOT NULL COMMENT '专栏详细描述', `expense` tinyint(4) unsigned DEFAULT '0' COMMENT '是否付费类 1付费 0免费', `price` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '专栏价格（单位：分）', `marking_price` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '划线价格（单位：分）', `knowledge_ids` text NOT NULL COMMENT '专栏内容IDS', `status` tinyint(4) NOT NULL COMMENT '专栏状态', `view` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读量', `f_view` int(11) unsigned NOT NULL COMMENT '虚拟浏览量', `sales` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '销售量', `f_sales` int(11) unsigned NOT NULL COMMENT '虚拟销售量', `favorites` int(11) unsigned NOT NULL COMMENT '收藏量', `f_favorites` int(11) unsigned NOT NULL COMMENT '虚拟收藏量', `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序值', `score` int(11) NOT NULL DEFAULT '0' COMMENT '购买课程返还积分数', `teacher_id` int(11) unsigned NOT NULL COMMENT '讲师ID', `start_time` int(11) unsigned NOT NULL COMMENT '上架时间', `create_time` int(11) unsigned NOT NULL, `update_time` int(11) unsigned NOT NULL, `only_member` tinyint(2) NOT NULL COMMENT '会员专享0：否 1：是', `limit_time` int(10) NOT NULL COMMENT '课程有效期 单位：天 0：永久', `reason` varchar(255) NOT NULL COMMENT '审核失败原因', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='专栏表'; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_evaluate` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `uniacid` int(11) NOT NULL COMMENT '平台ID', `uid` int(11) NOT NULL COMMENT '用户ID', `type` varchar(255) NOT NULL COMMENT '课程类型：专栏：column 单课：knowledge', `type_id` int(11) NOT NULL COMMENT '课程ID', `order_no` varchar(255) NOT NULL COMMENT '订单号', `images` varchar(600) NOT NULL COMMENT '评价晒图', `value` decimal(3,2) NOT NULL COMMENT '评分', `content` varchar(600) NOT NULL COMMENT '评价内容', `add_content` varchar(600) NOT NULL COMMENT '追加评论 json格式{images:content:}', `reply` text NOT NULL COMMENT '评价回复', `reply_time` int(11) unsigned NOT NULL COMMENT '回复时间', `create_time` int(11) NOT NULL, `update_time` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单评价表'; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_favorites` ( `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(10) NOT NULL, `uid` int(11) unsigned NOT NULL COMMENT '用户ID', `info_type` varchar(32) NOT NULL COMMENT '知识类型，knowledge:知识内容，column：专栏内容，关联不同模型', `info_id` bigint(11) unsigned NOT NULL COMMENT '内容ID,知识内容或专栏的ID', `status` tinyint(4) NOT NULL COMMENT '订单状态，1，正常，0，禁用，-1，已删除', `create_time` int(11) unsigned NOT NULL COMMENT '创建时间', `update_time` int(11) unsigned NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='付费知识订单'; CREATE TABLE IF NOT EXISTS `ims_muu_classroom_feedback` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID', `uniacid` int(11) unsigned NOT NULL COMMENT '平台ID', `content` varchar(255) NOT NULL COMMENT '反馈内容', `uid` int(11) unsigned NOT NULL COMMENT '用户ID', `status` tinyint(2) NOT NULL COMMENT '状态，1，正常�