-- MySQL dump 10.13 Distrib 8.0.23, for Win64 (x86_64) -- -- Host: localhost Database: mestre -- ------------------------------------------------------ -- Server version 8.0.23 /*!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 */; CREATE SCHEMA IF NOT EXISTS mestre; USE mestre; -- -- Table structure for table `mestre_autorizacaousuarioempresamestre` -- DROP TABLE IF EXISTS `mestre_autorizacaousuarioempresamestre`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mestre_autorizacaousuarioempresamestre` ( `Id` bigint NOT NULL AUTO_INCREMENT, `Caminho` varchar(200) NOT NULL DEFAULT '', `EmpresaMestreId` int NOT NULL, `UsuarioMestreId` int NOT NULL, `PodeConsultar` bit(1) NOT NULL DEFAULT b'0', `PodeAdicionar` bit(1) NOT NULL DEFAULT b'0', `PodeAtualizar` bit(1) NOT NULL DEFAULT b'0', `PodeExcluir` bit(1) NOT NULL DEFAULT b'0', PRIMARY KEY (`Id`), UNIQUE KEY `AutorizacaoUsuarioEmpresaMestre_Caminho_EmpresaId_UsuarioId_uih` (`Caminho`,`EmpresaMestreId`,`UsuarioMestreId`), KEY `AutorizacaoUsuarioEmpresaMestre_EmpresaMestreId_fkh` (`EmpresaMestreId`), KEY `AutorizacaoUsuarioEmpresaMestre_UsuarioMestreId_fkh` (`UsuarioMestreId`), CONSTRAINT `AutorizacaoUsuarioEmpresaMestre_EmpresaMestreId_fkh` FOREIGN KEY (`EmpresaMestreId`) REFERENCES `mestre_empresamestre` (`Id`), CONSTRAINT `AutorizacaoUsuarioEmpresaMestre_UsuarioMestreId_fkh` FOREIGN KEY (`UsuarioMestreId`) REFERENCES `mestre_usuariomestre` (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mestre_empresamestre` -- DROP TABLE IF EXISTS `mestre_empresamestre`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mestre_empresamestre` ( `Id` int NOT NULL AUTO_INCREMENT, `GrupoEmpresaMestreId` int NOT NULL, `RazaoSocial` varchar(60) NOT NULL DEFAULT '', `NomeFantasia` varchar(60) DEFAULT NULL, `DataHoraAceiteContrato` datetime DEFAULT NULL, `UsuarioAceiteContrato` int DEFAULT NULL, `Cnpj` varchar(18) NOT NULL DEFAULT '', `Cpf` varchar(14) DEFAULT NULL, `Cnae` varchar(7) DEFAULT NULL, `Ie` varchar(20) DEFAULT NULL, `Im` varchar(20) DEFAULT NULL, `Regime` int NOT NULL DEFAULT '0', `Menu` varchar(50) NOT NULL DEFAULT '', `Skin` varchar(50) NOT NULL DEFAULT '', `Logradouro` varchar(60) NOT NULL DEFAULT '', `Numero` varchar(10) NOT NULL DEFAULT '', `Complemento` varchar(60) DEFAULT NULL, `Bairro` varchar(60) NOT NULL DEFAULT '', `CaixaPostal` varchar(10) DEFAULT NULL, `NumeroCep` varchar(9) NOT NULL DEFAULT '', `CodigoMunicipio` varchar(7) NOT NULL DEFAULT '', `NomeMunicipio` varchar(60) NOT NULL DEFAULT '', `CodigoUf` varchar(2) DEFAULT NULL, `NomeUf` varchar(60) NOT NULL DEFAULT '', `SiglaUf` varchar(2) NOT NULL DEFAULT '', `CodigoPais` varchar(4) DEFAULT NULL, `NomePais` varchar(60) DEFAULT NULL, `TelefonePrincipal` varchar(20) NOT NULL DEFAULT '', `TelefoneSecundario` varchar(20) DEFAULT NULL, `Email` varchar(100) NOT NULL DEFAULT '', `Site` varchar(100) DEFAULT NULL, `NumeroLicencas` int NOT NULL DEFAULT '0', `EstaAtiva` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloEntrada` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloEstoque` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloMdfe` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloNfe` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloNfce` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloNfse` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloPagamento` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloProcedimentoBancario` bit(1) NOT NULL DEFAULT b'0', `PossuiModuloRecebimento` bit(1) NOT NULL DEFAULT b'0', `UsuarioMestreInclusaoId` int NOT NULL, `DataHoraInclusao` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `UsuarioMestreAlteracaoId` int NOT NULL, `DataHoraAlteracao` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), KEY `EmpresaMestre_GrupoEmpresaMestreId_fkh` (`GrupoEmpresaMestreId`), KEY `EmpresaMestre_UsuarioMestreInclusaoId_fkh` (`UsuarioMestreInclusaoId`), KEY `EmpresaMestre_UsuarioMestreAlteracaoId_fkh` (`UsuarioMestreAlteracaoId`), CONSTRAINT `EmpresaMestre_GrupoEmpresaMestreId_fkh` FOREIGN KEY (`GrupoEmpresaMestreId`) REFERENCES `mestre_grupoempresamestre` (`Id`), CONSTRAINT `EmpresaMestre_UsuarioMestreAlteracaoId_fkh` FOREIGN KEY (`UsuarioMestreAlteracaoId`) REFERENCES `mestre_usuariomestre` (`Id`), CONSTRAINT `EmpresaMestre_UsuarioMestreInclusaoId_fkh` FOREIGN KEY (`UsuarioMestreInclusaoId`) REFERENCES `mestre_usuariomestre` (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mestre_grupoempresamestre` -- DROP TABLE IF EXISTS `mestre_grupoempresamestre`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mestre_grupoempresamestre` ( `Id` int NOT NULL AUTO_INCREMENT, `Nome` varchar(50) NOT NULL DEFAULT '', `Bdn` varchar(10) NOT NULL DEFAULT '', `DataHoraInclusao` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `DataHoraAlteracao` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), UNIQUE KEY `GrupoEmpresaMestre_Nome_uih` (`Nome`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mestre_logerromestre` -- DROP TABLE IF EXISTS `mestre_logerromestre`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mestre_logerromestre` ( `Id` bigint NOT NULL AUTO_INCREMENT, `EmpresaId` int NOT NULL DEFAULT '0', `UsuarioId` int NOT NULL DEFAULT '0', `RequestUri` text, `Method` varchar(10) DEFAULT NULL, `Exception` text NOT NULL, `Content` text, `Tipo` text, `Mensagem` text, `DataHora` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mestre_usuarioempresamestre` -- DROP TABLE IF EXISTS `mestre_usuarioempresamestre`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mestre_usuarioempresamestre` ( `Id` int NOT NULL AUTO_INCREMENT, `UsuarioMestreId` int NOT NULL, `EmpresaMestreId` int NOT NULL, `IsAvancado` bit(1) NOT NULL DEFAULT b'0', PRIMARY KEY (`Id`), UNIQUE KEY `UsuarioEmpresaMestre_UsuarioMestreId_EmpresaMestreId_uih` (`UsuarioMestreId`,`EmpresaMestreId`), KEY `UsuarioEmpresaMestre_EmpresaMestreId_fkh` (`EmpresaMestreId`), CONSTRAINT `UsuarioEmpresaMestre_EmpresaMestreId_fkh` FOREIGN KEY (`EmpresaMestreId`) REFERENCES `mestre_empresamestre` (`Id`), CONSTRAINT `UsuarioEmpresaMestre_UsuarioMestreId_fkh` FOREIGN KEY (`UsuarioMestreId`) REFERENCES `mestre_usuariomestre` (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mestre_usuariomestre` -- DROP TABLE IF EXISTS `mestre_usuariomestre`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mestre_usuariomestre` ( `Id` int NOT NULL AUTO_INCREMENT, `NomeCompleto` varchar(100) NOT NULL DEFAULT '', `Apelido` varchar(20) NOT NULL DEFAULT '', `Login` varchar(100) NOT NULL DEFAULT '', `HashSenha` text, `EstaAtivo` bit(1) NOT NULL DEFAULT b'0', `IsAdministrador` bit(1) NOT NULL DEFAULT b'0', `DataHoraInclusao` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `DataHoraAlteracao` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `TokenAlteracaoSenha` char(36) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mestre_usuariotoken` -- DROP TABLE IF EXISTS `mestre_usuariotoken`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mestre_usuariotoken` ( `Id` bigint NOT NULL AUTO_INCREMENT, `UsuarioId` int NOT NULL DEFAULT '0', `ClienteId` varchar(100) NOT NULL DEFAULT '', `Token` char(36) NOT NULL, `EstaEmUso` bit(1) NOT NULL DEFAULT b'0', `DataHoraUltimoAcesso` datetime DEFAULT NULL, `UserAgent` text, `UserHostAddress` varchar(100) DEFAULT NULL, `UserHostName` text, `UserUuid` varchar(36) DEFAULT NULL, PRIMARY KEY (`Id`), UNIQUE KEY `UsuarioToken_Token_uih` (`Token`), KEY `UsuarioToken_UsuarioId_idh` (`UsuarioId`), KEY `UsuarioToken_ClienteId_idh` (`ClienteId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `metadados_versao` -- DROP TABLE IF EXISTS `metadados_versao`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `metadados_versao` ( `Id` int NOT NULL AUTO_INCREMENT, `Modelo` varchar(50) NOT NULL DEFAULT '', `Numero` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`Id`), UNIQUE KEY `Versao_Modelo_uih` (`Modelo`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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 2021-02-22 11:46:07