ue2D2PwV

1-- MySQL dump 10.13  Distrib 5.6.24, for Win32 (x86)
2--
3-- Host: localhost    Database: uebungen2
4-- ------------------------------------------------------
5-- Server version	5.6.24-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-- Current Database: `uebungen`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `uebungen` /*!40100 DEFAULT CHARACTER SET utf8 */;
23
24USE `uebungen`;
25
26--
27-- Table structure for table `t_abt`
28--
29
30DROP TABLE IF EXISTS `t_abt`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `t_abt` (
34  `id` int(11) NOT NULL AUTO_INCREMENT,
35  `name` varchar(100) DEFAULT NULL,
36  `ort` varchar(100) DEFAULT NULL,
37  PRIMARY KEY (`id`)
38) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `t_abt`
43--
44
45LOCK TABLES `t_abt` WRITE;
46/*!40000 ALTER TABLE `t_abt` DISABLE KEYS */;
47INSERT INTO `t_abt` VALUES (1,'Einkauf','Frankfurt'),(2,'Marketing','Berlin'),(3,'Verkauf','Hamburg'),(4,'Produktion','Wien'),(5,'Abt_Organisation','Berlin'),(6,'Controlling','Bern'),(7,'F&E','Zürich'),(8,'Personal','Berlin');
48/*!40000 ALTER TABLE `t_abt` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `t_artikel`
53--
54
55DROP TABLE IF EXISTS `t_artikel`;
56/*!40101 SET @saved_cs_client     = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `t_artikel` (
59  `id` int(11) NOT NULL AUTO_INCREMENT,
60  `name` varchar(100) NOT NULL DEFAULT '',
61  `code` varchar(30) NOT NULL DEFAULT '',
62  `lieferant` int(11) DEFAULT NULL,
63  `bemerkung` varchar(100) DEFAULT NULL,
64  PRIMARY KEY (`id`),
65  UNIQUE KEY `namecodeindex` (`name`,`code`)
66) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `t_artikel`
71--
72
73LOCK TABLES `t_artikel` WRITE;
74/*!40000 ALTER TABLE `t_artikel` DISABLE KEYS */;
75INSERT INTO `t_artikel` VALUES (22,'Bleistift B (10 Stück)','3423',1,NULL),(23,'Bleistift H (10 Stück)','3123',1,NULL),(33,'Füllhalter P1','4346',1,NULL),(35,'Füllhalter P','4344',2,NULL),(38,'Füllhalter P2 Rechtshänder','4322',1,NULL),(43,'Kugelschreiber KG1','5232',2,NULL),(44,'Kugelschreiber KG2','5223',2,NULL),(45,'Bleistift HB (10 Stück)','4342',1,NULL),(46,'Füllhalter P2 Linkshänder','4323',1,NULL),(47,'Füllhalter','4333',2,NULL),(48,'Kugelschreiber KG5','5222',2,NULL),(49,'Kugelschreiber Edel','5233',3,NULL),(50,'Fineliner (10 Stück)','4444',2,NULL);
76/*!40000 ALTER TABLE `t_artikel` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `t_lager`
81--
82
83DROP TABLE IF EXISTS `t_lager`;
84/*!40101 SET @saved_cs_client     = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `t_lager` (
87  `id` int(11) NOT NULL AUTO_INCREMENT,
88  `stueck` int(11) DEFAULT NULL,
89  `preis` float DEFAULT NULL,
90  PRIMARY KEY (`id`)
91) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;
92/*!40101 SET character_set_client = @saved_cs_client */;
93
94--
95-- Dumping data for table `t_lager`
96--
97
98LOCK TABLES `t_lager` WRITE;
99/*!40000 ALTER TABLE `t_lager` DISABLE KEYS */;
100INSERT INTO `t_lager` VALUES (22,267,22),(23,100,10),(33,134,8.5),(38,89,35.8),(45,156,9.5),(46,322,12),(47,46,24.8),(48,245,5.5),(49,144,14.6),(50,45,34);
101/*!40000 ALTER TABLE `t_lager` ENABLE KEYS */;
102UNLOCK TABLES;
103
104--
105-- Table structure for table `t_liefer`
106--
107
108DROP TABLE IF EXISTS `t_liefer`;
109/*!40101 SET @saved_cs_client     = @@character_set_client */;
110/*!40101 SET character_set_client = utf8 */;
111CREATE TABLE `t_liefer` (
112  `id` int(11) NOT NULL DEFAULT '0',
113  `name` varchar(150) DEFAULT NULL,
114  `plz` varchar(5) DEFAULT NULL,
115  `ort` varchar(100) DEFAULT NULL,
116  `str` varchar(100) DEFAULT NULL,
117  `hnr` varchar(5) DEFAULT NULL
118) ENGINE=InnoDB DEFAULT CHARSET=latin1;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `t_liefer`
123--
124
125LOCK TABLES `t_liefer` WRITE;
126/*!40000 ALTER TABLE `t_liefer` DISABLE KEYS */;
127INSERT INTO `t_liefer` VALUES (1,'Berger','10115','Berlin','Blumenstr.','3'),(2,'Knapp','21029','Hamburg','Brunnenstr.','31'),(3,'Schubert','60320','Frankfurt','Opernstr.','13');
128/*!40000 ALTER TABLE `t_liefer` ENABLE KEYS */;
129UNLOCK TABLES;
130/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
131/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
132/*!50003 SET @saved_col_connection = @@collation_connection */ ;
133/*!50003 SET character_set_client  = latin1 */ ;
134/*!50003 SET character_set_results = latin1 */ ;
135/*!50003 SET collation_connection  = latin1_swedish_ci */ ;
136/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
137/*!50003 SET sql_mode              = 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
138DELIMITER ;;
139/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER trig_liefer_nr BEFORE INSERT
140  ON t_liefer FOR EACH ROW BEGIN
141    DECLARE lid INTEGER;
142    IF (NEW.id = 0) THEN 
143      SELECT MAX(id)+1 FROM t_liefer INTO lid;
144      SET NEW.id = lid;
145    END IF;
146  END */;;
147DELIMITER ;
148/*!50003 SET sql_mode              = @saved_sql_mode */ ;
149/*!50003 SET character_set_client  = @saved_cs_client */ ;
150/*!50003 SET character_set_results = @saved_cs_results */ ;
151/*!50003 SET collation_connection  = @saved_col_connection */ ;
152
153--
154-- Table structure for table `t_m_p`
155--
156
157DROP TABLE IF EXISTS `t_m_p`;
158/*!40101 SET @saved_cs_client     = @@character_set_client */;
159/*!40101 SET character_set_client = utf8 */;
160CREATE TABLE `t_m_p` (
161  `ma_id` int(11) NOT NULL,
162  `id` text
163) ENGINE=InnoDB DEFAULT CHARSET=utf8;
164/*!40101 SET character_set_client = @saved_cs_client */;
165
166--
167-- Dumping data for table `t_m_p`
168--
169
170LOCK TABLES `t_m_p` WRITE;
171/*!40000 ALTER TABLE `t_m_p` DISABLE KEYS */;
172INSERT INTO `t_m_p` VALUES (2,'1'),(5,'1'),(8,'1'),(11,'1'),(36,'4'),(48,'4');
173/*!40000 ALTER TABLE `t_m_p` ENABLE KEYS */;
174UNLOCK TABLES;
175
176--
177-- Table structure for table `t_ma`
178--
179
180DROP TABLE IF EXISTS `t_ma`;
181/*!40101 SET @saved_cs_client     = @@character_set_client */;
182/*!40101 SET character_set_client = utf8 */;
183CREATE TABLE `t_ma` (
184  `id` int(11) NOT NULL AUTO_INCREMENT,
185  `name` varchar(50) DEFAULT NULL,
186  `vname` varchar(50) DEFAULT NULL,
187  `str` varchar(150) DEFAULT NULL,
188  `plz` varchar(5) DEFAULT NULL,
189  `ort` varchar(50) DEFAULT NULL,
190  `abtnr` int(11) DEFAULT NULL,
191  `hnr` varchar(5) DEFAULT NULL,
192  `gebdat` date DEFAULT NULL,
193  `land` varchar(4) DEFAULT 'D',
194  PRIMARY KEY (`id`)
195) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
196/*!40101 SET character_set_client = @saved_cs_client */;
197
198--
199-- Dumping data for table `t_ma`
200--
201
202LOCK TABLES `t_ma` WRITE;
203/*!40000 ALTER TABLE `t_ma` DISABLE KEYS */;
204INSERT INTO `t_ma` VALUES (1,'Fuchs','Peter','Martinplatz','22397','Hamburg',3,'70','1969-08-11','D'),(2,'Baumann','Lilly','Tannenstr.','21029','Hamburg',6,'49','1993-02-07','D'),(3,'Dorff','Norbert','Turmstr.','1060','Wien',4,'23','1968-12-23','AT'),(5,'Bayerle','Saskia','Buchenweg','8000','Zürich',7,'48','1976-06-05','CH'),(6,'Berger','Sebastian','Zentralplatz','60323','Frankfurt',1,'43','1986-05-15','D'),(7,'Kirsch','Karin','Albert-Schweitzer-Str.','1080','Wien',4,'47','1988-05-24','AT'),(8,'Bergstein','Roland','Waldstr.','21029','Hamburg',3,'16','1988-09-07','D'),(11,'Schwönsdorf','Lisa','Bahnhofstr.','1210','Wien',4,'1','1981-11-15','AT'),(12,'Luxemburg','Johann','Brunnenweg','22159','Hamburg',3,'78','1985-02-03','D'),(13,'Ülkü','Dilara','Lessingstr.','10179','Berlin',5,'12','1995-04-15','D'),(14,'Mannschatz','Annabell','Bahnhofstr.','60388','Frankfurt',1,'12','1967-07-06','D'),(15,'Nöller','Erwin','Industriestr.','21129','Hamburg',3,'4','1980-05-04','D'),(16,'Brio','Constantin','Hauptstr.','3005','Bern',6,'54','1977-04-21','CH'),(17,'Eppel','Andreas','Schillerstr.','1060','Wien',4,'9','1979-02-06','AT'),(18,'Classmann','Andrea','Buchenweg','8000','Zürich',7,'1','1985-02-02','CH'),(19,'Glahn','Stefanie','Ratsstr.','1080','Wien',4,'1','1978-05-02','AT'),(20,'Fiedler','Klaus','Schillerstr.','60388','Frankfurt',6,'3','1968-03-01','D'),(21,'Döring','Laura','Hafenweg','22111','Hamburg',3,'87','1969-03-01','D'),(22,'Margolin','Peter','Goethestr.','22159','Hamburg',3,'9','1973-04-21','D'),(23,'Seeau','Andrea','Goethestr.','10247','Berlin',2,'125','1976-11-16','D'),(24,'Klotz','Siglinde','Mittelstr.','1120','Wien',4,'75','1971-01-01','AT'),(25,'Stern','Hanna','Leibnizstr.','10247','Berlin',2,'23','1973-03-17','D'),(26,'Meier','Kerstin','Nordstr.','1120','Wien',4,'6','1966-12-27','AT'),(27,'Wolff','Gudrun','Hauptstr.','8038','Zürich',7,'32','1982-08-16','CH'),(28,'Ahrens','Enzo','Neugasse','1060','Wien',4,'62','1974-05-05','AT'),(29,'Schuster','Gabriele','Maienweg','22297','Hamburg',3,'89','1969-01-14','D'),(30,'Bläuel','Stefan','Rathausplatz','10119','Berlin',5,'1','1977-07-05','D'),(31,'Ebert','Jan','Wasserturmstr.','10119','Berlin',5,'44','1989-09-02','D'),(32,'Hallenbacher','Irmgart','Schillerstr.','22397','Hamburg',3,'29','1990-05-02','D'),(33,'Holzhäußer','Björn','Schillerstr.','8039','Zürich',2,'47 ','1976-03-24','CH'),(34,'Meyer','Matthias','Schulstr.','8038','Zürich',6,'6','1972-05-23','CH'),(35,'Walther','Steve','Siedlungsweg','3005','Bern',6,'12','1986-03-24','CH'),(36,'Meyer','Peter','Am Ring','60594','Frankfurt',1,'6','1974-08-13','D'),(37,'Bäumer','Paul','Keplerstr.','10115','Berlin',5,'49','1988-04-30','D'),(38,'Möller','Jochen','Am Kirchhof','22111','Hamburg',3,'23','1978-09-19','D'),(39,'Bonkowski','Hubert','Albert-Schweitzer-Str.','22111','Hamburg',3,'92','1974-03-14','D'),(40,'Eichenau','Maria','Alte Dorfstr.','10119','Berlin',2,'65','1987-05-15','D'),(41,'Guth','Stephan','Zentralplatz','10179','Berlin',2,'67','1975-12-06','D'),(42,'Berger','Sonja','Hauptstr.','21029','Hamburg',3,'37','1967-09-08','D'),(43,'Conolly','Sean','Goethestr.','8008','Zürich',7,'21','1976-04-26','CH'),(44,'Klapp','Frank','Buchenweg','22159','Hamburg',3,'46','1978-06-12','D'),(45,'Murnau','Anna','Goethestr.','1120','Wien',4,'78','1990-02-06','AT'),(46,'Untergärtner','Tobias','Ringstr.','21129','Hamburg',3,'26','1973-02-06','D'),(47,'Beyersdörfer','Ute','Ringstr.','10115','Berlin',5,'87','1985-08-12','D'),(48,'Elser','Stefano','Bahnhofstr.','22111','Hamburg',3,'20','1982-06-23','D'),(49,'Dröger','Maria','Ringstr.','1060','Wien',4,'53','1981-06-27','AT'),(50,'Kron-Köppers','Tina','Schillerstr.','10179','Berlin',2,'53','1975-11-06','D'),(51,'Stifter','Ansgar','Alte Gasse','1210','Wien',3,'21','1980-05-05','AT'),(52,'Mahn','Detlev','Goethestr.','1120','Wien',4,'27','1973-06-12','AT'),(53,'Zielecki','Norbert','Kleiststr.','21129','Hamburg',3,'32','1972-07-23','D'),(54,'Blücher','Barbara','Tannenstr.','8000','Zürich',3,'45','1995-01-26','CH'),(55,'Färber','Liane','Goethestr.','8008','Zürich',7,'23','1968-01-14','CH'),(56,'Holt','Sören','Eisenbahnstr.','1080','Wien',4,'23','1980-12-23','AT'),(57,'Loster-Schneider','Elena','Schulstr.','22159','Hamburg',3,'57','1976-12-21','D'),(58,'Maier','Frank','Mittelstr.','60320','Frankfurt',1,'37','1978-01-12','D'),(59,'Manz','Fridolin','Hauptstr.','1120','Wien',4,'89','1988-02-03','AT'),(60,'Otterstädter','Charlotte','Baumschulenweg','1210','Wien',4,'7','1978-08-12','AT'),(61,'Seiler','Jacqueline','Kantonsstr.','3001','Bern',5,'14','1987-03-04','CH'),(62,'Schmadtke','Chris','Friedensplatz','60388','Frankfurt',1,'99','1973-07-08','D'),(63,'Segebrecht','Annemarie','Taunusweg','60594','Frankfurt',1,'5','1971-07-11','D'),(64,'Trieschmann','Lars','Eisenbahnstr..','8038','Zürich',3,'58','1977-04-06','CH'),(65,'Unterwegner','Daniel','Zentralplatz','1210','Wien',4,'45','1991-09-05','AT'),(66,'Brauer','Sophie','Albert-Schweitzer-Str.','60320','Frankfurt',1,'48','1981-06-13','D'),(67,'Carstedt','Sabine','Goethestr.','60323','Frankfurt',1,'46','1969-08-12','D'),(68,'Eberspächer','Gerlinde','Bahnhofstr.','8008','Zürich',7,'45','1994-03-23','CH'),(69,'Frawley','Lutz','Schwedenstr.','22397','Hamburg',3,'21','1979-09-09','D');
205/*!40000 ALTER TABLE `t_ma` ENABLE KEYS */;
206UNLOCK TABLES;
207
208--
209-- Table structure for table `t_ma_proj`
210--
211
212DROP TABLE IF EXISTS `t_ma_proj`;
213/*!40101 SET @saved_cs_client     = @@character_set_client */;
214/*!40101 SET character_set_client = utf8 */;
215CREATE TABLE `t_ma_proj` (
216  `ma_id` int(11) NOT NULL,
217  `proj_id` int(11) NOT NULL,
218  KEY `ma_id` (`ma_id`),
219  KEY `proj_id` (`proj_id`),
220  CONSTRAINT `t_ma_proj_ibfk_1` FOREIGN KEY (`ma_id`) REFERENCES `t_ma` (`id`) ON DELETE CASCADE,
221  CONSTRAINT `t_ma_proj_ibfk_2` FOREIGN KEY (`proj_id`) REFERENCES `t_proj` (`id`) ON DELETE CASCADE
222) ENGINE=InnoDB DEFAULT CHARSET=utf8;
223/*!40101 SET character_set_client = @saved_cs_client */;
224
225--
226-- Dumping data for table `t_ma_proj`
227--
228
229LOCK TABLES `t_ma_proj` WRITE;
230/*!40000 ALTER TABLE `t_ma_proj` DISABLE KEYS */;
231INSERT INTO `t_ma_proj` VALUES (2,1),(5,1),(8,1),(11,1),(36,4),(48,4);
232/*!40000 ALTER TABLE `t_ma_proj` ENABLE KEYS */;
233UNLOCK TABLES;
234
235--
236-- Table structure for table `t_produkt`
237--
238
239DROP TABLE IF EXISTS `t_produkt`;
240/*!40101 SET @saved_cs_client     = @@character_set_client */;
241/*!40101 SET character_set_client = utf8 */;
242CREATE TABLE `t_produkt` (
243  `id` int(11) NOT NULL AUTO_INCREMENT,
244  `name` varchar(50) DEFAULT NULL,
245  `bemerk` varchar(100) DEFAULT NULL,
246  `datum` date DEFAULT NULL,
247  PRIMARY KEY (`id`),
248  KEY `i_produkt_name` (`name`)
249) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
250/*!40101 SET character_set_client = @saved_cs_client */;
251
252--
253-- Dumping data for table `t_produkt`
254--
255
256LOCK TABLES `t_produkt` WRITE;
257/*!40000 ALTER TABLE `t_produkt` DISABLE KEYS */;
258INSERT INTO `t_produkt` VALUES (1,'Dübel M4','lieferbar','2015-05-01'),(2,'Dübel M6','lieferbar','2015-03-01'),(3,'Dübel M8','lieferbar','2015-05-01'),(4,'Schraube M10','lieferbar','2015-04-01'),(5,'Mutter M4','lieferbar','2015-05-01'),(6,'Mutter M6','lieferbar','2015-05-01'),(7,'Mutter M8','lieferbar','2015-04-01'),(8,'Mutter M10','lieferbar','2015-05-01'),(9,'Unterlegscheibe M4','lieferbar','2015-05-01'),(10,'Unterlegscheibe M6','lieferbar','2015-05-01'),(11,'Unterlegscheibe M8','lieferbar','2015-05-01'),(12,'Unterlegscheibe M10','lieferbar','2015-03-01');
259/*!40000 ALTER TABLE `t_produkt` ENABLE KEYS */;
260UNLOCK TABLES;
261
262--
263-- Table structure for table `t_proj`
264--
265
266DROP TABLE IF EXISTS `t_proj`;
267/*!40101 SET @saved_cs_client     = @@character_set_client */;
268/*!40101 SET character_set_client = utf8 */;
269CREATE TABLE `t_proj` (
270  `id` int(11) NOT NULL AUTO_INCREMENT,
271  `name` varchar(50) DEFAULT NULL,
272  `beginn` date DEFAULT NULL,
273  `ende` date DEFAULT NULL,
274  PRIMARY KEY (`id`)
275) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
276/*!40101 SET character_set_client = @saved_cs_client */;
277
278--
279-- Dumping data for table `t_proj`
280--
281
282LOCK TABLES `t_proj` WRITE;
283/*!40000 ALTER TABLE `t_proj` DISABLE KEYS */;
284INSERT INTO `t_proj` VALUES (1,'Buchprojekt','2014-11-01','2015-05-20'),(2,'Renovierung des EDV3','2015-02-01','2015-05-28'),(3,'Anlegen eines Pflichtenheftes','2015-02-10','2015-04-21'),(4,'Kundenumfrage','2015-03-01','2015-06-30');
285/*!40000 ALTER TABLE `t_proj` ENABLE KEYS */;
286UNLOCK TABLES;
287
288--
289-- Table structure for table `temp_t_liefer`
290--
291
292DROP TABLE IF EXISTS `temp_t_liefer`;
293/*!40101 SET @saved_cs_client     = @@character_set_client */;
294/*!40101 SET character_set_client = utf8 */;
295CREATE TABLE `temp_t_liefer` (
296  `id` int(11) NOT NULL,
297  `name` varchar(30) DEFAULT NULL,
298  `plz` varchar(5) DEFAULT NULL,
299  `ort` varchar(30) DEFAULT NULL,
300  `str` varchar(40) DEFAULT NULL,
301  `hnr` varchar(5) DEFAULT NULL,
302  PRIMARY KEY (`id`)
303) ENGINE=InnoDB DEFAULT CHARSET=utf8;
304/*!40101 SET character_set_client = @saved_cs_client */;
305
306--
307-- Dumping data for table `temp_t_liefer`
308--
309
310LOCK TABLES `temp_t_liefer` WRITE;
311/*!40000 ALTER TABLE `temp_t_liefer` DISABLE KEYS */;
312INSERT INTO `temp_t_liefer` VALUES (1,'Huber','10115','Berlin','Blumenstr.','3'),(2,'Meier','21029','Hamburg','Brunnenstr.','31'),(3,'Fink','60320','Frankfurt','Opernstr.','13');
313/*!40000 ALTER TABLE `temp_t_liefer` ENABLE KEYS */;
314UNLOCK TABLES;
315/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
316
317/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
318/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
319/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
320/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
321/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
322/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
323/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
324
325-- Dump completed on 2015-06-04 14:40:32