RelationalDesign2: polnenje_4.sql

delete from "project".customer;

delete from "project".package;

delete from "project"."policy";

delete from "project".pol_dog;

delete from "project".auto_pol;

delete from "project".travel_pol;

delete from "project".pol_osi;

delete from "project".vehicle;

delete from "project".covers;

delete from "project".payment;

delete from "project".property_pol;

delete from "project".property;

-- type = 1 administrator, type=2 customer
insert into project.customer ( name, email, "password", "type") values
('AdminUser', 'admin@newdomain.com', 'adminpass123', true),
('John Doe', 'john.doe@example.com', 'password1234', false),
('Jane Smith', 'jane.smith@example.com', 'mypassword5678', false);

insert into project.package (code, title, total, valuet,type_pol) values
(1, 'Premium Package', 20000, 'USD',1),
(2, 'Basic Package', 10000, 'USD',1),
(3, 'Elite Package', 30000, 'USD',1),
(4, 'Property', 1500,'usd',2)

insert into project."policy" ( sdate, edate, package) values
( '2023-11-01', '2024-11-01', 1),
( '2023-10-15', '2023-11-15', 2),
( '2023-12-01', '2024-01-01', 3),
( '2023-12-16', '2024-01-15', 4)


insert into project.pol_dog (d_embg, "name", "policy", surname, birthdate, kontakt) values
(290700001,'John', 1, 'Doe', '1990-05-15', '072345678'),
(290700002, 'Jane', 2, 'Smith', '1985-08-25', '073456789'),
(290700003,  'John', 3, 'Doe', '1990-05-15', '072345678');

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

insert into project.vehicle ("policy", "type", marka, model, license_plate) values
( 1, 'car', 'Audi', 'A3', 'SK1234AB'),
( 2, 'bus', 'Mercedes', 'Sprinter', 'SK5678CD');

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

insert into project.pol_osi (o_embg, "policy", "name", surname, birthdate, kontakt) values
(290700002, 1, 'Jane', 'Smith', '1985-08-25', '073456789');


insert into project.covers (cov_id, cov_amount, package, "cov_type") values
(1, 2000, 1, 'Medical Expenses Cover, Trip Cancellation/Interruption Due to Illness'),
(2, 3000, 2, 'Ambulance Services, Medical Expenses Cover, Trip Cancellation/Interruption Due to Illness'),
(3, 4000, 3, 'Personal Accident Insurance, Ambulance Services, Medical Expenses Cover, Trip Cancellation/Interruption Due to Illness'),
(4, 10000, 4, 'Earthquake, Storm, Wind, Flood')


insert into project.payment (payment_num, "policy", p_date, p_amount,visa_number) values
(1, 1, '2024-05-15', 22000,'1234123412341234'),
(2, 2, '2024-06-01', 18000,'2456657488912234'),
(3, 3, '2024-07-10', 25000,'7788912344159011');

insert into project.property_pol (pr_id, pol_id) values
(1, 3),
(2, 4);


insert into project.property ( "policy", "address", floor, year_build, security) values
(2, 'Skopje, Center, Blvd', 3, 2015, true)