INSERT INTO
    Admin_User (
        id,
        e_posta,
        lozinka,
        ime,
        prezime,
        active
    )
VALUES (
        'ab4793e3-ae36-4ad0-a1bd-2dbef91e0067',
        'admin@admin.com',
        '$2b$14$w.cdYrNuTVMLQR5dggpgO.8KrjNvTr29o2n9aJmzUSvIq3hTN7nou',
        'Admin',
        'Adminovski',
        true
    ),
    (
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        'vasil@admin.com',
        '$2b$14$7htdVrnMwtY05hoZFJSdaemWkCCP2cnNhu3eZ1GMHWwQiaom1O7/i',
        'Vasil',
        'Finkovski',
        true
    );

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
    Korisnik (
        id,
        e_posta,
        lozinka,
        ime,
        prezime,
        pol,
        adresa,
        kreiranOd_Id,
        active
    )
VALUES (
        '3e26f4d3-0ecd-4810-bc47-3b531b154a30',
        'nikola@user.com',
        '$2b$14$B6JlbUEuyt0TbGS3rRtZleYumI7TWg6pOcHICLm6HAKGBzlC.Vr2O',
        'Nikola',
        'Janev',
        'Masko',
        'Skopje',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        true
    ),
    (
        '266a48c7-56cb-42d9-baa5-becbef00fd4c',
        'petar@user.com',
        '$2b$14$gFAe804W5/3kNq6spMGltOFCmvoqLHJYe5FJ8.nOzOq499bwGChaW',
        'Petar',
        'Veljanov',
        'Masko',
        'Skopje',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        true
    ),
    (
        'a4dee448-48e5-441f-a18f-b08f0825035f',
        'ivan@user.com',
        '$2b$14$5.x1eFPI9w6zYAFlIh2oauPh0GZNewV8N4SiIIvHd6mgS4u9DivMO',
        'Ivan',
        'Gjorevski',
        'Masko',
        'Skopje',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        true
    ),
    (
        '761eb4c6-689f-4495-ab70-fc10650ccb77',
        'marija@user.com',
        '$2a$14$YLico7eJVBrsXmaI7VKkueK0.fOgawmIDpwomyEch028OXIZSnkOa',
        'Marija',
        'Teonova',
        'Zensko',
        'Skopje',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        true
    ),
    (
        '4dac75d0-fdea-4cb2-93f6-b2bb6b176c19',
        'teon@user.com',
        '$2b$14$PJ7CpIs1BwQOElp1lUfy1eaOpYAVD43ti5MI2XP53X30QFbJhtdYS',
        'Teon',
        'Kirov',
        'Masko',
        'Strumica',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        true
    ),
    (
        '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
    ),
    (
        '9c8a9a5c-d96f-47a6-9611-d6ad4233fa4f',
        'roze@user.com',
        '$2b$14$PoUtM6OEX0LsFqV70de2VONL.aHlZO5ieFDts0r27Rw7E5fPM10N2',
        'Roze',
        'Zaneva',
        'Zensko',
        'Kumanovo',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        true
    ),
    (
        '18d82d24-9d9f-4c0b-9692-f7a87174cb4c',
        'aegon@user.com',
        '$2b$14$ZHwFP.imOTgHe6koSFL1k.M7UYEnJ23GEAM2IIiT0sPTlZgIorkxO',
        'Aegon',
        'Targeryen',
        'Masko',
        'Dragonstone',
        'a1dfd590-5875-4f29-88cd-62cc8f5904e0',
        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
    );