-- MySQL dump 10.13  Distrib 5.7.28, for Linux (x86_64)
--
-- Host: localhost    Database: moodle_DB
-- ------------------------------------------------------
-- Server version	5.7.28-0ubuntu0.18.04.4

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `mdl_oauth2_access_token`
--

DROP TABLE IF EXISTS `mdl_oauth2_access_token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_oauth2_access_token` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `token` longtext COLLATE utf8_unicode_ci NOT NULL,
  `expires` bigint(10) NOT NULL,
  `scope` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_oautaccetoke_iss_uix` (`issuerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_oauth2_access_token`
--

LOCK TABLES `mdl_oauth2_access_token` WRITE;
/*!40000 ALTER TABLE `mdl_oauth2_access_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_oauth2_access_token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_oauth2_endpoint`
--

DROP TABLE IF EXISTS `mdl_oauth2_endpoint`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_oauth2_endpoint` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url` longtext COLLATE utf8_unicode_ci NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_oautendp_iss_ix` (`issuerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_oauth2_endpoint`
--

LOCK TABLES `mdl_oauth2_endpoint` WRITE;
/*!40000 ALTER TABLE `mdl_oauth2_endpoint` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_oauth2_endpoint` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_oauth2_issuer`
--

DROP TABLE IF EXISTS `mdl_oauth2_issuer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_oauth2_issuer` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `image` longtext COLLATE utf8_unicode_ci NOT NULL,
  `baseurl` longtext COLLATE utf8_unicode_ci NOT NULL,
  `clientid` longtext COLLATE utf8_unicode_ci NOT NULL,
  `clientsecret` longtext COLLATE utf8_unicode_ci NOT NULL,
  `loginscopes` longtext COLLATE utf8_unicode_ci NOT NULL,
  `loginscopesoffline` longtext COLLATE utf8_unicode_ci NOT NULL,
  `loginparams` longtext COLLATE utf8_unicode_ci NOT NULL,
  `loginparamsoffline` longtext COLLATE utf8_unicode_ci NOT NULL,
  `alloweddomains` longtext COLLATE utf8_unicode_ci NOT NULL,
  `scopessupported` longtext COLLATE utf8_unicode_ci,
  `showonloginpage` tinyint(2) NOT NULL DEFAULT '1',
  `basicauth` tinyint(2) NOT NULL DEFAULT '0',
  `enabled` tinyint(2) NOT NULL DEFAULT '1',
  `sortorder` bigint(10) NOT NULL,
  `requireconfirmation` tinyint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPRESSED;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_oauth2_issuer`
--

LOCK TABLES `mdl_oauth2_issuer` WRITE;
/*!40000 ALTER TABLE `mdl_oauth2_issuer` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_oauth2_issuer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_oauth2_system_account`
--

DROP TABLE IF EXISTS `mdl_oauth2_system_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_oauth2_system_account` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timecreated` bigint(10) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `refreshtoken` longtext COLLATE utf8_unicode_ci NOT NULL,
  `grantedscopes` longtext COLLATE utf8_unicode_ci NOT NULL,
  `email` longtext COLLATE utf8_unicode_ci,
  `username` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_oautsystacco_iss_uix` (`issuerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_oauth2_system_account`
--

LOCK TABLES `mdl_oauth2_system_account` WRITE;
/*!40000 ALTER TABLE `mdl_oauth2_system_account` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_oauth2_system_account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_oauth2_user_field_mapping`
--

DROP TABLE IF EXISTS `mdl_oauth2_user_field_mapping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_oauth2_user_field_mapping` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `timemodified` bigint(10) NOT NULL,
  `timecreated` bigint(10) NOT NULL,
  `usermodified` bigint(10) NOT NULL,
  `issuerid` bigint(10) NOT NULL,
  `externalfield` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `internalfield` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_oautuserfielmapp_issin_uix` (`issuerid`,`internalfield`),
  KEY `mdl_oautuserfielmapp_iss_ix` (`issuerid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_oauth2_user_field_mapping`
--

LOCK TABLES `mdl_oauth2_user_field_mapping` WRITE;
/*!40000 ALTER TABLE `mdl_oauth2_user_field_mapping` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_oauth2_user_field_mapping` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz`
--

DROP TABLE IF EXISTS `mdl_offlinequiz`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz` (
  `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) NOT NULL DEFAULT '0',
  `pdfintro` longtext COLLATE utf8_unicode_ci,
  `timeopen` bigint(10) NOT NULL DEFAULT '0',
  `timeclose` bigint(10) NOT NULL DEFAULT '0',
  `time` bigint(10) NOT NULL DEFAULT '0',
  `grade` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `numgroups` bigint(10) NOT NULL DEFAULT '2',
  `decimalpoints` smallint(4) NOT NULL DEFAULT '2',
  `review` bigint(10) NOT NULL DEFAULT '0',
  `questionsperpage` bigint(10) NOT NULL DEFAULT '0',
  `docscreated` smallint(4) NOT NULL DEFAULT '0',
  `shufflequestions` smallint(4) NOT NULL DEFAULT '0',
  `shuffleanswers` smallint(4) NOT NULL DEFAULT '0',
  `printstudycodefield` smallint(4) NOT NULL DEFAULT '1',
  `papergray` bigint(10) NOT NULL DEFAULT '650',
  `fontsize` smallint(4) NOT NULL DEFAULT '10',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `showquestioninfo` smallint(4) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `fileformat` smallint(4) NOT NULL DEFAULT '0',
  `showgrades` smallint(4) NOT NULL DEFAULT '0',
  `showtutorial` smallint(4) NOT NULL DEFAULT '0',
  `id_digits` smallint(4) DEFAULT NULL,
  `disableimgnewlines` smallint(4) NOT NULL DEFAULT '0',
  `algorithmversion` bigint(10) NOT NULL DEFAULT '0',
  `experimentalevaluation` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_offl_cou_ix` (`course`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Main information about each offlinequiz';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz`
--

LOCK TABLES `mdl_offlinequiz` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz` DISABLE KEYS */;
INSERT INTO `mdl_offlinequiz` VALUES (1,580,'test','',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,1,0,1,1,670,10,1546702107,0,1546702107,0,0,0,7,0,0,0),(2,754,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1546937684,0,1546937684,0,0,0,NULL,0,0,0),(3,1043,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1546937684,0,1546937684,0,0,0,NULL,0,0,0),(4,754,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1546937684,0,1546937684,0,0,0,NULL,0,0,0),(5,754,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1546937684,0,1546937684,0,0,0,NULL,0,0,0),(6,754,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1546937684,0,1546937684,0,0,0,NULL,0,0,0),(7,1244,'DIE TIEREN','<p>WIE VIEL TIEREN SIND HIER ?</p><p><br></p>',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1548067478,0,1548067539,0,0,0,NULL,0,0,0),(11,1320,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1550048084,0,1550048084,0,0,0,NULL,0,0,0),(12,1320,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1550048084,0,1550048084,0,0,0,NULL,0,0,0),(13,1320,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1550048084,0,1550048084,0,0,0,NULL,0,0,0),(14,1320,'Some/ any','<a href=\"https://youtu.be/nMuDAlPvk8U\">Some/ any </a><br>',0,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1550048084,0,1550048084,0,0,0,NULL,0,0,0),(16,1313,'Offline Quiz','<p></p><p><span tabindex=\"0\" lang=\"mn\">Энэ модуль нь олон сонголттой асуултуудаас бүрдэх оффисын тестүүдийг төлөвлөх боломжийг багш олгодог.<br> </span><span tabindex=\"0\" lang=\"mn\">Эдгээр асуултуудыг Моодл асуулт асуулгад хадгалж, курсууд болон курсуудын хооронд дахин ашиглаж болно.<br> </span><span tabindex=\"0\" lang=\"mn\">Офлайн шалгалтуудыг PDF-, DOCX- эсвэл LaTeX-файлуудаар татаж авч болно.<br> </span><span tabindex=\"0\" lang=\"mn\">Оюутнууд нь хариултыг хуудасны хуудсан дээр тэмдэглэж байна. Маягтын хуудсыг сканердаж, хариултуудыг системд оруулж ирдэг.</span></p><br><p></p>',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,1,0,1,1,670,10,1550202539,0,1550202614,0,0,0,7,0,0,0),(17,1290,'표한1-1-OMR','',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,1,0,1,1,670,10,1550472681,0,1550472681,0,0,0,7,0,0,0),(19,2072,'11 анги  эх хэлний шалгалт','<p>11 ангийн монгол хэл, монгол бичиг, уран зохиолын хичээлийн нэгдсэн агуулгаар 3-р улирлын хөтөлбөрийн сэдвийн хүрээнд авах шалгалтын сэдэв&nbsp;</p>',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',1554465600,1554469200,1554343200,100.00000,2,2,522240,0,0,0,0,1,670,10,1554346801,0,1554347020,0,0,0,NULL,0,0,0),(20,2617,'11-р ангийн Дизайн технологи Шалгалт_OfflineQuiz','<p><span style=\"font-size: 14.44px;\">11-р ангийн Дизайн технологи Шалгалт_OfflineQuiz</span><br></p>',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,3,2,522240,0,1,1,1,1,670,10,1559277418,2,1559282663,0,1,0,7,0,0,1),(21,2619,'Offline_Test','',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1559284071,0,1559284071,0,0,0,NULL,0,0,0),(22,2620,'Offline_Test_Korea','',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1559284432,0,1559284432,0,0,0,NULL,0,0,0),(23,3001,'10 grade','',1,'<b>How do I mark correctly?</b><br>This answer form will be scanned automatically. Please do not fold or spot. Use a black or blue pen to mark the fields. If you want to correct a marking, completely fill the box with color. This field will be interpreted like an empty box.<br>',0,0,0,100.00000,1,2,522240,0,0,0,1,1,670,10,1571735949,0,1571735949,0,0,0,NULL,0,0,0);
/*!40000 ALTER TABLE `mdl_offlinequiz` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_attempts`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_attempts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_attempts` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `uniqueid` bigint(10) NOT NULL DEFAULT '0',
  `offlinequiz` bigint(10) NOT NULL DEFAULT '0',
  `groupid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `attempt` mediumint(6) NOT NULL DEFAULT '0',
  `sumgrades` double NOT NULL DEFAULT '0',
  `timestart` bigint(10) NOT NULL DEFAULT '0',
  `timefinish` bigint(10) NOT NULL DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `layout` longtext COLLATE utf8_unicode_ci NOT NULL,
  `sheet` smallint(3) NOT NULL DEFAULT '0',
  `preview` smallint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_offlatte_uni_uix` (`uniqueid`),
  KEY `mdl_offlatte_use_ix` (`userid`),
  KEY `mdl_offlatte_off_ix` (`offlinequiz`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores various attempts on a offlinequiz';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_attempts`
--

LOCK TABLES `mdl_offlinequiz_attempts` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_attempts` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_attempts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_choices`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_choices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_choices` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scannedpageid` bigint(10) NOT NULL,
  `slotnumber` smallint(4) NOT NULL,
  `choicenumber` smallint(4) NOT NULL,
  `value` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_offlchoi_sca_ix` (`scannedpageid`),
  KEY `mdl_offlchoi_slo_ix` (`slotnumber`),
  KEY `mdl_offlchoi_cho_ix` (`choicenumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The choices made by users on scanned pages.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_choices`
--

LOCK TABLES `mdl_offlinequiz_choices` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_choices` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_choices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_group_questions`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_group_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_group_questions` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL,
  `offlinegroupid` bigint(10) NOT NULL,
  `questionid` bigint(10) NOT NULL,
  `position` smallint(4) NOT NULL DEFAULT '1',
  `page` smallint(4) DEFAULT NULL,
  `slot` smallint(4) DEFAULT NULL,
  `maxmark` decimal(12,7) NOT NULL DEFAULT '1.0000000',
  PRIMARY KEY (`id`),
  KEY `mdl_offlgrouques_off_ix` (`offlinequizid`)
) ENGINE=InnoDB AUTO_INCREMENT=419 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The questions of an offlinequiz group';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_group_questions`
--

LOCK TABLES `mdl_offlinequiz_group_questions` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_group_questions` DISABLE KEYS */;
INSERT INTO `mdl_offlinequiz_group_questions` VALUES (1,1,1,11607,1,1,1,1.0000000),(2,8,8,27323,1,1,1,1.0000000),(3,8,8,27376,1,1,2,10.0000000),(4,8,8,27327,1,1,3,5.0000000),(5,8,8,27341,1,1,4,2.0000000),(6,9,9,27404,1,1,1,1.0000000),(7,9,9,27323,1,1,2,1.0000000),(8,9,9,27376,1,1,3,10.0000000),(9,9,9,27327,1,1,4,5.0000000),(10,9,9,27336,1,1,5,1.0000000),(11,9,9,27341,1,1,6,2.0000000),(12,9,9,27328,1,1,7,2.0000000),(13,9,9,27330,1,1,8,5.0000000),(14,9,9,27331,1,1,9,2.0000000),(15,9,9,27332,1,1,10,2.0000000),(16,9,9,27337,1,1,11,1.0000000),(17,9,9,27357,1,1,12,1.0000000),(18,9,9,27377,1,1,13,1.0000000),(19,9,9,27355,1,1,14,1.0000000),(20,9,9,27356,1,1,15,1.0000000),(21,9,9,27384,1,1,16,1.0000000),(22,9,9,27338,1,1,17,1.0000000),(23,9,9,27378,1,1,18,1.0000000),(24,9,9,27342,1,1,19,1.0000000),(25,9,9,27361,1,1,20,1.0000000),(26,9,9,27350,1,1,21,1.0000000),(27,9,9,27393,1,1,22,1.0000000),(28,9,9,27353,1,1,23,1.0000000),(29,9,9,27395,1,1,24,3.0000000),(30,9,9,27354,1,1,25,1.0000000),(31,9,9,27359,1,1,26,1.0000000),(32,9,9,27386,1,1,27,1.0000000),(33,9,9,27358,1,1,28,1.0000000),(34,9,9,27385,1,1,29,1.0000000),(35,9,9,27360,1,1,30,1.0000000),(36,9,9,27363,1,1,31,1.0000000),(37,9,9,27362,1,1,32,1.0000000),(38,9,9,27352,1,1,33,1.0000000),(39,9,9,27383,1,1,34,1.0000000),(40,9,9,27364,1,1,35,1.0000000),(41,9,9,27365,1,1,36,1.0000000),(42,9,9,27366,1,1,37,1.0000000),(43,9,9,27372,1,1,38,1.0000000),(44,9,9,27387,1,1,39,1.0000000),(45,9,9,27373,1,1,40,1.0000000),(46,9,9,27371,1,1,41,1.0000000),(47,9,9,27340,1,1,42,5.0000000),(48,9,9,27379,1,1,43,5.0000000),(49,9,9,27335,1,1,44,1.0000000),(50,9,9,27374,1,1,45,1.0000000),(51,9,9,27367,1,1,46,1.0000000),(52,9,9,27368,1,1,47,1.0000000),(53,9,9,27369,1,1,48,1.0000000),(54,9,9,27370,1,1,49,1.0000000),(55,9,9,27397,1,1,50,1.0000000),(56,9,9,27400,1,1,51,1.0000000),(57,9,9,27401,1,1,52,1.0000000),(58,9,9,27339,1,1,53,1.0000000),(59,9,9,27333,1,1,54,1.0000000),(60,9,9,27334,1,1,55,1.0000000),(61,9,10,27404,1,1,1,1.0000000),(62,9,10,27323,1,1,2,1.0000000),(63,9,10,27376,1,1,3,10.0000000),(64,9,10,27327,1,1,4,5.0000000),(65,9,10,27336,1,1,5,1.0000000),(66,9,10,27341,1,1,6,2.0000000),(67,9,10,27328,1,1,7,2.0000000),(68,9,10,27330,1,1,8,5.0000000),(69,9,10,27331,1,1,9,2.0000000),(70,9,10,27332,1,1,10,2.0000000),(71,9,10,27337,1,1,11,1.0000000),(72,9,10,27357,1,1,12,1.0000000),(73,9,10,27377,1,1,13,1.0000000),(74,9,10,27355,1,1,14,1.0000000),(75,9,10,27356,1,1,15,1.0000000),(76,9,10,27384,1,1,16,1.0000000),(77,9,10,27338,1,1,17,1.0000000),(78,9,10,27378,1,1,18,1.0000000),(79,9,10,27342,1,1,19,1.0000000),(80,9,10,27361,1,1,20,1.0000000),(81,9,10,27350,1,1,21,1.0000000),(82,9,10,27393,1,1,22,1.0000000),(83,9,10,27353,1,1,23,1.0000000),(84,9,10,27395,1,1,24,3.0000000),(85,9,10,27354,1,1,25,1.0000000),(86,9,10,27359,1,1,26,1.0000000),(87,9,10,27386,1,1,27,1.0000000),(88,9,10,27358,1,1,28,1.0000000),(89,9,10,27385,1,1,29,1.0000000),(90,9,10,27360,1,1,30,1.0000000),(91,9,10,27363,1,1,31,1.0000000),(92,9,10,27362,1,1,32,1.0000000),(93,9,10,27352,1,1,33,1.0000000),(94,9,10,27383,1,1,34,1.0000000),(95,9,10,27364,1,1,35,1.0000000),(96,9,10,27365,1,1,36,1.0000000),(97,9,10,27366,1,1,37,1.0000000),(98,9,10,27372,1,1,38,1.0000000),(99,9,10,27387,1,1,39,1.0000000),(100,9,10,27373,1,1,40,1.0000000),(101,9,10,27371,1,1,41,1.0000000),(102,9,10,27340,1,1,42,5.0000000),(103,9,10,27379,1,1,43,5.0000000),(104,9,10,27335,1,1,44,1.0000000),(105,9,10,27374,1,1,45,1.0000000),(106,9,10,27367,1,1,46,1.0000000),(107,9,10,27368,1,1,47,1.0000000),(108,9,10,27369,1,1,48,1.0000000),(109,9,10,27370,1,1,49,1.0000000),(110,9,10,27397,1,1,50,1.0000000),(111,9,10,27400,1,1,51,1.0000000),(112,9,10,27401,1,1,52,1.0000000),(113,9,10,27339,1,1,53,1.0000000),(114,9,10,27333,1,1,54,1.0000000),(115,9,10,27334,1,1,55,1.0000000),(116,9,11,27404,1,1,1,1.0000000),(117,9,11,27323,1,1,2,1.0000000),(118,9,11,27376,1,1,3,10.0000000),(119,9,11,27327,1,1,4,5.0000000),(120,9,11,27336,1,1,5,1.0000000),(121,9,11,27341,1,1,6,2.0000000),(122,9,11,27328,1,1,7,2.0000000),(123,9,11,27330,1,1,8,5.0000000),(124,9,11,27331,1,1,9,2.0000000),(125,9,11,27332,1,1,10,2.0000000),(126,9,11,27337,1,1,11,1.0000000),(127,9,11,27357,1,1,12,1.0000000),(128,9,11,27377,1,1,13,1.0000000),(129,9,11,27355,1,1,14,1.0000000),(130,9,11,27356,1,1,15,1.0000000),(131,9,11,27384,1,1,16,1.0000000),(132,9,11,27338,1,1,17,1.0000000),(133,9,11,27378,1,1,18,1.0000000),(134,9,11,27342,1,1,19,1.0000000),(135,9,11,27361,1,1,20,1.0000000),(136,9,11,27350,1,1,21,1.0000000),(137,9,11,27393,1,1,22,1.0000000),(138,9,11,27353,1,1,23,1.0000000),(139,9,11,27395,1,1,24,3.0000000),(140,9,11,27354,1,1,25,1.0000000),(141,9,11,27359,1,1,26,1.0000000),(142,9,11,27386,1,1,27,1.0000000),(143,9,11,27358,1,1,28,1.0000000),(144,9,11,27385,1,1,29,1.0000000),(145,9,11,27360,1,1,30,1.0000000),(146,9,11,27363,1,1,31,1.0000000),(147,9,11,27362,1,1,32,1.0000000),(148,9,11,27352,1,1,33,1.0000000),(149,9,11,27383,1,1,34,1.0000000),(150,9,11,27364,1,1,35,1.0000000),(151,9,11,27365,1,1,36,1.0000000),(152,9,11,27366,1,1,37,1.0000000),(153,9,11,27372,1,1,38,1.0000000),(154,9,11,27387,1,1,39,1.0000000),(155,9,11,27373,1,1,40,1.0000000),(156,9,11,27371,1,1,41,1.0000000),(157,9,11,27340,1,1,42,5.0000000),(158,9,11,27379,1,1,43,5.0000000),(159,9,11,27335,1,1,44,1.0000000),(160,9,11,27374,1,1,45,1.0000000),(161,9,11,27367,1,1,46,1.0000000),(162,9,11,27368,1,1,47,1.0000000),(163,9,11,27369,1,1,48,1.0000000),(164,9,11,27370,1,1,49,1.0000000),(165,9,11,27397,1,1,50,1.0000000),(166,9,11,27400,1,1,51,1.0000000),(167,9,11,27401,1,1,52,1.0000000),(168,9,11,27339,1,1,53,1.0000000),(169,9,11,27333,1,1,54,1.0000000),(170,9,11,27334,1,1,55,1.0000000),(171,9,12,27404,1,1,1,1.0000000),(172,9,12,27323,1,1,2,1.0000000),(173,9,12,27376,1,1,3,10.0000000),(174,9,12,27327,1,1,4,5.0000000),(175,9,12,27336,1,1,5,1.0000000),(176,9,12,27341,1,1,6,2.0000000),(177,9,12,27328,1,1,7,2.0000000),(178,9,12,27330,1,1,8,5.0000000),(179,9,12,27331,1,1,9,2.0000000),(180,9,12,27332,1,1,10,2.0000000),(181,9,12,27337,1,1,11,1.0000000),(182,9,12,27357,1,1,12,1.0000000),(183,9,12,27377,1,1,13,1.0000000),(184,9,12,27355,1,1,14,1.0000000),(185,9,12,27356,1,1,15,1.0000000),(186,9,12,27384,1,1,16,1.0000000),(187,9,12,27338,1,1,17,1.0000000),(188,9,12,27378,1,1,18,1.0000000),(189,9,12,27342,1,1,19,1.0000000),(190,9,12,27361,1,1,20,1.0000000),(191,9,12,27350,1,1,21,1.0000000),(192,9,12,27393,1,1,22,1.0000000),(193,9,12,27353,1,1,23,1.0000000),(194,9,12,27395,1,1,24,3.0000000),(195,9,12,27354,1,1,25,1.0000000),(196,9,12,27359,1,1,26,1.0000000),(197,9,12,27386,1,1,27,1.0000000),(198,9,12,27358,1,1,28,1.0000000),(199,9,12,27385,1,1,29,1.0000000),(200,9,12,27360,1,1,30,1.0000000),(201,9,12,27363,1,1,31,1.0000000),(202,9,12,27362,1,1,32,1.0000000),(203,9,12,27352,1,1,33,1.0000000),(204,9,12,27383,1,1,34,1.0000000),(205,9,12,27364,1,1,35,1.0000000),(206,9,12,27365,1,1,36,1.0000000),(207,9,12,27366,1,1,37,1.0000000),(208,9,12,27372,1,1,38,1.0000000),(209,9,12,27387,1,1,39,1.0000000),(210,9,12,27373,1,1,40,1.0000000),(211,9,12,27371,1,1,41,1.0000000),(212,9,12,27340,1,1,42,5.0000000),(213,9,12,27379,1,1,43,5.0000000),(214,9,12,27335,1,1,44,1.0000000),(215,9,12,27374,1,1,45,1.0000000),(216,9,12,27367,1,1,46,1.0000000),(217,9,12,27368,1,1,47,1.0000000),(218,9,12,27369,1,1,48,1.0000000),(219,9,12,27370,1,1,49,1.0000000),(220,9,12,27397,1,1,50,1.0000000),(221,9,12,27400,1,1,51,1.0000000),(222,9,12,27401,1,1,52,1.0000000),(223,9,12,27339,1,1,53,1.0000000),(224,9,12,27333,1,1,54,1.0000000),(225,9,12,27334,1,1,55,1.0000000),(226,10,13,27404,1,1,1,1.0000000),(227,10,13,27376,1,1,2,10.0000000),(228,10,13,27327,1,1,3,5.0000000),(229,10,13,27341,1,1,4,2.0000000),(230,10,13,27328,1,1,5,2.0000000),(231,10,13,27330,1,1,6,5.0000000),(232,10,13,27331,1,1,7,2.0000000),(233,10,13,27332,1,1,8,2.0000000),(234,10,13,27337,1,1,9,1.0000000),(235,10,13,27357,1,1,10,1.0000000),(236,10,13,27377,1,1,11,1.0000000),(237,10,13,27355,1,1,12,1.0000000),(238,10,13,27356,1,1,13,1.0000000),(239,10,13,27338,1,1,14,1.0000000),(240,10,13,27342,1,1,15,1.0000000),(241,10,13,27350,1,1,16,1.0000000),(242,10,13,27393,1,1,17,1.0000000),(243,10,13,27353,1,1,18,1.0000000),(244,10,13,27395,1,1,19,3.0000000),(245,10,13,27354,1,1,20,1.0000000),(246,10,13,27359,1,1,21,1.0000000),(247,10,13,27358,1,1,22,1.0000000),(248,10,13,27352,1,1,23,1.0000000),(249,10,13,27383,1,1,24,1.0000000),(250,10,13,27364,1,1,25,1.0000000),(251,10,13,27365,1,1,26,1.0000000),(252,10,13,27340,1,1,27,5.0000000),(253,10,13,27379,1,1,28,5.0000000),(254,10,13,27335,1,1,29,1.0000000),(255,10,13,27367,1,1,30,1.0000000),(256,10,13,27368,1,1,31,1.0000000),(257,10,13,27369,1,1,32,1.0000000),(258,10,13,27397,1,1,33,1.0000000),(259,10,13,27400,1,1,34,1.0000000),(260,10,13,27401,1,1,35,1.0000000),(261,10,14,27404,1,1,1,1.0000000),(262,10,14,27323,1,1,2,1.0000000),(263,10,14,27327,1,1,3,5.0000000),(264,10,14,27341,1,1,4,2.0000000),(265,10,14,27328,1,1,5,2.0000000),(266,10,14,27330,1,1,6,5.0000000),(267,10,14,27331,1,1,7,2.0000000),(268,10,14,27332,1,1,8,2.0000000),(269,10,14,27337,1,1,9,1.0000000),(270,10,14,27357,1,1,10,1.0000000),(271,10,14,27377,1,1,11,1.0000000),(272,10,14,27355,1,1,12,1.0000000),(273,10,14,27338,1,1,13,1.0000000),(274,10,14,27342,1,1,14,1.0000000),(275,10,14,27350,1,1,15,1.0000000),(276,10,14,27393,1,1,16,1.0000000),(277,10,14,27353,1,1,17,1.0000000),(278,10,14,27395,1,1,18,3.0000000),(279,10,14,27354,1,1,19,1.0000000),(280,10,14,27359,1,1,20,1.0000000),(281,10,14,27358,1,1,21,1.0000000),(282,10,14,27352,1,1,22,1.0000000),(283,10,14,27383,1,1,23,1.0000000),(284,10,14,27364,1,1,24,1.0000000),(285,10,14,27365,1,1,25,1.0000000),(286,10,14,27340,1,1,26,5.0000000),(287,10,14,27379,1,1,27,5.0000000),(288,10,14,27335,1,1,28,1.0000000),(289,10,14,27367,1,1,29,1.0000000),(290,10,14,27368,1,1,30,1.0000000),(291,10,14,27369,1,1,31,1.0000000),(292,10,14,27397,1,1,32,1.0000000),(293,10,14,27400,1,1,33,1.0000000),(294,10,14,27401,1,1,34,1.0000000),(295,10,15,27404,1,1,1,1.0000000),(296,10,15,27323,1,1,2,1.0000000),(297,10,15,27376,1,1,3,10.0000000),(298,10,15,27327,1,1,4,5.0000000),(299,10,15,27341,1,1,5,2.0000000),(300,10,15,27328,1,1,6,2.0000000),(301,10,15,27330,1,1,7,5.0000000),(302,10,15,27331,1,1,8,2.0000000),(303,10,15,27332,1,1,9,2.0000000),(304,10,15,27337,1,1,10,1.0000000),(305,10,15,27357,1,1,11,1.0000000),(306,10,15,27377,1,1,12,1.0000000),(307,10,15,27355,1,1,13,1.0000000),(308,10,15,27356,1,1,14,1.0000000),(309,10,15,27338,1,1,15,1.0000000),(310,10,15,27342,1,1,16,1.0000000),(311,10,15,27350,1,1,17,1.0000000),(312,10,15,27393,1,1,18,1.0000000),(313,10,15,27353,1,1,19,1.0000000),(314,10,15,27395,1,1,20,3.0000000),(315,10,15,27354,1,1,21,1.0000000),(316,10,15,27359,1,1,22,1.0000000),(317,10,15,27358,1,1,23,1.0000000),(318,10,15,27352,1,1,24,1.0000000),(319,10,15,27383,1,1,25,1.0000000),(320,10,15,27364,1,1,26,1.0000000),(321,10,15,27365,1,1,27,1.0000000),(322,10,15,27340,1,1,28,5.0000000),(323,10,15,27379,1,1,29,5.0000000),(324,10,15,27335,1,1,30,1.0000000),(325,10,15,27367,1,1,31,1.0000000),(326,10,15,27368,1,1,32,1.0000000),(327,10,15,27369,1,1,33,1.0000000),(328,10,15,27397,1,1,34,1.0000000),(329,10,15,27400,1,1,35,1.0000000),(330,10,15,27401,1,1,36,1.0000000),(331,10,16,27404,1,1,1,1.0000000),(332,10,16,27323,1,1,2,1.0000000),(333,10,16,27376,1,1,3,10.0000000),(334,10,16,27327,1,1,4,5.0000000),(335,10,16,27341,1,1,5,2.0000000),(336,10,16,27328,1,1,6,2.0000000),(337,10,16,27330,1,1,7,5.0000000),(338,10,16,27331,1,1,8,2.0000000),(339,10,16,27332,1,1,9,2.0000000),(340,10,16,27337,1,1,10,1.0000000),(341,10,16,27357,1,1,11,1.0000000),(342,10,16,27377,1,1,12,1.0000000),(343,10,16,27355,1,1,13,1.0000000),(344,10,16,27356,1,1,14,1.0000000),(345,10,16,27338,1,1,15,1.0000000),(346,10,16,27342,1,1,16,1.0000000),(347,10,16,27350,1,1,17,1.0000000),(348,10,16,27393,1,1,18,1.0000000),(349,10,16,27353,1,1,19,1.0000000),(350,10,16,27395,1,1,20,3.0000000),(351,10,16,27354,1,1,21,1.0000000),(352,10,16,27359,1,1,22,1.0000000),(353,10,16,27358,1,1,23,1.0000000),(354,10,16,27352,1,1,24,1.0000000),(355,10,16,27383,1,1,25,1.0000000),(356,10,16,27364,1,1,26,1.0000000),(357,10,16,27365,1,1,27,1.0000000),(358,10,16,27340,1,1,28,5.0000000),(359,10,16,27379,1,1,29,5.0000000),(360,10,16,27335,1,1,30,1.0000000),(361,10,16,27367,1,1,31,1.0000000),(362,10,16,27368,1,1,32,1.0000000),(363,10,16,27369,1,1,33,1.0000000),(364,10,16,27397,1,1,34,1.0000000),(365,10,16,27400,1,1,35,1.0000000),(366,10,16,27401,1,1,36,1.0000000),(367,15,21,28264,1,1,1,1.0000000),(368,15,21,28265,1,1,2,1.0000000),(369,17,26,28668,1,1,1,10.0000000),(370,17,26,28750,1,1,2,5.0000000),(371,17,26,28751,1,1,3,5.0000000),(372,17,26,28753,1,1,4,5.0000000),(373,16,25,28264,1,1,1,1.0000000),(374,16,25,28265,1,1,2,1.0000000),(375,16,25,34051,1,1,3,1.0000000),(376,16,25,34052,1,1,4,1.0000000),(377,20,30,35712,1,1,1,1.0000000),(378,20,30,35713,1,1,2,1.0000000),(379,20,30,35714,1,1,3,2.0000000),(380,20,30,35716,1,1,4,2.0000000),(381,20,30,35718,1,1,5,1.0000000),(382,20,30,35719,1,1,6,2.0000000),(383,20,30,35724,1,1,7,1.0000000),(384,20,30,35727,1,1,8,1.0000000),(385,20,30,35729,1,1,9,2.0000000),(386,20,30,35730,1,1,10,1.0000000),(387,20,30,35734,1,1,11,4.0000000),(388,20,30,35739,1,1,12,2.0000000),(389,20,30,35741,1,1,13,1.0000000),(390,20,30,35711,1,1,14,1.0000000),(391,20,31,35712,1,1,1,1.0000000),(392,20,31,35713,1,1,2,1.0000000),(393,20,31,35714,1,1,3,2.0000000),(394,20,31,35716,1,1,4,2.0000000),(395,20,31,35718,1,1,5,1.0000000),(396,20,31,35719,1,1,6,2.0000000),(397,20,31,35724,1,1,7,1.0000000),(398,20,31,35727,1,1,8,1.0000000),(399,20,31,35729,1,1,9,2.0000000),(400,20,31,35730,1,1,10,1.0000000),(401,20,31,35734,1,1,11,4.0000000),(402,20,31,35739,1,1,12,2.0000000),(403,20,31,35741,1,1,13,1.0000000),(404,20,31,35711,1,1,14,1.0000000),(405,20,32,35712,1,1,1,1.0000000),(406,20,32,35713,1,1,2,1.0000000),(407,20,32,35714,1,1,3,2.0000000),(408,20,32,35716,1,1,4,2.0000000),(409,20,32,35718,1,1,5,1.0000000),(410,20,32,35719,1,1,6,2.0000000),(411,20,32,35724,1,1,7,1.0000000),(412,20,32,35727,1,1,8,1.0000000),(413,20,32,35729,1,1,9,2.0000000),(414,20,32,35730,1,1,10,1.0000000),(415,20,32,35734,1,1,11,4.0000000),(416,20,32,35739,1,1,12,2.0000000),(417,20,32,35741,1,1,13,1.0000000),(418,20,32,35711,1,1,14,1.0000000);
/*!40000 ALTER TABLE `mdl_offlinequiz_group_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_groups`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_groups` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL,
  `groupnumber` smallint(4) NOT NULL DEFAULT '0',
  `sumgrades` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `numberofpages` smallint(4) NOT NULL DEFAULT '0',
  `templateusageid` bigint(10) NOT NULL DEFAULT '0',
  `questionfilename` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `answerfilename` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `correctionfilename` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_offlgrou_off_ix` (`offlinequizid`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Groups in offline quizzes';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_groups`
--

LOCK TABLES `mdl_offlinequiz_groups` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_groups` DISABLE KEYS */;
INSERT INTO `mdl_offlinequiz_groups` VALUES (1,1,1,1.00000,1,14631,'question_form_A_20190105_233204.pdf','answer_form_A_20190105_233204.pdf','correction_form_A_20190105_233204.pdf'),(2,2,1,0.00000,1,0,NULL,NULL,NULL),(3,3,1,0.00000,1,0,NULL,NULL,NULL),(4,4,1,0.00000,1,0,NULL,NULL,NULL),(5,5,1,0.00000,1,0,NULL,NULL,NULL),(6,6,1,0.00000,1,0,NULL,NULL,NULL),(7,7,1,0.00000,1,0,NULL,NULL,NULL),(17,11,1,0.00000,1,0,NULL,NULL,NULL),(18,12,1,0.00000,1,0,NULL,NULL,NULL),(19,13,1,0.00000,1,0,NULL,NULL,NULL),(20,14,1,0.00000,1,0,NULL,NULL,NULL),(25,16,1,4.00000,1,32817,'question_form_A_20190413_033056.pdf','answer_form_A_20190413_033056.pdf','correction_form_A_20190413_033056.pdf'),(26,17,1,25.00000,1,20565,'question_form_A_20190218_151642.pdf','answer_form_A_20190218_151642.pdf','correction_form_A_20190218_151642.pdf'),(28,19,1,0.00000,1,0,NULL,NULL,NULL),(29,19,2,0.00000,1,0,NULL,NULL,NULL),(30,20,1,22.00000,1,39967,'question_form_A_20190531_124017.pdf','answer_form_A_20190531_124020.pdf','correction_form_A_20190531_124022.pdf'),(31,20,2,22.00000,1,39968,'question_form_B_20190531_124019.pdf','answer_form_B_20190531_124021.pdf','correction_form_B_20190531_124024.pdf'),(32,20,3,22.00000,1,39969,'question_form_C_20190531_124020.pdf','answer_form_C_20190531_124021.pdf','correction_form_C_20190531_124025.pdf'),(33,21,1,0.00000,1,0,NULL,NULL,NULL),(34,22,1,0.00000,1,0,NULL,NULL,NULL),(35,23,1,0.00000,1,0,NULL,NULL,NULL);
/*!40000 ALTER TABLE `mdl_offlinequiz_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_hotspots`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_hotspots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_hotspots` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scannedpageid` bigint(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `x` decimal(10,2) NOT NULL,
  `y` decimal(10,2) NOT NULL,
  `blank` tinyint(1) DEFAULT NULL,
  `time` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_offlhots_sca_ix` (`scannedpageid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table to store the hotspots of scanned_pages for retrieval i';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_hotspots`
--

LOCK TABLES `mdl_offlinequiz_hotspots` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_hotspots` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_hotspots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_p_choices`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_p_choices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_p_choices` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scannedppageid` bigint(10) NOT NULL,
  `userid` bigint(10) DEFAULT NULL,
  `value` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The table contains the choices made on scanned lists of part';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_p_choices`
--

LOCK TABLES `mdl_offlinequiz_p_choices` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_p_choices` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_p_choices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_p_lists`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_p_lists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_p_lists` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `listnumber` smallint(4) NOT NULL DEFAULT '0',
  `filename` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_offlplist_off_ix` (`offlinequizid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Lists for participants';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_p_lists`
--

LOCK TABLES `mdl_offlinequiz_p_lists` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_p_lists` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_p_lists` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_page_corners`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_page_corners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_page_corners` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `scannedpageid` bigint(10) NOT NULL,
  `x` smallint(4) NOT NULL DEFAULT '0',
  `y` smallint(4) NOT NULL DEFAULT '0',
  `position` smallint(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_offlpagecorn_sca_ix` (`scannedpageid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contains the four corners for every page in offlinequiz_scan';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_page_corners`
--

LOCK TABLES `mdl_offlinequiz_page_corners` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_page_corners` DISABLE KEYS */;
INSERT INTO `mdl_offlinequiz_page_corners` VALUES (1,1,66,69,0),(2,1,785,73,1),(3,1,65,1145,2),(4,1,785,1147,3);
/*!40000 ALTER TABLE `mdl_offlinequiz_page_corners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_participants`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_participants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_participants` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `listid` bigint(10) NOT NULL DEFAULT '0',
  `userid` bigint(10) NOT NULL DEFAULT '0',
  `checked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_offlpart_lis_ix` (`listid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Checklist for the participants of an offline quiz';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_participants`
--

LOCK TABLES `mdl_offlinequiz_participants` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_participants` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_participants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_q_response_stats`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_q_response_stats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_q_response_stats` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizstatisticsid` bigint(10) NOT NULL,
  `questionid` bigint(10) NOT NULL,
  `subqid` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `aid` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `response` longtext COLLATE utf8_unicode_ci,
  `rcount` bigint(10) DEFAULT NULL,
  `credit` decimal(15,5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table to cache analysis results for question responses.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_q_response_stats`
--

LOCK TABLES `mdl_offlinequiz_q_response_stats` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_q_response_stats` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_q_response_stats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_q_statistics`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_q_statistics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_q_statistics` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizstatisticsid` bigint(10) NOT NULL,
  `questionid` bigint(10) NOT NULL,
  `slot` bigint(10) DEFAULT NULL,
  `subquestion` smallint(4) NOT NULL,
  `s` bigint(10) NOT NULL DEFAULT '0',
  `effectiveweight` decimal(15,5) DEFAULT NULL,
  `negcovar` tinyint(2) NOT NULL DEFAULT '0',
  `discriminationindex` decimal(15,5) DEFAULT NULL,
  `discriminativeefficiency` decimal(15,5) DEFAULT NULL,
  `sd` decimal(15,10) DEFAULT NULL,
  `facility` decimal(15,10) DEFAULT NULL,
  `subquestions` longtext COLLATE utf8_unicode_ci,
  `maxmark` decimal(12,7) DEFAULT NULL,
  `positions` longtext COLLATE utf8_unicode_ci,
  `randomguessscore` decimal(12,7) DEFAULT NULL,
  `correct` smallint(4) DEFAULT '0',
  `partially` smallint(4) DEFAULT '0',
  `wrong` smallint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Table to cache analysis results for the individual questions';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_q_statistics`
--

LOCK TABLES `mdl_offlinequiz_q_statistics` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_q_statistics` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_q_statistics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_queue`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_queue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_queue` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL DEFAULT '0',
  `importuserid` bigint(10) NOT NULL DEFAULT '0',
  `timecreated` bigint(10) NOT NULL DEFAULT '0',
  `timestart` bigint(10) NOT NULL DEFAULT '0',
  `timefinish` bigint(10) NOT NULL DEFAULT '0',
  `status` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='list of cron jobs';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_queue`
--

LOCK TABLES `mdl_offlinequiz_queue` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_queue` DISABLE KEYS */;
INSERT INTO `mdl_offlinequiz_queue` VALUES (1,8,250,1548998717,1556141883,1556141943,'finished'),(2,20,3,1559283733,1559284211,1559284243,'finished');
/*!40000 ALTER TABLE `mdl_offlinequiz_queue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_queue_data`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_queue_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_queue_data` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `queueid` bigint(10) NOT NULL DEFAULT '0',
  `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `error` varchar(1333) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(1333) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='import data for cron jobs';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_queue_data`
--

LOCK TABLES `mdl_offlinequiz_queue_data` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_queue_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_queue_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_reports`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_reports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_reports` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `displayorder` bigint(10) NOT NULL,
  `lastcron` bigint(10) NOT NULL DEFAULT '0',
  `cron` bigint(10) NOT NULL DEFAULT '0',
  `capability` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_offlrepo_nam_uix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Lists all the installed offlinequiz reports and their displa';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_reports`
--

LOCK TABLES `mdl_offlinequiz_reports` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_reports` DISABLE KEYS */;
INSERT INTO `mdl_offlinequiz_reports` VALUES (1,'overview',10000,0,0,NULL),(2,'rimport',9000,0,0,NULL),(3,'regrade',6000,0,0,NULL),(4,'statistics',6000,0,0,'offlinequiz/statistics:view');
/*!40000 ALTER TABLE `mdl_offlinequiz_reports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_results`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_results`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_results` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL,
  `offlinegroupid` bigint(10) NOT NULL,
  `userid` bigint(10) NOT NULL,
  `sumgrades` decimal(10,5) DEFAULT NULL,
  `usageid` bigint(10) NOT NULL,
  `teacherid` bigint(10) NOT NULL,
  `attendant` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timestart` bigint(10) NOT NULL DEFAULT '0',
  `timefinish` bigint(10) DEFAULT '0',
  `timemodified` bigint(10) NOT NULL DEFAULT '0',
  `preview` smallint(3) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mdl_offlresu_use_ix` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='(Incomplete) results of students for an offlinequiz. Will be';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_results`
--

LOCK TABLES `mdl_offlinequiz_results` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_results` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_results` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_scanned_p_pages`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_scanned_p_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_scanned_p_pages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL,
  `listnumber` smallint(4) DEFAULT NULL,
  `filename` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time` bigint(10) NOT NULL DEFAULT '0',
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `error` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores information about scanned participants-list-pages.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_scanned_p_pages`
--

LOCK TABLES `mdl_offlinequiz_scanned_p_pages` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_scanned_p_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_scanned_p_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_scanned_pages`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_scanned_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_scanned_pages` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL,
  `resultid` bigint(10) DEFAULT NULL,
  `filename` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `warningfilename` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `groupnumber` smallint(4) DEFAULT NULL,
  `userkey` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pagenumber` bigint(20) DEFAULT NULL,
  `time` bigint(10) NOT NULL DEFAULT '0',
  `status` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `error` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_offlscanpage_off_ix` (`offlinequizid`),
  KEY `mdl_offlscanpage_res_ix` (`resultid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='The pages of answer documents scanned by a teacher.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_scanned_pages`
--

LOCK TABLES `mdl_offlinequiz_scanned_pages` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_scanned_pages` DISABLE KEYS */;
INSERT INTO `mdl_offlinequiz_scanned_pages` VALUES (1,20,NULL,'Moodle.tif-0.png',NULL,1,'1XX0333',1,1559284216,'error','nonexistinguser',NULL);
/*!40000 ALTER TABLE `mdl_offlinequiz_scanned_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_offlinequiz_statistics`
--

DROP TABLE IF EXISTS `mdl_offlinequiz_statistics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_offlinequiz_statistics` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `offlinequizid` bigint(10) NOT NULL,
  `offlinegroupid` bigint(10) DEFAULT NULL,
  `groupid` bigint(10) NOT NULL,
  `allattempts` smallint(4) NOT NULL,
  `timemodified` bigint(10) NOT NULL,
  `firstattemptscount` bigint(10) NOT NULL,
  `allattemptscount` bigint(10) NOT NULL,
  `firstattemptsavg` decimal(15,5) DEFAULT NULL,
  `median` decimal(15,5) DEFAULT NULL,
  `allattemptsavg` decimal(15,5) DEFAULT NULL,
  `standarddeviation` decimal(15,5) DEFAULT NULL,
  `skewness` decimal(15,10) DEFAULT NULL,
  `kurtosis` decimal(15,5) DEFAULT NULL,
  `cic` decimal(15,10) DEFAULT NULL,
  `errorratio` decimal(15,10) DEFAULT NULL,
  `standarderror` decimal(15,10) DEFAULT NULL,
  `bestgrade` decimal(15,5) DEFAULT NULL,
  `worstgrade` decimal(15,5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='table to cache results from analysis done in statistics repo';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_offlinequiz_statistics`
--

LOCK TABLES `mdl_offlinequiz_statistics` WRITE;
/*!40000 ALTER TABLE `mdl_offlinequiz_statistics` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_offlinequiz_statistics` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-12-23 20:41:15
