moodle_backup.sql 1.29 MB
Newer Older
13001
13002
13003
13004
13005
13006
13007
13008
13009
13010
13011
13012
13013
13014
13015
13016
13017
13018
13019
13020
13021
13022
13023
13024
13025
13026
13027
13028
13029
13030
13031
13032
13033
13034
13035
13036
13037
13038
13039
13040
13041
13042
13043
13044
13045
13046
13047
13048
13049
13050
13051
13052
13053
13054
13055
13056
13057
13058
13059
13060
13061
13062
13063
13064
13065
13066
13067
13068
13069
13070
13071
13072
13073
13074
13075
13076
13077
13078
13079
13080
13081
13082
13083
13084
13085
13086
13087
13088
13089
13090
13091
13092
13093
13094
13095
13096
13097
13098
13099
13100
13101
13102
13103
13104
13105
13106
13107
13108
13109
13110
13111
13112
13113
13114
13115
13116
13117
13118
13119
13120
13121
13122
13123
13124
13125
13126
13127
13128
13129
13130
13131
13132
13133
13134
13135
13136
13137
13138
13139
13140
13141
13142
13143
13144
13145
13146
13147
13148
13149
13150
13151
13152
13153
13154
13155
13156
13157
13158
13159
13160
13161
13162
13163
13164
13165
13166
13167
13168
13169
13170
13171
13172
13173
13174
13175
13176
13177
13178
13179
13180
13181
13182
13183
13184
13185
13186
13187
13188
13189
13190
13191
13192
13193
13194
13195
13196
13197
13198
13199
13200
13201
13202
13203
13204
13205
13206
13207
13208
13209
13210
13211
13212
13213
13214
13215
13216
13217
13218
13219
13220
13221
13222
13223
13224
13225
13226
13227
13228
13229
13230
13231
13232
13233
13234
13235
13236
13237
13238
13239
13240
13241
13242
13243
13244
13245
13246
13247
13248
13249
13250
13251
13252
13253
13254
13255
13256
13257
13258
13259
13260
13261
13262
13263
13264
13265
13266
13267
13268
13269
13270
13271
13272
13273
13274
13275
13276
13277
13278
13279
13280
13281
13282
13283
13284
13285
13286
13287
13288
13289
13290
13291
13292
13293
13294
13295
13296
13297
13298
13299
13300
13301
13302
13303
13304
13305
13306
13307
13308
13309
13310
13311
13312
13313
13314
13315
13316
13317
13318
13319
13320
13321
13322
13323
13324
13325
13326
13327
13328
13329
13330
13331
13332
13333
13334
13335
13336
13337
13338
13339
13340
13341
13342
13343
13344
13345
13346
13347
13348
13349
13350
13351
13352
13353
13354
13355
13356
13357
13358
13359
13360
13361
13362
13363
13364
13365
13366
13367
13368
13369
13370
13371
13372
13373
13374
13375
13376
13377
13378
13379
13380
13381
13382
13383
13384
13385
13386
13387
13388
13389
13390
13391
13392
13393
13394
13395
13396
13397
13398
13399
13400
13401
13402
13403
13404
13405
13406
13407
13408
13409
13410
13411
13412
13413
13414
13415
13416
13417
13418
13419
13420
13421
13422
13423
13424
13425
13426
13427
13428
13429
13430
13431
13432
13433
13434
13435
13436
13437
13438
13439
13440
13441
13442
13443
13444
13445
13446
13447
13448
13449
13450
13451
13452
13453
13454
13455
13456
13457
13458
13459
13460
13461
13462
13463
13464
13465
13466
13467
13468
13469
13470
13471
13472
13473
13474
13475
13476
13477
13478
13479
13480
13481
13482
13483
13484
13485
13486
13487
13488
13489
13490
13491
13492
13493
13494
13495
13496
13497
13498
13499
13500
13501
13502
13503
13504
13505
13506
13507
13508
13509
13510
13511
13512
13513
13514
13515
13516
13517
13518
13519
13520
13521
13522
13523
13524
13525
13526
13527
13528
13529
13530
13531
13532
13533
13534
13535
13536
13537
13538
13539
13540
13541
13542
13543
13544
13545
13546
13547
13548
13549
13550
13551
13552
13553
13554
13555
13556
13557
13558
13559
13560
13561
13562
13563
13564
13565
13566
13567
13568
13569
13570
13571
13572
13573
13574
13575
13576
13577
13578
13579
13580
13581
13582
13583
13584
13585
13586
13587
13588
13589
13590
13591
13592
13593
13594
13595
13596
13597
13598
13599
13600
13601
13602
13603
13604
13605
13606
13607
13608
13609
13610
13611
13612
13613
13614
13615
13616
13617
13618
13619
13620
13621
13622
13623
13624
13625
13626
13627
13628
13629
13630
13631
13632
13633
13634
13635
13636
13637
13638
13639
13640
13641
13642
13643
13644
13645
13646
13647
13648
13649
13650
13651
13652
13653
13654
13655
13656
13657
13658
13659
13660
13661
13662
13663
13664
13665
13666
13667
13668
13669
13670
13671
13672
13673
13674
13675
13676
13677
13678
13679
13680
13681
13682
13683
13684
13685
13686
13687
13688
13689
13690
13691
13692
13693
13694
13695
13696
13697
13698
13699
13700
13701
13702
13703
13704
13705
13706
13707
13708
13709
13710
13711
13712
13713
13714
13715
13716
13717
13718
13719
13720
13721
13722
13723
13724
13725
13726
13727
13728
13729
13730
13731
13732
13733
13734
13735
13736
13737
13738
13739
13740
13741
13742
13743
13744
13745
13746
13747
13748
13749
13750
13751
13752
13753
13754
13755
13756
13757
13758
13759
13760
13761
13762
13763
13764
13765
13766
13767
13768
13769
13770
13771
13772
13773
13774
13775
13776
13777
13778
13779
13780
13781
13782
13783
13784
13785
13786
13787
13788
13789
13790
13791
13792
13793
13794
13795
13796
13797
13798
13799
13800
13801
13802
13803
13804
13805
13806
13807
13808
13809
13810
13811
13812
13813
13814
13815
13816
13817
13818
13819
13820
13821
13822
13823
13824
13825
13826
13827
13828
13829
13830
13831
13832
13833
13834
13835
13836
13837
13838
13839
13840
13841
13842
13843
13844
13845
13846
13847
13848
13849
13850
13851
13852
13853
13854
13855
13856
13857
13858
13859
13860
13861
13862
13863
13864
13865
13866
13867
13868
13869
13870
13871
13872
13873
13874
13875
13876
13877
13878
13879
13880
13881
13882
13883
13884
13885
13886
13887
13888
13889
13890
13891
13892
13893
13894
13895
13896
13897
13898
13899
13900
13901
13902
13903
13904
13905
13906
13907
13908
13909
13910
13911
13912
13913
13914
13915
13916
13917
13918
13919
13920
13921
13922
13923
13924
13925
13926
13927
13928
13929
13930
13931
13932
13933
13934
13935
13936
13937
13938
13939
13940
13941
13942
13943
13944
13945
13946
13947
13948
13949
13950
13951
13952
13953
13954
13955
13956
13957
13958
13959
13960
13961
13962
13963
13964
13965
13966
13967
13968
13969
13970
13971
13972
13973
13974
13975
13976
13977
13978
13979
13980
13981
13982
13983
13984
13985
13986
13987
13988
13989
13990
13991
13992
13993
13994
13995
13996
13997
13998
13999
14000
  KEY `mdl_statuserweek_tim_ix` (`timeend`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='To accumulate weekly stats per course/user';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_stats_user_weekly`
--

LOCK TABLES `mdl_stats_user_weekly` WRITE;
/*!40000 ALTER TABLE `mdl_stats_user_weekly` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_stats_user_weekly` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_stats_weekly`
--

DROP TABLE IF EXISTS `mdl_stats_weekly`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_stats_weekly` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT 0,
  `timeend` bigint(10) NOT NULL DEFAULT 0,
  `roleid` bigint(10) NOT NULL DEFAULT 0,
  `stattype` varchar(20) NOT NULL DEFAULT 'activity',
  `stat1` bigint(10) NOT NULL DEFAULT 0,
  `stat2` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_statweek_cou_ix` (`courseid`),
  KEY `mdl_statweek_tim_ix` (`timeend`),
  KEY `mdl_statweek_rol_ix` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='To accumulate weekly stats';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_stats_weekly`
--

LOCK TABLES `mdl_stats_weekly` WRITE;
/*!40000 ALTER TABLE `mdl_stats_weekly` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_stats_weekly` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_survey`
--

DROP TABLE IF EXISTS `mdl_survey`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_survey` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `template` bigint(10) NOT NULL DEFAULT 0,
  `days` mediumint(6) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `questions` varchar(255) NOT NULL DEFAULT '',
  `completionsubmit` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_surv_cou_ix` (`course`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each record is one SURVEY module with its configuration';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_survey`
--

LOCK TABLES `mdl_survey` WRITE;
/*!40000 ALTER TABLE `mdl_survey` DISABLE KEYS */;
INSERT INTO `mdl_survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `introformat`, `questions`, `completionsubmit`) VALUES (1,0,0,0,985017600,985017600,'collesaname','collesaintro',0,'25,26,27,28,29,30,43,44',0),(2,0,0,0,985017600,985017600,'collespname','collespintro',0,'31,32,33,34,35,36,43,44',0),(3,0,0,0,985017600,985017600,'collesapname','collesapintro',0,'37,38,39,40,41,42,43,44',0),(4,0,0,0,985017600,985017600,'attlsname','attlsintro',0,'65,67,68',0),(5,0,0,0,985017600,985017600,'ciqname','ciqintro',0,'69,70,71,72,73',0);
/*!40000 ALTER TABLE `mdl_survey` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_survey_analysis`
--

DROP TABLE IF EXISTS `mdl_survey_analysis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_survey_analysis` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `survey` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `notes` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_survanal_use_ix` (`userid`),
  KEY `mdl_survanal_sur_ix` (`survey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='text about each survey submission';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_survey_analysis`
--

LOCK TABLES `mdl_survey_analysis` WRITE;
/*!40000 ALTER TABLE `mdl_survey_analysis` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_survey_analysis` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_survey_answers`
--

DROP TABLE IF EXISTS `mdl_survey_answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_survey_answers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `survey` bigint(10) NOT NULL DEFAULT 0,
  `question` bigint(10) NOT NULL DEFAULT 0,
  `time` bigint(10) NOT NULL DEFAULT 0,
  `answer1` longtext NOT NULL,
  `answer2` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_survansw_use_ix` (`userid`),
  KEY `mdl_survansw_sur_ix` (`survey`),
  KEY `mdl_survansw_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='the answers to each questions filled by the users';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_survey_answers`
--

LOCK TABLES `mdl_survey_answers` WRITE;
/*!40000 ALTER TABLE `mdl_survey_answers` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_survey_answers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_survey_questions`
--

DROP TABLE IF EXISTS `mdl_survey_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_survey_questions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL DEFAULT '',
  `shorttext` varchar(30) NOT NULL DEFAULT '',
  `multi` varchar(100) NOT NULL DEFAULT '',
  `intro` varchar(50) NOT NULL DEFAULT '',
  `type` smallint(3) NOT NULL DEFAULT 0,
  `options` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='the questions conforming one survey';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_survey_questions`
--

LOCK TABLES `mdl_survey_questions` WRITE;
/*!40000 ALTER TABLE `mdl_survey_questions` DISABLE KEYS */;
INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) VALUES (1,'colles1','colles1short','','',1,'scaletimes5'),(2,'colles2','colles2short','','',1,'scaletimes5'),(3,'colles3','colles3short','','',1,'scaletimes5'),(4,'colles4','colles4short','','',1,'scaletimes5'),(5,'colles5','colles5short','','',1,'scaletimes5'),(6,'colles6','colles6short','','',1,'scaletimes5'),(7,'colles7','colles7short','','',1,'scaletimes5'),(8,'colles8','colles8short','','',1,'scaletimes5'),(9,'colles9','colles9short','','',1,'scaletimes5'),(10,'colles10','colles10short','','',1,'scaletimes5'),(11,'colles11','colles11short','','',1,'scaletimes5'),(12,'colles12','colles12short','','',1,'scaletimes5'),(13,'colles13','colles13short','','',1,'scaletimes5'),(14,'colles14','colles14short','','',1,'scaletimes5'),(15,'colles15','colles15short','','',1,'scaletimes5'),(16,'colles16','colles16short','','',1,'scaletimes5'),(17,'colles17','colles17short','','',1,'scaletimes5'),(18,'colles18','colles18short','','',1,'scaletimes5'),(19,'colles19','colles19short','','',1,'scaletimes5'),(20,'colles20','colles20short','','',1,'scaletimes5'),(21,'colles21','colles21short','','',1,'scaletimes5'),(22,'colles22','colles22short','','',1,'scaletimes5'),(23,'colles23','colles23short','','',1,'scaletimes5'),(24,'colles24','colles24short','','',1,'scaletimes5'),(25,'collesm1','collesm1short','1,2,3,4','collesmintro',1,'scaletimes5'),(26,'collesm2','collesm2short','5,6,7,8','collesmintro',1,'scaletimes5'),(27,'collesm3','collesm3short','9,10,11,12','collesmintro',1,'scaletimes5'),(28,'collesm4','collesm4short','13,14,15,16','collesmintro',1,'scaletimes5'),(29,'collesm5','collesm5short','17,18,19,20','collesmintro',1,'scaletimes5'),(30,'collesm6','collesm6short','21,22,23,24','collesmintro',1,'scaletimes5'),(31,'collesm1','collesm1short','1,2,3,4','collesmintro',2,'scaletimes5'),(32,'collesm2','collesm2short','5,6,7,8','collesmintro',2,'scaletimes5'),(33,'collesm3','collesm3short','9,10,11,12','collesmintro',2,'scaletimes5'),(34,'collesm4','collesm4short','13,14,15,16','collesmintro',2,'scaletimes5'),(35,'collesm5','collesm5short','17,18,19,20','collesmintro',2,'scaletimes5'),(36,'collesm6','collesm6short','21,22,23,24','collesmintro',2,'scaletimes5'),(37,'collesm1','collesm1short','1,2,3,4','collesmintro',3,'scaletimes5'),(38,'collesm2','collesm2short','5,6,7,8','collesmintro',3,'scaletimes5'),(39,'collesm3','collesm3short','9,10,11,12','collesmintro',3,'scaletimes5'),(40,'collesm4','collesm4short','13,14,15,16','collesmintro',3,'scaletimes5'),(41,'collesm5','collesm5short','17,18,19,20','collesmintro',3,'scaletimes5'),(42,'collesm6','collesm6short','21,22,23,24','collesmintro',3,'scaletimes5'),(43,'howlong','','','',1,'howlongoptions'),(44,'othercomments','','','',0,NULL),(45,'attls1','attls1short','','',1,'scaleagree5'),(46,'attls2','attls2short','','',1,'scaleagree5'),(47,'attls3','attls3short','','',1,'scaleagree5'),(48,'attls4','attls4short','','',1,'scaleagree5'),(49,'attls5','attls5short','','',1,'scaleagree5'),(50,'attls6','attls6short','','',1,'scaleagree5'),(51,'attls7','attls7short','','',1,'scaleagree5'),(52,'attls8','attls8short','','',1,'scaleagree5'),(53,'attls9','attls9short','','',1,'scaleagree5'),(54,'attls10','attls10short','','',1,'scaleagree5'),(55,'attls11','attls11short','','',1,'scaleagree5'),(56,'attls12','attls12short','','',1,'scaleagree5'),(57,'attls13','attls13short','','',1,'scaleagree5'),(58,'attls14','attls14short','','',1,'scaleagree5'),(59,'attls15','attls15short','','',1,'scaleagree5'),(60,'attls16','attls16short','','',1,'scaleagree5'),(61,'attls17','attls17short','','',1,'scaleagree5'),(62,'attls18','attls18short','','',1,'scaleagree5'),(63,'attls19','attls19short','','',1,'scaleagree5'),(64,'attls20','attls20short','','',1,'scaleagree5'),(65,'attlsm1','attlsm1','45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64','attlsmintro',1,'scaleagree5'),(66,'-','-','-','-',0,'-'),(67,'attlsm2','attlsm2','63,62,59,57,55,49,52,50,48,47','attlsmintro',-1,'scaleagree5'),(68,'attlsm3','attlsm3','46,54,45,51,60,53,56,58,61,64','attlsmintro',-1,'scaleagree5'),(69,'ciq1','ciq1short','','',0,NULL),(70,'ciq2','ciq2short','','',0,NULL),(71,'ciq3','ciq3short','','',0,NULL),(72,'ciq4','ciq4short','','',0,NULL),(73,'ciq5','ciq5short','','',0,NULL);
/*!40000 ALTER TABLE `mdl_survey_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tag`
--

DROP TABLE IF EXISTS `mdl_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tag` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `tagcollid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `rawname` varchar(255) NOT NULL DEFAULT '',
  `isstandard` tinyint(1) NOT NULL DEFAULT 0,
  `description` longtext DEFAULT NULL,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT 0,
  `flag` smallint(4) DEFAULT 0,
  `timemodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_tag_tagnam_uix` (`tagcollid`,`name`),
  KEY `mdl_tag_tagiss_ix` (`tagcollid`,`isstandard`),
  KEY `mdl_tag_use_ix` (`userid`),
  KEY `mdl_tag_tag_ix` (`tagcollid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Tag table - this generic table will replace the old "tags" t';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tag`
--

LOCK TABLES `mdl_tag` WRITE;
/*!40000 ALTER TABLE `mdl_tag` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tag` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tag_area`
--

DROP TABLE IF EXISTS `mdl_tag_area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tag_area` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(100) NOT NULL DEFAULT '',
  `itemtype` varchar(100) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `tagcollid` bigint(10) NOT NULL,
  `callback` varchar(100) DEFAULT NULL,
  `callbackfile` varchar(100) DEFAULT NULL,
  `showstandard` tinyint(1) NOT NULL DEFAULT 0,
  `multiplecontexts` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_tagarea_comite_uix` (`component`,`itemtype`),
  KEY `mdl_tagarea_tag_ix` (`tagcollid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines various tag areas, one area is identified by compone';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tag_area`
--

LOCK TABLES `mdl_tag_area` WRITE;
/*!40000 ALTER TABLE `mdl_tag_area` DISABLE KEYS */;
INSERT INTO `mdl_tag_area` (`id`, `component`, `itemtype`, `enabled`, `tagcollid`, `callback`, `callbackfile`, `showstandard`, `multiplecontexts`) VALUES (1,'core','user',1,1,'user_get_tagged_users','/user/lib.php',2,0),(2,'core','course',1,1,'course_get_tagged_courses','/course/lib.php',0,0),(3,'core_question','question',1,1,NULL,NULL,0,1),(4,'core','post',1,1,'blog_get_tagged_posts','/blog/lib.php',0,0),(5,'core','blog_external',1,1,NULL,NULL,0,0),(6,'core','course_modules',1,1,'course_get_tagged_course_modules','/course/lib.php',0,0),(7,'core_badges','badge',1,1,'badge_get_tagged_badges','/badges/lib.php',0,0),(8,'mod_book','book_chapters',1,1,'mod_book_get_tagged_chapters','/mod/book/locallib.php',0,0),(9,'mod_data','data_records',1,1,'mod_data_get_tagged_records','/mod/data/locallib.php',0,0),(10,'mod_forum','forum_posts',1,1,'mod_forum_get_tagged_posts','/mod/forum/locallib.php',0,0),(11,'mod_glossary','glossary_entries',1,1,'mod_glossary_get_tagged_entries','/mod/glossary/locallib.php',0,0),(12,'mod_wiki','wiki_pages',1,1,'mod_wiki_get_tagged_pages','/mod/wiki/locallib.php',0,0);
/*!40000 ALTER TABLE `mdl_tag_area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tag_coll`
--

DROP TABLE IF EXISTS `mdl_tag_coll`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tag_coll` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `isdefault` tinyint(2) NOT NULL DEFAULT 0,
  `component` varchar(100) DEFAULT NULL,
  `sortorder` mediumint(5) NOT NULL DEFAULT 0,
  `searchable` tinyint(2) NOT NULL DEFAULT 1,
  `customurl` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines different set of tags';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tag_coll`
--

LOCK TABLES `mdl_tag_coll` WRITE;
/*!40000 ALTER TABLE `mdl_tag_coll` DISABLE KEYS */;
INSERT INTO `mdl_tag_coll` (`id`, `name`, `isdefault`, `component`, `sortorder`, `searchable`, `customurl`) VALUES (1,NULL,1,NULL,0,1,NULL);
/*!40000 ALTER TABLE `mdl_tag_coll` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tag_correlation`
--

DROP TABLE IF EXISTS `mdl_tag_correlation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tag_correlation` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `tagid` bigint(10) NOT NULL,
  `correlatedtags` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_tagcorr_tag_ix` (`tagid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The rationale for the ''tag_correlation'' table is performance';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tag_correlation`
--

LOCK TABLES `mdl_tag_correlation` WRITE;
/*!40000 ALTER TABLE `mdl_tag_correlation` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tag_correlation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tag_instance`
--

DROP TABLE IF EXISTS `mdl_tag_instance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tag_instance` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `tagid` bigint(10) NOT NULL,
  `component` varchar(100) NOT NULL DEFAULT '',
  `itemtype` varchar(100) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `tiuserid` bigint(10) NOT NULL DEFAULT 0,
  `ordering` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_taginst_comiteiteconti_uix` (`component`,`itemtype`,`itemid`,`contextid`,`tiuserid`,`tagid`),
  KEY `mdl_taginst_itecomtagcon_ix` (`itemtype`,`component`,`tagid`,`contextid`),
  KEY `mdl_taginst_tag_ix` (`tagid`),
  KEY `mdl_taginst_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='tag_instance table holds the information of associations bet';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tag_instance`
--

LOCK TABLES `mdl_tag_instance` WRITE;
/*!40000 ALTER TABLE `mdl_tag_instance` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tag_instance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_task_adhoc`
--

DROP TABLE IF EXISTS `mdl_task_adhoc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_task_adhoc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(255) NOT NULL DEFAULT '',
  `classname` varchar(255) NOT NULL DEFAULT '',
  `nextruntime` bigint(10) NOT NULL,
  `faildelay` bigint(10) DEFAULT NULL,
  `customdata` longtext DEFAULT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `blocking` tinyint(2) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timestarted` bigint(10) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `pid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_taskadho_nex_ix` (`nextruntime`),
  KEY `mdl_taskadho_tim_ix` (`timestarted`),
  KEY `mdl_taskadho_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of adhoc tasks waiting to run.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_task_adhoc`
--

LOCK TABLES `mdl_task_adhoc` WRITE;
/*!40000 ALTER TABLE `mdl_task_adhoc` DISABLE KEYS */;
INSERT INTO `mdl_task_adhoc` (`id`, `component`, `classname`, `nextruntime`, `faildelay`, `customdata`, `userid`, `blocking`, `timecreated`, `timestarted`, `hostname`, `pid`) VALUES (1,'tool_moodlenet','\\tool_moodlenet\\task\\post_install',1722414935,0,'',NULL,0,1722414936,NULL,NULL,NULL),(2,'','\\core\\task\\build_installed_themes_task',1722414959,0,'',NULL,0,1722414960,NULL,NULL,NULL),(3,'quiz_statistics','\\quiz_statistics\\task\\recalculate',1722419961,0,'{\"quizid\":1}',NULL,0,1722416361,NULL,NULL,NULL);
/*!40000 ALTER TABLE `mdl_task_adhoc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_task_log`
--

DROP TABLE IF EXISTS `mdl_task_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_task_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` smallint(4) NOT NULL,
  `component` varchar(255) NOT NULL DEFAULT '',
  `classname` varchar(255) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `timestart` decimal(20,10) NOT NULL,
  `timeend` decimal(20,10) NOT NULL,
  `dbreads` bigint(10) NOT NULL,
  `dbwrites` bigint(10) NOT NULL,
  `result` tinyint(2) NOT NULL,
  `output` longtext NOT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `pid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_tasklog_cla_ix` (`classname`),
  KEY `mdl_tasklog_tim_ix` (`timestart`),
  KEY `mdl_tasklog_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The log table for all tasks';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_task_log`
--

LOCK TABLES `mdl_task_log` WRITE;
/*!40000 ALTER TABLE `mdl_task_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_task_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_task_scheduled`
--

DROP TABLE IF EXISTS `mdl_task_scheduled`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_task_scheduled` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(255) NOT NULL DEFAULT '',
  `classname` varchar(255) NOT NULL DEFAULT '',
  `lastruntime` bigint(10) DEFAULT NULL,
  `nextruntime` bigint(10) DEFAULT NULL,
  `blocking` tinyint(2) NOT NULL DEFAULT 0,
  `minute` varchar(200) NOT NULL DEFAULT '',
  `hour` varchar(70) NOT NULL DEFAULT '',
  `day` varchar(90) NOT NULL DEFAULT '',
  `month` varchar(30) NOT NULL DEFAULT '',
  `dayofweek` varchar(25) NOT NULL DEFAULT '',
  `faildelay` bigint(10) DEFAULT NULL,
  `customised` tinyint(2) NOT NULL DEFAULT 0,
  `disabled` tinyint(1) NOT NULL DEFAULT 0,
  `timestarted` bigint(10) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `pid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_tasksche_cla_uix` (`classname`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of scheduled tasks to be run by cron.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_task_scheduled`
--

LOCK TABLES `mdl_task_scheduled` WRITE;
/*!40000 ALTER TABLE `mdl_task_scheduled` DISABLE KEYS */;
INSERT INTO `mdl_task_scheduled` (`id`, `component`, `classname`, `lastruntime`, `nextruntime`, `blocking`, `minute`, `hour`, `day`, `month`, `dayofweek`, `faildelay`, `customised`, `disabled`, `timestarted`, `hostname`, `pid`) VALUES (1,'moodle','\\core\\task\\session_cleanup_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(2,'moodle','\\core\\task\\delete_unconfirmed_users_task',0,1722416400,0,'0','*','*','*','*',0,0,0,NULL,NULL,NULL),(3,'moodle','\\core\\task\\delete_incomplete_users_task',0,1722416700,0,'5','*','*','*','*',0,0,0,NULL,NULL,NULL),(4,'moodle','\\core\\task\\backup_cleanup_task',0,1722417000,0,'10','*','*','*','*',0,0,0,NULL,NULL,NULL),(5,'moodle','\\core\\task\\tag_cron_task',0,1722484560,0,'56','3','*','*','*',0,0,0,NULL,NULL,NULL),(6,'moodle','\\core\\task\\context_cleanup_task',0,1722417900,0,'25','*','*','*','*',0,0,0,NULL,NULL,NULL),(7,'moodle','\\core\\task\\cache_cleanup_task',0,1722418200,0,'30','*','*','*','*',0,0,0,NULL,NULL,NULL),(8,'moodle','\\core\\task\\messaging_cleanup_task',0,1722418500,0,'35','*','*','*','*',0,0,0,NULL,NULL,NULL),(9,'moodle','\\core\\task\\send_new_user_passwords_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(10,'moodle','\\core\\task\\send_failed_login_notifications_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(11,'moodle','\\core\\task\\create_contexts_task',0,1722470400,1,'0','0','*','*','*',0,0,0,NULL,NULL,NULL),(12,'moodle','\\core\\task\\grade_cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(13,'moodle','\\core\\task\\grade_history_cleanup_task',0,1722470400,0,'*','0','*','*','*',0,0,0,NULL,NULL,NULL),(14,'moodle','\\core\\task\\completion_regular_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(15,'moodle','\\core\\task\\completion_daily_task',0,1722484140,0,'49','3','*','*','*',0,0,0,NULL,NULL,NULL),(16,'moodle','\\core\\task\\portfolio_cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(17,'moodle','\\core\\task\\plagiarism_cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(18,'moodle','\\core\\task\\calendar_cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(19,'moodle','\\core\\task\\blog_cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(20,'moodle','\\core\\task\\question_preview_cleanup_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(21,'moodle','\\core\\task\\registration_cron_task',0,1722625020,0,'57','18','*','*','5',0,0,0,NULL,NULL,NULL),(22,'moodle','\\core\\task\\check_for_updates_task',0,1722422040,0,'34','10','*','*','*',0,0,0,NULL,NULL,NULL),(23,'moodle','\\core\\task\\cache_cron_task',0,1722415800,0,'50','*','*','*','*',0,0,0,NULL,NULL,NULL),(24,'moodle','\\core\\task\\automated_backup_task',0,1722415800,0,'50','*','*','*','*',0,0,0,NULL,NULL,NULL),(25,'moodle','\\core\\task\\badges_cron_task',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(26,'moodle','\\core\\task\\badges_message_task',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(27,'moodle','\\core\\task\\file_temp_cleanup_task',0,1722430500,0,'55','*/6','*','*','*',0,0,0,NULL,NULL,NULL),(28,'moodle','\\core\\task\\file_trash_cleanup_task',0,1722430500,0,'55','*/6','*','*','*',0,0,0,NULL,NULL,NULL),(29,'moodle','\\core\\task\\search_index_task',0,1722416400,0,'*/30','*','*','*','*',0,0,0,NULL,NULL,NULL),(30,'moodle','\\core\\task\\search_optimize_task',0,1722428100,0,'15','*/12','*','*','*',0,0,0,NULL,NULL,NULL),(31,'moodle','\\core\\task\\stats_cron_task',0,1722470400,0,'0','0','*','*','*',0,0,0,NULL,NULL,NULL),(32,'moodle','\\core\\task\\password_reset_cleanup_task',0,1722427200,0,'0','*/6','*','*','*',0,0,0,NULL,NULL,NULL),(33,'moodle','\\core\\task\\complete_plans_task',0,1722415260,0,'41','*','*','*','*',0,0,0,NULL,NULL,NULL),(34,'moodle','\\core\\task\\sync_plans_from_template_cohorts_task',0,1722417240,0,'14','*','*','*','*',0,0,0,NULL,NULL,NULL),(35,'moodle','\\core_files\\task\\conversion_cleanup_task',0,1722479940,0,'39','2','*','*','*',0,0,0,NULL,NULL,NULL),(36,'moodle','\\core\\oauth2\\refresh_system_tokens_task',0,1722418200,0,'30','*','*','*','*',0,0,0,NULL,NULL,NULL),(37,'moodle','\\core\\task\\analytics_cleanup_task',0,1722415320,0,'42','*','*','*','*',0,0,0,NULL,NULL,NULL),(38,'moodle','\\core\\task\\task_log_cleanup_task',0,1722429360,0,'36','12','*','*','*',0,0,0,NULL,NULL,NULL),(39,'moodle','\\core\\task\\h5p_get_content_types_task',0,1722552480,0,'48','22','1','*','*',0,0,0,NULL,NULL,NULL),(40,'moodle','\\core\\task\\h5p_clean_orphaned_records_task',0,1722473040,0,'44','0','*','*','*',0,0,0,NULL,NULL,NULL),(41,'moodle','\\core\\task\\antivirus_cleanup_task',0,1722471780,0,'23','0','*','*','*',0,0,0,NULL,NULL,NULL),(42,'moodle','\\core_reportbuilder\\task\\send_schedules',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(43,'moodle','\\core\\task\\task_lock_cleanup_task',0,1722471960,0,'26','0','*','*','*',0,0,0,NULL,NULL,NULL),(44,'moodle','\\core_xapi\\task\\state_cleanup_task',0,1722473160,0,'46','0','*','*','*',0,0,0,NULL,NULL,NULL),(45,'moodle','\\core\\task\\show_started_courses_task',0,1722474000,0,'00','01','*','*','*',0,0,1,NULL,NULL,NULL),(46,'moodle','\\core\\task\\hide_ended_courses_task',0,1722474000,0,'00','01','*','*','*',0,0,1,NULL,NULL,NULL),(47,'moodle','\\core\\task\\automated_backup_report_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(48,'mod_assign','\\mod_assign\\task\\cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(49,'mod_bigbluebuttonbn','\\mod_bigbluebuttonbn\\task\\check_pending_recordings',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(50,'mod_bigbluebuttonbn','\\mod_bigbluebuttonbn\\task\\check_dismissed_recordings',0,1722414960,0,'*','*','*/10','*','*',0,0,0,NULL,NULL,NULL),(51,'mod_chat','\\mod_chat\\task\\cron_task',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(52,'mod_forum','\\mod_forum\\task\\cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(53,'mod_lti','\\mod_lti\\task\\clean_access_tokens',0,1722455820,0,'57','20','*','*','*',0,0,0,NULL,NULL,NULL),(54,'mod_quiz','\\mod_quiz\\task\\update_overdue_attempts',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(55,'mod_quiz','\\mod_quiz\\task\\quiz_notify_attempt_manual_grading_completed',0,1722416820,0,'7','*','*','*','*',0,0,0,NULL,NULL,NULL),(56,'mod_scorm','\\mod_scorm\\task\\cron_task',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(57,'mod_workshop','\\mod_workshop\\task\\cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(58,'auth_cas','\\auth_cas\\task\\sync_task',0,1722466800,0,'0','0','*','*','*',0,0,1,NULL,NULL,NULL),(59,'auth_db','\\auth_db\\task\\sync_users',0,1722435240,0,'14','15','*','*','*',0,0,1,NULL,NULL,NULL),(60,'auth_ldap','\\auth_ldap\\task\\sync_roles',0,1722466800,0,'0','0','*','*','*',0,0,1,NULL,NULL,NULL),(61,'auth_ldap','\\auth_ldap\\task\\sync_task',0,1722466800,0,'0','0','*','*','*',0,0,1,NULL,NULL,NULL),(62,'auth_mnet','\\auth_mnet\\task\\cron_task',0,1722415200,0,'*/10','*','*','*','*',0,0,0,NULL,NULL,NULL),(63,'enrol_category','\\enrol_category\\task\\enrol_category_sync',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(64,'enrol_cohort','\\enrol_cohort\\task\\enrol_cohort_sync',0,1722418500,0,'35','*','*','*','*',0,0,0,NULL,NULL,NULL),(65,'enrol_database','\\enrol_database\\task\\sync_enrolments',0,1722449340,0,'9','19','*','*','*',0,0,1,NULL,NULL,NULL),(66,'enrol_flatfile','\\enrol_flatfile\\task\\flatfile_sync_task',0,1722417300,0,'15','*','*','*','*',0,0,0,NULL,NULL,NULL),(67,'enrol_imsenterprise','\\enrol_imsenterprise\\task\\cron_task',0,1722417000,0,'10','*','*','*','*',0,0,0,NULL,NULL,NULL),(68,'enrol_ldap','\\enrol_ldap\\task\\sync_enrolments',0,1722482220,0,'17','4','*','*','*',0,0,1,NULL,NULL,NULL),(69,'enrol_lti','\\enrol_lti\\task\\sync_grades',0,1722416400,0,'*/30','*','*','*','*',0,0,0,NULL,NULL,NULL),(70,'enrol_lti','\\enrol_lti\\task\\sync_members',0,1722416400,0,'*/30','*','*','*','*',0,0,0,NULL,NULL,NULL),(71,'enrol_lti','\\enrol_lti\\local\\ltiadvantage\\task\\sync_members',0,1722416400,0,'*/30','*','*','*','*',0,0,0,NULL,NULL,NULL),(72,'enrol_lti','\\enrol_lti\\local\\ltiadvantage\\task\\sync_grades',0,1722416400,0,'*/30','*','*','*','*',0,0,0,NULL,NULL,NULL),(73,'enrol_manual','\\enrol_manual\\task\\sync_enrolments',0,1722415200,0,'*/10','*','*','*','*',0,0,0,NULL,NULL,NULL),(74,'enrol_manual','\\enrol_manual\\task\\send_expiry_notifications',0,1722415200,0,'*/10','*','*','*','*',0,0,0,NULL,NULL,NULL),(75,'enrol_meta','\\enrol_meta\\task\\enrol_meta_sync',0,1722416700,0,'5','*','*','*','*',0,0,0,NULL,NULL,NULL),(76,'enrol_paypal','\\enrol_paypal\\task\\process_expirations',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(77,'enrol_self','\\enrol_self\\task\\sync_enrolments',0,1722415200,0,'*/10','*','*','*','*',0,0,0,NULL,NULL,NULL),(78,'enrol_self','\\enrol_self\\task\\send_expiry_notifications',0,1722415200,0,'*/10','*','*','*','*',0,0,0,NULL,NULL,NULL),(79,'message_email','\\message_email\\task\\send_email_task',0,1722459600,0,'0','22','*','*','*',0,0,0,NULL,NULL,NULL),(80,'block_recent_activity','\\block_recent_activity\\task\\cleanup',0,1722490740,0,'39','6','*','*','*',0,0,0,NULL,NULL,NULL),(81,'block_rss_client','\\block_rss_client\\task\\refreshfeeds',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(82,'editor_atto','\\editor_atto\\task\\autosave_cleanup_task',0,1722623820,0,'37','19','*','*','5',0,0,0,NULL,NULL,NULL),(83,'repository_dropbox','\\repository_dropbox\\task\\cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(84,'repository_filesystem','\\repository_filesystem\\task\\cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(85,'repository_onedrive','\\repository_onedrive\\remove_temp_access_task',0,1722560940,0,'9','2','*','*','5',0,0,0,NULL,NULL,NULL),(86,'tool_analytics','\\tool_analytics\\task\\train_models',0,1722438000,0,'0','16','*','*','*',0,0,0,NULL,NULL,NULL),(87,'tool_analytics','\\tool_analytics\\task\\predict_models',0,1722448800,0,'0','19','*','*','*',0,0,0,NULL,NULL,NULL),(88,'tool_brickfield','\\tool_brickfield\\task\\bulk_process_courses',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(89,'tool_brickfield','\\tool_brickfield\\task\\bulk_process_caches',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(90,'tool_brickfield','\\tool_brickfield\\task\\checkid_validation',0,1722499500,0,'05','9','*','*','*',0,0,0,NULL,NULL,NULL),(91,'tool_brickfield','\\tool_brickfield\\task\\update_summarydata',0,1722469800,0,'50','0','*','*','*',0,0,0,NULL,NULL,NULL),(92,'tool_brickfield','\\tool_brickfield\\task\\process_analysis_requests',0,1722415200,0,'*/5','*','*','*','*',0,0,0,NULL,NULL,NULL),(93,'tool_cohortroles','\\tool_cohortroles\\task\\cohort_role_sync',0,1722415800,0,'50','*','*','*','*',0,0,0,NULL,NULL,NULL),(94,'tool_dataprivacy','\\tool_dataprivacy\\task\\expired_retention_period',0,1722416400,0,'0','10','*','*','*',0,0,0,NULL,NULL,NULL),(95,'tool_dataprivacy','\\tool_dataprivacy\\task\\delete_expired_contexts',0,1722420000,0,'0','11','*','*','*',0,0,0,NULL,NULL,NULL),(96,'tool_dataprivacy','\\tool_dataprivacy\\task\\delete_expired_requests',0,1722425580,0,'33','12','*','*','*',0,0,0,NULL,NULL,NULL),(97,'tool_dataprivacy','\\tool_dataprivacy\\task\\delete_existing_deleted_users',0,1722459240,0,'54','21','*','*','*',0,0,1,NULL,NULL,NULL),(98,'tool_langimport','\\tool_langimport\\task\\update_langpacks_task',0,1722483120,0,'32','4','*','*','*',0,0,0,NULL,NULL,NULL),(99,'tool_messageinbound','\\tool_messageinbound\\task\\pickup_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(100,'tool_messageinbound','\\tool_messageinbound\\task\\cleanup_task',0,1722473700,0,'55','1','*','*','*',0,0,0,NULL,NULL,NULL),(101,'tool_monitor','\\tool_monitor\\task\\clean_events',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(102,'tool_monitor','\\tool_monitor\\task\\check_subscriptions',0,1722481320,0,'2','4','*','*','*',0,0,0,NULL,NULL,NULL),(103,'tool_recyclebin','\\tool_recyclebin\\task\\cleanup_course_bin',0,1722416400,0,'*/30','*','*','*','*',0,0,0,NULL,NULL,NULL),(104,'tool_recyclebin','\\tool_recyclebin\\task\\cleanup_category_bin',0,1722416400,0,'*/30','*','*','*','*',0,0,0,NULL,NULL,NULL),(105,'cachestore_redis','\\cachestore_redis\\task\\ttl',0,1722416400,0,'0','*','*','*','*',0,0,0,NULL,NULL,NULL),(106,'ltiservice_gradebookservices','\\ltiservice_gradebookservices\\task\\cleanup_task',0,1722429900,0,'45','13','*','*','*',0,0,0,NULL,NULL,NULL),(107,'workshopallocation_scheduled','\\workshopallocation_scheduled\\task\\cron_task',0,1722414960,0,'*','*','*','*','*',0,0,0,NULL,NULL,NULL),(108,'logstore_standard','\\logstore_standard\\task\\cleanup_task',0,1722483060,0,'31','4','*','*','*',0,0,0,NULL,NULL,NULL),(109,'factor_grace','\\factor_grace\\task\\revoke_expired_factors',0,1722469800,0,'50','0','*','*','*',0,0,0,NULL,NULL,NULL),(110,'factor_nosetup','\\factor_nosetup\\task\\delete_unusable_factors',0,1722467940,0,'19','0','*','*','*',0,0,0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `mdl_task_scheduled` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tiny_autosave`
--

DROP TABLE IF EXISTS `mdl_tiny_autosave`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tiny_autosave` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `elementid` varchar(255) NOT NULL DEFAULT '',
  `contextid` bigint(10) NOT NULL,
  `pagehash` varchar(64) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `drafttext` longtext NOT NULL,
  `draftid` bigint(10) DEFAULT NULL,
  `pageinstance` varchar(64) NOT NULL DEFAULT '',
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_tinyauto_eleconusepag_uix` (`elementid`,`contextid`,`userid`,`pagehash`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The content of the textarea saved during autosave operations';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tiny_autosave`
--

LOCK TABLES `mdl_tiny_autosave` WRITE;
/*!40000 ALTER TABLE `mdl_tiny_autosave` DISABLE KEYS */;
INSERT INTO `mdl_tiny_autosave` (`id`, `elementid`, `contextid`, `pagehash`, `userid`, `drafttext`, `draftid`, `pageinstance`, `timemodified`) VALUES (5,'q1:1_answer_id',15,'',2,'',NULL,'',1722416016),(8,'id_description_editor',19,'e37962c6e1c9d35e29aa6cb6076afe8e6e74568c',2,'',506458002,'76199ff06235abe80df2ca4cd33143f9',1722416174);
/*!40000 ALTER TABLE `mdl_tiny_autosave` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_areas`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_areas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_areas` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) NOT NULL DEFAULT 0,
  `contextid` bigint(10) DEFAULT NULL,
  `component` varchar(100) DEFAULT NULL,
  `tablename` varchar(40) DEFAULT NULL,
  `fieldorarea` varchar(50) DEFAULT NULL,
  `itemid` bigint(10) DEFAULT NULL,
  `filename` varchar(1333) DEFAULT NULL,
  `reftable` varchar(40) DEFAULT NULL,
  `refid` bigint(10) DEFAULT NULL,
  `cmid` bigint(10) DEFAULT NULL,
  `courseid` bigint(10) DEFAULT NULL,
  `categoryid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbricarea_coucmi_ix` (`courseid`,`cmid`),
  KEY `mdl_toolbricarea_typtabitef_ix` (`type`,`tablename`,`itemid`,`fieldorarea`),
  KEY `mdl_toolbricarea_typconcomf_ix` (`type`,`contextid`,`component`,`fieldorarea`,`itemid`),
  KEY `mdl_toolbricarea_refreftyp_ix` (`reftable`,`refid`,`type`),
  KEY `mdl_toolbricarea_cou_ix` (`courseid`),
  KEY `mdl_toolbricarea_cmi_ix` (`cmid`),
  KEY `mdl_toolbricarea_cat_ix` (`categoryid`),
  KEY `mdl_toolbricarea_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Areas that have been checked for accessibility problems';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_areas`
--

LOCK TABLES `mdl_tool_brickfield_areas` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_areas` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_areas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_cache_acts`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_cache_acts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_cache_acts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `component` varchar(64) DEFAULT NULL,
  `totalactivities` bigint(10) DEFAULT NULL,
  `failedactivities` bigint(10) DEFAULT NULL,
  `passedactivities` bigint(10) DEFAULT NULL,
  `errorcount` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbriccachacts_sta_ix` (`status`),
  KEY `mdl_toolbriccachacts_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Contains accessibility summary information per activity.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_cache_acts`
--

LOCK TABLES `mdl_tool_brickfield_cache_acts` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_cache_acts` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_cache_acts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_cache_check`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_cache_check`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_cache_check` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `checkid` bigint(10) DEFAULT NULL,
  `checkcount` bigint(10) DEFAULT NULL,
  `errorcount` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbriccachchec_sta_ix` (`status`),
  KEY `mdl_toolbriccachchec_err_ix` (`errorcount`),
  KEY `mdl_toolbriccachchec_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Contains accessibility summary information per check.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_cache_check`
--

LOCK TABLES `mdl_tool_brickfield_cache_check` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_cache_check` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_cache_check` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_checks`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_checks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_checks` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `checktype` varchar(64) DEFAULT NULL,
  `shortname` varchar(64) DEFAULT NULL,
  `checkgroup` bigint(16) DEFAULT 0,
  `status` smallint(4) NOT NULL,
  `severity` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbricchec_che_ix` (`checktype`),
  KEY `mdl_toolbricchec_che2_ix` (`checkgroup`),
  KEY `mdl_toolbricchec_sta_ix` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Checks details';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_checks`
--

LOCK TABLES `mdl_tool_brickfield_checks` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_checks` DISABLE KEYS */;
INSERT INTO `mdl_tool_brickfield_checks` (`id`, `checktype`, `shortname`, `checkgroup`, `status`, `severity`) VALUES (1,'full','a_links_dont_open_new_window',4,1,1),(2,'full','a_must_contain_text',4,1,1),(3,'full','area_dont_open_new_window',4,1,1),(4,'full','area_has_alt_value',4,1,1),(5,'full','a_suspicious_link_text',4,1,1),(6,'full','basefont_is_not_used',7,1,1),(7,'full','blink_is_not_used',7,1,1),(8,'full','bold_is_not_used',7,1,1),(9,'full','content_too_long',7,1,1),(10,'full','css_text_has_contrast',7,1,1),(11,'full','embed_has_associated_no_embed',7,1,1),(12,'full','header_h3',3,1,1),(13,'full','headers_have_text',3,1,1),(14,'full','i_is_not_used',7,1,1),(15,'full','img_alt_is_different',2,1,1),(16,'full','img_alt_is_too_long',2,1,1),(17,'full','img_alt_not_empty_in_anchor',2,1,1),(18,'full','img_alt_not_place_holder',2,1,1),(19,'full','img_has_alt',2,1,1),(20,'full','img_with_map_has_use_map',2,1,1),(21,'full','legend_text_not_empty',7,1,1),(22,'full','marquee_is_not_used',7,1,1),(23,'full','no_headings',3,1,1),(24,'full','object_must_have_embed',5,1,1),(25,'full','object_must_have_title',5,1,1),(26,'full','object_must_have_valid_title',5,1,1),(27,'full','strike_is_not_used',7,1,1),(28,'full','table_data_should_have_th',6,1,1),(29,'full','table_summary_does_not_duplicate_caption',6,1,1),(30,'full','table_td_should_not_merge',6,1,1),(31,'full','table_th_should_have_scope',6,1,1);
/*!40000 ALTER TABLE `mdl_tool_brickfield_checks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_content`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_content` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `areaid` bigint(10) NOT NULL,
  `contenthash` varchar(40) NOT NULL DEFAULT '',
  `iscurrent` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(2) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL,
  `timechecked` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbriccont_sta_ix` (`status`),
  KEY `mdl_toolbriccont_iscare_ix` (`iscurrent`,`areaid`),
  KEY `mdl_toolbriccont_are_ix` (`areaid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Content of an area at a particular time (recognised by a has';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_content`
--

LOCK TABLES `mdl_tool_brickfield_content` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_content` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_errors`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_errors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_errors` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `resultid` bigint(10) NOT NULL,
  `linenumber` bigint(10) NOT NULL DEFAULT 0,
  `errordata` longtext DEFAULT NULL,
  `htmlcode` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbricerro_res_ix` (`resultid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Errors during the accessibility checks';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_errors`
--

LOCK TABLES `mdl_tool_brickfield_errors` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_errors` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_errors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_process`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_process`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_process` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `item` varchar(64) DEFAULT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `innercontextid` bigint(10) DEFAULT NULL,
  `timecreated` bigint(16) DEFAULT NULL,
  `timecompleted` bigint(16) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbricproc_tim_ix` (`timecompleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Queued records to initiate new processing of specific target';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_process`
--

LOCK TABLES `mdl_tool_brickfield_process` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_process` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_process` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_results`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_results`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_results` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contentid` bigint(10) DEFAULT NULL,
  `checkid` bigint(10) NOT NULL,
  `errorcount` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbricresu_conche_ix` (`contentid`,`checkid`),
  KEY `mdl_toolbricresu_con_ix` (`contentid`),
  KEY `mdl_toolbricresu_che_ix` (`checkid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Results of the accessibility checks';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_results`
--

LOCK TABLES `mdl_tool_brickfield_results` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_results` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_results` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_schedule`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_schedule` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextlevel` bigint(10) NOT NULL DEFAULT 50,
  `instanceid` bigint(10) NOT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `status` tinyint(2) NOT NULL DEFAULT 0,
  `timeanalyzed` bigint(10) DEFAULT 0,
  `timemodified` bigint(10) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_toolbricsche_conins_uix` (`contextlevel`,`instanceid`),
  KEY `mdl_toolbricsche_sta_ix` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Keeps the per course content analysis schedule.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_schedule`
--

LOCK TABLES `mdl_tool_brickfield_schedule` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_schedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_brickfield_summary`
--

DROP TABLE IF EXISTS `mdl_tool_brickfield_summary`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_brickfield_summary` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `activities` bigint(10) DEFAULT NULL,
  `activitiespassed` bigint(10) DEFAULT NULL,
  `activitiesfailed` bigint(10) DEFAULT NULL,
  `errorschecktype1` bigint(10) DEFAULT NULL,
  `errorschecktype2` bigint(10) DEFAULT NULL,
  `errorschecktype3` bigint(10) DEFAULT NULL,
  `errorschecktype4` bigint(10) DEFAULT NULL,
  `errorschecktype5` bigint(10) DEFAULT NULL,
  `errorschecktype6` bigint(10) DEFAULT NULL,
  `errorschecktype7` bigint(10) DEFAULT NULL,
  `failedchecktype1` bigint(10) DEFAULT NULL,
  `failedchecktype2` bigint(10) DEFAULT NULL,
  `failedchecktype3` bigint(10) DEFAULT NULL,
  `failedchecktype4` bigint(10) DEFAULT NULL,
  `failedchecktype5` bigint(10) DEFAULT NULL,
  `failedchecktype6` bigint(10) DEFAULT NULL,
  `failedchecktype7` bigint(10) DEFAULT NULL,
  `percentchecktype1` bigint(10) DEFAULT NULL,
  `percentchecktype2` bigint(10) DEFAULT NULL,
  `percentchecktype3` bigint(10) DEFAULT NULL,
  `percentchecktype4` bigint(10) DEFAULT NULL,
  `percentchecktype5` bigint(10) DEFAULT NULL,
  `percentchecktype6` bigint(10) DEFAULT NULL,
  `percentchecktype7` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_toolbricsumm_sta_ix` (`status`),
  KEY `mdl_toolbricsumm_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Contains accessibility check results summary information.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_brickfield_summary`
--

LOCK TABLES `mdl_tool_brickfield_summary` WRITE;
/*!40000 ALTER TABLE `mdl_tool_brickfield_summary` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_brickfield_summary` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_cohortroles`
--

DROP TABLE IF EXISTS `mdl_tool_cohortroles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_cohortroles` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `cohortid` bigint(10) NOT NULL,
  `roleid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_toolcoho_cohroluse_uix` (`cohortid`,`roleid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Mapping of users to cohort role assignments.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_cohortroles`
--

LOCK TABLES `mdl_tool_cohortroles` WRITE;
/*!40000 ALTER TABLE `mdl_tool_cohortroles` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_cohortroles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_customlang`
--

DROP TABLE IF EXISTS `mdl_tool_customlang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_customlang` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lang` varchar(20) NOT NULL DEFAULT '',
  `componentid` bigint(10) NOT NULL,
  `stringid` varchar(255) NOT NULL DEFAULT '',
  `original` longtext NOT NULL,
  `master` longtext DEFAULT NULL,
  `local` longtext DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL,
  `timecustomized` bigint(10) DEFAULT NULL,
  `outdated` smallint(3) DEFAULT 0,
  `modified` smallint(3) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_toolcust_lancomstr_uix` (`lang`,`componentid`,`stringid`),
  KEY `mdl_toolcust_com_ix` (`componentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Contains the working checkout of all strings and their custo';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_customlang`
--

LOCK TABLES `mdl_tool_customlang` WRITE;
/*!40000 ALTER TABLE `mdl_tool_customlang` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_customlang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_customlang_components`
--

DROP TABLE IF EXISTS `mdl_tool_customlang_components`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_customlang_components` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Contains the list of all installed plugins that provide thei';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_customlang_components`
--

LOCK TABLES `mdl_tool_customlang_components` WRITE;
/*!40000 ALTER TABLE `mdl_tool_customlang_components` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_customlang_components` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_dataprivacy_category`
--

DROP TABLE IF EXISTS `mdl_tool_dataprivacy_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_dataprivacy_category` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `descriptionformat` tinyint(1) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Data categories';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_dataprivacy_category`
--

LOCK TABLES `mdl_tool_dataprivacy_category` WRITE;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_category` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_dataprivacy_contextlist`
--

DROP TABLE IF EXISTS `mdl_tool_dataprivacy_contextlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_dataprivacy_contextlist` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of contexts for a component';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_dataprivacy_contextlist`
--

LOCK TABLES `mdl_tool_dataprivacy_contextlist` WRITE;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_contextlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_contextlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_dataprivacy_ctxexpired`
--

DROP TABLE IF EXISTS `mdl_tool_dataprivacy_ctxexpired`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_dataprivacy_ctxexpired` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `unexpiredroles` longtext DEFAULT NULL,
  `expiredroles` longtext DEFAULT NULL,
  `defaultexpired` tinyint(1) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_tooldatactxe_con_uix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Default comment for the table, please edit me';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_dataprivacy_ctxexpired`
--

LOCK TABLES `mdl_tool_dataprivacy_ctxexpired` WRITE;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_ctxexpired` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_ctxexpired` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_tool_dataprivacy_ctxinstance`
--

DROP TABLE IF EXISTS `mdl_tool_dataprivacy_ctxinstance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_tool_dataprivacy_ctxinstance` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `purposeid` bigint(10) DEFAULT NULL,
  `categoryid` bigint(10) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_tooldatactxi_con_uix` (`contextid`),
  KEY `mdl_tooldatactxi_pur_ix` (`purposeid`),
  KEY `mdl_tooldatactxi_cat_ix` (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Default comment for the table, please edit me';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_tool_dataprivacy_ctxinstance`
--

LOCK TABLES `mdl_tool_dataprivacy_ctxinstance` WRITE;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_ctxinstance` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_tool_dataprivacy_ctxinstance` ENABLE KEYS */;
UNLOCK TABLES;

--
For faster browsing, not all history is shown. View entire blame