RelationalDesign: web3EdnevnikINSERT_v1.sql

File web3EdnevnikINSERT_v1.sql, 10.8 KB (added by 192063, 7 months ago)
Line 
1INSERT INTO Admin_User (id, e_posta, lozinka, ime, prezime, active)
2VALUES
3('ab4793e3-ae36-4ad0-a1bd-2dbef91e0067', 'admin@admin.com', '$2b$14$w.cdYrNuTVMLQR5dggpgO.8KrjNvTr29o2n9aJmzUSvIq3hTN7nou', 'Admin', 'Adminovski', true),
4('a1dfd590-5875-4f29-88cd-62cc8f5904e0', 'vasil@admin.com', '$2b$14$7htdVrnMwtY05hoZFJSdaemWkCCP2cnNhu3eZ1GMHWwQiaom1O7/i', 'Vasil', 'Finkovski', true);
5
6INSERT INTO
7 Mon_Admin (id, active)
8VALUES (
9 'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067',
10 true
11 );
12
13INSERT INTO
14 Direktor_Admin (id, kreiran_Od, active)
15VALUES (
16 'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
17 'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067',
18 true
19 );
20
21INSERT INTO Korisnik (id, e_posta, lozinka, ime, prezime, pol, adresa, kreiranOd_Id, active)
22VALUES
23('3e26f4d3-0ecd-4810-bc47-3b531b154a30', 'nikola@user.com', '$2b$14$B6JlbUEuyt0TbGS3rRtZleYumI7TWg6pOcHICLm6HAKGBzlC.Vr2O', 'Nikola', 'Janev', 'Masko', 'Skopje', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true),
24('266a48c7-56cb-42d9-baa5-becbef00fd4c', 'petar@user.com', '$2b$14$gFAe804W5/3kNq6spMGltOFCmvoqLHJYe5FJ8.nOzOq499bwGChaW', 'Petar', 'Veljanov', 'Masko', 'Skopje', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true),
25('a4dee448-48e5-441f-a18f-b08f0825035f', 'ivan@user.com', '$2b$14$5.x1eFPI9w6zYAFlIh2oauPh0GZNewV8N4SiIIvHd6mgS4u9DivMO', 'Ivan', 'Gjorevski', 'Masko', 'Skopje', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true),
26('761eb4c6-689f-4495-ab70-fc10650ccb77', 'marija@user.com', '$2a$14$YLico7eJVBrsXmaI7VKkueK0.fOgawmIDpwomyEch028OXIZSnkOa', 'Marija', 'Teonova', 'Zensko', 'Skopje', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true),
27('4dac75d0-fdea-4cb2-93f6-b2bb6b176c19', 'teon@user.com', '$2b$14$PJ7CpIs1BwQOElp1lUfy1eaOpYAVD43ti5MI2XP53X30QFbJhtdYS', 'Teon', 'Kirov', 'Masko', 'Strumica', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true),
28('3eddcc80-05ea-40d2-ae5f-80cee9eb250d', 'mirjana@user.com', '$2b$14$8Py79QACAIZkpyXYgFW3X.EYFXQ/6.lHyB/IiYNM/QtbvRKOedcWe', 'Mirjana', 'Temelkovska', 'Zensko', 'Kumanovo', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true),
29('9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f', 'roze@user.com', '$2b$14$PoUtM6OEX0LsFqV70de2VONL.aHlZO5ieFDts0r27Rw7E5fPM10N2', 'Roze', 'Zaneva', 'Zensko', 'Kumanovo', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true),
30('18d82d24-9d9f-4c0b-9692-f7a87174cb4c', 'aegon@user.com', '$2b$14$ZHwFP.imOTgHe6koSFL1k.M7UYEnJ23GEAM2IIiT0sPTlZgIorkxO', 'Aegon', 'Targeryen', 'Masko', 'Dragonstone', 'a1dfd590-5875-4f29-88cd-62cc8f5904e0', true);
31
32
33INSERT INTO
34 Nastavnik (id, active)
35VALUES (
36 '761eb4c6-689f-4495-ab70-fc10650ccb77',
37 true
38 ),
39 (
40 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
41 true
42 );
43
44INSERT INTO
45 Klasen_Rakovoditel (id, active)
46VALUES (
47 '761eb4c6-689f-4495-ab70-fc10650ccb77',
48 true
49 );
50
51INSERT INTO
52 Predmeten_Nastavnik (id, active)
53VALUES (
54 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
55 true
56 );
57
58INSERT INTO
59 Blagajnik (id, metamusk_adresa, active)
60VALUES (
61 '3eddcc80-05ea-40d2-ae5f-80cee9eb250d',
62 '0x1ab6B15AfE81B57fF4a692fbb8C141A1858941e0',
63 true
64 );
65
66INSERT INTO
67 Roditel (id, metamusk_adresa, active)
68VALUES (
69 '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
70 '0x0C3AD145d914B9Bf09Ac31B653d94764e440027A',
71 true
72 );
73
74
75INSERT INTO
76 Raspored (
77 id,
78 naslov,
79 tip,
80 izgotvenOd_Id,
81 active
82 )
83VALUES (
84 'b447c295-ef00-4cf9-a584-64f27c2ea462',
85 'Privremen raspored',
86 'privremen',
87 'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
88 true
89 );
90
91
92INSERT INTO
93 Klas (
94 id,
95 godinaNa_Slusanje,
96 paralelka,
97 oddelenie,
98 koristiRasporedId,
99 klasen_rakovoditel_id,
100 active
101 )
102VALUES (
103 '0c9f923d-c4b0-4037-9812-24610bee82a2',
104 '2019/2020',
105 'A',
106 9,
107 'b447c295-ef00-4cf9-a584-64f27c2ea462',
108 '761eb4c6-689f-4495-ab70-fc10650ccb77',
109 true
110 );
111
112
113INSERT INTO
114 Ucenik (
115 id,
116 mestoNa_ragjanje,
117 mobilen_telefon,
118 datumNa_ragjanje,
119 staratel_id,
120 uciVoKlas_id,
121 active
122 )
123VALUES (
124 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
125 'Westeros',
126 '072234235',
127 '2000-01-02',
128 '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
129 '0c9f923d-c4b0-4037-9812-24610bee82a2',
130 true
131 );
132
133INSERT INTO
134 AktivnostZa_NedelenPlan (
135 id,
136 naslov,
137 opis,
138 denVo_Nedelata,
139 active
140 )
141VALUES (
142 'b2210c06-f85c-4cf9-9de6-72ce6728d6af',
143 'Makedonski jazik',
144 'Raskazuvanje',
145 'Sreda',
146 true
147 );
148 INSERT INTO AktivnostZa_NedelenPlan(
149 id, naslov, opis, denVo_Nedelata)
150 VALUES(
151 'f2c231d2-945a-4cb4-9269-8c92793f5572',
152 'Francuski jazik',
153 'Obrabotka na zborovite vo treto lice',
154 'Ponedelnik'
155
156 ),
157 (
158 'b81265f3-14f1-41c8-9952-eaf4ce7acaac',
159 'Informatika 1',
160 'C++ vezbi 1',
161 'Sreda'
162
163 );
164
165
166INSERT INTO
167 Predmet (
168 id,
169 ime,
170 fond_casovi,
171 zaKlas_Id,
172 active
173 )
174VALUES (
175 '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
176 'Makedonski jazik',
177 30,
178 '0c9f923d-c4b0-4037-9812-24610bee82a2',
179 true
180 ),
181 (
182 '476e6ca8-347f-4bc9-af79-e4d448754cdf',
183 'Francuski jazik',
184 20,
185 '0c9f923d-c4b0-4037-9812-24610bee82a2',
186 true
187 ),
188 (
189 '820b1f2d-861d-4bed-a416-3e5e3e60d9dd',
190 'Informatika',
191 30,
192 '0c9f923d-c4b0-4037-9812-24610bee82a2',
193 true
194
195 );
196
197INSERT INTO
198 Cas (
199 id,
200 ime,
201 reden_cas,
202 predmet_Id,
203 active,
204 denVo_Nedelata
205 )
206VALUES (
207 '40e03e88-bdc7-4c51-9710-c739fd8ed78e',
208 'Makedonski jazik',
209 4,
210'31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
211 true,
212 'Vtornik'
213 );
214
215INSERT INTO
216 Nedelen_Plan (
217 id,
218 datum_Od,
219 datum_Do,
220 sledenOdKlas_Id,
221 active
222 )
223VALUES (
224 '8d6bd51f-aa61-45aa-a81d-94277075f20d',
225 '2025-12-19',
226 '2025-12-23',
227 '0c9f923d-c4b0-4037-9812-24610bee82a2',
228 true
229 );
230
231
232
233
234
235
236INSERT INTO
237 Ocenka (
238 id,
239 ocenka,
240 datum,
241 zabeleska,
242 vnesena_Od,
243 dobienaZaUcenikot_Id,
244 eZaPredmetot_Id,
245 zaAktivnosta_id
246 )
247VALUES (
248 '414acf3b-0e57-43d0-9aec-c3180523bd1e',
249 5,
250 CURRENT_DATE,
251 'Odlicno',
252 '761eb4c6-689f-4495-ab70-fc10650ccb77',
253 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
254 '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
255 'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
256
257 );
258
259INSERT INTO
260 Ocenka (
261 id,
262 ocenka,
263 datum,
264 zabeleska,
265 vnesena_Od,
266 dobienaZaUcenikot_Id,
267 eZaPredmetot_Id,
268 zaAktivnosta_id
269 )
270VALUES (
271 'bb78a56c-c2dc-4d15-adcf-7bf74290b74d',
272 4,
273 CURRENT_DATE,
274 'Mali sintaksicki greski',
275 '761eb4c6-689f-4495-ab70-fc10650ccb77',
276 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
277 '476e6ca8-347f-4bc9-af79-e4d448754cdf',
278 'f2c231d2-945a-4cb4-9269-8c92793f5572'
279 );
280
281INSERT INTO
282 Ocenka (
283 id,
284 ocenka,
285 datum,
286 zabeleska,
287 vnesena_Od,
288 dobienaZaUcenikot_Id,
289 eZaPredmetot_Id,
290 zaAktivnosta_id
291 )
292VALUES (
293 '22094917-c5df-4b7c-9c29-182db855f4a2',
294 4,
295 CURRENT_DATE,
296 'Krajna Usna ocenka za predmetot Informatika',
297 '761eb4c6-689f-4495-ab70-fc10650ccb77',
298 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
299 '820b1f2d-861d-4bed-a416-3e5e3e60d9dd',
300 NULL
301 );
302
303
304
305INSERT INTO
306 Usna_Ocenka (
307 id,
308 tema,
309 osvoeni_poeni,
310 max_poeni,
311 vid_isprasuvanje
312 )
313VALUES (
314 '414acf3b-0e57-43d0-9aec-c3180523bd1e',
315 'Prezentacija',
316 100,
317 100,
318 'usno'
319 );
320INSERT INTO
321 Pismena_Ocenka(
322 id,
323 tema,
324 osvoeni_poeni,
325 max_poeni,
326 vid
327 )
328VALUES (
329 'bb78a56c-c2dc-4d15-adcf-7bf74290b74d',
330 'Pismena rabota za romanot GOT',
331 80,
332 100,
333 'PISMENA_RABOTA'
334 );
335
336
337INSERT INTO Krajna_Ocenka (id, tip) VALUES('22094917-c5df-4b7c-9c29-182db855f4a2', 'PISMENA_OCENKA');
338
339
340
341INSERT INTO
342 SoopstenieZa_Plakjanje (
343 id,
344 naslov,
345 sodrzina,
346 rokZa_Plakjanje,
347 odobrenoOd_Id,
348 sozdadenoOdBlagajnik_Id,
349 active
350 )
351VALUES (
352 '8d3fa1eb-f432-4748-b849-a510d94f2b3d',
353 'Ekskurzija',
354 'Potrebno e da se plati 1 ETH.',
355 '2025-12-25',
356 'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
357 '3eddcc80-05ea-40d2-ae5f-80cee9eb250d',
358 true
359 );
360
361INSERT INTO
362 Plakjanje (
363 id,
364 status,
365 tx_hash,
366 valuta,
367 plateno_Na,
368 iznos,
369 platenoOdRoditel_Id,
370 soopstenie_za_plakjanje_id
371 )
372VALUES (
373 '01650e9f-5afa-48f6-be30-c65eb113ba64',
374 'Plateno',
375 '0xac219cf731dd4890d09521b07d7781a4b96c62edc0b5b8299bf64ab8ff42ac0a',
376 'ETH',
377 CURRENT_DATE,
378 1.000000000000000000,
379 '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
380 '8d3fa1eb-f432-4748-b849-a510d94f2b3d'
381 );
382
383INSERT INTO
384 KlasSlusa_Predmet (klas_Id, predmet_Id)
385VALUES (
386 '0c9f923d-c4b0-4037-9812-24610bee82a2',
387 '31d3cbd5-d598-4f60-9cae-f4786bb13ce9'
388 );
389
390INSERT INTO
391 NastavnikGoPredava_Predmetot (nastavnik_Id, predmet_Id)
392VALUES (
393 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
394 '476e6ca8-347f-4bc9-af79-e4d448754cdf'
395 );
396
397INSERT INTO
398 NedelenPlanOpfakja_Aktivnosti (
399 nedelenPlan_Id,
400 aktivnostZaNedelenPlan_Id
401 )
402VALUES (
403 '8d6bd51f-aa61-45aa-a81d-94277075f20d',
404 'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
405 );
406
407INSERT INTO
408 KlasenRakovoditelZapisuvaAktivnostZaNedelen_Plan (
409 klasenRakovoditel_Id,
410 aktivnostZaNedelenPlan_Id
411 )
412VALUES (
413 '761eb4c6-689f-4495-ab70-fc10650ccb77',
414 'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
415 );
416
417INSERT INTO
418 RasporedSodrzi_Cas (raspored_Id, cas_Id)
419VALUES (
420 'b447c295-ef00-4cf9-a584-64f27c2ea462',
421 '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
422 );
423
424
425 INSERT INTO Prisustvo(id, datum, status, zabeleska, evidentiranoOd_Id, seOdnesuvaNaUcenikot_Id, zaCasot_Id) VALUES(
426 '6a4e5101-1f4b-4a83-be8d-863279e44e8c',
427 '2026-02-14',
428 'PRISUTEN',
429 'Ucenikot bese prisuten na casot po makedonski jazik',
430 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
431 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
432 '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
433 );