RelationalDesign: polnenje.sql

set search_path = "project";


delete from "project".customer;

delete from "project".package;
delete from "project"."policy";
delete from "project".pol_dog;
delete from "project".pol_auto;
delete from "project".pol_travel;
delete from "project".pol_osi;
delete from "project".vehicle;


-- type = 1 administrator, type=2 customer
insert into project.customer  (c_id, name,email,"password","type") values
(1,'Administrator', 'a@trustshield.com', 'aa321','0'),
(2,'Ardit', 'ardit@gmail.com', 'aaa2456','1'),
(3,'Dragana', 'dragana@hotmail.com', 'sss8989','1');



insert into project.package  (code, title, covers, total, valuet) values 
(1, 'Package Gold', 'Hospital', 15000, 'Den'),
(2, 'Package Gold1', 'Zdravstveno', 18000, 'Den'),
(3, 'Package Gold2', '100%', 25000, 'Den');


insert into project."policy" (p_id,sdate,edate,package) values 
(1, '20231221','20241220',1),
(2, '20231212','20231220',2),
(3, '20231205','20231210',3);



insert into project.pol_dog (d_embg,c_id,"name","policy",surname,birthdate,kontakt) values
(290699945,2,'Ardit',1,'Ameti','19990629','070926854'),
(290699900,3,'Dragana',2,'Stojanovic','20000105','070852654'),
(290699942,2,'Ardit',3,'Ameti','19990629','070926854');


insert into project.pol_auto  (a_id,pol_id) values 
(1,1),
(2,3);


insert into project.pol_travel  (tr_id, pol_id) values 
(1,2);


insert into project.pol_osi (o_embg ,"policy","name",surname,birthdate,kontakt) values 
(290699900,1,'Dragana','Stojanovic','20000105','070852654');

insert into project.vehicle (v_id,"policy","type",marka,model,license_plate) values 
(1,1,'avto','BMW','x1','sk0869bc'),
(2,2,'bus','volvo','tmpx2','sk7469ap');