text: -- MySQL dump 10.13  Distrib 8.0.19, for macos10.15 (x86_64)
  --
  -- Host: localhost    Database: TASK_FORCE
  -- ------------------------------------------------------
  -- Server version	8.0.22
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!50503 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `attachment`
  --
  
  DROP TABLE IF EXISTS `attachment`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `attachment` (
    `id` int NOT NULL AUTO_INCREMENT,
    `task_id` int NOT NULL,
    `url` varchar(255) NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `task_id` (`task_id`),
    CONSTRAINT `attachment_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `attachment`
  --
  
  LOCK TABLES `attachment` WRITE;
  /*!40000 ALTER TABLE `attachment` DISABLE KEYS */;
  INSERT INTO `attachment` VALUES (1,1,'http://placehold.it/100x200',NULL),(2,2,'http://placehold.it/100x200',NULL),(3,3,'http://placehold.it/100x200',NULL),(4,4,'http://placehold.it/100x200',NULL),(5,5,'http://placehold.it/100x200',NULL),(6,6,'http://placehold.it/100x200',NULL),(7,7,'http://placehold.it/100x200',NULL),(8,8,'http://placehold.it/100x200',NULL),(9,9,'http://placehold.it/100x200',NULL),(10,10,'http://placehold.it/100x200',NULL),(11,11,'http://placehold.it/100x200',NULL),(12,12,'http://placehold.it/100x200',NULL),(13,13,'http://placehold.it/100x200',NULL),(14,14,'http://placehold.it/100x200',NULL),(15,15,'http://placehold.it/100x200',NULL),(16,16,'http://placehold.it/100x200',NULL),(17,17,'http://placehold.it/100x200',NULL),(18,18,'http://placehold.it/100x200',NULL),(19,19,'http://placehold.it/100x200',NULL),(20,20,'http://placehold.it/100x200',NULL),(21,21,'http://placehold.it/100x200',NULL),(22,22,'http://placehold.it/100x200',NULL),(23,23,'http://placehold.it/100x200',NULL),(24,24,'http://placehold.it/100x200',NULL),(25,25,'http://placehold.it/100x200',NULL),(26,26,'http://placehold.it/100x200',NULL),(27,27,'http://placehold.it/100x200',NULL),(28,28,'http://placehold.it/100x200',NULL),(29,29,'http://placehold.it/100x200',NULL),(30,30,'http://placehold.it/100x200',NULL),(31,31,'http://placehold.it/100x200',NULL),(32,32,'http://placehold.it/100x200',NULL),(33,33,'http://placehold.it/100x200',NULL),(34,34,'http://placehold.it/100x200',NULL),(35,35,'http://placehold.it/100x200',NULL),(36,36,'http://placehold.it/100x200',NULL),(37,37,'http://placehold.it/100x200',NULL),(38,38,'http://placehold.it/100x200',NULL),(39,39,'http://placehold.it/100x200',NULL),(40,40,'http://placehold.it/100x200',NULL),(41,41,'http://placehold.it/100x200',NULL),(42,42,'http://placehold.it/100x200',NULL),(43,43,'http://placehold.it/100x200',NULL),(44,44,'http://placehold.it/100x200',NULL),(45,45,'http://placehold.it/100x200',NULL),(46,46,'http://placehold.it/100x200',NULL),(47,47,'http://placehold.it/100x200',NULL),(48,48,'http://placehold.it/100x200',NULL),(49,49,'http://placehold.it/100x200',NULL),(50,50,'http://placehold.it/100x200',NULL),(51,51,'http://placehold.it/100x200',NULL),(52,52,'http://placehold.it/100x200',NULL),(53,53,'http://placehold.it/100x200',NULL),(54,54,'http://placehold.it/100x200',NULL),(55,55,'http://placehold.it/100x200',NULL),(56,56,'http://placehold.it/100x200',NULL),(57,57,'http://placehold.it/100x200',NULL),(58,58,'http://placehold.it/100x200',NULL),(59,59,'http://placehold.it/100x200',NULL),(60,60,'http://placehold.it/100x200',NULL),(61,61,'http://placehold.it/100x200',NULL),(62,62,'http://placehold.it/100x200',NULL),(63,63,'http://placehold.it/100x200',NULL),(64,64,'http://placehold.it/100x200',NULL),(65,65,'http://placehold.it/100x200',NULL),(66,66,'http://placehold.it/100x200',NULL),(67,67,'http://placehold.it/100x200',NULL),(68,68,'http://placehold.it/100x200',NULL),(69,69,'http://placehold.it/100x200',NULL),(70,70,'http://placehold.it/100x200',NULL),(71,71,'http://placehold.it/100x200',NULL),(72,72,'http://placehold.it/100x200',NULL),(73,73,'http://placehold.it/100x200',NULL),(74,74,'http://placehold.it/100x200',NULL),(75,75,'http://placehold.it/100x200',NULL),(76,76,'http://placehold.it/100x200',NULL),(77,77,'http://placehold.it/100x200',NULL),(78,78,'http://placehold.it/100x200',NULL),(79,79,'http://placehold.it/100x200',NULL),(80,80,'http://placehold.it/100x200',NULL),(81,81,'http://placehold.it/100x200',NULL),(82,82,'http://placehold.it/100x200',NULL),(83,83,'http://placehold.it/100x200',NULL),(84,84,'http://placehold.it/100x200',NULL),(85,85,'http://placehold.it/100x200',NULL),(86,86,'http://placehold.it/100x200',NULL),(87,87,'http://placehold.it/100x200',NULL),(88,88,'http://placehold.it/100x200',NULL),(89,89,'http://placehold.it/100x200',NULL),(90,90,'http://placehold.it/100x200',NULL),(91,91,'http://placehold.it/100x200',NULL),(92,92,'http://placehold.it/100x200',NULL),(93,93,'http://placehold.it/100x200',NULL),(94,94,'http://placehold.it/100x200',NULL),(95,95,'http://placehold.it/100x200',NULL),(96,96,'http://placehold.it/100x200',NULL),(97,97,'http://placehold.it/100x200',NULL),(98,98,'http://placehold.it/100x200',NULL),(99,99,'http://placehold.it/100x200',NULL),(100,100,'http://placehold.it/100x200',NULL);
  /*!40000 ALTER TABLE `attachment` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `categories`
  --
  
  DROP TABLE IF EXISTS `categories`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `categories` (
    `id` int NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `icon` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `categories`
  --
  
  LOCK TABLES `categories` WRITE;
  /*!40000 ALTER TABLE `categories` DISABLE KEYS */;
  INSERT INTO `categories` VALUES (1,'Переводы','translation'),(2,'Уборка','clean'),(3,'Переезды','cargo'),(4,'Компьютерная помощь','neo'),(5,'Ремонт квартирный','flat'),(6,'Ремонт техники','repair'),(7,'Красота','beauty'),(8,'Фото','photo');
  /*!40000 ALTER TABLE `categories` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `cities`
  --
  
  DROP TABLE IF EXISTS `cities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `cities` (
    `id` int NOT NULL AUTO_INCREMENT,
    `city` varchar(255) NOT NULL,
    `latitude` varchar(255) DEFAULT NULL,
    `longitude` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1110 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `cities`
  --
  
  LOCK TABLES `cities` WRITE;
  /*!40000 ALTER TABLE `cities` DISABLE KEYS */;
  INSERT INTO `cities` VALUES (1,'Абаза','90.0885929','52.6517296'),(2,'Абакан','91.4437792','53.7223661'),(3,'Абдулино','53.6473115','53.6778096'),(4,'Абинск','38.1618437','44.8679931'),(5,'Агидель','53.9221149','55.89976'),(6,'Агрыз','52.994257','56.5232645'),(7,'Адыгейск','39.190172','44.8783715'),(8,'Азнакаево','53.0745505','54.8599054'),(9,'Азов','39.4232597','47.1120631'),(10,'Ак-Довурак','90.5984511','51.1785658'),(11,'Аксай','39.8755485','47.2676075'),(12,'Алагир','44.2198622','43.0416151'),(13,'Алапаевск','61.6693934','57.8475542'),(14,'Алатырь','46.5721423','54.8398179'),(15,'Алдан','125.3816689','58.6094885'),(16,'Алейск','82.7794145','52.4920914'),(17,'Александров','38.711035','56.3919652'),(18,'Александровск','57.5764851','59.1613773'),(19,'Александровск-Сахалинский','142.1579322','50.8973664'),(20,'Алексеевка','38.6881776','50.6299932'),(21,'Алексин','37.047891','54.5083788'),(22,'Алзамай','98.6644106','55.5550493'),(23,'Алушта','34.4100387','44.6764419'),(24,'Альметьевск','52.2970654','54.9013662'),(25,'Амурск','136.8791135','50.2345017'),(26,'Анадырь','177.5015752','64.7314347'),(27,'Анапа','37.3163142','44.8950777'),(28,'Ангарск','103.8885385','52.5448102'),(29,'Андреаполь','32.2621196','56.6507072'),(30,'Анжеро-Судженск','86.0202207','56.0787179'),(31,'Анива','142.5265052','46.7132526'),(32,'Апатиты','33.4067218','67.5678295'),(33,'Апрелевка','37.0651105','55.5276336'),(34,'Апшеронск','39.7300092','44.4585239'),(35,'Арамиль','60.8343825','56.6945341'),(36,'Аргун','45.8724383','43.2918071'),(37,'Ардатов','46.2412736','54.8465693'),(38,'Ардон','44.2955701','43.1756719'),(39,'Арзамас','43.8407855','55.3947544'),(40,'Аркадак','43.4997558','51.9387813'),(41,'Армавир','41.132392','45.0010338'),(42,'Армянск','33.6910325','46.1059247'),(43,'Арсеньев','133.269622','44.16208'),(44,'Арск','49.8770441','56.0913636'),(45,'Артем','132.1596594','43.350053'),(46,'Артемовск','93.4356543','54.3472901'),(47,'Артемовский','61.8946599','57.3384162'),(48,'Архангельск','40.5170083','64.5392985'),(49,'Асбест','61.4581071','57.0052428'),(50,'Асино','86.1765724','56.9908444'),(51,'Астрахань','48.0559979','46.3655808'),(52,'Аткарск','45.0003199','51.8736331'),(53,'Ахтубинск','46.1906741','48.2753078'),(54,'Ачинск','90.47949','56.2538662'),(55,'Аша','57.2783704','54.9907105'),(56,'Бабаево','35.9378318','59.389309'),(57,'Бабушкин','105.8673633','51.7113066'),(58,'Бавлы','53.2457946','54.4063588'),(59,'Багратионовск','20.6418545','54.3866976'),(60,'Байкальск','104.1485752','51.5231282'),(61,'Баймак','58.3111995','52.5912632'),(62,'Бакал','58.8051085','54.9406759'),(63,'Баксан','43.5345627','43.6820621'),(64,'Балабаново','36.6567255','55.1773652'),(65,'Балаково','47.7828146','52.0222694'),(66,'Балахна','43.5758953','56.4949932'),(67,'Балашиха','37.9381413','55.7963352'),(68,'Балашов','43.1839828','51.5389502'),(69,'Балей','116.6380088','51.5822063'),(70,'Балтийск','19.9141911','54.6514128'),(71,'Барабинск','78.3465012','55.3515917'),(72,'Барнаул','83.7798362','53.3481145'),(73,'Барыш','47.1180805','53.6534563'),(74,'Батайск','39.7508382','47.138321'),(75,'Бахчисарай','33.8750341','44.751388'),(76,'Бежецк','36.6903445','57.7861144'),(77,'Белая Калитва','40.8033169','48.176948'),(78,'Белая Холуница','50.8461002','58.8415212'),(79,'Белгород','36.5858236','50.5977351'),(80,'Белебей','54.1111878','54.1033832'),(81,'Белев','36.1383153','53.8113348'),(82,'Белинский','43.4185003','52.9641169'),(83,'Белово','86.3036438','54.4221442'),(84,'Белогорск','128.4738742','50.9212235'),(85,'Белогорск','34.5998775','45.0571581'),(86,'Белозерск','37.7891123','60.0307914'),(87,'Белокуриха','84.9840343','51.9960534'),(88,'Беломорск','34.7799717','64.5378468'),(89,'Белорецк','58.4099562','53.9675927'),(90,'Белореченск','39.8780457','44.7652733'),(91,'Белоусово','36.6777239','55.0957679'),(92,'Белоярский','66.6772357','63.712181'),(93,'Белый','32.9388976','55.8337663'),(94,'Бердск','83.1072212','54.7582375'),(95,'Березники','56.8040725','59.4079898'),(96,'Березовский','86.2744636','55.6692853'),(97,'Березовский','60.8180256','56.9096284'),(98,'Беслан','44.5338746','43.1937634'),(99,'Бийск','85.2138852','52.5393683'),(100,'Бикин','134.2551046','46.8186244'),(101,'Билибино','166.4388451','68.0585533'),(102,'Биробиджан','132.9217594','48.7945975'),(103,'Бирск','55.5582335','55.4157107'),(104,'Бирюсинск','97.8203624','55.9608611'),(105,'Бирюч','38.4006203','50.6483899'),(106,'Благовещенск','127.5272186','50.2905935'),(107,'Благовещенск','55.955309','55.0499592'),(108,'Благодарный','43.4307042','45.0990834'),(109,'Бобров','40.0320014','51.0902048'),(110,'Богданович','62.0463692','56.7764419'),(111,'Богородицк','38.1225308','53.7700516'),(112,'Богородск','43.513678','56.1019905'),(113,'Боготол','89.5300182','56.209881'),(114,'Богучар','40.5592467','49.9352997'),(115,'Бодайбо','114.1867148','57.8468822'),(116,'Бокситогорск','33.8456521','59.4735032'),(117,'Болгар','49.0302977','54.9748862'),(118,'Бологое','34.0536895','57.885655'),(119,'Болотное','84.3906599','55.6693773'),(120,'Болохово','37.826844','54.0820644'),(121,'Болхов','36.0076969','53.4440204'),(122,'Большой Камень','132.3480354','43.1112737'),(123,'Бор','44.0644851','56.3565179'),(124,'Борзя','116.5235682','50.3875437'),(125,'Борисоглебск','42.100947','51.3654619'),(126,'Боровичи','33.9176761','58.3839866'),(127,'Боровск','36.4927446','55.2130965'),(128,'Бородино','94.9021138','55.9054308'),(129,'Братск','101.6339892','56.1513951'),(130,'Бронницы','38.2640794','55.4255534'),(131,'Брянск','34.3652716','53.2420071'),(132,'Бугульма','52.7895286','54.5363428'),(133,'Бугуруслан','52.4326166','53.6522636'),(134,'Буденновск','44.1650859','44.7814437'),(135,'Бузулук','52.2623757','52.7881434'),(136,'Буинск','48.2900576','54.9641106'),(137,'Буй','41.5306746','58.473445'),(138,'Буйнакск','47.1164452','42.8213799'),(139,'Бутурлиновка','40.5977541','50.8313227'),(140,'Валдай','33.2369492','57.9822906'),(141,'Валуйки','38.0998765','50.2112799'),(142,'Велиж','31.1857376','55.6058845'),(143,'Великие Луки','30.550757','56.3321847'),(144,'Великий Новгород','31.2755051','58.5214003'),(145,'Великий Устюг','46.3053893','60.7603243'),(146,'Вельск','42.1032858','61.0660057'),(147,'Венев','38.2642325','54.3542431'),(148,'Верещагино','54.6580948','58.0797908'),(149,'Верея','36.1563083','55.3674668'),(150,'Верхнеуральск','59.2169071','53.8760587'),(151,'Верхний Тагил','59.9516521','57.3762768'),(152,'Верхний Уфалей','60.231963','56.0487252'),(153,'Верхняя Пышма','60.564885','56.9757833'),(154,'Верхняя Салда','60.5560397','58.0466039'),(155,'Верхняя Тура','59.8266854','58.3643839'),(156,'Верхотурье','60.8104543','58.8621145'),(157,'Верхоянск','133.3907829','67.5500865'),(158,'Весьегонск','37.2568605','58.6584004'),(159,'Ветлуга','45.7762692','57.8558395'),(160,'Видное','37.7062062','55.5518323'),(161,'Вилюйск','121.6272754','63.7517314'),(162,'Вилючинск','158.4057276','52.930428'),(163,'Вихоревка','101.170332','56.1207708'),(164,'Вичуга','41.9131192','57.2044545'),(165,'Владивосток','131.882348','43.1163807'),(166,'Владикавказ','44.6819383','43.0205039'),(167,'Владимир','40.4082995','56.1281561'),(168,'Волгоград','44.5170207','48.7072005'),(169,'Волгодонск','42.1984531','47.5165181'),(170,'Волгореченск','41.1593076','57.4423712'),(171,'Волжск','48.371553','55.8622987'),(172,'Волжский','44.7462417','48.7978483'),(173,'Вологда','39.8356461','59.2484186'),(174,'Володарск','43.1597623','56.2168974'),(175,'Волоколамск','35.9585027','56.0358121'),(176,'Волосово','29.492277','59.4445107'),(177,'Волхов','32.35212','59.9006057'),(178,'Волчанск','60.0797964','59.9350515'),(179,'Вольск','47.3873504','52.0459932'),(180,'Воркута','64.0611045','67.4973484'),(181,'Воронеж','39.1968284','51.6592378'),(182,'Ворсма','43.2719879','55.9900425'),(183,'Воскресенск','38.7026949','55.3071305'),(184,'Воткинск','53.9874635','57.0517641'),(185,'Всеволожск','30.6455834','60.0190094'),(186,'Вуктыл','57.3165207','63.8615209'),(187,'Выборг','28.7328813','60.7130748'),(188,'Выкса','42.1679169','55.3207103'),(189,'Высоковск','36.5251316','56.336141'),(190,'Высоцк','28.5709914','60.6296511'),(191,'Вытегра','36.4495835','61.0064157'),(192,'Вышний Волочек','34.5402931','57.5683326'),(193,'Вяземский','134.7553701','47.5354416'),(194,'Вязники','42.2687311','56.2976528'),(195,'Вязьма','34.2951196','55.2115563'),(196,'Вятские Поляны','51.0614666','56.2286058'),(197,'Гаврилов Посад','40.1228288','56.5585967'),(198,'Гаврилов-Ям','39.8545157','57.3091552'),(199,'Гагарин','34.9949049','55.5526532'),(200,'Гаджиево','33.3152445','69.2490009'),(201,'Гай','58.4436189','51.4649138'),(202,'Галич','42.3654563','58.3826861'),(203,'Гатчина','30.1281859','59.5650861'),(204,'Гвардейск','21.0500584','54.6588981'),(205,'Гдов','27.8263328','58.7432585'),(206,'Геленджик','38.0790184','44.5631053'),(207,'Георгиевск','43.4739718','44.1486421'),(208,'Глазов','52.6634998','58.1359111'),(209,'Голицыно','36.9855559','55.6189762'),(210,'Горбатов','43.0626829','56.1307901'),(211,'Горно-Алтайск','85.9602957','51.9582681'),(212,'Горнозаводск','58.3230329','58.3743406'),(213,'Горняк','81.4643059','50.9979032'),(214,'Городец','43.4722975','56.6447459'),(215,'Городище','45.702731','53.2727888'),(216,'Городовиковск','41.9354039','46.0875351'),(217,'Гороховец','42.692517','56.2021059'),(218,'Горячий Ключ','39.1356421','44.6343251'),(219,'Грайворон','35.6662957','50.4862699'),(220,'Гремячинск','57.8520073','58.5625603'),(221,'Грозный','45.6981102','43.3179243'),(222,'Грязи','39.9331785','52.4873931'),(223,'Грязовец','40.248477','58.8757657'),(224,'Губаха','57.5544441','58.837024'),(225,'Губкин','37.5347608','51.2836362'),(226,'Губкинский','76.4714559','64.4456575'),(227,'Гудермес','46.1036052','43.3519164'),(228,'Гуково','39.9484635','48.0449422'),(229,'Гулькевичи','40.6918484','45.3605769'),(230,'Гурьевск','20.6039109','54.7705368'),(231,'Гурьевск','85.947723','54.2860005'),(232,'Гусев','22.1944114','54.5915477'),(233,'Гусиноозерск','106.5230732','51.2865751'),(234,'Гусь-Хрустальный','40.6578769','55.6198065'),(235,'Давлеканово','55.0313419','54.2227617'),(236,'Дагестанские Огни','48.1939983','42.1151021'),(237,'Далматово','62.9387378','56.2621393'),(238,'Дальнегорск','135.5662536','44.5539909'),(239,'Дальнереченск','133.7316542','45.9307882'),(240,'Данилов','40.1796765','58.1859542'),(241,'Данков','39.1457625','53.25769'),(242,'Дегтярск','60.0792227','56.7048199'),(243,'Дедовск','37.1244724','55.8704718'),(244,'Демидов','31.5062078','55.2682611'),(245,'Дербент','48.2908653','42.058935'),(246,'Десногорск','33.2834063','54.1465117'),(247,'Джанкой','34.388332','45.7092436'),(248,'Дзержинск','43.4599363','56.2376438'),(249,'Дзержинский','37.8440691','55.6241079'),(250,'Дивногорск','92.380085','55.9577868'),(251,'Дигора','44.1551132','43.1567386'),(252,'Димитровград','49.6261645','54.2168446'),(253,'Дмитриев','35.0739504','52.1269291'),(254,'Дмитров','37.5267184','56.3477176'),(255,'Дмитровск','35.141535','52.5053481'),(256,'Дно','29.9629569','57.8269802'),(257,'Добрянка','56.4131294','58.4696353'),(258,'Долгопрудный','37.5100527','55.9384901'),(259,'Долинск','142.7945985','47.3255903'),(260,'Домодедово','37.7666263','55.4363901'),(261,'Донецк','39.9460654','48.3350928'),(262,'Донской','38.3372104','53.9679582'),(263,'Дорогобуж','33.3024596','54.9137794'),(264,'Дрезна','38.8499228','55.7442991'),(265,'Дубна','37.1757163','56.7417949'),(266,'Дубовка','44.8270813','49.0555342'),(267,'Дудинка','86.1908135','69.4031339'),(268,'Духовщина','32.4012351','55.1950509'),(269,'Дюртюли','54.8524875','55.4848047'),(270,'Дятьково','34.355092','53.5958283'),(271,'Евпатория','33.3667685','45.1904322'),(272,'Егорьевск','39.0358236','55.3831326'),(273,'Ейск','38.2764915','46.7114611'),(274,'Екатеринбург','60.6054887','56.8386326'),(275,'Елабуга','52.0544438','55.7566727'),(276,'Елец','38.5289121','52.6151738'),(277,'Елизово','158.3882833','53.1829573'),(278,'Ельня','33.1749566','54.5836832'),(279,'Еманжелинск','61.3243985','54.7554084'),(280,'Емва','50.8731889','62.5965314'),(281,'Енисейск','92.165237','58.4485234'),(282,'Ермолино','36.5951966','55.1972714'),(283,'Ершов','48.2763313','51.3508407'),(284,'Ессентуки','42.8589078','44.044461'),(285,'Ефремов','38.0922412','53.1465725'),(286,'Железноводск','43.0306475','44.1320689'),(287,'Железногорск','93.532167','56.2529346'),(288,'Железногорск','35.3516834','52.3378753'),(289,'Железногорск-Илимский','104.1141747','56.5847382'),(290,'Жердевка','41.4617407','51.8421783'),(291,'Жигулевск','49.494529','53.4011545'),(292,'Жиздра','34.7386719','53.7522384'),(293,'Жирновск','44.7857694','50.9767561'),(294,'Жуков','36.7393279','55.0301386'),(295,'Жуковка','33.7302166','53.5341219'),(296,'Жуковский','38.1224185','55.5998408'),(297,'Завитинск','129.4392897','50.1064678'),(298,'Заводоуковск','66.5505094','56.5012193'),(299,'Заволжск','42.1374455','57.4916546'),(300,'Заволжье','43.3871565','56.6404237'),(301,'Задонск','38.9205772','52.4004611'),(302,'Заинск','52.0063634','55.2988854'),(303,'Закаменск','103.2867452','50.3726774'),(304,'Заозерный','94.7091037','55.9617268'),(305,'Заозерск','32.4502225','69.4003895'),(306,'Западная Двина','32.0805972','56.2568002'),(307,'Заполярный','30.7985332','69.413232'),(308,'Зарайск','38.8851485','54.7625993'),(309,'Заречный','45.1691502','53.1961009'),(310,'Заречный','61.3380592','56.8103345'),(311,'Заринск','84.9314703','53.7063495'),(312,'Звенигово','48.0170276','55.9739374'),(313,'Звенигород','36.8552843','55.7296168'),(314,'Зверево','40.1264948','48.043451'),(315,'Зеленогорск','94.5888736','56.1133001'),(316,'Зеленоградск','20.4753274','54.9600226'),(317,'Зеленодольск','48.5010882','55.8466751'),(318,'Зеленокумск','43.8841326','44.403359'),(319,'Зерноград','40.312765','46.8494991'),(320,'Зея','127.2658079','53.7339151'),(321,'Зима','102.0492066','53.9206865'),(322,'Златоуст','59.6726264','55.1715695'),(323,'Злынка','31.7360386','52.4265906'),(324,'Змеиногорск','82.1872476','51.1580235'),(325,'Знаменск','45.7367908','48.5865618'),(326,'Зубцов','34.5825504','56.1760709'),(327,'Зуевка','51.1330787','58.4031674'),(328,'Ивангород','28.2230504','59.3765845'),(329,'Иваново','40.9728231','56.9994677'),(330,'Ивантеевка','37.9208755','55.9742303'),(331,'Ивдель','60.4244661','60.6944353'),(332,'Игарка','86.5814287','67.4667947'),(333,'Ижевск','53.2113961','56.8527444'),(334,'Избербаш','47.871002','42.565098'),(335,'Изобильный','41.7086448','45.3684342'),(336,'Иланский','96.0672656','56.2374163'),(337,'Инза','46.3532786','53.8550467'),(338,'Инкерман','33.6100739','44.6135153'),(339,'Иннополис','48.7446161','55.7521544'),(340,'Инсар','44.3696866','53.8770384'),(341,'Инта','60.1154612','66.0368196'),(342,'Ипатово','42.8969695','45.7181897'),(343,'Ирбит','63.0576639','57.6838406'),(344,'Иркутск','104.280655','52.2863513'),(345,'Исилькуль','71.2816107','54.9096156'),(346,'Искитим','83.2951444','54.6266869'),(347,'Истра','36.8600854','55.9061087'),(348,'Ишим','69.4643292','56.0952037'),(349,'Ишимбай','56.043874','53.4546314'),(350,'Йошкар-Ола','47.8998445','56.6343763'),(351,'Кадников','40.3440473','59.5037947'),(352,'Казань','49.1115312','55.7943877'),(353,'Калач','41.0162858','50.4241213'),(354,'Калачинск','74.5655075','55.0598547'),(355,'Калач-на-Дону','43.5306866','48.6887569'),(356,'Калининград','20.5072458','54.7073218'),(357,'Калининск','44.4710177','51.4992917'),(358,'Калтан','87.2772143','53.5210461'),(359,'Калуга','36.2515933','54.5060439'),(360,'Калязин','37.7821253','57.2579471'),(361,'Камбарка','54.1934153','56.2659745'),(362,'Каменка','44.0468501','53.1855474'),(363,'Каменногорск','29.1308061','60.9508768'),(364,'Каменск-Уральский','61.9189837','56.4149095'),(365,'Каменск-Шахтинский','40.268874','48.3204412'),(366,'Камень-на-Оби','81.3545173','53.7915454'),(367,'Камешково','40.9955682','56.3488712'),(368,'Камызяк','48.0732724','46.1105429'),(369,'Камышин','45.3843816','50.0651261'),(370,'Камышлов','62.7120432','56.8465469'),(371,'Канаш','47.4917734','55.5069543'),(372,'Кандалакша','32.4142303','67.1567298'),(373,'Канск','95.7051246','56.2049776'),(374,'Карабаново','38.7034267','56.3133447'),(375,'Карабаш','60.2358959','55.4852076'),(376,'Карабулак','44.9094521','43.3054762'),(377,'Карасук','78.042457','53.7343772'),(378,'Карачаевск','41.9143726','43.773197'),(379,'Карачев','34.9887859','53.1297194'),(380,'Каргат','80.2831324','55.1943829'),(381,'Каргополь','38.9636415','61.5008762'),(382,'Карпинск','60.0011798','59.7664444'),(383,'Карталы','60.647712','53.0536101'),(384,'Касимов','41.3912912','54.9373788'),(385,'Касли','60.7422529','55.8868045'),(386,'Каспийск','47.6366674','42.8916599'),(387,'Катав-Ивановск','58.1983706','54.7520187'),(388,'Катайск','62.5800669','56.2908118'),(389,'Качканар','59.4840198','58.7051759'),(390,'Кашин','37.6118674','57.3600486'),(391,'Кашира','38.1903818','54.8534263'),(392,'Кедровый','79.5678914','57.5618465'),(393,'Кемерово','86.0467864','55.3909721'),(394,'Кемь','34.5948547','64.9543657'),(395,'Керчь','36.4674285','45.3561128'),(396,'Кизел','57.6471214','59.0511764'),(397,'Кизилюрт','46.8729311','43.2039094'),(398,'Кизляр','46.7232828','43.8483915'),(399,'Кимовск','38.5380267','53.9698378'),(400,'Кимры','37.3557064','56.873359'),(401,'Кингисепп','28.6112981','59.3739407'),(402,'Кинель','50.6343039','53.2209985'),(403,'Кинешма','42.1690039','57.4425441'),(404,'Киреевск','37.9220791','53.9321173'),(405,'Киренск','108.1107766','57.7757126'),(406,'Киржач','38.8635035','56.1485263'),(407,'Кириллов','38.3749854','59.8590353'),(408,'Кириши','32.0625536','59.4742626'),(409,'Киров','34.3077508','54.0790823'),(410,'Киров','49.6679219','58.6035313'),(411,'Кировград','60.0623588','57.4298451'),(412,'Кирово-Чепецк','50.0317608','58.5559921'),(413,'Кировск','30.9815205','59.875371'),(414,'Кировск','33.6637196','67.6150979'),(415,'Кирс','52.2415895','59.3400586'),(416,'Кирсанов','42.7284872','52.650594'),(417,'Киселевск','86.6367387','54.0060382'),(418,'Кисловодск','42.7167187','43.905235'),(419,'Клин','36.7240912','56.3424886'),(420,'Клинцы','32.2339161','52.7529052'),(421,'Княгинино','45.0322947','55.8205157'),(422,'Ковдор','30.4742082','67.5661466'),(423,'Ковров','41.3169568','56.3553895'),(424,'Ковылкино','43.9191229','54.0391464'),(425,'Когалым','74.4828687','62.2638914'),(426,'Кодинск','99.1797563','58.6033961'),(427,'Козельск','35.7807136','54.0348417'),(428,'Козловка','48.2579372','55.8406526'),(429,'Козьмодемьянск','46.5466282','56.333346'),(430,'Кола','33.0262014','68.8785079'),(431,'Кологрив','44.3185323','58.826988'),(432,'Коломна','38.7531734','55.1027797'),(433,'Колпашево','82.9027528','58.3114716'),(434,'Кольчугино','39.391201','56.3327616'),(435,'Коммунар','30.393466','59.6215929'),(436,'Комсомольск','40.3775952','57.0273907'),(437,'Комсомольск-на-Амуре','137.0079286','50.550011'),(438,'Конаково','36.8011699','56.7275533'),(439,'Кондопога','34.2681778','62.2059866'),(440,'Кондрово','35.9276099','54.796051'),(441,'Константиновск','41.0967362','47.5773456'),(442,'Копейск','61.6180809','55.1167545'),(443,'Кораблино','40.0227867','53.9245422'),(444,'Кореновск','39.4590178','45.4640868'),(445,'Коркино','61.4034541','54.8903023'),(446,'Королев','37.8545224','55.9162558'),(447,'Короча','37.1896543','50.8130123'),(448,'Корсаков','142.7994094','46.6323995'),(449,'Коряжма','47.1002315','61.2885993'),(450,'Костерево','39.624822','55.9336424'),(451,'Костомукша','30.6015567','64.5889946'),(452,'Кострома','40.9907282','57.8029445'),(453,'Котельники','37.8632865','55.659898'),(454,'Котельниково','43.1331198','47.6310808'),(455,'Котельнич','48.3474288','58.3035238'),(456,'Котлас','46.6331915','61.2529842'),(457,'Котово','44.8031864','50.3205433'),(458,'Котовск','41.5102486','52.592393'),(459,'Кохма','41.0933071','56.9325151'),(460,'Красавино','46.481465','60.9613991'),(461,'Красноармейск','45.7011086','51.0268595'),(462,'Красноармейск','45.695141','51.0236026'),(463,'Красновишерск','57.0537244','60.3902242'),(464,'Красногорск','37.32942','55.8318475'),(465,'Краснодар','38.9760801','45.040235'),(466,'Краснозаводск','38.2320671','56.4408723'),(467,'Краснознаменск','22.4928511','54.9452612'),(468,'Краснознаменск','37.0395137','55.5978962'),(469,'Краснокаменск','118.0323407','50.092858'),(470,'Краснокамск','55.7479797','58.0820946'),(471,'Красноперекопск','33.7921523','45.9537956'),(472,'Краснослободск','44.5631799','48.7068777'),(473,'Краснослободск','43.7845096','54.4248634'),(474,'Краснотурьинск','60.1934451','59.7636934'),(475,'Красноуральск','60.0409011','58.3486334'),(476,'Красноуфимск','57.7636958','56.6122864'),(477,'Красноярск','92.8524162','56.009466'),(478,'Красный Кут','46.9712472','50.9596867'),(479,'Красный Сулин','40.0781385','47.8830826'),(480,'Красный Холм','37.1125975','58.0570193'),(481,'Кременки','37.116878','54.8863306'),(482,'Кропоткин','40.5727852','45.4332464'),(483,'Крымск','37.9855314','44.9344108'),(484,'Кстово','44.1665081','56.1433353'),(485,'Кубинка','36.6952487','55.5755679'),(486,'Кувандык','57.3612029','51.4784845'),(487,'Кувшиново','34.1676435','57.0263733'),(488,'Кудымкар','54.6573459','59.0168605'),(489,'Кузнецк','46.6052497','53.1131686'),(490,'Куйбышев','78.3241042','55.4684104'),(491,'Кулебаки','42.512483','55.429716'),(492,'Кумертау','55.7969915','52.7565537'),(493,'Кунгур','56.9437787','57.4283217'),(494,'Купино','77.2972969','54.3660317'),(495,'Курган','65.3161339','55.4443448'),(496,'Курганинск','40.5913858','44.8876442'),(497,'Курильск','147.8796713','45.2271915'),(498,'Курлово','40.6124362','55.4525994'),(499,'Куровское','38.9208543','55.5791491'),(500,'Курск','36.1926448','51.7303391'),(501,'Куртамыш','64.4203009','54.9368491'),(502,'Курчатов','35.6571711','51.6605475'),(503,'Куса','59.4386474','55.3385156'),(504,'Кушва','59.7646113','58.2825406'),(505,'Кызыл','94.4377234','51.7191542'),(506,'Кыштым','60.5563271','55.7060048'),(507,'Кяхта','106.4534938','50.3466291'),(508,'Лабинск','40.724385','44.6353153'),(509,'Лабытнанги','66.3882628','66.6592376'),(510,'Лагань','47.3432943','45.3929617'),(511,'Ладушкин','20.1691909','54.5693538'),(512,'Лаишево','49.5498201','55.4042646'),(513,'Лакинск','39.9564706','56.0180614'),(514,'Лангепас','75.1807905','61.2536667'),(515,'Лахденпохья','30.199592','61.5189466'),(516,'Лебедянь','39.143498','53.0156678'),(517,'Лениногорск','52.4432118','54.5966917'),(518,'Ленинск','45.1992835','48.6936234'),(519,'Ленинск-Кузнецкий','86.1796724','54.6674092'),(520,'Ленск','114.9549103','60.7276036'),(521,'Лермонтов','42.9731433','44.1052526'),(522,'Лесной','59.7980528','58.634981'),(523,'Лесозаводск','133.4185501','45.4780192'),(524,'Лесосибирск','92.5036986','58.2218201'),(525,'Ливны','37.603944','52.4285122'),(526,'Ликино-Дулево','38.9577103','55.7078531'),(527,'Липецк','39.5946266','52.6103027'),(528,'Липки','37.7019452','53.9418109'),(529,'Лиски','39.518302','50.9944734'),(530,'Лихославль','35.4667886','57.122256'),(531,'Лобня','37.4614671','56.0328745'),(532,'Лодейное Поле','33.5522225','60.7320564'),(533,'Лосино-Петровский','38.2005377','55.8714441'),(534,'Луга','29.8466657','58.7373818'),(535,'Луза','47.2612069','60.6290781'),(536,'Лукоянов','44.4933829','55.0327349'),(537,'Луховицы','39.0261346','54.9651617'),(538,'Лысково','45.0356702','56.0262298'),(539,'Лысьва','57.8085728','58.0995987'),(540,'Лыткарино','37.9034952','55.5778065'),(541,'Льгов','35.2611592','51.6596935'),(542,'Любань','31.2485276','59.3492573'),(543,'Люберцы','37.9606496','55.700416'),(544,'Любим','40.6869581','58.3619868'),(545,'Людиново','34.4385498','53.8701406'),(546,'Лянтор','72.1793828','61.6391639'),(547,'Магадан','150.8085289','59.5681763'),(548,'Магас','44.8130849','43.1686967'),(549,'Магнитогорск','58.9791432','53.4071891'),(550,'Майкоп','40.1006527','44.6098268'),(551,'Майский','44.0516663','43.6281779'),(552,'Макаров','142.7803508','48.6236287'),(553,'Макарьев','43.8014428','57.8808916'),(554,'Макушино','67.2452558','55.2154025'),(555,'Малая Вишера','32.2247984','58.8458076'),(556,'Малгобек','44.5901517','43.5097009'),(557,'Малмыж','50.6782757','56.5243722'),(558,'Малоархангельск','36.5037931','52.4001151'),(559,'Малоярославец','36.4632122','55.0176756'),(560,'Мамадыш','51.4128614','55.7149876'),(561,'Мамоново','19.9454114','54.4645591'),(562,'Мантурово','44.7575036','58.3264667'),(563,'Мариинск','87.7454392','56.2127836'),(564,'Мариинский Посад','47.7142676','56.111968'),(565,'Маркс','46.7400684','51.7133973'),(566,'Махачкала','47.5046303','42.9848572'),(567,'Мглин','32.8467217','53.0600644'),(568,'Мегион','76.1024772','61.0318946'),(569,'Медвежьегорск','34.4567614','62.9127678'),(570,'Медногорск','57.5832185','51.4039421'),(571,'Медынь','35.887313','54.9690755'),(572,'Межгорье','57.96146','54.239683'),(573,'Междуреченск','88.0703888','53.6865695'),(574,'Мезень','44.2531865','65.8398386'),(575,'Меленки','41.634124','55.3387017'),(576,'Мелеуз','55.9283483','52.9590637'),(577,'Менделеевск','52.3144177','55.8950646'),(578,'Мензелинск','53.1005321','55.7270908'),(579,'Мещовск','35.2816065','54.3191127'),(580,'Миасс','60.1077757','55.0455774'),(581,'Микунь','50.0719738','62.3580188'),(582,'Миллерово','40.3983302','48.925821'),(583,'Минеральные Воды','43.1383482','44.2088942'),(584,'Минусинск','91.6871866','53.7105509'),(585,'Миньяр','57.5484435','55.0709601'),(586,'Мирный','40.3359976','62.7644267'),(587,'Мирный','113.9668146','62.5362511'),(588,'Михайлов','39.0090857','54.2296493'),(589,'Михайловка','43.2400847','50.0708749'),(590,'Михайловск','59.113865','56.4369736'),(591,'Михайловск','42.028787','45.1296297'),(592,'Мичуринск','40.510475','52.891294'),(593,'Могоча','119.7661232','53.7362465'),(594,'Можайск','36.0240724','55.5069819'),(595,'Можга','52.2138882','56.4427219'),(596,'Моздок','44.6571456','43.7471209'),(597,'Мончегорск','32.9358886','67.9385206'),(598,'Морозовск','41.8308006','48.3511724'),(599,'Моршанск','41.8115687','53.4436469'),(600,'Мосальск','34.987206','54.4825589'),(601,'Муравленко','74.494913','63.794188'),(602,'Мураши','48.9637651','59.3956347'),(603,'Мурманск','33.0686019','69.0076958'),(604,'Муром','42.023006','55.5632276'),(605,'Мценск','36.574992','53.2790021'),(606,'Мыски','87.8056657','53.7125516'),(607,'Мытищи','37.7363702','55.9104647'),(608,'Мышкин','38.4542816','57.7881664'),(609,'Набережные Челны','52.3958739','55.7436475'),(610,'Навашино','42.1887734','55.5439105'),(611,'Наволоки','41.9607371','57.4678426'),(612,'Надым','72.5182746','65.5377514'),(613,'Назарово','90.4167947','56.0113176'),(614,'Назрань','44.764685','43.2257977'),(615,'Называевск','71.3502572','55.5688811'),(616,'Нальчик','43.6070316','43.4846312'),(617,'Нариманов','47.8501624','46.6916597'),(618,'Наро-Фоминск','36.7608038','55.3802749'),(619,'Нарткала','43.8576411','43.5577208'),(620,'Нарьян-Мар','53.0069336','67.6381525'),(621,'Находка','132.8927812','42.8240404'),(622,'Невель','29.9240505','56.0201544'),(623,'Невельск','141.8631741','46.6527314'),(624,'Невинномысск','41.9476147','44.6227404'),(625,'Невьянск','60.2181839','57.491233'),(626,'Нелидово','32.7766656','56.2232417'),(627,'Неман','22.0323961','55.0315543'),(628,'Нерехта','40.5725438','57.4543706'),(629,'Нерчинск','116.5854018','51.9595512'),(630,'Нерюнгри','124.72031','56.6600322'),(631,'Нестеров','22.5713658','54.6314454'),(632,'Нефтегорск','51.1637126','52.797259'),(633,'Нефтекамск','54.2483391','56.0883075'),(634,'Нефтекумск','44.9865041','44.7544866'),(635,'Нефтеюганск','72.6164185','61.0882837'),(636,'Нея','43.8780965','58.2944499'),(637,'Нижневартовск','76.5696206','60.9397379'),(638,'Нижнекамск','51.814407','55.6311963'),(639,'Нижнеудинск','99.0313481','54.8969105'),(640,'Нижние Серги','59.2952291','56.6544606'),(641,'Нижний Ломов','43.6729216','53.5301274'),(642,'Нижний Новгород','44.0053948','56.3242093'),(643,'Нижний Тагил','59.9813242','57.9101038'),(644,'Нижняя Салда','60.7026555','58.0749243'),(645,'Нижняя Тура','59.8521265','58.6310942'),(646,'Николаевск','45.4733204','50.0166952'),(647,'Николаевск-на-Амуре','140.7109642','53.1461943'),(648,'Никольск','45.4575468','59.5350162'),(649,'Никольск','46.079962','53.7138397'),(650,'Никольское','30.7874879','59.7042633'),(651,'Новая Ладога','32.3141446','60.1100013'),(652,'Новая Ляля','60.5945405','59.053961'),(653,'Новоалександровск','41.2154482','45.4933561'),(654,'Новоалтайск','83.9311249','53.4120811'),(655,'Новоаннинский','42.6666038','50.5296873'),(656,'Нововоронеж','39.2162865','51.3092463'),(657,'Новодвинск','40.8208003','64.4136023'),(658,'Новозыбков','31.9356826','52.5371426'),(659,'Новокубанск','41.0473679','45.1038782'),(660,'Новокузнецк','87.2144046','53.7942757'),(661,'Новокуйбышевск','49.9477662','53.0995303'),(662,'Новомичуринск','39.7467023','54.0377979'),(663,'Новомосковск','38.2915652','54.0109754'),(664,'Новопавловск','43.6342855','43.9617565'),(665,'Новоржев','29.343333','57.0298332'),(666,'Новороссийск','37.7687218','44.7234264'),(667,'Новосибирск','82.9210575','55.0281016'),(668,'Новосиль','37.0438402','52.9747225'),(669,'Новосокольники','30.1527712','56.3407627'),(670,'Новотроицк','58.3017455','51.1965071'),(671,'Новоузенск','48.1412622','50.4551744'),(672,'Новоульяновск','48.3911701','54.1447691'),(673,'Новоуральск','60.095701','57.2471507'),(674,'Новохоперск','41.6173714','51.0953461'),(675,'Новочебоксарск','47.4791429','56.109486'),(676,'Новочеркасск','40.1042066','47.4119248'),(677,'Новошахтинск','39.9364709','47.7576522'),(678,'Новый Оскол','37.8774026','50.7635162'),(679,'Новый Уренгой','76.6810032','66.0840036'),(680,'Ногинск','38.4621635','55.8686239'),(681,'Нолинск','49.9357867','57.5596946'),(682,'Норильск','88.2009965','69.3490828'),(683,'Ноябрьск','75.4509665','63.201846'),(684,'Нурлат','50.8050431','54.4281578'),(685,'Нытва','55.3357261','57.9337429'),(686,'Нюрба','118.324325','63.2828775'),(687,'Нягань','65.3944361','62.1454839'),(688,'Нязепетровск','59.6096791','56.0537199'),(689,'Няндома','40.2061699','61.6653735'),(690,'Облучье','131.0539984','49.0188344'),(691,'Обнинск','36.6121785','55.0943892'),(692,'Обоянь','36.275425','51.212012'),(693,'Обь','82.6937925','54.9945882'),(694,'Одинцово','37.2636389','55.6789292'),(695,'Озерск','22.013508','54.4084804'),(696,'Озерск','60.7076337','55.7631922'),(697,'Озеры','38.55987','54.8539944'),(698,'Октябрьск','48.6707463','53.1640886'),(699,'Октябрьский','53.4656611','54.4815344'),(700,'Окуловка','33.2902474','58.3908717'),(701,'Олекминск','120.406013','60.3758203'),(702,'Оленегорск','33.2670094','68.1422068'),(703,'Олонец','32.9726031','60.9793604'),(704,'Омск','73.3674638','54.9848136'),(705,'Омутнинск','52.1893554','58.6697684'),(706,'Онега','38.0805749','63.9163966'),(707,'Опочка','28.6717455','56.7107956'),(708,'Орёл','36.0696479','52.9672573'),(709,'Оренбург','55.1017379','51.7875191'),(710,'Орехово-Зуево','38.9870711','55.8151729'),(711,'Орлов','48.8929268','58.5389402'),(712,'Орск','58.4751889','51.2293069'),(713,'Оса','55.4688982','57.2889992'),(714,'Осинники','87.3369948','53.5987397'),(715,'Осташков','33.1116707','57.1457205'),(716,'Остров','28.3437107','57.3452408'),(717,'Островной','39.5076034','68.0509133'),(718,'Острогожск','39.0406398','50.8678083'),(719,'Отрадное','30.7988403','59.772596'),(720,'Отрадный','51.3438695','53.3800609'),(721,'Оха','142.941221','53.5868238'),(722,'Оханск','55.387153','57.7178946'),(723,'Очер','54.7161756','57.8851991'),(724,'Павлово','43.0996232','55.9797995'),(725,'Павловск','40.1369087','50.4533684'),(726,'Павловский Посад','38.6596047','55.7806718'),(727,'Палласовка','46.8803355','50.0501422'),(728,'Партизанск','133.1264754','43.1279833'),(729,'Певек','170.2999194','69.7018051'),(730,'Пенза','45.0347408','53.1753884'),(731,'Первомайск','43.8012829','54.8676182'),(732,'Первоуральск','59.9429205','56.9081665'),(733,'Перевоз','44.5450268','55.596904'),(734,'Пересвет','38.1733567','56.4158828'),(735,'Переславль-Залесский','38.8543064','56.7360435'),(736,'Пермь','56.2341778','58.0103211'),(737,'Пестово','35.8144523','58.5973944'),(738,'Петров Вал','45.2091455','50.1380355'),(739,'Петровск','45.3851649','52.3093782'),(740,'Петровск-Забайкальский','108.8467139','51.2748381'),(741,'Петрозаводск','34.3596263','61.78909'),(742,'Петропавловск-Камчатский','158.6559142','53.0370213'),(743,'Петухово','67.8874369','55.0649932'),(744,'Петушки','39.4507913','55.9297657'),(745,'Печора','57.22388','65.1485717'),(746,'Печоры','27.6222823','57.8146689'),(747,'Пикалево','34.1773982','59.5130655'),(748,'Пионерский','20.227697','54.9516927'),(749,'Питкяранта','31.4641309','61.5756886'),(750,'Плавск','37.2863144','53.7095993'),(751,'Пласт','60.8152305','54.3691832'),(752,'Плес','41.512301','57.4605304'),(753,'Поворино','42.2472432','51.1953446'),(754,'Подольск','37.57027','55.4389588'),(755,'Подпорожье','34.1567832','60.9127463'),(756,'Покачи','75.5942069','61.7421977'),(757,'Покров','39.1733641','55.9167118'),(758,'Покровск','129.1482195','61.4843538'),(759,'Полевской','60.2366314','56.4958085'),(760,'Полесск','21.0998148','54.8626321'),(761,'Полысаево','86.2808803','54.6053968'),(762,'Полярные Зори','32.497541','67.3730192'),(763,'Полярный','33.4509985','69.1988373'),(764,'Поронайск','143.1007104','49.2387983'),(765,'Порхов','29.5436424','57.7764223'),(766,'Похвистнево','52.1235517','53.6498197'),(767,'Почеп','33.4744608','52.9154724'),(768,'Починок','32.4397914','54.4063031'),(769,'Пошехонье','39.1210034','58.506328'),(770,'Правдинск','21.0083638','54.4430604'),(771,'Приволжск','41.2809239','57.3807249'),(772,'Приморск','19.9983108','54.7311185'),(773,'Приморск','28.6135962','60.3660787'),(774,'Приморско-Ахтарск','38.1704654','46.0515'),(775,'Приозерск','30.15876','61.03313'),(776,'Прокопьевск','86.7183428','53.8604562'),(777,'Пролетарск','41.7274533','46.7038968'),(778,'Протвино','37.2183307','54.8706614'),(779,'Прохладный','44.0101936','43.7589521'),(780,'Псков','28.3318188','57.819284'),(781,'Пугачев','48.7972652','52.0158464'),(782,'Пудож','36.5330088','61.8059147'),(783,'Пустошка','29.3668243','56.3375131'),(784,'Пучеж','43.1683878','56.982075'),(785,'Пушкино','37.8471438','56.0104548'),(786,'Пущино','37.6210428','54.832521'),(787,'Пыталово','27.9234759','57.0637109'),(788,'Пыть-Ях','72.8366445','60.7585769'),(789,'Пятигорск','43.0661091','44.0411669'),(790,'Радужный','40.3323247','55.9961034'),(791,'Радужный','77.4584346','62.1343067'),(792,'Райчихинск','129.4112149','49.7941882'),(793,'Раменское','38.273015','55.549529'),(794,'Рассказово','41.8743779','52.6537517'),(795,'Ревда','59.9071464','56.79869'),(796,'Реж','61.3833223','57.3717914'),(797,'Реутов','37.8619443','55.758236'),(798,'Ржев','34.3291178','56.2629393'),(799,'Родники','41.7298908','57.1024137'),(800,'Рославль','32.8479617','53.9449601'),(801,'Россошь','39.6225534','50.170089'),(802,'Ростов','39.4378357','57.2050177'),(803,'Ростов-на-Дону','39.7187866','47.2224364'),(804,'Рошаль','39.8655434','55.6632504'),(805,'Ртищево','43.7842399','52.2616298'),(806,'Рубцовск','81.2077729','51.5013075'),(807,'Рудня','31.0794758','54.9441357'),(808,'Руза','36.1960043','55.7015302'),(809,'Рузаевка','44.949116','54.0583238'),(810,'Рыбинск','38.858338','58.0483802'),(811,'Рыбное','39.513438','54.7255937'),(812,'Рыльск','34.6802178','51.568165'),(813,'Ряжск','40.0521358','53.7067718'),(814,'Рязань','39.7359992','54.625457'),(815,'Саки','33.6032508','45.1342889'),(816,'Салават','55.9245559','53.3616311'),(817,'Салаир','85.8029215','54.2351588'),(818,'Салехард','66.6083994','66.5493568'),(819,'Сальск','41.5412229','46.4751689'),(820,'Самара','50.1067691','53.1951657'),(821,'Саранск','45.1862263','54.1807601'),(822,'Сарапул','53.8036967','56.4616117'),(823,'Саратов','45.9530257','51.530376'),(824,'Саров','43.3447792','54.9227002'),(825,'Сасово','41.9117458','54.350807'),(826,'Сатка','59.0288153','55.0404497'),(827,'Сафоново','33.233799','55.1199868'),(828,'Саяногорск','91.4121643','53.1008226'),(829,'Саянск','102.1802563','54.1107787'),(830,'Светлогорск','20.1514789','54.9439566'),(831,'Светлоград','42.8566923','45.3284769'),(832,'Светлый','20.1356625','54.6774051'),(833,'Светогорск','28.8726666','61.1112679'),(834,'Свирск','103.3364192','53.0842576'),(835,'Свободный','128.1218995','51.361264'),(836,'Себеж','28.4725735','56.2907663'),(837,'Северобайкальск','109.3362606','55.6357165'),(838,'Северодвинск','39.8182715','64.56253'),(839,'Северо-Курильск','156.1280722','50.6731056'),(840,'Североморск','33.4178354','69.0765029'),(841,'Североуральск','59.9525274','60.1533333'),(842,'Северск','84.8809687','56.6031143'),(843,'Севск','34.4918198','52.1484215'),(844,'Сегежа','34.3126755','63.7437211'),(845,'Сельцо','34.1059226','53.3738801'),(846,'Семенов','44.4903571','56.788935'),(847,'Семикаракорск','40.811585','47.5177981'),(848,'Семилуки','39.0189797','51.6951846'),(849,'Сенгилей','48.7767869','53.9590553'),(850,'Серафимович','42.7360013','49.566286'),(851,'Сергач','45.4813193','55.5200364'),(852,'Сергиев Посад','38.1502568','56.3063411'),(853,'Сердобск','44.2122688','52.4697532'),(854,'Серов','60.5752136','59.6048651'),(855,'Серпухов','37.4032682','54.9225396'),(856,'Сертолово','30.2094595','60.14458'),(857,'Сибай','58.6663303','52.7205811'),(858,'Сим','57.6899045','54.9906584'),(859,'Симферополь','34.100117','44.9482645'),(860,'Сковородино','123.943729','53.9871004'),(861,'Скопин','39.5493286','53.8236028'),(862,'Славгород','78.6459674','52.9993053'),(863,'Славск','21.6742294','55.0451054'),(864,'Славянск-на-Кубани','38.1260725','45.2605079'),(865,'Сланцы','28.088106','59.1178693'),(866,'Слободской','50.1670091','58.7311934'),(867,'Слюдянка','103.7186877','51.6562679'),(868,'Смоленск','31.8153366','54.7867168'),(869,'Снежинск','60.7324989','56.085232'),(870,'Снежногорск','33.2382821','69.1921469'),(871,'Собинка','40.0180034','55.993798'),(872,'Советск','21.8886272','55.0810474'),(873,'Советск','48.9589228','57.5841434'),(874,'Советск','37.6315517','53.9337099'),(875,'Советская Гавань','140.2852223','48.9664554'),(876,'Советский','63.566863','61.3706695'),(877,'Сокол','40.1114414','59.4759156'),(878,'Солигалич','42.2877245','59.0786729'),(879,'Соликамск','56.7710358','59.6483518'),(880,'Солнечногорск','37.0967653','56.2148655'),(881,'Сольвычегодск','46.920351','61.3318091'),(882,'Соль-Илецк','54.9895391','51.1634976'),(883,'Сольцы','30.309285','58.1201693'),(884,'Сорочинск','53.1542123','52.4265081'),(885,'Сорск','90.2595674','54.0001451'),(886,'Сортавала','30.6917021','61.7032216'),(887,'Сосенский','35.9621458','54.056525'),(888,'Сосновка','51.2833412','56.2533149'),(889,'Сосновоборск','93.3353411','56.1202088'),(890,'Сосновый Бор','29.1290866','59.8772921'),(891,'Сосногорск','53.8762792','63.5990137'),(892,'Сочи','39.7231419','43.5855829'),(893,'Спас-Деменск','34.0190263','54.4099201'),(894,'Спас-Клепики','40.1745036','55.1291472'),(895,'Спасск','43.1860475','53.927163'),(896,'Спасск-Дальний','132.8157564','44.5900929'),(897,'Спасск-Рязанский','40.3764367','54.4071497'),(898,'Среднеколымск','153.7069511','67.4581664'),(899,'Среднеуральск','60.4771953','56.991883'),(900,'Сретенск','117.7116971','52.2462356'),(901,'Ставрополь','41.9690168','45.0445439'),(902,'Старая Купавна','38.1426144','55.8038411'),(903,'Старая Русса','31.3555076','57.9906873'),(904,'Старица','34.9335145','56.514955'),(905,'Стародуб','32.7603628','52.5851881'),(906,'Старый Крым','35.0900885','45.0290659'),(907,'Старый Оскол','37.8349849','51.2965991'),(908,'Стерлитамак','55.9315707','53.6302498'),(909,'Стрежевой','77.6040323','60.7328199'),(910,'Строитель','36.4886619','50.7845571'),(911,'Струнино','38.583938','56.3750001'),(912,'Ступино','38.1186976','54.9238403'),(913,'Суворов','36.4806933','54.1345367'),(914,'Судак','34.9761591','44.8505913'),(915,'Суджа','35.2719619','51.1919711'),(916,'Судогда','40.8563392','55.949897'),(917,'Суздаль','40.4525581','56.4273814'),(918,'Суоярви','32.3499029','62.0787769'),(919,'Сураж','32.3938351','53.0171239'),(920,'Сургут','73.3961726','61.2539773'),(921,'Суровикино','42.8541308','48.6189756'),(922,'Сурск','45.6911897','53.0760597'),(923,'Сусуман','148.154033','62.7804628'),(924,'Сухиничи','35.3443077','54.0973787'),(925,'Сухой Лог','62.0358708','56.9075938'),(926,'Сызрань','48.4745419','53.1557213'),(927,'Сыктывкар','50.8356491','61.668789'),(928,'Сысерть','60.8190708','56.50052'),(929,'Сычевка','34.277868','55.8307397'),(930,'Сясьстрой','32.5602015','60.1402454'),(931,'Тавда','65.2743232','58.0434196'),(932,'Таганрог','38.935154','47.2094907'),(933,'Тайга','85.6207907','56.0622767'),(934,'Тайшет','98.0030649','55.9405397'),(935,'Талдом','37.5276414','56.7308993'),(936,'Талица','63.7322467','57.0123359'),(937,'Тамбов','41.452258','52.7213021'),(938,'Тара','74.3649643','56.9159171'),(939,'Тарко-Сале','77.7610204','64.9117649'),(940,'Таруса','37.1670866','54.7236791'),(941,'Татарск','75.9740805','55.2145894'),(942,'Таштагол','87.8477272','52.7594505'),(943,'Тверь','35.9117898','56.8585396'),(944,'Теберда','41.7414924','43.4438408'),(945,'Тейково','40.5355289','56.8542712'),(946,'Темников','43.2161785','54.6309086'),(947,'Темрюк','37.445519','45.2611082'),(948,'Терек','44.1402524','43.4838439'),(949,'Тетюши','48.8314915','54.936575'),(950,'Тимашевск','38.9350513','45.6159358'),(951,'Тихвин','33.5072307','59.6273809'),(952,'Тихорецк','40.1258702','45.8546953'),(953,'Тобольск','68.2538392','58.2016828'),(954,'Тогучин','84.4103867','55.2250038'),(955,'Тольятти','49.389461','53.5206438'),(956,'Томари','142.061508','47.7619957'),(957,'Томмот','126.2875375','58.9586939'),(958,'Томск','84.9481737','56.4847036'),(959,'Топки','85.6153223','55.2766036'),(960,'Торжок','34.9600691','57.0412804'),(961,'Торопец','31.6354366','56.5011791'),(962,'Тосно','30.8777872','59.5406697'),(963,'Тотьма','42.7589701','59.9735051'),(964,'Трехгорный','58.4465039','54.8178174'),(965,'Троицк','61.5585503','54.0844132'),(966,'Трубчевск','33.7660013','52.5791314'),(967,'Туапсе','39.082645','44.1103707'),(968,'Туймазы','53.6949081','54.5999889'),(969,'Тула','37.6153885','54.192017'),(970,'Тулун','100.5779402','54.5571409'),(971,'Туран','93.9172495','52.144932'),(972,'Туринск','63.698142','58.0394258'),(973,'Тутаев','39.5368234','57.8674237'),(974,'Тында','124.7468634','55.1546401'),(975,'Тырныауз','42.9215127','43.3981939'),(976,'Тюкалинск','72.1956156','55.8705121'),(977,'Тюмень','65.5343118','57.1530824'),(978,'Уварово','42.2529568','51.9768835'),(979,'Углегорск','142.0693033','49.0816311'),(980,'Углич','38.3019793','57.5223866'),(981,'Удачный','112.3061653','66.4072367'),(982,'Удомля','35.016716','57.8787885'),(983,'Ужур','89.8333827','55.3141977'),(984,'Узловая','38.1763104','53.9731407'),(985,'Улан-Удэ','107.5841511','51.8334378'),(986,'Ульяновск','48.3748717','54.3080674'),(987,'Унеча','32.6757071','52.8460665'),(988,'Урай','64.8040117','60.1295842'),(989,'Урень','45.783394','57.4612547'),(990,'Уржум','50.0056278','57.1097612'),(991,'Урюпинск','42.0288589','50.7904767'),(992,'Усинск','57.5570054','65.9941116'),(993,'Усмань','39.7264516','52.0444165'),(994,'Усолье','56.6837783','59.4279356'),(995,'Усолье-Сибирское','103.6387694','52.7567192'),(996,'Уссурийск','131.9517262','43.79726'),(997,'Усть-Джегута','41.971128','44.083852'),(998,'Усть-Илимск','102.7414683','57.9431325'),(999,'Усть-Катав','58.1528067','54.9261323'),(1000,'Усть-Кут','105.7756883','56.7928049'),(1001,'Усть-Лабинск','39.6930239','45.222676'),(1002,'Устюжна','36.4425046','58.8383671'),(1003,'Уфа','55.9578647','54.734853'),(1004,'Ухта','53.7014202','63.5564779'),(1005,'Учалы','59.4126559','54.3066965'),(1006,'Уяр','94.3282148','55.8131698'),(1007,'Фатеж','35.8538912','52.0918591'),(1008,'Феодосия','35.3824772','45.031878'),(1009,'Фокино','34.4158537','53.4554552'),(1010,'Фокино','132.4110209','42.9707163'),(1011,'Фролово','43.6648936','49.7647809'),(1012,'Фрязино','38.0409171','55.9590154'),(1013,'Фурманов','41.1053808','57.2538043'),(1014,'Хабаровск','135.0598811','48.4647991'),(1015,'Хадыженск','39.5319151','44.412303'),(1016,'Ханты-Мансийск','69.0183322','61.0024344'),(1017,'Харабали','47.2524467','47.4089187'),(1018,'Харовск','40.2000794','59.9477728'),(1019,'Хасавюрт','46.5852276','43.2505191'),(1020,'Хвалынск','48.1045147','52.4950057'),(1021,'Хилок','110.458989','51.3635236'),(1022,'Химки','37.4304154','55.8886705'),(1023,'Холм','31.1787812','57.1451036'),(1024,'Холмск','142.0416619','47.0408637'),(1025,'Хотьково','37.9395225','56.2515725'),(1026,'Цивильск','47.472967','55.8650132'),(1027,'Цимлянск','42.093022','47.6477668'),(1028,'Циолковский','128.121972','51.7624346'),(1029,'Чадан','91.5789135','51.2844482'),(1030,'Чайковский','54.1478482','56.7780203'),(1031,'Чапаевск','49.8674222','52.9289662'),(1032,'Чаплыгин','39.9671563','53.2404794'),(1033,'Чебаркуль','60.3773305','54.9819329'),(1034,'Чебоксары','47.2488718','56.1439378'),(1035,'Чегем','43.5865338','43.5672039'),(1036,'Чекалин','36.2474377','54.0985105'),(1037,'Челябинск','61.4007858','55.1603659'),(1038,'Чердынь','56.4801391','60.4011184'),(1039,'Черемхово','103.090119','53.1369385'),(1040,'Черепаново','83.3724392','54.2206974'),(1041,'Череповец','37.9092243','59.1269214'),(1042,'Черкесск','42.0467829','44.2268637'),(1043,'Чермоз','56.1507562','58.7842527'),(1044,'Черноголовка','38.3792328','56.0100909'),(1045,'Черногорск','91.3259669','53.8258425'),(1046,'Чернушка','56.0763919','56.5161079'),(1047,'Черняховск','21.7969179','54.6243928'),(1048,'Чехов','37.4532591','55.1507175'),(1049,'Чистополь','50.628495','55.3699372'),(1050,'Чита','113.4994884','52.0340128'),(1051,'Чкаловск','43.2420193','56.7651549'),(1052,'Чудово','31.6865406','59.1247477'),(1053,'Чулым','80.9592152','55.0906205'),(1054,'Чусовой','57.8193122','58.2974725'),(1055,'Чухлома','42.6883783','58.7534246'),(1056,'Шагонар','92.9199618','51.5347357'),(1057,'Шадринск','63.6298234','56.0870152'),(1058,'Шали','45.9009577','43.148776'),(1059,'Шарыпово','89.1801557','55.5389684'),(1060,'Шарья','45.4060762','58.3761832'),(1061,'Шатура','39.5443781','55.5777942'),(1062,'Шахты','40.2159154','47.7084247'),(1063,'Шахунья','46.6129673','57.6764773'),(1064,'Шацк','41.7182108','54.0288845'),(1065,'Шебекино','36.8877988','50.4005506'),(1066,'Шелехов','104.0973531','52.2102462'),(1067,'Шенкурск','42.89959','62.1057423'),(1068,'Шилка','116.033575','51.8495302'),(1069,'Шимановск','127.7006559','52.0052856'),(1070,'Шиханы','47.2022928','52.1148241'),(1071,'Шлиссельбург','31.0334136','59.9443923'),(1072,'Шумерля','46.4183534','55.4961795'),(1073,'Шумиха','63.2902391','55.2281833'),(1074,'Шуя','41.3802455','56.8560743'),(1075,'Щекино','37.517686','54.0020749'),(1076,'Щелкино','35.8251329','45.4289847'),(1077,'Щелково','37.9784419','55.9234303'),(1078,'Щигры','36.8910674','51.8787808'),(1079,'Щучье','62.7478475','55.20883'),(1080,'Электрогорск','38.7805239','55.8778573'),(1081,'Электросталь','38.4446531','55.7847718'),(1082,'Электроугли','38.2194049','55.7170329'),(1083,'Элиста','44.2701417','46.3082947'),(1084,'Энгельс','46.1267479','51.4854893'),(1085,'Эртиль','40.8074054','51.831024'),(1086,'Югорск','63.3364787','61.3124504'),(1087,'Южа','42.0457159','56.5926458'),(1088,'Южно-Сахалинск','142.7381252','46.959133'),(1089,'Южно-Сухокумск','45.6499304','44.6600972'),(1090,'Южноуральск','61.2581869','54.4490124'),(1091,'Юрга','84.8885516','55.7202689'),(1092,'Юрьевец','43.1110553','57.3178701'),(1093,'Юрьев-Польский','39.6679311','56.4938067'),(1094,'Юрюзань','58.4227116','54.8546372'),(1095,'Юхнов','35.2424857','54.7445873'),(1096,'Ядрин','46.2020765','55.9406826'),(1097,'Якутск','129.7325717','62.0280273'),(1098,'Ялта','34.04455','44.416366'),(1099,'Ялта','34.166386','44.4951948'),(1100,'Ялуторовск','66.297034','56.649167'),(1101,'Янаул','54.9298314','56.2650336'),(1102,'Яранск','47.8479185','57.304195'),(1103,'Яровое','78.5729898','52.9251728'),(1104,'Ярославль','39.897878','57.6216145'),(1105,'Ярцево','32.6902457','55.0564933'),(1106,'Ясногорск','37.689669','54.4795178'),(1107,'Ясный','59.8743256','51.0369499'),(1108,'Яхрома','37.4831016','56.2889858'),(1109,'Санкт-Петербург','59.9392259','29.5342917');
  /*!40000 ALTER TABLE `cities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `favorite_list`
  --
  
  DROP TABLE IF EXISTS `favorite_list`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `favorite_list` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_selected_id` int NOT NULL,
    `user_who_select_id` int NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_selected_id` (`user_selected_id`),
    KEY `user_who_select_id` (`user_who_select_id`),
    CONSTRAINT `favorite_list_ibfk_1` FOREIGN KEY (`user_selected_id`) REFERENCES `user` (`id`),
    CONSTRAINT `favorite_list_ibfk_2` FOREIGN KEY (`user_who_select_id`) REFERENCES `user` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `favorite_list`
  --
  
  LOCK TABLES `favorite_list` WRITE;
  /*!40000 ALTER TABLE `favorite_list` DISABLE KEYS */;
  INSERT INTO `favorite_list` VALUES (1,73,96),(2,87,65),(3,14,7),(4,19,9),(5,66,78),(6,49,2),(7,63,23),(8,79,91),(9,66,97),(10,92,77),(11,58,65),(12,6,71),(13,87,69),(14,32,19),(15,97,56),(16,21,15),(17,42,54),(18,11,81),(19,39,97),(20,12,9),(21,70,18),(22,82,1),(23,7,96),(24,41,11),(25,48,49),(26,64,10),(27,9,4),(28,55,15),(29,60,5),(30,89,45),(31,46,68),(32,52,52),(33,99,4),(34,63,79),(35,55,53),(36,24,33),(37,13,27),(38,23,74),(39,52,93),(40,12,98),(41,93,16),(42,69,69),(43,56,37),(44,27,90),(45,42,81),(46,2,47),(47,74,2),(48,50,81),(49,44,48),(50,56,46),(51,61,6),(52,97,61),(53,20,24),(54,50,39),(55,15,37),(56,29,82),(57,28,68),(58,3,6),(59,81,74),(60,42,24),(61,13,63),(62,73,12),(63,62,87),(64,33,99),(65,88,67),(66,20,33),(67,27,33),(68,79,42),(69,40,69),(70,56,31),(71,58,26),(72,1,21),(73,72,89),(74,87,66),(75,39,30),(76,62,13),(77,41,92),(78,36,2),(79,8,68),(80,14,50),(81,39,100),(82,50,2),(83,100,55),(84,75,30),(85,80,11),(86,87,82),(87,39,5),(88,1,32),(89,34,58),(90,8,83),(91,19,36),(92,53,41),(93,1,80),(94,61,30),(95,5,48),(96,67,83),(97,70,61),(98,30,7),(99,77,44),(100,71,53);
  /*!40000 ALTER TABLE `favorite_list` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `message`
  --
  
  DROP TABLE IF EXISTS `message`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `message` (
    `id` int NOT NULL AUTO_INCREMENT,
    `text` varchar(255) NOT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `user_id` int NOT NULL,
    `task_id` int NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `task_id` (`task_id`),
    CONSTRAINT `message_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
    CONSTRAINT `message_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `message`
  --
  
  LOCK TABLES `message` WRITE;
  /*!40000 ALTER TABLE `message` DISABLE KEYS */;
  INSERT INTO `message` VALUES (1,'felis, adipiscing fringilla, porttitor vulputate,','2020-05-17 13:49:27',1,1),(2,'montes, nascetur ridiculus mus. Proin vel arcu eu','2020-05-17 13:49:27',2,2),(3,'erat vitae risus.','2020-05-17 13:49:27',3,3),(4,'non, feugiat nec, diam. Duis','2020-05-17 13:49:27',4,4),(5,'pellentesque eget, dictum placerat, augue. Sed molestie.','2020-05-17 13:49:27',5,5),(6,'volutpat.','2020-05-17 13:49:27',6,6),(7,'dapibus gravida. Aliquam tincidunt, nunc ac','2020-05-17 13:49:27',7,7),(8,'diam. Sed','2020-05-17 13:49:27',8,8),(9,'sit amet metus.','2020-05-17 13:49:27',9,9),(10,'ligula. Aenean gravida nunc sed','2020-05-17 13:49:27',10,10),(11,'Maecenas iaculis aliquet diam. Sed','2020-05-17 13:49:27',11,11),(12,'pede. Praesent eu dui. Cum sociis natoque penatibus','2020-05-17 13:49:27',12,12),(13,'morbi tristique senectus et','2020-05-17 13:49:27',13,13),(14,'orci luctus et ultrices posuere cubilia Curae;','2020-05-17 13:49:27',14,14),(15,'in lobortis tellus justo sit amet nulla. Donec non','2020-05-17 13:49:27',15,15),(16,'nibh. Quisque nonummy ipsum non arcu.','2020-05-17 13:49:27',16,16),(17,'Fusce aliquam, enim nec tempus scelerisque,','2020-05-17 13:49:27',17,17),(18,'Cras interdum. Nunc sollicitudin','2020-05-17 13:49:27',18,18),(19,'Morbi','2020-05-17 13:49:27',19,19),(20,'tellus, imperdiet non, vestibulum nec, euismod in,','2020-05-17 13:49:27',20,20),(21,'Sed neque. Sed','2020-05-17 13:49:27',21,21),(22,'tristique pharetra.','2020-05-17 13:49:27',22,22),(23,'sed orci lobortis augue scelerisque mollis. Phasellus libero mauris,','2020-05-17 13:49:27',23,23),(24,'convallis dolor. Quisque tincidunt pede','2020-05-17 13:49:27',24,24),(25,'diam at pretium aliquet, metus urna convallis erat, eget tincidunt','2020-05-17 13:49:27',25,25),(26,'dolor.','2020-05-17 13:49:27',26,26),(27,'tempor lorem, eget mollis lectus','2020-05-17 13:49:27',27,27),(28,'placerat, orci lacus vestibulum lorem, sit amet ultricies sem magna','2020-05-17 13:49:27',28,28),(29,'orci, adipiscing non, luctus sit amet,','2020-05-17 13:49:27',29,29),(30,'pretium aliquet, metus urna convallis erat, eget tincidunt dui','2020-05-17 13:49:27',30,30),(31,'tincidunt','2020-05-17 13:49:27',31,31),(32,'semper auctor. Mauris vel turpis. Aliquam','2020-05-17 13:49:27',32,32),(33,'vulputate, posuere vulputate,','2020-05-17 13:49:27',33,33),(34,'ad litora torquent per conubia nostra, per inceptos hymenaeos. Mauris','2020-05-17 13:49:27',34,34),(35,'Proin ultrices. Duis volutpat nunc sit amet metus.','2020-05-17 13:49:27',35,35),(36,'et arcu imperdiet ullamcorper. Duis at lacus. Quisque','2020-05-17 13:49:27',36,36),(37,'natoque penatibus et magnis','2020-05-17 13:49:27',37,37),(38,'Aliquam auctor, velit eget laoreet posuere,','2020-05-17 13:49:27',38,38),(39,'erat','2020-05-17 13:49:27',39,39),(40,'vitae, sodales at, velit. Pellentesque','2020-05-17 13:49:27',40,40),(41,'sodales purus, in','2020-05-17 13:49:27',41,41),(42,'purus, in','2020-05-17 13:49:27',42,42),(43,'ut cursus luctus, ipsum leo elementum sem,','2020-05-17 13:49:27',43,43),(44,'semper et, lacinia vitae, sodales at, velit. Pellentesque ultricies','2020-05-17 13:49:27',44,44),(45,'eget varius ultrices, mauris','2020-05-17 13:49:27',45,45),(46,'risus, at fringilla purus mauris a nunc. In at pede.','2020-05-17 13:49:27',46,46),(47,'Curae; Phasellus ornare. Fusce mollis.','2020-05-17 13:49:27',47,47),(48,'In mi pede, nonummy ut, molestie in, tempus eu, ligula.','2020-05-17 13:49:27',48,48),(49,'est,','2020-05-17 13:49:27',49,49),(50,'mauris sit amet lorem semper auctor.','2020-05-17 13:49:27',50,50),(51,'eget ipsum. Suspendisse sagittis. Nullam vitae diam.','2020-05-17 13:49:27',51,51),(52,'amet,','2020-05-17 13:49:27',52,52),(53,'lacinia at, iaculis quis,','2020-05-17 13:49:27',53,53),(54,'lorem tristique aliquet. Phasellus fermentum convallis ligula. Donec luctus','2020-05-17 13:49:27',54,54),(55,'non quam. Pellentesque habitant morbi tristique senectus et','2020-05-17 13:49:27',55,55),(56,'Integer vitae nibh. Donec est mauris,','2020-05-17 13:49:27',56,56),(57,'mi eleifend egestas. Sed','2020-05-17 13:49:27',57,57),(58,'Maecenas libero est, congue','2020-05-17 13:49:27',58,58),(59,'est. Nunc','2020-05-17 13:49:27',59,59),(60,'nisi. Cum sociis natoque penatibus et magnis dis parturient montes,','2020-05-17 13:49:27',60,60),(61,'nisl. Maecenas malesuada fringilla est. Mauris eu','2020-05-17 13:49:27',61,61),(62,'Donec tincidunt. Donec vitae erat','2020-05-17 13:49:27',62,62),(63,'neque venenatis lacus. Etiam bibendum fermentum metus. Aenean','2020-05-17 13:49:27',63,63),(64,'ullamcorper, nisl arcu iaculis','2020-05-17 13:49:27',64,64),(65,'elit,','2020-05-17 13:49:27',65,65),(66,'mollis vitae, posuere at, velit. Cras lorem lorem, luctus ut,','2020-05-17 13:49:27',66,66),(67,'tincidunt, nunc ac mattis ornare, lectus ante dictum','2020-05-17 13:49:27',67,67),(68,'rutrum magna. Cras convallis','2020-05-17 13:49:27',68,68),(69,'non, bibendum sed, est.','2020-05-17 13:49:27',69,69),(70,'egestas.','2020-05-17 13:49:27',70,70),(71,'Sed congue, elit sed consequat','2020-05-17 13:49:27',71,71),(72,'fermentum arcu. Vestibulum ante ipsum primis in','2020-05-17 13:49:27',72,72),(73,'non, bibendum sed, est. Nunc laoreet lectus','2020-05-17 13:49:27',73,73),(74,'tristique','2020-05-17 13:49:27',74,74),(75,'Aliquam gravida mauris ut mi. Duis','2020-05-17 13:49:27',75,75),(76,'Nulla','2020-05-17 13:49:27',76,76),(77,'rutrum urna, nec luctus felis','2020-05-17 13:49:27',77,77),(78,'bibendum sed, est. Nunc laoreet lectus quis','2020-05-17 13:49:27',78,78),(79,'sapien. Nunc pulvinar arcu et pede.','2020-05-17 13:49:27',79,79),(80,'non magna.','2020-05-17 13:49:27',80,80),(81,'volutpat. Nulla dignissim. Maecenas','2020-05-17 13:49:27',81,81),(82,'facilisis.','2020-05-17 13:49:27',82,82),(83,'malesuada id, erat. Etiam vestibulum massa rutrum','2020-05-17 13:49:27',83,83),(84,'eros turpis non enim. Mauris','2020-05-17 13:49:27',84,84),(85,'ridiculus','2020-05-17 13:49:27',85,85),(86,'eu neque pellentesque massa lobortis ultrices. Vivamus','2020-05-17 13:49:27',86,86),(87,'dolor. Fusce feugiat. Lorem ipsum','2020-05-17 13:49:27',87,87),(88,'mauris sit amet','2020-05-17 13:49:27',88,88),(89,'tristique senectus','2020-05-17 13:49:27',89,89),(90,'suscipit, est ac facilisis','2020-05-17 13:49:27',90,90),(91,'Pellentesque habitant morbi tristique senectus','2020-05-17 13:49:27',91,91),(92,'ornare, facilisis eget, ipsum.','2020-05-17 13:49:27',92,92),(93,'orci lobortis augue scelerisque mollis. Phasellus','2020-05-17 13:49:27',93,93),(94,'elit elit fermentum risus, at','2020-05-17 13:49:27',94,94),(95,'tellus sem mollis dui, in sodales elit','2020-05-17 13:49:27',95,95),(96,'est. Nunc ullamcorper, velit','2020-05-17 13:49:27',96,96),(97,'amet massa. Quisque porttitor eros nec tellus. Nunc','2020-05-17 13:49:27',97,97),(98,'Nam consequat dolor vitae dolor.','2020-05-17 13:49:27',98,98),(99,'lacus. Mauris non dui nec','2020-05-17 13:49:27',99,99),(100,'ac metus vitae velit egestas lacinia. Sed','2020-05-17 13:49:27',100,100);
  /*!40000 ALTER TABLE `message` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `migration`
  --
  
  DROP TABLE IF EXISTS `migration`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `migration` (
    `version` varchar(180) NOT NULL,
    `apply_time` int DEFAULT NULL,
    PRIMARY KEY (`version`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migration`
  --
  
  LOCK TABLES `migration` WRITE;
  /*!40000 ALTER TABLE `migration` DISABLE KEYS */;
  INSERT INTO `migration` VALUES ('m000000_000000_base',1594024447),('m130524_201442_init',1594024835),('m190124_110200_add_verification_token_column_to_user_table',1594025096),('m200706_083022_add_online_column_to_userInfo',1594025096),('m200713_091801_change_executor_id_default_null',1594632124),('m200714_134917_change_city_id_column_to_task',1594734834),('m200715_145000_author_id_column_review_table',1594824810),('m200716_173451_name_column_attachments_table',1608973466),('m200727_062409_add_name_column_table_user',1608973466),('m200819_114347_execution_date_column_task_table',1608973466),('m200825_141244_is_null_price_field_task',1608973466),('m200903_072527_null_columns_user_info',1608973466),('m200903_105128_null_column_role_id_user_info',1608973466),('m200908_070545_remove_status_field_response_table',1608973466),('m200908_105032_set_not_require_fields_task_table',1608973467),('m200908_162141_add_status_field_response_table',1608973467),('m200908_173357_set_nullable_fields_response_table',1608973467),('m200908_190804_add_rating_fields_response_table',1608973467),('m201111_081757_longitude_latitude_to_string',1609052159),('m201111_084558_longitude_latitude_to_float',1609052159),('m201111_084900_longitude_latitude_to_float_2_10_precision',1609052159),('m201111_090734_longitude_latitude_to_double_precision',1609052159),('m201111_123721_rask_address_description',1609052159),('m201115_071706_geocode_field_task',1609052159),('m201227_070017_geocode_column_task_table',1609052496);
  /*!40000 ALTER TABLE `migration` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `notification`
  --
  
  DROP TABLE IF EXISTS `notification`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `notification` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `title` varchar(255) NOT NULL,
    `is_view` tinyint(1) NOT NULL,
    `url` varchar(255) NOT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `type` varchar(255) NOT NULL,
    `task_id` int NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `task_id` (`task_id`),
    CONSTRAINT `notification_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
    CONSTRAINT `notification_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `notification`
  --
  
  LOCK TABLES `notification` WRITE;
  /*!40000 ALTER TABLE `notification` DISABLE KEYS */;
  INSERT INTO `notification` VALUES (1,1,'consequat, lectus sit',1,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',1),(2,2,'risus. Duis a',0,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',2),(3,3,'Quisque libero lacus,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',3),(4,4,'et, lacinia vitae,',0,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',4),(5,5,'Suspendisse aliquet, sem',0,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',5),(6,6,'enim. Suspendisse aliquet,',0,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',6),(7,7,'Ut nec urna',0,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',7),(8,8,'pede blandit congue.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',8),(9,9,'torquent per conubia',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',9),(10,10,'augue, eu tempor',1,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',10),(11,11,'convallis ligula. Donec',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',11),(12,12,'lacus. Ut nec',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',12),(13,13,'fringilla cursus purus.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',13),(14,14,'non sapien molestie',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',14),(15,15,'fringilla purus mauris',1,'http://placehold.it/200x200','2020-05-17 13:48:44','green',15),(16,16,'egestas nunc sed',0,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',16),(17,17,'volutpat nunc sit',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',17),(18,18,'consectetuer ipsum nunc',0,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',18),(19,19,'in, cursus et,',0,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',19),(20,20,'et netus et',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',20),(21,21,'luctus ut, pellentesque',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',21),(22,22,'elit, dictum eu,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',22),(23,23,'Nullam vitae diam.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','green',23),(24,24,'enim. Mauris quis',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',24),(25,25,'vitae odio sagittis',1,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',25),(26,26,'quis diam. Pellentesque',0,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',26),(27,27,'Aliquam erat volutpat.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',27),(28,28,'massa. Integer vitae',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',28),(29,29,'magnis dis parturient',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',29),(30,30,'rutrum urna, nec',0,'http://placehold.it/200x200','2020-05-17 13:48:44','green',30),(31,31,'tempus, lorem fringilla',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',31),(32,32,'non, sollicitudin a,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',32),(33,33,'est. Nunc ullamcorper,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','green',33),(34,34,'lacus pede sagittis',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',34),(35,35,'cursus purus. Nullam',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',35),(36,36,'tellus. Phasellus elit',0,'http://placehold.it/200x200','2020-05-17 13:48:44','green',36),(37,37,'diam. Pellentesque habitant',1,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',37),(38,38,'facilisis facilisis, magna',1,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',38),(39,39,'dui quis accumsan',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',39),(40,40,'Curabitur consequat, lectus',0,'http://placehold.it/200x200','2020-05-17 13:48:44','green',40),(41,41,'cursus et, magna.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',41),(42,42,'egestas. Aliquam nec',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',42),(43,43,'Suspendisse sagittis. Nullam',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',43),(44,44,'dapibus quam quis',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',44),(45,45,'sed leo. Cras',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',45),(46,46,'Donec sollicitudin adipiscing',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',46),(47,47,'tincidunt aliquam arcu.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',47),(48,48,'justo. Praesent luctus.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',48),(49,49,'Curabitur dictum. Phasellus',0,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',49),(50,50,'Nam tempor diam',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',50),(51,51,'Cum sociis natoque',1,'http://placehold.it/200x200','2020-05-17 13:48:44','green',51),(52,52,'tempor erat neque',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',52),(53,53,'dolor egestas rhoncus.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',53),(54,54,'Sed diam lorem,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',54),(55,55,'eleifend. Cras sed',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',55),(56,56,'ante, iaculis nec,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','red',56),(57,57,'sit amet ornare',1,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',57),(58,58,'et pede. Nunc',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',58),(59,59,'erat volutpat. Nulla',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',59),(60,60,'Duis cursus, diam',1,'http://placehold.it/200x200','2020-05-17 13:48:44','red',60),(61,61,'Aliquam auctor, velit',1,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',61),(62,62,'erat, in consectetuer',1,'http://placehold.it/200x200','2020-05-17 13:48:44','red',62),(63,63,'nec metus facilisis',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',63),(64,64,'tellus. Phasellus elit',0,'http://placehold.it/200x200','2020-05-17 13:48:44','green',64),(65,65,'egestas. Sed pharetra,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','green',65),(66,66,'eu metus. In',0,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',66),(67,67,'non, vestibulum nec,',0,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',67),(68,68,'sem magna nec',0,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',68),(69,69,'ullamcorper. Duis at',1,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',69),(70,70,'a ultricies adipiscing,',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',70),(71,71,'mi felis, adipiscing',0,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',71),(72,72,'orci sem eget',0,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',72),(73,73,'nisi sem semper',0,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',73),(74,74,'Duis ac arcu.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',74),(75,75,'malesuada id, erat.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',75),(76,76,'tempor, est ac',0,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',76),(77,77,'rutrum urna, nec',1,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',77),(78,78,'lacinia vitae, sodales',0,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',78),(79,79,'Praesent eu dui.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',79),(80,80,'nulla. In tincidunt',1,'http://placehold.it/200x200','2020-05-17 13:48:44','red',80),(81,81,'velit. Quisque varius.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',81),(82,82,'ac libero nec',0,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',82),(83,83,'vel, vulputate eu,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','red',83),(84,84,'Curabitur massa. Vestibulum',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',84),(85,85,'diam dictum sapien.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',85),(86,86,'at sem molestie',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',86),(87,87,'nec tellus. Nunc',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',87),(88,88,'nulla. Integer urna.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','red',88),(89,89,'non, dapibus rutrum,',1,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',89),(90,90,'mi felis, adipiscing',1,'http://placehold.it/200x200','2020-05-17 13:48:44','orange',90),(91,91,'Donec sollicitudin adipiscing',0,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',91),(92,92,'sem eget massa.',1,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',92),(93,93,'vitae diam. Proin',1,'http://placehold.it/200x200','2020-05-17 13:48:44','yellow',93),(94,94,'elit. Aliquam auctor,',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',94),(95,95,'a odio semper',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',95),(96,96,'eros non enim',0,'http://placehold.it/200x200','2020-05-17 13:48:44','indigo',96),(97,97,'augue. Sed molestie.',0,'http://placehold.it/200x200','2020-05-17 13:48:44','violet',97),(98,98,'malesuada vel, venenatis',0,'http://placehold.it/200x200','2020-05-17 13:48:44','red',98),(99,99,'ligula tortor, dictum',0,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',99),(100,100,'lobortis mauris. Suspendisse',1,'http://placehold.it/200x200','2020-05-17 13:48:44','blue',100);
  /*!40000 ALTER TABLE `notification` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `portfolio_photo`
  --
  
  DROP TABLE IF EXISTS `portfolio_photo`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `portfolio_photo` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `title` varchar(255) NOT NULL,
    `description` varchar(255) NOT NULL,
    `url` varchar(255) NOT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `rating` int NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `portfolio_photo_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `portfolio_photo`
  --
  
  LOCK TABLES `portfolio_photo` WRITE;
  /*!40000 ALTER TABLE `portfolio_photo` DISABLE KEYS */;
  INSERT INTO `portfolio_photo` VALUES (1,1,'lobortis quis, pede.','libero mauris, aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus','http://placehold.it/200x200','2020-05-17 13:48:37',2),(2,2,'dis parturient montes,','mattis ornare, lectus ante dictum mi, ac mattis velit justo','http://placehold.it/200x200','2020-05-17 13:48:37',1),(3,3,'Curabitur vel lectus.','nascetur ridiculus mus. Aenean eget magna. Suspendisse tristique neque venenatis','http://placehold.it/200x200','2020-05-17 13:48:37',3),(4,4,'augue id ante','vestibulum. Mauris magna. Duis dignissim tempor arcu. Vestibulum ut eros','http://placehold.it/200x200','2020-05-17 13:48:37',2),(5,5,'pellentesque a, facilisis','ligula consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae,','http://placehold.it/200x200','2020-05-17 13:48:37',3),(6,6,'imperdiet dictum magna.','aliquet, sem ut cursus luctus, ipsum leo elementum sem, vitae','http://placehold.it/200x200','2020-05-17 13:48:37',0),(7,7,'diam at pretium','non, egestas a, dui. Cras pellentesque. Sed dictum. Proin eget','http://placehold.it/200x200','2020-05-17 13:48:37',3),(8,8,'et nunc. Quisque','quam. Pellentesque habitant morbi tristique senectus et netus et malesuada','http://placehold.it/200x200','2020-05-17 13:48:37',5),(9,9,'feugiat nec, diam.','nunc ac mattis ornare, lectus ante dictum mi, ac mattis','http://placehold.it/200x200','2020-05-17 13:48:37',2),(10,10,'Nulla tincidunt, neque','et, lacinia vitae, sodales at, velit. Pellentesque ultricies dignissim lacus.','http://placehold.it/200x200','2020-05-17 13:48:37',4),(11,11,'ligula. Nullam feugiat','mattis. Integer eu lacus. Quisque imperdiet, erat nonummy ultricies ornare,','http://placehold.it/200x200','2020-05-17 13:48:37',1),(12,12,'nec ante blandit','Mauris molestie pharetra nibh. Aliquam ornare, libero at auctor ullamcorper,','http://placehold.it/200x200','2020-05-17 13:48:37',0),(13,13,'tristique senectus et','aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus dapibus quam','http://placehold.it/200x200','2020-05-17 13:48:37',2),(14,14,'nonummy ipsum non','pharetra sed, hendrerit a, arcu. Sed et libero. Proin mi.','http://placehold.it/200x200','2020-05-17 13:48:37',0),(15,15,'orci, consectetuer euismod','a nunc. In at pede. Cras vulputate velit eu sem.','http://placehold.it/200x200','2020-05-17 13:48:37',4),(16,16,'sem elit, pharetra','mauris blandit mattis. Cras eget nisi dictum augue malesuada malesuada.','http://placehold.it/200x200','2020-05-17 13:48:37',4),(17,17,'nec, mollis vitae,','nascetur ridiculus mus. Proin vel arcu eu odio tristique pharetra.','http://placehold.it/200x200','2020-05-17 13:48:37',5),(18,18,'Nunc quis arcu','at risus. Nunc ac sem ut dolor dapibus gravida. Aliquam','http://placehold.it/200x200','2020-05-17 13:48:37',1),(19,19,'enim nec tempus','eu dolor egestas rhoncus. Proin nisl sem, consequat nec, mollis','http://placehold.it/200x200','2020-05-17 13:48:37',5),(20,20,'per inceptos hymenaeos.','In ornare sagittis felis. Donec tempor, est ac mattis semper,','http://placehold.it/200x200','2020-05-17 13:48:37',3),(21,21,'erat vitae risus.','nonummy. Fusce fermentum fermentum arcu. Vestibulum ante ipsum primis in','http://placehold.it/200x200','2020-05-17 13:48:37',2),(22,22,'Suspendisse eleifend. Cras','fermentum risus, at fringilla purus mauris a nunc. In at','http://placehold.it/200x200','2020-05-17 13:48:37',3),(23,23,'et libero. Proin','sed turpis nec mauris blandit mattis. Cras eget nisi dictum','http://placehold.it/200x200','2020-05-17 13:48:37',5),(24,24,'ligula. Donec luctus','semper rutrum. Fusce dolor quam, elementum at, egestas a, scelerisque','http://placehold.it/200x200','2020-05-17 13:48:37',3),(25,25,'eget, volutpat ornare,','consectetuer adipiscing elit. Curabitur sed tortor. Integer aliquam adipiscing lacus.','http://placehold.it/200x200','2020-05-17 13:48:37',4),(26,26,'tellus. Nunc lectus','at, egestas a, scelerisque sed, sapien. Nunc pulvinar arcu et','http://placehold.it/200x200','2020-05-17 13:48:37',2),(27,27,'velit in aliquet','dolor egestas rhoncus. Proin nisl sem, consequat nec, mollis vitae,','http://placehold.it/200x200','2020-05-17 13:48:37',5),(28,28,'dolor. Quisque tincidunt','cursus purus. Nullam scelerisque neque sed sem egestas blandit. Nam','http://placehold.it/200x200','2020-05-17 13:48:37',4),(29,29,'enim. Etiam gravida','mi pede, nonummy ut, molestie in, tempus eu, ligula. Aenean','http://placehold.it/200x200','2020-05-17 13:48:37',2),(30,30,'libero. Donec consectetuer','Duis volutpat nunc sit amet metus. Aliquam erat volutpat. Nulla','http://placehold.it/200x200','2020-05-17 13:48:37',4),(31,31,'libero dui nec','senectus et netus et malesuada fames ac turpis egestas. Fusce','http://placehold.it/200x200','2020-05-17 13:48:37',4),(32,32,'elit, pellentesque a,','interdum ligula eu enim. Etiam imperdiet dictum magna. Ut tincidunt','http://placehold.it/200x200','2020-05-17 13:48:37',4),(33,33,'egestas a, scelerisque','faucibus ut, nulla. Cras eu tellus eu augue porttitor interdum.','http://placehold.it/200x200','2020-05-17 13:48:37',2),(34,34,'lectus justo eu','sodales. Mauris blandit enim consequat purus. Maecenas libero est, congue','http://placehold.it/200x200','2020-05-17 13:48:37',1),(35,35,'feugiat placerat velit.','tempus eu, ligula. Aenean euismod mauris eu elit. Nulla facilisi.','http://placehold.it/200x200','2020-05-17 13:48:37',4),(36,36,'Donec nibh enim,','turpis nec mauris blandit mattis. Cras eget nisi dictum augue','http://placehold.it/200x200','2020-05-17 13:48:37',0),(37,37,'Integer tincidunt aliquam','mi enim, condimentum eget, volutpat ornare, facilisis eget, ipsum. Donec','http://placehold.it/200x200','2020-05-17 13:48:37',2),(38,38,'metus vitae velit','sagittis felis. Donec tempor, est ac mattis semper, dui lectus','http://placehold.it/200x200','2020-05-17 13:48:37',1),(39,39,'amet metus. Aliquam','eu dui. Cum sociis natoque penatibus et magnis dis parturient','http://placehold.it/200x200','2020-05-17 13:48:37',3),(40,40,'In at pede.','blandit at, nisi. Cum sociis natoque penatibus et magnis dis','http://placehold.it/200x200','2020-05-17 13:48:37',1),(41,41,'iaculis odio. Nam','Nam ac nulla. In tincidunt congue turpis. In condimentum. Donec','http://placehold.it/200x200','2020-05-17 13:48:37',4),(42,42,'eu eros. Nam','Vestibulum ante ipsum primis in faucibus orci luctus et ultrices','http://placehold.it/200x200','2020-05-17 13:48:37',5),(43,43,'Nam ac nulla.','eget lacus. Mauris non dui nec urna suscipit nonummy. Fusce','http://placehold.it/200x200','2020-05-17 13:48:37',3),(44,44,'ligula. Aliquam erat','et tristique pellentesque, tellus sem mollis dui, in sodales elit','http://placehold.it/200x200','2020-05-17 13:48:37',3),(45,45,'leo. Cras vehicula','montes, nascetur ridiculus mus. Aenean eget magna. Suspendisse tristique neque','http://placehold.it/200x200','2020-05-17 13:48:37',4),(46,46,'elit fermentum risus,','sed dictum eleifend, nunc risus varius orci, in consequat enim','http://placehold.it/200x200','2020-05-17 13:48:37',3),(47,47,'eget tincidunt dui','a feugiat tellus lorem eu metus. In lorem. Donec elementum,','http://placehold.it/200x200','2020-05-17 13:48:37',0),(48,48,'odio semper cursus.','neque. Nullam ut nisi a odio semper cursus. Integer mollis.','http://placehold.it/200x200','2020-05-17 13:48:37',5),(49,49,'lacus. Mauris non','dictum cursus. Nunc mauris elit, dictum eu, eleifend nec, malesuada','http://placehold.it/200x200','2020-05-17 13:48:37',0),(50,50,'dictum. Proin eget','aliquet lobortis, nisi nibh lacinia orci, consectetuer euismod est arcu','http://placehold.it/200x200','2020-05-17 13:48:37',2),(51,51,'Phasellus nulla. Integer','dui. Fusce diam nunc, ullamcorper eu, euismod ac, fermentum vel,','http://placehold.it/200x200','2020-05-17 13:48:37',4),(52,52,'dolor sit amet,','sapien. Nunc pulvinar arcu et pede. Nunc sed orci lobortis','http://placehold.it/200x200','2020-05-17 13:48:37',5),(53,53,'facilisis vitae, orci.','tempor diam dictum sapien. Aenean massa. Integer vitae nibh. Donec','http://placehold.it/200x200','2020-05-17 13:48:37',2),(54,54,'Nunc sed orci','a, facilisis non, bibendum sed, est. Nunc laoreet lectus quis','http://placehold.it/200x200','2020-05-17 13:48:37',1),(55,55,'aliquet molestie tellus.','placerat, orci lacus vestibulum lorem, sit amet ultricies sem magna','http://placehold.it/200x200','2020-05-17 13:48:37',5),(56,56,'dui nec urna','Phasellus vitae mauris sit amet lorem semper auctor. Mauris vel','http://placehold.it/200x200','2020-05-17 13:48:37',3),(57,57,'porttitor tellus non','sit amet, faucibus ut, nulla. Cras eu tellus eu augue','http://placehold.it/200x200','2020-05-17 13:48:37',5),(58,58,'est. Mauris eu','enim. Suspendisse aliquet, sem ut cursus luctus, ipsum leo elementum','http://placehold.it/200x200','2020-05-17 13:48:37',4),(59,59,'eu nibh vulputate','pretium neque. Morbi quis urna. Nunc quis arcu vel quam','http://placehold.it/200x200','2020-05-17 13:48:37',5),(60,60,'Vestibulum ante ipsum','arcu. Vestibulum ante ipsum primis in faucibus orci luctus et','http://placehold.it/200x200','2020-05-17 13:48:37',3),(61,61,'mauris ut mi.','non massa non ante bibendum ullamcorper. Duis cursus, diam at','http://placehold.it/200x200','2020-05-17 13:48:37',4),(62,62,'Nunc mauris elit,','Integer eu lacus. Quisque imperdiet, erat nonummy ultricies ornare, elit','http://placehold.it/200x200','2020-05-17 13:48:37',5),(63,63,'sed, sapien. Nunc','Cras vehicula aliquet libero. Integer in magna. Phasellus dolor elit,','http://placehold.it/200x200','2020-05-17 13:48:37',2),(64,64,'penatibus et magnis','dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus','http://placehold.it/200x200','2020-05-17 13:48:37',2),(65,65,'malesuada augue ut','Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna.','http://placehold.it/200x200','2020-05-17 13:48:37',5),(66,66,'sapien molestie orci','a felis ullamcorper viverra. Maecenas iaculis aliquet diam. Sed diam','http://placehold.it/200x200','2020-05-17 13:48:37',1),(67,67,'enim. Etiam imperdiet','ut aliquam iaculis, lacus pede sagittis augue, eu tempor erat','http://placehold.it/200x200','2020-05-17 13:48:37',2),(68,68,'habitant morbi tristique','ut erat. Sed nunc est, mollis non, cursus non, egestas','http://placehold.it/200x200','2020-05-17 13:48:37',5),(69,69,'fringilla. Donec feugiat','et netus et malesuada fames ac turpis egestas. Fusce aliquet','http://placehold.it/200x200','2020-05-17 13:48:37',5),(70,70,'egestas. Fusce aliquet','dui. Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate','http://placehold.it/200x200','2020-05-17 13:48:37',3),(71,71,'mi. Duis risus','nec, euismod in, dolor. Fusce feugiat. Lorem ipsum dolor sit','http://placehold.it/200x200','2020-05-17 13:48:37',1),(72,72,'ante bibendum ullamcorper.','felis. Donec tempor, est ac mattis semper, dui lectus rutrum','http://placehold.it/200x200','2020-05-17 13:48:37',3),(73,73,'Nullam nisl. Maecenas','nonummy ut, molestie in, tempus eu, ligula. Aenean euismod mauris','http://placehold.it/200x200','2020-05-17 13:48:37',3),(74,74,'mattis. Integer eu','In tincidunt congue turpis. In condimentum. Donec at arcu. Vestibulum','http://placehold.it/200x200','2020-05-17 13:48:37',4),(75,75,'adipiscing lobortis risus.','enim mi tempor lorem, eget mollis lectus pede et risus.','http://placehold.it/200x200','2020-05-17 13:48:37',3),(76,76,'viverra. Maecenas iaculis','senectus et netus et malesuada fames ac turpis egestas. Fusce','http://placehold.it/200x200','2020-05-17 13:48:37',2),(77,77,'Sed dictum. Proin','mauris blandit mattis. Cras eget nisi dictum augue malesuada malesuada.','http://placehold.it/200x200','2020-05-17 13:48:37',4),(78,78,'at, velit. Pellentesque','augue ut lacus. Nulla tincidunt, neque vitae semper egestas, urna','http://placehold.it/200x200','2020-05-17 13:48:37',2),(79,79,'magna. Phasellus dolor','scelerisque, lorem ipsum sodales purus, in molestie tortor nibh sit','http://placehold.it/200x200','2020-05-17 13:48:37',4),(80,80,'vel lectus. Cum','Suspendisse sagittis. Nullam vitae diam. Proin dolor. Nulla semper tellus','http://placehold.it/200x200','2020-05-17 13:48:37',4),(81,81,'egestas. Aliquam fringilla','a feugiat tellus lorem eu metus. In lorem. Donec elementum,','http://placehold.it/200x200','2020-05-17 13:48:37',2),(82,82,'mauris blandit mattis.','Suspendisse eleifend. Cras sed leo. Cras vehicula aliquet libero. Integer','http://placehold.it/200x200','2020-05-17 13:48:37',3),(83,83,'ipsum leo elementum','feugiat placerat velit. Quisque varius. Nam porttitor scelerisque neque. Nullam','http://placehold.it/200x200','2020-05-17 13:48:37',5),(84,84,'bibendum fermentum metus.','Quisque imperdiet, erat nonummy ultricies ornare, elit elit fermentum risus,','http://placehold.it/200x200','2020-05-17 13:48:37',4),(85,85,'Donec elementum, lorem','posuere at, velit. Cras lorem lorem, luctus ut, pellentesque eget,','http://placehold.it/200x200','2020-05-17 13:48:37',2),(86,86,'Phasellus dapibus quam','pharetra sed, hendrerit a, arcu. Sed et libero. Proin mi.','http://placehold.it/200x200','2020-05-17 13:48:37',3),(87,87,'adipiscing lacus. Ut','Mauris molestie pharetra nibh. Aliquam ornare, libero at auctor ullamcorper,','http://placehold.it/200x200','2020-05-17 13:48:37',3),(88,88,'Sed dictum. Proin','pharetra nibh. Aliquam ornare, libero at auctor ullamcorper, nisl arcu','http://placehold.it/200x200','2020-05-17 13:48:37',1),(89,89,'enim mi tempor','a, aliquet vel, vulputate eu, odio. Phasellus at augue id','http://placehold.it/200x200','2020-05-17 13:48:37',2),(90,90,'consectetuer ipsum nunc','cursus non, egestas a, dui. Cras pellentesque. Sed dictum. Proin','http://placehold.it/200x200','2020-05-17 13:48:37',2),(91,91,'amet nulla. Donec','sit amet, faucibus ut, nulla. Cras eu tellus eu augue','http://placehold.it/200x200','2020-05-17 13:48:37',4),(92,92,'gravida molestie arcu.','luctus sit amet, faucibus ut, nulla. Cras eu tellus eu','http://placehold.it/200x200','2020-05-17 13:48:37',1),(93,93,'Morbi sit amet','neque. In ornare sagittis felis. Donec tempor, est ac mattis','http://placehold.it/200x200','2020-05-17 13:48:37',2),(94,94,'nisl elementum purus,','pretium aliquet, metus urna convallis erat, eget tincidunt dui augue','http://placehold.it/200x200','2020-05-17 13:48:37',2),(95,95,'penatibus et magnis','elementum at, egestas a, scelerisque sed, sapien. Nunc pulvinar arcu','http://placehold.it/200x200','2020-05-17 13:48:37',1),(96,96,'cursus in, hendrerit','scelerisque neque. Nullam nisl. Maecenas malesuada fringilla est. Mauris eu','http://placehold.it/200x200','2020-05-17 13:48:37',5),(97,97,'eu metus. In','gravida sit amet, dapibus id, blandit at, nisi. Cum sociis','http://placehold.it/200x200','2020-05-17 13:48:37',4),(98,98,'orci lobortis augue','volutpat. Nulla dignissim. Maecenas ornare egestas ligula. Nullam feugiat placerat','http://placehold.it/200x200','2020-05-17 13:48:37',5),(99,99,'quam dignissim pharetra.','Aenean massa. Integer vitae nibh. Donec est mauris, rhoncus id,','http://placehold.it/200x200','2020-05-17 13:48:37',5),(100,100,'pharetra. Nam ac','Donec nibh enim, gravida sit amet, dapibus id, blandit at,','http://placehold.it/200x200','2020-05-17 13:48:37',1);
  /*!40000 ALTER TABLE `portfolio_photo` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `response`
  --
  
  DROP TABLE IF EXISTS `response`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `response` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `price` varchar(255) DEFAULT NULL,
    `comment` varchar(255) DEFAULT NULL,
    `responsed_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `task_id` int NOT NULL,
    `status` varchar(255) DEFAULT NULL,
    `rating` int DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `task_id` (`task_id`),
    CONSTRAINT `response_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
    CONSTRAINT `response_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `response`
  --
  
  LOCK TABLES `response` WRITE;
  /*!40000 ALTER TABLE `response` DISABLE KEYS */;
  INSERT INTO `response` VALUES (1,1,'4052','arcu eu odio tristique pharetra. Quisque ac libero nec ligula','2020-05-17 13:48:30',1,NULL,NULL),(2,2,'2059','at sem molestie sodales. Mauris blandit enim consequat purus. Maecenas','2020-05-17 13:48:30',2,NULL,NULL),(3,3,'32003','in faucibus orci luctus et ultrices posuere cubilia Curae; Phasellus','2020-05-17 13:48:30',3,NULL,NULL),(4,4,'85460','non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem ipsum','2020-05-17 13:48:30',4,NULL,NULL),(5,5,'51128','placerat, orci lacus vestibulum lorem, sit amet ultricies sem magna','2020-05-17 13:48:30',5,NULL,NULL),(6,6,'37474','malesuada fringilla est. Mauris eu turpis. Nulla aliquet. Proin velit.','2020-05-17 13:48:30',6,NULL,NULL),(7,7,'50636','tristique pharetra. Quisque ac libero nec ligula consectetuer rhoncus. Nullam','2020-05-17 13:48:30',7,NULL,NULL),(8,8,'17320','Phasellus at augue id ante dictum cursus. Nunc mauris elit,','2020-05-17 13:48:30',8,NULL,NULL),(9,9,'1681','Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla','2020-05-17 13:48:30',9,NULL,NULL),(10,10,'12179','Quisque imperdiet, erat nonummy ultricies ornare, elit elit fermentum risus,','2020-05-17 13:48:30',10,NULL,NULL),(11,11,'80485','rutrum magna. Cras convallis convallis dolor. Quisque tincidunt pede ac','2020-05-17 13:48:30',11,NULL,NULL),(12,12,'63198','dignissim tempor arcu. Vestibulum ut eros non enim commodo hendrerit.','2020-05-17 13:48:30',12,NULL,NULL),(13,13,'95395','fermentum arcu. Vestibulum ante ipsum primis in faucibus orci luctus','2020-05-17 13:48:30',13,NULL,NULL),(14,14,'39842','Sed auctor odio a purus. Duis elementum, dui quis accumsan','2020-05-17 13:48:30',14,NULL,NULL),(15,15,'69784','luctus et ultrices posuere cubilia Curae; Phasellus ornare. Fusce mollis.','2020-05-17 13:48:30',15,NULL,NULL),(16,16,'31929','lobortis. Class aptent taciti sociosqu ad litora torquent per conubia','2020-05-17 13:48:30',16,NULL,NULL),(17,17,'63724','vitae aliquam eros turpis non enim. Mauris quis turpis vitae','2020-05-17 13:48:30',17,NULL,NULL),(18,18,'81394','Nunc ullamcorper, velit in aliquet lobortis, nisi nibh lacinia orci,','2020-05-17 13:48:30',18,NULL,NULL),(19,19,'9541','sodales nisi magna sed dui. Fusce aliquam, enim nec tempus','2020-05-17 13:48:30',19,NULL,NULL),(20,20,'72139','diam at pretium aliquet, metus urna convallis erat, eget tincidunt','2020-05-17 13:48:30',20,NULL,NULL),(21,21,'21552','justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate,','2020-05-17 13:48:30',21,NULL,NULL),(22,22,'48758','enim. Mauris quis turpis vitae purus gravida sagittis. Duis gravida.','2020-05-17 13:48:30',22,NULL,NULL),(23,23,'9942','vestibulum massa rutrum magna. Cras convallis convallis dolor. Quisque tincidunt','2020-05-17 13:48:30',23,NULL,NULL),(24,24,'64939','venenatis lacus. Etiam bibendum fermentum metus. Aenean sed pede nec','2020-05-17 13:48:30',24,NULL,NULL),(25,25,'10493','dolor. Quisque tincidunt pede ac urna. Ut tincidunt vehicula risus.','2020-05-17 13:48:30',25,NULL,NULL),(26,26,'21584','Pellentesque ut ipsum ac mi eleifend egestas. Sed pharetra, felis','2020-05-17 13:48:30',26,NULL,NULL),(27,27,'35734','Aenean eget magna. Suspendisse tristique neque venenatis lacus. Etiam bibendum','2020-05-17 13:48:30',27,NULL,NULL),(28,28,'61575','feugiat non, lobortis quis, pede. Suspendisse dui. Fusce diam nunc,','2020-05-17 13:48:30',28,NULL,NULL),(29,29,'16851','lacinia. Sed congue, elit sed consequat auctor, nunc nulla vulputate','2020-05-17 13:48:30',29,NULL,NULL),(30,30,'51952','et magnis dis parturient montes, nascetur ridiculus mus. Aenean eget','2020-05-17 13:48:30',30,NULL,NULL),(31,31,'37823','non leo. Vivamus nibh dolor, nonummy ac, feugiat non, lobortis','2020-05-17 13:48:30',31,NULL,NULL),(32,32,'63548','natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.','2020-05-17 13:48:30',32,NULL,NULL),(33,33,'5911','dapibus quam quis diam. Pellentesque habitant morbi tristique senectus et','2020-05-17 13:48:30',33,NULL,NULL),(34,34,'87133','commodo hendrerit. Donec porttitor tellus non magna. Nam ligula elit,','2020-05-17 13:48:30',34,NULL,NULL),(35,35,'34098','gravida. Aliquam tincidunt, nunc ac mattis ornare, lectus ante dictum','2020-05-17 13:48:30',35,NULL,NULL),(36,36,'48281','ornare, libero at auctor ullamcorper, nisl arcu iaculis enim, sit','2020-05-17 13:48:30',36,NULL,NULL),(37,37,'9951','In mi pede, nonummy ut, molestie in, tempus eu, ligula.','2020-05-17 13:48:30',37,NULL,NULL),(38,38,'40916','neque non quam. Pellentesque habitant morbi tristique senectus et netus','2020-05-17 13:48:30',38,NULL,NULL),(39,39,'22821','facilisis eget, ipsum. Donec sollicitudin adipiscing ligula. Aenean gravida nunc','2020-05-17 13:48:30',39,NULL,NULL),(40,40,'27484','Fusce mi lorem, vehicula et, rutrum eu, ultrices sit amet,','2020-05-17 13:48:30',40,NULL,NULL),(41,41,'58628','sit amet, faucibus ut, nulla. Cras eu tellus eu augue','2020-05-17 13:48:30',41,NULL,NULL),(42,42,'7688','Cras vehicula aliquet libero. Integer in magna. Phasellus dolor elit,','2020-05-17 13:48:30',42,NULL,NULL),(43,43,'23639','at sem molestie sodales. Mauris blandit enim consequat purus. Maecenas','2020-05-17 13:48:30',43,NULL,NULL),(44,44,'91234','justo. Proin non massa non ante bibendum ullamcorper. Duis cursus,','2020-05-17 13:48:30',44,NULL,NULL),(45,45,'40649','semper, dui lectus rutrum urna, nec luctus felis purus ac','2020-05-17 13:48:30',45,NULL,NULL),(46,46,'42348','porttitor tellus non magna. Nam ligula elit, pretium et, rutrum','2020-05-17 13:48:30',46,NULL,NULL),(47,47,'9226','in consequat enim diam vel arcu. Curabitur ut odio vel','2020-05-17 13:48:30',47,NULL,NULL),(48,48,'84375','natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.','2020-05-17 13:48:30',48,NULL,NULL),(49,49,'59905','turpis egestas. Aliquam fringilla cursus purus. Nullam scelerisque neque sed','2020-05-17 13:48:30',49,NULL,NULL),(50,50,'42441','eget tincidunt dui augue eu tellus. Phasellus elit pede, malesuada','2020-05-17 13:48:30',50,NULL,NULL),(51,51,'21371','cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis','2020-05-17 13:48:30',51,NULL,NULL),(52,52,'65891','velit. Quisque varius. Nam porttitor scelerisque neque. Nullam nisl. Maecenas','2020-05-17 13:48:30',52,NULL,NULL),(53,53,'19122','dolor dolor, tempus non, lacinia at, iaculis quis, pede. Praesent','2020-05-17 13:48:30',53,NULL,NULL),(54,54,'70185','quis urna. Nunc quis arcu vel quam dignissim pharetra. Nam','2020-05-17 13:48:30',54,NULL,NULL),(55,55,'12406','aliquam, enim nec tempus scelerisque, lorem ipsum sodales purus, in','2020-05-17 13:48:30',55,NULL,NULL),(56,56,'89991','accumsan neque et nunc. Quisque ornare tortor at risus. Nunc','2020-05-17 13:48:30',56,NULL,NULL),(57,57,'56414','vitae mauris sit amet lorem semper auctor. Mauris vel turpis.','2020-05-17 13:48:30',57,NULL,NULL),(58,58,'29434','sem magna nec quam. Curabitur vel lectus. Cum sociis natoque','2020-05-17 13:48:30',58,NULL,NULL),(59,59,'3213','gravida sit amet, dapibus id, blandit at, nisi. Cum sociis','2020-05-17 13:48:30',59,NULL,NULL),(60,60,'29962','eu tempor erat neque non quam. Pellentesque habitant morbi tristique','2020-05-17 13:48:30',60,NULL,NULL),(61,61,'693','dolor. Nulla semper tellus id nunc interdum feugiat. Sed nec','2020-05-17 13:48:30',61,NULL,NULL),(62,62,'54259','ac turpis egestas. Fusce aliquet magna a neque. Nullam ut','2020-05-17 13:48:30',62,NULL,NULL),(63,63,'29280','eros nec tellus. Nunc lectus pede, ultrices a, auctor non,','2020-05-17 13:48:30',63,NULL,NULL),(64,64,'86182','Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla','2020-05-17 13:48:30',64,NULL,NULL),(65,65,'39577','neque sed dictum eleifend, nunc risus varius orci, in consequat','2020-05-17 13:48:30',65,NULL,NULL),(66,66,'16471','vulputate, risus a ultricies adipiscing, enim mi tempor lorem, eget','2020-05-17 13:48:30',66,NULL,NULL),(67,67,'74365','adipiscing lobortis risus. In mi pede, nonummy ut, molestie in,','2020-05-17 13:48:30',67,NULL,NULL),(68,68,'58225','sagittis semper. Nam tempor diam dictum sapien. Aenean massa. Integer','2020-05-17 13:48:30',68,NULL,NULL),(69,69,'83670','tincidunt congue turpis. In condimentum. Donec at arcu. Vestibulum ante','2020-05-17 13:48:30',69,NULL,NULL),(70,70,'82487','amet, faucibus ut, nulla. Cras eu tellus eu augue porttitor','2020-05-17 13:48:30',70,NULL,NULL),(71,71,'2266','faucibus ut, nulla. Cras eu tellus eu augue porttitor interdum.','2020-05-17 13:48:30',71,NULL,NULL),(72,72,'7723','ullamcorper. Duis at lacus. Quisque purus sapien, gravida non, sollicitudin','2020-05-17 13:48:30',72,NULL,NULL),(73,73,'443','nibh lacinia orci, consectetuer euismod est arcu ac orci. Ut','2020-05-17 13:48:30',73,NULL,NULL),(74,74,'95921','erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus nulla.','2020-05-17 13:48:30',74,NULL,NULL),(75,75,'28281','eleifend egestas. Sed pharetra, felis eget varius ultrices, mauris ipsum','2020-05-17 13:48:30',75,NULL,NULL),(76,76,'38563','non enim. Mauris quis turpis vitae purus gravida sagittis. Duis','2020-05-17 13:48:30',76,NULL,NULL),(77,77,'27610','tincidunt tempus risus. Donec egestas. Duis ac arcu. Nunc mauris.','2020-05-17 13:48:30',77,NULL,NULL),(78,78,'32237','dis parturient montes, nascetur ridiculus mus. Proin vel arcu eu','2020-05-17 13:48:30',78,NULL,NULL),(79,79,'87837','sapien, gravida non, sollicitudin a, malesuada id, erat. Etiam vestibulum','2020-05-17 13:48:30',79,NULL,NULL),(80,80,'88216','velit justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor','2020-05-17 13:48:30',80,NULL,NULL),(81,81,'95253','non, lacinia at, iaculis quis, pede. Praesent eu dui. Cum','2020-05-17 13:48:30',81,NULL,NULL),(82,82,'49893','dolor quam, elementum at, egestas a, scelerisque sed, sapien. Nunc','2020-05-17 13:48:30',82,NULL,NULL),(83,83,'20117','risus, at fringilla purus mauris a nunc. In at pede.','2020-05-17 13:48:30',83,NULL,NULL),(84,84,'37351','et tristique pellentesque, tellus sem mollis dui, in sodales elit','2020-05-17 13:48:30',84,NULL,NULL),(85,85,'50745','non, lacinia at, iaculis quis, pede. Praesent eu dui. Cum','2020-05-17 13:48:30',85,NULL,NULL),(86,86,'47417','luctus lobortis. Class aptent taciti sociosqu ad litora torquent per','2020-05-17 13:48:30',86,NULL,NULL),(87,87,'82501','Nam tempor diam dictum sapien. Aenean massa. Integer vitae nibh.','2020-05-17 13:48:30',87,NULL,NULL),(88,88,'40024','et magnis dis parturient montes, nascetur ridiculus mus. Proin vel','2020-05-17 13:48:30',88,NULL,NULL),(89,89,'55096','vel, faucibus id, libero. Donec consectetuer mauris id sapien. Cras','2020-05-17 13:48:30',89,NULL,NULL),(90,90,'76393','Mauris non dui nec urna suscipit nonummy. Fusce fermentum fermentum','2020-05-17 13:48:30',90,NULL,NULL),(91,91,'83541','pede sagittis augue, eu tempor erat neque non quam. Pellentesque','2020-05-17 13:48:30',91,NULL,NULL),(92,92,'5046','nec, diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis','2020-05-17 13:48:30',92,NULL,NULL),(93,93,'50169','Nam ligula elit, pretium et, rutrum non, hendrerit id, ante.','2020-05-17 13:48:30',93,NULL,NULL),(94,94,'88192','ullamcorper, nisl arcu iaculis enim, sit amet ornare lectus justo','2020-05-17 13:48:30',94,NULL,NULL),(95,95,'41173','nunc id enim. Curabitur massa. Vestibulum accumsan neque et nunc.','2020-05-17 13:48:30',95,NULL,NULL),(96,96,'9362','sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus','2020-05-17 13:48:30',96,NULL,NULL),(97,97,'18201','Vivamus euismod urna. Nullam lobortis quam a felis ullamcorper viverra.','2020-05-17 13:48:30',97,NULL,NULL),(98,98,'54947','venenatis vel, faucibus id, libero. Donec consectetuer mauris id sapien.','2020-05-17 13:48:30',98,NULL,NULL),(99,99,'96006','tempus non, lacinia at, iaculis quis, pede. Praesent eu dui.','2020-05-17 13:48:30',99,NULL,NULL),(100,100,'98175','magna sed dui. Fusce aliquam, enim nec tempus scelerisque, lorem','2020-05-17 13:48:30',100,NULL,NULL);
  /*!40000 ALTER TABLE `response` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `review`
  --
  
  DROP TABLE IF EXISTS `review`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `review` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `title` varchar(255) NOT NULL,
    `description` varchar(255) NOT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `rating` int NOT NULL,
    `task_id` int NOT NULL,
    `author_id` int DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `task_id` (`task_id`),
    CONSTRAINT `review_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
    CONSTRAINT `review_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `review`
  --
  
  LOCK TABLES `review` WRITE;
  /*!40000 ALTER TABLE `review` DISABLE KEYS */;
  INSERT INTO `review` VALUES (1,1,'metus sit amet','cursus et, magna. Praesent interdum ligula eu enim. Etiam imperdiet','2020-05-17 13:48:25',4,1,NULL),(2,1,'diam','Donec consectetuer mauris id sapien. Cras dolor dolor, tempus non,','2020-05-17 13:48:25',5,2,NULL),(3,1,'dolor, nonummy ac, feugiat','blandit. Nam nulla magna, malesuada vel, convallis in, cursus et,','2020-05-17 13:48:25',1,3,NULL),(4,1,'netus et malesuada fames','a, malesuada id, erat. Etiam vestibulum massa rutrum magna. Cras','2020-05-17 13:48:25',2,4,NULL),(5,5,'Duis elementum, dui quis','at augue id ante dictum cursus. Nunc mauris elit, dictum','2020-05-17 13:48:25',0,5,NULL),(6,6,'a, arcu.','a mi fringilla mi lacinia mattis. Integer eu lacus. Quisque','2020-05-17 13:48:25',2,6,NULL),(7,7,'lectus. Nullam suscipit,','metus. Aenean sed pede nec ante blandit viverra. Donec tempus,','2020-05-17 13:48:25',1,7,NULL),(8,8,'massa.','tellus, imperdiet non, vestibulum nec, euismod in, dolor. Fusce feugiat.','2020-05-17 13:48:25',3,8,NULL),(9,9,'Proin vel arcu','In at pede. Cras vulputate velit eu sem. Pellentesque ut','2020-05-17 13:48:25',0,9,NULL),(10,10,'Integer','Aliquam ultrices iaculis odio. Nam interdum enim non nisi. Aenean','2020-05-17 13:48:25',0,10,NULL),(11,11,'vitae,','lorem ipsum sodales purus, in molestie tortor nibh sit amet','2020-05-17 13:48:25',3,11,NULL),(12,12,'vitae velit','sapien molestie orci tincidunt adipiscing. Mauris molestie pharetra nibh. Aliquam','2020-05-17 13:48:25',5,12,NULL),(13,13,'ante, iaculis nec,','massa rutrum magna. Cras convallis convallis dolor. Quisque tincidunt pede','2020-05-17 13:48:25',3,13,NULL),(14,14,'felis, adipiscing fringilla, porttitor','fermentum arcu. Vestibulum ante ipsum primis in faucibus orci luctus','2020-05-17 13:48:25',5,14,NULL),(15,15,'sociis natoque','non ante bibendum ullamcorper. Duis cursus, diam at pretium aliquet,','2020-05-17 13:48:25',4,15,NULL),(16,16,'Morbi','odio. Phasellus at augue id ante dictum cursus. Nunc mauris','2020-05-17 13:48:25',5,16,NULL),(17,17,'ullamcorper','elementum sem, vitae aliquam eros turpis non enim. Mauris quis','2020-05-17 13:48:25',0,17,NULL),(18,18,'nisi. Aenean eget metus.','Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper','2020-05-17 13:48:25',3,18,NULL),(19,19,'risus quis diam','Sed eget lacus. Mauris non dui nec urna suscipit nonummy.','2020-05-17 13:48:25',2,19,NULL),(20,20,'Mauris quis turpis vitae','nec, eleifend non, dapibus rutrum, justo. Praesent luctus. Curabitur egestas','2020-05-17 13:48:25',1,20,NULL),(21,21,'nec, diam. Duis mi','eleifend. Cras sed leo. Cras vehicula aliquet libero. Integer in','2020-05-17 13:48:25',0,21,NULL),(22,22,'metus. In nec','nec tempus mauris erat eget ipsum. Suspendisse sagittis. Nullam vitae','2020-05-17 13:48:25',5,22,NULL),(23,23,'sollicitudin a, malesuada','ut, sem. Nulla interdum. Curabitur dictum. Phasellus in felis. Nulla','2020-05-17 13:48:25',1,23,NULL),(24,24,'vitae','mus. Aenean eget magna. Suspendisse tristique neque venenatis lacus. Etiam','2020-05-17 13:48:25',0,24,NULL),(25,25,'et, euismod','congue a, aliquet vel, vulputate eu, odio. Phasellus at augue','2020-05-17 13:48:25',1,25,NULL),(26,26,'Aliquam gravida mauris','arcu imperdiet ullamcorper. Duis at lacus. Quisque purus sapien, gravida','2020-05-17 13:48:25',4,26,NULL),(27,27,'at risus. Nunc','arcu. Vestibulum ante ipsum primis in faucibus orci luctus et','2020-05-17 13:48:25',0,27,NULL),(28,28,'velit. Quisque varius.','consectetuer adipiscing elit. Etiam laoreet, libero et tristique pellentesque, tellus','2020-05-17 13:48:25',4,28,NULL),(29,29,'non arcu. Vivamus sit','est. Nunc ullamcorper, velit in aliquet lobortis, nisi nibh lacinia','2020-05-17 13:48:25',5,29,NULL),(30,30,'rutrum','iaculis, lacus pede sagittis augue, eu tempor erat neque non','2020-05-17 13:48:25',1,30,NULL),(31,31,'vitae, posuere','auctor ullamcorper, nisl arcu iaculis enim, sit amet ornare lectus','2020-05-17 13:48:25',2,31,NULL),(32,32,'vitae, aliquet','rutrum magna. Cras convallis convallis dolor. Quisque tincidunt pede ac','2020-05-17 13:48:25',2,32,NULL),(33,33,'velit justo','dolor. Nulla semper tellus id nunc interdum feugiat. Sed nec','2020-05-17 13:48:25',5,33,NULL),(34,34,'purus. Duis elementum, dui','egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla','2020-05-17 13:48:25',4,34,NULL),(35,35,'lectus convallis est, vitae','nec metus facilisis lorem tristique aliquet. Phasellus fermentum convallis ligula.','2020-05-17 13:48:25',5,35,NULL),(36,36,'posuere cubilia','a ultricies adipiscing, enim mi tempor lorem, eget mollis lectus','2020-05-17 13:48:25',4,36,NULL),(37,37,'leo.','commodo at, libero. Morbi accumsan laoreet ipsum. Curabitur consequat, lectus','2020-05-17 13:48:25',4,37,NULL),(38,38,'ac','odio sagittis semper. Nam tempor diam dictum sapien. Aenean massa.','2020-05-17 13:48:25',5,38,NULL),(39,39,'eget,','Sed pharetra, felis eget varius ultrices, mauris ipsum porta elit,','2020-05-17 13:48:25',3,39,NULL),(40,40,'Nulla facilisi. Sed','magnis dis parturient montes, nascetur ridiculus mus. Proin vel arcu','2020-05-17 13:48:25',2,40,NULL),(41,41,'ante. Maecenas','diam. Duis mi enim, condimentum eget, volutpat ornare, facilisis eget,','2020-05-17 13:48:25',2,41,NULL),(42,42,'id','Nam ligula elit, pretium et, rutrum non, hendrerit id, ante.','2020-05-17 13:48:25',5,42,NULL),(43,43,'felis eget','vel sapien imperdiet ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt','2020-05-17 13:48:25',1,43,NULL),(44,44,'nisl','pellentesque eget, dictum placerat, augue. Sed molestie. Sed id risus','2020-05-17 13:48:25',2,44,NULL),(45,45,'vel sapien imperdiet','scelerisque neque sed sem egestas blandit. Nam nulla magna, malesuada','2020-05-17 13:48:25',4,45,NULL),(46,46,'pharetra ut,','felis. Donec tempor, est ac mattis semper, dui lectus rutrum','2020-05-17 13:48:25',2,46,NULL),(47,47,'Donec tempor, est','odio vel est tempor bibendum. Donec felis orci, adipiscing non,','2020-05-17 13:48:25',4,47,NULL),(48,48,'Cras dictum ultricies ligula.','enim. Mauris quis turpis vitae purus gravida sagittis. Duis gravida.','2020-05-17 13:48:25',1,48,NULL),(49,49,'ut, molestie','a mi fringilla mi lacinia mattis. Integer eu lacus. Quisque','2020-05-17 13:48:25',3,49,NULL),(50,50,'aliquam','magna sed dui. Fusce aliquam, enim nec tempus scelerisque, lorem','2020-05-17 13:48:25',1,50,NULL),(51,51,'arcu eu','Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna.','2020-05-17 13:48:25',2,51,NULL),(52,52,'Praesent interdum ligula','malesuada vel, venenatis vel, faucibus id, libero. Donec consectetuer mauris','2020-05-17 13:48:25',5,52,NULL),(53,53,'libero et tristique pellentesque,','nunc sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse','2020-05-17 13:48:25',5,53,NULL),(54,54,'sem. Nulla interdum.','luctus aliquet odio. Etiam ligula tortor, dictum eu, placerat eget,','2020-05-17 13:48:25',1,54,NULL),(55,55,'aliquet molestie tellus. Aenean','gravida molestie arcu. Sed eu nibh vulputate mauris sagittis placerat.','2020-05-17 13:48:25',0,55,NULL),(56,56,'Proin','elit erat vitae risus. Duis a mi fringilla mi lacinia','2020-05-17 13:48:25',2,56,NULL),(57,57,'mauris elit, dictum','arcu. Curabitur ut odio vel est tempor bibendum. Donec felis','2020-05-17 13:48:25',5,57,NULL),(58,58,'tempus mauris','feugiat non, lobortis quis, pede. Suspendisse dui. Fusce diam nunc,','2020-05-17 13:48:25',4,58,NULL),(59,59,'risus, at fringilla purus','velit justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor','2020-05-17 13:48:25',0,59,NULL),(60,60,'Nulla aliquet.','nec, malesuada ut, sem. Nulla interdum. Curabitur dictum. Phasellus in','2020-05-17 13:48:25',5,60,NULL),(61,61,'gravida non,','scelerisque neque sed sem egestas blandit. Nam nulla magna, malesuada','2020-05-17 13:48:25',2,61,NULL),(62,62,'et arcu imperdiet','elementum, dui quis accumsan convallis, ante lectus convallis est, vitae','2020-05-17 13:48:25',0,62,NULL),(63,63,'Aenean euismod mauris eu','arcu iaculis enim, sit amet ornare lectus justo eu arcu.','2020-05-17 13:48:25',0,63,NULL),(64,64,'sit amet lorem','Fusce diam nunc, ullamcorper eu, euismod ac, fermentum vel, mauris.','2020-05-17 13:48:25',3,64,NULL),(65,65,'felis eget varius','cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis','2020-05-17 13:48:25',1,65,NULL),(66,66,'ac','Proin dolor. Nulla semper tellus id nunc interdum feugiat. Sed','2020-05-17 13:48:25',1,66,NULL),(67,67,'a, facilisis','facilisis eget, ipsum. Donec sollicitudin adipiscing ligula. Aenean gravida nunc','2020-05-17 13:48:25',3,67,NULL),(68,68,'ipsum','ornare lectus justo eu arcu. Morbi sit amet massa. Quisque','2020-05-17 13:48:25',0,68,NULL),(69,69,'dui lectus rutrum','Aenean eget metus. In nec orci. Donec nibh. Quisque nonummy','2020-05-17 13:48:25',0,69,NULL),(70,70,'lectus convallis est,','iaculis nec, eleifend non, dapibus rutrum, justo. Praesent luctus. Curabitur','2020-05-17 13:48:25',3,70,NULL),(71,71,'lobortis tellus justo sit','imperdiet non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem','2020-05-17 13:48:25',1,71,NULL),(72,72,'semper cursus. Integer','congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit','2020-05-17 13:48:25',4,72,NULL),(73,73,'turpis. In','feugiat tellus lorem eu metus. In lorem. Donec elementum, lorem','2020-05-17 13:48:25',2,73,NULL),(74,74,'dolor dapibus gravida. Aliquam','sodales elit erat vitae risus. Duis a mi fringilla mi','2020-05-17 13:48:25',0,74,NULL),(75,75,'vel','tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque','2020-05-17 13:48:25',4,75,NULL),(76,76,'mi enim, condimentum eget,','faucibus orci luctus et ultrices posuere cubilia Curae; Donec tincidunt.','2020-05-17 13:48:25',1,76,NULL),(77,77,'eu,','neque venenatis lacus. Etiam bibendum fermentum metus. Aenean sed pede','2020-05-17 13:48:25',3,77,NULL),(78,78,'vehicula et, rutrum','In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas','2020-05-17 13:48:25',5,78,NULL),(79,79,'ac, eleifend vitae, erat.','commodo auctor velit. Aliquam nisl. Nulla eu neque pellentesque massa','2020-05-17 13:48:25',3,79,NULL),(80,80,'aliquet magna a','Praesent interdum ligula eu enim. Etiam imperdiet dictum magna. Ut','2020-05-17 13:48:25',0,80,NULL),(81,81,'Donec tincidunt. Donec vitae','ac tellus. Suspendisse sed dolor. Fusce mi lorem, vehicula et,','2020-05-17 13:48:25',2,81,NULL),(82,82,'eget','dapibus gravida. Aliquam tincidunt, nunc ac mattis ornare, lectus ante','2020-05-17 13:48:25',5,82,NULL),(83,83,'pulvinar arcu et pede.','dapibus rutrum, justo. Praesent luctus. Curabitur egestas nunc sed libero.','2020-05-17 13:48:25',3,83,NULL),(84,84,'magna nec','tincidunt vehicula risus. Nulla eget metus eu erat semper rutrum.','2020-05-17 13:48:25',5,84,NULL),(85,85,'lectus','mi lorem, vehicula et, rutrum eu, ultrices sit amet, risus.','2020-05-17 13:48:25',1,85,NULL),(86,86,'non dui nec','congue turpis. In condimentum. Donec at arcu. Vestibulum ante ipsum','2020-05-17 13:48:25',2,86,NULL),(87,87,'eget, venenatis a, magna.','accumsan convallis, ante lectus convallis est, vitae sodales nisi magna','2020-05-17 13:48:25',1,87,NULL),(88,88,'quis turpis vitae','egestas. Fusce aliquet magna a neque. Nullam ut nisi a','2020-05-17 13:48:25',3,88,NULL),(89,89,'a odio semper cursus.','vel turpis. Aliquam adipiscing lobortis risus. In mi pede, nonummy','2020-05-17 13:48:25',4,89,NULL),(90,90,'Sed nec metus','ipsum. Suspendisse sagittis. Nullam vitae diam. Proin dolor. Nulla semper','2020-05-17 13:48:25',5,90,NULL),(91,91,'in sodales elit','id risus quis diam luctus lobortis. Class aptent taciti sociosqu','2020-05-17 13:48:25',1,91,NULL),(92,92,'elit. Curabitur','Morbi non sapien molestie orci tincidunt adipiscing. Mauris molestie pharetra','2020-05-17 13:48:25',5,92,NULL),(93,93,'dis parturient','vulputate ullamcorper magna. Sed eu eros. Nam consequat dolor vitae','2020-05-17 13:48:25',1,93,NULL),(94,94,'euismod enim. Etiam gravida','molestie tortor nibh sit amet orci. Ut sagittis lobortis mauris.','2020-05-17 13:48:25',1,94,NULL),(95,95,'Mauris vestibulum, neque','Nulla tincidunt, neque vitae semper egestas, urna justo faucibus lectus,','2020-05-17 13:48:25',5,95,NULL),(96,96,'gravida. Aliquam tincidunt, nunc','egestas. Aliquam fringilla cursus purus. Nullam scelerisque neque sed sem','2020-05-17 13:48:25',2,96,NULL),(97,97,'quis,','consequat enim diam vel arcu. Curabitur ut odio vel est','2020-05-17 13:48:25',0,97,NULL),(98,98,'malesuada vel,','senectus et netus et malesuada fames ac turpis egestas. Aliquam','2020-05-17 13:48:25',1,98,NULL),(99,99,'scelerisque scelerisque','Fusce diam nunc, ullamcorper eu, euismod ac, fermentum vel, mauris.','2020-05-17 13:48:25',2,99,NULL),(100,100,'vel, venenatis vel,','scelerisque neque sed sem egestas blandit. Nam nulla magna, malesuada','2020-05-17 13:48:25',4,100,NULL);
  /*!40000 ALTER TABLE `review` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `site_settings`
  --
  
  DROP TABLE IF EXISTS `site_settings`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `site_settings` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `new_message` tinyint(1) DEFAULT '1',
    `actions_in_task` tinyint(1) DEFAULT '1',
    `show_contacts_client` tinyint(1) DEFAULT '1',
    `show_profile` tinyint(1) DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    CONSTRAINT `site_settings_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `site_settings`
  --
  
  LOCK TABLES `site_settings` WRITE;
  /*!40000 ALTER TABLE `site_settings` DISABLE KEYS */;
  INSERT INTO `site_settings` VALUES (1,1,0,0,1,1),(2,2,1,1,1,0),(3,3,1,0,0,1),(4,4,0,1,0,0),(5,5,1,1,1,1),(6,6,0,0,1,1),(7,7,1,1,0,0),(8,8,0,1,0,0),(9,9,1,1,1,1),(10,10,0,1,1,0),(11,11,1,0,1,0),(12,12,1,0,0,1),(13,13,1,0,0,0),(14,14,0,0,1,1),(15,15,1,0,0,1),(16,16,1,0,0,0),(17,17,0,0,1,1),(18,18,1,1,1,0),(19,19,1,1,0,1),(20,20,1,0,1,1),(21,21,0,1,1,1),(22,22,0,1,1,1),(23,23,1,0,1,0),(24,24,1,1,1,1),(25,25,1,1,1,0),(26,26,0,1,1,0),(27,27,0,0,1,0),(28,28,1,0,1,0),(29,29,0,0,1,0),(30,30,1,1,0,1),(31,31,1,1,1,0),(32,32,1,1,0,0),(33,33,0,0,1,1),(34,34,1,1,1,0),(35,35,1,0,0,1),(36,36,1,1,1,0),(37,37,0,1,1,0),(38,38,0,1,0,0),(39,39,1,1,0,1),(40,40,0,1,0,1),(41,41,1,1,0,0),(42,42,1,1,1,1),(43,43,0,1,0,0),(44,44,1,0,0,0),(45,45,1,1,1,0),(46,46,1,1,0,0),(47,47,1,1,1,0),(48,48,0,1,1,0),(49,49,1,1,0,0),(50,50,1,0,1,1),(51,51,0,0,1,0),(52,52,0,0,0,0),(53,53,1,0,0,0),(54,54,1,1,1,0),(55,55,1,1,0,0),(56,56,1,1,0,1),(57,57,1,0,0,0),(58,58,1,0,0,1),(59,59,0,0,1,0),(60,60,0,0,1,0),(61,61,0,1,1,1),(62,62,1,0,0,0),(63,63,0,1,0,0),(64,64,1,0,1,0),(65,65,1,1,1,1),(66,66,1,1,0,1),(67,67,1,0,0,0),(68,68,0,1,0,0),(69,69,1,1,0,1),(70,70,0,1,0,0),(71,71,0,1,0,1),(72,72,0,1,0,0),(73,73,1,1,1,0),(74,74,0,1,0,0),(75,75,1,1,0,0),(76,76,1,0,0,0),(77,77,0,1,0,0),(78,78,0,0,0,0),(79,79,0,1,0,0),(80,80,1,0,0,0),(81,81,1,1,1,0),(82,82,1,0,1,1),(83,83,1,1,1,0),(84,84,0,0,1,1),(85,85,1,1,1,0),(86,86,0,0,0,0),(87,87,1,1,1,1),(88,88,1,1,0,0),(89,89,1,1,1,0),(90,90,1,0,1,0),(91,91,0,1,1,1),(92,92,1,0,0,1),(93,93,0,1,0,0),(94,94,0,1,1,1),(95,95,0,0,1,1),(96,96,1,1,0,1),(97,97,0,1,1,0),(98,98,1,1,1,0),(99,99,0,0,1,0),(100,100,1,0,0,1);
  /*!40000 ALTER TABLE `site_settings` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `task`
  --
  
  DROP TABLE IF EXISTS `task`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `task` (
    `id` int NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `description` varchar(255) DEFAULT NULL,
    `status` varchar(255) NOT NULL,
    `price` int DEFAULT NULL,
    `category_id` int DEFAULT NULL,
    `author_id` int DEFAULT NULL,
    `executor_id` int DEFAULT NULL,
    `city_id` int DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `finished_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `execution_date` date DEFAULT NULL,
    `geocode` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `category_id` (`category_id`),
    KEY `author_id` (`author_id`),
    KEY `task_ibfk_3` (`executor_id`),
    KEY `task_ibfk_4` (`city_id`),
    CONSTRAINT `task_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
    CONSTRAINT `task_ibfk_2` FOREIGN KEY (`author_id`) REFERENCES `user` (`id`),
    CONSTRAINT `task_ibfk_4` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE RESTRICT
  ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `task`
  --
  
  LOCK TABLES `task` WRITE;
  /*!40000 ALTER TABLE `task` DISABLE KEYS */;
  INSERT INTO `task` VALUES (1,'eu nulla at sem molestie sodales. Mauris blandit enim consequat','vitae, posuere at, velit. Cras lorem lorem, luctus ut, pellentesque eget, dictum placerat, augue. Sed molestie. Sed id risus quis','new',82783,7,1,1,1,'2020-05-20 13:47:51','2020-05-17 13:47:51',NULL,'55.798784,37.514381'),(2,'consectetuer adipiscing elit. Etiam laoreet, libero et tristique pellentesque, tellus','mauris a nunc. In at pede. Cras vulputate velit eu sem. Pellentesque ut ipsum ac mi eleifend egestas. Sed pharetra,','cancelled',21978,3,2,2,2,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.739906,37.721004'),(3,'semper erat, in consectetuer ipsum nunc id enim. Curabitur massa.','lobortis tellus justo sit amet nulla. Donec non justo. Proin non massa non ante bibendum ullamcorper. Duis cursus, diam at','progress',54652,7,3,3,3,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.632495,37.703603'),(4,'Cras eget nisi dictum augue malesuada malesuada. Integer id magna','ut eros non enim commodo hendrerit. Donec porttitor tellus non magna. Nam ligula elit, pretium et, rutrum non, hendrerit id,','progress',53733,7,4,4,4,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.821695,37.836933'),(5,'malesuada id, erat. Etiam vestibulum massa rutrum magna. Cras convallis','massa. Integer vitae nibh. Donec est mauris, rhoncus id, mollis nec, cursus a, enim. Suspendisse aliquet, sem ut cursus luctus,','completed',57395,6,5,5,5,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.859426,37.601141'),(6,'lorem ipsum sodales purus, in molestie tortor nibh sit amet','lobortis risus. In mi pede, nonummy ut, molestie in, tempus eu, ligula. Aenean euismod mauris eu elit. Nulla facilisi. Sed','completed',46491,1,6,6,6,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.784098,37.596551'),(7,'Proin mi. Aliquam gravida mauris ut mi. Duis risus odio,','nulla ante, iaculis nec, eleifend non, dapibus rutrum, justo. Praesent luctus. Curabitur egestas nunc sed libero. Proin sed turpis nec','cancelled',85131,1,7,7,7,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.547754,37.553894'),(8,'consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales','posuere cubilia Curae; Donec tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae','cancelled',1801,2,8,8,8,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.759224,37.756043'),(9,'molestie. Sed id risus quis diam luctus lobortis. Class aptent','a, facilisis non, bibendum sed, est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque sed dictum eleifend, nunc risus varius','failed',44576,6,9,9,9,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.634586,37.346156'),(10,'sem ut dolor dapibus gravida. Aliquam tincidunt, nunc ac mattis','nunc sed libero. Proin sed turpis nec mauris blandit mattis. Cras eget nisi dictum augue malesuada malesuada. Integer id magna','progress',98854,4,10,10,10,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.667305,37.443229'),(11,'In ornare sagittis felis. Donec tempor, est ac mattis semper,','auctor velit. Aliquam nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus rhoncus. Donec est. Nunc ullamcorper, velit in aliquet','completed',91856,8,11,11,11,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.759658,37.524991'),(12,'vitae, erat. Vivamus nisi. Mauris nulla. Integer urna. Vivamus molestie','dignissim tempor arcu. Vestibulum ut eros non enim commodo hendrerit. Donec porttitor tellus non magna. Nam ligula elit, pretium et,','new',85384,6,12,12,12,'2020-05-19 13:47:51','2020-05-17 13:47:51',NULL,'55.595216,37.672603'),(13,'vel, venenatis vel, faucibus id, libero. Donec consectetuer mauris id','conubia nostra, per inceptos hymenaeos. Mauris ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus.','completed',83350,8,13,13,13,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.746621,37.613572'),(14,'penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec','eu dolor egestas rhoncus. Proin nisl sem, consequat nec, mollis vitae, posuere at, velit. Cras lorem lorem, luctus ut, pellentesque','completed',25468,8,14,14,14,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.543605,37.584773'),(15,'Sed id risus quis diam luctus lobortis. Class aptent taciti','velit. Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus euismod urna. Nullam lobortis quam a felis','failed',2964,8,15,15,15,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.831304,37.573014'),(16,'eu, ligula. Aenean euismod mauris eu elit. Nulla facilisi. Sed','nec mauris blandit mattis. Cras eget nisi dictum augue malesuada malesuada. Integer id magna et ipsum cursus vestibulum. Mauris magna.','failed',95725,2,16,16,16,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.629542,37.706425'),(17,'Maecenas ornare egestas ligula. Nullam feugiat placerat velit. Quisque varius.','at, egestas a, scelerisque sed, sapien. Nunc pulvinar arcu et pede. Nunc sed orci lobortis augue scelerisque mollis. Phasellus libero','failed',55488,1,17,17,17,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.611004,37.518928'),(18,'semper egestas, urna justo faucibus lectus, a sollicitudin orci sem','pede. Praesent eu dui. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aenean eget magna. Suspendisse','cancelled',83133,2,18,18,18,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.790789,37.656349'),(19,'est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque sed','purus, in molestie tortor nibh sit amet orci. Ut sagittis lobortis mauris. Suspendisse aliquet molestie tellus. Aenean egestas hendrerit neque.','cancelled',36563,3,19,19,19,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.829107,37.578056'),(20,'sed pede. Cum sociis natoque penatibus et magnis dis parturient','amet, dapibus id, blandit at, nisi. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel','cancelled',38827,7,20,20,20,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.747172,37.689383'),(21,'lectus quis massa. Mauris vestibulum, neque sed dictum eleifend, nunc','nunc nulla vulputate dui, nec tempus mauris erat eget ipsum. Suspendisse sagittis. Nullam vitae diam. Proin dolor. Nulla semper tellus','new',39326,6,21,21,21,'2020-05-18 13:47:51','2020-05-17 13:47:51',NULL,'55.617795,37.447563'),(22,'ipsum dolor sit amet, consectetuer adipiscing elit. Etiam laoreet, libero','arcu. Morbi sit amet massa. Quisque porttitor eros nec tellus. Nunc lectus pede, ultrices a, auctor non, feugiat nec, diam.','progress',47896,8,22,22,22,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.820425,37.729344'),(23,'mollis. Phasellus libero mauris, aliquam eu, accumsan sed, facilisis vitae,','adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc sollicitudin commodo ipsum. Suspendisse non leo. Vivamus nibh dolor, nonummy','cancelled',82830,7,23,23,23,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.764456,37.552436'),(24,'In nec orci. Donec nibh. Quisque nonummy ipsum non arcu.','consectetuer adipiscing elit. Curabitur sed tortor. Integer aliquam adipiscing lacus. Ut nec urna et arcu imperdiet ullamcorper. Duis at lacus.','progress',17307,6,24,24,24,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.659664,37.654511'),(25,'ipsum dolor sit amet, consectetuer adipiscing elit. Etiam laoreet, libero','sed, sapien. Nunc pulvinar arcu et pede. Nunc sed orci lobortis augue scelerisque mollis. Phasellus libero mauris, aliquam eu, accumsan','completed',20370,8,25,25,25,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.560072,37.161588'),(26,'consectetuer mauris id sapien. Cras dolor dolor, tempus non, lacinia','pretium et, rutrum non, hendrerit id, ante. Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent interdum ligula','cancelled',24661,6,26,26,26,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.58572,37.26393'),(27,'lacus pede sagittis augue, eu tempor erat neque non quam.','ridiculus mus. Proin vel arcu eu odio tristique pharetra. Quisque ac libero nec ligula consectetuer rhoncus. Nullam velit dui, semper','failed',92881,7,27,27,27,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.720326,37.573021'),(28,'Curae; Donec tincidunt. Donec vitae erat vel pede blandit congue.','ut, pharetra sed, hendrerit a, arcu. Sed et libero. Proin mi. Aliquam gravida mauris ut mi. Duis risus odio, auctor','new',74896,5,28,28,28,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.790254,37.590238'),(29,'aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus dapibus quam','Cras pellentesque. Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper magna. Sed eu eros. Nam consequat dolor vitae dolor. Donec','cancelled',97880,5,29,29,29,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.842396,37.584956'),(30,'adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc','tincidunt dui augue eu tellus. Phasellus elit pede, malesuada vel, venenatis vel, faucibus id, libero. Donec consectetuer mauris id sapien.','failed',86831,8,30,30,30,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.981896,37.180781'),(31,'lobortis risus. In mi pede, nonummy ut, molestie in, tempus','vitae erat vel pede blandit congue. In scelerisque scelerisque dui. Suspendisse ac metus vitae velit egestas lacinia. Sed congue, elit','progress',11104,1,31,31,31,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.988033,37.183316'),(32,'sed, est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque','placerat, orci lacus vestibulum lorem, sit amet ultricies sem magna nec quam. Curabitur vel lectus. Cum sociis natoque penatibus et','new',22819,4,32,32,32,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.600474,37.32148'),(33,'nec metus facilisis lorem tristique aliquet. Phasellus fermentum convallis ligula.','ligula elit, pretium et, rutrum non, hendrerit id, ante. Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent','progress',99743,1,33,33,33,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.603874,37.335305'),(34,'consequat enim diam vel arcu. Curabitur ut odio vel est','faucibus orci luctus et ultrices posuere cubilia Curae; Donec tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque scelerisque','completed',66706,5,34,34,34,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.60326,37.605909'),(35,'pellentesque a, facilisis non, bibendum sed, est. Nunc laoreet lectus','nec ligula consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales at, velit. Pellentesque ultricies dignissim lacus. Aliquam rutrum','cancelled',88326,3,35,35,35,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.800587,37.32801'),(36,'magna tellus faucibus leo, in lobortis tellus justo sit amet','cursus. Nunc mauris elit, dictum eu, eleifend nec, malesuada ut, sem. Nulla interdum. Curabitur dictum. Phasellus in felis. Nulla tempor','cancelled',20409,1,36,36,36,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.770761,37.555435'),(37,'penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin','ligula. Aenean euismod mauris eu elit. Nulla facilisi. Sed neque. Sed eget lacus. Mauris non dui nec urna suscipit nonummy.','failed',42594,5,37,37,37,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.765159,37.68632'),(38,'accumsan neque et nunc. Quisque ornare tortor at risus. Nunc','sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel nisl. Quisque fringilla euismod enim. Etiam gravida','completed',77401,6,38,38,38,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.573395,37.380357'),(39,'purus ac tellus. Suspendisse sed dolor. Fusce mi lorem, vehicula','eros non enim commodo hendrerit. Donec porttitor tellus non magna. Nam ligula elit, pretium et, rutrum non, hendrerit id, ante.','new',37767,6,39,39,39,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.699953,37.919596'),(40,'laoreet, libero et tristique pellentesque, tellus sem mollis dui, in','molestie pharetra nibh. Aliquam ornare, libero at auctor ullamcorper, nisl arcu iaculis enim, sit amet ornare lectus justo eu arcu.','cancelled',69844,7,40,40,40,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.633027,37.619484'),(41,'sed, est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque','ultricies adipiscing, enim mi tempor lorem, eget mollis lectus pede et risus. Quisque libero lacus, varius et, euismod et, commodo','failed',86705,2,41,41,41,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.621781,37.614909'),(42,'fermentum fermentum arcu. Vestibulum ante ipsum primis in faucibus orci','eget, ipsum. Donec sollicitudin adipiscing ligula. Aenean gravida nunc sed pede. Cum sociis natoque penatibus et magnis dis parturient montes,','completed',29272,2,42,42,42,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.698697,37.403055'),(43,'dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus','felis orci, adipiscing non, luctus sit amet, faucibus ut, nulla. Cras eu tellus eu augue porttitor interdum. Sed auctor odio','completed',96995,6,43,43,43,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.743842,37.533535'),(44,'amet massa. Quisque porttitor eros nec tellus. Nunc lectus pede,','pretium et, rutrum non, hendrerit id, ante. Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent interdum ligula','completed',12146,4,44,44,44,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.64493,37.746017'),(45,'enim. Suspendisse aliquet, sem ut cursus luctus, ipsum leo elementum','enim. Curabitur massa. Vestibulum accumsan neque et nunc. Quisque ornare tortor at risus. Nunc ac sem ut dolor dapibus gravida.','progress',76463,3,45,45,45,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.772574,37.429289'),(46,'cursus vestibulum. Mauris magna. Duis dignissim tempor arcu. Vestibulum ut','dis parturient montes, nascetur ridiculus mus. Donec dignissim magna a tortor. Nunc commodo auctor velit. Aliquam nisl. Nulla eu neque','new',95153,2,46,46,46,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.714942,37.395671'),(47,'dolor dolor, tempus non, lacinia at, iaculis quis, pede. Praesent','non, hendrerit id, ante. Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent interdum ligula eu enim. Etiam','progress',63276,1,47,47,47,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.811053,37.388867'),(48,'Nullam feugiat placerat velit. Quisque varius. Nam porttitor scelerisque neque.','lobortis tellus justo sit amet nulla. Donec non justo. Proin non massa non ante bibendum ullamcorper. Duis cursus, diam at','cancelled',58420,3,48,48,48,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.798974,37.615712'),(49,'arcu. Vestibulum ut eros non enim commodo hendrerit. Donec porttitor','imperdiet non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aliquam auctor, velit','progress',31117,4,49,49,49,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.610595,37.717837'),(50,'turpis vitae purus gravida sagittis. Duis gravida. Praesent eu nulla','Nunc sed orci lobortis augue scelerisque mollis. Phasellus libero mauris, aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus dapibus quam','progress',25505,5,50,50,50,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.701567,37.569342'),(51,'sem. Pellentesque ut ipsum ac mi eleifend egestas. Sed pharetra,','tempor arcu. Vestibulum ut eros non enim commodo hendrerit. Donec porttitor tellus non magna. Nam ligula elit, pretium et, rutrum','new',87672,7,51,51,51,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.631869,37.619698'),(52,'egestas blandit. Nam nulla magna, malesuada vel, convallis in, cursus','Vivamus nisi. Mauris nulla. Integer urna. Vivamus molestie dapibus ligula. Aliquam erat volutpat. Nulla dignissim. Maecenas ornare egestas ligula. Nullam','completed',2976,7,52,52,52,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.578176,37.694557'),(53,'lobortis mauris. Suspendisse aliquet molestie tellus. Aenean egestas hendrerit neque.','enim. Curabitur massa. Vestibulum accumsan neque et nunc. Quisque ornare tortor at risus. Nunc ac sem ut dolor dapibus gravida.','cancelled',70646,1,53,53,53,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.660403,37.575008'),(54,'ac, eleifend vitae, erat. Vivamus nisi. Mauris nulla. Integer urna.','id magna et ipsum cursus vestibulum. Mauris magna. Duis dignissim tempor arcu. Vestibulum ut eros non enim commodo hendrerit. Donec','new',36615,3,54,54,54,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.875084,37.527499'),(55,'lorem ac risus. Morbi metus. Vivamus euismod urna. Nullam lobortis','massa non ante bibendum ullamcorper. Duis cursus, diam at pretium aliquet, metus urna convallis erat, eget tincidunt dui augue eu','new',16488,2,55,55,55,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.763404,37.77746'),(56,'Nulla interdum. Curabitur dictum. Phasellus in felis. Nulla tempor augue','libero nec ligula consectetuer rhoncus. Nullam velit dui, semper et, lacinia vitae, sodales at, velit. Pellentesque ultricies dignissim lacus. Aliquam','new',75103,7,56,56,56,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.799484,37.734599'),(57,'vulputate mauris sagittis placerat. Cras dictum ultricies ligula. Nullam enim.','tellus sem mollis dui, in sodales elit erat vitae risus. Duis a mi fringilla mi lacinia mattis. Integer eu lacus.','progress',26095,2,57,57,57,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.625667,37.439644'),(58,'sem, consequat nec, mollis vitae, posuere at, velit. Cras lorem','libero. Donec consectetuer mauris id sapien. Cras dolor dolor, tempus non, lacinia at, iaculis quis, pede. Praesent eu dui. Cum','new',37861,5,58,58,58,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.581604,37.681894'),(59,'egestas hendrerit neque. In ornare sagittis felis. Donec tempor, est','fringilla. Donec feugiat metus sit amet ante. Vivamus non lorem vitae odio sagittis semper. Nam tempor diam dictum sapien. Aenean','completed',58974,6,59,59,59,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.732732,37.679485'),(60,'at, egestas a, scelerisque sed, sapien. Nunc pulvinar arcu et','lobortis risus. In mi pede, nonummy ut, molestie in, tempus eu, ligula. Aenean euismod mauris eu elit. Nulla facilisi. Sed','new',56074,5,60,60,60,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.604557,37.54296'),(61,'molestie in, tempus eu, ligula. Aenean euismod mauris eu elit.','velit egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla vulputate dui, nec tempus mauris erat eget ipsum. Suspendisse','cancelled',61156,2,61,61,61,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.665994,37.581388'),(62,'turpis nec mauris blandit mattis. Cras eget nisi dictum augue','Nulla tincidunt, neque vitae semper egestas, urna justo faucibus lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend. Cras sed','completed',48501,4,62,62,62,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.837554,37.637619'),(63,'purus sapien, gravida non, sollicitudin a, malesuada id, erat. Etiam','Etiam imperdiet dictum magna. Ut tincidunt orci quis lectus. Nullam suscipit, est ac facilisis facilisis, magna tellus faucibus leo, in','new',3349,4,63,63,63,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.665654,37.741106'),(64,'risus. Donec egestas. Duis ac arcu. Nunc mauris. Morbi non','Donec luctus aliquet odio. Etiam ligula tortor, dictum eu, placerat eget, venenatis a, magna. Lorem ipsum dolor sit amet, consectetuer','new',90205,2,64,64,64,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.602458,37.550263'),(65,'ut, molestie in, tempus eu, ligula. Aenean euismod mauris eu','bibendum fermentum metus. Aenean sed pede nec ante blandit viverra. Donec tempus, lorem fringilla ornare placerat, orci lacus vestibulum lorem,','progress',49530,4,65,65,65,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.634814,37.520714'),(66,'posuere at, velit. Cras lorem lorem, luctus ut, pellentesque eget,','volutpat nunc sit amet metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer vulputate, risus a','new',37610,1,66,66,66,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.641882,37.525993'),(67,'non, vestibulum nec, euismod in, dolor. Fusce feugiat. Lorem ipsum','conubia nostra, per inceptos hymenaeos. Mauris ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus.','progress',70543,7,67,67,67,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.655074,37.837837'),(68,'et ultrices posuere cubilia Curae; Donec tincidunt. Donec vitae erat','ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc sollicitudin commodo ipsum. Suspendisse non leo.','cancelled',81806,7,68,68,68,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.643661,37.656077'),(69,'Nunc pulvinar arcu et pede. Nunc sed orci lobortis augue','Nulla tincidunt, neque vitae semper egestas, urna justo faucibus lectus, a sollicitudin orci sem eget massa. Suspendisse eleifend. Cras sed','failed',79107,1,69,69,69,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.62017,37.712476'),(70,'ultrices, mauris ipsum porta elit, a feugiat tellus lorem eu','lacus. Cras interdum. Nunc sollicitudin commodo ipsum. Suspendisse non leo. Vivamus nibh dolor, nonummy ac, feugiat non, lobortis quis, pede.','new',38784,7,70,70,70,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.643109,37.526335'),(71,'Phasellus fermentum convallis ligula. Donec luctus aliquet odio. Etiam ligula','Mauris ut quam vel sapien imperdiet ornare. In faucibus. Morbi vehicula. Pellentesque tincidunt tempus risus. Donec egestas. Duis ac arcu.','completed',40796,8,71,71,71,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.691927,37.560687'),(72,'dapibus ligula. Aliquam erat volutpat. Nulla dignissim. Maecenas ornare egestas','a odio semper cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices iaculis odio. Nam interdum enim non nisi. Aenean','failed',32246,4,72,72,72,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.614256,37.747318'),(73,'convallis erat, eget tincidunt dui augue eu tellus. Phasellus elit','ante. Nunc mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. Praesent interdum ligula eu enim. Etiam imperdiet dictum magna.','completed',52863,5,73,73,73,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.672636,37.447103'),(74,'mauris erat eget ipsum. Suspendisse sagittis. Nullam vitae diam. Proin','In lorem. Donec elementum, lorem ut aliquam iaculis, lacus pede sagittis augue, eu tempor erat neque non quam. Pellentesque habitant','completed',36970,1,74,74,74,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.830847,37.379577'),(75,'semper cursus. Integer mollis. Integer tincidunt aliquam arcu. Aliquam ultrices','egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas a, dui. Cras pellentesque. Sed','completed',25133,7,75,75,75,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.894027,37.54299'),(76,'Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus','Aliquam tincidunt, nunc ac mattis ornare, lectus ante dictum mi, ac mattis velit justo nec ante. Maecenas mi felis, adipiscing','completed',23296,6,76,76,76,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.585558,37.264041'),(77,'pretium neque. Morbi quis urna. Nunc quis arcu vel quam','neque. Nullam nisl. Maecenas malesuada fringilla est. Mauris eu turpis. Nulla aliquet. Proin velit. Sed malesuada augue ut lacus. Nulla','cancelled',20228,2,77,77,77,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.850422,37.438038'),(78,'nisi nibh lacinia orci, consectetuer euismod est arcu ac orci.','ullamcorper. Duis cursus, diam at pretium aliquet, metus urna convallis erat, eget tincidunt dui augue eu tellus. Phasellus elit pede,','failed',59164,1,78,78,78,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.706835,37.621047'),(79,'pede sagittis augue, eu tempor erat neque non quam. Pellentesque','iaculis quis, pede. Praesent eu dui. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aenean eget','completed',75120,8,79,79,79,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.8566,37.396524'),(80,'venenatis vel, faucibus id, libero. Donec consectetuer mauris id sapien.','velit justo nec ante. Maecenas mi felis, adipiscing fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc sollicitudin commodo ipsum.','progress',46762,8,80,80,80,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.704031,37.621938'),(81,'ullamcorper magna. Sed eu eros. Nam consequat dolor vitae dolor.','Duis elementum, dui quis accumsan convallis, ante lectus convallis est, vitae sodales nisi magna sed dui. Fusce aliquam, enim nec','progress',91220,8,81,81,81,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.70652,37.617737'),(82,'dui, in sodales elit erat vitae risus. Duis a mi','est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque sed dictum eleifend, nunc risus varius orci, in consequat enim diam','new',26486,4,82,82,82,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.784801,37.520903'),(83,'elit pede, malesuada vel, venenatis vel, faucibus id, libero. Donec','eget varius ultrices, mauris ipsum porta elit, a feugiat tellus lorem eu metus. In lorem. Donec elementum, lorem ut aliquam','progress',7588,4,83,83,83,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.841929,37.373374'),(84,'molestie arcu. Sed eu nibh vulputate mauris sagittis placerat. Cras','vulputate dui, nec tempus mauris erat eget ipsum. Suspendisse sagittis. Nullam vitae diam. Proin dolor. Nulla semper tellus id nunc','new',22731,6,84,84,84,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.8006,37.635893'),(85,'nascetur ridiculus mus. Aenean eget magna. Suspendisse tristique neque venenatis','elementum, dui quis accumsan convallis, ante lectus convallis est, vitae sodales nisi magna sed dui. Fusce aliquam, enim nec tempus','new',54919,4,85,85,85,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.733202,37.668606'),(86,'est. Nunc laoreet lectus quis massa. Mauris vestibulum, neque sed','dignissim. Maecenas ornare egestas ligula. Nullam feugiat placerat velit. Quisque varius. Nam porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla','progress',84298,7,86,86,86,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.82672,37.572519'),(87,'Sed dictum. Proin eget odio. Aliquam vulputate ullamcorper magna. Sed','sed orci lobortis augue scelerisque mollis. Phasellus libero mauris, aliquam eu, accumsan sed, facilisis vitae, orci. Phasellus dapibus quam quis','new',10270,2,87,87,87,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.646701,37.450614'),(88,'litora torquent per conubia nostra, per inceptos hymenaeos. Mauris ut','nec urna suscipit nonummy. Fusce fermentum fermentum arcu. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia','completed',47006,4,88,88,88,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.865441,37.584429'),(89,'tortor at risus. Nunc ac sem ut dolor dapibus gravida.','laoreet ipsum. Curabitur consequat, lectus sit amet luctus vulputate, nisi sem semper erat, in consectetuer ipsum nunc id enim. Curabitur','cancelled',99117,1,89,89,89,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.791122,37.577271'),(90,'posuere at, velit. Cras lorem lorem, luctus ut, pellentesque eget,','semper et, lacinia vitae, sodales at, velit. Pellentesque ultricies dignissim lacus. Aliquam rutrum lorem ac risus. Morbi metus. Vivamus euismod','cancelled',82171,4,90,90,90,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.842014,37.353737'),(91,'cursus vestibulum. Mauris magna. Duis dignissim tempor arcu. Vestibulum ut','Vivamus sit amet risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed nunc est, mollis non, cursus non, egestas','new',64775,7,91,91,91,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.791616,37.604287'),(92,'Nullam enim. Sed nulla ante, iaculis nec, eleifend non, dapibus','nulla ante, iaculis nec, eleifend non, dapibus rutrum, justo. Praesent luctus. Curabitur egestas nunc sed libero. Proin sed turpis nec','cancelled',83187,4,92,92,92,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.799918,37.58352'),(93,'dapibus rutrum, justo. Praesent luctus. Curabitur egestas nunc sed libero.','penatibus et magnis dis parturient montes, nascetur ridiculus mus. Proin vel arcu eu odio tristique pharetra. Quisque ac libero nec','failed',78622,3,93,93,93,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.655274,37.3948'),(94,'commodo hendrerit. Donec porttitor tellus non magna. Nam ligula elit,','metus. Aliquam erat volutpat. Nulla facilisis. Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer vulputate, risus a ultricies adipiscing, enim mi','cancelled',47930,5,94,94,94,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.717108,37.580551'),(95,'euismod et, commodo at, libero. Morbi accumsan laoreet ipsum. Curabitur','primis in faucibus orci luctus et ultrices posuere cubilia Curae; Phasellus ornare. Fusce mollis. Duis sit amet diam eu dolor','failed',10470,4,95,95,95,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.68252,37.536909'),(96,'nisl. Nulla eu neque pellentesque massa lobortis ultrices. Vivamus rhoncus.','felis orci, adipiscing non, luctus sit amet, faucibus ut, nulla. Cras eu tellus eu augue porttitor interdum. Sed auctor odio','progress',78302,6,96,96,NULL,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.841458,37.371289'),(97,'enim, condimentum eget, volutpat ornare, facilisis eget, ipsum. Donec sollicitudin','pede et risus. Quisque libero lacus, varius et, euismod et, commodo at, libero. Morbi accumsan laoreet ipsum. Curabitur consequat, lectus','cancelled',5479,2,97,97,1109,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.844783,37.378836'),(98,'mi fringilla mi lacinia mattis. Integer eu lacus. Quisque imperdiet,','nulla. Integer vulputate, risus a ultricies adipiscing, enim mi tempor lorem, eget mollis lectus pede et risus. Quisque libero lacus,','new',80674,6,98,98,1109,'2020-05-17 13:47:51','2020-05-17 13:47:51',NULL,'55.724299,37.604562'),(99,'risus. Donec egestas. Aliquam nec enim. Nunc ut erat. Sed','placerat, augue. Sed molestie. Sed id risus quis diam luctus lobortis. Class aptent taciti sociosqu ad litora torquent per conubia','new',41015,1,99,99,1109,'2020-07-06 13:47:51','2020-07-06 13:47:51',NULL,'55.687171,37.576293'),(100,'egestas lacinia. Sed congue, elit sed consequat auctor, nunc nulla','sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aenean eget magna. Suspendisse tristique neque venenatis lacus. Etiam','new',42017,1,1,100,1109,'2020-07-14 08:55:55','2020-07-12 08:55:55',NULL,'55.841391,37.522932'),(103,'asdfgf','asdxcvb','new',55555,1,1,NULL,NULL,'2020-07-13 08:55:55','2020-07-14 08:55:55',NULL,'55.687951,37.42809');
  /*!40000 ALTER TABLE `task` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user`
  --
  
  DROP TABLE IF EXISTS `user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user` (
    `id` int NOT NULL AUTO_INCREMENT,
    `email` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `city_id` int NOT NULL,
    `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `name` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `email` (`email`),
    KEY `city_id` (`city_id`),
    CONSTRAINT `user_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user`
  --
  
  LOCK TABLES `user` WRITE;
  /*!40000 ALTER TABLE `user` DISABLE KEYS */;
  INSERT INTO `user` VALUES (1,'magnis@euodiotristique.net','786613737',1,'2020-05-17 13:46:41',NULL),(2,'justo.nec.ante@Nunc.co.uk','442907960',2,'2020-05-10 13:46:41',NULL),(3,'vitae@ornare.co.uk','050124353',3,'2020-05-11 13:46:41',NULL),(4,'auctor.velit.Aliquam@lectus.co.uk','976086744',4,'2020-05-12 13:46:41',NULL),(5,'mi.lacinia.mattis@bibendumDonecfelis.net','885185843',5,'2020-05-17 13:46:41',NULL),(6,'elementum@miAliquam.edu','067119636',6,'2020-05-17 13:46:41',NULL),(7,'Nulla@dictum.com','057576985',7,'2020-05-17 13:46:41',NULL),(8,'gravida.mauris.ut@conubianostra.net','868015736',8,'2020-05-17 13:46:41',NULL),(9,'fermentum.fermentum@egestas.co.uk','723460218',9,'2020-05-17 13:46:41',NULL),(10,'malesuada.malesuada@amet.co.uk','007339484',10,'2020-05-17 13:46:41',NULL),(11,'Quisque.porttitor@sit.co.uk','006730071',11,'2020-05-17 13:46:41',NULL),(12,'elit@arcu.co.uk','963925276',12,'2020-05-17 13:46:41',NULL),(13,'non.bibendum.sed@maurisrhoncusid.co.uk','197559248',13,'2020-05-17 13:46:41',NULL),(14,'lectus.Cum.sociis@Loremipsum.edu','142882117',14,'2020-05-17 13:46:41',NULL),(15,'Quisque@orciadipiscing.org','032452427',15,'2020-05-17 13:46:41',NULL),(16,'vulputate@Curabiturconsequatlectus.edu','032782500',16,'2020-05-17 13:46:41',NULL),(17,'quis.pede@nasceturridiculus.edu','386609655',17,'2020-05-17 13:46:41',NULL),(18,'lobortis.ultrices@consequat.com','321856999',18,'2020-05-17 13:46:41',NULL),(19,'Nulla.tempor@ridiculusmusDonec.net','205082373',19,'2020-05-17 13:46:41',NULL),(20,'tortor.Nunc@dictumPhasellusin.co.uk','881868392',20,'2020-05-17 13:46:41',NULL),(21,'sit.amet.consectetuer@et.co.uk','134403492',21,'2020-05-17 13:46:41',NULL),(22,'erat.nonummy.ultricies@ametrisus.org','110013190',22,'2020-05-17 13:46:41',NULL),(23,'In.nec.orci@sapien.com','166816199',23,'2020-05-17 13:46:41',NULL),(24,'accumsan.neque@Sedpharetrafelis.co.uk','669238446',24,'2020-05-17 13:46:41',NULL),(25,'nascetur.ridiculus@acmetus.net','337205900',25,'2020-05-17 13:46:41',NULL),(26,'ultricies.dignissim@urnaNunc.com','498646959',26,'2020-05-17 13:46:41',NULL),(27,'magna@massa.com','525483178',27,'2020-05-17 13:46:41',NULL),(28,'ut@Pellentesque.com','697638054',28,'2020-05-17 13:46:41',NULL),(29,'Quisque.ornare@pedenec.net','481234334',29,'2020-05-17 13:46:41',NULL),(30,'facilisis@erosnectellus.com','883545253',30,'2020-05-17 13:46:41',NULL),(31,'diam@Fuscefermentumfermentum.org','314364019',31,'2020-05-17 13:46:41',NULL),(32,'ullamcorper.velit@lectus.com','763348224',32,'2020-05-17 13:46:41',NULL),(33,'egestas.ligula.Nullam@egetvenenatisa.ca','841825458',33,'2020-05-17 13:46:41',NULL),(34,'amet.ante.Vivamus@lobortismaurisSuspendisse.ca','738694819',34,'2020-05-17 13:46:41',NULL),(35,'lacus.vestibulum.lorem@ullamcorperDuis.ca','507279065',35,'2020-05-17 13:46:41',NULL),(36,'turpis.Nulla@Crassed.co.uk','260215934',36,'2020-05-17 13:46:41',NULL),(37,'elit@Aeneanmassa.co.uk','588117416',37,'2020-05-17 13:46:41',NULL),(38,'fermentum.convallis.ligula@Aeneaneget.ca','587206061',38,'2020-05-17 13:46:41',NULL),(39,'risus.Quisque@ornarelectusjusto.com','071689251',39,'2020-05-17 13:46:41',NULL),(40,'ut.molestie.in@nequeSed.edu','492053848',40,'2020-05-17 13:46:41',NULL),(41,'porttitor.scelerisque@acmattis.org','965487556',41,'2020-05-17 13:46:41',NULL),(42,'egestas@tempor.org','809991888',42,'2020-05-17 13:46:41',NULL),(43,'vel.arcu@purusin.org','224663393',43,'2020-05-17 13:46:41',NULL),(44,'eu.turpis@egestas.ca','285592275',44,'2020-05-17 13:46:41',NULL),(45,'velit.Sed@lobortisnisinibh.org','745075424',45,'2020-05-17 13:46:41',NULL),(46,'mi.tempor.lorem@urnaVivamus.co.uk','046460424',46,'2020-05-17 13:46:41',NULL),(47,'Sed.molestie@purussapien.net','772014585',47,'2020-05-17 13:46:41',NULL),(48,'neque.In.ornare@veliteusem.net','296946981',48,'2020-05-17 13:46:41',NULL),(49,'egestas.hendrerit.neque@nisi.edu','794481374',49,'2020-05-17 13:46:41',NULL),(50,'risus@Aliquameratvolutpat.org','897870184',50,'2020-05-17 13:46:41',NULL),(51,'sed.turpis.nec@nec.net','393913538',51,'2020-05-17 13:46:41',NULL),(52,'dictum.augue.malesuada@malesuadafamesac.edu','882751522',52,'2020-05-17 13:46:41',NULL),(53,'at@pedeultricesa.com','222852253',53,'2020-05-17 13:46:41',NULL),(54,'Vivamus@nisl.com','072601974',54,'2020-05-17 13:46:41',NULL),(55,'sociosqu.ad.litora@musProinvel.com','220042949',55,'2020-05-17 13:46:41',NULL),(56,'imperdiet@varius.net','393903539',56,'2020-05-17 13:46:41',NULL),(57,'nonummy@leo.co.uk','716648688',57,'2020-05-17 13:46:41',NULL),(58,'Vivamus@utipsumac.net','245875562',58,'2020-05-17 13:46:41',NULL),(59,'felis.ullamcorper@liberolacusvarius.org','184440188',59,'2020-05-17 13:46:41',NULL),(60,'nonummy.Fusce.fermentum@eratvolutpat.org','897893749',60,'2020-05-17 13:46:41',NULL),(61,'egestas.Fusce.aliquet@sagittisNullam.ca','159561844',61,'2020-05-17 13:46:41',NULL),(62,'diam@odiotristiquepharetra.ca','010887172',62,'2020-05-17 13:46:41',NULL),(63,'netus.et.malesuada@massaIntegervitae.ca','174924860',63,'2020-05-17 13:46:41',NULL),(64,'nunc@Sed.net','540653540',64,'2020-05-17 13:46:41',NULL),(65,'Aenean@vitaesodalesnisi.ca','329644124',65,'2020-05-17 13:46:41',NULL),(66,'nec.tempus.scelerisque@etmalesuadafames.ca','029325792',66,'2020-05-17 13:46:41',NULL),(67,'gravida.molestie.arcu@eratEtiamvestibulum.com','098047905',67,'2020-05-17 13:46:41',NULL),(68,'mattis.semper@nascetur.edu','889313011',68,'2020-05-17 13:46:41',NULL),(69,'Quisque.fringilla.euismod@Mauris.org','172514580',69,'2020-05-17 13:46:41',NULL),(70,'ut.lacus@ante.edu','223961517',70,'2020-05-17 13:46:41',NULL),(71,'accumsan.convallis.ante@Maurisvel.ca','726641178',71,'2020-05-17 13:46:41',NULL),(72,'nunc@Integereu.net','949578470',72,'2020-05-17 13:46:41',NULL),(73,'nonummy.ultricies@Fuscealiquet.edu','371702150',73,'2020-05-17 13:46:41',NULL),(74,'purus.ac@pedeultrices.co.uk','678096652',74,'2020-05-17 13:46:41',NULL),(75,'pede.sagittis.augue@Cumsociis.com','204325112',75,'2020-05-17 13:46:41',NULL),(76,'blandit@interdumfeugiat.net','650028673',76,'2020-05-17 13:46:41',NULL),(77,'dui.Suspendisse.ac@pedeblandit.ca','493939037',77,'2020-05-17 13:46:41',NULL),(78,'vitae@famesac.co.uk','950864298',78,'2020-05-17 13:46:41',NULL),(79,'blandit.at@fermentum.org','368343257',79,'2020-05-17 13:46:41',NULL),(80,'nec.leo.Morbi@necmalesuadaut.ca','359523222',80,'2020-05-17 13:46:41',NULL),(81,'ipsum@nislelementumpurus.co.uk','531227221',81,'2020-05-17 13:46:41',NULL),(82,'tempus.mauris.erat@imperdiet.net','218143477',82,'2020-05-17 13:46:41',NULL),(83,'vitae.aliquet@Phaselluselit.ca','531749596',83,'2020-05-17 13:46:41',NULL),(84,'tempor.est.ac@lectusconvallis.edu','528995814',84,'2020-05-17 13:46:41',NULL),(85,'dui@cursusdiamat.org','681940623',85,'2020-05-17 13:46:41',NULL),(86,'ridiculus.mus.Proin@eros.net','637315300',86,'2020-05-17 13:46:41',NULL),(87,'neque@ultricesaauctor.net','983844754',87,'2020-05-17 13:46:41',NULL),(88,'imperdiet@fermentum.edu','396743478',88,'2020-05-17 13:46:41',NULL),(89,'magna.malesuada@orciinconsequat.co.uk','309137503',89,'2020-05-17 13:46:41',NULL),(90,'ut.erat@sit.edu','275283182',90,'2020-05-17 13:46:41',NULL),(91,'egestas.lacinia@justo.com','444579965',91,'2020-05-17 13:46:41',NULL),(92,'dolor@in.org','969180439',92,'2020-05-17 13:46:41',NULL),(93,'sem.semper@Praesenteudui.co.uk','794680892',93,'2020-05-17 13:46:41',NULL),(94,'dui@pedenecante.co.uk','772569034',94,'2020-05-17 13:46:41',NULL),(95,'facilisis.facilisis.magna@Proinvel.ca','742263874',95,'2020-05-17 13:46:41',NULL),(96,'non@auctorvelit.ca','508980638',96,'2020-05-17 13:46:41',NULL),(97,'primis.in@ultricesVivamus.co.uk','024527848',97,'2020-05-17 13:46:41',NULL),(98,'turpis@Crasloremlorem.co.uk','536550577',98,'2020-05-17 13:46:41',NULL),(99,'Suspendisse.aliquet.sem@odioNam.org','704033042',99,'2020-05-17 13:46:41',NULL),(100,'nibh.dolor@eu.com','879465953',100,'2020-05-17 13:46:41',NULL),(102,'nibh-ssdolor@eu.com','zdvfs432',100,'2020-07-13 09:07:07',NULL),(103,'nibh-slor@eu.com','sdf34554',100,'2020-07-13 09:07:31',NULL),(104,'w@s.ru','$2y$13$DUw1yDK7Gq02R0lKEVQGwuZ2zpQWD.SPSIgaRfC/cnPICQOuNTb1u',1108,'2020-12-26 09:05:35','Абырвалг');
  /*!40000 ALTER TABLE `user` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_category`
  --
  
  DROP TABLE IF EXISTS `user_category`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_category` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `category_id` int NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `category_id` (`category_id`),
    CONSTRAINT `user_category_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`user_id`),
    CONSTRAINT `user_category_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_category`
  --
  
  LOCK TABLES `user_category` WRITE;
  /*!40000 ALTER TABLE `user_category` DISABLE KEYS */;
  INSERT INTO `user_category` VALUES (1,1,1),(2,2,1),(3,3,1),(4,4,2),(5,5,8),(6,6,1),(7,7,6),(8,8,1),(9,9,4),(10,10,5),(11,11,1),(12,12,6),(13,13,8),(14,14,2),(15,15,1),(16,16,4),(17,17,8),(18,18,4),(19,19,7),(20,20,5),(21,21,7),(22,22,7),(23,23,1),(24,24,3),(25,25,3),(26,26,4),(27,27,5),(28,28,1),(29,29,8),(30,30,1),(31,31,4),(32,32,4),(33,33,7),(34,34,4),(35,35,7),(36,36,8),(37,37,4),(38,38,2),(39,39,3),(40,40,3),(41,41,7),(42,42,7),(43,43,5),(44,44,8),(45,45,4),(46,46,6),(47,47,1),(48,48,8),(49,49,8),(50,50,2),(51,51,2),(52,52,8),(53,53,1),(54,54,1),(55,55,7),(56,56,5),(57,57,7),(58,58,1),(59,59,7),(60,60,3),(61,61,6),(62,62,8),(63,63,8),(64,64,4),(65,65,8),(66,66,5),(67,67,7),(68,68,4),(69,69,8),(70,70,4),(71,71,5),(72,72,5),(73,73,8),(74,74,5),(75,75,6),(76,76,4),(77,77,4),(78,78,7),(79,79,3),(80,80,2),(81,81,3),(82,82,6),(83,83,4),(84,84,2),(85,85,1),(86,86,5),(87,87,2),(88,88,4),(89,89,2),(90,90,7),(91,91,4),(92,92,6),(93,93,3),(94,94,1),(95,95,4),(96,96,7),(97,97,6),(98,98,7),(99,99,3),(100,100,7),(102,103,1);
  /*!40000 ALTER TABLE `user_category` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_info`
  --
  
  DROP TABLE IF EXISTS `user_info`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_info` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` int NOT NULL,
    `name` varchar(255) DEFAULT NULL,
    `surname` varchar(255) DEFAULT NULL,
    `city_id` int DEFAULT NULL,
    `edited_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `date_birth` date DEFAULT NULL,
    `role_id` int DEFAULT NULL,
    `rating` float DEFAULT '0',
    `phone` varchar(255) DEFAULT NULL,
    `telegram` varchar(255) DEFAULT NULL,
    `skype` varchar(255) DEFAULT NULL,
    `online` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `user_id` (`user_id`),
    KEY `city_id` (`city_id`),
    CONSTRAINT `user_info_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
    CONSTRAINT `user_info_ibfk_2` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_info`
  --
  
  LOCK TABLES `user_info` WRITE;
  /*!40000 ALTER TABLE `user_info` DISABLE KEYS */;
  INSERT INTO `user_info` VALUES (1,1,'Cade','Gamble',57,'2019-06-30 21:00:00','2021-04-30',2,1,'81487004989','16281125 7753','16791215 8917','2020-07-06 09:32:10'),(2,2,'Burton','Castillo',100,'2020-06-12 21:00:00','2020-04-09',3,3,'84502495074','16870314 3126','16931225 4452','2020-07-13 08:25:10'),(3,3,'Otto','Osborne',33,'2020-04-21 21:00:00','2021-04-04',3,4,'89992042698','16730610 3032','16960907 9380','2020-07-06 04:49:10'),(4,4,'Harrison','Everett',94,'2019-11-12 21:00:00','2019-10-27',1,4,'82082588358','16270302 8270','16141215 1324','2020-07-06 04:48:10'),(5,5,'Walker','Schmidt',34,'2019-06-11 21:00:00','2019-07-06',3,5,'88689268593','16240401 3662','16330919 0365','2020-07-06 04:47:10'),(6,6,'Coby','Gilmore',18,'2019-06-30 21:00:00','2019-09-22',3,5,'88841103512','16841004 1373','16050128 3220','2020-07-06 04:52:10'),(7,7,'Cade','Shepard',13,'2020-07-01 21:00:00','2019-09-07',3,1,'86843749504','16561105 0765','16011008 5511','2020-07-09 06:54:42'),(8,8,'Ulysses','Herman',22,'2020-09-17 21:00:00','2020-07-22',3,5,'84738386172','16740412 2215','16441217 2761','2020-07-09 06:54:42'),(9,9,'Merrill','Hampton',53,'2020-08-06 21:00:00','2020-04-25',2,1,'82408629393','16880316 3412','16950830 9003','2020-07-09 06:54:42'),(10,10,'Wylie','Foreman',17,'2019-06-07 21:00:00','2019-06-25',2,1,'85519278069','16520729 7903','16620726 2673','2020-07-09 13:59:57'),(11,11,'Ishmael','Summers',35,'2020-12-06 21:00:00','2021-02-04',3,1,'82812325137','16171003 7720','16350717 4070',NULL),(12,12,'Jermaine','Jones',20,'2020-10-07 21:00:00','2019-09-16',2,2,'88971287027','16261017 5107','16151208 3112',NULL),(13,13,'Basil','Emerson',20,'2021-01-19 21:00:00','2020-09-30',2,5,'84041939953','16870320 2088','16320711 4251',NULL),(14,14,'Bevis','Sosa',28,'2020-04-30 21:00:00','2020-04-01',2,4,'85627228557','16110713 4684','16951130 9552',NULL),(15,15,'Sebastian','Dyer',39,'2019-09-12 21:00:00','2020-08-20',1,2,'88779458916','16440502 4722','16030122 6387',NULL),(16,16,'Arthur','Padilla',81,'2020-06-21 21:00:00','2019-08-27',1,1,'86806081800','16311012 8901','16491013 3273',NULL),(17,17,'Vaughan','Tran',42,'2021-03-29 21:00:00','2019-09-26',1,3,'85202613668','16330819 0606','16411101 3357',NULL),(18,18,'Merritt','Mack',34,'2020-07-04 21:00:00','2020-08-04',1,4,'87694031688','16250906 3190','16590919 5108',NULL),(19,19,'Keefe','Frank',35,'2020-03-06 21:00:00','2019-10-11',1,5,'88884954187','16250801 2339','16480707 1313',NULL),(20,20,'Solomon','Wilcox',33,'2019-06-03 21:00:00','2020-09-11',2,1,'85833406029','16960729 2811','16400202 1667',NULL),(21,21,'Alan','Snyder',53,'2020-06-19 21:00:00','2020-02-11',3,4,'86611027102','16371120 4085','16700506 4485',NULL),(22,22,'Steel','Rich',50,'2019-06-12 21:00:00','2020-08-17',2,3,'87715115601','16330517 1120','16810829 5422',NULL),(23,23,'Andrew','Branch',88,'2019-09-25 21:00:00','2019-12-21',3,5,'87152364945','16120711 8108','16950129 5753',NULL),(24,24,'Rashad','Mcconnell',43,'2019-12-17 21:00:00','2020-03-24',1,1,'83511889096','16170429 8577','16351121 6727',NULL),(25,25,'Noble','Torres',60,'2021-05-04 21:00:00','2019-05-21',3,5,'84925844196','16200329 9571','16531107 1160',NULL),(26,26,'Daquan','King',19,'2020-04-01 21:00:00','2020-10-28',2,2,'89774521177','16930523 1608','16660618 3835',NULL),(27,27,'Reed','Morin',20,'2021-02-27 21:00:00','2019-08-21',1,2,'81927514364','16000730 1450','16240324 9531',NULL),(28,28,'Ralph','Rosa',86,'2019-08-22 21:00:00','2019-05-23',3,5,'85061002743','16820514 5561','16120202 0077',NULL),(29,29,'Nolan','Valdez',39,'2019-07-06 21:00:00','2019-05-17',1,3,'83513782965','16571130 9061','16580922 6219',NULL),(30,30,'Price','Boyd',85,'2020-05-06 21:00:00','2020-05-17',1,4,'88117228504','16331227 6375','16660730 3374',NULL),(31,31,'Tanner','Benjamin',19,'2020-11-23 21:00:00','2019-06-23',2,3,'87007732083','16220516 0167','16060626 5007',NULL),(32,32,'Gannon','Hogan',14,'2020-09-07 21:00:00','2019-08-09',1,5,'87945474429','16070924 8926','16370915 2403',NULL),(33,33,'Kieran','Ayala',11,'2020-06-22 21:00:00','2021-03-02',3,4,'84836672838','16320127 2196','16401202 8058',NULL),(34,34,'Giacomo','Day',53,'2021-03-23 21:00:00','2020-09-30',1,5,'85382673714','16201112 7574','16361121 3798',NULL),(35,35,'Marvin','York',61,'2019-09-08 21:00:00','2019-11-18',3,1,'82714450431','16751214 7179','16921010 0708',NULL),(36,36,'Michael','Terry',58,'2020-05-15 21:00:00','2021-04-27',1,5,'83448305548','16120511 0941','16330911 8374',NULL),(37,37,'Macaulay','Morales',86,'2019-09-03 21:00:00','2021-05-01',3,4,'85177781419','16471029 6866','16901109 2591',NULL),(38,38,'Oliver','Hopkins',11,'2019-11-06 21:00:00','2019-10-13',2,4,'89501720541','16281103 5753','16121124 3074',NULL),(39,39,'Peter','Lyons',41,'2019-05-16 21:00:00','2019-05-29',2,1,'89611381785','16111005 8185','16301003 8606',NULL),(40,40,'Vladimir','Craig',73,'2020-10-18 21:00:00','2019-07-18',1,1,'89825504432','16330710 6553','16890510 0155',NULL),(41,41,'Dexter','Garrett',83,'2020-03-26 21:00:00','2021-01-15',1,4,'85863893591','16040702 1344','16240218 2014',NULL),(42,42,'Troy','Gay',58,'2019-12-29 21:00:00','2020-01-19',1,2,'87733127276','16560115 7497','16711122 8727',NULL),(43,43,'Bevis','Horne',86,'2020-10-25 21:00:00','2020-11-20',3,4,'86316426487','16621018 2280','16270822 2563',NULL),(44,44,'Barry','Key',39,'2019-08-03 21:00:00','2019-10-24',3,3,'82141556461','16560904 8912','16650913 5668',NULL),(45,45,'Yoshio','Berg',79,'2020-10-23 21:00:00','2020-04-03',3,2,'85486373903','16370205 7336','16670417 2557',NULL),(46,46,'Wallace','Mcbride',29,'2020-09-17 21:00:00','2019-07-17',2,4,'87224119899','16721129 7150','16871114 7069',NULL),(47,47,'Joseph','Gallegos',76,'2019-10-14 21:00:00','2020-04-27',2,5,'85284270953','16750617 1649','16280602 7054',NULL),(48,48,'Garrison','Dunn',73,'2020-07-19 21:00:00','2020-09-11',1,1,'83596329484','16941021 2014','16080202 3945',NULL),(49,49,'Travis','Knight',19,'2019-11-25 21:00:00','2020-08-26',1,3,'89162399953','16020919 0248','16090402 5475',NULL),(50,50,'Blaze','Downs',27,'2019-06-14 21:00:00','2021-04-22',3,4,'89348561572','16920421 9837','16730523 8086',NULL),(51,51,'Allistair','Sheppard',48,'2020-02-15 21:00:00','2021-05-11',1,3,'82085897846','16610404 5494','16860523 7927',NULL),(52,52,'Eaton','Gillespie',92,'2020-05-17 21:00:00','2020-12-13',1,3,'89583316053','16521004 0779','16341126 3415',NULL),(53,53,'Abel','Berg',11,'2020-12-09 21:00:00','2020-03-07',2,1,'82474290701','16520628 7616','16600102 3016',NULL),(54,54,'Merritt','Medina',16,'2020-11-13 21:00:00','2019-06-23',1,4,'87257562876','16231025 5928','16940314 4570',NULL),(55,55,'Caesar','Lloyd',16,'2021-03-02 21:00:00','2021-03-01',2,2,'88921256668','16360916 2429','16180302 5079',NULL),(56,56,'George','Robles',19,'2019-08-24 21:00:00','2019-07-11',3,2,'89115639338','16210726 5619','16970921 5934',NULL),(57,57,'Aquila','Cline',47,'2021-04-13 21:00:00','2020-07-06',2,2,'84281587286','16130730 6132','16350918 8896',NULL),(58,58,'Carlos','Nash',20,'2020-02-14 21:00:00','2020-12-18',3,2,'82673142072','16080522 2395','16400109 5126',NULL),(59,59,'Robert','Peck',15,'2020-08-21 21:00:00','2019-10-09',1,3,'83641851511','16600814 4351','16620904 2826',NULL),(60,60,'Hayden','Gillespie',11,'2021-03-01 21:00:00','2020-01-29',3,4,'85067877843','16830618 3727','16990916 4858',NULL),(61,61,'Kennan','Slater',16,'2020-03-04 21:00:00','2021-01-14',1,2,'83554385551','16720823 5577','16221027 0282',NULL),(62,62,'Finn','Rocha',55,'2020-12-16 21:00:00','2019-09-22',3,1,'88969227189','16080724 1252','16600726 1453',NULL),(63,63,'Chester','Tanner',70,'2019-07-30 21:00:00','2019-12-16',1,5,'81749126877','16811002 9926','16530805 6265',NULL),(64,64,'Harper','Whitaker',19,'2021-04-20 21:00:00','2019-08-12',1,3,'84836580553','16420309 3002','16040626 5140',NULL),(65,65,'Hammett','Pickett',54,'2021-01-30 21:00:00','2020-05-22',2,2,'88541687065','16571114 8790','16581212 2330',NULL),(66,66,'Ross','Weeks',98,'2019-12-02 21:00:00','2020-12-04',3,2,'82701946567','16070222 4619','16541229 3457',NULL),(67,67,'Timon','Fulton',58,'2020-09-03 21:00:00','2020-08-08',1,4,'81376363259','16250523 6501','16010221 9326',NULL),(68,68,'Brandon','Manning',5,'2020-04-24 21:00:00','2020-09-21',3,5,'81041000872','16270527 4518','16000719 4905',NULL),(69,69,'Kennan','Hawkins',4,'2019-11-30 21:00:00','2020-05-29',2,2,'87591787901','16760203 0863','16600719 2419',NULL),(70,70,'Dustin','Moon',53,'2020-06-04 21:00:00','2019-09-21',1,2,'88113863525','16260917 7155','16960517 8400',NULL),(71,71,'Duncan','Melendez',70,'2020-05-24 21:00:00','2020-08-09',2,3,'82329581045','16750325 5502','16191105 1629',NULL),(72,72,'Travis','Gallegos',88,'2019-08-17 21:00:00','2020-01-26',1,1,'84322027279','16740119 6840','16480923 0925',NULL),(73,73,'August','Battle',24,'2020-01-04 21:00:00','2020-03-25',2,4,'87231689948','16541014 3274','16590129 6359',NULL),(74,74,'Fletcher','Bishop',41,'2020-08-15 21:00:00','2020-11-04',2,1,'85723479194','16510326 4379','16500211 3412',NULL),(75,75,'Emmanuel','Lee',18,'2021-01-20 21:00:00','2020-05-21',3,5,'89779626457','16110717 5778','16941205 1287',NULL),(76,76,'Hamish','Merrill',21,'2020-02-15 21:00:00','2020-03-10',2,2,'88512506871','16621225 4343','16180630 3838',NULL),(77,77,'Laith','Keith',65,'2019-12-17 21:00:00','2021-02-04',1,3,'89395918923','16980123 0252','16761230 1320',NULL),(78,78,'Edward','Sawyer',97,'2020-08-18 21:00:00','2019-08-30',3,1,'82088661636','16840720 5601','16200719 4471',NULL),(79,79,'Baxter','Whitfield',24,'2019-08-18 21:00:00','2020-01-20',2,2,'83892151858','16490927 0151','16350108 7948',NULL),(80,80,'Kibo','Bass',89,'2021-02-27 21:00:00','2020-01-04',2,4,'86364799375','16750304 1951','16811203 1847',NULL),(81,81,'Tate','Peterson',46,'2020-09-19 21:00:00','2021-01-09',3,3,'85173673780','16821019 9645','16790913 6363',NULL),(82,82,'Linus','Burnett',73,'2021-05-04 21:00:00','2021-01-05',2,2,'81599468980','16660713 2377','16050613 2638',NULL),(83,83,'Caesar','Coleman',20,'2020-10-25 21:00:00','2019-11-02',3,3,'83089874724','16121122 7721','16370506 8199',NULL),(84,84,'Devin','Frank',16,'2020-05-19 21:00:00','2020-05-19',2,3,'82757316927','16390606 3098','16400612 3964',NULL),(85,85,'Murphy','Sears',93,'2020-02-10 21:00:00','2020-03-04',2,3,'87575435971','16770318 6911','16710607 1009',NULL),(86,86,'Raja','Schroeder',94,'2019-12-16 21:00:00','2020-09-25',1,4,'88285950741','16280822 3016','16370803 6417',NULL),(87,87,'Jarrod','Kerr',56,'2020-10-05 21:00:00','2020-12-19',3,1,'89541792128','16320618 6458','16680808 7149',NULL),(88,88,'Upton','Padilla',47,'2020-03-22 21:00:00','2020-04-16',2,2,'84993148518','16960312 0883','16920427 2836',NULL),(89,89,'Cairo','Mcdaniel',76,'2019-07-03 21:00:00','2021-02-05',2,3,'81985135097','16680521 8952','16351215 4851',NULL),(90,90,'Kirk','Gordon',48,'2020-09-09 21:00:00','2019-12-24',1,1,'89688778853','16460101 6282','16010515 7192',NULL),(91,91,'Upton','Galloway',45,'2019-12-12 21:00:00','2019-08-20',3,4,'87224309379','16630401 5503','16031222 2532',NULL),(92,92,'Hasad','Mcintyre',22,'2020-09-01 21:00:00','2020-09-01',3,3,'82972292600','16900411 0905','16380710 3878',NULL),(93,93,'Keane','Bright',79,'2020-09-01 21:00:00','2020-03-09',2,4,'87185964554','16051110 0265','16661010 6905',NULL),(94,94,'Talon','Haney',77,'2021-05-12 21:00:00','2020-09-22',3,5,'83995818319','16090811 8573','16160327 5775',NULL),(95,95,'Graham','Cline',94,'2020-09-13 21:00:00','2020-04-12',2,1,'82792497229','16971007 3421','16700130 2095',NULL),(96,96,'Norman','Randall',38,'2021-05-10 21:00:00','2019-08-06',3,1,'82029227497','16160404 9708','16161109 5819',NULL),(97,97,'Nolan','Yang',63,'2019-10-14 21:00:00','2019-10-29',3,3,'82106959576','16390825 4240','16110807 1216',NULL),(98,98,'Chase','Burke',75,'2020-12-10 21:00:00','2019-07-03',2,2,'81936268917','16100206 7880','16971211 8836',NULL),(99,99,'Lester','Manning',54,'2019-06-18 21:00:00','2020-05-28',3,2,'87694283859','16230601 4115','16240618 9395',NULL),(100,100,'Rafael','Poole',63,'2020-08-01 21:00:00','2020-03-22',1,3,'89305502533','16780930 9896','16160229 5972',NULL),(102,103,'test','testov',100,'2020-07-13 09:25:48','2020-03-22',1,2,'89305502533','16780930 9896','16160229 5972','2020-07-13 08:25:10'),(103,104,NULL,NULL,NULL,'2020-12-26 09:05:35',NULL,1,0,NULL,NULL,NULL,NULL);
  /*!40000 ALTER TABLE `user_info` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_visit`
  --
  
  DROP TABLE IF EXISTS `user_visit`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `user_visit` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_visitor_id` int NOT NULL,
    `user_guest_id` int NOT NULL,
    PRIMARY KEY (`id`),
    KEY `user_visitor_id` (`user_visitor_id`),
    KEY `user_guest_id` (`user_guest_id`),
    CONSTRAINT `user_visit_ibfk_1` FOREIGN KEY (`user_visitor_id`) REFERENCES `user` (`id`),
    CONSTRAINT `user_visit_ibfk_2` FOREIGN KEY (`user_guest_id`) REFERENCES `user` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_visit`
  --
  
  LOCK TABLES `user_visit` WRITE;
  /*!40000 ALTER TABLE `user_visit` DISABLE KEYS */;
  INSERT INTO `user_visit` VALUES (1,19,38),(2,21,94),(3,98,65),(4,73,10),(5,35,57),(6,46,40),(7,98,39),(8,28,26),(9,52,97),(10,1,44),(11,5,36),(12,56,36),(13,79,48),(14,58,52),(15,43,72),(16,95,80),(17,75,16),(18,83,88),(19,19,32),(20,36,7),(21,65,44),(22,87,28),(23,4,26),(24,30,87),(25,21,47),(26,83,62),(27,23,61),(28,41,63),(29,47,35),(30,17,20),(31,91,36),(32,100,78),(33,81,99),(34,82,77),(35,1,29),(36,16,20),(37,34,58),(38,71,66),(39,54,61),(40,26,68),(41,15,39),(42,80,98),(43,29,36),(44,34,75),(45,19,28),(46,89,95),(47,9,7),(48,80,72),(49,85,57),(50,75,60),(51,32,96),(52,34,82),(53,95,53),(54,50,39),(55,19,39),(56,17,34),(57,44,93),(58,62,8),(59,56,93),(60,39,46),(61,80,53),(62,69,66),(63,87,3),(64,17,5),(65,93,71),(66,62,15),(67,99,60),(68,70,6),(69,91,41),(70,62,94),(71,22,41),(72,38,28),(73,29,14),(74,36,33),(75,80,67),(76,1,13),(77,24,88),(78,89,98),(79,98,92),(80,98,54),(81,88,51),(82,100,38),(83,94,26),(84,86,84),(85,45,9),(86,31,27),(87,36,80),(88,14,83),(89,8,75),(90,62,24),(91,87,59),(92,30,51),(93,45,10),(94,27,20),(95,4,61),(96,32,65),(97,12,48),(98,9,14),(99,61,100),(100,97,23);
  /*!40000 ALTER TABLE `user_visit` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Dumping routines for database 'TASK_FORCE'
  --
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2020-12-27 17:21:20
  