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

DROP TABLE IF EXISTS `mdl_question_multianswer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_question_multianswer` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `question` bigint(10) NOT NULL DEFAULT '0',
  `sequence` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quesmult_que_ix` (`question`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Options for multianswer questions';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_question_multianswer`
--

LOCK TABLES `mdl_question_multianswer` WRITE;
/*!40000 ALTER TABLE `mdl_question_multianswer` DISABLE KEYS */;
INSERT INTO `mdl_question_multianswer` VALUES (1,4060,'4061,4062,4063,4064,4065'),(2,4066,'4067,4068,4069,4070,4071,4072,4073,4074'),(6,8799,'8803,8808,8813,8818,8822'),(7,8801,'8804,8809,8815,8819,8823'),(8,8800,'8805,8810,8814,8820,8824'),(9,8806,'8807,8811,8817,8821,8825'),(10,8826,'8829,8835,8839,8845,8851,8858,8864,8868'),(11,8828,'8831,8837,8840,8848,8852,8860,8866,8871'),(12,8827,'8830,8836,8841,8847,8853,8859,8865,8870'),(13,8832,'8834,8838,8842,8849,8855,8861,8867,8874'),(14,8844,'8846,8850,8854,8857,8862'),(15,8869,'8873,8880,8882,8884,8886,8888,8890,8891'),(16,8896,'8897,8898,8899,8900,8901'),(17,8902,'8903,8904,8905,8906,8907,8908,8909,8910'),(18,9107,'9108,9109,9110,9111,9112'),(19,9113,'9114,9115,9116,9117,9118,9119,9120,9121'),(20,9152,'9153,9154,9155,9156,9157'),(21,9158,'9159,9160,9161,9162,9163,9164,9165,9166'),(22,9199,'9200,9201,9202,9203,9204'),(23,9205,'9206,9207,9208,9209,9210,9211,9212,9213'),(24,9245,'9246,9247,9248,9249,9250'),(25,9251,'9252,9253,9254,9255,9256,9257,9258,9259'),(26,9290,'9291,9292,9293,9294,9295'),(27,9296,'9297,9298,9299,9300,9301,9302,9303,9304'),(28,9335,'9336,9337,9338,9339,9340'),(29,9341,'9342,9343,9344,9345,9346,9347,9348,9349'),(30,9383,'9384,9385,9386,9387,9388'),(31,9389,'9390,9391,9392,9393,9394,9395,9396,9397'),(32,10320,'10321,10322,10323,10324,10325'),(33,10326,'10327,10328,10329,10330,10331,10332,10333,10334'),(34,28083,'28084');
/*!40000 ALTER TABLE `mdl_question_multianswer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_question_musicinterval`
--

DROP TABLE IF EXISTS `mdl_question_musicinterval`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_question_musicinterval` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT '0',
  `direction` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `quality` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `size` bigint(10) NOT NULL,
  `orignoteletter` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orignoteaccidental` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orignoteregister` bigint(10) NOT NULL,
  `clef` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_quesmusi_que_ix` (`questionid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Options for musicinterval questions';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_question_musicinterval`
--

LOCK TABLES `mdl_question_musicinterval` WRITE;
/*!40000 ALTER TABLE `mdl_question_musicinterval` DISABLE KEYS */;
INSERT INTO `mdl_question_musicinterval` VALUES (1,34040,'d','M',2,'C','',3,'t');
/*!40000 ALTER TABLE `mdl_question_musicinterval` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_question_musickeysignature`
--

DROP TABLE IF EXISTS `mdl_question_musickeysignature`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_question_musickeysignature` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL DEFAULT '0',
  `orignoteletter` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `orignoteaccidental` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mode` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `clef` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mdl_quesmusi_que_ix` (`questionid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Options for music key signature questions';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_question_musickeysignature`
--

LOCK TABLES `mdl_question_musickeysignature` WRITE;
/*!40000 ALTER TABLE `mdl_question_musickeysignature` DISABLE KEYS */;
INSERT INTO `mdl_question_musickeysignature` VALUES (1,34041,'C','','major','t');
/*!40000 ALTER TABLE `mdl_question_musickeysignature` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mdl_question_musicscale`
--

DROP TABLE IF EXISTS `mdl_question_musicscale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mdl_question_musicscale` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT,
  `questionid` bigint(10) NOT NULL,
  `includeks` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `modescale` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orignoteletter` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orignoteaccidental` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `orignoteregister` bigint(10) NOT NULL,
  `forceclef` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `mdl_quesmusi_que_ix` (`questionid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Options for musicscale questions';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mdl_question_musicscale`
--

LOCK TABLES `mdl_question_musicscale` WRITE;
/*!40000 ALTER TABLE `mdl_question_musicscale` DISABLE KEYS */;
INSERT INTO `mdl_question_musicscale` VALUES (1,34042,'y','ma','C','',1,'');
/*!40000 ALTER TABLE `mdl_question_musicscale` 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:28
