-- Table structure for table `mdl_stats_daily`
--

CREATE TABLE `mdl_stats_daily` (
  `id` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'activity',
  `stat1` bigint(10) NOT NULL DEFAULT '0',
  `stat2` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='to accumulate daily stats';

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

--
-- Table structure for table `mdl_stats_monthly`
--

CREATE TABLE `mdl_stats_monthly` (
  `id` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'activity',
  `stat1` bigint(10) NOT NULL DEFAULT '0',
  `stat2` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='To accumulate monthly stats';

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

--
-- Table structure for table `mdl_stats_user_daily`
--

CREATE TABLE `mdl_stats_user_daily` (
  `id` bigint(10) NOT NULL,
  `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='To accumulate daily stats per course/user';

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

--
-- Table structure for table `mdl_stats_user_monthly`
--

CREATE TABLE `mdl_stats_user_monthly` (
  `id` bigint(10) NOT NULL,
  `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='To accumulate monthly stats per course/user';

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

--
-- Table structure for table `mdl_stats_user_weekly`
--

CREATE TABLE `mdl_stats_user_weekly` (
  `id` bigint(10) NOT NULL,
  `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='To accumulate weekly stats per course/user';

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

--
-- Table structure for table `mdl_stats_weekly`
--

CREATE TABLE `mdl_stats_weekly` (
  `id` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeend` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL DEFAULT '0',
  `stattype` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'activity',
  `stat1` bigint(10) NOT NULL DEFAULT '0',
  `stat2` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='To accumulate weekly stats';

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

--
-- Table structure for table `mdl_survey`
--

CREATE TABLE `mdl_survey` (
  `id` bigint(10) NOT NULL,
  `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `intro` longtext COLLATE utf8_unicode_ci NOT NULL,
  `introformat` smallint(4) NOT NULL DEFAULT '0',
  `questions` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Each record is one SURVEY module with its configuration';

--
-- Dumping data for table `mdl_survey`
--

INSERT INTO `mdl_survey` (`id`, `course`, `template`, `days`, `timecreated`, `timemodified`, `name`, `intro`, `introformat`, `questions`) VALUES
(1, 0, 0, 0, 985017600, 985017600, 'collesaname', 'collesaintro', 0, '25,26,27,28,29,30,43,44'),
(2, 0, 0, 0, 985017600, 985017600, 'collespname', 'collespintro', 0, '31,32,33,34,35,36,43,44'),
(3, 0, 0, 0, 985017600, 985017600, 'collesapname', 'collesapintro', 0, '37,38,39,40,41,42,43,44'),
(4, 0, 0, 0, 985017600, 985017600, 'attlsname', 'attlsintro', 0, '65,67,68'),
(5, 0, 0, 0, 985017600, 985017600, 'ciqname', 'ciqintro', 0, '69,70,71,72,73');

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

--
-- Table structure for table `mdl_survey_analysis`
--

CREATE TABLE `mdl_survey_analysis` (
  `id` bigint(10) NOT NULL,
  `survey` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `notes` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='text about each survey submission';

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

--
-- Table structure for table `mdl_survey_answers`
--

CREATE TABLE `mdl_survey_answers` (
  `id` bigint(10) NOT NULL,
  `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 COLLATE utf8_unicode_ci NOT NULL,
  `answer2` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='the answers to each questions filled by the users';

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

--
-- Table structure for table `mdl_survey_questions`
--

CREATE TABLE `mdl_survey_questions` (
  `id` bigint(10) NOT NULL,
  `text` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `shorttext` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `multi` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `intro` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` smallint(3) NOT NULL DEFAULT '0',
  `options` longtext COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='the questions conforming one survey';

--
-- Dumping data for table `mdl_survey_questions`
--

INSERT INTO `mdl_survey_questions` (`id`, `text`, `shorttext`, `multi`, `intro`, `type`, `options`) 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 `mdl_tag`
--

CREATE TABLE `mdl_tag` (
  `id` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rawname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tagtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8_unicode_ci,
  `descriptionformat` tinyint(2) NOT NULL DEFAULT '0',
  `flag` smallint(4) DEFAULT '0',
  `timemodified` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Tag table - this generic table will replace the old "tags" t';

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

--
-- Table structure for table `mdl_tag_correlation`
--

CREATE TABLE `mdl_tag_correlation` (
  `id` bigint(10) NOT NULL,
  `tagid` bigint(10) NOT NULL,
  `correlatedtags` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The rationale for the ''tag_correlation'' table is performance';

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

--
-- Table structure for table `mdl_tag_instance`
--

CREATE TABLE `mdl_tag_instance` (
  `id` bigint(10) NOT NULL,
  `tagid` bigint(10) NOT NULL,
  `itemtype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `itemid` bigint(10) NOT NULL,
  `tiuserid` bigint(10) NOT NULL DEFAULT '0',
  `ordering` bigint(10) DEFAULT NULL,
  `timemodified` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='tag_instance table holds the information of associations bet';

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

--
-- Table structure for table `mdl_temp_enroled_template`
--

CREATE TABLE `mdl_temp_enroled_template` (
  `id` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `roleid` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Temporary storage for course enrolments';

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

--
-- Table structure for table `mdl_temp_log_template`
--

CREATE TABLE `mdl_temp_log_template` (
  `id` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `course` bigint(10) NOT NULL DEFAULT '0',
  `action` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Temporary storage for daily logs';

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

--
-- Table structure for table `mdl_timezone`
--

CREATE TABLE `mdl_timezone` (
  `id` bigint(10) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `year` bigint(11) NOT NULL DEFAULT '0',
  `tzrule` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `gmtoff` bigint(11) NOT NULL DEFAULT '0',
  `dstoff` bigint(11) NOT NULL DEFAULT '0',
  `dst_month` tinyint(2) NOT NULL DEFAULT '0',
  `dst_startday` smallint(3) NOT NULL DEFAULT '0',
  `dst_weekday` smallint(3) NOT NULL DEFAULT '0',
  `dst_skipweeks` smallint(3) NOT NULL DEFAULT '0',
  `dst_time` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '00:00',
  `std_month` tinyint(2) NOT NULL DEFAULT '0',
  `std_startday` smallint(3) NOT NULL DEFAULT '0',
  `std_weekday` smallint(3) NOT NULL DEFAULT '0',
  `std_skipweeks` smallint(3) NOT NULL DEFAULT '0',
  `std_time` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT '00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Rules for calculating local wall clock time for users';

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

--
-- Table structure for table `mdl_tool_customlang`
--

CREATE TABLE `mdl_tool_customlang` (
  `id` bigint(10) NOT NULL,
  `lang` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `componentid` bigint(10) NOT NULL,
  `stringid` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `original` longtext COLLATE utf8_unicode_ci NOT NULL,
  `master` longtext COLLATE utf8_unicode_ci,
  `local` longtext COLLATE utf8_unicode_ci,
  `timemodified` bigint(10) NOT NULL,
  `timecustomized` bigint(10) DEFAULT NULL,
  `outdated` smallint(3) DEFAULT '0',
  `modified` smallint(3) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contains the working checkout of all strings and their custo';

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

--
-- Table structure for table `mdl_tool_customlang_components`
--

CREATE TABLE `mdl_tool_customlang_components` (
  `id` bigint(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `version` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contains the list of all installed plugins that provide thei';

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

--
-- Table structure for table `mdl_upgrade_log`
--

CREATE TABLE `mdl_upgrade_log` (
  `id` bigint(10) NOT NULL,
  `type` bigint(10) NOT NULL,
  `plugin` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `version` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `targetversion` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `details` longtext COLLATE utf8_unicode_ci,
  `backtrace` longtext COLLATE utf8_unicode_ci,
  `userid` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Upgrade logging';

--
-- Dumping data for table `mdl_upgrade_log`
--

INSERT INTO `mdl_upgrade_log` (`id`, `type`, `plugin`, `version`, `targetversion`, `info`, `details`, `backtrace`, `userid`, `timemodified`) VALUES
(1, 0, 'core', '2012120301', '2012120301', 'Upgrade savepoint reached', NULL, '', 0, 1359214485),
(2, 0, 'core', '2012120301', '2012120301', 'Core installed', NULL, '', 0, 1359214486),
(3, 0, 'qtype_calculated', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214486),
(4, 0, 'qtype_calculated', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214486),
(5, 0, 'qtype_calculated', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214486),
(6, 0, 'qtype_calculatedmulti', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(7, 0, 'qtype_calculatedmulti', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(8, 0, 'qtype_calculatedmulti', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(9, 0, 'qtype_calculatedsimple', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(10, 0, 'qtype_calculatedsimple', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(11, 0, 'qtype_calculatedsimple', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(12, 0, 'qtype_description', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(13, 0, 'qtype_description', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(14, 0, 'qtype_description', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(15, 0, 'qtype_essay', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(16, 0, 'qtype_essay', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(17, 0, 'qtype_essay', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(18, 0, 'qtype_match', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(19, 0, 'qtype_match', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(20, 0, 'qtype_match', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(21, 0, 'qtype_missingtype', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(22, 0, 'qtype_missingtype', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(23, 0, 'qtype_missingtype', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(24, 0, 'qtype_multianswer', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(25, 0, 'qtype_multianswer', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(26, 0, 'qtype_multianswer', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(27, 0, 'qtype_multichoice', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(28, 0, 'qtype_multichoice', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(29, 0, 'qtype_multichoice', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(30, 0, 'qtype_numerical', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(31, 0, 'qtype_numerical', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(32, 0, 'qtype_numerical', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(33, 0, 'qtype_random', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(34, 0, 'qtype_random', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(35, 0, 'qtype_random', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(36, 0, 'qtype_randomsamatch', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(37, 0, 'qtype_randomsamatch', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(38, 0, 'qtype_randomsamatch', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(39, 0, 'qtype_shortanswer', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(40, 0, 'qtype_shortanswer', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(41, 0, 'qtype_shortanswer', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(42, 0, 'qtype_truefalse', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(43, 0, 'qtype_truefalse', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214487),
(44, 0, 'qtype_truefalse', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(45, 0, 'mod_assign', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(46, 0, 'mod_assign', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(47, 0, 'mod_assignment', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(48, 0, 'mod_assignment', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(49, 0, 'mod_book', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(50, 0, 'mod_book', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214487),
(51, 0, 'mod_chat', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214487),
(52, 0, 'mod_chat', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214488),
(53, 0, 'mod_choice', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214488),
(54, 0, 'mod_choice', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214488),
(55, 0, 'mod_data', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214488),
(56, 0, 'mod_data', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214488),
(57, 0, 'mod_feedback', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214488),
(58, 0, 'mod_feedback', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214488),
(59, 0, 'mod_folder', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214488),
(60, 0, 'mod_folder', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214488),
(61, 0, 'mod_forum', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214488),
(62, 0, 'mod_forum', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214489),
(63, 0, 'mod_glossary', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214489),
(64, 0, 'mod_glossary', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214489),
(65, 0, 'mod_imscp', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214489),
(66, 0, 'mod_imscp', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214489),
(67, 0, 'mod_label', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214489),
(68, 0, 'mod_label', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214489),
(69, 0, 'mod_lesson', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214489),
(70, 0, 'mod_lesson', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214489),
(71, 0, 'mod_lti', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214489),
(72, 0, 'mod_lti', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214489),
(73, 0, 'mod_page', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214489),
(74, 0, 'mod_page', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214489),
(75, 0, 'mod_quiz', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214489),
(76, 0, 'mod_quiz', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214490),
(77, 0, 'mod_resource', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214490),
(78, 0, 'mod_resource', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214490),
(79, 0, 'mod_scorm', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214490),
(80, 0, 'mod_scorm', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214490),
(81, 0, 'mod_survey', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214490),
(82, 0, 'mod_survey', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214490),
(83, 0, 'mod_url', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214490),
(84, 0, 'mod_url', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(85, 0, 'mod_wiki', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(86, 0, 'mod_wiki', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(87, 0, 'mod_workshop', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(88, 0, 'mod_workshop', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(89, 0, 'auth_cas', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(90, 0, 'auth_cas', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(91, 0, 'auth_cas', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(92, 0, 'auth_db', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(93, 0, 'auth_db', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(94, 0, 'auth_db', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(95, 0, 'auth_email', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(96, 0, 'auth_email', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(97, 0, 'auth_email', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(98, 0, 'auth_fc', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(99, 0, 'auth_fc', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(100, 0, 'auth_fc', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(101, 0, 'auth_imap', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(102, 0, 'auth_imap', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(103, 0, 'auth_imap', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(104, 0, 'auth_ldap', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(105, 0, 'auth_ldap', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(106, 0, 'auth_ldap', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(107, 0, 'auth_manual', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(108, 0, 'auth_manual', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(109, 0, 'auth_manual', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214491),
(110, 0, 'auth_mnet', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214491),
(111, 0, 'auth_mnet', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214491),
(112, 0, 'auth_mnet', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(113, 0, 'auth_nntp', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(114, 0, 'auth_nntp', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(115, 0, 'auth_nntp', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(116, 0, 'auth_nologin', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(117, 0, 'auth_nologin', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(118, 0, 'auth_nologin', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(119, 0, 'auth_none', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(120, 0, 'auth_none', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(121, 0, 'auth_none', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(122, 0, 'auth_pam', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(123, 0, 'auth_pam', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(124, 0, 'auth_pam', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(125, 0, 'auth_pop3', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(126, 0, 'auth_pop3', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(127, 0, 'auth_pop3', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(128, 0, 'auth_radius', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(129, 0, 'auth_radius', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(130, 0, 'auth_radius', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(131, 0, 'auth_shibboleth', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(132, 0, 'auth_shibboleth', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(133, 0, 'auth_shibboleth', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(134, 0, 'auth_webservice', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(135, 0, 'auth_webservice', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(136, 0, 'auth_webservice', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(137, 0, 'enrol_authorize', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(138, 0, 'enrol_authorize', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(139, 0, 'enrol_authorize', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(140, 0, 'enrol_category', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(141, 0, 'enrol_category', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(142, 0, 'enrol_category', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(143, 0, 'enrol_cohort', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(144, 0, 'enrol_cohort', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(145, 0, 'enrol_cohort', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(146, 0, 'enrol_database', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(147, 0, 'enrol_database', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(148, 0, 'enrol_database', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(149, 0, 'enrol_flatfile', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(150, 0, 'enrol_flatfile', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(151, 0, 'enrol_flatfile', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(152, 0, 'enrol_guest', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(153, 0, 'enrol_guest', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(154, 0, 'enrol_guest', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(155, 0, 'enrol_imsenterprise', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(156, 0, 'enrol_imsenterprise', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(157, 0, 'enrol_imsenterprise', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(158, 0, 'enrol_ldap', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(159, 0, 'enrol_ldap', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(160, 0, 'enrol_ldap', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(161, 0, 'enrol_manual', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(162, 0, 'enrol_manual', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(163, 0, 'enrol_manual', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(164, 0, 'enrol_meta', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(165, 0, 'enrol_meta', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(166, 0, 'enrol_meta', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(167, 0, 'enrol_mnet', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(168, 0, 'enrol_mnet', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(169, 0, 'enrol_mnet', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(170, 0, 'enrol_paypal', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(171, 0, 'enrol_paypal', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(172, 0, 'enrol_paypal', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(173, 0, 'enrol_self', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(174, 0, 'enrol_self', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(175, 0, 'enrol_self', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(176, 0, 'message_email', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(177, 0, 'message_email', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(178, 0, 'message_email', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(179, 0, 'message_jabber', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(180, 0, 'message_jabber', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(181, 0, 'message_jabber', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(182, 0, 'message_popup', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(183, 0, 'message_popup', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214492),
(184, 0, 'message_popup', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(185, 0, 'block_activity_modules', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(186, 0, 'block_activity_modules', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(187, 0, 'block_admin_bookmarks', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(188, 0, 'block_admin_bookmarks', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(189, 0, 'block_blog_menu', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(190, 0, 'block_blog_menu', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(191, 0, 'block_blog_recent', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(192, 0, 'block_blog_recent', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(193, 0, 'block_blog_tags', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(194, 0, 'block_blog_tags', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(195, 0, 'block_calendar_month', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(196, 0, 'block_calendar_month', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214492),
(197, 0, 'block_calendar_upcoming', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214492),
(198, 0, 'block_calendar_upcoming', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(199, 0, 'block_comments', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(200, 0, 'block_comments', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(201, 0, 'block_community', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(202, 0, 'block_community', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(203, 0, 'block_completionstatus', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214493),
(204, 0, 'block_completionstatus', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214493),
(205, 0, 'block_course_list', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(206, 0, 'block_course_list', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(207, 0, 'block_course_overview', NULL, '2012121000', 'Starting plugin installation', NULL, '', 0, 1359214493),
(208, 0, 'block_course_overview', '2012121000', '2012121000', 'Plugin installed', NULL, '', 0, 1359214493),
(209, 0, 'block_course_summary', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214493),
(210, 0, 'block_course_summary', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214493),
(211, 0, 'block_feedback', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(212, 0, 'block_feedback', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(213, 0, 'block_glossary_random', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214493),
(214, 0, 'block_glossary_random', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214493),
(215, 0, 'block_html', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(216, 0, 'block_html', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(217, 0, 'block_login', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(218, 0, 'block_login', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(219, 0, 'block_mentees', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214493),
(220, 0, 'block_mentees', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214493),
(221, 0, 'block_messages', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(222, 0, 'block_messages', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(223, 0, 'block_mnet_hosts', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(224, 0, 'block_mnet_hosts', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(225, 0, 'block_myprofile', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(226, 0, 'block_myprofile', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(227, 0, 'block_navigation', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(228, 0, 'block_navigation', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(229, 0, 'block_news_items', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214493),
(230, 0, 'block_news_items', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214493),
(231, 0, 'block_online_users', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214493),
(232, 0, 'block_online_users', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214493),
(233, 0, 'block_participants', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(234, 0, 'block_participants', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(235, 0, 'block_private_files', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(236, 0, 'block_private_files', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(237, 0, 'block_quiz_results', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(238, 0, 'block_quiz_results', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(239, 0, 'block_recent_activity', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(240, 0, 'block_recent_activity', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(241, 0, 'block_rss_client', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(242, 0, 'block_rss_client', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(243, 0, 'block_search_forums', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(244, 0, 'block_search_forums', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(245, 0, 'block_section_links', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(246, 0, 'block_section_links', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(247, 0, 'block_selfcompletion', NULL, '2012112901', 'Starting plugin installation', NULL, '', 0, 1359214493),
(248, 0, 'block_selfcompletion', '2012112901', '2012112901', 'Plugin installed', NULL, '', 0, 1359214493),
(249, 0, 'block_settings', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(250, 0, 'block_settings', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(251, 0, 'block_site_main_menu', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(252, 0, 'block_site_main_menu', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(253, 0, 'block_social_activities', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(254, 0, 'block_social_activities', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(255, 0, 'block_tag_flickr', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(256, 0, 'block_tag_flickr', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(257, 0, 'block_tag_youtube', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(258, 0, 'block_tag_youtube', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(259, 0, 'block_tags', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(260, 0, 'block_tags', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(261, 0, 'filter_activitynames', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(262, 0, 'filter_activitynames', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(263, 0, 'filter_activitynames', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(264, 0, 'filter_algebra', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(265, 0, 'filter_algebra', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(266, 0, 'filter_algebra', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(267, 0, 'filter_censor', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(268, 0, 'filter_censor', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(269, 0, 'filter_censor', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(270, 0, 'filter_data', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(271, 0, 'filter_data', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(272, 0, 'filter_data', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(273, 0, 'filter_emailprotect', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(274, 0, 'filter_emailprotect', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(275, 0, 'filter_emailprotect', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(276, 0, 'filter_emoticon', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(277, 0, 'filter_emoticon', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(278, 0, 'filter_emoticon', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(279, 0, 'filter_glossary', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(280, 0, 'filter_glossary', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(281, 0, 'filter_glossary', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(282, 0, 'filter_mediaplugin', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(283, 0, 'filter_mediaplugin', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(284, 0, 'filter_mediaplugin', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(285, 0, 'filter_multilang', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(286, 0, 'filter_multilang', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(287, 0, 'filter_multilang', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214493),
(288, 0, 'filter_tex', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214493),
(289, 0, 'filter_tex', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214493),
(290, 0, 'filter_tex', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(291, 0, 'filter_tidy', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(292, 0, 'filter_tidy', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(293, 0, 'filter_tidy', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(294, 0, 'filter_urltolink', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(295, 0, 'filter_urltolink', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(296, 0, 'filter_urltolink', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(297, 0, 'editor_textarea', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(298, 0, 'editor_textarea', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(299, 0, 'editor_textarea', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(300, 0, 'editor_tinymce', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(301, 0, 'editor_tinymce', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(302, 0, 'editor_tinymce', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(303, 0, 'format_scorm', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(304, 0, 'format_scorm', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(305, 0, 'format_scorm', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(306, 0, 'format_social', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(307, 0, 'format_social', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(308, 0, 'format_social', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(309, 0, 'format_topics', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(310, 0, 'format_topics', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(311, 0, 'format_topics', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(312, 0, 'format_weeks', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(313, 0, 'format_weeks', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(314, 0, 'format_weeks', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(315, 0, 'profilefield_checkbox', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(316, 0, 'profilefield_checkbox', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(317, 0, 'profilefield_checkbox', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(318, 0, 'profilefield_datetime', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(319, 0, 'profilefield_datetime', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(320, 0, 'profilefield_datetime', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(321, 0, 'profilefield_menu', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(322, 0, 'profilefield_menu', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(323, 0, 'profilefield_menu', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(324, 0, 'profilefield_text', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(325, 0, 'profilefield_text', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(326, 0, 'profilefield_text', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(327, 0, 'profilefield_textarea', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(328, 0, 'profilefield_textarea', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(329, 0, 'profilefield_textarea', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(330, 0, 'report_backups', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(331, 0, 'report_backups', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(332, 0, 'report_backups', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(333, 0, 'report_completion', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(334, 0, 'report_completion', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(335, 0, 'report_completion', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(336, 0, 'report_configlog', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(337, 0, 'report_configlog', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(338, 0, 'report_configlog', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(339, 0, 'report_courseoverview', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(340, 0, 'report_courseoverview', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(341, 0, 'report_courseoverview', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(342, 0, 'report_log', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(343, 0, 'report_log', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(344, 0, 'report_log', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(345, 0, 'report_loglive', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(346, 0, 'report_loglive', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(347, 0, 'report_loglive', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(348, 0, 'report_outline', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(349, 0, 'report_outline', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(350, 0, 'report_outline', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(351, 0, 'report_participation', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(352, 0, 'report_participation', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(353, 0, 'report_participation', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(354, 0, 'report_progress', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(355, 0, 'report_progress', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(356, 0, 'report_progress', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(357, 0, 'report_questioninstances', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(358, 0, 'report_questioninstances', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(359, 0, 'report_questioninstances', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(360, 0, 'report_security', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(361, 0, 'report_security', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(362, 0, 'report_security', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(363, 0, 'report_stats', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(364, 0, 'report_stats', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(365, 0, 'report_stats', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(366, 0, 'gradeexport_ods', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(367, 0, 'gradeexport_ods', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(368, 0, 'gradeexport_ods', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(369, 0, 'gradeexport_txt', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(370, 0, 'gradeexport_txt', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(371, 0, 'gradeexport_txt', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(372, 0, 'gradeexport_xls', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(373, 0, 'gradeexport_xls', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(374, 0, 'gradeexport_xls', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(375, 0, 'gradeexport_xml', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(376, 0, 'gradeexport_xml', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(377, 0, 'gradeexport_xml', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(378, 0, 'gradeimport_csv', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(379, 0, 'gradeimport_csv', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(380, 0, 'gradeimport_csv', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(381, 0, 'gradeimport_xml', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(382, 0, 'gradeimport_xml', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(383, 0, 'gradeimport_xml', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(384, 0, 'gradereport_grader', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(385, 0, 'gradereport_grader', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(386, 0, 'gradereport_grader', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(387, 0, 'gradereport_outcomes', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(388, 0, 'gradereport_outcomes', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(389, 0, 'gradereport_outcomes', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(390, 0, 'gradereport_overview', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(391, 0, 'gradereport_overview', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(392, 0, 'gradereport_overview', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(393, 0, 'gradereport_user', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(394, 0, 'gradereport_user', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(395, 0, 'gradereport_user', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(396, 0, 'gradingform_guide', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(397, 0, 'gradingform_guide', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(398, 0, 'gradingform_guide', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214494),
(399, 0, 'gradingform_rubric', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214494),
(400, 0, 'gradingform_rubric', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214494),
(401, 0, 'gradingform_rubric', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(402, 0, 'mnetservice_enrol', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(403, 0, 'mnetservice_enrol', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(404, 0, 'mnetservice_enrol', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(405, 0, 'webservice_amf', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(406, 0, 'webservice_amf', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(407, 0, 'webservice_amf', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(408, 0, 'webservice_rest', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(409, 0, 'webservice_rest', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(410, 0, 'webservice_rest', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(411, 0, 'webservice_soap', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(412, 0, 'webservice_soap', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(413, 0, 'webservice_soap', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(414, 0, 'webservice_xmlrpc', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(415, 0, 'webservice_xmlrpc', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(416, 0, 'webservice_xmlrpc', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(417, 0, 'repository_alfresco', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(418, 0, 'repository_alfresco', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(419, 0, 'repository_alfresco', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(420, 0, 'repository_boxnet', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(421, 0, 'repository_boxnet', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(422, 0, 'repository_boxnet', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(423, 0, 'repository_coursefiles', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(424, 0, 'repository_coursefiles', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(425, 0, 'repository_coursefiles', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(426, 0, 'repository_dropbox', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(427, 0, 'repository_dropbox', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(428, 0, 'repository_dropbox', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(429, 0, 'repository_equella', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(430, 0, 'repository_equella', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(431, 0, 'repository_equella', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(432, 0, 'repository_filesystem', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(433, 0, 'repository_filesystem', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(434, 0, 'repository_filesystem', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(435, 0, 'repository_flickr', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(436, 0, 'repository_flickr', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(437, 0, 'repository_flickr', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(438, 0, 'repository_flickr_public', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(439, 0, 'repository_flickr_public', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(440, 0, 'repository_flickr_public', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(441, 0, 'repository_googledocs', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(442, 0, 'repository_googledocs', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(443, 0, 'repository_googledocs', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(444, 0, 'repository_local', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(445, 0, 'repository_local', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(446, 0, 'repository_local', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(447, 0, 'repository_merlot', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(448, 0, 'repository_merlot', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(449, 0, 'repository_merlot', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(450, 0, 'repository_picasa', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(451, 0, 'repository_picasa', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(452, 0, 'repository_picasa', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(453, 0, 'repository_recent', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(454, 0, 'repository_recent', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(455, 0, 'repository_recent', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(456, 0, 'repository_s3', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(457, 0, 'repository_s3', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(458, 0, 'repository_s3', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(459, 0, 'repository_upload', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(460, 0, 'repository_upload', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(461, 0, 'repository_upload', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(462, 0, 'repository_url', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(463, 0, 'repository_url', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(464, 0, 'repository_url', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(465, 0, 'repository_user', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(466, 0, 'repository_user', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(467, 0, 'repository_user', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(468, 0, 'repository_webdav', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(469, 0, 'repository_webdav', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(470, 0, 'repository_webdav', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(471, 0, 'repository_wikimedia', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(472, 0, 'repository_wikimedia', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(473, 0, 'repository_wikimedia', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(474, 0, 'repository_youtube', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(475, 0, 'repository_youtube', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(476, 0, 'repository_youtube', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(477, 0, 'portfolio_boxnet', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(478, 0, 'portfolio_boxnet', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(479, 0, 'portfolio_boxnet', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(480, 0, 'portfolio_download', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(481, 0, 'portfolio_download', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(482, 0, 'portfolio_download', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495);
INSERT INTO `mdl_upgrade_log` (`id`, `type`, `plugin`, `version`, `targetversion`, `info`, `details`, `backtrace`, `userid`, `timemodified`) VALUES
(483, 0, 'portfolio_flickr', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(484, 0, 'portfolio_flickr', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(485, 0, 'portfolio_flickr', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214495),
(486, 0, 'portfolio_googledocs', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214495),
(487, 0, 'portfolio_googledocs', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214495),
(488, 0, 'portfolio_googledocs', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(489, 0, 'portfolio_mahara', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(490, 0, 'portfolio_mahara', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(491, 0, 'portfolio_mahara', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(492, 0, 'portfolio_picasa', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(493, 0, 'portfolio_picasa', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(494, 0, 'portfolio_picasa', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(495, 0, 'qbehaviour_adaptive', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(496, 0, 'qbehaviour_adaptive', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(497, 0, 'qbehaviour_adaptive', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(498, 0, 'qbehaviour_adaptivenopenalty', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(499, 0, 'qbehaviour_adaptivenopenalty', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(500, 0, 'qbehaviour_adaptivenopenalty', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(501, 0, 'qbehaviour_deferredcbm', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(502, 0, 'qbehaviour_deferredcbm', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(503, 0, 'qbehaviour_deferredcbm', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(504, 0, 'qbehaviour_deferredfeedback', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(505, 0, 'qbehaviour_deferredfeedback', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(506, 0, 'qbehaviour_deferredfeedback', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(507, 0, 'qbehaviour_immediatecbm', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(508, 0, 'qbehaviour_immediatecbm', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(509, 0, 'qbehaviour_immediatecbm', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(510, 0, 'qbehaviour_immediatefeedback', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(511, 0, 'qbehaviour_immediatefeedback', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(512, 0, 'qbehaviour_immediatefeedback', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(513, 0, 'qbehaviour_informationitem', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(514, 0, 'qbehaviour_informationitem', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(515, 0, 'qbehaviour_informationitem', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(516, 0, 'qbehaviour_interactive', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(517, 0, 'qbehaviour_interactive', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(518, 0, 'qbehaviour_interactive', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(519, 0, 'qbehaviour_interactivecountback', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(520, 0, 'qbehaviour_interactivecountback', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(521, 0, 'qbehaviour_interactivecountback', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(522, 0, 'qbehaviour_manualgraded', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(523, 0, 'qbehaviour_manualgraded', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(524, 0, 'qbehaviour_manualgraded', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(525, 0, 'qbehaviour_missing', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(526, 0, 'qbehaviour_missing', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(527, 0, 'qbehaviour_missing', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(528, 0, 'qformat_aiken', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(529, 0, 'qformat_aiken', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(530, 0, 'qformat_aiken', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(531, 0, 'qformat_blackboard', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(532, 0, 'qformat_blackboard', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(533, 0, 'qformat_blackboard', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(534, 0, 'qformat_blackboard_six', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(535, 0, 'qformat_blackboard_six', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(536, 0, 'qformat_blackboard_six', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(537, 0, 'qformat_examview', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(538, 0, 'qformat_examview', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(539, 0, 'qformat_examview', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(540, 0, 'qformat_gift', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(541, 0, 'qformat_gift', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(542, 0, 'qformat_gift', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(543, 0, 'qformat_learnwise', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(544, 0, 'qformat_learnwise', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(545, 0, 'qformat_learnwise', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(546, 0, 'qformat_missingword', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(547, 0, 'qformat_missingword', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(548, 0, 'qformat_missingword', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(549, 0, 'qformat_multianswer', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(550, 0, 'qformat_multianswer', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(551, 0, 'qformat_multianswer', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(552, 0, 'qformat_webct', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(553, 0, 'qformat_webct', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(554, 0, 'qformat_webct', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(555, 0, 'qformat_xhtml', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(556, 0, 'qformat_xhtml', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(557, 0, 'qformat_xhtml', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(558, 0, 'qformat_xml', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(559, 0, 'qformat_xml', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(560, 0, 'qformat_xml', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(561, 0, 'tool_assignmentupgrade', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(562, 0, 'tool_assignmentupgrade', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(563, 0, 'tool_assignmentupgrade', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(564, 0, 'tool_capability', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(565, 0, 'tool_capability', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(566, 0, 'tool_capability', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(567, 0, 'tool_customlang', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(568, 0, 'tool_customlang', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(569, 0, 'tool_customlang', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(570, 0, 'tool_dbtransfer', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(571, 0, 'tool_dbtransfer', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(572, 0, 'tool_dbtransfer', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(573, 0, 'tool_generator', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(574, 0, 'tool_generator', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(575, 0, 'tool_generator', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(576, 0, 'tool_health', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(577, 0, 'tool_health', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(578, 0, 'tool_health', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(579, 0, 'tool_innodb', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(580, 0, 'tool_innodb', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(581, 0, 'tool_innodb', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(582, 0, 'tool_langimport', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(583, 0, 'tool_langimport', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(584, 0, 'tool_langimport', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(585, 0, 'tool_multilangupgrade', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(586, 0, 'tool_multilangupgrade', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(587, 0, 'tool_multilangupgrade', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(588, 0, 'tool_phpunit', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(589, 0, 'tool_phpunit', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(590, 0, 'tool_phpunit', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(591, 0, 'tool_profiling', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(592, 0, 'tool_profiling', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(593, 0, 'tool_profiling', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(594, 0, 'tool_qeupgradehelper', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(595, 0, 'tool_qeupgradehelper', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(596, 0, 'tool_qeupgradehelper', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(597, 0, 'tool_replace', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(598, 0, 'tool_replace', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(599, 0, 'tool_replace', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(600, 0, 'tool_spamcleaner', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(601, 0, 'tool_spamcleaner', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(602, 0, 'tool_spamcleaner', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(603, 0, 'tool_timezoneimport', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(604, 0, 'tool_timezoneimport', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(605, 0, 'tool_timezoneimport', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(606, 0, 'tool_unsuproles', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(607, 0, 'tool_unsuproles', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(608, 0, 'tool_unsuproles', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(609, 0, 'tool_uploaduser', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(610, 0, 'tool_uploaduser', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(611, 0, 'tool_uploaduser', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(612, 0, 'tool_xmldb', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(613, 0, 'tool_xmldb', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(614, 0, 'tool_xmldb', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(615, 0, 'cachestore_file', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214496),
(616, 0, 'cachestore_file', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214496),
(617, 0, 'cachestore_file', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214496),
(618, 0, 'cachestore_memcache', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(619, 0, 'cachestore_memcache', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(620, 0, 'cachestore_memcache', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(621, 0, 'cachestore_memcached', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(622, 0, 'cachestore_memcached', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(623, 0, 'cachestore_memcached', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(624, 0, 'cachestore_mongodb', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(625, 0, 'cachestore_mongodb', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(626, 0, 'cachestore_mongodb', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(627, 0, 'cachestore_session', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(628, 0, 'cachestore_session', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(629, 0, 'cachestore_session', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(630, 0, 'cachestore_static', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(631, 0, 'cachestore_static', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(632, 0, 'cachestore_static', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(633, 0, 'theme_afterburner', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(634, 0, 'theme_afterburner', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(635, 0, 'theme_afterburner', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(636, 0, 'theme_anomaly', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(637, 0, 'theme_anomaly', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(638, 0, 'theme_anomaly', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(639, 0, 'theme_arialist', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(640, 0, 'theme_arialist', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(641, 0, 'theme_arialist', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(642, 0, 'theme_base', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(643, 0, 'theme_base', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(644, 0, 'theme_base', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(645, 0, 'theme_binarius', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(646, 0, 'theme_binarius', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(647, 0, 'theme_binarius', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(648, 0, 'theme_boxxie', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(649, 0, 'theme_boxxie', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(650, 0, 'theme_boxxie', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(651, 0, 'theme_brick', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(652, 0, 'theme_brick', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(653, 0, 'theme_brick', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(654, 0, 'theme_canvas', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(655, 0, 'theme_canvas', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(656, 0, 'theme_canvas', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(657, 0, 'theme_formal_white', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(658, 0, 'theme_formal_white', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(659, 0, 'theme_formal_white', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(660, 0, 'theme_formfactor', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(661, 0, 'theme_formfactor', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(662, 0, 'theme_formfactor', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(663, 0, 'theme_fusion', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(664, 0, 'theme_fusion', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(665, 0, 'theme_fusion', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(666, 0, 'theme_leatherbound', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(667, 0, 'theme_leatherbound', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(668, 0, 'theme_leatherbound', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(669, 0, 'theme_magazine', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(670, 0, 'theme_magazine', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(671, 0, 'theme_magazine', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(672, 0, 'theme_mymobile', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(673, 0, 'theme_mymobile', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(674, 0, 'theme_mymobile', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(675, 0, 'theme_nimble', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(676, 0, 'theme_nimble', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(677, 0, 'theme_nimble', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(678, 0, 'theme_nonzero', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(679, 0, 'theme_nonzero', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(680, 0, 'theme_nonzero', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(681, 0, 'theme_overlay', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(682, 0, 'theme_overlay', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(683, 0, 'theme_overlay', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(684, 0, 'theme_serenity', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(685, 0, 'theme_serenity', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(686, 0, 'theme_serenity', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(687, 0, 'theme_sky_high', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(688, 0, 'theme_sky_high', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(689, 0, 'theme_sky_high', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(690, 0, 'theme_splash', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(691, 0, 'theme_splash', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(692, 0, 'theme_splash', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(693, 0, 'theme_standard', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(694, 0, 'theme_standard', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(695, 0, 'theme_standard', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(696, 0, 'theme_standardold', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(697, 0, 'theme_standardold', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(698, 0, 'theme_standardold', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(699, 0, 'assignsubmission_comments', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(700, 0, 'assignsubmission_comments', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(701, 0, 'assignsubmission_comments', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(702, 0, 'assignsubmission_file', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(703, 0, 'assignsubmission_file', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(704, 0, 'assignsubmission_file', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(705, 0, 'assignsubmission_onlinetext', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(706, 0, 'assignsubmission_onlinetext', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(707, 0, 'assignsubmission_onlinetext', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(708, 0, 'assignfeedback_comments', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(709, 0, 'assignfeedback_comments', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(710, 0, 'assignfeedback_comments', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(711, 0, 'assignfeedback_file', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(712, 0, 'assignfeedback_file', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(713, 0, 'assignfeedback_file', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(714, 0, 'assignfeedback_offline', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(715, 0, 'assignfeedback_offline', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(716, 0, 'assignfeedback_offline', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(717, 0, 'assignment_offline', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(718, 0, 'assignment_offline', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(719, 0, 'assignment_offline', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(720, 0, 'assignment_online', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(721, 0, 'assignment_online', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(722, 0, 'assignment_online', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(723, 0, 'assignment_upload', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(724, 0, 'assignment_upload', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(725, 0, 'assignment_upload', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(726, 0, 'assignment_uploadsingle', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(727, 0, 'assignment_uploadsingle', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(728, 0, 'assignment_uploadsingle', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(729, 0, 'booktool_exportimscp', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(730, 0, 'booktool_exportimscp', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(731, 0, 'booktool_exportimscp', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(732, 0, 'booktool_importhtml', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(733, 0, 'booktool_importhtml', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(734, 0, 'booktool_importhtml', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(735, 0, 'booktool_print', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(736, 0, 'booktool_print', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(737, 0, 'booktool_print', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(738, 0, 'datafield_checkbox', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(739, 0, 'datafield_checkbox', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(740, 0, 'datafield_checkbox', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(741, 0, 'datafield_date', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214497),
(742, 0, 'datafield_date', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214497),
(743, 0, 'datafield_date', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214497),
(744, 0, 'datafield_file', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(745, 0, 'datafield_file', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(746, 0, 'datafield_file', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(747, 0, 'datafield_latlong', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(748, 0, 'datafield_latlong', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(749, 0, 'datafield_latlong', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(750, 0, 'datafield_menu', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(751, 0, 'datafield_menu', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(752, 0, 'datafield_menu', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(753, 0, 'datafield_multimenu', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(754, 0, 'datafield_multimenu', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(755, 0, 'datafield_multimenu', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(756, 0, 'datafield_number', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(757, 0, 'datafield_number', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(758, 0, 'datafield_number', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(759, 0, 'datafield_picture', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(760, 0, 'datafield_picture', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(761, 0, 'datafield_picture', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(762, 0, 'datafield_radiobutton', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(763, 0, 'datafield_radiobutton', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(764, 0, 'datafield_radiobutton', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(765, 0, 'datafield_text', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(766, 0, 'datafield_text', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(767, 0, 'datafield_text', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(768, 0, 'datafield_textarea', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(769, 0, 'datafield_textarea', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(770, 0, 'datafield_textarea', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(771, 0, 'datafield_url', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(772, 0, 'datafield_url', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(773, 0, 'datafield_url', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(774, 0, 'datapreset_imagegallery', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(775, 0, 'datapreset_imagegallery', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(776, 0, 'datapreset_imagegallery', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(777, 0, 'quiz_grading', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(778, 0, 'quiz_grading', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(779, 0, 'quiz_grading', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(780, 0, 'quiz_overview', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(781, 0, 'quiz_overview', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(782, 0, 'quiz_overview', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(783, 0, 'quiz_responses', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(784, 0, 'quiz_responses', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(785, 0, 'quiz_responses', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(786, 0, 'quiz_statistics', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(787, 0, 'quiz_statistics', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(788, 0, 'quiz_statistics', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(789, 0, 'quizaccess_delaybetweenattempts', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(790, 0, 'quizaccess_delaybetweenattempts', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(791, 0, 'quizaccess_delaybetweenattempts', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(792, 0, 'quizaccess_ipaddress', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(793, 0, 'quizaccess_ipaddress', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(794, 0, 'quizaccess_ipaddress', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(795, 0, 'quizaccess_numattempts', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(796, 0, 'quizaccess_numattempts', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(797, 0, 'quizaccess_numattempts', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(798, 0, 'quizaccess_openclosedate', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(799, 0, 'quizaccess_openclosedate', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(800, 0, 'quizaccess_openclosedate', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(801, 0, 'quizaccess_password', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(802, 0, 'quizaccess_password', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(803, 0, 'quizaccess_password', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(804, 0, 'quizaccess_safebrowser', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(805, 0, 'quizaccess_safebrowser', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(806, 0, 'quizaccess_safebrowser', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(807, 0, 'quizaccess_securewindow', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(808, 0, 'quizaccess_securewindow', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(809, 0, 'quizaccess_securewindow', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(810, 0, 'quizaccess_timelimit', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(811, 0, 'quizaccess_timelimit', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(812, 0, 'quizaccess_timelimit', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(813, 0, 'scormreport_basic', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(814, 0, 'scormreport_basic', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(815, 0, 'scormreport_basic', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(816, 0, 'scormreport_graphs', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(817, 0, 'scormreport_graphs', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(818, 0, 'scormreport_graphs', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(819, 0, 'scormreport_interactions', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(820, 0, 'scormreport_interactions', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(821, 0, 'scormreport_interactions', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(822, 0, 'workshopform_accumulative', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(823, 0, 'workshopform_accumulative', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(824, 0, 'workshopform_accumulative', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(825, 0, 'workshopform_comments', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(826, 0, 'workshopform_comments', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(827, 0, 'workshopform_comments', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(828, 0, 'workshopform_numerrors', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(829, 0, 'workshopform_numerrors', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(830, 0, 'workshopform_numerrors', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(831, 0, 'workshopform_rubric', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(832, 0, 'workshopform_rubric', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(833, 0, 'workshopform_rubric', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(834, 0, 'workshopallocation_manual', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(835, 0, 'workshopallocation_manual', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(836, 0, 'workshopallocation_manual', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(837, 0, 'workshopallocation_random', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(838, 0, 'workshopallocation_random', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(839, 0, 'workshopallocation_random', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(840, 0, 'workshopallocation_scheduled', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(841, 0, 'workshopallocation_scheduled', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(842, 0, 'workshopallocation_scheduled', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(843, 0, 'workshopeval_best', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(844, 0, 'workshopeval_best', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(845, 0, 'workshopeval_best', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(846, 0, 'tinymce_dragmath', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(847, 0, 'tinymce_dragmath', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(848, 0, 'tinymce_dragmath', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(849, 0, 'tinymce_moodleemoticon', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(850, 0, 'tinymce_moodleemoticon', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(851, 0, 'tinymce_moodleemoticon', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(852, 0, 'tinymce_moodleimage', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(853, 0, 'tinymce_moodleimage', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(854, 0, 'tinymce_moodleimage', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(855, 0, 'tinymce_moodlemedia', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(856, 0, 'tinymce_moodlemedia', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(857, 0, 'tinymce_moodlemedia', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(858, 0, 'tinymce_moodlenolink', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(859, 0, 'tinymce_moodlenolink', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(860, 0, 'tinymce_moodlenolink', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214498),
(861, 0, 'tinymce_spellchecker', NULL, '2012112900', 'Starting plugin installation', NULL, '', 0, 1359214498),
(862, 0, 'tinymce_spellchecker', '2012112900', '2012112900', 'Upgrade savepoint reached', NULL, '', 0, 1359214498),
(863, 0, 'tinymce_spellchecker', '2012112900', '2012112900', 'Plugin installed', NULL, '', 0, 1359214499);

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

--
-- Table structure for table `mdl_url`
--

CREATE TABLE `mdl_url` (
  `id` bigint(10) NOT NULL,
  `course` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `intro` longtext COLLATE utf8_unicode_ci,
  `introformat` smallint(4) NOT NULL DEFAULT '0',
  `externalurl` longtext COLLATE utf8_unicode_ci NOT NULL,
  `display` smallint(4) NOT NULL DEFAULT '0',
  `displayoptions` longtext COLLATE utf8_unicode_ci,
  `parameters` longtext COLLATE utf8_unicode_ci,
  `timemodified` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='each record is one url resource';

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

--
-- Table structure for table `mdl_user_enrolments`
--

CREATE TABLE `mdl_user_enrolments` (
  `id` bigint(10) NOT NULL,
  `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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Users participating in courses (aka enrolled users) - everyb';

--
-- Dumping data for table `mdl_user_enrolments`
--

INSERT INTO `mdl_user_enrolments` (`id`, `status`, `enrolid`, `userid`, `timestart`, `timeend`, `modifierid`, `timecreated`, `timemodified`) VALUES
(1, 0, 1, 2, 1359169200, 0, 2, 1359215568, 1359215568),
(2, 0, 1, 3, 1359154800, 0, 2, 1359217406, 1359217406),
(3, 0, 1, 59, 1359428400, 0, 2, 1359471705, 1359471705),
(4, 0, 1, 9, 1359428400, 0, 2, 1359485349, 1359485349),
(5, 0, 1, 5, 1359428400, 0, 2, 1359485371, 1359485371),
(6, 0, 118, 60, 1359414000, 0, 5, 1359489566, 1359489566);

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

--
-- Table structure for table `mdl_user_info_category`
--

CREATE TABLE `mdl_user_info_category` (
  `id` bigint(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sortorder` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Customisable fields categories';

--
-- Dumping data for table `mdl_user_info_category`
--

INSERT INTO `mdl_user_info_category` (`id`, `name`, `sortorder`) VALUES
(1, 'Otros campos', 1);

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

--
-- Table structure for table `mdl_user_info_data`
--

CREATE TABLE `mdl_user_info_data` (
  `id` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `fieldid` bigint(10) NOT NULL DEFAULT '0',
  `data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `dataformat` tinyint(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Data for the customisable user fields';

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

--
-- Table structure for table `mdl_user_info_field`
--

CREATE TABLE `mdl_user_info_field` (
  `id` bigint(10) NOT NULL,
  `shortname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'shortname',
  `name` longtext COLLATE utf8_unicode_ci NOT NULL,
  `datatype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8_unicode_ci,
  `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 COLLATE utf8_unicode_ci,
  `defaultdataformat` tinyint(2) NOT NULL DEFAULT '0',
  `param1` longtext COLLATE utf8_unicode_ci,
  `param2` longtext COLLATE utf8_unicode_ci,
  `param3` longtext COLLATE utf8_unicode_ci,
  `param4` longtext COLLATE utf8_unicode_ci,
  `param5` longtext COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Customisable user profile fields';

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

--
-- Table structure for table `mdl_user_lastaccess`
--

CREATE TABLE `mdl_user_lastaccess` (
  `id` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `courseid` bigint(10) NOT NULL DEFAULT '0',
  `timeaccess` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='To keep track of course page access times, used in online pa';

--
-- Dumping data for table `mdl_user_lastaccess`
--

INSERT INTO `mdl_user_lastaccess` (`id`, `userid`, `courseid`, `timeaccess`) VALUES
(1, 2, 2, 1359559240),
(2, 3, 2, 1359217448),
(3, 2, 3, 1359227152),
(4, 2, 4, 1359227281),
(5, 2, 5, 1359227758),
(6, 2, 6, 1359227937),
(7, 2, 7, 1359228797),
(8, 2, 8, 1359228861),
(9, 2, 9, 1359228909),
(10, 2, 10, 1359228950),
(11, 2, 11, 1359229010),
(12, 2, 12, 1359229052),
(13, 2, 13, 1359229107),
(14, 2, 14, 1359229128),
(15, 2, 15, 1359229185),
(16, 2, 16, 1359229308),
(17, 2, 17, 1359229373),
(18, 2, 18, 1359229404),
(19, 2, 19, 1359229482),
(20, 2, 20, 1359229626),
(21, 2, 21, 1359229696),
(22, 2, 22, 1359229773),
(23, 2, 23, 1359229794),
(24, 2, 24, 1359229899),
(25, 2, 25, 1359229912),
(26, 2, 26, 1359230069),
(27, 2, 27, 1359230131),
(28, 2, 28, 1359230161),
(29, 2, 29, 1359230244),
(30, 2, 30, 1359230269),
(31, 2, 31, 1359230350),
(32, 2, 32, 1359230383),
(33, 2, 33, 1359230583),
(34, 2, 34, 1359230630),
(35, 2, 35, 1359230672),
(36, 2, 36, 1359230701),
(37, 2, 37, 1359230725),
(38, 2, 38, 1359230750),
(39, 2, 39, 1359230769),
(40, 2, 40, 1359230792),
(41, 5, 2, 1359488710),
(42, 5, 41, 1359489523),
(43, 2, 41, 1359489248);

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

--
-- Table structure for table `mdl_user_preferences`
--

CREATE TABLE `mdl_user_preferences` (
  `id` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` varchar(1333) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Allows modules to store arbitrary user preferences';

--
-- Dumping data for table `mdl_user_preferences`
--

INSERT INTO `mdl_user_preferences` (`id`, `userid`, `name`, `value`) VALUES
(1, 2, 'email_bounce_count', '1'),
(2, 2, 'email_send_count', '1'),
(3, 2, 'userselector_preserveselected', '0'),
(4, 2, 'userselector_autoselectunique', '0'),
(5, 2, 'userselector_searchanywhere', '0'),
(6, 3, 'auth_forcepasswordchange', '0'),
(7, 3, 'email_bounce_count', '1'),
(8, 3, 'email_send_count', '1'),
(9, 2, 'filepicker_recentrepository', '3'),
(10, 2, 'filepicker_recentlicense', 'allrightsreserved'),
(79, 6, 'auth_forcepasswordchange', '1'),
(81, 8, 'auth_forcepasswordchange', '1'),
(82, 9, 'auth_forcepasswordchange', '1'),
(83, 10, 'auth_forcepasswordchange', '1'),
(85, 12, 'auth_forcepasswordchange', '1'),
(86, 13, 'auth_forcepasswordchange', '1'),
(90, 17, 'auth_forcepasswordchange', '1'),
(91, 18, 'auth_forcepasswordchange', '1'),
(93, 20, 'auth_forcepasswordchange', '1'),
(95, 22, 'auth_forcepasswordchange', '1'),
(96, 23, 'auth_forcepasswordchange', '1'),
(99, 26, 'auth_forcepasswordchange', '1'),
(101, 28, 'auth_forcepasswordchange', '1'),
(102, 29, 'auth_forcepasswordchange', '1'),
(103, 30, 'auth_forcepasswordchange', '1'),
(104, 31, 'auth_forcepasswordchange', '1'),
(105, 32, 'auth_forcepasswordchange', '1'),
(106, 33, 'auth_forcepasswordchange', '1'),
(108, 35, 'auth_forcepasswordchange', '1'),
(111, 38, 'auth_forcepasswordchange', '1'),
(112, 39, 'auth_forcepasswordchange', '1'),
(113, 40, 'auth_forcepasswordchange', '1'),
(114, 41, 'auth_forcepasswordchange', '1'),
(115, 42, 'auth_forcepasswordchange', '1'),
(116, 43, 'auth_forcepasswordchange', '1'),
(117, 44, 'auth_forcepasswordchange', '1'),
(118, 45, 'auth_forcepasswordchange', '1'),
(120, 47, 'auth_forcepasswordchange', '1'),
(121, 48, 'auth_forcepasswordchange', '1'),
(122, 49, 'auth_forcepasswordchange', '1'),
(123, 50, 'auth_forcepasswordchange', '1'),
(124, 51, 'auth_forcepasswordchange', '1'),
(125, 52, 'auth_forcepasswordchange', '1'),
(127, 54, 'auth_forcepasswordchange', '1'),
(129, 56, 'auth_forcepasswordchange', '1'),
(130, 57, 'auth_forcepasswordchange', '1'),
(131, 58, 'auth_forcepasswordchange', '1'),
(132, 59, 'auth_forcepasswordchange', '1'),
(134, 61, 'auth_forcepasswordchange', '1'),
(135, 62, 'auth_forcepasswordchange', '1'),
(136, 63, 'auth_forcepasswordchange', '1'),
(137, 64, 'auth_forcepasswordchange', '1'),
(138, 65, 'auth_forcepasswordchange', '1'),
(139, 66, 'auth_forcepasswordchange', '1'),
(140, 67, 'auth_forcepasswordchange', '1'),
(142, 69, 'auth_forcepasswordchange', '1'),
(143, 53, 'filepicker_recentrepository', '3'),
(144, 16, 'docked_block_instance_5', '1'),
(145, 2, 'user_add_filter_form_showadvanced', '1'),
(146, 5, 'userselector_searchanywhere', '0'),
(147, 5, 'userselector_preserveselected', '0'),
(148, 5, 'userselector_autoselectunique', '0'),
(149, 7, 'filepicker_recentrepository', '3'),
(150, 7, 'filepicker_recentlicense', 'allrightsreserved');

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

--
-- Table structure for table `mdl_user_private_key`
--

CREATE TABLE `mdl_user_private_key` (
  `id` bigint(10) NOT NULL,
  `script` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `userid` bigint(10) NOT NULL,
  `instance` bigint(10) DEFAULT NULL,
  `iprestriction` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `validuntil` bigint(10) DEFAULT NULL,
  `timecreated` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='access keys used in cookieless scripts - rss, etc.';

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

--
-- Table structure for table `mdl_webdav_locks`
--

CREATE TABLE `mdl_webdav_locks` (
  `id` bigint(10) NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `expiry` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `recursive` tinyint(1) NOT NULL DEFAULT '0',
  `exclusivelock` tinyint(1) NOT NULL DEFAULT '0',
  `created` bigint(10) NOT NULL DEFAULT '0',
  `modified` bigint(10) NOT NULL DEFAULT '0',
  `owner` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Resource locks for WebDAV users';

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

--
-- Table structure for table `mdl_wiki`
--

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

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

--
-- Table structure for table `mdl_wiki_links`
--

CREATE TABLE `mdl_wiki_links` (
  `id` bigint(10) NOT NULL,
  `subwikiid` bigint(10) NOT NULL DEFAULT '0',
  `frompageid` bigint(10) NOT NULL DEFAULT '0',
  `topageid` bigint(10) NOT NULL DEFAULT '0',
  `tomissingpage` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Page wiki links';

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

--
-- Table structure for table `mdl_wiki_locks`
--

CREATE TABLE `mdl_wiki_locks` (
  `id` bigint(10) NOT NULL,
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `sectionname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `lockedat` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Manages page locks';

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

--
-- Table structure for table `mdl_wiki_pages`
--

CREATE TABLE `mdl_wiki_pages` (
  `id` bigint(10) NOT NULL,
  `subwikiid` bigint(10) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'title',
  `cachedcontent` longtext COLLATE utf8_unicode_ci 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores wiki pages';

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

--
-- Table structure for table `mdl_wiki_subwikis`
--

CREATE TABLE `mdl_wiki_subwikis` (
  `id` bigint(10) NOT NULL,
  `wikiid` bigint(10) NOT NULL DEFAULT '0',
  `groupid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores subwiki instances';

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

--
-- Table structure for table `mdl_wiki_synonyms`
--

CREATE TABLE `mdl_wiki_synonyms` (
  `id` bigint(10) NOT NULL,
  `subwikiid` bigint(10) NOT NULL DEFAULT '0',
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `pagesynonym` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Pagesynonym'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores wiki pages synonyms';

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

--
-- Table structure for table `mdl_wiki_versions`
--

CREATE TABLE `mdl_wiki_versions` (
  `id` bigint(10) NOT NULL,
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `content` longtext COLLATE utf8_unicode_ci NOT NULL,
  `contentformat` varchar(20) COLLATE utf8_unicode_ci 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores wiki page history';

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

--
-- Table structure for table `mdl_workshop`
--

CREATE TABLE `mdl_workshop` (
  `id` bigint(10) NOT NULL,
  `course` bigint(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `intro` longtext COLLATE utf8_unicode_ci,
  `introformat` smallint(3) NOT NULL DEFAULT '0',
  `instructauthors` longtext COLLATE utf8_unicode_ci,
  `instructauthorsformat` smallint(3) NOT NULL DEFAULT '0',
  `instructreviewers` longtext COLLATE utf8_unicode_ci,
  `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `evaluation` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `gradedecimals` smallint(3) DEFAULT '0',
  `nattachments` smallint(3) DEFAULT '0',
  `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 COLLATE utf8_unicode_ci,
  `conclusionformat` smallint(3) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='This table keeps information about the module instances and ';

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

--
-- Table structure for table `mdl_workshopallocation_scheduled`
--

CREATE TABLE `mdl_workshopallocation_scheduled` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `enabled` tinyint(2) NOT NULL DEFAULT '0',
  `submissionend` bigint(10) NOT NULL,
  `timeallocated` bigint(10) DEFAULT NULL,
  `settings` longtext COLLATE utf8_unicode_ci,
  `resultstatus` bigint(10) DEFAULT NULL,
  `resultmessage` varchar(1333) COLLATE utf8_unicode_ci DEFAULT NULL,
  `resultlog` longtext COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores the allocation settings for the scheduled allocator';

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

--
-- Table structure for table `mdl_workshopeval_best_settings`
--

CREATE TABLE `mdl_workshopeval_best_settings` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `comparison` smallint(3) DEFAULT '5'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Settings for the grading evaluation subplugin Comparison wit';

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

--
-- Table structure for table `mdl_workshopform_accumulative`
--

CREATE TABLE `mdl_workshopform_accumulative` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci,
  `descriptionformat` smallint(3) DEFAULT '0',
  `grade` bigint(10) NOT NULL,
  `weight` mediumint(5) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The assessment dimensions definitions of Accumulative gradin';

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

--
-- Table structure for table `mdl_workshopform_comments`
--

CREATE TABLE `mdl_workshopform_comments` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci,
  `descriptionformat` smallint(3) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The assessment dimensions definitions of Comments strategy f';

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

--
-- Table structure for table `mdl_workshopform_numerrors`
--

CREATE TABLE `mdl_workshopform_numerrors` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci,
  `descriptionformat` smallint(3) DEFAULT '0',
  `descriptiontrust` bigint(10) DEFAULT NULL,
  `grade0` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `grade1` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `weight` mediumint(5) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The assessment dimensions definitions of Number of errors gr';

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

--
-- Table structure for table `mdl_workshopform_numerrors_map`
--

CREATE TABLE `mdl_workshopform_numerrors_map` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `nonegative` bigint(10) NOT NULL,
  `grade` decimal(10,5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='This maps the number of errors to a percentual grade for sub';

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

--
-- Table structure for table `mdl_workshopform_rubric`
--

CREATE TABLE `mdl_workshopform_rubric` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `sort` bigint(10) DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci,
  `descriptionformat` smallint(3) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The assessment dimensions definitions of Rubric grading stra';

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

--
-- Table structure for table `mdl_workshopform_rubric_config`
--

CREATE TABLE `mdl_workshopform_rubric_config` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `layout` varchar(30) COLLATE utf8_unicode_ci DEFAULT 'list'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Configuration table for the Rubric grading strategy';

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

--
-- Table structure for table `mdl_workshopform_rubric_levels`
--

CREATE TABLE `mdl_workshopform_rubric_levels` (
  `id` bigint(10) NOT NULL,
  `dimensionid` bigint(10) NOT NULL,
  `grade` decimal(10,5) NOT NULL,
  `definition` longtext COLLATE utf8_unicode_ci,
  `definitionformat` smallint(3) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The definition of rubric rating scales';

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

--
-- Table structure for table `mdl_workshop_aggregations`
--

CREATE TABLE `mdl_workshop_aggregations` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `gradinggrade` decimal(10,5) DEFAULT NULL,
  `timegraded` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Aggregated grades for assessment are stored here. The aggreg';

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

--
-- Table structure for table `mdl_workshop_assessments`
--

CREATE TABLE `mdl_workshop_assessments` (
  `id` bigint(10) NOT NULL,
  `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 COLLATE utf8_unicode_ci,
  `feedbackauthorformat` smallint(3) DEFAULT '0',
  `feedbackreviewer` longtext COLLATE utf8_unicode_ci,
  `feedbackreviewerformat` smallint(3) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Info about the made assessment and automatically calculated ';

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

--
-- Table structure for table `mdl_workshop_assessments_old`
--

CREATE TABLE `mdl_workshop_assessments_old` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL DEFAULT '0',
  `submissionid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timegraded` bigint(10) NOT NULL DEFAULT '0',
  `timeagreed` bigint(10) NOT NULL DEFAULT '0',
  `grade` double NOT NULL DEFAULT '0',
  `gradinggrade` smallint(3) NOT NULL DEFAULT '0',
  `teachergraded` smallint(3) NOT NULL DEFAULT '0',
  `mailed` smallint(3) NOT NULL DEFAULT '0',
  `resubmission` smallint(3) NOT NULL DEFAULT '0',
  `donotuse` smallint(3) NOT NULL DEFAULT '0',
  `generalcomment` longtext COLLATE utf8_unicode_ci,
  `teachercomment` longtext COLLATE utf8_unicode_ci,
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop_assessments table to be dropped later in Moo';

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

--
-- Table structure for table `mdl_workshop_comments_old`
--

CREATE TABLE `mdl_workshop_comments_old` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL DEFAULT '0',
  `assessmentid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `mailed` tinyint(2) NOT NULL DEFAULT '0',
  `comments` longtext COLLATE utf8_unicode_ci NOT NULL,
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop_comments table to be dropped later in Moodle';

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

--
-- Table structure for table `mdl_workshop_elements_old`
--

CREATE TABLE `mdl_workshop_elements_old` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL DEFAULT '0',
  `elementno` smallint(3) NOT NULL DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `scale` smallint(3) NOT NULL DEFAULT '0',
  `maxscore` smallint(3) NOT NULL DEFAULT '1',
  `weight` smallint(3) NOT NULL DEFAULT '11',
  `stddev` double NOT NULL DEFAULT '0',
  `totalassessments` bigint(10) NOT NULL DEFAULT '0',
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop_elements table to be dropped later in Moodle';

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

--
-- Table structure for table `mdl_workshop_grades`
--

CREATE TABLE `mdl_workshop_grades` (
  `id` bigint(10) NOT NULL,
  `assessmentid` bigint(10) NOT NULL,
  `strategy` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `dimensionid` bigint(10) NOT NULL,
  `grade` decimal(10,5) NOT NULL,
  `peercomment` longtext COLLATE utf8_unicode_ci,
  `peercommentformat` smallint(3) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='How the reviewers filled-up the grading forms, given grades ';

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

--
-- Table structure for table `mdl_workshop_grades_old`
--

CREATE TABLE `mdl_workshop_grades_old` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL DEFAULT '0',
  `assessmentid` bigint(10) NOT NULL DEFAULT '0',
  `elementno` bigint(10) NOT NULL DEFAULT '0',
  `feedback` longtext COLLATE utf8_unicode_ci NOT NULL,
  `grade` smallint(3) NOT NULL DEFAULT '0',
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop_grades table to be dropped later in Moodle 2';

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

--
-- Table structure for table `mdl_workshop_old`
--

CREATE TABLE `mdl_workshop_old` (
  `id` bigint(10) NOT NULL,
  `course` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `wtype` smallint(3) NOT NULL DEFAULT '0',
  `nelements` smallint(3) NOT NULL DEFAULT '1',
  `nattachments` smallint(3) NOT NULL DEFAULT '0',
  `phase` tinyint(2) NOT NULL DEFAULT '0',
  `format` tinyint(2) NOT NULL DEFAULT '0',
  `gradingstrategy` tinyint(2) NOT NULL DEFAULT '1',
  `resubmit` tinyint(2) NOT NULL DEFAULT '0',
  `agreeassessments` tinyint(2) NOT NULL DEFAULT '0',
  `hidegrades` tinyint(2) NOT NULL DEFAULT '0',
  `anonymous` tinyint(2) NOT NULL DEFAULT '0',
  `includeself` tinyint(2) NOT NULL DEFAULT '0',
  `maxbytes` bigint(10) NOT NULL DEFAULT '100000',
  `submissionstart` bigint(10) NOT NULL DEFAULT '0',
  `assessmentstart` bigint(10) NOT NULL DEFAULT '0',
  `submissionend` bigint(10) NOT NULL DEFAULT '0',
  `assessmentend` bigint(10) NOT NULL DEFAULT '0',
  `releasegrades` bigint(10) NOT NULL DEFAULT '0',
  `grade` smallint(3) NOT NULL DEFAULT '0',
  `gradinggrade` smallint(3) NOT NULL DEFAULT '0',
  `ntassessments` smallint(3) NOT NULL DEFAULT '0',
  `assessmentcomps` smallint(3) NOT NULL DEFAULT '2',
  `nsassessments` smallint(3) NOT NULL DEFAULT '0',
  `overallocation` smallint(3) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `teacherweight` smallint(3) NOT NULL DEFAULT '1',
  `showleaguetable` smallint(3) NOT NULL DEFAULT '0',
  `usepassword` smallint(3) NOT NULL DEFAULT '0',
  `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop table to be dropped later in Moodle 2.x';

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

--
-- Table structure for table `mdl_workshop_rubrics_old`
--

CREATE TABLE `mdl_workshop_rubrics_old` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL DEFAULT '0',
  `elementno` bigint(10) NOT NULL DEFAULT '0',
  `rubricno` smallint(3) NOT NULL DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop_rubrics table to be dropped later in Moodle ';

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

--
-- Table structure for table `mdl_workshop_stockcomments_old`
--

CREATE TABLE `mdl_workshop_stockcomments_old` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL DEFAULT '0',
  `elementno` bigint(10) NOT NULL DEFAULT '0',
  `comments` longtext COLLATE utf8_unicode_ci NOT NULL,
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop_stockcomments table to be dropped later in M';

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

--
-- Table structure for table `mdl_workshop_submissions`
--

CREATE TABLE `mdl_workshop_submissions` (
  `id` bigint(10) NOT NULL,
  `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content` longtext COLLATE utf8_unicode_ci,
  `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 COLLATE utf8_unicode_ci,
  `feedbackauthorformat` smallint(3) DEFAULT '0',
  `timegraded` bigint(10) DEFAULT NULL,
  `published` tinyint(2) DEFAULT '0',
  `late` tinyint(2) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Info about the submission and the aggregation of the grade f';

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

--
-- Table structure for table `mdl_workshop_submissions_old`
--

CREATE TABLE `mdl_workshop_submissions_old` (
  `id` bigint(10) NOT NULL,
  `workshopid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `mailed` tinyint(2) NOT NULL DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `gradinggrade` smallint(3) NOT NULL DEFAULT '0',
  `finalgrade` smallint(3) NOT NULL DEFAULT '0',
  `late` smallint(3) NOT NULL DEFAULT '0',
  `nassessments` bigint(10) NOT NULL DEFAULT '0',
  `newplugin` varchar(28) COLLATE utf8_unicode_ci DEFAULT NULL,
  `newid` bigint(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Legacy workshop_submissions table to be dropped later in Moo';

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mdl_assign`
--
ALTER TABLE `mdl_assign`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assi_cou_ix` (`course`),
  ADD KEY `mdl_assi_tea_ix` (`teamsubmissiongroupingid`);

--
-- Indexes for table `mdl_assignfeedback_comments`
--
ALTER TABLE `mdl_assignfeedback_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assicomm_ass_ix` (`assignment`),
  ADD KEY `mdl_assicomm_gra_ix` (`grade`);

--
-- Indexes for table `mdl_assignfeedback_file`
--
ALTER TABLE `mdl_assignfeedback_file`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assifile_ass2_ix` (`assignment`),
  ADD KEY `mdl_assifile_gra_ix` (`grade`);

--
-- Indexes for table `mdl_assignment`
--
ALTER TABLE `mdl_assignment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assi_cou2_ix` (`course`);

--
-- Indexes for table `mdl_assignment_submissions`
--
ALTER TABLE `mdl_assignment_submissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assisubm_use2_ix` (`userid`),
  ADD KEY `mdl_assisubm_mai_ix` (`mailed`),
  ADD KEY `mdl_assisubm_tim_ix` (`timemarked`),
  ADD KEY `mdl_assisubm_ass2_ix` (`assignment`);

--
-- Indexes for table `mdl_assignsubmission_file`
--
ALTER TABLE `mdl_assignsubmission_file`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assifile_ass_ix` (`assignment`),
  ADD KEY `mdl_assifile_sub_ix` (`submission`);

--
-- Indexes for table `mdl_assignsubmission_onlinetext`
--
ALTER TABLE `mdl_assignsubmission_onlinetext`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assionli_ass_ix` (`assignment`),
  ADD KEY `mdl_assionli_sub_ix` (`submission`);

--
-- Indexes for table `mdl_assign_grades`
--
ALTER TABLE `mdl_assign_grades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assigrad_use_ix` (`userid`),
  ADD KEY `mdl_assigrad_mai_ix` (`mailed`),
  ADD KEY `mdl_assigrad_ass_ix` (`assignment`);

--
-- Indexes for table `mdl_assign_plugin_config`
--
ALTER TABLE `mdl_assign_plugin_config`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assiplugconf_plu_ix` (`plugin`),
  ADD KEY `mdl_assiplugconf_sub_ix` (`subtype`),
  ADD KEY `mdl_assiplugconf_nam_ix` (`name`),
  ADD KEY `mdl_assiplugconf_ass_ix` (`assignment`);

--
-- Indexes for table `mdl_assign_submission`
--
ALTER TABLE `mdl_assign_submission`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assisubm_use_ix` (`userid`),
  ADD KEY `mdl_assisubm_ass_ix` (`assignment`);

--
-- Indexes for table `mdl_assign_user_mapping`
--
ALTER TABLE `mdl_assign_user_mapping`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_assiusermapp_ass_ix` (`assignment`),
  ADD KEY `mdl_assiusermapp_use_ix` (`userid`);

--
-- Indexes for table `mdl_backup_controllers`
--
ALTER TABLE `mdl_backup_controllers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_backcont_bac_uix` (`backupid`),
  ADD KEY `mdl_backcont_typite_ix` (`type`,`itemid`),
  ADD KEY `mdl_backcont_use_ix` (`userid`);

--
-- Indexes for table `mdl_backup_courses`
--
ALTER TABLE `mdl_backup_courses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_backcour_cou_uix` (`courseid`);

--
-- Indexes for table `mdl_backup_files_template`
--
ALTER TABLE `mdl_backup_files_template`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_backfiletemp_bacconcomf_ix` (`backupid`,`contextid`,`component`,`filearea`,`itemid`);

--
-- Indexes for table `mdl_backup_ids_template`
--
ALTER TABLE `mdl_backup_ids_template`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_backidstemp_baciteite_uix` (`backupid`,`itemname`,`itemid`),
  ADD KEY `mdl_backidstemp_bacitepar_ix` (`backupid`,`itemname`,`parentitemid`),
  ADD KEY `mdl_backidstemp_bacitenew_ix` (`backupid`,`itemname`,`newitemid`);

--
-- Indexes for table `mdl_backup_logs`
--
ALTER TABLE `mdl_backup_logs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_backlogs_bacid_uix` (`backupid`,`id`),
  ADD KEY `mdl_backlogs_bac_ix` (`backupid`);

--
-- Indexes for table `mdl_block`
--
ALTER TABLE `mdl_block`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_bloc_nam_uix` (`name`);

--
-- Indexes for table `mdl_block_community`
--
ALTER TABLE `mdl_block_community`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_block_instances`
--
ALTER TABLE `mdl_block_instances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_blocinst_parshopagsub_ix` (`parentcontextid`,`showinsubcontexts`,`pagetypepattern`,`subpagepattern`),
  ADD KEY `mdl_blocinst_par_ix` (`parentcontextid`);

--
-- Indexes for table `mdl_block_positions`
--
ALTER TABLE `mdl_block_positions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_blocposi_bloconpagsub_uix` (`blockinstanceid`,`contextid`,`pagetype`,`subpage`),
  ADD KEY `mdl_blocposi_blo_ix` (`blockinstanceid`),
  ADD KEY `mdl_blocposi_con_ix` (`contextid`);

--
-- Indexes for table `mdl_block_rss_client`
--
ALTER TABLE `mdl_block_rss_client`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_blog_association`
--
ALTER TABLE `mdl_blog_association`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_blogasso_con_ix` (`contextid`),
  ADD KEY `mdl_blogasso_blo_ix` (`blogid`);

--
-- Indexes for table `mdl_blog_external`
--
ALTER TABLE `mdl_blog_external`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_blogexte_use_ix` (`userid`);

--
-- Indexes for table `mdl_book`
--
ALTER TABLE `mdl_book`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_book_chapters`
--
ALTER TABLE `mdl_book_chapters`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_cache_filters`
--
ALTER TABLE `mdl_cache_filters`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_cachfilt_filmd5_ix` (`filter`,`md5key`);

--
-- Indexes for table `mdl_cache_flags`
--
ALTER TABLE `mdl_cache_flags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_cachflag_fla_ix` (`flagtype`),
  ADD KEY `mdl_cachflag_nam_ix` (`name`);

--
-- Indexes for table `mdl_cache_text`
--
ALTER TABLE `mdl_cache_text`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_cachtext_md5_ix` (`md5key`),
  ADD KEY `mdl_cachtext_tim_ix` (`timemodified`);

--
-- Indexes for table `mdl_capabilities`
--
ALTER TABLE `mdl_capabilities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_capa_nam_uix` (`name`);

--
-- Indexes for table `mdl_chat`
--
ALTER TABLE `mdl_chat`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_chat_cou_ix` (`course`);

--
-- Indexes for table `mdl_chat_messages`
--
ALTER TABLE `mdl_chat_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_chatmess_use_ix` (`userid`),
  ADD KEY `mdl_chatmess_gro_ix` (`groupid`),
  ADD KEY `mdl_chatmess_timcha_ix` (`timestamp`,`chatid`),
  ADD KEY `mdl_chatmess_cha_ix` (`chatid`);

--
-- Indexes for table `mdl_chat_messages_current`
--
ALTER TABLE `mdl_chat_messages_current`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_chatmesscurr_use_ix` (`userid`),
  ADD KEY `mdl_chatmesscurr_gro_ix` (`groupid`),
  ADD KEY `mdl_chatmesscurr_timcha_ix` (`timestamp`,`chatid`),
  ADD KEY `mdl_chatmesscurr_cha_ix` (`chatid`);

--
-- Indexes for table `mdl_chat_users`
--
ALTER TABLE `mdl_chat_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_chatuser_use_ix` (`userid`),
  ADD KEY `mdl_chatuser_las_ix` (`lastping`),
  ADD KEY `mdl_chatuser_gro_ix` (`groupid`),
  ADD KEY `mdl_chatuser_cha_ix` (`chatid`);

--
-- Indexes for table `mdl_choice`
--
ALTER TABLE `mdl_choice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_choi_cou_ix` (`course`);

--
-- Indexes for table `mdl_choice_answers`
--
ALTER TABLE `mdl_choice_answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_choiansw_use_ix` (`userid`),
  ADD KEY `mdl_choiansw_cho_ix` (`choiceid`),
  ADD KEY `mdl_choiansw_opt_ix` (`optionid`);

--
-- Indexes for table `mdl_choice_options`
--
ALTER TABLE `mdl_choice_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_choiopti_cho_ix` (`choiceid`);

--
-- Indexes for table `mdl_cohort`
--
ALTER TABLE `mdl_cohort`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_coho_con_ix` (`contextid`);

--
-- Indexes for table `mdl_cohort_members`
--
ALTER TABLE `mdl_cohort_members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_cohomemb_cohuse_uix` (`cohortid`,`userid`),
  ADD KEY `mdl_cohomemb_coh_ix` (`cohortid`),
  ADD KEY `mdl_cohomemb_use_ix` (`userid`);

--
-- Indexes for table `mdl_comments`
--
ALTER TABLE `mdl_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_config`
--
ALTER TABLE `mdl_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_conf_nam_uix` (`name`);

--
-- Indexes for table `mdl_config_log`
--
ALTER TABLE `mdl_config_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_conflog_tim_ix` (`timemodified`),
  ADD KEY `mdl_conflog_use_ix` (`userid`);

--
-- Indexes for table `mdl_config_plugins`
--
ALTER TABLE `mdl_config_plugins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_confplug_plunam_uix` (`plugin`,`name`);

--
-- Indexes for table `mdl_context`
--
ALTER TABLE `mdl_context`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_cont_conins_uix` (`contextlevel`,`instanceid`),
  ADD KEY `mdl_cont_ins_ix` (`instanceid`),
  ADD KEY `mdl_cont_pat_ix` (`path`);

--
-- Indexes for table `mdl_context_temp`
--
ALTER TABLE `mdl_context_temp`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_course`
--
ALTER TABLE `mdl_course`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_cour_cat_ix` (`category`),
  ADD KEY `mdl_cour_idn_ix` (`idnumber`),
  ADD KEY `mdl_cour_sho_ix` (`shortname`),
  ADD KEY `mdl_cour_sor_ix` (`sortorder`);

--
-- Indexes for table `mdl_course_categories`
--
ALTER TABLE `mdl_course_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_courcate_par_ix` (`parent`);

--
-- Indexes for table `mdl_course_completions`
--
ALTER TABLE `mdl_course_completions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_courcomp_usecou_uix` (`userid`,`course`),
  ADD KEY `mdl_courcomp_use_ix` (`userid`),
  ADD KEY `mdl_courcomp_cou_ix` (`course`),
  ADD KEY `mdl_courcomp_tim_ix` (`timecompleted`);

--
-- Indexes for table `mdl_course_completion_aggr_methd`
--
ALTER TABLE `mdl_course_completion_aggr_methd`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_courcompaggrmeth_coucr_uix` (`course`,`criteriatype`),
  ADD KEY `mdl_courcompaggrmeth_cou_ix` (`course`),
  ADD KEY `mdl_courcompaggrmeth_cri_ix` (`criteriatype`);

--
-- Indexes for table `mdl_course_completion_criteria`
--
ALTER TABLE `mdl_course_completion_criteria`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_courcompcrit_cou_ix` (`course`);

--
-- Indexes for table `mdl_course_completion_crit_compl`
--
ALTER TABLE `mdl_course_completion_crit_compl`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_courcompcritcomp_useco_uix` (`userid`,`course`,`criteriaid`),
  ADD KEY `mdl_courcompcritcomp_use_ix` (`userid`),
  ADD KEY `mdl_courcompcritcomp_cou_ix` (`course`),
  ADD KEY `mdl_courcompcritcomp_cri_ix` (`criteriaid`),
  ADD KEY `mdl_courcompcritcomp_tim_ix` (`timecompleted`);

--
-- Indexes for table `mdl_course_format_options`
--
ALTER TABLE `mdl_course_format_options`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_courformopti_couforsec_uix` (`courseid`,`format`,`sectionid`,`name`),
  ADD KEY `mdl_courformopti_cou_ix` (`courseid`);

--
-- Indexes for table `mdl_course_modules`
--
ALTER TABLE `mdl_course_modules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_courmodu_vis_ix` (`visible`),
  ADD KEY `mdl_courmodu_cou_ix` (`course`),
  ADD KEY `mdl_courmodu_mod_ix` (`module`),
  ADD KEY `mdl_courmodu_ins_ix` (`instance`),
  ADD KEY `mdl_courmodu_idncou_ix` (`idnumber`,`course`),
  ADD KEY `mdl_courmodu_gro_ix` (`groupingid`);

--
-- Indexes for table `mdl_course_modules_availability`
--
ALTER TABLE `mdl_course_modules_availability`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_courmoduavai_cou_ix` (`coursemoduleid`),
  ADD KEY `mdl_courmoduavai_sou_ix` (`sourcecmid`),
  ADD KEY `mdl_courmoduavai_gra_ix` (`gradeitemid`);

--
-- Indexes for table `mdl_course_modules_avail_fields`
--
ALTER TABLE `mdl_course_modules_avail_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_courmoduavaifiel_cou_ix` (`coursemoduleid`);

--
-- Indexes for table `mdl_course_modules_completion`
--
ALTER TABLE `mdl_course_modules_completion`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_courmoducomp_usecou_uix` (`userid`,`coursemoduleid`),
  ADD KEY `mdl_courmoducomp_cou_ix` (`coursemoduleid`);

--
-- Indexes for table `mdl_course_published`
--
ALTER TABLE `mdl_course_published`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_course_request`
--
ALTER TABLE `mdl_course_request`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_courrequ_sho_ix` (`shortname`);

--
-- Indexes for table `mdl_course_sections`
--
ALTER TABLE `mdl_course_sections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_coursect_cousec_uix` (`course`,`section`);

--
-- Indexes for table `mdl_course_sections_availability`
--
ALTER TABLE `mdl_course_sections_availability`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_coursectavai_cou_ix` (`coursesectionid`),
  ADD KEY `mdl_coursectavai_sou_ix` (`sourcecmid`),
  ADD KEY `mdl_coursectavai_gra_ix` (`gradeitemid`);

--
-- Indexes for table `mdl_course_sections_avail_fields`
--
ALTER TABLE `mdl_course_sections_avail_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_coursectavaifiel_cou_ix` (`coursesectionid`);

--
-- Indexes for table `mdl_data`
--
ALTER TABLE `mdl_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_data_cou_ix` (`course`);

--
-- Indexes for table `mdl_data_content`
--
ALTER TABLE `mdl_data_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_datacont_rec_ix` (`recordid`),
  ADD KEY `mdl_datacont_fie_ix` (`fieldid`);

--
-- Indexes for table `mdl_data_fields`
--
ALTER TABLE `mdl_data_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_datafiel_typdat_ix` (`type`,`dataid`),
  ADD KEY `mdl_datafiel_dat_ix` (`dataid`);

--
-- Indexes for table `mdl_data_records`
--
ALTER TABLE `mdl_data_records`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_datareco_dat_ix` (`dataid`);

--
-- Indexes for table `mdl_enrol_authorize`
--
ALTER TABLE `mdl_enrol_authorize`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_enroauth_cou_ix` (`courseid`),
  ADD KEY `mdl_enroauth_use_ix` (`userid`),
  ADD KEY `mdl_enroauth_sta_ix` (`status`),
  ADD KEY `mdl_enroauth_tra_ix` (`transid`);

--
-- Indexes for table `mdl_enrol_authorize_refunds`
--
ALTER TABLE `mdl_enrol_authorize_refunds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_enroauthrefu_tra_ix` (`transid`),
  ADD KEY `mdl_enroauthrefu_ord_ix` (`orderid`);

--
-- Indexes for table `mdl_enrol_flatfile`
--
ALTER TABLE `mdl_enrol_flatfile`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_enroflat_cou_ix` (`courseid`),
  ADD KEY `mdl_enroflat_use_ix` (`userid`),
  ADD KEY `mdl_enroflat_rol_ix` (`roleid`);

--
-- Indexes for table `mdl_enrol_paypal`
--
ALTER TABLE `mdl_enrol_paypal`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_event`
--
ALTER TABLE `mdl_event`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_even_cou_ix` (`courseid`),
  ADD KEY `mdl_even_use_ix` (`userid`),
  ADD KEY `mdl_even_tim_ix` (`timestart`),
  ADD KEY `mdl_even_tim2_ix` (`timeduration`),
  ADD KEY `mdl_even_grocouvisuse_ix` (`groupid`,`courseid`,`visible`,`userid`);

--
-- Indexes for table `mdl_events_handlers`
--
ALTER TABLE `mdl_events_handlers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_evenhand_evecom_uix` (`eventname`,`component`);

--
-- Indexes for table `mdl_events_queue`
--
ALTER TABLE `mdl_events_queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_evenqueu_use_ix` (`userid`);

--
-- Indexes for table `mdl_events_queue_handlers`
--
ALTER TABLE `mdl_events_queue_handlers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_evenqueuhand_que_ix` (`queuedeventid`),
  ADD KEY `mdl_evenqueuhand_han_ix` (`handlerid`);

--
-- Indexes for table `mdl_event_subscriptions`
--
ALTER TABLE `mdl_event_subscriptions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_external_functions`
--
ALTER TABLE `mdl_external_functions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_extefunc_nam_uix` (`name`);

--
-- Indexes for table `mdl_external_services`
--
ALTER TABLE `mdl_external_services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_exteserv_nam_uix` (`name`);

--
-- Indexes for table `mdl_external_services_functions`
--
ALTER TABLE `mdl_external_services_functions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_exteservfunc_ext_ix` (`externalserviceid`);

--
-- Indexes for table `mdl_external_services_users`
--
ALTER TABLE `mdl_external_services_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_exteservuser_ext_ix` (`externalserviceid`),
  ADD KEY `mdl_exteservuser_use_ix` (`userid`);

--
-- Indexes for table `mdl_external_tokens`
--
ALTER TABLE `mdl_external_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_extetoke_use_ix` (`userid`),
  ADD KEY `mdl_extetoke_ext_ix` (`externalserviceid`),
  ADD KEY `mdl_extetoke_con_ix` (`contextid`),
  ADD KEY `mdl_extetoke_cre_ix` (`creatorid`);

--
-- Indexes for table `mdl_feedback`
--
ALTER TABLE `mdl_feedback`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feed_cou_ix` (`course`);

--
-- Indexes for table `mdl_feedback_completed`
--
ALTER TABLE `mdl_feedback_completed`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feedcomp_use_ix` (`userid`),
  ADD KEY `mdl_feedcomp_fee_ix` (`feedback`);

--
-- Indexes for table `mdl_feedback_completedtmp`
--
ALTER TABLE `mdl_feedback_completedtmp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feedcomp_use2_ix` (`userid`),
  ADD KEY `mdl_feedcomp_fee2_ix` (`feedback`);

--
-- Indexes for table `mdl_feedback_item`
--
ALTER TABLE `mdl_feedback_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feeditem_fee_ix` (`feedback`),
  ADD KEY `mdl_feeditem_tem_ix` (`template`);

--
-- Indexes for table `mdl_feedback_sitecourse_map`
--
ALTER TABLE `mdl_feedback_sitecourse_map`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feedsitemap_cou_ix` (`courseid`),
  ADD KEY `mdl_feedsitemap_fee_ix` (`feedbackid`);

--
-- Indexes for table `mdl_feedback_template`
--
ALTER TABLE `mdl_feedback_template`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feedtemp_cou_ix` (`course`);

--
-- Indexes for table `mdl_feedback_tracking`
--
ALTER TABLE `mdl_feedback_tracking`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feedtrac_use_ix` (`userid`),
  ADD KEY `mdl_feedtrac_fee_ix` (`feedback`),
  ADD KEY `mdl_feedtrac_com_ix` (`completed`);

--
-- Indexes for table `mdl_feedback_value`
--
ALTER TABLE `mdl_feedback_value`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feedvalu_cou_ix` (`course_id`),
  ADD KEY `mdl_feedvalu_ite_ix` (`item`);

--
-- Indexes for table `mdl_feedback_valuetmp`
--
ALTER TABLE `mdl_feedback_valuetmp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_feedvalu_cou2_ix` (`course_id`),
  ADD KEY `mdl_feedvalu_ite2_ix` (`item`);

--
-- Indexes for table `mdl_files`
--
ALTER TABLE `mdl_files`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_file_pat_uix` (`pathnamehash`),
  ADD KEY `mdl_file_comfilconite_ix` (`component`,`filearea`,`contextid`,`itemid`),
  ADD KEY `mdl_file_con_ix` (`contenthash`),
  ADD KEY `mdl_file_con2_ix` (`contextid`),
  ADD KEY `mdl_file_use_ix` (`userid`),
  ADD KEY `mdl_file_ref_ix` (`referencefileid`);

--
-- Indexes for table `mdl_files_reference`
--
ALTER TABLE `mdl_files_reference`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_filerefe_repref_uix` (`repositoryid`,`referencehash`),
  ADD KEY `mdl_filerefe_rep_ix` (`repositoryid`);

--
-- Indexes for table `mdl_filter_active`
--
ALTER TABLE `mdl_filter_active`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_filtacti_confil_uix` (`contextid`,`filter`),
  ADD KEY `mdl_filtacti_con_ix` (`contextid`);

--
-- Indexes for table `mdl_filter_config`
--
ALTER TABLE `mdl_filter_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_filtconf_confilnam_uix` (`contextid`,`filter`,`name`),
  ADD KEY `mdl_filtconf_con_ix` (`contextid`);

--
-- Indexes for table `mdl_folder`
--
ALTER TABLE `mdl_folder`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_fold_cou_ix` (`course`);

--
-- Indexes for table `mdl_forum`
--
ALTER TABLE `mdl_forum`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_foru_cou_ix` (`course`);

--
-- Indexes for table `mdl_forum_discussions`
--
ALTER TABLE `mdl_forum_discussions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_forudisc_use_ix` (`userid`),
  ADD KEY `mdl_forudisc_for_ix` (`forum`);

--
-- Indexes for table `mdl_forum_posts`
--
ALTER TABLE `mdl_forum_posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_forupost_use_ix` (`userid`),
  ADD KEY `mdl_forupost_cre_ix` (`created`),
  ADD KEY `mdl_forupost_mai_ix` (`mailed`),
  ADD KEY `mdl_forupost_dis_ix` (`discussion`),
  ADD KEY `mdl_forupost_par_ix` (`parent`);

--
-- Indexes for table `mdl_forum_queue`
--
ALTER TABLE `mdl_forum_queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_foruqueu_use_ix` (`userid`),
  ADD KEY `mdl_foruqueu_dis_ix` (`discussionid`),
  ADD KEY `mdl_foruqueu_pos_ix` (`postid`);

--
-- Indexes for table `mdl_forum_read`
--
ALTER TABLE `mdl_forum_read`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_foruread_usefor_ix` (`userid`,`forumid`),
  ADD KEY `mdl_foruread_usedis_ix` (`userid`,`discussionid`),
  ADD KEY `mdl_foruread_usepos_ix` (`userid`,`postid`);

--
-- Indexes for table `mdl_forum_subscriptions`
--
ALTER TABLE `mdl_forum_subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_forusubs_use_ix` (`userid`),
  ADD KEY `mdl_forusubs_for_ix` (`forum`);

--
-- Indexes for table `mdl_forum_track_prefs`
--
ALTER TABLE `mdl_forum_track_prefs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_forutracpref_usefor_ix` (`userid`,`forumid`);

--
-- Indexes for table `mdl_glossary`
--
ALTER TABLE `mdl_glossary`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_glos_cou_ix` (`course`);

--
-- Indexes for table `mdl_glossary_alias`
--
ALTER TABLE `mdl_glossary_alias`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_glosalia_ent_ix` (`entryid`);

--
-- Indexes for table `mdl_glossary_categories`
--
ALTER TABLE `mdl_glossary_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gloscate_glo_ix` (`glossaryid`);

--
-- Indexes for table `mdl_glossary_entries`
--
ALTER TABLE `mdl_glossary_entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_glosentr_use_ix` (`userid`),
  ADD KEY `mdl_glosentr_con_ix` (`concept`),
  ADD KEY `mdl_glosentr_glo_ix` (`glossaryid`);

--
-- Indexes for table `mdl_glossary_entries_categories`
--
ALTER TABLE `mdl_glossary_entries_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_glosentrcate_cat_ix` (`categoryid`),
  ADD KEY `mdl_glosentrcate_ent_ix` (`entryid`);

--
-- Indexes for table `mdl_glossary_formats`
--
ALTER TABLE `mdl_glossary_formats`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_grade_categories`
--
ALTER TABLE `mdl_grade_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradcate_cou_ix` (`courseid`),
  ADD KEY `mdl_gradcate_par_ix` (`parent`);

--
-- Indexes for table `mdl_grade_categories_history`
--
ALTER TABLE `mdl_grade_categories_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradcatehist_act_ix` (`action`),
  ADD KEY `mdl_gradcatehist_old_ix` (`oldid`),
  ADD KEY `mdl_gradcatehist_cou_ix` (`courseid`),
  ADD KEY `mdl_gradcatehist_par_ix` (`parent`),
  ADD KEY `mdl_gradcatehist_log_ix` (`loggeduser`);

--
-- Indexes for table `mdl_grade_grades`
--
ALTER TABLE `mdl_grade_grades`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradgrad_useite_uix` (`userid`,`itemid`),
  ADD KEY `mdl_gradgrad_locloc_ix` (`locked`,`locktime`),
  ADD KEY `mdl_gradgrad_ite_ix` (`itemid`),
  ADD KEY `mdl_gradgrad_use_ix` (`userid`),
  ADD KEY `mdl_gradgrad_raw_ix` (`rawscaleid`),
  ADD KEY `mdl_gradgrad_use2_ix` (`usermodified`);

--
-- Indexes for table `mdl_grade_grades_history`
--
ALTER TABLE `mdl_grade_grades_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradgradhist_act_ix` (`action`),
  ADD KEY `mdl_gradgradhist_old_ix` (`oldid`),
  ADD KEY `mdl_gradgradhist_ite_ix` (`itemid`),
  ADD KEY `mdl_gradgradhist_use_ix` (`userid`),
  ADD KEY `mdl_gradgradhist_raw_ix` (`rawscaleid`),
  ADD KEY `mdl_gradgradhist_use2_ix` (`usermodified`),
  ADD KEY `mdl_gradgradhist_log_ix` (`loggeduser`);

--
-- Indexes for table `mdl_grade_import_newitem`
--
ALTER TABLE `mdl_grade_import_newitem`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradimponewi_imp_ix` (`importer`);

--
-- Indexes for table `mdl_grade_import_values`
--
ALTER TABLE `mdl_grade_import_values`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradimpovalu_ite_ix` (`itemid`),
  ADD KEY `mdl_gradimpovalu_new_ix` (`newgradeitem`),
  ADD KEY `mdl_gradimpovalu_imp_ix` (`importer`);

--
-- Indexes for table `mdl_grade_items`
--
ALTER TABLE `mdl_grade_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_graditem_locloc_ix` (`locked`,`locktime`),
  ADD KEY `mdl_graditem_itenee_ix` (`itemtype`,`needsupdate`),
  ADD KEY `mdl_graditem_gra_ix` (`gradetype`),
  ADD KEY `mdl_graditem_idncou_ix` (`idnumber`,`courseid`),
  ADD KEY `mdl_graditem_cou_ix` (`courseid`),
  ADD KEY `mdl_graditem_cat_ix` (`categoryid`),
  ADD KEY `mdl_graditem_sca_ix` (`scaleid`),
  ADD KEY `mdl_graditem_out_ix` (`outcomeid`);

--
-- Indexes for table `mdl_grade_items_history`
--
ALTER TABLE `mdl_grade_items_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_graditemhist_act_ix` (`action`),
  ADD KEY `mdl_graditemhist_old_ix` (`oldid`),
  ADD KEY `mdl_graditemhist_cou_ix` (`courseid`),
  ADD KEY `mdl_graditemhist_cat_ix` (`categoryid`),
  ADD KEY `mdl_graditemhist_sca_ix` (`scaleid`),
  ADD KEY `mdl_graditemhist_out_ix` (`outcomeid`),
  ADD KEY `mdl_graditemhist_log_ix` (`loggeduser`);

--
-- Indexes for table `mdl_grade_letters`
--
ALTER TABLE `mdl_grade_letters`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradlett_conlowlet_uix` (`contextid`,`lowerboundary`,`letter`);

--
-- Indexes for table `mdl_grade_outcomes`
--
ALTER TABLE `mdl_grade_outcomes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradoutc_cousho_uix` (`courseid`,`shortname`),
  ADD KEY `mdl_gradoutc_cou_ix` (`courseid`),
  ADD KEY `mdl_gradoutc_sca_ix` (`scaleid`),
  ADD KEY `mdl_gradoutc_use_ix` (`usermodified`);

--
-- Indexes for table `mdl_grade_outcomes_courses`
--
ALTER TABLE `mdl_grade_outcomes_courses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradoutccour_couout_uix` (`courseid`,`outcomeid`),
  ADD KEY `mdl_gradoutccour_cou_ix` (`courseid`),
  ADD KEY `mdl_gradoutccour_out_ix` (`outcomeid`);

--
-- Indexes for table `mdl_grade_outcomes_history`
--
ALTER TABLE `mdl_grade_outcomes_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradoutchist_act_ix` (`action`),
  ADD KEY `mdl_gradoutchist_old_ix` (`oldid`),
  ADD KEY `mdl_gradoutchist_cou_ix` (`courseid`),
  ADD KEY `mdl_gradoutchist_sca_ix` (`scaleid`),
  ADD KEY `mdl_gradoutchist_log_ix` (`loggeduser`);

--
-- Indexes for table `mdl_grade_settings`
--
ALTER TABLE `mdl_grade_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradsett_counam_uix` (`courseid`,`name`),
  ADD KEY `mdl_gradsett_cou_ix` (`courseid`);

--
-- Indexes for table `mdl_gradingform_guide_comments`
--
ALTER TABLE `mdl_gradingform_guide_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradguidcomm_def_ix` (`definitionid`);

--
-- Indexes for table `mdl_gradingform_guide_criteria`
--
ALTER TABLE `mdl_gradingform_guide_criteria`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradguidcrit_def_ix` (`definitionid`);

--
-- Indexes for table `mdl_gradingform_guide_fillings`
--
ALTER TABLE `mdl_gradingform_guide_fillings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradguidfill_inscri_uix` (`instanceid`,`criterionid`),
  ADD KEY `mdl_gradguidfill_ins_ix` (`instanceid`),
  ADD KEY `mdl_gradguidfill_cri_ix` (`criterionid`);

--
-- Indexes for table `mdl_gradingform_rubric_criteria`
--
ALTER TABLE `mdl_gradingform_rubric_criteria`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradrubrcrit_def_ix` (`definitionid`);

--
-- Indexes for table `mdl_gradingform_rubric_fillings`
--
ALTER TABLE `mdl_gradingform_rubric_fillings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradrubrfill_inscri_uix` (`instanceid`,`criterionid`),
  ADD KEY `mdl_gradrubrfill_lev_ix` (`levelid`),
  ADD KEY `mdl_gradrubrfill_ins_ix` (`instanceid`),
  ADD KEY `mdl_gradrubrfill_cri_ix` (`criterionid`);

--
-- Indexes for table `mdl_gradingform_rubric_levels`
--
ALTER TABLE `mdl_gradingform_rubric_levels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradrubrleve_cri_ix` (`criterionid`);

--
-- Indexes for table `mdl_grading_areas`
--
ALTER TABLE `mdl_grading_areas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_gradarea_concomare_uix` (`contextid`,`component`,`areaname`),
  ADD KEY `mdl_gradarea_con_ix` (`contextid`);

--
-- Indexes for table `mdl_grading_definitions`
--
ALTER TABLE `mdl_grading_definitions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_graddefi_aremet_uix` (`areaid`,`method`),
  ADD KEY `mdl_graddefi_are_ix` (`areaid`),
  ADD KEY `mdl_graddefi_use_ix` (`usermodified`),
  ADD KEY `mdl_graddefi_use2_ix` (`usercreated`);

--
-- Indexes for table `mdl_grading_instances`
--
ALTER TABLE `mdl_grading_instances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_gradinst_def_ix` (`definitionid`),
  ADD KEY `mdl_gradinst_rat_ix` (`raterid`);

--
-- Indexes for table `mdl_groupings`
--
ALTER TABLE `mdl_groupings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_grou_idn2_ix` (`idnumber`),
  ADD KEY `mdl_grou_cou2_ix` (`courseid`);

--
-- Indexes for table `mdl_groupings_groups`
--
ALTER TABLE `mdl_groupings_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_grougrou_gro_ix` (`groupingid`),
  ADD KEY `mdl_grougrou_gro2_ix` (`groupid`);

--
-- Indexes for table `mdl_groups`
--
ALTER TABLE `mdl_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_grou_idn_ix` (`idnumber`),
  ADD KEY `mdl_grou_cou_ix` (`courseid`);

--
-- Indexes for table `mdl_groups_members`
--
ALTER TABLE `mdl_groups_members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_groumemb_gro_ix` (`groupid`),
  ADD KEY `mdl_groumemb_use_ix` (`userid`);

--
-- Indexes for table `mdl_imscp`
--
ALTER TABLE `mdl_imscp`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_imsc_cou_ix` (`course`);

--
-- Indexes for table `mdl_label`
--
ALTER TABLE `mdl_label`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_labe_cou_ix` (`course`);

--
-- Indexes for table `mdl_lesson`
--
ALTER TABLE `mdl_lesson`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_less_cou_ix` (`course`);

--
-- Indexes for table `mdl_lesson_answers`
--
ALTER TABLE `mdl_lesson_answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lessansw_les_ix` (`lessonid`),
  ADD KEY `mdl_lessansw_pag_ix` (`pageid`);

--
-- Indexes for table `mdl_lesson_attempts`
--
ALTER TABLE `mdl_lesson_attempts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lessatte_use_ix` (`userid`),
  ADD KEY `mdl_lessatte_les_ix` (`lessonid`),
  ADD KEY `mdl_lessatte_pag_ix` (`pageid`),
  ADD KEY `mdl_lessatte_ans_ix` (`answerid`);

--
-- Indexes for table `mdl_lesson_branch`
--
ALTER TABLE `mdl_lesson_branch`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lessbran_use_ix` (`userid`),
  ADD KEY `mdl_lessbran_les_ix` (`lessonid`),
  ADD KEY `mdl_lessbran_pag_ix` (`pageid`);

--
-- Indexes for table `mdl_lesson_grades`
--
ALTER TABLE `mdl_lesson_grades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lessgrad_use_ix` (`userid`),
  ADD KEY `mdl_lessgrad_les_ix` (`lessonid`);

--
-- Indexes for table `mdl_lesson_high_scores`
--
ALTER TABLE `mdl_lesson_high_scores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lesshighscor_use_ix` (`userid`),
  ADD KEY `mdl_lesshighscor_les_ix` (`lessonid`);

--
-- Indexes for table `mdl_lesson_pages`
--
ALTER TABLE `mdl_lesson_pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lesspage_les_ix` (`lessonid`);

--
-- Indexes for table `mdl_lesson_timer`
--
ALTER TABLE `mdl_lesson_timer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lesstime_use_ix` (`userid`),
  ADD KEY `mdl_lesstime_les_ix` (`lessonid`);

--
-- Indexes for table `mdl_license`
--
ALTER TABLE `mdl_license`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_log`
--
ALTER TABLE `mdl_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_log_coumodact_ix` (`course`,`module`,`action`),
  ADD KEY `mdl_log_tim_ix` (`time`),
  ADD KEY `mdl_log_act_ix` (`action`),
  ADD KEY `mdl_log_usecou_ix` (`userid`,`course`),
  ADD KEY `mdl_log_cmi_ix` (`cmid`);

--
-- Indexes for table `mdl_log_display`
--
ALTER TABLE `mdl_log_display`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_logdisp_modact_uix` (`module`,`action`);

--
-- Indexes for table `mdl_log_queries`
--
ALTER TABLE `mdl_log_queries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_lti`
--
ALTER TABLE `mdl_lti`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_lti_cou_ix` (`course`);

--
-- Indexes for table `mdl_lti_submission`
--
ALTER TABLE `mdl_lti_submission`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_ltisubm_lti_ix` (`ltiid`);

--
-- Indexes for table `mdl_lti_types`
--
ALTER TABLE `mdl_lti_types`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_ltitype_cou_ix` (`course`),
  ADD KEY `mdl_ltitype_too_ix` (`tooldomain`);

--
-- Indexes for table `mdl_lti_types_config`
--
ALTER TABLE `mdl_lti_types_config`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_ltitypeconf_typ_ix` (`typeid`);

--
-- Indexes for table `mdl_message`
--
ALTER TABLE `mdl_message`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_mess_use_ix` (`useridfrom`),
  ADD KEY `mdl_mess_use2_ix` (`useridto`);

--
-- Indexes for table `mdl_message_contacts`
--
ALTER TABLE `mdl_message_contacts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_messcont_usecon_uix` (`userid`,`contactid`);

--
-- Indexes for table `mdl_message_processors`
--
ALTER TABLE `mdl_message_processors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_message_providers`
--
ALTER TABLE `mdl_message_providers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_messprov_comnam_uix` (`component`,`name`);

--
-- Indexes for table `mdl_message_read`
--
ALTER TABLE `mdl_message_read`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_messread_use_ix` (`useridfrom`),
  ADD KEY `mdl_messread_use2_ix` (`useridto`);

--
-- Indexes for table `mdl_message_working`
--
ALTER TABLE `mdl_message_working`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_mnetservice_enrol_courses`
--
ALTER TABLE `mdl_mnetservice_enrol_courses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_mnetenrocour_hosrem_uix` (`hostid`,`remoteid`);

--
-- Indexes for table `mdl_mnetservice_enrol_enrolments`
--
ALTER TABLE `mdl_mnetservice_enrol_enrolments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_mnetenroenro_use_ix` (`userid`),
  ADD KEY `mdl_mnetenroenro_hos_ix` (`hostid`);

--
-- Indexes for table `mdl_mnet_application`
--
ALTER TABLE `mdl_mnet_application`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_mnet_host`
--
ALTER TABLE `mdl_mnet_host`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_mnethost_app_ix` (`applicationid`);

--
-- Indexes for table `mdl_mnet_host2service`
--
ALTER TABLE `mdl_mnet_host2service`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_mnethost_hosser_uix` (`hostid`,`serviceid`);

--
-- Indexes for table `mdl_mnet_log`
--
ALTER TABLE `mdl_mnet_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_mnetlog_hosusecou_ix` (`hostid`,`userid`,`course`);

--
-- Indexes for table `mdl_mnet_remote_rpc`
--
ALTER TABLE `mdl_mnet_remote_rpc`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_mnet_remote_service2rpc`
--
ALTER TABLE `mdl_mnet_remote_service2rpc`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_mnetremoserv_rpcser_uix` (`rpcid`,`serviceid`);

--
-- Indexes for table `mdl_mnet_rpc`
--
ALTER TABLE `mdl_mnet_rpc`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_mnetrpc_enaxml_ix` (`enabled`,`xmlrpcpath`);

--
-- Indexes for table `mdl_mnet_service`
--
ALTER TABLE `mdl_mnet_service`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_mnet_service2rpc`
--
ALTER TABLE `mdl_mnet_service2rpc`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_mnetserv_rpcser_uix` (`rpcid`,`serviceid`);

--
-- Indexes for table `mdl_mnet_session`
--
ALTER TABLE `mdl_mnet_session`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_mnetsess_tok_uix` (`token`);

--
-- Indexes for table `mdl_mnet_sso_access_control`
--
ALTER TABLE `mdl_mnet_sso_access_control`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_mnetssoaccecont_mneuse_uix` (`mnet_host_id`,`username`);

--
-- Indexes for table `mdl_modules`
--
ALTER TABLE `mdl_modules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_modu_nam_ix` (`name`);

--
-- Indexes for table `mdl_my_pages`
--
ALTER TABLE `mdl_my_pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_mypage_usepri_ix` (`userid`,`private`);

--
-- Indexes for table `mdl_page`
--
ALTER TABLE `mdl_page`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_page_cou_ix` (`course`);

--
-- Indexes for table `mdl_portfolio_instance`
--
ALTER TABLE `mdl_portfolio_instance`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_portfolio_instance_config`
--
ALTER TABLE `mdl_portfolio_instance_config`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_portinstconf_nam_ix` (`name`),
  ADD KEY `mdl_portinstconf_ins_ix` (`instance`);

--
-- Indexes for table `mdl_portfolio_instance_user`
--
ALTER TABLE `mdl_portfolio_instance_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_portinstuser_ins_ix` (`instance`),
  ADD KEY `mdl_portinstuser_use_ix` (`userid`);

--
-- Indexes for table `mdl_portfolio_log`
--
ALTER TABLE `mdl_portfolio_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_portlog_use_ix` (`userid`),
  ADD KEY `mdl_portlog_por_ix` (`portfolio`);

--
-- Indexes for table `mdl_portfolio_mahara_queue`
--
ALTER TABLE `mdl_portfolio_mahara_queue`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_portmahaqueu_tok_ix` (`token`),
  ADD KEY `mdl_portmahaqueu_tra_ix` (`transferid`);

--
-- Indexes for table `mdl_portfolio_tempdata`
--
ALTER TABLE `mdl_portfolio_tempdata`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_porttemp_use_ix` (`userid`),
  ADD KEY `mdl_porttemp_ins_ix` (`instance`);

--
-- Indexes for table `mdl_post`
--
ALTER TABLE `mdl_post`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_post_iduse_uix` (`id`,`userid`),
  ADD KEY `mdl_post_las_ix` (`lastmodified`),
  ADD KEY `mdl_post_mod_ix` (`module`),
  ADD KEY `mdl_post_sub_ix` (`subject`),
  ADD KEY `mdl_post_use_ix` (`usermodified`);

--
-- Indexes for table `mdl_profiling`
--
ALTER TABLE `mdl_profiling`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_prof_run_uix` (`runid`),
  ADD KEY `mdl_prof_urlrun_ix` (`url`,`runreference`),
  ADD KEY `mdl_prof_timrun_ix` (`timecreated`,`runreference`);

--
-- Indexes for table `mdl_qtype_essay_options`
--
ALTER TABLE `mdl_qtype_essay_options`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_qtypessaopti_que_uix` (`questionid`);

--
-- Indexes for table `mdl_question`
--
ALTER TABLE `mdl_question`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_ques_cat_ix` (`category`),
  ADD KEY `mdl_ques_par_ix` (`parent`),
  ADD KEY `mdl_ques_cre_ix` (`createdby`),
  ADD KEY `mdl_ques_mod_ix` (`modifiedby`);

--
-- Indexes for table `mdl_question_answers`
--
ALTER TABLE `mdl_question_answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesansw_que_ix` (`question`);

--
-- Indexes for table `mdl_question_attempts`
--
ALTER TABLE `mdl_question_attempts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_quesatte_queslo_uix` (`questionusageid`,`slot`),
  ADD KEY `mdl_quesatte_que_ix` (`questionid`),
  ADD KEY `mdl_quesatte_que2_ix` (`questionusageid`);

--
-- Indexes for table `mdl_question_attempt_steps`
--
ALTER TABLE `mdl_question_attempt_steps`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_quesattestep_queseq_uix` (`questionattemptid`,`sequencenumber`),
  ADD KEY `mdl_quesattestep_que_ix` (`questionattemptid`),
  ADD KEY `mdl_quesattestep_use_ix` (`userid`);

--
-- Indexes for table `mdl_question_attempt_step_data`
--
ALTER TABLE `mdl_question_attempt_step_data`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_quesattestepdata_attna_uix` (`attemptstepid`,`name`),
  ADD KEY `mdl_quesattestepdata_att_ix` (`attemptstepid`);

--
-- Indexes for table `mdl_question_calculated`
--
ALTER TABLE `mdl_question_calculated`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quescalc_ans_ix` (`answer`),
  ADD KEY `mdl_quescalc_que_ix` (`question`);

--
-- Indexes for table `mdl_question_calculated_options`
--
ALTER TABLE `mdl_question_calculated_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quescalcopti_que_ix` (`question`);

--
-- Indexes for table `mdl_question_categories`
--
ALTER TABLE `mdl_question_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quescate_con_ix` (`contextid`),
  ADD KEY `mdl_quescate_par_ix` (`parent`);

--
-- Indexes for table `mdl_question_datasets`
--
ALTER TABLE `mdl_question_datasets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesdata_quedat_ix` (`question`,`datasetdefinition`),
  ADD KEY `mdl_quesdata_que_ix` (`question`),
  ADD KEY `mdl_quesdata_dat_ix` (`datasetdefinition`);

--
-- Indexes for table `mdl_question_dataset_definitions`
--
ALTER TABLE `mdl_question_dataset_definitions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesdatadefi_cat_ix` (`category`);

--
-- Indexes for table `mdl_question_dataset_items`
--
ALTER TABLE `mdl_question_dataset_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesdataitem_def_ix` (`definition`);

--
-- Indexes for table `mdl_question_hints`
--
ALTER TABLE `mdl_question_hints`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_queshint_que_ix` (`questionid`);

--
-- Indexes for table `mdl_question_match`
--
ALTER TABLE `mdl_question_match`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesmatc_que_ix` (`question`);

--
-- Indexes for table `mdl_question_match_sub`
--
ALTER TABLE `mdl_question_match_sub`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesmatcsub_que_ix` (`question`);

--
-- Indexes for table `mdl_question_multianswer`
--
ALTER TABLE `mdl_question_multianswer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesmult_que_ix` (`question`);

--
-- Indexes for table `mdl_question_multichoice`
--
ALTER TABLE `mdl_question_multichoice`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesmult_que2_ix` (`question`);

--
-- Indexes for table `mdl_question_numerical`
--
ALTER TABLE `mdl_question_numerical`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesnume_ans_ix` (`answer`),
  ADD KEY `mdl_quesnume_que_ix` (`question`);

--
-- Indexes for table `mdl_question_numerical_options`
--
ALTER TABLE `mdl_question_numerical_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesnumeopti_que_ix` (`question`);

--
-- Indexes for table `mdl_question_numerical_units`
--
ALTER TABLE `mdl_question_numerical_units`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_quesnumeunit_queuni_uix` (`question`,`unit`),
  ADD KEY `mdl_quesnumeunit_que_ix` (`question`);

--
-- Indexes for table `mdl_question_randomsamatch`
--
ALTER TABLE `mdl_question_randomsamatch`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesrand_que_ix` (`question`);

--
-- Indexes for table `mdl_question_sessions`
--
ALTER TABLE `mdl_question_sessions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_quessess_attque_uix` (`attemptid`,`questionid`),
  ADD KEY `mdl_quessess_att_ix` (`attemptid`),
  ADD KEY `mdl_quessess_que_ix` (`questionid`),
  ADD KEY `mdl_quessess_new_ix` (`newest`),
  ADD KEY `mdl_quessess_new2_ix` (`newgraded`);

--
-- Indexes for table `mdl_question_shortanswer`
--
ALTER TABLE `mdl_question_shortanswer`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesshor_que_ix` (`question`);

--
-- Indexes for table `mdl_question_states`
--
ALTER TABLE `mdl_question_states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesstat_att_ix` (`attempt`),
  ADD KEY `mdl_quesstat_que_ix` (`question`);

--
-- Indexes for table `mdl_question_truefalse`
--
ALTER TABLE `mdl_question_truefalse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_questrue_que_ix` (`question`);

--
-- Indexes for table `mdl_question_usages`
--
ALTER TABLE `mdl_question_usages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quesusag_con_ix` (`contextid`);

--
-- Indexes for table `mdl_quiz`
--
ALTER TABLE `mdl_quiz`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quiz_cou_ix` (`course`);

--
-- Indexes for table `mdl_quiz_attempts`
--
ALTER TABLE `mdl_quiz_attempts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_quizatte_quiuseatt_uix` (`quiz`,`userid`,`attempt`),
  ADD UNIQUE KEY `mdl_quizatte_uni_uix` (`uniqueid`),
  ADD KEY `mdl_quizatte_statim_ix` (`state`,`timecheckstate`),
  ADD KEY `mdl_quizatte_qui_ix` (`quiz`),
  ADD KEY `mdl_quizatte_use_ix` (`userid`);

--
-- Indexes for table `mdl_quiz_feedback`
--
ALTER TABLE `mdl_quiz_feedback`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quizfeed_qui_ix` (`quizid`);

--
-- Indexes for table `mdl_quiz_grades`
--
ALTER TABLE `mdl_quiz_grades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quizgrad_use_ix` (`userid`),
  ADD KEY `mdl_quizgrad_qui_ix` (`quiz`);

--
-- Indexes for table `mdl_quiz_overrides`
--
ALTER TABLE `mdl_quiz_overrides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quizover_qui_ix` (`quiz`),
  ADD KEY `mdl_quizover_gro_ix` (`groupid`),
  ADD KEY `mdl_quizover_use_ix` (`userid`);

--
-- Indexes for table `mdl_quiz_overview_regrades`
--
ALTER TABLE `mdl_quiz_overview_regrades`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_quiz_question_instances`
--
ALTER TABLE `mdl_quiz_question_instances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_quizquesinst_qui_ix` (`quiz`),
  ADD KEY `mdl_quizquesinst_que_ix` (`question`);

--
-- Indexes for table `mdl_quiz_question_response_stats`
--
ALTER TABLE `mdl_quiz_question_response_stats`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_quiz_question_statistics`
--
ALTER TABLE `mdl_quiz_question_statistics`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_quiz_reports`
--
ALTER TABLE `mdl_quiz_reports`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_quizrepo_nam_uix` (`name`);

--
-- Indexes for table `mdl_quiz_statistics`
--
ALTER TABLE `mdl_quiz_statistics`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_rating`
--
ALTER TABLE `mdl_rating`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_rati_comratconite_ix` (`component`,`ratingarea`,`contextid`,`itemid`),
  ADD KEY `mdl_rati_con_ix` (`contextid`),
  ADD KEY `mdl_rati_use_ix` (`userid`);

--
-- Indexes for table `mdl_registration_hubs`
--
ALTER TABLE `mdl_registration_hubs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_repository`
--
ALTER TABLE `mdl_repository`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_repository_instance_config`
--
ALTER TABLE `mdl_repository_instance_config`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_resource`
--
ALTER TABLE `mdl_resource`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_reso_cou_ix` (`course`);

--
-- Indexes for table `mdl_resource_old`
--
ALTER TABLE `mdl_resource_old`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_resoold_old_uix` (`oldid`),
  ADD KEY `mdl_resoold_cmi_ix` (`cmid`);

--
-- Indexes for table `mdl_role`
--
ALTER TABLE `mdl_role`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_role_sor_uix` (`sortorder`),
  ADD UNIQUE KEY `mdl_role_sho_uix` (`shortname`);

--
-- Indexes for table `mdl_role_allow_assign`
--
ALTER TABLE `mdl_role_allow_assign`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_rolealloassi_rolall_uix` (`roleid`,`allowassign`),
  ADD KEY `mdl_rolealloassi_rol_ix` (`roleid`),
  ADD KEY `mdl_rolealloassi_all_ix` (`allowassign`);

--
-- Indexes for table `mdl_role_allow_override`
--
ALTER TABLE `mdl_role_allow_override`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_rolealloover_rolall_uix` (`roleid`,`allowoverride`),
  ADD KEY `mdl_rolealloover_rol_ix` (`roleid`),
  ADD KEY `mdl_rolealloover_all_ix` (`allowoverride`);

--
-- Indexes for table `mdl_role_allow_switch`
--
ALTER TABLE `mdl_role_allow_switch`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_rolealloswit_rolall_uix` (`roleid`,`allowswitch`),
  ADD KEY `mdl_rolealloswit_rol_ix` (`roleid`),
  ADD KEY `mdl_rolealloswit_all_ix` (`allowswitch`);

--
-- Indexes for table `mdl_role_assignments`
--
ALTER TABLE `mdl_role_assignments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_roleassi_sor_ix` (`sortorder`),
  ADD KEY `mdl_roleassi_rolcon_ix` (`roleid`,`contextid`),
  ADD KEY `mdl_roleassi_useconrol_ix` (`userid`,`contextid`,`roleid`),
  ADD KEY `mdl_roleassi_comiteuse_ix` (`component`,`itemid`,`userid`),
  ADD KEY `mdl_roleassi_rol_ix` (`roleid`),
  ADD KEY `mdl_roleassi_con_ix` (`contextid`),
  ADD KEY `mdl_roleassi_use_ix` (`userid`);

--
-- Indexes for table `mdl_role_capabilities`
--
ALTER TABLE `mdl_role_capabilities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_rolecapa_rolconcap_uix` (`roleid`,`contextid`,`capability`),
  ADD KEY `mdl_rolecapa_rol_ix` (`roleid`),
  ADD KEY `mdl_rolecapa_con_ix` (`contextid`),
  ADD KEY `mdl_rolecapa_mod_ix` (`modifierid`),
  ADD KEY `mdl_rolecapa_cap_ix` (`capability`);

--
-- Indexes for table `mdl_role_context_levels`
--
ALTER TABLE `mdl_role_context_levels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_rolecontleve_conrol_uix` (`contextlevel`,`roleid`),
  ADD KEY `mdl_rolecontleve_rol_ix` (`roleid`);

--
-- Indexes for table `mdl_role_names`
--
ALTER TABLE `mdl_role_names`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_rolename_rolcon_uix` (`roleid`,`contextid`),
  ADD KEY `mdl_rolename_rol_ix` (`roleid`),
  ADD KEY `mdl_rolename_con_ix` (`contextid`);

--
-- Indexes for table `mdl_role_sortorder`
--
ALTER TABLE `mdl_role_sortorder`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_rolesort_userolcon_uix` (`userid`,`roleid`,`contextid`),
  ADD KEY `mdl_rolesort_use_ix` (`userid`),
  ADD KEY `mdl_rolesort_rol_ix` (`roleid`),
  ADD KEY `mdl_rolesort_con_ix` (`contextid`);

--
-- Indexes for table `mdl_scale`
--
ALTER TABLE `mdl_scale`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_scal_cou_ix` (`courseid`);

--
-- Indexes for table `mdl_scale_history`
--
ALTER TABLE `mdl_scale_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_scalhist_act_ix` (`action`),
  ADD KEY `mdl_scalhist_old_ix` (`oldid`),
  ADD KEY `mdl_scalhist_cou_ix` (`courseid`),
  ADD KEY `mdl_scalhist_log_ix` (`loggeduser`);

--
-- Indexes for table `mdl_scorm`
--
ALTER TABLE `mdl_scorm`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_scor_cou_ix` (`course`);

--
-- Indexes for table `mdl_scorm_aicc_session`
--
ALTER TABLE `mdl_scorm_aicc_session`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_scoraiccsess_sco_ix` (`scormid`),
  ADD KEY `mdl_scoraiccsess_use_ix` (`userid`);

--
-- Indexes for table `mdl_scorm_scoes`
--
ALTER TABLE `mdl_scorm_scoes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_scorscoe_sco_ix` (`scorm`);

--
-- Indexes for table `mdl_scorm_scoes_data`
--
ALTER TABLE `mdl_scorm_scoes_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_scorscoedata_sco_ix` (`scoid`);

--
-- Indexes for table `mdl_scorm_scoes_track`
--
ALTER TABLE `mdl_scorm_scoes_track`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_scorscoetrac_usescosco_uix` (`userid`,`scormid`,`scoid`,`attempt`,`element`),
  ADD KEY `mdl_scorscoetrac_use_ix` (`userid`),
  ADD KEY `mdl_scorscoetrac_ele_ix` (`element`),
  ADD KEY `mdl_scorscoetrac_sco_ix` (`scormid`),
  ADD KEY `mdl_scorscoetrac_sco2_ix` (`scoid`);

--
-- Indexes for table `mdl_scorm_seq_mapinfo`
--
ALTER TABLE `mdl_scorm_seq_mapinfo`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_scorseqmapi_scoidobj_uix` (`scoid`,`id`,`objectiveid`),
  ADD KEY `mdl_scorseqmapi_sco_ix` (`scoid`),
  ADD KEY `mdl_scorseqmapi_obj_ix` (`objectiveid`);

--
-- Indexes for table `mdl_scorm_seq_objective`
--
ALTER TABLE `mdl_scorm_seq_objective`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_scorseqobje_scoid_uix` (`scoid`,`id`),
  ADD KEY `mdl_scorseqobje_sco_ix` (`scoid`);

--
-- Indexes for table `mdl_scorm_seq_rolluprule`
--
ALTER TABLE `mdl_scorm_seq_rolluprule`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_scorseqroll_scoid_uix` (`scoid`,`id`),
  ADD KEY `mdl_scorseqroll_sco_ix` (`scoid`);

--
-- Indexes for table `mdl_scorm_seq_rolluprulecond`
--
ALTER TABLE `mdl_scorm_seq_rolluprulecond`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_scorseqroll_scorolid_uix` (`scoid`,`rollupruleid`,`id`),
  ADD KEY `mdl_scorseqroll_sco2_ix` (`scoid`),
  ADD KEY `mdl_scorseqroll_rol_ix` (`rollupruleid`);

--
-- Indexes for table `mdl_scorm_seq_rulecond`
--
ALTER TABLE `mdl_scorm_seq_rulecond`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_scorseqrule_idscorul_uix` (`id`,`scoid`,`ruleconditionsid`),
  ADD KEY `mdl_scorseqrule_sco2_ix` (`scoid`),
  ADD KEY `mdl_scorseqrule_rul_ix` (`ruleconditionsid`);

--
-- Indexes for table `mdl_scorm_seq_ruleconds`
--
ALTER TABLE `mdl_scorm_seq_ruleconds`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_scorseqrule_scoid_uix` (`scoid`,`id`),
  ADD KEY `mdl_scorseqrule_sco_ix` (`scoid`);

--
-- Indexes for table `mdl_sessions`
--
ALTER TABLE `mdl_sessions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_sess_sid_uix` (`sid`),
  ADD KEY `mdl_sess_sta_ix` (`state`),
  ADD KEY `mdl_sess_tim_ix` (`timecreated`),
  ADD KEY `mdl_sess_tim2_ix` (`timemodified`),
  ADD KEY `mdl_sess_use_ix` (`userid`);

--
-- Indexes for table `mdl_stats_daily`
--
ALTER TABLE `mdl_stats_daily`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_statdail_cou_ix` (`courseid`),
  ADD KEY `mdl_statdail_tim_ix` (`timeend`),
  ADD KEY `mdl_statdail_rol_ix` (`roleid`);

--
-- Indexes for table `mdl_stats_monthly`
--
ALTER TABLE `mdl_stats_monthly`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_statmont_cou_ix` (`courseid`),
  ADD KEY `mdl_statmont_tim_ix` (`timeend`),
  ADD KEY `mdl_statmont_rol_ix` (`roleid`);

--
-- Indexes for table `mdl_stats_user_daily`
--
ALTER TABLE `mdl_stats_user_daily`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_statuserdail_cou_ix` (`courseid`),
  ADD KEY `mdl_statuserdail_use_ix` (`userid`),
  ADD KEY `mdl_statuserdail_rol_ix` (`roleid`),
  ADD KEY `mdl_statuserdail_tim_ix` (`timeend`);

--
-- Indexes for table `mdl_stats_user_monthly`
--
ALTER TABLE `mdl_stats_user_monthly`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_statusermont_cou_ix` (`courseid`),
  ADD KEY `mdl_statusermont_use_ix` (`userid`),
  ADD KEY `mdl_statusermont_rol_ix` (`roleid`),
  ADD KEY `mdl_statusermont_tim_ix` (`timeend`);

--
-- Indexes for table `mdl_stats_user_weekly`
--
ALTER TABLE `mdl_stats_user_weekly`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_statuserweek_cou_ix` (`courseid`),
  ADD KEY `mdl_statuserweek_use_ix` (`userid`),
  ADD KEY `mdl_statuserweek_rol_ix` (`roleid`),
  ADD KEY `mdl_statuserweek_tim_ix` (`timeend`);

--
-- Indexes for table `mdl_stats_weekly`
--
ALTER TABLE `mdl_stats_weekly`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_statweek_cou_ix` (`courseid`),
  ADD KEY `mdl_statweek_tim_ix` (`timeend`),
  ADD KEY `mdl_statweek_rol_ix` (`roleid`);

--
-- Indexes for table `mdl_survey`
--
ALTER TABLE `mdl_survey`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_surv_cou_ix` (`course`);

--
-- Indexes for table `mdl_survey_analysis`
--
ALTER TABLE `mdl_survey_analysis`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_survanal_use_ix` (`userid`),
  ADD KEY `mdl_survanal_sur_ix` (`survey`);

--
-- Indexes for table `mdl_survey_answers`
--
ALTER TABLE `mdl_survey_answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_survansw_use_ix` (`userid`),
  ADD KEY `mdl_survansw_sur_ix` (`survey`),
  ADD KEY `mdl_survansw_que_ix` (`question`);

--
-- Indexes for table `mdl_survey_questions`
--
ALTER TABLE `mdl_survey_questions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_tag`
--
ALTER TABLE `mdl_tag`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_tag_nam_uix` (`name`),
  ADD UNIQUE KEY `mdl_tag_idnam_uix` (`id`,`name`),
  ADD KEY `mdl_tag_use_ix` (`userid`);

--
-- Indexes for table `mdl_tag_correlation`
--
ALTER TABLE `mdl_tag_correlation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_tagcorr_tag_ix` (`tagid`);

--
-- Indexes for table `mdl_tag_instance`
--
ALTER TABLE `mdl_tag_instance`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_taginst_iteitetagtiu_uix` (`itemtype`,`itemid`,`tagid`,`tiuserid`),
  ADD KEY `mdl_taginst_tag_ix` (`tagid`);

--
-- Indexes for table `mdl_temp_enroled_template`
--
ALTER TABLE `mdl_temp_enroled_template`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_tempenrotemp_use_ix` (`userid`),
  ADD KEY `mdl_tempenrotemp_cou_ix` (`courseid`),
  ADD KEY `mdl_tempenrotemp_rol_ix` (`roleid`);

--
-- Indexes for table `mdl_temp_log_template`
--
ALTER TABLE `mdl_temp_log_template`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_templogtemp_act_ix` (`action`),
  ADD KEY `mdl_templogtemp_cou_ix` (`course`),
  ADD KEY `mdl_templogtemp_use_ix` (`userid`),
  ADD KEY `mdl_templogtemp_usecouact_ix` (`userid`,`course`,`action`);

--
-- Indexes for table `mdl_timezone`
--
ALTER TABLE `mdl_timezone`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_tool_customlang`
--
ALTER TABLE `mdl_tool_customlang`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_toolcust_lancomstr_uix` (`lang`,`componentid`,`stringid`),
  ADD KEY `mdl_toolcust_com_ix` (`componentid`);

--
-- Indexes for table `mdl_tool_customlang_components`
--
ALTER TABLE `mdl_tool_customlang_components`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_upgrade_log`
--
ALTER TABLE `mdl_upgrade_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_upgrlog_tim_ix` (`timemodified`),
  ADD KEY `mdl_upgrlog_typtim_ix` (`type`,`timemodified`),
  ADD KEY `mdl_upgrlog_use_ix` (`userid`);

--
-- Indexes for table `mdl_url`
--
ALTER TABLE `mdl_url`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_url_cou_ix` (`course`);

--
-- Indexes for table `mdl_user_enrolments`
--
ALTER TABLE `mdl_user_enrolments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_userenro_enruse_uix` (`enrolid`,`userid`),
  ADD KEY `mdl_userenro_enr_ix` (`enrolid`),
  ADD KEY `mdl_userenro_use_ix` (`userid`),
  ADD KEY `mdl_userenro_mod_ix` (`modifierid`);

--
-- Indexes for table `mdl_user_info_category`
--
ALTER TABLE `mdl_user_info_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_user_info_data`
--
ALTER TABLE `mdl_user_info_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_userinfodata_usefie_ix` (`userid`,`fieldid`);

--
-- Indexes for table `mdl_user_info_field`
--
ALTER TABLE `mdl_user_info_field`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_user_lastaccess`
--
ALTER TABLE `mdl_user_lastaccess`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_userlast_usecou_uix` (`userid`,`courseid`),
  ADD KEY `mdl_userlast_use_ix` (`userid`),
  ADD KEY `mdl_userlast_cou_ix` (`courseid`);

--
-- Indexes for table `mdl_user_preferences`
--
ALTER TABLE `mdl_user_preferences`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_userpref_usenam_uix` (`userid`,`name`);

--
-- Indexes for table `mdl_user_private_key`
--
ALTER TABLE `mdl_user_private_key`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_userprivkey_scrval_ix` (`script`,`value`),
  ADD KEY `mdl_userprivkey_use_ix` (`userid`);

--
-- Indexes for table `mdl_webdav_locks`
--
ALTER TABLE `mdl_webdav_locks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_webdlock_tok_uix` (`token`),
  ADD KEY `mdl_webdlock_pat_ix` (`path`),
  ADD KEY `mdl_webdlock_exp_ix` (`expiry`);

--
-- Indexes for table `mdl_wiki`
--
ALTER TABLE `mdl_wiki`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_wiki_cou_ix` (`course`);

--
-- Indexes for table `mdl_wiki_links`
--
ALTER TABLE `mdl_wiki_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_wikilink_fro_ix` (`frompageid`),
  ADD KEY `mdl_wikilink_sub_ix` (`subwikiid`);

--
-- Indexes for table `mdl_wiki_locks`
--
ALTER TABLE `mdl_wiki_locks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mdl_wiki_pages`
--
ALTER TABLE `mdl_wiki_pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_wikipage_subtituse_uix` (`subwikiid`,`title`,`userid`),
  ADD KEY `mdl_wikipage_sub_ix` (`subwikiid`);

--
-- Indexes for table `mdl_wiki_subwikis`
--
ALTER TABLE `mdl_wiki_subwikis`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_wikisubw_wikgrouse_uix` (`wikiid`,`groupid`,`userid`),
  ADD KEY `mdl_wikisubw_wik_ix` (`wikiid`);

--
-- Indexes for table `mdl_wiki_synonyms`
--
ALTER TABLE `mdl_wiki_synonyms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_wikisyno_pagpag_uix` (`pageid`,`pagesynonym`);

--
-- Indexes for table `mdl_wiki_versions`
--
ALTER TABLE `mdl_wiki_versions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_wikivers_pag_ix` (`pageid`);

--
-- Indexes for table `mdl_workshop`
--
ALTER TABLE `mdl_workshop`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_work_cou_ix` (`course`);

--
-- Indexes for table `mdl_workshopallocation_scheduled`
--
ALTER TABLE `mdl_workshopallocation_scheduled`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_worksche_wor_uix` (`workshopid`);

--
-- Indexes for table `mdl_workshopeval_best_settings`
--
ALTER TABLE `mdl_workshopeval_best_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_workbestsett_wor_uix` (`workshopid`);

--
-- Indexes for table `mdl_workshopform_accumulative`
--
ALTER TABLE `mdl_workshopform_accumulative`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workaccu_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshopform_comments`
--
ALTER TABLE `mdl_workshopform_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workcomm_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshopform_numerrors`
--
ALTER TABLE `mdl_workshopform_numerrors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_worknume_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshopform_numerrors_map`
--
ALTER TABLE `mdl_workshopform_numerrors_map`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_worknumemap_wornon_uix` (`workshopid`,`nonegative`),
  ADD KEY `mdl_worknumemap_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshopform_rubric`
--
ALTER TABLE `mdl_workshopform_rubric`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workrubr_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshopform_rubric_config`
--
ALTER TABLE `mdl_workshopform_rubric_config`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_workrubrconf_wor_uix` (`workshopid`);

--
-- Indexes for table `mdl_workshopform_rubric_levels`
--
ALTER TABLE `mdl_workshopform_rubric_levels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workrubrleve_dim_ix` (`dimensionid`);

--
-- Indexes for table `mdl_workshop_aggregations`
--
ALTER TABLE `mdl_workshop_aggregations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_workaggr_woruse_uix` (`workshopid`,`userid`),
  ADD KEY `mdl_workaggr_wor_ix` (`workshopid`),
  ADD KEY `mdl_workaggr_use_ix` (`userid`);

--
-- Indexes for table `mdl_workshop_assessments`
--
ALTER TABLE `mdl_workshop_assessments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workasse_sub_ix` (`submissionid`),
  ADD KEY `mdl_workasse_gra_ix` (`gradinggradeoverby`),
  ADD KEY `mdl_workasse_rev_ix` (`reviewerid`);

--
-- Indexes for table `mdl_workshop_assessments_old`
--
ALTER TABLE `mdl_workshop_assessments_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workasseold_use_ix` (`userid`),
  ADD KEY `mdl_workasseold_mai_ix` (`mailed`),
  ADD KEY `mdl_workasseold_wor_ix` (`workshopid`),
  ADD KEY `mdl_workasseold_sub_ix` (`submissionid`);

--
-- Indexes for table `mdl_workshop_comments_old`
--
ALTER TABLE `mdl_workshop_comments_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workcommold_use_ix` (`userid`),
  ADD KEY `mdl_workcommold_mai_ix` (`mailed`),
  ADD KEY `mdl_workcommold_wor_ix` (`workshopid`),
  ADD KEY `mdl_workcommold_ass_ix` (`assessmentid`);

--
-- Indexes for table `mdl_workshop_elements_old`
--
ALTER TABLE `mdl_workshop_elements_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workelemold_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshop_grades`
--
ALTER TABLE `mdl_workshop_grades`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mdl_workgrad_assstrdim_uix` (`assessmentid`,`strategy`,`dimensionid`),
  ADD KEY `mdl_workgrad_ass_ix` (`assessmentid`);

--
-- Indexes for table `mdl_workshop_grades_old`
--
ALTER TABLE `mdl_workshop_grades_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workgradold_wor_ix` (`workshopid`),
  ADD KEY `mdl_workgradold_ass_ix` (`assessmentid`);

--
-- Indexes for table `mdl_workshop_old`
--
ALTER TABLE `mdl_workshop_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workold_cou_ix` (`course`);

--
-- Indexes for table `mdl_workshop_rubrics_old`
--
ALTER TABLE `mdl_workshop_rubrics_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workrubrold_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshop_stockcomments_old`
--
ALTER TABLE `mdl_workshop_stockcomments_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_workstocold_wor_ix` (`workshopid`);

--
-- Indexes for table `mdl_workshop_submissions`
--
ALTER TABLE `mdl_workshop_submissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_worksubm_wor_ix` (`workshopid`),
  ADD KEY `mdl_worksubm_gra_ix` (`gradeoverby`),
  ADD KEY `mdl_worksubm_aut_ix` (`authorid`);

--
-- Indexes for table `mdl_workshop_submissions_old`
--
ALTER TABLE `mdl_workshop_submissions_old`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mdl_worksubmold_use_ix` (`userid`),
  ADD KEY `mdl_worksubmold_mai_ix` (`mailed`),
  ADD KEY `mdl_worksubmold_wor_ix` (`workshopid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mdl_assign`
--
ALTER TABLE `mdl_assign`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assignfeedback_comments`
--
ALTER TABLE `mdl_assignfeedback_comments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assignfeedback_file`
--
ALTER TABLE `mdl_assignfeedback_file`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assignment`
--
ALTER TABLE `mdl_assignment`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assignment_submissions`
--
ALTER TABLE `mdl_assignment_submissions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assignsubmission_file`
--
ALTER TABLE `mdl_assignsubmission_file`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assignsubmission_onlinetext`
--
ALTER TABLE `mdl_assignsubmission_onlinetext`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assign_grades`
--
ALTER TABLE `mdl_assign_grades`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assign_plugin_config`
--
ALTER TABLE `mdl_assign_plugin_config`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assign_submission`
--
ALTER TABLE `mdl_assign_submission`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_assign_user_mapping`
--
ALTER TABLE `mdl_assign_user_mapping`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_backup_controllers`
--
ALTER TABLE `mdl_backup_controllers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mdl_backup_courses`
--
ALTER TABLE `mdl_backup_courses`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_backup_files_template`
--
ALTER TABLE `mdl_backup_files_template`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_backup_ids_template`
--
ALTER TABLE `mdl_backup_ids_template`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_backup_logs`
--
ALTER TABLE `mdl_backup_logs`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_block`
--
ALTER TABLE `mdl_block`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `mdl_block_community`
--
ALTER TABLE `mdl_block_community`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_block_instances`
--
ALTER TABLE `mdl_block_instances`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171;

--
-- AUTO_INCREMENT for table `mdl_block_positions`
--
ALTER TABLE `mdl_block_positions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_block_rss_client`
--
ALTER TABLE `mdl_block_rss_client`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_blog_association`
--
ALTER TABLE `mdl_blog_association`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_blog_external`
--
ALTER TABLE `mdl_blog_external`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_book`
--
ALTER TABLE `mdl_book`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_book_chapters`
--
ALTER TABLE `mdl_book_chapters`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_cache_filters`
--
ALTER TABLE `mdl_cache_filters`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_cache_flags`
--
ALTER TABLE `mdl_cache_flags`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=130;

--
-- AUTO_INCREMENT for table `mdl_cache_text`
--
ALTER TABLE `mdl_cache_text`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `mdl_capabilities`
--
ALTER TABLE `mdl_capabilities`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=477;

--
-- AUTO_INCREMENT for table `mdl_chat`
--
ALTER TABLE `mdl_chat`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mdl_chat_messages`
--
ALTER TABLE `mdl_chat_messages`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `mdl_chat_messages_current`
--
ALTER TABLE `mdl_chat_messages_current`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `mdl_chat_users`
--
ALTER TABLE `mdl_chat_users`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_choice`
--
ALTER TABLE `mdl_choice`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_choice_answers`
--
ALTER TABLE `mdl_choice_answers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_choice_options`
--
ALTER TABLE `mdl_choice_options`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_cohort`
--
ALTER TABLE `mdl_cohort`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_cohort_members`
--
ALTER TABLE `mdl_cohort_members`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_comments`
--
ALTER TABLE `mdl_comments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_config`
--
ALTER TABLE `mdl_config`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=411;

--
-- AUTO_INCREMENT for table `mdl_config_log`
--
ALTER TABLE `mdl_config_log`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=815;

--
-- AUTO_INCREMENT for table `mdl_config_plugins`
--
ALTER TABLE `mdl_config_plugins`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=889;

--
-- AUTO_INCREMENT for table `mdl_context`
--
ALTER TABLE `mdl_context`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=296;

--
-- AUTO_INCREMENT for table `mdl_course`
--
ALTER TABLE `mdl_course`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `mdl_course_categories`
--
ALTER TABLE `mdl_course_categories`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `mdl_course_completions`
--
ALTER TABLE `mdl_course_completions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_completion_aggr_methd`
--
ALTER TABLE `mdl_course_completion_aggr_methd`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_completion_criteria`
--
ALTER TABLE `mdl_course_completion_criteria`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_completion_crit_compl`
--
ALTER TABLE `mdl_course_completion_crit_compl`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_format_options`
--
ALTER TABLE `mdl_course_format_options`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;

--
-- AUTO_INCREMENT for table `mdl_course_modules`
--
ALTER TABLE `mdl_course_modules`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `mdl_course_modules_availability`
--
ALTER TABLE `mdl_course_modules_availability`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_modules_avail_fields`
--
ALTER TABLE `mdl_course_modules_avail_fields`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_modules_completion`
--
ALTER TABLE `mdl_course_modules_completion`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_published`
--
ALTER TABLE `mdl_course_published`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_request`
--
ALTER TABLE `mdl_course_request`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_sections`
--
ALTER TABLE `mdl_course_sections`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `mdl_course_sections_availability`
--
ALTER TABLE `mdl_course_sections_availability`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_course_sections_avail_fields`
--
ALTER TABLE `mdl_course_sections_avail_fields`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_data`
--
ALTER TABLE `mdl_data`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_data_content`
--
ALTER TABLE `mdl_data_content`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_data_fields`
--
ALTER TABLE `mdl_data_fields`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_data_records`
--
ALTER TABLE `mdl_data_records`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_enrol_authorize`
--
ALTER TABLE `mdl_enrol_authorize`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_enrol_authorize_refunds`
--
ALTER TABLE `mdl_enrol_authorize_refunds`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_enrol_flatfile`
--
ALTER TABLE `mdl_enrol_flatfile`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_enrol_paypal`
--
ALTER TABLE `mdl_enrol_paypal`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_event`
--
ALTER TABLE `mdl_event`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mdl_events_handlers`
--
ALTER TABLE `mdl_events_handlers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `mdl_events_queue`
--
ALTER TABLE `mdl_events_queue`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_events_queue_handlers`
--
ALTER TABLE `mdl_events_queue_handlers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_event_subscriptions`
--
ALTER TABLE `mdl_event_subscriptions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_external_functions`
--
ALTER TABLE `mdl_external_functions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `mdl_external_services`
--
ALTER TABLE `mdl_external_services`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mdl_external_services_functions`
--
ALTER TABLE `mdl_external_services_functions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `mdl_external_services_users`
--
ALTER TABLE `mdl_external_services_users`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_external_tokens`
--
ALTER TABLE `mdl_external_tokens`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback`
--
ALTER TABLE `mdl_feedback`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_completed`
--
ALTER TABLE `mdl_feedback_completed`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_completedtmp`
--
ALTER TABLE `mdl_feedback_completedtmp`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_item`
--
ALTER TABLE `mdl_feedback_item`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_sitecourse_map`
--
ALTER TABLE `mdl_feedback_sitecourse_map`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_template`
--
ALTER TABLE `mdl_feedback_template`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_tracking`
--
ALTER TABLE `mdl_feedback_tracking`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_value`
--
ALTER TABLE `mdl_feedback_value`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_feedback_valuetmp`
--
ALTER TABLE `mdl_feedback_valuetmp`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_files`
--
ALTER TABLE `mdl_files`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `mdl_files_reference`
--
ALTER TABLE `mdl_files_reference`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_filter_active`
--
ALTER TABLE `mdl_filter_active`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `mdl_filter_config`
--
ALTER TABLE `mdl_filter_config`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_folder`
--
ALTER TABLE `mdl_folder`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_forum`
--
ALTER TABLE `mdl_forum`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mdl_forum_discussions`
--
ALTER TABLE `mdl_forum_discussions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_forum_posts`
--
ALTER TABLE `mdl_forum_posts`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_forum_queue`
--
ALTER TABLE `mdl_forum_queue`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_forum_read`
--
ALTER TABLE `mdl_forum_read`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_forum_subscriptions`
--
ALTER TABLE `mdl_forum_subscriptions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_forum_track_prefs`
--
ALTER TABLE `mdl_forum_track_prefs`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_glossary`
--
ALTER TABLE `mdl_glossary`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_glossary_alias`
--
ALTER TABLE `mdl_glossary_alias`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_glossary_categories`
--
ALTER TABLE `mdl_glossary_categories`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_glossary_entries`
--
ALTER TABLE `mdl_glossary_entries`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_glossary_entries_categories`
--
ALTER TABLE `mdl_glossary_entries_categories`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_glossary_formats`
--
ALTER TABLE `mdl_glossary_formats`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `mdl_grade_categories`
--
ALTER TABLE `mdl_grade_categories`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mdl_grade_categories_history`
--
ALTER TABLE `mdl_grade_categories_history`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mdl_grade_grades`
--
ALTER TABLE `mdl_grade_grades`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_grades_history`
--
ALTER TABLE `mdl_grade_grades_history`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_import_newitem`
--
ALTER TABLE `mdl_grade_import_newitem`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_import_values`
--
ALTER TABLE `mdl_grade_import_values`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_items`
--
ALTER TABLE `mdl_grade_items`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mdl_grade_items_history`
--
ALTER TABLE `mdl_grade_items_history`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mdl_grade_letters`
--
ALTER TABLE `mdl_grade_letters`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_outcomes`
--
ALTER TABLE `mdl_grade_outcomes`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_outcomes_courses`
--
ALTER TABLE `mdl_grade_outcomes_courses`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_outcomes_history`
--
ALTER TABLE `mdl_grade_outcomes_history`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grade_settings`
--
ALTER TABLE `mdl_grade_settings`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_gradingform_guide_comments`
--
ALTER TABLE `mdl_gradingform_guide_comments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_gradingform_guide_criteria`
--
ALTER TABLE `mdl_gradingform_guide_criteria`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_gradingform_guide_fillings`
--
ALTER TABLE `mdl_gradingform_guide_fillings`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_gradingform_rubric_criteria`
--
ALTER TABLE `mdl_gradingform_rubric_criteria`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_gradingform_rubric_fillings`
--
ALTER TABLE `mdl_gradingform_rubric_fillings`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_gradingform_rubric_levels`
--
ALTER TABLE `mdl_gradingform_rubric_levels`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grading_areas`
--
ALTER TABLE `mdl_grading_areas`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grading_definitions`
--
ALTER TABLE `mdl_grading_definitions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_grading_instances`
--
ALTER TABLE `mdl_grading_instances`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_groupings`
--
ALTER TABLE `mdl_groupings`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_groupings_groups`
--
ALTER TABLE `mdl_groupings_groups`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_groups`
--
ALTER TABLE `mdl_groups`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_groups_members`
--
ALTER TABLE `mdl_groups_members`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_imscp`
--
ALTER TABLE `mdl_imscp`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_label`
--
ALTER TABLE `mdl_label`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson`
--
ALTER TABLE `mdl_lesson`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson_answers`
--
ALTER TABLE `mdl_lesson_answers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson_attempts`
--
ALTER TABLE `mdl_lesson_attempts`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson_branch`
--
ALTER TABLE `mdl_lesson_branch`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson_grades`
--
ALTER TABLE `mdl_lesson_grades`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson_high_scores`
--
ALTER TABLE `mdl_lesson_high_scores`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson_pages`
--
ALTER TABLE `mdl_lesson_pages`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lesson_timer`
--
ALTER TABLE `mdl_lesson_timer`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_license`
--
ALTER TABLE `mdl_license`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mdl_log`
--
ALTER TABLE `mdl_log`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=454;

--
-- AUTO_INCREMENT for table `mdl_log_display`
--
ALTER TABLE `mdl_log_display`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=176;

--
-- AUTO_INCREMENT for table `mdl_log_queries`
--
ALTER TABLE `mdl_log_queries`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lti`
--
ALTER TABLE `mdl_lti`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lti_submission`
--
ALTER TABLE `mdl_lti_submission`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lti_types`
--
ALTER TABLE `mdl_lti_types`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_lti_types_config`
--
ALTER TABLE `mdl_lti_types_config`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_message`
--
ALTER TABLE `mdl_message`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_message_contacts`
--
ALTER TABLE `mdl_message_contacts`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_message_processors`
--
ALTER TABLE `mdl_message_processors`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mdl_message_providers`
--
ALTER TABLE `mdl_message_providers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `mdl_message_read`
--
ALTER TABLE `mdl_message_read`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_message_working`
--
ALTER TABLE `mdl_message_working`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_mnetservice_enrol_courses`
--
ALTER TABLE `mdl_mnetservice_enrol_courses`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_mnetservice_enrol_enrolments`
--
ALTER TABLE `mdl_mnetservice_enrol_enrolments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_mnet_application`
--
ALTER TABLE `mdl_mnet_application`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mdl_mnet_host`
--
ALTER TABLE `mdl_mnet_host`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `mdl_mnet_host2service`
--
ALTER TABLE `mdl_mnet_host2service`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_mnet_log`
--
ALTER TABLE `mdl_mnet_log`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_mnet_remote_rpc`
--
ALTER TABLE `mdl_mnet_remote_rpc`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `mdl_mnet_remote_service2rpc`
--
ALTER TABLE `mdl_mnet_remote_service2rpc`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `mdl_mnet_rpc`
--
ALTER TABLE `mdl_mnet_rpc`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `mdl_mnet_service`
--
ALTER TABLE `mdl_mnet_service`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mdl_mnet_service2rpc`
--
ALTER TABLE `mdl_mnet_service2rpc`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `mdl_mnet_session`
--
ALTER TABLE `mdl_mnet_session`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_mnet_sso_access_control`
--
ALTER TABLE `mdl_mnet_sso_access_control`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_modules`
--
ALTER TABLE `mdl_modules`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `mdl_my_pages`
--
ALTER TABLE `mdl_my_pages`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mdl_page`
--
ALTER TABLE `mdl_page`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_portfolio_instance`
--
ALTER TABLE `mdl_portfolio_instance`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_portfolio_instance_config`
--
ALTER TABLE `mdl_portfolio_instance_config`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_portfolio_instance_user`
--
ALTER TABLE `mdl_portfolio_instance_user`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_portfolio_log`
--
ALTER TABLE `mdl_portfolio_log`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_portfolio_mahara_queue`
--
ALTER TABLE `mdl_portfolio_mahara_queue`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_portfolio_tempdata`
--
ALTER TABLE `mdl_portfolio_tempdata`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_post`
--
ALTER TABLE `mdl_post`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_profiling`
--
ALTER TABLE `mdl_profiling`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_qtype_essay_options`
--
ALTER TABLE `mdl_qtype_essay_options`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question`
--
ALTER TABLE `mdl_question`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_answers`
--
ALTER TABLE `mdl_question_answers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_attempts`
--
ALTER TABLE `mdl_question_attempts`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_attempt_steps`
--
ALTER TABLE `mdl_question_attempt_steps`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_attempt_step_data`
--
ALTER TABLE `mdl_question_attempt_step_data`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_calculated`
--
ALTER TABLE `mdl_question_calculated`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_calculated_options`
--
ALTER TABLE `mdl_question_calculated_options`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_categories`
--
ALTER TABLE `mdl_question_categories`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_datasets`
--
ALTER TABLE `mdl_question_datasets`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_dataset_definitions`
--
ALTER TABLE `mdl_question_dataset_definitions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_dataset_items`
--
ALTER TABLE `mdl_question_dataset_items`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_hints`
--
ALTER TABLE `mdl_question_hints`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_match`
--
ALTER TABLE `mdl_question_match`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_match_sub`
--
ALTER TABLE `mdl_question_match_sub`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_multianswer`
--
ALTER TABLE `mdl_question_multianswer`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_multichoice`
--
ALTER TABLE `mdl_question_multichoice`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_numerical`
--
ALTER TABLE `mdl_question_numerical`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_numerical_options`
--
ALTER TABLE `mdl_question_numerical_options`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_numerical_units`
--
ALTER TABLE `mdl_question_numerical_units`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_randomsamatch`
--
ALTER TABLE `mdl_question_randomsamatch`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_sessions`
--
ALTER TABLE `mdl_question_sessions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_shortanswer`
--
ALTER TABLE `mdl_question_shortanswer`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_states`
--
ALTER TABLE `mdl_question_states`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_truefalse`
--
ALTER TABLE `mdl_question_truefalse`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_question_usages`
--
ALTER TABLE `mdl_question_usages`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz`
--
ALTER TABLE `mdl_quiz`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_attempts`
--
ALTER TABLE `mdl_quiz_attempts`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_feedback`
--
ALTER TABLE `mdl_quiz_feedback`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_grades`
--
ALTER TABLE `mdl_quiz_grades`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_overrides`
--
ALTER TABLE `mdl_quiz_overrides`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_overview_regrades`
--
ALTER TABLE `mdl_quiz_overview_regrades`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_question_instances`
--
ALTER TABLE `mdl_quiz_question_instances`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_question_response_stats`
--
ALTER TABLE `mdl_quiz_question_response_stats`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_question_statistics`
--
ALTER TABLE `mdl_quiz_question_statistics`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_quiz_reports`
--
ALTER TABLE `mdl_quiz_reports`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `mdl_quiz_statistics`
--
ALTER TABLE `mdl_quiz_statistics`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_rating`
--
ALTER TABLE `mdl_rating`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_registration_hubs`
--
ALTER TABLE `mdl_registration_hubs`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_repository`
--
ALTER TABLE `mdl_repository`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `mdl_repository_instance_config`
--
ALTER TABLE `mdl_repository_instance_config`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_resource`
--
ALTER TABLE `mdl_resource`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mdl_resource_old`
--
ALTER TABLE `mdl_resource_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_role`
--
ALTER TABLE `mdl_role`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `mdl_role_allow_assign`
--
ALTER TABLE `mdl_role_allow_assign`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `mdl_role_allow_override`
--
ALTER TABLE `mdl_role_allow_override`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `mdl_role_allow_switch`
--
ALTER TABLE `mdl_role_allow_switch`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `mdl_role_assignments`
--
ALTER TABLE `mdl_role_assignments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `mdl_role_capabilities`
--
ALTER TABLE `mdl_role_capabilities`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1096;

--
-- AUTO_INCREMENT for table `mdl_role_context_levels`
--
ALTER TABLE `mdl_role_context_levels`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `mdl_role_names`
--
ALTER TABLE `mdl_role_names`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_role_sortorder`
--
ALTER TABLE `mdl_role_sortorder`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scale`
--
ALTER TABLE `mdl_scale`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scale_history`
--
ALTER TABLE `mdl_scale_history`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm`
--
ALTER TABLE `mdl_scorm`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_aicc_session`
--
ALTER TABLE `mdl_scorm_aicc_session`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_scoes`
--
ALTER TABLE `mdl_scorm_scoes`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_scoes_data`
--
ALTER TABLE `mdl_scorm_scoes_data`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_scoes_track`
--
ALTER TABLE `mdl_scorm_scoes_track`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_seq_mapinfo`
--
ALTER TABLE `mdl_scorm_seq_mapinfo`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_seq_objective`
--
ALTER TABLE `mdl_scorm_seq_objective`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_seq_rolluprule`
--
ALTER TABLE `mdl_scorm_seq_rolluprule`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_seq_rolluprulecond`
--
ALTER TABLE `mdl_scorm_seq_rolluprulecond`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_seq_rulecond`
--
ALTER TABLE `mdl_scorm_seq_rulecond`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_scorm_seq_ruleconds`
--
ALTER TABLE `mdl_scorm_seq_ruleconds`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_sessions`
--
ALTER TABLE `mdl_sessions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT for table `mdl_stats_daily`
--
ALTER TABLE `mdl_stats_daily`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_stats_monthly`
--
ALTER TABLE `mdl_stats_monthly`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_stats_user_daily`
--
ALTER TABLE `mdl_stats_user_daily`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_stats_user_monthly`
--
ALTER TABLE `mdl_stats_user_monthly`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_stats_user_weekly`
--
ALTER TABLE `mdl_stats_user_weekly`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_stats_weekly`
--
ALTER TABLE `mdl_stats_weekly`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_survey`
--
ALTER TABLE `mdl_survey`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `mdl_survey_analysis`
--
ALTER TABLE `mdl_survey_analysis`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_survey_answers`
--
ALTER TABLE `mdl_survey_answers`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_survey_questions`
--
ALTER TABLE `mdl_survey_questions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `mdl_tag`
--
ALTER TABLE `mdl_tag`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_tag_correlation`
--
ALTER TABLE `mdl_tag_correlation`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_tag_instance`
--
ALTER TABLE `mdl_tag_instance`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_temp_enroled_template`
--
ALTER TABLE `mdl_temp_enroled_template`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_temp_log_template`
--
ALTER TABLE `mdl_temp_log_template`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_timezone`
--
ALTER TABLE `mdl_timezone`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_tool_customlang`
--
ALTER TABLE `mdl_tool_customlang`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_tool_customlang_components`
--
ALTER TABLE `mdl_tool_customlang_components`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_upgrade_log`
--
ALTER TABLE `mdl_upgrade_log`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=864;

--
-- AUTO_INCREMENT for table `mdl_url`
--
ALTER TABLE `mdl_url`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_user_enrolments`
--
ALTER TABLE `mdl_user_enrolments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `mdl_user_info_category`
--
ALTER TABLE `mdl_user_info_category`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mdl_user_info_data`
--
ALTER TABLE `mdl_user_info_data`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_user_info_field`
--
ALTER TABLE `mdl_user_info_field`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_user_lastaccess`
--
ALTER TABLE `mdl_user_lastaccess`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `mdl_user_preferences`
--
ALTER TABLE `mdl_user_preferences`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT for table `mdl_user_private_key`
--
ALTER TABLE `mdl_user_private_key`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_webdav_locks`
--
ALTER TABLE `mdl_webdav_locks`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_wiki`
--
ALTER TABLE `mdl_wiki`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_wiki_links`
--
ALTER TABLE `mdl_wiki_links`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_wiki_locks`
--
ALTER TABLE `mdl_wiki_locks`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_wiki_pages`
--
ALTER TABLE `mdl_wiki_pages`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_wiki_subwikis`
--
ALTER TABLE `mdl_wiki_subwikis`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_wiki_synonyms`
--
ALTER TABLE `mdl_wiki_synonyms`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_wiki_versions`
--
ALTER TABLE `mdl_wiki_versions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop`
--
ALTER TABLE `mdl_workshop`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopallocation_scheduled`
--
ALTER TABLE `mdl_workshopallocation_scheduled`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopeval_best_settings`
--
ALTER TABLE `mdl_workshopeval_best_settings`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopform_accumulative`
--
ALTER TABLE `mdl_workshopform_accumulative`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopform_comments`
--
ALTER TABLE `mdl_workshopform_comments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopform_numerrors`
--
ALTER TABLE `mdl_workshopform_numerrors`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopform_numerrors_map`
--
ALTER TABLE `mdl_workshopform_numerrors_map`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopform_rubric`
--
ALTER TABLE `mdl_workshopform_rubric`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopform_rubric_config`
--
ALTER TABLE `mdl_workshopform_rubric_config`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshopform_rubric_levels`
--
ALTER TABLE `mdl_workshopform_rubric_levels`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_aggregations`
--
ALTER TABLE `mdl_workshop_aggregations`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_assessments`
--
ALTER TABLE `mdl_workshop_assessments`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_assessments_old`
--
ALTER TABLE `mdl_workshop_assessments_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_comments_old`
--
ALTER TABLE `mdl_workshop_comments_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_elements_old`
--
ALTER TABLE `mdl_workshop_elements_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_grades`
--
ALTER TABLE `mdl_workshop_grades`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_grades_old`
--
ALTER TABLE `mdl_workshop_grades_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_old`
--
ALTER TABLE `mdl_workshop_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_rubrics_old`
--
ALTER TABLE `mdl_workshop_rubrics_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_stockcomments_old`
--
ALTER TABLE `mdl_workshop_stockcomments_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_submissions`
--
ALTER TABLE `mdl_workshop_submissions`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mdl_workshop_submissions_old`
--
ALTER TABLE `mdl_workshop_submissions_old`
  MODIFY `id` bigint(10) NOT NULL AUTO_INCREMENT;
COMMIT;

