The database from hairpersona.ru, consisting of customers.sql (75k records), orders.sql (156k records), and address_book.sql (94k records), has been publicly released on b1nd, indicating a significant data breach where extensive user information may have been exposed.
Leak Date: 2024
INSERT INTO `orders`
INSERT INTO `customers`
INSERT INTO `address_book`
Leak Date: 2024
INSERT INTO `orders`
(`orders_id`, `guid`, `customers_id`, `customers_cid`, `customers_vat_id`, `customers_status`, `customers_status_name`, `customers_status_image`, `customers_status_discount`, `customers_name`, `customers_firstname`, `customers_secondname`, `customers_lastname`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_firstname`, `delivery_secondname`, `delivery_lastname`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_country_iso_code_2`, `delivery_address_format_id`, `billing_name`, `billing_firstname`, `billing_secondname`, `billing_lastname`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_country_iso_code_2`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `cc_start`, `cc_issue`, `cc_cvv`, `comments`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`, `account_type`, `payment_class`, `shipping_method`, `shipping_class`, `customers_ip`, `language`, `afterbuy_success`, `afterbuy_id`, `refferers_id`, `conversion_type`, `orders_ident_key`, `orig_reference`, `login_reference`, `ozon_logistic_order_id`, `delivery_tracking_code`, `post_id`, `sb_link`, `delivery_code_dalli`, `delivery_code_dalli_send`, `likes`, `dislikes`, `without_call`) VALUES
(550, '', 897, '', '', 1, 'Посетитель', 'guest_status.gif', 0.00, 'Лилия Велищанская', 'Лилия', '', 'Велищанская', '', '9Парковая57к3Акв21п2э1код21решетка866', '', 'Москва', '', '', 'Российская Федерация', '8495 780 41 78', 'floradog@mail.ru', 1, 'Лилия Велищанская', 'Лилия', '', 'Велищанская', '', '9Парковая57к3Акв21п2э1код21решетка866', '', 'Москва', '', '', 'Российская Федерация', 'RU', 1, 'Лилия Велищанская', 'Лилия', '', 'Велищанская', '', '9Парковая57к3Акв21п2э1код21решетка866', '', 'Москва', '', '', 'Российская Федерация', 'RU', 1, 'cod', '', '', '', '', '', '', '', '', '2011-03-25 19:15:25', '2011-03-23 17:17:37', 6, NULL, 'RUR', 1.000000, 0, 'cod', 'Доставка', 'free_free', '213.234.204.51', 'russian', 0, 0, '0', 1, NULL, '://?', '://?', '', '', '', '', NULL, 0, 0, 0, 0),
(528, '', 964, '', '', 1, 'Посетитель', 'guest_status.gif', 0.00, 'Елена Стуколова', 'Елена', '', 'Стуколова', '', 'Ленинский пр-т, 107', '', 'Москва', '', '', 'Российская Федерация', '8-910-452-46-80', 'elena.stukolova@inbox.ru', 1, 'Елена Стуколова', 'Елена', '', 'Стуколова', '', 'Ленинский пр-т, 107', '', 'Москва', '', '', 'Российская Федерация', 'RU', 1, 'Елена Стуколова', 'Елена', '', 'Стуколова', '', 'Ленинский пр-т, 107', '', 'Москва', '', '', 'Российская Федерация', 'RU', 1, 'cod', '', '', '', '', '', '', '', '', '2011-03-17 14:39:43', '2011-03-12 17:22:21', 6, NULL, 'RUR', 1.000000, 0, 'cod', 'Курьерская доставка (На указанный адрес доставки)', 'flat_flat', '195.210.151.2', 'russian', 0, 0, '0', 1, NULL, 'http://www.hairpersona.ru/index.php?cat=214', 'http://www.hairpersona.ru/index.php?cat=214', '', '', '', '', NULL, 0, 0, 0, 0),
INSERT INTO `customers`
(`customers_id`, `customers_cid`, `customers_vat_id`, `customers_vat_id_status`, `customers_warning`, `customers_status`, `customers_gender`, `customers_firstname`, `customers_secondname`, `customers_lastname`, `customers_dob`, `customers_email_address`, `customers_default_address_id`, `customers_telephone`, `customers_fax`, `customers_password`, `customers_newsletter`, `customers_newsletter_mode`, `member_flag`, `delete_user`, `account_type`, `password_request_key`, `payment_unallowed`, `shipping_unallowed`, `refferers_id`, `customers_date_added`, `customers_last_modified`, `orig_reference`, `login_reference`, `login_tries`, `login_time`, `customers_username`, `customers_fid`, `customers_sid`, `customers_personal_discount`, `bonus_total`, `date_send_return_mail`, `check_without_call`, `date_send_mail_count_bonus`) VALUES
(1, '', '', 0, NULL, 0, '', 'Dmitry', '', 'Иван', '0000-00-00 00:00:00', 'astral1979@yandex.ru', 1, '7 (977) 556-99-13', '', '629dc3ac02aaef4dad26cf44dd6cb646', '1', '0', '0', '0', 0, '', '', '', 0, '2010-01-25 20:25:17', '2023-11-21 10:23:41', NULL, NULL, '0', '2024-01-26 00:34:20', NULL, NULL, NULL, 0.00, 8036, '2021-09-17 00:00:26', 1, '2023-03-11 10:00:35'),
(7, NULL, '', 0, NULL, 2, '', 'Анастасия', '', 'Дипнер', '0000-00-00 00:00:00', 'adipner@74.ru', 7, '9127955474', '', 'c57615eba2e73eb0fff06354eadcf18f', '0', '0', '0', '1', 0, '', '', '', 0, '2010-02-23 15:00:30', '2010-02-23 15:00:30', 'http://www.hairpersona.ru/?gclid=CISowLuziKACFQU9ZgodH1WYHw', 'http://www.hairpersona.ru/?gclid=CISowLuziKACFQU9ZgodH1WYHw', '0', '2016-06-18 08:24:59', NULL, NULL, NULL, 0.00, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
(8, NULL, '', 0, NULL, 1, '', 'таня', '', 'баканова', '0000-00-00 00:00:00', 'tamaz7373@mail.ru', 8, '89037114210', '', '7be86c415a9b4c61ca2ad97c4261110e', '0', '0', '0', '1', 0, '', '', '', 0, '2010-02-23 19:43:47', '2010-02-23 19:43:47', 'http://win.mail.ru/cgi-bin/readmsg?id=12669339330000000799', 'http://win.mail.ru/cgi-bin/readmsg?id=12669339330000000799', '0', '0000-00-00 00:00:00', NULL, NULL, NULL, 0.00, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00'),
INSERT INTO `address_book`
(`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_secondname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`, `address_date_added`, `address_last_modified`) VALUES
(1, 1, '', 'hairpersona.ru', '', '', 'Иван', 'г Москва, ул Юных Ленинцев, д 66', NULL, '', 'Москва', '98', 176, 98, '2010-01-25 20:25:17', '2023-11-21 10:23:41'),
(8, 8, '', NULL, 'таня', '', 'баканова', 'б,черкизовская д,26 к2 кв 44', NULL, '', 'москва', NULL, 176, 98, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 7, '', NULL, 'Анастасия', '', 'Дипнер', 'пр.К.Маркса 2-139', NULL, '', 'Озёрск, Челябинская обл.', NULL, 176, 98, '2010-02-23 15:00:30', '2010-02-23 15:00:30'),