Логички и физички дизајн: polnenje.sql

File polnenje.sql, 8.7 KB (added by 186102, 3 years ago)
Line 
1INSERT INTO project."Configuration" (config_id,"name",price,"type") VALUES
2(2500,'Configuration 01',25000,'Gaming')
3,(2501,'Configuration 02',36000,'All In One')
4,(2502,'Configuration 03',55000,'Other')
5,(2503,'Configuration 04',68000,'Gaming')
6,(2504,'Configuration 05',42000,'Gaming')
7,(2505,'Configuration 6',33000,'Productivity')
8,(2506,'Configuration 7',20000,'Productivity');
9
10INSERT INTO project."User" (user_id,"Password") VALUES
11(1,'pass1')
12,(2,'pass2')
13,(3,'pass3')
14,(4,'pass4')
15,(5,'pass5')
16,(6,'pass6')
17,(7,'pass7')
18,(8,'pass8')
19,(9,'pass9')
20,(10,'pass10');
21
22INSERT INTO project."User" (user_id,"Password") VALUES
23(11,'pass11')
24,(12,'pass12')
25,(13,'pass13')
26,(14,'pass14')
27,(15,'pass15')
28,(16,'pass16')
29,(17,'pass17')
30,(18,'pass18')
31,(19,'pass19')
32,(20,'pass20');
33
34INSERT INTO project."admin" (admin_id) VALUES
35(1)
36,(2)
37,(3)
38,(4)
39,(5);
40
41INSERT INTO project.cart (cart_id,client_id) VALUES
42(1111,14)
43,(1112,15)
44,(1113,16)
45,(1114,17);
46
47INSERT INTO project.checkout (cart_id,order_id) VALUES
48(1111,41111)
49,(1112,41112)
50,(1112,41113)
51,(1113,41114)
52,(1114,41115)
53,(1114,41116);
54
55INSERT INTO project.client (client_id,address,"name","e-mail") VALUES
56(14,'Volgogradska 21','Petar Petrov','petar@gmail.com')
57,(15,'Kozle 24','Martin Martinovski','martin@gmail.com')
58,(16,'Preseka 25','David Pavlovski','david@gmail.com')
59,(17,'Zebra 19','Angela Angelovska','angela@gmail.com')
60,(18,'Ruzveltova 56','Ana Gjorgievska','ana@gmail.com')
61,(19,'Aerodrom 23','Sandra Sandrovska','sandra@gmail.com')
62,(20,'Singilic 66','Martina Kristinovska','martina@gmail.com');
63
64INSERT INTO project.config_contains_product (config_id,prod_id,num_products_config) VALUES
65(2500,3250,1)
66,(2501,3259,2)
67,(2501,3254,2)
68,(2503,3260,1)
69,(2504,3264,1);
70
71INSERT INTO project.contains_product (prod_id,cart_id,quantity) VALUES
72(3250,1111,2)
73,(3256,1111,1)
74,(3261,1112,1)
75,(3262,1113,2)
76,(3264,1114,3)
77,(3262,1112,1)
78,(3262,1114,1);
79
80INSERT INTO project.delivery (delivery_id,delivery_address,"date",status,client_id,distributor_id) VALUES
81(51411,'Kozle 24','2022-02-19','Delivered',15,9)
82,(51412,'Preseka 25','2022-02-19','Delivered',16,9)
83,(120,'Centar','2022-02-15','Delivered',17,12)
84,(121,'Kozle','2022-02-15','Delivered',18,12)
85,(122,'Gjorce','2022-02-20','Delivered',19,12)
86,(124,'Vodnjanska','2022-02-15','Delivered',14,10)
87,(123,'Preseka','2022-02-09','Delivered',20,9)
88,(125,'Pariska','2021-02-16','Delivered',15,10)
89,(51410,'Volgogradska 21','2022-01-01','Delivered',14,9)
90,(111,'Preseka','2022-05-02','Delivered',14,9);
91
92INSERT INTO project.delivery (delivery_id,delivery_address,"date",status,client_id,distributor_id) VALUES
93(113,'Kozle24','2022-06-03','Delivered',15,10)
94,(114,'Preseka25','2022-07-05','Delivered',16,11)
95,(115,'Zebra19','2022-08-05','Delivered',17,11)
96,(116,'Zebra19','2021-09-06','Delivered',17,12)
97,(112,'Kozle24','2022-09-03','Delivered',15,10)
98,(117,'Vodnjanska','2022-10-15','Delivered',14,13)
99,(118,'Pariska','2022-10-14','Delivered',15,13)
100,(119,'Ruzveltova','2022-11-13','Delivered',16,13);
101
102INSERT INTO project.distributor (distributor_id,"name",surname,contact_number) VALUES
103(9,'Davor','Srbinovski',111)
104,(10,'Snezana','Zdravkovska',222)
105,(11,'Filip','Filipovski',333)
106,(12,'Gorazd','Stamenkovski',444)
107,(13,'Nina','Korstafova',555);
108
109INSERT INTO project.manages_configuration (config_id,admin_id) VALUES
110(2500,1)
111,(2501,1)
112,(2502,5)
113,(2503,3)
114,(2504,4);
115
116INSERT INTO project."order" (order_id,order_status,total_price,client_id,delivery_id) VALUES
117(41210,'Processed',25000,14,51410)
118,(41211,'Processed',36000,15,51411)
119,(41212,'Processed',55000,16,51412)
120,(41111,'Processed',46000,14,111)
121,(41112,'Processed',6500,15,112)
122,(41113,'Processed',12000,15,113)
123,(41114,'Processed',5000,16,114)
124,(41115,'Processed',9850,17,115)
125,(41116,'Processed',47400,17,116)
126,(4000,'Processed',68000,14,117);
127
128INSERT INTO project."order" (order_id,order_status,total_price,client_id,delivery_id) VALUES
129(4001,'Processed',42000,15,118)
130,(4002,'Processed',33000,16,119)
131,(4003,'Processed',20000,17,120)
132,(4004,'Processed',20000,18,121)
133,(4005,'Processed',20000,19,122)
134,(4006,'Processed',20000,20,123)
135,(4007,'Processed',55000,14,124)
136,(4008,'Processed',55000,15,125);
137
138INSERT INTO project.orders_configuration (config_id,order_id) VALUES
139(2500,41210)
140,(2501,41211)
141,(2502,41212)
142,(2503,4000)
143,(2504,4001)
144,(2505,4002)
145,(2506,4003)
146,(2506,4004)
147,(2506,4005)
148,(2506,4006);
149
150INSERT INTO project.orders_configuration (config_id,order_id) VALUES
151(2502,4007)
152,(2502,4008);
153
154INSERT INTO project.price_history (price_history_id,dates,prod_id,"Product_price") VALUES
155(4000,'2022-01-01',3250,15000)
156,(4001,'2022-01-02',3250,15500)
157,(4003,'2022-01-03',3250,17000)
158,(4002,'2022-01-15',3250,13000)
159,(4004,'2022-02-10',3250,18000)
160,(4005,'2021-01-01',3250,15000)
161,(4006,'2021-12-01',3250,16123)
162,(4007,'2021-03-01',3250,15100)
163,(4008,'2021-04-01',3250,15150)
164,(4009,'2021-05-01',3250,15155);
165
166INSERT INTO project.price_history (price_history_id,dates,prod_id,"Product_price") VALUES
167(4010,'2021-06-01',3250,16000)
168,(4011,'2021-07-01',3250,15100)
169,(4012,'2021-08-01',3250,15100)
170,(4013,'2021-09-01',3250,15100)
171,(4014,'2021-10-01',3250,15100)
172,(4015,'2021-11-01',3250,15100);
173
174INSERT INTO project.product (prod_id,availability,"name",description,price,"type",quantity,store_id) VALUES
175(3259,true,'CPU AMD Athlon PRO 300GE Dual-Core 3.4GHz AM4 5MB TRAY','CPU',32000,'CPU',1,'3')
176,(3260,false,'Sapphire AMD R7 240 4GB DDR3','Graficka kartica',6500,'Graphics Card',0,'1')
177,(3261,false,'PSU 850W Be Quiet! Straight Power 11','Napojuvanje',12000,'Power Supply',0,'1')
178,(3262,false,'ATX Micro / ITX Case SAMA Inpower','Kukjishte',2500,'Case',0,'2')
179,(3263,false,'ATX Mid Tower Case NZXT H710i w/Window SmartDevice','Kukjishte',9850,'Case',0,'1')
180,(3264,false,'ATX Full Tower Case ThermalTake The Tower 900 Black','Kukjishte',15800,'Case',0,'2')
181,(3252,true,'DIMM 32GB DDR5 6000MHz Kingston Fury Beast Kit CL40 (2x16)','RAM memorija',32000,'RAM Memory',6,'1')
182,(3253,true,'DIMM 16GB DDR4 3600Mhz Corsair Vengeance PRO RGB','RAM memorija',5600,'RAM Memory',15,'2')
183,(3254,true,'SSD 2.5" Leven JS600 Series 128GB','SSD',1200,'SSD',22,'2')
184,(3258,true,'CPU AMD Athlon PRO 300GE Dual-Core 3.4GHz AM4 5MB TRAY','CPU',3600,'CPU',16,'2');
185
186INSERT INTO project.product (prod_id,availability,"name",description,price,"type",quantity,store_id) VALUES
187(3250,true,'Gigabyte GeForce GTX 1050 Ti OC Low Profile 4GB GDDR5','Graficka kartica',15000,'Graphics Card',12,'1')
188,(3251,true,'MSI GeForce GT710 1GB DDR3 LP HDMI/DVI/VGA','Graficka kartica',2500,'Graphics Card',20,'1')
189,(3255,true,'PSU 550W Corsair CX550F RGB White 80 Plus','Napojuvanje',5400,'Power Supply',6,'1')
190,(3256,true,'CPU Intel Core i7-9700 Coffee Lake Eight Core','CPU',16000,'CPU',4,'3')
191,(3257,true,'MSI GeForce RTX 3090 SUPRIM X 24GB GDDR6X','Graficka kartica',120000,'Graphics Card',2,'1');
192
193INSERT INTO project.product_to_wishlist (prod_id,wishlist_id) VALUES
194(3252,14)
195,(3259,14)
196,(3257,14)
197,(3252,15)
198,(3259,15)
199,(3252,16)
200,(3259,16)
201,(3254,16)
202,(3252,17)
203,(3259,17);
204
205INSERT INTO project.seller_admin (admin_id,seller_id,store_id,"name",surname,"e-mail") VALUES
206(1,6,'Anhoch','Atanas','Davidov','atanas@anhoch.com')
207,(1,7,'Setec','Stefan','Stefanovski','stefan@setec.com')
208,(2,8,'Neptun','Nikola','Petrov','nikola@neptun.com');
209
210INSERT INTO project.store (store_id,locations,contact,store_name) VALUES
211(1,'Mida,GTC','contact@anhoch.com','Anhoch')
212,(2,'Ruzveltova,City Mall','contact@setek.com','Setec')
213,(3,'City Mall,Aerodrom','contact@neptun.com','Neptun');
214
215INSERT INTO project.updates (seller_id,product_id,time_stamp) VALUES
216(6,3250,'2021-08-01')
217,(7,3258,'2021-08-02')
218,(7,3253,'2021-09-02')
219,(7,3264,'2022-01-03')
220,(6,3251,'2021-06-01')
221,(6,3257,'2021-06-01')
222,(6,3263,'2022-02-11')
223,(7,3262,'2021-08-15')
224,(6,3261,'2021-07-15')
225,(6,3260,'2021-07-15');
226
227INSERT INTO project.updates (seller_id,product_id,time_stamp) VALUES
228(8,3259,'2021-06-01')
229,(8,3256,'2021-06-01')
230,(6,3255,'2021-08-28')
231,(7,3254,'2022-02-11')
232,(6,3252,'2022-03-01');
233
234INSERT INTO project.view_product (client_id,prod_id,time_stamp) VALUES
235(14,3250,'2021-08-27')
236,(15,3251,'2021-08-30')
237,(16,3253,'2021-10-15')
238,(17,3255,'2021-11-20')
239,(18,3256,'2021-12-05')
240,(19,3257,'2022-01-19')
241,(20,3254,'2022-02-02')
242,(18,3255,'2022-02-05')
243,(18,3251,'2022-02-09')
244,(15,3262,'2022-02-20');
245
246INSERT INTO project.view_product (client_id,prod_id,time_stamp) VALUES
247(20,3259,'2022-03-02')
248,(14,3255,'2022-03-01')
249,(18,3264,'2022-03-11')
250,(16,3257,'2022-03-22')
251,(17,3252,'2022-03-28');
252
253INSERT INTO project.wishlist (wishlist_id,client_id) VALUES
254(8169,20)
255,(14,14)
256,(16,16)
257,(19,19)
258,(15,15)
259,(20,20)
260,(17,17)
261,(18,18);