CREATE TABLE `agenda` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Modalidade` int(11) NOT NULL,
  `Categoria` int(11) NOT NULL,
  `Evento` int(11) NOT NULL,
  `Cliente` int(11) NOT NULL,
  `Titulo` varchar(150) NOT NULL,
  `Descricao` longtext NOT NULL,
  `Data` varchar(10) NOT NULL,
  `Horario` varchar(5) NOT NULL,
  `Dia` int(2) NOT NULL,
  `Mes` varchar(2) NOT NULL,
  `Ano` int(4) NOT NULL,
  `Horas` int(2) NOT NULL,
  `Minutos` int(2) NOT NULL,
  `Usuario` varchar(1) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `Operador` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `agenda` VALUES ('2', '3', '0', '0', '29', '12', '', '', '01/8/2023', '', '0', '', '0', '0', '0', '', '2023-08-31 10:17:08', '16');
CREATE TABLE `agendacategorias` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Descricao` varchar(70) NOT NULL,
  `Cor` varchar(15) NOT NULL,
  `Fonte` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `agendacategorias` VALUES ('1', '1', 'Comercial', '#FF1065', '#FFFFFF');
CREATE TABLE `agendacliente` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Filial` int(11) NOT NULL,
  `Status` int(5) NOT NULL,
  `Cliente` int(11) NOT NULL,
  `Assunto` varchar(300) NOT NULL,
  `Data` varchar(10) NOT NULL,
  `Hora` varchar(5) NOT NULL,
  `Local` varchar(300) NOT NULL,
  `Operador` int(11) NOT NULL,
  `Atendente` int(11) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `DataAlteracao` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `agendacolocadores` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Modalidade` int(11) NOT NULL,
  `Colocador` int(11) NOT NULL,
  `Evento` int(11) NOT NULL,
  `Cliente` int(11) NOT NULL,
  `Titulo` varchar(150) NOT NULL,
  `Descricao` longtext NOT NULL,
  `Ambiente` longtext NOT NULL,
  `Valor` float(8,2) NOT NULL,
  `Data` varchar(10) NOT NULL,
  `Horario` varchar(5) NOT NULL,
  `Dia` varchar(2) NOT NULL,
  `Mes` varchar(2) NOT NULL,
  `Ano` varchar(4) NOT NULL,
  `Horas` varchar(2) NOT NULL,
  `Minutos` varchar(2) NOT NULL,
  `Usuario` varchar(1) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `Operador` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `agendamodalidade` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Descricao` varchar(70) NOT NULL,
  `Cor` varchar(15) NOT NULL,
  `Fonte` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `agendamodalidade` VALUES ('1', '1', 'Entrega', '#28FF65', '#000000');
CREATE TABLE `atendimentos` (
  `Codigo` int(11) NOT NULL,
  `Filial` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Cliente` int(11) NOT NULL,
  `Atendimento` text NOT NULL,
  `Operador` int(11) NOT NULL,
  `Departamento` int(11) NOT NULL,
  `DataHora` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `bancos` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `CodigoBanco` int(11) NOT NULL,
  `Banco` varchar(70) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `bancos` VALUES ('1', '1', '341', 'Itaú');
INSERT INTO `bancos` VALUES ('2', '2', '1', 'banco teste');
CREATE TABLE `bloqueioacesso` (
  `id` int(11) NOT NULL,
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Status` int(2) NOT NULL,
  `Inicio` varchar(5) COLLATE latin1_general_ci NOT NULL,
  `Fim` varchar(5) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO `bloqueioacesso` VALUES ('1', '1', '1', '1', '06:00', '19:00');
INSERT INTO `bloqueioacesso` VALUES ('2', '1', '2', '0', '06:00', '19:00');
INSERT INTO `bloqueioacesso` VALUES ('3', '1', '3', '0', '06:00', '19:00');
CREATE TABLE `cargos` (
  `CodCargo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Cargo` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `chamados` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Usuario` int(11) NOT NULL,
  `Pedido` int(11) NOT NULL,
  `Departamento` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `UsuarioResposta` int(11) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `Data` varchar(10) NOT NULL,
  `DataRegistro` varchar(10) NOT NULL,
  `Titulo` varchar(70) NOT NULL,
  `Descricao` longtext NOT NULL,
  `DataConclusao` varchar(30) NOT NULL,
  `PrazoConclusao` int(2) NOT NULL,
  `Atraso` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `chamados` VALUES ('1', '2', '3', '11', '7', '0', '0', '2022-10-18 14:39:22', '18/10/2022', '2022-10-18', 'MEDI&Ccedil;&Atilde;O PEDIDO 11', '\n	Montagem: 19/10/2011<br />\n	Medi&ccedil;&atilde;o: 19/11/2022<br />\n	Periodo: MANHÃ<br />\n	Nome: TESTE AGENDA<br />\n	Telefone: <br />\n	Celular: <br />\n	Endere&ccedil;o: RUA TESTE<br />\n	Observa&ccedil;&otilde;es: ', '', '0', '0');
CREATE TABLE `chamadosatendimentos` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Chamado` int(11) NOT NULL,
  `Visualizado` int(11) NOT NULL,
  `Leitor` int(11) NOT NULL,
  `Usuario` int(11) NOT NULL,
  `Descricao` longtext NOT NULL,
  `DataCadastro` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `chamadosatendimentos` VALUES ('1', '3', '1', '0', '0', '16', '', '2023-08-29 11:51:08');
INSERT INTO `chamadosatendimentos` VALUES ('2', '3', '1', '0', '0', '16', 'Resolvido', '2023-08-29 11:51:17');
INSERT INTO `chamadosatendimentos` VALUES ('3', '3', '1', '0', '0', '16', '', '2023-08-29 15:40:36');
CREATE TABLE `chamadosstatus` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Descricao` varchar(70) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `chamadosstatus` VALUES ('0', '0', 'PENDENTE');
INSERT INTO `chamadosstatus` VALUES ('1', '0', 'ANDAMENTO');
INSERT INTO `chamadosstatus` VALUES ('2', '0', 'CONCLUÍDO');
CREATE TABLE `cheques` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Usuario` int(11) NOT NULL,
  `Financeiro` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Pedido` int(11) NOT NULL,
  `DataPagamento` varchar(10) NOT NULL,
  `DataVencimento` varchar(10) NOT NULL,
  `DataVenda` varchar(10) NOT NULL,
  `Valor` float(8,2) NOT NULL,
  `Dia` int(2) NOT NULL,
  `Mes` int(2) NOT NULL,
  `Ano` int(4) NOT NULL,
  `Banco` varchar(70) NOT NULL,
  `CodigoBanco` varchar(30) NOT NULL,
  `Agencia` varchar(30) NOT NULL,
  `Conta` varchar(30) NOT NULL,
  `Serie` varchar(30) NOT NULL,
  `NumeroCheque` varchar(30) NOT NULL,
  `Titular` varchar(70) NOT NULL,
  `Repasse` varchar(70) NOT NULL,
  `CPF` varchar(30) NOT NULL,
  `Observacoes` longtext NOT NULL,
  `DataCadastro` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `clientes` (
  `Codigo` int(10) NOT NULL,
  `Construtora` int(1) NOT NULL,
  `Filial` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Modalidade` int(5) NOT NULL,
  `Status` int(1) NOT NULL,
  `Nome` varchar(150) NOT NULL,
  `CPF` varchar(14) NOT NULL,
  `RazaoSocial` varchar(300) NOT NULL,
  `NomeFantasia` varchar(150) NOT NULL,
  `CNPJ` varchar(18) NOT NULL,
  `IE` varchar(14) NOT NULL,
  `DataNascimento` varchar(10) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `EmailNFe` varchar(100) NOT NULL,
  `Endereco` varchar(150) NOT NULL,
  `Numero` varchar(10) NOT NULL,
  `Complemento` varchar(30) NOT NULL,
  `Bairro` varchar(100) NOT NULL,
  `Cidade` varchar(100) NOT NULL,
  `UF` varchar(2) NOT NULL,
  `CEP` varchar(10) NOT NULL,
  `Telefone01` varchar(14) NOT NULL,
  `Telefone02` varchar(14) NOT NULL,
  `Telefone03` varchar(14) NOT NULL,
  `Celular01` varchar(15) NOT NULL,
  `Celular02` varchar(15) NOT NULL,
  `Operadora01` varchar(15) NOT NULL,
  `Operadora02` varchar(15) NOT NULL,
  `Referencia` varchar(500) NOT NULL,
  `OBS` varchar(500) NOT NULL,
  `Operador` int(5) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `DataModificacao` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `clientes` VALUES ('1', '0', '0', '2', '1', '1', 'FLÁVIO TESTE', '', '', 'FLÁVIO TESTE', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '3', '2022-05-31 11:08:06', '2022-05-31 11:08:06');
INSERT INTO `clientes` VALUES ('2', '0', '0', '2', '1', '1', 'teste2', '', '', 'teste2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '3', '2022-06-06 14:39:56', '2022-06-06 14:39:56');
INSERT INTO `clientes` VALUES ('3', '0', '0', '1', '1', '1', 'Flávio Roberto Deda Flávio', '788.275.232-00', '', 'Flávio Roberto Deda Flávio', '', '', '', 'flavio@vegason.com.br', '', 'Avenida Winston Churchill', '1527', 'Sala 08', 'Capão Raso', 'Curitiba', 'PR', '81130000', '41999121863', '', '', '', '', '', '', '', '', '2', '2022-06-16 15:43:23', '2022-06-16 15:43:23');
INSERT INTO `clientes` VALUES ('4', '0', '0', '2', '1', '1', 'TESTE 18OUTUBRO', '014.949.949-94', '', 'TESTE 18OUTUBRO', '', '6666666666', '12/03/2002', 'TESTE1810@GMAIL', '', 'Avenida Presidente Wenceslau Braz', '688', '', 'Parolin', 'Curitiba', 'PR', '81030030', '(41) 3333-3333', '(41) 2222-2222', '', '', '', '', '', '', 'CADASTRO DIA 18 OUT 22', '3', '2022-10-18 11:26:05', '2022-10-18 11:26:05');
INSERT INTO `clientes` VALUES ('5', '0', '0', '0', '1', '1', 'cliente teste 1', '', '', 'cliente teste 1', '', '', '', '', '', '', '', '', '', '', '', '', '(41) 3333-3333', '', '', '', '', '', '', '', '', '3', '2022-10-18 13:30:18', '2022-10-18 13:30:18');
INSERT INTO `clientes` VALUES ('6', '0', '0', '0', '1', '1', 'cliente teste', '', '', 'cliente teste', '', '', '', '', '', '', '', '', '', '', '', '', '(41) 3333-3333', '', '', '', '', '', '', '', '', '3', '2022-10-18 13:31:06', '2022-10-18 13:31:06');
INSERT INTO `clientes` VALUES ('7', '0', '0', '0', '1', '1', 'cliente 123', '', '', 'cliente 123', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '3', '2022-10-18 13:32:13', '2022-10-18 13:32:13');
INSERT INTO `clientes` VALUES ('8', '0', '0', '3', '1', '1', 'teste 123', '', '', 'teste 123', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '(41) 99999-9999', '', '', '', '', '', '4', '2023-02-08 14:28:18', '2023-02-08 14:28:18');
INSERT INTO `clientes` VALUES ('9', '0', '0', '0', '1', '1', 'cliente 123', '', '', 'cliente 123', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '4', '2023-02-08 14:44:17', '2023-02-08 14:44:17');
INSERT INTO `clientes` VALUES ('10', '0', '0', '1', '1', '1', 'flavio 13-03', '', '', 'flavio 13-03', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2', '2023-03-13 11:31:25', '2023-03-13 11:31:25');
INSERT INTO `clientes` VALUES ('11', '0', '0', '3', '1', '1', 'TESTE', '', '', 'TESTE', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '(12) 34567-8999', '', '', '', '', '', '16', '2023-08-30 09:03:56', '2023-08-30 09:03:56');
INSERT INTO `clientes` VALUES ('12', '0', '0', '3', '1', '1', 'João', '', '', 'João', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '16', '2023-08-30 09:25:56', '2023-08-30 09:25:56');
CREATE TABLE `codconferencia` (
  `CodConferencia` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `codconferenciaagenda` (
  `CodConferencia` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `colocacoes` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Pedido` int(11) NOT NULL,
  `Colocador` int(11) NOT NULL,
  `Item` int(11) NOT NULL,
  `Quantidade` float(8,2) NOT NULL,
  `Valor` float(8,2) NOT NULL,
  `Total` float(8,2) NOT NULL,
  `Data` varchar(10) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `Operador` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `colocacoespagamentos` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Colocacao` int(11) NOT NULL,
  `Data` varchar(10) NOT NULL,
  `Dia` int(2) NOT NULL,
  `Mes` int(2) NOT NULL,
  `Ano` int(4) NOT NULL,
  `Quantidade` float(8,2) NOT NULL,
  `Valor` float(8,2) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `Operador` int(11) NOT NULL,
  `DataPagamento` varchar(10) NOT NULL,
  `DataPagamentoCadastro` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `colocadores` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Porcentagem` float(8,2) NOT NULL,
  `Filial` int(11) NOT NULL,
  `Modalidade` int(5) NOT NULL,
  `Status` int(1) NOT NULL,
  `Nome` varchar(150) NOT NULL,
  `CPF` varchar(14) NOT NULL,
  `RazaoSocial` varchar(300) NOT NULL,
  `NomeFantasia` varchar(150) NOT NULL,
  `CNPJ` varchar(18) NOT NULL,
  `IE` varchar(14) NOT NULL,
  `DataNascimento` varchar(10) NOT NULL,
  `Email` varchar(100) NOT NULL,
  `EmailNFe` varchar(100) NOT NULL,
  `Endereco` varchar(150) NOT NULL,
  `Numero` varchar(10) NOT NULL,
  `Complemento` varchar(30) NOT NULL,
  `Bairro` varchar(100) NOT NULL,
  `Cidade` varchar(100) NOT NULL,
  `UF` varchar(2) NOT NULL,
  `CEP` varchar(10) NOT NULL,
  `Telefone01` varchar(14) NOT NULL,
  `Telefone02` varchar(14) NOT NULL,
  `Telefone03` varchar(14) NOT NULL,
  `Celular01` varchar(15) NOT NULL,
  `Celular02` varchar(15) NOT NULL,
  `Operadora01` varchar(15) NOT NULL,
  `Operadora02` varchar(15) NOT NULL,
  `Referencia` varchar(500) NOT NULL,
  `OBS` varchar(500) NOT NULL,
  `Operador` int(5) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `DataModificacao` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `colocadores` VALUES ('1', '1', '0.00', '0', '2', '1', 'flavio colocador', '', 'flavio colocador', 'flavio colocador', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '            ', '2', '2022-06-16 16:05:22', '2022-06-16 16:05:22');
INSERT INTO `colocadores` VALUES ('2', '2', '0.00', '0', '1', '1', 'ze colocador', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '(41) 3136-2506', '', '', '', '', '', '', '', '', '3', '2022-10-18 11:34:12', '2022-10-18 11:34:12');
CREATE TABLE `comissoes` (
  `Codigo` int(11) NOT NULL,
  `Status` int(2) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Usuario` int(11) NOT NULL,
  `Pedido` int(11) NOT NULL,
  `Financeiro` int(11) NOT NULL,
  `ValorTotal` float(8,2) NOT NULL,
  `FormaPagamento` int(11) NOT NULL,
  `Porcentagem` float(8,2) NOT NULL,
  `Comissao` float(8,2) NOT NULL,
  `ComissaoTotal` float(8,2) NOT NULL,
  `DescontoComissao` float(8,2) NOT NULL,
  `Data` varchar(10) NOT NULL,
  `DataVenda` varchar(10) NOT NULL,
  `DataPagamento` varchar(10) NOT NULL,
  `DataPagamentoCadastro` varchar(30) NOT NULL,
  `Dia` int(2) NOT NULL,
  `Mes` int(2) NOT NULL,
  `Ano` int(4) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `compromissos` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Status` int(2) NOT NULL,
  `Modalidade` int(11) NOT NULL,
  `Evento` int(11) NOT NULL,
  `Cliente` int(11) NOT NULL,
  `Titulo` varchar(150) NOT NULL,
  `Descricao` longtext NOT NULL,
  `Data` varchar(10) NOT NULL,
  `Horario` varchar(5) NOT NULL,
  `Dia` int(2) NOT NULL,
  `Mes` varchar(2) NOT NULL,
  `Ano` int(4) NOT NULL,
  `Horas` int(2) NOT NULL,
  `Minutos` int(2) NOT NULL,
  `Usuario` varchar(1) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL,
  `DataConclusao` varchar(30) NOT NULL,
  `Operador` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `compromissosmodalidade` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Descricao` varchar(70) NOT NULL,
  `Cor` varchar(15) NOT NULL,
  `Fonte` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `compromissosmodalidade` VALUES ('1', '1', 'Reunião', '#FF6331', '#FFFFFF');
CREATE TABLE `configuracaosistema` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Nome` varchar(150) NOT NULL,
  `Logo` varchar(150) NOT NULL,
  `Link` varchar(150) NOT NULL,
  `LinkLoja` varchar(150) NOT NULL,
  `LinkSistema` varchar(500) NOT NULL,
  `LinkMobile` varchar(150) NOT NULL,
  `CorFundoPadrao` varchar(10) NOT NULL,
  `CorFundoRollover` varchar(10) NOT NULL,
  `CorFundoDevedores` varchar(10) NOT NULL,
  `CorFundoDestaques` varchar(10) NOT NULL,
  `CorFundoExterno` varchar(10) NOT NULL,
  `CorFundoTopoTabelas` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `configuracaosistema` VALUES ('1', '0', 'Sispedra', 'logo.png', 'https://sispedra.com.br/sistema/', 'https://sispedra.com.br/sistema/', 'https://sispedra.com.br/painel-adm/', '', '', '', '', '', '', '');
CREATE TABLE `contasemail` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Email` varchar(300) NOT NULL,
  `Responsavel` int(11) NOT NULL,
  `Senha` varchar(70) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `contrato` (
  `id` int(11) NOT NULL,
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Descricao` longtext NOT NULL,
  `Tipo` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `contrato` VALUES ('1', '1', '1', '123', '0');
INSERT INTO `contrato` VALUES ('2', '2', '1', 'contrato 2', '0');
INSERT INTO `contrato` VALUES ('3', '3', '1', '2333', '0');
INSERT INTO `contrato` VALUES ('4', '4', '1', '32323232', '0');
INSERT INTO `contrato` VALUES ('5', '5', '1', '123131231', '0');
INSERT INTO `contrato` VALUES ('6', '1', '2', 'contrato pedido teste', '0');
INSERT INTO `contrato` VALUES ('7', '2', '2', '', '0');
INSERT INTO `contrato` VALUES ('8', '3', '2', 'termo cheque teste', '0');
INSERT INTO `contrato` VALUES ('9', '4', '2', 'termo cheque teste', '0');
INSERT INTO `contrato` VALUES ('10', '5', '2', 'furar teste', '0');
INSERT INTO `contrato` VALUES ('11', '1', '3', '', '0');
INSERT INTO `contrato` VALUES ('12', '2', '3', '', '0');
INSERT INTO `contrato` VALUES ('13', '3', '3', '', '0');
INSERT INTO `contrato` VALUES ('14', '4', '3', '', '0');
INSERT INTO `contrato` VALUES ('15', '5', '3', '', '0');
CREATE TABLE `contratocheques` (
  `id` int(11) NOT NULL,
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Titulo` longtext NOT NULL,
  `Texto01` longtext NOT NULL,
  `Texto02` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `contratocheques` VALUES ('1', '1', '1', '123213', '22222', '33333');
INSERT INTO `contratocheques` VALUES ('2', '1', '2', '', '', '');
INSERT INTO `contratocheques` VALUES ('3', '1', '3', '', '', '');
CREATE TABLE `departamentos` (
  `Codigo` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Departamento` varchar(30) NOT NULL,
  `Telefone` varchar(15) NOT NULL,
  `Email` varchar(150) NOT NULL,
  `TempoChamado` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `departamentos` VALUES ('1', '3', 'Comercial - Luis', '', '', '0');
INSERT INTO `departamentos` VALUES ('2', '1', 'Comercial', '', '', '2');
INSERT INTO `departamentos` VALUES ('3', '2', 'teste 1', '', '', '2');
INSERT INTO `departamentos` VALUES ('4', '2', 'teste 2', '', '', '1');
INSERT INTO `departamentos` VALUES ('5', '2', 'teste 3', '', '', '0');
INSERT INTO `departamentos` VALUES ('6', '3', 'Financeiro', '', '', '3');
INSERT INTO `departamentos` VALUES ('7', '3', 'Assistência Técnica', '', '', '1');
INSERT INTO `departamentos` VALUES ('8', '3', 'Comercial - Fernanda', '', '', '1');
CREATE TABLE `documentosclientes` (
  `Codigo` int(11) NOT NULL,
  `Filial` int(11) NOT NULL,
  `Loja` int(11) NOT NULL,
  `Cliente` int(11) NOT NULL,
  `Titulo` varchar(150) NOT NULL,
  `Operador` int(11) NOT NULL,
  `Documento` varchar(150) NOT NULL,
  `DataCadastro` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
