SQL Bridgemanimages.co.uk (12.17.2020)

[validator]

Bridgeman Images - ведущие мировые специалисты по распространению произведений искусства, культурно-исторических изображений и видеоматериалов для репродукции. Имеют почти 50-летний опыт работы с изображениями от самых престижных музеев, коллекций и художников.

База данных сайта Bridgemanimages.co.uk. Много файлов с различной структурой и данными. Например, в файле contacts.sql почти 198 тысяч строк, а в файле clients.sql около 100 тысяч строк.

Дата создания дампа - 17.12.2020

Мысли создателя дампа по поводу количества уникальных пользователей - около 46 тысяч (подсчитано по использованию популярных почтовых сервисов, gmail, yahoo, hotmail, aol и outlook, поскольку было много поддельных учетных записей).

Спойлер: Содержимое архива

1.4G ./orderitems.sql
239M ./orders.sql
123M ./contacts.sql
55M ./clients.sql
54M ./clients_backup_2020_01_28_1553.sql
48M ./registrations.sql
42M ./clients_backup_2018_04_24.sql
32M ./contactmethods.sql
29M ./invoices.sql
28M ./clients_temp.sql
27M ./addresses.sql
22M ./creators.sql
8.0M ./projectdeliverycontacts.sql

Спойлер: Пример строк из файла contacts.sql

INSERT INTO `contacts` (`contact_id`, `contact_office_id`, `contact_title`, `contact_first_name`, `contact_middle_name`, `contact_last_name`, `contact_suffix`, `contact_display_as`, `contact_gender`, `contact_department`, `contact_job_title`, `contact_telephone`, `contact_initials`, `contact_gls_initials`, `contact_is_default`, `contact_guest`, `contact_is_primary`, `contact_is_staff`, `contact_studio_status`, `contact_manager_name`, `contact_assistant_name`, `contact_email`, `contact_staff_user_id`, `contact_username`, `contact_password`, `contact_password_hash`, `contact_password_sha1`, `contact_comments`, `contact_created`, `contact_last_modified`, `contact_created_contact_id`, `contact_last_modified_contact_id`, `contact_pimms_guid`, `contact_pimms_uuid`, `contact_gls_id`, `contact_deleted`, `contact_current_lightbox_id`, `contact_owner_id`, `contact_owner_type`, `contact_type_other`, `contact_address_id`, `contact_email_newsletter`, `contact_results_per_page`, `contact_thumbnail_size`, `contact_current_project_id`, `contact_registration_id`, `contact_reset_password_key`, `contact_phone`, `contact_mobile`, `contact_fax`, `contact_second_email`, `contact_second_phone`, `contact_third_phone`, `contact_second_fax`, `contact_sap_status`, `contact_last_sap_sync`, `contact_id_SAP_L`, `contact_id_SAP_P`, `contact_id_SAP_B`, `contact_id_SAP_N`, `contact_status`, `contact_current_office_id`, `contact_display_metadataformat_id`, `contact_email_is_shared`, `contact_breadcrumb_format`, `contact_search_assettype_id`, `contact_password_salt`, `contact_wp_token_value`, `contact_wp_token_expire`, `contact_wp_ip`, `contact_wp_user_id`, `contact_wp_magic_token_value`, `contact_wp_magic_token_expire`, `contact_reset_password_key_log`, `contact_sync_to_hubspot`) VALUES

(3, 1, NULL, 'Martha', NULL, 'Lineham', NULL, 'Martha Lineham', 'M', NULL, NULL, NULL, 'ML', 'HA', 0, 0, 0, 0, 'no', NULL, NULL, 'Martha.Lineham@bridgemanart.co.uk', 'mlineham', 'MLineham', 'guest', NULL, '{SHA}2ZAcs1tb5pTF20DHpO2XxyH21DE=', NULL, '2008-05-22 09:08:49', '2009-10-20 13:15:13', 1, 70, '90B6B1E1-E63F-48A5-B2DD-069535D38EC1', 687, 5, 1, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'dead', 1, NULL, 0, 'projects_lightboxes_auto', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),

(4, 3, '', 'NY', '', 'Intern', '', 'NY Intern', 'F', '', '', NULL, NULL, NULL, 0, 0, 0, 1, 'no', '', '', 'BridgemanIntern@bridgemanimages.com', 'nyintern', 'nyintern', 'N8iwz5', 'LzA6Nn1KTGCJugNe0mc6K2LWM5RIUj8fvB2kXJOewsg=', '{SHA}aSsONiafQEeNW/ISA5yfEBE8IWM=', NULL, '2008-05-22 09:08:49', '2020-02-27 15:13:36', 1, 132376, '5FE3ECC3-F0F0-4C62-BACB-F6243D7F1FCA', 688, 3, 0, 18382462, 53652, 'client', NULL, NULL, 0, 200, 150, NULL, NULL, NULL, '', '', '', '', '', '', '', 'update_sap', '2015-02-04 00:00:00', NULL, NULL, NULL, NULL, 'live', 3, NULL, 0, 'lightboxes_only', NULL, 'KFgAFkV7k55LnQ73/jA7PuMHqFusXGwrllj5FAOHK/k=', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),

(5, 1, '', 'Adrian', '', 'Gibbs', '', 'Adrian Gibbs', 'M', '', '', NULL, 'AG', NULL, 0, 0, 1, 1, 'no', '', '', 'adrianmpgibbs@yahoo.co.uk', 'agibbs', 'AGibbs', 'Ljglmd', 'T23sh3k2hkozlqW2LtBYsBhw6XfcXksM1qRTDkHnZE=', '{SHA}AjcD20iRO9qDmUAkKwO2zQLr+28=', NULL, '2008-05-22 09:08:49', '2020-03-11 15:42:25', 1, 5, 'E5E2D4D5-9C02-420E-A8F7-2D86F0235092', 689, 4, 0, 18270871, 524, 'supplier', NULL, 45705, 0, 200, 150, NULL, NULL, NULL, '', '07947 352326', '', '', '', '', '', 'sap_updated', '2020-03-11 00:00:00', NULL, NULL, NULL, NULL, 'live', 1, NULL, 1, 'lightboxes_only', NULL, 'Li4cNnQyH/eXUjI6RCDoTQW6zLhVXhtgvQr9ptEa7fQ=', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),

(6, 1, NULL, 'Hannah', NULL, 'Armstrong', NULL, 'Hannah Armstrong', 'M', NULL, NULL, NULL, 'HA', NULL, 0, 0, 0, 0, 'no', NULL, NULL, 'Hannah.Armstrong@bridgemanart.co.uk', 'harmstrong', 'HArmstrong', 'guest', 'qt0c+o35k087C5ImqCXy0g1hDG8lXdOGgNUPxIbsRAY=', '{SHA}1sIhVMtgq5mksX9gKTZJ7wnXdZ4=', NULL, '2008-05-22 09:08:49', '2009-10-20 13:05:58', 1, 70, '072DB5DD-A3B7-401C-B3F4-D1757549F33C', 690, 5, 0, NULL, NULL, NULL, NULL, NULL, 0, 60, 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'live', 1, NULL, 0, 'projects_lightboxes_auto', NULL, '2WsCunjM5UJ5CldYu2CWtQA5Ytsmq1cwxNPc38jAS+U=', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),

(7, 1, '', 'Katrien', '', 'Demoor', '', 'Katrien Demoor', 'M', '', '', NULL, 'KD', NULL, 0, 0, 0, 1, 'no', '', '', 'Katrien.Demoor@bridgemanimages.com', 'kdemoor', 'KDemoor', 'Azvc6t', 'm71BxpZTd9rdPi56MRZDil3YS93bvJZ3mWNIBPtTxbU=', '{SHA}khyTOFqnZvyhd8KfeEF2/dIEDHA=', NULL, '2008-05-22 09:08:49', '2020-02-27 13:17:30', 1, 132376, 'BF69794E-5259-49A6-86AA-99047F5D67FE', 691, 6, 0, NULL, 58766, 'client', NULL, NULL, 0, 200, 150, NULL, NULL, NULL, '', '', '', '', '', '', '', 'sap_update_error', '2016-05-24 00:00:00', NULL, NULL, NULL, NULL, 'live', 1, NULL, 0, 'lightboxes_only', NULL, 'PI3B9t3Ebf393z5BvL7QRfx93Rj4o1rGGeVhihO9XUQ=', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0),

https://sql.gg/download/d186Nkb6sPh6x0FFOrYjunRBdM4Az-LHhttps://anonfiles.com/R6Obp350q4/bridgemanimages_7zhttp://www.mediafire.com/file/vzkkzplayun20a5/bridgemanimages.7z/file