web/install/edusoho_init_6.sql

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

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

INSERT INTO `course_member` (`id`, `courseId`, `classroomId`, `joinedType`, `userId`, `orderId`, `deadline`, `refundDeadline`, `levelId`, `learnedNum`, `learnedCompulsoryTaskNum`, `credit`, `noteNum`, `noteLastUpdateTime`, `isLearned`, `finishedTime`, `seq`, `remark`, `isVisible`, `role`, `locked`, `deadlineNotified`, `createdTime`, `lastLearnTime`, `updatedTime`, `lastViewTime`, `courseSetId`, `stickyTime`) VALUES (1,1,0,'course',1,0,0,0,0,0,0,0,0,0,0,0,0,'',1,'teacher',0,0,1516008196,1547191524,1547193248,1547193248,1,0);
INSERT INTO `course_set_v8` (`id`, `type`, `title`, `subtitle`, `tags`, `categoryId`, `summary`, `goals`, `audiences`, `isVip`, `cover`, `status`, `creator`, `createdTime`, `updatedTime`, `serializeMode`, `ratingNum`, `rating`, `noteNum`, `studentNum`, `hotSeq`, `recommended`, `recommendedSeq`, `recommendedTime`, `orgId`, `orgCode`, `discountId`, `discount`, `hitNum`, `maxRate`, `materialNum`, `parentId`, `locked`, `minCoursePrice`, `maxCoursePrice`, `teacherIds`, `defaultCourseId`) VALUES (1,'normal','课程管理说明（请务必完成学习！）','学习本课程后，可到【管理后台】-【课程】-【课程管理】中修改此课程的内容，或删除课程。','',0,'<p>请到该课程的管理页修改【课程信息】-【课程简介】。</p>\n','','',0,'{\"large\":\"public:\\/\\/default\\/2018\\/01-15\\/173111fa3f67352372.jpg\",\"middle\":\"public:\\/\\/default\\/2018\\/01-15\\/173111fa4abd521105.jpg\",\"small\":\"public:\\/\\/default\\/2018\\/01-15\\/173111fa5371918121.jpg\"}','published',1,1516008196,1547189447,'none',0,0,0,0,0,0,0,0,1,'1.',0,10.00,1,100,0,0,0,0.00,0.00,'|1|',1);
INSERT INTO `course_task` (`id`, `courseId`, `fromCourseSetId`, `seq`, `categoryId`, `activityId`, `title`, `isFree`, `isOptional`, `startTime`, `endTime`, `status`, `createdUserId`, `createdTime`, `updatedTime`, `mode`, `number`, `type`, `mediaSource`, `length`, `maxOnlineNum`, `copyId`, `migrateLessonId`) VALUES (1,1,1,8,1,1,'如何创建课程？',0,0,0,0,'published',1,1516008405,1547191578,'lesson','4','text','',0,0,0,0),(2,1,1,10,2,2,'如何设置课程教师？',0,0,0,0,'published',1,1516008430,1547191578,'lesson','5','text','',0,0,0,0),(3,1,1,14,3,3,'如何上传视频让学员学习？',0,0,0,0,'published',1,1516008459,1547191578,'lesson','7','text','',0,0,0,0),(4,1,1,16,4,4,'如何添加作业练习和考试？',0,0,0,0,'published',1,1516008485,1547191578,'lesson','8','text','',0,0,0,0),(5,1,1,18,5,5,'如何添加学习资料让学员下载？',0,0,0,0,'published',1,1516008522,1547191578,'lesson','9','text','',0,0,0,0),(6,1,1,20,6,6,'管理员如何管理课程和设置教师权限？',0,0,0,0,'published',1,1516008543,1547191578,'lesson','10','text','',0,0,0,0),(7,1,1,22,7,7,'如何查看课程订单和营收？',0,0,0,0,'published',1,1516008568,1547191578,'lesson','11','text','',0,0,0,0),(8,1,1,24,8,8,'关闭课程与删除课程',0,0,0,0,'published',1,1516008595,1547191578,'lesson','12','text','',0,0,0,0),(9,1,1,4,9,9,'班级、课程、教学计划、任务（课时）的关系',0,0,0,0,'published',1,1547190435,1547191578,'lesson','2','text','',0,0,0,0),(10,1,1,6,10,10,'课程类型介绍：普通课程、直播课程、录播公开课、直播公开课',0,0,0,0,'published',1,1547190480,1547191578,'lesson','3','text','',0,0,0,0),(11,1,1,12,11,11,'课程价格与加入设置',0,0,0,0,'published',1,1547190702,1547191578,'lesson','6','text','',0,0,0,0),(12,1,1,2,12,12,'系统功能学习说明（网站管理员）',0,0,0,0,'published',1,1547191162,1547191578,'lesson','1','text','',0,0,0,0);
INSERT INTO `course_v8` (`id`, `courseSetId`, `title`, `subtitle`, `courseSetTitle`, `learnMode`, `expiryMode`, `expiryDays`, `expiryStartDate`, `expiryEndDate`, `summary`, `goals`, `audiences`, `isDefault`, `maxStudentNum`, `status`, `seq`, `creator`, `isFree`, `price`, `vipLevelId`, `buyable`, `tryLookable`, `tryLookLength`, `watchLimit`, `services`, `taskNum`, `compulsoryTaskNum`, `lessonNum`, `publishLessonNum`, `studentNum`, `teacherIds`, `parentId`, `createdTime`, `updatedTime`, `ratingNum`, `rating`, `noteNum`, `questionNum`, `discussionNum`, `buyExpiryTime`, `threadNum`, `type`, `approval`, `income`, `originPrice`, `coinPrice`, `originCoinPrice`, `showStudentNumType`, `giveCredit`, `about`, `locationId`, `address`, `deadlineNotify`, `daysOfNotifyBeforeDeadline`, `useInClassroom`, `singleBuy`, `freeStartTime`, `freeEndTime`, `locked`, `cover`, `enableFinish`, `materialNum`, `maxRate`, `serializeMode`, `showServices`, `recommended`, `recommendedSeq`, `recommendedTime`, `categoryId`, `hitNum`, `courseType`, `rewardPoint`, `taskRewardPoint`, `enableAudio`, `isHideUnpublish`) VALUES (1,1,'','','课程管理说明（请务必完成学习！）','freeMode','forever',0,0,0,'','','',1,0,'published',1,1,1,0.00,0,1,0,0,0,'',12,12,12,12,0,'|1|',0,1516008196,1547191174,0,0,0,0,0,0,0,'normal',0,0.00,0.00,0.00,0.00,'opened',0,NULL,0,'','none',0,'single',1,0,0,0,NULL,1,0,100,'none',0,0,0,0,0,17,'default',0,0,0,0);