

insert into administrator (id_user,authorized_from, authorized_till) values (1,'2022-01-01','2024-01-01'),(2,'2022-01-01','2025-01-01'),(3,'2022-01-01','2026-01-01');

insert into client (id_user) values (13),(4),(5),(6);

insert into delivery_man (id_user,employed_from) values (7,now()),(8,now()),(9,now());

insert into warehouse (warehouse_location) values ('Radishani'),('Kozle'),('Vizbegovo');

insert into warehouseman (id_user,employed_from,id_warehouse) values (10,now(),1),(11,now(),2),(12,now(),3);

insert into part_manufacturer (pm_name,pm_location) values
('Bosch','Germany'),
('Continental','Belgium'),
('Mahle','Netherlands');

insert into car_manufacturer (cm_name,cm_country) values
('Volkswagen','Germany'),
('Fiat','Italy'),
('Ford','USA'),
('Toyota','Japan'),
('Hyndai','Korea');

insert into repair_shop (rs_name,rs_location,rs_phone_number) values
('Toyota Service','Partizanska','070 123 456'),
('Volkswagen Service','Ilinenska','075 876 543'),
('Fiat Service','Vodnjanska','078 555 666'),
('Hyndai Service','Boris Trajkovski','075 500 000');

insert into car(in_production_since,in_production_till,car_type,id_car_manufacturer) values
(2001,2004,'Golf 4',1),
(2006,2009,'Punto',2),
(2004,2006,'Golf 5',1),
(2000,2008,'Fiesta',3),
(1995,2005,'Coupe',5);

insert into car_sample(vin,year_of_production, engine_power, displacement, fuel_type, km_driven, ID_user, ID_car) values
(1111,2008,65,1200,'Diesel',120000,4,4),
(2222,2010,80,1400,'Diesel',150000,5,4),
(3333,2016,65,1200,'Petrol/Gas',65000,6,2),
(4444,1997,140,2000,'Petrol/Gas',185000,13,5);

insert into part(part_name, id_part_manufacturer) values
('Engine G4GF',1),
('Wheel 20CM',2),
('Shift 6GEARS',3),
('Radio WITH AUX',1),
('Rear Bumper FOR VW GOLF 4',2),
('Headlight FOR PUNTO',3);

insert into category(category_name) values ('Brakes'),('Cooling System'),('Electrical'),('Engine components'),('Exterior'),('Filters');

insert into order_table(order_status,order_date,id_user) values 
('created',now(),4),
('created',now(),5),
('created',now(),6),
('created',now(),13);

insert into service_book (vin) values (1111),(2222),(3333),(4444);

insert into delivery (delivery_status, delivery_address,id_user,id_order) values 
('in progress','Aerodrom',7,3),
('finished','Pintija',8,1),
('in progress','Kisela Voda',9,2),
('in progress','Kozle',8,4);

insert into price (amount, price_from, id_part) values 
(1000,now(),2),
(2000,now(),3),
(3000,now(),1),
(1500,now(),4),
(3500,now(),5),
(300,now(),6);

insert into repair (vin, id_repair_shop, id_service_book) values (1111,3,1),(2222,2,2),(3333,1,3),(4444, 2, 4);

insert into review (review_rating, id_repair, id_user) values (10, 1, 4), (6, 2, 5), (8, 3, 6), (9, 4, 13);

insert into part_is_from_category (id_part, id_category) values (5,5), (1,4), (6,5);

insert into repair_shop_is_authorized_for_car_make (id_repair_shop, id_car_manufacturer) values (1,4),(2,1),(3,2),(4,5);

insert into order_contains_part (id_order, id_part, quantity_order) values (1,3,1),(2,4,2),(3,1,2),(4,6,1);

insert into part_is_in_stock_in_warehouse (id_part,id_warehouse,quantity_warehouse) values (1,2,100), (2,1,150), (3,1,50), (4,3,75),(5,1,30),(6,2,70);

insert into part_is_appropriate_for_car (id_part, id_car) values (1,1),(1,2),(1,3),(2,1),(2,4),(2,5),(5,1),(4,1),(4,2),(4,3),(4,4),(4,5),(3,5),(6,2);