Up99YWNV

1DROP SCHEMA IF EXISTS shitdatabase;
2
3CREATE SCHEMA IF NOT EXISTS shitdatabase;
4use shitdatabase;
5CREATE TABLE parkingLot (
6  id int(11) NOT NULL AUTO_INCREMENT,
7  name varchar(50) NOT NULL,
8  #location varchar(50),
9  capacity int(11) NOT NULL,
10  reservedSpaces int(11) NOT NULL,
11  PRIMARY KEY (id)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8; 
13
14CREATE TABLE parkingLog (
15  id int (11) NOT NULL AUTO_INCREMENT,
16  currentParked int (11) NOT NULL,
17  logDate datetime NOT NULL,
18  parkingLot_id int NOT NULL,
19  #CONSTRAINT constraint_name
20  PRIMARY KEY (id),
21  FOREIGN KEY fk_parkingLot(parkingLot_id)
22  REFERENCES parkingLot(id)
23) ENGINE=InnoDB;
24
25
26INSERT INTO parkingLot (name, capacity, reservedSpaces) VALUES
27('Student Organisasjonen', 100, 10),
28('Hokus Pokus Barnehage', 70, 7)
29
30INSERT INTO parkingLog (currentParked, logDate, parkingLot_id) VALUES
31(28, '2016-12-31 10:59:59', 1),
32(29, '2017-01-30 11:53:54', 1),
33(30, DATETIME.NOW, 1),
34(18, '2016-12-31 10:59:59', 2),
35(19, '2017-01-30 11:53:54', 2),
36(18, DATETIME.NOW, 2)