· 6 years ago · Jun 08, 2019, 01:44 AM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8I am DemonSad <3
9
10Target : http://www.uerj.br/ ( Universidade do Estado Do Rio De Janeiro )
11
12Greetings: TioSan, Angel, Cloudmore, NedLock
13
14--------------------------------------------------------------------------------------------
15-- MySQL Administrator dump 1.4
16--
17-- ------------------------------------------------------
18-- Server version 5.1.37-community
19
20
21/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
22/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
23/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
24/*!40101 SET NAMES utf8 */;
25
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
30
31--
32-- Create schema lnebulosaf
33--
34
35CREATE DATABASE /*!32312 IF NOT EXISTS*/ lnebulosaf;
36USE lnebulosaf;
37
38--
39-- Table structure for table `lnebulosaf`.`antecedente`
40--
41
42DROP TABLE IF EXISTS `antecedente`;
43CREATE TABLE `antecedente` (
44 `Cod_regra` int(10) unsigned NOT NULL,
45 `Cod_termo` int(10) unsigned NOT NULL,
46 PRIMARY KEY (`Cod_regra`,`Cod_termo`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49--
50-- Dumping data for table `lnebulosaf`.`antecedente`
51--
52
53/*!40000 ALTER TABLE `antecedente` DISABLE KEYS */;
54INSERT INTO `antecedente` (`Cod_regra`,`Cod_termo`) VALUES
55 (1,3),
56 (1,4),
57 (2,3),
58 (2,5),
59 (3,3),
60 (3,6),
61 (4,2),
62 (4,4),
63 (5,2),
64 (5,5),
65 (6,2),
66 (6,6),
67 (7,1),
68 (7,4),
69 (8,1),
70 (8,5),
71 (9,1),
72 (9,6);
73/*!40000 ALTER TABLE `antecedente` ENABLE KEYS */;
74
75
76--
77-- Table structure for table `lnebulosaf`.`regra`
78--
79
80DROP TABLE IF EXISTS `regra`;
81CREATE TABLE `regra` (
82 `Cod_Regra` int(10) unsigned NOT NULL AUTO_INCREMENT,
83 `Cod_Termo_Cons` int(10) unsigned NOT NULL,
84 `cod_sistema` int(10) unsigned DEFAULT NULL,
85 PRIMARY KEY (`Cod_Regra`)
86) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
87
88--
89-- Dumping data for table `lnebulosaf`.`regra`
90--
91
92/*!40000 ALTER TABLE `regra` DISABLE KEYS */;
93INSERT INTO `regra` (`Cod_Regra`,`Cod_Termo_Cons`,`cod_sistema`) VALUES
94 (1,8,1),
95 (2,8,1),
96 (3,7,1),
97 (4,9,1),
98 (5,8,1),
99 (6,8,1),
100 (7,10,1),
101 (8,9,1),
102 (9,8,1);
103/*!40000 ALTER TABLE `regra` ENABLE KEYS */;
104
105
106--
107-- Table structure for table `lnebulosaf`.`segmento`
108--
109
110DROP TABLE IF EXISTS `segmento`;
111CREATE TABLE `segmento` (
112 `Cod_Termo` int(10) unsigned NOT NULL DEFAULT '0',
113 `Cod_Segmento` int(10) unsigned NOT NULL DEFAULT '0',
114 `Intervalo_Esquerdo` decimal(10,5) NOT NULL DEFAULT '0.00000',
115 `Intervalo_Direito` decimal(10,5) NOT NULL DEFAULT '0.00000',
116 `Coef_Angular` decimal(18,4) NOT NULL DEFAULT '0.0000',
117 `Coef_Linear` decimal(18,4) NOT NULL DEFAULT '0.0000',
118 `Mi_Esquerdo` int(10) unsigned NOT NULL DEFAULT '0',
119 `Mi_Direito` int(10) unsigned NOT NULL DEFAULT '0',
120 PRIMARY KEY (`Cod_Termo`,`Cod_Segmento`)
121) ENGINE=InnoDB DEFAULT CHARSET=latin1;
122
123--
124-- Dumping data for table `lnebulosaf`.`segmento`
125--
126
127/*!40000 ALTER TABLE `segmento` DISABLE KEYS */;
128INSERT INTO `segmento` (`Cod_Termo`,`Cod_Segmento`,`Intervalo_Esquerdo`,`Intervalo_Direito`,`Coef_Angular`,`Coef_Linear`,`Mi_Esquerdo`,`Mi_Direito`) VALUES
129 (1,1,'0.00000','20.00000','0.0000','0.0000',0,0),
130 (1,2,'20.00000','40.00000','0.0500','-1.0000',0,1),
131 (2,1,'0.00000','10.00000','0.0000','0.0000',0,0),
132 (2,2,'10.00000','20.00000','0.1000','-1.0000',0,1),
133 (2,3,'20.00000','30.00000','-0.1000','3.0000',1,0),
134 (2,4,'30.00000','40.00000','0.0000','0.0000',0,0),
135 (3,1,'0.00000','20.00000','-0.0500','1.0000',1,0),
136 (3,2,'20.00000','40.00000','0.0000','0.0000',0,0),
137 (4,1,'0.00000','5.00000','0.0000','1.0000',1,1),
138 (4,2,'5.00000','10.00000','-0.2000','2.0000',1,0),
139 (4,3,'10.00000','20.00000','0.0000','0.0000',0,0),
140 (5,1,'0.00000','5.00000','0.0000','0.0000',0,0),
141 (5,2,'5.00000','10.00000','0.2000','-1.0000',0,1),
142 (5,3,'10.00000','15.00000','-0.2000','3.0000',1,0),
143 (5,4,'15.00000','20.00000','0.0000','0.0000',0,0),
144 (6,1,'0.00000','10.00000','0.0000','0.0000',0,0),
145 (6,2,'10.00000','15.00000','0.2000','-2.0000',0,1),
146 (6,3,'15.00000','20.00000','0.0000','1.0000',1,1);
147INSERT INTO `segmento` (`Cod_Termo`,`Cod_Segmento`,`Intervalo_Esquerdo`,`Intervalo_Direito`,`Coef_Angular`,`Coef_Linear`,`Mi_Esquerdo`,`Mi_Direito`) VALUES
148 (7,1,'0.00000','40.00000','-0.0250','1.0000',1,0),
149 (7,2,'40.00000','120.00000','0.0000','0.0000',0,0),
150 (8,1,'0.00000','40.00000','0.0250','0.0000',0,1),
151 (8,2,'40.00000','80.00000','-0.0250','2.0000',1,0),
152 (8,3,'80.00000','120.00000','0.0000','0.0000',0,0),
153 (9,1,'0.00000','40.00000','0.0000','0.0000',0,0),
154 (9,2,'40.00000','80.00000','0.0250','-1.0000',0,1),
155 (9,3,'80.00000','120.00000','-0.0250','3.0000',1,0),
156 (10,1,'0.00000','80.00000','0.0000','0.0000',0,0),
157 (10,2,'80.00000','120.00000','0.0250','-2.0000',0,1);
158/*!40000 ALTER TABLE `segmento` ENABLE KEYS */;
159
160
161--
162-- Table structure for table `lnebulosaf`.`sistema`
163--
164
165DROP TABLE IF EXISTS `sistema`;
166CREATE TABLE `sistema` (
167 `cod_sistema` int(3) unsigned NOT NULL DEFAULT '0',
168 `nom_sistema` varchar(20) NOT NULL DEFAULT '',
169 PRIMARY KEY (`cod_sistema`)
170) ENGINE=InnoDB DEFAULT CHARSET=latin1;
171
172--
173-- Dumping data for table `lnebulosaf`.`sistema`
174--
175
176/*!40000 ALTER TABLE `sistema` DISABLE KEYS */;
177INSERT INTO `sistema` (`cod_sistema`,`nom_sistema`) VALUES
178 (1,'Estrada');
179/*!40000 ALTER TABLE `sistema` ENABLE KEYS */;
180
181
182--
183-- Table structure for table `lnebulosaf`.`termo`
184--
185
186DROP TABLE IF EXISTS `termo`;
187CREATE TABLE `termo` (
188 `Cod_Termo` int(11) NOT NULL AUTO_INCREMENT,
189 `Cod_Variavel` int(11) NOT NULL DEFAULT '0',
190 `Nom_Termo` varchar(50) NOT NULL DEFAULT '',
191 PRIMARY KEY (`Cod_Termo`,`Cod_Variavel`)
192) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
193
194--
195-- Dumping data for table `lnebulosaf`.`termo`
196--
197
198/*!40000 ALTER TABLE `termo` DISABLE KEYS */;
199INSERT INTO `termo` (`Cod_Termo`,`Cod_Variavel`,`Nom_Termo`) VALUES
200 (1,1,'Ampla'),
201 (2,1,'Media'),
202 (3,1,'Estreita'),
203 (4,2,'Livre'),
204 (5,2,'Moderado'),
205 (6,2,'Intenso'),
206 (7,3,'Muito_Lenta'),
207 (8,3,'Lenta'),
208 (9,3,'Rapida'),
209 (10,3,'Muito_Rapida');
210/*!40000 ALTER TABLE `termo` ENABLE KEYS */;
211
212
213--
214-- Table structure for table `lnebulosaf`.`variavel_linguistica`
215--
216
217DROP TABLE IF EXISTS `variavel_linguistica`;
218CREATE TABLE `variavel_linguistica` (
219 `Cod_variavel` int(10) unsigned NOT NULL AUTO_INCREMENT,
220 `nom_variavel` varchar(50) NOT NULL DEFAULT '',
221 `ini_universo` int(10) unsigned NOT NULL DEFAULT '0',
222 `fim_universo` int(10) unsigned NOT NULL DEFAULT '0',
223 `cod_sistema` int(3) unsigned DEFAULT NULL,
224 `flag_antecedente` char(1) NOT NULL DEFAULT '',
225 PRIMARY KEY (`Cod_variavel`)
226) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
227
228--
229-- Dumping data for table `lnebulosaf`.`variavel_linguistica`
230--
231
232/*!40000 ALTER TABLE `variavel_linguistica` DISABLE KEYS */;
233INSERT INTO `variavel_linguistica` (`Cod_variavel`,`nom_variavel`,`ini_universo`,`fim_universo`,`cod_sistema`,`flag_antecedente`) VALUES
234 (1,'Largura',0,40,1,'1'),
235 (2,'Transito',0,20,1,'1'),
236 (3,'Velocidade',0,120,1,'0');
237/*!40000 ALTER TABLE `variavel_linguistica` ENABLE KEYS */;
238
239/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
240/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
241/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
242/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
243/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
244/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
245/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;