-- MySQL dump 10.13  Distrib 5.5.46, for Linux (x86_64)
--
-- Host: localhost    Database: gfmtz
-- ------------------------------------------------------
-- Server version   5.5.46

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ativo`
--

DROP TABLE IF EXISTS `ativo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ativo` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  `tipo_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `descricao` VARCHAR(255) DEFAULT '',
  `caracteristicas` text,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `dt_compra` DATE DEFAULT NULL,
  `vl_compra` DECIMAL(12,4) DEFAULT '0.0000',
  `dt_venda` DATE DEFAULT NULL,
  `vl_venda` DECIMAL(12,4) DEFAULT '0.0000',
  `dt_fipe` DATE DEFAULT NULL,
  `vl_fipe` DECIMAL(12,4) DEFAULT '0.0000',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ativo_tipo`
--

DROP TABLE IF EXISTS `ativo_tipo`;
CREATE TABLE `ativo_tipo` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 PACK_KEYS=0;

--
-- Dumping data for table `ativo`
--

LOCK TABLES `ativo_tipo` WRITE;
/*!40000 ALTER TABLE `ativo_tipo` DISABLE KEYS */;
INSERT INTO ativo_tipo ( id, nome ) VALUES ( 1, 'Móvel' ), ( 2, 'Imóvel' );
/*!40000 ALTER TABLE `ativo_tipo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `ativo`
--

LOCK TABLES `ativo` WRITE;
/*!40000 ALTER TABLE `ativo` DISABLE KEYS */;
INSERT INTO `ativo` VALUES (1,'Casa de Praia',1,'Teste','Teste','2016-02-14 12:26:00',1,'2016-03-12',0.0000,'2016-07-13',0.0000,'2016-05-11',0.0000),(3,'Casa de Praia 2',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(4,'Casa de Praia 3',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(5,'Casa de Praia 4',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(6,'Casa de Praia 5',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(7,'Casa de Praia 6',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(8,'Casa de Praia 7',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(9,'Casa de Praia 8',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(10,'Casa de Praia 9',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000),(11,'Casa de Praia 10',1,'Teste','Teste','2016-03-12 18:45:32',1,NULL,0.0000,NULL,0.0000,NULL,0.0000);
/*!40000 ALTER TABLE `ativo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `banco`
--

DROP TABLE IF EXISTS `banco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banco` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  `descricao` VARCHAR(255) DEFAULT '',
  `codigo` INT(5) DEFAULT '1',
  `agencia` VARCHAR(10) DEFAULT '',
  `conta` VARCHAR(25) DEFAULT '',
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banco`
--

LOCK TABLES `banco` WRITE;
/*!40000 ALTER TABLE `banco` DISABLE KEYS */;
INSERT INTO `banco` VALUES (1,'Itaú','',341,'0109','649301','2016-02-14 12:26:00',1),(2,'Bradesco','',345,'0109','643980','2016-02-14 12:26:00',1),(3,'Santander','',567,'0109','643980','2016-02-14 12:26:00',1);
/*!40000 ALTER TABLE `banco` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `configuracao`
--

DROP TABLE IF EXISTS `configuracao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `configuracao` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `chave` VARCHAR(80) DEFAULT NULL,
  `valor` VARCHAR(512) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `configuracao`
--

LOCK TABLES `configuracao` WRITE;
/*!40000 ALTER TABLE `configuracao` DISABLE KEYS */;
INSERT INTO `configuracao` VALUES (1,'taxa_base','5'),(2,'cpmf_fisica','0.002'),(3,'cpmf_juridica','0.002'),(4,'iof_base_fisica','0.000082'),(5,'iof_base_juridica','0.000041'),(6,'iof_adicional_fisica','0.0038'),(7,'iof_adicional_juridica','0.0038'),(8,'taxa_adm','8.5');
/*!40000 ALTER TABLE `configuracao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `credito_situacao`
--

DROP TABLE IF EXISTS `credito_situacao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `credito_situacao` (
  `id` INT(11) UNSIGNED NOT NULL,
  `nome` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `credito_situacao`
--

LOCK TABLES `credito_situacao` WRITE;
/*!40000 ALTER TABLE `credito_situacao` DISABLE KEYS */;
INSERT INTO `credito_situacao` VALUES (0,'Pendente'),(1,'Em Análise'),(2,'Analisado');
/*!40000 ALTER TABLE `credito_situacao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delegado`
--

DROP TABLE IF EXISTS `delegado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegado` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `gestor_id` INT(11) UNSIGNED NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `delegado_id` INT(11) UNSIGNED NOT NULL,
  `dt_inicio` datetime DEFAULT NULL,
  `dt_fim` datetime DEFAULT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_delegado_gestor_id_idx` (`gestor_id`),
  KEY `fk_delegado_user_id_idx` (`user_id`),
  KEY `fk_delegado_delegado_id_idx` (`delegado_id`),
  CONSTRAINT `fk_delegado_delegado_id` FOREIGN KEY (`delegado_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_delegado_gestor_id` FOREIGN KEY (`gestor_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_delegado_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delegado`
--

LOCK TABLES `delegado` WRITE;
/*!40000 ALTER TABLE `delegado` DISABLE KEYS */;
/*!40000 ALTER TABLE `delegado` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_queue`
--

DROP TABLE IF EXISTS `email_queue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `email_queue` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `subject` VARCHAR(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `toname` VARCHAR(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `toemail` VARCHAR(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_queue`
--

LOCK TABLES `email_queue` WRITE;
/*!40000 ALTER TABLE `email_queue` DISABLE KEYS */;
/*!40000 ALTER TABLE `email_queue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estado`
--

DROP TABLE IF EXISTS `estado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estado` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(80) DEFAULT NULL,
  `uf` VARCHAR(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estado`
--

LOCK TABLES `estado` WRITE;
/*!40000 ALTER TABLE `estado` DISABLE KEYS */;
INSERT INTO `estado` VALUES (1,'Acre','AC'),(2,'Alagoas','AL'),(3,'Amazonas','AM'),(4,'Amapá','AP'),(5,'Bahia','BA'),(6,'Ceará','CE'),(7,'Distrito Federal','DF'),(8,'Espírito Santo','ES'),(9,'Goiás','GO'),(10,'Maranhão','MA'),(11,'Minas Gerais','MG'),(12,'Mato Grosso do Sul','MS'),(13,'Mato Grosso','MT'),(14,'Pará','PA'),(15,'Paraíba','PB'),(16,'Pernambuco','PE'),(17,'Piauí','PI'),(18,'Paraná','PR'),(19,'Rio de Janeiro','RJ'),(20,'Rio Grande do Norte','RN'),(21,'Rondônia','RO'),(22,'Roraima','RR'),(23,'Rio Grande do Sul','RS'),(24,'Santa Catarina','SC'),(25,'Sergipe','SE'),(26,'São Paulo','SP'),(27,'Tocantins','TO');
/*!40000 ALTER TABLE `estado` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estado_civil`
--

DROP TABLE IF EXISTS `estado_civil`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estado_civil` (
  `id` INT(11) UNSIGNED NOT NULL,
  `nome` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estado_civil`
--

LOCK TABLES `estado_civil` WRITE;
/*!40000 ALTER TABLE `estado_civil` DISABLE KEYS */;
INSERT INTO `estado_civil` VALUES (0,'Solteiro(a)'),(1,'Casado(a)'),(2,'Divorciado(a)'),(3,'Viúvo(a)'),(4,'Separado(a)'),(5,'Companheiro(a)');
/*!40000 ALTER TABLE `estado_civil` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fila`
--

DROP TABLE IF EXISTS `fila`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fila` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `group` VARCHAR(25) DEFAULT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `email` VARCHAR(150) DEFAULT NULL,
  `texto` text,
  `dt_create` datetime DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fila`
--

LOCK TABLES `fila` WRITE;
/*!40000 ALTER TABLE `fila` DISABLE KEYS */;
/*!40000 ALTER TABLE `fila` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `financeiro`
--

DROP TABLE IF EXISTS `financeiro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `financeiro` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `plano_id` INT(11) UNSIGNED NOT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `situacao` tinyint(3) UNSIGNED DEFAULT NULL,
  `tipo_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `pessoa_id` INT(11) UNSIGNED NOT NULL,
  `dt_emissao` datetime DEFAULT NULL,
  `negociacao_id` INT(11) UNSIGNED DEFAULT NULL,
  `numero` VARCHAR(50) DEFAULT '',
  `dt_vencimento` datetime DEFAULT NULL,
  `dt_baixa` datetime DEFAULT NULL,
  `vl_financeiro` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_total` DECIMAL(12,4) DEFAULT '0.0000',
  `descricao` VARCHAR(255) DEFAULT '',
  `qt_dias_antecipado` INT(5) DEFAULT '1',
  `qt_dias_atraso` INT(5) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fk_financeiro_pessoa_id_idx` (`pessoa_id`),
  KEY `fk_financeiro_negociacao_id_idx` (`negociacao_id`),
  KEY `fk_financeiro_user_id_idx` (`user_id`),
  KEY `fk_financeiro_plano_id_idx` (`plano_id`),
  CONSTRAINT `fk_financeiro_negociacao_id` FOREIGN KEY (`negociacao_id`) REFERENCES `negociacao` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_financeiro_pessoa_id` FOREIGN KEY (`pessoa_id`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_financeiro_plano_id` FOREIGN KEY (`plano_id`) REFERENCES `plano_conta` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_financeiro_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `financeiro_historico`
--

DROP TABLE IF EXISTS `financeiro_historico`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `financeiro_historico` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `financeiro_parcela_id` INT(11) UNSIGNED NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `situacao` tinyint(3) UNSIGNED DEFAULT NULL,
  `tipo_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `acao` VARCHAR(255) DEFAULT '',
  `hash_dados` text,
  PRIMARY KEY (`id`),
  KEY `fk_financeiro_historico_user_id_idx` (`user_id`),
  KEY `fk_financeiro_historico_financeiro_parcela_id_idx` (`financeiro_parcela_id`),
  CONSTRAINT `fk_financeiro_historico_financeiro_parcela_id` FOREIGN KEY (`financeiro_parcela_id`) REFERENCES `financeiro_parcela` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_financeiro_historico_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `financeiro_parcela`
--

DROP TABLE IF EXISTS `financeiro_parcela`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `financeiro_parcela` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `financeiro_id` INT(11) UNSIGNED NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `banco_id` INT(11) UNSIGNED DEFAULT NULL,
  `cheque` VARCHAR(25) DEFAULT '',
  `pagamento_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `ordem` INT(5) DEFAULT '1',
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `dt_baixa` DATE DEFAULT NULL,
  `dt_emprestimo` DATE DEFAULT NULL,
  `dt_pagamento` DATE DEFAULT NULL,
  `qt_prazo_dias` INT(5) DEFAULT '1',
  `vl_parcela` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_juros` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_cpmf` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_iof` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_total` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_prazo_comp` DECIMAL(12,4) DEFAULT '0.0000',
  `descricao` VARCHAR(255) DEFAULT '',
  `status` tinyint(3) UNSIGNED DEFAULT NULL,
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `cheque_compensar` tinyint(3) UNSIGNED DEFAULT NULL,
  `vl_desconto` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_multa` DECIMAL(12,4) DEFAULT '0.0000',
  `dt_vencimento` DATE DEFAULT NULL,
  `vl_despesas_adm` DECIMAL(12,4) DEFAULT '0.0000',
  PRIMARY KEY (`id`),
  KEY `fk_financeiro_parcela_user_id_idx` (`user_id`),
  KEY `fk_financeiro_parcela_financeiro_id_idx` (`financeiro_id`),
  KEY `fk_financeiro_parcela_banco_id_idx` (`banco_id`),
  CONSTRAINT `fk_financeiro_parcela_banco_id` FOREIGN KEY (`banco_id`) REFERENCES `banco` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_financeiro_parcela_financeiro_id` FOREIGN KEY (`financeiro_id`) REFERENCES `financeiro` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_financeiro_parcela_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `financeiro_status`
--

DROP TABLE IF EXISTS `financeiro_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `financeiro_status` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `financeiro_status`
--

LOCK TABLES `financeiro_status` WRITE;
/*!40000 ALTER TABLE `financeiro_status` DISABLE KEYS */;
INSERT INTO `financeiro_status` VALUES (1,'Em Aberto'),(2,'Baixada');
/*!40000 ALTER TABLE `financeiro_status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `financeiro_tipo`
--

DROP TABLE IF EXISTS `financeiro_tipo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `financeiro_tipo` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `financeiro_tipo`
--

LOCK TABLES `financeiro_tipo` WRITE;
/*!40000 ALTER TABLE `financeiro_tipo` DISABLE KEYS */;
INSERT INTO `financeiro_tipo` VALUES (1,'Á Pagar'),(2,'Á Receber');
/*!40000 ALTER TABLE `financeiro_tipo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu`
--

DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  `tipo_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `caminho` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu`
--

LOCK TABLES `menu` WRITE;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
INSERT INTO `menu` VALUES (1,'Alarmes',1,'2016-03-12 18:26:08',1,'alarme/lista'),(2,'Negociações',1,'2016-03-12 18:26:08',1,'negociacao/lista'),(3,'Nova negociação',1,'2016-03-12 18:26:08',1,'negociacao/seleciona'),(4,'Cliente/Fornecedor',2,'2016-03-12 18:26:08',1,'pessoa/lista'),(5,'Financeiro',2,'2016-03-12 18:26:08',1,'financeiro/lista'),(6,'Novo financeiro',2,'2016-03-12 18:26:08',1,'financeiro/seleciona'),(7,'Ativos',2,'2016-03-12 18:26:08',1,'ativo/lista'),(8,'Simuladores',2,'2016-03-12 18:26:08',1,'simulador/lista'),(9,'Bancos',2,'2016-03-12 18:26:08',1,'banco/lista'),(10,'Plano de Contas',2,'2016-03-12 18:26:08',1,'planoconta/lista'),(11,'Usuários',3,'2016-03-12 18:26:08',1,'usuario/lista'),(12,'Configurações',3,'2016-03-12 18:26:08',1,'configuracao/lista'),(13,'Patrimônio',4,'2016-03-12 18:26:08',1,'reports/filtro'),(14,'Cash Flow',4,'2016-03-12 18:26:08',1,'reports/cash-flow'),(15,'Cash Flow Anual',4,'2016-03-12 18:26:08',1,'reports/cash-flow-anual'),(16,'Finances',4,'2016-03-12 18:26:08',1,'reports/finances'),(17,'Analítico',4,'2016-03-27 00:00:00',1,'reports/analitico'),(18,'Sintético Financeiro',4,'2016-03-27 00:00:00',1,'reports/sintetico-financeiro');
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu_tipo`
--

DROP TABLE IF EXISTS `menu_tipo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu_tipo` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  `icone` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu_tipo`
--

LOCK TABLES `menu_tipo` WRITE;
/*!40000 ALTER TABLE `menu_tipo` DISABLE KEYS */;
INSERT INTO `menu_tipo` VALUES (1,'Simuladores','mdi-editor-border-all'),(2,'Cadastros','mdi-editor-insert-comment'),(3,'Administração','mdi-image-palette'),(4,'Relatórios','mdi-action-print');
/*!40000 ALTER TABLE `menu_tipo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `migration` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` INT(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_users_table',1),('2014_10_12_100000_create_password_resets_table',1),('2015_01_01_000001_create_oauth_scopes_table',2),('2015_01_01_000002_create_oauth_grants_table',2),('2015_01_01_000003_create_oauth_grant_scopes_table',2),('2015_01_01_000004_create_oauth_clients_table',2),('2015_01_01_000005_create_oauth_client_endpoints_table',2),('2015_01_01_000006_create_oauth_client_scopes_table',2),('2015_01_01_000007_create_oauth_client_grants_table',2),('2015_01_01_000008_create_oauth_sessions_table',2),('2015_01_01_000009_create_oauth_session_scopes_table',2),('2015_01_01_000010_create_oauth_auth_codes_table',2),('2015_01_01_000011_create_oauth_auth_code_scopes_table',2),('2015_01_01_000012_create_oauth_access_tokens_table',2),('2015_01_01_000013_create_oauth_access_token_scopes_table',2),('2015_01_01_000014_create_oauth_refresh_tokens_table',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `negociacao`
--

DROP TABLE IF EXISTS `negociacao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `negociacao` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `simulador_id` INT(11) UNSIGNED NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `pessoa_id` INT(11) UNSIGNED NOT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dt_contrato` DATE DEFAULT NULL,
  `dt_pagamento` DATE DEFAULT NULL,
  `qt_parcelas` INT(5) DEFAULT '1',
  `status` tinyint(3) UNSIGNED DEFAULT NULL,
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `vl_contrato` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_taxa_juros_mes` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_capital` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_calculado` DECIMAL(12,4) DEFAULT '0.0000',
  `dia_vencimento` INT(5) DEFAULT '1',
  `vl_taxa_adm` DECIMAL(12,4) DEFAULT NULL,
  `tipo_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `vl_cet` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_cpmf` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_iof` DECIMAL(12,4) DEFAULT '0.0000',
  PRIMARY KEY (`id`),
  KEY `fk_negociacao_simulador_id_idx` (`simulador_id`),
  KEY `fk_negociacao_user_id_idx` (`user_id`),
  KEY `fk_negociacao_pessoa_id_idx` (`pessoa_id`),
  CONSTRAINT `fk_negociacao_pessoa_id` FOREIGN KEY (`pessoa_id`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_negociacao_simulador_id` FOREIGN KEY (`simulador_id`) REFERENCES `simulador` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_negociacao_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `negociacao_parcela`
--

DROP TABLE IF EXISTS `negociacao_parcela`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `negociacao_parcela` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `negociacao_id` INT(11) UNSIGNED NOT NULL,
  `banco_id` INT(11) UNSIGNED DEFAULT NULL,
  `cheque` VARCHAR(25) DEFAULT '',
  `ordem` INT(5) DEFAULT '1',
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `dt_emprestimo` DATE DEFAULT NULL,
  `dt_pagamento` DATE DEFAULT NULL,
  `qt_prazo_dias` INT(5) DEFAULT '1',
  `vl_parcela` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_juros` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_cpmf` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_iof` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_total` DECIMAL(12,4) DEFAULT '0.0000',
  `vl_prazo_comp` DECIMAL(12,4) DEFAULT '0.0000',
  `status` tinyint(3) UNSIGNED DEFAULT NULL,
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `vl_juros_calc` DECIMAL(12,4) DEFAULT NULL,
  `vl_saldo_calc` DECIMAL(12,4) DEFAULT NULL,
  `vl_amortizacao_calc` DECIMAL(12,4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_negociacao_parcela_negociacao_id_idx` (`negociacao_id`),
  KEY `fk_negociacao_parcela_banco_id_idx` (`banco_id`),
  CONSTRAINT `fk_negociacao_parcela_banco_id` FOREIGN KEY (`banco_id`) REFERENCES `banco` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_negociacao_parcela_negociacao_id` FOREIGN KEY (`negociacao_id`) REFERENCES `negociacao` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=421 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `negociacao_tipo`
--

DROP TABLE IF EXISTS `negociacao_tipo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `negociacao_tipo` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `negociacao_tipo`
--

LOCK TABLES `negociacao_tipo` WRITE;
/*!40000 ALTER TABLE `negociacao_tipo` DISABLE KEYS */;
INSERT INTO `negociacao_tipo` VALUES (1,'Emprestimo'),(2,'Financiamento'),(3,'Cheque Próprio'),(4,'Cheque Terceiro');
/*!40000 ALTER TABLE `negociacao_tipo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_access_token_scopes`
--

DROP TABLE IF EXISTS `oauth_access_token_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_access_token_scopes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `access_token_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `scope_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_access_token_scopes_access_token_id_index` (`access_token_id`),
  KEY `oauth_access_token_scopes_scope_id_index` (`scope_id`),
  CONSTRAINT `oauth_access_token_scopes_access_token_id_foreign` FOREIGN KEY (`access_token_id`) REFERENCES `oauth_access_tokens` (`id`) ON DELETE CASCADE,
  CONSTRAINT `oauth_access_token_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_access_token_scopes`
--

LOCK TABLES `oauth_access_token_scopes` WRITE;
/*!40000 ALTER TABLE `oauth_access_token_scopes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_access_token_scopes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_access_tokens`
--

DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_access_tokens` (
  `id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `session_id` INT(10) UNSIGNED NOT NULL,
  `expire_time` INT(11) NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `oauth_access_tokens_id_session_id_unique` (`id`,`session_id`),
  KEY `oauth_access_tokens_session_id_index` (`session_id`),
  CONSTRAINT `oauth_access_tokens_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `oauth_sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_access_tokens`
--

LOCK TABLES `oauth_access_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
INSERT INTO `oauth_access_tokens` VALUES ('0cmMKuRkSSbIQs8z5jlxGF4rgP4I9OXdFQr7cSk4',1,1443708930,'2015-10-01 19:15:30','2015-10-01 19:15:30'),('1sOjErinPTJ3TL1hthfbDUbUkkrhySpvNhFTTgBT',24,1443750239,'2015-10-02 06:43:59','2015-10-02 06:43:59'),('52S82mG8SQ8HSJgkXcVqiknE1SrlJQ73mQZHqfdi',25,1443750341,'2015-10-02 06:45:41','2015-10-02 06:45:41'),('5LVN1wqDc1DtHNlfx6fSLnG0ZhUCqwUrlLPB3jkq',16,1443749987,'2015-10-02 06:39:47','2015-10-02 06:39:47'),('6asdJ8OQ6kjVRJLntiUauugALGDsBEoOFlW2jGR2',8,1443748182,'2015-10-02 06:09:42','2015-10-02 06:09:42'),('9TmxvE6BGJZzKv7v0VORv2031bUOAJ6TWcAcPq11',15,1443749962,'2015-10-02 06:39:22','2015-10-02 06:39:22'),('AXXEtZUaBmuHUlisDnhQHB4cqzM0zK6pqcm3c3nn',13,1443749718,'2015-10-02 06:35:19','2015-10-02 06:35:19'),('beHrXI3d2X16P1GnwvINrnn03RgO9PUolJ0ojpMh',9,1443748251,'2015-10-02 06:10:51','2015-10-02 06:10:51'),('biiDCegy0xzZ8TKYXs7EQC6cmW8MKcfkl568hZQB',17,1443750105,'2015-10-02 06:41:45','2015-10-02 06:41:45'),('BJOCyntw4fB8zclE28vhlntCxwysEpja8XqdvztQ',27,1443750608,'2015-10-02 06:50:08','2015-10-02 06:50:08'),('bnizluCzARtl7bIj1SqUoPcfUZMzQOzwEblGu1JB',5,1443710297,'2015-10-01 19:38:17','2015-10-01 19:38:17'),('cFGT7IIIEz0A5in6sPPYTZq2T2JzNOywDSxN4xAw',19,1443750189,'2015-10-02 06:43:09','2015-10-02 06:43:09'),('CwtMTQIsTfmSuYecKgsZn3Nxk3tPbOm3rJ8YqKFg',18,1443750175,'2015-10-02 06:42:55','2015-10-02 06:42:55'),('dFNBJ9tY5VxM1EiIOPhPHy9EYOA1tUQGdzb1SroI',3,1443709395,'2015-10-01 19:23:15','2015-10-01 19:23:15'),('dGSd9KkLe4RoNBjTf0Z9qnENZzW3PR2wfqD9O3wi',4,1443709639,'2015-10-01 19:27:19','2015-10-01 19:27:19'),('GVBFy4ZGuZQtsFGFg1ddo68xSkh5PxgT36HUHBPg',21,1443750204,'2015-10-02 06:43:24','2015-10-02 06:43:24'),('HhYao0OPbwvootClPlIoFveHOoraFrlAFw0AeH4h',36,1450964710,'2015-12-24 12:45:10','2015-12-24 12:45:10'),('iC6UybjtkpNrb35ZBAmsRQkEoC5xMVv928u43zLy',33,1443911721,'2015-10-04 03:35:21','2015-10-04 03:35:21'),('kprzyIkZA7f2pAKQqZvH0FQN9PYZu9INyeM3yuzd',6,1443712920,'2015-10-01 20:22:00','2015-10-01 20:22:00'),('KyrOj5HBbodRS2GtAakcEZIyYgcNkGMtT1ikfKKJ',23,1443750226,'2015-10-02 06:43:46','2015-10-02 06:43:46'),('LpBvdpb4pxldEvQIAMwsLuBwAoksPO3tNdp19laM',11,1443749700,'2015-10-02 06:35:00','2015-10-02 06:35:00'),('mAMlnAapcwlC7vQ0cChzT6QI0L0PVwNkPEIqJ5oZ',32,1443794083,'2015-10-02 18:54:44','2015-10-02 18:54:44'),('n1p8Xo3awV6k7ntHzRehFuGj5Aejzeys4JqvSVHH',31,1443750710,'2015-10-02 06:51:50','2015-10-02 06:51:50'),('NrnBg3Jghg2e2zkDINHJlpvPq8Teapzh4jMg13og',30,1443750701,'2015-10-02 06:51:41','2015-10-02 06:51:41'),('OZBsCOs7rVeSyqKAyXfgpa8MK79BWShm0nDeQIDv',34,1444011649,'2015-10-05 07:20:49','2015-10-05 07:20:49'),('ppkzDiJOiGuWrkoeD4aGttTHpNrBXnF2MrwCN237',22,1443750207,'2015-10-02 06:43:28','2015-10-02 06:43:28'),('Q4SiRNT908VUzAqpCTRyLHr5cZThut4gnn4A64eQ',7,1443747698,'2015-10-02 06:01:38','2015-10-02 06:01:38'),('QgONKf1TabYgw9e6iJcsxMmrJvgta5UHUuFyLjI2',12,1443749706,'2015-10-02 06:35:07','2015-10-02 06:35:07'),('R4J7ZKRjfHsgfyE6sNz6eFwBwVicXAmlBPPyK5l6',14,1443749917,'2015-10-02 06:38:37','2015-10-02 06:38:37'),('R7QWmnrH3rTK13Js2TVGb2wJxYkz4gyqVHoJR94c',29,1443750684,'2015-10-02 06:51:24','2015-10-02 06:51:24'),('U1zJH2sZfZX1ZAuBUfXS5rnx8zn1JSESm6aK69QT',20,1443750201,'2015-10-02 06:43:21','2015-10-02 06:43:21'),('UCSp0t4foh6dg9WbsG2epXB9IVMMLtzhVLKrbkwa',10,1443748259,'2015-10-02 06:10:59','2015-10-02 06:10:59'),('vxDy8Ut5PMCOu1x2mN3S6SWauwOvrJrOfvvXZJfr',28,1443750675,'2015-10-02 06:51:15','2015-10-02 06:51:15'),('W6LsvXcFKaYruVMmZhDOu7VqoSRkvCNmEX5gy1XA',26,1443750418,'2015-10-02 06:46:58','2015-10-02 06:46:58'),('w7LLo8qxlopPo671vLxUl8nUS2xemd3ILsyQkHe5',35,1450964558,'2015-12-24 12:42:38','2015-12-24 12:42:38'),('y3EfCBJmR7wT5jZCNGcxKA5a4f7kXTr1DMBOVwk8',2,1443709120,'2015-10-01 19:18:40','2015-10-01 19:18:40');
/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_auth_code_scopes`
--

DROP TABLE IF EXISTS `oauth_auth_code_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_auth_code_scopes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `auth_code_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `scope_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_auth_code_scopes_auth_code_id_index` (`auth_code_id`),
  KEY `oauth_auth_code_scopes_scope_id_index` (`scope_id`),
  CONSTRAINT `oauth_auth_code_scopes_auth_code_id_foreign` FOREIGN KEY (`auth_code_id`) REFERENCES `oauth_auth_codes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `oauth_auth_code_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_auth_code_scopes`
--

LOCK TABLES `oauth_auth_code_scopes` WRITE;
/*!40000 ALTER TABLE `oauth_auth_code_scopes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_auth_code_scopes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_auth_codes`
--

DROP TABLE IF EXISTS `oauth_auth_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_auth_codes` (
  `id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `session_id` INT(10) UNSIGNED NOT NULL,
  `redirect_uri` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `expire_time` INT(11) NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_session_id_index` (`session_id`),
  CONSTRAINT `oauth_auth_codes_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `oauth_sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_auth_codes`
--

LOCK TABLES `oauth_auth_codes` WRITE;
/*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_client_endpoints`
--

DROP TABLE IF EXISTS `oauth_client_endpoints`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_client_endpoints` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `redirect_uri` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `oauth_client_endpoints_client_id_redirect_uri_unique` (`client_id`,`redirect_uri`),
  CONSTRAINT `oauth_client_endpoints_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_client_endpoints`
--

LOCK TABLES `oauth_client_endpoints` WRITE;
/*!40000 ALTER TABLE `oauth_client_endpoints` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_client_endpoints` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_client_grants`
--

DROP TABLE IF EXISTS `oauth_client_grants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_client_grants` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `grant_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_client_grants_client_id_index` (`client_id`),
  KEY `oauth_client_grants_grant_id_index` (`grant_id`),
  CONSTRAINT `oauth_client_grants_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `oauth_client_grants_grant_id_foreign` FOREIGN KEY (`grant_id`) REFERENCES `oauth_grants` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_client_grants`
--

LOCK TABLES `oauth_client_grants` WRITE;
/*!40000 ALTER TABLE `oauth_client_grants` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_client_grants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_client_scopes`
--

DROP TABLE IF EXISTS `oauth_client_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_client_scopes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `scope_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_client_scopes_client_id_index` (`client_id`),
  KEY `oauth_client_scopes_scope_id_index` (`scope_id`),
  CONSTRAINT `oauth_client_scopes_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE,
  CONSTRAINT `oauth_client_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_client_scopes`
--

LOCK TABLES `oauth_client_scopes` WRITE;
/*!40000 ALTER TABLE `oauth_client_scopes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_client_scopes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_clients`
--

DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_clients` (
  `id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `secret` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `name` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `oauth_clients_id_secret_unique` (`id`,`secret`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_clients`
--

LOCK TABLES `oauth_clients` WRITE;
/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
INSERT INTO `oauth_clients` VALUES ('app1','secret','client1','2015-10-01 14:45:00','2015-10-01 14:45:00');
/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_grant_scopes`
--

DROP TABLE IF EXISTS `oauth_grant_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_grant_scopes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `grant_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `scope_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_grant_scopes_grant_id_index` (`grant_id`),
  KEY `oauth_grant_scopes_scope_id_index` (`scope_id`),
  CONSTRAINT `oauth_grant_scopes_grant_id_foreign` FOREIGN KEY (`grant_id`) REFERENCES `oauth_grants` (`id`) ON DELETE CASCADE,
  CONSTRAINT `oauth_grant_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_grant_scopes`
--

LOCK TABLES `oauth_grant_scopes` WRITE;
/*!40000 ALTER TABLE `oauth_grant_scopes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_grant_scopes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_grants`
--

DROP TABLE IF EXISTS `oauth_grants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_grants` (
  `id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_grants`
--

LOCK TABLES `oauth_grants` WRITE;
/*!40000 ALTER TABLE `oauth_grants` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_grants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_refresh_tokens`
--

DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_refresh_tokens` (
  `id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `access_token_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `expire_time` INT(11) NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`access_token_id`),
  UNIQUE KEY `oauth_refresh_tokens_id_unique` (`id`),
  CONSTRAINT `oauth_refresh_tokens_access_token_id_foreign` FOREIGN KEY (`access_token_id`) REFERENCES `oauth_access_tokens` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_refresh_tokens`
--

LOCK TABLES `oauth_refresh_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_scopes`
--

DROP TABLE IF EXISTS `oauth_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_scopes` (
  `id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `description` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_scopes`
--

LOCK TABLES `oauth_scopes` WRITE;
/*!40000 ALTER TABLE `oauth_scopes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_scopes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_session_scopes`
--

DROP TABLE IF EXISTS `oauth_session_scopes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_session_scopes` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `session_id` INT(10) UNSIGNED NOT NULL,
  `scope_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_session_scopes_session_id_index` (`session_id`),
  KEY `oauth_session_scopes_scope_id_index` (`scope_id`),
  CONSTRAINT `oauth_session_scopes_scope_id_foreign` FOREIGN KEY (`scope_id`) REFERENCES `oauth_scopes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `oauth_session_scopes_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `oauth_sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_session_scopes`
--

LOCK TABLES `oauth_session_scopes` WRITE;
/*!40000 ALTER TABLE `oauth_session_scopes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_session_scopes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_sessions`
--

DROP TABLE IF EXISTS `oauth_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_sessions` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `client_id` VARCHAR(40) COLLATE utf8_unicode_ci NOT NULL,
  `owner_type` enum('client','user') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user',
  `owner_id` VARCHAR(255) COLLATE utf8_unicode_ci NOT NULL,
  `client_redirect_uri` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `oauth_sessions_client_id_owner_type_owner_id_index` (`client_id`,`owner_type`,`owner_id`),
  CONSTRAINT `oauth_sessions_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `oauth_clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_sessions`
--

LOCK TABLES `oauth_sessions` WRITE;
/*!40000 ALTER TABLE `oauth_sessions` DISABLE KEYS */;
INSERT INTO `oauth_sessions` VALUES (1,'app1','user','4',NULL,'2015-10-01 19:15:30','2015-10-01 19:15:30'),(2,'app1','user','4',NULL,'2015-10-01 19:18:40','2015-10-01 19:18:40'),(3,'app1','user','4',NULL,'2015-10-01 19:23:15','2015-10-01 19:23:15'),(4,'app1','user','4',NULL,'2015-10-01 19:27:19','2015-10-01 19:27:19'),(5,'app1','user','4',NULL,'2015-10-01 19:38:17','2015-10-01 19:38:17'),(6,'app1','user','4',NULL,'2015-10-01 20:22:00','2015-10-01 20:22:00'),(7,'app1','user','4',NULL,'2015-10-02 06:01:38','2015-10-02 06:01:38'),(8,'app1','user','4',NULL,'2015-10-02 06:09:42','2015-10-02 06:09:42'),(9,'app1','user','4',NULL,'2015-10-02 06:10:51','2015-10-02 06:10:51'),(10,'app1','user','4',NULL,'2015-10-02 06:10:59','2015-10-02 06:10:59'),(11,'app1','user','4',NULL,'2015-10-02 06:35:00','2015-10-02 06:35:00'),(12,'app1','user','4',NULL,'2015-10-02 06:35:06','2015-10-02 06:35:06'),(13,'app1','user','4',NULL,'2015-10-02 06:35:18','2015-10-02 06:35:18'),(14,'app1','user','4',NULL,'2015-10-02 06:38:37','2015-10-02 06:38:37'),(15,'app1','user','4',NULL,'2015-10-02 06:39:22','2015-10-02 06:39:22'),(16,'app1','user','4',NULL,'2015-10-02 06:39:47','2015-10-02 06:39:47'),(17,'app1','user','4',NULL,'2015-10-02 06:41:45','2015-10-02 06:41:45'),(18,'app1','user','4',NULL,'2015-10-02 06:42:55','2015-10-02 06:42:55'),(19,'app1','user','4',NULL,'2015-10-02 06:43:09','2015-10-02 06:43:09'),(20,'app1','user','4',NULL,'2015-10-02 06:43:21','2015-10-02 06:43:21'),(21,'app1','user','4',NULL,'2015-10-02 06:43:24','2015-10-02 06:43:24'),(22,'app1','user','4',NULL,'2015-10-02 06:43:27','2015-10-02 06:43:27'),(23,'app1','user','4',NULL,'2015-10-02 06:43:46','2015-10-02 06:43:46'),(24,'app1','user','4',NULL,'2015-10-02 06:43:59','2015-10-02 06:43:59'),(25,'app1','user','4',NULL,'2015-10-02 06:45:41','2015-10-02 06:45:41'),(26,'app1','user','4',NULL,'2015-10-02 06:46:58','2015-10-02 06:46:58'),(27,'app1','user','4',NULL,'2015-10-02 06:50:08','2015-10-02 06:50:08'),(28,'app1','user','4',NULL,'2015-10-02 06:51:15','2015-10-02 06:51:15'),(29,'app1','user','4',NULL,'2015-10-02 06:51:24','2015-10-02 06:51:24'),(30,'app1','user','4',NULL,'2015-10-02 06:51:41','2015-10-02 06:51:41'),(31,'app1','user','4',NULL,'2015-10-02 06:51:50','2015-10-02 06:51:50'),(32,'app1','user','4',NULL,'2015-10-02 18:54:44','2015-10-02 18:54:44'),(33,'app1','user','4',NULL,'2015-10-04 03:35:21','2015-10-04 03:35:21'),(34,'app1','user','4',NULL,'2015-10-05 07:20:49','2015-10-05 07:20:49'),(35,'app1','user','1',NULL,'2015-12-24 12:42:38','2015-12-24 12:42:38'),(36,'app1','user','1',NULL,'2015-12-24 12:45:10','2015-12-24 12:45:10');
/*!40000 ALTER TABLE `oauth_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `token` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissao`
--

DROP TABLE IF EXISTS `permissao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissao` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `menu_id` INT(11) UNSIGNED NOT NULL,
  `tipo` tinyint(3) UNSIGNED DEFAULT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_permissao_user_id_idx` (`user_id`),
  KEY `fk_permissao_menu_id_idx` (`menu_id`),
  CONSTRAINT `fk_permissao_menu_id` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_permissao_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissao`
--

LOCK TABLES `permissao` WRITE;
/*!40000 ALTER TABLE `permissao` DISABLE KEYS */;
/*!40000 ALTER TABLE `permissao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pessoa`
--

DROP TABLE IF EXISTS `pessoa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pessoa` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `tipo_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `tipo_pessoa_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `codigo` VARCHAR(60) DEFAULT '',
  `nome` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) DEFAULT '',
  `nome_reduzido` VARCHAR(100) DEFAULT '',
  `telefone1` VARCHAR(15) DEFAULT '',
  `telefone2` VARCHAR(15) DEFAULT '',
  `fax` VARCHAR(15) DEFAULT '',
  `contato` VARCHAR(255) DEFAULT '',
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` tinyint(3) UNSIGNED DEFAULT NULL,
  `dt_cadastro` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `dt_ultimo_ctr` DATE DEFAULT NULL,
  `dt_atualizado` DATE DEFAULT NULL,
  `dt_nascimento` DATE DEFAULT NULL,
  `documento` VARCHAR(20) DEFAULT '',
  `registro` VARCHAR(20) DEFAULT '',
  `registro_estado_uf` VARCHAR(2) DEFAULT '',
  `inscricao_municipal` VARCHAR(20) DEFAULT '',
  `estado_civil` tinyint(3) UNSIGNED DEFAULT NULL,
  `estrangeiro` tinyint(3) UNSIGNED DEFAULT NULL,
  `passaporte` VARCHAR(50) DEFAULT '',
  `passaporte_validade` DATE DEFAULT NULL,
  `endereco_transito` VARCHAR(255) DEFAULT '',
  `nacionalidade` VARCHAR(150) DEFAULT '',
  `cnh` VARCHAR(50) DEFAULT '',
  `cnh_emissao` DATE DEFAULT NULL,
  `validade` DATE DEFAULT NULL,
  `prontuario` VARCHAR(255) DEFAULT '',
  `categoria` VARCHAR(255) DEFAULT '',
  `data_lista_alerta` DATE DEFAULT NULL,
  `motivo` VARCHAR(255) DEFAULT '',
  `particularidades` tinyint(3) UNSIGNED DEFAULT NULL,
  `fixa` VARCHAR(255) DEFAULT '',
  `site` VARCHAR(255) DEFAULT '',
  `observacao` VARCHAR(255) DEFAULT '',
  `endereco` VARCHAR(255) DEFAULT '',
  `numero` VARCHAR(25) DEFAULT '',
  `complemento` VARCHAR(50) DEFAULT '',
  `bairro` VARCHAR(255) DEFAULT '',
  `cidade` VARCHAR(255) DEFAULT '',
  `estado_uf` VARCHAR(2) DEFAULT '',
  `cep` VARCHAR(10) DEFAULT '',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `cobranca_endereco` VARCHAR(255) DEFAULT '',
  `cobranca_numero` VARCHAR(25) DEFAULT '',
  `cobranca_complemento` VARCHAR(50) DEFAULT '',
  `cobranca_bairro` VARCHAR(255) DEFAULT '',
  `cobranca_cidade` VARCHAR(255) DEFAULT '',
  `cobranca_estado_uf` VARCHAR(2) DEFAULT '',
  `cobranca_cep` VARCHAR(10) DEFAULT '',
  `cobranca_telefone` VARCHAR(15) DEFAULT '',
  `credito_situacao` tinyint(3) UNSIGNED DEFAULT NULL,
  `credito_dt_atualizado` DATE DEFAULT NULL,
  `credito_vl_limite_faturamento` DECIMAL(12,4) DEFAULT '0.0000',
  `credito_vl_comprometimento` DECIMAL(12,4) DEFAULT '0.0000',
  `credito_comprometimento` VARCHAR(255) DEFAULT '',
  `credito_vl_faturamento_mensal` DECIMAL(12,4) DEFAULT '0.0000',
  `credito_vl_patrimonio_liquido` DECIMAL(12,4) DEFAULT '0.0000',
  `credito_regime_tributario` VARCHAR(255) DEFAULT '',
  `credito_dt_ultimo_balanco` DATE DEFAULT NULL,
  `credito_dt_consulta_serasa` DATE DEFAULT NULL,
  `credito_dt_restricao_credito` DATE DEFAULT NULL,
  `credito_historico_cliente` VARCHAR(512) DEFAULT '',
  `credito_user_id` INT(11) UNSIGNED NOT NULL,
  `taxa_base` DECIMAL(12,4) DEFAULT '0.0000',
  PRIMARY KEY (`id`),
  KEY `fk_pessoa_user_id_idx` (`user_id`),
  CONSTRAINT `fk_pessoa_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pessoa`
--

LOCK TABLES `pessoa` WRITE;
/*!40000 ALTER TABLE `pessoa` DISABLE KEYS */;
INSERT INTO `pessoa` VALUES (2,1,1,0,'PD0001','Pedro Brasileiro','pedro@uol.com.br','Pedro','33043314','99578877','4333043314','Hernando','2016-01-08 10:46:39',0,'2016-01-08 10:46:39','2016-01-10','2016-01-08','2016-01-08','73102679901','12345678901','PR','123456778901',1,1,'12345678901','2016-01-08','Rua Santos 248','Brasileiro','12345678901','2011-03-03','2016-01-08','prontuario','Tipo A','2016-01-28','motivo',1,'fixa','http://www.uol.com.br','observacao','Rua Santos','248','Ap 302','Centro','Londrina','PR','86020040',0,'','','Ap 504','Vila Siam','Londrina','PR','86039370','43 33043317',1,'2016-03-23',100000.0000,50000.0000,'--comprometimento--',80000.0000,500000.0000,'--regime--','2016-01-10','2016-01-10','2016-01-10','',1,3.5000),(3,1,1,0,'RD0002','Rosana','rosana@uol.com.br','Rosana','4333212020','4399578877','4333727000','Rosana','2016-01-08 19:21:36',1,'2016-01-08 19:21:36','2016-01-08','2016-01-08','2016-01-08','73102679900','','AC','',1,0,'','2016-01-08','','','','2016-01-08','2016-01-08','','','2016-01-08','',0,'','','','Rua Santos','248','Ap 302','Centro','Londrina','PR','86020040',1,'','','','','','AC','','',0,'2015-07-15',1.0000,2.0000,'gsdfgsdf',3.0000,4.0000,'gsdfgsdf','1899-11-09','1899-11-18','1899-11-11','TRANQUILO',1,3.5000),(4,1,2,1,'HPB009','Hernando de Paula Brasileiro','hpbrasileiro@hotmail.com','Hernando','4399578877','4333043314','4333729000','Hernando','0000-00-00 00:00:00',1,'0000-00-00 00:00:00','2016-01-08','0000-00-00','2016-01-08','73102679900','','AC','',1,0,'','2016-01-08','','','','2016-01-08','2016-01-08','','','2016-01-08','',0,'','','','Rua Santos','248','Ap 302','Centro','Londrina','PR','8602040',1,'','','','','','AC','','',2,'2015-11-01',100000.0000,50000.0000,'--comprometimento--',80000.0000,500000.0000,'--regime--','2016-01-10','2016-01-10','2016-01-10','',1,5.0000),(5,1,1,0,'RB0019','Rogerio Brasileiro','brasileiro@exactus.com.br','Rogerio','43 33230661','43 99578877','43 33727000','Sirlaine','0000-00-00 00:00:00',1,'0000-00-00 00:00:00','2016-01-10','0000-00-00','2016-01-10','73102679900','','AC','',1,0,'','2016-01-10','','','','2016-01-10','2016-01-10','','','2016-01-10','',0,'','','','Rua Santos','248','Ap 302','Centro','Londrina','PR','86020040',1,'','','','','','AC','','',2,'2016-01-12',15000.0000,50000.0000,'',3000000.0000,1500000.0000,'','0000-00-00','0000-00-00','0000-00-00','',1,5.0000),(9,1,1,1,'RD0002','Teste','teste@uol.com.br','Teste','','','','','0000-00-00 00:00:00',1,'0000-00-00 00:00:00','2016-02-17','0000-00-00','2016-02-17','73102679907','','AC','',1,0,'','2016-02-17','','','','2016-02-17','2016-02-17','','','2016-02-17','',0,'','','','Rua Catarina de Bora','123','Ap','Centro','Londrina','AC','860020040',1,'','','','','','AC','','',2,'0000-00-00',10000.0000,50000.0000,'',0.0000,0.0000,'','0000-00-00','0000-00-00','0000-00-00','',0,4.0000);
/*!40000 ALTER TABLE `pessoa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pessoa_alerta`
--

DROP TABLE IF EXISTS `pessoa_alerta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pessoa_alerta` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `aprovador_id` INT(11) UNSIGNED DEFAULT NULL,
  `pessoa_id` INT(11) UNSIGNED NOT NULL,
  `tipo_id` tinyint(3) UNSIGNED DEFAULT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `dt_aprovacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `descricao` VARCHAR(255) DEFAULT '',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_pessoa_alerta_user_id_idx` (`user_id`),
  KEY `fk_pessoa_alerta_aprovador_id_idx` (`aprovador_id`),
  KEY `fk_pessoa_alerta_pessoa_id_idx` (`pessoa_id`),
  CONSTRAINT `fk_pessoa_alerta_aprovador_id` FOREIGN KEY (`aprovador_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_pessoa_alerta_pessoa_id` FOREIGN KEY (`pessoa_id`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_pessoa_alerta_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pessoa_alerta`
--

LOCK TABLES `pessoa_alerta` WRITE;
/*!40000 ALTER TABLE `pessoa_alerta` DISABLE KEYS */;
INSERT INTO `pessoa_alerta` VALUES (2,1,1,3,0,'2016-01-12 20:13:05','2016-01-12 20:13:57','',0),(3,1,1,3,1,'2016-01-12 20:13:29','2016-01-12 20:14:22','',0),(4,1,NULL,3,0,'2016-01-12 20:14:54','0000-00-00 00:00:00','',0),(5,1,NULL,3,0,'2016-01-12 20:17:21','0000-00-00 00:00:00','',0),(6,1,1,5,1,'2016-01-13 12:05:14','2016-01-13 16:24:36','',0),(7,1,1,5,1,'2016-01-15 12:10:14','2016-01-15 12:11:07','',0),(8,1,1,3,0,'2016-01-15 12:16:44','2016-01-15 12:17:13','',0),(9,1,1,3,0,'2016-01-15 12:18:05','2016-02-02 19:57:35','',0),(10,1,1,3,0,'2016-01-15 12:20:06','2016-02-02 19:57:35','',0),(11,1,1,3,0,'2016-01-24 18:46:58','2016-02-02 19:57:35','',0),(12,1,1,3,0,'2016-01-25 21:49:10','2016-02-02 19:57:35','',0),(13,1,NULL,3,0,'2016-02-18 22:28:29','0000-00-00 00:00:00','',1),(14,1,NULL,3,0,'2016-02-25 19:33:02','0000-00-00 00:00:00','',1),(15,1,NULL,3,0,'2016-02-26 00:21:49','0000-00-00 00:00:00','',1),(16,1,NULL,3,0,'2016-02-26 16:31:46','0000-00-00 00:00:00','',1),(17,1,NULL,9,0,'2016-02-29 09:54:49','0000-00-00 00:00:00','',1),(18,1,NULL,3,0,'2016-02-29 09:57:43','0000-00-00 00:00:00','',1),(19,1,NULL,3,0,'2016-02-29 11:05:17','0000-00-00 00:00:00','',1),(20,1,NULL,3,0,'2016-02-29 22:31:26','0000-00-00 00:00:00','',1),(21,1,NULL,9,0,'2016-03-06 15:11:42','0000-00-00 00:00:00','',1),(22,1,NULL,9,0,'2016-03-06 15:13:30','0000-00-00 00:00:00','',1),(23,1,NULL,3,0,'2016-03-07 22:35:10','0000-00-00 00:00:00','',1),(24,1,NULL,9,0,'2016-03-08 14:50:48','0000-00-00 00:00:00','',1),(25,1,NULL,3,0,'2016-03-13 08:33:19','0000-00-00 00:00:00','',1),(26,9,NULL,3,0,'2016-03-22 22:54:11','0000-00-00 00:00:00','',1),(27,6,NULL,2,0,'2016-03-28 22:59:33','0000-00-00 00:00:00','',1);
/*!40000 ALTER TABLE `pessoa_alerta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pessoa_banco`
--

DROP TABLE IF EXISTS `pessoa_banco`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pessoa_banco` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pessoa_id` INT(11) UNSIGNED NOT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `padrao` tinyint(3) UNSIGNED DEFAULT NULL,
  `banco` INT(5) DEFAULT '1',
  `agencia` VARCHAR(10) DEFAULT '',
  `conta` VARCHAR(25) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `fk_pessoa_banco_pessoa_id_idx` (`pessoa_id`),
  CONSTRAINT `fk_pessoa_banco_pessoa_id` FOREIGN KEY (`pessoa_id`) REFERENCES `pessoa` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pessoa_banco`
--

LOCK TABLES `pessoa_banco` WRITE;
/*!40000 ALTER TABLE `pessoa_banco` DISABLE KEYS */;
INSERT INTO `pessoa_banco` VALUES (2,3,'0000-00-00 00:00:00',NULL,0,0,'5670','67890'),(5,2,'0000-00-00 00:00:00',NULL,0,0,'fasdf','fasdfasd');
/*!40000 ALTER TABLE `pessoa_banco` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pessoa_tipo`
--

DROP TABLE IF EXISTS `pessoa_tipo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pessoa_tipo` (
  `id` INT(11) UNSIGNED NOT NULL,
  `nome` VARCHAR(255) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pessoa_tipo`
--

LOCK TABLES `pessoa_tipo` WRITE;
/*!40000 ALTER TABLE `pessoa_tipo` DISABLE KEYS */;
INSERT INTO `pessoa_tipo` VALUES (0,'Ambos'),(1,'Cliente'),(2,'Fornecedor');
/*!40000 ALTER TABLE `pessoa_tipo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plano_conta_tipo`
--

DROP TABLE IF EXISTS `plano_conta_tipo`;
CREATE TABLE `plano_conta_tipo` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  `descricao` VARCHAR(255) DEFAULT '',
  `ordem` INT(5) DEFAULT '1',
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 PACK_KEYS=0;

--
-- Dumping data for table `plano_conta_tipo`
--

LOCK TABLES `plano_conta_tipo` WRITE;
/*!40000 ALTER TABLE `plano_conta_tipo` DISABLE KEYS */;
INSERT INTO `plano_conta_tipo` (
  `id`,
  `nome`,
  `descricao`,
  `ordem`,
  `ativo`,
  `dt_criacao`
) VALUES
( 3, 'Receitas Operacionais','',0,1,NOW() ),
( 4, 'Despesas Operacionais','',0,1,NOW() ),
( 5, 'Despesas Administrativas','',0,1,NOW() ),
( 6, 'Impostos à Recolher','',0,1,NOW() ),
( 7, 'Investimentos','',0,1,NOW() );
/*!40000 ALTER TABLE `plano_conta_tipo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plano_conta`
--

DROP TABLE IF EXISTS `plano_conta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `plano_conta` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nome` VARCHAR(255) DEFAULT '',
  `descricao` VARCHAR(255) DEFAULT '',
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tipo_id` INT(11) UNSIGNED DEFAULT NULL,
  `ativo` tinyint(3) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_plano_conta_tipo_id_idx` (`tipo_id`),
  CONSTRAINT `fk_plano_conta_tipo_id` FOREIGN KEY (`tipo_id`) REFERENCES `plano_conta_tipo` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plano_conta`
--

LOCK TABLES `plano_conta` WRITE;
/*!40000 ALTER TABLE `plano_conta` DISABLE KEYS */;

INSERT INTO `plano_conta` (
  `nome`,
  `descricao`,
  `dt_criacao`,
  `ativo`,
  `tipo_id`
) VALUES
( 'Aplicações Financeiras', '', NOW(), 1, 3 ),
( 'Cheques Próprios e/ou Duplicatas', '', NOW(), 1, 3 ),
( 'Cheques Terceiros', '', NOW(), 1, 3 ),
( 'Crédito Bancário', '', NOW(), 1, 3 ),
( 'Empréstimos', '', NOW(), 1, 3 ),
( 'Financiamentos', '', NOW(), 1, 3 ),
( 'Inv. Capital Próprio', '', NOW(), 1, 3 ),
( 'Inv. Capital Terceiros', '', NOW(), 1, 3 ),
( 'Locação', '', NOW(), 1, 3 ),
( 'Outros', '', NOW(), 1, 3 );

INSERT INTO `plano_conta` (
  `nome`,
  `descricao`,
  `dt_criacao`,
  `ativo`,
  `tipo_id`
) VALUES
( 'Combustível', '', NOW(), 1, 4 ),
( 'Comissões', '', NOW(), 1, 4 ),
( 'Consórcios', '', NOW(), 1, 4 ),
( 'Estacionamento', '', NOW(), 1, 4 ),
( 'Financiamentos', '', NOW(), 1, 4 ),
( 'Juros - Capital Próprio', '', NOW(), 1, 4 ),
( 'Juros - Capital Terceiro', '', NOW(), 1, 4 ),
( 'Serviços Cons. Financeira - Serasa', '', NOW(), 1, 4 ),
( 'Serviços de Despachantes', '', NOW(), 1, 4 ),
( 'Serviços de Tabelionato', '', NOW(), 1, 4 ),
( 'Tarifas Bancárias', '', NOW(), 1, 4 );

INSERT INTO `plano_conta` (
  `nome`,
  `descricao`,
  `dt_criacao`,
  `ativo`,
  `tipo_id`
) VALUES
( '13º Salário', '', NOW(), 1, 5 ),
( 'Água e Esgoto', '', NOW(), 1, 5 ),
( 'Aluguel de Imóvel', '', NOW(), 1, 5 ),
( 'Aluguel de Máquinas e Equipamentos', '', NOW(), 1, 5 ),
( 'Aluguel de Veículos', '', NOW(), 1, 5 ),
( 'Antecipação de Lucros', '', NOW(), 1, 5 ),
( 'Assistência Contábil', '', NOW(), 1, 5 ),
( 'Assistência Jurídica', '', NOW(), 1, 5 ),
( 'Assistência Médica e Social', '', NOW(), 1, 5 ),
( 'Contribuição Assistencial', '', NOW(), 1, 5 ),
( 'Contribuição Assossiativa', '', NOW(), 1, 5 ),
( 'Contribuição Confederativa', '', NOW(), 1, 5 ),
( 'Contribuição Sindical', '', NOW(), 1, 5 ),
( 'Energia Elétrica', '', NOW(), 1, 5 ),
( 'Férias ', '', NOW(), 1, 5 ),
( 'FGTS', '', NOW(), 1, 5 ),
( 'INSS', '', NOW(), 1, 5 ),
( 'IR (sobre folha de pagamento)', '', NOW(), 1, 5 ),
( 'Livros, Jornais e Revistas', '', NOW(), 1, 5 ),
( 'Material de Escritório', '', NOW(), 1, 5 ),
( 'Material de Higiene e Limpeza', '', NOW(), 1, 5 ),
( 'Pró Labore', '', NOW(), 1, 5 ),
( 'Rescisão Trabalhista', '', NOW(), 1, 5 ),
( 'Salários', '', NOW(), 1, 5 ),
( 'Serv. Limpeza e Conservação', '', NOW(), 1, 5 ),
( 'Serv. Manutenção Predial', '', NOW(), 1, 5 ),
( 'Serv. Postal e Telegráfico', '', NOW(), 1, 5 ),
( 'Serv. Tabelionato', '', NOW(), 1, 5 ),
( 'Serv. Tecnologia e Informação (T.I)', '', NOW(), 1, 5 ),
( 'Telefonia Fixa + Serv. Internet', '', NOW(), 1, 5 ),
( 'Telefonia Móvel', '', NOW(), 1, 5 ),
( 'Vale Refeição', '', NOW(), 1, 5 ),
( 'Vale Transporte', '', NOW(), 1, 5 );

INSERT INTO `plano_conta` (
  `nome`,
  `descricao`,
  `dt_criacao`,
  `ativo`,
  `tipo_id`
) VALUES
( 'Cofins à recolher', '', NOW(), 1, 6 ),
( 'CRF à recolher', '', NOW(), 1, 6 ),
( 'CSLL à recolher', '', NOW(), 1, 6 ),
( 'FIA à recolher', '', NOW(), 1, 6 ),
( 'Funrejus', '', NOW(), 1, 6 ),
( 'FUNRURAL à recolher', '', NOW(), 1, 6 ),
( 'ICMS à recolher', '', NOW(), 1, 6 ),
( 'IRPJ à recolher', '', NOW(), 1, 6 ),
( 'IRRF à recolher', '', NOW(), 1, 6 ),
( 'ISS à recolher', '', NOW(), 1, 6 ),
( 'ITBI', '', NOW(), 1, 6 ),
( 'PIS à recolher', '', NOW(), 1, 6 ),
( 'REFIS à recolher', '', NOW(), 1, 6 ),
( 'Subst. Tributária à recolher', '', NOW(), 1, 6 );

INSERT INTO `plano_conta` (
  `nome`,
  `descricao`,
  `dt_criacao`,
  `ativo`,
  `tipo_id`
) VALUES
( 'Aplicações Financeiras', '', NOW(), 1, 7 ),
( 'Consórcios', '', NOW(), 1, 7 );

/*!40000 ALTER TABLE `plano_conta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `simulador`
--

DROP TABLE IF EXISTS `simulador`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `simulador` (
  `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `plano_receber_id` INT(11) UNSIGNED NOT NULL,
  `plano_pagar_id` INT(11) UNSIGNED NOT NULL,
  `nome` VARCHAR(255) DEFAULT '',
  `dt_criacao` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dt_atualizado` TIMESTAMP NULL DEFAULT NULL,
  `situacao` tinyint(3) UNSIGNED DEFAULT NULL,
  `ativo` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fk_simulador_user_id_idx` (`user_id`),
  KEY `fk_simulador_plano_receber_id_idx` (`plano_receber_id`),
  KEY `fk_simulador_plano_pagar_id_idx` (`plano_pagar_id`),
  CONSTRAINT `fk_simulador_plano_pagar_id` FOREIGN KEY (`plano_pagar_id`) REFERENCES `plano_conta` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_simulador_plano_receber_id` FOREIGN KEY (`plano_receber_id`) REFERENCES `plano_conta` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_simulador_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `simulador`
--

LOCK TABLES `simulador` WRITE;
/*!40000 ALTER TABLE `simulador` DISABLE KEYS */;
INSERT INTO `simulador` VALUES
(1,1,2,1,'Valor Parcela','2016-02-18 23:09:49','2016-02-18 23:09:56',NULL,1),
(2,1,2,1,'Quantidade de Parcelas','2016-02-18 23:11:35','2016-02-18 23:11:39',NULL,1),
(3,1,2,1,'Valor Financiado','2016-02-18 23:12:34','2016-02-18 23:12:39',NULL,1),
(4,1,2,1,'Taxa de Juros','2016-02-18 23:13:19','2016-02-18 23:13:34',NULL,1),
(5,1,2,1,'Cheque Próprio','2016-02-18 23:13:19','2016-02-18 23:13:34',NULL,1),
(6,1,2,1,'Cheque Terceiro','2016-02-18 23:13:19','2016-02-18 23:13:34',NULL,1);
/*!40000 ALTER TABLE `simulador` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipo_pessoa`
--

DROP TABLE IF EXISTS `tipo_pessoa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tipo_pessoa` (
  `id` INT(11) UNSIGNED NOT NULL,
  `nome` VARCHAR(255) DEFAULT '',
  `abrev` VARCHAR(5) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipo_pessoa`
--

LOCK TABLES `tipo_pessoa` WRITE;
/*!40000 ALTER TABLE `tipo_pessoa` DISABLE KEYS */;
INSERT INTO `tipo_pessoa` VALUES (0,'Pessoa Física','PF'),(1,'Pessoa Jurídica','PJ');
/*!40000 ALTER TABLE `tipo_pessoa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `password` VARCHAR(60) NOT NULL,
  `remember_token` VARCHAR(100) DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tipo_id` INT(1) DEFAULT '0' COMMENT 'user operador = 0 ou gerente = 1 ou admin = 2\n',
  `ativo` INT(1) DEFAULT '1' COMMENT 'user está ativo = 1 ou desativado = 0\n',
  `reset_token` VARCHAR(100) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 PACK_KEYS=0;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Administrador','hpbrasileiro@hotmail.com','$2y$10$ZwUzFsRNDDDh6uu/qD9ZruegyG83CZPHBBD8WoV8aKVgUmrEaOGl.','HGj4pqNHGMJCRkIvFKJJbjKdrZQGxchqGEd8qi8x9z9AbA58NcNEXgF7Myhl','2015-12-24 07:52:00','2016-03-28 10:47:33',1,1,''),(6,'Denis Bernardo','denis@nerdly.com.br','$2y$10$frckHEvRFqZFdT6SmLYTAeENpUQOcYjy4W/lUZAhPCxq85ciCXafm','3OlwMeX3cc3hIyavsNimuVCRJ0a5eWMVMlJQhxZJSpKB18bwCsBOUkSdItmg','2016-02-03 23:26:18','2016-03-28 23:42:40',1,1,''),(9,'Gerente','hpbrasileiro@gmail.com','$2y$10$N9a9tbRTG8Niht1k3CuVjueGOAeHcb4AWyxgxeOJfQf.q6ZP4DAjm','sQ1uBcFzK81jrGcWNsAB6i77F5umWd2OL6mQtETjmrqcOphXUElc1qnzLnBZ','2016-02-25 20:07:24','2016-03-22 23:00:59',1,1,''),(10,'Denis Operador','denis302010@gmail.com','$2y$10$99AYGY1qRZwGXK.KdtwXyOesHqx3HsBnsHRf2tygd6poDTjAnWQ.W','QksNpp3k6udHzKKUWVFJzWC6DSf6jNWR8Kw5WqLTa0EqaRF8Zu3DjTCySWzs','2016-03-22 02:14:19','2016-03-28 10:49:04',0,1,'');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-03-31  3:12:05