Zendion/Fmovel
Zendion
/
Fmovel
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Fmovel/Banco.sql

782 lines
172 KiB
MySQL
Raw Permalink Normal View History

primeiro commit
2025-07-09 14:11:55 +00:00
-- MariaDB dump 10.17 Distrib 10.4.10-MariaDB, for Win64 (AMD64)
--
-- Host: localhost Database: fmovel
-- ------------------------------------------------------
-- Server version 10.4.10-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `agendamentos`
--
DROP TABLE IF EXISTS `agendamentos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agendamentos` (
`idagendamentos` int(11) NOT NULL AUTO_INCREMENT,
`idvisitas` int(11) DEFAULT NULL,
`dataretorno` datetime DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idagendamentos`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `agendamentos`
--
LOCK TABLES `agendamentos` WRITE;
/*!40000 ALTER TABLE `agendamentos` DISABLE KEYS */;
/*!40000 ALTER TABLE `agendamentos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `bancos`
--
DROP TABLE IF EXISTS `bancos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bancos` (
`idbancos` int(11) NOT NULL AUTO_INCREMENT,
`descricao` varchar(45) DEFAULT NULL,
`saldo` double DEFAULT NULL,
`debito` tinyint(4) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idbancos`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bancos`
--
LOCK TABLES `bancos` WRITE;
/*!40000 ALTER TABLE `bancos` DISABLE KEYS */;
/*!40000 ALTER TABLE `bancos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `centrodecustos`
--
DROP TABLE IF EXISTS `centrodecustos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `centrodecustos` (
`idcentrodecustos` int(11) NOT NULL AUTO_INCREMENT,
`descricao` varchar(150) DEFAULT NULL,
`limite` double DEFAULT NULL,
`simular` tinyint(4) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idcentrodecustos`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `centrodecustos`
--
LOCK TABLES `centrodecustos` WRITE;
/*!40000 ALTER TABLE `centrodecustos` DISABLE KEYS */;
/*!40000 ALTER TABLE `centrodecustos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cidades`
--
DROP TABLE IF EXISTS `cidades`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cidades` (
`idcidade` int(11) NOT NULL AUTO_INCREMENT,
`idestado` int(11) DEFAULT NULL,
`descricao` varchar(150) DEFAULT NULL,
PRIMARY KEY (`idcidade`)
) ENGINE=InnoDB AUTO_INCREMENT=5572 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cidades`
--
LOCK TABLES `cidades` WRITE;
/*!40000 ALTER TABLE `cidades` DISABLE KEYS */;
INSERT INTO `cidades` VALUES (1,11,'Alta Floresta D\'Oeste'),(2,11,'Ariquemes'),(3,11,'Cabixi'),(4,11,'Cacoal'),(5,11,'Cerejeiras'),(6,11,'Colorado do Oeste'),(7,11,'Corumbiara'),(8,11,'Costa Marques'),(9,11,'Espigão D\'Oeste'),(10,11,'Guajará-Mirim'),(11,11,'Jaru'),(12,11,'Ji-Paraná'),(13,11,'Machadinho D\'Oeste'),(14,11,'Nova Brasilândia D\'Oeste'),(15,11,'Ouro Preto do Oeste'),(16,11,'Pimenta Bueno'),(17,11,'Porto Velho'),(18,11,'Presidente Médici'),(19,11,'Rio Crespo'),(20,11,'Rolim de Moura'),(21,11,'Santa Luzia D\'Oeste'),(22,11,'Vilhena'),(23,11,'São Miguel do Guaporé'),(24,11,'Nova Mamoré'),(25,11,'Alvorada D\'Oeste'),(26,11,'Alto Alegre dos Parecis'),(27,11,'Alto Paraíso'),(28,11,'Buritis'),(29,11,'Novo Horizonte do Oeste'),(30,11,'Cacaulândia'),(31,11,'Campo Novo de Rondônia'),(32,11,'Candeias do Jamari'),(33,11,'Castanheiras'),(34,11,'Chupinguaia'),(35,11,'Cujubim'),(36,11,'Governador Jorge Teixeira'),(37,11,'Itapuã do Oeste'),(38,11,'Ministro Andreazza'),(39,11,'Mirante da Serra'),(40,11,'Monte Negro'),(41,11,'Nova União'),(42,11,'Parecis'),(43,11,'Pimenteiras do Oeste'),(44,11,'Primavera de Rondônia'),(45,11,'São Felipe D\'Oeste'),(46,11,'São Francisco do Guaporé'),(47,11,'Seringueiras'),(48,11,'Teixeirópolis'),(49,11,'Theobroma'),(50,11,'Urupá'),(51,11,'Vale do Anari'),(52,11,'Vale do Paraíso'),(53,12,'Acrelândia'),(54,12,'Assis Brasil'),(55,12,'Brasiléia'),(56,12,'Bujari'),(57,12,'Capixaba'),(58,12,'Cruzeiro do Sul'),(59,12,'Epitaciolândia'),(60,12,'Feijó'),(61,12,'Jordão'),(62,12,'Mâncio Lima'),(63,12,'Manoel Urbano'),(64,12,'Marechal Thaumaturgo'),(65,12,'Plácido de Castro'),(66,12,'Porto Walter'),(67,12,'Rio Branco'),(68,12,'Rodrigues Alves'),(69,12,'Santa Rosa do Purus'),(70,12,'Senador Guiomard'),(71,12,'Sena Madureira'),(72,12,'Tarauacá'),(73,12,'Xapuri'),(74,12,'Porto Acre'),(75,13,'Alvarães'),(76,13,'Amaturá'),(77,13,'Anamã'),(78,13,'Anori'),(79,13,'Apuí'),(80,13,'Atalaia do Norte'),(81,13,'Autazes'),(82,13,'Barcelos'),(83,13,'Barreirinha'),(84,13,'Benjamin Constant'),(85,13,'Beruri'),(86,13,'Boa Vista do Ramos'),(87,13,'Boca do Acre'),(88,13,'Borba'),(89,13,'Caapiranga'),(90,13,'Canutama'),(91,13,'Carauari'),(92,13,'Careiro'),(93,13,'Careiro da Várzea'),(94,13,'Coari'),(95,13,'Codajás'),(96,13,'Eirunepé'),(97,13,'Envira'),(98,13,'Fonte Boa'),(99,13,'Guajará'),(100,13,'Humaitá'),(101,13,'Ipixuna'),(102,13,'Iranduba'),(103,13,'Itacoatiara'),(104,13,'Itamarati'),(105,13,'Itapiranga'),(106,13,'Japurá'),(107,13,'Juruá'),(108,13,'Jutaí'),(109,13,'Lábrea'),(110,13,'Manacapuru'),(111,13,'Manaquiri'),(112,13,'Manaus'),(113,13,'Manicoré'),(114,13,'Maraã'),(115,13,'Maués'),(116,13,'Nhamundá'),(117,13,'Nova Olinda do Norte'),(118,13,'Novo Airão'),(119,13,'Novo Aripuanã'),(120,13,'Parintins'),(121,13,'Pauini'),(122,13,'Presidente Figueiredo'),(123,13,'Rio Preto da Eva'),(124,13,'Santa Isabel do Rio Negro'),(125,13,'Santo Antônio do Içá'),(126,13,'São Gabriel da Cachoeira'),(127,13,'São Paulo de Olivença'),(128,13,'São Sebastião do Uatumã'),(129,13,'Silves'),(130,13,'Tabatinga'),(131,13,'Tapauá'),(132,13,'Tefé'),(133,13,'Tonantins'),(134,13,'Uarini'),(135,13,'Urucará'),(136,13,'Urucurituba'),(137,14,'Amajari'),(138,14,'Alto Alegre'),(139,14,'Boa Vista'),(140,14,'Bonfim'),(141,14,'Cantá'),(142,14,'Caracaraí'),(143,14,'Caroebe'),(144,14,'Iracema'),(145,14,'Mucajaí'),(146,14,'Normandia'),(147,14,'Pacaraima'),(148,14,'Rorainópolis'),(149,14,'São João da Baliza'),(150,14,'São Luiz'),(151,14,'Uiramutã'),(152,15,'Abaetetuba'),(153,15,'Abel Figueiredo'),(154,15,'Acará'),(155,15,'Afuá'),(156,15,'Água Azul do Norte'),(157,15,'Alenquer'),(158,15,'Almeirim'),(159,15,'Altamira'),(160,15,'Anajás'),(161,15,'Ananindeua'),(162,15,'Anapu'),(163,15,'Augusto Corrêa'),(164,15,'Aurora do Pará'),(165,15,'Aveiro'),(166,15,'Bagre'),(167,15,'Baião'),(168,15,'Bannach'),(169,15,'Barcarena'),(170,15,'Belém'),(171,15,'Belterra'),(172,15,'Benevides'),(173,15,'Bom Jesus do Tocantins'),(174,15,'Bonito'),(175,15,'Bragança'),(176,15,'Brasil Novo'),(177,15,'Brejo Grande
/*!40000 ALTER TABLE `cidades` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `clientes`
--
DROP TABLE IF EXISTS `clientes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clientes` (
`idclientes` int(11) NOT NULL AUTO_INCREMENT,
`cpf_cnpj` varchar(45) NOT NULL,
`nome` varchar(150) DEFAULT NULL,
`rg` varchar(45) DEFAULT NULL,
`celular` varchar(45) DEFAULT NULL,
`email` varchar(150) DEFAULT NULL,
`cep` varchar(45) DEFAULT NULL,
`logradouro` varchar(150) DEFAULT NULL,
`numero` varchar(45) DEFAULT NULL,
`bairro` varchar(150) DEFAULT NULL,
`cidade` varchar(100) DEFAULT NULL,
`estado` varchar(100) DEFAULT NULL,
`sexo` varchar(1) DEFAULT NULL,
`pessoafisica` varchar(1) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idclientes`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `clientes`
--
LOCK TABLES `clientes` WRITE;
/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `configuracoes`
--
DROP TABLE IF EXISTS `configuracoes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `configuracoes` (
`idconfiguracoes` int(11) NOT NULL AUTO_INCREMENT,
`nome_loja` varchar(100) DEFAULT NULL,
`responsavel` varchar(100) DEFAULT NULL,
`telefone` varchar(45) DEFAULT NULL,
`celular` varchar(45) DEFAULT NULL,
`endereco` varchar(200) DEFAULT NULL,
`horario_atendimento` varchar(100) DEFAULT NULL,
`caminho_logo` varchar(555) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`udpate_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idconfiguracoes`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `configuracoes`
--
LOCK TABLES `configuracoes` WRITE;
/*!40000 ALTER TABLE `configuracoes` DISABLE KEYS */;
INSERT INTO `configuracoes` VALUES (1,'Estacionamento do Gustavo','Gustavo Farias Rocha','(19) 3554-8849','(19) 99871-7777','Rua das Garcas, 49 - Centro Leme SP','Seg a Sex das 09:00 as 18:00','C:/Logo.png','2021-03-13 15:31:10','2021-03-13 16:03:22');
/*!40000 ALTER TABLE `configuracoes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contasapagar`
--
DROP TABLE IF EXISTS `contasapagar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contasapagar` (
`idcontasapagar` int(11) NOT NULL AUTO_INCREMENT,
`movimento` varchar(45) DEFAULT NULL,
`descricao` varchar(150) DEFAULT NULL,
`dataentrada` datetime DEFAULT NULL,
`datavencimento` datetime DEFAULT NULL,
`databaixa` datetime DEFAULT NULL,
`valor` double DEFAULT NULL,
`parcela` int(11) DEFAULT NULL,
`parcelas` int(11) DEFAULT NULL,
`status` varchar(45) DEFAULT NULL,
`idcentrodecustos` int(11) DEFAULT NULL,
`idbancos` int(11) DEFAULT NULL,
`idusuarios_cad` int(11) DEFAULT NULL,
`idusuarios_baixa` int(11) DEFAULT NULL,
`idclientes` int(11) DEFAULT NULL,
`idveiculosdetalhes` int(11) DEFAULT NULL,
`idbancos_p` int(11) DEFAULT NULL,
`observacao` varchar(255) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idcontasapagar`)
) ENGINE=InnoDB AUTO_INCREMENT=1043 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contasapagar`
--
LOCK TABLES `contasapagar` WRITE;
/*!40000 ALTER TABLE `contasapagar` DISABLE KEYS */;
/*!40000 ALTER TABLE `contasapagar` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contasquitadas`
--
DROP TABLE IF EXISTS `contasquitadas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contasquitadas` (
`idcontasquitadas` int(11) NOT NULL AUTO_INCREMENT,
`idbancos` int(11) DEFAULT NULL,
`idbancos_p` int(11) DEFAULT NULL,
`valor` double DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idcontasquitadas`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contasquitadas`
--
LOCK TABLES `contasquitadas` WRITE;
/*!40000 ALTER TABLE `contasquitadas` DISABLE KEYS */;
/*!40000 ALTER TABLE `contasquitadas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `contasquitadasref`
--
DROP TABLE IF EXISTS `contasquitadasref`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contasquitadasref` (
`idcontasquitadasref` int(11) NOT NULL AUTO_INCREMENT,
`idcontasquitadas` int(11) DEFAULT NULL,
`idcontasapagar` int(11) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idcontasquitadasref`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `contasquitadasref`
--
LOCK TABLES `contasquitadasref` WRITE;
/*!40000 ALTER TABLE `contasquitadasref` DISABLE KEYS */;
/*!40000 ALTER TABLE `contasquitadasref` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estados`
--
DROP TABLE IF EXISTS `estados`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estados` (
`idestado` int(11) NOT NULL AUTO_INCREMENT,
`descricao` varchar(45) DEFAULT NULL,
`uf` varchar(2) DEFAULT NULL,
PRIMARY KEY (`idestado`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estados`
--
LOCK TABLES `estados` WRITE;
/*!40000 ALTER TABLE `estados` DISABLE KEYS */;
INSERT INTO `estados` VALUES (11,'Rondônia','RO'),(12,'Acre','AC'),(13,'Amazonas','AM'),(14,'Roraima','RR'),(15,'Pará','PA'),(16,'Amapá','AP'),(17,'Tocantins','TO'),(21,'Maranhão','MA'),(22,'Piauí','PI'),(23,'Ceará','CE'),(24,'Rio Grande do Norte','RN'),(25,'Paraíba','PB'),(26,'Pernambuco','PE'),(27,'Alagoas','AL'),(28,'Sergipe','SE'),(29,'Bahia','BA'),(31,'Minas Gerais','MG'),(32,'Espírito Santo','ES'),(33,'Rio de Janeiro','RJ'),(35,'São Paulo','SP'),(41,'Paraná','PR'),(42,'Santa Catarina','SC'),(43,'Rio Grande do Sul','RS'),(50,'Mato Grosso do Sul','MS'),(51,'Mato Grosso','MT'),(52,'Goiás','GO'),(53,'Distrito Federal','DF');
/*!40000 ALTER TABLE `estados` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `estoque`
--
DROP TABLE IF EXISTS `estoque`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estoque` (
`idestoque` int(11) NOT NULL AUTO_INCREMENT,
`idveiculos` int(11) DEFAULT NULL,
`motor` varchar(45) DEFAULT NULL,
`versao` varchar(150) DEFAULT NULL,
`ano` int(11) DEFAULT NULL,
`direcao` varchar(100) DEFAULT NULL,
`valoripva` double DEFAULT NULL,
`portas` int(11) DEFAULT NULL,
`cambio` varchar(45) DEFAULT NULL,
`combustivel` varchar(45) DEFAULT NULL,
`quantidade` int(11) DEFAULT 1,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idestoque`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `estoque`
--
LOCK TABLES `estoque` WRITE;
/*!40000 ALTER TABLE `estoque` DISABLE KEYS */;
/*!40000 ALTER TABLE `estoque` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fabricantes`
--
DROP TABLE IF EXISTS `fabricantes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fabricantes` (
`idfabricantes` int(11) NOT NULL AUTO_INCREMENT,
`descricao` varchar(150) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idfabricantes`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fabricantes`
--
LOCK TABLES `fabricantes` WRITE;
/*!40000 ALTER TABLE `fabricantes` DISABLE KEYS */;
INSERT INTO `fabricantes` VALUES (1,'Chevrolet','2021-04-13 20:30:49',NULL),(2,'VolksWagen','2021-04-13 20:30:56',NULL),(3,'Audi','2021-04-13 20:31:01',NULL),(4,'Fiat','2021-04-13 20:31:05',NULL),(5,'Honda','2021-04-13 20:31:12',NULL),(6,'Ford','2021-04-13 20:31:19',NULL),(7,'Kia','2021-04-13 20:31:26',NULL);
/*!40000 ALTER TABLE `fabricantes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `fornecedores`
--
DROP TABLE IF EXISTS `fornecedores`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fornecedores` (
`idfornecedores` int(11) NOT NULL AUTO_INCREMENT,
`cpf_cnpj` varchar(45) NOT NULL,
`nomefantasia` varchar(150) DEFAULT NULL,
`razaosocial` varchar(150) DEFAULT NULL,
`telefone` varchar(45) DEFAULT NULL,
`email` varchar(150) DEFAULT NULL,
`cep` int(11) DEFAULT NULL,
`logradouro` varchar(150) DEFAULT NULL,
`numero` varchar(45) DEFAULT NULL,
`bairro` varchar(150) DEFAULT NULL,
`cidade` varchar(100) DEFAULT NULL,
`estado` varchar(100) DEFAULT NULL,
`sexo` varchar(1) DEFAULT NULL,
`pessoafisica` varchar(1) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idfornecedores`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `fornecedores`
--
LOCK TABLES `fornecedores` WRITE;
/*!40000 ALTER TABLE `fornecedores` DISABLE KEYS */;
/*!40000 ALTER TABLE `fornecedores` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menus`
--
DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menus` (
`idmenus` int(11) NOT NULL AUTO_INCREMENT,
`menu` varchar(45) DEFAULT NULL,
`objeto` varchar(255) DEFAULT NULL,
`x_location` int(11) DEFAULT NULL,
`y_location` int(11) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idmenus`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `menus`
--
LOCK TABLES `menus` WRITE;
/*!40000 ALTER TABLE `menus` DISABLE KEYS */;
INSERT INTO `menus` VALUES (1,'esquerdo_clientes','imgClientes',NULL,NULL,'2022-03-02 09:01:06','2022-03-02 18:03:30'),(2,'esquerdo_fornecedores','imgFornecedores',NULL,NULL,'2022-03-02 09:01:13','2022-03-02 18:03:35'),(3,'esrquerdo_veiculos','imgVeiculos',NULL,NULL,'2022-03-02 09:01:18','2022-03-02 18:03:39'),(4,'esrquerdo_usuarios','imgUsuarios',NULL,NULL,'2022-03-02 09:01:24','2022-03-02 18:03:44'),(5,'esquerdo_agenda','imgAgendamentos',NULL,NULL,'2022-03-02 09:01:30','2022-03-02 18:03:47'),(6,'esquerdo_visitas','imgVisitas',NULL,NULL,'2022-03-02 09:01:34','2022-03-02 18:03:51'),(7,'esquerdo_movimentos','imgContasPagar',NULL,NULL,'2022-03-02 09:01:41','2022-03-02 18:03:55'),(8,'esquerdo_backup','imgBackup',NULL,NULL,'2022-03-02 09:01:45','2022-03-02 18:03:59'),(9,'superior_sistema','arquivoToolStripMenuItem',NULL,NULL,'2022-03-02 09:02:03','2022-03-02 17:18:23'),(10,'superior_sistema_usuarios','usuariosToolStripMenuItem',NULL,NULL,'2022-03-02 09:02:51','2022-03-02 17:18:30'),(11,'superior_sistema_permissoes','permissõesToolStripMenuItem',NULL,NULL,'2022-03-02 09:03:02','2022-03-02 17:18:36'),(12,'superior_sistema_backup','backupToolStripMenuItem',NULL,NULL,'2022-03-02 09:03:08','2022-03-02 17:18:42'),(13,'superior_sistema_configuracoes','dadosDaEmpresaToolStripMenuItem',NULL,NULL,'2022-03-02 09:03:26','2022-03-02 17:18:50'),(14,'superior_financeiro','financeiroToolStripMenuItem',NULL,NULL,'2022-03-02 09:03:33','2022-03-02 17:18:55'),(15,'superior_financeiro_fixos','movimentosFixosToolStripMenuItem',NULL,NULL,'2022-03-02 09:03:52','2022-03-02 17:19:01'),(16,'superior_financeiro_movimentos','movimentosBancosToolStripMenuItem',NULL,NULL,'2022-03-02 09:03:58','2022-03-02 17:19:06'),(17,'superior_financeiro_bancos','bancosToolStripMenuItem',NULL,NULL,'2022-03-02 09:04:10','2022-03-02 17:19:52'),(18,'superior_financeiro_centroscustos','centrosDeCustoToolStripMenuItem',NULL,NULL,'2022-03-02 09:04:22','2022-03-02 17:19:59'),(19,'superior_clientes','clientesToolStripMenuItem',NULL,NULL,'2022-03-02 09:04:28','2022-03-02 17:20:17'),(20,'superior_clientes_cadastro','cadastroConsultaToolStripMenuItem',NULL,NULL,'2022-03-02 09:04:42','2022-03-02 17:20:22'),(21,'superior_clientes_visitas','controleDeVisitasToolStripMenuItem',NULL,NULL,'2022-03-02 09:04:50','2022-03-02 17:20:28'),(22,'superior_clientes_agendamentos','agendamentosToolStripMenuItem',NULL,NULL,'2022-03-02 09:05:03','2022-03-02 17:20:33'),(23,'superior_fornecedores','fornecedoresToolStripMenuItem',NULL,NULL,'2022-03-02 09:05:14','2022-03-02 17:20:40'),(24,'superior_fornecedores_cadastro','cadastroConsultaToolStripMenuItem1',NULL,NULL,'2022-03-02 09:05:19','2022-03-02 17:20:47'),(25,'superior_fornecedores_veiculos','veiculosToolStripMenuItem',NULL,NULL,'2022-03-02 09:05:25','2022-03-02 17:20:52'),(26,'superior_financeiro_consulta','consultaMovimentosToolStripMenuItem',NULL,NULL,'2022-03-02 17:21:14',NULL),(27,'direito_notas','imgNotas',14,88,'2022-03-02 17:21:49','2022-03-03 08:19:01'),(28,'direito_calculadora','imgCalculadora',121,88,'2022-03-02 17:22:01','2022-03-03 08:19:13'),(29,'esquerdo_bancos','imgBancos',NULL,NULL,'2022-03-03 10:35:50',NULL);
/*!40000 ALTER TABLE `menus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `movimentosfixos`
--
DROP TABLE IF EXISTS `movimentosfixos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `movimentosfixos` (
`idmovimentosfixos` int(11) NOT NULL AUTO_INCREMENT,
`movimento` varchar(45) DEFAULT NULL,
`descricao` varchar(150) DEFAULT NULL,
`valor` double DEFAULT NULL,
`dia_vencimento` int(11) DEFAULT NULL,
`idcentrodecustos` int(11) DEFAULT NULL,
`habilitado` tinyint(4) DEFAULT NULL,
`idbancos` int(11) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idmovimentosfixos`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `movimentosfixos`
--
LOCK TABLES `movimentosfixos` WRITE;
/*!40000 ALTER TABLE `movimentosfixos` DISABLE KEYS */;
/*!40000 ALTER TABLE `movimentosfixos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `permissoes`
--
DROP TABLE IF EXISTS `permissoes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissoes` (
`idpermissoes` int(11) NOT NULL AUTO_INCREMENT,
`descricaoacesso` varchar(45) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idpermissoes`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `permissoes`
--
LOCK TABLES `permissoes` WRITE;
/*!40000 ALTER TABLE `permissoes` DISABLE KEYS */;
INSERT INTO `permissoes` VALUES (1,'Inserir','2021-02-27 08:22:45',NULL),(2,'Excluir','2021-02-27 08:22:45',NULL),(3,'Editar','2021-02-27 08:22:45',NULL),(4,'Consultar','2021-02-27 08:22:45',NULL),(5,'Abrir','2021-02-27 08:22:45',NULL),(6,'Imprimir','2021-02-27 08:22:45',NULL),(7,'SemAcesso','2021-02-27 08:22:45',NULL),(8,'AcessoTotal','2021-02-27 08:22:45',NULL);
/*!40000 ALTER TABLE `permissoes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `permissoesacoes`
--
DROP TABLE IF EXISTS `permissoesacoes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissoesacoes` (
`idpermissoesacoes` int(11) NOT NULL AUTO_INCREMENT,
`idpermissoes` int(11) NOT NULL,
`formulario` varchar(150) NOT NULL,
`acao` varchar(45) NOT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idpermissoesacoes`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `permissoesacoes`
--
LOCK TABLES `permissoesacoes` WRITE;
/*!40000 ALTER TABLE `permissoesacoes` DISABLE KEYS */;
INSERT INTO `permissoesacoes` VALUES (1,8,'Agendamentos','AcessoTotal','2021-02-27 11:19:09',NULL),(2,8,'Backup','AcessoTotal','2021-02-27 11:19:18',NULL),(3,8,'Bancos','AcessoTotal','2021-02-27 11:18:53',NULL),(4,8,'Centros de Custo','AcessoTotal','2021-02-27 11:18:45',NULL),(5,8,'Clientes','AcessoTotal','2021-02-27 11:18:06',NULL),(6,8,'Contas a Pagar','AcessoTotal','2021-02-27 11:18:58',NULL),(7,8,'Controle de Visitas','AcessoTotal','2021-02-27 11:17:00',NULL),(8,8,'Fornecedores','AcessoTotal','2021-02-27 11:18:18',NULL),(9,8,'Movimento de Caixa','AcessoTotal','2021-02-27 11:18:37',NULL),(10,8,'Movimentos Fixos','AcessoTotal','2021-02-27 11:19:04',NULL),(11,8,'Permissoes','AcessoTotal','2021-02-27 11:19:13',NULL),(12,8,'Usuarios','AcessoTotal','2021-02-27 11:17:58',NULL),(13,8,'Veiculos','AcessoTotal','2021-02-27 11:18:26',NULL),(18,5,'Agendamentos','Abrir','2021-02-27 11:45:15',NULL),(19,6,'Agendamentos','Imprimir','2021-02-27 11:45:20',NULL),(20,7,'Agendamentos','SemAcesso','2021-02-27 11:45:25',NULL),(21,5,'Backup','Abrir','2021-02-27 11:46:20',NULL),(22,7,'Backup','SemAcesso','2021-02-27 11:46:32',NULL),(23,1,'Bancos','Inserir','2021-02-27 11:46:39',NULL),(24,2,'Bancos','Excluir','2021-02-27 11:46:45',NULL),(25,3,'Bancos','Editar','2021-02-27 11:46:50',NULL),(26,5,'Bancos','Abrir','2021-02-27 11:47:01',NULL),(27,7,'Bancos','SemAcesso','2021-02-27 11:47:16',NULL),(28,1,'Centros de Custo','Inserir','2021-02-27 11:47:23',NULL),(29,2,'Centros de Custo','Excluir','2021-02-27 11:47:28',NULL),(30,3,'Centros de Custo','Editar','2021-02-27 11:47:33',NULL),(31,5,'Centros de Custo','Abrir','2021-02-27 11:47:43',NULL),(33,7,'Centros de Custo','SemAcesso','2021-02-27 11:48:06',NULL),(34,1,'Clientes','Inserir','2021-02-27 11:48:44',NULL),(35,2,'Clientes','Excluir','2021-02-27 11:48:57',NULL),(36,3,'Clientes','Editar','2021-02-27 11:49:00',NULL),(37,4,'Clientes','Consultar','2021-02-27 11:49:05',NULL),(38,5,'Clientes','Abrir','2021-02-27 11:49:09',NULL),(39,6,'Clientes','Imprimir','2021-02-27 11:49:14',NULL),(40,7,'Clientes','SemAcesso','2021-02-27 11:49:18',NULL),(44,5,'Contas a Pagar','Abrir','2021-02-27 11:50:14',NULL),(46,6,'Contas a Pagar','Imprimir','2021-02-27 11:51:18',NULL),(47,1,'Movimento de Caixa','Inserir','2021-02-27 11:51:24',NULL),(48,2,'Movimento de Caixa','Excluir','2021-02-27 11:51:29',NULL),(49,3,'Movimento de Caixa','Editar','2021-02-27 11:51:33',NULL),(50,5,'Movimento de Caixa','Abrir','2021-02-27 11:51:40',NULL),(51,7,'Movimento de Caixa','SemAcesso','2021-02-27 11:51:45',NULL),(52,7,'Contas a Pagar','SemAcesso','2021-02-27 11:51:48',NULL),(53,1,'Fabricantes','Inserir','2021-02-27 11:51:54',NULL),(54,2,'Fabricantes','Excluir','2021-02-27 11:51:59',NULL),(55,3,'Fabricantes','Editar','2021-02-27 11:52:03',NULL),(56,5,'Fabricantes','Abrir','2021-02-27 11:52:12',NULL),(57,7,'Fabricantes','SemAcesso','2021-02-27 11:52:18',NULL),(58,1,'Fornecedores','Inserir','2021-02-27 11:52:30',NULL),(59,2,'Fornecedores','Excluir','2021-02-27 11:52:34',NULL),(60,3,'Fornecedores','Editar','2021-02-27 11:52:37',NULL),(62,4,'Fornecedores','Consultar','2021-02-27 11:52:47',NULL),(63,5,'Fornecedores','Abrir','2021-02-27 11:52:51',NULL),(65,6,'Fornecedores','Imprimir','2021-02-27 11:54:40',NULL),(66,7,'Fornecedores','SemAcesso','2021-02-27 11:54:53',NULL),(67,1,'Movimentos Fixos','Inserir','2021-02-27 11:55:00',NULL),(68,2,'Movimentos Fixos','Excluir','2021-02-27 11:55:04',NULL),(69,3,'Movimentos Fixos','Editar','2021-02-27 11:55:10',NULL),(70,4,'Movimentos Fixos','Consultar','2021-02-27 11:55:18',NULL),(71,5,'Movimentos Fixos','Abrir','2021-02-27 11:55:24',NULL),(72,7,'Movimentos Fixos','SemAcesso','2021-02-27 11:55:35',NULL),(73,1,'Permissoes','Inserir','2021-02-27 11:55:40',NULL),(74,2,'Permissoes','Excluir','2021-02-27 11:55:46',NULL),(75,3,'Permissoes','Editar','2021-02-27 11:55:52',NULL),(76,5,'Permissoes','Abrir','2021-02-27 11:56:00',NULL),(77,7,'Permissoes','SemAcesso','2021-02-27 11:56:09',NULL),(78,1,'Usuarios','Inserir','2021-02-27 11:56:14',NULL),(79,2,'Usuarios','Excluir','2021-02-27 11:56:19',NULL),(80,3,'Usuarios',
/*!40000 ALTER TABLE `permissoesacoes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `permissoesusuario`
--
DROP TABLE IF EXISTS `permissoesusuario`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissoesusuario` (
`idpermissoesacoes` int(11) NOT NULL,
`idusuarios` int(11) NOT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idpermissoesacoes`,`idusuarios`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `permissoesusuario`
--
LOCK TABLES `permissoesusuario` WRITE;
/*!40000 ALTER TABLE `permissoesusuario` DISABLE KEYS */;
INSERT INTO `permissoesusuario` VALUES (1,1,'2021-02-27 11:21:25','2021-02-27 11:26:28'),(2,1,'2021-02-27 11:40:24',NULL),(3,1,'2021-02-27 11:40:26',NULL),(4,1,'2021-02-27 11:40:28',NULL),(5,1,'2021-02-27 11:40:31',NULL),(6,1,'2021-02-27 11:40:33',NULL),(7,1,'2021-02-27 11:40:35',NULL),(8,1,'2021-02-27 11:40:38',NULL),(9,1,'2021-02-27 11:40:40',NULL),(10,1,'2021-02-27 11:40:43',NULL),(11,1,'2021-02-27 11:40:45',NULL),(12,1,'2021-02-27 11:40:18',NULL),(13,1,'2021-02-27 11:40:50',NULL),(97,1,'2021-03-13 16:26:35',NULL),(98,1,'2021-03-13 16:26:37',NULL),(99,1,'2021-04-13 22:11:50',NULL),(105,1,'2022-03-03 11:09:20',NULL);
/*!40000 ALTER TABLE `permissoesusuario` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `resultadosvisitas`
--
DROP TABLE IF EXISTS `resultadosvisitas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resultadosvisitas` (
`idresultadosvisitas` int(11) NOT NULL AUTO_INCREMENT,
`descricao` varchar(45) DEFAULT NULL,
`retorno` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`idresultadosvisitas`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `resultadosvisitas`
--
LOCK TABLES `resultadosvisitas` WRITE;
/*!40000 ALTER TABLE `resultadosvisitas` DISABLE KEYS */;
/*!40000 ALTER TABLE `resultadosvisitas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usuarios`
--
DROP TABLE IF EXISTS `usuarios`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuarios` (
`idusuarios` int(11) NOT NULL AUTO_INCREMENT,
`nome` varchar(45) DEFAULT NULL,
`senha` varchar(45) DEFAULT NULL,
`anotacoes` longtext DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idusuarios`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usuarios`
--
LOCK TABLES `usuarios` WRITE;
/*!40000 ALTER TABLE `usuarios` DISABLE KEYS */;
INSERT INTO `usuarios` VALUES (1,'admin','1','','2021-03-01 20:05:27','2021-07-15 18:33:21');
/*!40000 ALTER TABLE `usuarios` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `usuariosmenus`
--
DROP TABLE IF EXISTS `usuariosmenus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuariosmenus` (
`idusuariosmenus` int(11) NOT NULL AUTO_INCREMENT,
`idusuarios` int(11) DEFAULT NULL,
`menu` varchar(45) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idusuariosmenus`)
) ENGINE=InnoDB AUTO_INCREMENT=494 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `usuariosmenus`
--
LOCK TABLES `usuariosmenus` WRITE;
/*!40000 ALTER TABLE `usuariosmenus` DISABLE KEYS */;
INSERT INTO `usuariosmenus` VALUES (481,1,'superior_sistema','2022-03-03 11:09:44',NULL),(482,1,'superior_sistema_usuarios','2022-03-03 11:09:44',NULL),(483,1,'esquerdo_clientes','2022-03-03 11:09:44',NULL),(484,1,'esquerdo_movimentos','2022-03-03 11:09:44',NULL),(485,1,'direito_calculadora','2022-03-03 11:09:44',NULL),(486,1,'direito_notas','2022-03-03 11:09:44',NULL),(487,1,'esquerdo_bancos','2022-03-03 11:09:44',NULL),(488,1,'superior_financeiro','2022-03-03 11:09:44',NULL),(489,1,'superior_financeiro_fixos','2022-03-03 11:09:44',NULL),(490,1,'superior_financeiro_centroscustos','2022-03-03 11:09:44',NULL),(491,1,'superior_financeiro_consulta','2022-03-03 11:09:44',NULL),(492,1,'superior_sistema_backup','2022-03-03 11:09:44',NULL),(493,1,'superior_sistema_permissoes','2022-03-03 11:09:44',NULL);
/*!40000 ALTER TABLE `usuariosmenus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `veiculos`
--
DROP TABLE IF EXISTS `veiculos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `veiculos` (
`idveiculos` int(11) NOT NULL AUTO_INCREMENT,
`modelo` varchar(150) DEFAULT NULL,
`fabricante` varchar(100) DEFAULT NULL,
`tabelafipe` double DEFAULT NULL,
`depreciacao` double DEFAULT NULL,
`porte` varchar(45) DEFAULT NULL,
`categoria` varchar(45) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idveiculos`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `veiculos`
--
LOCK TABLES `veiculos` WRITE;
/*!40000 ALTER TABLE `veiculos` DISABLE KEYS */;
/*!40000 ALTER TABLE `veiculos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `veiculoscustos`
--
DROP TABLE IF EXISTS `veiculoscustos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `veiculoscustos` (
`idveiculoscustos` int(11) NOT NULL AUTO_INCREMENT,
`placa` varchar(45) DEFAULT NULL,
`descricao` varchar(100) DEFAULT NULL,
`custo` double DEFAULT NULL,
`data` datetime DEFAULT NULL,
`observacao` varchar(255) DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idveiculoscustos`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `veiculoscustos`
--
LOCK TABLES `veiculoscustos` WRITE;
/*!40000 ALTER TABLE `veiculoscustos` DISABLE KEYS */;
/*!40000 ALTER TABLE `veiculoscustos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `veiculosdetalhes`
--
DROP TABLE IF EXISTS `veiculosdetalhes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `veiculosdetalhes` (
`idveiculosdetalhes` int(11) NOT NULL AUTO_INCREMENT,
`idestoque` int(11) DEFAULT NULL,
`idfornecedores` int(11) DEFAULT NULL,
`placa` varchar(45) DEFAULT NULL,
`renavam` int(11) DEFAULT NULL,
`cor` varchar(45) DEFAULT NULL,
`quilometragem` double DEFAULT NULL,
`chassis` varchar(45) DEFAULT NULL,
`situacao` varchar(45) DEFAULT NULL,
`vidros` tinyint(4) DEFAULT NULL,
`travas` tinyint(4) DEFAULT NULL,
`ar` tinyint(4) DEFAULT NULL,
`som` tinyint(4) DEFAULT NULL,
`airbag` tinyint(4) DEFAULT NULL,
`alarme` tinyint(4) DEFAULT NULL,
`abs` tinyint(4) DEFAULT NULL,
`regvolante` tinyint(4) DEFAULT NULL,
`sensorre` tinyint(4) DEFAULT NULL,
`camerare` tinyint(4) DEFAULT NULL,
`funilaria` tinyint(4) DEFAULT NULL,
`pintura` tinyint(4) DEFAULT NULL,
`motor` tinyint(4) DEFAULT NULL,
`cambio` tinyint(4) DEFAULT NULL,
`suspensao` tinyint(4) DEFAULT NULL,
`freios` tinyint(4) DEFAULT NULL,
`pneus` tinyint(4) DEFAULT NULL,
`direcao` tinyint(4) DEFAULT NULL,
`eletrica` tinyint(4) DEFAULT NULL,
`valorcompra` double DEFAULT NULL,
`valorvenda` double DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idveiculosdetalhes`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `veiculosdetalhes`
--
LOCK TABLES `veiculosdetalhes` WRITE;
/*!40000 ALTER TABLE `veiculosdetalhes` DISABLE KEYS */;
/*!40000 ALTER TABLE `veiculosdetalhes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `visitas`
--
DROP TABLE IF EXISTS `visitas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `visitas` (
`idvisitas` int(11) NOT NULL AUTO_INCREMENT,
`nome` varchar(150) DEFAULT NULL,
`celular` varchar(45) DEFAULT NULL,
`datavisita` datetime DEFAULT NULL,
`idusuarios` int(11) DEFAULT NULL,
`idresultadosvisitas` int(11) DEFAULT NULL,
`placa` varchar(45) DEFAULT NULL,
`interesse` int(11) DEFAULT NULL,
`resumo` longtext DEFAULT NULL,
`dataretorno` datetime DEFAULT NULL,
`insert_date` datetime DEFAULT current_timestamp(),
`update_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (`idvisitas`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `visitas`
--
LOCK TABLES `visitas` WRITE;
/*!40000 ALTER TABLE `visitas` DISABLE KEYS */;
/*!40000 ALTER TABLE `visitas` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-03-03 13:42:03