web/install/edusoho_init_5.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

INSERT INTO `course_chapter` (`id`, `courseId`, `type`, `number`, `seq`, `title`, `createdTime`, `updatedTime`, `copyId`, `status`, `isOptional`, `migrateLessonId`, `migrateCopyCourseId`, `migrateRefTaskId`, `mgrateCopyTaskId`, `migrate_task_id`, `published_number`) VALUES (1,1,'lesson',4,7,'如何创建课程？',1516008405,1547191578,0,'published',0,0,0,0,0,0,4),(2,1,'lesson',5,9,'如何设置课程教师？',1516008430,1547191578,0,'published',0,0,0,0,0,0,5),(3,1,'lesson',7,13,'如何上传视频让学员学习？',1516008459,1547191578,0,'published',0,0,0,0,0,0,7),(4,1,'lesson',8,15,'如何添加作业练习和考试？',1516008485,1547191578,0,'published',0,0,0,0,0,0,8),(5,1,'lesson',9,17,'如何添加学习资料让学员下载？',1516008522,1547191578,0,'published',0,0,0,0,0,0,9),(6,1,'lesson',10,19,'管理员如何管理课程和设置教师权限？',1516008543,1547191578,0,'published',0,0,0,0,0,0,10),(7,1,'lesson',11,21,'如何查看课程订单和营收？',1516008568,1547191578,0,'published',0,0,0,0,0,0,11),(8,1,'lesson',12,23,'关闭课程与删除课程',1516008595,1547191578,0,'published',0,0,0,0,0,0,12),(9,1,'lesson',2,3,'班级、课程、教学计划、任务（课时）的关系',1547190435,1547191578,0,'published',0,0,0,0,0,0,2),(10,1,'lesson',3,5,'课程类型介绍：普通课程、直播课程、录播公开课、直播公开课',1547190480,1547191578,0,'published',0,0,0,0,0,0,3),(11,1,'lesson',6,11,'课程价格与加入设置',1547190702,1547191578,0,'published',0,0,0,0,0,0,6),(12,1,'lesson',1,1,'系统功能学习说明（网站管理员）',1547191162,1547191578,0,'published',0,0,0,0,0,0,1);
INSERT INTO `course_draft` (`id`, `title`, `summary`, `courseId`, `content`, `userId`, `activityId`, `createdTime`) VALUES (24,'',NULL,1,'<p><span style=\"font-size:14px;\">1、教师身份</span></p>\n\n<p><span style=\"font-size:14px;\">路径：网站首页【我的教学】-【创建课程】。</span></p>\n\n<p><span style=\"font-size:14px;\">2、管理员身份</span></p>\n\n<p><span style=\"font-size:14px;\">路径：【管理后台】-【课程】-【课程管理】-【创建课程】，只有管理员有权限进入管理后台。</span></p>\n\n<p>&nbsp;</p>\n\n<p><strong>【必学】课程功能说明：<a href=\"http://www.qiqiuyu.com/course/22\">http://www.qiqiuyu.com/course/22</a></strong></p>\n',1,1,1547190930),(25,'',NULL,1,'<p>路径：【课程管理页】-【默认计划设置】-【教师设置】。</p>\n\n<p>说明：只能添加有教师权限的用户为课程老师；</p>\n\n<p><span style=\"font-size:14px;\"><strong>如何给某个用户教师权限？</strong></span></p>\n\n<p>路径：【管理后台】-【用户】-【用户管理】，搜索到要提升权限的用户，点击操作一栏下的【设置用户组】，勾选对应权限保存即可。</p>\n\n<p>&nbsp;</p>\n\n<p><strong>【必学】课程功能说明：<a href=\"http://www.qiqiuyu.com/course/22\">http://www.qiqiuyu.com/course/22</a></strong></p>\n\n<p>&nbsp;</p>\n',1,2,1547190935),(28,'',NULL,1,'<p><strong>考试功能说明：<a href=\"http://www.qiqiuyu.com/faq/784/detail\" target=\"_blank\">http://www.qiqiuyu.com/faq/784/detail</a></strong></p>\n\n<p><strong>作业功能说明：<a href=\"http://www.qiqiuyu.com/faq/785/detail\" target=\"_blank\">http://www.qiqiuyu.com/faq/785/detail</a></strong></p>\n\n<p><strong>练习功能说明：<a href=\"http://www.qiqiuyu.com/faq/786/detail\" target=\"_blank\">http://www.qiqiuyu.com/faq/786/detail</a></strong></p>\n\n<p><strong>考试、作业、练习的区别：<a href=\"http://www.qiqiuyu.com/faq/751/detail\" target=\"_blank\">http://www.qiqiuyu.com/faq/751/detail</a></strong></p>\n\n<p><img alt=\"\" src=\"/files/course/2019/01-11/14582845b3c1548340.png\" /></p>\n\n<p><img alt=\"\" src=\"/files/course/2019/01-11/150534e8930a874658.png\" /></p>\n\n<p>&nbsp;</p>\n',1,4,1547190961),(30,'',NULL,1,'<p>路径：【课程管理页】-【默认计划设置】-【课时管理】-【添加课时】-【选择教学任务&middot;下载资料】，上传资料并保存。</p>\n\n<p>&nbsp;</p>\n\n<p>确保课程已发布，学员加入课程后，可在课程【资料区】中下载资料。</p>\n\n<p>&nbsp;</p>\n\n<p><strong>【必学】课程功能说明：<a href=\"http://www.qiqiuyu.com/course/22\">http://www.qiqiuyu.com/course/22</a></strong></p>\n',1,5,1547190974),(32,'',NULL,1,'<p><span style=\"font-size:16px;\"><strong>【必学】课程功能说明：<a href=\"http://www.qiqiuyu.com/course/22\">http://www.qiqiuyu.com/course/22</a></strong></span></p>\n\n<p><span style=\"font-size:16px;\"><strong>【必学】管理后台功能说明：<a href=\"http://www.qiqiuyu.com/course/429\">http://www.qiqiuyu.com/course/429</a></strong></span></p>\n\n<p><span style=\"font-size:16px;\"><strong>【常用】系统功能问答中心（搜关键词找教程）：<a href=\"http://www.qiqiuyu.com/faq/search\">http://www.qiqiuyu.com/faq/search</a></strong></span></p>\n\n<p>&nbsp;</p>\n\n<p>&nbsp;</p>\n\n<p>&nbsp;</p>\n',1,0,1547191163);