--
-- Host: localhost    Database: moodle_DB
-- ------------------------------------------------------


--
-- Table structure for table `mdl_label`
--

CREATE TABLE `mdl_label` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `course` 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) DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_labe_cou_ix` (`course`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Defines labels';

--
-- Dumping data for table `mdl_label`
--

INSERT INTO `mdl_label` VALUES (1,368,'Label','<p><img src=\"@@PLUGINFILE@@/Laws-1.png\" alt=\"\" width=\"1000\" height=\"1412\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p>',1,1541777461),(2,368,'Label','<p><img src=\"@@PLUGINFILE@@/Laws1-1.PNG\" alt=\"\" width=\"1000\" height=\"233\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p>',1,1541777566),(3,368,'표지','<p><img src=\"@@PLUGINFILE@@/Laws2-1.PNG\" alt=\"\" width=\"1000\" height=\"260\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p>',1,1541777687),(4,368,'표지','<p><img src=\"@@PLUGINFILE@@/Laws3-1.PNG\" alt=\"\" width=\"1000\" height=\"412\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws3-2.PNG\" alt=\"\" width=\"1000\" height=\"413\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws3-3.PNG\" alt=\"\" width=\"1000\" height=\"481\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws3-4.PNG\" alt=\"\" width=\"1000\" height=\"384\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws3-5.PNG\" alt=\"\" width=\"1000\" height=\"266\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws3-6.PNG\" alt=\"\" width=\"1000\" height=\"540\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws3-7.PNG\" alt=\"\" width=\"1000\" height=\"404\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws3-8.PNG\" alt=\"\" width=\"1000\" height=\"121\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p>',1,1541778227),(5,368,'표지','<p><img src=\"@@PLUGINFILE@@/Laws4-1.PNG\" alt=\"\" width=\"1000\" height=\"486\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws4-2.PNG\" alt=\"\" width=\"1000\" height=\"584\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws4-3.PNG\" alt=\"\" width=\"1012\" height=\"468\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p>',1,1541778468),(6,368,'표지','<p><img src=\"@@PLUGINFILE@@/Laws5-1.PNG\" alt=\"\" width=\"1000\" height=\"499\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p><p><img src=\"@@PLUGINFILE@@/Laws5-2.PNG\" alt=\"\" width=\"1000\" height=\"424\" role=\"presentation\" class=\"img-responsive atto_image_button_text-bottom\"><br></p>',1,1541778625),(8,1261,'&nbsp; &nbsp; Зүгээр тэмдэр буюу тайлбарлахын тулд','<p>&nbsp; &nbsp; Зүгээр тэмдэр буюу тайлбарлахын тулд</p>',1,1549049561),(9,758,'TEST','<p>TEST</p>',1,1550047361);

--
-- Table structure for table `mdl_lesson_answers`
--

CREATE TABLE `mdl_lesson_answers` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lessonid` bigint(10) NOT NULL DEFAULT '0',
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `jumpto` bigint(11) NOT NULL DEFAULT '0',
  `grade` smallint(4) NOT NULL DEFAULT '0',
  `score` bigint(10) NOT NULL DEFAULT '0',
  `flags` smallint(3) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `answer` longtext COLLATE utf8_unicode_ci,
  `answerformat` tinyint(2) NOT NULL DEFAULT '0',
  `response` longtext COLLATE utf8_unicode_ci,
  `responseformat` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_lessansw_les_ix` (`lessonid`),
  KEY `mdl_lessansw_pag_ix` (`pageid`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Defines lesson_answers';

--
-- Dumping data for table `mdl_lesson_answers`
--

INSERT INTO `mdl_lesson_answers` VALUES (4,168,3,0,0,0,0,1555096816,0,'content',0,NULL,0),(5,168,3,-1,0,0,0,1555096816,0,'content2',0,NULL,0),(6,168,4,-80,0,0,0,1555096836,0,NULL,0,NULL,0),(7,168,5,-1,0,1,0,1555096898,0,'<p>1</p>',1,'',1),(8,168,5,0,0,0,0,1555096898,0,'<p>2</p>',1,'',1),(9,168,5,0,0,0,0,1555096898,0,'<p>3</p>',1,'',1),(10,168,5,0,0,0,0,1555096898,0,'<p>4</p>',1,'',1);

--
-- Table structure for table `mdl_lesson_attempts`
--

CREATE TABLE `mdl_lesson_attempts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lessonid` bigint(10) NOT NULL DEFAULT '0',
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `answerid` bigint(10) NOT NULL DEFAULT '0',
  `retry` smallint(3) NOT NULL DEFAULT '0',
  `correct` bigint(10) NOT NULL DEFAULT '0',
  `useranswer` longtext COLLATE utf8_unicode_ci,
  `timeseen` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_lessatte_use_ix` (`userid`),
  KEY `mdl_lessatte_les_ix` (`lessonid`),
  KEY `mdl_lessatte_pag_ix` (`pageid`),
  KEY `mdl_lessatte_ans_ix` (`answerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Defines lesson_attempts';

--
-- Dumping data for table `mdl_lesson_attempts`
--


--
-- Table structure for table `mdl_lesson_branch`
--

CREATE TABLE `mdl_lesson_branch` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lessonid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `pageid` bigint(10) NOT NULL DEFAULT '0',
  `retry` bigint(10) NOT NULL DEFAULT '0',
  `flag` smallint(3) NOT NULL DEFAULT '0',
  `timeseen` bigint(10) NOT NULL DEFAULT '0',
  `nextpageid` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_lessbran_use_ix` (`userid`),
  KEY `mdl_lessbran_les_ix` (`lessonid`),
  KEY `mdl_lessbran_pag_ix` (`pageid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='branches for each lesson/user';

--
-- Dumping data for table `mdl_lesson_branch`
--

INSERT INTO `mdl_lesson_branch` VALUES (2,168,250,3,0,0,1555096928,3),(3,168,250,3,0,0,1555096931,-9);

--
-- Table structure for table `mdl_lesson_grades`
--

CREATE TABLE `mdl_lesson_grades` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lessonid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `grade` double NOT NULL DEFAULT '0',
  `late` smallint(3) NOT NULL DEFAULT '0',
  `completed` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_lessgrad_use_ix` (`userid`),
  KEY `mdl_lessgrad_les_ix` (`lessonid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Defines lesson_grades';

--
-- Dumping data for table `mdl_lesson_grades`
--


--
-- Table structure for table `mdl_lesson_overrides`
--

CREATE TABLE `mdl_lesson_overrides` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lessonid` bigint(10) NOT NULL DEFAULT '0',
  `groupid` bigint(10) DEFAULT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `available` bigint(10) DEFAULT NULL,
  `deadline` bigint(10) DEFAULT NULL,
  `timelimit` bigint(10) DEFAULT NULL,
  `review` smallint(3) DEFAULT NULL,
  `maxattempts` smallint(3) DEFAULT NULL,
  `retake` smallint(3) DEFAULT NULL,
  `password` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_lessover_les_ix` (`lessonid`),
  KEY `mdl_lessover_gro_ix` (`groupid`),
  KEY `mdl_lessover_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The overrides to lesson settings.';

--
-- Dumping data for table `mdl_lesson_overrides`
--


--
-- Table structure for table `mdl_lesson_pages`
--

CREATE TABLE `mdl_lesson_pages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lessonid` bigint(10) NOT NULL DEFAULT '0',
  `prevpageid` bigint(10) NOT NULL DEFAULT '0',
  `nextpageid` bigint(10) NOT NULL DEFAULT '0',
  `qtype` smallint(3) NOT NULL DEFAULT '0',
  `qoption` smallint(3) NOT NULL DEFAULT '0',
  `layout` smallint(3) NOT NULL DEFAULT '1',
  `display` smallint(3) NOT NULL DEFAULT '1',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `contents` longtext COLLATE utf8_unicode_ci NOT NULL,
  `contentsformat` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_lesspage_les_ix` (`lessonid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Defines lesson_pages';

--
-- Dumping data for table `mdl_lesson_pages`
--

INSERT INTO `mdl_lesson_pages` VALUES (3,168,4,0,20,0,1,1,1555096816,0,'Content','<p>content</p>',1),(4,168,5,3,30,0,1,1,1555096836,0,'Cluster','Cluster',0),(5,168,0,4,3,0,0,0,1555096898,0,'MCQ','<p>MCQ</p>',1);

--
-- Table structure for table `mdl_lesson_timer`
--

CREATE TABLE `mdl_lesson_timer` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `lessonid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `starttime` bigint(10) NOT NULL DEFAULT '0',
  `lessontime` bigint(10) NOT NULL DEFAULT '0',
  `completed` tinyint(1) DEFAULT '0',
  `timemodifiedoffline` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_lesstime_use_ix` (`userid`),
  KEY `mdl_lesstime_les_ix` (`lessonid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='lesson timer for each lesson';

--
-- Dumping data for table `mdl_lesson_timer`
--


--
-- Table structure for table `mdl_license`
--

CREATE TABLE `mdl_license` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `shortname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fullname` longtext COLLATE utf8_unicode_ci,
  `source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '1',
  `version` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='store licenses used by moodle';

--
-- Dumping data for table `mdl_license`
--

INSERT INTO `mdl_license` VALUES (1,'unknown','Unknown license','',1,2010033100),(2,'allrightsreserved','All rights reserved','http://en.wikipedia.org/wiki/All_rights_reserved',1,2010033100),(3,'public','Public Domain','http://creativecommons.org/licenses/publicdomain/',1,2010033100),(4,'cc','Creative Commons','http://creativecommons.org/licenses/by/3.0/',1,2010033100),(5,'cc-nd','Creative Commons - NoDerivs','http://creativecommons.org/licenses/by-nd/3.0/',1,2010033100),(6,'cc-nc-nd','Creative Commons - No Commercial NoDerivs','http://creativecommons.org/licenses/by-nc-nd/3.0/',1,2010033100),(7,'cc-nc','Creative Commons - No Commercial','http://creativecommons.org/licenses/by-nc/3.0/',1,2013051500),(8,'cc-nc-sa','Creative Commons - No Commercial ShareAlike','http://creativecommons.org/licenses/by-nc-sa/3.0/',1,2010033100),(9,'cc-sa','Creative Commons - ShareAlike','http://creativecommons.org/licenses/by-sa/3.0/',1,2010033100);

--
-- Table structure for table `mdl_local_qrlinks`
--

CREATE TABLE `mdl_local_qrlinks` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `public_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `private_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `public_description` longtext COLLATE utf8_unicode_ci,
  `private_description` longtext COLLATE utf8_unicode_ci,
  `url` longtext COLLATE utf8_unicode_ci NOT NULL,
  `courseid` bigint(10) DEFAULT NULL,
  `cmid` bigint(10) DEFAULT NULL,
  `createdby` bigint(10) NOT NULL,
  `timestamp` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_locaqrli_cre_ix` (`createdby`),
  KEY `mdl_locaqrli_cou_ix` (`courseid`),
  KEY `mdl_locaqrli_cmi_ix` (`cmid`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='QR Links table.';

--
-- Dumping data for table `mdl_local_qrlinks`
--

INSERT INTO `mdl_local_qrlinks` VALUES (1,'Course: Дулаан хүйтэн өнгө мэдэх зурах, нэг ба хоёр өнгөөр дагнааслах','','<p><span style=\"font-size: 14.44px;\">улаан хүйтэн өнгө мэдэх зурах, нэг ба хоёр өнгөөр дагнааслах</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2190',NULL,NULL,235,1556461712),(2,'7а анги','','<p>тест</p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=9671',NULL,NULL,4391,1556676862),(3,'Курс: FLCS23 DIGITAL BOOK','','<p>Dijital book&nbsp;</p><p><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1625',NULL,NULL,8646,1558428975),(4,'Course: Макро эдийн засаг','','<p>11 анги III улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2155',NULL,NULL,197,1557214172),(5,'Course: Улс төр','','<p>11 анги IV улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2089',NULL,NULL,197,1557214378),(6,'Course: Хувь хүн ба эдийн засаг','','<p>8-р анги III улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=949',NULL,NULL,197,1557214567),(7,'Course: Хувь хүн ба эдийн засаг хуулбар 1','','<p>7 анги III улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=868',NULL,NULL,197,1557214649),(8,'Course: Хүний эрх ба хууль-7','','<p>7-р анги IV улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2396',NULL,NULL,197,1557214717),(9,'Course: Монголчууд тусгаар тогтнолынхоо төлөө тэмцсэн нь','','<p>8-р анги түүх III улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2088',NULL,NULL,197,1557214887),(10,'Course: XVIII-XX зууны эхэн үеийн Монголчуудын хөгжил','','<p>8-р анги түүх III-II улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2087',NULL,NULL,197,1557214951),(11,'Course: XVIII-XX зууны эхэн үеийн дэлхий дахин','','<p>8-р анги түүх IV улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2048',NULL,NULL,197,1557215012),(12,'Course: Улс төрийн институт','','<p>11 анги IV улирал Улс төрийн институт</p>','','http://59.153.84.101/moodle/course/view.php?id=2427',NULL,NULL,197,1557215313),(13,'Course: Хүний эрх ба хууль 8-р анги','','<p>8-р анги IV уилрал Хүний эрх ба хууль</p>','','http://59.153.84.101/moodle/course/view.php?id=2397',NULL,NULL,197,1557215543),(14,'Course: Хүний эрх ба хууль 8-р анги','','<p>IV улирал нийгэм</p>','','http://59.153.84.101/moodle/course/view.php?id=2397',NULL,NULL,197,1557215574),(15,'Курс: Туужид юу өгүүлэв?','','<p>6-р ангиТуужид өгүүлэв.</p>','','http://59.153.84.101/moodle/course/view.php?id=2135',NULL,NULL,4533,1557451498),(16,'Course: 9-Б ангийн эцэг эхийн холбоо','','<p><span style=\"font-size: 14.44px;\">9-Б ангийн эцэг эхийн холбоо</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2574',NULL,NULL,250,1558418773),(17,'23-9b-EEX','','<p>9б ангийн эцэг эхийн холбоо<br></p>','','http://59.153.84.101/moodle/local/qrlinks/qrlinks_edit.php',NULL,NULL,255,1558428641),(18,'Editing quiz: 9-Б','','<p>9年生テスト</p>','','http://59.153.84.101/moodle/mod/quiz/edit.php?cmid=2963',NULL,NULL,214,1558430477),(19,'Course: 표한1-6과 한국어를 배워요 Солонгос хэл сурдаг','','<p><span style=\"font-size: 14.44px;\">표한1-6과 한국어를 배워요 Солонгос хэл сурдаг</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2137',NULL,NULL,250,1558437944),(20,'Course: ФИЗИКИЙН ТУРШИЛТЫН ХИЧЭЭЛ','','<p><span style=\"font-size: 14.44px;\">ФИЗИКИЙН ТУРШИЛТЫН ХИЧЭЭЛ</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1602',NULL,NULL,315,1559022443),(21,'Мэдээлэл зүй 6 ','','<p>Бичвэр мэдээлэл боловсруулах<br></p>','','http://59.153.84.101/moodle/course/view.php?id=1140',NULL,NULL,3,1558444260),(22,'СА','','<p>СА</p>','','http://59.153.84.101/moodle/course/view.php?id=2587',NULL,NULL,4216,1558657365),(23,'Course: БСШУСЯ ЛАБОРАТОРИ СУРГУУЛИУД','','<p><span style=\"font-size: 14.44px;\">БСШУСЯ ЛАБОРАТОРИ СУРГУУЛИУД</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1923',NULL,NULL,250,1558450010),(24,'23-СА-ЭМЧ-СХЭМ: ЭРҮҮЛ МЭНД','','<p><span style=\"font-size: 14.44px;\">ЭРҮҮЛ МЭНД</span><br></p>','','http://59.153.84.101/moodle/mod/data/view.php?d=39',NULL,NULL,250,1559531248),(25,'МЭДЭЭЛЭЛ САМБАР','','<p><span style=\"font-size: 14.44px;\">МЭДЭЭЛЭЛ САМБАР</span><br></p>','','http://59.153.84.101/moodle/mod/forum/view.php?id=10157',NULL,NULL,250,1558576534),(26,'9б ангийн эцэг эхийн холбоо','','<p>9б ангийн эцэг эхийн холбоо<br></p>','','http://59.153.84.101/moodle/course/view.php?id=2574',NULL,NULL,255,1558657474),(27,'3. Сургуулийн талаар','','Мүүдл','','http://59.153.84.101/moodle/mod/feedback/view.php?id=7147',NULL,NULL,255,1558658833),(28,'эцэг эхийн сургалтын сэтгэл ханамж','','<p>эцэг эхийн сургалтын сэтгэл ханамж<br></p>','','http://59.153.84.101/moodle/course/view.php?id=1816',NULL,NULL,255,1558659075),(29,'23-MS-MCH-AD-TSH: 2018-2019-IV ДҮН МЭДЭЭ','','<p><span style=\"font-size: 14.44px;\">2018-2019-IV ДҮН МЭДЭЭ</span><br></p>','','http://59.153.84.101/moodle/mod/folder/view.php?id=10185',NULL,NULL,250,1559037493),(30,'S23-8G-YX-TEST-II-8b: 8-Б','','<p>8б ангийн шалгалт&nbsp;</p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=2958',NULL,NULL,214,1559022457),(31,'7-р ангийн Дүрслэх урлагийн МЧС','','<p>7-р анги</p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=10206',NULL,NULL,4395,1559046356),(32,'7-р анги Дүрслэх урлаг МЧС','','<p>ДҮРСЛЭХ УРЛАГ</p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=1',NULL,NULL,4395,1559046989),(33,'Course: 7-р ангийн Дүрслэх урлаг хичээлийн МЧС шалгалт','','<p><span style=\"font-size: 14.44px;\">7-р ангийн Дүрслэх урлаг хичээлийн МЧС шалгалт</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2614',NULL,NULL,250,1559095392),(34,'11-р ангийн Дизайн технологийн шалгалт','','<p>Анги дэвших шалгалт</p>','','http://59.153.84.101/moodle/course/view.php?id',NULL,NULL,202,1559164210),(35,'11 angi','','<p>dt</p>','','http://59.153.84.101/moodle/course/view.php?id=2617',NULL,NULL,202,1559165065),(36,'11-r angi dizain tehnologi','','<p>mchs</p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=10224',NULL,NULL,202,1559165203),(37,'Course: 종합2-2 약속 ','','<p><span style=\"font-size: 14.44px;\">종합2-2 약속&nbsp;</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1079',NULL,NULL,250,1559194945),(38,'23-8G-CX-IV-TEST: 8학년 기말고사 3권1-2과','','<p><span style=\"font-size: 14.44px;\">23-8G-CX-IV-TEST: 8학년 기말고사 3권1-2과</span><br></p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=10251',NULL,NULL,250,1559616786),(39,'Course: 학기말평가 8학년','','<p><span style=\"font-size: 14.44px;\">Course: 학기말평가 8학년</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2630',NULL,NULL,250,1559618217),(40,'Course: 8-р ангийн япон хэлийн шалгалт','','<p><span style=\"font-size: 14.44px;\">8-р ангийн япон хэлийн шалгалт</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2645',NULL,NULL,250,1559721448),(41,'Course: Олон өнгөөр зураг зурах','','<p><span style=\"font-size: 14.44px;\">Олон өнгөөр зураг зурах</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1526',NULL,NULL,229,1559723452),(42,'Курс: Цэнгэл copy 1','','<p>4-р улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2200',NULL,NULL,199,1559730564),(43,'Курс: 6-р анги Дэлхийн эртний улсууд','','<p>ёёёёё</p>','','http://59.153.84.101/moodle/course/view.php?id=1116',NULL,NULL,199,1559731988),(44,'Course: 2018-2019 оны хичээлийн жилийн тайлан','','<p>2018-2019 оны хичээлийн жилийн тайлан<br></p>','','http://59.153.84.101/moodle/course/view.php?id=1285',NULL,NULL,250,1559732588),(45,'Курс: Өгүүллэгийг уншиж ойлгох  хуулбар 1','','<p>Өгүүллэг уншиж ойлгох 8 анги</p><p><br></p>','','http://59.153.84.101/moodle/course/view.php?id=883',NULL,NULL,4392,1559739870),(46,'Курс: Хошин жүжгийн зохиолыг уншиж судлах ','','<p>8 анги хошин жүжиг- Далан худалч</p>','','http://59.153.84.101/moodle/course/view.php?id=2227',NULL,NULL,4392,1559739700),(47,'Курс: Үйл үгийн язгуур үндсийн бичлэгийн онцлогийг мэдэх ','','<p>Үйл үгийн язгуур үндсийн бичлэгийн онцлог&nbsp;</p>','','http://59.153.84.101/moodle/course/view.php?id=2550',NULL,NULL,4392,1559740064),(48,'Курс: ТУУЖИЙГ УНШИЖ ОЙЛГОХ ','','<p>8 анги туужийг уншиж ойлгох&nbsp;</p>','','http://59.153.84.101/moodle/course/view.php?id=889',NULL,NULL,4392,1559740183),(49,'Курс: шалтгаан үрийн холбоо  хамаарлыг гарган бичих 8 цаг','','<p>8 анги учир шалтгааныг тайлбарлан бичих&nbsp;</p>','','http://59.153.84.101/moodle/course/view.php?id=850',NULL,NULL,4392,1559740327),(50,'Course: VI_IV жишиг','','<p>Хими 6 жишиг даалгавар</p>','','http://59.153.84.101/moodle/course/view.php?id=2533',NULL,NULL,4536,1559744716),(51,'Course: Соронзон орон','','Соронзон орон','','http://59.153.84.101/moodle/course/view.php?id=2174',NULL,NULL,315,1559782471),(52,'Course: 3 дугаар улирлын шалгалт','','<p><span style=\"font-size: 14.44px;\">3 дугаар улирлын шалгалт</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1939',NULL,NULL,315,1559782677),(53,'Course: Цахилгаан хэлхээ','','<p><span style=\"font-size: 14.44px;\">Цахилгаан хэлхээ</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1289',NULL,NULL,315,1559782777),(54,'Course: Цахилгаан орон ','','<p><span style=\"font-size: 14.44px;\">Цахилгаан орон</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1287',NULL,NULL,315,1559782854),(55,'Course: Соронзон орон','','Соронзон орон','','http://59.153.84.101/moodle/course/view.php?id=1286',NULL,NULL,315,1559782951),(56,'Механик хэлбэлзэл: Тест','','<p><span style=\"font-size: 14.44px;\">Тест</span><br></p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=8047',NULL,NULL,315,1559783652),(57,'Механик хэлбэлзэл: Тест','','<p><span style=\"font-size: 14.44px;\">Тест</span><br></p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=8047',NULL,NULL,315,1559783653),(58,'Механик хэлбэлзэл: Тест','','<p><span style=\"font-size: 14.44px;\">Тест</span><br></p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=8047',NULL,NULL,315,1559783655),(59,'Course: Хэлбэлзэл долгион','','<p><span style=\"font-size: 14.44px;\">Хэлбэлзэл долгион</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1451',NULL,NULL,315,1559785420),(60,'Course: Цахилгаан бүлэг сэдэв','','<p><span style=\"font-size: 14.44px;\">Цахилгаан бүлэг сэдэв</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1945',NULL,NULL,315,1559784055),(61,'Course: Цахилгаан энерги ба чадал','','<p><span style=\"font-size: 14.44px;\">Цахилгаан энерги ба чадал</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1450',NULL,NULL,315,1559785283),(62,'Course: Дуу тархах, хүлээн авах','','<p><span style=\"font-size: 14.44px;\">Дуу тархах, хүлээн авах</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=1334',NULL,NULL,315,1559785559),(63,'Course: Дууны үүсгүүр','','<p><span style=\"font-size: 14.44px;\">Дууны үүсгүүр</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=859',NULL,NULL,315,1559785686),(64,'Course: Нарны аймаг copy 1','','<p><span style=\"font-size: 14.44px;\">Нарны аймаг&nbsp;</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2517',NULL,NULL,315,1559785792),(65,'Course: Оптик-Гэрэл','','<p><span style=\"font-size: 14.44px;\">Оптик-Гэрэл</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2518',NULL,NULL,315,1559785847),(66,'Course: Ангийн танилцуулга','','<p>10а ангийн танилцуулга</p>','','http://59.153.84.101/moodle/course/view.php?id=1741',NULL,NULL,199,1559798065),(67,'Course: 23S-XX-8G-IV-1 negj    ХЯТАД ХЭЛНИЙ 8-Р АНГИЙН НЭГЖ ','','<p>Course: 23S-XX-8G-IV-1 negj&nbsp; &nbsp; &nbsp; &nbsp; 一个电话<br></p><p>ХЯТАД ХЭЛНИЙ БАГШ Г.ДОЛЖМАА</p>','','http://59.153.84.101/moodle/course/view.php?id=2390',NULL,NULL,4389,1559830193),(68,'Course: 23S-XX-8G-IV-1 negj        一个电话','','<p>Course: 23S-XX-8G-IV-1 negj&nbsp; &nbsp; &nbsp; &nbsp; 一个电话<br></p><p>&nbsp;</p><p>ХЯТАД ХЭЛНИЙ БАГШ Г.ДОЛЖМАА</p>','','http://59.153.84.101/moodle/course/view.php?id=2390',NULL,NULL,4389,1559802155),(69,'Курс: 二十四吃月饼，看月亮','','<p>Курс: 二十四吃月饼，看月亮<br></p><p>Хятад хэлний багш Жан Жы Мэй</p>','','http://59.153.84.101/moodle/course/view.php?id=2629',NULL,NULL,9048,1559803358),(70,'Курс: 二十三广州比北京热得多','','<p>Курс: 二十三广州比北京热得多<br></p><p>&nbsp;Хятад хэлний багш Жан Жы Мэй</p>','','http://59.153.84.101/moodle/course/view.php?id=2628',NULL,NULL,9048,1559804268),(71,'Курс: 二十二课我去过故宫','','<p>Курс: 二十二课我去过故宫<br></p><p>Хятад хэлний багш&nbsp;</p>','','http://59.153.84.101/moodle/course/view.php?id=2627',NULL,NULL,9048,1559804445),(72,'Курс: 二十一课你看广告没有 4-р анги','','<p>Курс: 二十一课你看广告没有 4-р анги<br></p><p>&nbsp;хятад хэлний багш ЖАН ЖЫ МЭЙ</p>','','http://59.153.84.101/moodle/course/view.php?id=2626',NULL,NULL,9048,1559804654),(73,'flcs23: IV улирал','','<p><span style=\"font-size: 14.44px;\">flcs23: IV улирал&nbsp;Jiang Zhi Mei&nbsp;</span><br></p><p><br></p>','','http://59.153.84.101/moodle/course/index.php?categoryid=1308',NULL,NULL,4389,1559810423),(74,'Course: 23S- XX-7G-III-2 negj      美国没有这么多自行车     7-Р АНГИ','','<p><span style=\"font-size: 14.44px;\">Course: 23S- XX-7G-III-2 negj&nbsp; &nbsp; &nbsp; 美国没有这么多自行车&nbsp; &nbsp; &nbsp; &nbsp; 第三十四课</span><br></p><p><span style=\"font-size: 14.44px;\">ХЯТАД ХЭЛНИЙ БАГШ Г.ДОЛЖМАА</span></p>','','http://59.153.84.101/moodle/course/view.php?id=1961',NULL,NULL,4389,1559830298),(75,'Course: 23S-XX-5G-III-negj 3  5-Р АНГИ ХЯТАД ХЭЛ','','<p><span style=\"font-size: 14.44px;\">Course: 23S-XX-5G-III-negj 3&nbsp; 5-Р АНГИ ХЯТАД ХЭЛ</span><br></p><p><span style=\"font-size: 14.44px;\">ХЯТАД ХЭЛНИЙ БАГШ Г.ДОЛЖМАА&nbsp;</span></p>','','http://59.153.84.101/moodle/course/view.php?id=1419',NULL,NULL,4389,1559830558),(76,'Course: UTIL','','<p>test</p>','','http://59.153.84.101/moodle/course/view.php?id=2577',NULL,NULL,250,1565758855),(77,'Course: ESIS ЦАХИМ ГАРЫН АВЛАГА','','<p>ESIS ЦАХИМ ЖУРНАЛ ГАРЫН АВЛАГА<br></p>','','http://59.153.84.101/moodle/course/view.php?id=2784',NULL,NULL,250,1568202444),(78,'8-б ангийн ханз шалгалт','','<p><span style=\"font-size: 14.44px;\">8-б ангийн ханз шалгалт</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2814',NULL,NULL,4385,1568595826),(79,'6 MH','','<p>6 mh</p>','','http://59.153.84.101/moodle/local/qrlinks/manage.php?cid=1792',NULL,NULL,4533,1568613942),(80,'Enrolment methods','','<p>ECO MOVEMENT</p>','','http://59.153.84.101/moodle/enrol/instances.php?id=2828',NULL,NULL,250,1568632826),(81,'HW','','<p>You can do it your homework.</p>','','https://youtu.be/0knOmm3yPrk',NULL,NULL,4377,1568683447),(82,'HW','','<p>You can do it your homework.</p>','','http://59.153.84.101/moodle/local/qrlinks/qrlinks_edit.php',NULL,NULL,4377,1568683537),(83,'Course: 2019~2020 TTSH','','<p>2019-2020 оны хичээлийн жилийн оношлох шалгалтын дүн мэдээ</p>','','http://59.153.84.101/moodle/course/view.php?id=2867',NULL,NULL,250,1569198265),(84,'Course: 표한1-6 한국어를 배워요. Солонгос хэл сурдаг.','','<p><span style=\"font-size: 14.44px;\">Course: 표한1-6 한국어를 배워요. Солонгос хэл сурдаг.</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=825',NULL,NULL,250,1569492367),(85,'Course: 종한3-1 학교생활','','<p>Course: 종한3-1 학교생활(2019-2020 학년도 9학년 1학기 수업)<br></p>','','http://59.153.84.101/moodle/course/view.php?id=811',NULL,NULL,8643,1573554953),(86,'Course: MOODLE LESSON','','<p><span style=\"font-size: 10.83px;\">2019-2020 оны хичээлийн жилийн MOODLE LESSON</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2956',NULL,NULL,250,1572945128),(87,'Course: QUIZ боловсруулах арга','','<p><span style=\"font-size: 10.83px;\">10 төрлийн&nbsp; QUIZ боловсруулах арга</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2957',NULL,NULL,250,1569755664),(88,'flcs23: All courses','','<p>MOODLE сургагч багш бэлтгэх сургалт</p>','','http://59.153.84.101/moodle/course/index.php?categoryid=2452',NULL,NULL,250,1569799019),(89,'Course: Ил захидлын зохиомж','','<p>Ил захидлын зохиомж&nbsp;</p>','','http://59.153.84.101/moodle/course/view.php?id=2019',NULL,NULL,4579,1570514883),(90,'Course: Гацуур модны чимэглэл','','<p>Гацуур модны чимэглэл I-Улирал</p>','','http://59.153.84.101/moodle/course/view.php?id=2026',NULL,NULL,4579,1570514767),(91,'DATABASE APP','','<p><span style=\"font-size: 14.44px;\">ШИНЭ DATABASE APP ТАТАХ</span><br></p>','','http://59.153.84.101/moodle/mod/forum/discuss.php?d=154',NULL,NULL,250,1570618406),(92,'Course: АНГЛИ ХЭЛ СОНГОН','','<p>ENGLISH ELECTIVE COURSE</p>','','http://59.153.84.101/moodle/course/view.php?id=3008',NULL,NULL,4613,1571357380),(93,'Course: 경시대회','','<p>경시대회 시험 문제<br></p>','','http://59.153.84.101/moodle/course/view.php?id=3022',NULL,NULL,250,1572408908),(94,'Course: Хүүхэлдэйн театр','','<p>6-р анги</p>','','http://59.153.84.101/moodle/course/view.php?id=682',NULL,NULL,4579,1572942492),(95,'Course: Гар оёдол','','6-р анги','','http://59.153.84.101/moodle/course/view.php?id=449',NULL,NULL,4579,1572942544),(96,'Course: &quot;Гар оёдол&quot; /Самбарын алчуур,хормогч/','','7-р анги \"Гар оёдол\"','','http://59.153.84.101/moodle/course/view.php?id=3157',NULL,NULL,4579,1572942606),(97,'Course: Алгебрийн илэрхийлэл, тэгшитгэл,тэнцэтгэл биш','','<p><span style=\"font-size: 14.44px;\">Алгебрийн илэрхийлэл, тэгшитгэл,тэнцэтгэл биш</span><br></p>','','http://59.153.84.101/moodle/course/view.php?id=3052',NULL,NULL,4397,1572945685),(98,'Course: Алгебр','','<p>Алгебр<br></p>','','http://59.153.84.101/moodle/course/view.php?id=3091',NULL,NULL,194,1572946033),(99,'Course: kkkk','','<p>kkkk<br></p>','','http://59.153.84.101/moodle/course/view.php?id=3160',NULL,NULL,250,1573006447),(100,'Course: Хүчил ба суурь - Саармагжих үзэгдэл','','<p>Саармагжих үзэгдэл</p>','','http://59.153.84.101/moodle/course/view.php?id=2143',NULL,NULL,4536,1573023856),(101,'Course: day and night','','<p>day and night<br></p>','','http://59.153.84.101/moodle/course/view.php?id=3159',NULL,NULL,9199,1573024132),(102,'Course: Амьд биеийн үржил, хөгжил ','','<p><a href=\"http://59.153.84.101/moodle/local/qrlinks/qrlinks_edit.php?url=http%3A%2F%2F59.153.84.101%2Fmoodle%2Fcourse%2Fview.php%3Fid%3D2103&amp;title=Course%3A%20Амьд%20биеийн%20үржил%2C%20хөгжил%20\">http://59.153.84.101/moodle/local/qrlinks/qrlinks_edit.php?url=http%3A%2F%2F59.153.84.101%2Fmoodle%2Fcourse%2Fview.php%3Fid%3D2103&amp;title=Course%3A%20Амьд%20биеийн%20үржил%2C%20хөгжил%20</a><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2103',NULL,NULL,4525,1573024195),(103,'Course: Амьд биеийн үржил, хөгжил ','','<p><a href=\"http://59.153.84.101/moodle/local/qrlinks/qrlinks_edit.php?url=http%3A%2F%2F59.153.84.101%2Fmoodle%2Fcourse%2Fview.php%3Fid%3D2103&amp;title=Course%3A%20Амьд%20биеийн%20үржил%2C%20хөгжил%20\">http://59.153.84.101/moodle/local/qrlinks/qrlinks_edit.php?url=http%3A%2F%2F59.153.84.101%2Fmoodle%2Fcourse%2Fview.php%3Fid%3D2103&amp;title=Course%3A%20Амьд%20биеийн%20үржил%2C%20хөгжил%20</a><br></p>','','http://59.153.84.101/moodle/course/view.php?id=2103',NULL,NULL,4525,1573024195),(104,'Course: colors','','<p>colors<br></p><p>http://59.153.84.101/moodle/course/view.php?id=3166<br></p>','','http://59.153.84.101/moodle/course/view.php?id=3166',NULL,NULL,9199,1573025112),(105,'Course: clothes and colors','','<p>clothes and colors<br></p><p>link; http://59.153.84.101/moodle/course/view.php?id=3167<br></p><p><a href=\"http://59.153.84.101/moodle/course/view.php?id=3167\">http://59.153.84.101/moodle/course/view.php?id=3167</a><div><p>clothes and colors</p></div><br></p>','','http://59.153.84.101/moodle/course/view.php?id=3167',NULL,NULL,9199,1573026643),(106,'Course: Хооллолт ба хөдөлгөөн ','','<p>Course: Хооллолт ба хөдөлгөөн&nbsp;<br></p>','','http://59.153.84.101/moodle/course/view.php?id=3239',NULL,NULL,9725,1573555135),(107,'Course: DATABASE REPORT','','<p>DATABASE REPORT<br></p>','','http://59.153.84.101/moodle/course/view.php?id=3240',NULL,NULL,250,1573608153),(108,'Томуу вакцин','','<p>Томуу вакцин<br></p>','','http://59.153.84.101/moodle/mod/feedback/view.php?id=13123',NULL,NULL,250,1574066855),(109,'flcs23: All courses','','<p><span style=\"font-size: 14.44px;\">flcs23: All courses</span><br></p>','','http://59.153.84.101/moodle/course/index.php?categoryid=2445',NULL,NULL,250,1575348742),(110,'UCLASS DOWNLOAD FOLDER','','<p><span style=\"font-size: 14.44px;\">UCLASS DOWNLOAD FOLDER</span><br></p>','','http://59.153.84.101/moodle/mod/folder/view.php?id=13540',NULL,NULL,250,1575508270),(111,'8-Р АНГИ 1-р хагас жил эмэгтэй','','<p>Мэдлэг чадварын сорилын тест</p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=13563',NULL,NULL,4579,1576029385),(112,'2019-2020학년도 한국어 중간고사(10학년) ','','<p><span style=\"font-size: 10.83px;\">2019-2020학년도 한국어 중간고사(10학년)&nbsp;</span><br></p>','','http://59.153.84.101/moodle/mod/quiz/edit.php?cmid=13554&amp;cat=21158%2C78489',NULL,NULL,250,1575697829),(113,'23-TEX-8G-II-I: Мэдлэг чадварын сорилын шалгалт 1-р хагас жил эрэгтэй','','<p>мэдлэг чадварын сорилын тест</p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=13566',NULL,NULL,203,1576029825),(114,'Солонгос хэл 4-г','','<p>Солонгос хэл 4-г<br></p>','','http://59.153.84.101/moodle/mod/quiz/view.php?id=13729',NULL,NULL,250,1576218616),(115,'Мэдээлэл зүй -7 Н.Оюунгэрэл','','<p>Мэдээлэл зүй 7&nbsp; Баримт бичиг боловсруулах технологи нэгж хичээлийн боловсруулалт&nbsp; Мэдээлэл зүйн багш Н.Оюунгэрэл</p>','','http://59.153.84.101/moodle/course/view.php?id=534',NULL,NULL,255,1576720895),(116,'FLCS23 VIDEO LESSON','','<p><span style=\"font-size: 14.44px;\">FLCS23 VIDEO LESSON</span><br></p>','','http://59.153.84.101/moodle/mod/bigbluebuttonbn/view.php?id=13986&amp;forceview=1',NULL,NULL,250,1576895926);

--
-- Table structure for table `mdl_lock_db`
--

CREATE TABLE `mdl_lock_db` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `resourcekey` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `expires` bigint(10) DEFAULT NULL,
  `owner` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_lockdb_res_uix` (`resourcekey`),
  KEY `mdl_lockdb_exp_ix` (`expires`),
  KEY `mdl_lockdb_own_ix` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores active and inactive lock types for db locking method.';

--
-- Dumping data for table `mdl_lock_db`
--


--
-- Table structure for table `mdl_log`
--

CREATE TABLE `mdl_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `time` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `ip` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `course` bigint(10) NOT NULL DEFAULT '0',
  `module` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cmid` bigint(10) NOT NULL DEFAULT '0',
  `action` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `info` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_log_coumodact_ix` (`course`,`module`,`action`),
  KEY `mdl_log_tim_ix` (`time`),
  KEY `mdl_log_act_ix` (`action`),
  KEY `mdl_log_usecou_ix` (`userid`,`course`),
  KEY `mdl_log_cmi_ix` (`cmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Every action is logged as far as possible';

--
-- Dumping data for table `mdl_log`
--


--
-- Table structure for table `mdl_log_display`
--

CREATE TABLE `mdl_log_display` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `module` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `action` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mtable` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `field` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `component` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_logdisp_modact_uix` (`module`,`action`)
) ENGINE=InnoDB AUTO_INCREMENT=303 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='For a particular module/action, specifies a moodle table/fie';

--
-- Dumping data for table `mdl_log_display`
--

INSERT INTO `mdl_log_display` VALUES (1,'course','user report','user','CONCAT(firstname, \' \', lastname)','moodle'),(2,'course','view','course','fullname','moodle'),(3,'course','view section','course_sections','name','moodle'),(4,'course','update','course','fullname','moodle'),(5,'course','hide','course','fullname','moodle'),(6,'course','show','course','fullname','moodle'),(7,'course','move','course','fullname','moodle'),(8,'course','enrol','course','fullname','moodle'),(9,'course','unenrol','course','fullname','moodle'),(10,'course','report log','course','fullname','moodle'),(11,'course','report live','course','fullname','moodle'),(12,'course','report outline','course','fullname','moodle'),(13,'course','report participation','course','fullname','moodle'),(14,'course','report stats','course','fullname','moodle'),(15,'category','add','course_categories','name','moodle'),(16,'category','hide','course_categories','name','moodle'),(17,'category','move','course_categories','name','moodle'),(18,'category','show','course_categories','name','moodle'),(19,'category','update','course_categories','name','moodle'),(20,'message','write','user','CONCAT(firstname, \' \', lastname)','moodle'),(21,'message','read','user','CONCAT(firstname, \' \', lastname)','moodle'),(22,'message','add contact','user','CONCAT(firstname, \' \', lastname)','moodle'),(23,'message','remove contact','user','CONCAT(firstname, \' \', lastname)','moodle'),(24,'message','block contact','user','CONCAT(firstname, \' \', lastname)','moodle'),(25,'message','unblock contact','user','CONCAT(firstname, \' \', lastname)','moodle'),(26,'group','view','groups','name','moodle'),(27,'tag','update','tag','name','moodle'),(28,'tag','flag','tag','name','moodle'),(29,'user','view','user','CONCAT(firstname, \' \', lastname)','moodle'),(58,'book','add','book','name','mod_book'),(59,'book','update','book','name','mod_book'),(60,'book','view','book','name','mod_book'),(61,'book','add chapter','book_chapters','title','mod_book'),(62,'book','update chapter','book_chapters','title','mod_book'),(63,'book','view chapter','book_chapters','title','mod_book'),(64,'chat','view','chat','name','mod_chat'),(65,'chat','add','chat','name','mod_chat'),(66,'chat','update','chat','name','mod_chat'),(67,'chat','report','chat','name','mod_chat'),(68,'chat','talk','chat','name','mod_chat'),(69,'choice','view','choice','name','mod_choice'),(70,'choice','update','choice','name','mod_choice'),(71,'choice','add','choice','name','mod_choice'),(72,'choice','report','choice','name','mod_choice'),(73,'choice','choose','choice','name','mod_choice'),(74,'choice','choose again','choice','name','mod_choice'),(75,'data','view','data','name','mod_data'),(76,'data','add','data','name','mod_data'),(77,'data','update','data','name','mod_data'),(78,'data','record delete','data','name','mod_data'),(79,'data','fields add','data_fields','name','mod_data'),(80,'data','fields update','data_fields','name','mod_data'),(81,'data','templates saved','data','name','mod_data'),(82,'data','templates def','data','name','mod_data'),(83,'feedback','startcomplete','feedback','name','mod_feedback'),(84,'feedback','submit','feedback','name','mod_feedback'),(85,'feedback','delete','feedback','name','mod_feedback'),(86,'feedback','view','feedback','name','mod_feedback'),(87,'feedback','view all','course','shortname','mod_feedback'),(88,'folder','view','folder','name','mod_folder'),(89,'folder','view all','folder','name','mod_folder'),(90,'folder','update','folder','name','mod_folder'),(91,'folder','add','folder','name','mod_folder'),(92,'forum','add','forum','name','mod_forum'),(93,'forum','update','forum','name','mod_forum'),(94,'forum','add discussion','forum_discussions','name','mod_forum'),(95,'forum','add post','forum_posts','subject','mod_forum'),(96,'forum','update post','forum_posts','subject','mod_forum'),(97,'forum','user report','user','CONCAT(firstname, \' \', lastname)','mod_forum'),(98,'forum','move discussion','forum_discussions','name','mod_forum'),(99,'forum','view subscribers','forum','name','mod_forum'),(100,'forum','view discussion','forum_discussions','name','mod_forum'),(101,'forum','view forum','forum','name','mod_forum'),(102,'forum','subscribe','forum','name','mod_forum'),(103,'forum','unsubscribe','forum','name','mod_forum'),(104,'forum','pin discussion','forum_discussions','name','mod_forum'),(105,'forum','unpin discussion','forum_discussions','name','mod_forum'),(106,'glossary','add','glossary','name','mod_glossary'),(107,'glossary','update','glossary','name','mod_glossary'),(108,'glossary','view','glossary','name','mod_glossary'),(109,'glossary','view all','glossary','name','mod_glossary'),(110,'glossary','add entry','glossary','name','mod_glossary'),(111,'glossary','update entry','glossary','name','mod_glossary'),(112,'glossary','add category','glossary','name','mod_glossary'),(113,'glossary','update category','glossary','name','mod_glossary'),(114,'glossary','delete category','glossary','name','mod_glossary'),(115,'glossary','approve entry','glossary','name','mod_glossary'),(116,'glossary','disapprove entry','glossary','name','mod_glossary'),(117,'glossary','view entry','glossary_entries','concept','mod_glossary'),(118,'imscp','view','imscp','name','mod_imscp'),(119,'imscp','view all','imscp','name','mod_imscp'),(120,'imscp','update','imscp','name','mod_imscp'),(121,'imscp','add','imscp','name','mod_imscp'),(122,'label','add','label','name','mod_label'),(123,'label','update','label','name','mod_label'),(124,'lesson','start','lesson','name','mod_lesson'),(125,'lesson','end','lesson','name','mod_lesson'),(126,'lesson','view','lesson_pages','title','mod_lesson'),(127,'lti','view','lti','name','mod_lti'),(128,'lti','launch','lti','name','mod_lti'),(129,'lti','view all','lti','name','mod_lti'),(130,'page','view','page','name','mod_page'),(131,'page','view all','page','name','mod_page'),(132,'page','update','page','name','mod_page'),(133,'page','add','page','name','mod_page'),(134,'quiz','add','quiz','name','mod_quiz'),(135,'quiz','update','quiz','name','mod_quiz'),(136,'quiz','view','quiz','name','mod_quiz'),(137,'quiz','report','quiz','name','mod_quiz'),(138,'quiz','attempt','quiz','name','mod_quiz'),(139,'quiz','submit','quiz','name','mod_quiz'),(140,'quiz','review','quiz','name','mod_quiz'),(141,'quiz','editquestions','quiz','name','mod_quiz'),(142,'quiz','preview','quiz','name','mod_quiz'),(143,'quiz','start attempt','quiz','name','mod_quiz'),(144,'quiz','close attempt','quiz','name','mod_quiz'),(145,'quiz','continue attempt','quiz','name','mod_quiz'),(146,'quiz','edit override','quiz','name','mod_quiz'),(147,'quiz','delete override','quiz','name','mod_quiz'),(148,'quiz','view summary','quiz','name','mod_quiz'),(149,'resource','view','resource','name','mod_resource'),(150,'resource','view all','resource','name','mod_resource'),(151,'resource','update','resource','name','mod_resource'),(152,'resource','add','resource','name','mod_resource'),(157,'survey','add','survey','name','mod_survey'),(158,'survey','update','survey','name','mod_survey'),(159,'survey','download','survey','name','mod_survey'),(160,'survey','view form','survey','name','mod_survey'),(161,'survey','view graph','survey','name','mod_survey'),(162,'survey','view report','survey','name','mod_survey'),(163,'survey','submit','survey','name','mod_survey'),(164,'url','view','url','name','mod_url'),(165,'url','view all','url','name','mod_url'),(166,'url','update','url','name','mod_url'),(167,'url','add','url','name','mod_url'),(168,'workshop','add','workshop','name','mod_workshop'),(169,'workshop','update','workshop','name','mod_workshop'),(170,'workshop','view','workshop','name','mod_workshop'),(171,'workshop','view all','workshop','name','mod_workshop'),(172,'workshop','add submission','workshop_submissions','title','mod_workshop'),(173,'workshop','update submission','workshop_submissions','title','mod_workshop'),(174,'workshop','view submission','workshop_submissions','title','mod_workshop'),(175,'workshop','add assessment','workshop_submissions','title','mod_workshop'),(176,'workshop','update assessment','workshop_submissions','title','mod_workshop'),(177,'workshop','add example','workshop_submissions','title','mod_workshop'),(178,'workshop','update example','workshop_submissions','title','mod_workshop'),(179,'workshop','view example','workshop_submissions','title','mod_workshop'),(180,'workshop','add reference assessment','workshop_submissions','title','mod_workshop'),(181,'workshop','update reference assessment','workshop_submissions','title','mod_workshop'),(182,'workshop','add example assessment','workshop_submissions','title','mod_workshop'),(183,'workshop','update example assessment','workshop_submissions','title','mod_workshop'),(184,'workshop','update aggregate grades','workshop','name','mod_workshop'),(185,'workshop','update clear aggregated grades','workshop','name','mod_workshop'),(186,'workshop','update clear assessments','workshop','name','mod_workshop'),(187,'book','exportimscp','book','name','booktool_exportimscp'),(188,'book','print','book','name','booktool_print'),(189,'book','print chapter','book_chapters','title','booktool_print'),(193,'bigbluebuttonbn','add','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(194,'bigbluebuttonbn','update','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(195,'bigbluebuttonbn','view','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(196,'bigbluebuttonbn','view all','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(197,'bigbluebuttonbn','create','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(198,'bigbluebuttonbn','end','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(199,'bigbluebuttonbn','join','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(200,'bigbluebuttonbn','left','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(201,'bigbluebuttonbn','publish','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(202,'bigbluebuttonbn','unpublish','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(203,'bigbluebuttonbn','delete','bigbluebuttonbn','name','mod_bigbluebuttonbn'),(204,'hotpot','add','hotpot','name','mod_hotpot'),(205,'hotpot','update','hotpot','name','mod_hotpot'),(206,'hotpot','view','hotpot','name','mod_hotpot'),(207,'hotpot','attempt','hotpot','name','mod_hotpot'),(208,'hotpot','submit','hotpot','name','mod_hotpot'),(209,'hotpot','report','hotpot','name','mod_hotpot'),(210,'hotpot','review','hotpot','name','mod_hotpot'),(215,'customcert','view','customcert','name','mod_customcert'),(216,'customcert','add','customcert','name','mod_customcert'),(217,'customcert','update','customcert','name','mod_customcert'),(218,'customcert','received','customcert','name','mod_customcert'),(259,'mootyper','add','mootyper','name','mod_mootyper'),(260,'mootyper','update','mootyper','name','mod_mootyper'),(261,'mootyper','view','mootyper','name','mod_mootyper'),(262,'mootyper','view all','mootyper','name','mod_mootyper'),(263,'geogebra','add','geogebra','name','mod_geogebra'),(264,'geogebra','view','geogebra','name','mod_geogebra'),(265,'geogebra','update','geogebra','name','mod_geogebra'),(266,'helixmedia','view','helixmedia','name','mod_helixmedia'),(267,'helixmedia','launch','helixmedia','name','mod_helixmedia'),(268,'helixmedia','editlaunch','helixmedia','name','mod_helixmedia'),(269,'helixmedia','editlaunchnew','helixmedia','name','mod_helixmedia'),(270,'helixmedia','view all','helixmedia','name','mod_helixmedia'),(271,'quizgame','add','quizgame','name','mod_quizgame'),(272,'quizgame','update','quizgame','name','mod_quizgame'),(273,'quizgame','view','quizgame','name','mod_quizgame'),(274,'quizgame','view all','quizgame','name','mod_quizgame'),(280,'assign','add','assign','name','mod_assign'),(281,'assign','delete mod','assign','name','mod_assign'),(282,'assign','download all submissions','assign','name','mod_assign'),(283,'assign','grade submission','assign','name','mod_assign'),(284,'assign','lock submission','assign','name','mod_assign'),(285,'assign','reveal identities','assign','name','mod_assign'),(286,'assign','revert submission to draft','assign','name','mod_assign'),(287,'assign','set marking workflow state','assign','name','mod_assign'),(288,'assign','submission statement accepted','assign','name','mod_assign'),(289,'assign','submit','assign','name','mod_assign'),(290,'assign','submit for grading','assign','name','mod_assign'),(291,'assign','unlock submission','assign','name','mod_assign'),(292,'assign','update','assign','name','mod_assign'),(293,'assign','upload','assign','name','mod_assign'),(294,'assign','view','assign','name','mod_assign'),(295,'assign','view all','course','fullname','mod_assign'),(296,'assign','view confirm submit assignment form','assign','name','mod_assign'),(297,'assign','view grading form','assign','name','mod_assign'),(298,'assign','view submission','assign','name','mod_assign'),(299,'assign','view submission grading table','assign','name','mod_assign'),(300,'assign','view submit assignment form','assign','name','mod_assign'),(301,'assign','view feedback','assign','name','mod_assign'),(302,'assign','view batch set marking workflow state','assign','name','mod_assign');

--
-- Table structure for table `mdl_log_queries`
--

CREATE TABLE `mdl_log_queries` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `qtype` mediumint(5) NOT NULL,
  `sqltext` longtext COLLATE utf8_unicode_ci NOT NULL,
  `sqlparams` longtext COLLATE utf8_unicode_ci,
  `error` mediumint(5) NOT NULL DEFAULT '0',
  `info` longtext COLLATE utf8_unicode_ci,
  `backtrace` longtext COLLATE utf8_unicode_ci,
  `exectime` decimal(10,5) NOT NULL,
  `timelogged` bigint(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Logged database queries.';

--
-- Dumping data for table `mdl_log_queries`
--


--
-- Table structure for table `mdl_logstore_standard_log`
--

CREATE TABLE `mdl_logstore_standard_log` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `eventname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `component` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `action` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `target` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `objecttable` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `objectid` bigint(10) DEFAULT NULL,
  `crud` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `edulevel` tinyint(1) NOT NULL,
  `contextid` bigint(10) NOT NULL,
  `contextlevel` bigint(10) NOT NULL,
  `contextinstanceid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `courseid` bigint(10) DEFAULT NULL,
  `relateduserid` bigint(10) DEFAULT NULL,
  `anonymous` tinyint(1) NOT NULL DEFAULT '0',
  `other` longtext COLLATE utf8_unicode_ci,
  `timecreated` bigint(10) NOT NULL,
  `origin` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `realuserid` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_logsstanlog_tim_ix` (`timecreated`),
  KEY `mdl_logsstanlog_couanotim_ix` (`courseid`,`anonymous`,`timecreated`),
  KEY `mdl_logsstanlog_useconconcr_ix` (`userid`,`contextlevel`,`contextinstanceid`,`crud`,`edulevel`,`timecreated`),
  KEY `mdl_logsstanlog_con_ix` (`contextid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Standard log table';

--
-- Dumping data for table `mdl_logstore_standard_log`
--


--
-- Table structure for table `mdl_lti_access_tokens`
--

CREATE TABLE `mdl_lti_access_tokens` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `typeid` bigint(10) NOT NULL,
  `scope` longtext COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `validuntil` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `lastaccess` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_ltiaccetoke_tok_uix` (`token`),
  KEY `mdl_ltiaccetoke_typ_ix` (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mdl_lti_access_tokens`
--


--
-- Table structure for table `mdl_lti_submission`
--

CREATE TABLE `mdl_lti_submission` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `ltiid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `datesubmitted` bigint(10) NOT NULL,
  `dateupdated` bigint(10) NOT NULL,
  `gradepercent` decimal(10,5) NOT NULL,
  `originalgrade` decimal(10,5) NOT NULL,
  `launchid` bigint(10) NOT NULL,
  `state` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltisubm_lti_ix` (`ltiid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Keeps track of individual submissions for LTI activities.';

--
-- Dumping data for table `mdl_lti_submission`
--


--
-- Table structure for table `mdl_lti_tool_proxies`
--

CREATE TABLE `mdl_lti_tool_proxies` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Tool Provider',
  `regurl` longtext COLLATE utf8_unicode_ci,
  `state` tinyint(2) NOT NULL DEFAULT '1',
  `guid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `secret` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vendorcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `capabilityoffered` longtext COLLATE utf8_unicode_ci NOT NULL,
  `serviceoffered` longtext COLLATE utf8_unicode_ci NOT NULL,
  `toolproxy` longtext COLLATE utf8_unicode_ci,
  `createdby` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_ltitoolprox_gui_uix` (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='LTI tool proxy registrations';

--
-- Dumping data for table `mdl_lti_tool_proxies`
--


--
-- Table structure for table `mdl_lti_tool_settings`
--

CREATE TABLE `mdl_lti_tool_settings` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `toolproxyid` bigint(10) NOT NULL,
  `typeid` bigint(10) DEFAULT NULL,
  `course` bigint(10) DEFAULT NULL,
  `coursemoduleid` bigint(10) DEFAULT NULL,
  `settings` longtext COLLATE utf8_unicode_ci NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltitoolsett_too_ix` (`toolproxyid`),
  KEY `mdl_ltitoolsett_cou_ix` (`course`),
  KEY `mdl_ltitoolsett_cou2_ix` (`coursemoduleid`),
  KEY `mdl_ltitoolsett_typ_ix` (`typeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='LTI tool setting values';

--
-- Dumping data for table `mdl_lti_tool_settings`
--


--
-- Table structure for table `mdl_lti_types`
--

CREATE TABLE `mdl_lti_types` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'basiclti Activity',
  `baseurl` longtext COLLATE utf8_unicode_ci NOT NULL,
  `tooldomain` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `state` tinyint(2) NOT NULL DEFAULT '2',
  `course` bigint(10) NOT NULL,
  `coursevisible` tinyint(1) NOT NULL DEFAULT '0',
  `ltiversion` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `clientid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `toolproxyid` bigint(10) DEFAULT NULL,
  `enabledcapability` longtext COLLATE utf8_unicode_ci,
  `parameter` longtext COLLATE utf8_unicode_ci,
  `icon` longtext COLLATE utf8_unicode_ci,
  `secureicon` longtext COLLATE utf8_unicode_ci,
  `createdby` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_ltitype_cli_uix` (`clientid`),
  KEY `mdl_ltitype_cou_ix` (`course`),
  KEY `mdl_ltitype_too_ix` (`tooldomain`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Basic LTI pre-configured activities';

--
-- Dumping data for table `mdl_lti_types`
--

INSERT INTO `mdl_lti_types` VALUES (2,'BBB','https://demo.bigbluebutton.org/gl/kwo-phn-jkt','demo.bigbluebutton.org',1,1923,1,'LTI-1p0',NULL,NULL,NULL,NULL,'','',250,1553752342,1553752342,''),(3,'KOHA DIGITAL LIBRARY_MOODLE','http://59.153.84.101','59.153.84.101',1,1623,1,'LTI-1p0',NULL,NULL,NULL,NULL,'','',250,1553868673,1553869271,''),(4,'KOHA DIGITAL LIBRARY','http://59.153.84.100','59.153.84.100',1,1623,1,'LTI-1p0',NULL,NULL,NULL,NULL,'','',250,1553869434,1553869434,''),(5,'EXCEL','https://docs.google.com/spreadsheets/d/1J8YXaAfNEFb7wnLj9ZME0DXIQbVe1UCwZkQKGLwMA1g/edit?usp=sharing','docs.google.com',1,2564,1,'LTI-1p0',NULL,NULL,NULL,NULL,'','',250,1558358130,1558358130,'2018-2019 оны 1-р хагас жилийн мэдлэг чадвар, сорил');

--
-- Table structure for table `mdl_lti_types_config`
--

CREATE TABLE `mdl_lti_types_config` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `typeid` bigint(10) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltitypeconf_typ_ix` (`typeid`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Basic LTI types configuration';

--
-- Dumping data for table `mdl_lti_types_config`
--



--
-- Table structure for table `mdl_ltiservice_gradebookservices`
--

CREATE TABLE `mdl_ltiservice_gradebookservices` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `gradeitemid` bigint(10) NOT NULL,
  `courseid` bigint(10) NOT NULL,
  `toolproxyid` bigint(10) DEFAULT NULL,
  `typeid` bigint(10) DEFAULT NULL,
  `baseurl` longtext COLLATE utf8_unicode_ci,
  `ltilinkid` bigint(10) DEFAULT NULL,
  `tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_ltisgrad_lti_ix` (`ltilinkid`),
  KEY `mdl_ltisgrad_gracou_ix` (`gradeitemid`,`courseid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='This file records the grade items created by the LTI Gradebo';

--
-- Dumping data for table `mdl_ltiservice_gradebookservices`
--



