logicalAndPhysicalDesign: web3EdnevnikINSERT_v3.sql

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