RelationalDesign2: polnenje_1.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 (c_id, name, email, "password", "type") values
(1, 'AdminUser', 'admin@newdomain.com', 'adminpass123', 0),
(2, 'John Doe', 'john.doe@example.com', 'password1234', 1),
(3, 'Jane Smith', 'jane.smith@example.com', 'mypassword5678', 1);

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

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

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

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

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.vehicle (v_id, "policy", "type", marka, model, license_plate) values
(1, 1, 'car', 'Audi', 'A3', 'SK1234AB'),
(2, 2, 'bus', 'Mercedes', 'Sprinter', 'SK5678CD');

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) values
(1, 1, '2024-05-15', 22000),
(2, 2, '2024-06-01', 18000),
(3, 3, '2024-07-10', 25000);

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


insert into project.property (prop_id, "policy", "address", floor, year_build, security) values
(1, 2, 'Skopje, Center, Blvd', 3, '2015-03-12', 1)