· 6 years ago · Jun 02, 2019, 01:54 AM
1 .-----------------TTTT_-----_______
2 /''''''''''(______O] ----------____ \______/]_
3 __...---'"""\_ --'' Q ___________@
4|''' ._ _______________=---------"""""""
5| ..--''| l L |_l |
6| ..--'' . /-___j ' '
7| ..--'' / , ' '
8|--'' / ` \
9 L__' \ -
10 - '-.
11 '. /
12 '-./
13
14FBI HACKED BY : DEMONSAD
15
16Greetings : Tiosan , Angel Cracking, Kami , Cloudmore , HaxStroke
17
18
19------------------------------------------------------------------------
20
21ABRAÇO PRA EQUIPE DO F.B.I
22
23
24-----------------------------------------------------------------------
25
26-- MySQL Administrator dump 1.4
27--
28-- ------------------------------------------------------
29-- Server version 5.0.27-community-nt
30
31
32/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
33/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
34/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
35/*!40101 SET NAMES utf8 */;
36
37/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
38/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
39/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
40
41
42--
43-- Create schema pes06_2_1
44--
45
46CREATE DATABASE IF NOT EXISTS pes06_2_1;
47USE pes06_2_1;
48
49--
50-- Definition of table `algoritmo`
51--
52CREATE TABLE `algoritmo` (
53 `id_variavel` int(11) NOT NULL auto_increment,
54 `nome` varchar(250) NOT NULL default '',
55 `id_projeto` varchar(100) NOT NULL default '',
56 `valor` varchar(250) NOT NULL default '',
57 PRIMARY KEY (`id_variavel`),
58 UNIQUE KEY `nome` (`nome`,`id_projeto`)
59) ENGINE=MyISAM DEFAULT CHARSET=latin1;
60
61--
62-- Dumping data for table `algoritmo`
63--
64
65/*!40000 ALTER TABLE `algoritmo` DISABLE KEYS */;
66/*!40000 ALTER TABLE `algoritmo` ENABLE KEYS */;
67
68
69--
70-- Definition of table `axioma`
71--
72CREATE TABLE `axioma` (
73 `id_axioma` int(11) NOT NULL auto_increment,
74 `axioma` varchar(250) NOT NULL default '',
75 `id_projeto` int(11) default '30',
76 PRIMARY KEY (`id_axioma`),
77 UNIQUE KEY `axioma` (`axioma`,`id_projeto`)
78) ENGINE=MyISAM DEFAULT CHARSET=latin1;
79
80--
81-- Dumping data for table `axioma`
82--
83
84/*!40000 ALTER TABLE `axioma` DISABLE KEYS */;
85/*!40000 ALTER TABLE `axioma` ENABLE KEYS */;
86
87
88--
89-- Definition of table `cenario`
90--
91CREATE TABLE `cenario` (
92 `id_cenario` int(11) NOT NULL auto_increment,
93 `id_projeto` int(11) NOT NULL default '0',
94 `data` date NOT NULL default '0000-00-00',
95 `titulo` varchar(255) NOT NULL default '',
96 `objetivo` text NOT NULL,
97 `contexto` text NOT NULL,
98 `atores` text NOT NULL,
99 `recursos` text NOT NULL,
100 `episodios` text NOT NULL,
101 `excecao` text,
102 PRIMARY KEY (`id_cenario`,`data`),
103 UNIQUE KEY `IDX_cenario_2` (`id_projeto`,`titulo`)
104) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
105
106--
107-- Dumping data for table `cenario`
108--
109
110/*!40000 ALTER TABLE `cenario` DISABLE KEYS */;
111INSERT INTO `cenario` (`id_cenario`,`id_projeto`,`data`,`titulo`,`objetivo`,`contexto`,`atores`,`recursos`,`episodios`,`excecao`) VALUES
112 (1,6,'0000-00-00','teste','teste','teste','teste\r\npessoa\r\nestudante','teste\r\ndindin\r\nnada','pessoa\r\ndindin','teste');
113/*!40000 ALTER TABLE `cenario` ENABLE KEYS */;
114
115
116--
117-- Definition of table `centocen`
118--
119CREATE TABLE `centocen` (
120 `id_cenario_from` int(11) NOT NULL default '0',
121 `id_cenario_to` int(11) NOT NULL default '0',
122 PRIMARY KEY (`id_cenario_from`,`id_cenario_to`)
123) ENGINE=MyISAM DEFAULT CHARSET=latin1;
124
125--
126-- Dumping data for table `centocen`
127--
128
129/*!40000 ALTER TABLE `centocen` DISABLE KEYS */;
130/*!40000 ALTER TABLE `centocen` ENABLE KEYS */;
131
132
133--
134-- Definition of table `centolex`
135--
136CREATE TABLE `centolex` (
137 `id_cenario` int(11) NOT NULL default '0',
138 `id_lexico` int(11) NOT NULL default '0',
139 PRIMARY KEY (`id_cenario`,`id_lexico`)
140) ENGINE=MyISAM DEFAULT CHARSET=latin1;
141
142--
143-- Dumping data for table `centolex`
144--
145
146/*!40000 ALTER TABLE `centolex` DISABLE KEYS */;
147/*!40000 ALTER TABLE `centolex` ENABLE KEYS */;
148
149
150--
151-- Definition of table `conceito`
152--
153CREATE TABLE `conceito` (
154 `id_conceito` int(11) NOT NULL auto_increment,
155 `nome` varchar(250) NOT NULL default '',
156 `descricao` varchar(250) NOT NULL default '',
157 `namespace` varchar(250) default NULL,
158 `id_projeto` int(11) NOT NULL default '30',
159 PRIMARY KEY (`id_conceito`),
160 UNIQUE KEY `nome` (`nome`,`id_projeto`)
161) ENGINE=MyISAM DEFAULT CHARSET=latin1;
162
163--
164-- Dumping data for table `conceito`
165--
166
167/*!40000 ALTER TABLE `conceito` DISABLE KEYS */;
168/*!40000 ALTER TABLE `conceito` ENABLE KEYS */;
169
170
171--
172-- Definition of table `hierarquia`
173--
174CREATE TABLE `hierarquia` (
175 `id_hierarquia` int(11) NOT NULL auto_increment,
176 `id_projeto` int(11) NOT NULL default '0',
177 `id_conceito` int(11) NOT NULL default '0',
178 `id_subconceito` int(11) NOT NULL default '0',
179 PRIMARY KEY (`id_hierarquia`,`id_projeto`,`id_conceito`,`id_subconceito`)
180) ENGINE=MyISAM DEFAULT CHARSET=latin1;
181
182--
183-- Dumping data for table `hierarquia`
184--
185
186/*!40000 ALTER TABLE `hierarquia` DISABLE KEYS */;
187/*!40000 ALTER TABLE `hierarquia` ENABLE KEYS */;
188
189
190--
191-- Definition of table `impacto`
192--
193CREATE TABLE `impacto` (
194 `id_impacto` int(11) NOT NULL auto_increment,
195 `id_lexico` int(11) NOT NULL default '0',
196 `impacto` varchar(250) NOT NULL default '',
197 PRIMARY KEY (`id_lexico`,`impacto`),
198 UNIQUE KEY `id_impacto` (`id_impacto`)
199) ENGINE=MyISAM DEFAULT CHARSET=latin1;
200
201--
202-- Dumping data for table `impacto`
203--
204
205/*!40000 ALTER TABLE `impacto` DISABLE KEYS */;
206/*!40000 ALTER TABLE `impacto` ENABLE KEYS */;
207
208
209--
210-- Definition of table `lexico`
211--
212CREATE TABLE `lexico` (
213 `id_lexico` int(11) NOT NULL auto_increment,
214 `id_projeto` int(11) NOT NULL default '0',
215 `data` date NOT NULL default '0000-00-00',
216 `nome` varchar(64) NOT NULL default '',
217 `tipo` varchar(15) default NULL,
218 `nocao` text NOT NULL,
219 `impacto` text,
220 PRIMARY KEY (`id_lexico`,`data`),
221 UNIQUE KEY `IDX_lexico_2` (`id_projeto`,`nome`)
222) ENGINE=MyISAM DEFAULT CHARSET=latin1;
223
224--
225-- Dumping data for table `lexico`
226--
227
228/*!40000 ALTER TABLE `lexico` DISABLE KEYS */;
229/*!40000 ALTER TABLE `lexico` ENABLE KEYS */;
230
231
232--
233-- Definition of table `lextolex`
234--
235CREATE TABLE `lextolex` (
236 `id_lexico_from` int(11) NOT NULL default '0',
237 `id_lexico_to` int(11) NOT NULL default '0',
238 PRIMARY KEY (`id_lexico_from`,`id_lexico_to`)
239) ENGINE=MyISAM DEFAULT CHARSET=latin1;
240
241--
242-- Dumping data for table `lextolex`
243--
244
245/*!40000 ALTER TABLE `lextolex` DISABLE KEYS */;
246/*!40000 ALTER TABLE `lextolex` ENABLE KEYS */;
247
248
249--
250-- Definition of table `participa`
251--
252CREATE TABLE `participa` (
253 `id_usuario` int(11) NOT NULL default '0',
254 `id_projeto` int(11) NOT NULL default '0',
255 `gerente` int(1) NOT NULL default '0',
256 PRIMARY KEY (`id_usuario`,`id_projeto`)
257) ENGINE=MyISAM DEFAULT CHARSET=latin1;
258
259--
260-- Dumping data for table `participa`
261--
262
263/*!40000 ALTER TABLE `participa` DISABLE KEYS */;
264INSERT INTO `participa` (`id_usuario`,`id_projeto`,`gerente`) VALUES
265 (8,6,1),
266 (5,7,1),
267 (1,7,0),
268 (2,7,0),
269 (3,7,0),
270 (4,7,0),
271 (6,7,0),
272 (7,7,0),
273 (8,7,0);
274/*!40000 ALTER TABLE `participa` ENABLE KEYS */;
275
276
277--
278-- Definition of table `pedidocen`
279--
280CREATE TABLE `pedidocen` (
281 `id_pedido` int(11) NOT NULL auto_increment,
282 `id_usuario` int(11) NOT NULL default '0',
283 `id_projeto` int(11) NOT NULL default '0',
284 `tipo_pedido` varchar(7) NOT NULL default '',
285 `aprovado` int(1) NOT NULL default '0',
286 `id_cenario` int(11) default NULL,
287 `titulo` varchar(255) NOT NULL default '',
288 `objetivo` text NOT NULL,
289 `contexto` text NOT NULL,
290 `atores` text NOT NULL,
291 `recursos` text NOT NULL,
292 `episodios` text,
293 `justificativa` text,
294 `id_status` int(1) default NULL,
295 `excecao` text,
296 PRIMARY KEY (`id_pedido`)
297) ENGINE=MyISAM DEFAULT CHARSET=latin1;
298
299--
300-- Dumping data for table `pedidocen`
301--
302
303/*!40000 ALTER TABLE `pedidocen` DISABLE KEYS */;
304/*!40000 ALTER TABLE `pedidocen` ENABLE KEYS */;
305
306
307--
308-- Definition of table `pedidocon`
309--
310CREATE TABLE `pedidocon` (
311 `id_pedido` int(11) NOT NULL auto_increment,
312 `id_usuario` int(11) NOT NULL default '0',
313 `id_projeto` int(11) NOT NULL default '0',
314 `tipo_pedido` varchar(7) NOT NULL default '',
315 `aprovado` int(1) NOT NULL default '0',
316 `id_conceito` int(11) default NULL,
317 `nome` varchar(255) NOT NULL default '',
318 `descricao` text NOT NULL,
319 `namespace` text NOT NULL,
320 `justificativa` text,
321 `id_status` int(1) default NULL,
322 PRIMARY KEY (`id_pedido`)
323) ENGINE=MyISAM DEFAULT CHARSET=latin1;
324
325--
326-- Dumping data for table `pedidocon`
327--
328
329/*!40000 ALTER TABLE `pedidocon` DISABLE KEYS */;
330/*!40000 ALTER TABLE `pedidocon` ENABLE KEYS */;
331
332
333--
334-- Definition of table `pedidolex`
335--
336CREATE TABLE `pedidolex` (
337 `id_pedido` int(11) NOT NULL auto_increment,
338 `id_usuario` int(11) NOT NULL default '0',
339 `id_projeto` int(11) NOT NULL default '0',
340 `tipo_pedido` varchar(7) NOT NULL default '',
341 `aprovado` int(1) NOT NULL default '0',
342 `id_lexico` int(11) NOT NULL default '0',
343 `nome` varchar(64) NOT NULL default '',
344 `nocao` text NOT NULL,
345 `impacto` text NOT NULL,
346 `justificativa` text,
347 `id_status` int(1) default NULL,
348 `tipo` varchar(20) default NULL,
349 PRIMARY KEY (`id_pedido`)
350) ENGINE=MyISAM DEFAULT CHARSET=latin1;
351
352--
353-- Dumping data for table `pedidolex`
354--
355
356/*!40000 ALTER TABLE `pedidolex` DISABLE KEYS */;
357/*!40000 ALTER TABLE `pedidolex` ENABLE KEYS */;
358
359
360--
361-- Definition of table `pedidorel`
362--
363CREATE TABLE `pedidorel` (
364 `id_pedido` int(11) NOT NULL auto_increment,
365 `id_usuario` int(11) NOT NULL default '0',
366 `id_projeto` int(11) NOT NULL default '0',
367 `tipo_pedido` varchar(7) NOT NULL default '',
368 `aprovado` int(1) NOT NULL default '0',
369 `id_relacao` int(11) default NULL,
370 `nome` varchar(255) NOT NULL default '',
371 `justificativa` text,
372 `id_status` int(1) default NULL,
373 PRIMARY KEY (`id_pedido`)
374) ENGINE=MyISAM DEFAULT CHARSET=latin1;
375
376--
377-- Dumping data for table `pedidorel`
378--
379
380/*!40000 ALTER TABLE `pedidorel` DISABLE KEYS */;
381/*!40000 ALTER TABLE `pedidorel` ENABLE KEYS */;
382
383
384--
385-- Definition of table `projeto`
386--
387CREATE TABLE `projeto` (
388 `id_projeto` int(11) NOT NULL default '0',
389 `nome` varchar(128) NOT NULL default '',
390 `data_criacao` date NOT NULL default '0000-00-00',
391 `descricao` text NOT NULL,
392 `id_status` int(50) default NULL,
393 PRIMARY KEY (`id_projeto`)
394) ENGINE=MyISAM DEFAULT CHARSET=latin1;
395
396--
397-- Dumping data for table `projeto`
398--
399
400/*!40000 ALTER TABLE `projeto` DISABLE KEYS */;
401INSERT INTO `projeto` (`id_projeto`,`nome`,`data_criacao`,`descricao`,`id_status`) VALUES
402 (1,'novo','2004-10-13','novo',NULL),
403 (2,'aa','2004-10-13','aa',NULL),
404 (3,'novoprojeto','2004-10-13','descricao projeto testes',NULL),
405 (4,'ultimo','2004-10-13','ultimo',NULL),
406 (5,'teste123','2004-10-13','testeasa',NULL),
407 (6,'projeto','2004-10-13','projteste',NULL),
408 (7,'teste','2004-10-13','',NULL);
409/*!40000 ALTER TABLE `projeto` ENABLE KEYS */;
410
411
412--
413-- Definition of table `publicacao`
414--
415CREATE TABLE `publicacao` (
416 `id_projeto` int(11) NOT NULL default '0',
417 `data_publicacao` date NOT NULL default '0000-00-00',
418 `versao` varchar(15) NOT NULL default '',
419 `XML` longtext NOT NULL,
420 PRIMARY KEY (`id_projeto`,`versao`)
421) ENGINE=MyISAM DEFAULT CHARSET=latin1;
422
423--
424-- Dumping data for table `publicacao`
425--
426
427/*!40000 ALTER TABLE `publicacao` DISABLE KEYS */;
428/*!40000 ALTER TABLE `publicacao` ENABLE KEYS */;
429
430
431--
432-- Definition of table `relacao`
433--
434CREATE TABLE `relacao` (
435 `id_relacao` int(11) NOT NULL auto_increment,
436 `nome` varchar(250) NOT NULL default '',
437 `id_projeto` int(11) default '30',
438 PRIMARY KEY (`id_relacao`),
439 UNIQUE KEY `nome` (`nome`,`id_projeto`)
440) ENGINE=MyISAM DEFAULT CHARSET=latin1;
441
442--
443-- Dumping data for table `relacao`
444--
445
446/*!40000 ALTER TABLE `relacao` DISABLE KEYS */;
447/*!40000 ALTER TABLE `relacao` ENABLE KEYS */;
448
449
450--
451-- Definition of table `relacao_conceito`
452--
453CREATE TABLE `relacao_conceito` (
454 `id_conceito` int(11) NOT NULL default '0',
455 `id_relacao` int(11) NOT NULL default '0',
456 `predicado` varchar(250) NOT NULL default '',
457 `id_projeto` int(11) NOT NULL default '30',
458 PRIMARY KEY (`id_conceito`,`id_relacao`,`predicado`,`id_projeto`)
459) ENGINE=MyISAM DEFAULT CHARSET=latin1;
460
461--
462-- Dumping data for table `relacao_conceito`
463--
464
465/*!40000 ALTER TABLE `relacao_conceito` DISABLE KEYS */;
466/*!40000 ALTER TABLE `relacao_conceito` ENABLE KEYS */;
467
468
469--
470-- Definition of table `sinonimo`
471--
472CREATE TABLE `sinonimo` (
473 `id_sinonimo` int(50) NOT NULL auto_increment,
474 `id_lexico` int(50) NOT NULL default '0',
475 `id_pedidolex` int(50) NOT NULL default '0',
476 `nome` varchar(50) NOT NULL default '',
477 `id_projeto` int(50) default NULL,
478 PRIMARY KEY (`id_sinonimo`)
479) ENGINE=MyISAM DEFAULT CHARSET=latin1;
480
481--
482-- Dumping data for table `sinonimo`
483--
484
485/*!40000 ALTER TABLE `sinonimo` DISABLE KEYS */;
486/*!40000 ALTER TABLE `sinonimo` ENABLE KEYS */;
487
488
489--
490-- Definition of table `status`
491--
492CREATE TABLE `status` (
493 `Id_status` int(2) NOT NULL auto_increment,
494 `Descricao` varchar(50) NOT NULL default '',
495 PRIMARY KEY (`Id_status`)
496) ENGINE=MyISAM DEFAULT CHARSET=latin1;
497
498--
499-- Dumping data for table `status`
500--
501
502/*!40000 ALTER TABLE `status` DISABLE KEYS */;
503/*!40000 ALTER TABLE `status` ENABLE KEYS */;
504
505
506--
507-- Definition of table `usuario`
508--
509CREATE TABLE `usuario` (
510 `id_usuario` int(11) NOT NULL auto_increment,
511 `nome` varchar(255) NOT NULL default '',
512 `email` varchar(64) NOT NULL default '',
513 `login` varchar(32) NOT NULL default '',
514 `senha` varchar(32) NOT NULL default '',
515 PRIMARY KEY (`id_usuario`),
516 UNIQUE KEY `IDX_usuario_2` (`login`)
517) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
518
519--
520-- Dumping data for table `usuario`
521--
522
523/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
524INSERT INTO `usuario` (`id_usuario`,`nome`,`email`,`login`,`senha`) VALUES
525 (1,'meu nome','email@blah.com','usuario','123'),
526 (2,'novo','novo@novo.com','novo','novo'),
527 (3,'1','1@1.com','aa','aa'),
528 (4,'teste123','teste123@teste.com','teste123','teste123'),
529 (5,'lyrene','lyrene@inf.cp','lyrene','321'),
530 (6,'nova','nova@teste.com','nova','nova'),
531 (7,'renata','renata@teste.com','renata','senha'),
532 (8,'teste','teste@teste.com','teste','teste'),
533 (9,'carolina','carolina@com.com','carolina','carolina');
534/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
535
536
537
538
539/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
540/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
541/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
542/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
543/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
544/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
545/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;