moodle_backup.sql

  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext DEFAULT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `numbering` smallint(4) NOT NULL DEFAULT 0,
  `navstyle` smallint(4) NOT NULL DEFAULT 1,
  `customtitles` tinyint(2) NOT NULL DEFAULT 0,
  `revision` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_book_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines book';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_book`
--

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

--
-- Table structure for table `mdl_book_chapters`
--

DROP TABLE IF EXISTS `mdl_book_chapters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_book_chapters` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `bookid` bigint(10) NOT NULL DEFAULT 0,
  `pagenum` bigint(10) NOT NULL DEFAULT 0,
  `subchapter` bigint(10) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` longtext NOT NULL,
  `contentformat` smallint(4) NOT NULL DEFAULT 0,
  `hidden` tinyint(2) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `importsrc` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_bookchap_boo_ix` (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines book_chapters';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_book_chapters`
--

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

--
-- Table structure for table `mdl_cache_filters`
--

DROP TABLE IF EXISTS `mdl_cache_filters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_cache_filters` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `filter` varchar(32) NOT NULL DEFAULT '',
  `version` bigint(10) NOT NULL DEFAULT 0,
  `md5key` varchar(32) NOT NULL DEFAULT '',
  `rawtext` longtext NOT NULL,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_cachfilt_filmd5_ix` (`filter`,`md5key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='For keeping information about cached data';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_cache_filters`
--

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

--
-- Table structure for table `mdl_cache_flags`
--

DROP TABLE IF EXISTS `mdl_cache_flags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_cache_flags` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `flagtype` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `value` longtext NOT NULL,
  `expiry` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_cachflag_fla_ix` (`flagtype`),
  KEY `mdl_cachflag_nam_ix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Cache of time-sensitive flags';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_cache_flags`
--

LOCK TABLES `mdl_cache_flags` WRITE;
/*!40000 ALTER TABLE `mdl_cache_flags` DISABLE KEYS */;
INSERT INTO `mdl_cache_flags` (`id`, `flagtype`, `name`, `timemodified`, `value`, `expiry`) VALUES (1,'userpreferenceschanged','2',1722415784,'1',1722444584),(2,'accesslib/dirtyusers','2',1722415073,'1',1722443873),(3,'userpreferenceschanged','3',1722416288,'1',1722445088),(4,'userpreferenceschanged','4',1722416392,'1',1722445192),(5,'accesslib/dirtyusers','3',1722416223,'1',1722445023),(6,'accesslib/dirtyusers','4',1722416223,'1',1722445023);
/*!40000 ALTER TABLE `mdl_cache_flags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_capabilities`
--

DROP TABLE IF EXISTS `mdl_capabilities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_capabilities` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `captype` varchar(50) NOT NULL DEFAULT '',
  `contextlevel` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) NOT NULL DEFAULT '',
  `riskbitmask` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_capa_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=722 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='this defines all capabilities';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_capabilities`
--

LOCK TABLES `mdl_capabilities` WRITE;
/*!40000 ALTER TABLE `mdl_capabilities` DISABLE KEYS */;
INSERT INTO `mdl_capabilities` (`id`, `name`, `captype`, `contextlevel`, `component`, `riskbitmask`) VALUES (1,'moodle/site:config','write',10,'moodle',62),(2,'moodle/site:configview','read',10,'moodle',0),(3,'moodle/site:readallmessages','read',10,'moodle',8),(4,'moodle/site:manageallmessaging','write',10,'moodle',8),(5,'moodle/site:deleteanymessage','write',10,'moodle',32),(6,'moodle/site:sendmessage','write',10,'moodle',16),(7,'moodle/site:senderrormessage','write',10,'moodle',16),(8,'moodle/site:deleteownmessage','write',10,'moodle',0),(9,'moodle/site:approvecourse','write',40,'moodle',4),(10,'moodle/backup:backupcourse','write',50,'moodle',28),(11,'moodle/backup:backupsection','write',50,'moodle',28),(12,'moodle/backup:backupactivity','write',70,'moodle',28),(13,'moodle/backup:backuptargetimport','read',50,'moodle',28),(14,'moodle/backup:downloadfile','write',50,'moodle',28),(15,'moodle/backup:configure','write',50,'moodle',28),(16,'moodle/backup:userinfo','read',50,'moodle',8),(17,'moodle/backup:anonymise','read',50,'moodle',8),(18,'moodle/restore:restorecourse','write',50,'moodle',28),(19,'moodle/restore:restoresection','write',50,'moodle',28),(20,'moodle/restore:restoreactivity','write',50,'moodle',28),(21,'moodle/restore:viewautomatedfilearea','write',50,'moodle',28),(22,'moodle/restore:restoretargetimport','write',50,'moodle',28),(23,'moodle/restore:uploadfile','write',50,'moodle',28),(24,'moodle/restore:configure','write',50,'moodle',28),(25,'moodle/restore:rolldates','write',50,'moodle',0),(26,'moodle/restore:userinfo','write',50,'moodle',30),(27,'moodle/restore:createuser','write',10,'moodle',24),(28,'moodle/site:manageblocks','write',80,'moodle',20),(29,'moodle/site:accessallgroups','read',70,'moodle',0),(30,'moodle/site:viewanonymousevents','read',70,'moodle',8),(31,'moodle/site:viewfullnames','read',70,'moodle',0),(32,'moodle/site:viewuseridentity','read',70,'moodle',0),(33,'moodle/site:viewreports','read',50,'moodle',8),(34,'moodle/site:trustcontent','write',70,'moodle',4),(35,'moodle/site:uploadusers','write',10,'moodle',24),(36,'moodle/filter:manage','write',50,'moodle',0),(37,'moodle/user:create','write',10,'moodle',24),(38,'moodle/user:delete','write',10,'moodle',40),(39,'moodle/user:update','write',10,'moodle',24),(40,'moodle/user:viewdetails','read',50,'moodle',0),(41,'moodle/user:viewalldetails','read',30,'moodle',8),(42,'moodle/user:viewlastip','read',30,'moodle',8),(43,'moodle/user:viewhiddendetails','read',50,'moodle',8),(44,'moodle/user:loginas','write',50,'moodle',30),(45,'moodle/user:managesyspages','write',10,'moodle',0),(46,'moodle/user:manageblocks','write',30,'moodle',0),(47,'moodle/user:manageownblocks','write',10,'moodle',0),(48,'moodle/user:manageownfiles','write',10,'moodle',0),(49,'moodle/user:ignoreuserquota','write',10,'moodle',0),(50,'moodle/my:configsyspages','write',10,'moodle',0),(51,'moodle/role:assign','write',50,'moodle',28),(52,'moodle/role:review','read',50,'moodle',8),(53,'moodle/role:override','write',50,'moodle',28),(54,'moodle/role:safeoverride','write',50,'moodle',16),(55,'moodle/role:manage','write',10,'moodle',28),(56,'moodle/role:switchroles','read',50,'moodle',12),(57,'moodle/category:manage','write',40,'moodle',4),(58,'moodle/category:viewcourselist','read',40,'moodle',0),(59,'moodle/category:viewhiddencategories','read',40,'moodle',0),(60,'moodle/cohort:manage','write',40,'moodle',0),(61,'moodle/cohort:assign','write',40,'moodle',0),(62,'moodle/cohort:view','read',50,'moodle',0),(63,'moodle/cohort:configurecustomfields','write',10,'moodle',16),(64,'moodle/group:configurecustomfields','write',10,'moodle',16),(65,'moodle/course:create','write',40,'moodle',4),(66,'moodle/course:creategroupconversations','write',50,'moodle',4),(67,'moodle/course:request','write',40,'moodle',0),(68,'moodle/course:delete','write',50,'moodle',32),(69,'moodle/course:update','write',50,'moodle',4),(70,'moodle/course:view','read',50,'moodle',0),(71,'moodle/course:enrolreview','read',50,'moodle',8),(72,'moodle/course:enrolconfig','write',50,'moodle',8),(73,'moodle/course:reviewotherusers','read',50,'moodle',0),(74,'moodle/course:bulkmessaging','write',50,'moodle',16),(75,'moodle/course:viewhiddenuserfields','read',50,'moodle',8),(76,'moodle/course:viewhiddencourses','read',50,'moodle',0),(77,'moodle/course:visibility','write',50,'moodle',0),(78,'moodle/course:managefiles','write',50,'moodle',4),(79,'moodle/course:ignoreavailabilityrestrictions','read',70,'moodle',0),(80,'moodle/course:ignorefilesizelimits','write',50,'moodle',0),(81,'moodle/course:manageactivities','write',70,'moodle',4),(82,'moodle/course:activityvisibility','write',70,'moodle',0),(83,'moodle/course:viewhiddenactivities','read',70,'moodle',0),(84,'moodle/course:viewparticipants','read',50,'moodle',0),(85,'moodle/course:changefullname','write',50,'moodle',4),(86,'moodle/course:changeshortname','write',50,'moodle',4),(87,'moodle/course:changelockedcustomfields','write',50,'moodle',16),(88,'moodle/course:configurecustomfields','write',10,'moodle',16),(89,'moodle/course:renameroles','write',50,'moodle',0),(90,'moodle/course:changeidnumber','write',50,'moodle',4),(91,'moodle/course:changecategory','write',50,'moodle',4),(92,'moodle/course:changesummary','write',50,'moodle',4),(93,'moodle/course:setforcedlanguage','write',50,'moodle',0),(94,'moodle/site:viewparticipants','read',10,'moodle',0),(95,'moodle/course:isincompletionreports','read',50,'moodle',0),(96,'moodle/course:viewscales','read',50,'moodle',0),(97,'moodle/course:managescales','write',50,'moodle',0),(98,'moodle/course:managegroups','write',50,'moodle',4),(99,'moodle/course:viewhiddengroups','READ',50,'moodle',8),(100,'moodle/course:reset','write',50,'moodle',32),(101,'moodle/course:viewsuspendedusers','read',50,'moodle',0),(102,'moodle/course:tag','write',50,'moodle',16),(103,'moodle/blog:view','read',10,'moodle',0),(104,'moodle/blog:search','read',10,'moodle',0),(105,'moodle/blog:viewdrafts','read',10,'moodle',8),(106,'moodle/blog:create','write',10,'moodle',16),(107,'moodle/blog:manageentries','write',10,'moodle',16),(108,'moodle/blog:manageexternal','write',10,'moodle',16),(109,'moodle/calendar:manageownentries','write',50,'moodle',16),(110,'moodle/calendar:managegroupentries','write',50,'moodle',16),(111,'moodle/calendar:manageentries','write',50,'moodle',16),(112,'moodle/user:editprofile','write',30,'moodle',24),(113,'moodle/user:editownprofile','write',10,'moodle',16),(114,'moodle/user:changeownpassword','write',10,'moodle',0),(115,'moodle/user:readuserposts','read',30,'moodle',0),(116,'moodle/user:readuserblogs','read',30,'moodle',0),(117,'moodle/user:viewuseractivitiesreport','read',30,'moodle',8),(118,'moodle/user:editmessageprofile','write',30,'moodle',16),(119,'moodle/user:editownmessageprofile','write',10,'moodle',0),(120,'moodle/question:managecategory','write',50,'moodle',20),(121,'moodle/question:add','write',50,'moodle',20),(122,'moodle/question:editmine','write',50,'moodle',20),(123,'moodle/question:editall','write',50,'moodle',20),(124,'moodle/question:viewmine','read',50,'moodle',0),(125,'moodle/question:viewall','read',50,'moodle',0),(126,'moodle/question:usemine','read',50,'moodle',0),(127,'moodle/question:useall','read',50,'moodle',0),(128,'moodle/question:movemine','write',50,'moodle',0),(129,'moodle/question:moveall','write',50,'moodle',0),(130,'moodle/question:config','write',10,'moodle',2),(131,'moodle/question:flag','write',50,'moodle',0),(132,'moodle/question:tagmine','write',50,'moodle',0),(133,'moodle/question:tagall','write',50,'moodle',0),(134,'moodle/site:doclinks','read',10,'moodle',0),(135,'moodle/course:sectionvisibility','write',50,'moodle',0),(136,'moodle/course:useremail','write',50,'moodle',0),(137,'moodle/course:viewhiddensections','read',50,'moodle',0),(138,'moodle/course:setcurrentsection','write',50,'moodle',0),(139,'moodle/course:movesections','write',50,'moodle',0),(140,'moodle/site:mnetlogintoremote','read',10,'moodle',0),(141,'moodle/grade:viewall','read',50,'moodle',8),(142,'moodle/grade:view','read',50,'moodle',0),(143,'moodle/grade:viewhidden','read',50,'moodle',8),(144,'moodle/grade:import','write',50,'moodle',12),(145,'moodle/grade:export','read',50,'moodle',8),(146,'moodle/grade:manage','write',50,'moodle',12),(147,'moodle/grade:edit','write',50,'moodle',12),(148,'moodle/grade:managegradingforms','write',50,'moodle',12),(149,'moodle/grade:sharegradingforms','write',10,'moodle',4),(150,'moodle/grade:managesharedforms','write',10,'moodle',4),(151,'moodle/grade:manageoutcomes','write',50,'moodle',0),(152,'moodle/grade:manageletters','write',50,'moodle',0),(153,'moodle/grade:hide','write',50,'moodle',0),(154,'moodle/grade:lock','write',50,'moodle',0),(155,'moodle/grade:unlock','write',50,'moodle',0),(156,'moodle/my:manageblocks','write',10,'moodle',0),(157,'moodle/notes:view','read',50,'moodle',0),(158,'moodle/notes:manage','write',50,'moodle',16),(159,'moodle/tag:manage','write',10,'moodle',16),(160,'moodle/tag:edit','write',10,'moodle',16),(161,'moodle/tag:flag','write',10,'moodle',16),(162,'moodle/tag:editblocks','write',10,'moodle',0),(163,'moodle/block:view','read',80,'moodle',0),(164,'moodle/block:edit','write',80,'moodle',20),(165,'moodle/portfolio:export','read',10,'moodle',0),(166,'moodle/comment:view','read',50,'moodle',0),(167,'moodle/comment:post','write',50,'moodle',24),(168,'moodle/comment:delete','write',50,'moodle',32),(169,'moodle/webservice:createtoken','write',10,'moodle',62),(170,'moodle/webservice:managealltokens','write',10,'moodle',42),(171,'moodle/webservice:createmobiletoken','write',10,'moodle',24),(172,'moodle/rating:view','read',50,'moodle',0),(173,'moodle/rating:viewany','read',50,'moodle',8),(174,'moodle/rating:viewall','read',50,'moodle',8),(175,'moodle/rating:rate','write',50,'moodle',0),(176,'moodle/course:markcomplete','write',50,'moodle',0),(177,'moodle/course:overridecompletion','write',50,'moodle',0),(178,'moodle/badges:manageglobalsettings','write',10,'moodle',34),(179,'moodle/badges:viewbadges','read',50,'moodle',0),(180,'moodle/badges:manageownbadges','write',30,'moodle',0),(181,'moodle/badges:viewotherbadges','read',30,'moodle',0),(182,'moodle/badges:earnbadge','write',50,'moodle',0),(183,'moodle/badges:createbadge','write',50,'moodle',16),(184,'moodle/badges:deletebadge','write',50,'moodle',32),(185,'moodle/badges:configuredetails','write',50,'moodle',16),(186,'moodle/badges:configurecriteria','write',50,'moodle',4),(187,'moodle/badges:configuremessages','write',50,'moodle',16),(188,'moodle/badges:awardbadge','write',50,'moodle',16),(189,'moodle/badges:revokebadge','write',50,'moodle',16),(190,'moodle/badges:viewawarded','read',50,'moodle',8),(191,'moodle/site:forcelanguage','read',10,'moodle',0),(192,'moodle/search:query','read',10,'moodle',0),(193,'moodle/competency:competencymanage','write',40,'moodle',0),(194,'moodle/competency:competencyview','read',40,'moodle',0),(195,'moodle/competency:competencygrade','write',50,'moodle',0),(196,'moodle/competency:coursecompetencymanage','write',50,'moodle',0),(197,'moodle/competency:coursecompetencyconfigure','write',70,'moodle',0),(198,'moodle/competency:coursecompetencygradable','read',50,'moodle',0),(199,'moodle/competency:coursecompetencyview','read',50,'moodle',0),(200,'moodle/competency:evidencedelete','write',30,'moodle',0),(201,'moodle/competency:planmanage','write',30,'moodle',0),(202,'moodle/competency:planmanagedraft','write',30,'moodle',0),(203,'moodle/competency:planmanageown','write',30,'moodle',0),(204,'moodle/competency:planmanageowndraft','write',30,'moodle',0),(205,'moodle/competency:planview','read',30,'moodle',0),(206,'moodle/competency:planviewdraft','read',30,'moodle',0),(207,'moodle/competency:planviewown','read',30,'moodle',0),(208,'moodle/competency:planviewowndraft','read',30,'moodle',0),(209,'moodle/competency:planrequestreview','write',30,'moodle',0),(210,'moodle/competency:planrequestreviewown','write',30,'moodle',0),(211,'moodle/competency:planreview','write',30,'moodle',0),(212,'moodle/competency:plancomment','write',30,'moodle',0),(213,'moodle/competency:plancommentown','write',30,'moodle',0),(214,'moodle/competency:usercompetencyview','read',30,'moodle',0),(215,'moodle/competency:usercompetencyrequestreview','write',30,'moodle',0),(216,'moodle/competency:usercompetencyrequestreviewown','write',30,'moodle',0),(217,'moodle/competency:usercompetencyreview','write',30,'moodle',0),(218,'moodle/competency:usercompetencycomment','write',30,'moodle',0),(219,'moodle/competency:usercompetencycommentown','write',30,'moodle',0),(220,'moodle/competency:templatemanage','write',40,'moodle',0),(221,'moodle/analytics:listinsights','read',50,'moodle',8),(222,'moodle/analytics:managemodels','write',10,'moodle',2),(223,'moodle/competency:templateview','read',40,'moodle',0),(224,'moodle/competency:userevidencemanage','write',30,'moodle',0),(225,'moodle/competency:userevidencemanageown','write',30,'moodle',0),(226,'moodle/competency:userevidenceview','read',30,'moodle',0),(227,'moodle/site:maintenanceaccess','write',10,'moodle',0),(228,'moodle/site:messageanyuser','write',10,'moodle',16),(229,'moodle/site:managecontextlocks','write',70,'moodle',0),(230,'moodle/course:togglecompletion','write',70,'moodle',0),(231,'moodle/analytics:listowninsights','read',10,'moodle',0),(232,'moodle/h5p:setdisplayoptions','write',70,'moodle',0),(233,'moodle/h5p:deploy','write',70,'moodle',4),(234,'moodle/h5p:updatelibraries','write',70,'moodle',4),(235,'moodle/course:recommendactivity','write',10,'moodle',0),(236,'moodle/contentbank:access','read',50,'moodle',0),(237,'moodle/contentbank:upload','write',50,'moodle',16),(238,'moodle/contentbank:deleteanycontent','write',50,'moodle',32),(239,'moodle/contentbank:deleteowncontent','write',50,'moodle',0),(240,'moodle/contentbank:manageanycontent','write',50,'moodle',32),(241,'moodle/contentbank:manageowncontent','write',50,'moodle',0),(242,'moodle/contentbank:useeditor','write',50,'moodle',16),(243,'moodle/contentbank:downloadcontent','read',50,'moodle',0),(244,'moodle/contentbank:copyanycontent','write',50,'moodle',16),(245,'moodle/contentbank:copycontent','write',50,'moodle',16),(246,'moodle/course:downloadcoursecontent','read',50,'moodle',0),(247,'moodle/course:configuredownloadcontent','write',50,'moodle',0),(248,'moodle/payment:manageaccounts','write',50,'moodle',42),(249,'moodle/payment:viewpayments','read',50,'moodle',8),(250,'moodle/contentbank:viewunlistedcontent','read',50,'moodle',0),(251,'moodle/reportbuilder:view','read',10,'moodle',0),(252,'moodle/reportbuilder:edit','write',10,'moodle',0),(253,'moodle/reportbuilder:editall','write',10,'moodle',0),(254,'moodle/reportbuilder:scheduleviewas','read',10,'moodle',0),(255,'moodle/moodlenet:shareactivity','read',50,'moodle',0),(256,'moodle/course:configurecoursecommunication','write',50,'moodle',0),(257,'moodle/moodlenet:sharecourse','read',50,'moodle',0),(258,'mod/assign:view','read',70,'mod_assign',0),(259,'mod/assign:submit','write',70,'mod_assign',0),(260,'mod/assign:grade','write',70,'mod_assign',4),(261,'mod/assign:exportownsubmission','read',70,'mod_assign',0),(262,'mod/assign:addinstance','write',50,'mod_assign',4),(263,'mod/assign:editothersubmission','write',70,'mod_assign',41),(264,'mod/assign:grantextension','write',70,'mod_assign',0),(265,'mod/assign:revealidentities','write',70,'mod_assign',0),(266,'mod/assign:reviewgrades','write',70,'mod_assign',0),(267,'mod/assign:releasegrades','write',70,'mod_assign',0),(268,'mod/assign:managegrades','write',70,'mod_assign',0),(269,'mod/assign:manageallocations','write',70,'mod_assign',0),(270,'mod/assign:viewgrades','read',70,'mod_assign',0),(271,'mod/assign:viewblinddetails','write',70,'mod_assign',8),(272,'mod/assign:receivegradernotifications','read',70,'mod_assign',0),(273,'mod/assign:manageoverrides','write',70,'mod_assign',0),(274,'mod/assign:showhiddengrader','read',70,'mod_assign',0),(275,'mod/assign:viewownsubmissionsummary','read',70,'mod_assign',0),(276,'mod/bigbluebuttonbn:addinstance','write',50,'mod_bigbluebuttonbn',4),(277,'mod/bigbluebuttonbn:addinstancewithmeeting','write',70,'mod_bigbluebuttonbn',0),(278,'mod/bigbluebuttonbn:addinstancewithrecording','write',70,'mod_bigbluebuttonbn',0),(279,'mod/bigbluebuttonbn:join','read',70,'mod_bigbluebuttonbn',0),(280,'mod/bigbluebuttonbn:view','read',70,'mod_bigbluebuttonbn',0),(281,'mod/bigbluebuttonbn:managerecordings','write',70,'mod_bigbluebuttonbn',0),(282,'mod/bigbluebuttonbn:viewallrecordingformats','read',70,'mod_bigbluebuttonbn',0),(283,'mod/bigbluebuttonbn:publishrecordings','write',70,'mod_bigbluebuttonbn',0),(284,'mod/bigbluebuttonbn:unpublishrecordings','write',70,'mod_bigbluebuttonbn',0),(285,'mod/bigbluebuttonbn:protectrecordings','write',70,'mod_bigbluebuttonbn',0),(286,'mod/bigbluebuttonbn:unprotectrecordings','write',70,'mod_bigbluebuttonbn',0),(287,'mod/bigbluebuttonbn:deleterecordings','write',70,'mod_bigbluebuttonbn',0),(288,'mod/bigbluebuttonbn:importrecordings','write',70,'mod_bigbluebuttonbn',0),(289,'mod/book:addinstance','write',50,'mod_book',4),(290,'mod/book:read','read',70,'mod_book',0),(291,'mod/book:viewhiddenchapters','read',70,'mod_book',0),(292,'mod/book:edit','write',70,'mod_book',4),(293,'mod/chat:addinstance','write',50,'mod_chat',4),(294,'mod/chat:chat','write',70,'mod_chat',16),(295,'mod/chat:readlog','read',70,'mod_chat',0),(296,'mod/chat:deletelog','write',70,'mod_chat',0),(297,'mod/chat:exportparticipatedsession','read',70,'mod_chat',8),(298,'mod/chat:exportsession','read',70,'mod_chat',8),(299,'mod/chat:view','read',70,'mod_chat',0),(300,'mod/choice:addinstance','write',50,'mod_choice',4),(301,'mod/choice:choose','write',70,'mod_choice',0),(302,'mod/choice:readresponses','read',70,'mod_choice',0),(303,'mod/choice:deleteresponses','write',70,'mod_choice',0),(304,'mod/choice:downloadresponses','read',70,'mod_choice',0),(305,'mod/choice:view','read',70,'mod_choice',0),(306,'mod/data:addinstance','write',50,'mod_data',4),(307,'mod/data:viewentry','read',70,'mod_data',0),(308,'mod/data:writeentry','write',70,'mod_data',16),(309,'mod/data:comment','write',70,'mod_data',16),(310,'mod/data:rate','write',70,'mod_data',0),(311,'mod/data:viewrating','read',70,'mod_data',0),(312,'mod/data:viewanyrating','read',70,'mod_data',8),(313,'mod/data:viewallratings','read',70,'mod_data',8),(314,'mod/data:approve','write',70,'mod_data',16),(315,'mod/data:manageentries','write',70,'mod_data',16),(316,'mod/data:managecomments','write',70,'mod_data',16),(317,'mod/data:managetemplates','write',70,'mod_data',20),(318,'mod/data:viewalluserpresets','read',70,'mod_data',0),(319,'mod/data:manageuserpresets','write',70,'mod_data',20),(320,'mod/data:exportentry','read',70,'mod_data',8),(321,'mod/data:exportownentry','read',70,'mod_data',0),(322,'mod/data:exportallentries','read',70,'mod_data',8),(323,'mod/data:exportuserinfo','read',70,'mod_data',8),(324,'mod/data:view','read',70,'mod_data',0),(325,'mod/feedback:addinstance','write',50,'mod_feedback',4),(326,'mod/feedback:view','read',70,'mod_feedback',0),(327,'mod/feedback:complete','write',70,'mod_feedback',16),(328,'mod/feedback:viewanalysepage','read',70,'mod_feedback',8),(329,'mod/feedback:deletesubmissions','write',70,'mod_feedback',0),(330,'mod/feedback:mapcourse','write',70,'mod_feedback',0),(331,'mod/feedback:edititems','write',70,'mod_feedback',20),(332,'mod/feedback:createprivatetemplate','write',70,'mod_feedback',16),(333,'mod/feedback:createpublictemplate','write',70,'mod_feedback',16),(334,'mod/feedback:deletetemplate','write',70,'mod_feedback',0),(335,'mod/feedback:viewreports','read',70,'mod_feedback',8),(336,'mod/feedback:receivemail','read',70,'mod_feedback',8),(337,'mod/folder:addinstance','write',50,'mod_folder',4),(338,'mod/folder:view','read',70,'mod_folder',0),(339,'mod/folder:managefiles','write',70,'mod_folder',20),(340,'mod/forum:addinstance','write',50,'mod_forum',4),(341,'mod/forum:viewdiscussion','read',70,'mod_forum',0),(342,'mod/forum:viewhiddentimedposts','read',70,'mod_forum',0),(343,'mod/forum:startdiscussion','write',70,'mod_forum',16),(344,'mod/forum:replypost','write',70,'mod_forum',16),(345,'mod/forum:addnews','write',70,'mod_forum',16),(346,'mod/forum:replynews','write',70,'mod_forum',16),(347,'mod/forum:viewrating','read',70,'mod_forum',0),(348,'mod/forum:viewanyrating','read',70,'mod_forum',8),(349,'mod/forum:viewallratings','read',70,'mod_forum',8),(350,'mod/forum:rate','write',70,'mod_forum',0),(351,'mod/forum:postprivatereply','write',70,'mod_forum',0),(352,'mod/forum:readprivatereplies','read',70,'mod_forum',0),(353,'mod/forum:createattachment','write',70,'mod_forum',16),(354,'mod/forum:deleteownpost','write',70,'mod_forum',0),(355,'mod/forum:deleteanypost','write',70,'mod_forum',0),(356,'mod/forum:splitdiscussions','write',70,'mod_forum',0),(357,'mod/forum:movediscussions','write',70,'mod_forum',0),(358,'mod/forum:pindiscussions','write',70,'mod_forum',0),(359,'mod/forum:editanypost','write',70,'mod_forum',16),(360,'mod/forum:viewqandawithoutposting','read',70,'mod_forum',0),(361,'mod/forum:viewsubscribers','read',70,'mod_forum',0),(362,'mod/forum:managesubscriptions','write',70,'mod_forum',16),(363,'mod/forum:postwithoutthrottling','write',70,'mod_forum',16),(364,'mod/forum:exportdiscussion','read',70,'mod_forum',8),(365,'mod/forum:exportforum','read',70,'mod_forum',8),(366,'mod/forum:exportpost','read',70,'mod_forum',8),(367,'mod/forum:exportownpost','read',70,'mod_forum',8),(368,'mod/forum:addquestion','write',70,'mod_forum',16),(369,'mod/forum:allowforcesubscribe','read',70,'mod_forum',0),(370,'mod/forum:canposttomygroups','write',70,'mod_forum',0),(371,'mod/forum:canoverridediscussionlock','write',70,'mod_forum',0),(372,'mod/forum:canoverridecutoff','write',70,'mod_forum',0),(373,'mod/forum:cantogglefavourite','write',70,'mod_forum',0),(374,'mod/forum:grade','write',70,'mod_forum',0),(375,'mod/forum:canmailnow','write',70,'mod_forum',16),(376,'mod/glossary:addinstance','write',50,'mod_glossary',4),(377,'mod/glossary:view','read',70,'mod_glossary',0),(378,'mod/glossary:write','write',70,'mod_glossary',16),(379,'mod/glossary:manageentries','write',70,'mod_glossary',16),(380,'mod/glossary:managecategories','write',70,'mod_glossary',16),(381,'mod/glossary:comment','write',70,'mod_glossary',16),(382,'mod/glossary:managecomments','write',70,'mod_glossary',16),(383,'mod/glossary:import','write',70,'mod_glossary',16),(384,'mod/glossary:export','read',70,'mod_glossary',0),(385,'mod/glossary:approve','write',70,'mod_glossary',16),(386,'mod/glossary:rate','write',70,'mod_glossary',0),(387,'mod/glossary:viewrating','read',70,'mod_glossary',0),(388,'mod/glossary:viewanyrating','read',70,'mod_glossary',8),(389,'mod/glossary:viewallratings','read',70,'mod_glossary',8),(390,'mod/glossary:exportentry','read',70,'mod_glossary',8),(391,'mod/glossary:exportownentry','read',70,'mod_glossary',0),(392,'mod/h5pactivity:view','read',70,'mod_h5pactivity',0),(393,'mod/h5pactivity:addinstance','write',50,'mod_h5pactivity',0),(394,'mod/h5pactivity:submit','write',70,'mod_h5pactivity',0),(395,'mod/h5pactivity:reviewattempts','read',70,'mod_h5pactivity',0),(396,'mod/imscp:view','read',70,'mod_imscp',0),(397,'mod/imscp:addinstance','write',50,'mod_imscp',4),(398,'mod/label:addinstance','write',50,'mod_label',4),(399,'mod/label:view','read',70,'mod_label',0),(400,'mod/lesson:addinstance','write',50,'mod_lesson',4),(401,'mod/lesson:edit','write',70,'mod_lesson',4),(402,'mod/lesson:grade','write',70,'mod_lesson',20),(403,'mod/lesson:viewreports','read',70,'mod_lesson',8),(404,'mod/lesson:manage','write',70,'mod_lesson',0),(405,'mod/lesson:manageoverrides','write',70,'mod_lesson',0),(406,'mod/lesson:view','read',70,'mod_lesson',0),(407,'mod/lti:view','read',70,'mod_lti',0),(408,'mod/lti:addinstance','write',50,'mod_lti',4),(409,'mod/lti:manage','write',70,'mod_lti',8),(410,'mod/lti:admin','write',70,'mod_lti',8),(411,'mod/lti:addcoursetool','write',50,'mod_lti',0),(412,'mod/lti:addpreconfiguredinstance','write',50,'mod_lti',0),(413,'mod/lti:requesttooladd','write',50,'mod_lti',0),(414,'mod/page:view','read',70,'mod_page',0),(415,'mod/page:addinstance','write',50,'mod_page',4),(416,'mod/quiz:view','read',70,'mod_quiz',0),(417,'mod/quiz:addinstance','write',50,'mod_quiz',4),(418,'mod/quiz:attempt','write',70,'mod_quiz',16),(419,'mod/quiz:reviewmyattempts','read',70,'mod_quiz',0),(420,'mod/quiz:manage','write',70,'mod_quiz',16),(421,'mod/quiz:manageoverrides','write',70,'mod_quiz',0),(422,'mod/quiz:viewoverrides','read',70,'mod_quiz',0),(423,'mod/quiz:preview','write',70,'mod_quiz',0),(424,'mod/quiz:grade','write',70,'mod_quiz',20),(425,'mod/quiz:regrade','write',70,'mod_quiz',16),(426,'mod/quiz:viewreports','read',70,'mod_quiz',8),(427,'mod/quiz:deleteattempts','write',70,'mod_quiz',32),(428,'mod/quiz:reopenattempts','write',70,'mod_quiz',0),(429,'mod/quiz:ignoretimelimits','read',70,'mod_quiz',0),(430,'mod/quiz:emailconfirmsubmission','read',70,'mod_quiz',0),(431,'mod/quiz:emailnotifysubmission','read',70,'mod_quiz',0),(432,'mod/quiz:emailwarnoverdue','read',70,'mod_quiz',0),(433,'mod/quiz:emailnotifyattemptgraded','read',70,'mod_quiz',0),(434,'mod/resource:view','read',70,'mod_resource',0),(435,'mod/resource:addinstance','write',50,'mod_resource',4),(436,'mod/scorm:addinstance','write',50,'mod_scorm',4),(437,'mod/scorm:viewreport','read',70,'mod_scorm',0),(438,'mod/scorm:skipview','read',70,'mod_scorm',0),(439,'mod/scorm:savetrack','write',70,'mod_scorm',0),(440,'mod/scorm:viewscores','read',70,'mod_scorm',0),(441,'mod/scorm:deleteresponses','write',70,'mod_scorm',0),(442,'mod/scorm:deleteownresponses','write',70,'mod_scorm',0),(443,'mod/survey:addinstance','write',50,'mod_survey',4),(444,'mod/survey:participate','read',70,'mod_survey',0),(445,'mod/survey:readresponses','read',70,'mod_survey',0),(446,'mod/survey:download','read',70,'mod_survey',0),(447,'mod/url:view','read',70,'mod_url',0),(448,'mod/url:addinstance','write',50,'mod_url',4),(449,'mod/wiki:addinstance','write',50,'mod_wiki',4),(450,'mod/wiki:viewpage','read',70,'mod_wiki',0),(451,'mod/wiki:editpage','write',70,'mod_wiki',16),(452,'mod/wiki:createpage','write',70,'mod_wiki',16),(453,'mod/wiki:viewcomment','read',70,'mod_wiki',0),(454,'mod/wiki:editcomment','write',70,'mod_wiki',16),(455,'mod/wiki:managecomment','write',70,'mod_wiki',0),(456,'mod/wiki:managefiles','write',70,'mod_wiki',0),(457,'mod/wiki:overridelock','write',70,'mod_wiki',0),(458,'mod/wiki:managewiki','write',70,'mod_wiki',0),(459,'mod/workshop:view','read',70,'mod_workshop',0),(460,'mod/workshop:addinstance','write',50,'mod_workshop',4),(461,'mod/workshop:switchphase','write',70,'mod_workshop',0),(462,'mod/workshop:editdimensions','write',70,'mod_workshop',4),(463,'mod/workshop:submit','write',70,'mod_workshop',0),(464,'mod/workshop:peerassess','write',70,'mod_workshop',0),(465,'mod/workshop:manageexamples','write',70,'mod_workshop',0),(466,'mod/workshop:allocate','write',70,'mod_workshop',0),(467,'mod/workshop:publishsubmissions','write',70,'mod_workshop',0),(468,'mod/workshop:viewauthornames','read',70,'mod_workshop',0),(469,'mod/workshop:viewreviewernames','read',70,'mod_workshop',0),(470,'mod/workshop:viewallsubmissions','read',70,'mod_workshop',0),(471,'mod/workshop:viewpublishedsubmissions','read',70,'mod_workshop',0),(472,'mod/workshop:viewauthorpublished','read',70,'mod_workshop',0),(473,'mod/workshop:viewallassessments','read',70,'mod_workshop',0),(474,'mod/workshop:overridegrades','write',70,'mod_workshop',0),(475,'mod/workshop:ignoredeadlines','write',70,'mod_workshop',0),(476,'mod/workshop:deletesubmissions','write',70,'mod_workshop',0),(477,'mod/workshop:exportsubmissions','read',70,'mod_workshop',0),(478,'auth/oauth2:managelinkedlogins','write',30,'auth_oauth2',0),(479,'communication/matrix:moderator','read',50,'communication_matrix',0),(480,'enrol/category:synchronised','write',10,'enrol_category',0),(481,'enrol/category:config','write',50,'enrol_category',0),(482,'enrol/cohort:config','write',50,'enrol_cohort',0),(483,'enrol/cohort:unenrol','write',50,'enrol_cohort',0),(484,'enrol/database:unenrol','write',50,'enrol_database',0),(485,'enrol/database:config','write',50,'enrol_database',0),(486,'enrol/fee:config','write',50,'enrol_fee',0),(487,'enrol/fee:manage','write',50,'enrol_fee',0),(488,'enrol/fee:unenrol','write',50,'enrol_fee',0),(489,'enrol/fee:unenrolself','write',50,'enrol_fee',0),(490,'enrol/flatfile:manage','write',50,'enrol_flatfile',0),(491,'enrol/flatfile:unenrol','write',50,'enrol_flatfile',0),(492,'enrol/guest:config','write',50,'enrol_guest',0),(493,'enrol/imsenterprise:config','write',50,'enrol_imsenterprise',0),(494,'enrol/ldap:manage','write',50,'enrol_ldap',0),(495,'enrol/lti:config','write',50,'enrol_lti',0),(496,'enrol/lti:unenrol','write',50,'enrol_lti',0),(497,'enrol/manual:config','write',50,'enrol_manual',0),(498,'enrol/manual:enrol','write',50,'enrol_manual',0),(499,'enrol/manual:manage','write',50,'enrol_manual',0),(500,'enrol/manual:unenrol','write',50,'enrol_manual',0),(501,'enrol/manual:unenrolself','write',50,'enrol_manual',0),(502,'enrol/meta:config','write',50,'enrol_meta',0),(503,'enrol/meta:selectaslinked','read',50,'enrol_meta',0),(504,'enrol/meta:unenrol','write',50,'enrol_meta',0),(505,'enrol/mnet:config','write',50,'enrol_mnet',0),(506,'enrol/paypal:config','write',50,'enrol_paypal',0),(507,'enrol/paypal:manage','write',50,'enrol_paypal',0),(508,'enrol/paypal:unenrol','write',50,'enrol_paypal',0),(509,'enrol/paypal:unenrolself','write',50,'enrol_paypal',0),(510,'enrol/self:config','write',50,'enrol_self',0),(511,'enrol/self:manage','write',50,'enrol_self',0),(512,'enrol/self:holdkey','write',50,'enrol_self',0),(513,'enrol/self:unenrolself','write',50,'enrol_self',0),(514,'enrol/self:unenrol','write',50,'enrol_self',0),(515,'enrol/self:enrolself','write',50,'enrol_self',0),(516,'message/airnotifier:managedevice','write',10,'message_airnotifier',0),(517,'block/accessreview:addinstance','write',80,'block_accessreview',0),(518,'block/accessreview:view','read',80,'block_accessreview',0),(519,'block/activity_modules:addinstance','write',80,'block_activity_modules',20),(520,'block/activity_results:addinstance','write',80,'block_activity_results',20),(521,'block/admin_bookmarks:myaddinstance','write',10,'block_admin_bookmarks',0),(522,'block/admin_bookmarks:addinstance','write',80,'block_admin_bookmarks',20),(523,'block/badges:addinstance','read',80,'block_badges',0),(524,'block/badges:myaddinstance','read',10,'block_badges',8),(525,'block/blog_menu:addinstance','write',80,'block_blog_menu',20),(526,'block/blog_recent:addinstance','write',80,'block_blog_recent',20),(527,'block/blog_tags:addinstance','write',80,'block_blog_tags',20),(528,'block/calendar_month:myaddinstance','write',10,'block_calendar_month',0),(529,'block/calendar_month:addinstance','write',80,'block_calendar_month',20),(530,'block/calendar_upcoming:myaddinstance','write',10,'block_calendar_upcoming',0),(531,'block/calendar_upcoming:addinstance','write',80,'block_calendar_upcoming',20),(532,'block/comments:myaddinstance','write',10,'block_comments',0),(533,'block/comments:addinstance','write',80,'block_comments',20),(534,'block/completionstatus:addinstance','write',80,'block_completionstatus',20),(535,'block/course_list:myaddinstance','write',10,'block_course_list',0),(536,'block/course_list:addinstance','write',80,'block_course_list',20),(537,'block/course_summary:addinstance','write',80,'block_course_summary',20),(538,'block/feedback:addinstance','write',80,'block_feedback',20),(539,'block/globalsearch:myaddinstance','write',10,'block_globalsearch',0),(540,'block/globalsearch:addinstance','write',80,'block_globalsearch',0),(541,'block/glossary_random:myaddinstance','write',10,'block_glossary_random',0),(542,'block/glossary_random:addinstance','write',80,'block_glossary_random',20),(543,'block/html:myaddinstance','write',10,'block_html',0),(544,'block/html:addinstance','write',80,'block_html',20),(545,'block/login:addinstance','write',80,'block_login',20),(546,'block/lp:addinstance','write',10,'block_lp',0),(547,'block/lp:myaddinstance','write',10,'block_lp',0),(548,'block/mentees:myaddinstance','write',10,'block_mentees',0),(549,'block/mentees:addinstance','write',80,'block_mentees',20),(550,'block/mnet_hosts:myaddinstance','write',10,'block_mnet_hosts',0),(551,'block/mnet_hosts:addinstance','write',80,'block_mnet_hosts',20),(552,'block/myoverview:myaddinstance','write',10,'block_myoverview',0),(553,'block/myprofile:myaddinstance','write',10,'block_myprofile',0),(554,'block/myprofile:addinstance','write',80,'block_myprofile',20),(555,'block/navigation:myaddinstance','write',10,'block_navigation',0),(556,'block/navigation:addinstance','write',80,'block_navigation',20),(557,'block/news_items:myaddinstance','write',10,'block_news_items',0),(558,'block/news_items:addinstance','write',80,'block_news_items',20),(559,'block/online_users:myaddinstance','write',10,'block_online_users',0),(560,'block/online_users:addinstance','write',80,'block_online_users',20),(561,'block/online_users:viewlist','read',80,'block_online_users',0),(562,'block/private_files:myaddinstance','write',10,'block_private_files',0),(563,'block/private_files:addinstance','write',80,'block_private_files',20),(564,'block/recent_activity:addinstance','write',80,'block_recent_activity',20),(565,'block/recent_activity:viewaddupdatemodule','read',50,'block_recent_activity',0),(566,'block/recent_activity:viewdeletemodule','read',50,'block_recent_activity',0),(567,'block/recentlyaccessedcourses:myaddinstance','write',10,'block_recentlyaccessedcourses',0),(568,'block/recentlyaccesseditems:myaddinstance','write',10,'block_recentlyaccesseditems',0),(569,'block/rss_client:myaddinstance','write',10,'block_rss_client',0),(570,'block/rss_client:addinstance','write',80,'block_rss_client',20),(571,'block/rss_client:manageownfeeds','write',80,'block_rss_client',0),(572,'block/rss_client:manageanyfeeds','write',80,'block_rss_client',16),(573,'block/search_forums:addinstance','write',80,'block_search_forums',20),(574,'block/section_links:addinstance','write',80,'block_section_links',20),(575,'block/selfcompletion:addinstance','write',80,'block_selfcompletion',20),(576,'block/settings:myaddinstance','write',10,'block_settings',0),(577,'block/settings:addinstance','write',80,'block_settings',20),(578,'block/site_main_menu:addinstance','write',80,'block_site_main_menu',20),(579,'block/social_activities:addinstance','write',80,'block_social_activities',20),(580,'block/starredcourses:myaddinstance','write',10,'block_starredcourses',0),(581,'block/tag_flickr:addinstance','write',80,'block_tag_flickr',20),(582,'block/tag_youtube:addinstance','write',80,'block_tag_youtube',20),(583,'block/tags:myaddinstance','write',10,'block_tags',0),(584,'block/tags:addinstance','write',80,'block_tags',20),(585,'block/timeline:myaddinstance','write',10,'block_timeline',0),(586,'report/completion:view','read',50,'report_completion',8),(587,'report/courseoverview:view','read',10,'report_courseoverview',8),(588,'report/log:view','read',50,'report_log',8),(589,'report/log:viewtoday','read',50,'report_log',8),(590,'report/loglive:view','read',50,'report_loglive',8),(591,'report/outline:view','read',50,'report_outline',8),(592,'report/outline:viewuserreport','read',50,'report_outline',8),(593,'report/participation:view','read',50,'report_participation',8),(594,'report/performance:view','read',10,'report_performance',2),(595,'report/progress:view','read',50,'report_progress',8),(596,'report/questioninstances:view','read',10,'report_questioninstances',0),(597,'report/security:view','read',10,'report_security',2),(598,'report/stats:view','read',50,'report_stats',8),(599,'report/status:view','read',10,'report_status',2),(600,'report/usersessions:manageownsessions','write',30,'report_usersessions',0),(601,'gradeexport/ods:view','read',50,'gradeexport_ods',8),(602,'gradeexport/ods:publish','read',50,'gradeexport_ods',8),(603,'gradeexport/txt:view','read',50,'gradeexport_txt',8),(604,'gradeexport/txt:publish','read',50,'gradeexport_txt',8),(605,'gradeexport/xls:view','read',50,'gradeexport_xls',8),(606,'gradeexport/xls:publish','read',50,'gradeexport_xls',8),(607,'gradeexport/xml:view','read',50,'gradeexport_xml',8),(608,'gradeexport/xml:publish','read',50,'gradeexport_xml',8),(609,'gradeimport/csv:view','write',50,'gradeimport_csv',0),(610,'gradeimport/direct:view','write',50,'gradeimport_direct',0),(611,'gradeimport/xml:view','write',50,'gradeimport_xml',0),(612,'gradeimport/xml:publish','write',50,'gradeimport_xml',0),(613,'gradereport/grader:view','read',50,'gradereport_grader',8),(614,'gradereport/history:view','read',50,'gradereport_history',8),(615,'gradereport/outcomes:view','read',50,'gradereport_outcomes',8),(616,'gradereport/overview:view','read',50,'gradereport_overview',8),(617,'gradereport/singleview:view','read',50,'gradereport_singleview',8),(618,'gradereport/summary:view','read',50,'gradereport_summary',8),(619,'gradereport/user:view','read',50,'gradereport_user',8),(620,'webservice/rest:use','read',50,'webservice_rest',0),(621,'webservice/soap:use','read',50,'webservice_soap',0),(622,'repository/areafiles:view','read',70,'repository_areafiles',0),(623,'repository/contentbank:view','read',70,'repository_contentbank',0),(624,'repository/contentbank:accesscoursecontent','read',50,'repository_contentbank',0),(625,'repository/contentbank:accesscoursecategorycontent','read',40,'repository_contentbank',0),(626,'repository/contentbank:accessgeneralcontent','read',40,'repository_contentbank',0),(627,'repository/coursefiles:view','read',70,'repository_coursefiles',0),(628,'repository/dropbox:view','read',70,'repository_dropbox',0),(629,'repository/equella:view','read',70,'repository_equella',0),(630,'repository/filesystem:view','read',70,'repository_filesystem',0),(631,'repository/flickr:view','read',70,'repository_flickr',0),(632,'repository/flickr_public:view','read',70,'repository_flickr_public',0),(633,'repository/googledocs:view','read',70,'repository_googledocs',0),(634,'repository/local:view','read',70,'repository_local',0),(635,'repository/merlot:view','read',70,'repository_merlot',0),(636,'repository/nextcloud:view','read',70,'repository_nextcloud',0),(637,'repository/onedrive:view','read',70,'repository_onedrive',0),(638,'repository/recent:view','read',70,'repository_recent',0),(639,'repository/s3:view','read',70,'repository_s3',0),(640,'repository/upload:view','read',70,'repository_upload',0),(641,'repository/url:view','read',70,'repository_url',0),(642,'repository/user:view','read',70,'repository_user',0),(643,'repository/webdav:view','read',70,'repository_webdav',0),(644,'repository/wikimedia:view','read',70,'repository_wikimedia',0),(645,'repository/youtube:view','read',70,'repository_youtube',0),(646,'moodle/question:commentmine','write',50,'qbank_comment',0),(647,'moodle/question:commentall','write',50,'qbank_comment',0),(648,'qbank/customfields:changelockedcustomfields','write',50,'qbank_customfields',16),(649,'qbank/customfields:configurecustomfields','write',10,'qbank_customfields',16),(650,'qbank/customfields:viewhiddencustomfields','read',50,'qbank_customfields',0),(651,'tool/brickfield:viewcoursetools','read',50,'tool_brickfield',8),(652,'tool/brickfield:viewsystemtools','read',10,'tool_brickfield',2),(653,'tool/customlang:view','read',10,'tool_customlang',2),(654,'tool/customlang:edit','write',10,'tool_customlang',6),(655,'tool/customlang:export','read',10,'tool_customlang',2),(656,'tool/dataprivacy:managedatarequests','write',10,'tool_dataprivacy',60),(657,'tool/dataprivacy:requestdeleteforotheruser','write',10,'tool_dataprivacy',60),(658,'tool/dataprivacy:managedataregistry','write',10,'tool_dataprivacy',60),(659,'tool/dataprivacy:makedatarequestsforchildren','write',30,'tool_dataprivacy',24),(660,'tool/dataprivacy:makedatadeletionrequestsforchildren','write',30,'tool_dataprivacy',24),(661,'tool/dataprivacy:downloadownrequest','read',30,'tool_dataprivacy',0),(662,'tool/dataprivacy:downloadallrequests','read',30,'tool_dataprivacy',8),(663,'tool/dataprivacy:requestdelete','write',30,'tool_dataprivacy',32),(664,'tool/lpmigrate:frameworksmigrate','write',10,'tool_lpmigrate',0),(665,'tool/mfa:mfaaccess','write',30,'tool_mfa',0),(666,'tool/monitor:subscribe','read',50,'tool_monitor',8),(667,'tool/monitor:managerules','write',50,'tool_monitor',4),(668,'tool/monitor:managetool','write',10,'tool_monitor',4),(669,'tool/policy:accept','write',10,'tool_policy',0),(670,'tool/policy:acceptbehalf','write',30,'tool_policy',8),(671,'tool/policy:managedocs','write',10,'tool_policy',0),(672,'tool/policy:viewacceptances','read',10,'tool_policy',0),(673,'tool/recyclebin:deleteitems','write',50,'tool_recyclebin',32),(674,'tool/recyclebin:restoreitems','write',50,'tool_recyclebin',0),(675,'tool/recyclebin:viewitems','read',50,'tool_recyclebin',0),(676,'tool/uploaduser:uploaduserpictures','write',10,'tool_uploaduser',16),(677,'tool/usertours:managetours','write',10,'tool_usertours',4),(678,'contenttype/h5p:access','read',50,'contenttype_h5p',0),(679,'contenttype/h5p:upload','write',50,'contenttype_h5p',16),(680,'contenttype/h5p:useeditor','write',50,'contenttype_h5p',16),(681,'booktool/exportimscp:export','read',70,'booktool_exportimscp',0),(682,'booktool/importhtml:import','write',70,'booktool_importhtml',4),(683,'booktool/print:print','read',70,'booktool_print',0),(684,'forumreport/summary:view','read',70,'forumreport_summary',0),(685,'forumreport/summary:viewall','read',70,'forumreport_summary',8),(686,'quiz/grading:viewstudentnames','read',70,'quiz_grading',0),(687,'quiz/grading:viewidnumber','read',70,'quiz_grading',0),(688,'quiz/statistics:view','read',70,'quiz_statistics',0),(689,'quizaccess/seb:managetemplates','write',10,'quizaccess_seb',0),(690,'quizaccess/seb:bypassseb','read',70,'quizaccess_seb',0),(691,'quizaccess/seb:manage_seb_requiresafeexambrowser','write',70,'quizaccess_seb',0),(692,'quizaccess/seb:manage_seb_templateid','read',70,'quizaccess_seb',0),(693,'quizaccess/seb:manage_filemanager_sebconfigfile','write',70,'quizaccess_seb',0),(694,'quizaccess/seb:manage_seb_showsebdownloadlink','write',70,'quizaccess_seb',0),(695,'quizaccess/seb:manage_seb_allowedbrowserexamkeys','write',70,'quizaccess_seb',0),(696,'quizaccess/seb:manage_seb_linkquitseb','write',70,'quizaccess_seb',0),(697,'quizaccess/seb:manage_seb_userconfirmquit','write',70,'quizaccess_seb',0),(698,'quizaccess/seb:manage_seb_allowuserquitseb','write',70,'quizaccess_seb',0),(699,'quizaccess/seb:manage_seb_quitpassword','write',70,'quizaccess_seb',0),(700,'quizaccess/seb:manage_seb_allowreloadinexam','write',70,'quizaccess_seb',0),(701,'quizaccess/seb:manage_seb_showsebtaskbar','write',70,'quizaccess_seb',0),(702,'quizaccess/seb:manage_seb_showreloadbutton','write',70,'quizaccess_seb',0),(703,'quizaccess/seb:manage_seb_showtime','write',70,'quizaccess_seb',0),(704,'quizaccess/seb:manage_seb_showkeyboardlayout','write',70,'quizaccess_seb',0),(705,'quizaccess/seb:manage_seb_showwificontrol','write',70,'quizaccess_seb',0),(706,'quizaccess/seb:manage_seb_enableaudiocontrol','write',70,'quizaccess_seb',0),(707,'quizaccess/seb:manage_seb_muteonstartup','write',70,'quizaccess_seb',0),(708,'quizaccess/seb:manage_seb_allowspellchecking','write',70,'quizaccess_seb',0),(709,'quizaccess/seb:manage_seb_activateurlfiltering','write',70,'quizaccess_seb',0),(710,'quizaccess/seb:manage_seb_filterembeddedcontent','write',70,'quizaccess_seb',0),(711,'quizaccess/seb:manage_seb_expressionsallowed','write',70,'quizaccess_seb',0),(712,'quizaccess/seb:manage_seb_regexallowed','write',70,'quizaccess_seb',0),(713,'quizaccess/seb:manage_seb_expressionsblocked','write',70,'quizaccess_seb',0),(714,'quizaccess/seb:manage_seb_regexblocked','write',70,'quizaccess_seb',0),(715,'atto/h5p:addembed','write',70,'atto_h5p',0),(716,'atto/recordrtc:recordaudio','write',70,'atto_recordrtc',0),(717,'atto/recordrtc:recordvideo','write',70,'atto_recordrtc',0),(718,'tiny/h5p:addembed','write',70,'tiny_h5p',0),(719,'tiny/recordrtc:recordaudio','write',70,'tiny_recordrtc',0),(720,'tiny/recordrtc:recordvideo','write',70,'tiny_recordrtc',0),(721,'factor/capability:cannotpassfactor','read',10,'factor_capability',0);
/*!40000 ALTER TABLE `mdl_capabilities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_chat`
--

DROP TABLE IF EXISTS `mdl_chat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_chat` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `keepdays` bigint(11) NOT NULL DEFAULT 0,
  `studentlogs` smallint(4) NOT NULL DEFAULT 0,
  `chattime` bigint(10) NOT NULL DEFAULT 0,
  `schedule` smallint(4) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_chat_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each of these is a chat room';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_chat`
--

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

--
-- Table structure for table `mdl_chat_messages`
--

DROP TABLE IF EXISTS `mdl_chat_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_chat_messages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `chatid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `issystem` tinyint(1) NOT NULL DEFAULT 0,
  `message` longtext NOT NULL,
  `timestamp` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_chatmess_use_ix` (`userid`),
  KEY `mdl_chatmess_gro_ix` (`groupid`),
  KEY `mdl_chatmess_timcha_ix` (`timestamp`,`chatid`),
  KEY `mdl_chatmess_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores all the actual chat messages';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_chat_messages`
--

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

--
-- Table structure for table `mdl_chat_messages_current`
--

DROP TABLE IF EXISTS `mdl_chat_messages_current`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_chat_messages_current` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `chatid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `issystem` tinyint(1) NOT NULL DEFAULT 0,
  `message` longtext NOT NULL,
  `timestamp` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_chatmesscurr_use_ix` (`userid`),
  KEY `mdl_chatmesscurr_gro_ix` (`groupid`),
  KEY `mdl_chatmesscurr_timcha_ix` (`timestamp`,`chatid`),
  KEY `mdl_chatmesscurr_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores current session';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_chat_messages_current`
--

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

--
-- Table structure for table `mdl_chat_users`
--

DROP TABLE IF EXISTS `mdl_chat_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_chat_users` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `chatid` bigint(11) NOT NULL DEFAULT 0,
  `userid` bigint(11) NOT NULL DEFAULT 0,
  `groupid` bigint(11) NOT NULL DEFAULT 0,
  `version` varchar(16) NOT NULL DEFAULT '',
  `ip` varchar(45) NOT NULL DEFAULT '',
  `firstping` bigint(10) NOT NULL DEFAULT 0,
  `lastping` bigint(10) NOT NULL DEFAULT 0,
  `lastmessageping` bigint(10) NOT NULL DEFAULT 0,
  `sid` varchar(32) NOT NULL DEFAULT '',
  `course` bigint(10) NOT NULL DEFAULT 0,
  `lang` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_chatuser_use_ix` (`userid`),
  KEY `mdl_chatuser_las_ix` (`lastping`),
  KEY `mdl_chatuser_gro_ix` (`groupid`),
  KEY `mdl_chatuser_cha_ix` (`chatid`),
  KEY `mdl_chatuser_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Keeps track of which users are in which chat rooms';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_chat_users`
--

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

--
-- Table structure for table `mdl_choice`
--

DROP TABLE IF EXISTS `mdl_choice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_choice` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `publish` tinyint(2) NOT NULL DEFAULT 0,
  `showresults` tinyint(2) NOT NULL DEFAULT 0,
  `display` smallint(4) NOT NULL DEFAULT 0,
  `allowupdate` tinyint(2) NOT NULL DEFAULT 0,
  `allowmultiple` tinyint(2) NOT NULL DEFAULT 0,
  `showunanswered` tinyint(2) NOT NULL DEFAULT 0,
  `includeinactive` tinyint(2) NOT NULL DEFAULT 1,
  `limitanswers` tinyint(2) NOT NULL DEFAULT 0,
  `timeopen` bigint(10) NOT NULL DEFAULT 0,
  `timeclose` bigint(10) NOT NULL DEFAULT 0,
  `showpreview` tinyint(2) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `completionsubmit` tinyint(1) NOT NULL DEFAULT 0,
  `showavailable` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_choi_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Available choices are stored here';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_choice`
--

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

--
-- Table structure for table `mdl_choice_answers`
--

DROP TABLE IF EXISTS `mdl_choice_answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_choice_answers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `choiceid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `optionid` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_choiansw_use_ix` (`userid`),
  KEY `mdl_choiansw_cho_ix` (`choiceid`),
  KEY `mdl_choiansw_opt_ix` (`optionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='choices performed by users';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_choice_answers`
--

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

--
-- Table structure for table `mdl_choice_options`
--

DROP TABLE IF EXISTS `mdl_choice_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_choice_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `choiceid` bigint(10) NOT NULL DEFAULT 0,
  `text` longtext DEFAULT NULL,
  `maxanswers` bigint(10) DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_choiopti_cho_ix` (`choiceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='available options to choice';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_choice_options`
--

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

--
-- Table structure for table `mdl_cohort`
--

DROP TABLE IF EXISTS `mdl_cohort`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_cohort` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `name` varchar(254) NOT NULL DEFAULT '',
  `idnumber` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `descriptionformat` tinyint(2) NOT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `component` varchar(100) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `theme` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_coho_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each record represents one cohort (aka site-wide group).';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_cohort`
--

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

--
-- Table structure for table `mdl_cohort_members`
--

DROP TABLE IF EXISTS `mdl_cohort_members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_cohort_members` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `cohortid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `timeadded` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_cohomemb_cohuse_uix` (`cohortid`,`userid`),
  KEY `mdl_cohomemb_coh_ix` (`cohortid`),
  KEY `mdl_cohomemb_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Link a user to a cohort.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_cohort_members`
--

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

--
-- Table structure for table `mdl_comments`
--

DROP TABLE IF EXISTS `mdl_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_comments` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `component` varchar(255) DEFAULT NULL,
  `commentarea` varchar(255) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `content` longtext NOT NULL,
  `format` tinyint(2) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_comm_concomite_ix` (`contextid`,`commentarea`,`itemid`),
  KEY `mdl_comm_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='moodle comments module';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_comments`
--

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

--
-- Table structure for table `mdl_communication`
--

DROP TABLE IF EXISTS `mdl_communication`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_communication` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `instanceid` bigint(10) NOT NULL,
  `component` varchar(100) NOT NULL DEFAULT '',
  `instancetype` varchar(100) NOT NULL DEFAULT '',
  `provider` varchar(100) NOT NULL DEFAULT '',
  `roomname` varchar(255) DEFAULT NULL,
  `avatarfilename` varchar(100) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `avatarsynced` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_comm_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Communication records';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_communication`
--

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

--
-- Table structure for table `mdl_communication_customlink`
--

DROP TABLE IF EXISTS `mdl_communication_customlink`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_communication_customlink` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `commid` bigint(10) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_commcust_com_ix` (`commid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the link associated with a custom link communication ';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_communication_customlink`
--

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

--
-- Table structure for table `mdl_communication_user`
--

DROP TABLE IF EXISTS `mdl_communication_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_communication_user` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `commid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `synced` tinyint(1) NOT NULL DEFAULT 0,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_commuser_com_ix` (`commid`),
  KEY `mdl_commuser_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Communication user records mapping';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_communication_user`
--

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

--
-- Table structure for table `mdl_competency`
--

DROP TABLE IF EXISTS `mdl_competency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `descriptionformat` smallint(4) NOT NULL DEFAULT 0,
  `idnumber` varchar(100) DEFAULT NULL,
  `competencyframeworkid` bigint(10) NOT NULL,
  `parentid` bigint(10) NOT NULL DEFAULT 0,
  `path` varchar(255) NOT NULL DEFAULT '',
  `sortorder` bigint(10) NOT NULL,
  `ruletype` varchar(100) DEFAULT NULL,
  `ruleoutcome` tinyint(2) NOT NULL DEFAULT 0,
  `ruleconfig` longtext DEFAULT NULL,
  `scaleid` bigint(10) DEFAULT NULL,
  `scaleconfiguration` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_comp_comidn_uix` (`competencyframeworkid`,`idnumber`),
  KEY `mdl_comp_rul_ix` (`ruleoutcome`),
  KEY `mdl_comp_sca_ix` (`scaleid`),
  KEY `mdl_comp_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table contains the master record of each competency in ';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency`
--

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

--
-- Table structure for table `mdl_competency_coursecomp`
--

DROP TABLE IF EXISTS `mdl_competency_coursecomp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_coursecomp` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `competencyid` bigint(10) NOT NULL,
  `ruleoutcome` tinyint(2) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `sortorder` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_compcour_coucom_uix` (`courseid`,`competencyid`),
  KEY `mdl_compcour_courul_ix` (`courseid`,`ruleoutcome`),
  KEY `mdl_compcour_cou2_ix` (`courseid`),
  KEY `mdl_compcour_com_ix` (`competencyid`),
  KEY `mdl_compcour_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Link a competency to a course.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_coursecomp`
--

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

--
-- Table structure for table `mdl_competency_coursecompsetting`
--

DROP TABLE IF EXISTS `mdl_competency_coursecompsetting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_coursecompsetting` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `pushratingstouserplans` tinyint(2) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_compcour_cou_uix` (`courseid`),
  KEY `mdl_compcour_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table contains the course specific settings for compete';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_coursecompsetting`
--

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

--
-- Table structure for table `mdl_competency_evidence`
--

DROP TABLE IF EXISTS `mdl_competency_evidence`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_evidence` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `usercompetencyid` bigint(10) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `action` tinyint(2) NOT NULL,
  `actionuserid` bigint(10) DEFAULT NULL,
  `descidentifier` varchar(255) NOT NULL DEFAULT '',
  `desccomponent` varchar(255) NOT NULL DEFAULT '',
  `desca` longtext DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `grade` bigint(10) DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_compevid_use_ix` (`usercompetencyid`),
  KEY `mdl_compevid_con_ix` (`contextid`),
  KEY `mdl_compevid_act_ix` (`actionuserid`),
  KEY `mdl_compevid_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The evidence linked to a user competency';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_evidence`
--

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

--
-- Table structure for table `mdl_competency_framework`
--

DROP TABLE IF EXISTS `mdl_competency_framework`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_framework` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(100) DEFAULT NULL,
  `contextid` bigint(10) NOT NULL,
  `idnumber` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `descriptionformat` smallint(4) NOT NULL DEFAULT 0,
  `scaleid` bigint(11) DEFAULT NULL,
  `scaleconfiguration` longtext NOT NULL,
  `visible` tinyint(2) NOT NULL DEFAULT 1,
  `taxonomies` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_compfram_idn_uix` (`idnumber`),
  KEY `mdl_compfram_con_ix` (`contextid`),
  KEY `mdl_compfram_sca_ix` (`scaleid`),
  KEY `mdl_compfram_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of competency frameworks.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_framework`
--

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

--
-- Table structure for table `mdl_competency_modulecomp`
--

DROP TABLE IF EXISTS `mdl_competency_modulecomp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_modulecomp` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `cmid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `sortorder` bigint(10) NOT NULL,
  `competencyid` bigint(10) NOT NULL,
  `ruleoutcome` tinyint(2) NOT NULL,
  `overridegrade` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_compmodu_cmicom_uix` (`cmid`,`competencyid`),
  KEY `mdl_compmodu_cmirul_ix` (`cmid`,`ruleoutcome`),
  KEY `mdl_compmodu_cmi_ix` (`cmid`),
  KEY `mdl_compmodu_com_ix` (`competencyid`),
  KEY `mdl_compmodu_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Link a competency to a module.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_modulecomp`
--

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

--
-- Table structure for table `mdl_competency_plan`
--

DROP TABLE IF EXISTS `mdl_competency_plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_plan` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `descriptionformat` smallint(4) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL,
  `templateid` bigint(10) DEFAULT NULL,
  `origtemplateid` bigint(10) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `duedate` bigint(10) DEFAULT 0,
  `reviewerid` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_compplan_usesta_ix` (`userid`,`status`),
  KEY `mdl_compplan_tem_ix` (`templateid`),
  KEY `mdl_compplan_stadue_ix` (`status`,`duedate`),
  KEY `mdl_compplan_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Learning plans';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_plan`
--

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

--
-- Table structure for table `mdl_competency_plancomp`
--

DROP TABLE IF EXISTS `mdl_competency_plancomp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_plancomp` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `planid` bigint(10) NOT NULL,
  `competencyid` bigint(10) NOT NULL,
  `sortorder` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_compplan_placom_uix` (`planid`,`competencyid`),
  KEY `mdl_compplan_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Plan competencies';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_plancomp`
--

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

--
-- Table structure for table `mdl_competency_relatedcomp`
--

DROP TABLE IF EXISTS `mdl_competency_relatedcomp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_relatedcomp` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `competencyid` bigint(10) NOT NULL,
  `relatedcompetencyid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_comprela_com_ix` (`competencyid`),
  KEY `mdl_comprela_rel_ix` (`relatedcompetencyid`),
  KEY `mdl_comprela_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Related competencies';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_relatedcomp`
--

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

--
-- Table structure for table `mdl_competency_template`
--

DROP TABLE IF EXISTS `mdl_competency_template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_template` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(100) DEFAULT NULL,
  `contextid` bigint(10) NOT NULL,
  `description` longtext DEFAULT NULL,
  `descriptionformat` smallint(4) NOT NULL DEFAULT 0,
  `visible` tinyint(2) NOT NULL DEFAULT 1,
  `duedate` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_comptemp_con_ix` (`contextid`),
  KEY `mdl_comptemp_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Learning plan templates.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_template`
--

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

--
-- Table structure for table `mdl_competency_templatecohort`
--

DROP TABLE IF EXISTS `mdl_competency_templatecohort`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_templatecohort` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `templateid` bigint(10) NOT NULL,
  `cohortid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_comptemp_temcoh_uix` (`templateid`,`cohortid`),
  KEY `mdl_comptemp_tem2_ix` (`templateid`),
  KEY `mdl_comptemp_use3_ix` (`usermodified`)
) 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_competency_templatecohort`
--

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

--
-- Table structure for table `mdl_competency_templatecomp`
--

DROP TABLE IF EXISTS `mdl_competency_templatecomp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_templatecomp` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `templateid` bigint(10) NOT NULL,
  `competencyid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `sortorder` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_comptemp_tem_ix` (`templateid`),
  KEY `mdl_comptemp_com_ix` (`competencyid`),
  KEY `mdl_comptemp_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Link a competency to a learning plan template.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_templatecomp`
--

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

--
-- Table structure for table `mdl_competency_usercomp`
--

DROP TABLE IF EXISTS `mdl_competency_usercomp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mdl_competency_usercomp` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `competencyid` bigint(10) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT 0,
  `reviewerid` bigint(10) DEFAULT NULL,
  `proficiency` tinyint(2) DEFAULT NULL,
  `grade` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_compuser_usecom_uix` (`userid`,`competencyid`),
  KEY `mdl_compuser_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='User competencies';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_competency_usercomp`
--

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

--
-- Table structure for table `mdl_competency_usercompcourse`
--

DROP TABLE IF EXISTS `mdl_competency_usercompcourse`;