search

Maxim963 / BD_teach

bd for learning
0 stars 0 forks source link

less4 #2

Open Maxim963 opened 4 years ago

Maxim963 commented 4 years ago

DROP database IF EXISTS vk2; CREATE database vk2; use vk2;

DROP TABLE IF EXISTS communities; CREATE TABLE communities ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id), KEY communities_name_idx (name) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO communities VALUES ('30','assumenda'), ('19','aut'), ('82','aut'), ('92','aut'), ('100','aut'), ('56','commodi'), ('16','consectetur'), ('55','consectetur'), ('59','consequatur'), ('57','consequuntur'), ('65','corporis'), ('9','cumque'), ('22','delectus'), ('99','delectus'), ('49','dicta'), ('67','dolor'), ('98','dolor'), ('2','dolorem'), ('88','dolores'), ('13','dolorum'), ('79','ea'), ('4','earum'), ('21','eligendi'), ('48','eos'), ('83','error'), ('8','esse'), ('32','esse'), ('18','est'), ('46','est'), ('89','est'), ('90','est'), ('28','et'), ('35','et'), ('36','et'), ('54','et'), ('58','et'), ('34','eum'), ('39','ex'), ('95','excepturi'), ('20','exercitationem'), ('66','facere'), ('37','fuga'), ('71','fuga'), ('15','hic'), ('80','illo'), ('45','illum'), ('27','in'), ('72','inventore'), ('5','itaque'), ('84','itaque'), ('96','labore'), ('26','laborum'), ('97','laudantium'), ('38','magni'), ('68','magni'), ('11','modi'), ('43','modi'), ('24','molestiae'), ('63','nam'), ('91','nam'), ('76','nemo'), ('1','neque'), ('61','nobis'), ('17','non'), ('70','non'), ('7','officia'), ('51','officiis'), ('3','perferendis'), ('14','perferendis'), ('29','possimus'), ('75','praesentium'), ('53','provident'), ('94','quaerat'), ('47','qui'), ('23','quia'), ('52','quia'), ('44','quo'), ('73','quos'), ('40','reiciendis'), ('86','reprehenderit'), ('12','rerum'), ('33','rerum'), ('78','rerum'), ('41','saepe'), ('87','saepe'), ('50','sequi'), ('6','similique'), ('77','sit'), ('25','soluta'), ('85','totam'), ('64','unde'), ('42','velit'), ('60','velit'), ('62','vitae'), ('74','vitae'), ('81','voluptas'), ('10','voluptatem'), ('31','voluptatem'), ('69','voluptatem'), ('93','voluptatem');

DROP TABLE IF EXISTS friend_requests; CREATE TABLE friend_requests ( initiator_user_id bigint(20) unsigned NOT NULL, target_user_id bigint(20) unsigned NOT NULL, status enum('requested','approved','unfriended','declined') COLLATE utf8_unicode_ci DEFAULT NULL, requested_at datetime DEFAULT current_timestamp(), confirmed_at datetime DEFAULT NULL, PRIMARY KEY (initiator_user_id,target_user_id), KEY initiator_user_id (initiator_user_id), KEY target_user_id (target_user_id), CONSTRAINT friend_requests_ibfk_1 FOREIGN KEY (initiator_user_id) REFERENCES users (id), CONSTRAINT friend_requests_ibfk_2 FOREIGN KEY (target_user_id) REFERENCES users (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO friend_requests VALUES ('1','1','unfriended','2011-05-24 23:31:46','2008-12-17 15:30:37'), ('2','2','unfriended','1986-07-29 21:12:04','1998-06-01 08:19:39'), ('3','3','requested','2017-12-26 21:30:58','1981-03-13 21:49:21'), ('4','4','declined','1970-05-21 13:20:21','2004-09-07 05:59:39'), ('5','5','unfriended','1999-02-16 16:41:28','2018-02-10 22:48:33'), ('6','6','unfriended','1982-10-10 01:56:33','2005-02-08 09:41:21'), ('7','7','unfriended','1987-10-11 14:13:04','1981-06-20 01:19:39'), ('8','8','requested','2011-06-06 06:10:33','1976-05-21 22:35:42'), ('9','9','declined','2008-04-15 18:00:59','2009-06-06 13:49:28'), ('10','10','unfriended','1978-11-04 13:28:16','2010-06-06 02:00:45'), ('11','11','unfriended','1988-09-17 06:53:44','2004-01-10 10:53:02'), ('12','12','requested','2009-03-04 10:41:39','1983-04-07 09:36:32'), ('13','13','requested','1999-05-20 11:20:19','1986-06-13 13:05:45'), ('14','14','declined','1977-08-18 05:55:19','1977-06-24 22:41:15'), ('15','15','declined','2012-03-06 13:57:34','1971-07-19 18:40:52'), ('16','16','approved','1987-07-21 15:44:00','2012-11-18 08:51:55'), ('17','17','declined','1995-10-05 10:03:42','2019-08-09 22:04:17'), ('18','18','requested','1973-02-22 19:25:31','1991-05-15 18:05:03'), ('19','19','declined','1991-02-21 21:54:55','1993-06-21 14:44:02'), ('20','20','declined','1994-08-10 23:03:12','1975-03-09 04:18:40');

DROP TABLE IF EXISTS groups; CREATE TABLE groups ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_unicode_ci NOT NULL, user_id bigint(20) unsigned NOT NULL, theme varchar(255) COLLATE utf8_unicode_ci NOT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY name_group (name), KEY user_id (user_id), CONSTRAINT groups_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO groups VALUES ('1','rem','1','','2017-10-12 06:29:35','1978-12-27 01:07:27'), ('2','nemo','2','','1974-10-20 04:28:41','2013-06-22 18:46:14'), ('3','voluptatem','3','','1984-01-11 02:05:59','1977-08-26 23:08:25'), ('4','inventore','4','','1979-08-12 13:57:31','1974-11-22 20:37:34'), ('5','maxime','5','','2011-10-31 13:45:29','1986-12-19 18:52:58'), ('6','magnam','6','','1979-10-11 21:34:53','2012-07-02 11:47:18'), ('7','iure','7','','1975-11-15 23:07:49','2016-09-23 17:48:22'), ('8','maiores','8','','2003-06-07 23:38:06','1993-04-23 00:18:27'), ('9','quibusdam','9','','1994-11-05 11:32:56','1985-02-08 07:40:49'), ('10','quas','10','','2007-01-31 00:17:41','2016-08-02 18:20:48'), ('11','reprehenderit','11','','1988-10-15 07:31:13','1993-02-12 15:41:10'), ('12','deserunt','12','','2004-07-05 01:01:28','2007-10-18 09:11:12'), ('13','ut','13','','2003-12-01 13:54:16','1991-05-25 20:22:40'), ('14','et','14','','2006-08-29 00:38:18','2019-02-12 10:22:02'), ('15','molestiae','15','','1981-03-24 17:01:31','1991-03-31 20:50:51'), ('16','repellendus','16','','1986-03-03 03:33:55','2002-09-05 05:18:23'), ('17','suscipit','17','','1973-10-31 18:25:43','2001-09-15 01:07:04'), ('18','libero','18','','1987-07-08 23:34:03','2012-08-12 03:45:12'), ('19','aut','19','','1972-05-06 03:20:18','1986-09-29 19:25:04'), ('20','quia','20','','2006-01-26 16:24:58','1991-04-15 15:26:50');

DROP TABLE IF EXISTS likes; CREATE TABLE likes ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, media_id bigint(20) unsigned NOT NULL, created_at datetime DEFAULT current_timestamp(), PRIMARY KEY (id), KEY user_id (user_id), KEY media_id (media_id), CONSTRAINT likes_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT likes_ibfk_2 FOREIGN KEY (media_id) REFERENCES media (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO likes VALUES ('1','1','1','2011-01-09 15:07:36'), ('2','2','2','1981-12-14 22:26:53'), ('3','3','3','1992-07-14 14:51:40'), ('4','4','4','1978-08-16 06:05:50'), ('5','5','5','2007-01-07 17:44:38'), ('6','6','6','2011-07-01 15:11:12'), ('7','7','7','1989-08-06 15:36:41'), ('8','8','8','1977-06-05 16:15:44'), ('9','9','9','2001-06-24 22:15:27'), ('10','10','10','1977-09-14 08:48:29'), ('11','11','11','1991-05-23 20:26:31'), ('12','12','12','1974-12-10 17:23:57'), ('13','13','13','1982-06-27 09:14:40'), ('14','14','14','2009-07-13 18:29:28'), ('15','15','15','1994-02-08 04:01:46'), ('16','16','16','1997-05-10 17:02:51'), ('17','17','17','1973-08-05 11:08:25'), ('18','18','18','1972-01-15 11:18:32'), ('19','19','19','2002-03-08 06:46:28'), ('20','20','20','1991-07-03 22:10:40');

DROP TABLE IF EXISTS media; CREATE TABLE media ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, media_type_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, body text COLLATE utf8_unicode_ci DEFAULT NULL, filename varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, size int(11) DEFAULT NULL, metadata longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY user_id (user_id), KEY media_type_id (media_type_id), CONSTRAINT media_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT media_ibfk_2 FOREIGN KEY (media_type_id) REFERENCES media_types (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO media VALUES ('1','1','1','Officiis temporibus doloribus et iusto. Unde autem aut consequatur nesciunt officia sit. Illo et ut illo enim. Expedita iure aut error dicta eius.','suscipit','8987871',NULL,'2003-05-20 10:58:05','2006-03-12 01:18:30'), ('2','2','2','Accusamus voluptatem illo beatae harum sunt. Aut distinctio qui est repudiandae eaque. Eaque perspiciatis exercitationem voluptatem facere. Quaerat corrupti vero perferendis corrupti.','voluptas','169322',NULL,'1983-06-07 14:40:38','1989-09-07 11:02:24'), ('3','3','3','Provident ut quia dolore et. Facilis occaecati sequi eius atque inventore. Quam qui rerum officiis non et ea ab fugit. Consequuntur vitae asperiores cum ab quis commodi. Est repellendus illo et quae odio eaque.','aut','3',NULL,'1994-09-07 18:41:41','2003-12-30 16:09:07'), ('4','4','4','Voluptatem vel laudantium similique voluptatum id ullam deserunt. Natus accusantium minima excepturi quas culpa corporis. Enim eveniet facere sit sunt illum nam aut. Sunt rerum corporis repudiandae et labore.','rerum','7562239',NULL,'2015-01-27 06:32:16','2019-05-26 00:59:50'), ('5','5','5','Esse voluptatem in occaecati nisi et ut dolor. Aut iste dolor accusamus. Eveniet qui error ducimus nam. Accusamus vel veniam a odit et soluta fugit magni. In beatae amet ut repellat quas et.','nesciunt','1',NULL,'2017-01-01 17:35:55','1975-04-14 22:00:22'), ('6','6','6','Sit autem officiis et ducimus. Voluptas et fugiat eos dolorem molestiae eos asperiores. Quia natus voluptatem debitis id sint. Incidunt fugiat aut sit consectetur iste sint ratione vitae.','ut','352365346',NULL,'1983-03-04 19:54:55','2019-07-11 22:02:21'), ('7','7','7','Omnis ipsum commodi sit consequatur molestias commodi. Quos consequatur sed eos et minus eum similique corrupti. Beatae laboriosam quia doloremque consequuntur.','voluptas','7',NULL,'1994-01-11 03:21:05','1970-12-24 16:54:43'), ('8','8','8','Ipsum enim pariatur ea. Qui aliquam sequi facilis natus rerum. Odit harum quod laborum aliquid.','eaque','9',NULL,'1992-11-14 08:52:29','2017-12-09 01:26:32'), ('9','9','9','Voluptatem enim eos numquam fuga sint aperiam. Earum assumenda quia cum mollitia ea laboriosam. Iste molestiae voluptatum harum.','quasi','0',NULL,'1997-12-08 15:55:01','2001-04-09 22:50:34'), ('10','10','10','Deserunt veritatis voluptates dolor id non velit debitis explicabo. Commodi inventore quo neque ullam. Consequatur quo autem ut. Iste consequatur cum consequatur aut quasi consectetur dignissimos.','nostrum','89606',NULL,'1972-01-22 03:43:29','1988-08-19 23:52:18'), ('11','11','11','Impedit exercitationem corporis consectetur neque. Et error recusandae animi nulla. Libero nisi accusantium ut temporibus consequatur sed cumque.','hic','0',NULL,'2000-03-09 08:47:11','1993-06-27 13:11:07'), ('12','12','12','Inventore minus beatae eum consequatur nisi enim reprehenderit. Magni qui iste ipsum deserunt repellendus numquam ut. Est omnis ipsam culpa iure unde. Doloribus et corporis accusamus blanditiis.','magnam','1',NULL,'1976-09-07 05:44:15','2011-12-06 02:53:14'), ('13','13','13','Dolorum est dolorem qui dolor. Voluptate sit aut facilis magnam doloribus perspiciatis. Aut quos sint saepe et veniam soluta.','sit','74616489',NULL,'1989-10-12 07:26:28','1987-08-12 13:21:11'), ('14','14','14','Veniam voluptatem nesciunt ex ut. Aliquam facere molestiae sit perferendis a. Est inventore sit aut.','saepe','20',NULL,'2002-02-25 22:37:12','1997-10-06 06:28:29'), ('15','15','15','Provident expedita cupiditate quia ad officia. Laboriosam quia in iure rerum dolores accusantium earum. Itaque blanditiis officiis reiciendis tempore nesciunt laudantium animi. Maxime pariatur voluptatem perferendis quibusdam non maiores dolorem.','molestias','76645',NULL,'2011-04-11 05:13:40','2017-10-29 02:19:30'), ('16','16','16','Dicta facilis culpa cupiditate quae praesentium numquam. Odio dicta hic et distinctio ex. Optio eaque non corrupti qui nemo sed rem consequuntur. Sunt minus est quia et. Dolorum consequatur temporibus dolorum earum voluptatum sequi.','sed','1441287',NULL,'2015-10-16 07:39:45','2017-10-08 21:59:04'), ('17','17','17','Voluptate dolores vero quia qui a. Sint in aliquam voluptatem accusantium quae ratione non. Architecto dolore quo vel quia sed.','distinctio','11',NULL,'2009-04-06 06:10:27','1986-09-22 23:51:26'), ('18','18','18','Fuga rerum harum et voluptatibus consequatur facere. Sed occaecati animi eaque sit quia expedita earum. Mollitia deserunt non aliquid placeat quam blanditiis.','est','20510',NULL,'1987-01-31 17:22:06','2017-08-08 08:07:38'), ('19','19','19','Dolores dolorum veritatis officiis. Neque aspernatur ratione reiciendis nobis dolorem voluptatem. Quidem nobis est ipsa. Deleniti perspiciatis at sint architecto in.','consequatur','47984216',NULL,'2002-04-02 16:27:40','1998-11-07 23:49:26'), ('20','20','20','Eum reiciendis recusandae labore quo et unde. Facilis laudantium doloribus ut magnam qui adipisci dolorum accusantium. Nesciunt excepturi numquam officiis sequi. Provident deleniti asperiores neque itaque.','et','266623657',NULL,'2018-08-24 16:05:23','1980-07-21 03:40:28');

DROP TABLE IF EXISTS media_types; CREATE TABLE media_types ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO media_types VALUES ('1','incidunt','1972-01-30 04:40:52','2008-01-27 10:29:55'), ('2','amet','1996-06-06 12:28:54','1984-08-24 17:28:32'), ('3','alias','2014-01-30 16:53:46','1991-02-12 06:10:05'), ('4','dolor','1996-06-30 02:55:55','2015-01-26 12:27:19'), ('5','quos','1975-01-31 06:34:28','1988-08-18 19:56:40'), ('6','exercitationem','1979-06-01 16:21:25','1998-03-21 12:18:23'), ('7','excepturi','2001-02-06 17:47:07','1990-09-09 08:09:56'), ('8','qui','2005-11-18 08:48:50','1972-10-14 10:18:30'), ('9','enim','2019-06-08 08:31:01','1993-09-22 20:29:44'), ('10','et','1975-05-24 07:07:49','2018-03-08 22:57:52'), ('11','voluptas','1997-05-30 21:07:15','2007-11-27 02:42:08'), ('12','consequatur','2013-09-15 17:34:33','1990-07-01 05:15:19'), ('13','nisi','1985-08-19 22:22:57','1984-12-29 03:23:50'), ('14','odit','1999-09-26 23:28:00','2016-09-06 05:53:30'), ('15','itaque','1989-01-06 06:59:52','2009-08-28 15:13:35'), ('16','repudiandae','1998-02-09 00:59:18','2010-08-04 11:14:22'), ('17','excepturi','2008-01-23 22:58:15','1979-05-10 22:51:33'), ('18','quos','1975-06-28 03:21:50','1973-02-01 10:52:05'), ('19','cupiditate','1979-11-09 13:12:54','2002-10-27 14:25:42'), ('20','esse','2007-01-18 07:21:00','1989-11-10 15:17:25');

DROP TABLE IF EXISTS mess_of_gr; CREATE TABLE mess_of_gr ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, from_user_id bigint(20) unsigned NOT NULL, txt text COLLATE utf8_unicode_ci DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY mess_from_user_id (from_user_id), CONSTRAINT mess_of_gr_ibfk_1 FOREIGN KEY (id) REFERENCES groups (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO mess_of_gr VALUES ('1','1',NULL,'1987-01-01 09:50:31','1975-07-20 15:07:53'), ('2','2',NULL,'2008-04-25 00:14:32','2005-04-16 17:35:27'), ('3','3',NULL,'2018-02-02 12:34:07','1994-07-31 03:20:32'), ('4','4',NULL,'1981-05-22 08:32:46','1984-05-09 15:44:32'), ('5','5',NULL,'1985-02-14 00:07:15','2016-08-30 17:58:34'), ('6','6',NULL,'1996-04-17 02:03:59','1982-05-23 16:08:26'), ('7','7',NULL,'2014-07-03 08:31:04','1982-06-29 00:59:03'), ('8','8',NULL,'1973-07-04 20:18:58','1979-05-09 14:22:01'), ('9','9',NULL,'1996-11-30 13:32:16','1974-01-21 10:59:26'), ('10','10',NULL,'2016-05-15 21:50:37','1987-02-20 20:01:33'), ('11','11',NULL,'1985-05-18 17:25:54','1978-02-01 14:02:53'), ('12','12',NULL,'1977-04-03 09:43:00','1999-11-27 17:09:24'), ('13','13',NULL,'1979-07-30 01:30:33','1982-04-27 07:44:52'), ('14','14',NULL,'1973-05-17 23:18:05','1984-09-16 10:59:17'), ('15','15',NULL,'2010-07-12 12:56:03','1974-11-17 16:14:44'), ('16','16',NULL,'1998-06-30 13:10:24','1989-06-02 09:11:18'), ('17','17',NULL,'1995-04-15 09:07:18','1993-04-02 18:11:30'), ('18','18',NULL,'2014-04-19 17:34:21','2019-01-05 17:04:03'), ('19','19',NULL,'1983-12-21 08:43:38','1976-03-07 06:31:21'), ('20','20',NULL,'1989-05-17 02:18:06','1990-11-01 08:17:05');

DROP TABLE IF EXISTS messages; CREATE TABLE messages ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, from_user_id bigint(20) unsigned NOT NULL, to_user_id bigint(20) unsigned NOT NULL, body text COLLATE utf8_unicode_ci DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), PRIMARY KEY (id), KEY messages_from_user_id (from_user_id), KEY messages_to_user_id (to_user_id), CONSTRAINT messages_ibfk_1 FOREIGN KEY (from_user_id) REFERENCES users (id), CONSTRAINT messages_ibfk_2 FOREIGN KEY (to_user_id) REFERENCES users (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO messages VALUES ('1','1','1','Iste inventore est necessitatibus libero culpa. Omnis molestiae vel quas labore. Aspernatur recusandae assumenda consequatur mollitia exercitationem nesciunt sapiente eveniet.','1981-01-18 01:13:38'), ('2','2','2','Amet quos sit dolore. Perspiciatis natus qui voluptas nam. Dolorum laudantium sed reiciendis sit qui eligendi odit ipsum. Distinctio et aperiam ut ut.','1985-04-05 12:16:26'), ('3','3','3','Aut architecto quis et repellat. Doloribus itaque voluptas sed omnis. Et porro qui itaque rerum eos accusantium dicta.','2000-01-12 19:56:24'), ('4','4','4','Recusandae illum dolorum officia atque repellat laborum. Et autem vero doloremque quidem. Sint voluptatum nisi blanditiis voluptas ut voluptatem. Enim occaecati dolor voluptatem maxime.','2001-11-15 16:45:55'), ('5','5','5','Quis odio ea sequi est expedita est saepe. Quaerat omnis molestias aut tempora. Quo consectetur pariatur dolorum aliquid delectus sapiente ut. Aperiam dignissimos possimus vel culpa ipsam.','1983-03-05 16:16:10'), ('6','6','6','Corporis molestiae et quia vero voluptate alias. Eveniet et iure aut velit vero.','2019-09-15 06:49:31'), ('7','7','7','Eos aut dolor voluptatem sit eos doloremque sed quis. Velit praesentium dolorem ut. Omnis ducimus sed aspernatur et aut possimus.','1996-07-26 20:22:39'), ('8','8','8','Nesciunt alias doloribus voluptas omnis ut accusamus amet dolorem. Repellat a ipsum laborum iste neque. Veniam tempora reprehenderit ea autem.','1990-09-10 17:37:02'), ('9','9','9','Eos maxime nihil sit recusandae sed ut. Eos ut eum necessitatibus repellat enim omnis illum dolores. Dolor aut aut dolores fuga cum delectus. Ut rerum incidunt quam iure ea ullam soluta deserunt.','1985-04-25 13:00:39'), ('10','10','10','Cumque vero id animi assumenda sit quod qui. Deleniti iste nesciunt veritatis qui qui sed est. Cumque omnis voluptatibus magnam sit cupiditate. Maiores quos id asperiores quam asperiores at sequi.','1998-05-04 06:44:02'), ('11','11','11','Ipsa consequatur aliquam qui unde odit reiciendis fuga. Eaque quis placeat ipsam omnis temporibus. Commodi temporibus quis illum beatae. Et iure qui sit impedit explicabo aut soluta.','2010-03-12 12:50:53'), ('12','12','12','Possimus nobis reprehenderit nihil labore ipsa deserunt. Debitis et earum et ex veritatis libero. Voluptas vero maiores eius enim quia qui praesentium. Perferendis aspernatur provident excepturi facere ut fugiat.','1989-01-29 07:49:34'), ('13','13','13','Ea ut nesciunt vel deserunt voluptatibus aliquid dolores quos. Fugiat ea ullam vitae veritatis et molestiae. Voluptas natus odit et voluptas id dolores ratione. Et quo repellat repellat amet.','2002-06-15 06:37:08'), ('14','14','14','Architecto asperiores nisi fugiat culpa quae. Doloribus omnis autem id modi aut ut qui. Et voluptatem id omnis.','2003-05-15 07:23:51'), ('15','15','15','Quidem et voluptas optio omnis quaerat voluptas. Quia delectus molestiae neque in magni. Hic et quisquam quibusdam hic. Impedit est et ex debitis itaque.','2014-01-28 02:29:13'), ('16','16','16','Voluptas est mollitia itaque doloremque accusantium ut. Et molestias et nisi recusandae a vel. Sapiente et doloremque aut voluptas tenetur occaecati aliquam. Dolore reiciendis rerum consequatur expedita. Rerum accusantium totam commodi id alias.','2000-03-11 09:01:31'), ('17','17','17','Et exercitationem provident dolor deserunt deleniti. Omnis fuga sed autem voluptatibus est sunt et animi. Qui est veniam qui velit cupiditate. Laboriosam deleniti deserunt sunt dolor distinctio.','1992-08-04 18:28:53'), ('18','18','18','Esse dolor ratione officiis vel aut nihil molestias et. Iste est consequatur aliquam. Recusandae ad ipsam debitis in.','2019-05-07 19:25:09'), ('19','19','19','Voluptatem est nesciunt molestiae ab. Minima veniam velit commodi fugit. Numquam architecto rerum possimus voluptatum est. Unde minus eos aut nisi commodi ut est.','2004-12-05 16:55:50'), ('20','20','20','Pariatur id veniam non ad. Saepe ad animi aut nisi tempora temporibus. Deleniti quia voluptas voluptatum et.','2002-06-01 00:48:15');

DROP TABLE IF EXISTS music; CREATE TABLE music ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, media_id bigint(20) unsigned NOT NULL, themes varchar(255) COLLATE utf8_unicode_ci NOT NULL, autor varchar(255) COLLATE utf8_unicode_ci NOT NULL, song varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id), KEY theme_of_music (themes), KEY autor_of_music (autor), KEY name_of_song (song), KEY media_id (media_id), CONSTRAINT music_ibfk_1 FOREIGN KEY (media_id) REFERENCES media (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO music 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','','','');

DROP TABLE IF EXISTS photo_albums; CREATE TABLE photo_albums ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, user_id bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY id (id), KEY user_id (user_id), CONSTRAINT photo_albums_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO photo_albums VALUES ('1','dolore','1'), ('2','et','2'), ('3','voluptates','3'), ('4','excepturi','4'), ('5','quia','5'), ('6','officiis','6'), ('7','qui','7'), ('8','labore','8'), ('9','officiis','9'), ('10','unde','10'), ('11','iste','11'), ('12','tenetur','12'), ('13','necessitatibus','13'), ('14','assumenda','14'), ('15','similique','15'), ('16','rerum','16'), ('17','molestiae','17'), ('18','culpa','18'), ('19','perferendis','19'), ('20','omnis','20');

DROP TABLE IF EXISTS photos; CREATE TABLE photos ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, album_id bigint(20) unsigned NOT NULL, media_id bigint(20) unsigned NOT NULL, PRIMARY KEY (id), KEY album_id (album_id), KEY media_id (media_id), CONSTRAINT photos_ibfk_1 FOREIGN KEY (album_id) REFERENCES photo_albums (id), CONSTRAINT photos_ibfk_2 FOREIGN KEY (media_id) REFERENCES media (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT 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');

DROP TABLE IF EXISTS profiles; CREATE TABLE profiles ( user_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, gender char(1) COLLATE utf8_unicode_ci DEFAULT NULL, birthday date DEFAULT NULL, photo_id bigint(20) unsigned DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), hometown varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (user_id), CONSTRAINT profiles_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO profiles VALUES ('1',NULL,'1992-03-04','1','1973-05-31 03:09:00',NULL), ('2',NULL,'1993-06-12','2','1986-02-07 00:33:00',NULL), ('3',NULL,'2002-07-27','3','2018-10-12 06:11:16',NULL), ('4',NULL,'1993-06-04','4','1971-03-27 19:43:46',NULL), ('5',NULL,'2005-05-20','5','1986-04-25 08:48:09',NULL), ('6',NULL,'1983-07-11','6','1994-12-09 07:01:30',NULL), ('7',NULL,'1982-08-19','7','2001-10-21 12:07:11',NULL), ('8',NULL,'2003-11-22','8','1985-05-14 18:48:20',NULL), ('9',NULL,'1985-02-15','9','2011-03-19 05:33:15',NULL), ('10',NULL,'1986-05-04','10','1993-05-30 23:31:38',NULL), ('11',NULL,'2010-12-29','11','1975-06-14 02:34:39',NULL), ('12',NULL,'2019-06-04','12','1973-02-03 05:09:29',NULL), ('13',NULL,'1979-11-19','13','1984-07-18 12:06:29',NULL), ('14',NULL,'2008-11-09','14','1991-11-11 17:04:58',NULL), ('15',NULL,'1994-11-19','15','2017-09-19 23:17:41',NULL), ('16',NULL,'1992-07-14','16','2017-03-15 18:11:22',NULL), ('17',NULL,'2008-03-25','17','2015-11-19 01:16:59',NULL), ('18',NULL,'1989-03-25','18','2000-04-25 19:22:30',NULL), ('19',NULL,'1976-07-14','19','1977-03-01 12:04:18',NULL), ('20',NULL,'2017-02-28','20','1993-08-09 01:57:39',NULL), ('21',NULL,'2004-08-13','1','2005-03-06 13:19:13',NULL), ('22',NULL,'1987-10-17','2','2006-05-27 09:25:02',NULL), ('23',NULL,'1971-05-18','3','1988-07-27 10:58:33',NULL), ('24',NULL,'2005-02-26','4','1971-02-16 12:18:34',NULL), ('25',NULL,'1991-04-09','5','2003-04-09 16:50:17',NULL), ('26',NULL,'1970-08-01','6','1988-06-22 13:28:55',NULL), ('27',NULL,'1999-02-10','7','1972-06-08 23:06:03',NULL), ('28',NULL,'1985-12-05','8','1994-06-28 03:57:34',NULL), ('29',NULL,'1979-10-19','9','2019-02-18 15:21:17',NULL), ('30',NULL,'1994-10-27','10','1981-02-14 23:46:33',NULL), ('31',NULL,'1988-06-06','11','2002-10-09 06:47:23',NULL), ('32',NULL,'1980-11-28','12','1979-04-06 11:40:15',NULL), ('33',NULL,'1981-02-23','13','1985-05-26 15:25:24',NULL), ('34',NULL,'1986-02-22','14','1986-08-17 19:39:10',NULL), ('35',NULL,'2014-07-27','15','2011-09-14 00:10:20',NULL), ('36',NULL,'1998-11-12','16','1977-01-17 04:04:45',NULL), ('37',NULL,'2013-12-04','17','2003-12-30 06:45:16',NULL), ('38',NULL,'1972-10-17','18','2004-01-29 10:02:23',NULL), ('39',NULL,'1983-08-03','19','1996-06-08 23:52:22',NULL), ('40',NULL,'1975-04-11','20','2001-12-06 18:52:03',NULL), ('41',NULL,'2003-06-28','1','1979-02-08 19:22:23',NULL), ('42',NULL,'1981-07-28','2','1980-09-15 22:37:52',NULL), ('43',NULL,'1974-01-24','3','2001-06-14 22:58:03',NULL), ('44',NULL,'2007-10-07','4','2005-01-29 11:47:59',NULL), ('45',NULL,'2012-07-10','5','2010-03-21 14:41:24',NULL), ('46',NULL,'1989-07-02','6','2018-04-08 12:10:12',NULL), ('47',NULL,'1994-02-19','7','2010-06-03 13:02:12',NULL), ('48',NULL,'1983-07-10','8','2017-10-11 23:21:50',NULL), ('49',NULL,'2014-07-04','9','2005-03-09 01:24:21',NULL), ('50',NULL,'2013-05-03','10','1997-07-23 04:15:41',NULL), ('51',NULL,'1984-05-27','11','1995-03-19 18:49:07',NULL), ('52',NULL,'1987-04-11','12','1994-07-16 08:23:50',NULL), ('53',NULL,'1981-07-16','13','1987-03-18 02:57:26',NULL), ('54',NULL,'2000-05-05','14','2012-01-01 01:15:17',NULL), ('55',NULL,'1978-05-28','15','1982-12-23 01:49:05',NULL), ('56',NULL,'1989-12-08','16','1971-07-24 18:56:38',NULL), ('57',NULL,'2019-03-12','17','1990-05-08 12:54:53',NULL), ('58',NULL,'1982-07-09','18','1992-12-18 00:58:10',NULL), ('59',NULL,'1989-07-18','19','2010-09-14 23:29:57',NULL), ('60',NULL,'1975-05-26','20','1979-09-09 05:25:34',NULL), ('61',NULL,'2004-04-23','1','2013-04-13 20:18:00',NULL), ('62',NULL,'1982-11-22','2','2002-09-09 21:48:46',NULL), ('63',NULL,'1989-09-08','3','1988-04-20 16:49:29',NULL), ('64',NULL,'2014-05-12','4','2013-01-30 21:36:08',NULL), ('65',NULL,'1983-07-01','5','1985-02-10 14:10:53',NULL), ('66',NULL,'1970-05-28','6','2012-02-23 10:54:57',NULL), ('67',NULL,'2017-12-20','7','1979-05-26 19:35:57',NULL), ('68',NULL,'2000-06-14','8','1989-03-28 16:53:34',NULL), ('69',NULL,'2019-12-06','9','2010-03-03 18:56:59',NULL), ('70',NULL,'1980-10-23','10','2015-03-28 06:32:42',NULL), ('71',NULL,'2016-03-10','11','2001-02-21 23:46:07',NULL), ('72',NULL,'2005-07-23','12','1998-11-20 02:19:30',NULL), ('73',NULL,'2009-10-07','13','1985-12-26 09:43:15',NULL), ('74',NULL,'2001-09-29','14','1975-11-09 10:07:11',NULL), ('75',NULL,'1971-02-20','15','2019-02-18 11:13:52',NULL), ('76',NULL,'1973-09-02','16','2001-06-13 11:34:44',NULL), ('77',NULL,'1996-11-07','17','1975-04-14 11:23:28',NULL), ('78',NULL,'1987-10-25','18','2017-01-02 10:47:59',NULL), ('79',NULL,'2004-12-31','19','2013-11-14 22:04:56',NULL), ('80',NULL,'2000-06-13','20','2010-06-04 01:57:55',NULL), ('81',NULL,'2002-05-01','1','1978-11-23 10:51:14',NULL), ('82',NULL,'2017-03-01','2','2014-12-08 04:37:32',NULL), ('83',NULL,'2019-09-30','3','1997-04-21 11:43:24',NULL), ('84',NULL,'2010-09-24','4','1971-08-29 07:24:32',NULL), ('85',NULL,'2011-01-25','5','1975-06-04 00:37:02',NULL), ('86',NULL,'1983-10-16','6','1998-08-20 23:34:31',NULL), ('87',NULL,'1982-06-25','7','1973-05-21 05:38:29',NULL), ('88',NULL,'1983-06-19','8','1977-06-22 23:21:07',NULL), ('89',NULL,'1995-03-28','9','1979-07-03 23:56:37',NULL), ('90',NULL,'2007-01-09','10','2006-04-03 04:29:28',NULL), ('91',NULL,'1971-03-25','11','1990-03-30 19:07:09',NULL), ('92',NULL,'1977-03-29','12','1995-08-08 07:07:58',NULL), ('93',NULL,'2009-10-18','13','1993-04-23 06:48:09',NULL), ('94',NULL,'1976-08-11','14','1991-03-30 19:22:41',NULL), ('95',NULL,'1993-02-23','15','2008-09-19 19:58:24',NULL), ('96',NULL,'1971-01-01','16','1971-04-03 15:39:38',NULL), ('97',NULL,'2007-05-08','17','2011-05-25 17:38:35',NULL), ('98',NULL,'2008-06-14','18','1983-08-26 01:08:18',NULL), ('99',NULL,'1999-12-19','19','1984-10-15 01:40:45',NULL), ('100',NULL,'2014-03-05','20','1974-06-20 21:56:43',NULL);

DROP TABLE IF EXISTS users; CREATE TABLE users ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, firstname varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, lastname varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Фамиль', email varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL, phone bigint(20) DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY email (email), KEY users_phone_idx (phone), KEY users_firstname_lastname_idx (firstname,lastname) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO users VALUES ('1','Magnus','Hessel','zwehner@example.org','1'), ('2','Deron','Stracke','karson04@example.org','56'), ('3','Bud','Reilly','demmerich@example.net','338139'), ('4','Nona','Mante','brakus.fidel@example.net','4506380723'), ('5','Isidro','Torphy','tamara.tillman@example.net','1'), ('6','Timmothy','Auer','fadel.austyn@example.net','907'), ('7','Rico','Legros','haley.maverick@example.com','1'), ('8','Tyree','Steuber','sawayn.alvena@example.com','960'), ('9','Kelsi','Prohaska','shany85@example.com','1'), ('10','Logan','Hessel','lemke.dulce@example.org','506'), ('11','Jasmin','Pagac','vanessa49@example.net','845867'), ('12','Wilma','Armstrong','leila.reilly@example.org','1'), ('13','Camilla','Kunde','vrolfson@example.com','0'), ('14','Jeanne','Mante','sylvester.sawayn@example.net','1'), ('15','Chelsey','Herman','walker.stan@example.com','776305'), ('16','Vicky','Rempel','wava19@example.net','0'), ('17','Tessie','Hayes','nannie.parker@example.com','394226052'), ('18','Gerard','Emard','beth21@example.net','1'), ('19','Major','Hessel','michelle.macejkovic@example.net','1'), ('20','Federico','Cummings','retha.osinski@example.org','359533'), ('21','Ray','Feest','brenden.lakin@example.org','454022'), ('22','Newton','Quigley','uking@example.org','851'), ('23','Jaclyn','Casper','armani.douglas@example.com','662993'), ('24','Samantha','Greenholt','linwood.dare@example.com','1'), ('25','Abigale','Casper','kassulke.glenna@example.com','0'), ('26','Dan','Rau','zbarrows@example.net','4673125940'), ('27','Kelsie','Deckow','spencer.mia@example.com','664959'), ('28','Electa','Goyette','sophia03@example.org','877'), ('29','Shanny','Stehr','ivy.bayer@example.net','3846429279'), ('30','Felipa','Barrows','dustin.padberg@example.org','8'), ('31','Moses','Johns','barrett26@example.org','911341'), ('32','Milo','Kemmer','dudley01@example.net','0'), ('33','Buddy','Erdman','lavonne06@example.org','954'), ('34','Mary','Yundt','tdaniel@example.org','1'), ('35','Brigitte','Waelchi','ernie93@example.com','1'), ('36','Kassandra','Lakin','vswaniawski@example.net','0'), ('37','Arlie','Wisoky','roselyn68@example.com','78'), ('38','Nettie','Halvorson','lesch.aidan@example.net','503652'), ('39','Brenna','Hodkiewicz','graham.fae@example.net','0'), ('40','Jeromy','Schowalter','joannie77@example.net','926'), ('41','Kaci','Abernathy','omari59@example.net','80'), ('42','Ariel','Weimann','ankunding.aurelie@example.net','0'), ('43','Kirstin','Kovacek','green.walsh@example.org','30'), ('44','Priscilla','Armstrong','fisher.ebony@example.com','0'), ('45','Tracey','Treutel','hadley.runolfsson@example.com','987'), ('46','Bailey','Brakus','julio.romaguera@example.org','753'), ('47','Carey','Von','joaquin.kulas@example.com','0'), ('48','Bette','Hodkiewicz','devante64@example.com','921'), ('49','Cornelius','Collier','drice@example.net','780'), ('50','Brenna','Bogisich','jovany.auer@example.com','8146235115'), ('51','Aileen','Collins','felix.o\'kon@example.org','1'), ('52','Turner','Jacobson','immanuel94@example.net','757790'), ('53','Shaylee','Gislason','estreich@example.org','420183'), ('54','Lee','Walsh','kihn.ottilie@example.org','0'), ('55','Gisselle','Yost','rice.nick@example.org','0'), ('56','Delfina','Langosh','zherzog@example.com','1'), ('57','Deon','Carroll','predovic.oral@example.com','1'), ('58','Yolanda','Boehm','millie.wuckert@example.net','989'), ('59','Shea','Rutherford','jadon98@example.net','640'), ('60','Erika','Mante','althea.kuhn@example.org','1'), ('61','Jewel','Bradtke','madge.reichert@example.com','1'), ('62','Elena','Hand','deron95@example.org','7839087077'), ('63','Don','Borer','brendon.wilkinson@example.net','820860121'), ('64','Bernice','Kris','o\'keefe.emil@example.org','5523119214'), ('65','Devonte','Deckow','alfonso.anderson@example.org','77'), ('66','Shanon','Kihn','ktowne@example.org','36'), ('67','Catharine','Hermann','cleta52@example.org','0'), ('68','Luz','Boyle','casimir.schmitt@example.com','1'), ('69','Belle','Kozey','astoltenberg@example.com','670'), ('70','Taylor','Jacobi','fadel.jimmie@example.net','0'), ('71','Mustafa','Monahan','ada70@example.com','921'), ('72','Orlando','Hintz','paolo12@example.org','1'), ('73','Dawn','Schmidt','delta86@example.org','2488882722'), ('74','Cortez','Waelchi','eliezer19@example.net','1'), ('75','Deshawn','Reichert','mayer.tatum@example.com','0'), ('76','Gerda','Connelly','satterfield.rene@example.net','93281'), ('77','Aiden','Wiegand','yoshiko80@example.org','220'), ('78','Bart','Gaylord','lowell.ullrich@example.net','151'), ('79','Sabryna','Predovic','amari66@example.net','769'), ('80','Yasmeen','Fadel','scot97@example.org','368858'), ('81','Armando','Sipes','rozella.rau@example.org','625630'), ('82','Asia','Veum','nfeil@example.com','793'), ('83','Avis','Stamm','block.garrick@example.org','6014335216'), ('84','Eve','Kemmer','miller.rebeka@example.net','664'), ('85','Antonetta','Osinski','oswaldo90@example.org','893310'), ('86','Neal','Wuckert','taya.wunsch@example.net','169377'), ('87','Hosea','Tillman','welch.amara@example.com','554361'), ('88','Rubye','Bernier','luther.renner@example.com','1'), ('89','Cecelia','Wisoky','bebert@example.org','0'), ('90','Manley','King','erodriguez@example.org','4385417947'), ('91','Alexys','Funk','shaniya06@example.com','0'), ('92','Ressie','Rohan','josie92@example.com','861834'), ('93','Hattie','Kerluke','alysha04@example.com','1'), ('94','Guido','Sporer','alvis.kuhic@example.com','1'), ('95','Emerson','Turner','flebsack@example.com','426715'), ('96','Delpha','Sauer','stamm.jean@example.org','382274'), ('97','Carlie','Harris','kiehn.faye@example.net','624181'), ('98','Joy','Thompson','murl64@example.com','0'), ('99','Brandon','Blick','goyette.geo@example.net','105'), ('100','Salma','Christiansen','phyllis.lemke@example.net','0');

DROP TABLE IF EXISTS users_communities; CREATE TABLE users_communities ( user_id bigint(20) unsigned NOT NULL, community_id bigint(20) unsigned NOT NULL, PRIMARY KEY (user_id,community_id), KEY community_id (community_id), CONSTRAINT users_communities_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT users_communities_ibfk_2 FOREIGN KEY (community_id) REFERENCES communities (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT 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');

Maxim963 commented 4 years ago

DROP database IF EXISTS vk2; CREATE database vk2; use vk2;

DROP TABLE IF EXISTS communities; CREATE TABLE communities ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id), KEY communities_name_idx (name) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO communities VALUES ('30','assumenda'), ('19','aut'), ('82','aut'), ('92','aut'), ('100','aut'), ('56','commodi'), ('16','consectetur'), ('55','consectetur'), ('59','consequatur'), ('57','consequuntur'), ('65','corporis'), ('9','cumque'), ('22','delectus'), ('99','delectus'), ('49','dicta'), ('67','dolor'), ('98','dolor'), ('2','dolorem'), ('88','dolores'), ('13','dolorum'), ('79','ea'), ('4','earum'), ('21','eligendi'), ('48','eos'), ('83','error'), ('8','esse'), ('32','esse'), ('18','est'), ('46','est'), ('89','est'), ('90','est'), ('28','et'), ('35','et'), ('36','et'), ('54','et'), ('58','et'), ('34','eum'), ('39','ex'), ('95','excepturi'), ('20','exercitationem'), ('66','facere'), ('37','fuga'), ('71','fuga'), ('15','hic'), ('80','illo'), ('45','illum'), ('27','in'), ('72','inventore'), ('5','itaque'), ('84','itaque'), ('96','labore'), ('26','laborum'), ('97','laudantium'), ('38','magni'), ('68','magni'), ('11','modi'), ('43','modi'), ('24','molestiae'), ('63','nam'), ('91','nam'), ('76','nemo'), ('1','neque'), ('61','nobis'), ('17','non'), ('70','non'), ('7','officia'), ('51','officiis'), ('3','perferendis'), ('14','perferendis'), ('29','possimus'), ('75','praesentium'), ('53','provident'), ('94','quaerat'), ('47','qui'), ('23','quia'), ('52','quia'), ('44','quo'), ('73','quos'), ('40','reiciendis'), ('86','reprehenderit'), ('12','rerum'), ('33','rerum'), ('78','rerum'), ('41','saepe'), ('87','saepe'), ('50','sequi'), ('6','similique'), ('77','sit'), ('25','soluta'), ('85','totam'), ('64','unde'), ('42','velit'), ('60','velit'), ('62','vitae'), ('74','vitae'), ('81','voluptas'), ('10','voluptatem'), ('31','voluptatem'), ('69','voluptatem'), ('93','voluptatem');

DROP TABLE IF EXISTS friend_requests; CREATE TABLE friend_requests ( initiator_user_id bigint(20) unsigned NOT NULL, target_user_id bigint(20) unsigned NOT NULL, status enum('requested','approved','unfriended','declined') COLLATE utf8_unicode_ci DEFAULT NULL, requested_at datetime DEFAULT current_timestamp(), confirmed_at datetime DEFAULT NULL, PRIMARY KEY (initiator_user_id,target_user_id), KEY initiator_user_id (initiator_user_id), KEY target_user_id (target_user_id), CONSTRAINT friend_requests_ibfk_1 FOREIGN KEY (initiator_user_id) REFERENCES users (id), CONSTRAINT friend_requests_ibfk_2 FOREIGN KEY (target_user_id) REFERENCES users (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO friend_requests VALUES ('1','1','unfriended','2011-05-24 23:31:46','2008-12-17 15:30:37'), ('2','2','unfriended','1986-07-29 21:12:04','1998-06-01 08:19:39'), ('3','3','requested','2017-12-26 21:30:58','1981-03-13 21:49:21'), ('4','4','declined','1970-05-21 13:20:21','2004-09-07 05:59:39'), ('5','5','unfriended','1999-02-16 16:41:28','2018-02-10 22:48:33'), ('6','6','unfriended','1982-10-10 01:56:33','2005-02-08 09:41:21'), ('7','7','unfriended','1987-10-11 14:13:04','1981-06-20 01:19:39'), ('8','8','requested','2011-06-06 06:10:33','1976-05-21 22:35:42'), ('9','9','declined','2008-04-15 18:00:59','2009-06-06 13:49:28'), ('10','10','unfriended','1978-11-04 13:28:16','2010-06-06 02:00:45'), ('11','11','unfriended','1988-09-17 06:53:44','2004-01-10 10:53:02'), ('12','12','requested','2009-03-04 10:41:39','1983-04-07 09:36:32'), ('13','13','requested','1999-05-20 11:20:19','1986-06-13 13:05:45'), ('14','14','declined','1977-08-18 05:55:19','1977-06-24 22:41:15'), ('15','15','declined','2012-03-06 13:57:34','1971-07-19 18:40:52'), ('16','16','approved','1987-07-21 15:44:00','2012-11-18 08:51:55'), ('17','17','declined','1995-10-05 10:03:42','2019-08-09 22:04:17'), ('18','18','requested','1973-02-22 19:25:31','1991-05-15 18:05:03'), ('19','19','declined','1991-02-21 21:54:55','1993-06-21 14:44:02'), ('20','20','declined','1994-08-10 23:03:12','1975-03-09 04:18:40');

DROP TABLE IF EXISTS groups; CREATE TABLE groups ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_unicode_ci NOT NULL, user_id bigint(20) unsigned NOT NULL, theme varchar(255) COLLATE utf8_unicode_ci NOT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY name_group (name), KEY user_id (user_id), CONSTRAINT groups_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO groups VALUES ('1','rem','1','','2017-10-12 06:29:35','1978-12-27 01:07:27'), ('2','nemo','2','','1974-10-20 04:28:41','2013-06-22 18:46:14'), ('3','voluptatem','3','','1984-01-11 02:05:59','1977-08-26 23:08:25'), ('4','inventore','4','','1979-08-12 13:57:31','1974-11-22 20:37:34'), ('5','maxime','5','','2011-10-31 13:45:29','1986-12-19 18:52:58'), ('6','magnam','6','','1979-10-11 21:34:53','2012-07-02 11:47:18'), ('7','iure','7','','1975-11-15 23:07:49','2016-09-23 17:48:22'), ('8','maiores','8','','2003-06-07 23:38:06','1993-04-23 00:18:27'), ('9','quibusdam','9','','1994-11-05 11:32:56','1985-02-08 07:40:49'), ('10','quas','10','','2007-01-31 00:17:41','2016-08-02 18:20:48'), ('11','reprehenderit','11','','1988-10-15 07:31:13','1993-02-12 15:41:10'), ('12','deserunt','12','','2004-07-05 01:01:28','2007-10-18 09:11:12'), ('13','ut','13','','2003-12-01 13:54:16','1991-05-25 20:22:40'), ('14','et','14','','2006-08-29 00:38:18','2019-02-12 10:22:02'), ('15','molestiae','15','','1981-03-24 17:01:31','1991-03-31 20:50:51'), ('16','repellendus','16','','1986-03-03 03:33:55','2002-09-05 05:18:23'), ('17','suscipit','17','','1973-10-31 18:25:43','2001-09-15 01:07:04'), ('18','libero','18','','1987-07-08 23:34:03','2012-08-12 03:45:12'), ('19','aut','19','','1972-05-06 03:20:18','1986-09-29 19:25:04'), ('20','quia','20','','2006-01-26 16:24:58','1991-04-15 15:26:50');

DROP TABLE IF EXISTS likes; CREATE TABLE likes ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, media_id bigint(20) unsigned NOT NULL, created_at datetime DEFAULT current_timestamp(), PRIMARY KEY (id), KEY user_id (user_id), KEY media_id (media_id), CONSTRAINT likes_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT likes_ibfk_2 FOREIGN KEY (media_id) REFERENCES media (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO likes VALUES ('1','1','1','2011-01-09 15:07:36'), ('2','2','2','1981-12-14 22:26:53'), ('3','3','3','1992-07-14 14:51:40'), ('4','4','4','1978-08-16 06:05:50'), ('5','5','5','2007-01-07 17:44:38'), ('6','6','6','2011-07-01 15:11:12'), ('7','7','7','1989-08-06 15:36:41'), ('8','8','8','1977-06-05 16:15:44'), ('9','9','9','2001-06-24 22:15:27'), ('10','10','10','1977-09-14 08:48:29'), ('11','11','11','1991-05-23 20:26:31'), ('12','12','12','1974-12-10 17:23:57'), ('13','13','13','1982-06-27 09:14:40'), ('14','14','14','2009-07-13 18:29:28'), ('15','15','15','1994-02-08 04:01:46'), ('16','16','16','1997-05-10 17:02:51'), ('17','17','17','1973-08-05 11:08:25'), ('18','18','18','1972-01-15 11:18:32'), ('19','19','19','2002-03-08 06:46:28'), ('20','20','20','1991-07-03 22:10:40');

DROP TABLE IF EXISTS media; CREATE TABLE media ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, media_type_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, body text COLLATE utf8_unicode_ci DEFAULT NULL, filename varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, size int(11) DEFAULT NULL, metadata longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY user_id (user_id), KEY media_type_id (media_type_id), CONSTRAINT media_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT media_ibfk_2 FOREIGN KEY (media_type_id) REFERENCES media_types (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO media VALUES ('1','1','1','Officiis temporibus doloribus et iusto. Unde autem aut consequatur nesciunt officia sit. Illo et ut illo enim. Expedita iure aut error dicta eius.','suscipit','8987871',NULL,'2003-05-20 10:58:05','2006-03-12 01:18:30'), ('2','2','2','Accusamus voluptatem illo beatae harum sunt. Aut distinctio qui est repudiandae eaque. Eaque perspiciatis exercitationem voluptatem facere. Quaerat corrupti vero perferendis corrupti.','voluptas','169322',NULL,'1983-06-07 14:40:38','1989-09-07 11:02:24'), ('3','3','3','Provident ut quia dolore et. Facilis occaecati sequi eius atque inventore. Quam qui rerum officiis non et ea ab fugit. Consequuntur vitae asperiores cum ab quis commodi. Est repellendus illo et quae odio eaque.','aut','3',NULL,'1994-09-07 18:41:41','2003-12-30 16:09:07'), ('4','4','4','Voluptatem vel laudantium similique voluptatum id ullam deserunt. Natus accusantium minima excepturi quas culpa corporis. Enim eveniet facere sit sunt illum nam aut. Sunt rerum corporis repudiandae et labore.','rerum','7562239',NULL,'2015-01-27 06:32:16','2019-05-26 00:59:50'), ('5','5','5','Esse voluptatem in occaecati nisi et ut dolor. Aut iste dolor accusamus. Eveniet qui error ducimus nam. Accusamus vel veniam a odit et soluta fugit magni. In beatae amet ut repellat quas et.','nesciunt','1',NULL,'2017-01-01 17:35:55','1975-04-14 22:00:22'), ('6','6','6','Sit autem officiis et ducimus. Voluptas et fugiat eos dolorem molestiae eos asperiores. Quia natus voluptatem debitis id sint. Incidunt fugiat aut sit consectetur iste sint ratione vitae.','ut','352365346',NULL,'1983-03-04 19:54:55','2019-07-11 22:02:21'), ('7','7','7','Omnis ipsum commodi sit consequatur molestias commodi. Quos consequatur sed eos et minus eum similique corrupti. Beatae laboriosam quia doloremque consequuntur.','voluptas','7',NULL,'1994-01-11 03:21:05','1970-12-24 16:54:43'), ('8','8','8','Ipsum enim pariatur ea. Qui aliquam sequi facilis natus rerum. Odit harum quod laborum aliquid.','eaque','9',NULL,'1992-11-14 08:52:29','2017-12-09 01:26:32'), ('9','9','9','Voluptatem enim eos numquam fuga sint aperiam. Earum assumenda quia cum mollitia ea laboriosam. Iste molestiae voluptatum harum.','quasi','0',NULL,'1997-12-08 15:55:01','2001-04-09 22:50:34'), ('10','10','10','Deserunt veritatis voluptates dolor id non velit debitis explicabo. Commodi inventore quo neque ullam. Consequatur quo autem ut. Iste consequatur cum consequatur aut quasi consectetur dignissimos.','nostrum','89606',NULL,'1972-01-22 03:43:29','1988-08-19 23:52:18'), ('11','11','11','Impedit exercitationem corporis consectetur neque. Et error recusandae animi nulla. Libero nisi accusantium ut temporibus consequatur sed cumque.','hic','0',NULL,'2000-03-09 08:47:11','1993-06-27 13:11:07'), ('12','12','12','Inventore minus beatae eum consequatur nisi enim reprehenderit. Magni qui iste ipsum deserunt repellendus numquam ut. Est omnis ipsam culpa iure unde. Doloribus et corporis accusamus blanditiis.','magnam','1',NULL,'1976-09-07 05:44:15','2011-12-06 02:53:14'), ('13','13','13','Dolorum est dolorem qui dolor. Voluptate sit aut facilis magnam doloribus perspiciatis. Aut quos sint saepe et veniam soluta.','sit','74616489',NULL,'1989-10-12 07:26:28','1987-08-12 13:21:11'), ('14','14','14','Veniam voluptatem nesciunt ex ut. Aliquam facere molestiae sit perferendis a. Est inventore sit aut.','saepe','20',NULL,'2002-02-25 22:37:12','1997-10-06 06:28:29'), ('15','15','15','Provident expedita cupiditate quia ad officia. Laboriosam quia in iure rerum dolores accusantium earum. Itaque blanditiis officiis reiciendis tempore nesciunt laudantium animi. Maxime pariatur voluptatem perferendis quibusdam non maiores dolorem.','molestias','76645',NULL,'2011-04-11 05:13:40','2017-10-29 02:19:30'), ('16','16','16','Dicta facilis culpa cupiditate quae praesentium numquam. Odio dicta hic et distinctio ex. Optio eaque non corrupti qui nemo sed rem consequuntur. Sunt minus est quia et. Dolorum consequatur temporibus dolorum earum voluptatum sequi.','sed','1441287',NULL,'2015-10-16 07:39:45','2017-10-08 21:59:04'), ('17','17','17','Voluptate dolores vero quia qui a. Sint in aliquam voluptatem accusantium quae ratione non. Architecto dolore quo vel quia sed.','distinctio','11',NULL,'2009-04-06 06:10:27','1986-09-22 23:51:26'), ('18','18','18','Fuga rerum harum et voluptatibus consequatur facere. Sed occaecati animi eaque sit quia expedita earum. Mollitia deserunt non aliquid placeat quam blanditiis.','est','20510',NULL,'1987-01-31 17:22:06','2017-08-08 08:07:38'), ('19','19','19','Dolores dolorum veritatis officiis. Neque aspernatur ratione reiciendis nobis dolorem voluptatem. Quidem nobis est ipsa. Deleniti perspiciatis at sint architecto in.','consequatur','47984216',NULL,'2002-04-02 16:27:40','1998-11-07 23:49:26'), ('20','20','20','Eum reiciendis recusandae labore quo et unde. Facilis laudantium doloribus ut magnam qui adipisci dolorum accusantium. Nesciunt excepturi numquam officiis sequi. Provident deleniti asperiores neque itaque.','et','266623657',NULL,'2018-08-24 16:05:23','1980-07-21 03:40:28');

DROP TABLE IF EXISTS media_types; CREATE TABLE media_types ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO media_types VALUES ('1','incidunt','1972-01-30 04:40:52','2008-01-27 10:29:55'), ('2','amet','1996-06-06 12:28:54','1984-08-24 17:28:32'), ('3','alias','2014-01-30 16:53:46','1991-02-12 06:10:05'), ('4','dolor','1996-06-30 02:55:55','2015-01-26 12:27:19'), ('5','quos','1975-01-31 06:34:28','1988-08-18 19:56:40'), ('6','exercitationem','1979-06-01 16:21:25','1998-03-21 12:18:23'), ('7','excepturi','2001-02-06 17:47:07','1990-09-09 08:09:56'), ('8','qui','2005-11-18 08:48:50','1972-10-14 10:18:30'), ('9','enim','2019-06-08 08:31:01','1993-09-22 20:29:44'), ('10','et','1975-05-24 07:07:49','2018-03-08 22:57:52'), ('11','voluptas','1997-05-30 21:07:15','2007-11-27 02:42:08'), ('12','consequatur','2013-09-15 17:34:33','1990-07-01 05:15:19'), ('13','nisi','1985-08-19 22:22:57','1984-12-29 03:23:50'), ('14','odit','1999-09-26 23:28:00','2016-09-06 05:53:30'), ('15','itaque','1989-01-06 06:59:52','2009-08-28 15:13:35'), ('16','repudiandae','1998-02-09 00:59:18','2010-08-04 11:14:22'), ('17','excepturi','2008-01-23 22:58:15','1979-05-10 22:51:33'), ('18','quos','1975-06-28 03:21:50','1973-02-01 10:52:05'), ('19','cupiditate','1979-11-09 13:12:54','2002-10-27 14:25:42'), ('20','esse','2007-01-18 07:21:00','1989-11-10 15:17:25');

DROP TABLE IF EXISTS mess_of_gr; CREATE TABLE mess_of_gr ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, from_user_id bigint(20) unsigned NOT NULL, txt text COLLATE utf8_unicode_ci DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), updated_at datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY mess_from_user_id (from_user_id), CONSTRAINT mess_of_gr_ibfk_1 FOREIGN KEY (id) REFERENCES groups (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO mess_of_gr VALUES ('1','1',NULL,'1987-01-01 09:50:31','1975-07-20 15:07:53'), ('2','2',NULL,'2008-04-25 00:14:32','2005-04-16 17:35:27'), ('3','3',NULL,'2018-02-02 12:34:07','1994-07-31 03:20:32'), ('4','4',NULL,'1981-05-22 08:32:46','1984-05-09 15:44:32'), ('5','5',NULL,'1985-02-14 00:07:15','2016-08-30 17:58:34'), ('6','6',NULL,'1996-04-17 02:03:59','1982-05-23 16:08:26'), ('7','7',NULL,'2014-07-03 08:31:04','1982-06-29 00:59:03'), ('8','8',NULL,'1973-07-04 20:18:58','1979-05-09 14:22:01'), ('9','9',NULL,'1996-11-30 13:32:16','1974-01-21 10:59:26'), ('10','10',NULL,'2016-05-15 21:50:37','1987-02-20 20:01:33'), ('11','11',NULL,'1985-05-18 17:25:54','1978-02-01 14:02:53'), ('12','12',NULL,'1977-04-03 09:43:00','1999-11-27 17:09:24'), ('13','13',NULL,'1979-07-30 01:30:33','1982-04-27 07:44:52'), ('14','14',NULL,'1973-05-17 23:18:05','1984-09-16 10:59:17'), ('15','15',NULL,'2010-07-12 12:56:03','1974-11-17 16:14:44'), ('16','16',NULL,'1998-06-30 13:10:24','1989-06-02 09:11:18'), ('17','17',NULL,'1995-04-15 09:07:18','1993-04-02 18:11:30'), ('18','18',NULL,'2014-04-19 17:34:21','2019-01-05 17:04:03'), ('19','19',NULL,'1983-12-21 08:43:38','1976-03-07 06:31:21'), ('20','20',NULL,'1989-05-17 02:18:06','1990-11-01 08:17:05');

DROP TABLE IF EXISTS messages; CREATE TABLE messages ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, from_user_id bigint(20) unsigned NOT NULL, to_user_id bigint(20) unsigned NOT NULL, body text COLLATE utf8_unicode_ci DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), PRIMARY KEY (id), KEY messages_from_user_id (from_user_id), KEY messages_to_user_id (to_user_id), CONSTRAINT messages_ibfk_1 FOREIGN KEY (from_user_id) REFERENCES users (id), CONSTRAINT messages_ibfk_2 FOREIGN KEY (to_user_id) REFERENCES users (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO messages VALUES ('1','1','1','Iste inventore est necessitatibus libero culpa. Omnis molestiae vel quas labore. Aspernatur recusandae assumenda consequatur mollitia exercitationem nesciunt sapiente eveniet.','1981-01-18 01:13:38'), ('2','2','2','Amet quos sit dolore. Perspiciatis natus qui voluptas nam. Dolorum laudantium sed reiciendis sit qui eligendi odit ipsum. Distinctio et aperiam ut ut.','1985-04-05 12:16:26'), ('3','3','3','Aut architecto quis et repellat. Doloribus itaque voluptas sed omnis. Et porro qui itaque rerum eos accusantium dicta.','2000-01-12 19:56:24'), ('4','4','4','Recusandae illum dolorum officia atque repellat laborum. Et autem vero doloremque quidem. Sint voluptatum nisi blanditiis voluptas ut voluptatem. Enim occaecati dolor voluptatem maxime.','2001-11-15 16:45:55'), ('5','5','5','Quis odio ea sequi est expedita est saepe. Quaerat omnis molestias aut tempora. Quo consectetur pariatur dolorum aliquid delectus sapiente ut. Aperiam dignissimos possimus vel culpa ipsam.','1983-03-05 16:16:10'), ('6','6','6','Corporis molestiae et quia vero voluptate alias. Eveniet et iure aut velit vero.','2019-09-15 06:49:31'), ('7','7','7','Eos aut dolor voluptatem sit eos doloremque sed quis. Velit praesentium dolorem ut. Omnis ducimus sed aspernatur et aut possimus.','1996-07-26 20:22:39'), ('8','8','8','Nesciunt alias doloribus voluptas omnis ut accusamus amet dolorem. Repellat a ipsum laborum iste neque. Veniam tempora reprehenderit ea autem.','1990-09-10 17:37:02'), ('9','9','9','Eos maxime nihil sit recusandae sed ut. Eos ut eum necessitatibus repellat enim omnis illum dolores. Dolor aut aut dolores fuga cum delectus. Ut rerum incidunt quam iure ea ullam soluta deserunt.','1985-04-25 13:00:39'), ('10','10','10','Cumque vero id animi assumenda sit quod qui. Deleniti iste nesciunt veritatis qui qui sed est. Cumque omnis voluptatibus magnam sit cupiditate. Maiores quos id asperiores quam asperiores at sequi.','1998-05-04 06:44:02'), ('11','11','11','Ipsa consequatur aliquam qui unde odit reiciendis fuga. Eaque quis placeat ipsam omnis temporibus. Commodi temporibus quis illum beatae. Et iure qui sit impedit explicabo aut soluta.','2010-03-12 12:50:53'), ('12','12','12','Possimus nobis reprehenderit nihil labore ipsa deserunt. Debitis et earum et ex veritatis libero. Voluptas vero maiores eius enim quia qui praesentium. Perferendis aspernatur provident excepturi facere ut fugiat.','1989-01-29 07:49:34'), ('13','13','13','Ea ut nesciunt vel deserunt voluptatibus aliquid dolores quos. Fugiat ea ullam vitae veritatis et molestiae. Voluptas natus odit et voluptas id dolores ratione. Et quo repellat repellat amet.','2002-06-15 06:37:08'), ('14','14','14','Architecto asperiores nisi fugiat culpa quae. Doloribus omnis autem id modi aut ut qui. Et voluptatem id omnis.','2003-05-15 07:23:51'), ('15','15','15','Quidem et voluptas optio omnis quaerat voluptas. Quia delectus molestiae neque in magni. Hic et quisquam quibusdam hic. Impedit est et ex debitis itaque.','2014-01-28 02:29:13'), ('16','16','16','Voluptas est mollitia itaque doloremque accusantium ut. Et molestias et nisi recusandae a vel. Sapiente et doloremque aut voluptas tenetur occaecati aliquam. Dolore reiciendis rerum consequatur expedita. Rerum accusantium totam commodi id alias.','2000-03-11 09:01:31'), ('17','17','17','Et exercitationem provident dolor deserunt deleniti. Omnis fuga sed autem voluptatibus est sunt et animi. Qui est veniam qui velit cupiditate. Laboriosam deleniti deserunt sunt dolor distinctio.','1992-08-04 18:28:53'), ('18','18','18','Esse dolor ratione officiis vel aut nihil molestias et. Iste est consequatur aliquam. Recusandae ad ipsam debitis in.','2019-05-07 19:25:09'), ('19','19','19','Voluptatem est nesciunt molestiae ab. Minima veniam velit commodi fugit. Numquam architecto rerum possimus voluptatum est. Unde minus eos aut nisi commodi ut est.','2004-12-05 16:55:50'), ('20','20','20','Pariatur id veniam non ad. Saepe ad animi aut nisi tempora temporibus. Deleniti quia voluptas voluptatum et.','2002-06-01 00:48:15');

DROP TABLE IF EXISTS music; CREATE TABLE music ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, media_id bigint(20) unsigned NOT NULL, themes varchar(255) COLLATE utf8_unicode_ci NOT NULL, autor varchar(255) COLLATE utf8_unicode_ci NOT NULL, song varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (id), KEY theme_of_music (themes), KEY autor_of_music (autor), KEY name_of_song (song), KEY media_id (media_id), CONSTRAINT music_ibfk_1 FOREIGN KEY (media_id) REFERENCES media (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO music 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','','','');

DROP TABLE IF EXISTS photo_albums; CREATE TABLE photo_albums ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, user_id bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY id (id), KEY user_id (user_id), CONSTRAINT photo_albums_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO photo_albums VALUES ('1','dolore','1'), ('2','et','2'), ('3','voluptates','3'), ('4','excepturi','4'), ('5','quia','5'), ('6','officiis','6'), ('7','qui','7'), ('8','labore','8'), ('9','officiis','9'), ('10','unde','10'), ('11','iste','11'), ('12','tenetur','12'), ('13','necessitatibus','13'), ('14','assumenda','14'), ('15','similique','15'), ('16','rerum','16'), ('17','molestiae','17'), ('18','culpa','18'), ('19','perferendis','19'), ('20','omnis','20');

DROP TABLE IF EXISTS photos; CREATE TABLE photos ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, album_id bigint(20) unsigned NOT NULL, media_id bigint(20) unsigned NOT NULL, PRIMARY KEY (id), KEY album_id (album_id), KEY media_id (media_id), CONSTRAINT photos_ibfk_1 FOREIGN KEY (album_id) REFERENCES photo_albums (id), CONSTRAINT photos_ibfk_2 FOREIGN KEY (media_id) REFERENCES media (id) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT 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');

DROP TABLE IF EXISTS profiles; CREATE TABLE profiles ( user_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, gender char(1) COLLATE utf8_unicode_ci DEFAULT NULL, birthday date DEFAULT NULL, photo_id bigint(20) unsigned DEFAULT NULL, created_at datetime DEFAULT current_timestamp(), hometown varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (user_id), CONSTRAINT profiles_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO profiles VALUES ('1',NULL,'1992-03-04','1','1973-05-31 03:09:00',NULL), ('2',NULL,'1993-06-12','2','1986-02-07 00:33:00',NULL), ('3',NULL,'2002-07-27','3','2018-10-12 06:11:16',NULL), ('4',NULL,'1993-06-04','4','1971-03-27 19:43:46',NULL), ('5',NULL,'2005-05-20','5','1986-04-25 08:48:09',NULL), ('6',NULL,'1983-07-11','6','1994-12-09 07:01:30',NULL), ('7',NULL,'1982-08-19','7','2001-10-21 12:07:11',NULL), ('8',NULL,'2003-11-22','8','1985-05-14 18:48:20',NULL), ('9',NULL,'1985-02-15','9','2011-03-19 05:33:15',NULL), ('10',NULL,'1986-05-04','10','1993-05-30 23:31:38',NULL), ('11',NULL,'2010-12-29','11','1975-06-14 02:34:39',NULL), ('12',NULL,'2019-06-04','12','1973-02-03 05:09:29',NULL), ('13',NULL,'1979-11-19','13','1984-07-18 12:06:29',NULL), ('14',NULL,'2008-11-09','14','1991-11-11 17:04:58',NULL), ('15',NULL,'1994-11-19','15','2017-09-19 23:17:41',NULL), ('16',NULL,'1992-07-14','16','2017-03-15 18:11:22',NULL), ('17',NULL,'2008-03-25','17','2015-11-19 01:16:59',NULL), ('18',NULL,'1989-03-25','18','2000-04-25 19:22:30',NULL), ('19',NULL,'1976-07-14','19','1977-03-01 12:04:18',NULL), ('20',NULL,'2017-02-28','20','1993-08-09 01:57:39',NULL), ('21',NULL,'2004-08-13','1','2005-03-06 13:19:13',NULL), ('22',NULL,'1987-10-17','2','2006-05-27 09:25:02',NULL), ('23',NULL,'1971-05-18','3','1988-07-27 10:58:33',NULL), ('24',NULL,'2005-02-26','4','1971-02-16 12:18:34',NULL), ('25',NULL,'1991-04-09','5','2003-04-09 16:50:17',NULL), ('26',NULL,'1970-08-01','6','1988-06-22 13:28:55',NULL), ('27',NULL,'1999-02-10','7','1972-06-08 23:06:03',NULL), ('28',NULL,'1985-12-05','8','1994-06-28 03:57:34',NULL), ('29',NULL,'1979-10-19','9','2019-02-18 15:21:17',NULL), ('30',NULL,'1994-10-27','10','1981-02-14 23:46:33',NULL), ('31',NULL,'1988-06-06','11','2002-10-09 06:47:23',NULL), ('32',NULL,'1980-11-28','12','1979-04-06 11:40:15',NULL), ('33',NULL,'1981-02-23','13','1985-05-26 15:25:24',NULL), ('34',NULL,'1986-02-22','14','1986-08-17 19:39:10',NULL), ('35',NULL,'2014-07-27','15','2011-09-14 00:10:20',NULL), ('36',NULL,'1998-11-12','16','1977-01-17 04:04:45',NULL), ('37',NULL,'2013-12-04','17','2003-12-30 06:45:16',NULL), ('38',NULL,'1972-10-17','18','2004-01-29 10:02:23',NULL), ('39',NULL,'1983-08-03','19','1996-06-08 23:52:22',NULL), ('40',NULL,'1975-04-11','20','2001-12-06 18:52:03',NULL), ('41',NULL,'2003-06-28','1','1979-02-08 19:22:23',NULL), ('42',NULL,'1981-07-28','2','1980-09-15 22:37:52',NULL), ('43',NULL,'1974-01-24','3','2001-06-14 22:58:03',NULL), ('44',NULL,'2007-10-07','4','2005-01-29 11:47:59',NULL), ('45',NULL,'2012-07-10','5','2010-03-21 14:41:24',NULL), ('46',NULL,'1989-07-02','6','2018-04-08 12:10:12',NULL), ('47',NULL,'1994-02-19','7','2010-06-03 13:02:12',NULL), ('48',NULL,'1983-07-10','8','2017-10-11 23:21:50',NULL), ('49',NULL,'2014-07-04','9','2005-03-09 01:24:21',NULL), ('50',NULL,'2013-05-03','10','1997-07-23 04:15:41',NULL), ('51',NULL,'1984-05-27','11','1995-03-19 18:49:07',NULL), ('52',NULL,'1987-04-11','12','1994-07-16 08:23:50',NULL), ('53',NULL,'1981-07-16','13','1987-03-18 02:57:26',NULL), ('54',NULL,'2000-05-05','14','2012-01-01 01:15:17',NULL), ('55',NULL,'1978-05-28','15','1982-12-23 01:49:05',NULL), ('56',NULL,'1989-12-08','16','1971-07-24 18:56:38',NULL), ('57',NULL,'2019-03-12','17','1990-05-08 12:54:53',NULL), ('58',NULL,'1982-07-09','18','1992-12-18 00:58:10',NULL), ('59',NULL,'1989-07-18','19','2010-09-14 23:29:57',NULL), ('60',NULL,'1975-05-26','20','1979-09-09 05:25:34',NULL), ('61',NULL,'2004-04-23','1','2013-04-13 20:18:00',NULL), ('62',NULL,'1982-11-22','2','2002-09-09 21:48:46',NULL), ('63',NULL,'1989-09-08','3','1988-04-20 16:49:29',NULL), ('64',NULL,'2014-05-12','4','2013-01-30 21:36:08',NULL), ('65',NULL,'1983-07-01','5','1985-02-10 14:10:53',NULL), ('66',NULL,'1970-05-28','6','2012-02-23 10:54:57',NULL), ('67',NULL,'2017-12-20','7','1979-05-26 19:35:57',NULL), ('68',NULL,'2000-06-14','8','1989-03-28 16:53:34',NULL), ('69',NULL,'2019-12-06','9','2010-03-03 18:56:59',NULL), ('70',NULL,'1980-10-23','10','2015-03-28 06:32:42',NULL), ('71',NULL,'2016-03-10','11','2001-02-21 23:46:07',NULL), ('72',NULL,'2005-07-23','12','1998-11-20 02:19:30',NULL), ('73',NULL,'2009-10-07','13','1985-12-26 09:43:15',NULL), ('74',NULL,'2001-09-29','14','1975-11-09 10:07:11',NULL), ('75',NULL,'1971-02-20','15','2019-02-18 11:13:52',NULL), ('76',NULL,'1973-09-02','16','2001-06-13 11:34:44',NULL), ('77',NULL,'1996-11-07','17','1975-04-14 11:23:28',NULL), ('78',NULL,'1987-10-25','18','2017-01-02 10:47:59',NULL), ('79',NULL,'2004-12-31','19','2013-11-14 22:04:56',NULL), ('80',NULL,'2000-06-13','20','2010-06-04 01:57:55',NULL), ('81',NULL,'2002-05-01','1','1978-11-23 10:51:14',NULL), ('82',NULL,'2017-03-01','2','2014-12-08 04:37:32',NULL), ('83',NULL,'2019-09-30','3','1997-04-21 11:43:24',NULL), ('84',NULL,'2010-09-24','4','1971-08-29 07:24:32',NULL), ('85',NULL,'2011-01-25','5','1975-06-04 00:37:02',NULL), ('86',NULL,'1983-10-16','6','1998-08-20 23:34:31',NULL), ('87',NULL,'1982-06-25','7','1973-05-21 05:38:29',NULL), ('88',NULL,'1983-06-19','8','1977-06-22 23:21:07',NULL), ('89',NULL,'1995-03-28','9','1979-07-03 23:56:37',NULL), ('90',NULL,'2007-01-09','10','2006-04-03 04:29:28',NULL), ('91',NULL,'1971-03-25','11','1990-03-30 19:07:09',NULL), ('92',NULL,'1977-03-29','12','1995-08-08 07:07:58',NULL), ('93',NULL,'2009-10-18','13','1993-04-23 06:48:09',NULL), ('94',NULL,'1976-08-11','14','1991-03-30 19:22:41',NULL), ('95',NULL,'1993-02-23','15','2008-09-19 19:58:24',NULL), ('96',NULL,'1971-01-01','16','1971-04-03 15:39:38',NULL), ('97',NULL,'2007-05-08','17','2011-05-25 17:38:35',NULL), ('98',NULL,'2008-06-14','18','1983-08-26 01:08:18',NULL), ('99',NULL,'1999-12-19','19','1984-10-15 01:40:45',NULL), ('100',NULL,'2014-03-05','20','1974-06-20 21:56:43',NULL);

DROP TABLE IF EXISTS users; CREATE TABLE users ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, firstname varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, lastname varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Фамиль', email varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL, phone bigint(20) DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY email (email), KEY users_phone_idx (phone), KEY users_firstname_lastname_idx (firstname,lastname) ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO users VALUES ('1','Magnus','Hessel','zwehner@example.org','1'), ('2','Deron','Stracke','karson04@example.org','56'), ('3','Bud','Reilly','demmerich@example.net','338139'), ('4','Nona','Mante','brakus.fidel@example.net','4506380723'), ('5','Isidro','Torphy','tamara.tillman@example.net','1'), ('6','Timmothy','Auer','fadel.austyn@example.net','907'), ('7','Rico','Legros','haley.maverick@example.com','1'), ('8','Tyree','Steuber','sawayn.alvena@example.com','960'), ('9','Kelsi','Prohaska','shany85@example.com','1'), ('10','Logan','Hessel','lemke.dulce@example.org','506'), ('11','Jasmin','Pagac','vanessa49@example.net','845867'), ('12','Wilma','Armstrong','leila.reilly@example.org','1'), ('13','Camilla','Kunde','vrolfson@example.com','0'), ('14','Jeanne','Mante','sylvester.sawayn@example.net','1'), ('15','Chelsey','Herman','walker.stan@example.com','776305'), ('16','Vicky','Rempel','wava19@example.net','0'), ('17','Tessie','Hayes','nannie.parker@example.com','394226052'), ('18','Gerard','Emard','beth21@example.net','1'), ('19','Major','Hessel','michelle.macejkovic@example.net','1'), ('20','Federico','Cummings','retha.osinski@example.org','359533'), ('21','Ray','Feest','brenden.lakin@example.org','454022'), ('22','Newton','Quigley','uking@example.org','851'), ('23','Jaclyn','Casper','armani.douglas@example.com','662993'), ('24','Samantha','Greenholt','linwood.dare@example.com','1'), ('25','Abigale','Casper','kassulke.glenna@example.com','0'), ('26','Dan','Rau','zbarrows@example.net','4673125940'), ('27','Kelsie','Deckow','spencer.mia@example.com','664959'), ('28','Electa','Goyette','sophia03@example.org','877'), ('29','Shanny','Stehr','ivy.bayer@example.net','3846429279'), ('30','Felipa','Barrows','dustin.padberg@example.org','8'), ('31','Moses','Johns','barrett26@example.org','911341'), ('32','Milo','Kemmer','dudley01@example.net','0'), ('33','Buddy','Erdman','lavonne06@example.org','954'), ('34','Mary','Yundt','tdaniel@example.org','1'), ('35','Brigitte','Waelchi','ernie93@example.com','1'), ('36','Kassandra','Lakin','vswaniawski@example.net','0'), ('37','Arlie','Wisoky','roselyn68@example.com','78'), ('38','Nettie','Halvorson','lesch.aidan@example.net','503652'), ('39','Brenna','Hodkiewicz','graham.fae@example.net','0'), ('40','Jeromy','Schowalter','joannie77@example.net','926'), ('41','Kaci','Abernathy','omari59@example.net','80'), ('42','Ariel','Weimann','ankunding.aurelie@example.net','0'), ('43','Kirstin','Kovacek','green.walsh@example.org','30'), ('44','Priscilla','Armstrong','fisher.ebony@example.com','0'), ('45','Tracey','Treutel','hadley.runolfsson@example.com','987'), ('46','Bailey','Brakus','julio.romaguera@example.org','753'), ('47','Carey','Von','joaquin.kulas@example.com','0'), ('48','Bette','Hodkiewicz','devante64@example.com','921'), ('49','Cornelius','Collier','drice@example.net','780'), ('50','Brenna','Bogisich','jovany.auer@example.com','8146235115'), ('51','Aileen','Collins','felix.o'kon@example.org','1'), ('52','Turner','Jacobson','immanuel94@example.net','757790'), ('53','Shaylee','Gislason','estreich@example.org','420183'), ('54','Lee','Walsh','kihn.ottilie@example.org','0'), ('55','Gisselle','Yost','rice.nick@example.org','0'), ('56','Delfina','Langosh','zherzog@example.com','1'), ('57','Deon','Carroll','predovic.oral@example.com','1'), ('58','Yolanda','Boehm','millie.wuckert@example.net','989'), ('59','Shea','Rutherford','jadon98@example.net','640'), ('60','Erika','Mante','althea.kuhn@example.org','1'), ('61','Jewel','Bradtke','madge.reichert@example.com','1'), ('62','Elena','Hand','deron95@example.org','7839087077'), ('63','Don','Borer','brendon.wilkinson@example.net','820860121'), ('64','Bernice','Kris','o'keefe.emil@example.org','5523119214'), ('65','Devonte','Deckow','alfonso.anderson@example.org','77'), ('66','Shanon','Kihn','ktowne@example.org','36'), ('67','Catharine','Hermann','cleta52@example.org','0'), ('68','Luz','Boyle','casimir.schmitt@example.com','1'), ('69','Belle','Kozey','astoltenberg@example.com','670'), ('70','Taylor','Jacobi','fadel.jimmie@example.net','0'), ('71','Mustafa','Monahan','ada70@example.com','921'), ('72','Orlando','Hintz','paolo12@example.org','1'), ('73','Dawn','Schmidt','delta86@example.org','2488882722'), ('74','Cortez','Waelchi','eliezer19@example.net','1'), ('75','Deshawn','Reichert','mayer.tatum@example.com','0'), ('76','Gerda','Connelly','satterfield.rene@example.net','93281'), ('77','Aiden','Wiegand','yoshiko80@example.org','220'), ('78','Bart','Gaylord','lowell.ullrich@example.net','151'), ('79','Sabryna','Predovic','amari66@example.net','769'), ('80','Yasmeen','Fadel','scot97@example.org','368858'), ('81','Armando','Sipes','rozella.rau@example.org','625630'), ('82','Asia','Veum','nfeil@example.com','793'), ('83','Avis','Stamm','block.garrick@example.org','6014335216'), ('84','Eve','Kemmer','miller.rebeka@example.net','664'), ('85','Antonetta','Osinski','oswaldo90@example.org','893310'), ('86','Neal','Wuckert','taya.wunsch@example.net','169377'), ('87','Hosea','Tillman','welch.amara@example.com','554361'), ('88','Rubye','Bernier','luther.renner@example.com','1'), ('89','Cecelia','Wisoky','bebert@example.org','0'), ('90','Manley','King','erodriguez@example.org','4385417947'), ('91','Alexys','Funk','shaniya06@example.com','0'), ('92','Ressie','Rohan','josie92@example.com','861834'), ('93','Hattie','Kerluke','alysha04@example.com','1'), ('94','Guido','Sporer','alvis.kuhic@example.com','1'), ('95','Emerson','Turner','flebsack@example.com','426715'), ('96','Delpha','Sauer','stamm.jean@example.org','382274'), ('97','Carlie','Harris','kiehn.faye@example.net','624181'), ('98','Joy','Thompson','murl64@example.com','0'), ('99','Brandon','Blick','goyette.geo@example.net','105'), ('100','Salma','Christiansen','phyllis.lemke@example.net','0');

DROP TABLE IF EXISTS users_communities; CREATE TABLE users_communities ( user_id bigint(20) unsigned NOT NULL, community_id bigint(20) unsigned NOT NULL, PRIMARY KEY (user_id,community_id), KEY community_id (community_id), CONSTRAINT users_communities_ibfk_1 FOREIGN KEY (user_id) REFERENCES users (id), CONSTRAINT users_communities_ibfk_2 FOREIGN KEY (community_id) REFERENCES communities (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT 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');

Maxim963 commented 4 years ago

/zd2/ select firstname from vk2.users GROUP by firstname order by firstname; / zd 3.1/ alter table profiles add is_active enum ('1', '0') not null default '0'; /zd 3.2/ update vk2.profiles set is_active = '1' where birthday < date('2002.01.10'); /zd 4/ INSERT INTO vk2.messages (from_user_id, to_user_id, body, created_at) values(5, 2, 'Hi! Who are you?', '2025.01.03 11:12:30'), (2, 5, 'I am your old friend. My name is Max', '2025.01.05 10:30:15'), (3, 9, 'How about go for a walk?', '2022.08.15 12.26.33'), (9, 3, 'No thanks! I do not want.', '2022.08.15 13.01.14'); delete from vk2.messages where created_at > date(now()); select * from vk2.messages where created_at > date(now());