![[Image: gaadi.png]](https://cdn.breachforums.st/logo/gaadi.png "[Image: gaadi.png]"){kind=logo}
In May 2015, the Indian motoring website known as Gaadi had 4.3 million records exposed in a data breach. The data contained usernames, email and IP addresses, genders, the city of users as well as passwords stored in both plain text and as MD5 hashes.
Compromised data: Email addresses, Genders, Geographic locations, IP addresses, Names, Passwords, Phone numbers, Usernames
Sample:
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`user_id` int(200) NOT NULL,
`username` varchar(200) NOT NULL,
`password` varchar(200) NOT NULL,
`username_md5` varchar(200) NOT NULL,
`password_md5` varchar(200) NOT NULL,
`fname` varchar(200) NOT NULL,
`lname` varchar(200) NOT NULL,
`email` varchar(200) NOT NULL,
`gender` varchar(200) NOT NULL,
`std` varchar(200) NOT NULL,
`city` varchar(200) NOT NULL,
`phone` varchar(200) NOT NULL,
`ip` varchar(200) NOT NULL,
`mobile` varchar(200) NOT NULL,
`img` varchar(200) NOT NULL,
`state` varchar(200) NOT NULL,
`address` varchar(200) NOT NULL,
`img_ch` varchar(200) NOT NULL,
`about` varchar(200) NOT NULL,
`c_id` varchar(200) NOT NULL,
`vote` varchar(200) NOT NULL,
`flag` varchar(200) NOT NULL,
`frequency` varchar(200) NOT NULL,
`unsubscribe` varchar(200) NOT NULL,
`flag_newsletter` varchar(200) NOT NULL,
`zip` varchar(200) NOT NULL,
`datetime` varchar(200) NOT NULL,
`last_activity_mail` varchar(200) NOT NULL,
`is_dealer` varchar(200) NOT NULL,
`last_email_on` varchar(200) NOT NULL,
`email_count` varchar(200) NOT NULL,
`avatar` varchar(200) NOT NULL,
`total_post` varchar(200) NOT NULL,
`is_valid_mobile` varchar(200) NOT NULL,
`is_valid_mobile_sms` varchar(200) NOT NULL,
`is_valid_email` varchar(200) NOT NULL,
`potential_unsubscribe_flag` varchar(200) NOT NULL,
`alert_unsubscribe_flag` varchar(200) NOT NULL,
`original_email` varchar(200) NOT NULL,
`is_bounced` varchar(200) NOT NULL,
`plist_flag` varchar(200) NOT NULL,
`maruti_tco` varchar(200) NOT NULL,
`temp_flag` varchar(200) NOT NULL,
`email_val_status` varchar(200) NOT NULL,
`is_used_in_glist` varchar(200) NOT NULL,
PRIMARY KEY (`user_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!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 (2,'aa@gmail.com','12345','3979576bcdcbd166d005a5b225e1bc52','827ccb0eea8a706c4c34a16891f84e7b','aa','aa','aa@gmail.com','','','New Delhi','','203.124.18.123','1234567899','','','Factory Area Faridabad','0','','2','0','1','2','1','Gaadi.com Newsletter October 2008','121001','0000-00-00 00:00:00','2011-07-20','0','0000-00-00','0','Male/a4.jpg','0','0','1','1','0','0','','1','1','1','0','invalid','1'),(17,'vivek','oldpassword','061a01a98f80f415b1431236b62bb10b','d5b5fffc89f961903fb3c9a173f1b667','vivek','pahwa','vivekpahwa@gmail.com','Male','','New Delhi','','203.124.18.124','9811500700','','','Civil Lines','0','','17','155','1','52','0','Gaadi.com Newsletter October 2008','110085','0000-00-00 00:00:00','2013-01-11','0','0000-00-00','0','Male/a10.jpg','39','1','1','1','0','0','','0','0','0','1','','1'),(21,'rameshwar','rameshwar','c146615846136af296c7a59aa8bfc161','c146615846136af296c7a59aa8bfc161','Rameshwar','gupta','rameshwargupta11@gmail.com','','','New Delhi','','203.124.18.123','9810694444','','','Civil Lines','0','hi','21','3','1','52','0','Gaadi.com Newsletter October 2008','110054','0000-00-00 00:00:00','2013-01-11','0','0000-00-00','0','car_avatars/image15.jpg','1','1','0','1','1','0','','0','1','1','1','','1'),(25,'sanjay1','12345','c7310a5f00473dd54829263891eadfae','827ccb0eea8a706c4c34a16891f84e7b','sanjay','sanjay','sanjay@yahoo.com','','','Adilabad','','203.124.18.123','9988776655','','','','0','','25','0','1','3','1','Gaadi.com Newsletter October 2008','0','0000-00-00 00:00:00','2008-12-24','0','0000-00-00','0','bike_avatars/image1.jpg','0','1','1','1','0','0','','0','0','1','0','invalid','1'),(41,'sanjaya','12345','d9dba78b00e9b6a5bd72d66b9321b63f','827ccb0eea8a706c4c34a16891f84e7b','sanjay','sanjay','sss@sasa.com','Male','','Chandigarh','','203.124.18.123','9811818211','','','','0','','41','0','1','5','0','Gaadi.com Newsletter October 2008','0','0000-00-00 00:00:00','2008-12-24','0','0000-00-00','0','Male/a13.jpg','0','1','1','1','0','0','','0','0','0','0','','1'),(65,'warikoos','ttiotwan','e4689182b1703bfbbcca285c348c0adb','84388c989b1100182f46c3c2ccbcc725','Ankur','Warikoo','warikoo@gmail.com','Male','','Faridabad','','221.134.25.196','9999768702','','','Amarnagar Faridabad','0','','65','136','1','52','0','Gaadi.com Newsletter October 2008','121003','0000-00-00 00:00:00','2013-01-11','0','0000-00-00','0','Male/a3.jpg','37','1','1','1','0','0','','0','0','0','1','','1'),(78,'rajusuresh','raju999','f9b58c7f0df86618c29d3803622ebeb2','aee6893fb10d3bdb6d26af0c1b112eb5','Suresh','Kanumuri','rajusuresh@yahoo.com','Male','','Hyderabad','','76.226.111.192','9999999999','','','','0','','78','94','1','52','0','Gaadi.com Newsletter October 2008','0','0000-00-00 00:00:00','2013-01-11','0','0000-00-00','0','bike_avatars/image18.jpg','21','0','1','1','0','0','','0','0','0','1','','1'),(87,'kumar257','86001','aa0c2848e23ecf5ae46d82440093fe6e','dc6de40a3234b6d2d73e97e359d3b2fe','kumar','','fmcdelhi92@indiatimes.com','','','New Delhi','','59.161.136.242','9310003707','','','Anand Vihar','0','','87','0','1','8','0','none','110092','0000-00-00 00:00:00','2008-12-24','0','0000-00-00','0','bike_avatars/image16.jpg','0','1','0','1','0','0','','0','0','0','1','','1'),(102,'testing','testing','ae2b1fca515949e5d54fb22b8ed95575','ae2b1fca515949e5d54fb22b8ed95575','test','test','ttest@g.com','Male','','New Delhi','','122.163.253.129','9811500700','','','','0','','102','6','1','2','0','Gaadi.com Newsletter October 2008','0','0000-00-00 00:00:00','2013-01-11','0','0000-00-00','0','bike_avatars/image13.jpg','2','1','1','1','0','0','','1','1','0','0','','1'),(109,'rameshwar1','12345','4d3c3fbb8ada21076bc3b02852b942d3','827ccb0eea8a706c4c34a16891f84e7b','Rameshwar','','hibipinengineer@gmail.com','','','','','220.224.79.9','','','','','0','','109','0','1','52','0','Gaadi.com Newsletter October 2008','0','0000-00-00 00:00:00','2008-12-24','0