--
-- Host: localhost    Database: moodle
-- ------------------------------------------------------


--
-- Table structure for table `mdl_adminpresets`
--

CREATE TABLE `mdl_adminpresets` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `comments` longtext DEFAULT NULL,
  `site` varchar(255) NOT NULL DEFAULT '',
  `author` varchar(255) DEFAULT NULL,
  `moodleversion` varchar(20) NOT NULL DEFAULT '',
  `moodlerelease` varchar(255) NOT NULL DEFAULT '',
  `iscore` tinyint(1) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timeimported` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Table to store presets data';

--
-- Dumping data for table `mdl_adminpresets`
--

INSERT INTO `mdl_adminpresets` VALUES (1,0,'Starter (lanzador)','Moodle con todas las funciones más populares, incluidas asignaciones, comentarios, foros, H5P, cuestionarios y seguimiento de finalización.','http://localhost','','','',1,1785888326,0),(2,0,'Completo','Todas las características de Starter más la herramienta externa (LTI), SCORM, Workshop, Analytics, Badges, Competencias, planes de aprendizaje y mucho más.','http://localhost','','','',2,1785888326,0);

--
-- Table structure for table `mdl_adminpresets_app`
--

CREATE TABLE `mdl_adminpresets_app` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `adminpresetid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `time` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_admiapp_adm_ix` (`adminpresetid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Applied presets';

--
-- Dumping data for table `mdl_adminpresets_app`
--


--
-- Table structure for table `mdl_adminpresets_app_it`
--

CREATE TABLE `mdl_adminpresets_app_it` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `adminpresetapplyid` bigint(10) NOT NULL,
  `configlogid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_admiappit_con_ix` (`configlogid`),
  KEY `mdl_admiappit_adm_ix` (`adminpresetapplyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Admin presets applied items. To maintain the relation with c';

--
-- Dumping data for table `mdl_adminpresets_app_it`
--


--
-- Table structure for table `mdl_adminpresets_app_it_a`
--

CREATE TABLE `mdl_adminpresets_app_it_a` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `adminpresetapplyid` bigint(10) NOT NULL,
  `configlogid` bigint(10) NOT NULL,
  `itemname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_admiappita_con_ix` (`configlogid`),
  KEY `mdl_admiappita_adm_ix` (`adminpresetapplyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Attributes of the applied items';

--
-- Dumping data for table `mdl_adminpresets_app_it_a`
--


--
-- Table structure for table `mdl_adminpresets_app_plug`
--

CREATE TABLE `mdl_adminpresets_app_plug` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `adminpresetapplyid` bigint(10) NOT NULL,
  `plugin` varchar(100) DEFAULT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` smallint(4) NOT NULL DEFAULT 0,
  `oldvalue` smallint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_admiappplug_adm_ix` (`adminpresetapplyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Admin presets plugins applied';

--
-- Dumping data for table `mdl_adminpresets_app_plug`
--


--
-- Table structure for table `mdl_adminpresets_it`
--

CREATE TABLE `mdl_adminpresets_it` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `adminpresetid` bigint(10) NOT NULL,
  `plugin` varchar(100) DEFAULT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_admiit_adm_ix` (`adminpresetid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Table to store settings';

--
-- Dumping data for table `mdl_adminpresets_it`
--

INSERT INTO `mdl_adminpresets_it` VALUES (1,1,'none','usecomments','0'),(2,1,'none','usetags','0'),(3,1,'none','enablenotes','0'),(4,1,'none','enableblogs','0'),(5,1,'none','enablebadges','0'),(6,1,'none','enableanalytics','0'),(7,1,'core_competency','enabled','0'),(8,1,'core_competency','pushcourseratingstouserplans','0'),(9,1,'tool_dataprivacy','showdataretentionsummary','0'),(10,1,'none','forum_maxattachments','3'),(11,1,'none','guestloginbutton','0'),(12,1,'none','activitychoosertabmode','4'),(13,2,'none','usecomments','1'),(14,2,'none','usetags','1'),(15,2,'none','enablenotes','1'),(16,2,'none','enableblogs','1'),(17,2,'none','enablebadges','1'),(18,2,'none','enableanalytics','0'),(19,2,'core_competency','enabled','1'),(20,2,'core_competency','pushcourseratingstouserplans','1'),(21,2,'tool_dataprivacy','showdataretentionsummary','1'),(22,2,'none','forum_maxattachments','9'),(23,2,'none','guestloginbutton','1'),(24,2,'none','activitychoosertabmode','3');

--
-- Table structure for table `mdl_adminpresets_it_a`
--

CREATE TABLE `mdl_adminpresets_it_a` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `itemid` bigint(10) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_admiita_ite_ix` (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Admin presets items attributes. For settings with attributes';

--
-- Dumping data for table `mdl_adminpresets_it_a`
--


--
-- Table structure for table `mdl_adminpresets_plug`
--

CREATE TABLE `mdl_adminpresets_plug` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `adminpresetid` bigint(10) NOT NULL,
  `plugin` varchar(100) DEFAULT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `enabled` smallint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_admiplug_adm_ix` (`adminpresetid`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Admin presets plugins status, to store information about whe';

--
-- Dumping data for table `mdl_adminpresets_plug`
--

INSERT INTO `mdl_adminpresets_plug` VALUES (1,1,'mod','data',0),(2,1,'mod','lti',0),(3,1,'mod','imscp',0),(4,1,'mod','lesson',0),(5,1,'mod','scorm',0),(6,1,'mod','wiki',0),(7,1,'mod','workshop',0),(8,1,'availability','grouping',0),(9,1,'availability','profile',0),(10,1,'block','activity_modules',0),(11,1,'block','blog_menu',0),(12,1,'block','blog_tags',0),(13,1,'block','comments',0),(14,1,'block','completionstatus',0),(15,1,'block','course_summary',0),(16,1,'block','course_list',0),(17,1,'block','tag_flickr',0),(18,1,'block','globalsearch',0),(19,1,'block','badges',0),(20,1,'block','lp',0),(21,1,'block','myprofile',0),(22,1,'block','login',0),(23,1,'block','site_main_menu',0),(24,1,'block','mentees',0),(25,1,'block','private_files',0),(26,1,'block','blog_recent',0),(27,1,'block','rss_client',0),(28,1,'block','search_forums',0),(29,1,'block','section_links',0),(30,1,'block','selfcompletion',0),(31,1,'block','social_activities',0),(32,1,'block','tags',0),(33,1,'block','tag_youtube',0),(34,1,'block','feedback',0),(35,1,'block','online_users',0),(36,1,'block','recentlyaccessedcourses',0),(37,1,'block','starredcourses',0),(38,1,'format','social',0),(39,1,'dataformat','json',0),(40,1,'enrol','cohort',0),(41,1,'enrol','guest',0),(42,1,'filter','mathjaxloader',-9999),(43,1,'filter','activitynames',-9999),(44,1,'qbehaviour','adaptivenopenalty',0),(45,1,'qbehaviour','deferredcbm',0),(46,1,'qbehaviour','immediatecbm',0),(47,1,'qtype','calculated',0),(48,1,'qtype','calculatedmulti',0),(49,1,'qtype','calculatedsimple',0),(50,1,'qtype','ddmarker',0),(51,1,'qtype','ddimageortext',0),(52,1,'qtype','multianswer',0),(53,1,'qtype','numerical',0),(54,1,'qtype','randomsamatch',0),(55,1,'repository','local',0),(56,1,'repository','url',0),(57,1,'repository','wikimedia',0),(58,2,'mod','data',1),(59,2,'mod','lti',1),(60,2,'mod','imscp',1),(61,2,'mod','lesson',1),(62,2,'mod','scorm',1),(63,2,'mod','wiki',1),(64,2,'mod','workshop',1),(65,2,'availability','grouping',1),(66,2,'availability','profile',1),(67,2,'block','activity_modules',1),(68,2,'block','blog_menu',1),(69,2,'block','blog_tags',1),(70,2,'block','comments',1),(71,2,'block','completionstatus',1),(72,2,'block','course_list',1),(73,2,'block','tag_flickr',1),(74,2,'block','globalsearch',1),(75,2,'block','badges',1),(76,2,'block','lp',1),(77,2,'block','myprofile',1),(78,2,'block','login',1),(79,2,'block','site_main_menu',1),(80,2,'block','mentees',1),(81,2,'block','private_files',1),(82,2,'block','blog_recent',1),(83,2,'block','search_forums',1),(84,2,'block','section_links',1),(85,2,'block','social_activities',1),(86,2,'block','tags',1),(87,2,'block','online_users',1),(88,2,'block','recentlyaccessedcourses',1),(89,2,'block','starredcourses',1),(90,2,'format','social',1),(91,2,'dataformat','json',1),(92,2,'enrol','cohort',1),(93,2,'enrol','guest',1),(94,2,'filter','mathjaxloader',1),(95,2,'filter','activitynames',1),(96,2,'qbehaviour','adaptivenopenalty',1),(97,2,'qbehaviour','deferredcbm',1),(98,2,'qbehaviour','immediatecbm',1),(99,2,'qtype','calculated',1),(100,2,'qtype','calculatedmulti',1),(101,2,'qtype','calculatedsimple',1),(102,2,'qtype','ddmarker',1),(103,2,'qtype','ddimageortext',1),(104,2,'qtype','multianswer',1),(105,2,'qtype','numerical',1),(106,2,'qtype','randomsamatch',1),(107,2,'repository','local',1),(108,2,'repository','url',1),(109,2,'repository','wikimedia',1);

--
-- Table structure for table `mdl_ai_action_explain_text`
--

CREATE TABLE `mdl_ai_action_explain_text` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `prompt` longtext DEFAULT NULL,
  `responseid` varchar(128) DEFAULT NULL,
  `fingerprint` varchar(128) DEFAULT NULL,
  `generatedcontent` longtext DEFAULT NULL,
  `finishreason` varchar(128) DEFAULT NULL,
  `prompttokens` bigint(10) DEFAULT NULL,
  `completiontoken` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores specific data about explain text actions.';

--
-- Dumping data for table `mdl_ai_action_explain_text`
--


--
-- Table structure for table `mdl_ai_action_generate_image`
--

CREATE TABLE `mdl_ai_action_generate_image` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `prompt` longtext DEFAULT NULL,
  `numberimages` bigint(10) NOT NULL,
  `quality` varchar(21) NOT NULL DEFAULT '',
  `aspectratio` varchar(20) DEFAULT NULL,
  `style` varchar(20) DEFAULT NULL,
  `sourceurl` longtext DEFAULT NULL,
  `revisedprompt` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores specific data about generate image actions';

--
-- Dumping data for table `mdl_ai_action_generate_image`
--


--
-- Table structure for table `mdl_ai_action_generate_text`
--

CREATE TABLE `mdl_ai_action_generate_text` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `prompt` longtext DEFAULT NULL,
  `responseid` varchar(128) DEFAULT NULL,
  `fingerprint` varchar(128) DEFAULT NULL,
  `generatedcontent` longtext DEFAULT NULL,
  `finishreason` varchar(128) DEFAULT NULL,
  `prompttokens` bigint(10) DEFAULT NULL,
  `completiontoken` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores specific data about generate text actions.';

--
-- Dumping data for table `mdl_ai_action_generate_text`
--


--
-- Table structure for table `mdl_ai_action_register`
--

CREATE TABLE `mdl_ai_action_register` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `actionname` varchar(100) NOT NULL DEFAULT '',
  `actionid` bigint(10) NOT NULL,
  `success` tinyint(1) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `provider` varchar(100) NOT NULL DEFAULT '',
  `errorcode` smallint(4) DEFAULT NULL,
  `errormessage` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timecompleted` bigint(10) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_aiactiregi_actact_uix` (`actionname`,`actionid`),
  KEY `mdl_aiactiregi_actpro_ix` (`actionname`,`provider`),
  KEY `mdl_aiactiregi_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores information about processed ai actions.';

--
-- Dumping data for table `mdl_ai_action_register`
--


--
-- Table structure for table `mdl_ai_action_summarise_text`
--

CREATE TABLE `mdl_ai_action_summarise_text` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `prompt` longtext DEFAULT NULL,
  `responseid` varchar(128) DEFAULT NULL,
  `fingerprint` varchar(128) DEFAULT NULL,
  `generatedcontent` longtext DEFAULT NULL,
  `finishreason` varchar(128) DEFAULT NULL,
  `prompttokens` bigint(10) DEFAULT NULL,
  `completiontoken` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores specific data about summarise text actions.';

--
-- Dumping data for table `mdl_ai_action_summarise_text`
--


--
-- Table structure for table `mdl_ai_policy_register`
--

CREATE TABLE `mdl_ai_policy_register` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `timeaccepted` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_aipoliregi_use_uix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Register of users who have accepted this sites AI usage poli';

--
-- Dumping data for table `mdl_ai_policy_register`
--


--
-- Table structure for table `mdl_ai_providers`
--

CREATE TABLE `mdl_ai_providers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `provider` varchar(255) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `config` longtext NOT NULL,
  `actionconfig` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_aiprov_pro_ix` (`provider`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='AI provider instances';

--
-- Dumping data for table `mdl_ai_providers`
--


--
-- Table structure for table `mdl_analytics_indicator_calc`
--

CREATE TABLE `mdl_analytics_indicator_calc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `starttime` bigint(10) NOT NULL,
  `endtime` bigint(10) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `sampleorigin` varchar(255) NOT NULL DEFAULT '',
  `sampleid` bigint(10) NOT NULL,
  `indicator` varchar(255) NOT NULL DEFAULT '',
  `value` decimal(10,2) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_analindicalc_staendcon_ix` (`starttime`,`endtime`,`contextid`),
  KEY `mdl_analindicalc_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stored indicator calculations';

--
-- Dumping data for table `mdl_analytics_indicator_calc`
--


--
-- Table structure for table `mdl_analytics_models`
--

CREATE TABLE `mdl_analytics_models` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `enabled` tinyint(1) NOT NULL DEFAULT 0,
  `trained` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(1333) DEFAULT NULL,
  `target` varchar(255) NOT NULL DEFAULT '',
  `indicators` longtext NOT NULL,
  `timesplitting` varchar(255) DEFAULT NULL,
  `predictionsprocessor` varchar(255) DEFAULT NULL,
  `version` bigint(10) NOT NULL,
  `contextids` longtext DEFAULT NULL,
  `timecreated` bigint(10) DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_analmode_enatra_ix` (`enabled`,`trained`),
  KEY `mdl_analmode_use_ix` (`usermodified`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Analytic models.';

--
-- Dumping data for table `mdl_analytics_models`
--

INSERT INTO `mdl_analytics_models` VALUES (1,0,0,NULL,'\\core_course\\analytics\\target\\course_dropout','[\"\\\\core\\\\analytics\\\\indicator\\\\any_access_after_end\",\"\\\\core\\\\analytics\\\\indicator\\\\any_access_before_start\",\"\\\\core\\\\analytics\\\\indicator\\\\any_write_action_in_course\",\"\\\\core\\\\analytics\\\\indicator\\\\read_actions\",\"\\\\core_course\\\\analytics\\\\indicator\\\\completion_enabled\",\"\\\\core_course\\\\analytics\\\\indicator\\\\potential_cognitive_depth\",\"\\\\core_course\\\\analytics\\\\indicator\\\\potential_social_breadth\",\"\\\\mod_assign\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_assign\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_book\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_book\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_choice\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_choice\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_data\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_data\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_feedback\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_feedback\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_folder\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_folder\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_forum\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_forum\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_glossary\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_glossary\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_imscp\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_imscp\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_label\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_label\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_lesson\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_lesson\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_lti\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_lti\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_page\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_page\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_quiz\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_quiz\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_resource\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_resource\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_scorm\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_scorm\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_url\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_url\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_wiki\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_wiki\\\\analytics\\\\indicator\\\\social_breadth\",\"\\\\mod_workshop\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_workshop\\\\analytics\\\\indicator\\\\social_breadth\"]',NULL,NULL,1785888339,NULL,1785888339,1785888339,0),(2,1,1,NULL,'\\core_course\\analytics\\target\\no_teaching','[\"\\\\core_course\\\\analytics\\\\indicator\\\\no_teacher\",\"\\\\core_course\\\\analytics\\\\indicator\\\\no_student\"]','\\core\\analytics\\time_splitting\\single_range',NULL,1785888339,NULL,1785888339,1785888339,0),(3,1,1,NULL,'\\core_user\\analytics\\target\\upcoming_activities_due','[\"\\\\core_course\\\\analytics\\\\indicator\\\\activities_due\"]','\\core\\analytics\\time_splitting\\upcoming_week',NULL,1785888339,NULL,1785888339,1785888339,0),(4,1,1,NULL,'\\core_course\\analytics\\target\\no_access_since_course_start','[\"\\\\core\\\\analytics\\\\indicator\\\\any_course_access\"]','\\core\\analytics\\time_splitting\\one_month_after_start',NULL,1785888339,NULL,1785888339,1785888339,0),(5,1,1,NULL,'\\core_course\\analytics\\target\\no_recent_accesses','[\"\\\\core\\\\analytics\\\\indicator\\\\any_course_access\"]','\\core\\analytics\\time_splitting\\past_month',NULL,1785888339,NULL,1785888339,1785888339,0);

--
-- Table structure for table `mdl_analytics_models_log`
--

CREATE TABLE `mdl_analytics_models_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modelid` bigint(10) NOT NULL,
  `version` bigint(10) NOT NULL,
  `evaluationmode` varchar(50) NOT NULL DEFAULT '',
  `target` varchar(255) NOT NULL DEFAULT '',
  `indicators` longtext NOT NULL,
  `timesplitting` varchar(255) DEFAULT NULL,
  `score` decimal(10,5) NOT NULL DEFAULT 0.00000,
  `info` longtext DEFAULT NULL,
  `dir` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_analmodelog_mod_ix` (`modelid`),
  KEY `mdl_analmodelog_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Analytic models changes during evaluation.';

--
-- Dumping data for table `mdl_analytics_models_log`
--


--
-- Table structure for table `mdl_analytics_predict_samples`
--

CREATE TABLE `mdl_analytics_predict_samples` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modelid` bigint(10) NOT NULL,
  `analysableid` bigint(10) NOT NULL,
  `timesplitting` varchar(255) NOT NULL DEFAULT '',
  `rangeindex` bigint(10) NOT NULL,
  `sampleids` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_analpredsamp_modanatimr_ix` (`modelid`,`analysableid`,`timesplitting`,`rangeindex`),
  KEY `mdl_analpredsamp_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Samples already used for predictions.';

--
-- Dumping data for table `mdl_analytics_predict_samples`
--


--
-- Table structure for table `mdl_analytics_prediction_actions`
--

CREATE TABLE `mdl_analytics_prediction_actions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `predictionid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `actionname` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_analpredacti_preuseact_ix` (`predictionid`,`userid`,`actionname`),
  KEY `mdl_analpredacti_pre_ix` (`predictionid`),
  KEY `mdl_analpredacti_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Register of user actions over predictions.';

--
-- Dumping data for table `mdl_analytics_prediction_actions`
--


--
-- Table structure for table `mdl_analytics_predictions`
--

CREATE TABLE `mdl_analytics_predictions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modelid` bigint(10) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `sampleid` bigint(10) NOT NULL,
  `rangeindex` mediumint(5) NOT NULL,
  `prediction` decimal(10,2) NOT NULL,
  `predictionscore` decimal(10,5) NOT NULL,
  `calculations` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timestart` bigint(10) DEFAULT NULL,
  `timeend` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_analpred_modcon_ix` (`modelid`,`contextid`),
  KEY `mdl_analpred_mod_ix` (`modelid`),
  KEY `mdl_analpred_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Predictions';

--
-- Dumping data for table `mdl_analytics_predictions`
--


--
-- Table structure for table `mdl_analytics_train_samples`
--

CREATE TABLE `mdl_analytics_train_samples` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modelid` bigint(10) NOT NULL,
  `analysableid` bigint(10) NOT NULL,
  `timesplitting` varchar(255) NOT NULL DEFAULT '',
  `sampleids` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_analtraisamp_modanatim_ix` (`modelid`,`analysableid`,`timesplitting`),
  KEY `mdl_analtraisamp_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Samples used for training';

--
-- Dumping data for table `mdl_analytics_train_samples`
--


--
-- Table structure for table `mdl_analytics_used_analysables`
--

CREATE TABLE `mdl_analytics_used_analysables` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modelid` bigint(10) NOT NULL,
  `action` varchar(50) NOT NULL DEFAULT '',
  `analysableid` bigint(10) NOT NULL,
  `firstanalysis` bigint(10) NOT NULL,
  `timeanalysed` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_analusedanal_modact_ix` (`modelid`,`action`),
  KEY `mdl_analusedanal_ana_ix` (`analysableid`),
  KEY `mdl_analusedanal_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of analysables used by each model';

--
-- Dumping data for table `mdl_analytics_used_analysables`
--


--
-- Table structure for table `mdl_analytics_used_files`
--

CREATE TABLE `mdl_analytics_used_files` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modelid` bigint(10) NOT NULL DEFAULT 0,
  `fileid` bigint(10) NOT NULL DEFAULT 0,
  `action` varchar(50) NOT NULL DEFAULT '',
  `time` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_analusedfile_modactfil_ix` (`modelid`,`action`,`fileid`),
  KEY `mdl_analusedfile_mod_ix` (`modelid`),
  KEY `mdl_analusedfile_fil_ix` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Files that have already been used for training and predictio';

--
-- Dumping data for table `mdl_analytics_used_files`
--


--
-- Table structure for table `mdl_assign`
--

CREATE TABLE `mdl_assign` (
  `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,
  `alwaysshowdescription` tinyint(2) NOT NULL DEFAULT 0,
  `nosubmissions` tinyint(2) NOT NULL DEFAULT 0,
  `submissiondrafts` tinyint(2) NOT NULL DEFAULT 0,
  `sendnotifications` tinyint(2) NOT NULL DEFAULT 0,
  `sendlatenotifications` tinyint(2) NOT NULL DEFAULT 0,
  `duedate` bigint(10) NOT NULL DEFAULT 0,
  `allowsubmissionsfromdate` bigint(10) NOT NULL DEFAULT 0,
  `grade` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `requiresubmissionstatement` tinyint(2) NOT NULL DEFAULT 0,
  `completionsubmit` tinyint(2) NOT NULL DEFAULT 0,
  `cutoffdate` bigint(10) NOT NULL DEFAULT 0,
  `gradingduedate` bigint(10) NOT NULL DEFAULT 0,
  `teamsubmission` tinyint(2) NOT NULL DEFAULT 0,
  `requireallteammemberssubmit` tinyint(2) NOT NULL DEFAULT 0,
  `teamsubmissiongroupingid` bigint(10) NOT NULL DEFAULT 0,
  `blindmarking` tinyint(2) NOT NULL DEFAULT 0,
  `hidegrader` tinyint(2) NOT NULL DEFAULT 0,
  `revealidentities` tinyint(2) NOT NULL DEFAULT 0,
  `attemptreopenmethod` varchar(10) NOT NULL DEFAULT 'untilpass',
  `maxattempts` mediumint(6) NOT NULL DEFAULT 1,
  `markingworkflow` tinyint(2) NOT NULL DEFAULT 0,
  `markingallocation` tinyint(2) NOT NULL DEFAULT 0,
  `markinganonymous` tinyint(2) NOT NULL DEFAULT 0,
  `sendstudentnotifications` tinyint(2) NOT NULL DEFAULT 1,
  `preventsubmissionnotingroup` tinyint(2) NOT NULL DEFAULT 0,
  `activity` longtext DEFAULT NULL,
  `activityformat` smallint(4) NOT NULL DEFAULT 0,
  `timelimit` bigint(10) NOT NULL DEFAULT 0,
  `submissionattachments` tinyint(2) NOT NULL DEFAULT 0,
  `gradepenalty` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_assi_cou_ix` (`course`),
  KEY `mdl_assi_tea_ix` (`teamsubmissiongroupingid`),
  KEY `mdl_assi_gra_ix` (`gradepenalty`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table saves information about an instance of mod_assign';

--
-- Dumping data for table `mdl_assign`
--


--
-- Table structure for table `mdl_assign_grades`
--

CREATE TABLE `mdl_assign_grades` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `grader` bigint(10) NOT NULL DEFAULT 0,
  `grade` decimal(10,5) DEFAULT 0.00000,
  `penalty` decimal(10,5) NOT NULL DEFAULT 0.00000,
  `attemptnumber` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_assigrad_assuseatt_uix` (`assignment`,`userid`,`attemptnumber`),
  KEY `mdl_assigrad_use_ix` (`userid`),
  KEY `mdl_assigrad_att_ix` (`attemptnumber`),
  KEY `mdl_assigrad_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Grading information about a single assignment submission.';

--
-- Dumping data for table `mdl_assign_grades`
--


--
-- Table structure for table `mdl_assign_overrides`
--

CREATE TABLE `mdl_assign_overrides` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) DEFAULT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `sortorder` bigint(10) DEFAULT NULL,
  `allowsubmissionsfromdate` bigint(10) DEFAULT NULL,
  `duedate` bigint(10) DEFAULT NULL,
  `cutoffdate` bigint(10) DEFAULT NULL,
  `timelimit` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_assiover_ass_ix` (`assignid`),
  KEY `mdl_assiover_gro_ix` (`groupid`),
  KEY `mdl_assiover_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The overrides to assign settings.';

--
-- Dumping data for table `mdl_assign_overrides`
--


--
-- Table structure for table `mdl_assign_plugin_config`
--

CREATE TABLE `mdl_assign_plugin_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `plugin` varchar(28) NOT NULL DEFAULT '',
  `subtype` varchar(28) NOT NULL DEFAULT '',
  `name` varchar(28) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_assiplugconf_plu_ix` (`plugin`),
  KEY `mdl_assiplugconf_sub_ix` (`subtype`),
  KEY `mdl_assiplugconf_nam_ix` (`name`),
  KEY `mdl_assiplugconf_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Config data for an instance of a plugin in an assignment.';

--
-- Dumping data for table `mdl_assign_plugin_config`
--


--
-- Table structure for table `mdl_assign_submission`
--

CREATE TABLE `mdl_assign_submission` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `timestarted` bigint(10) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `attemptnumber` bigint(10) NOT NULL DEFAULT 0,
  `latest` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_assisubm_assusegroatt_uix` (`assignment`,`userid`,`groupid`,`attemptnumber`),
  KEY `mdl_assisubm_use_ix` (`userid`),
  KEY `mdl_assisubm_att_ix` (`attemptnumber`),
  KEY `mdl_assisubm_assusegrolat_ix` (`assignment`,`userid`,`groupid`,`latest`),
  KEY `mdl_assisubm_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table keeps information about student interactions with';

--
-- Dumping data for table `mdl_assign_submission`
--


--
-- Table structure for table `mdl_assign_user_flags`
--

CREATE TABLE `mdl_assign_user_flags` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `locked` bigint(10) NOT NULL DEFAULT 0,
  `mailed` smallint(4) NOT NULL DEFAULT 0,
  `extensionduedate` bigint(10) NOT NULL DEFAULT 0,
  `workflowstate` varchar(20) DEFAULT NULL,
  `allocatedmarker` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_assiuserflag_mai_ix` (`mailed`),
  KEY `mdl_assiuserflag_use_ix` (`userid`),
  KEY `mdl_assiuserflag_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='List of flags that can be set for a single user in a single ';

--
-- Dumping data for table `mdl_assign_user_flags`
--


--
-- Table structure for table `mdl_assign_user_mapping`
--

CREATE TABLE `mdl_assign_user_mapping` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_assiusermapp_ass_ix` (`assignment`),
  KEY `mdl_assiusermapp_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Map an assignment specific id number to a user';

--
-- Dumping data for table `mdl_assign_user_mapping`
--


--
-- Table structure for table `mdl_assignfeedback_comments`
--

CREATE TABLE `mdl_assignfeedback_comments` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `grade` bigint(10) NOT NULL DEFAULT 0,
  `commenttext` longtext DEFAULT NULL,
  `commentformat` smallint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_assicomm_ass_ix` (`assignment`),
  KEY `mdl_assicomm_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Text feedback for submitted assignments';

--
-- Dumping data for table `mdl_assignfeedback_comments`
--


--
-- Table structure for table `mdl_assignfeedback_editpdf_annot`
--

CREATE TABLE `mdl_assignfeedback_editpdf_annot` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `gradeid` bigint(10) NOT NULL DEFAULT 0,
  `pageno` bigint(10) NOT NULL DEFAULT 0,
  `x` bigint(10) DEFAULT 0,
  `y` bigint(10) DEFAULT 0,
  `endx` bigint(10) DEFAULT 0,
  `endy` bigint(10) DEFAULT 0,
  `path` longtext DEFAULT NULL,
  `type` varchar(10) DEFAULT 'line',
  `colour` varchar(10) DEFAULT 'black',
  `draft` tinyint(2) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `mdl_assieditanno_grapag_ix` (`gradeid`,`pageno`),
  KEY `mdl_assieditanno_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='stores annotations added to pdfs submitted by students';

--
-- Dumping data for table `mdl_assignfeedback_editpdf_annot`
--


--
-- Table structure for table `mdl_assignfeedback_editpdf_cmnt`
--

CREATE TABLE `mdl_assignfeedback_editpdf_cmnt` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `gradeid` bigint(10) NOT NULL DEFAULT 0,
  `x` bigint(10) DEFAULT 0,
  `y` bigint(10) DEFAULT 0,
  `width` bigint(10) DEFAULT 120,
  `rawtext` longtext DEFAULT NULL,
  `pageno` bigint(10) NOT NULL DEFAULT 0,
  `colour` varchar(10) DEFAULT 'black',
  `draft` tinyint(2) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `mdl_assieditcmnt_grapag_ix` (`gradeid`,`pageno`),
  KEY `mdl_assieditcmnt_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores comments added to pdfs';

--
-- Dumping data for table `mdl_assignfeedback_editpdf_cmnt`
--


--
-- Table structure for table `mdl_assignfeedback_editpdf_quick`
--

CREATE TABLE `mdl_assignfeedback_editpdf_quick` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `rawtext` longtext NOT NULL,
  `width` bigint(10) NOT NULL DEFAULT 120,
  `colour` varchar(10) DEFAULT 'yellow',
  PRIMARY KEY (`id`),
  KEY `mdl_assieditquic_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores teacher specified quicklist comments';

--
-- Dumping data for table `mdl_assignfeedback_editpdf_quick`
--


--
-- Table structure for table `mdl_assignfeedback_editpdf_rot`
--

CREATE TABLE `mdl_assignfeedback_editpdf_rot` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `gradeid` bigint(10) NOT NULL DEFAULT 0,
  `pageno` bigint(10) NOT NULL DEFAULT 0,
  `pathnamehash` longtext NOT NULL,
  `isrotated` tinyint(1) NOT NULL DEFAULT 0,
  `degree` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_assieditrot_grapag_uix` (`gradeid`,`pageno`),
  KEY `mdl_assieditrot_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores rotation information of a page.';

--
-- Dumping data for table `mdl_assignfeedback_editpdf_rot`
--


--
-- Table structure for table `mdl_assignfeedback_file`
--

CREATE TABLE `mdl_assignfeedback_file` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `grade` bigint(10) NOT NULL DEFAULT 0,
  `numfiles` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_assifile_ass2_ix` (`assignment`),
  KEY `mdl_assifile_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores info about the number of files submitted by a student';

--
-- Dumping data for table `mdl_assignfeedback_file`
--


--
-- Table structure for table `mdl_assignsubmission_file`
--

CREATE TABLE `mdl_assignsubmission_file` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `submission` bigint(10) NOT NULL DEFAULT 0,
  `numfiles` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_assifile_ass_ix` (`assignment`),
  KEY `mdl_assifile_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Info about file submissions for assignments';

--
-- Dumping data for table `mdl_assignsubmission_file`
--


--
-- Table structure for table `mdl_assignsubmission_onlinetext`
--

CREATE TABLE `mdl_assignsubmission_onlinetext` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assignment` bigint(10) NOT NULL DEFAULT 0,
  `submission` bigint(10) NOT NULL DEFAULT 0,
  `onlinetext` longtext DEFAULT NULL,
  `onlineformat` smallint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_assionli_ass_ix` (`assignment`),
  KEY `mdl_assionli_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Info about onlinetext submission';

--
-- Dumping data for table `mdl_assignsubmission_onlinetext`
--


--
-- Table structure for table `mdl_auth_lti_linked_login`
--

CREATE TABLE `mdl_auth_lti_linked_login` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `issuer` longtext NOT NULL,
  `issuer256` varchar(64) NOT NULL DEFAULT '',
  `sub` varchar(255) NOT NULL DEFAULT '',
  `sub256` varchar(64) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_authltilinklogi_useiss_uix` (`userid`,`issuer256`,`sub256`),
  KEY `mdl_authltilinklogi_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Accounts linked to a users Moodle account.';

--
-- Dumping data for table `mdl_auth_lti_linked_login`
--


--
-- Table structure for table `mdl_auth_oauth2_linked_login`
--

CREATE TABLE `mdl_auth_oauth2_linked_login` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `username` varchar(255) NOT NULL DEFAULT '',
  `email` longtext NOT NULL,
  `confirmtoken` varchar(64) NOT NULL DEFAULT '',
  `confirmtokenexpires` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_authoautlinklogi_useis_uix` (`userid`,`issuerid`,`username`),
  KEY `mdl_authoautlinklogi_issuse_ix` (`issuerid`,`username`),
  KEY `mdl_authoautlinklogi_use_ix` (`usermodified`),
  KEY `mdl_authoautlinklogi_use2_ix` (`userid`),
  KEY `mdl_authoautlinklogi_iss_ix` (`issuerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Accounts linked to a users Moodle account.';

--
-- Dumping data for table `mdl_auth_oauth2_linked_login`
--


--
-- Table structure for table `mdl_backup_controllers`
--

CREATE TABLE `mdl_backup_controllers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `backupid` varchar(32) NOT NULL DEFAULT '',
  `operation` varchar(20) NOT NULL DEFAULT 'backup',
  `type` varchar(10) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `format` varchar(20) NOT NULL DEFAULT '',
  `interactive` smallint(4) NOT NULL,
  `purpose` smallint(4) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `status` smallint(4) NOT NULL,
  `execution` smallint(4) NOT NULL,
  `executiontime` bigint(10) NOT NULL,
  `checksum` varchar(32) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `progress` decimal(15,14) NOT NULL DEFAULT 0.00000000000000,
  `controller` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_backcont_bac_uix` (`backupid`),
  KEY `mdl_backcont_typite_ix` (`type`,`itemid`),
  KEY `mdl_backcont_useite_ix` (`userid`,`itemid`),
  KEY `mdl_backcont_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='To store the backup_controllers as they are used';

--
-- Dumping data for table `mdl_backup_controllers`
--


--
-- Table structure for table `mdl_backup_courses`
--

CREATE TABLE `mdl_backup_courses` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT 0,
  `laststarttime` bigint(10) NOT NULL DEFAULT 0,
  `lastendtime` bigint(10) NOT NULL DEFAULT 0,
  `laststatus` varchar(1) NOT NULL DEFAULT '5',
  `nextstarttime` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_backcour_cou_uix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='To store every course backup status';

--
-- Dumping data for table `mdl_backup_courses`
--


--
-- Table structure for table `mdl_backup_logs`
--

CREATE TABLE `mdl_backup_logs` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `backupid` varchar(32) NOT NULL DEFAULT '',
  `loglevel` smallint(4) NOT NULL,
  `message` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_backlogs_bacid_uix` (`backupid`,`id`),
  KEY `mdl_backlogs_bac_ix` (`backupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='To store all the logs from backup and restore operations (by';

--
-- Dumping data for table `mdl_backup_logs`
--


--
-- Table structure for table `mdl_badge`
--

CREATE TABLE `mdl_badge` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `usercreated` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `issuername` varchar(255) NOT NULL DEFAULT '',
  `issuerurl` varchar(255) NOT NULL DEFAULT '',
  `issuercontact` varchar(255) DEFAULT NULL,
  `expiredate` bigint(10) DEFAULT NULL,
  `expireperiod` bigint(10) DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 1,
  `courseid` bigint(10) DEFAULT NULL,
  `message` longtext NOT NULL,
  `messagesubject` longtext NOT NULL,
  `attachment` tinyint(1) NOT NULL DEFAULT 1,
  `notification` tinyint(1) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `nextcron` bigint(10) DEFAULT NULL,
  `version` varchar(255) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `imagecaption` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_badg_typ_ix` (`type`),
  KEY `mdl_badg_cou_ix` (`courseid`),
  KEY `mdl_badg_use_ix` (`usermodified`),
  KEY `mdl_badg_use2_ix` (`usercreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines badge';

--
-- Dumping data for table `mdl_badge`
--


--
-- Table structure for table `mdl_badge_alignment`
--

CREATE TABLE `mdl_badge_alignment` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `badgeid` bigint(10) NOT NULL DEFAULT 0,
  `targetname` varchar(255) NOT NULL DEFAULT '',
  `targeturl` varchar(255) NOT NULL DEFAULT '',
  `targetdescription` longtext DEFAULT NULL,
  `targetframework` varchar(255) DEFAULT NULL,
  `targetcode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_badgalig_bad_ix` (`badgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines alignment for badges';

--
-- Dumping data for table `mdl_badge_alignment`
--


--
-- Table structure for table `mdl_badge_backpack`
--

CREATE TABLE `mdl_badge_backpack` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `email` varchar(100) NOT NULL DEFAULT '',
  `backpackuid` bigint(10) NOT NULL,
  `autosync` tinyint(1) NOT NULL DEFAULT 0,
  `password` varchar(50) DEFAULT NULL,
  `externalbackpackid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_badgback_useext_uix` (`userid`,`externalbackpackid`),
  KEY `mdl_badgback_use_ix` (`userid`),
  KEY `mdl_badgback_ext_ix` (`externalbackpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines settings for connecting external backpack';

--
-- Dumping data for table `mdl_badge_backpack`
--


--
-- Table structure for table `mdl_badge_backpack_oauth2`
--

CREATE TABLE `mdl_badge_backpack_oauth2` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `externalbackpackid` bigint(10) NOT NULL,
  `token` longtext NOT NULL,
  `refreshtoken` longtext NOT NULL,
  `expires` bigint(10) DEFAULT NULL,
  `scope` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_badgbackoaut_use_ix` (`usermodified`),
  KEY `mdl_badgbackoaut_use2_ix` (`userid`),
  KEY `mdl_badgbackoaut_iss_ix` (`issuerid`),
  KEY `mdl_badgbackoaut_ext_ix` (`externalbackpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Default comment for the table, please edit me';

--
-- Dumping data for table `mdl_badge_backpack_oauth2`
--


--
-- Table structure for table `mdl_badge_criteria`
--

CREATE TABLE `mdl_badge_criteria` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `badgeid` bigint(10) NOT NULL DEFAULT 0,
  `criteriatype` bigint(10) DEFAULT NULL,
  `method` tinyint(1) NOT NULL DEFAULT 1,
  `description` longtext DEFAULT NULL,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_badgcrit_badcri_uix` (`badgeid`,`criteriatype`),
  KEY `mdl_badgcrit_cri_ix` (`criteriatype`),
  KEY `mdl_badgcrit_bad_ix` (`badgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines criteria for issuing badges';

--
-- Dumping data for table `mdl_badge_criteria`
--


--
-- Table structure for table `mdl_badge_criteria_met`
--

CREATE TABLE `mdl_badge_criteria_met` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `issuedid` bigint(10) DEFAULT NULL,
  `critid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `datemet` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_badgcritmet_cri_ix` (`critid`),
  KEY `mdl_badgcritmet_use_ix` (`userid`),
  KEY `mdl_badgcritmet_iss_ix` (`issuedid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines criteria that were met for an issued badge';

--
-- Dumping data for table `mdl_badge_criteria_met`
--


--
-- Table structure for table `mdl_badge_criteria_param`
--

CREATE TABLE `mdl_badge_criteria_param` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `critid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_badgcritpara_cri_ix` (`critid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines parameters for badges criteria';

--
-- Dumping data for table `mdl_badge_criteria_param`
--


--
-- Table structure for table `mdl_badge_endorsement`
--

CREATE TABLE `mdl_badge_endorsement` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `badgeid` bigint(10) NOT NULL DEFAULT 0,
  `issuername` varchar(255) NOT NULL DEFAULT '',
  `issuerurl` varchar(255) NOT NULL DEFAULT '',
  `issueremail` varchar(255) NOT NULL DEFAULT '',
  `claimid` varchar(255) DEFAULT NULL,
  `claimcomment` longtext DEFAULT NULL,
  `dateissued` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_badgendo_bad_ix` (`badgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines endorsement for badge';

--
-- Dumping data for table `mdl_badge_endorsement`
--


--
-- Table structure for table `mdl_badge_external`
--

CREATE TABLE `mdl_badge_external` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `backpackid` bigint(10) NOT NULL,
  `collectionid` bigint(10) NOT NULL,
  `entityid` varchar(255) DEFAULT NULL,
  `assertion` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_badgexte_bac_ix` (`backpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Setting for external badges display';

--
-- Dumping data for table `mdl_badge_external`
--


--
-- Table structure for table `mdl_badge_external_identifier`
--

CREATE TABLE `mdl_badge_external_identifier` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `sitebackpackid` bigint(10) NOT NULL,
  `internalid` varchar(128) NOT NULL DEFAULT '',
  `externalid` varchar(128) NOT NULL DEFAULT '',
  `type` varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_badgexteiden_sitintext_uix` (`sitebackpackid`,`internalid`,`externalid`,`type`),
  KEY `mdl_badgexteiden_sit_ix` (`sitebackpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Setting for external badges mappings';

--
-- Dumping data for table `mdl_badge_external_identifier`
--


--
-- Table structure for table `mdl_badge_issued`
--

CREATE TABLE `mdl_badge_issued` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `badgeid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `uniquehash` longtext NOT NULL,
  `dateissued` bigint(10) NOT NULL DEFAULT 0,
  `dateexpire` bigint(10) DEFAULT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT 0,
  `issuernotified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_badgissu_baduse_uix` (`badgeid`,`userid`),
  KEY `mdl_badgissu_bad_ix` (`badgeid`),
  KEY `mdl_badgissu_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines issued badges';

--
-- Dumping data for table `mdl_badge_issued`
--


--
-- Table structure for table `mdl_badge_manual_award`
--

CREATE TABLE `mdl_badge_manual_award` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `badgeid` bigint(10) NOT NULL,
  `recipientid` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `issuerrole` bigint(10) NOT NULL,
  `datemet` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_badgmanuawar_bad_ix` (`badgeid`),
  KEY `mdl_badgmanuawar_rec_ix` (`recipientid`),
  KEY `mdl_badgmanuawar_iss_ix` (`issuerid`),
  KEY `mdl_badgmanuawar_iss2_ix` (`issuerrole`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Track manual award criteria for badges';

--
-- Dumping data for table `mdl_badge_manual_award`
--


--
-- Table structure for table `mdl_badge_related`
--

CREATE TABLE `mdl_badge_related` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `badgeid` bigint(10) NOT NULL DEFAULT 0,
  `relatedbadgeid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_badgrela_badrel_uix` (`badgeid`,`relatedbadgeid`),
  KEY `mdl_badgrela_bad_ix` (`badgeid`),
  KEY `mdl_badgrela_rel_ix` (`relatedbadgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Defines badge related for badges';

--
-- Dumping data for table `mdl_badge_related`
--


--
-- Table structure for table `mdl_bigbluebuttonbn`
--

CREATE TABLE `mdl_bigbluebuttonbn` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) NOT NULL DEFAULT 0,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext DEFAULT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 1,
  `meetingid` varchar(255) NOT NULL DEFAULT '',
  `moderatorpass` varchar(255) NOT NULL DEFAULT '',
  `viewerpass` varchar(255) NOT NULL DEFAULT '',
  `wait` tinyint(1) NOT NULL DEFAULT 0,
  `record` tinyint(1) NOT NULL DEFAULT 0,
  `recordallfromstart` tinyint(1) NOT NULL DEFAULT 0,
  `recordhidebutton` tinyint(1) NOT NULL DEFAULT 0,
  `welcome` longtext DEFAULT NULL,
  `voicebridge` mediumint(5) NOT NULL DEFAULT 0,
  `openingtime` bigint(10) NOT NULL DEFAULT 0,
  `closingtime` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `presentation` longtext DEFAULT NULL,
  `participants` longtext DEFAULT NULL,
  `userlimit` smallint(3) NOT NULL DEFAULT 0,
  `recordings_html` tinyint(1) NOT NULL DEFAULT 0,
  `recordings_deleted` tinyint(1) NOT NULL DEFAULT 1,
  `recordings_imported` tinyint(1) NOT NULL DEFAULT 0,
  `recordings_preview` tinyint(1) NOT NULL DEFAULT 0,
  `clienttype` tinyint(1) NOT NULL DEFAULT 0,
  `muteonstart` tinyint(1) NOT NULL DEFAULT 0,
  `disablecam` tinyint(1) NOT NULL DEFAULT 0,
  `disablemic` tinyint(1) NOT NULL DEFAULT 0,
  `disableprivatechat` tinyint(1) NOT NULL DEFAULT 0,
  `disablepublicchat` tinyint(1) NOT NULL DEFAULT 0,
  `disablenote` tinyint(1) NOT NULL DEFAULT 0,
  `hideuserlist` tinyint(1) NOT NULL DEFAULT 0,
  `completionattendance` int(9) NOT NULL DEFAULT 0,
  `completionengagementchats` int(9) NOT NULL DEFAULT 0,
  `completionengagementtalks` int(9) NOT NULL DEFAULT 0,
  `completionengagementraisehand` int(9) NOT NULL DEFAULT 0,
  `completionengagementpollvotes` int(9) NOT NULL DEFAULT 0,
  `completionengagementemojis` int(9) NOT NULL DEFAULT 0,
  `guestallowed` tinyint(2) DEFAULT 0,
  `mustapproveuser` tinyint(2) DEFAULT 1,
  `guestlinkuid` varchar(1024) DEFAULT NULL,
  `guestpassword` varchar(255) DEFAULT NULL,
  `showpresentation` tinyint(1) NOT NULL DEFAULT 1,
  `grade` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The bigbluebuttonbn table to store information about a meeti';

--
-- Dumping data for table `mdl_bigbluebuttonbn`
--


--
-- Table structure for table `mdl_bigbluebuttonbn_logs`
--

CREATE TABLE `mdl_bigbluebuttonbn_logs` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `bigbluebuttonbnid` bigint(10) NOT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `meetingid` varchar(256) NOT NULL DEFAULT '',
  `log` varchar(32) NOT NULL DEFAULT '',
  `meta` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_bigblogs_cou_ix` (`courseid`),
  KEY `mdl_bigblogs_log_ix` (`log`),
  KEY `mdl_bigblogs_coubiguselog_ix` (`courseid`,`bigbluebuttonbnid`,`userid`,`log`),
  KEY `mdl_bigblogs_uselog_ix` (`userid`,`log`),
  KEY `mdl_bigblogs_coubig_ix` (`courseid`,`bigbluebuttonbnid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The bigbluebuttonbn table to store meeting activity events';

--
-- Dumping data for table `mdl_bigbluebuttonbn_logs`
--


--
-- Table structure for table `mdl_bigbluebuttonbn_recordings`
--

CREATE TABLE `mdl_bigbluebuttonbn_recordings` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `bigbluebuttonbnid` bigint(10) NOT NULL,
  `groupid` bigint(10) DEFAULT NULL,
  `recordingid` varchar(64) NOT NULL DEFAULT '',
  `headless` tinyint(1) NOT NULL DEFAULT 0,
  `imported` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `importeddata` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `usermodified` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_bigbreco_cou_ix` (`courseid`),
  KEY `mdl_bigbreco_rec_ix` (`recordingid`),
  KEY `mdl_bigbreco_big_ix` (`bigbluebuttonbnid`),
  KEY `mdl_bigbreco_use_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The bigbluebuttonbn table to store references to recordings';

--
-- Dumping data for table `mdl_bigbluebuttonbn_recordings`
--


--
-- Table structure for table `mdl_block`
--

CREATE TABLE `mdl_block` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL DEFAULT '',
  `cron` bigint(10) NOT NULL DEFAULT 0,
  `lastcron` bigint(10) NOT NULL DEFAULT 0,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_bloc_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='contains all installed blocks';

--
-- Dumping data for table `mdl_block`
--

INSERT INTO `mdl_block` VALUES (1,'accessreview',0,0,1),(2,'activity_modules',0,0,1),(3,'activity_results',0,0,1),(4,'admin_bookmarks',0,0,1),(5,'badges',0,0,1),(6,'blog_menu',0,0,1),(7,'blog_recent',0,0,1),(8,'blog_tags',0,0,1),(9,'calendar_month',0,0,1),(10,'calendar_upcoming',0,0,1),(11,'comments',0,0,1),(12,'completionstatus',0,0,1),(13,'course_list',0,0,1),(14,'course_summary',0,0,0),(15,'feedback',0,0,0),(16,'globalsearch',0,0,1),(17,'glossary_random',0,0,1),(18,'html',0,0,1),(19,'login',0,0,1),(20,'lp',0,0,1),(21,'mentees',0,0,1),(22,'myoverview',0,0,1),(23,'myprofile',0,0,1),(24,'navigation',0,0,1),(25,'news_items',0,0,1),(26,'online_users',0,0,1),(27,'private_files',0,0,1),(28,'recent_activity',0,0,1),(29,'recentlyaccessedcourses',0,0,1),(30,'recentlyaccesseditems',0,0,1),(31,'rss_client',0,0,0),(32,'search_forums',0,0,1),(33,'section_links',0,0,1),(34,'selfcompletion',0,0,0),(35,'settings',0,0,1),(36,'site_main_menu',0,0,1),(37,'social_activities',0,0,1),(38,'starredcourses',0,0,1),(39,'tag_flickr',0,0,1),(40,'tag_youtube',0,0,0),(41,'tags',0,0,1),(42,'timeline',0,0,1),(43,'miflora_student',0,0,1);

--
-- Table structure for table `mdl_block_instances`
--

CREATE TABLE `mdl_block_instances` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `blockname` varchar(40) NOT NULL DEFAULT '',
  `parentcontextid` bigint(10) NOT NULL,
  `showinsubcontexts` smallint(4) NOT NULL,
  `requiredbytheme` smallint(4) NOT NULL DEFAULT 0,
  `pagetypepattern` varchar(64) NOT NULL DEFAULT '',
  `subpagepattern` varchar(16) DEFAULT NULL,
  `defaultregion` varchar(16) NOT NULL DEFAULT '',
  `defaultweight` bigint(10) NOT NULL,
  `configdata` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_blocinst_parshopagsub_ix` (`parentcontextid`,`showinsubcontexts`,`pagetypepattern`,`subpagepattern`),
  KEY `mdl_blocinst_tim_ix` (`timemodified`),
  KEY `mdl_blocinst_blo_ix` (`blockname`),
  KEY `mdl_blocinst_par_ix` (`parentcontextid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table stores block instances. The type of block this is';

--
-- Dumping data for table `mdl_block_instances`
--

INSERT INTO `mdl_block_instances` VALUES (1,'admin_bookmarks',1,0,0,'admin-*',NULL,'side-pre',2,'',1785888406,1785888406),(2,'recentlyaccesseditems',1,0,0,'my-index','2','side-post',0,'',1785888406,1785888406),(3,'timeline',1,0,0,'my-index','2','content',0,'',1785888406,1785888406),(4,'calendar_month',1,0,0,'my-index','2','content',1,'',1785888406,1785888406),(5,'myoverview',1,0,0,'my-index','3','content',0,'',1785888406,1785888406),(6,'recentlyaccesseditems',5,0,0,'my-index','4','side-post',0,'',1785888931,1785888931),(7,'timeline',5,0,0,'my-index','4','content',0,'',1785888931,1785888931),(8,'calendar_month',5,0,0,'my-index','4','content',1,'',1785888931,1785888931),(9,'navigation',1,1,1,'*',NULL,'side-pre',0,'',1785891958,1785891958),(10,'settings',1,1,1,'*',NULL,'side-pre',0,'',1785891958,1785891958),(11,'recentlyaccesseditems',20,0,0,'my-index','6','side-post',0,'',1785892172,1785892172),(12,'timeline',20,0,0,'my-index','6','content',0,'',1785892172,1785892172),(13,'calendar_month',20,0,0,'my-index','6','content',1,'',1785892172,1785892172);

--
-- Table structure for table `mdl_block_positions`
--

CREATE TABLE `mdl_block_positions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `blockinstanceid` bigint(10) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `pagetype` varchar(64) NOT NULL DEFAULT '',
  `subpage` varchar(16) NOT NULL DEFAULT '',
  `visible` smallint(4) NOT NULL,
  `region` varchar(16) NOT NULL DEFAULT '',
  `weight` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_blocposi_bloconpagsub_uix` (`blockinstanceid`,`contextid`,`pagetype`,`subpage`),
  KEY `mdl_blocposi_blo_ix` (`blockinstanceid`),
  KEY `mdl_blocposi_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the position of a sticky block_instance on a another ';

--
-- Dumping data for table `mdl_block_positions`
--


--
-- Table structure for table `mdl_block_recent_activity`
--

CREATE TABLE `mdl_block_recent_activity` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `cmid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `action` tinyint(1) NOT NULL,
  `modname` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_blocreceacti_coutim_ix` (`courseid`,`timecreated`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Recent activity block';

--
-- Dumping data for table `mdl_block_recent_activity`
--

INSERT INTO `mdl_block_recent_activity` VALUES (1,13,12,1785896441,2,0,NULL),(2,13,12,1785896595,2,1,NULL),(3,13,12,1785896918,2,1,NULL);

--
-- Table structure for table `mdl_block_recentlyaccesseditems`
--

CREATE TABLE `mdl_block_recentlyaccesseditems` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `cmid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timeaccess` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_blocrece_usecoucmi_uix` (`userid`,`courseid`,`cmid`),
  KEY `mdl_blocrece_use_ix` (`userid`),
  KEY `mdl_blocrece_cou_ix` (`courseid`),
  KEY `mdl_blocrece_cmi_ix` (`cmid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Most recently accessed items accessed by a user';

--
-- Dumping data for table `mdl_block_recentlyaccesseditems`
--

INSERT INTO `mdl_block_recentlyaccesseditems` VALUES (1,13,12,2,1785898852),(2,13,12,3,1785958045);

--
-- Table structure for table `mdl_block_rss_client`
--

CREATE TABLE `mdl_block_rss_client` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `title` longtext NOT NULL,
  `preferredtitle` varchar(64) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `shared` tinyint(2) NOT NULL DEFAULT 0,
  `url` varchar(255) NOT NULL DEFAULT '',
  `skiptime` bigint(10) NOT NULL DEFAULT 0,
  `skipuntil` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Remote news feed information. Contains the news feed id, the';

--
-- Dumping data for table `mdl_block_rss_client`
--


--
-- Table structure for table `mdl_blog_association`
--

CREATE TABLE `mdl_blog_association` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `blogid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_blogasso_con_ix` (`contextid`),
  KEY `mdl_blogasso_blo_ix` (`blogid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Associations of blog entries with courses and module instanc';

--
-- Dumping data for table `mdl_blog_association`
--


--
-- Table structure for table `mdl_blog_external`
--

CREATE TABLE `mdl_blog_external` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `url` longtext NOT NULL,
  `filtertags` varchar(255) DEFAULT NULL,
  `failedlastsync` tinyint(1) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) DEFAULT NULL,
  `timefetched` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_blogexte_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='External blog links used for RSS copying of blog entries to ';

--
-- Dumping data for table `mdl_blog_external`
--


--
-- Table structure for table `mdl_book`
--

CREATE TABLE `mdl_book` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `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';

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


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

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';

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


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

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';

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


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

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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Cache of time-sensitive flags';

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

INSERT INTO `mdl_cache_flags` VALUES (1,'userpreferenceschanged','2',1786148579,'1',1786177379),(2,'accesslib/dirtycontexts','/1/15/14',1785889561,'1',1785918361),(3,'userpreferenceschanged','3',1786148685,'1',1786177485),(4,'accesslib/dirtyusers','2',1785894640,'1',1785923440),(5,'accesslib/dirtyusers','3',1785971077,'1',1785999877);

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

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=769 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='this defines all capabilities';

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

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

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

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';

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


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

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';

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


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

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';

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


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

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).';

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


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

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.';

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


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

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';

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


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

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';

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


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

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 ';

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


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

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';

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


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

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 ';

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


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

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.';

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


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

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';

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


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

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';

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


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

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.';

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


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

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.';

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


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

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';

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


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

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';

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


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

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';

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


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

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.';

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


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

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';

--
-- Dumping data for table `mdl_competency_templatecohort`
--


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

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.';

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


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

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';

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


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

CREATE TABLE `mdl_competency_usercompcourse` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `competencyid` bigint(10) NOT 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_usecoucom_uix` (`userid`,`courseid`,`competencyid`),
  KEY `mdl_compuser_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='User competencies in a course';

--
-- Dumping data for table `mdl_competency_usercompcourse`
--


--
-- Table structure for table `mdl_competency_usercompplan`
--

CREATE TABLE `mdl_competency_usercompplan` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `competencyid` bigint(10) NOT NULL,
  `planid` bigint(10) NOT NULL,
  `proficiency` tinyint(2) DEFAULT NULL,
  `grade` bigint(10) DEFAULT 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_compuser_usecompla_uix` (`userid`,`competencyid`,`planid`),
  KEY `mdl_compuser_use3_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='User competencies plans';

--
-- Dumping data for table `mdl_competency_usercompplan`
--


--
-- Table structure for table `mdl_competency_userevidence`
--

CREATE TABLE `mdl_competency_userevidence` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `descriptionformat` tinyint(1) NOT NULL,
  `url` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_compuser_use4_ix` (`userid`),
  KEY `mdl_compuser_use5_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='The evidence of prior learning';

--
-- Dumping data for table `mdl_competency_userevidence`
--


--
-- Table structure for table `mdl_competency_userevidencecomp`
--

CREATE TABLE `mdl_competency_userevidencecomp` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userevidenceid` bigint(10) NOT NULL,
  `competencyid` 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_compuser_usecom2_uix` (`userevidenceid`,`competencyid`),
  KEY `mdl_compuser_use6_ix` (`userevidenceid`),
  KEY `mdl_compuser_use7_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Relationship between user evidence and competencies';

--
-- Dumping data for table `mdl_competency_userevidencecomp`
--


--
-- Table structure for table `mdl_config`
--

CREATE TABLE `mdl_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_conf_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=631 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Moodle configuration variables';

--
-- Dumping data for table `mdl_config`
--

INSERT INTO `mdl_config` VALUES (2,'rolesactive','1'),(3,'auth','email'),(4,'enrol_plugins_enabled','manual,guest,self,cohort'),(5,'theme','miflora'),(6,'filter_multilang_converted','1'),(7,'siteidentifier','HYsDay1m25ppYTsSmpKdCddj8bAQfKCAlocalhost'),(8,'backup_version','2008111700'),(9,'backup_release','2.0 dev'),(10,'mnet_dispatcher_mode','off'),(11,'sessiontimeout','28800'),(12,'stringfilters',''),(13,'filterall','0'),(14,'texteditors','tiny,textarea'),(15,'antiviruses',''),(16,'media_plugins_sortorder','videojs,youtube'),(17,'upgrade_extracreditweightsstepignored','1'),(18,'upgrade_calculatedgradeitemsignored','1'),(19,'upgrade_letterboundarycourses','1'),(20,'format_plugins_sortorder','topics,weeks,singleactivity,social'),(21,'mnet_localhost_id','1'),(22,'mnet_all_hosts_id','2'),(23,'siteguest','1'),(24,'siteadmins','2'),(25,'themerev','1785982919'),(26,'jsrev','1785982919'),(27,'templaterev','1785982919'),(28,'gdversion','2'),(29,'licenses','unknown,allrightsreserved,public,cc-4.0,cc-nc-4.0,cc-nd-4.0,cc-nc-nd-4.0,cc-nc-sa-4.0,cc-sa-4.0'),(30,'sitedefaultlicense','unknown'),(31,'version','2025041408.07'),(32,'enableuserfeedback','0'),(33,'userfeedback_nextreminder','1'),(34,'userfeedback_remindafter','90'),(35,'enableoutcomes','0'),(36,'usecomments','1'),(37,'usetags','1'),(38,'enablenotes','1'),(39,'enableportfolios','0'),(40,'enablewebservices','0'),(41,'enablestats','0'),(42,'enablerssfeeds','0'),(43,'enableblogs','1'),(44,'enablecompletion','1'),(45,'enableavailability','1'),(46,'enableplagiarism','0'),(47,'enablebadges','1'),(48,'enableglobalsearch','0'),(49,'allowstealth','0'),(50,'enableanalytics','0'),(51,'messaging','1'),(52,'enablecustomreports','1'),(53,'allowemojipicker','1'),(54,'userfiltersdefault','realname'),(55,'defaultpreference_maildisplay','2'),(56,'defaultpreference_mailformat','1'),(57,'defaultpreference_maildigest','0'),(58,'defaultpreference_autosubscribe','1'),(59,'defaultpreference_trackforums','0'),(60,'defaultpreference_core_contentbank_visibility','1'),(61,'enroladminnewcourse','1'),(62,'autologinguests','0'),(63,'hiddenuserfields',''),(64,'showuseridentity','email'),(65,'fullnamedisplay','language'),(66,'alternativefullnameformat','language'),(67,'maxusersperpage','100'),(68,'enablegravatar','0'),(69,'gravatardefaulturl','mm'),(70,'agedigitalconsentverification','0'),(71,'agedigitalconsentmap','*, 16\r\nAT, 14\r\nBE, 13\r\nBG, 14\r\nCY, 14\r\nCZ, 15\r\nDK, 13\r\nEE, 13\r\nES, 14\r\nFI, 13\r\nFR, 15\r\nGB, 13\r\nGR, 15\r\nIT, 14\r\nLT, 14\r\nLV, 13\r\nMT, 13\r\nNO, 13\r\nPT, 13\r\nSE, 13\r\nUS, 13'),(72,'sitepolicy',''),(73,'sitepolicyguest',''),(74,'activitychoosertabmode','3'),(75,'activitychooseractivefooter','hidden'),(76,'enableasyncbackup','1'),(77,'downloadcoursecontentallowed','0'),(78,'maxsizeperdownloadcoursefile','52428800'),(79,'enablecourserequests','1'),(80,'defaultrequestcategory','3'),(81,'lockrequestcategory','0'),(82,'courserequestnotify',''),(83,'grade_report_showonlyactiveenrol','1'),(84,'grade_report_quickgrading','1'),(85,'grade_report_meanselection','1'),(86,'grade_report_showaverages','1'),(87,'grade_report_showranges','0'),(88,'grade_report_showuserimage','1'),(89,'grade_report_shownumberofgrades','0'),(90,'grade_report_averagesdisplaytype','inherit'),(91,'grade_report_rangesdisplaytype','inherit'),(92,'grade_report_averagesdecimalpoints','inherit'),(93,'grade_report_rangesdecimalpoints','inherit'),(94,'grade_report_historyperpage','50'),(95,'grade_report_overview_showrank','0'),(96,'grade_report_overview_showtotalsifcontainhidden','0'),(97,'grade_report_user_showrank','0'),(98,'grade_report_user_showpercentage','1'),(99,'grade_report_user_showgrade','1'),(100,'grade_report_user_showfeedback','1'),(101,'grade_report_user_showrange','1'),(102,'grade_report_user_showweight','1'),(103,'grade_report_user_showaverage','0'),(104,'grade_report_user_showlettergrade','0'),(105,'grade_report_user_rangedecimals','0'),(106,'grade_report_user_showhiddenitems','1'),(107,'grade_report_user_showtotalsifcontainhidden','0'),(108,'grade_report_user_showcontributiontocoursetotal','1'),(109,'gradepenalty_enabledmodules',''),(110,'grade_profilereport','user'),(111,'grade_aggregationposition','1'),(112,'grade_includescalesinaggregation','1'),(113,'grade_hiddenasdate','0'),(114,'gradepublishing','0'),(115,'grade_export_exportfeedback','0'),(116,'grade_export_displaytype','1'),(117,'grade_export_decimalpoints','2'),(118,'grade_export_userprofilefields','firstname,lastname,idnumber,institution,department,email'),(119,'grade_export_customprofilefields',''),(120,'recovergradesdefault','0'),(121,'gradeexport',''),(122,'gradeexport_default','ods'),(123,'unlimitedgrades','0'),(124,'grade_report_showmin','1'),(125,'gradepointmax','100'),(126,'gradepointdefault','100'),(127,'grade_minmaxtouse','1'),(128,'grade_mygrades_report','overview'),(129,'gradereport_mygradeurl',''),(130,'grade_hideforcedsettings','1'),(131,'grade_aggregation','13'),(132,'grade_aggregation_flag','0'),(133,'grade_aggregations_visible','13'),(134,'grade_aggregateonlygraded','1'),(135,'grade_aggregateonlygraded_flag','0'),(136,'grade_aggregateoutcomes','0'),(137,'grade_aggregateoutcomes_flag','0'),(138,'grade_keephigh','0'),(139,'grade_keephigh_flag','1'),(140,'grade_droplow','0'),(141,'grade_droplow_flag','0'),(142,'grade_overridecat','1'),(143,'grade_displaytype','1'),(144,'grade_decimalpoints','2'),(145,'badges_defaultissuername',''),(146,'badges_defaultissuercontact',''),(147,'badges_badgesalt','badges1785888322'),(148,'badges_allowcoursebadges','1'),(149,'badges_allowexternalbackpack','1'),(150,'badges_canvasregions','Australia|https://au.badgr.io|https://api.au.badgr.io/v2\nCanada|https://ca.badgr.io|https://api.ca.badgr.io/v2\nEurope|https://eu.badgr.io|https://api.eu.badgr.io/v2\nSingapore|https://sg.badgr.io|https://api.sg.badgr.io/v2\nUnited States|https://badgr.io|https://api.badgr.io/v2'),(151,'rememberuserlicensepref','1'),(153,'forcetimezone','99'),(154,'country','PE'),(155,'defaultcity',''),(156,'allcountrycodes',''),(157,'geoip2file','C:\\moodle\\server\\moodledata/geoip/GeoIP-City.mmdb'),(158,'geoipdbedition','GeoLite2-City'),(159,'geoipmaxmindaccid',''),(160,'geoipmaxmindlicensekey',''),(161,'googlemapkey3',''),(162,'geopluginapikey',''),(163,'autolang','1'),(164,'lang','es'),(165,'autolangusercreation','1'),(166,'langmenu','1'),(167,'langlist',''),(168,'langrev','1785982919'),(169,'langcache','1'),(170,'langstringcache','1'),(171,'locale',''),(172,'latinexcelexport','0'),(173,'enablepdfexportfont','0'),(174,'messagingallusers','0'),(175,'messagingdefaultpressenter','1'),(176,'messagingdeletereadnotificationsdelay','604800'),(177,'messagingdeleteallnotificationsdelay','2620800'),(178,'messagingallowemailoverride','0'),(180,'authloginviaemail','0'),(181,'allowaccountssameemail','0'),(182,'authpreventaccountcreation','0'),(183,'loginpageautofocus','0'),(184,'guestloginbutton','1'),(185,'limitconcurrentlogins','0'),(186,'alternateloginurl',''),(187,'showloginform','1'),(188,'forgottenpasswordurl',''),(189,'auth_instructions',''),(190,'allowemailaddresses',''),(191,'denyemailaddresses',''),(192,'verifychangedemail','1'),(193,'enableloginrecaptcha','0'),(194,'recaptchapublickey',''),(195,'recaptchaprivatekey',''),(196,'loginpasswordtoggle','2'),(197,'searchengine','simpledb'),(198,'searchindexwhendisabled','0'),(199,'searchindextime','600'),(200,'searchallavailablecourses','0'),(201,'searchincludeallcourses','0'),(202,'searchenablecategories','0'),(203,'searchdefaultcategory','core-all'),(204,'searchhideallcategory','0'),(205,'searchmaxtopresults','3'),(206,'searchteacherroles',''),(207,'searchenginequeryonly',''),(208,'searchbannerenable','0'),(209,'searchbanner',''),(210,'filteruploadedfiles','0'),(211,'filtermatchoneperpage','0'),(212,'filtermatchonepertext','0'),(213,'filternavigationwithsystemcontext','1'),(214,'requiremodintro','0'),(215,'portfolio_moderate_filesize_threshold','1048576'),(216,'portfolio_high_filesize_threshold','5242880'),(217,'portfolio_moderate_db_threshold','20'),(218,'portfolio_high_db_threshold','50'),(219,'repositorycacheexpire','120'),(220,'repositorygetfiletimeout','30'),(221,'repositorysyncfiletimeout','1'),(222,'repositorysyncimagetimeout','3'),(223,'repositoryallowexternallinks','1'),(224,'legacyfilesinnewcourses','0'),(225,'legacyfilesaddallowed','1'),(226,'media_default_width','640'),(227,'media_default_height','360'),(228,'questiondefaultssave','1'),(229,'allowbeforeblock','0'),(230,'allowedip',''),(231,'blockedip',''),(232,'protectusernames','1'),(233,'forcelogin','0'),(234,'forceloginforprofiles','1'),(235,'forceloginforprofileimage','0'),(236,'opentowebcrawlers','0'),(237,'allowindexing','0'),(238,'maxbytes','0'),(239,'userquota','104857600'),(240,'allowobjectembed','0'),(241,'enabletrusttext','0'),(242,'maxeditingtime','1800'),(243,'extendedusernamechars','0'),(244,'keeptagnamecase','1'),(245,'profilesforenrolledusersonly','1'),(246,'cronclionly','1'),(247,'cronremotepassword',''),(248,'lockoutthreshold','0'),(249,'lockoutwindow','1800'),(250,'lockoutduration','1800'),(251,'passwordpolicy','1'),(252,'minpasswordlength','8'),(253,'minpassworddigits','1'),(254,'minpasswordlower','1'),(255,'minpasswordupper','1'),(256,'minpasswordnonalphanum','1'),(257,'maxconsecutiveidentchars','0'),(258,'passwordpolicycheckonlogin','0'),(259,'passwordreuselimit','0'),(260,'pwresettime','1800'),(261,'passwordchangelogout','1'),(262,'passwordchangetokendeletion','0'),(263,'tokenduration','7257600'),(264,'groupenrolmentkeypolicy','1'),(265,'disableuserimages','0'),(266,'emailchangeconfirmation','1'),(267,'rememberusername','2'),(268,'strictformsrequired','0'),(269,'cookiesecure','1'),(270,'allowframembedding','0'),(271,'curlsecurityblockedhosts','127.0.0.0/8\r\n192.168.0.0/16\r\n10.0.0.0/8\r\n172.16.0.0/12\r\n0.0.0.0\r\nlocalhost\r\n169.254.169.254\r\n0000::1'),(272,'curlsecurityallowedport','443\r\n80'),(273,'referrerpolicy','default'),(274,'displayloginfailures','0'),(275,'notifyloginfailures',''),(276,'notifyloginthreshold','10'),(277,'calendartype','gregorian'),(278,'calendar_adminseesall','0'),(279,'calendar_site_timeformat','0'),(280,'calendar_startwday','1'),(281,'calendar_weekend','65'),(282,'calendar_lookahead','21'),(283,'calendar_maxevents','10'),(284,'enablecalendarexport','1'),(285,'calendar_customexport','1'),(286,'calendar_exportlookahead','365'),(287,'calendar_exportlookback','5'),(288,'calendar_exportsalt','3Aawrwglo0xswnpm1vFBHoWAqB6NtLseAT1s7qf0tF33krssDDPY7EDSbRx7'),(289,'calendar_showicalsource','1'),(290,'useblogassociations','1'),(291,'bloglevel','4'),(292,'useexternalblogs','1'),(293,'externalblogcrontime','86400'),(294,'maxexternalblogsperuser','1'),(295,'blogusecomments','1'),(296,'blogshowcommentscount','1'),(297,'enabledashboard','1'),(298,'defaulthomepage','1'),(299,'allowguestmymoodle','1'),(300,'navshowfullcoursenames','0'),(301,'navshowcategories','1'),(302,'navshowmycoursecategories','0'),(303,'navshowallcourses','0'),(304,'navsortmycoursessort','sortorder'),(305,'navsortmycourseshiddenlast','1'),(306,'navcourselimit','10'),(307,'usesitenameforsitepages','0'),(308,'linkadmincategories','1'),(309,'navshowfrontpagemods','1'),(310,'navadduserpostslinks','1'),(311,'sitenameintitle','shortname'),(312,'formatstringstriptags','1'),(313,'emoticons','[{\"text\":\":-)\",\"imagename\":\"s\\/smiley\",\"imagecomponent\":\"core\",\"altidentifier\":\"smiley\",\"altcomponent\":\"core_pix\"},{\"text\":\":)\",\"imagename\":\"s\\/smiley\",\"imagecomponent\":\"core\",\"altidentifier\":\"smiley\",\"altcomponent\":\"core_pix\"},{\"text\":\":-D\",\"imagename\":\"s\\/biggrin\",\"imagecomponent\":\"core\",\"altidentifier\":\"biggrin\",\"altcomponent\":\"core_pix\"},{\"text\":\";-)\",\"imagename\":\"s\\/wink\",\"imagecomponent\":\"core\",\"altidentifier\":\"wink\",\"altcomponent\":\"core_pix\"},{\"text\":\":-\\/\",\"imagename\":\"s\\/mixed\",\"imagecomponent\":\"core\",\"altidentifier\":\"mixed\",\"altcomponent\":\"core_pix\"},{\"text\":\"V-.\",\"imagename\":\"s\\/thoughtful\",\"imagecomponent\":\"core\",\"altidentifier\":\"thoughtful\",\"altcomponent\":\"core_pix\"},{\"text\":\":-P\",\"imagename\":\"s\\/tongueout\",\"imagecomponent\":\"core\",\"altidentifier\":\"tongueout\",\"altcomponent\":\"core_pix\"},{\"text\":\":-p\",\"imagename\":\"s\\/tongueout\",\"imagecomponent\":\"core\",\"altidentifier\":\"tongueout\",\"altcomponent\":\"core_pix\"},{\"text\":\"B-)\",\"imagename\":\"s\\/cool\",\"imagecomponent\":\"core\",\"altidentifier\":\"cool\",\"altcomponent\":\"core_pix\"},{\"text\":\"^-)\",\"imagename\":\"s\\/approve\",\"imagecomponent\":\"core\",\"altidentifier\":\"approve\",\"altcomponent\":\"core_pix\"},{\"text\":\"8-)\",\"imagename\":\"s\\/wideeyes\",\"imagecomponent\":\"core\",\"altidentifier\":\"wideeyes\",\"altcomponent\":\"core_pix\"},{\"text\":\":o)\",\"imagename\":\"s\\/clown\",\"imagecomponent\":\"core\",\"altidentifier\":\"clown\",\"altcomponent\":\"core_pix\"},{\"text\":\":-(\",\"imagename\":\"s\\/sad\",\"imagecomponent\":\"core\",\"altidentifier\":\"sad\",\"altcomponent\":\"core_pix\"},{\"text\":\":(\",\"imagename\":\"s\\/sad\",\"imagecomponent\":\"core\",\"altidentifier\":\"sad\",\"altcomponent\":\"core_pix\"},{\"text\":\"8-.\",\"imagename\":\"s\\/shy\",\"imagecomponent\":\"core\",\"altidentifier\":\"shy\",\"altcomponent\":\"core_pix\"},{\"text\":\":-I\",\"imagename\":\"s\\/blush\",\"imagecomponent\":\"core\",\"altidentifier\":\"blush\",\"altcomponent\":\"core_pix\"},{\"text\":\":-X\",\"imagename\":\"s\\/kiss\",\"imagecomponent\":\"core\",\"altidentifier\":\"kiss\",\"altcomponent\":\"core_pix\"},{\"text\":\"8-o\",\"imagename\":\"s\\/surprise\",\"imagecomponent\":\"core\",\"altidentifier\":\"surprise\",\"altcomponent\":\"core_pix\"},{\"text\":\"P-|\",\"imagename\":\"s\\/blackeye\",\"imagecomponent\":\"core\",\"altidentifier\":\"blackeye\",\"altcomponent\":\"core_pix\"},{\"text\":\"8-[\",\"imagename\":\"s\\/angry\",\"imagecomponent\":\"core\",\"altidentifier\":\"angry\",\"altcomponent\":\"core_pix\"},{\"text\":\"(grr)\",\"imagename\":\"s\\/angry\",\"imagecomponent\":\"core\",\"altidentifier\":\"angry\",\"altcomponent\":\"core_pix\"},{\"text\":\"xx-P\",\"imagename\":\"s\\/dead\",\"imagecomponent\":\"core\",\"altidentifier\":\"dead\",\"altcomponent\":\"core_pix\"},{\"text\":\"|-.\",\"imagename\":\"s\\/sleepy\",\"imagecomponent\":\"core\",\"altidentifier\":\"sleepy\",\"altcomponent\":\"core_pix\"},{\"text\":\"}-]\",\"imagename\":\"s\\/evil\",\"imagecomponent\":\"core\",\"altidentifier\":\"evil\",\"altcomponent\":\"core_pix\"},{\"text\":\"(h)\",\"imagename\":\"s\\/heart\",\"imagecomponent\":\"core\",\"altidentifier\":\"heart\",\"altcomponent\":\"core_pix\"},{\"text\":\"(heart)\",\"imagename\":\"s\\/heart\",\"imagecomponent\":\"core\",\"altidentifier\":\"heart\",\"altcomponent\":\"core_pix\"},{\"text\":\"(y)\",\"imagename\":\"s\\/yes\",\"imagecomponent\":\"core\",\"altidentifier\":\"yes\",\"altcomponent\":\"core\"},{\"text\":\"(n)\",\"imagename\":\"s\\/no\",\"imagecomponent\":\"core\",\"altidentifier\":\"no\",\"altcomponent\":\"core\"},{\"text\":\"(martin)\",\"imagename\":\"s\\/martin\",\"imagecomponent\":\"core\",\"altidentifier\":\"martin\",\"altcomponent\":\"core_pix\"},{\"text\":\"( )\",\"imagename\":\"s\\/egg\",\"imagecomponent\":\"core\",\"altidentifier\":\"egg\",\"altcomponent\":\"core_pix\"}]'),(314,'docroot','https://docs.moodle.org'),(315,'doclang',''),(316,'doctonewwindow','0'),(317,'coursecreationguide','https://moodle.academy/coursequickstart'),(318,'coursecontactduplicates','0'),(319,'courselistshortnames','0'),(320,'coursesperpage','20'),(321,'courseswithsummarieslimit','10'),(322,'courseoverviewfileslimit','1'),(323,'courseoverviewfilesext','web_image'),(324,'coursegraceperiodbefore','0'),(325,'coursegraceperiodafter','0'),(326,'yuicomboloading','1'),(327,'cachejs','1'),(328,'additionalhtmlhead',''),(329,'additionalhtmltopofbody',''),(330,'additionalhtmlfooter',''),(331,'cachetemplates','1'),(332,'themelist',''),(333,'themedesignermode','0'),(334,'allowuserthemes','0'),(335,'allowcoursethemes','0'),(336,'allowcategorythemes','0'),(337,'allowcohortthemes','0'),(338,'allowthemechangeonurl','0'),(339,'allowuserblockhiding','1'),(340,'langmenuinsecurelayout','0'),(341,'logininfoinsecurelayout','0'),(342,'navfilter','0'),(343,'custommenuitems',''),(344,'customusermenuitems','profile,moodle|/user/profile.php\ngrades,grades|/grade/report/mygrades.php\ncalendar,core_calendar|/calendar/view.php?view=month\nprivatefiles,moodle|/user/files.php\nreports,core_reportbuilder|/reportbuilder/index.php'),(345,'file_redactor_exifremoverenabled','1'),(346,'file_redactor_exifremovertoolpath',''),(347,'file_redactor_exifremoverremovetags','gps'),(348,'file_redactor_exifremovermimetype','image/jpeg\nimage/tiff'),(349,'cron_enabled','1'),(350,'cron_keepalive','180'),(351,'task_scheduled_concurrency_limit','3'),(352,'task_scheduled_max_runtime','1800'),(353,'task_adhoc_concurrency_limit','3'),(354,'task_adhoc_max_runtime','1800'),(355,'task_adhoc_failed_retention','2419200'),(356,'task_logmode','1'),(357,'task_logtostdout','1'),(358,'task_logretention','2419200'),(359,'task_logretainruns','20'),(360,'smtphosts',''),(361,'smtpsecure',''),(362,'smtpauthtype','LOGIN'),(363,'smtpuser',''),(364,'smtppass',''),(365,'smtpmaxbulk','1'),(366,'allowedemaildomains',''),(367,'divertallemailsto',''),(368,'divertallemailsexcept',''),(369,'emaildkimselector',''),(370,'sitemailcharset','0'),(371,'allowusermailcharset','0'),(372,'allowattachments','1'),(373,'mailnewline','LF'),(374,'emailfromvia','1'),(375,'emailsubjectprefix',''),(376,'emailheaders',''),(377,'enablewsdocumentation','0'),(378,'pathtophp',''),(379,'pathtodu',''),(380,'aspellpath',''),(381,'pathtodot',''),(382,'pathtogs','/usr/bin/gs'),(383,'pathtopdftoppm',''),(384,'pathtopython',''),(385,'supportname','Administrador Usuario'),(386,'supportpage',''),(387,'supportavailability','1'),(388,'servicespage',''),(389,'dbsessions','0'),(390,'sessiontimeoutwarning','1200'),(391,'sessioncookie',''),(392,'sessioncookiepath',''),(393,'sessioncookiedomain',''),(394,'statsfirstrun','none'),(395,'statsmaxruntime','0'),(396,'statsruntimedays','31'),(397,'statsuserthreshold','0'),(398,'slasharguments','1'),(399,'getremoteaddrconf','3'),(400,'reverseproxyignore',''),(401,'proxyhost',''),(402,'proxyport','0'),(403,'proxytype','HTTP'),(404,'proxyuser',''),(405,'proxypassword',''),(406,'proxybypass','localhost,127.0.0.1'),(407,'proxylogunsafe','0'),(408,'proxyfixunsafe','0'),(409,'maintenance_enabled','0'),(410,'maintenance_message',''),(411,'deleteunconfirmed','168'),(412,'deleteincompleteusers','0'),(413,'disablegradehistory','0'),(414,'gradehistorylifetime','0'),(415,'tempdatafoldercleanup','168'),(416,'xapicleanupperiod','4838400'),(417,'filescleanupperiod','86400'),(418,'extramemorylimit','512M'),(419,'maxtimelimit','0'),(420,'curlcache','120'),(421,'curltimeoutkbitrate','56'),(422,'updateautocheck','1'),(423,'updateminmaturity','200'),(424,'updatenotifybuilds','0'),(425,'customreportslimit','0'),(426,'customreportsliveediting','1'),(427,'dndallowtextandlinks','0'),(428,'pathtosassc',''),(429,'contextlocking','0'),(430,'contextlockappliestoadmin','1'),(431,'forceclean','0'),(432,'enablecourserelativedates','0'),(433,'enablesharingtomoodlenet','0'),(434,'enablecommunicationsubsystem','0'),(435,'debug','0'),(436,'debugdisplay','0'),(437,'perfdebug','7'),(438,'debugstringids','0'),(439,'debugsqltrace','0'),(440,'debugvalidators','0'),(441,'debugpageinfo','0'),(442,'debugtemplateinfo','0'),(443,'profilingenabled','0'),(444,'profilingincluded',''),(445,'profilingexcluded',''),(446,'profilingautofrec','0'),(447,'profilingallowme','0'),(448,'profilingallowall','0'),(449,'profilingslow','0'),(450,'profilinglifetime','1440'),(451,'profilingimportprefix','(I)'),(452,'release','5.0.8+ (Build: 20260728)'),(453,'localcachedirpurged','1785982920'),(454,'scheduledtaskreset','1785982920'),(455,'paygw_plugins_sortorder','paypal'),(456,'allversionshash','2edf5728899bc78af57618f527758cc4c96884d2'),(457,'allcomponenthash','70b1a2d4d2bee1f3ffd2633ed11f02674518872e'),(458,'registrationpending','1'),(460,'branch','500'),(461,'enableaccessibilitytools','1'),(462,'notloggedinroleid','6'),(463,'guestroleid','6'),(464,'defaultuserroleid','7'),(465,'creatornewroleid','3'),(466,'restorernewroleid','3'),(467,'sitepolicyhandler',''),(468,'gradebookroles','5'),(469,'h5plibraryhandler','h5plib_v128'),(470,'airnotifierurl','https://messages.moodle.net'),(471,'airnotifierport','443'),(472,'airnotifiermobileappname','com.moodle.moodlemobile'),(473,'airnotifierappname','commoodlemoodlemobile'),(474,'airnotifieraccesskey',''),(475,'block_rss_client_num_entries','5'),(476,'block_rss_client_timeout','30'),(477,'block_course_list_adminview','all'),(478,'block_course_list_hideallcourseslink','0'),(479,'block_html_allowcssclasses','0'),(480,'block_online_users_timetosee','5'),(481,'block_online_users_onlinestatushiding','1'),(482,'pathtounoconv','/usr/bin/unoconv'),(483,'filter_multilang_force_old','0'),(484,'data_enablerssfeeds','0'),(485,'bigbluebuttonbn_server_url',''),(486,'bigbluebuttonbn_shared_secret',''),(487,'bigbluebuttonbn_checksum_algorithm','SHA256'),(488,'bigbluebuttonbn_poll_interval','5'),(489,'bigbluebuttonbn_welcome_default',''),(490,'bigbluebuttonbn_welcome_editable','1'),(491,'bigbluebuttonbn_recording_default','1'),(492,'bigbluebuttonbn_recording_refresh_period','300'),(493,'bigbluebuttonbn_recording_editable','1'),(494,'bigbluebuttonbn_recording_all_from_start_default','0'),(495,'bigbluebuttonbn_recording_all_from_start_editable','0'),(496,'bigbluebuttonbn_recording_hide_button_default','0'),(497,'bigbluebuttonbn_recording_hide_button_editable','0'),(498,'bigbluebuttonbn_recording_safe_formats','video,presentation'),(499,'bigbluebuttonbn_importrecordings_enabled','0'),(500,'bigbluebuttonbn_importrecordings_from_deleted_enabled','0'),(501,'bigbluebuttonbn_recordings_deleted_default','1'),(502,'bigbluebuttonbn_recordings_deleted_editable','0'),(503,'bigbluebuttonbn_recordings_imported_default','0'),(504,'bigbluebuttonbn_recordings_imported_editable','1'),(505,'bigbluebuttonbn_recordings_preview_default','1'),(506,'bigbluebuttonbn_recordings_preview_editable','0'),(507,'bigbluebuttonbn_recordings_asc_sort','0'),(508,'bigbluebuttonbn_recording_protect_editable','1'),(509,'bigbluebuttonbn_waitformoderator_default','0'),(510,'bigbluebuttonbn_waitformoderator_editable','1'),(511,'bigbluebuttonbn_waitformoderator_ping_interval','10'),(512,'bigbluebuttonbn_waitformoderator_cache_ttl','60'),(513,'bigbluebuttonbn_voicebridge_editable','0'),(514,'bigbluebuttonbn_preuploadpresentation_editable','0'),(515,'bigbluebuttonbn_userlimit_default','0'),(516,'bigbluebuttonbn_userlimit_editable','0'),(517,'bigbluebuttonbn_participant_moderator_default','0'),(518,'bigbluebuttonbn_muteonstart_default','0'),(519,'bigbluebuttonbn_muteonstart_editable','0'),(520,'bigbluebuttonbn_disablecam_default','0'),(521,'bigbluebuttonbn_disablecam_editable','1'),(522,'bigbluebuttonbn_disablemic_default','0'),(523,'bigbluebuttonbn_disablemic_editable','1'),(524,'bigbluebuttonbn_disableprivatechat_default','0'),(525,'bigbluebuttonbn_disableprivatechat_editable','1'),(526,'bigbluebuttonbn_disablepublicchat_default','0'),(527,'bigbluebuttonbn_disablepublicchat_editable','1'),(528,'bigbluebuttonbn_disablenote_default','0'),(529,'bigbluebuttonbn_disablenote_editable','1'),(530,'bigbluebuttonbn_hideuserlist_default','0'),(531,'bigbluebuttonbn_hideuserlist_editable','1'),(532,'bigbluebuttonbn_recordingready_enabled','0'),(533,'bigbluebuttonbn_profile_picture_enabled','0'),(534,'bigbluebuttonbn_meetingevents_enabled','0'),(535,'bigbluebuttonbn_guestaccess_enabled','0'),(536,'forum_displaymode','3'),(537,'forum_shortpost','300'),(538,'forum_longpost','600'),(539,'forum_manydiscussions','100'),(540,'forum_maxbytes','512000'),(541,'forum_maxattachments','9'),(542,'forum_subscription','0'),(543,'forum_trackingtype','1'),(544,'forum_trackreadposts','1'),(545,'forum_allowforcedreadtracking','0'),(546,'forum_oldpostdays','14'),(547,'forum_usermarksread','0'),(548,'forum_cleanreadtime','2'),(549,'digestmailtime','17'),(550,'forum_enablerssfeeds','0'),(551,'forum_enabletimedposts','1'),(552,'forum_announcementmaxattachments','1'),(553,'forum_announcementsubscription','1'),(554,'glossary_entbypage','10'),(555,'glossary_dupentries','0'),(556,'glossary_allowcomments','0'),(557,'glossary_linkbydefault','1'),(558,'glossary_defaultapproval','1'),(559,'glossary_enablerssfeeds','0'),(560,'glossary_linkentries','0'),(561,'glossary_casesensitive','0'),(562,'glossary_fullmatch','0'),(563,'feedback_allowfullanonymous','0'),(564,'profileroles','5,4,3'),(565,'coursecontact','3'),(566,'frontpage','6'),(567,'frontpageloggedin','6'),(568,'maxcategorydepth','2'),(569,'frontpagecourselimit','200'),(570,'commentsperpage','15'),(571,'defaultfrontpageroleid','8'),(572,'messageinbound_enabled','0'),(573,'messageinbound_mailbox',''),(574,'messageinbound_domain',''),(575,'messageinbound_host',''),(576,'messageinbound_hostssl','ssl'),(577,'messageinbound_hostuser',''),(578,'messageinbound_hostpass',''),(579,'mobilecssurl',''),(580,'enablemobilewebservice','0'),(581,'timezone','America/Lima'),(582,'registerauth',''),(583,'noreplyaddress','floratristancollege@gmail.com'),(584,'supportemail','floratristancollege@gmail.com');

--
-- Table structure for table `mdl_config_log`
--

CREATE TABLE `mdl_config_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `plugin` varchar(100) DEFAULT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  `oldvalue` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_conflog_tim_ix` (`timemodified`),
  KEY `mdl_conflog_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=1894 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Changes done in server configuration through admin UI';

--
-- Dumping data for table `mdl_config_log`
--



--
-- Table structure for table `mdl_config_plugins`
--

CREATE TABLE `mdl_config_plugins` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `plugin` varchar(100) NOT NULL DEFAULT 'core',
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_confplug_plunam_uix` (`plugin`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Moodle modules and plugins configuration variables';

--
-- Dumping data for table `mdl_config_plugins`
--



--
-- Table structure for table `mdl_contentbank_content`
--

CREATE TABLE `mdl_contentbank_content` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `contenttype` varchar(100) NOT NULL DEFAULT '',
  `contextid` bigint(10) NOT NULL,
  `visibility` tinyint(1) NOT NULL DEFAULT 1,
  `instanceid` bigint(10) DEFAULT NULL,
  `configdata` longtext DEFAULT NULL,
  `usercreated` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_contcont_nam_ix` (`name`),
  KEY `mdl_contcont_conconins_ix` (`contextid`,`contenttype`,`instanceid`),
  KEY `mdl_contcont_con_ix` (`contextid`),
  KEY `mdl_contcont_use_ix` (`usermodified`),
  KEY `mdl_contcont_use2_ix` (`usercreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='This table stores content data in the content bank.';

--
-- Dumping data for table `mdl_contentbank_content`
--


--
-- Table structure for table `mdl_context`
--

CREATE TABLE `mdl_context` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextlevel` bigint(10) NOT NULL DEFAULT 0,
  `instanceid` bigint(10) NOT NULL DEFAULT 0,
  `path` varchar(255) DEFAULT NULL,
  `depth` tinyint(2) NOT NULL DEFAULT 0,
  `locked` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_cont_conins_uix` (`contextlevel`,`instanceid`),
  KEY `mdl_cont_ins_ix` (`instanceid`),
  KEY `mdl_cont_pat_ix` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='one of these must be set';

--
-- Dumping data for table `mdl_context`
--

INSERT INTO `mdl_context` VALUES (1,10,0,'/1',1,0),(2,50,1,'/1/2',2,0),(4,30,1,'/1/4',2,0),(5,30,2,'/1/5',2,0),(6,80,1,'/1/6',2,0),(7,80,2,'/1/7',2,0),(8,80,3,'/1/8',2,0),(9,80,4,'/1/9',2,0),(10,80,5,'/1/10',2,0),(11,80,6,'/1/5/11',3,0),(12,80,7,'/1/5/12',3,0),(13,80,8,'/1/5/13',3,0),(15,40,3,'/1/15',2,0),(16,40,4,'/1/16',2,0),(17,40,5,'/1/17',2,0),(18,40,6,'/1/18',2,0),(19,40,7,'/1/19',2,0),(20,30,3,'/1/20',2,0),(21,50,2,'/1/15/21',3,0),(22,70,1,'/1/15/21/22',4,0),(23,80,9,'/1/23',2,0),(24,80,10,'/1/24',2,0),(25,80,11,'/1/20/25',3,0),(26,80,12,'/1/20/26',3,0),(27,80,13,'/1/20/27',3,0),(28,40,8,'/1/28',2,0),(29,50,3,'/1/15/29',3,0),(30,70,2,'/1/15/29/30',4,0),(31,50,4,'/1/15/31',3,0),(32,50,5,'/1/15/32',3,0),(33,70,4,'/1/15/32/33',4,0),(34,50,6,'/1/15/34',3,0),(35,50,7,'/1/15/35',3,0),(36,50,8,'/1/17/36',3,0),(37,50,9,'/1/17/37',3,0),(38,50,10,'/1/17/38',3,0),(39,50,11,'/1/17/39',3,0),(40,50,12,'/1/17/40',3,0),(41,50,13,'/1/28/41',3,0),(42,70,12,'/1/28/41/42',4,0);

--
-- Table structure for table `mdl_context_temp`
--

CREATE TABLE `mdl_context_temp` (
  `id` bigint(10) NOT NULL,
  `path` varchar(255) NOT NULL DEFAULT '',
  `depth` tinyint(2) NOT NULL,
  `locked` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Used by build_context_path() in upgrade and cron to keep con';

--
-- Dumping data for table `mdl_context_temp`
--


--
-- Table structure for table `mdl_course`
--

CREATE TABLE `mdl_course` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `category` bigint(10) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  `fullname` varchar(1333) NOT NULL DEFAULT '',
  `shortname` varchar(255) NOT NULL DEFAULT '',
  `idnumber` varchar(100) NOT NULL DEFAULT '',
  `summary` longtext DEFAULT NULL,
  `summaryformat` tinyint(2) NOT NULL DEFAULT 0,
  `format` varchar(21) NOT NULL DEFAULT 'topics',
  `showgrades` tinyint(2) NOT NULL DEFAULT 1,
  `newsitems` mediumint(5) NOT NULL DEFAULT 1,
  `startdate` bigint(10) NOT NULL DEFAULT 0,
  `enddate` bigint(10) NOT NULL DEFAULT 0,
  `relativedatesmode` tinyint(1) NOT NULL DEFAULT 0,
  `marker` bigint(10) NOT NULL DEFAULT 0,
  `maxbytes` bigint(10) NOT NULL DEFAULT 0,
  `legacyfiles` smallint(4) NOT NULL DEFAULT 0,
  `showreports` smallint(4) NOT NULL DEFAULT 0,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `visibleold` tinyint(1) NOT NULL DEFAULT 1,
  `downloadcontent` tinyint(1) DEFAULT NULL,
  `groupmode` smallint(4) NOT NULL DEFAULT 0,
  `groupmodeforce` smallint(4) NOT NULL DEFAULT 0,
  `defaultgroupingid` bigint(10) NOT NULL DEFAULT 0,
  `lang` varchar(30) NOT NULL DEFAULT '',
  `calendartype` varchar(30) NOT NULL DEFAULT '',
  `theme` varchar(50) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `requested` tinyint(1) NOT NULL DEFAULT 0,
  `enablecompletion` tinyint(1) NOT NULL DEFAULT 0,
  `completionnotify` tinyint(1) NOT NULL DEFAULT 0,
  `cacherev` bigint(10) NOT NULL DEFAULT 0,
  `originalcourseid` bigint(10) DEFAULT NULL,
  `showactivitydates` tinyint(1) NOT NULL DEFAULT 1,
  `showcompletionconditions` tinyint(1) DEFAULT NULL,
  `pdfexportfont` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_cour_cat_ix` (`category`),
  KEY `mdl_cour_idn_ix` (`idnumber`),
  KEY `mdl_cour_sho_ix` (`shortname`),
  KEY `mdl_cour_sor_ix` (`sortorder`),
  KEY `mdl_cour_ori_ix` (`originalcourseid`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Central course table';

--
-- Dumping data for table `mdl_course`
--

INSERT INTO `mdl_course` VALUES (1,0,1,'Mi Flora - Campus Virtual del Colegio Flora Tristán','Mi Flora','','<p>Bienvenido a Mi Flora, el campus virtual del Colegio Flora Tristán. Desde este espacio los estudiantes, docentes y familias podrán acceder a sus cursos, recursos educativos, actividades, tareas, evaluaciones y evidencias de aprendizaje en un entorno moderno, seguro y organizado.</p>',0,'site',1,3,0,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785888322,1785888930,0,0,0,1785982919,NULL,1,NULL,NULL),(2,3,20006,'Comunicación','COM-2026','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785890360,1785890360,0,1,0,1785982919,NULL,1,1,NULL),(3,3,20005,'Matemática','MAT-2026','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894085,1785894085,0,1,0,1785982919,NULL,1,1,NULL),(4,3,20004,'Ciencia y Tecnología','CYT-2026','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894148,1785894148,0,1,0,1785982919,NULL,1,1,NULL),(5,3,20003,'Personal Social','PES-2026','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894189,1785894189,0,1,0,1785982919,NULL,1,1,NULL),(6,3,20002,'Arte y Cultura','ART-2026','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894225,1785894225,0,1,0,1785982919,NULL,1,1,NULL),(7,3,20001,'Inglés','ING-2026','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894286,1785894286,0,1,0,1785982919,NULL,1,1,NULL),(8,5,30005,'Religión','REL-5T','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894332,1785894332,0,1,0,1785982919,NULL,1,1,NULL),(9,5,30004,'Música','MUS-5T','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894381,1785894381,0,1,0,1785982919,NULL,1,1,NULL),(10,5,30003,'Manualidades','MAN-5T','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894417,1785894417,0,1,0,1785982919,NULL,1,1,NULL),(11,5,30002,'Cocina y Repostería','CYR-5T','','',1,'topics',1,5,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894443,1785894443,0,1,0,1785982919,NULL,1,1,NULL),(12,5,30001,'FLORATEC','FTC-5T','','',1,'topics',1,5,1785906000,1817442000,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894478,1785894478,0,1,0,1785982919,NULL,1,1,NULL),(13,8,40001,'Mi Portafolio Digital','PORTAFOLIO','','<p>&lt;h2&gt;Bienvenido a Mi Portafolio Digital&lt;/h2&gt;</p>\r\n<p>&lt;p&gt;<br>Este espacio ha sido diseñado para conservar y compartir los logros académicos,<br>artísticos, científicos y personales de cada estudiante del Colegio Flora Tristán.<br>&lt;/p&gt;</p>\r\n<p>&lt;p&gt;<br>Aquí podrás visualizar fotografías, videos, documentos, proyectos, cuentos,<br>textos argumentativos, exposiciones, participaciones en concursos y todas las<br>evidencias del proceso de aprendizaje.<br>&lt;/p&gt;</p>\r\n<p>&lt;p&gt;<br>Cada estudiante contará con un espacio personal al que únicamente tendrán acceso<br>el estudiante, sus padres y los docentes autorizados.<br>&lt;/p&gt;</p>',1,'topics',1,0,1785906000,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1785894640,1785894640,0,1,0,1785982919,NULL,1,1,NULL);

--
-- Table structure for table `mdl_course_categories`
--

CREATE TABLE `mdl_course_categories` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `idnumber` varchar(100) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT 0,
  `parent` bigint(10) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  `coursecount` bigint(10) NOT NULL DEFAULT 0,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `visibleold` tinyint(1) NOT NULL DEFAULT 1,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `depth` bigint(10) NOT NULL DEFAULT 0,
  `path` varchar(255) NOT NULL DEFAULT '',
  `theme` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_courcate_par_ix` (`parent`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Course categories';

--
-- Dumping data for table `mdl_course_categories`
--

INSERT INTO `mdl_course_categories` VALUES (3,'Primaria','','',1,0,20000,6,1,1,1785889529,1,'/3',NULL),(4,'Inicial','','',1,0,10000,0,1,1,1785889552,1,'/4',NULL),(5,'Talleres Mi Flora','','',1,0,30000,5,1,1,1785889600,1,'/5',NULL),(6,'Docentes','','',1,0,50000,0,1,1,1785889624,1,'/6',NULL),(7,'Administradores','','',1,0,60000,0,1,1,1785889633,1,'/7',NULL),(8,' Portafolio Digital','','',1,0,40000,1,1,1,1785893986,1,'/8',NULL);

--
-- Table structure for table `mdl_course_completion_aggr_methd`
--

CREATE TABLE `mdl_course_completion_aggr_methd` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `criteriatype` bigint(10) DEFAULT NULL,
  `method` tinyint(1) NOT NULL DEFAULT 0,
  `value` decimal(10,5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_courcompaggrmeth_coucr_uix` (`course`,`criteriatype`),
  KEY `mdl_courcompaggrmeth_cou_ix` (`course`),
  KEY `mdl_courcompaggrmeth_cri_ix` (`criteriatype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Course completion aggregation methods for criteria';

--
-- Dumping data for table `mdl_course_completion_aggr_methd`
--


--
-- Table structure for table `mdl_course_completion_crit_compl`
--

CREATE TABLE `mdl_course_completion_crit_compl` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `criteriaid` bigint(10) NOT NULL DEFAULT 0,
  `gradefinal` decimal(10,5) DEFAULT NULL,
  `unenroled` bigint(10) DEFAULT NULL,
  `timecompleted` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_courcompcritcomp_useco_uix` (`userid`,`course`,`criteriaid`),
  KEY `mdl_courcompcritcomp_use_ix` (`userid`),
  KEY `mdl_courcompcritcomp_cou_ix` (`course`),
  KEY `mdl_courcompcritcomp_cri_ix` (`criteriaid`),
  KEY `mdl_courcompcritcomp_tim_ix` (`timecompleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Course completion user records';

--
-- Dumping data for table `mdl_course_completion_crit_compl`
--


--
-- Table structure for table `mdl_course_completion_criteria`
--

CREATE TABLE `mdl_course_completion_criteria` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `criteriatype` bigint(10) NOT NULL DEFAULT 0,
  `module` varchar(100) DEFAULT NULL,
  `moduleinstance` bigint(10) DEFAULT NULL,
  `courseinstance` bigint(10) DEFAULT NULL,
  `enrolperiod` bigint(10) DEFAULT NULL,
  `timeend` bigint(10) DEFAULT NULL,
  `gradepass` decimal(10,5) DEFAULT NULL,
  `role` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_courcompcrit_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Course completion criteria';

--
-- Dumping data for table `mdl_course_completion_criteria`
--


--
-- Table structure for table `mdl_course_completion_defaults`
--

CREATE TABLE `mdl_course_completion_defaults` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL,
  `module` bigint(10) NOT NULL,
  `completion` tinyint(1) NOT NULL DEFAULT 0,
  `completionview` tinyint(1) NOT NULL DEFAULT 0,
  `completionusegrade` tinyint(1) NOT NULL DEFAULT 0,
  `completionpassgrade` tinyint(1) NOT NULL DEFAULT 0,
  `completionexpected` bigint(10) NOT NULL DEFAULT 0,
  `customrules` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_courcompdefa_coumod_uix` (`course`,`module`),
  KEY `mdl_courcompdefa_mod_ix` (`module`),
  KEY `mdl_courcompdefa_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Default settings for activities completion';

--
-- Dumping data for table `mdl_course_completion_defaults`
--


--
-- Table structure for table `mdl_course_completions`
--

CREATE TABLE `mdl_course_completions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `timeenrolled` bigint(10) NOT NULL DEFAULT 0,
  `timestarted` bigint(10) NOT NULL DEFAULT 0,
  `timecompleted` bigint(10) DEFAULT NULL,
  `reaggregate` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_courcomp_usecou_uix` (`userid`,`course`),
  KEY `mdl_courcomp_use_ix` (`userid`),
  KEY `mdl_courcomp_cou_ix` (`course`),
  KEY `mdl_courcomp_tim_ix` (`timecompleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Course completion records';

--
-- Dumping data for table `mdl_course_completions`
--


--
-- Table structure for table `mdl_course_format_options`
--

CREATE TABLE `mdl_course_format_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `format` varchar(21) NOT NULL DEFAULT '',
  `sectionid` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(100) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_courformopti_couforsec_uix` (`courseid`,`format`,`sectionid`,`name`),
  KEY `mdl_courformopti_cou_ix` (`courseid`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores format-specific options for the course or course sect';

--
-- Dumping data for table `mdl_course_format_options`
--

INSERT INTO `mdl_course_format_options` VALUES (1,1,'site',0,'numsections','1'),(2,2,'topics',0,'hiddensections','1'),(3,2,'topics',0,'coursedisplay','0'),(4,3,'topics',0,'hiddensections','1'),(5,3,'topics',0,'coursedisplay','0'),(6,4,'topics',0,'hiddensections','1'),(7,4,'topics',0,'coursedisplay','0'),(8,5,'topics',0,'hiddensections','1'),(9,5,'topics',0,'coursedisplay','0'),(10,6,'topics',0,'hiddensections','1'),(11,6,'topics',0,'coursedisplay','0'),(12,7,'topics',0,'hiddensections','1'),(13,7,'topics',0,'coursedisplay','0'),(14,8,'topics',0,'hiddensections','1'),(15,8,'topics',0,'coursedisplay','0'),(16,9,'topics',0,'hiddensections','1'),(17,9,'topics',0,'coursedisplay','0'),(18,10,'topics',0,'hiddensections','1'),(19,10,'topics',0,'coursedisplay','0'),(20,11,'topics',0,'hiddensections','1'),(21,11,'topics',0,'coursedisplay','0'),(22,12,'topics',0,'hiddensections','1'),(23,12,'topics',0,'coursedisplay','0'),(24,13,'topics',0,'hiddensections','1'),(25,13,'topics',0,'coursedisplay','0');

--
-- Table structure for table `mdl_course_modules`
--

CREATE TABLE `mdl_course_modules` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `module` bigint(10) NOT NULL DEFAULT 0,
  `instance` bigint(10) NOT NULL DEFAULT 0,
  `section` bigint(10) NOT NULL DEFAULT 0,
  `idnumber` varchar(100) DEFAULT NULL,
  `added` bigint(10) NOT NULL DEFAULT 0,
  `score` smallint(4) NOT NULL DEFAULT 0,
  `indent` mediumint(5) NOT NULL DEFAULT 0,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `visibleoncoursepage` tinyint(1) NOT NULL DEFAULT 1,
  `visibleold` tinyint(1) NOT NULL DEFAULT 1,
  `groupmode` smallint(4) NOT NULL DEFAULT 0,
  `groupingid` bigint(10) NOT NULL DEFAULT 0,
  `completion` tinyint(1) NOT NULL DEFAULT 0,
  `completiongradeitemnumber` bigint(10) DEFAULT NULL,
  `completionview` tinyint(1) NOT NULL DEFAULT 0,
  `completionexpected` bigint(10) NOT NULL DEFAULT 0,
  `completionpassgrade` tinyint(1) NOT NULL DEFAULT 0,
  `showdescription` tinyint(1) NOT NULL DEFAULT 0,
  `availability` longtext DEFAULT NULL,
  `deletioninprogress` tinyint(1) NOT NULL DEFAULT 0,
  `downloadcontent` tinyint(1) DEFAULT 1,
  `lang` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_courmodu_vis_ix` (`visible`),
  KEY `mdl_courmodu_cou_ix` (`course`),
  KEY `mdl_courmodu_mod_ix` (`module`),
  KEY `mdl_courmodu_ins_ix` (`instance`),
  KEY `mdl_courmodu_idncou_ix` (`idnumber`,`course`),
  KEY `mdl_courmodu_gro_ix` (`groupingid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='course_modules table retrofitted from MySQL';

--
-- Dumping data for table `mdl_course_modules`
--

INSERT INTO `mdl_course_modules` VALUES (1,2,8,1,1,NULL,1785890360,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(2,3,8,2,12,NULL,1785894085,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(3,4,8,3,17,NULL,1785894148,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(4,5,8,4,22,NULL,1785894189,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(5,6,8,5,27,NULL,1785894225,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(6,7,8,6,32,NULL,1785894286,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(7,8,8,7,37,NULL,1785894332,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(8,9,8,8,42,NULL,1785894381,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(9,10,8,9,47,NULL,1785894417,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(10,11,8,10,52,NULL,1785894443,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(11,12,8,11,57,NULL,1785894478,0,0,1,1,1,0,0,0,NULL,0,0,0,0,NULL,0,1,NULL),(12,13,5,1,63,'',1785896441,0,0,1,1,1,0,0,0,NULL,0,0,0,1,NULL,0,1,'');

--
-- Table structure for table `mdl_course_modules_completion`
--

CREATE TABLE `mdl_course_modules_completion` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `coursemoduleid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `completionstate` tinyint(1) NOT NULL,
  `overrideby` bigint(10) DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_courmoducomp_usecou_uix` (`userid`,`coursemoduleid`),
  KEY `mdl_courmoducomp_cou_ix` (`coursemoduleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Stores the completion state (completed or not completed, etc';

--
-- Dumping data for table `mdl_course_modules_completion`
--


--
-- Table structure for table `mdl_course_modules_viewed`
--

CREATE TABLE `mdl_course_modules_viewed` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `coursemoduleid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_courmoduview_usecou_uix` (`userid`,`coursemoduleid`),
  KEY `mdl_courmoduview_cou_ix` (`coursemoduleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Tracks the completion viewed (viewed with cmid/userid and ot';

--
-- Dumping data for table `mdl_course_modules_viewed`
--


--
-- Table structure for table `mdl_course_published`
--

CREATE TABLE `mdl_course_published` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `huburl` varchar(255) DEFAULT NULL,
  `courseid` bigint(10) NOT NULL,
  `timepublished` bigint(10) NOT NULL,
  `enrollable` tinyint(1) NOT NULL DEFAULT 1,
  `hubcourseid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT 0,
  `timechecked` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_courpubl_hub_ix` (`hubcourseid`),
  KEY `mdl_courpubl_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Information about how and when an local courses were publish';

--
-- Dumping data for table `mdl_course_published`
--


--
-- Table structure for table `mdl_course_request`
--

CREATE TABLE `mdl_course_request` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(1333) NOT NULL DEFAULT '',
  `shortname` varchar(255) NOT NULL DEFAULT '',
  `summary` longtext NOT NULL,
  `summaryformat` tinyint(2) NOT NULL DEFAULT 0,
  `category` bigint(10) NOT NULL DEFAULT 0,
  `reason` longtext NOT NULL,
  `requester` bigint(10) NOT NULL DEFAULT 0,
  `password` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_courrequ_sho_ix` (`shortname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='course requests';

--
-- Dumping data for table `mdl_course_request`
--


--
-- Table structure for table `mdl_course_sections`
--

CREATE TABLE `mdl_course_sections` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `section` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  `summary` longtext DEFAULT NULL,
  `summaryformat` tinyint(2) NOT NULL DEFAULT 0,
  `sequence` longtext DEFAULT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT 1,
  `availability` longtext DEFAULT NULL,
  `component` varchar(100) DEFAULT NULL,
  `itemid` bigint(10) DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_coursect_cousec_uix` (`course`,`section`),
  KEY `mdl_coursect_comite_ix` (`component`,`itemid`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='to define the sections for each course';

--
-- Dumping data for table `mdl_course_sections`
--

INSERT INTO `mdl_course_sections` VALUES (1,2,0,NULL,'',1,'1',1,NULL,NULL,NULL,1785890360),(2,2,1,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(3,2,2,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(4,2,3,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(5,2,4,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(6,2,5,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(7,2,6,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(8,2,7,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(9,2,8,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(10,2,9,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(11,2,10,NULL,'',1,'',1,NULL,NULL,NULL,1785890360),(12,3,0,NULL,'',1,'2',1,NULL,NULL,NULL,1785894085),(13,3,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894085),(14,3,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894085),(15,3,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894085),(16,3,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894085),(17,4,0,NULL,'',1,'3',1,NULL,NULL,NULL,1785894149),(18,4,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894149),(19,4,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894149),(20,4,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894149),(21,4,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894149),(22,5,0,NULL,'',1,'4',1,NULL,NULL,NULL,1785894189),(23,5,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894189),(24,5,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894189),(25,5,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894189),(26,5,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894189),(27,6,0,NULL,'',1,'5',1,NULL,NULL,NULL,1785894225),(28,6,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894225),(29,6,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894225),(30,6,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894225),(31,6,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894225),(32,7,0,NULL,'',1,'6',1,NULL,NULL,NULL,1785894286),(33,7,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894286),(34,7,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894286),(35,7,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894286),(36,7,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894286),(37,8,0,NULL,'',1,'7',1,NULL,NULL,NULL,1785894332),(38,8,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894332),(39,8,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894332),(40,8,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894332),(41,8,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894332),(42,9,0,NULL,'',1,'8',1,NULL,NULL,NULL,1785894381),(43,9,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894381),(44,9,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894381),(45,9,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894381),(46,9,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894381),(47,10,0,NULL,'',1,'9',1,NULL,NULL,NULL,1785894417),(48,10,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894417),(49,10,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894417),(50,10,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894417),(51,10,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894417),(52,11,0,NULL,'',1,'10',1,NULL,NULL,NULL,1785894443),(53,11,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894443),(54,11,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894443),(55,11,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894443),(56,11,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894443),(57,12,0,NULL,'',1,'11',1,NULL,NULL,NULL,1785894478),(58,12,1,NULL,'',1,'',1,NULL,NULL,NULL,1785894478),(59,12,2,NULL,'',1,'',1,NULL,NULL,NULL,1785894478),(60,12,3,NULL,'',1,'',1,NULL,NULL,NULL,1785894478),(61,12,4,NULL,'',1,'',1,NULL,NULL,NULL,1785894478),(62,13,0,'📌 Bienvenida','',1,'',1,NULL,NULL,NULL,1785894730),(63,13,1,'📰 Publicaciones','',1,'12',1,NULL,NULL,NULL,1785894735),(64,13,2,'🏆 Logros y reconocimientos','',1,'',1,NULL,NULL,NULL,1785895034),(67,13,3,'🎓 Cursos y talleres','',1,'',1,NULL,NULL,NULL,1785895043),(68,1,1,NULL,'',1,'',1,NULL,NULL,NULL,1785896475);

--
-- Table structure for table `mdl_customfield_category`
--

CREATE TABLE `mdl_customfield_category` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(400) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `descriptionformat` bigint(10) DEFAULT NULL,
  `sortorder` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `component` varchar(100) NOT NULL DEFAULT '',
  `area` varchar(100) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL DEFAULT 0,
  `contextid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_custcate_comareitesor_ix` (`component`,`area`,`itemid`,`sortorder`),
  KEY `mdl_custcate_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='core_customfield category table';

--
-- Dumping data for table `mdl_customfield_category`
--


--
-- Table structure for table `mdl_customfield_data`
--

CREATE TABLE `mdl_customfield_data` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `fieldid` bigint(10) NOT NULL,
  `instanceid` bigint(10) NOT NULL,
  `intvalue` bigint(10) DEFAULT NULL,
  `decvalue` decimal(15,5) DEFAULT NULL,
  `shortcharvalue` varchar(255) DEFAULT NULL,
  `charvalue` varchar(1333) DEFAULT NULL,
  `value` longtext NOT NULL,
  `valueformat` bigint(10) NOT NULL,
  `valuetrust` tinyint(2) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_custdata_insfie_uix` (`instanceid`,`fieldid`),
  KEY `mdl_custdata_fieint_ix` (`fieldid`,`intvalue`),
  KEY `mdl_custdata_fiesho_ix` (`fieldid`,`shortcharvalue`),
  KEY `mdl_custdata_fiedec_ix` (`fieldid`,`decvalue`),
  KEY `mdl_custdata_fie_ix` (`fieldid`),
  KEY `mdl_custdata_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='core_customfield data table';

--
-- Dumping data for table `mdl_customfield_data`
--


--
-- Table structure for table `mdl_customfield_field`
--

CREATE TABLE `mdl_customfield_field` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(400) NOT NULL DEFAULT '',
  `type` varchar(100) NOT NULL DEFAULT '',
  `description` longtext DEFAULT NULL,
  `descriptionformat` bigint(10) DEFAULT NULL,
  `sortorder` bigint(10) DEFAULT NULL,
  `categoryid` bigint(10) DEFAULT NULL,
  `configdata` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_custfiel_catsor_ix` (`categoryid`,`sortorder`),
  KEY `mdl_custfiel_cat_ix` (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='core_customfield field table';

--
-- Dumping data for table `mdl_customfield_field`
--


--
-- Table structure for table `mdl_data`
--

CREATE TABLE `mdl_data` (
  `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,
  `comments` smallint(4) NOT NULL DEFAULT 0,
  `timeavailablefrom` bigint(10) NOT NULL DEFAULT 0,
  `timeavailableto` bigint(10) NOT NULL DEFAULT 0,
  `timeviewfrom` bigint(10) NOT NULL DEFAULT 0,
  `timeviewto` bigint(10) NOT NULL DEFAULT 0,
  `requiredentries` int(8) NOT NULL DEFAULT 0,
  `requiredentriestoview` int(8) NOT NULL DEFAULT 0,
  `maxentries` int(8) NOT NULL DEFAULT 0,
  `rssarticles` smallint(4) NOT NULL DEFAULT 0,
  `singletemplate` longtext DEFAULT NULL,
  `listtemplate` longtext DEFAULT NULL,
  `listtemplateheader` longtext DEFAULT NULL,
  `listtemplatefooter` longtext DEFAULT NULL,
  `addtemplate` longtext DEFAULT NULL,
  `rsstemplate` longtext DEFAULT NULL,
  `rsstitletemplate` longtext DEFAULT NULL,
  `csstemplate` longtext DEFAULT NULL,
  `jstemplate` longtext DEFAULT NULL,
  `asearchtemplate` longtext DEFAULT NULL,
  `approval` smallint(4) NOT NULL DEFAULT 0,
  `manageapproved` smallint(4) NOT NULL DEFAULT 1,
  `scale` bigint(10) NOT NULL DEFAULT 0,
  `assessed` bigint(10) NOT NULL DEFAULT 0,
  `assesstimestart` bigint(10) NOT NULL DEFAULT 0,
  `assesstimefinish` bigint(10) NOT NULL DEFAULT 0,
  `defaultsort` bigint(10) NOT NULL DEFAULT 0,
  `defaultsortdir` smallint(4) NOT NULL DEFAULT 0,
  `editany` smallint(4) NOT NULL DEFAULT 0,
  `notification` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `config` longtext DEFAULT NULL,
  `completionentries` bigint(10) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_data_cou_ix` (`course`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='all database activities';

--
-- Dumping data for table `mdl_data`
--

INSERT INTO `mdl_data` VALUES (1,13,'Mis publicaciones','<h2>Mis Publicaciones</h2>\r\n<p>Este espacio reúne las evidencias de aprendizaje del estudiante.</p>\r\n<p>Aquí se publicarán fotografías, videos, documentos, proyectos, cuentos, textos argumentativos, exposiciones, logros y reconocimientos obtenidos durante su formación académica.</p>\r\n<p>Este portafolio podrá ser visualizado por el estudiante, sus padres y los docentes autorizados.</p>',1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,'<div id=\"defaulttemplate-addentry\">\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">fotoprincipal</div>\r\n[[fotoprincipal]]</div>\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">titulo</div>\r\n[[titulo]]</div>\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">tipo</div>\r\n[[tipo]]</div>\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">categoria</div>\r\n[[categoria]]</div>\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">fecha</div>\r\n[[fecha]]</div>\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">descripcion</div>\r\n[[descripcion]]</div>\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">documento</div>\r\n[[documento]]</div>\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">video</div>\r\n[[video]]</div>\r\n##otherfields##\r\n<div class=\"mb-3 pt-3\">\r\n<div class=\"fw-bold\">Marcas</div>\r\n##tags##</div>\r\n</div>',NULL,NULL,NULL,NULL,NULL,1,1,100,0,0,0,0,0,0,0,1785896918,'{\"editor_addtemplate\":true}',0);

--
-- Table structure for table `mdl_data_content`
--

CREATE TABLE `mdl_data_content` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `fieldid` bigint(10) NOT NULL DEFAULT 0,
  `recordid` bigint(10) NOT NULL DEFAULT 0,
  `content` longtext DEFAULT NULL,
  `content1` longtext DEFAULT NULL,
  `content2` longtext DEFAULT NULL,
  `content3` longtext DEFAULT NULL,
  `content4` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_datacont_rec_ix` (`recordid`),
  KEY `mdl_datacont_fie_ix` (`fieldid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='the content introduced in each record/fields';

--
-- Dumping data for table `mdl_data_content`
--

INSERT INTO `mdl_data_content` VALUES (1,1,1,'images.jpg','',NULL,NULL,NULL),(2,2,1,'',NULL,NULL,NULL,NULL),(3,3,1,'Feria de Ciencias',NULL,NULL,NULL,NULL),(4,4,1,'Ciencia y Tecnología',NULL,NULL,NULL,NULL),(5,5,1,'1785888000',NULL,NULL,NULL,NULL),(6,6,1,'<p>presentacion de proyecto</p>','1',NULL,NULL,NULL),(7,7,1,NULL,NULL,NULL,NULL,NULL),(8,8,1,'','',NULL,NULL,NULL);

--
-- Table structure for table `mdl_data_fields`
--

CREATE TABLE `mdl_data_fields` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `dataid` bigint(10) NOT NULL DEFAULT 0,
  `type` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `param1` longtext DEFAULT NULL,
  `param2` longtext DEFAULT NULL,
  `param3` longtext DEFAULT NULL,
  `param4` longtext DEFAULT NULL,
  `param5` longtext DEFAULT NULL,
  `param6` longtext DEFAULT NULL,
  `param7` longtext DEFAULT NULL,
  `param8` longtext DEFAULT NULL,
  `param9` longtext DEFAULT NULL,
  `param10` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_datafiel_typdat_ix` (`type`,`dataid`),
  KEY `mdl_datafiel_dat_ix` (`dataid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='every field available';

--
-- Dumping data for table `mdl_data_fields`
--

INSERT INTO `mdl_data_fields` VALUES (1,1,'picture','fotoprincipal','Fotografía principal de la publicación.',1,'900','900','0','320','320',NULL,NULL,NULL,NULL,NULL),(2,1,'text','titulo','Título de la publicación.',0,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,'menu','tipo','Seleccione el tipo de publicación que se registrará en el portafolio del estudiante.',1,'Actividad de aprendizaje\r\nProyecto\r\nTexto argumentativo\r\nCuento\r\nExperimento\r\nFeria de Ciencias\r\nExposición\r\nConcurso\r\nReconocimiento\r\nDiploma\r\nPresentación artística\r\nVideo\r\nFotografía\r\nOtro','','','','','','','','',''),(4,1,'menu','categoria','Seleccione la categoría a la que pertenece esta publicación.',1,'Comunicación\r\nMatemática\r\nCiencia y Tecnología\r\nPersonal Social\r\nArte y Cultura\r\nEducación Física\r\nInglés\r\nReligión\r\nTutoría\r\nFLORATEC\r\nMúsica\r\nManualidades\r\nCocina y Repostería\r\nRobótica\r\nProyecto Institucional\r\nOtro','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,'date','fecha','',0,'','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,'textarea','descripcion','Descripción de la publicación.',1,'','80','15','1','0',NULL,NULL,NULL,NULL,NULL),(7,1,'file','documento','Adjunte un archivo relacionado con la publicación (PDF, Word, PowerPoint u otro documento).',0,'','','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,1,'url','video','Ingrese el enlace de un video de YouTube u otra plataforma relacionado con la publicación.',0,'on','','on',NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `mdl_data_records`
--

CREATE TABLE `mdl_data_records` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `dataid` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `approved` smallint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_datareco_dat_ix` (`dataid`),
  KEY `mdl_datareco_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='every record introduced';

--
-- Dumping data for table `mdl_data_records`
--

INSERT INTO `mdl_data_records` VALUES (1,3,0,1,1785898624,1785898624,1);

--
-- Table structure for table `mdl_enrol_flatfile`
--

CREATE TABLE `mdl_enrol_flatfile` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `action` varchar(30) NOT NULL DEFAULT '',
  `roleid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `timestart` bigint(10) NOT NULL DEFAULT 0,
  `timeend` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mdl_enroflat_cou_ix` (`courseid`),
  KEY `mdl_enroflat_use_ix` (`userid`),
  KEY `mdl_enroflat_rol_ix` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='enrol_flatfile table retrofitted from MySQL';

--
-- Dumping data for table `mdl_enrol_flatfile`
--


--
-- Table structure for table `mdl_enrol_lti_app_registration`
--

CREATE TABLE `mdl_enrol_lti_app_registration` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `platformid` longtext DEFAULT NULL,
  `clientid` varchar(1333) DEFAULT NULL,
  `uniqueid` varchar(255) NOT NULL DEFAULT '',
  `platformclienthash` varchar(64) DEFAULT NULL,
  `platformuniqueidhash` varchar(64) DEFAULT NULL,
  `authenticationrequesturl` longtext DEFAULT NULL,
  `jwksurl` longtext DEFAULT NULL,
  `accesstokenurl` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_enroltiappregi_uni_uix` (`uniqueid`),
  UNIQUE KEY `mdl_enroltiappregi_pla_uix` (`platformclienthash`),
  UNIQUE KEY `mdl_enroltiappregi_pla2_uix` (`platformuniqueidhash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Details of each application that has been registered with th';

--
-- Dumping data for table `mdl_enrol_lti_app_registration`
--


--
-- Table structure for table `mdl_enrol_lti_context`
--

CREATE TABLE `mdl_enrol_lti_context` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` varchar(255) NOT NULL DEFAULT '',
  `ltideploymentid` bigint(10) NOT NULL,
  `type` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_enrolticont_lticon_uix` (`ltideploymentid`,`contextid`),
  KEY `mdl_enrolticont_lti_ix` (`ltideploymentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each row represents a context in the platform, where resourc';

--
-- Dumping data for table `mdl_enrol_lti_context`
--


--
-- Table structure for table `mdl_enrol_lti_deployment`
--

CREATE TABLE `mdl_enrol_lti_deployment` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `deploymentid` varchar(255) NOT NULL DEFAULT '',
  `platformid` bigint(10) NOT NULL,
  `legacyconsumerkey` varchar(255) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_enroltidepl_pladep_uix` (`platformid`,`deploymentid`),
  KEY `mdl_enroltidepl_pla_ix` (`platformid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Each row represents a deployment of a tool within a platform';

--
-- Dumping data for table `mdl_enrol_lti_deployment`
--


--
-- Table structure for table `mdl_enrol_lti_lti2_consumer`
--

CREATE TABLE `mdl_enrol_lti_lti2_consumer` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `consumerkey256` varchar(255) NOT NULL DEFAULT '',
  `consumerkey` longtext DEFAULT NULL,
  `secret` varchar(1024) NOT NULL DEFAULT '',
  `ltiversion` varchar(10) DEFAULT NULL,
  `consumername` varchar(255) DEFAULT NULL,
  `consumerversion` varchar(255) DEFAULT NULL,
  `consumerguid` varchar(1024) DEFAULT NULL,
  `profile` longtext DEFAULT NULL,
  `toolproxy` longtext DEFAULT NULL,
  `settings` longtext DEFAULT NULL,
  `protected` tinyint(1) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `enablefrom` bigint(10) DEFAULT NULL,
  `enableuntil` bigint(10) DEFAULT NULL,
  `lastaccess` bigint(10) DEFAULT NULL,
  `created` bigint(10) NOT NULL,
  `updated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_enroltilti2cons_con_uix` (`consumerkey256`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='LTI consumers interacting with moodle';

--
-- Dumping data for table `mdl_enrol_lti_lti2_consumer`
--


--
-- Table structure for table `mdl_enrol_lti_lti2_context`
--

CREATE TABLE `mdl_enrol_lti_lti2_context` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `consumerid` bigint(11) NOT NULL,
  `lticontextkey` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(100) DEFAULT NULL,
  `settings` longtext DEFAULT NULL,
  `created` bigint(10) NOT NULL,
  `updated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_enroltilti2cont_con_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Information about a specific LTI contexts from the consumers';

--
-- Dumping data for table `mdl_enrol_lti_lti2_context`
--


--
-- Table structure for table `mdl_enrol_lti_lti2_nonce`
--

CREATE TABLE `mdl_enrol_lti_lti2_nonce` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `consumerid` bigint(11) NOT NULL,
  `value` varchar(64) NOT NULL DEFAULT '',
  `expires` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_enroltilti2nonc_con_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Nonce used for authentication between moodle and a consumer';

--
-- Dumping data for table `mdl_enrol_lti_lti2_nonce`
--


--
-- Table structure for table `mdl_enrol_lti_lti2_resource_link`
--

CREATE TABLE `mdl_enrol_lti_lti2_resource_link` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(11) DEFAULT NULL,
  `consumerid` bigint(11) DEFAULT NULL,
  `ltiresourcelinkkey` varchar(255) NOT NULL DEFAULT '',
  `settings` longtext DEFAULT NULL,
  `primaryresourcelinkid` bigint(11) DEFAULT NULL,
  `shareapproved` tinyint(1) DEFAULT NULL,
  `created` bigint(10) NOT NULL,
  `updated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_enroltilti2resolink_con_ix` (`contextid`),
  KEY `mdl_enroltilti2resolink_pri_ix` (`primaryresourcelinkid`),
  KEY `mdl_enroltilti2resolink_co2_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Link from the consumer to the tool';

--
-- Dumping data for table `mdl_enrol_lti_lti2_resource_link`
--


--
-- Table structure for table `mdl_enrol_lti_lti2_share_key`
--

CREATE TABLE `mdl_enrol_lti_lti2_share_key` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `sharekey` varchar(32) NOT NULL DEFAULT '',
  `resourcelinkid` bigint(11) NOT NULL,
  `autoapprove` tinyint(1) NOT NULL,
  `expires` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_enroltilti2sharkey_sha_uix` (`sharekey`),
  UNIQUE KEY `mdl_enroltilti2sharkey_res_uix` (`resourcelinkid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPRESSED COMMENT='Resource link share key';

--
