 ALTER TABLE `logins_log`
   MODIFY `id_ul` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
 --
+-- AUTO_INCREMENT for table `lp_area_conhecimento`
+--
+ALTER TABLE `lp_area_conhecimento`
+  MODIFY `id_lpac` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `lp_linha_pesquisa`
+--
+ALTER TABLE `lp_linha_pesquisa`
+  MODIFY `id_lp` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `lp_palavra_chave`
+--
+ALTER TABLE `lp_palavra_chave`
+  MODIFY `id_lppc` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `lp_setor_aplicacao`
+--
+ALTER TABLE `lp_setor_aplicacao`
+  MODIFY `id_lpsa` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
 -- AUTO_INCREMENT for table `programa_pos`
 --
 ALTER TABLE `programa_pos`
-  MODIFY `id_pp` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
---
--- AUTO_INCREMENT for table `usuario`
---
-ALTER TABLE `usuario`
+  MODIFY `id_pp` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `us_bolsa`
+--
+ALTER TABLE `us_bolsa`
+  MODIFY `id_usb` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `us_cracha`
+--
+ALTER TABLE `us_cracha`
+  MODIFY `id_usc` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `us_email`
+--
+ALTER TABLE `us_email`
+  MODIFY `id_usm` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `us_fone`
+--
+ALTER TABLE `us_fone`
+  MODIFY `id_ufs` int(11) unsigned NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT for table `us_funcao`
+--
+ALTER TABLE `us_funcao`
+  MODIFY `usf_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
+--
+-- AUTO_INCREMENT for table `us_tipo`
+--
+ALTER TABLE `us_tipo`
+  MODIFY `ust_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
+--
+-- AUTO_INCREMENT for table `us_titulacao`
+--
+ALTER TABLE `us_titulacao`
+  MODIFY `ust_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
+--
+-- AUTO_INCREMENT for table `us_usuario`
+--
+ALTER TABLE `us_usuario`
   MODIFY `id_us` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
 --
--- AUTO_INCREMENT for table `usuario_bolsa`
---
-ALTER TABLE `usuario_bolsa`
-  MODIFY `id_usb` int(11) unsigned NOT NULL AUTO_INCREMENT;
---
--- AUTO_INCREMENT for table `usuario_cracha`
---
-ALTER TABLE `usuario_cracha`
-  MODIFY `id_usc` int(11) unsigned NOT NULL AUTO_INCREMENT;
---
--- AUTO_INCREMENT for table `usuario_email`
---
-ALTER TABLE `usuario_email`
-  MODIFY `id_usm` int(11) unsigned NOT NULL AUTO_INCREMENT;
---
--- AUTO_INCREMENT for table `usuario_fone`
---
-ALTER TABLE `usuario_fone`
-  MODIFY `id_ufs` int(11) unsigned NOT NULL AUTO_INCREMENT;
---
--- AUTO_INCREMENT for table `usuario_funcao`
---
-ALTER TABLE `usuario_funcao`
-  MODIFY `usf_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
---
--- AUTO_INCREMENT for table `usuario_tipo`
---
-ALTER TABLE `usuario_tipo`
-  MODIFY `ust_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
---
--- AUTO_INCREMENT for table `usuario_titulacao`
---
-ALTER TABLE `usuario_titulacao`
-  MODIFY `ust_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
+-- AUTO_INCREMENT for table `variaveis`
+--
+ALTER TABLE `variaveis`
+  MODIFY `id_v` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
+--
+-- AUTO_INCREMENT for table `variaveis_dados`
+--
+ALTER TABLE `variaveis_dados`
+  MODIFY `id_d` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=55;
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

-- --------------------------------------------------------

--
-- Table structure for table `usuario`
--

CREATE TABLE IF NOT EXISTS `usuario` (
  `id_us` bigint(20) unsigned NOT NULL,
  `us_nome` varchar(250) DEFAULT NULL,
  `us_cpf` varchar(15) DEFAULT NULL,

  `up_ativo` tinyint(11) DEFAULT NULL,
  `up_user` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lp_area_conhecimento`
--

CREATE TABLE IF NOT EXISTS `lp_area_conhecimento` (
  `id_lpac` int(11) unsigned NOT NULL,
  `lpac_nome` varchar(250) DEFAULT NULL,
  `lapc_cod_principal` varchar(20) NOT NULL COMMENT 'vinculo tabela de areas do conhecimento',
  `lp_id` int(11) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lp_linha_pesquisa`
--

CREATE TABLE IF NOT EXISTS `lp_linha_pesquisa` (
  `id_lp` int(11) unsigned NOT NULL,
  `lp_nome` varchar(150) DEFAULT NULL,
  `lp_objetivo` text,
  `lp_espelho` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lp_palavra_chave`
--

CREATE TABLE IF NOT EXISTS `lp_palavra_chave` (
  `id_lppc` int(11) unsigned NOT NULL,
  `lppc_palavra` varchar(60) DEFAULT NULL,
  `lp_id` int(11) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lp_pp`
--

CREATE TABLE IF NOT EXISTS `lp_pp` (
  `pp_id` int(11) unsigned NOT NULL COMMENT 'vinculo com programa de pos',
  `lp_id` int(11) unsigned NOT NULL COMMENT 'vinculo com linha de pesquisa',
  `lp_pp_dt_vinculo` date DEFAULT NULL,
  `lp_pp_dt_desvinculo` date DEFAULT NULL,
  `lp_pp_ativo` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `lp_setor_aplicacao`
--

CREATE TABLE IF NOT EXISTS `lp_setor_aplicacao` (
  `id_lpsa` int(11) unsigned NOT NULL,
  `lpsa_setor` varchar(250) DEFAULT NULL,
  `lp_id` int(11) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

