Zynga
Sep 2019
Domain:
zynga.com
Breach Count:
172,869,660
Region:
Global
Source:
File Size:
23.34 GB
Uncompressed File Size:
87.33 GB
File Count:
1
In 2019, a massive data leak from Zynga exposed the personal information of 172,869,660 users. The leaked data included names, email addresses, birthdates, phone numbers, and Facebook IDs.
The leak was the result of a security breach on Zyngas servers, which allowed hackers to access the companys database. The data was then shared on a file-sharing website, where it was quickly downloaded by millions of people.
The Zynga leak was one of the largest data breaches in history, and it raised serious concerns about the security of online data. The leak also highlighted the importance of protecting personal information, and it led to increased calls for stronger data protection regulations.
Leaked Information:
Email
Password
Phone
User Name
We have loaded this breach into our database.
File List:
139.zynga.com.sql
File Content Sample:
CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`login_lower` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`name_lower` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`role` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone_number` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`salt` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`crypted_udid_password` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`crypted_custom_password` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`crypted_wf_password` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`password_reset_code` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token_expires_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`enabled` tinyint(1) DEFAULT '1',
`facebook_account_id` bigint(20) unsigned DEFAULT '0',
`zauth_account_id` bigint(20) unsigned DEFAULT '0',
`lock_version` int(11) unsigned DEFAULT '0',
`client_reset_at` datetime DEFAULT NULL,
`client_game_reset_at` datetime DEFAULT NULL,
`cs_notes` text COLLATE utf8mb4_unicode_ci,
`data` text COLLATE utf8mb4_unicode_ci,
`zynga_account_id` bigint(20) unsigned DEFAULT NULL,
`firebase_account_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_users_on_login_lower` (`login_lower`),
UNIQUE KEY `index_users_on_name_lower` (`name_lower`),
UNIQUE KEY `index_users_on_phone_number` (`phone_number`),
UNIQUE KEY `index_users_on_zynga_account_id` (`zynga_account_id`),
UNIQUE KEY `index_users_on_firebase_account_id` (`firebase_account_id`),
KEY `index_users_on_facebook_account_id` (`facebook_account_id`),
KEY `index_users_on_zauth_account_id` (`zauth_account_id`),
KEY `index_users_on_password_reset_code` (`password_reset_code`),
KEY `index_users_on_remember_token` (`remember_token`),
KEY `index_users_on_role` (`role`)
) ENGINE=InnoDB AUTO_INCREMENT=230674855 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'administrator','Administrator','administrator','administrator',NULL,NULL,'0362871472bbdf9f164962dcd1eca013929a82ce','8af211f26445c065aab7c7d7ff2fc16f600c8c7c',NULL,NULL,NULL,NULL,NULL,'2008-10-29 05:27:25','2015-08-27 16:57:39',1,0,0,41,NULL,NULL,NULL,'BAh7BzoSYWNjZXB0ZWRfZXVsYXsGbCsHfsXGU2wrBxwF4FM6GWZhY2Vib29rX2FjY291bnRfaWRzewhsKwiEO6CVI5lpAGwrCN32o6ESk2kAbCsIjICDwA1naQA=',33360928273,NULL),(2,'[email protected]','David Bettner','[email protected]','david bettner',NULL,NULL,'01039ebaf09cd361d457e418a3e3f752384e9386','62fa1d97238970b93e271f5dedba921c7858c099',NULL,NULL,'8aa009eeb87f0294bdc5204a04189b6efb6a5140',NULL,NULL,'2008-10-29 05:27:25','2017-02-25 21:01:37',1,9900809,0,3,NULL,'2014-08-05 18:25:57',NULL,'BAh7BzoSYWNjZXB0ZWRfZXVsYXsGbCsHfsXGU2wrBxwF4FNJIiNyZWNlaXZlZF9sYXBzZWRfcmV0dXJuZXJfZ3JhbnQGOgZFVHsGSSINV29yZEdhbWUGOwZUVA==',33360928272,NULL),(3,'[email protected]','Paul Bettner','[email protected]','paul bettner',NULL,NULL,'867573c9a2007308199bca07fc5a1e945500cba6','d90b7f7c44e5e99d4be2ef58952ff74800a21816',NULL,NULL,'dae2608377b6e7084b89af7aa2b490edcc1a8ed6',NULL,NULL,'2008-10-29 05:27:25','2017-05-03 18:58:37',1,0,0,3,NULL,NULL,NULL,'BAh7BzoSYWNjZXB0ZWRfZXVsYXsGbCsHfsXGU2wrBxwF4FNJIhpyZWNlaXZlZF9sYXBzZXJfZ3JhbnQGOgZFVHsGSSINV29yZEdhbWUGOwZUVA==',33360928271,NULL),(4,'[email protected]','Player 2','[email protected]','player 2',NULL,NULL,'278f13812ee3d536dd0abac10b307eb756833395','4ebb42fcc03fd4d0874f7f3b1b9321d63999452a',NULL,NULL,NULL,NULL,NULL,'2008-10-29 05:27:25','2019-08-17 09:55:00',1,0,0,258,NULL,NULL,'','8QAACyFNBAh7CEkiFWJsb2NrZWRfYnlfdXNlcnMGOgZFVFsBrGkEcqz0AmkEDzIGBmkEQeCpA2kEF+qzCWkEoJInVwD9er9XAEO4X1wCAe1bBApGBZqcBAoMAzBYVWkEj9EEBGkEhPzASwSaJihQAwaVXjoHaQQmmJpPAVp0cVcAxk5mVwCbfo5XALKV4EcFUDhFVwDns+tHAofhXFsOVLPDTwFg8p9XAGgGSEQCBmsVLwtpBOKZOU8B/3rpYhGrSVQDBqFADQVpBKiAPVcDaEeqRwJqlfVXA4MHl0cFuKRRXwLXnMRHAhQmo1cDck/+fg4IXF4C2h5sCgaU5lwIaQTL/8ZfA
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`login_lower` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`name_lower` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`role` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`phone_number` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`salt` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`crypted_udid_password` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`crypted_custom_password` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`crypted_wf_password` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`password_reset_code` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token_expires_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`enabled` tinyint(1) DEFAULT '1',
`facebook_account_id` bigint(20) unsigned DEFAULT '0',
`zauth_account_id` bigint(20) unsigned DEFAULT '0',
`lock_version` int(11) unsigned DEFAULT '0',
`client_reset_at` datetime DEFAULT NULL,
`client_game_reset_at` datetime DEFAULT NULL,
`cs_notes` text COLLATE utf8mb4_unicode_ci,
`data` text COLLATE utf8mb4_unicode_ci,
`zynga_account_id` bigint(20) unsigned DEFAULT NULL,
`firebase_account_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_users_on_login_lower` (`login_lower`),
UNIQUE KEY `index_users_on_name_lower` (`name_lower`),
UNIQUE KEY `index_users_on_phone_number` (`phone_number`),
UNIQUE KEY `index_users_on_zynga_account_id` (`zynga_account_id`),
UNIQUE KEY `index_users_on_firebase_account_id` (`firebase_account_id`),
KEY `index_users_on_facebook_account_id` (`facebook_account_id`),
KEY `index_users_on_zauth_account_id` (`zauth_account_id`),
KEY `index_users_on_password_reset_code` (`password_reset_code`),
KEY `index_users_on_remember_token` (`remember_token`),
KEY `index_users_on_role` (`role`)
) ENGINE=InnoDB AUTO_INCREMENT=230674855 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'administrator','Administrator','administrator','administrator',NULL,NULL,'0362871472bbdf9f164962dcd1eca013929a82ce','8af211f26445c065aab7c7d7ff2fc16f600c8c7c',NULL,NULL,NULL,NULL,NULL,'2008-10-29 05:27:25','2015-08-27 16:57:39',1,0,0,41,NULL,NULL,NULL,'BAh7BzoSYWNjZXB0ZWRfZXVsYXsGbCsHfsXGU2wrBxwF4FM6GWZhY2Vib29rX2FjY291bnRfaWRzewhsKwiEO6CVI5lpAGwrCN32o6ESk2kAbCsIjICDwA1naQA=',33360928273,NULL),(2,'[email protected]','David Bettner','[email protected]','david bettner',NULL,NULL,'01039ebaf09cd361d457e418a3e3f752384e9386','62fa1d97238970b93e271f5dedba921c7858c099',NULL,NULL,'8aa009eeb87f0294bdc5204a04189b6efb6a5140',NULL,NULL,'2008-10-29 05:27:25','2017-02-25 21:01:37',1,9900809,0,3,NULL,'2014-08-05 18:25:57',NULL,'BAh7BzoSYWNjZXB0ZWRfZXVsYXsGbCsHfsXGU2wrBxwF4FNJIiNyZWNlaXZlZF9sYXBzZWRfcmV0dXJuZXJfZ3JhbnQGOgZFVHsGSSINV29yZEdhbWUGOwZUVA==',33360928272,NULL),(3,'[email protected]','Paul Bettner','[email protected]','paul bettner',NULL,NULL,'867573c9a2007308199bca07fc5a1e945500cba6','d90b7f7c44e5e99d4be2ef58952ff74800a21816',NULL,NULL,'dae2608377b6e7084b89af7aa2b490edcc1a8ed6',NULL,NULL,'2008-10-29 05:27:25','2017-05-03 18:58:37',1,0,0,3,NULL,NULL,NULL,'BAh7BzoSYWNjZXB0ZWRfZXVsYXsGbCsHfsXGU2wrBxwF4FNJIhpyZWNlaXZlZF9sYXBzZXJfZ3JhbnQGOgZFVHsGSSINV29yZEdhbWUGOwZUVA==',33360928271,NULL),(4,'[email protected]','Player 2','[email protected]','player 2',NULL,NULL,'278f13812ee3d536dd0abac10b307eb756833395','4ebb42fcc03fd4d0874f7f3b1b9321d63999452a',NULL,NULL,NULL,NULL,NULL,'2008-10-29 05:27:25','2019-08-17 09:55:00',1,0,0,258,NULL,NULL,'','8QAACyFNBAh7CEkiFWJsb2NrZWRfYnlfdXNlcnMGOgZFVFsBrGkEcqz0AmkEDzIGBmkEQeCpA2kEF+qzCWkEoJInVwD9er9XAEO4X1wCAe1bBApGBZqcBAoMAzBYVWkEj9EEBGkEhPzASwSaJihQAwaVXjoHaQQmmJpPAVp0cVcAxk5mVwCbfo5XALKV4EcFUDhFVwDns+tHAofhXFsOVLPDTwFg8p9XAGgGSEQCBmsVLwtpBOKZOU8B/3rpYhGrSVQDBqFADQVpBKiAPVcDaEeqRwJqlfVXA4MHl0cFuKRRXwLXnMRHAhQmo1cDck/+fg4IXF4C2h5sCgaU5lwIaQTL/8ZfA