Wattpad
wattpad.com
268,765,495
Global
23.51 GB
118.07 GB
1
In September 2020, the popular online writing platform Wattpad experienced a massive data breach, resulting in the exposure of nearly 270 million user records. The compromised data included sensitive information such as email addresses, usernames, and even hashed passwords, making it one of the largest data breaches in recent history.
The breach was particularly concerning due to the sheer number of affected users and the potential for malicious actors to exploit the exposed information. Email addresses, for instance, could be used for phishing attacks or spam, while hashed passwords could be cracked using brute-force techniques to gain access to accounts. The breach prompted Wattpad to take swift action, including resetting passwords for affected users and implementing additional security measures to prevent future incidents.
We have loaded this breach into our database.
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(80) NOT NULL DEFAULT '',
`PASSWORD` varchar(80) NOT NULL DEFAULT '',
`EMAIL` varchar(128) NOT NULL DEFAULT '',
`CREATEDATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`MODIFYDATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`LOGINIP` varchar(45) DEFAULT NULL,
`LOGINDATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`LASTEMAILNAG` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`ACTIVE` tinyint(1) NOT NULL DEFAULT '1',
`VERIFIED` tinyint(1) NOT NULL DEFAULT '0',
`REALNAME` varchar(240) CHARACTER SET utf8mb4 DEFAULT NULL,
`LOCATION` varchar(240) CHARACTER SET utf8mb4 DEFAULT NULL,
`COUNTRY` varchar(2) DEFAULT NULL,
`WEBSITE` varchar(240) DEFAULT NULL,
`IM` varchar(240) DEFAULT NULL,
`PHONE` varchar(40) DEFAULT NULL,
`SUBSCRIBE` tinyint(1) NOT NULL DEFAULT '1',
`ABOUT` text CHARACTER SET utf8mb4,
`ALERTS` tinyint(1) NOT NULL DEFAULT '1',
`ISAUTHOR` tinyint(1) NOT NULL DEFAULT '0',
`WARNCOUNT` tinyint(1) NOT NULL DEFAULT '0',
`ALERTSSUB` tinyint(1) unsigned NOT NULL DEFAULT '1',
`DOB` date NOT NULL DEFAULT '0000-00-00',
`GENDER` varchar(1) DEFAULT NULL,
`LANGUAGE` tinyint(1) unsigned DEFAULT NULL,
`FBID` bigint(20) unsigned DEFAULT NULL,
`MYSPACE` varchar(45) DEFAULT NULL,
`SHOWAGE` tinyint(1) unsigned NOT NULL DEFAULT '0',
`SHOWNAME` tinyint(1) unsigned NOT NULL DEFAULT '1',
`ISMODERATOR` tinyint(1) unsigned NOT NULL DEFAULT '0',
`LULU` varchar(45) DEFAULT NULL,
`TWITTERID` varchar(45) DEFAULT NULL,
`TWITTERTOKEN` text,
`SMASHWORDS` varchar(45) DEFAULT NULL,
`BUBOK` varchar(45) DEFAULT NULL,
`TUMBLREMAIL` varchar(45) DEFAULT NULL,
`TUMBLRPASSWORD` varchar(45) DEFAULT NULL,
`TUMBLRURL` varchar(45) DEFAULT NULL,
`STATUS` varchar(600) DEFAULT NULL,
`STATUSLASTUPDATED` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`AVATAR_TIMESTAMP` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`BACKGROUND_TIMESTAMP` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`NOTES` text,
`LAST_FB_NOTIFICATION` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`APPEAR_OFFLINE` tinyint(1) unsigned NOT NULL DEFAULT '0',
`EMAILBOUNCEDATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`REVISION` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `Index_3` (`NAME`),
KEY `INDEX_FBID` (`FBID`),
KEY `INDEX_TWITTERID` (`TWITTERID`),
KEY `INDEX_EMAIL` (`EMAIL`),
KEY `for_active_lookup` (`ID`,`ACTIVE`)
) ENGINE=InnoDB AUTO_INCREMENT=258383564 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!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 (0,'-placeholder-','','[email protected]','2006-09-28 07:45:36','2006-09-28 07:45:36','','2011-06-28 19:37:52','0000-00-00 00:00:00',0,1,'','','US','',NULL,NULL,1,'',0,0,0,0,'1954-04-12','',1,NULL,'',0,0,0,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),(1,'mtextbox','9d1f018ecdcb38a6aaf93c92c6d6f7033af817ae8152ae5cc9e6e803defab50c','[email protected]','2006-09-28 06:45:36','2020-05-01 14:29:15','99.255.220.73','2012-01-09 14:39:40','0000-00-00 00:00:00',1,1,'sdsds','','ES','','',NULL,0,'',0,0,7,0,'1992-01-01','F',1,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','2020-03-27 23:06:53','2020-03-25 20:53:03','Account Closed - banned_explicit','0000-00-00 00:00:00',0,'2019-10-26 22:32:02',78),(2,'ivanyuen','$2y$10$ngltmcu/sjOYAyi/1zKe4.8rob04dqG90cFAeIVvUneV9/ul/EwLO','[email protected]','2006-11-08 23:48:49','2017-03-01 19:09:40','24.114.57.156','2017-03-01 19:09:40','2013-09-03 07:00:00',1,1,'Ivan Yuen','Toronto, Ontario','CA','https://www.flickr.com/photos/iyuen/sets/','',NULL,1,'Welcome! My name is Ivan and I\'m one of the creators of Wattpad. Take a look around, I hope you find something you like!
I enjoy mystery and science fiction stories. I also like #travel stories. I am always looking for something good to read. I also occasionally write. I hope you check out my stories and tell me if you enjoy reading it.',1,0,1,254,'1977-01-07','M',1,590575780,'',1,1,0,'',NULL,'a:5:{s:11:\"oauth_token\";s:48:\"9924182-ty1hnUssHi1JLEHk3ksIumn51FujIsbC8WacUTSo\";s:18:\"oauth_token_secret\";s:41:\"gCqpUWRqGfYnNYgD6LKZEYCUFUTQODVXr2iV1J5Ds\";s:7:\"user_id\";s:7:\"9924182\";s:11:\"screen_name\";s:8:\"ivanyuen\";s:14:\"x_auth_expires\";s:1:\"0\";}','','',NULL,NULL,NULL,'','2014-07-14 20:49:01','2019-12-10 01:03:36','2015-05-13 01:33:46','','2013-07-08 07:00:00',0,'0000-00-00 00:00:00',134),(3,'_minicooper','fcab5db5ffb5af951498615837ddc17ecdbaee5ab3d103c443c0c6dda8588693','[email protected]','2006-11-08 23:49:54','2013-10-23 19:49:50','99.225.98.173','2012-07-26 01:56:34','2012-09-17 07:00:00',0,1,'Mini Cooper','Toronto','CA','','',NULL,0,'Interested in business and economic issues.',0,0,3,1,'0000-00-00','',NULL,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','2012-01-10 21:14:47','2012-01-10 21:14:16','0000-00-00 00:00:00','Account Closed - Copyright Infringement','0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),(4,'arumugam_t','954e43381b3182a58776b5184ba1d94e000acde167b6cfde05fdbde81c8831fb','[email protected]','2006-11-09 00:29:47','2012-11-15 22:26:31','209.15.25.82','2016-04-04 20:39:55','0000-00-00 00:00:00',1,0,NULL,NULL,'CA',NULL,NULL,NULL,0,NULL,1,0,0,252,'0000-00-00','',NULL,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00',0,'2020-03-24 08:32:16',0),(6,'_indra01','98a0a00449dc777352b8a7d77d674bbd5a46fca7157be3a783ee27a67b98ea02','[email protected]','2006-11-09 00:49:40','2016-02-25 23:42:06','64.233.166.136','2007-01-10 03:35:16','0000-00-00 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,0,0,1,'0000-00-00','',NULL,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','Account Closed - Spam','0000-00-00 00:00:00',0,'1990-01-01 00:00:00',1),(7,'Danboiciuc','$2y$10$R.TuGjRHNrWOpP7Oo59SJ.UJpWXW4oD01Zx86VJSM1zxw9UfV8G02','[email protected]','2006-11-09 00:50:59','2019-08-24 21:08:35','65.255.37.199','2019-08-24 21:08:35','0000-00-00 00:00:00',1,1,'','','RO','','',NULL,0,NULL,0,0,0,0,'0000-00-00','',15,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0),(8,'saju_D','cb0e15645306913c9092b696d328c3a917d65ec9543d445ed0739dfda161d77b','[email protected]','2006-11-09 00:53:26','2006-11-09 00:53:26',NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,NULL,NULL,'ID',NULL,NULL,NULL,1,NULL,1,0,0,252,'0000-00-00','',NULL,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00',0,'1990-01-01 00:00:00',0),(9,'evolving_dar','bb02ab79b697310918a262db8638cf02c12a6e9bd66d1b26bff06c29126c53f0','[email protected]','2006-11-09 02:29:03','2006-11-09 02:29:03','210.213.225.232','2006-11-09 02:31:43','0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,0,0,252,'0000-00-00','',NULL,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','2020-03-25 17:42:10','0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00',0,'2015-02-06 08:00:33',1),(10,'lax1970','fe4a1e927bbf9e3da4dc2ecfbfe27f8df0601ee6e2f1b8bd77d99ec4e039670d','[email protected]','2006-11-09 02:32:46','2006-11-09 02:32:46','203.145.134.195','2006-11-09 02:39:11','0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,0,0,1,'0000-00-00','',NULL,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','2019-05-23 15:02:27',NULL,'0000-00-00 00:00:00',0,'1990-01-01 00:00:00',0),(11,'coolgunz','7149169c331d62964e586c201c568e9dc0fde23db94977ac36fc19dce2756e02','[email protected]','2006-11-09 02:36:54','2006-11-09 02:36:54','210.166.41.14','2006-11-09 02:37:32','0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,0,0,1,'0000-00-00','',NULL,NULL,'',1,0,0,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00',0,'1990-01-01 00:00:00',0),(12,'Dromadero','e2ad2edecd9427e9d7bc6560fca1a72bf37bec653af6c9cc7f3368493ba1fe14','[email protected]','2006-11-09 02:37:37','2006-11-09 02:37:37','86.122.211.114','2006-12-21 06:44:54','0000-00-00 00:00:00',1,0,'','',NULL,'','',NULL,1,NULL,1,0,0,1,'0000-00-