-- MySQL dump 10.13  Distrib 8.0.29, for Linux (x86_64)
--
-- Host: localhost    Database: gnm_producao2
-- ------------------------------------------------------
-- Server version	8.0.30-0ubuntu0.20.04.2

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `CAD_ACOMPANHAMENTO`
--

DROP TABLE IF EXISTS `CAD_ACOMPANHAMENTO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_ACOMPANHAMENTO` (
  `ID_ACOMPANHAMENTO` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROPOSTA` int DEFAULT NULL,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  `DESCRICAO` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TIPO_INTERACAO` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_ACOMPANHAMENTO`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_ANEXOS_LOTE`
--

DROP TABLE IF EXISTS `CAD_ANEXOS_LOTE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_ANEXOS_LOTE` (
  `ID_ANEXO_LOTE` int NOT NULL AUTO_INCREMENT,
  `FK_ID_LOTE` int DEFAULT NULL,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `NOME_ARQUIVO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CAMINHO` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  `NOME_ALEATORIO` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_ANEXO_LOTE`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_ANEXOS_PLANO`
--

DROP TABLE IF EXISTS `CAD_ANEXOS_PLANO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_ANEXOS_PLANO` (
  `ID_ANEXO_PLANO` int NOT NULL AUTO_INCREMENT,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `CAMINHO` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  `NOME_ALEATORIO` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NOME_ARQUIVO` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_ANEXO_PLANO`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_ANEXOS_PROPOSTA`
--

DROP TABLE IF EXISTS `CAD_ANEXOS_PROPOSTA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_ANEXOS_PROPOSTA` (
  `ID_ANEXO_PROPOSTA` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROPOSTA` int DEFAULT NULL,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `NOME_ARQUIVO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CAMINHO` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  `NOME_ALEATORIO` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_ANEXO_PROPOSTA`)
) ENGINE=InnoDB AUTO_INCREMENT=1277 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_CATEGORIA_REPRESENTANTE`
--

DROP TABLE IF EXISTS `CAD_CATEGORIA_REPRESENTANTE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_CATEGORIA_REPRESENTANTE` (
  `ID_CATEGORIA_REPRESENTANTE` int NOT NULL AUTO_INCREMENT,
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DESCRICAO_CATEGORIA` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `PERCENTUAL_COMISSAO` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_CATEGORIA_REPRESENTANTE`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_EQUIPE`
--

DROP TABLE IF EXISTS `CAD_EQUIPE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_EQUIPE` (
  `ID_EQUIPE` int NOT NULL AUTO_INCREMENT,
  `FK_ID_REPRESENTANTE` int DEFAULT NULL,
  `NOME_EQUIPE` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  `REPRESENTANTE_PREMIADOS` int DEFAULT NULL,
  PRIMARY KEY (`ID_EQUIPE`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_LICENCA_SISTEMA`
--

DROP TABLE IF EXISTS `CAD_LICENCA_SISTEMA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_LICENCA_SISTEMA` (
  `ID_LICENCA` int NOT NULL AUTO_INCREMENT,
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DESCRICAO_LICENCA` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `VALOR_LICENCA` decimal(15,2) DEFAULT NULL,
  `PERCENTUAL_COMISSAO_AFILIADO` varchar(5) NOT NULL,
  PRIMARY KEY (`ID_LICENCA`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_META`
--

DROP TABLE IF EXISTS `CAD_META`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_META` (
  `ID_META` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROVEDOR` int DEFAULT NULL,
  `PERIODO_REFERENTE` char(7) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'Número do mês. 01 - Janeiro,  02 - Fevereiro e assim sucessivamente.',
  `QUANTIDADE_VENDAS` int DEFAULT NULL,
  `VALOR_PREMIACAO` decimal(15,2) DEFAULT NULL,
  `META_RESTRITA` char(1) DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  `SITUACAO_META` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DESCRICAO_META` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_META`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_META_EQUIPE`
--

DROP TABLE IF EXISTS `CAD_META_EQUIPE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_META_EQUIPE` (
  `ID_META_EQUIPE` int NOT NULL AUTO_INCREMENT,
  `FK_ID_META` int DEFAULT NULL,
  `FK_ID_EQUIPE` int DEFAULT NULL,
  PRIMARY KEY (`ID_META_EQUIPE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_META_REPRESENTANTE`
--

DROP TABLE IF EXISTS `CAD_META_REPRESENTANTE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_META_REPRESENTANTE` (
  `ID_META_REPRESENTANTE` int NOT NULL AUTO_INCREMENT,
  `FK_ID_META` int DEFAULT NULL,
  `FK_ID_REPRESENTANTE` int DEFAULT NULL,
  PRIMARY KEY (`ID_META_REPRESENTANTE`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_PESSOA`
--

DROP TABLE IF EXISTS `CAD_PESSOA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_PESSOA` (
  `ID_PESSOA` int NOT NULL AUTO_INCREMENT,
  `FK_ID_EMPRESA` int DEFAULT NULL,
  `TIPO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `RG_IE` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `RAZAO_SOCIAL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NOME_FANTASIA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CPF_CNPJ` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `GENERO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NASCIMENTO` date DEFAULT NULL,
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CEP` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `LOGRADOURO` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NUMERO` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `COMPLEMENTO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `BAIRRO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CIDADE` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `UF` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `IBGE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `GEOCODE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `EMAIL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TELEFONE01` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TELEFONE02` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `CLIENTE` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `FORNECEDOR` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `FUNCIONARIO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NACIONALIDADE` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ESTADO_CIVIL` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `PROFISSAO` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `SENHA_CLIENTE` varchar(300) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_PESSOA`)
) ENGINE=MyISAM AUTO_INCREMENT=1106 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_PLANO`
--

DROP TABLE IF EXISTS `CAD_PLANO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_PLANO` (
  `ID_PLANO` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROVEDOR` int DEFAULT NULL,
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DESCRICAO_PLANO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `VALOR` decimal(15,2) DEFAULT NULL,
  `TIPO_PLANO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DOWNLOAD` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `UPLOAD` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `FRANQUIA` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'D - DADOS | I - ILIMITADO',
  `TIPO_WIFI` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'P - PLUS | DB - DUAL BAND | M - MESH | C - COMODATO | G - GRATIS | V - VENDIDO',
  `TIPO_TAXA` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'I - INSTALACAO | A - ADESAO  | W - WIFI | G - GRATIS | P - PAGO',
  `TIPO_COMISSAO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TIPO_PLANO_LOCAL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `PLANO_VELOCIDADE` int DEFAULT NULL,
  `VALOR_ENVIO_CORREIO` decimal(15,2) DEFAULT NULL,
  `VALOR_COMISSAO` decimal(15,2) DEFAULT NULL,
  `VALOR_BONUS_DCC` decimal(15,2) DEFAULT NULL,
  `VALOR_DESCONTO_DCC` decimal(15,2) DEFAULT NULL,
  `VALOR_TAXA_INSTALACAO` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`ID_PLANO`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_PROPOSTAS`
--

DROP TABLE IF EXISTS `CAD_PROPOSTAS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_PROPOSTAS` (
  `ID_PROPOSTA` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROVEDOR` int DEFAULT NULL,
  `FK_ID_REPRESENTANTE` int DEFAULT NULL,
  `FK_ID_PLANO` int DEFAULT NULL,
  `NOME` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CEP` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `LOGRADOURO` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NUMERO` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `COMPLEMENTO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `BAIRRO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CIDADE` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `UF` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `IBGE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `GEOCODE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `EMAIL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TELEFONE` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TELEFONE_2` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `SITUACAO_PROPOSTA` char(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'AA - AGUARDANDO ANALISE | AV - AGUARDANDO VIABILIDADE | AI - AGUARDANDO INSTALACAO | N - NEGOCIACAO',
  `DATA_CADASTRO` date DEFAULT NULL,
  `TIPO_COBRANCA` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'D - DIGITAL | C - CORREIOS',
  `TIPO_CONTRATACAO` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'F - FIDELIDADE | SF - SEM FIDELIDADE',
  `TIPO_PAGAMENTO` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'P - PARCELADO | AV - A VISTA',
  `FORMA_PAGAMENTO` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'B - BOLETO | CD - CARTAO DE CREDITO  | D - DEBITO EM CONTA',
  `TIPO_PESSOA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CPF_CNPJ` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `RG_CNH` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ORGAO_EXPEDITOR` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_NASCIMENTO` date DEFAULT NULL,
  `PROFISSAO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ESTADO_CIVIL` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `COORDENADAS` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NOME_MAE` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NOME_PAI` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DIA_VENCIMENTO` int DEFAULT NULL,
  PRIMARY KEY (`ID_PROPOSTA`)
) ENGINE=InnoDB AUTO_INCREMENT=799 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_PROVEDOR`
--

DROP TABLE IF EXISTS `CAD_PROVEDOR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_PROVEDOR` (
  `ID_PROVEDOR` int NOT NULL AUTO_INCREMENT,
  `CNPJ` varchar(21) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `RAZAO_SOCIAL` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NOME_FANTASIA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CEP` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `LOGRADOURO` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NUMERO` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `COMPLEMENTO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `BAIRRO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CIDADE` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `UF` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `IBGE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `GEOCODE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `EMAIL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TELEFONE` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TIPO_COMISSAO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT 'P',
  `PERCENTUAL_COMISSAO` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `VALOR_COMISSAO` decimal(15,2) DEFAULT NULL,
  `LIMITE_DIAS_ESTORNO` int DEFAULT NULL,
  `USUARIO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `SENHA` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TOKEN` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_PROVEDOR`)
) ENGINE=InnoDB AUTO_INCREMENT=1137 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_REPRESENTANTE`
--

DROP TABLE IF EXISTS `CAD_REPRESENTANTE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_REPRESENTANTE` (
  `ID_REPRESENTANTE` int NOT NULL AUTO_INCREMENT,
  `FK_ID_CATEGORIA` int DEFAULT NULL,
  `FK_ID_LICENCA` int DEFAULT NULL,
  `FK_ID_REPRESENTANTE_INDICADO` int NOT NULL,
  `FK_ID_EQUIPE` int NOT NULL,
  `TIPO_PESSOA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CPF_CNPJ` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `RAZAO_SOCIAL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NOME_FANTASIA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CEP` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `LOGRADOURO` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `NUMERO` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `COMPLEMENTO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `BAIRRO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CIDADE` varchar(90) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `UF` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `IBGE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `GEOCODE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `USUARIO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `SENHA` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `EMAIL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `TELEFONE` varchar(14) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `BANCO_REPRESENTANTE` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `AGENCIA_REPRESENTANTE` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CONTA_REPRESENTANTE` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `APROVADO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CHAVE_PIX` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  PRIMARY KEY (`ID_REPRESENTANTE`)
) ENGINE=MyISAM AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CAD_VIABILIDADE_PROVEDOR`
--

DROP TABLE IF EXISTS `CAD_VIABILIDADE_PROVEDOR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CAD_VIABILIDADE_PROVEDOR` (
  `ID_VIABILIDADE_PROVEDOR` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROVEDOR` int DEFAULT NULL,
  `CEP_VIABILIDADE` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `BAIRRO_VIABILIDADE` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_VIABILIDADE_PROVEDOR`)
) ENGINE=InnoDB AUTO_INCREMENT=115333 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_AGENDA`
--

DROP TABLE IF EXISTS `CON_AGENDA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_AGENDA` (
  `ID_AGENDA` int NOT NULL AUTO_INCREMENT,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `TITULO` varchar(45) DEFAULT NULL,
  `DESCRICAO` varchar(200) DEFAULT NULL,
  `INICIO` datetime DEFAULT NULL,
  `FIM` datetime DEFAULT NULL,
  `COR` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`ID_AGENDA`)
) ENGINE=MyISAM AUTO_INCREMENT=1014 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_MENU`
--

DROP TABLE IF EXISTS `CON_MENU`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_MENU` (
  `ID_MENU` int NOT NULL AUTO_INCREMENT,
  `DESCRICAO` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `LINK` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `ICONE` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `PESO` int NOT NULL,
  PRIMARY KEY (`ID_MENU`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_METODO`
--

DROP TABLE IF EXISTS `CON_METODO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_METODO` (
  `ID_METODO` int NOT NULL AUTO_INCREMENT,
  `IDENTIFICACAO` varchar(90) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'Caminho pós base_url()',
  `FK_ID_MENU` int DEFAULT NULL COMMENT 'Menu onde a classe esta',
  `FK_ID_SUBMENU` int DEFAULT NULL COMMENT 'Sub menu onde a classe esta',
  PRIMARY KEY (`ID_METODO`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_PERFIL`
--

DROP TABLE IF EXISTS `CON_PERFIL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_PERFIL` (
  `ID_PERFIL` int NOT NULL AUTO_INCREMENT,
  `DESCRICAO` varchar(80) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA` date DEFAULT NULL,
  PRIMARY KEY (`ID_PERFIL`)
) ENGINE=MyISAM AUTO_INCREMENT=1023 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_PERFIL_PERMISSAO`
--

DROP TABLE IF EXISTS `CON_PERFIL_PERMISSAO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_PERFIL_PERMISSAO` (
  `ID_PERMISSAO` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PERFIL` int DEFAULT NULL,
  `FK_ID_METODO` int DEFAULT NULL,
  PRIMARY KEY (`ID_PERMISSAO`)
) ENGINE=MyISAM AUTO_INCREMENT=869 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_PERMISSAO`
--

DROP TABLE IF EXISTS `CON_PERMISSAO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_PERMISSAO` (
  `ID_PERMISSAO` int NOT NULL AUTO_INCREMENT,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `FK_ID_METODO` int DEFAULT NULL,
  PRIMARY KEY (`ID_PERMISSAO`)
) ENGINE=MyISAM AUTO_INCREMENT=3583 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_SUBMENU`
--

DROP TABLE IF EXISTS `CON_SUBMENU`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_SUBMENU` (
  `ID_SUBMENU` int NOT NULL AUTO_INCREMENT,
  `FK_ID_MENU` int DEFAULT NULL,
  `DESCRICAO` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `LINK` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `ICONE` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`ID_SUBMENU`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CON_USUARIO`
--

DROP TABLE IF EXISTS `CON_USUARIO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `CON_USUARIO` (
  `ID_USUARIO` int NOT NULL AUTO_INCREMENT,
  `NOME` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `USUARIO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `SENHA` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `EMAIL` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `TELEFONE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `URL_FOTO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT 'https://res.cloudinary.com/dvtoppzy5/image/upload/v1574117358/user5-128x128_jascdc.png',
  `FK_ID_REPRESENTANTE` int DEFAULT NULL,
  `TOKEN` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_USUARIO`)
) ENGINE=MyISAM AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_BANCO`
--

DROP TABLE IF EXISTS `FINAN_BANCO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_BANCO` (
  `ID_BANCO` int NOT NULL AUTO_INCREMENT COMMENT 'ID DO BANCO',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE DE LOG',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `NOME` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'APELIDO DA CONTA NOME DADO PARA FACILITAR A IDENTIFICACAO PELO USUARIO',
  `BANCO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'NOME DO BANCO',
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'A-ATIVO I-INATIVO',
  `AGENCIA` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'AGENCIA',
  `AGENCIA_DV` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DIGITO VERIFICADOR AGENCIA',
  `CONTA` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'NUMERO DA CONTA',
  `CONTA_DV` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DIGITO VERIFICADOR DA CONTA',
  PRIMARY KEY (`ID_BANCO`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci COMMENT='TABELA DE BANCOS INTITUICOES FINANCEIRAS	';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_CENTRO_CUSTO`
--

DROP TABLE IF EXISTS `FINAN_CENTRO_CUSTO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_CENTRO_CUSTO` (
  `ID_CENTRO_CUSTO` int NOT NULL AUTO_INCREMENT COMMENT 'ID DO CENTRO DE CUSTO',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `DESCRICAO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DESCRICAO DO CENTRO DE CUSTO',
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'A-ATIVO I-INATIVO',
  PRIMARY KEY (`ID_CENTRO_CUSTO`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_CENTRO_CUSTO_RECEBER`
--

DROP TABLE IF EXISTS `FINAN_CENTRO_CUSTO_RECEBER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_CENTRO_CUSTO_RECEBER` (
  `ID_CENTRO_CUSTO` int NOT NULL AUTO_INCREMENT COMMENT 'ID DO CENTRO DE CUSTO',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `DESCRICAO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DESCRICAO DO CENTRO DE CUSTO',
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'A-ATIVO I-INATIVO',
  PRIMARY KEY (`ID_CENTRO_CUSTO`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_COMISSAO`
--

DROP TABLE IF EXISTS `FINAN_COMISSAO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_COMISSAO` (
  `ID_COMISSAO` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROPOSTA` int DEFAULT NULL,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `FK_ID_REPRESENTANTE` int NOT NULL,
  `FK_ID_LOTE_PAGAMENTO` int DEFAULT NULL,
  `SITUACAO_COMISSAO` char(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_CADASTRO` date DEFAULT NULL,
  `DATA_PREVISTA` date DEFAULT NULL,
  `DATA_PAGAMENTO` date DEFAULT NULL,
  `VALOR_PLANO` decimal(15,2) DEFAULT NULL,
  `VALOR_COMISSAO` decimal(15,2) DEFAULT NULL,
  `OBSERVACAO` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`ID_COMISSAO`)
) ENGINE=MyISAM AUTO_INCREMENT=704 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_CONTA_PAGAR`
--

DROP TABLE IF EXISTS `FINAN_CONTA_PAGAR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_CONTA_PAGAR` (
  `ID_CONTA_PAGAR` int NOT NULL AUTO_INCREMENT COMMENT 'ID DA CONTA PAGAR',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `TIPO_PESSOA` int DEFAULT NULL COMMENT '1-FORNECEDOR / 2-FUNCIONARIO',
  `FK_ID_REPRESENTANTE` int DEFAULT NULL,
  `FK_ID_PESSOA` int DEFAULT NULL COMMENT 'ID DA PESSOA QUE TEM O CREDITO',
  `FK_ID_PLANO_CONTA` int DEFAULT NULL COMMENT 'ID DO PLANO DE CONTA',
  `FK_ID_SUBPLANO_CONTA` int DEFAULT NULL COMMENT 'ID SUBPLANO DE CONTA',
  `FK_ID_CENTRO_CUSTO` int DEFAULT NULL COMMENT 'ID DO CENTRO DE CUSTO',
  `FK_ID_COMISSAO` int DEFAULT NULL,
  `FK_ID_META` int DEFAULT NULL,
  `BANCO` int DEFAULT NULL COMMENT 'ID DO BANCO A SER DEBITADO',
  `FK_ID_MARCADOR` int DEFAULT NULL COMMENT 'ID DO MARCADOR',
  `DATA_EMISSAO` date DEFAULT NULL COMMENT 'DATA DE EMISSAO DA CONTA',
  `NF_NUMERO` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'NUMERO DA NOTA',
  `NF_SERIE` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'SERIE DA NOTA',
  `NF_MODELO` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'MODEO DA NOTA',
  `NF_CHAVE` varchar(44) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'CHAVE DA NF',
  `VALOR_TOTAL` decimal(15,2) DEFAULT NULL,
  `PERIODICIDADE` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'F-FIXA V-VARIAVEL',
  `PARCELAS` int DEFAULT NULL,
  `DESCRICAO` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_CONTA_PAGAR`)
) ENGINE=MyISAM AUTO_INCREMENT=701 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_CONTA_PAGAR_PARCELA`
--

DROP TABLE IF EXISTS `FINAN_CONTA_PAGAR_PARCELA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_CONTA_PAGAR_PARCELA` (
  `ID_CONTA_PAGAR_PARCELA` int NOT NULL AUTO_INCREMENT COMMENT 'ID DA PARCELA',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `FK_ID_CONTA_PAGAR` int DEFAULT NULL COMMENT 'FK ID DA CONTA A PAGAR',
  `FK_ID_COMISSAO` int DEFAULT NULL,
  `FK_ID_META` int DEFAULT NULL,
  `DATA_VENCIMENTO` date DEFAULT NULL COMMENT 'DATA DE VENCIMENTO',
  `DATA_BAIXA` date DEFAULT NULL COMMENT 'DATA DE BAIXA',
  `SITUACAO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'P-PENDENTE\nL-LIQUIDADO\nV-VENCIDO\nC-CANCELADO',
  `PARCELA` int DEFAULT NULL COMMENT 'NUMERO DA PARCELA',
  `VALOR` decimal(15,2) DEFAULT NULL COMMENT 'VALOR ORIGINAL',
  `ENCARGOS` decimal(15,2) DEFAULT NULL COMMENT 'VALOR DO JUROS/MULTA',
  `DESCONTOS` decimal(15,2) DEFAULT NULL COMMENT 'VALOR DO DESCONTO QUANDO HOUVER',
  `VALOR_PAGO` decimal(15,2) DEFAULT NULL COMMENT 'VALOR PAGO',
  `CHEQUE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'NUMERO DO CHEQUE',
  `BOLETO_RECEBIDO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'SE O BOLETO FOI RECEBIDO OU NAO',
  `TIPO_BAIXA` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'TIPO DE BAIXA\n',
  PRIMARY KEY (`ID_CONTA_PAGAR_PARCELA`)
) ENGINE=MyISAM AUTO_INCREMENT=728 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_CONTA_RECEBER`
--

DROP TABLE IF EXISTS `FINAN_CONTA_RECEBER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_CONTA_RECEBER` (
  `ID_CONTA_RECEBER` int NOT NULL AUTO_INCREMENT COMMENT 'ID DA CONTA RECEBER',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `TIPO_PESSOA` int DEFAULT NULL COMMENT '1-FORNECEDOR / 2-FUNCIONARIO',
  `FK_ID_REPRESENTANTE` int DEFAULT NULL,
  `FK_ID_PESSOA` int DEFAULT NULL COMMENT 'ID DA PESSOA QUE TEM O CREDITO',
  `FK_ID_PLANO_CONTA` int DEFAULT NULL COMMENT 'ID DO PLANO DE CONTA',
  `FK_ID_SUBPLANO_CONTA` int DEFAULT NULL COMMENT 'ID SUBPLANO DE CONTA',
  `FK_ID_CENTRO_CUSTO` int DEFAULT NULL COMMENT 'ID DO CENTRO DE CUSTO',
  `FK_ID_COMISSAO` int DEFAULT NULL,
  `FK_ID_PROVEDOR` int DEFAULT NULL,
  `BANCO` int DEFAULT NULL COMMENT 'ID DO BANCO A SER DEBITADO',
  `FK_ID_MARCADOR` int DEFAULT NULL COMMENT 'ID DO MARCADOR',
  `DATA_EMISSAO` date DEFAULT NULL COMMENT 'DATA DE EMISSAO DA CONTA',
  `NF_NUMERO` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'NUMERO DA NOTA',
  `NF_SERIE` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'SERIE DA NOTA',
  `NF_MODELO` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'MODEO DA NOTA',
  `NF_CHAVE` varchar(44) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'CHAVE DA NF',
  `VALOR_TOTAL` decimal(15,2) DEFAULT NULL,
  `PERIODICIDADE` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'F-FIXA V-VARIAVEL',
  `PARCELAS` int DEFAULT NULL,
  `DESCRICAO` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_CONTA_RECEBER`)
) ENGINE=MyISAM AUTO_INCREMENT=596 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_CONTA_RECEBER_PARCELA`
--

DROP TABLE IF EXISTS `FINAN_CONTA_RECEBER_PARCELA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_CONTA_RECEBER_PARCELA` (
  `ID_CONTA_RECEBER_PARCELA` int NOT NULL AUTO_INCREMENT COMMENT 'ID DA PARCELA',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `FK_ID_CONTA_RECEBER` int DEFAULT NULL COMMENT 'FK ID DA CONTA A RECEBER',
  `FK_ID_COMISSAO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_VENCIMENTO` date DEFAULT NULL COMMENT 'DATA DE VENCIMENTO',
  `DATA_BAIXA` date DEFAULT NULL COMMENT 'DATA DE BAIXA',
  `SITUACAO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'P-PENDENTE\nL-LIQUIDADO\nV-VENCIDO\nC-CANCELADO',
  `PARCELA` int DEFAULT NULL COMMENT 'NUMERO DA PARCELA',
  `VALOR` decimal(15,2) DEFAULT NULL COMMENT 'VALOR ORIGINAL',
  `ENCARGOS` decimal(15,2) DEFAULT NULL COMMENT 'VALOR DO JUROS/MULTA',
  `DESCONTOS` decimal(15,2) DEFAULT NULL COMMENT 'VALOR DO DESCONTO QUANDO HOUVER',
  `VALOR_PAGO` decimal(15,2) DEFAULT NULL COMMENT 'VALOR PAGO',
  `CHEQUE` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'NUMERO DO CHEQUE',
  `BOLETO_RECEBIDO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'SE O BOLETO FOI RECEBIDO OU NAO',
  `TIPO_BAIXA` char(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'TIPO DE BAIXA\n',
  PRIMARY KEY (`ID_CONTA_RECEBER_PARCELA`)
) ENGINE=MyISAM AUTO_INCREMENT=722 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_LOTE_PAGAMENTO`
--

DROP TABLE IF EXISTS `FINAN_LOTE_PAGAMENTO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_LOTE_PAGAMENTO` (
  `ID_LOTE_PAGAMENTO` int NOT NULL AUTO_INCREMENT,
  `DESCRICAO_LOTE` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `VALOR_TOTAL_LOTE` decimal(15,2) DEFAULT NULL,
  `DATA_LIBERACAO_LOTE` date DEFAULT NULL,
  `DATA_PAGAMENTO_LOTE` date DEFAULT NULL,
  `SITUACAO_LOTE` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`ID_LOTE_PAGAMENTO`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_MARCADOR`
--

DROP TABLE IF EXISTS `FINAN_MARCADOR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_MARCADOR` (
  `ID_MARCADOR` int NOT NULL AUTO_INCREMENT COMMENT 'ID DO MARCADOR',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `DESCRICAO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DESCRICAO DO MARCADOR',
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'A-ATIVO I-INATIVO',
  PRIMARY KEY (`ID_MARCADOR`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_MARCADOR_RECEBER`
--

DROP TABLE IF EXISTS `FINAN_MARCADOR_RECEBER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_MARCADOR_RECEBER` (
  `ID_MARCADOR` int NOT NULL AUTO_INCREMENT COMMENT 'ID DO MARCADOR',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `DESCRICAO` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DESCRICAO DO MARCADOR',
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'A-ATIVO I-INATIVO',
  PRIMARY KEY (`ID_MARCADOR`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_PLANO_CONTA`
--

DROP TABLE IF EXISTS `FINAN_PLANO_CONTA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_PLANO_CONTA` (
  `ID_PLANO_CONTA` int NOT NULL AUTO_INCREMENT COMMENT 'ID DO PLANO DE CONTA',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `OPERACAO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'D-DEBITO C-CREDITO',
  `DESCRICAO` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DESCRICAO DO PLANO',
  `FK_ID_PLANO_CONTA` int DEFAULT NULL COMMENT 'ID DO PROPRIO PLANO QUANDO FOR SUBPLANO',
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'A-ATIVO I-INATIVO',
  PRIMARY KEY (`ID_PLANO_CONTA`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `FINAN_PLANO_CONTA_RECEBER`
--

DROP TABLE IF EXISTS `FINAN_PLANO_CONTA_RECEBER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `FINAN_PLANO_CONTA_RECEBER` (
  `ID_PLANO_CONTA` int NOT NULL AUTO_INCREMENT COMMENT 'ID DO PLANO DE CONTA',
  `KEYUSER` int DEFAULT NULL COMMENT 'USUARIO CHAVE',
  `FK_ID_EMPRESA` int DEFAULT NULL COMMENT 'ID DA EMPRESA',
  `OPERACAO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'D-DEBITO C-CREDITO',
  `DESCRICAO` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'DESCRICAO DO PLANO',
  `FK_ID_PLANO_CONTA` int DEFAULT NULL COMMENT 'ID DO PROPRIO PLANO QUANDO FOR SUBPLANO',
  `ATIVO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'A-ATIVO I-INATIVO',
  PRIMARY KEY (`ID_PLANO_CONTA`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SYS_ACESS_LOG`
--

DROP TABLE IF EXISTS `SYS_ACESS_LOG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SYS_ACESS_LOG` (
  `ID_LOG` int NOT NULL AUTO_INCREMENT,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `DATA` datetime DEFAULT NULL,
  PRIMARY KEY (`ID_LOG`)
) ENGINE=MyISAM AUTO_INCREMENT=4052 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SYS_CONFIRMACAO_TERMO`
--

DROP TABLE IF EXISTS `SYS_CONFIRMACAO_TERMO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SYS_CONFIRMACAO_TERMO` (
  `ID_CONFIRMACAO_TERMO` int NOT NULL AUTO_INCREMENT,
  `DATA_CONFIRMACAO` datetime DEFAULT NULL,
  `IP_CONFIRMACAO` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `CONFIRMADO` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL COMMENT 'S - SIM | N - NAO',
  PRIMARY KEY (`ID_CONFIRMACAO_TERMO`)
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SYS_LOG`
--

DROP TABLE IF EXISTS `SYS_LOG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SYS_LOG` (
  `ID_LOG` int NOT NULL AUTO_INCREMENT,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `COMANDO` varchar(100) DEFAULT NULL,
  `DATA` datetime DEFAULT NULL,
  `TABELA` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ID_LOG`)
) ENGINE=MyISAM AUTO_INCREMENT=2095 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SYS_LOG_STATUS_PROPOSTA`
--

DROP TABLE IF EXISTS `SYS_LOG_STATUS_PROPOSTA`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `SYS_LOG_STATUS_PROPOSTA` (
  `ID_LOG_STATUS_PROPOSTA` int NOT NULL AUTO_INCREMENT,
  `FK_ID_PROPOSTA` int DEFAULT NULL,
  `FK_ID_USUARIO` int DEFAULT NULL,
  `SITUACAO_PROPOSTA` char(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `DATA_ALTERACAO` date DEFAULT NULL,
  PRIMARY KEY (`ID_LOG_STATUS_PROPOSTA`)
) ENGINE=InnoDB AUTO_INCREMENT=2914 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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-09-13 10:33:46
