· 8 years ago · Feb 16, 2018, 09:30 AM
1CREATE DATABASE IF NOT EXISTS `academy` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `academy`;
3-- MySQL dump 10.13 Distrib 5.5.16, for Win32 (x86)
4--
5-- Host: localhost Database: academy
6-- ------------------------------------------------------
7-- Server version 5.5.21
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `Lehrgang`
22--
23
24DROP TABLE IF EXISTS `Lehrgang`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `Lehrgang` (
28 `idLehrgang` int(11) NOT NULL,
29 `fkInhalt` int(11) DEFAULT NULL,
30 `Beginn` date DEFAULT NULL,
31 `fkDozent` int(11) DEFAULT NULL,
32 `fkLehrgangsort` int(11) DEFAULT NULL,
33 PRIMARY KEY (`idLehrgang`),
34 KEY `fkInhalt` (`fkInhalt`),
35 KEY `fkDozent` (`fkDozent`),
36 KEY `fkLehrgangsort` (`fkLehrgangsort`),
37 CONSTRAINT `fkInhalt` FOREIGN KEY (`fkInhalt`) REFERENCES `Inhalt` (`idInhalt`) ON DELETE NO ACTION ON UPDATE NO ACTION,
38 CONSTRAINT `fkDozent` FOREIGN KEY (`fkDozent`) REFERENCES `Dozent` (`idDozent`) ON DELETE NO ACTION ON UPDATE NO ACTION,
39 CONSTRAINT `fkLehrgangsort` FOREIGN KEY (`fkLehrgangsort`) REFERENCES `Lehrgangsort` (`idLehrgangsort`) ON DELETE NO ACTION ON UPDATE NO ACTION
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `Lehrgang`
45--
46
47LOCK TABLES `Lehrgang` WRITE;
48/*!40000 ALTER TABLE `Lehrgang` DISABLE KEYS */;
49INSERT INTO `Lehrgang` VALUES (1,2,'2000-06-15',10,3),(2,2,'2000-06-15',9,2),(3,8,'2000-11-23',8,1),(4,14,'2000-02-08',7,1),(5,3,'2000-01-15',5,2),(6,9,'2000-06-30',3,2),(7,1,'2000-01-25',4,1),(8,9,'2000-06-30',3,2),(9,6,'2000-10-10',2,3),(10,11,'2000-03-30',1,1),(11,7,'2000-08-30',7,3);
50/*!40000 ALTER TABLE `Lehrgang` ENABLE KEYS */;
51UNLOCK TABLES;
52
53--
54-- Table structure for table `Lehrgangsort`
55--
56
57DROP TABLE IF EXISTS `Lehrgangsort`;
58/*!40101 SET @saved_cs_client = @@character_set_client */;
59/*!40101 SET character_set_client = utf8 */;
60CREATE TABLE `Lehrgangsort` (
61 `idLehrgangsort` int(11) NOT NULL,
62 `Bezeichnung` varchar(50) DEFAULT NULL,
63 PRIMARY KEY (`idLehrgangsort`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Dumping data for table `Lehrgangsort`
69--
70
71LOCK TABLES `Lehrgangsort` WRITE;
72/*!40000 ALTER TABLE `Lehrgangsort` DISABLE KEYS */;
73INSERT INTO `Lehrgangsort` VALUES (1,'Hotel Savoy Köln'),(2,'Friedrich-List-Berufskolleg Bonn'),(3,'Hotel Petersberg Königswinter');
74/*!40000 ALTER TABLE `Lehrgangsort` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `Teilnahme`
79--
80
81DROP TABLE IF EXISTS `Teilnahme`;
82/*!40101 SET @saved_cs_client = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `Teilnahme` (
85 `fkTeilnehmer` int(11) NOT NULL,
86 `fkLehrgang` int(11) NOT NULL,
87 PRIMARY KEY (`fkTeilnehmer`,`fkLehrgang`),
88 KEY `fkTeilnehmer` (`fkTeilnehmer`),
89 KEY `fkLehrgang` (`fkLehrgang`),
90 CONSTRAINT `fkTeilnehmer` FOREIGN KEY (`fkTeilnehmer`) REFERENCES `Teilnehmer` (`idTeilnehmer`) ON DELETE NO ACTION ON UPDATE NO ACTION,
91 CONSTRAINT `fkLehrgang` FOREIGN KEY (`fkLehrgang`) REFERENCES `Lehrgang` (`idLehrgang`) ON DELETE NO ACTION ON UPDATE NO ACTION
92) ENGINE=InnoDB DEFAULT CHARSET=latin1;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `Teilnahme`
97--
98
99LOCK TABLES `Teilnahme` WRITE;
100/*!40000 ALTER TABLE `Teilnahme` DISABLE KEYS */;
101INSERT INTO `Teilnahme` VALUES (1,9),(1,10),(2,1),(3,3),(3,6),(3,9),(4,7),(5,2),(5,8),(5,9),(6,6),(7,2),(7,8),(7,9),(7,11),(8,1),(8,4),(8,7),(9,5),(9,9),(10,5),(11,5),(11,9),(12,4),(12,5),(12,7),(13,1),(13,3),(13,8),(14,1),(14,8),(15,3),(15,7),(16,4),(16,7),(17,2),(17,4),(17,7),(19,3),(19,10),(20,3),(20,10),(21,8),(21,10);
102/*!40000 ALTER TABLE `Teilnahme` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `Ort`
107--
108
109DROP TABLE IF EXISTS `Ort`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `Ort` (
113 `idOrt` varchar(5) NOT NULL,
114 `Ortsname` varchar(50) DEFAULT NULL,
115 PRIMARY KEY (`idOrt`)
116) ENGINE=InnoDB DEFAULT CHARSET=latin1;
117/*!40101 SET character_set_client = @saved_cs_client */;
118
119--
120-- Dumping data for table `Ort`
121--
122
123LOCK TABLES `Ort` WRITE;
124/*!40000 ALTER TABLE `Ort` DISABLE KEYS */;
125INSERT INTO `Ort` VALUES ('16845','Holzhausen'),('22926','Birkenbusch'),('23898','Kühsen'),('36115','Ehrenberg'),('38275','Haverlah'),('45881','Gelsenkirchen'),('46117','Oberhausen'),('47259','Duisburg'),('47929','Grefrath'),('50769','Köln'),('50858','Köln'),('53177','Bonn'),('53229','Bonn'),('53474','Bad Neuenahr-Ahrweiler'),('53547','Dattenberg'),('56295','Lonning'),('56584','Rüschied'),('59075','Hamm'),('73486','Adelmannsfelden'),('83739','Heißkistler'),('84405','Loh'),('91469','Erlachskirchen');
126/*!40000 ALTER TABLE `Ort` ENABLE KEYS */;
127UNLOCK TABLES;
128
129--
130-- Table structure for table `Dozent`
131--
132
133DROP TABLE IF EXISTS `Dozent`;
134/*!40101 SET @saved_cs_client = @@character_set_client */;
135/*!40101 SET character_set_client = utf8 */;
136CREATE TABLE `Dozent` (
137 `idDozent` int(11) NOT NULL,
138 `Nachname` varchar(50) DEFAULT NULL,
139 `Stundensatz` double DEFAULT NULL,
140 PRIMARY KEY (`idDozent`)
141) ENGINE=InnoDB DEFAULT CHARSET=latin1;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `Dozent`
146--
147
148LOCK TABLES `Dozent` WRITE;
149/*!40000 ALTER TABLE `Dozent` DISABLE KEYS */;
150INSERT INTO `Dozent` VALUES (1,'Wirtgen',60),(2,'Schult',65),(3,'Schneider',50),(4,'Göppert',70),(5,'Hamblen',70),(6,'Dohlen',55),(7,'Heidert',60),(8,'Kruse',55),(9,'Feldmann',70),(10,'Seibold',65),(11,'Bachmann',22.5);
151/*!40000 ALTER TABLE `Dozent` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Table structure for table `Inhalt`
156--
157
158DROP TABLE IF EXISTS `Inhalt`;
159/*!40101 SET @saved_cs_client = @@character_set_client */;
160/*!40101 SET character_set_client = utf8 */;
161CREATE TABLE `Inhalt` (
162 `idInhalt` int(11) NOT NULL,
163 `Beschreibung` varchar(50) DEFAULT NULL,
164 `Stundensatz` double DEFAULT NULL,
165 `Dauer` int(11) DEFAULT NULL,
166 PRIMARY KEY (`idInhalt`)
167) ENGINE=InnoDB DEFAULT CHARSET=latin1;
168/*!40101 SET character_set_client = @saved_cs_client */;
169
170--
171-- Dumping data for table `Inhalt`
172--
173
174LOCK TABLES `Inhalt` WRITE;
175/*!40000 ALTER TABLE `Inhalt` DISABLE KEYS */;
176INSERT INTO `Inhalt` VALUES (1,'MS-Office Grundlagen',20,16),(2,'Java Anfänger',22,48),(3,'C++ Fortgeschrittene',30,32),(4,'Konfiguration eines Firewalls',25,8),(5,'Einrichtung eines Web-Servers',18,16),(6,'Teamarbeit',15,40),(7,'Projektmanagement',12,16),(8,'Qualitätsssicherung',20,32),(9,'Java-Fortgeschrittene',30,40),(10,'C++ Experten',30,80),(11,'Systemadministration WIN-NT',15,32),(12,'LINUX Installation',20,20),(13,'C++-Anfänger',15,32),(14,'Access Einführung',15,32);
177/*!40000 ALTER TABLE `Inhalt` ENABLE KEYS */;
178UNLOCK TABLES;
179
180--
181-- Table structure for table `Teilnehmer`
182--
183
184DROP TABLE IF EXISTS `Teilnehmer`;
185/*!40101 SET @saved_cs_client = @@character_set_client */;
186/*!40101 SET character_set_client = utf8 */;
187CREATE TABLE `Teilnehmer` (
188 `idTeilnehmer` int(11) NOT NULL,
189 `Nachname` varchar(50) DEFAULT NULL,
190 `fkOrt` varchar(5) DEFAULT NULL,
191 PRIMARY KEY (`idTeilnehmer`),
192 KEY `fkOrt` (`fkOrt`),
193 CONSTRAINT `fkOrt` FOREIGN KEY (`fkOrt`) REFERENCES `Ort` (`idOrt`) ON DELETE NO ACTION ON UPDATE NO ACTION
194) ENGINE=InnoDB DEFAULT CHARSET=latin1;
195/*!40101 SET character_set_client = @saved_cs_client */;
196
197--
198-- Dumping data for table `Teilnehmer`
199--
200
201LOCK TABLES `Teilnehmer` WRITE;
202/*!40000 ALTER TABLE `Teilnehmer` DISABLE KEYS */;
203INSERT INTO `Teilnehmer` VALUES (1,'Battner','38275'),(2,'Mitz','16845'),(3,'Jäger','23898'),(4,'Griffith','56584'),(5,'Betz','53177'),(6,'Gründgens','56295'),(7,'Bach','83739'),(8,'Eisenmann','84405'),(9,'Kelter','53474'),(10,'Bachmann','47259'),(11,'Ahmendt','50858'),(12,'Jacobs','56295'),(13,'Dotzler','46117'),(14,'Sterling','50769'),(15,'Escher','59075'),(16,'Bochers','91469'),(17,'Zobel','84405'),(18,'Zimmermann','47929'),(19,'Brödner','53229'),(20,'Babbage','56584'),(21,'Coy','84405');
204/*!40000 ALTER TABLE `Teilnehmer` ENABLE KEYS */;
205UNLOCK TABLES;
206/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
207
208/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
209/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
210/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
211/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
212/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
213/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
214/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
215
216-- Dump completed on 2012-03-26 19:48:00