SQL vivadogs.com

[tudos]

взято с рейда
сайт : vivadogs.com
sql таблицы юзеров
дата : Jul 11, 2020
порядка 80к строк

Спойлер: что внутри?

`entity_id` int(10) UNSIGNED NOT NULL COMMENT 'Entity Id',
`website_id` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Website Id',
`email` varchar(255) DEFAULT NULL COMMENT 'Email',
`group_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Group Id',
`increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
`store_id` smallint(5) UNSIGNED DEFAULT 0 COMMENT 'Store Id',
`created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
`is_active` smallint(5) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Is Active',
`disable_auto_group_change` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Disable automatic group change based on VAT ID',
`created_in` varchar(255) DEFAULT NULL COMMENT 'Created From',
`prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix',
`firstname` varchar(255) DEFAULT NULL COMMENT 'First Name',
`middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name/Initial',
`lastname` varchar(255) DEFAULT NULL COMMENT 'Last Name',
`suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix',
`dob` date DEFAULT NULL COMMENT 'Date of Birth',
`password_hash` varchar(128) DEFAULT NULL COMMENT 'Password_hash',
`rp_token` varchar(128) DEFAULT NULL COMMENT 'Reset password token',
`rp_token_created_at` datetime DEFAULT NULL COMMENT 'Reset password token creation time',
`default_billing` int(10) UNSIGNED DEFAULT NULL COMMENT 'Default Billing Address',
`default_shipping` int(10) UNSIGNED DEFAULT NULL COMMENT 'Default Shipping Address',
`taxvat` varchar(50) DEFAULT NULL COMMENT 'Tax/VAT Number',
`confirmation` varchar(64) DEFAULT NULL COMMENT 'Is Confirmed',
`gender` smallint(5) UNSIGNED DEFAULT NULL COMMENT 'Gender',
`failures_num` smallint(6) DEFAULT 0 COMMENT 'Failure Number',
`first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure',
`lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock Expiration Date'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity';

​

Спойлер: пример

(150, 10, 'nacho1991lastablas@hotmail.es', 1, NULL, 3, '2019-10-21 05:26:29', '2019-10-24 10:13:21', 1, 0, NULL, NULL, 'Jose Ignacio', NULL, 'LUQUIN DEL PESO', NULL, '0000-00-00', 'ece5a6b44c63a39941b1f7a20ac96000cd93ed0372a3659fc6bcce0c25563850:YltkOMVKtshz2RvU4tRgGki9V7XV9nMJ:1', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL),
(541, 10, 'rosa_estudio@hotmail.com', 1, NULL, 3, '2020-01-20 13:18:31', '2020-05-29 09:05:52', 1, 0, NULL, NULL, 'Maria Rosa', NULL, 'OCAÑA CÓRCOLES', NULL, '2020-01-20', 'b3edeca76a257770d1693cf5bfb8d3d4364be7b2d48a96717b24ec07e04d5e50:cN8tyNSiW5UVoInNvyIsc7VG2Qt2g6c8:1', NULL, NULL, 138225, 138225, NULL, NULL, 0, 0, NULL, NULL),
(780, 10, 'janira@jflorido.es', 1, NULL, 3, '2019-10-21 05:26:33', '2019-10-24 10:13:21', 1, 0, NULL, NULL, 'JANRIA', NULL, 'MORENO', NULL, '0000-00-00', '0f4f9edbab33fbf7ed9cc6419c4dccdae29a85c2b84546258b5921d8b63b86a2:MyJUyLz249zan5oyxiJ5c2kvntWsvPuk:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),
(788, 10, 'deborah.benayas@gmail.com', 1, NULL, 3, '2019-10-21 05:26:34', '2019-10-24 10:13:21', 1, 0, NULL, NULL, 'Deborah ', NULL, 'Benayas Herencias', NULL, '0000-00-00', '28bcd054247b9bc47867f24413e51d8a220d08f307c1532dfb18e12c2b09b9f9:NDwyqN2JHRZRdkkly5qUUll4lZFfLv85:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),
(892, 10, 'peterkuhne@worldonline.es', 1, NULL, 3, '2019-10-21 05:26:34', '2019-10-24 10:13:21', 1, 0, NULL, NULL, 'Janine', NULL, 'KÜHNE', NULL, '0000-00-00', 'b9ce4382c1622e2b5c1cea778ae665f0ea5fdcd1243baa12333f450ad051c0d2:yZzRoMVDuUb1NrUzX92Dbmrdozoz2jbY:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),
(1043, 10, 'lastresescobitas@gmail.com', 1, NULL, 3, '2019-10-21 05:26:37', '2019-12-13 15:00:28', 1, 0, NULL, NULL, 'Ana', NULL, 'Reina Podadera', NULL, '0000-00-00', 'c6ecece4c357605d34096f589f11adfd84b5a6549810da1b1b4f732fec758ea5:07U6Bi7Xqbc6KZpKe6jTnpJDaALDXuK9:1', NULL, NULL, NULL, 136949, NULL, NULL, 0, 0, NULL, NULL),
(1428, 10, 'curuxina@hotmail.es', 1, NULL, 3, '2019-10-21 05:26:37', '2019-11-20 16:56:37', 1, 0, NULL, NULL, 'Julia', NULL, 'Martínez Funcasta', NULL, '0000-00-00', 'c9a3b8c5ae3ae168074baa6debeb565c5497cf587662deb7c722d7a65f47bdf3:lv0q3Of7NiRKgrLBZzn9i4rMJwfYIXeP:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),
(1562, 10, 'janire_615@hotmail.com', 1, NULL, 3, '2019-10-21 05:26:40', '2019-10-24 10:13:21', 1, 0, NULL, NULL, 'Janire', NULL, 'Amigo Landaluce', NULL, '0000-00-00', '9db26c3dfe8d72f77a2d7952d6bb61f1aeb99d415fb4a25cd744907395bfb6b3:52PJMysFxNjmRw4jQxJABS7olOyhYntO:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),
(1784, 10, 'albajon1112@hotmail.es', 1, NULL, 3, '2019-10-21 05:26:40', '2019-10-24 10:13:21', 1, 0, NULL, NULL, 'Alba', NULL, 'morillo romero', NULL, '0000-00-00', 'bc421ecaf6cb9c167b46d0425e63f34bfc2852a653ec63375fd62146dc9aefdf:QLuJeaOPUWuy1oMkETpBgSGIJVRdDepC:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),
(2111, 1, 'pipsarahjayne@yahoo.co.uk', 1, NULL, 1, '2019-10-21 05:26:40', '2019-11-15 07:09:12', 1, 0, NULL, NULL, 'sarah', NULL, 'parkhill', NULL, '0000-00-00', '044579bf6a6cea41d9a059caf08de62698363d5ea7841092e9f288f7b0c2c7b1:cgaHHhhrps5lQXGasXhljYUWmoNn28i4:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),
(2404, 1, 'sarahvictoriaswain@hotmail.co.uk', 1, NULL, 1, '2019-10-21 05:26:40', '2019-11-15 07:09:12', 1, 0, NULL, NULL, 'Sarah', NULL, 'Swain', NULL, '0000-00-00', '3469567ccc43b1816e98709fa9c7508f9650929874c0c8729dd37ca742d2e707:qzRqn7sgekA6ZU6cAHMdbNbSofbShJ6b:1', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL),

​

​

vivadogs.com.zip

View and download from Yandex.Disk

yadi.sk