logicalAndPhysicalDesign: web3EdnevnikINSERT_v1.sql

File web3EdnevnikINSERT_v1.sql, 14.0 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 )
9VALUES (
10 'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067',
11 'admin@admin.com',
12 'admin123',
13 'Admin',
14 'Adminovski'
15 );
16
17INSERT INTO
18 Admin_User (
19 id,
20 e_posta,
21 lozinka,
22 ime,
23 prezime
24 )
25VALUES (
26 'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
27 'vasil@admin.com',
28 'vasil',
29 'Vasil',
30 'Finkovski'
31 );
32
33INSERT INTO
34 Mon_Admin (id)
35VALUES (
36 'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067'
37 );
38
39INSERT INTO
40 Direktor_Admin (id, kreiran_Od)
41VALUES (
42 'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
43 'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067'
44 );
45
46INSERT INTO
47 Korisnik (
48 id,
49 e_posta,
50 lozinka,
51 ime,
52 prezime,
53 pol,
54 adresa,
55 kreiranOd_Id
56 )
57VALUES (
58 '3e26f4d3-0ecd-4810-bc47-3b531b154a30',
59 'nikola@user.com',
60 'nikola123',
61 'Nikola',
62 'Janev',
63 'Masko',
64 'ul. Rugjer Boskovikj br 16, Skopje, Republika Severna Makedonija',
65 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
66 );
67
68INSERT INTO
69 Korisnik (
70 id,
71 e_posta,
72 lozinka,
73 ime,
74 prezime,
75 pol,
76 adresa,
77 kreiranOd_Id
78 )
79VALUES (
80 '266a48c7-56cb-42d9-baa5-becbef00fd4c',
81 'petar@user.com',
82 'petar123',
83 'Petar',
84 'Veljanov',
85 'Masko',
86 'ul. Lerinska br 2, Skopje, Republika Severna Makedonija',
87 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
88 );
89
90INSERT INTO
91 Korisnik (
92 id,
93 e_posta,
94 lozinka,
95 ime,
96 prezime,
97 pol,
98 adresa,
99 kreiranOd_Id
100 )
101VALUES (
102 'a4dee448-48e5-441f-a18f-b08f0825035f',
103 'ivan@user.com',
104 'ivan123',
105 'Ivan',
106 'Gjorevski',
107 'Masko',
108 'ul. Ulica BB, Pestani, Skopje, Republika Severna Makedonija',
109 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
110 );
111
112INSERT INTO
113 Korisnik (
114 id,
115 e_posta,
116 lozinka,
117 ime,
118 prezime,
119 pol,
120 adresa,
121 kreiranOd_Id
122 )
123VALUES (
124 '761eb4c6-689f-4495-ab70-fc10650ccb77',
125 'marija@user.com',
126 'Mari@',
127 'Marija',
128 'Teonova',
129 'Zensko',
130 'ul. Ruzveltova, Karpos, Skopje, Republika Severna Makedonija',
131 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
132 );
133
134INSERT INTO
135 Korisnik (
136 id,
137 e_posta,
138 lozinka,
139 ime,
140 prezime,
141 pol,
142 adresa,
143 kreiranOd_Id
144 )
145VALUES (
146 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
147 'teon@user.com',
148 'Teon123',
149 'Teon',
150 'Kirov',
151 'Masko',
152 'ul. 234, Rabrovo, Strumica, Republika Severna Makedonija',
153 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
154 );
155
156INSERT INTO
157 Korisnik (
158 id,
159 e_posta,
160 lozinka,
161 ime,
162 prezime,
163 pol,
164 adresa,
165 kreiranOd_Id
166 )
167VALUES (
168 '3eddcc80-05ea-40d2-ae5f-80cee9eb250d',
169 'Mirjana@user.com',
170 'Mirjana123',
171 'Mirjana',
172 'Temelkovska',
173 'Zensko',
174 'ul. 2, Kumanovo, Republika Severna Makedonija',
175 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
176 );
177
178INSERT INTO
179 Nastavnik (id)
180VALUES (
181 '761eb4c6-689f-4495-ab70-fc10650ccb77'
182 );
183
184INSERT INTO
185 Nastavnik (id)
186VALUES (
187 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19'
188 );
189
190INSERT INTO
191 Klasen_Rakovoditel (id)
192VALUES (
193 '761eb4c6-689f-4495-ab70-fc10650ccb77'
194 );
195
196INSERT INTO
197 Predmeten_Nastavnik (id)
198VALUES (
199 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19'
200 );
201
202INSERT INTO
203 Blagajnik (id, metamusk_adresa)
204VALUES (
205 '3eddcc80-05ea-40d2-ae5f-80cee9eb250d',
206 '0x1ab6B15AfE81B57fF4a692fbb8C141A1858941e0'
207 );
208
209INSERT INTO
210 Korisnik (
211 id,
212 e_posta,
213 lozinka,
214 ime,
215 prezime,
216 pol,
217 adresa,
218 kreiranOd_Id
219 )
220VALUES (
221 '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
222 'Roze@user.com',
223 'Roze123',
224 'Roze',
225 'Zaneva',
226 'Zensko',
227 'ul. 2, Kumanovo, Republika Severna Makedonija',
228 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
229 );
230
231INSERT INTO
232 Roditel (id, metamusk_adresa)
233VALUES (
234 '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
235 '0x0C3AD145d914B9Bf09Ac31B653d94764e440027A'
236 );
237
238INSERT INTO
239 Klas (
240 id,
241 godinaNa_Slusanje,
242 paralelka,
243 oddelenie
244 )
245VALUES (
246 '0c9f923d-c4b0-4037-9812-24610bee82a2',
247 '2019/2020',
248 'A',
249 9
250 );
251
252INSERT INTO
253 Korisnik (
254 id,
255 e_posta,
256 lozinka,
257 ime,
258 prezime,
259 pol,
260 adresa,
261 kreiranOd_Id
262 )
263VALUES (
264 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
265 'aegon@user.com',
266 'Aegon123',
267 'Aegon',
268 'Targeryen',
269 'Masko',
270 'ul. BB, Dragonstone, The Seven Kingdoms of Westeros',
271 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
272 );
273
274INSERT INTO
275 Ucenik (
276 id,
277 mestoNa_ragjanje,
278 mobilen_telefon,
279 datumNa_ragjanje,
280 staratel_id,
281 imeNa_staratel,
282 uciVoKlas_id
283 )
284VALUES (
285 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
286 'The Seven Kingdoms of Westeros',
287 '072234235',
288 '2000-01-02',
289 '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
290 (
291 SELECT k.ime
292 FROM Korisnik k
293 JOIN Roditel r ON k.id = r.id
294 WHERE
295 k.id = '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f'
296 ),
297 '0c9f923d-c4b0-4037-9812-24610bee82a2'
298 );
299
300INSERT INTO
301 AktivnostZa_NedelenPlan (
302 id,
303 naslov,
304 opis,
305 denVo_Nedelata
306 )
307VALUES (
308 'b2210c06-f85c-4cf9-9de6-72ce6728d6af',
309 'Makedonski jazik',
310 'Raskazuvanje na knigata Igra na Tronovi',
311 'Sreda'
312 );
313
314INSERT INTO
315 AktivnostZa_NedelenPlan (
316 id,
317 naslov,
318 opis,
319 denVo_Nedelata
320 )
321VALUES (
322 '7f2a229e-1003-4343-a21c-4157bdd25be9',
323 'Francuski jazik',
324 'Gramatika na zborovite sakam i nejkam',
325 'Sreda'
326 );
327
328INSERT INTO
329 Cas (id, reden_cas, denVo_Nedelata)
330VALUES (
331 '40e03e88-bdc7-4c51-9710-c739fd8ed78e',
332 1,
333 'Ponedelnik'
334 );
335
336INSERT INTO
337 Cas (id, reden_cas, denVo_Nedelata)
338VALUES (
339 'd8492f47-b590-4889-bd37-f5246ce9cfe6',
340 6,
341 'Petok'
342 );
343
344INSERT INTO
345 Prisustvo (
346 id,
347 datum,
348 status,
349 zabeleska,
350 evidentiranoOd_Id,
351 seOdnesuvaNaUcenikot_Id,
352 zaCasot_Id
353 )
354VALUES (
355 'af39d067-49f0-446c-9855-0cf445d806bd',
356 CURRENT_DATE,
357 'otsuten',
358 'Ucenikot ne dojde na casot',
359 '761eb4c6-689f-4495-ab70-fc10650ccb77',
360 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
361 '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
362 );
363
364INSERT INTO
365 Predmet (
366 id,
367 ime,
368 fond_casovi,
369 zaKlas_Id
370 )
371VALUES (
372 '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
373 'Makedonski jazik',
374 30,
375 '0c9f923d-c4b0-4037-9812-24610bee82a2'
376 );
377
378INSERT INTO
379 Predmet (
380 id,
381 ime,
382 fond_casovi,
383 zaKlas_Id
384 )
385VALUES (
386 '476e6ca8-347f-4bc9-af79-e4d448754cdf',
387 'Francuski jazik',
388 20,
389 '0c9f923d-c4b0-4037-9812-24610bee82a2'
390 );
391
392INSERT INTO
393 Ocenka (
394 id,
395 ocenka,
396 datum,
397 zabeleska,
398 vnesena_Od,
399 dobienaZaUcenikot_Id,
400 eZaPredmetot_Id,
401 zaAktivnosta_id
402 )
403VALUES (
404 '414acf3b-0e57-43d0-9aec-c3180523bd1e',
405 5,
406 CURRENT_DATE,
407 'Ucenikot odlicno gi prezentirase temite',
408 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
409 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c', ---nastavnik-
410 '31d3cbd5-d598-4f60-9cae-f4786bb13ce9', --predmet--
411 'b2210c06-f85c-4cf9-9de6-72ce6728d6af' --aktivnost--
412 );
413
414INSERT INTO
415 Ocenka (
416 id,
417 ocenka,
418 datum,
419 zabeleska,
420 vnesena_Od,
421 dobienaZaUcenikot_Id,
422 eZaPredmetot_Id,
423 zaAktivnosta_id
424 )
425VALUES (
426 '5ddf06fa-824b-408b-986d-449aa6962964',
427 2,
428 CURRENT_DATE,
429 'Ucenikot postojano se buni za temata',
430 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
431 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
432 '476e6ca8-347f-4bc9-af79-e4d448754cdf',
433 '7f2a229e-1003-4343-a21c-4157bdd25be9'
434 );
435
436INSERT INTO
437 Ocenka (
438 id,
439 ocenka,
440 datum,
441 zabeleska,
442 vnesena_Od,
443 dobienaZaUcenikot_Id,
444 eZaPredmetot_Id,
445 zaAktivnosta_id
446 )
447VALUES (
448 'b06e9c9b-4007-4e4c-bd80-2480780d347d',
449 2,
450 CURRENT_DATE,
451 'Krajna ocenka',
452 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
453 '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
454 '476e6ca8-347f-4bc9-af79-e4d448754cdf',
455 '7f2a229e-1003-4343-a21c-4157bdd25be9'
456 );
457
458INSERT INTO
459 Usna_Ocenka (
460 id,
461 tema,
462 osvoeni_poeni,
463 max_poeni,
464 vid_isprasuvanje
465 )
466VALUES (
467 '414acf3b-0e57-43d0-9aec-c3180523bd1e',
468 'Prezentiranje na kniga Igra na Tronovi',
469 100,
470 100,
471 'usno'
472 );
473
474INSERT INTO
475 Pismena_Ocenka (
476 id,
477 tema,
478 osvoeni_poeni,
479 max_poeni,
480 vid
481 )
482VALUES (
483 '5ddf06fa-824b-408b-986d-449aa6962964',
484 'Test po Francuski jazik 1',
485 50,
486 100,
487 'test'
488 );
489
490INSERT INTO
491 Krajna_Ocenka (id, tip)
492VALUES (
493 'b06e9c9b-4007-4e4c-bd80-2480780d347d',
494 'polugodisna ocenka'
495 );
496
497INSERT INTO
498 Soopstenie (
499 id,
500 naslov,
501 sodrzina,
502 kreirano_Na,
503 zaKlas_Id,
504 postiranoOd_Id
505 )
506VALUES (
507 '75cf3e1a-8c63-4748-ac8d-4b717df62a7a',
508 'Petok 21.12 neraboten den',
509 'Dragi ucenici, ovoj petok, (21.12.2025), nastava nema da se odrzi poradi otsustvo na nastavnikot Ivo.',
510 CURRENT_DATE,
511 '0c9f923d-c4b0-4037-9812-24610bee82a2',
512 '761eb4c6-689f-4495-ab70-fc10650ccb77'
513 );
514
515INSERT INTO
516 Nedelen_Plan (
517 id,
518 datum_Od,
519 datum_Do,
520 sledenOdKlas_id
521 )
522VALUES (
523 '8d6bd51f-aa61-45aa-a81d-94277075f20d',
524 '2025-12-19',
525 '2025-12-23',
526 '0c9f923d-c4b0-4037-9812-24610bee82a2'
527 );
528
529INSERT INTO
530 Raspored (
531 id,
532 naslov,
533 tip,
534 izgotvenOd_Id
535 )
536VALUES (
537 'b447c295-ef00-4cf9-a584-64f27c2ea462',
538 'Privremen raspored za klas 9-A',
539 'privremen',
540 'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
541 );
542
543INSERT INTO
544 SoopstenieZa_Plakjanje (
545 id,
546 naslov,
547 sodrzina,
548 rokZa_Plakjanje,
549 odobrenoOd_Id,
550 sozdadenoOdBlagajnik_Id
551 )
552VALUES (
553 '8d3fa1eb-f432-4748-b849-a510d94f2b3d',
554 'Soopstenie za plakjanje na ednodnevna ekskurzija vo Dubai',
555 'Pocituvani roditeli! Na den 31.12.2025 ke se organizira ednodnevna ekskurzija vo Dubai, so agencijata Rule Turs, zatoa se potrebni sekoj roditel da plati 1 ETH.',
556 '2025-12-25',
557 'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
558 '3eddcc80-05ea-40d2-ae5f-80cee9eb250d'
559 );
560
561INSERT INTO
562 Plakjanje (
563 id,
564 status,
565 tx_hash,
566 valuta,
567 plateno_Na,
568 iznos,
569 platenoOdRoditel_Id
570 )
571VALUES (
572 '01650e9f-5afa-48f6-be30-c65eb113ba64',
573 'Plateno',
574 '0xac219cf731dd4890d09521b07d7781a4b96c62edc0b5b8299bf64ab8ff42ac0a',
575 'ETH',
576 CURRENT_DATE,
577 1.000000000000000000,
578 '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f'
579 );
580
581INSERT INTO
582 KlasSlusa_Predmet (klas_Id, predmet_Id)
583VALUES (
584 '0c9f923d-c4b0-4037-9812-24610bee82a2',
585 '31d3cbd5-d598-4f60-9cae-f4786bb13ce9'
586 );
587
588INSERT INTO
589 NastavnikGoPredava_Predmetot (nastavnik_Id, predmet_Id)
590VALUES (
591 '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
592 '476e6ca8-347f-4bc9-af79-e4d448754cdf'
593 );
594
595INSERT INTO
596 NedelenPlanOpfakja_Aktivnosti (
597 nedelenPlan_Id,
598 aktivnostZaNedelenPlan_Id
599 )
600VALUES (
601 '8d6bd51f-aa61-45aa-a81d-94277075f20d',
602 'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
603 );
604
605INSERT INTO
606 KlasenRakovoditelZapisuvaAktivnostZaNedelen_Plan (
607 klasenRakovoditel_Id,
608 aktivnostZaNedelenPlan_Id
609 )
610VALUES (
611 '761eb4c6-689f-4495-ab70-fc10650ccb77',
612 'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
613 );
614
615INSERT INTO
616 RasporedSodrzi_Cas (raspored_Id, cas_Id)
617VALUES (
618 'b447c295-ef00-4cf9-a584-64f27c2ea462',
619 '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
620 );
621
622INSERT INTO
623 PredmetSePredavaNa_Cas (predmet_Id, cas_Id)
624VALUES (
625 '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
626 '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
627 );
628
629INSERT INTO
630 KlasenRakovoditelRakovodiSo_Klas (klasenRakovoditel_Id, klas_Id)
631VALUES (
632 '761eb4c6-689f-4495-ab70-fc10650ccb77',
633 '0c9f923d-c4b0-4037-9812-24610bee82a2'
634 );
635
636INSERT INTO
637 KlasKoristi_Raspored (klas_Id, raspored_Id)
638VALUES (
639 '0c9f923d-c4b0-4037-9812-24610bee82a2',
640 'b447c295-ef00-4cf9-a584-64f27c2ea462'
641 );
642
643INSERT INTO
644 SoopstenieZaPlakjanjeVklucuva_Plakjanje (
645 soopstenieZaPlakjanje_Id,
646 plakjanje_Id
647 )
648VALUES (
649 '8d3fa1eb-f432-4748-b849-a510d94f2b3d',
650 '01650e9f-5afa-48f6-be30-c65eb113ba64'
651 )