5ML2GjLp

1DROP TABLE IF EXISTS Oppbygging;
2DROP TABLE IF EXISTS Del;
3DROP TABLE IF EXISTS Gave;
4DROP TABLE IF EXISTS Person;
5
6CREATE TABLE IF NOT EXISTS Person
7(
8Pnr INTEGER,
9Fornavn VARCHAR(45),
10Etternavn VARCHAR(45),
11fDato DATE,
12
13PRIMARY KEY(Pnr)
14)ENGINE = InnoDB;
15
16CREATE TABLE IF NOT EXISTS Gave
17(
18gnr INTEGER,
19navn VARCHAR(20),
20prod_tid INTEGER,
21
22PRIMARY KEY(gnr)
23)ENGINE = InnoDB;
24
25CREATE TABLE IF NOT EXISTS Del
26(
27dnr INTEGER,
28navn VARCHAR(45),
29lager_ant INTEGER,
30
31PRIMARY KEY(dnr)
32)ENGINE = InnoDB;
33
34CREATE TABLE IF NOT EXISTS Oppbygging
35(
36gnr INTEGER,
37dnr INTEGER,
38ant INTEGER,
39
40PRIMARY KEY(gnr, dnr),
41FOREIGN KEY(gnr) REFERENCES Gave(gnr),
42FOREIGN KEY(dnr) REFERENCES Del(dnr)
43)ENGINE = InnoDB;