--
-- Host: localhost    Database: mobisky_lms
-- ------------------------------------------------------


--
-- Table structure for table `mblms_analytics_indicator_calc`
--

CREATE TABLE `mblms_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 `mblms_analindicalc_staendco_ix` (`starttime`,`endtime`,`contextid`),
  KEY `mblms_analindicalc_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stored indicator calculations';

--
-- Dumping data for table `mblms_analytics_indicator_calc`
--


--
-- Table structure for table `mblms_analytics_models`
--

CREATE TABLE `mblms_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 `mblms_analmode_enatra_ix` (`enabled`,`trained`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Analytic models.';

--
-- Dumping data for table `mblms_analytics_models`
--

INSERT INTO `mblms_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_chat\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_chat\\\\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_survey\\\\analytics\\\\indicator\\\\cognitive_depth\",\"\\\\mod_survey\\\\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,1616485975,NULL,1616485975,1616485975,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,1616485975,NULL,1616485975,1616485975,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,1616485975,NULL,1616485975,1616485975,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,1616485975,NULL,1616485975,1616485975,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,1616485975,NULL,1616485975,1616485975,0);

--
-- Table structure for table `mblms_analytics_models_log`
--

CREATE TABLE `mblms_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 `mblms_analmodelog_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Analytic models changes during evaluation.';

--
-- Dumping data for table `mblms_analytics_models_log`
--


--
-- Table structure for table `mblms_analytics_predict_samples`
--

CREATE TABLE `mblms_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 `mblms_analpredsamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`,`rangeindex`),
  KEY `mblms_analpredsamp_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Samples already used for predictions.';

--
-- Dumping data for table `mblms_analytics_predict_samples`
--


--
-- Table structure for table `mblms_analytics_prediction_actions`
--

CREATE TABLE `mblms_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 `mblms_analpredacti_preuseac_ix` (`predictionid`,`userid`,`actionname`),
  KEY `mblms_analpredacti_pre_ix` (`predictionid`),
  KEY `mblms_analpredacti_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Register of user actions over predictions.';

--
-- Dumping data for table `mblms_analytics_prediction_actions`
--


--
-- Table structure for table `mblms_analytics_predictions`
--

CREATE TABLE `mblms_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 `mblms_analpred_modcon_ix` (`modelid`,`contextid`),
  KEY `mblms_analpred_mod_ix` (`modelid`),
  KEY `mblms_analpred_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Predictions';

--
-- Dumping data for table `mblms_analytics_predictions`
--


--
-- Table structure for table `mblms_analytics_train_samples`
--

CREATE TABLE `mblms_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 `mblms_analtraisamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`),
  KEY `mblms_analtraisamp_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Samples used for training';

--
-- Dumping data for table `mblms_analytics_train_samples`
--


--
-- Table structure for table `mblms_analytics_used_analysables`
--

CREATE TABLE `mblms_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 `mblms_analusedanal_modact_ix` (`modelid`,`action`),
  KEY `mblms_analusedanal_ana_ix` (`analysableid`),
  KEY `mblms_analusedanal_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='List of analysables used by each model';

--
-- Dumping data for table `mblms_analytics_used_analysables`
--


--
-- Table structure for table `mblms_analytics_used_files`
--

CREATE TABLE `mblms_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 `mblms_analusedfile_modactfi_ix` (`modelid`,`action`,`fileid`),
  KEY `mblms_analusedfile_mod_ix` (`modelid`),
  KEY `mblms_analusedfile_fil_ix` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Files that have already been used for training and predictio';

--
-- Dumping data for table `mblms_analytics_used_files`
--


--
-- Table structure for table `mblms_assign`
--

CREATE TABLE `mblms_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 'none',
  `maxattempts` mediumint(6) NOT NULL DEFAULT -1,
  `markingworkflow` tinyint(2) NOT NULL DEFAULT 0,
  `markingallocation` tinyint(2) NOT NULL DEFAULT 0,
  `sendstudentnotifications` tinyint(2) NOT NULL DEFAULT 1,
  `preventsubmissionnotingroup` tinyint(2) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_assi_cou_ix` (`course`),
  KEY `mblms_assi_tea_ix` (`teamsubmissiongroupingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table saves information about an instance of mod_assign';

--
-- Dumping data for table `mblms_assign`
--


--
-- Table structure for table `mblms_assign_grades`
--

CREATE TABLE `mblms_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,
  `attemptnumber` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_assigrad_assuseatt_uix` (`assignment`,`userid`,`attemptnumber`),
  KEY `mblms_assigrad_use_ix` (`userid`),
  KEY `mblms_assigrad_att_ix` (`attemptnumber`),
  KEY `mblms_assigrad_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Grading information about a single assignment submission.';

--
-- Dumping data for table `mblms_assign_grades`
--


--
-- Table structure for table `mblms_assign_overrides`
--

CREATE TABLE `mblms_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,
  PRIMARY KEY (`id`),
  KEY `mblms_assiover_ass_ix` (`assignid`),
  KEY `mblms_assiover_gro_ix` (`groupid`),
  KEY `mblms_assiover_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='The overrides to assign settings.';

--
-- Dumping data for table `mblms_assign_overrides`
--


--
-- Table structure for table `mblms_assign_plugin_config`
--

CREATE TABLE `mblms_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 `mblms_assiplugconf_plu_ix` (`plugin`),
  KEY `mblms_assiplugconf_sub_ix` (`subtype`),
  KEY `mblms_assiplugconf_nam_ix` (`name`),
  KEY `mblms_assiplugconf_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Config data for an instance of a plugin in an assignment.';

--
-- Dumping data for table `mblms_assign_plugin_config`
--


--
-- Table structure for table `mblms_assign_submission`
--

CREATE TABLE `mblms_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,
  `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 `mblms_assisubm_assusegroat_uix` (`assignment`,`userid`,`groupid`,`attemptnumber`),
  KEY `mblms_assisubm_use_ix` (`userid`),
  KEY `mblms_assisubm_att_ix` (`attemptnumber`),
  KEY `mblms_assisubm_assusegrolat_ix` (`assignment`,`userid`,`groupid`,`latest`),
  KEY `mblms_assisubm_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table keeps information about student interactions with';

--
-- Dumping data for table `mblms_assign_submission`
--


--
-- Table structure for table `mblms_assign_user_flags`
--

CREATE TABLE `mblms_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 `mblms_assiuserflag_mai_ix` (`mailed`),
  KEY `mblms_assiuserflag_use_ix` (`userid`),
  KEY `mblms_assiuserflag_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='List of flags that can be set for a single user in a single ';

--
-- Dumping data for table `mblms_assign_user_flags`
--


--
-- Table structure for table `mblms_assign_user_mapping`
--

CREATE TABLE `mblms_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 `mblms_assiusermapp_ass_ix` (`assignment`),
  KEY `mblms_assiusermapp_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Map an assignment specific id number to a user';

--
-- Dumping data for table `mblms_assign_user_mapping`
--


--
-- Table structure for table `mblms_assignfeedback_comments`
--

CREATE TABLE `mblms_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 `mblms_assicomm_ass_ix` (`assignment`),
  KEY `mblms_assicomm_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Text feedback for submitted assignments';

--
-- Dumping data for table `mblms_assignfeedback_comments`
--


--
-- Table structure for table `mblms_assignfeedback_editpdf_annot`
--

CREATE TABLE `mblms_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 `mblms_assieditanno_grapag_ix` (`gradeid`,`pageno`),
  KEY `mblms_assieditanno_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='stores annotations added to pdfs submitted by students';

--
-- Dumping data for table `mblms_assignfeedback_editpdf_annot`
--


--
-- Table structure for table `mblms_assignfeedback_editpdf_cmnt`
--

CREATE TABLE `mblms_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 `mblms_assieditcmnt_grapag_ix` (`gradeid`,`pageno`),
  KEY `mblms_assieditcmnt_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores comments added to pdfs';

--
-- Dumping data for table `mblms_assignfeedback_editpdf_cmnt`
--


--
-- Table structure for table `mblms_assignfeedback_editpdf_queue`
--

CREATE TABLE `mblms_assignfeedback_editpdf_queue` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `submissionid` bigint(10) NOT NULL,
  `submissionattempt` bigint(10) NOT NULL,
  `attemptedconversions` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_assieditqueu_subsub_uix` (`submissionid`,`submissionattempt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Queue for processing.';

--
-- Dumping data for table `mblms_assignfeedback_editpdf_queue`
--


--
-- Table structure for table `mblms_assignfeedback_editpdf_quick`
--

CREATE TABLE `mblms_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 `mblms_assieditquic_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores teacher specified quicklist comments';

--
-- Dumping data for table `mblms_assignfeedback_editpdf_quick`
--


--
-- Table structure for table `mblms_assignfeedback_editpdf_rot`
--

CREATE TABLE `mblms_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 `mblms_assieditrot_grapag_uix` (`gradeid`,`pageno`),
  KEY `mblms_assieditrot_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores rotation information of a page.';

--
-- Dumping data for table `mblms_assignfeedback_editpdf_rot`
--


--
-- Table structure for table `mblms_assignfeedback_file`
--

CREATE TABLE `mblms_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 `mblms_assifile_ass2_ix` (`assignment`),
  KEY `mblms_assifile_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores info about the number of files submitted by a student';

--
-- Dumping data for table `mblms_assignfeedback_file`
--


--
-- Table structure for table `mblms_assignment`
--

CREATE TABLE `mblms_assignment` (
  `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,
  `assignmenttype` varchar(50) NOT NULL DEFAULT '',
  `resubmit` tinyint(2) NOT NULL DEFAULT 0,
  `preventlate` tinyint(2) NOT NULL DEFAULT 0,
  `emailteachers` tinyint(2) NOT NULL DEFAULT 0,
  `var1` bigint(10) DEFAULT 0,
  `var2` bigint(10) DEFAULT 0,
  `var3` bigint(10) DEFAULT 0,
  `var4` bigint(10) DEFAULT 0,
  `var5` bigint(10) DEFAULT 0,
  `maxbytes` bigint(10) NOT NULL DEFAULT 100000,
  `timedue` bigint(10) NOT NULL DEFAULT 0,
  `timeavailable` bigint(10) NOT NULL DEFAULT 0,
  `grade` bigint(10) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_assi_cou2_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines assignments';

--
-- Dumping data for table `mblms_assignment`
--


--
-- Table structure for table `mblms_assignment_submissions`
--

CREATE TABLE `mblms_assignment_submissions` (
  `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,
  `numfiles` bigint(10) NOT NULL DEFAULT 0,
  `data1` longtext DEFAULT NULL,
  `data2` longtext DEFAULT NULL,
  `grade` bigint(11) NOT NULL DEFAULT 0,
  `submissioncomment` longtext NOT NULL,
  `format` smallint(4) NOT NULL DEFAULT 0,
  `teacher` bigint(10) NOT NULL DEFAULT 0,
  `timemarked` bigint(10) NOT NULL DEFAULT 0,
  `mailed` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_assisubm_use2_ix` (`userid`),
  KEY `mblms_assisubm_mai_ix` (`mailed`),
  KEY `mblms_assisubm_tim_ix` (`timemarked`),
  KEY `mblms_assisubm_ass2_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Info about submitted assignments';

--
-- Dumping data for table `mblms_assignment_submissions`
--


--
-- Table structure for table `mblms_assignment_upgrade`
--

CREATE TABLE `mblms_assignment_upgrade` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `oldcmid` bigint(10) NOT NULL DEFAULT 0,
  `oldinstance` bigint(10) NOT NULL DEFAULT 0,
  `newcmid` bigint(10) NOT NULL DEFAULT 0,
  `newinstance` bigint(10) NOT NULL DEFAULT 0,
  `timecreated` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_assiupgr_old_ix` (`oldcmid`),
  KEY `mblms_assiupgr_old2_ix` (`oldinstance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Info about upgraded assignments';

--
-- Dumping data for table `mblms_assignment_upgrade`
--


--
-- Table structure for table `mblms_assignsubmission_file`
--

CREATE TABLE `mblms_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 `mblms_assifile_ass_ix` (`assignment`),
  KEY `mblms_assifile_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Info about file submissions for assignments';

--
-- Dumping data for table `mblms_assignsubmission_file`
--


--
-- Table structure for table `mblms_assignsubmission_onlinetext`
--

CREATE TABLE `mblms_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 `mblms_assionli_ass_ix` (`assignment`),
  KEY `mblms_assionli_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Info about onlinetext submission';

--
-- Dumping data for table `mblms_assignsubmission_onlinetext`
--


--
-- Table structure for table `mblms_auth_oauth2_linked_login`
--

CREATE TABLE `mblms_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 `mblms_authoautlinklogi_use_uix` (`userid`,`issuerid`,`username`),
  KEY `mblms_authoautlinklogi_issu_ix` (`issuerid`,`username`),
  KEY `mblms_authoautlinklogi_use_ix` (`usermodified`),
  KEY `mblms_authoautlinklogi_use2_ix` (`userid`),
  KEY `mblms_authoautlinklogi_iss_ix` (`issuerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Accounts linked to a users Moodle account.';

--
-- Dumping data for table `mblms_auth_oauth2_linked_login`
--


--
-- Table structure for table `mblms_backup_controllers`
--

CREATE TABLE `mblms_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 `mblms_backcont_bac_uix` (`backupid`),
  KEY `mblms_backcont_typite_ix` (`type`,`itemid`),
  KEY `mblms_backcont_useite_ix` (`userid`,`itemid`),
  KEY `mblms_backcont_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='To store the backup_controllers as they are used';

--
-- Dumping data for table `mblms_backup_controllers`
--


--
-- Table structure for table `mblms_backup_courses`
--

CREATE TABLE `mblms_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 `mblms_backcour_cou_uix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='To store every course backup status';

--
-- Dumping data for table `mblms_backup_courses`
--


--
-- Table structure for table `mblms_backup_logs`
--

CREATE TABLE `mblms_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 `mblms_backlogs_bacid_uix` (`backupid`,`id`),
  KEY `mblms_backlogs_bac_ix` (`backupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='To store all the logs from backup and restore operations (by';

--
-- Dumping data for table `mblms_backup_logs`
--


--
-- Table structure for table `mblms_badge`
--

CREATE TABLE `mblms_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,
  `imageauthorname` varchar(255) DEFAULT NULL,
  `imageauthoremail` varchar(255) DEFAULT NULL,
  `imageauthorurl` varchar(255) DEFAULT NULL,
  `imagecaption` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_badg_typ_ix` (`type`),
  KEY `mblms_badg_cou_ix` (`courseid`),
  KEY `mblms_badg_use_ix` (`usermodified`),
  KEY `mblms_badg_use2_ix` (`usercreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines badge';

--
-- Dumping data for table `mblms_badge`
--


--
-- Table structure for table `mblms_badge_alignment`
--

CREATE TABLE `mblms_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 `mblms_badgalig_bad_ix` (`badgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines alignment for badges';

--
-- Dumping data for table `mblms_badge_alignment`
--


--
-- Table structure for table `mblms_badge_backpack`
--

CREATE TABLE `mblms_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 `mblms_badgback_useext_uix` (`userid`,`externalbackpackid`),
  KEY `mblms_badgback_use_ix` (`userid`),
  KEY `mblms_badgback_ext_ix` (`externalbackpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines settings for connecting external backpack';

--
-- Dumping data for table `mblms_badge_backpack`
--


--
-- Table structure for table `mblms_badge_backpack_oauth2`
--

CREATE TABLE `mblms_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 `mblms_badgbackoaut_use_ix` (`usermodified`),
  KEY `mblms_badgbackoaut_use2_ix` (`userid`),
  KEY `mblms_badgbackoaut_iss_ix` (`issuerid`),
  KEY `mblms_badgbackoaut_ext_ix` (`externalbackpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Default comment for the table, please edit me';

--
-- Dumping data for table `mblms_badge_backpack_oauth2`
--


--
-- Table structure for table `mblms_badge_criteria`
--

CREATE TABLE `mblms_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 `mblms_badgcrit_badcri_uix` (`badgeid`,`criteriatype`),
  KEY `mblms_badgcrit_cri_ix` (`criteriatype`),
  KEY `mblms_badgcrit_bad_ix` (`badgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines criteria for issuing badges';

--
-- Dumping data for table `mblms_badge_criteria`
--


--
-- Table structure for table `mblms_badge_criteria_met`
--

CREATE TABLE `mblms_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 `mblms_badgcritmet_cri_ix` (`critid`),
  KEY `mblms_badgcritmet_use_ix` (`userid`),
  KEY `mblms_badgcritmet_iss_ix` (`issuedid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines criteria that were met for an issued badge';

--
-- Dumping data for table `mblms_badge_criteria_met`
--


--
-- Table structure for table `mblms_badge_criteria_param`
--

CREATE TABLE `mblms_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 `mblms_badgcritpara_cri_ix` (`critid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines parameters for badges criteria';

--
-- Dumping data for table `mblms_badge_criteria_param`
--


--
-- Table structure for table `mblms_badge_endorsement`
--

CREATE TABLE `mblms_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 `mblms_badgendo_bad_ix` (`badgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines endorsement for badge';

--
-- Dumping data for table `mblms_badge_endorsement`
--


--
-- Table structure for table `mblms_badge_external`
--

CREATE TABLE `mblms_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 `mblms_badgexte_bac_ix` (`backpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Setting for external badges display';

--
-- Dumping data for table `mblms_badge_external`
--


--
-- Table structure for table `mblms_badge_external_identifier`
--

CREATE TABLE `mblms_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 `mblms_badgexteiden_sitinte_uix` (`sitebackpackid`,`internalid`,`externalid`,`type`),
  KEY `mblms_badgexteiden_sit_ix` (`sitebackpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Setting for external badges mappings';

--
-- Dumping data for table `mblms_badge_external_identifier`
--


--
-- Table structure for table `mblms_badge_issued`
--

CREATE TABLE `mblms_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 `mblms_badgissu_baduse_uix` (`badgeid`,`userid`),
  KEY `mblms_badgissu_bad_ix` (`badgeid`),
  KEY `mblms_badgissu_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines issued badges';

--
-- Dumping data for table `mblms_badge_issued`
--


--
-- Table structure for table `mblms_badge_manual_award`
--

CREATE TABLE `mblms_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 `mblms_badgmanuawar_bad_ix` (`badgeid`),
  KEY `mblms_badgmanuawar_rec_ix` (`recipientid`),
  KEY `mblms_badgmanuawar_iss_ix` (`issuerid`),
  KEY `mblms_badgmanuawar_iss2_ix` (`issuerrole`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Track manual award criteria for badges';

--
-- Dumping data for table `mblms_badge_manual_award`
--


--
-- Table structure for table `mblms_badge_related`
--

CREATE TABLE `mblms_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 `mblms_badgrela_badrel_uix` (`badgeid`,`relatedbadgeid`),
  KEY `mblms_badgrela_bad_ix` (`badgeid`),
  KEY `mblms_badgrela_rel_ix` (`relatedbadgeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines badge related for badges';

--
-- Dumping data for table `mblms_badge_related`
--


--
-- Table structure for table `mblms_block`
--

CREATE TABLE `mblms_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 `mblms_bloc_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='contains all installed blocks';

--
-- Dumping data for table `mblms_block`
--

INSERT INTO `mblms_block` VALUES (1,'activity_modules',0,0,1),(2,'activity_results',0,0,1),(3,'admin_bookmarks',0,0,1),(4,'badges',0,0,1),(5,'blog_menu',0,0,1),(6,'blog_recent',0,0,1),(7,'blog_tags',0,0,1),(8,'calendar_month',0,0,1),(9,'calendar_upcoming',0,0,1),(10,'comments',0,0,1),(11,'completionstatus',0,0,1),(12,'course_list',0,0,1),(13,'course_summary',0,0,1),(14,'feedback',0,0,1),(15,'globalsearch',0,0,1),(16,'glossary_random',0,0,1),(17,'html',0,0,1),(18,'login',0,0,1),(19,'lp',0,0,1),(20,'mentees',0,0,1),(21,'mnet_hosts',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,'quiz_results',0,0,0),(29,'recent_activity',0,0,1),(30,'recentlyaccessedcourses',0,0,1),(31,'recentlyaccesseditems',0,0,1),(32,'rss_client',0,0,1),(33,'search_forums',0,0,1),(34,'section_links',0,0,1),(35,'selfcompletion',0,0,1),(36,'settings',0,0,1),(37,'site_main_menu',0,0,1),(38,'social_activities',0,0,1),(39,'starredcourses',0,0,1),(40,'tag_flickr',0,0,1),(41,'tag_youtube',0,0,0),(42,'tags',0,0,1),(43,'timeline',0,0,1);

--
-- Table structure for table `mblms_block_instances`
--

CREATE TABLE `mblms_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 `mblms_blocinst_parshopagsub_ix` (`parentcontextid`,`showinsubcontexts`,`pagetypepattern`,`subpagepattern`),
  KEY `mblms_blocinst_tim_ix` (`timemodified`),
  KEY `mblms_blocinst_par_ix` (`parentcontextid`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table stores block instances. The type of block this is';

--
-- Dumping data for table `mblms_block_instances`
--

INSERT INTO `mblms_block_instances` VALUES (1,'admin_bookmarks',1,0,0,'admin-*',NULL,'side-pre',2,'',1616486358,1616486358),(2,'timeline',1,0,0,'my-index','2','side-post',0,'',1616486358,1616486358),(3,'private_files',1,0,0,'my-index','2','side-post',1,'',1616486358,1616486358),(4,'online_users',1,0,0,'my-index','2','side-post',2,'',1616486358,1616486358),(5,'badges',1,0,0,'my-index','2','side-post',3,'',1616486358,1616486358),(6,'calendar_month',1,0,0,'my-index','2','side-post',4,'',1616486358,1616486358),(7,'calendar_upcoming',1,0,0,'my-index','2','side-post',5,'',1616486358,1616486358),(8,'lp',1,0,0,'my-index','2','content',0,'',1616486358,1616486358),(9,'recentlyaccessedcourses',1,0,0,'my-index','2','content',1,'',1616486358,1616486358),(10,'myoverview',1,0,0,'my-index','2','content',2,'',1616486358,1616486358),(11,'timeline',5,0,0,'my-index','3','side-post',0,'',1616487247,1616487247),(12,'private_files',5,0,0,'my-index','3','side-post',1,'',1616487247,1616487247),(13,'online_users',5,0,0,'my-index','3','side-post',2,'',1616487247,1616487247),(14,'badges',5,0,0,'my-index','3','side-post',3,'',1616487247,1616487247),(15,'calendar_month',5,0,0,'my-index','3','side-post',4,'',1616487247,1616487247),(16,'calendar_upcoming',5,0,0,'my-index','3','side-post',5,'',1616487247,1616487247),(17,'lp',5,0,0,'my-index','3','content',0,'',1616487247,1616487247),(18,'recentlyaccessedcourses',5,0,0,'my-index','3','content',1,'',1616487247,1616487247),(19,'myoverview',5,0,0,'my-index','3','content',2,'',1616487247,1616487247),(20,'navigation',1,1,1,'*',NULL,'side-post',0,'',1616488563,1616488563),(21,'settings',1,1,1,'*',NULL,'side-post',0,'',1616488563,1616488563);

--
-- Table structure for table `mblms_block_positions`
--

CREATE TABLE `mblms_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 `mblms_blocposi_bloconpagsu_uix` (`blockinstanceid`,`contextid`,`pagetype`,`subpage`),
  KEY `mblms_blocposi_blo_ix` (`blockinstanceid`),
  KEY `mblms_blocposi_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores the position of a sticky block_instance on a another ';

--
-- Dumping data for table `mblms_block_positions`
--


--
-- Table structure for table `mblms_block_recent_activity`
--

CREATE TABLE `mblms_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 `mblms_blocreceacti_coutim_ix` (`courseid`,`timecreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Recent activity block';

--
-- Dumping data for table `mblms_block_recent_activity`
--


--
-- Table structure for table `mblms_block_recentlyaccesseditems`
--

CREATE TABLE `mblms_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 `mblms_blocrece_usecoucmi_uix` (`userid`,`courseid`,`cmid`),
  KEY `mblms_blocrece_use_ix` (`userid`),
  KEY `mblms_blocrece_cou_ix` (`courseid`),
  KEY `mblms_blocrece_cmi_ix` (`cmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Most recently accessed items accessed by a user';

--
-- Dumping data for table `mblms_block_recentlyaccesseditems`
--


--
-- Table structure for table `mblms_block_rss_client`
--

CREATE TABLE `mblms_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 ROW_FORMAT=COMPRESSED COMMENT='Remote news feed information. Contains the news feed id, the';

--
-- Dumping data for table `mblms_block_rss_client`
--


--
-- Table structure for table `mblms_blog_association`
--

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

--
-- Dumping data for table `mblms_blog_association`
--


--
-- Table structure for table `mblms_blog_external`
--

CREATE TABLE `mblms_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 `mblms_blogexte_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='External blog links used for RSS copying of blog entries to ';

--
-- Dumping data for table `mblms_blog_external`
--


--
-- Table structure for table `mblms_book`
--

CREATE TABLE `mblms_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines book';

--
-- Dumping data for table `mblms_book`
--


--
-- Table structure for table `mblms_book_chapters`
--

CREATE TABLE `mblms_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 `mblms_bookchap_boo_ix` (`bookid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Defines book_chapters';

--
-- Dumping data for table `mblms_book_chapters`
--


--
-- Table structure for table `mblms_cache_filters`
--

CREATE TABLE `mblms_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 `mblms_cachfilt_filmd5_ix` (`filter`,`md5key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='For keeping information about cached data';

--
-- Dumping data for table `mblms_cache_filters`
--


--
-- Table structure for table `mblms_cache_flags`
--

CREATE TABLE `mblms_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 `mblms_cachflag_fla_ix` (`flagtype`),
  KEY `mblms_cachflag_nam_ix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Cache of time-sensitive flags';

--
-- Dumping data for table `mblms_cache_flags`
--

INSERT INTO `mblms_cache_flags` VALUES (1,'userpreferenceschanged','2',1616568128,'1',1616596928),(2,'accesslib/dirtycontexts','/1/27',1616488952,'1',1616517752),(3,'accesslib/dirtycontexts','/1/27/28',1616488952,'1',1616517752),(4,'accesslib/dirtycontexts','/1/28',1616488969,'1',1616517769);

--
-- Table structure for table `mblms_capabilities`
--

CREATE TABLE `mblms_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 `mblms_capa_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=686 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='this defines all capabilities';

--
-- Dumping data for table `mblms_capabilities`
--

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

--
-- Table structure for table `mblms_chat`
--

CREATE TABLE `mblms_chat` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT 0,
  `keepdays` bigint(11) NOT NULL DEFAULT 0,
  `studentlogs` smallint(4) NOT NULL DEFAULT 0,
  `chattime` bigint(10) NOT NULL DEFAULT 0,
  `schedule` smallint(4) NOT NULL DEFAULT 0,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_chat_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Each of these is a chat room';

--
-- Dumping data for table `mblms_chat`
--


--
-- Table structure for table `mblms_chat_messages`
--

CREATE TABLE `mblms_chat_messages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `chatid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `issystem` tinyint(1) NOT NULL DEFAULT 0,
  `message` longtext NOT NULL,
  `timestamp` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_chatmess_use_ix` (`userid`),
  KEY `mblms_chatmess_gro_ix` (`groupid`),
  KEY `mblms_chatmess_timcha_ix` (`timestamp`,`chatid`),
  KEY `mblms_chatmess_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores all the actual chat messages';

--
-- Dumping data for table `mblms_chat_messages`
--


--
-- Table structure for table `mblms_chat_messages_current`
--

CREATE TABLE `mblms_chat_messages_current` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `chatid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `issystem` tinyint(1) NOT NULL DEFAULT 0,
  `message` longtext NOT NULL,
  `timestamp` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_chatmesscurr_use_ix` (`userid`),
  KEY `mblms_chatmesscurr_gro_ix` (`groupid`),
  KEY `mblms_chatmesscurr_timcha_ix` (`timestamp`,`chatid`),
  KEY `mblms_chatmesscurr_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores current session';

--
-- Dumping data for table `mblms_chat_messages_current`
--


--
-- Table structure for table `mblms_chat_users`
--

CREATE TABLE `mblms_chat_users` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `chatid` bigint(11) NOT NULL DEFAULT 0,
  `userid` bigint(11) NOT NULL DEFAULT 0,
  `groupid` bigint(11) NOT NULL DEFAULT 0,
  `version` varchar(16) NOT NULL DEFAULT '',
  `ip` varchar(45) NOT NULL DEFAULT '',
  `firstping` bigint(10) NOT NULL DEFAULT 0,
  `lastping` bigint(10) NOT NULL DEFAULT 0,
  `lastmessageping` bigint(10) NOT NULL DEFAULT 0,
  `sid` varchar(32) NOT NULL DEFAULT '',
  `course` bigint(10) NOT NULL DEFAULT 0,
  `lang` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mblms_chatuser_use_ix` (`userid`),
  KEY `mblms_chatuser_las_ix` (`lastping`),
  KEY `mblms_chatuser_gro_ix` (`groupid`),
  KEY `mblms_chatuser_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Keeps track of which users are in which chat rooms';

--
-- Dumping data for table `mblms_chat_users`
--


--
-- Table structure for table `mblms_choice`
--

CREATE TABLE `mblms_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 `mblms_choi_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Available choices are stored here';

--
-- Dumping data for table `mblms_choice`
--


--
-- Table structure for table `mblms_choice_answers`
--

CREATE TABLE `mblms_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 `mblms_choiansw_use_ix` (`userid`),
  KEY `mblms_choiansw_cho_ix` (`choiceid`),
  KEY `mblms_choiansw_opt_ix` (`optionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='choices performed by users';

--
-- Dumping data for table `mblms_choice_answers`
--


--
-- Table structure for table `mblms_choice_options`
--

CREATE TABLE `mblms_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 `mblms_choiopti_cho_ix` (`choiceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='available options to choice';

--
-- Dumping data for table `mblms_choice_options`
--


--
-- Table structure for table `mblms_cohort`
--

CREATE TABLE `mblms_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 `mblms_coho_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Each record represents one cohort (aka site-wide group).';

--
-- Dumping data for table `mblms_cohort`
--


--
-- Table structure for table `mblms_cohort_members`
--

CREATE TABLE `mblms_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 `mblms_cohomemb_cohuse_uix` (`cohortid`,`userid`),
  KEY `mblms_cohomemb_coh_ix` (`cohortid`),
  KEY `mblms_cohomemb_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Link a user to a cohort.';

--
-- Dumping data for table `mblms_cohort_members`
--


--
-- Table structure for table `mblms_comments`
--

CREATE TABLE `mblms_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 `mblms_comm_concomite_ix` (`contextid`,`commentarea`,`itemid`),
  KEY `mblms_comm_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='moodle comments module';

--
-- Dumping data for table `mblms_comments`
--


--
-- Table structure for table `mblms_competency`
--

CREATE TABLE `mblms_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 `mblms_comp_comidn_uix` (`competencyframeworkid`,`idnumber`),
  KEY `mblms_comp_rul_ix` (`ruleoutcome`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table contains the master record of each competency in ';

--
-- Dumping data for table `mblms_competency`
--


--
-- Table structure for table `mblms_competency_coursecomp`
--

CREATE TABLE `mblms_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 `mblms_compcour_coucom_uix` (`courseid`,`competencyid`),
  KEY `mblms_compcour_courul_ix` (`courseid`,`ruleoutcome`),
  KEY `mblms_compcour_cou2_ix` (`courseid`),
  KEY `mblms_compcour_com_ix` (`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Link a competency to a course.';

--
-- Dumping data for table `mblms_competency_coursecomp`
--


--
-- Table structure for table `mblms_competency_coursecompsetting`
--

CREATE TABLE `mblms_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 `mblms_compcour_cou_uix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table contains the course specific settings for compete';

--
-- Dumping data for table `mblms_competency_coursecompsetting`
--


--
-- Table structure for table `mblms_competency_evidence`
--

CREATE TABLE `mblms_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 `mblms_compevid_use_ix` (`usercompetencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='The evidence linked to a user competency';

--
-- Dumping data for table `mblms_competency_evidence`
--


--
-- Table structure for table `mblms_competency_framework`
--

CREATE TABLE `mblms_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 `mblms_compfram_idn_uix` (`idnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='List of competency frameworks.';

--
-- Dumping data for table `mblms_competency_framework`
--


--
-- Table structure for table `mblms_competency_modulecomp`
--

CREATE TABLE `mblms_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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_compmodu_cmicom_uix` (`cmid`,`competencyid`),
  KEY `mblms_compmodu_cmirul_ix` (`cmid`,`ruleoutcome`),
  KEY `mblms_compmodu_cmi_ix` (`cmid`),
  KEY `mblms_compmodu_com_ix` (`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Link a competency to a module.';

--
-- Dumping data for table `mblms_competency_modulecomp`
--


--
-- Table structure for table `mblms_competency_plan`
--

CREATE TABLE `mblms_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 `mblms_compplan_usesta_ix` (`userid`,`status`),
  KEY `mblms_compplan_tem_ix` (`templateid`),
  KEY `mblms_compplan_stadue_ix` (`status`,`duedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Learning plans';

--
-- Dumping data for table `mblms_competency_plan`
--


--
-- Table structure for table `mblms_competency_plancomp`
--

CREATE TABLE `mblms_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 `mblms_compplan_placom_uix` (`planid`,`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Plan competencies';

--
-- Dumping data for table `mblms_competency_plancomp`
--


--
-- Table structure for table `mblms_competency_relatedcomp`
--

CREATE TABLE `mblms_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Related competencies';

--
-- Dumping data for table `mblms_competency_relatedcomp`
--


--
-- Table structure for table `mblms_competency_template`
--

CREATE TABLE `mblms_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Learning plan templates.';

--
-- Dumping data for table `mblms_competency_template`
--


--
-- Table structure for table `mblms_competency_templatecohort`
--

CREATE TABLE `mblms_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 `mblms_comptemp_temcoh_uix` (`templateid`,`cohortid`),
  KEY `mblms_comptemp_tem2_ix` (`templateid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Default comment for the table, please edit me';

--
-- Dumping data for table `mblms_competency_templatecohort`
--


--
-- Table structure for table `mblms_competency_templatecomp`
--

CREATE TABLE `mblms_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 `mblms_comptemp_tem_ix` (`templateid`),
  KEY `mblms_comptemp_com_ix` (`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Link a competency to a learning plan template.';

--
-- Dumping data for table `mblms_competency_templatecomp`
--


--
-- Table structure for table `mblms_competency_usercomp`
--

CREATE TABLE `mblms_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 `mblms_compuser_usecom_uix` (`userid`,`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='User competencies';

--
-- Dumping data for table `mblms_competency_usercomp`
--


--
-- Table structure for table `mblms_competency_usercompcourse`
--

CREATE TABLE `mblms_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 `mblms_compuser_usecoucom_uix` (`userid`,`courseid`,`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='User competencies in a course';

--
-- Dumping data for table `mblms_competency_usercompcourse`
--


--
-- Table structure for table `mblms_competency_usercompplan`
--

CREATE TABLE `mblms_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 `mblms_compuser_usecompla_uix` (`userid`,`competencyid`,`planid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='User competencies plans';

--
-- Dumping data for table `mblms_competency_usercompplan`
--


--
-- Table structure for table `mblms_competency_userevidence`
--

CREATE TABLE `mblms_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 `mblms_compuser_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='The evidence of prior learning';

--
-- Dumping data for table `mblms_competency_userevidence`
--


--
-- Table structure for table `mblms_competency_userevidencecomp`
--

CREATE TABLE `mblms_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 `mblms_compuser_usecom2_uix` (`userevidenceid`,`competencyid`),
  KEY `mblms_compuser_use2_ix` (`userevidenceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Relationship between user evidence and competencies';

--
-- Dumping data for table `mblms_competency_userevidencecomp`
--


--
-- Table structure for table `mblms_config`
--

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

--
-- Dumping data for table `mblms_config`
--

INSERT INTO `mblms_config` VALUES (2,'rolesactive','1'),(3,'auth','email'),(4,'enrol_plugins_enabled','manual,guest,self,cohort'),(5,'theme','boost'),(6,'filter_multilang_converted','1'),(7,'siteidentifier','2AuuJsbgtP9bMj73nQZDEfZ7Q8ruRQ4Nlocalhost'),(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','atto,tinymce,textarea'),(15,'antiviruses',''),(16,'media_plugins_sortorder','videojs,youtube,swf'),(17,'upgrade_extracreditweightsstepignored','1'),(18,'upgrade_calculatedgradeitemsignored','1'),(19,'upgrade_letterboundarycourses','1'),(20,'mnet_localhost_id','1'),(21,'mnet_all_hosts_id','2'),(22,'siteguest','1'),(23,'siteadmins','2'),(24,'themerev','1616490331'),(25,'jsrev','1616490247'),(26,'templaterev','1616490247'),(27,'gdversion','2'),(28,'licenses','unknown,allrightsreserved,public,cc,cc-nd,cc-nc-nd,cc-nc,cc-nc-sa,cc-sa'),(29,'sitedefaultlicense','unknown'),(30,'badges_site_backpack','1'),(31,'version','2020110901'),(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,'completiondefault','1'),(46,'enableavailability','1'),(47,'enableplagiarism','0'),(48,'enablebadges','1'),(49,'enableglobalsearch','0'),(50,'allowstealth','0'),(51,'enableanalytics','1'),(52,'allowemojipicker','1'),(53,'userfiltersdefault','realname'),(54,'defaultpreference_maildisplay','2'),(55,'defaultpreference_mailformat','1'),(56,'defaultpreference_maildigest','0'),(57,'defaultpreference_autosubscribe','1'),(58,'defaultpreference_trackforums','0'),(59,'autologinguests','0'),(60,'hiddenuserfields',''),(61,'showuseridentity','email'),(62,'fullnamedisplay','language'),(63,'alternativefullnameformat','language'),(64,'maxusersperpage','100'),(65,'enablegravatar','0'),(66,'gravatardefaulturl','mm'),(67,'agedigitalconsentverification','0'),(68,'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'),(69,'sitepolicy',''),(70,'sitepolicyguest',''),(71,'downloadcoursecontentallowed','0'),(72,'maxsizeperdownloadcoursefile','52428800'),(73,'enablecourserequests','1'),(74,'defaultrequestcategory','2'),(75,'lockrequestcategory','0'),(76,'courserequestnotify',''),(77,'activitychoosertabmode','0'),(78,'activitychooseractivefooter','hidden'),(79,'enableasyncbackup','0'),(80,'grade_profilereport','user'),(81,'grade_aggregationposition','1'),(82,'grade_includescalesinaggregation','1'),(83,'grade_hiddenasdate','0'),(84,'gradepublishing','0'),(85,'grade_export_exportfeedback','0'),(86,'grade_export_displaytype','1'),(87,'grade_export_decimalpoints','2'),(88,'grade_navmethod','1'),(89,'grade_export_userprofilefields','firstname,lastname,idnumber,institution,department,email'),(90,'grade_export_customprofilefields',''),(91,'recovergradesdefault','0'),(92,'gradeexport',''),(93,'unlimitedgrades','0'),(94,'grade_report_showmin','1'),(95,'gradepointmax','100'),(96,'gradepointdefault','100'),(97,'grade_minmaxtouse','1'),(98,'grade_mygrades_report','overview'),(99,'gradereport_mygradeurl',''),(100,'grade_hideforcedsettings','1'),(101,'grade_aggregation','13'),(102,'grade_aggregation_flag','0'),(103,'grade_aggregations_visible','13'),(104,'grade_aggregateonlygraded','1'),(105,'grade_aggregateonlygraded_flag','2'),(106,'grade_aggregateoutcomes','0'),(107,'grade_aggregateoutcomes_flag','2'),(108,'grade_keephigh','0'),(109,'grade_keephigh_flag','3'),(110,'grade_droplow','0'),(111,'grade_droplow_flag','2'),(112,'grade_overridecat','1'),(113,'grade_displaytype','1'),(114,'grade_decimalpoints','2'),(115,'grade_item_advanced','iteminfo,idnumber,gradepass,plusfactor,multfactor,display,decimals,hiddenuntil,locktime'),(116,'grade_report_studentsperpage','100'),(117,'grade_report_showonlyactiveenrol','1'),(118,'grade_report_quickgrading','1'),(119,'grade_report_showquickfeedback','0'),(120,'grade_report_meanselection','1'),(121,'grade_report_enableajax','0'),(122,'grade_report_showcalculations','1'),(123,'grade_report_showeyecons','0'),(124,'grade_report_showaverages','1'),(125,'grade_report_showlocks','0'),(126,'grade_report_showranges','0'),(127,'grade_report_showanalysisicon','1'),(128,'grade_report_showuserimage','1'),(129,'grade_report_showactivityicons','1'),(130,'grade_report_shownumberofgrades','0'),(131,'grade_report_averagesdisplaytype','inherit'),(132,'grade_report_rangesdisplaytype','inherit'),(133,'grade_report_averagesdecimalpoints','inherit'),(134,'grade_report_rangesdecimalpoints','inherit'),(135,'grade_report_historyperpage','50'),(136,'grade_report_overview_showrank','0'),(137,'grade_report_overview_showtotalsifcontainhidden','0'),(138,'grade_report_user_showrank','0'),(139,'grade_report_user_showpercentage','1'),(140,'grade_report_user_showgrade','1'),(141,'grade_report_user_showfeedback','1'),(142,'grade_report_user_showrange','1'),(143,'grade_report_user_showweight','1'),(144,'grade_report_user_showaverage','0'),(145,'grade_report_user_showlettergrade','0'),(146,'grade_report_user_rangedecimals','0'),(147,'grade_report_user_showhiddenitems','1'),(148,'grade_report_user_showtotalsifcontainhidden','0'),(149,'grade_report_user_showcontributiontocoursetotal','1'),(150,'badges_defaultissuername',''),(151,'badges_defaultissuercontact',''),(152,'badges_badgesalt','badges1616485854'),(153,'badges_allowcoursebadges','1'),(154,'badges_allowexternalbackpack','1'),(155,'rememberuserlicensepref','1'),(157,'forcetimezone','99'),(158,'country','0'),(159,'defaultcity',''),(160,'geoip2file','C:\\xampp\\moodledata/geoip/GeoLite2-City.mmdb'),(161,'googlemapkey3',''),(162,'allcountrycodes',''),(163,'autolang','1'),(164,'lang','en'),(165,'autolangusercreation','1'),(166,'langmenu','1'),(167,'langlist',''),(168,'langrev','1616490247'),(169,'langcache','1'),(170,'langstringcache','1'),(171,'locale',''),(172,'latinexcelexport','0'),(173,'messaging','1'),(174,'messagingallusers','0'),(175,'messagingdefaultpressenter','1'),(176,'messagingdeletereadnotificationsdelay','604800'),(177,'messagingdeleteallnotificationsdelay','2620800'),(178,'messagingallowemailoverride','0'),(179,'requiremodintro','0'),(181,'authloginviaemail','0'),(182,'allowaccountssameemail','0'),(183,'authpreventaccountcreation','0'),(184,'loginpageautofocus','0'),(185,'guestloginbutton','1'),(186,'limitconcurrentlogins','0'),(187,'alternateloginurl',''),(188,'forgottenpasswordurl',''),(189,'auth_instructions',''),(190,'allowemailaddresses',''),(191,'denyemailaddresses',''),(192,'verifychangedemail','1'),(193,'recaptchapublickey',''),(194,'recaptchaprivatekey',''),(195,'filteruploadedfiles','0'),(196,'filtermatchoneperpage','0'),(197,'filtermatchonepertext','0'),(198,'media_default_width','400'),(199,'media_default_height','300'),(200,'portfolio_moderate_filesize_threshold','1048576'),(201,'portfolio_high_filesize_threshold','5242880'),(202,'portfolio_moderate_db_threshold','20'),(203,'portfolio_high_db_threshold','50'),(204,'repositorycacheexpire','120'),(205,'repositorygetfiletimeout','30'),(206,'repositorysyncfiletimeout','1'),(207,'repositorysyncimagetimeout','3'),(208,'repositoryallowexternallinks','1'),(209,'legacyfilesinnewcourses','0'),(210,'legacyfilesaddallowed','1'),(211,'searchengine','simpledb'),(212,'searchindexwhendisabled','0'),(213,'searchindextime','600'),(214,'searchallavailablecourses','0'),(215,'searchincludeallcourses','0'),(216,'searchenablecategories','0'),(217,'searchdefaultcategory','core-all'),(218,'searchhideallcategory','0'),(219,'searchenginequeryonly',''),(220,'searchbannerenable','0'),(221,'searchbanner',''),(222,'enablewsdocumentation','0'),(223,'allowbeforeblock','0'),(224,'allowedip',''),(225,'blockedip',''),(226,'protectusernames','1'),(227,'forcelogin','0'),(228,'forceloginforprofiles','1'),(229,'forceloginforprofileimage','0'),(230,'opentowebcrawlers','0'),(231,'allowindexing','0'),(232,'maxbytes','0'),(233,'userquota','104857600'),(234,'allowobjectembed','0'),(235,'enabletrusttext','0'),(236,'maxeditingtime','1800'),(237,'extendedusernamechars','0'),(238,'keeptagnamecase','1'),(239,'profilesforenrolledusersonly','1'),(240,'cronclionly','1'),(241,'cronremotepassword',''),(242,'lockoutthreshold','0'),(243,'lockoutwindow','1800'),(244,'lockoutduration','1800'),(245,'passwordpolicy','1'),(246,'minpasswordlength','8'),(247,'minpassworddigits','1'),(248,'minpasswordlower','1'),(249,'minpasswordupper','1'),(250,'minpasswordnonalphanum','1'),(251,'maxconsecutiveidentchars','0'),(252,'passwordpolicycheckonlogin','0'),(253,'passwordreuselimit','0'),(254,'pwresettime','1800'),(255,'passwordchangelogout','0'),(256,'passwordchangetokendeletion','0'),(257,'tokenduration','7257600'),(258,'groupenrolmentkeypolicy','1'),(259,'disableuserimages','0'),(260,'emailchangeconfirmation','1'),(261,'rememberusername','2'),(262,'strictformsrequired','0'),(263,'cookiesecure','1'),(264,'cookiehttponly','0'),(265,'allowframembedding','0'),(266,'curlsecurityblockedhosts',''),(267,'curlsecurityallowedport',''),(268,'referrerpolicy','default'),(269,'displayloginfailures','0'),(270,'notifyloginfailures',''),(271,'notifyloginthreshold','10'),(272,'themelist',''),(273,'themedesignermode','0'),(274,'allowuserthemes','0'),(275,'allowcoursethemes','0'),(276,'allowcategorythemes','0'),(277,'allowcohortthemes','0'),(278,'allowthemechangeonurl','0'),(279,'allowuserblockhiding','1'),(280,'langmenuinsecurelayout','0'),(281,'logininfoinsecurelayout','0'),(282,'custommenuitems',''),(283,'customusermenuitems','grades,grades|/grade/report/mygrades.php|t/grades\nmessages,message|/message/index.php|t/message\npreferences,moodle|/user/preferences.php|t/preferences'),(284,'enabledevicedetection','1'),(285,'devicedetectregex','[]'),(286,'calendartype','gregorian'),(287,'calendar_adminseesall','0'),(288,'calendar_site_timeformat','0'),(289,'calendar_startwday','1'),(290,'calendar_weekend','65'),(291,'calendar_lookahead','21'),(292,'calendar_maxevents','10'),(293,'enablecalendarexport','1'),(294,'calendar_customexport','1'),(295,'calendar_exportlookahead','365'),(296,'calendar_exportlookback','5'),(297,'calendar_exportsalt','iomlqyCiR0ZRMEFRFp28i1JdodLc3tQX9O2GF40ReILrrU9yDJWfNgJxEZpL'),(298,'calendar_showicalsource','1'),(299,'useblogassociations','1'),(300,'bloglevel','4'),(301,'useexternalblogs','1'),(302,'externalblogcrontime','86400'),(303,'maxexternalblogsperuser','1'),(304,'blogusecomments','1'),(305,'blogshowcommentscount','1'),(306,'defaulthomepage','1'),(307,'allowguestmymoodle','1'),(308,'navshowfullcoursenames','0'),(309,'navshowcategories','1'),(310,'navshowmycoursecategories','0'),(311,'navshowallcourses','0'),(312,'navsortmycoursessort','sortorder'),(313,'navsortmycourseshiddenlast','1'),(314,'navcourselimit','10'),(315,'usesitenameforsitepages','0'),(316,'linkadmincategories','1'),(317,'linkcoursesections','1'),(318,'navshowfrontpagemods','1'),(319,'navadduserpostslinks','1'),(320,'formatstringstriptags','1'),(321,'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\"}]'),(322,'docroot','https://docs.moodle.org'),(323,'doclang',''),(324,'doctonewwindow','0'),(325,'coursecontactduplicates','0'),(326,'courselistshortnames','0'),(327,'coursesperpage','20'),(328,'courseswithsummarieslimit','10'),(329,'courseoverviewfileslimit','1'),(330,'courseoverviewfilesext','.jpg,.gif,.png'),(331,'coursegraceperiodbefore','0'),(332,'coursegraceperiodafter','0'),(333,'useexternalyui','0'),(334,'yuicomboloading','1'),(335,'cachejs','1'),(336,'modchooserdefault','1'),(337,'additionalhtmlhead',''),(338,'additionalhtmltopofbody',''),(339,'additionalhtmlfooter',''),(340,'cachetemplates','1'),(341,'pathtophp',''),(342,'pathtodu',''),(343,'aspellpath',''),(344,'pathtodot',''),(345,'pathtogs','/usr/bin/gs'),(346,'pathtopython',''),(347,'supportname','Admin User'),(348,'supportemail',''),(349,'supportpage',''),(350,'dbsessions','0'),(351,'sessioncookie',''),(352,'sessioncookiepath',''),(353,'sessioncookiedomain',''),(354,'statsfirstrun','none'),(355,'statsmaxruntime','0'),(356,'statsruntimedays','31'),(357,'statsuserthreshold','0'),(358,'slasharguments','1'),(359,'getremoteaddrconf','3'),(360,'reverseproxyignore',''),(361,'proxyhost',''),(362,'proxyport','0'),(363,'proxytype','HTTP'),(364,'proxyuser',''),(365,'proxypassword',''),(366,'proxybypass','localhost, 127.0.0.1'),(367,'maintenance_enabled','0'),(368,'maintenance_message',''),(369,'deleteunconfirmed','168'),(370,'deleteincompleteusers','0'),(371,'disablegradehistory','0'),(372,'gradehistorylifetime','0'),(373,'tempdatafoldercleanup','168'),(374,'filescleanupperiod','86400'),(375,'extramemorylimit','512M'),(376,'maxtimelimit','0'),(377,'curlcache','120'),(378,'curltimeoutkbitrate','56'),(379,'cron_enabled','1'),(380,'task_scheduled_concurrency_limit','3'),(381,'task_scheduled_max_runtime','1800'),(382,'task_adhoc_concurrency_limit','3'),(383,'task_adhoc_max_runtime','1800'),(384,'task_logmode','1'),(385,'task_logtostdout','1'),(386,'task_logretention','2419200'),(387,'task_logretainruns','20'),(388,'smtphosts',''),(389,'smtpsecure',''),(390,'smtpauthtype','LOGIN'),(391,'smtpuser',''),(392,'smtppass',''),(393,'smtpmaxbulk','1'),(394,'allowedemaildomains',''),(395,'divertallemailsto',''),(396,'divertallemailsexcept',''),(397,'emaildkimselector',''),(398,'sitemailcharset','0'),(399,'allowusermailcharset','0'),(400,'allowattachments','1'),(401,'mailnewline','LF'),(402,'emailfromvia','1'),(403,'emailsubjectprefix',''),(404,'emailheaders',''),(405,'updateautocheck','1'),(406,'updateminmaturity','200'),(407,'updatenotifybuilds','0'),(408,'dndallowtextandlinks','0'),(409,'pathtosassc',''),(410,'contextlocking','0'),(411,'contextlockappliestoadmin','1'),(412,'forceclean','0'),(413,'enablecourserelativedates','0'),(414,'debug','0'),(415,'debugdisplay','1'),(416,'perfdebug','7'),(417,'debugstringids','0'),(418,'debugsqltrace','0'),(419,'debugvalidators','0'),(420,'debugpageinfo','0'),(421,'profilingenabled','0'),(422,'profilingincluded',''),(423,'profilingexcluded',''),(424,'profilingautofrec','0'),(425,'profilingallowme','0'),(426,'profilingallowall','0'),(427,'profilingslow','0'),(428,'profilinglifetime','1440'),(429,'profilingimportprefix','(I)'),(430,'release','3.10.1 (Build: 20210118)'),(431,'localcachedirpurged','1616490248'),(432,'scheduledtaskreset','1616490248'),(433,'paygw_plugins_sortorder','paypal'),(434,'allversionshash','7a29b783cbf3461c0b7caa749b322484c9049bb8'),(436,'registrationpending','0'),(437,'branch','310'),(438,'notloggedinroleid','6'),(439,'guestroleid','6'),(440,'defaultuserroleid','7'),(441,'creatornewroleid','3'),(442,'restorernewroleid','3'),(443,'sitepolicyhandler',''),(444,'gradebookroles','5'),(445,'h5plibraryhandler','h5plib_v124'),(446,'jabberhost',''),(447,'jabberserver',''),(448,'jabberusername',''),(449,'jabberpassword',''),(450,'jabberport','5222'),(451,'airnotifierurl','https://messages.moodle.net'),(452,'airnotifierport','443'),(453,'airnotifiermobileappname','com.moodle.moodlemobile'),(454,'airnotifierappname','commoodlemoodlemobile'),(455,'airnotifieraccesskey',''),(456,'chat_method','ajax'),(457,'chat_refresh_userlist','10'),(458,'chat_old_ping','35'),(459,'chat_refresh_room','5'),(460,'chat_normal_updatemode','jsupdate'),(461,'chat_serverhost','localhost'),(462,'chat_serverip','127.0.0.1'),(463,'chat_serverport','9111'),(464,'chat_servermax','100'),(465,'data_enablerssfeeds','0'),(466,'feedback_allowfullanonymous','0'),(467,'forum_displaymode','3'),(468,'forum_shortpost','300'),(469,'forum_longpost','600'),(470,'forum_manydiscussions','100'),(471,'forum_maxbytes','512000'),(472,'forum_maxattachments','9'),(473,'forum_subscription','0'),(474,'forum_trackingtype','1'),(475,'forum_trackreadposts','1'),(476,'forum_allowforcedreadtracking','0'),(477,'forum_oldpostdays','14'),(478,'forum_usermarksread','0'),(479,'forum_cleanreadtime','2'),(480,'digestmailtime','17'),(481,'forum_enablerssfeeds','0'),(482,'forum_enabletimedposts','1'),(483,'glossary_entbypage','10'),(484,'glossary_dupentries','0'),(485,'glossary_allowcomments','0'),(486,'glossary_linkbydefault','1'),(487,'glossary_defaultapproval','1'),(488,'glossary_enablerssfeeds','0'),(489,'glossary_linkentries','0'),(490,'glossary_casesensitive','0'),(491,'glossary_fullmatch','0'),(492,'block_course_list_adminview','all'),(493,'block_course_list_hideallcourseslink','0'),(494,'block_html_allowcssclasses','0'),(495,'block_online_users_timetosee','5'),(496,'block_online_users_onlinestatushiding','1'),(497,'block_rss_client_num_entries','5'),(498,'block_rss_client_timeout','30'),(499,'pathtounoconv','/usr/bin/unoconv'),(500,'filter_multilang_force_old','0'),(501,'filter_censor_badwords',''),(502,'logguests','1'),(503,'loglifetime','0'),(504,'profileroles','5,4,3'),(505,'coursecontact','3'),(506,'frontpage','6,7'),(507,'frontpageloggedin','6'),(508,'maxcategorydepth','2'),(509,'frontpagecourselimit','200'),(510,'commentsperpage','15'),(511,'defaultfrontpageroleid','8'),(512,'messageinbound_enabled','0'),(513,'messageinbound_mailbox',''),(514,'messageinbound_domain',''),(515,'messageinbound_host',''),(516,'messageinbound_hostssl','ssl'),(517,'messageinbound_hostuser',''),(518,'messageinbound_hostpass',''),(519,'enablemobilewebservice','0'),(520,'mobilecssurl',''),(521,'timezone','Africa/Nairobi'),(522,'registerauth',''),(523,'noreplyaddress','rwanjiku@mobisky.biz'),(525,'theme_adaptable_putprops','');

--
-- Table structure for table `mblms_config_log`
--

CREATE TABLE `mblms_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 `mblms_conflog_tim_ix` (`timemodified`),
  KEY `mblms_conflog_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=2046 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Changes done in server configuration through admin UI';

--
-- Dumping data for table `mblms_config_log`
--



--
-- Table structure for table `mblms_config_plugins`
--

CREATE TABLE `mblms_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 `mblms_confplug_plunam_uix` (`plugin`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2322 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Moodle modules and plugins configuration variables';

--
-- Dumping data for table `mblms_config_plugins`
--



--
-- Table structure for table `mblms_contentbank_content`
--

CREATE TABLE `mblms_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,
  `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 `mblms_contcont_nam_ix` (`name`),
  KEY `mblms_contcont_conconins_ix` (`contextid`,`contenttype`,`instanceid`),
  KEY `mblms_contcont_con_ix` (`contextid`),
  KEY `mblms_contcont_use_ix` (`usermodified`),
  KEY `mblms_contcont_use2_ix` (`usercreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table stores content data in the content bank.';

--
-- Dumping data for table `mblms_contentbank_content`
--


--
-- Table structure for table `mblms_context`
--

CREATE TABLE `mblms_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 `mblms_cont_conins_uix` (`contextlevel`,`instanceid`),
  KEY `mblms_cont_ins_ix` (`instanceid`),
  KEY `mblms_cont_pat_ix` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='one of these must be set';

--
-- Dumping data for table `mblms_context`
--

INSERT INTO `mblms_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/11',2,0),(12,80,7,'/1/12',2,0),(13,80,8,'/1/13',2,0),(14,80,9,'/1/14',2,0),(15,80,10,'/1/15',2,0),(16,80,11,'/1/5/16',3,0),(17,80,12,'/1/5/17',3,0),(18,80,13,'/1/5/18',3,0),(19,80,14,'/1/5/19',3,0),(20,80,15,'/1/5/20',3,0),(21,80,16,'/1/5/21',3,0),(22,80,17,'/1/5/22',3,0),(23,80,18,'/1/5/23',3,0),(24,80,19,'/1/5/24',3,0),(25,80,20,'/1/25',2,0),(26,80,21,'/1/26',2,0),(27,40,2,'/1/27',2,0),(28,40,3,'/1/28',2,0),(29,40,4,'/1/29',2,0),(30,50,2,'/1/28/30',3,0),(31,70,1,'/1/28/30/31',4,0),(32,70,2,'/1/2/32',3,0);

--
-- Table structure for table `mblms_context_temp`
--

CREATE TABLE `mblms_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 ROW_FORMAT=COMPRESSED COMMENT='Used by build_context_path() in upgrade and cron to keep con';

--
-- Dumping data for table `mblms_context_temp`
--


--
-- Table structure for table `mblms_course`
--

CREATE TABLE `mblms_course` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `category` bigint(10) NOT NULL DEFAULT 0,
  `sortorder` bigint(10) NOT NULL DEFAULT 0,
  `fullname` varchar(254) 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,
  PRIMARY KEY (`id`),
  KEY `mblms_cour_cat_ix` (`category`),
  KEY `mblms_cour_idn_ix` (`idnumber`),
  KEY `mblms_cour_sho_ix` (`shortname`),
  KEY `mblms_cour_sor_ix` (`sortorder`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Central course table';

--
-- Dumping data for table `mblms_course`
--

INSERT INTO `mblms_course` VALUES (1,0,1,'Mobisky Academy','mobicademy','','<p dir=\"ltr\" style=\"text-align: left;\">A leading ICT academy</p>',0,'site',1,3,0,0,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1616485854,1616489403,0,0,0,1616490247,NULL),(2,3,30001,'R programming','R','','<p dir=\"ltr\" style=\"text-align: left;\">Introduction to R</p>',1,'topics',1,5,1616533200,1648069200,0,0,0,0,0,1,1,NULL,0,0,0,'','','',1616489032,1616489190,0,1,0,1616490247,NULL);

--
-- Table structure for table `mblms_course_categories`
--

CREATE TABLE `mblms_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 `mblms_courcate_par_ix` (`parent`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Course categories';

--
-- Dumping data for table `mblms_course_categories`
--

INSERT INTO `mblms_course_categories` VALUES (2,'Programming','1','<p dir=\"ltr\" style=\"text-align: left;\">Programming Category</p>',1,0,20000,0,1,1,1616488952,1,'/2',NULL),(3,'Data Science','2','<p dir=\"ltr\" style=\"text-align: left;\">Data science courses</p>',1,0,30000,1,1,1,1616488969,1,'/3',NULL),(4,'Artificial Intelligence','3','<p dir=\"ltr\" style=\"text-align: left;\">AI category</p>',1,0,10000,0,1,1,1616488927,1,'/4',NULL);

--
-- Table structure for table `mblms_course_completion_aggr_methd`
--

CREATE TABLE `mblms_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 `mblms_courcompaggrmeth_cou_uix` (`course`,`criteriatype`),
  KEY `mblms_courcompaggrmeth_cou_ix` (`course`),
  KEY `mblms_courcompaggrmeth_cri_ix` (`criteriatype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Course completion aggregation methods for criteria';

--
-- Dumping data for table `mblms_course_completion_aggr_methd`
--


--
-- Table structure for table `mblms_course_completion_crit_compl`
--

CREATE TABLE `mblms_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 `mblms_courcompcritcomp_use_uix` (`userid`,`course`,`criteriaid`),
  KEY `mblms_courcompcritcomp_use_ix` (`userid`),
  KEY `mblms_courcompcritcomp_cou_ix` (`course`),
  KEY `mblms_courcompcritcomp_cri_ix` (`criteriaid`),
  KEY `mblms_courcompcritcomp_tim_ix` (`timecompleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Course completion user records';

--
-- Dumping data for table `mblms_course_completion_crit_compl`
--


--
-- Table structure for table `mblms_course_completion_criteria`
--

CREATE TABLE `mblms_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 `mblms_courcompcrit_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Course completion criteria';

--
-- Dumping data for table `mblms_course_completion_criteria`
--


--
-- Table structure for table `mblms_course_completion_defaults`
--

CREATE TABLE `mblms_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,
  `completionexpected` bigint(10) NOT NULL DEFAULT 0,
  `customrules` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_courcompdefa_coumod_uix` (`course`,`module`),
  KEY `mblms_courcompdefa_mod_ix` (`module`),
  KEY `mblms_courcompdefa_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Default settings for activities completion';

--
-- Dumping data for table `mblms_course_completion_defaults`
--


--
-- Table structure for table `mblms_course_completions`
--

CREATE TABLE `mblms_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 `mblms_courcomp_usecou_uix` (`userid`,`course`),
  KEY `mblms_courcomp_use_ix` (`userid`),
  KEY `mblms_courcomp_cou_ix` (`course`),
  KEY `mblms_courcomp_tim_ix` (`timecompleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Course completion records';

--
-- Dumping data for table `mblms_course_completions`
--


--
-- Table structure for table `mblms_course_format_options`
--

CREATE TABLE `mblms_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 `mblms_courformopti_coufors_uix` (`courseid`,`format`,`sectionid`,`name`),
  KEY `mblms_courformopti_cou_ix` (`courseid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores format-specific options for the course or course sect';

--
-- Dumping data for table `mblms_course_format_options`
--

INSERT INTO `mblms_course_format_options` VALUES (1,1,'site',0,'numsections','1'),(2,2,'topics',0,'hiddensections','0'),(3,2,'topics',0,'coursedisplay','0');

--
-- Table structure for table `mblms_course_modules`
--

CREATE TABLE `mblms_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,
  `showdescription` tinyint(1) NOT NULL DEFAULT 0,
  `availability` longtext DEFAULT NULL,
  `deletioninprogress` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_courmodu_vis_ix` (`visible`),
  KEY `mblms_courmodu_cou_ix` (`course`),
  KEY `mblms_courmodu_mod_ix` (`module`),
  KEY `mblms_courmodu_ins_ix` (`instance`),
  KEY `mblms_courmodu_idncou_ix` (`idnumber`,`course`),
  KEY `mblms_courmodu_gro_ix` (`groupingid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='course_modules table retrofitted from MySQL';

--
-- Dumping data for table `mblms_course_modules`
--

INSERT INTO `mblms_course_modules` VALUES (1,2,9,1,1,NULL,1616489033,0,0,1,1,1,0,0,0,NULL,0,0,0,NULL,0),(2,1,9,2,6,NULL,1616489338,0,0,1,1,1,0,0,0,NULL,0,0,0,NULL,0);

--
-- Table structure for table `mblms_course_modules_completion`
--

CREATE TABLE `mblms_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,
  `viewed` tinyint(1) DEFAULT NULL,
  `overrideby` bigint(10) DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_courmoducomp_usecou_uix` (`userid`,`coursemoduleid`),
  KEY `mblms_courmoducomp_cou_ix` (`coursemoduleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Stores the completion state (completed or not completed, etc';

--
-- Dumping data for table `mblms_course_modules_completion`
--


--
-- Table structure for table `mblms_course_published`
--

CREATE TABLE `mblms_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Information about how and when an local courses were publish';

--
-- Dumping data for table `mblms_course_published`
--


--
-- Table structure for table `mblms_course_request`
--

CREATE TABLE `mblms_course_request` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(254) NOT NULL DEFAULT '',
  `shortname` varchar(100) 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 `mblms_courrequ_sho_ix` (`shortname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='course requests';

--
-- Dumping data for table `mblms_course_request`
--


--
-- Table structure for table `mblms_course_sections`
--

CREATE TABLE `mblms_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,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_coursect_cousec_uix` (`course`,`section`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='to define the sections for each course';

--
-- Dumping data for table `mblms_course_sections`
--

INSERT INTO `mblms_course_sections` VALUES (1,2,0,NULL,'',1,'1',1,NULL,1616489033),(2,2,1,NULL,'',1,'',1,NULL,1616489033),(3,2,2,NULL,'',1,'',1,NULL,1616489033),(4,2,3,NULL,'',1,'',1,NULL,1616489033),(5,2,4,NULL,'',1,'',1,NULL,1616489033),(6,1,0,NULL,'',1,'2',1,NULL,1616489338);

--
-- Table structure for table `mblms_customfield_category`
--

CREATE TABLE `mblms_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 `mblms_custcate_comareitesor_ix` (`component`,`area`,`itemid`,`sortorder`),
  KEY `mblms_custcate_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='core_customfield category table';

--
-- Dumping data for table `mblms_customfield_category`
--


--
-- Table structure for table `mblms_customfield_data`
--

CREATE TABLE `mblms_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(10,5) DEFAULT NULL,
  `shortcharvalue` varchar(255) DEFAULT NULL,
  `charvalue` varchar(1333) DEFAULT NULL,
  `value` longtext NOT NULL,
  `valueformat` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_custdata_insfie_uix` (`instanceid`,`fieldid`),
  KEY `mblms_custdata_fieint_ix` (`fieldid`,`intvalue`),
  KEY `mblms_custdata_fiesho_ix` (`fieldid`,`shortcharvalue`),
  KEY `mblms_custdata_fiedec_ix` (`fieldid`,`decvalue`),
  KEY `mblms_custdata_fie_ix` (`fieldid`),
  KEY `mblms_custdata_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='core_customfield data table';

--
-- Dumping data for table `mblms_customfield_data`
--


--
-- Table structure for table `mblms_customfield_field`
--

CREATE TABLE `mblms_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 `mblms_custfiel_catsor_ix` (`categoryid`,`sortorder`),
  KEY `mblms_custfiel_cat_ix` (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='core_customfield field table';

--
-- Dumping data for table `mblms_customfield_field`
--


--
-- Table structure for table `mblms_data`
--

CREATE TABLE `mblms_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 `mblms_data_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='all database activities';

--
-- Dumping data for table `mblms_data`
--


--
-- Table structure for table `mblms_data_content`
--

CREATE TABLE `mblms_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 `mblms_datacont_rec_ix` (`recordid`),
  KEY `mblms_datacont_fie_ix` (`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='the content introduced in each record/fields';

--
-- Dumping data for table `mblms_data_content`
--


--
-- Table structure for table `mblms_data_fields`
--

CREATE TABLE `mblms_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 `mblms_datafiel_typdat_ix` (`type`,`dataid`),
  KEY `mblms_datafiel_dat_ix` (`dataid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='every field available';

--
-- Dumping data for table `mblms_data_fields`
--


--
-- Table structure for table `mblms_data_records`
--

CREATE TABLE `mblms_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 `mblms_datareco_dat_ix` (`dataid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='every record introduced';

--
-- Dumping data for table `mblms_data_records`
--


--
-- Table structure for table `mblms_editor_atto_autosave`
--

CREATE TABLE `mblms_editor_atto_autosave` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `elementid` varchar(255) NOT NULL DEFAULT '',
  `contextid` bigint(10) NOT NULL,
  `pagehash` varchar(64) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `drafttext` longtext NOT NULL,
  `draftid` bigint(10) DEFAULT NULL,
  `pageinstance` varchar(64) NOT NULL DEFAULT '',
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_editattoauto_eleconu_uix` (`elementid`,`contextid`,`userid`,`pagehash`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Draft text that is auto-saved every 5 seconds while an edito';

--
-- Dumping data for table `mblms_editor_atto_autosave`
--

INSERT INTO `mblms_editor_atto_autosave` VALUES (24,'id_s_theme_adaptable_alerttext1',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',280244947,'yui_3_17_2_1_1616487991672_56',1616487994),(25,'id_s_theme_adaptable_footnote',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',689274890,'yui_3_17_2_1_1616487991672_1581',1616487994),(26,'id_s_theme_adaptable_p1cap',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',522822784,'yui_3_17_2_1_1616487991672_2015',1616487994),(27,'id_s_theme_adaptable_p2cap',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',890984662,'yui_3_17_2_1_1616487991672_2397',1616487994),(28,'id_s_theme_adaptable_p3cap',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',727001623,'yui_3_17_2_1_1616487991672_2779',1616487994),(29,'id_s_theme_adaptable_tickertext1',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',78966849,'yui_3_17_2_1_1616487991672_3161',1616487994),(30,'id_s_theme_adaptable_sitetitletext',1,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',-1,'yui_3_17_2_1_1616487991672_3543',1616487995),(31,'id_s_theme_adaptable_logintextboxtop',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',485778303,'yui_3_17_2_1_1616487991672_3938',1616487995),(32,'id_s_theme_adaptable_logintextboxbottom',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',613103967,'yui_3_17_2_1_1616487991672_4320',1616487995),(33,'id_s_theme_adaptable_infobox',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',501680845,'yui_3_17_2_1_1616487991672_4702',1616487995),(34,'id_s_theme_adaptable_infobox2',5,'73bb7f715569d3e42a0aac07f4266cce9fb2c950',2,'',535570306,'yui_3_17_2_1_1616487991672_5084',1616487995),(45,'id_message',2,'8f5a73686185bc29522a036c5c20034fc39c6b48',2,'',972426356,'yui_3_17_2_1_1616489338569_46',1616489340),(46,'id_s__summary',1,'5995d18046e3affa759c9beec96280d2445df4b0',2,'',-1,'yui_3_17_2_1_1616489683097_45',1616489683);

--
-- Table structure for table `mblms_enrol_flatfile`
--

CREATE TABLE `mblms_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 `mblms_enroflat_cou_ix` (`courseid`),
  KEY `mblms_enroflat_use_ix` (`userid`),
  KEY `mblms_enroflat_rol_ix` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='enrol_flatfile table retrofitted from MySQL';

--
-- Dumping data for table `mblms_enrol_flatfile`
--


--
-- Table structure for table `mblms_enrol_lti_lti2_consumer`
--

CREATE TABLE `mblms_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 `mblms_enroltilti2cons_con_uix` (`consumerkey256`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='LTI consumers interacting with moodle';

--
-- Dumping data for table `mblms_enrol_lti_lti2_consumer`
--


--
-- Table structure for table `mblms_enrol_lti_lti2_context`
--

CREATE TABLE `mblms_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 `mblms_enroltilti2cont_con_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Information about a specific LTI contexts from the consumers';

--
-- Dumping data for table `mblms_enrol_lti_lti2_context`
--


--
-- Table structure for table `mblms_enrol_lti_lti2_nonce`
--

CREATE TABLE `mblms_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 `mblms_enroltilti2nonc_con_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Nonce used for authentication between moodle and a consumer';

--
-- Dumping data for table `mblms_enrol_lti_lti2_nonce`
--


--
-- Table structure for table `mblms_enrol_lti_lti2_resource_link`
--

CREATE TABLE `mblms_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 `mblms_enroltilti2resolink_c_ix` (`contextid`),
  KEY `mblms_enroltilti2resolink_p_ix` (`primaryresourcelinkid`),
  KEY `mblms_enroltilti2resolink_2_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Link from the consumer to the tool';

--
-- Dumping data for table `mblms_enrol_lti_lti2_resource_link`
--


--
-- Table structure for table `mblms_enrol_lti_lti2_share_key`
--

CREATE TABLE `mblms_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 `mblms_enroltilti2sharkey_s_uix` (`sharekey`),
  UNIQUE KEY `mblms_enroltilti2sharkey_r_uix` (`resourcelinkid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Resource link share key';

--
-- Dumping data for table `mblms_enrol_lti_lti2_share_key`
--


--
-- Table structure for table `mblms_enrol_lti_lti2_tool_proxy`
--

CREATE TABLE `mblms_enrol_lti_lti2_tool_proxy` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `toolproxykey` varchar(32) NOT NULL DEFAULT '',
  `consumerid` bigint(11) NOT NULL,
  `toolproxy` longtext NOT NULL,
  `created` bigint(10) NOT NULL,
  `updated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_enroltilti2toolprox__uix` (`toolproxykey`),
  KEY `mblms_enroltilti2toolprox_c_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='A tool proxy between moodle and a consumer';

--
-- Dumping data for table `mblms_enrol_lti_lti2_tool_proxy`
--


--
-- Table structure for table `mblms_enrol_lti_lti2_user_result`
--

CREATE TABLE `mblms_enrol_lti_lti2_user_result` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `resourcelinkid` bigint(11) NOT NULL,
  `ltiuserkey` varchar(255) NOT NULL DEFAULT '',
  `ltiresultsourcedid` varchar(1024) NOT NULL DEFAULT '',
  `created` bigint(10) NOT NULL,
  `updated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_enroltilti2userresu_r_ix` (`resourcelinkid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Results for each user for each resource link';

--
-- Dumping data for table `mblms_enrol_lti_lti2_user_result`
--


--
-- Table structure for table `mblms_enrol_lti_tool_consumer_map`
--

CREATE TABLE `mblms_enrol_lti_tool_consumer_map` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `toolid` bigint(11) NOT NULL,
  `consumerid` bigint(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_enroltitoolconsmap_to_ix` (`toolid`),
  KEY `mblms_enroltitoolconsmap_co_ix` (`consumerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Table that maps the published tool to tool consumers.';

--
-- Dumping data for table `mblms_enrol_lti_tool_consumer_map`
--


--
-- Table structure for table `mblms_enrol_lti_tools`
--

CREATE TABLE `mblms_enrol_lti_tools` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `enrolid` bigint(10) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `institution` varchar(40) NOT NULL DEFAULT '',
  `lang` varchar(30) NOT NULL DEFAULT 'en',
  `timezone` varchar(100) NOT NULL DEFAULT '99',
  `maxenrolled` bigint(10) NOT NULL DEFAULT 0,
  `maildisplay` tinyint(2) NOT NULL DEFAULT 2,
  `city` varchar(120) NOT NULL DEFAULT '',
  `country` varchar(2) NOT NULL DEFAULT '',
  `gradesync` tinyint(1) NOT NULL DEFAULT 0,
  `gradesynccompletion` tinyint(1) NOT NULL DEFAULT 0,
  `membersync` tinyint(1) NOT NULL DEFAULT 0,
  `membersyncmode` tinyint(1) NOT NULL DEFAULT 0,
  `roleinstructor` bigint(10) NOT NULL,
  `rolelearner` bigint(10) NOT NULL,
  `secret` longtext DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_enroltitool_enr_ix` (`enrolid`),
  KEY `mblms_enroltitool_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='List of tools provided to the remote system';

--
-- Dumping data for table `mblms_enrol_lti_tools`
--


--
-- Table structure for table `mblms_enrol_lti_users`
--

CREATE TABLE `mblms_enrol_lti_users` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `toolid` bigint(10) NOT NULL,
  `serviceurl` longtext DEFAULT NULL,
  `sourceid` longtext DEFAULT NULL,
  `consumerkey` longtext DEFAULT NULL,
  `consumersecret` longtext DEFAULT NULL,
  `membershipsurl` longtext DEFAULT NULL,
  `membershipsid` longtext DEFAULT NULL,
  `lastgrade` decimal(10,5) DEFAULT NULL,
  `lastaccess` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_enroltiuser_use_ix` (`userid`),
  KEY `mblms_enroltiuser_too_ix` (`toolid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='User access log and gradeback data';

--
-- Dumping data for table `mblms_enrol_lti_users`
--


--
-- Table structure for table `mblms_enrol_paypal`
--

CREATE TABLE `mblms_enrol_paypal` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `business` varchar(255) NOT NULL DEFAULT '',
  `receiver_email` varchar(255) NOT NULL DEFAULT '',
  `receiver_id` varchar(255) NOT NULL DEFAULT '',
  `item_name` varchar(255) NOT NULL DEFAULT '',
  `courseid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `instanceid` bigint(10) NOT NULL DEFAULT 0,
  `memo` varchar(255) NOT NULL DEFAULT '',
  `tax` varchar(255) NOT NULL DEFAULT '',
  `option_name1` varchar(255) NOT NULL DEFAULT '',
  `option_selection1_x` varchar(255) NOT NULL DEFAULT '',
  `option_name2` varchar(255) NOT NULL DEFAULT '',
  `option_selection2_x` varchar(255) NOT NULL DEFAULT '',
  `payment_status` varchar(255) NOT NULL DEFAULT '',
  `pending_reason` varchar(255) NOT NULL DEFAULT '',
  `reason_code` varchar(30) NOT NULL DEFAULT '',
  `txn_id` varchar(255) NOT NULL DEFAULT '',
  `parent_txn_id` varchar(255) NOT NULL DEFAULT '',
  `payment_type` varchar(30) NOT NULL DEFAULT '',
  `timeupdated` bigint(10) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `mblms_enropayp_bus_ix` (`business`),
  KEY `mblms_enropayp_rec_ix` (`receiver_email`),
  KEY `mblms_enropayp_cou_ix` (`courseid`),
  KEY `mblms_enropayp_use_ix` (`userid`),
  KEY `mblms_enropayp_ins_ix` (`instanceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Holds all known information about PayPal transactions';

--
-- Dumping data for table `mblms_enrol_paypal`
--


--
-- Table structure for table `mblms_event`
--

CREATE TABLE `mblms_event` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` longtext NOT NULL,
  `description` longtext NOT NULL,
  `format` smallint(4) NOT NULL DEFAULT 0,
  `categoryid` bigint(10) NOT NULL DEFAULT 0,
  `courseid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `repeatid` bigint(10) NOT NULL DEFAULT 0,
  `component` varchar(100) DEFAULT NULL,
  `modulename` varchar(20) NOT NULL DEFAULT '',
  `instance` bigint(10) NOT NULL DEFAULT 0,
  `type` smallint(4) NOT NULL DEFAULT 0,
  `eventtype` varchar(20) NOT NULL DEFAULT '',
  `timestart` bigint(10) NOT NULL DEFAULT 0,
  `timeduration` bigint(10) NOT NULL DEFAULT 0,
  `timesort` bigint(10) DEFAULT NULL,
  `visible` smallint(4) NOT NULL DEFAULT 1,
  `uuid` varchar(255) NOT NULL DEFAULT '',
  `sequence` bigint(10) NOT NULL DEFAULT 1,
  `timemodified` bigint(10) NOT NULL DEFAULT 0,
  `subscriptionid` bigint(10) DEFAULT NULL,
  `priority` bigint(10) DEFAULT NULL,
  `location` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_even_cou_ix` (`courseid`),
  KEY `mblms_even_use_ix` (`userid`),
  KEY `mblms_even_tim_ix` (`timestart`),
  KEY `mblms_even_tim2_ix` (`timeduration`),
  KEY `mblms_even_uui_ix` (`uuid`),
  KEY `mblms_even_typtim_ix` (`type`,`timesort`),
  KEY `mblms_even_grocoucatvisuse_ix` (`groupid`,`courseid`,`categoryid`,`visible`,`userid`),
  KEY `mblms_even_eve_ix` (`eventtype`),
  KEY `mblms_even_comeveins_ix` (`component`,`eventtype`,`instance`),
  KEY `mblms_even_modinseve_ix` (`modulename`,`instance`,`eventtype`),
  KEY `mblms_even_cat_ix` (`categoryid`),
  KEY `mblms_even_sub_ix` (`subscriptionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='For everything with a time associated to it';

--
-- Dumping data for table `mblms_event`
--


--
-- Table structure for table `mblms_event_subscriptions`
--

CREATE TABLE `mblms_event_subscriptions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL DEFAULT '',
  `categoryid` bigint(10) NOT NULL DEFAULT 0,
  `courseid` bigint(10) NOT NULL DEFAULT 0,
  `groupid` bigint(10) NOT NULL DEFAULT 0,
  `userid` bigint(10) NOT NULL DEFAULT 0,
  `eventtype` varchar(20) NOT NULL DEFAULT '',
  `pollinterval` bigint(10) NOT NULL DEFAULT 0,
  `lastupdated` bigint(10) DEFAULT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='Tracks subscriptions to remote calendars.';

--
-- Dumping data for table `mblms_event_subscriptions`
--


--
-- Table structure for table `mblms_events_handlers`
--

CREATE TABLE `mblms_events_handlers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `eventname` varchar(166) NOT NULL DEFAULT '',
  `component` varchar(166) NOT NULL DEFAULT '',
  `handlerfile` varchar(255) NOT NULL DEFAULT '',
  `handlerfunction` longtext DEFAULT NULL,
  `schedule` varchar(255) DEFAULT NULL,
  `status` bigint(10) NOT NULL DEFAULT 0,
  `internal` tinyint(2) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_evenhand_evecom_uix` (`eventname`,`component`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table is for storing which components requests what typ';

--
-- Dumping data for table `mblms_events_handlers`
--


--
-- Table structure for table `mblms_events_queue`
--

CREATE TABLE `mblms_events_queue` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `eventdata` longtext NOT NULL,
  `stackdump` longtext DEFAULT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_evenqueu_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This table is for storing queued events. It stores only one ';

--
-- Dumping data for table `mblms_events_queue`
--


--
-- Table structure for table `mblms_events_queue_handlers`
--

CREATE TABLE `mblms_events_queue_handlers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `queuedeventid` bigint(10) NOT NULL,
  `handlerid` bigint(10) NOT NULL,
  `status` bigint(10) DEFAULT NULL,
  `errormessage` longtext DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mblms_evenqueuhand_que_ix` (`queuedeventid`),
  KEY `mblms_evenqueuhand_han_ix` (`handlerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='This is the list of queued handlers for processing. The even';

--
-- Dumping data for table `mblms_events_queue_handlers`
--


--
-- Table structure for table `mblms_external_functions`
--

CREATE TABLE `mblms_external_functions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `classname` varchar(100) NOT NULL DEFAULT '',
  `methodname` varchar(100) NOT NULL DEFAULT '',
  `classpath` varchar(255) DEFAULT NULL,
  `component` varchar(100) NOT NULL DEFAULT '',
  `capabilities` varchar(255) DEFAULT NULL,
  `services` varchar(1333) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mblms_extefunc_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=608 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPRESSED COMMENT='list of all external functions';

--
-- Dumping data for table `mblms_external_functions`
--

INSERT INTO `mblms_external_functions` VALUES (1,'core_auth_confirm_user','core_auth_external','confirm_user',NULL,'moodle','',NULL),(2,'core_auth_request_password_reset','core_auth_external','request_password_reset',NULL,'moodle','',NULL),(3,'core_auth_is_minor','core_auth_external','is_minor',NULL,'moodle','',NULL),(4,'core_auth_is_age_digital_consent_verification_enabled','core_auth_external','is_age_digital_consent_verification_enabled',NULL,'moodle','',NULL),(5,'core_auth_resend_confirmation_email','core_auth_external','resend_confirmation_email',NULL,'moodle','',NULL),(6,'core_backup_get_async_backup_progress','core_backup_external','get_async_backup_progress','backup/externallib.php','moodle','',NULL),(7,'core_backup_get_async_backup_links_backup','core_backup_external','get_async_backup_links_backup','backup/externallib.php','moodle','',NULL),(8,'core_backup_get_async_backup_links_restore','core_backup_external','get_async_backup_links_restore','backup/externallib.php','moodle','',NULL),(9,'core_backup_get_copy_progress','core_backup_external','get_copy_progress','backup/externallib.php','moodle','',NULL),(10,'core_backup_submit_copy_form','core_backup_external','submit_copy_form','backup/externallib.php','moodle','',NULL),(11,'core_badges_get_user_badges','core_badges_external','get_user_badges',NULL,'moodle','moodle/badges:viewotherbadges','moodle_mobile_app'),(12,'core_blog_get_entries','core_blog\\external','get_entries',NULL,'moodle','','moodle_mobile_app'),(13,'core_blog_view_entries','core_blog\\external','view_entries',NULL,'moodle','','moodle_mobile_app'),(14,'core_calendar_get_calendar_monthly_view','core_calendar_external','get_calendar_monthly_view','calendar/externallib.php','moodle','','moodle_mobile_app'),(15,'core_calendar_get_calendar_day_view','core_calendar_external','get_calendar_day_view','calendar/externallib.php','moodle','','moodle_mobile_app'),(16,'core_calendar_get_calendar_upcoming_view','core_calendar_external','get_calendar_upcoming_view','calendar/externallib.php','moodle','','moodle_mobile_app'),(17,'core_calendar_update_event_start_day','core_calendar_external','update_event_start_day','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(18,'core_calendar_create_calendar_events','core_calendar_external','create_calendar_events','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(19,'core_calendar_delete_calendar_events','core_calendar_external','delete_calendar_events','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(20,'core_calendar_get_calendar_events','core_calendar_external','get_calendar_events','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(21,'core_calendar_get_action_events_by_timesort','core_calendar_external','get_calendar_action_events_by_timesort','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(22,'core_calendar_get_action_events_by_course','core_calendar_external','get_calendar_action_events_by_course','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(23,'core_calendar_get_action_events_by_courses','core_calendar_external','get_calendar_action_events_by_courses','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(24,'core_calendar_get_calendar_event_by_id','core_calendar_external','get_calendar_event_by_id','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(25,'core_calendar_submit_create_update_form','core_calendar_external','submit_create_update_form','calendar/externallib.php','moodle','moodle/calendar:manageentries, moodle/calendar:manageownentries, moodle/calendar:managegroupentries','moodle_mobile_app'),(26,'core_calendar_get_calendar_access_information','core_calendar_external','get_calendar_access_information','calendar/externallib.php','moodle','','moodle_mobile_app'),(27,'core_calendar_get_allowed_event_types','core_calendar_external','get_allowed_event_types','calendar/externallib.php','moodle','','moodle_mobile_app'),(28,'core_calendar_get_timestamps','core_calendar_external','get_timestamps','calendar/externallib.php','moodle','',NULL),(29,'core_calendar_get_calendar_export_token','core_calendar\\external\\export\\token','execute',NULL,'moodle','','moodle_mobile_app'),(30,'core_cohort_add_cohort_members','core_cohort_external','add_cohort_members','cohort/externallib.php','moodle','moodle/cohort:assign',NULL),(31,'core_cohort_create_cohorts','core_cohort_external','create_cohorts','cohort/externallib.php','moodle','moodle/cohort:manage',NULL),(32,'core_cohort_delete_cohort_members','core_cohort_external','delete_cohort_members','cohort/externallib.php','moodle','moodle/cohort:assign',NULL),(33,'core_cohort_delete_cohorts','core_cohort_external','delete_cohorts','cohort/externallib.php','moodle','moodle/cohort:manage',NULL),(34,'core_cohort_get_cohort_members','core_cohort_external','get_cohort_members','cohort/externallib.php','moodle','moodle/cohort:view',NULL),(35,'core_cohort_search_cohorts','core_cohort_external','search_cohorts','cohort/externallib.php','moodle','moodle/cohort:view',NULL),(36,'core_cohort_get_cohorts','core_cohort_external','get_cohorts','cohort/externallib.php','moodle','moodle/cohort:view',NULL),(37,'core_cohort_update_cohorts','core_cohort_external','update_cohorts','cohort/externallib.php','moodle','moodle/cohort:manage',NULL),(38,'core_comment_get_comments','core_comment_external','get_comments',NULL,'moodle','moodle/comment:view','moodle_mobile_app'),(39,'core_comment_add_comments','core_comment_external','add_comments',NULL,'moodle','','moodle_mobile_app'),(40,'core_comment_delete_comments','core_comment_external','delete_comments',NULL,'moodle','','moodle_mobile_app'),(41,'core_completion_get_activities_completion_status','core_completion_external','get_activities_completion_status',NULL,'moodle','','moodle_mobile_app'),(42,'core_completion_get_course_completion_status','core_completion_external','get_course_completion_status',NULL,'moodle','report/completion:view','moodle_mobile_app'),(43,'core_completion_mark_course_self_completed','core_completion_external','mark_course_self_completed',NULL,'moodle','','moodle_mobile_app'),(44,'core_completion_update_activity_completion_status_manually','core_completion_external','update_activity_completion_status_manually',NULL,'moodle','','moodle_mobile_app'),(45,'core_completion_override_activity_completion_status','core_completion_external','override_activity_completion_status',NULL,'moodle','moodle/course:overridecompletion',NULL),(46,'core_course_create_categories','core_course_external','create_categories','course/externallib.php','moodle','moodle/category:manage',NULL),(47,'core_course_create_courses','core_course_external','create_courses','course/externallib.php','moodle','moodle/course:create, moodle/course:visibility',NULL),(48,'core_course_delete_categories','core_course_external','delete_categories','course/externallib.php','moodle','moodle/category:manage',NULL),(49,'core_course_delete_courses','core_course_external','delete_courses','course/externallib.php','moodle','moodle/course:delete',NULL),(50,'core_course_delete_modules','core_course_external','delete_modules','course/externallib.php','moodle','moodle/course:manageactivities',NULL),(51,'core_course_duplicate_course','core_course_external','duplicate_course','course/externallib.php','moodle','moodle/backup:backupcourse, moodle/restore:restorecourse, moodle/course:create',NULL),(52,'core_course_get_categories','core_course_external','get_categories','course/externallib.php','moodle','moodle/category:viewhiddencategories','moodle_mobile_app'),(53,'core_course_get_contents','core_course_external','get_course_contents','course/externallib.php','moodle','moodle/course:update, moodle/course:viewhiddencourses','moodle_mobile_app'),(54,'core_course_get_course_module','core_course_external','get_course_module','course/externallib.php','moodle','','moodle_mobile_app'),(55,'core_course_get_course_module_by_instance','core_course_external','get_course_module_by_instance','course/externallib.php','moodle','','moodle_mobile_app'),(56,'core_course_get_module','core_course_external','get_module','course/externallib.php','moodle','',NULL),(57,'core_course_edit_module','core_course_external','edit_module','course/externallib.php','moodle','',NULL),(58,'core_course_edit_section','core_course_external','edit_section','course/externallib.php','moodle','',NULL),(59,'core_course_get_courses','core_course_external','get_courses','course/externallib.php','moodle','moodle/course:view, moodle/course:update, moodle/course:viewhiddencourses','moodle_mobile_app'),(60,'core_course_import_course','core_course_external','import_course','course/externallib.php','moodle','moodle/backup:backuptargetimport, moodle/restore:restoretargetimport',NULL),(61,'core_course_search_courses','core_course_external','search_courses','course/externallib.php','moodle','','moodle_mobile_app'),(62,'core_course_update_categories','core_course_external','update_categories','course/externallib.php','moodle','moodle/category:manage',NULL),(63,'core_course_update_courses','core_course_external','update_courses','course/externallib.php','moodle','moodle/course:update, moodle/course:changecategory, moodle/course:changefullname, moodle/course:changeshortname, moodle/course:changeidnumber, moodle/course:changesummary, moodle/course:visibility',NULL),(64,'core_course_view_course','core_course_external','view_course','course/externallib.php','moodle','','moodle_mobile_app'),(65,'core_course_get_user_navigation_options','core_course_external','get_user_navigation_options','course/externallib.php','moodle','','moodle_mobile_app'),(66,'core_course_get_user_administration_options','core_course_external','get_user_administration_options','course/externallib.php','moodle','','moodle_mobile_app'),(67,'core_course_get_courses_by_field','core_course_external','get_courses_by_field','course/externallib.php','moodle','','moodle_mobile_app'),(68,'core_course_check_updates','core_course_external','check_updates','course/externallib.php','moodle','','moodle_mobile_app'),(69,'core_course_get_updates_since','core_course_external','get_updates_since','course/externallib.php','moodle','','moodle_mobile_app'),(70,'core_course_get_enrolled_courses_by_timeline_classification','core_course_external','get_enrolled_courses_by_timeline_classification','course/externallib.php','moodle','','moodle_mobile_app'),(71,'core_course_get_recent_courses','core_course_external','get_recent_courses','course/externallib.php','moodle','','moodle_mobile_app'),(72,'core_course_set_favourite_courses','core_course_external','set_favourite_courses','course/externallib.php','moodle','','moodle_mobile_app'),(73,'core_course_get_enrolled_users_by_cmid','core_course_external','get_enrolled_users_by_cmid','course/externallib.php','moodle','',NULL),(74,'core_course_add_content_item_to_user_favourites','core_course_external','add_content_item_to_user_favourites','course/externallib.php','moodle','',NULL),(75,'core_course_remove_content_item_from_user_favourites','core_course_external','remove_content_item_from_user_favourites','course/externallib.php','moodle','',NULL),(76,'core_course_get_course_content_items','core_course_external','get_course_content_items','course/externallib.php','moodle','',NULL),(77,'core_course_get_activity_chooser_footer','core_course_external','get_activity_chooser_footer','course/externallib.php','moodle','',NULL),(78,'core_course_toggle_activity_recommendation','core_course_external','toggle_activity_recommendation','course/externallib.php','moodle','',NULL),(79,'core_enrol_get_course_enrolment_methods','core_enrol_external','get_course_enrolment_methods','enrol/externallib.php','moodle','','moodle_mobile_app'),(80,'core_enrol_get_enrolled_users','core_enrol_external','get_enrolled_users','enrol/externallib.php','moodle','moodle/user:viewdetails, moodle/user:viewhiddendetails, moodle/course:useremail, moodle/user:update, moodle/site:accessallgroups','moodle_mobile_app'),(81,'core_enrol_get_enrolled_users_with_capability','core_enrol_external','get_enrolled_users_with_capability','enrol/externallib.php','moodle','',NULL),(82,'core_enrol_get_potential_users','core_enrol_external','get_potential_users','enrol/externallib.php','moodle','moodle/course:enrolreview',NULL),(83,'core_enrol_search_users','core_enrol_external','search_users','enrol/externallib.php','moodle','moodle/course:viewparticipants','moodle_mobile_app'),(84,'core_enrol_get_users_courses','core_enrol_external','get_users_courses','enrol/externallib.php','moodle','moodle/course:viewparticipants','moodle_mobile_app'),(85,'core_enrol_edit_user_enrolment','core_enrol_external','edit_user_enrolment','enrol/externallib.php','moodle','',NULL),(86,'core_enrol_submit_user_enrolment_form','core_enrol_external','submit_user_enrolment_form','enrol/externallib.php','moodle','',NULL),(87,'core_enrol_unenrol_user_enrolment','core_enrol_external','unenrol_user_enrolment','enrol/externallib.php','moodle','',NULL),(88,'core_fetch_notifications','core_external','fetch_notifications','lib/external/externallib.php','moodle','',NULL),(89,'core_session_touch','core\\session\\external','touch_session',NULL,'moodle','',NULL),(90,'core_session_time_remaining','core\\session\\external','time_remaining',NULL,'moodle','',NULL),(91,'core_files_get_files','core_files_external','get_files','files/externallib.php','moodle','','moodle_mobile_app'),(92,'core_files_upload','core_files_external','upload','files/externallib.php','moodle','',NULL),(93,'core_files_delete_draft_files','core_files\\external\\delete\\draft','execute',NULL,'moodle','','moodle_mobile_app'),(94,'core_form_get_filetypes_browser_data','core_form\\external','get_filetypes_browser_data',NULL,'moodle','',NULL),(95,'core_get_component_strings','core_external','get_component_strings','lib/external/externallib.php','moodle','','moodle_mobile_app'),(96,'core_get_fragment','core_external','get_fragment','lib/external/externallib.php','moodle','',NULL),(97,'core_get_string','core_external','get_string','lib/external/externallib.php','moodle','',NULL),(98,'core_get_strings','core_external','get_strings','lib/external/externallib.php','moodle','',NULL),(99,'core_get_user_dates','core_external','get_user_dates','lib/external/externallib.php','moodle','',NULL),(100,'core_grades_get_grades','core_grades_external','get_grades',NULL,'moodle','moodle/grade:view, moodle/grade:viewall, moodle/grade:viewhidden',NULL),(101,'core_grades_update_grades','core_grades_external','update_grades',NULL,'moodle','',NULL),(102,'core_grades_grader_gradingpanel_point_fetch','core_grades\\grades\\grader\\gradingpanel\\point\\external\\fetch','execute',NULL,'moodle','','moodle_mobile_app'),(103,'core_grades_grader_gradingpanel_point_store','core_grades\\grades\\grader\\gradingpanel\\point\\external\\store','execute',NULL,'moodle','','moodle_mobile_app'),(104,'core_grades_grader_gradingpanel_scale_fetch','core_grades\\grades\\grader\\gradingpanel\\scale\\external\\fetch','execute',NULL,'moodle','','moodle_mobile_app'),(105,'core_grades_grader_gradingpanel_scale_store','core_grades\\grades\\grader\\gradingpanel\\scale\\external\\store','execute',NULL,'moodle','','moodle_mobile_app'),(106,'core_grades_create_gradecategory','core_grades_external','create_gradecategory',NULL,'moodle','moodle/grade:manage',NULL),(107,'core_grading_get_definitions','core_grading_external','get_definitions',NULL,'moodle','',NULL),(108,'core_grading_get_gradingform_instances','core_grading_external','get_gradingform_instances',NULL,'moodle','',NULL),(109,'core_grading_save_definitions','core_grading_external','save_definitions',NULL,'moodle','',NULL),(110,'core_group_add_group_members','core_group_external','add_group_members','group/externallib.php','moodle','moodle/course:managegroups',NULL),(111,'core_group_assign_grouping','core_group_external','assign_grouping','group/externallib.php','moodle','',NULL),(112,'core_group_create_groupings','core_group_external','create_groupings','group/externallib.php','moodle','',NULL),(113,'core_group_create_groups','core_group_external','create_groups','group/externallib.php','moodle','moodle/course:managegroups',NULL),(114,'core_group_delete_group_members','core_group_external','delete_group_members','group/externallib.php','moodle','moodle/course:managegroups',NULL),(115,'core_group_delete_groupings','core_group_external','delete_groupings','group/externallib.php','moodle','',NULL),(116,'core_group_delete_groups','core_group_external','delete_groups','group/externallib.php','moodle','moodle/course:managegroups',NULL),(117,'core_group_get_activity_allowed_groups','core_group_external','get_activity_allowed_groups','group/externallib.php','moodle','','moodle_mobile_app'),(118,'core_group_get_activity_groupmode','core_group_external','get_activity_groupmode','group/externallib.php','moodle','','moodle_mobile_app'),(119,'core_group_get_course_groupings','core_group_external','get_course_groupings','group/externallib.php','moodle','','moodle_mobile_app'),(120,'core_group_get_course_groups','core_group_external','get_course_groups','group/externallib.php','moodle','moodle/course:managegroups','moodle_mobile_app'),(121,'core_group_get_course_user_groups','core_group_external','get_course_user_groups','group/externallib.php','moodle','moodle/course:managegroups','moodle_mobile_app'),(122,'core_group_get_group_members','core_group_external','get_group_members','group/externallib.php','moodle','moodle/course:managegroups',NULL),(123,'core_group_get_groupings','core_group_external','get_groupings','group/externallib.php','moodle','',NULL),(124,'core_group_get_groups','core_group_external','get_groups','group/externallib.php','moodle','moodle/course:managegroups',NULL),(125,'core_group_unassign_grouping','core_group_external','unassign_grouping','group/externallib.php','moodle','',NULL),(126,'core_group_update_groupings','core_group_external','update_groupings','group/externallib.php','moodle','',NULL),(127,'core_group_update_groups','core_group_external','update_groups','group/externallib.php','moodle','moodle/course:managegroups',NULL),(128,'core_message_mute_conversations','core_message_external','mute_conversations','message/externallib.php','moodle','','moodle_mobile_app'),(129,'core_message_unmute_conversations','core_message_external','unmute_conversations','message/externallib.php','moodle','','moodle_mobile_app'),(130,'core_message_block_user','core_message_external','block_user','message/externallib.php','moodle','','moodle_mobile_app'),(131,'core_message_get_contact_requests','core_message_external','get_contact_requests','message/externallib.php','moodle','','moodle_mobile_app'),(132,'core_message_create_contact_request','core_message_external','create_contact_request','message/externallib.php','moodle','','moodle_mobile_app'),(133,'core_message_confirm_contact_request','core_message_external','confirm_contact_request','message/externallib.php','moodle','','moodle_mobile_app'),(134,'core_message_decline_contact_request','core_message_external','decline_contact_request','message/externallib.php','moodle','','moodle_mobile_app'),(135,'core_message_get_received_contact_requests_count','core_message_external','get_received_contact_requests_count','message/externallib.php','moodle','','moodle_mobile_app'),(136,'core_message_delete_contacts','core_message_external','delete_contacts','message/externallib.php','moodle','','moodle_mobile_app'),(137,'core_message_delete_conversations_by_id','core_message_external','delete_conversations_by_id','message/externallib.php','moodle','moodle/site:deleteownmessage','moodle_mobile_app'),(138,'core_message_delete_message','core_message_external','delete_message','message/externallib.php','moodle','moodle/site:deleteownmessage','moodle_mobile_app'),(139,'core_message_get_blocked_users','core_message_external','get_blocked_users','message/externallib.php','moodle','','moodle_mobile_app'),(140,'core_message_data_for_messagearea_search_messages','core_message_external','data_for_messagearea_search_messages','message/externallib.php','moodle','','moodle_mobile_app'),(141,'core_message_message_search_users','core_message_external','message_search_users','message/externallib.php','moodle','','moodle_mobile_app'),(142,'core_message_get_user_contacts','core_message_external','get_user_contacts','message/externallib.php','moodle','','moodle_mobile_app'),(143,'core_message_get_conversations','core_message_external','get_conversations','message/externallib.php','moodle','','moodle_mobile_app'),(144,'core_message_get_conversation','core_message_external','get_conversation','message/externallib.php','moodle','','moodle_mobile_app'),(145,'core_message_get_conversation_between_users','core_message_external','get_conversation_between_users','message/externallib.php','moodle','','moodle_mobile_app'),(146,'core_message_get_self_conversation','core_message_external','get_self_conversation','message/externallib.php','moodle','','moodle_mobile_app'),(147,'core_message_get_messages','core_message_external','get_messages','message/externallib.php','moodle','','moodle_mobile_app'),(148,'core_message_get_conversation_counts','core_message_external','get_conversation_counts','message/externallib.php','moodle','','moodle_mobile_app'),(149,'core_message_get_unread_conversation_counts','core_message_external','get_unread_conversation_counts','message/externallib.php','moodle','','moodle_mobile_app'),(150,'core_message_get_conversation_members','core_message_external','get_conversation_members','message/externallib.php','moodle','','moodle_mobile_app'),(151,'core_message_get_member_info','core_message_external','get_member_info','message/externallib.php','moodle','','moodle_mobile_app'),(152,'core_message_get_unread_conversations_count','core_message_external','get_unread_conversations_count','message/externallib.php','moodle','','moodle_mobile_app'),(153,'core_message_mark_all_notifications_as_read','core_message_external','mark_all_notifications_as_read','message/externallib.php','moodle','','moodle_mobile_app'),(154,'core_message_mark_all_conversation_messages_as_read','core_message_external','mark_all_conversation_messages_as_read','message/externallib.php','moodle','','moodle_mobile_app'),(155,'core_message_mark_message_read','core_message_external','mark_message_read','message/externallib.php','moodle','','moodle_mobile_app'),(156,'core_message_mark_notification_read','core_message_external','mark_notification_read','message/externallib.php','moodle','','moodle_mobile_app'),(157,'core_message_message_processor_config_form','core_message_external','message_processor_config_form','message/externallib.php','moodle','','moodle_mobile_app'),(158,'core_message_get_message_processor','core_message_external','get_message_processor','message/externallib.php','moodle','',NULL),(159,'core_message_search_contacts','core_message_external','search_contacts','message/externallib.php','moodle','','moodle_mobile_app'),(160,'core_message_send_instant_messages','core_message_external','send_instant_messages','message/externallib.php','moodle','moodle/site:sendmessage','moodle_mobile_app'),(161,'core_message_send_messages_to_conversation','core_message_external','send_messages_to_conversation','message/externallib.php','moodle','moodle/site:sendmessage','moodle_mobile_app'),(162,'core_message_get_conversation_messages','core_message_external','get_conversation_messages','message/externallib.php','moodle','','moodle_mobile_app'),(163,'core_message_unblock_user','core_message_external','unblock_user','message/externallib.php','moodle','','moodle_mobile_app'),(164,'core_message_get_user_notification_preferences','core_message_external','get_user_notification_preferences','message/externallib.php','moodle','moodle/user:editownmessageprofile','moodle_mobile_app'),(165,'core_message_get_user_message_preferences','core_message_external','get_user_message_preferences','message/externallib.php','moodle','moodle/user:editownmessageprofile','moodle_mobile_app'),(166,'core_message_set_favourite_conversations','core_message_external','set_favourite_conversations','message/externallib.php','moodle','','moodle_mobile_app'),(167,'core_message_unset_favourite_conversations','core_message_external','unset_favourite_conversations','message/externallib.php','moodle','','moodle_mobile_app'),(168,'core_message_delete_message_for_all_users','core_message_external','delete_message_for_all_users','message/externallib.php','moodle','moodle/site:deleteanymessage','moodle_mobile_app'),(169,'core_notes_create_notes','core_notes_external','create_notes','notes/externallib.php','moodle','moodle/notes:manage','moodle_mobile_app'),(170,'core_notes_delete_notes','core_notes_external','delete_notes','notes/externallib.php','moodle','moodle/notes:manage','moodle_mobile_app'),(171,'core_notes_get_course_notes','core_notes_external','get_course_notes','notes/externallib.php','moodle','moodle/notes:view','moodle_mobile_app'),(172,'core_notes_get_notes','core_notes_external','get_notes','notes/externallib.php','moodle','moodle/notes:view',NULL),(173,'core_notes_update_notes','core_notes_external','update_notes','notes/externallib.php','moodle','moodle/notes:manage',NULL),(174,'core_notes_view_notes','core_notes_external','view_notes','notes/externallib.php','moodle','moodle/notes:view','moodle_mobile_app'),(175,'core_output_load_template','core\\output\\external','load_template',NULL,'moodle','',NULL),(176,'core_output_load_template_with_dependencies','core\\output\\external','load_template_with_dependencies',NULL,'moodle','',NULL),(177,'core_output_load_fontawesome_icon_map','core\\output\\external','load_fontawesome_icon_map',NULL,'moodle','',NULL),(178,'core_output_load_fontawesome_icon_system_map','core\\external\\output\\icon_system\\load_fontawesome_map','execute',NULL,'moodle','',NULL),(179,'core_question_update_flag','core_question_external','update_flag',NULL,'moodle','moodle/question:flag','moodle_mobile_app'),(180,'core_question_submit_tags_form','core_question_external','submit_tags_form',NULL,'moodle','',NULL),(181,'core_question_get_random_question_summaries','core_question_external','get_random_question_summaries',NULL,'moodle','',NULL),(182,'core_rating_get_item_ratings','core_rating_external','get_item_ratings',NULL,'moodle','moodle/rating:view','moodle_mobile_app'),(183,'core_rating_add_rating','core_rating_external','add_rating',NULL,'moodle','moodle/rating:rate','moodle_mobile_app'),(184,'core_role_assign_roles','core_role_external','assign_roles','enrol/externallib.php','moodle','moodle/role:assign',NULL),(185,'core_role_unassign_roles','core_role_external','unassign_roles','enrol/externallib.php','moodle','moodle/role:assign',NULL),(186,'core_search_get_relevant_users','\\core_search\\external','get_relevant_users',NULL,'moodle','',NULL),(187,'core_tag_get_tagindex','core_tag_external','get_tagindex',NULL,'moodle','','moodle_mobile_app'),(188,'core_tag_get_tags','core_tag_external','get_tags',NULL,'moodle','',NULL),(189,'core_tag_update_tags','core_tag_external','update_tags',NULL,'moodle','',NULL),(190,'core_tag_get_tagindex_per_area','core_tag_external','get_tagindex_per_area',NULL,'moodle','','moodle_mobile_app'),(191,'core_tag_get_tag_areas','core_tag_external','get_tag_areas',NULL,'moodle','','moodle_mobile_app'),(192,'core_tag_get_tag_collections','core_tag_external','get_tag_collections',NULL,'moodle','','moodle_mobile_app'),(193,'core_tag_get_tag_cloud','core_tag_external','get_tag_cloud',NULL,'moodle','','moodle_mobile_app'),(194,'core_update_inplace_editable','core_external','update_inplace_editable','lib/external/externallib.php','moodle','',NULL),(195,'core_user_add_user_device','core_user_external','add_user_device','user/externallib.php','moodle','','moodle_mobile_app'),(196,'core_user_add_user_private_files','core_user_external','add_user_private_files','user/externallib.php','moodle','moodle/user:manageownfiles','moodle_mobile_app'),(197,'core_user_create_users','core_user_external','create_users','user/externallib.php','moodle','moodle/user:create',NULL),(198,'core_user_delete_users','core_user_external','delete_users','user/externallib.php','moodle','moodle/user:delete',NULL),(199,'core_user_get_course_user_profiles','core_user_external','get_course_user_profiles','user/externallib.php','moodle','moodle/user:viewdetails, moodle/user:viewhiddendetails, moodle/course:useremail, moodle/user:update, moodle/site:accessallgroups','moodle_mobile_app'),(200,'core_user_get_users','core_user_external','get_users','user/externallib.php','moodle','moodle/user:viewdetails, moodle/user:viewhiddendetails, moodle/course:useremail, moodle/user:update',NULL),(201,'core_user_get_users_by_field','core_user_external','get_users_by_field','user/externallib.php','moodle','moodle/user:viewdetails, moodle/user:viewhiddendetails, moodle/course:useremail, moodle/user:update','moodle_mobile_app'),(202,'core_user_remove_user_device','core_user_external','remove_user_device','user/externallib.php','moodle','','moodle_mobile_app'),(203,'core_user_update_users','core_user_external','update_users','user/externallib.php','moodle','moodle/user:update',NULL),(204,'core_user_update_user_preferences','core_user_external','update_user_preferences','user/externallib.php','moodle','moodle/user:editownmessageprofile, moodle/user:editmessageprofile','moodle_mobile_app'),(205,'core_user_view_user_list','core_user_external','view_user_list','user/externallib.php','moodle','moodle/course:viewparticipants','moodle_mobile_app'),(206,'core_user_view_user_profile','core_user_external','view_user_profile','user/externallib.php','moodle','moodle/user:viewdetails','moodle_mobile_app'),(207,'core_user_get_user_preferences','core_user_external','get_user_preferences','user/externallib.php','moodle','','moodle_mobile_app'),(208,'core_user_update_picture','core_user_external','update_picture','user/externallib.php','moodle','moodle/user:editownprofile, moodle/user:editprofile','moodle_mobile_app'),(209,'core_user_set_user_preferences','core_user_external','set_user_preferences','user/externallib.php','moodle','moodle/site:config','moodle_mobile_app'),(210,'core_user_agree_site_policy','core_user_external','agree_site_policy','user/externallib.php','moodle','','moodle_mobile_app'),(211,'core_user_get_private_files_info','core_user_external','get_private_files_info','user/externallib.php','moodle','moodle/user:manageownfiles','moodle_mobile_app'),(212,'core_competency_create_competency_framework','core_competency\\external','create_competency_framework',NULL,'moodle','moodle/competency:competencymanage',NULL),(213,'core_competency_read_competency_framework','core_competency\\external','read_competency_framework',NULL,'moodle','moodle/competency:competencyview',NULL),(214,'core_competency_duplicate_competency_framework','core_competency\\external','duplicate_competency_framework',NULL,'moodle','moodle/competency:competencymanage',NULL),(215,'core_competency_delete_competency_framework','core_competency\\external','delete_competency_framework',NULL,'moodle','moodle/competency:competencymanage',NULL),(216,'core_competency_update_competency_framework','core_competency\\external','update_competency_framework',NULL,'moodle','moodle/competency:competencymanage',NULL),(217,'core_competency_list_competency_frameworks','core_competency\\external','list_competency_frameworks',NULL,'moodle','moodle/competency:competencyview',NULL),(218,'core_competency_count_competency_frameworks','core_competency\\external','count_competency_frameworks',NULL,'moodle','moodle/competency:competencyview',NULL),(219,'core_competency_competency_framework_viewed','core_competency\\external','competency_framework_viewed',NULL,'moodle','moodle/competency:competencyview',NULL),(220,'core_competency_create_competency','core_competency\\external','create_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(221,'core_competency_read_competency','core_competency\\external','read_competency',NULL,'moodle','moodle/competency:competencyview',NULL),(222,'core_competency_competency_viewed','core_competency\\external','competency_viewed',NULL,'moodle','moodle/competency:competencyview','moodle_mobile_app'),(223,'core_competency_delete_competency','core_competency\\external','delete_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(224,'core_competency_update_competency','core_competency\\external','update_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(225,'core_competency_list_competencies','core_competency\\external','list_competencies',NULL,'moodle','moodle/competency:competencyview',NULL),(226,'core_competency_list_competencies_in_template','core_competency\\external','list_competencies_in_template',NULL,'moodle','moodle/competency:competencyview',NULL),(227,'core_competency_count_competencies','core_competency\\external','count_competencies',NULL,'moodle','moodle/competency:competencyview',NULL),(228,'core_competency_count_competencies_in_template','core_competency\\external','count_competencies_in_template',NULL,'moodle','moodle/competency:competencyview',NULL),(229,'core_competency_search_competencies','core_competency\\external','search_competencies',NULL,'moodle','moodle/competency:competencyview',NULL),(230,'core_competency_set_parent_competency','core_competency\\external','set_parent_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(231,'core_competency_move_up_competency','core_competency\\external','move_up_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(232,'core_competency_move_down_competency','core_competency\\external','move_down_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(233,'core_competency_list_course_module_competencies','core_competency\\external','list_course_module_competencies',NULL,'moodle','moodle/competency:coursecompetencyview',NULL),(234,'core_competency_count_course_module_competencies','core_competency\\external','count_course_module_competencies',NULL,'moodle','moodle/competency:coursecompetencyview',NULL),(235,'core_competency_list_course_competencies','core_competency\\external','list_course_competencies',NULL,'moodle','moodle/competency:coursecompetencyview','moodle_mobile_app'),(236,'core_competency_count_competencies_in_course','core_competency\\external','count_competencies_in_course',NULL,'moodle','moodle/competency:coursecompetencyview',NULL),(237,'core_competency_count_courses_using_competency','core_competency\\external','count_courses_using_competency',NULL,'moodle','moodle/competency:coursecompetencyview',NULL),(238,'core_competency_add_competency_to_course','core_competency\\external','add_competency_to_course',NULL,'moodle','moodle/competency:coursecompetencymanage',NULL),(239,'core_competency_add_competency_to_template','core_competency\\external','add_competency_to_template',NULL,'moodle','moodle/competency:templatemanage',NULL),(240,'core_competency_remove_competency_from_course','core_competency\\external','remove_competency_from_course',NULL,'moodle','moodle/competency:coursecompetencymanage',NULL),(241,'core_competency_set_course_competency_ruleoutcome','core_competency\\external','set_course_competency_ruleoutcome',NULL,'moodle','moodle/competency:coursecompetencymanage',NULL),(242,'core_competency_remove_competency_from_template','core_competency\\external','remove_competency_from_template',NULL,'moodle','moodle/competency:templatemanage',NULL),(243,'core_competency_reorder_course_competency','core_competency\\external','reorder_course_competency',NULL,'moodle','moodle/competency:coursecompetencymanage',NULL),(244,'core_competency_reorder_template_competency','core_competency\\external','reorder_template_competency',NULL,'moodle','moodle/competency:templatemanage',NULL),(245,'core_competency_create_template','core_competency\\external','create_template',NULL,'moodle','moodle/competency:templatemanage',NULL),(246,'core_competency_duplicate_template','core_competency\\external','duplicate_template',NULL,'moodle','moodle/competency:templatemanage',NULL),(247,'core_competency_read_template','core_competency\\external','read_template',NULL,'moodle','moodle/competency:templateview',NULL),(248,'core_competency_delete_template','core_competency\\external','delete_template',NULL,'moodle','moodle/competency:templatemanage',NULL),(249,'core_competency_update_template','core_competency\\external','update_template',NULL,'moodle','moodle/competency:templatemanage',NULL),(250,'core_competency_list_templates','core_competency\\external','list_templates',NULL,'moodle','moodle/competency:templateview',NULL),(251,'core_competency_list_templates_using_competency','core_competency\\external','list_templates_using_competency',NULL,'moodle','moodle/competency:templateview',NULL),(252,'core_competency_count_templates','core_competency\\external','count_templates',NULL,'moodle','moodle/competency:templateview',NULL),(253,'core_competency_count_templates_using_competency','core_competency\\external','count_templates_using_competency',NULL,'moodle','moodle/competency:templateview',NULL),(254,'core_competency_create_plan','core_competency\\external','create_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(255,'core_competency_update_plan','core_competency\\external','update_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(256,'core_competency_complete_plan','core_competency\\external','complete_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(257,'core_competency_reopen_plan','core_competency\\external','reopen_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(258,'core_competency_read_plan','core_competency\\external','read_plan',NULL,'moodle','moodle/competency:planviewown',NULL),(259,'core_competency_delete_plan','core_competency\\external','delete_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(260,'core_competency_list_user_plans','core_competency\\external','list_user_plans',NULL,'moodle','moodle/competency:planviewown',NULL),(261,'core_competency_list_plan_competencies','core_competency\\external','list_plan_competencies',NULL,'moodle','moodle/competency:planviewown',NULL),(262,'core_competency_add_competency_to_plan','core_competency\\external','add_competency_to_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(263,'core_competency_remove_competency_from_plan','core_competency\\external','remove_competency_from_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(264,'core_competency_reorder_plan_competency','core_competency\\external','reorder_plan_competency',NULL,'moodle','moodle/competency:planmanage',NULL),(265,'core_competency_plan_request_review','core_competency\\external','plan_request_review',NULL,'moodle','moodle/competency:planmanagedraft',NULL),(266,'core_competency_plan_start_review','core_competency\\external','plan_start_review',NULL,'moodle','moodle/competency:planmanage',NULL),(267,'core_competency_plan_stop_review','core_competency\\external','plan_stop_review',NULL,'moodle','moodle/competency:planmanage',NULL),(268,'core_competency_plan_cancel_review_request','core_competency\\external','plan_cancel_review_request',NULL,'moodle','moodle/competency:planmanagedraft',NULL),(269,'core_competency_approve_plan','core_competency\\external','approve_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(270,'core_competency_unapprove_plan','core_competency\\external','unapprove_plan',NULL,'moodle','moodle/competency:planmanage',NULL),(271,'core_competency_template_has_related_data','core_competency\\external','template_has_related_data',NULL,'moodle','moodle/competency:templateview',NULL),(272,'core_competency_get_scale_values','core_competency\\external','get_scale_values',NULL,'moodle','moodle/competency:competencymanage','moodle_mobile_app'),(273,'core_competency_add_related_competency','core_competency\\external','add_related_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(274,'core_competency_remove_related_competency','core_competency\\external','remove_related_competency',NULL,'moodle','moodle/competency:competencymanage',NULL),(275,'core_competency_read_user_evidence','core_competency\\external','read_user_evidence',NULL,'moodle','moodle/competency:userevidenceview',NULL),(276,'core_competency_delete_user_evidence','core_competency\\external','delete_user_evidence',NULL,'moodle','moodle/competency:userevidencemanageown',NULL),(277,'core_competency_create_user_evidence_competency','core_competency\\external','create_user_evidence_competency',NULL,'moodle','moodle/competency:userevidencemanageown, moodle/competency:competencyview',NULL),(278,'core_competency_delete_user_evidence_competency','core_competency\\external','delete_user_evidence_competency',NULL,'moodle','moodle/competency:userevidencemanageown',NULL),(279,'core_competency_user_competency_cancel_review_request','core_competency\\external','user_competency_cancel_review_request',NULL,'moodle','moodle/competency:userevidencemanageown',NULL),(280,'core_competency_user_competency_request_review','core_competency\\external','user_competency_request_review',NULL,'moodle','moodle/competency:userevidencemanageown',NULL),(281,'core_competency_user_competency_start_review','core_competency\\external','user_competency_start_review',NULL,'moodle','moodle/competency:competencygrade',NULL),(282,'core_competency_user_competency_stop_review','core_competency\\external','user_competency_stop_review',NULL,'moodle','moodle/competency:competencygrade',NULL),(283,'core_competency_user_competency_viewed','core_competency\\external','user_competency_viewed',NULL,'moodle','moodle/competency:usercompetencyview','moodle_mobile_app'),(284,'core_competency_user_competency_viewed_in_plan','core_competency\\external','user_competency_viewed_in_plan',NULL,'moodle','moodle/competency:usercompetencyview','moodle_mobile_app'),(285,'core_competency_user_competency_viewed_in_course','core_competency\\external','user_competency_viewed_in_course',NULL,'moodle','moodle/competency:usercompetencyview','moodle_mobile_app'),(286,'core_competency_user_competency_plan_viewed','core_competency\\external','user_competency_plan_viewed',NULL,'moodle','moodle/competency:usercompetencyview','moodle_mobile_app'),(287,'core_competency_grade_competency','core_competency\\external','grade_competency',NULL,'moodle','moodle/competency:competencygrade',NULL),(288,'core_competency_grade_competency_in_plan','core_competency\\external','grade_competency_in_plan',NULL,'moodle','moodle/competency:competencygrade',NULL),(289,'core_competency_grade_competency_in_course','core_competency\\external','grade_competency_in_course',NULL,'moodle','moodle/competency:competencygrade','moodle_mobile_app'),(290,'core_competency_unlink_plan_from_template','core_competency\\external','unlink_plan_from_template',NULL,'moodle','moodle/competency:planmanage',NULL),(291,'core_competency_template_viewed','core_competency\\external','template_viewed',NULL,'moodle','moodle/competency:templateview',NULL),(292,'core_competency_request_review_of_user_evidence_linked_competencies','core_competency\\external','request_review_of_user_evidence_linked_competencies',NULL,'moodle','moodle/competency:userevidencemanageown',NULL),(293,'core_competency_update_course_competency_settings','core_competency\\external','update_course_competency_settings',NULL,'moodle','moodle/competency:coursecompetencyconfigure',NULL),(294,'core_competency_delete_evidence','core_competency\\external','delete_evidence',NULL,'moodle','moodle/competency:evidencedelete','moodle_mobile_app'),(295,'core_webservice_get_site_info','core_webservice_external','get_site_info','webservice/externallib.php','moodle','','moodle_mobile_app'),(296,'core_block_get_course_blocks','core_block_external','get_course_blocks',NULL,'moodle','','moodle_mobile_app'),(297,'core_block_get_dashboard_blocks','core_block_external','get_dashboard_blocks',NULL,'moodle','','moodle_mobile_app'),(298,'core_filters_get_available_in_context','core_filters\\external','get_available_in_context',NULL,'moodle','','moodle_mobile_app'),(299,'core_customfield_delete_field','core_customfield_external','delete_field','customfield/externallib.php','moodle','',NULL),(300,'core_customfield_reload_template','core_customfield_external','reload_template','customfield/externallib.php','moodle','',NULL),(301,'core_customfield_create_category','core_customfield_external','create_category','customfield/externallib.php','moodle','',NULL),(302,'core_customfield_delete_category','core_customfield_external','delete_category','customfield/externallib.php','moodle','',NULL),(303,'core_customfield_move_field','core_customfield_external','move_field','customfield/externallib.php','moodle','',NULL),(304,'core_customfield_move_category','core_customfield_external','move_category','customfield/externallib.php','moodle','',NULL),(305,'core_h5p_get_trusted_h5p_file','core_h5p\\external','get_trusted_h5p_file',NULL,'moodle','','moodle_mobile_app'),(306,'core_table_get_dynamic_table_content','core_table\\external\\dynamic\\get','execute',NULL,'moodle','','moodle_mobile_app'),(307,'core_xapi_statement_post','core_xapi\\external\\post_statement','execute',NULL,'moodle','','moodle_mobile_app'),(308,'core_contentbank_delete_content','core_contentbank\\external\\delete_content','execute',NULL,'moodle','moodle/contentbank:deleteanycontent',NULL),(309,'core_contentbank_rename_content','core_contentbank\\external\\rename_content','execute',NULL,'moodle','moodle/contentbank:manageowncontent',NULL),(310,'core_create_userfeedback_action_record','core\\external\\record_userfeedback_action','execute',NULL,'moodle','',NULL),(311,'core_payment_get_available_gateways','core_payment\\external\\get_available_gateways','execute',NULL,'moodle','',NULL),(312,'mod_assign_copy_previous_attempt','mod_assign_external','copy_previous_attempt','mod/assign/externallib.php','mod_assign','mod/assign:view, mod/assign:submit',NULL),(313,'mod_assign_get_grades','mod_assign_external','get_grades','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(314,'mod_assign_get_assignments','mod_assign_external','get_assignments','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(315,'mod_assign_get_submissions','mod_assign_external','get_submissions','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(316,'mod_assign_get_user_flags','mod_assign_external','get_user_flags','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(317,'mod_assign_set_user_flags','mod_assign_external','set_user_flags','mod/assign/externallib.php','mod_assign','mod/assign:grade','moodle_mobile_app'),(318,'mod_assign_get_user_mappings','mod_assign_external','get_user_mappings','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(319,'mod_assign_revert_submissions_to_draft','mod_assign_external','revert_submissions_to_draft','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(320,'mod_assign_lock_submissions','mod_assign_external','lock_submissions','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(321,'mod_assign_unlock_submissions','mod_assign_external','unlock_submissions','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(322,'mod_assign_save_submission','mod_assign_external','save_submission','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(323,'mod_assign_submit_for_grading','mod_assign_external','submit_for_grading','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(324,'mod_assign_save_grade','mod_assign_external','save_grade','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(325,'mod_assign_save_grades','mod_assign_external','save_grades','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(326,'mod_assign_save_user_extensions','mod_assign_external','save_user_extensions','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(327,'mod_assign_reveal_identities','mod_assign_external','reveal_identities','mod/assign/externallib.php','mod_assign','','moodle_mobile_app'),(328,'mod_assign_view_grading_table','mod_assign_external','view_grading_table','mod/assign/externallib.php','mod_assign','mod/assign:view, mod/assign:viewgrades','moodle_mobile_app'),(329,'mod_assign_view_submission_status','mod_assign_external','view_submission_status','mod/assign/externallib.php','mod_assign','mod/assign:view','moodle_mobile_app'),(330,'mod_assign_get_submission_status','mod_assign_external','get_submission_status','mod/assign/externallib.php','mod_assign','mod/assign:view','moodle_mobile_app'),(331,'mod_assign_list_participants','mod_assign_external','list_participants','mod/assign/externallib.php','mod_assign','mod/assign:view, mod/assign:viewgrades','moodle_mobile_app'),(332,'mod_assign_submit_grading_form','mod_assign_external','submit_grading_form','mod/assign/externallib.php','mod_assign','mod/assign:grade','moodle_mobile_app'),(333,'mod_assign_get_participant','mod_assign_external','get_participant','mod/assign/externallib.php','mod_assign','mod/assign:view, mod/assign:viewgrades','moodle_mobile_app'),(334,'mod_assign_view_assign','mod_assign_external','view_assign','mod/assign/externallib.php','mod_assign','mod/assign:view','moodle_mobile_app'),(335,'mod_book_view_book','mod_book_external','view_book',NULL,'mod_book','mod/book:read','moodle_mobile_app'),(336,'mod_book_get_books_by_courses','mod_book_external','get_books_by_courses',NULL,'mod_book','','moodle_mobile_app'),(337,'mod_chat_login_user','mod_chat_external','login_user',NULL,'mod_chat','mod/chat:chat','moodle_mobile_app'),(338,'mod_chat_get_chat_users','mod_chat_external','get_chat_users',NULL,'mod_chat','mod/chat:chat','moodle_mobile_app'),(339,'mod_chat_send_chat_message','mod_chat_external','send_chat_message',NULL,'mod_chat','mod/chat:chat','moodle_mobile_app'),(340,'mod_chat_get_chat_latest_messages','mod_chat_external','get_chat_latest_messages',NULL,'mod_chat','mod/chat:chat','moodle_mobile_app'),(341,'mod_chat_view_chat','mod_chat_external','view_chat',NULL,'mod_chat','mod/chat:chat','moodle_mobile_app'),(342,'mod_chat_get_chats_by_courses','mod_chat_external','get_chats_by_courses',NULL,'mod_chat','','moodle_mobile_app'),(343,'mod_chat_get_sessions','mod_chat_external','get_sessions',NULL,'mod_chat','','moodle_mobile_app'),(344,'mod_chat_get_session_messages','mod_chat_external','get_session_messages',NULL,'mod_chat','','moodle_mobile_app'),(345,'mod_choice_get_choice_results','mod_choice_external','get_choice_results',NULL,'mod_choice','','moodle_mobile_app'),(346,'mod_choice_get_choice_options','mod_choice_external','get_choice_options',NULL,'mod_choice','mod/choice:choose','moodle_mobile_app'),(347,'mod_choice_submit_choice_response','mod_choice_external','submit_choice_response',NULL,'mod_choice','mod/choice:choose','moodle_mobile_app'),(348,'mod_choice_view_choice','mod_choice_external','view_choice',NULL,'mod_choice','','moodle_mobile_app'),(349,'mod_choice_get_choices_by_courses','mod_choice_external','get_choices_by_courses',NULL,'mod_choice','','moodle_mobile_app'),(350,'mod_choice_delete_choice_responses','mod_choice_external','delete_choice_responses',NULL,'mod_choice','mod/choice:choose','moodle_mobile_app'),(351,'mod_data_get_databases_by_courses','mod_data_external','get_databases_by_courses',NULL,'mod_data','mod/data:viewentry','moodle_mobile_app'),(352,'mod_data_view_database','mod_data_external','view_database',NULL,'mod_data','mod/data:viewentry','moodle_mobile_app'),(353,'mod_data_get_data_access_information','mod_data_external','get_data_access_information',NULL,'mod_data','mod/data:viewentry','moodle_mobile_app'),(354,'mod_data_get_entries','mod_data_external','get_entries',NULL,'mod_data','mod/data:viewentry','moodle_mobile_app'),(355,'mod_data_get_entry','mod_data_external','get_entry',NULL,'mod_data','mod/data:viewentry','moodle_mobile_app'),(356,'mod_data_get_fields','mod_data_external','get_fields',NULL,'mod_data','mod/data:viewentry','moodle_mobile_app'),(357,'mod_data_search_entries','mod_data_external','search_entries',NULL,'mod_data','mod/data:viewentry','moodle_mobile_app'),(358,'mod_data_approve_entry','mod_data_external','approve_entry',NULL,'mod_data','mod/data:approve','moodle_mobile_app'),(359,'mod_data_delete_entry','mod_data_external','delete_entry',NULL,'mod_data','mod/data:manageentries','moodle_mobile_app'),(360,'mod_data_add_entry','mod_data_external','add_entry',NULL,'mod_data','mod/data:writeentry','moodle_mobile_app'),(361,'mod_data_update_entry','mod_data_external','update_entry',NULL,'mod_data','mod/data:writeentry','moodle_mobile_app'),(362,'mod_feedback_get_feedbacks_by_courses','mod_feedback_external','get_feedbacks_by_courses',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(363,'mod_feedback_get_feedback_access_information','mod_feedback_external','get_feedback_access_information',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(364,'mod_feedback_view_feedback','mod_feedback_external','view_feedback',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(365,'mod_feedback_get_current_completed_tmp','mod_feedback_external','get_current_completed_tmp',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(366,'mod_feedback_get_items','mod_feedback_external','get_items',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(367,'mod_feedback_launch_feedback','mod_feedback_external','launch_feedback',NULL,'mod_feedback','mod/feedback:complete','moodle_mobile_app'),(368,'mod_feedback_get_page_items','mod_feedback_external','get_page_items',NULL,'mod_feedback','mod/feedback:complete','moodle_mobile_app'),(369,'mod_feedback_process_page','mod_feedback_external','process_page',NULL,'mod_feedback','mod/feedback:complete','moodle_mobile_app'),(370,'mod_feedback_get_analysis','mod_feedback_external','get_analysis',NULL,'mod_feedback','mod/feedback:viewanalysepage','moodle_mobile_app'),(371,'mod_feedback_get_unfinished_responses','mod_feedback_external','get_unfinished_responses',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(372,'mod_feedback_get_finished_responses','mod_feedback_external','get_finished_responses',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(373,'mod_feedback_get_non_respondents','mod_feedback_external','get_non_respondents',NULL,'mod_feedback','mod/feedback:viewreports','moodle_mobile_app'),(374,'mod_feedback_get_responses_analysis','mod_feedback_external','get_responses_analysis',NULL,'mod_feedback','mod/feedback:viewreports','moodle_mobile_app'),(375,'mod_feedback_get_last_completed','mod_feedback_external','get_last_completed',NULL,'mod_feedback','mod/feedback:view','moodle_mobile_app'),(376,'mod_folder_view_folder','mod_folder_external','view_folder',NULL,'mod_folder','mod/folder:view','moodle_mobile_app'),(377,'mod_folder_get_folders_by_courses','mod_folder_external','get_folders_by_courses',NULL,'mod_folder','mod/folder:view','moodle_mobile_app'),(378,'mod_forum_get_forums_by_courses','mod_forum_external','get_forums_by_courses','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion','moodle_mobile_app'),(379,'mod_forum_get_discussion_posts','mod_forum_external','get_discussion_posts','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion, mod/forum:viewqandawithoutposting','moodle_mobile_app'),(380,'mod_forum_get_forum_discussion_posts','mod_forum_external','get_forum_discussion_posts','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion, mod/forum:viewqandawithoutposting','moodle_mobile_app'),(381,'mod_forum_get_forum_discussions_paginated','mod_forum_external','get_forum_discussions_paginated','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion, mod/forum:viewqandawithoutposting','moodle_mobile_app'),(382,'mod_forum_get_forum_discussions','mod_forum_external','get_forum_discussions','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion, mod/forum:viewqandawithoutposting','moodle_mobile_app'),(383,'mod_forum_view_forum','mod_forum_external','view_forum','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion','moodle_mobile_app'),(384,'mod_forum_view_forum_discussion','mod_forum_external','view_forum_discussion','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion','moodle_mobile_app'),(385,'mod_forum_add_discussion_post','mod_forum_external','add_discussion_post','mod/forum/externallib.php','mod_forum','mod/forum:replypost','moodle_mobile_app'),(386,'mod_forum_add_discussion','mod_forum_external','add_discussion','mod/forum/externallib.php','mod_forum','mod/forum:startdiscussion','moodle_mobile_app'),(387,'mod_forum_can_add_discussion','mod_forum_external','can_add_discussion','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(388,'mod_forum_get_forum_access_information','mod_forum_external','get_forum_access_information',NULL,'mod_forum','','moodle_mobile_app'),(389,'mod_forum_set_subscription_state','mod_forum_external','set_subscription_state','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(390,'mod_forum_set_lock_state','mod_forum_external','set_lock_state','mod/forum/externallib.php','mod_forum','moodle/course:manageactivities','moodle_mobile_app'),(391,'mod_forum_toggle_favourite_state','mod_forum_external','toggle_favourite_state','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(392,'mod_forum_set_pin_state','mod_forum_external','set_pin_state','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(393,'mod_forum_delete_post','mod_forum_external','delete_post','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(394,'mod_forum_get_discussion_posts_by_userid','mod_forum_external','get_discussion_posts_by_userid','mod/forum/externallib.php','mod_forum','mod/forum:viewdiscussion, mod/forum:viewqandawithoutposting',NULL),(395,'mod_forum_get_discussion_post','mod_forum_external','get_discussion_post','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(396,'mod_forum_prepare_draft_area_for_post','mod_forum_external','prepare_draft_area_for_post','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(397,'mod_forum_update_discussion_post','mod_forum_external','update_discussion_post','mod/forum/externallib.php','mod_forum','','moodle_mobile_app'),(398,'mod_glossary_get_glossaries_by_courses','mod_glossary_external','get_glossaries_by_courses',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(399,'mod_glossary_view_glossary','mod_glossary_external','view_glossary',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(400,'mod_glossary_view_entry','mod_glossary_external','view_entry',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(401,'mod_glossary_get_entries_by_letter','mod_glossary_external','get_entries_by_letter',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(402,'mod_glossary_get_entries_by_date','mod_glossary_external','get_entries_by_date',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(403,'mod_glossary_get_categories','mod_glossary_external','get_categories',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(404,'mod_glossary_get_entries_by_category','mod_glossary_external','get_entries_by_category',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(405,'mod_glossary_get_authors','mod_glossary_external','get_authors',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(406,'mod_glossary_get_entries_by_author','mod_glossary_external','get_entries_by_author',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(407,'mod_glossary_get_entries_by_author_id','mod_glossary_external','get_entries_by_author_id',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(408,'mod_glossary_get_entries_by_search','mod_glossary_external','get_entries_by_search',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(409,'mod_glossary_get_entries_by_term','mod_glossary_external','get_entries_by_term',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(410,'mod_glossary_get_entries_to_approve','mod_glossary_external','get_entries_to_approve',NULL,'mod_glossary','mod/glossary:approve','moodle_mobile_app'),(411,'mod_glossary_get_entry_by_id','mod_glossary_external','get_entry_by_id',NULL,'mod_glossary','mod/glossary:view','moodle_mobile_app'),(412,'mod_glossary_add_entry','mod_glossary_external','add_entry',NULL,'mod_glossary','mod/glossary:write','moodle_mobile_app'),(413,'mod_glossary_delete_entry','mod_glossary\\external\\delete_entry','execute',NULL,'mod_glossary','','moodle_mobile_app'),(414,'mod_glossary_update_entry','mod_glossary\\external\\update_entry','execute',NULL,'mod_glossary','','moodle_mobile_app'),(415,'mod_glossary_prepare_entry_for_edition','mod_glossary\\external\\prepare_entry','execute',NULL,'mod_glossary','','moodle_mobile_app'),(416,'mod_h5pactivity_get_h5pactivity_access_information','mod_h5pactivity\\external\\get_h5pactivity_access_information','execute',NULL,'mod_h5pactivity','mod/h5pactivity:view','moodle_mobile_app'),(417,'mod_h5pactivity_view_h5pactivity','mod_h5pactivity\\external\\view_h5pactivity','execute',NULL,'mod_h5pactivity','mod/h5pactivity:view','moodle_mobile_app'),(418,'mod_h5pactivity_get_attempts','mod_h5pactivity\\external\\get_attempts','execute',NULL,'mod_h5pactivity','mod/h5pactivity:view','moodle_mobile_app'),(419,'mod_h5pactivity_get_results','mod_h5pactivity\\external\\get_results','execute',NULL,'mod_h5pactivity','mod/h5pactivity:view','moodle_mobile_app'),(420,'mod_h5pactivity_get_h5pactivities_by_courses','mod_h5pactivity\\external\\get_h5pactivities_by_courses','execute',NULL,'mod_h5pactivity','mod/h5pactivity:view','moodle_mobile_app'),(421,'mod_imscp_view_imscp','mod_imscp_external','view_imscp',NULL,'mod_imscp','mod/imscp:view','moodle_mobile_app'),(422,'mod_imscp_get_imscps_by_courses','mod_imscp_external','get_imscps_by_courses',NULL,'mod_imscp','mod/imscp:view','moodle_mobile_app'),(423,'mod_label_get_labels_by_courses','mod_label_external','get_labels_by_courses',NULL,'mod_label','mod/label:view','moodle_mobile_app'),(424,'mod_lesson_get_lessons_by_courses','mod_lesson_external','get_lessons_by_courses',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(425,'mod_lesson_get_lesson_access_information','mod_lesson_external','get_lesson_access_information',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(426,'mod_lesson_view_lesson','mod_lesson_external','view_lesson',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(427,'mod_lesson_get_questions_attempts','mod_lesson_external','get_questions_attempts',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(428,'mod_lesson_get_user_grade','mod_lesson_external','get_user_grade',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(429,'mod_lesson_get_user_attempt_grade','mod_lesson_external','get_user_attempt_grade',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(430,'mod_lesson_get_content_pages_viewed','mod_lesson_external','get_content_pages_viewed',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(431,'mod_lesson_get_user_timers','mod_lesson_external','get_user_timers',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(432,'mod_lesson_get_pages','mod_lesson_external','get_pages',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(433,'mod_lesson_launch_attempt','mod_lesson_external','launch_attempt',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(434,'mod_lesson_get_page_data','mod_lesson_external','get_page_data',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(435,'mod_lesson_process_page','mod_lesson_external','process_page',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(436,'mod_lesson_finish_attempt','mod_lesson_external','finish_attempt',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(437,'mod_lesson_get_attempts_overview','mod_lesson_external','get_attempts_overview',NULL,'mod_lesson','mod/lesson:viewreports','moodle_mobile_app'),(438,'mod_lesson_get_user_attempt','mod_lesson_external','get_user_attempt',NULL,'mod_lesson','mod/lesson:viewreports','moodle_mobile_app'),(439,'mod_lesson_get_pages_possible_jumps','mod_lesson_external','get_pages_possible_jumps',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(440,'mod_lesson_get_lesson','mod_lesson_external','get_lesson',NULL,'mod_lesson','mod/lesson:view','moodle_mobile_app'),(441,'mod_lti_get_tool_launch_data','mod_lti_external','get_tool_launch_data',NULL,'mod_lti','mod/lti:view','moodle_mobile_app'),(442,'mod_lti_get_ltis_by_courses','mod_lti_external','get_ltis_by_courses',NULL,'mod_lti','mod/lti:view','moodle_mobile_app'),(443,'mod_lti_view_lti','mod_lti_external','view_lti',NULL,'mod_lti','mod/lti:view','moodle_mobile_app'),(444,'mod_lti_get_tool_proxies','mod_lti_external','get_tool_proxies',NULL,'mod_lti','moodle/site:config',NULL),(445,'mod_lti_create_tool_proxy','mod_lti_external','create_tool_proxy',NULL,'mod_lti','moodle/site:config',NULL),(446,'mod_lti_delete_tool_proxy','mod_lti_external','delete_tool_proxy',NULL,'mod_lti','moodle/site:config',NULL),(447,'mod_lti_get_tool_proxy_registration_request','mod_lti_external','get_tool_proxy_registration_request',NULL,'mod_lti','moodle/site:config',NULL),(448,'mod_lti_get_tool_types','mod_lti_external','get_tool_types',NULL,'mod_lti','moodle/site:config',NULL),(449,'mod_lti_create_tool_type','mod_lti_external','create_tool_type',NULL,'mod_lti','moodle/site:config',NULL),(450,'mod_lti_update_tool_type','mod_lti_external','update_tool_type',NULL,'mod_lti','moodle/site:config',NULL),(451,'mod_lti_delete_tool_type','mod_lti_external','delete_tool_type',NULL,'mod_lti','moodle/site:config',NULL),(452,'mod_lti_is_cartridge','mod_lti_external','is_cartridge',NULL,'mod_lti','moodle/site:config',NULL),(453,'mod_page_view_page','mod_page_external','view_page',NULL,'mod_page','mod/page:view','moodle_mobile_app'),(454,'mod_page_get_pages_by_courses','mod_page_external','get_pages_by_courses',NULL,'mod_page','mod/page:view','moodle_mobile_app'),(455,'mod_quiz_get_quizzes_by_courses','mod_quiz_external','get_quizzes_by_courses',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(456,'mod_quiz_view_quiz','mod_quiz_external','view_quiz',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(457,'mod_quiz_get_user_attempts','mod_quiz_external','get_user_attempts',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(458,'mod_quiz_get_user_best_grade','mod_quiz_external','get_user_best_grade',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(459,'mod_quiz_get_combined_review_options','mod_quiz_external','get_combined_review_options',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(460,'mod_quiz_start_attempt','mod_quiz_external','start_attempt',NULL,'mod_quiz','mod/quiz:attempt','moodle_mobile_app'),(461,'mod_quiz_get_attempt_data','mod_quiz_external','get_attempt_data',NULL,'mod_quiz','mod/quiz:attempt','moodle_mobile_app'),(462,'mod_quiz_get_attempt_summary','mod_quiz_external','get_attempt_summary',NULL,'mod_quiz','mod/quiz:attempt','moodle_mobile_app'),(463,'mod_quiz_save_attempt','mod_quiz_external','save_attempt',NULL,'mod_quiz','mod/quiz:attempt','moodle_mobile_app'),(464,'mod_quiz_process_attempt','mod_quiz_external','process_attempt',NULL,'mod_quiz','mod/quiz:attempt','moodle_mobile_app'),(465,'mod_quiz_get_attempt_review','mod_quiz_external','get_attempt_review',NULL,'mod_quiz','mod/quiz:reviewmyattempts','moodle_mobile_app'),(466,'mod_quiz_view_attempt','mod_quiz_external','view_attempt',NULL,'mod_quiz','mod/quiz:attempt','moodle_mobile_app'),(467,'mod_quiz_view_attempt_summary','mod_quiz_external','view_attempt_summary',NULL,'mod_quiz','mod/quiz:attempt','moodle_mobile_app'),(468,'mod_quiz_view_attempt_review','mod_quiz_external','view_attempt_review',NULL,'mod_quiz','mod/quiz:reviewmyattempts','moodle_mobile_app'),(469,'mod_quiz_get_quiz_feedback_for_grade','mod_quiz_external','get_quiz_feedback_for_grade',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(470,'mod_quiz_get_quiz_access_information','mod_quiz_external','get_quiz_access_information',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(471,'mod_quiz_get_attempt_access_information','mod_quiz_external','get_attempt_access_information',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(472,'mod_quiz_get_quiz_required_qtypes','mod_quiz_external','get_quiz_required_qtypes',NULL,'mod_quiz','mod/quiz:view','moodle_mobile_app'),(473,'mod_resource_view_resource','mod_resource_external','view_resource',NULL,'mod_resource','mod/resource:view','moodle_mobile_app'),(474,'mod_resource_get_resources_by_courses','mod_resource_external','get_resources_by_courses',NULL,'mod_resource','mod/resource:view','moodle_mobile_app'),(475,'mod_scorm_view_scorm','mod_scorm_external','view_scorm',NULL,'mod_scorm','','moodle_mobile_app'),(476,'mod_scorm_get_scorm_attempt_count','mod_scorm_external','get_scorm_attempt_count',NULL,'mod_scorm','','moodle_mobile_app'),(477,'mod_scorm_get_scorm_scoes','mod_scorm_external','get_scorm_scoes',NULL,'mod_scorm','','moodle_mobile_app'),(478,'mod_scorm_get_scorm_user_data','mod_scorm_external','get_scorm_user_data',NULL,'mod_scorm','','moodle_mobile_app'),(479,'mod_scorm_insert_scorm_tracks','mod_scorm_external','insert_scorm_tracks',NULL,'mod_scorm','mod/scorm:savetrack','moodle_mobile_app'),(480,'mod_scorm_get_scorm_sco_tracks','mod_scorm_external','get_scorm_sco_tracks',NULL,'mod_scorm','','moodle_mobile_app'),(481,'mod_scorm_get_scorms_by_courses','mod_scorm_external','get_scorms_by_courses',NULL,'mod_scorm','','moodle_mobile_app'),(482,'mod_scorm_launch_sco','mod_scorm_external','launch_sco',NULL,'mod_scorm','','moodle_mobile_app'),(483,'mod_scorm_get_scorm_access_information','mod_scorm_external','get_scorm_access_information',NULL,'mod_scorm','','moodle_mobile_app'),(484,'mod_survey_get_surveys_by_courses','mod_survey_external','get_surveys_by_courses',NULL,'mod_survey','','moodle_mobile_app'),(485,'mod_survey_view_survey','mod_survey_external','view_survey',NULL,'mod_survey','mod/survey:participate','moodle_mobile_app'),(486,'mod_survey_get_questions','mod_survey_external','get_questions',NULL,'mod_survey','mod/survey:participate','moodle_mobile_app'),(487,'mod_survey_submit_answers','mod_survey_external','submit_answers',NULL,'mod_survey','mod/survey:participate','moodle_mobile_app'),(488,'mod_url_view_url','mod_url_external','view_url',NULL,'mod_url','mod/url:view','moodle_mobile_app'),(489,'mod_url_get_urls_by_courses','mod_url_external','get_urls_by_courses',NULL,'mod_url','mod/url:view','moodle_mobile_app'),(490,'mod_wiki_get_wikis_by_courses','mod_wiki_external','get_wikis_by_courses',NULL,'mod_wiki','mod/wiki:viewpage','moodle_mobile_app'),(491,'mod_wiki_view_wiki','mod_wiki_external','view_wiki',NULL,'mod_wiki','mod/wiki:viewpage','moodle_mobile_app'),(492,'mod_wiki_view_page','mod_wiki_external','view_page',NULL,'mod_wiki','mod/wiki:viewpage','moodle_mobile_app'),(493,'mod_wiki_get_subwikis','mod_wiki_external','get_subwikis',NULL,'mod_wiki','mod/wiki:viewpage','moodle_mobile_app'),(494,'mod_wiki_get_subwiki_pages','mod_wiki_external','get_subwiki_pages',NULL,'mod_wiki','mod/wiki:viewpage','moodle_mobile_app'),(495,'mod_wiki_get_subwiki_files','mod_wiki_external','get_subwiki_files',NULL,'mod_wiki','mod/wiki:viewpage','moodle_mobile_app'),(496,'mod_wiki_get_page_contents','mod_wiki_external','get_page_contents',NULL,'mod_wiki','mod/wiki:viewpage','moodle_mobile_app'),(497,'mod_wiki_get_page_for_editing','mod_wiki_external','get_page_for_editing',NULL,'mod_wiki','mod/wiki:editpage','moodle_mobile_app'),(498,'mod_wiki_new_page','mod_wiki_external','new_page',NULL,'mod_wiki','mod/wiki:editpage','moodle_mobile_app'),(499,'mod_wiki_edit_page','mod_wiki_external','edit_page',NULL,'mod_wiki','mod/wiki:editpage','moodle_mobile_app'),(500,'mod_workshop_get_workshops_by_courses','mod_workshop_external','get_workshops_by_courses',NULL,'mod_workshop','mod/workshop:view','moodle_mobile_app'),(501,'mod_workshop_get_workshop_access_information','mod_workshop_external','get_workshop_access_information',NULL,'mod_workshop','mod/workshop:view','moodle_mobile_app'),(502,'mod_workshop_get_user_plan','mod_workshop_external','get_user_plan',NULL,'mod_workshop','mod/workshop:view','moodle_mobile_app'),(503,'mod_workshop_view_workshop','mod_workshop_external','view_workshop',NULL,'mod_workshop','mod/workshop:view','moodle_mobile_app'),(504,'mod_workshop_add_submission','mod_workshop_external','add_submission',NULL,'mod_workshop','mod/workshop:submit','moodle_mobile_app'),(505,'mod_workshop_update_submission','mod_workshop_external','update_submission',NULL,'mod_workshop','mod/workshop:submit','moodle_mobile_app'),(506,'mod_workshop_delete_submission','mod_workshop_external','delete_submission',NULL,'mod_workshop','mod/workshop:submit','moodle_mobile_app'),(507,'mod_workshop_get_submissions','mod_workshop_external','get_submissions',NULL,'mod_workshop','','moodle_mobile_app'),(508,'mod_workshop_get_submission','mod_workshop_external','get_submission',NULL,'mod_workshop','','moodle_mobile_app'),(509,'mod_workshop_get_submission_assessments','mod_workshop_external','get_submission_assessments',NULL,'mod_workshop','','moodle_mobile_app'),(510,'mod_workshop_get_assessment','mod_workshop_external','get_assessment',NULL,'mod_workshop','','moodle_mobile_app'),(511,'mod_workshop_get_assessment_form_definition','mod_workshop_external','get_assessment_form_definition',NULL,'mod_workshop','','moodle_mobile_app'),(512,'mod_workshop_get_reviewer_assessments','mod_workshop_external','get_reviewer_assessments',NULL,'mod_workshop','','moodle_mobile_app'),(513,'mod_workshop_update_assessment','mod_workshop_external','update_assessment',NULL,'mod_workshop','','moodle_mobile_app'),(514,'mod_workshop_get_grades','mod_workshop_external','get_grades',NULL,'mod_workshop','','moodle_mobile_app'),(515,'mod_workshop_evaluate_assessment','mod_workshop_external','evaluate_assessment',NULL,'mod_workshop','','moodle_mobile_app'),(516,'mod_workshop_get_grades_report','mod_workshop_external','get_grades_report',NULL,'mod_workshop','','moodle_mobile_app'),(517,'mod_workshop_view_submission','mod_workshop_external','view_submission',NULL,'mod_workshop','mod/workshop:view','moodle_mobile_app'),(518,'mod_workshop_evaluate_submission','mod_workshop_external','evaluate_submission',NULL,'mod_workshop','','moodle_mobile_app'),(519,'auth_email_get_signup_settings','auth_email_external','get_signup_settings',NULL,'auth_email','',NULL),(520,'auth_email_signup_user','auth_email_external','signup_user',NULL,'auth_email','',NULL),(521,'enrol_guest_get_instance_info','enrol_guest_external','get_instance_info',NULL,'enrol_guest','','moodle_mobile_app'),(522,'enrol_manual_enrol_users','enrol_manual_external','enrol_users','enrol/manual/externallib.php','enrol_manual','enrol/manual:enrol',NULL),(523,'enrol_manual_unenrol_users','enrol_manual_external','unenrol_users','enrol/manual/externallib.php','enrol_manual','enrol/manual:unenrol',NULL),(524,'enrol_self_get_instance_info','enrol_self_external','get_instance_info','enrol/self/externallib.php','enrol_self','','moodle_mobile_app'),(525,'enrol_self_enrol_user','enrol_self_external','enrol_user','enrol/self/externallib.php','enrol_self','','moodle_mobile_app'),(526,'message_airnotifier_is_system_configured','message_airnotifier_external','is_system_configured','message/output/airnotifier/externallib.php','message_airnotifier','','moodle_mobile_app'),(527,'message_airnotifier_are_notification_preferences_configured','message_airnotifier_external','are_notification_preferences_configured','message/output/airnotifier/externallib.php','message_airnotifier','','moodle_mobile_app'),(528,'message_airnotifier_get_user_devices','message_airnotifier_external','get_user_devices','message/output/airnotifier/externallib.php','message_airnotifier','','moodle_mobile_app'),(529,'message_airnotifier_enable_device','message_airnotifier_external','enable_device','message/output/airnotifier/externallib.php','message_airnotifier','message/airnotifier:managedevice','moodle_mobile_app'),(530,'message_popup_get_popup_notifications','message_popup_external','get_popup_notifications','message/output/popup/externallib.php','message_popup','','moodle_mobile_app'),(531,'message_popup_get_unread_popup_notification_count','message_popup_external','get_unread_popup_notification_count','message/output/popup/externallib.php','message_popup','','moodle_mobile_app'),(532,'block_recentlyaccesseditems_get_recent_items','block_recentlyaccesseditems\\external','get_recent_items',NULL,'block_recentlyaccesseditems','','moodle_mobile_app'),(533,'block_starredcourses_get_starred_courses','block_starredcourses_external','get_starred_courses','block/starredcourses/classes/external.php','block_starredcourses','','moodle_mobile_app'),(534,'media_videojs_get_language','media_videojs\\external\\get_language','execute',NULL,'media_videojs','',NULL),(535,'report_competency_data_for_report','report_competency\\external','data_for_report',NULL,'report_competency','moodle/competency:coursecompetencyview',NULL),(536,'report_insights_set_notuseful_prediction','report_insights\\external','set_notuseful_prediction',NULL,'report_insights','','moodle_mobile_app'),(537,'report_insights_set_fixed_prediction','report_insights\\external','set_fixed_prediction',NULL,'report_insights','','moodle_mobile_app'),(538,'report_insights_action_executed','report_insights\\external','action_executed',NULL,'report_insights','','moodle_mobile_app'),(539,'gradereport_overview_get_course_grades','gradereport_overview_external','get_course_grades',NULL,'gradereport_overview','','moodle_mobile_app'),(540,'gradereport_overview_view_grade_report','gradereport_overview_external','view_grade_report',NULL,'gradereport_overview','gradereport/overview:view','moodle_mobile_app'),(541,'gradereport_user_get_grades_table','gradereport_user_external','get_grades_table','grade/report/user/externallib.php','gradereport_user','gradereport/user:view','moodle_mobile_app'),(542,'gradereport_user_view_grade_report','gradereport_user_external','view_grade_report','grade/report/user/externallib.php','gradereport_user','gradereport/user:view','moodle_mobile_app'),(543,'gradereport_user_get_grade_items','gradereport_user_external','get_grade_items','grade/report/user/externallib.php','gradereport_user','gradereport/user:view','moodle_mobile_app'),(544,'gradingform_guide_grader_gradingpanel_fetch','gradingform_guide\\grades\\grader\\gradingpanel\\external\\fetch','execute',NULL,'gradingform_guide','',NULL),(545,'gradingform_guide_grader_gradingpanel_store','gradingform_guide\\grades\\grader\\gradingpanel\\external\\store','execute',NULL,'gradingform_guide','',NULL),(546,'gradingform_rubric_grader_gradingpanel_fetch','gradingform_rubric\\grades\\grader\\gradingpanel\\external\\fetch','execute',NULL,'gradingform_rubric','',NULL),(547,'gradingform_rubric_grader_gradingpanel_store','gradingform_rubric\\grades\\grader\\gradingpanel\\external\\store','execute',NULL,'gradingform_rubric','',NULL),(548,'tool_analytics_potential_contexts','tool_analytics\\external','potential_contexts',NULL,'tool_analytics','','moodle_mobile_app'),(549,'tool_dataprivacy_cancel_data_request','tool_dataprivacy\\external','cancel_data_request',NULL,'tool_dataprivacy','',NULL),(550,'tool_dataprivacy_contact_dpo','tool_dataprivacy\\external','contact_dpo',NULL,'tool_dataprivacy','',NULL),(551,'tool_dataprivacy_mark_complete','tool_dataprivacy\\external','mark_complete',NULL,'tool_dataprivacy','tool/dataprivacy:managedatarequests',NULL),(552,'tool_dataprivacy_get_data_request','tool_dataprivacy\\external','get_data_request',NULL,'tool_dataprivacy','tool/dataprivacy:managedatarequests',NULL),(553,'tool_dataprivacy_approve_data_request','tool_dataprivacy\\external','approve_data_request',NULL,'tool_dataprivacy','tool/dataprivacy:managedatarequests',NULL),(554,'tool_dataprivacy_bulk_approve_data_requests','tool_dataprivacy\\external','bulk_approve_data_requests',NULL,'tool_dataprivacy','tool/dataprivacy:managedatarequests',NULL),(555,'tool_dataprivacy_deny_data_request','tool_dataprivacy\\external','deny_data_request',NULL,'tool_dataprivacy','tool/dataprivacy:managedatarequests',NULL),(556,'tool_dataprivacy_bulk_deny_data_requests','tool_dataprivacy\\external','bulk_deny_data_requests',NULL,'tool_dataprivacy','tool/dataprivacy:managedatarequests',NULL),(557,'tool_dataprivacy_get_users','tool_dataprivacy\\external','get_users',NULL,'tool_dataprivacy','tool/dataprivacy:managedatarequests',NULL),(558,'tool_dataprivacy_create_purpose_form','tool_dataprivacy\\external','create_purpose_form',NULL,'tool_dataprivacy','',NULL),(559,'tool_dataprivacy_create_category_form','tool_dataprivacy\\external','create_category_form',NULL,'tool_dataprivacy','',NULL),(560,'tool_dataprivacy_delete_purpose','tool_dataprivacy\\external','delete_purpose',NULL,'tool_dataprivacy','',NULL),(561,'tool_dataprivacy_delete_category','tool_dataprivacy\\external','delete_category',NULL,'tool_dataprivacy','',NULL),(562,'tool_dataprivacy_set_contextlevel_form','tool_dataprivacy\\external','set_contextlevel_form',NULL,'tool_dataprivacy','',NULL),(563,'tool_dataprivacy_set_context_form','tool_dataprivacy\\external','set_context_form',NULL,'tool_dataprivacy','',NULL),(564,'tool_dataprivacy_tree_extra_branches','tool_dataprivacy\\external','tree_extra_branches',NULL,'tool_dataprivacy','',NULL),(565,'tool_dataprivacy_confirm_contexts_for_deletion','tool_dataprivacy\\external','confirm_contexts_for_deletion',NULL,'tool_dataprivacy','',NULL),(566,'tool_dataprivacy_set_context_defaults','tool_dataprivacy\\external','set_context_defaults',NULL,'tool_dataprivacy','tool/dataprivacy:managedataregistry',NULL),(567,'tool_dataprivacy_get_category_options','tool_dataprivacy\\external','get_category_options',NULL,'tool_dataprivacy','tool/dataprivacy:managedataregistry',NULL),(568,'tool_dataprivacy_get_purpose_options','tool_dataprivacy\\external','get_purpose_options',NULL,'tool_dataprivacy','tool/dataprivacy:managedataregistry',NULL),(569,'tool_dataprivacy_get_activity_options','tool_dataprivacy\\external','get_activity_options',NULL,'tool_dataprivacy','tool/dataprivacy:managedataregistry',NULL),(570,'tool_lp_data_for_competency_frameworks_manage_page','tool_lp\\external','data_for_competency_frameworks_manage_page',NULL,'tool_lp','moodle/competency:competencyview',NULL),(571,'tool_lp_data_for_competency_summary','tool_lp\\external','data_for_competency_summary',NULL,'tool_lp','moodle/competency:competencyview',NULL),(572,'tool_lp_data_for_competencies_manage_page','tool_lp\\external','data_for_competencies_manage_page',NULL,'tool_lp','moodle/competency:competencyview',NULL),(573,'tool_lp_list_courses_using_competency','tool_lp\\external','list_courses_using_competency',NULL,'tool_lp','moodle/competency:coursecompetencyview',NULL),(574,'tool_lp_data_for_course_competencies_page','tool_lp\\external','data_for_course_competencies_page',NULL,'tool_lp','moodle/competency:coursecompetencyview','moodle_mobile_app'),(575,'tool_lp_data_for_template_competencies_page','tool_lp\\external','data_for_template_competencies_page',NULL,'tool_lp','moodle/competency:templateview',NULL),(576,'tool_lp_data_for_templates_manage_page','tool_lp\\external','data_for_templates_manage_page',NULL,'tool_lp','moodle/competency:templateview',NULL),(577,'tool_lp_data_for_plans_page','tool_lp\\external','data_for_plans_page',NULL,'tool_lp','moodle/competency:planviewown','moodle_mobile_app'),(578,'tool_lp_data_for_plan_page','tool_lp\\external','data_for_plan_page',NULL,'tool_lp','moodle/competency:planview','moodle_mobile_app'),(579,'tool_lp_data_for_related_competencies_section','tool_lp\\external','data_for_related_competencies_section',NULL,'tool_lp','moodle/competency:competencyview',NULL),(580,'tool_lp_search_users','tool_lp\\external','search_users',NULL,'tool_lp','',NULL),(581,'tool_lp_search_cohorts','core_cohort_external','search_cohorts','cohort/externallib.php','tool_lp','moodle/cohort:view',NULL),(582,'tool_lp_data_for_user_evidence_list_page','tool_lp\\external','data_for_user_evidence_list_page',NULL,'tool_lp','moodle/competency:userevidenceview','moodle_mobile_app'),(583,'tool_lp_data_for_user_evidence_page','tool_lp\\external','data_for_user_evidence_page',NULL,'tool_lp','moodle/competency:userevidenceview','moodle_mobile_app'),(584,'tool_lp_data_for_user_competency_summary','tool_lp\\external','data_for_user_competency_summary',NULL,'tool_lp','moodle/competency:planview','moodle_mobile_app'),(585,'tool_lp_data_for_user_competency_summary_in_plan','tool_lp\\external','data_for_user_competency_summary_in_plan',NULL,'tool_lp','moodle/competency:planview','moodle_mobile_app'),(586,'tool_lp_data_for_user_competency_summary_in_course','tool_lp\\external','data_for_user_competency_summary_in_course',NULL,'tool_lp','moodle/competency:coursecompetencyview','moodle_mobile_app'),(587,'tool_mobile_get_plugins_supporting_mobile','tool_mobile\\external','get_plugins_supporting_mobile',NULL,'tool_mobile','','moodle_mobile_app'),(588,'tool_mobile_get_public_config','tool_mobile\\external','get_public_config',NULL,'tool_mobile','','moodle_mobile_app'),(589,'tool_mobile_get_config','tool_mobile\\external','get_config',NULL,'tool_mobile','','moodle_mobile_app'),(590,'tool_mobile_get_autologin_key','tool_mobile\\external','get_autologin_key',NULL,'tool_mobile','','moodle_mobile_app'),(591,'tool_mobile_get_content','tool_mobile\\external','get_content',NULL,'tool_mobile','','moodle_mobile_app'),(592,'tool_mobile_call_external_functions','tool_mobile\\external','call_external_functions',NULL,'tool_mobile','','moodle_mobile_app'),(593,'tool_mobile_validate_subscription_key','tool_mobile\\external','validate_subscription_key',NULL,'tool_mobile','','moodle_mobile_app'),(594,'tool_mobile_get_tokens_for_qr_login','tool_mobile\\external','get_tokens_for_qr_login',NULL,'tool_mobile','','moodle_mobile_app'),(595,'tool_moodlenet_verify_webfinger','tool_moodlenet\\external','verify_webfinger',NULL,'tool_moodlenet','','moodle_mobile_app'),(596,'tool_moodlenet_search_courses','tool_moodlenet\\external','search_courses',NULL,'tool_moodlenet','','moodle_mobile_app'),(597,'tool_policy_get_policy_version','tool_policy\\external','get_policy_version',NULL,'tool_policy','',NULL),(598,'tool_policy_submit_accept_on_behalf','tool_policy\\external','submit_accept_on_behalf',NULL,'tool_policy','',NULL),(599,'tool_templatelibrary_list_templates','tool_templatelibrary\\external','list_templates',NULL,'tool_templatelibrary','',NULL),(600,'tool_templatelibrary_load_canonical_template','tool_templatelibrary\\external','load_canonical_template',NULL,'tool_templatelibrary','',NULL),(601,'tool_usertours_fetch_and_start_tour','tool_usertours\\external\\tour','fetch_and_start_tour',NULL,'tool_usertours','',NULL),(602,'tool_usertours_step_shown','tool_usertours\\external\\tour','step_shown',NULL,'tool_usertours','',NULL),(603,'tool_usertours_complete_tour','tool_usertours\\external\\tour','complete_tour',NULL,'tool_usertours','',NULL),(604,'tool_usertours_reset_tour','tool_usertours\\external\\tour','reset_tour',NULL,'tool_usertours','',NULL),(605,'tool_xmldb_invoke_move_action','tool_xmldb_external','invoke_move_action',NULL,'tool_xmldb','',NULL),(606,'paygw_paypal_get_config_for_js','paygw_paypal\\external\\get_config_for_js','execute',NULL,'paygw_paypal','',NULL),(607,'paygw_paypal_create_transaction_complete','paygw_paypal\\external\\transaction_complete','execute',NULL,'paygw_paypal','',NULL);

--
