Yandex Food
2022
Domain:
eda.yandex.ru
Breach Count:
49,441,686
Region:
Global
Source:
File Size:
7.95 GB
Uncompressed File Size:
50.68 GB
File Count:
3
The Yandex Food data leak occurred in March 2022, exposing the personal information of 49,441,686 users of the food delivery service. The leaked data included names, phone numbers, email addresses, home addresses, and order histories.
The leak was caused by a vulnerability in Yandex Foods mobile app that allowed attackers to access its database. The vulnerability was discovered by security researcher Bob Diachenko, who reported it to Yandex. However, Yandex reportedly ignored the researchers warnings for three weeks, which allowed the attacker to steal the data and leak it to the public.
The Yandex Food leak is one of the largest data breaches in recent history and has raised concerns about the security of personal data in the digital age. The leak has also damaged Yandexs reputation and could result in legal action against the company.
Leaked Information:
Full Name
Address
Phone
We have loaded this breach into our database.
File List:
part1.sql
part2.sql
part3.sql
File Content Sample:
CREATE TABLE `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`address_city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`address_street` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_house` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_entrance` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_floor` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_office` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_comment` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_reliable` tinyint(1) DEFAULT NULL,
`address_full` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_short` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_plot` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_building` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`courier_id` int(11) DEFAULT NULL,
`adopted_by_courier` tinyint(1) NOT NULL,
`adopted_by_courier_at` datetime DEFAULT NULL,
`courier_arrived_to_place_at` datetime DEFAULT NULL,
`courier_assigned_at` datetime DEFAULT NULL,
`arrived_to_customer_at` datetime DEFAULT NULL,
`taken_at` datetime DEFAULT NULL,
`moved_to_delivery_at` datetime DEFAULT NULL,
`delivered_at` datetime DEFAULT NULL,
`time_to_delivery` int(11) DEFAULT NULL,
`time_to_delivery_min` int(11) DEFAULT NULL,
`time_to_delivery_max` int(11) DEFAULT NULL,
`pre_delivery_time` int(11) NOT NULL,
`location_latitude` decimal(10,6) NOT NULL,
`location_longitude` decimal(10,6) NOT NULL,
`notify_priority` datetime NOT NULL,
`notify_priority_up_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`operator_id` int(11) DEFAULT NULL,
`operator_assigned_at` datetime DEFAULT NULL,
`external_order_nr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`order_nr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`amount_blocked` int(11) NOT NULL DEFAULT '0',
`currency` char(3) COLLATE utf8_unicode_ci NOT NULL,
`amount_charged` int(11) NOT NULL DEFAULT '0',
`actual_amount` int(11) DEFAULT NULL,
`amount_client_paid` int(11) DEFAULT NULL,
`card_payment_failed_at` datetime DEFAULT NULL,
`payment_method_id` int(11) NOT NULL,
`payment_status` smallint(6) NOT NULL DEFAULT '0',
`payment_service` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`place_payment_method_id` int(11) NOT NULL,
`payture_card_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`payture_order_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`payture_session_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_id` int(11) NOT NULL,
`yandex_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_address_id` int(11) DEFAULT NULL,
`crm_comment` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`phone_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`user_agent` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
`change_on` int(11) DEFAULT NULL,
`persons_quantity` int(11) DEFAULT NULL,
`sort_priority` datetime NOT NULL,
`status` smallint(6) NOT NULL,
`is_asap` tinyint(1) NOT NULL,
`is_comment_transmitted` tinyint(1) NOT NULL DEFAULT '0',
`is_delayed` tinyint(1) NOT NULL DEFAULT '0',
`started_at` datetime DEFAULT NULL,
`call_center_confirmed_at` datetime DEFAULT NULL,
`cancelled_at` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`sent_to_restaurant_at` datetime DEFAULT NULL,
`place_confirmed_at` datetime DEFAULT NULL,
`restaurant_received_at` datetime DEFAULT NULL,
`reminded_call_at` datetime DEFAULT NULL,
`remind_at` datetime DEFAULT NULL,
`reminded_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`cancel_reason_id` int(11) DEFAULT NULL,
`cart_id` bigint(20) DEFAULT NULL,
`place_id` int(11) NOT NULL,
`device_id` int(11) DEFAULT NULL,
`feedback_id` int(11) DEFAULT NULL,
`promocode_id` int(11) DEFAULT NULL,
`sorry_promocode_sent_at` datetime DEFAULT NULL,
`logistic_approve_needed` tinyint(1) NOT NULL DEFAULT '0',
`available_delivery_delay` int(11) NOT NULL DEFAULT '0',
`place_call_requested_at` datetime DEFAULT NULL,
`type` enum('native','marketplace') COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:order_type)',
`processing_type` enum('native','marketplace','fast_food','store') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '(DC2Type:order_processing_type)',
`address_doorcode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`region_id` int(11) unsigned DEFAULT NULL,
`place_commission` decimal(4,2) DEFAULT NULL,
`place_acquiring_commission` decimal(4,2) DEFAULT NULL,
`time_to_place` int(11) DEFAULT NULL,
`place_delivery_zone_id` int(10) unsigned DEFAULT NULL,
`finished_at` datetime DEFAULT NULL,
`fully_payed` tinyint(1) NOT NULL DEFAULT '0',
`legal_info_id` int(11) DEFAULT NULL,
`latest_revision_id` int(10) unsigned DEFAULT NULL,
`taxi_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`app` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Идентификатор Ð¿Ñ€Ð¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ñ Ñ€ÐµÐºÐ²ÐµÑта',
`flow_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'native' COMMENT 'Order Flow identity',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_E52FFDEE1AD5CDBF` (`cart_id`),
UNIQUE KEY `order_nr_idx` (`order_nr`),
UNIQUE KEY `UNIQ_E52FFDEE9E53D244` (`payture_order_id`),
UNIQUE KEY `UNIQ_E52FFDEED906FC5D` (`external_order_nr`),
UNIQUE KEY `UNIQ_E52FFDEED249A887` (`feedback_id`),
KEY `IDX_E52FFDEEA76ED395` (`user_id`),
KEY `IDX_E52FFDEEE3D8151C` (`courier_id`),
KEY `IDX_E52FFDEEC76C06D9` (`promocode_id`),
KEY `idx_created_at` (`created_at`),
KEY `IDX_E52FFDEE584598A3` (`operator_id`),
KEY `IDX_E52FFDEEEE1A430C` (`cancel_reason_id`),
KEY `idx_sort_priority` (`sort_priority`),
KEY `idx_notify_priority` (`notify_priority`),
KEY `IDX_E52FFDEE52D06999` (`user_address_id`),
KEY `IDX_E52FFDEE94A4C7D4` (`device_id`),
KEY `idx_payture_session_id` (`payture_session_id`),
KEY `idx_phone_number` (`phone_number`),
KEY `idx_status_courier_delivered` (`status`,`courier_id`,`delivered_at`),
KEY `fk_orders_region` (`region_id`),
KEY `idx_place_confirmed_at` (`place_confirmed_at`),
KEY `idx_restaurant_received_at` (`restaurant_received_at`),
KEY `idx_finished_at` (`finished_at`),
KEY `IDX_E52FFDEEDA6A219` (`place_id`),
KEY `IDX_E52FFDEE9AB05F96` (`legal_info_id`),
KEY `IDX_E52FFDEEC6556E3E` (`latest_revision_id`),
KEY `idx__orders__place_id__status__type` (`place_id`,`status`,`type`),
KEY `idx_place_delivery_zone_id` (`place_delivery_zone_id`),
KEY `idx__orders__yandex_uid` (`yandex_uid`),
KEY `idx__orders__courier_assigned_at` (`courier_assigned_at`),
KEY `idx__orders__updated_at` (`updated_at`),
CONSTRAINT `FK_E52FFDEE52D06999` FOREIGN KEY (`user_address_id`) REFERENCES `user_addresses` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_E52FFDEE584598A3` FOREIGN KEY (`operator_id`) REFERENCES `admins` (`id`),
CONSTRAINT `FK_E52FFDEE94A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `user_devices` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_E52FFDEEA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `FK_E52FFDEEC6556E3E` FOREIGN KEY (`latest_revision_id`) REFERENCES `order_revisions` (`id`),
CONSTRAINT `FK_E52FFDEEC76C06D9` FOREIGN KEY (`promocode_id`) REFERENCES `promocodes` (`id`),
CONSTRAINT `FK_E52FFDEED249A887` FOREIGN KEY (`feedback_id`) REFERENCES `order_feedbacks` (`id`),
CONSTRAINT `FK_E52FFDEEDA6A219` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`),
CONSTRAINT `FK_E52FFDEEE3D8151C` FOREIGN KEY (`courier_id`) REFERENCES `couriers` (`id`),
CONSTRAINT `FK_E52FFDEEEE1A430C` FOREIGN KEY (`cancel_reason_id`) REFERENCES `order_problem_dictionary` (`id`),
CONSTRAINT `__FK_E52FFDEE9AB05F96` FOREIGN KEY (`legal_info_id`) REFERENCES `legal_info` (`id`),
CONSTRAINT `fk_orders_region` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=732672207 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (726928131,'Иваново','3-я Березниковская улица','9',NULL,NULL,NULL,NULL,1,'Россия, Иваново, 3-я Березниковская улица, 9','Иваново, 3-я Березниковская улица, 9',NULL,NULL,2545580,1,'2022-01-29 19:10:30','2022-01-29 19:21:49','2022-01-29 19:10:29','2022-01-29 19:58:07','2022-01-29 19:31:47','2022-01-29 19:23:39','2022-01-29 20:00:06',34,50,70,48,56.982917,40.951584,'2022-01-29 19:07:02',NULL,NULL,NULL,'3c7ea298e6a786c0f1641771c778a09c.0c58679c4e41076abca8a1cc7dc38fe0','220129-303746',0,'RUB',1050,NULL,1050,NULL,1,2,'EatsPayments',2,NULL,NULL,NULL,325426382,'777487312',130554861,NULL,'Анна Балашова','+79965177323','Mozilla/5.0 (Linux; Android 9; LLD-L31 Build/HONORLLD-L31; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/97.0.4692.98 Mobile Safari/537.36 yandex-taxi/4.68.1.122258 Android/9 (HUAWEI; LLD-L31) Superapp/Eats EatsKit/3.5.0',NULL,0,'2022-01-29 19:07:02',4,1,1,0,'2022-01-29 19:07:04','2022-01-29 19:07:02',NULL,'2022-01-29 19:06:48',NULL,'2022-01-29 19:23:38','2022-01-29 19:23:38',NULL,'2022-01-29 19:21:39','2022-01-29 19:22:39','2022-01-29 20:00:07',NULL,NULL,152785,NULL,721441086,NULL,NULL,0,20,NULL,'native','fast_food',NULL,57,NULL,NULL,2,940464,'2022-01-29 20:00:06',1,2,759740991,'854b701d9521472da4808fe148ffc021','superapp_android','native'),(726928136,'Москва','Волгоградский проспект','110к3','3','2','145',NULL,1,NULL,NULL,NULL,NULL,1933619,1,'2022-01-30 11:33:08','2022-01-30 11:44:29','2022-01-30 11:33:02','2022-01-30 12:23:42','2022-01-30 11:52:00',NULL,'2022-01-30 12:28:06',46,120,150,128,55.702394,37.775918,'2022-01-30 09:22:03','remind',NULL,NULL,'c4c18271226068fc0aecf4514e32a13f.a613951160ead0608d76dceb9def8a2d','220129-286865',0,'RUB',8440,NULL,8440,NULL,1,2,'EatsPayments',2,NULL,NULL,NULL,27016828,'881151785',40329418,NULL,'Татьяна','+79104457179','android (2.64.0)',NULL,0,'2022-01-30 09:22:03',4,0,1,0,NULL,'2022-01-29 19:07:00',NULL,'2022-01-29 19:06:48','2022-01-30 11:07:06','2022-01-30 10:00:17','2022-01-29 19:07:06',NULL,'2022-01-30 09:22:00','2022-01-30 09:22:03','2022-01-30 12:28:07',NULL,NULL,377967,281020701,721441091,NULL,NULL,0,-10,NULL,'native','native','145 вызов',630,NULL,NULL,NULL,3382076,'2022-01-30 12:28:06',1,2,760217061,NULL,'eda_android','retail'),(726928141,'Санкт-Петербург','улица Оптиков','34к1','1','7','82',NULL,1,NULL,NULL,NULL,NULL,3528971,1,'2022-01-29 19:16:10','2022-01-29 19:24:33','2022-01-29 19:16:08','2022-01-29 19:52:01','2022-01-29 19:35:17','2022-01-29 19:34:25','2022-01-29 20:00:10',31,50,60,48,59.999764,30.216236,'2022-01-29 19:07:04',NULL,NULL,NULL,'046fd726-09cd-4bab-9ebd-c9cb34f6fef6','220129-107138',0,'RUB',825,NULL,825,NULL,1,2,'EatsPayments',2,NULL,NULL,NULL,326560702,'1543164609',127572123,NULL,'Тина Буценко','+79818188065','ios(5.28.0)',NULL,0,'2022-01-29 19:07:04',4,1,1,0,'2022-01-29 19:07:06','2022-01-29 19:07:04',NULL,'2022-01-29 19:06:49',NULL,'2022-01-29 19:23:57','2022-01-29 19:23:57',NULL,'2022-01-29 19:21:22','2022-01-29 19:22:22','2022-01-29 20:00:12',NULL,NULL,13832,281156866,721441096,NULL,NULL,0,10,NULL,'native','fast_food','Да',3,NULL,NULL,1,201341,'2022-01-29 20:00:10',1,2,759741011,NULL,'eda_iphone','native')
`id` int(11) NOT NULL AUTO_INCREMENT,
`address_city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`address_street` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_house` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_entrance` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_floor` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_office` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_comment` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_reliable` tinyint(1) DEFAULT NULL,
`address_full` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_short` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_plot` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`address_building` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`courier_id` int(11) DEFAULT NULL,
`adopted_by_courier` tinyint(1) NOT NULL,
`adopted_by_courier_at` datetime DEFAULT NULL,
`courier_arrived_to_place_at` datetime DEFAULT NULL,
`courier_assigned_at` datetime DEFAULT NULL,
`arrived_to_customer_at` datetime DEFAULT NULL,
`taken_at` datetime DEFAULT NULL,
`moved_to_delivery_at` datetime DEFAULT NULL,
`delivered_at` datetime DEFAULT NULL,
`time_to_delivery` int(11) DEFAULT NULL,
`time_to_delivery_min` int(11) DEFAULT NULL,
`time_to_delivery_max` int(11) DEFAULT NULL,
`pre_delivery_time` int(11) NOT NULL,
`location_latitude` decimal(10,6) NOT NULL,
`location_longitude` decimal(10,6) NOT NULL,
`notify_priority` datetime NOT NULL,
`notify_priority_up_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`operator_id` int(11) DEFAULT NULL,
`operator_assigned_at` datetime DEFAULT NULL,
`external_order_nr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`order_nr` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`amount_blocked` int(11) NOT NULL DEFAULT '0',
`currency` char(3) COLLATE utf8_unicode_ci NOT NULL,
`amount_charged` int(11) NOT NULL DEFAULT '0',
`actual_amount` int(11) DEFAULT NULL,
`amount_client_paid` int(11) DEFAULT NULL,
`card_payment_failed_at` datetime DEFAULT NULL,
`payment_method_id` int(11) NOT NULL,
`payment_status` smallint(6) NOT NULL DEFAULT '0',
`payment_service` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`place_payment_method_id` int(11) NOT NULL,
`payture_card_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`payture_order_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`payture_session_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_id` int(11) NOT NULL,
`yandex_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`user_address_id` int(11) DEFAULT NULL,
`crm_comment` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`phone_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`user_agent` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
`change_on` int(11) DEFAULT NULL,
`persons_quantity` int(11) DEFAULT NULL,
`sort_priority` datetime NOT NULL,
`status` smallint(6) NOT NULL,
`is_asap` tinyint(1) NOT NULL,
`is_comment_transmitted` tinyint(1) NOT NULL DEFAULT '0',
`is_delayed` tinyint(1) NOT NULL DEFAULT '0',
`started_at` datetime DEFAULT NULL,
`call_center_confirmed_at` datetime DEFAULT NULL,
`cancelled_at` datetime DEFAULT NULL,
`created_at` datetime NOT NULL,
`sent_to_restaurant_at` datetime DEFAULT NULL,
`place_confirmed_at` datetime DEFAULT NULL,
`restaurant_received_at` datetime DEFAULT NULL,
`reminded_call_at` datetime DEFAULT NULL,
`remind_at` datetime DEFAULT NULL,
`reminded_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`cancel_reason_id` int(11) DEFAULT NULL,
`cart_id` bigint(20) DEFAULT NULL,
`place_id` int(11) NOT NULL,
`device_id` int(11) DEFAULT NULL,
`feedback_id` int(11) DEFAULT NULL,
`promocode_id` int(11) DEFAULT NULL,
`sorry_promocode_sent_at` datetime DEFAULT NULL,
`logistic_approve_needed` tinyint(1) NOT NULL DEFAULT '0',
`available_delivery_delay` int(11) NOT NULL DEFAULT '0',
`place_call_requested_at` datetime DEFAULT NULL,
`type` enum('native','marketplace') COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:order_type)',
`processing_type` enum('native','marketplace','fast_food','store') COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '(DC2Type:order_processing_type)',
`address_doorcode` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`region_id` int(11) unsigned DEFAULT NULL,
`place_commission` decimal(4,2) DEFAULT NULL,
`place_acquiring_commission` decimal(4,2) DEFAULT NULL,
`time_to_place` int(11) DEFAULT NULL,
`place_delivery_zone_id` int(10) unsigned DEFAULT NULL,
`finished_at` datetime DEFAULT NULL,
`fully_payed` tinyint(1) NOT NULL DEFAULT '0',
`legal_info_id` int(11) DEFAULT NULL,
`latest_revision_id` int(10) unsigned DEFAULT NULL,
`taxi_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`app` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Идентификатор Ð¿Ñ€Ð¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ñ Ñ€ÐµÐºÐ²ÐµÑта',
`flow_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'native' COMMENT 'Order Flow identity',
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQ_E52FFDEE1AD5CDBF` (`cart_id`),
UNIQUE KEY `order_nr_idx` (`order_nr`),
UNIQUE KEY `UNIQ_E52FFDEE9E53D244` (`payture_order_id`),
UNIQUE KEY `UNIQ_E52FFDEED906FC5D` (`external_order_nr`),
UNIQUE KEY `UNIQ_E52FFDEED249A887` (`feedback_id`),
KEY `IDX_E52FFDEEA76ED395` (`user_id`),
KEY `IDX_E52FFDEEE3D8151C` (`courier_id`),
KEY `IDX_E52FFDEEC76C06D9` (`promocode_id`),
KEY `idx_created_at` (`created_at`),
KEY `IDX_E52FFDEE584598A3` (`operator_id`),
KEY `IDX_E52FFDEEEE1A430C` (`cancel_reason_id`),
KEY `idx_sort_priority` (`sort_priority`),
KEY `idx_notify_priority` (`notify_priority`),
KEY `IDX_E52FFDEE52D06999` (`user_address_id`),
KEY `IDX_E52FFDEE94A4C7D4` (`device_id`),
KEY `idx_payture_session_id` (`payture_session_id`),
KEY `idx_phone_number` (`phone_number`),
KEY `idx_status_courier_delivered` (`status`,`courier_id`,`delivered_at`),
KEY `fk_orders_region` (`region_id`),
KEY `idx_place_confirmed_at` (`place_confirmed_at`),
KEY `idx_restaurant_received_at` (`restaurant_received_at`),
KEY `idx_finished_at` (`finished_at`),
KEY `IDX_E52FFDEEDA6A219` (`place_id`),
KEY `IDX_E52FFDEE9AB05F96` (`legal_info_id`),
KEY `IDX_E52FFDEEC6556E3E` (`latest_revision_id`),
KEY `idx__orders__place_id__status__type` (`place_id`,`status`,`type`),
KEY `idx_place_delivery_zone_id` (`place_delivery_zone_id`),
KEY `idx__orders__yandex_uid` (`yandex_uid`),
KEY `idx__orders__courier_assigned_at` (`courier_assigned_at`),
KEY `idx__orders__updated_at` (`updated_at`),
CONSTRAINT `FK_E52FFDEE52D06999` FOREIGN KEY (`user_address_id`) REFERENCES `user_addresses` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_E52FFDEE584598A3` FOREIGN KEY (`operator_id`) REFERENCES `admins` (`id`),
CONSTRAINT `FK_E52FFDEE94A4C7D4` FOREIGN KEY (`device_id`) REFERENCES `user_devices` (`id`) ON DELETE SET NULL,
CONSTRAINT `FK_E52FFDEEA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `FK_E52FFDEEC6556E3E` FOREIGN KEY (`latest_revision_id`) REFERENCES `order_revisions` (`id`),
CONSTRAINT `FK_E52FFDEEC76C06D9` FOREIGN KEY (`promocode_id`) REFERENCES `promocodes` (`id`),
CONSTRAINT `FK_E52FFDEED249A887` FOREIGN KEY (`feedback_id`) REFERENCES `order_feedbacks` (`id`),
CONSTRAINT `FK_E52FFDEEDA6A219` FOREIGN KEY (`place_id`) REFERENCES `places` (`id`),
CONSTRAINT `FK_E52FFDEEE3D8151C` FOREIGN KEY (`courier_id`) REFERENCES `couriers` (`id`),
CONSTRAINT `FK_E52FFDEEEE1A430C` FOREIGN KEY (`cancel_reason_id`) REFERENCES `order_problem_dictionary` (`id`),
CONSTRAINT `__FK_E52FFDEE9AB05F96` FOREIGN KEY (`legal_info_id`) REFERENCES `legal_info` (`id`),
CONSTRAINT `fk_orders_region` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=732672207 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (726928131,'Иваново','3-я Березниковская улица','9',NULL,NULL,NULL,NULL,1,'Россия, Иваново, 3-я Березниковская улица, 9','Иваново, 3-я Березниковская улица, 9',NULL,NULL,2545580,1,'2022-01-29 19:10:30','2022-01-29 19:21:49','2022-01-29 19:10:29','2022-01-29 19:58:07','2022-01-29 19:31:47','2022-01-29 19:23:39','2022-01-29 20:00:06',34,50,70,48,56.982917,40.951584,'2022-01-29 19:07:02',NULL,NULL,NULL,'3c7ea298e6a786c0f1641771c778a09c.0c58679c4e41076abca8a1cc7dc38fe0','220129-303746',0,'RUB',1050,NULL,1050,NULL,1,2,'EatsPayments',2,NULL,NULL,NULL,325426382,'777487312',130554861,NULL,'Анна Балашова','+79965177323','Mozilla/5.0 (Linux; Android 9; LLD-L31 Build/HONORLLD-L31; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/97.0.4692.98 Mobile Safari/537.36 yandex-taxi/4.68.1.122258 Android/9 (HUAWEI; LLD-L31) Superapp/Eats EatsKit/3.5.0',NULL,0,'2022-01-29 19:07:02',4,1,1,0,'2022-01-29 19:07:04','2022-01-29 19:07:02',NULL,'2022-01-29 19:06:48',NULL,'2022-01-29 19:23:38','2022-01-29 19:23:38',NULL,'2022-01-29 19:21:39','2022-01-29 19:22:39','2022-01-29 20:00:07',NULL,NULL,152785,NULL,721441086,NULL,NULL,0,20,NULL,'native','fast_food',NULL,57,NULL,NULL,2,940464,'2022-01-29 20:00:06',1,2,759740991,'854b701d9521472da4808fe148ffc021','superapp_android','native'),(726928136,'Москва','Волгоградский проспект','110к3','3','2','145',NULL,1,NULL,NULL,NULL,NULL,1933619,1,'2022-01-30 11:33:08','2022-01-30 11:44:29','2022-01-30 11:33:02','2022-01-30 12:23:42','2022-01-30 11:52:00',NULL,'2022-01-30 12:28:06',46,120,150,128,55.702394,37.775918,'2022-01-30 09:22:03','remind',NULL,NULL,'c4c18271226068fc0aecf4514e32a13f.a613951160ead0608d76dceb9def8a2d','220129-286865',0,'RUB',8440,NULL,8440,NULL,1,2,'EatsPayments',2,NULL,NULL,NULL,27016828,'881151785',40329418,NULL,'Татьяна','+79104457179','android (2.64.0)',NULL,0,'2022-01-30 09:22:03',4,0,1,0,NULL,'2022-01-29 19:07:00',NULL,'2022-01-29 19:06:48','2022-01-30 11:07:06','2022-01-30 10:00:17','2022-01-29 19:07:06',NULL,'2022-01-30 09:22:00','2022-01-30 09:22:03','2022-01-30 12:28:07',NULL,NULL,377967,281020701,721441091,NULL,NULL,0,-10,NULL,'native','native','145 вызов',630,NULL,NULL,NULL,3382076,'2022-01-30 12:28:06',1,2,760217061,NULL,'eda_android','retail'),(726928141,'Санкт-Петербург','улица Оптиков','34к1','1','7','82',NULL,1,NULL,NULL,NULL,NULL,3528971,1,'2022-01-29 19:16:10','2022-01-29 19:24:33','2022-01-29 19:16:08','2022-01-29 19:52:01','2022-01-29 19:35:17','2022-01-29 19:34:25','2022-01-29 20:00:10',31,50,60,48,59.999764,30.216236,'2022-01-29 19:07:04',NULL,NULL,NULL,'046fd726-09cd-4bab-9ebd-c9cb34f6fef6','220129-107138',0,'RUB',825,NULL,825,NULL,1,2,'EatsPayments',2,NULL,NULL,NULL,326560702,'1543164609',127572123,NULL,'Тина Буценко','+79818188065','ios(5.28.0)',NULL,0,'2022-01-29 19:07:04',4,1,1,0,'2022-01-29 19:07:06','2022-01-29 19:07:04',NULL,'2022-01-29 19:06:49',NULL,'2022-01-29 19:23:57','2022-01-29 19:23:57',NULL,'2022-01-29 19:21:22','2022-01-29 19:22:22','2022-01-29 20:00:12',NULL,NULL,13832,281156866,721441096,NULL,NULL,0,10,NULL,'native','fast_food','Да',3,NULL,NULL,1,201341,'2022-01-29 20:00:10',1,2,759741011,NULL,'eda_iphone','native')