Логички и физички дизајн - Креирање база податоци (со SQL DDL): insert_tabela_finish.sql

INSERT INTO Korisnici (user_id, username, password)
VALUES (1, 'user1', 'password1'),
       (2, 'user2', 'password2'),
       (3, 'user3', 'password3'),
       (4, 'user4', 'password4'),
       (5, 'user5', 'password5'),
       (6, 'user6', 'password6'),
       (7, 'user7', 'password7'),
       (8, 'user8', 'password8'),
       (9, 'user9', 'password9'),
       (10, 'user10', 'password10'),
       (11, 'user11', 'password11'),
       (12, 'user12', 'password12'),
       (13, 'user13', 'password13'),
       (14, 'user14', 'password14'),
       (15, 'user15', 'password15'),
       (16, 'user16', 'password16'),
       (17, 'user17', 'password17'),
       (18, 'user18', 'password18'),
       (19, 'user19', 'password19'),
       (20, 'user20', 'password20'),
       (21, 'user21', 'password21'),
       (22, 'user22', 'password22'),
       (23, 'user23', 'password23'),
       (24, 'user24', 'password24'),
       (25, 'user25', 'password25'),
       (26, 'user26', 'password26'),
       (27, 'user27', 'password27'),
       (28, 'user28', 'password28'),
       (29, 'user29', 'password29'),
       (30, 'user30', 'password30'),
       (31, 'user31', 'password31'),
       (32, 'user32', 'password32'),
       (33, 'user33', 'password33'),
       (34, 'user34', 'password34'),
       (35, 'user35', 'password35'),
       (36, 'user36', 'password36'),
       (37, 'user37', 'password37'),
       (38, 'user38', 'password38'),
       (39, 'user39', 'password39'),
       (40, 'user40', 'password40'),
       (41, 'user41', 'password41'),
       (42, 'user42', 'password42'),
       (43, 'user43', 'password43'),
       (44, 'user44', 'password44'),
       (45, 'user45', 'password45'),
       (46, 'user46', 'password46'),
       (47, 'user47', 'password47'),
       (48, 'user48', 'password48'),
       (49, 'user49', 'password49'),
       (50, 'user50', 'password50');
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_br)
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, email, tel_br)
VALUES 
    (31, 101, 'Ivan', 'Jovanovski', 'ivan.jovanovski@example.com', '070111223'),
    (32, 102, 'Marija', 'Petrovska', 'marija.petrovska@example.com', '070222334'),
    (33, 103, 'Stefan', 'Nikolovski', 'stefan.nikolovski@example.com', '070333445'),
    (34, 104, 'Ana', 'Kostova', 'ana.kostova@example.com', '070444556'),
    (35, 105, 'Nikola', 'Mitrovski', 'nikola.mitrovski@example.com', '070555667'),
    (36, 106, 'Kristina', 'Trajkovska', 'kristina.trajkovska@example.com', '070666778'),
    (37, 107, 'Filip', 'Georgievski', 'filip.georgievski@example.com', '070777889'),
    (38, 108, 'Tamara', 'Spasovska', 'tamara.spasovska@example.com', '070888990'),
    (39, 109, 'Igor', 'Manevski', 'igor.manevski@example.com', '070999001');


INSERT INTO Fitnes_Instruktor (user_id_instruktor, id_gym, ime, prezime, kratka_bio, rab_iskustvo, email, tel_br)
VALUES 
    (41, 101, 'Marko', 'Jovanovski', 'Certified personal trainer with 5 years of experience', 5, 'marko.jovanovski@example.com', '077111222'),
    (42, 102, 'Ana', 'Mitrevska', 'Expert in strength training and nutrition coaching', 6, 'ana.mitrevska@example.com', '077222333'),
    (43, 103, 'Nikola', 'Georgiev', 'Specialist in functional fitness and mobility', 4, 'nikola.georgiev@example.com', '077333444'),
    (44, 104, 'Kristina', 'Stankovska', 'Yoga and pilates instructor with a passion for wellness', 7, 'kristina.stankovska@example.com', '077444555'),
    (45, 105, 'Filip', 'Krstevski', 'Strength and conditioning coach for athletes', 5, 'filip.krstevski@example.com', '077555666'),
    (46, 106, 'Stefan', 'Petreski', 'Group fitness expert specializing in HIIT', 3, 'stefan.petreski@example.com', '077666777'),
    (47, 107, 'Elena', 'Nikolovska', 'Certified personal trainer with a focus on weight loss', 6, 'elena.nikolovska@example.com', '077777888'),
    (48, 108, 'Bojan', 'Manevski', 'Former athlete turned fitness coach', 8, 'bojan.manevski@example.com', '077888999'),
    (49, 109, 'Tamara', 'Spasevska', 'Aerobics and dance fitness specialist', 4, 'tamara.spasevska@example.com', '077999000'),
    (50, 110, 'Igor', 'Andonov', 'Bodybuilding coach with extensive competition experience', 10, '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, pocetok, vremetraenje, datum)
VALUES 
    (1, 41, 222, '08:00:00', 60, '2025-02-05'),
    (2, 42, 223, '09:30:00', 45, '2025-02-06'),
    (3, 43, 224, '11:00:00', 30, '2025-02-07'),
    (4, 44, 225, '17:00:00', 60, '2025-02-08'),
    (5, 45, 226, '18:30:00', 90, '2025-02-09');




INSERT INTO Rezervacija (rez_id, user_id_klient_rez, termin_id)
VALUES 
    (1,1,1),
    (2,2,2),
    (3,3,3),
    (4,4,4),
    (5,5,5);

INSERT into ocenka (ocenka_id, rez_id, vrednost, komentar)
VALUES
    (1, 1, 5, 'top'),
    (2, 2, 5, 'vrv'),
    (3, 3, 5, 'ekstra'),
    (4, 4, 4, 'bravo'),
    (5, 5, 5, 'za pofalba');