Xp3eLLiN

1
2--
3-- Table structure for table `Platz`
4--
5
6DROP TABLE IF EXISTS `Platz`;
7/*!40101 SET @saved_cs_client     = @@character_set_client */;
8/*!40101 SET character_set_client = utf8 */;
9CREATE TABLE `Platz` (
10  `PNr` int(11) NOT NULL,
11  `TNr` int(11) NOT NULL,
12  `Kategorie` char(1) NOT NULL,
13  PRIMARY KEY (`PNr`,`TNr`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15/*!40101 SET character_set_client = @saved_cs_client */;
16
17--
18-- Dumping data for table `Platz`
19--
20
21LOCK TABLES `Platz` WRITE;
22/*!40000 ALTER TABLE `Platz` DISABLE KEYS */;
23INSERT INTO `Platz` VALUES (1,1,'A'),(1,2,'A'),(2,1,'A'),(2,2,'A'),(3,1,'B'),(3,2,'B'),(4,1,'B'),(4,2,'B'),(5,2,'C'),(6,2,'C'),(7,2,'C');
24/*!40000 ALTER TABLE `Platz` ENABLE KEYS */;
25UNLOCK TABLES;
26
27--
28-- Table structure for table `Theater`
29--
30
31DROP TABLE IF EXISTS `Theater`;
32/*!40101 SET @saved_cs_client     = @@character_set_client */;
33/*!40101 SET character_set_client = utf8 */;
34CREATE TABLE `Theater` (
35  `TNr` int(11) NOT NULL,
36  `Name` varchar(50) DEFAULT NULL,
37  `Ort` varchar(50) DEFAULT NULL,
38  PRIMARY KEY (`TNr`)
39) ENGINE=InnoDB DEFAULT CHARSET=utf8;
40/*!40101 SET character_set_client = @saved_cs_client */;
41
42--
43-- Dumping data for table `Theater`
44--
45
46LOCK TABLES `Theater` WRITE;
47/*!40000 ALTER TABLE `Theater` DISABLE KEYS */;
48INSERT INTO `Theater` VALUES (1,'Schauspielhaus','Bremen'),(2,'Packhaus','Bremen'),(3,'Shakespeare Company','Bremen'),(4,'Allee Theater','Hamburg'),(5,'Goldbekhaus','Hamburg');
49/*!40000 ALTER TABLE `Theater` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `Vorführung`
54--
55
56DROP TABLE IF EXISTS `Vorführung`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `Vorführung` (
60  `VNr` int(11) NOT NULL,
61  `Titel` varchar(50) DEFAULT NULL,
62  `Regisseur` varchar(50) DEFAULT NULL,
63  `Datum` varchar(10) DEFAULT NULL,
64  `TNr` int(11) NOT NULL,
65  PRIMARY KEY (`VNr`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `Vorführung`
71--
72
73LOCK TABLES `Vorführung` WRITE;
74/*!40000 ALTER TABLE `Vorführung` DISABLE KEYS */;
75INSERT INTO `Vorführung` VALUES (1,'Die Unbezwinglichen','Hans Lehner','11.4.2008',1),(2,'Purer Wahnsinn','Franz Kafka','19.4.2008',2),(3,'Purer Wahnsinn','Franz Kafka','24.4.2008',2),(4,'Purer Wahnsinn','Franz Kafka','1.7.2008',1);
76/*!40000 ALTER TABLE `Vorführung` ENABLE KEYS */;
77UNLOCK TABLES;
78/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
79
80/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
81/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
82/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
83/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
84/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
85/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
86/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
87
88-- Dump completed on 2012-09-06 15:23:46