-- 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_question_numerical`
--

DROP TABLE IF EXISTS `mdl_question_numerical`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_question_numerical` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT '0',
  `answer` bigint(10) NOT NULL DEFAULT '0',
  `tolerance` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`id`),
  KEY `mdl_quesnume_ans_ix` (`answer`),
  KEY `mdl_quesnume_que_ix` (`question`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Options for numerical questions.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_question_numerical`
--

LOCK TABLES `mdl_question_numerical` WRITE;
/*!40000 ALTER TABLE `mdl_question_numerical` DISABLE KEYS */;
INSERT INTO `mdl_question_numerical` VALUES (1,4056,19412,'0'),(2,4056,19413,'0'),(3,4056,19414,'0'),(4,4069,19433,'0.1'),(5,4069,19434,'2'),(6,4074,19448,'2'),(13,8777,41991,'0'),(14,8776,41990,'0'),(15,8778,41992,'0'),(16,8777,41996,'0'),(17,8776,41993,'0'),(18,8778,41997,'0'),(19,8777,42001,'0'),(20,8779,41995,'0'),(21,8776,41998,'0'),(22,8778,42002,'0'),(23,8779,41999,'0'),(24,8779,42003,'0'),(25,8802,42022,'0'),(26,8802,42024,'0'),(27,8802,42030,'0'),(28,8839,42097,'0.1'),(29,8840,42098,'0.1'),(30,8841,42099,'0.1'),(31,8839,42100,'2'),(32,8840,42102,'2'),(33,8841,42101,'2'),(34,8842,42103,'0.1'),(35,8842,42105,'2'),(36,8868,42187,'2'),(37,8870,42188,'2'),(38,8871,42189,'2'),(39,8874,42194,'2'),(40,8882,42212,'0.1'),(41,8882,42214,'2'),(42,8889,42233,'0'),(43,8889,42234,'0'),(44,8889,42235,'0'),(45,8891,42238,'2'),(46,8905,42259,'0.1'),(47,8905,42260,'2'),(48,8910,42274,'2'),(49,9103,43053,'0'),(50,9103,43054,'0'),(51,9103,43055,'0'),(52,9116,43074,'0.1'),(53,9116,43075,'2'),(54,9121,43089,'2'),(55,9148,43232,'0'),(56,9148,43233,'0'),(57,9148,43234,'0'),(58,9161,43253,'0.1'),(59,9161,43254,'2'),(60,9166,43268,'2'),(61,9195,43433,'0'),(62,9195,43434,'0'),(63,9195,43435,'0'),(64,9208,43454,'0.1'),(65,9208,43455,'2'),(66,9213,43469,'2'),(67,9241,43640,'0'),(68,9241,43641,'0'),(69,9241,43642,'0'),(70,9254,43661,'0.1'),(71,9254,43662,'2'),(72,9259,43676,'2'),(73,9286,43819,'0'),(74,9286,43820,'0'),(75,9286,43821,'0'),(76,9299,43840,'0.1'),(77,9299,43841,'2'),(78,9304,43855,'2'),(79,9331,43998,'0'),(80,9331,43999,'0'),(81,9331,44000,'0'),(82,9344,44019,'0.1'),(83,9344,44020,'2'),(84,9349,44034,'2'),(85,9379,44252,'0'),(86,9379,44253,'0'),(87,9379,44254,'0'),(88,9392,44273,'0.1'),(89,9392,44274,'2'),(90,9397,44288,'2'),(91,10316,49250,'0'),(92,10316,49251,'0'),(93,10316,49252,'0'),(94,10329,49271,'0.1'),(95,10329,49272,'2'),(96,10334,49286,'2'),(97,24160,118244,'2'),(98,24161,118249,'1'),(99,24162,118250,'2'),(100,24163,118251,'1'),(101,24164,118252,'1'),(102,25386,124261,'0'),(103,25386,124262,'0'),(104,25386,124263,'0'),(105,25387,124264,'0'),(106,25387,124265,'0'),(107,25387,124266,'0'),(108,25389,124273,'0'),(109,25389,124274,'0'),(110,25389,124275,'0'),(111,25391,124282,'0'),(112,25391,124283,'0'),(113,25391,124284,'0');
/*!40000 ALTER TABLE `mdl_question_numerical` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_question_numerical_options`
--

DROP TABLE IF EXISTS `mdl_question_numerical_options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_question_numerical_options` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT '0',
  `showunits` smallint(4) NOT NULL DEFAULT '0',
  `unitsleft` smallint(4) NOT NULL DEFAULT '0',
  `unitgradingtype` smallint(4) NOT NULL DEFAULT '0',
  `unitpenalty` decimal(12,7) NOT NULL DEFAULT '0.1000000',
  PRIMARY KEY (`id`),
  KEY `mdl_quesnumeopti_que_ix` (`question`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Options for questions of type numerical This table is also u';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_question_numerical_options`
--

LOCK TABLES `mdl_question_numerical_options` WRITE;
/*!40000 ALTER TABLE `mdl_question_numerical_options` DISABLE KEYS */;
INSERT INTO `mdl_question_numerical_options` VALUES (1,4056,3,0,0,0.1000000),(2,4069,3,0,0,1.0000000),(3,4074,3,0,0,1.0000000),(7,8776,3,0,0,0.1000000),(8,8777,3,0,0,0.1000000),(9,8778,3,0,0,0.1000000),(10,8779,3,0,0,0.1000000),(11,8802,3,0,0,0.1000000),(12,8839,3,0,0,1.0000000),(13,8840,3,0,0,1.0000000),(14,8841,3,0,0,1.0000000),(15,8842,3,0,0,1.0000000),(16,8868,3,0,0,1.0000000),(17,8870,3,0,0,1.0000000),(18,8871,3,0,0,1.0000000),(19,8874,3,0,0,1.0000000),(20,8882,3,0,0,1.0000000),(21,8889,3,0,0,0.1000000),(22,8891,3,0,0,1.0000000),(23,8905,3,0,0,1.0000000),(24,8910,3,0,0,1.0000000),(25,9103,3,0,0,0.1000000),(26,9116,3,0,0,1.0000000),(27,9121,3,0,0,1.0000000),(28,9148,3,0,0,0.1000000),(29,9161,3,0,0,1.0000000),(30,9166,3,0,0,1.0000000),(31,9195,3,0,0,0.1000000),(32,9208,3,0,0,1.0000000),(33,9213,3,0,0,1.0000000),(34,9241,3,0,0,0.1000000),(35,9254,3,0,0,1.0000000),(36,9259,3,0,0,1.0000000),(37,9286,3,0,0,0.1000000),(38,9299,3,0,0,1.0000000),(39,9304,3,0,0,1.0000000),(40,9331,3,0,0,0.1000000),(41,9344,3,0,0,1.0000000),(42,9349,3,0,0,1.0000000),(43,9379,3,0,0,0.1000000),(44,9392,3,0,0,1.0000000),(45,9397,3,0,0,1.0000000),(46,10316,3,0,0,0.1000000),(47,10329,3,0,0,1.0000000),(48,10334,3,0,0,1.0000000),(49,24160,3,0,0,0.1000000),(50,24161,3,0,0,0.1000000),(51,24162,3,0,0,0.1000000),(52,24163,3,0,0,0.1000000),(53,24164,3,0,0,0.1000000),(54,25386,3,0,0,0.1000000),(55,25387,3,0,0,0.1000000),(56,25389,3,0,0,0.1000000),(57,25391,3,0,0,0.1000000);
/*!40000 ALTER TABLE `mdl_question_numerical_options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_question_numerical_units`
--

DROP TABLE IF EXISTS `mdl_question_numerical_units`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_question_numerical_units` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT '0',
  `multiplier` decimal(38,19) NOT NULL DEFAULT '1.0000000000000000000',
  `unit` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mdl_quesnumeunit_queuni_uix` (`question`,`unit`),
  KEY `mdl_quesnumeunit_que_ix` (`question`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Optional unit options for numerical questions. This table is';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_question_numerical_units`
--

LOCK TABLES `mdl_question_numerical_units` WRITE;
/*!40000 ALTER TABLE `mdl_question_numerical_units` DISABLE KEYS */;
/*!40000 ALTER TABLE `mdl_question_numerical_units` 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 21:09:43
