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
    AktivnostZa_NedelenPlan (
        id,
        naslov,
        opis,
        denVo_Nedelata,
        active
    )
VALUES (
        'b2210c06-f85c-4cf9-9de6-72ce6728d6af',
        'Makedonski jazik',
        'Raskazuvanje',
        'Sreda',
        true
    );
	INSERT INTO AktivnostZa_NedelenPlan(
	id, naslov, opis, denVo_Nedelata) 
	VALUES(
	'f2c231d2-945a-4cb4-9269-8c92793f5572',
	'Francuski jazik',
	'Obrabotka na zborovite vo treto lice',
	'Ponedelnik'
	
	),
	(
	'b81265f3-14f1-41c8-9952-eaf4ce7acaac',
	'Informatika 1',
	'C++ vezbi 1',
	'Sreda'
	
	);


INSERT INTO
    Predmet (
        id,
        ime,
        fond_casovi,
        zaKlas_Id,
        active
    )
VALUES (
        '31d3cbd5-d598-4f60-9cae-f4786bb13ce9',
        'Makedonski jazik',
        30,
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        true
    ),
    (
        '476e6ca8-347f-4bc9-af79-e4d448754cdf',
        'Francuski jazik',
        20,
        '0c9f923d-c4b0-4037-9812-24610bee82a2',
        true
    ),
	(
		'820b1f2d-861d-4bed-a416-3e5e3e60d9dd',
		'Informatika',
		30,
		'0c9f923d-c4b0-4037-9812-24610bee82a2',
		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'
       
    );

INSERT INTO
    Ocenka (
        id,
        ocenka,
        datum,
        zabeleska,
        vnesena_Od,
        dobienaZaUcenikot_Id,
        eZaPredmetot_Id,
        zaAktivnosta_id
    )
VALUES (
        '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'
    );

INSERT INTO
    Ocenka (
        id,
        ocenka,
        datum,
        zabeleska,
        vnesena_Od,
        dobienaZaUcenikot_Id,
        eZaPredmetot_Id,
        zaAktivnosta_id
    )
VALUES (
        '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,
        rokZa_Plakjanje,
        odobrenoOd_Id,
        sozdadenoOdBlagajnik_Id,
        active
    )
VALUES (
        '8d3fa1eb-f432-4748-b849-a510d94f2b3d',
        'Ekskurzija',
        'Potrebno e da se plati 1 ETH.',
        '2025-12-25',
        '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',
        'Plateno',
        '0xac219cf731dd4890d09521b07d7781a4b96c62edc0b5b8299bf64ab8ff42ac0a',
        'ETH',
        CURRENT_DATE,
        1.000000000000000000,
        '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'
    );

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 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'
    );