87ud3nCV

1-- Tables
2DROP TABLE IF EXISTS brand CASCADE;
3DROP TABLE IF EXISTS favorite CASCADE;
4DROP TABLE IF EXISTS model CASCADE;
5DROP TABLE IF EXISTS "order" CASCADE;
6DROP TABLE IF EXISTS payment CASCADE;
7DROP TABLE IF EXISTS product CASCADE;
8DROP TABLE IF EXISTS "user" CASCADE;
9DROP TABLE IF EXISTS history_product CASCADE;
10DROP TABLE IF EXISTS product_category CASCADE;
11DROP TABLE IF EXISTS single_category CASCADE;
12DROP TABLE IF EXISTS product_order CASCADE;
13DROP TABLE IF EXISTS featured_product CASCADE;
14DROP TABLE IF EXISTS review CASCADE;
15DROP TABLE IF EXISTS single_history_product CASCADE;
16DROP TABLE IF EXISTS single_featured_product CASCADE;
17
18
19
20
21CREATE TABLE brand (
22    id SERIAL,
23    name text NOT NULL
24);
25
26CREATE TABLE favorite (
27    id_user integer,
28    id_product integer,
29    addition_date timestamp with time zone
30);
31
32
33CREATE TABLE model (
34    id SERIAL,
35    name text,
36    id_brand integer
37);
38
39CREATE TABLE "order" (
40    status text NOT NULL,
41    address text NOT NULL,
42    contact text NOT NULL,
43    total_cost real,
44    payment_method text NOT NULL,
45    id_user integer,
46    id SERIAL,
47    delivery_date timestamp with time zone,
48    payment_date timestamp with time zone NOT NULL,
49    CONSTRAINT total_cost_positive CHECK ((total_cost > 0))
50);
51
52CREATE TABLE payment (
53    id SERIAL,
54    id_order integer,
55    method text,
56    amount real,
57    date timestamp with time zone
58);
59
60CREATE TABLE product (
61    id SERIAL,
62    name text NOT NULL,
63    description text NOT NULL,
64    stock integer,
65    price real,
66    id_model integer,
67    CONSTRAINT stock_positive CHECK ((stock >= 0)),
68    CONSTRAINT price_positive CHECK ((price > 0))
69);
70
71
72CREATE TABLE product_category (
73    id SERIAL,
74    name text NOT NULL
75);
76
77
78CREATE TABLE product_order (
79    id_product integer,
80    id_order integer
81);
82
83
84CREATE TABLE review (
85    id SERIAL,
86    score real,
87    comment text NOT NULL,
88    date timestamp with time zone NOT NULL,
89    id_product integer,
90    id_user integer
91);
92
93
94CREATE TABLE single_category (
95    id_product integer,
96    id_product_category integer
97);
98
99
100CREATE TABLE "user" (
101    id SERIAL,
102    email text NOT NULL,
103    name text NOT NULL,
104    password text NOT NULL,
105    address text,
106    city text,
107    permissions text NOT NULL
108);
109
110
111CREATE TABLE history_product (
112    id SERIAL,
113    date date NOT NULL,
114    description text NOT NULL,
115    price real NOT NULL
116);
117
118
119CREATE TABLE single_history_product (
120    id_history_product integer,
121    id_product integer
122);
123
124CREATE TABLE featured_product (
125    id SERIAL,
126    date date
127);
128
129CREATE TABLE single_featured_product (
130    id_product integer,
131    id_featured_product integer
132);
133
134-- Primary Keys and Uniques
135
136ALTER TABLE ONLY brand
137    ADD CONSTRAINT brand_pkey PRIMARY KEY (id);
138
139ALTER TABLE ONLY brand
140    ADD CONSTRAINT brand_name UNIQUE (name);
141
142ALTER TABLE ONLY favorite
143    ADD CONSTRAINT favorite_pkey PRIMARY KEY (id_user, id_product);
144
145ALTER TABLE ONLY model
146    ADD CONSTRAINT model_pkey PRIMARY KEY (id);
147
148ALTER TABLE ONLY model
149    ADD CONSTRAINT model_name UNIQUE (name);
150
151ALTER TABLE ONLY "order"
152    ADD CONSTRAINT order_pkey PRIMARY KEY (id);
153
154ALTER TABLE ONLY payment
155    ADD CONSTRAINT payment_pkey PRIMARY KEY (id);
156
157ALTER TABLE ONLY product
158    ADD CONSTRAINT product_pkey PRIMARY KEY (id);
159
160ALTER TABLE ONLY product
161    ADD CONSTRAINT product_name UNIQUE (name);
162
163ALTER TABLE ONLY history_product
164ADD CONSTRAINT  history_product_pkey PRIMARY KEY (id);
165
166ALTER TABLE ONLY product_category
167    ADD CONSTRAINT product_category_pkey PRIMARY KEY (id);
168
169ALTER TABLE ONLY featured_product
170    ADD CONSTRAINT featured_product_pkey PRIMARY KEY (id);
171
172ALTER TABLE ONLY product_order
173    ADD CONSTRAINT product_order_pkey PRIMARY KEY (id_product,id_order);
174
175ALTER TABLE ONLY review
176    ADD CONSTRAINT review_pkey PRIMARY KEY (id);
177
178ALTER TABLE ONLY single_category
179    ADD CONSTRAINT single_category_pkey PRIMARY KEY (id_product, id_product_category);
180
181ALTER TABLE ONLY "user"
182    ADD CONSTRAINT user_pkey PRIMARY KEY (id);
183
184ALTER TABLE ONLY "user"
185    ADD CONSTRAINT user_email_key UNIQUE (email);
186
187ALTER TABLE ONLY single_featured_product
188    ADD CONSTRAINT single_featured_product_pkey PRIMARY KEY (id_product, id_featured_product);
189
190
191    -- Foreign Keys
192
193ALTER TABLE ONLY favorite
194    ADD CONSTRAINT favorite_id_user_fkey FOREIGN KEY (id_user) REFERENCES "user"(id) ON UPDATE CASCADE;
195
196ALTER TABLE ONLY favorite
197    ADD CONSTRAINT favorite_id_product_fkey FOREIGN KEY (id_product) REFERENCES product(id) ON UPDATE CASCADE;
198
199ALTER TABLE ONLY model
200    ADD CONSTRAINT model_id_brand_fkey FOREIGN KEY (id_brand) REFERENCES brand(id) ON UPDATE CASCADE;
201
202ALTER TABLE ONLY "order"
203    ADD CONSTRAINT order_id_user_fkey FOREIGN KEY (id_user) REFERENCES "user"(id) ON UPDATE CASCADE;
204
205ALTER TABLE ONLY payment
206    ADD CONSTRAINT payment_id_order_fkey FOREIGN KEY (id_order) REFERENCES "order"(id) ON UPDATE CASCADE;
207
208ALTER TABLE ONLY product
209    ADD CONSTRAINT product_id_model_fkey FOREIGN KEY (id_model) REFERENCES model(id) ON UPDATE CASCADE;
210
211ALTER TABLE ONLY product_order
212    ADD CONSTRAINT product_order_id_product_fkey FOREIGN KEY (id_product) REFERENCES product(id) ON UPDATE CASCADE;
213
214ALTER TABLE ONLY product_order
215    ADD CONSTRAINT product_order_id_order_fkey FOREIGN KEY (id_order) REFERENCES "order"(id) ON UPDATE CASCADE;
216
217ALTER TABLE ONLY review
218    ADD CONSTRAINT review_id_user_fkey FOREIGN KEY (id_user) REFERENCES "user"(id) ON UPDATE CASCADE;
219
220ALTER TABLE ONLY review
221    ADD CONSTRAINT review_id_product_fkey FOREIGN KEY (id_product) REFERENCES product(id) ON UPDATE CASCADE;
222
223ALTER TABLE ONLY single_category
224    ADD CONSTRAINT single_category_id_product_fkey FOREIGN KEY (id_product) REFERENCES product(id) ON UPDATE CASCADE;
225
226ALTER TABLE ONLY single_category
227    ADD CONSTRAINT single_category_id_product_category_fkey FOREIGN KEY (id_product_category) REFERENCES product_category(id) ON UPDATE CASCADE;
228
229ALTER TABLE ONLY single_history_product
230    ADD CONSTRAINT single_history_product_id_history_product_fkey FOREIGN KEY (id_history_product) REFERENCES history_product(id) ON UPDATE CASCADE;
231
232ALTER TABLE ONLY single_history_product
233    ADD CONSTRAINT single_history_product_id_product_fkey FOREIGN KEY (id_product) REFERENCES product(id) ON UPDATE CASCADE;
234
235ALTER TABLE ONLY single_featured_product
236    ADD CONSTRAINT single_featured_product_id_product_fkey FOREIGN KEY (id_product) REFERENCES product(id) ON UPDATE CASCADE;
237
238ALTER TABLE ONLY single_featured_product
239ADD CONSTRAINT single_featured_product_id__featured_product_fkey FOREIGN KEY (id_featured_product) REFERENCES featured_product(id) ON UPDATE CASCADE;
240
241
242
243
244
245
246INSERT INTO brand (id,name) VALUES (1,'Asus');
247INSERT INTO brand (id,name) VALUES (2,'HP');
248INSERT INTO brand (id,name) VALUES (3,'Apple');
249INSERT INTO brand (id,name) VALUES (4,'Samsung');
250INSERT INTO brand (id,name) VALUES (5,'Xiaomi');
251INSERT INTO brand (id,name) VALUES (6,'One Plus');
252INSERT INTO brand (id,name) VALUES (7,'Huawei');
253INSERT INTO brand (id,name) VALUES (8,'Toshiba');
254INSERT INTO brand (id,name) VALUES (9,'Lenovo');
255INSERT INTO brand (id,name) VALUES (10,'Nokia');
256INSERT INTO brand (id,name) VALUES (11,'Acer');
257INSERT INTO brand (id,name) VALUES (12,'Dell');
258INSERT INTO brand (id,name) VALUES (13,'Microsoft');
259INSERT INTO brand (id,name) VALUES (14,'LG');
260INSERT INTO brand (id,name) VALUES (15,'Intel');
261INSERT INTO brand (id,name) VALUES (16,'AMD');
262INSERT INTO brand (id,name) VALUES (17,'MSI');
263INSERT INTO brand (id,name) VALUES (18,'Kingston');
264INSERT INTO brand (id,name) VALUES (19,'SanDisk');
265INSERT INTO brand (id,name) VALUES (20,'NVIDIA');
266
267INSERT INTO favorite (id_user,id_product,addition_date) VALUES (6,8,'05/04/2018');
268INSERT INTO favorite (id_user,id_product,addition_date) VALUES (6,9,'17/12/2017');
269INSERT INTO favorite (id_user,id_product,addition_date) VALUES (3,8,'20/03/2018');
270INSERT INTO favorite (id_user,id_product,addition_date) VALUES (15,6,'03/06/2018');
271INSERT INTO favorite (id_user,id_product,addition_date) VALUES (10,2,'07/04/2017');
272INSERT INTO favorite (id_user,id_product,addition_date) VALUES (2,4,'24/05/2018');
273INSERT INTO favorite (id_user,id_product,addition_date) VALUES (19,6,'23/09/2017');
274INSERT INTO favorite (id_user,id_product,addition_date) VALUES (14,8,'20/09/2017');
275INSERT INTO favorite (id_user,id_product,addition_date) VALUES (11,8,'20/07/2018');
276INSERT INTO favorite (id_user,id_product,addition_date) VALUES (19,4,'22/11/2018');
277INSERT INTO favorite (id_user,id_product,addition_date) VALUES (2,7,'15/01/2019');
278INSERT INTO favorite (id_user,id_product,addition_date) VALUES (13,8,'27/10/2018');
279INSERT INTO favorite (id_user,id_product,addition_date) VALUES (5,7,'08/07/2018');
280INSERT INTO favorite (id_user,id_product,addition_date) VALUES (6,4,'26/12/2018');
281INSERT INTO favorite (id_user,id_product,addition_date) VALUES (5,10,'05/01/2018');
282INSERT INTO favorite (id_user,id_product,addition_date) VALUES (10,7,'13/10/2017');
283INSERT INTO favorite (id_user,id_product,addition_date) VALUES (20,6,'22/06/2017');
284INSERT INTO favorite (id_user,id_product,addition_date) VALUES (14,8,'26/08/2018');
285INSERT INTO favorite (id_user,id_product,addition_date) VALUES (9,7,'08/04/2017');
286INSERT INTO favorite (id_user,id_product,addition_date) VALUES (12,8,'09/08/2017');
287
288INSERT INTO model (id,name,id_brand) VALUES (1,'Surface 3',13);
289INSERT INTO model (id,name,id_brand) VALUES (2,'SDSDUNC-064G-GN6IN',19);
290INSERT INTO model (id,name,id_brand) VALUES (3,'6',10);
291INSERT INTO model (id,name,id_brand) VALUES (4,'SDSDUNC-128G-GN6IN',19);
292INSERT INTO model (id,name,id_brand) VALUES (5,'GL62M 7RDX-2203XES',17);
293INSERT INTO model (id,name,id_brand) VALUES (6,'A6-6400K',16);
294INSERT INTO model (id,name,id_brand) VALUES (7,'Lumia 1020',10);
295INSERT INTO model (id,name,id_brand) VALUES (8,'Yoga',9);
296INSERT INTO model (id,name,id_brand) VALUES (9,'S9+',4);
297INSERT INTO model (id,name,id_brand) VALUES (10,'Latitude 5480',12);
298INSERT INTO model (id,name,id_brand) VALUES (11,'X',3);
299INSERT INTO model (id,name,id_brand) VALUES (12,'Aspire V 13',11);
300INSERT INTO model (id,name,id_brand) VALUES (13,'P20',7);
301INSERT INTO model (id,name,id_brand) VALUES (14,'GTX1080',20);
302INSERT INTO model (id,name,id_brand) VALUES (15,'Mi 6',5);
303INSERT INTO model (id,name,id_brand) VALUES (16,'Macbook Pro 15"',3);
304INSERT INTO model (id,name,id_brand) VALUES (17,'G6',14);
305INSERT INTO model (id,name,id_brand) VALUES (18,'8',3);
306INSERT INTO model (id,name,id_brand) VALUES (19,'S8',4);
307INSERT INTO model (id,name,id_brand) VALUES (20,'GTX960M',20);
308
309INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Deliveried','Ap #699-800 Ligula St.','981 553 524',2203,'Credit Card ',11,1,'06/10/2018','12/07/2017');
310INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Processing ','P.O. Box 328, 3629 Luctus Avenue','915 449 883',244,'Credit Card ',17,2,'22/01/2018','04/10/2017');
311INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES ('Wainting for payment ','125-2064 Non Rd.','912 223 293',2606,' Paypal ',5,3,'06/03/2018','25/10/2018');
312INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Deliveried','5728 Duis Rd.','923 049 699',1373,' Paypal ',15,4,'31/12/2017','09/11/2017');
313INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Paid ','406-5972 Est, Ave','997 575 459',133,'Credit Card ',3,5,'19/07/2018','19/04/2017');
314INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Processing ','Ap #739-7587 Enim St.','929 674 574',2177,' Paypal ',14,6,'08/10/2017','26/01/2018');
315INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Dispatched ','141-4427 Nunc St.','921 047 241',568,' Paypal ',19,7,'08/11/2017','12/09/2018');
316INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Paid ','P.O. Box 414, 8721 Fusce Rd.','911 618 718',618,' Paypal ',9,8,'29/07/2018','06/02/2018');
317INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Paid ','825-459 Et Rd.','906 620 148',1932,'Credit Card ',2,9,'03/04/2019','28/01/2018');
318INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Deliveried','Ap #368-237 Dictum Ave','926 665 779',2635,' Paypal ',20,10,'11/10/2018','07/08/2017');
319INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Paid ','P.O. Box 429, 4162 Aliquam Rd.','974 961 497',2413,'Credit Card ',16,11,'07/03/2019','25/07/2018');
320INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Paid ','908-3078 Egestas, Rd.','945 787 498',2913,'Credit Card ',11,12,'14/12/2017','05/06/2017');
321INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Processing ','7485 Sapien Rd.','984 004 124',473,' Paypal ',16,13,'25/03/2018','01/02/2018');
322INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Paid ','Ap #887-8670 Ante, Ave','926 430 684',1589,'Credit Card ',11,14,'26/06/2017','21/06/2017');
323INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Paid ','P.O. Box 309, 2462 A St.','902 441 049',577,'Credit Card ',13,15,'23/01/2018','05/08/2017');
324INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Processing ','P.O. Box 240, 631 Quam, St.','974 353 673',376,'Credit Card ',14,16,'30/05/2018','19/01/2019');
325INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Deliveried','P.O. Box 264, 7686 Mollis St.','901 715 595',2512,'Credit Card ',8,17,'18/01/2018','26/01/2018');
326INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES ('Wainting for payment ','396-1328 Scelerisque, Road','904 053 178',1985,'Credit Card ',11,18,'07/07/2018','26/05/2018');
327INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Shipped Out ','P.O. Box 487, 7301 Eu St.','961 389 045',2541,'Credit Card ',15,19,'28/08/2018','28/09/2017');
328INSERT INTO "order" (status,address,contact,total_cost,payment_method,id_user,id,delivery_date,payment_date) VALUES (' Deliveried','Ap #512-1247 Netus Road','908 561 667',922,' Paypal ',14,20,'15/09/2018','20/02/2018');
329
330INSERT INTO payment (id,method,amount,date) VALUES (1,' MBWay',405,'01/11/2017');
331INSERT INTO payment (id,method,amount,date) VALUES (2,'Credit Card ',271,'16/03/2018');
332INSERT INTO payment (id,method,amount,date) VALUES (3,' Paypal ',1043,'07/05/2018');
333INSERT INTO payment (id,method,amount,date) VALUES (4,' MBWay',602,'10/12/2017');
334INSERT INTO payment (id,method,amount,date) VALUES (5,'Credit Card ',577,'23/08/2017');
335INSERT INTO payment (id,method,amount,date) VALUES (6,'Credit Card ',722,'03/02/2018');
336INSERT INTO payment (id,method,amount,date) VALUES (7,' Paypal ',641,'14/12/2017');
337INSERT INTO payment (id,method,amount,date) VALUES (8,' MBWay',466,'09/02/2018');
338INSERT INTO payment (id,method,amount,date) VALUES (9,' MBWay',864,'24/01/2018');
339INSERT INTO payment (id,method,amount,date) VALUES (10,' Paypal ',667,'20/04/2017');
340INSERT INTO payment (id,method,amount,date) VALUES (11,' Paypal ',915,'22/07/2018');
341INSERT INTO payment (id,method,amount,date) VALUES (12,' Paypal ',1079,'02/12/2017');
342INSERT INTO payment (id,method,amount,date) VALUES (13,'Credit Card ',183,'30/03/2018');
343INSERT INTO payment (id,method,amount,date) VALUES (14,' Paypal ',752,'01/12/2017');
344INSERT INTO payment (id,method,amount,date) VALUES (15,' Paypal ',711,'15/04/2017');
345INSERT INTO payment (id,method,amount,date) VALUES (16,' MBWay',272,'02/12/2017');
346INSERT INTO payment (id,method,amount,date) VALUES (17,' MBWay',121,'19/03/2019');
347INSERT INTO payment (id,method,amount,date) VALUES (18,' Paypal ',930,'30/09/2018');
348INSERT INTO payment (id,method,amount,date) VALUES (19,'Credit Card ',301,'09/08/2018');
349INSERT INTO payment (id,method,amount,date) VALUES (20,' Paypal ',1344,'01/06/2017');
350
351INSERT INTO product (id,name,description,stock,price,model_id) VALUES (1,'Steel','facilisis non, bibendum sed, est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque sed dictum eleifend, nunc risus varius orci, in consequat enim diam vel arcu. Curabitur ut odio vel est tempor bibendum. Donec felis orci, adipiscing non, luctus sit amet, faucibus ut, nulla. Cras eu tellus eu augue porttitor interdum. Sed auctor odio a purus. Duis elementum, dui quis accumsan convallis, ante lectus convallis est, vitae sodales nisi magna sed dui. Fusce aliquam, enim nec tempus scelerisque, lorem ipsum sodales purus, in molestie tortor nibh sit amet orci. Ut sagittis lobortis mauris. Suspendisse',9970,950,1);
352INSERT INTO product (id,name,description,stock,price,model_id) VALUES (2,'Garrison','diam nunc, ullamcorper eu, euismod ac, fermentum vel, mauris. Integer sem elit, pharetra ut, pharetra sed, hendrerit a, arcu. Sed et libero. Proin mi. Aliquam gravida mauris ut mi. Duis risus odio, auctor vitae, aliquet nec, imperdiet nec, leo. Morbi neque tellus, imperdiet non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem ipsum dolor sit amet, consectetuer',1832,530,1);
353INSERT INTO product (id,name,description,stock,price,model_id) VALUES (3,'Solomon','Mauris ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus. Donec egestas. Duis ac arcu. Nunc mauris. Morbi non sapien molestie orci tincidunt adipiscing. Mauris molestie pharetra nibh. Aliquam ornare, libero at auctor ullamcorper, nisl arcu iaculis enim, sit amet ornare lectus justo eu arcu. Morbi sit amet massa. Quisque porttitor eros nec tellus. Nunc lectus pede, ultrices a, auctor non, feugiat nec, diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis',1436,1211,13);
354INSERT INTO product (id,name,description,stock,price,model_id) VALUES (4,'Slade','in, cursus et, eros. Proin ultrices. Duis volutpat nunc sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer vulputate, risus a ultricies adipiscing, enim mi tempor lorem, eget mollis lectus pede et risus. Quisque libero lacus, varius et, euismod et, commodo at, libero. Morbi accumsan laoreet ipsum. Curabitur consequat, lectus sit amet luctus vulputate, nisi sem semper erat, in consectetuer ipsum nunc id enim. Curabitur massa. Vestibulum accumsan neque et',7510,354,12);
355INSERT INTO product (id,name,description,stock,price,model_id) VALUES (5,'Martin','pede nec ante blandit viverra. Donec tempus, lorem fringilla ornare placerat, orci lacus vestibulum lorem, sit amet ultricies sem magna nec quam. Curabitur vel lectus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec dignissim magna a tortor. Nunc commodo auctor velit. Aliquam nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus rhoncus. Donec est. Nunc ullamcorper, velit in aliquet lobortis, nisi nibh lacinia orci, consectetuer euismod est',4946,576,13);
356INSERT INTO product (id,name,description,stock,price,model_id) VALUES (6,'Nicholas','a neque. Nullam ut nisi a odio semper cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis odio. Nam interdum enim non nisi. Aenean eget metus. In nec orci. Donec nibh. Quisque nonummy ipsum non arcu. Vivamus sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper magna. Sed eu eros. Nam consequat dolor vitae dolor. Donec fringilla. Donec feugiat metus',7345,967,2);
357INSERT INTO product (id,name,description,stock,price,model_id) VALUES (7,'Kenneth','In nec orci. Donec nibh. Quisque nonummy ipsum non arcu. Vivamus sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper magna. Sed eu eros. Nam consequat dolor vitae dolor. Donec fringilla. Donec feugiat metus sit amet ante. Vivamus non lorem vitae odio sagittis semper. Nam tempor diam dictum sapien. Aenean massa. Integer vitae nibh. Donec est mauris, rhoncus id, mollis nec, cursus a, enim. Suspendisse aliquet,',8989,93,14);
358INSERT INTO product (id,name,description,stock,price,model_id) VALUES (8,'Isaiah','Curabitur massa. Vestibulum accumsan neque et nunc. Quisque ornare tortor at risus. Nunc ac sem ut dolor dapibus gravida. Aliquam tincidunt, nunc ac mattis ornare, lectus ante dictum mi, ac mattis velit justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc sollicitudin commodo ipsum. Suspendisse non leo. Vivamus nibh dolor, nonummy ac, feugiat non, lobortis quis, pede. Suspendisse dui. Fusce diam nunc, ullamcorper eu, euismod ac, fermentum vel,',1794,346,3);
359INSERT INTO product (id,name,description,stock,price,model_id) VALUES (9,'Andrew','et, euismod et, commodo at, libero. Morbi accumsan laoreet ipsum. Curabitur consequat, lectus sit amet luctus vulputate, nisi sem semper erat, in consectetuer ipsum nunc id enim. Curabitur massa. Vestibulum accumsan neque et nunc. Quisque ornare tortor at risus. Nunc ac sem ut dolor dapibus gravida. Aliquam tincidunt, nunc ac mattis ornare, lectus ante dictum mi, ac mattis velit justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere',7575,994,8);
360INSERT INTO product (id,name,description,stock,price,model_id) VALUES (10,'Thane','in felis. Nulla tempor augue ac ipsum. Phasellus vitae mauris sit amet lorem semper auctor. Mauris vel turpis. Aliquam adipiscing lobortis risus. In mi pede, nonummy ut, molestie in, tempus eu, ligula. Aenean euismod mauris eu elit. Nulla facilisi. Sed neque. Sed eget lacus. Mauris non dui nec urna suscipit nonummy.',3392,381,16);
361INSERT INTO product (id,name,description,stock,price,model_id) VALUES (11,'Palmer','Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Phasellus ornare. Fusce mollis. Duis sit amet diam eu dolor egestas rhoncus. Proin nisl sem, consequat nec, mollis vitae, posuere at, velit. Cras lorem lorem, luctus ut, pellentesque eget, dictum placerat, augue. Sed molestie. Sed id risus quis diam luctus lobortis. Class aptent taciti sociosqu ad litora torquent per',5549,456,1);
362INSERT INTO product (id,name,description,stock,price,model_id) VALUES (12,'Keaton','feugiat nec, diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis eget, ipsum. Donec sollicitudin adipiscing ligula. Aenean gravida nunc sed pede. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel arcu eu odio tristique pharetra. Quisque ac libero nec ligula consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales at, velit. Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus euismod urna. Nullam lobortis quam a felis ullamcorper viverra. Maecenas iaculis aliquet diam. Sed diam lorem, auctor quis, tristique ac, eleifend',7289,885,8);
363INSERT INTO product (id,name,description,stock,price,model_id) VALUES (13,'Hiram','odio vel est tempor bibendum. Donec felis orci, adipiscing non, luctus sit amet, faucibus ut, nulla. Cras eu tellus eu augue porttitor interdum. Sed auctor odio a purus. Duis elementum, dui quis accumsan convallis, ante lectus convallis est, vitae sodales nisi magna sed dui. Fusce aliquam, enim nec tempus scelerisque, lorem ipsum sodales purus, in molestie tortor nibh sit amet orci. Ut sagittis lobortis mauris. Suspendisse aliquet molestie tellus. Aenean',2127,165,1);
364INSERT INTO product (id,name,description,stock,price,model_id) VALUES (14,'Calvin','Nulla eget metus eu erat semper rutrum. Fusce dolor quam, elementum at, egestas a, scelerisque sed, sapien. Nunc pulvinar arcu et pede. Nunc sed orci lobortis augue scelerisque mollis. Phasellus libero mauris, aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus dapibus quam quis diam. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Fusce aliquet magna a neque. Nullam ut nisi a odio semper cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis odio. Nam interdum enim',4332,1168,17);
365INSERT INTO product (id,name,description,stock,price,model_id) VALUES (15,'Kevin','enim commodo hendrerit. Donec porttitor tellus non magna. Nam ligula elit, pretium et, rutrum non, hendrerit id, ante. Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent interdum ligula eu enim. Etiam imperdiet dictum magna. Ut tincidunt orci quis lectus. Nullam suscipit, est ac facilisis facilisis, magna tellus',1004,905,10);
366INSERT INTO product (id,name,description,stock,price,model_id) VALUES (16,'Zane','neque. Morbi quis urna. Nunc quis arcu vel quam dignissim pharetra. Nam ac nulla. In tincidunt congue turpis. In condimentum. Donec at arcu. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla vulputate dui, nec tempus mauris erat eget ipsum. Suspendisse',3025,1037,19);
367INSERT INTO product (id,name,description,stock,price,model_id) VALUES (17,'Alan','in consectetuer ipsum nunc id enim. Curabitur massa. Vestibulum accumsan neque et nunc. Quisque ornare tortor at risus. Nunc ac sem ut dolor dapibus gravida. Aliquam tincidunt, nunc ac mattis ornare, lectus ante dictum mi, ac mattis velit justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc sollicitudin commodo ipsum. Suspendisse non leo. Vivamus nibh dolor, nonummy ac, feugiat non, lobortis quis, pede. Suspendisse dui. Fusce diam nunc, ullamcorper eu, euismod ac, fermentum vel, mauris. Integer sem elit, pharetra',4143,496,1);
368INSERT INTO product (id,name,description,stock,price,model_id) VALUES (18,'Merritt','quam. Curabitur vel lectus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec dignissim magna a tortor. Nunc commodo auctor velit. Aliquam nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus rhoncus. Donec est. Nunc ullamcorper, velit in aliquet lobortis, nisi nibh lacinia orci, consectetuer euismod est arcu ac orci. Ut semper pretium neque. Morbi quis urna. Nunc quis',4982,1161,12);
369INSERT INTO product (id,name,description,stock,price,model_id) VALUES (19,'Quamar','egestas hendrerit neque. In ornare sagittis felis. Donec tempor, est ac mattis semper, dui lectus rutrum urna, nec luctus felis purus ac tellus. Suspendisse sed dolor. Fusce mi lorem, vehicula et, rutrum eu, ultrices sit amet, risus. Donec nibh enim, gravida sit amet, dapibus id, blandit at, nisi. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel nisl. Quisque fringilla euismod enim. Etiam gravida molestie arcu. Sed eu nibh vulputate mauris sagittis placerat. Cras dictum ultricies ligula. Nullam',4509,21,4);
370INSERT INTO product (id,name,description,stock,price,model_id) VALUES (20,'Hamilton','ut lacus. Nulla tincidunt, neque vitae semper egestas, urna justo faucibus lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend. Cras sed leo. Cras vehicula aliquet libero. Integer in magna. Phasellus dolor elit, pellentesque a, facilisis non, bibendum sed, est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque sed dictum eleifend, nunc risus varius orci, in consequat enim diam vel arcu. Curabitur ut odio vel est tempor bibendum. Donec felis orci, adipiscing non, luctus sit amet, faucibus ut, nulla. Cras eu tellus',737,134,12);
371
372INSERT INTO product_category (id,name) VALUES (1,'Computers');
373INSERT INTO product_category (id,name) VALUES (2,'Accessories');
374INSERT INTO product_category (id,name) VALUES (3,'Mobile');
375INSERT INTO product_category (id,name) VALUES (4,'Consoles');
376INSERT INTO product_category (id,name) VALUES (5,'Components');
377
378INSERT INTO product_order (id_product,id_order) VALUES (6,8);
379INSERT INTO product_order (id_product,id_order) VALUES (20,6);
380INSERT INTO product_order (id_product,id_order) VALUES (7,1);
381INSERT INTO product_order (id_product,id_order) VALUES (7,17);
382INSERT INTO product_order (id_product,id_order) VALUES (18,10);
383INSERT INTO product_order (id_product,id_order) VALUES (14,13);
384INSERT INTO product_order (id_product,id_order) VALUES (12,11);
385INSERT INTO product_order (id_product,id_order) VALUES (9,8);
386INSERT INTO product_order (id_product,id_order) VALUES (17,7);
387INSERT INTO product_order (id_product,id_order) VALUES (19,6);
388INSERT INTO product_order (id_product,id_order) VALUES (4,15);
389INSERT INTO product_order (id_product,id_order) VALUES (13,17);
390INSERT INTO product_order (id_product,id_order) VALUES (12,1);
391INSERT INTO product_order (id_product,id_order) VALUES (18,19);
392INSERT INTO product_order (id_product,id_order) VALUES (15,9);
393INSERT INTO product_order (id_product,id_order) VALUES (12,7);
394INSERT INTO product_order (id_product,id_order) VALUES (5,20);
395INSERT INTO product_order (id_product,id_order) VALUES (14,14);
396INSERT INTO product_order (id_product,id_order) VALUES (8,15);
397INSERT INTO product_order (id_product,id_order) VALUES (15,4);
398
399INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (1,5,'tempor augue ac ipsum. Phasellus vitae mauris','25/08/2018',6,4);
400INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (2,1,'eget, dictum placerat, augue. Sed molestie. Sed id risus quis diam','02/12/2017',11,10);
401INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (3,1,'Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus euismod urna. Nullam lobortis quam a felis ullamcorper viverra. Maecenas iaculis','21/08/2018',12,3);
402INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (4,3,'Cras vehicula aliquet libero. Integer in magna. Phasellus dolor elit, pellentesque a, facilisis non, bibendum sed, est. Nunc laoreet lectus','13/03/2018',8,14);
403INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (5,5,'hendrerit. Donec','11/11/2017',16,12);
404INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (6,5,'ante. Vivamus non lorem vitae odio sagittis semper. Nam tempor diam dictum sapien. Aenean massa. Integer vitae','31/07/2017',17,16);
405INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (7,4,'sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque.','02/08/2017',19,20);
406INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (8,3,'placerat','16/08/2017',4,12);
407INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (9,4,'sem mollis dui, in sodales elit erat vitae risus.','06/09/2017',20,1);
408INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (10,1,'purus. Maecenas libero est, congue a, aliquet vel, vulputate eu,','13/03/2019',16,9);
409INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (11,5,'lorem ut aliquam iaculis, lacus pede sagittis augue, eu tempor erat neque non quam. Pellentesque','22/02/2019',10,4);
410INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (12,5,'mauris id sapien. Cras dolor dolor, tempus non, lacinia at, iaculis quis, pede. Praesent eu dui. Cum sociis natoque penatibus et magnis','15/07/2018',3,10);
411INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (13,3,'vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla','18/08/2018',2,3);
412INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (14,4,'urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla dignissim. Maecenas ornare egestas ligula. Nullam','28/07/2017',19,7);
413INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (15,2,'arcu et pede. Nunc sed orci lobortis augue scelerisque mollis. Phasellus libero mauris, aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus dapibus quam quis diam.','30/06/2018',13,12);
414INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (16,5,'non arcu. Vivamus sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras','13/10/2018',7,12);
415INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (17,3,'cubilia Curae; Donec tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit','23/06/2018',17,3);
416INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (18,2,'vitae, orci. Phasellus dapibus quam quis diam. Pellentesque','29/06/2017',9,10);
417INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (19,3,'accumsan neque et nunc. Quisque ornare tortor at risus. Nunc ac sem ut dolor dapibus','16/11/2017',14,19);
418INSERT INTO review (id,score,comment,date,id_product,id_user) VALUES (20,4,'ligula consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales at,','03/03/2019',18,6);
419
420INSERT INTO single_category (id_product,id_product_category) VALUES (1,1);
421INSERT INTO single_category (id_product,id_product_category) VALUES (2,2);
422INSERT INTO single_category (id_product,id_product_category) VALUES (3,3);
423INSERT INTO single_category (id_product,id_product_category) VALUES (4,2);
424INSERT INTO single_category (id_product,id_product_category) VALUES (5,1);
425INSERT INTO single_category (id_product,id_product_category) VALUES (6,3);
426INSERT INTO single_category (id_product,id_product_category) VALUES (7,4);
427INSERT INTO single_category (id_product,id_product_category) VALUES (8,5);
428INSERT INTO single_category (id_product,id_product_category) VALUES (9,4);
429INSERT INTO single_category (id_product,id_product_category) VALUES (10,5);
430INSERT INTO single_category (id_product,id_product_category) VALUES (11,1);
431INSERT INTO single_category (id_product,id_product_category) VALUES (12,2);
432INSERT INTO single_category (id_product,id_product_category) VALUES (13,4);
433INSERT INTO single_category (id_product,id_product_category) VALUES (14,4);
434INSERT INTO single_category (id_product,id_product_category) VALUES (15,4);
435INSERT INTO single_category (id_product,id_product_category) VALUES (16,2);
436INSERT INTO single_category (id_product,id_product_category) VALUES (17,1);
437INSERT INTO single_category (id_product,id_product_category) VALUES (18,2);
438INSERT INTO single_category (id_product,id_product_category) VALUES (19,2);
439INSERT INTO single_category (id_product,id_product_category) VALUES (20,3);
440
441INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (1,'vel.est.tempor@erat.org','Geoffrey Keith','PDB77ZTR5OS','Ap #894-4328 Erat Road','Raiganj','Admin ');
442INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (2,'egestas@nisl.co.uk','Rama Browning','HSY38MXX8ME','P.O. Box 369, 4403 Massa Avenue','Chapadinha',' User');
443INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (3,'lobortis.quis.pede@Vivamusrhoncus.net','Olivia Brennan','MOX89EFA0DU','Ap #624-5071 At, Ave','Oostakker',' User');
444INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (4,'Nulla.facilisi@semeget.org','Charity Livingston','QYA36FRM1NX','9785 Neque St.','Ambala Sadar','Admin ');
445INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (5,'nisi@Duiscursus.com','Levi Cervantes','XNW95ZQW9TY','Ap #722-1022 Odio St.','Maria',' User');
446INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (6,'egestas@diam.edu','Quinn Barnes','IBH69AXY9UU','Ap #515-4663 Nulla Street','Melsele','Admin ');
447INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (7,'primis@Integervulputaterisus.com','Xenos Osborn','GMT03GML0QV','P.O. Box 893, 1360 Magna. Ave','Fayetteville',' User');
448INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (8,'feugiat@pedeSuspendisse.com','Cole Tyson','ONK78OZF8JP','202-214 Lorem Ave','Montpellier','Admin ');
449INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (9,'elit.dictum.eu@eget.net','Desirae Vazquez','TGT94CGV0GO','P.O. Box 989, 6124 Mi Avenue','Qualicum Beach',' User');
450INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (10,'mus.Aenean@velitinaliquet.edu','Xandra Drake','YUT64SMA0OL','6876 Justo Rd.','Musselburgh',' User');
451INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (11,'nibh.vulputate@est.com','Isaac Dillard','SDJ96YDP4PD','Ap #123-9516 Augue. St.','Ramsel','Admin ');
452INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (12,'fringilla.purus.mauris@anequeNullam.org','Hayes Mcpherson','SJG98OFJ0XY','2765 Mi Rd.','Hawick','Admin ');
453INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (13,'Suspendisse.aliquet.molestie@atvelit.com','Sydney Mcfadden','QQO20CHT9RF','9359 Lorem Av.','Richmond','Admin ');
454INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (14,'risus.Nunc@semutcursus.co.uk','Kaseem Holman','CYZ17ZTS8LO','P.O. Box 464, 9581 Sem Av.','Fort Smith',' User');
455INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (15,'scelerisque.lorem.ipsum@Maurisquisturpis.org','Tatum Simpson','SHD63JUZ3FH','3972 Sit Rd.','Salem','Admin ');
456INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (16,'nostra@ultricesVivamusrhoncus.com','Adara Frazier','VBD69BIR9VV','Ap #667-4458 Mauris Rd.','Recogne',' User');
457INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (17,'semper@penatibusetmagnis.edu','Ciaran Singleton','FBI41SUB4DT','Ap #147-4425 Velit Ave','San Juan de la Costa','Admin ');
458INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (18,'Morbi.metus.Vivamus@faucibusleo.edu','Sloane Hatfield','JPG58FMP5HH','P.O. Box 882, 3276 Nunc Ave','Cañete',' User');
459INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (19,'mollis.nec.cursus@ultrices.edu','Zachary Love','WXF13ZUT7RV','P.O. Box 790, 9016 Vitae Ave','Purnea','Admin ');
460INSERT INTO "user" (id,email,name,password,address,city,permissions) VALUES (20,'eu@auctor.ca','Tashya Irwin','GBU93BOO1SH','212-7102 Risus. Av.','Águas Lindas de Goiás','Admin ');
461
462INSERT INTO "history_product" (id,date,description,price) VALUES (1,'12/10/2018','egestas, urna justo faucibus lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend. Cras sed leo. Cras vehicula aliquet libero. Integer in magna. Phasellus dolor elit, pellentesque a, facilisis non, bibendum sed, est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque sed dictum eleifend, nunc risus varius orci, in consequat enim diam vel arcu. Curabitur ut odio vel est tempor bibendum. Donec felis orci, adipiscing non, luctus sit amet, faucibus ut, nulla. Cras eu tellus eu augue porttitor interdum. Sed auctor odio a purus. Duis',1083);
463INSERT INTO "history_product" (id,date,description,price) VALUES (2,'13/03/2018','ultrices, mauris ipsum porta elit, a feugiat tellus lorem eu metus. In lorem. Donec elementum, lorem ut aliquam iaculis, lacus pede sagittis augue, eu tempor erat neque non quam. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam fringilla cursus purus. Nullam scelerisque neque sed sem egestas blandit. Nam nulla magna, malesuada vel, convallis in, cursus et, eros. Proin ultrices. Duis volutpat nunc sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer vulputate, risus a ultricies adipiscing, enim',453);
464INSERT INTO "history_product" (id,date,description,price) VALUES (3,'15/11/2018','egestas hendrerit neque. In ornare sagittis felis. Donec tempor, est ac mattis semper, dui lectus rutrum urna, nec luctus felis purus ac tellus. Suspendisse sed dolor. Fusce mi lorem, vehicula et, rutrum eu, ultrices sit amet, risus. Donec nibh enim, gravida sit amet, dapibus id, blandit at, nisi. Cum sociis natoque penatibus et magnis dis parturient',997);
465INSERT INTO "history_product" (id,date,description,price) VALUES (4,'27/07/2017','erat nonummy ultricies ornare, elit elit fermentum risus, at fringilla purus mauris a nunc. In at pede. Cras vulputate velit eu sem. Pellentesque ut ipsum ac mi eleifend egestas. Sed pharetra, felis eget varius ultrices, mauris ipsum porta elit, a feugiat tellus lorem eu metus. In lorem. Donec elementum, lorem ut aliquam iaculis, lacus pede sagittis augue,',232);
466INSERT INTO "history_product" (id,date,description,price) VALUES (5,'08/04/2018','elit, a feugiat tellus lorem eu metus. In lorem. Donec elementum, lorem ut aliquam iaculis, lacus pede sagittis augue, eu tempor erat neque non quam. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam fringilla cursus purus. Nullam scelerisque neque sed sem egestas blandit. Nam nulla magna, malesuada vel, convallis in, cursus et, eros. Proin ultrices. Duis volutpat nunc',420);
467INSERT INTO "history_product" (id,date,description,price) VALUES (6,'18/04/2017','Quisque ac libero nec ligula consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales at, velit. Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus euismod urna. Nullam lobortis quam a felis ullamcorper viverra. Maecenas iaculis aliquet diam. Sed diam lorem, auctor quis, tristique ac, eleifend vitae, erat. Vivamus nisi. Mauris nulla. Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla dignissim. Maecenas ornare egestas',501);
468INSERT INTO "history_product" (id,date,description,price) VALUES (7,'03/11/2017','magna sed dui. Fusce aliquam, enim nec tempus scelerisque, lorem ipsum sodales purus, in molestie tortor nibh sit amet orci. Ut sagittis lobortis mauris. Suspendisse aliquet molestie tellus. Aenean egestas hendrerit neque. In ornare sagittis felis. Donec tempor, est ac mattis semper, dui lectus rutrum urna, nec luctus felis purus ac tellus. Suspendisse sed dolor. Fusce mi lorem, vehicula et, rutrum eu, ultrices sit amet, risus. Donec nibh enim, gravida sit amet, dapibus id, blandit at, nisi. Cum sociis natoque penatibus et magnis dis',678);
469INSERT INTO "history_product" (id,date,description,price) VALUES (8,'07/06/2018','parturient montes, nascetur ridiculus mus. Aenean eget magna. Suspendisse tristique neque venenatis lacus. Etiam bibendum fermentum metus. Aenean sed pede nec ante blandit viverra. Donec tempus, lorem fringilla ornare placerat, orci lacus vestibulum lorem, sit amet ultricies sem magna nec quam. Curabitur vel lectus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec dignissim magna a tortor. Nunc commodo auctor velit. Aliquam nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus rhoncus.',901);
470INSERT INTO "history_product" (id,date,description,price) VALUES (9,'26/08/2018','vitae purus gravida sagittis. Duis gravida. Praesent eu nulla at sem molestie sodales. Mauris blandit enim consequat purus. Maecenas libero est, congue a, aliquet vel, vulputate eu, odio. Phasellus at augue id ante dictum cursus. Nunc mauris elit, dictum eu, eleifend nec, malesuada ut, sem. Nulla interdum. Curabitur dictum. Phasellus in felis. Nulla tempor augue ac ipsum. Phasellus vitae mauris sit amet lorem semper auctor. Mauris vel turpis. Aliquam adipiscing lobortis risus. In mi pede, nonummy ut, molestie in, tempus eu, ligula. Aenean euismod mauris eu elit. Nulla facilisi. Sed neque. Sed eget lacus. Mauris non dui nec',925);
471INSERT INTO "history_product" (id,date,description,price) VALUES (10,'22/07/2017','sit amet ornare lectus justo eu arcu. Morbi sit amet massa. Quisque porttitor eros nec tellus. Nunc lectus pede, ultrices a, auctor non, feugiat nec, diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis eget, ipsum. Donec sollicitudin adipiscing ligula. Aenean gravida nunc sed pede. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel arcu eu odio tristique pharetra. Quisque ac libero nec ligula consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales',846);
472INSERT INTO "history_product" (id,date,description,price) VALUES (11,'29/06/2017','ornare, libero at auctor ullamcorper, nisl arcu iaculis enim, sit amet ornare lectus justo eu arcu. Morbi sit amet massa. Quisque porttitor eros nec tellus. Nunc lectus pede, ultrices a, auctor non, feugiat nec, diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis eget, ipsum. Donec sollicitudin adipiscing ligula. Aenean gravida nunc sed pede. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel arcu eu odio tristique pharetra. Quisque ac libero nec ligula consectetuer rhoncus.',64);
473INSERT INTO "history_product" (id,date,description,price) VALUES (12,'18/03/2019','est ac facilisis facilisis, magna tellus faucibus leo, in lobortis tellus justo sit amet nulla. Donec non justo. Proin non massa non ante bibendum ullamcorper. Duis cursus, diam at pretium aliquet, metus urna convallis erat, eget tincidunt dui augue eu tellus. Phasellus elit pede, malesuada vel, venenatis vel, faucibus id, libero. Donec consectetuer mauris id sapien. Cras dolor dolor, tempus non, lacinia at, iaculis quis, pede. Praesent eu dui. Cum sociis natoque penatibus',305);
474INSERT INTO "history_product" (id,date,description,price) VALUES (13,'26/01/2019','Donec non justo. Proin non massa non ante bibendum ullamcorper. Duis cursus, diam at pretium aliquet, metus urna convallis erat, eget tincidunt dui augue eu tellus. Phasellus elit pede, malesuada vel, venenatis vel, faucibus id, libero. Donec consectetuer mauris id sapien. Cras dolor dolor, tempus non, lacinia at, iaculis quis, pede. Praesent eu dui. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aenean eget magna. Suspendisse tristique neque venenatis lacus. Etiam bibendum fermentum metus. Aenean sed pede nec ante blandit viverra. Donec tempus,',1292);
475INSERT INTO "history_product" (id,date,description,price) VALUES (14,'04/10/2017','metus facilisis lorem tristique aliquet. Phasellus fermentum convallis ligula. Donec luctus aliquet odio. Etiam ligula tortor, dictum eu, placerat eget, venenatis a, magna. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Etiam laoreet, libero et tristique pellentesque, tellus sem mollis dui, in sodales elit erat vitae risus. Duis a mi fringilla mi lacinia mattis. Integer eu',966);
476INSERT INTO "history_product" (id,date,description,price) VALUES (15,'29/08/2017','Quisque purus sapien, gravida non, sollicitudin a, malesuada id, erat. Etiam vestibulum massa rutrum magna. Cras convallis convallis dolor. Quisque tincidunt pede ac urna. Ut tincidunt vehicula risus. Nulla eget metus eu erat semper rutrum. Fusce dolor quam, elementum at, egestas a, scelerisque sed, sapien. Nunc pulvinar arcu et pede. Nunc sed orci lobortis augue scelerisque mollis. Phasellus libero mauris, aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus dapibus quam',64);
477INSERT INTO "history_product" (id,date,description,price) VALUES (16,'19/12/2018','erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper magna. Sed eu eros. Nam consequat dolor vitae dolor. Donec fringilla. Donec feugiat metus sit amet ante. Vivamus non lorem vitae odio sagittis semper. Nam tempor diam dictum sapien. Aenean massa. Integer vitae nibh. Donec est mauris, rhoncus id, mollis nec, cursus a, enim. Suspendisse aliquet, sem ut cursus luctus, ipsum leo elementum sem, vitae aliquam eros turpis non enim. Mauris quis turpis',925);
478INSERT INTO "history_product" (id,date,description,price) VALUES (17,'04/09/2017','fermentum risus, at fringilla purus mauris a nunc. In at pede. Cras vulputate velit eu sem. Pellentesque ut ipsum ac mi eleifend egestas. Sed pharetra, felis eget varius ultrices, mauris ipsum porta elit, a feugiat tellus lorem eu metus. In lorem. Donec elementum, lorem ut aliquam iaculis, lacus pede sagittis augue, eu tempor erat neque non quam. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam fringilla cursus purus. Nullam scelerisque neque sed sem egestas blandit. Nam nulla magna, malesuada vel, convallis in, cursus et, eros. Proin ultrices. Duis volutpat nunc sit amet metus. Aliquam',225);
479INSERT INTO "history_product" (id,date,description,price) VALUES (18,'07/04/2017','aliquam arcu. Aliquam ultrices iaculis odio. Nam interdum enim non nisi. Aenean eget metus. In nec orci. Donec nibh. Quisque nonummy ipsum non arcu. Vivamus sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper magna.',812);
480INSERT INTO "history_product" (id,date,description,price) VALUES (19,'15/11/2018','tincidunt congue turpis. In condimentum. Donec at arcu. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla vulputate dui, nec tempus',647);
481INSERT INTO "history_product" (id,date,description,price) VALUES (20,'28/05/2018','nascetur ridiculus mus. Donec dignissim magna a tortor. Nunc commodo auctor velit. Aliquam nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus rhoncus. Donec est. Nunc ullamcorper, velit in aliquet lobortis, nisi nibh lacinia orci, consectetuer euismod est arcu ac orci. Ut semper pretium neque. Morbi quis urna. Nunc quis arcu vel quam dignissim pharetra. Nam ac nulla. In tincidunt congue turpis. In condimentum. Donec at arcu. Vestibulum ante ipsum',224);
482
483INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (1,7);
484INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (2,5);
485INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (3,10);
486INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (4,18);
487INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (5,20);
488INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (6,13);
489INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (7,2);
490INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (8,1);
491INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (9,13);
492INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (10,1);
493INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (11,10);
494INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (12,12);
495INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (13,9);
496INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (14,6);
497INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (15,7);
498INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (16,13);
499INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (17,12);
500INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (18,6);
501INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (19,13);
502INSERT INTO "single_history_product" (id_history_product,id_product) VALUES (20,4);
503
504INSERT INTO "featured_product" (id,date) VALUES (1,'12/01/2018');
505INSERT INTO "featured_product" (id,date) VALUES (2,'08/10/2018');
506INSERT INTO "featured_product" (id,date) VALUES (3,'09/11/2018');
507INSERT INTO "featured_product" (id,date) VALUES (4,'23/08/2018');
508
509INSERT INTO "single_featured_product" (id_product,id_featured_product) VALUES (16,1);
510INSERT INTO "single_featured_product" (id_product,id_featured_product) VALUES (7,2);
511INSERT INTO "single_featured_product" (id_product,id_featured_product) VALUES (6,3);
512INSERT INTO "single_featured_product" (id_product,id_featured_product) VALUES (2,4);