· 7 years ago · Nov 12, 2018, 08:50 PM
1CREATE DATABASE IF NOT EXISTS `all` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `all`;
3-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
4--
5-- Host: localhost Database: all
6-- ------------------------------------------------------
7-- Server version 5.7.14
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/*!40101 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 `notafiscal`
22--
23
24DROP TABLE IF EXISTS `notafiscal`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `notafiscal` (
28 `id_nf` int(11) NOT NULL,
29 `data_emissao` date DEFAULT NULL,
30 `numero` varchar(45) DEFAULT NULL,
31 `cfop` int(11) DEFAULT NULL,
32 `valor_total` float DEFAULT NULL,
33 `dados_adicionais` varchar(200) DEFAULT NULL,
34 `uf` char(2) DEFAULT NULL,
35 `chave` varchar(100) DEFAULT NULL,
36 `status` bit(1) DEFAULT NULL,
37 PRIMARY KEY (`id_nf`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Table structure for table `notafiscal_saida`
43--
44
45DROP TABLE IF EXISTS `notafiscal_saida`;
46/*!40101 SET @saved_cs_client = @@character_set_client */;
47/*!40101 SET character_set_client = utf8 */;
48CREATE TABLE `notafiscal_saida` (
49 `data_emissao` date DEFAULT NULL,
50 `id_nf` int(11) DEFAULT NULL,
51 `cfop` int(11) DEFAULT NULL,
52 `valor_total` float DEFAULT NULL,
53 `dados_adicionais` varchar(40) DEFAULT NULL,
54 `estado` varchar(40) DEFAULT NULL,
55 `serie` varchar(40) DEFAULT NULL,
56 `insc_estadual` varchar(40) DEFAULT NULL,
57 `cnpj` varchar(14) DEFAULT NULL,
58 `cpf` varchar(11) DEFAULT NULL,
59 `val_icms` float DEFAULT NULL,
60 `val_ipi` float DEFAULT NULL,
61 `natureza_op` varchar(40) DEFAULT NULL,
62 `id_nfsaida` int(11) DEFAULT NULL,
63 `cod_contabil` varchar(35) DEFAULT NULL,
64 `procedencia` varchar(100) DEFAULT NULL,
65 `emitente` varchar(100) DEFAULT NULL
66) ENGINE=InnoDB DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Table structure for table `notafiscal_servico`
71--
72
73DROP TABLE IF EXISTS `notafiscal_servico`;
74/*!40101 SET @saved_cs_client = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `notafiscal_servico` (
77 `data_emissao` date DEFAULT NULL,
78 `cfop` varchar(4) DEFAULT NULL,
79 `valor_total` float DEFAULT NULL,
80 `dados_adicionais` varchar(40) DEFAULT NULL,
81 `estado` varchar(40) DEFAULT NULL,
82 `serie` bit(1) DEFAULT NULL,
83 `insc_estadual` varchar(40) DEFAULT NULL,
84 `cnpj` varchar(14) DEFAULT NULL,
85 `val_iss` float DEFAULT NULL,
86 `id_nfservico` int(11) DEFAULT NULL,
87 `id_nf` int(11) DEFAULT NULL
88) ENGINE=InnoDB DEFAULT CHARSET=latin1;
89/*!40101 SET character_set_client = @saved_cs_client */;
90
91--
92-- Table structure for table `produto_nf`
93--
94
95DROP TABLE IF EXISTS `produto_nf`;
96/*!40101 SET @saved_cs_client = @@character_set_client */;
97/*!40101 SET character_set_client = utf8 */;
98CREATE TABLE `produto_nf` (
99 `nome` varchar(40) DEFAULT NULL,
100 `qtd_item` int(11) DEFAULT NULL,
101 `valor_total` float DEFAULT NULL,
102 `id_produto` int(11) DEFAULT NULL,
103 `valor_icms` float DEFAULT NULL,
104 `valor_ipi` float DEFAULT NULL
105) ENGINE=InnoDB DEFAULT CHARSET=latin1;
106/*!40101 SET character_set_client = @saved_cs_client */;
107
108--
109-- Table structure for table `produtonota`
110--
111
112DROP TABLE IF EXISTS `produtonota`;
113/*!40101 SET @saved_cs_client = @@character_set_client */;
114/*!40101 SET character_set_client = utf8 */;
115CREATE TABLE `produtonota` (
116 `nome` varchar(40) DEFAULT NULL,
117 `qtd_item` int(11) DEFAULT NULL,
118 `valor_total` float DEFAULT NULL,
119 `id_produto` int(11) DEFAULT NULL,
120 `valor_unitario` float DEFAULT NULL
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Table structure for table `servico_nf`
126--
127
128DROP TABLE IF EXISTS `servico_nf`;
129/*!40101 SET @saved_cs_client = @@character_set_client */;
130/*!40101 SET character_set_client = utf8 */;
131CREATE TABLE `servico_nf` (
132 `id_servico` int(11) DEFAULT NULL,
133 `valor` float DEFAULT NULL,
134 `descricao` varchar(40) DEFAULT NULL,
135 `nome` varchar(40) DEFAULT NULL,
136 `valor_iss` float DEFAULT NULL,
137 `valor_unitario` float DEFAULT NULL,
138 `meses` int(11) DEFAULT NULL,
139 `id_nfservico` int(11) DEFAULT NULL,
140 `servico_nfcol` varchar(45) DEFAULT NULL,
141 `id_nf` int(11) DEFAULT NULL
142) ENGINE=InnoDB DEFAULT CHARSET=latin1;
143/*!40101 SET character_set_client = @saved_cs_client */;
144
145--
146-- Table structure for table `serviconota`
147--
148
149DROP TABLE IF EXISTS `serviconota`;
150/*!40101 SET @saved_cs_client = @@character_set_client */;
151/*!40101 SET character_set_client = utf8 */;
152CREATE TABLE `serviconota` (
153 `id_servico` int(11) NOT NULL,
154 `valor_total` float DEFAULT NULL,
155 `valor_unitario` float DEFAULT NULL,
156 `descricao` varchar(45) DEFAULT NULL,
157 `nome` varchar(45) DEFAULT NULL,
158 `valor_iss` float DEFAULT NULL,
159 `mes` int(11) DEFAULT NULL,
160 PRIMARY KEY (`id_servico`)
161) ENGINE=InnoDB DEFAULT CHARSET=latin1;
162/*!40101 SET character_set_client = @saved_cs_client */;
163
164--
165-- Table structure for table `tb_centro_custo`
166--
167
168DROP TABLE IF EXISTS `tb_centro_custo`;
169/*!40101 SET @saved_cs_client = @@character_set_client */;
170/*!40101 SET character_set_client = utf8 */;
171CREATE TABLE `tb_centro_custo` (
172 `cnpj` varchar(14) NOT NULL,
173 `razao_social` varchar(45) DEFAULT NULL,
174 `fantasia` varchar(45) DEFAULT NULL,
175 `longradouro` varchar(45) DEFAULT NULL,
176 `nro` int(11) DEFAULT NULL,
177 `bairro` varchar(45) DEFAULT NULL,
178 `municipio` varchar(45) DEFAULT NULL,
179 `estado` varchar(45) DEFAULT NULL,
180 `cep` varchar(10) DEFAULT NULL,
181 `telefone` varchar(45) DEFAULT NULL,
182 `inscricao_estadual` varchar(45) DEFAULT NULL,
183 `inscricao_municipal` varchar(45) DEFAULT NULL,
184 PRIMARY KEY (`cnpj`)
185) ENGINE=InnoDB DEFAULT CHARSET=latin1;
186/*!40101 SET character_set_client = @saved_cs_client */;
187
188--
189-- Table structure for table `tb_cliente_fisico`
190--
191
192DROP TABLE IF EXISTS `tb_cliente_fisico`;
193/*!40101 SET @saved_cs_client = @@character_set_client */;
194/*!40101 SET character_set_client = utf8 */;
195CREATE TABLE `tb_cliente_fisico` (
196 `nome` varchar(40) DEFAULT NULL,
197 `cpf` varchar(11) DEFAULT NULL,
198 `data_nasc` date DEFAULT NULL,
199 `email` varchar(40) DEFAULT NULL,
200 `telefone` varchar(40) DEFAULT NULL,
201 `id_endereco` varchar(45) DEFAULT NULL
202) ENGINE=InnoDB DEFAULT CHARSET=latin1;
203/*!40101 SET character_set_client = @saved_cs_client */;
204
205--
206-- Table structure for table `tb_cliente_juridico`
207--
208
209DROP TABLE IF EXISTS `tb_cliente_juridico`;
210/*!40101 SET @saved_cs_client = @@character_set_client */;
211/*!40101 SET character_set_client = utf8 */;
212CREATE TABLE `tb_cliente_juridico` (
213 `cnpj` varchar(14) DEFAULT NULL,
214 `email` varchar(40) DEFAULT NULL,
215 `telefone` varchar(20) DEFAULT NULL,
216 `incricao_estadual` varchar(40) DEFAULT NULL,
217 `id_endereco` varchar(45) DEFAULT NULL
218) ENGINE=InnoDB DEFAULT CHARSET=latin1;
219/*!40101 SET character_set_client = @saved_cs_client */;
220
221--
222-- Table structure for table `tb_default`
223--
224
225DROP TABLE IF EXISTS `tb_default`;
226/*!40101 SET @saved_cs_client = @@character_set_client */;
227/*!40101 SET character_set_client = utf8 */;
228CREATE TABLE `tb_default` (
229 `uf` varchar(2) DEFAULT NULL,
230 `valor` int(11) DEFAULT NULL
231) ENGINE=InnoDB DEFAULT CHARSET=latin1;
232/*!40101 SET character_set_client = @saved_cs_client */;
233
234--
235-- Table structure for table `tb_endereco`
236--
237
238DROP TABLE IF EXISTS `tb_endereco`;
239/*!40101 SET @saved_cs_client = @@character_set_client */;
240/*!40101 SET character_set_client = utf8 */;
241CREATE TABLE `tb_endereco` (
242 `estado` varchar(40) DEFAULT NULL,
243 `cep` varchar(8) DEFAULT NULL,
244 `bairro` varchar(40) DEFAULT NULL,
245 `cidade` varchar(40) DEFAULT NULL,
246 `rua` varchar(40) DEFAULT NULL,
247 `numero` varchar(40) DEFAULT NULL,
248 `complemento` varchar(40) DEFAULT NULL,
249 `id` int(11) NOT NULL AUTO_INCREMENT,
250 PRIMARY KEY (`id`)
251) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
252/*!40101 SET character_set_client = @saved_cs_client */;
253
254--
255-- Table structure for table `tb_funcionario`
256--
257
258DROP TABLE IF EXISTS `tb_funcionario`;
259/*!40101 SET @saved_cs_client = @@character_set_client */;
260/*!40101 SET character_set_client = utf8 */;
261CREATE TABLE `tb_funcionario` (
262 `nome` varchar(40) DEFAULT NULL,
263 `id` int(11) DEFAULT NULL
264) ENGINE=InnoDB DEFAULT CHARSET=latin1;
265/*!40101 SET character_set_client = @saved_cs_client */;
266
267--
268-- Table structure for table `tb_ordem_expedicao`
269--
270
271DROP TABLE IF EXISTS `tb_ordem_expedicao`;
272/*!40101 SET @saved_cs_client = @@character_set_client */;
273/*!40101 SET character_set_client = utf8 */;
274CREATE TABLE `tb_ordem_expedicao` (
275 `_status` varchar(40) DEFAULT NULL,
276 `data_entrega` date DEFAULT NULL,
277 `id_vendedor` int(11) DEFAULT NULL,
278 `id_pedido` int(11) DEFAULT NULL
279) ENGINE=InnoDB DEFAULT CHARSET=latin1;
280/*!40101 SET character_set_client = @saved_cs_client */;
281
282--
283-- Table structure for table `tb_pedido`
284--
285
286DROP TABLE IF EXISTS `tb_pedido`;
287/*!40101 SET @saved_cs_client = @@character_set_client */;
288/*!40101 SET character_set_client = utf8 */;
289CREATE TABLE `tb_pedido` (
290 `id_pedido` int(11) NOT NULL AUTO_INCREMENT,
291 `valor_total` float DEFAULT NULL,
292 `_status` varchar(40) DEFAULT NULL,
293 `_data` date DEFAULT NULL,
294 `forma_pagamento` varchar(40) DEFAULT NULL,
295 `id_vendedor` int(11) DEFAULT NULL,
296 `id_cliente` varchar(14) DEFAULT NULL,
297 `tipo_pagamento` varchar(40) DEFAULT NULL,
298 `pago` tinyint(1) DEFAULT NULL,
299 PRIMARY KEY (`id_pedido`)
300) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
301/*!40101 SET character_set_client = @saved_cs_client */;
302
303--
304-- Table structure for table `tb_produto`
305--
306
307DROP TABLE IF EXISTS `tb_produto`;
308/*!40101 SET @saved_cs_client = @@character_set_client */;
309/*!40101 SET character_set_client = utf8 */;
310CREATE TABLE `tb_produto` (
311 `id_produto` int(11) DEFAULT NULL,
312 `valor` float DEFAULT NULL,
313 `descricao` varchar(40) DEFAULT NULL,
314 `nome` varchar(40) DEFAULT NULL
315) ENGINE=InnoDB DEFAULT CHARSET=latin1;
316/*!40101 SET character_set_client = @saved_cs_client */;
317
318--
319-- Table structure for table `tb_produto_pedido`
320--
321
322DROP TABLE IF EXISTS `tb_produto_pedido`;
323/*!40101 SET @saved_cs_client = @@character_set_client */;
324/*!40101 SET character_set_client = utf8 */;
325CREATE TABLE `tb_produto_pedido` (
326 `id_produto` int(11) DEFAULT NULL,
327 `id_pedido` int(11) DEFAULT NULL,
328 `quantidade` int(11) DEFAULT NULL
329) ENGINE=InnoDB DEFAULT CHARSET=latin1;
330/*!40101 SET character_set_client = @saved_cs_client */;
331
332--
333-- Table structure for table `tb_servico`
334--
335
336DROP TABLE IF EXISTS `tb_servico`;
337/*!40101 SET @saved_cs_client = @@character_set_client */;
338/*!40101 SET character_set_client = utf8 */;
339CREATE TABLE `tb_servico` (
340 `id_servico` varchar(40) DEFAULT NULL,
341 `valor` float DEFAULT NULL,
342 `descricao` varchar(40) DEFAULT NULL,
343 `nome` varchar(40) DEFAULT NULL
344) ENGINE=InnoDB DEFAULT CHARSET=latin1;
345/*!40101 SET character_set_client = @saved_cs_client */;
346
347--
348-- Table structure for table `tb_servico_pedido`
349--
350
351DROP TABLE IF EXISTS `tb_servico_pedido`;
352/*!40101 SET @saved_cs_client = @@character_set_client */;
353/*!40101 SET character_set_client = utf8 */;
354CREATE TABLE `tb_servico_pedido` (
355 `id_servico` int(11) DEFAULT NULL,
356 `id_pedido` int(11) DEFAULT NULL,
357 `meses_duracao` int(11) DEFAULT NULL
358) ENGINE=InnoDB DEFAULT CHARSET=latin1;
359/*!40101 SET character_set_client = @saved_cs_client */;
360/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
361
362/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
363/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
364/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
365/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
366/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
367/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
368/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
369
370-- Dump completed on 2018-11-12 17:21:39
371
372-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
373--
374-- Host: localhost Database: all
375-- ------------------------------------------------------
376-- Server version 5.7.14
377
378/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
379/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
380/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
381/*!40101 SET NAMES utf8 */;
382/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
383/*!40103 SET TIME_ZONE='+00:00' */;
384/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
385/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
386/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
387/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
388
389--
390-- Dumping data for table `notafiscal`
391--
392
393LOCK TABLES `notafiscal` WRITE;
394/*!40000 ALTER TABLE `notafiscal` DISABLE KEYS */;
395/*!40000 ALTER TABLE `notafiscal` ENABLE KEYS */;
396UNLOCK TABLES;
397
398--
399-- Dumping data for table `notafiscal_saida`
400--
401
402LOCK TABLES `notafiscal_saida` WRITE;
403/*!40000 ALTER TABLE `notafiscal_saida` DISABLE KEYS */;
404/*!40000 ALTER TABLE `notafiscal_saida` ENABLE KEYS */;
405UNLOCK TABLES;
406
407--
408-- Dumping data for table `notafiscal_servico`
409--
410
411LOCK TABLES `notafiscal_servico` WRITE;
412/*!40000 ALTER TABLE `notafiscal_servico` DISABLE KEYS */;
413/*!40000 ALTER TABLE `notafiscal_servico` ENABLE KEYS */;
414UNLOCK TABLES;
415
416--
417-- Dumping data for table `produto_nf`
418--
419
420LOCK TABLES `produto_nf` WRITE;
421/*!40000 ALTER TABLE `produto_nf` DISABLE KEYS */;
422/*!40000 ALTER TABLE `produto_nf` ENABLE KEYS */;
423UNLOCK TABLES;
424
425--
426-- Dumping data for table `produtonota`
427--
428
429LOCK TABLES `produtonota` WRITE;
430/*!40000 ALTER TABLE `produtonota` DISABLE KEYS */;
431/*!40000 ALTER TABLE `produtonota` ENABLE KEYS */;
432UNLOCK TABLES;
433
434--
435-- Dumping data for table `servico_nf`
436--
437
438LOCK TABLES `servico_nf` WRITE;
439/*!40000 ALTER TABLE `servico_nf` DISABLE KEYS */;
440/*!40000 ALTER TABLE `servico_nf` ENABLE KEYS */;
441UNLOCK TABLES;
442
443--
444-- Dumping data for table `serviconota`
445--
446
447LOCK TABLES `serviconota` WRITE;
448/*!40000 ALTER TABLE `serviconota` DISABLE KEYS */;
449/*!40000 ALTER TABLE `serviconota` ENABLE KEYS */;
450UNLOCK TABLES;
451
452--
453-- Dumping data for table `tb_centro_custo`
454--
455
456LOCK TABLES `tb_centro_custo` WRITE;
457/*!40000 ALTER TABLE `tb_centro_custo` DISABLE KEYS */;
458/*!40000 ALTER TABLE `tb_centro_custo` ENABLE KEYS */;
459UNLOCK TABLES;
460
461--
462-- Dumping data for table `tb_cliente_fisico`
463--
464
465LOCK TABLES `tb_cliente_fisico` WRITE;
466/*!40000 ALTER TABLE `tb_cliente_fisico` DISABLE KEYS */;
467INSERT INTO `tb_cliente_fisico` VALUES ('Bruno Paz','44197291809','2018-02-18','bruno@email.com','11985255612','6');
468/*!40000 ALTER TABLE `tb_cliente_fisico` ENABLE KEYS */;
469UNLOCK TABLES;
470
471--
472-- Dumping data for table `tb_cliente_juridico`
473--
474
475LOCK TABLES `tb_cliente_juridico` WRITE;
476/*!40000 ALTER TABLE `tb_cliente_juridico` DISABLE KEYS */;
477/*!40000 ALTER TABLE `tb_cliente_juridico` ENABLE KEYS */;
478UNLOCK TABLES;
479
480--
481-- Dumping data for table `tb_default`
482--
483
484LOCK TABLES `tb_default` WRITE;
485/*!40000 ALTER TABLE `tb_default` DISABLE KEYS */;
486/*!40000 ALTER TABLE `tb_default` ENABLE KEYS */;
487UNLOCK TABLES;
488
489--
490-- Dumping data for table `tb_endereco`
491--
492
493LOCK TABLES `tb_endereco` WRITE;
494/*!40000 ALTER TABLE `tb_endereco` DISABLE KEYS */;
495INSERT INTO `tb_endereco` VALUES ('SP','08310520','Pq. São Rafael','São Paulo','Avenida Salvador','330','',5),('SP','04456140','Vila Matilde','São Paulo','Rua dos Santos','231','',6);
496/*!40000 ALTER TABLE `tb_endereco` ENABLE KEYS */;
497UNLOCK TABLES;
498
499--
500-- Dumping data for table `tb_funcionario`
501--
502
503LOCK TABLES `tb_funcionario` WRITE;
504/*!40000 ALTER TABLE `tb_funcionario` DISABLE KEYS */;
505/*!40000 ALTER TABLE `tb_funcionario` ENABLE KEYS */;
506UNLOCK TABLES;
507
508--
509-- Dumping data for table `tb_ordem_expedicao`
510--
511
512LOCK TABLES `tb_ordem_expedicao` WRITE;
513/*!40000 ALTER TABLE `tb_ordem_expedicao` DISABLE KEYS */;
514/*!40000 ALTER TABLE `tb_ordem_expedicao` ENABLE KEYS */;
515UNLOCK TABLES;
516
517--
518-- Dumping data for table `tb_pedido`
519--
520
521LOCK TABLES `tb_pedido` WRITE;
522/*!40000 ALTER TABLE `tb_pedido` DISABLE KEYS */;
523INSERT INTO `tb_pedido` VALUES (5,615,'Aberto','2018-11-12','4X',1,'44197291809','Cartao de Debito',1),(6,30,'Aberto','2018-11-12','1X',1,'44197291809','Dinheiro',1),(7,1200,'Aberto','2018-11-12','1X',1,'44197291809','Dinheiro',1),(8,60,'Aberto','2018-11-12','1X',1,'44197291809','Dinheiro',0),(9,30,'Aberto','2018-11-12','1X',1,'44197291809','Dinheiro',0),(10,120,'Aberto','2018-11-12','1X',1,'44197291809','Dinheiro',0);
524/*!40000 ALTER TABLE `tb_pedido` ENABLE KEYS */;
525UNLOCK TABLES;
526
527--
528-- Dumping data for table `tb_produto`
529--
530
531LOCK TABLES `tb_produto` WRITE;
532/*!40000 ALTER TABLE `tb_produto` DISABLE KEYS */;
533INSERT INTO `tb_produto` VALUES (1234,30,'Panela inox tamanho 2','Panela Inox'),(12231,90,'Panela anti-aderente tamanho 3','Panela anti-aderente');
534/*!40000 ALTER TABLE `tb_produto` ENABLE KEYS */;
535UNLOCK TABLES;
536
537--
538-- Dumping data for table `tb_produto_pedido`
539--
540
541LOCK TABLES `tb_produto_pedido` WRITE;
542/*!40000 ALTER TABLE `tb_produto_pedido` DISABLE KEYS */;
543INSERT INTO `tb_produto_pedido` VALUES (1234,9,1),(1234,10,1),(12231,10,1);
544/*!40000 ALTER TABLE `tb_produto_pedido` ENABLE KEYS */;
545UNLOCK TABLES;
546
547--
548-- Dumping data for table `tb_servico`
549--
550
551LOCK TABLES `tb_servico` WRITE;
552/*!40000 ALTER TABLE `tb_servico` DISABLE KEYS */;
553/*!40000 ALTER TABLE `tb_servico` ENABLE KEYS */;
554UNLOCK TABLES;
555
556--
557-- Dumping data for table `tb_servico_pedido`
558--
559
560LOCK TABLES `tb_servico_pedido` WRITE;
561/*!40000 ALTER TABLE `tb_servico_pedido` DISABLE KEYS */;
562/*!40000 ALTER TABLE `tb_servico_pedido` ENABLE KEYS */;
563UNLOCK TABLES;
564/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
565
566/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
567/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
568/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
569/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
570/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
571/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
572/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
573
574-- Dump completed on 2018-11-12 17:19:37