tcM6QDv0

1DROP DATABASE IF EXISTS vk;
2CREATE DATABASE vk;
3USE vk;
4
5DROP TABLE IF EXISTS users;
6CREATE TABLE users (
7	id SERIAL PRIMARY KEY, -- SERIAL = BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE
8    firstname VARCHAR(50),
9    lastname VARCHAR(50) COMMENT 'Фамилия',
10    email VARCHAR(120) UNIQUE,
11    phone BIGINT, 
12    INDEX users_phone_idx(phone),
13    INDEX users_firstname_lastname_idx(firstname, lastname)
14);
15INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('1', 'Reuben', 'Nienow', 'arlo50@example.org', '9374071116');
16INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('2', 'Frederik', 'Upton', 'terrence.cartwright@example.org', '9127498182');
17INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('3', 'Unique', 'Windler', 'rupert55@example.org', '9921090703');
18INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('4', 'Norene', 'West', 'rebekah29@example.net', '9592139196');
19INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('5', 'Frederick', 'Effertz', 'von.bridget@example.net', '9909791725');
20INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('6', 'Victoria', 'Medhurst', 'sstehr@example.net', '9456642385');
21INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('7', 'Austyn', 'Braun', 'itzel.beahan@example.com', '9448906606');
22INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('8', 'Jaida', 'Kilback', 'johnathan.wisozk@example.com', '9290679311');
23INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('9', 'Mireya', 'Orn', 'missouri87@example.org', '9228624339');
24INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('10', 'Jordyn', 'Jerde', 'edach@example.com', '9443126821');
25INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('11', 'Thad', 'McDermott', 'shaun.ferry@example.org', '9840726982');
26INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('12', 'Aiden', 'Runolfsdottir', 'doug57@example.net', '9260442904');
27INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('13', 'Bernadette', 'Haag', 'lhoeger@example.net', '9984574866');
28INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('14', 'Dedric', 'Stanton', 'tconsidine@example.org', '9499932439');
29INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('15', 'Clare', 'Wolff', 'effertz.laverna@example.org', '9251665331');
30INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('16', 'Lina', 'Macejkovic', 'smitham.demarcus@example.net', '9762021357');
31INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('17', 'Jerrell', 'Stanton', 'deja00@example.com', '9191103792');
32INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('18', 'Golden', 'Wisozk', 'frida19@example.com', '9331565437');
33INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('19', 'Elisa', 'Balistreri', 'romaine27@example.org', '9372983850');
34INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('20', 'Reed', 'Bogan', 'zhyatt@example.com', '9924753974');
35INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('21', 'Gwendolyn', 'McClure', 'zluettgen@example.net', '9745046704');
36INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('22', 'Luz', 'Bailey', 'tillman.iliana@example.org', '9881942174');
37INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('23', 'Alyce', 'Toy', 'russel.ewell@example.com', '9754884857');
38INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('24', 'Oma', 'Ortiz', 'jailyn.feest@example.com', '9339073755');
39INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('25', 'Valentine', 'Goldner', 'matteo.wiza@example.net', '9803404650');
40INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('26', 'Rasheed', 'Ebert', 'brenden32@example.net', '9924275184');
41INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('27', 'Misael', 'Lakin', 'benjamin.hilpert@example.com', '9619165091');
42INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('28', 'Shaun', 'Fritsch', 'wwiegand@example.org', '9231898080');
43INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('29', 'Katarina', 'Sipes', 'jenifer.gislason@example.net', '9348426774');
44INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('30', 'Newton', 'Koss', 'beatty.river@example.org', '9574058915');
45INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('31', 'Selmer', 'Quitzon', 'ztromp@example.net', '9363178382');
46INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('32', 'Margarete', 'Koepp', 'idell70@example.net', '9743498718');
47INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('33', 'Donavon', 'Bauch', 'michele.lakin@example.com', '9229739697');
48INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('34', 'Ashlynn', 'Cummerata', 'weber.tatyana@example.net', '9710902090');
49INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('35', 'Fletcher', 'Lang', 'mona94@example.com', '9502246403');
50INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('36', 'Amiya', 'Leuschke', 'mathilde.macejkovic@example.com', '9461791942');
51INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('37', 'Terrance', 'West', 'ebert.magnus@example.org', '9381729082');
52INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('38', 'Keara', 'Kiehn', 'audie.franecki@example.net', '9796576345');
53INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('39', 'Wyatt', 'Olson', 'jarvis92@example.org', '9212459514');
54INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('40', 'Paula', 'Shields', 'casey.bayer@example.org', '9410763172');
55INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('41', 'Ivah', 'Bernier', 'paris15@example.com', '9283284370');
56INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('42', 'Liza', 'Howe', 'hadley72@example.org', '9926888657');
57INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('43', 'Kevon', 'Gerhold', 'fhilll@example.com', '9398761644');
58INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('44', 'Hermina', 'Lubowitz', 'amalia.reichel@example.org', '9213914905');
59INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('45', 'Cara', 'Quigley', 'hailee.beier@example.net', '9287811077');
60INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('46', 'Kian', 'Weimann', 'tankunding@example.net', '9168462586');
61INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('47', 'Madelynn', 'Hahn', 'pleffler@example.org', '9598242802');
62INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('48', 'Hassie', 'Monahan', 'lowe.amelia@example.net', '9765846197');
63INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('49', 'Taryn', 'Kuvalis', 'aschneider@example.net', '9533355262');
64INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('50', 'Hollis', 'Padberg', 'cathryn40@example.net', '9163727209');
65INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('51', 'Henriette', 'Lindgren', 'allie.witting@example.com', '9891313707');
66INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('52', 'Keven', 'DuBuque', 'durward83@example.com', '9613848114');
67INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('53', 'Chaz', 'Yundt', 'stamm.bret@example.net', '9763350438');
68INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('54', 'Rosalee', 'Dickens', 'concepcion.conn@example.net', '9675063949');
69INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('55', 'Kip', 'Schoen', 'ibeer@example.com', '9987381304');
70INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('56', 'Louie', 'Spencer', 'tkessler@example.com', '9938579943');
71INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('57', 'Priscilla', 'Daniel', 'barrett12@example.com', '9886578202');
72INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('58', 'Dean', 'Satterfield', 'orin69@example.net', '9160120629');
73INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('59', 'Prudence', 'Shields', 'sleffler@example.net', '9414604655');
74INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('60', 'Elaina', 'Buckridge', 'bartell.einar@example.net', '9916593682');
75INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('61', 'Monserrat', 'Conner', 'linda58@example.com', '9519551625');
76INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('62', 'Ramona', 'Davis', 'abbigail68@example.net', '9484610686');
77INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('63', 'Eldridge', 'Wilkinson', 'callie.wuckert@example.org', '9532811737');
78INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('64', 'Emanuel', 'Reinger', 'loyal.herzog@example.org', '9659591995');
79INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('65', 'Janis', 'Stamm', 'nils93@example.org', '9905318598');
80INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('66', 'Nannie', 'Streich', 'chelsea01@example.com', '9412172452');
81INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('67', 'Elva', 'Sawayn', 'modesta.haley@example.com', '9803009959');
82INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('68', 'Ava', 'Nolan', 'mmarvin@example.com', '9428224970');
83INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('69', 'Westley', 'Predovic', 'urunolfsdottir@example.net', '9247233922');
84INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('70', 'Antonina', 'Ferry', 'jamaal.farrell@example.com', '9902477849');
85INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('71', 'Jeffery', 'Lowe', 'noemie38@example.org', '9803133328');
86INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('72', 'Cesar', 'Schmitt', 'johnathan.waelchi@example.org', '9330339588');
87INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('73', 'Letha', 'Beatty', 'reynold.feil@example.net', '9636262160');
88INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('74', 'Benton', 'Rogahn', 'jbeer@example.net', '9490216855');
89INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('75', 'Braden', 'Shields', 'zemlak.foster@example.com', '9114981748');
90INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('76', 'Luther', 'Turcotte', 'zturner@example.com', '9292137540');
91INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('77', 'Patricia', 'Gleason', 'benny76@example.net', '9148879590');
92INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('78', 'Delta', 'Kerluke', 'terry.antone@example.org', '9667864529');
93INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('79', 'Thurman', 'Rutherford', 'isaiah.gerlach@example.net', '9994148720');
94INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('80', 'Willie', 'Fritsch', 'rolando45@example.org', '9512440690');
95INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('81', 'Letitia', 'Marks', 'bosco.sage@example.net', '9546163253');
96INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('82', 'Ada', 'Kuvalis', 'emmanuelle.hegmann@example.org', '9251017068');
97INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('83', 'Josie', 'Kunde', 'kaley.rolfson@example.net', '9285157694');
98INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('84', 'Harmony', 'Lesch', 'velda32@example.org', '9627960545');
99INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('85', 'Kelsie', 'Olson', 'xheidenreich@example.net', '9548492646');
100INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('86', 'Lucile', 'Rolfson', 'dbartell@example.net', '9258387168');
101INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('87', 'Celestino', 'Cruickshank', 'flavio.hammes@example.com', '9686686728');
102INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('88', 'Hayley', 'Vandervort', 'cartwright.seamus@example.com', '9228109837');
103INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('89', 'Royal', 'DuBuque', 'jswift@example.org', '9295312277');
104INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('90', 'Adrian', 'Mills', 'gail.lockman@example.net', '9491584055');
105INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('91', 'Roosevelt', 'Tromp', 'gutkowski.janiya@example.com', '9910853104');
106INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('92', 'Miguel', 'Watsica', 'hassan.kuphal@example.org', '9824696112');
107INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('93', 'Gregory', 'Jenkins', 'weimann.richard@example.com', '9860971258');
108INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('94', 'Kristina', 'Jast', 'jennifer27@example.com', '9133161481');
109INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('95', 'Ozella', 'Hauck', 'idickens@example.com', '9773438197');
110INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('96', 'Emmet', 'Hammes', 'qcremin@example.org', '9694110645');
111INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('97', 'Eleonore', 'Ward', 'antonietta.swift@example.com', '9397815776');
112INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('98', 'Lori', 'Koch', 'damaris34@example.net', '9192291407');
113INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('99', 'Sam', 'Kuphal', 'telly.miller@example.net', '9917826312');
114INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `phone`) VALUES ('100', 'Pearl', 'Prohaska', 'xeichmann@example.net', '9136605713');
115
116
117DROP TABLE IF EXISTS messages;
118CREATE TABLE messages (
119	id SERIAL PRIMARY KEY,
120	from_user_id BIGINT UNSIGNED NOT NULL,
121    to_user_id BIGINT UNSIGNED NOT NULL,
122    body TEXT,
123    created_at DATETIME DEFAULT NOW(),
124    INDEX messages_from_user_id (from_user_id),
125    INDEX messages_to_user_id (to_user_id),
126    FOREIGN KEY (from_user_id) REFERENCES users(id),
127    FOREIGN KEY (to_user_id) REFERENCES users(id)
128);
129INSERT INTO `messages` VALUES 
130('1','1','2','Voluptatem ut quaerat quia. Pariatur esse amet ratione qui quia. In necessitatibus reprehenderit et. Nam accusantium aut qui quae nesciunt non.','1995-08-28 22:44:29'),
131('2','2','1','Sint dolores et debitis est ducimus. Aut et quia beatae minus. Ipsa rerum totam modi sunt sed. Voluptas atque eum et odio ea molestias ipsam architecto.',now()),
132('3','3','1','Sed mollitia quo sequi nisi est tenetur at rerum. Sed quibusdam illo ea facilis nemo sequi. Et tempora repudiandae saepe quo.','1993-09-14 19:45:58'),
133('4','1','3','Quod dicta omnis placeat id et officiis et. Beatae enim aut aliquid neque occaecati odit. Facere eum distinctio assumenda omnis est delectus magnam.','1985-11-25 16:56:25'),
134('5','1','5','Voluptas omnis enim quia porro debitis facilis eaque ut. Id inventore non corrupti doloremque consequuntur. Molestiae molestiae deleniti exercitationem sunt qui ea accusamus deserunt.','1999-09-19 04:35:46'),
135('6','1','6','Rerum labore culpa et laboriosam eum totam. Quidem pariatur sit alias. Atque doloribus ratione eum rem dolor vitae saepe.','1973-11-09 08:12:04'),
136('7','1','7','Perspiciatis temporibus doloribus debitis. Et inventore labore eos modi. Quo temporibus corporis minus. Accusamus aspernatur nihil nobis placeat molestiae et commodi eaque.','1998-04-09 00:00:26'),
137('8','8','8','Suscipit dolore voluptas et sit vero et sint. Rem ut ratione voluptatum assumenda nesciunt ea. Quas qui qui atque ut. Similique et praesentium non voluptate iure. Eum aperiam officia quia dolorem.','2005-08-20 18:40:27'),
138('9','9','9','Et quia libero aut vitae minus. Rerum a blanditiis debitis sit nam. Veniam quasi aut autem ratione dolorem. Sunt quo similique dolorem odit totam sint sed.','2013-03-19 04:10:10'),
139('10','10','10','Praesentium molestias quia aut odio. Est quis eius ut animi optio molestiae. Amet tempore sequi blanditiis in est.','1976-05-22 14:38:15'),
140('11','11','11','Molestiae laudantium quibusdam porro est alias placeat assumenda. Ut consequatur rerum officiis exercitationem eveniet. Qui eum maxime sed in.','1996-04-27 00:23:37'),
141('12','12','12','Quo asperiores et id veritatis placeat. Aperiam ut sit exercitationem iste vel nisi fugit quia. Suscipit labore error ducimus quaerat distinctio quae quasi.','1989-05-13 22:39:47'),
142('13','13','1','Earum sunt quia sed harum modi accusamus. Quia dolor laboriosam asperiores aliquam quia. Sint id quasi et cumque qui minima ut quo. Autem sed laudantium officiis sit sit.','1997-09-30 00:06:14'),
143('14','4','1','Aut enim sint voluptas saepe. Ut tenetur quos rem earum sint inventore fugiat. Eaque recusandae similique earum laborum.','1977-10-15 23:26:40'),
144('15','4','1','Nisi rerum officiis officiis aut ad voluptates autem. Dolor nesciunt eum qui eos dignissimos culpa iste. Atque qui vitae quos odit inventore eum. Quam et voluptas quia amet.','1977-10-13 19:40:32'),
145('16','4','1','Consequatur ut et repellat non voluptatem nihil veritatis. Vel deleniti omnis et consequuntur. Et doloribus reprehenderit sed earum quas velit labore.','1998-05-24 10:09:36'),
146('17','2','1','Iste deserunt in et et. Corrupti rerum a veritatis harum. Ratione consequatur est ut deserunt dolores.','1993-01-30 15:51:38'),
147('18','18','1','Dicta non inventore autem incidunt accusamus amet distinctio. Aut laborum nam ab maxime. Maxime minima blanditiis et neque. Et laboriosam qui at deserunt magnam.','1996-05-19 14:18:39'),
148('19','19','1','Amet ad dolorum distinctio excepturi possimus quia. Adipisci veniam porro ipsum ipsum tempora est blanditiis. Magni ut quia eius qui.','1998-08-12 04:42:34'),
149('20','20','20','Porro aperiam voluptate quo eos nobis. Qui blanditiis cum id eos. Est sit reprehenderit consequatur eum corporis. Molestias quia quo sit architecto aut.','2013-11-01 05:14:05'),
150('21','21','21','Architecto sunt asperiores modi. A commodi non qui.','2007-10-22 01:34:17'),
151('22','8','1','Minus praesentium ipsum iusto ipsum et a nobis. Aut distinctio enim dolor suscipit et. Quia culpa molestiae architecto quod. Error nulla qui et harum sapiente maxime qui sed.','1986-07-17 11:23:56'),
152('23','8','1','Explicabo nostrum eius cum molestiae. Et deserunt aut consectetur molestiae. Illo veritatis sed ab.','2002-06-22 15:10:59'),
153('24','8','1','Excepturi consequatur ducimus voluptatum. Est sed perferendis ducimus officia et. Qui nemo sapiente harum rerum.','2007-09-14 22:06:16'),
154('25','8','1','Non deserunt quis non illum. In vel exercitationem dolore reiciendis non animi sequi cumque. Officia et repellat in aut voluptas. Dignissimos sed voluptatem minima eligendi. Magnam porro omnis mollitia aspernatur error quia.','2006-06-16 19:28:59'),
155('26','8','1','Minus tenetur molestiae laudantium est voluptatem tempora. Sed ab veniam porro similique cumque. Accusamus illo est et tempora excepturi odit.','1977-11-04 08:02:22'),
156('27','8','1','At ratione quae facere minima exercitationem vel ipsum ipsam. Qui eligendi repellat ut unde quos hic sit. Itaque expedita voluptatem id numquam. Provident culpa expedita alias optio ipsum id. Voluptatum quae quidem nihil aut nemo voluptatibus.','1975-06-25 22:37:18'),
157('28','8','1','Nam dignissimos nobis qui qui voluptate. Dolor voluptas praesentium quis tenetur deleniti dolorem incidunt. Cupiditate qui nam excepturi.','2007-03-22 10:13:05'),
158('29','8','1','Molestias ratione tenetur sint. Vel rerum voluptas vel vitae et aut non autem. Distinctio sunt in dignissimos esse eligendi praesentium. Ut totam autem vel sapiente architecto et.','2003-01-11 19:37:45'),
159('30','8','1','Perferendis in eius architecto debitis exercitationem. Optio deleniti ad dolor sapiente soluta. Quisquam deserunt autem amet magni quasi quo dolores. Expedita ea omnis omnis sint.','2010-04-13 15:06:20'),
160('31','31','31','Voluptatum totam inventore numquam dolor mollitia. Qui explicabo ut commodi culpa libero quisquam. Doloribus consequuntur rerum in nesciunt quia consequuntur ut.','2009-02-23 05:02:06'),
161('32','32','32','Delectus animi laboriosam magnam. Dolor a qui numquam et. Magnam rerum exercitationem officiis numquam.','2017-06-21 05:19:41'),
162('33','33','33','Blanditiis incidunt fugiat itaque animi impedit modi ratione at. Excepturi vel hic enim quidem aut ullam facilis. Ipsum aut maxime deserunt doloremque.','1996-01-15 13:05:37'),
163('34','34','34','Quia magnam reprehenderit libero fugiat. Voluptatem id qui incidunt nihil et voluptatem quos dicta. Corrupti et ut ratione quos architecto omnis. Accusamus quo aliquam hic sit quia illum.','1987-01-09 11:35:59'),
164('35','35','35','Voluptatem aperiam omnis ut sed nulla. Autem optio eligendi et corrupti.','1980-07-24 15:48:57'),
165('36','36','36','Omnis dolor dignissimos vel tempora. Quia explicabo iste tempora delectus esse. Laudantium molestiae recusandae laboriosam quam.','2007-01-31 14:18:23'),
166('37','37','37','Nesciunt vitae consequuntur et molestiae deleniti cupiditate nostrum. Et natus eveniet officiis voluptas voluptas magni velit. Explicabo ipsam et quis eos dolore explicabo.','1971-09-15 21:08:26'),
167('38','38','38','Atque deleniti voluptas labore veniam quas ipsam voluptatem. Similique facere qui est quaerat est et. Incidunt corporis aut deleniti aut excepturi.','1991-12-06 22:30:58'),
168('39','39','39','Placeat eos est animi voluptatem quas dolore. Dolor minima rem corporis perspiciatis. Nemo est autem voluptate est.','2004-10-09 10:37:23'),
169('40','40','40','Ab quibusdam dolor et illum quis dolore. Qui deserunt consequuntur voluptatem itaque. Expedita sit velit hic repudiandae provident culpa quisquam. Est aut rerum itaque in non et.','1972-03-14 21:06:39'),
170('41','41','41','Quasi porro esse voluptate aut quia quo cupiditate. Nihil dolorem neque ut est quibusdam. Eius labore quidem rerum animi eligendi sapiente. Quo dolor voluptates fugit sed eos ipsam illo quia.','2017-04-22 21:50:21'),
171('42','42','42','Similique accusantium voluptatem perferendis dignissimos et inventore qui. Est aspernatur et voluptas occaecati officiis dolores numquam. Ut amet quas natus voluptatibus.','2001-11-06 03:19:29'),
172('43','43','43','Nostrum aspernatur enim cum iure ut neque similique ut. Labore repudiandae eum inventore est consequatur. Non sed ea incidunt laboriosam ea itaque porro. Esse culpa id explicabo odio consequatur unde voluptatum.','1997-02-17 15:31:00'),
173('44','44','44','Magni ex dolor enim assumenda sit modi molestiae. Est quis aliquam ut id aliquam eveniet est. Fuga quaerat neque tenetur. Nihil reprehenderit necessitatibus ut quo nam excepturi.','1998-06-20 05:03:15'),
174('45','45','45','Quaerat eum sequi consequatur perferendis in libero. Nulla facilis sed facere natus. Harum aut incidunt quia harum aut beatae aspernatur. Perferendis dolor et ut corporis blanditiis.','2004-04-20 20:20:36'),
175('46','46','46','Expedita quia similique praesentium placeat. Harum omnis perspiciatis occaecati odio. Enim consequatur sequi ut hic deserunt odit quos.','2005-06-30 22:41:30'),
176('47','47','47','Cum reiciendis neque unde reprehenderit totam laborum porro. Voluptas sed eveniet voluptas. Qui sed consequatur exercitationem quis. Nihil velit possimus magnam cumque dolore cum nemo.','1973-09-27 23:29:10'),
177('48','48','48','Dolorum dignissimos ipsa tempore enim. Aliquam ex labore exercitationem odio id dignissimos eaque. Aperiam cupiditate alias ut rerum asperiores et.','1986-05-03 10:04:03'),
178('49','49','49','Molestiae omnis magnam labore quidem omnis doloribus delectus. Aut a ut velit quos. Quae est omnis vel omnis omnis aut distinctio aperiam. Numquam nulla quo qui quis.','1970-08-09 14:37:59'),
179('50','50','50','Dolorem necessitatibus ullam cumque quo assumenda alias. Molestias quibusdam earum commodi placeat. Saepe voluptatem voluptatem aut.','1976-06-06 22:03:25'),
180('51','51','51','Tenetur aut nobis pariatur et accusamus est eos deserunt. Non quia ratione aspernatur. Perspiciatis doloremque adipisci qui et animi. Aut quis in non.','1992-04-30 20:58:57'),
181('52','52','52','Animi et et incidunt ea sequi eaque quia. Quia laudantium est necessitatibus natus qui velit impedit vitae. Dolorum vitae eius tempore et magnam.','1973-03-10 13:48:51'),
182('53','53','53','Enim in minima dolores possimus odio quia. Officia qui quis laudantium ea dolor omnis. Dolores nihil optio exercitationem optio nihil exercitationem laboriosam est. Enim quasi qui dolorem sit tempora labore laboriosam.','1982-11-18 08:42:29'),
183('54','54','54','Quam tempora accusantium ullam doloribus eveniet ut. Qui dolores ut et. Molestiae velit dolorem vel similique neque.','1995-03-14 17:47:23'),
184('55','55','55','Dolore molestias aut sit cum. Libero tempora laboriosam mollitia saepe. Ipsa voluptatum itaque sequi dolorem. Ipsam sint sequi perferendis odio amet dicta optio fugit.','1999-07-08 10:32:41'),
185('56','56','56','Inventore facere perferendis nostrum est. Aut eos laborum iusto itaque tenetur. Dicta nihil maxime necessitatibus ut nihil. Enim ab et quo aperiam.','2008-10-15 17:57:56'),
186('57','57','57','Voluptates consequatur et et necessitatibus soluta et. Reiciendis saepe debitis placeat autem. Aperiam soluta et commodi sint consectetur.','1974-01-30 16:15:55'),
187('58','58','58','Libero eos incidunt ipsum omnis sit quisquam dolores doloribus. Doloremque nobis repellat sit vel totam molestias. Minus quasi qui labore tenetur molestiae est assumenda.','1979-10-08 08:07:50'),
188('59','59','59','Tempore vero voluptatem mollitia qui suscipit iusto suscipit. Aut consectetur accusamus provident consequatur officiis. Amet fugit voluptatibus dolorem reiciendis voluptatem cupiditate quia.','1994-08-20 09:12:31'),
189('60','60','60','Quia sequi animi repellat. Consequatur ad soluta consequatur quo. Molestias suscipit et placeat non officiis rerum et. Voluptatibus ea veniam architecto labore aut corporis qui.','1974-04-18 22:45:58'),
190('61','61','61','Aut ab numquam non commodi aut. Assumenda adipisci hic tenetur. Possimus delectus dicta ab id dolores.','1987-10-17 16:11:13'),
191('62','62','62','Eos amet ut qui tempora saepe totam. Velit ut quis ut quia. Est id eos et commodi nihil. Rerum saepe quia consequatur laborum delectus suscipit velit.','2012-11-25 07:00:39'),
192('63','63','63','Eligendi qui iusto non. Rerum amet aut tempore expedita ut assumenda perspiciatis. Id ut nemo quis. Sit quia repellendus et minus.','2005-02-27 23:18:23'),
193('64','64','64','Consectetur ad nihil tenetur iusto. Possimus qui quibusdam id ut. Sunt molestias quidem quisquam eligendi natus. Assumenda magnam laborum harum nemo qui nisi.','1998-10-18 18:46:37'),
194('65','65','65','Alias voluptatem odit aliquid possimus id est. Aliquid excepturi soluta deserunt vel quidem voluptatem ipsam. Natus ex quis neque unde est. Molestias possimus sint quos sed quo.','1988-05-14 20:25:46'),
195('66','66','66','Temporibus voluptates ipsa placeat est dolorum. Mollitia aut laboriosam consequuntur amet asperiores maxime aspernatur distinctio. Incidunt est voluptatem ipsam provident optio dignissimos praesentium. Dolores quis laudantium ut beatae voluptas blanditiis est.','1988-03-02 21:17:37'),
196('67','67','67','Minus necessitatibus voluptate molestiae eius. Illo consequatur aliquam dolore fugit nemo est beatae beatae.','2001-09-08 17:21:02'),
197('68','68','68','Et aut libero odit id. Occaecati doloribus et quam excepturi eveniet esse.','1990-05-02 19:23:36'),
198('69','69','69','Rerum qui deleniti et dolorum quae. Voluptates repudiandae aliquid at repellat. At delectus rerum aut qui qui. Accusantium suscipit blanditiis aut tenetur quae et ut. Fugit dolorem veritatis quam corrupti odio sint voluptatem impedit.','1992-11-20 08:57:16'),
199('70','70','70','Occaecati et quisquam fugit a. Et repellendus alias quam incidunt ut tempora. Deserunt temporibus aut saepe eius excepturi.','1970-08-11 21:33:29'),
200('71','71','71','Sint quo natus ut odit corrupti laboriosam iure molestias. Quod repudiandae consequuntur quas et dolore expedita. Iste dolorem eius officiis. Deleniti magni iusto autem vero.','2005-10-16 03:28:41'),
201('72','72','72','Aperiam nobis odit omnis culpa. Ex esse tempora et error. Animi doloribus ut dolores dolorum quos facilis. Vel cupiditate sint cum est et. Quasi quo aut et consequatur repellat odit ut.','1988-02-29 05:32:01'),
202('73','73','73','Incidunt exercitationem qui amet explicabo natus ipsam repudiandae. Quod fugiat dolor qui eum sit est. Magni eum odit et eos consequatur id.','2010-04-18 01:08:09'),
203('74','74','74','Ipsam debitis eligendi labore error minima inventore quia. Minus et minima ut. Consequatur consectetur corporis et laborum impedit.','1985-10-05 19:13:28'),
204('75','75','75','Explicabo tenetur illo sint corporis dolore. Vitae quos quia qui hic natus deserunt facere sit. Molestiae enim animi libero qui. Quis accusamus itaque quas qui cumque qui.','2012-03-29 11:54:19'),
205('76','76','76','Ut placeat ad ab tempore. Temporibus itaque distinctio hic laboriosam eum asperiores quibusdam placeat. Aut sit ut est perspiciatis beatae omnis. Ad et aperiam dolorem voluptatem molestiae quia eos.','1986-03-25 09:53:35'),
206('77','77','77','Nesciunt animi voluptatum eveniet voluptatem perferendis vel. Dolorem dolor nihil doloremque sed ut. Unde ea et numquam tenetur modi eos qui. Fuga est sapiente omnis omnis.','1972-04-24 19:27:51'),
207('78','78','78','Recusandae laudantium debitis modi perspiciatis mollitia aliquid saepe culpa. In molestiae dolore nesciunt. Sint dolorem velit aliquid saepe dolorum iure voluptatem.','2014-07-19 03:46:12'),
208('79','79','79','Et aut earum aut dolores enim sequi. Quo cumque dolorum eos qui vel expedita quo. Est libero labore et tempore. Temporibus deleniti ipsa ea ea possimus accusamus maxime.','1984-10-24 22:39:24'),
209('80','80','80','Voluptas nemo aliquam pariatur sequi dolorem officia molestiae. Cupiditate ut ab necessitatibus odio suscipit quo.','1991-05-25 00:05:39'),
210('81','81','81','Occaecati possimus ipsum velit dolorum in ipsam. Hic laudantium eligendi pariatur deserunt molestias. Esse doloribus nemo odio aperiam illum.','1992-06-19 09:18:21'),
211('82','82','82','Aut quas animi sed quis. Autem explicabo totam accusamus. Sapiente in sunt in dolores. Totam est repellendus voluptas.','1990-08-26 13:57:28'),
212('83','83','83','Harum non ea incidunt accusamus fugit voluptatibus. Totam voluptatibus inventore dolorum odit.','2017-08-01 23:04:18'),
213('84','84','84','Consequuntur atque ut officiis est laudantium sapiente quia. Ut atque at corrupti autem. Consequatur repudiandae consequatur ut eligendi ipsam eum vero.','1984-08-20 04:11:47'),
214('85','85','85','Explicabo fugit consequatur non. Ex qui culpa amet. Accusamus consequatur sed quia qui nihil quia.','1998-08-07 18:07:35'),
215('86','86','86','Aut vero dolore hic et reiciendis omnis. Nesciunt quis aut odit quam. Reprehenderit omnis molestiae ipsa vero laboriosam totam consectetur cumque. Facere et qui dolore ut architecto reprehenderit.','1989-05-22 06:13:52'),
216('87','87','87','Qui omnis a assumenda tempora assumenda. Consequatur nihil dolorem veritatis qui dolores vel.','2010-08-08 17:23:39'),
217('88','88','88','Consequatur repudiandae voluptas ex ea. Commodi non officiis culpa quos. Eum id sed voluptatibus.','2011-03-01 02:20:15'),
218('89','89','89','Velit tenetur qui ratione dolore non. Ad omnis totam aliquid quos.','2008-01-26 14:29:48'),
219('90','90','90','Beatae et adipisci dolorem. Consequatur ut tenetur nulla dolor corporis vero.','1996-07-08 15:22:44'),
220('91','91','91','Quia est natus assumenda explicabo fugit atque. Ea sit maiores quod repellendus molestiae. Qui consectetur qui aut ipsa corporis dolore architecto corporis.','2015-12-29 19:09:22'),
221('92','92','92','Ipsa sunt voluptatem animi optio qui. Eum autem quam et accusantium fuga autem voluptatem. Laborum illum dignissimos ut et qui sed. Est hic nesciunt quo iusto dolor soluta maxime.','2014-11-15 17:19:35'),
222('93','93','93','Doloribus aliquid incidunt et architecto ipsa est sapiente. In nesciunt quia et quo expedita. Possimus qui voluptatum fuga eum ut.','1979-10-07 18:50:35'),
223('94','94','94','Qui deleniti omnis officiis. Maiores ducimus quisquam inventore iusto totam est deserunt voluptates. Quasi reprehenderit excepturi vel aut ullam.','1983-09-13 00:31:43'),
224('95','95','95','Est voluptatem voluptas ut asperiores expedita voluptatem. Recusandae reiciendis eos magnam fugit placeat blanditiis illo. Aliquam quis officia repellat consequatur aut consequatur voluptas.','1975-09-22 08:07:45'),
225('96','96','96','Non sunt maxime nisi impedit dolores. Aliquid vero et facilis a. Non maiores quos dolores saepe similique maxime.','1988-12-01 15:08:45'),
226('97','97','97','Tempore aliquid aut ipsa. Ea sunt modi non ducimus eum sed ea. Sint aliquid nihil ipsam est cumque velit earum. Voluptas qui inventore eius et facere placeat nemo.','1992-04-14 11:30:54'),
227('98','98','98','Quasi velit non fugiat. Neque porro molestiae est et architecto. Voluptatem ipsa in beatae nihil voluptatem quidem. Minus est in autem saepe.','1999-11-20 22:33:47'),
228('99','99','99','Maiores ut accusantium rerum. Expedita consequuntur et placeat vero ea eligendi et eum. Et distinctio at beatae quis ut ut rerum. In repellat corrupti adipisci quaerat repellat quas illo.','1990-06-30 05:56:22'),
229('100','100','100','Molestiae molestiae non doloribus temporibus minima. Eaque sapiente ex assumenda. Eveniet dolorum iure qui mollitia repudiandae vel. Labore quos qui necessitatibus.','1991-05-20 07:06:14'); 
230
231DROP TABLE IF EXISTS friend_requests;
232CREATE TABLE friend_requests (
233	-- id SERIAL PRIMARY KEY, -- changed to combined primary key (initiator_user_id, target_user_id)
234	initiator_user_id BIGINT UNSIGNED NOT NULL,
235    target_user_id BIGINT UNSIGNED NOT NULL,
236    -- `status` TINYINT UNSIGNED,
237    `status` ENUM('requested', 'approved', 'unfriended', 'declined'),
238	requested_at DATETIME DEFAULT NOW(),
239	confirmed_at DATETIME,
240	INDEX (initiator_user_id),
241    INDEX (target_user_id),
242    PRIMARY KEY (initiator_user_id, target_user_id),
243    FOREIGN KEY (initiator_user_id) REFERENCES users(id),
244    FOREIGN KEY (target_user_id) REFERENCES users(id)
245);
246INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('1', '10', 'approved', '1970-08-21 06:40:37', '2003-12-29 23:20:55');
247INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('1', '2', 'requested', '1987-10-10 07:33:23', '1983-01-18 01:56:05');
248INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('1', '3', 'approved', '2015-02-07 01:53:07', '2015-09-14 16:17:12');
249INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('4', '1', 'approved', '1983-04-08 15:57:26', '1976-12-28 23:54:58');
250INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('5', '2', 'unfriended', '1976-03-03 18:22:00', '1996-12-03 11:29:04');
251INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('6', '3', 'unfriended', '2008-12-06 17:07:59', '2015-11-01 08:03:23');
252INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('7', '1', 'requested', '1989-10-26 06:20:23', '2001-08-05 16:01:03');
253INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('8', '6', 'unfriended', '1987-12-30 01:50:03', '2001-07-09 07:39:50');
254INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('9', '7', 'requested', '2003-12-27 22:52:09', '1998-04-18 04:41:46');
255INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('10', '11', 'declined', '1970-05-08 00:32:15', '2007-03-22 21:08:16');
256INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('11', '14', 'approved', '1988-05-02 10:55:41', '1985-02-09 05:04:27');
257INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('12', '11', 'unfriended', '1975-07-25 20:11:02', '1993-06-30 12:51:09');
258INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('13', '33', 'declined', '2000-06-24 13:17:54', '1982-04-16 16:12:48');
259INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('14', '24', 'declined', '2007-12-09 17:17:48', '1991-05-31 12:38:33');
260INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('15', '35', 'unfriended', '2016-07-21 20:48:02', '1982-10-06 14:54:41');
261INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('16', '36', 'requested', '1992-10-04 04:16:38', '2001-01-24 13:54:16');
262INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('17', '37', 'approved', '1984-11-20 10:33:06', '2018-10-07 19:43:11');
263INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('18', '38', 'approved', '1992-07-31 16:34:16', '2008-08-03 10:13:44');
264INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('19', '39', 'requested', '1993-06-18 14:21:32', '1976-01-16 15:57:24');
265INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('20', '30', 'declined', '2007-03-22 18:13:14', '2010-01-06 00:06:18');
266INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('21', '31', 'requested', '2015-09-17 12:10:37', '1986-06-30 22:29:41');
267INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('22', '32', 'approved', '2004-09-21 23:23:19', '2003-01-27 16:11:05');
268INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('23', '33', 'requested', '1972-04-26 20:13:41', '1991-01-03 06:58:39');
269INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('24', '34', 'unfriended', '2017-08-08 05:38:20', '2007-09-27 03:07:27');
270INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('25', '35', 'approved', '2001-01-16 08:07:31', '1995-04-25 06:23:27');
271INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('26', '36', 'declined', '2004-07-31 10:12:37', '2001-06-28 18:49:10');
272INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('27', '37', 'declined', '2004-11-01 19:13:46', '1978-05-16 19:08:26');
273INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('28', '38', 'requested', '1989-07-10 17:02:49', '2007-03-16 20:42:05');
274INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('29', '39', 'unfriended', '1984-08-12 11:38:13', '1971-07-07 10:40:59');
275INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('30', '10', 'unfriended', '1997-03-01 23:22:31', '1974-08-30 23:16:26');
276INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('31', '11', 'approved', '2003-02-19 05:45:39', '2015-02-04 15:26:16');
277INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('32', '12', 'declined', '2017-01-08 12:24:37', '2019-02-23 04:25:58');
278INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('33', '13', 'requested', '2018-08-15 10:50:34', '1984-08-24 14:00:01');
279INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('34', '14', 'unfriended', '1988-06-12 03:29:45', '1998-11-28 12:07:32');
280INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('35', '15', 'unfriended', '1988-01-30 09:10:41', '2004-06-02 14:04:53');
281INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('36', '16', 'declined', '1993-03-10 12:19:15', '2007-05-17 03:24:16');
282INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('37', '17', 'requested', '1999-06-21 09:26:23', '2011-08-28 05:29:49');
283INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('38', '18', 'requested', '1977-03-14 20:26:41', '1975-09-03 17:01:54');
284INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('39', '19', 'approved', '2017-09-08 20:11:20', '1989-12-10 18:38:58');
285INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('40', '10', 'approved', '2001-08-16 04:34:33', '1999-01-01 14:33:52');
286INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('41', '11', 'unfriended', '1982-07-18 15:48:44', '1989-10-14 05:48:07');
287INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('42', '12', 'requested', '1973-10-29 10:38:00', '1973-11-02 18:26:40');
288INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('43', '13', 'requested', '1979-12-17 11:27:04', '2004-09-28 04:54:42');
289INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('44', '14', 'approved', '2013-10-01 07:28:04', '2006-12-12 05:43:06');
290INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('45', '15', 'requested', '2011-07-27 12:46:23', '1988-05-07 21:59:11');
291INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('46', '16', 'declined', '1999-11-13 00:33:38', '2016-05-02 19:19:15');
292INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('47', '17', 'approved', '1980-03-02 03:50:22', '2010-09-22 18:58:47');
293INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('48', '18', 'requested', '2003-11-15 23:04:36', '1991-08-05 16:56:51');
294INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('49', '19', 'approved', '2006-03-24 23:01:39', '2010-08-04 15:00:32');
295INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('50', '10', 'approved', '2008-07-18 00:34:41', '2016-12-25 03:18:49');
296INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('51', '11', 'approved', '2001-10-14 18:49:19', '2012-06-08 01:36:28');
297INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('52', '12', 'requested', '2000-06-08 04:08:36', '2010-10-12 10:27:39');
298INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('53', '13', 'approved', '1972-07-01 10:35:33', '1972-03-03 01:26:27');
299INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('54', '14', 'declined', '2007-07-24 20:49:26', '2014-03-10 04:56:59');
300INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('55', '15', 'approved', '1981-09-25 09:50:15', '1991-04-22 04:24:22');
301INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('56', '16', 'approved', '2015-03-08 22:23:52', '1996-02-08 09:41:57');
302INSERT INTO `friend_requests` (`initiator_user_id`, `target_user_id`, `status`, `requested_at`, `confirmed_at`) VALUES ('57', '17', 'declined', '2012-07-18 20:25:26', '2008-06-10 16:46:01');
303
304
305DROP TABLE IF EXISTS communities;
306CREATE TABLE communities(
307	id SERIAL PRIMARY KEY,
308	name VARCHAR(150),
309    INDEX communities_name_idx(name)
310);
311/*!40000 ALTER TABLE `communities` DISABLE KEYS */;
312INSERT INTO `communities` VALUES (2,'atque'),(1,'beatae'),(9,'est'),(5,'eum'),(7,'hic'),(6,'nemo'),(8,'quis'),(4,'rerum'),(10,'tempora'),(3,'voluptas');
313/*!40000 ALTER TABLE `communities` ENABLE KEYS */;
314
315DROP TABLE IF EXISTS users_communities;
316CREATE TABLE users_communities(
317	user_id BIGINT UNSIGNED NOT NULL,
318	community_id BIGINT UNSIGNED NOT NULL,
319    PRIMARY KEY (user_id, community_id),
320    FOREIGN KEY (user_id) REFERENCES users(id),
321    FOREIGN KEY (community_id) REFERENCES communities(id)
322);
323INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('1', '1');
324INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('1', '2');
325INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('1', '3');
326INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('2', '4');
327INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('2', '5');
328INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('6', '6');
329INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('7', '7');
330INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('8', '8');
331INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('9', '9');
332INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('10', '10');
333INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('11', '1');
334INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('12', '2');
335INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('13', '3');
336INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('14', '4');
337INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('15', '5');
338INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('16', '6');
339INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('17', '7');
340INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('18', '8');
341INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('19', '9');
342INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('20', '10');
343INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('21', '1');
344INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('22', '2');
345INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('23', '3');
346INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('24', '4');
347INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('25', '5');
348INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('26', '6');
349INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('27', '7');
350INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('28', '8');
351INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('29', '9');
352INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('30', '10');
353INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('31', '1');
354INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('32', '2');
355INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('33', '3');
356INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('34', '4');
357INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('35', '5');
358INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('36', '6');
359INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('37', '7');
360INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('38', '8');
361INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('39', '9');
362INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('40', '10');
363INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('41', '1');
364INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('42', '2');
365INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('43', '3');
366INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('44', '4');
367INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('45', '5');
368INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('46', '6');
369INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('47', '7');
370INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('48', '8');
371INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('49', '9');
372INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('50', '10');
373INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('51', '1');
374INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('52', '2');
375INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('53', '3');
376INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('54', '4');
377INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('55', '5');
378INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('56', '6');
379INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('57', '7');
380INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('58', '8');
381INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('59', '9');
382INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('60', '10');
383INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('61', '1');
384INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('62', '2');
385INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('63', '3');
386INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('64', '4');
387INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('65', '5');
388INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('66', '6');
389INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('67', '7');
390INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('68', '8');
391INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('69', '9');
392INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('70', '10');
393INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('71', '1');
394INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('72', '2');
395INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('73', '3');
396INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('74', '4');
397INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('75', '5');
398INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('76', '6');
399INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('77', '7');
400INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('78', '8');
401INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('79', '9');
402INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('80', '10');
403INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('81', '1');
404INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('82', '2');
405INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('83', '3');
406INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('84', '4');
407INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('85', '5');
408INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('86', '6');
409INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('87', '7');
410INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('88', '8');
411INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('89', '9');
412INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('90', '10');
413INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('91', '1');
414INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('92', '2');
415INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('93', '3');
416INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('94', '4');
417INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('95', '5');
418INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('96', '6');
419INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('97', '7');
420INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('98', '8');
421INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('99', '9');
422INSERT INTO `users_communities` (`user_id`, `community_id`) VALUES ('100', '10');
423
424DROP TABLE IF EXISTS media_types;
425CREATE TABLE media_types(
426	id SERIAL PRIMARY KEY,
427    name VARCHAR(255),
428    created_at DATETIME DEFAULT NOW()
429);
430/*!40000 ALTER TABLE `media_types` DISABLE KEYS */;
431INSERT INTO `media_types` VALUES 
432	(1,'Photo','2003-07-09 10:08:05'),
433	(2,'Music','2009-06-19 20:08:09'),
434	(3,'Video','1984-04-18 01:55:09'),
435	(4,'Post','2001-04-17 06:47:52');
436/*!40000 ALTER TABLE `media_types` ENABLE KEYS */;
437
438DROP TABLE IF EXISTS media;
439CREATE TABLE media(
440	id SERIAL PRIMARY KEY,
441    media_type_id BIGINT UNSIGNED NOT NULL,
442    user_id BIGINT UNSIGNED NOT NULL,
443  	body text,
444    filename VARCHAR(255),
445    size INT,
446	metadata JSON,
447    created_at DATETIME DEFAULT NOW(),
448    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
449	INDEX (user_id),
450    FOREIGN KEY (user_id) REFERENCES users(id),
451    FOREIGN KEY (media_type_id) REFERENCES media_types(id)
452);
453INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
454(1,1,'Est aut aliquid est. Soluta eveniet doloribus ipsam ut id assumenda quam. Consequuntur et velit aperiam error corporis rem corporis. Est similique quisquam quia maxime eaque possimus facere officiis. Odio magni atque dicta voluptatibus hic iste delectus.','a.avi',5,NULL,'1991-11-16 08:14:38.000','2019-06-19 18:11:58.000')
455,(2,2,'Laborum dolorem magni unde vero sit hic. Pariatur quia voluptas magnam. Blanditiis dolorem et molestias veniam facere provident.','asperiores.mp4',4510,NULL,'1986-12-10 19:34:26.000','2019-06-19 18:11:58.000')
456,(1,3,'A quam ea ullam reiciendis vel et reiciendis. Delectus iure mollitia est. Eum dolores dolores sed officia vitae qui. Sed repudiandae voluptatem voluptatibus libero culpa quo.','sapiente.avi',763116,NULL,'1978-09-18 17:07:49.000','2019-06-19 18:11:58.000')
457,(4,4,'Velit commodi in veniam occaecati. Tenetur temporibus ullam enim officiis aut illum. In maiores velit nobis soluta molestias maiores tempora. Quisquam et ut et sequi.','rerum.mp4',740,NULL,'1984-10-21 04:41:15.000','2019-06-19 18:11:58.000')
458,(1,5,'Est eaque est qui et omnis rerum. Expedita porro nesciunt inventore consequatur quos. Inventore aut rerum voluptas. Dicta vel ut quibusdam cupiditate tempore.','user5-profile-image.mp4',40813,NULL,'2014-06-20 03:34:11.000','2019-06-19 18:11:58.000')
459,(2,6,'Atque et nam nulla et aliquid. Vel repellendus aut natus odit quibusdam quis atque et. Laudantium minima velit dolores eos voluptate nostrum.','quasi.jpg',119422,NULL,'1991-11-02 07:50:45.000','2019-06-19 18:11:58.000')
460,(3,7,'Nihil ut et reprehenderit et. Numquam veniam quis impedit. Voluptas saepe rerum illo vel omnis. Aliquam illum ut quo saepe ea unde est.','non.mp4',704558,NULL,'1988-09-17 20:56:38.000','2019-06-19 18:11:58.000')
461,(4,8,'Sint quod fugit molestiae dolore repellendus est. Quis corporis necessitatibus commodi placeat temporibus doloremque voluptatem. Nemo maxime sit dolorem perferendis repellat. Et impedit deleniti eaque pariatur ut quia voluptatibus.','earum.mp4',65108,NULL,'1995-10-07 10:19:53.000','2019-06-19 18:11:58.000')
462,(1,9,'Optio sed aperiam veniam eum. Rerum placeat soluta iusto perspiciatis quibusdam dolorem eos. Ea pariatur optio est ut.','ullam.jpg',83717449,NULL,'2003-08-05 05:55:25.000','2019-06-19 18:11:58.000')
463,(2,10,'Facere nostrum facilis aperiam quisquam dolor. Minima omnis est nam.','maiores.jpg',75,NULL,'1984-05-17 07:37:30.000','2019-06-19 18:11:58.000')
464;
465INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
466(3,1,'A omnis ratione non. Et velit sed incidunt corporis ut rerum nemo. Ut pariatur tempora ea incidunt praesentium ut. Eligendi et et rerum sequi ut.','non.mp4',0,NULL,'2010-05-07 19:13:09.000','2019-06-19 18:11:58.000')
467,(4,1,'Quo minus harum debitis debitis quis sunt. Dolores suscipit placeat dolorum non voluptate et. Non eos odio esse tempore. Illum minus quidem temporibus porro.','earum.jpg',1826766,NULL,'2013-08-25 22:49:45.000','2019-06-19 18:11:58.000')
468,(1,1,'Et aliquid sit natus vitae fuga enim repudiandae. Quis ab et debitis est accusantium labore. Exercitationem delectus eaque necessitatibus.','hic.jpg',979,NULL,'2015-11-02 00:11:31.000','2019-06-19 18:11:58.000')
469,(2,1,'Nobis est sed blanditiis assumenda incidunt explicabo. Facere rem assumenda odio explicabo ad enim repellat quia. Dolor mollitia fugiat officia nihil animi.','iste.jpg',18,NULL,'2006-05-11 12:11:06.000','2019-06-19 18:11:58.000')
470,(3,1,'Tempora ad et aspernatur laborum ut dolor et. Exercitationem quaerat corporis placeat et.','quia.jpg',7,NULL,'2000-03-29 04:01:57.000','2019-06-19 18:11:58.000')
471,(4,1,'Accusantium est ea fuga omnis mollitia. Dolores officia et consequatur iste est quo. Ullam laborum qui ut quo delectus temporibus.','omnis.jpg',2058670,NULL,'1971-10-08 06:43:32.000','2019-06-19 18:11:58.000')
472,(1,1,'Quasi itaque atque ut aliquam debitis. Qui consequuntur maiores sit ad perspiciatis quaerat assumenda repudiandae. Necessitatibus placeat quaerat aut voluptatem ratione voluptate expedita. Nulla doloremque aut molestiae nam.','aperiam.jpg',3489253,NULL,'1973-12-19 09:20:43.000','2019-06-19 18:11:58.000')
473,(2,1,'Deserunt voluptatem quia voluptatem sit. Qui omnis distinctio optio voluptatem veniam atque dolorem. Repellat laboriosam illo consequatur nesciunt voluptas magni rerum. Saepe quos qui doloremque.','commodi.jpg',8,NULL,'1989-03-01 17:19:42.000','2019-06-19 18:11:58.000')
474,(3,1,'Fugiat consequuntur voluptatem odit omnis. Quia aut voluptate officia rerum. Cumque voluptatem eaque dolorum voluptas sed. Et autem atque est minus veritatis explicabo eos.','id.jpg',1,NULL,'1970-11-04 03:06:33.000','2019-06-19 18:11:58.000')
475,(4,2,'Autem dolore beatae aut corporis fugit ratione. Ex beatae qui at. Est deleniti asperiores temporibus perferendis est.','fugiat.jpg',82,NULL,'2017-06-08 03:23:04.000','2019-06-19 18:11:58.000')
476;
477INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
478(1,21,'Provident eligendi animi quidem qui ipsum. Accusamus dolor sint est qui magnam. Omnis enim quis dolore magni facilis repudiandae deserunt. Consequatur eum at recusandae id tenetur voluptas amet.','ipsa.jpg',1,NULL,'1986-12-30 23:42:20.000','2019-06-19 18:11:58.000')
479,(2,22,'Animi ut labore dolore atque consequuntur maxime fugit. Sunt et et facere sint. Recusandae numquam accusamus a. Non quia dolorem reiciendis earum et officiis iure.','adipisci.jpg',4582,NULL,'2017-07-19 09:44:31.000','2019-06-19 18:11:58.000')
480,(3,23,'Sint officiis a ipsa quaerat rerum ea totam. Aut perferendis deleniti error ipsa ducimus ipsam. Ipsum a sunt quis placeat.','qui.jpg',8302441,NULL,'1985-01-28 13:54:18.000','2019-06-19 18:11:58.000')
481,(4,24,'Et accusamus a et adipisci dolore. Blanditiis sit vitae dolorem voluptas temporibus numquam ab. Aut temporibus accusantium consectetur.','maxime.jpg',91764,NULL,'2006-08-07 15:24:03.000','2019-06-19 18:11:58.000')
482,(1,25,'Consequuntur animi sed ea perferendis ad magnam. Aut libero alias sequi iste qui est. Ut quo dignissimos quibusdam doloremque est est incidunt.','qui.jpg',90944,NULL,'2000-11-07 15:35:46.000','2019-06-19 18:11:58.000')
483,(2,26,'Accusantium sit praesentium voluptatem molestias architecto. Excepturi doloremque ab eligendi eum ullam voluptas qui. Inventore expedita distinctio omnis laborum laboriosam.','eveniet.jpg',317340,NULL,'1999-07-10 01:22:03.000','2019-06-19 18:11:58.000')
484,(3,27,'Et iure cupiditate expedita ut earum et illum. Cum sed assumenda velit officia. Voluptas harum ea magni aspernatur aut ea vel.','incidunt.jpg',0,NULL,'1996-06-24 05:20:00.000','2019-06-19 18:11:58.000')
485,(4,28,'A culpa nostrum et quis. Id ipsum ipsum deserunt earum eaque aut earum. Blanditiis et commodi voluptas.','eaque.jpg',9525,NULL,'1973-07-27 14:27:31.000','2019-06-19 18:11:58.000')
486,(1,29,'Cumque quod provident provident fugit cumque numquam. Fuga totam delectus a aut quaerat nemo dignissimos eos. Ratione harum et laborum qui dolore aliquam facilis numquam. At quas nam sapiente porro nesciunt voluptatum.','non.jpg',20697427,NULL,'1999-02-12 16:23:02.000','2019-06-19 18:11:58.000')
487,(2,30,'Provident quia fuga et consequatur reprehenderit repellat. Et aut cum nostrum ut beatae animi aut alias.','et.jpg',263408,NULL,'1977-02-20 10:38:19.000','2019-06-19 18:11:58.000')
488;
489INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
490(3,31,'Voluptatem est recusandae molestias quod. Voluptatem velit omnis asperiores dolorum est vero. Quo doloribus aut natus rem. Dolor sapiente libero quis sit.','et.jpg',4391,NULL,'1976-08-29 01:30:58.000','2019-06-19 18:11:58.000')
491,(4,32,'Et commodi tempora voluptate perferendis. Ullam ratione sequi in eveniet accusantium consequatur. Quod quis ipsum consectetur fuga numquam.','odio.jpg',90,NULL,'2011-05-04 15:25:34.000','2019-06-19 18:11:58.000')
492,(1,33,'Similique qui quibusdam vitae et. Voluptas nihil nesciunt reiciendis et. Incidunt necessitatibus illo asperiores quidem ipsa quam. Amet quisquam amet aut facere totam fuga quasi.','expedita.jpg',87,NULL,'2004-12-04 20:41:26.000','2019-06-19 18:11:58.000')
493,(2,34,'Eos id culpa inventore voluptatem aut placeat dolorem. Ex sunt rem esse aspernatur. Est ut ut quidem est esse. Possimus quia nisi neque.','beatae.jpg',694461,NULL,'2009-07-14 02:12:15.000','2019-06-19 18:11:58.000')
494,(3,35,'Libero ut qui dicta impedit. Consequatur earum neque quis consequatur numquam consequatur. Voluptatibus eos vel ex quis sed cum.','et.jpg',154603,NULL,'1982-03-22 20:11:50.000','2019-06-19 18:11:58.000')
495,(4,36,'Sapiente in totam sed aliquam rem qui occaecati. Dolor dignissimos omnis mollitia temporibus repellendus ut. Est esse facilis deleniti eum dolorem ex distinctio. Est nisi rerum aut optio. Quod dolor occaecati expedita quia incidunt debitis.','tenetur.jpg',6392040,NULL,'2002-02-25 18:09:15.000','2019-06-19 18:11:58.000')
496,(1,37,'Ut praesentium soluta facere sunt. Eveniet in voluptatem optio neque cumque quis ut. Dolores assumenda ullam error quis atque magni ut. Quia at aut et aliquid consectetur.','accusantium.jpg',0,NULL,'2001-12-11 00:20:19.000','2019-06-19 18:11:58.000')
497,(2,38,'Ut ab libero dolor eum deleniti porro facilis. Quo iusto perspiciatis fugiat voluptatem nam sint. Ut nisi sed et dicta eos explicabo quos.','corrupti.jpg',3,NULL,'1985-09-26 10:28:43.000','2019-06-19 18:11:58.000')
498,(3,39,'Nam voluptas omnis in quas aut. Nihil perspiciatis magni voluptatum mollitia aut nulla. Consequuntur nostrum atque nihil omnis. Velit hic eum sapiente quis molestiae deleniti.','tempore.jpg',2896602,NULL,'1986-09-26 20:25:54.000','2019-06-19 18:11:58.000')
499,(4,40,'Ea odio eveniet totam asperiores aut vel. Nihil dolores natus magnam aut delectus perspiciatis eum ullam. Magnam est cupiditate earum fuga aut numquam. Delectus modi ut occaecati est et aut.','necessitatibus.jpg',0,NULL,'1992-02-13 22:01:03.000','2019-06-19 18:11:58.000')
500;
501INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
502(1,41,'Dolorem molestias similique laboriosam et. Incidunt earum voluptatem magnam voluptas eligendi quos. Cum voluptatem quia odio sed. Ut voluptatum ex sint illum molestias perferendis laborum.','sapiente.jpg',816152694,NULL,'1990-10-06 08:14:28.000','2019-06-19 18:11:58.000')
503,(2,42,'Id illo quia corporis. Magni id illo commodi natus. Eos porro error nihil optio quia.','dolorem.jpg',7095,NULL,'1997-02-27 21:12:18.000','2019-06-19 18:11:58.000')
504,(3,43,'Eos omnis error quis est debitis. Itaque adipisci voluptatibus velit autem. Tempora quo saepe nesciunt sapiente sequi hic.','illo.jpg',1520673,NULL,'1986-07-05 22:35:21.000','2019-06-19 18:11:58.000')
505,(4,44,'Dolore non repellat mollitia dolor ut sequi. Excepturi enim dolorem mollitia eaque sit porro ab. Eos consequatur hic dolore itaque quia animi ea.','dignissimos.jpg',548,NULL,'2002-12-21 03:54:14.000','2019-06-19 18:11:58.000')
506,(1,45,'Cupiditate modi molestiae culpa delectus est et voluptatem. Eius non impedit asperiores praesentium repellendus tempore. Minus natus quod eos quidem.','qui.jpg',7380,NULL,'2016-05-23 13:35:39.000','2019-06-19 18:11:58.000')
507,(2,46,'Provident dignissimos necessitatibus ut et esse. Excepturi et iste facere id suscipit ut. Voluptatem est ex et dolor nobis facilis et. Ut voluptatibus sunt et ut.','aut.jpg',14685,NULL,'2009-12-02 01:42:24.000','2019-06-19 18:11:58.000')
508,(3,47,'In mollitia consequatur aspernatur atque. Alias illum voluptatem et nemo et exercitationem. Voluptatem in ut quia similique quis. Saepe cupiditate sunt tenetur minima.','laborum.jpg',3,NULL,'2010-12-16 09:47:22.000','2019-06-19 18:11:58.000')
509,(4,48,'Quidem ad libero voluptas et veniam. Dolores dolores quia voluptatem soluta. Voluptatibus facere saepe non nulla.','consequatur.jpg',490,NULL,'1977-01-14 01:24:52.000','2019-06-19 18:11:58.000')
510,(1,49,'Esse eveniet similique sit temporibus aliquam. Sequi consequatur excepturi enim aut. Mollitia voluptas facilis velit omnis animi ea numquam. Accusamus nostrum aspernatur ullam itaque et eveniet quia. Corrupti tempora fugit rerum architecto voluptatem pariatur.','quae.jpg',26430194,NULL,'1990-08-09 00:43:45.000','2019-06-19 18:11:58.000')
511,(2,50,'Molestiae excepturi quia necessitatibus id voluptatem laudantium. Et ut ea mollitia quisquam. Vel consequatur quas excepturi totam sit suscipit. Aut tempora ratione eos ipsam quae possimus libero. Architecto et quia voluptatem et tempora alias sequi.','nulla.jpg',0,NULL,'1995-04-23 07:55:46.000','2019-06-19 18:11:58.000')
512;
513INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
514(3,51,'Omnis quaerat minus inventore quaerat. Ut sunt optio similique laboriosam. Fugit voluptas nesciunt debitis possimus tempore. Architecto sunt maiores laborum quod laboriosam.','dolorem.jpg',38,NULL,'1976-09-18 10:50:57.000','2019-06-19 18:11:58.000')
515,(4,52,'Ullam unde earum dolorem. Vel doloremque harum optio deserunt iure. Voluptate at animi veniam suscipit quisquam.','dolorum.jpg',447,NULL,'2015-10-20 01:11:46.000','2019-06-19 18:11:58.000')
516,(1,53,'Ut distinctio non vero qui. Accusantium a consectetur magnam eum quisquam molestias. Sequi et quam fuga ut sint.','impedit.jpg',874783484,NULL,'1988-08-22 10:39:27.000','2019-06-19 18:11:58.000')
517,(2,54,'Fugiat rem eveniet laborum eius ipsa. Soluta provident nihil dolor aliquid ut modi magnam delectus. Ratione amet dolores quam molestiae blanditiis.','voluptas.jpg',86837,NULL,'2010-01-19 21:57:21.000','2019-06-19 18:11:58.000')
518,(3,55,'Consequatur voluptatem et sequi voluptatibus ut accusamus perferendis. Aut perspiciatis laboriosam ut consectetur. Ducimus omnis rem ut unde nobis sit rerum laborum. Reiciendis quaerat amet consequatur velit excepturi deserunt atque. Sed natus quibusdam quidem pariatur.','et.jpg',868,NULL,'2014-09-09 19:10:38.000','2019-06-19 18:11:58.000')
519,(4,56,'Non est quia doloribus sed. Voluptates vitae necessitatibus molestiae quo dolorum mollitia at. Quos rem omnis porro nulla vero tempore similique ratione. Mollitia quo quo et et non laboriosam perferendis sit.','aliquid.jpg',10461638,NULL,'1988-06-16 01:16:35.000','2019-06-19 18:11:58.000')
520,(1,57,'Quia provident autem nisi quisquam rerum. Inventore nostrum dolores eum explicabo hic ipsum deserunt. Eos et eum aut.','maiores.jpg',482028,NULL,'2016-05-20 20:16:27.000','2019-06-19 18:11:58.000')
521,(2,58,'Repellat minima animi iure explicabo blanditiis sed. Incidunt vel animi reprehenderit quisquam reprehenderit. Dolor ut ipsum deleniti ut officia. Velit sequi consequatur nemo nam sed rerum.','dolorem.jpg',142917961,NULL,'1974-05-05 20:37:58.000','2019-06-19 18:11:58.000')
522,(3,59,'Assumenda ipsum officiis fuga unde itaque eveniet magni. Quasi assumenda qui sed quod quis. Amet sit dolores accusantium voluptatem omnis unde soluta.','unde.jpg',6099,NULL,'1972-08-24 05:37:28.000','2019-06-19 18:11:58.000')
523,(4,60,'Non est animi consequatur. Neque aliquid aut voluptatem aut inventore ut. Maiores hic voluptas nesciunt. Nulla vel facilis deleniti tempore.','dignissimos.jpg',783631045,NULL,'2006-11-01 15:16:53.000','2019-06-19 18:11:58.000')
524;
525INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
526(1,61,'Debitis neque est ratione. Quia quod ab ut sit et neque quam. Illum suscipit voluptas est amet dolores sit perspiciatis cumque. Eos est et veritatis non esse.','nisi.jpg',914587,NULL,'1983-12-22 21:47:23.000','2019-06-19 18:11:58.000')
527,(2,62,'Nihil quasi doloremque rerum velit non libero. Non veritatis perspiciatis autem. Expedita rerum nihil aliquam.','sint.jpg',86964,NULL,'2011-09-12 11:05:53.000','2019-06-19 18:11:58.000')
528,(3,63,'Nesciunt aut sint nam dolor facilis ut est. Odit dolores assumenda dolore.','ipsum.jpg',689891921,NULL,'2008-05-10 05:19:10.000','2019-06-19 18:11:58.000')
529,(4,64,'Aliquid facere dignissimos quidem quo et beatae. Non qui dolore velit. Nemo non asperiores architecto corporis ratione.','velit.jpg',767,NULL,'1981-11-28 00:43:00.000','2019-06-19 18:11:58.000')
530,(1,65,'Id quos rerum delectus quas porro eos. Qui in accusantium nihil et possimus. Qui doloribus dolores a deserunt illo.','ducimus.jpg',663,NULL,'2005-01-31 02:53:19.000','2019-06-19 18:11:58.000')
531,(2,66,'Ipsa odit ut sed et. Eos vero aut veritatis doloribus ipsam et at repellendus. Fugiat sequi sint aliquam nostrum voluptate. Omnis quaerat consequatur cum.','mollitia.jpg',66726632,NULL,'1970-10-07 22:45:18.000','2019-06-19 18:11:58.000')
532,(3,67,'Placeat aut consequatur unde sed qui voluptatum. Harum ut quasi reprehenderit nostrum et. Facilis magnam consectetur ea suscipit accusantium.','enim.jpg',213578,NULL,'2015-06-20 15:21:47.000','2019-06-19 18:11:58.000')
533,(4,68,'Quod assumenda impedit aut odio consequatur aut quisquam. In officia mollitia nobis. Non accusantium ut tempore.','iure.jpg',0,NULL,'1996-05-24 05:33:17.000','2019-06-19 18:11:58.000')
534,(1,69,'Nemo eum et placeat non et repellat consequuntur. Rem vitae rerum sed aut numquam voluptatum quia. Magni itaque rerum laboriosam saepe molestias a.','voluptas.jpg',8488,NULL,'1973-03-06 04:36:40.000','2019-06-19 18:11:58.000')
535,(2,70,'Alias qui dolores tempore est. Molestiae necessitatibus debitis nihil qui. Et molestiae voluptatem doloribus tempore enim veritatis tenetur. Consequatur qui non debitis voluptas et in soluta.','aut.jpg',96,NULL,'2001-09-09 22:19:46.000','2019-06-19 18:11:58.000')
536;
537INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
538(3,71,'Ipsam velit maiores sit expedita distinctio. Nostrum corrupti similique officiis et et dolor. Quasi autem voluptas voluptas id molestias.','dicta.jpg',968311915,NULL,'1979-02-24 11:29:37.000','2019-06-19 18:11:58.000')
539,(4,72,'Natus vel est aspernatur qui velit adipisci sunt. Qui facilis cupiditate accusantium ut excepturi sequi esse. Numquam ipsam eos exercitationem qui perspiciatis. Sint quia consectetur recusandae in deserunt.','voluptate.jpg',985362,NULL,'2018-05-05 17:56:57.000','2019-06-19 18:11:58.000')
540,(1,73,'Atque et sint quam maxime. Beatae necessitatibus soluta quos qui qui explicabo aut. Cupiditate quisquam quis ab modi. Modi aut explicabo voluptates rerum ut quaerat.','modi.jpg',3,NULL,'2000-10-06 09:42:23.000','2019-06-19 18:11:58.000')
541,(2,74,'Sint nemo quasi est. Nulla vitae aut eveniet id exercitationem. Culpa eveniet neque ut minus ea eos.','possimus.jpg',17341,NULL,'1988-09-11 12:40:20.000','2019-06-19 18:11:58.000')
542,(3,75,'Sed sed ad eum commodi quam nulla perspiciatis doloremque. Corporis debitis nostrum harum consequuntur molestiae aut et. Voluptatibus in eos consequatur commodi molestiae.','eaque.jpg',778,NULL,'2012-12-31 08:29:33.000','2019-06-19 18:11:58.000')
543,(4,76,'Quisquam consequuntur deleniti rerum et dolorum sapiente voluptatem. Laudantium voluptatibus rem repudiandae omnis voluptas harum sed. Nam officiis dignissimos ut similique ipsum et architecto ullam. Ipsa illo veniam fuga ullam.','iste.jpg',6,NULL,'1998-12-20 23:58:27.000','2019-06-19 18:11:58.000')
544,(1,77,'Sequi vero nostrum sint dolores ratione aut et. Iure qui voluptas molestiae recusandae. Ut perferendis consequatur sed dolorum deleniti nobis exercitationem. Voluptas cumque laudantium aut quibusdam quia ex.','est.jpg',86,NULL,'1981-08-11 16:46:58.000','2019-06-19 18:11:58.000')
545,(2,78,'Similique sit deserunt assumenda inventore sunt dolorem. Nihil quo rerum vel assumenda. Saepe dolorum reiciendis et esse ipsam amet quod. Et nam et earum eveniet debitis et nesciunt.','omnis.jpg',8603,NULL,'1981-11-02 11:26:06.000','2019-06-19 18:11:58.000')
546,(3,79,'Sed qui ad quibusdam eaque dolores. Quia earum quis corporis non. Tempore consequatur qui a cupiditate.','ad.jpg',5346,NULL,'1996-01-26 17:47:20.000','2019-06-19 18:11:58.000')
547,(4,80,'Facilis a ducimus ad. Ipsam rerum iure assumenda veniam dolorem consequatur quasi occaecati. Aut sed est et sapiente aspernatur illo accusamus. Voluptatem asperiores quaerat sit sit.','dignissimos.jpg',58481,NULL,'1989-09-23 11:33:51.000','2019-06-19 18:11:58.000')
548;
549INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
550(1,81,'Quidem et eius doloremque ratione. Qui modi ipsum est officia et dolores. Molestias porro non velit totam.','rerum.jpg',5209165,NULL,'1990-06-19 20:06:13.000','2019-06-19 18:11:58.000')
551,(2,82,'Perferendis et et enim beatae ut voluptas velit. Officiis perspiciatis sed quaerat rem. Fuga laborum quia sed amet laboriosam voluptatem.','dolores.jpg',47161319,NULL,'1974-09-03 13:54:26.000','2019-06-19 18:11:58.000')
552,(3,83,'Delectus expedita libero fuga accusamus qui. Accusantium dolores iste nihil mollitia voluptatum. Eum error repellendus suscipit quia nisi culpa ut reiciendis. Tempore et reiciendis quaerat culpa.','quos.jpg',39321,NULL,'1995-07-10 19:13:21.000','2019-06-19 18:11:58.000')
553,(4,84,'Repudiandae dolor illum est maxime sapiente aut perspiciatis. Sunt reiciendis molestiae commodi at odit est. Qui fuga voluptatibus sunt animi velit non et.','et.jpg',2,NULL,'1971-04-15 17:44:35.000','2019-06-19 18:11:58.000')
554,(1,85,'Nisi iusto cum sed quam est cupiditate. Et praesentium necessitatibus ipsam maiores expedita. Velit autem possimus et labore.','deserunt.jpg',5929496,NULL,'2004-04-29 20:55:06.000','2019-06-19 18:11:58.000')
555,(2,86,'Ea sapiente voluptatem dolores a temporibus enim. Rerum quasi quo atque modi. Autem repellendus vitae esse aspernatur iure natus reprehenderit. Quo aut fugit dolorem atque qui voluptate atque ullam.','possimus.jpg',92,NULL,'2019-02-23 20:58:44.000','2019-06-19 18:11:58.000')
556,(3,87,'Dignissimos non qui est eligendi in. Et hic ea quidem et facilis.','sint.jpg',141,NULL,'2015-08-30 07:22:54.000','2019-06-19 18:11:58.000')
557,(4,88,'Ipsa dolores voluptatem maxime rem dolores dolores. Cupiditate doloribus porro in fuga ut. Aut aut nihil repellendus nisi asperiores. Ut voluptas id in veniam voluptatem veritatis.','rem.jpg',74236435,NULL,'1971-12-03 21:35:48.000','2019-06-19 18:11:58.000')
558,(1,89,'Doloremque rerum placeat dolores ut error. Assumenda dolores voluptatem nihil consequatur et aspernatur ab. Ducimus rerum et minus doloribus at ullam.','quo.jpg',258,NULL,'1984-01-05 19:50:11.000','2019-06-19 18:11:58.000')
559,(2,90,'Aliquid rerum sit natus deserunt. Nihil sint in ut facere eum. Quibusdam magnam ut qui officia quod dolore.','odio.jpg',163,NULL,'1978-08-29 20:13:55.000','2019-06-19 18:11:58.000')
560;
561INSERT INTO media (media_type_id,user_id,body,filename,`size`,metadata,created_at,updated_at) VALUES 
562(3,91,'Laboriosam non quia et blanditiis. Nihil ut est non autem voluptatibus. Molestiae reprehenderit at est sed sint enim. Voluptatibus ex eligendi doloribus non quaerat nostrum dignissimos. Architecto in veniam laboriosam inventore beatae.','autem.jpg',1,NULL,'1988-11-12 22:11:24.000','2019-06-19 18:11:58.000')
563,(4,92,'Vero esse suscipit non quis sed temporibus. Consectetur sit vel distinctio repellendus deleniti veniam qui. Eius veritatis at tempore quia.','neque.jpg',2,NULL,'2009-05-27 09:49:55.000','2019-06-19 18:11:58.000')
564,(1,93,'Repellat delectus nulla est nulla cum. Voluptas eum aut necessitatibus sit animi illo impedit aut. Consectetur aut et excepturi porro esse. Sint praesentium autem deleniti omnis et harum vitae. Minima error dolores voluptas provident cupiditate officiis.','et.jpg',93,NULL,'1987-09-12 21:34:04.000','2019-06-19 18:11:58.000')
565,(2,94,'Tempore corrupti vel nemo doloremque quibusdam expedita. Similique sit quam quis dolorum non excepturi. Rem voluptas laborum quos voluptas vel et. Error eveniet ea cum minus nihil officia dolorum. Ullam qui voluptatem autem ut.','quisquam.jpg',5591,NULL,'1998-08-05 08:54:38.000','2019-06-19 18:11:58.000')
566,(3,95,'Labore velit ipsam et sint voluptas. Necessitatibus maxime nihil repellendus quo cupiditate. Sit ad qui nemo. Sed magnam quia eos dignissimos in quo iusto.','maiores.jpg',0,NULL,'2007-08-10 00:40:53.000','2019-06-19 18:11:58.000')
567,(4,96,'Ducimus possimus dolorem quia corrupti dolore. Omnis nam ea eum culpa distinctio ex optio aut. Voluptas non facilis quo natus corrupti perferendis. Illo rerum ut explicabo sit.','ipsum.jpg',667274,NULL,'2011-03-10 23:39:19.000','2019-06-19 18:11:58.000')
568,(1,97,'Voluptatem corrupti exercitationem nulla est itaque. Ipsum quaerat similique ut dolorum. Qui aliquid neque labore alias ut placeat.','non.jpg',62,NULL,'1996-01-18 02:10:58.000','2019-06-19 18:11:58.000')
569,(2,98,'Qui aspernatur aut sit veniam. Aliquam nisi fuga facere. Asperiores aut beatae laboriosam libero. Fugiat id perspiciatis a dolores voluptatem ad earum.','aut.jpg',801927073,NULL,'1980-01-09 06:19:44.000','2019-06-19 18:11:58.000')
570,(3,99,'Assumenda iure delectus optio blanditiis atque occaecati. Ea assumenda dolor quibusdam nemo aut. Fugiat omnis velit quod. Sequi nihil quis consequatur sit et.','est.jpg',707,NULL,'1985-07-16 10:26:38.000','2019-06-19 18:11:58.000')
571,(4,100,'Deserunt accusantium laudantium ab soluta facilis assumenda. Et temporibus ab corporis dolorum rem qui. Ipsa veritatis amet voluptas quod. Ut incidunt illo ullam fugit optio recusandae.','doloribus.jpg',4,NULL,'2011-08-04 09:10:30.000','2019-06-19 18:11:58.000')
572;
573
574DROP TABLE IF EXISTS likes;
575CREATE TABLE likes(
576	id SERIAL PRIMARY KEY,
577    user_id BIGINT UNSIGNED NOT NULL,
578    media_id BIGINT UNSIGNED NOT NULL,
579    created_at DATETIME DEFAULT NOW()
580    , FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE restrict
581    , FOREIGN KEY (media_id) REFERENCES media(id)
582);
583INSERT INTO `likes` VALUES 
584('1','1','1','1988-10-14 18:47:39'),
585('2','2','1','1988-09-04 16:08:30'),
586('3','3','1','1994-07-10 22:07:03'),
587('4','4','1','1991-05-12 20:32:08'),
588('5','5','2','1978-09-10 14:36:01'),
589('6','6','2','1992-04-15 01:27:31'),
590('7','7','2','2003-02-03 04:56:27'),
591('8','8','8','2017-04-24 09:30:19'),
592('9','9','9','1974-02-07 20:53:55'),
593('10','10','10','1973-05-11 03:21:40'),
594('11','11','11','2008-12-17 13:03:56'),
595('12','12','12','1995-07-17 21:22:38'),
596('13','13','13','1985-09-07 23:34:21'),
597('14','14','14','1973-01-27 23:11:53'),
598('15','1','15','1974-02-07 20:53:55'),
599('16','1','16','1973-05-11 03:21:40'),
600('17','1','17','2008-12-17 13:03:56'),
601('18','1','18','1995-07-17 21:22:38'),
602('19','1','19','1985-09-07 23:34:21'),
603('20','1','20','1973-01-27 23:11:53')
604; 
605
606DROP TABLE IF EXISTS `profiles`;
607CREATE TABLE `profiles` (
608	user_id SERIAL PRIMARY KEY,
609    gender CHAR(1),
610    birthday DATE,
611	photo_id BIGINT UNSIGNED NULL,
612    created_at DATETIME DEFAULT NOW(),
613    hometown VARCHAR(100),
614    FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE restrict,
615    FOREIGN KEY (photo_id) REFERENCES media(id)
616);
617INSERT INTO `profiles` VALUES 
618('1','f','1976-11-08','1','1970-01-18 03:54:01','Adriannaport'),
619('2','f','2011-12-20','2','1994-11-06 23:56:10','North Nettieton'),
620('3','m','1994-06-15','3','1975-11-27 02:27:11','Padbergtown'),
621('4','f','1979-11-07','4','1994-04-12 04:31:49','Port Rupertville'),
622('5','f','1976-04-19','5','1976-07-05 02:25:30','Spencerfort'),
623('6','f','1983-09-07','6','1981-06-20 15:54:43','South Woodrowmouth'),
624('7','m','2014-07-31','7','1997-06-21 07:52:05','South Jeffereyshire'),
625('8','f','1975-03-26','8','2008-08-18 18:23:25','Howeside'),
626('9','f','1982-11-01','9','2014-09-29 01:22:26','Loweborough'),
627('10','m','1977-05-14','10','1980-03-17 18:17:45','New Nellaside'),
628('11','m','1988-10-28','11','2011-08-22 08:31:06','New Skylar'),
629('12','f','1994-02-07','12','2015-08-04 16:34:50','South Dameontown'),
630('13','f','1998-08-08','13','1978-02-12 03:14:55','North Terencemouth'),
631('14','f','1973-11-16','14','2015-03-13 03:01:16','West Wilfordshire'),
632('15','m','1979-08-20','15','1983-08-13 03:48:56','North Xavier'),
633('16','m','1997-03-17','16','1989-09-08 23:17:00','Port Kayton'),
634('17','m','2015-02-25','17','1992-10-29 05:38:24','New Odie'),
635('18','f','2011-04-05','18','1981-08-22 06:53:53','South Newton'),
636('19','f','1981-01-24','19','1975-08-17 04:48:38','Port Jovanyview'),
637('20','f','2010-03-12','20','2008-02-11 09:39:28','Port Adolfoville'),
638('21','f','1971-02-01','21','1972-09-21 21:31:09','Kleinbury'),
639('22','f','2000-08-30','22','1977-03-15 13:44:30','South Ciara'),
640('23','f','1991-08-17','23','1991-10-15 01:01:05','Magdalenahaven'),
641('24','m','2008-08-26','24','2016-06-23 23:04:39','Port Jettchester'),
642('25','f','2005-03-19','25','2002-11-21 22:26:09','West Juneview'),
643('26','m','1970-03-17','26','1995-06-07 00:37:46','South Jose'),
644('27','m','2011-01-12','27','1992-03-18 22:28:05','Christinahaven'),
645('28','m','2000-01-22','28','2003-06-16 16:15:57','Lednerstad'),
646('29','f','1988-02-16','29','1988-02-09 12:47:21','Lisandrofort'),
647('30','m','1977-08-16','30','1977-03-09 23:28:37','Sethfort'),
648('31','f','1978-11-28','31','2008-01-31 16:16:06','Tessieport'),
649('32','f','2004-02-06','32','1995-11-19 13:46:21','Lake Reilly'),
650('33','f','2000-05-07','33','1991-11-21 16:14:32','East Rosalinda'),
651('34','f','1988-11-22','34','2008-08-17 22:20:26','Lake Henderson'),
652('35','f','2008-08-28','35','1991-07-07 07:37:17','Melanyport'),
653('36','m','2004-02-05','36','1973-11-04 03:21:50','Bryanaland'),
654('37','m','2012-01-21','37','2014-11-25 14:47:51','South Lorenstad'),
655('38','f','1999-10-17','38','1990-04-29 04:32:11','Rocioport'),
656('39','f','1991-02-16','39','1976-09-18 06:18:30','New Petra'),
657('40','m','1993-08-26','40','1976-10-03 19:24:42','Wizabury'),
658('41','m','2005-07-31','41','1997-04-11 10:03:16','Port Elton'),
659('42','m','2000-01-08','42','1971-02-20 18:14:51','New Hannahchester'),
660('43','f','1996-01-09','43','1999-05-18 06:05:39','North Deion'),
661('44','f','1976-02-16','44','1997-09-01 08:44:31','Lake Johnpaulport'),
662('45','f','2018-10-20','45','1995-04-02 18:37:27','East Ivybury'),
663('46','m','1981-03-05','46','1978-01-04 19:53:38','West Zula'),
664('47','m','1973-06-27','47','1992-08-24 13:18:15','Medatown'),
665('48','f','1974-11-15','48','1992-12-01 00:54:49','Medhursthaven'),
666('49','f','1987-11-04','49','1973-10-23 18:53:51','Kileyton'),
667('50','m','1971-05-09','50','1974-01-17 03:57:15','East Electaland'),
668('51','m','1985-01-12','51','1998-06-20 11:06:11','Isabellaland'),
669('52','m','1989-06-05','52','1986-09-23 20:01:28','Lake Houston'),
670('53','f','2010-12-11','53','2002-08-02 09:00:39','Lake Mohammad'),
671('54','m','1975-05-29','54','1973-09-21 12:52:05','Odessaside'),
672('55','m','1996-06-27','55','1974-07-07 05:47:32','West Jordy'),
673('56','m','1976-08-28','56','1994-10-13 21:37:38','Laceybury'),
674('57','f','2016-05-22','57','2007-10-31 21:36:34','Port Zelmastad'),
675('58','f','1999-10-10','58','2003-06-03 17:27:10','Vivienberg'),
676('59','m','2008-12-12','59','2015-11-19 11:12:16','West Sibyl'),
677('60','m','1999-09-14','60','1981-02-06 04:05:26','Antwantown'),
678('61','m','2005-02-09','61','1972-07-02 08:34:26','New Nonaview'),
679('62','f','1993-07-09','62','1996-12-19 03:17:29','Hilarioland'),
680('63','f','2012-04-04','63','1978-12-23 11:06:08','South Skylarmouth'),
681('64','f','2005-10-07','64','2010-10-31 01:21:49','West Bernadine'),
682('65','f','1992-11-02','65','1971-10-15 06:36:08','New Kacie'),
683('66','m','2009-10-12','66','1993-10-20 16:49:29','New Doylefort'),
684('67','f','1982-08-16','67','1990-01-23 22:14:55','West Kellihaven'),
685('68','f','2006-05-13','68','1997-04-29 02:49:42','East Ottis'),
686('69','m','2003-09-20','69','1987-02-12 08:27:11','Busterfort'),
687('70','f','2011-09-09','70','2017-05-04 11:35:24','Kassandrachester'),
688('71','f','1979-10-23','71','1993-10-23 12:37:59','North Estelle'),
689('72','f','1978-07-10','72','1990-09-16 18:57:43','Sonyachester'),
690('73','m','1993-07-13','73','1992-08-10 05:04:44','West Mozelle'),
691('74','m','1977-12-04','74','2009-09-19 18:30:49','South Kayleeton'),
692('75','f','1981-08-27','75','1974-12-15 01:52:32','Port Abdul'),
693('76','f','1998-02-10','76','2012-05-22 12:05:10','Lake Kellyland'),
694('77','m','1973-10-17','77','1984-06-22 12:10:24','West Alice'),
695('78','f','2018-10-25','78','1994-03-02 05:14:12','New Danykaberg'),
696('79','m','1990-06-28','79','2010-03-06 20:16:13','Port Nickolaschester'),
697('80','m','2006-10-08','80','2007-10-20 17:07:41','South Marleeburgh'),
698('81','m','1972-02-09','81','2012-02-18 04:33:04','South Elizabethside'),
699('82','f','1971-09-28','82','1979-09-10 00:00:36','Volkmanberg'),
700('83','m','1987-11-02','83','1994-02-03 03:15:34','South Bernita'),
701('84','f','2019-03-20','84','1979-09-08 02:29:57','Rennerfort'),
702('85','m','2013-06-30','85','2003-12-31 09:46:13','New Dagmar'),
703('86','f','1974-12-29','86','1978-05-13 16:58:53','West Cade'),
704('87','f','2006-04-20','87','2006-10-20 00:25:45','New Alycia'),
705('88','f','1995-12-10','88','2000-04-28 19:55:37','Hermanmouth'),
706('89','f','1972-05-13','89','2010-09-05 17:54:37','East Aliyah'),
707('90','m','2006-08-02','90','2007-10-11 03:49:30','Majorland'),
708('91','f','1988-11-18','91','2000-05-01 02:03:19','Sydneeport'),
709('92','f','1983-07-24','92','1977-10-20 00:24:36','Trinityland'),
710('93','m','2015-04-16','93','2003-01-06 17:49:50','South Noeliaton'),
711('94','f','2016-09-20','94','1990-07-07 06:28:12','South Kirstin'),
712('95','m','1980-10-15','95','1974-09-15 21:30:36','West Coryville'),
713('96','m','1984-10-02','96','1972-05-04 20:10:50','Hettingerside'),
714('97','f','1971-12-10','97','2005-07-14 15:03:46','Dooleyland'),
715('98','f','2005-09-07','98','1990-04-06 05:48:14','Lockmantown'),
716('99','f','1996-10-09','99','1981-09-24 02:19:44','Lake Lora'),
717('100','f','1990-02-11','100','1974-08-23 15:31:47','Port Mable'); 
718