-- ------------------------- Fornecedores ---------------------- --

INSERT INTO `fornecedores` (`ID`, `Nome`, `Endereco`, `Bairro`, `Cidade`, `Estado`, `CEP`, `Telefone`, `Telefone2`, `Celular`, `CPFCNPJ`, `RGIE`, `Email`, `Vendedor`, `Observacoes`, `Cadastro`, `Ativo`, `Celular2`) VALUES
(1, 'Compesa', '', '', '2601102', '26', '', '', '', '', '55.131.617/0001-38', NULL, '', 1, 'Contatos diversos\n#1 3700-1001\n#2 3700-1000', NULL, 1, NULL),
(3, 'Viana Variedade ', 'Rua Porto Alegre, ', 'Centro', '2604106', '26', '55004-270', '(81) 3722-0650', '', '(81) 9209-2927', '01.380.994/0001-81', NULL, 'lucienevianacavalcante@gmail.com', 4, NULL, NULL, 1, NULL),
(4, 'OI MOVEL S.A.', 'SETOR COMERCIAL NORTE S/N QUADRA 03 BLOCO A- TÉRRE', '', '5300108', '53', '70713-900', '', '', '', '05.423.963/0001-11', NULL, '', 6, '', NULL, 1, NULL),
(5, 'Champion - Magnum Ind. da Amazonia S.A', 'Av. cupiuba , nº 1500', 'Dist. Industrial', '1302603', '13', '69075-060', '(92) 3615-3555', '', '', '84.185.866/0001-04', NULL, 'email@imail.com', 1, 'Contato financeiro: \nxx xxxx-xxxx\nContato suporte:\nxx xxxx-xxxx', NULL, 1, NULL);

-- ------------------------- Clientes ---------------------- --

INSERT INTO `clientes` (`ID`, `NOME`, `ENDERECO`, `BAIRRO`, `CIDADE`, `ESTADO`, `CEP`, `TELEFONE`, `CELULAR`, `CPFCNPJ`, `RGIE`, `EMAIL`, `SEXO`, `VENDEDOR`, `OBSERVACOES`, `CADASTRO`, `MAE`, `ATIVO`, `telefone2`) VALUES
(3, 'Welton Andrade', '', '', '2600807', '26', '', '', '', '551.543.285-15', NULL, 'welton@aol.com', 'M', 1, NULL, NULL, NULL, 1, NULL),
(4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '426.689.884-38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL),
(5, 'José Domingues', NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, '', NULL, 1, NULL, NULL, NULL, 1, 1),
(6, 'José Da Silva', NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, '', NULL, 1, NULL, NULL, NULL, 1, 1),
(7, 'José Vinícius', NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, '', NULL, 4, NULL, NULL, NULL, 1, NULL),
(8, 'Noemi Nonato', NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, '', NULL, 1, NULL, NULL, NULL, 1, NULL),
(9, 'DEBORA RAFAELA DA SILVA MOURA', 'RUA ANTENOR NAVARRO Nº 645-A', 'PETROPÓLIS', '2604106', '26', '', '', '(81) 9255-8927', '705.248.434-06', NULL, '', 'F', 4, NULL, NULL, NULL, 1, NULL),
(10, 'JOSE BEZERRA - JUNIOR TRAMONTINA', 'BRASILUX IND.COMP.IMP.EXP.LTDA. Nº 2135', 'ENCANO DO NORTE', '4207502', '42', '89130-000', '(81) 3722-5750', '', '00.374.121/0001-01', NULL, 'jbezerrasjunior@gmail.com', 'M', 6, NULL, NULL, NULL, 1, NULL),
(11, 'JOSILEIDE FERREIRA ALVES', 'RUA JOSÉ RAFAEL CAVALCANTE Nº 166', 'PETROPOLIS', '2604106', '26', '', '(81) 3722-2406', '(81) 99915-5319', '584.691.504-30', NULL, '', 'M', 6, NULL, NULL, NULL, 1, NULL),
(12, 'IVANIZE VIEIRA DOS SANTOS', 'AV. RUBEM FLORENCIO DE MOURA Nº 196', 'PADRE INACIO', '2604106', '26', '', '', '(81) 9226-5511', '034.824.894-67', NULL, '', 'M', 6, NULL, NULL, NULL, 1, NULL),
(13, 'JOSELUCIA ALVES DA SILVA OLIVEIRA', '1º TRAVESSA LAGOA ENCANTADA Nº 17', 'KENNEDY', '2604106', '26', '', '', '(81) 99406-7503', '258.118.514-72', NULL, '', 'M', 6, NULL, NULL, NULL, 1, NULL),
(14, 'CLIENTE CONSUMIDOR', NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, '', NULL, 6, NULL, NULL, NULL, 1, NULL),
(15, 'CLIENTE CONSUMIDOR', NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, '', NULL, 1, NULL, NULL, NULL, 1, NULL),
(16, 'TARCISO ALMEIDA SILVA', 'RUA 47 Nº 116', 'REIDEIRAS', '2604106', '26', '55022-085', '', '(81) 9339-2286', '279.428.564-53', NULL, '', 'M', 6, NULL, NULL, NULL, 1, NULL),
(17, 'CLAUDIANO JULIO DA SILVA   MOTORISTA COLETIVO', 'RUA SAMUEL FALCÃO Nº 204', 'CAIUCA', '0', '0', '', '', '(81) 9845-3732', '025.290.074-03', NULL, '', 'M', 6, NULL, NULL, NULL, 1, NULL),
(18, 'VALDOMIRO JOSÉ DE LIRA', 'RUA JOAO FRANCISCO DA SILVA Nº 75', 'JOSÉ CARLOS DE OLIVEIRA', '2604106', '26', '55042-370', '', '(81) 9277-1381', '045.069.094-61', NULL, '', 'M', 6, NULL, NULL, NULL, 1, NULL);

-- ------------------------- Produtos ---------------------- --

INSERT INTO `produtos` (`ID`, `Referencia`, `Descricao`, `ValorCompra`, `Valor`, `Valor2`, `ValorPrazo`, `Estoque`, `UltimoBalanco`, `Unidade`, `Cor`, `Tamanho`, `Tipo`, `Status`) VALUES
(7, '004', 'Relógio Citizen', NULL, 250.00, NULL, 265.53, 10, NULL, 'PC', 'Prata', '', '', NULL),
(8, 'BA2016', 'Bateria 2016', NULL, 20.00, NULL, 0.00, -1, NULL, 'UN', '', '', '', NULL),
(9, 'RN09', 'RELÓGIO NEUTRON ', NULL, 15.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(10, 'RG02', 'RELÓGIO GUITARRA', NULL, 25.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(11, 'RE001', 'Produto Teste', NULL, 250.00, 0.00, NULL, 25, 25, 'UN', NULL, NULL, NULL, NULL),
(12, 'RL0164008', 'RELOGIO SPEEDO LPEVDPI2', NULL, 250.00, 0.00, NULL, 0, 0, 'UN', NULL, NULL, NULL, NULL),
(13, 'RA01', 'RELÓGIO ATLANTIS BORRACHA', NULL, 25.00, 0.00, NULL, -2, NULL, 'UN', NULL, NULL, NULL, NULL),
(14, 'RAA02', 'RELOGIO ATLANTIS DE AÇO', NULL, 30.00, 0.00, NULL, -1, NULL, 'UN', NULL, NULL, NULL, NULL),
(15, 'MT01', 'MOLA DE TRAVA', NULL, 5.00, 0.00, NULL, -2, NULL, 'UN', NULL, NULL, NULL, NULL),
(16, 'MQ05', 'MAQUINA PINGO D''ÁGUA', NULL, 70.00, 0.00, NULL, -1, NULL, 'UN', NULL, NULL, NULL, NULL),
(17, 'CJFO01', 'CONJUNTO FOLHEADO', NULL, 10.00, 0.00, NULL, -1, NULL, 'UN', NULL, NULL, NULL, NULL),
(18, 'RLS', 'RELOGIO SÉCULOS 24773LPSFDS1211', NULL, 340.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(19, 'RLS2', 'RELÓGIO SÉCULOS 24773LPSFMS41211', NULL, 415.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(20, 'RLS3', 'RELÓGIO SÉCULOS 28182LPSPDS20912', NULL, 286.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(21, 'RLS03', 'RELÓGIO SECULOS 247002PSPBS41082', NULL, 262.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(22, 'RLS4', 'RELÓGIO SÉCULOS 232712PSDA30304', NULL, 202.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(23, 'RLS5', 'RELÓGIO SÉCULOS 232712PSBDA30304', NULL, 202.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(24, 'RLS5', 'RELÓGIO SÉCULOS 245362PSSPA0606', NULL, 284.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(25, 'RLS6', 'RELÓGIO SÉCULOS 28140LPSPDS40805', NULL, 284.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(26, 'RLS7', 'RELÓGIO SÉCULOS 24736GOSBNA30902', NULL, 216.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(27, 'RLG1', 'RELOGIO 76184LPMGRE30904', NULL, 330.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(28, 'RLG2', ' RELOGIO 76175LPMSPZ10801', NULL, 136.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(29, 'RLG3', 'RELOGIO 94289LPMGDP10804', NULL, 390.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(30, 'RLG4', 'RELOGIO 94318GOMBNS20301', NULL, 172.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(31, 'RLG5', 'RELOGIO 94299GOMGNS10204', NULL, 266.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(32, 'RLG6', 'RELOGIO  76141LOMFNE10801', NULL, 162.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(33, 'RLG7', 'RELOGIO 94308LOMTNM10802', NULL, 150.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(34, 'RLG8', 'RELOGIO 76191LPMFDB2', NULL, 137.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(35, 'RLG9', 'RELOGIO 76191LPMFDB20905', NULL, 274.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(36, 'RLG10', 'RELOGIO 28017GO0606', NULL, 234.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(37, 'RLG11', 'RELOGIO 94165LOMENE0303', NULL, 162.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(38, 'RLG12', 'RELOGIO 94212LOMENE0692', NULL, 146.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL),
(39, 'RLGS', 'RELOGIO SURF MORE18840016', NULL, 138.00, NULL, 0.00, 0, NULL, 'UN', '', '', '', NULL);

-- ------------------------- Serviços ---------------------- --

INSERT INTO `servicos` (`ID`, `Referencia`, `Descricao`, `Valor`, `Valor2`, `ValorPrazo`, `Desconto`, `Unidade`, `Cor`, `Tamanho`, `Tipo`, `Categoria`, `Status`) VALUES
(3, 'AJ01', 'Ajuste em óculos', 25.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(5, 'BA920', 'Bateria 920', 20.00, NULL, 0.00, NULL, 'PÇ', '', '', '', NULL, NULL),
(6, 'RE01', 'PINO', 5.00, NULL, 0.00, NULL, 'PÇ', '-', '-', '-', NULL, NULL),
(7, 'BA626', 'BATERIA 626', 15.00, 13.00, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(8, 'PB24', 'PULSEIRA BORRACHA', 20.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(9, 'TC01', 'TRANCA COMUM COURO', 5.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(10, 'TN02', 'TRANCA NET WORK', 10.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(11, 'TO03', 'TRANCA DE ORIENT', 10.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(12, 'DM01', 'DIMINUIR RELOGIO', 5.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(13, 'BA927', 'BATERIA', 25.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(14, 'PC01', 'PULSEIRA EM COURO GOLD', 20.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(15, 'PS01', 'PASSADOR DE PULSEIRA ', 5.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(16, 'LP01', 'LIMPEZA DE CIRCUITO CONTROLE', 5.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(17, 'CP01', 'COLOCAR PONTEIROS NACIONAL', 5.00, NULL, 0.00, NULL, 'UN', '', '', '', NULL, NULL),
(18, 'MP003', 'MAQUINA PRETA', 25.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, 3, NULL),
(19, 'PC006', 'PULSEIRA COURO', 15.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, 3, NULL),
(20, 'RP007', 'RELOGIO PEQUENO', 15.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, 3, NULL),
(21, 'BA2032', 'BATERIA 2032', 8.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, 3, NULL),
(22, 'BA621', 'BATERIA', 10.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, 3, NULL),
(24, 'CV007', 'CONSERTOS VARIADOS', 110.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, 1, 1),
(25, 'CG008', 'CONSERTOS EM GERAL', 110.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, 1, NULL),
(26, 'RM VISOU', 'RELÓGIO DIMINUIR VISOU', 0.00, 2.00, NULL, NULL, 'UN', NULL, NULL, NULL, 1, NULL),
(27, 'RM VISOU 04', 'DIMINUIR RELOGIO', 0.00, 4.00, NULL, NULL, 'UN', NULL, NULL, NULL, 3, NULL),
(28, 'PT011', 'PINO TRAVA', 10.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(29, 'CR010', 'CONSERTO RELOGIO', 10.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(30, 'VR04', 'VEDAÇÃO DE RELOGIO', 25.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(31, 'VIDRL01', 'VIDRO DE RELOGIO', 40.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(32, 'RLP01', 'AJUSTE DE PONTEIROS', 5.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(33, 'PL01', ' POLIMENTO', 20.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(34, 'LIMP01', 'LIMPEZA', 10.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(35, 'BC03', 'BORRACHA DE VEDAÇÃO', 5.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(36, 'BA371', 'BATERIA ENERGIZER', 20.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(37, 'RP01', 'REPOSIÇÃO DE PONTEIROS', 5.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(38, 'RM06', 'RESTAURAÇÃO DE MOSTRADOR', 5.00, NULL, 0.00, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(39, 'AI01', 'AJUSTE DE INDEX', 5.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(40, 'BA721', 'BATERIA', 25.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(41, 'SCP', 'SOLDA CORDÃO DE PRATA', 20.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(42, 'RV', 'REVISÃO DE RELOGIO', 10.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, NULL, NULL),
(43, 'RPPUL01', 'REPOSIÇÃO DE PULSEIRA', 5.00, 0.00, NULL, NULL, 'UN', NULL, NULL, NULL, NULL, NULL);