1T0CeY22

1-----------------------------------------
2-- Drop old schmema
3-----------------------------------------
4
5DROP TABLE IF EXISTS "user" CASCADE;
6DROP TABLE IF EXISTS "admin" CASCADE;
7DROP TABLE IF EXISTS "member" CASCADE;
8DROP TABLE IF EXISTS author CASCADE;
9DROP TABLE IF EXISTS cart CASCADE;
10DROP TABLE IF EXISTS category CASCADE;
11DROP TABLE IF EXISTS genre CASCADE;
12DROP TABLE IF EXISTS city CASCADE;
13DROP TABLE IF EXISTS country CASCADE;
14DROP TABLE IF EXISTS item CASCADE;
15DROP TABLE IF EXISTS "order" CASCADE;
16DROP TABLE IF EXISTS seller CASCADE;
17DROP TABLE IF EXISTS buyer CASCADE;
18DROP TABLE IF EXISTS ban CASCADE;
19DROP TABLE IF EXISTS banned CASCADE;
20DROP TABLE IF EXISTS book CASCADE;
21DROP TABLE IF EXISTS belongs_c CASCADE;
22DROP TABLE IF EXISTS belongs_g CASCADE;
23DROP TABLE IF EXISTS buys_to CASCADE;
24DROP TABLE IF EXISTS item_cart CASCADE;
25DROP TABLE IF EXISTS written CASCADE;
26DROP TABLE IF EXISTS password_resets CASCADE;
27
28DROP TYPE IF EXISTS genres CASCADE;
29DROP TYPE IF EXISTS categories CASCADE;
30DROP TYPE IF EXISTS status CASCADE;
31
32DROP DOMAIN IF EXISTS Today CASCADE;
33
34DROP FUNCTION IF EXISTS item_on_cart() CASCADE;
35DROP FUNCTION IF EXISTS user_member() CASCADE;
36DROP FUNCTION IF EXISTS check_if_banned() CASCADE;
37DROP FUNCTION IF EXISTS add_to_cart_price() CASCADE;
38DROP FUNCTION IF EXISTS remove_from_cart_price() CASCADE;
39DROP FUNCTION IF EXISTS unban() CASCADE;
40DROP FUNCTION IF EXISTS user_admin() CASCADE;
41
42DROP TRIGGER IF EXISTS item_on_cart ON cart;
43DROP TRIGGER IF EXISTS user_member ON member;
44DROP TRIGGER IF EXISTS unban ON ban;
45DROP TRIGGER IF EXISTS check_if_banned ON "user";
46DROP TRIGGER IF EXISTS add_on_cart on item_cart;
47DROP TRIGGER IF EXISTS remove_from_cart on item_cart;
48DROP TRIGGER IF EXISTS unban on ban;
49DROP TRIGGER IF EXISTS user_admin on "admin";
50
51-----------------------------------------
52-- Types
53-----------------------------------------
54
55CREATE TYPE genres AS ENUM ('Arts & Music', 'Biographies', 'Business', 'Kids', 'Comics', 'Computers & Tech', 'Cooking', 'Hoobies & Crafts', 'Edu & Reference', 'Gay & Lesbian', 'Health & Fitness', 'History', 'Home & Garden', 'Horror', 'Entertainment', 'Literature & Fiction', 'Medical', 'Mysteries', 'Parenting', 'Social Sciences', 'Religion', 'Romance', 'Science & Maths', 'Sci-Fi & Fantasy', 'Self-Help', 'Sports', 'Teen', 'Travel', 'True Crime', 'Westerns');
56CREATE TYPE categories AS ENUM ('Children','Best-Sellers', 'Most-Searched', 'New-In', 'Classics');
57CREATE TYPE status AS ENUM ('New', 'Hold', 'Shipped', 'Delivered', 'Closed');
58
59-----------------------------------------
60-- Domains
61-----------------------------------------
62
63CREATE DOMAIN Today AS DATE NOT NULL DEFAULT ('now'::text)::date;
64
65-----------------------------------------
66-- Tables
67-----------------------------------------
68CREATE TABLE country (
69	id SERIAL PRIMARY KEY,
70	country text NOT NULL
71);
72
73CREATE TABLE city (
74	id SERIAL PRIMARY KEY,
75	id_country INTEGER REFERENCES country (id) ON UPDATE CASCADE ON DELETE CASCADE,
76	city text NOT NULL
77);
78
79CREATE TABLE "user" (
80    id SERIAL PRIMARY KEY,
81	id_city INTEGER REFERENCES city (id) ON UPDATE CASCADE ON DELETE CASCADE,
82	username text NOT NULL UNIQUE,
83	first_name text NOT NULL,
84	last_name text NOT NULL,
85	email text NOT NULL UNIQUE,
86	"password" text NOT NULL,
87	"address" text,
88	zipcode text,
89	date_of_birth TIMESTAMP WITH TIME zone,
90    date_of_registration TIMESTAMP WITH TIME zone DEFAULT now() NOT NULL,
91	profile_picture text,
92	remember_token VARCHAR
93);
94
95CREATE TABLE "admin" (
96	id_user INTEGER REFERENCES "user" (id) ON UPDATE CASCADE ON DELETE CASCADE,
97	PRIMARY KEY(id_user)
98);
99
100CREATE TABLE "member" (
101	id_user INTEGER REFERENCES "user" (id) ON UPDATE CASCADE ON DELETE CASCADE,
102	PRIMARY KEY(id_user)
103);
104
105CREATE TABLE seller (
106	id_member INTEGER REFERENCES "member" (id_user) ON UPDATE CASCADE ON DELETE CASCADE,
107	iban text NOT NULL,
108	PRIMARY	KEY(id_member)
109);
110
111CREATE TABLE buyer(
112	id_member INTEGER REFERENCES "member" (id_user) ON UPDATE CASCADE ON DELETE CASCADE,
113	PRIMARY KEY(id_member)
114);
115
116CREATE TABLE author (
117	id SERIAL PRIMARY KEY,
118	"name" text NOT NULL,
119	"date" TIMESTAMP WITH TIME zone,
120	id_country INTEGER REFERENCES country (id) ON UPDATE CASCADE ON DELETE CASCADE,
121	biography text
122);
123
124CREATE TABLE cart (
125	id SERIAL PRIMARY KEY,
126	id_member INTEGER REFERENCES "member" (id_user) ON UPDATE CASCADE ON DELETE CASCADE,
127	total_price NUMERIC
128);
129
130CREATE TABLE category (
131	id SERIAL PRIMARY KEY,
132	TYPE categories NOT NULL
133);
134
135CREATE TABLE genre (
136	id SERIAL PRIMARY KEY,
137	TYPE genres NOT NULL
138);
139
140CREATE TABLE book (
141	id SERIAL PRIMARY KEY,
142	isbn text NOT NULL,
143	title text NOT NULL,
144	photo text,
145	description text,
146	publication_date date,
147	rating INTEGER,
148	language text,
149	publisher text,
150	CONSTRAINT date_ck CHECK (publication_date < now()),
151	CONSTRAINT rating_ck CHECK ((rating > 0) AND (rating <= 5))
152);
153
154CREATE TABLE item (
155	id SERIAL PRIMARY KEY,
156	id_book INTEGER REFERENCES book (id) ON UPDATE CASCADE ON DELETE CASCADE,
157	id_seller INTEGER REFERENCES seller (id_member) ON UPDATE CASCADE ON DELETE CASCADE,
158	price NUMERIC NOT NULL,
159	quality text,
160	CONSTRAINT price_ck CHECK (price > 0)
161);
162
163CREATE TABLE "order" (
164	id SERIAL PRIMARY KEY,
165	id_buyer INTEGER REFERENCES buyer (id_member) ON UPDATE CASCADE ON DELETE CASCADE,
166	id_book INTEGER REFERENCES book (id),
167	TYPE status NOT NULL,
168	price numeric NOT NULL,
169	CONSTRAINT price_ck CHECK (price > 0)
170);
171
172CREATE TABLE ban (
173	id SERIAL,
174	id_admin INTEGER REFERENCES "admin" (id_user) ON UPDATE CASCADE ON DELETE CASCADE,
175	id_banned INTEGER REFERENCES "member" (id_user) ON UPDATE CASCADE ON DELETE CASCADE,
176	start_date TIMESTAMP WITH TIME zone DEFAULT now() NOT NULL,
177	end_date TIMESTAMP WITH TIME zone DEFAULT now() NOT NULL,
178	reason text NOT NULL,
179	CONSTRAINT dates CHECK (end_date > start_date),
180	PRIMARY KEY(id, id_banned)
181);
182
183CREATE TABLE banned (
184	id_member INTEGER REFERENCES "member" (id_user) ON UPDATE CASCADE ON DELETE CASCADE,
185	PRIMARY KEY(id_member)
186);
187
188CREATE TABLE belongs_c (
189	id_book INTEGER REFERENCES book (id) ON UPDATE CASCADE ON DELETE CASCADE,
190	id_category INTEGER REFERENCES category (id) ON UPDATE CASCADE ON DELETE CASCADE,
191	PRIMARY KEY(id_book, id_category)
192);
193
194CREATE TABLE belongs_g (
195	id SERIAL PRIMARY KEY,
196	id_book INTEGER REFERENCES book (id) ON UPDATE CASCADE ON DELETE CASCADE,
197	id_genre INTEGER REFERENCES genre (id) ON UPDATE CASCADE ON DELETE CASCADE
198);
199
200CREATE TABLE buys_to(
201	id_seller INTEGER REFERENCES seller (id_member) ON UPDATE CASCADE ON DELETE CASCADE,
202	id_buyer INTEGER REFERENCES buyer (id_member) ON UPDATE CASCADE ON DELETE CASCADE,
203	PRIMARY KEY(id_seller, id_buyer)
204);
205
206CREATE TABLE item_cart(
207	id SERIAL PRIMARY KEY,
208	id_item INTEGER REFERENCES item (id) ON UPDATE CASCADE ON DELETE CASCADE,
209	id_cart INTEGER REFERENCES cart (id) ON UPDATE CASCADE ON DELETE CASCADE
210);
211
212CREATE TABLE written(
213	id SERIAL PRIMARY KEY,
214	id_book INTEGER REFERENCES book (id) ON UPDATE CASCADE ON DELETE CASCADE,
215	id_author INTEGER REFERENCES author (id) ON UPDATE CASCADE ON DELETE CASCADE
216);
217
218CREATE TABLE password_resets (
219	email TEXT PRIMARY KEY,
220	token TEXT,
221	created_at TIMESTAMP WITH TIME zone
222);
223
224-----------------------------------------
225-- INDEXES
226-----------------------------------------
227
228CREATE INDEX item_title ON book USING GiST (to_tsvector('english', title || ' ' || description));
229
230CREATE INDEX book_title ON book USING hash (title);
231
232CREATE INDEX book_isbn ON book USING hash (isbn);
233
234CREATE INDEX category_item ON category USING hash (TYPE);
235
236CREATE INDEX genre_item ON genre USING hash (TYPE);
237
238CREATE INDEX price_item ON item USING btree (price);
239
240-----------------------------------------
241-- TRIGGERS and UDFs
242-----------------------------------------
243
244CREATE FUNCTION add_to_cart_price() RETURNS TRIGGER AS
245$BODY$
246BEGIN
247
248	UPDATE cart
249	SET total_price = (SELECT item.price FROM item WHERE NEW.id_item = item.id) + total_price
250	WHERE NEW.id_cart = cart.id;
251	
252	RETURN NEW;
253
254END
255$BODY$
256LANGUAGE plpgsql;
257
258CREATE TRIGGER add_on_cart
259    AFTER INSERT ON item_cart
260    FOR EACH ROW
261    EXECUTE PROCEDURE add_to_cart_price();
262
263
264
265
266
267
268CREATE FUNCTION remove_from_cart_price() RETURNS TRIGGER AS
269$BODY$
270BEGIN
271
272	UPDATE cart
273	SET total_price = total_price - (SELECT item.price FROM item WHERE OLD.id_item = item.id)
274	WHERE OLD.id_cart = cart.id;
275	
276	RETURN OLD;
277
278END
279$BODY$
280LANGUAGE plpgsql;
281
282CREATE TRIGGER remove_from_cart
283    AFTER DELETE ON item_cart
284    FOR EACH ROW
285    EXECUTE PROCEDURE remove_from_cart_price();
286
287
288
289-- CREATE FUNCTION item_on_cart() RETURNS TRIGGER AS
290-- $BODY$
291-- BEGIN
292--     IF EXISTS (SELECT *  FROM cart, item, item_cart, "user" WHERE NEW.id = item.id AND NEW.id = item_cart.id_item AND cart.id = item_cart.id_cart AND cart.id_member = "user".id) THEN        RAISE EXCEPTION 'An users item cannot be in his cart.';
293
294--     END IF;
295--     RETURN NEW;
296-- END
297-- $BODY$
298-- LANGUAGE plpgsql;
299
300-- CREATE TRIGGER item_on_cart
301--     BEFORE INSERT OR UPDATE ON cart
302--     FOR EACH ROW
303--     EXECUTE PROCEDURE item_on_cart();
304
305
306CREATE FUNCTION user_admin() RETURNS TRIGGER AS
307$BODY$
308BEGIN
309	DELETE FROM "member" WHERE id_user = NEW.id_user;
310	DELETE FROM "buyer" WHERE id_member = NEW.id_user;
311    DELETE FROM cart WHERE id_member = NEW.id_user;
312	RETURN NEW;
313	
314END 
315$BODY$
316LANGUAGE plpgsql;
317
318CREATE TRIGGER user_admin
319	AFTER INSERT ON "admin"
320	FOR EACH ROW
321	EXECUTE PROCEDURE user_admin();
322
323
324
325CREATE FUNCTION unban() RETURNS TRIGGER AS
326$BODY$
327BEGIN
328    DELETE FROM banned WHERE id_member = OLD.id_banned;
329	RETURN NEW;
330END
331$BODY$
332LANGUAGE plpgsql;
333
334CREATE TRIGGER unban
335    AFTER DELETE ON ban
336    FOR EACH ROW
337    EXECUTE PROCEDURE unban();
338
339
340CREATE FUNCTION user_member() RETURNS TRIGGER AS
341$BODY$
342BEGIN
343	INSERT INTO "member" (id_user) VALUES (NEW.id);
344    INSERT INTO buyer (id_member) VALUES (NEW.id);
345    INSERT INTO cart (id_member, total_price) VALUES (NEW.id, 0);
346
347	RETURN NEW;
348END
349$BODY$
350LANGUAGE plpgsql;
351
352CREATE TRIGGER user_member
353    AFTER INSERT ON "user"
354    FOR EACH ROW
355    EXECUTE PROCEDURE user_member();
356
357
358CREATE FUNCTION check_if_banned() RETURNS TRIGGER AS
359$BODY$
360BEGIN
361    IF NEW.email IN (SELECT "user".email AS Email FROM banned, member, "user" WHERE banned.id_member = member.id_user AND member.id_user = "user".id) THEN
362        RAISE EXCEPTION 'That email is associated with a banned account!';
363        END IF;
364        RETURN NEW;
365END
366$BODY$
367LANGUAGE plpgsql;
368
369CREATE TRIGGER check_if_banned
370    BEFORE INSERT ON "user"
371    FOR EACH ROW
372    EXECUTE PROCEDURE check_if_banned();
373
374-----------------------------------------
375-- end
376-----------------------------------------
377
378-----------------------------------------
379-- Populate the database
380-----------------------------------------
381
382
383-----------------------------------------
384-- Country
385-----------------------------------------
386INSERT INTO country (country) VALUES ('Greece');
387INSERT INTO country (country) VALUES ('Brazil');
388INSERT INTO country (country) VALUES ('United States');
389INSERT INTO country (country) VALUES ('France');
390INSERT INTO country (country) VALUES ('Portugal');
391INSERT INTO country (country) VALUES ('Nigeria');
392INSERT INTO country (country) VALUES ('Spain');
393INSERT INTO country (country) VALUES ('Netherlands');
394INSERT INTO country (country) VALUES ('Finland');
395INSERT INTO country (country) VALUES ('Germany');
396INSERT INTO country (country) VALUES ('Mexico');
397INSERT INTO country (country) VALUES ('Colombia');
398INSERT INTO country (country) VALUES ('Canada');
399INSERT INTO country (country) VALUES ('China');
400
401
402-----------------------------------------
403-- City
404-----------------------------------------
405INSERT INTO city (id_country, city) VALUES (1, 'Athens');
406INSERT INTO city (id_country, city) VALUES (2, 'São Paulo');
407INSERT INTO city (id_country, city) VALUES (3, 'Nebraska');
408INSERT INTO city (id_country, city) VALUES (3, 'Maine');
409INSERT INTO city (id_country, city) VALUES (3, 'South Carolina');
410INSERT INTO city (id_country, city) VALUES (7, 'Gawul');
411INSERT INTO city (id_country, city) VALUES (5, 'Trà My');
412INSERT INTO city (id_country, city) VALUES (6, 'Mikun’');
413INSERT INTO city (id_country, city) VALUES (7, 'Ambarita');
414INSERT INTO city (id_country, city) VALUES (4, 'Paris');
415INSERT INTO city (id_country, city) VALUES (5, 'Porto');
416INSERT INTO city (id_country, city) VALUES (6, 'Abuja');
417INSERT INTO city (id_country, city) VALUES (7, 'Madrid');
418INSERT INTO city (id_country, city) VALUES (8, 'Amsterdan');
419INSERT INTO city (id_country, city) VALUES (9, 'Helsinki');
420INSERT INTO city (id_country, city) VALUES (10, 'Berlin');
421INSERT INTO city (id_country, city) VALUES (11, 'Mexico City');
422INSERT INTO city (id_country, city) VALUES (12, 'Bogotá');
423INSERT INTO city (id_country, city) VALUES (13, 'Toronto');
424INSERT INTO city (id_country, city) VALUES (14, 'Xinzheng');
425
426
427-----------------------------------------
428-- User
429-----------------------------------------
430insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (3, 'kdavinet0', 'Karen', 'Davinet', 'kdavinet0@latimes.com', '$2y$10$HfzIhGCCaxqyaIdGgjARSuOKAcm1Uy82YfLuNaajn6JrjLWy9Sj/W', '7013 Londonderry Circle', '1150', '1948-08-24', '2019-04-30', 'http://dummyimage.com/216x236.png/cc0000/ffffff');
431insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (18, 'esudran1', 'Elisabetta', 'Sudran', 'esudran1@google.com.au', 'z6d0UQT', '7090 Coolidge Center', '394075', '1974-04-16', '2019-04-30', 'http://dummyimage.com/172x160.png/dddddd/000000');
432insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (16, 'gjinkins2', 'Gordie', 'Jinkins', 'gjinkins2@devhub.com', 'auvOPYh5uA', '4 Cherokee Lane', null, '1975-09-16', '2019-04-30', 'http://dummyimage.com/155x118.png/cc0000/ffffff');
433insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'lgutteridge3', 'Laurens', 'Gutteridge', 'lgutteridge3@house.gov', 'pfOnZqq6Yc9', '9 Quincy Place', '8301', '1964-04-04', '2019-04-30', 'http://dummyimage.com/120x119.png/ff4444/ffffff');
434insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (7, 'jhauxby4', 'Jameson', 'Hauxby', 'jhauxby4@symantec.com', 'ybIdSDwZ', '1817 Bartelt Circle', '393025', '1975-01-10', '2019-04-30', 'http://dummyimage.com/194x190.png/cc0000/ffffff');
435insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (2, 'koliverpaull5', 'Kelvin', 'Oliver-Paull', 'koliverpaull5@nationalgeographic.com', 'mtFObZamv3', '58705 Hansons Pass', '582 21', '1985-05-27', '2019-04-30', 'http://dummyimage.com/248x205.png/dddddd/000000');
436insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (19, 'dbroggio6', 'Donall', 'Broggio', 'dbroggio6@wikipedia.org', 'EBAILncyl', '158 Novick Parkway', '11204', '1969-06-11', '2019-04-30', 'http://dummyimage.com/172x180.png/5fa2dd/ffffff');
437insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (13, 'gromi7', 'Gert', 'Romi', 'gromi7@baidu.com', 'hjek2sdTtW', '24722 Jana Plaza', '2402', '1992-06-05', '2019-04-30', 'http://dummyimage.com/108x241.png/cc0000/ffffff');
438insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (18, 'jdunbobin8', 'Jeralee', 'Dunbobin', 'jdunbobin8@wired.com', 'v5ZbFta1', '6339 Heffernan Lane', null, '1979-06-10', '2019-04-30', 'http://dummyimage.com/116x197.png/dddddd/000000');
439insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'aasken9', 'Anabal', 'Asken', 'aasken9@unc.edu', 'WkQVhC', '65 Burning Wood Street', '3513', '1954-07-28', '2019-04-30', 'http://dummyimage.com/157x137.png/5fa2dd/ffffff');
440insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (9, 'eferrandeza', 'Ebonee', 'Ferrandez', 'eferrandeza@omniture.com', 'LSvNF0MuS', '3 Toban Lane', '10208', '1989-10-12', '2019-04-30', 'http://dummyimage.com/134x140.png/5fa2dd/ffffff');
441insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'cbonb', 'Cynde', 'Bon', 'cbonb@about.com', 'Iz5fyzgxd', '0383 Lakewood Way', '57000-000', '1975-12-20', '2019-04-30', 'http://dummyimage.com/136x241.png/ff4444/ffffff');
442insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (8, 'adewdneyc', 'Alastair', 'Dewdney', 'adewdneyc@vk.com', '9zZ98ES', '97316 Cherokee Drive', '588 33', '1972-12-24', '2019-04-30', 'http://dummyimage.com/248x219.png/ff4444/ffffff');
443insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (4, 'dlaffand', 'Darleen', 'Laffan', 'dlaffand@twitter.com', '5teLdoaZ', '4763 Utah Way', null, '1952-04-05', '2019-04-30', 'http://dummyimage.com/127x228.png/ff4444/ffffff');
444insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (7, 'vaylotte', 'Valentina', 'Aylott', 'vaylotte@wikimedia.org', '4p496BG', '6412 Hintze Lane', '665212', '1987-09-21', '2019-04-30', 'http://dummyimage.com/172x167.png/dddddd/000000');
445insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'ashelmerdinef', 'Avery', 'Shelmerdine', 'ashelmerdinef@ihg.com', 'z2pFJWQVPA', '39008 Express Crossing', null, '1992-02-08', '2019-04-30', 'http://dummyimage.com/162x193.png/dddddd/000000');
446insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (3, 'aloadesg', 'Allyn', 'Loades', 'aloadesg@about.com', 'UwXJCaCFe', '959 Colorado Road', '862 95', '1992-07-30', '2019-04-30', 'http://dummyimage.com/103x147.png/5fa2dd/ffffff');
447insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (14, 'epeakerh', 'Emmalyn', 'Peaker', 'epeakerh@multiply.com', 'hxHolXfHutV', '6 Eastwood Road', '6227', '1957-09-03', '2019-04-30', 'http://dummyimage.com/222x149.png/dddddd/000000');
448insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (1, 'rsabbani', 'Rancell', 'Sabban', 'rsabbani@yellowbook.com', 'jAClF4nroqX', '41 Oak Circle', '427820', '1987-05-18', '2019-04-30', 'http://dummyimage.com/221x157.png/dddddd/000000');
449insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'keltonj', 'Kylie', 'Elton', 'keltonj@tinyurl.com', 'zyxrkbi', '7 Trailsway Court', null, '1990-03-27', '2019-04-30', 'http://dummyimage.com/224x149.png/cc0000/ffffff');
450insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (16, 'ccaldayrouk', 'Corby', 'Caldayrou', 'ccaldayrouk@bloglovin.com', 'YRsLbzqe', '1667 Gulseth Trail', null, '1955-04-07', '2019-04-30', 'http://dummyimage.com/167x240.png/5fa2dd/ffffff');
451insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (14, 'clunkl', 'Cassandry', 'Lunk', 'clunkl@biblegateway.com', 'AgFKdurf', '88889 Arapahoe Drive', '13465-000', '1967-05-21', '2019-04-30', 'http://dummyimage.com/128x129.png/dddddd/000000');
452insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (12, 'xdurbridgem', 'Ximenes', 'Durbridge', 'xdurbridgem@lulu.com', 'veDwXqE', '818 Roth Way', null, '1967-05-29', '2019-04-30', 'http://dummyimage.com/144x136.png/5fa2dd/ffffff');
453insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (16, 'bmanusn', 'Bessy', 'Manus', 'bmanusn@weather.com', 'ieUil1HOT3C', '49029 Parkside Park', '83-050', '1951-01-21', '2019-04-30', 'http://dummyimage.com/156x136.png/5fa2dd/ffffff');
454insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'mcastaneo', 'Margareta', 'Castane', 'mcastaneo@purevolume.com', 'GywtBlfTpzo', '3890 Comanche Junction', null, '1953-03-12', '2019-04-30', 'http://dummyimage.com/205x216.png/cc0000/ffffff');
455insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (4, 'jshermanp', 'Jeffrey', 'Sherman', 'jshermanp@squarespace.com', 'yHrSe7', '67 Oriole Plaza', null, '1955-04-11', '2019-04-30', 'http://dummyimage.com/195x111.png/5fa2dd/ffffff');
456insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (17, 'mlonglandsq', 'Matilde', 'Longlands', 'mlonglandsq@mysql.com', 'tfJ2ZBG1Pg', '821 Vahlen Road', null, '1964-05-17', '2019-04-30', 'http://dummyimage.com/221x162.png/dddddd/000000');
457insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (11, 'tvalder', 'Tyson', 'Valde', 'tvalder@msu.edu', 'Tygj1gy6', '99 Mallard Park', null, '1960-09-19', '2019-04-30', 'http://dummyimage.com/133x207.png/ff4444/ffffff');
458insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (18, 'olovewells', 'Ottilie', 'Lovewell', 'olovewells@163.com', 'I0UelR', '3 Kipling Place', null, '1999-12-29', '2019-04-30', 'http://dummyimage.com/131x130.png/cc0000/ffffff');
459insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (13, 'cmcgorleyt', 'Calv', 'Mc Gorley', 'cmcgorleyt@cmu.edu', '5SRDO8E5rz9', '44921 Rigney Road', null, '1989-11-22', '2019-04-30', 'http://dummyimage.com/133x160.png/5fa2dd/ffffff');
460insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (9, 'aderoecku', 'Ariadne', 'De Roeck', 'aderoecku@usatoday.com', 'MFwyF3TKmA', '2 Blue Bill Park Center', '34-116', '1969-02-08', '2019-04-30', 'http://dummyimage.com/139x202.png/cc0000/ffffff');
461insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (20, 'jhalkyardv', 'Jeanna', 'Halkyard', 'jhalkyardv@amazon.com', 'nzOWD481361', '36391 Vernon Crossing', '163028', '1959-08-28', '2019-04-30', 'http://dummyimage.com/187x211.png/5fa2dd/ffffff');
462insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (5, 'hmacsporranw', 'Hadlee', 'MacSporran', 'hmacsporranw@sciencedaily.com', 'VmbLPo', '3737 La Follette Point', '49505', '1958-04-28', '2019-04-30', 'http://dummyimage.com/233x183.png/5fa2dd/ffffff');
463insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (8, 'kyakhinx', 'Kalina', 'Yakhin', 'kyakhinx@is.gd', 'RJXIN9s7Tovi', '175 Washington Trail', null, '1956-07-27', '2019-04-30', 'http://dummyimage.com/189x215.png/5fa2dd/ffffff');
464insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (6, 'hbaudy', 'Hugues', 'Baud', 'hbaudy@aboutads.info', 'ijvKhADIF', '63 Larry Parkway', '520039', '1979-01-09', '2019-04-30', 'http://dummyimage.com/248x177.png/cc0000/ffffff');
465insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (17, 'afahyz', 'Angelica', 'Fahy', 'afahyz@istockphoto.com', 'nOlu0GaGn', '91 Leroy Hill', null, '1979-03-04', '2019-04-30', 'http://dummyimage.com/217x111.png/ff4444/ffffff');
466insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (5, 'lgoathrop10', 'Lena', 'Goathrop', 'lgoathrop10@tumblr.com', 'eVaIrTPcDy', '24385 Bartelt Junction', '96120', '1998-04-14', '2019-04-30', 'http://dummyimage.com/238x195.png/5fa2dd/ffffff');
467insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (17, 'ctalby11', 'Charlene', 'Talby', 'ctalby11@noaa.gov', 'svJWGxT', '13 Thackeray Parkway', null, '1943-03-31', '2019-04-30', 'http://dummyimage.com/132x160.png/dddddd/000000');
468insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (4, 'ucordeiro12', 'Ursola', 'Cordeiro', 'ucordeiro12@ibm.com', 'O0wjMXtp2RKF', '05327 Sachtjen Lane', null, '1987-06-05', '2019-04-30', 'http://dummyimage.com/196x203.png/5fa2dd/ffffff');
469insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (3, 'ufaircliffe13', 'Ulrich', 'Faircliffe', 'ufaircliffe13@businesswire.com', 'j6XmDCP08Q', '49 Calypso Lane', '95-083', '1966-12-12', '2019-04-30', 'http://dummyimage.com/161x139.png/ff4444/ffffff');
470insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (1, 'hkeable14', 'Hannis', 'Keable', 'hkeable14@mail.ru', 'XDVlSSH7p', '607 Wayridge Plaza', null, '1976-08-13', '2019-04-30', 'http://dummyimage.com/133x127.png/ff4444/ffffff');
471insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (1, 'ggudgion15', 'Gilberto', 'Gudgion', 'ggudgion15@nba.com', 'tGS6FFT', '3623 Tony Avenue', null, '1964-08-19', '2019-04-30', 'http://dummyimage.com/242x209.png/cc0000/ffffff');
472insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (10, 'rbrunnstein16', 'Rory', 'Brunnstein', 'rbrunnstein16@forbes.com', 'troB0Npb04yg', '43 Blaine Junction', null, '1964-12-10', '2019-04-30', 'http://dummyimage.com/221x164.png/ff4444/ffffff');
473insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (11, 'cgeeson17', 'Caren', 'Geeson', 'cgeeson17@jalbum.net', '9z5q90iLfStR', '94 Rusk Street', null, '1997-10-16', '2019-04-30', 'http://dummyimage.com/131x135.png/5fa2dd/ffffff');
474insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (10, 'jballeine18', 'Joly', 'Balleine', 'jballeine18@moonfruit.com', 'Tt5ZHkK6c', '021 Spaight Street', null, '1980-07-20', '2019-04-30', 'http://dummyimage.com/107x155.png/5fa2dd/ffffff');
475insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (14, 'dpatinkin19', 'Daron', 'Patinkin', 'dpatinkin19@quantcast.com', '2I9cR7G', '3768 Pankratz Point', null, '1957-03-31', '2019-04-30', 'http://dummyimage.com/130x178.png/cc0000/ffffff');
476insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (6, 'gcranefield1a', 'Gradeigh', 'Cranefield', 'gcranefield1a@samsung.com', 'EnZC18FJ', '03575 Fulton Point', '7565-205', '1945-04-30', '2019-04-30', 'http://dummyimage.com/199x115.png/cc0000/ffffff');
477insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (18, 'ghansen1b', 'Georgena', 'Hansen', 'ghansen1b@istockphoto.com', '3XVnoylDqgn', '5 Ryan Avenue', null, '1976-02-22', '2019-04-30', 'http://dummyimage.com/118x161.png/5fa2dd/ffffff');
478insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (11, 'cblenkinsop1c', 'Clemmy', 'Blenkinsop', 'cblenkinsop1c@bluehost.com', 'Mqw34uvzp0', '1748 Bay Hill', null, '1955-09-17', '2019-04-30', 'http://dummyimage.com/184x233.png/dddddd/000000');
479insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (20, 'live1d', 'Leopold', 'Ive', 'live1d@kickstarter.com', '8XRBRD', '16140 Kedzie Drive', null, '1975-04-22', '2019-04-30', 'http://dummyimage.com/159x232.png/cc0000/ffffff');
480insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (7, 'nyantsev1e', 'Niall', 'Yantsev', 'nyantsev1e@rediff.com', 'rtt9SQ0', '56650 Magdeline Drive', null, '1968-06-25', '2019-04-30', 'http://dummyimage.com/112x188.png/5fa2dd/ffffff');
481insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (11, 'fcharlet1f', 'Feodor', 'Charlet', 'fcharlet1f@hubpages.com', 'N0K9UndLriGc', '8 Transport Hill', '3460-710', '1980-07-22', '2019-04-30', 'http://dummyimage.com/151x159.png/5fa2dd/ffffff');
482insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (16, 'mgoodhall1g', 'Matelda', 'Goodhall', 'mgoodhall1g@unc.edu', 'BtDq2MOzMG8k', '8 Buena Vista Point', '051059', '1956-08-26', '2019-04-30', 'http://dummyimage.com/223x112.png/ff4444/ffffff');
483insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (10, 'mbarczewski1h', 'Miller', 'Barczewski', 'mbarczewski1h@furl.net', 'NvGBPjX', '64 Forest Dale Point', 'H71', '1999-10-27', '2019-04-30', 'http://dummyimage.com/238x153.png/cc0000/ffffff');
484insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (2, 'lverman1i', 'Lindon', 'Verman', 'lverman1i@rakuten.co.jp', 'QFavAOj', '95782 Old Gate Junction', '936-0056', '1946-05-01', '2019-04-30', 'http://dummyimage.com/153x183.png/dddddd/000000');
485insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (6, 'arolance1j', 'Alexander', 'Rolance', 'arolance1j@topsy.com', 'CUDO8ZsKDSk', '16232 Hallows Drive', 'L-9696', '1988-09-16', '2019-04-30', 'http://dummyimage.com/134x197.png/5fa2dd/ffffff');
486insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (12, 'rquest1k', 'Randi', 'Quest', 'rquest1k@google.com.au', '5qu7WxRQLpwc', '090 Fieldstone Parkway', null, '1990-04-05', '2019-04-30', 'http://dummyimage.com/179x243.png/dddddd/000000');
487insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (9, 'dalliband1l', 'Dorie', 'Alliband', 'dalliband1l@slideshare.net', 'xwSU9d29M1', '72717 Kim Crossing', null, '1958-11-24', '2019-04-30', 'http://dummyimage.com/153x193.png/ff4444/ffffff');
488insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (14, 'ksimnett1m', 'Kelby', 'Simnett', 'ksimnett1m@squarespace.com', 'dyCUv5OVM', '7 Pawling Crossing', '4503', '1951-10-16', '2019-04-30', 'http://dummyimage.com/172x156.png/ff4444/ffffff');
489insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (9, 'gyoselevitch1n', 'Glori', 'Yoselevitch', 'gyoselevitch1n@theguardian.com', 'LXf56FuA4b', '12 Declaration Road', '346940', '1959-04-22', '2019-04-30', 'http://dummyimage.com/171x249.png/cc0000/ffffff');
490insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (2, 'svakhonin1o', 'Sheffy', 'Vakhonin', 'svakhonin1o@mapquest.com', 'eHxZQG', '01683 Melvin Junction', null, '1961-03-29', '2019-04-30', 'http://dummyimage.com/138x246.png/5fa2dd/ffffff');
491insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (10, 'akingaby1p', 'Akim', 'Kingaby', 'akingaby1p@hao123.com', 'InFM9HUq', '5 Wayridge Terrace', '433201', '1968-06-07', '2019-04-30', 'http://dummyimage.com/224x235.png/5fa2dd/ffffff');
492insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (1, 'aaggs1q', 'Annis', 'Aggs', 'aaggs1q@nsw.gov.au', '9yyk8VQD8', '8194 Mayfield Park', null, '1980-05-02', '2019-04-30', 'http://dummyimage.com/243x240.png/ff4444/ffffff');
493insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (8, 'alamprey1r', 'Alistair', 'Lamprey', 'alamprey1r@mit.edu', '9aPAG1E', '3732 Namekagon Center', '346781', '1947-02-24', '2019-04-30', 'http://dummyimage.com/250x115.png/5fa2dd/ffffff');
494insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (5, 'adanilyak1s', 'Amanda', 'Danilyak', 'adanilyak1s@jigsy.com', 'FvjAMHin', '6367 Hovde Junction', '3332', '1947-02-22', '2019-04-30', 'http://dummyimage.com/170x193.png/dddddd/000000');
495insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (14, 'bvasilik1t', 'Bernadine', 'Vasilik', 'bvasilik1t@g.co', 'xfWpaZ6rSGm', '84 Cordelia Plaza', null, '1998-03-27', '2019-04-30', 'http://dummyimage.com/104x129.png/dddddd/000000');
496insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (11, 'tfacchini1u', 'Tod', 'Facchini', 'tfacchini1u@aboutads.info', '3NNavzV', '1420 Comanche Plaza', '3280-011', '1989-11-25', '2019-04-30', 'http://dummyimage.com/167x204.png/5fa2dd/ffffff');
497insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (11, 'jbruty1v', 'Juan', 'Bruty', 'jbruty1v@umn.edu', '8Uiguyl68', '022 Glacier Hill Crossing', null, '1960-05-19', '2019-04-30', 'http://dummyimage.com/219x122.png/cc0000/ffffff');
498insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (10, 'ahambric1w', 'Aggy', 'Hambric', 'ahambric1w@irs.gov', 'ZUtVqzF', '5440 Carberry Park', '390507', '1957-09-09', '2019-04-30', 'http://dummyimage.com/212x247.png/dddddd/000000');
499insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'elathaye1x', 'Ethe', 'Lathaye', 'elathaye1x@alibaba.com', '6uKvEi', '89769 Transport Pass', null, '1980-07-13', '2019-04-30', 'http://dummyimage.com/140x105.png/5fa2dd/ffffff');
500insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (20, 'hramsby1y', 'Huberto', 'Ramsby', 'hramsby1y@xing.com', 'SINKBpFL', '53 Mendota Trail', '205018', '1985-03-10', '2019-04-30', 'http://dummyimage.com/173x103.png/ff4444/ffffff');
501insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (13, 'hhorwell1z', 'Hollie', 'Horwell', 'hhorwell1z@hp.com', 'dCCkJdlCwf', '5962 Meadow Valley Alley', '423650', '1979-02-10', '2019-04-30', 'http://dummyimage.com/221x209.png/cc0000/ffffff');
502insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (13, 'ckeppe20', 'Cullan', 'Keppe', 'ckeppe20@walmart.com', 'QOjrTmp', '198 Pine View Parkway', '84104 CEDEX', '1990-05-12', '2019-04-30', 'http://dummyimage.com/177x231.png/5fa2dd/ffffff');
503insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (8, 'amcfater21', 'Abeu', 'McFater', 'amcfater21@blogs.com', 'dticktHQV', '323 Knutson Point', null, '1970-09-15', '2019-04-30', 'http://dummyimage.com/179x165.png/cc0000/ffffff');
504insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (19, 'gconman22', 'Gerald', 'Conman', 'gconman22@barnesandnoble.com', 'nJjUFaGhunWR', '7154 Ridge Oak Avenue', '3830-752', '1981-05-06', '2019-04-30', 'http://dummyimage.com/187x190.png/dddddd/000000');
505insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (16, 'aadamowicz23', 'Alicea', 'Adamowicz', 'aadamowicz23@yelp.com', 'R8M4Yf', '7993 American Ash Lane', '2109', '1943-12-25', '2019-04-30', 'http://dummyimage.com/130x246.png/5fa2dd/ffffff');
506insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (3, 'bdrinan24', 'Benton', 'Drinan', 'bdrinan24@nbcnews.com', 'rXAmEWy', '24 Spohn Avenue', null, '1945-03-16', '2019-04-30', 'http://dummyimage.com/178x143.png/5fa2dd/ffffff');
507insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (18, 'jduesberry25', 'Janel', 'Duesberry', 'jduesberry25@photobucket.com', 'KsQAVj4Kr4p', '49695 Colorado Center', '6009', '1959-11-27', '2019-04-30', 'http://dummyimage.com/139x217.png/ff4444/ffffff');
508insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (10, 'hhowkins26', 'Haslett', 'Howkins', 'hhowkins26@tinypic.com', 'm7cH5vzhqMhO', '641 Riverside Park', null, '1968-10-02', '2019-04-30', 'http://dummyimage.com/215x213.png/cc0000/ffffff');
509insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (19, 'abelhomme27', 'Anne', 'Belhomme', 'abelhomme27@nationalgeographic.com', 'c7PpWEigbxF', '3 Kinsman Center', 'K8H', '1957-07-01', '2019-04-30', 'http://dummyimage.com/153x185.png/cc0000/ffffff');
510insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (13, 'klamburn28', 'Kathlin', 'Lamburn', 'klamburn28@mediafire.com', 'W23D2yT', '1651 Waubesa Trail', null, '1946-04-09', '2019-04-30', 'http://dummyimage.com/157x170.png/ff4444/ffffff');
511insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (14, 'sblinckhorne29', 'Si', 'Blinckhorne', 'sblinckhorne29@archive.org', '0InAdu6OQtjY', '33 Sunbrook Place', '8330', '1985-12-29', '2019-04-30', 'http://dummyimage.com/163x168.png/5fa2dd/ffffff');
512insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (10, 'dastridge2a', 'Darla', 'Astridge', 'dastridge2a@ftc.gov', 'qcuEyN', '1587 Di Loreto Hill', null, '1952-07-18', '2019-04-30', 'http://dummyimage.com/220x145.png/ff4444/ffffff');
513insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (19, 'proumier2b', 'Paulita', 'Roumier', 'proumier2b@theglobeandmail.com', '3g6EtmRmHXuD', '84 Roxbury Lane', null, '1963-04-02', '2019-04-30', 'http://dummyimage.com/163x229.png/5fa2dd/ffffff');
514insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'kmoreby2c', 'Kaitlin', 'Moreby', 'kmoreby2c@blogs.com', 'pss962', '56012 Fremont Way', null, '1982-04-09', '2019-04-30', 'http://dummyimage.com/205x233.png/dddddd/000000');
515insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (5, 'glefeuvre2d', 'Gallagher', 'Le feuvre', 'glefeuvre2d@jiathis.com', 'W8LuUk', '684 Oak Valley Circle', '613060', '1988-11-29', '2019-04-30', 'http://dummyimage.com/173x117.png/5fa2dd/ffffff');
516insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (13, 'lbyrth2e', 'Leigh', 'Byrth', 'lbyrth2e@fastcompany.com', 'gjM0BhlfI02', '67280 Westridge Street', '939-1351', '1983-07-13', '2019-04-30', 'http://dummyimage.com/205x111.png/ff4444/ffffff');
517insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (19, 'snaire2f', 'Steve', 'Naire', 'snaire2f@slate.com', '6igc51NUhqbI', '62 Village Green Parkway', '32-864', '1946-11-20', '2019-04-30', 'http://dummyimage.com/172x192.png/dddddd/000000');
518insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (5, 'lroyl2g', 'Ludvig', 'Royl', 'lroyl2g@webeden.co.uk', 'GHPZzPr5TT', '63203 Northport Junction', '671450', '1999-11-08', '2019-04-30', 'http://dummyimage.com/179x219.png/5fa2dd/ffffff');
519insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (15, 'cvanarsdalen2h', 'Celisse', 'Van Arsdalen', 'cvanarsdalen2h@etsy.com', 'BT05pA', '44 Beilfuss Point', '639-2244', '1951-07-05', '2019-04-30', 'http://dummyimage.com/178x130.png/5fa2dd/ffffff');
520insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (14, 'cvasilechko2i', 'Cherin', 'Vasilechko', 'cvasilechko2i@geocities.jp', 'qZqRAp5', '88 Pepper Wood Center', null, '1975-09-11', '2019-04-30', 'http://dummyimage.com/226x208.png/5fa2dd/ffffff');
521insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (17, 'jzorener2j', 'Joni', 'Zorener', 'jzorener2j@e-recht24.de', 'oA1mvbdv8S6', '315 Paget Trail', null, '1974-02-03', '2019-04-30', 'http://dummyimage.com/112x125.png/ff4444/ffffff');
522insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (4, 'agutman2k', 'Ashien', 'Gutman', 'agutman2k@privacy.gov.au', 'pQXTOt', '45490 Fairfield Crossing', null, '1992-08-23', '2019-04-30', 'http://dummyimage.com/128x166.png/5fa2dd/ffffff');
523insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (4, 'rcaulder2l', 'Rhody', 'Caulder', 'rcaulder2l@epa.gov', 'jXZo3zhS5s', '7348 Caliangt Alley', '301259', '1950-12-25', '2019-04-30', 'http://dummyimage.com/173x147.png/cc0000/ffffff');
524insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (16, 'fzavittieri2m', 'Fredi', 'Zavittieri', 'fzavittieri2m@seesaa.net', 'ti0sl2L', '166 Lotheville Terrace', null, '1950-12-26', '2019-04-30', 'http://dummyimage.com/112x154.png/cc0000/ffffff');
525insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (6, 'yyewdall2n', 'Yoshiko', 'Yewdall', 'yyewdall2n@un.org', 'ueqtbAnWz1o', '9914 Stone Corner Crossing', '368758', '1994-03-08', '2019-04-30', 'http://dummyimage.com/229x241.png/dddddd/000000');
526insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (12, 'fsturges2o', 'Farrah', 'Sturges', 'fsturges2o@who.int', 'lucsfe', '618 Lyons Terrace', '3530', '1943-11-27', '2019-04-30', 'http://dummyimage.com/109x131.png/5fa2dd/ffffff');
527insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (3, 'abrimblecombe2p', 'Ado', 'Brimblecombe', 'abrimblecombe2p@foxnews.com', 'VZlx8kjD1UP', '062 Dennis Junction', '9303', '1986-09-21', '2019-04-30', 'http://dummyimage.com/146x130.png/ff4444/ffffff');
528insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (2, 'gregelous2q', 'Gwenore', 'Regelous', 'gregelous2q@goo.ne.jp', '1Iwib6Uqc', '5 Burning Wood Court', null, '1990-06-03', '2019-04-30', 'http://dummyimage.com/149x188.png/dddddd/000000');
529insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (9, 'lscougal2r', 'Louisa', 'Scougal', 'lscougal2r@icio.us', 'T9flpxvBwZ', '0 Blackbird Way', null, '1977-02-05', '2019-04-30', 'http://dummyimage.com/125x153.png/cc0000/ffffff');
530insert into "user" (id_city, username, first_name, last_name, email, "password", "address", zipcode, date_of_birth, date_of_registration, profile_picture) values (9, 'John', 'John', 'Doe', 'john@example.com', '$2y$10$HfzIhGCCaxqyaIdGgjARSuOKAcm1Uy82YfLuNaajn6JrjLWy9Sj/W', '0 Blackbird Way', null, '1977-02-05', '2019-04-30', 'http://dummyimage.com/125x153.png/cc0000/ffffff');
531-----------------------------------------
532-- Admin
533-----------------------------------------
534INSERT INTO "admin" (id_user) VALUES (1);
535INSERT INTO "admin" (id_user) VALUES (2);
536INSERT INTO "admin" (id_user) VALUES (3);
537INSERT INTO "admin" (id_user) VALUES (4);
538
539-----------------------------------------
540-- Seller
541-----------------------------------------
542INSERT INTO seller (id_member, iban) VALUES (70, 'CR05015202001026284066');
543INSERT INTO seller (id_member, iban) VALUES (73, 'DO28BAGR00000001212453611324');
544INSERT INTO seller (id_member, iban) VALUES (57, 'KW81CBKU0000000000001234560101');
545INSERT INTO seller (id_member, iban) VALUES (56, 'PT50000201231234567890154');
546INSERT INTO seller (id_member, iban) VALUES (90, 'PT50000201261664567890554');
547INSERT INTO seller (id_member, iban) VALUES (65, 'YY24KIHB12476423125915947930915268');
548INSERT INTO seller (id_member, iban) VALUES (69, 'UA213996220000026007233566001');
549INSERT INTO seller (id_member, iban) VALUES (95, 'LU280019400644750000');
550INSERT INTO seller (id_member, iban) VALUES (79, 'LU280019404644550000');
551INSERT INTO seller (id_member, iban) VALUES (91, 'GB29NWBK60161331926819');
552INSERT INTO seller (id_member, iban) VALUES (101, 'GB59NWBK60161331926819');
553
554
555-----------------------------------------
556-- Author
557-----------------------------------------
558INSERT INTO author ("name", "date", id_country, biography) VALUES ('J. Michael Straczynski' , '1954-07-17', 3, 'Joseph Michael Straczynski (bo');
559INSERT INTO author ("name", "date", id_country, biography) VALUES ('Esad Ribic' , null, 10, null);
560INSERT INTO author ("name", "date", id_country, biography) VALUES ('Robert Jordan' , '1948-10-17', 3, 'Librarian Note: There is mo');
561INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brandon Sanderson' , null, 3, 'Brandon’s major books for the ');
562INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dan Simmons' , '1948-04-04', 13, 'Dan Simmons grew up in ');
563INSERT INTO author ("name", "date", id_country, biography) VALUES ('Alan Moore' , null, 3, 'Alan Moore is an English write');
564INSERT INTO author ("name", "date", id_country, biography) VALUES ('Curt Swan' , '1920-02-17', 6, null);
565INSERT INTO author ("name", "date", id_country, biography) VALUES ('George Pérez' , '1954-06-09', 8, 'George Pérez (born June 9, 195');
566INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dave Gibbons' , '1949-04-14', 4, 'Dave Gibbons is an English com');
567INSERT INTO author ("name", "date", id_country, biography) VALUES ('Rick Veitch' , '1951-05-07', 13, 'Richard "Rick" Veitch is an Am');
568INSERT INTO author ("name", "date", id_country, biography) VALUES ('Al Williamson' , '1931-03-21', 11, 'Al Williamson was an American ');
569INSERT INTO author ("name", "date", id_country, biography) VALUES ('Murphy Anderson' , '1926-07-09', 13, null);
570INSERT INTO author ("name", "date", id_country, biography) VALUES ('Paul Kupperberg' , null, 6, null);
571INSERT INTO author ("name", "date", id_country, biography) VALUES ('Stephen King' , null, 3, 'Stephen Edwin King was born th');
572INSERT INTO author ("name", "date", id_country, biography) VALUES ('Arthur C. Clarke' , '1917-12-16', 3, 'Arthur Charles Clarke was one ');
573INSERT INTO author ("name", "date", id_country, biography) VALUES ('Terry Pratchett' , '1948-04-28', 3, 'Born Terence David John Pratch');
574INSERT INTO author ("name", "date", id_country, biography) VALUES ('Isaac Asimov' , '1920-01-02', 8, 'Isaac Asimov was a Russian-bor');
575INSERT INTO author ("name", "date", id_country, biography) VALUES ('Michel Faber' , '1960-04-13', 13, 'Michel Faber (born 13 April 19');
576INSERT INTO author ("name", "date", id_country, biography) VALUES ('Clayton Crain' , null, 10, null);
577INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mary Roach' , null, 12, 'Mary Roach is the author of th');
578INSERT INTO author ("name", "date", id_country, biography) VALUES ('Peter Clines' , null, 12, null);
579INSERT INTO author ("name", "date", id_country, biography) VALUES ('Haruki Murakami' , '1949-01-12', 2, 'Murakami Haruki (Japane');
580INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ted Goossen' , null, 10, null);
581INSERT INTO author ("name", "date", id_country, biography) VALUES ('Chip Kidd' , '1964-01-01', 1, 'Chip Kidd is an American autho');
582INSERT INTO author ("name", "date", id_country, biography) VALUES ('Owen King' , null, 3, 'I''m the author of the novel ');
583INSERT INTO author ("name", "date", id_country, biography) VALUES ('Joe Hill' , null, 3, 'Joe Hill''s debut, ');
584INSERT INTO author ("name", "date", id_country, biography) VALUES ('Richard Bachman' , '1941-09-21', 3, 'This is a ');
585INSERT INTO author ("name", "date", id_country, biography) VALUES ('Matthew Sturges' , null, 3, null);
586INSERT INTO author ("name", "date", id_country, biography) VALUES ('Bill Willingham' , null, 3, 'In the late 1970s to early 198');
587INSERT INTO author ("name", "date", id_country, biography) VALUES ('Luca  Rossi' , '1977-04-15', 11, 'Research, science, science fic');
588INSERT INTO author ("name", "date", id_country, biography) VALUES ('D. Ross Campbell' , null, 8, 'Librarian Note: There is mo');
589INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jill Thompson' , '1966-11-20', 7, 'Jill Thompson is an American c');
590INSERT INTO author ("name", "date", id_country, biography) VALUES ('Tim Waggoner' , null, 8, 'Tim Waggoner has published ove');
591INSERT INTO author ("name", "date", id_country, biography) VALUES ('Steve Rolston' , null, 12, null);
592INSERT INTO author ("name", "date", id_country, biography) VALUES ('Sean Gordon Murphy' , null, 4, null);
593INSERT INTO author ("name", "date", id_country, biography) VALUES ('Lee Loughridge' , null, 3, null);
594INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dave  Stewart' , null, 5, null);
595INSERT INTO author ("name", "date", id_country, biography) VALUES ('Todd Klein' , '1951-01-28', 11, null);
596INSERT INTO author ("name", "date", id_country, biography) VALUES ('Esao Andrews' , null, 4, null);
597INSERT INTO author ("name", "date", id_country, biography) VALUES ('Bernie Wrightson' , '1948-10-27', 1, 'Artist known for his horror il');
598INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ángel Medina' , null, 11, null);
599INSERT INTO author ("name", "date", id_country, biography) VALUES ('Garth Ennis' , '1970-01-16', 6, 'Ennis began his comic-writing ');
600INSERT INTO author ("name", "date", id_country, biography) VALUES ('Steve  Dillon' , null, 3, 'Librarian’s note: There is ');
601INSERT INTO author ("name", "date", id_country, biography) VALUES ('Joe R. Lansdale' , '1951-10-28', 13, 'Champion Mojo Storyteller Joe ');
602INSERT INTO author ("name", "date", id_country, biography) VALUES ('Greg Rucka' , '1969-11-29', 3, 'Greg Rucka, is an American com');
603INSERT INTO author ("name", "date", id_country, biography) VALUES ('Eddy Barrows' , null, 2, 'Eduardo Barros is a Brazilian ');
604INSERT INTO author ("name", "date", id_country, biography) VALUES ('Diego Olmos' , null, 10, null);
605INSERT INTO author ("name", "date", id_country, biography) VALUES ('Pere Pérez' , null, 3, null);
606INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dwayne McDuffie' , null, 12, null);
607INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ruy Jose' , null, 13, null);
608INSERT INTO author ("name", "date", id_country, biography) VALUES ('Robert Louis Stevenson' , '1850-11-13', 8, 'Robert Louis Balfour Stevenson');
609INSERT INTO author ("name", "date", id_country, biography) VALUES ('Andrew Robinson' , null, 4, 'Librarian Note: There is mo');
610INSERT INTO author ("name", "date", id_country, biography) VALUES ('Geoff Johns' , '1973-01-25', 3, 'Geoff Johns originally hails f');
611INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ethan Van Sciver' , '1974-09-03', 11, 'One of the most popular artist');
612INSERT INTO author ("name", "date", id_country, biography) VALUES ('Scott Hanna' , null, 9, null);
613INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brian Miller' , null, 10, null);
614INSERT INTO author ("name", "date", id_country, biography) VALUES ('Peter David' , '1956-09-23', 11, 'aka ');
615INSERT INTO author ("name", "date", id_country, biography) VALUES ('Reginald Hudlin' , '1961-12-15', 4, null);
616INSERT INTO author ("name", "date", id_country, biography) VALUES ('Pat Lee' , null, 8, null);
617INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brian Michael Bendis' , '1967-08-18', 3, 'A comic book writer and erstwh');
618INSERT INTO author ("name", "date", id_country, biography) VALUES ('Christos Gage' , null, 10, 'Chris Gage is a writer for com');
619INSERT INTO author ("name", "date", id_country, biography) VALUES ('Daniel Knauf' , null, 12, null);
620INSERT INTO author ("name", "date", id_country, biography) VALUES ('Charles Knauf' , null, 9, null);
621INSERT INTO author ("name", "date", id_country, biography) VALUES ('Alex Maleev' , null, 11, null);
622INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mike  Perkins' , null, 13, 'Librarian note: there is mo');
623INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jeremy Haun' , null, 1, null);
624INSERT INTO author ("name", "date", id_country, biography) VALUES ('Patrick Zircher' , null, 10, null);
625INSERT INTO author ("name", "date", id_country, biography) VALUES ('Allan Heinberg' , null, 4, null);
626INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jim Cheung' , null, 10, null);
627INSERT INTO author ("name", "date", id_country, biography) VALUES ('John Dell' , null, 6, null);
628INSERT INTO author ("name", "date", id_country, biography) VALUES ('Neal Adams' , '1941-06-06', 13, 'Neal Adams is an American comi');
629INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mark Millar' , null, 3, 'Mark Millar is the New York Ti');
630INSERT INTO author ("name", "date", id_country, biography) VALUES ('Bryan Hitch' , '1966-04-22', 11, 'Bryan Hitch is a British comic');
631INSERT INTO author ("name", "date", id_country, biography) VALUES ('Andrew Currie' , null, 3, null);
632INSERT INTO author ("name", "date", id_country, biography) VALUES ('Warren Ellis' , null, 3, 'Warren Ellis is the award-winn');
633INSERT INTO author ("name", "date", id_country, biography) VALUES ('Adi Granov' , null, 1, null);
634INSERT INTO author ("name", "date", id_country, biography) VALUES ('Matt Fraction' , '1975-12-12', 3, '"How he got started in comi');
635INSERT INTO author ("name", "date", id_country, biography) VALUES ('Salvador Larroca' , null, 4, null);
636INSERT INTO author ("name", "date", id_country, biography) VALUES ('Christopher Yost' , '1973-02-21', 3, null);
637INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brian K. Vaughan' , null, 3, 'Born in Cleveland in 1976, Bri');
638INSERT INTO author ("name", "date", id_country, biography) VALUES ('Adrian Alphona' , null, 3, 'Adrian Alphona is a Canadian c');
639INSERT INTO author ("name", "date", id_country, biography) VALUES ('G. Willow Wilson' , null, 10, 'Hugo Award-winning writer of c');
640INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mark Waid' , '1962-03-21', 3, 'Mark Waid (born March 21, 1962');
641INSERT INTO author ("name", "date", id_country, biography) VALUES ('Barry Kitson' , null, 1, null);
642INSERT INTO author ("name", "date", id_country, biography) VALUES ('Johanna Spyri' , '1827-06-12', 8, 'Johanna Spyri was an author of');
643INSERT INTO author ("name", "date", id_country, biography) VALUES ('Chris Claremont' , '1950-11-30', 10, 'Chris Claremont is a writer of');
644INSERT INTO author ("name", "date", id_country, biography) VALUES ('John Byrne' , '1960-07-06', 1, 'John Lindley Byrne is a Britis');
645INSERT INTO author ("name", "date", id_country, biography) VALUES ('Terry Kevin Austin' , '1952-08-23', 5, 'Inker and occasional writer fo');
646INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dave Cockrum' , '1943-11-11', 3, 'David Emmett Cockrum was an Am');
647INSERT INTO author ("name", "date", id_country, biography) VALUES ('Len Wein' , '1948-06-12', 13, 'Len Wein was an American comic');
648INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mark Bagley' , '1957-08-07', 11, 'Mark Bagley was born to a mili');
649INSERT INTO author ("name", "date", id_country, biography) VALUES ('Stuart Immonen' , null, 10, null);
650INSERT INTO author ("name", "date", id_country, biography) VALUES ('Wade Von Grawbadger' , null, 11, null);
651INSERT INTO author ("name", "date", id_country, biography) VALUES ('Scott Snyder' , null, 9, 'Scott Snyder is the Eisner and');
652INSERT INTO author ("name", "date", id_country, biography) VALUES ('Keith Giffen' , '1952-11-30', 5, 'Keith Ian Giffen is an America');
653INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dan Abnett' , null, 8, null);
654INSERT INTO author ("name", "date", id_country, biography) VALUES ('Andy Lanning' , null, 1, null);
655INSERT INTO author ("name", "date", id_country, biography) VALUES ('Art Thibert' , '1961-10-07', 1, null);
656INSERT INTO author ("name", "date", id_country, biography) VALUES ('Scott Kolins' , null, 5, 'Scott Kolins is an American il');
657INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ariel Olivetti' , '1967-11-15', 4, 'Argentine comic book penciller');
658INSERT INTO author ("name", "date", id_country, biography) VALUES ('Kev Walker' , null, 12, null);
659INSERT INTO author ("name", "date", id_country, biography) VALUES ('Roberto Aguirre-Sacasa' , null, 1, null);
660INSERT INTO author ("name", "date", id_country, biography) VALUES ('Steve Leialoha' , '1952-01-27', 2, 'Steve Leialoha is an American ');
661INSERT INTO author ("name", "date", id_country, biography) VALUES ('Craig  Hamilton' , null, 11, 'Craig Hamilton is a graduate o');
662INSERT INTO author ("name", "date", id_country, biography) VALUES ('James Jean' , '1979-10-20', 3, 'James Jean is a Taiwanese-Amer');
663INSERT INTO author ("name", "date", id_country, biography) VALUES ('John Cassaday' , '1971-01-01', 7, null);
664INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brad Walker' , null, 9, null);
665INSERT INTO author ("name", "date", id_country, biography) VALUES ('Kieron Gillen' , null, 2, 'Kieron Gillen is a comic book ');
666INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jim Krueger' , null, 6, null);
667INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mike McKone' , null, 2, null);
668INSERT INTO author ("name", "date", id_country, biography) VALUES ('Marko Djurdjevic' , null, 10, null);
669INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ed Brubaker' , '1966-11-17', 1, 'Ed Brubaker (born November 17,');
670INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mike Deodato' , '1963-05-23', 11, 'Mike Deodato, sometimes credit');
671INSERT INTO author ("name", "date", id_country, biography) VALUES ('Joseph Conrad' , '1857-12-03', 9, 'Joseph Conrad (born ');
672INSERT INTO author ("name", "date", id_country, biography) VALUES ('Fernando Pessoa' , null, 5, null);
673INSERT INTO author ("name", "date", id_country, biography) VALUES ('Matt Kindt' , null, 9, null);
674INSERT INTO author ("name", "date", id_country, biography) VALUES ('David Aja' , '1977-04-16', 9, 'David Ajá Fernández is a Spani');
675INSERT INTO author ("name", "date", id_country, biography) VALUES ('Michael Lark' , null, 5, null);
676INSERT INTO author ("name", "date", id_country, biography) VALUES ('Stefano Gaudiano' , null, 11, null);
677INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jeff Lemire' , '1976-03-21', 13, 'Jeff Lemire is an award-winnin');
678INSERT INTO author ("name", "date", id_country, biography) VALUES ('Tony Bedard' , null, 10, null);
679INSERT INTO author ("name", "date", id_country, biography) VALUES ('Tyler Kirkham' , null, 3, null);
680INSERT INTO author ("name", "date", id_country, biography) VALUES ('John Romita Jr.' , '1956-08-17', 3, 'John Salvatore Romita, Jr. is ');
681INSERT INTO author ("name", "date", id_country, biography) VALUES ('Peter J. Tomasi' , null, 7, 'Peter J. Tomasi is an American');
682INSERT INTO author ("name", "date", id_country, biography) VALUES ('Rob Liefeld' , '1967-10-03', 3, 'Rob Liefeld is an American com');
683INSERT INTO author ("name", "date", id_country, biography) VALUES ('Fernando Pasarín' , null, 5, null);
684INSERT INTO author ("name", "date", id_country, biography) VALUES ('Cam Smith' , null, 11, null);
685INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ivan Reis' , '1976-11-06', 8, 'Ivan Reis was born in São Paul');
686INSERT INTO author ("name", "date", id_country, biography) VALUES ('Patrick Gleason' , null, 11, 'Patrick Gleason is a comic boo');
687INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ardian Syaf' , null, 7, null);
688INSERT INTO author ("name", "date", id_country, biography) VALUES ('Catherine Scott-Clark' , null, 11, null);
689INSERT INTO author ("name", "date", id_country, biography) VALUES ('Plato' , '0428-02-20', 1, '(Greek: ');
690INSERT INTO author ("name", "date", id_country, biography) VALUES ('J.T. Krul' , null, 10, 'J. T. Krul is an American comi');
691INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mike W. Barr' , '1952-05-30', 1, 'Mike W. Barr is an American wr');
692INSERT INTO author ("name", "date", id_country, biography) VALUES ('Vicente Cifuentes' , null, 2, 'Historietista nacido en Albace');
693INSERT INTO author ("name", "date", id_country, biography) VALUES ('Judd Winick' , '1970-02-12', 3, 'Born February 12th, 1970 and r');
694INSERT INTO author ("name", "date", id_country, biography) VALUES ('Aaron Lopresti' , null, 3, null);
695INSERT INTO author ("name", "date", id_country, biography) VALUES ('Joe Bennett' , '1968-02-03', 3, 'comic book artist');
696INSERT INTO author ("name", "date", id_country, biography) VALUES ('Fernando Dagnino' , '1973-07-24', 10, 'Dagnino''s artistic career star');
697INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jeff Katz' , null, 2, null);
698INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dan Jurgens' , '1959-06-27', 2, 'Dan Jurgens is an American com');
699INSERT INTO author ("name", "date", id_country, biography) VALUES ('Kyle Higgins' , null, 4, null);
700INSERT INTO author ("name", "date", id_country, biography) VALUES ('Bryan Lee O''Malley' , '1979-02-21', 2, 'Bryan Lee O''Malley is a Canadi');
701INSERT INTO author ("name", "date", id_country, biography) VALUES ('Alberto Ponticelli' , null, 4, null);
702INSERT INTO author ("name", "date", id_country, biography) VALUES ('J.G. Jones' , null, 6, null);
703INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brian Reed' , '1973-07-01', 3, 'Librarian Note: There is mo');
704INSERT INTO author ("name", "date", id_country, biography) VALUES ('Roberto de la Torre' , '1975-07-24', 10, null);
705INSERT INTO author ("name", "date", id_country, biography) VALUES ('Frank Cho' , null, 4, 'The second of three children, ');
706INSERT INTO author ("name", "date", id_country, biography) VALUES ('Bryan Q. Miller' , null, 6, 'Bryan Q. Miller is an American');
707INSERT INTO author ("name", "date", id_country, biography) VALUES ('Lee Garbett' , null, 4, null);
708INSERT INTO author ("name", "date", id_country, biography) VALUES ('Trevor Scott' , null, 7, 'Trevor Scott was born in Dulut');
709INSERT INTO author ("name", "date", id_country, biography) VALUES ('Grant Morrison' , '1960-01-31', 1, 'Scottish comic book author Gra');
710INSERT INTO author ("name", "date", id_country, biography) VALUES ('Frazer Irving' , null, 5, null);
711INSERT INTO author ("name", "date", id_country, biography) VALUES ('David Hine' , null, 1, null);
712INSERT INTO author ("name", "date", id_country, biography) VALUES ('Chris Sprouse' , null, 4, null);
713INSERT INTO author ("name", "date", id_country, biography) VALUES ('Georges Jeanty' , null, 8, 'GEORGES JEANTY is an Eisner Aw');
714INSERT INTO author ("name", "date", id_country, biography) VALUES ('Bram Stoker' , '1847-11-08', 5, 'He was born Abraham Stoker in ');
715INSERT INTO author ("name", "date", id_country, biography) VALUES ('Nina Auerbach' , null, 8, null);
716INSERT INTO author ("name", "date", id_country, biography) VALUES ('Michel Lacombe' , null, 10, null);
717INSERT INTO author ("name", "date", id_country, biography) VALUES ('David J. Skal' , '1952-06-21', 11, 'David J. Skal became fascinate');
718INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mick Gray' , null, 4, null);
719INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mary Wollstonecraft Shelley' , '1797-08-30', 5, 'Mary Shelley (née Mary ');
720INSERT INTO author ("name", "date", id_country, biography) VALUES ('Guy Majors' , null, 10, null);
721INSERT INTO author ("name", "date", id_country, biography) VALUES ('Nathan Fairbairn' , null, 12, null);
722INSERT INTO author ("name", "date", id_country, biography) VALUES ('Peter F. Hamilton' , null, 9, 'Peter F. Hamilton is a British');
723INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jared K. Fletcher' , null, 11, null);
724INSERT INTO author ("name", "date", id_country, biography) VALUES ('Amy Reeder' , '1980-08-25', 1, 'Amy Reeder is an American comi');
725INSERT INTO author ("name", "date", id_country, biography) VALUES ('Andy Kubert' , '1962-02-27', 9, 'Andrew "Andy" Kubert is an Ame');
726INSERT INTO author ("name", "date", id_country, biography) VALUES ('J.R.R. Tolkien' , '1892-01-03', 3, 'John Ronald Reuel Tolkien, CBE');
727INSERT INTO author ("name", "date", id_country, biography) VALUES ('Shane Davis' , null, 1, null);
728INSERT INTO author ("name", "date", id_country, biography) VALUES ('Eric Battle' , null, 1, null);
729INSERT INTO author ("name", "date", id_country, biography) VALUES ('Tom Nguyen' , null, 8, null);
730INSERT INTO author ("name", "date", id_country, biography) VALUES ('Todd Dezago' , null, 11, 'Todd Dezago is an American com');
731INSERT INTO author ("name", "date", id_country, biography) VALUES ('Marv Wolfman' , '1946-05-13', 3, 'Marvin A. "Marv" Wolfman is an');
732INSERT INTO author ("name", "date", id_country, biography) VALUES ('Laura  Martin' , null, 9, 'Librarian Note: There is mo');
733INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mark Morales' , null, 4, null);
734INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ian Churchill' , null, 10, 'Ian Churchill is a British com');
735INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jock' , '1972-09-24', 9, null);
736INSERT INTO author ("name", "date", id_country, biography) VALUES ('Francesco Francavilla' , null, 5, null);
737INSERT INTO author ("name", "date", id_country, biography) VALUES ('Sal Cipriano' , null, 7, null);
738INSERT INTO author ("name", "date", id_country, biography) VALUES ('David Baron' , null, 1, 'David Baron is an award-winnin');
739INSERT INTO author ("name", "date", id_country, biography) VALUES ('Adam Schlagman' , null, 6, null);
740INSERT INTO author ("name", "date", id_country, biography) VALUES ('Pornsak Pichetshote' , null, 6, 'Pornsak Pichetshote was a Thai');
741INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ron Garney' , null, 3, null);
742INSERT INTO author ("name", "date", id_country, biography) VALUES ('Robson Rocha' , null, 2, null);
743INSERT INTO author ("name", "date", id_country, biography) VALUES ('Max Brooks' , null, 13, 'Max Brooks is The New York Tim');
744INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brian Azzarello' , '1962-08-11', 6, 'Brian Azzarello (born in Cleve');
745INSERT INTO author ("name", "date", id_country, biography) VALUES ('Andy Smith' , null, 4, 'Comic book artist.');
746INSERT INTO author ("name", "date", id_country, biography) VALUES ('Keith Champagne' , '1970-08-04', 12, null);
747INSERT INTO author ("name", "date", id_country, biography) VALUES ('Terry Dodson' , null, 7, null);
748INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jonathan Haidt' , '1963-10-19', 9, 'Jonathan Haidt is the Thomas C');
749INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jan Duursema' , '1957-10-27', 7, 'Sometimes credited as Jan Duur');
750INSERT INTO author ("name", "date", id_country, biography) VALUES ('Seth Grahame-Smith' , '1976-01-04', 7, 'Seth Grahame-Smith (born Seth ');
751INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ben Oliver' , null, 9, null);
752INSERT INTO author ("name", "date", id_country, biography) VALUES ('Frank Miller' , '1957-01-27', 3, 'Frank Miller is an American wr');
753INSERT INTO author ("name", "date", id_country, biography) VALUES ('David Mazzucchelli' , '1960-09-21', 13, 'David Mazzucchelli has been ma');
754INSERT INTO author ("name", "date", id_country, biography) VALUES ('Richmond Lewis' , null, 6, 'Richmond Lewis has been writin');
755INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dennis O''Neil' , '1939-05-03', 8, 'Dennis O''Neil is a comic book ');
756INSERT INTO author ("name", "date", id_country, biography) VALUES ('Lowell Francis' , null, 3, null);
757INSERT INTO author ("name", "date", id_country, biography) VALUES ('Rex Ogle' , null, 3, null);
758INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mike Carlin' , '1958-10-06', 9, 'Michael "Mike" Carlin is a com');
759INSERT INTO author ("name", "date", id_country, biography) VALUES ('Gene Ha' , null, 3, null);
760INSERT INTO author ("name", "date", id_country, biography) VALUES ('Eduardo Francisco' , null, 7, null);
761INSERT INTO author ("name", "date", id_country, biography) VALUES ('Paulo Siqueira' , null, 13, null);
762INSERT INTO author ("name", "date", id_country, biography) VALUES ('Roland Paris' , null, 9, null);
763INSERT INTO author ("name", "date", id_country, biography) VALUES ('Rick Leonardi' , '1957-08-09', 8, 'Rick Leonardi is an American c');
764INSERT INTO author ("name", "date", id_country, biography) VALUES ('Don Ho' , null, 11, null);
765INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brad Meltzer' , null, 3, 'Brad Meltzer is the #1 New Yor');
766INSERT INTO author ("name", "date", id_country, biography) VALUES ('Roger Cruz' , '1971-02-22', 1, 'Rogério Da Cruz Kuroda es un h');
767INSERT INTO author ("name", "date", id_country, biography) VALUES ('Frank Quitely' , null, 4, null);
768INSERT INTO author ("name", "date", id_country, biography) VALUES ('Kurt Busiek' , '1960-09-16', 1, 'Kurt Busiek is an American com');
769INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brent Anderson' , null, 6, null);
770INSERT INTO author ("name", "date", id_country, biography) VALUES ('Alex Ross' , null, 5, 'Librarian Note: There is mo');
771INSERT INTO author ("name", "date", id_country, biography) VALUES ('Richard Case' , null, 7, null);
772INSERT INTO author ("name", "date", id_country, biography) VALUES ('Juan Carlos Garzón' , null, 4, null);
773INSERT INTO author ("name", "date", id_country, biography) VALUES ('John Nyberg' , null, 10, null);
774INSERT INTO author ("name", "date", id_country, biography) VALUES ('Elliot S. Maggin' , null, 5, 'Elliot S. Maggin, also spelled');
775INSERT INTO author ("name", "date", id_country, biography) VALUES ('Chuck Wendig' , null, 4, 'Chuck Wendig is a novelist, a ');
776INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ann Nocenti' , '1957-01-17', 3, 'Ann Nocenti is most noted as a');
777INSERT INTO author ("name", "date", id_country, biography) VALUES ('John Francis Moore' , null, 5, 'John Francis Moore is comic bo');
778INSERT INTO author ("name", "date", id_country, biography) VALUES ('Steve Kurth' , null, 2, null);
779INSERT INTO author ("name", "date", id_country, biography) VALUES ('Freddie E. Williams II' , '1977-05-30', 13, 'American comic book writer and');
780INSERT INTO author ("name", "date", id_country, biography) VALUES ('Peter Milligan' , null, 3, 'Peter Milligan is a British wr');
781INSERT INTO author ("name", "date", id_country, biography) VALUES ('Miguel Sepúlveda' , null, 3, null);
782INSERT INTO author ("name", "date", id_country, biography) VALUES ('Ed Benes' , '1972-11-20', 3, 'José Edilbenes Bezerra is a Br');
783INSERT INTO author ("name", "date", id_country, biography) VALUES ('Tony S. Daniel' , null, 1, 'Tony Salvador Daniel is a comi');
784INSERT INTO author ("name", "date", id_country, biography) VALUES ('James Bonny' , null, 12, null);
785INSERT INTO author ("name", "date", id_country, biography) VALUES ('Philip Tan' , null, 12, null);
786INSERT INTO author ("name", "date", id_country, biography) VALUES ('Brandon Seifert' , null, 2, null);
787INSERT INTO author ("name", "date", id_country, biography) VALUES ('Adam Glass' , null, 12, null);
788INSERT INTO author ("name", "date", id_country, biography) VALUES ('Sean Ryan' , null, 1, null);
789INSERT INTO author ("name", "date", id_country, biography) VALUES ('Sterling Gates' , null, 5, 'Sterling Gates has written sto');
790INSERT INTO author ("name", "date", id_country, biography) VALUES ('Joel  Gomez-Dossi' , '1957-07-08', 6, null);
791INSERT INTO author ("name", "date", id_country, biography) VALUES ('Rodney Buchemi' , null, 7, null);
792INSERT INTO author ("name", "date", id_country, biography) VALUES ('José Marzán Jr.' , null, 5, 'José Marzán Jr. is a 29 -year ');
793INSERT INTO author ("name", "date", id_country, biography) VALUES ('Charles Soule' , null, 9, null);
794INSERT INTO author ("name", "date", id_country, biography) VALUES ('Scott Lobdell' , null, 10, 'Scott Lobdell (born 1963) is a');
795INSERT INTO author ("name", "date", id_country, biography) VALUES ('James Joyce' , '1882-02-02', 3, 'James Joyce, Irish novelist, n');
796INSERT INTO author ("name", "date", id_country, biography) VALUES ('Fabian Nicieza' , '1961-12-31', 10, 'Fabian Nicieza is an American ');
797INSERT INTO author ("name", "date", id_country, biography) VALUES ('China Miéville' , null, 2, 'A British "fantastic fiction" ');
798INSERT INTO author ("name", "date", id_country, biography) VALUES ('Mateus Santolouco' , null, 1, null);
799INSERT INTO author ("name", "date", id_country, biography) VALUES ('Riccardo Burchielli' , null, 7, null);
800INSERT INTO author ("name", "date", id_country, biography) VALUES ('David Lapham' , '1970-01-01', 13, null);
801INSERT INTO author ("name", "date", id_country, biography) VALUES ('Paul Cornell' , null, 10, 'Paul Cornell is a British writ');
802INSERT INTO author ("name", "date", id_country, biography) VALUES ('Kelly Sue DeConnick' , null, 6, null);
803INSERT INTO author ("name", "date", id_country, biography) VALUES ('Alex  Sinclair' , null, 7, 'Alex Sinclair is a thirty-two-');
804INSERT INTO author ("name", "date", id_country, biography) VALUES ('Maria Jesus Merino Sanz' , null, 6, null);
805INSERT INTO author ("name", "date", id_country, biography) VALUES ('Gary Frank' , null, 7, null);
806INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jeph Loeb' , '1958-01-29', 3, 'Joseph "Jeph" Loeb III is an E');
807INSERT INTO author ("name", "date", id_country, biography) VALUES ('Jonathan Hickman' , null, 5, 'It’s no small thing to die and');
808INSERT INTO author ("name", "date", id_country, biography) VALUES ('Dustin Weaver' , null, 12, 'Dustin Weaver is an American c');
809INSERT INTO author ("name", "date", id_country, biography) VALUES ('Christina Strain' , null, 11, null);
810INSERT INTO author ("name", "date", id_country, biography) VALUES ('Pete Woods' , null, 4, null);
811INSERT INTO author ("name", "date", id_country, biography) VALUES ('Sean Chen' , null, 3, null);
812INSERT INTO author ("name", "date", id_country, biography) VALUES ('James Robinson' , '1963-04-01', 8, 'James Robinson is a British wr');
813
814-- Category
815-----------------------------------------
816INSERT INTO category (TYPE) VALUES ('Children');
817INSERT INTO category (TYPE) VALUES ('Best-Sellers');
818INSERT INTO category (TYPE) VALUES ('Most-Searched');
819INSERT INTO category (TYPE) VALUES ('New-In');
820INSERT INTO category (TYPE) VALUES ('Classics');
821
822-----------------------------------------
823-- Genre
824-----------------------------------------
825
826INSERT INTO genre (id, TYPE) VALUES (1, 'Arts & Music');
827INSERT INTO genre (id, TYPE) VALUES (2, 'Biographies');
828INSERT INTO genre (id, TYPE) VALUES (3, 'Business');
829INSERT INTO genre (id, TYPE) VALUES (4, 'Kids');
830INSERT INTO genre (id, TYPE) VALUES (5, 'Comics');
831INSERT INTO genre (id, TYPE) VALUES (6, 'Computers & Tech');
832INSERT INTO genre (id, TYPE) VALUES (7, 'Cooking');
833INSERT INTO genre (id, TYPE) VALUES (8, 'Hoobies & Crafts');
834INSERT INTO genre (id, TYPE) VALUES (9, 'Edu & Reference');
835INSERT INTO genre (id, TYPE) VALUES (10, 'Gay & Lesbian');
836INSERT INTO genre (id, TYPE) VALUES (11, 'Health & Fitness');
837INSERT INTO genre (id, TYPE) VALUES (12, 'History');
838INSERT INTO genre (id, TYPE) VALUES (13, 'Home & Garden');
839INSERT INTO genre (id, TYPE) VALUES (14, 'Horror');
840INSERT INTO genre (id, TYPE) VALUES (15, 'Entertainment');
841INSERT INTO genre (id, TYPE) VALUES (16, 'Literature & Fiction');
842INSERT INTO genre (id, TYPE) VALUES (17, 'Medical');
843INSERT INTO genre (id, TYPE) VALUES (18, 'Mysteries');
844INSERT INTO genre (id, TYPE) VALUES (19, 'Parenting');
845INSERT INTO genre (id, TYPE) VALUES (20, 'Social Sciences');
846INSERT INTO genre (id, TYPE) VALUES (21, 'Religion');
847INSERT INTO genre (id, TYPE) VALUES (22, 'Romance');
848INSERT INTO genre (id, TYPE) VALUES (23, 'Science & Maths');
849INSERT INTO genre (id, TYPE) VALUES (24, 'Sci-Fi & Fantasy');
850INSERT INTO genre (id, TYPE) VALUES (25, 'Self-Help');
851INSERT INTO genre (id, TYPE) VALUES (26, 'Sports');
852INSERT INTO genre (id, TYPE) VALUES (27, 'Teen');
853INSERT INTO genre (id, TYPE) VALUES (28, 'Travel');
854INSERT INTO genre (id, TYPE) VALUES (29, 'True Crime');
855INSERT INTO genre (id, TYPE) VALUES (30, 'Westerns');
856
857-----------------------------------------
858-- Book
859-----------------------------------------
860INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785128484' , 'Silver Surfer: Requiem', 'https://images.gr-assets.com/books/1532787188m/1831334.jpg', 'For many years Norrin Radd has', '2007-12-19', 4.18, 'English', 'Marvel');
861INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0812511816' , 'The Eye of the World (The Wheel of Time, #1)', 'https://images.gr-assets.com/books/1337818095m/228665.jpg', 'The Wheel of Time turns and Ag', '1990-11-15', 4.19, 'English', 'Tor Books');
862INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0765350378' , 'Elantris (Elantris, #1)', 'https://images.gr-assets.com/books/1475740953m/68427.jpg', 'Elantris was the capital of Ar', '2006-05-30', 4.18, 'English', 'Tor Fantasy');
863INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0765330423' , 'The Alloy of Law (Mistborn, #4)', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Three hundred years after the ', '2011-11-08', 4.21, 'English', 'Tor Books');
864INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0765378558' , 'Shadows of Self (Mistborn, #5)', 'https://images.gr-assets.com/books/1435053013m/16065004.jpg', 'Shadows of Self shows M', '2015-10-06', 4.31, 'English', 'Tor Books');
865INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0765316897' , 'The Hero of Ages (Mistborn, #3)', 'https://images.gr-assets.com/books/1480717763m/2767793.jpg', 'Tricked into releasing the evi', '2008-10-14', 4.48, 'English', 'Tor Books');
866INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0575089938' , 'The Well of Ascension (Mistborn, #2)', 'https://images.gr-assets.com/books/1393698277m/6547260.jpg', 'Vin, the street urchin who has', '2009-12-10', 4.36, 'English', 'Gollancz');
867INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1473217857' , 'Skyward (Skyward, #1)', 'https://images.gr-assets.com/books/1531845177m/36642458.jpg', 'Defeated, crushed, and driven ', '2018-11-06', 4.55, 'English', 'Gollancz');
868INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0575089911' , 'The Final Empire (Mistborn, #1)', 'https://images.gr-assets.com/books/1314601971m/6547258.jpg', 'In a world where ash falls fro', '2009-10-01', 4.45, 'English', null);
869INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0553283685' , 'Hyperion (Hyperion Cantos, #1)', 'https://images.gr-assets.com/books/1405546838m/77566.jpg', 'On the world called Hyperion, ', null, 4.23, 'English', 'Bantam Spectra');
870INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401223478' , 'Superman: Whatever Happened to the Man of Tomorrow?', 'https://images.gr-assets.com/books/1320482904m/5563473.jpg', 'An unforgettable hardcover col', '2009-07-14', 4.12, 'English', 'DC Comics');
871INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0340952598' , 'Everything''s Eventual', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'In this eerie, enchanting comp', '2007-10-01', 3.96, null, 'Hodder');
872INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0340922745' , 'Cell', 'https://images.gr-assets.com/books/1328796605m/4477745.jpg', 'Witness Stephen King''s triumph', '2006-11-21', 3.65, 'English', 'Hodder & Stoughton');
873INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1857231589' , 'Rendezvous with Rama (Rama, #1)', 'https://images.gr-assets.com/books/1405456427m/112537.jpg', 'At first, only a few things ar', null, 4.08, 'English', null);
874INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0060855924' , 'The Color of Magic (Discworld, #1; Rincewind, #1)', 'https://images.gr-assets.com/books/1407111017m/34497.jpg', 'Terry Pratchett''s profoundly i', '2005-09-13', 3.99, 'English', 'Harper');
875INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0553803700' , 'I, Robot (Robot, #0.1)', 'https://images.gr-assets.com/books/1388321463m/41804.jpg', 'The three laws of Robotics:', '2004-06-01', 4.19, 'English', 'Spectra');
876INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1841954314' , 'The Crimson Petal and the White', 'https://images.gr-assets.com/books/1408937589m/40200.jpg', 'Sugar, 19, prostitute in Victo', '2003-09-11', 3.88, 'English', 'Canongate Books');
877INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1841954802' , 'Under the Skin', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'In this haunting, entrancing n', '2004-05-03', 3.73, 'English', 'Canongate Books Ltd');
878INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0393068471' , 'Packing for Mars: The Curious Science of Life in the Void', 'https://images.gr-assets.com/books/1290480157m/7237456.jpg', 'The best-selling autho', '2010-08-02', 3.94, 'English', 'W. W. Norton & Company');
879INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0804136572' , 'Ex-Heroes (Ex-Heroes, #1)', 'https://images.gr-assets.com/books/1360646185m/16479439.jpg', 'The first in a spectacularly g', '2013-02-26', 3.86, null, 'Crown Publishing Group');
880INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0385354304' , 'The Strange Library', 'https://images.gr-assets.com/books/1419549475m/23128304.jpg', 'From internationally acclai', '2014-12-02', 3.56, 'English', 'Knopf');
881INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('055341884X' , 'The Book of Strange New Things', 'https://images.gr-assets.com/books/1394824754m/20697435.jpg', 'A monumental, genre-defying no', null, 3.66, 'English', null);
882INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('150116340X' , 'Sleeping Beauties', 'https://images.gr-assets.com/books/1510335748m/34466922.jpg', 'In a future so real and near i', '2017-09-26', 3.74, 'English', 'Scribner');
883INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0062663119' , 'Strange Weather', 'https://images.gr-assets.com/books/1493845147m/34066621.jpg', 'A collection of four chilling ', '2017-10-24', 3.91, 'English', 'William Morrow');
884INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0340952253' , 'The Bachman Books', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'For years, readers wrote askin', '2007-06-14', 4.11, 'English', 'Hodder');
885INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0450411435' , 'It', 'https://images.gr-assets.com/books/1334416842m/830502.jpg', 'Welcome to Derry, Maine ...', '1987-10-01', 4.23, 'English', 'New English Library');
886INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401220797' , 'House of Mystery, Volume 1: Room and Boredom', 'https://images.gr-assets.com/books/1320519139m/3754399.jpg', 'Matthew Sturges, writer of the', '2009-01-20', 3.79, 'English', 'Vertigo');
887INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0452253802' , 'Creepshow', 'https://images.gr-assets.com/books/1332002598m/11580.jpg', 'Stories in comic strip form te', '1982-08-01', 4.07, 'English', 'Plume');
888INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1563892618' , 'Preacher, Volume 1: Gone to Texas', 'https://images.gr-assets.com/books/1309914494m/95431.jpg', 'One of the most celebrated com', '1996-03-01', 4.14, 'English', 'Vertigo');
889INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401226388' , 'Superman: Nightwing and Flamebird, Vol. 1', 'https://images.gr-assets.com/books/1348945375m/6665175.jpg', 'Following the startling events', '2010-03-23', 3.33, 'English', 'DC Comics');
890INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401225683' , 'The Flash: Rebirth', 'https://images.gr-assets.com/books/1320436138m/6476516.jpg', 'Geoff Johns and Ethan Van Sciv', '2010-05-04', 3.94, 'English', 'DC Comics');
891INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785123148' , 'Civil War: Iron Man', 'https://images.gr-assets.com/books/1506416566m/106036.jpg', 'Two tales of suspense ripped f', '2007-06-06', 4.11, 'English', 'Marvel');
892INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785120181' , 'Young Avengers, Volume 1: Sidekicks', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'In the wake of Avengers Dis', '2006-04-19', 4.15, 'English', 'Marvel');
893INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785109609' , 'The Ultimates, Volume 1: Super-Human', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Nick Fury, head of an elite es', '2006-04-12', 4.11, 'English', 'Marvel');
894INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785122583' , 'Iron Man: Extremis', 'https://images.gr-assets.com/books/1503693014m/43739.jpg', 'It''s the beginning of a new er', '2007-02-14', 4.08, 'English', 'Marvel');
895INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785134603' , 'The Invincible Iron Man, Volume 1: The Five Nightmares', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Tony Stark - Iron Man, billion', '2008-12-17', 4.11, 'English', 'Marvel');
896INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785118764' , 'Runaways Deluxe, Vol. 1', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'In Pride & Joy, six young ', '2006-08-09', 4.21, 'English', 'Marvel');
897INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401204821' , 'Legion of Super-Heroes, Vol. 1: Teenage Revolution', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'An amazing collection featurin', '2005-12-01', 3.83, 'English', 'DC Comics');
898INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785121013' , 'The Uncanny X-Men Omnibus, Vol. 1', 'https://images.gr-assets.com/books/1523441940m/598918.jpg', 'Collects Giant Size X-Men #1, ', '2006-09-01', 4.36, 'English', 'Marvel Comics Group');
899INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785122788' , 'NextWave: Agents of H.A.T.E., Vol. 1: This is What They Want', 'https://images.gr-assets.com/books/1547944291m/43725.jpg', 'The Highest Anti-Terrorism Eff', '2006-09-13', 4.17, 'English', 'Marvel Comics Group');
900INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785125116' , 'Annihilation, Book One', 'https://images.gr-assets.com/books/1424200099m/298472.jpg', 'The epic collection of the cos', '2007-03-07', 3.99, 'English', 'Marvel');
901INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1563899426' , 'Fables, Vol. 1: Legends in Exile', 'https://images.gr-assets.com/books/1375392441m/21326.jpg', 'When a savage creature known o', '2002-12-31', 3.97, 'English', 'Vertigo');
902INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401227015' , 'Absolute Planetary Book Two', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Collects issues 13-27 of the o', '2010-07-20', 4.52, 'English', 'WildStorm');
903INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785151834' , 'The Thanos Imperative', 'https://images.gr-assets.com/books/1525077112m/9222916.jpg', 'Thanos is back! A war has i', '2011-03-16', 4.06, 'English', 'Marvel');
904INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('078514840X' , 'Journey into Mystery: Fear Itself', 'https://images.gr-assets.com/books/1526831387m/11596962.jpg', 'The shadow of Fear Itself loom', '2012-02-01', 4.16, 'English', 'Marvel Comics');
905INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785144943' , 'Avengers Academy, Volume 1: Permanent Record', 'https://images.gr-assets.com/books/1344271538m/8862456.jpg', 'Determined to keep the traditi', '2011-02-09', 3.86, 'English', 'Marvel');
906INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('078514269X' , 'Thor, by J. Michael Straczynski, Volume 3', 'https://images.gr-assets.com/books/1417281057m/7028202.jpg', 'Has Thor turned his back on As', '2010-02-03', 4.05, 'English', 'Marvel');
907INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785145990' , 'Secret Avengers, Volume 1: Mission to Mars', 'https://images.gr-assets.com/books/1504457891m/8962093.jpg', 'Who are the Secret Avengers? A', '2011-02-02', 3.71, 'English', 'Marvel');
908INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401232817' , 'Green Lantern Corps, Volume 8: The Weaponer', 'https://images.gr-assets.com/books/1341804136m/11025097.jpg', 'The Qwardian known as The Weap', '2011-10-04', 3.64, 'English', 'DC Comics');
909INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401232345' , 'War of the Green Lanterns', 'https://images.gr-assets.com/books/1344739832m/11186458.jpg', 'A malevolent force has usurped', '2011-11-22', 4.00, 'English', 'DC Comics');
910INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401230792' , 'Green Lantern: Emerald Warriors', 'https://images.gr-assets.com/books/1333579914m/10267585.jpg', 'Green Lanterns Guy Gardner, Ki', '2011-08-16', 3.69, 'English', 'DC Comics');
911INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401230830' , 'Brightest Day, Vol. 2', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Comics hottest writer Geoff Jo', '2011-05-10', 3.69, 'English', 'DC Comics');
912INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401230733' , 'Green Arrow: Into the Woods', 'https://images.gr-assets.com/books/1320565698m/9695203.jpg', 'Once the self-centered billion', '2011-07-12', 3.80, 'English', 'DC Comics');
913INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401230202' , 'Justice League: Generation Lost, Vol. 1', 'https://images.gr-assets.com/books/1359476688m/8751729.jpg', 'Members of the original JUSTIC', '2011-04-19', 3.95, 'English', 'DC Comics');
914INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401217877' , 'Booster Gold, Vol. 1: 52 Pick-Up', 'https://images.gr-assets.com/books/1343772628m/2183274.jpg', 'Originally published in single', '2008-05-20', 4.05, 'English', 'DC Comics');
915INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401234712' , 'Frankenstein, Agent of S.H.A.D.E., Volume 1: War of the Monsters', 'https://images.gr-assets.com/books/1342232321m/13227731.jpg', 'As a part of the acclaimed DC ', '2012-06-26', 3.42, 'English', 'DC Comics');
916INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785122818' , 'Ms. Marvel, Volume 1: Best of the Best', 'https://images.gr-assets.com/books/1550546248m/422581.jpg', 'Straight out of the pages of ', '2006-10-04', 3.79, 'wak', 'Marvel');
917INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('140123142X' , 'Batgirl, Volume 2: The Flood', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Batgirl must stop The Calcu', null, 4.23, 'English', null);
918INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401229689' , 'Batman: The Return of Bruce Wayne (Batman by Morrison #10)', 'https://images.gr-assets.com/books/1320544991m/8544958.jpg', 'Grant Morrison’s best-selling ', '2011-02-08', 3.49, 'English', 'DC Comics');
919INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401231454' , 'Batman: Under the Red Hood', 'https://images.gr-assets.com/books/1526770643m/9408670.jpg', 'Batman is confronted with a hi', '2011-08-30', 4.35, 'English', 'DC Comics');
920INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('140123206X' , 'Batman: The Black Mirror', 'https://images.gr-assets.com/books/1503127212m/10889279.jpg', 'A NEW YORK TIMES #1 Bestsel', '2011-11-23', 4.28, 'English', null);
921INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401234062' , 'Flashpoint: The World of Flashpoint Featuring Green Lantern', 'https://images.gr-assets.com/books/1508900281m/12397228.jpg', 'Not a dream, not an imaginary ', '2012-03-27', 3.57, 'English', 'DC Comics');
922INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401207529' , 'Batman: Year One', 'https://images.gr-assets.com/books/1526768987m/59980.jpg', 'Lieutenant James Gordon takes ', null, 4.21, 'English', 'DC Comics');
923INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401234348' , 'Flashpoint: The World of Flashpoint Featuring Superman', 'https://images.gr-assets.com/books/1418059291m/12470593.jpg', 'Don''t miss this Superman volum', '2012-03-20', 3.64, 'English', 'DC Comics');
924INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785108114' , 'New X-Men, Volume 1: E Is for Extinction', 'https://images.gr-assets.com/books/1374683546m/22351.jpg', 'Cassandra Nova has murdered 16', '2006-09-27', 4.06, 'English', 'Marvel');
925INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('156389551X' , 'Astro City, Vol. 1: Life in the Big City', 'https://images.gr-assets.com/books/1468008741m/72111.jpg', 'Volumes 1-6 of Kurt Busiek''s A', '1999-06-23', 4.11, 'English', 'WildStorm');
926INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1563890348' , 'Doom Patrol, Vol. 1: Crawling from the Wreckage', 'https://images.gr-assets.com/books/1543991820m/22355.jpg', 'The first collection of Grant ', '2000-04-17', 4.09, 'English', 'Vertigo');
927INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0446606693' , 'Kingdom Come', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'This is a novelization of the ', '1999-09-01', 4.47, 'English', 'Aspect');
928INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('034551162X' , 'Aftermath (Star Wars: Aftermath, #1)', 'https://images.gr-assets.com/books/1426622433m/25134015.jpg', 'New York Times Bestsell', '2015-09-04', 3.19, 'English', 'Del Rey');
929INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401238424' , 'Green Arrow, Volume 2: Triple Threat', 'https://images.gr-assets.com/books/1360000501m/15794740.jpg', 'The stress of running a multi-', '2013-01-29', 2.69, 'English', 'DC Comics');
930INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401237150' , 'Captain Atom, Vol. 1: Evolution', 'https://images.gr-assets.com/books/1351213334m/13536828.jpg', 'As a part of DC Comics - The N', '2012-12-04', 3.44, 'English', 'DC Comics');
931INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401238475' , 'Red Lanterns, Volume 2: The Death of the Red Lanterns', 'https://images.gr-assets.com/books/1521808083m/15798411.jpg', 'The Red Spectrum of Rage is th', '2013-03-12', 3.56, 'English', 'DC Comics');
932INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401237061' , 'The Savage Hawkman, Volume 1: Darkness Rising', 'https://images.gr-assets.com/books/1551679326m/13532154.jpg', 'As a part of the acclaimed ', '2012-10-30', 3.16, 'English', 'DC Comics');
933INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401234089' , 'Flashpoint: The World of Flashpoint Featuring The Flash', 'https://images.gr-assets.com/books/1508900084m/12470592.jpg', 'Don''t miss this Flash volume c', '2012-03-27', 3.72, 'English', 'DC Comics');
934INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401234852' , 'Superboy, Vol. 1: Incubation', 'https://images.gr-assets.com/books/1344368671m/13531010.jpg', 'As a part of the acclaimed DC ', '2012-08-07', 3.58, 'English', 'DC Comics');
935INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401237754' , 'Dial H, Vol. 1: Into You', 'https://images.gr-assets.com/books/1362466457m/15799191.jpg', 'Hugo Award-winning novelist Ch', '2013-04-23', 3.56, 'English', 'DC Comics');
936INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401234836' , 'Stormwatch, Volume 1: The Dark Side', 'https://images.gr-assets.com/books/1338260849m/13228445.jpg', 'As a part of the acclaimed ', '2012-05-01', 3.32, 'English', 'DC Comics');
937INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785148949' , 'S.H.I.E.L.D.: Architects of Forever', 'https://images.gr-assets.com/books/1344268469m/9433132.jpg', 'Leonardo Da Vinci was an agent', '2011-05-04', 3.88, 'English', 'Marvel Comics Group');
938INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1401230334' , 'Superman: The Black Ring Vol. 1', 'https://images.gr-assets.com/books/1341981307m/9013623.jpg', 'When Lex Luthor finally regain', '2011-04-05', 3.70, 'English', 'DC Comics');
939INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('140122329X' , 'Superman: New Krypton, Vol. 1', 'https://images.gr-assets.com/books/1343751285m/5141027.jpg', 'Best-selling writers Geoff Joh', '2009-05-19', 3.42, 'English', 'DC Comics');
940INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785155082' , 'X-Men: Age of Apocalypse Prelude', 'https://images.gr-assets.com/books/1359391662m/9839249.jpg', 'Legion, the supremely powerful', '2011-06-01', 3.96, 'English', 'Marvel');
941INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1596873434' , 'Crisis on Infinite Earths', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'A spectacular and original nov', null, 4.04, null, null);
942INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1563896613' , 'The Authority, Vol. 1: Relentless', 'https://images.gr-assets.com/books/1518640805m/546887.jpg', 'The Authority, the powerful te', '2000-05-01', 4.15, 'English', 'WildStorm');
943INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1405088834' , 'The Temporal Void', 'https://images.gr-assets.com/books/1357349093m/3437328.jpg', 'The Intersolar Commonwealth is', '2008-10-03', 4.25, 'English', 'Macmillan');
944INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0345496574' , 'The Evolutionary Void', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Exposed as the Second Dreamer,', '2010-08-24', 4.27, 'English', 'Del Rey');
945INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0345496531' , 'The Dreaming Void', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'The year is 3589, fifteen hund', null, 4.18, 'English', null);
946INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0345461665' , 'Judas Unchained', 'https://images.gr-assets.com/books/1316501189m/45244.jpg', 'Robust, peaceful, and confiden', null, 4.31, 'English', null);
947INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0345461622' , 'Pandora''s Star', 'https://images.gr-assets.com/books/1440699949m/45252.jpg', 'The year is 2380. The Intersol', '2005-03-02', 4.24, 'English', 'Del Rey');
948INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1476754454' , 'Mr. Mercedes (Bill Hodges Trilogy, #1)', 'https://images.gr-assets.com/books/1468705326m/18775247.jpg', 'Now an AT&T Audience Or', '2014-06-03', 3.95, 'English', 'Scribner');
949INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0062200577' , 'NOS4A2', 'https://images.gr-assets.com/books/1369591617m/15729539.jpg', 'NOS4A2 is a spine-tingling nov', '2013-04-30', 4.07, 'English', 'William Morrow');
950INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0061147958' , 'Horns', 'https://images.gr-assets.com/books/1402958805m/6587879.jpg', 'Ignatius Perrish spent the nig', '2010-03-01', 3.92, 'English', 'William Morrow');
951INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0393970124' , 'Dracula', 'https://images.gr-assets.com/books/1387151694m/17245.jpg', 'You can find an alternative', '1986-05-12', 3.99, 'English', 'Norton');
952INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('1934964387' , 'Scott Pilgrim, Vol. 6: Scott Pilgrim''s Finest Hour', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'It''s finally here! Six years a', '2010-07-20', 4.41, 'English', 'Oni Press');
953INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785132619' , 'Kick-Ass', 'https://images.gr-assets.com/books/1548168706m/3918010.jpg', 'Have you ever really wanted to', '2011-07-20', 4.05, 'English', 'Marvel Comics');
954INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785117644' , 'The Amazing Spider-Man, Vol. 10: New Avengers', 'https://images.gr-assets.com/books/1505583591m/234042.jpg', 'Trump Tower has nothing on Spi', '2006-02-08', 4.15, 'English', 'Marvel');
955INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785108203' , 'Ultimate Spider-Man, Volume 2: Learning Curve', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'Collects Ultimate Spider-Man (', '2007-04-04', 4.17, 'English', 'Marvel');
956INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785108777' , 'The Amazing Spider-Man, Vol. 2: Revelations', 'https://images.gr-assets.com/books/1505583407m/707695.jpg', 'In the wake of the World Trade', '2002-09-06', 4.20, 'English', 'Marvel Comics');
957INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785119280' , 'Ultimate Spider-Man, Volume 17: Clone Saga', 'https://s.gr-assets.com/assets/nophoto/book/111x148-bcc042a9c91a29c1d680899eff700a03.png', 'As Peter Parker tries to sort ', '2007-09-05', 4.11, 'English', 'Marvel');
958INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785121889' , 'Spider-Man: The Other', 'https://images.gr-assets.com/books/1505583800m/476459.jpg', 'The startling super-story t', '2006-05-31', 3.74, 'English', 'Marvel');
959INSERT INTO book (isbn, title, photo, description, publication_date, rating, language, publisher) VALUES ('0785121897' , 'Civil War: Peter Parker, Spider-Man', 'https://images.gr-assets.com/books/1531192754m/97045.jpg', 'The War has begun, sides have ', '2007-05-23', 4.08, 'English', 'Marvel');
960
961-----------------------------------------
962-- Item
963-----------------------------------------
964INSERT INTO item (id_book, id_seller, price, quality) VALUES (100, 70, 38.89, 'Good');
965INSERT INTO item (id_book, id_seller, price, quality) VALUES (98, 73, 35.30, 'Bad');
966INSERT INTO item (id_book, id_seller, price, quality) VALUES (17, 57, 3.22, 'Good');
967INSERT INTO item (id_book, id_seller, price, quality) VALUES (53, 56, 48.72, 'Good');
968INSERT INTO item (id_book, id_seller, price, quality) VALUES (100, 90, 18.17, 'Good');
969INSERT INTO item (id_book, id_seller, price, quality) VALUES (98, 91, 4.54, 'Excelent');
970INSERT INTO item (id_book, id_seller, price, quality) VALUES (98, 91, 14.98, 'Good');
971INSERT INTO item (id_book, id_seller, price, quality) VALUES (25, 57, 37.60, 'Good');
972INSERT INTO item (id_book, id_seller, price, quality) VALUES (99, 57, 3.50, 'Good');
973INSERT INTO item (id_book, id_seller, price, quality) VALUES (100, 73, 12.89, 'Good');
974INSERT INTO item (id_book, id_seller, price, quality) VALUES (100, 101, 12.89, 'Good');
975INSERT INTO item (id_book, id_seller, price, quality) VALUES (61, 101, 12.89, 'Good');
976
977-----------------------------------------
978-- Order
979-----------------------------------------
980INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (62, 100,'New', 38.89);
981INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (61, 98, 'New', 35.30);
982INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (92, 17, 'New', 3.22);
983INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (85, 53,'Delivered', 48.72);
984INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (99, 100, 'Hold', 18.17);
985INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (90, 98, 'Closed', 4.54);
986INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (77, 98, 'Delivered', 14.98);
987INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (63, 25, 'Hold', 37.60);
988INSERT INTO "order" (id_buyer, id_book, TYPE, price) VALUES (88, 99, 'Shipped', 3.50);
989
990-----------------------------------------
991-- Ban
992-----------------------------------------
993INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (1, 18,'2017-05-12', '2020-09-29', 'Insulting member');
994INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (1, 24,'2015-12-02', '2022-11-03', 'Didn''t ship a selled book');
995INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (2, 29,'2018-04-17', '2021-09-03', 'Didn''t ship a selled book');
996INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (2, 13,'2015-01-21', '2030-01-18', 'Send book with obscenities written');
997INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (3, 24,'2018-01-11', '2020-02-16', 'Didn''t ship a selled book');
998INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (3, 23,'2016-09-17', '2019-11-07', 'Insulting member');
999INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (2, 28,'2018-07-04', '2019-07-09', 'Didn''t ship a selled book');
1000INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (1, 13,'2018-03-08', '2021-07-02', 'Phishing');
1001INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (3, 27,'2018-10-06', '2020-12-01', 'Insulting member');
1002INSERT INTO ban (id_admin, id_banned, start_date, end_date, reason) VALUES (2, 19,'2016-11-08', '2021-07-19', 'Insulting member');
1003
1004
1005-----------------------------------------
1006-- Banned
1007-----------------------------------------
1008INSERT INTO banned (id_member) VALUES (18);
1009INSERT INTO banned (id_member) VALUES (55);
1010INSERT INTO banned (id_member) VALUES (29);
1011INSERT INTO banned (id_member) VALUES (13);
1012INSERT INTO banned (id_member) VALUES (24);
1013INSERT INTO banned (id_member) VALUES (23);
1014INSERT INTO banned (id_member) VALUES (28);
1015INSERT INTO banned (id_member) VALUES (67);
1016INSERT INTO banned (id_member) VALUES (27);
1017INSERT INTO banned (id_member) VALUES (19);
1018
1019
1020
1021-----------------------------------------
1022-- Belongs_c
1023-----------------------------------------
1024INSERT INTO belongs_c (id_book, id_category) VALUES (1, 5);
1025INSERT INTO belongs_c (id_book, id_category) VALUES (2, 1);
1026INSERT INTO belongs_c (id_book, id_category) VALUES (3, 1);
1027INSERT INTO belongs_c (id_book, id_category) VALUES (4, 2);
1028INSERT INTO belongs_c (id_book, id_category) VALUES (5, 4);
1029INSERT INTO belongs_c (id_book, id_category) VALUES (6, 1);
1030INSERT INTO belongs_c (id_book, id_category) VALUES (7, 1);
1031INSERT INTO belongs_c (id_book, id_category) VALUES (8, 2);
1032INSERT INTO belongs_c (id_book, id_category) VALUES (9, 1);
1033INSERT INTO belongs_c (id_book, id_category) VALUES (10, 1);
1034INSERT INTO belongs_c (id_book, id_category) VALUES (11, 2);
1035INSERT INTO belongs_c (id_book, id_category) VALUES (12, 5);
1036INSERT INTO belongs_c (id_book, id_category) VALUES (13, 3);
1037INSERT INTO belongs_c (id_book, id_category) VALUES (14, 5);
1038INSERT INTO belongs_c (id_book, id_category) VALUES (15, 3);
1039INSERT INTO belongs_c (id_book, id_category) VALUES (16, 4);
1040INSERT INTO belongs_c (id_book, id_category) VALUES (17, 3);
1041INSERT INTO belongs_c (id_book, id_category) VALUES (18, 5);
1042INSERT INTO belongs_c (id_book, id_category) VALUES (19, 5);
1043INSERT INTO belongs_c (id_book, id_category) VALUES (20, 1);
1044INSERT INTO belongs_c (id_book, id_category) VALUES (21, 4);
1045INSERT INTO belongs_c (id_book, id_category) VALUES (22, 5);
1046INSERT INTO belongs_c (id_book, id_category) VALUES (23, 2);
1047INSERT INTO belongs_c (id_book, id_category) VALUES (24, 5);
1048INSERT INTO belongs_c (id_book, id_category) VALUES (25, 5);
1049INSERT INTO belongs_c (id_book, id_category) VALUES (26, 4);
1050INSERT INTO belongs_c (id_book, id_category) VALUES (27, 4);
1051INSERT INTO belongs_c (id_book, id_category) VALUES (28, 5);
1052INSERT INTO belongs_c (id_book, id_category) VALUES (29, 4);
1053INSERT INTO belongs_c (id_book, id_category) VALUES (30, 3);
1054INSERT INTO belongs_c (id_book, id_category) VALUES (31, 3);
1055INSERT INTO belongs_c (id_book, id_category) VALUES (32, 5);
1056INSERT INTO belongs_c (id_book, id_category) VALUES (33, 4);
1057INSERT INTO belongs_c (id_book, id_category) VALUES (34, 1);
1058INSERT INTO belongs_c (id_book, id_category) VALUES (35, 4);
1059INSERT INTO belongs_c (id_book, id_category) VALUES (36, 3);
1060INSERT INTO belongs_c (id_book, id_category) VALUES (37, 2);
1061INSERT INTO belongs_c (id_book, id_category) VALUES (38, 1);
1062INSERT INTO belongs_c (id_book, id_category) VALUES (39, 5);
1063INSERT INTO belongs_c (id_book, id_category) VALUES (40, 4);
1064INSERT INTO belongs_c (id_book, id_category) VALUES (41, 5);
1065INSERT INTO belongs_c (id_book, id_category) VALUES (42, 2);
1066INSERT INTO belongs_c (id_book, id_category) VALUES (43, 2);
1067INSERT INTO belongs_c (id_book, id_category) VALUES (44, 2);
1068INSERT INTO belongs_c (id_book, id_category) VALUES (45, 2);
1069INSERT INTO belongs_c (id_book, id_category) VALUES (46, 4);
1070INSERT INTO belongs_c (id_book, id_category) VALUES (47, 4);
1071INSERT INTO belongs_c (id_book, id_category) VALUES (48, 4);
1072INSERT INTO belongs_c (id_book, id_category) VALUES (49, 5);
1073INSERT INTO belongs_c (id_book, id_category) VALUES (50, 2);
1074INSERT INTO belongs_c (id_book, id_category) VALUES (51, 2);
1075INSERT INTO belongs_c (id_book, id_category) VALUES (52, 2);
1076INSERT INTO belongs_c (id_book, id_category) VALUES (53, 4);
1077INSERT INTO belongs_c (id_book, id_category) VALUES (54, 2);
1078INSERT INTO belongs_c (id_book, id_category) VALUES (55, 4);
1079INSERT INTO belongs_c (id_book, id_category) VALUES (56, 2);
1080INSERT INTO belongs_c (id_book, id_category) VALUES (57, 1);
1081INSERT INTO belongs_c (id_book, id_category) VALUES (58, 2);
1082INSERT INTO belongs_c (id_book, id_category) VALUES (59, 5);
1083INSERT INTO belongs_c (id_book, id_category) VALUES (60, 4);
1084INSERT INTO belongs_c (id_book, id_category) VALUES (61, 3);
1085INSERT INTO belongs_c (id_book, id_category) VALUES (62, 1);
1086INSERT INTO belongs_c (id_book, id_category) VALUES (63, 5);
1087INSERT INTO belongs_c (id_book, id_category) VALUES (64, 3);
1088INSERT INTO belongs_c (id_book, id_category) VALUES (65, 1);
1089INSERT INTO belongs_c (id_book, id_category) VALUES (66, 1);
1090INSERT INTO belongs_c (id_book, id_category) VALUES (67, 5);
1091INSERT INTO belongs_c (id_book, id_category) VALUES (68, 4);
1092INSERT INTO belongs_c (id_book, id_category) VALUES (69, 4);
1093INSERT INTO belongs_c (id_book, id_category) VALUES (70, 1);
1094INSERT INTO belongs_c (id_book, id_category) VALUES (71, 2);
1095INSERT INTO belongs_c (id_book, id_category) VALUES (72, 1);
1096INSERT INTO belongs_c (id_book, id_category) VALUES (73, 3);
1097INSERT INTO belongs_c (id_book, id_category) VALUES (74, 5);
1098INSERT INTO belongs_c (id_book, id_category) VALUES (75, 3);
1099INSERT INTO belongs_c (id_book, id_category) VALUES (76, 3);
1100INSERT INTO belongs_c (id_book, id_category) VALUES (77, 1);
1101INSERT INTO belongs_c (id_book, id_category) VALUES (78, 5);
1102INSERT INTO belongs_c (id_book, id_category) VALUES (79, 5);
1103INSERT INTO belongs_c (id_book, id_category) VALUES (80, 3);
1104INSERT INTO belongs_c (id_book, id_category) VALUES (81, 3);
1105INSERT INTO belongs_c (id_book, id_category) VALUES (82, 1);
1106INSERT INTO belongs_c (id_book, id_category) VALUES (83, 3);
1107INSERT INTO belongs_c (id_book, id_category) VALUES (84, 5);
1108INSERT INTO belongs_c (id_book, id_category) VALUES (85, 4);
1109INSERT INTO belongs_c (id_book, id_category) VALUES (86, 3);
1110INSERT INTO belongs_c (id_book, id_category) VALUES (87, 5);
1111INSERT INTO belongs_c (id_book, id_category) VALUES (88, 1);
1112INSERT INTO belongs_c (id_book, id_category) VALUES (89, 5);
1113INSERT INTO belongs_c (id_book, id_category) VALUES (90, 1);
1114INSERT INTO belongs_c (id_book, id_category) VALUES (91, 3);
1115INSERT INTO belongs_c (id_book, id_category) VALUES (92, 4);
1116INSERT INTO belongs_c (id_book, id_category) VALUES (93, 1);
1117INSERT INTO belongs_c (id_book, id_category) VALUES (94, 4);
1118INSERT INTO belongs_c (id_book, id_category) VALUES (95, 1);
1119INSERT INTO belongs_c (id_book, id_category) VALUES (96, 3);
1120INSERT INTO belongs_c (id_book, id_category) VALUES (97, 5);
1121INSERT INTO belongs_c (id_book, id_category) VALUES (98, 2);
1122INSERT INTO belongs_c (id_book, id_category) VALUES (99, 2);
1123INSERT INTO belongs_c (id_book, id_category) VALUES (100, 1);
1124
1125-----------------------------------------
1126-- Belongs_g
1127-----------------------------------------
1128INSERT INTO belongs_g (id_book, id_genre) VALUES (1, 9);
1129INSERT INTO belongs_g (id_book, id_genre) VALUES (2, 28);
1130INSERT INTO belongs_g (id_book, id_genre) VALUES (3, 14);
1131INSERT INTO belongs_g (id_book, id_genre) VALUES (4, 13);
1132INSERT INTO belongs_g (id_book, id_genre) VALUES (5, 24);
1133INSERT INTO belongs_g (id_book, id_genre) VALUES (6, 24);
1134INSERT INTO belongs_g (id_book, id_genre) VALUES (7, 7);
1135INSERT INTO belongs_g (id_book, id_genre) VALUES (8, 7);
1136INSERT INTO belongs_g (id_book, id_genre) VALUES (9, 3);
1137INSERT INTO belongs_g (id_book, id_genre) VALUES (10, 10);
1138INSERT INTO belongs_g (id_book, id_genre) VALUES (11, 11);
1139INSERT INTO belongs_g (id_book, id_genre) VALUES (12, 26);
1140INSERT INTO belongs_g (id_book, id_genre) VALUES (13, 6);
1141INSERT INTO belongs_g (id_book, id_genre) VALUES (14, 19);
1142INSERT INTO belongs_g (id_book, id_genre) VALUES (15, 3);
1143INSERT INTO belongs_g (id_book, id_genre) VALUES (16, 18);
1144INSERT INTO belongs_g (id_book, id_genre) VALUES (17, 10);
1145INSERT INTO belongs_g (id_book, id_genre) VALUES (18, 2);
1146INSERT INTO belongs_g (id_book, id_genre) VALUES (19, 30);
1147INSERT INTO belongs_g (id_book, id_genre) VALUES (20, 25);
1148INSERT INTO belongs_g (id_book, id_genre) VALUES (21, 4);
1149INSERT INTO belongs_g (id_book, id_genre) VALUES (22, 13);
1150INSERT INTO belongs_g (id_book, id_genre) VALUES (23, 21);
1151INSERT INTO belongs_g (id_book, id_genre) VALUES (24, 4);
1152INSERT INTO belongs_g (id_book, id_genre) VALUES (25, 1);
1153INSERT INTO belongs_g (id_book, id_genre) VALUES (26, 17);
1154INSERT INTO belongs_g (id_book, id_genre) VALUES (27, 30);
1155INSERT INTO belongs_g (id_book, id_genre) VALUES (28, 5);
1156INSERT INTO belongs_g (id_book, id_genre) VALUES (29, 5);
1157INSERT INTO belongs_g (id_book, id_genre) VALUES (30, 18);
1158INSERT INTO belongs_g (id_book, id_genre) VALUES (31, 9);
1159INSERT INTO belongs_g (id_book, id_genre) VALUES (32, 11);
1160INSERT INTO belongs_g (id_book, id_genre) VALUES (33, 12);
1161INSERT INTO belongs_g (id_book, id_genre) VALUES (34, 9);
1162INSERT INTO belongs_g (id_book, id_genre) VALUES (35, 30);
1163INSERT INTO belongs_g (id_book, id_genre) VALUES (36, 25);
1164INSERT INTO belongs_g (id_book, id_genre) VALUES (37, 26);
1165INSERT INTO belongs_g (id_book, id_genre) VALUES (38, 15);
1166INSERT INTO belongs_g (id_book, id_genre) VALUES (39, 5);
1167INSERT INTO belongs_g (id_book, id_genre) VALUES (40, 9);
1168INSERT INTO belongs_g (id_book, id_genre) VALUES (41, 8);
1169INSERT INTO belongs_g (id_book, id_genre) VALUES (42, 17);
1170INSERT INTO belongs_g (id_book, id_genre) VALUES (43, 29);
1171INSERT INTO belongs_g (id_book, id_genre) VALUES (44, 29);
1172INSERT INTO belongs_g (id_book, id_genre) VALUES (45, 8);
1173INSERT INTO belongs_g (id_book, id_genre) VALUES (46, 23);
1174INSERT INTO belongs_g (id_book, id_genre) VALUES (47, 28);
1175INSERT INTO belongs_g (id_book, id_genre) VALUES (48, 27);
1176INSERT INTO belongs_g (id_book, id_genre) VALUES (49, 19);
1177INSERT INTO belongs_g (id_book, id_genre) VALUES (50, 28);
1178INSERT INTO belongs_g (id_book, id_genre) VALUES (51, 20);
1179INSERT INTO belongs_g (id_book, id_genre) VALUES (52, 1);
1180INSERT INTO belongs_g (id_book, id_genre) VALUES (53, 20);
1181INSERT INTO belongs_g (id_book, id_genre) VALUES (54, 8);
1182INSERT INTO belongs_g (id_book, id_genre) VALUES (55, 7);
1183INSERT INTO belongs_g (id_book, id_genre) VALUES (56, 30);
1184INSERT INTO belongs_g (id_book, id_genre) VALUES (57, 11);
1185INSERT INTO belongs_g (id_book, id_genre) VALUES (58, 13);
1186INSERT INTO belongs_g (id_book, id_genre) VALUES (59, 6);
1187INSERT INTO belongs_g (id_book, id_genre) VALUES (60, 27);
1188INSERT INTO belongs_g (id_book, id_genre) VALUES (61, 29);
1189INSERT INTO belongs_g (id_book, id_genre) VALUES (62, 26);
1190INSERT INTO belongs_g (id_book, id_genre) VALUES (63, 25);
1191INSERT INTO belongs_g (id_book, id_genre) VALUES (64, 3);
1192INSERT INTO belongs_g (id_book, id_genre) VALUES (65, 18);
1193INSERT INTO belongs_g (id_book, id_genre) VALUES (66, 22);
1194INSERT INTO belongs_g (id_book, id_genre) VALUES (67, 4);
1195INSERT INTO belongs_g (id_book, id_genre) VALUES (68, 2);
1196INSERT INTO belongs_g (id_book, id_genre) VALUES (69, 17);
1197INSERT INTO belongs_g (id_book, id_genre) VALUES (70, 17);
1198INSERT INTO belongs_g (id_book, id_genre) VALUES (71, 14);
1199INSERT INTO belongs_g (id_book, id_genre) VALUES (72, 23);
1200INSERT INTO belongs_g (id_book, id_genre) VALUES (73, 15);
1201INSERT INTO belongs_g (id_book, id_genre) VALUES (74, 9);
1202INSERT INTO belongs_g (id_book, id_genre) VALUES (75, 7);
1203INSERT INTO belongs_g (id_book, id_genre) VALUES (76, 20);
1204INSERT INTO belongs_g (id_book, id_genre) VALUES (77, 4);
1205INSERT INTO belongs_g (id_book, id_genre) VALUES (78, 12);
1206INSERT INTO belongs_g (id_book, id_genre) VALUES (79, 1);
1207INSERT INTO belongs_g (id_book, id_genre) VALUES (80, 7);
1208INSERT INTO belongs_g (id_book, id_genre) VALUES (81, 15);
1209INSERT INTO belongs_g (id_book, id_genre) VALUES (82, 1);
1210INSERT INTO belongs_g (id_book, id_genre) VALUES (83, 29);
1211INSERT INTO belongs_g (id_book, id_genre) VALUES (84, 3);
1212INSERT INTO belongs_g (id_book, id_genre) VALUES (85, 13);
1213INSERT INTO belongs_g (id_book, id_genre) VALUES (86, 13);
1214INSERT INTO belongs_g (id_book, id_genre) VALUES (87, 22);
1215INSERT INTO belongs_g (id_book, id_genre) VALUES (88, 10);
1216INSERT INTO belongs_g (id_book, id_genre) VALUES (89, 11);
1217INSERT INTO belongs_g (id_book, id_genre) VALUES (90, 6);
1218INSERT INTO belongs_g (id_book, id_genre) VALUES (91, 16);
1219INSERT INTO belongs_g (id_book, id_genre) VALUES (92, 5);
1220INSERT INTO belongs_g (id_book, id_genre) VALUES (93, 3);
1221INSERT INTO belongs_g (id_book, id_genre) VALUES (94, 1);
1222INSERT INTO belongs_g (id_book, id_genre) VALUES (95, 19);
1223INSERT INTO belongs_g (id_book, id_genre) VALUES (96, 8);
1224INSERT INTO belongs_g (id_book, id_genre) VALUES (97, 11);
1225INSERT INTO belongs_g (id_book, id_genre) VALUES (98, 4);
1226INSERT INTO belongs_g (id_book, id_genre) VALUES (99, 10);
1227INSERT INTO belongs_g (id_book, id_genre) VALUES (100, 15);
1228
1229-----------------------------------------
1230-- Buys_to
1231-----------------------------------------
1232INSERT INTO buys_to (id_seller, id_buyer) VALUES (70, 62);
1233INSERT INTO buys_to (id_seller, id_buyer) VALUES (73, 92);
1234INSERT INTO buys_to (id_seller, id_buyer) VALUES (57, 77);
1235INSERT INTO buys_to (id_seller, id_buyer) VALUES (90, 88);
1236
1237
1238-----------------------------------------
1239-- Item_cart
1240-----------------------------------------
1241INSERT INTO item_cart (id_item, id_cart) VALUES (5, 5);
1242INSERT INTO item_cart (id_item, id_cart) VALUES (6, 6);
1243INSERT INTO item_cart (id_item, id_cart) VALUES (7, 7);
1244INSERT INTO item_cart (id_item, id_cart) VALUES (8, 8);
1245INSERT INTO item_cart (id_item, id_cart) VALUES (9, 9);
1246INSERT INTO item_cart (id_item, id_cart) VALUES (1, 101);
1247INSERT INTO item_cart (id_item, id_cart) VALUES (5, 101);
1248
1249
1250-----------------------------------------
1251-- written
1252-----------------------------------------
1253INSERT INTO written (id_book, id_author) VALUES (1, 1);
1254INSERT INTO written (id_book, id_author) VALUES (1, 2);
1255INSERT INTO written (id_book, id_author) VALUES (2, 3);
1256INSERT INTO written (id_book, id_author) VALUES (3, 4);
1257INSERT INTO written (id_book, id_author) VALUES (4, 4);
1258INSERT INTO written (id_book, id_author) VALUES (5, 4);
1259INSERT INTO written (id_book, id_author) VALUES (6, 4);
1260INSERT INTO written (id_book, id_author) VALUES (7, 4);
1261INSERT INTO written (id_book, id_author) VALUES (8, 4);
1262INSERT INTO written (id_book, id_author) VALUES (9, 4);
1263INSERT INTO written (id_book, id_author) VALUES (10, 5);
1264INSERT INTO written (id_book, id_author) VALUES (11, 6);
1265INSERT INTO written (id_book, id_author) VALUES (11, 7);
1266INSERT INTO written (id_book, id_author) VALUES (11, 8);
1267INSERT INTO written (id_book, id_author) VALUES (11, 9);
1268INSERT INTO written (id_book, id_author) VALUES (11, 10);
1269INSERT INTO written (id_book, id_author) VALUES (11, 11);
1270INSERT INTO written (id_book, id_author) VALUES (11, 12);
1271INSERT INTO written (id_book, id_author) VALUES (11, 13);
1272INSERT INTO written (id_book, id_author) VALUES (12, 14);
1273INSERT INTO written (id_book, id_author) VALUES (13, 14);
1274INSERT INTO written (id_book, id_author) VALUES (14, 15);
1275INSERT INTO written (id_book, id_author) VALUES (15, 16);
1276INSERT INTO written (id_book, id_author) VALUES (16, 17);
1277INSERT INTO written (id_book, id_author) VALUES (17, 18);
1278INSERT INTO written (id_book, id_author) VALUES (18, 18);
1279INSERT INTO written (id_book, id_author) VALUES (19, 20);
1280INSERT INTO written (id_book, id_author) VALUES (20, 21);
1281INSERT INTO written (id_book, id_author) VALUES (21, 22);
1282INSERT INTO written (id_book, id_author) VALUES (21, 23);
1283INSERT INTO written (id_book, id_author) VALUES (21, 24);
1284INSERT INTO written (id_book, id_author) VALUES (22, 18);
1285INSERT INTO written (id_book, id_author) VALUES (23, 14);
1286INSERT INTO written (id_book, id_author) VALUES (23, 25);
1287INSERT INTO written (id_book, id_author) VALUES (24, 26);
1288INSERT INTO written (id_book, id_author) VALUES (25, 27);
1289INSERT INTO written (id_book, id_author) VALUES (25, 14);
1290INSERT INTO written (id_book, id_author) VALUES (26, 14);
1291INSERT INTO written (id_book, id_author) VALUES (27, 28);
1292INSERT INTO written (id_book, id_author) VALUES (27, 29);
1293INSERT INTO written (id_book, id_author) VALUES (27, 31);
1294INSERT INTO written (id_book, id_author) VALUES (27, 32);
1295INSERT INTO written (id_book, id_author) VALUES (27, 34);
1296INSERT INTO written (id_book, id_author) VALUES (27, 35);
1297INSERT INTO written (id_book, id_author) VALUES (27, 36);
1298INSERT INTO written (id_book, id_author) VALUES (27, 38);
1299INSERT INTO written (id_book, id_author) VALUES (27, 39);
1300INSERT INTO written (id_book, id_author) VALUES (28, 14);
1301INSERT INTO written (id_book, id_author) VALUES (28, 40);
1302INSERT INTO written (id_book, id_author) VALUES (29, 42);
1303INSERT INTO written (id_book, id_author) VALUES (29, 44);
1304INSERT INTO written (id_book, id_author) VALUES (30, 45);
1305INSERT INTO written (id_book, id_author) VALUES (30, 46);
1306INSERT INTO written (id_book, id_author) VALUES (30, 47);
1307INSERT INTO written (id_book, id_author) VALUES (30, 48);
1308INSERT INTO written (id_book, id_author) VALUES (30, 50);
1309INSERT INTO written (id_book, id_author) VALUES (30, 52);
1310INSERT INTO written (id_book, id_author) VALUES (31, 53);
1311INSERT INTO written (id_book, id_author) VALUES (31, 54);
1312INSERT INTO written (id_book, id_author) VALUES (31, 55);
1313INSERT INTO written (id_book, id_author) VALUES (31, 56);
1314INSERT INTO written (id_book, id_author) VALUES (32, 60);
1315INSERT INTO written (id_book, id_author) VALUES (32, 61);
1316INSERT INTO written (id_book, id_author) VALUES (32, 62);
1317INSERT INTO written (id_book, id_author) VALUES (32, 63);
1318INSERT INTO written (id_book, id_author) VALUES (32, 64);
1319INSERT INTO written (id_book, id_author) VALUES (32, 66);
1320INSERT INTO written (id_book, id_author) VALUES (32, 67);
1321INSERT INTO written (id_book, id_author) VALUES (33, 68);
1322INSERT INTO written (id_book, id_author) VALUES (33, 69);
1323INSERT INTO written (id_book, id_author) VALUES (33, 70);
1324INSERT INTO written (id_book, id_author) VALUES (33, 71);
1325INSERT INTO written (id_book, id_author) VALUES (34, 72);
1326INSERT INTO written (id_book, id_author) VALUES (34, 73);
1327INSERT INTO written (id_book, id_author) VALUES (34, 74);
1328INSERT INTO written (id_book, id_author) VALUES (35, 75);
1329INSERT INTO written (id_book, id_author) VALUES (35, 76);
1330INSERT INTO written (id_book, id_author) VALUES (36, 77);
1331INSERT INTO written (id_book, id_author) VALUES (36, 78);
1332INSERT INTO written (id_book, id_author) VALUES (37, 80);
1333INSERT INTO written (id_book, id_author) VALUES (37, 81);
1334INSERT INTO written (id_book, id_author) VALUES (38, 83);
1335INSERT INTO written (id_book, id_author) VALUES (38, 84);
1336INSERT INTO written (id_book, id_author) VALUES (38, 9);
1337INSERT INTO written (id_book, id_author) VALUES (39, 86);
1338INSERT INTO written (id_book, id_author) VALUES (39, 87);
1339INSERT INTO written (id_book, id_author) VALUES (39, 88);
1340INSERT INTO written (id_book, id_author) VALUES (39, 89);
1341INSERT INTO written (id_book, id_author) VALUES (39, 90);
1342INSERT INTO written (id_book, id_author) VALUES (40, 75);
1343INSERT INTO written (id_book, id_author) VALUES (40, 92);
1344INSERT INTO written (id_book, id_author) VALUES (40, 93);
1345INSERT INTO written (id_book, id_author) VALUES (41, 95);
1346INSERT INTO written (id_book, id_author) VALUES (41, 96);
1347INSERT INTO written (id_book, id_author) VALUES (41, 97);
1348INSERT INTO written (id_book, id_author) VALUES (41, 99);
1349INSERT INTO written (id_book, id_author) VALUES (41, 100);
1350INSERT INTO written (id_book, id_author) VALUES (41, 101);
1351INSERT INTO written (id_book, id_author) VALUES (42, 29);
1352INSERT INTO written (id_book, id_author) VALUES (42, 103);
1353INSERT INTO written (id_book, id_author) VALUES (42, 105);
1354INSERT INTO written (id_book, id_author) VALUES (43, 75);
1355INSERT INTO written (id_book, id_author) VALUES (43, 106);
1356INSERT INTO written (id_book, id_author) VALUES (44, 96);
1357INSERT INTO written (id_book, id_author) VALUES (44, 97);
1358INSERT INTO written (id_book, id_author) VALUES (44, 107);
1359INSERT INTO written (id_book, id_author) VALUES (45, 108);
1360INSERT INTO written (id_book, id_author) VALUES (46, 61);
1361INSERT INTO written (id_book, id_author) VALUES (46, 110);
1362INSERT INTO written (id_book, id_author) VALUES (47, 1);
1363INSERT INTO written (id_book, id_author) VALUES (47, 111);
1364INSERT INTO written (id_book, id_author) VALUES (48, 112);
1365INSERT INTO written (id_book, id_author) VALUES (48, 113);
1366INSERT INTO written (id_book, id_author) VALUES (48, 111);
1367INSERT INTO written (id_book, id_author) VALUES (48, 117);
1368INSERT INTO written (id_book, id_author) VALUES (48, 118);
1369INSERT INTO written (id_book, id_author) VALUES (48, 119);
1370INSERT INTO written (id_book, id_author) VALUES (49, 121);
1371INSERT INTO written (id_book, id_author) VALUES (49, 122);
1372INSERT INTO written (id_book, id_author) VALUES (50, 53);
1373INSERT INTO written (id_book, id_author) VALUES (50, 121);
1374INSERT INTO written (id_book, id_author) VALUES (50, 124);
1375INSERT INTO written (id_book, id_author) VALUES (50, 122);
1376INSERT INTO written (id_book, id_author) VALUES (50, 126);
1377INSERT INTO written (id_book, id_author) VALUES (51, 124);
1378INSERT INTO written (id_book, id_author) VALUES (51, 126);
1379INSERT INTO written (id_book, id_author) VALUES (52, 53);
1380INSERT INTO written (id_book, id_author) VALUES (52, 124);
1381INSERT INTO written (id_book, id_author) VALUES (52, 128);
1382INSERT INTO written (id_book, id_author) VALUES (52, 129);
1383INSERT INTO written (id_book, id_author) VALUES (52, 130);
1384INSERT INTO written (id_book, id_author) VALUES (53, 133);
1385INSERT INTO written (id_book, id_author) VALUES (53, 135);
1386INSERT INTO written (id_book, id_author) VALUES (54, 136);
1387INSERT INTO written (id_book, id_author) VALUES (54, 95);
1388INSERT INTO written (id_book, id_author) VALUES (54, 137);
1389INSERT INTO written (id_book, id_author) VALUES (54, 138);
1390INSERT INTO written (id_book, id_author) VALUES (54, 139);
1391INSERT INTO written (id_book, id_author) VALUES (55, 53);
1392INSERT INTO written (id_book, id_author) VALUES (55, 140);
1393INSERT INTO written (id_book, id_author) VALUES (55, 141);
1394INSERT INTO written (id_book, id_author) VALUES (56, 120);
1395INSERT INTO written (id_book, id_author) VALUES (56, 144);
1396INSERT INTO written (id_book, id_author) VALUES (56, 145);
1397INSERT INTO written (id_book, id_author) VALUES (57, 146);
1398INSERT INTO written (id_book, id_author) VALUES (57, 147);
1399INSERT INTO written (id_book, id_author) VALUES (57, 148);
1400INSERT INTO written (id_book, id_author) VALUES (58, 149);
1401INSERT INTO written (id_book, id_author) VALUES (58, 150);
1402INSERT INTO written (id_book, id_author) VALUES (58, 48);
1403INSERT INTO written (id_book, id_author) VALUES (59, 152);
1404INSERT INTO written (id_book, id_author) VALUES (59, 153);
1405INSERT INTO written (id_book, id_author) VALUES (59, 156);
1406INSERT INTO written (id_book, id_author) VALUES (59, 150);
1407INSERT INTO written (id_book, id_author) VALUES (59, 159);
1408INSERT INTO written (id_book, id_author) VALUES (59, 161);
1409INSERT INTO written (id_book, id_author) VALUES (59, 48);
1410INSERT INTO written (id_book, id_author) VALUES (59, 164);
1411INSERT INTO written (id_book, id_author) VALUES (59, 166);
1412INSERT INTO written (id_book, id_author) VALUES (59, 168);
1413INSERT INTO written (id_book, id_author) VALUES (60, 136);
1414INSERT INTO written (id_book, id_author) VALUES (60, 170);
1415INSERT INTO written (id_book, id_author) VALUES (60, 171);
1416INSERT INTO written (id_book, id_author) VALUES (60, 172);
1417INSERT INTO written (id_book, id_author) VALUES (60, 176);
1418INSERT INTO written (id_book, id_author) VALUES (61, 94);
1419INSERT INTO written (id_book, id_author) VALUES (61, 178);
1420INSERT INTO written (id_book, id_author) VALUES (61, 179);
1421INSERT INTO written (id_book, id_author) VALUES (61, 166);
1422INSERT INTO written (id_book, id_author) VALUES (61, 180);
1423INSERT INTO written (id_book, id_author) VALUES (62, 182);
1424INSERT INTO written (id_book, id_author) VALUES (62, 120);
1425INSERT INTO written (id_book, id_author) VALUES (62, 183);
1426INSERT INTO written (id_book, id_author) VALUES (62, 185);
1427INSERT INTO written (id_book, id_author) VALUES (62, 188);
1428INSERT INTO written (id_book, id_author) VALUES (62, 189);
1429INSERT INTO written (id_book, id_author) VALUES (62, 50);
1430INSERT INTO written (id_book, id_author) VALUES (62, 194);
1431INSERT INTO written (id_book, id_author) VALUES (63, 195);
1432INSERT INTO written (id_book, id_author) VALUES (63, 196);
1433INSERT INTO written (id_book, id_author) VALUES (64, 94);
1434INSERT INTO written (id_book, id_author) VALUES (64, 199);
1435INSERT INTO written (id_book, id_author) VALUES (64, 200);
1436INSERT INTO written (id_book, id_author) VALUES (64, 141);
1437INSERT INTO written (id_book, id_author) VALUES (64, 201);
1438INSERT INTO written (id_book, id_author) VALUES (64, 202);
1439INSERT INTO written (id_book, id_author) VALUES (64, 203);
1440INSERT INTO written (id_book, id_author) VALUES (64, 204);
1441INSERT INTO written (id_book, id_author) VALUES (64, 205);
1442INSERT INTO written (id_book, id_author) VALUES (64, 206);
1443INSERT INTO written (id_book, id_author) VALUES (64, 50);
1444INSERT INTO written (id_book, id_author) VALUES (65, 152);
1445INSERT INTO written (id_book, id_author) VALUES (65, 210);
1446INSERT INTO written (id_book, id_author) VALUES (66, 211);
1447INSERT INTO written (id_book, id_author) VALUES (66, 212);
1448INSERT INTO written (id_book, id_author) VALUES (67, 152);
1449INSERT INTO written (id_book, id_author) VALUES (67, 214);
1450INSERT INTO written (id_book, id_author) VALUES (67, 55);
1451INSERT INTO written (id_book, id_author) VALUES (67, 216);
1452INSERT INTO written (id_book, id_author) VALUES (68, 217);
1453INSERT INTO written (id_book, id_author) VALUES (68, 83);
1454INSERT INTO written (id_book, id_author) VALUES (69, 218);
1455INSERT INTO written (id_book, id_author) VALUES (70, 219);
1456INSERT INTO written (id_book, id_author) VALUES (70, 221);
1457INSERT INTO written (id_book, id_author) VALUES (70, 222);
1458INSERT INTO written (id_book, id_author) VALUES (71, 133);
1459INSERT INTO written (id_book, id_author) VALUES (71, 222);
1460INSERT INTO written (id_book, id_author) VALUES (72, 223);
1461INSERT INTO written (id_book, id_author) VALUES (72, 224);
1462INSERT INTO written (id_book, id_author) VALUES (72, 225);
1463INSERT INTO written (id_book, id_author) VALUES (73, 226);
1464INSERT INTO written (id_book, id_author) VALUES (73, 227);
1465INSERT INTO written (id_book, id_author) VALUES (73, 228);
1466INSERT INTO written (id_book, id_author) VALUES (74, 99);
1467INSERT INTO written (id_book, id_author) VALUES (74, 230);
1468INSERT INTO written (id_book, id_author) VALUES (74, 231);
1469INSERT INTO written (id_book, id_author) VALUES (74, 232);
1470INSERT INTO written (id_book, id_author) VALUES (74, 234);
1471INSERT INTO written (id_book, id_author) VALUES (74, 235);
1472INSERT INTO written (id_book, id_author) VALUES (74, 50);
1473INSERT INTO written (id_book, id_author) VALUES (75, 237);
1474INSERT INTO written (id_book, id_author) VALUES (76, 240);
1475INSERT INTO written (id_book, id_author) VALUES (76, 241);
1476INSERT INTO written (id_book, id_author) VALUES (76, 242);
1477INSERT INTO written (id_book, id_author) VALUES (76, 243);
1478INSERT INTO written (id_book, id_author) VALUES (77, 244);
1479INSERT INTO written (id_book, id_author) VALUES (77, 224);
1480INSERT INTO written (id_book, id_author) VALUES (78, 250);
1481INSERT INTO written (id_book, id_author) VALUES (78, 251);
1482INSERT INTO written (id_book, id_author) VALUES (78, 252);
1483INSERT INTO written (id_book, id_author) VALUES (78, 38);
1484INSERT INTO written (id_book, id_author) VALUES (79, 244);
1485INSERT INTO written (id_book, id_author) VALUES (79, 253);
1486INSERT INTO written (id_book, id_author) VALUES (79, 254);
1487INSERT INTO written (id_book, id_author) VALUES (80, 53);
1488INSERT INTO written (id_book, id_author) VALUES (80, 255);
1489INSERT INTO written (id_book, id_author) VALUES (80, 232);
1490INSERT INTO written (id_book, id_author) VALUES (80, 253);
1491INSERT INTO written (id_book, id_author) VALUES (80, 48);
1492INSERT INTO written (id_book, id_author) VALUES (81, 237);
1493INSERT INTO written (id_book, id_author) VALUES (81, 249);
1494INSERT INTO written (id_book, id_author) VALUES (81, 239);
1495INSERT INTO written (id_book, id_author) VALUES (81, 83);
1496INSERT INTO written (id_book, id_author) VALUES (81, 209);
1497INSERT INTO written (id_book, id_author) VALUES (81, 168);
1498INSERT INTO written (id_book, id_author) VALUES (81, 220);
1499INSERT INTO written (id_book, id_author) VALUES (81, 190);
1500INSERT INTO written (id_book, id_author) VALUES (81, 192);
1501INSERT INTO written (id_book, id_author) VALUES (81, 184);
1502INSERT INTO written (id_book, id_author) VALUES (81, 177);
1503INSERT INTO written (id_book, id_author) VALUES (81, 173);
1504INSERT INTO written (id_book, id_author) VALUES (82, 174);
1505INSERT INTO written (id_book, id_author) VALUES (83, 75);
1506INSERT INTO written (id_book, id_author) VALUES (83, 73);
1507INSERT INTO written (id_book, id_author) VALUES (84, 165);
1508INSERT INTO written (id_book, id_author) VALUES (85, 165);
1509INSERT INTO written (id_book, id_author) VALUES (86, 165);
1510INSERT INTO written (id_book, id_author) VALUES (87, 165);
1511INSERT INTO written (id_book, id_author) VALUES (88, 165);
1512INSERT INTO written (id_book, id_author) VALUES (89, 14);
1513INSERT INTO written (id_book, id_author) VALUES (90, 26);
1514INSERT INTO written (id_book, id_author) VALUES (91, 26);
1515INSERT INTO written (id_book, id_author) VALUES (92, 157);
1516INSERT INTO written (id_book, id_author) VALUES (92, 158);
1517INSERT INTO written (id_book, id_author) VALUES (92, 160);
1518INSERT INTO written (id_book, id_author) VALUES (94, 72);
1519INSERT INTO written (id_book, id_author) VALUES (94, 123);
1520INSERT INTO written (id_book, id_author) VALUES (94, 125);
1521INSERT INTO written (id_book, id_author) VALUES (95, 1);
1522INSERT INTO written (id_book, id_author) VALUES (95, 113);
1523INSERT INTO written (id_book, id_author) VALUES (96, 60);
1524INSERT INTO written (id_book, id_author) VALUES (96, 91);
1525INSERT INTO written (id_book, id_author) VALUES (96, 98);
1526INSERT INTO written (id_book, id_author) VALUES (97, 1);
1527INSERT INTO written (id_book, id_author) VALUES (97, 123);
1528INSERT INTO written (id_book, id_author) VALUES (98, 60);
1529INSERT INTO written (id_book, id_author) VALUES (98, 91);
1530INSERT INTO written (id_book, id_author) VALUES (99, 57);
1531INSERT INTO written (id_book, id_author) VALUES (99, 1);
1532INSERT INTO written (id_book, id_author) VALUES (99, 58);
1533INSERT INTO written (id_book, id_author) VALUES (99, 59);
1534INSERT INTO written (id_book, id_author) VALUES (99, 113);
1535INSERT INTO written (id_book, id_author) VALUES (100, 102);
1536INSERT INTO written (id_book, id_author) VALUES (100, 41);
1537INSERT INTO written (id_book, id_author) VALUES (100, 19);