CREATE TABLE `cliente` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cod_cliente` int(11) NOT NULL,
`cpf` char(11) NOT NULL,
`nome` varchar(255) NOT NULL,
`dt_nascimento` date NOT NULL,
`estado_civil` varchar(255) NOT NULL,
`sexo` char(1) NOT NULL,
`email` varchar(255) NOT NULL,
`id_endereco` int(11) NOT NULL,
`status` tinyint(4) NOT NULL,
`id_dispositivo` int(11) DEFAULT NULL,
`dt_primeiro_login` datetime DEFAULT NULL,
`dt_ultimo_login` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `un_cod_cliente` (`cod_cliente`),
KEY `fk_cliente_endereco_idx` (`id_endereco`),
KEY `fk_cliente_dispositivo_idx` (`id_dispositivo`),
KEY `ix_cliente_cpf` (`cpf`),
CONSTRAINT `fk_cliente_dispositivo` FOREIGN KEY (`id_dispositivo`) REFERENCES `dispositivo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_cliente_endereco` FOREIGN KEY (`id_endereco`) REFERENCES `endereco` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=603797 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cliente`
--
LOCK TABLES `cliente` WRITE;
/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
INSERT INTO `cliente` VALUES (1,100030,'09013335730','ALICE MARIA BARROS SILVA MONTEIRO','1982-04-19','casado','F','
alicebarros@maisamigas.com.br',1,1,140890,'2017-11-07 16:22:24','2022-09-21 09:36:32'),(2,100031,'07212611751','FELIPE DAL BELLO LIMA','1976-11-13','casado','F','
felipe@maisamigas.com.br',2,1,125568,'2017-11-16 13:41:06','2022-07-07 11:38:28'),(3,100032,'37735386001','CONSULTOR DE TESTE 4','1984-06-03','solteiro','F','
teste254@gmail.com',3,1,NULL,'2017-11-16 14:47:13','2018-02-23 15:03:02'),(4,106514,'08448024761','CLARISSE DIAZ','1980-05-16','solteiro','F','
clapodifra@hotmail.com',4,1,88919,'2017-11-07 14:42:39','2022-09-21 15:06:50'),(5,120423,'10626747740','ANA OLIVEIRA','1985-10-23','solteiro','F','',5,1,60608,'2017-11-10 13:51:00','2022-03-18 10:59:15'),(6,199815,'66950929749','DIOMAR OLIVEIRA','1961-08-08','casado','M','
diomaroliveira@maisamigas.com',6,1,119962,'2017-11-10 19:50:12','2022-07-11 14:01:06'),(7,369587,'07783762735','CARLA REGINA DA SILVA PIMENTA AVELINO','1978-05-18','casado','F','
carlaavelino@maisamigas.com.br',7,1,29931,'2019-08-27 10:58:58','2022-05-19 16:11:25'),(8,380698,'90985117753','CARLOS HENRIQUE DIEGUEZ MARTINS','1969-03-30','casado','M','
carlosmartins@maisamigas.com.br',8,1,143516,'2017-12-01 12:05:32','2022-09-24 19:14:19'),(9,426066,'05224569796','RAFAEL COSTA','1979-03-11','casado','M','
rafaelcosta@maisamigas.com.br',9,1,58539,'2020-07-06 15:43:51','2021-07-01 13:17:36'),(10,524771,'01672693721','ANA PAULA AZEVEDO CHIARA','1972-05-16','casado','F','
ap.azevedo@hotmail.com',10,1,NULL,'2020-11-18 12:06:18',NULL),(11,554117,'07514833463','IRANEIDE COELHO DA SILVA','1988-01-25','casado','F','',11,1,98717,'2019-09-18 08:41:59','2022-06-27 12:21:06'),(12,573463,'08837150660','JOAO B FERREIRA ALVES','1984-08-05','casado','M','',12,1,17995,'2019-12-25 12:36:27','2021-02-16 01:09:55'),(13,100033,'25724192896','MARCIA ALESSANDRA RODRIGUES','1978-05-20','casado','F','
marciaalessandra17@hotmail.com',13,1,NULL,'2017-11-09 18:14:15','2017-11-09 18:14:15'),(14,100036,'03897353881','VALDI DINIZ ESPERIDIAO','1962-11-20','casado','M','
valdides@yahoo.com.br',14,1,NULL,'2017-11-07 17:26:39','2019-02-15 17:12:23'),(15,100037,'43815289807','YAHAIRA YASMIN DOMINGUES PASTOR','1995-12-22','solteiro','F','
yahaira22@outlook.com.br',15,1,NULL,NULL,NULL),(16,100038,'06283520855','MARIA LUISA DA SILVA','1961-02-23','casado','F','
luizamaria61@bol.com.br',16,1,NULL,NULL,NULL),(17,100039,'03486659898','ARIOVALDO DOMINGUES MACIEL','1956-06-12','casado','M','
ari1domingues@hotmail.com',17,1,NULL,NULL,NULL),(18,100040,'16492984803','ROSANGELA DAS GRAÇAS PENA SILVA','1973-02-19','casado','F','',18,0,NULL,'2017-11-09 18:14:15','2017-11-09 18:14:15'),(19,100041,'17863428807','CARMEN LUCIA FRANCISCO CAMARA','1962-08-09','casado','F','
camara.mauricio@bol.com.br',19,1,NULL,NULL,NULL),(20,100042,'34757552890','WILCINEIA DE FATIMA CAMARA JUVENTINO','1985-08-20','casado','F','
mauricio_fcamara@hotmail.com',20,1,NULL,NULL,NULL),(21,100043,'22078381888','MARIA INEZ HANSEN AFONSO','1944-04-07','casado','F','
manoelelzo@terra.com.br',21,1,NULL,NULL,NULL),(22,100044,'05538018806','MARIA DO ROSARIO DA CUNHA','1959-10-04','casado','F','',22,1,NULL,'2017-11-08 00:41:49','2020-11-02 22:39:35'),(23,100045,'30142716839','JOSIANE MELO DA SILVA','1978-05-15','casado','F','',23,1,NULL,NULL,NULL),(24,100046,'43500478832','DOUGLAS WELLINGTON LIMA','1996-05-01','solteiro','F','
douglaswell@hotmail.com',24,1,NULL,'2020-02-05 17:14:18','2020-02-05 17:27:20'),(25,100047,'24898102867','ALEXANDRE FRANZONI','1975-11-21','casado','M','
danicatalogos@hotmail.com',25,1,31052,'2017-12-04 14:05:36','2022-07-07 10:12:47'),(26,100048,'25021450824','LUIS CARLOS DE OLIVEIRA','1956-04-13','casado','M','',26,1,130278,'2022-07-07 13:57:43',NULL),(27,100049,'28089738885','DANIELE A SANTOS FRANZONI','1979-07-14','casado','F','',27,1,31052,'2021-12-04 13:53:36',NULL),(28,100050,'34673603869','THIAGO JEFFERSON DE FREITAS','1985-06-20','casado','M','',28,1,NULL,NULL,NULL),(29,100051,'44324560862','PATRICIA KESIA ALVES ARAUJO','1996-06-18','casado','F','
tiagopatriciaalves@gmail.com',29,1,NULL,NULL,NULL),(30,100052,'39451145869','JOSE MATHEUS DA SILVA RAMOS','1992-05-06','casado','M','',30,1,NULL,NULL,NULL),(31,100053,'05734599832','CARLOS ULISSES APARECIDO DRAGO','1967-02-28','divorciado','M','',31,1,NULL,NULL,NULL),(32,100054,'11528097840','CLEUSA MARIA SPIRONELO','1954-05-26','casado','F','',32,1,NULL,NULL,NULL),(33,100055,'08319059801','MARLI AP DO AMARAL F PEREIRA','1966-01-06','casado','F','',33,1,NULL,NULL,NULL),(34,100056,'41353781615','ONILIA ISABEL PADILHA','1960-03-04','viuvo','F','',34,1,NULL,NULL,NULL),(35,100057,'18577014886','SOLANGE GOUVEIA MOREIRA','1972-09-26','casado','F','',35,1,NULL,NULL,NULL),(36,100058,'35937228871','ANDRESSA CRISTINA DA COSTA','1995-11-19','solteiro','F','',36,1,NULL,NULL,NULL),(37,100059,'05314696894','JANDIRA SANTOS DE MOURA DELFINO','1965-09-05','casado','F','
jandiradelfino@gmail.com',37,0,NULL,NULL,NULL),(38,100060,'19206598899','ESTELA MARIA DE LIRA','1931-02-18','casado','F','',38,1,NULL,NULL,NULL),(39,100061,'27618492808','VALDETE FATIMA S ESTEVAN','1953-12-30','casado','F','',39,1,NULL,NULL,NULL),(40,100062,'17033285825','ADRIANO JUNIOR SARZI','1974-04-09','solteiro','M','
adrianosarzi@hotmail.com',40,1,113124,'2017-11-09 18:14:15','2022-03-22 08:36:34'),(41,100063,'89962645557','CONSULTORA DE TESTE','2015-08-12','solteiro','F','',41,1,NULL,NULL,NULL),(42,100064,'68526035630','CONSULTORA DE TESTE','2015-08-12','solteiro','F','',42,1,NULL,NULL,NULL),(43,100065,'08073037718','KELLEN FRANCO DE AZEVEDO','1976-10-25','casado','F','',43,0,NULL,'2017-11-09 18:14:15','2019-01-08 14:21:07'),(44,100066,'36863347806','THAIS SABRINA SANTOS PAULA','1990-09-21','solteiro','F','',44,0,NULL,NULL,NULL),(45,100067,'10169050840','SONIA MARIA INACIO','1969-09-21','casado','F','',45,0,NULL,NULL,NULL),(46,100068,'38248908011','MARIA JOSE SANTOS MARONGIO','1940-05-24','casado','F','',46,0,NULL,NULL,NULL),(47,100069,'80694829587','ADRIANA COELHO NERES','1976-05-01','solteiro','F','',47,0,NULL,NULL,NULL),(48,100070,'03102396720','CRISTIANE SANTOS','1974-07-24','solteiro','F','',48,0,NULL,NULL,NULL),(49,100071,'04287721888','LAURA TOLEDO CHAGAS','1963-06-03','casado','F','',49,0,NULL,NULL,NULL),(50,100072,'24688997841','MARIA SOLEDADE CAMARGO SANTOS','1943-10-06','casado','F','',50,0,NULL,NULL,NULL),(51,100073,'04859088832','GISLAINE CRISTINA Q MENEGUETTI','1963-09-25','casado','F','',51,1,NULL,NULL,NULL),(52,100074,'12197054899','SILVIA REGINA DA SILVA','1973-09-25','casado','F','',52,0,NULL,NULL,NULL),(53,100075,'35832887859','NAJLA FERREIRA MARTINS MORAIS','1986-08-11','casado','F','',53,0,NULL,NULL,NULL),(54,100076,'42112343823','REGIANE MESSIAS FERNANDES','1992-07-11','casado','F','',54,0,NULL,NULL,NULL),(55,100077,'04274902862','MARIA RUTE
