INSERT INTO project."Configuration" (config_id,"name",price,"type") VALUES 
(2500,'Configuration 01',25000,'Gaming')
,(2501,'Configuration 02',36000,'All In One')
,(2502,'Configuration 03',55000,'Other')
,(2503,'Configuration 04',68000,'Gaming')
,(2504,'Configuration 05',42000,'Gaming')
,(2505,'Configuration 6',33000,'Productivity')
,(2506,'Configuration 7',20000,'Productivity');





INSERT INTO project."admin" (admin_id) VALUES 
(1)
,(2)
,(3)
,(4)
,(5);

INSERT INTO project.cart (cart_id,client_id) VALUES 
(1111,14)
,(1112,15)
,(1113,16)
,(1114,17);

INSERT INTO project.checkout (cart_id,order_id) VALUES 
(1111,41111)
,(1112,41112)
,(1112,41113)
,(1113,41114)
,(1114,41115)
,(1114,41116);

INSERT INTO project.client (client_id,address,"name","e-mail") VALUES 
(14,'Volgogradska 21','Petar Petrov','petar@gmail.com')
,(15,'Kozle 24','Martin Martinovski','martin@gmail.com')
,(16,'Preseka 25','David Pavlovski','david@gmail.com')
,(17,'Zebra 19','Angela Angelovska','angela@gmail.com')
,(18,'Ruzveltova 56','Ana Gjorgievska','ana@gmail.com')
,(19,'Aerodrom 23','Sandra Sandrovska','sandra@gmail.com')
,(20,'Singilic 66','Martina Kristinovska','martina@gmail.com');

INSERT INTO project.config_contains_product (config_id,prod_id,num_products_config) VALUES 
(2500,3250,1)
,(2501,3259,2)
,(2501,3254,2)
,(2503,3260,1)
,(2504,3264,1);

INSERT INTO project.contains_product (prod_id,cart_id,quantity) VALUES 
(3250,1111,2)
,(3256,1111,1)
,(3261,1112,1)
,(3262,1113,2)
,(3264,1114,3)
,(3262,1112,1)
,(3262,1114,1);

INSERT INTO project.delivery (delivery_id,delivery_address,"date",status,client_id,distributor_id) VALUES 
(51411,'Kozle 24','2022-02-19','Delivered',15,9)
,(51412,'Preseka 25','2022-02-19','Delivered',16,9)
,(120,'Centar','2022-02-15','Delivered',17,12)
,(121,'Kozle','2022-02-15','Delivered',18,12)
,(122,'Gjorce','2022-02-20','Delivered',19,12)
,(124,'Vodnjanska','2022-02-15','Delivered',14,10)
,(123,'Preseka','2022-02-09','Delivered',20,9)
,(125,'Pariska','2021-02-16','Delivered',15,10)
,(51410,'Volgogradska 21','2022-01-01','Delivered',14,9)
,(111,'Preseka','2022-05-02','Delivered',14,9);

INSERT INTO project.delivery (delivery_id,delivery_address,"date",status,client_id,distributor_id) VALUES 
(113,'Kozle24','2022-06-03','Delivered',15,10)
,(114,'Preseka25','2022-07-05','Delivered',16,11)
,(115,'Zebra19','2022-08-05','Delivered',17,11)
,(116,'Zebra19','2021-09-06','Delivered',17,12)
,(112,'Kozle24','2022-09-03','Delivered',15,10)
,(117,'Vodnjanska','2022-10-15','Delivered',14,13)
,(118,'Pariska','2022-10-14','Delivered',15,13)
,(119,'Ruzveltova','2022-11-13','Delivered',16,13);

INSERT INTO project.distributor (distributor_id,"name",surname,contact_number) VALUES 
(9,'Davor','Srbinovski',111)
,(10,'Snezana','Zdravkovska',222)
,(11,'Filip','Filipovski',333)
,(12,'Gorazd','Stamenkovski',444)
,(13,'Nina','Korstafova',555);

INSERT INTO project.manages_configuration (config_id,admin_id) VALUES 
(2500,1)
,(2501,1)
,(2502,5)
,(2503,3)
,(2504,4);

INSERT INTO project."order" (order_id,order_status,total_price,client_id,delivery_id) VALUES 
(41210,'Processed',25000,14,51410)
,(41211,'Processed',36000,15,51411)
,(41212,'Processed',55000,16,51412)
,(41111,'Processed',46000,14,111)
,(41112,'Processed',6500,15,112)
,(41113,'Processed',12000,15,113)
,(41114,'Processed',5000,16,114)
,(41115,'Processed',9850,17,115)
,(41116,'Processed',47400,17,116)
,(4000,'Processed',68000,14,117);

INSERT INTO project."order" (order_id,order_status,total_price,client_id,delivery_id) VALUES 
(4001,'Processed',42000,15,118)
,(4002,'Processed',33000,16,119)
,(4003,'Processed',20000,17,120)
,(4004,'Processed',20000,18,121)
,(4005,'Processed',20000,19,122)
,(4006,'Processed',20000,20,123)
,(4007,'Processed',55000,14,124)
,(4008,'Processed',55000,15,125);

INSERT INTO project.orders_configuration (config_id,order_id) VALUES 
(2500,41210)
,(2501,41211)
,(2502,41212)
,(2503,4000)
,(2504,4001)
,(2505,4002)
,(2506,4003)
,(2506,4004)
,(2506,4005)
,(2506,4006);

INSERT INTO project.orders_configuration (config_id,order_id) VALUES 
(2502,4007)
,(2502,4008);

INSERT INTO project.price_history (price_history_id,dates,prod_id,"Product_price") VALUES 
(4000,'2022-01-01',3250,15000)
,(4001,'2022-01-02',3250,15500)
,(4003,'2022-01-03',3250,17000)
,(4002,'2022-01-15',3250,13000)
,(4004,'2022-02-10',3250,18000)
,(4005,'2021-01-01',3250,15000)
,(4006,'2021-12-01',3250,16123)
,(4007,'2021-03-01',3250,15100)
,(4008,'2021-04-01',3250,15150)
,(4009,'2021-05-01',3250,15155);

INSERT INTO project.price_history (price_history_id,dates,prod_id,"Product_price") VALUES 
(4010,'2021-06-01',3250,16000)
,(4011,'2021-07-01',3250,15100)
,(4012,'2021-08-01',3250,15100)
,(4013,'2021-09-01',3250,15100)
,(4014,'2021-10-01',3250,15100)
,(4015,'2021-11-01',3250,15100);

INSERT INTO project.product (prod_id,availability,"name",description,price,"type",quantity,store_id) VALUES 
(3259,true,'CPU AMD Athlon PRO 300GE Dual-Core 3.4GHz AM4 5MB TRAY','CPU',32000,'CPU',1,'3')
,(3260,false,'Sapphire AMD R7 240 4GB DDR3','Graficka kartica',6500,'Graphics Card',0,'1')
,(3261,false,'PSU 850W Be Quiet! Straight Power 11','Napojuvanje',12000,'Power Supply',0,'1')
,(3262,false,'ATX Micro / ITX Case SAMA Inpower','Kukjishte',2500,'Case',0,'2')
,(3263,false,'ATX Mid Tower Case NZXT H710i w/Window SmartDevice','Kukjishte',9850,'Case',0,'1')
,(3264,false,'ATX Full Tower Case ThermalTake The Tower 900 Black','Kukjishte',15800,'Case',0,'2')
,(3252,true,'DIMM 32GB DDR5 6000MHz Kingston Fury Beast Kit CL40 (2x16)','RAM memorija',32000,'RAM Memory',6,'1')
,(3253,true,'DIMM 16GB DDR4 3600Mhz Corsair Vengeance PRO RGB','RAM memorija',5600,'RAM Memory',15,'2')
,(3254,true,'SSD 2.5" Leven JS600 Series 128GB','SSD',1200,'SSD',22,'2')
,(3258,true,'CPU AMD Athlon PRO 300GE Dual-Core 3.4GHz AM4 5MB TRAY','CPU',3600,'CPU',16,'2');

INSERT INTO project.product (prod_id,availability,"name",description,price,"type",quantity,store_id) VALUES 
(3250,true,'Gigabyte GeForce GTX 1050 Ti OC Low Profile 4GB GDDR5','Graficka kartica',15000,'Graphics Card',12,'1')
,(3251,true,'MSI GeForce GT710 1GB DDR3 LP HDMI/DVI/VGA','Graficka kartica',2500,'Graphics Card',20,'1')
,(3255,true,'PSU 550W Corsair CX550F RGB White 80 Plus','Napojuvanje',5400,'Power Supply',6,'1')
,(3256,true,'CPU Intel Core i7-9700 Coffee Lake Eight Core','CPU',16000,'CPU',4,'3')
,(3257,true,'MSI GeForce RTX 3090 SUPRIM X 24GB GDDR6X','Graficka kartica',120000,'Graphics Card',2,'1');

INSERT INTO project.product_to_wishlist (prod_id,wishlist_id) VALUES 
(3252,14)
,(3259,14)
,(3257,14)
,(3252,15)
,(3259,15)
,(3252,16)
,(3259,16)
,(3254,16)
,(3252,17)
,(3259,17);

INSERT INTO project.seller_admin (admin_id,seller_id,store_id,"name",surname,"e-mail") VALUES 
(1,6,'Anhoch','Atanas','Davidov','atanas@anhoch.com')
,(1,7,'Setec','Stefan','Stefanovski','stefan@setec.com')
,(2,8,'Neptun','Nikola','Petrov','nikola@neptun.com');

INSERT INTO project.store (store_id,locations,contact,store_name) VALUES 
(1,'Mida,GTC','contact@anhoch.com','Anhoch')
,(2,'Ruzveltova,City Mall','contact@setek.com','Setec')
,(3,'City Mall,Aerodrom','contact@neptun.com','Neptun');

INSERT INTO project.updates (seller_id,product_id,time_stamp) VALUES 
(6,3250,'2021-08-01')
,(7,3258,'2021-08-02')
,(7,3253,'2021-09-02')
,(7,3264,'2022-01-03')
,(6,3251,'2021-06-01')
,(6,3257,'2021-06-01')
,(6,3263,'2022-02-11')
,(7,3262,'2021-08-15')
,(6,3261,'2021-07-15')
,(6,3260,'2021-07-15');

INSERT INTO project.updates (seller_id,product_id,time_stamp) VALUES 
(8,3259,'2021-06-01')
,(8,3256,'2021-06-01')
,(6,3255,'2021-08-28')
,(7,3254,'2022-02-11')
,(6,3252,'2022-03-01');

INSERT INTO project.view_product (client_id,prod_id,time_stamp) VALUES 
(14,3250,'2021-08-27')
,(15,3251,'2021-08-30')
,(16,3253,'2021-10-15')
,(17,3255,'2021-11-20')
,(18,3256,'2021-12-05')
,(19,3257,'2022-01-19')
,(20,3254,'2022-02-02')
,(18,3255,'2022-02-05')
,(18,3251,'2022-02-09')
,(15,3262,'2022-02-20');

INSERT INTO project.view_product (client_id,prod_id,time_stamp) VALUES 
(20,3259,'2022-03-02')
,(14,3255,'2022-03-01')
,(18,3264,'2022-03-11')
,(16,3257,'2022-03-22')
,(17,3252,'2022-03-28');

INSERT INTO project.wishlist (wishlist_id,client_id) VALUES 
(8169,20)
,(14,14)
,(16,16)
,(19,19)
,(15,15)
,(20,20)
,(17,17)
,(18,18);