RelationalSchema: data.sql

File data.sql, 24.7 KB (added by 221514, 3 weeks ago)
Line 
1INSERT INTO account
2values (100, 'duko@outlook.com', 'David', 'Davidov',
3 '$2a$12$pr3az9qix0CnAsX84C2clu9cG9JDlfqfK.sMqaFhPYR7D5fiz8BjO'); -- pw: d
4INSERT INTO account
5values (200, 'kiko@outlook.com', 'Kiko', 'Kikoski',
6 '$2a$12$KCpRdwqqm2S0BX8fHjzCBO570ivpoJZ6tuIc1W6gwSpzObvxykZ8y'); -- pw: k
7INSERT INTO account
8values (300, 'jama@outlook.com', 'Jana', 'Janoska',
9 '$2a$12$XO94fugzv1B9T.IjEbFSWu4WyCDFTdMM9Vg4Xli7DWiDH1LGwgj7G'); -- pw: j
10INSERT INTO account
11values (400, 'verche@outlook.com', 'Verche', 'Verchoska',
12 '$2a$12$XO94fugzv1B9T.IjEbFSWu4WyCDFTdMM9Vg4Xli7DWiDH1LGwgj7G'); -- pw: v
13
14
15INSERT INTO transport_organizer
16values (100, 100, 'Galeb', '1234512345123');
17INSERT INTO transport_organizer
18values (200, 200, 'Delfina', '1234512345124');
19INSERT INTO transport_organizer
20VALUES (300, 300, 'MakExpress', '1234512345125');
21
22INSERT INTO admin
23values (100, 300);
24
25
26INSERT INTO location (location_id, latitude, longitude, name)
27VALUES (100, 3.2, 1.3, 'Ohrid'),
28 (200, 3.6, 1.4, 'Bitola'),
29 (300, 1.1, 4.5, 'Skopje'),
30 (400, 1.2, 4.8, 'Veles'),
31 (500, 1.3, 4.2, 'Prilep'),
32 (600, 1.5, 4.5, 'Vevcani'),
33 (700, 2.1, 4.7, 'Kumanovo'),
34 (800, 2.8, 3.9, 'Tetovo'),
35 (900, 3.0, 4.0, 'Struga'),
36 (1000, 2.4, 4.2, 'Gostivar'),
37 (1100, 2.4, 4.2, 'Kicevo');
38
39
40INSERT INTO route (route_id, transport_organizer_id, from_location_id, to_location_id)
41VALUES (100, 100, 100, 300),
42 (200, 200, 100, 200),
43 (300, 200, 200, 300),
44 (400, 200, 300, 200),
45 (500, 200, 300, 100),
46 (600, 100, 300, 100),
47 (700, 300, 300, 100),
48 (800, 100, 200, 400), -- Galeb: Bitola to Veles
49 (801, 100, 400, 700), -- Galeb: Veles to Kumanovo
50 (802, 100, 700, 800), -- Galeb: Kumanovo to Tetovo
51 (803, 200, 800, 900), -- Delfina: Tetovo to Struga
52 (804, 200, 900, 100), -- Delfina: Struga to Ohrid
53 (805, 200, 500, 600), -- Delfina: Prilep to Vevcani
54 (806, 300, 600, 1000), -- MakExpress: Vevcani to Gostivar
55 (807, 300, 1000, 300), -- MakExpress: Gostivar to Skopje
56 (808, 100, 300, 700), -- Galeb: Skopje to Kumanovo
57 (809, 200, 700, 300); -- Delfina: Kumanovo to Skopje
58
59
60INSERT INTO trip (trip_id, base_price, route_id, transport_organizer_id, free_seats, date, status)
61VALUES (400, 24.99, 100, 100, 33, '2025-02-12', 'NOT_STARTED'),
62 (500, 24.99, 100, 100, 40, '2025-03-02', 'NOT_STARTED'),
63 (600, 24.99, 100, 300, 6, '2025-05-02', 'NOT_STARTED'),
64 (700, 24.99, 100, 300, 13, '2025-01-12', 'NOT_STARTED'),
65 (800, 24.99, 100, 300, 50, '2025-09-02', 'NOT_STARTED'),
66 (900, 24.99, 100, 300, 6, '2025-10-02', 'NOT_STARTED'),
67 (1000, 19.99, 100, 100, 25, '2025-02-15', 'NOT_STARTED'),
68 (1100, 19.99, 100, 300, 18, '2025-02-16', 'NOT_STARTED'),
69 (1200, 19.99, 100, 200, 40, '2025-02-20', 'NOT_STARTED'),
70 (1300, 19.99, 100, 300, 50, '2025-02-25', 'NOT_STARTED'),
71 (1400, 19.99, 100, 300, 20, '2025-02-26', 'NOT_STARTED'),
72 (1500, 19.99, 200, 100, 35, '2025-02-27', 'NOT_STARTED'),
73 (1600, 19.99, 200, 200, 28, '2025-02-28', 'NOT_STARTED'),
74 (1700, 19.99, 100, 300, 40, '2025-03-01', 'NOT_STARTED'),
75 (1800, 19.99, 100, 100, 18, '2025-03-02', 'NOT_STARTED'),
76 (1900, 19.99, 200, 300, 25, '2025-03-03', 'NOT_STARTED'),
77 (2000, 19.99, 200, 200, 22, '2025-03-04', 'NOT_STARTED'),
78 (2100, 19.99, 100, 100, 30, '2025-03-05', 'NOT_STARTED'),
79 (2200, 19.99, 200, 300, 12, '2025-03-06', 'NOT_STARTED'),
80 (2300, 19.99, 100, 100, 55, '2025-03-07', 'NOT_STARTED'),
81 (2400, 19.99, 100, 100, 45, '2025-01-15', 'COMPLETED'),
82 (2401, 19.99, 200, 200, 38, '2025-01-16', 'COMPLETED'),
83 (2402, 19.99, 300, 200, 42, '2025-01-17', 'COMPLETED'),
84 (2403, 19.99, 400, 200, 35, '2025-01-18', 'COMPLETED'),
85 (2404, 19.99, 500, 200, 28, '2025-01-19', 'COMPLETED'),
86 (2405, 19.99, 600, 100, 33, '2025-01-20', 'COMPLETED'),
87 (2406, 19.99, 700, 300, 40, '2025-01-21', 'COMPLETED'),
88 (2407, 19.99, 800, 100, 45, '2025-01-22', 'COMPLETED'),
89 (2408, 19.99, 801, 100, 30, '2025-01-23', 'COMPLETED'),
90 (2409, 19.99, 802, 100, 25, '2025-01-24', 'COMPLETED'),
91 (2410, 19.99, 803, 200, 40, '2025-01-25', 'COMPLETED'),
92 (2411, 19.99, 804, 200, 35, '2025-01-26', 'COMPLETED'),
93 (2412, 19.99, 805, 200, 30, '2025-01-27', 'COMPLETED'),
94 (2413, 19.99, 806, 300, 45, '2025-01-28', 'COMPLETED'),
95 (2414, 19.99, 807, 300, 38, '2025-01-29', 'COMPLETED'),
96 (2415, 19.99, 808, 100, 42, '2025-01-30', 'COMPLETED'),
97 (2416, 19.99, 809, 200, 35, '2025-01-31', 'COMPLETED'),
98 (2500, 19.99, 100, 100, 20, '2025-02-01', 'COMPLETED'),
99 (2501, 19.99, 200, 200, 15, '2025-02-01', 'COMPLETED'),
100 (2502, 19.99, 300, 200, 18, '2025-02-01', 'COMPLETED'),
101 (2503, 19.99, 400, 200, 22, '2025-02-01', 'COMPLETED'),
102 (2504, 19.99, 500, 200, 25, '2025-02-01', 'COMPLETED'),
103 (2505, 19.99, 100, 100, 18, '2025-02-02', 'COMPLETED'),
104 (2506, 19.99, 200, 200, 12, '2025-02-02', 'COMPLETED'),
105 (2507, 19.99, 300, 200, 20, '2025-02-02', 'COMPLETED'),
106 (2508, 19.99, 700, 300, 30, '2025-02-02', 'COMPLETED'),
107 (2509, 19.99, 800, 100, 35, '2025-02-02', 'COMPLETED'),
108 (2510, 19.99, 100, 100, 25, '2025-02-03', 'COMPLETED'),
109 (2511, 19.99, 200, 200, 20, '2025-02-03', 'COMPLETED'),
110 (2512, 19.99, 300, 200, 15, '2025-02-03', 'COMPLETED'),
111 (2513, 19.99, 801, 100, 28, '2025-02-03', 'COMPLETED'),
112 (2514, 19.99, 802, 100, 22, '2025-02-03', 'COMPLETED'),
113 (2515, 19.99, 100, 100, 30, '2025-02-04', 'COMPLETED'),
114 (2516, 19.99, 200, 200, 25, '2025-02-04', 'COMPLETED'),
115 (2517, 19.99, 400, 200, 18, '2025-02-04', 'COMPLETED'),
116 (2518, 19.99, 803, 200, 40, '2025-02-04', 'COMPLETED'),
117 (2519, 19.99, 804, 200, 35, '2025-02-04', 'COMPLETED'),
118 (2520, 19.99, 100, 100, 22, '2025-02-05', 'COMPLETED'),
119 (2521, 19.99, 300, 200, 28, '2025-02-05', 'COMPLETED'),
120 (2522, 19.99, 500, 200, 32, '2025-02-05', 'COMPLETED'),
121 (2523, 19.99, 805, 200, 25, '2025-02-05', 'COMPLETED'),
122 (2524, 19.99, 806, 300, 38, '2025-02-05', 'COMPLETED'),
123 (2600, 19.99, 100, 100, 35, '2025-03-08', 'NOT_STARTED'),
124 (2601, 19.99, 200, 200, 40, '2025-03-08', 'NOT_STARTED'),
125 (2602, 19.99, 300, 200, 32, '2025-03-08', 'NOT_STARTED'),
126 (2603, 19.99, 700, 300, 45, '2025-03-08', 'NOT_STARTED'),
127 (2604, 19.99, 800, 100, 38, '2025-03-08', 'NOT_STARTED'),
128 (2605, 19.99, 100, 100, 30, '2025-03-09', 'NOT_STARTED'),
129 (2606, 19.99, 400, 200, 35, '2025-03-09', 'NOT_STARTED'),
130 (2607, 19.99, 500, 200, 40, '2025-03-09', 'NOT_STARTED'),
131 (2608, 19.99, 801, 100, 25, '2025-03-09', 'NOT_STARTED'),
132 (2609, 19.99, 802, 100, 28, '2025-03-09', 'NOT_STARTED'),
133 (2610, 19.99, 200, 200, 42, '2025-03-10', 'NOT_STARTED'),
134 (2611, 19.99, 300, 200, 38, '2025-03-10', 'NOT_STARTED'),
135 (2612, 19.99, 803, 200, 45, '2025-03-10', 'NOT_STARTED'),
136 (2613, 19.99, 804, 200, 40, '2025-03-10', 'NOT_STARTED'),
137 (2614, 19.99, 807, 300, 35, '2025-03-10', 'NOT_STARTED'),
138 (2700, 19.99, 100, 100, 40, '2025-04-12', 'NOT_STARTED'),
139 (2701, 19.99, 200, 200, 35, '2025-04-12', 'NOT_STARTED'),
140 (2702, 19.99, 300, 200, 38, '2025-04-12', 'NOT_STARTED'),
141 (2703, 19.99, 400, 200, 42, '2025-04-12', 'NOT_STARTED'),
142 (2704, 19.99, 500, 200, 45, '2025-04-12', 'NOT_STARTED'),
143 (2705, 19.99, 600, 100, 30, '2025-04-13', 'NOT_STARTED'),
144 (2706, 19.99, 700, 300, 35, '2025-04-13', 'NOT_STARTED'),
145 (2707, 19.99, 800, 100, 40, '2025-04-13', 'NOT_STARTED'),
146 (2708, 19.99, 801, 100, 32, '2025-04-14', 'NOT_STARTED'),
147 (2709, 19.99, 802, 100, 28, '2025-04-14', 'NOT_STARTED'),
148 (2800, 19.99, 100, 100, 45, '2025-05-15', 'NOT_STARTED'),
149 (2801, 19.99, 200, 200, 40, '2025-05-15', 'NOT_STARTED'),
150 (2802, 19.99, 300, 200, 35, '2025-05-16', 'NOT_STARTED'),
151 (2803, 19.99, 400, 200, 38, '2025-05-16', 'NOT_STARTED'),
152 (2804, 19.99, 500, 200, 42, '2025-05-17', 'NOT_STARTED'),
153 (2805, 19.99, 700, 300, 40, '2025-05-17', 'NOT_STARTED'),
154 (2806, 19.99, 800, 100, 35, '2025-05-18', 'NOT_STARTED'),
155 (2807, 19.99, 803, 200, 45, '2025-05-18', 'NOT_STARTED'),
156 (2808, 19.99, 804, 200, 38, '2025-05-19', 'NOT_STARTED'),
157 (2809, 19.99, 807, 300, 40, '2025-05-19', 'NOT_STARTED');
158
159INSERT INTO trip_stops (trip_stop_id, trip_id, location_id, stop_time)
160VALUES (300, 400, 300, '19:00'),
161 (400, 400, 100, '20:00'),
162 (500, 500, 200, '15:30'),
163 (600, 500, 100, '16:45'),
164 (700, 600, 600, '09:10'),
165 (800, 600, 200, '12:30'),
166 (900, 700, 400, '19:00'),
167 (1000, 700, 600, '22:30'),
168 (1100, 800, 500, '11:10'),
169 (1200, 800, 200, '12:30'),
170 (1300, 800, 100, '01:10'),
171 (1499, 800, 200, '02:00'),
172 (1500, 1000, 100, '08:00'),
173 (1501, 1000, 900, '09:15'),
174 (1502, 1000, 300, '11:00'),
175 (1901, 1400, 100, '08:00'),
176 (1902, 1400, 200, '09:30'),
177 (2001, 1500, 300, '07:00'),
178 (2002, 1500, 500, '10:00'),
179 (2003, 1500, 100, '12:00'),
180 (2101, 1600, 300, '06:15'),
181 (2102, 1600, 200, '08:30'),
182 (2201, 1700, 300, '09:00'),
183 (2202, 1700, 100, '11:30'),
184 (2301, 1800, 100, '13:00'),
185 (2302, 1800, 300, '16:00'),
186 (1600, 1100, 200, '07:30'),
187 (1601, 1100, 500, '08:10'),
188 (1602, 1100, 400, '09:00'),
189 (1603, 1100, 300, '10:00'),
190 (1700, 1200, 300, '14:00'),
191 (1701, 1200, 800, '15:10'),
192 (1702, 1200, 1000, '16:00'),
193 (1703, 1200, 200, '17:30'),
194 (1800, 1300, 300, '06:00'),
195 (1801, 1300, 700, '07:30'),
196 (1802, 1300, 100, '09:45'),
197 (3000, 2400, 100, '08:00'),
198 (3001, 2400, 300, '10:30'),
199 (3002, 2401, 100, '09:00'),
200 (3003, 2401, 200, '10:15'),
201 (3004, 2402, 200, '11:00'),
202 (3005, 2402, 300, '12:45'),
203 (3006, 2403, 300, '13:30'),
204 (3007, 2403, 200, '15:00'),
205 (3008, 2404, 300, '16:00'),
206 (3009, 2404, 100, '18:30'),
207 (3010, 2407, 200, '07:30'),
208 (3011, 2407, 400, '09:00'),
209 (3012, 2408, 400, '10:15'),
210 (3013, 2408, 700, '12:00'),
211 (3014, 2409, 700, '13:45'),
212 (3015, 2409, 800, '15:30'),
213 (3100, 2500, 100, '06:00'),
214 (3101, 2500, 300, '08:30'),
215 (3102, 2501, 100, '07:00'),
216 (3103, 2501, 200, '08:15'),
217 (3104, 2502, 200, '09:00'),
218 (3105, 2502, 300, '10:45'),
219 (3106, 2505, 100, '14:00'),
220 (3107, 2505, 300, '16:30'),
221 (3108, 2506, 100, '15:00'),
222 (3109, 2506, 200, '16:15'),
223 (3110, 2510, 100, '18:00'),
224 (3111, 2510, 300, '20:30'),
225 (3112, 2515, 100, '19:00'),
226 (3113, 2515, 300, '21:30'),
227 (3114, 2520, 100, '05:30'),
228 (3115, 2520, 300, '08:00');
229
230
231INSERT INTO payment (payment_id, account_id, date, total_price, n_tickets)
232VALUES (100, 300, '02-02-2025', 20.98, 2),
233 (200, 300, '03-02-2025', 9.99, 1),
234 (300, 300, '2025-02-10', 25.99, 2),
235 (400, 300, '2025-02-11', 19.50, 1),
236 (500, 300, '2025-02-12', 45.75, 3),
237 (600, 300, '2025-02-13', 32.00, 2),
238 (700, 300, '2025-02-14', 15.25, 1),
239 (800, 300, '2025-02-15', 67.80, 4),
240 (900, 300, '2025-02-16', 28.90, 2),
241 (1000, 300, '2025-02-17', 12.99, 1),
242 (1100, 300, '2025-02-18', 38.45, 2),
243 (1200, 300, '2025-02-19', 54.30, 3),
244 (1300, 100, '2025-01-10', 89.75, 5),
245 (1301, 200, '2025-01-10', 45.50, 3),
246 (1302, 300, '2025-01-11', 67.25, 4),
247 (1303, 400, '2025-01-11', 23.99, 2),
248 (1304, 100, '2025-01-12', 156.80, 8),
249 (1305, 200, '2025-01-12', 78.45, 5),
250 (1306, 300, '2025-01-13', 34.75, 2),
251 (1307, 400, '2025-01-13', 92.30, 6),
252 (1308, 100, '2025-01-14', 45.99, 3),
253 (1309, 200, '2025-01-14', 134.85, 7),
254 (1310, 300, '2025-01-15', 58.50, 4),
255 (1311, 400, '2025-01-15', 27.75, 2),
256 (1312, 100, '2025-01-16', 98.60, 6),
257 (1313, 200, '2025-01-16', 65.25, 4),
258 (1314, 300, '2025-01-17', 189.99, 9),
259 (1315, 400, '2025-01-17', 76.80, 5),
260 (1316, 100, '2025-01-18', 43.50, 3),
261 (1317, 200, '2025-01-18', 112.75, 7),
262 (1318, 300, '2025-01-19', 85.40, 5),
263 (1319, 400, '2025-01-19', 36.99, 2),
264 (1320, 100, '2025-01-20', 167.25, 8),
265 (1400, 100, '2025-02-01', 234.75, 10),
266 (1401, 200, '2025-02-01', 145.80, 8),
267 (1402, 300, '2025-02-01', 198.50, 9),
268 (1403, 400, '2025-02-01', 87.25, 5),
269 (1404, 100, '2025-02-02', 298.60, 12),
270 (1405, 200, '2025-02-02', 176.40, 9),
271 (1406, 300, '2025-02-02', 123.75, 7),
272 (1407, 400, '2025-02-02', 254.90, 11),
273 (1408, 100, '2025-02-03', 189.99, 9),
274 (1409, 200, '2025-02-03', 267.85, 12),
275 (1410, 300, '2025-02-03', 145.50, 8),
276 (1411, 400, '2025-02-03', 98.75, 6),
277 (1412, 100, '2025-02-04', 334.60, 14),
278 (1413, 200, '2025-02-04', 215.25, 10),
279 (1414, 300, '2025-02-04', 178.99, 9),
280 (1415, 400, '2025-02-04', 156.80, 8),
281 (1416, 100, '2025-02-05', 87.50, 5),
282 (1417, 200, '2025-02-05', 245.75, 11),
283 (1418, 300, '2025-02-05', 198.40, 9),
284 (1419, 400, '2025-02-05', 123.99, 7);
285
286
287INSERT INTO ticket (ticket_id, trip_id, gets_on_location_id, gets_off_location_id, account_id, date_purchased,
288 time_purchased, price, seat, payment_id)
289VALUES (301, 400, 100, 200, 300, '08-08-2025', '10:45', 12.50, '12A', 200),
290 (302, 500, 200, 300, 300, '08-09-2025', '10:50', 12.50, '12B', 200),
291 (303, 600, 100, 300, 300, '07-9-2025', '11:05', 9.99, '15', 200),
292 (304, 600, 200, 300, 300, '03-02-2025', '11:20', 9.99, '16', 200),
293 (305, 700, 300, 200, 300, '04-02-2025', '12:00', 11.00, '20A', 200),
294 (306, 800, 300, 100, 300, '04-02-2025', '12:15', 11.00, '20B', 200),
295 (307, 900, 100, 300, 300, '05-02-2025', '13:10', 14.00, '25A', 200),
296 (308, 1000, 200, 100, 300, '05-02-2025', '13:20', 14.00, '25B', 200),
297 (309, 1100, 300, 100, 300, '06-02-2025', '14:40', 9.50, '30A', 200),
298 (310, 1200, 200, 300, 300, '06-02-2025', '14:50', 9.50, '30B', 200),
299 (311, 1300, 600, 200, 300, '06-02-2025', '15:10', 9.50, '30C', 200),
300 (100, 1400, 100, 100, 300, '02-02-2025', '10:03', 10.99, '3', 100),
301 (101, 400, 100, 100, 300, '02-02-2025', '10:03', 10.99, '4', 100),
302 (102, 400, 100, 100, 300, '02-02-2025', '10:03', 10.99, '5', 100),
303 (103, 400, 100, 100, 300, '02-02-2025', '10:03', 10.99, '6', 100),
304 (104, 400, 100, 100, 300, '02-02-2025', '10:03', 10.99, '7', 100),
305 (105, 400, 100, 100, 300, '02-02-2025', '10:03', 10.99, '8', 100),
306 (200, 400, 100, 300, 300, '02-02-2025', '10:04', 10.99, '4', 200),
307 (300, 600, 100, 300, 300, '03-02-2025', '09:32', 9.99, '30', 200),
308 (1000, 2400, 100, 300, 100, '2025-01-10', '09:15', 18.50, '1A', 1300),
309 (1001, 2400, 100, 300, 100, '2025-01-10', '09:15', 18.50, '1B', 1300),
310 (1002, 2400, 100, 300, 100, '2025-01-10', '09:15', 18.50, '1C', 1300),
311 (1003, 2400, 100, 300, 100, '2025-01-10', '09:15', 17.25, '2A', 1300),
312 (1004, 2400, 100, 300, 100, '2025-01-10', '09:15', 17.00, '2B', 1300),
313 (1005, 2401, 100, 200, 200, '2025-01-10', '10:30', 15.50, '3A', 1301),
314 (1006, 2401, 100, 200, 200, '2025-01-10', '10:30', 15.50, '3B', 1301),
315 (1007, 2401, 100, 200, 200, '2025-01-10', '10:30', 14.50, '4A', 1301),
316 (1008, 2402, 200, 300, 300, '2025-01-11', '11:45', 16.75, '5A', 1302),
317 (1009, 2402, 200, 300, 300, '2025-01-11', '11:45', 16.75, '5B', 1302),
318 (1010, 2402, 200, 300, 300, '2025-01-11', '11:45', 16.75, '6A', 1302),
319 (1011, 2402, 200, 300, 300, '2025-01-11', '11:45', 17.00, '6B', 1302),
320 (1012, 2403, 300, 200, 400, '2025-01-11', '12:30', 12.00, '7A', 1303),
321 (1013, 2403, 300, 200, 400, '2025-01-11', '12:30', 11.99, '7B', 1303),
322 (1020, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.60, '8A', 1304),
323 (1021, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.60, '8B', 1304),
324 (1022, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.60, '9A', 1304),
325 (1023, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.60, '9B', 1304),
326 (1024, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.60, '10A', 1304),
327 (1025, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.60, '10B', 1304),
328 (1026, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.60, '11A', 1304),
329 (1027, 2404, 300, 100, 100, '2025-01-12', '13:15', 19.40, '11B', 1304),
330 (1030, 2407, 200, 400, 200, '2025-01-12', '14:00', 15.69, '12A', 1305),
331 (1031, 2407, 200, 400, 200, '2025-01-12', '14:00', 15.69, '12B', 1305),
332 (1032, 2407, 200, 400, 200, '2025-01-12', '14:00', 15.69, '13A', 1305),
333 (1033, 2407, 200, 400, 200, '2025-01-12', '14:00', 15.69, '13B', 1305),
334 (1034, 2407, 200, 400, 200, '2025-01-12', '14:00', 15.69, '14A', 1305),
335 (1040, 2408, 400, 700, 300, '2025-01-13', '15:30', 17.25, '15A', 1306),
336 (1041, 2408, 400, 700, 300, '2025-01-13', '15:30', 17.50, '15B', 1306),
337 (1050, 2409, 700, 800, 400, '2025-01-13', '16:15', 15.38, '16A', 1307),
338 (1051, 2409, 700, 800, 400, '2025-01-13', '16:15', 15.38, '16B', 1307),
339 (1052, 2409, 700, 800, 400, '2025-01-13', '16:15', 15.38, '17A', 1307),
340 (1053, 2409, 700, 800, 400, '2025-01-13', '16:15', 15.38, '17B', 1307),
341 (1054, 2409, 700, 800, 400, '2025-01-13', '16:15', 15.38, '18A', 1307),
342 (1055, 2409, 700, 800, 400, '2025-01-13', '16:15', 15.38, '18B', 1307),
343 (1100, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '1A', 1400),
344 (1101, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '1B', 1400),
345 (1102, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '1C', 1400),
346 (1103, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '1D', 1400),
347 (1104, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '2A', 1400),
348 (1105, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '2B', 1400),
349 (1106, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '2C', 1400),
350 (1107, 2500, 100, 300, 100, '2025-02-01', '07:30', 24.50, '2D', 1400),
351 (1108, 2500, 100, 300, 100, '2025-02-01', '07:30', 22.75, '3A', 1400),
352 (1109, 2500, 100, 300, 100, '2025-02-01', '07:30', 22.00, '3B', 1400),
353 (1120, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.22, '4A', 1401),
354 (1121, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.22, '4B', 1401),
355 (1122, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.22, '5A', 1401),
356 (1123, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.22, '5B', 1401),
357 (1124, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.22, '6A', 1401),
358 (1125, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.22, '6B', 1401),
359 (1126, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.22, '7A', 1401),
360 (1127, 2501, 100, 200, 200, '2025-02-01', '08:45', 18.14, '7B', 1401),
361 (1140, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '8A', 1402),
362 (1141, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '8B', 1402),
363 (1142, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '9A', 1402),
364 (1143, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '9B', 1402),
365 (1144, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '10A', 1402),
366 (1145, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '10B', 1402),
367 (1146, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '11A', 1402),
368 (1147, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '11B', 1402),
369 (1148, 2502, 200, 300, 300, '2025-02-01', '10:00', 22.06, '12A', 1402),
370 (1160, 2503, 300, 200, 400, '2025-02-01', '11:15', 17.45, '13A', 1403),
371 (1161, 2503, 300, 200, 400, '2025-02-01', '11:15', 17.45, '13B', 1403),
372 (1162, 2503, 300, 200, 400, '2025-02-01', '11:15', 17.45, '14A', 1403),
373 (1163, 2503, 300, 200, 400, '2025-02-01', '11:15', 17.45, '14B', 1403),
374 (1164, 2503, 300, 200, 400, '2025-02-01', '11:15', 17.45, '15A', 1403),
375 (1200, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '16A', 1404),
376 (1201, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '16B', 1404),
377 (1202, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '17A', 1404),
378 (1203, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '17B', 1404),
379 (1204, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '18A', 1404),
380 (1205, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '18B', 1404),
381 (1206, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '19A', 1404),
382 (1207, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '19B', 1404),
383 (1208, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '20A', 1404),
384 (1209, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '20B', 1404),
385 (1210, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '21A', 1404),
386 (1211, 2505, 100, 300, 100, '2025-02-02', '12:30', 24.88, '21B', 1404),
387 (1220, 2506, 100, 200, 200, '2025-02-02', '13:45', 19.60, '22A', 1405),
388 (1221, 2506, 100, 200, 200, '2025-02-02', '13:45', 19.60, '22B', 1405),
389 (1222, 2506, 100, 200, 200, '2025-02-02', '13:45', 19.60, '23A', 1405),
390 (1223, 2506, 100, 200, 200, '2025-02-02', '13:45', 19.60, '23B', 1405),
391 (1224, 2506, 100, 200, 200, '2025-02-02', '13:45', 19.60, '24A', 1405),
392 (1225, 2506, 100, 200, 200, '2025-02-02', '13:45', 19.60, '24B', 1405);
393
394-- Insert new routes for Struga to Skopje and Struga to Veles
395INSERT INTO route (route_id, transport_organizer_id, from_location_id, to_location_id)
396VALUES (810, 100, 900, 300), -- Struga to Skopje
397 (811, 100, 900, 400);
398-- Struga to Veles
399-- Insert trips
400INSERT INTO trip (trip_id, route_id, transport_organizer_id, free_seats, date, status)
401VALUES (2900, 100, 100, 40, '2026-03-01', 'NOT_STARTED'), -- Ohrid -> Bitola -> Kicevo -> Skopje
402 (2901, 100, 100, 35, '2026-03-02', 'NOT_STARTED'), -- Ohrid -> Kicevo -> Skopje
403 (2902, 100, 100, 30, '2026-03-03', 'NOT_STARTED'), -- Ohrid -> Prilep -> Bitola -> Kicevo -> Skopje
404 (2903, 811, 100, 45, '2026-03-04', 'NOT_STARTED'), -- Struga -> Ohrid -> Skopje -> Veles
405 (2904, 810, 100, 38, '2026-03-05', 'NOT_STARTED');
406-- Struga -> Ohrid -> Skopje
407
408-- Insert stops for each trip
409INSERT INTO trip_stops (trip_stop_id, trip_id, location_id, stop_time)
410VALUES
411 -- Trip 2900: Ohrid -> Bitola -> Kicevo -> Skopje
412 (3200, 2900, 100, '08:00'), -- Ohrid
413 (3201, 2900, 200, '09:00'), -- Bitola
414 (3202, 2900, 1100, '10:00'), -- Kicevo
415 (3203, 2900, 300, '11:00'), -- Skopje
416 -- Trip 2901: Ohrid -> Kicevo -> Skopje
417 (3204, 2901, 100, '09:00'), -- Ohrid
418 (3205, 2901, 1100, '10:00'), -- Kicevo
419 (3206, 2901, 300, '11:00'), -- Skopje
420 -- Trip 2902: Ohrid -> Prilep -> Bitola -> Kicevo -> Skopje
421 (3207, 2902, 100, '07:00'), -- Ohrid
422 (3208, 2902, 500, '08:00'), -- Prilep
423 (3209, 2902, 200, '09:00'), -- Bitola
424 (3210, 2902, 1100, '10:00'), -- Kicevo
425 (3211, 2902, 300, '11:00'), -- Skopje
426 -- Trip 2903: Struga -> Ohrid -> Skopje -> Veles
427 (3212, 2903, 900, '07:00'), -- Struga
428 (3213, 2903, 100, '08:00'), -- Ohrid
429 (3214, 2903, 300, '10:00'), -- Skopje
430 (3215, 2903, 400, '11:00'), -- Veles
431 -- Trip 2904: Struga -> Ohrid -> Skopje
432 (3216, 2904, 900, '08:00'), -- Struga
433 (3217, 2904, 100, '09:00'), -- Ohrid
434 (3218, 2904, 300, '11:00'); -- Skopje
435
436INSERT INTO review (account_id, ticket_id, description, rating)
437VALUES (100, 1001, 'Service was quick.', 4),
438 (200, 1005, 'Could improve response time.', 3),
439 (300, 1010, 'Very helpful staff.', 5),
440 (200, 1025, 'Not satisfied.', 2),
441 (300, 1032, 'Excellent service.', 5);
442
443
444INSERT INTO favorite (favorite_id, route_id, account_id)
445VALUES (144, 100, 300),
446 (244, 200, 300),
447 (344, 300, 300),
448 (4123, 400, 300),
449 (10123, 100, 100),
450 (203, 200, 100),
451 (302, 300, 100),
452 (404, 400, 100),
453 (1005, 100, 200),
454 (2020, 200, 200),
455 (3030, 300, 200),
456 (4050, 400, 200);
457
458INSERT INTO account (account_id, email, name, surname, password)
459VALUES
460 (601, 'marko.driver@example.com', 'Marko', 'Markovski', '$2a$12$pr3az9qix0CnAsX84C2clu9cG9JDlfqfK.sMqaFhPYR7D5fiz8BjO'), -- pw d
461 (602, 'stefan.driver@example.com', 'Stefan', 'Stefanovski', '$2a$12$pr3az9qix0CnAsX84C2clu9cG9JDlfqfK.sMqaFhPYR7D5fiz8BjO'),
462 (603, 'elena.driver@example.com', 'Elena', 'Elenova', '$2a$12$pr3az9qix0CnAsX84C2clu9cG9JDlfqfK.sMqaFhPYR7D5fiz8BjO'),
463 (604, 'bojan.driver@example.com', 'Bojan', 'Bojanovski', '$2a$12$pr3az9qix0CnAsX84C2clu9cG9JDlfqfK.sMqaFhPYR7D5fiz8BjO');
464
465
466INSERT INTO driver (driver_id, account_id, years_experience, transport_organizer_id)
467VALUES
468 (2001, 601, 5, 100),
469 (2002, 602, 8, 200),
470 (2003, 603, 6, 300),
471 (2004, 604, 10, 100);
472
473
474INSERT INTO driver_drives_on_trip (driver_drives_on_trip_id, driver_id, trip_id)
475VALUES
476 (10, 2001, 400),
477 (11, 2002, 500),
478 (12, 2003, 600),
479 (13, 2004, 700);