· 7 years ago · Sep 10, 2018, 08:16 AM
1-- MySQL dump 10.16 Distrib 10.2.14-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: nbb
4-- ------------------------------------------------------
5-- Server version 10.2.14-MariaDB
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 `tblArtikel`
20--
21
22DROP TABLE IF EXISTS `tblArtikel`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `tblArtikel` (
26 `aid` int(11) NOT NULL AUTO_INCREMENT,
27 `name` varchar(45) DEFAULT NULL,
28 `beschreibung` varchar(45) DEFAULT NULL,
29 `preis` decimal(18,2) DEFAULT NULL,
30 PRIMARY KEY (`aid`)
31) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `tblArtikel`
36--
37
38LOCK TABLES `tblArtikel` WRITE;
39/*!40000 ALTER TABLE `tblArtikel` DISABLE KEYS */;
40INSERT INTO `tblArtikel` VALUES (1,'Acer Predator Helios 300 (G3-572-79KL)','y0y0y0 n1 description',9999.99),(2,'HP Pavilion Power','power',9999.99),(3,'MacBook Pro','y0',1500.00),(4,'Razer d000ge','zerstört sich von selbst nach ablauf der gar',99.95),(5,'Razer noch mehr dogshit','auch kabutt nach garantie',99.95),(6,'Roccat Kone','stabil',99.95),(7,'Lenovo 320-17IKBR','Onyx Black 17.3 Zoll HD+ Intel i5-8250U 8GB ',9999.99),(8,'HP Slimline Desktop','260-a159ng, AMD Quad-Core A8-7410 8GB RAM 100',9999.99),(9,'HP Pavilion,570-p551ng','AMD A10-9700 8GB RAM 1TB HDD GeForce GTX 1050',9999.99),(10,'Intel NUC Kit','NUC8i7HVK Intel Core i7-8809G Radeon RX Vega ',9999.99),(11,'Apple Mac Mini','Intel Core i5-4260U 1.4GHz Dual-Core 4GB RAM ',9999.99),(13,'Traubensaft','Ein Fruchtgetränk\"\n\"Erdnussflips',9999.99),(18,'Maus','Maus',9999.99),(19,'Notebook','Notebook',9999.99),(20,'SSD','SSD 512GB',9999.99),(21,'Schreibtisch','groß',9999.99),(22,'Stift','Kugelschreiber',1.00),(23,'Monitor','NEC 3D',150.00);
41/*!40000 ALTER TABLE `tblArtikel` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `tblKunde`
46--
47
48DROP TABLE IF EXISTS `tblKunde`;
49/*!40101 SET @saved_cs_client = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `tblKunde` (
52 `kid` int(11) NOT NULL AUTO_INCREMENT,
53 `name` varchar(45) DEFAULT NULL,
54 `vorname` varchar(45) DEFAULT NULL,
55 `strasse` varchar(45) DEFAULT NULL,
56 `plz` char(5) DEFAULT NULL,
57 `stadt` varchar(45) DEFAULT NULL,
58 `email` varchar(45) DEFAULT NULL,
59 PRIMARY KEY (`kid`)
60) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `tblKunde`
65--
66
67LOCK TABLES `tblKunde` WRITE;
68/*!40000 ALTER TABLE `tblKunde` DISABLE KEYS */;
69INSERT INTO `tblKunde` VALUES (1,'Heise','Kevin','Wasserstraße, 3','42448','Bochum','test.bla@gmail.com'),(2,'Soggi','Daniel','unter der Bruecke, 13','47892','Bochum','soggi@gmx.de'),(3,'Mustermann','Max','Musterstrasse ,1','12345','Musterstadt','mustermail@musterprovider.muster'),(4,'Wasgehtsiedasan','Kevin','Schneckenstraße, 12','44544','Bikini Bottom','wasgehtsiedasan@gmail.com'),(5,'Hackfleischhackendezerhasser','Der','Muschelsand Superhighway','99999','Bikini Bottom','zerhacker@bikinibotton.de'),(6,'luca','schroeder','Am Kempel, 13','45525','Hattingen','luca.schroeder@gmail.com'),(7,'Johannes','p','Oberhausener Weg, 12','43185','Oberhausen','j.ptaszyk@web.de'),(8,'Derek','Bertram','Hauptstrasse 10','48162','Bottrop','derek.b@yahoo.com'),(9,'test','user','testStrasse 93','11111','TestStadt','test.test@test.de'),(10,'Jennifer','Heise','Wittener Str. 45','44799','Bochum','jennifer.borkowski@private.de'),(11,'Clef','Paulo','Ostring 25','44787','Bochum','p.clef@example.com'),(12,'Savas','Christine','Ostring 25','44787','Bochum','c.savas@example.com');
70/*!40000 ALTER TABLE `tblKunde` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `tblRechnung`
75--
76
77DROP TABLE IF EXISTS `tblRechnung`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `tblRechnung` (
81 `rid` int(11) NOT NULL AUTO_INCREMENT,
82 `datum` date DEFAULT NULL,
83 `vid` int(11) DEFAULT NULL,
84 `zid` int(11) DEFAULT NULL,
85 `kid` int(11) DEFAULT NULL,
86 PRIMARY KEY (`rid`),
87 KEY `fk_tblRechnung_tblVersand1_idx` (`vid`),
88 KEY `fk_tblRechnung_tblZahlungsart1_idx` (`zid`),
89 KEY `fk_tblRechnung_tblKunde1_idx` (`kid`),
90 CONSTRAINT `fk_tblRechnung_tblKunde1` FOREIGN KEY (`kid`) REFERENCES `tblKunde` (`kid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
91 CONSTRAINT `fk_tblRechnung_tblVersand1` FOREIGN KEY (`vid`) REFERENCES `tblVersand` (`vid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
92 CONSTRAINT `fk_tblRechnung_tblZahlungsart1` FOREIGN KEY (`zid`) REFERENCES `tblZahlungsart` (`zid`) ON DELETE NO ACTION ON UPDATE NO ACTION
93) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
94/*!40101 SET character_set_client = @saved_cs_client */;
95
96--
97-- Dumping data for table `tblRechnung`
98--
99
100LOCK TABLES `tblRechnung` WRITE;
101/*!40000 ALTER TABLE `tblRechnung` DISABLE KEYS */;
102INSERT INTO `tblRechnung` VALUES (1,'2018-05-09',3,3,1),(2,'2018-05-30',6,7,11),(3,'2018-05-31',7,5,12);
103/*!40000 ALTER TABLE `tblRechnung` ENABLE KEYS */;
104UNLOCK TABLES;
105
106--
107-- Table structure for table `tblRechnung_has_tblArtikel`
108--
109
110DROP TABLE IF EXISTS `tblRechnung_has_tblArtikel`;
111/*!40101 SET @saved_cs_client = @@character_set_client */;
112/*!40101 SET character_set_client = utf8 */;
113CREATE TABLE `tblRechnung_has_tblArtikel` (
114 `a2rid` int(11) NOT NULL AUTO_INCREMENT,
115 `rid` int(11) NOT NULL,
116 `aid` int(11) NOT NULL,
117 PRIMARY KEY (`a2rid`),
118 KEY `fk_tblRechnung_has_tblArtikel_tblArtikel1_idx` (`aid`),
119 KEY `fk_tblRechnung_has_tblArtikel_tblRechnung1_idx` (`rid`),
120 CONSTRAINT `fk_tblRechnung_has_tblArtikel_tblArtikel1` FOREIGN KEY (`aid`) REFERENCES `tblArtikel` (`aid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
121 CONSTRAINT `fk_tblRechnung_has_tblArtikel_tblRechnung1` FOREIGN KEY (`rid`) REFERENCES `tblRechnung` (`rid`) ON DELETE NO ACTION ON UPDATE NO ACTION
122) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
123/*!40101 SET character_set_client = @saved_cs_client */;
124
125--
126-- Dumping data for table `tblRechnung_has_tblArtikel`
127--
128
129LOCK TABLES `tblRechnung_has_tblArtikel` WRITE;
130/*!40000 ALTER TABLE `tblRechnung_has_tblArtikel` DISABLE KEYS */;
131INSERT INTO `tblRechnung_has_tblArtikel` VALUES (1,1,1),(2,1,3),(3,1,5),(4,1,7),(5,1,9),(6,1,9),(7,1,1),(8,1,3),(9,1,5),(10,1,7),(11,1,1),(12,2,3),(13,2,18),(14,2,2),(15,2,5),(16,3,23),(17,3,20),(18,3,10),(19,3,21),(20,3,22);
132/*!40000 ALTER TABLE `tblRechnung_has_tblArtikel` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `tblVersand`
137--
138
139DROP TABLE IF EXISTS `tblVersand`;
140/*!40101 SET @saved_cs_client = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `tblVersand` (
143 `vid` int(11) NOT NULL AUTO_INCREMENT,
144 `name` varchar(45) DEFAULT NULL,
145 `beschreibung` varchar(45) DEFAULT NULL,
146 `kosten` varchar(45) DEFAULT NULL,
147 PRIMARY KEY (`vid`)
148) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Dumping data for table `tblVersand`
153--
154
155LOCK TABLES `tblVersand` WRITE;
156/*!40000 ALTER TABLE `tblVersand` DISABLE KEYS */;
157INSERT INTO `tblVersand` VALUES (1,'Fahhrad','Platten reifen','213'),(2,'Auto','Platten reifen','1'),(3,'Fuß','dauert ewig','453'),(4,'DPD','Fast','453'),(5,'Post','3 Tage','2'),(6,'Gar nicht','kommt nie an','312'),(7,'UPS','World shipping','213');
158/*!40000 ALTER TABLE `tblVersand` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `tblZahlungsart`
163--
164
165DROP TABLE IF EXISTS `tblZahlungsart`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `tblZahlungsart` (
169 `zid` int(11) NOT NULL AUTO_INCREMENT,
170 `name` varchar(45) DEFAULT NULL,
171 PRIMARY KEY (`zid`)
172) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `tblZahlungsart`
177--
178
179LOCK TABLES `tblZahlungsart` WRITE;
180/*!40000 ALTER TABLE `tblZahlungsart` DISABLE KEYS */;
181INSERT INTO `tblZahlungsart` VALUES (1,'VISA'),(2,'Bargeld lacht'),(3,'Muscheln'),(4,'Ãœberweisung'),(5,'Paypal'),(6,'EC'),(7,'BAR'),(8,'KREDITKARTE'),(9,'PAYPAL');
182/*!40000 ALTER TABLE `tblZahlungsart` ENABLE KEYS */;
183UNLOCK TABLES;
184/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
185
186/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
187/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
188/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
189/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
190/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
191/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
192/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
193
194-- Dump completed on 2018-09-10 10:07:53