· 8 years ago · Apr 24, 2018, 12:22 PM
1-- Host: localhost Database: vorlesung_db1
2-- ------------------------------------------------------
3-- Server version 5.5.12
4
5/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
6/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
7/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
8/*!40101 SET NAMES utf8 */;
9/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
10/*!40103 SET TIME_ZONE='+00:00' */;
11/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
15
16--
17-- Table structure for table `abteilung`
18--
19
20DROP TABLE IF EXISTS `abteilung`;
21/*!40101 SET @saved_cs_client = @@character_set_client */;
22/*!40101 SET character_set_client = utf8 */;
23CREATE TABLE `abteilung` (
24 `abteilungsnr` int(11) NOT NULL AUTO_INCREMENT,
25 `bezeichnung` varchar(255) DEFAULT NULL,
26 PRIMARY KEY (`abteilungsnr`)
27) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
28/*!40101 SET character_set_client = @saved_cs_client */;
29
30--
31-- Dumping data for table `abteilung`
32--
33
34LOCK TABLES `abteilung` WRITE;
35/*!40000 ALTER TABLE `abteilung` DISABLE KEYS */;
36INSERT INTO `abteilung` VALUES (1,'Geschäftsführung'),(2,'Support'),(3,'Rechnungswesen'),(4,'Einkauf'),(5,'Vertrieb'),(6,'Verwaltung');
37/*!40000 ALTER TABLE `abteilung` ENABLE KEYS */;
38UNLOCK TABLES;
39
40--
41-- Table structure for table `adressen`
42--
43
44DROP TABLE IF EXISTS `adressen`;
45/*!40101 SET @saved_cs_client = @@character_set_client */;
46/*!40101 SET character_set_client = utf8 */;
47CREATE TABLE `adressen` (
48 `name` varchar(255) DEFAULT NULL,
49 `voname` varchar(255) DEFAULT NULL,
50 `plz` varchar(255) DEFAULT NULL,
51 `ort` varchar(255) DEFAULT NULL
52) ENGINE=MyISAM DEFAULT CHARSET=utf8;
53/*!40101 SET character_set_client = @saved_cs_client */;
54
55--
56-- Dumping data for table `adressen`
57--
58
59LOCK TABLES `adressen` WRITE;
60/*!40000 ALTER TABLE `adressen` DISABLE KEYS */;
61/*!40000 ALTER TABLE `adressen` ENABLE KEYS */;
62UNLOCK TABLES;
63
64--
65-- Table structure for table `artikel`
66--
67
68DROP TABLE IF EXISTS `artikel`;
69/*!40101 SET @saved_cs_client = @@character_set_client */;
70/*!40101 SET character_set_client = utf8 */;
71CREATE TABLE `artikel` (
72 `artikelnr` int(11) NOT NULL AUTO_INCREMENT,
73 `bezeichnung` varchar(255) DEFAULT NULL,
74 `hersteller` int(11) DEFAULT NULL,
75 `nettopreis` float DEFAULT NULL,
76 `mwst` int(11) DEFAULT NULL,
77 `bestand` int(11) DEFAULT NULL,
78 `mindestbestand` int(11) DEFAULT NULL,
79 `kategorie` int(11) DEFAULT NULL,
80 `bestellvorschlag` varchar(255) DEFAULT NULL,
81 PRIMARY KEY (`artikelnr`)
82) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
83/*!40101 SET character_set_client = @saved_cs_client */;
84
85--
86-- Dumping data for table `artikel`
87--
88
89LOCK TABLES `artikel` WRITE;
90/*!40000 ALTER TABLE `artikel` DISABLE KEYS */;
91INSERT INTO `artikel` VALUES (1,'106075',1,137.93,2,100,10,1,'1'),(2,'106055',1,172.14,2,100,10,1,'1'),(3,'753S',2,111.21,2,100,10,1,'1'),(4,'757P',2,145.69,2,100,10,1,'1'),(5,'1200NF',2,602.59,2,100,10,1,'0'),(6,'CanoScan LiDE 20',7,47.41,2,100,10,2,'1'),(7,'CanoScan 5000F',7,132.76,2,100,10,2,'0'),(8,'Perfection1670',8,81.03,2,100,10,2,'0'),(9,'ScanJet 2400',4,63.79,2,100,10,2,'1'),(10,'ScanJet 8290',4,1507.76,2,100,10,2,'1'),(11,'Millenium G450',5,81.03,2,100,10,3,'0'),(12,'Millenium G550',5,85.34,2,100,10,3,'0'),(13,'Millenium G650',5,137.07,2,100,10,3,'1'),(14,'Millenium P750',5,197.41,2,100,10,3,'1'),(15,'Parhelia 512',5,309.48,2,100,10,3,'1'),(16,'SV0802N',2,55.17,2,100,10,4,'1'),(17,'SP0802N',2,63.79,2,100,10,4,'0'),(18,'SV1203N',2,72.41,2,100,10,4,'1'),(19,'SP1604N',2,93.97,2,100,10,4,'1'),(20,'MHT2060AH',9,197.41,2,100,10,4,'0'),(21,'Aureon 5.1 Fun',6,33.62,2,100,10,5,'1'),(22,'Aureon 5.1 Fun Games',6,42.24,2,100,10,5,'1'),(23,'Aureon 5.1 Sky',6,68.1,2,100,10,5,'1'),(24,'Aureon 5.1 USB',6,85.34,2,100,10,5,'0'),(25,'Aureon 5.1 Universe',6,206.03,2,100,10,5,'0'),(26,'Internet Keyboard',10,17.23,2,100,10,6,'0'),(27,'Office Keyboard',10,25.85,2,100,10,6,'1'),(28,'Natural MultiMedia',10,23.28,2,100,10,6,'1'),(29,'MultiMedia Keyboard refresh',10,27.59,2,100,10,6,'0'),(30,'WL Optical Desctop for Bluetooth',10,128.45,2,100,10,6,'1'),(31,'DeskJet 3520',4,33.62,2,100,10,7,'1'),(32,'OfficeJet 7140xi',4,539.97,2,100,10,7,'0'),(33,'LaserJet 1150',4,240.51,2,100,10,7,'1'),(34,'i250',7,46.55,2,100,10,7,'1'),(35,'BJC-5500',7,645.69,2,100,10,7,'0'),(36,'Stylus C44 Plus',8,46.55,2,100,10,7,'0'),(37,'Stylus Photo R300',8,150,2,100,10,7,'1'),(38,'Basic Optical Mouse SB',10,12.07,2,100,10,10,'1'),(39,'Mouse Blue',10,25,2,100,10,10,'1'),(40,'Wireless InteliMouse Explorer BT',10,72.41,2,100,10,10,'0'),(41,'Windows 2000 Professional',10,124.14,2,100,10,8,'0'),(42,'Windows XP Home Edition',10,101.97,2,100,10,8,'1'),(43,'Office XP Pro',10,516.38,2,100,10,8,'1'),(44,'Visual Studio.NET 2003',10,1766.38,2,100,10,8,'1'),(45,'Works Suite 2004',10,93.97,2,100,10,8,'1'),(46,'SC-152A',2,13.79,2,100,10,9,'1'),(47,'SW252',2,33.62,2,100,10,9,'0'),(48,'SM-352',2,59.48,2,100,10,9,'1'),(49,'SD-616',2,25,2,100,10,9,'1'),(50,'SC-152A schwarz',2,14.66,2,100,10,9,'1');
92/*!40000 ALTER TABLE `artikel` ENABLE KEYS */;
93UNLOCK TABLES;
94
95--
96-- Table structure for table `bestellung`
97--
98
99DROP TABLE IF EXISTS `bestellung`;
100/*!40101 SET @saved_cs_client = @@character_set_client */;
101/*!40101 SET character_set_client = utf8 */;
102CREATE TABLE `bestellung` (
103 `bestellnr` int(11) NOT NULL AUTO_INCREMENT,
104 `kundennr` int(11) DEFAULT NULL,
105 `bestelldatum` date DEFAULT NULL,
106 `lieferdatum` date DEFAULT NULL,
107 `rechnungsbetrag` float DEFAULT NULL,
108 PRIMARY KEY (`bestellnr`)
109) ENGINE=MyISAM AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
110/*!40101 SET character_set_client = @saved_cs_client */;
111
112--
113-- Dumping data for table `bestellung`
114--
115
116LOCK TABLES `bestellung` WRITE;
117/*!40000 ALTER TABLE `bestellung` DISABLE KEYS */;
118INSERT INTO `bestellung` VALUES (1,1,'2006-01-02','2006-01-11',359.68),(2,2,'2006-01-02','2006-01-11',107.99),(3,3,'2006-01-02','2006-01-11',322.99),(4,4,'2006-01-02','2006-01-11',109),(5,5,'2006-01-02','2006-01-12',109),(6,6,'2006-01-03','2006-01-13',31.99),(7,7,'2006-01-03','2006-01-11',267.99),(8,8,'2006-01-03','2006-01-12',98.99),(9,9,'2006-01-04','2006-01-10',29),(10,10,'2006-01-04','2006-01-11',388),(11,11,'2006-01-04','2006-01-16',229),(12,12,'2006-01-04','2006-01-14',54),(13,13,'2006-01-04','2006-01-14',173),(14,14,'2006-01-04','2006-01-15',164.99),(15,15,'2006-01-05','2006-01-13',54),(16,16,'2006-01-05','2006-01-12',156),(17,17,'2006-01-06','2006-01-13',54),(18,18,'2006-01-07','2006-01-18',54),(19,19,'2006-01-07','2006-01-11',144),(20,20,'2006-01-08','2006-01-12',74),(21,21,'2006-01-08','2006-01-11',599.05),(22,22,'2006-01-08','2006-01-12',109.01),(23,23,'2006-01-10','2006-01-15',626.37),(24,24,'2006-01-10','2006-01-14',457.99),(25,25,'2006-01-10','2006-01-15',27),(26,9,'2006-01-10','2006-01-14',171.99),(27,26,'2006-01-11','2006-01-17',54),(28,27,'2006-01-11','2006-01-19',84),(29,28,'2006-01-11','2006-01-15',797.99),(30,29,'2006-01-11','2006-01-16',81.01),(31,30,'2006-01-12','2006-01-18',359),(32,31,'2006-01-12','2006-01-17',84),(33,15,'2006-01-12','2006-01-18',28),(34,32,'2006-01-12','2006-01-18',169),(35,33,'2006-01-14','2006-01-19',239),(36,4,'2006-01-15','2006-01-19',736.36),(37,34,'2006-01-15','2006-01-20',109.01),(38,35,'2006-01-15','2006-01-19',118.29),(39,36,'2006-01-16','2006-01-19',148.99),(40,37,'2006-01-16','2006-01-20',74),(41,38,'2006-01-16','2006-01-21',188),(42,39,'2006-01-17','2006-01-21',59.97),(43,40,'2006-01-17','2006-01-22',84),(44,41,'2006-01-17','2006-01-22',98.99),(45,42,'2006-01-17','2006-01-21',154),(46,23,'2006-01-18','2006-01-23',14),(47,43,'2006-01-18','2006-01-24',39),(48,44,'2006-01-19','2006-01-24',0),(49,45,'2006-01-19','2006-01-22',626.37),(50,46,'2006-01-19','2006-01-24',127.99),(51,47,'2006-01-20','2006-01-23',198),(52,7,'2006-01-20','2006-01-24',81.01),(53,48,'2006-01-21','2006-01-25',54),(54,49,'2006-01-21','2006-01-26',144),(55,50,'2006-01-22','2006-01-26',457.99),(56,51,'2006-01-22','2006-01-25',32),(57,42,'2006-01-23','2006-01-30',160),(58,52,'2006-01-23','2006-01-27',84),(59,53,'2006-01-23','2006-01-28',1252.73),(60,54,'2006-01-23','2006-01-27',98.99),(61,55,'2006-01-23','2006-01-28',258.01),(62,56,'2006-01-23','2006-01-28',201.99),(63,57,'2006-01-24','2006-01-27',169),(64,58,'2006-01-24','2006-01-28',397.28),(65,2,'2006-01-24','2006-01-27',3798),(66,59,'2006-01-24','2006-01-28',131.98),(67,60,'2006-01-24','2006-01-27',308.98),(68,29,'2006-01-24','2006-01-29',159),(69,61,'2006-01-24','2006-01-28',462),(70,62,'2006-01-24','2006-01-30',150),(71,36,'2006-01-25','2006-01-28',82),(72,63,'2006-01-25','2006-01-30',4235.97),(73,64,'2006-01-25','2006-01-30',768),(74,17,'2006-01-25','2006-01-29',2442.26),(75,43,'2006-01-25','2006-01-30',1506.26),(76,65,'2006-01-26','2006-01-30',1429.38),(77,66,'2006-01-26','2006-01-31',1699.98),(78,67,'2006-01-26','2006-01-29',839.99),(79,68,'2006-01-26','2006-01-31',198),(80,58,'2006-01-26','2006-02-01',152.99),(81,69,'2006-01-26','2006-01-30',1034.98),(82,70,'2006-01-26','2006-01-31',1052.36),(83,5,'2006-01-26','2006-01-31',103),(84,72,'2006-01-26','2006-02-01',79),(85,73,'2006-01-27','2006-01-30',2049),(86,28,'2006-01-27','2006-02-01',2230.01),(87,74,'2006-01-27','2006-02-01',699),(88,75,'2006-01-27','2006-02-02',39),(89,63,'2006-01-27','2006-02-01',174),(90,76,'2006-01-27','2006-02-01',359),(91,77,'2006-01-27','2006-02-02',324.99),(92,47,'2006-01-28','2006-02-01',278.99),(93,78,'2006-01-28','2006-02-02',457.99),(94,79,'2006-01-28','2006-02-01',32),(95,55,'2006-01-28','2006-02-03',118.29),(96,80,'2006-01-28','2006-02-01',1908),(97,81,'2006-01-28','2006-02-03',79),(98,83,'2006-01-28','2006-02-05',169),(99,73,'2006-01-28','2006-02-04',1198),(100,84,'2006-01-28','2006-02-03',749),(101,85,'2006-01-28','2006-02-05',507.69),(102,39,'2006-01-28','2006-02-04',118.29),(103,86,'2006-01-29','2006-02-05',278.99),(104,23,'2006-01-29','2006-02-04',127.99),(105,87,'2006-01-29','2006-02-06',79),(106,88,'2006-01-29','2006-02-04',84),(107,62,'2006-01-29','2006-02-04',159.96),(108,89,'2006-01-29','2006-02-04',747.36),(109,90,'2006-01-31','2006-02-11',531.99),(110,91,'2006-02-01','2006-02-11',109.01),(111,92,'2006-02-01','2006-02-09',83.98),(112,88,'2006-02-01','2006-02-07',293.99),(113,35,'2006-02-01','2006-02-09',552.99),(114,8,'2006-02-01','2006-02-08',193.99),(115,82,'2006-02-01','2006-02-05',187.99),(116,93,'2006-02-02','2006-02-11',98.99),(117,72,'2006-02-02','2006-02-10',31),(118,61,'2006-02-02','2006-02-06',616.01),(119,4,'2006-02-02','2006-02-09',277.99),(120,94,'2006-02-02','2006-02-08',477.99),(121,95,'2006-02-03','2006-02-10',39),(122,48,'2006-02-03','2006-02-11',699),(123,29,'2006-02-03','2006-02-10',3131.83),(124,96,'2006-02-03','2006-02-09',532.99),(125,82,'2006-02-03','2006-02-11',84),(126,63,'2006-02-03','2006-02-10',29),(127,72,'2006-02-03','2006-02-11',109.01),(128,39,'2006-02-03','2006-02-11',137),(129,51,'2006-02-04','2006-02-11',118.29),(130,13,'2006-02-04','2006-02-11',318),(131,47,'2006-02-04','2006-02-11',14),(132,97,'2006-02-04','2006-02-10',74),(133,64,'2006-02-04','2006-02-11',78),(134,9,'2006-02-04','2006-02-10',278.99),(135,98,'2006-02-04','2006-02-11',1898),(136,99,'2006-02-04','2006-02-12',16),(137,14,'2006-02-05','2006-02-10',1452.01),(138,71,'2006-02-05','2006-02-11',98.99),(139,44,'2006-02-05','2006-02-12',174),(140,57,'2006-02-05','2006-02-09',84),(141,6,'2006-02-05','2006-02-10',497),(142,12,'2006-02-05','2006-02-11',69),(143,100,'2006-02-06','2006-02-11',169),(144,17,'2006-02-06','2006-02-11',278.99),(145,73,'2006-02-06','2006-02-12',728.84),(146,38,'2006-02-06','2006-02-11',129),(147,25,'2006-02-06','2006-02-12',54),(148,83,'2006-02-07','2006-02-13',19.99),(149,69,'2006-02-07','2006-02-12',183),(150,46,'2006-02-07','2006-02-13',320),(999,1,'2006-03-27','2006-04-06',NULL),(421,1,'2006-03-27','2006-04-06',231.1),(422,1,'2006-03-27','2006-04-06',231.1);
119/*!40000 ALTER TABLE `bestellung` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `geburtstag`
124--
125
126DROP TABLE IF EXISTS `geburtstag`;
127/*!40101 SET @saved_cs_client = @@character_set_client */;
128/*!40101 SET character_set_client = utf8 */;
129CREATE TABLE `geburtstag` (
130 `gebnr` int(11) DEFAULT NULL,
131 `name` varchar(255) DEFAULT NULL,
132 `vorname` varchar(255) DEFAULT NULL
133) ENGINE=MyISAM DEFAULT CHARSET=utf8;
134/*!40101 SET character_set_client = @saved_cs_client */;
135
136--
137-- Dumping data for table `geburtstag`
138--
139
140LOCK TABLES `geburtstag` WRITE;
141/*!40000 ALTER TABLE `geburtstag` DISABLE KEYS */;
142/*!40000 ALTER TABLE `geburtstag` ENABLE KEYS */;
143UNLOCK TABLES;
144
145--
146-- Table structure for table `hersteller`
147--
148
149DROP TABLE IF EXISTS `hersteller`;
150/*!40101 SET @saved_cs_client = @@character_set_client */;
151/*!40101 SET character_set_client = utf8 */;
152CREATE TABLE `hersteller` (
153 `herstellernr` int(11) NOT NULL AUTO_INCREMENT,
154 `name` varchar(255) DEFAULT NULL,
155 PRIMARY KEY (`herstellernr`)
156) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
157/*!40101 SET character_set_client = @saved_cs_client */;
158
159--
160-- Dumping data for table `hersteller`
161--
162
163LOCK TABLES `hersteller` WRITE;
164/*!40000 ALTER TABLE `hersteller` DISABLE KEYS */;
165INSERT INTO `hersteller` VALUES (1,'Belinea'),(2,'Samsung'),(3,'Sony'),(4,'HP'),(5,'Matrox'),(6,'Terratec'),(7,'Canon'),(8,'Epson'),(9,'Fujitsu'),(10,'Microsoft');
166/*!40000 ALTER TABLE `hersteller` ENABLE KEYS */;
167UNLOCK TABLES;
168
169--
170-- Table structure for table `jobticket`
171--
172
173DROP TABLE IF EXISTS `jobticket`;
174/*!40101 SET @saved_cs_client = @@character_set_client */;
175/*!40101 SET character_set_client = utf8 */;
176CREATE TABLE `jobticket` (
177 `id` int(11) NOT NULL AUTO_INCREMENT,
178 `mitarbeiternr` int(11) DEFAULT NULL,
179 `gueltig_bis` date DEFAULT NULL,
180 PRIMARY KEY (`id`)
181) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
182/*!40101 SET character_set_client = @saved_cs_client */;
183
184--
185-- Dumping data for table `jobticket`
186--
187
188LOCK TABLES `jobticket` WRITE;
189/*!40000 ALTER TABLE `jobticket` DISABLE KEYS */;
190INSERT INTO `jobticket` VALUES (1,1,'2007-01-01'),(2,3,'2007-01-01');
191/*!40000 ALTER TABLE `jobticket` ENABLE KEYS */;
192UNLOCK TABLES;
193
194--
195-- Table structure for table `kategorie`
196--
197
198DROP TABLE IF EXISTS `kategorie`;
199/*!40101 SET @saved_cs_client = @@character_set_client */;
200/*!40101 SET character_set_client = utf8 */;
201CREATE TABLE `kategorie` (
202 `kategorienr` int(11) NOT NULL AUTO_INCREMENT,
203 `bezeichnung` varchar(255) DEFAULT NULL,
204 PRIMARY KEY (`kategorienr`)
205) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `kategorie`
210--
211
212LOCK TABLES `kategorie` WRITE;
213/*!40000 ALTER TABLE `kategorie` DISABLE KEYS */;
214INSERT INTO `kategorie` VALUES (1,'Monitore'),(2,'Scanner'),(3,'Grafikkarten'),(4,'Festplatten'),(5,'Soundkarten'),(6,'Keyboards'),(7,'Drucker'),(8,'Software'),(9,'Laufwerke'),(10,'Mäuse');
215/*!40000 ALTER TABLE `kategorie` ENABLE KEYS */;
216UNLOCK TABLES;
217
218--
219-- Table structure for table `kunde`
220--
221
222DROP TABLE IF EXISTS `kunde`;
223/*!40101 SET @saved_cs_client = @@character_set_client */;
224/*!40101 SET character_set_client = utf8 */;
225CREATE TABLE `kunde` (
226 `kundennr` int(11) NOT NULL AUTO_INCREMENT,
227 `name` varchar(255) DEFAULT NULL,
228 `vorname` varchar(255) DEFAULT NULL,
229 `strasse` varchar(255) DEFAULT NULL,
230 `plz` varchar(255) DEFAULT NULL,
231 `ort` varchar(255) DEFAULT NULL,
232 `telefon_gesch` varchar(255) DEFAULT NULL,
233 `telefon_privat` varchar(255) DEFAULT NULL,
234 `email` varchar(255) DEFAULT NULL,
235 `zahlungsart` varchar(255) DEFAULT NULL,
236 PRIMARY KEY (`kundennr`)
237) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
238/*!40101 SET character_set_client = @saved_cs_client */;
239
240--
241-- Dumping data for table `kunde`
242--
243
244LOCK TABLES `kunde` WRITE;
245/*!40000 ALTER TABLE `kunde` DISABLE KEYS */;
246INSERT INTO `kunde` VALUES (1,'Loewe','Arthur','Sebastianstraße 134','50737','Köln','','19467383','','B'),(2,'Adler','Felix','Goethestraße 4','30453','Hannover','9856023452','10562382','adler@on-line.de','R'),(3,'Stein','Johannes','Elisabethenstr. 23','53111','Bonn','99746227','99746228','johnny@hip.de','N'),(4,'Falkner','Michael','Querfeldstraße 21','65187','Wiesbaden','13726583','48892768','mischa24@wysiwyg.com','V'),(5,'Lederer','Helene','Rennbahnstraße 6','50733','Köln','87126534','32675491','lele@lederer-world.de','K'),(6,'Kogen','Arnold','Clara-Viebig-Straße 17','53179','Bonn','','55819269','','B'),(7,'Schneider','Benedikt','Vahrendorfer Stadtweg 61','21075','Hamburg','','93728815','benni@postfach-online.de','B'),(8,'Dietrich','Diana','Kastanienallee 675','65199','Wiesbaden','','56112894','diedietrich@on-line.de','V'),(9,'Voglin','Jakob','Engeldamm 34','12487','Berlin','999657324','12432673','voglin@berliner-tagblatt.de','K'),(10,'Stern','Martin','Knaufstraße 453','50858','Köln','72891174','17582964','martin.stern@on-line.de','B'),(11,'Marsch','Ronald','Große Telegraphenstraße 95','50769','Köln','16547326','99234713','ronnie@on-line.de','B'),(12,'Fromkess','Leon','Schmittgasser Kirchweg 44','53129','Bonn','67346248','19684375','leon.fromkess@lola.com','R'),(13,'Badel','Sarah','Am Ginsterpfad 74','51147','Köln','17483763','82675271','s.badel@on-line.de','R'),(14,'Schäfer','Willi','Bei der blauen Brücke 119','22083','Hamburg','02857204','86756251','schaefer32@lola.com','R'),(15,'Front','Jeremias','Reichskanzlerstraße 71','22525','Hamburg','5685710','86957248','jerry@gartenlaubenfreunde.de','B'),(16,'Wilhelms','Simon','Gustav-Freytag-Straße 22','51069','Köln','19785737','98760438','','N'),(17,'Grunpeter','Sascha','Pascalstraße 64','52121','Bonn','918574736','11768462','sagrun@lola.com','R'),(18,'Marx','Alfred','Gabriele-Muenter-Straße 102','51371','Leverkusen','02759285','849647286','alfred_marx@on-line.de','R'),(19,'Kops','Bernhard','Gunther-Plüschow-Straße 47','50739','Köln','10675849','61969285','berniekops@lola.com','B'),(20,'Elson','Andrea','Herzog-Alf-Weg 13','20459','Hamburg','28795823','967584483','elson@elsons-laedchen.de','R'),(21,'Kaplan','Marvin','Oskar-Schlemmer-Straße 72','50933','Köln','','96857385','marvin@marc-aurel-jg-2001.de','K'),(22,'Glaister','Gabrielle','Simrockallee 2','53227','Bonn','97857358','304760583','gabyglaister@on-line.de','N'),(23,'Knutt','Robert','Metzgerstraße 81','52076','Aachen','29786682','10684937','robert@robert-knutt.de','B'),(24,'Reiner','Robert','Pattscheider Weg 7','51147','Köln','19587238','017589375','meathead@lola.com','B'),(25,'Grunert','Paul','Jütländer Allee 236','22415','Hamburg','19473825','47294978','paul@briefmarken-hamburg.de','R'),(26,'Free','Oliver','Pferdmengesstraße 58','50672','Köln','19473067','94728395','ollifree@fc-koelle-for-ever.de','K'),(27,'Frankau','Nicholas','Rennbahnstraße 83','65207','Wiesbaden','10264738','91650376','nick.frank@on-line.de','R'),(28,'Weinberger','Eduard','Modersohnstraße 112','10965','Berlin','57480399','10275748','weinberger@lola.com','K'),(29,'Mann','Miriam','Wielandplatz 8','99425','Weimar','19786854','19786743','miriam-mann@on-line.de','N'),(30,'Waring','Georg','Merkenicher Ringstraße 313','51103','Köln','01896748','71835738','waring@polstermoebel-schmidt.de','R'),(31,'Locke','Albert','Bundesgrenzschutzplatz 32','53177','Bonn','47382765','19684758','Bertie@Wooster.de','K'),(32,'Mills','Michael','Im Grund 4','51063','Köln','86758685','10894519','michael@mills-and-more.de','R'),(33,'Brisebois','Danielle','Bismarckstraße 9','53721','Siegburg','91856748','27685710','danielle@tricatel.fr','R'),(34,'Dorning','Robert','Hunnebeckweg 21','48147','Münster','57483910','153424352','dorne@hip.de','N'),(35,'Sperber','Milo','Zypressenweg 3','22457','Hamburg','67582978','564736540','milo@lola.com','B'),(36,'Fabrizi','Mario','Auf dem Hunnenrücken 19','50999','Köln','142398079','09978699','mario.fabrizi@on-line.de','K'),(37,'Anderson','Margarete','Machabäerstraße 34','50735','Köln','27685741','09987890','gretel.anderson@on-line.de','V'),(38,'May','Jakob','In der Dasladen 9','51373','Leverkusen','197869504','19785673','mayday@pc-helfer-leverkusen.de','N'),(39,'Palk','Anna','Winston-Churchill-Straße 80','53129','Bonn','197867513','154635241','anpal@on-line.de','R'),(40,'Kaufmann','Andreas','Am Alten Brauhaus 11','51105','Köln','0796835460','01758362','andy@koelner-taxis.de','V'),(41,'Bussell','Mark','Hanfgartenstraße 63','81475','München','473829201','13246359','bussell@bavaria-bank.de','R'),(42,'Clement','Richard','Fröbelstraße 26','12161','Berlin','','57297867','clem@on-line.de','B'),(43,'Handl','Irene','Berberitzenweg 7','50678','Köln','84736291','98675842','irenehandl@lola.com','R'),(44,'Landesberg','Stefan','Kleiner Griechenmarkt 19','51107','Köln','08978569','186759472','Steve@metal-rules.de','N'),(45,'Lenhart','Heidi','Mozartstraße 73','51371','Leverkusen','19705832','879685740','heidi@montana-dreaming.de','R'),(46,'Wendt','Georg','Froschkönigweg 32','50767','Köln','23142312','06905964','Georg@on-line.de','R'),(47,'Masur','Richard','Up den Wiemen 46','22609','Hamburg','29671323','29685749','masur@on-line.de','R'),(48,'Gross','Michael','Neptunstraße 33','12621','Berlin','37685940','197867580','m.gross@lola.com','B'),(49,'Hirsch','Andreas','Waidmarkt 16','50735','Köln','19783060','57483657','andreas.hirsch@on-line.de','N'),(50,'Hecht','Jessica','Im Teich 42','51105','Köln','26453756','98786029','jessie.hecht@lola.com','R'),(51,'Kaminski','Melvin','Neue ABC-Straße 504','22607','Hamburg','97860169','57192060','mel@bancroft-and-brooks.com','B'),(52,'Schäfer','Natalie','Mittelstraße 50','53225','Bonn','58672901','91254341','nati@on-line.de','N'),(53,'Persky','Lisa','Keplerstraße 48','40489','Düsseldorf','19562109','38295647','lisa.persky@kunsthaus-persky.de','N'),(54,'Steuer','Paul','Langweidenstraße 67','60386','Frankfurt Main','01867493','19887960','paul.steuer@on-line.de','R'),(55,'Karn','Richard','Jan-Wellem-Straße 34','50668','Köln','97860927','37681936','karn.koeln@on-line.de','V'),(56,'Barron','Marion','Im Fuldchen 7','60435','Frankfurt Main','13241735','91703275','barron.marion@lola.com','B'),(57,'Mull','Martin','Rautendeleinweg 29','40593','Düsseldorf','10923874','57463524','mamu@on-line.de','N'),(58,'Kay','Sylvia','Gutzkowstraße 58','21079','Hamburg','95847772','17584637','kay@web-postfaecher.de','R'),(59,'Singer','Alex','Neumoorstück 15','20459','Hamburg','96857682','19685733','alex@lola.com','N'),(60,'Zagorsky','Annette','Isarstraße 75','30559','Hannover','286957483','10395738','annette@zagorsky-verlag-und-druck.de','R'),(61,'Hecht','Gina','Schulgasse 28','65207','Wiesbaden','195748372','83746293','gina.hecht@on-line.de','R'),(62,'Penner','Jonathan','Von-Lapp-Straße 66','53125','Bonn','17581253','28547639','penner@lola.com','B'),(63,'Kampmann','Stefan','Gustav-Mahler-Straße 64','50733','Köln','19463827','12647366','kampmann@computer-kampmann.de','R'),(64,'Rasche','David','Boxgraben 9','52078','Aachen','18675943','19574838','dave@com-cafe.de','N'),(65,'Wolf','Susanne','Veilchenstieg 26','22297','Hamburg','96857486','768574676','susi.wolf@on-line.de','R'),(66,'Barber','Paul','Mühlenweg 19','10405','Berlin','','46375483','','R'),(67,'Martin','Melanie','Löwengasse 17','51105','Köln','57465748','97867586','melanie.martin@on-line.de','R'),(68,'Lukas','Karl','Max-Hartig-Weg 20','60386','Frankfurt Main','91657438','35462817','k.lukas@lola.com','N'),(69,'Zucker','David','Abbestraße 38','09114','Chemnitz','97860231','16453271','d.zucker@zucker-suess.de','R'),(70,'Sim','Gerald','Lobositzstraße 63','51103','Köln','57463892','18675290','gerald.s@on-line.de','R'),(71,'Arnold','Thomas','Industriestraße 543','21109','Hamburg','18796851','57481503','tom@mayim-bialik-fans.de','B'),(72,'Hart','Melissa','Gurkenweg 4','30655','Hannover','94768592','37685749','lisa.hart@lola.com','R'),(73,'Ure','Gudrun','Lochumer Weg 23','50668','Köln','','28675942','gudrun.ure@on-line.de','N'),(74,'Anwar','Mina','Putzdelle 86','51379','Leverkusen','19675849','16574638','m.anwar@on-line.de','N'),(75,'Kerr','Annette','Brander Heide 37','52066','Aachen','19786758','97867592','anette.kerr@modehaus-kerr-aachen.de','R'),(76,'Lembeck','Helene','Fuldaer Straße 73','60486','Frankfurt Main','67581930','19786024','lele39@on-line.de','V'),(77,'Fleischer','Karl','Kriemhildstraße 38','21109','Hamburg','18695783','97867261','fleischer@web-postfaecher.de','R'),(78,'Kaufmann','Andreas','Fabriciusstieg 47','20257','Hamburg','96847392','53427164','andreas.kaufmann@zmuda.de','K'),(79,'Eles','Sandor','Diedenhofer Straße 63','22419','Hamburg','98362781','87926715','sandor.eles@on-line.de','R'),(80,'Voland','Herbert','Düsseldorfer Straße 90','50939','Köln','86932710','83756493','herbert.voland@on-line.de','R'),(81,'Stoller','Alfred','Voltastraße 53','60388','Frankfurt Main','00418673','65884192','alfi.stoller@lola.com','N'),(82,'Martin','Georg','Hermesgasse 17','51145','Köln','29675813','16475855','g.martin@web-postfaecher.de','B'),(83,'Durdan','Richard','Görlitzer Straße 41','60313','Frankfurt Main','96815376','27681930','dickdurdan@lola.com','K'),(84,'Bonner','Frank','Shakespeareplatz 35','14055','Berlin','36277361','17564832','frank.bonner2@on-line.de','R'),(85,'Baden-Semper','Nina','Brookdamm 68','20457','Hamburg','27564932','04437193','nina@web-postfaecher.de','R'),(86,'Mandan','Robert','Kösener Weg 8','40489','Düsseldorf','56473329','17564932','robert.mandan@on-line.de','N'),(87,'Fenacolini','Anna','Josef-Hirn-Platz 4','50597','Stuttgart','19685493','57463829','anna.fenacolini@stuttgart-uni.de','R'),(88,'Hordern','Michael','Schwengelkamp 44','20255','Hamburg','19685723','375847650','michael.hordern@on-line.de','R'),(89,'Dane','Alexandra','Langeler Kreuzweg 92','51063','Köln','195647382','95768323','xandra@fc-koelle-for-ever.de','N'),(90,'Scolari','Peter','Ella-Kay-Straße 85','13357','Berlin','18574639','26574619','peter.scolari@on-line.de','R'),(91,'Herbert','Philipp','Am Pulverhof 52','22045','Hamburg','28576462','82868584','philipp.herbert@lola.com','R'),(92,'Kraft','Robert','Hohenzollernring 103','14129','Berlin','18463728','07869237','kraft@tierhaus-kraft.de','N'),(93,'Donner','Robert','Bebelplatz 12','51149','Köln','18679684','37586472','donner@donner-und-blitz-medien.de','R'),(94,'Sadowsky','Adam','Colmarer Straße 73','28327','Bremen','96857328','17564834','adam.sadowsky@on-line.de','R'),(95,'Hartman','Philipp','Hamburger Hochstraße 19','22767','Hamburg','29371826','85647291','philipp@radio-bill.de','N'),(96,'Piekarsky','Julia','Quinxer Straße 6','52074','Aachen','28574639','17685743','piekarsky@web-postfaecher.de','R'),(97,'Eiding','Paul','Goerdelerstraße 37','65195','Wiesbaden','','27564832','','N'),(98,'Ritter','Hannes','Emschertalstraße 73','44149','Dortmund','27584637','','hannes.ritter@lola.com','R'),(99,'Adrian','Iris','Vulkanstraße 46','50677','Köln','18675943','27564839','iris.adrian@on-line.de','N'),(100,'Slotky','Anna','Anita-Ree-Straße 61','22087','Hamburg','28574635','29186753','slotky@zzzorro.de','K');
247/*!40000 ALTER TABLE `kunde` ENABLE KEYS */;
248UNLOCK TABLES;
249
250--
251-- Table structure for table `kunde_delete_log`
252--
253
254DROP TABLE IF EXISTS `kunde_delete_log`;
255/*!40101 SET @saved_cs_client = @@character_set_client */;
256/*!40101 SET character_set_client = utf8 */;
257CREATE TABLE `kunde_delete_log` (
258 `name` varchar(255) DEFAULT NULL,
259 `vorname` varchar(255) DEFAULT NULL
260) ENGINE=MyISAM DEFAULT CHARSET=utf8;
261/*!40101 SET character_set_client = @saved_cs_client */;
262
263--
264-- Dumping data for table `kunde_delete_log`
265--
266
267LOCK TABLES `kunde_delete_log` WRITE;
268/*!40000 ALTER TABLE `kunde_delete_log` DISABLE KEYS */;
269/*!40000 ALTER TABLE `kunde_delete_log` ENABLE KEYS */;
270UNLOCK TABLES;
271
272--
273-- Table structure for table `kunde_domaene`
274--
275
276DROP TABLE IF EXISTS `kunde_domaene`;
277/*!40101 SET @saved_cs_client = @@character_set_client */;
278/*!40101 SET character_set_client = utf8 */;
279CREATE TABLE `kunde_domaene` (
280 `kundennr` int(11) NOT NULL AUTO_INCREMENT,
281 `name` varchar(255) DEFAULT NULL,
282 `vorname` varchar(255) DEFAULT NULL,
283 `strasse` varchar(255) DEFAULT NULL,
284 `plz` varchar(255) DEFAULT NULL,
285 `ort` varchar(255) DEFAULT NULL,
286 `telefon_gesch` varchar(255) DEFAULT NULL,
287 `telefon_privat` varchar(255) DEFAULT NULL,
288 `email` varchar(255) DEFAULT NULL,
289 `zahlungsart` varchar(255) DEFAULT NULL,
290 PRIMARY KEY (`kundennr`)
291) ENGINE=MyISAM AUTO_INCREMENT=223 DEFAULT CHARSET=utf8;
292/*!40101 SET character_set_client = @saved_cs_client */;
293
294--
295-- Dumping data for table `kunde_domaene`
296--
297
298LOCK TABLES `kunde_domaene` WRITE;
299/*!40000 ALTER TABLE `kunde_domaene` DISABLE KEYS */;
300INSERT INTO `kunde_domaene` VALUES (1,'Loewe','Arthur','Sebastianstraße 134','50737','Köln','','19467383','','B'),(2,'Adler','felix','HH','33333','hhh','9999','444','adlod','N'),(222,'Adler','felix','HH','33333','hhh','9999','444','adlod','N');
301/*!40000 ALTER TABLE `kunde_domaene` ENABLE KEYS */;
302UNLOCK TABLES;
303
304--
305-- Table structure for table `mitarbeiter`
306--
307
308DROP TABLE IF EXISTS `mitarbeiter`;
309/*!40101 SET @saved_cs_client = @@character_set_client */;
310/*!40101 SET character_set_client = utf8 */;
311CREATE TABLE `mitarbeiter` (
312 `mitarbeiternr` int(11) NOT NULL AUTO_INCREMENT,
313 `name` varchar(255) DEFAULT NULL,
314 `vorname` varchar(255) DEFAULT NULL,
315 `strasse` varchar(255) DEFAULT NULL,
316 `plz` varchar(255) DEFAULT NULL,
317 `ort` varchar(255) DEFAULT NULL,
318 `gehalt` float DEFAULT NULL,
319 `abteilung` int(11) DEFAULT NULL,
320 `telefonnummer` varchar(255) DEFAULT NULL,
321 `email` varchar(255) DEFAULT NULL,
322 `eintrittsdatum` date DEFAULT NULL,
323 PRIMARY KEY (`mitarbeiternr`)
324) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
325/*!40101 SET character_set_client = @saved_cs_client */;
326
327--
328-- Dumping data for table `mitarbeiter`
329--
330
331LOCK TABLES `mitarbeiter` WRITE;
332/*!40000 ALTER TABLE `mitarbeiter` DISABLE KEYS */;
333INSERT INTO `mitarbeiter` VALUES (1,'Ross','Hagen','Hauptstraße 67','53123','Bonn',7500,1,'43567890','hagen.ross@beispielfirma.de','1986-02-18'),(2,'Roberts','Patrick','Schillerstraße 154','53229','Bonn',7000,1,'98761462','p.roberts@beispielfirma.de','1988-10-20'),(3,'Hummer','Stefan','Sonnenhag 74','53175','Bonn',7000,1,'98120421','stefanhummer@beispielfirma.de','1992-08-01'),(4,'Gerhard','David','Nibelungenstraße 21','52115','Bonn',2500,2,'67294738','dave.g@beispielfirma.de','1987-07-13'),(5,'Weinert','Eduard','Quellenweg 57','53177','Bonn',2000,2,'78646193','eduard.weinert@beispielfirma.de','1987-01-19'),(6,'Michaels','Connie','Benedek Straße 5','53756','St. Augustin',2500,3,'12345655','connie.michaels@beispielfirma.de','1988-04-21'),(7,'Osser','Bernd','Usambaraweg 28','50732','Köln',2200,3,'27913020','b.osser@beispielfirma.de','1995-06-05'),(8,'Koppes','Karin','Kopenhagener Straße 34','53177','Bonn',2400,4,'98766754','karin.koppes@beispielfirma.de','1998-05-10'),(9,'Wilding','Alexander','Sedanstraße 172','53229','Bonn',2300,4,'28652947','alex.wilding@beispielfirma.de','2001-06-30'),(10,'Schmidt','Peter','Konrad-Adenauer-Straße 49','50997','Köln',2500,5,'68371020','p.schmidt@beispielfirma.de','2001-11-04'),(11,'Müller','Ole','Lutherstraße 4','50823','Köln',2600,5,'682037741','o.mueller@beispielfirma.de','1999-03-02'),(12,'Meier','Wilhelm','Römerstraße 53','53229','Bonn',2400,5,'91821573','willi.meier@beispielfirma.de','1994-08-02'),(13,'Schiff','Martin','Truchseßstraße 74','53127','Bonn',2500,5,'65744583','martin.schiff@beispielfirma.de','2002-09-28'),(14,'Lehne','Luise','Lyngsbergstraße 93','53113','Bonn',2000,6,'12341756','luise.lehne@beispielfirma.de','2001-07-22'),(15,'Remsen','Kevin','Nonnenstrombergstraße 22','50672','Köln',1800,6,'94128882','kevin.remsen@beispielfirma.de','2004-01-02');
334/*!40000 ALTER TABLE `mitarbeiter` ENABLE KEYS */;
335UNLOCK TABLES;
336
337--
338-- Table structure for table `mwstsatz`
339--
340
341DROP TABLE IF EXISTS `mwstsatz`;
342/*!40101 SET @saved_cs_client = @@character_set_client */;
343/*!40101 SET character_set_client = utf8 */;
344CREATE TABLE `mwstsatz` (
345 `mwstnr` int(11) DEFAULT NULL,
346 `prozent` float DEFAULT NULL
347) ENGINE=MyISAM DEFAULT CHARSET=utf8;
348/*!40101 SET character_set_client = @saved_cs_client */;
349
350--
351-- Dumping data for table `mwstsatz`
352--
353
354LOCK TABLES `mwstsatz` WRITE;
355/*!40000 ALTER TABLE `mwstsatz` DISABLE KEYS */;
356INSERT INTO `mwstsatz` VALUES (1,7),(2,19);
357/*!40000 ALTER TABLE `mwstsatz` ENABLE KEYS */;
358UNLOCK TABLES;
359
360--
361-- Table structure for table `posten`
362--
363
364DROP TABLE IF EXISTS `posten`;
365/*!40101 SET @saved_cs_client = @@character_set_client */;
366/*!40101 SET character_set_client = utf8 */;
367CREATE TABLE `posten` (
368 `bestellnr` int(11) DEFAULT NULL,
369 `artikelnr` int(11) DEFAULT NULL,
370 `bestellmenge` int(11) DEFAULT NULL,
371 `liefermenge` int(11) DEFAULT NULL
372) ENGINE=MyISAM DEFAULT CHARSET=utf8;
373/*!40101 SET character_set_client = @saved_cs_client */;
374
375--
376-- Dumping data for table `posten`
377--
378
379LOCK TABLES `posten` WRITE;
380/*!40000 ALTER TABLE `posten` DISABLE KEYS */;
381INSERT INTO `posten` VALUES (1,1,1,1),(1,2,1,1),(2,34,2,2),(3,20,1,1),(3,11,1,1),(4,45,1,1),(5,19,1,1),(6,46,2,2),(7,8,1,1),(7,37,1,1),(8,12,1,1),(9,39,1,1),(10,30,1,1),(10,25,1,1),(11,20,1,1),(12,36,1,1),(13,41,1,1),(13,49,1,1),(14,6,3,3),(15,36,1,1),(16,21,4,4),(17,34,1,1),(18,34,1,1),(19,41,1,1),(20,17,1,1),(21,2,3,3),(22,19,1,1),(23,32,1,1),(24,14,2,2),(25,28,1,1),(26,8,1,1),(26,21,2,2),(27,36,1,1),(28,40,1,1),(29,4,1,1),(29,27,1,1),(29,43,1,1),(30,28,3,3),(31,15,1,1),(32,18,1,1),(33,38,2,2),(34,4,1,1),(35,25,1,1),(36,6,2,2),(36,32,1,1),(37,19,1,1),(38,42,1,1),(39,26,1,1),(39,3,1,1),(40,17,1,1),(41,23,1,1),(41,45,1,1),(42,27,2,2),(43,18,1,1),(44,24,1,1),(45,7,1,1),(46,38,1,1),(47,21,1,1),(49,32,1,1),(50,16,2,2),(51,47,1,1),(51,13,1,1),(52,28,3,3),(53,34,1,1),(54,41,1,1),(55,14,2,2),(56,29,1,1),(57,1,1,1),(58,18,1,1),(59,32,2,2),(60,24,1,1),(61,30,1,1),(61,45,1,1),(62,11,2,2),(62,38,1,1),(63,4,1,1),(64,33,1,1),(64,42,1,1),(65,10,1,1),(65,44,1,1),(66,26,1,1),(66,36,1,1),(66,49,2,2),(67,27,1,1),(67,33,1,1),(68,13,1,1),(69,7,3,3),(70,18,1,1),(70,22,1,1),(70,50,1,1),(71,6,1,1),(71,28,1,1),(72,1,2,2),(72,6,4,4),(72,10,1,1),(72,12,2,2),(72,10,1,1),(73,4,1,1),(73,43,1,1),(74,3,1,1),(74,4,1,1),(74,7,1,1),(74,9,1,1),(74,11,1,1),(74,14,1,1),(74,17,1,1),(74,20,1,1),(74,22,1,1),(74,26,1,1),(74,29,1,1),(74,34,1,1),(74,37,1,1),(74,38,1,1),(74,41,1,1),(74,42,1,1),(74,43,1,1),(74,48,1,1),(74,50,1,1),(75,5,1,1),(75,8,1,1),(75,13,1,1),(75,23,1,1),(75,26,1,1),(75,33,1,1),(75,39,1,1),(75,42,1,1),(75,49,1,1),(76,32,1,1),(76,12,1,1),(76,24,1,1),(76,3,3,3),(76,45,2,2),(77,46,10,10),(77,47,10,10),(77,48,10,10),(77,49,10,10),(77,50,10,10),(78,9,1,1),(78,16,1,1),(78,22,1,1),(78,36,1,1),(78,43,1,1),(79,34,1,1),(79,41,1,1),(80,12,1,1),(80,36,1,1),(81,4,1,1),(81,7,1,1),(81,11,1,1),(81,18,1,1),(81,24,1,1),(81,28,1,1),(81,33,1,1),(81,39,1,1),(81,40,1,1),(81,46,1,1),(82,9,1,1),(82,32,1,1),(82,29,1,1),(82,1,2,2),(83,17,1,1),(83,39,1,1),(84,23,1,1),(85,44,1,1),(86,7,1,1),(86,28,1,1),(86,44,1,1),(87,5,1,1),(88,21,1,1),(89,37,1,1),(90,15,1,1),(91,22,1,1),(91,48,4,4),(92,33,1,1),(93,14,2,2),(94,29,1,1),(95,42,1,1),(96,10,1,1),(96,13,1,1),(97,23,1,1),(98,4,1,1),(99,43,2,2),(100,35,1,1),(101,2,1,1),(101,7,2,2),(102,42,1,1),(103,33,1,1),(104,16,2,2),(105,23,1,1),(106,18,1,1),(107,46,10,10),(108,11,1,1),(108,28,1,1),(108,32,1,1),(109,17,1,1),(109,20,2,2),(110,19,1,1),(111,27,1,1),(111,34,1,1),(112,22,6,6),(113,15,1,1),(113,8,1,1),(114,26,1,1),(114,37,1,1),(115,11,2,2),(116,24,1,1),(117,38,1,1),(117,50,1,1),(118,7,4,4),(119,26,1,1),(119,3,2,2),(120,25,2,2),(121,47,1,1),(122,5,1,1),(123,32,5,5),(124,25,2,2),(124,6,1,1),(125,40,1,1),(126,39,1,1),(127,19,1,1),(128,28,1,1),(128,6,2,2),(129,42,1,1),(130,13,2,2),(131,38,1,1),(132,17,1,1),(133,21,2,2),(134,33,1,1),(135,10,1,1),(135,30,1,1),(136,46,1,1),(137,5,2,2),(137,34,1,1),(138,24,1,1),(139,37,1,1),(140,18,1,1),(141,33,1,1),(141,19,2,1),(142,48,1,1),(143,4,1,1),(144,33,1,1),(145,17,4,4),(145,31,2,2),(145,42,3,3),(146,3,1,1),(147,34,1,1),(148,26,1,1),(149,7,1,1),(149,49,1,1),(150,1,2,2);
382/*!40000 ALTER TABLE `posten` ENABLE KEYS */;
383UNLOCK TABLES;
384
385--
386-- Table structure for table `statistik`
387--
388
389DROP TABLE IF EXISTS `statistik`;
390/*!40101 SET @saved_cs_client = @@character_set_client */;
391/*!40101 SET character_set_client = utf8 */;
392CREATE TABLE `statistik` (
393 `kundenanzahl` int(11) DEFAULT NULL,
394 `artikelanzahl` int(11) DEFAULT NULL
395) ENGINE=MyISAM DEFAULT CHARSET=utf8;
396/*!40101 SET character_set_client = @saved_cs_client */;
397
398--
399-- Dumping data for table `statistik`
400--
401
402LOCK TABLES `statistik` WRITE;
403/*!40000 ALTER TABLE `statistik` DISABLE KEYS */;
404INSERT INTO `statistik` VALUES (100,50);
405/*!40000 ALTER TABLE `statistik` ENABLE KEYS */;
406UNLOCK TABLES;
407/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
408
409/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
410/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
411/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
412/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
413/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
414/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
415/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;