Логички и физички дизајн - Креирање база податоци (со SQL DDL): popolnuvanje_tabeli.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_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');