DatabaseProjekt/Data_kollegie.sql at main · jesperdlau/DatabaseProjekt · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
-- Data til Kollegiet


INSERT Resident VALUES
("00001", "Ahmed Abdullah", "ahmed@gmail.com", "10297362", "7563455093"),
("81838", "Spencer Lloyd", "werwe@hellsmoney.com", "54075690", "96941657"),
("81193", "Alexis Robbins", "alekseu6@suksesboss.com", "89441583", "66192438"),
("77612", "Luther Gibbons", "nbyrd568@allfrree.xyz", "78033372", "30771149"),
("09208", "Big Man Shaq", "babyj23@gcantikored.pw", "96509093", "35913717"),
("59301", "Moe Lester", "scottvw1@hulas.us", "01685455", "55353104"),
("80033", "Chris P. Bacon", "cedjoe@sonophon.ru", "74142804", "41359985"),
("64910", "Ben Dover", "shainurovaelena@bukanimers.com", "81323954", "16744280"),
("36593", "Torben Torp", "hornyboy19474@boranora.com", "51252167", "32669505"),
("30777", "Lars Larsen Muhammed", "gmfam@menuyul.club", "22653373", "98560359"),
("76179", "Malthe BR. Esler", "lillepik@bigboysclub.dk", "74810273", "67446187"),
("93194", "Juliet Fernandez", "giomelos@menuyul.club", "26756075", "03272464"),
("27183", "Laila Andersen", "pfqlug9yix@clk2020.info", "64800239", "86397684"),
("21827", "Sugma Kok", "bulikina@bukanimers.com", "52978832", "78760567"),
("52923", "Dean Mohr", "azamyt@greendike.com", "26480959", "80488983"),
("40938", "Frida Torp", "frida@torp.family.dk", "13883969", "95671075"),
("62775", "Uffe Torp", "uffe@torp.family.dk", "76302667", "32706604"),
("99798", "Steffen Torp", "steffen@torp.family.dk", "79741802", "32399798"),
("03934", "Johanne Torp", "johanne@torp.family.dk", "29726786", "65147817"),
("13732", "Kristine Torp", "kristine@torp.family.dk", "31243048", "63825321");

INSERT ROOMS VALUES
(01, 1, A, False, False),
(02, 1, A, False, False),
(03, 1, A, True, True),
(04, 1, A, False, False),
(05, 1, A, False, False),
(06, 1, A, False, False),
(07, 1, A, False, False),
(08, 1, A, True, True),
(09, 1, A, True, False),
(10, 1, A, False, False),
(01, 2, A, False, False),
(02, 2, A, False, False),
(03, 2, A, True, False),
(04, 2, A, True, False),
(05, 2, A, True, False),
(06, 2, A, True, False),
(07, 2, A, True, False),
(08, 2, A, True, False),
(09, 2, A, True, False),
(10, 2, A, True, False),
(01, 1, B, True, False),
(02, 1, B, True, False),
(03, 1, B, True, False),
(04, 1, B, True, False),
(05, 1, B, True, False),
(01, 2, B, True, False),
(02, 2, B, True, False),
(03, 2, B, True, False),
(04, 2, B, True, True),
(05, 2, B, True, False);


INSERT Item VALUES
("19821740", 'L01'),
("4a42277d", 'L02'),
("28ecf826", "L04"),
("faw21440", 'B01'),
("4a22212d", 'B02'),
("98edw826", "B04");


INSERT BookingHistory VALUES
("19821740", "12-20-01"),
("4a42277d", "13-24-02"),
("28ecf826", "16-12-03"),
("faw21440", "11-28-02"),
("4a22212d", "16-20-03"),
("98edw826", "12-05-02");

INSERT Booking VALUES
("00001","19821740"),
("81838","4a42277d"),
("81193","28ecf826"),
("77612","faw21440"),
("09208","4a22212d"),
("59301","98edw826");


INSERT Lives VALUES
(00001, 03, 1, A),
(81838, 02, 2, A),
(81193, 04, 2, B),
(77612, 05, 2, B),
(09208, 06, 2, A),
(59301, 08, 1, A),
(80033, 10, 2, A),
(64910, 03, 1, B),
(36593, 09, 1, A),
(30777, 03, 1, A),
(76179, 05, 2, B),
(93194, 01, 1, B),
(27183, 02, 1, B),
(21827, 07, 2, A),
(52923, 06, 2, A),
(40938, 05, 2, A),
(62775, 08, 1, A),
(99798, 04, 2, B),
(03934, 03, 2, B),
(13732, 03, 2, A);


INSERT LaundryRoom VALUES
    ('L01', 'Vask', 10, False),
    ('L02', 'Vask', 10, False),
    ('L03', 'Tørre', 5, False),
    ('L04', 'Tørre', 5, True);

INSERT Boats VALUES
    ('B01', 'W.T. Frigg', 'Kano', 20, False),
    ('B02', 'Malthe Boatsler', 'Kano', 20, True),
    ('B03', 'Bo(at)', 'Kano', 20, False),
    ('B04', 'Bloat', 'Kajak', 25, False);