/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE TABLE IF NOT EXISTS `derramamento` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT NULL,
  `diretos` int(11) NOT NULL DEFAULT 0,
  `status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*!40000 ALTER TABLE `derramamento` DISABLE KEYS */;
INSERT INTO `derramamento` (`id`, `login`, `diretos`, `status`) VALUES
	(1, 'cosmo9able', 1, 'saiu'),
	(2, '123', 0, NULL),
	(3, '123sdfsd', 0, NULL),
	(4, 'fsdfsdfsdfsdfsd', 0, NULL),
	(7, 'cosmo123', 2, NULL),
	(8, 'maria', 0, NULL);
/*!40000 ALTER TABLE `derramamento` ENABLE KEYS */;

CREATE TABLE IF NOT EXISTS `rede` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT NULL,
  `esquerda` varchar(50) DEFAULT NULL,
  `direita` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*!40000 ALTER TABLE `rede` DISABLE KEYS */;
INSERT INTO `rede` (`id`, `login`, `esquerda`, `direita`) VALUES
	(1, 'cosmo9able', '123', '123'),
	(4, '123', 'cosmo9able', '123'),
	(7, 'cosmo123', 'maria', '123'),
	(8, 'maria', '123', 'kervin');
/*!40000 ALTER TABLE `rede` ENABLE KEYS */;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `last_name` varchar(90) NOT NULL,
  `login` varchar(50) NOT NULL,
  `email` varchar(120) NOT NULL,
  `password` char(128) NOT NULL,
  `indicador` varchar(50) DEFAULT NULL,
  `balance` decimal(35,8) DEFAULT 0.00000000,
  `pontos_d` int(11) DEFAULT 0,
  `pontos_e` int(11) DEFAULT 0,
  `2fa` int(11) DEFAULT NULL,
  `secret` char(128) DEFAULT NULL,
  `data` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `name`, `last_name`, `login`, `email`, `password`, `indicador`, `balance`, `pontos_d`, `pontos_e`, `2fa`, `secret`, `data`) VALUES
	(1, 'Cosmo André', 'Silva Moraes', 'cosmo9able', 'cosmo@mail.com', '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2', NULL, 0.00000000, 0, 0, 1, 'a7ef77ba16f603c4c2f2fadf7b3567a1ec4121a7aeb8fd8840e66e570032501120d70e6aaf80dfa71ecb0cb2f70e66c05d56ad958144b716555de2a546e0501b', '2017-07-26 20:08:21'),
	(7, 'Teste', 'Sil.va', '123', 'casdaksmlkda', '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2', NULL, 0.00000000, 0, 0, NULL, NULL, '2017-07-28 14:34:14'),
	(11, 'Cosmo', 'André', 'cosmo123', 'cosmo_moraes@hotmail.com', '2889995164920eeb4717891c42fb9a86cc612327d8b703afc772ff22b5aba7bdc4ecf2f2930265749d6a73e55fc4f1d6852f663e07c30309b20d0e53a2330367', NULL, 0.00000000, 0, 0, 1, '5FVA4HK2YSJGP4U3', '2017-08-01 20:37:01'),
	(12, 'Maria', 'Silva', 'maria', 'maria@mail.com', '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2', 'cosmo123', 0.00000000, 0, 0, NULL, NULL, '2017-08-01 20:46:00');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;