svw3wTrw

1alter table Personal drop foreign key c_fk_Pizzeria_ID;
2alter table Bestellung drop foreign key b_fk_Pizzeria_ID;
3alter table Bestellung drop foreign key b_fk_Personal_ID;
4alter table Bestellung drop foreign key b_fk_Kunden_ID;
5
6drop table if exists pizzeria;
7drop table if exists personal;
8drop table if exists kunden;
9drop table if exists adresse;
10drop table if exists bestellung;
11
12create database if not exists Pizzeria;
13
14
15create table Pizzeria (
16pk_Pizzeria_ID	integer primary key
17);
18
19create table Personal (
20pk_Personal_ID	integer primary key,
21Vorname	varchar(50),
22Nachname	varchar(50),
23Strasse	varchar(30),
24PLZ	varchar(10),
25Ort	varchar(30),
26fk_Pizzeria_ID	integer
27);
28
29create table Kunden (
30pk_Kunden_ID	integer primary key,
31Vorname	varchar(50),
32Nachname	varchar(50),
33Strasse	varchar(30),
34PLZ	varchar(10),
35Ort	varchar(30),
36Telefonnummer integer(255),
37Email_Adresse varchar(255),
38fk_Pizzeria_ID	integer
39);
40
41create table Bestellung (
42pk_Pizza_ID	integer primary key,
43Pizzaname	varchar(50),
44Zutatenliste	varchar(50),
45fk_Pizzeria_ID	integer,
46fk_Personal_ID integer,
47fk_Kunden_ID	integer
48);
49
50alter table Personal add constraint c_fk_Pizzeria_ID foreign key (fk_Pizzeria_ID)
51references pizzeria(pk_pizzeria_id);
52
53alter table Bestellung add constraint b_fk_Pizzeria_ID foreign key (fk_Pizzeria_ID)
54references pizzeria(pk_pizzeria_id);
55
56alter table Bestellung add constraint b_fk_Personal_ID foreign key (fk_Personal_ID)
57references Personal(pk_Personal_id);
58
59alter table Bestellung add constraint b_fk_Kunden_ID foreign key (fk_Kunden_ID)
60references Kunden(pk_Kunden_id);