YrXSLpCd

1DROP DATABASE IF EXISTS nbb;
2# DROP DATABASE NBB;
3CREATE DATABASE nbb;
4
5USE nbb;
6
7SET utf8 ;
8
9
10-- -----------------------------------------------------
11-- Table tblKunde
12-- -----------------------------------------------------
13CREATE TABLE tblKunde (
14  kid INT NOT NULL AUTO_INCREMENT,
15  name VARCHAR(45),
16  vorname VARCHAR(45),
17  strasse VARCHAR(45),
18  plz CHAR(5),
19  stadt VARCHAR(45),
20  email VARCHAR(45),
21  PRIMARY KEY (kid)
22  ) ENGINE = InnoDB;
23
24
25-- -----------------------------------------------------
26-- Table tblArtikel
27-- -----------------------------------------------------
28CREATE TABLE tblArtikel (
29  aid INT NOT NULL AUTO_INCREMENT,
30  name VARCHAR(45),
31  beschreibung VARCHAR(45),
32  PRIMARY KEY (aid))
33ENGINE = InnoDB;
34
35
36-- -----------------------------------------------------
37-- Table tblVersand
38-- -----------------------------------------------------
39CREATE TABLE tblVersand (
40  vid INT NOT NULL AUTO_INCREMENT,
41  name VARCHAR(45),
42  beschreibung VARCHAR(45),
43  kosten VARCHAR(45),
44  PRIMARY KEY (vid))
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table tblZahlungsart
50-- -----------------------------------------------------
51CREATE TABLE tblZahlungsart (
52  zid INT NOT NULL AUTO_INCREMENT,
53  name VARCHAR(45),
54  PRIMARY KEY (zid))
55ENGINE = InnoDB;
56
57
58-- -----------------------------------------------------
59-- Table tblRechnung
60-- -----------------------------------------------------
61CREATE TABLE tblRechnung (
62  rid INT NOT NULL AUTO_INCREMENT,
63  datum DATE,
64  vid INT,
65  zid INT,
66  kid INT,
67  PRIMARY KEY (rid),
68  INDEX fk_tblRechnung_tblVersand1_idx (vid ASC),
69  INDEX fk_tblRechnung_tblZahlungsart1_idx (zid ASC),
70  INDEX fk_tblRechnung_tblKunde1_idx (kid ASC),
71  CONSTRAINT fk_tblRechnung_tblVersand1
72    FOREIGN KEY (vid)
73    REFERENCES tblVersand (vid)
74    ON DELETE NO ACTION
75    ON UPDATE NO ACTION,
76  CONSTRAINT fk_tblRechnung_tblZahlungsart1
77    FOREIGN KEY (zid)
78    REFERENCES tblZahlungsart (zid)
79    ON DELETE NO ACTION
80    ON UPDATE NO ACTION,
81  CONSTRAINT fk_tblRechnung_tblKunde1
82    FOREIGN KEY (kid)
83    REFERENCES tblKunde (kid)
84    ON DELETE NO ACTION
85    ON UPDATE NO ACTION)
86ENGINE = InnoDB;
87
88
89-- -----------------------------------------------------
90-- Table tblRechnung_has_tblArtikel
91-- -----------------------------------------------------
92CREATE TABLE tblRechnung_has_tblArtikel (
93  a2rid INT NOT NULL AUTO_INCREMENT,
94  rid INT NOT NULL,
95  aid INT NOT NULL,
96  INDEX fk_tblRechnung_has_tblArtikel_tblArtikel1_idx (aid ASC),
97  INDEX fk_tblRechnung_has_tblArtikel_tblRechnung1_idx (rid ASC),
98  PRIMARY KEY (a2rid),
99  CONSTRAINT fk_tblRechnung_has_tblArtikel_tblRechnung1
100    FOREIGN KEY (rid)
101    REFERENCES tblRechnung (rid)
102    ON DELETE NO ACTION
103    ON UPDATE NO ACTION,
104  CONSTRAINT fk_tblRechnung_has_tblArtikel_tblArtikel1
105    FOREIGN KEY (aid)
106    REFERENCES tblArtikel (aid)
107    ON DELETE NO ACTION
108    ON UPDATE NO ACTION)
109ENGINE = InnoDB;