

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

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

INSERT INTO
    Nastavnik (id, active)
VALUES (
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        true
    ),
    (
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
        true
    );

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

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

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

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

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

INSERT INTO
    Klas (
        id,
        godinaNa_Slusanje,
        paralelka,
        oddelenie,
        koristiRasporedId,
        klasen_rakovoditel_id,
        active
    )
VALUES (
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '2019/2020',
        'A',
        9,
        'b447c295-ef00-4cf9-a584-64f27c2ea462',
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        true
    );

INSERT INTO
    Ucenik (
        id,
        mestoNa_ragjanje,
        mobilen_telefon,
        datumNa_ragjanje,
        staratel_id,
        uciVoKlas_id,
        active
    )
VALUES (
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        'Westeros',
        '072234235',
        '2000-01-02',
        '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        true
    );

INSERT INTO
    Predmet (id, ime, fond_casovi, active)
VALUES (
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
        'Makedonski jazik',
        30,
        true
    ),
    (
        '476e6ca8-347f-4bc9-af79-e4d448754cdf',
        'Francuski jazik',
        20,
        true
    ),
    (
        '820b1f2d-861d-4bed-a416-3e5e3e60d9dd',
        'Informatika',
        30,
        true
    );

INSERT INTO
    AktivnostZa_NedelenPlan (
        id,
        naslov,
        opis,
        denVo_Nedelata,
        predmet_id,
        active
    )
VALUES (
        'b2210c06-f85c-4cf9-9de6-72ce6728d6af',
        'Makedonski jazik',
        'Raskazuvanje',
        'Sreda',
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
        true
    ),
    (
        'f2c231d2-945a-4cb4-9269-8c92793f5572',
        'Francuski jazik',
        'Obrabotka na zborovite vo treto lice',
        'Ponedelnik',
        '476e6ca8-347f-4bc9-af79-e4d448754cdf',
        true
    ),
    (
        'b81265f3-14f1-41c8-9952-eaf4ce7acaac',
        'Informatika 1',
        'C++ vezbi 1',
        'Sreda',
        '820b1f2d-861d-4bed-a416-3e5e3e60d9dd',
        true
    );

INSERT INTO
    Cas (
        id,
        ime,
        reden_cas,
        predmet_Id,
        active,
        denVo_Nedelata
    )
VALUES (
        '40e03e88-bdc7-4c51-9710-c739fd8ed78e',
        'Makedonski jazik',
        4,
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
        true,
        'Vtornik'
    );

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

INSERT INTO
    Ocenka (
        id,
        ocenka,
        datum,
        zabeleska,
        vnesena_Od,
        dobienaZaUcenikot_Id,
        eZaPredmetot_Id,
        zaAktivnosta_id
    )
VALUES (
        '414acf3b-0e57-43d0-9aec-c3180523bd1e',
        5,
        CURRENT_DATE,
        'Odlicno',
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
        'b2210c06-f85c-4cf9-9de6-72ce6728d6af'
    ),
    (
        'bb78a56c-c2dc-4d15-adcf-7bf74290b74d',
        4,
        CURRENT_DATE,
        'Mali sintaksicki greski',
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        '476e6ca8-347f-4bc9-af79-e4d448754cdf',
        'f2c231d2-945a-4cb4-9269-8c92793f5572'
    ),
    (
        '22094917-c5df-4b7c-9c29-182db855f4a2',
        4,
        CURRENT_DATE,
        'Krajna Usna ocenka za predmetot Informatika',
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        '820b1f2d-861d-4bed-a416-3e5e3e60d9dd',
        NULL
    );

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

INSERT INTO
    Pismena_Ocenka (
        id,
        tema,
        osvoeni_poeni,
        max_poeni,
        vid
    )
VALUES (
        'bb78a56c-c2dc-4d15-adcf-7bf74290b74d',
        'Pismena rabota za romanot GOT',
        80,
        100,
        'PISMENA_RABOTA'
    );

INSERT INTO
    Krajna_Ocenka (id, tip)
VALUES (
        '22094917-c5df-4b7c-9c29-182db855f4a2',
        'PISMENA_OCENKA'
    );

INSERT INTO
    SoopstenieZa_Plakjanje (
        id,
        naslov,
        sodrzina,
        iznos,
        valuta,
        rokZa_Plakjanje,
        status,
        obrabotenoOd_Id,
        sozdadenoOdBlagajnik_Id,
        active
    )
VALUES (
        '8d3fa1eb-f432-4748-b849-a510d94f2b3d',
        'Ekskurzija',
        'Potrebno e da se plati 1 ETH.',
        0.0000000000010000000,
        'ETH',
        '2025-12-25',
        'APPROVED',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        '3eddcc80-05ea-40d2-ae5f-80cee9eb250d',
        true
    );

INSERT INTO
    Plakjanje (
        id,
        status,
        tx_hash,
        valuta,
        plateno_Na,
        iznos,
        platenoOdRoditel_Id,
        soopstenie_za_plakjanje_id
    )
VALUES (
        '01650e9f-5afa-48f6-be30-c65eb113ba64',
        'ZAVRSENO',
        '0xac219cf731dd4890d09521b07d7781a4b96c62edc0b5b8299bf64ab8ff42ac0a',
        'ETH',
        CURRENT_TIMESTAMP,
        0.0000000000010000000,
        '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
        '8d3fa1eb-f432-4748-b849-a510d94f2b3d'
    );

INSERT INTO
    KlasSlusa_Predmet (klas_Id, predmet_Id)
VALUES (
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9'
    ),
    (
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '476e6ca8-347f-4bc9-af79-e4d448754cdf'
    ),
    (
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '820b1f2d-861d-4bed-a416-3e5e3e60d9dd'
    );

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
    NastavnikZapisuvaAktivnostZaNedelen_Plan (
        nastavnik_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
    Prisustvo (
        id,
        datum,
        status,
        zabeleska,
        evidentiranoOd_Id,
        seOdnesuvaNaUcenikot_Id,
        zaCasot_Id
    )
VALUES (
        '6a4e5101-1f4b-4a83-be8d-863279e44e8c',
        '2026-02-14',
        'PRISUTEN',
        'Ucenikot bese prisuten na casot po makedonski jazik',
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        '40e03e88-bdc7-4c51-9710-c739fd8ed78e'
    );

INSERT INTO
    Soopstenie (
        id,
        naslov,
        sodrzina,
        kreirano_Na,
        zaKlas_Id,
        postiranoOd_Id,
        active
    )
VALUES (
        'd2f4e8c1-8d4a-4d75-b1d5-5f91a4d6c123',
        'Roditelska sredba',
        'Roditelska sredba ke se odrzi na 20.12.2025 vo 18:00 casot vo ucilnicata na klasot.',
        '2025-12-15',
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        true
    );