fWnQHNcJ

1/*Домашнее задание. */
2DROP DATABASE IF EXISTS vk;
3CREATE DATABASE vk;
4USE vk;
5
6DROP TABLE IF EXISTS users;
7CREATE TABLE users (
8  id SERIAL PRIMARY KEY,
9    firstname VARCHAR(100),
10    lastname VARCHAR(100) COMMENT 'Фамилия',
11    email VARCHAR(100) UNIQUE,
12    password_hash varchar(100),
13    phone BIGINT,
14    is_deleted bit default 0,
15    INDEX users_firstname_lastname_idx(firstname, lastname)
16);
17
18DROP TABLE IF EXISTS `profiles`;
19CREATE TABLE `profiles` (
20  user_id SERIAL PRIMARY KEY,
21    birthday DATE,
22  photo_id BIGINT UNSIGNED NULL,
23    created_at DATETIME DEFAULT NOW(),
24    hometown VARCHAR(100)
25);
26
27ALTER TABLE `profiles` ADD CONSTRAINT fk_user_id
28    FOREIGN KEY (user_id) REFERENCES users(id)
29    ON UPDATE CASCADE ON DELETE CASCADE;
30
31DROP TABLE IF EXISTS messages;
32CREATE TABLE messages (
33  id SERIAL PRIMARY KEY,
34  from_user_id BIGINT UNSIGNED NOT NULL,
35    to_user_id BIGINT UNSIGNED NOT NULL,
36    body TEXT,
37    created_at DATETIME DEFAULT NOW(),
38    FOREIGN KEY (from_user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE,
39    FOREIGN KEY (to_user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE
40);
41
42DROP TABLE IF EXISTS friend_requests;
43CREATE TABLE friend_requests (
44  initiator_user_id BIGINT UNSIGNED NOT NULL,
45    target_user_id BIGINT UNSIGNED NOT NULL,
46    `status` ENUM('requested', 'approved', 'declined', 'unfriended'),
47  requested_at DATETIME DEFAULT NOW(),
48  updated_at DATETIME on update now(),
49    PRIMARY KEY (initiator_user_id, target_user_id),
50    FOREIGN KEY (initiator_user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE,
51    FOREIGN KEY (target_user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE
52);
53
54DROP TABLE IF EXISTS communities;
55CREATE TABLE communities(
56  id SERIAL PRIMARY KEY,
57  name VARCHAR(150),
58  admin_user_id BIGINT UNSIGNED,
59  INDEX communities_name_idx(name),
60  FOREIGN KEY (admin_user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE SET NULL
61);
62
63DROP TABLE IF EXISTS users_communities;
64CREATE TABLE users_communities(
65  user_id BIGINT UNSIGNED NOT NULL,
66  community_id BIGINT UNSIGNED NOT NULL,
67  PRIMARY KEY (user_id, community_id),
68    FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE,
69    FOREIGN KEY (community_id) REFERENCES communities(id) ON UPDATE CASCADE ON DELETE CASCADE
70);
71
72DROP TABLE IF EXISTS media_types;
73CREATE TABLE media_types(
74  id SERIAL PRIMARY KEY,
75    name VARCHAR(255),
76    created_at DATETIME DEFAULT NOW(),
77    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
78);
79
80DROP TABLE IF EXISTS media;
81CREATE TABLE media(
82  id SERIAL PRIMARY KEY,
83    media_type_id BIGINT UNSIGNED,
84    user_id BIGINT UNSIGNED NOT NULL,
85    body text,
86    filename VARCHAR(255),
87    `size` INT,
88  metadata JSON,
89    created_at DATETIME DEFAULT NOW(),
90    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
91    FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE,
92    FOREIGN KEY (media_type_id) REFERENCES media_types(id) ON UPDATE CASCADE ON DELETE SET NULL
93);
94
95DROP TABLE IF EXISTS likes;
96CREATE TABLE likes(
97  id SERIAL PRIMARY KEY,
98    user_id BIGINT UNSIGNED NOT NULL,
99    media_id BIGINT UNSIGNED NOT NULL,
100    created_at DATETIME DEFAULT NOW(),
101    FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE,
102    FOREIGN KEY (media_id) REFERENCES media(id) ON UPDATE CASCADE ON DELETE CASCADE
103
104);
105
106DROP TABLE IF EXISTS `photo_albums`;
107CREATE TABLE `photo_albums` (
108  `id` SERIAL,
109  `name` varchar(255) DEFAULT NULL,
110    `user_id` BIGINT UNSIGNED DEFAULT NULL,
111
112    FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE SET NULL,
113    PRIMARY KEY (`id`)
114);
115
116DROP TABLE IF EXISTS `photos`;
117CREATE TABLE `photos` (
118  id SERIAL PRIMARY KEY,
119  `album_id` BIGINT unsigned NOT NULL,
120  `media_id` BIGINT unsigned NOT NULL,
121
122  FOREIGN KEY (album_id) REFERENCES photo_albums(id) ON UPDATE CASCADE ON DELETE CASCADE,
123    FOREIGN KEY (media_id) REFERENCES media(id) ON UPDATE CASCADE ON DELETE CASCADE
124);
125
126ALTER TABLE `profiles` ADD CONSTRAINT fk_photo_id
127    FOREIGN KEY (photo_id) REFERENCES photos(id)
128    ON UPDATE CASCADE ON DELETE set NULL;
129    
130/* Домашнее задание.
131Практическое задание по теме “Введение в проектирование БД”
132Написать cкрипт, добавляющий в БД vk, которую создали на 3 вебинаре, 3-4 новые таблицы (с перечнем полей, указанием индексов и внешних ключей).
133(по желанию: организовать все связи 1-1, 1-М, М-М)*/
134
135DROP TABLE IF EXISTS pets_types;
136CREATE TABLE pets_types(
137  id SERIAL PRIMARY KEY,
138  pets_type VARCHAR(100)
139);
140DROP TABLE IF EXISTS pets;
141CREATE TABLE pets(
142  id SERIAL PRIMARY KEY,
143  pets_type BIGINT UNSIGNED NOT NULL,
144  pets_name VARCHAR(100),
145  pets_age INT UNSIGNED NOT NULL,
146  INDEX pets_pets_type_idx(pets_name), -- животных может быть очень много
147  FOREIGN KEY (pets_type) REFERENCES pets_types(id) ON UPDATE CASCADE ON DELETE SET NULL-- 1:M
148);
149DROP TABLE IF EXISTS users_pets; -- табличка для образования связи М:М
150CREATE TABLE users_pets(
151  user_id BIGINT UNSIGNED NOT NULL,
152  pets_id BIGINT UNSIGNED NOT NULL,
153  PRIMARY KEY (user_id, pets_id), -- составной ключ. Один пользователь не может быть хозяином одного и того же животного больше одного раза, животное не может быть питомцем одного пользователя больше одного раза 
154  FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE SET NULL,
155  FOREIGN KEY (pets_id) REFERENCES pets(id) ON UPDATE CASCADE ON DELETE SET NULL
156);
157
158DROP TABLE IF EXISTS gender_id;
159CREATE TABLE gender_id(
160  id INT UNSIGNED NOT NULL PRIMARY KEY,
161  gender VARCHAR(50) -- в связи с мировыми тенденциями может быть актуально)
162);
163
164DROP TABLE IF EXISTS users_gender; 
165CREATE TABLE users_gender(
166  user_id SERIAL PRIMARY KEY, -- у одного пользователя не может быть больше одного пола
167  gender_id INT UNSIGNED NOT NULL,
168  FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE SET NULL,
169  FOREIGN KEY (gender_id) REFERENCES gender_id(id) ON UPDATE CASCADE ON DELETE SET NULL
170);
171
172/*Практическое задание к уроку 4 CRUD-операции.
173
1741. Заполнить все таблицы БД vk данными (по 10-100 записей в каждой таблице).*/
175
176INSERT INTO `media_types` VALUES (1,'velit','2010-02-14 20:36:48','1997-09-27 03:45:08'),(2,'ad','1976-09-16 00:58:38','1982-07-25 08:14:56'),(3,'in','1984-07-30 02:44:43','2009-07-08 11:11:29'),(4,'numquam','1971-06-28 04:03:42','1995-02-23 11:25:45'),(5,'cupiditate','2018-06-11 22:35:42','2008-01-23 17:00:55'),(6,'sunt','2008-01-12 21:50:52','1987-12-05 19:57:35'),(7,'illum','2020-01-29 08:26:52','1988-04-28 11:47:46'),(8,'laborum','2010-12-01 19:38:26','1975-10-21 11:59:31'),(9,'nihil','2010-09-24 08:18:19','1984-02-08 01:58:47'),(10,'soluta','1998-03-20 14:04:38','1980-05-20 15:33:32');
177INSERT INTO `media` VALUES (1,1,1,'Quasi soluta ad nesciunt. Quo aut tempora velit sit minima.','eum',618,NULL,'1973-01-02 19:31:47','1979-05-07 12:10:03'),(2,2,2,'Quia qui et earum nihil et corporis eligendi. Illo maiores voluptas enim voluptatem voluptatem quia dignissimos. Aut error praesentium doloremque ea omnis molestias delectus ullam.','dolores',92,NULL,'1979-09-06 10:43:49','2003-11-20 00:07:17'),(3,3,3,'Ea quod omnis exercitationem architecto sit. Nihil praesentium totam debitis reiciendis provident voluptatibus perspiciatis. Accusamus aliquam ipsam voluptas fugiat fugit nam at.','ducimus',3344,NULL,'2011-09-18 18:41:19','1989-11-05 17:45:00'),(4,4,4,'Fugiat consectetur voluptatum laboriosam id nihil. Quia aliquam quia sit pariatur. Illo id quibusdam vel odit quia quibusdam.','odit',0,NULL,'1990-10-03 06:29:07','2001-04-25 20:58:18'),(5,5,5,'Soluta voluptatem culpa natus autem. Numquam ad et tempore aliquam nisi. Dolores aut quisquam excepturi ducimus. Iusto nobis qui est blanditiis dolorem.','vitae',880139,NULL,'1980-07-28 21:34:03','1975-09-25 20:37:29'),(6,6,6,'Eum atque necessitatibus eligendi omnis optio. Mollitia dolor odit ut sapiente aut. Laudantium aut quia quisquam delectus.','ducimus',122,NULL,'1996-12-05 23:59:19','2002-08-02 21:21:02'),(7,7,7,'Dolores pariatur deleniti quod doloremque voluptatem officiis aliquam. Accusamus et sed rerum dolores sequi perferendis voluptatem. Et sit delectus enim vel quaerat dolor aut.','est',54,NULL,'1992-07-30 10:27:11','1984-12-01 22:53:00'),(8,8,8,'Vel velit maiores ut iste. Pariatur velit explicabo reprehenderit ex eveniet laborum molestiae dignissimos. Nobis quasi asperiores dignissimos aut.','aut',3755110,NULL,'2016-08-29 07:28:25','2002-11-07 09:13:51'),(9,9,9,'Blanditiis quam consectetur sed qui. Quia nisi consequatur veniam similique quidem temporibus modi. Molestiae omnis voluptas adipisci deleniti. Blanditiis omnis quae recusandae at sapiente.','non',14808,NULL,'1970-01-02 23:31:26','2005-09-16 01:23:07'),(10,10,10,'Accusamus optio quam rerum voluptatibus necessitatibus ab neque. Accusantium ratione nesciunt est quidem illo a aut ratione.','eaque',0,NULL,'2011-04-12 03:31:50','2014-07-26 00:33:05'),(11,1,11,'Quo rerum unde natus cumque nisi tenetur sed. Sed quasi voluptas beatae et dolorem veritatis. A et cumque molestias aut aut laborum commodi. Mollitia eligendi temporibus velit voluptas rerum.','dolores',3747,NULL,'2001-01-24 03:59:46','2013-02-17 03:37:42'),(12,2,12,'Eos magnam pariatur enim enim dolor aut. Vero ut minima qui. Natus dolore repudiandae corporis dolorem autem et aut.','ex',39,NULL,'1979-11-09 18:16:03','1992-04-16 16:48:53'),(13,3,13,'Maiores consequatur dolore omnis quia. Et tenetur aliquid nihil itaque eos. Fuga id et numquam esse.','accusantium',4,NULL,'1995-06-11 16:37:03','2003-08-13 16:08:20'),(14,4,14,'Assumenda eos rerum dolor eius et ex vel facilis. Quae necessitatibus doloremque temporibus. Voluptatem voluptas nihil est. Quaerat minus aperiam blanditiis officiis accusantium.','incidunt',95711506,NULL,'2021-01-03 19:41:13','1975-08-29 05:52:43'),(15,5,15,'Repudiandae suscipit aut consequatur quis eveniet rerum non. Qui consectetur excepturi non et molestiae saepe fuga. Suscipit iusto illum atque.','nostrum',8648,NULL,'2011-01-20 15:10:29','2010-04-28 18:23:35'),(16,6,16,'Perferendis facere numquam ut. Vero amet hic aliquid ex harum praesentium. Ut et est ipsam id. Qui unde eveniet sunt iure expedita repudiandae repellat corporis. Possimus incidunt laborum optio ut dolorem.','velit',56,NULL,'2006-06-25 16:36:49','2002-03-11 20:13:00'),(17,7,17,'Harum temporibus exercitationem provident. Optio eum vero et temporibus.','ut',431,NULL,'2019-08-02 06:39:23','1992-06-22 02:46:13'),(18,8,18,'Blanditiis et incidunt voluptas. Culpa qui explicabo labore debitis adipisci. Dolorum pariatur beatae eligendi eaque. Impedit omnis quibusdam sit molestiae accusantium.','molestias',5,NULL,'2002-07-08 15:34:37','1990-05-28 10:23:05'),(19,9,19,'Accusamus nemo aperiam vero et ad officiis. Sed eum et et eos. Aliquam eum et voluptatem explicabo aut aperiam.','aliquid',994083796,NULL,'1971-12-16 15:44:28','1978-06-10 15:27:32'),(20,10,20,'Ut mollitia laudantium dolores autem quia ullam. Placeat eius sint sit debitis officia est. Veritatis nostrum aspernatur autem in sunt. Sit omnis qui similique.','maiores',0,NULL,'2001-04-04 08:54:05','1975-02-10 21:57:04');
178INSERT INTO `pets_types` VALUES (1,'qui'),(2,'nemo'),(3,'eum'),(4,'nostrum'),(5,'est'),(6,'unde'),(7,'sequi'),(8,'at'),(9,'autem'),(10,'modi');
179INSERT INTO `pets` VALUES (761,5,'in',8),(763,7,'officia',47),(764,1,'aspernatur',827),(765,1,'doloremque',955877936),(766,3,'qui',81664),(767,3,'vitae',3474),(768,1,'cupiditate',7397),(769,1,'asperiores',95401),(770,1,'est',6263816),(771,1,'quos',845405),(772,9,'odit',2124613),(773,5,'id',6176040),(774,8,'quidem',552),(775,9,'eius',29837),(776,8,'laborum',0),(777,5,'nostrum',2412),(778,9,'molestiae',928273164),(779,4,'voluptatum',21689823),(780,1,'et',58),(781,8,'id',550121368),(782,7,'qui',8221314),(785,1,'ea',632),(786,1,'necessitatibus',31195138),(787,9,'debitis',91),(788,4,'deserunt',9),(789,1,'est',9312),(793,4,'sed',924913886),(794,8,'soluta',509),(795,2,'accusamus',41261192),(796,2,'iusto',400044),(797,8,'eum',3653816),(799,2,'temporibus',3),(800,1,'libero',2279643);
180INSERT INTO `gender_id` VALUES (6,'velit'),(7,'tempora');
181INSERT INTO `photo_albums` VALUES (1,'qui',1),(2,'non',2),(3,'voluptatem',3),(4,'autem',4),(5,'omnis',5),(6,'ipsam',6),(7,'voluptatem',7),(8,'animi',8),(9,'ut',9),(10,'ullam',10),(11,'fuga',11),(12,'adipisci',12),(13,'ut',13),(14,'et',14),(15,'velit',15),(16,'dolores',16),(17,'odit',17),(18,'sunt',18),(19,'odit',19),(20,'ullam',20);
182INSERT INTO `photos` VALUES (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10),(11,11,11),(12,12,12),(13,13,13),(14,14,14),(15,15,15),(16,16,16),(17,17,17),(18,18,18),(19,19,19),(20,20,20),(21,1,1),(22,2,2),(23,3,3),(24,4,4),(25,5,5),(26,6,6),(27,7,7),(28,8,8),(29,9,9),(30,10,10),(31,11,11),(32,12,12),(33,13,13),(34,14,14),(35,15,15),(36,16,16),(37,17,17),(38,18,18),(39,19,19),(40,20,20),(41,1,1),(42,2,2),(43,3,3),(44,4,4),(45,5,5),(46,6,6),(47,7,7),(48,8,8),(49,9,9),(50,10,10);
183INSERT INTO `communities` VALUES (1,'numquam',1),(2,'omnis',2),(3,'qui',3),(4,'doloremque',4),(5,'debitis',5),(6,'voluptate',6),(7,'ut',7),(8,'quo',8),(9,'et',9),(10,'officia',10),(11,'numquam',11),(12,'quidem',12),(13,'aperiam',13),(14,'et',14),(15,'possimus',15),(16,'et',16),(17,'accusamus',17),(18,'minus',18),(19,'explicabo',19),(20,'aut',20),(21,'nostrum',21),(22,'dolor',22),(23,'culpa',23),(24,'quis',24),(25,'dolorum',25),(26,'quidem',26),(27,'iusto',27),(28,'laborum',28),(29,'unde',29),(30,'doloribus',30),(31,'unde',31),(32,'natus',32),(33,'fugit',33),(34,'molestias',34),(35,'est',35),(36,'error',36),(37,'eveniet',37),(38,'illum',38),(39,'quia',39),(40,'corporis',40),(41,'neque',41),(42,'adipisci',42),(43,'enim',43),(44,'iste',44),(45,'unde',45),(46,'debitis',46),(47,'et',47),(48,'corporis',48),(49,'nihil',49),(50,'a',50),(51,'explicabo',51),(52,'in',52),(53,'perferendis',53),(54,'ab',54),(55,'eius',55),(56,'laudantium',56),(57,'expedita',57),(58,'ipsam',58),(59,'rerum',59),(60,'cupiditate',60),(61,'est',61),(62,'ut',62),(63,'eaque',63),(64,'ducimus',64),(65,'qui',65),(66,'reprehenderit',66),(67,'adipisci',67),(68,'nihil',68),(69,'est',69),(70,'repellat',70),(71,'ut',71),(72,'odio',72),(73,'consequuntur',73),(74,'facilis',74),(75,'facere',75),(76,'neque',76),(77,'sed',77),(78,'nemo',78),(79,'reiciendis',79),(80,'velit',80),(81,'et',81),(82,'alias',82),(83,'id',83),(84,'cumque',84),(85,'nobis',85),(86,'fugit',86),(87,'ducimus',87),(88,'dolores',88),(89,'et',89),(90,'tempore',90),(91,'totam',91),(92,'fugiat',92),(93,'enim',93),(94,'quisquam',94),(95,'nam',95),(96,'sunt',96),(97,'qui',97),(98,'nobis',98),(99,'voluptatum',99),(100,'numquam',100);
184INSERT INTO `users` VALUES (1,'Mariah','Ritchie','stacey32@example.com','9daf0aad734aabdc24bf5027d3ca30bc2483d887',0,'\0'),(2,'Cydney','Goyette','josianne.parker@example.org','5805f581304b7300d640cdd5361cb3a4d614b1b7',0,'\0'),(3,'Reanna','Senger','eloy24@example.net','ce42120c99e828acb2822f1e2d4cff7882f08008',0,'\0'),(4,'Aurelie','Denesik','sebastian.white@example.org','d9cc78a9b7dbab84bcd46231106690762a8c3bfb',0,'
'),(5,'Dallas','Huel','toy.hipolito@example.com','11ef45998766612666770bfde221e2a7a9ffa02b',723,'\0'),(6,'Alyce','Glover','charlotte.bode@example.com','11d5f89337c2311080ccfa0d5c5b305835da7632',1,'
'),(7,'Shanon','Gleason','sauer@example.net','59b518551fab81f28b8ba5e6d33ab64bc90540b4',294,'
'),(8,'Lacey','Beer','vkoelpin@example.org','0f243d131b2ae4f13722657a1a9764a72c4a37f8',209998,'\0'),(9,'Graham','Mueller','millie79@example.net','98e52858253f5a3f8057eb9a2c2440e745f8b03b',6563445734,'
'),(10,'Reginald','Gleichner','wallace.bauch@example.com','d515f7cd7a36165e04a4fa6ea318d2decbe281a6',785631,'\0'),(11,'Keara','Trantow','kschulist@example.com','34c74e6d09210e1b1029d3cf3e13dedee1b0edc3',154772,'
'),(12,'Darrel','Frami','corrine.bayer@example.org','32290803adcfb435dfface110dcef4b6a57b4ef2',651313,'
'),(13,'Marley','Leannon','zack90@example.com','12ad9ad72a540debee0fb4fe43987b23648e0b74',106712,'
'),(14,'Sim','Vandervort','uerdman@example.org','6bddbb80e6144da2aca4787b764fc6c00914be46',537,'\0'),(15,'Mattie','O\'Connell','horacio86@example.net','965b74d002441a3d9c6b02964816429fddf47c73',399,'
'),(16,'Hester','Schimmel','cielo00@example.net','0e8a3b2ea1510a7b8e048557bfdef55d46595555',0,'\0'),(17,'Naomie','Nienow','fjacobi@example.net','d7001136fd5c4f5a488a96d7219f749357ba8621',440344,'\0'),(18,'Dudley','Cummerata','deontae.wiza@example.com','c0b20031c68add43ca71cceb6fc5aab6bebce4bd',231,'
'),(19,'Rowland','Dickens','angelica.powlowski@example.org','680d315dd45ef57c4b66fc4acb305ccdb8133ffc',1,'
'),(20,'Cristian','Dickens','hmarvin@example.net','3b48bbcb934c7bd94a82b4c092294a7f6b01e89d',772,'
'),(21,'Kianna','Sawayn','gillian62@example.com','f78689a16c42a25af8cd8b8541cf487e897a6c3c',164799,'
'),(22,'Angie','Beatty','kertzmann.everett@example.com','e3b62469a1105606aeebc1a69f1b5778564d74ff',1,'
'),(23,'Bernadine','O\'Reilly','rath.lysanne@example.net','677e6decf5762f053760e314fe231772f04e8059',82,'
'),(24,'Shaun','Trantow','xnienow@example.org','14331bfd7bdd7212995bd7c9c219d4e9f83b0e32',741,'
'),(25,'Ivory','Harvey','dauer@example.net','a8a44fbe81b1ebea052b1128ce7db8b1cbcea840',0,'\0'),(26,'Gordon','Rowe','jcarroll@example.net','4cac58f17f987d5856476da9cc2ee6a4c6fcf345',637,'\0'),(27,'Genevieve','Jacobson','collier.emmie@example.org','1ad93ae74e48b8a85bdd05112cb6db0daf0507e4',83,'\0'),(28,'Toby','Ortiz','eryn57@example.org','c802cce00fc924ca9e0a03b2ff18eb7e33f8fb19',1,'\0'),(29,'Elinore','Little','mdicki@example.com','b6653b3314735f0e807933b49468bb1864c93a73',177,'
'),(30,'Jonathon','Cruickshank','romaguera.josefa@example.net','6e490f3990a6c4006d81a83664f12080821acb44',6025957276,'\0'),(31,'Shayna','Parisian','baumbach.gladyce@example.net','8836aeb25c57b1fd8ac222dd2ee3994a0fb7350a',0,'\0'),(32,'Molly','McDermott','mitchel.emmerich@example.com','e0bed5604bcece7e4f5f99d02cbbed82635235b1',32,'
'),(33,'Rogelio','Doyle','seamus80@example.net','e859ae295a3b78e8dcadd6058927be3c8847ec56',1659945846,'\0'),(34,'Caesar','Vandervort','jdach@example.org','60c3f86e2ee578c135c2e9f28ff9a4105dc9205b',4455388838,'
'),(35,'Orlando','Abshire','omueller@example.org','60d69f29fd9d6dd3d741f06a203607c375f65502',218100,'
'),(36,'Maida','Rodriguez','peter.kuphal@example.org','1fafd3e79f604450bd9d4eef038f9bdb002217de',590811,'
'),(37,'Dennis','Ullrich','georgianna.wiza@example.net','c44f657963a384d58b00a1a7582da41c4713a373',0,'
'),(38,'Hillard','Fadel','yondricka@example.org','56ac18c6c2240dab7333dd48372734ff782a413b',29,'\0'),(39,'Bria','Kuhic','diego.carter@example.net','0ecde8801e066b908ae70e59225a3f828b3f50a7',103,'\0'),(40,'Brent','Pouros','gutkowski.tyree@example.com','d0aa2a420123be0164d5885c01f0bbd5f14d0905',869,'
'),(41,'Jamaal','Hilpert','emelie.brekke@example.org','43470228e788a1b2cc376c7e44ea556c46cf0f15',0,'
'),(42,'April','Gulgowski','alverta.spencer@example.org','030a5a9d471d16590c9c2c5cb00c65eee89ed120',304,'\0'),(43,'Beryl','Auer','mauricio13@example.net','3abb3ceca6918c36217bbcf61d85668530924015',164174,'
'),(44,'Emily','Oberbrunner','rosamond82@example.com','8ec063694e838e0ba1685e3b201607efbfd944f6',1,'
'),(45,'Jamison','Wyman','feil.paxton@example.com','27405270d1dbe0b5457e5af273541c68ae711f7a',49,'
'),(46,'Rita','Marks','miracle32@example.com','1aec26a67912f60d2b64342ff6cebd9d0d404df7',6891069185,'
'),(47,'Tomasa','Hackett','kautzer.sanford@example.com','35dcdc80c409a005bb274bf3cbaba2269967d5ba',1,'\0'),(48,'Isabelle','Wilderman','xmitchell@example.net','7f25a64f4a5de71a9dd3fedeb47c7f3f3dffc6fc',1,'\0'),(49,'Cassie','Ritchie','marjory.frami@example.org','fc8702db9f8b0d6c08eef14f22aa9542e006e655',1,'
'),(50,'Hadley','Littel','greenholt.jules@example.org','f00eb66a5a7fc58e7d65250534a8faf156e9e943',1,'
'),(51,'Margaret','Breitenberg','krystel.cassin@example.org','ff9eedce973fcc1b6a3f64248689b8abd2a3cdae',1,'
'),(52,'Wilber','Christiansen','kolby.donnelly@example.com','8e8ca657aa326db1e527f74dcfba9fb56cb8e2f5',249767,'
'),(53,'Wilson','Sawayn','labernathy@example.com','d3809e232d9221493149dec0756cffbcb186504b',621,'\0'),(54,'Yasmeen','Bogisich','parisian.eldridge@example.org','1c8b273f518f9bc10c906a50168ef191af583889',1,'
'),(55,'Julie','Hilpert','zpredovic@example.com','5aeb551bef5243b5cb793912c0892cb659dd9d82',1,'
'),(56,'Ofelia','Rodriguez','audreanne63@example.org','f23143f38f995ad1d02750de932c0b1ba208e58f',0,'
'),(57,'Boris','O\'Connell','morissette.lawrence@example.org','a8a27474328b87b0ae173ed562738d236a8e2a1a',0,'\0'),(58,'Maureen','Sanford','tarmstrong@example.org','c4a0a0ed637af1aa9e0a3922944dfec7040e5895',1,'
'),(59,'Steve','Cremin','mcglynn.roel@example.com','8265431d4cf5a3d27fdf2a56f940eddf29c612e4',121,'\0'),(60,'Ivah','Gutmann','bahringer.susanna@example.com','48424f8b5ee0b2544dd15575fc1f77a7816c1e4e',7254172516,'
'),(61,'Silas','Denesik','abshire.arlene@example.com','94b7b0fc21182ff1be78c769bd2dd62a00e3dc29',12,'\0'),(62,'Sylvan','Simonis','miracle.klocko@example.net','0051af9622df48818b55aa5d2682b02e6fe7daf2',4973953515,'\0'),(63,'Marge','Abbott','carlo16@example.net','dc806bfdb8672f3b75e98452c0bf0a7d158f4669',0,'\0'),(64,'Virgil','Mohr','olemke@example.com','b84fc049b2991b59ffe1d1521fd52ff3e63f7c7a',64,'\0'),(65,'Mylene','Fritsch','gottlieb.clifton@example.org','e3cc4bb116fbb1595420e3644ceabb45090966c0',9917195200,'
'),(66,'Lynn','McGlynn','britney72@example.com','414fc700298cee4e6116b2412cd594aaeb46bbf9',491585,'\0'),(67,'Garrick','Schuppe','jeanette.daniel@example.com','b336777ebb9af67030a74f33ce471e48b826694d',750,'\0'),(68,'Queen','Hills','roscoe.sipes@example.com','b9d29cef76ec838cdea4e457f06a984f0df5cb50',1,'\0'),(69,'Soledad','Gorczany','runte.vladimir@example.com','8cc61dc7299b7d47cd009da902b0280459f54e69',707,'
'),(70,'Mellie','Murray','rebecca.fahey@example.com','fb91964f6b7b935415270d1f10dc5aae2a183666',1,'
'),(71,'Meghan','King','bettie.hammes@example.org','4963c72810f574518a8eeaa7fe25b6b995448fe9',1,'\0'),(72,'Gerson','Legros','towne.eladio@example.net','9b05d4ab7ef5b74a6488dfcfcdf58a2109ddc9b5',1,'
'),(73,'Lorenza','Kulas','ubartell@example.com','fe45e702ebdbbcdcb9a6977735c3aff81d9bf13d',773,'\0'),(74,'Monty','Kihn','lynn.kemmer@example.net','f1db1ee71a0a3592494d356c0e7f292eafc2dbd7',0,'\0'),(75,'Miller','Wiza','lois.friesen@example.com','53ce50f6ad8762cc2f209c9a8fb12e39b5481197',1,'
'),(76,'Hayley','Smith','nwilderman@example.org','88e1ef7dc0f9598c5bea57da1832b44e84c742c7',117323,'\0'),(77,'Neoma','Marks','ortiz.mandy@example.com','3dee2650bcace86859635332260afe9913d31946',0,'\0'),(78,'Lennie','Quigley','qkub@example.org','b5ca39dbcc0ba5b030da28a71cac2a97d355480c',31,'\0'),(79,'Arvel','Treutel','feeney.floy@example.net','46e408ae76be05ab3222e0d4b2f165e9e69bcfcf',899,'\0'),(80,'Amely','Senger','jannie.purdy@example.net','1e36acd548d0ab1cf4005ad26be8f09468f6363b',7015818832,'
'),(81,'Morton','Ondricka','pauline.hegmann@example.com','873fee746dda59045960f1b85d8f489790093287',994,'
'),(82,'Warren','Ward','anderson.tyson@example.org','a223e6b7b8cdd1658ff9b023b7e59a874aa48636',1,'\0'),(83,'Susana','Lesch','durgan.shaina@example.net','61faf7db718b62e7817105fa1348ee1c6ee374da',0,'
'),(84,'Laurie','Heidenreich','dejuan10@example.com','3c79199e30319c710d928fb5f8adfc043024f44e',0,'\0'),(85,'Bernardo','Littel','llemke@example.net','2666617a6072e63d372a7ac92198b98b647de515',1,'
'),(86,'Frances','Becker','wilbert30@example.net','1ff394a184be7832e40660f90e98be054f728036',5645943874,'\0'),(87,'Amanda','Roob','runolfsson.hulda@example.org','765a6eb7213d59e1a7e880ab077926139eae3c4e',87,'
'),(88,'Sabina','Price','xroberts@example.com','77434783714d630fbea3c365b7b53c9d1a6a4090',1,'
'),(89,'Dario','Schmitt','zola20@example.com','cf22a4f6559cbf270701f775aa0fa2e944ee7531',47004,'\0'),(90,'Carson','Kessler','estrella64@example.net','85059bde2879c84a744aa651605d651eff0e1aec',183,'
'),(91,'Turner','Stoltenberg','brent.hintz@example.org','f4214fc19817272419e3c3885a65db8f1621c87f',683266,'
'),(92,'Leon','McCullough','emie94@example.net','b46751397a91e606559cb2838f1d5d80100e124d',629,'\0'),(93,'Micheal','Stamm','oratke@example.net','6971ef41b30a2b132fcbf9d6a3258c37ff1d5bfb',1,'
'),(94,'Michael','Greenfelder','estiedemann@example.org','88fc9ca024c2adbc2a50eac70a25f3664466686b',21962,'
'),(95,'Bridie','Metz','trey51@example.org','a6aa60fe8f27309aca47859b79966b12edae0665',406679,'
'),(96,'Maye','Bode','qfriesen@example.org','1a453a95fb166d687e240560d24e1d19dcc870bd',38,'\0'),(97,'Garnet','Doyle','okris@example.net','21973ab7c8a55bb4ed7499c59951e68f064c52b5',0,'
'),(98,'Zachery','Gibson','lemke.seth@example.org','34f5306543f7667c834befb400611494e91f0bf0',1,'
'),(99,'Mason','Weber','fkutch@example.net','dffbca46c194591d9064de190c169f37e7b1e2e6',48,'
'),(100,'Kristoffer','Purdy','heaney.zelma@example.net','911948276c8121e839e4ecbbd1b4165be6af5feb',1,'
');
185INSERT INTO `likes` VALUES (1,1,1,'2013-05-10 08:22:09'),(2,2,2,'2007-12-20 23:03:33'),(3,3,3,'1997-06-25 12:00:50'),(4,4,4,'2000-05-12 19:30:44'),(5,5,5,'2002-12-22 00:30:26'),(6,6,6,'1971-10-06 20:16:15'),(7,7,7,'2018-08-01 13:43:52'),(8,8,8,'1993-11-11 06:48:22'),(9,9,9,'2017-11-30 00:28:17'),(10,10,10,'2007-02-24 09:20:59'),(11,11,11,'1991-12-16 20:12:54'),(12,12,12,'2017-09-21 20:27:41'),(13,13,13,'1991-09-30 04:28:29'),(14,14,14,'2003-07-01 10:48:12'),(15,15,15,'2003-09-02 03:59:08'),(16,16,16,'1974-10-16 16:53:45'),(17,17,17,'1974-04-17 10:11:35'),(18,18,18,'1977-01-10 21:30:59'),(19,19,19,'1995-07-10 15:56:01'),(20,20,20,'1982-01-27 14:04:33'),(21,21,1,'2013-07-06 00:36:37'),(22,22,2,'2017-12-11 17:17:23'),(23,23,3,'1971-01-19 23:38:04'),(24,24,4,'2001-05-25 21:51:26'),(25,25,5,'1997-01-22 13:38:38'),(26,26,6,'2016-11-20 12:27:48'),(27,27,7,'2017-01-26 10:55:31'),(28,28,8,'1988-06-09 02:05:19'),(29,29,9,'1992-08-03 07:08:02'),(30,30,10,'2014-04-28 04:20:32'),(31,31,11,'1972-11-05 20:55:30'),(32,32,12,'1975-08-30 14:29:42'),(33,33,13,'2009-08-24 11:00:33'),(34,34,14,'2011-05-13 23:09:12'),(35,35,15,'1998-09-02 20:50:43'),(36,36,16,'2001-06-17 19:42:13'),(37,37,17,'2006-03-14 20:29:24'),(38,38,18,'2000-03-20 03:57:01'),(39,39,19,'2007-05-07 23:39:08'),(40,40,20,'2011-10-01 00:17:43'),(41,41,1,'1992-06-29 14:46:38'),(42,42,2,'1997-04-18 06:49:22'),(43,43,3,'2005-12-21 01:15:37'),(44,44,4,'1971-05-06 22:12:03'),(45,45,5,'2020-11-28 22:16:38'),(46,46,6,'2005-10-03 04:40:10'),(47,47,7,'1975-07-31 12:24:41'),(48,48,8,'1970-06-29 02:50:32'),(49,49,9,'1977-10-25 16:37:07'),(50,50,10,'2001-07-26 11:53:55'),(51,51,11,'2020-11-03 19:13:46'),(52,52,12,'2015-02-18 14:24:04'),(53,53,13,'2018-10-26 07:49:56'),(54,54,14,'2010-07-28 16:47:25'),(55,55,15,'1996-05-28 17:57:13'),(56,56,16,'1975-01-11 21:01:12'),(57,57,17,'1977-01-19 04:23:48'),(58,58,18,'2002-07-19 03:57:40'),(59,59,19,'2021-01-18 11:58:37'),(60,60,20,'1986-10-14 20:51:31'),(61,61,1,'2013-09-26 16:52:37'),(62,62,2,'1985-09-22 23:16:21'),(63,63,3,'1993-04-19 20:25:45'),(64,64,4,'1979-04-30 02:46:41'),(65,65,5,'2004-12-24 19:47:05'),(66,66,6,'2009-09-10 05:31:51'),(67,67,7,'1971-11-09 21:51:24'),(68,68,8,'1984-08-18 00:41:22'),(69,69,9,'2020-04-23 03:48:10'),(70,70,10,'2017-10-18 22:27:33'),(71,71,11,'1980-04-26 05:12:05'),(72,72,12,'1993-12-25 22:58:05'),(73,73,13,'2020-08-03 13:40:58'),(74,74,14,'2021-02-06 22:41:51'),(75,75,15,'2019-02-18 00:12:50'),(76,76,16,'1981-10-10 17:17:33'),(77,77,17,'2000-05-05 23:11:50'),(78,78,18,'1980-10-31 05:35:53'),(79,79,19,'2015-12-24 09:43:17'),(80,80,20,'1994-11-10 01:18:33'),(81,81,1,'1971-03-10 01:02:55'),(82,82,2,'1985-02-18 08:10:28'),(83,83,3,'2021-02-07 21:34:14'),(84,84,4,'1987-03-04 06:29:07'),(85,85,5,'1989-01-13 01:24:11'),(86,86,6,'2016-03-04 11:38:20'),(87,87,7,'1988-12-16 22:07:20'),(88,88,8,'2011-07-25 06:45:28'),(89,89,9,'1988-10-23 11:11:02'),(90,90,10,'2001-01-07 15:10:32'),(91,91,11,'2006-04-27 20:20:22'),(92,92,12,'1983-11-13 08:05:23'),(93,93,13,'1992-03-08 14:40:45'),(94,94,14,'2004-07-03 12:47:31'),(95,95,15,'2012-12-27 12:16:08'),(96,96,16,'1974-05-02 06:15:30'),(97,97,17,'1985-04-29 20:19:02'),(98,98,18,'2014-03-03 04:34:44'),(99,99,19,'1988-06-19 18:55:38'),(100,100,20,'2004-08-29 14:40:30');
186INSERT INTO `friend_requests` VALUES (1,1,'approved','2010-11-16 09:45:27','1983-11-11 18:29:58'),(2,2,'declined','1980-03-24 02:21:48','1991-08-27 21:21:55'),(3,3,'approved','2011-12-07 22:09:19','1985-04-14 23:53:29'),(4,4,'declined','2021-05-15 07:24:02','1974-11-27 11:43:33'),(5,5,'requested','2003-12-25 03:30:31','1975-10-15 02:33:02'),(6,6,'unfriended','1975-08-14 15:14:48','1992-07-01 03:11:32'),(7,7,'declined','1979-05-07 19:39:57','2007-07-20 01:14:39'),(8,8,'approved','1995-11-06 17:55:40','2003-06-17 08:02:59'),(9,9,'unfriended','1994-12-08 04:16:17','1986-04-16 04:39:30'),(10,10,'approved','2006-10-16 01:56:17','2008-11-18 08:15:14'),(11,11,'unfriended','2017-05-15 12:43:49','1973-01-31 12:39:20'),(12,12,'declined','2002-12-11 17:16:30','1994-03-13 00:45:44'),(13,13,'declined','2003-08-24 22:35:10','2014-03-28 06:53:32'),(14,14,'declined','2020-07-03 07:34:45','1996-04-08 08:48:08'),(15,15,'unfriended','1990-02-03 00:39:36','2008-11-23 03:52:47'),(16,16,'requested','2019-11-11 08:50:24','2016-05-21 11:02:31'),(17,17,'unfriended','1978-04-30 19:08:50','1982-06-09 08:19:03'),(18,18,'declined','1978-10-24 07:01:33','2017-04-08 02:58:04'),(19,19,'requested','2018-03-25 03:13:15','2018-09-04 15:24:06'),(20,20,'declined','1973-05-31 15:11:53','1970-01-20 23:10:59'),(21,21,'approved','1983-06-22 19:47:33','2010-09-10 07:00:29'),(22,22,'unfriended','1970-09-13 05:00:50','2012-10-03 21:33:23'),(23,23,'approved','2012-04-03 23:34:09','1982-06-28 13:27:50'),(24,24,'requested','1992-08-12 16:44:24','1976-11-24 22:59:50'),(25,25,'approved','1975-12-29 14:51:26','2002-12-16 11:01:05'),(26,26,'approved','2013-01-10 16:27:44','1986-01-08 03:42:28'),(27,27,'requested','1995-08-14 16:25:03','1993-07-14 08:08:02'),(28,28,'approved','2014-10-17 23:28:25','2001-11-03 05:15:09'),(29,29,'approved','2003-04-18 10:24:34','2020-10-16 23:23:10'),(30,30,'declined','1976-07-01 05:40:37','2016-09-26 01:20:57'),(31,31,'declined','1982-04-13 10:22:16','1972-11-07 21:12:23'),(32,32,'requested','2002-07-04 20:40:51','1998-12-09 03:32:46'),(33,33,'unfriended','2018-06-22 22:37:56','1994-11-09 06:25:49'),(34,34,'approved','1981-07-28 01:20:47','2015-05-29 17:39:19'),(35,35,'declined','1988-03-08 07:07:34','1998-07-25 22:27:37'),(36,36,'declined','1998-06-04 08:46:53','1972-11-01 23:00:13'),(37,37,'declined','1978-01-03 02:35:12','2003-08-01 03:44:32'),(38,38,'requested','1994-01-04 06:42:41','1978-10-20 16:57:33'),(39,39,'requested','1995-03-25 23:39:27','1977-04-30 21:42:58'),(40,40,'approved','1996-08-24 23:31:19','1995-09-05 17:24:01'),(41,41,'requested','1992-10-06 17:10:18','2007-08-03 19:09:26'),(42,42,'requested','1973-10-01 10:43:55','1975-01-28 09:51:47'),(43,43,'declined','2015-07-08 06:13:09','2018-08-12 23:00:31'),(44,44,'approved','2006-10-28 01:45:39','2018-03-25 14:46:10'),(45,45,'unfriended','2016-08-07 00:21:06','2005-08-17 22:40:55'),(46,46,'approved','1978-11-22 22:57:52','1985-03-03 01:30:42'),(47,47,'declined','1976-12-15 09:57:23','1997-07-13 07:04:54'),(48,48,'declined','2008-05-28 02:40:48','2020-01-15 23:52:12'),(49,49,'requested','2019-07-06 04:34:51','2002-01-11 02:56:27'),(50,50,'requested','1976-03-13 02:48:51','1976-12-15 09:42:50'),(51,51,'declined','2020-03-15 17:17:53','1980-02-20 22:49:20'),(52,52,'approved','2020-03-26 02:42:10','2019-09-16 09:50:16'),(53,53,'requested','2019-10-06 03:44:35','2004-09-27 04:41:58'),(54,54,'declined','2009-10-07 09:39:07','1987-03-30 01:38:35'),(55,55,'approved','1978-07-25 00:31:37','2007-04-10 15:43:04'),(56,56,'requested','2019-10-13 16:29:24','1993-08-13 11:44:28'),(57,57,'unfriended','2021-05-02 00:06:17','1983-07-27 05:20:58'),(58,58,'approved','1994-12-05 09:18:10','2018-06-06 21:59:31'),(59,59,'approved','1988-12-27 07:31:58','2004-03-30 18:30:40'),(60,60,'requested','1971-08-27 00:58:52','2018-05-14 23:03:29'),(61,61,'requested','2004-03-28 03:15:32','1971-09-29 03:48:30'),(62,62,'requested','1973-09-01 08:09:35','1996-07-09 03:53:58'),(63,63,'requested','1975-07-01 03:59:40','1977-03-25 20:57:09'),(64,64,'requested','1970-11-17 08:06:35','1995-09-20 16:56:51'),(65,65,'approved','1998-09-03 15:05:38','1993-10-29 09:36:31'),(66,66,'unfriended','2008-05-23 22:38:25','1976-08-11 03:21:49'),(67,67,'approved','1996-10-15 15:28:04','2010-04-27 21:23:34'),(68,68,'unfriended','2017-04-16 09:21:43','2003-02-02 17:59:24'),(69,69,'approved','1990-04-26 07:27:43','2003-03-22 18:27:15'),(70,70,'unfriended','1996-02-04 23:39:50','1972-12-04 03:52:29'),(71,71,'unfriended','1973-08-27 00:52:02','1988-09-15 17:15:33'),(72,72,'unfriended','1993-12-17 13:45:16','2007-07-02 11:11:43'),(73,73,'unfriended','1980-10-21 00:58:07','1988-07-08 12:02:32'),(74,74,'requested','1990-02-16 03:01:30','1995-04-03 04:45:29'),(75,75,'approved','1984-06-17 10:03:08','2001-03-16 14:20:11'),(76,76,'declined','1973-10-08 15:03:21','1999-02-25 10:39:15'),(77,77,'unfriended','2012-09-18 04:55:24','2012-10-07 13:07:28'),(78,78,'approved','2020-10-06 17:04:45','1997-08-30 18:01:25'),(79,79,'unfriended','1973-08-25 00:45:58','1995-03-28 02:58:56'),(80,80,'requested','1971-09-05 20:42:01','1981-06-19 06:48:23'),(81,81,'declined','2001-03-29 00:23:35','1998-12-23 00:53:30'),(82,82,'requested','1974-06-07 02:24:56','1970-12-19 13:46:27'),(83,83,'approved','2012-10-31 00:07:50','1970-04-30 13:42:15'),(84,84,'declined','2017-11-24 19:43:56','1984-12-31 01:31:31'),(85,85,'approved','2001-11-15 11:25:12','1983-10-29 07:56:16'),(86,86,'requested','1977-03-21 02:59:58','1987-10-24 23:03:33'),(87,87,'unfriended','1999-09-07 10:09:51','1996-03-27 10:35:01'),(88,88,'declined','1972-02-07 00:13:50','1987-04-29 04:35:37'),(89,89,'unfriended','1976-05-12 03:27:32','1983-02-22 19:43:21'),(90,90,'requested','1985-04-26 08:18:59','2019-07-03 17:23:02'),(91,91,'declined','1981-07-25 02:27:27','1973-03-23 05:08:43'),(92,92,'declined','1973-11-25 09:18:55','2016-02-28 02:03:02'),(93,93,'requested','1980-02-14 17:49:03','2010-01-11 04:32:32'),(94,94,'declined','1976-03-13 16:46:22','1986-08-30 01:46:18'),(95,95,'declined','1986-03-10 17:38:48','2007-08-19 02:51:30'),(96,96,'approved','1999-05-16 23:11:48','1985-01-31 22:16:50'),(97,97,'requested','2000-03-26 00:59:55','1986-11-07 09:48:55'),(98,98,'requested','2006-05-05 08:15:09','2005-04-08 13:19:02'),(99,99,'requested','2010-08-22 05:57:38','1978-03-23 19:47:36'),(100,100,'requested','1999-04-27 11:26:18','2011-10-20 11:12:16');
187INSERT INTO `messages` VALUES (1,1,1,'Omnis dolorem architecto dicta ut qui soluta autem. Necessitatibus nemo sunt sunt perferendis quam quia. Labore aliquam sapiente sed ex sit deserunt excepturi ipsam.','1993-05-22 22:12:12'),(2,2,2,'Ipsam recusandae ut et nihil id. Non aspernatur placeat vero similique reprehenderit. Mollitia ut tempore velit.','2021-09-09 04:04:02'),(3,3,3,'Quisquam laborum nihil quos tempore. Aut omnis rerum quod voluptas porro doloribus autem. Qui sit corporis ut consequatur quia accusamus sint.','2016-12-02 17:56:52'),(4,4,4,'Culpa aut voluptates harum eligendi incidunt hic. Officia laudantium veritatis dolorem dicta cumque. Asperiores ratione iusto in similique similique.','1972-04-21 22:20:02'),(5,5,5,'Consequatur fugiat exercitationem odio ipsam autem quis. Quo quasi quidem et veritatis labore velit est aut. Ipsam quaerat ut perferendis. Sunt rem quasi illum ipsam.','1991-04-21 14:56:57'),(6,6,6,'Magnam est placeat illo vel non. Quis minima odit blanditiis et earum. Suscipit facilis ad quia et.','1999-02-06 20:22:51'),(7,7,7,'Nihil aut rem eaque eaque eum voluptatem. Earum ut et quas in est id harum natus. Voluptate commodi dolorem est veniam at autem dolor at.','2018-09-11 10:17:14'),(8,8,8,'Id blanditiis tempora sunt debitis consequatur voluptatem deserunt aliquam. Nesciunt reprehenderit molestias iste quibusdam. Aut quasi et sint eligendi. Aliquam molestiae velit consequatur magni omnis sit soluta. Omnis unde delectus dolor magnam inventore quo.','1973-02-19 20:38:36'),(9,9,9,'Sunt qui cum sunt illo et eos ut. Est repellat ducimus cum mollitia. Aspernatur nobis dolor minima ut.','1981-09-22 20:26:49'),(10,10,10,'Et laboriosam voluptas quis aspernatur corrupti. Vel facere in ut voluptates nihil ex ea sed. Quas quisquam sed laboriosam saepe autem eum rem.','2001-01-01 14:46:41'),(11,11,11,'Qui officia impedit aut optio et et. Quasi voluptatem temporibus libero repudiandae est fuga et. Et vero et est suscipit rerum eos qui. Magnam sint totam quos aliquam.','1981-07-09 12:57:23'),(12,12,12,'Et aut eos voluptatem vel similique aut. Ea reiciendis error voluptatem unde sed. Ut non a modi omnis ut aut. At praesentium exercitationem aperiam.','2000-01-25 09:26:52'),(13,13,13,'Voluptatibus at autem magnam qui praesentium. Aspernatur est omnis eos quo. Pariatur at repellat iste quaerat nihil.','1997-05-12 18:54:08'),(14,14,14,'Magni quibusdam ullam officia. Possimus minima cupiditate quae voluptatem aut laborum quas nesciunt. Deserunt nihil vel et ut explicabo explicabo incidunt. Cupiditate consequatur ipsa eum voluptas sed. Ut aliquam sit quos hic rerum fugiat laudantium.','1984-05-10 06:37:42'),(15,15,15,'Tenetur impedit iste est. Iusto et reprehenderit est dolores quibusdam alias occaecati iure. Culpa recusandae quaerat dolorem nihil. Non sit deleniti expedita sed laboriosam beatae molestiae.','1980-11-03 16:25:16'),(16,16,16,'Maiores similique non exercitationem esse nesciunt eos. Fugiat officia dolore vel repudiandae quia consectetur et.','2004-06-23 18:59:27'),(17,17,17,'In consequatur omnis reprehenderit itaque aspernatur dolores. Deleniti qui repellendus aut qui quaerat quibusdam. Voluptatem odit tenetur non officiis quam in.','1999-05-21 03:19:30'),(18,18,18,'Tenetur sed fuga non ipsa dicta. Ad consequatur quod quod dolores non et sint. Sed dolor molestiae architecto in dicta. Quia non quia est labore quo.','1977-10-06 02:36:55'),(19,19,19,'Porro reiciendis distinctio est provident natus repellendus voluptates ex. Explicabo dignissimos officiis praesentium natus reiciendis iusto et voluptates. Quia possimus exercitationem explicabo quae voluptas. Quae eos ex facilis itaque nisi est.','1975-10-01 13:32:07'),(20,20,20,'Voluptatum quae dolorum voluptates velit sint cum beatae. Dolore vel quia atque minima tempore quia. Aliquam est possimus quas quia aut. Ipsa alias dignissimos ducimus soluta perferendis vitae reprehenderit.','1984-01-09 17:05:40'),(21,21,21,'Non exercitationem est accusamus doloribus omnis saepe ut. Nam vitae rem est magnam repellendus. Reiciendis placeat voluptatem ad rerum est. Provident quia aspernatur atque magni.','1984-12-15 14:31:50'),(22,22,22,'Aut nesciunt illum sunt harum. Mollitia neque quod nostrum et autem. Et minima nam reprehenderit voluptatum veritatis. Exercitationem est tempore accusamus molestias eius.','1977-11-04 16:13:20'),(23,23,23,'Et quis nemo corrupti similique. Quo sunt eligendi aut voluptas consequatur quisquam facilis. Atque officiis tempora adipisci dolorem dolor pariatur.','1979-05-13 22:15:25'),(24,24,24,'Est esse aliquam commodi libero mollitia aspernatur. Veritatis sint omnis corporis ut iste. Necessitatibus dignissimos sed vel dicta maxime assumenda enim. Excepturi labore suscipit modi quaerat sapiente officia libero esse. Sint voluptas voluptatibus laborum at autem nostrum.','1989-07-03 05:36:26'),(25,25,25,'Culpa quaerat aut quod id vitae quidem soluta accusamus. Sint voluptates rerum quia accusantium blanditiis. Id harum dolores sunt est et et.','1991-07-10 07:34:22'),(26,26,26,'Sit esse quae quia minima tenetur. Pariatur qui consequatur sed doloribus facilis. Est ut ducimus et iusto. Est amet sunt rerum exercitationem. Nulla repellat eius doloremque.','1978-09-30 11:50:15'),(27,27,27,'Numquam praesentium labore itaque aut est. Incidunt repudiandae eos cupiditate sit delectus et odit. Aliquam vitae eligendi sapiente odit et. Iure voluptatem aliquid animi incidunt omnis.','1981-07-29 12:04:05'),(28,28,28,'Ab qui ut eaque aliquam. Ut molestiae voluptas exercitationem enim eum omnis aut. Eligendi a eveniet vitae. Dolorem cum ut quo quidem sunt odio.','2003-05-17 04:16:10'),(29,29,29,'Ea tempore sit totam accusantium. Nostrum dolore pariatur autem tempore cum a incidunt. Fugit quo qui aut et ipsa dolor.','1995-06-11 19:45:05'),(30,30,30,'Officia quos et aut alias. Facilis similique rerum atque non rerum nobis commodi. Eum et dignissimos quis. Asperiores ut maxime debitis error veniam consequatur.','2018-10-29 11:15:02'),(31,31,31,'Ipsam est consectetur sapiente voluptatibus. Delectus cupiditate aliquam provident rerum vero debitis. Et quibusdam autem hic consequuntur. Deleniti tempore consequatur molestiae quas dolores quaerat aut iure. Qui aut reprehenderit dolor et.','1982-10-28 19:32:04'),(32,32,32,'Quisquam ducimus aut nulla et quo aspernatur. Quia qui voluptatum labore. Facilis et accusantium facilis molestiae eaque sunt.','2020-12-01 06:47:01'),(33,33,33,'Laborum voluptatum optio pariatur quasi sequi sit. Odio molestiae ducimus earum exercitationem et. Consectetur accusantium architecto dolorem sequi asperiores nulla voluptatibus.','2020-01-12 09:42:14'),(34,34,34,'Reiciendis corrupti quaerat quos eius. Beatae et assumenda suscipit sunt sunt velit. Expedita omnis voluptates amet minima in at repellendus.','2006-04-09 02:42:43'),(35,35,35,'Est mollitia consequatur eos consequatur voluptatem. In praesentium facilis quia magnam nihil et. Et ipsum sunt omnis aliquam voluptatum. Dicta doloremque sint fugiat voluptatem quo rerum commodi.','1996-04-28 03:26:30'),(36,36,36,'Consectetur perferendis provident corrupti excepturi aut. Voluptatem pariatur omnis enim quod sed maiores neque. Velit itaque modi nihil cupiditate. Omnis tempore iste praesentium pariatur.','2020-08-26 08:31:43'),(37,37,37,'Libero libero ipsa consequatur reiciendis qui. Reiciendis sint accusamus autem et tempora ea ut. Consectetur itaque qui ad possimus. Rerum illo maxime sit earum qui.','1979-06-27 07:32:10'),(38,38,38,'Veniam modi quo quis earum minus sequi debitis. Deserunt vitae omnis corrupti voluptatem similique et. Aliquam dolorem aut sint impedit exercitationem corrupti reiciendis. Quis mollitia a velit consectetur tempora voluptas.','1982-09-02 05:59:45'),(39,39,39,'Eius voluptas rerum laborum animi eligendi. Explicabo vel reiciendis ut autem praesentium omnis. Voluptas non id id et rerum. Cumque veniam et sit est.','1988-01-06 15:17:05'),(40,40,40,'Alias placeat eveniet corrupti iure repudiandae ut. Dolor eaque itaque ab qui dolore. Odio suscipit consequatur non est magnam. Vero qui officiis vitae autem. Sit laborum deleniti sequi molestiae voluptas voluptas porro.','1997-04-06 13:09:00'),(41,41,41,'Consequuntur numquam nihil sunt deserunt eligendi quam velit in. Incidunt similique fugiat omnis quas cumque molestiae vel debitis. Cumque reprehenderit aut est incidunt.','2007-02-08 10:01:16'),(42,42,42,'Iure dolor quo ut ipsa sit. Veritatis molestiae optio qui molestiae explicabo. Est ullam ut molestias ad omnis.','2019-03-12 23:56:42'),(43,43,43,'Asperiores et placeat sequi necessitatibus tempore est. Alias aspernatur non eos omnis et accusantium. Atque eius dolor aut nemo enim amet nobis.','1976-09-23 23:51:50'),(44,44,44,'Vel voluptatum inventore est suscipit. Voluptas harum autem qui vel nobis molestiae. Explicabo eos in qui error. Ipsam sed deleniti perspiciatis ullam. Ea consequatur velit nihil voluptatem soluta consequatur ullam explicabo.','1970-12-23 09:17:45'),(45,45,45,'Rerum est omnis occaecati sint sit voluptas. Ad et aut et dolores. Modi fuga assumenda repellendus nobis soluta reprehenderit saepe. Eos voluptatem omnis eligendi qui aliquid voluptatem.','2001-08-19 21:44:15'),(46,46,46,'Natus qui vel sit. Est reprehenderit ratione fuga libero perferendis.','2005-09-13 01:44:49'),(47,47,47,'Est iure et maxime qui eveniet corrupti. Aliquid quam rerum quo. Incidunt qui officiis recusandae eveniet. Mollitia dolor quo assumenda est doloribus nulla doloremque aspernatur.','2013-05-02 03:57:27'),(48,48,48,'Ad voluptate voluptatem natus. Aut veritatis inventore aut ipsam a. Commodi blanditiis corporis ut.','1998-03-19 15:01:58'),(49,49,49,'Incidunt omnis sed soluta debitis voluptatem enim. Sed autem sed consequuntur.','1976-08-30 11:45:47'),(50,50,50,'Ullam consequatur sed nemo sunt. Alias aut quibusdam adipisci et dignissimos animi repellat. Placeat ratione labore et voluptate.','2020-08-16 18:32:57'),(51,51,51,'Iste fugiat est quas. Officiis voluptatem optio aut quaerat. Quis ipsam aut repudiandae odit.','2018-08-22 16:42:04'),(52,52,52,'Repellat temporibus sunt architecto. Consequatur voluptas veniam dolorem eius dolorum sunt. Impedit eligendi sed velit quo nam id natus.','1998-08-31 21:37:03'),(53,53,53,'Possimus qui eos recusandae qui. Qui ex reiciendis quo.','2009-03-23 11:22:21'),(54,54,54,'Velit quaerat ut tempore voluptatem ad mollitia voluptatibus. Veritatis vero est asperiores repellendus qui debitis. Consequatur est aut ducimus et voluptatem. Adipisci pariatur eaque quasi quia. Natus velit laboriosam quis dolor facere laborum et.','2009-06-23 17:22:58'),(55,55,55,'Occaecati molestias aperiam ut optio necessitatibus aperiam. Atque dolor consequatur in porro consequatur. Minus tempora amet impedit libero.','1994-01-27 04:46:19'),(56,56,56,'Eveniet deleniti voluptas et. Facere magnam aut beatae reiciendis voluptates. Iste aut autem corporis error qui. Possimus dolorem est rerum omnis at modi.','2006-09-29 04:08:47'),(57,57,57,'Earum cum doloremque dolor dolores qui debitis. Officiis laudantium earum enim et.','2020-08-25 12:13:53'),(58,58,58,'Adipisci sapiente laudantium ut possimus. Sint soluta tempore dolorem. Et esse voluptate aut voluptatem quisquam. Ex et nobis placeat.','1970-06-10 03:15:44'),(59,59,59,'Est atque in dolores. Blanditiis non sequi ut similique ipsa sint porro sint. Placeat voluptas voluptas ut ducimus reiciendis nostrum labore. Alias quia doloribus amet.','2010-09-04 06:00:52'),(60,60,60,'Quae laboriosam voluptatem quia dolores impedit. Quod deserunt id earum. Eos aperiam consequatur eaque a. Tempore sint iure aut distinctio expedita aut totam.','2017-10-03 04:41:34'),(61,61,61,'Fuga quis voluptatem dolorem magnam deleniti quis consectetur in. Eos libero odit illum id deserunt corporis rem. Totam sint odit porro.','1997-12-03 13:57:43'),(62,62,62,'Aliquam possimus laudantium consectetur ducimus est. Repudiandae non pariatur voluptatibus mollitia maiores modi impedit. Ea dolores aliquid est aliquid aut.','2012-01-28 20:18:10'),(63,63,63,'Numquam optio voluptatum nobis asperiores repudiandae magnam. Ut ipsam eos iste ducimus est ut non. Modi voluptas fugiat eligendi reprehenderit. Deserunt rerum ut enim expedita non rerum.','1973-06-07 06:13:21'),(64,64,64,'Labore eaque deserunt nobis. Aperiam corporis et saepe at dolor sint maiores. Veritatis consequatur fugiat pariatur. Quasi sint consequatur fugiat ea iure quo quis.','1973-08-24 08:55:50'),(65,65,65,'Voluptas nobis magni molestiae ab tenetur ipsam. Et esse quo quia tempore non rem deleniti. Rerum cumque deserunt et incidunt quibusdam est voluptas. Quia iure maxime debitis qui.','2001-07-29 06:42:21'),(66,66,66,'Repudiandae enim laborum inventore dicta eos tempore assumenda. Tempore voluptatibus facilis dolor est iure. Non atque dolore sit nesciunt. Rem ipsam qui repellat voluptas laboriosam.','2001-09-05 17:48:17'),(67,67,67,'Est eveniet expedita molestiae quis. Ut facere ipsam aut deserunt. Magni sint fuga dolorum id explicabo accusantium.','2013-03-29 08:47:08'),(68,68,68,'Animi fugiat atque aliquid quos inventore. Inventore sequi ea sed est sapiente exercitationem modi ullam. Omnis dignissimos quis quia. Inventore quod suscipit autem ut neque quia aspernatur non.','1980-05-28 12:51:38'),(69,69,69,'Non perspiciatis et hic saepe dicta. Nam nobis quaerat delectus quasi. Vitae dolores qui magni rerum voluptatem nihil expedita sunt. Maxime nostrum enim et fugit libero similique iusto. In omnis maiores quasi sed.','1986-03-01 10:58:47'),(70,70,70,'Aut quasi sunt ducimus modi dolores nihil vel. Eum adipisci est labore aut quia. Autem quae ratione tempore itaque omnis in dolorum. In architecto iusto alias rerum sit libero doloribus.','2001-10-15 16:32:13'),(71,71,71,'Odio eum in nemo quia quo et. Tempore earum iure vitae sit quia deleniti nam. Modi velit facilis cumque voluptatum.','1975-06-05 20:53:54'),(72,72,72,'Ullam porro quis voluptas aliquid amet. Similique animi veritatis deserunt nisi odio sit quo. Qui ut et amet dicta unde.','2017-02-19 09:11:54'),(73,73,73,'Doloremque qui omnis repellendus voluptas et quam tempore. Ex consequatur beatae ut minima ut est. Est tenetur et eveniet et aut vel quaerat id.','1970-04-22 04:58:40'),(74,74,74,'Nihil impedit nam natus atque adipisci quod laboriosam. Officiis in facere cumque exercitationem dignissimos. Porro ut quos qui. Libero accusamus ut delectus autem labore alias.','2010-02-09 21:58:47'),(75,75,75,'Perferendis cum voluptatem minus eum quibusdam totam voluptatem recusandae. Debitis quaerat minus dolores voluptas vitae. Molestiae sunt sint animi.','1982-02-14 05:43:29'),(76,76,76,'Hic eos aliquid non quia. Ut voluptatibus non soluta voluptas itaque et vitae. Vel corporis dolore voluptatem eveniet unde quia consequatur. Ipsum harum saepe magnam voluptatem eos quod.','1975-02-05 13:56:07'),(77,77,77,'Consequuntur explicabo et dolorem. Molestiae incidunt omnis debitis ut fugiat ipsum omnis. Quasi architecto tenetur beatae iste mollitia.','1994-08-29 08:40:27'),(78,78,78,'Dolorem placeat a rerum non. Suscipit et tempora vel qui optio praesentium sed. Doloribus suscipit dolores at cumque.','1986-11-14 05:42:47'),(79,79,79,'Culpa tempore non in et facere impedit. Veritatis cum architecto ab vel laboriosam alias. Eum rerum veritatis et et cupiditate distinctio voluptatibus. Eos sed quia et sit.','1990-06-02 10:04:34'),(80,80,80,'Fugiat commodi et voluptatem soluta nemo voluptatem iusto fugiat. Soluta ullam molestias eius quas voluptas in ipsum ducimus. Vel nostrum et quidem. Temporibus quia recusandae sunt repellat sequi itaque quia.','1997-11-01 01:07:45'),(81,81,81,'Debitis perspiciatis illo sunt est vel vitae explicabo. At sed eaque sunt porro corrupti. Soluta sed qui laudantium non ipsam odit sint quas. Iure qui et consequatur dicta. Molestiae magnam sit id explicabo quos assumenda blanditiis.','2007-03-16 02:48:49'),(82,82,82,'Voluptate optio et ut omnis laudantium cumque. Illum molestias placeat modi porro similique recusandae.','2012-04-16 05:31:54'),(83,83,83,'Facilis ducimus voluptas voluptatum nostrum. Labore dignissimos iusto aut similique sed. Ut nihil et et consequatur ex excepturi. Eaque quo qui aut aut aut qui maxime.','2019-08-10 15:37:32'),(84,84,84,'Rerum et sapiente sit et ullam. Esse asperiores quo perferendis laborum ducimus. Atque esse quis nostrum aut vel qui.','2015-07-27 22:54:15'),(85,85,85,'Reprehenderit adipisci quis eius debitis. Molestias autem inventore totam praesentium aperiam. Natus voluptatem omnis voluptatibus ea repudiandae adipisci quibusdam.','1991-03-24 02:11:35'),(86,86,86,'Omnis omnis voluptatibus sint aut. Veniam fugiat sed sint.','1982-10-22 22:50:48'),(87,87,87,'Esse quia recusandae eius at vero et. Aut debitis dolore ratione labore quidem voluptate. Ab a dignissimos asperiores excepturi. At repellat cum et enim eos necessitatibus assumenda.','1976-04-19 15:56:40'),(88,88,88,'Commodi asperiores ea voluptas totam et blanditiis eos quod. Eum quibusdam fuga qui culpa nisi ut sit. Non modi omnis quia enim dolore quia. Nulla neque excepturi veritatis.','2003-10-10 22:14:08'),(89,89,89,'Minima et quisquam rerum qui non corporis eos. Eos enim corporis quibusdam est sunt. Asperiores dolorem voluptatum laborum molestias.','1973-08-16 16:36:45'),(90,90,90,'Eum velit eveniet deserunt praesentium id. Molestiae qui nihil aspernatur natus porro. Ratione qui quia distinctio. Voluptate deserunt deserunt quaerat aliquid soluta. Nesciunt suscipit nesciunt rerum qui enim fuga.','1987-04-07 16:40:17'),(91,91,91,'Beatae vel architecto provident expedita ipsa. Aut incidunt eius quod provident. Harum aperiam repudiandae cum tenetur.','2009-11-23 06:07:10'),(92,92,92,'Aut harum cum dicta. Qui reiciendis aspernatur adipisci beatae temporibus. Libero rerum quasi nemo dignissimos praesentium non dolor. Delectus iusto facere non esse.','2009-04-06 05:50:20'),(93,93,93,'Ex laborum esse aperiam qui voluptatum nisi. Sit non quos et reiciendis distinctio praesentium quia iusto. Nisi nam nobis dolor. Quis impedit odit accusantium ea. Voluptatem illum quas unde facilis officia deleniti.','1983-10-29 00:36:11'),(94,94,94,'Aut quisquam recusandae deleniti qui omnis facilis molestias. Praesentium commodi quidem quidem ratione repudiandae voluptatem maxime. Sed vel illo laborum.','1973-02-10 18:49:18'),(95,95,95,'Facilis voluptas provident sit officiis. Esse in doloribus hic dolor repudiandae. Voluptatum nisi aliquid eum. Qui iusto sit suscipit corporis et.','2003-10-10 12:20:28'),(96,96,96,'Minus quia dolorum odit. Provident amet dignissimos dicta dolor sed dignissimos. Et nulla sint voluptatem corporis ut.','1981-03-16 17:46:23'),(97,97,97,'Qui possimus dolore veniam doloremque. Cumque incidunt ea dolore ducimus sint dolores natus. Ratione vero excepturi pariatur ut.','1978-06-02 12:01:56'),(98,98,98,'Consequuntur minus quam asperiores expedita. Neque debitis corporis autem sit consequatur. Id esse corrupti ea nihil voluptate.','1982-05-29 20:09:20'),(99,99,99,'Ipsa sit culpa quo assumenda omnis temporibus dignissimos sed. Placeat ut illo deserunt. Est et odio deleniti. Quidem nihil dignissimos occaecati ea fuga.','2012-02-06 12:37:20'),(100,100,100,'Veniam minus tempore et doloribus molestias debitis. Velit suscipit harum sed magnam repellat minima. Distinctio tempore mollitia et saepe.','1990-07-09 20:27:40');
188INSERT INTO `profiles` VALUES (1,'1992-08-10',1,'2015-12-24 15:42:51',NULL),(2,'2012-03-30',2,'2004-12-25 03:56:55',NULL),(3,'1988-10-06',3,'1980-03-09 10:07:36',NULL),(4,'2015-04-18',4,'2015-05-22 08:28:15',NULL),(5,'2008-06-11',5,'2019-01-25 12:43:33',NULL),(6,'1998-12-22',6,'1992-02-10 14:25:56',NULL),(7,'2021-06-01',7,'2000-02-23 10:24:16',NULL),(8,'1990-04-03',8,'2010-08-04 02:28:12',NULL),(9,'1970-01-06',9,'1979-01-20 15:39:13',NULL),(10,'2017-09-17',10,'1992-11-06 02:01:58',NULL),(11,'1994-11-30',11,'1985-04-23 01:06:03',NULL),(12,'2001-02-12',12,'1985-05-04 03:03:28',NULL),(13,'1972-04-18',13,'2004-10-19 18:36:34',NULL),(14,'2014-10-05',14,'2012-03-25 10:09:31',NULL),(15,'1977-02-21',15,'1978-07-12 19:58:30',NULL),(16,'1987-09-13',16,'1986-07-21 05:56:44',NULL),(17,'1993-02-05',17,'1975-06-20 09:03:38',NULL),(18,'1998-09-06',18,'1977-07-17 08:25:56',NULL),(19,'2004-12-14',19,'1978-02-02 19:16:01',NULL),(20,'1985-07-16',20,'2000-01-30 13:46:45',NULL),(21,'1999-03-22',21,'1996-01-25 01:43:07',NULL),(22,'1986-08-22',22,'1979-07-11 17:45:05',NULL),(23,'2004-09-27',23,'2007-04-28 00:19:54',NULL),(24,'2019-07-05',24,'1996-03-06 13:54:25',NULL),(25,'2002-06-29',25,'1971-03-23 23:10:33',NULL),(26,'2016-12-23',26,'1988-11-20 15:06:45',NULL),(27,'2021-04-08',27,'1978-06-25 12:52:12',NULL),(28,'1983-05-07',28,'2009-11-03 11:03:00',NULL),(29,'1975-04-21',29,'1971-08-31 12:14:36',NULL),(30,'1985-09-13',30,'1983-05-12 19:35:35',NULL),(31,'2009-08-25',31,'1987-09-28 12:43:22',NULL),(32,'1977-10-04',32,'2007-10-28 11:28:15',NULL),(33,'2018-04-04',33,'1984-11-01 18:51:49',NULL),(34,'2014-11-16',34,'1970-08-23 16:43:27',NULL),(35,'2020-03-21',35,'1987-02-09 01:33:27',NULL),(36,'1976-01-03',36,'1972-01-19 07:46:24',NULL),(37,'2020-05-06',37,'1991-02-25 08:56:39',NULL),(38,'2004-10-30',38,'1979-06-06 07:30:08',NULL),(39,'1972-09-01',39,'2002-08-25 11:41:36',NULL),(40,'1985-03-24',40,'1988-05-26 22:06:14',NULL),(41,'1994-09-13',41,'1974-02-08 20:58:49',NULL),(42,'2011-10-17',42,'2016-10-15 23:23:21',NULL),(43,'2019-01-07',43,'1986-09-10 08:45:44',NULL),(44,'1977-09-16',44,'1993-05-24 03:26:32',NULL),(45,'1970-11-17',45,'1974-05-07 14:33:34',NULL),(46,'1992-10-13',46,'1983-02-07 11:00:37',NULL),(47,'1997-07-17',47,'2014-11-03 11:34:25',NULL),(48,'1994-08-06',48,'2020-07-03 01:56:17',NULL),(49,'2016-06-03',49,'1977-06-27 00:23:51',NULL),(50,'1991-07-01',50,'1988-04-11 06:12:06',NULL),(51,'2012-05-21',1,'1993-07-31 21:50:30',NULL),(52,'1991-04-22',2,'1993-12-17 09:34:43',NULL),(53,'1978-12-24',3,'2001-02-03 11:03:55',NULL),(54,'1990-11-20',4,'1970-10-07 07:50:05',NULL),(55,'1981-03-16',5,'1970-03-28 14:33:03',NULL),(56,'1984-03-29',6,'2003-04-29 14:20:58',NULL),(57,'1990-10-04',7,'1980-03-21 10:51:58',NULL),(58,'1972-04-28',8,'2007-11-12 15:37:52',NULL),(59,'1972-09-03',9,'1978-03-01 16:47:02',NULL),(60,'2009-11-27',10,'1997-01-24 13:12:23',NULL),(61,'2019-08-22',11,'1983-04-29 11:25:53',NULL),(62,'2005-06-24',12,'2005-02-13 16:11:19',NULL),(63,'1975-05-29',13,'2015-08-25 01:45:19',NULL),(64,'1972-01-03',14,'1997-06-16 13:02:47',NULL),(65,'1990-02-06',15,'1987-01-25 23:09:06',NULL),(66,'1997-09-04',16,'1996-08-09 12:12:45',NULL),(67,'1986-12-29',17,'2015-06-18 01:29:40',NULL),(68,'2019-02-24',18,'1973-06-10 01:20:35',NULL),(69,'2013-12-03',19,'2016-03-23 11:54:02',NULL),(70,'1981-12-05',20,'1996-01-06 20:50:39',NULL),(71,'1987-07-29',21,'1984-12-13 10:23:46',NULL),(72,'1980-09-17',22,'2016-03-29 18:39:51',NULL),(73,'2009-05-07',23,'1975-09-29 20:31:55',NULL),(74,'1988-01-06',24,'2015-02-08 18:00:58',NULL),(75,'1987-03-04',25,'2005-09-16 15:54:00',NULL),(76,'1980-07-07',26,'1996-02-09 11:48:59',NULL),(77,'1970-01-28',27,'1982-04-15 23:50:50',NULL),(78,'2013-01-06',28,'1992-04-15 05:52:20',NULL),(79,'2004-07-16',29,'2008-11-13 18:00:25',NULL),(80,'1981-09-13',30,'2016-05-06 08:42:55',NULL),(81,'2020-03-18',31,'2001-05-03 05:20:27',NULL),(82,'2016-04-27',32,'1981-04-20 23:39:13',NULL),(83,'2003-07-20',33,'1988-07-25 11:09:17',NULL),(84,'2014-08-07',34,'1984-04-29 02:38:11',NULL),(85,'2000-04-02',35,'2013-11-27 13:01:34',NULL),(86,'2013-02-12',36,'1973-08-14 11:30:33',NULL),(87,'2021-03-19',37,'1988-01-13 00:11:44',NULL),(88,'1978-06-18',38,'2015-12-11 14:24:44',NULL),(89,'2003-04-30',39,'1974-08-10 15:04:57',NULL),(90,'1976-04-16',40,'1993-01-23 06:09:38',NULL),(91,'2017-04-04',41,'1990-09-04 09:21:28',NULL),(92,'1990-09-20',42,'1990-11-15 20:10:25',NULL),(93,'1987-12-27',43,'1999-05-02 21:45:45',NULL),(94,'2011-05-25',44,'2010-10-12 09:48:42',NULL),(95,'2017-11-05',45,'2008-10-23 07:57:15',NULL),(96,'2011-06-16',46,'1997-11-21 17:15:15',NULL),(97,'1977-10-06',47,'2015-12-02 03:04:15',NULL),(98,'1998-07-02',48,'1970-11-28 14:33:46',NULL),(99,'1988-10-31',49,'1998-02-07 15:06:22',NULL),(100,'2008-03-24',50,'1978-05-10 09:50:05',NULL);
189INSERT INTO `users_communities` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12),(13,13),(14,14),(15,15),(16,16),(17,17),(18,18),(19,19),(20,20),(21,21),(22,22),(23,23),(24,24),(25,25),(26,26),(27,27),(28,28),(29,29),(30,30),(31,31),(32,32),(33,33),(34,34),(35,35),(36,36),(37,37),(38,38),(39,39),(40,40),(41,41),(42,42),(43,43),(44,44),(45,45),(46,46),(47,47),(48,48),(49,49),(50,50),(51,51),(52,52),(53,53),(54,54),(55,55),(56,56),(57,57),(58,58),(59,59),(60,60),(61,61),(62,62),(63,63),(64,64),(65,65),(66,66),(67,67),(68,68),(69,69),(70,70),(71,71),(72,72),(73,73),(74,74),(75,75),(76,76),(77,77),(78,78),(79,79),(80,80),(81,81),(82,82),(83,83),(84,84),(85,85),(86,86),(87,87),(88,88),(89,89),(90,90),(91,91),(92,92),(93,93),(94,94),(95,95),(96,96),(97,97),(98,98),(99,99),(100,100);
190INSERT INTO `users_gender` VALUES (1,6),(3,6),(5,6),(7,6),(9,6),(11,6),(13,6),(15,6),(17,6),(19,6),(21,6),(23,6),(25,6),(27,6),(29,6),(31,6),(33,6),(35,6),(37,6),(39,6),(41,6),(43,6),(45,6),(47,6),(49,6),(51,6),(53,6),(55,6),(57,6),(59,6),(61,6),(63,6),(65,6),(67,6),(69,6),(71,6),(73,6),(75,6),(77,6),(79,6),(81,6),(83,6),(85,6),(87,6),(89,6),(91,6),(93,6),(95,6),(97,6),(99,6),(2,7),(4,7),(6,7),(8,7),(10,7),(12,7),(14,7),(16,7),(18,7),(20,7),(22,7),(24,7),(26,7),(28,7),(30,7),(32,7),(34,7),(36,7),(38,7),(40,7),(42,7),(44,7),(46,7),(48,7),(50,7),(52,7),(54,7),(56,7),(58,7),(60,7),(62,7),(64,7),(66,7),(68,7),(70,7),(72,7),(74,7),(76,7),(78,7),(80,7),(82,7),(84,7),(86,7),(88,7),(90,7),(92,7),(94,7),(96,7),(98,7),(100,7);
191INSERT INTO `users_pets` VALUES (1,761),(2,763),(3,764),(4,765),(5,766),(6,767),(7,768),(8,769),(9,770),(10,771),(11,772),(12,773),(13,774),(14,775),(15,776),(16,777),(17,778),(18,779),(19,780),(20,781),(21,782),(22,785),(23,786),(24,787),(25,788),(26,789),(27,793),(28,794),(29,795),(30,796),(31,797),(32,799),(33,800),(34,761),(35,763),(36,764),(37,765),(38,766),(39,767),(40,768),(41,769),(42,770),(43,771),(44,772),(45,773),(46,774),(47,775),(48,776),(49,777),(50,778);
192
193/*
1942. Написать скрипт, возвращающий список имен (только firstname) пользователей без повторений в алфавитном порядке.*/
195
196SELECT DISTINCT firstname 
197FROM users
198ORDER BY firstname ASC;
199
200/*
2013.Первые пять пользователей пометить как удаленные.*/
202SELECT id FROM users WHERE id<=5;
203
204UPDATE users 
205SET 
206    is_deleted = 1
207  WHERE id<=5;
208
209/* 
2104. Написать скрипт, удаляющий сообщения «из будущего» (дата больше сегодняшней).*/
211
212DELETE FROM messages
213WHERE created_at > CURRENT_DATE;
214
215/*
2165.Написать название темы курсового проекта.
217
218ON-LINE приемная полиции Готэм-сити*/
219
220
221
222
223