web/install/edusoho_init_13.sql

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

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

INSERT INTO `user` (`id`, `email`, `verifiedMobile`, `password`, `salt`, `payPassword`, `payPasswordSalt`, `locale`, `uri`, `nickname`, `title`, `tags`, `type`, `point`, `coin`, `smallAvatar`, `mediumAvatar`, `largeAvatar`, `emailVerified`, `setup`, `roles`, `promoted`, `promotedSeq`, `promotedTime`, `locked`, `lockDeadline`, `consecutivePasswordErrorTimes`, `lastPasswordFailTime`, `loginTime`, `loginIp`, `loginSessionId`, `approvalTime`, `approvalStatus`, `newMessageNum`, `newNotificationNum`, `createdIp`, `createdTime`, `updatedTime`, `inviteCode`, `orgId`, `orgCode`, `registeredWay`, `distributorToken`, `uuid`, `passwordInit`, `faceRegistered`, `registerVisitId`) VALUES (1,'a@a.com','','+KmlZnnk5j4oRUnd+GG1lh/FD3hx61r6PY5hFdPX+CA=','jomp3q2xk2ok8ckw4ooc44wks8s4skk','','',NULL,'','默认教师','默认教师','','default',0,0,'public://default/2018/01-15/1721393063f7976683.png','public://default/2018/01-15/172139305883627899.png','public://default/2018/01-15/172139304cd4041642.png',0,1,'|ROLE_USER|ROLE_TEACHER|ROLE_SUPER_ADMIN|',1,1,1516009061,0,0,0,0,1558071912,'192.168.70.20','05jbgla6k5iqrpfme0p810oef7',0,'unapprove',0,0,'',1515719362,1558071913,NULL,1,'1.','','','f297eb2a59ca1f98354f3b3e125f0905e9838c29',1,0,''),(2,'user_r9q9w822j@edusoho.net','','bT8Yd2djDvwnkjuL9ophzfGz+C9arMHbci/S1P3xhpE=','6exe8q1u93go88w04css8ggwgwowwc4','','',NULL,'','usertd1ze0(系统用户)','','','system',0,0,'','','',1,1,'|ROLE_USER|ROLE_SUPER_ADMIN|',0,0,0,0,0,0,0,0,'','',0,'unapprove',0,0,'',1515719362,1524187248,NULL,1,'1.','','','476290ffff02ba9624456cbf0bfcaf7fbe9f5406',1,0,'');
INSERT INTO `user_active_log` (`id`, `userId`, `activeTime`, `createdTime`) VALUES (1,1,20180112,1515746702),(2,1,20180115,1516001621),(3,1,20180116,1516063497),(4,1,20180117,1516151499),(5,1,20180122,1516617438),(6,1,20180123,1516697318),(7,1,20180124,1516755669),(8,1,20180125,1516841519),(9,1,20180126,1516937399),(10,1,20180131,1517367947),(11,1,20180201,1517449508),(12,1,20180205,1517795103),(13,1,20180206,1517878884),(14,1,20180207,1517964942),(15,1,20180208,1518051498),(16,1,20180420,1524186441),(17,1,20180626,1529974983),(18,1,20180627,1530061031),(19,1,20180706,1530840173),(20,1,20180713,1531443369),(21,1,20180803,1533263788),(22,1,20180806,1533518602),(23,1,20180907,1536285588),(24,1,20190110,1547083559),(25,1,20190111,1547188674),(26,1,20190123,1548231655),(27,1,20190124,1548322831),(28,1,20190507,1557199713),(29,1,20190509,1557381707),(30,1,20190515,1557881834),(31,1,20190517,1558071525);
INSERT INTO `user_learn_statistics_total` (`id`, `userId`, `joinedClassroomNum`, `joinedCourseSetNum`, `joinedCourseNum`, `exitClassroomNum`, `exitCourseSetNum`, `exitCourseNum`, `learnedSeconds`, `finishedTaskNum`, `paidAmount`, `refundAmount`, `actualAmount`, `createdTime`, `updatedTime`) VALUES (1,1,0,0,0,0,0,0,0,0,0,0,0,1516726801,1516726801);
INSERT INTO `user_profile` (`id`, `truename`, `idcard`, `gender`, `iam`, `birthday`, `city`, `mobile`, `qq`, `signature`, `about`, `company`, `job`, `school`, `class`, `weibo`, `weixin`, `isQQPublic`, `isWeixinPublic`, `isWeiboPublic`, `site`, `intField1`, `intField2`, `intField3`, `intField4`, `intField5`, `dateField1`, `dateField2`, `dateField3`, `dateField4`, `dateField5`, `floatField1`, `floatField2`, `floatField3`, `floatField4`, `floatField5`, `varcharField1`, `varcharField2`, `varcharField3`, `varcharField4`, `varcharField5`, `varcharField6`, `varcharField7`, `varcharField8`, `varcharField9`, `varcharField10`, `textField1`, `textField2`, `textField3`, `textField4`, `textField5`, `textField6`, `textField7`, `textField8`, `textField9`, `textField10`) VALUES (1,'默认教师','','secret','',NULL,'','','11111111',NULL,'<p>此处显示个人设置中的自我介绍。<br />\n该账号为默认教师，系统不支持删除用户，请修改密码后通过【用户名＋密码】登录使用。<br />\n登录超管账号修改密码：【管理后台】-【用户】-【用户管理】-【操作】-【修改密码】。<br />\n如需修改“默认教师”用户名，请修改密码后登录该账号，前往【个人设置】中修改。</p>\n','','','','','','',1,1,1,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','','','','','','','','','','','','','','','','','','',''),(2,'','','secret','',NULL,'','','',NULL,NULL,'','','','','','',0,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);