-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmovies_projections_reservations.sql
110 lines (106 loc) · 3.39 KB
/
movies_projections_reservations.sql
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
INSERT OR IGNORE INTO Movies(name, rating)
VALUES ("The Hunger Games: Catching Fire", 7.9),
("Wreck-It Ralph", 7.8),
("Her", 8.3),
("Hot Pursuit", 4.2),
("The D Train", 6.4),
("Ruth & Alex", 6.6),
("Истинският Сен Лоран", 6.4),
("I Am Big Bird: The Caroll Spinney Story", 7.4),
("Noble", 7.2),
("The Seven Five", 7.3);
INSERT OR IGNORE INTO Projections(movie_id, type, date, time)
VALUES (1, "3D", "2014-04-01", "15:30"),
(1, "4DX", "2014-04-02", "12:10"),
(1, "2D", "2014-04-03", "11:40"),
(2, "3D", "2014-04-04", "12:00"),
(2, "2D", "2014-04-05", "19:15"),
(2, "4DX", "2014-04-03", "18:20"),
(3, "3D", "2014-04-02", "08:30"),
(3, "3D", "2014-04-03", "11:30"),
(4, "2D", "2014-04-10", "12:30"),
(5, "4DX", "2014-04-08", "10:55"),
(5, "2D", "2014-04-02", "11:60"),
(6, "3D", "2014-04-06", "22:40"),
(6, "2D", "2014-04-06", "10:25"),
(6, "3D", "2014-04-05", "21:40"),
(7, "2D", "2014-04-03", "18:35"),
(8, "3D", "2014-04-02", "19:40"),
(9, "4DX", "2014-04-03", "20:20"),
(9, "2D", "2014-04-04", "21:50"),
(10, "3D", "2014-04-02", "19:40"),
(10, "2D", "2014-04-01", "11:30"),
(10, "3D", "2014-04-05", "09:20"),
(10, "4DX", "2014-04-06", "12:10"),
(10, "4DX", "2014-04-07", "01:35"),
(10, "2D", "2014-04-08", "15:10");
INSERT OR IGNORE INTO Reservations(username, projection_id, row, col)
VALUES ("Pesho", 1, 7, 7),
("Marcho", 1, 3, 2),
("Slavi", 1, 2, 2),
("Kina", 1, 1, 2),
("Georgi", 1, 1, 4),
("Georgi", 1, 2, 8),
("Pesho", 2, 5, 1),
("Pesho", 2, 5, 2),
("Pesho", 2, 5, 3),
("Pesho", 2, 5, 4),
("Pesho", 2, 5, 5),
("Filip", 2, 6, 2),
("Kostadin", 3, 1, 2),
("Stilyan", 3, 3, 2),
("Maria", 3, 2, 2),
("Maria", 3, 8, 8),
("Peio", 4, 5, 6),
("Slavi", 5, 1, 1),
("Kincho", 5, 2, 2),
("Kerka", 6, 3, 3),
("Misho", 6, 4, 4),
("Hristo", 7, 1, 1),
("Ivelin", 7, 9, 9),
("Pesho", 7, 10, 10),
("Pesho", 8, 2, 2),
("Gosho", 9, 2, 2),
("Dimitur", 10, 1, 2),
("Ivan", 10, 8, 2),
("Ivan", 10, 2, 2),
("Ivan", 10, 3, 2),
("Ivan", 10, 2, 3),
("Rado", 10, 2, 5),
("Ivo", 11, 1, 3),
("Anton", 11, 3, 1),
("Pesho", 11, 7, 7),
("Marcho", 12, 3, 2),
("Slavi", 12, 2, 2),
("Kina", 12, 1, 2),
("Georgi", 13, 1, 1 ),
("Georgi", 13, 2, 8),
("Dorotei", 13, 5, 1),
("Drago", 14, 5, 2),
("Aleks", 14, 5, 3),
("Aleksei", 14, 5, 4),
("Denica", 15, 5, 5),
("Filip", 15, 6, 2),
("Kostadin", 15, 1, 2),
("Stilyan", 16, 3, 2),
("Debora", 16, 2, 2),
("Antonia", 17, 8, 8),
("Ivona", 17, 5, 6),
("Karcho", 18, 1, 1),
("Kiro", 19, 2, 2),
("Kerka", 19, 3, 3),
("Misho", 20, 4, 4),
("Dorotei", 20, 1, 1),
("Doncho", 20, 9, 9),
("Gerasim", 21, 10, 10),
("Gero", 21, 2, 2),
("Matei", 21, 2, 2),
("Boqn", 22, 1, 2),
("Kristina", 23, 8, 2),
("Gancho", 24, 2, 2),
("Gancho", 24, 3, 2),
("Gancho", 24, 2, 3),
("Radi", 24, 4, 4),
("Simo", 24, 9, 9),
("Dimo", 24, 4, 5);
-- PRAGMA foreign_keys = ON;