zNHbeLWH

1CREATE DATABASE  IF NOT EXISTS `stiweb_bd` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
2USE `stiweb_bd`;
3-- MySQL dump 10.13  Distrib 8.0.16, for Win64 (x86_64)
4--
5-- Host: 127.0.0.1    Database: stiweb_bd
6-- ------------------------------------------------------
7-- Server version	8.0.16
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12 SET NAMES utf8 ;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `acesso_telas`
22--
23
24DROP TABLE IF EXISTS `acesso_telas`;
25/*!40101 SET @saved_cs_client     = @@character_set_client */;
26 SET character_set_client = utf8mb4 ;
27CREATE TABLE `acesso_telas` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `consulta_financeiro` varchar(255) DEFAULT NULL,
30  `manutencao_financeiro` varchar(255) DEFAULT NULL,
31  `username` varchar(255) DEFAULT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `acesso_telas`
38--
39
40LOCK TABLES `acesso_telas` WRITE;
41/*!40000 ALTER TABLE `acesso_telas` DISABLE KEYS */;
42INSERT INTO `acesso_telas` VALUES (1,'S','N','ELIELCENA'),(2,'S','S','GIM'),(3,'S','S','MASSAROTTI'),(4,'S','S','JOSEBRAS');
43/*!40000 ALTER TABLE `acesso_telas` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `almoxarifado`
48--
49
50DROP TABLE IF EXISTS `almoxarifado`;
51/*!40101 SET @saved_cs_client     = @@character_set_client */;
52 SET character_set_client = utf8mb4 ;
53CREATE TABLE `almoxarifado` (
54  `idAlmoxarifado` int(11) NOT NULL AUTO_INCREMENT,
55  `descricao` varchar(255) DEFAULT NULL,
56  `idEmpresa` int(11) DEFAULT NULL,
57  PRIMARY KEY (`idAlmoxarifado`),
58  KEY `FK8D05CB7364C4C7DC` (`idEmpresa`),
59  CONSTRAINT `FK8D05CB7364C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`)
60) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `almoxarifado`
65--
66
67LOCK TABLES `almoxarifado` WRITE;
68/*!40000 ALTER TABLE `almoxarifado` DISABLE KEYS */;
69INSERT INTO `almoxarifado` VALUES (1,'ADMINISTRATIVO',1);
70/*!40000 ALTER TABLE `almoxarifado` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `caixa`
75--
76
77DROP TABLE IF EXISTS `caixa`;
78/*!40101 SET @saved_cs_client     = @@character_set_client */;
79 SET character_set_client = utf8mb4 ;
80CREATE TABLE `caixa` (
81  `idCaixa` int(11) NOT NULL AUTO_INCREMENT,
82  `descricao` varchar(255) DEFAULT NULL,
83  PRIMARY KEY (`idCaixa`)
84) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `caixa`
89--
90
91LOCK TABLES `caixa` WRITE;
92/*!40000 ALTER TABLE `caixa` DISABLE KEYS */;
93INSERT INTO `caixa` VALUES (1,'CAIXA 1');
94/*!40000 ALTER TABLE `caixa` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `caixa_abertura_fechamento`
99--
100
101DROP TABLE IF EXISTS `caixa_abertura_fechamento`;
102/*!40101 SET @saved_cs_client     = @@character_set_client */;
103 SET character_set_client = utf8mb4 ;
104CREATE TABLE `caixa_abertura_fechamento` (
105  `idcaixa_abertura_fechamento` int(11) NOT NULL AUTO_INCREMENT,
106  `data_abertura` datetime DEFAULT NULL,
107  `data_fechamento` datetime DEFAULT NULL,
108  `diferenca` double DEFAULT NULL,
109  `gaveta_cheque` double DEFAULT NULL,
110  `gaveta_credito` double DEFAULT NULL,
111  `gaveta_debito` double DEFAULT NULL,
112  `gaveta_dinheiro` double DEFAULT NULL,
113  `obs_fechamento` varchar(255) DEFAULT NULL,
114  `pagar_boleto` double DEFAULT NULL,
115  `pagar_cheque` double DEFAULT NULL,
116  `pagar_credito` double DEFAULT NULL,
117  `pagar_debito` double DEFAULT NULL,
118  `pagar_deposito` double DEFAULT NULL,
119  `pagar_dinheiro` double DEFAULT NULL,
120  `receber_boleto` double DEFAULT NULL,
121  `receber_cheque` double DEFAULT NULL,
122  `receber_credito` double DEFAULT NULL,
123  `receber_debito` double DEFAULT NULL,
124  `receber_deposito` double DEFAULT NULL,
125  `receber_dinheiro` double DEFAULT NULL,
126  `sistema_cheque` double DEFAULT NULL,
127  `sistema_credito` double DEFAULT NULL,
128  `sistema_debito` double DEFAULT NULL,
129  `sistema_dinheiro` double DEFAULT NULL,
130  `sistema_prazo` double DEFAULT NULL,
131  `sistema_reforco` double DEFAULT NULL,
132  `sistema_sangria` double DEFAULT NULL,
133  `total_fisico` double DEFAULT NULL,
134  `total_geral` double DEFAULT NULL,
135  `usuario_abertura` varchar(255) DEFAULT NULL,
136  `usuario_fechamento` varchar(255) DEFAULT NULL,
137  `valor_abertura` double DEFAULT NULL,
138  `idCaixa` int(11) DEFAULT NULL,
139  `id_empresa` int(11) DEFAULT NULL,
140  PRIMARY KEY (`idcaixa_abertura_fechamento`),
141  KEY `FKC395F58A2E50AE67` (`idCaixa`),
142  KEY `FKC395F58AAA282233` (`id_empresa`),
143  CONSTRAINT `FKC395F58A2E50AE67` FOREIGN KEY (`idCaixa`) REFERENCES `caixa` (`idCaixa`),
144  CONSTRAINT `FKC395F58AAA282233` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`idEmpresa`)
145) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
146/*!40101 SET character_set_client = @saved_cs_client */;
147
148--
149-- Dumping data for table `caixa_abertura_fechamento`
150--
151
152LOCK TABLES `caixa_abertura_fechamento` WRITE;
153/*!40000 ALTER TABLE `caixa_abertura_fechamento` DISABLE KEYS */;
154INSERT INTO `caixa_abertura_fechamento` VALUES (1,'2020-01-09 20:06:26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ELIELCENA',NULL,10000,1,1);
155/*!40000 ALTER TABLE `caixa_abertura_fechamento` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `caixa_movimento`
160--
161
162DROP TABLE IF EXISTS `caixa_movimento`;
163/*!40101 SET @saved_cs_client     = @@character_set_client */;
164 SET character_set_client = utf8mb4 ;
165CREATE TABLE `caixa_movimento` (
166  `idcaixa_movimento` int(11) NOT NULL AUTO_INCREMENT,
167  `data` datetime DEFAULT NULL,
168  `descricao` varchar(255) DEFAULT NULL,
169  `forma_pagamento` varchar(255) DEFAULT NULL,
170  `sangria_reforco` varchar(255) DEFAULT NULL,
171  `usuario` varchar(255) DEFAULT NULL,
172  `valor` double DEFAULT NULL,
173  `idCaixa` int(11) DEFAULT NULL,
174  `id_empresa` int(11) DEFAULT NULL,
175  `id_nota` int(11) DEFAULT NULL,
176  PRIMARY KEY (`idcaixa_movimento`),
177  KEY `FK1D10D991B1383D68` (`id_nota`),
178  KEY `FK1D10D9912E50AE67` (`idCaixa`),
179  KEY `FK1D10D991AA282233` (`id_empresa`),
180  CONSTRAINT `FK1D10D9912E50AE67` FOREIGN KEY (`idCaixa`) REFERENCES `caixa` (`idCaixa`),
181  CONSTRAINT `FK1D10D991AA282233` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`idEmpresa`),
182  CONSTRAINT `FK1D10D991B1383D68` FOREIGN KEY (`id_nota`) REFERENCES `nota_fiscal_parcelas` (`idnota_fiscal_parcelas`)
183) ENGINE=InnoDB DEFAULT CHARSET=latin1;
184/*!40101 SET character_set_client = @saved_cs_client */;
185
186--
187-- Dumping data for table `caixa_movimento`
188--
189
190LOCK TABLES `caixa_movimento` WRITE;
191/*!40000 ALTER TABLE `caixa_movimento` DISABLE KEYS */;
192/*!40000 ALTER TABLE `caixa_movimento` ENABLE KEYS */;
193UNLOCK TABLES;
194
195--
196-- Table structure for table `devolucao_almoxarifado`
197--
198
199DROP TABLE IF EXISTS `devolucao_almoxarifado`;
200/*!40101 SET @saved_cs_client     = @@character_set_client */;
201 SET character_set_client = utf8mb4 ;
202CREATE TABLE `devolucao_almoxarifado` (
203  `iddevolucao` int(11) NOT NULL AUTO_INCREMENT,
204  `dtdev` datetime DEFAULT NULL,
205  `dtmovhora` datetime DEFAULT NULL,
206  `nrdevolucao` int(11) DEFAULT NULL,
207  `qtdedev` double DEFAULT NULL,
208  `vlrtotal` double DEFAULT NULL,
209  `vlrunit` double DEFAULT NULL,
210  `idAlmoxarifado` int(11) DEFAULT NULL,
211  `idEmpresa` int(11) DEFAULT NULL,
212  `idMaterial` int(11) DEFAULT NULL,
213  `idPessoaDevolveu` int(11) DEFAULT NULL,
214  `idRequisicao` int(11) DEFAULT NULL,
215  PRIMARY KEY (`iddevolucao`),
216  KEY `FK879881246082D27C` (`idAlmoxarifado`),
217  KEY `FK8798812464C4C7DC` (`idEmpresa`),
218  KEY `FK8798812428E49F23` (`idRequisicao`),
219  KEY `FK87988124B5274018` (`idMaterial`),
220  KEY `FK87988124CB07D88C` (`idPessoaDevolveu`),
221  CONSTRAINT `FK8798812428E49F23` FOREIGN KEY (`idRequisicao`) REFERENCES `requisicao_materiais` (`idrequisicao_materiais`),
222  CONSTRAINT `FK879881246082D27C` FOREIGN KEY (`idAlmoxarifado`) REFERENCES `almoxarifado` (`idAlmoxarifado`),
223  CONSTRAINT `FK8798812464C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
224  CONSTRAINT `FK87988124B5274018` FOREIGN KEY (`idMaterial`) REFERENCES `material` (`idMaterial`),
225  CONSTRAINT `FK87988124CB07D88C` FOREIGN KEY (`idPessoaDevolveu`) REFERENCES `pessoa` (`idPessoa`)
226) ENGINE=InnoDB DEFAULT CHARSET=latin1;
227/*!40101 SET character_set_client = @saved_cs_client */;
228
229--
230-- Dumping data for table `devolucao_almoxarifado`
231--
232
233LOCK TABLES `devolucao_almoxarifado` WRITE;
234/*!40000 ALTER TABLE `devolucao_almoxarifado` DISABLE KEYS */;
235/*!40000 ALTER TABLE `devolucao_almoxarifado` ENABLE KEYS */;
236UNLOCK TABLES;
237
238--
239-- Table structure for table `empresa`
240--
241
242DROP TABLE IF EXISTS `empresa`;
243/*!40101 SET @saved_cs_client     = @@character_set_client */;
244 SET character_set_client = utf8mb4 ;
245CREATE TABLE `empresa` (
246  `idEmpresa` int(11) NOT NULL,
247  `bairro` varchar(255) DEFAULT NULL,
248  `cep` varchar(255) DEFAULT NULL,
249  `cnpj` varchar(255) DEFAULT NULL,
250  `complemento` varchar(255) DEFAULT NULL,
251  `endereco` varchar(255) DEFAULT NULL,
252  `numero` int(11) DEFAULT NULL,
253  `razaosocial` varchar(255) DEFAULT NULL,
254  PRIMARY KEY (`idEmpresa`)
255) ENGINE=InnoDB DEFAULT CHARSET=latin1;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `empresa`
260--
261
262LOCK TABLES `empresa` WRITE;
263/*!40000 ALTER TABLE `empresa` DISABLE KEYS */;
264INSERT INTO `empresa` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'STI WEB');
265/*!40000 ALTER TABLE `empresa` ENABLE KEYS */;
266UNLOCK TABLES;
267
268--
269-- Table structure for table `estoque`
270--
271
272DROP TABLE IF EXISTS `estoque`;
273/*!40101 SET @saved_cs_client     = @@character_set_client */;
274 SET character_set_client = utf8mb4 ;
275CREATE TABLE `estoque` (
276  `idEstoque` int(11) NOT NULL AUTO_INCREMENT,
277  `dtsaldo` datetime DEFAULT NULL,
278  `qtdeest` double DEFAULT NULL,
279  `vlrmedio` double DEFAULT NULL,
280  `idAlmoxarifado` int(11) DEFAULT NULL,
281  `idEmpresa` int(11) DEFAULT NULL,
282  `idMaterial` int(11) DEFAULT NULL,
283  PRIMARY KEY (`idEstoque`),
284  KEY `FKA9A982786082D27C` (`idAlmoxarifado`),
285  KEY `FKA9A9827864C4C7DC` (`idEmpresa`),
286  KEY `FKA9A98278B5274018` (`idMaterial`),
287  CONSTRAINT `FKA9A982786082D27C` FOREIGN KEY (`idAlmoxarifado`) REFERENCES `almoxarifado` (`idAlmoxarifado`),
288  CONSTRAINT `FKA9A9827864C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
289  CONSTRAINT `FKA9A98278B5274018` FOREIGN KEY (`idMaterial`) REFERENCES `material` (`idMaterial`)
290) ENGINE=InnoDB DEFAULT CHARSET=latin1;
291/*!40101 SET character_set_client = @saved_cs_client */;
292
293--
294-- Dumping data for table `estoque`
295--
296
297LOCK TABLES `estoque` WRITE;
298/*!40000 ALTER TABLE `estoque` DISABLE KEYS */;
299/*!40000 ALTER TABLE `estoque` ENABLE KEYS */;
300UNLOCK TABLES;
301
302--
303-- Table structure for table `familia`
304--
305
306DROP TABLE IF EXISTS `familia`;
307/*!40101 SET @saved_cs_client     = @@character_set_client */;
308 SET character_set_client = utf8mb4 ;
309CREATE TABLE `familia` (
310  `idFamilia` int(11) NOT NULL AUTO_INCREMENT,
311  `descfam` varchar(255) DEFAULT NULL,
312  `idEmpresa` int(11) DEFAULT NULL,
313  PRIMARY KEY (`idFamilia`),
314  KEY `FKBF730F8D64C4C7DC` (`idEmpresa`),
315  CONSTRAINT `FKBF730F8D64C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`)
316) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
317/*!40101 SET character_set_client = @saved_cs_client */;
318
319--
320-- Dumping data for table `familia`
321--
322
323LOCK TABLES `familia` WRITE;
324/*!40000 ALTER TABLE `familia` DISABLE KEYS */;
325INSERT INTO `familia` VALUES (1,'ALUGUEL',1);
326/*!40000 ALTER TABLE `familia` ENABLE KEYS */;
327UNLOCK TABLES;
328
329--
330-- Table structure for table `financeiro`
331--
332
333DROP TABLE IF EXISTS `financeiro`;
334/*!40101 SET @saved_cs_client     = @@character_set_client */;
335 SET character_set_client = utf8mb4 ;
336CREATE TABLE `financeiro` (
337  `idFinanceiro` int(11) NOT NULL AUTO_INCREMENT,
338  `data_gerou` datetime DEFAULT NULL,
339  `dtpagamento` date DEFAULT NULL,
340  `dtvencimento` date DEFAULT NULL,
341  `pagar_receber` varchar(255) DEFAULT NULL,
342  `parcela` int(11) DEFAULT NULL,
343  `tipo_pag` varchar(255) DEFAULT NULL,
344  `id_titulo_origem` int(11) DEFAULT NULL,
345  `valor_a_pagar` double DEFAULT NULL,
346  `valor_pago` double DEFAULT NULL,
347  `idEmpresa` int(11) DEFAULT NULL,
348  `idFornecedorCliente` int(11) DEFAULT NULL,
349  `idNotaFiscal` int(11) DEFAULT NULL,
350  `id_sp_cab` int(11) DEFAULT NULL,
351  `historico` varchar(200) DEFAULT NULL,
352  PRIMARY KEY (`idFinanceiro`),
353  KEY `FK94AA024CB259F190` (`idFornecedorCliente`),
354  KEY `FK94AA024C64C4C7DC` (`idEmpresa`),
355  KEY `FK94AA024CAD852DE7` (`idNotaFiscal`),
356  KEY `fk_financeiro_sp_cab_idx` (`id_sp_cab`),
357  CONSTRAINT `FK94AA024C64C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
358  CONSTRAINT `FK94AA024CAD852DE7` FOREIGN KEY (`idNotaFiscal`) REFERENCES `nota_fiscal` (`idnota_fiscal`),
359  CONSTRAINT `FK94AA024CB259F190` FOREIGN KEY (`idFornecedorCliente`) REFERENCES `pessoa` (`idPessoa`),
360  CONSTRAINT `fk_financeiro_sp_cab` FOREIGN KEY (`id_sp_cab`) REFERENCES `sp_cab` (`idsp_cab`)
361) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
362/*!40101 SET character_set_client = @saved_cs_client */;
363
364--
365-- Dumping data for table `financeiro`
366--
367
368LOCK TABLES `financeiro` WRITE;
369/*!40000 ALTER TABLE `financeiro` DISABLE KEYS */;
370INSERT INTO `financeiro` VALUES (3,'2020-02-03 08:45:21',NULL,'2020-02-03','P',1,'LA',NULL,100,NULL,1,4,NULL,2075479318,''),(4,'2020-02-03 12:47:19',NULL,'2020-02-03','P',1,'LA',NULL,150000,150000,1,1,NULL,2075479319,'TESTE');
371/*!40000 ALTER TABLE `financeiro` ENABLE KEYS */;
372UNLOCK TABLES;
373
374--
375-- Table structure for table `financeiro_pagamento`
376--
377
378DROP TABLE IF EXISTS `financeiro_pagamento`;
379/*!40101 SET @saved_cs_client     = @@character_set_client */;
380 SET character_set_client = utf8mb4 ;
381CREATE TABLE `financeiro_pagamento` (
382  `idfinanceiro_pagamento` int(11) NOT NULL,
383  `data_registro` datetime DEFAULT NULL,
384  `dtpagamento` datetime DEFAULT NULL,
385  `forma_pagamento` varchar(255) DEFAULT NULL,
386  `valor` double DEFAULT NULL,
387  `idFinanceiro` int(11) DEFAULT NULL,
388  `usuario_baixa` varchar(255) DEFAULT NULL,
389  PRIMARY KEY (`idfinanceiro_pagamento`),
390  KEY `FK1B4FA0F35CEFDF07` (`idFinanceiro`),
391  CONSTRAINT `FK1B4FA0F35CEFDF07` FOREIGN KEY (`idFinanceiro`) REFERENCES `financeiro` (`idFinanceiro`)
392) ENGINE=InnoDB DEFAULT CHARSET=latin1;
393/*!40101 SET character_set_client = @saved_cs_client */;
394
395--
396-- Dumping data for table `financeiro_pagamento`
397--
398
399LOCK TABLES `financeiro_pagamento` WRITE;
400/*!40000 ALTER TABLE `financeiro_pagamento` DISABLE KEYS */;
401INSERT INTO `financeiro_pagamento` VALUES (1638814878,'2020-02-03 12:53:04','2020-02-03 00:00:00','',150000,4,'2');
402/*!40000 ALTER TABLE `financeiro_pagamento` ENABLE KEYS */;
403UNLOCK TABLES;
404
405--
406-- Table structure for table `grupo`
407--
408
409DROP TABLE IF EXISTS `grupo`;
410/*!40101 SET @saved_cs_client     = @@character_set_client */;
411 SET character_set_client = utf8mb4 ;
412CREATE TABLE `grupo` (
413  `idGrupo` int(11) NOT NULL AUTO_INCREMENT,
414  `descgrupo` varchar(255) DEFAULT NULL,
415  `idEmpresa` int(11) DEFAULT NULL,
416  `idFamilia` int(11) DEFAULT NULL,
417  PRIMARY KEY (`idGrupo`),
418  KEY `FK5E10C6964C4C7DC` (`idEmpresa`),
419  KEY `FK5E10C69DC122E60` (`idFamilia`),
420  CONSTRAINT `FK5E10C6964C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
421  CONSTRAINT `FK5E10C69DC122E60` FOREIGN KEY (`idFamilia`) REFERENCES `familia` (`idFamilia`)
422) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
423/*!40101 SET character_set_client = @saved_cs_client */;
424
425--
426-- Dumping data for table `grupo`
427--
428
429LOCK TABLES `grupo` WRITE;
430/*!40000 ALTER TABLE `grupo` DISABLE KEYS */;
431INSERT INTO `grupo` VALUES (1,'ALUGUEL DE EQUIPAMENTOS',1,1);
432/*!40000 ALTER TABLE `grupo` ENABLE KEYS */;
433UNLOCK TABLES;
434
435--
436-- Table structure for table `inventario`
437--
438
439DROP TABLE IF EXISTS `inventario`;
440/*!40101 SET @saved_cs_client     = @@character_set_client */;
441 SET character_set_client = utf8mb4 ;
442CREATE TABLE `inventario` (
443  `idinventario` int(11) NOT NULL AUTO_INCREMENT,
444  `ajustar` varchar(255) DEFAULT NULL,
445  `contagem1` double DEFAULT NULL,
446  `data_ajuste` datetime DEFAULT NULL,
447  `data_inventario` datetime DEFAULT NULL,
448  `digitou` varchar(255) DEFAULT NULL,
449  `dtmovhora` datetime DEFAULT NULL,
450  `entrada_estoque` double DEFAULT NULL,
451  `observacao` varchar(255) DEFAULT NULL,
452  `processo` varchar(255) DEFAULT NULL,
453  `qtdeest` double DEFAULT NULL,
454  `saida_estoque` double DEFAULT NULL,
455  `usuario` varchar(255) DEFAULT NULL,
456  `usuariodigitou` varchar(255) DEFAULT NULL,
457  `idAlmoxarifado` int(11) DEFAULT NULL,
458  `idempresa` int(11) DEFAULT NULL,
459  `idFamilia` int(11) DEFAULT NULL,
460  `idGrupo` int(11) DEFAULT NULL,
461  `idmaterial` int(11) DEFAULT NULL,
462  PRIMARY KEY (`idinventario`),
463  KEY `FK6A6CB3716082D27C` (`idAlmoxarifado`),
464  KEY `FK6A6CB37164C4C7DC` (`idempresa`),
465  KEY `FK6A6CB371DC122E60` (`idFamilia`),
466  KEY `FK6A6CB371B5274018` (`idmaterial`),
467  KEY `FK6A6CB371BA7C98FC` (`idGrupo`),
468  CONSTRAINT `FK6A6CB3716082D27C` FOREIGN KEY (`idAlmoxarifado`) REFERENCES `almoxarifado` (`idAlmoxarifado`),
469  CONSTRAINT `FK6A6CB37164C4C7DC` FOREIGN KEY (`idempresa`) REFERENCES `empresa` (`idEmpresa`),
470  CONSTRAINT `FK6A6CB371B5274018` FOREIGN KEY (`idmaterial`) REFERENCES `material` (`idMaterial`),
471  CONSTRAINT `FK6A6CB371BA7C98FC` FOREIGN KEY (`idGrupo`) REFERENCES `grupo` (`idGrupo`),
472  CONSTRAINT `FK6A6CB371DC122E60` FOREIGN KEY (`idFamilia`) REFERENCES `familia` (`idFamilia`)
473) ENGINE=InnoDB DEFAULT CHARSET=latin1;
474/*!40101 SET character_set_client = @saved_cs_client */;
475
476--
477-- Dumping data for table `inventario`
478--
479
480LOCK TABLES `inventario` WRITE;
481/*!40000 ALTER TABLE `inventario` DISABLE KEYS */;
482/*!40000 ALTER TABLE `inventario` ENABLE KEYS */;
483UNLOCK TABLES;
484
485--
486-- Table structure for table `material`
487--
488
489DROP TABLE IF EXISTS `material`;
490/*!40101 SET @saved_cs_client     = @@character_set_client */;
491 SET character_set_client = utf8mb4 ;
492CREATE TABLE `material` (
493  `idMaterial` int(11) NOT NULL AUTO_INCREMENT,
494  `classificacao` varchar(255) DEFAULT NULL,
495  `descmat` varchar(255) DEFAULT NULL,
496  `localidade` varchar(255) DEFAULT NULL,
497  `marca` varchar(255) DEFAULT NULL,
498  `maximoestoque` int(11) DEFAULT NULL,
499  `minimoestoque` int(11) DEFAULT NULL,
500  `referencia` varchar(255) DEFAULT NULL,
501  `unidade` varchar(255) DEFAULT NULL,
502  `idEmpresa` int(11) DEFAULT NULL,
503  `idFamilia` int(11) DEFAULT NULL,
504  `idGrupo` int(11) DEFAULT NULL,
505  PRIMARY KEY (`idMaterial`),
506  KEY `FK11D3652764C4C7DC` (`idEmpresa`),
507  KEY `FK11D36527DC122E60` (`idFamilia`),
508  KEY `FK11D36527BA7C98FC` (`idGrupo`),
509  CONSTRAINT `FK11D3652764C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
510  CONSTRAINT `FK11D36527BA7C98FC` FOREIGN KEY (`idGrupo`) REFERENCES `grupo` (`idGrupo`),
511  CONSTRAINT `FK11D36527DC122E60` FOREIGN KEY (`idFamilia`) REFERENCES `familia` (`idFamilia`)
512) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
513/*!40101 SET character_set_client = @saved_cs_client */;
514
515--
516-- Dumping data for table `material`
517--
518
519LOCK TABLES `material` WRITE;
520/*!40000 ALTER TABLE `material` DISABLE KEYS */;
521INSERT INTO `material` VALUES (1,'S','DRONE','','',NULL,NULL,'','PC',1,1,1);
522/*!40000 ALTER TABLE `material` ENABLE KEYS */;
523UNLOCK TABLES;
524
525--
526-- Table structure for table `material_almox`
527--
528
529DROP TABLE IF EXISTS `material_almox`;
530/*!40101 SET @saved_cs_client     = @@character_set_client */;
531 SET character_set_client = utf8mb4 ;
532CREATE TABLE `material_almox` (
533  `idMaterial_almox` int(11) NOT NULL AUTO_INCREMENT,
534  `id_almoxarifado` int(11) DEFAULT NULL,
535  `id_empresa` int(11) DEFAULT NULL,
536  `id_material` int(11) DEFAULT NULL,
537  PRIMARY KEY (`idMaterial_almox`),
538  KEY `FKB3ACB5F3299D5685` (`id_almoxarifado`),
539  KEY `FKB3ACB5F3AA282233` (`id_empresa`),
540  KEY `FKB3ACB5F31C2F30A1` (`id_material`),
541  CONSTRAINT `FKB3ACB5F31C2F30A1` FOREIGN KEY (`id_material`) REFERENCES `material` (`idMaterial`),
542  CONSTRAINT `FKB3ACB5F3299D5685` FOREIGN KEY (`id_almoxarifado`) REFERENCES `almoxarifado` (`idAlmoxarifado`),
543  CONSTRAINT `FKB3ACB5F3AA282233` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`idEmpresa`)
544) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
545/*!40101 SET character_set_client = @saved_cs_client */;
546
547--
548-- Dumping data for table `material_almox`
549--
550
551LOCK TABLES `material_almox` WRITE;
552/*!40000 ALTER TABLE `material_almox` DISABLE KEYS */;
553INSERT INTO `material_almox` VALUES (3,1,1,1);
554/*!40000 ALTER TABLE `material_almox` ENABLE KEYS */;
555UNLOCK TABLES;
556
557--
558-- Table structure for table `municipio`
559--
560
561DROP TABLE IF EXISTS `municipio`;
562/*!40101 SET @saved_cs_client     = @@character_set_client */;
563 SET character_set_client = utf8mb4 ;
564CREATE TABLE `municipio` (
565  `idMunicipio` int(11) NOT NULL AUTO_INCREMENT,
566  `descmunicipio` varchar(255) DEFAULT NULL,
567  `estado` varchar(255) DEFAULT NULL,
568  PRIMARY KEY (`idMunicipio`)
569) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
570/*!40101 SET character_set_client = @saved_cs_client */;
571
572--
573-- Dumping data for table `municipio`
574--
575
576LOCK TABLES `municipio` WRITE;
577/*!40000 ALTER TABLE `municipio` DISABLE KEYS */;
578INSERT INTO `municipio` VALUES (2,'ARIRANHA','SP');
579/*!40000 ALTER TABLE `municipio` ENABLE KEYS */;
580UNLOCK TABLES;
581
582--
583-- Table structure for table `nota_fiscal`
584--
585
586DROP TABLE IF EXISTS `nota_fiscal`;
587/*!40101 SET @saved_cs_client     = @@character_set_client */;
588 SET character_set_client = utf8mb4 ;
589CREATE TABLE `nota_fiscal` (
590  `idnota_fiscal` int(11) NOT NULL,
591  `cancelado` varchar(255) DEFAULT NULL,
592  `codtipdoc` varchar(255) DEFAULT NULL,
593  `data_cancelou` datetime DEFAULT NULL,
594  `dtemissao` datetime DEFAULT NULL,
595  `dtentrada` datetime DEFAULT NULL,
596  `dtmovhora` datetime DEFAULT NULL,
597  `idOrcamento` int(11) DEFAULT NULL,
598  `motivo_cancelou` varchar(255) DEFAULT NULL,
599  `numero` int(11) DEFAULT NULL,
600  `observacao` varchar(255) DEFAULT NULL,
601  `pedido_orcamento` varchar(255) DEFAULT NULL,
602  `serie` varchar(255) DEFAULT NULL,
603  `status_orcamento` varchar(255) DEFAULT NULL,
604  `tipo` varchar(255) DEFAULT NULL,
605  `validade_orcamento` datetime DEFAULT NULL,
606  `vlrdesconto` double DEFAULT NULL,
607  `vlrfrete` double DEFAULT NULL,
608  `valor_total` double DEFAULT NULL,
609  `idEmpresa` int(11) DEFAULT NULL,
610  `idPessoa` int(11) DEFAULT NULL,
611  `idUsuarioDigitou` varchar(255) DEFAULT NULL,
612  `idUsuarioCancelou` varchar(255) DEFAULT NULL,
613  `idPessoa_vendedor` int(11) DEFAULT NULL,
614  PRIMARY KEY (`idnota_fiscal`),
615  KEY `FKC6ECDF2F64C4C7DC` (`idEmpresa`),
616  KEY `FKC6ECDF2F6D36545A` (`idPessoa_vendedor`),
617  KEY `FKC6ECDF2F982DA8D8` (`idPessoa`),
618  CONSTRAINT `FKC6ECDF2F64C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
619  CONSTRAINT `FKC6ECDF2F6D36545A` FOREIGN KEY (`idPessoa_vendedor`) REFERENCES `pessoa` (`idPessoa`),
620  CONSTRAINT `FKC6ECDF2F982DA8D8` FOREIGN KEY (`idPessoa`) REFERENCES `pessoa` (`idPessoa`)
621) ENGINE=InnoDB DEFAULT CHARSET=latin1;
622/*!40101 SET character_set_client = @saved_cs_client */;
623
624--
625-- Dumping data for table `nota_fiscal`
626--
627
628LOCK TABLES `nota_fiscal` WRITE;
629/*!40000 ALTER TABLE `nota_fiscal` DISABLE KEYS */;
630/*!40000 ALTER TABLE `nota_fiscal` ENABLE KEYS */;
631UNLOCK TABLES;
632
633--
634-- Table structure for table `nota_fiscal_itens`
635--
636
637DROP TABLE IF EXISTS `nota_fiscal_itens`;
638/*!40101 SET @saved_cs_client     = @@character_set_client */;
639 SET character_set_client = utf8mb4 ;
640CREATE TABLE `nota_fiscal_itens` (
641  `idnota_fiscal_itens` int(11) NOT NULL,
642  `qtdemov` double DEFAULT NULL,
643  `vlrdesconto` double DEFAULT NULL,
644  `vlrtotal` double DEFAULT NULL,
645  `vlrunit` double DEFAULT NULL,
646  `idAlmoxarifado` int(11) DEFAULT NULL,
647  `idEmpresa` int(11) DEFAULT NULL,
648  `idMaterial` int(11) DEFAULT NULL,
649  `idNotaFiscal` int(11) DEFAULT NULL,
650  PRIMARY KEY (`idnota_fiscal_itens`),
651  KEY `FKD1E8CACF6082D27C` (`idAlmoxarifado`),
652  KEY `FKD1E8CACF64C4C7DC` (`idEmpresa`),
653  KEY `FKD1E8CACFAD852DE7` (`idNotaFiscal`),
654  KEY `FKD1E8CACFB5274018` (`idMaterial`),
655  CONSTRAINT `FKD1E8CACF6082D27C` FOREIGN KEY (`idAlmoxarifado`) REFERENCES `almoxarifado` (`idAlmoxarifado`),
656  CONSTRAINT `FKD1E8CACF64C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
657  CONSTRAINT `FKD1E8CACFAD852DE7` FOREIGN KEY (`idNotaFiscal`) REFERENCES `nota_fiscal` (`idnota_fiscal`),
658  CONSTRAINT `FKD1E8CACFB5274018` FOREIGN KEY (`idMaterial`) REFERENCES `material` (`idMaterial`)
659) ENGINE=InnoDB DEFAULT CHARSET=latin1;
660/*!40101 SET character_set_client = @saved_cs_client */;
661
662--
663-- Dumping data for table `nota_fiscal_itens`
664--
665
666LOCK TABLES `nota_fiscal_itens` WRITE;
667/*!40000 ALTER TABLE `nota_fiscal_itens` DISABLE KEYS */;
668/*!40000 ALTER TABLE `nota_fiscal_itens` ENABLE KEYS */;
669UNLOCK TABLES;
670
671--
672-- Table structure for table `nota_fiscal_parcelas`
673--
674
675DROP TABLE IF EXISTS `nota_fiscal_parcelas`;
676/*!40101 SET @saved_cs_client     = @@character_set_client */;
677 SET character_set_client = utf8mb4 ;
678CREATE TABLE `nota_fiscal_parcelas` (
679  `idnota_fiscal_parcelas` int(11) NOT NULL,
680  `dtvencimento` datetime DEFAULT NULL,
681  `forma_pagamento` varchar(255) DEFAULT NULL,
682  `nrparcela` int(11) DEFAULT NULL,
683  `valor` double DEFAULT NULL,
684  `id_caixa` int(11) DEFAULT NULL,
685  `idNotaFiscal` int(11) DEFAULT NULL,
686  PRIMARY KEY (`idnota_fiscal_parcelas`),
687  KEY `FK60EA250BB8A4B27E` (`id_caixa`),
688  KEY `FK60EA250BAD852DE7` (`idNotaFiscal`),
689  CONSTRAINT `FK60EA250BAD852DE7` FOREIGN KEY (`idNotaFiscal`) REFERENCES `nota_fiscal` (`idnota_fiscal`),
690  CONSTRAINT `FK60EA250BB8A4B27E` FOREIGN KEY (`id_caixa`) REFERENCES `caixa` (`idCaixa`)
691) ENGINE=InnoDB DEFAULT CHARSET=latin1;
692/*!40101 SET character_set_client = @saved_cs_client */;
693
694--
695-- Dumping data for table `nota_fiscal_parcelas`
696--
697
698LOCK TABLES `nota_fiscal_parcelas` WRITE;
699/*!40000 ALTER TABLE `nota_fiscal_parcelas` DISABLE KEYS */;
700/*!40000 ALTER TABLE `nota_fiscal_parcelas` ENABLE KEYS */;
701UNLOCK TABLES;
702
703--
704-- Table structure for table `nota_fiscal_servicos`
705--
706
707DROP TABLE IF EXISTS `nota_fiscal_servicos`;
708/*!40101 SET @saved_cs_client     = @@character_set_client */;
709 SET character_set_client = utf8mb4 ;
710CREATE TABLE `nota_fiscal_servicos` (
711  `idnotafiscalservicos` int(11) NOT NULL,
712  `descricao_completa` varchar(255) DEFAULT NULL,
713  `qtde` double DEFAULT NULL,
714  `vlrtotal` double DEFAULT NULL,
715  `vlrunit` double DEFAULT NULL,
716  `idMaterial` int(11) DEFAULT NULL,
717  `idNotaFiscal` int(11) DEFAULT NULL,
718  PRIMARY KEY (`idnotafiscalservicos`),
719  KEY `FK6D3408A4AD852DE7` (`idNotaFiscal`),
720  KEY `FK6D3408A4B5274018` (`idMaterial`),
721  CONSTRAINT `FK6D3408A4AD852DE7` FOREIGN KEY (`idNotaFiscal`) REFERENCES `nota_fiscal` (`idnota_fiscal`),
722  CONSTRAINT `FK6D3408A4B5274018` FOREIGN KEY (`idMaterial`) REFERENCES `material` (`idMaterial`)
723) ENGINE=InnoDB DEFAULT CHARSET=latin1;
724/*!40101 SET character_set_client = @saved_cs_client */;
725
726--
727-- Dumping data for table `nota_fiscal_servicos`
728--
729
730LOCK TABLES `nota_fiscal_servicos` WRITE;
731/*!40000 ALTER TABLE `nota_fiscal_servicos` DISABLE KEYS */;
732/*!40000 ALTER TABLE `nota_fiscal_servicos` ENABLE KEYS */;
733UNLOCK TABLES;
734
735--
736-- Table structure for table `pessoa`
737--
738
739DROP TABLE IF EXISTS `pessoa`;
740/*!40101 SET @saved_cs_client     = @@character_set_client */;
741 SET character_set_client = utf8mb4 ;
742CREATE TABLE `pessoa` (
743  `idPessoa` int(11) NOT NULL AUTO_INCREMENT,
744  `bairro` varchar(255) DEFAULT NULL,
745  `cep` varchar(255) DEFAULT NULL,
746  `cnpj` varchar(255) DEFAULT NULL,
747  `complemento` varchar(255) DEFAULT NULL,
748  `cpf` varchar(255) DEFAULT NULL,
749  `e_mail` varchar(255) DEFAULT NULL,
750  `endereco` varchar(255) DEFAULT NULL,
751  `fone_celular` varchar(255) DEFAULT NULL,
752  `fone_fixo` varchar(255) DEFAULT NULL,
753  `inscricaoestadual` varchar(255) DEFAULT NULL,
754  `numero` int(11) DEFAULT NULL,
755  `razaosocial` varchar(255) DEFAULT NULL,
756  `rg` varchar(255) DEFAULT NULL,
757  `tipoinscricao` varchar(255) DEFAULT NULL,
758  `tipopessoa` varchar(255) DEFAULT NULL,
759  `idEmpresa` int(11) DEFAULT NULL,
760  `idmunicipio` int(11) DEFAULT NULL,
761  PRIMARY KEY (`idPessoa`),
762  KEY `FKC4E40FA764C4C7DC` (`idEmpresa`),
763  KEY `FKC4E40FA7B8CD4A80` (`idmunicipio`),
764  CONSTRAINT `FKC4E40FA764C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
765  CONSTRAINT `FKC4E40FA7B8CD4A80` FOREIGN KEY (`idmunicipio`) REFERENCES `municipio` (`idMunicipio`)
766) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
767/*!40101 SET character_set_client = @saved_cs_client */;
768
769--
770-- Dumping data for table `pessoa`
771--
772
773LOCK TABLES `pessoa` WRITE;
774/*!40000 ALTER TABLE `pessoa` DISABLE KEYS */;
775INSERT INTO `pessoa` VALUES (1,'','15960-000','49.911.589/0004-11','CASA',NULL,'','RUA ALBINO BRIGHENTI','','','',633,'PEDRO MANOEL DE ANDRADE - ME',NULL,'J','F',1,2),(4,'JD SAO DOMINGOS','15960-000',NULL,'','169.809.358-60','LGALHASSI@GMAIL.COM','ALBINO BRIGHENTI','(17) 98133-7763','',NULL,633,'LUIS ALESSANDRO GALHASSI','267011209','F','V',1,2);
776/*!40000 ALTER TABLE `pessoa` ENABLE KEYS */;
777UNLOCK TABLES;
778
779--
780-- Table structure for table `plano_custo`
781--
782
783DROP TABLE IF EXISTS `plano_custo`;
784/*!40101 SET @saved_cs_client     = @@character_set_client */;
785 SET character_set_client = utf8mb4 ;
786CREATE TABLE `plano_custo` (
787  `idplano_custo` varchar(8) NOT NULL,
788  `Descricao` varchar(45) NOT NULL,
789  `Receita_Despesa` varchar(1) DEFAULT NULL,
790  `analitico_sintetico` varchar(255) DEFAULT NULL,
791  PRIMARY KEY (`idplano_custo`)
792) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
793/*!40101 SET character_set_client = @saved_cs_client */;
794
795--
796-- Dumping data for table `plano_custo`
797--
798
799LOCK TABLES `plano_custo` WRITE;
800/*!40000 ALTER TABLE `plano_custo` DISABLE KEYS */;
801INSERT INTO `plano_custo` VALUES ('01','DESPESA','D','S'),('0101','ALUGUEL','D','A'),('0102','ENERGIA ELETRICA','D','A'),('02','RECEITA','R','S'),('0201','ALUGUEL DE DRONE','R','A');
802/*!40000 ALTER TABLE `plano_custo` ENABLE KEYS */;
803UNLOCK TABLES;
804
805--
806-- Table structure for table `requisicao_materiais`
807--
808
809DROP TABLE IF EXISTS `requisicao_materiais`;
810/*!40101 SET @saved_cs_client     = @@character_set_client */;
811 SET character_set_client = utf8mb4 ;
812CREATE TABLE `requisicao_materiais` (
813  `idrequisicao_materiais` int(11) NOT NULL AUTO_INCREMENT,
814  `dtmovhora` datetime DEFAULT NULL,
815  `dtreq` datetime DEFAULT NULL,
816  `nrreq` int(11) DEFAULT NULL,
817  `qtdereq` double DEFAULT NULL,
818  `vlrtotal` double DEFAULT NULL,
819  `vlrunit` double DEFAULT NULL,
820  `idAlmoxarifado` int(11) DEFAULT NULL,
821  `idEmpresa` int(11) DEFAULT NULL,
822  `idPessoaRequisitou` int(11) DEFAULT NULL,
823  `idMaterial` int(11) DEFAULT NULL,
824  PRIMARY KEY (`idrequisicao_materiais`),
825  KEY `FKF8ACA4596082D27C` (`idAlmoxarifado`),
826  KEY `FKF8ACA45964C4C7DC` (`idEmpresa`),
827  KEY `FKF8ACA45938C2612A` (`idPessoaRequisitou`),
828  KEY `FKF8ACA459B5274018` (`idMaterial`),
829  CONSTRAINT `FKF8ACA45938C2612A` FOREIGN KEY (`idPessoaRequisitou`) REFERENCES `pessoa` (`idPessoa`),
830  CONSTRAINT `FKF8ACA4596082D27C` FOREIGN KEY (`idAlmoxarifado`) REFERENCES `almoxarifado` (`idAlmoxarifado`),
831  CONSTRAINT `FKF8ACA45964C4C7DC` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
832  CONSTRAINT `FKF8ACA459B5274018` FOREIGN KEY (`idMaterial`) REFERENCES `material` (`idMaterial`)
833) ENGINE=InnoDB DEFAULT CHARSET=latin1;
834/*!40101 SET character_set_client = @saved_cs_client */;
835
836--
837-- Dumping data for table `requisicao_materiais`
838--
839
840LOCK TABLES `requisicao_materiais` WRITE;
841/*!40000 ALTER TABLE `requisicao_materiais` DISABLE KEYS */;
842/*!40000 ALTER TABLE `requisicao_materiais` ENABLE KEYS */;
843UNLOCK TABLES;
844
845--
846-- Table structure for table `sp_cab`
847--
848
849DROP TABLE IF EXISTS `sp_cab`;
850/*!40101 SET @saved_cs_client     = @@character_set_client */;
851 SET character_set_client = utf8mb4 ;
852CREATE TABLE `sp_cab` (
853  `idsp_cab` int(11) NOT NULL AUTO_INCREMENT,
854  `idEmpresa` int(11) DEFAULT NULL,
855  `numero` int(11) DEFAULT NULL,
856  `data` datetime DEFAULT NULL,
857  `dtvencimento` date DEFAULT NULL,
858  `pagar_receber` varchar(1) DEFAULT NULL,
859  `idPessoa` int(11) DEFAULT NULL,
860  `favorecido` varchar(200) DEFAULT NULL,
861  `observacao` varchar(200) DEFAULT NULL,
862  `valor` double DEFAULT NULL,
863  `idUsuario` int(11) DEFAULT NULL,
864  PRIMARY KEY (`idsp_cab`),
865  KEY `fk_sp_cab_empresa_idx` (`idEmpresa`),
866  KEY `fk_sp_cab_pessoa_idx` (`idPessoa`),
867  KEY `FKCA9446E2D30E3BE1` (`idUsuario`),
868  CONSTRAINT `FKCA9446E2D30E3BE1` FOREIGN KEY (`idUsuario`) REFERENCES `usuario` (`idusuario`),
869  CONSTRAINT `fk_sp_cab_empresa` FOREIGN KEY (`idEmpresa`) REFERENCES `empresa` (`idEmpresa`),
870  CONSTRAINT `fk_sp_cab_pessoa` FOREIGN KEY (`idPessoa`) REFERENCES `pessoa` (`idPessoa`)
871) ENGINE=InnoDB AUTO_INCREMENT=2075479320 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='		';
872/*!40101 SET character_set_client = @saved_cs_client */;
873
874--
875-- Dumping data for table `sp_cab`
876--
877
878LOCK TABLES `sp_cab` WRITE;
879/*!40000 ALTER TABLE `sp_cab` DISABLE KEYS */;
880INSERT INTO `sp_cab` VALUES (2075479315,1,949712550,'2020-01-31 16:50:15','2020-01-31','P',1,'PEDRO MANOEL DE ANDRADE - ME','TESTE',300,2),(2075479316,1,415682105,'2020-01-31 18:25:18','2020-01-31','P',1,'PEDRO MANOEL DE ANDRADE - ME','TESTE',1500,2),(2075479317,1,195605199,'2020-01-31 18:31:55','2020-01-31','P',1,'PEDRO MANOEL DE ANDRADE - ME','TESTANDO O SISTEMA',500,2),(2075479318,1,505377543,'2020-02-03 08:45:02','2020-02-03','P',4,'LUIS ALESSANDRO GALHASSI','',100,2),(2075479319,1,1268182375,'2020-02-03 12:46:45','2020-02-03','P',1,'PEDRO MANOEL DE ANDRADE - ME','TESTE',150000,2);
881/*!40000 ALTER TABLE `sp_cab` ENABLE KEYS */;
882UNLOCK TABLES;
883
884--
885-- Table structure for table `sp_item`
886--
887
888DROP TABLE IF EXISTS `sp_item`;
889/*!40101 SET @saved_cs_client     = @@character_set_client */;
890 SET character_set_client = utf8mb4 ;
891CREATE TABLE `sp_item` (
892  `idsp_item` int(11) NOT NULL AUTO_INCREMENT,
893  `id_sp_cab` int(11) DEFAULT NULL,
894  `valor` double DEFAULT NULL,
895  `observacao` varchar(200) DEFAULT NULL,
896  `id_plano_custo` varchar(8) DEFAULT NULL,
897  PRIMARY KEY (`idsp_item`),
898  KEY `fk_sp_item_custo_idx` (`id_plano_custo`),
899  KEY `fk_sp_item_id_cab_idx` (`id_sp_cab`),
900  CONSTRAINT `fk_sp_item_custo` FOREIGN KEY (`id_plano_custo`) REFERENCES `plano_custo` (`idplano_custo`),
901  CONSTRAINT `fk_sp_item_id_cab` FOREIGN KEY (`id_sp_cab`) REFERENCES `sp_cab` (`idsp_cab`)
902) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='	';
903/*!40101 SET character_set_client = @saved_cs_client */;
904
905--
906-- Dumping data for table `sp_item`
907--
908
909LOCK TABLES `sp_item` WRITE;
910/*!40000 ALTER TABLE `sp_item` DISABLE KEYS */;
911INSERT INTO `sp_item` VALUES (10,2075479315,100,'TESTE','0101'),(11,2075479315,200,'YESYE','0102'),(12,2075479316,1500,'TESTE','0101'),(13,2075479317,500,'TSTE','0102'),(14,2075479318,100,'TESTE','0101'),(15,2075479319,150000,'ALUGUEL ESCRITÓRIO','0101');
912/*!40000 ALTER TABLE `sp_item` ENABLE KEYS */;
913UNLOCK TABLES;
914
915--
916-- Table structure for table `sp_parcelas`
917--
918
919DROP TABLE IF EXISTS `sp_parcelas`;
920/*!40101 SET @saved_cs_client     = @@character_set_client */;
921 SET character_set_client = utf8mb4 ;
922CREATE TABLE `sp_parcelas` (
923  `idsp_parcelas` int(11) NOT NULL AUTO_INCREMENT,
924  `id_sp_cab` int(11) DEFAULT NULL,
925  `forma_pagamento` varchar(2) DEFAULT NULL,
926  `nrparcela` int(11) DEFAULT NULL,
927  `valor` double DEFAULT NULL,
928  `id_caixa` int(11) DEFAULT NULL,
929  PRIMARY KEY (`idsp_parcelas`),
930  KEY `id_sp_parcelas_caixa_idx` (`id_caixa`),
931  KEY `fk_sp_cab_id_idx` (`id_sp_cab`),
932  CONSTRAINT `fk_sp_cab_id` FOREIGN KEY (`id_sp_cab`) REFERENCES `sp_cab` (`idsp_cab`),
933  CONSTRAINT `id_sp_parcelas_caixa` FOREIGN KEY (`id_caixa`) REFERENCES `caixa` (`idCaixa`)
934) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
935/*!40101 SET character_set_client = @saved_cs_client */;
936
937--
938-- Dumping data for table `sp_parcelas`
939--
940
941LOCK TABLES `sp_parcelas` WRITE;
942/*!40000 ALTER TABLE `sp_parcelas` DISABLE KEYS */;
943/*!40000 ALTER TABLE `sp_parcelas` ENABLE KEYS */;
944UNLOCK TABLES;
945
946--
947-- Table structure for table `tabela_preco`
948--
949
950DROP TABLE IF EXISTS `tabela_preco`;
951/*!40101 SET @saved_cs_client     = @@character_set_client */;
952 SET character_set_client = utf8mb4 ;
953CREATE TABLE `tabela_preco` (
954  `idtabela_preco` int(11) NOT NULL AUTO_INCREMENT,
955  `data` datetime DEFAULT NULL,
956  `data_gerou` datetime DEFAULT NULL,
957  `preco_custo` double DEFAULT NULL,
958  `preco_venda` double DEFAULT NULL,
959  `usuario` varchar(255) DEFAULT NULL,
960  `id_empresa` int(11) DEFAULT NULL,
961  `id_material` int(11) DEFAULT NULL,
962  PRIMARY KEY (`idtabela_preco`),
963  KEY `FK70FB2A75AA282233` (`id_empresa`),
964  KEY `FK70FB2A751C2F30A1` (`id_material`),
965  CONSTRAINT `FK70FB2A751C2F30A1` FOREIGN KEY (`id_material`) REFERENCES `material` (`idMaterial`),
966  CONSTRAINT `FK70FB2A75AA282233` FOREIGN KEY (`id_empresa`) REFERENCES `empresa` (`idEmpresa`)
967) ENGINE=InnoDB DEFAULT CHARSET=latin1;
968/*!40101 SET character_set_client = @saved_cs_client */;
969
970--
971-- Dumping data for table `tabela_preco`
972--
973
974LOCK TABLES `tabela_preco` WRITE;
975/*!40000 ALTER TABLE `tabela_preco` DISABLE KEYS */;
976/*!40000 ALTER TABLE `tabela_preco` ENABLE KEYS */;
977UNLOCK TABLES;
978
979--
980-- Table structure for table `usuario`
981--
982
983DROP TABLE IF EXISTS `usuario`;
984/*!40101 SET @saved_cs_client     = @@character_set_client */;
985 SET character_set_client = utf8mb4 ;
986CREATE TABLE `usuario` (
987  `idusuario` int(11) NOT NULL AUTO_INCREMENT,
988  `ativo` varchar(255) DEFAULT NULL,
989  `senha` varchar(255) DEFAULT NULL,
990  `usuario` varchar(255) DEFAULT NULL,
991  PRIMARY KEY (`idusuario`)
992) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
993/*!40101 SET character_set_client = @saved_cs_client */;
994
995--
996-- Dumping data for table `usuario`
997--
998
999LOCK TABLES `usuario` WRITE;
1000/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
1001INSERT INTO `usuario` VALUES (1,'N','123','MASSAROTTI'),(2,'S','123','GIM'),(3,'S','041299','ELIELCENA'),(5,'S','1234','JOSEBRAS');
1002/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
1003UNLOCK TABLES;
1004
1005--
1006-- Table structure for table `viza_aplicacao`
1007--
1008
1009DROP TABLE IF EXISTS `viza_aplicacao`;
1010/*!40101 SET @saved_cs_client     = @@character_set_client */;
1011 SET character_set_client = utf8mb4 ;
1012CREATE TABLE `viza_aplicacao` (
1013  `id` int(11) NOT NULL AUTO_INCREMENT,
1014  `ativo` varchar(255) DEFAULT NULL,
1015  `descricao` varchar(255) DEFAULT NULL,
1016  `pagina` varchar(255) DEFAULT NULL,
1017  `id_viza_tipo` int(11) DEFAULT NULL,
1018  PRIMARY KEY (`id`),
1019  KEY `FK56EA57627714EC6E` (`id_viza_tipo`),
1020  CONSTRAINT `FK56EA57627714EC6E` FOREIGN KEY (`id_viza_tipo`) REFERENCES `viza_tipo` (`id`)
1021) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
1022/*!40101 SET character_set_client = @saved_cs_client */;
1023
1024--
1025-- Dumping data for table `viza_aplicacao`
1026--
1027
1028LOCK TABLES `viza_aplicacao` WRITE;
1029/*!40000 ALTER TABLE `viza_aplicacao` DISABLE KEYS */;
1030INSERT INTO `viza_aplicacao` VALUES (1,'S','Aplicação','/apps/infraestrutura/aplicacao/aplicacao.jsf',1),(3,'S','Pessoa','/apps/pessoa/pessoa.jsf',3),(4,'S','Usuário','/apps/user/usuario.jsf',1),(5,'S','Almoxarifado','/apps/almoxarifado/almoxarifado.jsf',3),(6,'S','Grupo','/apps/grupo/grupo.jsf',3),(7,'S','Familia','/apps/familia/familia.jsf',3),(8,'S','Produtos','/apps/material/material.jsf',3),(9,'S','Municipio','/apps/municipio/municipio.jsf',3),(10,'S','Permissão Acesso','/apps/seguranca/permissaoAcesso.jsf',4),(15,'S','Aprovação','/apps/inventario/aprovarInventario.jsf',6),(16,'S','Contagem','/apps/inventario/digitacaoContagem.jsf',7),(17,'S','Seleção','/apps/inventario/selecionarInventario.jsf',6),(19,'S','Vendas','/apps/venda/venda.jsf',9),(22,'S','Grafico de Vendas','/apps/venda/vendaGrafico.jsf',11),(23,'S','Nota Fiscal Entrada','/apps/notaFiscal/notaFiscal.jsf',12),(24,'S','Cadastro de Caixa','/apps/caixa/caixa.jsf',13),(25,'S','Abertura do Caixa','/apps/caixa/caixaAbertura.jsf',13),(26,'S','Movimento do Caixa','/apps/caixa/caixaMovimento.jsf',13),(27,'S','Fechamento do Caixa','/apps/caixa/caixaFechamento.jsf',13),(28,'S','Consulta Movimento','/apps/caixa/consultaMovimento.jsf',14),(30,'S','Tabela de Preços','/apps/material/materialTabelaPreco.jsf',3),(31,'S','Consulta Estoque','/apps/material/consultaEstoque.jsf',15),(32,'S','Gráfico Tipo Recebimento','/apps/venda/vendaTipoPagamento.jsf',11),(33,'S','Alerta de Estoque','/apps/material/alertaEstoque.jsf',15),(34,'S','Vendas por Período','/apps/venda/consultaVendas.jsf',11),(35,'S','Vendas por Vendedor','/apps/venda/vendaVendedor.jsf',11),(36,'S','Requisição de Produtos','/apps/estoque/requisicaoMaterial.jsf',16),(37,'S','Devolução de Produtos','/apps/estoque/devolucaoAlmoxarifado.jsf',16),(38,'S','Cancelar Vendas','/apps/venda/cancelarVendas.jsf',9),(39,'S','Movimentação de Estoque','/apps/estoque/movimentacaoEstoque.jsf',15),(40,'S','Orçamentos por Período','/apps/venda/consultaOrcamentos.jsf',11),(41,'S','Baixa de Pagamento / Recebimento','/apps/financeiro/baixaFinanceiro.jsf',2),(42,'S','Pagina Index','/viza/index.jsf',1),(43,'S','Movimento Financeiro','/apps/financeiro/consultaFinanceiro.jsf',17),(44,'S','Entrada Nota Fiscal','/apps/notaFiscal/consultaNotaFiscalEntrada.jsf',18),(45,'S','Lançamento de Contas Diversas','/apps/financeiro/contas.jsf',2),(46,'S','Cadastro Plano de Custos','/apps/financeiro/planoCusto.jsf',2);
1031/*!40000 ALTER TABLE `viza_aplicacao` ENABLE KEYS */;
1032UNLOCK TABLES;
1033
1034--
1035-- Table structure for table `viza_regra_acesso`
1036--
1037
1038DROP TABLE IF EXISTS `viza_regra_acesso`;
1039/*!40101 SET @saved_cs_client     = @@character_set_client */;
1040 SET character_set_client = utf8mb4 ;
1041CREATE TABLE `viza_regra_acesso` (
1042  `id` int(11) NOT NULL AUTO_INCREMENT,
1043  `id_aplicacao` int(11) DEFAULT NULL,
1044  `id_usuario` int(11) DEFAULT NULL,
1045  PRIMARY KEY (`id`),
1046  KEY `FKC1A0B3AD18719638` (`id_usuario`),
1047  CONSTRAINT `FKC1A0B3AD18719638` FOREIGN KEY (`id_usuario`) REFERENCES `usuario` (`idusuario`)
1048) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=latin1;
1049/*!40101 SET character_set_client = @saved_cs_client */;
1050
1051--
1052-- Dumping data for table `viza_regra_acesso`
1053--
1054
1055LOCK TABLES `viza_regra_acesso` WRITE;
1056/*!40000 ALTER TABLE `viza_regra_acesso` DISABLE KEYS */;
1057INSERT INTO `viza_regra_acesso` VALUES (1,10,3),(2,25,3),(3,33,3),(4,5,3),(5,1,3),(6,15,3),(7,41,3),(8,24,3),(9,38,3),(10,31,3),(11,28,3),(12,16,3),(13,37,3),(14,44,3),(15,7,3),(16,27,3),(17,22,3),(18,32,3),(19,6,3),(20,18,3),(21,39,3),(22,26,3),(23,43,3),(24,9,3),(25,23,3),(26,40,3),(27,42,3),(28,3,3),(29,8,3),(30,36,3),(31,17,3),(32,30,3),(33,4,3),(34,19,3),(35,34,3),(36,35,3),(37,25,2),(38,33,2),(39,5,2),(40,1,2),(41,15,2),(42,41,2),(43,24,2),(44,38,2),(45,31,2),(46,28,2),(47,16,2),(48,37,2),(49,44,2),(50,7,2),(51,27,2),(52,22,2),(53,32,2),(54,6,2),(55,18,2),(56,39,2),(57,26,2),(58,43,2),(59,9,2),(60,23,2),(61,40,2),(62,42,2),(63,10,2),(64,3,2),(65,8,2),(66,36,2),(67,17,2),(68,30,2),(69,4,2),(70,19,2),(71,34,2),(72,35,2),(73,25,1),(74,33,1),(75,5,1),(76,1,1),(77,15,1),(78,41,1),(79,24,1),(80,38,1),(81,31,1),(82,28,1),(83,16,1),(84,37,1),(85,44,1),(86,7,1),(87,27,1),(88,22,1),(89,32,1),(90,6,1),(91,18,1),(92,39,1),(93,26,1),(94,43,1),(95,9,1),(96,23,1),(97,40,1),(98,42,1),(99,10,1),(100,3,1),(101,8,1),(102,36,1),(103,17,1),(104,30,1),(105,4,1),(106,19,1),(107,34,1),(108,35,1),(109,38,5),(110,22,5),(111,32,5),(112,40,5),(113,19,5),(114,34,5),(115,35,5),(116,25,5),(117,41,5),(118,24,5),(119,28,5),(120,27,5),(121,26,5),(122,43,5),(123,44,5),(124,23,5),(125,1,5),(126,42,5),(127,10,5),(128,4,5),(129,33,5),(130,5,5),(131,15,5),(132,31,5),(133,16,5),(134,37,5),(135,7,5),(136,6,5),(137,18,5),(138,39,5),(139,9,5),(140,3,5),(141,8,5),(142,36,5),(143,17,5),(144,30,5),(145,45,2),(146,46,2);
1058/*!40000 ALTER TABLE `viza_regra_acesso` ENABLE KEYS */;
1059UNLOCK TABLES;
1060
1061--
1062-- Table structure for table `viza_setor`
1063--
1064
1065DROP TABLE IF EXISTS `viza_setor`;
1066/*!40101 SET @saved_cs_client     = @@character_set_client */;
1067 SET character_set_client = utf8mb4 ;
1068CREATE TABLE `viza_setor` (
1069  `id` int(11) NOT NULL,
1070  `descricao` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
1071  `ordem` int(11) DEFAULT NULL,
1072  PRIMARY KEY (`id`)
1073) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1074/*!40101 SET character_set_client = @saved_cs_client */;
1075
1076--
1077-- Dumping data for table `viza_setor`
1078--
1079
1080LOCK TABLES `viza_setor` WRITE;
1081/*!40000 ALTER TABLE `viza_setor` DISABLE KEYS */;
1082INSERT INTO `viza_setor` VALUES (1,'Painel de Controle',1),(2,'Financeiro',2),(3,'Suprimentos',3),(4,'Comercial',4),(5,'Fiscal',5);
1083/*!40000 ALTER TABLE `viza_setor` ENABLE KEYS */;
1084UNLOCK TABLES;
1085
1086--
1087-- Table structure for table `viza_sistema`
1088--
1089
1090DROP TABLE IF EXISTS `viza_sistema`;
1091/*!40101 SET @saved_cs_client     = @@character_set_client */;
1092 SET character_set_client = utf8mb4 ;
1093CREATE TABLE `viza_sistema` (
1094  `id` int(11) NOT NULL,
1095  `descricao` varchar(255) DEFAULT NULL,
1096  `id_viza_setor` int(11) DEFAULT NULL,
1097  PRIMARY KEY (`id`),
1098  KEY `FK405173FDA3B103C7` (`id_viza_setor`),
1099  CONSTRAINT `FK405173FDA3B103C7` FOREIGN KEY (`id_viza_setor`) REFERENCES `viza_setor` (`id`)
1100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1101/*!40101 SET character_set_client = @saved_cs_client */;
1102
1103--
1104-- Dumping data for table `viza_sistema`
1105--
1106
1107LOCK TABLES `viza_sistema` WRITE;
1108/*!40000 ALTER TABLE `viza_sistema` DISABLE KEYS */;
1109INSERT INTO `viza_sistema` VALUES (1,'Segurança',1),(2,'Contas a Pagar/Receber',2),(3,'Materiais',3),(4,'Inventario',3),(5,'Vendas',4),(7,'Nota Fiscal',5),(8,'Caixa',2),(9,'Estoque',3);
1110/*!40000 ALTER TABLE `viza_sistema` ENABLE KEYS */;
1111UNLOCK TABLES;
1112
1113--
1114-- Table structure for table `viza_tipo`
1115--
1116
1117DROP TABLE IF EXISTS `viza_tipo`;
1118/*!40101 SET @saved_cs_client     = @@character_set_client */;
1119 SET character_set_client = utf8mb4 ;
1120CREATE TABLE `viza_tipo` (
1121  `id` int(11) NOT NULL,
1122  `descricao` varchar(255) DEFAULT NULL,
1123  `id_viza_sistema` int(11) DEFAULT NULL,
1124  PRIMARY KEY (`id`),
1125  KEY `FKD395EF39814B4B44` (`id_viza_sistema`),
1126  CONSTRAINT `FKD395EF39814B4B44` FOREIGN KEY (`id_viza_sistema`) REFERENCES `viza_sistema` (`id`)
1127) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1128/*!40101 SET character_set_client = @saved_cs_client */;
1129
1130--
1131-- Dumping data for table `viza_tipo`
1132--
1133
1134LOCK TABLES `viza_tipo` WRITE;
1135/*!40000 ALTER TABLE `viza_tipo` DISABLE KEYS */;
1136INSERT INTO `viza_tipo` VALUES (1,'Cadastro',1),(2,'Manutenção',2),(3,'Cadastro',3),(4,'Manutenção',1),(6,'Manutenção',4),(7,'Digitação',4),(9,'Manutenção',5),(11,'Consulta',5),(12,'Digitação',7),(13,'Manutenção',8),(14,'Consulta',8),(15,'Consulta',9),(16,'Digitação',9),(17,'Consulta',2),(18,'Consulta',7);
1137/*!40000 ALTER TABLE `viza_tipo` ENABLE KEYS */;
1138UNLOCK TABLES;
1139/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1140
1141/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1142/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1143/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1144/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1145/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1146/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1147/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1148
1149-- Dump completed on 2020-02-03 18:24:15