Sem Hora Database

Aug 2016

Domain:

semhora.com.br

Breach Count:

223,128

Region:

Global

News Report:

-

Leak from:

File Size:

170.79 MB

Uncompressed File Size:

1.32 GB

File Count:

1

The Sem Hora Database leak occurred in 2016 in Brazil (BR), with 206,142 records exposed. The leaked data included real names, emails, usernames, phone numbers, addresses, genders, and dates of birth.

Leaked Information:

Full Name

User Name

Phone

Address

Gender

Date Of Birth

We have loaded this breach into our database.

File List:

sem_hora.sql

File Content 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','[email protected]','[email protected]',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','[email protected]',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','[email protected]',1,'Vict?ria Anselmo Pinheiro de Faria','0000-00-00','1993-01-28','','feminino','','','','','','A0EA1F8BDB1ACD8E5F1AF87E125E0B0B',''