· 8 years ago · Jun 30, 2018, 12:58 AM
1-- MySQL dump 10.13 Distrib 5.6.40, for FreeBSD11.1 (i386)
2--
3-- Host: eowyn Database: fotos
4-- ------------------------------------------------------
5-- Server version 5.6.40
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `Devol_RR`
20--
21
22DROP TABLE IF EXISTS `Devol_RR`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `Devol_RR` (
26 `Relatorio` varchar(6) NOT NULL,
27 `NumeroDoItem` varchar(2) NOT NULL,
28 `CodigoDoProduto` varchar(9) NOT NULL,
29 `Descricao` varchar(100) NOT NULL,
30 `Quantidade` decimal(12,3) NOT NULL,
31 `Preco` decimal(12,2) NOT NULL,
32 `Valor` decimal(12,2) NOT NULL,
33 `Horario` varchar(4) NOT NULL,
34 PRIMARY KEY (`Relatorio`,`NumeroDoItem`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Table structure for table `Fornecedor`
40--
41
42DROP TABLE IF EXISTS `Fornecedor`;
43/*!40101 SET @saved_cs_client = @@character_set_client */;
44/*!40101 SET character_set_client = utf8 */;
45CREATE TABLE `Fornecedor` (
46 `Relatorio` varchar(6) NOT NULL,
47 `PlacaCaminhao` varchar(7) NOT NULL,
48 `Empresa` varchar(100) NOT NULL,
49 `NumeroNota` varchar(7) NOT NULL,
50 `Data` varchar(8) NOT NULL,
51 `Horario` varchar(4) NOT NULL,
52 PRIMARY KEY (`Relatorio`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
54/*!40101 SET character_set_client = @saved_cs_client */;
55
56--
57-- Table structure for table `Fotos`
58--
59
60DROP TABLE IF EXISTS `Fotos`;
61/*!40101 SET @saved_cs_client = @@character_set_client */;
62/*!40101 SET character_set_client = utf8 */;
63CREATE TABLE `Fotos` (
64 `Relatorio` varchar(6) NOT NULL,
65 `Nome1` varchar(100) NOT NULL,
66 `Conteudo1` mediumblob NOT NULL,
67 `Min_Conteudo1` mediumblob NOT NULL,
68 `Nome2` varchar(100) DEFAULT '',
69 `Conteudo2` mediumblob,
70 `Min_Conteudo2` mediumblob,
71 `Nome3` varchar(100) DEFAULT '',
72 `Conteudo3` mediumblob,
73 `Min_Conteudo3` mediumblob,
74 PRIMARY KEY (`Relatorio`)
75) ENGINE=InnoDB DEFAULT CHARSET=latin1;
76/*!40101 SET character_set_client = @saved_cs_client */;
77
78--
79-- Table structure for table `Itens_RR`
80--
81
82DROP TABLE IF EXISTS `Itens_RR`;
83/*!40101 SET @saved_cs_client = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `Itens_RR` (
86 `Relatorio` varchar(6) NOT NULL,
87 `NumeroDoItem` varchar(2) NOT NULL,
88 `CodigoDoProduto` varchar(9) NOT NULL,
89 `Descricao` varchar(100) NOT NULL,
90 `Quantidade` decimal(12,3) NOT NULL,
91 `Preco` decimal(12,2) NOT NULL,
92 `Valor` decimal(12,2) NOT NULL,
93 `Horario` varchar(4) NOT NULL,
94 PRIMARY KEY (`Relatorio`,`NumeroDoItem`)
95) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Table structure for table `Materiais`
100--
101
102DROP TABLE IF EXISTS `Materiais`;
103/*!40101 SET @saved_cs_client = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `Materiais` (
106 `Relatorio` varchar(6) NOT NULL,
107 `NumeroDoItem` varchar(2) NOT NULL,
108 `CodigoDoProduto` varchar(9) NOT NULL,
109 `Descricao` varchar(100) NOT NULL,
110 `Quantidade` decimal(12,3) NOT NULL,
111 PRIMARY KEY (`Relatorio`,`NumeroDoItem`)
112) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
113/*!40101 SET character_set_client = @saved_cs_client */;
114/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
115
116/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
117/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
118/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
119/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
120/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
121/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
122/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
123
124-- Dump completed on 2018-06-29 9:06:03