RelationalDesign: Polnenje.sql

insert into project.Korisnik(ime_prezime, password_korisnik)
values ('Hristijan Mitic','hrismiti' ),
('Kristijan Markovski','kikokiko' ),
('Trajko Mladenovski','ldldld123' );

insert into project.Korisnik(ime_prezime, password_korisnik)
values ('Primer proba','kafsgfa' ),
('Ako Lil','ksfsafko' ),
('Kako Kikikj','ldsd123' );

insert into project.Korisnik(ime_prezime, password_korisnik)
values ('Andrej Probovski','aaa123' ),
('Kiki Liki','223sfa' ),
('Roko Leni','ukikj123' );

insert into project.Korisnik(ime_prezime, password_korisnik)
values ('Andrej Andrejkovski','ako222' ),
('Miki Riki','miki234' ),
('Oko Nos','okno123' );

insert into project.Korisnik(ime_prezime, password_korisnik)
values ('Bojan Bozinovski','boki3421' ),
('Oki Koki','oki2341' ),
('Vale Kale','vaka456' );

insert into project.Kupuvac(id_korisnik,mail) values
(1, 'proba@gmail.com'),
(3, 'trajko@gmail.com'),
(4,'primer@yahoo.com'),
(10, 'andrejandrejkovski@yahoo.com');

insert into project.admin_korisnik(id_korisnik)values (6),(11),(12);

insert into project.dostavuvac(id_korisnik) values (2),(5),(13);

insert into project.magacioner(id_korisnik, id_magacin) values (7,1),(9,2),(14,3);

insert into project.telefonskibroj(id_korisnik, telefonski_broj) values
(1,'078 500 000'),
(3,'070 222 305'),
(4,'077 777 777'),
(10,'072 335 302');

insert into project.naracka(vkupno_suma,datum, status, adresa,id_korisnik) values
(2000, now()- interval '2days','za dostava','Goce delcev br 32',1),
(1500,now()- interval '2years','zavrsena', 'Jane Sandanski br 5',3),
(1000, now()- interval '1day','za dostava','Ilindenska br 1', 4),
(1200, now()- interval '1hour','se sprema','Ilindenska br 43', 10);


insert into project.dostava (id_korisnik, id_naracka, datum, status) values
(2,1,now()-interval '2days','za dostava'),
(5,3,now()- interval '5hours','za dostava'),
(2,2,now() - interval '2years','dostavena');


insert into project.magacin (lokacija) values
('Aerodrom'),
('Karpos'),
('Kale');


insert into project.kategorija(ime) values
('Suvomesnati proizvodi'),
('Zelencuk'),
('Testenini');

insert into project.produkt(ime, opis , id_korisnik) values
('Spageti', 'Spageti 15cm', 6),
('Domati','',6),
('Slanina', 'Slanina',6),
('Kulen', 'Kulen',11),
('Krastavica', 'Krastavica',12);

insert into project.cena(id_produkt, cena_od, cena_do, iznos)values
(1,now()- interval '2days',null,100),
(2,now()- interval '1year',now()+ interval '2months',70),
(3,now() - interval '2months',null,125),
(4,now() - interval '1month',null,150),
(5,now() - interval '2days',now() + interval '2days',45);


insert into project.naracka_sodrzi_produkt (id_produkt, id_naracka , kolicina, cena) values
(1,3,10,1000),
(2,3,25,1900),
(3,2,12,1500),
(4,1,13,2000),
(5,4,30,1200);

insert into project.produkt_e_od_kategorija (id_produkt, id_kategorija) values
(1,3),
(2,2),
(3,1),
(4,1),
(5,2);

insert into project.produkt_e_vo_magacin (id_produkt, id_magacin, kolicina) values 
(1,2,10),
(2,1,5),
(3,2,7),
(3,3,10),
(1,1,7),
(4,2,1),
(5,1,15),
(5,2,10);