RelationalDesign: polnenje_v2.sql

set search_path = project;

delete from Korisnik;
delete from Potrosuvac;
delete from Vozac;
delete from Administrator;
delete from Manager;
delete from Naracka;
delete from Naplata;
delete from Vozilo;
delete from Restoran;
delete from MenuItem;

insert into Korisnik(Email, username, Pword) values
('luka.cheshlarov@finki.com', 'Lukamaster', 'luka1234'),
('stefan@finki.com', 'Stefan', 'stefan1234'),
('user1@finki.com', 'user1', 'password1'),
('vasil@finki.com', 'vase', 'p@ssw0rd123$');

insert into Potrosuvac(korisnik_id, Address, br_telefon) values
(1, 'Ul. Prashka Br 32a', '070321643'),
(2, 'Ul. Atinska Br 25', '071295425'),
(7, 'Ul. Jane Sandanski Br 41', '078822733'),
(12, 'Ul. Anton Popov Br 16b', '077884323');

insert into Vozac(korisnik_id, vozilo_id) values
(12, 2),
(8, 1),
(6, 3),
(5, 4);

insert into Administrator(korisnik_id) values
(23),
(12),
(10),
(15);

insert into Manager(korisnik_id) values
(23),
(12),
(10),
(15);

insert into .Naracka(Datum, potrosuvac_id, restoran_id, vozac_id, admin_id) values
(11/1/2024, 10, 1, 10, 1),
(12/1/2024, 11, 3, 15, 3),
(13/1/2024, 12, 2, 12, 2),
(14/1/2024, 15, 4, 15, 4);

insert into Naplata(Iznos, nacin_na_plakjane, potrosuvac_id, naracka_id) values
('500MKD', 'Credit Card', 12, 5),
('240MKD', 'Credit Card', 15, 20),
('330MKD', 'Credit Card', 18, 23),
('480MKD', 'Credit Card', 20, 30);

insert into Vozilo(tip, br_registracija) values
('VW Golf', 'SK3526AU'),
('Skoda Fabia', 'KU4210AZ'),
('Mitsubishi Space Star', 'SK2403BL'),
('Opel Corsa', 'SK4400BW');

insert into Restoran(ime, lokacija, rabotno_vreme, manager_id) values
('McDonalds', 'Bul. Partizanski Odredi Br.22A', '09:00-23:00', 54),
('Marakana', 'Ulica 1732 bb', '09:00-22:00', 22),
('Meze Bar', 'Bul. Kuznam Josifovski Pitu bb', '09:00-21:00', 14),
('Royal Burger', 'Vidoe Smilevski Bato 55', '09:00-01:00', 17);

insert into MenuItem(ime, cena, restoran_id) values
('Cheeseburger', '120MKD', 1),
('Coca-Cola', '40MKD', 2),
('Rebra', '200MKD', 4),
('Chicken Nuggets', '100MKD', 8);