pfypsK7G

1-- MySQL dump 10.13  Distrib 5.7.20, for Linux (x86_64)
2--
3-- Host: localhost    Database: fgv_epge_nc_report4
4-- ------------------------------------------------------
5-- Server version	5.7.20
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 utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `aluno`
20--
21
22DROP TABLE IF EXISTS `aluno`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `aluno` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `pessoaID` int(11) NOT NULL,
28  `cursoID` int(11) NOT NULL,
29  `matricula` varchar(15) NOT NULL,
30  PRIMARY KEY (`id`,`pessoaID`),
31  UNIQUE KEY `matricula_UNIQUE` (`matricula`),
32  KEY `fk_aluno_pessoa1_idx` (`pessoaID`),
33  KEY `fk_aluno_curso1_idx` (`cursoID`),
34  CONSTRAINT `fk_aluno_curso1` FOREIGN KEY (`cursoID`) REFERENCES `curso` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
35  CONSTRAINT `fk_aluno_pessoa1` FOREIGN KEY (`pessoaID`) REFERENCES `pessoa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
36) ENGINE=InnoDB DEFAULT CHARSET=utf8;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `aluno`
41--
42
43LOCK TABLES `aluno` WRITE;
44/*!40000 ALTER TABLE `aluno` DISABLE KEYS */;
45/*!40000 ALTER TABLE `aluno` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `apresentacao_trabalho`
50--
51
52DROP TABLE IF EXISTS `apresentacao_trabalho`;
53/*!40101 SET @saved_cs_client     = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `apresentacao_trabalho` (
56  `id` int(11) NOT NULL AUTO_INCREMENT,
57  `pessoaID` int(11) NOT NULL,
58  `natureza` varchar(255) NOT NULL,
59  `titulo` varchar(400) NOT NULL,
60  `ano` int(4) NOT NULL,
61  `pais` varchar(30) DEFAULT NULL,
62  `idioma` varchar(45) DEFAULT NULL,
63  `nomeEvento` varchar(255) DEFAULT NULL COMMENT 'Nome do evento',
64  `instituicaoPromotora` varchar(255) DEFAULT NULL COMMENT 'Instiuição promotora',
65  `localApresentacao` varchar(255) DEFAULT NULL COMMENT 'Local de apresentação',
66  `cidadeApresentacao` varchar(64) DEFAULT NULL COMMENT 'Cidade de apresentação',
67  `hash` varchar(32) NOT NULL,
68  PRIMARY KEY (`id`),
69  UNIQUE KEY `hash_UNIQUE` (`hash`),
70  KEY `fk_apresentacao_trabalho_pessoa1_idx` (`pessoaID`),
71  CONSTRAINT `fk_apresentacao_trabalho_pessoa1` FOREIGN KEY (`pessoaID`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
72) ENGINE=InnoDB DEFAULT CHARSET=utf8;
73/*!40101 SET character_set_client = @saved_cs_client */;
74
75--
76-- Dumping data for table `apresentacao_trabalho`
77--
78
79LOCK TABLES `apresentacao_trabalho` WRITE;
80/*!40000 ALTER TABLE `apresentacao_trabalho` DISABLE KEYS */;
81/*!40000 ALTER TABLE `apresentacao_trabalho` ENABLE KEYS */;
82UNLOCK TABLES;
83
84--
85-- Table structure for table `artigo`
86--
87
88DROP TABLE IF EXISTS `artigo`;
89/*!40101 SET @saved_cs_client     = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `artigo` (
92  `id` int(11) NOT NULL AUTO_INCREMENT,
93  `producaoBibliograficaID` int(11) NOT NULL,
94  `periodicoID` int(11) NOT NULL,
95  `natureza` varchar(255) DEFAULT NULL,
96  `volume` varchar(64) DEFAULT NULL,
97  `fasciculo` varchar(64) DEFAULT NULL,
98  `serie` varchar(64) DEFAULT NULL,
99  `paginaInicial` varchar(20) DEFAULT NULL,
100  `paginaFinal` varchar(20) DEFAULT NULL,
101  `localPublicacao` varchar(100) DEFAULT NULL,
102  `publicado` tinyint(1) NOT NULL DEFAULT '0',
103  `fatorCAPES` float NOT NULL DEFAULT '1',
104  `fatorEPGE` float NOT NULL DEFAULT '1',
105  PRIMARY KEY (`id`,`producaoBibliograficaID`),
106  KEY `fk_artigo_producao_bibliografica1_idx` (`producaoBibliograficaID`),
107  KEY `fk_artigo_periodico1_idx` (`periodicoID`),
108  CONSTRAINT `fk_artigo_periodico1` FOREIGN KEY (`periodicoID`) REFERENCES `periodico` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
109  CONSTRAINT `fk_artigo_producao_bibliografica1` FOREIGN KEY (`producaoBibliograficaID`) REFERENCES `producao_bibliografica` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
110) ENGINE=InnoDB DEFAULT CHARSET=utf8;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `artigo`
115--
116
117LOCK TABLES `artigo` WRITE;
118/*!40000 ALTER TABLE `artigo` DISABLE KEYS */;
119/*!40000 ALTER TABLE `artigo` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `artigos_tipo_note`
124--
125
126DROP TABLE IF EXISTS `artigos_tipo_note`;
127/*!40101 SET @saved_cs_client     = @@character_set_client */;
128/*!40101 SET character_set_client = utf8 */;
129CREATE TABLE `artigos_tipo_note` (
130  `id` int(11) NOT NULL AUTO_INCREMENT,
131  `hash` varchar(32) NOT NULL,
132  `fatorEPGE` float NOT NULL,
133  `fatorCAPES` float NOT NULL,
134  PRIMARY KEY (`id`)
135) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
136/*!40101 SET character_set_client = @saved_cs_client */;
137
138--
139-- Dumping data for table `artigos_tipo_note`
140--
141
142LOCK TABLES `artigos_tipo_note` WRITE;
143/*!40000 ALTER TABLE `artigos_tipo_note` DISABLE KEYS */;
144INSERT INTO `artigos_tipo_note` VALUES (1,'df680ab0d9a8eea06e415a20ea14c315',0.6,1),(2,'8be66902b10b0efd83ddd438938f8b76',0.6,1),(3,'3f063a28a139e0810e9b9f62ed99e777',0.6,1),(4,'2da42cae38b66dba599066bbfda0c400',0.6,1),(5,'0900e46551b8b4f09f438b737a00ce8a',0.6,1),(6,'41ad7498039156f86cfc8305dd181ef3',0.6,1),(7,'dc78d6f3ce91e3d3bc1b93993bb187f0',0.6,1),(8,'ff4e466c01186b1fe7371cab4cf07ec0',0.6,1),(9,'51cea746f26ab4788bf96b769c3b713a',0.6,1),(10,'131bd9324edee7ee516c4545e6c1eb55',0.6,1),(11,'8d819a8752f8f99a958e68e433bd3bcf',0.6,1),(12,'4348fbcc6301591a1065ea1a98caf968',0.6,1),(13,'cd4fe1820d7f6617cf219a916e58701b',0.6,1),(14,'c1dd4f92c68800047c74ff084500a9dc',0.6,1),(15,'8ad4350e0dd46a240173fd81da5f558e',0.6,1),(16,'7673d25af361f564b12227ac588b4a8e',0.6,1),(17,'21755c0437e3753b4a15f3a8d62544eb',0.6,0),(18,'6b1b56c01a61c09c74b05f0d39964690',0.6,0);
145/*!40000 ALTER TABLE `artigos_tipo_note` ENABLE KEYS */;
146UNLOCK TABLES;
147
148--
149-- Table structure for table `authassignment`
150--
151
152DROP TABLE IF EXISTS `authassignment`;
153/*!40101 SET @saved_cs_client     = @@character_set_client */;
154/*!40101 SET character_set_client = utf8 */;
155CREATE TABLE `authassignment` (
156  `itemname` varchar(64) NOT NULL,
157  `userid` int(11) NOT NULL,
158  `bizrule` text,
159  `data` text,
160  PRIMARY KEY (`itemname`,`userid`) USING BTREE,
161  KEY `fk_authassignment_usuario1_idx` (`userid`),
162  CONSTRAINT `authassignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
163  CONSTRAINT `fk_authassignment_usuario1` FOREIGN KEY (`userid`) REFERENCES `usuario` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
164) ENGINE=InnoDB DEFAULT CHARSET=utf8;
165/*!40101 SET character_set_client = @saved_cs_client */;
166
167--
168-- Dumping data for table `authassignment`
169--
170
171LOCK TABLES `authassignment` WRITE;
172/*!40000 ALTER TABLE `authassignment` DISABLE KEYS */;
173INSERT INTO `authassignment` VALUES ('Admin',1,NULL,'N;'),('Admin',13,NULL,'N;'),('Admin',15,NULL,'N;'),('Admin',16,NULL,'N;'),('Admin',19,NULL,'N;'),('Admin',21,NULL,'N;'),('Admin',22,NULL,'N;');
174/*!40000 ALTER TABLE `authassignment` ENABLE KEYS */;
175UNLOCK TABLES;
176
177--
178-- Table structure for table `authitem`
179--
180
181DROP TABLE IF EXISTS `authitem`;
182/*!40101 SET @saved_cs_client     = @@character_set_client */;
183/*!40101 SET character_set_client = utf8 */;
184CREATE TABLE `authitem` (
185  `name` varchar(64) NOT NULL,
186  `type` int(11) NOT NULL,
187  `description` text,
188  `bizrule` text,
189  `data` text,
190  PRIMARY KEY (`name`)
191) ENGINE=InnoDB DEFAULT CHARSET=utf8;
192/*!40101 SET character_set_client = @saved_cs_client */;
193
194--
195-- Dumping data for table `authitem`
196--
197
198LOCK TABLES `authitem` WRITE;
199/*!40000 ALTER TABLE `authitem` DISABLE KEYS */;
200INSERT INTO `authitem` VALUES ('Admin',2,NULL,NULL,'N;'),('Aluno.*',1,NULL,NULL,'N;'),('Aluno.Cadastrar',0,NULL,NULL,'N;'),('Aluno.Editar',0,NULL,NULL,'N;'),('Aluno.Excluir',0,NULL,NULL,'N;'),('Aluno.Exibe',0,NULL,NULL,'N;'),('Aluno.Index',0,NULL,NULL,'N;'),('Cadastros',2,'Realiza cadastro em geral',NULL,'N;'),('Categorias.*',1,NULL,NULL,'N;'),('Categorias.Cadastrar',0,NULL,NULL,'N;'),('Categorias.Editar',0,NULL,NULL,'N;'),('Categorias.Excluir',0,NULL,NULL,'N;'),('Categorias.Exibe',0,NULL,NULL,'N;'),('Categorias.Index',0,NULL,NULL,'N;'),('Image.Default.*',1,NULL,NULL,'N;'),('Image.Default.Create',0,NULL,NULL,'N;'),('Image.Default.Index',0,NULL,NULL,'N;'),('Image.Install.*',1,NULL,NULL,'N;'),('Image.Install.Confirm',0,NULL,NULL,'N;'),('Image.Install.Create',0,NULL,NULL,'N;'),('Image.Install.Error',0,NULL,NULL,'N;'),('Image.Install.Index',0,NULL,NULL,'N;'),('Image.Install.Ready',0,NULL,NULL,'N;'),('Instituicoes.*',1,NULL,NULL,'N;'),('Instituicoes.Cadastrar',0,NULL,NULL,'N;'),('Instituicoes.Editar',0,NULL,NULL,'N;'),('Instituicoes.Excluir',0,NULL,NULL,'N;'),('Instituicoes.Exibe',0,NULL,NULL,'N;'),('Instituicoes.Index',0,NULL,NULL,'N;'),('Lattes.ApresentacaoTrabalho.*',1,NULL,NULL,'N;'),('Lattes.ApresentacaoTrabalho.Admin',0,NULL,NULL,'N;'),('Lattes.ApresentacaoTrabalho.Cadastrar',0,NULL,NULL,'N;'),('Lattes.ApresentacaoTrabalho.Editar',0,NULL,NULL,'N;'),('Lattes.ApresentacaoTrabalho.Excluir',0,NULL,NULL,'N;'),('Lattes.ApresentacaoTrabalho.Exibe',0,NULL,NULL,'N;'),('Lattes.ApresentacaoTrabalho.Index',0,NULL,NULL,'N;'),('Lattes.Artigo.*',1,NULL,NULL,'N;'),('Lattes.Artigo.Admin',0,NULL,NULL,'N;'),('Lattes.Artigo.Editar',0,NULL,NULL,'N;'),('Lattes.Artigo.Excluir',0,NULL,NULL,'N;'),('Lattes.Artigo.Exibe',0,NULL,NULL,'N;'),('Lattes.Artigo.Index',0,NULL,NULL,'N;'),('Lattes.CapituloLivro.*',1,NULL,NULL,'N;'),('Lattes.CapituloLivro.Admin',0,NULL,NULL,'N;'),('Lattes.CapituloLivro.Editar',0,NULL,NULL,'N;'),('Lattes.CapituloLivro.Excluir',0,NULL,NULL,'N;'),('Lattes.CapituloLivro.Exibe',0,NULL,NULL,'N;'),('Lattes.CapituloLivro.Index',0,NULL,NULL,'N;'),('Lattes.Default.*',1,NULL,NULL,'N;'),('Lattes.Default.Index',0,NULL,NULL,'N;'),('Lattes.DemaisTrabalhos.*',1,NULL,NULL,'N;'),('Lattes.DemaisTrabalhos.Admin',0,NULL,NULL,'N;'),('Lattes.DemaisTrabalhos.Editar',0,NULL,NULL,'N;'),('Lattes.DemaisTrabalhos.Excluir',0,NULL,NULL,'N;'),('Lattes.DemaisTrabalhos.Exibe',0,NULL,NULL,'N;'),('Lattes.DemaisTrabalhos.Index',0,NULL,NULL,'N;'),('Lattes.ImportaCurriculoAlunos.*',1,NULL,NULL,'N;'),('Lattes.ImportaCurriculoAlunos.Importar',0,NULL,NULL,'N;'),('Lattes.ImportaCurriculoAlunos.ImportProgress',0,NULL,NULL,'N;'),('Lattes.ImportaCurriculoAlunos.Index',0,NULL,NULL,'N;'),('Lattes.ImportaCurriculoDocentes.*',1,NULL,NULL,'N;'),('Lattes.ImportaCurriculoDocentes.ImportProgress',0,NULL,NULL,'N;'),('Lattes.ImportaCurriculoDocentes.Index',0,NULL,NULL,'N;'),('Lattes.Livro.*',1,NULL,NULL,'N;'),('Lattes.Livro.Admin',0,NULL,NULL,'N;'),('Lattes.Livro.Editar',0,NULL,NULL,'N;'),('Lattes.Livro.Excluir',0,NULL,NULL,'N;'),('Lattes.Livro.Exibe',0,NULL,NULL,'N;'),('Lattes.Livro.Index',0,NULL,NULL,'N;'),('Lattes.OrganizacaoEvento.*',1,NULL,NULL,'N;'),('Lattes.OrganizacaoEvento.Admin',0,NULL,NULL,'N;'),('Lattes.OrganizacaoEvento.Editar',0,NULL,NULL,'N;'),('Lattes.OrganizacaoEvento.Excluir',0,NULL,NULL,'N;'),('Lattes.OrganizacaoEvento.Exibe',0,NULL,NULL,'N;'),('Lattes.OrganizacaoEvento.Index',0,NULL,NULL,'N;'),('Lattes.OutraProducao.*',1,NULL,NULL,'N;'),('Lattes.OutraProducao.Admin',0,NULL,NULL,'N;'),('Lattes.OutraProducao.Editar',0,NULL,NULL,'N;'),('Lattes.OutraProducao.Excluir',0,NULL,NULL,'N;'),('Lattes.OutraProducao.Exibe',0,NULL,NULL,'N;'),('Lattes.OutraProducao.Index',0,NULL,NULL,'N;'),('Lattes.ParticipacaoEvento.*',1,NULL,NULL,'N;'),('Lattes.ParticipacaoEvento.Admin',0,NULL,NULL,'N;'),('Lattes.ParticipacaoEvento.Cadastrar',0,NULL,NULL,'N;'),('Lattes.ParticipacaoEvento.Editar',0,NULL,NULL,'N;'),('Lattes.ParticipacaoEvento.Excluir',0,NULL,NULL,'N;'),('Lattes.ParticipacaoEvento.Exibe',0,NULL,NULL,'N;'),('Lattes.ParticipacaoEvento.Index',0,NULL,NULL,'N;'),('Lattes.PremioTitulo.*',1,NULL,NULL,'N;'),('Lattes.PremioTitulo.Admin',0,NULL,NULL,'N;'),('Lattes.PremioTitulo.Cadastrar',0,NULL,NULL,'N;'),('Lattes.PremioTitulo.Editar',0,NULL,NULL,'N;'),('Lattes.PremioTitulo.Excluir',0,NULL,NULL,'N;'),('Lattes.PremioTitulo.Exibe',0,NULL,NULL,'N;'),('Lattes.PremioTitulo.Index',0,NULL,NULL,'N;'),('Lattes.ProjetoPesquisa.*',1,NULL,NULL,'N;'),('Lattes.ProjetoPesquisa.Admin',0,NULL,NULL,'N;'),('Lattes.ProjetoPesquisa.Editar',0,NULL,NULL,'N;'),('Lattes.ProjetoPesquisa.Excluir',0,NULL,NULL,'N;'),('Lattes.ProjetoPesquisa.Exibe',0,NULL,NULL,'N;'),('Lattes.ProjetoPesquisa.Index',0,NULL,NULL,'N;'),('Lattes.TextoEmJornalRevista.*',1,NULL,NULL,'N;'),('Lattes.TextoEmJornalRevista.Admin',0,NULL,NULL,'N;'),('Lattes.TextoEmJornalRevista.Editar',0,NULL,NULL,'N;'),('Lattes.TextoEmJornalRevista.Excluir',0,NULL,NULL,'N;'),('Lattes.TextoEmJornalRevista.Exibe',0,NULL,NULL,'N;'),('Lattes.TextoEmJornalRevista.Index',0,NULL,NULL,'N;'),('Periodico.*',1,NULL,NULL,'N;'),('Periodico.Admin',0,NULL,NULL,'N;'),('Periodico.Cadastrar',0,NULL,NULL,'N;'),('Periodico.Editar',0,NULL,NULL,'N;'),('Periodico.Excluir',0,NULL,NULL,'N;'),('Periodico.Exibe',0,NULL,NULL,'N;'),('Periodico.Index',0,NULL,NULL,'N;'),('Professor.*',1,NULL,NULL,'N;'),('Professor.Admin',0,NULL,NULL,'N;'),('Professor.Cadastrar',0,NULL,NULL,'N;'),('Professor.Editar',0,NULL,NULL,'N;'),('Professor.Excluir',0,NULL,NULL,'N;'),('Professor.Exibe',0,NULL,NULL,'N;'),('Professor.Index',0,NULL,NULL,'N;'),('Relatorios.CargaHoraria.*',1,NULL,NULL,'N;'),('Relatorios.CargaHoraria.Index',0,NULL,NULL,'N;'),('Relatorios.Default.*',1,NULL,NULL,'N;'),('Relatorios.Default.Index',0,NULL,NULL,'N;'),('Relatorios.Lecionadas.*',1,NULL,NULL,'N;'),('Relatorios.Lecionadas.Lecionadas',0,NULL,NULL,'N;'),('Relatorios.Orientacoes.*',1,NULL,NULL,'N;'),('Relatorios.Orientacoes.ListaEmAndamentoPorProfessor',0,NULL,NULL,'N;'),('Relatorios.Orientacoes.RealizadasPorAno',0,NULL,NULL,'N;'),('Relatorios.Orientacoes.RealizadasPorProfessor',0,NULL,NULL,'N;'),('Relatorios.Orientacoes.TabelaEmAndamento',0,NULL,NULL,'N;'),('Relatorios.Orientacoes.TabelaRealizadas',0,NULL,NULL,'N;'),('Relatorios.TurmasOrientacoes.*',1,NULL,NULL,'N;'),('Relatorios.TurmasOrientacoes.Index',0,NULL,NULL,'N;'),('Relatorios.TurmasOrientacoes.Professores',0,NULL,NULL,'N;'),('Site.*',1,NULL,NULL,'N;'),('Site.Error',0,NULL,NULL,'N;'),('Site.Index',0,NULL,NULL,'N;'),('Site.Login',0,NULL,NULL,'N;'),('Site.Logout',0,NULL,NULL,'N;'),('Usuario.*',1,NULL,NULL,'N;'),('Usuario.Create',0,NULL,NULL,'N;'),('Usuario.Delete',0,NULL,NULL,'N;'),('Usuario.Index',0,NULL,NULL,'N;'),('Usuario.Update',0,NULL,NULL,'N;'),('Usuario.View',0,NULL,NULL,'N;');
201/*!40000 ALTER TABLE `authitem` ENABLE KEYS */;
202UNLOCK TABLES;
203
204--
205-- Table structure for table `authitemchild`
206--
207
208DROP TABLE IF EXISTS `authitemchild`;
209/*!40101 SET @saved_cs_client     = @@character_set_client */;
210/*!40101 SET character_set_client = utf8 */;
211CREATE TABLE `authitemchild` (
212  `parent` varchar(64) NOT NULL,
213  `child` varchar(64) NOT NULL,
214  PRIMARY KEY (`parent`,`child`),
215  KEY `child` (`child`),
216  CONSTRAINT `authitemchild_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
217  CONSTRAINT `authitemchild_ibfk_2` FOREIGN KEY (`child`) REFERENCES `authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
218) ENGINE=InnoDB DEFAULT CHARSET=utf8;
219/*!40101 SET character_set_client = @saved_cs_client */;
220
221--
222-- Dumping data for table `authitemchild`
223--
224
225LOCK TABLES `authitemchild` WRITE;
226/*!40000 ALTER TABLE `authitemchild` DISABLE KEYS */;
227INSERT INTO `authitemchild` VALUES ('Cadastros','Periodico.*'),('Cadastros','Professor.*');
228/*!40000 ALTER TABLE `authitemchild` ENABLE KEYS */;
229UNLOCK TABLES;
230
231--
232-- Table structure for table `autor`
233--
234
235DROP TABLE IF EXISTS `autor`;
236/*!40101 SET @saved_cs_client     = @@character_set_client */;
237/*!40101 SET character_set_client = utf8 */;
238CREATE TABLE `autor` (
239  `producaoBibliograficaID` int(11) NOT NULL,
240  `pessoaID` int(11) NOT NULL,
241  `ordemAutoria` tinyint(4) DEFAULT '0',
242  PRIMARY KEY (`producaoBibliograficaID`,`pessoaID`),
243  KEY `fk_producao_bibliografica_has_pessoa_pessoa1_idx` (`pessoaID`),
244  KEY `fk_producao_bibliografica_has_pessoa_producao_bibliografica_idx` (`producaoBibliograficaID`),
245  CONSTRAINT `fk_producao_bibliografica_has_pessoa_pessoa1` FOREIGN KEY (`pessoaID`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
246  CONSTRAINT `fk_producao_bibliografica_has_pessoa_producao_bibliografica1` FOREIGN KEY (`producaoBibliograficaID`) REFERENCES `producao_bibliografica` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
247) ENGINE=InnoDB DEFAULT CHARSET=utf8;
248/*!40101 SET character_set_client = @saved_cs_client */;
249
250--
251-- Dumping data for table `autor`
252--
253
254LOCK TABLES `autor` WRITE;
255/*!40000 ALTER TABLE `autor` DISABLE KEYS */;
256/*!40000 ALTER TABLE `autor` ENABLE KEYS */;
257UNLOCK TABLES;
258
259--
260-- Table structure for table `bsc_indicador`
261--
262
263DROP TABLE IF EXISTS `bsc_indicador`;
264/*!40101 SET @saved_cs_client     = @@character_set_client */;
265/*!40101 SET character_set_client = utf8 */;
266CREATE TABLE `bsc_indicador` (
267  `id` int(11) NOT NULL AUTO_INCREMENT,
268  `bscPerspectivaID` int(11) NOT NULL,
269  `indicador` varchar(255) NOT NULL,
270  `meta` varchar(45) NOT NULL,
271  `funcaoAlvo` varchar(255) NOT NULL,
272  PRIMARY KEY (`id`),
273  KEY `idbsc_indicadorbsc_perspectiva1_idx` (`bscPerspectivaID`),
274  CONSTRAINT `idbsc_indicadorbsc_perspectiva1` FOREIGN KEY (`bscPerspectivaID`) REFERENCES `bsc_perspectiva` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
275) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
276/*!40101 SET character_set_client = @saved_cs_client */;
277
278--
279-- Dumping data for table `bsc_indicador`
280--
281
282LOCK TABLES `bsc_indicador` WRITE;
283/*!40000 ALTER TABLE `bsc_indicador` DISABLE KEYS */;
284INSERT INTO `bsc_indicador` VALUES (1,1,'2.2 - Razão entre o (total de discentes) pelo (total docentes permanentes)','Entre: 3 e 6','discentesPorDocentes'),(2,1,'2.3 - Razão entre a (horas-aulas ministradas no triênio em média anual) pelo (total de docentes permanentes no programa)','Entre: 120h e 360h','mediaHorasAulasPorDP'),(3,1,'2.4 - Percentual de docentes permanentes que ministraram aulas na Graduação','Entre: 75% e 100%','perDocentesAulasGrad'),(4,2,'3.1.a - Razão entre o (número de titulados + desistências + abandonos) pela (dimensão do corpo discente) - Doutorado','>= 20%','totalTituladosMaisDAPorDimensaoCursoDoutorado'),(5,2,'3.1.b - Razão entre o (número de titulados + desistências + abandonos) pela (dimensão do corpo discente) - Mestrado','>= 30%','totalTituladosMaisDAPorDimensaoCursoMestrado'),(6,2,'3.1.c - Razão entre o (total de discentes titulados) pelo (total docentes permanentes)','>= 100%','totalDiscentesTituladosPorDP'),(7,2,'3.2 - Total de teses + dissertações defendidas pelos 25% dos docentes permanentes que mais orientaram considerando todos os programas','< 60%','totalTesesEDissertacoesPorDocentes'),(8,2,'3.3 - Razão entre (total de discentes com publicações em periódicos) pelo (total de discentes)','>= 30%','totalDiscentesComPubPorTotalDiscentes'),(9,2,'3.4 - Tempo médio de titulação no Mestrado','<= 30 Meses','tempoMedioTitulacaoMestrado'),(10,2,'3.4 - Tempo médio de titulação no Doutorado','<= 54 Meses','tempoMedioTitulacaoDoutorado'),(11,3,'4.2 - Razão entre o (número de docentes permanentes com publicações em periódicos no triênio) pelo (número médio de docentes permanentes no triênio)','>= 70%','docentesComPubPorNumMedioDocentes'),(12,1,'Docente permanente com maior número de orientandos','<= 8','dpComMaiorNumeroOrientados');
285/*!40000 ALTER TABLE `bsc_indicador` ENABLE KEYS */;
286UNLOCK TABLES;
287
288--
289-- Table structure for table `bsc_perspectiva`
290--
291
292DROP TABLE IF EXISTS `bsc_perspectiva`;
293/*!40101 SET @saved_cs_client     = @@character_set_client */;
294/*!40101 SET character_set_client = utf8 */;
295CREATE TABLE `bsc_perspectiva` (
296  `id` int(11) NOT NULL AUTO_INCREMENT,
297  `nome` varchar(255) NOT NULL,
298  PRIMARY KEY (`id`)
299) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
300/*!40101 SET character_set_client = @saved_cs_client */;
301
302--
303-- Dumping data for table `bsc_perspectiva`
304--
305
306LOCK TABLES `bsc_perspectiva` WRITE;
307/*!40000 ALTER TABLE `bsc_perspectiva` DISABLE KEYS */;
308INSERT INTO `bsc_perspectiva` VALUES (1,'2 - Corpo Docente'),(2,'3 - Corpo Discente, Teses e Dissertações'),(3,'4 - Produção Intelectual');
309/*!40000 ALTER TABLE `bsc_perspectiva` ENABLE KEYS */;
310UNLOCK TABLES;
311
312--
313-- Table structure for table `capitulo_livro`
314--
315
316DROP TABLE IF EXISTS `capitulo_livro`;
317/*!40101 SET @saved_cs_client     = @@character_set_client */;
318/*!40101 SET character_set_client = utf8 */;
319CREATE TABLE `capitulo_livro` (
320  `id` int(11) NOT NULL AUTO_INCREMENT,
321  `producaoBibliograficaID` int(11) NOT NULL,
322  `tipo` varchar(128) NOT NULL,
323  `tituloLivro` varchar(400) NOT NULL,
324  `numeroVolumes` varchar(5) DEFAULT '',
325  `paginaInicial` varchar(20) DEFAULT '',
326  `paginaFinal` varchar(20) DEFAULT '',
327  `isbn` varchar(13) DEFAULT '',
328  `organizadores` varchar(400) DEFAULT '' COMMENT 'Organizadores',
329  `numeroEdicaoRevisao` varchar(5) DEFAULT '' COMMENT 'Número da Edição de revisão',
330  `numeroSerie` varchar(5) DEFAULT '' COMMENT 'Número da série',
331  `cidadeEditora` varchar(30) DEFAULT '' COMMENT 'Cidade da Editora',
332  `nomeEditora` varchar(100) DEFAULT '' COMMENT 'Nome da Editora',
333  PRIMARY KEY (`id`,`producaoBibliograficaID`),
334  KEY `fk_capitulo_livro_producao_bibliografica1_idx` (`producaoBibliograficaID`),
335  CONSTRAINT `fk_capitulo_livro_producao_bibliografica1` FOREIGN KEY (`producaoBibliograficaID`) REFERENCES `producao_bibliografica` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
336) ENGINE=InnoDB DEFAULT CHARSET=utf8;
337/*!40101 SET character_set_client = @saved_cs_client */;
338
339--
340-- Dumping data for table `capitulo_livro`
341--
342
343LOCK TABLES `capitulo_livro` WRITE;
344/*!40000 ALTER TABLE `capitulo_livro` DISABLE KEYS */;
345/*!40000 ALTER TABLE `capitulo_livro` ENABLE KEYS */;
346UNLOCK TABLES;
347
348--
349-- Table structure for table `categoria`
350--
351
352DROP TABLE IF EXISTS `categoria`;
353/*!40101 SET @saved_cs_client     = @@character_set_client */;
354/*!40101 SET character_set_client = utf8 */;
355CREATE TABLE `categoria` (
356  `id` int(11) NOT NULL AUTO_INCREMENT,
357  `nome` varchar(45) NOT NULL,
358  PRIMARY KEY (`id`)
359) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
360/*!40101 SET character_set_client = @saved_cs_client */;
361
362--
363-- Dumping data for table `categoria`
364--
365
366LOCK TABLES `categoria` WRITE;
367/*!40000 ALTER TABLE `categoria` DISABLE KEYS */;
368INSERT INTO `categoria` VALUES (6,'Congregação'),(11,'Permanentes - CAPES 2012'),(23,'Permanentes - CAPES 2013'),(24,'Permanentes - CAPES 2014'),(25,'Sem categoria'),(26,'Permanentes - CAPES 2015'),(31,'Permanentes - CAPES 2016'),(36,'Colaboradores - CAPES 2012'),(37,'Colaboradores - CAPES 2013'),(38,'Colaboradores - CAPES 2014'),(39,'Colaboradores - CAPES 2015'),(40,'Colaboradores - CAPES 2016'),(41,'Permanentes MP - CAPES 2016'),(42,'Colaboradores - CAPES 2017'),(43,'Colaboradores MP - CAPES 2016'),(44,'Permanentes - CAPES 2011'),(45,'PDI'),(46,'Permanentes MP - CAPES 2013'),(47,'Permanentes MP - CAPES 2014'),(48,'Permanentes MP - CAPES 2015'),(49,'Permanentes - CAPES 2017'),(50,'Permanentes MP - CAPES 2017');
369/*!40000 ALTER TABLE `categoria` ENABLE KEYS */;
370UNLOCK TABLES;
371
372--
373-- Table structure for table `categoria_professor`
374--
375
376DROP TABLE IF EXISTS `categoria_professor`;
377/*!40101 SET @saved_cs_client     = @@character_set_client */;
378/*!40101 SET character_set_client = utf8 */;
379CREATE TABLE `categoria_professor` (
380  `professorID` int(11) NOT NULL,
381  `categoriaID` int(11) NOT NULL,
382  PRIMARY KEY (`professorID`,`categoriaID`),
383  KEY `idcategoria_professorprofessor1_idx` (`professorID`),
384  KEY `idcategoria_professorcategoria1_idx` (`categoriaID`),
385  CONSTRAINT `idcategoria_professorcategoria1` FOREIGN KEY (`categoriaID`) REFERENCES `categoria` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
386  CONSTRAINT `idcategoria_professorprofessor1` FOREIGN KEY (`professorID`) REFERENCES `professor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
387) ENGINE=InnoDB DEFAULT CHARSET=utf8;
388/*!40101 SET character_set_client = @saved_cs_client */;
389
390--
391-- Dumping data for table `categoria_professor`
392--
393
394LOCK TABLES `categoria_professor` WRITE;
395/*!40000 ALTER TABLE `categoria_professor` DISABLE KEYS */;
396INSERT INTO `categoria_professor` VALUES (1,6),(1,45),(2,6),(2,11),(2,23),(2,24),(2,26),(2,31),(2,44),(2,45),(2,49),(3,6),(3,11),(3,23),(3,24),(3,26),(3,31),(3,41),(3,44),(3,45),(3,46),(3,47),(3,48),(3,49),(3,50),(4,6),(4,11),(4,23),(4,24),(4,26),(4,31),(4,41),(4,44),(4,45),(4,46),(4,47),(4,48),(4,49),(4,50),(5,6),(5,24),(5,31),(5,41),(5,45),(5,46),(5,47),(5,48),(5,49),(5,50),(6,6),(6,23),(6,24),(6,26),(6,45),(7,11),(8,6),(8,11),(8,23),(8,24),(8,26),(8,31),(8,44),(8,45),(8,49),(9,6),(9,11),(9,23),(9,24),(9,26),(9,31),(9,44),(9,45),(9,49),(10,6),(10,11),(10,23),(10,24),(10,26),(10,31),(10,41),(10,44),(10,45),(10,46),(10,47),(10,48),(10,49),(10,50),(11,41),(11,46),(11,47),(11,48),(11,50),(12,6),(12,11),(12,23),(12,24),(12,26),(12,31),(12,41),(12,44),(12,45),(12,46),(12,47),(12,48),(12,49),(12,50),(13,6),(13,11),(13,23),(13,24),(13,26),(13,31),(13,44),(13,45),(13,46),(13,49),(14,6),(14,45),(15,6),(15,11),(15,23),(15,24),(15,26),(15,31),(15,41),(15,44),(15,45),(15,46),(15,47),(15,48),(15,49),(15,50),(16,6),(16,11),(16,44),(16,45),(18,26),(18,31),(18,41),(18,46),(18,47),(18,48),(18,49),(19,11),(19,45),(20,6),(20,11),(20,23),(20,24),(20,26),(20,31),(20,44),(20,45),(20,49),(21,6),(21,45),(23,41),(23,45),(23,46),(23,47),(23,48),(23,50),(24,41),(24,45),(24,46),(24,47),(24,48),(24,50),(26,41),(26,48),(29,41),(29,45),(29,46),(29,47),(29,48),(29,50),(31,41),(31,46),(31,47),(31,48),(31,50),(32,43),(33,43),(37,43),(37,45),(44,41),(44,46),(44,47),(44,48),(44,50),(46,45),(46,46),(46,47),(48,11),(48,23),(48,24),(48,26),(48,31),(48,49),(96,45),(97,6),(97,11),(97,23),(97,24),(97,26),(97,31),(97,41),(97,45),(97,48),(97,49),(97,50),(99,41),(99,45),(99,46),(99,47),(99,48),(99,50),(100,45),(101,25),(102,45),(117,45),(119,45),(122,45),(123,45),(124,26),(124,31),(124,45),(124,49),(125,45),(127,45),(129,24),(129,26),(129,31),(131,45),(229,6),(229,31),(229,41),(229,45),(229,49),(229,50),(230,6),(230,31),(230,45),(230,49),(231,6),(231,31),(231,45),(231,49),(232,45),(294,11),(294,23),(294,24),(294,26),(294,31),(294,41),(294,44),(294,46),(294,47),(294,48),(294,49),(295,11),(295,23),(295,24),(295,26),(295,31),(295,41),(295,44),(295,49),(296,24),(296,26),(296,31),(296,49),(297,11),(297,23),(297,24),(297,26),(297,31),(297,41),(297,44),(297,46),(297,47),(297,48),(297,49),(298,26),(298,31),(298,41),(298,46),(298,47),(298,48),(298,49),(299,11),(299,23),(299,24),(299,26),(299,44),(300,11),(300,23),(301,11),(301,23),(301,44),(302,46),(303,11),(303,23),(303,24),(303,26),(303,31),(303,41),(303,44),(303,46),(303,47),(303,48),(303,49),(304,11),(304,23),(304,24),(304,26),(304,41),(304,44),(304,46),(304,47),(304,48),(306,11),(306,23),(306,24),(306,26),(306,31),(306,41),(306,44),(306,46),(306,47),(306,48),(306,49),(307,11),(307,23),(307,24),(307,26),(307,31),(307,41),(307,46),(307,47),(307,48),(307,49),(308,23),(308,24),(308,26),(308,31),(308,41),(308,46),(308,47),(308,48),(308,49),(309,11),(309,23),(309,24),(309,26),(309,31),(309,41),(309,44),(309,46),(309,47),(309,48),(309,49),(310,11),(310,23),(310,26),(310,31),(310,44),(310,49),(311,11),(311,23),(311,24),(311,26),(312,11),(312,23),(312,24),(312,26),(312,31),(312,49),(314,11),(314,23),(314,24),(314,26),(314,31),(314,49),(315,11),(315,23),(315,24),(315,26),(315,31),(315,49),(316,11),(317,11),(317,23),(317,24),(317,26),(317,31),(317,49),(318,11),(318,23),(318,24),(318,26),(318,31),(318,49),(319,24),(319,31),(319,49),(320,11),(321,45),(322,11),(322,23),(322,31),(322,49),(323,11),(323,23),(323,24),(323,26),(323,31),(323,49),(324,11),(324,23),(324,24),(324,26),(324,31),(324,49),(325,11),(326,11),(326,23),(326,24),(326,26),(326,31),(326,49),(327,11),(328,25),(329,11),(329,23),(329,24),(329,26),(329,31),(329,49),(330,11),(330,23),(330,24),(330,26),(330,31),(330,49),(331,41),(331,47),(331,48),(331,50),(332,11),(332,23),(332,24),(332,26),(332,31),(332,49),(333,11),(333,23),(333,24),(333,26),(333,31),(333,41),(333,48),(333,49),(334,11),(334,23),(334,24),(334,26),(334,31),(334,41),(334,48),(334,49),(335,11),(335,23),(335,24),(335,26),(335,31),(335,49),(336,11),(336,23),(336,24),(336,26),(336,31),(336,41),(336,48),(336,49),(337,24),(337,26),(337,31),(337,49),(338,25),(339,11),(339,23),(339,24),(339,26),(339,31),(339,49),(340,11),(340,23),(340,24),(340,26),(340,31),(340,41),(340,48),(340,49),(341,11),(341,23),(341,24),(341,26),(341,31),(341,41),(341,48),(341,49),(342,11),(342,23),(342,24),(342,26),(342,31),(342,41),(342,48),(342,49),(360,11),(360,23),(360,24),(360,26),(360,31),(360,49),(361,11),(361,23),(361,24),(361,26),(361,31),(361,41),(361,46),(361,47),(361,48),(361,49),(362,11),(362,23),(362,24),(362,26),(362,31),(362,49),(363,11),(363,23),(363,24),(363,26),(363,31),(363,49),(364,11),(364,23),(364,24),(364,26),(364,41),(364,46),(364,47),(364,48),(365,11),(365,23),(365,24),(365,26),(365,31),(365,41),(365,46),(365,47),(365,48),(365,49),(366,11),(366,23),(366,24),(366,26),(366,31),(366,41),(366,46),(366,47),(366,48),(366,49),(367,23),(367,24),(367,26),(367,31),(367,49),(368,11),(368,23),(368,24),(368,31),(368,41),(368,46),(368,47),(368,48),(368,49),(369,11),(369,23),(369,24),(369,26),(369,31),(369,49),(370,11),(370,23),(370,24),(370,26),(370,41),(370,46),(370,47),(370,48),(371,25),(372,11),(372,23),(372,24),(372,26),(372,31),(372,41),(372,46),(372,47),(372,48),(372,49),(373,11),(373,23),(373,24),(373,26),(373,31),(373,49),(374,24),(374,26),(374,31),(374,41),(374,47),(374,48),(374,49),(375,11),(375,23),(375,24),(375,26),(375,31),(375,41),(375,46),(375,47),(375,48),(375,49),(376,11),(376,23),(376,24),(376,26),(376,31),(376,49),(377,11),(377,23),(377,24),(377,26),(377,31),(377,41),(377,46),(377,47),(377,48),(377,49),(378,11),(378,23),(378,24),(378,26),(378,31),(378,49),(379,11),(379,23),(379,24),(379,26),(379,31),(379,49),(380,25),(381,11),(381,23),(381,24),(381,26),(381,31),(381,49),(382,11),(382,23),(382,24),(382,26),(382,31),(382,49),(383,11),(383,23),(383,24),(383,26),(383,31),(383,49),(384,23),(384,24),(384,26),(384,31),(384,49),(385,11),(385,23),(385,24),(385,26),(385,31),(385,49),(387,25),(388,11),(388,23),(388,24),(388,26),(388,31),(388,49),(389,11),(389,23),(389,24),(389,26),(389,31),(389,49),(390,11),(390,23),(390,24),(390,26),(390,31),(390,49),(391,11),(391,23),(391,24),(391,26),(391,31),(391,41),(391,46),(391,47),(391,48),(391,49),(392,25),(393,11),(393,23),(393,24),(393,26),(393,31),(393,49),(394,11),(394,23),(394,24),(394,26),(394,31),(394,49),(395,11),(395,23),(395,24),(395,26),(395,31),(395,49),(396,11),(396,23),(396,24),(396,26),(396,31),(396,49),(398,11),(398,23),(398,24),(398,26),(398,31),(398,41),(398,46),(398,47),(398,48),(398,49),(399,11),(399,23),(399,24),(399,26),(399,31),(399,49),(400,11),(400,23),(400,24),(400,26),(400,31),(400,49),(401,11),(401,23),(401,24),(401,26),(401,31),(401,49),(402,11),(402,23),(402,24),(402,26),(402,31),(402,49),(403,11),(403,23),(403,24),(403,26),(403,31),(403,49),(404,11),(404,23),(404,24),(404,26),(404,31),(404,49),(405,11),(405,23),(405,24),(405,26),(405,31),(405,49),(406,11),(406,23),(406,24),(406,26),(406,31),(406,49),(407,11),(407,23),(407,24),(407,26),(407,31),(407,49),(408,11),(409,11),(409,23),(409,24),(409,26),(409,31),(410,11),(410,23),(410,24),(410,26),(410,31),(410,49),(411,11),(411,23),(411,24),(411,26),(411,31),(411,49),(412,11),(412,23),(412,24),(412,26),(412,31),(413,41),(413,45),(413,46),(413,47),(413,48),(413,50),(414,6),(414,24),(414,26),(414,31),(414,41),(414,45),(414,47),(414,48),(414,49),(414,50),(415,6),(415,24),(415,26),(415,31),(415,45),(415,49),(417,26),(417,31),(417,41),(417,47),(417,48),(417,49),(421,24),(421,26),(421,31),(421,49),(422,31),(422,49),(423,6),(423,24),(423,31),(423,39),(423,41),(423,47),(423,48),(423,49),(424,24),(425,42),(429,23),(429,24),(429,26),(429,31),(429,49),(430,23),(430,24),(430,26),(431,23),(431,24),(431,26),(431,31),(431,36),(431,49),(432,23),(432,24),(432,26),(432,31),(432,49),(433,23),(434,11),(434,23),(434,24),(434,26),(434,31),(435,11),(435,23),(435,24),(435,26),(435,31),(435,49),(436,23),(436,24),(436,26),(436,31),(436,49),(437,23),(437,24),(437,26),(437,31),(437,41),(437,48),(437,49),(438,23),(438,24),(438,26),(438,31),(438,41),(438,46),(438,47),(438,48),(438,49),(439,23),(439,24),(439,26),(439,31),(439,41),(439,46),(439,47),(439,48),(439,49),(440,23),(440,24),(440,26),(440,31),(440,41),(440,46),(440,47),(440,48),(440,49),(441,11),(441,23),(441,24),(441,26),(441,31),(441,49),(442,23),(442,24),(442,26),(442,31),(442,49),(443,11),(443,23),(443,24),(443,26),(443,31),(443,49),(444,24),(444,26),(444,42),(445,41),(445,48),(446,25),(447,25),(448,43),(449,25),(450,24),(450,26),(450,31),(450,41),(450,46),(450,47),(450,48),(450,49),(451,25),(452,41),(452,46),(452,47),(452,48),(452,50),(453,41),(453,46),(453,47),(453,48),(453,50),(454,41),(454,47),(454,48),(455,41),(455,46),(455,47),(455,48),(455,50),(456,41),(456,47),(456,48),(456,50),(457,46),(457,47),(457,48),(458,41),(458,46),(458,47),(458,48),(458,50),(459,46),(459,47),(460,46),(460,47),(460,48),(461,41),(461,46),(461,47),(461,48),(461,50),(462,41),(462,46),(462,47),(462,48),(462,50),(463,41),(463,46),(463,47),(463,48),(463,50),(464,41),(464,46),(464,47),(464,48),(464,50),(465,41),(465,46),(465,47),(465,48),(465,50),(466,41),(466,46),(466,47),(466,48),(466,50),(467,41),(467,46),(467,47),(467,48),(467,50),(468,41),(468,46),(468,47),(468,48),(468,50),(469,41),(469,46),(469,47),(469,48),(469,50),(470,46),(471,41),(471,46),(471,47),(471,48),(471,50),(472,41),(472,46),(472,47),(472,48),(472,50),(473,41),(473,46),(473,47),(473,48),(473,50),(474,41),(474,46),(474,47),(474,48),(474,50),(475,41),(475,46),(475,47),(475,48),(475,50),(476,41),(476,46),(476,47),(476,48),(477,41),(477,46),(477,47),(477,48),(478,46),(478,47),(479,41),(479,46),(479,47),(479,48),(480,41),(480,46),(480,47),(480,48),(481,26),(481,31),(481,49),(482,41),(482,48),(483,41),(483,46),(483,47),(483,48),(484,41),(484,48),(485,41),(485,46),(485,47),(485,48),(486,41),(486,46),(486,47),(486,48),(487,46),(487,47),(487,48),(488,41),(488,46),(488,47),(488,48),(489,41),(489,46),(489,47),(489,48),(489,50),(490,41),(490,45),(490,47),(490,48),(490,50),(491,25),(492,41),(492,45),(492,46),(492,47),(492,48),(492,50),(494,41),(494,47),(494,48),(494,50),(495,41),(495,47),(495,48),(495,50),(496,41),(496,48),(496,50),(497,25),(498,45),(499,25),(500,11),(500,23),(500,24),(500,26),(501,24),(502,25),(503,25),(504,31),(504,49),(505,25),(506,24),(506,26),(506,31),(506,41),(506,49),(507,23),(507,24),(507,26),(507,31),(507,49),(508,24),(508,26),(508,31),(508,49),(509,24),(509,26),(509,31),(509,49),(510,23),(510,24),(510,26),(510,31),(510,49),(511,25),(512,46),(512,47),(513,41),(513,48),(514,41),(514,47),(514,48),(515,46),(516,46),(517,45),(821,26),(821,31),(821,49),(822,26),(822,31),(822,49),(823,26),(823,31),(823,49),(824,26),(824,31),(824,49),(825,24),(825,26),(825,31),(825,49),(826,26),(826,31),(826,49),(827,26),(827,31),(827,49),(854,11),(854,23),(854,24),(854,26),(854,31),(854,49),(855,11),(855,23),(855,24),(855,26),(855,31),(856,11),(856,23),(856,24),(856,26),(856,31),(856,49),(857,11),(857,23),(857,24),(857,26),(857,31),(857,49),(858,11),(858,23),(858,24),(858,26),(858,40),(859,11),(859,23),(859,24),(859,26),(859,31),(859,49),(860,11),(860,23),(860,24),(860,26),(860,31),(860,49),(861,11),(861,23),(861,24),(861,26),(861,31),(861,49),(862,11),(862,23),(862,24),(862,26),(862,31),(862,49),(863,11),(863,23),(863,24),(863,26),(863,31),(863,49),(864,11),(864,26),(864,31),(864,49),(865,23),(865,24),(865,26),(865,31),(865,49),(866,23),(866,24),(866,26),(866,31),(866,49),(867,23),(867,24),(867,26),(867,31),(867,49),(868,23),(868,24),(868,26),(868,31),(868,49),(869,37),(869,38),(869,39),(869,40),(870,23),(870,24),(870,26),(870,31),(870,49),(871,23),(871,24),(871,39),(871,40),(872,26),(872,31),(872,37),(872,38),(872,49),(873,23),(873,24),(873,26),(873,31),(873,49),(874,24),(874,26),(874,31),(874,49),(875,24),(875,26),(875,31),(875,49),(876,26),(876,31),(876,38),(876,49),(877,26),(877,31),(877,49),(878,31),(878,49),(879,6),(879,45),(880,31),(880,49),(881,31),(881,49),(882,43),(883,23),(883,24),(883,26),(883,31),(883,49),(884,41),(884,45),(884,46),(884,47),(884,48),(884,50),(885,31),(885,49),(886,45),(887,45),(888,45),(889,45),(890,45),(891,45),(892,45),(893,45),(894,45),(895,26),(895,31),(895,49),(896,46),(896,47),(897,41),(897,46),(897,47),(897,48),(898,41),(898,48),(899,41),(899,46),(899,47),(899,48),(900,41),(900,46),(900,47),(900,48),(901,41),(901,46),(901,47),(901,48),(902,46),(902,47),(903,41),(903,46),(903,47),(903,48),(904,41),(904,46),(904,47),(904,48),(905,41),(906,41),(906,48),(907,41),(907,48),(908,41),(908,48),(909,41),(909,47),(909,48),(910,41),(911,41),(912,41),(912,48),(912,50),(913,23),(913,24),(913,26),(913,31),(913,49),(914,23),(914,24),(914,26),(914,31),(914,49),(915,23),(915,24),(915,26),(915,31),(915,49),(916,23),(916,24),(916,26),(916,31),(916,49),(917,23),(917,24),(917,26),(917,31),(917,49),(918,23),(918,24),(918,26),(918,31),(918,49),(919,31),(919,49),(920,23),(920,24),(920,26),(920,31),(920,49),(921,23),(921,24),(921,26),(921,31),(922,23),(922,24),(922,26),(922,31),(922,49),(923,23),(923,24),(923,26),(923,31),(923,49),(924,23),(924,24),(924,26),(924,31),(924,49),(925,23),(925,24),(925,26),(925,31),(925,49),(926,23),(926,24),(926,26),(926,31),(926,49),(927,23),(927,24),(927,26),(927,31),(927,49),(928,23),(928,24),(928,26),(928,31),(928,49),(929,23),(929,24),(929,26),(929,31),(929,49),(930,23),(930,24),(930,26),(930,31),(930,49),(931,23),(931,24),(931,26),(931,31),(931,49),(932,23),(932,24),(932,26),(932,31),(932,49),(933,24),(933,26),(933,31),(933,49),(934,23),(934,26),(934,31),(934,49),(935,23),(935,24),(935,26),(935,31),(936,23),(936,24),(936,26),(936,31),(936,49),(937,23),(937,24),(937,26),(937,31),(937,49),(938,23),(938,24),(938,26),(938,31),(938,49),(939,23),(939,24),(939,26),(939,31),(939,49),(940,23),(940,24),(940,26),(940,31),(940,49),(941,23),(941,24),(941,26),(941,31),(941,49),(942,23),(942,24),(942,26),(942,31),(942,49),(943,23),(943,24),(943,26),(943,31),(943,49),(944,23),(944,24),(944,26),(944,31),(944,49),(945,23),(945,24),(945,26),(945,31),(945,49),(946,23),(946,24),(946,26),(946,31),(946,49),(947,24),(947,26),(947,31),(947,49),(948,23),(948,24),(948,26),(948,31),(948,49),(949,23),(949,24),(949,26),(949,31),(949,49),(950,24),(950,26),(950,31),(950,49),(951,23),(951,24),(951,26),(951,31),(951,49),(952,26),(952,31),(952,49),(953,23),(953,24),(953,26),(953,31),(953,49),(954,26),(954,31),(954,49),(955,26),(955,31),(955,49),(956,26),(956,31),(956,49),(957,23),(957,24),(957,26),(957,31),(957,49),(958,23),(958,24),(958,26),(958,31),(958,49),(959,23),(959,24),(959,26),(959,31),(959,49),(960,26),(960,31),(960,49),(961,26),(961,31),(961,49),(962,24),(963,26),(964,25),(965,45),(966,45),(967,45),(968,45),(969,45),(970,49),(971,49),(972,49),(973,49),(974,49),(975,49),(976,49),(977,49),(978,49),(979,49),(980,6);
397/*!40000 ALTER TABLE `categoria_professor` ENABLE KEYS */;
398UNLOCK TABLES;
399
400--
401-- Table structure for table `classificacao_periodico_clm`
402--
403
404DROP TABLE IF EXISTS `classificacao_periodico_clm`;
405/*!40101 SET @saved_cs_client     = @@character_set_client */;
406/*!40101 SET character_set_client = utf8 */;
407CREATE TABLE `classificacao_periodico_clm` (
408  `periodico_issn` varchar(8) NOT NULL COMMENT 'Periódico ISSN',
409  `periodico_titulo` varchar(45) NOT NULL COMMENT 'Periódico título',
410  `clm` float NOT NULL COMMENT 'CLM',
411  `ranking` int(11) NOT NULL COMMENT 'Ranking',
412  PRIMARY KEY (`periodico_issn`)
413) ENGINE=InnoDB DEFAULT CHARSET=utf8;
414/*!40101 SET character_set_client = @saved_cs_client */;
415
416--
417-- Dumping data for table `classificacao_periodico_clm`
418--
419
420LOCK TABLES `classificacao_periodico_clm` WRITE;
421/*!40000 ALTER TABLE `classificacao_periodico_clm` DISABLE KEYS */;
422INSERT INTO `classificacao_periodico_clm` VALUES ('00014826','Accounting Review',9.62429,281),('00016373','Acta Oeconomica',7.44427,462),('0001771X','L\'Actualite Economique/Revue D\'Analyse Econom',7.71061,419),('00028282','American Economic Review',96.144,3),('00029092','American Journal of Agricultural Economics',27.0622,57),('00029246','American Journal of Economics and Sociology',10.625,242),('00030554','American Political Science Review',14.6037,143),('0003603X','Antitrust Bulletin',6.94916,551),('00036846','Applied Economics',16.1346,123),('00048216','Aussenwirtschaft',7.78823,409),('00048992','Australian Economic History Review',9.00988,318),('0004900X','Australian Economic Papers',7.25471,491),('00049018','Australian Economic Review',8.06208,381),('00071080','British Journal of Industrial Relations',8.07252,380),('00072303','Brookings Papers on Economic Activity',16.0653,124),('00074918','Bulletin of Indonesian Economic Studies',12.6694,178),('0007666X','Business Economics',8.9105,326),('00076805','Business History Review',6.83355,580),('00077011','Federal Reserve Bank of Philadelphia Business',12.7453,177),('00083976','Canadian Journal of Agricultural Economics',10.2214,252),('00084085','Canadian Journal of Economics',20.8939,84),('00121533','Developing Economies',9.44922,289),('0012155X','Development and Change',8.20715,370),('00128775','Eastern European Economics',6.78151,591),('00129682','Econometrica',98.4211,2),('00129984','Economic and Social Review',11.8532,205),('00130079','Economic Development and Cultural Change',24.7028,65),('00130095','Economic Geography',21.3714,83),('00130117','Economic History Review',20.4149,86),('00130133','Economic Journal',59.9359,12),('00130249','Economic Record',14.4681,144),('00130427','Economica',26.5625,59),('0013063X','De Economist',13.501,159),('00142921','European Economic Review',39.5349,28),('00144983','Explorations in Economic History',14.4457,145),('00149187','Federal Reserve Bank of St. Louis Review',8.74445,336),('00149209','Federal Reserve Bulletin',11.071,229),('00151947','Finance and Development',7.12192,518),('0015198X','Financial Analysts Journal',7.96545,391),('00152218','FinanzArchiv',7.52544,445),('00170097','Giornale degli Economisti e Annali di Economi',7.57908,437),('00174815','Growth and Change',7.7513,413),('00182702','History of Political Economy',9.64663,278),('00194670','Indian Economic Review',7.50475,450),('00197939','Industrial and Labor Relations Review',11.9987,198),('00198676','Industrial Relations',10.5157,244),('00205346','Intereconomics/Review of European Economic Po',7.02746,532),('00206598','International Economic Review',48.3829,19),('00207276','International Journal of Game Theory',19.15,93),('00207780','International Labour Review',9.42778,290),('00208183','International Organization',13.6447,154),('00213624','Journal of Economic Issues',9.68661,276),('00214027','Jahrbucher fur Nationalokonomie und Statistik',7.68181,423),('00218456','Journal of Accounting Research',10.8469,234),('0021857X','Journal of Agricultural Economics',14.324,146),('00219886','Journal of Common Market Studies',11.4212,221),('00220078','Journal of Consumer Affairs',13.6746,153),('00220388','Journal of Development Studies',17.6832,100),('00220485','Journal of Economic Education',10.2804,250),('00220507','Journal of Economic History',27.1605,56),('00220515','Journal of Economic Literature',28.3333,52),('00220531','Journal of Economic Theory',65.2705,11),('00221082','Journal of Finance',94.2066,4),('00221090','Journal of Financial and Quantitative Analysi',35.687,35),('0022166X','Journal of Human Resources',47.5827,20),('00221821','Journal of Industrial Economics',23.9744,68),('00221996','Journal of International Economics',53.2763,16),('00222186','Journal of Law and Economics',31.4815,45),('00222437','Journal of Marketing Research',8.29452,363),('00222879','Journal of Money Credit and Banking',31.4286,46),('00223433','Journal of Peace Research',9.20955,304),('00223808','Journal of Political Economy',82.9268,6),('00224146','Journal of Regional Science',23.2154,74),('00224367','Journal of Risk and Insurance',19.6222,90),('00225258','Journal of Transport Economics and Policy',11.9184,203),('00229709','Keio Economic Studies',7.53312,443),('00229733','Economic Review (Keizai Kenkyu)',7.60192,435),('00234591','Kredit und Kapital',6.80889,586),('00235962','Kyklos',15.3657,128),('00237639','Land Economics',22.8606,77),('00251909','Management Science',18.0851,96),('00261386','Metroeconomica',8.99533,319),('00262234','Michigan Law Review',7.26637,488),('0026959X','Moneda y Credito',9.05933,314),('00279501','National Institute Economic Review',7.40393,471),('00280283','National Tax Journal',17.6832,99),('00280453','Nationalokonomisk Tidsskrift',6.7728,595),('0030364X','Operations Research',9.91516,268),('00307653','Oxford Economic Papers',19.9573,89),('00335533','Quarterly Journal of Economics',100,1),('00343404','Regional Studies',18.8413,94),('00346527','Review of Economic Studies',86.3741,5),('00346535','Review of Economics and Statistics',68.4982,9),('00346586','Review of Income and Wealth',17.4278,104),('00346764','Review of Social Economy',6.81148,585),('00352764','Revue Economique',8.27334,364),('00356468','Rivista di Politica Economica',6.96762,547),('00369292','Scottish Journal of Political Economy',10.0945,259),('00382280','South African Journal of Economics',7.54489,441),('00384038','Southern Economic Journal',17.5422,103),('00396222','Survey of Current Business',7.80052,406),('00405833','Theory and Decision',17.0932,109),('00413011','El Trimestre Economico',10.2174,253),('00420980','Urban Studies',8.77522,335),('00440094','Yale Law Journal',7.42358,466),('00451460','Bank of Canada Review',7.94843,393),('00463892','Financial Management',8.90476,327),('00472506','Journal of International Business Studies',7.7034,421),('00472530','Journal of Legal Studies',14.7284,142),('00472727','Journal of Public Economics',56.1562,14),('00485829','Public Choice',29.3794,49),('00487333','Research Policy',11.9451,201),('0048749X','Review of Regional Studies',7.49036,451),('00494488','Transportation',8.62944,344),('00935301','Journal of Consumer Research',6.99065,540),('00941190','Journal of Urban Economics',41.326,27),('00945056','Eastern Economic Journal',8.78178,334),('00950696','Journal of Environmental Economics and Manage',35.8925,33),('00952583','Economic Inquiry',25.9903,61),('00954519','Innovations',7.90419,400),('00987921','Population and Development Review',9.285,297),('01245996','Revista de Economia Institucional',6.84982,576),('01409883','Energy Economics',22.7771,78),('01435671','Fiscal Studies',11.1475,226),('01436570','Managerial and Decision Economics',7.42822,464),('01443585','Journal of Economic Studies',7.12907,516),('01448188','International Review of Law and Economics',12.4958,183),('01475967','Journal of Comparative Economics',17.9205,97),('01476580','Federal Reserve Bank of New York Economic Pol',8.50951,349),('01486195','Journal of Economics and Business',7.42402,465),('01565826','Journal of Australian Political Economy',7.36946,476),('01600176','International Regional Science Review',6.71454,609),('01603477','Journal of Post Keynesian Economics',7.59083,436),('01612387','Federal Reserve Bank of Kansas City Economic ',7.13021,515),('01618938','Journal of Policy Modeling',10.6462,241),('01621459','Journal of the American Statistical Associati',12.8743,173),('01640682','Federal Reserve Bank of Chicago Economic Pers',9.18466,305),('01640704','Journal of Macroeconomics',13.3954,162),('01651587','European Review of Agricultural Economics',15.1847,130),('01651765','Economics Letters',25.5814,62),('01651889','Journal of Economic Dynamics and Control',31.2448,47),('01654101','Journal of Accounting and Economics',38.359,30),('01654896','Mathematical Social Sciences',15.014,136),('01660462','Regional Science and Urban Economics',23.2442,73),('01672681','Journal of Economic Behavior and Organization',38.9583,29),('01674870','Journal of Economic Psychology',23.746,70),('01676245','Information Economics and Policy',11.6656,212),('01676296','Journal of Health Economics',41.5556,26),('01676687','Insurance: Mathematics and Economics',8.16059,373),('01677187','International Journal of Industrial Organizat',27.8481,54),('01692070','International Journal of Forecasting',23.7159,71),('01695150','Agricultural Economics',15.834,126),('01761714','Social Choice and Welfare',22.9307,76),('01762680','European Journal of Political Economy',14.1424,149),('01851667','Investigacion Economica',7.00228,537),('01912615','Transportation Research: Part B: Methodologic',34.2178,39),('01953613','Journal of Labor Research',7.32042,482),('01956574','Energy Journal',23.7762,69),('01974254','Atlantic Economic Journal',6.89197,567),('02101173','Hacienda Publica Espanola/Revista de Economia',6.71816,607),('02102633','Cuadernos Economicos de I.C.E.',7.03617,530),('02126109','Revista de Historia Economica',9.38666,293),('02175908','Singapore Economic Review',6.81239,584),('02190249','International Journal of Theoretical and Appl',7.25387,493),('02191989','International Game Theory Review',7.01315,534),('02494744','Economie et Prevision',7.60729,434),('02548372','Journal of Economic Development',6.9898,541),('02573032','World Bank Research Observer',9.29878,295),('02577755','EIB Papers',8.85176,331),('02586770','World Bank Economic Review',12.6181,181),('02615606','Journal of International Money and Finance',11.7131,211),('02649993','Economic Modelling',11.5042,216),('02662671','Economics and Philosophy',15.1356,133),('02664658','Economic Policy',14.7432,141),('02664666','Econometric Theory',37.8926,32),('0266903X','Oxford Review of Economic Policy',21.6185,82),('02692171','International Review of Applied Economics',6.95544,548),('02702592','Journal of Financial Research',7.4879,452),('02707314','Journal of Futures Markets',7.26214,489),('02715287','Federal Reserve Bank of Minneapolis Quarterly',14.1573,148),('02727757','Economics of Education Review',26.338,60),('02733072','Cato Journal',6.86149,574),('02776693','Journal of Forecasting',12.6522,179),('02888432','Monetary and Economic Studies',10.1546,255),('03014215','Energy Policy',8.37438,357),('03038300','Social Indicators Research',6.96981,546),('03039692','Schweizerische Zeitschrift fur Volkswirtschaf',13.3016,166),('03042758','Estudios de Economia',6.97073,545),('03043878','Journal of Development Economics',43.287,25),('03043932','Journal of Monetary Economics',59.271,13),('0304405X','Journal of Financial Economics',82.5607,7),('03044068','Journal of Mathematical Economics',17.5587,102),('03044076','Journal of Econometrics',66.548,10),('0305750X','World Development',28.5933,51),('03059049','Oxford Bulletin of Economics and Statistics',15.1433,132),('03069192','Food Policy',20.7432,85),('03073378','Bulletin of Economic Research',9.78647,271),('03085147','Economy and Society',19.612,91),('0308518X','Environment and Planning A',8.89206,328),('03085961','Telecommunications Policy',6.77414,594),('0309166X','Cambridge Journal of Economics',16.1695,122),('03135926','Economic Analysis and Policy',7.08908,523),('03170861','Canadian Public Policy',7.46763,459),('03408744','Empirica',9.28534,296),('03470520','Scandinavian Journal of Economics',17.0021,112),('03616576','Journal of Economics (MVEA)',7.86541,402),('03630021','Federal Reserve Bank of San Francisco Economi',13.5136,158),('03649490','Delaware Journal of Corporate Law',7.93202,396),('03732630','Revue d\'Economie Politique',7.5388,442),('03777332','Empirical Economics',13.5164,157),('03784266','Journal of Banking and Finance',24.1602,66),('03785920','World Economy',16.2892,120),('03912078','Economia e Politica Industriale',6.86281,573),('03915026','Economic Notes',7.57876,438),('03915115','Journal of European Economic History',6.98748,542),('03918440','International Journal of Transport Economics',7.2282,497),('03927911','Energia',7.92086,399),('04866134','Review of Radical Political Economics',8.20249,371),('05701864','Annals of Regional Science',12.1193,193),('05779154','Jingji Yanjiu/Economic Research Journal',6.72113,605),('07190425','Latin American Journal of Economics',6.83733,579),('07213808','Zeitschrift fur Wirtschaftspolitik',6.77672,593),('07321813','Federal Reserve Bank of Atlanta Economic Revi',7.71891,418),('07322399','Marketing Science',10.2606,251),('07328516','Financial Review',7.73134,415),('0734306X','Journal of Labor Economics',49.5364,18),('07350015','Journal of Business and Economic Statistics',45.9763,22),('07381360','Marine Resource Economics',12.417,185),('07416261','RAND Journal of Economics',53.505,15),('07424477','Agribusiness',9.10197,311),('07474938','Econometric Reviews',22.5573,80),('07479662','Journal of Economic and Social Measurement',7.48743,453),('07526180','Finance',7.51688,447),('07690479','Revue Francaise d\'Economie',7.60926,433),('0769489X','Annales d\'Economie et de Statistique',9.21397,303),('07704518','Recherches Economiques de Louvain/Louvain Eco',12.574,182),('07727674','Review of Business and Economics',8.01732,385),('07845197','Finnish Economic Papers',9.51214,288),('08120439','Economic Papers',7.48344,454),('08189935','Asian-Pacific Economic Literature',10.0917,260),('08239150','Contemporary Accounting Research/Recherche Co',7.25399,492),('08724733','Notas Economicas',8.30579,362),('08837252','Journal of Applied Econometrics',35.7895,34),('08852545','Journal of Cultural Economics',11.6221,213),('08887233','Comparative Economic Studies',7.41351,468),('08891583','Journal of the Japanese and International Eco',11.9718,199),('08893047','Review of Austrian Economics',8.87238,330),('0889938X','Review of Industrial Organization',13.2156,169),('0890913X','Journal of Private Enterprise',7.20118,503),('08912424','Economic Development Quarterly',10.0376,262),('08929912','Journal of Technology Transfer',6.93878,552),('08939454','Review of Financial Studies',78.4067,8),('08953309','Journal of Economic Perspectives',30.1613,48),('0895562X','Journal of Productivity Analysis',15.0989,134),('08955638','Journal of Real Estate Finance and Economics',16.9231,114),('08955646','Journal of Risk and Uncertainty',29.1504,50),('0896307X','Faith and Economics',10.5105,245),('08965803','Journal of Real Estate Research',11.8392,207),('0898011X','Review of Futures Markets',6.74336,602),('08997764','Journal of Media Economics',8.0316,383),('08998256','Games and Economic Behavior',49.668,17),('09208550','Journal of Financial Services Research',7.98727,387),('09218009','Ecological Economics',38.2804,31),('0921898X','Small Business Economics',16.556,117),('09221425','Japan and the World Economy',8.47496,352),('0922680X','Journal of Regulatory Economics',11.4408,219),('09237992','Open Economies Review',9.35234,294),('09246460','Environmental and Resource Economics',23.5072,72),('0924865X','Review of Quantitative Finance and Accounting',7.00347,535),('09266437','Journal of Income Distribution',7.34864,479),('09275371','Labour Economics',22.6119,79),('0927538X','Pacific-Basin Finance Journal',6.75318,600),('09275398','Journal of Empirical Finance',15.1457,131),('09275940','International Tax and Public Finance',14.1345,150),('09277099','Computational Economics',9.53554,287),('09277544','Journal of Real Estate Literature',7.55928,440),('09287655','Resource and Energy Economics',16.556,118),('09291199','Journal of Corporate Finance',9.54325,286),('09291261','European Journal of Law and Economics',9.03924,315),('09318658','Journal of Economics (Zeitschrift fur Nationa',12.3879,187),('09324569','Journal of Institutional and Theoretical Econ',11.4689,218),('09331433','Journal of Population Economics',20.2053,88),('09369937','Journal of Evolutionary Economics',12.4501,184),('09382259','Economic Theory',34.093,40),('09393625','Economic Systems',10.6073,243),('09430180','Homo Oeconomicus',8.40701,355),('09485139','Jahrbuch fur Wirtschaftswissenschaften/Review',7.15373,510),('09492984','Finance and Stochastics',10,264),('09500804','Journal of Economic Surveys',9.98665,265),('09506764','Development Policy Review',7.36076,478),('09535314','Economic Systems Research',8.72404,338),('09538259','Review of Political Economy',7.14564,511),('09541985','Economics and Politics',12.0202,197),('0954349X','Structural Change and Economic Dynamics',7.96227,392),('09571787','Utilities Policy',7.7886,408),('09599916','Journal of Property Research',6.91542,557),('09601627','Mathematical Finance',27.6627,55),('09603107','Applied Financial Economics',7.27502,487),('09606491','Industrial and Corporate Change',20.282,87),('09638008','Financial Markets Institutions and Instrument',10.2991,249),('09638024','Journal of African Economies',11.7278,210),('09638199','Journal of International Trade and Economic D',7.74808,414),('09641998','Journal of the Royal Statistical Society: Ser',10.3544,247),('09645292','Education Economics',8.47539,351),('09657576','Review of International Economics',12.9478,172),('09658564','Transportation Research: Part A: Policy and P',24.0824,67),('09670750','Economics of Transition',10.0484,261),('09672567','European Journal of the History of Economic T',7.93381,395),('09685650','Financial History Review',7.96871,390),('09692290','Review of International Political Economy',13.5311,156),('09711554','Journal of Quantitative Economics New Series',7.21164,500),('10116702','Journal of World Trade',8.44435,353),('10168737','International Economic Journal',7.47185,457),('1018161X','Academia Economic Papers',7.85226,403),('10183833','Taiwan Economic Review',7.66662,426),('10207635','IMF Staff Papers',9.844,270),('10222898','Journal of Financial Studies',6.91362,559),('10242694','Defence and Peace Economics',9.88633,269),('10275703','Integration and Trade',7.23354,495),('10353046','Economic and Labour Relations Review',7.65087,427),('10370196','History of Economics Review',7.40001,473),('10424431','Journal of International Financial Markets In',11.1275,227),('10429573','Journal of Financial Intermediation',13.1736,171),('10434062','Constitutional Political Economy',8.99424,320),('10438599','Economics of Innovation and New Technology',8.24278,366),('1043951X','China Economic Review',11.5789,214),('10490078','Journal of Asian Economics',7.77653,412),('10511377','Journal of Housing Economics',12.3841,188),('10527001','Journal of Housing Research',7.78177,410),('10535357','Journal of Socio-Economics',8.35371,358),('10538372','Journal of the History of Economic Thought',7.93766,394),('10568190','Papers in Regional Science',14.8945,138),('10579230','Health Economics',33.8156,42),('10583300','Review of Financial Economics',6.79485,588),('10586407','Journal of Economics and Management Strategy',25.2362,64),('10587195','Review of Agricultural Economics',6.72055,606),('10590560','International Review of Economics and Finance',11.4145,222),('1060586X','Post-Soviet Affairs',9.66908,277),('10629408','North American Journal of Economics and Finan',9.39909,292),('10629769','Quarterly Review of Economics and Finance',7.30863,483),('10682805','Agricultural and Resource Economics Review',7.19709,504),('10685502','Journal of Agricultural and Resource Economic',7.6316,430),('10697225','Federal Reserve Bank of Richmond Economic Qua',13.3833,163),('10741240','Journal of Derivatives',6.8991,564),('10743529','Contemporary Economic Policy',11.7536,208),('10769307','International Journal of Finance and Economic',6.91185,561),('10792457','Peace Economics Peace Science and Public Poli',7.17023,507),('10808620','Real Estate Economics',17.2988,106),('10811826','Studies in Nonlinear Dynamics and Econometric',10.1437,256),('10861653','Independent Review',8.80414,333),('10904999','Journal of Regional Analysis and Policy',6.8175,583),('10909443','Research in Economics',8.11139,376),('10911421','Public Finance Review',7.67667,424),('10920277','North American Actuarial Journal',6.79042,589),('10942025','Review of Economic Dynamics',34.5656,37),('10973923','Journal of Public Economic Theory',14.2912,147),('11046899','Journal of Forest Economics',9.93888,266),('11207019','Journal of Public Finance and Public Choice/E',8.18069,372),('11209496','Politica Economica',6.82268,582),('11217081','Labour',9.02644,316),('11228792','History of Economic Ideas',7.97568,389),('11330686','TEST',7.48,456),('11578637','Communications and Strategies',7.05909,527),('12100455','Prague Economic Papers',7.61208,432),('12123609','Ekonomie a Management',6.86772,572),('12250279','Seoul Journal of Economics',7.3086,484),('12264261','Journal of Economic Research',8.69284,342),('1226508X','Global Economic Review',8.41828,354),('12268550','Journal of International and Area Studies',7.18129,506),('12292893','Journal of Economic Theory and Econometrics',9.17908,306),('12408093','Economie Internationale',8.01136,386),('12454060','Revue d\'Economie du Developpement',10.0312,263),('12659576','Revue de L\'OFCE',6.89112,569),('12675059','Region et Developpement',6.75846,598),('1300610X','Iktisat Isletme ve Finans',9.73262,273),('13007262','Marmara University Journal of Economic and Ad',7.11372,520),('13030701','Central Bank Review',7.06252,526),('13088793','International Econometric Review',8.96928,325),('1309422X','Eurasian Economic Review',7.19096,505),('13221833','Agenda',6.84146,578),('13281143','Australian Journal of Labour Economics',6.92788,555),('13318004','Zbornik Radova Ekonomskog Fakulteta u Rijeci:',7.40305,472),('1350178X','Journal of Economic Methodology',7.56098,439),('13504851','Applied Economics Letters',10.7502,237),('1350486X','Applied Mathematical Finance',6.78592,590),('13507419','Economic and Financial Modelling',6.72669,604),('13513958','Asian Economic Journal',6.90762,563),('1351847X','European Journal of Finance',6.95208,549),('13524739','Japanese Economic Review',9.56033,285),('13545701','Feminist Economics',13.4823,161),('13547798','European Financial Management',7.66865,425),('13547860','Journal of the Asia Pacific Economy',7.07396,524),('13548166','Tourism Economics',8.71384,340),('1355770X','Environment and Development Economics',8.33891,361),('13563467','New Political Economy',10.6644,240),('13571516','International Journal of the Economics of Bus',7.22969,496),('13600818','Oxford Development Studies',7.03313,531),('1361374X','Pacific Economic Review',9.16442,307),('13614916','European Review of Economic History',11.8429,206),('13636669','Review of Development Economics',11.5042,217),('13637029','Economic Issues',6.89164,568),('1364985X','Australian Journal of Agricultural and Resour',12.8655,174),('13651005','Macroeconomic Dynamics',17.1717,108),('13662716','Industry and Innovation',9.09667,312),('13665545','Transportation Research: Part E: Logistics an',18.4965,95),('13670271','International Finance',9.09204,313),('13684221','Econometrics Journal',19.6017,92),('13691066','Venture Capital',7.06496,525),('1369412X','International Review of Finance',8.23149,367),('13704788','Annals of Public and Cooperative Economics',6.73499,603),('13760971','Revue de Philosophie Economique/Review of Eco',8.22513,368),('13806645','Review of Derivatives Research',11.2211,225),('13806653','Review of Accounting Studies',7.44723,460),('13814338','Journal of Economic Growth',34.7249,36),('13859587','Netnomics',6.92619,556),('13864157','Experimental Economics',34.2491,38),('13864181','Journal of Financial Markets',10.3116,248),('13872834','Asia-Pacific Financial Markets',6.98242,544),('13876996','Journal of Bioeconomics',8.57642,347),('13896563','International Journal of Health Care Finance ',9.72513,274),('1406099X','Baltic Journal of Economics',7.48164,455),('14322994','Mathematical Methods of Operations Research',7.21965,499),('1432847X','Environmental Economics and Policy Studies',7.36459,477),('14344742','Review of Economic Design',16.3681,119),('14356104','Economics of Governance',12.0326,196),('14469022','Review of Network Economics',9.27451,299),('1452595X','Panoeconomicus',10.9276,233),('14631377','Post-Communist Economies',6.92978,553),('14636786','Manchester School',9.71429,275),('14656485','German Economic Review',11.4408,220),('14656493','Perspektiven der Wirtschaftspolitik',7.47064,458),('14657252','American Law and Economics Review',14.755,140),('14682702','Journal of Economic Geography',26.8871,58),('14693062','Climate Policy',7.13332,513),('14697688','Quantitative Finance',17.7335,98),('14747456','World Trade Review',8.80727,332),('14747472','Journal of Pension Economics and Finance',13.3817,164),('14751461','Socio-Economic Review',8.97976,322),('14765667','International Journal of Technology and Globa',6.74773,601),('14773880','International Review of Economics Education',7.51022,448),('14798409','Journal of Financial Econometrics',22.209,81),('14929759','International Productivity Monitor',8.15522,374),('14965208','Estey Centre Journal of International Law and',6.85656,575),('15140326','Journal of Applied Economics',8.733,337),('15214842','Journal of Real Estate Practice and Education',7.20539,501),('1522936X','AgBioForum',7.41651,467),('15239721','Public Finance and Management',7.92624,397),('15270025','Journal of Sports Economics',11.5468,215),('15287084','Brookings-Wharton Papers on Urban Affairs',16.2054,121),('15297373','Annals of Economics and Finance',7.5191,446),('15297470','Economia: Journal of the Latin American and C',8.33975,360),('15337790','Demography',10.9968,231),('15345963','B.E. Journal of Theoretical Economics: Advanc',12.7558,176),('15345971','B.E. Journal of Theoretical Economics: Contri',12.6522,180),('1534598X','B.E. Journal of Theoretical Economics: Topics',11.3505,223),('15345998','B.E. Journal of Macroeconomics: Topics in Mac',11.8995,204),('15346005','B.E. Journal of Macroeconomics: Contributions',12.3514,189),('15346013','B.E. Journal of Macroeconomics: Advances in M',11.9412,202),('15353516','Asian Economic Papers',7.92495,398),('15380629','B.E. Journal of Economic Analysis and Policy:',12.1271,191),('15380637','B.E. Journal of Economic Analysis and Policy:',17.3469,105),('15380645','B.E. Journal of Economic Analysis and Policy:',17.243,107),('15380653','B.E. Journal of Economic Analysis and Policy:',16.9538,113),('1540496X','Emerging Markets Finance and Trade',7.02743,533),('15420485','Journal of Agricultural and Food Industrial O',8.07407,379),('15424766','Journal of the European Economic Association',47.3418,21),('15427560','Journal of Behavioral Finance',10.996,232),('15452921','Economics Bulletin',7.79425,407),('15459144','Journal of Investment Management',8.35324,359),('15465616','Review of Marketing Science',7.05662,528),('15479846','Foundations and Trends in Microeconomics',9.63412,280),('15480003','International Journal of Applied Economics',7.44633,461),('15513076','Foundations and Trends in Econometrics',14.8677,139),('15533832','Economists\' Voice',8.39743,356),('15540189','Competition Policy International',7.87112,401),('15540626','Quarterly Journal of Political Science',11.2253,224),('15540642','Foundations and Trends in Accounting',7.50598,449),('1554964X','Geneva Risk and Insurance Review',7.28793,486),('15555879','Review of Law and Economics',10.1672,254),('15557561','Theoretical Economics',16.828,115),('15573060','Education Finance and Policy',9.57995,284),('15597431','Review of International Organizations',9.28102,298),('15660141','Emerging Markets Review',9.64174,279),('1566113X','Networks and Spatial Economics',6.89401,566),('15661679','Journal of Industry Competition and Trade',7.37597,475),('15672395','Foundations and Trends in Finance',8.97807,323),('15691721','Journal of Economic Inequality',17.0633,110),('15695239','Review of Economics of the Household',10.7529,236),('1570677X','Economics and Human Biology',15.0741,135),('15707156','Quantitative Marketing and Economics',14.1277,151),('15723089','Journal of Financial Stability',12.1213,192),('15723097','Review of Finance',23.0247,75),('15739414','Economic Change and Restructuring',6.91131,562),('15780732','Economia Agraria y Recursos Naturales',6.77212,596),('15829146','Amfiteatru Economic',7.14437,512),('15937879','Mind and Society',7.40981,469),('15938662','Rivista Italiana degli Economisti',7.22034,498),('15938883','Decisions in Economics and Finance',7.30507,485),('16070704','International Journal of Business and Economi',7.2573,490),('16081625','Asia-Pacific Journal of Accounting and Econom',9.12434,310),('1610241X','CESifo Economic Studies',10.0945,258),('16102878','Review of World Economics/Weltwirtschaftliche',12.0972,195),('16111699','Journal of Business Economics and Management',7.84725,405),('16124812','International Economics and Economic Policy',7.20334,502),('16142446','Annals of Finance',9.26705,300),('16143485','Zeitschrift fur ArbeitsmarktForschung/Journal',6.7172,608),('1615245X','CESifo Forum',8.69106,343),('16187598','European Journal of Health Economics',15.8407,125),('16712234','China and World Economy',8.57995,346),('16733444','Frontiers of Economics in China',6.9133,560),('17057299','Assurances et Gestion des Risques/Insurance a',7.84895,404),('17204100','Studi e Note di Economia',6.99086,539),('17421772','Spatial Economic Analysis',11.0789,228),('17427355','International Journal of Economic Theory',13.223,168),('17441331','Health Economics Policy and Law',6.80405,587),('17441374','Journal of Institutional Economics',12.0977,194),('17446414','Journal of Competition Law and Economics',12.8305,175),('17475864','International Journal of Microsimulation',6.99135,538),('17506816','Review of Environmental Economics and Policy',9.77042,272),('17521378','Cambridge Journal of Regions Economy and Soci',11.032,230),('17538254','Indian Growth and Development Review',7.69819,422),('1756137X','China Agricultural Economic Review',8.12299,375),('17563607','Journal of Energy Markets',6.92963,554),('17567130','International Journal of Financial Markets an',6.91436,558),('17576385','Journal of Financial Economic Policy',8.03357,382),('17597323','Quantitative Economics',17.0414,111),('17752329','Economie et Institutions',7.10765,521),('17782333','Quarterly Selection of Articles',8.2117,369),('17939933','Journal of International Commerce Economics a',7.11492,519),('18142044','Frontiers in Finance and Economics',8.08697,378),('18154654','International Journal of Central Banking',8.55633,348),('18281990','Storia del Pensiero Economico: Nuova Serie',7.40805,470),('18328105','Asian Economic Policy Review',8.4865,350),('1860711X','Journal of Economic Interaction and Coordinat',7.34631,480),('18632505','Cliometrica',11.9497,200),('18644031','Letters in Spatial and Resource Sciences',7.72868,416),('18645739','International Commerce Review',7.16621,509),('18646042','Economics: The Open-Access Open-Assessment E-',10.6868,239),('18651704','International Review of Economics',7.72805,417),('18694187','SERIEs',15.2082,129),('18737374','Economics Letters',25.4942,63),('18769098','Erasmus Journal for Philosophy and Economics',7.43068,463),('18855628','e-Publica',6.83036,581),('19044526','Nordic Economic Policy Review',10.1344,257),('19297092','Journal of Reviews on Global Economics',7.0972,522),('19302975','Judgment and Decision Making',6.8423,577),('19314361','Journal of Wine Economics',9.21451,302),('19320183','Basic Income Studies',7.63185,429),('19320213','Capitalism and Society',9.60115,282),('19321465','International Review of Environmental and Res',8.97448,324),('19328575','Journal of Human Capital',13.2886,167),('1933527X','Econ Journal Watch',8.02059,384),('19344554','Financial Markets and Portfolio Management',6.76641,597),('19351682','B.E. Journal of Economic Analysis and Policy',14.9242,137),('19351690','B.E. Journal of Macroeconomics',12.3882,186),('19351704','B.E. Journal of Theoretical Economics',12.2543,190),('19355041','Journal of Industrial Organization Education',9.91718,267),('19405979','Review of Behavioral Finance',7.53129,444),('1940655X','Journal of International and Global Economic ',7.13291,514),('19411340','Annual Review of Resource Economics',7.24104,494),('19411367','Annual Review of Financial Economics',17.5827,101),('19411383','Annual Review of Economics',16.5711,116),('19411928','Journal of Time Series Econometrics',15.7935,127),('1944012X','Strategic Behavior and the Environment',8.89121,329),('19457669','American Economic Journal: Microeconomics',34.0327,41),('19457707','American Economic Journal: Macroeconomics',44.6618,23),('19457731','American Economic Journal: Economic Policy',32.9933,43),('19457782','American Economic Journal: Applied Economics',44.1011,24),('19481837','Journal of Globalization and Development',9.25373,301),('19498276','Journal of Sustainable Real Estate',6.94923,550),('19733909','Review of Economic Analysis',8.98229,321),('19744730','Enometrica',6.98525,543),('19802447','Brazilian Review of Econometrics',8.71985,339),('1994201X','State Bank of Pakistan Research Bulletin',7.63275,428),('19952880','OECD Journal: Journal of Business Cycle Measu',6.77951,592),('20100078','Climate Change Economics',8.58857,345),('20101392','Quarterly Journal of Finance',10.7347,238),('20104952','Annals of Financial Economics',8.10842,377),('20381379','Review of Economics and Institutions',10.4765,246),('20405790','Applied Economic Perspectives and Policy',13.2107,170),('20414161','IMF Economic Review',32.3228,44),('20440839','Journal of Agribusiness in Developing and Eme',7.3414,481),('20459920','Review of Asset Pricing Studies',13.8351,152),('20469128','Review of Corporate Finance Studies',13.3776,165),('20495323','Review of Keynesian Economics',7.12229,517),('20495838','Migration Studies',7.61355,431),('20498640','Journal of Financial Perspectives',7.00317,536),('20734336','Games',10.759,235),('21107017','International Economics',6.7574,599),('21135207','Oeconomia',6.87713,571),('21522812','Journal of Benefit-Cost Analysis',7.78033,411),('21530785','Dynamic Games and Applications',9.14345,308),('21605882','Economics of Energy and Environmental Policy',9.59966,283),('21622078','Theoretical Economics Letters',8.69372,341),('21938997','IZA Journal of Labor Economics',13.4972,160),('21939004','IZA Journal of Labor Policy',7.16846,508),('21939012','IZA Journal of European Labor Studies',7.70493,420),('21939020','IZA Journal of Labor and Development',9.13977,309),('21939039','IZA Journal of Migration',7.97984,388),('21946191','Forum for Health Economics and Policy',8.26447,365),('21991227','Credit and Capital Markets/Kredit und Kapital',6.8841,570),('22104275','Complexity Economics',7.04664,529),('22120122','Economics of Transportation',9.42241,291),('22124284','Water Resources and Economics',7.38935,474),('22409971','History of Economic Thought and Policy',9.02501,317),('22513612','Global Journal of Economics',11.7407,209),('22625321','Vie et Sciences de l\'Entreprise',6.89777,565),('23093013','Quantile',13.5896,155),('87566222','Journal of Law Economics and Organization',28.3119,53);
423/*!40000 ALTER TABLE `classificacao_periodico_clm` ENABLE KEYS */;
424UNLOCK TABLES;
425
426--
427-- Table structure for table `curso`
428--
429
430DROP TABLE IF EXISTS `curso`;
431/*!40101 SET @saved_cs_client     = @@character_set_client */;
432/*!40101 SET character_set_client = utf8 */;
433CREATE TABLE `curso` (
434  `id` int(11) NOT NULL AUTO_INCREMENT,
435  `nome` varchar(45) NOT NULL,
436  PRIMARY KEY (`id`)
437) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8;
438/*!40101 SET character_set_client = @saved_cs_client */;
439
440--
441-- Dumping data for table `curso`
442--
443
444LOCK TABLES `curso` WRITE;
445/*!40000 ALTER TABLE `curso` DISABLE KEYS */;
446INSERT INTO `curso` VALUES (201,'Graduação'),(202,'Mestrado Acadêmico'),(203,'Doutorado'),(204,'Mestrado Profissional');
447/*!40000 ALTER TABLE `curso` ENABLE KEYS */;
448UNLOCK TABLES;
449
450--
451-- Table structure for table `demais_trabalhos`
452--
453
454DROP TABLE IF EXISTS `demais_trabalhos`;
455/*!40101 SET @saved_cs_client     = @@character_set_client */;
456/*!40101 SET character_set_client = utf8 */;
457CREATE TABLE `demais_trabalhos` (
458  `id` int(11) NOT NULL AUTO_INCREMENT,
459  `producaoBibliograficaID` int(11) NOT NULL,
460  `natureza` varchar(255) DEFAULT NULL COMMENT 'Natureza da publicação',
461  `finalidade` varchar(255) DEFAULT NULL,
462  `local` varchar(128) DEFAULT NULL,
463  PRIMARY KEY (`id`,`producaoBibliograficaID`),
464  KEY `fk_outra_producao_producao_bibliografica1` (`producaoBibliograficaID`),
465  CONSTRAINT `fk_outra_producao_producao_bibliografica10` FOREIGN KEY (`producaoBibliograficaID`) REFERENCES `producao_bibliografica` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
466) ENGINE=InnoDB DEFAULT CHARSET=utf8;
467/*!40101 SET character_set_client = @saved_cs_client */;
468
469--
470-- Dumping data for table `demais_trabalhos`
471--
472
473LOCK TABLES `demais_trabalhos` WRITE;
474/*!40000 ALTER TABLE `demais_trabalhos` DISABLE KEYS */;
475/*!40000 ALTER TABLE `demais_trabalhos` ENABLE KEYS */;
476UNLOCK TABLES;
477
478--
479-- Table structure for table `equipe_projeto`
480--
481
482DROP TABLE IF EXISTS `equipe_projeto`;
483/*!40101 SET @saved_cs_client     = @@character_set_client */;
484/*!40101 SET character_set_client = utf8 */;
485CREATE TABLE `equipe_projeto` (
486  `pessoaID` int(11) NOT NULL,
487  `projetoPesquisaID` int(11) NOT NULL,
488  `responsavel` tinyint(1) NOT NULL DEFAULT '0',
489  PRIMARY KEY (`pessoaID`,`projetoPesquisaID`),
490  KEY `fk_pessoa_has_projeto_pesquisa_projeto_pesquisa1_idx` (`projetoPesquisaID`),
491  KEY `fk_pessoa_has_projeto_pesquisa_pessoa1_idx` (`pessoaID`),
492  CONSTRAINT `fk_pessoa_has_projeto_pesquisa_pessoa1` FOREIGN KEY (`pessoaID`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
493  CONSTRAINT `fk_pessoa_has_projeto_pesquisa_projeto_pesquisa1` FOREIGN KEY (`projetoPesquisaID`) REFERENCES `projeto_pesquisa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
494) ENGINE=InnoDB DEFAULT CHARSET=utf8;
495/*!40101 SET character_set_client = @saved_cs_client */;
496
497--
498-- Dumping data for table `equipe_projeto`
499--
500
501LOCK TABLES `equipe_projeto` WRITE;
502/*!40000 ALTER TABLE `equipe_projeto` DISABLE KEYS */;
503/*!40000 ALTER TABLE `equipe_projeto` ENABLE KEYS */;
504UNLOCK TABLES;
505
506--
507-- Table structure for table `evento_pessoa`
508--
509
510DROP TABLE IF EXISTS `evento_pessoa`;
511/*!40101 SET @saved_cs_client     = @@character_set_client */;
512/*!40101 SET character_set_client = utf8 */;
513CREATE TABLE `evento_pessoa` (
514  `pessoaID` int(11) NOT NULL,
515  `organizacaoEventoID` int(11) NOT NULL,
516  PRIMARY KEY (`pessoaID`,`organizacaoEventoID`),
517  KEY `idpessoa_organizacao_eventoorganizacao_evento1_idx` (`organizacaoEventoID`),
518  KEY `idpessoa_organizacao_eventopessoa1_idx` (`pessoaID`),
519  CONSTRAINT `idpessoa_organizacao_eventoorganizacao_evento1` FOREIGN KEY (`organizacaoEventoID`) REFERENCES `organizacao_evento` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
520  CONSTRAINT `idpessoa_organizacao_eventopessoa1` FOREIGN KEY (`pessoaID`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
521) ENGINE=InnoDB DEFAULT CHARSET=utf8;
522/*!40101 SET character_set_client = @saved_cs_client */;
523
524--
525-- Dumping data for table `evento_pessoa`
526--
527
528LOCK TABLES `evento_pessoa` WRITE;
529/*!40000 ALTER TABLE `evento_pessoa` DISABLE KEYS */;
530/*!40000 ALTER TABLE `evento_pessoa` ENABLE KEYS */;
531UNLOCK TABLES;
532
533--
534-- Table structure for table `financiador_projeto`
535--
536
537DROP TABLE IF EXISTS `financiador_projeto`;
538/*!40101 SET @saved_cs_client     = @@character_set_client */;
539/*!40101 SET character_set_client = utf8 */;
540CREATE TABLE `financiador_projeto` (
541  `id` int(11) NOT NULL AUTO_INCREMENT,
542  `projetoPesquisaID` int(11) NOT NULL,
543  `codigoInstituicao` varchar(20) NOT NULL,
544  `nomeInstituicao` varchar(255) NOT NULL,
545  `natureza` varchar(45) NOT NULL,
546  PRIMARY KEY (`id`),
547  KEY `fk_financiador_projeto_projeto_pesquisa1_idx` (`projetoPesquisaID`),
548  CONSTRAINT `fk_financiador_projeto_projeto_pesquisa1` FOREIGN KEY (`projetoPesquisaID`) REFERENCES `projeto_pesquisa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
549) ENGINE=InnoDB DEFAULT CHARSET=utf8;
550/*!40101 SET character_set_client = @saved_cs_client */;
551
552--
553-- Dumping data for table `financiador_projeto`
554--
555
556LOCK TABLES `financiador_projeto` WRITE;
557/*!40000 ALTER TABLE `financiador_projeto` DISABLE KEYS */;
558/*!40000 ALTER TABLE `financiador_projeto` ENABLE KEYS */;
559UNLOCK TABLES;
560
561--
562-- Table structure for table `grupo_capes`
563--
564
565DROP TABLE IF EXISTS `grupo_capes`;
566/*!40101 SET @saved_cs_client     = @@character_set_client */;
567/*!40101 SET character_set_client = utf8 */;
568CREATE TABLE `grupo_capes` (
569  `grupo` varchar(5) NOT NULL,
570  `peso` int(5) NOT NULL,
571  PRIMARY KEY (`grupo`),
572  UNIQUE KEY `grupo_UNIQUE` (`grupo`)
573) ENGINE=InnoDB DEFAULT CHARSET=utf8;
574/*!40101 SET character_set_client = @saved_cs_client */;
575
576--
577-- Dumping data for table `grupo_capes`
578--
579
580LOCK TABLES `grupo_capes` WRITE;
581/*!40000 ALTER TABLE `grupo_capes` DISABLE KEYS */;
582INSERT INTO `grupo_capes` VALUES ('A1',100),('A2',80),('B1',60),('B2',40),('B3',25),('B4',15),('B5',5),('C',0),('NC',0);
583/*!40000 ALTER TABLE `grupo_capes` ENABLE KEYS */;
584UNLOCK TABLES;
585
586--
587-- Table structure for table `grupo_epge`
588--
589
590DROP TABLE IF EXISTS `grupo_epge`;
591/*!40101 SET @saved_cs_client     = @@character_set_client */;
592/*!40101 SET character_set_client = utf8 */;
593CREATE TABLE `grupo_epge` (
594  `grupo` varchar(5) NOT NULL,
595  `peso` int(5) NOT NULL,
596  PRIMARY KEY (`grupo`),
597  UNIQUE KEY `peso_UNIQUE` (`peso`),
598  UNIQUE KEY `grupo_UNIQUE` (`grupo`)
599) ENGINE=InnoDB DEFAULT CHARSET=utf8;
600/*!40101 SET character_set_client = @saved_cs_client */;
601
602--
603-- Dumping data for table `grupo_epge`
604--
605
606LOCK TABLES `grupo_epge` WRITE;
607/*!40000 ALTER TABLE `grupo_epge` DISABLE KEYS */;
608INSERT INTO `grupo_epge` VALUES ('8',0),('7',4),('6',8),('5',12),('4',20),('3-B',30),('3-A',40),('2-B',50),('2-A',60),('1',100);
609/*!40000 ALTER TABLE `grupo_epge` ENABLE KEYS */;
610UNLOCK TABLES;
611
612--
613-- Table structure for table `image`
614--
615
616DROP TABLE IF EXISTS `image`;
617/*!40101 SET @saved_cs_client     = @@character_set_client */;
618/*!40101 SET character_set_client = utf8 */;
619CREATE TABLE `image` (
620  `id` int(11) NOT NULL AUTO_INCREMENT,
621  `name` varchar(255) NOT NULL,
622  `path` varchar(255) NOT NULL,
623  `extension` varchar(255) NOT NULL,
624  `fileName` varchar(255) NOT NULL,
625  `byteSize` int(10) NOT NULL,
626  `mimeType` varchar(255) NOT NULL,
627  `created` datetime DEFAULT NULL,
628  `crop` varchar(255) DEFAULT '',
629  PRIMARY KEY (`id`)
630) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
631/*!40101 SET character_set_client = @saved_cs_client */;
632
633--
634-- Dumping data for table `image`
635--
636
637LOCK TABLES `image` WRITE;
638/*!40000 ALTER TABLE `image` DISABLE KEYS */;
639INSERT INTO `image` VALUES (7,'foto-3-4.jpg','files/images/usuarios/','jpg','usuario_506ed03797cf51.62342635.jpg',45770,'image/jpeg','2012-10-05 09:19:03','{x:0,y:0,x2:320,y2:320,w:320,h:320}');
640/*!40000 ALTER TABLE `image` ENABLE KEYS */;
641UNLOCK TABLES;
642
643--
644-- Table structure for table `instituicao`
645--
646
647DROP TABLE IF EXISTS `instituicao`;
648/*!40101 SET @saved_cs_client     = @@character_set_client */;
649/*!40101 SET character_set_client = utf8 */;
650CREATE TABLE `instituicao` (
651  `id` int(11) NOT NULL AUTO_INCREMENT,
652  `nome` varchar(255) NOT NULL,
653  `sigla` varchar(64) DEFAULT NULL,
654  `conceitoCapes` smallint(5) unsigned NOT NULL,
655  PRIMARY KEY (`id`)
656) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;
657/*!40101 SET character_set_client = @saved_cs_client */;
658
659--
660-- Dumping data for table `instituicao`
661--
662
663LOCK TABLES `instituicao` WRITE;
664/*!40000 ALTER TABLE `instituicao` DISABLE KEYS */;
665INSERT INTO `instituicao` VALUES (1,'FGV EPGE-31011012002P2','EPGE',7),(2,'FGV EESP-33014019002P7','EESP',7),(4,'USP-33002010036P4','USP',7),(5,'PUC-RIO-31005012008P4','PUC-RIO',6),(7,'UFMG-32001010013P5','UFMG',6),(8,'UFPR-40001016024P0','UFPR',6),(10,'UNB-53001010012P1','UNB',6),(11,'UNICAMP-33003017020P7','UNICAMP',6),(12,'INSPER-33129010001P1','INSPER',5),(13,'IBMEC-31034012002P5','IBMEC',5),(50,'FGV EBAPE-31011012004P5',' EBAPE',6),(51,'UERJ-31004016032P6','UERJ',4),(52,'UFF-31003010022P8','UFF',5),(53,'UFRJ-31001017025P0','UFRJ',5);
666/*!40000 ALTER TABLE `instituicao` ENABLE KEYS */;
667UNLOCK TABLES;
668
669--
670-- Table structure for table `jornal_revista`
671--
672
673DROP TABLE IF EXISTS `jornal_revista`;
674/*!40101 SET @saved_cs_client     = @@character_set_client */;
675/*!40101 SET character_set_client = utf8 */;
676CREATE TABLE `jornal_revista` (
677  `id` int(11) NOT NULL AUTO_INCREMENT,
678  `producaoBibliograficaID` int(11) NOT NULL,
679  `natureza` varchar(128) NOT NULL,
680  `tituloJornalRevista` varchar(255) NOT NULL COMMENT 'Título do jornal ou revista',
681  `issn` varchar(13) DEFAULT NULL,
682  `dataPublicacao` date DEFAULT NULL COMMENT 'Data de publicação',
683  `volume` varchar(64) DEFAULT NULL COMMENT 'Volúme',
684  `paginaInicial` varchar(10) DEFAULT NULL COMMENT 'Página inicial',
685  `paginaFinal` varchar(10) DEFAULT NULL COMMENT 'Página final',
686  `localPublicacao` varchar(100) DEFAULT NULL COMMENT 'Local de publicação',
687  PRIMARY KEY (`id`,`producaoBibliograficaID`),
688  KEY `fk_jornal_revista_producao_bibliografica1_idx` (`producaoBibliograficaID`),
689  CONSTRAINT `fk_jornal_revista_producao_bibliografica1` FOREIGN KEY (`producaoBibliograficaID`) REFERENCES `producao_bibliografica` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
690) ENGINE=InnoDB DEFAULT CHARSET=utf8;
691/*!40101 SET character_set_client = @saved_cs_client */;
692
693--
694-- Dumping data for table `jornal_revista`
695--
696
697LOCK TABLES `jornal_revista` WRITE;
698/*!40000 ALTER TABLE `jornal_revista` DISABLE KEYS */;
699/*!40000 ALTER TABLE `jornal_revista` ENABLE KEYS */;
700UNLOCK TABLES;
701
702--
703-- Table structure for table `listanegra_producao`
704--
705
706DROP TABLE IF EXISTS `listanegra_producao`;
707/*!40101 SET @saved_cs_client     = @@character_set_client */;
708/*!40101 SET character_set_client = utf8 */;
709CREATE TABLE `listanegra_producao` (
710  `id` int(11) NOT NULL AUTO_INCREMENT,
711  `hash` varchar(32) NOT NULL,
712  `dataCadastro` datetime NOT NULL,
713  PRIMARY KEY (`id`),
714  UNIQUE KEY `hash_UNIQUE` (`hash`)
715) ENGINE=InnoDB AUTO_INCREMENT=760 DEFAULT CHARSET=utf8;
716/*!40101 SET character_set_client = @saved_cs_client */;
717
718--
719-- Dumping data for table `listanegra_producao`
720--
721
722LOCK TABLES `listanegra_producao` WRITE;
723/*!40000 ALTER TABLE `listanegra_producao` DISABLE KEYS */;
724INSERT INTO `listanegra_producao` VALUES (350,'b4005f7289354d9de1b45fb8f53afe69','2017-01-26 09:37:32'),(351,'6bb60d92a15a7475520a0b368178e3ac','2017-01-26 09:38:48'),(354,'e92da72410721c6d908a46be9f74c22c','2017-01-26 09:45:41'),(355,'bb1bb33c89e8dc4bb81c0fa6171f3163','2017-01-26 09:45:51'),(356,'6e4986bbf2d9d6e8cdb18f78f892937c','2017-01-26 09:46:39'),(357,'9cf10fa0995475f4e07fb5035ff99ca6','2017-01-26 09:47:49'),(359,'8dd8df8939998c30a27ea93dd7f8e939','2017-01-26 09:48:01'),(360,'b07cd69fbfd6e2924742623cfb019e26','2017-01-26 09:48:30'),(361,'32500c19fbee9f1dcf40f2f1397877c1','2017-01-26 09:49:23'),(362,'d7acc7bb19df5d42088798576cf7b430','2017-01-26 09:50:19'),(363,'20685f501828b3e56334a72d8da98dce','2017-01-26 09:50:32'),(364,'aeeb5e517859b4f6da452d810573e24f','2017-01-26 09:53:11'),(365,'91a68d5b1e9d92ba24b9e45b627f0b77','2017-01-26 09:53:30'),(366,'b9966e6b02b5f05b2fd5c7c098601384','2017-01-26 09:53:49'),(367,'12a954058e8a210c726cf80e355d6b60','2017-01-26 09:53:59'),(368,'25f1a3320ba1ceba0217a2dbfd779e65','2017-01-26 09:57:29'),(369,'355f3b93922f08ad40380852f92c72dd','2017-01-26 09:57:52'),(370,'e21cb6296d82cecd8999db21a72d195c','2017-01-26 09:58:30'),(371,'3cdd1cd85d9cb0d5198834361ffa8a46','2017-01-26 09:58:46'),(372,'303af7ae3c7dba993cac63a9e6eed3e7','2017-01-26 09:59:12'),(373,'72af1a6f36f408bbd1a2c6cb9766ec74','2017-01-26 10:01:40'),(374,'b80f1e6d286ffe7df1bd267ef8f3f9c3','2017-01-26 10:02:07'),(386,'5e30583112dc3e40929c89fcff52b475','2017-01-26 10:07:49'),(388,'00094b5b46e4949e58e3c7efc261cb9d','2017-01-26 10:08:57'),(390,'45007c3390d206fbc8795fcf8d021b0d','2017-01-26 10:17:52'),(391,'a3ef0b59d94bde63a5aeb226a7c6cd4b','2017-01-26 10:20:14'),(392,'457fc046227cd9f8cce853e67d90c24f','2017-01-26 10:21:10'),(393,'7aa258bb1877a49fb58d12c501a5342f','2017-01-26 10:21:53'),(394,'f468c2f7ad0801af428a98f76dc6192e','2017-01-26 10:21:55'),(395,'f9fa5442ad914e42dc0a8417a087fd09','2017-01-26 10:24:09'),(396,'c02c4dae47a443826db837eef14c227a','2017-01-26 10:24:18'),(397,'640aab2bd182756dde53934127bfc78a','2017-01-26 10:26:35'),(398,'84531ef9d39de70a6bf7a2538059c7d9','2017-01-26 10:26:59'),(399,'efe0ddcf83b27ac576f210f3c8a7d7d1','2017-01-26 10:28:04'),(400,'083adc768d369405379be175a07a03b0','2017-01-26 10:28:41'),(401,'ffed6c7897a48f7fc55036228697508e','2017-01-26 10:29:34'),(402,'724b84ce572aedb3c19f3a7751729012','2017-01-26 10:29:54'),(403,'c0996f8dee6801d4055bcb3009e52981','2017-01-26 10:30:15'),(405,'6cba5fee0ae112bdbf0f4f9f7bc43508','2017-01-26 10:31:48'),(406,'91c332b1dbba5c33bc3da1a735b29693','2017-01-26 10:32:04'),(407,'0947b7bd26a81ed39756e755b73f5dc5','2017-01-26 10:33:40'),(408,'b30a8082e20592a8f66ada142b60344c','2017-01-26 10:34:51'),(409,'b7c72488b2bbb61ff15c320b8d9b9780','2017-01-26 10:35:07'),(410,'0c05f7be1f07c3b067fec7e5f7dbe117','2017-01-26 10:36:13'),(411,'68b049ba3890d72f1df44121ebc79281','2017-01-26 10:36:45'),(412,'05e3feb93578f709d8ad9e41e20a43e1','2017-01-26 10:37:00'),(413,'5b56ad982df31acda2b594e21d0fca36','2017-01-26 10:37:46'),(414,'f39778103988f0d68d5c7ef0e28fc6bc','2017-01-26 10:40:45'),(415,'9fd5df949b6997dea6f88f07f41ef000','2017-01-26 10:41:35'),(416,'e710e9883a7b5172d2868c80d7df57ce','2017-01-26 10:46:13'),(417,'d7e3aac87990e68aa383c8c4e1656a72','2017-01-26 10:46:26'),(418,'ab6cebcc2623bbd62deaff8e4f4022dc','2017-01-26 10:47:09'),(419,'bf83402cfeae3b186dee993395bc067d','2017-01-26 10:47:34'),(420,'be2aaa01ef9f09fc75c0d29caf0b5991','2017-01-26 10:48:22'),(421,'9feed305d6f80afaa1c576c930ba9553','2017-01-26 10:50:10'),(422,'a3501c7ed714c487a46674b7f103ce73','2017-01-26 10:59:21'),(423,'7a6847796d12c7be5d7e8ba12330600c','2017-01-26 11:04:59'),(424,'c34c60aeee5cce0969ca6cb4247a3f75','2017-01-26 11:05:35'),(425,'b3c97ff0c07322ea4e2fc45aa5af6345','2017-01-26 11:06:08'),(426,'0c0a42a1a444f0c0d069902ac8c87b47','2017-01-26 11:06:38'),(427,'fde3d29046e9a2f5cf95f81caa9ddcaa','2017-01-26 11:06:49'),(428,'7fe60911d5d84f443cf4d12399423f31','2017-01-26 11:07:08'),(429,'eae7dbe58e84572ff07d60135998fb07','2017-01-26 11:08:24'),(430,'c6fcb2a7dfc02cc772ebfde871dd35e2','2017-01-26 11:09:20'),(431,'a218504e61b42b3f00f4e1e0f6f11471','2017-01-26 11:09:37'),(432,'07040162942d4c6c6d8d9a4324a6a11a','2017-01-26 11:10:15'),(433,'9df5703544c901ca465193b18fbe63a7','2017-01-26 11:10:34'),(434,'194e6e8874ebee5abd19adf96750f588','2017-01-26 11:11:19'),(435,'2e389ad0a5f6d43f2eb169630961d8b5','2017-01-26 11:12:03'),(436,'28859a679da7ebe37f2ce54cd382ef10','2017-01-26 11:13:27'),(437,'cfcdde1fcee3838a090764bf49164cb3','2017-01-26 11:22:09'),(438,'62e02644e11bb924b62b223699548298','2017-01-26 11:22:27'),(439,'d9f4d65d61125b68c2887abb9acbb242','2017-01-26 11:24:33'),(441,'0f4902ddebce7b97a8ca354a2e70dc8d','2017-01-26 11:27:08'),(442,'180fbee9fd51d0e45b39f23a4309c9b2','2017-01-26 11:27:30'),(443,'34a51016fe5e9850550d342c25ebc1f2','2017-01-26 11:30:47'),(444,'80e73c3e9829d09b7c84a17294a572c2','2017-01-26 11:32:14'),(445,'f9dbae1d4dd6437ac84d2df230a12e6c','2017-01-26 11:36:01'),(446,'4c1199ac131e50e0bd248c5aac7dc478','2017-01-26 11:36:55'),(447,'8cc53d1cd0b2779e8f7b06eef7995b63','2017-01-26 11:38:42'),(448,'17c25fc976e6363d9e8b189f99d8bd3e','2017-01-26 11:39:57'),(449,'ab5e9e47423a3afb9c6adb297c0ee518','2017-01-26 11:40:32'),(450,'1fc18bd7e1f0e38cb71b21cc71b709f2','2017-01-26 11:41:18'),(451,'1544a88526c757fbfab127b3274a2234','2017-01-26 11:42:18'),(452,'bef7f6d88dce761016e605028810d581','2017-01-26 11:43:37'),(453,'bf0698603417c6b4a2d132315b882dde','2017-01-26 11:44:13'),(454,'d9872bdb6a84b931ff2da0139efeb337','2017-01-26 11:45:47'),(455,'c7ddab495beec2e613ecfd247a42afee','2017-01-26 11:47:22'),(456,'9a7f0799e0ae98e279064627746a0957','2017-01-26 11:49:14'),(457,'28532a51f77bdb772792078ba7b073f6','2017-01-26 11:50:12'),(458,'6bfbd8fe44ae4ee9c417c4f40a597694','2017-01-26 11:50:42'),(459,'537f01d3d9828e24d1bd040c1488a79e','2017-01-26 11:51:05'),(460,'fd9a4bb38e6edddfb2195685f821007f','2017-01-26 11:51:57'),(461,'bd8bbbe24d293bf3775b4907cf76f4a3','2017-01-26 11:55:52'),(462,'f28e1fd33ebd54e3385c2b0dacdc3147','2017-01-26 11:56:23'),(463,'6af70f0b7f2bb099f910a4f22084d8d1','2017-01-26 11:58:56'),(465,'4b60abdf2fc5ba6d3c89e63a313a864b','2017-01-26 12:01:40'),(466,'401fa90b2dd513a94fff9f3d69cd007b','2017-01-26 12:02:22'),(467,'5ce481e97ca4a161726430695e098593','2017-01-26 12:02:40'),(468,'a1187112184e8c719c284382e640f2db','2017-01-26 12:03:46'),(469,'b815efb1504ded89d034b95e6ac9607d','2017-01-26 12:04:36'),(470,'d1d5646a929b8f33282399314fc55222','2017-01-26 12:18:56'),(471,'1338d2e2d6ac9504b9b057ba71d30af5','2017-01-26 12:19:16'),(472,'7e31e3c7289a13daf0c3a74b1ea575a6','2017-01-26 12:19:49'),(473,'06cfe4299e21271675516a448d0f2c9e','2017-01-26 12:20:25'),(474,'afbe8897a90541d57451a81930d83b3f','2017-01-26 12:20:32'),(475,'b91c2356d992bdbaf8308dcc568e9d8c','2017-01-26 12:20:35'),(477,'0000a448173d83beb9915e3c16642cd2','2017-01-26 12:22:32'),(478,'3ac33a723c64ef79fd8b9552b1752550','2017-01-26 12:23:21'),(479,'c4970751e0ce819329d6cc5b6cf029d6','2017-01-26 12:23:41'),(480,'ec7ca309038f6e65f7be2d87a17f09ce','2017-01-26 12:26:10'),(481,'190e4290e2d95f5fcaf4e763f2806d50','2017-01-26 12:26:54'),(482,'97cc386da6243eb984d267feb895acd7','2017-01-26 12:27:44'),(483,'36fff6a06f465447e537600c3c3ce4d5','2017-01-26 12:28:45'),(484,'fc14b98e2636452e3a07813894314eaf','2017-01-26 12:28:59'),(487,'f804ae0fa1c7feb70d1b108478938658','2017-01-26 12:31:03'),(488,'aff0a090bd646e36dcc5386ab8c8ca2f','2017-01-26 12:31:24'),(489,'db9ace5a66062d52eea154c996defbca','2017-01-26 12:32:33'),(490,'f862045958b5357433a65f282764d400','2017-01-26 12:33:30'),(491,'8b66b7d729418d6eaa3442ee041002f3','2017-01-26 12:33:47'),(492,'dbfa62826a4bf4a3d4f07d188071372d','2017-01-26 12:34:03'),(493,'728a729dbc35bed299b20b52a0dcefa2','2017-01-26 12:34:50'),(494,'31a43da024f6304a7e1716b96c8a9878','2017-01-26 12:35:03'),(495,'53d930aaea36040a4fa392dccdf2deb2','2017-01-26 12:36:35'),(496,'bebb992a8d397315006aec22423053e2','2017-01-26 12:37:13'),(497,'a81128f8c689e2cae25dc7a4f9237f04','2017-01-26 12:39:11'),(499,'7300f6bdb367191c13174275c95d5278','2017-02-08 15:41:20'),(501,'5a8e579fab2c689ebe4515327da037af','2017-02-08 15:41:49'),(502,'82d8caea434afb7f19ee5d7f37986625','2017-02-08 15:44:10'),(503,'022b35d5ab219de3154b4afbe2398a2d','2017-02-08 15:44:55'),(504,'0fb539e8b2ad8e4e51d1b074e4ba7e1e','2017-02-08 15:48:47'),(506,'d967d3b1ddc7090f63cb936587715de9','2017-02-08 15:56:44'),(507,'2cbbdd83a0f5b5ad07c33bf7e900f27a','2017-02-08 15:57:32'),(509,'725c1c53515b8b03d3a9830cf9ab44c7','2017-02-08 15:58:54'),(510,'69e52fca9227b2f3e41df52117dfd9cc','2017-02-08 15:59:13'),(511,'b29e41d1adbf769ad6c26707d7b921d4','2017-02-08 15:59:27'),(513,'b489c0ba85e33bb2646fa7eeffb76d1e','2017-02-08 16:00:58'),(514,'34b746fd43a33f00ebedf7766eee16d0','2017-02-08 16:01:33'),(515,'b17529154835a4554edfb1b1a66f15be','2017-02-08 16:02:49'),(516,'4a6665f83e5285a423bea27c07ba4bee','2017-02-13 16:02:49'),(517,'a5594ea7efa35ec5affc9418d77d4c19','2017-02-13 11:27:05'),(518,'06b1f256f35460bc5042672f9b2082c5','2017-02-13 11:27:56'),(519,'77f55cee113a2d8c6a66c6c200e1a958','2017-02-13 11:36:05'),(520,'aaa5e05d9f67f0ab0a57505c2b36d63f','2017-02-13 11:36:56'),(521,'e9b2add39845c52e0cefd0733fa7fafe','2017-02-13 11:37:48'),(522,'fe9bf56c715b1ec3053d6e3a4f21a54c','2017-02-13 11:38:45'),(523,'e4cca187013e6e58b5c86d920e9c3e6f','2017-02-13 11:42:07'),(524,'c61c57694ec3a0a3fb4edd9b31947e6f','2017-02-13 11:43:00'),(525,'7ad96370cf6397a0ae26354575dc0a47','2017-02-13 11:43:43'),(526,'0d785feeb18454a1ecce9a3c1da48cd7','2017-02-13 11:47:22'),(527,'38f3e19a35bc25d51b64baa807f1a560','2017-02-13 11:48:12'),(528,'68d52ebc30b2c7f76a0f3b176d726dff','2017-02-13 11:49:16'),(529,'4b91cce8a2bff2ecc5eeda95b3c3d309','2017-02-13 11:52:22'),(530,'d83023668e088dd228642cfcd2c35a46','2017-02-13 12:14:53'),(531,'1b1a47e6065a423b837d38a59137cd96','2017-02-13 12:16:27'),(532,'7e260276b35c91965fc076f0ad344d80','2017-02-13 12:17:02'),(533,'2d1432605d9ecb9959d3cdef3ff9079b','2017-02-13 12:18:07'),(534,'ce1f15b9a09de01c723e1a823265a11a','2017-02-13 13:04:07'),(535,'ddd7c7a4d7b68bd368d68413cadaefdb','2017-05-09 08:52:11'),(536,'d6092c8c4b7cc0be4a9eb66ff4b8d2a2','2017-05-09 09:05:03'),(537,'5a37f5278aa6278996135cc6c11a3913','2017-06-06 13:47:46'),(538,'8a5cb546af2c3ba6c178e67e07d37725','2017-06-06 13:48:49'),(548,'23df5150e451f25f1be22942a8cdf4bf','2017-07-05 12:52:05'),(549,'30aefba50db8d8e16c9da745285781e2','2017-07-05 12:54:12'),(550,'67cd3ff6f5deb053de97f4525a5d0ae4','2017-07-05 12:54:19'),(551,'d858339e9ed8d97c8c67fe3320721e1d','2017-07-05 12:54:28'),(554,'eb5446cff185d21f179af7d581e5f9b9','2017-07-05 12:54:57'),(555,'3e31fa644cd8f020332e50741df2f8d1','2017-07-05 12:55:13'),(556,'6f5054cafbba42f3a9edaaad93758a21','2017-07-05 12:55:18'),(558,'54ad56fea42f09c9c637506b69794000','2017-07-05 12:55:23'),(559,'06675a59ec059d1e3bc5bb253c93828a','2017-07-05 12:56:05'),(560,'f48f410e006a82e6c8d918a99dc8cfb6','2017-07-05 12:56:17'),(561,'1e8d23ab9dbd817ffe466c02ee8fa193','2017-07-05 12:56:31'),(562,'43a58e7735c05a261c65af230482717e','2017-07-05 12:56:39'),(564,'fd814bee6bf1fd6cce15b9df94bd0f3b','2017-07-05 12:56:59'),(566,'1b9a67759603f1db8f244c881e1bd641','2017-07-05 13:00:29'),(567,'4b49b5230d4fadce146ffccd9d8ba90c','2017-07-05 13:00:36'),(568,'9543d7dbb44cb2e58a62781cef218c90','2017-07-05 13:01:46'),(569,'750cf71136a786d7cd70e6a63788c189','2017-07-05 13:02:00'),(570,'94763dc177d6ca0a2fc92231d3812f3e','2017-07-05 13:02:13'),(571,'9fc858c00440c8cd5176eb37a02702d8','2017-07-05 13:02:31'),(572,'94dce1f45ca2fa10c9e16e6f8cd4b16a','2017-07-05 13:06:17'),(573,'4481cee50ea0022c8d81f2afd26c30f1','2017-07-05 13:07:51'),(574,'3fc67c17aa1158d6c109ecea2d6fe729','2017-07-05 13:08:03'),(575,'e316f13c625d2543b1eb766c28d0c157','2017-07-05 13:08:08'),(576,'aa97157f404d07f9ce79a79c4837d333','2017-07-05 13:09:16'),(577,'611dc4d675cdf1616bdceb99bfec4461','2017-07-05 13:09:30'),(578,'43f8d671b1e3a294fab5053866dcac29','2017-07-05 13:09:41'),(579,'8bf9e811ab9fe15792d846fbc2c8a68e','2017-07-05 13:09:52'),(580,'5ae459158982ad0abbe1c92475a1096a','2017-07-05 13:10:49'),(581,'3a2703ac0821b37204b0fc29cf0c170b','2017-07-05 13:10:56'),(583,'48efbfb72c861c8120065ce1446882fe','2017-07-05 13:11:16'),(584,'7bf4b5a06a9789e9e98c6c8615aa0549','2017-07-05 13:15:11'),(586,'5ea10832145203695cf0154b48b73133','2017-07-05 13:15:52'),(589,'d253e970cc7e289b2f7b2df6fb4a4f74','2017-07-06 08:56:39'),(590,'eee5be06b6ca633e1add863d7abfc594','2017-07-06 08:56:45'),(592,'d380cac2ffe152b8f10f7fa30ff07d4d','2017-07-06 08:57:34'),(593,'a6efd7e2bbd93a92ad425d5c91c73ca5','2017-07-06 08:57:48'),(594,'75ca171837cdc5fb56b0b93374aef805','2017-07-06 08:58:09'),(595,'6dd105f1b163fa54c908c719bacaa000','2017-07-06 09:00:47'),(596,'54e653b91fb5798608829a17b5e70835','2017-07-06 09:03:05'),(597,'485b06d79465cde5ccc1179c4d4d8c98','2017-07-06 09:03:30'),(598,'6b07cd4246b0c5079605e56be5e1be4d','2017-07-06 09:06:28'),(599,'c6f119e986ffc86df725e205cbb8f605','2017-07-06 09:06:57'),(600,'cde9712b4058394162255d516ec0e517','2017-07-06 09:08:37'),(601,'ec3faa9759676cf81666b55fcb877d37','2017-07-06 09:08:51'),(602,'63a4fcbd9227ede0571a8ed0b537051e','2017-07-06 09:09:32'),(603,'9fe5bc7f00f487d26c962efb7a674fa3','2017-07-06 09:11:37'),(604,'8cac8d6e7226b6d280dae772fe7adbaa','2017-07-06 09:12:17'),(605,'567d435a69f158fa2128d7235109b5e2','2017-07-06 09:12:41'),(606,'b440b824d22afc2f70bd6d4728820550','2017-07-06 09:14:28'),(607,'e0a944f65a520992b95cd2eeee196f99','2017-07-06 09:19:45'),(608,'8cc20ae608c8197d7a291e069f38d8ca','2017-07-06 09:19:53'),(609,'cde9d3b92be419a5d335b0f89124ee85','2017-07-06 09:20:12'),(610,'e2560a55bd56f2dabf96de681483f790','2017-07-06 09:21:07'),(611,'cc33c065cee66ecac07b96f31df4bcb0','2017-07-06 09:21:24'),(612,'4b93ec28664087f2f66a28ec225275d3','2017-07-06 09:23:43'),(613,'f8f223c4dcc71d7a996df7fce64a983c','2017-07-06 09:24:07'),(614,'02570f5b0502641844cf85ac757011e4','2017-07-06 09:25:11'),(615,'ea62b26b4990bcb91394dab9428340c7','2017-07-06 09:25:58'),(616,'591b90cbcb700f04cf9475e722a6a4f0','2017-07-06 09:26:13'),(617,'8115f7cec8fd7975fd8938ad448d6d2f','2017-07-06 09:27:14'),(618,'6b055025b25e1005e1976fdac1389f9c','2017-07-06 09:28:42'),(619,'e58d3c282d7bf80fef892ab59eb810af','2017-07-06 09:28:52'),(620,'8cee9522b67ca40f9dac4c7548411b85','2017-07-06 09:29:01'),(621,'19dfc09b913ff9b8b405d9d7a7e1854a','2017-07-06 09:30:40'),(622,'885b0e48c01af412d8cc86d1a6f0543c','2017-07-06 09:30:50'),(623,'66762f79999196b734ca951787646bf2','2017-07-06 09:31:48'),(624,'94ea8c0c7b1d575a0c61f4cd19dc25a9','2017-07-06 09:31:58'),(625,'dcc0fbe738a4dd1dbda8a4fec5b969a3','2017-07-06 09:32:07'),(626,'2dde85465f498bd7d3c47b8e1da74b24','2017-07-06 09:32:24'),(627,'8e27dcb92a9619279284b57e9b8c2627','2017-07-06 09:33:02'),(628,'2876995bfdbf3ba997724bb11cfd0b22','2017-07-06 09:33:12'),(629,'f44dbdb4981ce5ed8d79c02a5b2838cc','2017-07-06 09:47:00'),(630,'05d5d2ebb0498a8ea59a012fec851d95','2017-07-06 09:50:33'),(631,'3c1e78eea482141a8329ba9876fe3fcd','2017-07-06 09:50:44'),(632,'d57191a64a7f6d0c63eff55a0bad72cb','2017-07-06 09:51:57'),(633,'04c6929dd77f197c1c0c597555c14462','2017-07-06 09:52:36'),(634,'f9112da9cf7dfeeea5173f848973b8ef','2017-07-06 09:52:50'),(635,'de7808312d3572d5e9354ed3d8b38025','2017-07-06 10:01:59'),(636,'623c37bd04cbe1a13e488f788ba105af','2017-07-06 10:02:34'),(637,'70c3a17e1d7b0c553a53e7f711a62d4b','2017-07-06 10:03:29'),(638,'305a2560d11e3bbdbf57ba92b1333f76','2017-07-06 10:03:40'),(639,'dbef78a09a3f699a4b2a565291fe7376','2017-07-06 10:03:43'),(640,'eeb215cf52abe28108ca5b5c622e3b5e','2017-07-06 10:15:59'),(641,'432e2d7b837133910ade2d47d2b044cf','2017-07-06 10:16:00'),(642,'9a27328f75458f4dc68f9bfa30ad0e92','2017-07-06 10:20:22'),(643,'cf01dc0c90151e65dfd6f9f927ae85e8','2017-07-06 10:21:56'),(644,'7c318fbc259d926a6c7d3ab2cfe6357e','2017-07-06 10:22:26'),(645,'b40836772f58f0a296a1c7c79d20337c','2017-07-06 10:25:41'),(646,'0cfc40e76eff73271360a6d010f6ca0c','2017-07-06 10:25:45'),(647,'528007d73589ab7193401429ebef362a','2017-07-06 10:26:33'),(648,'19beb34a654297345ec3689320d31b23','2017-07-06 10:28:39'),(649,'194adced6bfbc72485cce8e2a6b930a6','2017-07-06 10:28:47'),(650,'89a0ec615516137124b659422bd7e0f1','2017-07-06 10:29:04'),(651,'537696cd418f913bef73a5fc2e04dddc','2017-07-06 10:29:34'),(652,'91cd013d08f77974313b82667e30c989','2017-07-06 10:31:52'),(653,'532f9f02e7cfe24e0be427b23efd7e52','2017-07-06 10:33:24'),(654,'4788a7ca7bf074ac844c37d0b471c2df','2017-07-06 10:33:36'),(655,'818b12b04d84536b8c35abe06e35f5ca','2017-07-06 10:35:34'),(656,'04d350e09f56f6a30505d39ab6de0289','2017-07-06 10:39:05'),(657,'4ee6c52e9e93b00514d0b982f44e09ea','2017-07-06 10:41:36'),(658,'2d38d4b18fc8c8b783bcb8122d60ca73','2017-07-06 10:42:25'),(659,'17e2610b89ee931cf4efdff32061699d','2017-07-06 10:42:36'),(660,'027e34d2d66d453cc904592d83223f9b','2017-07-06 10:43:11'),(661,'125738ae398d9fdda97390b60cf59dd1','2017-07-06 10:44:01'),(662,'9add9dba5d662e657504f566a63984bb','2017-07-06 10:45:55'),(664,'21575d759928c42ca6460775f6309b9d','2017-07-06 10:47:21'),(665,'f427bb10e1332834cf775c5c06302564','2017-07-06 10:52:05'),(666,'5c851525925d496f5b7d7e19c4ead200','2017-07-06 10:52:27'),(667,'dfe222484c5d17dcc596091b5b5570ea','2017-07-06 10:52:41'),(668,'2363dcd45112ca1093986b64f55a9397','2017-07-06 10:53:04'),(669,'f993d1bed886e002db664af345a3df79','2017-07-06 10:53:27'),(670,'1629700240028d79a9e65ba3e5f3ab8b','2017-07-06 10:54:19'),(671,'a88fb58611d35a4d5195aeda15a06310','2017-07-06 10:54:41'),(672,'f063b8d8fa87f388624e212e5ee05fac','2017-07-06 10:57:29'),(673,'87de76625545ea76d300ae0152b4dfca','2017-07-06 10:58:37'),(674,'ecfa2e8d0e56b6c6a944f43d55958153','2017-07-06 11:13:23'),(675,'425b6f2111db1fd6f1031418322422e0','2017-07-06 11:14:32'),(676,'fe097b6a0f671b9cfe3b1e0ccc07b021','2017-07-06 11:14:33'),(677,'547e65ad8a759324df2721d00bca5339','2017-07-06 11:15:59'),(678,'69b13550c8a707959fc6cbe089c675f5','2017-07-06 11:17:01'),(679,'597ce24fda4c19abcea47b0f842fac14','2017-07-06 11:17:05'),(680,'17470bedb8f1b662f7163793797a9336','2017-07-06 11:41:09'),(683,'cebae3b7b2847fe68dc6fc55462bca40','2018-01-05 12:22:00'),(684,'f769ace648694156aa773f09fbd8b89b','2018-01-05 12:22:10'),(685,'7d8dee38e1cdce250d06253388870bde','2018-01-05 12:22:43'),(686,'3ea66f3a5619aa94238618b331b09484','2018-01-05 12:23:51'),(687,'702fe4117db1f341337c9d62da09b01a','2018-01-05 12:31:09'),(688,'991693dd94abf47bc354096d734545b6','2018-01-05 12:34:43'),(692,'0ae544133b2efd5a09ed0d96ad1e62b3','2018-01-05 13:55:58'),(693,'f3c772ff2891fe3362efe2eba0661297','2018-01-05 14:02:29'),(695,'e6b3f54ade88505fe842edacc37a4a31','2018-01-05 14:09:23'),(696,'00e736561fe164f751504d4c8f6e4141','2018-01-05 14:10:19'),(697,'6d5b06e01757143c7c30121acc9e2949','2018-01-05 14:20:08'),(698,'a039aa4f6ecfe6814fe79e379aeeff01','2018-01-05 14:20:09'),(699,'6f3fe219f8a36c178f2355da96a8cb8c','2018-01-05 14:25:49'),(700,'320fb63797e27b066b6c064309f20f75','2018-01-05 14:26:10'),(701,'c4afc5ee3c133446430ec10742caa6c4','2018-01-05 14:27:22'),(702,'91898f029c94a5eb8e905ca84f050a75','2018-01-05 14:28:06'),(703,'88cd67642182feeb76a8f30a6787630b','2018-01-05 14:29:22'),(704,'fdc1ced1681ba52c4b0be41d9bee2967','2018-01-05 14:47:20'),(705,'c12ad767468a3430ff18129c26923bc3','2018-01-05 14:48:34'),(706,'8f8573b4e24c1e3a48fb989f1051a726','2018-01-05 14:49:14'),(707,'1b0607cf5f0ca1eb7e2507ed93ef5416','2018-01-05 14:51:45'),(708,'957deb77b035ffc85cd2a58c761db538','2018-01-05 14:54:47'),(709,'e1493ab02e02fdd499795383a697f9d9','2018-01-05 15:03:26'),(710,'a7c7ce69e640ce13b61c922d658406d0','2018-01-05 15:05:10'),(711,'842a8b13eea3dcae5539150fedd6ba8f','2018-01-05 15:06:19'),(712,'e4e4c5539db65b9ad9a5dfd3b98b4362','2018-01-05 15:06:40'),(713,'d09d211f53db7cf172c62af4e306433f','2018-01-05 15:08:34'),(714,'17447f325e70e7de100a419bec535771','2018-01-05 15:10:00'),(715,'47072b25f7c1e2dc83e09736908c78cc','2018-01-05 15:14:11'),(716,'b6cd7262b450f43bf3059e84abde492c','2018-01-05 15:23:07'),(718,'cfe8f3e3ebf50fc1d2225372ed97274e','2018-01-05 15:28:37'),(719,'e189d41d7cabd19bd4eb132d4dd48ec2','2018-01-05 15:30:56'),(720,'b96910a165bcf9ebdda53793788174af','2018-01-05 15:38:24'),(727,'2a60354df5007ad16311c5ca4742abdd','2018-01-05 16:07:11'),(728,'86bf4df40323912839fecd20ccdf0322','2018-01-05 16:12:15'),(729,'265d1a2bd9c1b3d5ba37b510139bf66b','2018-01-05 16:12:29'),(730,'35a41d51577e9412258cc7ea192139d7','2018-01-05 16:18:32'),(731,'0e5f68acd1d9febd140b93e089a036dc','2018-01-05 16:20:54'),(732,'c8c69d4bbc3d11f0f9ff40ddab3c3c12','2018-01-05 16:22:02'),(733,'00344d6ecfaa15b68dc51196c1ef6e7d','2018-01-05 16:22:36'),(734,'b4a71de3253bacbb6b6a67201f9d1275','2018-01-05 16:30:33'),(735,'d36f6b84b2fd36f9620954b239ea956f','2018-01-05 16:30:49'),(736,'02af052eee0699b3b359668bcd6dd76e','2018-01-05 16:31:02'),(737,'548e2e8d1b0f23f8b7cbd7ff3648b271','2018-01-05 16:31:27'),(738,'e10fb0e765587c8a250a60aed5a92bef','2018-01-05 16:33:58'),(739,'096245c08c2034a40ad1fe96004b8f63','2018-01-05 16:34:20'),(740,'d1c929111ad156415f21cc498a73828c','2018-01-05 16:34:52'),(741,'2d155dd0f8c2ad22bf716a790c53bea2','2018-01-05 16:35:32'),(742,'fe549e5b400a8b71d0e96282d7608eb8','2018-01-05 16:36:40'),(743,'52dd861bd24fad0310e2317901feb8b5','2018-01-05 16:38:25'),(744,'8200c2816fcee022cffb0f786812e374','2018-01-05 16:40:04'),(745,'dfacf6a8b21291d072a5f84eaf29f400','2018-01-05 16:45:50'),(746,'a5a8080234497c3b3a226bdef3082c15','2018-01-05 16:46:38'),(747,'836c889c6b75e944e470514f6703eea4','2018-01-05 16:46:51'),(748,'e4fd47c2fd98b8e557cff40ea9caf66a','2018-01-05 16:47:02'),(749,'85568dd852103d0c588e7e8f8f8825b7','2018-01-05 16:48:56'),(750,'83fa8396b360e8f100d7a48d6a0395eb','2018-01-05 16:54:25'),(751,'436f9495b13f19cebede6c8cfd318849','2018-01-05 16:54:43'),(752,'40335ba22511da1d23cc9d25602ab894','2018-01-05 16:56:00'),(753,'35a9a2117cae77c4f86d873076142a5a','2018-01-05 16:57:57'),(754,'200876aedf7348e39f958e1a1eccb40f','2018-01-05 16:59:23'),(755,'4cf90fd2b1b92f020ceeb4a46a30d81c','2018-01-05 17:03:14'),(756,'dd9bf5fc70018fa7cf0069edf8717f4b','2018-01-05 17:03:24'),(757,'18e4f1788626e8657bc2d7feec09d606','2018-01-05 17:04:32'),(758,'87ca63eb997ab54bc3c6e7b842a31893','2018-01-05 17:06:23'),(759,'2e4f72a58e87c75d5397d5d3682c8fa6','2018-01-05 17:06:23'),(760,'418c01ae8705bc6f2203262d0edebed2','2018-02-08 12:44:52'),(761,'fe35265968c4dd2f7957984dba4c3905','2018-02-08 12:45:17'),(762,'048d1c91f32cf037ef51eb1ab46eaf34','2018-02-08 12:48:35'),(763,'c4e76e1a92c34f47f764cbb859708ac4','2018-02-08 12:52:17'),(764,'b830dcdb6ddde8396f1eeedfba15a2ac','2018-02-08 12:54:01'),(765,'11990578a31e06ede982965d779eb3c4','2018-02-08 12:54:44');
725/*!40000 ALTER TABLE `listanegra_producao` ENABLE KEYS */;
726UNLOCK TABLES;
727
728--
729-- Table structure for table `livro`
730--
731
732DROP TABLE IF EXISTS `livro`;
733/*!40101 SET @saved_cs_client     = @@character_set_client */;
734/*!40101 SET character_set_client = utf8 */;
735CREATE TABLE `livro` (
736  `id` int(11) NOT NULL AUTO_INCREMENT,
737  `producaoBibliograficaID` int(11) NOT NULL,
738  `tipo` varchar(128) NOT NULL,
739  `natureza` varchar(255) NOT NULL,
740  `isbn` varchar(13) DEFAULT '',
741  `numeroVolumes` varchar(5) DEFAULT NULL COMMENT 'Número de volumes',
742  `numeroPaginas` varchar(5) DEFAULT NULL COMMENT 'Número de páginas',
743  `numeroEdicaoRevisao` varchar(5) DEFAULT NULL COMMENT 'Número da edição',
744  `numeroSerie` varchar(5) DEFAULT NULL COMMENT 'Número da série',
745  `cidadeEditora` varchar(30) DEFAULT NULL COMMENT 'Cidade da editora',
746  `nomeEditora` varchar(100) DEFAULT NULL COMMENT 'Nome da Editora',
747  PRIMARY KEY (`id`,`producaoBibliograficaID`),
748  KEY `fk_livro_producao_bibliografica_idx` (`producaoBibliograficaID`),
749  CONSTRAINT `fk_livro_producao_bibliografica` FOREIGN KEY (`producaoBibliograficaID`) REFERENCES `producao_bibliografica` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
750) ENGINE=InnoDB DEFAULT CHARSET=utf8;
751/*!40101 SET character_set_client = @saved_cs_client */;
752
753--
754-- Dumping data for table `livro`
755--
756
757LOCK TABLES `livro` WRITE;
758/*!40000 ALTER TABLE `livro` DISABLE KEYS */;
759/*!40000 ALTER TABLE `livro` ENABLE KEYS */;
760UNLOCK TABLES;
761
762--
763-- Table structure for table `membro_corpo_editorial`
764--
765
766DROP TABLE IF EXISTS `membro_corpo_editorial`;
767/*!40101 SET @saved_cs_client     = @@character_set_client */;
768/*!40101 SET character_set_client = utf8 */;
769CREATE TABLE `membro_corpo_editorial` (
770  `id` int(11) NOT NULL AUTO_INCREMENT,
771  `pessoaID` int(11) NOT NULL,
772  `periodico` varchar(255) NOT NULL,
773  `mesInicio` int(2) DEFAULT NULL,
774  `anoInicio` int(4) DEFAULT NULL,
775  `mesFim` int(2) DEFAULT NULL,
776  `anoFim` int(4) DEFAULT NULL,
777  PRIMARY KEY (`id`),
778  KEY `idrevisor_periodicopessoa1_idx` (`pessoaID`),
779  CONSTRAINT `idrevisor_periodicopessoa10` FOREIGN KEY (`pessoaID`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
780) ENGINE=InnoDB DEFAULT CHARSET=utf8;
781/*!40101 SET character_set_client = @saved_cs_client */;
782
783--
784-- Dumping data for table `membro_corpo_editorial`
785--
786
787LOCK TABLES `membro_corpo_editorial` WRITE;
788/*!40000 ALTER TABLE `membro_corpo_editorial` DISABLE KEYS */;
789/*!40000 ALTER TABLE `membro_corpo_editorial` ENABLE KEYS */;
790UNLOCK TABLES;
791
792--
793-- Table structure for table `nome_citacao`
794--
795
796DROP TABLE IF EXISTS `nome_citacao`;
797/*!40101 SET @saved_cs_client     = @@character_set_client */;
798/*!40101 SET character_set_client = utf8 */;
799CREATE TABLE `nome_citacao` (
800  `id` int(11) NOT NULL AUTO_INCREMENT,
801  `pessoaID` int(11) NOT NULL,
802  `nome` varchar(64) NOT NULL,
803  `hash` varchar(32) NOT NULL,
804  PRIMARY KEY (`id`),
805  KEY `nome_citacaopessoaID1_idx` (`pessoaID`),
806  CONSTRAINT `nome_citacaopessoaID1` FOREIGN KEY (`pessoaID`) REFERENCES `pessoa` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
807) ENGINE=InnoDB AUTO_INCREMENT=10129 DEFAULT CHARSET=utf8;
808/*!40101 SET character_set_client = @saved_cs_client */;
809
810--
811-- Dumping data for table `nome_citacao`
812--
813
814LOCK TABLES `nome_citacao` WRITE;
815/*!40000 ALTER TABLE `nome_citacao` DISABLE KEYS */;
816INSERT INTO `nome_citacao` VALUES (177,332,'RODRIGUES, J. A. G. A. F.','04e7ee1f2652f2b5e0833f5149aaaea3'),(248,260,'MORAIS, R.','ae9352f1d339878f1202ccb16287a3f3'),(382,376,'RADEMAKER, A','06118a08b77ddb84aad6051ffdde11e7'),(383,376,'RADEMAKER, A.','63ba5614f0801dc210dd3b5156fa6bbd'),(384,376,'Rademaker, Alexandre','580568bd21ed3e6aaecbd242b3bc9d36'),(386,377,'SARMENTO, C. E. B.','5e1881621ff71423d868bc254f8c2c56'),(393,380,'KOILLER, Jair','4f41feec7f8d2b1be3017af1e8019cc7'),(395,382,'MAIA, J. M. E.','a7d8cf55ac91360d0bbc81e4137a335c'),(396,382,'Maia, João Marcelo','0d6a5a39dbc6189fd8eb242cf547239c'),(397,382,'Ehlert Maia, J. M.','16a24ff9210c78a0cab833f2ebf490e1'),(398,383,'O\'DONNELL, J. G.','8b8cd03eb353a5f6b8b1cf4c3f72a434'),(408,388,'SOCHACZEWSKI, Monique','aff6e99ff0d2890a6e96f99932ed857f'),(411,390,'FONSECA, Richard','d284e4acdd78c323eb8a9daf42d333c1'),(414,392,'Durães, S. M.','a74b9200ac9ff324c10a8e9ca77c0ba3'),(455,224,'SILVA, Andre Luiz Carvalhal da','b7f7a99083bbe915e8c94d9de6ea326a'),(456,251,'SIMONASSI, A. G.','8fa8003a22119eb5384fc14a3167060b'),(466,254,'VARGA, G.','bcce51a0e1e7fb5263dbaf699e41d747'),(476,236,'DIAS, M. A. G.','e58885a12bb5b17fb6889eeec293d4e1'),(492,256,'SILVEIRA, M. A. C.','bf646ef441dcaf0e14628c784c81e58a'),(508,394,'HERNANDEZ PEREZ, A. A.','dd62dd3ad22c14c46af7e44c2f6dd664'),(509,394,'PEREZ, Adriana Azevedo Hernandez','9e3ad2e7543385e1dfb2b24c1d744b03'),(510,394,'HERNANDEZ PEREZ, Adriana Azevedo','a15ccd3ecbda45bf1d3cd540d02346d3'),(511,227,'MATOS, João Manuel Amaro de','eca6f32a509a7c174636544552329041'),(512,227,'MATOS, J. M. A. de','7c382682c626740a48180e06188288a5'),(513,227,'MATOS, João Manuel Gonçalves Amaro de','37c072c643ab0484079a9c0b8317b28f'),(568,7,'PUPATO, Germán','189a23cd1c325d7ceea55d4c576317fe'),(720,7,'PUPATO, Germán Pablo','18136f92b17194ba26cc203b342fe6af'),(721,7,'PUPATO, G. P.','ea1dedf607b67d79f01ebe2e2b9fae5e'),(740,224,'SILVA, A. L. C.','52bb7d714fb1995cb39e7ff1b702b703'),(742,227,'MATOS, J. M. G. A.','7a1c51cb9781cb7011a60cb3ae22bd0f'),(749,236,'DIAS, Marco Antonio Guimarães','f5aa955db6e1883ac085ab9037cd4c55'),(751,251,'SIMONASSI, Andrei Gomes','dbe9eb916574166d469855e964641a28'),(756,256,'SILVEIRA, Marcos Antonio Coutinho da','b7487697822654f72d2aa2cc0d2f0546'),(758,260,'MORAIS, Rafael Pinho de','8227ed2b393e169f32ef3efde73c6aad'),(759,260,'MORAIS, R. P.','6699271afdba6d76ad4ed6f7529231f4'),(826,377,'SARMENTO, Carlos Eduardo Barbosa','1ed15cd64dc705cd58c6724d20cdc238'),(830,382,'MAIA, J. M.','a582cd401ff326d240179dfad891123f'),(831,383,'O\'DONNELL, Julia Galli','100ac8ea18a39dd0890668a00b63983c'),(834,388,'GOLDFELD, Monique Sochaczewski','0e58941006ec3aff84be701d8090ad89'),(835,388,'GOLDFELD, M. S.','5370811c2d34d777e592f2a22fd1a94c'),(839,394,'PEREZ, A. A. H.','9bf67364387456d86ab0075ed7f3c1ef'),(853,124,'TERRA, M. C. T.','0ec7dc8b71257ab2ba09bd69cf5c7c2d'),(854,124,'Terra, Cristina','71def3c64fca787740b4326b597376bd'),(855,124,'TERRA, Maria Cristina Trindade','36f3a575a06c419e1a8745e09785a0e3'),(933,237,'LEAL, R. P. C.','9102e206e83740a7640aa2f6ab143b01'),(934,237,'Leal, Ricardo','8134a9ec67a1f3d009295a7fb2e9123f'),(935,237,'Leal, Ricardo Pereira Camara','e4a43ae4de0ed71bc570195452e4ac6c'),(936,237,'Leal, Ricardo P C','1c5f8e745832a59eb3a78d52d145e996'),(937,237,'Leal, Ricardo Pereira Câmara','e4a43ae4de0ed71bc570195452e4ac6c'),(938,237,'Leal, Ricardo P. Câmara','fba12aa6c1ed51253163be947f42861a'),(939,109,'PESSÔA, S. A.','0022d162544982d40c5eb778fa283c27'),(940,109,'PESSÔA, SAMUEL','2a0df97b1c49e032734d27751da6ebf3'),(941,109,'PESSÔA, Samuel de Abreu','493df52410c8dc8abd66729ee8ec826d'),(1311,378,'WAGNER, E.','46f4fd367293dec363c519258ddfefe7'),(1312,378,'WAGNER, Eduardo','8c9754f54f814937c230697cd28d6b45'),(1534,622,'FERNANDEZ, R. G.','b0b5030644b48e705fd7de4e3d5bb3c8'),(1535,622,'FERNANDEZ, Ramon Vicente Garcia','238614d5b122d4332c8cdd9f5ce9e546'),(1536,622,'FERNANDEZ, R. V. G.','7504ddb08484ac543fff64cfccbec284'),(1570,630,'Aldrighi, Dante Mendes','ee049294db0a265c4de8b7b178a6c2c4'),(1571,630,'ALDRIGHI, D. M.','a600645eb71cadde2f94d548c8a3e183'),(3551,1152,'FIGUEIRÊDO, L.','433dcd9ab6db5e90fc1fa9be4cf2ed85'),(3552,1152,'FIGUEIRÊDO, Lízia de','fd964c7f7c5a1f4699e2d2de662b7730'),(4148,1361,'SIMONSEN, A. A.','65d5b4a31b3c04ebeadafe280e81e579'),(4149,1361,'SIMONSEN, Axel Andre','2d95f2bef0ed3e954b2487c3edb04603'),(4150,1362,'AZEVEDO, Rafael Moura','5a05622c4d3c5e896a2fe3e6cd150002'),(4151,1362,'AZEVEDO, R. M.','7096ca888ca5402cea99e42f17dc7a1b'),(4163,1364,'FERREIRA, R. V. X.','3f6dd36b19d8a500ee6ff7d931651efb'),(4164,1364,'FERREIRA, Rafael de Vasconcelos Xavier','b135c4a9d2045dfe4c234d8ead124110'),(4490,1406,'HOLLANDA, L.','a6061ab7d37ac81754ab0d82560b52ba'),(4491,1406,'HOLLANDA, Lavinia Rocha de','117bb0a338be210edefd9b62af967196'),(4492,1406,'HOLLANDA, L. R.','4b0cc845f211d1c03b2b02ab1c91198c'),(4733,1412,'VEIGA, Felipe Berocan','6856058e1bc4d18dae571ebac83e6f4f'),(4734,1412,'VEIGA, F. Berocan','b7d8f04cd8ae00e047dcddd78758e331'),(4735,1412,'VEIGA, F. B.','794a8003e42c5540800fac0f3a7ceb88'),(4738,1414,'LEVY, Joaquim Vieira Ferreira','980aa25c5b9aaaed78b368f127dd4000'),(4739,1414,'LEVY, Joaquim','4ab9d93980df0edcc31ca8a37e6c419f'),(4740,1414,'LEVY, J. V. F.','89a403b9f802bdde170e90c78a500495'),(5242,1366,'SBICCA, Adriana','4ec21ef276183e0a9725ac9d43272f30'),(5243,1366,'FERNANDES, Adriana Sbicca','4a4a0b3b99787b230be864acd686fafd'),(5244,1366,'FERNANDES, A. S.','36e92078045c19334ccd276e3b5bda8d'),(5309,335,'CARVALHO, Maria Gabriela C.','9b909848844422c78359151f2cd161cb'),(5310,335,'Carvalho, Gabriela','528ccac2402e914bae028eb26db10fd3'),(5311,335,'CARVALHO, Maria Gabriela Carneiro de','60bbe9e13a879a92f05bb463dad79d0f'),(5312,335,'CARVALHO, M. G. C.','4d77df5e0ef54957113f148784b9bf26'),(5587,1153,'CROCCO, M.','ae66e4a884448953845396d0d1a90ece'),(5588,1153,'AFONSO, Marco Aurelio Crocco','ebd7735b6d3ef002ec3cb1792b31990e'),(5589,1153,'AFONSO, M. A. C.','b32e4a8a82789fe1305ed4396eda35bf'),(5606,1156,'SIMÕES, R.','422b7b14ca073b0bf30319f467cefe5b'),(5607,1156,'SIMÕES, Rodrigo Ferreira','6468e235bd77854e1a96291a5f10438f'),(5608,1156,'SIMÕES, R. F.','d60c490bf8bdf5a6a05cded43d1759c0'),(5828,467,'MADUREIRA, Alexandre L.','f2ea5ab33928265c5be85cf1a3ce2769'),(5829,467,'MADUREIRA, A. L.','6fb7422c6d57a0e4ed5fed4470cc3968'),(5830,467,'MADUREIRA, Alexandre Loureiro','8e01f647cb61422e2cc86043e637dd83'),(5834,252,'Polydoro, Angelo','9d43b9a1bc5fcbbd32d7197f0971b9b3'),(5835,252,'POLYDORO, Angelo Luiz Rocha','cac4b6528e3f5cb8923ec3c54d642a29'),(5836,252,'POLYDORO, A. L. R.','6a0bcac18b23c26e6ce36e029271ed0f'),(5944,1434,'DIAS, V. P.','1a834a5fe87891a9efdda390a2c16b73'),(5945,1434,'DIAS, Victor Pina','bcbf4ee27e8331695af7561f28453397'),(7615,1339,'PAULA NETO, A. N.','a7251e26ef5afc9c8e5d5d1da4b5aa10'),(7616,1339,'DE PAULA, ÁUREO','1d3f837511e589acf66489beafd6630a'),(7617,1339,'PAULA NETO, Aureo Nilo de','5390b8819680cf77406684efa82b4d4d'),(7640,645,'CACCIAMALI, M. C.','3730855f147e8b71f7c24b9b4880c02d'),(7641,645,'CACCIAMALI, Maria Cristina','4752d888b00f8688c5ae26bbc492da00'),(7673,644,'TURCHICK, D.','2d2c5e127d9eb498f2f310099073e77e'),(7674,644,'Turchick, David','72e1c20311def739cd2dc193fcfacc92'),(7675,644,'RUBIN, David Daniel Turchick','d1c7a247416ba8383e1cde54d1cf92d2'),(7676,644,'RUBIN, D. D. T.','69db3952bbf345b412dd42107bee62e4'),(7681,1417,'SOROMENHO, J. E. C.','8b0075857dc122f7433709cfdb350763'),(7682,1417,'SOROMENHO, Jorge Eduardo de Castro','455fcef2803707742e1ee8e3f1f2b944'),(7683,1418,'CHIAPPIN, J.R.N.','83aa17b292a26fae9152e030fe7228bc'),(7684,1418,'CHIAPPIN, Jose Raymundo Novaes','79a0689f9a1664becd6aeb22a954691c'),(7685,637,'RANGEL, M. A.','96d973e15f3de29bcf56647292c52de7'),(7686,637,'RANGEL, Marcos de Almeida','89ff71bcb8c42be6e7023fb976b16520'),(7696,1415,'MADEIRA, R. A.','14b43a06cebcec5a04619e7b44ecd1c9'),(7697,1415,'MADEIRA, Ricardo de Abreu','e470832b47afd0f741ad8859393dae72'),(7700,655,'WERNECK, R. L. F.','57dfd14c128fbf7e7362a1c6fa00e299'),(7701,655,'WERNECK, Rogério Ladeira Furquim','e083a7f57bd86172620e7a64151f180a'),(7702,1420,'Pedro CL Souza','806a004345e859e202ad18fa6f2fad28'),(7703,1420,'SOUZA, P. C. L.','ae573044673d7bdbe12151257eed5c56'),(7704,1349,'ROCHA, Bruno de  Paula.','ee32a5ce90e5092c5c284890920e871e'),(7705,1349,'ROCHA, Bruno de Paula','532f4ca69553ee4ea6bb8cafaa02e4d8'),(7706,1349,'ROCHA, B. P.','3abb3e687afc69a39257e73dc2e5f07a'),(7716,1426,'GERMER, C. M.','6a7ee726a9f0a1fbf1a3cca9861ba03b'),(7717,1426,'GERMER, Claus Magno','0b1955a0592dbe1f02de076c8a407d64'),(7726,1136,'SAMPAIO, A. V.','9fa51c7d4a540f41e8887bdc3788ca00'),(7727,1136,'SAMPAIO, ARMANDO VAZ','ff1b4353eb18e21f76be49ffa6a068bf'),(7730,1115,'Maurício Barata de Paula Pinto','56a81837b997ab1a1a0865126dbbbf7c'),(7731,1115,'Maurício B. P. Pinto','adf48d8e6005382d0fca9bd0dfecb673'),(7732,1115,'Maurício de Paula Pinto','9c8759ffc139e0ba2992485576f7cc77'),(7733,1115,'M. B. P. Pinto','9167474f3a03cea07832eb7af304dca4'),(7734,1115,'PINTO, Mauricio Barata de Paula','ca98656a2bfdcae1c753e081c3dd8136'),(7735,1115,'PINTO, M. B. P.','bba3f6869810245469239a65a64af430'),(7772,1131,'ANDRADE, R. P. de','ff58ad58a1259d99cc18aeb5cb8f7355'),(7773,1131,'ANDRADE, Rogerio Pereira de','c63bba24426e9ba49060278966bb25a3'),(7774,1131,'ANDRADE, R. P.','1ef13f9bd7dfca874b65400498aba2f8'),(7778,1124,'SILVA, A. C. M. E.','a6fdf33524d3a7e43f493662fd95a13d'),(7779,1124,'SILVA, Antonio Carlos Macedo e','eef9ad5c9bc0d3290c35350d2862a5ab'),(7780,1124,'SILVA, A. C. M.','64e302cad26f3e8fb61e79e7971ba4a3'),(7977,1416,'COSTA LIMA, R. C.','77631977c738438dee19cb11387a4582'),(7978,1416,'Lima, Rafael Costa','04b4decab14d8aeabf140bb9db618ede'),(7979,1416,'COSTA LIMA, Rafael Coutinho','77bbd3fbd3b305dcf6c41257d053b6e1'),(7980,1416,'LIMA, Rafael Coutinho Costa','693ed80ca51d722487bd0a23f653b972'),(7997,1770,'Linhares, Alexandre','919829c05909c229d08ac40336e21fe0'),(7998,1770,'LINHARES, A.','b3061f4c208ea6769b4d06f1cad2aeb1'),(7999,1770,'Linhares, A','a7ba44670364aa3ecc846262ecebee90'),(8015,1773,'ZOUAIN, D. M.','7ae32aea445e30b7cda5de8048a4f12c'),(8016,1773,'ZOUAIN, Deborah Moraes','126425e4de378ede83096cded2bd311c'),(8017,1773,'ZOUAIN, DEBORAH MORAES','126425e4de378ede83096cded2bd311c'),(8018,1773,'ZOUAIN, DEBORAH M.','b1aff1b13253836d9bebf4e80109543a'),(8019,1773,'MORAES ZOUAIN, DEBORAH','2fbac03e423458ea87818114a529407f'),(8080,1784,'MOTTA, P. R. M.','dfe21281ad31d1b23575f223d2475bf6'),(8081,1784,'MOTTA, Paulo Roberto de Mendonca','f23f62242e379fa8c69a14a15b38b48f'),(8082,1784,'MOTTA, P. R.','aa4fe818683a5ef440ef42dc626ec73d'),(8083,1784,'MOTTA, Paulo Roberto','eddd80bbba59dc38c72b44d738089920'),(8084,1784,'MOTTA, Paulo Roberto de Mendonça','f23f62242e379fa8c69a14a15b38b48f'),(8123,1786,'CARDOSO, R. L.','575a28ec4c363113d82efbfe4f885bfe'),(8124,1786,'CARDOSO, Ricardo Lopes','b1ae4119673af78ecf7057b59c63fb6b'),(8146,628,'GONÇALVES, Carlos Eduardo Soares','6d3dab6897051fd2d8f4ad6ff09bd1e6'),(8147,628,'GONÇALVES, C. E. S.','1ee9749619c7a1368ee81dacdd56a774'),(8148,633,'KANCZUK, F.','ad91c3e07b2b7aa17f0473a19a85f421'),(8149,633,'KANCZUK, Fabio','0b4d547dba6c5b29fe677cc46d9ec311'),(8150,1345,'MADEIRA, G. A.','2c9976fe31be7387f1a90f66386ee722'),(8151,1345,'MADEIRA, GABRIEL A.','2856b7c39fdd81edddfb3e99af6e7302'),(8152,1345,'MADEIRA, Gabriel de Abreu','44ccd3d0d8f6a8b46ea9736646924dfa'),(8156,642,'COLISTETE, R.P.','56c09f8223eb86c7048778df97a02e32'),(8157,642,'COLISTETE, Renato Perim','dddb680f07962682b73e892a2b9b4dc6'),(8158,642,'COLISTETE, R. P.','32a4daff06184f0b0ab8eab259a8d013'),(8159,1348,'BUENO, Rodrigo de Losso da Silveira','4e3f8dc676832e69ba72b43a8301152b'),(8160,1348,'DE-LOSSO, Rodrigo','c9383a12953a29422db11a8dd1e6f43b'),(8161,1348,'BUENO, R. L. S.','5633c6e2cf50d77a8073dbd5aec72c02'),(8190,1797,'MARTINS, B. S.','df9885053634126671bd134ea0afacde'),(8191,1797,'MARTINS, BRUNO','65be8f4e024cc2a284d74e46dcb0f369'),(8192,1797,'MARTINS, Bruno Silva','c83f1ad7e00fe91e5d358c8fcd07dd6e'),(8197,1363,'Kubudi, D.','562ace773ff968aadb63cea134d603de'),(8198,1363,'GLASMAN, Daniela Kubudi','2ee55b8819bddabd0021b588cb820b31'),(8199,1363,'GLASMAN, D. K.','952629b0f72f7d7670d9c3bd901acd7e'),(8232,234,'PESSOA, M. S.','c36b6e8d4b3068c91e34489fba4ed774'),(8233,234,'PESSOA, Marcelo de Sales','9656aece0dd3181dc9919ed46a622666'),(8234,235,'JANOT, M. M.','90c8538a8ae10924c4685ddb725c8d24'),(8235,235,'JANOT, Marcio Magalhães','dc32329b0258285d783ec2457cbe85b3'),(8261,616,'BRESSER-PEREIRA, L. C.','e8c997c630088fff0976e65c1ca52872'),(8262,616,'Bresser-Pereira, Luiz Carlos','5bfa4c7b846dd65eff844c239188149c'),(8342,617,'Holland, M.','e8cd45048c8ed376ca8b338b2b5e6ff1'),(8343,617,'BRITO, Marcio Holland de','3df7ccb74498d80a0d67f065800c317c'),(8344,617,'BRITO, M. H.','61afe2d1685bfa680805c74e2ee3d67b'),(8345,618,'AZEVEDO, P. F.','66db8e258ea96dccd1d21f2029c4e97d'),(8346,618,'Azevedo, Paulo Furquim','fe0c0930645eb8a4844ed68acffedc1d'),(8347,618,'Furquim de Azevedo, Paulo','4a0196e67ac025c7f2cd2b6a14a2b642'),(8348,618,'de Azevedo, Paulo Furquim','11ca651c18bce403fd107fe387b81b36'),(8349,618,'AZEVEDO, Paulo Furquim de','4fef302f09793b8df351204567c77f60'),(8376,1,'FRANCO NETO, Afonso A. M.','10dd8dc0a62106b9c704a022bd0d4eea'),(8377,1,'FRANCO NETO, A. A. M.','019c240b4b9ed703bc31fd34473f13e2'),(8391,1802,'BRANCO, A. C. S.','13775097dad8e98ed2dbcd3dd63b6ae0'),(8392,1802,'Branco, Antonio C.S.','59346adcc23e18ba5b358ce37553cced'),(8393,1802,'A. C. S. BRANCO','30d822ca0838d05a04a4290a57b58250'),(8394,393,'PORTO, Antônio José Maristrello','5e8fea42d53c1b8ab312ad52ca6e6905'),(8395,393,'PORTO, A. J. M.','2b7f0cc432864b46835a242a6fc7369b'),(8396,1803,'SA, A. M.','e071ba53f34177c62763c65d1faeaf76'),(8397,1803,'SA, A.','575d66a21f01e75bac267439d3c021a3'),(8398,1803,'SÁ, ASLA','c95bce203e2ff140f130d8e09e345890'),(8399,1803,'MEDEIROS E SÁ, ASLA','869ed0801225e0057ef9f055311240bd'),(8400,1803,'asla medeiros e sa','c3f6dce8449d59fda16698bb7d12c5f4'),(8401,1803,'ASLA SA,','c9b9b68a02d3837905169320387a32ca'),(8402,1803,'asla sa','1f4061ffcd6a31a5fe06bc6a6276ba93'),(8420,240,'CAMPOS, Eduardo Lima','445ba136c44046f3032843703bdad742'),(8421,240,'CAMPOS, E. L.','bbc4ec2bae08b98299667004d1b2bb06'),(8429,6,'BARBOSA, F. H.','1797a840e9b43cfd1a336e0e8b52d4af'),(8430,6,'BARBOSA, Fernando de Holanda','5527f989eb6957c89be5f32c0cf47028'),(8438,1413,'VELLOSO, J. P. R.','e25ee830b59c78f07d6e59363575be1e'),(8439,1413,'VELLOSO, Joao Paulo dos Reis','22a91780cc684a30a0af8d5bb398f8d3'),(8457,1804,'COSTA, L. G.','917f96d4359fba7570a2d2b10bb11d1e'),(8458,1804,'HRYNIEWICZ COSTA, L. G.','ca13e91cc7ec42f6a2af657419d834e3'),(8459,1804,'HRYNIEWICZ, L. G. C.','9494823af0b991f816627e535c61abca'),(8460,19,'NERI, M. C.','068ab89359b4f390746ea6d32b3b80c2'),(8461,19,'Neri, Marcelo','0528f4a75cc7fe42624b03f788fb1fec'),(8462,19,'M. Neri','049fa4fba7eed24fba1585a8caa513b8'),(8463,19,'NERI, M.','22804a75f38526e1ef2a77fcb4ff48e0'),(8464,19,'NERI, Marcelo Côrtes','15271b5d244f6052fa65d78b880eb845'),(8470,334,'LEON, Márcia S.','a6361071e3c698540ebb23dfab11656a'),(8471,334,'LEON, Marcia Saraiva','3b62624cfdf7f06fb5e11628202a1d4f'),(8472,334,'LEON, M. S.','c2b1f7878418205286043c5ea96c1274'),(8473,384,'VILAROUCA, Marcio Grijó','e025fbe539854eea0c66eeaab9f4fc2b'),(8474,384,'VILAROUCA, M. G.','df33f1617474ec63c5cf39b9509343f6'),(8475,385,'CAMACHO, M. I. T.','140797726f46ed6783c9c656cf343edd'),(8476,385,'CAMACHO, Maria Izabel Tavares','332c629f6339bcf8e87e01d28fa68651'),(8477,1805,'ARONNA, M. S.','de84ec720760e9dc5af103f7596c62f6'),(8478,1805,'ARONNA, M.','ed879c2ef3f197e906940acce15a8949'),(8479,1805,'SOLEDAD ARONNA, M.','44e4ac95bb6d14cc658055fc5fd980ec'),(8480,1805,'ARONNA, M. SOLEDAD','5208d34b887e9f32691644f491a561db'),(8481,1805,'ARONNA, M.-SOLEDAD','53fe4f8f8925935b85185d524663304a'),(8482,330,'DUCLOS, M. T. M.','26f34c89ceb44412ab7e7407acadae25'),(8483,330,'DUCLOS, Maria Teresa Marins','85617fd3de4a0d6df1c2e9866f29a15c'),(8488,387,'SILVA, M. A. H. B.','fee6731b197532960897d9edd541cdfe'),(8489,387,'Silva, Moacyr A. H. B.','cd1e59cd7dc3520e5616548492ee5d83'),(8490,387,'Alvim, Moacyr','108cbffaeedbf6eedaf7f64b7c6d5454'),(8491,387,'Silva, Moacyr Alvim','9c96390d83a186b75b4280985a74cab3'),(8492,389,'CARVALHO, Paulo Cezar P. de','22c73537af2746b1a533f4cc395cad6d'),(8493,389,'CARVALHO, Paulo Cezar Pinto de','b88fddb74377a1b97a617e206372ebcf'),(8494,389,'CARVALHO, P. C. P.','dac79a67ae35f89fb0b9ffbde0cdb444'),(8502,1806,'BLIMAN, P. A. J.','512443841ef490e57af6cf3e32d342bb'),(8503,1806,'Bliman, P.-A.','18f478174f3dd55437f3bf51983e061c'),(8504,1806,'BLIMAN, PIERRE-ALEXANDRE','4c0750b401a6e3884a34c17130679b8d'),(8505,1806,'BLIMAN, P.','33a096b8bb2be0b207f5f817cc25297a'),(8506,1806,'BLIMAN, PIERRE-ALEXANDER','f1cf5a892217371508e868a811e85339'),(8510,14,'CARDOSO, R. F.','a709655626126d2953d9aed07ae23a87'),(8511,14,'CARDOSO, Renato Fragelli','94391de531179c512c69127a19a01dff'),(8512,223,'FLORES JUNIOR, R. G.','eb23d2d79e62b70e6e86e260ffef9e88'),(8513,223,'FLÔRES JUNIOR, Renato Galvão','6a910d946bdd3d88910de8cf72d9c938'),(8518,16,'CYSNE, Rubens Penha','bc4e572b38bb3394a8bbf45a41d5be4d'),(8519,16,'CYSNE, R. P.','3a122ae2187e5b6eea8d7bbb32e5427d'),(8520,1807,'WERNECK VIANNA, S. T.','8b89499d30f790d3178ca7f3fb40b2f4'),(8521,1432,'LATERCE, S. R.','046396fa0ee9bf1ca62df27fb0cbaea5'),(8522,1432,'LATERCE, Savio Ramos','0a48d430db1e153814bd1e0f35858d3e'),(8525,1808,'SANDE, W. W. C.','e466e8a947f81deec100e637a08342c9'),(8528,1801,'CAMARANO, A. A.','f278c25ae50022dc5cdf8d6729b9bcbe'),(8529,1801,'CAMARANO, ANA AMELIA','b18be965e61c7687e8bd470b57d60547'),(8530,1809,'SAPORITO, Y. F.','6f9ec1ce6302a48e9035bf285a77aa6c'),(8531,1809,'SAPORITO, YURI F.','3475bad009b36c1931092501de02c461'),(8534,638,'Sotomayor, M. A. O.','13c66aa8af4827268ef4573e19981a10'),(8535,638,'Sotomayor, Marilda','878572d7ab66b6f5e843485223b0c62d'),(8536,638,'SOTOMAYOR, M','bbe4ed3c109c8087683e766f545cb0b1'),(8537,638,'SOTOMAYOR, Marilda Antonia de Oliveira','4cafdf2f5ce96b7df66386d90a36e673'),(8555,1811,'PEREIMA, João Basilio','55e7ac2d35cd92390eb3e681a3fbcdc1'),(8556,1812,'VIEIRA, J. G. S.','7eecc71ff96ed7dbf85c72ba085bc0de'),(8564,1813,'SILVA, G. P.','f37775ad071527bf9e74c793678b61b2'),(8575,1814,'ANDRADA, A. F. S.','ae476db503e6d0708585f687cf6c6a50'),(8582,1815,'ZAPATA, C.','da41f09852642614d12897e365054378'),(8583,1816,'IMBROISI, D.','07c1975a1382140a2fdbe125a3938d3d'),(8585,1108,'ANDRADE, J. P.','cb838ce66e32039eaf25117d72a67b13'),(8586,1108,'ANDRADE, Joaquim Pinto de','bafbb4414953474aa56a986f03cf0e2c'),(8595,1114,'TANNURI-PIANTO, M. E.','e69119a95dd9050980b7eab0bc9177a7'),(8596,1114,'Tannuri-Pianto, Maria','dda4404ccf2830aa2e613026768c690c'),(8597,1114,'Tannuri, M. E.','02cfa5b6a2538e53ff0d57e1c0823e53'),(8598,1114,'TANNURI-PIANTO, Maria Eduarda','852919c10e8bfd8c233cf020bb6ac115'),(8606,1818,'CONCEIÇÃO, P. H. Z.','f09e287cb67df05cb00bed78564c99c8'),(8614,1819,'LUCAS, V.','a082b9ed1e56f404441d1050220e5eb9'),(8615,1819,'Lucas, Vander Mendes','3da1050360bce434c6d03f6542c447f3'),(8616,1819,'Lucas, V.M.','13b5bdc4697176c6380c49b73b24a7af'),(8617,1819,'Lucas, Vander M.','72353f85d3f6eac8700b73e67afaf9b8'),(8618,1817,'VERSIANI, F. R.','7c315af89a8596e7fee55afee722f195'),(8624,1820,'TAKASAGO, M.','c91e460b563b30057aec778a8cb296c8'),(8697,228,'Lowenkron, A.','b4e488f7cbfc553a0ed204e1e66c0124'),(8701,1821,'GUILLÉN, D. A.','edbf456e81c94bd594c939b9ce2931ce'),(8702,1821,'GUILLÉN, DIOGO','9cfb67c2fa04a47e11de4decf0202dae'),(8717,1822,'CAVALCANTI, M. A. F. H.','3140bca9e91ea1dc71f287f137f3a577'),(8718,1822,'Cavalcanti, Marco Antônio F. de H.','2a9e7522737680f42deb019fdf3508f5'),(8719,1822,'Cavalcanti, Marco Antonio F.H.','6e616beb35be2976c18f9a270b38ae1c'),(8720,1822,'CAVALCANTI, MARCO A. F. H.','f7f704aa452cb0a4d6c9fed4b9c0c823'),(8721,1823,'SALGADO, P.','b08089c6412eff902e9d7e597f0fa01a'),(8722,1823,'SALGADO, PABLO','d773ed466fdec31a1e8d14a62a46ea81'),(8723,1360,'RIBEIRO, R. M.','74b19942345131ca734739fe01d06fc9'),(8724,1360,'RIBEIRO, Ruy Monteiro','77fe47351b0fb99f3cef24ac92c4f75e'),(8729,1391,'PINTO, Afonso de C.','082856ae57467078b31cdbdb3e6651c1'),(8730,1391,'PINTO, Afonso de Campos','32749a6faf18d4fba62e90864c47aec1'),(8731,1391,'PINTO, A. C.','abc828fc96057463240c5b1bafd01401'),(8732,1427,'OLIVEIRA, Alexandre da Silva de','3f1dd37696ee640e7d171eecd180f89a'),(8737,1392,'MARÇAL, E. F.','b5eead11ae36bc501e8cf075faa9ccb9'),(8738,1392,'Marçal, Emerson Fernandes','c2c4077efe1cf81c08d516ef667da2b0'),(8739,1392,'Marçal, Emerson','8483c8dce12aae3ffdbe2e860c01fe88'),(8743,1393,'SHENG, H. H.','883e2184e969b2886d8b6bc43ae7b5ad'),(8744,1393,'HSIA, H. S.','74afcb6aab1c1d0f85894660521384f8'),(8745,1393,'SHENG, HSIA HUA','ee1cd460d8097b925ffff273ccb92900'),(8746,1393,'HSIA, HUA SHENG','10962816379aeeb292794aa48167864f'),(8747,1393,'SHENG, HSIA','ad577c4fb29ee5c1e586cb7656e184c3'),(8748,1394,'MERGULHÃO, J.','13b322a6f1787cde319080a45dbdedb8'),(8749,1394,'MERGULHÃO, João Filipe Bernardes Volkmann de Mendonça','a7fb8bdd01f792f4510f1fef43b17767'),(8750,1394,'MERGULHÃO, J. F. B. V. M.','28721047ec5030daf257ce00ca2d90dd'),(8751,1395,'RUILOVA, J. C.','6d1c60e0be9f7bee59c32b5ee1e0dd81'),(8752,1395,'TERÁN, Juan Carlos Ruilova','7e0d9f99a53670a7df0261fc11c55bd4'),(8753,1395,'TERÁN, J. C. R.','fbf90136a4a91f15052b7743e00f5de1'),(8759,1398,'LORA, Mayra Ivanoff','00b5921b2dcbd7f6f29a893ab6bed390'),(8760,1398,'Lora, Mayra Ivanoff: Lora, M I','9bfc2f0e935525be9de822fe23e27595'),(8761,1398,'LORA, MAYRA','6ff994badcd5486ee9e2833b88fa1852'),(8762,1398,'LORA, M. I.','0a45fb842f3fa39b44568832f4822e25'),(8763,619,'GALA, Paulo Sérgio de Oliveira Simões','b1e76a2224b139d81f3184b78a71ea03'),(8764,619,'Gala, Paulo','1c4bd7699ce0ba92df232f250bd9df09'),(8765,619,'GALA, P. S. O. S.','ed23cda74bc5963098754cc17ddaa223'),(8771,1400,'ROCHMAN, R. R.','fa33c187b2ec288254080a20193581aa'),(8772,1400,'Rochman, Ricardo Ratner','ffd3bc75db9eacb37fd3b2e0d23c3b23'),(8773,1400,'ROCHMAN, RICARDO','a5a2b90833279d62dc625dfd6922f6af'),(8774,1401,'MORI, R.','2e26ac90b7684c3f725854bba9cff0da'),(8775,1401,'MORI, ROGÉRIO','9bd9d33adb125e512b2d2c60caf8d289'),(8776,1401,'Rogério Mori','5d22a9efb723d2c759b28dc34e64fcb1'),(8777,1401,'R. MORI','40dfe1bea26aef2ffc5ec16f6a9fc10d'),(8778,1402,'DANA, Samy','f56f5a88fdc95b390dc9306753f81e09'),(8782,1403,'ORELLANO, V. I. F.','c5822a1d84bde543614fbb6a66c62e7f'),(8783,1403,'ORELLANO, Veronica Ines Fernandez','1ff90d5d8be34aee2776b2620e60e073'),(8805,1824,'GURGEL, A. C.','90dadab2a37e8c00a79b3cbf6c32238a'),(8806,1824,'GURGEL, A.','83931f7c52423069bb3c86fd67e6657d'),(8807,1824,'Gurgel, Angelo Costa','d90a0ca0ed38e9ab4d0c8f8647891053'),(8808,1824,'Gurgel, Angelo','6fa913275c1d00012af79ad750ad8de6'),(8809,1369,'SANVICENTE, A. Z.','a13b00e7c631de86de00ee7cda5627bf'),(8810,1369,'Sanvicente, Antonio Zoratto','896b432c78e598d148822a7d475de397'),(8815,1429,'TAVARES, Priscila de Albuquerque','1bb323c9bd7c8680bae3741955352eb0'),(8816,1429,'TAVARES, P. A.','986fa7006400a38bc2368a8b03fb0fb8'),(