

INSERT INTO
    Mon_Admin (id)
VALUES (
        'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067'
    );

INSERT INTO
    Direktor_Admin (id, kreiran_Od)
VALUES (
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067'
    );

INSERT INTO
    Nastavnik (id)
VALUES (
        '761eb4c6-689f-4495-ab70-fc10650ccb77'
    );

INSERT INTO
    Nastavnik (id)
VALUES (
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19'
    );

INSERT INTO
    Klasen_Rakovoditel (id)
VALUES (
        '761eb4c6-689f-4495-ab70-fc10650ccb77'
    );

INSERT INTO
    Predmeten_Nastavnik (id)
VALUES (
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19'
    );

INSERT INTO
    Blagajnik (id, metamusk_adresa)
VALUES (
        '3eddcc80-05ea-40d2-ae5f-80cee9eb250d',
        '0x1ab6B15AfE81B57fF4a692fbb8C141A1858941e0'
    );

INSERT INTO
    Roditel (id, metamusk_adresa)
VALUES (
        '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
        '0x0C3AD145d914B9Bf09Ac31B653d94764e440027A'
    );

INSERT INTO
    Klas (
        id,
        godinaNa_Slusanje,
        paralelka,
        oddelenie
    )
VALUES (
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '2019/2020',
        'A',
        9
    );

INSERT INTO
    AktivnostZa_NedelenPlan (
        id,
        naslov,
        opis,
        denVo_Nedelata
    )
VALUES (
        'b2210c06-f85c-4cf9-9de6-72ce6728d6af',
        'Makedonski jazik',
        'Raskazuvanje na knigata Igra na Tronovi',
        'Sreda'
    );

INSERT INTO
    AktivnostZa_NedelenPlan (
        id,
        naslov,
        opis,
        denVo_Nedelata
    )
VALUES (
        '7f2a229e-1003-4343-a21c-4157bdd25be9',
        'Francuski jazik',
        'Gramatika na zborovite sakam i nejkam',
        'Sreda'
    );

INSERT INTO
    Cas (id, reden_cas, denVo_Nedelata)
VALUES (
        '40e03e88-bdc7-4c51-9710-c739fd8ed78e',
        1,
        'Ponedelnik'
    );

INSERT INTO
    Cas (id, reden_cas, denVo_Nedelata)
VALUES (
        'd8492f47-b590-4889-bd37-f5246ce9cfe6',
        6,
        'Petok'
    );

INSERT INTO
    Prisustvo (
        id,
        datum,
        status,
        zabeleska,
        evidentiranoOd_Id,
        seOdnesuvaNaUcenikot_Id,
        zaCasot_Id
    )
VALUES (
        'af39d067-49f0-446c-9855-0cf445d806bd',
        CURRENT_DATE,
        'otsuten',
        'Ucenikot ne dojde na casot',
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
    );

INSERT INTO
    Predmet (
        id,
        ime,
        fond_casovi,
        zaKlas_Id
    )
VALUES (
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
        'Makedonski jazik',
        30,
        '0c9f923d-c4b0-4037-9812-24610bee82a2'
    );

INSERT INTO
    Predmet (
        id,
        ime,
        fond_casovi,
        zaKlas_Id
    )
VALUES (
        '476e6ca8-347f-4bc9-af79-e4d448754cdf',
        'Francuski jazik',
        20,
        '0c9f923d-c4b0-4037-9812-24610bee82a2'
    );

INSERT INTO
    Ocenka (
        id,
        ocenka,
        datum,
        zabeleska,
        vnesena_Od,
        dobienaZaUcenikot_Id,
        eZaPredmetot_Id,
        zaAktivnosta_id
    )
VALUES (
        '414acf3b-0e57-43d0-9aec-c3180523bd1e',
        5,
        CURRENT_DATE,
        'Ucenikot odlicno gi prezentirase temite',
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c', ---nastavnik-
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9', --predmet--
        'b2210c06-f85c-4cf9-9de6-72ce6728d6af' --aktivnost--
    );

INSERT INTO
    Ocenka (
        id,
        ocenka,
        datum,
        zabeleska,
        vnesena_Od,
        dobienaZaUcenikot_Id,
        eZaPredmetot_Id,
        zaAktivnosta_id
    )
VALUES (
        '5ddf06fa-824b-408b-986d-449aa6962964',
        2,
        CURRENT_DATE,
        'Ucenikot postojano se buni za temata',
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        '476e6ca8-347f-4bc9-af79-e4d448754cdf',
        '7f2a229e-1003-4343-a21c-4157bdd25be9'
    );

INSERT INTO
    Ocenka (
        id,
        ocenka,
        datum,
        zabeleska,
        vnesena_Od,
        dobienaZaUcenikot_Id,
        eZaPredmetot_Id,
        zaAktivnosta_id
    )
VALUES (
        'b06e9c9b-4007-4e4c-bd80-2480780d347d',
        2,
        CURRENT_DATE,
        'Krajna ocenka',
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        '476e6ca8-347f-4bc9-af79-e4d448754cdf',
        '7f2a229e-1003-4343-a21c-4157bdd25be9'
    );

INSERT INTO
    Usna_Ocenka (
        id,
        tema,
        osvoeni_poeni,
        max_poeni,
        vid_isprasuvanje
    )
VALUES (
        '414acf3b-0e57-43d0-9aec-c3180523bd1e',
        'Prezentiranje na kniga Igra na Tronovi',
        100,
        100,
        'usno'
    );

INSERT INTO
    Pismena_Ocenka (
        id,
        tema,
        osvoeni_poeni,
        max_poeni,
        vid
    )
VALUES (
        '5ddf06fa-824b-408b-986d-449aa6962964',
        'Test po Francuski jazik 1',
        50,
        100,
        'test'
    );

INSERT INTO
    Krajna_Ocenka (id, tip)
VALUES (
        'b06e9c9b-4007-4e4c-bd80-2480780d347d',
        'polugodisna ocenka'
    );

INSERT INTO
    Soopstenie (
        id,
        naslov,
        sodrzina,
        kreirano_Na,
        zaKlas_Id,
        postiranoOd_Id
    )
VALUES (
        '75cf3e1a-8c63-4748-ac8d-4b717df62a7a',
        'Petok 21.12 neraboten den',
        'Dragi ucenici, ovoj petok, (21.12.2025), nastava nema da se odrzi poradi otsustvo na nastavnikot Ivo.',
        CURRENT_DATE,
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '761eb4c6-689f-4495-ab70-fc10650ccb77'
    );

INSERT INTO
    Nedelen_Plan (
        id,
        datum_Od,
        datum_Do,
        sledenOdKlas_id
    )
VALUES (
        '8d6bd51f-aa61-45aa-a81d-94277075f20d',
        '2025-12-19',
        '2025-12-23',
        '0c9f923d-c4b0-4037-9812-24610bee82a2'
    );

INSERT INTO
    Raspored (
        id,
        naslov,
        tip,
        izgotvenOd_Id
    )
VALUES (
        'b447c295-ef00-4cf9-a584-64f27c2ea462',
        'Privremen raspored za klas 9-A',
        'privremen',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0'
    );

INSERT INTO
    SoopstenieZa_Plakjanje (
        id,
        naslov,
        sodrzina,
        rokZa_Plakjanje,
        odobrenoOd_Id,
        sozdadenoOdBlagajnik_Id
    )
VALUES (
        '8d3fa1eb-f432-4748-b849-a510d94f2b3d',
        'Soopstenie za plakjanje na ednodnevna ekskurzija vo Dubai',
        '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.',
        '2025-12-25',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        '3eddcc80-05ea-40d2-ae5f-80cee9eb250d'
    );

INSERT INTO
    Plakjanje (
        id,
        status,
        tx_hash,
        valuta,
        plateno_Na,
        iznos,
        platenoOdRoditel_Id
    )
VALUES (
        '01650e9f-5afa-48f6-be30-c65eb113ba64',
        'Plateno',
        '0xac219cf731dd4890d09521b07d7781a4b96c62edc0b5b8299bf64ab8ff42ac0a',
        'ETH',
        CURRENT_DATE,
        1.000000000000000000,
        '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f'
    );

INSERT INTO
    KlasSlusa_Predmet (klas_Id, predmet_Id)
VALUES (
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9'
    );

INSERT INTO
    NastavnikGoPredava_Predmetot (nastavnik_Id, predmet_Id)
VALUES (
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
        '476e6ca8-347f-4bc9-af79-e4d448754cdf'
    );

INSERT INTO
    NedelenPlanOpfakja_Aktivnosti (
        nedelenPlan_Id,
        aktivnostZaNedelenPlan_Id
    )
VALUES (
        '8d6bd51f-aa61-45aa-a81d-94277075f20d',
        'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
    );

INSERT INTO
    KlasenRakovoditelZapisuvaAktivnostZaNedelen_Plan (
        klasenRakovoditel_Id,
        aktivnostZaNedelenPlan_Id
    )
VALUES (
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
    );

INSERT INTO
    RasporedSodrzi_Cas (raspored_Id, cas_Id)
VALUES (
        'b447c295-ef00-4cf9-a584-64f27c2ea462',
        '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
    );

INSERT INTO
    PredmetSePredavaNa_Cas (predmet_Id, cas_Id)
VALUES (
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
        '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
    );

INSERT INTO
    KlasenRakovoditelRakovodiSo_Klas (klasenRakovoditel_Id, klas_Id)
VALUES (
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        '0c9f923d-c4b0-4037-9812-24610bee82a2'
    );

INSERT INTO
    KlasKoristi_Raspored (klas_Id, raspored_Id)
VALUES (
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        'b447c295-ef00-4cf9-a584-64f27c2ea462'
    );

INSERT INTO
    SoopstenieZaPlakjanjeVklucuva_Plakjanje (
        soopstenieZaPlakjanje_Id,
        plakjanje_Id
    )
VALUES (
        '8d3fa1eb-f432-4748-b849-a510d94f2b3d',
        '01650e9f-5afa-48f6-be30-c65eb113ba64'
    )