
INSERT INTO Fitnes_Centar (id, ime, tel_br, lokacija)
VALUES 
    (101, 'Fitnes Centar 1', '070123456', 'Skopje, City Center'),
    (102, 'Fitnes Centar 2', '070223456', 'Skopje, Aerodrom'),
    (103, 'Fitnes Centar 3', '070323456', 'Bitola, Main Street'),
    (104, 'Fitnes Centar 4', '070423456', 'Prilep, Center'),
    (105, 'Fitnes Centar 5', '070523456', 'Ohrid, Lakeside'),
    (106, 'Fitnes Centar 6', '070623456', 'Tetovo, West District'),
    (107, 'Fitnes Centar 7', '070723456', 'Veles, City Park'),
    (108, 'Fitnes Centar 8', '070823456', 'Kumanovo, Center'),
    (109, 'Fitnes Centar 9', '070923456', 'Stip, Near Market'),
    (110, 'Fitnes Centar 10', '071023456', 'Skopje, New City');


INSERT INTO Klient (user_id_klient, id_gym, ime, prezime, email, tel_broj)
VALUES 
    (1, 101, 'Marko', 'Petrovski', 'marko.petrovski@example.com', '070111222'),
    (2, 102, 'Ana', 'Jovanovska', 'ana.jovanovska@example.com', '070222333'),
    (3, 103, 'Stefan', 'Trajkovski', 'stefan.trajkovski@example.com', '070333444'),
    (4, 104, 'Elena', 'Miceva', 'elena.miceva@example.com', '070444555'),
    (5, 105, 'Goran', 'Kostovski', 'goran.kostovski@example.com', '070555666'),
    (6, 106, 'Simona', 'Stankovska', 'simona.stankovska@example.com', '070666777'),
    (7, 107, 'Aleksandar', 'Nikolovski', 'aleksandar.nikolovski@example.com', '070777888'),
    (8, 108, 'Ivana', 'Mitrinovska', 'ivana.mitrinovska@example.com', '070888999'),
    (9, 109, 'Kristijan', 'Jovanov', 'kristijan.jovanov@example.com', '070999000'),
    (10, 110, 'Tamara', 'Ristovska', 'tamara.ristovska@example.com', '071000111'),
    (11, 101, 'Nikola', 'Mitev', 'nikola.mitev@example.com', '071111222'),
    (12, 102, 'Jana', 'Stojanovska', 'jana.stojanovska@example.com', '071222333'),
    (13, 103, 'David', 'Georgiev', 'david.georgiev@example.com', '071333444'),
    (14, 104, 'Sara', 'Kitanovska', 'sara.kitanovska@example.com', '071444555'),
    (15, 105, 'Filip', 'Kostov', 'filip.kostov@example.com', '071555666'),
    (16, 106, 'Martina', 'Velkovska', 'martina.velkovska@example.com', '071666777'),
    (17, 107, 'Dimitar', 'Andov', 'dimitar.andov@example.com', '071777888'),
    (18, 108, 'Lina', 'Nikolovska', 'lina.nikolovska@example.com', '071888999'),
    (19, 109, 'Viktor', 'Spasov', 'viktor.spasov@example.com', '071999000'),
    (20, 110, 'Katerina', 'Todorovska', 'katerina.todorovska@example.com', '072000111'),
    (21, 101, 'Hristijan', 'Mitrov', 'hristijan.mitrov@example.com', '072111222'),
    (22, 102, 'Andrej', 'Petreski', 'andrej.petreski@example.com', '072222333'),
    (23, 103, 'Ivana', 'Jovanoska', 'ivana.jovanoska@example.com', '072333444'),
    (24, 104, 'Milan', 'Mladenovski', 'milan.mladenovski@example.com', '072444555'),
    (25, 105, 'Teodora', 'Ilievska', 'teodora.ilievska@example.com', '072555666'),
    (26, 106, 'Bojan', 'Milevski', 'bojan.milevski@example.com', '072666777'),
    (27, 107, 'Kristina', 'Trajanovska', 'kristina.trajanovska@example.com', '072777888'),
    (28, 108, 'Dario', 'Jovanovski', 'dario.jovanovski@example.com', '072888999'),
    (29, 109, 'Natalija', 'Cvetkovska', 'natalija.cvetkovska@example.com', '072999000'),
    (30, 110, 'Petar', 'Nacev', 'petar.nacev@example.com', '073000111');




INSERT INTO Sopstvenik (user_id_sopstvenik, id_gym, ime, prezime, tel_br, email)
VALUES 
    (31, 101, 'Ivan', 'Jovanovski', '070111223', 'ivan.jovanovski@example.com'),
    (32, 102, 'Marija', 'Petrovska', '070222334', 'marija.petrovska@example.com'),
    (33, 103, 'Stefan', 'Nikolovski', '070333445', 'stefan.nikolovski@example.com'),
    (34, 104, 'Ana', 'Kostova', '070444556', 'ana.kostova@example.com'),
    (35, 105, 'Nikola', 'Mitrovski', '070555667', 'nikola.mitrovski@example.com'),
    (36, 106, 'Kristina', 'Trajkovska', '070666778', 'kristina.trajkovska@example.com'),
    (37, 107, 'Filip', 'Georgievski', '070777889', 'filip.georgievski@example.com'),
    (38, 108, 'Tamara', 'Spasovska', '070888990', 'tamara.spasovska@example.com'),
    (39, 109, 'Igor', 'Manevski', '070999001', 'igor.manevski@example.com'),
    (40, 110, 'Jana', 'Stojanova', '071000112', 'jana.stojanova@example.com');


INSERT INTO Fitnes_Instruktor (user_id_instruktor, id_gym, ime, prezime, email, tel_broj)
VALUES 
    (41, 101, 'Marko', 'Jovanovski', 'marko.jovanovski@example.com', '077111222'),
    (42, 102, 'Ana', 'Mitrevska', 'ana.mitrevska@example.com', '077222333'),
    (43, 103, 'Nikola', 'Georgiev', 'nikola.georgiev@example.com', '077333444'),
    (44, 104, 'Kristina', 'Stankovska', 'kristina.stankovska@example.com', '077444555'),
    (45, 105, 'Filip', 'Krstevski', 'filip.krstevski@example.com', '077555666'),
    (46, 106, 'Stefan', 'Petreski', 'stefan.petreski@example.com', '077666777'),
    (47, 107, 'Elena', 'Nikolovska', 'elena.nikolovska@example.com', '077777888'),
    (48, 108, 'Bojan', 'Manevski', 'bojan.manevski@example.com', '077888999'),
    (49, 109, 'Tamara', 'Spasevska', 'tamara.spasevska@example.com', '077999000'),
    (50, 110, 'Igor', 'Andonov', 'igor.andonov@example.com', '078000111');

INSERT INTO Trening (trening_id, tip, user_id_instruktor_trening)
VALUES 
(222, 'Индивидуален', 41),
(223, 'Групен', 42),
(224, 'Индивидуален', 43),
(225, 'Групен', 44),
(226, 'Индивидуален', 45);

INSERT INTO Termin (termin_id, instruktor_id,  trening_id_termin, user_id_klient_termin, pocetok, vremetraenje, datum)
VALUES 
    (1, 41, 222, 1, '08:00:00', 60, '2025-02-05'),
    (2, 42, 223, 2, '09:30:00', 45, '2025-02-06'),
    (3, 43, 224, 3, '11:00:00', 30, '2025-02-07'),
    (4, 44, 225, 4, '17:00:00', 60, '2025-02-08'),
    (5, 45, 226, 5, '18:30:00', 90, '2025-02-09');

INSERT INTO Rezervacija ( rez_id,termin_id,instruktor_id, trening_id_rez , user_id_klient_rez)
VALUES 
    (1,1, 41, 222,1),
    (2,2, 42, 223,2),
    (3,3, 43, 224,3),
    (4,4, 44, 225,4),
    (5,5, 45, 226,5);

INSERT INTO ocenka (trening_id_o, user_id_klient_o, vrednost, komentar)
VALUES
    (222, 1, 5, 'top'),
    (223, 2, 5, 'vrv'),
    (224, 3, 4, 'ekstra'),
    (225, 4, 4, 'bravo'),
    (226, 5, 5, 'za pofalba');


