text: -- MySQL dump 10.13  Distrib 5.5.43, for debian-linux-gnu (x86_64)
  --
  -- Host: localhost    Database: newsjunkies
  -- ------------------------------------------------------
  -- Server version	5.5.43-0ubuntu0.14.04.1
  
  /*!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 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 `antwort`
  --
  
  DROP TABLE IF EXISTS `antwort`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `antwort` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `text` varchar(255) NOT NULL,
    `ist_richtig` tinyint(1) NOT NULL,
    `frage_id` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `antwort`
  --
  
  LOCK TABLES `antwort` WRITE;
  /*!40000 ALTER TABLE `antwort` DISABLE KEYS */;
  INSERT INTO `antwort` VALUES (1,'sdcsdcsd',1,15),(2,'csdcsdc',0,15),(3,'sdcscsdc',0,15),(4,'scscsc',0,15),(5,'sdcsdcsd',1,16),(6,'csdcsdc',0,16),(7,'sdcscsdc',0,16),(8,'scscsc',0,16),(9,'sdcsdcsd',1,17),(10,'csdcsdc',0,17),(11,'sdcscsdc',0,17),(12,'scscsc',0,17),(13,'sdcsdcsd',1,18),(14,'csdcsdc',0,18),(15,'sdcscsdc',0,18),(16,'scscsc',0,18),(17,'!111111111111111111',0,19),(18,'2222222222222',0,19),(19,'333333333333333',1,19),(20,'4444444444444444444',0,19);
  /*!40000 ALTER TABLE `antwort` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `frage`
  --
  
  DROP TABLE IF EXISTS `frage`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `frage` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `text` varchar(255) NOT NULL,
    `media_id` int(11) DEFAULT NULL,
    `date_value` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `frage`
  --
  
  LOCK TABLES `frage` WRITE;
  /*!40000 ALTER TABLE `frage` DISABLE KEYS */;
  INSERT INTO `frage` VALUES (15,'fgfsdc',NULL,'0000-00-00 00:00:00'),(16,'fgfsdc',NULL,'0000-00-00 00:00:00'),(17,'testasdasdasd',NULL,'0000-00-00 00:00:00'),(18,'testasdasdasd',NULL,'0000-00-00 00:00:00'),(19,'FRAGEGEGEGEG',NULL,'0000-00-00 00:00:00');
  /*!40000 ALTER TABLE `frage` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `fragen_rubriken`
  --
  
  DROP TABLE IF EXISTS `fragen_rubriken`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `fragen_rubriken` (
    `frage_id` int(11) NOT NULL,
    `rubrik_id` int(11) NOT NULL,
    PRIMARY KEY (`frage_id`,`rubrik_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `fragen_rubriken`
  --
  
  LOCK TABLES `fragen_rubriken` WRITE;
  /*!40000 ALTER TABLE `fragen_rubriken` DISABLE KEYS */;
  INSERT INTO `fragen_rubriken` VALUES (15,1),(15,2),(16,1),(16,2),(16,3),(16,4),(16,6),(17,1),(17,2),(17,3),(17,4),(17,5),(17,6),(18,1),(18,3),(18,5),(19,1),(19,6);
  /*!40000 ALTER TABLE `fragen_rubriken` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `media`
  --
  
  DROP TABLE IF EXISTS `media`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `media` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `url` varchar(512) NOT NULL,
    `type` varchar(16) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `media`
  --
  
  LOCK TABLES `media` WRITE;
  /*!40000 ALTER TABLE `media` DISABLE KEYS */;
  /*!40000 ALTER TABLE `media` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `rubriken`
  --
  
  DROP TABLE IF EXISTS `rubriken`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `rubriken` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `rubriken`
  --
  
  LOCK TABLES `rubriken` WRITE;
  /*!40000 ALTER TABLE `rubriken` DISABLE KEYS */;
  INSERT INTO `rubriken` VALUES (1,'Allgemein'),(2,'Inland'),(3,'Ausland'),(4,'Wirtschaft'),(5,'Kultur'),(6,'Sport');
  /*!40000 ALTER TABLE `rubriken` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `time`
  --
  
  DROP TABLE IF EXISTS `time`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `time` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `type` varchar(32) NOT NULL,
    `sek` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `time`
  --
  
  LOCK TABLES `time` WRITE;
  /*!40000 ALTER TABLE `time` DISABLE KEYS */;
  /*!40000 ALTER TABLE `time` 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 2015-06-18 10:37:48
  