· 8 years ago · Nov 22, 2017, 01:16 PM
1-- MySQL dump 10.13 Distrib 5.7.9, for Win64 (x86_64)
2--
3-- Host: localhost Database: auftrag4
4-- ------------------------------------------------------
5-- Server version 5.7.12-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `abteilung`
20--
21
22DROP TABLE IF EXISTS `abteilung`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `abteilung` (
26 `id_abteilung` int(11) NOT NULL AUTO_INCREMENT,
27 `abteilungsname` varchar(45) NOT NULL,
28 `abteilungsbeschreibung` varchar(300) DEFAULT NULL,
29 PRIMARY KEY (`id_abteilung`)
30) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
31/*!40101 SET character_set_client = @saved_cs_client */;
32
33--
34-- Dumping data for table `abteilung`
35--
36
37LOCK TABLES `abteilung` WRITE;
38/*!40000 ALTER TABLE `abteilung` DISABLE KEYS */;
39INSERT INTO `abteilung` VALUES (1,'ProgrammierABT',NULL),(2,'KuechenABT','Interne Firmenkueche'),(3,'SekretariatABT','Firmensekretariat'),(4,'PapiershreddereiABT',NULL),(5,'MeldestelleABT',NULL),(6,'WeltherrschaftABT','Top secret');
40/*!40000 ALTER TABLE `abteilung` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Temporary view structure for view `anzahl_stunden_zu_max`
45--
46
47DROP TABLE IF EXISTS `anzahl_stunden_zu_max`;
48/*!50001 DROP VIEW IF EXISTS `anzahl_stunden_zu_max`*/;
49SET @saved_cs_client = @@character_set_client;
50SET character_set_client = utf8;
51/*!50001 CREATE VIEW `anzahl_stunden_zu_max` AS SELECT
52 1 AS `Projekt`,
53 1 AS `Maximale Arbeitszeit`,
54 1 AS `Bisherige Arbeitszeit`,
55 1 AS `in %`*/;
56SET character_set_client = @saved_cs_client;
57
58--
59-- Table structure for table `audit_buchung`
60--
61
62DROP TABLE IF EXISTS `audit_buchung`;
63/*!40101 SET @saved_cs_client = @@character_set_client */;
64/*!40101 SET character_set_client = utf8 */;
65CREATE TABLE `audit_buchung` (
66 `id_audit_buchung` int(11) NOT NULL AUTO_INCREMENT,
67 `zeitpunkt_audit` datetime NOT NULL,
68 `id_buchung` int(11) NOT NULL,
69 `stunden` int(11) NOT NULL,
70 `freitextfeld` varchar(2000) DEFAULT NULL,
71 `eintrag_id` int(11) NOT NULL,
72 `taetigkeit_id` int(11) NOT NULL,
73 PRIMARY KEY (`id_audit_buchung`)
74) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
75/*!40101 SET character_set_client = @saved_cs_client */;
76
77--
78-- Dumping data for table `audit_buchung`
79--
80
81LOCK TABLES `audit_buchung` WRITE;
82/*!40000 ALTER TABLE `audit_buchung` DISABLE KEYS */;
83INSERT INTO `audit_buchung` VALUES (1,'2016-05-26 20:32:48',2,1,'eine ein-stunden tätigkeit',4,2),(2,'2016-05-26 20:32:48',9,3,NULL,9,2);
84/*!40000 ALTER TABLE `audit_buchung` ENABLE KEYS */;
85UNLOCK TABLES;
86
87--
88-- Table structure for table `buchung`
89--
90
91DROP TABLE IF EXISTS `buchung`;
92/*!40101 SET @saved_cs_client = @@character_set_client */;
93/*!40101 SET character_set_client = utf8 */;
94CREATE TABLE `buchung` (
95 `id_buchung` int(11) NOT NULL AUTO_INCREMENT,
96 `stunden` int(11) NOT NULL,
97 `freitextfeld` varchar(300) DEFAULT NULL,
98 `eintrag_id` int(11) NOT NULL,
99 `taetigkeit_id` int(11) DEFAULT NULL,
100 `Datenbankbenutzer` varchar(50) DEFAULT 'root',
101 `Eintragsdatum` datetime DEFAULT NULL,
102 PRIMARY KEY (`id_buchung`),
103 KEY `eintrag_id` (`eintrag_id`),
104 KEY `taetigkeit_id` (`taetigkeit_id`),
105 CONSTRAINT `buchung_ibfk_1` FOREIGN KEY (`eintrag_id`) REFERENCES `zwischentabelle` (`id_eintrag`),
106 CONSTRAINT `buchung_ibfk_2` FOREIGN KEY (`taetigkeit_id`) REFERENCES `taetigkeit` (`id_taetigkeit`)
107) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
108/*!40101 SET character_set_client = @saved_cs_client */;
109
110--
111-- Dumping data for table `buchung`
112--
113
114LOCK TABLES `buchung` WRITE;
115/*!40000 ALTER TABLE `buchung` DISABLE KEYS */;
116INSERT INTO `buchung` VALUES (1,10,'Erster Eintrag nur zu testzwecken',1,1,'root',NULL),(2,2,'eine ein-stunden tätigkeit',4,2,'root@localhost','2016-05-26 20:32:48'),(3,7,NULL,2,4,'root',NULL),(4,4,NULL,3,3,'root',NULL),(5,5,NULL,5,3,'root',NULL),(6,6,NULL,6,5,'root',NULL),(7,3,'neue tätigkeit',7,4,'dennis@localhost','2016-05-26 00:07:14'),(8,7,'bitte unbedingt ausfüllen',8,3,'mustername@localhost','2016-05-26 20:08:00');
117/*!40000 ALTER TABLE `buchung` ENABLE KEYS */;
118UNLOCK TABLES;
119
120--
121-- Table structure for table `eingegangene_zahlungen`
122--
123
124DROP TABLE IF EXISTS `eingegangene_zahlungen`;
125/*!40101 SET @saved_cs_client = @@character_set_client */;
126/*!40101 SET character_set_client = utf8 */;
127CREATE TABLE `eingegangene_zahlungen` (
128 `id_eingegangene_zahlungen` int(11) NOT NULL AUTO_INCREMENT,
129 `datum` date NOT NULL,
130 `betrag` int(11) DEFAULT NULL,
131 `rechnung_id` int(11) NOT NULL,
132 PRIMARY KEY (`id_eingegangene_zahlungen`),
133 KEY `rechnung_id` (`rechnung_id`),
134 CONSTRAINT `eingegangene_zahlungen_ibfk_1` FOREIGN KEY (`rechnung_id`) REFERENCES `rechnungen` (`id_rechnung`)
135) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
136/*!40101 SET character_set_client = @saved_cs_client */;
137
138--
139-- Dumping data for table `eingegangene_zahlungen`
140--
141
142LOCK TABLES `eingegangene_zahlungen` WRITE;
143/*!40000 ALTER TABLE `eingegangene_zahlungen` DISABLE KEYS */;
144INSERT INTO `eingegangene_zahlungen` VALUES (1,'2015-10-04',300,1),(2,'2015-11-03',3000,2),(3,'2015-11-05',300,1),(4,'2015-11-09',400,2),(5,'2015-12-04',7000,3),(6,'2015-12-12',1313,4),(7,'2016-01-01',2400,5);
145/*!40000 ALTER TABLE `eingegangene_zahlungen` ENABLE KEYS */;
146UNLOCK TABLES;
147
148--
149-- Table structure for table `fixprojekte`
150--
151
152DROP TABLE IF EXISTS `fixprojekte`;
153/*!40101 SET @saved_cs_client = @@character_set_client */;
154/*!40101 SET character_set_client = utf8 */;
155CREATE TABLE `fixprojekte` (
156 `projekt_id` int(11) NOT NULL,
157 `preis` int(11) NOT NULL,
158 PRIMARY KEY (`projekt_id`),
159 CONSTRAINT `fixprojekte_ibfk_1` FOREIGN KEY (`projekt_id`) REFERENCES `projekt` (`id_projekt`)
160) ENGINE=InnoDB DEFAULT CHARSET=utf8;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `fixprojekte`
165--
166
167LOCK TABLES `fixprojekte` WRITE;
168/*!40000 ALTER TABLE `fixprojekte` DISABLE KEYS */;
169INSERT INTO `fixprojekte` VALUES (1,5000),(3,90000),(4,10000);
170/*!40000 ALTER TABLE `fixprojekte` ENABLE KEYS */;
171UNLOCK TABLES;
172
173--
174-- Table structure for table `hirarchie`
175--
176
177DROP TABLE IF EXISTS `hirarchie`;
178/*!40101 SET @saved_cs_client = @@character_set_client */;
179/*!40101 SET character_set_client = utf8 */;
180CREATE TABLE `hirarchie` (
181 `id_hirarchie` int(11) NOT NULL AUTO_INCREMENT,
182 `boss` int(11) DEFAULT NULL,
183 `mitarbeiter` int(11) DEFAULT NULL,
184 PRIMARY KEY (`id_hirarchie`),
185 KEY `boss` (`boss`),
186 KEY `mitarbeiter` (`mitarbeiter`),
187 CONSTRAINT `hirarchie_ibfk_1` FOREIGN KEY (`boss`) REFERENCES `mitarbeiter` (`id_mitarbeiter`),
188 CONSTRAINT `hirarchie_ibfk_2` FOREIGN KEY (`mitarbeiter`) REFERENCES `mitarbeiter` (`id_mitarbeiter`)
189) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
190/*!40101 SET character_set_client = @saved_cs_client */;
191
192--
193-- Dumping data for table `hirarchie`
194--
195
196LOCK TABLES `hirarchie` WRITE;
197/*!40000 ALTER TABLE `hirarchie` DISABLE KEYS */;
198INSERT INTO `hirarchie` VALUES (1,2,3),(2,5,7),(3,1,4),(4,1,6),(5,4,8),(6,2,9),(7,2,10),(8,7,11);
199/*!40000 ALTER TABLE `hirarchie` ENABLE KEYS */;
200UNLOCK TABLES;
201
202--
203-- Table structure for table `mitarbeiter`
204--
205
206DROP TABLE IF EXISTS `mitarbeiter`;
207/*!40101 SET @saved_cs_client = @@character_set_client */;
208/*!40101 SET character_set_client = utf8 */;
209CREATE TABLE `mitarbeiter` (
210 `id_mitarbeiter` int(11) NOT NULL AUTO_INCREMENT,
211 `vorname` varchar(50) DEFAULT NULL,
212 `nachname` varchar(50) NOT NULL,
213 `lohn` int(11) NOT NULL,
214 `abteilung_id` int(11) NOT NULL,
215 PRIMARY KEY (`id_mitarbeiter`),
216 KEY `abteilung_id` (`abteilung_id`),
217 CONSTRAINT `mitarbeiter_ibfk_1` FOREIGN KEY (`abteilung_id`) REFERENCES `abteilung` (`id_abteilung`)
218) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
219/*!40101 SET character_set_client = @saved_cs_client */;
220
221--
222-- Dumping data for table `mitarbeiter`
223--
224
225LOCK TABLES `mitarbeiter` WRITE;
226/*!40000 ALTER TABLE `mitarbeiter` DISABLE KEYS */;
227INSERT INTO `mitarbeiter` VALUES (1,NULL,'Meier',400,1),(2,'Robert','Aschenputtel',350,4),(3,'Max','Frankenstein',200,2),(4,NULL,'Hauser',375,3),(5,NULL,'Wollishofer',250,5),(6,'Frederick','Juncker',300,3),(7,'Robin','Schumacher',400,1),(8,'Fritz','Mustermann',315,5),(9,'Thomas','Breidenbach',290,2),(10,'Severin','Flamme',345,1),(11,'Tom','Cherry',500,1);
228/*!40000 ALTER TABLE `mitarbeiter` ENABLE KEYS */;
229UNLOCK TABLES;
230
231--
232-- Table structure for table `projekt`
233--
234
235DROP TABLE IF EXISTS `projekt`;
236/*!40101 SET @saved_cs_client = @@character_set_client */;
237/*!40101 SET character_set_client = utf8 */;
238CREATE TABLE `projekt` (
239 `id_projekt` int(11) NOT NULL AUTO_INCREMENT,
240 `projektname` varchar(45) NOT NULL,
241 `projektbeschreibung` varchar(300) DEFAULT NULL,
242 `maximale_arbeitszeit` int(11) DEFAULT '100',
243 PRIMARY KEY (`id_projekt`)
244) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
245/*!40101 SET character_set_client = @saved_cs_client */;
246
247--
248-- Dumping data for table `projekt`
249--
250
251LOCK TABLES `projekt` WRITE;
252/*!40000 ALTER TABLE `projekt` DISABLE KEYS */;
253INSERT INTO `projekt` VALUES (1,'Firmenprojekt','Default-Projekt',100),(2,'Sitzprojekt',NULL,100),(3,'Werbeprojekt','nur für werbung',100),(4,'Sammelprojekt','ist das eine beschreibung',100),(5,'Ideensammelprojekt','Ideen sind ausgegangen',100);
254/*!40000 ALTER TABLE `projekt` ENABLE KEYS */;
255UNLOCK TABLES;
256
257--
258-- Temporary view structure for view `projektkosten`
259--
260
261DROP TABLE IF EXISTS `projektkosten`;
262/*!50001 DROP VIEW IF EXISTS `projektkosten`*/;
263SET @saved_cs_client = @@character_set_client;
264SET character_set_client = utf8;
265/*!50001 CREATE VIEW `projektkosten` AS SELECT
266 1 AS `id_buchung`,
267 1 AS `projektname`,
268 1 AS `kosten`*/;
269SET character_set_client = @saved_cs_client;
270
271--
272-- Table structure for table `rechnungen`
273--
274
275DROP TABLE IF EXISTS `rechnungen`;
276/*!40101 SET @saved_cs_client = @@character_set_client */;
277/*!40101 SET character_set_client = utf8 */;
278CREATE TABLE `rechnungen` (
279 `id_rechnung` int(11) NOT NULL,
280 `projekt_id` int(11) NOT NULL,
281 PRIMARY KEY (`id_rechnung`),
282 KEY `projekt_id` (`projekt_id`),
283 CONSTRAINT `rechnungen_ibfk_1` FOREIGN KEY (`projekt_id`) REFERENCES `projekt` (`id_projekt`)
284) ENGINE=InnoDB DEFAULT CHARSET=utf8;
285/*!40101 SET character_set_client = @saved_cs_client */;
286
287--
288-- Dumping data for table `rechnungen`
289--
290
291LOCK TABLES `rechnungen` WRITE;
292/*!40000 ALTER TABLE `rechnungen` DISABLE KEYS */;
293INSERT INTO `rechnungen` VALUES (1,1),(2,2),(3,3),(6,3),(4,4),(5,5);
294/*!40000 ALTER TABLE `rechnungen` ENABLE KEYS */;
295UNLOCK TABLES;
296
297--
298-- Table structure for table `regieprojekte`
299--
300
301DROP TABLE IF EXISTS `regieprojekte`;
302/*!40101 SET @saved_cs_client = @@character_set_client */;
303/*!40101 SET character_set_client = utf8 */;
304CREATE TABLE `regieprojekte` (
305 `projekt_id` int(11) NOT NULL,
306 `kosten_pro_stunde_an_kunden` int(11) DEFAULT NULL,
307 PRIMARY KEY (`projekt_id`),
308 CONSTRAINT `regieprojekte_ibfk_1` FOREIGN KEY (`projekt_id`) REFERENCES `projekt` (`id_projekt`)
309) ENGINE=InnoDB DEFAULT CHARSET=utf8;
310/*!40101 SET character_set_client = @saved_cs_client */;
311
312--
313-- Dumping data for table `regieprojekte`
314--
315
316LOCK TABLES `regieprojekte` WRITE;
317/*!40000 ALTER TABLE `regieprojekte` DISABLE KEYS */;
318INSERT INTO `regieprojekte` VALUES (2,300),(5,375);
319/*!40000 ALTER TABLE `regieprojekte` ENABLE KEYS */;
320UNLOCK TABLES;
321
322--
323-- Table structure for table `taetigkeit`
324--
325
326DROP TABLE IF EXISTS `taetigkeit`;
327/*!40101 SET @saved_cs_client = @@character_set_client */;
328/*!40101 SET character_set_client = utf8 */;
329CREATE TABLE `taetigkeit` (
330 `id_taetigkeit` int(11) NOT NULL AUTO_INCREMENT,
331 `taetigkeit` varchar(45) NOT NULL,
332 PRIMARY KEY (`id_taetigkeit`)
333) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
334/*!40101 SET character_set_client = @saved_cs_client */;
335
336--
337-- Dumping data for table `taetigkeit`
338--
339
340LOCK TABLES `taetigkeit` WRITE;
341/*!40000 ALTER TABLE `taetigkeit` DISABLE KEYS */;
342INSERT INTO `taetigkeit` VALUES (1,'rumsitzen'),(2,'lachen'),(3,'reden'),(4,'entwickeln'),(5,'laufen');
343/*!40000 ALTER TABLE `taetigkeit` ENABLE KEYS */;
344UNLOCK TABLES;
345
346--
347-- Table structure for table `versandte_rechnungen`
348--
349
350DROP TABLE IF EXISTS `versandte_rechnungen`;
351/*!40101 SET @saved_cs_client = @@character_set_client */;
352/*!40101 SET character_set_client = utf8 */;
353CREATE TABLE `versandte_rechnungen` (
354 `id_versandte` int(11) NOT NULL AUTO_INCREMENT,
355 `datum` date NOT NULL,
356 `rechnung_id` int(11) NOT NULL,
357 PRIMARY KEY (`id_versandte`),
358 KEY `rechnung_id` (`rechnung_id`),
359 CONSTRAINT `versandte_rechnungen_ibfk_1` FOREIGN KEY (`rechnung_id`) REFERENCES `rechnungen` (`id_rechnung`)
360) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
361/*!40101 SET character_set_client = @saved_cs_client */;
362
363--
364-- Dumping data for table `versandte_rechnungen`
365--
366
367LOCK TABLES `versandte_rechnungen` WRITE;
368/*!40000 ALTER TABLE `versandte_rechnungen` DISABLE KEYS */;
369INSERT INTO `versandte_rechnungen` VALUES (1,'2015-04-22',1),(2,'2015-05-01',2),(3,'2015-05-02',3),(4,'2015-05-03',4),(5,'2015-08-29',5),(6,'2015-09-01',6);
370/*!40000 ALTER TABLE `versandte_rechnungen` ENABLE KEYS */;
371UNLOCK TABLES;
372
373--
374-- Table structure for table `zwischentabelle`
375--
376
377DROP TABLE IF EXISTS `zwischentabelle`;
378/*!40101 SET @saved_cs_client = @@character_set_client */;
379/*!40101 SET character_set_client = utf8 */;
380CREATE TABLE `zwischentabelle` (
381 `id_eintrag` int(11) NOT NULL AUTO_INCREMENT,
382 `projekt_id` int(11) NOT NULL,
383 `mitarbeiter_id` int(11) NOT NULL,
384 PRIMARY KEY (`id_eintrag`),
385 KEY `projekt_id` (`projekt_id`),
386 CONSTRAINT `zwischentabelle_ibfk_1` FOREIGN KEY (`projekt_id`) REFERENCES `projekt` (`id_projekt`)
387) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
388/*!40101 SET character_set_client = @saved_cs_client */;
389
390--
391-- Dumping data for table `zwischentabelle`
392--
393
394LOCK TABLES `zwischentabelle` WRITE;
395/*!40000 ALTER TABLE `zwischentabelle` DISABLE KEYS */;
396INSERT INTO `zwischentabelle` VALUES (1,1,1),(2,2,2),(3,3,3),(4,3,2),(5,3,4),(6,4,5),(7,1,6),(8,1,8),(9,1,9),(10,1,10);
397/*!40000 ALTER TABLE `zwischentabelle` ENABLE KEYS */;
398UNLOCK TABLES;
399
400--
401-- Final view structure for view `anzahl_stunden_zu_max`
402--
403
404/*!50001 DROP VIEW IF EXISTS `anzahl_stunden_zu_max`*/;
405/*!50001 SET @saved_cs_client = @@character_set_client */;
406/*!50001 SET @saved_cs_results = @@character_set_results */;
407/*!50001 SET @saved_col_connection = @@collation_connection */;
408/*!50001 SET character_set_client = utf8 */;
409/*!50001 SET character_set_results = utf8 */;
410/*!50001 SET collation_connection = utf8_general_ci */;
411/*!50001 CREATE ALGORITHM=UNDEFINED */
412/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
413/*!50001 VIEW `anzahl_stunden_zu_max` AS select `projekt`.`projektname` AS `Projekt`,`projekt`.`maximale_arbeitszeit` AS `Maximale Arbeitszeit`,sum(`buchung`.`stunden`) AS `Bisherige Arbeitszeit`,cast(((100 / `projekt`.`maximale_arbeitszeit`) * sum(`buchung`.`stunden`)) as decimal(3,2)) AS `in %` from ((`buchung` join `zwischentabelle` on((`zwischentabelle`.`id_eintrag` = `buchung`.`eintrag_id`))) join `projekt` on((`zwischentabelle`.`projekt_id` = `projekt`.`id_projekt`))) group by `projekt`.`projektname` */;
414/*!50001 SET character_set_client = @saved_cs_client */;
415/*!50001 SET character_set_results = @saved_cs_results */;
416/*!50001 SET collation_connection = @saved_col_connection */;
417
418--
419-- Final view structure for view `projektkosten`
420--
421
422/*!50001 DROP VIEW IF EXISTS `projektkosten`*/;
423/*!50001 SET @saved_cs_client = @@character_set_client */;
424/*!50001 SET @saved_cs_results = @@character_set_results */;
425/*!50001 SET @saved_col_connection = @@collation_connection */;
426/*!50001 SET character_set_client = utf8 */;
427/*!50001 SET character_set_results = utf8 */;
428/*!50001 SET collation_connection = utf8_general_ci */;
429/*!50001 CREATE ALGORITHM=UNDEFINED */
430/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
431/*!50001 VIEW `projektkosten` AS select `buchung`.`id_buchung` AS `id_buchung`,`projekt`.`projektname` AS `projektname`,sum((`mitarbeiter`.`lohn` * `buchung`.`stunden`)) AS `kosten` from (((`buchung` join `zwischentabelle` on((`zwischentabelle`.`id_eintrag` = `buchung`.`eintrag_id`))) join `projekt` on((`zwischentabelle`.`projekt_id` = `projekt`.`id_projekt`))) join `mitarbeiter` on((`zwischentabelle`.`mitarbeiter_id` = `mitarbeiter`.`id_mitarbeiter`))) group by `projekt`.`projektname` */;
432/*!50001 SET character_set_client = @saved_cs_client */;
433/*!50001 SET character_set_results = @saved_cs_results */;
434/*!50001 SET collation_connection = @saved_col_connection */;
435/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
436
437/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
438/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
439/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
440/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
441/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
442/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
443/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
444
445-- Dump completed on 2016-05-26 23:03:13