-- Table structure for table `[[dbprefix]]role_context_levels`
--

CREATE TABLE `[[dbprefix]]role_context_levels` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(10) NOT NULL,
  `contextlevel` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]rolecontleve_conrol_uix` (`contextlevel`,`roleid`),
  KEY `[[dbprefix]]rolecontleve_rol_ix` (`roleid`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Lists which roles can be assigned at which context levels. T' AUTO_INCREMENT=12 ;

--
-- Dumping data for table `[[dbprefix]]role_context_levels`
--

INSERT INTO `[[dbprefix]]role_context_levels` VALUES
(1, 1, 10),
(4, 2, 10),
(2, 1, 40),
(5, 2, 40),
(3, 1, 50),
(6, 3, 50),
(8, 4, 50),
(10, 5, 50),
(7, 3, 70),
(9, 4, 70),
(11, 5, 70);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]role_names`
--

CREATE TABLE `[[dbprefix]]role_names` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `contextid` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]rolename_rolcon_uix` (`roleid`,`contextid`),
  KEY `[[dbprefix]]rolename_rol_ix` (`roleid`),
  KEY `[[dbprefix]]rolename_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='role names in native strings' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scale`
--

CREATE TABLE `[[dbprefix]]scale` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `scale` longtext NOT NULL,
  `description` longtext NOT NULL,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]scal_cou_ix` (`courseid`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Defines grading scales' AUTO_INCREMENT=3 ;

--
-- Dumping data for table `[[dbprefix]]scale`
--

INSERT INTO `[[dbprefix]]scale` VALUES
(1, 0, 0, 'Separate and Connected ways of knowing', 'Mostly separate knowing,Separate and connected,Mostly connected knowing', 'The scale based on the theory of separate and connected knowing. This theory describes two different ways that we can evaluate and learn about the things we see and hear.<ul><li><strong>Separate knowers</strong> remain as objective as possible without including feelings and emotions. In a discussion with other people, they like to defend their own ideas, using logic to find holes in opponent''s ideas.</li><li><strong>Connected knowers</strong> are more sensitive to other people. They are skilled at empathy and tend to listen and ask questions until they feel they can connect and "understand things from their point of view". They learn by trying to share the experiences that led to the knowledge they find in other people.</li></ul>', 0, [[timestamp]]),
(2, 0, 0, 'Default competence scale', 'Not yet competent,Competent', 'A binary rating scale that provides no further information beyond whether someone has demonstrated proficiency or not.', 0, [[timestamp]]);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scale_history`
--

CREATE TABLE `[[dbprefix]]scale_history` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `action` bigint(10) NOT NULL DEFAULT '0',
  `oldid` bigint(10) NOT NULL,
  `source` varchar(255) DEFAULT NULL,
  `timemodified` bigint(10) DEFAULT NULL,
  `loggeduser` bigint(10) DEFAULT NULL,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `scale` longtext NOT NULL,
  `description` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]scalhist_act_ix` (`action`),
  KEY `[[dbprefix]]scalhist_tim_ix` (`timemodified`),
  KEY `[[dbprefix]]scalhist_old_ix` (`oldid`),
  KEY `[[dbprefix]]scalhist_cou_ix` (`courseid`),
  KEY `[[dbprefix]]scalhist_log_ix` (`loggeduser`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='History table' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm`
--

CREATE TABLE `[[dbprefix]]scorm` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `scormtype` varchar(50) NOT NULL DEFAULT 'local',
  `reference` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT '0',
  `version` varchar(9) NOT NULL DEFAULT '',
  `maxgrade` double NOT NULL DEFAULT '0',
  `grademethod` tinyint(2) NOT NULL DEFAULT '0',
  `whatgrade` bigint(10) NOT NULL DEFAULT '0',
  `maxattempt` bigint(10) NOT NULL DEFAULT '1',
  `forcecompleted` tinyint(1) NOT NULL DEFAULT '0',
  `forcenewattempt` tinyint(1) NOT NULL DEFAULT '0',
  `lastattemptlock` tinyint(1) NOT NULL DEFAULT '0',
  `masteryoverride` tinyint(1) NOT NULL DEFAULT '1',
  `displayattemptstatus` tinyint(1) NOT NULL DEFAULT '1',
  `displaycoursestructure` tinyint(1) NOT NULL DEFAULT '0',
  `updatefreq` tinyint(1) NOT NULL DEFAULT '0',
  `sha1hash` varchar(40) DEFAULT NULL,
  `md5hash` varchar(32) NOT NULL DEFAULT '',
  `revision` bigint(10) NOT NULL DEFAULT '0',
  `launch` bigint(10) NOT NULL DEFAULT '0',
  `skipview` tinyint(1) NOT NULL DEFAULT '1',
  `hidebrowse` tinyint(1) NOT NULL DEFAULT '0',
  `hidetoc` tinyint(1) NOT NULL DEFAULT '0',
  `nav` tinyint(1) NOT NULL DEFAULT '1',
  `navpositionleft` bigint(10) DEFAULT '-100',
  `navpositiontop` bigint(10) DEFAULT '-100',
  `auto` tinyint(1) NOT NULL DEFAULT '0',
  `popup` tinyint(1) NOT NULL DEFAULT '0',
  `options` varchar(255) NOT NULL DEFAULT '',
  `width` bigint(10) NOT NULL DEFAULT '100',
  `height` bigint(10) NOT NULL DEFAULT '600',
  `timeopen` bigint(10) NOT NULL DEFAULT '0',
  `timeclose` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `completionstatusrequired` tinyint(1) DEFAULT NULL,
  `completionscorerequired` bigint(10) DEFAULT NULL,
  `completionstatusallscos` tinyint(1) DEFAULT NULL,
  `displayactivityname` smallint(4) NOT NULL DEFAULT '1',
  `autocommit` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]scor_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='each table is one SCORM module and its configuration' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_aicc_session`
--

CREATE TABLE `[[dbprefix]]scorm_aicc_session` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `scormid` bigint(10) NOT NULL DEFAULT '0',
  `hacpsession` varchar(255) NOT NULL DEFAULT '',
  `scoid` bigint(10) DEFAULT '0',
  `scormmode` varchar(50) DEFAULT NULL,
  `scormstatus` varchar(255) DEFAULT NULL,
  `attempt` bigint(10) DEFAULT NULL,
  `lessonstatus` varchar(255) DEFAULT NULL,
  `sessiontime` varchar(255) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]scoraiccsess_sco_ix` (`scormid`),
  KEY `[[dbprefix]]scoraiccsess_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Used by AICC HACP to store session information' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_scoes`
--

CREATE TABLE `[[dbprefix]]scorm_scoes` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scorm` bigint(10) NOT NULL DEFAULT '0',
  `manifest` varchar(255) NOT NULL DEFAULT '',
  `organization` varchar(255) NOT NULL DEFAULT '',
  `parent` varchar(255) NOT NULL DEFAULT '',
  `identifier` varchar(255) NOT NULL DEFAULT '',
  `launch` longtext NOT NULL,
  `scormtype` varchar(5) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `sortorder` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]scorscoe_sco_ix` (`scorm`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='each SCO part of the SCORM module' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_scoes_data`
--

CREATE TABLE `[[dbprefix]]scorm_scoes_data` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]scorscoedata_sco_ix` (`scoid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Contains variable data get from packages' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_scoes_track`
--

CREATE TABLE `[[dbprefix]]scorm_scoes_track` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `scormid` bigint(10) NOT NULL DEFAULT '0',
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `attempt` bigint(10) NOT NULL DEFAULT '1',
  `element` varchar(255) NOT NULL DEFAULT '',
  `value` longtext NOT NULL,
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]scorscoetrac_usesco_uix` (`userid`,`scormid`,`scoid`,`attempt`,`element`),
  KEY `[[dbprefix]]scorscoetrac_use_ix` (`userid`),
  KEY `[[dbprefix]]scorscoetrac_sco_ix` (`scormid`),
  KEY `[[dbprefix]]scorscoetrac_sco2_ix` (`scoid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='to track SCOes' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_seq_mapinfo`
--

CREATE TABLE `[[dbprefix]]scorm_seq_mapinfo` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `objectiveid` bigint(10) NOT NULL DEFAULT '0',
  `targetobjectiveid` bigint(10) NOT NULL DEFAULT '0',
  `readsatisfiedstatus` tinyint(1) NOT NULL DEFAULT '1',
  `readnormalizedmeasure` tinyint(1) NOT NULL DEFAULT '1',
  `writesatisfiedstatus` tinyint(1) NOT NULL DEFAULT '0',
  `writenormalizedmeasure` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]scorseqmapi_scoidob_uix` (`scoid`,`id`,`objectiveid`),
  KEY `[[dbprefix]]scorseqmapi_sco_ix` (`scoid`),
  KEY `[[dbprefix]]scorseqmapi_obj_ix` (`objectiveid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='SCORM2004 objective mapinfo description' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_seq_objective`
--

CREATE TABLE `[[dbprefix]]scorm_seq_objective` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `primaryobj` tinyint(1) NOT NULL DEFAULT '0',
  `objectiveid` varchar(255) NOT NULL DEFAULT '',
  `satisfiedbymeasure` tinyint(1) NOT NULL DEFAULT '1',
  `minnormalizedmeasure` float(11,4) NOT NULL DEFAULT '0.0000',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]scorseqobje_scoid_uix` (`scoid`,`id`),
  KEY `[[dbprefix]]scorseqobje_sco_ix` (`scoid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='SCORM2004 objective description' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_seq_rolluprule`
--

CREATE TABLE `[[dbprefix]]scorm_seq_rolluprule` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `childactivityset` varchar(15) NOT NULL DEFAULT '',
  `minimumcount` bigint(10) NOT NULL DEFAULT '0',
  `minimumpercent` float(11,4) NOT NULL DEFAULT '0.0000',
  `conditioncombination` varchar(3) NOT NULL DEFAULT 'all',
  `action` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]scorseqroll_scoid_uix` (`scoid`,`id`),
  KEY `[[dbprefix]]scorseqroll_sco_ix` (`scoid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='SCORM2004 sequencing rule' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_seq_rolluprulecond`
--

CREATE TABLE `[[dbprefix]]scorm_seq_rolluprulecond` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `rollupruleid` bigint(10) NOT NULL DEFAULT '0',
  `operator` varchar(5) NOT NULL DEFAULT 'noOp',
  `cond` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]scorseqroll_scoroli_uix` (`scoid`,`rollupruleid`,`id`),
  KEY `[[dbprefix]]scorseqroll_sco2_ix` (`scoid`),
  KEY `[[dbprefix]]scorseqroll_rol_ix` (`rollupruleid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='SCORM2004 sequencing rule' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_seq_rulecond`
--

CREATE TABLE `[[dbprefix]]scorm_seq_rulecond` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `ruleconditionsid` bigint(10) NOT NULL DEFAULT '0',
  `refrencedobjective` varchar(255) NOT NULL DEFAULT '',
  `measurethreshold` float(11,4) NOT NULL DEFAULT '0.0000',
  `operator` varchar(5) NOT NULL DEFAULT 'noOp',
  `cond` varchar(30) NOT NULL DEFAULT 'always',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]scorseqrule_idscoru_uix` (`id`,`scoid`,`ruleconditionsid`),
  KEY `[[dbprefix]]scorseqrule_sco2_ix` (`scoid`),
  KEY `[[dbprefix]]scorseqrule_rul_ix` (`ruleconditionsid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='SCORM2004 rule condition' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]scorm_seq_ruleconds`
--

CREATE TABLE `[[dbprefix]]scorm_seq_ruleconds` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scoid` bigint(10) NOT NULL DEFAULT '0',
  `conditioncombination` varchar(3) NOT NULL DEFAULT 'all',
  `ruletype` tinyint(2) NOT NULL DEFAULT '0',
  `action` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]scorseqrule_scoid_uix` (`scoid`,`id`),
  KEY `[[dbprefix]]scorseqrule_sco_ix` (`scoid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='SCORM2004 rule conditions' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]search_index_requests`
--

CREATE TABLE `[[dbprefix]]search_index_requests` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `searcharea` varchar(255) NOT NULL DEFAULT '',
  `timerequested` bigint(10) NOT NULL,
  `partialarea` varchar(255) NOT NULL DEFAULT '',
  `partialtime` bigint(10) NOT NULL,
  `indexpriority` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]searinderequ_indtim_ix` (`indexpriority`,`timerequested`),
  KEY `[[dbprefix]]searinderequ_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Records requests for (re)indexing of specific contexts. Entr' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]search_simpledb_index`
--

CREATE TABLE `[[dbprefix]]search_simpledb_index` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `docid` varchar(255) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `title` longtext,
  `content` longtext,
  `contextid` bigint(10) NOT NULL,
  `areaid` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `owneruserid` bigint(10) DEFAULT NULL,
  `modified` bigint(10) NOT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `description1` longtext,
  `description2` longtext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]searsimpinde_doc_uix` (`docid`),
  KEY `[[dbprefix]]searsimpinde_owncon_ix` (`owneruserid`,`contextid`),
  FULLTEXT KEY `[[dbprefix]]search_simpledb_index_index` (`title`,`content`,`description1`,`description2`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='search_simpledb table containing the index data.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sessions`
--

CREATE TABLE `[[dbprefix]]sessions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `state` bigint(10) NOT NULL DEFAULT '0',
  `sid` varchar(128) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `sessdata` longtext,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `firstip` varchar(45) DEFAULT NULL,
  `lastip` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]sess_sid_uix` (`sid`),
  KEY `[[dbprefix]]sess_sta_ix` (`state`),
  KEY `[[dbprefix]]sess_tim_ix` (`timecreated`),
  KEY `[[dbprefix]]sess_tim2_ix` (`timemodified`),
  KEY `[[dbprefix]]sess_use_ix` (`userid`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Database based session storage - now recommended' AUTO_INCREMENT=1 ;

--
-- Dumping data for table `[[dbprefix]]sessions`
--


-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stats_daily`
--

CREATE TABLE `[[dbprefix]]stats_daily` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(20) NOT NULL DEFAULT 'activity',
  `stat1` bigint(10) NOT NULL DEFAULT '0',
  `stat2` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]statdail_cou_ix` (`courseid`),
  KEY `[[dbprefix]]statdail_tim_ix` (`timeend`),
  KEY `[[dbprefix]]statdail_rol_ix` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='to accumulate daily stats' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stats_monthly`
--

CREATE TABLE `[[dbprefix]]stats_monthly` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(20) NOT NULL DEFAULT 'activity',
  `stat1` bigint(10) NOT NULL DEFAULT '0',
  `stat2` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]statmont_cou_ix` (`courseid`),
  KEY `[[dbprefix]]statmont_tim_ix` (`timeend`),
  KEY `[[dbprefix]]statmont_rol_ix` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='To accumulate monthly stats' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stats_user_daily`
--

CREATE TABLE `[[dbprefix]]stats_user_daily` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `statsreads` bigint(10) NOT NULL DEFAULT '0',
  `statswrites` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]statuserdail_cou_ix` (`courseid`),
  KEY `[[dbprefix]]statuserdail_use_ix` (`userid`),
  KEY `[[dbprefix]]statuserdail_rol_ix` (`roleid`),
  KEY `[[dbprefix]]statuserdail_tim_ix` (`timeend`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='To accumulate daily stats per course/user' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stats_user_monthly`
--

CREATE TABLE `[[dbprefix]]stats_user_monthly` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `statsreads` bigint(10) NOT NULL DEFAULT '0',
  `statswrites` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]statusermont_cou_ix` (`courseid`),
  KEY `[[dbprefix]]statusermont_use_ix` (`userid`),
  KEY `[[dbprefix]]statusermont_rol_ix` (`roleid`),
  KEY `[[dbprefix]]statusermont_tim_ix` (`timeend`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='To accumulate monthly stats per course/user' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stats_user_weekly`
--

CREATE TABLE `[[dbprefix]]stats_user_weekly` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `statsreads` bigint(10) NOT NULL DEFAULT '0',
  `statswrites` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]statuserweek_cou_ix` (`courseid`),
  KEY `[[dbprefix]]statuserweek_use_ix` (`userid`),
  KEY `[[dbprefix]]statuserweek_rol_ix` (`roleid`),
  KEY `[[dbprefix]]statuserweek_tim_ix` (`timeend`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='To accumulate weekly stats per course/user' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]stats_weekly`
--

CREATE TABLE `[[dbprefix]]stats_weekly` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(20) NOT NULL DEFAULT 'activity',
  `stat1` bigint(10) NOT NULL DEFAULT '0',
  `stat2` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]statweek_cou_ix` (`courseid`),
  KEY `[[dbprefix]]statweek_tim_ix` (`timeend`),
  KEY `[[dbprefix]]statweek_rol_ix` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='To accumulate weekly stats' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]survey`
--

CREATE TABLE `[[dbprefix]]survey` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT '0',
  `template` bigint(10) NOT NULL DEFAULT '0',
  `days` mediumint(6) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT '0',
  `questions` varchar(255) NOT NULL DEFAULT '',
  `completionsubmit` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]surv_cou_ix` (`course`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Each record is one SURVEY module with its configuration' AUTO_INCREMENT=6 ;

--
-- Dumping data for table `[[dbprefix]]survey`
--

INSERT INTO `[[dbprefix]]survey` VALUES
(1, 0, 0, 0, 985017600, 985017600, 'collesaname', 'collesaintro', 0, '25,26,27,28,29,30,43,44', 0),
(2, 0, 0, 0, 985017600, 985017600, 'collespname', 'collespintro', 0, '31,32,33,34,35,36,43,44', 0),
(3, 0, 0, 0, 985017600, 985017600, 'collesapname', 'collesapintro', 0, '37,38,39,40,41,42,43,44', 0),
(4, 0, 0, 0, 985017600, 985017600, 'attlsname', 'attlsintro', 0, '65,67,68', 0),
(5, 0, 0, 0, 985017600, 985017600, 'ciqname', 'ciqintro', 0, '69,70,71,72,73', 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]survey_analysis`
--

CREATE TABLE `[[dbprefix]]survey_analysis` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `survey` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `notes` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]survanal_use_ix` (`userid`),
  KEY `[[dbprefix]]survanal_sur_ix` (`survey`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='text about each survey submission' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]survey_answers`
--

CREATE TABLE `[[dbprefix]]survey_answers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `survey` bigint(10) NOT NULL DEFAULT '0',
  `question` bigint(10) NOT NULL DEFAULT '0',
  `time` bigint(10) NOT NULL DEFAULT '0',
  `answer1` longtext NOT NULL,
  `answer2` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]survansw_use_ix` (`userid`),
  KEY `[[dbprefix]]survansw_sur_ix` (`survey`),
  KEY `[[dbprefix]]survansw_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='the answers to each questions filled by the users' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]survey_questions`
--

CREATE TABLE `[[dbprefix]]survey_questions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `text` varchar(255) NOT NULL DEFAULT '',
  `shorttext` varchar(30) NOT NULL DEFAULT '',
  `multi` varchar(100) NOT NULL DEFAULT '',
  `intro` varchar(50) NOT NULL DEFAULT '',
  `type` smallint(3) NOT NULL DEFAULT '0',
  `options` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='the questions conforming one survey' AUTO_INCREMENT=74 ;

--
-- Dumping data for table `[[dbprefix]]survey_questions`
--

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

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tag`
--

CREATE TABLE `[[dbprefix]]tag` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `tagcollid` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `rawname` varchar(255) NOT NULL DEFAULT '',
  `isstandard` tinyint(1) NOT NULL DEFAULT '0',
  `description` longtext,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT '0',
  `flag` smallint(4) DEFAULT '0',
  `timemodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]tag_tagnam_uix` (`tagcollid`,`name`),
  KEY `[[dbprefix]]tag_tagiss_ix` (`tagcollid`,`isstandard`),
  KEY `[[dbprefix]]tag_use_ix` (`userid`),
  KEY `[[dbprefix]]tag_tag_ix` (`tagcollid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Tag table - this generic table will replace the old "tags" t' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tag_area`
--

CREATE TABLE `[[dbprefix]]tag_area` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(100) NOT NULL DEFAULT '',
  `itemtype` varchar(100) NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `tagcollid` bigint(10) NOT NULL,
  `callback` varchar(100) DEFAULT NULL,
  `callbackfile` varchar(100) DEFAULT NULL,
  `showstandard` tinyint(1) NOT NULL DEFAULT '0',
  `multiplecontexts` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]tagarea_comite_uix` (`component`,`itemtype`),
  KEY `[[dbprefix]]tagarea_tag_ix` (`tagcollid`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Defines various tag areas, one area is identified by compone' AUTO_INCREMENT=12 ;

--
-- Dumping data for table `[[dbprefix]]tag_area`
--

INSERT INTO `[[dbprefix]]tag_area` VALUES
(1, 'core', 'user', 1, 1, 'user_get_tagged_users', '/user/lib.php', 2, 0),
(2, 'core', 'course', 1, 1, 'course_get_tagged_courses', '/course/lib.php', 0, 0),
(3, 'core_question', 'question', 1, 1, NULL, NULL, 0, 1),
(4, 'core', 'post', 1, 1, 'blog_get_tagged_posts', '/blog/lib.php', 0, 0),
(5, 'core', 'blog_external', 1, 1, NULL, NULL, 0, 0),
(6, 'core', 'course_modules', 1, 1, 'course_get_tagged_course_modules', '/course/lib.php', 0, 0),
(7, 'mod_book', 'book_chapters', 1, 1, 'mod_book_get_tagged_chapters', '/mod/book/locallib.php', 0, 0),
(8, 'mod_data', 'data_records', 1, 1, 'mod_data_get_tagged_records', '/mod/data/locallib.php', 0, 0),
(9, 'mod_forum', 'forum_posts', 1, 1, 'mod_forum_get_tagged_posts', '/mod/forum/locallib.php', 0, 0),
(10, 'mod_glossary', 'glossary_entries', 1, 1, 'mod_glossary_get_tagged_entries', '/mod/glossary/locallib.php', 0, 0),
(11, 'mod_wiki', 'wiki_pages', 1, 1, 'mod_wiki_get_tagged_pages', '/mod/wiki/locallib.php', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tag_coll`
--

CREATE TABLE `[[dbprefix]]tag_coll` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `isdefault` tinyint(2) NOT NULL DEFAULT '0',
  `component` varchar(100) DEFAULT NULL,
  `sortorder` mediumint(5) NOT NULL DEFAULT '0',
  `searchable` tinyint(2) NOT NULL DEFAULT '1',
  `customurl` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Defines different set of tags' AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]tag_coll`
--

INSERT INTO `[[dbprefix]]tag_coll` VALUES
(1, NULL, 1, NULL, 0, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tag_correlation`
--

CREATE TABLE `[[dbprefix]]tag_correlation` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `tagid` bigint(10) NOT NULL,
  `correlatedtags` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]tagcorr_tag_ix` (`tagid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='The rationale for the ''tag_correlation'' table is performance' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tag_instance`
--

CREATE TABLE `[[dbprefix]]tag_instance` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `tagid` bigint(10) NOT NULL,
  `component` varchar(100) NOT NULL DEFAULT '',
  `itemtype` varchar(100) NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `tiuserid` bigint(10) NOT NULL DEFAULT '0',
  `ordering` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]taginst_comiteiteco_uix` (`component`,`itemtype`,`itemid`,`contextid`,`tiuserid`,`tagid`),
  KEY `[[dbprefix]]taginst_itecomtagcon_ix` (`itemtype`,`component`,`tagid`,`contextid`),
  KEY `[[dbprefix]]taginst_tag_ix` (`tagid`),
  KEY `[[dbprefix]]taginst_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='tag_instance table holds the information of associations bet' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]task_adhoc`
--

CREATE TABLE `[[dbprefix]]task_adhoc` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(255) NOT NULL DEFAULT '',
  `classname` varchar(255) NOT NULL DEFAULT '',
  `nextruntime` bigint(10) NOT NULL,
  `faildelay` bigint(10) DEFAULT NULL,
  `customdata` longtext,
  `userid` bigint(10) DEFAULT NULL,
  `blocking` tinyint(2) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timestarted` bigint(10) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `pid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]taskadho_nex_ix` (`nextruntime`),
  KEY `[[dbprefix]]taskadho_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='List of adhoc tasks waiting to run.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]task_log`
--

CREATE TABLE `[[dbprefix]]task_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` smallint(4) NOT NULL,
  `component` varchar(255) NOT NULL DEFAULT '',
  `classname` varchar(255) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `timestart` decimal(20,10) NOT NULL,
  `timeend` decimal(20,10) NOT NULL,
  `dbreads` bigint(10) NOT NULL,
  `dbwrites` bigint(10) NOT NULL,
  `result` tinyint(2) NOT NULL,
  `output` longtext NOT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `pid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]tasklog_cla_ix` (`classname`),
  KEY `[[dbprefix]]tasklog_tim_ix` (`timestart`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='The log table for all tasks' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]task_scheduled`
--

CREATE TABLE `[[dbprefix]]task_scheduled` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `component` varchar(255) NOT NULL DEFAULT '',
  `classname` varchar(255) NOT NULL DEFAULT '',
  `lastruntime` bigint(10) DEFAULT NULL,
  `nextruntime` bigint(10) DEFAULT NULL,
  `blocking` tinyint(2) NOT NULL DEFAULT '0',
  `minute` varchar(25) NOT NULL DEFAULT '',
  `hour` varchar(25) NOT NULL DEFAULT '',
  `day` varchar(25) NOT NULL DEFAULT '',
  `month` varchar(25) NOT NULL DEFAULT '',
  `dayofweek` varchar(25) NOT NULL DEFAULT '',
  `faildelay` bigint(10) DEFAULT NULL,
  `customised` tinyint(2) NOT NULL DEFAULT '0',
  `disabled` tinyint(1) NOT NULL DEFAULT '0',
  `timestarted` bigint(10) DEFAULT NULL,
  `hostname` varchar(255) DEFAULT NULL,
  `pid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]tasksche_cla_uix` (`classname`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='List of scheduled tasks to be run by cron.' AUTO_INCREMENT=106 ;

--
-- Dumping data for table `[[dbprefix]]task_scheduled`
--

INSERT INTO `[[dbprefix]]task_scheduled` VALUES
(1, 'moodle', '\\core\\task\\session_cleanup_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(2, 'moodle', '\\core\\task\\delete_unconfirmed_users_task', 0, [[timestamp]], 0, '0', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(3, 'moodle', '\\core\\task\\delete_incomplete_users_task', 0, [[timestamp]], 0, '5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(4, 'moodle', '\\core\\task\\backup_cleanup_task', 0, [[timestamp]], 0, '10', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(5, 'moodle', '\\core\\task\\tag_cron_task', 0, [[timestamp]], 0, '25', '3', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(6, 'moodle', '\\core\\task\\context_cleanup_task', 0, [[timestamp]], 0, '25', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(7, 'moodle', '\\core\\task\\cache_cleanup_task', 0, [[timestamp]], 0, '30', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(8, 'moodle', '\\core\\task\\messaging_cleanup_task', 0, [[timestamp]], 0, '35', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(9, 'moodle', '\\core\\task\\send_new_user_passwords_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(10, 'moodle', '\\core\\task\\send_failed_login_notifications_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(11, 'moodle', '\\core\\task\\create_contexts_task', 0, [[timestamp_nextday]], 1, '0', '0', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(12, 'moodle', '\\core\\task\\legacy_plugin_cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(13, 'moodle', '\\core\\task\\grade_cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(14, 'moodle', '\\core\\task\\grade_history_cleanup_task', 0, [[timestamp_nextday]], 0, '*', '0', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(15, 'moodle', '\\core\\task\\completion_regular_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(16, 'moodle', '\\core\\task\\completion_daily_task', 0, [[timestamp_nextday]], 0, '51', '20', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(17, 'moodle', '\\core\\task\\portfolio_cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(18, 'moodle', '\\core\\task\\plagiarism_cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(19, 'moodle', '\\core\\task\\calendar_cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(20, 'moodle', '\\core\\task\\blog_cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(21, 'moodle', '\\core\\task\\question_preview_cleanup_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(22, 'moodle', '\\core\\task\\question_stats_cleanup_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(23, 'moodle', '\\core\\task\\registration_cron_task', 0, [[timestamp]], 0, '49', '1', '*', '*', '3', 0, 0, 0, NULL, NULL, NULL),
(24, 'moodle', '\\core\\task\\check_for_updates_task', 0, [[timestamp_nextday]], 0, '56', '12', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(25, 'moodle', '\\core\\task\\cache_cron_task', 0, [[timestamp]], 0, '50', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(26, 'moodle', '\\core\\task\\automated_backup_task', 0, [[timestamp]], 0, '50', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(27, 'moodle', '\\core\\task\\badges_cron_task', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(28, 'moodle', '\\core\\task\\badges_message_task', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(29, 'moodle', '\\core\\task\\file_temp_cleanup_task', 0, [[timestamp]], 0, '55', '*/6', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(30, 'moodle', '\\core\\task\\file_trash_cleanup_task', 0, [[timestamp]], 0, '55', '*/6', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(31, 'moodle', '\\core\\task\\search_index_task', 0, [[timestamp]], 0, '*/30', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(32, 'moodle', '\\core\\task\\search_optimize_task', 0, [[timestamp]], 0, '15', '*/12', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(33, 'moodle', '\\core\\task\\stats_cron_task', 0, [[timestamp_nextday]], 0, '0', '0', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(34, 'moodle', '\\core\\task\\password_reset_cleanup_task', 0, [[timestamp]], 0, '0', '*/6', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(35, 'moodle', '\\core\\task\\complete_plans_task', 0, [[timestamp]], 0, '49', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(36, 'moodle', '\\core\\task\\sync_plans_from_template_cohorts_task', 0, [[timestamp]], 0, '45', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(37, 'moodle', '\\core_files\\task\\conversion_cleanup_task', 0, [[timestamp_nextday]], 0, '44', '2', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(38, 'moodle', '\\core\\oauth2\\refresh_system_tokens_task', 0, [[timestamp]], 0, '30', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(39, 'moodle', '\\core\\task\\analytics_cleanup_task', 0, [[timestamp]], 0, '42', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(40, 'moodle', '\\core\\task\\task_log_cleanup_task', 0, [[timestamp_nextday]], 0, '43', '2', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(41, 'moodle', '\\core\\task\\h5p_get_content_types_task', 0, [[timestamp_nextday]], 0, '5', '6', '1', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(42, 'moodle', '\\core\\task\\h5p_clean_orphaned_records_task', 0, [[timestamp_nextday]], 0, '52', '0', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(43, 'moodle', '\\core\\task\\antivirus_cleanup_task', 0, [[timestamp_nextday]], 0, '9', '0', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(44, 'qtype_random', '\\qtype_random\\task\\remove_unused_questions', 0, [[timestamp]], 0, '54', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(45, 'mod_assign', '\\mod_assign\\task\\cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(46, 'mod_chat', '\\mod_chat\\task\\cron_task', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(47, 'mod_forum', '\\mod_forum\\task\\cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(48, 'mod_lti', '\\mod_lti\\task\\clean_access_tokens', 0, [[timestamp]], 0, '20', '10', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(49, 'mod_quiz', '\\mod_quiz\\task\\update_overdue_attempts', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(50, 'mod_quiz', '\\mod_quiz\\task\\legacy_quiz_reports_cron', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(51, 'mod_quiz', '\\mod_quiz\\task\\legacy_quiz_accessrules_cron', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(52, 'mod_scorm', '\\mod_scorm\\task\\cron_task', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(53, 'mod_workshop', '\\mod_workshop\\task\\cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(54, 'mod_workshop', '\\mod_workshop\\task\\legacy_workshop_allocation_cron', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(55, 'auth_cas', '\\auth_cas\\task\\sync_task', 0, [[timestamp_nextday]], 0, '0', '0', '*', '*', '*', 0, 0, 1, NULL, NULL, NULL),
(56, 'auth_db', '\\auth_db\\task\\sync_users', 0, [[timestamp]], 0, '10', '13', '*', '*', '*', 0, 0, 1, NULL, NULL, NULL),
(57, 'auth_ldap', '\\auth_ldap\\task\\sync_roles', 0, [[timestamp_nextday]], 0, '0', '0', '*', '*', '*', 0, 0, 1, NULL, NULL, NULL),
(58, 'auth_ldap', '\\auth_ldap\\task\\sync_task', 0, [[timestamp_nextday]], 0, '0', '0', '*', '*', '*', 0, 0, 1, NULL, NULL, NULL),
(59, 'auth_mnet', '\\auth_mnet\\task\\cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(60, 'enrol_category', '\\enrol_category\\task\\enrol_category_sync', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(61, 'enrol_cohort', '\\enrol_cohort\\task\\enrol_cohort_sync', 0, [[timestamp]], 0, '25', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(62, 'enrol_database', '\\enrol_database\\task\\sync_enrolments', 0, [[timestamp]], 0, '51', '19', '*', '*', '*', 0, 0, 1, NULL, NULL, NULL),
(63, 'enrol_flatfile', '\\enrol_flatfile\\task\\flatfile_sync_task', 0, [[timestamp]], 0, '15', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(64, 'enrol_imsenterprise', '\\enrol_imsenterprise\\task\\cron_task', 0, [[timestamp]], 0, '10', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(65, 'enrol_ldap', '\\enrol_ldap\\task\\sync_enrolments', 0, [[timestamp]], 0, '50', '17', '*', '*', '*', 0, 0, 1, NULL, NULL, NULL),
(66, 'enrol_lti', '\\enrol_lti\\task\\sync_grades', 0, [[timestamp]], 0, '*/30', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(67, 'enrol_lti', '\\enrol_lti\\task\\sync_members', 0, [[timestamp]], 0, '*/30', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(68, 'enrol_manual', '\\enrol_manual\\task\\sync_enrolments', 0, [[timestamp]], 0, '*/10', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(69, 'enrol_manual', '\\enrol_manual\\task\\send_expiry_notifications', 0, [[timestamp]], 0, '*/10', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(70, 'enrol_meta', '\\enrol_meta\\task\\enrol_meta_sync', 0, [[timestamp]], 0, '27', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(71, 'enrol_paypal', '\\enrol_paypal\\task\\process_expirations', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(72, 'enrol_self', '\\enrol_self\\task\\sync_enrolments', 0, [[timestamp]], 0, '*/10', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(73, 'enrol_self', '\\enrol_self\\task\\send_expiry_notifications', 0, [[timestamp]], 0, '*/10', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(74, 'message_email', '\\message_email\\task\\send_email_task', 0, [[timestamp_nextday]], 0, '0', '22', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(75, 'block_recent_activity', '\\block_recent_activity\\task\\cleanup', 0, [[timestamp]], 0, '24', '17', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(76, 'block_rss_client', '\\block_rss_client\\task\\refreshfeeds', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(77, 'editor_atto', '\\editor_atto\\task\\autosave_cleanup_task', 0, [[timestamp_nextday]], 0, '24', '23', '*', '*', '5', 0, 0, 0, NULL, NULL, NULL),
(78, 'repository_dropbox', '\\repository_dropbox\\task\\cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(79, 'repository_filesystem', '\\repository_filesystem\\task\\cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(80, 'repository_onedrive', '\\repository_onedrive\\remove_temp_access_task', 0, [[timestamp_nextday]], 0, '47', '19', '*', '*', '2', 0, 0, 0, NULL, NULL, NULL),
(81, 'tool_analytics', '\\tool_analytics\\task\\train_models', 0, [[timestamp]], 0, '0', '20', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(82, 'tool_analytics', '\\tool_analytics\\task\\predict_models', 0, [[timestamp_nextday]], 0, '0', '23', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(83, 'tool_brickfield', '\\tool_brickfield\\task\\bulk_process_courses', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(84, 'tool_brickfield', '\\tool_brickfield\\task\\bulk_process_caches', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(85, 'tool_brickfield', '\\tool_brickfield\\task\\checkid_validation', 0, [[timestamp]], 0, '05', '9', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(86, 'tool_brickfield', '\\tool_brickfield\\task\\update_summarydata', 0, [[timestamp_nextday]], 0, '50', '0', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(87, 'tool_brickfield', '\\tool_brickfield\\task\\process_analysis_requests', 0, [[timestamp]], 0, '*/5', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(88, 'tool_cohortroles', '\\tool_cohortroles\\task\\cohort_role_sync', 0, [[timestamp]], 0, '13', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(89, 'tool_dataprivacy', '\\tool_dataprivacy\\task\\expired_retention_period', 0, [[timestamp]], 0, '0', '14', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(90, 'tool_dataprivacy', '\\tool_dataprivacy\\task\\delete_expired_contexts', 0, [[timestamp]], 0, '0', '5', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(91, 'tool_dataprivacy', '\\tool_dataprivacy\\task\\delete_expired_requests', 0, [[timestamp]], 0, '41', '4', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(92, 'tool_dataprivacy', '\\tool_dataprivacy\\task\\delete_existing_deleted_users', 0, [[timestamp_nextday]], 0, '4', '20', '*', '*', '*', 0, 0, 1, NULL, NULL, NULL),
(93, 'tool_langimport', '\\tool_langimport\\task\\update_langpacks_task', 0, [[timestamp]], 0, '1', '4', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(94, 'tool_messageinbound', '\\tool_messageinbound\\task\\pickup_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(95, 'tool_messageinbound', '\\tool_messageinbound\\task\\cleanup_task', 0, [[timestamp_nextday]], 0, '55', '1', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(96, 'tool_monitor', '\\tool_monitor\\task\\clean_events', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(97, 'tool_monitor', '\\tool_monitor\\task\\check_subscriptions', 0, [[timestamp_nextday]], 0, '57', '14', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(98, 'tool_recyclebin', '\\tool_recyclebin\\task\\cleanup_course_bin', 0, [[timestamp]], 0, '*/30', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(99, 'tool_recyclebin', '\\tool_recyclebin\\task\\cleanup_category_bin', 0, [[timestamp]], 0, '*/30', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(100, 'assignfeedback_editpdf', '\\assignfeedback_editpdf\\task\\convert_submissions', 0, [[timestamp]], 0, '*/15', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(101, 'ltiservice_gradebookservices', '\\ltiservice_gradebookservices\\task\\cleanup_task', 0, [[timestamp]], 0, '16', '2', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(102, 'quiz_statistics', '\\quiz_statistics\\task\\quiz_statistics_cleanup', 0, [[timestamp]], 0, '27', '*/5', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(103, 'workshopallocation_scheduled', '\\workshopallocation_scheduled\\task\\cron_task', 0, [[timestamp]], 0, '*', '*', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(104, 'logstore_legacy', '\\logstore_legacy\\task\\cleanup_task', 0, [[timestamp]], 0, '15', '5', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL),
(105, 'logstore_standard', '\\logstore_standard\\task\\cleanup_task', 0, [[timestamp]], 0, '52', '4', '*', '*', '*', 0, 0, 0, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_areas`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_areas` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) NOT NULL DEFAULT '0',
  `contextid` bigint(10) DEFAULT NULL,
  `component` varchar(100) DEFAULT NULL,
  `tablename` varchar(40) DEFAULT NULL,
  `fieldorarea` varchar(50) DEFAULT NULL,
  `itemid` bigint(10) DEFAULT NULL,
  `filename` varchar(1333) DEFAULT NULL,
  `reftable` varchar(40) DEFAULT NULL,
  `refid` bigint(10) DEFAULT NULL,
  `cmid` bigint(10) DEFAULT NULL,
  `courseid` bigint(10) DEFAULT NULL,
  `categoryid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbricarea_coucmi_ix` (`courseid`,`cmid`),
  KEY `[[dbprefix]]toolbricarea_typtabi_ix` (`type`,`tablename`,`itemid`,`fieldorarea`),
  KEY `[[dbprefix]]toolbricarea_typconc_ix` (`type`,`contextid`,`component`,`fieldorarea`,`itemid`),
  KEY `[[dbprefix]]toolbricarea_refreft_ix` (`reftable`,`refid`,`type`),
  KEY `[[dbprefix]]toolbricarea_cou_ix` (`courseid`),
  KEY `[[dbprefix]]toolbricarea_cmi_ix` (`cmid`),
  KEY `[[dbprefix]]toolbricarea_cat_ix` (`categoryid`),
  KEY `[[dbprefix]]toolbricarea_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Areas that have been checked for accessibility problems' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_cache_acts`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_cache_acts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `component` varchar(64) DEFAULT NULL,
  `totalactivities` bigint(10) DEFAULT NULL,
  `failedactivities` bigint(10) DEFAULT NULL,
  `passedactivities` bigint(10) DEFAULT NULL,
  `errorcount` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbriccachacts_sta_ix` (`status`),
  KEY `[[dbprefix]]toolbriccachacts_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Contains accessibility summary information per activity.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_cache_check`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_cache_check` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `checkid` bigint(10) DEFAULT NULL,
  `checkcount` bigint(10) DEFAULT NULL,
  `errorcount` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbriccachchec_sta_ix` (`status`),
  KEY `[[dbprefix]]toolbriccachchec_err_ix` (`errorcount`),
  KEY `[[dbprefix]]toolbriccachchec_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Contains accessibility summary information per check.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_checks`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_checks` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `checktype` varchar(64) DEFAULT NULL,
  `shortname` varchar(64) DEFAULT NULL,
  `checkgroup` bigint(16) DEFAULT '0',
  `status` smallint(4) NOT NULL,
  `severity` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbricchec_che_ix` (`checktype`),
  KEY `[[dbprefix]]toolbricchec_che2_ix` (`checkgroup`),
  KEY `[[dbprefix]]toolbricchec_sta_ix` (`status`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Checks details' AUTO_INCREMENT=32 ;

--
-- Dumping data for table `[[dbprefix]]tool_brickfield_checks`
--

INSERT INTO `[[dbprefix]]tool_brickfield_checks` VALUES
(1, 'full', 'a_links_dont_open_new_window', 4, 1, 1),
(2, 'full', 'a_must_contain_text', 4, 1, 1),
(3, 'full', 'area_dont_open_new_window', 4, 1, 1),
(4, 'full', 'area_has_alt_value', 4, 1, 1),
(5, 'full', 'a_suspicious_link_text', 4, 1, 1),
(6, 'full', 'basefont_is_not_used', 7, 1, 1),
(7, 'full', 'blink_is_not_used', 7, 1, 1),
(8, 'full', 'bold_is_not_used', 7, 1, 1),
(9, 'full', 'content_too_long', 7, 1, 1),
(10, 'full', 'css_text_has_contrast', 7, 1, 1),
(11, 'full', 'embed_has_associated_no_embed', 7, 1, 1),
(12, 'full', 'header_h3', 3, 1, 1),
(13, 'full', 'headers_have_text', 3, 1, 1),
(14, 'full', 'i_is_not_used', 7, 1, 1),
(15, 'full', 'img_alt_is_different', 2, 1, 1),
(16, 'full', 'img_alt_is_too_long', 2, 1, 1),
(17, 'full', 'img_alt_not_empty_in_anchor', 2, 1, 1),
(18, 'full', 'img_alt_not_place_holder', 2, 1, 1),
(19, 'full', 'img_has_alt', 2, 1, 1),
(20, 'full', 'img_with_map_has_use_map', 2, 1, 1),
(21, 'full', 'legend_text_not_empty', 7, 1, 1),
(22, 'full', 'marquee_is_not_used', 7, 1, 1),
(23, 'full', 'no_headings', 3, 1, 1),
(24, 'full', 'object_must_have_embed', 5, 1, 1),
(25, 'full', 'object_must_have_title', 5, 1, 1),
(26, 'full', 'object_must_have_valid_title', 5, 1, 1),
(27, 'full', 'strike_is_not_used', 7, 1, 1),
(28, 'full', 'table_data_should_have_th', 6, 1, 1),
(29, 'full', 'table_summary_does_not_duplicate_caption', 6, 1, 1),
(30, 'full', 'table_td_should_not_merge', 6, 1, 1),
(31, 'full', 'table_th_should_have_scope', 6, 1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_content`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_content` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `areaid` bigint(10) NOT NULL,
  `contenthash` varchar(40) NOT NULL DEFAULT '',
  `iscurrent` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL,
  `timechecked` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbriccont_sta_ix` (`status`),
  KEY `[[dbprefix]]toolbriccont_iscare_ix` (`iscurrent`,`areaid`),
  KEY `[[dbprefix]]toolbriccont_are_ix` (`areaid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Content of an area at a particular time (recognised by a has' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_errors`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_errors` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `resultid` bigint(10) NOT NULL,
  `linenumber` bigint(10) NOT NULL DEFAULT '0',
  `errordata` longtext,
  `htmlcode` longtext,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbricerro_res_ix` (`resultid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Errors during the accessibility checks' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_process`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_process` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `item` varchar(64) DEFAULT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `innercontextid` bigint(10) DEFAULT NULL,
  `timecreated` bigint(16) DEFAULT NULL,
  `timecompleted` bigint(16) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbricproc_tim_ix` (`timecompleted`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Queued records to initiate new processing of specific target' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_results`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_results` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contentid` bigint(10) DEFAULT NULL,
  `checkid` bigint(10) NOT NULL,
  `errorcount` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbricresu_conche_ix` (`contentid`,`checkid`),
  KEY `[[dbprefix]]toolbricresu_con_ix` (`contentid`),
  KEY `[[dbprefix]]toolbricresu_che_ix` (`checkid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Results of the accessibility checks' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_schedule`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_schedule` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextlevel` bigint(10) NOT NULL DEFAULT '50',
  `instanceid` bigint(10) NOT NULL,
  `contextid` bigint(10) DEFAULT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `timeanalyzed` bigint(10) DEFAULT '0',
  `timemodified` bigint(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]toolbricsche_conins_uix` (`contextlevel`,`instanceid`),
  KEY `[[dbprefix]]toolbricsche_sta_ix` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Keeps the per course content analysis schedule.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_brickfield_summary`
--

CREATE TABLE `[[dbprefix]]tool_brickfield_summary` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `activities` bigint(10) DEFAULT NULL,
  `activitiespassed` bigint(10) DEFAULT NULL,
  `activitiesfailed` bigint(10) DEFAULT NULL,
  `errorschecktype1` bigint(10) DEFAULT NULL,
  `errorschecktype2` bigint(10) DEFAULT NULL,
  `errorschecktype3` bigint(10) DEFAULT NULL,
  `errorschecktype4` bigint(10) DEFAULT NULL,
  `errorschecktype5` bigint(10) DEFAULT NULL,
  `errorschecktype6` bigint(10) DEFAULT NULL,
  `errorschecktype7` bigint(10) DEFAULT NULL,
  `failedchecktype1` bigint(10) DEFAULT NULL,
  `failedchecktype2` bigint(10) DEFAULT NULL,
  `failedchecktype3` bigint(10) DEFAULT NULL,
  `failedchecktype4` bigint(10) DEFAULT NULL,
  `failedchecktype5` bigint(10) DEFAULT NULL,
  `failedchecktype6` bigint(10) DEFAULT NULL,
  `failedchecktype7` bigint(10) DEFAULT NULL,
  `percentchecktype1` bigint(10) DEFAULT NULL,
  `percentchecktype2` bigint(10) DEFAULT NULL,
  `percentchecktype3` bigint(10) DEFAULT NULL,
  `percentchecktype4` bigint(10) DEFAULT NULL,
  `percentchecktype5` bigint(10) DEFAULT NULL,
  `percentchecktype6` bigint(10) DEFAULT NULL,
  `percentchecktype7` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolbricsumm_sta_ix` (`status`),
  KEY `[[dbprefix]]toolbricsumm_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Contains accessibility check results summary information.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_cohortroles`
--

CREATE TABLE `[[dbprefix]]tool_cohortroles` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `cohortid` bigint(10) NOT NULL,
  `roleid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]toolcoho_cohroluse_uix` (`cohortid`,`roleid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Mapping of users to cohort role assignments.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_customlang`
--

CREATE TABLE `[[dbprefix]]tool_customlang` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lang` varchar(20) NOT NULL DEFAULT '',
  `componentid` bigint(10) NOT NULL,
  `stringid` varchar(255) NOT NULL DEFAULT '',
  `original` longtext NOT NULL,
  `master` longtext,
  `local` longtext,
  `timemodified` bigint(10) NOT NULL,
  `timecustomized` bigint(10) DEFAULT NULL,
  `outdated` smallint(3) DEFAULT '0',
  `modified` smallint(3) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]toolcust_lancomstr_uix` (`lang`,`componentid`,`stringid`),
  KEY `[[dbprefix]]toolcust_com_ix` (`componentid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Contains the working checkout of all strings and their custo' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_customlang_components`
--

CREATE TABLE `[[dbprefix]]tool_customlang_components` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Contains the list of all installed plugins that provide thei' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_dataprivacy_category`
--

CREATE TABLE `[[dbprefix]]tool_dataprivacy_category` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` longtext,
  `descriptionformat` tinyint(1) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Data categories' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_dataprivacy_ctxexpired`
--

CREATE TABLE `[[dbprefix]]tool_dataprivacy_ctxexpired` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `unexpiredroles` longtext,
  `expiredroles` longtext,
  `defaultexpired` tinyint(1) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]tooldatactxe_con_uix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Default comment for the table, please edit me' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_dataprivacy_ctxinstance`
--

CREATE TABLE `[[dbprefix]]tool_dataprivacy_ctxinstance` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextid` bigint(10) NOT NULL,
  `purposeid` bigint(10) DEFAULT NULL,
  `categoryid` bigint(10) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]tooldatactxi_con_uix` (`contextid`),
  KEY `[[dbprefix]]tooldatactxi_pur_ix` (`purposeid`),
  KEY `[[dbprefix]]tooldatactxi_cat_ix` (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Default comment for the table, please edit me' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_dataprivacy_ctxlevel`
--

CREATE TABLE `[[dbprefix]]tool_dataprivacy_ctxlevel` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `contextlevel` smallint(3) NOT NULL,
  `purposeid` bigint(10) DEFAULT NULL,
  `categoryid` bigint(10) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]tooldatactxl_con_uix` (`contextlevel`),
  KEY `[[dbprefix]]tooldatactxl_cat_ix` (`categoryid`),
  KEY `[[dbprefix]]tooldatactxl_pur_ix` (`purposeid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Default comment for the table, please edit me' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_dataprivacy_purpose`
--

CREATE TABLE `[[dbprefix]]tool_dataprivacy_purpose` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` longtext,
  `descriptionformat` tinyint(1) DEFAULT NULL,
  `lawfulbases` longtext NOT NULL,
  `sensitivedatareasons` longtext,
  `retentionperiod` varchar(255) NOT NULL DEFAULT '',
  `protected` tinyint(1) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Data purposes' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_dataprivacy_purposerole`
--

CREATE TABLE `[[dbprefix]]tool_dataprivacy_purposerole` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `purposeid` bigint(10) NOT NULL,
  `roleid` bigint(10) NOT NULL,
  `lawfulbases` longtext,
  `sensitivedatareasons` longtext,
  `retentionperiod` varchar(255) NOT NULL DEFAULT '',
  `protected` tinyint(1) DEFAULT NULL,
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]tooldatapurp_purrol_uix` (`purposeid`,`roleid`),
  KEY `[[dbprefix]]tooldatapurp_pur_ix` (`purposeid`),
  KEY `[[dbprefix]]tooldatapurp_rol_ix` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Data purpose overrides for a specific role' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_dataprivacy_request`
--

CREATE TABLE `[[dbprefix]]tool_dataprivacy_request` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` bigint(10) NOT NULL DEFAULT '0',
  `comments` longtext,
  `commentsformat` tinyint(2) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `requestedby` bigint(10) NOT NULL DEFAULT '0',
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `dpo` bigint(10) DEFAULT '0',
  `dpocomment` longtext,
  `dpocommentformat` tinyint(2) NOT NULL DEFAULT '0',
  `systemapproved` smallint(4) NOT NULL DEFAULT '0',
  `usermodified` bigint(10) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `creationmethod` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]tooldatarequ_use_ix` (`userid`),
  KEY `[[dbprefix]]tooldatarequ_req_ix` (`requestedby`),
  KEY `[[dbprefix]]tooldatarequ_dpo_ix` (`dpo`),
  KEY `[[dbprefix]]tooldatarequ_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Table for data requests' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_monitor_events`
--

CREATE TABLE `[[dbprefix]]tool_monitor_events` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `eventname` varchar(254) NOT NULL DEFAULT '',
  `contextid` bigint(10) NOT NULL,
  `contextlevel` bigint(10) NOT NULL,
  `contextinstanceid` bigint(10) NOT NULL,
  `link` varchar(254) NOT NULL DEFAULT '',
  `courseid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='A table that keeps a log of events related to subscriptions' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_monitor_history`
--

CREATE TABLE `[[dbprefix]]tool_monitor_history` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `sid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timesent` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]toolmonihist_siduse_uix` (`sid`,`userid`,`timesent`),
  KEY `[[dbprefix]]toolmonihist_sid_ix` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Table to store history of message notifications sent' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_monitor_rules`
--

CREATE TABLE `[[dbprefix]]tool_monitor_rules` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `description` longtext,
  `descriptionformat` tinyint(1) NOT NULL,
  `name` varchar(254) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `plugin` varchar(254) NOT NULL DEFAULT '',
  `eventname` varchar(254) NOT NULL DEFAULT '',
  `template` longtext NOT NULL,
  `templateformat` tinyint(1) NOT NULL,
  `frequency` smallint(4) NOT NULL,
  `timewindow` mediumint(5) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolmonirule_couuse_ix` (`courseid`,`userid`),
  KEY `[[dbprefix]]toolmonirule_eve_ix` (`eventname`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Table to store rules' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_monitor_subscriptions`
--

CREATE TABLE `[[dbprefix]]tool_monitor_subscriptions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `ruleid` bigint(10) NOT NULL,
  `cmid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `lastnotificationsent` bigint(10) NOT NULL DEFAULT '0',
  `inactivedate` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolmonisubs_couuse_ix` (`courseid`,`userid`),
  KEY `[[dbprefix]]toolmonisubs_rul_ix` (`ruleid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Table to store user subscriptions to various rules' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_policy`
--

CREATE TABLE `[[dbprefix]]tool_policy` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `sortorder` mediumint(5) NOT NULL DEFAULT '999',
  `currentversionid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolpoli_cur_ix` (`currentversionid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Contains the list of policy documents defined on the site.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_policy_acceptances`
--

CREATE TABLE `[[dbprefix]]tool_policy_acceptances` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `policyversionid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `lang` varchar(30) NOT NULL DEFAULT '',
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `note` longtext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]toolpoliacce_poluse_uix` (`policyversionid`,`userid`),
  KEY `[[dbprefix]]toolpoliacce_pol_ix` (`policyversionid`),
  KEY `[[dbprefix]]toolpoliacce_use_ix` (`userid`),
  KEY `[[dbprefix]]toolpoliacce_use2_ix` (`usermodified`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Tracks users accepting the policy versions' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_policy_versions`
--

CREATE TABLE `[[dbprefix]]tool_policy_versions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(1333) NOT NULL DEFAULT '',
  `type` smallint(3) NOT NULL DEFAULT '0',
  `audience` smallint(3) NOT NULL DEFAULT '0',
  `archived` smallint(3) NOT NULL DEFAULT '0',
  `usermodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `policyid` bigint(10) NOT NULL,
  `agreementstyle` smallint(3) NOT NULL DEFAULT '0',
  `optional` smallint(3) NOT NULL DEFAULT '0',
  `revision` varchar(1333) NOT NULL DEFAULT '',
  `summary` longtext NOT NULL,
  `summaryformat` smallint(3) NOT NULL,
  `content` longtext NOT NULL,
  `contentformat` smallint(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolpolivers_use_ix` (`usermodified`),
  KEY `[[dbprefix]]toolpolivers_pol_ix` (`policyid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Holds versions of the policy documents' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_recyclebin_category`
--

CREATE TABLE `[[dbprefix]]tool_recyclebin_category` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `categoryid` bigint(10) NOT NULL,
  `shortname` varchar(255) NOT NULL DEFAULT '',
  `fullname` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolrecycate_tim_ix` (`timecreated`),
  KEY `[[dbprefix]]toolrecycate_cat_ix` (`categoryid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='A list of items in the category recycle bin' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_recyclebin_course`
--

CREATE TABLE `[[dbprefix]]tool_recyclebin_course` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `courseid` bigint(10) NOT NULL,
  `section` bigint(10) NOT NULL,
  `module` bigint(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]toolrecycour_tim_ix` (`timecreated`),
  KEY `[[dbprefix]]toolrecycour_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='A list of items in the course recycle bin' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_usertours_steps`
--

CREATE TABLE `[[dbprefix]]tool_usertours_steps` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `tourid` bigint(10) NOT NULL,
  `title` longtext,
  `content` longtext,
  `targettype` tinyint(2) NOT NULL,
  `targetvalue` longtext NOT NULL,
  `sortorder` bigint(10) NOT NULL DEFAULT '0',
  `configdata` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]tooluserstep_tousor_ix` (`tourid`,`sortorder`),
  KEY `[[dbprefix]]tooluserstep_tou_ix` (`tourid`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Steps in an tour' AUTO_INCREMENT=5 ;

--
-- Dumping data for table `[[dbprefix]]tool_usertours_steps`
--

INSERT INTO `[[dbprefix]]tool_usertours_steps` VALUES
(1, 1, 'tour_activityinfo_course_teacher_title,tool_usertours', 'tour_activityinfo_course_teacher_content,tool_usertours', 0, '[data-region=activity-information]', 0, '{}'),
(2, 2, 'tour_activityinfo_course_student_title,tool_usertours', 'tour_activityinfo_course_student_content,tool_usertours', 0, '[data-region=activity-information]', 0, '{}'),
(3, 3, 'tour_activityinfo_activity_teacher_title,tool_usertours', 'tour_activityinfo_activity_teacher_content,tool_usertours', 0, '[data-region=activity-information]', 0, '{}'),
(4, 4, 'tour_activityinfo_activity_student_title,tool_usertours', 'tour_activityinfo_activity_student_content,tool_usertours', 0, '[data-region=activity-information]', 0, '{}');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]tool_usertours_tours`
--

CREATE TABLE `[[dbprefix]]tool_usertours_tours` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` longtext,
  `pathmatch` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `sortorder` bigint(10) NOT NULL DEFAULT '0',
  `configdata` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='List of tours' AUTO_INCREMENT=5 ;

--
-- Dumping data for table `[[dbprefix]]tool_usertours_tours`
--

INSERT INTO `[[dbprefix]]tool_usertours_tours` VALUES
(1, 'Activity information in course homepage (Teacher)', 'A tour of the activity information for Teacher display on the course homepage', '/course/view.php%', 1, 3, '{"placement":"bottom","orphan":"0","backdrop":"1","reflex":"0","filtervalues":{"accessdate":{"filter_accessdate":"tool_usertours_accountcreation","filter_accessdate_range":0,"filter_accessdate_enabled":"0"},"category":[],"course":[],"courseformat":[],"role":["manager","teacher","editingteacher"],"theme":[],"cssselector":["[data-region=activity-information]"]},"majorupdatetime":1620109487,"shipped_tour":true,"shipped_filename":"311_activity_information_course_page_teacher.json","shipped_version":2}'),
(2, 'Activity information in course homepage (Student)', 'A tour of the activity information for Student display on the course homepage', '/course/view.php%', 1, 2, '{"placement":"bottom","orphan":"0","backdrop":"1","reflex":"0","filtervalues":{"accessdate":{"filter_accessdate":"tool_usertours_accountcreation","filter_accessdate_range":0,"filter_accessdate_enabled":"0"},"category":[],"course":[],"courseformat":[],"role":["student"],"theme":[],"cssselector":["[data-region=activity-information]"]},"majorupdatetime":1620109487,"shipped_tour":true,"shipped_filename":"311_activity_information_course_page_student.json","shipped_version":2}'),
(3, 'Activity information in activity page (Teacher)', 'A tour of the activity information for Teacher display on the activity page', '/mod/%/view.php%', 1, 1, '{"placement":"bottom","orphan":"0","backdrop":"1","reflex":"0","filtervalues":{"accessdate":{"filter_accessdate":"tool_usertours_accountcreation","filter_accessdate_range":0,"filter_accessdate_enabled":"0"},"category":[],"course":[],"courseformat":[],"role":["manager","teacher","editingteacher"],"theme":[],"cssselector":["[data-region=activity-information]"]},"majorupdatetime":1620110287,"shipped_tour":true,"shipped_filename":"311_activity_information_activity_page_teacher.json","shipped_version":2}'),
(4, 'Activity information in activity page (Student)', 'A tour of the activity information for Student display on the activity page', '/mod/%/view.php%', 1, 0, '{"placement":"bottom","orphan":"0","backdrop":"1","reflex":"0","filtervalues":{"accessdate":{"filter_accessdate":"tool_usertours_accountcreation","filter_accessdate_range":0,"filter_accessdate_enabled":"0"},"category":[],"course":[],"courseformat":[],"role":["student"],"theme":[],"cssselector":["[data-region=activity-information]"]},"majorupdatetime":1620110287,"shipped_tour":true,"shipped_filename":"311_activity_information_activity_page_student.json","shipped_version":2}');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]upgrade_log`
--

CREATE TABLE `[[dbprefix]]upgrade_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `type` bigint(10) NOT NULL,
  `plugin` varchar(100) DEFAULT NULL,
  `version` varchar(100) DEFAULT NULL,
  `targetversion` varchar(100) DEFAULT NULL,
  `info` varchar(255) NOT NULL DEFAULT '',
  `details` longtext,
  `backtrace` longtext,
  `userid` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]upgrlog_tim_ix` (`timemodified`),
  KEY `[[dbprefix]]upgrlog_typtim_ix` (`type`,`timemodified`),
  KEY `[[dbprefix]]upgrlog_use_ix` (`userid`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Upgrade logging' AUTO_INCREMENT=1254 ;

--
-- Dumping data for table `[[dbprefix]]upgrade_log`
--

INSERT INTO `[[dbprefix]]upgrade_log` VALUES
(1, 0, 'core', '2021051718', '2021051718', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(2, 0, 'core', '2021051718', '2021051718', 'Core installed', NULL, '', 0, [[timestamp]]),
(3, 0, 'antivirus_clamav', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(4, 0, 'antivirus_clamav', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(5, 0, 'antivirus_clamav', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(6, 0, 'availability_completion', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(7, 0, 'availability_completion', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(8, 0, 'availability_completion', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(9, 0, 'availability_date', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(10, 0, 'availability_date', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(11, 0, 'availability_date', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(12, 0, 'availability_grade', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(13, 0, 'availability_grade', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(14, 0, 'availability_grade', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(15, 0, 'availability_group', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(16, 0, 'availability_group', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(17, 0, 'availability_group', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(18, 0, 'availability_grouping', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(19, 0, 'availability_grouping', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(20, 0, 'availability_grouping', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(21, 0, 'availability_profile', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(22, 0, 'availability_profile', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(23, 0, 'availability_profile', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(24, 0, 'qtype_calculated', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(25, 0, 'qtype_calculated', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(26, 0, 'qtype_calculated', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(27, 0, 'qtype_calculatedmulti', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(28, 0, 'qtype_calculatedmulti', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(29, 0, 'qtype_calculatedmulti', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(30, 0, 'qtype_calculatedsimple', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(31, 0, 'qtype_calculatedsimple', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(32, 0, 'qtype_calculatedsimple', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(33, 0, 'qtype_ddimageortext', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(34, 0, 'qtype_ddimageortext', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(35, 0, 'qtype_ddimageortext', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(36, 0, 'qtype_ddmarker', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(37, 0, 'qtype_ddmarker', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(38, 0, 'qtype_ddmarker', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(39, 0, 'qtype_ddwtos', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(40, 0, 'qtype_ddwtos', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(41, 0, 'qtype_ddwtos', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(42, 0, 'qtype_description', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(43, 0, 'qtype_description', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(44, 0, 'qtype_description', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(45, 0, 'qtype_essay', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(46, 0, 'qtype_essay', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(47, 0, 'qtype_essay', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(48, 0, 'qtype_gapselect', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(49, 0, 'qtype_gapselect', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(50, 0, 'qtype_gapselect', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(51, 0, 'qtype_match', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(52, 0, 'qtype_match', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(53, 0, 'qtype_match', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(54, 0, 'qtype_missingtype', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(55, 0, 'qtype_missingtype', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(56, 0, 'qtype_missingtype', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(57, 0, 'qtype_multianswer', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(58, 0, 'qtype_multianswer', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(59, 0, 'qtype_multianswer', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(60, 0, 'qtype_multichoice', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(61, 0, 'qtype_multichoice', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(62, 0, 'qtype_multichoice', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(63, 0, 'qtype_numerical', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(64, 0, 'qtype_numerical', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(65, 0, 'qtype_numerical', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(66, 0, 'qtype_random', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(67, 0, 'qtype_random', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(68, 0, 'qtype_random', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(69, 0, 'qtype_randomsamatch', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(70, 0, 'qtype_randomsamatch', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(71, 0, 'qtype_randomsamatch', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(72, 0, 'qtype_shortanswer', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(73, 0, 'qtype_shortanswer', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(74, 0, 'qtype_shortanswer', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(75, 0, 'qtype_truefalse', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(76, 0, 'qtype_truefalse', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(77, 0, 'qtype_truefalse', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(78, 0, 'mod_assign', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(79, 0, 'mod_assign', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(80, 0, 'mod_assign', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(81, 0, 'mod_assignment', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(82, 0, 'mod_assignment', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(83, 0, 'mod_assignment', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(84, 0, 'mod_book', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(85, 0, 'mod_book', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(86, 0, 'mod_book', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(87, 0, 'mod_chat', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(88, 0, 'mod_chat', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(89, 0, 'mod_chat', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(90, 0, 'mod_choice', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(91, 0, 'mod_choice', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(92, 0, 'mod_choice', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(93, 0, 'mod_data', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(94, 0, 'mod_data', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(95, 0, 'mod_data', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(96, 0, 'mod_feedback', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(97, 0, 'mod_feedback', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(98, 0, 'mod_feedback', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(99, 0, 'mod_folder', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(100, 0, 'mod_folder', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(101, 0, 'mod_folder', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(102, 0, 'mod_forum', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(103, 0, 'mod_forum', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(104, 0, 'mod_forum', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(105, 0, 'mod_glossary', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(106, 0, 'mod_glossary', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(107, 0, 'mod_glossary', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(108, 0, 'mod_h5pactivity', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(109, 0, 'mod_h5pactivity', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(110, 0, 'mod_h5pactivity', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(111, 0, 'mod_imscp', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(112, 0, 'mod_imscp', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(113, 0, 'mod_imscp', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(114, 0, 'mod_label', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(115, 0, 'mod_label', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(116, 0, 'mod_label', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(117, 0, 'mod_lesson', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(118, 0, 'mod_lesson', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(119, 0, 'mod_lesson', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(120, 0, 'mod_lti', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(121, 0, 'mod_lti', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(122, 0, 'mod_lti', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(123, 0, 'mod_page', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(124, 0, 'mod_page', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(125, 0, 'mod_page', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(126, 0, 'mod_quiz', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(127, 0, 'mod_quiz', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(128, 0, 'mod_quiz', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(129, 0, 'mod_resource', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(130, 0, 'mod_resource', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(131, 0, 'mod_resource', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(132, 0, 'mod_scorm', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(133, 0, 'mod_scorm', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(134, 0, 'mod_scorm', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(135, 0, 'mod_survey', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(136, 0, 'mod_survey', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(137, 0, 'mod_survey', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(138, 0, 'mod_url', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(139, 0, 'mod_url', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(140, 0, 'mod_url', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(141, 0, 'mod_wiki', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(142, 0, 'mod_wiki', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(143, 0, 'mod_wiki', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(144, 0, 'mod_workshop', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(145, 0, 'mod_workshop', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(146, 0, 'mod_workshop', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(147, 0, 'auth_cas', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(148, 0, 'auth_cas', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(149, 0, 'auth_cas', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(150, 0, 'auth_db', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(151, 0, 'auth_db', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(152, 0, 'auth_db', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(153, 0, 'auth_email', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(154, 0, 'auth_email', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(155, 0, 'auth_email', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(156, 0, 'auth_ldap', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(157, 0, 'auth_ldap', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(158, 0, 'auth_ldap', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(159, 0, 'auth_lti', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(160, 0, 'auth_lti', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(161, 0, 'auth_lti', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(162, 0, 'auth_manual', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(163, 0, 'auth_manual', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(164, 0, 'auth_manual', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(165, 0, 'auth_mnet', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(166, 0, 'auth_mnet', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(167, 0, 'auth_mnet', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(168, 0, 'auth_nologin', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(169, 0, 'auth_nologin', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(170, 0, 'auth_nologin', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(171, 0, 'auth_none', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(172, 0, 'auth_none', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(173, 0, 'auth_none', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(174, 0, 'auth_oauth2', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(175, 0, 'auth_oauth2', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(176, 0, 'auth_oauth2', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(177, 0, 'auth_shibboleth', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(178, 0, 'auth_shibboleth', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(179, 0, 'auth_shibboleth', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(180, 0, 'auth_webservice', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(181, 0, 'auth_webservice', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(182, 0, 'auth_webservice', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(183, 0, 'calendartype_gregorian', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(184, 0, 'calendartype_gregorian', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(185, 0, 'calendartype_gregorian', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(186, 0, 'customfield_checkbox', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(187, 0, 'customfield_checkbox', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(188, 0, 'customfield_checkbox', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(189, 0, 'customfield_date', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(190, 0, 'customfield_date', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(191, 0, 'customfield_date', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(192, 0, 'customfield_select', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(193, 0, 'customfield_select', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(194, 0, 'customfield_select', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(195, 0, 'customfield_text', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(196, 0, 'customfield_text', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(197, 0, 'customfield_text', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(198, 0, 'customfield_textarea', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(199, 0, 'customfield_textarea', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(200, 0, 'customfield_textarea', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(201, 0, 'enrol_category', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(202, 0, 'enrol_category', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(203, 0, 'enrol_category', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(204, 0, 'enrol_cohort', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(205, 0, 'enrol_cohort', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(206, 0, 'enrol_cohort', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(207, 0, 'enrol_database', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(208, 0, 'enrol_database', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(209, 0, 'enrol_database', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(210, 0, 'enrol_fee', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(211, 0, 'enrol_fee', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(212, 0, 'enrol_fee', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(213, 0, 'enrol_flatfile', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(214, 0, 'enrol_flatfile', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(215, 0, 'enrol_flatfile', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(216, 0, 'enrol_guest', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(217, 0, 'enrol_guest', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(218, 0, 'enrol_guest', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(219, 0, 'enrol_imsenterprise', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(220, 0, 'enrol_imsenterprise', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(221, 0, 'enrol_imsenterprise', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(222, 0, 'enrol_ldap', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(223, 0, 'enrol_ldap', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(224, 0, 'enrol_ldap', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(225, 0, 'enrol_lti', NULL, '2021051703', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(226, 0, 'enrol_lti', '2021051703', '2021051703', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(227, 0, 'enrol_lti', '2021051703', '2021051703', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(228, 0, 'enrol_manual', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(229, 0, 'enrol_manual', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(230, 0, 'enrol_manual', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(231, 0, 'enrol_meta', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(232, 0, 'enrol_meta', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(233, 0, 'enrol_meta', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(234, 0, 'enrol_mnet', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(235, 0, 'enrol_mnet', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(236, 0, 'enrol_mnet', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(237, 0, 'enrol_paypal', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(238, 0, 'enrol_paypal', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(239, 0, 'enrol_paypal', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(240, 0, 'enrol_self', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(241, 0, 'enrol_self', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(242, 0, 'enrol_self', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(243, 0, 'message_airnotifier', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(244, 0, 'message_airnotifier', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(245, 0, 'message_airnotifier', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(246, 0, 'message_email', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(247, 0, 'message_email', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(248, 0, 'message_email', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(249, 0, 'message_jabber', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(250, 0, 'message_jabber', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(251, 0, 'message_jabber', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(252, 0, 'message_popup', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(253, 0, 'message_popup', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(254, 0, 'message_popup', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(255, 0, 'block_accessreview', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(256, 0, 'block_accessreview', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(257, 0, 'block_accessreview', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(258, 0, 'block_activity_modules', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(259, 0, 'block_activity_modules', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(260, 0, 'block_activity_modules', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(261, 0, 'block_activity_results', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(262, 0, 'block_activity_results', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(263, 0, 'block_activity_results', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(264, 0, 'block_admin_bookmarks', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(265, 0, 'block_admin_bookmarks', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(266, 0, 'block_admin_bookmarks', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(267, 0, 'block_badges', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(268, 0, 'block_badges', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(269, 0, 'block_badges', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(270, 0, 'block_blog_menu', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(271, 0, 'block_blog_menu', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(272, 0, 'block_blog_menu', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(273, 0, 'block_blog_recent', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(274, 0, 'block_blog_recent', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(275, 0, 'block_blog_recent', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(276, 0, 'block_blog_tags', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(277, 0, 'block_blog_tags', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(278, 0, 'block_blog_tags', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(279, 0, 'block_calendar_month', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(280, 0, 'block_calendar_month', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(281, 0, 'block_calendar_month', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(282, 0, 'block_calendar_upcoming', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(283, 0, 'block_calendar_upcoming', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(284, 0, 'block_calendar_upcoming', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(285, 0, 'block_comments', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(286, 0, 'block_comments', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(287, 0, 'block_comments', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(288, 0, 'block_completionstatus', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(289, 0, 'block_completionstatus', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(290, 0, 'block_completionstatus', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(291, 0, 'block_course_list', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(292, 0, 'block_course_list', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(293, 0, 'block_course_list', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(294, 0, 'block_course_summary', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(295, 0, 'block_course_summary', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(296, 0, 'block_course_summary', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(297, 0, 'block_feedback', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(298, 0, 'block_feedback', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(299, 0, 'block_feedback', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(300, 0, 'block_globalsearch', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(301, 0, 'block_globalsearch', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(302, 0, 'block_globalsearch', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(303, 0, 'block_glossary_random', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(304, 0, 'block_glossary_random', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(305, 0, 'block_glossary_random', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(306, 0, 'block_html', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(307, 0, 'block_html', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(308, 0, 'block_html', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(309, 0, 'block_login', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(310, 0, 'block_login', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(311, 0, 'block_login', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(312, 0, 'block_lp', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(313, 0, 'block_lp', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(314, 0, 'block_lp', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(315, 0, 'block_mentees', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(316, 0, 'block_mentees', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(317, 0, 'block_mentees', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(318, 0, 'block_mnet_hosts', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(319, 0, 'block_mnet_hosts', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(320, 0, 'block_mnet_hosts', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(321, 0, 'block_myoverview', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(322, 0, 'block_myoverview', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(323, 0, 'block_myoverview', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(324, 0, 'block_myprofile', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(325, 0, 'block_myprofile', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(326, 0, 'block_myprofile', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(327, 0, 'block_navigation', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(328, 0, 'block_navigation', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(329, 0, 'block_navigation', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(330, 0, 'block_news_items', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(331, 0, 'block_news_items', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(332, 0, 'block_news_items', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(333, 0, 'block_online_users', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(334, 0, 'block_online_users', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(335, 0, 'block_online_users', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(336, 0, 'block_private_files', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(337, 0, 'block_private_files', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(338, 0, 'block_private_files', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(339, 0, 'block_quiz_results', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(340, 0, 'block_quiz_results', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(341, 0, 'block_quiz_results', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(342, 0, 'block_recent_activity', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(343, 0, 'block_recent_activity', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(344, 0, 'block_recent_activity', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(345, 0, 'block_recentlyaccessedcourses', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(346, 0, 'block_recentlyaccessedcourses', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(347, 0, 'block_recentlyaccessedcourses', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(348, 0, 'block_recentlyaccesseditems', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(349, 0, 'block_recentlyaccesseditems', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(350, 0, 'block_recentlyaccesseditems', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(351, 0, 'block_rss_client', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(352, 0, 'block_rss_client', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(353, 0, 'block_rss_client', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(354, 0, 'block_search_forums', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(355, 0, 'block_search_forums', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(356, 0, 'block_search_forums', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(357, 0, 'block_section_links', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(358, 0, 'block_section_links', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(359, 0, 'block_section_links', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(360, 0, 'block_selfcompletion', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(361, 0, 'block_selfcompletion', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(362, 0, 'block_selfcompletion', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(363, 0, 'block_settings', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(364, 0, 'block_settings', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(365, 0, 'block_settings', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(366, 0, 'block_site_main_menu', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(367, 0, 'block_site_main_menu', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(368, 0, 'block_site_main_menu', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(369, 0, 'block_social_activities', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(370, 0, 'block_social_activities', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(371, 0, 'block_social_activities', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(372, 0, 'block_starredcourses', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(373, 0, 'block_starredcourses', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(374, 0, 'block_starredcourses', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(375, 0, 'block_tag_flickr', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(376, 0, 'block_tag_flickr', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(377, 0, 'block_tag_flickr', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(378, 0, 'block_tag_youtube', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(379, 0, 'block_tag_youtube', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(380, 0, 'block_tag_youtube', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(381, 0, 'block_tags', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(382, 0, 'block_tags', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(383, 0, 'block_tags', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(384, 0, 'block_timeline', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(385, 0, 'block_timeline', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(386, 0, 'block_timeline', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(387, 0, 'media_html5audio', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(388, 0, 'media_html5audio', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(389, 0, 'media_html5audio', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(390, 0, 'media_html5video', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(391, 0, 'media_html5video', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(392, 0, 'media_html5video', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(393, 0, 'media_swf', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(394, 0, 'media_swf', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(395, 0, 'media_swf', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(396, 0, 'media_videojs', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(397, 0, 'media_videojs', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(398, 0, 'media_videojs', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(399, 0, 'media_vimeo', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(400, 0, 'media_vimeo', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(401, 0, 'media_vimeo', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(402, 0, 'media_youtube', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(403, 0, 'media_youtube', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(404, 0, 'media_youtube', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(405, 0, 'filter_activitynames', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(406, 0, 'filter_activitynames', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(407, 0, 'filter_activitynames', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(408, 0, 'filter_algebra', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(409, 0, 'filter_algebra', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(410, 0, 'filter_algebra', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(411, 0, 'filter_censor', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(412, 0, 'filter_censor', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(413, 0, 'filter_censor', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(414, 0, 'filter_data', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(415, 0, 'filter_data', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(416, 0, 'filter_data', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(417, 0, 'filter_displayh5p', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(418, 0, 'filter_displayh5p', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(419, 0, 'filter_displayh5p', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(420, 0, 'filter_emailprotect', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(421, 0, 'filter_emailprotect', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(422, 0, 'filter_emailprotect', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(423, 0, 'filter_emoticon', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(424, 0, 'filter_emoticon', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(425, 0, 'filter_emoticon', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(426, 0, 'filter_glossary', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(427, 0, 'filter_glossary', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(428, 0, 'filter_glossary', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(429, 0, 'filter_mathjaxloader', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(430, 0, 'filter_mathjaxloader', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(431, 0, 'filter_mathjaxloader', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(432, 0, 'filter_mediaplugin', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(433, 0, 'filter_mediaplugin', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(434, 0, 'filter_mediaplugin', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(435, 0, 'filter_multilang', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(436, 0, 'filter_multilang', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(437, 0, 'filter_multilang', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(438, 0, 'filter_tex', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(439, 0, 'filter_tex', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(440, 0, 'filter_tex', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(441, 0, 'filter_tidy', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(442, 0, 'filter_tidy', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(443, 0, 'filter_tidy', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(444, 0, 'filter_urltolink', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(445, 0, 'filter_urltolink', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(446, 0, 'filter_urltolink', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(447, 0, 'editor_atto', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(448, 0, 'editor_atto', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(449, 0, 'editor_atto', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(450, 0, 'editor_textarea', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(451, 0, 'editor_textarea', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(452, 0, 'editor_textarea', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(453, 0, 'editor_tinymce', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(454, 0, 'editor_tinymce', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(455, 0, 'editor_tinymce', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(456, 0, 'format_singleactivity', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(457, 0, 'format_singleactivity', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(458, 0, 'format_singleactivity', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(459, 0, 'format_social', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(460, 0, 'format_social', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(461, 0, 'format_social', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(462, 0, 'format_topics', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(463, 0, 'format_topics', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(464, 0, 'format_topics', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(465, 0, 'format_weeks', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(466, 0, 'format_weeks', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(467, 0, 'format_weeks', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(468, 0, 'dataformat_csv', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(469, 0, 'dataformat_csv', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(470, 0, 'dataformat_csv', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(471, 0, 'dataformat_excel', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(472, 0, 'dataformat_excel', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(473, 0, 'dataformat_excel', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(474, 0, 'dataformat_html', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(475, 0, 'dataformat_html', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(476, 0, 'dataformat_html', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(477, 0, 'dataformat_json', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(478, 0, 'dataformat_json', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(479, 0, 'dataformat_json', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(480, 0, 'dataformat_ods', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(481, 0, 'dataformat_ods', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]);
INSERT INTO `[[dbprefix]]upgrade_log` VALUES
(482, 0, 'dataformat_ods', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(483, 0, 'dataformat_pdf', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(484, 0, 'dataformat_pdf', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(485, 0, 'dataformat_pdf', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(486, 0, 'profilefield_checkbox', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(487, 0, 'profilefield_checkbox', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(488, 0, 'profilefield_checkbox', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(489, 0, 'profilefield_datetime', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(490, 0, 'profilefield_datetime', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(491, 0, 'profilefield_datetime', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(492, 0, 'profilefield_menu', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(493, 0, 'profilefield_menu', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(494, 0, 'profilefield_menu', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(495, 0, 'profilefield_social', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(496, 0, 'profilefield_social', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(497, 0, 'profilefield_social', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(498, 0, 'profilefield_text', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(499, 0, 'profilefield_text', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(500, 0, 'profilefield_text', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(501, 0, 'profilefield_textarea', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(502, 0, 'profilefield_textarea', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(503, 0, 'profilefield_textarea', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(504, 0, 'report_backups', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(505, 0, 'report_backups', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(506, 0, 'report_backups', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(507, 0, 'report_competency', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(508, 0, 'report_competency', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(509, 0, 'report_competency', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(510, 0, 'report_completion', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(511, 0, 'report_completion', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(512, 0, 'report_completion', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(513, 0, 'report_configlog', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(514, 0, 'report_configlog', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(515, 0, 'report_configlog', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(516, 0, 'report_courseoverview', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(517, 0, 'report_courseoverview', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(518, 0, 'report_courseoverview', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(519, 0, 'report_eventlist', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(520, 0, 'report_eventlist', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(521, 0, 'report_eventlist', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(522, 0, 'report_infectedfiles', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(523, 0, 'report_infectedfiles', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(524, 0, 'report_infectedfiles', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(525, 0, 'report_insights', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(526, 0, 'report_insights', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(527, 0, 'report_insights', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(528, 0, 'report_log', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(529, 0, 'report_log', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(530, 0, 'report_log', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(531, 0, 'report_loglive', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(532, 0, 'report_loglive', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(533, 0, 'report_loglive', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(534, 0, 'report_outline', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(535, 0, 'report_outline', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(536, 0, 'report_outline', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(537, 0, 'report_participation', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(538, 0, 'report_participation', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(539, 0, 'report_participation', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(540, 0, 'report_performance', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(541, 0, 'report_performance', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(542, 0, 'report_performance', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(543, 0, 'report_progress', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(544, 0, 'report_progress', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(545, 0, 'report_progress', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(546, 0, 'report_questioninstances', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(547, 0, 'report_questioninstances', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(548, 0, 'report_questioninstances', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(549, 0, 'report_security', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(550, 0, 'report_security', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(551, 0, 'report_security', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(552, 0, 'report_stats', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(553, 0, 'report_stats', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(554, 0, 'report_stats', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(555, 0, 'report_status', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(556, 0, 'report_status', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(557, 0, 'report_status', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(558, 0, 'report_usersessions', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(559, 0, 'report_usersessions', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(560, 0, 'report_usersessions', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(561, 0, 'gradeexport_ods', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(562, 0, 'gradeexport_ods', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(563, 0, 'gradeexport_ods', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(564, 0, 'gradeexport_txt', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(565, 0, 'gradeexport_txt', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(566, 0, 'gradeexport_txt', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(567, 0, 'gradeexport_xls', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(568, 0, 'gradeexport_xls', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(569, 0, 'gradeexport_xls', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(570, 0, 'gradeexport_xml', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(571, 0, 'gradeexport_xml', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(572, 0, 'gradeexport_xml', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(573, 0, 'gradeimport_csv', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(574, 0, 'gradeimport_csv', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(575, 0, 'gradeimport_csv', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(576, 0, 'gradeimport_direct', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(577, 0, 'gradeimport_direct', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(578, 0, 'gradeimport_direct', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(579, 0, 'gradeimport_xml', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(580, 0, 'gradeimport_xml', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(581, 0, 'gradeimport_xml', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(582, 0, 'gradereport_grader', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(583, 0, 'gradereport_grader', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(584, 0, 'gradereport_grader', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(585, 0, 'gradereport_history', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(586, 0, 'gradereport_history', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(587, 0, 'gradereport_history', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(588, 0, 'gradereport_outcomes', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(589, 0, 'gradereport_outcomes', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(590, 0, 'gradereport_outcomes', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(591, 0, 'gradereport_overview', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(592, 0, 'gradereport_overview', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(593, 0, 'gradereport_overview', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(594, 0, 'gradereport_singleview', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(595, 0, 'gradereport_singleview', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(596, 0, 'gradereport_singleview', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(597, 0, 'gradereport_user', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(598, 0, 'gradereport_user', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(599, 0, 'gradereport_user', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(600, 0, 'gradingform_guide', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(601, 0, 'gradingform_guide', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(602, 0, 'gradingform_guide', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(603, 0, 'gradingform_rubric', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(604, 0, 'gradingform_rubric', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(605, 0, 'gradingform_rubric', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(606, 0, 'mlbackend_php', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(607, 0, 'mlbackend_php', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(608, 0, 'mlbackend_php', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(609, 0, 'mlbackend_python', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(610, 0, 'mlbackend_python', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(611, 0, 'mlbackend_python', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(612, 0, 'mnetservice_enrol', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(613, 0, 'mnetservice_enrol', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(614, 0, 'mnetservice_enrol', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(615, 0, 'webservice_rest', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(616, 0, 'webservice_rest', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(617, 0, 'webservice_rest', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(618, 0, 'webservice_soap', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(619, 0, 'webservice_soap', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(620, 0, 'webservice_soap', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(621, 0, 'webservice_xmlrpc', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(622, 0, 'webservice_xmlrpc', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(623, 0, 'webservice_xmlrpc', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(624, 0, 'repository_areafiles', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(625, 0, 'repository_areafiles', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(626, 0, 'repository_areafiles', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(627, 0, 'repository_boxnet', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(628, 0, 'repository_boxnet', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(629, 0, 'repository_boxnet', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(630, 0, 'repository_contentbank', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(631, 0, 'repository_contentbank', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(632, 0, 'repository_contentbank', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(633, 0, 'repository_coursefiles', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(634, 0, 'repository_coursefiles', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(635, 0, 'repository_coursefiles', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(636, 0, 'repository_dropbox', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(637, 0, 'repository_dropbox', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(638, 0, 'repository_dropbox', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(639, 0, 'repository_equella', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(640, 0, 'repository_equella', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(641, 0, 'repository_equella', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(642, 0, 'repository_filesystem', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(643, 0, 'repository_filesystem', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(644, 0, 'repository_filesystem', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(645, 0, 'repository_flickr', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(646, 0, 'repository_flickr', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(647, 0, 'repository_flickr', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(648, 0, 'repository_flickr_public', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(649, 0, 'repository_flickr_public', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(650, 0, 'repository_flickr_public', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(651, 0, 'repository_googledocs', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(652, 0, 'repository_googledocs', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(653, 0, 'repository_googledocs', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(654, 0, 'repository_local', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(655, 0, 'repository_local', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(656, 0, 'repository_local', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(657, 0, 'repository_merlot', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(658, 0, 'repository_merlot', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(659, 0, 'repository_merlot', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(660, 0, 'repository_nextcloud', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(661, 0, 'repository_nextcloud', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(662, 0, 'repository_nextcloud', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(663, 0, 'repository_onedrive', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(664, 0, 'repository_onedrive', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(665, 0, 'repository_onedrive', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(666, 0, 'repository_picasa', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(667, 0, 'repository_picasa', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(668, 0, 'repository_picasa', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(669, 0, 'repository_recent', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(670, 0, 'repository_recent', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(671, 0, 'repository_recent', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(672, 0, 'repository_s3', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(673, 0, 'repository_s3', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(674, 0, 'repository_s3', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(675, 0, 'repository_skydrive', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(676, 0, 'repository_skydrive', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(677, 0, 'repository_skydrive', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(678, 0, 'repository_upload', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(679, 0, 'repository_upload', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(680, 0, 'repository_upload', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(681, 0, 'repository_url', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(682, 0, 'repository_url', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(683, 0, 'repository_url', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(684, 0, 'repository_user', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(685, 0, 'repository_user', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(686, 0, 'repository_user', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(687, 0, 'repository_webdav', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(688, 0, 'repository_webdav', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(689, 0, 'repository_webdav', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(690, 0, 'repository_wikimedia', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(691, 0, 'repository_wikimedia', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(692, 0, 'repository_wikimedia', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(693, 0, 'repository_youtube', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(694, 0, 'repository_youtube', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(695, 0, 'repository_youtube', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(696, 0, 'portfolio_boxnet', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(697, 0, 'portfolio_boxnet', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(698, 0, 'portfolio_boxnet', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(699, 0, 'portfolio_download', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(700, 0, 'portfolio_download', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(701, 0, 'portfolio_download', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(702, 0, 'portfolio_flickr', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(703, 0, 'portfolio_flickr', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(704, 0, 'portfolio_flickr', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(705, 0, 'portfolio_googledocs', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(706, 0, 'portfolio_googledocs', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(707, 0, 'portfolio_googledocs', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(708, 0, 'portfolio_mahara', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(709, 0, 'portfolio_mahara', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(710, 0, 'portfolio_mahara', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(711, 0, 'portfolio_picasa', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(712, 0, 'portfolio_picasa', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(713, 0, 'portfolio_picasa', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(714, 0, 'search_simpledb', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(715, 0, 'search_simpledb', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(716, 0, 'search_simpledb', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(717, 0, 'search_solr', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(718, 0, 'search_solr', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(719, 0, 'search_solr', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(720, 0, 'qbehaviour_adaptive', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(721, 0, 'qbehaviour_adaptive', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(722, 0, 'qbehaviour_adaptive', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(723, 0, 'qbehaviour_adaptivenopenalty', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(724, 0, 'qbehaviour_adaptivenopenalty', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(725, 0, 'qbehaviour_adaptivenopenalty', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(726, 0, 'qbehaviour_deferredcbm', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(727, 0, 'qbehaviour_deferredcbm', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(728, 0, 'qbehaviour_deferredcbm', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(729, 0, 'qbehaviour_deferredfeedback', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(730, 0, 'qbehaviour_deferredfeedback', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(731, 0, 'qbehaviour_deferredfeedback', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(732, 0, 'qbehaviour_immediatecbm', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(733, 0, 'qbehaviour_immediatecbm', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(734, 0, 'qbehaviour_immediatecbm', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(735, 0, 'qbehaviour_immediatefeedback', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(736, 0, 'qbehaviour_immediatefeedback', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(737, 0, 'qbehaviour_immediatefeedback', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(738, 0, 'qbehaviour_informationitem', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(739, 0, 'qbehaviour_informationitem', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(740, 0, 'qbehaviour_informationitem', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(741, 0, 'qbehaviour_interactive', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(742, 0, 'qbehaviour_interactive', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(743, 0, 'qbehaviour_interactive', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(744, 0, 'qbehaviour_interactivecountback', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(745, 0, 'qbehaviour_interactivecountback', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(746, 0, 'qbehaviour_interactivecountback', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(747, 0, 'qbehaviour_manualgraded', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(748, 0, 'qbehaviour_manualgraded', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(749, 0, 'qbehaviour_manualgraded', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(750, 0, 'qbehaviour_missing', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(751, 0, 'qbehaviour_missing', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(752, 0, 'qbehaviour_missing', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(753, 0, 'qformat_aiken', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(754, 0, 'qformat_aiken', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(755, 0, 'qformat_aiken', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(756, 0, 'qformat_blackboard_six', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(757, 0, 'qformat_blackboard_six', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(758, 0, 'qformat_blackboard_six', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(759, 0, 'qformat_examview', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(760, 0, 'qformat_examview', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(761, 0, 'qformat_examview', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(762, 0, 'qformat_gift', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(763, 0, 'qformat_gift', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(764, 0, 'qformat_gift', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(765, 0, 'qformat_missingword', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(766, 0, 'qformat_missingword', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(767, 0, 'qformat_missingword', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(768, 0, 'qformat_multianswer', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(769, 0, 'qformat_multianswer', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(770, 0, 'qformat_multianswer', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(771, 0, 'qformat_webct', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(772, 0, 'qformat_webct', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(773, 0, 'qformat_webct', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(774, 0, 'qformat_xhtml', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(775, 0, 'qformat_xhtml', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(776, 0, 'qformat_xhtml', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(777, 0, 'qformat_xml', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(778, 0, 'qformat_xml', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(779, 0, 'qformat_xml', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(780, 0, 'tool_analytics', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(781, 0, 'tool_analytics', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(782, 0, 'tool_analytics', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(783, 0, 'tool_availabilityconditions', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(784, 0, 'tool_availabilityconditions', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(785, 0, 'tool_availabilityconditions', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(786, 0, 'tool_behat', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(787, 0, 'tool_behat', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(788, 0, 'tool_behat', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(789, 0, 'tool_brickfield', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(790, 0, 'tool_brickfield', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(791, 0, 'tool_brickfield', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(792, 0, 'tool_capability', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(793, 0, 'tool_capability', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(794, 0, 'tool_capability', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(795, 0, 'tool_cohortroles', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(796, 0, 'tool_cohortroles', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(797, 0, 'tool_cohortroles', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(798, 0, 'tool_customlang', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(799, 0, 'tool_customlang', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(800, 0, 'tool_customlang', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(801, 0, 'tool_dataprivacy', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(802, 0, 'tool_dataprivacy', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(803, 0, 'tool_dataprivacy', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(804, 0, 'tool_dbtransfer', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(805, 0, 'tool_dbtransfer', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(806, 0, 'tool_dbtransfer', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(807, 0, 'tool_filetypes', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(808, 0, 'tool_filetypes', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(809, 0, 'tool_filetypes', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(810, 0, 'tool_generator', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(811, 0, 'tool_generator', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(812, 0, 'tool_generator', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(813, 0, 'tool_health', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(814, 0, 'tool_health', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(815, 0, 'tool_health', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(816, 0, 'tool_httpsreplace', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(817, 0, 'tool_httpsreplace', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(818, 0, 'tool_httpsreplace', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(819, 0, 'tool_innodb', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(820, 0, 'tool_innodb', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(821, 0, 'tool_innodb', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(822, 0, 'tool_installaddon', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(823, 0, 'tool_installaddon', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(824, 0, 'tool_installaddon', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(825, 0, 'tool_langimport', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(826, 0, 'tool_langimport', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(827, 0, 'tool_langimport', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(828, 0, 'tool_licensemanager', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(829, 0, 'tool_licensemanager', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(830, 0, 'tool_licensemanager', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(831, 0, 'tool_log', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(832, 0, 'tool_log', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(833, 0, 'tool_log', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(834, 0, 'tool_lp', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(835, 0, 'tool_lp', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(836, 0, 'tool_lp', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(837, 0, 'tool_lpimportcsv', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(838, 0, 'tool_lpimportcsv', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(839, 0, 'tool_lpimportcsv', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(840, 0, 'tool_lpmigrate', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(841, 0, 'tool_lpmigrate', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(842, 0, 'tool_lpmigrate', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(843, 0, 'tool_messageinbound', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(844, 0, 'tool_messageinbound', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(845, 0, 'tool_messageinbound', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(846, 0, 'tool_mobile', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(847, 0, 'tool_mobile', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(848, 0, 'tool_mobile', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(849, 0, 'tool_monitor', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(850, 0, 'tool_monitor', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(851, 0, 'tool_monitor', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(852, 0, 'tool_moodlenet', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(853, 0, 'tool_moodlenet', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(854, 0, 'tool_moodlenet', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(855, 0, 'tool_multilangupgrade', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(856, 0, 'tool_multilangupgrade', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(857, 0, 'tool_multilangupgrade', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(858, 0, 'tool_oauth2', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(859, 0, 'tool_oauth2', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(860, 0, 'tool_oauth2', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(861, 0, 'tool_phpunit', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(862, 0, 'tool_phpunit', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(863, 0, 'tool_phpunit', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(864, 0, 'tool_policy', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(865, 0, 'tool_policy', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(866, 0, 'tool_policy', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(867, 0, 'tool_profiling', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(868, 0, 'tool_profiling', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(869, 0, 'tool_profiling', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(870, 0, 'tool_recyclebin', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(871, 0, 'tool_recyclebin', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(872, 0, 'tool_recyclebin', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(873, 0, 'tool_replace', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(874, 0, 'tool_replace', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(875, 0, 'tool_replace', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(876, 0, 'tool_spamcleaner', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(877, 0, 'tool_spamcleaner', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(878, 0, 'tool_spamcleaner', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(879, 0, 'tool_task', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(880, 0, 'tool_task', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(881, 0, 'tool_task', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(882, 0, 'tool_templatelibrary', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(883, 0, 'tool_templatelibrary', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(884, 0, 'tool_templatelibrary', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(885, 0, 'tool_unsuproles', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(886, 0, 'tool_unsuproles', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(887, 0, 'tool_unsuproles', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(888, 0, 'tool_uploadcourse', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(889, 0, 'tool_uploadcourse', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(890, 0, 'tool_uploadcourse', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(891, 0, 'tool_uploaduser', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(892, 0, 'tool_uploaduser', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(893, 0, 'tool_uploaduser', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(894, 0, 'tool_usertours', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(895, 0, 'tool_usertours', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(896, 0, 'tool_usertours', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(897, 0, 'tool_xmldb', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(898, 0, 'tool_xmldb', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(899, 0, 'tool_xmldb', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(900, 0, 'cachestore_apcu', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(901, 0, 'cachestore_apcu', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(902, 0, 'cachestore_apcu', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(903, 0, 'cachestore_file', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(904, 0, 'cachestore_file', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(905, 0, 'cachestore_file', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(906, 0, 'cachestore_memcached', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(907, 0, 'cachestore_memcached', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(908, 0, 'cachestore_memcached', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(909, 0, 'cachestore_mongodb', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(910, 0, 'cachestore_mongodb', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(911, 0, 'cachestore_mongodb', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(912, 0, 'cachestore_redis', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(913, 0, 'cachestore_redis', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(914, 0, 'cachestore_redis', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(915, 0, 'cachestore_session', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(916, 0, 'cachestore_session', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(917, 0, 'cachestore_session', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(918, 0, 'cachestore_static', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(919, 0, 'cachestore_static', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(920, 0, 'cachestore_static', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(921, 0, 'cachelock_file', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(922, 0, 'cachelock_file', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(923, 0, 'cachelock_file', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(924, 0, 'fileconverter_googledrive', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(925, 0, 'fileconverter_googledrive', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(926, 0, 'fileconverter_googledrive', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(927, 0, 'fileconverter_unoconv', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(928, 0, 'fileconverter_unoconv', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(929, 0, 'fileconverter_unoconv', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(930, 0, 'contenttype_h5p', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(931, 0, 'contenttype_h5p', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(932, 0, 'contenttype_h5p', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(933, 0, 'theme_boost', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(934, 0, 'theme_boost', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(935, 0, 'theme_boost', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(936, 0, 'theme_classic', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(937, 0, 'theme_classic', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(938, 0, 'theme_classic', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(939, 0, 'h5plib_v124', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(940, 0, 'h5plib_v124', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(941, 0, 'h5plib_v124', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(942, 0, 'paygw_paypal', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(943, 0, 'paygw_paypal', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(944, 0, 'paygw_paypal', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(945, 0, 'assignsubmission_comments', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(946, 0, 'assignsubmission_comments', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(947, 0, 'assignsubmission_comments', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(948, 0, 'assignsubmission_file', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(949, 0, 'assignsubmission_file', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(950, 0, 'assignsubmission_file', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(951, 0, 'assignsubmission_onlinetext', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]);
INSERT INTO `[[dbprefix]]upgrade_log` VALUES
(952, 0, 'assignsubmission_onlinetext', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(953, 0, 'assignsubmission_onlinetext', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(954, 0, 'assignfeedback_comments', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(955, 0, 'assignfeedback_comments', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(956, 0, 'assignfeedback_comments', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(957, 0, 'assignfeedback_editpdf', NULL, '2021051702', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(958, 0, 'assignfeedback_editpdf', '2021051702', '2021051702', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(959, 0, 'assignfeedback_editpdf', '2021051702', '2021051702', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(960, 0, 'assignfeedback_file', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(961, 0, 'assignfeedback_file', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(962, 0, 'assignfeedback_file', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(963, 0, 'assignfeedback_offline', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(964, 0, 'assignfeedback_offline', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(965, 0, 'assignfeedback_offline', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(966, 0, 'assignment_offline', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(967, 0, 'assignment_offline', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(968, 0, 'assignment_offline', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(969, 0, 'assignment_online', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(970, 0, 'assignment_online', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(971, 0, 'assignment_online', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(972, 0, 'assignment_upload', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(973, 0, 'assignment_upload', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(974, 0, 'assignment_upload', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(975, 0, 'assignment_uploadsingle', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(976, 0, 'assignment_uploadsingle', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(977, 0, 'assignment_uploadsingle', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(978, 0, 'booktool_exportimscp', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(979, 0, 'booktool_exportimscp', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(980, 0, 'booktool_exportimscp', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(981, 0, 'booktool_importhtml', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(982, 0, 'booktool_importhtml', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(983, 0, 'booktool_importhtml', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(984, 0, 'booktool_print', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(985, 0, 'booktool_print', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(986, 0, 'booktool_print', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(987, 0, 'datafield_checkbox', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(988, 0, 'datafield_checkbox', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(989, 0, 'datafield_checkbox', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(990, 0, 'datafield_date', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(991, 0, 'datafield_date', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(992, 0, 'datafield_date', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(993, 0, 'datafield_file', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(994, 0, 'datafield_file', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(995, 0, 'datafield_file', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(996, 0, 'datafield_latlong', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(997, 0, 'datafield_latlong', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(998, 0, 'datafield_latlong', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(999, 0, 'datafield_menu', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1000, 0, 'datafield_menu', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1001, 0, 'datafield_menu', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1002, 0, 'datafield_multimenu', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1003, 0, 'datafield_multimenu', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1004, 0, 'datafield_multimenu', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1005, 0, 'datafield_number', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1006, 0, 'datafield_number', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1007, 0, 'datafield_number', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1008, 0, 'datafield_picture', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1009, 0, 'datafield_picture', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1010, 0, 'datafield_picture', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1011, 0, 'datafield_radiobutton', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1012, 0, 'datafield_radiobutton', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1013, 0, 'datafield_radiobutton', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1014, 0, 'datafield_text', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1015, 0, 'datafield_text', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1016, 0, 'datafield_text', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1017, 0, 'datafield_textarea', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1018, 0, 'datafield_textarea', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1019, 0, 'datafield_textarea', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1020, 0, 'datafield_url', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1021, 0, 'datafield_url', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1022, 0, 'datafield_url', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1023, 0, 'datapreset_imagegallery', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1024, 0, 'datapreset_imagegallery', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1025, 0, 'datapreset_imagegallery', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1026, 0, 'forumreport_summary', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1027, 0, 'forumreport_summary', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1028, 0, 'forumreport_summary', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1029, 0, 'ltiservice_basicoutcomes', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1030, 0, 'ltiservice_basicoutcomes', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1031, 0, 'ltiservice_basicoutcomes', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1032, 0, 'ltiservice_gradebookservices', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1033, 0, 'ltiservice_gradebookservices', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1034, 0, 'ltiservice_gradebookservices', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1035, 0, 'ltiservice_memberships', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1036, 0, 'ltiservice_memberships', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1037, 0, 'ltiservice_memberships', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1038, 0, 'ltiservice_profile', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1039, 0, 'ltiservice_profile', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1040, 0, 'ltiservice_profile', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1041, 0, 'ltiservice_toolproxy', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1042, 0, 'ltiservice_toolproxy', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1043, 0, 'ltiservice_toolproxy', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1044, 0, 'ltiservice_toolsettings', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1045, 0, 'ltiservice_toolsettings', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1046, 0, 'ltiservice_toolsettings', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1047, 0, 'quiz_grading', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1048, 0, 'quiz_grading', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1049, 0, 'quiz_grading', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1050, 0, 'quiz_overview', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1051, 0, 'quiz_overview', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1052, 0, 'quiz_overview', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1053, 0, 'quiz_responses', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1054, 0, 'quiz_responses', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1055, 0, 'quiz_responses', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1056, 0, 'quiz_statistics', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1057, 0, 'quiz_statistics', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1058, 0, 'quiz_statistics', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1059, 0, 'quizaccess_delaybetweenattempts', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1060, 0, 'quizaccess_delaybetweenattempts', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1061, 0, 'quizaccess_delaybetweenattempts', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1062, 0, 'quizaccess_ipaddress', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1063, 0, 'quizaccess_ipaddress', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1064, 0, 'quizaccess_ipaddress', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1065, 0, 'quizaccess_numattempts', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1066, 0, 'quizaccess_numattempts', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1067, 0, 'quizaccess_numattempts', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1068, 0, 'quizaccess_offlineattempts', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1069, 0, 'quizaccess_offlineattempts', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1070, 0, 'quizaccess_offlineattempts', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1071, 0, 'quizaccess_openclosedate', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1072, 0, 'quizaccess_openclosedate', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1073, 0, 'quizaccess_openclosedate', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1074, 0, 'quizaccess_password', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1075, 0, 'quizaccess_password', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1076, 0, 'quizaccess_password', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1077, 0, 'quizaccess_seb', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1078, 0, 'quizaccess_seb', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1079, 0, 'quizaccess_seb', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1080, 0, 'quizaccess_securewindow', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1081, 0, 'quizaccess_securewindow', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1082, 0, 'quizaccess_securewindow', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1083, 0, 'quizaccess_timelimit', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1084, 0, 'quizaccess_timelimit', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1085, 0, 'quizaccess_timelimit', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1086, 0, 'scormreport_basic', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1087, 0, 'scormreport_basic', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1088, 0, 'scormreport_basic', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1089, 0, 'scormreport_graphs', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1090, 0, 'scormreport_graphs', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1091, 0, 'scormreport_graphs', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1092, 0, 'scormreport_interactions', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1093, 0, 'scormreport_interactions', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1094, 0, 'scormreport_interactions', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1095, 0, 'scormreport_objectives', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1096, 0, 'scormreport_objectives', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1097, 0, 'scormreport_objectives', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1098, 0, 'workshopform_accumulative', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1099, 0, 'workshopform_accumulative', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1100, 0, 'workshopform_accumulative', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1101, 0, 'workshopform_comments', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1102, 0, 'workshopform_comments', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1103, 0, 'workshopform_comments', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1104, 0, 'workshopform_numerrors', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1105, 0, 'workshopform_numerrors', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1106, 0, 'workshopform_numerrors', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1107, 0, 'workshopform_rubric', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1108, 0, 'workshopform_rubric', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1109, 0, 'workshopform_rubric', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1110, 0, 'workshopallocation_manual', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1111, 0, 'workshopallocation_manual', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1112, 0, 'workshopallocation_manual', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1113, 0, 'workshopallocation_random', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1114, 0, 'workshopallocation_random', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1115, 0, 'workshopallocation_random', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1116, 0, 'workshopallocation_scheduled', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1117, 0, 'workshopallocation_scheduled', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1118, 0, 'workshopallocation_scheduled', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1119, 0, 'workshopeval_best', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1120, 0, 'workshopeval_best', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1121, 0, 'workshopeval_best', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1122, 0, 'atto_accessibilitychecker', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1123, 0, 'atto_accessibilitychecker', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1124, 0, 'atto_accessibilitychecker', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1125, 0, 'atto_accessibilityhelper', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1126, 0, 'atto_accessibilityhelper', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1127, 0, 'atto_accessibilityhelper', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1128, 0, 'atto_align', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1129, 0, 'atto_align', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1130, 0, 'atto_align', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1131, 0, 'atto_backcolor', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1132, 0, 'atto_backcolor', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1133, 0, 'atto_backcolor', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1134, 0, 'atto_bold', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1135, 0, 'atto_bold', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1136, 0, 'atto_bold', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1137, 0, 'atto_charmap', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1138, 0, 'atto_charmap', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1139, 0, 'atto_charmap', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1140, 0, 'atto_clear', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1141, 0, 'atto_clear', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1142, 0, 'atto_clear', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1143, 0, 'atto_collapse', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1144, 0, 'atto_collapse', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1145, 0, 'atto_collapse', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1146, 0, 'atto_emojipicker', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1147, 0, 'atto_emojipicker', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1148, 0, 'atto_emojipicker', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1149, 0, 'atto_emoticon', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1150, 0, 'atto_emoticon', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1151, 0, 'atto_emoticon', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1152, 0, 'atto_equation', NULL, '2021051701', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1153, 0, 'atto_equation', '2021051701', '2021051701', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1154, 0, 'atto_equation', '2021051701', '2021051701', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1155, 0, 'atto_fontcolor', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1156, 0, 'atto_fontcolor', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1157, 0, 'atto_fontcolor', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1158, 0, 'atto_h5p', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1159, 0, 'atto_h5p', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1160, 0, 'atto_h5p', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1161, 0, 'atto_html', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1162, 0, 'atto_html', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1163, 0, 'atto_html', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1164, 0, 'atto_image', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1165, 0, 'atto_image', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1166, 0, 'atto_image', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1167, 0, 'atto_indent', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1168, 0, 'atto_indent', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1169, 0, 'atto_indent', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1170, 0, 'atto_italic', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1171, 0, 'atto_italic', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1172, 0, 'atto_italic', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1173, 0, 'atto_link', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1174, 0, 'atto_link', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1175, 0, 'atto_link', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1176, 0, 'atto_managefiles', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1177, 0, 'atto_managefiles', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1178, 0, 'atto_managefiles', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1179, 0, 'atto_media', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1180, 0, 'atto_media', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1181, 0, 'atto_media', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1182, 0, 'atto_noautolink', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1183, 0, 'atto_noautolink', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1184, 0, 'atto_noautolink', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1185, 0, 'atto_orderedlist', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1186, 0, 'atto_orderedlist', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1187, 0, 'atto_orderedlist', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1188, 0, 'atto_recordrtc', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1189, 0, 'atto_recordrtc', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1190, 0, 'atto_recordrtc', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1191, 0, 'atto_rtl', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1192, 0, 'atto_rtl', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1193, 0, 'atto_rtl', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1194, 0, 'atto_strike', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1195, 0, 'atto_strike', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1196, 0, 'atto_strike', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1197, 0, 'atto_subscript', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1198, 0, 'atto_subscript', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1199, 0, 'atto_subscript', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1200, 0, 'atto_superscript', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1201, 0, 'atto_superscript', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1202, 0, 'atto_superscript', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1203, 0, 'atto_table', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1204, 0, 'atto_table', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1205, 0, 'atto_table', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1206, 0, 'atto_title', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1207, 0, 'atto_title', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1208, 0, 'atto_title', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1209, 0, 'atto_underline', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1210, 0, 'atto_underline', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1211, 0, 'atto_underline', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1212, 0, 'atto_undo', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1213, 0, 'atto_undo', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1214, 0, 'atto_undo', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1215, 0, 'atto_unorderedlist', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1216, 0, 'atto_unorderedlist', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1217, 0, 'atto_unorderedlist', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1218, 0, 'tinymce_ctrlhelp', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1219, 0, 'tinymce_ctrlhelp', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1220, 0, 'tinymce_ctrlhelp', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1221, 0, 'tinymce_managefiles', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1222, 0, 'tinymce_managefiles', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1223, 0, 'tinymce_managefiles', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1224, 0, 'tinymce_moodleemoticon', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1225, 0, 'tinymce_moodleemoticon', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1226, 0, 'tinymce_moodleemoticon', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1227, 0, 'tinymce_moodleimage', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1228, 0, 'tinymce_moodleimage', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1229, 0, 'tinymce_moodleimage', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1230, 0, 'tinymce_moodlemedia', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1231, 0, 'tinymce_moodlemedia', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1232, 0, 'tinymce_moodlemedia', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1233, 0, 'tinymce_moodlenolink', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1234, 0, 'tinymce_moodlenolink', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1235, 0, 'tinymce_moodlenolink', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1236, 0, 'tinymce_pdw', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1237, 0, 'tinymce_pdw', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1238, 0, 'tinymce_pdw', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1239, 0, 'tinymce_spellchecker', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1240, 0, 'tinymce_spellchecker', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1241, 0, 'tinymce_spellchecker', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1242, 0, 'tinymce_wrap', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1243, 0, 'tinymce_wrap', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1244, 0, 'tinymce_wrap', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1245, 0, 'logstore_database', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1246, 0, 'logstore_database', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1247, 0, 'logstore_database', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1248, 0, 'logstore_legacy', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1249, 0, 'logstore_legacy', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1250, 0, 'logstore_legacy', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]),
(1251, 0, 'logstore_standard', NULL, '2021051700', 'Starting plugin installation', NULL, '', 0, [[timestamp]]),
(1252, 0, 'logstore_standard', '2021051700', '2021051700', 'Upgrade savepoint reached', NULL, '', 0, [[timestamp]]),
(1253, 0, 'logstore_standard', '2021051700', '2021051700', 'Plugin installed', NULL, '', 0, [[timestamp]]);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]url`
--

CREATE TABLE `[[dbprefix]]url` (
  `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',
  `externalurl` longtext NOT NULL,
  `display` smallint(4) NOT NULL DEFAULT '0',
  `displayoptions` longtext,
  `parameters` longtext,
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]url_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='each record is one url resource' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user`
--

CREATE TABLE `[[dbprefix]]user` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `auth` varchar(20) NOT NULL DEFAULT 'manual',
  `confirmed` tinyint(1) NOT NULL DEFAULT '0',
  `policyagreed` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  `suspended` tinyint(1) NOT NULL DEFAULT '0',
  `mnethostid` bigint(10) NOT NULL DEFAULT '0',
  `username` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `idnumber` varchar(255) NOT NULL DEFAULT '',
  `firstname` varchar(100) NOT NULL DEFAULT '',
  `lastname` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `emailstop` tinyint(1) NOT NULL DEFAULT '0',
  `phone1` varchar(20) NOT NULL DEFAULT '',
  `phone2` varchar(20) NOT NULL DEFAULT '',
  `institution` varchar(255) NOT NULL DEFAULT '',
  `department` varchar(255) NOT NULL DEFAULT '',
  `address` varchar(255) NOT NULL DEFAULT '',
  `city` varchar(120) NOT NULL DEFAULT '',
  `country` varchar(2) NOT NULL DEFAULT '',
  `lang` varchar(30) NOT NULL DEFAULT 'en',
  `calendartype` varchar(30) NOT NULL DEFAULT 'gregorian',
  `theme` varchar(50) NOT NULL DEFAULT '',
  `timezone` varchar(100) NOT NULL DEFAULT '99',
  `firstaccess` bigint(10) NOT NULL DEFAULT '0',
  `lastaccess` bigint(10) NOT NULL DEFAULT '0',
  `lastlogin` bigint(10) NOT NULL DEFAULT '0',
  `currentlogin` bigint(10) NOT NULL DEFAULT '0',
  `lastip` varchar(45) NOT NULL DEFAULT '',
  `secret` varchar(15) NOT NULL DEFAULT '',
  `picture` bigint(10) NOT NULL DEFAULT '0',
  `description` longtext,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT '1',
  `mailformat` tinyint(1) NOT NULL DEFAULT '1',
  `maildigest` tinyint(1) NOT NULL DEFAULT '0',
  `maildisplay` tinyint(2) NOT NULL DEFAULT '2',
  `autosubscribe` tinyint(1) NOT NULL DEFAULT '1',
  `trackforums` tinyint(1) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `trustbitmask` bigint(10) NOT NULL DEFAULT '0',
  `imagealt` varchar(255) DEFAULT NULL,
  `lastnamephonetic` varchar(255) DEFAULT NULL,
  `firstnamephonetic` varchar(255) DEFAULT NULL,
  `middlename` varchar(255) DEFAULT NULL,
  `alternatename` varchar(255) DEFAULT NULL,
  `moodlenetprofile` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]user_mneuse_uix` (`mnethostid`,`username`),
  KEY `[[dbprefix]]user_del_ix` (`deleted`),
  KEY `[[dbprefix]]user_con_ix` (`confirmed`),
  KEY `[[dbprefix]]user_fir_ix` (`firstname`),
  KEY `[[dbprefix]]user_las_ix` (`lastname`),
  KEY `[[dbprefix]]user_cit_ix` (`city`),
  KEY `[[dbprefix]]user_cou_ix` (`country`),
  KEY `[[dbprefix]]user_las2_ix` (`lastaccess`),
  KEY `[[dbprefix]]user_ema_ix` (`email`),
  KEY `[[dbprefix]]user_aut_ix` (`auth`),
  KEY `[[dbprefix]]user_idn_ix` (`idnumber`),
  KEY `[[dbprefix]]user_fir2_ix` (`firstnamephonetic`),
  KEY `[[dbprefix]]user_las3_ix` (`lastnamephonetic`),
  KEY `[[dbprefix]]user_mid_ix` (`middlename`),
  KEY `[[dbprefix]]user_alt_ix` (`alternatename`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='One record for each person' AUTO_INCREMENT=3 ;

--
-- Dumping data for table `[[dbprefix]]user`
--

INSERT INTO `[[dbprefix]]user` VALUES
(1, 'manual', 1, 0, 0, 0, 1, 'guest', '$2y$10$NMFcV3VUeo6X2kfX/gL.ueGH.zNNqwM/yTj5nVQo9F5TFdKpWMN3e', '', 'Guest user', ' ', 'root@localhost', 0, '', '', '', '', '', '', '', 'en', 'gregorian', '', '99', 0, 0, 0, 0, '', '', 0, 'This user is a special user that allows read-only access to some courses.', 1, 1, 0, 2, 1, 0, 0, [[timestamp]], 0, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'manual', 1, 0, 0, 0, 1, '[[admin_username]]', '[[admin_pass]]', '', '[[admin_fname]]', '[[admin_lname]]', '[[admin_email]]', 0, '', '', '', '', '', 'defaultcity', 'US', '[[language]]', 'gregorian', '', '99', [[timestamp]], [[timestamp]], 0, [[timestamp]], '[[clientip]]', '', 0, '', 1, 1, 0, 1, 1, 0, 0, [[timestamp]], 0, NULL, '', '', '', '', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_devices`
--

CREATE TABLE `[[dbprefix]]user_devices` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `appid` varchar(128) NOT NULL DEFAULT '',
  `name` varchar(32) NOT NULL DEFAULT '',
  `model` varchar(32) NOT NULL DEFAULT '',
  `platform` varchar(32) NOT NULL DEFAULT '',
  `version` varchar(32) NOT NULL DEFAULT '',
  `pushid` varchar(255) NOT NULL DEFAULT '',
  `uuid` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]userdevi_pususe_uix` (`pushid`,`userid`),
  KEY `[[dbprefix]]userdevi_uuiuse_ix` (`uuid`,`userid`),
  KEY `[[dbprefix]]userdevi_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='This table stores user''s mobile devices information in order' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_enrolments`
--

CREATE TABLE `[[dbprefix]]user_enrolments` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `status` bigint(10) NOT NULL DEFAULT '0',
  `enrolid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `timestart` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '2147483647',
  `modifierid` bigint(10) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]userenro_enruse_uix` (`enrolid`,`userid`),
  KEY `[[dbprefix]]userenro_enr_ix` (`enrolid`),
  KEY `[[dbprefix]]userenro_use_ix` (`userid`),
  KEY `[[dbprefix]]userenro_mod_ix` (`modifierid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Users participating in courses (aka enrolled users) - everyb' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_info_category`
--

CREATE TABLE `[[dbprefix]]user_info_category` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `sortorder` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Customisable fields categories' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_info_data`
--

CREATE TABLE `[[dbprefix]]user_info_data` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `fieldid` bigint(10) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  `dataformat` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]userinfodata_usefie_uix` (`userid`,`fieldid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Data for the customisable user fields' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_info_field`
--

CREATE TABLE `[[dbprefix]]user_info_field` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(255) NOT NULL DEFAULT 'shortname',
  `name` longtext NOT NULL,
  `datatype` varchar(255) NOT NULL DEFAULT '',
  `description` longtext,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT '0',
  `categoryid` bigint(10) NOT NULL DEFAULT '0',
  `sortorder` bigint(10) NOT NULL DEFAULT '0',
  `required` tinyint(2) NOT NULL DEFAULT '0',
  `locked` tinyint(2) NOT NULL DEFAULT '0',
  `visible` smallint(4) NOT NULL DEFAULT '0',
  `forceunique` tinyint(2) NOT NULL DEFAULT '0',
  `signup` tinyint(2) NOT NULL DEFAULT '0',
  `defaultdata` longtext,
  `defaultdataformat` tinyint(2) NOT NULL DEFAULT '0',
  `param1` longtext,
  `param2` longtext,
  `param3` longtext,
  `param4` longtext,
  `param5` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Customisable user profile fields' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_lastaccess`
--

CREATE TABLE `[[dbprefix]]user_lastaccess` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeaccess` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]userlast_usecou_uix` (`userid`,`courseid`),
  KEY `[[dbprefix]]userlast_use_ix` (`userid`),
  KEY `[[dbprefix]]userlast_cou_ix` (`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='To keep track of course page access times, used in online pa' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_password_history`
--

CREATE TABLE `[[dbprefix]]user_password_history` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `hash` varchar(255) NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]userpasshist_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='A rotating log of hashes of previously used passwords for ea' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_password_resets`
--

CREATE TABLE `[[dbprefix]]user_password_resets` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL,
  `timerequested` bigint(10) NOT NULL,
  `timererequested` bigint(10) NOT NULL DEFAULT '0',
  `token` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]userpassrese_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='table tracking password reset confirmation tokens' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_preferences`
--

CREATE TABLE `[[dbprefix]]user_preferences` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(1333) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]userpref_usenam_uix` (`userid`,`name`),
  KEY `[[dbprefix]]userpref_nam_ix` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Allows modules to store arbitrary user preferences' AUTO_INCREMENT=6 ;

--
-- Dumping data for table `[[dbprefix]]user_preferences`
--

INSERT INTO `[[dbprefix]]user_preferences` VALUES
(1, 2, 'core_message_migrate_data', '1'),
(2, 2, 'auth_manual_passwordupdatetime', '[[timestamp]]'),
(3, 2, 'email_bounce_count', '1'),
(4, 2, 'email_send_count', '1'),
(5, 2, 'login_failed_count_since_success', '0');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_private_key`
--

CREATE TABLE `[[dbprefix]]user_private_key` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `script` varchar(128) NOT NULL DEFAULT '',
  `value` varchar(128) NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `instance` bigint(10) DEFAULT NULL,
  `iprestriction` varchar(255) DEFAULT NULL,
  `validuntil` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]userprivkey_scrval_ix` (`script`,`value`),
  KEY `[[dbprefix]]userprivkey_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='access keys used in cookieless scripts - rss, etc.' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]wiki`
--

CREATE TABLE `[[dbprefix]]wiki` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT 'Wiki',
  `intro` longtext,
  `introformat` smallint(4) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `firstpagetitle` varchar(255) NOT NULL DEFAULT 'First Page',
  `wikimode` varchar(20) NOT NULL DEFAULT 'collaborative',
  `defaultformat` varchar(20) NOT NULL DEFAULT 'creole',
  `forceformat` tinyint(1) NOT NULL DEFAULT '1',
  `editbegin` bigint(10) NOT NULL DEFAULT '0',
  `editend` bigint(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]wiki_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Stores Wiki activity configuration' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]wiki_links`
--

CREATE TABLE `[[dbprefix]]wiki_links` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `subwikiid` bigint(10) NOT NULL DEFAULT '0',
  `frompageid` bigint(10) NOT NULL DEFAULT '0',
  `topageid` bigint(10) NOT NULL DEFAULT '0',
  `tomissingpage` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]wikilink_fro_ix` (`frompageid`),
  KEY `[[dbprefix]]wikilink_sub_ix` (`subwikiid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Page wiki links' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]wiki_locks`
--

CREATE TABLE `[[dbprefix]]wiki_locks` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `sectionname` varchar(255) DEFAULT NULL,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `lockedat` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Manages page locks' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]wiki_pages`
--

CREATE TABLE `[[dbprefix]]wiki_pages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `subwikiid` bigint(10) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT 'title',
  `cachedcontent` longtext NOT NULL,
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `timerendered` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `pageviews` bigint(10) NOT NULL DEFAULT '0',
  `readonly` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]wikipage_subtituse_uix` (`subwikiid`,`title`,`userid`),
  KEY `[[dbprefix]]wikipage_sub_ix` (`subwikiid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Stores wiki pages' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]wiki_subwikis`
--

CREATE TABLE `[[dbprefix]]wiki_subwikis` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `wikiid` bigint(10) NOT NULL DEFAULT '0',
  `groupid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]wikisubw_wikgrouse_uix` (`wikiid`,`groupid`,`userid`),
  KEY `[[dbprefix]]wikisubw_wik_ix` (`wikiid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Stores subwiki instances' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]wiki_synonyms`
--

CREATE TABLE `[[dbprefix]]wiki_synonyms` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `subwikiid` bigint(10) NOT NULL DEFAULT '0',
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `pagesynonym` varchar(255) NOT NULL DEFAULT 'Pagesynonym',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]wikisyno_pagpag_uix` (`pageid`,`pagesynonym`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Stores wiki pages synonyms' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]wiki_versions`
--

CREATE TABLE `[[dbprefix]]wiki_versions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `content` longtext NOT NULL,
  `contentformat` varchar(20) NOT NULL DEFAULT 'creole',
  `version` mediumint(5) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]wikivers_pag_ix` (`pageid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Stores wiki page history' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshop`
--

CREATE TABLE `[[dbprefix]]workshop` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` bigint(10) NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `intro` longtext,
  `introformat` smallint(3) NOT NULL DEFAULT '0',
  `instructauthors` longtext,
  `instructauthorsformat` smallint(3) NOT NULL DEFAULT '0',
  `instructreviewers` longtext,
  `instructreviewersformat` smallint(3) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL,
  `phase` smallint(3) DEFAULT '0',
  `useexamples` tinyint(2) DEFAULT '0',
  `usepeerassessment` tinyint(2) DEFAULT '0',
  `useselfassessment` tinyint(2) DEFAULT '0',
  `grade` decimal(10,5) DEFAULT '80.00000',
  `gradinggrade` decimal(10,5) DEFAULT '20.00000',
  `strategy` varchar(30) NOT NULL DEFAULT '',
  `evaluation` varchar(30) NOT NULL DEFAULT '',
  `gradedecimals` smallint(3) DEFAULT '0',
  `submissiontypetext` tinyint(1) NOT NULL DEFAULT '1',
  `submissiontypefile` tinyint(1) NOT NULL DEFAULT '1',
  `nattachments` smallint(3) DEFAULT '1',
  `submissionfiletypes` varchar(255) DEFAULT NULL,
  `latesubmissions` tinyint(2) DEFAULT '0',
  `maxbytes` bigint(10) DEFAULT '100000',
  `examplesmode` smallint(3) DEFAULT '0',
  `submissionstart` bigint(10) DEFAULT '0',
  `submissionend` bigint(10) DEFAULT '0',
  `assessmentstart` bigint(10) DEFAULT '0',
  `assessmentend` bigint(10) DEFAULT '0',
  `phaseswitchassessment` tinyint(2) NOT NULL DEFAULT '0',
  `conclusion` longtext,
  `conclusionformat` smallint(3) NOT NULL DEFAULT '1',
  `overallfeedbackmode` smallint(3) DEFAULT '1',
  `overallfeedbackfiles` smallint(3) DEFAULT '0',
  `overallfeedbackfiletypes` varchar(255) DEFAULT NULL,
  `overallfeedbackmaxbytes` bigint(10) DEFAULT '100000',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]work_cou_ix` (`course`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='This table keeps information about the module instances and ' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopallocation_scheduled`
--

CREATE TABLE `[[dbprefix]]workshopallocation_scheduled` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `enabled` tinyint(2) NOT NULL DEFAULT '0',
  `submissionend` bigint(10) NOT NULL,
  `timeallocated` bigint(10) DEFAULT NULL,
  `settings` longtext,
  `resultstatus` bigint(10) DEFAULT NULL,
  `resultmessage` varchar(1333) DEFAULT NULL,
  `resultlog` longtext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]worksche_wor_uix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Stores the allocation settings for the scheduled allocator' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopeval_best_settings`
--

CREATE TABLE `[[dbprefix]]workshopeval_best_settings` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `comparison` smallint(3) DEFAULT '5',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]workbestsett_wor_uix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Settings for the grading evaluation subplugin Comparison wit' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopform_accumulative`
--

CREATE TABLE `[[dbprefix]]workshopform_accumulative` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext,
  `descriptionformat` smallint(3) DEFAULT '0',
  `grade` bigint(10) NOT NULL,
  `weight` mediumint(5) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]workaccu_wor_ix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='The assessment dimensions definitions of Accumulative gradin' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopform_comments`
--

CREATE TABLE `[[dbprefix]]workshopform_comments` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext,
  `descriptionformat` smallint(3) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]workcomm_wor_ix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='The assessment dimensions definitions of Comments strategy f' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopform_numerrors`
--

CREATE TABLE `[[dbprefix]]workshopform_numerrors` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext,
  `descriptionformat` smallint(3) DEFAULT '0',
  `descriptiontrust` bigint(10) DEFAULT NULL,
  `grade0` varchar(50) DEFAULT NULL,
  `grade1` varchar(50) DEFAULT NULL,
  `weight` mediumint(5) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]worknume_wor_ix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='The assessment dimensions definitions of Number of errors gr' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopform_numerrors_map`
--

CREATE TABLE `[[dbprefix]]workshopform_numerrors_map` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `nonegative` bigint(10) NOT NULL,
  `grade` decimal(10,5) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]worknumemap_wornon_uix` (`workshopid`,`nonegative`),
  KEY `[[dbprefix]]worknumemap_wor_ix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='This maps the number of errors to a percentual grade for sub' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopform_rubric`
--

CREATE TABLE `[[dbprefix]]workshopform_rubric` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext,
  `descriptionformat` smallint(3) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]workrubr_wor_ix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='The assessment dimensions definitions of Rubric grading stra' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopform_rubric_config`
--

CREATE TABLE `[[dbprefix]]workshopform_rubric_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `layout` varchar(30) DEFAULT 'list',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]workrubrconf_wor_uix` (`workshopid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Configuration table for the Rubric grading strategy' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshopform_rubric_levels`
--

CREATE TABLE `[[dbprefix]]workshopform_rubric_levels` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `dimensionid` bigint(10) NOT NULL,
  `grade` decimal(10,5) NOT NULL,
  `definition` longtext,
  `definitionformat` smallint(3) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]workrubrleve_dim_ix` (`dimensionid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='The definition of rubric rating scales' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshop_aggregations`
--

CREATE TABLE `[[dbprefix]]workshop_aggregations` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `gradinggrade` decimal(10,5) DEFAULT NULL,
  `timegraded` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]workaggr_woruse_uix` (`workshopid`,`userid`),
  KEY `[[dbprefix]]workaggr_wor_ix` (`workshopid`),
  KEY `[[dbprefix]]workaggr_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Aggregated grades for assessment are stored here. The aggreg' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshop_assessments`
--

CREATE TABLE `[[dbprefix]]workshop_assessments` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `submissionid` bigint(10) NOT NULL,
  `reviewerid` bigint(10) NOT NULL,
  `weight` bigint(10) NOT NULL DEFAULT '1',
  `timecreated` bigint(10) DEFAULT '0',
  `timemodified` bigint(10) DEFAULT '0',
  `grade` decimal(10,5) DEFAULT NULL,
  `gradinggrade` decimal(10,5) DEFAULT NULL,
  `gradinggradeover` decimal(10,5) DEFAULT NULL,
  `gradinggradeoverby` bigint(10) DEFAULT NULL,
  `feedbackauthor` longtext,
  `feedbackauthorformat` smallint(3) DEFAULT '0',
  `feedbackauthorattachment` smallint(3) DEFAULT '0',
  `feedbackreviewer` longtext,
  `feedbackreviewerformat` smallint(3) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]workasse_sub_ix` (`submissionid`),
  KEY `[[dbprefix]]workasse_gra_ix` (`gradinggradeoverby`),
  KEY `[[dbprefix]]workasse_rev_ix` (`reviewerid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Info about the made assessment and automatically calculated ' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshop_grades`
--

CREATE TABLE `[[dbprefix]]workshop_grades` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `assessmentid` bigint(10) NOT NULL,
  `strategy` varchar(30) NOT NULL DEFAULT '',
  `dimensionid` bigint(10) NOT NULL,
  `grade` decimal(10,5) DEFAULT NULL,
  `peercomment` longtext,
  `peercommentformat` smallint(3) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `[[dbprefix]]workgrad_assstrdim_uix` (`assessmentid`,`strategy`,`dimensionid`),
  KEY `[[dbprefix]]workgrad_ass_ix` (`assessmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='How the reviewers filled-up the grading forms, given grades ' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]workshop_submissions`
--

CREATE TABLE `[[dbprefix]]workshop_submissions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `workshopid` bigint(10) NOT NULL,
  `example` tinyint(2) DEFAULT '0',
  `authorid` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `content` longtext,
  `contentformat` smallint(3) NOT NULL DEFAULT '0',
  `contenttrust` smallint(3) NOT NULL DEFAULT '0',
  `attachment` tinyint(2) DEFAULT '0',
  `grade` decimal(10,5) DEFAULT NULL,
  `gradeover` decimal(10,5) DEFAULT NULL,
  `gradeoverby` bigint(10) DEFAULT NULL,
  `feedbackauthor` longtext,
  `feedbackauthorformat` smallint(3) DEFAULT '0',
  `timegraded` bigint(10) DEFAULT NULL,
  `published` tinyint(2) DEFAULT '0',
  `late` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `[[dbprefix]]worksubm_wor_ix` (`workshopid`),
  KEY `[[dbprefix]]worksubm_gra_ix` (`gradeoverby`),
  KEY `[[dbprefix]]worksubm_aut_ix` (`authorid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] [[row_format]] COMMENT='Info about the submission and the aggregation of the grade f' AUTO_INCREMENT=1 ;

