xn8P1QwF

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