RelationalDesign: polnenje_v1.sql

truncate table user_table restart identity cascade;
truncate table administrator restart identity cascade;
truncate table delivery_man restart identity cascade;
truncate table service_man restart identity cascade;
truncate table customer restart identity cascade;
truncate table warehouseman restart identity cascade;
truncate table warehouse restart identity cascade;
truncate table vehicle restart identity cascade;
truncate table delivery restart identity cascade;
truncate table review restart identity cascade;
truncate table order_table restart identity cascade;
truncate table manufacturer restart identity cascade;
truncate table category restart identity cascade;
truncate table subcategory restart identity cascade;
truncate table product restart identity cascade;
truncate table order_table_contains_product restart identity cascade;
truncate table product_is_in_category restart identity cascade;
truncate table product_is_in_stock_in_warehouse restart identity cascade;
truncate table vehicle_is_used_for_delivery restart identity cascade;



insert into user_table (username,name_user,email,"password" ,phone_number) values
('john_doe_85', 'John Doe', 'john.doe@gmail.com', 'pass123', '123-456-7890'),
('jane_smith_92', 'Jane Smith', 'jane.smith@gmail.com', 'securepass', '987-654-3210'),
('alice_j_78', 'Alice Johnson', 'alice.j@gmail.com', 'alicepass123', '555-123-4567'),
('bob_m_89', 'Bob Miller', 'bob.m@gmail.com', 'mypass123', '789-123-4560'),
('eva_d_93', 'Eva Davis', 'eva.d@gmail.com', 'evapass', '345-678-9012'),
('chris_wilson_87', 'Chris Wilson', 'chris.w@gmail.com', 'wilsonpass', '567-890-1234'),
('sophie_brown_90', 'Sophie Brown', 'sophie.b@gmail.com', 'sophiepass', '123-987-6543'),
('daniel_white_88', 'Daniel White', 'daniel.w@gmail.com', 'danielpass', '890-234-5678'),
('emily_taylor_91', 'Emily Taylor', 'emily.t@gmail.com', 'emilypass', '432-109-8765'),
('michael_j_94', 'Michael Johnson', 'michael.j@gmail.com', 'mikepass', '876-543-2109'),
('olivia_clark_89', 'Olivia Clark', 'olivia.c@gmail.com', 'oliviapass', '321-654-0987'),
('matthew_h_92', 'Matthew Harris', 'matthew.h@gmail.com', 'mattpass', '654-987-0123'),
('laura_adams_86', 'Laura Adams', 'laura.a@gmail.com', 'laurapass', '789-234-5670'),
('kevin_jones_95', 'Kevin Jones', 'kevin.j@gmail.com', 'kevinpass', '234-567-8901'),
('megan_w_91', 'Megan Walker', 'megan.w@gmail.com', 'meganpass', '456-789-0123');

insert into administrator (user_id) values
(1), (2), (3);

insert into delivery_man (user_id) values
(4), (5), (6);

insert into customer (user_id) values
(7), (8), (9);

insert into service_man (user_id) values
(10), (11), (12);

insert into warehouse (warehouse_location) values
('123 Industrial Street, Skopje 1000, Macedonia'),
('456 Commerce Avenue, Ohrid 6000, Macedonia'),
('789 Summit Road, Bitola 7000, Macedonia');

insert into warehouseman (user_id, warehouse_id) values
(13,1),
(14,2),
(15,3);

insert into vehicle (vehicle_model, vehicle_service, delivery_man_id) values
('Ford Transit','01/01/2023',4),
('Mercedes-Benz Sprinter','01/03/2023',5),
('Chevrolet Express','01/06/2023',6);

insert into order_table (order_status, order_date, customer_id) values
('Processing', '01/29/2024', 7),
('Shipped', '01/28/2024', 8),
('Delivered', '01/27/2024', 9);

insert into delivery (delivery_status, delivery_address, delivery_man_id, order_id) values
('Pending', '123 Main Street, Cityville', 4, 1),
('Shipped', '456 Park Avenue, Townsville', 5, 2),
('Delivered', '789 Oak Lane, Villageton', 6, 3);

insert into category (category_name) values
('Processor'),
('Graphics Card'),
('Storage Drive');

insert into subcategory (subcategory_name, category_id) values
('Intel Core', 1),
('NVIDIA GeForce', 2),
('Samsung SSD', 3);

insert into manufacturer (manufacturer_name) values
('Intel'),
('NVIDIA'),
('Samsung');

insert into product (product_name, product_description, product_price, product_warranty, product_image, manufacturer_id, service_man_id) values
('Intel Core i7', 'Quad-core processor', 28000, 2, '/images/intel_core_i7.jpg', 1, 10),
('NVIDIA GeForce RTX 3080', 'High-performance GPU', 42000, 3, '/images/nvidia_rtx_3080.jpg', 2, 11),
('Samsung 2TB SSD', 'Fast storage drive', 12000, 5, '/images/samsung_2tb_ssd.jpg', 3, 12);

insert into review (review_rating, review_description, customer_id, product_id) values
(5, 'Impressive performance!', 7, 1),
(4, 'Great GPU for gaming', 8, 2),
(5, 'Fast and reliable SSD', 9, 3);

insert into order_table_contains_product (order_id, product_id, quantity) values
(1, 1, 4),
(2, 2, 2),
(3, 3, 3);

insert into product_is_in_category (product_id, category_id) values
(1, 1),
(2, 2),
(3, 3);

insert into product_is_in_stock_in_warehouse (product_id, warehouse_id, quantity) values
(1, 1, 10),
(2, 2, 15),
(3, 3, 8);

insert into vehicle_is_used_for_delivery (vehicle_id, delivery_id) values
(1, 1),
(2, 2),
(3, 3);