Untitled.sql

CREATE DATABASE  IF NOT EXISTS `db_quiz` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `db_quiz`;
-- MySQL dump 10.13  Distrib 8.0.15, for macos10.14 (x86_64)
--
-- Host: 127.0.0.1    Database: db_quiz
-- ------------------------------------------------------
-- Server version	8.0.15

/*!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 */;
 SET NAMES utf8 ;
/*!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 `quiz_key`
--

DROP TABLE IF EXISTS `quiz_key`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `quiz_key` (
  `id` int(11) DEFAULT NULL,
  `question` text COLLATE utf8mb4_general_ci,
  `category` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quiz_key`
--

LOCK TABLES `quiz_key` WRITE;
/*!40000 ALTER TABLE `quiz_key` DISABLE KEYS */;
INSERT INTO `quiz_key` VALUES (1,'Q1A1','B'),(2,'Q1A2','D'),(3,'Q1A3','C'),(4,'Q1A4','E'),(5,'Q1A5','A'),(6,'Q2A1','D'),(7,'Q2A2','C'),(8,'Q2A3','B'),(9,'Q2A4','E'),(10,'Q2A5','A'),(11,'Q3A1','B'),(12,'Q3A2','A'),(13,'Q3A3','C'),(14,'Q3A4','D'),(15,'Q3A5','E'),(16,'Q4A1','C'),(17,'Q4A2','D'),(18,'Q4A3','A'),(19,'Q4A4','E'),(20,'Q4A5','B'),(21,'Q5A1','A'),(22,'Q5A2','C'),(23,'Q5A3','D'),(24,'Q6A1','C'),(25,'Q6A2','B'),(26,'Q6A3','A'),(27,'Q6A4','D'),(28,'Q6A5','E'),(29,'Q7A1','B'),(30,'Q8A1','A'),(31,'Q8A2','C'),(32,'Q8A3','D'),(33,'Q8A4','E'),(34,'Q8A5','B'),(35,'Q9A1','E'),(36,'Q9A2','B'),(37,'Q9A3','C'),(38,'Q9A4','D'),(39,'Q9A5','A'),(40,'Q10A1','B'),(41,'Q10A2','A'),(42,'Q10A3','D'),(43,'Q10A4','C'),(44,'Q10A5','E');
/*!40000 ALTER TABLE `quiz_key` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `quiz_map`
--

DROP TABLE IF EXISTS `quiz_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `quiz_map` (
  `id` int(11) DEFAULT NULL,
  `result` text COLLATE utf8mb4_general_ci,
  `result_category` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quiz_map`
--

LOCK TABLES `quiz_map` WRITE;
/*!40000 ALTER TABLE `quiz_map` DISABLE KEYS */;
INSERT INTO `quiz_map` VALUES (1,'Playfair Display','A'),(2,'Lora','AB'),(3,'Sacramento','AC'),(4,'Shadows Into Light Two','AD'),(5,'Alice','AE'),(6,'Raleway','B'),(7,'Josefin Slab','BC'),(8,'Amatic SC','BD'),(9,'Cutive Mono','BE'),(10,'Lobster Two','CE'),(11,'Fascinate Inline','CD'),(12,'Raleway Dots','CE'),(13,'Homemade Apple','D'),(14,'Bad Script','DE');
/*!40000 ALTER TABLE `quiz_map` 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-04-18 10:19:36