· 6 years ago · Jun 09, 2019, 09:36 PM
1███▄▄▄▄ ▄████████ ████████▄ ▄█ ▄██████▄ ▄████████ ▄█ ▄█▄
2███▀▀▀██▄ ███ ███ ███ ▀███ ███ ███ ███ ███ ███ ███ ▄███▀
3███ ███ ███ █▀ ███ ███ ███ ███ ███ ███ █▀ ███▐██▀
4███ ███ ▄███▄▄▄ ███ ███ ███ ███ ███ ███ ▄█████▀
5███ ███ ▀▀███▀▀▀ ███ ███ ███ ███ ███ ███ ▀▀█████▄
6███ ███ ███ █▄ ███ ███ ███ ███ ███ ███ █▄ ███▐██▄
7███ ███ ███ ███ ███ ▄███ ███▌ ▄ ███ ███ ███ ███ ███ ▀███▄
8 ▀█ █▀ ██████████ ████████▀ █████▄▄██ ▀██████▀ ████████▀ ███ ▀█▀
9 ▀ ▀
10=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
11Corpos na vala rasgados na bala, gente que se mata, vive no pecado
12Tem cara que fala; te chama de parça,te abraça e que não vale nem um centavo
13
14Target : https://svn.cercomp.ufg.br/
15=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
16-- Host: localhost Database: sgp
17-- ------------------------------------------------------
18-- Server version 5.0.45-Debian_1ubuntu3-log
19
20/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
21/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
22/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
23/*!40101 SET NAMES utf8 */;
24/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
25/*!40103 SET TIME_ZONE='+00:00' */;
26/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
27/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
28/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
29/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
30
31--
32-- Current Database: `sgp`
33--
34
35CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sgp` /*!40100 DEFAULT CHARACTER SET latin1 */;
36
37USE `sgp`;
38
39--
40-- Table structure for table `bloco`
41--
42
43DROP TABLE IF EXISTS `bloco`;
44CREATE TABLE `bloco` (
45 `id` int(10) NOT NULL auto_increment,
46 `id_unidade` int(10) NOT NULL,
47 `bloco` varchar(20) NOT NULL,
48 PRIMARY KEY (`id`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1;
50
51--
52-- Dumping data for table `bloco`
53--
54
55LOCK TABLES `bloco` WRITE;
56/*!40000 ALTER TABLE `bloco` DISABLE KEYS */;
57/*!40000 ALTER TABLE `bloco` ENABLE KEYS */;
58UNLOCK TABLES;
59
60--
61-- Table structure for table `cor`
62--
63
64DROP TABLE IF EXISTS `cor`;
65CREATE TABLE `cor` (
66 `id` int(10) NOT NULL auto_increment,
67 `cor` varchar(20) NOT NULL,
68 PRIMARY KEY (`id`)
69) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
70
71--
72-- Dumping data for table `cor`
73--
74
75LOCK TABLES `cor` WRITE;
76/*!40000 ALTER TABLE `cor` DISABLE KEYS */;
77INSERT INTO `cor` VALUES (12,'Vermelho'),(13,'Verde'),(14,'Azul');
78/*!40000 ALTER TABLE `cor` ENABLE KEYS */;
79UNLOCK TABLES;
80
81--
82-- Table structure for table `departamento`
83--
84
85DROP TABLE IF EXISTS `departamento`;
86CREATE TABLE `departamento` (
87 `id` int(10) NOT NULL auto_increment,
88 `id_unidade` int(10) NOT NULL,
89 `id_bloco` int(10) NOT NULL,
90 `departamento` varchar(20) NOT NULL,
91 PRIMARY KEY (`id`)
92) ENGINE=MyISAM DEFAULT CHARSET=latin1;
93
94--
95-- Dumping data for table `departamento`
96--
97
98LOCK TABLES `departamento` WRITE;
99/*!40000 ALTER TABLE `departamento` DISABLE KEYS */;
100/*!40000 ALTER TABLE `departamento` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `patrimonio`
105--
106
107DROP TABLE IF EXISTS `patrimonio`;
108CREATE TABLE `patrimonio` (
109 `id` int(10) NOT NULL auto_increment,
110 `id_unidade` int(10) NOT NULL,
111 `id_bloco` int(10) NOT NULL,
112 `id_departamento` int(10) NOT NULL,
113 `id_sala` int(10) NOT NULL,
114 `id_cor` int(10) NOT NULL,
115 `id_tipo` int(10) NOT NULL,
116 `id_situacao` int(10) NOT NULL,
117 `dataEntrada` date NOT NULL,
118 `codigo` varchar(20) NOT NULL,
119 `nome` varchar(20) NOT NULL,
120 `dataBaixa` date default NULL,
121 PRIMARY KEY (`id`)
122) ENGINE=MyISAM DEFAULT CHARSET=latin1;
123
124--
125-- Dumping data for table `patrimonio`
126--
127
128LOCK TABLES `patrimonio` WRITE;
129/*!40000 ALTER TABLE `patrimonio` DISABLE KEYS */;
130/*!40000 ALTER TABLE `patrimonio` ENABLE KEYS */;
131UNLOCK TABLES;
132
133--
134-- Table structure for table `sala`
135--
136
137DROP TABLE IF EXISTS `sala`;
138CREATE TABLE `sala` (
139 `id` int(10) NOT NULL auto_increment,
140 `id_unidade` int(10) NOT NULL,
141 `id_bloco` int(10) NOT NULL,
142 `id_departamento` int(10) default NULL,
143 `sala` varchar(20) NOT NULL,
144 PRIMARY KEY (`id`)
145) ENGINE=MyISAM DEFAULT CHARSET=latin1;
146
147--
148-- Dumping data for table `sala`
149--
150
151LOCK TABLES `sala` WRITE;
152/*!40000 ALTER TABLE `sala` DISABLE KEYS */;
153/*!40000 ALTER TABLE `sala` ENABLE KEYS */;
154UNLOCK TABLES;
155
156--
157-- Table structure for table `situacao`
158--
159
160DROP TABLE IF EXISTS `situacao`;
161CREATE TABLE `situacao` (
162 `id` int(10) unsigned NOT NULL auto_increment,
163 `situacao` varchar(20) NOT NULL,
164 PRIMARY KEY (`id`)
165) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
166
167--
168-- Dumping data for table `situacao`
169--
170
171LOCK TABLES `situacao` WRITE;
172/*!40000 ALTER TABLE `situacao` DISABLE KEYS */;
173INSERT INTO `situacao` VALUES (1,'estragado'),(3,'defeituoso'),(6,'reformado'),(14,'usado');
174/*!40000 ALTER TABLE `situacao` ENABLE KEYS */;
175UNLOCK TABLES;
176
177--
178-- Table structure for table `tipo`
179--
180
181DROP TABLE IF EXISTS `tipo`;
182CREATE TABLE `tipo` (
183 `id` int(10) NOT NULL auto_increment,
184 `tipo` varchar(20) default NULL,
185 PRIMARY KEY (`id`)
186) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
187
188--
189-- Dumping data for table `tipo`
190--
191
192LOCK TABLES `tipo` WRITE;
193/*!40000 ALTER TABLE `tipo` DISABLE KEYS */;
194INSERT INTO `tipo` VALUES (1,'mesa'),(2,'cadeira');
195/*!40000 ALTER TABLE `tipo` ENABLE KEYS */;
196UNLOCK TABLES;
197
198--
199-- Table structure for table `unidade`
200--
201
202DROP TABLE IF EXISTS `unidade`;
203CREATE TABLE `unidade` (
204 `id` int(10) unsigned NOT NULL auto_increment,
205 `unidade` varchar(20) NOT NULL,
206 PRIMARY KEY (`id`)
207) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
208
209--
210-- Dumping data for table `unidade`
211--
212
213LOCK TABLES `unidade` WRITE;
214/*!40000 ALTER TABLE `unidade` DISABLE KEYS */;
215INSERT INTO `unidade` VALUES (1,'Jardim da luz'),(3,'Centro');
216/*!40000 ALTER TABLE `unidade` ENABLE KEYS */;
217UNLOCK TABLES;
218
219--
220-- Table structure for table `usuario`
221--
222
223DROP TABLE IF EXISTS `usuario`;
224CREATE TABLE `usuario` (
225 `matricula` varchar(5) NOT NULL,
226 `nome` varchar(30) NOT NULL,
227 `cargo` varchar(30) NOT NULL,
228 `email` varchar(30) NOT NULL,
229 `login` varchar(10) NOT NULL,
230 `senha` varchar(4) NOT NULL,
231 PRIMARY KEY (`matricula`)
232) ENGINE=MyISAM DEFAULT CHARSET=latin1;
233
234--
235-- Dumping data for table `usuario`
236--
237
238LOCK TABLES `usuario` WRITE;
239/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
240INSERT INTO `usuario` VALUES ('111','Marcello Henrique','Analista','faraohh@gmail.com','faraohh','fara'),('112','Eugenio','Professor','eugenio@gmail.com','eugenio','123'),('113','Kleuber','aluno','kleuber@gmail.com','kleuber','1234'),('114','Leonardo','aluno','leonardo@gmail.com','leonardo',''),('116','marcos','aluno','marcos@gmail.com','marcos','123');
241/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
242UNLOCK TABLES;
243/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
244
245/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
246/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
247/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
248/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
249/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
250/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
251/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
252
253#NewSec