· 6 years ago · Jul 28, 2019, 06:50 AM
1 ██▓ █ ██ ██▓ ▒███████▒ ▄▄▄▄ ██▀███
2▓██▒ ██ ▓██▒▓██▒ ▒ ▒ ▒ ▄▀░▓█████▄ ▓██ ▒ ██▒
3▒██░ ▓██ ▒██░▒██░ ░ ▒ ▄▀▒░ ▒██▒ ▄██▓██ ░▄█ ▒
4▒██░ ▓▓█ ░██░▒██░ ▄▀▒ ░▒██░█▀ ▒██▀▀█▄
5░██████▒▒▒█████▓ ░██████▒▒███████▒░▓█ ▀█▓░██▓ ▒██▒
6░ ▒░▓ ░░▒▓▒ ▒ ▒ ░ ▒░▓ ░░▒▒ ▓░▒░▒░▒▓███▀▒░ ▒▓ ░▒▓░
7░ ░ ▒ ░░░▒░ ░ ░ ░ ░ ▒ ░░░▒ ▒ ░ ▒▒░▒ ░ ░▒ ░ ▒░
8 ░ ░ ░░░ ░ ░ ░ ░ ░ ░ ░ ░ ░ ░ ░ ░░ ░
9 ░ ░ ░ ░ ░ ░ ░ ░ ░
10 ░ ░
11
12Lulz BR | Data Leak FEN/UERJ -> FACULDADE DE ENGENHARIA
13
14--------------------------------------------------------------------------------------------------
15DROP TABLE IF EXISTS `antecedente`;
16CREATE TABLE `antecedente` (
17 `Cod_regra` int(10) unsigned NOT NULL,
18 `Cod_termo` int(10) unsigned NOT NULL,
19 PRIMARY KEY (`Cod_regra`,`Cod_termo`)
20) ENGINE=InnoDB DEFAULT CHARSET=latin1;
21
22--
23-- Dumping data for table `lnebulosaf`.`antecedente`
24--
25
26/*!40000 ALTER TABLE `antecedente` DISABLE KEYS */;
27INSERT INTO `antecedente` (`Cod_regra`,`Cod_termo`) VALUES
28 (1,3),
29 (1,4),
30 (2,3),
31 (2,5),
32 (3,3),
33 (3,6),
34 (4,2),
35 (4,4),
36 (5,2),
37 (5,5),
38 (6,2),
39 (6,6),
40 (7,1),
41 (7,4),
42 (8,1),
43 (8,5),
44 (9,1),
45 (9,6);
46/*!40000 ALTER TABLE `antecedente` ENABLE KEYS */;
47
48
49--
50-- Table structure for table `lnebulosaf`.`regra`
51--
52
53DROP TABLE IF EXISTS `regra`;
54CREATE TABLE `regra` (
55 `Cod_Regra` int(10) unsigned NOT NULL AUTO_INCREMENT,
56 `Cod_Termo_Cons` int(10) unsigned NOT NULL,
57 `cod_sistema` int(10) unsigned DEFAULT NULL,
58 PRIMARY KEY (`Cod_Regra`)
59) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
60
61--
62-- Dumping data for table `lnebulosaf`.`regra`
63--
64
65/*!40000 ALTER TABLE `regra` DISABLE KEYS */;
66INSERT INTO `regra` (`Cod_Regra`,`Cod_Termo_Cons`,`cod_sistema`) VALUES
67 (1,8,1),
68 (2,8,1),
69 (3,7,1),
70 (4,9,1),
71 (5,8,1),
72 (6,8,1),
73 (7,10,1),
74 (8,9,1),
75 (9,8,1);
76/*!40000 ALTER TABLE `regra` ENABLE KEYS */;
77
78
79--
80-- Table structure for table `lnebulosaf`.`segmento`
81--
82
83DROP TABLE IF EXISTS `segmento`;
84CREATE TABLE `segmento` (
85 `Cod_Termo` int(10) unsigned NOT NULL DEFAULT '0',
86 `Cod_Segmento` int(10) unsigned NOT NULL DEFAULT '0',
87 `Intervalo_Esquerdo` decimal(10,5) NOT NULL DEFAULT '0.00000',
88 `Intervalo_Direito` decimal(10,5) NOT NULL DEFAULT '0.00000',
89 `Coef_Angular` decimal(18,4) NOT NULL DEFAULT '0.0000',
90 `Coef_Linear` decimal(18,4) NOT NULL DEFAULT '0.0000',
91 `Mi_Esquerdo` int(10) unsigned NOT NULL DEFAULT '0',
92 `Mi_Direito` int(10) unsigned NOT NULL DEFAULT '0',
93 PRIMARY KEY (`Cod_Termo`,`Cod_Segmento`)
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95
96--
97-- Dumping data for table `lnebulosaf`.`segmento`
98--
99
100/*!40000 ALTER TABLE `segmento` DISABLE KEYS */;
101INSERT INTO `segmento` (`Cod_Termo`,`Cod_Segmento`,`Intervalo_Esquerdo`,`Intervalo_Direito`,`Coef_Angular`,`Coef_Linear`,`Mi_Esquerdo`,`Mi_Direito`) VALUES
102 (1,1,'0.00000','20.00000','0.0000','0.0000',0,0),
103 (1,2,'20.00000','40.00000','0.0500','-1.0000',0,1),
104 (2,1,'0.00000','10.00000','0.0000','0.0000',0,0),
105 (2,2,'10.00000','20.00000','0.1000','-1.0000',0,1),
106 (2,3,'20.00000','30.00000','-0.1000','3.0000',1,0),
107 (2,4,'30.00000','40.00000','0.0000','0.0000',0,0),
108 (3,1,'0.00000','20.00000','-0.0500','1.0000',1,0),
109 (3,2,'20.00000','40.00000','0.0000','0.0000',0,0),
110 (4,1,'0.00000','5.00000','0.0000','1.0000',1,1),
111 (4,2,'5.00000','10.00000','-0.2000','2.0000',1,0),
112 (4,3,'10.00000','20.00000','0.0000','0.0000',0,0),
113 (5,1,'0.00000','5.00000','0.0000','0.0000',0,0),
114 (5,2,'5.00000','10.00000','0.2000','-1.0000',0,1),
115 (5,3,'10.00000','15.00000','-0.2000','3.0000',1,0),
116 (5,4,'15.00000','20.00000','0.0000','0.0000',0,0),
117 (6,1,'0.00000','10.00000','0.0000','0.0000',0,0),
118 (6,2,'10.00000','15.00000','0.2000','-2.0000',0,1),
119 (6,3,'15.00000','20.00000','0.0000','1.0000',1,1);
120INSERT INTO `segmento` (`Cod_Termo`,`Cod_Segmento`,`Intervalo_Esquerdo`,`Intervalo_Direito`,`Coef_Angular`,`Coef_Linear`,`Mi_Esquerdo`,`Mi_Direito`) VALUES
121 (7,1,'0.00000','40.00000','-0.0250','1.0000',1,0),
122 (7,2,'40.00000','120.00000','0.0000','0.0000',0,0),
123 (8,1,'0.00000','40.00000','0.0250','0.0000',0,1),
124 (8,2,'40.00000','80.00000','-0.0250','2.0000',1,0),
125 (8,3,'80.00000','120.00000','0.0000','0.0000',0,0),
126 (9,1,'0.00000','40.00000','0.0000','0.0000',0,0),
127 (9,2,'40.00000','80.00000','0.0250','-1.0000',0,1),
128 (9,3,'80.00000','120.00000','-0.0250','3.0000',1,0),
129 (10,1,'0.00000','80.00000','0.0000','0.0000',0,0),
130 (10,2,'80.00000','120.00000','0.0250','-2.0000',0,1);
131/*!40000 ALTER TABLE `segmento` ENABLE KEYS */;
132
133
134--
135-- Table structure for table `lnebulosaf`.`sistema`
136--
137
138DROP TABLE IF EXISTS `sistema`;
139CREATE TABLE `sistema` (
140 `cod_sistema` int(3) unsigned NOT NULL DEFAULT '0',
141 `nom_sistema` varchar(20) NOT NULL DEFAULT '',
142 PRIMARY KEY (`cod_sistema`)
143) ENGINE=InnoDB DEFAULT CHARSET=latin1;
144
145--
146-- Dumping data for table `lnebulosaf`.`sistema`
147--
148
149/*!40000 ALTER TABLE `sistema` DISABLE KEYS */;
150INSERT INTO `sistema` (`cod_sistema`,`nom_sistema`) VALUES
151 (1,'Estrada');
152/*!40000 ALTER TABLE `sistema` ENABLE KEYS */;
153
154
155--
156-- Table structure for table `lnebulosaf`.`termo`
157--
158
159DROP TABLE IF EXISTS `termo`;
160CREATE TABLE `termo` (
161 `Cod_Termo` int(11) NOT NULL AUTO_INCREMENT,
162 `Cod_Variavel` int(11) NOT NULL DEFAULT '0',
163 `Nom_Termo` varchar(50) NOT NULL DEFAULT '',
164 PRIMARY KEY (`Cod_Termo`,`Cod_Variavel`)
165) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
166
167--
168-- Dumping data for table `lnebulosaf`.`termo`
169--
170
171/*!40000 ALTER TABLE `termo` DISABLE KEYS */;
172INSERT INTO `termo` (`Cod_Termo`,`Cod_Variavel`,`Nom_Termo`) VALUES
173 (1,1,'Ampla'),
174 (2,1,'Media'),
175 (3,1,'Estreita'),
176 (4,2,'Livre'),
177 (5,2,'Moderado'),
178 (6,2,'Intenso'),
179 (7,3,'Muito_Lenta'),
180 (8,3,'Lenta'),
181 (9,3,'Rapida'),
182 (10,3,'Muito_Rapida');
183/*!40000 ALTER TABLE `termo` ENABLE KEYS */;
184
185
186--
187-- Table structure for table `lnebulosaf`.`variavel_linguistica`
188--
189
190DROP TABLE IF EXISTS `variavel_linguistica`;
191CREATE TABLE `variavel_linguistica` (
192 `Cod_variavel` int(10) unsigned NOT NULL AUTO_INCREMENT,
193 `nom_variavel` varchar(50) NOT NULL DEFAULT '',
194 `ini_universo` int(10) unsigned NOT NULL DEFAULT '0',
195 `fim_universo` int(10) unsigned NOT NULL DEFAULT '0',
196 `cod_sistema` int(3) unsigned DEFAULT NULL,
197 `flag_antecedente` char(1) NOT NULL DEFAULT '',
198 PRIMARY KEY (`Cod_variavel`)
199) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
200
201--
202-- Dumping data for table `lnebulosaf`.`variavel_linguistica`
203--
204
205/*!40000 ALTER TABLE `variavel_linguistica` DISABLE KEYS */;
206INSERT INTO `variavel_linguistica` (`Cod_variavel`,`nom_variavel`,`ini_universo`,`fim_universo`,`cod_sistema`,`flag_antecedente`) VALUES
207 (1,'Largura',0,40,1,'1'),
208 (2,'Transito',0,20,1,'1'),
209 (3,'Velocidade',0,120,1,'0');
210/*!40000 ALTER TABLE `variavel_linguistica` ENABLE KEYS */;