- Joined
- Jun 14, 2024
- Messages
- 2,601
- Reaction score
- 24,216
- 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 , ' chloe.roukbi@gmail.com ' , '$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 , ' mariecamilleeck@hotmail.com ' , '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 , ' emmanuel.naar@gmail.com ' , '$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 , ' brieradale@gmail.com ' , '$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 , ' mehdi.benabroug@kaymu.com ' , '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 , ' art.porre@gmail.com ' , '$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 , ' rebecca.13.peterson@gmail.com ' , '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 , ' lorris.miglioretti@gmail.com ' , '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 ),