web/install/edusoho_init_2.sql

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

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

INSERT INTO `biz_pay_user_balance` (`id`, `user_id`, `amount`, `cash_amount`, `locked_amount`, `recharge_amount`, `purchase_amount`, `updated_time`, `created_time`, `migrate_id`) VALUES (1,0,0,0,0,0,0,1515719362,1515719362,0);
INSERT INTO `biz_scheduler_job` (`id`, `name`, `pool`, `source`, `expression`, `class`, `args`, `priority`, `pre_fire_time`, `next_fire_time`, `misfire_threshold`, `misfire_policy`, `enabled`, `creator_id`, `updated_time`, `created_time`) VALUES (1,'Order_FinishSuccessOrdersJob','default','MAIN','20 * * * *','Codeages\\Biz\\Order\\Job\\FinishSuccessOrdersJob','',100,1558070400,1558074000,300,'missed',1,0,1558070401,1515719362),(2,'Order_CloseOrdersJob','default','MAIN','20 * * * *','Codeages\\Biz\\Order\\Job\\CloseExpiredOrdersJob','',100,1558070400,1558074000,300,'missed',1,0,1558070401,1515719362),(3,'DeleteExpiredTokenJob','default','MAIN','0 * * * *','Biz\\User\\Job\\DeleteExpiredTokenJob','',100,1558069200,1558072800,300,'missed',1,0,1558069201,1515719362),(4,'SessionGcJob','default','MAIN','0 * * * *','Codeages\\Biz\\Framework\\Session\\Job\\SessionGcJob','',100,1558069200,1558072800,300,'missed',1,0,1558069201,1515719362),(5,'OnlineGcJob','default','MAIN','0 * * * *','Codeages\\Biz\\Framework\\Session\\Job\\OnlineGcJob','',100,1558069200,1558072800,300,'missed',1,0,1558069201,1515719362),(6,'Scheduler_MarkExecutingTimeoutJob','dedicated','MAIN','0 * * * *','Codeages\\Biz\\Framework\\Scheduler\\Job\\MarkExecutingTimeoutJob','',100,1558069200,1558072800,300,'missed',1,0,1558069201,1515719362),(7,'RefreshLearningProgressJob','default','MAIN','0 2 * * *','Biz\\Course\\Job\\RefreshLearningProgressJob','',100,1558029600,1558116000,300,'executing',1,0,1558029602,1515719362),(8,'UpdateInviteRecordOrderInfoJob','default','MAIN','0 * * * *','Biz\\User\\Job\\UpdateInviteRecordOrderInfoJob','',100,1558069200,1558072800,300,'missed',1,0,1558069201,1515719362),(12,'SyncUserTotalLearnStatisticsJob','default','MAIN','*/3 1-6 * * *','Biz\\UserLearnStatistics\\Job\\SyncTotalJob','{\"lastUserId\":\"1\"}',100,1516726980,1516727160,300,'missed',0,0,1516726981,1516698363),(13,'SyncUserLearnDailyPastLearnStatisticsJob','default','MAIN','*/3 1-6 * * *','Biz\\UserLearnStatistics\\Job\\SyncDailyPastDataJob','{\"cursor\":1485014400}',100,1517073480,1517073660,300,'missed',0,0,1517073481,1516698363),(14,'DeleteUserLearnDailyPastLearnStatisticsJob','default','MAIN','0 2 * * *','Biz\\UserLearnStatistics\\Job\\DeletePastDataJob','',100,1558029600,1558116000,300,'missed',1,0,1558029602,1516698363),(15,'SyncUserLearnDailyLearnStatisticsJob','default','MAIN','0 1 * * *','Biz\\UserLearnStatistics\\Job\\SyncDaily','{\"cursor\":1558022400}',100,1558026000,1558112400,300,'missed',1,0,1558026002,1516698363),(16,'StorageDailyLearnStatisticsJob','default','MAIN','0 3 * * *','Biz\\UserLearnStatistics\\Job\\StorageDailyJob','',100,1558033200,1558119600,300,'missed',1,0,1558033201,1516698363),(17,'Xapi_PushStatementsJob','default','MAIN','46 1-6 * * *','Biz\\Xapi\\Job\\PushStatementJob','',100,1558046760,1558115160,300,'missed',1,0,1558046761,1516698389),(18,'Xapi_AddActivityWatchToStatementJob','default','MAIN','49 1-6 * * *','Biz\\Xapi\\Job\\AddActivityWatchToStatementJob','',100,1558046940,1558115340,300,'missed',1,0,1558046941,1516698389),(19,'Xapi_ArchiveStatementJob','default','MAIN','58 1-6 * * *','Biz\\Xapi\\Job\\ArchiveStatementJob','',100,1558047480,1558115880,300,'missed',1,0,1558047482,1516698389),(20,'CheckConvertStatusJob','default','MAIN','*/15 * * * *','Biz\\File\\Job\\VideoMediaStatusUpdateJob','{\"cursor\":\"0\",\"start\":1000,\"limit\":\"1000\"}',100,1558071900,1558072800,300,'missed',1,0,1558071901,1516698390),(21,'Xapi_ConvertStatementsJob','default','MAIN','*/10 1-6 * * *','Biz\\Xapi\\Job\\ConvertStatementJob','',100,1558047000,1558112400,300,'missed',1,0,1558047002,1516698424),(22,'DistributorSyncJob','default','MAIN','*/19 * * * *','Biz\\Distributor\\Job\\DistributorSyncJob','',100,1558071480,1558072620,300,'missed',1,0,1558071481,1517449759),(23,'DeleteFiredLogJob','default','MAIN','0 23 * * *','Codeages\\Biz\\Framework\\Scheduler\\Job\\DeleteFiredLogJob','',100,1558018800,1558105200,300,'missed',1,0,1558018801,1524187290),(24,'updateCourseSetHotSeq','default','MAIN','47 4 * * *','Biz\\Course\\Job\\UpdateCourseSetHotSeqJob','',100,1558039620,1558126020,0,'missed',1,0,1558039622,1524187307),(25,'UpdateLiveStatusJob','default','MAIN','*/10 * * * *','Biz\\Live\\Job\\UpdateLiveStatusJob','',100,1558071600,1558072200,300,'missed',1,0,1558071601,1524187338),(27,'CloudConsultFreshJob','default','MAIN','54 6 * * *','Biz\\CloudPlatform\\Job\\CloudConsultFreshJob','',200,1558047240,1558133640,300,'executing',1,0,1558047241,1547101592);
INSERT INTO `biz_scheduler_job_pool` (`id`, `name`, `max_num`, `num`, `timeout`, `updated_time`, `created_time`) VALUES (1,'default',10,0,120,1515720001,1515720001),(2,'dedicated',10,0,120,1515722401,1515722401);