RPWkj4Ti

1DROP TABLE IF EXISTS User;
2CREATE TABLE User(
3  id int AUTO_INCREMENT not NULL,
4  username varchar(128),
5  password varchar(128),
6  PRIMARY KEY(id)
7);
8
9DROP TABLE IF EXISTS Firmaer;
10CREATE TABLE Firmaer(
11  id int NOT NULL AUTO_INCREMENT,
12  firmanavn varchar(20),
13  PRIMARY KEY(id)
14);
15
16DROP TABLE IF EXISTS Biler;
17CREATE TABLE Biler(
18  id int NOT NULL AUTO_INCREMENT,
19  maerke varchar(20),
20  model varchar(60),
21  prisprkm int(5),
22  active varchar(50),
23  PRIMARY KEY(id)
24);
25
26DROP TABLE IF EXISTS Leasinger;
27CREATE TABLE Leasinger(
28  id int NOT NULL AUTO_INCREMENT,
29  bil_id int(5),
30  firma_id int(5),
31  ForvKmKort int(10),
32  PrisPrMoned int(10),
33  PRIMARY KEY(id)
34);
35
36DROP TABLE IF EXISTS Historik_biler;
37CREATE TABLE Historik_biler(
38  id int NOT NULL AUTO_INCREMENT,
39  maerke varchar(20),
40  model varchar(60),
41  prisprkm int(5),
42  active varchar(50),
43  PRIMARY KEY(id)
44);
45
46DROP TABLE IF EXISTS Leasinger_Historik;
47CREATE TABLE Leasinger_Historik(
48  id int NOT NULL AUTO_INCREMENT,
49  bil_id int(5),
50  firma_id int(5),
51  ForvKmKort int(10),
52  PrisPrMoned int(10),
53  PRIMARY KEY(id)
54);
55
56DROP TABLE IF EXISTS images;
57CREATE TABLE images(
58  id int NOT NULL AUTO_INCREMENT,
59  picturename varchar(50),
60  bil_id int(5),
61  PRIMARY KEY(id)
62);
63
64
65INSERT INTO Firmaer(firmanavn) VALUES ("Renovation og søn");
66INSERT INTO Firmaer(firmanavn) VALUES ("Alka");
67INSERT INTO Firmaer(firmanavn) VALUES ("Frederiks hjemmeservice");
68INSERT INTO Firmaer(firmanavn) VALUES ("360North");
69INSERT INTO Firmaer(firmanavn) VALUES ("SHB-Service");
70INSERT INTO Firmaer(firmanavn) VALUES ("Blomster og dig");