--
-- Host: localhost    Database: dlhplata_newmod
-- ------------------------------------------------------


--
-- Table structure for table `mdl0i_analytics_indicator_calc`
--

CREATE TABLE `mdl0i_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 `mdl0i_analindicalc_staendco_ix` (`starttime`,`endtime`,`contextid`),
  KEY `mdl0i_analindicalc_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stored indicator calculations';

--
-- Dumping data for table `mdl0i_analytics_indicator_calc`
--


--
-- Table structure for table `mdl0i_analytics_models`
--

CREATE TABLE `mdl0i_analytics_models` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `trained` tinyint(1) NOT NULL DEFAULT '0',
  `target` varchar(255) NOT NULL DEFAULT '',
  `indicators` longtext NOT NULL,
  `timesplitting` varchar(255) DEFAULT NULL,
  `version` bigint(10) NOT NULL,
  `timecreated` bigint(10) DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_analmode_enatra_ix` (`enabled`,`trained`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Analytic models.';

--
-- Dumping data for table `mdl0i_analytics_models`
--

INSERT INTO `mdl0i_analytics_models` VALUES (1,0,0,'\\core\\analytics\\target\\course_dropout','[\"\\\\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\",\"\\\\core_course\\\\analytics\\\\indicator\\\\completion_enabled\",\"\\\\core_course\\\\analytics\\\\indicator\\\\potential_cognitive_depth\",\"\\\\core_course\\\\analytics\\\\indicator\\\\potential_social_breadth\",\"\\\\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\"]',NULL,1538674447,1538674447,1538674447,0),(2,1,1,'\\core\\analytics\\target\\no_teaching','[\"\\\\core_course\\\\analytics\\\\indicator\\\\no_teacher\",\"\\\\core_course\\\\analytics\\\\indicator\\\\no_student\"]','\\core\\analytics\\time_splitting\\single_range',1538674447,1538674447,1538674447,0);

--
-- Table structure for table `mdl0i_analytics_models_log`
--

CREATE TABLE `mdl0i_analytics_models_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `modelid` bigint(10) NOT NULL,
  `version` bigint(10) NOT NULL,
  `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,
  `dir` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_analmodelog_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analytic models changes during evaluation.';

--
-- Dumping data for table `mdl0i_analytics_models_log`
--


--
-- Table structure for table `mdl0i_analytics_predict_samples`
--

CREATE TABLE `mdl0i_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 `mdl0i_analpredsamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`,`rangeindex`),
  KEY `mdl0i_analpredsamp_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Samples already used for predictions.';

--
-- Dumping data for table `mdl0i_analytics_predict_samples`
--


--
-- Table structure for table `mdl0i_analytics_prediction_actions`
--

CREATE TABLE `mdl0i_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 `mdl0i_analpredacti_preuseac_ix` (`predictionid`,`userid`,`actionname`),
  KEY `mdl0i_analpredacti_pre_ix` (`predictionid`),
  KEY `mdl0i_analpredacti_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Register of user actions over predictions.';

--
-- Dumping data for table `mdl0i_analytics_prediction_actions`
--


--
-- Table structure for table `mdl0i_analytics_predictions`
--

CREATE TABLE `mdl0i_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 `mdl0i_analpred_modcon_ix` (`modelid`,`contextid`),
  KEY `mdl0i_analpred_mod_ix` (`modelid`),
  KEY `mdl0i_analpred_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Predictions';

--
-- Dumping data for table `mdl0i_analytics_predictions`
--


--
-- Table structure for table `mdl0i_analytics_train_samples`
--

CREATE TABLE `mdl0i_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 '',
  `fileid` bigint(10) NOT NULL,
  `sampleids` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl0i_analtraisamp_modanati_ix` (`modelid`,`analysableid`,`timesplitting`),
  KEY `mdl0i_analtraisamp_mod_ix` (`modelid`),
  KEY `mdl0i_analtraisamp_fil_ix` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Samples used for training';

--
-- Dumping data for table `mdl0i_analytics_train_samples`
--


--
-- Table structure for table `mdl0i_analytics_used_analysables`
--

CREATE TABLE `mdl0i_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,
  `timeanalysed` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_analusedanal_modact_ix` (`modelid`,`action`),
  KEY `mdl0i_analusedanal_mod_ix` (`modelid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List of analysables used by each model';

--
-- Dumping data for table `mdl0i_analytics_used_analysables`
--


--
-- Table structure for table `mdl0i_analytics_used_files`
--

CREATE TABLE `mdl0i_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 `mdl0i_analusedfile_modactfi_ix` (`modelid`,`action`,`fileid`),
  KEY `mdl0i_analusedfile_mod_ix` (`modelid`),
  KEY `mdl0i_analusedfile_fil_ix` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Files that have already been used for training and predictio';

--
-- Dumping data for table `mdl0i_analytics_used_files`
--


--
-- Table structure for table `mdl0i_assign`
--

CREATE TABLE `mdl0i_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',
  `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 `mdl0i_assi_cou_ix` (`course`),
  KEY `mdl0i_assi_tea_ix` (`teamsubmissiongroupingid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table saves information about an instance of mod_assign';

--
-- Dumping data for table `mdl0i_assign`
--


--
-- Table structure for table `mdl0i_assign_grades`
--

CREATE TABLE `mdl0i_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 `mdl0i_assigrad_assuseatt_uix` (`assignment`,`userid`,`attemptnumber`),
  KEY `mdl0i_assigrad_use_ix` (`userid`),
  KEY `mdl0i_assigrad_att_ix` (`attemptnumber`),
  KEY `mdl0i_assigrad_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grading information about a single assignment submission.';

--
-- Dumping data for table `mdl0i_assign_grades`
--


--
-- Table structure for table `mdl0i_assign_overrides`
--

CREATE TABLE `mdl0i_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 `mdl0i_assiover_ass_ix` (`assignid`),
  KEY `mdl0i_assiover_gro_ix` (`groupid`),
  KEY `mdl0i_assiover_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The overrides to assign settings.';

--
-- Dumping data for table `mdl0i_assign_overrides`
--


--
-- Table structure for table `mdl0i_assign_plugin_config`
--

CREATE TABLE `mdl0i_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,
  PRIMARY KEY (`id`),
  KEY `mdl0i_assiplugconf_plu_ix` (`plugin`),
  KEY `mdl0i_assiplugconf_sub_ix` (`subtype`),
  KEY `mdl0i_assiplugconf_nam_ix` (`name`),
  KEY `mdl0i_assiplugconf_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Config data for an instance of a plugin in an assignment.';

--
-- Dumping data for table `mdl0i_assign_plugin_config`
--


--
-- Table structure for table `mdl0i_assign_submission`
--

CREATE TABLE `mdl0i_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 `mdl0i_assisubm_assusegroat_uix` (`assignment`,`userid`,`groupid`,`attemptnumber`),
  KEY `mdl0i_assisubm_use_ix` (`userid`),
  KEY `mdl0i_assisubm_att_ix` (`attemptnumber`),
  KEY `mdl0i_assisubm_assusegrolat_ix` (`assignment`,`userid`,`groupid`,`latest`),
  KEY `mdl0i_assisubm_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table keeps information about student interactions with';

--
-- Dumping data for table `mdl0i_assign_submission`
--


--
-- Table structure for table `mdl0i_assign_user_flags`
--

CREATE TABLE `mdl0i_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 `mdl0i_assiuserflag_mai_ix` (`mailed`),
  KEY `mdl0i_assiuserflag_use_ix` (`userid`),
  KEY `mdl0i_assiuserflag_ass_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List of flags that can be set for a single user in a single ';

--
-- Dumping data for table `mdl0i_assign_user_flags`
--


--
-- Table structure for table `mdl0i_assign_user_mapping`
--

CREATE TABLE `mdl0i_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 `mdl0i_assiusermapp_ass_ix` (`assignment`),
  KEY `mdl0i_assiusermapp_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Map an assignment specific id number to a user';

--
-- Dumping data for table `mdl0i_assign_user_mapping`
--


--
-- Table structure for table `mdl0i_assignfeedback_comments`
--

CREATE TABLE `mdl0i_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,
  `commentformat` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl0i_assicomm_ass_ix` (`assignment`),
  KEY `mdl0i_assicomm_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Text feedback for submitted assignments';

--
-- Dumping data for table `mdl0i_assignfeedback_comments`
--


--
-- Table structure for table `mdl0i_assignfeedback_editpdf_annot`
--

CREATE TABLE `mdl0i_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,
  `type` varchar(10) DEFAULT 'line',
  `colour` varchar(10) DEFAULT 'black',
  `draft` tinyint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `mdl0i_assieditanno_grapag_ix` (`gradeid`,`pageno`),
  KEY `mdl0i_assieditanno_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='stores annotations added to pdfs submitted by students';

--
-- Dumping data for table `mdl0i_assignfeedback_editpdf_annot`
--


--
-- Table structure for table `mdl0i_assignfeedback_editpdf_cmnt`
--

CREATE TABLE `mdl0i_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,
  `pageno` bigint(10) NOT NULL DEFAULT '0',
  `colour` varchar(10) DEFAULT 'black',
  `draft` tinyint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `mdl0i_assieditcmnt_grapag_ix` (`gradeid`,`pageno`),
  KEY `mdl0i_assieditcmnt_gra_ix` (`gradeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores comments added to pdfs';

--
-- Dumping data for table `mdl0i_assignfeedback_editpdf_cmnt`
--


--
-- Table structure for table `mdl0i_assignfeedback_editpdf_queue`
--

CREATE TABLE `mdl0i_assignfeedback_editpdf_queue` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `submissionid` bigint(10) NOT NULL,
  `submissionattempt` bigint(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Queue for processing.';

--
-- Dumping data for table `mdl0i_assignfeedback_editpdf_queue`
--


--
-- Table structure for table `mdl0i_assignfeedback_editpdf_quick`
--

CREATE TABLE `mdl0i_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 `mdl0i_assieditquic_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores teacher specified quicklist comments';

--
-- Dumping data for table `mdl0i_assignfeedback_editpdf_quick`
--


--
-- Table structure for table `mdl0i_assignfeedback_file`
--

CREATE TABLE `mdl0i_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 `mdl0i_assifile_ass2_ix` (`assignment`),
  KEY `mdl0i_assifile_gra_ix` (`grade`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores info about the number of files submitted by a student';

--
-- Dumping data for table `mdl0i_assignfeedback_file`
--


--
-- Table structure for table `mdl0i_assignment`
--

CREATE TABLE `mdl0i_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 `mdl0i_assi_cou2_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines assignments';

--
-- Dumping data for table `mdl0i_assignment`
--


--
-- Table structure for table `mdl0i_assignment_submissions`
--

CREATE TABLE `mdl0i_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,
  `data2` longtext,
  `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 `mdl0i_assisubm_use2_ix` (`userid`),
  KEY `mdl0i_assisubm_mai_ix` (`mailed`),
  KEY `mdl0i_assisubm_tim_ix` (`timemarked`),
  KEY `mdl0i_assisubm_ass2_ix` (`assignment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Info about submitted assignments';

--
-- Dumping data for table `mdl0i_assignment_submissions`
--


--
-- Table structure for table `mdl0i_assignment_upgrade`
--

CREATE TABLE `mdl0i_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 `mdl0i_assiupgr_old_ix` (`oldcmid`),
  KEY `mdl0i_assiupgr_old2_ix` (`oldinstance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Info about upgraded assignments';

--
-- Dumping data for table `mdl0i_assignment_upgrade`
--


--
-- Table structure for table `mdl0i_assignsubmission_file`
--

CREATE TABLE `mdl0i_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 `mdl0i_assifile_ass_ix` (`assignment`),
  KEY `mdl0i_assifile_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Info about file submissions for assignments';

--
-- Dumping data for table `mdl0i_assignsubmission_file`
--


--
-- Table structure for table `mdl0i_assignsubmission_onlinetext`
--

CREATE TABLE `mdl0i_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,
  `onlineformat` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl0i_assionli_ass_ix` (`assignment`),
  KEY `mdl0i_assionli_sub_ix` (`submission`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Info about onlinetext submission';

--
-- Dumping data for table `mdl0i_assignsubmission_onlinetext`
--


--
-- Table structure for table `mdl0i_auth_oauth2_linked_login`
--

CREATE TABLE `mdl0i_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 `mdl0i_authoautlinklogi_use_uix` (`userid`,`issuerid`,`username`),
  KEY `mdl0i_authoautlinklogi_issu_ix` (`issuerid`,`username`),
  KEY `mdl0i_authoautlinklogi_use_ix` (`usermodified`),
  KEY `mdl0i_authoautlinklogi_use2_ix` (`userid`),
  KEY `mdl0i_authoautlinklogi_iss_ix` (`issuerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Accounts linked to a users Moodle account.';

--
-- Dumping data for table `mdl0i_auth_oauth2_linked_login`
--


--
-- Table structure for table `mdl0i_backup_controllers`
--

CREATE TABLE `mdl0i_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,
  `controller` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl0i_backcont_bac_uix` (`backupid`),
  KEY `mdl0i_backcont_typite_ix` (`type`,`itemid`),
  KEY `mdl0i_backcont_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='To store the backup_controllers as they are used';

--
-- Dumping data for table `mdl0i_backup_controllers`
--

INSERT INTO `mdl0i_backup_controllers` VALUES (1,'8df1cb4820cb7e90531420f73e7b3915','backup','activity',5,'moodle2',0,10,2,1000,1,0,'7d6129ccef9a0e72fc5bb06d4a6fbef1',1538696478,1538696479,''),(2,'0acc7250e7d46572d348aa303749be51','backup','course',2,'moodle2',1,10,2,1000,1,0,'923f5e17a4bfc3147db2674d5b4e2606',1538748021,1538748056,''),(3,'41c964b8d7ad88cc570399b7df2955fe','backup','course',2,'moodle2',0,10,2,1000,1,0,'4addc1d97ad184770a88a8cbe15aab63',1539210278,1539210333,''),(4,'9bf029146cf0b5ccd2bed2abc556fb55','backup','course',6,'moodle2',0,10,2,1000,1,0,'5bbc93d7f3b290bee78b594b2486dfcd',1543966857,1543966900,'');

--
-- Table structure for table `mdl0i_backup_courses`
--

CREATE TABLE `mdl0i_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 `mdl0i_backcour_cou_uix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='To store every course backup status';

--
-- Dumping data for table `mdl0i_backup_courses`
--


--
-- Table structure for table `mdl0i_backup_logs`
--

CREATE TABLE `mdl0i_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 `mdl0i_backlogs_bacid_uix` (`backupid`,`id`),
  KEY `mdl0i_backlogs_bac_ix` (`backupid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='To store all the logs from backup and restore operations (by';

--
-- Dumping data for table `mdl0i_backup_logs`
--


--
-- Table structure for table `mdl0i_badge`
--

CREATE TABLE `mdl0i_badge` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` longtext,
  `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,
  PRIMARY KEY (`id`),
  KEY `mdl0i_badg_typ_ix` (`type`),
  KEY `mdl0i_badg_cou_ix` (`courseid`),
  KEY `mdl0i_badg_use_ix` (`usermodified`),
  KEY `mdl0i_badg_use2_ix` (`usercreated`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Defines badge';

--
-- Dumping data for table `mdl0i_badge`
--

INSERT INTO `mdl0i_badge` VALUES (1,'¡Baby Learner!','¡Felicidades! te has convertido en un baby learner. Sigue avanzando en tu aprendizaje y obtendrás más insignias.',1538748468,1538749358,2,2,'Digital Learning Hub','https://dlhplataforma.com','bechegaray@dlh.com.pe',NULL,NULL,1,NULL,'<p> ¡Se le ha otorgado una insignia \"%badgename%\"!</p>\n<p> Puede encontrar más información sobre esta insignia en la %badgelink% página de información de insignias. </p>\n<p> Puede gestionar y descargar la insignia desde <a href=\"https://dlhplataforma.com/plataforma/badges/mybadges.php\">Gestionar insignias</a>. </p>','¡Felicitaciones, acaba de ganar una insignia!',1,0,1,NULL),(2,'Baby Learner','¡Felicidades! ahora eres un Baby Learner. Sigue avanzando en tus estudios y obtendrás nuevas insignias.',1538750455,1538750902,2,2,'Digital Learning Hub','https://dlhplataforma.com','bechegaray@dlh.com.pe',NULL,NULL,1,NULL,'<p>¡Se le ha otorgado una insignia \"%badgename%\"!</p>\r\n<p>Puede encontrar más información sobre esta insignia en la %badgelink% página de información de insignias.</p>\r\n<p>Puede gestionar y descargar la insignia desde <a href=\"https://dlhplataforma.com/plataforma/badges/mybadges.php\">Gestionar insignias</a>.</p>','¡Felicitaciones, acaba de ganar una insignia!',1,1,4,NULL);

--
-- Table structure for table `mdl0i_badge_backpack`
--

CREATE TABLE `mdl0i_badge_backpack` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `email` varchar(100) NOT NULL DEFAULT '',
  `backpackurl` varchar(255) NOT NULL DEFAULT '',
  `backpackuid` bigint(10) NOT NULL,
  `autosync` tinyint(1) NOT NULL DEFAULT '0',
  `password` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_badgback_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines settings for connecting external backpack';

--
-- Dumping data for table `mdl0i_badge_backpack`
--


--
-- Table structure for table `mdl0i_badge_criteria`
--

CREATE TABLE `mdl0i_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,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl0i_badgcrit_badcri_uix` (`badgeid`,`criteriatype`),
  KEY `mdl0i_badgcrit_cri_ix` (`criteriatype`),
  KEY `mdl0i_badgcrit_bad_ix` (`badgeid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Defines criteria for issuing badges';

--
-- Dumping data for table `mdl0i_badge_criteria`
--

INSERT INTO `mdl0i_badge_criteria` VALUES (1,1,0,1,'',1),(2,1,5,2,'¡Felicidades!',0),(3,2,0,1,'',1),(6,2,1,2,'',1);

--
-- Table structure for table `mdl0i_badge_criteria_met`
--

CREATE TABLE `mdl0i_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 `mdl0i_badgcritmet_cri_ix` (`critid`),
  KEY `mdl0i_badgcritmet_use_ix` (`userid`),
  KEY `mdl0i_badgcritmet_iss_ix` (`issuedid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Defines criteria that were met for an issued badge';

--
-- Dumping data for table `mdl0i_badge_criteria_met`
--

INSERT INTO `mdl0i_badge_criteria_met` VALUES (2,1,6,4,1538750708),(3,1,3,4,1538750708),(4,2,6,5,1538751550),(5,2,3,5,1538751550),(6,3,6,8,1538779114),(7,3,3,8,1538779114),(8,4,6,9,1539014513),(9,4,3,9,1539014514);

--
-- Table structure for table `mdl0i_badge_criteria_param`
--

CREATE TABLE `mdl0i_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 `mdl0i_badgcritpara_cri_ix` (`critid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Defines parameters for badges criteria';

--
-- Dumping data for table `mdl0i_badge_criteria_param`
--

INSERT INTO `mdl0i_badge_criteria_param` VALUES (1,2,'course_2','2'),(4,6,'module_4','4');

--
-- Table structure for table `mdl0i_badge_external`
--

CREATE TABLE `mdl0i_badge_external` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `backpackid` bigint(10) NOT NULL,
  `collectionid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_badgexte_bac_ix` (`backpackid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Setting for external badges display';

--
-- Dumping data for table `mdl0i_badge_external`
--


--
-- Table structure for table `mdl0i_badge_issued`
--

CREATE TABLE `mdl0i_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 `mdl0i_badgissu_baduse_uix` (`badgeid`,`userid`),
  KEY `mdl0i_badgissu_bad_ix` (`badgeid`),
  KEY `mdl0i_badgissu_use_ix` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Defines issued badges';

--
-- Dumping data for table `mdl0i_badge_issued`
--

INSERT INTO `mdl0i_badge_issued` VALUES (1,2,4,'308f7d900507381fcc761b402328b5038f4a96c5',1538750708,NULL,1,NULL),(2,2,5,'beaa33afcbef6f83cd368086723afbd83a2c64a0',1538751550,NULL,1,1538751551),(3,2,8,'1b7ed1e76d3dc3277b2d44ef881d6f165250e20a',1538779114,NULL,1,1538779114),(4,2,9,'0c0cd33e0115fa4b0585920f38399fff1717dfa0',1539014514,NULL,1,1539014514);

--
-- Table structure for table `mdl0i_badge_manual_award`
--

CREATE TABLE `mdl0i_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 `mdl0i_badgmanuawar_bad_ix` (`badgeid`),
  KEY `mdl0i_badgmanuawar_rec_ix` (`recipientid`),
  KEY `mdl0i_badgmanuawar_iss_ix` (`issuerid`),
  KEY `mdl0i_badgmanuawar_iss2_ix` (`issuerrole`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Track manual award criteria for badges';

--
-- Dumping data for table `mdl0i_badge_manual_award`
--


--
-- Table structure for table `mdl0i_block`
--

CREATE TABLE `mdl0i_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 `mdl0i_bloc_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='contains all installed blocks';

--
-- Dumping data for table `mdl0i_block`
--

INSERT INTO `mdl0i_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,'community',0,0,1),(12,'completionstatus',0,0,1),(13,'course_list',0,0,1),(14,'course_summary',0,0,1),(15,'feedback',0,0,1),(16,'globalsearch',0,0,1),(17,'glossary_random',0,0,1),(18,'html',0,0,1),(19,'login',0,0,1),(20,'lp',0,0,1),(21,'mentees',0,0,1),(22,'mnet_hosts',0,0,1),(23,'myoverview',0,0,1),(24,'myprofile',0,0,1),(25,'navigation',0,0,1),(26,'news_items',0,0,1),(27,'online_users',0,0,1),(28,'participants',0,0,1),(29,'private_files',0,0,1),(30,'quiz_results',0,0,0),(31,'recent_activity',86400,0,1),(32,'rss_client',300,1538700084,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,'tag_flickr',0,0,1),(40,'tag_youtube',0,0,0),(41,'tags',0,0,1),(42,'helpdesk',0,0,1),(43,'messages',0,0,1);

--
-- Table structure for table `mdl0i_block_community`
--

CREATE TABLE `mdl0i_block_community` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `coursename` varchar(255) NOT NULL DEFAULT '',
  `coursedescription` longtext,
  `courseurl` varchar(255) NOT NULL DEFAULT '',
  `imageurl` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Community block';

--
-- Dumping data for table `mdl0i_block_community`
--


--
-- Table structure for table `mdl0i_block_helpdesk_hd_user`
--

CREATE TABLE `mdl0i_block_helpdesk_hd_user` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(20) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_blochelphduser_use_ix` (`userid`),
  KEY `mdl0i_blochelphduser_ema_ix` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='Helpdesk user.';

--
-- Dumping data for table `mdl0i_block_helpdesk_hd_user`
--

INSERT INTO `mdl0i_block_helpdesk_hd_user` VALUES (1,2,NULL,NULL,NULL,NULL),(2,9,NULL,NULL,NULL,NULL),(3,10,NULL,NULL,NULL,NULL),(4,8,NULL,NULL,NULL,NULL),(5,1,NULL,NULL,NULL,NULL),(6,7,NULL,NULL,NULL,NULL),(7,6,NULL,NULL,NULL,NULL);

--
-- Table structure for table `mdl0i_block_helpdesk_status`
--

CREATE TABLE `mdl0i_block_helpdesk_status` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `displayname` varchar(255) DEFAULT NULL,
  `core` tinyint(1) DEFAULT NULL,
  `whohasball` bigint(20) DEFAULT NULL,
  `ticketdefault` tinyint(1) DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='Ticket status table, where core and additional statuses are ';

--
-- Dumping data for table `mdl0i_block_helpdesk_status`
--

INSERT INTO `mdl0i_block_helpdesk_status` VALUES (1,'new',NULL,1,NULL,1,1),(2,'workinprogress',NULL,1,NULL,0,1),(3,'closed',NULL,1,NULL,0,0),(4,'resolved',NULL,1,NULL,0,0),(5,'reopened',NULL,1,NULL,0,1),(6,'needmoreinfo',NULL,1,NULL,0,1),(7,'infoprovided',NULL,1,NULL,0,1);

--
-- Table structure for table `mdl0i_block_helpdesk_status_path`
--

CREATE TABLE `mdl0i_block_helpdesk_status_path` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `fromstatusid` bigint(20) NOT NULL,
  `tostatusid` bigint(20) NOT NULL,
  `capabilityname` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='What statuses can change to and who can change them.';

--
-- Dumping data for table `mdl0i_block_helpdesk_status_path`
--

INSERT INTO `mdl0i_block_helpdesk_status_path` VALUES (1,1,2,'block/helpdesk:answer'),(2,1,6,'block/helpdesk:answer'),(3,1,4,'block/helpdesk:answer'),(4,1,3,'block/helpdesk:answer'),(5,1,2,'block/helpdesk:ask'),(6,1,3,'block/helpdesk:ask'),(7,2,6,'block/helpdesk:answer'),(8,2,3,'block/helpdesk:answer'),(9,2,4,'block/helpdesk:answer'),(10,2,3,'block/helpdesk:ask'),(11,6,7,'block/helpdesk:answer'),(12,6,2,'block/helpdesk:answer'),(13,6,3,'block/helpdesk:answer'),(14,6,7,'block/helpdesk:ask'),(15,6,3,'block/helpdesk:ask'),(16,7,2,'block/helpdesk:answer'),(17,7,6,'block/helpdesk:answer'),(18,7,3,'block/helpdesk:answer'),(19,7,4,'block/helpdesk:answer'),(20,7,3,'block/helpdesk:answer'),(21,3,5,'block/helpdesk:answer'),(22,3,5,'block/helpdesk:ask'),(23,4,5,'block/helpdesk:answer'),(24,4,5,'block/helpdesk:ask'),(25,5,2,'block/helpdesk:answer'),(26,5,6,'block/helpdesk:answer'),(27,5,3,'block/helpdesk:answer'),(28,5,4,'block/helpdesk:answer'),(29,5,3,'block/helpdesk:ask');

--
-- Table structure for table `mdl0i_block_helpdesk_ticket`
--

CREATE TABLE `mdl0i_block_helpdesk_ticket` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `summary` longtext NOT NULL,
  `detail` longtext NOT NULL,
  `detailformat` tinyint(2) NOT NULL DEFAULT '1',
  `timecreated` bigint(20) NOT NULL,
  `timemodified` bigint(20) NOT NULL,
  `hd_userid` bigint(20) NOT NULL,
  `assigned_refs` tinyint(2) NOT NULL,
  `firstcontact` bigint(20) DEFAULT NULL,
  `groupid` bigint(20) DEFAULT NULL,
  `status` bigint(20) NOT NULL,
  `createdby` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_blochelptick_hd__ix` (`hd_userid`),
  KEY `mdl0i_blochelptick_fir_ix` (`firstcontact`),
  KEY `mdl0i_blochelptick_sta_ix` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This is the ticket table for the Help Desk block.';

--
-- Dumping data for table `mdl0i_block_helpdesk_ticket`
--


--
-- Table structure for table `mdl0i_block_helpdesk_ticket_assign`
--

CREATE TABLE `mdl0i_block_helpdesk_ticket_assign` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userid` bigint(20) NOT NULL,
  `ticketid` bigint(20) NOT NULL,
  `iswatcher` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_blochelptickassi_tic_ix` (`ticketid`),
  KEY `mdl0i_blochelptickassi_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Assignment relations to relate a user with id to be related ';

--
-- Dumping data for table `mdl0i_block_helpdesk_ticket_assign`
--


--
-- Table structure for table `mdl0i_block_helpdesk_ticket_tag`
--

CREATE TABLE `mdl0i_block_helpdesk_ticket_tag` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  `valueformat` tinyint(2) NOT NULL DEFAULT '1',
  `ticketid` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_blochelpticktag_tic_ix` (`ticketid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A table that holds individual custom tags per ticket.';

--
-- Dumping data for table `mdl0i_block_helpdesk_ticket_tag`
--


--
-- Table structure for table `mdl0i_block_helpdesk_ticket_update`
--

CREATE TABLE `mdl0i_block_helpdesk_ticket_update` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `ticketid` bigint(20) NOT NULL,
  `notes` longtext NOT NULL,
  `notesformat` tinyint(2) NOT NULL DEFAULT '1',
  `hd_userid` bigint(20) NOT NULL,
  `status` varchar(128) NOT NULL DEFAULT '',
  `newticketstatus` bigint(20) DEFAULT NULL,
  `type` longtext NOT NULL,
  `hidden` tinyint(1) DEFAULT '0',
  `timecreated` bigint(20) NOT NULL,
  `timemodified` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_blochelptickupda_tic_ix` (`ticketid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Every time a ticket is updated with a new status, it gets pu';

--
-- Dumping data for table `mdl0i_block_helpdesk_ticket_update`
--


--
-- Table structure for table `mdl0i_block_helpdesk_watcher`
--

CREATE TABLE `mdl0i_block_helpdesk_watcher` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `ticketid` bigint(20) NOT NULL,
  `hd_userid` bigint(20) NOT NULL,
  `token` varchar(255) DEFAULT NULL,
  `token_last_issued` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl0i_blochelpwatc_tichd__uix` (`ticketid`,`hd_userid`),
  KEY `mdl0i_blochelpwatc_tic_ix` (`ticketid`),
  KEY `mdl0i_blochelpwatc_hd__ix` (`hd_userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Default comment for the table, please edit me';

--
-- Dumping data for table `mdl0i_block_helpdesk_watcher`
--


--
-- Table structure for table `mdl0i_block_instances`
--

CREATE TABLE `mdl0i_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,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_blocinst_parshopagsub_ix` (`parentcontextid`,`showinsubcontexts`,`pagetypepattern`,`subpagepattern`),
  KEY `mdl0i_blocinst_tim_ix` (`timemodified`),
  KEY `mdl0i_blocinst_par_ix` (`parentcontextid`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='This table stores block instances. The type of block this is';

--
-- Dumping data for table `mdl0i_block_instances`
--

INSERT INTO `mdl0i_block_instances` VALUES (1,'admin_bookmarks',1,0,0,'admin-*',NULL,'side-pre',2,'',1538674447,1538674447),(2,'private_files',1,0,0,'my-index','2','side-post',0,'',1538674447,1538674447),(3,'online_users',1,0,0,'my-index','2','side-post',1,'',1538674447,1538674447),(4,'badges',1,0,0,'my-index','2','content',2,'',1538674447,1538751866),(5,'calendar_month',1,0,0,'my-index','2','side-post',3,'',1538674447,1538674447),(6,'calendar_upcoming',1,0,0,'my-index','2','side-post',4,'',1538674447,1538674447),(7,'lp',1,0,0,'my-index','2','content',-1,'',1538674447,1538751799),(8,'myoverview',1,1,0,'my-index','2','content',1,'Tzo4OiJzdGRDbGFzcyI6MDp7fQ==',1538674447,1539111146),(46,'html',1,0,0,'admin-setting-frontpagesettings',NULL,'side-pre',4,'',1538751943,1538751956),(55,'navigation',1,1,1,'*',NULL,'side-pre',0,'',1538772845,1538772845),(56,'settings',1,1,1,'*',NULL,'side-pre',0,'',1538772845,1538772845),(57,'course_list',1,0,0,'my-index','2','side-pre',5,'',1539111128,1539111128),(58,'helpdesk',1,0,0,'my-index','2','side-pre',5,'',1539129015,1539129015),(68,'private_files',5,0,0,'my-index','13','side-post',0,'',1539130321,1539130321),(69,'online_users',5,0,0,'my-index','13','side-post',1,'',1539130321,1539130321),(70,'badges',5,0,0,'my-index','13','content',2,'',1539130322,1539130322),(71,'calendar_month',5,0,0,'my-index','13','side-post',3,'',1539130322,1539130322),(72,'calendar_upcoming',5,0,0,'my-index','13','side-post',4,'',1539130322,1539130322),(73,'lp',5,0,0,'my-index','13','content',-1,'',1539130322,1539130322),(74,'myoverview',5,1,0,'my-index','13','content',1,'Tzo4OiJzdGRDbGFzcyI6MDp7fQ==',1539130322,1539130322),(75,'course_list',5,0,0,'my-index','13','side-pre',5,'',1539130322,1539130322),(76,'helpdesk',5,0,0,'my-index','13','side-pre',5,'',1539130322,1539130322);

--
-- Table structure for table `mdl0i_block_positions`
--

CREATE TABLE `mdl0i_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 `mdl0i_blocposi_bloconpagsu_uix` (`blockinstanceid`,`contextid`,`pagetype`,`subpage`),
  KEY `mdl0i_blocposi_blo_ix` (`blockinstanceid`),
  KEY `mdl0i_blocposi_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores the position of a sticky block_instance on a another ';

--
-- Dumping data for table `mdl0i_block_positions`
--


--
-- Table structure for table `mdl0i_block_recent_activity`
--

CREATE TABLE `mdl0i_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 `mdl0i_blocreceacti_coutim_ix` (`courseid`,`timecreated`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COMMENT='Recent activity block';

--
-- Dumping data for table `mdl0i_block_recent_activity`
--

INSERT INTO `mdl0i_block_recent_activity` VALUES (1,2,3,1538685510,2,0,NULL),(2,2,3,1538686188,2,1,NULL),(3,2,4,1538686585,2,0,NULL),(4,2,5,1538694227,2,0,NULL),(5,2,6,1538695206,2,0,NULL),(6,2,6,1538695391,2,1,NULL),(7,2,6,1538695632,2,1,NULL),(8,2,6,1538695680,2,1,NULL),(9,2,6,1538696222,2,1,NULL),(10,2,6,1538696459,2,1,NULL),(11,2,5,1538696479,2,2,'customcert'),(12,2,6,1538696684,2,1,NULL),(13,2,6,1538697027,2,1,NULL),(14,2,6,1538697072,2,1,NULL),(15,2,6,1538697120,2,1,NULL),(16,2,6,1538697400,2,1,NULL),(17,2,4,1538700912,2,1,NULL),(18,2,4,1538700932,2,1,NULL),(19,2,7,1538701223,2,0,NULL),(20,2,7,1538701245,2,1,NULL),(21,2,6,1538701302,2,1,NULL),(22,2,6,1538701331,2,1,NULL),(23,2,6,1538701396,2,1,NULL),(24,2,6,1538701426,2,1,NULL),(25,2,6,1538701476,2,1,NULL),(26,2,6,1538701535,2,1,NULL),(27,2,8,1538701951,2,0,NULL),(28,2,6,1538705502,2,1,NULL),(29,2,6,1538705567,2,1,NULL),(30,2,6,1538705622,2,1,NULL),(31,2,6,1538705684,2,1,NULL),(32,2,6,1538705722,2,1,NULL),(33,2,6,1538705755,2,1,NULL),(34,2,6,1538705789,2,1,NULL),(35,2,6,1538705818,2,1,NULL),(36,2,6,1538706849,2,1,NULL),(37,2,6,1538707009,2,1,NULL),(38,2,7,1538749188,2,1,NULL),(39,2,6,1538749215,2,1,NULL),(40,2,4,1538755728,2,1,NULL),(41,2,9,1539013925,2,0,NULL),(42,2,9,1539014204,2,1,NULL),(43,2,6,1539014232,2,1,NULL),(44,2,3,1539014339,2,1,NULL),(45,2,9,1539037300,2,1,NULL),(46,2,11,1539177791,2,0,NULL),(47,2,12,1539177921,2,0,NULL),(48,5,15,1539804883,12,0,NULL),(49,4,16,1539804935,12,0,NULL),(50,6,18,1542821642,2,0,NULL),(51,6,18,1542821730,2,1,NULL),(52,7,21,1543967180,2,0,NULL),(53,7,21,1543967831,2,1,NULL),(54,7,21,1544024202,2,1,NULL);

--
-- Table structure for table `mdl0i_block_rss_client`
--

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

--
-- Dumping data for table `mdl0i_block_rss_client`
--


--
-- Table structure for table `mdl0i_blog_association`
--

CREATE TABLE `mdl0i_blog_association` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `blogid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_blogasso_con_ix` (`contextid`),
  KEY `mdl0i_blogasso_blo_ix` (`blogid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Associations of blog entries with courses and module instanc';

--
-- Dumping data for table `mdl0i_blog_association`
--


--
-- Table structure for table `mdl0i_blog_external`
--

CREATE TABLE `mdl0i_blog_external` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` longtext,
  `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 `mdl0i_blogexte_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='External blog links used for RSS copying of blog entries to ';

--
-- Dumping data for table `mdl0i_blog_external`
--


--
-- Table structure for table `mdl0i_book`
--

CREATE TABLE `mdl0i_book` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext,
  `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=utf8 COMMENT='Defines book';

--
-- Dumping data for table `mdl0i_book`
--


--
-- Table structure for table `mdl0i_book_chapters`
--

CREATE TABLE `mdl0i_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Defines book_chapters';

--
-- Dumping data for table `mdl0i_book_chapters`
--


--
-- Table structure for table `mdl0i_cache_filters`
--

CREATE TABLE `mdl0i_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 `mdl0i_cachfilt_filmd5_ix` (`filter`,`md5key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='For keeping information about cached data';

--
-- Dumping data for table `mdl0i_cache_filters`
--


--
-- Table structure for table `mdl0i_cache_flags`
--

CREATE TABLE `mdl0i_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 `mdl0i_cachflag_fla_ix` (`flagtype`),
  KEY `mdl0i_cachflag_nam_ix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1515 DEFAULT CHARSET=utf8 COMMENT='Cache of time-sensitive flags';

--
-- Dumping data for table `mdl0i_cache_flags`
--

INSERT INTO `mdl0i_cache_flags` VALUES (2,'userpreferenceschanged','2',1544044784,'1',1544051984),(5,'userpreferenceschanged','3',1538749378,'1',1538756578),(6,'accesslib/dirtycontexts','/1/3/22/34',1538696479,'1',1538703679),(7,'accesslib/dirtycontexts','/1/3/22',1539111416,'1',1539118616),(8,'accesslib/dirtycontexts','/1/26/27',1538750092,'1',1538757292),(9,'accesslib/dirtycontexts','/1/26/28',1538750092,'1',1538757292),(10,'accesslib/dirtycontexts','/1/26/29',1538750092,'1',1538757292),(11,'accesslib/dirtycontexts','/1/26/30',1538750092,'1',1538757292),(12,'accesslib/dirtycontexts','/1/26/31',1538750092,'1',1538757292),(13,'accesslib/dirtycontexts','/1/26/32',1538750092,'1',1538757292),(14,'accesslib/dirtycontexts','/1/26/33',1538750092,'1',1538757292),(15,'accesslib/dirtycontexts','/1/26',1538750092,'1',1538757292),(16,'userpreferenceschanged','4',1538750211,'1',1538757411),(17,'accesslib/dirtycontexts','/1/38/39',1538751452,'1',1538758652),(18,'accesslib/dirtycontexts','/1/38/40',1538751452,'1',1538758652),(19,'accesslib/dirtycontexts','/1/38/41',1538751452,'1',1538758652),(20,'accesslib/dirtycontexts','/1/38/42',1538751452,'1',1538758652),(21,'accesslib/dirtycontexts','/1/38/43',1538751452,'1',1538758652),(22,'accesslib/dirtycontexts','/1/38/44',1538751453,'1',1538758653),(23,'accesslib/dirtycontexts','/1/38/45',1538751453,'1',1538758653),(24,'accesslib/dirtycontexts','/1/38',1538751453,'1',1538758653),(25,'userpreferenceschanged','5',1538753065,'1',1538760265),(26,'accesslib/dirtycontexts','/1/5/14',1538751893,'1',1538759093),(27,'accesslib/dirtycontexts','/1/5/15',1538751893,'1',1538759093),(28,'accesslib/dirtycontexts','/1/5/16',1538751893,'1',1538759093),(29,'accesslib/dirtycontexts','/1/5/17',1538751893,'1',1538759093),(30,'accesslib/dirtycontexts','/1/5/18',1538751893,'1',1538759093),(31,'accesslib/dirtycontexts','/1/5/19',1538751893,'1',1538759093),(32,'accesslib/dirtycontexts','/1/5/20',1538751893,'1',1538759093),(33,'accesslib/dirtycontexts','/1/46/47',1538751893,'1',1538759093),(34,'accesslib/dirtycontexts','/1/46/48',1538751893,'1',1538759093),(35,'accesslib/dirtycontexts','/1/46/49',1538751893,'1',1538759093),(36,'accesslib/dirtycontexts','/1/46/50',1538751893,'1',1538759093),(37,'accesslib/dirtycontexts','/1/46/51',1538751893,'1',1538759093),(38,'accesslib/dirtycontexts','/1/46/52',1538751893,'1',1538759093),(39,'accesslib/dirtycontexts','/1/46/53',1538751893,'1',1538759093),(40,'userpreferenceschanged','6',1538768017,'1',1538775217),(41,'accesslib/dirtycontexts','/1/46/55',1538755593,'1',1538762793),(42,'accesslib/dirtycontexts','/1/46/56',1538755593,'1',1538762793),(43,'accesslib/dirtycontexts','/1/46/57',1538755593,'1',1538762793),(44,'accesslib/dirtycontexts','/1/46/58',1538755593,'1',1538762793),(45,'accesslib/dirtycontexts','/1/46/59',1538755593,'1',1538762793),(46,'accesslib/dirtycontexts','/1/46/60',1538755593,'1',1538762793),(47,'accesslib/dirtycontexts','/1/46/61',1538755593,'1',1538762793),(48,'accesslib/dirtycontexts','/1/46/62',1538755593,'1',1538762793),(49,'accesslib/dirtycontexts','/1/46',1538755593,'1',1538762793),(50,'userpreferenceschanged','7',1538772331,'1',1538779531),(51,'userpreferenceschanged','8',1539705545,'1',1539712745),(52,'userpreferenceschanged','9',1539014479,'1',1539021679),(53,'userpreferenceschanged','10',1539037228,'1',1539044428),(54,'accesslib/dirtycontexts','/1/80',1539109578,'1',1539116778),(55,'accesslib/dirtycontexts','/1/80/81',1539111020,'1',1539118220),(56,'accesslib/dirtycontexts','/1/54',1539111121,'1',1539118321),(57,'accesslib/dirtycontexts','/1/3/83',1539111352,'1',1539118552),(58,'accesslib/dirtycontexts','/1/84',1539111333,'1',1539118533),(59,'accesslib/dirtycontexts','/1/85',1539111378,'1',1539118578),(60,'accesslib/dirtycontexts','/1/3/86',1543967018,'1',1543974218),(61,'accesslib/dirtycontexts','/1/3/86/22',1539210335,'1',1539217535),(62,'accesslib/dirtycontexts','/1/5/67',1539129021,'1',1539136221),(63,'accesslib/dirtycontexts','/1/5/68',1539129021,'1',1539136221),(64,'accesslib/dirtycontexts','/1/5/69',1539129021,'1',1539136221),(65,'accesslib/dirtycontexts','/1/5/70',1539129021,'1',1539136221),(66,'accesslib/dirtycontexts','/1/5/71',1539129021,'1',1539136221),(67,'accesslib/dirtycontexts','/1/5/72',1539129021,'1',1539136221),(68,'accesslib/dirtycontexts','/1/5/73',1539129021,'1',1539136221),(69,'accesslib/dirtycontexts','/1/5/74',1539129021,'1',1539136221),(70,'userpreferenceschanged','11',1539129140,'1',1539136340),(71,'accesslib/dirtycontexts','/1/3/86/22/23',1539210334,'1',1539217534),(72,'accesslib/dirtycontexts','/1/3/86/22/24',1539210334,'1',1539217534),(73,'accesslib/dirtycontexts','/1/3/86/22/77',1539210334,'1',1539217534),(74,'accesslib/dirtycontexts','/1/3/86/22/25',1539210335,'1',1539217535),(75,'accesslib/dirtycontexts','/1/3/86/22/107',1539210335,'1',1539217535),(76,'accesslib/dirtycontexts','/1/3/86/22/108',1539210335,'1',1539217535),(77,'accesslib/dirtycontexts','/1/3/86/22/36',1539210335,'1',1539217535),(78,'accesslib/dirtycontexts','/1/3/86/22/35',1539210335,'1',1539217535),(79,'accesslib/dirtycontexts','/1/3/86/22/37',1539210335,'1',1539217535),(80,'userpreferenceschanged','12',1539804192,'1',1539811392),(81,'accesslib/dirtycontexts','/1/110',1539634420,'1',1539641620),(82,'accesslib/dirtycontexts','/1/110/111',1543895711,'1',1543902911),(83,'accesslib/dirtycontexts','/1/110/121',1543895216,'1',1543902416),(84,'accesslib/dirtycontexts','/1/109/113',1542816514,'1',1542823714),(85,'accesslib/dirtycontexts','/1/109/114',1542816514,'1',1542823714),(86,'accesslib/dirtycontexts','/1/109/115',1542816514,'1',1542823714),(87,'accesslib/dirtycontexts','/1/109/116',1542816514,'1',1542823714),(88,'accesslib/dirtycontexts','/1/109/117',1542816514,'1',1542823714),(89,'accesslib/dirtycontexts','/1/109/118',1542816514,'1',1542823714),(90,'accesslib/dirtycontexts','/1/109/119',1542816514,'1',1542823714),(91,'accesslib/dirtycontexts','/1/109/120',1542816515,'1',1542823715),(92,'accesslib/dirtycontexts','/1/109',1542816515,'1',1542823715),(93,'accesslib/dirtycontexts','/1/3/133',1543966902,'1',1543974102),(94,'accesslib/dirtycontexts','/1/64',1542824626,'1',1542831826),(95,'accesslib/dirtycontexts','/1/88/89',1542824633,'1',1542831833),(96,'accesslib/dirtycontexts','/1/88/90',1542824633,'1',1542831833),(97,'accesslib/dirtycontexts','/1/88/91',1542824633,'1',1542831833),(98,'accesslib/dirtycontexts','/1/88/92',1542824633,'1',1542831833),(99,'accesslib/dirtycontexts','/1/88/93',1542824633,'1',1542831833),(100,'accesslib/dirtycontexts','/1/88/94',1542824633,'1',1542831833),(101,'accesslib/dirtycontexts','/1/88/96',1542824633,'1',1542831833),(102,'accesslib/dirtycontexts','/1/88/97',1542824633,'1',1542831833),(103,'accesslib/dirtycontexts','/1/88/95',1542824633,'1',1542831833),(104,'accesslib/dirtycontexts','/1/88',1542824633,'1',1542831833),(105,'accesslib/dirtycontexts','/1/65',1542824641,'1',1542831841),(106,'accesslib/dirtycontexts','/1/66/123',1542824689,'1',1542831889),(107,'accesslib/dirtycontexts','/1/66/124',1542824689,'1',1542831889),(108,'accesslib/dirtycontexts','/1/66/125',1542824689,'1',1542831889),(109,'accesslib/dirtycontexts','/1/66/126',1542824689,'1',1542831889),(110,'accesslib/dirtycontexts','/1/66/127',1542824689,'1',1542831889),(111,'accesslib/dirtycontexts','/1/66/128',1542824689,'1',1542831889),(112,'accesslib/dirtycontexts','/1/66/129',1542824689,'1',1542831889),(113,'accesslib/dirtycontexts','/1/66/130',1542824689,'1',1542831889),(114,'accesslib/dirtycontexts','/1/66',1542824689,'1',1542831889),(115,'accesslib/dirtycontexts','/1/79',1542824698,'1',1542831898),(116,'accesslib/dirtycontexts','/1/78',1542824730,'1',1542831930),(117,'userpreferenceschanged','13',1543894511,'1',1543901711),(118,'userpreferenceschanged','14',1543894511,'1',1543901711),(119,'userpreferenceschanged','15',1543894511,'1',1543901711),(120,'userpreferenceschanged','16',1543894511,'1',1543901711),(121,'userpreferenceschanged','17',1543894511,'1',1543901711),(122,'userpreferenceschanged','18',1543894511,'1',1543901711),(123,'userpreferenceschanged','19',1543894511,'1',1543901711),(124,'userpreferenceschanged','20',1543894511,'1',1543901711),(125,'userpreferenceschanged','21',1543894511,'1',1543901711),(126,'userpreferenceschanged','22',1543894511,'1',1543901711),(127,'userpreferenceschanged','23',1543894511,'1',1543901711),(128,'userpreferenceschanged','24',1543894511,'1',1543901711),(129,'userpreferenceschanged','25',1543894511,'1',1543901711),(130,'userpreferenceschanged','26',1543894512,'1',1543901712),(131,'userpreferenceschanged','27',1543894512,'1',1543901712),(132,'userpreferenceschanged','28',1543894512,'1',1543901712),(133,'userpreferenceschanged','29',1543894512,'1',1543901712),(134,'userpreferenceschanged','30',1543894512,'1',1543901712),(135,'userpreferenceschanged','31',1543894920,'1',1543902120),(136,'userpreferenceschanged','32',1543894512,'1',1543901712),(137,'userpreferenceschanged','33',1543894512,'1',1543901712),(138,'userpreferenceschanged','34',1543894512,'1',1543901712),(139,'userpreferenceschanged','35',1543894512,'1',1543901712),(140,'userpreferenceschanged','36',1543894512,'1',1543901712),(141,'userpreferenceschanged','37',1543894512,'1',1543901712),(142,'userpreferenceschanged','38',1543894935,'1',1543902135),(143,'userpreferenceschanged','39',1543894512,'1',1543901712),(144,'userpreferenceschanged','40',1543894512,'1',1543901712),(145,'userpreferenceschanged','41',1543894512,'1',1543901712),(146,'userpreferenceschanged','42',1543894512,'1',1543901712),(147,'userpreferenceschanged','43',1543894512,'1',1543901712),(148,'userpreferenceschanged','44',1543894512,'1',1543901712),(149,'userpreferenceschanged','45',1543894512,'1',1543901712),(150,'userpreferenceschanged','46',1543894512,'1',1543901712),(151,'userpreferenceschanged','47',1543894512,'1',1543901712),(152,'userpreferenceschanged','48',1543894512,'1',1543901712),(153,'userpreferenceschanged','49',1543894512,'1',1543901712),(154,'userpreferenceschanged','50',1543894512,'1',1543901712),(155,'userpreferenceschanged','51',1543894512,'1',1543901712),(156,'userpreferenceschanged','52',1543894512,'1',1543901712),(157,'userpreferenceschanged','53',1543894512,'1',1543901712),(158,'userpreferenceschanged','54',1543894513,'1',1543901713),(159,'userpreferenceschanged','55',1543894513,'1',1543901713),(160,'userpreferenceschanged','56',1543894513,'1',1543901713),(161,'userpreferenceschanged','57',1543894513,'1',1543901713),(162,'userpreferenceschanged','58',1543894513,'1',1543901713),(163,'userpreferenceschanged','59',1543894513,'1',1543901713),(164,'userpreferenceschanged','60',1543894513,'1',1543901713),(165,'userpreferenceschanged','61',1543894513,'1',1543901713),(166,'userpreferenceschanged','62',1543894513,'1',1543901713),(167,'userpreferenceschanged','63',1543894513,'1',1543901713),(168,'userpreferenceschanged','64',1543894513,'1',1543901713),(169,'userpreferenceschanged','65',1543894513,'1',1543901713),(170,'userpreferenceschanged','66',1543894513,'1',1543901713),(171,'userpreferenceschanged','67',1543894513,'1',1543901713),(172,'userpreferenceschanged','68',1543894513,'1',1543901713),(173,'userpreferenceschanged','69',1543894513,'1',1543901713),(174,'userpreferenceschanged','70',1543894513,'1',1543901713),(175,'userpreferenceschanged','71',1543894513,'1',1543901713),(176,'userpreferenceschanged','72',1543894513,'1',1543901713),(177,'userpreferenceschanged','73',1543894513,'1',1543901713),(178,'userpreferenceschanged','74',1543894513,'1',1543901713),(179,'userpreferenceschanged','75',1543894513,'1',1543901713),(180,'userpreferenceschanged','76',1543894513,'1',1543901713),(181,'userpreferenceschanged','77',1543894513,'1',1543901713),(182,'userpreferenceschanged','78',1543894513,'1',1543901713),(183,'userpreferenceschanged','79',1543894513,'1',1543901713),(184,'userpreferenceschanged','80',1543894513,'1',1543901713),(185,'userpreferenceschanged','81',1543894513,'1',1543901713),(186,'userpreferenceschanged','82',1543894513,'1',1543901713),(187,'userpreferenceschanged','83',1543894513,'1',1543901713),(188,'userpreferenceschanged','84',1543894514,'1',1543901714),(189,'userpreferenceschanged','85',1543894514,'1',1543901714),(190,'userpreferenceschanged','86',1543894514,'1',1543901714),(191,'userpreferenceschanged','87',1543894514,'1',1543901714),(192,'userpreferenceschanged','88',1543894514,'1',1543901714),(193,'userpreferenceschanged','89',1543894514,'1',1543901714),(194,'userpreferenceschanged','90',1543894514,'1',1543901714),(195,'userpreferenceschanged','91',1543894514,'1',1543901714),(196,'userpreferenceschanged','92',1543894514,'1',1543901714),(197,'userpreferenceschanged','93',1543894514,'1',1543901714),(198,'userpreferenceschanged','94',1543894514,'1',1543901714),(199,'userpreferenceschanged','95',1543894514,'1',1543901714),(200,'userpreferenceschanged','96',1543894514,'1',1543901714),(201,'userpreferenceschanged','97',1543894514,'1',1543901714),(202,'userpreferenceschanged','98',1543894514,'1',1543901714),(203,'userpreferenceschanged','99',1543894514,'1',1543901714),(204,'userpreferenceschanged','100',1543894514,'1',1543901714),(205,'userpreferenceschanged','101',1543894514,'1',1543901714),(206,'userpreferenceschanged','102',1543894514,'1',1543901714),(207,'userpreferenceschanged','103',1543894514,'1',1543901714),(208,'userpreferenceschanged','104',1543894514,'1',1543901714),(209,'userpreferenceschanged','105',1543894514,'1',1543901714),(210,'userpreferenceschanged','106',1543894514,'1',1543901714),(211,'userpreferenceschanged','107',1543894514,'1',1543901714),(212,'userpreferenceschanged','108',1543894514,'1',1543901714),(213,'userpreferenceschanged','109',1543894514,'1',1543901714),(214,'userpreferenceschanged','110',1543894514,'1',1543901714),(215,'userpreferenceschanged','111',1543894514,'1',1543901714),(216,'userpreferenceschanged','112',1543894514,'1',1543901714),(217,'userpreferenceschanged','113',1543894515,'1',1543901715),(218,'userpreferenceschanged','114',1543894515,'1',1543901715),(219,'userpreferenceschanged','115',1543894515,'1',1543901715),(220,'userpreferenceschanged','116',1543894515,'1',1543901715),(221,'userpreferenceschanged','117',1543894515,'1',1543901715),(222,'userpreferenceschanged','118',1543894515,'1',1543901715),(223,'userpreferenceschanged','119',1543894515,'1',1543901715),(224,'userpreferenceschanged','120',1543894515,'1',1543901715),(225,'userpreferenceschanged','121',1543894515,'1',1543901715),(226,'userpreferenceschanged','122',1543894515,'1',1543901715),(227,'userpreferenceschanged','123',1543894515,'1',1543901715),(228,'userpreferenceschanged','124',1543894515,'1',1543901715),(229,'userpreferenceschanged','125',1543894515,'1',1543901715),(230,'userpreferenceschanged','126',1543894515,'1',1543901715),(231,'userpreferenceschanged','127',1543894515,'1',1543901715),(232,'userpreferenceschanged','128',1543894515,'1',1543901715),(233,'userpreferenceschanged','129',1543894515,'1',1543901715),(234,'userpreferenceschanged','130',1543894515,'1',1543901715),(235,'userpreferenceschanged','131',1543894515,'1',1543901715),(236,'userpreferenceschanged','132',1543894515,'1',1543901715),(237,'userpreferenceschanged','133',1543894515,'1',1543901715),(238,'userpreferenceschanged','134',1543894516,'1',1543901716),(239,'userpreferenceschanged','135',1543894516,'1',1543901716),(240,'userpreferenceschanged','136',1543894516,'1',1543901716),(241,'userpreferenceschanged','137',1543894516,'1',1543901716),(242,'userpreferenceschanged','138',1543894516,'1',1543901716),(243,'userpreferenceschanged','139',1543894516,'1',1543901716),(244,'userpreferenceschanged','140',1543894516,'1',1543901716),(245,'userpreferenceschanged','141',1543894516,'1',1543901716),(246,'userpreferenceschanged','142',1543894516,'1',1543901716),(247,'userpreferenceschanged','143',1543894516,'1',1543901716),(248,'userpreferenceschanged','144',1543894516,'1',1543901716),(249,'userpreferenceschanged','145',1543894516,'1',1543901716),(250,'userpreferenceschanged','146',1543894516,'1',1543901716),(251,'userpreferenceschanged','147',1543894516,'1',1543901716),(252,'userpreferenceschanged','148',1543894516,'1',1543901716),(253,'userpreferenceschanged','149',1543894516,'1',1543901716),(254,'userpreferenceschanged','150',1543894516,'1',1543901716),(255,'userpreferenceschanged','151',1543894516,'1',1543901716),(256,'userpreferenceschanged','152',1543894517,'1',1543901717),(257,'userpreferenceschanged','153',1543894517,'1',1543901717),(258,'userpreferenceschanged','154',1543894517,'1',1543901717),(259,'userpreferenceschanged','155',1543894517,'1',1543901717),(260,'userpreferenceschanged','156',1543894517,'1',1543901717),(261,'userpreferenceschanged','157',1543894517,'1',1543901717),(262,'userpreferenceschanged','158',1543894517,'1',1543901717),(263,'userpreferenceschanged','159',1543894517,'1',1543901717),(264,'userpreferenceschanged','160',1543894517,'1',1543901717),(265,'userpreferenceschanged','161',1543894517,'1',1543901717),(266,'userpreferenceschanged','162',1543894517,'1',1543901717),(267,'userpreferenceschanged','163',1543894517,'1',1543901717),(268,'userpreferenceschanged','164',1543894517,'1',1543901717),(269,'userpreferenceschanged','165',1543894517,'1',1543901717),(270,'userpreferenceschanged','166',1543894517,'1',1543901717),(271,'userpreferenceschanged','167',1543894517,'1',1543901717),(272,'userpreferenceschanged','168',1543894517,'1',1543901717),(273,'userpreferenceschanged','169',1543894517,'1',1543901717),(274,'userpreferenceschanged','170',1543894517,'1',1543901717),(275,'userpreferenceschanged','171',1543894517,'1',1543901717),(276,'userpreferenceschanged','172',1543894517,'1',1543901717),(277,'userpreferenceschanged','173',1543894517,'1',1543901717),(278,'userpreferenceschanged','174',1543894517,'1',1543901717),(279,'userpreferenceschanged','175',1543894517,'1',1543901717),(280,'userpreferenceschanged','176',1543894518,'1',1543901718),(281,'userpreferenceschanged','177',1543894518,'1',1543901718),(282,'userpreferenceschanged','178',1543894518,'1',1543901718),(283,'userpreferenceschanged','179',1543894518,'1',1543901718),(284,'userpreferenceschanged','180',1543894518,'1',1543901718),(285,'userpreferenceschanged','181',1543894518,'1',1543901718),(286,'userpreferenceschanged','182',1543894518,'1',1543901718),(287,'userpreferenceschanged','183',1543894518,'1',1543901718),(288,'userpreferenceschanged','184',1543894518,'1',1543901718),(289,'userpreferenceschanged','185',1543894518,'1',1543901718),(290,'userpreferenceschanged','186',1543894518,'1',1543901718),(291,'userpreferenceschanged','187',1543894518,'1',1543901718),(292,'userpreferenceschanged','188',1543894518,'1',1543901718),(293,'userpreferenceschanged','189',1543894518,'1',1543901718),(294,'userpreferenceschanged','190',1543894518,'1',1543901718),(295,'userpreferenceschanged','191',1543894518,'1',1543901718),(296,'userpreferenceschanged','192',1543894518,'1',1543901718),(297,'userpreferenceschanged','193',1543894518,'1',1543901718),(298,'userpreferenceschanged','194',1543894518,'1',1543901718),(299,'userpreferenceschanged','195',1543894518,'1',1543901718),(300,'userpreferenceschanged','196',1543894518,'1',1543901718),(301,'userpreferenceschanged','197',1543894518,'1',1543901718),(302,'userpreferenceschanged','198',1543894519,'1',1543901719),(303,'userpreferenceschanged','199',1543894519,'1',1543901719),(304,'userpreferenceschanged','200',1543894519,'1',1543901719),(305,'userpreferenceschanged','201',1543894519,'1',1543901719),(306,'userpreferenceschanged','202',1543894519,'1',1543901719),(307,'userpreferenceschanged','203',1543894519,'1',1543901719),(308,'userpreferenceschanged','204',1543894519,'1',1543901719),(309,'userpreferenceschanged','205',1543894519,'1',1543901719),(310,'userpreferenceschanged','206',1543894519,'1',1543901719),(311,'userpreferenceschanged','207',1543894519,'1',1543901719),(312,'userpreferenceschanged','208',1543894519,'1',1543901719),(313,'userpreferenceschanged','209',1543894519,'1',1543901719),(314,'userpreferenceschanged','210',1543894519,'1',1543901719),(315,'userpreferenceschanged','211',1543894519,'1',1543901719),(316,'userpreferenceschanged','212',1543894519,'1',1543901719),(317,'userpreferenceschanged','213',1543894519,'1',1543901719),(318,'userpreferenceschanged','214',1543894519,'1',1543901719),(319,'userpreferenceschanged','215',1543894519,'1',1543901719),(320,'userpreferenceschanged','216',1543894519,'1',1543901719),(321,'userpreferenceschanged','217',1543894519,'1',1543901719),(322,'userpreferenceschanged','218',1543894519,'1',1543901719),(323,'userpreferenceschanged','219',1543894519,'1',1543901719),(324,'userpreferenceschanged','220',1543894519,'1',1543901719),(325,'userpreferenceschanged','221',1543894519,'1',1543901719),(326,'userpreferenceschanged','222',1543894519,'1',1543901719),(327,'userpreferenceschanged','223',1543894519,'1',1543901719),(328,'userpreferenceschanged','224',1543894519,'1',1543901719),(329,'userpreferenceschanged','225',1543894519,'1',1543901719),(330,'userpreferenceschanged','226',1543894519,'1',1543901719),(331,'userpreferenceschanged','227',1543894520,'1',1543901720),(332,'userpreferenceschanged','228',1543894520,'1',1543901720),(333,'userpreferenceschanged','229',1543894520,'1',1543901720),(334,'userpreferenceschanged','230',1543894520,'1',1543901720),(335,'userpreferenceschanged','231',1543894520,'1',1543901720),(336,'userpreferenceschanged','232',1543894520,'1',1543901720),(337,'userpreferenceschanged','233',1543894520,'1',1543901720),(338,'userpreferenceschanged','234',1543894520,'1',1543901720),(339,'userpreferenceschanged','235',1543894520,'1',1543901720),(340,'userpreferenceschanged','236',1543894520,'1',1543901720),(341,'userpreferenceschanged','237',1543894520,'1',1543901720),(342,'userpreferenceschanged','238',1543894520,'1',1543901720),(343,'userpreferenceschanged','239',1543894520,'1',1543901720),(344,'userpreferenceschanged','240',1543894520,'1',1543901720),(345,'userpreferenceschanged','241',1543894520,'1',1543901720),(346,'userpreferenceschanged','242',1543894520,'1',1543901720),(347,'userpreferenceschanged','243',1543894520,'1',1543901720),(348,'userpreferenceschanged','244',1543894520,'1',1543901720),(349,'userpreferenceschanged','245',1543894520,'1',1543901720),(350,'userpreferenceschanged','246',1543894520,'1',1543901720),(351,'userpreferenceschanged','247',1543894520,'1',1543901720),(352,'userpreferenceschanged','248',1543894520,'1',1543901720),(353,'userpreferenceschanged','249',1543894520,'1',1543901720),(354,'userpreferenceschanged','250',1543894520,'1',1543901720),(355,'userpreferenceschanged','251',1543894520,'1',1543901720),(356,'userpreferenceschanged','252',1543894520,'1',1543901720),(357,'userpreferenceschanged','253',1543894520,'1',1543901720),(358,'userpreferenceschanged','254',1543894520,'1',1543901720),(359,'userpreferenceschanged','255',1543894520,'1',1543901720),(360,'userpreferenceschanged','256',1543894520,'1',1543901720),(361,'userpreferenceschanged','257',1543894520,'1',1543901720),(362,'userpreferenceschanged','258',1543894520,'1',1543901720),(363,'userpreferenceschanged','259',1543894520,'1',1543901720),(364,'userpreferenceschanged','260',1543894521,'1',1543901721),(365,'userpreferenceschanged','261',1543894521,'1',1543901721),(366,'userpreferenceschanged','262',1543894521,'1',1543901721),(367,'userpreferenceschanged','263',1543894521,'1',1543901721),(368,'userpreferenceschanged','264',1543894521,'1',1543901721),(369,'userpreferenceschanged','265',1543894521,'1',1543901721),(370,'userpreferenceschanged','266',1543894521,'1',1543901721),(371,'userpreferenceschanged','267',1543894521,'1',1543901721),(372,'userpreferenceschanged','268',1543894521,'1',1543901721),(373,'userpreferenceschanged','269',1543894521,'1',1543901721),(374,'userpreferenceschanged','270',1543894521,'1',1543901721),(375,'userpreferenceschanged','271',1543894521,'1',1543901721),(376,'userpreferenceschanged','272',1543894521,'1',1543901721),(377,'userpreferenceschanged','273',1543894521,'1',1543901721),(378,'userpreferenceschanged','274',1543894521,'1',1543901721),(379,'userpreferenceschanged','275',1543894521,'1',1543901721),(380,'userpreferenceschanged','276',1543894521,'1',1543901721),(381,'userpreferenceschanged','277',1543894521,'1',1543901721),(382,'userpreferenceschanged','278',1543894521,'1',1543901721),(383,'userpreferenceschanged','279',1543894521,'1',1543901721),(384,'userpreferenceschanged','280',1543894521,'1',1543901721),(385,'userpreferenceschanged','281',1543894521,'1',1543901721),(386,'userpreferenceschanged','282',1543894521,'1',1543901721),(387,'userpreferenceschanged','283',1543894521,'1',1543901721),(388,'userpreferenceschanged','284',1543894522,'1',1543901722),(389,'userpreferenceschanged','285',1543894522,'1',1543901722),(390,'userpreferenceschanged','286',1543894522,'1',1543901722),(391,'userpreferenceschanged','287',1543894522,'1',1543901722),(392,'userpreferenceschanged','288',1543894522,'1',1543901722),(393,'userpreferenceschanged','289',1543894522,'1',1543901722),(394,'userpreferenceschanged','290',1543894522,'1',1543901722),(395,'userpreferenceschanged','291',1543894522,'1',1543901722),(396,'userpreferenceschanged','292',1543894522,'1',1543901722),(397,'userpreferenceschanged','293',1543894522,'1',1543901722),(398,'userpreferenceschanged','294',1543894522,'1',1543901722),(399,'userpreferenceschanged','295',1543894522,'1',1543901722),(400,'userpreferenceschanged','296',1543894522,'1',1543901722),(401,'userpreferenceschanged','297',1543894522,'1',1543901722),(402,'userpreferenceschanged','298',1543894522,'1',1543901722),(403,'userpreferenceschanged','299',1543894522,'1',1543901722),(404,'userpreferenceschanged','300',1543894522,'1',1543901722),(405,'userpreferenceschanged','301',1543894522,'1',1543901722),(406,'userpreferenceschanged','302',1543894522,'1',1543901722),(407,'userpreferenceschanged','303',1543894522,'1',1543901722),(408,'userpreferenceschanged','304',1543894522,'1',1543901722),(409,'userpreferenceschanged','305',1543894522,'1',1543901722),(410,'userpreferenceschanged','306',1543894522,'1',1543901722),(411,'userpreferenceschanged','307',1543894522,'1',1543901722),(412,'userpreferenceschanged','308',1543894522,'1',1543901722),(413,'userpreferenceschanged','309',1543894522,'1',1543901722),(414,'userpreferenceschanged','310',1543894522,'1',1543901722),(415,'userpreferenceschanged','311',1543894522,'1',1543901722),(416,'userpreferenceschanged','312',1543894522,'1',1543901722),(417,'userpreferenceschanged','313',1543894522,'1',1543901722),(418,'userpreferenceschanged','314',1543894522,'1',1543901722),(419,'userpreferenceschanged','315',1543894522,'1',1543901722),(420,'userpreferenceschanged','316',1543894522,'1',1543901722),(421,'userpreferenceschanged','317',1543894522,'1',1543901722),(422,'userpreferenceschanged','318',1543894523,'1',1543901723),(423,'userpreferenceschanged','319',1543894523,'1',1543901723),(424,'userpreferenceschanged','320',1543894523,'1',1543901723),(425,'userpreferenceschanged','321',1543894523,'1',1543901723),(426,'userpreferenceschanged','322',1543894523,'1',1543901723),(427,'userpreferenceschanged','323',1543894523,'1',1543901723),(428,'userpreferenceschanged','324',1543894523,'1',1543901723),(429,'userpreferenceschanged','325',1543894523,'1',1543901723),(430,'userpreferenceschanged','326',1543894523,'1',1543901723),(431,'userpreferenceschanged','327',1543894523,'1',1543901723),(432,'userpreferenceschanged','328',1543894523,'1',1543901723),(433,'userpreferenceschanged','329',1543894523,'1',1543901723),(434,'userpreferenceschanged','330',1543894523,'1',1543901723),(435,'userpreferenceschanged','331',1543894523,'1',1543901723),(436,'userpreferenceschanged','332',1543894523,'1',1543901723),(437,'userpreferenceschanged','333',1543894523,'1',1543901723),(438,'userpreferenceschanged','334',1543894523,'1',1543901723),(439,'userpreferenceschanged','335',1543894523,'1',1543901723),(440,'userpreferenceschanged','336',1543894523,'1',1543901723),(441,'userpreferenceschanged','337',1543894523,'1',1543901723),(442,'userpreferenceschanged','338',1543894523,'1',1543901723),(443,'userpreferenceschanged','339',1543894523,'1',1543901723),(444,'userpreferenceschanged','340',1543894523,'1',1543901723),(445,'userpreferenceschanged','341',1543894523,'1',1543901723),(446,'userpreferenceschanged','342',1543894523,'1',1543901723),(447,'userpreferenceschanged','343',1543894523,'1',1543901723),(448,'userpreferenceschanged','344',1543894523,'1',1543901723),(449,'userpreferenceschanged','345',1543894523,'1',1543901723),(450,'userpreferenceschanged','346',1543894523,'1',1543901723),(451,'userpreferenceschanged','347',1543894523,'1',1543901723),(452,'userpreferenceschanged','348',1543894523,'1',1543901723),(453,'userpreferenceschanged','349',1543894523,'1',1543901723),(454,'userpreferenceschanged','350',1543894523,'1',1543901723),(455,'userpreferenceschanged','351',1543894523,'1',1543901723),(456,'userpreferenceschanged','352',1543894524,'1',1543901724),(457,'userpreferenceschanged','353',1543894524,'1',1543901724),(458,'userpreferenceschanged','354',1543894524,'1',1543901724),(459,'userpreferenceschanged','355',1543894524,'1',1543901724),(460,'userpreferenceschanged','356',1543894524,'1',1543901724),(461,'userpreferenceschanged','357',1543894524,'1',1543901724),(462,'userpreferenceschanged','358',1543894524,'1',1543901724),(463,'userpreferenceschanged','359',1543894524,'1',1543901724),(464,'userpreferenceschanged','360',1543894524,'1',1543901724),(465,'userpreferenceschanged','361',1543894524,'1',1543901724),(466,'userpreferenceschanged','362',1543894524,'1',1543901724),(467,'userpreferenceschanged','363',1543894524,'1',1543901724),(468,'userpreferenceschanged','364',1543894524,'1',1543901724),(469,'userpreferenceschanged','365',1543894524,'1',1543901724),(470,'userpreferenceschanged','366',1543894524,'1',1543901724),(471,'userpreferenceschanged','367',1543894524,'1',1543901724),(472,'userpreferenceschanged','368',1543894524,'1',1543901724),(473,'userpreferenceschanged','369',1543894524,'1',1543901724),(474,'userpreferenceschanged','370',1543894524,'1',1543901724),(475,'userpreferenceschanged','371',1543894524,'1',1543901724),(476,'userpreferenceschanged','372',1543894524,'1',1543901724),(477,'userpreferenceschanged','373',1543894524,'1',1543901724),(478,'userpreferenceschanged','374',1543894524,'1',1543901724),(479,'userpreferenceschanged','375',1543894524,'1',1543901724),(480,'userpreferenceschanged','376',1543894524,'1',1543901724),(481,'userpreferenceschanged','377',1543894525,'1',1543901725),(482,'userpreferenceschanged','378',1543894525,'1',1543901725),(483,'userpreferenceschanged','379',1543894525,'1',1543901725),(484,'userpreferenceschanged','380',1543894525,'1',1543901725),(485,'userpreferenceschanged','381',1543894525,'1',1543901725),(486,'userpreferenceschanged','382',1543894525,'1',1543901725),(487,'userpreferenceschanged','383',1543894525,'1',1543901725),(488,'userpreferenceschanged','384',1543894525,'1',1543901725),(489,'userpreferenceschanged','385',1543894525,'1',1543901725),(490,'userpreferenceschanged','386',1543894525,'1',1543901725),(491,'userpreferenceschanged','387',1543894525,'1',1543901725),(492,'userpreferenceschanged','388',1543894525,'1',1543901725),(493,'userpreferenceschanged','389',1543894525,'1',1543901725),(494,'userpreferenceschanged','390',1543894525,'1',1543901725),(495,'userpreferenceschanged','391',1543894525,'1',1543901725),(496,'userpreferenceschanged','392',1543894525,'1',1543901725),(497,'userpreferenceschanged','393',1543894525,'1',1543901725),(498,'userpreferenceschanged','394',1543894525,'1',1543901725),(499,'userpreferenceschanged','395',1543894525,'1',1543901725),(500,'userpreferenceschanged','396',1543894525,'1',1543901725),(501,'userpreferenceschanged','397',1543894525,'1',1543901725),(502,'userpreferenceschanged','398',1543894525,'1',1543901725),(503,'userpreferenceschanged','399',1543894525,'1',1543901725),(504,'userpreferenceschanged','400',1543894525,'1',1543901725),(505,'userpreferenceschanged','401',1543894525,'1',1543901725),(506,'userpreferenceschanged','402',1543894525,'1',1543901725),(507,'userpreferenceschanged','403',1543894526,'1',1543901726),(508,'userpreferenceschanged','404',1543894526,'1',1543901726),(509,'userpreferenceschanged','405',1543894526,'1',1543901726),(510,'userpreferenceschanged','406',1543894526,'1',1543901726),(511,'userpreferenceschanged','407',1543894526,'1',1543901726),(512,'userpreferenceschanged','408',1543894526,'1',1543901726),(513,'userpreferenceschanged','409',1543894526,'1',1543901726),(514,'userpreferenceschanged','410',1543894526,'1',1543901726),(515,'userpreferenceschanged','411',1543894526,'1',1543901726),(516,'userpreferenceschanged','412',1543894526,'1',1543901726),(517,'userpreferenceschanged','413',1543894526,'1',1543901726),(518,'userpreferenceschanged','414',1543894526,'1',1543901726),(519,'userpreferenceschanged','415',1543894526,'1',1543901726),(520,'userpreferenceschanged','416',1543894526,'1',1543901726),(521,'userpreferenceschanged','417',1543894526,'1',1543901726),(522,'userpreferenceschanged','418',1543894526,'1',1543901726),(523,'userpreferenceschanged','419',1543894526,'1',1543901726),(524,'userpreferenceschanged','420',1543894526,'1',1543901726),(525,'userpreferenceschanged','421',1543894526,'1',1543901726),(526,'userpreferenceschanged','422',1543894526,'1',1543901726),(527,'userpreferenceschanged','423',1543894526,'1',1543901726),(528,'userpreferenceschanged','424',1543894526,'1',1543901726),(529,'userpreferenceschanged','425',1543894526,'1',1543901726),(530,'userpreferenceschanged','426',1543894526,'1',1543901726),(531,'userpreferenceschanged','427',1543894526,'1',1543901726),(532,'userpreferenceschanged','428',1543894526,'1',1543901726),(533,'userpreferenceschanged','429',1543894526,'1',1543901726),(534,'userpreferenceschanged','430',1543894526,'1',1543901726),(535,'userpreferenceschanged','431',1543894526,'1',1543901726),(536,'userpreferenceschanged','432',1543894527,'1',1543901727),(537,'userpreferenceschanged','433',1543894527,'1',1543901727),(538,'userpreferenceschanged','434',1543894527,'1',1543901727),(539,'userpreferenceschanged','435',1543894527,'1',1543901727),(540,'userpreferenceschanged','436',1543894527,'1',1543901727),(541,'userpreferenceschanged','437',1543894527,'1',1543901727),(542,'userpreferenceschanged','438',1543894527,'1',1543901727),(543,'userpreferenceschanged','439',1543894527,'1',1543901727),(544,'userpreferenceschanged','440',1543894527,'1',1543901727),(545,'userpreferenceschanged','441',1543894527,'1',1543901727),(546,'userpreferenceschanged','442',1543894527,'1',1543901727),(547,'userpreferenceschanged','443',1543894527,'1',1543901727),(548,'userpreferenceschanged','444',1543894527,'1',1543901727),(549,'userpreferenceschanged','445',1543894527,'1',1543901727),(550,'userpreferenceschanged','446',1543894527,'1',1543901727),(551,'userpreferenceschanged','447',1543894527,'1',1543901727),(552,'userpreferenceschanged','448',1543894527,'1',1543901727),(553,'userpreferenceschanged','449',1543894527,'1',1543901727),(554,'userpreferenceschanged','450',1543894527,'1',1543901727),(555,'userpreferenceschanged','451',1543894527,'1',1543901727),(556,'userpreferenceschanged','452',1543894527,'1',1543901727),(557,'userpreferenceschanged','453',1543894528,'1',1543901728),(558,'userpreferenceschanged','454',1543894528,'1',1543901728),(559,'userpreferenceschanged','455',1543894528,'1',1543901728),(560,'userpreferenceschanged','456',1543894528,'1',1543901728),(561,'userpreferenceschanged','457',1543894528,'1',1543901728),(562,'userpreferenceschanged','458',1543894528,'1',1543901728),(563,'userpreferenceschanged','459',1543894528,'1',1543901728),(564,'userpreferenceschanged','460',1543894528,'1',1543901728),(565,'userpreferenceschanged','461',1543894528,'1',1543901728),(566,'userpreferenceschanged','462',1543894528,'1',1543901728),(567,'userpreferenceschanged','463',1543894528,'1',1543901728),(568,'userpreferenceschanged','464',1543894528,'1',1543901728),(569,'userpreferenceschanged','465',1543894528,'1',1543901728),(570,'userpreferenceschanged','466',1543894528,'1',1543901728),(571,'userpreferenceschanged','467',1543894528,'1',1543901728),(572,'userpreferenceschanged','468',1543894528,'1',1543901728),(573,'userpreferenceschanged','469',1543894528,'1',1543901728),(574,'userpreferenceschanged','470',1543894528,'1',1543901728),(575,'userpreferenceschanged','471',1543894528,'1',1543901728),(576,'userpreferenceschanged','472',1543894528,'1',1543901728),(577,'userpreferenceschanged','473',1543894528,'1',1543901728),(578,'userpreferenceschanged','474',1543894528,'1',1543901728),(579,'userpreferenceschanged','475',1543894528,'1',1543901728),(580,'userpreferenceschanged','476',1543894528,'1',1543901728),(581,'userpreferenceschanged','477',1543894528,'1',1543901728),(582,'userpreferenceschanged','478',1543894529,'1',1543901729),(583,'userpreferenceschanged','479',1543894529,'1',1543901729),(584,'userpreferenceschanged','480',1543894529,'1',1543901729),(585,'userpreferenceschanged','481',1543894529,'1',1543901729),(586,'userpreferenceschanged','482',1543894529,'1',1543901729),(587,'userpreferenceschanged','483',1543894529,'1',1543901729),(588,'userpreferenceschanged','484',1543894529,'1',1543901729),(589,'userpreferenceschanged','485',1543894529,'1',1543901729),(590,'userpreferenceschanged','486',1543894529,'1',1543901729),(591,'userpreferenceschanged','487',1543894529,'1',1543901729),(592,'userpreferenceschanged','488',1543894529,'1',1543901729),(593,'userpreferenceschanged','489',1543894529,'1',1543901729),(594,'userpreferenceschanged','490',1543894529,'1',1543901729),(595,'userpreferenceschanged','491',1543894529,'1',1543901729),(596,'userpreferenceschanged','492',1543894529,'1',1543901729),(597,'userpreferenceschanged','493',1543894529,'1',1543901729),(598,'userpreferenceschanged','494',1543894529,'1',1543901729),(599,'userpreferenceschanged','495',1543894529,'1',1543901729),(600,'userpreferenceschanged','496',1543894529,'1',1543901729),(601,'userpreferenceschanged','497',1543894529,'1',1543901729),(602,'userpreferenceschanged','498',1543894529,'1',1543901729),(603,'userpreferenceschanged','499',1543894529,'1',1543901729),(604,'userpreferenceschanged','500',1543894529,'1',1543901729),(605,'userpreferenceschanged','501',1543894529,'1',1543901729),(606,'userpreferenceschanged','502',1543894529,'1',1543901729),(607,'userpreferenceschanged','503',1543894529,'1',1543901729),(608,'userpreferenceschanged','504',1543894529,'1',1543901729),(609,'userpreferenceschanged','505',1543894529,'1',1543901729),(610,'userpreferenceschanged','506',1543894529,'1',1543901729),(611,'userpreferenceschanged','507',1543894529,'1',1543901729),(612,'userpreferenceschanged','508',1543894529,'1',1543901729),(613,'userpreferenceschanged','509',1543894529,'1',1543901729),(614,'userpreferenceschanged','510',1543894529,'1',1543901729),(615,'userpreferenceschanged','511',1543894529,'1',1543901729),(616,'userpreferenceschanged','512',1543894530,'1',1543901730),(617,'userpreferenceschanged','513',1543894530,'1',1543901730),(618,'userpreferenceschanged','514',1543894530,'1',1543901730),(619,'userpreferenceschanged','515',1543894530,'1',1543901730),(620,'userpreferenceschanged','516',1543894530,'1',1543901730),(621,'userpreferenceschanged','517',1543894530,'1',1543901730),(622,'userpreferenceschanged','518',1543894530,'1',1543901730),(623,'userpreferenceschanged','519',1543894530,'1',1543901730),(624,'userpreferenceschanged','520',1543894530,'1',1543901730),(625,'userpreferenceschanged','521',1543894530,'1',1543901730),(626,'userpreferenceschanged','522',1543894530,'1',1543901730),(627,'userpreferenceschanged','523',1543894530,'1',1543901730),(628,'userpreferenceschanged','524',1543894530,'1',1543901730),(629,'userpreferenceschanged','525',1543894530,'1',1543901730),(630,'userpreferenceschanged','526',1543894530,'1',1543901730),(631,'userpreferenceschanged','527',1543894530,'1',1543901730),(632,'userpreferenceschanged','528',1543894530,'1',1543901730),(633,'userpreferenceschanged','529',1543894530,'1',1543901730),(634,'userpreferenceschanged','530',1543894530,'1',1543901730),(635,'userpreferenceschanged','531',1543894530,'1',1543901730),(636,'userpreferenceschanged','532',1543894530,'1',1543901730),(637,'userpreferenceschanged','533',1543894530,'1',1543901730),(638,'userpreferenceschanged','534',1543894530,'1',1543901730),(639,'userpreferenceschanged','535',1543894530,'1',1543901730),(640,'userpreferenceschanged','536',1543894530,'1',1543901730),(641,'userpreferenceschanged','537',1543894530,'1',1543901730),(642,'userpreferenceschanged','538',1543894530,'1',1543901730),(643,'userpreferenceschanged','539',1543894530,'1',1543901730),(644,'userpreferenceschanged','540',1543894531,'1',1543901731),(645,'userpreferenceschanged','541',1543894531,'1',1543901731),(646,'userpreferenceschanged','542',1543894531,'1',1543901731),(647,'userpreferenceschanged','543',1543894531,'1',1543901731),(648,'userpreferenceschanged','544',1543894531,'1',1543901731),(649,'userpreferenceschanged','545',1543894531,'1',1543901731),(650,'userpreferenceschanged','546',1543894531,'1',1543901731),(651,'userpreferenceschanged','547',1543894531,'1',1543901731),(652,'userpreferenceschanged','548',1543894531,'1',1543901731),(653,'userpreferenceschanged','549',1543894531,'1',1543901731),(654,'userpreferenceschanged','550',1543894531,'1',1543901731),(655,'userpreferenceschanged','551',1543894531,'1',1543901731),(656,'userpreferenceschanged','552',1543894531,'1',1543901731),(657,'userpreferenceschanged','553',1543894531,'1',1543901731),(658,'userpreferenceschanged','554',1543894531,'1',1543901731),(659,'userpreferenceschanged','555',1543894531,'1',1543901731),(660,'userpreferenceschanged','556',1543894531,'1',1543901731),(661,'userpreferenceschanged','557',1543894531,'1',1543901731),(662,'userpreferenceschanged','558',1543894531,'1',1543901731),(663,'userpreferenceschanged','559',1543894531,'1',1543901731),(664,'userpreferenceschanged','560',1543894531,'1',1543901731),(665,'userpreferenceschanged','561',1543894531,'1',1543901731),(666,'userpreferenceschanged','562',1543894531,'1',1543901731),(667,'userpreferenceschanged','563',1543894531,'1',1543901731),(668,'userpreferenceschanged','564',1543894531,'1',1543901731),(669,'userpreferenceschanged','565',1543894531,'1',1543901731),(670,'userpreferenceschanged','566',1543894531,'1',1543901731),(671,'userpreferenceschanged','567',1543894531,'1',1543901731),(672,'userpreferenceschanged','568',1543894531,'1',1543901731),(673,'userpreferenceschanged','569',1543894531,'1',1543901731),(674,'userpreferenceschanged','570',1543894531,'1',1543901731),(675,'userpreferenceschanged','571',1543894531,'1',1543901731),(676,'userpreferenceschanged','572',1543894532,'1',1543901732),(677,'userpreferenceschanged','573',1543894532,'1',1543901732),(678,'userpreferenceschanged','574',1543894532,'1',1543901732),(679,'userpreferenceschanged','575',1543894532,'1',1543901732),(680,'userpreferenceschanged','576',1543894532,'1',1543901732),(681,'userpreferenceschanged','577',1543894532,'1',1543901732),(682,'userpreferenceschanged','578',1543894532,'1',1543901732),(683,'userpreferenceschanged','579',1543894532,'1',1543901732),(684,'userpreferenceschanged','580',1543894532,'1',1543901732),(685,'userpreferenceschanged','581',1543894532,'1',1543901732),(686,'userpreferenceschanged','582',1543894532,'1',1543901732),(687,'userpreferenceschanged','583',1543894532,'1',1543901732),(688,'userpreferenceschanged','584',1543894532,'1',1543901732),(689,'userpreferenceschanged','585',1543894532,'1',1543901732),(690,'userpreferenceschanged','586',1543894532,'1',1543901732),(691,'userpreferenceschanged','587',1543894532,'1',1543901732),(692,'userpreferenceschanged','588',1543894532,'1',1543901732),(693,'userpreferenceschanged','589',1543894532,'1',1543901732),(694,'userpreferenceschanged','590',1543894532,'1',1543901732),(695,'userpreferenceschanged','591',1543894532,'1',1543901732),(696,'userpreferenceschanged','592',1543894532,'1',1543901732),(697,'userpreferenceschanged','593',1543894532,'1',1543901732),(698,'userpreferenceschanged','594',1543894532,'1',1543901732),(699,'userpreferenceschanged','595',1543894532,'1',1543901732),(700,'userpreferenceschanged','596',1543894532,'1',1543901732),(701,'userpreferenceschanged','597',1543894532,'1',1543901732),(702,'userpreferenceschanged','598',1543894532,'1',1543901732),(703,'userpreferenceschanged','599',1543894532,'1',1543901732),(704,'userpreferenceschanged','600',1543894532,'1',1543901732),(705,'userpreferenceschanged','601',1543894532,'1',1543901732),(706,'userpreferenceschanged','602',1543894532,'1',1543901732),(707,'userpreferenceschanged','603',1543894532,'1',1543901732),(708,'userpreferenceschanged','604',1543894532,'1',1543901732),(709,'userpreferenceschanged','605',1543894532,'1',1543901732),(710,'userpreferenceschanged','606',1543894532,'1',1543901732),(711,'userpreferenceschanged','607',1543894532,'1',1543901732),(712,'userpreferenceschanged','608',1543894532,'1',1543901732),(713,'userpreferenceschanged','609',1543894532,'1',1543901732),(714,'userpreferenceschanged','610',1543894532,'1',1543901732),(715,'userpreferenceschanged','611',1543894532,'1',1543901732),(716,'userpreferenceschanged','612',1543894533,'1',1543901733),(717,'userpreferenceschanged','613',1543894533,'1',1543901733),(718,'userpreferenceschanged','614',1543894533,'1',1543901733),(719,'userpreferenceschanged','615',1543894533,'1',1543901733),(720,'userpreferenceschanged','616',1543894533,'1',1543901733),(721,'userpreferenceschanged','617',1543894533,'1',1543901733),(722,'userpreferenceschanged','618',1543894533,'1',1543901733),(723,'userpreferenceschanged','619',1543894533,'1',1543901733),(724,'userpreferenceschanged','620',1543894533,'1',1543901733),(725,'userpreferenceschanged','621',1543894533,'1',1543901733),(726,'userpreferenceschanged','622',1543894533,'1',1543901733),(727,'userpreferenceschanged','623',1543894533,'1',1543901733),(728,'userpreferenceschanged','624',1543894533,'1',1543901733),(729,'userpreferenceschanged','625',1543894533,'1',1543901733),(730,'userpreferenceschanged','626',1543894533,'1',1543901733),(731,'userpreferenceschanged','627',1543894533,'1',1543901733),(732,'userpreferenceschanged','628',1543894533,'1',1543901733),(733,'userpreferenceschanged','629',1543894533,'1',1543901733),(734,'userpreferenceschanged','630',1543894533,'1',1543901733),(735,'userpreferenceschanged','631',1543894533,'1',1543901733),(736,'userpreferenceschanged','632',1543894533,'1',1543901733),(737,'userpreferenceschanged','633',1543894533,'1',1543901733),(738,'userpreferenceschanged','634',1543894533,'1',1543901733),(739,'userpreferenceschanged','635',1543894533,'1',1543901733),(740,'userpreferenceschanged','636',1543894533,'1',1543901733),(741,'userpreferenceschanged','637',1543894534,'1',1543901734),(742,'userpreferenceschanged','638',1543894534,'1',1543901734),(743,'userpreferenceschanged','639',1543894534,'1',1543901734),(744,'userpreferenceschanged','640',1543894534,'1',1543901734),(745,'userpreferenceschanged','641',1543894534,'1',1543901734),(746,'userpreferenceschanged','642',1543894534,'1',1543901734),(747,'userpreferenceschanged','643',1543894534,'1',1543901734),(748,'userpreferenceschanged','644',1543894534,'1',1543901734),(749,'userpreferenceschanged','645',1543894534,'1',1543901734),(750,'userpreferenceschanged','646',1543894534,'1',1543901734),(751,'userpreferenceschanged','647',1543894534,'1',1543901734),(752,'userpreferenceschanged','648',1543894534,'1',1543901734),(753,'userpreferenceschanged','649',1543894534,'1',1543901734),(754,'userpreferenceschanged','650',1543894534,'1',1543901734),(755,'userpreferenceschanged','651',1543894534,'1',1543901734),(756,'userpreferenceschanged','652',1543894534,'1',1543901734),(757,'userpreferenceschanged','653',1543894534,'1',1543901734),(758,'userpreferenceschanged','654',1543894534,'1',1543901734),(759,'userpreferenceschanged','655',1543894534,'1',1543901734),(760,'userpreferenceschanged','656',1543894534,'1',1543901734),(761,'userpreferenceschanged','657',1543894534,'1',1543901734),(762,'userpreferenceschanged','658',1543894534,'1',1543901734),(763,'userpreferenceschanged','659',1543894534,'1',1543901734),(764,'userpreferenceschanged','660',1543894534,'1',1543901734),(765,'userpreferenceschanged','661',1543894534,'1',1543901734),(766,'userpreferenceschanged','662',1543894534,'1',1543901734),(767,'userpreferenceschanged','663',1543894534,'1',1543901734),(768,'userpreferenceschanged','664',1543894534,'1',1543901734),(769,'userpreferenceschanged','665',1543894534,'1',1543901734),(770,'userpreferenceschanged','666',1543894534,'1',1543901734),(771,'userpreferenceschanged','667',1543894534,'1',1543901734),(772,'userpreferenceschanged','668',1543894534,'1',1543901734),(773,'userpreferenceschanged','669',1543894534,'1',1543901734),(774,'userpreferenceschanged','670',1543894535,'1',1543901735),(775,'userpreferenceschanged','671',1543894535,'1',1543901735),(776,'userpreferenceschanged','672',1543894535,'1',1543901735),(777,'userpreferenceschanged','673',1543894535,'1',1543901735),(778,'userpreferenceschanged','674',1543894535,'1',1543901735),(779,'userpreferenceschanged','675',1543894535,'1',1543901735),(780,'userpreferenceschanged','676',1543894535,'1',1543901735),(781,'userpreferenceschanged','677',1543894535,'1',1543901735),(782,'userpreferenceschanged','678',1543894535,'1',1543901735),(783,'userpreferenceschanged','679',1543894535,'1',1543901735),(784,'userpreferenceschanged','680',1543894535,'1',1543901735),(785,'userpreferenceschanged','681',1543894535,'1',1543901735),(786,'userpreferenceschanged','682',1543894535,'1',1543901735),(787,'userpreferenceschanged','683',1543894535,'1',1543901735),(788,'userpreferenceschanged','684',1543894535,'1',1543901735),(789,'userpreferenceschanged','685',1543894535,'1',1543901735),(790,'userpreferenceschanged','686',1543894535,'1',1543901735),(791,'userpreferenceschanged','687',1543894535,'1',1543901735),(792,'userpreferenceschanged','688',1543894535,'1',1543901735),(793,'userpreferenceschanged','689',1543894535,'1',1543901735),(794,'userpreferenceschanged','690',1543894535,'1',1543901735),(795,'userpreferenceschanged','691',1543894535,'1',1543901735),(796,'userpreferenceschanged','692',1543894535,'1',1543901735),(797,'userpreferenceschanged','693',1543894535,'1',1543901735),(798,'userpreferenceschanged','694',1543894535,'1',1543901735),(799,'userpreferenceschanged','695',1543894535,'1',1543901735),(800,'userpreferenceschanged','696',1543894535,'1',1543901735),(801,'userpreferenceschanged','697',1543894535,'1',1543901735),(802,'userpreferenceschanged','698',1543894535,'1',1543901735),(803,'userpreferenceschanged','699',1543894535,'1',1543901735),(804,'userpreferenceschanged','700',1543894535,'1',1543901735),(805,'userpreferenceschanged','701',1543894536,'1',1543901736),(806,'userpreferenceschanged','702',1543894536,'1',1543901736),(807,'userpreferenceschanged','703',1543894536,'1',1543901736),(808,'userpreferenceschanged','704',1543894536,'1',1543901736),(809,'userpreferenceschanged','705',1543894536,'1',1543901736),(810,'userpreferenceschanged','706',1543894536,'1',1543901736),(811,'userpreferenceschanged','707',1543894536,'1',1543901736),(812,'userpreferenceschanged','708',1543894536,'1',1543901736),(813,'userpreferenceschanged','709',1543894536,'1',1543901736),(814,'userpreferenceschanged','710',1543894536,'1',1543901736),(815,'userpreferenceschanged','711',1543894536,'1',1543901736),(816,'userpreferenceschanged','712',1543894536,'1',1543901736),(817,'userpreferenceschanged','713',1543894536,'1',1543901736),(818,'userpreferenceschanged','714',1543894536,'1',1543901736),(819,'userpreferenceschanged','715',1543894536,'1',1543901736),(820,'userpreferenceschanged','716',1543894536,'1',1543901736),(821,'userpreferenceschanged','717',1543894536,'1',1543901736),(822,'userpreferenceschanged','718',1543894536,'1',1543901736),(823,'userpreferenceschanged','719',1543894536,'1',1543901736),(824,'userpreferenceschanged','720',1543894536,'1',1543901736),(825,'userpreferenceschanged','721',1543894536,'1',1543901736),(826,'userpreferenceschanged','722',1543894536,'1',1543901736),(827,'userpreferenceschanged','723',1543894536,'1',1543901736),(828,'userpreferenceschanged','724',1543894536,'1',1543901736),(829,'userpreferenceschanged','725',1543894536,'1',1543901736),(830,'userpreferenceschanged','726',1543894536,'1',1543901736),(831,'userpreferenceschanged','727',1543894536,'1',1543901736),(832,'userpreferenceschanged','728',1543894536,'1',1543901736),(833,'userpreferenceschanged','729',1543894536,'1',1543901736),(834,'userpreferenceschanged','730',1543894536,'1',1543901736),(835,'userpreferenceschanged','731',1543894536,'1',1543901736),(836,'userpreferenceschanged','732',1543894536,'1',1543901736),(837,'userpreferenceschanged','733',1543894536,'1',1543901736),(838,'userpreferenceschanged','734',1543894537,'1',1543901737),(839,'userpreferenceschanged','735',1543894537,'1',1543901737),(840,'userpreferenceschanged','736',1543894537,'1',1543901737),(841,'userpreferenceschanged','737',1543894537,'1',1543901737),(842,'userpreferenceschanged','738',1543894537,'1',1543901737),(843,'userpreferenceschanged','739',1543894537,'1',1543901737),(844,'userpreferenceschanged','740',1543894537,'1',1543901737),(845,'userpreferenceschanged','741',1543894537,'1',1543901737),(846,'userpreferenceschanged','742',1543894537,'1',1543901737),(847,'userpreferenceschanged','743',1543894537,'1',1543901737),(848,'userpreferenceschanged','744',1543894537,'1',1543901737),(849,'userpreferenceschanged','745',1543894537,'1',1543901737),(850,'userpreferenceschanged','746',1543894537,'1',1543901737),(851,'userpreferenceschanged','747',1543894537,'1',1543901737),(852,'userpreferenceschanged','748',1543894537,'1',1543901737),(853,'userpreferenceschanged','749',1543894537,'1',1543901737),(854,'userpreferenceschanged','750',1543894537,'1',1543901737),(855,'userpreferenceschanged','751',1543894537,'1',1543901737),(856,'userpreferenceschanged','752',1543894537,'1',1543901737),(857,'userpreferenceschanged','753',1543894537,'1',1543901737),(858,'userpreferenceschanged','754',1543894537,'1',1543901737),(859,'userpreferenceschanged','755',1543894537,'1',1543901737),(860,'userpreferenceschanged','756',1543894537,'1',1543901737),(861,'userpreferenceschanged','757',1543894537,'1',1543901737),(862,'userpreferenceschanged','758',1543894537,'1',1543901737),(863,'userpreferenceschanged','759',1543894537,'1',1543901737),(864,'userpreferenceschanged','760',1543894537,'1',1543901737),(865,'userpreferenceschanged','761',1543894537,'1',1543901737),(866,'userpreferenceschanged','762',1543894537,'1',1543901737),(867,'userpreferenceschanged','763',1543894537,'1',1543901737),(868,'userpreferenceschanged','764',1543894537,'1',1543901737),(869,'userpreferenceschanged','765',1543894537,'1',1543901737),(870,'userpreferenceschanged','766',1543894537,'1',1543901737),(871,'userpreferenceschanged','767',1543894537,'1',1543901737),(872,'userpreferenceschanged','768',1543894538,'1',1543901738),(873,'userpreferenceschanged','769',1543894538,'1',1543901738),(874,'userpreferenceschanged','770',1543894538,'1',1543901738),(875,'userpreferenceschanged','771',1543894538,'1',1543901738),(876,'userpreferenceschanged','772',1543894538,'1',1543901738),(877,'userpreferenceschanged','773',1543894538,'1',1543901738),(878,'userpreferenceschanged','774',1543894538,'1',1543901738),(879,'userpreferenceschanged','775',1543894538,'1',1543901738),(880,'userpreferenceschanged','776',1543894538,'1',1543901738),(881,'userpreferenceschanged','777',1543894538,'1',1543901738),(882,'userpreferenceschanged','778',1543894538,'1',1543901738),(883,'userpreferenceschanged','779',1543894538,'1',1543901738),(884,'userpreferenceschanged','780',1543894538,'1',1543901738),(885,'userpreferenceschanged','781',1543894538,'1',1543901738),(886,'userpreferenceschanged','782',1543894538,'1',1543901738),(887,'userpreferenceschanged','783',1543894538,'1',1543901738),(888,'userpreferenceschanged','784',1543894538,'1',1543901738),(889,'userpreferenceschanged','785',1543894538,'1',1543901738),(890,'userpreferenceschanged','786',1543894538,'1',1543901738),(891,'userpreferenceschanged','787',1543894538,'1',1543901738),(892,'userpreferenceschanged','788',1543894538,'1',1543901738),(893,'userpreferenceschanged','789',1543894538,'1',1543901738),(894,'userpreferenceschanged','790',1543894538,'1',1543901738),(895,'userpreferenceschanged','791',1543894538,'1',1543901738),(896,'userpreferenceschanged','792',1543894538,'1',1543901738),(897,'userpreferenceschanged','793',1543894538,'1',1543901738),(898,'userpreferenceschanged','794',1543894538,'1',1543901738),(899,'userpreferenceschanged','795',1543894538,'1',1543901738),(900,'userpreferenceschanged','796',1543894538,'1',1543901738),(901,'userpreferenceschanged','797',1543894538,'1',1543901738),(902,'userpreferenceschanged','798',1543894539,'1',1543901739),(903,'userpreferenceschanged','799',1543894539,'1',1543901739),(904,'userpreferenceschanged','800',1543894539,'1',1543901739),(905,'userpreferenceschanged','801',1543894539,'1',1543901739),(906,'userpreferenceschanged','802',1543894539,'1',1543901739),(907,'userpreferenceschanged','803',1543894539,'1',1543901739),(908,'userpreferenceschanged','804',1543894539,'1',1543901739),(909,'userpreferenceschanged','805',1543894539,'1',1543901739),(910,'userpreferenceschanged','806',1543894539,'1',1543901739),(911,'userpreferenceschanged','807',1543894539,'1',1543901739),(912,'userpreferenceschanged','808',1543894539,'1',1543901739),(913,'userpreferenceschanged','809',1543894539,'1',1543901739),(914,'userpreferenceschanged','810',1543894539,'1',1543901739),(915,'userpreferenceschanged','811',1543894539,'1',1543901739),(916,'userpreferenceschanged','812',1543894539,'1',1543901739),(917,'userpreferenceschanged','813',1543894539,'1',1543901739),(918,'userpreferenceschanged','814',1543894539,'1',1543901739),(919,'userpreferenceschanged','815',1543894539,'1',1543901739),(920,'userpreferenceschanged','816',1543894539,'1',1543901739),(921,'userpreferenceschanged','817',1543894539,'1',1543901739),(922,'userpreferenceschanged','818',1543894539,'1',1543901739),(923,'userpreferenceschanged','819',1543894539,'1',1543901739),(924,'userpreferenceschanged','820',1543894539,'1',1543901739),(925,'userpreferenceschanged','821',1543894539,'1',1543901739),(926,'userpreferenceschanged','822',1543894539,'1',1543901739),(927,'userpreferenceschanged','823',1543894539,'1',1543901739),(928,'userpreferenceschanged','824',1543894539,'1',1543901739),(929,'userpreferenceschanged','825',1543894539,'1',1543901739),(930,'userpreferenceschanged','826',1543894539,'1',1543901739),(931,'userpreferenceschanged','827',1543894539,'1',1543901739),(932,'userpreferenceschanged','828',1543894539,'1',1543901739),(933,'userpreferenceschanged','829',1543894539,'1',1543901739),(934,'userpreferenceschanged','830',1543894539,'1',1543901739),(935,'userpreferenceschanged','831',1543894539,'1',1543901739),(936,'userpreferenceschanged','832',1543894539,'1',1543901739),(937,'userpreferenceschanged','833',1543894540,'1',1543901740),(938,'userpreferenceschanged','834',1543894540,'1',1543901740),(939,'userpreferenceschanged','835',1543894540,'1',1543901740),(940,'userpreferenceschanged','836',1543894540,'1',1543901740),(941,'userpreferenceschanged','837',1543894540,'1',1543901740),(942,'userpreferenceschanged','838',1543894540,'1',1543901740),(943,'userpreferenceschanged','839',1543894540,'1',1543901740),(944,'userpreferenceschanged','840',1543894540,'1',1543901740),(945,'userpreferenceschanged','841',1543894540,'1',1543901740),(946,'userpreferenceschanged','842',1543894540,'1',1543901740),(947,'userpreferenceschanged','843',1543894540,'1',1543901740),(948,'userpreferenceschanged','844',1543894540,'1',1543901740),(949,'userpreferenceschanged','845',1543894540,'1',1543901740),(950,'userpreferenceschanged','846',1543894540,'1',1543901740),(951,'userpreferenceschanged','847',1543894540,'1',1543901740),(952,'userpreferenceschanged','848',1543894540,'1',1543901740),(953,'userpreferenceschanged','849',1543894540,'1',1543901740),(954,'userpreferenceschanged','850',1543894540,'1',1543901740),(955,'userpreferenceschanged','851',1543894540,'1',1543901740),(956,'userpreferenceschanged','852',1543894540,'1',1543901740),(957,'userpreferenceschanged','853',1543894540,'1',1543901740),(958,'userpreferenceschanged','854',1543894540,'1',1543901740),(959,'userpreferenceschanged','855',1543894540,'1',1543901740),(960,'userpreferenceschanged','856',1543894540,'1',1543901740),(961,'userpreferenceschanged','857',1543894540,'1',1543901740),(962,'userpreferenceschanged','858',1543894540,'1',1543901740),(963,'userpreferenceschanged','859',1543894541,'1',1543901741),(964,'userpreferenceschanged','860',1543894541,'1',1543901741),(965,'userpreferenceschanged','861',1543894541,'1',1543901741),(966,'userpreferenceschanged','862',1543894541,'1',1543901741),(967,'userpreferenceschanged','863',1543894541,'1',1543901741),(968,'userpreferenceschanged','864',1543894541,'1',1543901741),(969,'userpreferenceschanged','865',1543894541,'1',1543901741),(970,'userpreferenceschanged','866',1543894541,'1',1543901741),(971,'userpreferenceschanged','867',1543894541,'1',1543901741),(972,'userpreferenceschanged','868',1543894541,'1',1543901741),(973,'userpreferenceschanged','869',1543894541,'1',1543901741),(974,'userpreferenceschanged','870',1543894541,'1',1543901741),(975,'userpreferenceschanged','871',1543894541,'1',1543901741),(976,'userpreferenceschanged','872',1543894541,'1',1543901741),(977,'userpreferenceschanged','873',1543894541,'1',1543901741),(978,'userpreferenceschanged','874',1543894541,'1',1543901741),(979,'userpreferenceschanged','875',1543894541,'1',1543901741),(980,'userpreferenceschanged','876',1543894541,'1',1543901741),(981,'userpreferenceschanged','877',1543894541,'1',1543901741),(982,'userpreferenceschanged','878',1543894541,'1',1543901741),(983,'userpreferenceschanged','879',1543894541,'1',1543901741),(984,'userpreferenceschanged','880',1543894541,'1',1543901741),(985,'userpreferenceschanged','881',1543894541,'1',1543901741),(986,'userpreferenceschanged','882',1543894541,'1',1543901741),(987,'userpreferenceschanged','883',1543894541,'1',1543901741),(988,'userpreferenceschanged','884',1543894541,'1',1543901741),(989,'userpreferenceschanged','885',1543894541,'1',1543901741),(990,'userpreferenceschanged','886',1543894541,'1',1543901741),(991,'userpreferenceschanged','887',1543894541,'1',1543901741),(992,'userpreferenceschanged','888',1543894541,'1',1543901741),(993,'userpreferenceschanged','889',1543894541,'1',1543901741),(994,'userpreferenceschanged','890',1543894541,'1',1543901741),(995,'userpreferenceschanged','891',1543894541,'1',1543901741),(996,'userpreferenceschanged','892',1543894541,'1',1543901741),(997,'userpreferenceschanged','893',1543894541,'1',1543901741),(998,'userpreferenceschanged','894',1543894541,'1',1543901741),(999,'userpreferenceschanged','895',1543894542,'1',1543901742),(1000,'userpreferenceschanged','896',1543894542,'1',1543901742),(1001,'userpreferenceschanged','897',1543894542,'1',1543901742),(1002,'userpreferenceschanged','898',1543894542,'1',1543901742),(1003,'userpreferenceschanged','899',1543894542,'1',1543901742),(1004,'userpreferenceschanged','900',1543894542,'1',1543901742),(1005,'userpreferenceschanged','901',1543894542,'1',1543901742),(1006,'userpreferenceschanged','902',1543894542,'1',1543901742),(1007,'userpreferenceschanged','903',1543894542,'1',1543901742),(1008,'userpreferenceschanged','904',1543894542,'1',1543901742),(1009,'userpreferenceschanged','905',1543894542,'1',1543901742),(1010,'userpreferenceschanged','906',1543894542,'1',1543901742),(1011,'userpreferenceschanged','907',1543894542,'1',1543901742),(1012,'userpreferenceschanged','908',1543894542,'1',1543901742),(1013,'userpreferenceschanged','909',1543894542,'1',1543901742),(1014,'userpreferenceschanged','910',1543894542,'1',1543901742),(1015,'userpreferenceschanged','911',1543894542,'1',1543901742),(1016,'userpreferenceschanged','912',1543894542,'1',1543901742),(1017,'userpreferenceschanged','913',1543894542,'1',1543901742),(1018,'userpreferenceschanged','914',1543894542,'1',1543901742),(1019,'userpreferenceschanged','915',1543894542,'1',1543901742),(1020,'userpreferenceschanged','916',1543894542,'1',1543901742),(1021,'userpreferenceschanged','917',1543894542,'1',1543901742),(1022,'userpreferenceschanged','918',1543894542,'1',1543901742),(1023,'userpreferenceschanged','919',1543894542,'1',1543901742),(1024,'userpreferenceschanged','920',1543894542,'1',1543901742),(1025,'userpreferenceschanged','921',1543894542,'1',1543901742),(1026,'userpreferenceschanged','922',1543894542,'1',1543901742),(1027,'userpreferenceschanged','923',1543894542,'1',1543901742),(1028,'userpreferenceschanged','924',1543894542,'1',1543901742),(1029,'userpreferenceschanged','925',1543894542,'1',1543901742),(1030,'userpreferenceschanged','926',1543894542,'1',1543901742),(1031,'userpreferenceschanged','927',1543894542,'1',1543901742),(1032,'userpreferenceschanged','928',1543894542,'1',1543901742),(1033,'userpreferenceschanged','929',1543894542,'1',1543901742),(1034,'userpreferenceschanged','930',1543894542,'1',1543901742),(1035,'userpreferenceschanged','931',1543894542,'1',1543901742),(1036,'userpreferenceschanged','932',1543894542,'1',1543901742),(1037,'userpreferenceschanged','933',1543894543,'1',1543901743),(1038,'userpreferenceschanged','934',1543894543,'1',1543901743),(1039,'userpreferenceschanged','935',1543894543,'1',1543901743),(1040,'userpreferenceschanged','936',1543894543,'1',1543901743),(1041,'userpreferenceschanged','937',1543894543,'1',1543901743),(1042,'userpreferenceschanged','938',1543894543,'1',1543901743),(1043,'userpreferenceschanged','939',1543894543,'1',1543901743),(1044,'userpreferenceschanged','940',1543894543,'1',1543901743),(1045,'userpreferenceschanged','941',1543894543,'1',1543901743),(1046,'userpreferenceschanged','942',1543894543,'1',1543901743),(1047,'userpreferenceschanged','943',1543894543,'1',1543901743),(1048,'userpreferenceschanged','944',1543894543,'1',1543901743),(1049,'userpreferenceschanged','945',1543894543,'1',1543901743),(1050,'userpreferenceschanged','946',1543894543,'1',1543901743),(1051,'userpreferenceschanged','947',1543894543,'1',1543901743),(1052,'userpreferenceschanged','948',1543894543,'1',1543901743),(1053,'userpreferenceschanged','949',1543894543,'1',1543901743),(1054,'userpreferenceschanged','950',1543894543,'1',1543901743),(1055,'userpreferenceschanged','951',1543894543,'1',1543901743),(1056,'userpreferenceschanged','952',1543894543,'1',1543901743),(1057,'userpreferenceschanged','953',1543894543,'1',1543901743),(1058,'userpreferenceschanged','954',1543894543,'1',1543901743),(1059,'userpreferenceschanged','955',1543894543,'1',1543901743),(1060,'userpreferenceschanged','956',1543894543,'1',1543901743),(1061,'userpreferenceschanged','957',1543894543,'1',1543901743),(1062,'userpreferenceschanged','958',1543894543,'1',1543901743),(1063,'userpreferenceschanged','959',1543894543,'1',1543901743),(1064,'userpreferenceschanged','960',1543894543,'1',1543901743),(1065,'userpreferenceschanged','961',1543894543,'1',1543901743),(1066,'userpreferenceschanged','962',1543894543,'1',1543901743),(1067,'userpreferenceschanged','963',1543894544,'1',1543901744),(1068,'userpreferenceschanged','964',1543894544,'1',1543901744),(1069,'userpreferenceschanged','965',1543894544,'1',1543901744),(1070,'userpreferenceschanged','966',1543894544,'1',1543901744),(1071,'userpreferenceschanged','967',1543894544,'1',1543901744),(1072,'userpreferenceschanged','968',1543894544,'1',1543901744),(1073,'userpreferenceschanged','969',1543894544,'1',1543901744),(1074,'userpreferenceschanged','970',1543894544,'1',1543901744),(1075,'userpreferenceschanged','971',1543894544,'1',1543901744),(1076,'userpreferenceschanged','972',1543894544,'1',1543901744),(1077,'userpreferenceschanged','973',1543894544,'1',1543901744),(1078,'userpreferenceschanged','974',1543894544,'1',1543901744),(1079,'userpreferenceschanged','975',1543894544,'1',1543901744),(1080,'userpreferenceschanged','976',1543894544,'1',1543901744),(1081,'userpreferenceschanged','977',1543894544,'1',1543901744),(1082,'userpreferenceschanged','978',1543894544,'1',1543901744),(1083,'userpreferenceschanged','979',1543894544,'1',1543901744),(1084,'userpreferenceschanged','980',1543894544,'1',1543901744),(1085,'userpreferenceschanged','981',1543894544,'1',1543901744),(1086,'userpreferenceschanged','982',1543894544,'1',1543901744),(1087,'userpreferenceschanged','983',1543894544,'1',1543901744),(1088,'userpreferenceschanged','984',1543894544,'1',1543901744),(1089,'userpreferenceschanged','985',1543894544,'1',1543901744),(1090,'userpreferenceschanged','986',1543894544,'1',1543901744),(1091,'userpreferenceschanged','987',1543894544,'1',1543901744),(1092,'userpreferenceschanged','988',1543894544,'1',1543901744),(1093,'userpreferenceschanged','989',1543894544,'1',1543901744),(1094,'userpreferenceschanged','990',1543894544,'1',1543901744),(1095,'userpreferenceschanged','991',1543894544,'1',1543901744),(1096,'userpreferenceschanged','992',1543894544,'1',1543901744),(1097,'userpreferenceschanged','993',1543894544,'1',1543901744),(1098,'userpreferenceschanged','994',1543894544,'1',1543901744),(1099,'userpreferenceschanged','995',1543894544,'1',1543901744),(1100,'userpreferenceschanged','996',1543894544,'1',1543901744),(1101,'userpreferenceschanged','997',1543894544,'1',1543901744),(1102,'userpreferenceschanged','998',1543894545,'1',1543901745),(1103,'userpreferenceschanged','999',1543894545,'1',1543901745),(1104,'userpreferenceschanged','1000',1543894545,'1',1543901745),(1105,'userpreferenceschanged','1001',1543894545,'1',1543901745),(1106,'userpreferenceschanged','1002',1543894545,'1',1543901745),(1107,'userpreferenceschanged','1003',1543894545,'1',1543901745),(1108,'userpreferenceschanged','1004',1543894545,'1',1543901745),(1109,'userpreferenceschanged','1005',1543894545,'1',1543901745),(1110,'userpreferenceschanged','1006',1543894545,'1',1543901745),(1111,'userpreferenceschanged','1007',1543894545,'1',1543901745),(1112,'userpreferenceschanged','1008',1543894545,'1',1543901745),(1113,'userpreferenceschanged','1009',1543894545,'1',1543901745),(1114,'userpreferenceschanged','1010',1543894545,'1',1543901745),(1115,'userpreferenceschanged','1011',1543894545,'1',1543901745),(1116,'userpreferenceschanged','1012',1543894545,'1',1543901745),(1117,'userpreferenceschanged','1013',1543894545,'1',1543901745),(1118,'userpreferenceschanged','1014',1543894545,'1',1543901745),(1119,'userpreferenceschanged','1015',1543894545,'1',1543901745),(1120,'userpreferenceschanged','1016',1543894545,'1',1543901745),(1121,'userpreferenceschanged','1017',1543894545,'1',1543901745),(1122,'userpreferenceschanged','1018',1543894545,'1',1543901745),(1123,'userpreferenceschanged','1019',1543894545,'1',1543901745),(1124,'userpreferenceschanged','1020',1543894545,'1',1543901745),(1125,'userpreferenceschanged','1021',1543894545,'1',1543901745),(1126,'userpreferenceschanged','1022',1543894545,'1',1543901745),(1127,'userpreferenceschanged','1023',1543894545,'1',1543901745),(1128,'userpreferenceschanged','1024',1543894545,'1',1543901745),(1129,'userpreferenceschanged','1025',1543894545,'1',1543901745),(1130,'userpreferenceschanged','1026',1543894545,'1',1543901745),(1131,'userpreferenceschanged','1027',1543894545,'1',1543901745),(1132,'userpreferenceschanged','1028',1543894545,'1',1543901745),(1133,'userpreferenceschanged','1029',1543894545,'1',1543901745),(1134,'userpreferenceschanged','1030',1543894545,'1',1543901745),(1135,'userpreferenceschanged','1031',1543894545,'1',1543901745),(1136,'userpreferenceschanged','1032',1543894546,'1',1543901746),(1137,'userpreferenceschanged','1033',1543894546,'1',1543901746),(1138,'userpreferenceschanged','1034',1543894546,'1',1543901746),(1139,'userpreferenceschanged','1035',1543894546,'1',1543901746),(1140,'userpreferenceschanged','1036',1543894546,'1',1543901746),(1141,'userpreferenceschanged','1037',1543894546,'1',1543901746),(1142,'userpreferenceschanged','1038',1543894546,'1',1543901746),(1143,'userpreferenceschanged','1039',1543894546,'1',1543901746),(1144,'userpreferenceschanged','1040',1543894546,'1',1543901746),(1145,'userpreferenceschanged','1041',1543894546,'1',1543901746),(1146,'userpreferenceschanged','1042',1543894546,'1',1543901746),(1147,'userpreferenceschanged','1043',1543894546,'1',1543901746),(1148,'userpreferenceschanged','1044',1543894546,'1',1543901746),(1149,'userpreferenceschanged','1045',1543894546,'1',1543901746),(1150,'userpreferenceschanged','1046',1543894546,'1',1543901746),(1151,'userpreferenceschanged','1047',1543894546,'1',1543901746),(1152,'userpreferenceschanged','1048',1543894546,'1',1543901746),(1153,'userpreferenceschanged','1049',1543894546,'1',1543901746),(1154,'userpreferenceschanged','1050',1543894546,'1',1543901746),(1155,'userpreferenceschanged','1051',1543894546,'1',1543901746),(1156,'userpreferenceschanged','1052',1543894546,'1',1543901746),(1157,'userpreferenceschanged','1053',1543894546,'1',1543901746),(1158,'userpreferenceschanged','1054',1543894546,'1',1543901746),(1159,'userpreferenceschanged','1055',1543894546,'1',1543901746),(1160,'userpreferenceschanged','1056',1543894546,'1',1543901746),(1161,'userpreferenceschanged','1057',1543894546,'1',1543901746),(1162,'userpreferenceschanged','1058',1543894546,'1',1543901746),(1163,'userpreferenceschanged','1059',1543894546,'1',1543901746),(1164,'userpreferenceschanged','1060',1543894546,'1',1543901746),(1165,'userpreferenceschanged','1061',1543894546,'1',1543901746),(1166,'userpreferenceschanged','1062',1543894546,'1',1543901746),(1167,'userpreferenceschanged','1063',1543894546,'1',1543901746),(1168,'userpreferenceschanged','1064',1543894546,'1',1543901746),(1169,'userpreferenceschanged','1065',1543894546,'1',1543901746),(1170,'userpreferenceschanged','1066',1543894546,'1',1543901746),(1171,'userpreferenceschanged','1067',1543894546,'1',1543901746),(1172,'userpreferenceschanged','1068',1543894546,'1',1543901746),(1173,'userpreferenceschanged','1069',1543894546,'1',1543901746),(1174,'userpreferenceschanged','1070',1543894547,'1',1543901747),(1175,'userpreferenceschanged','1071',1543894547,'1',1543901747),(1176,'userpreferenceschanged','1072',1543894547,'1',1543901747),(1177,'userpreferenceschanged','1073',1543894547,'1',1543901747),(1178,'userpreferenceschanged','1074',1543894547,'1',1543901747),(1179,'userpreferenceschanged','1075',1543894547,'1',1543901747),(1180,'userpreferenceschanged','1076',1543894547,'1',1543901747),(1181,'userpreferenceschanged','1077',1543894547,'1',1543901747),(1182,'userpreferenceschanged','1078',1543894547,'1',1543901747),(1183,'userpreferenceschanged','1079',1543894547,'1',1543901747),(1184,'userpreferenceschanged','1080',1543894547,'1',1543901747),(1185,'userpreferenceschanged','1081',1543894547,'1',1543901747),(1186,'userpreferenceschanged','1082',1543894547,'1',1543901747),(1187,'userpreferenceschanged','1083',1543894547,'1',1543901747),(1188,'userpreferenceschanged','1084',1543894547,'1',1543901747),(1189,'userpreferenceschanged','1085',1543894547,'1',1543901747),(1190,'userpreferenceschanged','1086',1543894547,'1',1543901747),(1191,'userpreferenceschanged','1087',1543894547,'1',1543901747),(1192,'userpreferenceschanged','1088',1543894547,'1',1543901747),(1193,'userpreferenceschanged','1089',1543894547,'1',1543901747),(1194,'userpreferenceschanged','1090',1543894547,'1',1543901747),(1195,'userpreferenceschanged','1091',1543894547,'1',1543901747),(1196,'userpreferenceschanged','1092',1543894547,'1',1543901747),(1197,'userpreferenceschanged','1093',1543894547,'1',1543901747),(1198,'userpreferenceschanged','1094',1543894547,'1',1543901747),(1199,'userpreferenceschanged','1095',1543894547,'1',1543901747),(1200,'userpreferenceschanged','1096',1543894547,'1',1543901747),(1201,'userpreferenceschanged','1097',1543894547,'1',1543901747),(1202,'userpreferenceschanged','1098',1543894547,'1',1543901747),(1203,'userpreferenceschanged','1099',1543894547,'1',1543901747),(1204,'userpreferenceschanged','1100',1543894547,'1',1543901747),(1205,'userpreferenceschanged','1101',1543894547,'1',1543901747),(1206,'userpreferenceschanged','1102',1543894547,'1',1543901747),(1207,'userpreferenceschanged','1103',1543894548,'1',1543901748),(1208,'userpreferenceschanged','1104',1543894548,'1',1543901748),(1209,'userpreferenceschanged','1105',1543894548,'1',1543901748),(1210,'userpreferenceschanged','1106',1543894548,'1',1543901748),(1211,'userpreferenceschanged','1107',1543894548,'1',1543901748),(1212,'userpreferenceschanged','1108',1543894548,'1',1543901748),(1213,'userpreferenceschanged','1109',1543894548,'1',1543901748),(1214,'userpreferenceschanged','1110',1543894548,'1',1543901748),(1215,'userpreferenceschanged','1111',1543894548,'1',1543901748),(1216,'userpreferenceschanged','1112',1543894548,'1',1543901748),(1217,'userpreferenceschanged','1113',1543894548,'1',1543901748),(1218,'userpreferenceschanged','1114',1543894548,'1',1543901748),(1219,'userpreferenceschanged','1115',1543894548,'1',1543901748),(1220,'userpreferenceschanged','1116',1543894548,'1',1543901748),(1221,'userpreferenceschanged','1117',1543894548,'1',1543901748),(1222,'userpreferenceschanged','1118',1543894548,'1',1543901748),(1223,'userpreferenceschanged','1119',1543894548,'1',1543901748),(1224,'userpreferenceschanged','1120',1543894548,'1',1543901748),(1225,'userpreferenceschanged','1121',1543894548,'1',1543901748),(1226,'userpreferenceschanged','1122',1543894548,'1',1543901748),(1227,'userpreferenceschanged','1123',1543894548,'1',1543901748),(1228,'userpreferenceschanged','1124',1543894548,'1',1543901748),(1229,'userpreferenceschanged','1125',1543894548,'1',1543901748),(1230,'userpreferenceschanged','1126',1543894548,'1',1543901748),(1231,'userpreferenceschanged','1127',1544024969,'1',1544032169),(1232,'userpreferenceschanged','1128',1543894548,'1',1543901748),(1233,'userpreferenceschanged','1129',1543894548,'1',1543901748),(1234,'userpreferenceschanged','1130',1543894548,'1',1543901748),(1235,'userpreferenceschanged','1131',1543894549,'1',1543901749),(1236,'userpreferenceschanged','1132',1543894549,'1',1543901749),(1237,'userpreferenceschanged','1133',1543894549,'1',1543901749),(1238,'userpreferenceschanged','1134',1543894549,'1',1543901749),(1239,'userpreferenceschanged','1135',1543894549,'1',1543901749),(1240,'userpreferenceschanged','1136',1543894549,'1',1543901749),(1241,'userpreferenceschanged','1137',1543894549,'1',1543901749),(1242,'userpreferenceschanged','1138',1543894549,'1',1543901749),(1243,'userpreferenceschanged','1139',1543894549,'1',1543901749),(1244,'userpreferenceschanged','1140',1543894549,'1',1543901749),(1245,'userpreferenceschanged','1141',1543894549,'1',1543901749),(1246,'userpreferenceschanged','1142',1543894549,'1',1543901749),(1247,'userpreferenceschanged','1143',1543894549,'1',1543901749),(1248,'userpreferenceschanged','1144',1543894549,'1',1543901749),(1249,'userpreferenceschanged','1145',1543894549,'1',1543901749),(1250,'userpreferenceschanged','1146',1543894549,'1',1543901749),(1251,'userpreferenceschanged','1147',1543894549,'1',1543901749),(1252,'userpreferenceschanged','1148',1543894549,'1',1543901749),(1253,'userpreferenceschanged','1149',1543894549,'1',1543901749),(1254,'userpreferenceschanged','1150',1543894549,'1',1543901749),(1255,'userpreferenceschanged','1151',1543894549,'1',1543901749),(1256,'userpreferenceschanged','1152',1543894549,'1',1543901749),(1257,'userpreferenceschanged','1153',1543894549,'1',1543901749),(1258,'userpreferenceschanged','1154',1543894549,'1',1543901749),(1259,'userpreferenceschanged','1155',1543894549,'1',1543901749),(1260,'userpreferenceschanged','1156',1543894549,'1',1543901749),(1261,'userpreferenceschanged','1157',1543894549,'1',1543901749),(1262,'userpreferenceschanged','1158',1543894549,'1',1543901749),(1263,'userpreferenceschanged','1159',1543894549,'1',1543901749),(1264,'userpreferenceschanged','1160',1543894549,'1',1543901749),(1265,'userpreferenceschanged','1161',1543894549,'1',1543901749),(1266,'userpreferenceschanged','1162',1543894549,'1',1543901749),(1267,'userpreferenceschanged','1163',1543894549,'1',1543901749),(1268,'userpreferenceschanged','1164',1543894549,'1',1543901749),(1269,'userpreferenceschanged','1165',1543894550,'1',1543901750),(1270,'userpreferenceschanged','1166',1543894550,'1',1543901750),(1271,'userpreferenceschanged','1167',1543894550,'1',1543901750),(1272,'userpreferenceschanged','1168',1543894550,'1',1543901750),(1273,'userpreferenceschanged','1169',1543894550,'1',1543901750),(1274,'userpreferenceschanged','1170',1543894550,'1',1543901750),(1275,'userpreferenceschanged','1171',1543894550,'1',1543901750),(1276,'userpreferenceschanged','1172',1543894550,'1',1543901750),(1277,'userpreferenceschanged','1173',1543894550,'1',1543901750),(1278,'userpreferenceschanged','1174',1543894550,'1',1543901750),(1279,'userpreferenceschanged','1175',1543894550,'1',1543901750),(1280,'userpreferenceschanged','1176',1543894550,'1',1543901750),(1281,'userpreferenceschanged','1177',1543894550,'1',1543901750),(1282,'userpreferenceschanged','1178',1543894550,'1',1543901750),(1283,'userpreferenceschanged','1179',1543894550,'1',1543901750),(1284,'userpreferenceschanged','1180',1543894550,'1',1543901750),(1285,'userpreferenceschanged','1181',1543894550,'1',1543901750),(1286,'userpreferenceschanged','1182',1543894550,'1',1543901750),(1287,'userpreferenceschanged','1183',1543894550,'1',1543901750),(1288,'userpreferenceschanged','1184',1543894550,'1',1543901750),(1289,'userpreferenceschanged','1185',1543894550,'1',1543901750),(1290,'userpreferenceschanged','1186',1543894550,'1',1543901750),(1291,'userpreferenceschanged','1187',1543894550,'1',1543901750),(1292,'userpreferenceschanged','1188',1543894550,'1',1543901750),(1293,'userpreferenceschanged','1189',1543894550,'1',1543901750),(1294,'userpreferenceschanged','1190',1543894550,'1',1543901750),(1295,'userpreferenceschanged','1191',1543894550,'1',1543901750),(1296,'userpreferenceschanged','1192',1543894550,'1',1543901750),(1297,'userpreferenceschanged','1193',1543894551,'1',1543901751),(1298,'userpreferenceschanged','1194',1543894551,'1',1543901751),(1299,'userpreferenceschanged','1195',1543894551,'1',1543901751),(1300,'userpreferenceschanged','1196',1543894551,'1',1543901751),(1301,'userpreferenceschanged','1197',1543894551,'1',1543901751),(1302,'userpreferenceschanged','1198',1543894551,'1',1543901751),(1303,'userpreferenceschanged','1199',1543894551,'1',1543901751),(1304,'userpreferenceschanged','1200',1543894551,'1',1543901751),(1305,'userpreferenceschanged','1201',1543894551,'1',1543901751),(1306,'userpreferenceschanged','1202',1543894551,'1',1543901751),(1307,'userpreferenceschanged','1203',1543894551,'1',1543901751),(1308,'userpreferenceschanged','1204',1543894551,'1',1543901751),(1309,'userpreferenceschanged','1205',1543894551,'1',1543901751),(1310,'userpreferenceschanged','1206',1543894551,'1',1543901751),(1311,'userpreferenceschanged','1207',1543894551,'1',1543901751),(1312,'userpreferenceschanged','1208',1543894551,'1',1543901751),(1313,'userpreferenceschanged','1209',1543894551,'1',1543901751),(1314,'userpreferenceschanged','1210',1543894551,'1',1543901751),(1315,'userpreferenceschanged','1211',1543894551,'1',1543901751),(1316,'userpreferenceschanged','1212',1543894551,'1',1543901751),(1317,'userpreferenceschanged','1213',1543894551,'1',1543901751),(1318,'userpreferenceschanged','1214',1543894551,'1',1543901751),(1319,'userpreferenceschanged','1215',1543894551,'1',1543901751),(1320,'userpreferenceschanged','1216',1543894551,'1',1543901751),(1321,'userpreferenceschanged','1217',1543894551,'1',1543901751),(1322,'userpreferenceschanged','1218',1543894551,'1',1543901751),(1323,'userpreferenceschanged','1219',1543894551,'1',1543901751),(1324,'userpreferenceschanged','1220',1543894551,'1',1543901751),(1325,'userpreferenceschanged','1221',1543894551,'1',1543901751),(1326,'userpreferenceschanged','1222',1543894551,'1',1543901751),(1327,'userpreferenceschanged','1223',1543894551,'1',1543901751),(1328,'userpreferenceschanged','1224',1543894551,'1',1543901751),(1329,'userpreferenceschanged','1225',1543894551,'1',1543901751),(1330,'userpreferenceschanged','1226',1543894551,'1',1543901751),(1331,'userpreferenceschanged','1227',1543894551,'1',1543901751),(1332,'userpreferenceschanged','1228',1543894551,'1',1543901751),(1333,'userpreferenceschanged','1229',1543894551,'1',1543901751),(1334,'userpreferenceschanged','1230',1543894551,'1',1543901751),(1335,'userpreferenceschanged','1231',1543894552,'1',1543901752),(1336,'userpreferenceschanged','1232',1543894552,'1',1543901752),(1337,'userpreferenceschanged','1233',1543894552,'1',1543901752),(1338,'userpreferenceschanged','1234',1543894552,'1',1543901752),(1339,'userpreferenceschanged','1235',1543894552,'1',1543901752),(1340,'userpreferenceschanged','1236',1543894552,'1',1543901752),(1341,'userpreferenceschanged','1237',1543894552,'1',1543901752),(1342,'userpreferenceschanged','1238',1543894552,'1',1543901752),(1343,'userpreferenceschanged','1239',1543894552,'1',1543901752),(1344,'userpreferenceschanged','1240',1543894552,'1',1543901752),(1345,'userpreferenceschanged','1241',1543894552,'1',1543901752),(1346,'userpreferenceschanged','1242',1543894552,'1',1543901752),(1347,'userpreferenceschanged','1243',1543894552,'1',1543901752),(1348,'userpreferenceschanged','1244',1543894552,'1',1543901752),(1349,'userpreferenceschanged','1245',1543894552,'1',1543901752),(1350,'userpreferenceschanged','1246',1543894552,'1',1543901752),(1351,'userpreferenceschanged','1247',1543894552,'1',1543901752),(1352,'userpreferenceschanged','1248',1543894552,'1',1543901752),(1353,'userpreferenceschanged','1249',1543894552,'1',1543901752),(1354,'userpreferenceschanged','1250',1543894552,'1',1543901752),(1355,'userpreferenceschanged','1251',1543894552,'1',1543901752),(1356,'userpreferenceschanged','1252',1543894552,'1',1543901752),(1357,'userpreferenceschanged','1253',1543894552,'1',1543901752),(1358,'userpreferenceschanged','1254',1543894552,'1',1543901752),(1359,'userpreferenceschanged','1255',1543894552,'1',1543901752),(1360,'userpreferenceschanged','1256',1543894552,'1',1543901752),(1361,'userpreferenceschanged','1257',1543894552,'1',1543901752),(1362,'userpreferenceschanged','1258',1543894552,'1',1543901752),(1363,'userpreferenceschanged','1259',1543894552,'1',1543901752),(1364,'userpreferenceschanged','1260',1543894552,'1',1543901752),(1365,'userpreferenceschanged','1261',1543894552,'1',1543901752),(1366,'userpreferenceschanged','1262',1543894552,'1',1543901752),(1367,'userpreferenceschanged','1263',1543894552,'1',1543901752),(1368,'userpreferenceschanged','1264',1543894552,'1',1543901752),(1369,'userpreferenceschanged','1265',1543894552,'1',1543901752),(1370,'userpreferenceschanged','1266',1543894552,'1',1543901752),(1371,'userpreferenceschanged','1267',1543894552,'1',1543901752),(1372,'userpreferenceschanged','1268',1543894552,'1',1543901752),(1373,'userpreferenceschanged','1269',1543894552,'1',1543901752),(1374,'userpreferenceschanged','1270',1543894553,'1',1543901753),(1375,'userpreferenceschanged','1271',1543894553,'1',1543901753),(1376,'userpreferenceschanged','1272',1543894553,'1',1543901753),(1377,'userpreferenceschanged','1273',1543894553,'1',1543901753),(1378,'userpreferenceschanged','1274',1543894553,'1',1543901753),(1379,'userpreferenceschanged','1275',1543894553,'1',1543901753),(1380,'userpreferenceschanged','1276',1543894553,'1',1543901753),(1381,'userpreferenceschanged','1277',1543894553,'1',1543901753),(1382,'userpreferenceschanged','1278',1543894553,'1',1543901753),(1383,'userpreferenceschanged','1279',1543894553,'1',1543901753),(1384,'userpreferenceschanged','1280',1543894553,'1',1543901753),(1385,'userpreferenceschanged','1281',1543894553,'1',1543901753),(1386,'userpreferenceschanged','1282',1543894553,'1',1543901753),(1387,'userpreferenceschanged','1283',1543894553,'1',1543901753),(1388,'userpreferenceschanged','1284',1543894553,'1',1543901753),(1389,'userpreferenceschanged','1285',1543894553,'1',1543901753),(1390,'userpreferenceschanged','1286',1543894553,'1',1543901753),(1391,'userpreferenceschanged','1287',1543894553,'1',1543901753),(1392,'userpreferenceschanged','1288',1543894553,'1',1543901753),(1393,'userpreferenceschanged','1289',1543894553,'1',1543901753),(1394,'userpreferenceschanged','1290',1543894553,'1',1543901753),(1395,'userpreferenceschanged','1291',1543894553,'1',1543901753),(1396,'userpreferenceschanged','1292',1543894553,'1',1543901753),(1397,'userpreferenceschanged','1293',1543894553,'1',1543901753),(1398,'userpreferenceschanged','1294',1543894553,'1',1543901753),(1399,'userpreferenceschanged','1295',1543894553,'1',1543901753),(1400,'userpreferenceschanged','1296',1543894553,'1',1543901753),(1401,'userpreferenceschanged','1297',1543894553,'1',1543901753),(1402,'userpreferenceschanged','1298',1543894553,'1',1543901753),(1403,'userpreferenceschanged','1299',1543894553,'1',1543901753),(1404,'userpreferenceschanged','1300',1543894553,'1',1543901753),(1405,'userpreferenceschanged','1301',1543894553,'1',1543901753),(1406,'userpreferenceschanged','1302',1543894553,'1',1543901753),(1407,'userpreferenceschanged','1303',1543894553,'1',1543901753),(1408,'userpreferenceschanged','1304',1543894553,'1',1543901753),(1409,'userpreferenceschanged','1305',1543894554,'1',1543901754),(1410,'userpreferenceschanged','1306',1543894554,'1',1543901754),(1411,'userpreferenceschanged','1307',1543894554,'1',1543901754),(1412,'userpreferenceschanged','1308',1543894554,'1',1543901754),(1413,'userpreferenceschanged','1309',1543894554,'1',1543901754),(1414,'userpreferenceschanged','1310',1543894554,'1',1543901754),(1415,'userpreferenceschanged','1311',1543894554,'1',1543901754),(1416,'userpreferenceschanged','1312',1543894554,'1',1543901754),(1417,'userpreferenceschanged','1313',1543894554,'1',1543901754),(1418,'userpreferenceschanged','1314',1543894554,'1',1543901754),(1419,'userpreferenceschanged','1315',1543894554,'1',1543901754),(1420,'userpreferenceschanged','1316',1543894554,'1',1543901754),(1421,'userpreferenceschanged','1317',1543894554,'1',1543901754),(1422,'userpreferenceschanged','1318',1543894554,'1',1543901754),(1423,'userpreferenceschanged','1319',1543894554,'1',1543901754),(1424,'userpreferenceschanged','1320',1543894554,'1',1543901754),(1425,'userpreferenceschanged','1321',1543894554,'1',1543901754),(1426,'userpreferenceschanged','1322',1543894554,'1',1543901754),(1427,'userpreferenceschanged','1323',1543894554,'1',1543901754),(1428,'userpreferenceschanged','1324',1543894554,'1',1543901754),(1429,'userpreferenceschanged','1325',1543894554,'1',1543901754),(1430,'userpreferenceschanged','1326',1543894554,'1',1543901754),(1431,'userpreferenceschanged','1327',1543894554,'1',1543901754),(1432,'userpreferenceschanged','1328',1543894554,'1',1543901754),(1433,'userpreferenceschanged','1329',1543894554,'1',1543901754),(1434,'userpreferenceschanged','1330',1543894554,'1',1543901754),(1435,'userpreferenceschanged','1331',1543894554,'1',1543901754),(1436,'userpreferenceschanged','1332',1543894554,'1',1543901754),(1437,'userpreferenceschanged','1333',1543894554,'1',1543901754),(1438,'userpreferenceschanged','1334',1543894554,'1',1543901754),(1439,'userpreferenceschanged','1335',1543894554,'1',1543901754),(1440,'userpreferenceschanged','1336',1543894554,'1',1543901754),(1441,'userpreferenceschanged','1337',1543894554,'1',1543901754),(1442,'userpreferenceschanged','1338',1543894555,'1',1543901755),(1443,'userpreferenceschanged','1339',1543894555,'1',1543901755),(1444,'userpreferenceschanged','1340',1543894555,'1',1543901755),(1445,'userpreferenceschanged','1341',1543894555,'1',1543901755),(1446,'userpreferenceschanged','1342',1543894555,'1',1543901755),(1447,'userpreferenceschanged','1343',1543894555,'1',1543901755),(1448,'userpreferenceschanged','1344',1543894555,'1',1543901755),(1449,'userpreferenceschanged','1345',1543894555,'1',1543901755),(1450,'userpreferenceschanged','1346',1543894555,'1',1543901755),(1451,'userpreferenceschanged','1347',1543894555,'1',1543901755),(1452,'userpreferenceschanged','1348',1543894555,'1',1543901755),(1453,'userpreferenceschanged','1349',1543894555,'1',1543901755),(1454,'userpreferenceschanged','1350',1543894555,'1',1543901755),(1455,'userpreferenceschanged','1351',1543894555,'1',1543901755),(1456,'userpreferenceschanged','1352',1543894555,'1',1543901755),(1457,'userpreferenceschanged','1353',1543894555,'1',1543901755),(1458,'userpreferenceschanged','1354',1543894555,'1',1543901755),(1459,'userpreferenceschanged','1355',1543894555,'1',1543901755),(1460,'userpreferenceschanged','1356',1543894555,'1',1543901755),(1461,'userpreferenceschanged','1357',1543894555,'1',1543901755),(1462,'userpreferenceschanged','1358',1543894555,'1',1543901755),(1463,'userpreferenceschanged','1359',1543894555,'1',1543901755),(1464,'userpreferenceschanged','1360',1543894555,'1',1543901755),(1465,'userpreferenceschanged','1361',1543894555,'1',1543901755),(1466,'userpreferenceschanged','1362',1543894555,'1',1543901755),(1467,'userpreferenceschanged','1363',1543894555,'1',1543901755),(1468,'userpreferenceschanged','1364',1543894555,'1',1543901755),(1469,'userpreferenceschanged','1365',1543894555,'1',1543901755),(1470,'userpreferenceschanged','1366',1543894556,'1',1543901756),(1471,'userpreferenceschanged','1367',1543894556,'1',1543901756),(1472,'userpreferenceschanged','1368',1543894556,'1',1543901756),(1473,'userpreferenceschanged','1369',1543894556,'1',1543901756),(1474,'userpreferenceschanged','1370',1543894556,'1',1543901756),(1475,'userpreferenceschanged','1371',1543894556,'1',1543901756),(1476,'userpreferenceschanged','1372',1543894556,'1',1543901756),(1477,'userpreferenceschanged','1373',1543894556,'1',1543901756),(1478,'userpreferenceschanged','1374',1543894556,'1',1543901756),(1479,'userpreferenceschanged','1375',1543894556,'1',1543901756),(1480,'userpreferenceschanged','1376',1543894556,'1',1543901756),(1481,'userpreferenceschanged','1377',1543894556,'1',1543901756),(1482,'userpreferenceschanged','1378',1543894556,'1',1543901756),(1483,'userpreferenceschanged','1379',1543894556,'1',1543901756),(1484,'userpreferenceschanged','1380',1543894556,'1',1543901756),(1485,'userpreferenceschanged','1381',1543894556,'1',1543901756),(1486,'userpreferenceschanged','1382',1543894556,'1',1543901756),(1487,'userpreferenceschanged','1383',1543894556,'1',1543901756),(1488,'userpreferenceschanged','1384',1543894556,'1',1543901756),(1489,'userpreferenceschanged','1385',1543894556,'1',1543901756),(1490,'userpreferenceschanged','1386',1543894556,'1',1543901756),(1491,'userpreferenceschanged','1387',1543894556,'1',1543901756),(1492,'userpreferenceschanged','1388',1543894556,'1',1543901756),(1493,'userpreferenceschanged','1389',1543894556,'1',1543901756),(1494,'userpreferenceschanged','1390',1543894556,'1',1543901756),(1495,'userpreferenceschanged','1391',1543894556,'1',1543901756),(1496,'userpreferenceschanged','1392',1543894556,'1',1543901756),(1497,'userpreferenceschanged','1393',1543894556,'1',1543901756),(1498,'userpreferenceschanged','1394',1543894556,'1',1543901756),(1499,'userpreferenceschanged','1395',1543894556,'1',1543901756),(1500,'userpreferenceschanged','1396',1543894556,'1',1543901756),(1501,'userpreferenceschanged','1397',1543894556,'1',1543901756),(1502,'userpreferenceschanged','1398',1543894556,'1',1543901756),(1503,'userpreferenceschanged','1399',1543894556,'1',1543901756),(1504,'userpreferenceschanged','1400',1543894556,'1',1543901756),(1505,'userpreferenceschanged','1401',1543894557,'1',1543901757),(1506,'userpreferenceschanged','1402',1543894557,'1',1543901757),(1507,'userpreferenceschanged','1403',1543894557,'1',1543901757),(1508,'userpreferenceschanged','1404',1543894557,'1',1543901757),(1509,'userpreferenceschanged','1405',1543894557,'1',1543901757),(1510,'accesslib/dirtycontexts','/1/3/133/134',1543966901,'1',1543974101),(1511,'accesslib/dirtycontexts','/1/3/133/135',1543966901,'1',1543974101),(1512,'accesslib/dirtycontexts','/1/3/1529',1543968795,'1',1543975995),(1513,'accesslib/dirtycontexts','/1/3/1531',1543967042,'1',1543974242),(1514,'userpreferenceschanged','1406',1544023851,'1',1544031051);

--
-- Table structure for table `mdl0i_capabilities`
--

CREATE TABLE `mdl0i_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 `mdl0i_capa_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=625 DEFAULT CHARSET=utf8 COMMENT='this defines all capabilities';

--
-- Dumping data for table `mdl0i_capabilities`
--

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

--
-- Table structure for table `mdl0i_certificate`
--

CREATE TABLE `mdl0i_certificate` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext,
  `introformat` smallint(4) NOT NULL DEFAULT '0',
  `emailteachers` tinyint(1) NOT NULL DEFAULT '0',
  `emailothers` longtext,
  `savecert` tinyint(1) NOT NULL DEFAULT '0',
  `reportcert` tinyint(1) NOT NULL DEFAULT '0',
  `delivery` smallint(3) NOT NULL DEFAULT '0',
  `requiredtime` bigint(10) NOT NULL DEFAULT '0',
  `certificatetype` varchar(50) NOT NULL DEFAULT '',
  `orientation` varchar(10) NOT NULL DEFAULT '',
  `borderstyle` varchar(255) NOT NULL DEFAULT '0',
  `bordercolor` varchar(30) NOT NULL DEFAULT '0',
  `printwmark` varchar(255) NOT NULL DEFAULT '0',
  `printdate` bigint(10) NOT NULL DEFAULT '0',
  `datefmt` bigint(10) NOT NULL DEFAULT '0',
  `printnumber` tinyint(1) NOT NULL DEFAULT '0',
  `printgrade` bigint(10) NOT NULL DEFAULT '0',
  `gradefmt` bigint(10) NOT NULL DEFAULT '0',
  `printoutcome` bigint(10) NOT NULL DEFAULT '0',
  `printhours` varchar(255) DEFAULT NULL,
  `printteacher` bigint(10) NOT NULL DEFAULT '0',
  `customtext` longtext,
  `printsignature` varchar(255) NOT NULL DEFAULT '0',
  `printseal` varchar(255) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED COMMENT='Defines certificates';

--
-- Dumping data for table `mdl0i_certificate`
--

INSERT INTO `mdl0i_certificate` VALUES (2,5,'Certificado','',1,0,'',0,0,0,0,'A4_non_embedded','L','Fancy1-black.jpg','0','0',0,1,0,0,1,0,'',0,'','0','0',1539804883,1539804883),(3,4,'Certificado','',1,0,'',0,0,0,0,'A4_non_embedded','L','Fancy1-black.jpg','0','0',0,1,0,0,1,0,'',0,'','0','0',1539804935,1539804935);

--
-- Table structure for table `mdl0i_certificate_issues`
--

CREATE TABLE `mdl0i_certificate_issues` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `certificateid` bigint(10) NOT NULL DEFAULT '0',
  `code` varchar(40) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Info about issued certificates';

--
-- Dumping data for table `mdl0i_certificate_issues`
--

INSERT INTO `mdl0i_certificate_issues` VALUES (1,2,1,'5mUAmUaL2o',1538701955),(2,12,2,'1eu1pnornj',1539804884),(3,12,3,'oQdnyVmQom',1539804935),(4,2,2,'hjjPYKzzHW',1539973554),(5,2,3,'nNqUvmt9GX',1540820495);

--
-- Table structure for table `mdl0i_chat`
--

CREATE TABLE `mdl0i_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 `mdl0i_chat_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Each of these is a chat room';

--
-- Dumping data for table `mdl0i_chat`
--


--
-- Table structure for table `mdl0i_chat_messages`
--

CREATE TABLE `mdl0i_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 `mdl0i_chatmess_use_ix` (`userid`),
  KEY `mdl0i_chatmess_gro_ix` (`groupid`),
  KEY `mdl0i_chatmess_timcha_ix` (`timestamp`,`chatid`),
  KEY `mdl0i_chatmess_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores all the actual chat messages';

--
-- Dumping data for table `mdl0i_chat_messages`
--


--
-- Table structure for table `mdl0i_chat_messages_current`
--

CREATE TABLE `mdl0i_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 `mdl0i_chatmesscurr_use_ix` (`userid`),
  KEY `mdl0i_chatmesscurr_gro_ix` (`groupid`),
  KEY `mdl0i_chatmesscurr_timcha_ix` (`timestamp`,`chatid`),
  KEY `mdl0i_chatmesscurr_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores current session';

--
-- Dumping data for table `mdl0i_chat_messages_current`
--


--
-- Table structure for table `mdl0i_chat_users`
--

CREATE TABLE `mdl0i_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 `mdl0i_chatuser_use_ix` (`userid`),
  KEY `mdl0i_chatuser_las_ix` (`lastping`),
  KEY `mdl0i_chatuser_gro_ix` (`groupid`),
  KEY `mdl0i_chatuser_cha_ix` (`chatid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Keeps track of which users are in which chat rooms';

--
-- Dumping data for table `mdl0i_chat_users`
--


--
-- Table structure for table `mdl0i_choice`
--

CREATE TABLE `mdl0i_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',
  PRIMARY KEY (`id`),
  KEY `mdl0i_choi_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Available choices are stored here';

--
-- Dumping data for table `mdl0i_choice`
--


--
-- Table structure for table `mdl0i_choice_answers`
--

CREATE TABLE `mdl0i_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 `mdl0i_choiansw_use_ix` (`userid`),
  KEY `mdl0i_choiansw_cho_ix` (`choiceid`),
  KEY `mdl0i_choiansw_opt_ix` (`optionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='choices performed by users';

--
-- Dumping data for table `mdl0i_choice_answers`
--


--
-- Table structure for table `mdl0i_choice_options`
--

CREATE TABLE `mdl0i_choice_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `choiceid` bigint(10) NOT NULL DEFAULT '0',
  `text` longtext,
  `maxanswers` bigint(10) DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl0i_choiopti_cho_ix` (`choiceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='available options to choice';

--
-- Dumping data for table `mdl0i_choice_options`
--


--
-- Table structure for table `mdl0i_cohort`
--

CREATE TABLE `mdl0i_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,
  `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 `mdl0i_coho_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Each record represents one cohort (aka site-wide group).';

--
-- Dumping data for table `mdl0i_cohort`
--


--
-- Table structure for table `mdl0i_cohort_members`
--

CREATE TABLE `mdl0i_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 `mdl0i_cohomemb_cohuse_uix` (`cohortid`,`userid`),
  KEY `mdl0i_cohomemb_coh_ix` (`cohortid`),
  KEY `mdl0i_cohomemb_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link a user to a cohort.';

--
-- Dumping data for table `mdl0i_cohort_members`
--


--
-- Table structure for table `mdl0i_comments`
--

CREATE TABLE `mdl0i_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 `mdl0i_comm_concomite_ix` (`contextid`,`commentarea`,`itemid`),
  KEY `mdl0i_comm_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='moodle comments module';

--
-- Dumping data for table `mdl0i_comments`
--


--
-- Table structure for table `mdl0i_competency`
--

CREATE TABLE `mdl0i_competency` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(100) DEFAULT NULL,
  `description` longtext,
  `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,
  `scaleid` bigint(10) DEFAULT NULL,
  `scaleconfiguration` longtext,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl0i_comp_comidn_uix` (`competencyframeworkid`,`idnumber`),
  KEY `mdl0i_comp_rul_ix` (`ruleoutcome`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table contains the master record of each competency in ';

--
-- Dumping data for table `mdl0i_competency`
--


--
-- Table structure for table `mdl0i_competency_coursecomp`
--

CREATE TABLE `mdl0i_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 `mdl0i_compcour_coucom_uix` (`courseid`,`competencyid`),
  KEY `mdl0i_compcour_courul_ix` (`courseid`,`ruleoutcome`),
  KEY `mdl0i_compcour_cou2_ix` (`courseid`),
  KEY `mdl0i_compcour_com_ix` (`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link a competency to a course.';

--
-- Dumping data for table `mdl0i_competency_coursecomp`
--


--
-- Table structure for table `mdl0i_competency_coursecompsetting`
--

CREATE TABLE `mdl0i_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 `mdl0i_compcour_cou_uix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table contains the course specific settings for compete';

--
-- Dumping data for table `mdl0i_competency_coursecompsetting`
--


--
-- Table structure for table `mdl0i_competency_evidence`
--

CREATE TABLE `mdl0i_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,
  `url` varchar(255) DEFAULT NULL,
  `grade` bigint(10) DEFAULT NULL,
  `note` longtext,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl0i_compevid_use_ix` (`usercompetencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The evidence linked to a user competency';

--
-- Dumping data for table `mdl0i_competency_evidence`
--


--
-- Table structure for table `mdl0i_competency_framework`
--

CREATE TABLE `mdl0i_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,
  `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 `mdl0i_compfram_idn_uix` (`idnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List of competency frameworks.';

--
-- Dumping data for table `mdl0i_competency_framework`
--


--
-- Table structure for table `mdl0i_competency_modulecomp`
--

CREATE TABLE `mdl0i_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 `mdl0i_compmodu_cmicom_uix` (`cmid`,`competencyid`),
  KEY `mdl0i_compmodu_cmirul_ix` (`cmid`,`ruleoutcome`),
  KEY `mdl0i_compmodu_cmi_ix` (`cmid`),
  KEY `mdl0i_compmodu_com_ix` (`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link a competency to a module.';

--
-- Dumping data for table `mdl0i_competency_modulecomp`
--


--
-- Table structure for table `mdl0i_competency_plan`
--

CREATE TABLE `mdl0i_competency_plan` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` longtext,
  `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 `mdl0i_compplan_usesta_ix` (`userid`,`status`),
  KEY `mdl0i_compplan_tem_ix` (`templateid`),
  KEY `mdl0i_compplan_stadue_ix` (`status`,`duedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Learning plans';

--
-- Dumping data for table `mdl0i_competency_plan`
--


--
-- Table structure for table `mdl0i_competency_plancomp`
--

CREATE TABLE `mdl0i_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 `mdl0i_compplan_placom_uix` (`planid`,`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Plan competencies';

--
-- Dumping data for table `mdl0i_competency_plancomp`
--


--
-- Table structure for table `mdl0i_competency_relatedcomp`
--

CREATE TABLE `mdl0i_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=utf8 COMMENT='Related competencies';

--
-- Dumping data for table `mdl0i_competency_relatedcomp`
--


--
-- Table structure for table `mdl0i_competency_template`
--

CREATE TABLE `mdl0i_competency_template` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(100) DEFAULT NULL,
  `contextid` bigint(10) NOT NULL,
  `description` longtext,
  `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=utf8 COMMENT='Learning plan templates.';

--
-- Dumping data for table `mdl0i_competency_template`
--


--
-- Table structure for table `mdl0i_competency_templatecohort`
--

CREATE TABLE `mdl0i_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 `mdl0i_comptemp_temcoh_uix` (`templateid`,`cohortid`),
  KEY `mdl0i_comptemp_tem2_ix` (`templateid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Default comment for the table, please edit me';

--
-- Dumping data for table `mdl0i_competency_templatecohort`
--


--
-- Table structure for table `mdl0i_competency_templatecomp`
--

CREATE TABLE `mdl0i_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 `mdl0i_comptemp_tem_ix` (`templateid`),
  KEY `mdl0i_comptemp_com_ix` (`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link a competency to a learning plan template.';

--
-- Dumping data for table `mdl0i_competency_templatecomp`
--


--
-- Table structure for table `mdl0i_competency_usercomp`
--

CREATE TABLE `mdl0i_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 `mdl0i_compuser_usecom_uix` (`userid`,`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='User competencies';

--
-- Dumping data for table `mdl0i_competency_usercomp`
--


--
-- Table structure for table `mdl0i_competency_usercompcourse`
--

CREATE TABLE `mdl0i_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 `mdl0i_compuser_usecoucom_uix` (`userid`,`courseid`,`competencyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='User competencies in a course';

--
-- Dumping data for table `mdl0i_competency_usercompcourse`
--


--
-- Table structure for table `mdl0i_competency_usercompplan`
--

CREATE TABLE `mdl0i_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 `mdl0i_compuser_usecompla_uix` (`userid`,`competencyid`,`planid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='User competencies plans';

--
-- Dumping data for table `mdl0i_competency_usercompplan`
--


--
-- Table structure for table `mdl0i_competency_userevidence`
--

CREATE TABLE `mdl0i_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 `mdl0i_compuser_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The evidence of prior learning';

--
-- Dumping data for table `mdl0i_competency_userevidence`
--


--
-- Table structure for table `mdl0i_competency_userevidencecomp`
--

CREATE TABLE `mdl0i_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 `mdl0i_compuser_usecom2_uix` (`userevidenceid`,`competencyid`),
  KEY `mdl0i_compuser_use2_ix` (`userevidenceid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Relationship between user evidence and competencies';

--
-- Dumping data for table `mdl0i_competency_userevidencecomp`
--


--
-- Table structure for table `mdl0i_config`
--

CREATE TABLE `mdl0i_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl0i_conf_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=496 DEFAULT CHARSET=utf8 COMMENT='Moodle configuration variables';

--
-- Dumping data for table `mdl0i_config`
--

INSERT INTO `mdl0i_config` VALUES (2,'rolesactive','1'),(3,'auth','email'),(4,'enrol_plugins_enabled','manual,guest,self,cohort'),(5,'theme','moove'),(6,'filter_multilang_converted','1'),(7,'siteidentifier','akamjaoe51g5c6ikhjfadya0k4l3gg3ydlhplataforma.com'),(8,'backup_version','2018051400'),(9,'backup_release','3.5'),(10,'mnet_dispatcher_mode','off'),(11,'sessiontimeout','7200'),(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','1544027707'),(25,'jsrev','1544027707'),(26,'gdversion','2'),(27,'licenses','unknown,allrightsreserved,public,cc,cc-nd,cc-nc-nd,cc-nc,cc-nc-sa,cc-sa'),(28,'version','2018051702'),(29,'enableoutcomes','0'),(30,'usecomments','1'),(31,'usetags','1'),(32,'enablenotes','1'),(33,'enableportfolios','0'),(34,'enablewebservices','0'),(35,'messaging','1'),(36,'messaginghidereadnotifications','0'),(37,'messagingdeletereadnotificationsdelay','604800'),(38,'messagingallowemailoverride','0'),(39,'enablestats','0'),(40,'enablerssfeeds','0'),(41,'enableblogs','1'),(42,'enablecompletion','1'),(43,'completiondefault','1'),(44,'enableavailability','1'),(45,'enableplagiarism','0'),(46,'enablebadges','1'),(47,'enableglobalsearch','0'),(48,'allowstealth','0'),(49,'defaultpreference_maildisplay','2'),(50,'defaultpreference_mailformat','1'),(51,'defaultpreference_maildigest','0'),(52,'defaultpreference_autosubscribe','1'),(53,'defaultpreference_trackforums','0'),(54,'autologinguests','0'),(55,'hiddenuserfields',''),(56,'showuseridentity','email'),(57,'fullnamedisplay','language'),(58,'alternativefullnameformat','language'),(59,'maxusersperpage','100'),(60,'enablegravatar','0'),(61,'gravatardefaulturl','mm'),(62,'agedigitalconsentverification','0'),(63,'agedigitalconsentmap','*, 16\nAT, 14\nES, 14\nUS, 13'),(64,'sitepolicy',''),(65,'sitepolicyguest',''),(66,'enablecourserequests','0'),(67,'defaultrequestcategory','1'),(68,'requestcategoryselection','0'),(69,'courserequestnotify',''),(70,'grade_profilereport','user'),(71,'grade_aggregationposition','1'),(72,'grade_includescalesinaggregation','1'),(73,'grade_hiddenasdate','0'),(74,'gradepublishing','0'),(75,'grade_export_exportfeedback','0'),(76,'grade_export_displaytype','1'),(77,'grade_export_decimalpoints','2'),(78,'grade_navmethod','1'),(79,'grade_export_userprofilefields','firstname,lastname,idnumber,institution,department,email'),(80,'grade_export_customprofilefields',''),(81,'recovergradesdefault','0'),(82,'gradeexport',''),(83,'unlimitedgrades','0'),(84,'grade_report_showmin','1'),(85,'gradepointmax','100'),(86,'gradepointdefault','100'),(87,'grade_minmaxtouse','1'),(88,'grade_mygrades_report','overview'),(89,'gradereport_mygradeurl',''),(90,'grade_hideforcedsettings','1'),(91,'grade_aggregation','13'),(92,'grade_aggregation_flag','0'),(93,'grade_aggregations_visible','13'),(94,'grade_aggregateonlygraded','1'),(95,'grade_aggregateonlygraded_flag','2'),(96,'grade_aggregateoutcomes','0'),(97,'grade_aggregateoutcomes_flag','2'),(98,'grade_keephigh','0'),(99,'grade_keephigh_flag','3'),(100,'grade_droplow','0'),(101,'grade_droplow_flag','2'),(102,'grade_overridecat','1'),(103,'grade_displaytype','1'),(104,'grade_decimalpoints','2'),(105,'grade_item_advanced','iteminfo,idnumber,gradepass,plusfactor,multfactor,display,decimals,hiddenuntil,locktime'),(106,'grade_report_studentsperpage','100'),(107,'grade_report_showonlyactiveenrol','1'),(108,'grade_report_quickgrading','1'),(109,'grade_report_showquickfeedback','0'),(110,'grade_report_meanselection','1'),(111,'grade_report_enableajax','0'),(112,'grade_report_showcalculations','1'),(113,'grade_report_showeyecons','0'),(114,'grade_report_showaverages','1'),(115,'grade_report_showlocks','0'),(116,'grade_report_showranges','0'),(117,'grade_report_showanalysisicon','1'),(118,'grade_report_showuserimage','1'),(119,'grade_report_showactivityicons','1'),(120,'grade_report_shownumberofgrades','0'),(121,'grade_report_averagesdisplaytype','inherit'),(122,'grade_report_rangesdisplaytype','inherit'),(123,'grade_report_averagesdecimalpoints','inherit'),(124,'grade_report_rangesdecimalpoints','inherit'),(125,'grade_report_historyperpage','50'),(126,'grade_report_overview_showrank','0'),(127,'grade_report_overview_showtotalsifcontainhidden','0'),(128,'grade_report_user_showrank','0'),(129,'grade_report_user_showpercentage','1'),(130,'grade_report_user_showgrade','1'),(131,'grade_report_user_showfeedback','1'),(132,'grade_report_user_showrange','1'),(133,'grade_report_user_showweight','1'),(134,'grade_report_user_showaverage','0'),(135,'grade_report_user_showlettergrade','0'),(136,'grade_report_user_rangedecimals','0'),(137,'grade_report_user_showhiddenitems','1'),(138,'grade_report_user_showtotalsifcontainhidden','0'),(139,'grade_report_user_showcontributiontocoursetotal','1'),(140,'badges_defaultissuername','Digital Learning Hub'),(141,'badges_defaultissuercontact','sistemas@dlh.com.pe'),(142,'badges_badgesalt','badges1538674447'),(143,'badges_allowexternalbackpack','1'),(144,'badges_allowcoursebadges','1'),(146,'forcetimezone','99'),(147,'country','0'),(148,'defaultcity',''),(149,'geoip2file','/home/dlhplata/plataformadata/geoip/GeoLite2-City.mmdb'),(150,'googlemapkey3',''),(151,'allcountrycodes',''),(152,'autolang','1'),(153,'lang','es'),(154,'langmenu','1'),(155,'langlist',''),(156,'langrev','1544027707'),(157,'langcache','1'),(158,'langstringcache','1'),(159,'locale',''),(160,'latinexcelexport','0'),(161,'requiremodintro','0'),(163,'authloginviaemail','0'),(164,'allowaccountssameemail','0'),(165,'authpreventaccountcreation','0'),(166,'loginpageautofocus','0'),(167,'guestloginbutton','1'),(168,'limitconcurrentlogins','0'),(169,'alternateloginurl',''),(170,'forgottenpasswordurl',''),(171,'auth_instructions',''),(172,'allowemailaddresses',''),(173,'denyemailaddresses',''),(174,'verifychangedemail','1'),(175,'recaptchapublickey',''),(176,'recaptchaprivatekey',''),(177,'filteruploadedfiles','0'),(178,'filtermatchoneperpage','0'),(179,'filtermatchonepertext','0'),(180,'sitedefaultlicense','allrightsreserved'),(181,'media_default_width','400'),(182,'media_default_height','300'),(183,'portfolio_moderate_filesize_threshold','1048576'),(184,'portfolio_high_filesize_threshold','5242880'),(185,'portfolio_moderate_db_threshold','20'),(186,'portfolio_high_db_threshold','50'),(187,'repositorycacheexpire','120'),(188,'repositorygetfiletimeout','30'),(189,'repositorysyncfiletimeout','1'),(190,'repositorysyncimagetimeout','3'),(191,'repositoryallowexternallinks','1'),(192,'legacyfilesinnewcourses','0'),(193,'legacyfilesaddallowed','1'),(194,'searchengine','simpledb'),(195,'searchindexwhendisabled','0'),(196,'searchindextime','600'),(197,'searchallavailablecourses','0'),(198,'enablewsdocumentation','0'),(199,'allowbeforeblock','0'),(200,'allowedip',''),(201,'blockedip',''),(202,'protectusernames','1'),(203,'forcelogin','0'),(204,'forceloginforprofiles','1'),(205,'forceloginforprofileimage','1'),(206,'opentogoogle','0'),(207,'allowindexing','0'),(208,'maxbytes','0'),(209,'userquota','104857600'),(210,'allowobjectembed','0'),(211,'enabletrusttext','0'),(212,'maxeditingtime','1800'),(213,'extendedusernamechars','0'),(214,'keeptagnamecase','1'),(215,'profilesforenrolledusersonly','1'),(216,'cronclionly','1'),(217,'cronremotepassword',''),(218,'lockoutthreshold','0'),(219,'lockoutwindow','1800'),(220,'lockoutduration','1800'),(221,'passwordpolicy','1'),(222,'minpasswordlength','0'),(223,'minpassworddigits','0'),(224,'minpasswordlower','0'),(225,'minpasswordupper','0'),(226,'minpasswordnonalphanum','0'),(227,'maxconsecutiveidentchars','0'),(228,'passwordreuselimit','0'),(229,'pwresettime','1800'),(230,'passwordchangelogout','0'),(231,'passwordchangetokendeletion','0'),(232,'tokenduration','7257600'),(233,'groupenrolmentkeypolicy','1'),(234,'disableuserimages','0'),(235,'emailchangeconfirmation','1'),(236,'rememberusername','2'),(237,'strictformsrequired','0'),(238,'cookiesecure','1'),(239,'cookiehttponly','0'),(240,'allowframembedding','0'),(241,'curlsecurityblockedhosts',''),(242,'curlsecurityallowedport',''),(243,'displayloginfailures','0'),(244,'notifyloginfailures',''),(245,'notifyloginthreshold','10'),(246,'themelist',''),(247,'themedesignermode','0'),(248,'allowuserthemes','0'),(249,'allowcoursethemes','0'),(250,'allowcategorythemes','0'),(251,'allowcohortthemes','0'),(252,'allowthemechangeonurl','0'),(253,'allowuserblockhiding','1'),(254,'allowblockstodock','1'),(255,'custommenuitems',''),(256,'customusermenuitems','grades,grades|/grade/report/mygrades.php|grades\r\nmessages,message|/message/index.php|message\r\npreferences,moodle|/user/preferences.php|preferences'),(257,'enabledevicedetection','1'),(258,'devicedetectregex','[]'),(259,'calendartype','gregorian'),(260,'calendar_adminseesall','0'),(261,'calendar_site_timeformat','0'),(262,'calendar_startwday','1'),(263,'calendar_weekend','65'),(264,'calendar_lookahead','21'),(265,'calendar_maxevents','10'),(266,'enablecalendarexport','1'),(267,'calendar_customexport','1'),(268,'calendar_exportlookahead','365'),(269,'calendar_exportlookback','5'),(270,'calendar_exportsalt','cfrmjpwyhwkf2k27cjpnojizbq8kzso7p38muxmkyxreeavu1bapot0xz9s9'),(271,'calendar_showicalsource','1'),(272,'useblogassociations','1'),(273,'bloglevel','4'),(274,'useexternalblogs','1'),(275,'externalblogcrontime','86400'),(276,'maxexternalblogsperuser','1'),(277,'blogusecomments','1'),(278,'blogshowcommentscount','1'),(279,'defaulthomepage','0'),(280,'allowguestmymoodle','0'),(281,'navshowfullcoursenames','1'),(282,'navshowcategories','0'),(283,'navshowmycoursecategories','0'),(284,'navshowallcourses','1'),(285,'navsortmycoursessort','sortorder'),(286,'navcourselimit','10'),(287,'usesitenameforsitepages','0'),(288,'linkadmincategories','1'),(289,'linkcoursesections','1'),(290,'navshowfrontpagemods','1'),(291,'navadduserpostslinks','1'),(292,'formatstringstriptags','1'),(293,'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\"}]'),(294,'docroot','https://docs.moodle.org'),(295,'doclang',''),(296,'doctonewwindow','0'),(297,'courselistshortnames','0'),(298,'coursesperpage','20'),(299,'courseswithsummarieslimit','10'),(300,'courseoverviewfileslimit','1'),(301,'courseoverviewfilesext','.jpg,.gif,.png'),(302,'useexternalyui','0'),(303,'yuicomboloading','1'),(304,'cachejs','1'),(305,'modchooserdefault','1'),(306,'additionalhtmlhead',''),(307,'additionalhtmltopofbody',''),(308,'additionalhtmlfooter',''),(309,'pathtodu',''),(310,'aspellpath',''),(311,'pathtodot',''),(312,'pathtogs','/usr/bin/gs'),(313,'pathtopython',''),(314,'supportname','Admin User'),(315,'supportemail',''),(316,'supportpage',''),(317,'dbsessions','0'),(318,'sessioncookie',''),(319,'sessioncookiepath',''),(320,'sessioncookiedomain',''),(321,'statsfirstrun','none'),(322,'statsmaxruntime','0'),(323,'statsruntimedays','31'),(324,'statsuserthreshold','0'),(325,'slasharguments','1'),(326,'getremoteaddrconf','0'),(327,'proxyhost',''),(328,'proxyport','0'),(329,'proxytype','HTTP'),(330,'proxyuser',''),(331,'proxypassword',''),(332,'proxybypass','localhost, 127.0.0.1'),(333,'maintenance_enabled','0'),(334,'maintenance_message',''),(335,'deleteunconfirmed','168'),(336,'deleteincompleteusers','0'),(337,'disablegradehistory','0'),(338,'gradehistorylifetime','0'),(339,'tempdatafoldercleanup','168'),(340,'extramemorylimit','512M'),(341,'maxtimelimit','0'),(342,'curlcache','120'),(343,'curltimeoutkbitrate','56'),(344,'smtphosts','smtp.google.com'),(345,'smtpsecure','ssl'),(346,'smtpauthtype','LOGIN'),(347,'smtpuser','sistemas@dlh.com.pe'),(348,'smtppass','Barmandoec7'),(349,'smtpmaxbulk','1'),(350,'noreplyaddress','sistemas@dlh.com.pw'),(351,'allowedemaildomains','www.dlh.com.pe\r\nwww.dlhplataforma.com'),(352,'sitemailcharset','0'),(353,'allowusermailcharset','0'),(354,'allowattachments','1'),(355,'mailnewline','LF'),(356,'emailfromvia','1'),(357,'updateautocheck','1'),(358,'updateminmaturity','200'),(359,'updatenotifybuilds','0'),(360,'enablesafebrowserintegration','0'),(361,'dndallowtextandlinks','0'),(362,'pathtosassc',''),(363,'forceclean','0'),(364,'debug','0'),(365,'debugdisplay','0'),(366,'debugsmtp','0'),(367,'perfdebug','7'),(368,'debugstringids','0'),(369,'debugvalidators','0'),(370,'debugpageinfo','0'),(371,'profilingenabled','0'),(372,'profilingincluded',''),(373,'profilingexcluded',''),(374,'profilingautofrec','0'),(375,'profilingallowme','0'),(376,'profilingallowall','0'),(377,'profilinglifetime','1440'),(378,'profilingimportprefix','(I)'),(379,'release','3.5.2 (Build: 20180910)'),(380,'branch','35'),(381,'localcachedirpurged','1544027707'),(382,'scheduledtaskreset','1544027707'),(383,'allversionshash','8404649d95ad4684d813d2031de11630719cdd30'),(385,'registrationpending','0'),(386,'notloggedinroleid','6'),(387,'guestroleid','6'),(388,'defaultuserroleid','7'),(389,'creatornewroleid','3'),(390,'restorernewroleid','3'),(391,'sitepolicyhandler',''),(392,'gradebookroles','5'),(393,'chat_method','ajax'),(394,'chat_refresh_userlist','10'),(395,'chat_old_ping','35'),(396,'chat_refresh_room','5'),(397,'chat_normal_updatemode','jsupdate'),(398,'chat_serverhost','dlhplataforma.com'),(399,'chat_serverip','127.0.0.1'),(400,'chat_serverport','9111'),(401,'chat_servermax','100'),(402,'data_enablerssfeeds','0'),(403,'feedback_allowfullanonymous','0'),(404,'forum_displaymode','3'),(405,'forum_shortpost','300'),(406,'forum_longpost','600'),(407,'forum_manydiscussions','100'),(408,'forum_maxbytes','512000'),(409,'forum_maxattachments','9'),(410,'forum_subscription','0'),(411,'forum_trackingtype','1'),(412,'forum_trackreadposts','1'),(413,'forum_allowforcedreadtracking','0'),(414,'forum_oldpostdays','14'),(415,'forum_usermarksread','0'),(416,'forum_cleanreadtime','2'),(417,'digestmailtime','17'),(418,'forum_enablerssfeeds','0'),(419,'forum_enabletimedposts','1'),(420,'glossary_entbypage','10'),(421,'glossary_dupentries','0'),(422,'glossary_allowcomments','0'),(423,'glossary_linkbydefault','1'),(424,'glossary_defaultapproval','1'),(425,'glossary_enablerssfeeds','0'),(426,'glossary_linkentries','0'),(427,'glossary_casesensitive','0'),(428,'glossary_fullmatch','0'),(429,'block_course_list_adminview','all'),(430,'block_course_list_hideallcourseslink','0'),(431,'block_html_allowcssclasses','0'),(432,'block_online_users_timetosee','5'),(433,'block_rss_client_num_entries','5'),(434,'block_rss_client_timeout','30'),(435,'pathtounoconv','/usr/bin/unoconv'),(436,'filter_multilang_force_old','0'),(437,'filter_censor_badwords',''),(438,'logguests','1'),(439,'loglifetime','0'),(440,'jabberhost',''),(441,'jabberserver',''),(442,'jabberusername',''),(443,'jabberpassword',''),(444,'jabberport','5222'),(445,'airnotifierurl','https://messages.moodle.net'),(446,'airnotifierport','443'),(447,'airnotifiermobileappname','com.moodle.moodlemobile'),(448,'airnotifierappname','commoodlemoodlemobile'),(449,'airnotifieraccesskey',''),(450,'profileroles','4,5'),(451,'coursecontact','3'),(452,'frontpage','0,2'),(453,'frontpageloggedin','2,0'),(454,'maxcategorydepth','2'),(455,'frontpagecourselimit','200'),(456,'commentsperpage','15'),(457,'defaultfrontpageroleid','8'),(458,'messageinbound_enabled','0'),(459,'messageinbound_mailbox',''),(460,'messageinbound_domain',''),(461,'messageinbound_host',''),(462,'messageinbound_hostssl','ssl'),(463,'messageinbound_hostuser',''),(464,'messageinbound_hostpass',''),(465,'enablemobilewebservice','0'),(466,'timezone','America/New_York'),(467,'registerauth',''),(468,'fileslastcleanup','1538674868'),(469,'digestmailtimelast','1538689267'),(470,'forum_lastreadclean','1538674869'),(471,'scorm_updatetimelast','1538674869'),(473,'reposecretkey','1538694359IcunBIG9lBAUZB5UO7f44XCwVjVlUe2G'),(476,'theme_essential_putprops',''),(479,'block_helpdesk_block_name',''),(480,'block_helpdesk_submit_text',''),(481,'block_helpdesk_allow_external_users','0'),(482,'block_helpdesk_user_types','student,teacher,guardian'),(483,'block_helpdesk_external_user_tokens','0'),(484,'block_helpdesk_token_exp','7'),(485,'block_helpdesk_external_updates','0'),(486,'block_helpdesk_assigned_auto_watch','1'),(487,'block_helpdesk_show_firstcontact','0'),(488,'block_helpdesk_send_update_email','0'),(489,'block_helpdesk_includeagent','0'),(490,'block_helpdesk_email_addr',''),(491,'block_helpdesk_email_passwd',''),(492,'block_helpdesk_email_name',''),(493,'block_helpdesk_email_subject','Ticket #!ticketid! Updated'),(494,'block_helpdesk_email_content','Hello !username!,\r\n\r\nYou are being notfified because one of your questions have been updated and may require your attention.\r\n\r\nYou can access the question here: !ticketlink!\r\nYou question was updated at !updatetime!.\r\n\r\nThank you,\r\n!supportname!'),(495,'block_helpdesk_email_htmlcontent','');

--
