- Joined
- Jun 14, 2024
- Messages
- 2,601
- Reaction score
- 24,213
- Points
- 113
- Thread Author
- #1
foodora.com .sql database
foodora.com sql databaseIn April 2016, the online food delivery service Foodora suffered a data breach which was then extensively redistributed online. The breach included the personal information of hundreds of thousands of customers from multiple countries including their names, delivery addresses, phone numbers and passwords stored as either a salted MD5 or a bcrypt hash.
Compromised data: Email addresses, Names, Passwords, Phone numbers, Physical addresses
sample:
Code:
INSERT INTO `Customers` ( `id` , `code` , `language_id` , `email` , `password` , `salt` , `crypt_algorithm` , `firstname` , `lastname` , `mobile` , `mobile_country_code` , `mobile_confirmation_code` , `mobile_verified` , `mobile_verified_attempts` , `landline` , `landline_verified` , `lastlogin` , `reference_code` , `internal_comment` , `deleted` , `_oldsystem_id` , `created_at` , `updated_at` , `created_by` , `updated_by` , `source` , `user_agent` , `loyaltyprogramname_id` , `card_id` , `company_id` , `guest` , `profile_picture_link` ) VALUES ( 102 , 'v5hck1tt' , 1 , 'restaurant-admin@ .de' , '$2y$11$w4aNZDXenqr5lDTI8K7J2.5Yler.dY0DfTGKptR2yNebH6A/6FPSu' , NULL , 'bcrypt' , 'Restaurant' , 'Admin' , '693550211' , '+34' , '5269' , 1 , 0 , NULL , NULL , '2015-06-12 16:06:52' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:52' , '2016-04-19 08:03:38' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1508 , 'd0wlg9cz' , 1 , 'jonas@ .de' , 'a7fb821162d72ec37c86c77d0eef3b0dadcc12a7b13c18e89dfb77cffce18436103d0c562fda359c5cbdbef7d5e4f512d03329eb24f38a19d31b67380b230b40' , '1QySzUswn-KxydvznczR' , 'sha512_volo' , 'Jonas' , 'Weidtke' , NULL , NULL , '3271' , 0 , 0 , NULL , NULL , '2015-06-12 16:06:53' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:53' , '2016-04-19 08:03:43' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1629 , 'e2bla3jc' , 1 , ' [email protected] ' , '$2y$11$dlsO/VoUe4OHN.iAXOQfoOkpOXYFETUl2e43xJnnZh.BbT43LXRsW' , NULL , 'bcrypt' , 'Chloe' , 'Roukbi' , NULL , NULL , '8548' , 0 , 0 , NULL , NULL , '2015-06-12 16:06:54' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:54' , '2016-04-19 08:03:43' , 1 , 312 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1689 , 'p9qwf0dc' , 1 , ' [email protected] ' , '68e57e47fe945d3717b9bac505215ef6a9bc7051229b860eae61ca2b7e1c3e8ee4e00ca6c7b6f5e1c932b78ae848b8747d50203ab61a99c1c5bb3f41f82fe9e5' , 'qsbUS_b5gmuHGq5r-Yfs' , 'sha512_volo' , 'MARIE CAMILLE' , 'ECK' , '620958549' , '+33' , '4932' , 1 , 0 , NULL , NULL , '2015-06-12 16:06:54' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:54' , '2016-04-19 08:03:38' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1694 , 'u2mtt2ce' , 1 , ' [email protected] ' , '$2y$11$h5Rmv.IXN5Mro2qsJ3KqoeuxNeJRP5j9z6CqFS1Gf1Yn.XdGQz5/W' , NULL , 'bcrypt' , 'Emmanuel' , 'Naar' , NULL , NULL , '7015' , 0 , 0 , NULL , NULL , '2015-06-12 16:06:55' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:55' , '2016-04-19 08:03:43' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1704 , 'y1hpm7ei' , 1 , 'boris.mittermueller@ .de' , '8c789bec35bfa9ef18610f1b598a109113e1eea14474091c10782f5ba77d88ef0e0bbb2f3d4135a08bcb57e0384c03ce001a80fb01a93d5bef64f54ec7ae92af' , 'hdSPUy_bqxTZNVbcDQaV' , 'sha512_volo' , 'Boris' , 'Mittermueller' , '1753187192' , '+49' , '1282' , 1 , 0 , NULL , NULL , '2015-06-12 16:06:56' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:56' , '2016-04-19 08:03:38' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1733 , 'a9gdq0yu' , 1 , ' [email protected] ' , '$2y$11$BL3rxUe03Zfzbk625RspRe5Q7A6XEshKIGjEAshn3nwnkp1PO.YjW' , NULL , 'bcrypt' , 'Briera' , 'Dale' , '619403983' , '+33' , '4063' , 0 , 0 , NULL , NULL , '2015-06-12 16:06:56' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:56' , '2016-04-21 13:15:35' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1760 , 'g8xup6wm' , 1 , ' [email protected] ' , '0e662fdd7007fc85b7c0ea51fa0e6ee0399788cf554400cb2caf105797e656d716b3e0b6ba386d719b2d6c22b9c32f01e85eb1bce3f9f3d10a976f4ae0ef0ed3' , 'V2eUxsB25Ry7nAHy5_Qn' , 'sha512_volo' , 'Mehdi' , 'Ben Abroug' , NULL , NULL , '6965' , 0 , 0 , NULL , NULL , '2015-06-12 16:06:56' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:56' , '2016-04-19 08:03:43' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1772 , 'i4spb4vn' , 1 , 'chloe.roukbi@ .escpeurope.eu' , '3176bd37cfc5d26958ce7f01c90bf8e55609303e980ec90128d7af5e4a2d5d88bff8a030cc9f3816382361377d9ef74bd60d796e6ce0da0ba2e0add512c5776b' , 'F1Mxx1Ho8sTNQoKwpufw' , 'sha512_volo' , 'Chloe' , 'Roukbi' , NULL , NULL , '8744' , 0 , 0 , NULL , NULL , '2015-06-12 16:06:57' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:57' , '2016-04-19 08:03:43' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1775 , 't8pmx7cd' , 1 , ' [email protected] ' , '$2y$11$btlGvX4UKD2vrNKkYEoUTO0zn1IeKaj5W3pG6RiDFvmH.WfGlXd22' , NULL , 'bcrypt' , 'Arthur' , 'Porré' , '663248489' , '+33' , '3824' , 1 , 0 , NULL , NULL , '2015-06-12 16:06:57' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:57' , '2016-04-19 08:03:38' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1784 , 'k9llu1bl' , 1 , ' [email protected] ' , 'd7f9de74706b215c96d7e369b68f0d3c842ee72cacdb0924ebb7d585394ea2d410f990950f9f599b92ef522a3fb1758eee65eb74355e3861b34669176cde1ef6' , 'xxRCJFvxTAw2hcVz67nF' , 'sha512_volo' , 'Rebecca' , 'Peterson' , '623141254' , '+33' , '9887' , 1 , 0 , NULL , NULL , '2015-06-12 16:06:58' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:58' , '2016-04-19 08:03:38' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ), ( 1789 , 'v3xjs1bh' , 1 , ' [email protected] ' , '6d018400a286d1493c52e960da346adcd3c2403da57e6f2c147c02e44089342d2f6a0b408b8c57cbbe513fa6c4d749a1d8b0a01a769e81ca1cb9c4efeb3afbb7' , '5ErLNwvB3i2yYBq_Rjxx' , 'sha512_volo' , 'lorris' , 'miglioretti' , '682580568' , '+33' , '9966' , 1 , 0 , NULL , NULL , '2015-06-12 16:06:59' , NULL , NULL , 0 , NULL , '2015-06-12 16:06:59' , '2016-04-19 08:03:38' , 1 , 1 , 'b2c' , NULL , NULL , NULL , NULL , 0 , NULL ),