Brazilian Concert Website Sem Hora (semhora.com.br) - 206k
In August 2016, the Brazilian concert website Sem Hora suffered a data breach that impacted 206k members. The breach led to the exposure of data including Full names, Email addresses, Dates of birth, Genders and Orders. Sem Hora is now defunct.
sample:
Compromised data: Full names, Email addresses, Dates of birth, Genders, Orders
sample:
CREATE TABLE `user` (
`id` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`emailVerified` tinyint(1) DEFAULT '0',
`name` varchar(255) DEFAULT NULL,
`birthdate` date DEFAULT NULL,
`birthday` date DEFAULT NULL,
`additional` text,
`gender` varchar(255) DEFAULT NULL,
`number` varchar(255) DEFAULT NULL,
`street` varchar(255) DEFAULT NULL,
`zip_code` varchar(255) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL,
`facebook` varchar(255) DEFAULT NULL,
`qrcode` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`comprouDebito` tinyint(1) DEFAULT '0',
`comprouDeposito` tinyint(1) DEFAULT '0',
`status` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`ultima_interacao` datetime DEFAULT NULL,
`EmailAgeScore` varchar(255) DEFAULT NULL,
`objectIdEmailAge` varchar(255) DEFAULT NULL,
`LogAlertaFraudeEmailAge` varchar(255) DEFAULT NULL,
`createdAt` datetime DEFAULT NULL,
`updatedAt` datetime DEFAULT NULL,
UNIQUE KEY `id` (`id`),
KEY `id_2` (`id`),
KEY `gender` (`gender`),
KEY `state` (`state`),
KEY `city` (`city`),
KEY `status` (`status`),
KEY `createdAt` (`createdAt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES ('WfptItZQtj','cesarspalma@hotmail.com','cesarspalma@hotmail.com',1,'cesar da Silva palma','0000-00-00','1978-08-21','','masculino','','','','','','73D75CAD1BE3D669FFE7B804EBDFBC79','','',0,0,'web','(11) 98202-4896','2015-10-23 12:17:23','','',NULL,'2014-09-09 12:33:15','2015-05-26 13:26:18'),('G5nC1HqI4I','vansc1234','vanessasantana.fisio@hotmail.com',1,'vanessa santana carneiro','0000-00-00','1988-05-17','','feminino','','','','','','677483FC4C2A6DD07F95899968013B02','','',0,0,'web','(71) 91444-275','2015-10-23 12:17:22','','',NULL,'2014-09-09 13:32:45','2015-05-26 13:26:19'),('8FD2x3APFh','vicfaria','victoriaa_faria@hotmail.com',1,'Vict?ria Anselmo Pinheiro de Faria','0000-00-00','1993-01-28','','feminino','','','','','','A0EA1F8BDB1ACD8E5F1AF87E125E0B0B',''
Compromised data: Full names, Email addresses, Dates of birth, Genders, Orders