· 8 years ago · Apr 19, 2018, 06:28 AM
1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version 5.0.24-community-nt
5
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
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema tcc
19--
20
21CREATE DATABASE IF NOT EXISTS tcc;
22USE tcc;
23
24--
25-- Definition of table `domicilios`
26--
27
28DROP TABLE IF EXISTS `domicilios`;
29CREATE TABLE `domicilios` (
30 `codDomicilios` int(10) unsigned NOT NULL auto_increment,
31 `numero` varchar(45) NOT NULL,
32 `logradouro` varchar(100) NOT NULL,
33 `bairro` varchar(45) NOT NULL,
34 `tipo` varchar(45) NOT NULL,
35 `codSetor` int(10) unsigned NOT NULL,
36 PRIMARY KEY (`codDomicilios`),
37 KEY `FK_domicilios` (`codSetor`),
38 CONSTRAINT `FK_domicilios` FOREIGN KEY (`codSetor`) REFERENCES `setor` (`codSetor`)
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40
41--
42-- Dumping data for table `domicilios`
43--
44
45/*!40000 ALTER TABLE `domicilios` DISABLE KEYS */;
46INSERT INTO `domicilios` (`codDomicilios`,`numero`,`logradouro`,`bairro`,`tipo`,`codSetor`) VALUES
47 (1,'8390','Avenida rsrs','Jussara','Casa',1),
48 (2,'8390','Avenida São Paulo','Jussara','Casa',1);
49/*!40000 ALTER TABLE `domicilios` ENABLE KEYS */;
50
51
52--
53-- Definition of table `empregosgerados`
54--
55
56DROP TABLE IF EXISTS `empregosgerados`;
57CREATE TABLE `empregosgerados` (
58 `codEmpGerados` int(10) unsigned NOT NULL auto_increment,
59 `mes` varchar(45) NOT NULL,
60 `ano` varchar(45) NOT NULL,
61 `tipo` varchar(45) NOT NULL,
62 `qtd` varchar(45) NOT NULL,
63 `codReceitaProjeto` int(10) unsigned NOT NULL,
64 PRIMARY KEY (`codEmpGerados`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `empregosgerados`
69--
70
71/*!40000 ALTER TABLE `empregosgerados` DISABLE KEYS */;
72/*!40000 ALTER TABLE `empregosgerados` ENABLE KEYS */;
73
74
75--
76-- Definition of table `entescoleta`
77--
78
79DROP TABLE IF EXISTS `entescoleta`;
80CREATE TABLE `entescoleta` (
81 `codEntesColeta` int(10) unsigned NOT NULL auto_increment,
82 `nome` varchar(45) NOT NULL,
83 `CNPJ` varchar(45) NOT NULL,
84 `situacao` varchar(45) NOT NULL,
85 `codPevsBases` int(10) unsigned NOT NULL,
86 `codSetor` int(10) unsigned NOT NULL,
87 PRIMARY KEY (`codEntesColeta`),
88 KEY `FK_EntesColeta_1` (`codPevsBases`),
89 KEY `FK_EntesColeta_2` (`codSetor`)
90) ENGINE=InnoDB DEFAULT CHARSET=latin1;
91
92--
93-- Dumping data for table `entescoleta`
94--
95
96/*!40000 ALTER TABLE `entescoleta` DISABLE KEYS */;
97/*!40000 ALTER TABLE `entescoleta` ENABLE KEYS */;
98
99
100--
101-- Definition of table `entesprocessamento`
102--
103
104DROP TABLE IF EXISTS `entesprocessamento`;
105CREATE TABLE `entesprocessamento` (
106 `codEnteProces` int(10) unsigned NOT NULL auto_increment,
107 `nome` varchar(45) NOT NULL,
108 `CNPJ` varchar(45) NOT NULL,
109 `situacao` varchar(45) NOT NULL,
110 `codSetor` int(10) unsigned NOT NULL,
111 `codGalpaoTriagem` int(10) unsigned NOT NULL,
112 PRIMARY KEY (`codEnteProces`),
113 KEY `FK_EntesProcessamento_1` (`codSetor`),
114 KEY `FK_EntesProcessamento_2` (`codGalpaoTriagem`)
115) ENGINE=InnoDB DEFAULT CHARSET=latin1;
116
117--
118-- Dumping data for table `entesprocessamento`
119--
120
121/*!40000 ALTER TABLE `entesprocessamento` DISABLE KEYS */;
122/*!40000 ALTER TABLE `entesprocessamento` ENABLE KEYS */;
123
124
125--
126-- Definition of table `galpaotriagem`
127--
128
129DROP TABLE IF EXISTS `galpaotriagem`;
130CREATE TABLE `galpaotriagem` (
131 `CodGalpaoTriagem` int(10) unsigned NOT NULL auto_increment,
132 `nome` varchar(45) NOT NULL,
133 `codSetor` int(10) unsigned NOT NULL,
134 PRIMARY KEY (`CodGalpaoTriagem`),
135 KEY `FK_GalpaoTriagem_1` (`codSetor`)
136) ENGINE=InnoDB DEFAULT CHARSET=latin1;
137
138--
139-- Dumping data for table `galpaotriagem`
140--
141
142/*!40000 ALTER TABLE `galpaotriagem` DISABLE KEYS */;
143/*!40000 ALTER TABLE `galpaotriagem` ENABLE KEYS */;
144
145
146--
147-- Definition of table `pevsbasesdeapoio`
148--
149
150DROP TABLE IF EXISTS `pevsbasesdeapoio`;
151CREATE TABLE `pevsbasesdeapoio` (
152 `codPevsBases` int(10) unsigned NOT NULL auto_increment,
153 `nome` varchar(45) NOT NULL,
154 `codGalpaoTriagem` int(10) unsigned NOT NULL,
155 `codSetor` int(10) unsigned NOT NULL,
156 PRIMARY KEY (`codPevsBases`),
157 KEY `FK_PevsBases_1` (`codGalpaoTriagem`),
158 KEY `FK_PevsBases_2` (`codSetor`)
159) ENGINE=InnoDB DEFAULT CHARSET=latin1;
160
161--
162-- Dumping data for table `pevsbasesdeapoio`
163--
164
165/*!40000 ALTER TABLE `pevsbasesdeapoio` DISABLE KEYS */;
166/*!40000 ALTER TABLE `pevsbasesdeapoio` ENABLE KEYS */;
167
168
169--
170-- Definition of table `receitaprojeto`
171--
172
173DROP TABLE IF EXISTS `receitaprojeto`;
174CREATE TABLE `receitaprojeto` (
175 `codReceitaProjeto` int(10) unsigned NOT NULL auto_increment,
176 `prodNegPrestServ` varchar(45) NOT NULL,
177 `prodNegRec` varchar(45) NOT NULL,
178 `prodPosUtilProj` varchar(45) NOT NULL,
179 `prodPosCriacEmpre` varchar(45) NOT NULL,
180 PRIMARY KEY (`codReceitaProjeto`)
181) ENGINE=InnoDB DEFAULT CHARSET=latin1;
182
183--
184-- Dumping data for table `receitaprojeto`
185--
186
187/*!40000 ALTER TABLE `receitaprojeto` DISABLE KEYS */;
188/*!40000 ALTER TABLE `receitaprojeto` ENABLE KEYS */;
189
190
191--
192-- Definition of table `recursos`
193--
194
195DROP TABLE IF EXISTS `recursos`;
196CREATE TABLE `recursos` (
197 `codRecursos` int(10) unsigned NOT NULL auto_increment,
198 `nome` varchar(45) NOT NULL,
199 `tipo` varchar(45) NOT NULL,
200 `qtdDisponivel` varchar(45) NOT NULL,
201 `codGalpaoTriagem` int(10) unsigned NOT NULL,
202 `codReceitaProjeto` int(10) unsigned NOT NULL,
203 `codPevsBases` int(10) unsigned NOT NULL,
204 PRIMARY KEY (`codRecursos`),
205 KEY `FK_Recursos_1` (`codGalpaoTriagem`),
206 KEY `FK_Recursos_2` (`codReceitaProjeto`),
207 KEY `FK_Recursos_3` (`codPevsBases`),
208 CONSTRAINT `FK_Recursos_1` FOREIGN KEY (`codGalpaoTriagem`) REFERENCES `galpao triagem` (`CodGalpaoTriagem`),
209 CONSTRAINT `FK_Recursos_2` FOREIGN KEY (`codReceitaProjeto`) REFERENCES `receita projeto` (`codReceitaProjeto`),
210 CONSTRAINT `FK_Recursos_3` FOREIGN KEY (`codPevsBases`) REFERENCES `pevs bases de apoio` (`codPevsBases`)
211) ENGINE=InnoDB DEFAULT CHARSET=latin1;
212
213--
214-- Dumping data for table `recursos`
215--
216
217/*!40000 ALTER TABLE `recursos` DISABLE KEYS */;
218/*!40000 ALTER TABLE `recursos` ENABLE KEYS */;
219
220
221--
222-- Definition of table `residuosgeradosdia`
223--
224
225DROP TABLE IF EXISTS `residuosgeradosdia`;
226CREATE TABLE `residuosgeradosdia` (
227 `codResiduosGerados` int(10) unsigned NOT NULL,
228 `data` varchar(45) NOT NULL,
229 `unidade` varchar(45) NOT NULL,
230 `qtd` int(10) unsigned NOT NULL,
231 `unidMedida` varchar(45) NOT NULL,
232 `mes` varchar(45) NOT NULL,
233 `ano` varchar(45) NOT NULL,
234 `setorColetaMes` int(10) unsigned NOT NULL,
235 `setorColetaAno` int(10) unsigned NOT NULL,
236 `codSetor` int(10) unsigned NOT NULL,
237 PRIMARY KEY (`codResiduosGerados`),
238 KEY `FK_ResiduosGeradosDia_1` (`codSetor`)
239) ENGINE=InnoDB DEFAULT CHARSET=latin1;
240
241--
242-- Dumping data for table `residuosgeradosdia`
243--
244
245/*!40000 ALTER TABLE `residuosgeradosdia` DISABLE KEYS */;
246/*!40000 ALTER TABLE `residuosgeradosdia` ENABLE KEYS */;
247
248
249--
250-- Definition of table `setor`
251--
252
253DROP TABLE IF EXISTS `setor`;
254CREATE TABLE `setor` (
255 `codSetor` int(10) unsigned NOT NULL auto_increment,
256 `localizacao` varchar(45) NOT NULL,
257 PRIMARY KEY (`codSetor`)
258) ENGINE=InnoDB DEFAULT CHARSET=latin1;
259
260--
261-- Dumping data for table `setor`
262--
263
264/*!40000 ALTER TABLE `setor` DISABLE KEYS */;
265INSERT INTO `setor` (`codSetor`,`localizacao`) VALUES
266 (1,'Centro'),
267 (2,'Norte');
268/*!40000 ALTER TABLE `setor` ENABLE KEYS */;
269
270
271--
272-- Definition of table `usuario`
273--
274
275DROP TABLE IF EXISTS `usuario`;
276CREATE TABLE `usuario` (
277 `codUsuario` int(10) unsigned NOT NULL auto_increment,
278 `nome` varchar(45) NOT NULL,
279 `RG` varchar(45) NOT NULL,
280 `telefone` varchar(45) NOT NULL,
281 `nivelAcesso` varchar(45) NOT NULL,
282 `login` varchar(45) NOT NULL,
283 `senha` varchar(45) NOT NULL,
284 PRIMARY KEY (`codUsuario`)
285) ENGINE=InnoDB DEFAULT CHARSET=latin1;
286
287--
288-- Dumping data for table `usuario`
289--
290
291/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
292INSERT INTO `usuario` (`codUsuario`,`nome`,`RG`,`telefone`,`nivelAcesso`,`login`,`senha`) VALUES
293 (1,'Jaum','58.484.898-9','(13)6904-8879','Administrador','villeneuve','180893');
294/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
295
296
297
298
299/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
300/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
301/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
302/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
303/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
304/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
305/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;