
#
# Criação da Tabela : tb_aconselhamentos
#

CREATE TABLE `tb_aconselhamentos` (
  `id_aconselhamento` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `texto` text NOT NULL,
  `data_aconselhamento` datetime NOT NULL,
  `id_usuario` int(11) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_aconselhamento`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_aconselhamentos VALUES ( '2', '6', 'teste', '2015-03-10 21:30:00', '94', '2015-03-10 20:35:36', '2015-03-10 21:37:36');

#
# Criação da Tabela : tb_app_conversas
#

CREATE TABLE `tb_app_conversas` (
  `id_conversa` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `id_usuario` int(11) NOT NULL,
  `texto` text NOT NULL,
  `paroquia_visualizou` varchar(250) NOT NULL,
  `membro_visualizou` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_conversa`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_app_conversas VALUES ( '1', '39', '0', 'Olá tudo bem?', 'sim', '', '2016-04-14 05:38:20', '2016-04-14 19:12:37');
INSERT INTO tb_app_conversas VALUES ( '2', '39', '2', 'Tudo ótimo e com vc?', 'sim', '', '2016-04-14 05:38:20', '2016-04-14 19:12:37');
INSERT INTO tb_app_conversas VALUES ( '3', '39', '94', 'Teste de inserção.', 'sim', '', '2016-04-14 17:09:14', '2016-04-14 19:09:14');
INSERT INTO tb_app_conversas VALUES ( '4', '39', '94', 'Olá, sua solicitação (Alteração de dados) não pode ser atendida, favor entrar em contato com a congregação.', 'sim', '', '2016-04-14 17:27:19', '2016-04-14 19:27:19');
INSERT INTO tb_app_conversas VALUES ( '5', '39', '94', 'Olá, sua solicitação (Alteração de dados) foi atendida.', 'sim', '', '2016-04-15 01:26:33', '2016-04-15 03:26:33');
INSERT INTO tb_app_conversas VALUES ( '6', '39', '0', '(null)', 'sim', 'sim', '2016-04-15 02:23:22', '2016-04-15 04:30:51');
INSERT INTO tb_app_conversas VALUES ( '7', '39', '0', 'Teste 2', 'sim', 'sim', '2016-04-15 02:25:42', '2016-04-15 04:30:51');
INSERT INTO tb_app_conversas VALUES ( '8', '39', '0', 'afae', 'sim', 'sim', '2016-04-15 02:25:56', '2016-04-15 04:30:51');
INSERT INTO tb_app_conversas VALUES ( '9', '39', '0', 'afaefaefa for efa fear Rafa Edward ', 'sim', 'sim', '2016-04-15 02:26:04', '2016-04-15 04:30:51');
INSERT INTO tb_app_conversas VALUES ( '10', '39', '94', 'Blaaaaa', 'sim', '', '2016-04-15 02:31:11', '2016-04-15 04:31:11');
INSERT INTO tb_app_conversas VALUES ( '11', '39', '94', 'blaaaa 2', 'sim', '', '2016-04-15 02:31:30', '2016-04-15 04:31:30');
INSERT INTO tb_app_conversas VALUES ( '12', '39', '0', 'sff', 'sim', 'sim', '2016-04-15 02:35:54', '2016-04-15 09:57:33');
INSERT INTO tb_app_conversas VALUES ( '13', '39', '94', 'OIá Christian', 'sim', '', '2016-04-15 07:58:12', '2016-04-15 09:58:12');
INSERT INTO tb_app_conversas VALUES ( '14', '39', '0', 'ola ', 'sim', 'sim', '2016-04-15 07:59:41', '2016-04-15 09:59:42');
INSERT INTO tb_app_conversas VALUES ( '15', '39', '94', 'Testeeeeeeeeeeeeeeeeeeeee', 'sim', '', '2016-04-15 07:59:50', '2016-04-15 09:59:50');
INSERT INTO tb_app_conversas VALUES ( '16', '39', '94', 'Teste 2', 'sim', '', '2016-04-15 08:00:13', '2016-04-15 10:00:13');
INSERT INTO tb_app_conversas VALUES ( '17', '39', '0', 'djjdfg', 'sim', 'sim', '2016-04-15 11:22:48', '2016-04-19 17:07:48');
INSERT INTO tb_app_conversas VALUES ( '18', '39', '94', 'Olá, sua solicitação (Alteração de dados) não pôde ser atendida, favor entrar em contato com a congregação.', 'sim', '', '2016-04-19 10:47:05', '2016-04-19 12:47:05');
INSERT INTO tb_app_conversas VALUES ( '19', '39', '94', 'Olá, sua solicitação (Alteração de dados) foi atendida.', 'sim', '', '2016-04-19 10:47:25', '2016-04-19 12:47:25');
INSERT INTO tb_app_conversas VALUES ( '20', '39', '94', 'Olá, sua solicitação (Alteração de dados) não pôde ser atendida, favor entrar em contato com a congregação.', 'sim', '', '2016-04-19 14:41:12', '2016-04-19 16:41:12');
INSERT INTO tb_app_conversas VALUES ( '21', '39', '94', 'Olá, sua solicitação (Alteração de dados) foi atendida.', 'sim', '', '2016-04-19 15:06:49', '2016-04-19 17:06:49');
INSERT INTO tb_app_conversas VALUES ( '22', '39', '94', 'oi', 'sim', '', '2016-04-19 15:07:56', '2016-04-19 17:07:56');
INSERT INTO tb_app_conversas VALUES ( '23', '39', '94', 'Olá, sua solicitação (Alteração de dados) foi atendida.', 'sim', '', '2016-04-20 17:59:52', '2016-04-20 19:59:52');
INSERT INTO tb_app_conversas VALUES ( '24', '39', '0', 'ola', 'sim', 'sim', '2016-04-20 18:44:05', '2016-04-20 20:44:07');

#
# Criação da Tabela : tb_app_solicitacoes
#

CREATE TABLE `tb_app_solicitacoes` (
  `id_solicitacao` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `texto` text NOT NULL,
  `situacao` varchar(250) NOT NULL,
  `paroquia_visualizou` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_solicitacao`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_app_solicitacoes VALUES ( '1', '39', 'Alteração de dados', 'Solicito alteração do meu nome para João.', 'Rejeitada', 'sim', '2016-04-14 09:24:12', '2016-04-14 19:27:19');
INSERT INTO tb_app_solicitacoes VALUES ( '7', '39', 'Alteração de dados', 'teste', 'Encerrada', 'sim', '2016-04-15 01:26:05', '2016-04-15 03:26:32');
INSERT INTO tb_app_solicitacoes VALUES ( '8', '39', 'Alteração de dados', 'adicionar telefone: 30660669', '', '', '2016-04-15 08:04:10', '2016-04-15 10:04:10');
INSERT INTO tb_app_solicitacoes VALUES ( '9', '39', 'Alteração de dados', 'dhgfd', '', '', '2016-04-19 10:40:00', '2016-04-19 12:40:00');
INSERT INTO tb_app_solicitacoes VALUES ( '10', '39', 'Alteração de dados', 'solicto apagar tudo', 'Encerrada', 'sim', '2016-04-19 10:46:13', '2016-04-19 12:47:25');
INSERT INTO tb_app_solicitacoes VALUES ( '11', '39', 'Alteração de dados', 'meu teleefone mudou', 'Rejeitada', 'sim', '2016-04-19 14:40:45', '2016-04-19 16:41:11');
INSERT INTO tb_app_solicitacoes VALUES ( '12', '39', 'Alteração de dados', 'aaaaas', 'Encerrada', 'sim', '2016-04-19 15:06:31', '2016-04-19 17:06:48');
INSERT INTO tb_app_solicitacoes VALUES ( '13', '39', 'Alteração de dados', 'estou semvendereco', 'Encerrada', 'sim', '2016-04-20 17:59:26', '2016-04-20 19:59:52');

#
# Criação da Tabela : tb_auxiliar_atividades
#

CREATE TABLE `tb_auxiliar_atividades` (
  `id_atividade` int(11) NOT NULL AUTO_INCREMENT,
  `ativo` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `cor` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_atividade`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_auxiliar_atividades VALUES ( '1', 'sim', 'Grupo de estudo - PEM', '00eeff', '0000-00-00 00:00:00', '2015-03-17 19:29:33');
INSERT INTO tb_auxiliar_atividades VALUES ( '2', 'sim', 'Visita', 'a30000', '0000-00-00 00:00:00', '2015-03-17 19:29:36');
INSERT INTO tb_auxiliar_atividades VALUES ( '3', 'sim', 'Culto', '0060c7', '2015-03-17 15:39:01', '2015-03-17 19:29:38');
INSERT INTO tb_auxiliar_atividades VALUES ( '4', 'sim', 'Casamento luterano', 'c9ac1e', '2015-03-17 17:17:59', '2015-03-17 19:29:41');
INSERT INTO tb_auxiliar_atividades VALUES ( '5', 'sim', 'Casamento misto', 'f07211', '2015-03-17 17:18:13', '2015-03-17 19:29:45');
INSERT INTO tb_auxiliar_atividades VALUES ( '6', 'sim', 'Reunião', '32b000', '2015-04-09 12:45:50', '2015-06-16 11:16:37');
INSERT INTO tb_auxiliar_atividades VALUES ( '7', 'sim', 'Retiro', 'a6a6a6', '2015-04-09 12:46:09', '2015-04-09 13:46:09');
INSERT INTO tb_auxiliar_atividades VALUES ( '8', 'sim', 'Passeio', '9ed678', '2015-04-09 12:46:21', '2015-04-09 13:46:21');
INSERT INTO tb_auxiliar_atividades VALUES ( '9', 'sim', 'Encontro', 'ff0000', '2015-04-09 12:50:58', '2015-04-09 13:50:58');
INSERT INTO tb_auxiliar_atividades VALUES ( '10', 'sim', 'Visita pastoral', 'a30000', '0000-00-00 00:00:00', '2015-06-11 23:44:30');
INSERT INTO tb_auxiliar_atividades VALUES ( '11', 'sim', 'Visita à enfermos', 'a30000', '0000-00-00 00:00:00', '2015-06-11 23:44:30');
INSERT INTO tb_auxiliar_atividades VALUES ( '12', 'sim', 'Visita missionária', 'a30000', '0000-00-00 00:00:00', '2015-06-11 23:44:30');

#
# Criação da Tabela : tb_auxiliar_departamentos
#

CREATE TABLE `tb_auxiliar_departamentos` (
  `id_departamento` int(11) NOT NULL AUTO_INCREMENT,
  `ativo` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_departamento`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_auxiliar_departamentos VALUES ( '1', 'sim', 'Música
', '0000-00-00 00:00:00', '2015-02-06 08:05:34');
INSERT INTO tb_auxiliar_departamentos VALUES ( '2', 'sim', 'Servas', '2015-02-18 12:50:36', '2015-02-18 15:50:36');
INSERT INTO tb_auxiliar_departamentos VALUES ( '3', 'sim', 'Crianças', '2015-03-17 17:28:12', '2015-03-17 18:28:12');
INSERT INTO tb_auxiliar_departamentos VALUES ( '4', 'sim', 'Instrução', '2015-03-17 17:28:17', '2015-03-17 18:28:17');
INSERT INTO tb_auxiliar_departamentos VALUES ( '5', 'sim', 'Juventude Mirim', '2015-03-17 17:28:31', '2015-03-17 18:28:31');
INSERT INTO tb_auxiliar_departamentos VALUES ( '6', 'sim', 'Jovens', '2015-03-17 17:28:41', '2015-03-17 18:28:41');
INSERT INTO tb_auxiliar_departamentos VALUES ( '7', 'sim', 'Homens', '2015-03-17 17:28:51', '2015-03-17 18:28:51');
INSERT INTO tb_auxiliar_departamentos VALUES ( '8', 'sim', 'Casais / Famílias / Noivos', '2015-03-17 17:28:54', '2015-03-17 18:28:54');
INSERT INTO tb_auxiliar_departamentos VALUES ( '9', 'sim', 'Terceira Idade', '2015-03-17 17:29:01', '2015-03-17 18:29:01');
INSERT INTO tb_auxiliar_departamentos VALUES ( '10', 'sim', 'Áreas de atuação', '2015-03-17 17:29:11', '2015-03-17 18:29:11');
INSERT INTO tb_auxiliar_departamentos VALUES ( '11', 'sim', 'Diretoria / Administração', '2015-03-17 17:29:18', '2015-03-17 18:29:18');
INSERT INTO tb_auxiliar_departamentos VALUES ( '12', 'sim', 'Comunicação', '2015-04-07 18:03:23', '2015-04-07 19:03:23');

#
# Criação da Tabela : tb_centro_custos
#

CREATE TABLE `tb_centro_custos` (
  `id_centro_custo` int(11) NOT NULL AUTO_INCREMENT,
  `ativo` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_centro_custo`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_centro_custos VALUES ( '1', 'sim', 'Ofertas Dominicais', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:57:26');
INSERT INTO tb_centro_custos VALUES ( '2', 'sim', 'Ofertas Mensais, Anuais (regulares)', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:57:29');
INSERT INTO tb_centro_custos VALUES ( '3', 'sim', 'Ofertas Especiais', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:57:31');
INSERT INTO tb_centro_custos VALUES ( '4', 'sim', 'Ofertas de Terceiros', 'A receber', '2014-09-05 16:05:52', '2015-04-06 17:42:25');
INSERT INTO tb_centro_custos VALUES ( '5', 'sim', 'Campanhas Específicas', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:06');
INSERT INTO tb_centro_custos VALUES ( '6', 'sim', 'Auxílio de Outros', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:58:06');
INSERT INTO tb_centro_custos VALUES ( '7', 'sim', 'Subsídio da IELB', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:57:51');
INSERT INTO tb_centro_custos VALUES ( '8', 'sim', 'Auxílio do FAPI', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:57:48');
INSERT INTO tb_centro_custos VALUES ( '9', 'sim', 'Subsídio do Distrito', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:57:46');
INSERT INTO tb_centro_custos VALUES ( '10', 'sim', 'Auxílio do Distrito Padrinho', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:57:44');
INSERT INTO tb_centro_custos VALUES ( '11', 'sim', 'Receita de Aluguéis', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:09');
INSERT INTO tb_centro_custos VALUES ( '12', 'sim', 'Receita de Promoções', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:11');
INSERT INTO tb_centro_custos VALUES ( '13', 'sim', 'Receita da Escola', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:13');
INSERT INTO tb_centro_custos VALUES ( '14', 'sim', 'Receita para Serviço Social', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:15');
INSERT INTO tb_centro_custos VALUES ( '15', 'sim', 'Ressarcimentos', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:18');
INSERT INTO tb_centro_custos VALUES ( '16', 'sim', 'Outras entradas', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:21');
INSERT INTO tb_centro_custos VALUES ( '17', 'sim', 'Empréstimos', 'A receber', '2014-09-05 16:05:52', '2015-03-17 18:59:24');
INSERT INTO tb_centro_custos VALUES ( '18', 'sim', 'Auxílio Subsistência de Pastores', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:27');
INSERT INTO tb_centro_custos VALUES ( '19', 'sim', 'Despesas com Estagiários', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:30');
INSERT INTO tb_centro_custos VALUES ( '20', 'sim', 'Pagamentos a outras pessoas', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:32');
INSERT INTO tb_centro_custos VALUES ( '21', 'sim', 'INSS', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:34');
INSERT INTO tb_centro_custos VALUES ( '22', 'sim', 'Fundo de Garantia e FPP', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:36');
INSERT INTO tb_centro_custos VALUES ( '23', 'sim', 'Adicionais política de subsistência', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:40');
INSERT INTO tb_centro_custos VALUES ( '24', 'sim', 'Gratificação de Natal e férias', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:43');
INSERT INTO tb_centro_custos VALUES ( '25', 'sim', 'Assist. Médica, Prev. Privada', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:46');
INSERT INTO tb_centro_custos VALUES ( '26', 'sim', 'Aquisição de Propriedades', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:49');
INSERT INTO tb_centro_custos VALUES ( '27', 'sim', 'Construção e Reforma', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:52');
INSERT INTO tb_centro_custos VALUES ( '28', 'sim', 'Conservação de propriedades', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:54');
INSERT INTO tb_centro_custos VALUES ( '29', 'sim', 'Aquisição de equipamentos', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:57');
INSERT INTO tb_centro_custos VALUES ( '30', 'sim', 'Impostos (IPTU,  etc.)', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 18:59:59');
INSERT INTO tb_centro_custos VALUES ( '31', 'sim', 'Material Missionário', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:04');
INSERT INTO tb_centro_custos VALUES ( '32', 'sim', 'Contribuição para a IELB', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:07');
INSERT INTO tb_centro_custos VALUES ( '33', 'sim', 'Contribuição para o Distrito', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:10');
INSERT INTO tb_centro_custos VALUES ( '34', 'sim', 'Contribuição para o FAPI', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:14');
INSERT INTO tb_centro_custos VALUES ( '35', 'sim', 'Contribuição para Outros', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:16');
INSERT INTO tb_centro_custos VALUES ( '36', 'sim', 'Auxílio para Congregação Afilhada', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:19');
INSERT INTO tb_centro_custos VALUES ( '37', 'sim', 'Despesas da Escola', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:23');
INSERT INTO tb_centro_custos VALUES ( '38', 'sim', 'Saídas para Serviço Social', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:26');
INSERT INTO tb_centro_custos VALUES ( '39', 'sim', 'Despesas com Comunicação', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:29');
INSERT INTO tb_centro_custos VALUES ( '40', 'sim', 'Seguro de vida e propriedades', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:40');
INSERT INTO tb_centro_custos VALUES ( '41', 'sim', 'Transporte', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:46');
INSERT INTO tb_centro_custos VALUES ( '42', 'sim', 'Moradia', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:00:53');
INSERT INTO tb_centro_custos VALUES ( '43', 'sim', 'Aluguel de local de cultos', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:02');
INSERT INTO tb_centro_custos VALUES ( '44', 'sim', 'Luz', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:05');
INSERT INTO tb_centro_custos VALUES ( '45', 'sim', 'Água', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:08');
INSERT INTO tb_centro_custos VALUES ( '46', 'sim', 'Telefone, Fax, Internet', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:12');
INSERT INTO tb_centro_custos VALUES ( '47', 'sim', 'Material de Expediente', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:16');
INSERT INTO tb_centro_custos VALUES ( '48', 'sim', 'Participação em Eventos', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:18');
INSERT INTO tb_centro_custos VALUES ( '49', 'sim', 'Outras saídas', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:22');
INSERT INTO tb_centro_custos VALUES ( '50', 'sim', 'Devolução de Empréstimos', 'A pagar', '2014-09-05 16:09:50', '2015-03-17 19:01:29');
INSERT INTO tb_centro_custos VALUES ( '72', 'sim', 'Internet 4g', 'A pagar', '2015-04-07 08:41:40', '2015-04-07 09:41:40');

#
# Criação da Tabela : tb_centro_custos2
#

CREATE TABLE `tb_centro_custos2` (
  `id_centro_custo2` int(11) NOT NULL AUTO_INCREMENT,
  `id_centro_custo` int(11) NOT NULL,
  `ativo` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_centro_custo2`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_centro_custos2 VALUES ( '2', '45', 'sim', 'Água Igreja', '2016-02-18 06:34:24', '2017-01-06 11:04:40');
INSERT INTO tb_centro_custos2 VALUES ( '3', '45', 'sim', 'Água casa pastoral', '2016-02-18 06:34:32', '2017-01-06 11:04:55');

#
# Criação da Tabela : tb_congregacoes
#

CREATE TABLE `tb_congregacoes` (
  `id_congregacao` int(11) NOT NULL AUTO_INCREMENT,
  `sede` varchar(5) NOT NULL,
  `cnpj` varchar(250) NOT NULL,
  `razao_social` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `tipo` varchar(250) NOT NULL COMMENT 'Congregação (CG), comunidade (CM), igreja (I), ponto de missão/pregação (P)',
  `emails` text NOT NULL,
  `telefones` text NOT NULL,
  `endereco` varchar(250) NOT NULL,
  `numero` varchar(250) NOT NULL,
  `complemento` varchar(250) NOT NULL,
  `cep` varchar(250) NOT NULL,
  `bairro` varchar(250) NOT NULL,
  `cidade` varchar(250) NOT NULL,
  `estado` varchar(250) NOT NULL,
  `data_fundacao` date NOT NULL,
  `data_inauguracao_templo` date NOT NULL,
  `local_cultos` varchar(250) NOT NULL COMMENT 'templo, salão, escola, casa, outro',
  `periodo_cultos` varchar(250) NOT NULL COMMENT 'Semanal, 2x mês, 3x mês, Mensal, Outro',
  `horarios_cultos` varchar(300) NOT NULL,
  `encerramento_atividades_data` date NOT NULL,
  `encerramento_atividades_motivo` text NOT NULL,
  `data_inicio_trabalhos` date NOT NULL,
  `pastor_fundador` varchar(250) NOT NULL,
  `membros_fundadores` text NOT NULL,
  `data_primeiro_culto` date NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_congregacao`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_congregacoes VALUES ( '5', 'sim', '99.999.999/9999-99', 'Cristo Redentor', 'Cristo Redentor', 'CG', 'contato@cristoredentor.com.br', '(51) 3030.2322', 'Rua Miguel Couto', '12', 'sala 03', '93320-040', 'Centro', 'Novo Hamburgo', 'RS', '1990-08-16', '2004-03-10', 'Templo', 'Semanal', 'Sábado 20h e Domingo 9h', '0000-00-00', '', '2004-03-11', 'Alfredo Witzburger', '', '2004-03-11', '2014-12-11 19:04:23', '2015-04-08 16:21:13');
INSERT INTO tb_congregacoes VALUES ( '7', 'nao', '00.000.000/0000-00', 'Ebenézer', 'Ebenézer', 'CM', 'comunidadeebenezer@hotmail.com', '(51) 3029.3135', 'Rua Monte Alegre', '182', '', '93334-400', 'Ideal', 'Novo Hamburgo', 'RS', '2001-02-20', '2001-02-20', 'Salão', '2x mês', 'Sábado 18h30', '0000-00-00', '', '2001-02-20', 'Gerson Túlio Schmidt', '', '2001-02-20', '2015-04-01 15:56:13', '2015-04-01 16:56:13');

#
# Criação da Tabela : tb_contas_bancarias
#

CREATE TABLE `tb_contas_bancarias` (
  `id_conta_bancaria` int(11) NOT NULL AUTO_INCREMENT,
  `ativo` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `agencia` varchar(250) NOT NULL,
  `conta` varchar(250) NOT NULL,
  `saldo` decimal(15,2) NOT NULL,
  `limite` decimal(15,2) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_conta_bancaria`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_contas_bancarias VALUES ( '2', 'sim', 'Sicredi', '0101', '14392-7', '2484.00', '400.00', '2014-12-29 23:02:45', '2016-03-30 15:35:01');
INSERT INTO tb_contas_bancarias VALUES ( '3', 'sim', 'Bradesco', '0139', '1230101-9', '7001.07', '311.11', '2015-04-01 16:39:18', '2016-04-13 11:39:10');
INSERT INTO tb_contas_bancarias VALUES ( '4', 'sim', 'Caixa interno', '00000', '0', '2830.00', '0.00', '2015-04-07 08:39:52', '2016-04-20 21:07:25');

#
# Criação da Tabela : tb_contas_bancarias_ajustes
#

CREATE TABLE `tb_contas_bancarias_ajustes` (
  `id_ajuste` int(11) NOT NULL AUTO_INCREMENT,
  `operador` varchar(250) NOT NULL,
  `id_conta_bancaria` int(11) NOT NULL,
  `data` date NOT NULL,
  `valor` decimal(15,2) NOT NULL,
  `motivo` text NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_ajuste`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_contas_bancarias_ajustes VALUES ( '4', 'Suporte F5 SAPI', '3', '2016-03-17', '5.00', 'testes2', '2016-03-17 15:56:37', '2016-03-17 17:56:37');
INSERT INTO tb_contas_bancarias_ajustes VALUES ( '5', 'Suporte F5 SAPI', '3', '2016-03-17', '-0.60', 'teste 3', '2016-03-17 15:57:38', '2016-03-17 17:57:38');

#
# Criação da Tabela : tb_cronicas_acontecimentos
#

CREATE TABLE `tb_cronicas_acontecimentos` (
  `id_acontecimento` int(11) NOT NULL AUTO_INCREMENT,
  `id_congregacao` int(11) NOT NULL,
  `texto` text NOT NULL,
  `data_acontecimento` datetime NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_acontecimento`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_cronicas_acontecimentos VALUES ( '1', '6', 'teste', '2014-12-31 14:20:00', '2014-12-27 22:02:28', '2015-03-10 22:21:21');
INSERT INTO tb_cronicas_acontecimentos VALUES ( '2', '5', 'fiaefihfaleihfaeifhaiehfiah', '2016-04-20 11:03:00', '2016-04-20 09:03:41', '2016-04-20 11:03:41');

#
# Criação da Tabela : tb_diretoria_paroquial
#

CREATE TABLE `tb_diretoria_paroquial` (
  `id_diretoria` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) DEFAULT NULL,
  `funcao` varchar(250) NOT NULL COMMENT 'Presidente, Secretário, Tesoureiro, Pastor',
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_diretoria`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_diretoria_paroquial VALUES ( '3', '26', 'Tesoureiro', '2015-04-07 08:37:52', '2015-04-07 09:37:52');
INSERT INTO tb_diretoria_paroquial VALUES ( '4', '18', 'Presidente', '2015-04-07 17:50:24', '2015-04-07 18:50:24');

#
# Criação da Tabela : tb_eventos
#

CREATE TABLE `tb_eventos` (
  `id_evento` int(11) NOT NULL AUTO_INCREMENT,
  `id_grupo` int(11) NOT NULL,
  `id_atividade` int(11) NOT NULL,
  `id_departamento` int(11) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `descricao` text NOT NULL,
  `pastoral` text NOT NULL,
  `coordenador` int(11) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_congregacao` int(11) NOT NULL,
  PRIMARY KEY (`id_evento`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_eventos VALUES ( '1', '0', '2', '0', 'teste', '', '', '0', '2016-02-19 07:14:36', '2016-02-19 11:14:36', '5');
INSERT INTO tb_eventos VALUES ( '2', '0', '6', '0', 'teste 2', '', '', '0', '2016-02-19 07:16:15', '2016-02-19 11:16:15', '5');
INSERT INTO tb_eventos VALUES ( '3', '0', '9', '0', 'aaa', '', '', '0', '2016-02-19 10:43:14', '2016-02-19 14:43:14', '5');
INSERT INTO tb_eventos VALUES ( '4', '0', '3', '0', 'Culto', '', '', '0', '2016-03-30 09:37:42', '2016-03-30 11:37:42', '5');
INSERT INTO tb_eventos VALUES ( '5', '10', '0', '1', 'Grupo Vocal', '', '', '37', '2016-03-30 13:09:28', '2016-03-30 15:09:28', '5');
INSERT INTO tb_eventos VALUES ( '6', '11', '7', '0', 'grupo de testes', '', '', '20', '2016-04-13 15:04:02', '2016-04-13 17:18:23', '5');
INSERT INTO tb_eventos VALUES ( '7', '0', '10', '0', 'Visita família Tiago Silveira', '', '', '0', '2016-04-20 09:08:50', '2016-04-20 11:08:50', '5');
INSERT INTO tb_eventos VALUES ( '8', '0', '10', '0', 'Visita família Tiago Silveira', '', '', '0', '2016-04-20 09:18:01', '2016-04-20 11:18:01', '5');
INSERT INTO tb_eventos VALUES ( '9', '0', '1', '0', 'grupo do pem', '', '', '0', '2016-04-20 16:20:11', '2016-04-20 18:20:11', '7');
INSERT INTO tb_eventos VALUES ( '10', '12', '0', '10', 'grupo do pem', '', '', '20', '2016-04-20 16:21:43', '2016-04-20 18:21:43', '5');
INSERT INTO tb_eventos VALUES ( '11', '0', '3', '0', 'Culto', '', '', '0', '2017-01-04 16:30:37', '2017-01-04 20:30:37', '5');
INSERT INTO tb_eventos VALUES ( '12', '0', '3', '0', 'Culto', 'Teste de descrição', '', '0', '2017-01-05 14:36:28', '2017-01-05 18:36:28', '5');
INSERT INTO tb_eventos VALUES ( '13', '0', '3', '0', 'Culto especial', '', '', '0', '2017-08-18 20:35:42', '2017-08-18 20:35:42', '5');
INSERT INTO tb_eventos VALUES ( '14', '0', '10', '0', 'Visita pastoral', '', '', '0', '2017-08-18 20:41:59', '2017-08-18 20:41:59', '5');

#
# Criação da Tabela : tb_eventos_datas
#

CREATE TABLE `tb_eventos_datas` (
  `id_data` int(11) NOT NULL AUTO_INCREMENT,
  `id_evento` int(11) NOT NULL,
  `id_grupo` int(11) NOT NULL,
  `periodicidade` varchar(250) NOT NULL,
  `dia_semana` varchar(250) NOT NULL,
  `dia` date NOT NULL,
  `horario_inicial` time NOT NULL,
  `horario_final` time NOT NULL,
  `data_inicial` datetime NOT NULL,
  `data_final` datetime NOT NULL,
  `hinos` varchar(250) NOT NULL,
  `santa_ceia` varchar(250) NOT NULL DEFAULT 'nao',
  `observacao` text NOT NULL,
  `total_membros` int(11) NOT NULL,
  `total_visitantes` int(11) NOT NULL,
  `total_santa_ceia` int(11) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_data`)
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_eventos_datas VALUES ( '1', '3', '0', '', '', '2016-02-18', '19:00:00', '22:00:00', '2016-02-18 19:00:00', '2016-02-18 22:00:00', '', 'nao', '', '0', '0', '0', '2016-02-19 10:43:14', '2016-02-19 14:43:14');
INSERT INTO tb_eventos_datas VALUES ( '2', '4', '0', 'Semanais', '0', '2016-04-03', '09:00:00', '10:00:00', '0000-00-00 00:00:00', '2016-04-03 10:00:00', '', 'sim', '', '22', '5', '10', '2016-03-30 09:37:42', '2016-04-20 11:59:12');
INSERT INTO tb_eventos_datas VALUES ( '3', '4', '0', 'Semanais', '0', '2016-04-10', '09:00:00', '10:00:00', '2016-04-10 09:00:00', '2016-04-10 10:00:00', '', 'nao', '', '0', '0', '0', '2016-03-30 09:37:42', '2016-03-30 11:37:42');
INSERT INTO tb_eventos_datas VALUES ( '4', '4', '0', 'Semanais', '0', '2016-04-17', '09:00:00', '10:00:00', '2016-04-17 09:00:00', '2016-04-17 10:00:00', '', 'nao', '', '0', '0', '0', '2016-03-30 09:37:42', '2016-03-30 11:37:42');
INSERT INTO tb_eventos_datas VALUES ( '5', '4', '0', 'Semanais', '0', '2016-04-24', '09:00:00', '10:00:00', '2016-04-24 09:00:00', '2016-04-24 10:00:00', '', 'nao', '', '0', '0', '0', '2016-03-30 09:37:42', '2016-03-30 11:37:42');
INSERT INTO tb_eventos_datas VALUES ( '6', '5', '10', '', '', '2016-03-31', '20:00:00', '21:30:00', '2016-03-31 20:00:00', '2016-03-31 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:28', '2016-03-30 15:09:28');
INSERT INTO tb_eventos_datas VALUES ( '7', '5', '10', '', '', '2016-04-07', '20:00:00', '21:30:00', '2016-04-07 20:00:00', '2016-04-07 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:28', '2016-03-30 15:09:28');
INSERT INTO tb_eventos_datas VALUES ( '8', '5', '10', '', '', '2016-04-14', '20:00:00', '21:30:00', '2016-04-14 20:00:00', '2016-04-14 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:28', '2016-03-30 15:09:28');
INSERT INTO tb_eventos_datas VALUES ( '9', '5', '10', '', '', '2016-04-21', '20:00:00', '21:30:00', '2016-04-21 20:00:00', '2016-04-21 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '10', '5', '10', '', '', '2016-04-28', '20:00:00', '21:30:00', '2016-04-28 20:00:00', '2016-04-28 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '11', '5', '10', '', '', '2016-05-05', '20:00:00', '21:30:00', '2016-05-05 20:00:00', '2016-05-05 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '12', '5', '10', '', '', '2016-05-12', '20:00:00', '21:30:00', '2016-05-12 20:00:00', '2016-05-12 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '13', '5', '10', '', '', '2016-05-19', '20:00:00', '21:30:00', '2016-05-19 20:00:00', '2016-05-19 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '14', '5', '10', '', '', '2016-05-26', '20:00:00', '21:30:00', '2016-05-26 20:00:00', '2016-05-26 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '15', '5', '10', '', '', '2016-06-02', '20:00:00', '21:30:00', '2016-06-02 20:00:00', '2016-06-02 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '16', '5', '10', '', '', '2016-06-09', '20:00:00', '21:30:00', '2016-06-09 20:00:00', '2016-06-09 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '17', '5', '10', '', '', '2016-06-16', '20:00:00', '21:30:00', '2016-06-16 20:00:00', '2016-06-16 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '18', '5', '10', '', '', '2016-06-23', '20:00:00', '21:30:00', '2016-06-23 20:00:00', '2016-06-23 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '19', '5', '10', '', '', '2016-06-30', '20:00:00', '21:30:00', '2016-06-30 20:00:00', '2016-06-30 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '20', '5', '10', '', '', '2016-07-07', '20:00:00', '21:30:00', '2016-07-07 20:00:00', '2016-07-07 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '21', '5', '10', '', '', '2016-07-14', '20:00:00', '21:30:00', '2016-07-14 20:00:00', '2016-07-14 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '22', '5', '10', '', '', '2016-07-21', '20:00:00', '21:30:00', '2016-07-21 20:00:00', '2016-07-21 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:29', '2016-03-30 15:09:29');
INSERT INTO tb_eventos_datas VALUES ( '23', '5', '10', '', '', '2016-07-28', '20:00:00', '21:30:00', '2016-07-28 20:00:00', '2016-07-28 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '24', '5', '10', '', '', '2016-08-04', '20:00:00', '21:30:00', '2016-08-04 20:00:00', '2016-08-04 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '25', '5', '10', '', '', '2016-08-11', '20:00:00', '21:30:00', '2016-08-11 20:00:00', '2016-08-11 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '26', '5', '10', '', '', '2016-08-18', '20:00:00', '21:30:00', '2016-08-18 20:00:00', '2016-08-18 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '27', '5', '10', '', '', '2016-08-25', '20:00:00', '21:30:00', '2016-08-25 20:00:00', '2016-08-25 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '28', '5', '10', '', '', '2016-09-01', '20:00:00', '21:30:00', '2016-09-01 20:00:00', '2016-09-01 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '29', '5', '10', '', '', '2016-09-08', '20:00:00', '21:30:00', '2016-09-08 20:00:00', '2016-09-08 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '30', '5', '10', '', '', '2016-09-15', '20:00:00', '21:30:00', '2016-09-15 20:00:00', '2016-09-15 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '31', '5', '10', '', '', '2016-09-22', '20:00:00', '21:30:00', '2016-09-22 20:00:00', '2016-09-22 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '32', '5', '10', '', '', '2016-09-29', '20:00:00', '21:30:00', '2016-09-29 20:00:00', '2016-09-29 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:30', '2016-03-30 15:09:30');
INSERT INTO tb_eventos_datas VALUES ( '33', '5', '10', '', '', '2016-10-06', '20:00:00', '21:30:00', '2016-10-06 20:00:00', '2016-10-06 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '34', '5', '10', '', '', '2016-10-13', '20:00:00', '21:30:00', '2016-10-13 20:00:00', '2016-10-13 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '35', '5', '10', '', '', '2016-10-20', '20:00:00', '21:30:00', '2016-10-20 20:00:00', '2016-10-20 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '36', '5', '10', '', '', '2016-10-27', '20:00:00', '21:30:00', '2016-10-27 20:00:00', '2016-10-27 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '37', '5', '10', '', '', '2016-11-03', '20:00:00', '21:30:00', '2016-11-03 20:00:00', '2016-11-03 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '38', '5', '10', '', '', '2016-11-10', '20:00:00', '21:30:00', '2016-11-10 20:00:00', '2016-11-10 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '39', '5', '10', '', '', '2016-11-17', '20:00:00', '21:30:00', '2016-11-17 20:00:00', '2016-11-17 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '40', '5', '10', '', '', '2016-11-24', '20:00:00', '21:30:00', '2016-11-24 20:00:00', '2016-11-24 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '41', '5', '10', '', '', '2016-12-01', '20:00:00', '21:30:00', '2016-12-01 20:00:00', '2016-12-01 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '42', '5', '10', '', '', '2016-12-08', '20:00:00', '21:30:00', '2016-12-08 20:00:00', '2016-12-08 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '43', '5', '10', '', '', '2016-12-15', '20:00:00', '21:30:00', '2016-12-15 20:00:00', '2016-12-15 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '44', '5', '10', '', '', '2016-12-22', '20:00:00', '21:30:00', '2016-12-22 20:00:00', '2016-12-22 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '45', '5', '10', '', '', '2016-12-29', '20:00:00', '21:30:00', '2016-12-29 20:00:00', '2016-12-29 21:30:00', '', 'nao', '', '0', '0', '0', '2016-03-30 13:09:31', '2016-03-30 15:09:31');
INSERT INTO tb_eventos_datas VALUES ( '46', '6', '11', '', '', '2016-04-18', '20:00:00', '21:00:00', '2016-04-18 20:00:00', '2016-04-18 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:02', '2016-04-13 17:04:02');
INSERT INTO tb_eventos_datas VALUES ( '47', '6', '11', '', '', '2016-04-25', '20:00:00', '21:00:00', '2016-04-25 20:00:00', '2016-04-25 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '48', '6', '11', '', '', '2016-05-02', '20:00:00', '21:00:00', '2016-05-02 20:00:00', '2016-05-02 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '49', '6', '11', '', '', '2016-05-09', '20:00:00', '21:00:00', '2016-05-09 20:00:00', '2016-05-09 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '50', '6', '11', '', '', '2016-05-16', '20:00:00', '21:00:00', '2016-05-16 20:00:00', '2016-05-16 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '51', '6', '11', '', '', '2016-05-23', '20:00:00', '21:00:00', '2016-05-23 20:00:00', '2016-05-23 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '52', '6', '11', '', '', '2016-05-30', '20:00:00', '21:00:00', '2016-05-30 20:00:00', '2016-05-30 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '53', '6', '11', '', '', '2016-06-06', '20:00:00', '21:00:00', '2016-06-06 20:00:00', '2016-06-06 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '54', '6', '11', '', '', '2016-06-13', '20:00:00', '21:00:00', '2016-06-13 20:00:00', '2016-06-13 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '55', '6', '11', '', '', '2016-06-20', '20:00:00', '21:00:00', '2016-06-20 20:00:00', '2016-06-20 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:03', '2016-04-13 17:04:03');
INSERT INTO tb_eventos_datas VALUES ( '56', '6', '11', '', '', '2016-06-27', '20:00:00', '21:00:00', '2016-06-27 20:00:00', '2016-06-27 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '57', '6', '11', '', '', '2016-07-04', '20:00:00', '21:00:00', '2016-07-04 20:00:00', '2016-07-04 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '58', '6', '11', '', '', '2016-07-11', '20:00:00', '21:00:00', '2016-07-11 20:00:00', '2016-07-11 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '59', '6', '11', '', '', '2016-07-18', '20:00:00', '21:00:00', '2016-07-18 20:00:00', '2016-07-18 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '60', '6', '11', '', '', '2016-07-25', '20:00:00', '21:00:00', '2016-07-25 20:00:00', '2016-07-25 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '61', '6', '11', '', '', '2016-08-01', '20:00:00', '21:00:00', '2016-08-01 20:00:00', '2016-08-01 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '62', '6', '11', '', '', '2016-08-08', '20:00:00', '21:00:00', '2016-08-08 20:00:00', '2016-08-08 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '63', '6', '11', '', '', '2016-08-15', '20:00:00', '21:00:00', '2016-08-15 20:00:00', '2016-08-15 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '64', '6', '11', '', '', '2016-08-22', '20:00:00', '21:00:00', '2016-08-22 20:00:00', '2016-08-22 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '65', '6', '11', '', '', '2016-08-29', '20:00:00', '21:00:00', '2016-08-29 20:00:00', '2016-08-29 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:04', '2016-04-13 17:04:04');
INSERT INTO tb_eventos_datas VALUES ( '66', '6', '11', '', '', '2016-09-05', '20:00:00', '21:00:00', '2016-09-05 20:00:00', '2016-09-05 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '67', '6', '11', '', '', '2016-09-12', '20:00:00', '21:00:00', '2016-09-12 20:00:00', '2016-09-12 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '68', '6', '11', '', '', '2016-09-19', '20:00:00', '21:00:00', '2016-09-19 20:00:00', '2016-09-19 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '69', '6', '11', '', '', '2016-09-26', '20:00:00', '21:00:00', '2016-09-26 20:00:00', '2016-09-26 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '70', '6', '11', '', '', '2016-10-03', '20:00:00', '21:00:00', '2016-10-03 20:00:00', '2016-10-03 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '71', '6', '11', '', '', '2016-10-10', '20:00:00', '21:00:00', '2016-10-10 20:00:00', '2016-10-10 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '72', '6', '11', '', '', '2016-10-17', '20:00:00', '21:00:00', '2016-10-17 20:00:00', '2016-10-17 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '73', '6', '11', '', '', '2016-10-24', '20:00:00', '21:00:00', '2016-10-24 20:00:00', '2016-10-24 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '74', '6', '11', '', '', '2016-10-31', '20:00:00', '21:00:00', '2016-10-31 20:00:00', '2016-10-31 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '75', '6', '11', '', '', '2016-11-07', '20:00:00', '21:00:00', '2016-11-07 20:00:00', '2016-11-07 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '76', '6', '11', '', '', '2016-11-14', '20:00:00', '21:00:00', '2016-11-14 20:00:00', '2016-11-14 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '77', '6', '11', '', '', '2016-11-21', '20:00:00', '21:00:00', '2016-11-21 20:00:00', '2016-11-21 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '78', '6', '11', '', '', '2016-11-28', '20:00:00', '21:00:00', '2016-11-28 20:00:00', '2016-11-28 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:05', '2016-04-13 17:04:05');
INSERT INTO tb_eventos_datas VALUES ( '79', '6', '11', '', '', '2016-12-05', '20:00:00', '21:00:00', '2016-12-05 20:00:00', '2016-12-05 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:06', '2016-04-13 17:04:06');
INSERT INTO tb_eventos_datas VALUES ( '80', '6', '11', '', '', '2016-12-12', '20:00:00', '21:00:00', '2016-12-12 20:00:00', '2016-12-12 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:06', '2016-04-13 17:04:06');
INSERT INTO tb_eventos_datas VALUES ( '81', '6', '11', '', '', '2016-12-19', '20:00:00', '21:00:00', '2016-12-19 20:00:00', '2016-12-19 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:06', '2016-04-13 17:04:06');
INSERT INTO tb_eventos_datas VALUES ( '82', '6', '11', '', '', '2016-12-26', '20:00:00', '21:00:00', '2016-12-26 20:00:00', '2016-12-26 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:04:06', '2016-04-13 17:04:06');
INSERT INTO tb_eventos_datas VALUES ( '84', '6', '11', '', '', '2016-04-07', '10:00:00', '12:00:00', '2016-04-07 10:00:00', '2016-04-07 12:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:12:30', '2016-04-13 17:12:30');
INSERT INTO tb_eventos_datas VALUES ( '85', '6', '11', '', '', '2016-04-08', '12:00:00', '14:00:00', '2016-04-08 12:00:00', '2016-04-08 14:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:13:32', '2016-04-13 17:13:32');
INSERT INTO tb_eventos_datas VALUES ( '86', '6', '11', '', '', '2016-04-06', '15:00:00', '16:00:00', '2016-04-06 15:00:00', '2016-04-06 16:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:18:23', '2016-04-13 17:18:23');
INSERT INTO tb_eventos_datas VALUES ( '87', '6', '11', '', '', '2016-04-09', '10:00:00', '11:00:00', '2016-04-09 10:00:00', '2016-04-09 11:00:00', '', 'nao', '', '0', '0', '0', '2016-04-13 15:19:24', '2016-04-13 17:19:24');
INSERT INTO tb_eventos_datas VALUES ( '88', '7', '0', '', '', '0000-00-00', '00:00:00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 09:08:50', '2016-04-20 11:08:50');
INSERT INTO tb_eventos_datas VALUES ( '89', '8', '0', '', '', '2016-04-06', '18:00:00', '00:00:00', '2016-04-06 18:00:00', '2016-04-06 00:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 09:18:01', '2016-04-20 11:18:01');
INSERT INTO tb_eventos_datas VALUES ( '90', '9', '0', 'Semanais', '6', '2016-04-23', '19:00:00', '20:00:00', '2016-04-23 19:00:00', '2016-04-23 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '91', '9', '0', 'Semanais', '6', '2016-04-30', '19:00:00', '20:00:00', '2016-04-30 19:00:00', '2016-04-30 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '92', '9', '0', 'Semanais', '6', '2016-05-07', '19:00:00', '20:00:00', '2016-05-07 19:00:00', '2016-05-07 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '93', '9', '0', 'Semanais', '6', '2016-05-14', '19:00:00', '20:00:00', '2016-05-14 19:00:00', '2016-05-14 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '94', '9', '0', 'Semanais', '6', '2016-05-21', '19:00:00', '20:00:00', '2016-05-21 19:00:00', '2016-05-21 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '95', '9', '0', 'Semanais', '6', '2016-05-28', '19:00:00', '20:00:00', '2016-05-28 19:00:00', '2016-05-28 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '96', '9', '0', 'Semanais', '6', '2016-06-04', '19:00:00', '20:00:00', '2016-06-04 19:00:00', '2016-06-04 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '97', '9', '0', 'Semanais', '6', '2016-06-11', '19:00:00', '20:00:00', '2016-06-11 19:00:00', '2016-06-11 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '98', '9', '0', 'Semanais', '6', '2016-06-18', '19:00:00', '20:00:00', '2016-06-18 19:00:00', '2016-06-18 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '99', '9', '0', 'Semanais', '6', '2016-06-25', '19:00:00', '20:00:00', '2016-06-25 19:00:00', '2016-06-25 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '100', '9', '0', 'Semanais', '6', '2016-07-02', '19:00:00', '20:00:00', '2016-07-02 19:00:00', '2016-07-02 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '101', '9', '0', 'Semanais', '6', '2016-07-09', '19:00:00', '20:00:00', '2016-07-09 19:00:00', '2016-07-09 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '102', '9', '0', 'Semanais', '6', '2016-07-16', '19:00:00', '20:00:00', '2016-07-16 19:00:00', '2016-07-16 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '103', '9', '0', 'Semanais', '6', '2016-07-23', '19:00:00', '20:00:00', '2016-07-23 19:00:00', '2016-07-23 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '104', '9', '0', 'Semanais', '6', '2016-07-30', '19:00:00', '20:00:00', '2016-07-30 19:00:00', '2016-07-30 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '105', '9', '0', 'Semanais', '6', '2016-08-06', '19:00:00', '20:00:00', '2016-08-06 19:00:00', '2016-08-06 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '106', '9', '0', 'Semanais', '6', '2016-08-13', '19:00:00', '20:00:00', '2016-08-13 19:00:00', '2016-08-13 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '107', '9', '0', 'Semanais', '6', '2016-08-20', '19:00:00', '20:00:00', '2016-08-20 19:00:00', '2016-08-20 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '108', '9', '0', 'Semanais', '6', '2016-08-27', '19:00:00', '20:00:00', '2016-08-27 19:00:00', '2016-08-27 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '109', '9', '0', 'Semanais', '6', '2016-09-03', '19:00:00', '20:00:00', '2016-09-03 19:00:00', '2016-09-03 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '110', '9', '0', 'Semanais', '6', '2016-09-10', '19:00:00', '20:00:00', '2016-09-10 19:00:00', '2016-09-10 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '111', '9', '0', 'Semanais', '6', '2016-09-17', '19:00:00', '20:00:00', '2016-09-17 19:00:00', '2016-09-17 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '112', '9', '0', 'Semanais', '6', '2016-09-24', '19:00:00', '20:00:00', '2016-09-24 19:00:00', '2016-09-24 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '113', '9', '0', 'Semanais', '6', '2016-10-01', '19:00:00', '20:00:00', '2016-10-01 19:00:00', '2016-10-01 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '114', '9', '0', 'Semanais', '6', '2016-10-08', '19:00:00', '20:00:00', '2016-10-08 19:00:00', '2016-10-08 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '115', '9', '0', 'Semanais', '6', '2016-10-15', '19:00:00', '20:00:00', '2016-10-15 19:00:00', '2016-10-15 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '116', '9', '0', 'Semanais', '6', '2016-10-22', '19:00:00', '20:00:00', '2016-10-22 19:00:00', '2016-10-22 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '117', '9', '0', 'Semanais', '6', '2016-10-29', '19:00:00', '20:00:00', '2016-10-29 19:00:00', '2016-10-29 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '118', '9', '0', 'Semanais', '6', '2016-11-05', '19:00:00', '20:00:00', '2016-11-05 19:00:00', '2016-11-05 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '119', '9', '0', 'Semanais', '6', '2016-11-12', '19:00:00', '20:00:00', '2016-11-12 19:00:00', '2016-11-12 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:12', '2016-04-20 18:20:12');
INSERT INTO tb_eventos_datas VALUES ( '120', '9', '0', 'Semanais', '6', '2016-11-19', '19:00:00', '20:00:00', '2016-11-19 19:00:00', '2016-11-19 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:13', '2016-04-20 18:20:13');
INSERT INTO tb_eventos_datas VALUES ( '121', '9', '0', 'Semanais', '6', '2016-11-26', '19:00:00', '20:00:00', '2016-11-26 19:00:00', '2016-11-26 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:13', '2016-04-20 18:20:13');
INSERT INTO tb_eventos_datas VALUES ( '122', '9', '0', 'Semanais', '6', '2016-12-03', '19:00:00', '20:00:00', '2016-12-03 19:00:00', '2016-12-03 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:13', '2016-04-20 18:20:13');
INSERT INTO tb_eventos_datas VALUES ( '123', '9', '0', 'Semanais', '6', '2016-12-10', '19:00:00', '20:00:00', '2016-12-10 19:00:00', '2016-12-10 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:13', '2016-04-20 18:20:13');
INSERT INTO tb_eventos_datas VALUES ( '124', '9', '0', 'Semanais', '6', '2016-12-17', '19:00:00', '20:00:00', '2016-12-17 19:00:00', '2016-12-17 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:13', '2016-04-20 18:20:13');
INSERT INTO tb_eventos_datas VALUES ( '125', '9', '0', 'Semanais', '6', '2016-12-24', '19:00:00', '20:00:00', '2016-12-24 19:00:00', '2016-12-24 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:13', '2016-04-20 18:20:13');
INSERT INTO tb_eventos_datas VALUES ( '126', '9', '0', 'Semanais', '6', '2016-12-31', '19:00:00', '20:00:00', '2016-12-31 19:00:00', '2016-12-31 20:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:20:13', '2016-04-20 18:20:13');
INSERT INTO tb_eventos_datas VALUES ( '127', '10', '12', '', '', '2016-04-22', '20:00:00', '21:00:00', '2016-04-22 20:00:00', '2016-04-22 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '128', '10', '12', '', '', '2016-04-29', '20:00:00', '21:00:00', '2016-04-29 20:00:00', '2016-04-29 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '129', '10', '12', '', '', '2016-05-06', '20:00:00', '21:00:00', '2016-05-06 20:00:00', '2016-05-06 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '130', '10', '12', '', '', '2016-05-13', '20:00:00', '21:00:00', '2016-05-13 20:00:00', '2016-05-13 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '131', '10', '12', '', '', '2016-05-20', '20:00:00', '21:00:00', '2016-05-20 20:00:00', '2016-05-20 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '132', '10', '12', '', '', '2016-05-27', '20:00:00', '21:00:00', '2016-05-27 20:00:00', '2016-05-27 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '133', '10', '12', '', '', '2016-06-03', '20:00:00', '21:00:00', '2016-06-03 20:00:00', '2016-06-03 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '134', '10', '12', '', '', '2016-06-10', '20:00:00', '21:00:00', '2016-06-10 20:00:00', '2016-06-10 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '135', '10', '12', '', '', '2016-06-17', '20:00:00', '21:00:00', '2016-06-17 20:00:00', '2016-06-17 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '136', '10', '12', '', '', '2016-06-24', '20:00:00', '21:00:00', '2016-06-24 20:00:00', '2016-06-24 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:43', '2016-04-20 18:21:43');
INSERT INTO tb_eventos_datas VALUES ( '137', '10', '12', '', '', '2016-07-01', '20:00:00', '21:00:00', '2016-07-01 20:00:00', '2016-07-01 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '138', '10', '12', '', '', '2016-07-08', '20:00:00', '21:00:00', '2016-07-08 20:00:00', '2016-07-08 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '139', '10', '12', '', '', '2016-07-15', '20:00:00', '21:00:00', '2016-07-15 20:00:00', '2016-07-15 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '140', '10', '12', '', '', '2016-07-22', '20:00:00', '21:00:00', '2016-07-22 20:00:00', '2016-07-22 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '141', '10', '12', '', '', '2016-07-29', '20:00:00', '21:00:00', '2016-07-29 20:00:00', '2016-07-29 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '142', '10', '12', '', '', '2016-08-05', '20:00:00', '21:00:00', '2016-08-05 20:00:00', '2016-08-05 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '143', '10', '12', '', '', '2016-08-12', '20:00:00', '21:00:00', '2016-08-12 20:00:00', '2016-08-12 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '144', '10', '12', '', '', '2016-08-19', '20:00:00', '21:00:00', '2016-08-19 20:00:00', '2016-08-19 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '145', '10', '12', '', '', '2016-08-26', '20:00:00', '21:00:00', '2016-08-26 20:00:00', '2016-08-26 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '146', '10', '12', '', '', '2016-09-02', '20:00:00', '21:00:00', '2016-09-02 20:00:00', '2016-09-02 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '147', '10', '12', '', '', '2016-09-09', '20:00:00', '21:00:00', '2016-09-09 20:00:00', '2016-09-09 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '148', '10', '12', '', '', '2016-09-16', '20:00:00', '21:00:00', '2016-09-16 20:00:00', '2016-09-16 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '149', '10', '12', '', '', '2016-09-23', '20:00:00', '21:00:00', '2016-09-23 20:00:00', '2016-09-23 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '150', '10', '12', '', '', '2016-09-30', '20:00:00', '21:00:00', '2016-09-30 20:00:00', '2016-09-30 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '151', '10', '12', '', '', '2016-10-07', '20:00:00', '21:00:00', '2016-10-07 20:00:00', '2016-10-07 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '152', '10', '12', '', '', '2016-10-14', '20:00:00', '21:00:00', '2016-10-14 20:00:00', '2016-10-14 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '153', '10', '12', '', '', '2016-10-21', '20:00:00', '21:00:00', '2016-10-21 20:00:00', '2016-10-21 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '154', '10', '12', '', '', '2016-10-28', '20:00:00', '21:00:00', '2016-10-28 20:00:00', '2016-10-28 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '155', '10', '12', '', '', '2016-11-04', '20:00:00', '21:00:00', '2016-11-04 20:00:00', '2016-11-04 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '156', '10', '12', '', '', '2016-11-11', '20:00:00', '21:00:00', '2016-11-11 20:00:00', '2016-11-11 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '157', '10', '12', '', '', '2016-11-18', '20:00:00', '21:00:00', '2016-11-18 20:00:00', '2016-11-18 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '158', '10', '12', '', '', '2016-11-25', '20:00:00', '21:00:00', '2016-11-25 20:00:00', '2016-11-25 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '159', '10', '12', '', '', '2016-12-02', '20:00:00', '21:00:00', '2016-12-02 20:00:00', '2016-12-02 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '160', '10', '12', '', '', '2016-12-09', '20:00:00', '21:00:00', '2016-12-09 20:00:00', '2016-12-09 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '161', '10', '12', '', '', '2016-12-16', '20:00:00', '21:00:00', '2016-12-16 20:00:00', '2016-12-16 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '162', '10', '12', '', '', '2016-12-23', '20:00:00', '21:00:00', '2016-12-23 20:00:00', '2016-12-23 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '163', '10', '12', '', '', '2016-12-30', '20:00:00', '21:00:00', '2016-12-30 20:00:00', '2016-12-30 21:00:00', '', 'nao', '', '0', '0', '0', '2016-04-20 16:21:44', '2016-04-20 18:21:44');
INSERT INTO tb_eventos_datas VALUES ( '164', '13', '0', '', '', '2017-08-18', '00:00:00', '00:00:00', '2017-08-18 00:00:00', '2017-08-18 00:00:00', '', 'sim', '', '0', '0', '0', '2017-08-18 20:35:42', '2017-08-18 20:35:42');
INSERT INTO tb_eventos_datas VALUES ( '165', '14', '0', '', '', '2017-08-19', '00:00:00', '00:00:00', '2017-08-19 00:00:00', '2017-08-19 00:00:00', '', 'sim', '', '0', '0', '0', '2017-08-18 20:42:00', '2017-08-18 20:42:00');

#
# Criação da Tabela : tb_eventos_datas_oficiantes
#

CREATE TABLE `tb_eventos_datas_oficiantes` (
  `id_oficiante` int(11) NOT NULL AUTO_INCREMENT,
  `id_evento` int(11) NOT NULL,
  `id_data` int(11) NOT NULL,
  `oficiante` varchar(250) NOT NULL,
  `nome_oficiante` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_oficiante`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_eventos_datas_oficiantes VALUES ( '1', '4', '0', '1', '', '2016-03-30 09:37:42', '2016-03-30 11:37:42');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '2', '7', '0', '1', '', '2016-04-20 09:08:50', '2016-04-20 11:08:50');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '3', '7', '88', '11', 'Jason Litz', '2016-04-20 09:08:50', '2016-04-20 11:08:50');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '4', '8', '0', '1', '', '2016-04-20 09:18:01', '2016-04-20 11:18:01');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '5', '8', '89', '11', 'Jason Litz', '2016-04-20 09:18:01', '2016-04-20 11:18:01');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '6', '9', '0', 'l', '', '2016-04-20 16:20:11', '2016-04-20 18:20:11');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '7', '11', '0', 'l', '', '2017-01-04 16:30:37', '2017-01-04 20:30:37');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '8', '12', '0', '1', '', '2017-01-05 14:36:28', '2017-01-05 18:36:28');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '9', '14', '0', '1', '', '2017-08-18 20:41:59', '2017-08-18 20:41:59');
INSERT INTO tb_eventos_datas_oficiantes VALUES ( '10', '14', '165', '11', 'Jason Litz', '2017-08-18 20:42:00', '2017-08-18 20:42:00');

#
# Criação da Tabela : tb_eventos_participantes
#

CREATE TABLE `tb_eventos_participantes` (
  `id_participante` int(11) NOT NULL AUTO_INCREMENT,
  `id_evento` int(11) NOT NULL,
  `id_data` int(11) NOT NULL,
  `id_grupo` int(11) NOT NULL,
  `id_membro` int(11) NOT NULL,
  `participou` varchar(250) NOT NULL DEFAULT 'nao',
  `santa_ceia` varchar(30) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_participante`)
) ENGINE=InnoDB AUTO_INCREMENT=339 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_eventos_participantes VALUES ( '1', '1', '398', '0', '20', 'sim', 'nao', '2016-02-19 07:15:10', '2016-02-19 11:15:10');
INSERT INTO tb_eventos_participantes VALUES ( '2', '1', '398', '0', '26', 'sim', 'nao', '2016-02-19 07:15:10', '2016-02-19 11:15:10');
INSERT INTO tb_eventos_participantes VALUES ( '3', '2', '399', '0', '20', 'sim', 'nao', '2016-02-19 07:16:29', '2016-02-19 11:16:29');
INSERT INTO tb_eventos_participantes VALUES ( '4', '2', '399', '0', '26', 'sim', 'nao', '2016-02-19 10:05:25', '2016-02-19 14:05:25');
INSERT INTO tb_eventos_participantes VALUES ( '5', '2', '399', '0', '34', 'sim', 'nao', '2016-02-19 10:05:53', '2016-02-19 14:05:53');
INSERT INTO tb_eventos_participantes VALUES ( '6', '3', '1', '0', '30', 'sim', 'nao', '2016-02-19 10:43:48', '2016-02-19 14:43:48');
INSERT INTO tb_eventos_participantes VALUES ( '7', '3', '1', '0', '22', 'sim', 'nao', '2016-02-19 10:43:48', '2016-02-19 14:43:48');
INSERT INTO tb_eventos_participantes VALUES ( '8', '4', '3', '0', '21', 'sim', 'nao', '2016-03-30 09:39:12', '2016-03-30 11:39:22');
INSERT INTO tb_eventos_participantes VALUES ( '9', '4', '3', '0', '11', 'nao', 'nao', '2016-03-30 09:39:12', '2016-03-30 11:39:21');
INSERT INTO tb_eventos_participantes VALUES ( '11', '5', '6', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '12', '5', '7', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '13', '5', '8', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '14', '5', '9', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '15', '5', '10', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '16', '5', '11', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '17', '5', '12', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '18', '5', '13', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '19', '5', '14', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '20', '5', '15', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '21', '5', '16', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '22', '5', '17', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '23', '5', '18', '10', '9', 'nao', '', '2016-03-30 13:10:56', '2016-03-30 15:10:56');
INSERT INTO tb_eventos_participantes VALUES ( '24', '5', '19', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '25', '5', '20', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '26', '5', '21', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '27', '5', '22', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '28', '5', '23', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '29', '5', '24', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '30', '5', '25', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '31', '5', '26', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '32', '5', '27', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '33', '5', '28', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '34', '5', '29', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '35', '5', '30', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '36', '5', '31', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '37', '5', '32', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '38', '5', '33', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '39', '5', '34', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '40', '5', '35', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '41', '5', '36', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '42', '5', '37', '10', '9', 'nao', '', '2016-03-30 13:10:57', '2016-03-30 15:10:57');
INSERT INTO tb_eventos_participantes VALUES ( '43', '5', '38', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '44', '5', '39', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '45', '5', '40', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '46', '5', '41', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '47', '5', '42', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '48', '5', '43', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '49', '5', '44', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '50', '5', '45', '10', '9', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '51', '5', '6', '10', '17', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '52', '5', '7', '10', '17', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '53', '5', '8', '10', '17', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '54', '5', '9', '10', '17', 'nao', '', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_eventos_participantes VALUES ( '55', '5', '10', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '56', '5', '11', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '57', '5', '12', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '58', '5', '13', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '59', '5', '14', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '60', '5', '15', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '61', '5', '16', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '62', '5', '17', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '63', '5', '18', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '64', '5', '19', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '65', '5', '20', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '66', '5', '21', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '67', '5', '22', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '68', '5', '23', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '69', '5', '24', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '70', '5', '25', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '71', '5', '26', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '72', '5', '27', '10', '17', 'nao', '', '2016-03-30 13:10:59', '2016-03-30 15:10:59');
INSERT INTO tb_eventos_participantes VALUES ( '73', '5', '28', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '74', '5', '29', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '75', '5', '30', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '76', '5', '31', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '77', '5', '32', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '78', '5', '33', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '79', '5', '34', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '80', '5', '35', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '81', '5', '36', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '82', '5', '37', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '83', '5', '38', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '84', '5', '39', '10', '17', 'nao', '', '2016-03-30 13:11:00', '2016-03-30 15:11:00');
INSERT INTO tb_eventos_participantes VALUES ( '85', '5', '40', '10', '17', 'nao', '', '2016-03-30 13:11:01', '2016-03-30 15:11:01');
INSERT INTO tb_eventos_participantes VALUES ( '86', '5', '41', '10', '17', 'nao', '', '2016-03-30 13:11:01', '2016-03-30 15:11:01');
INSERT INTO tb_eventos_participantes VALUES ( '87', '5', '42', '10', '17', 'nao', '', '2016-03-30 13:11:01', '2016-03-30 15:11:01');
INSERT INTO tb_eventos_participantes VALUES ( '88', '5', '43', '10', '17', 'nao', '', '2016-03-30 13:11:01', '2016-03-30 15:11:01');
INSERT INTO tb_eventos_participantes VALUES ( '89', '5', '44', '10', '17', 'nao', '', '2016-03-30 13:11:01', '2016-03-30 15:11:01');
INSERT INTO tb_eventos_participantes VALUES ( '90', '5', '45', '10', '17', 'nao', '', '2016-03-30 13:11:01', '2016-03-30 15:11:01');
INSERT INTO tb_eventos_participantes VALUES ( '91', '6', '46', '11', '20', 'nao', '', '2016-04-13 15:04:27', '2016-04-13 17:04:27');
INSERT INTO tb_eventos_participantes VALUES ( '92', '6', '47', '11', '20', 'nao', '', '2016-04-13 15:04:27', '2016-04-13 17:04:27');
INSERT INTO tb_eventos_participantes VALUES ( '93', '6', '48', '11', '20', 'nao', '', '2016-04-13 15:04:27', '2016-04-13 17:04:27');
INSERT INTO tb_eventos_participantes VALUES ( '94', '6', '49', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '95', '6', '50', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '96', '6', '51', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '97', '6', '52', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '98', '6', '53', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '99', '6', '54', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '100', '6', '55', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '101', '6', '56', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '102', '6', '57', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '103', '6', '58', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '104', '6', '59', '11', '20', 'nao', '', '2016-04-13 15:04:28', '2016-04-13 17:04:28');
INSERT INTO tb_eventos_participantes VALUES ( '105', '6', '60', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '106', '6', '61', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '107', '6', '62', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '108', '6', '63', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '109', '6', '64', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '110', '6', '65', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '111', '6', '66', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '112', '6', '67', '11', '20', 'nao', '', '2016-04-13 15:04:30', '2016-04-13 17:04:30');
INSERT INTO tb_eventos_participantes VALUES ( '113', '6', '68', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '114', '6', '69', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '115', '6', '70', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '116', '6', '71', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '117', '6', '72', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '118', '6', '73', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '119', '6', '74', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '120', '6', '75', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '121', '6', '76', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '122', '6', '77', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '123', '6', '78', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '124', '6', '79', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '125', '6', '80', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '126', '6', '81', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '127', '6', '82', '11', '20', 'nao', '', '2016-04-13 15:04:31', '2016-04-13 17:04:31');
INSERT INTO tb_eventos_participantes VALUES ( '128', '6', '46', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '129', '6', '47', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '130', '6', '48', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '131', '6', '49', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '132', '6', '50', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '133', '6', '51', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '134', '6', '52', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '135', '6', '53', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '136', '6', '54', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '137', '6', '55', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '138', '6', '56', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '139', '6', '57', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '140', '6', '58', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '141', '6', '59', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '142', '6', '60', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '143', '6', '61', '11', '14', 'nao', '', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_eventos_participantes VALUES ( '144', '6', '62', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '145', '6', '63', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '146', '6', '64', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '147', '6', '65', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '148', '6', '66', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '149', '6', '67', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '150', '6', '68', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '151', '6', '69', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '152', '6', '70', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '153', '6', '71', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '154', '6', '72', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '155', '6', '73', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '156', '6', '74', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '157', '6', '75', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '158', '6', '76', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '159', '6', '77', '11', '14', 'nao', '', '2016-04-13 15:04:33', '2016-04-13 17:04:33');
INSERT INTO tb_eventos_participantes VALUES ( '160', '6', '78', '11', '14', 'nao', '', '2016-04-13 15:04:34', '2016-04-13 17:04:34');
INSERT INTO tb_eventos_participantes VALUES ( '161', '6', '79', '11', '14', 'nao', '', '2016-04-13 15:04:34', '2016-04-13 17:04:34');
INSERT INTO tb_eventos_participantes VALUES ( '162', '6', '80', '11', '14', 'nao', '', '2016-04-13 15:04:34', '2016-04-13 17:04:34');
INSERT INTO tb_eventos_participantes VALUES ( '163', '6', '81', '11', '14', 'nao', '', '2016-04-13 15:04:34', '2016-04-13 17:04:34');
INSERT INTO tb_eventos_participantes VALUES ( '164', '6', '82', '11', '14', 'nao', '', '2016-04-13 15:04:34', '2016-04-13 17:04:34');
INSERT INTO tb_eventos_participantes VALUES ( '165', '6', '46', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:24');
INSERT INTO tb_eventos_participantes VALUES ( '166', '6', '47', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:24');
INSERT INTO tb_eventos_participantes VALUES ( '167', '6', '48', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '168', '6', '49', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '169', '6', '50', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '170', '6', '51', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '171', '6', '52', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '172', '6', '53', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '173', '6', '54', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '174', '6', '55', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:25');
INSERT INTO tb_eventos_participantes VALUES ( '175', '6', '56', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '176', '6', '57', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '177', '6', '58', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '178', '6', '59', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '179', '6', '60', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '180', '6', '61', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '181', '6', '62', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '182', '6', '63', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '183', '6', '64', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '184', '6', '65', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '185', '6', '66', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:26');
INSERT INTO tb_eventos_participantes VALUES ( '186', '6', '67', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '187', '6', '68', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '188', '6', '69', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '189', '6', '70', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '190', '6', '71', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '191', '6', '72', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '192', '6', '73', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '193', '6', '74', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:27');
INSERT INTO tb_eventos_participantes VALUES ( '194', '6', '75', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '195', '6', '76', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '196', '6', '77', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '197', '6', '78', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '198', '6', '79', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '199', '6', '80', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '200', '6', '81', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '201', '6', '82', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '202', '6', '84', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '203', '6', '85', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:28');
INSERT INTO tb_eventos_participantes VALUES ( '204', '6', '86', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '205', '6', '87', '11', '20', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '206', '6', '46', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '207', '6', '47', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '208', '6', '48', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '209', '6', '49', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '210', '6', '50', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '211', '6', '51', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '212', '6', '52', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:29');
INSERT INTO tb_eventos_participantes VALUES ( '213', '6', '53', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:30');
INSERT INTO tb_eventos_participantes VALUES ( '214', '6', '54', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:30');
INSERT INTO tb_eventos_participantes VALUES ( '215', '6', '55', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:30');
INSERT INTO tb_eventos_participantes VALUES ( '216', '6', '56', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:30');
INSERT INTO tb_eventos_participantes VALUES ( '217', '6', '57', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:30');
INSERT INTO tb_eventos_participantes VALUES ( '218', '6', '58', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:30');
INSERT INTO tb_eventos_participantes VALUES ( '219', '6', '59', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:30');
INSERT INTO tb_eventos_participantes VALUES ( '220', '6', '60', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:31');
INSERT INTO tb_eventos_participantes VALUES ( '221', '6', '61', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:31');
INSERT INTO tb_eventos_participantes VALUES ( '222', '6', '62', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:31');
INSERT INTO tb_eventos_participantes VALUES ( '223', '6', '63', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:31');
INSERT INTO tb_eventos_participantes VALUES ( '224', '6', '64', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:31');
INSERT INTO tb_eventos_participantes VALUES ( '225', '6', '65', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:31');
INSERT INTO tb_eventos_participantes VALUES ( '226', '6', '66', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '227', '6', '67', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '228', '6', '68', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '229', '6', '69', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '230', '6', '70', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '231', '6', '71', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '232', '6', '72', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '233', '6', '73', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '234', '6', '74', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:32');
INSERT INTO tb_eventos_participantes VALUES ( '235', '6', '75', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '236', '6', '76', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '237', '6', '77', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '238', '6', '78', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '239', '6', '79', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '240', '6', '80', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '241', '6', '81', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '242', '6', '82', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '243', '6', '84', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '244', '6', '85', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '245', '6', '86', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:33');
INSERT INTO tb_eventos_participantes VALUES ( '246', '6', '87', '11', '14', 'nao', '', '0000-00-00 00:00:00', '2016-04-13 17:19:34');
INSERT INTO tb_eventos_participantes VALUES ( '255', '4', '2', '0', '20', 'sim', 'sim', '2016-04-20 09:58:20', '2017-01-04 20:32:16');
INSERT INTO tb_eventos_participantes VALUES ( '256', '4', '2', '0', '14', 'sim', 'sim', '2016-04-20 09:58:20', '2017-01-04 20:32:16');
INSERT INTO tb_eventos_participantes VALUES ( '257', '4', '2', '0', '8', 'sim', 'nao', '2016-04-20 09:58:20', '2017-01-04 20:32:16');
INSERT INTO tb_eventos_participantes VALUES ( '258', '4', '2', '0', '21', 'sim', 'nao', '2016-04-20 10:19:45', '2017-01-04 20:32:15');
INSERT INTO tb_eventos_participantes VALUES ( '259', '4', '2', '0', '26', 'sim', 'sim', '2016-04-20 10:19:45', '2017-01-04 20:32:16');
INSERT INTO tb_eventos_participantes VALUES ( '260', '4', '2', '0', '11', 'sim', 'nao', '2016-04-20 15:28:58', '2017-01-04 20:32:15');
INSERT INTO tb_eventos_participantes VALUES ( '261', '4', '2', '0', '22', 'sim', 'sim', '2016-04-20 16:17:55', '2017-01-04 20:32:16');
INSERT INTO tb_eventos_participantes VALUES ( '262', '10', '127', '12', '20', 'nao', '', '2016-04-20 16:22:42', '2016-04-20 18:22:42');
INSERT INTO tb_eventos_participantes VALUES ( '263', '10', '128', '12', '20', 'nao', '', '2016-04-20 16:22:42', '2016-04-20 18:22:42');
INSERT INTO tb_eventos_participantes VALUES ( '264', '10', '129', '12', '20', 'nao', '', '2016-04-20 16:22:42', '2016-04-20 18:22:42');
INSERT INTO tb_eventos_participantes VALUES ( '265', '10', '130', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '266', '10', '131', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '267', '10', '132', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '268', '10', '133', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '269', '10', '134', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '270', '10', '135', '12', '20', 'sim', '', '2016-04-20 16:22:43', '2016-04-20 18:23:01');
INSERT INTO tb_eventos_participantes VALUES ( '271', '10', '136', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '272', '10', '137', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '273', '10', '138', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '274', '10', '139', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '275', '10', '140', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '276', '10', '141', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '277', '10', '142', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '278', '10', '143', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '279', '10', '144', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '280', '10', '145', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '281', '10', '146', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '282', '10', '147', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '283', '10', '148', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '284', '10', '149', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '285', '10', '150', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '286', '10', '151', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '287', '10', '152', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '288', '10', '153', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '289', '10', '154', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '290', '10', '155', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '291', '10', '156', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '292', '10', '157', '12', '20', 'nao', '', '2016-04-20 16:22:43', '2016-04-20 18:22:43');
INSERT INTO tb_eventos_participantes VALUES ( '293', '10', '158', '12', '20', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '294', '10', '159', '12', '20', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '295', '10', '160', '12', '20', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '296', '10', '161', '12', '20', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '297', '10', '162', '12', '20', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '298', '10', '163', '12', '20', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '299', '10', '127', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '300', '10', '128', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '301', '10', '129', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '302', '10', '130', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '303', '10', '131', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '304', '10', '132', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '305', '10', '133', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '306', '10', '134', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '307', '10', '135', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '308', '10', '136', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '309', '10', '137', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '310', '10', '138', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '311', '10', '139', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '312', '10', '140', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '313', '10', '141', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '314', '10', '142', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '315', '10', '143', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '316', '10', '144', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '317', '10', '145', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '318', '10', '146', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '319', '10', '147', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '320', '10', '148', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '321', '10', '149', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '322', '10', '150', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '323', '10', '151', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '324', '10', '152', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '325', '10', '153', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '326', '10', '154', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '327', '10', '155', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '328', '10', '156', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '329', '10', '157', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '330', '10', '158', '12', '22', 'nao', '', '2016-04-20 16:22:44', '2016-04-20 18:22:44');
INSERT INTO tb_eventos_participantes VALUES ( '331', '10', '159', '12', '22', 'nao', '', '2016-04-20 16:22:45', '2016-04-20 18:22:45');
INSERT INTO tb_eventos_participantes VALUES ( '332', '10', '160', '12', '22', 'nao', '', '2016-04-20 16:22:45', '2016-04-20 18:22:45');
INSERT INTO tb_eventos_participantes VALUES ( '333', '10', '161', '12', '22', 'nao', '', '2016-04-20 16:22:45', '2016-04-20 18:22:45');
INSERT INTO tb_eventos_participantes VALUES ( '334', '10', '162', '12', '22', 'nao', '', '2016-04-20 16:22:45', '2016-04-20 18:22:45');
INSERT INTO tb_eventos_participantes VALUES ( '335', '10', '163', '12', '22', 'nao', '', '2016-04-20 16:22:45', '2016-04-20 18:22:45');
INSERT INTO tb_eventos_participantes VALUES ( '336', '13', '164', '0', '20', 'sim', 'sim', '2017-08-18 20:36:45', '2017-08-18 20:37:00');
INSERT INTO tb_eventos_participantes VALUES ( '337', '13', '164', '0', '21', 'sim', 'nao', '2017-08-18 20:36:45', '2017-08-18 20:37:00');
INSERT INTO tb_eventos_participantes VALUES ( '338', '13', '164', '0', '14', 'sim', 'sim', '2017-08-18 20:36:45', '2017-08-18 20:37:00');

#
# Criação da Tabela : tb_financeiro
#

CREATE TABLE `tb_financeiro` (
  `id_financeiro` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(250) NOT NULL,
  `id_conta_bancaria` int(11) NOT NULL,
  `id_recorrencia` int(11) NOT NULL,
  `id_fornecedor` int(11) NOT NULL,
  `id_evento` int(11) NOT NULL,
  `id_membro` int(11) NOT NULL,
  `id_centro_custo` int(11) NOT NULL,
  `id_centro_custo2` int(11) NOT NULL,
  `referencia` varchar(250) NOT NULL,
  `valor` decimal(15,2) NOT NULL,
  `situacao` varchar(250) NOT NULL,
  `data_vencimento` date NOT NULL,
  `data_pagamento` date NOT NULL,
  `parcelas` varchar(250) NOT NULL,
  `observacoes` text NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_financeiro`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_financeiro VALUES ( '1', 'A pagar', '1', '0', '0', '0', '0', '2', '0', '', '45.90', 'Pendente', '2014-12-29', '2014-12-30', '', 'Teste de observações.', '2014-12-29 21:40:58', '2014-12-30 10:24:43');
INSERT INTO tb_financeiro VALUES ( '2', 'A receber', '2', '0', '0', '509', '0', '4', '0', '', '204.21', 'Pendente', '2014-12-21', '2014-12-21', '', 'Observações.', '2014-12-30 22:39:20', '2015-10-05 16:21:02');
INSERT INTO tb_financeiro VALUES ( '3', 'A pagar', '2', '0', '0', '0', '0', '2', '0', '', '200.00', 'Pago', '2014-12-20', '2014-12-30', '', '', '2014-12-30 22:53:15', '2014-12-31 10:53:15');
INSERT INTO tb_financeiro VALUES ( '4', 'A receber', '2', '0', '0', '0', '0', '2', '0', '', '20.40', 'Pago', '2015-01-01', '2014-12-31', '', '', '2014-12-31 14:58:52', '2015-01-01 02:58:52');
INSERT INTO tb_financeiro VALUES ( '5', 'A pagar', '2', '0', '1', '0', '0', '2', '0', '0', '90.00', 'Pendente', '2015-01-02', '0000-00-00', '', '', '2015-01-02 20:22:23', '2015-01-03 08:22:23');
INSERT INTO tb_financeiro VALUES ( '6', 'A pagar', '2', '1', '1', '0', '0', '2', '0', '0', '90.00', 'Pendente', '2015-01-02', '0000-00-00', '', '', '2015-01-02 20:24:41', '2015-01-03 08:24:41');
INSERT INTO tb_financeiro VALUES ( '7', 'A pagar', '2', '0', '1', '0', '0', '2', '0', 'teste', '50.00', 'Pago', '2015-01-03', '2015-01-03', '', '', '2015-01-03 19:51:41', '2015-01-04 07:51:41');
INSERT INTO tb_financeiro VALUES ( '8', 'A pagar', '2', '0', '2', '0', '0', '2', '0', 'teste', '20.00', 'Pago', '2015-01-03', '2015-01-03', '', '', '2015-01-03 19:55:19', '2015-01-04 07:55:19');
INSERT INTO tb_financeiro VALUES ( '9', 'A pagar', '2', '0', '1', '0', '0', '2', '0', '', '90.00', 'Pago', '2015-02-01', '2015-02-02', '', '', '2015-02-01 20:58:07', '2015-02-03 07:14:03');
INSERT INTO tb_financeiro VALUES ( '31', 'A pagar', '2', '0', '0', '0', '0', '2', '0', 'Teste', '10.00', 'Pago', '2015-02-03', '2015-02-03', '1/1', '', '2015-02-03 07:33:28', '2015-02-03 17:33:28');
INSERT INTO tb_financeiro VALUES ( '32', 'A receber', '2', '0', '2', '485', '6', '4', '0', 'Teste 2', '12.00', 'Pago', '2015-02-03', '2015-02-03', '1/1', '', '2015-02-03 07:42:41', '2015-03-03 15:37:03');
INSERT INTO tb_financeiro VALUES ( '33', 'A pagar', '2', '0', '0', '0', '0', '3', '0', 'Teste 3', '20.00', 'Pago', '2015-02-03', '2015-02-03', '1/1', '', '2015-02-03 08:00:09', '2015-02-03 18:00:09');
INSERT INTO tb_financeiro VALUES ( '34', 'A pagar', '2', '0', '2', '0', '0', '2', '0', 'teste de parcelamento (1/4)', '50.00', 'Pago', '2015-02-06', '2015-02-06', '1/4', '', '2015-02-06 13:24:48', '2015-02-06 23:24:48');
INSERT INTO tb_financeiro VALUES ( '35', 'A pagar', '2', '0', '2', '0', '0', '2', '0', 'teste de parcelamento (2/4)', '50.00', 'Pendente', '2015-03-08', '0000-00-00', '2/4', '', '2015-02-06 13:24:48', '2015-02-06 23:24:48');
INSERT INTO tb_financeiro VALUES ( '36', 'A pagar', '2', '0', '2', '0', '0', '2', '0', 'teste de parcelamento (3/4)', '50.00', 'Pendente', '2015-05-07', '0000-00-00', '3/4', '', '2015-02-06 13:24:48', '2015-02-06 23:24:48');
INSERT INTO tb_financeiro VALUES ( '37', 'A pagar', '2', '0', '2', '0', '0', '2', '0', 'teste de parcelamento (4/4)', '50.00', 'Pendente', '2015-08-05', '0000-00-00', '4/4', '', '2015-02-06 13:24:48', '2015-02-06 23:24:48');
INSERT INTO tb_financeiro VALUES ( '38', 'A receber', '2', '0', '0', '0', '6', '4', '0', 'teste 2', '500.00', 'Pago', '2015-03-17', '2015-03-17', '1/1', 'Teste', '2015-03-17 15:00:24', '2015-03-17 16:10:44');
INSERT INTO tb_financeiro VALUES ( '39', 'A receber', '2', '0', '0', '0', '6', '4', '0', '', '500.00', 'Pago', '2015-03-17', '2015-03-17', '1/1', '', '2015-03-17 15:11:21', '2015-03-17 16:11:21');
INSERT INTO tb_financeiro VALUES ( '40', 'A receber', '2', '0', '0', '4', '0', '4', '0', 'Teste', '20.00', 'Pago', '2015-03-17', '2015-03-17', '1/1', '', '2015-03-17 16:04:05', '2015-03-17 17:04:05');
INSERT INTO tb_financeiro VALUES ( '41', 'A receber', '3', '0', '0', '0', '14', '2', '0', '', '50.00', 'Pago', '2015-04-01', '2015-04-04', '1/1', '', '2015-04-06 15:31:49', '2015-04-06 16:31:49');
INSERT INTO tb_financeiro VALUES ( '42', 'A receber', '3', '0', '0', '0', '11', '2', '0', '', '100.00', 'Pago', '2015-04-01', '2015-04-06', '1/1', '', '2015-04-06 15:35:13', '2015-04-06 17:24:57');
INSERT INTO tb_financeiro VALUES ( '43', 'A pagar', '3', '0', '0', '0', '0', '29', '0', '', '150.00', 'Pendente', '2015-04-06', '0000-00-00', '1/1', '', '2015-04-06 16:23:58', '2015-04-06 18:17:03');
INSERT INTO tb_financeiro VALUES ( '44', 'A receber', '3', '0', '0', '129', '0', '1', '0', '', '200.00', 'Pago', '2015-04-07', '2015-04-07', '1/1', '', '2015-04-07 08:15:45', '2015-04-07 09:15:45');
INSERT INTO tb_financeiro VALUES ( '45', 'A receber', '4', '0', '0', '89', '20', '4', '0', 'df', '1000.00', 'Pago', '2015-04-16', '2015-04-07', '1/1', '', '2015-04-07 08:40:30', '2015-04-07 20:49:41');
INSERT INTO tb_financeiro VALUES ( '46', 'A receber', '4', '0', '0', '170', '20', '2', '0', '', '100.00', 'Pago', '2015-04-07', '2015-04-07', '1/1', '', '2015-04-07 19:29:56', '2015-04-07 20:47:44');
INSERT INTO tb_financeiro VALUES ( '47', 'A receber', '4', '0', '0', '170', '21', '2', '0', '', '100.00', 'Pago', '2015-04-08', '2015-04-08', '1/1', '', '2015-04-08 15:04:48', '2015-04-08 16:07:25');
INSERT INTO tb_financeiro VALUES ( '48', 'A receber', '4', '0', '0', '170', '26', '3', '0', 'Oferta ', '300.00', 'Pago', '2015-04-12', '2015-04-12', '1/1', '', '2015-04-10 13:33:34', '2015-04-10 14:33:34');
INSERT INTO tb_financeiro VALUES ( '49', 'A pagar', '4', '0', '0', '0', '0', '36', '0', '', '200.00', 'Pago', '2015-04-11', '2015-04-11', '1/1', '', '2015-04-11 11:49:48', '2015-04-11 12:49:48');
INSERT INTO tb_financeiro VALUES ( '53', 'A receber', '3', '0', '0', '0', '0', '6', '0', '123456', '115.00', 'Pago', '2015-04-16', '2015-04-16', '1/1', 'tetes', '2015-04-16 15:28:25', '2015-04-16 16:39:39');
INSERT INTO tb_financeiro VALUES ( '54', 'A receber', '3', '0', '0', '291', '0', '1', '0', ' (1/3)', '166.67', 'Pago', '2015-07-29', '2015-07-28', '1/3', '', '2015-07-28 15:12:42', '2015-07-28 16:16:04');
INSERT INTO tb_financeiro VALUES ( '55', 'A receber', '3', '0', '0', '291', '0', '1', '0', ' (2/3)', '166.67', 'Pendente', '2015-08-28', '0000-00-00', '2/3', '', '2015-07-28 15:12:42', '2015-07-28 16:12:42');
INSERT INTO tb_financeiro VALUES ( '56', 'A receber', '3', '0', '0', '291', '0', '1', '0', ' (3/3)', '166.67', 'Pendente', '2015-09-28', '0000-00-00', '3/3', '', '2015-07-28 15:12:42', '2015-07-28 16:17:25');
INSERT INTO tb_financeiro VALUES ( '57', 'A receber', '4', '0', '0', '0', '0', '2', '0', '', '1000.00', 'Pago', '2015-09-22', '2015-09-22', '1/1', '', '2015-09-22 12:29:39', '2015-09-22 13:29:39');
INSERT INTO tb_financeiro VALUES ( '58', 'A receber', '3', '0', '0', '530', '0', '2', '0', '', '100.00', 'Pago', '2016-02-17', '2016-02-17', '1/1', '', '2016-02-17 04:54:01', '2016-02-17 08:54:01');
INSERT INTO tb_financeiro VALUES ( '59', 'A pagar', '3', '0', '2', '0', '0', '45', '3', 'teste', '200.00', 'Pago', '2016-02-18', '2016-02-18', '1/1', '', '2016-02-18 06:48:03', '2016-02-18 10:51:54');
INSERT INTO tb_financeiro VALUES ( '60', 'A pagar', '4', '0', '1', '0', '0', '45', '2', 'teste', '20.00', 'Pago', '2016-02-17', '2016-02-17', '1/1', '', '2016-02-18 06:51:24', '2016-02-18 10:51:24');
INSERT INTO tb_financeiro VALUES ( '61', 'A pagar', '2', '0', '2', '0', '0', '45', '3', 'teste 21', '350.00', 'Pago', '2016-02-17', '2016-02-17', '1/1', '', '2016-02-18 07:49:50', '2016-02-18 11:53:29');
INSERT INTO tb_financeiro VALUES ( '62', 'A pagar', '4', '0', '0', '0', '0', '49', '0', 'Movimento entre contas', '300.00', 'Pago', '2016-03-17', '2016-03-17', '1/1', '', '2016-03-17 19:19:40', '2016-03-17 21:19:40');
INSERT INTO tb_financeiro VALUES ( '63', 'A receber', '2', '0', '0', '0', '0', '16', '0', 'Movimento entre contas', '300.00', 'Pago', '2016-03-17', '2016-03-17', '1/1', '', '2016-03-17 19:19:40', '2016-03-17 21:19:40');
INSERT INTO tb_financeiro VALUES ( '64', 'A receber', '2', '0', '0', '4', '0', '1', '0', '', '1752.00', 'Pago', '2016-03-20', '2016-03-20', '1/1', '', '2016-03-30 13:35:00', '2016-03-30 15:35:00');
INSERT INTO tb_financeiro VALUES ( '65', 'A receber', '4', '0', '0', '0', '0', '1', '0', ' (1/1)', '500.00', 'Pago', '2016-03-29', '2016-03-29', '1/1', '', '2016-03-30 14:14:27', '2016-03-30 16:14:27');
INSERT INTO tb_financeiro VALUES ( '66', 'A receber', '3', '0', '0', '0', '0', '2', '0', 'teste', '500.00', 'Pago', '2016-04-13', '2016-04-13', '1/1', '', '2016-04-13 09:39:10', '2016-04-13 11:39:10');
INSERT INTO tb_financeiro VALUES ( '67', 'A pagar', '4', '0', '0', '0', '0', '45', '2', '', '250.00', 'Pago', '2016-04-20', '2016-04-20', '1/1', '', '2016-04-20 09:06:10', '2016-04-20 11:06:10');
INSERT INTO tb_financeiro VALUES ( '68', 'A receber', '4', '0', '0', '0', '0', '2', '0', '', '400.00', 'Pago', '2016-04-17', '2016-04-17', '1/1', '', '2016-04-20 09:07:20', '2016-04-20 11:07:20');
INSERT INTO tb_financeiro VALUES ( '69', 'A receber', '4', '0', '0', '0', '0', '2', '0', '', '50.00', 'Pago', '2016-04-20', '2016-04-20', '1/1', '', '2016-04-20 16:26:53', '2016-04-20 18:26:53');
INSERT INTO tb_financeiro VALUES ( '70', 'A receber', '4', '0', '0', '0', '0', '2', '0', '', '150.00', 'Pago', '2016-04-20', '2016-04-20', '1/1', '', '2016-04-20 19:07:25', '2016-04-20 21:07:25');
INSERT INTO tb_financeiro VALUES ( '71', 'A pagar', '2', '1', '1', '0', '0', '2', '0', '0', '90.00', 'Pendente', '2015-01-02', '0000-00-00', '', '', '2018-05-22 23:33:25', '2018-05-22 23:33:25');

#
# Criação da Tabela : tb_financeiro_recorrencia
#

CREATE TABLE `tb_financeiro_recorrencia` (
  `id_recorrencia` int(11) NOT NULL AUTO_INCREMENT,
  `periodicidade` varchar(250) NOT NULL,
  `periodicidade_vencimento` date NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `id_fornecedor` int(11) NOT NULL,
  `id_conta_bancaria` int(11) NOT NULL,
  `id_centro_custo` int(11) NOT NULL,
  `referencia` varchar(250) NOT NULL,
  `valor` decimal(15,2) NOT NULL,
  `observacoes` text NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_recorrencia`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_financeiro_recorrencia VALUES ( '1', 'Mensal', '2015-01-02', 'A pagar', '1', '2', '2', '0', '90.00', '', '2015-01-02 14:40:34', '2015-01-03 08:12:06');
INSERT INTO tb_financeiro_recorrencia VALUES ( '2', 'Mensal', '2015-04-08', 'A pagar', '0', '3', '43', '', '600.00', '', '2015-04-06 16:10:36', '2015-04-08 15:59:35');

#
# Criação da Tabela : tb_fornecedores
#

CREATE TABLE `tb_fornecedores` (
  `id_fornecedor` int(11) NOT NULL AUTO_INCREMENT,
  `ativo` varchar(250) NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `nome_razao_social` varchar(250) NOT NULL,
  `rg_ie` varchar(250) NOT NULL,
  `cpf_cnpj` varchar(250) NOT NULL,
  `cep` varchar(250) NOT NULL,
  `endereco` varchar(250) NOT NULL,
  `numero` varchar(250) NOT NULL,
  `complemento` varchar(250) NOT NULL,
  `bairro` varchar(250) NOT NULL,
  `cidade` varchar(250) NOT NULL,
  `estado` varchar(250) NOT NULL,
  `observacoes` text NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_fornecedor`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_fornecedores VALUES ( '1', 'sim', 'CNPJ', 'F5 Digital Ltda.', '9999', '999.999.999/9999-99', '93320-040', 'Rua Miguel Couto', '12', 'Sala 03', 'Centro', 'Novo Hamburgo', 'RS', 'Melhor fornecedor.', '2014-12-31 16:22:48', '2015-01-02 02:47:15');
INSERT INTO tb_fornecedores VALUES ( '2', 'sim', 'CNPJ', 'Anderson Barreto Glaeser', '2929292', '99.999.999/9999-99', '93334-290', '2343424', '34', '34', '34', '34', '34', '', '2015-01-01 14:50:38', '2015-01-13 23:09:28');

#
# Criação da Tabela : tb_fornecedores_emails
#

CREATE TABLE `tb_fornecedores_emails` (
  `id_email` int(11) NOT NULL AUTO_INCREMENT,
  `id_fornecedor` int(11) NOT NULL,
  `email` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_fornecedores_emails VALUES ( '2', '1', 'anderson@f5digital.com.br', '2015-01-01 14:47:40', '2015-01-02 02:47:40');

#
# Criação da Tabela : tb_fornecedores_telefones
#

CREATE TABLE `tb_fornecedores_telefones` (
  `id_telefone` int(11) NOT NULL AUTO_INCREMENT,
  `id_fornecedor` int(11) NOT NULL,
  `numero` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_telefone`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_fornecedores_telefones VALUES ( '2', '1', '(51) 3066.0669', '2015-01-01 14:47:40', '2015-01-02 02:47:40');

#
# Criação da Tabela : tb_grupos
#

CREATE TABLE `tb_grupos` (
  `id_grupo` int(11) NOT NULL AUTO_INCREMENT,
  `id_congregacao` int(11) NOT NULL,
  `id_departamento` int(11) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `coordenador` int(11) NOT NULL,
  `descricao` text NOT NULL,
  `encontros` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_grupo`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_grupos VALUES ( '1', '5', '1', 'Aula de violão', '0', 'Aulas de violão com o professor Christian Schunke.', 'Semanais', '2015-03-12 17:20:16', '2015-04-11 14:32:16');
INSERT INTO tb_grupos VALUES ( '2', '5', '1', 'Aula de Teclado', '0', 'Aulas de Teclado com o Professor: Josias', 'Semanais', '2015-03-12 17:28:10', '2015-03-19 17:59:20');
INSERT INTO tb_grupos VALUES ( '3', '5', '1', 'Coral', '20', '', 'Semanais', '2015-04-06 15:11:56', '2015-06-06 16:44:10');
INSERT INTO tb_grupos VALUES ( '4', '7', '1', 'Grupo de violino', '0', '', 'Semanais', '2015-04-07 07:50:00', '2015-04-07 08:50:00');
INSERT INTO tb_grupos VALUES ( '5', '5', '6', 'Jovens', '0', '', 'Semanais', '2015-04-07 19:37:11', '2015-04-07 20:37:11');
INSERT INTO tb_grupos VALUES ( '6', '5', '11', 'Grupo com coordenador', '20', 'Teste de grupo com coordenador sendo simpatizante.', 'Indefinido', '2015-04-07 19:59:24', '2015-04-07 20:59:56');
INSERT INTO tb_grupos VALUES ( '7', '5', '10', 'Encontros de famílias', '26', '', 'Semanais', '2015-06-06 15:44:50', '2015-06-06 16:44:50');
INSERT INTO tb_grupos VALUES ( '8', '5', '6', 'Jovens mirim', '26', 'Grupo de jovens para crianças da comunidade', 'Semanais', '2015-10-20 07:50:53', '2015-10-20 09:50:53');
INSERT INTO tb_grupos VALUES ( '10', '5', '1', 'Grupo Vocal', '37', '', 'Semanais', '2016-03-30 13:09:28', '2016-03-30 15:09:28');
INSERT INTO tb_grupos VALUES ( '11', '5', '10', 'grupo de testes', '20', '', 'Semanais', '2016-04-13 15:04:02', '2016-04-13 17:04:02');
INSERT INTO tb_grupos VALUES ( '12', '5', '10', 'grupo do pem', '20', '', 'Semanais', '2016-04-20 16:21:43', '2016-04-20 18:21:43');

#
# Criação da Tabela : tb_grupos_encontros
#

CREATE TABLE `tb_grupos_encontros` (
  `id_encontro` int(11) NOT NULL AUTO_INCREMENT,
  `id_grupo` int(11) NOT NULL,
  `periodicidade` varchar(250) NOT NULL,
  `dia_semana` varchar(250) NOT NULL,
  `dia` date NOT NULL,
  `horario_inicial` time NOT NULL,
  `horario_final` time NOT NULL,
  `data_inicial` datetime NOT NULL,
  `data_final` datetime NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_encontro`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_grupos_encontros VALUES ( '9', '3', 'Semanais', '2', '2015-06-09', '01:00:00', '02:00:00', '2015-06-09 01:00:00', '2015-06-09 02:00:00', '2015-06-06 15:44:10', '2015-06-06 16:44:10');
INSERT INTO tb_grupos_encontros VALUES ( '7', '5', 'Semanais', '2', '2015-04-14', '20:00:00', '21:00:00', '2015-04-14 20:00:00', '2015-04-14 21:00:00', '2015-04-08 14:04:25', '2015-04-08 15:04:25');
INSERT INTO tb_grupos_encontros VALUES ( '8', '1', 'Semanais', '2', '2015-04-14', '20:00:00', '21:00:00', '2015-04-14 20:00:00', '2015-04-14 21:00:00', '2015-04-11 13:32:17', '2015-04-11 14:32:17');
INSERT INTO tb_grupos_encontros VALUES ( '10', '7', 'Semanais', '1', '2015-06-08', '02:00:00', '02:00:00', '2015-06-08 20:00:00', '2015-06-08 22:00:00', '2015-06-06 15:44:51', '2015-06-06 16:44:51');
INSERT INTO tb_grupos_encontros VALUES ( '11', '8', 'Semanais', '0', '2015-10-25', '01:00:00', '01:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2015-10-20 07:50:53', '2015-10-20 09:50:53');
INSERT INTO tb_grupos_encontros VALUES ( '13', '0', 'Quinzenais', '', '2015-12-08', '20:00:00', '21:00:00', '2015-12-08 20:00:00', '2015-12-08 21:00:00', '2015-12-07 15:53:44', '2015-12-07 15:53:44');
INSERT INTO tb_grupos_encontros VALUES ( '14', '0', 'Semanais', '6', '2015-12-12', '01:00:00', '02:00:00', '2015-12-12 19:00:00', '2015-12-12 20:00:00', '2015-12-07 15:57:38', '2015-12-07 15:57:38');
INSERT INTO tb_grupos_encontros VALUES ( '15', '0', 'Quinzenais', '', '2015-12-08', '19:30:00', '20:30:00', '2015-12-08 19:30:00', '2015-12-08 20:30:00', '2015-12-08 10:13:06', '2015-12-08 10:13:06');
INSERT INTO tb_grupos_encontros VALUES ( '16', '10', 'Semanais', '4', '2016-03-31', '02:00:00', '02:00:00', '2016-03-31 20:00:00', '2016-03-31 21:30:00', '2016-03-30 13:09:32', '2016-03-30 15:09:32');
INSERT INTO tb_grupos_encontros VALUES ( '17', '11', 'Semanais', '1', '2016-04-18', '02:00:00', '02:00:00', '2016-04-18 20:00:00', '2016-04-18 21:00:00', '2016-04-13 15:04:06', '2016-04-13 17:04:06');
INSERT INTO tb_grupos_encontros VALUES ( '18', '12', 'Semanais', '5', '2016-04-22', '02:00:00', '02:00:00', '2016-04-22 20:00:00', '2016-04-22 21:00:00', '2016-04-20 16:21:44', '2016-04-20 18:21:44');

#
# Criação da Tabela : tb_grupos_participantes
#

CREATE TABLE `tb_grupos_participantes` (
  `id_participante` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `id_grupo` int(11) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_participante`)
) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_grupos_participantes VALUES ( '88', '15', '2', '2015-06-09 13:38:28', '2015-06-09 14:38:28');
INSERT INTO tb_grupos_participantes VALUES ( '94', '12', '3', '2016-03-17 09:32:14', '2016-03-17 11:32:14');
INSERT INTO tb_grupos_participantes VALUES ( '82', '18', '5', '2015-04-10 12:53:31', '2015-04-10 13:53:31');
INSERT INTO tb_grupos_participantes VALUES ( '87', '5', '1', '2015-04-12 14:44:24', '2015-04-12 15:44:24');
INSERT INTO tb_grupos_participantes VALUES ( '90', '34', '8', '2015-10-20 07:52:57', '2015-10-20 09:52:57');
INSERT INTO tb_grupos_participantes VALUES ( '91', '14', '8', '2015-10-20 07:52:58', '2015-10-20 09:52:58');
INSERT INTO tb_grupos_participantes VALUES ( '66', '9', '4', '2015-04-07 07:51:28', '2015-04-07 08:51:28');
INSERT INTO tb_grupos_participantes VALUES ( '67', '14', '4', '2015-04-07 07:51:29', '2015-04-07 08:51:29');
INSERT INTO tb_grupos_participantes VALUES ( '81', '14', '5', '2015-04-10 12:53:31', '2015-04-10 13:53:31');
INSERT INTO tb_grupos_participantes VALUES ( '80', '21', '5', '2015-04-10 12:53:31', '2015-04-10 13:53:31');
INSERT INTO tb_grupos_participantes VALUES ( '89', '29', '8', '2015-10-20 07:52:57', '2015-10-20 09:52:57');
INSERT INTO tb_grupos_participantes VALUES ( '79', '20', '5', '2015-04-10 12:53:31', '2015-04-10 13:53:31');
INSERT INTO tb_grupos_participantes VALUES ( '93', '9', '3', '2016-03-17 09:32:14', '2016-03-17 11:32:14');
INSERT INTO tb_grupos_participantes VALUES ( '86', '18', '1', '2015-04-12 14:44:23', '2015-04-12 15:44:23');
INSERT INTO tb_grupos_participantes VALUES ( '85', '13', '1', '2015-04-12 14:44:22', '2015-04-12 15:44:22');
INSERT INTO tb_grupos_participantes VALUES ( '84', '17', '1', '2015-04-12 14:44:21', '2015-04-12 15:44:21');
INSERT INTO tb_grupos_participantes VALUES ( '92', '5', '3', '2016-03-17 09:32:14', '2016-03-17 11:32:14');
INSERT INTO tb_grupos_participantes VALUES ( '83', '14', '1', '2015-04-12 14:44:20', '2015-04-12 15:44:20');
INSERT INTO tb_grupos_participantes VALUES ( '95', '15', '3', '2016-03-17 09:32:14', '2016-03-17 11:32:14');
INSERT INTO tb_grupos_participantes VALUES ( '96', '9', '10', '2016-03-30 13:10:55', '2016-03-30 15:10:55');
INSERT INTO tb_grupos_participantes VALUES ( '97', '17', '10', '2016-03-30 13:10:58', '2016-03-30 15:10:58');
INSERT INTO tb_grupos_participantes VALUES ( '98', '20', '11', '2016-04-13 15:04:27', '2016-04-13 17:04:27');
INSERT INTO tb_grupos_participantes VALUES ( '99', '14', '11', '2016-04-13 15:04:32', '2016-04-13 17:04:32');
INSERT INTO tb_grupos_participantes VALUES ( '100', '20', '12', '2016-04-20 16:22:42', '2016-04-20 18:22:42');
INSERT INTO tb_grupos_participantes VALUES ( '101', '22', '12', '2016-04-20 16:22:44', '2016-04-20 18:22:44');

#
# Criação da Tabela : tb_log_financeiro
#

CREATE TABLE `tb_log_financeiro` (
  `id_log` int(11) NOT NULL AUTO_INCREMENT,
  `id_conta_bancaria` int(11) NOT NULL,
  `id_lancamento` int(11) NOT NULL,
  `saldo_anterior` decimal(15,2) NOT NULL,
  `saldo_posterior` decimal(15,2) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_log`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_log_financeiro VALUES ( '1', '2', '8', '354.00', '334.00', '2015-01-03 19:55:19', '2015-01-04 07:55:19');
INSERT INTO tb_log_financeiro VALUES ( '2', '2', '25', '333.90', '323.90', '2015-02-02 13:10:06', '2015-02-02 23:10:06');
INSERT INTO tb_log_financeiro VALUES ( '3', '2', '27', '323.90', '248.90', '2015-02-02 13:14:59', '2015-02-02 23:14:59');
INSERT INTO tb_log_financeiro VALUES ( '4', '2', '29', '248.90', '173.90', '2015-02-02 13:18:23', '2015-02-02 23:18:23');
INSERT INTO tb_log_financeiro VALUES ( '5', '2', '30', '173.90', '170.00', '2015-02-02 13:32:55', '2015-02-02 23:32:55');
INSERT INTO tb_log_financeiro VALUES ( '6', '2', '9', '170.00', '80.00', '2015-02-02 21:14:03', '2015-02-03 07:14:03');
INSERT INTO tb_log_financeiro VALUES ( '7', '2', '31', '80.00', '70.00', '2015-02-03 07:33:28', '2015-02-03 17:33:28');
INSERT INTO tb_log_financeiro VALUES ( '8', '2', '32', '70.00', '82.00', '2015-02-03 07:42:41', '2015-02-03 17:42:41');
INSERT INTO tb_log_financeiro VALUES ( '9', '2', '33', '82.00', '62.00', '2015-02-03 08:00:09', '2015-02-03 18:00:09');
INSERT INTO tb_log_financeiro VALUES ( '10', '2', '37', '62.00', '12.00', '2015-02-06 13:24:48', '2015-02-06 23:24:48');
INSERT INTO tb_log_financeiro VALUES ( '11', '2', '38', '12.00', '62.00', '2015-03-17 15:00:24', '2015-03-17 16:00:24');
INSERT INTO tb_log_financeiro VALUES ( '12', '2', '39', '62.00', '562.00', '2015-03-17 15:11:22', '2015-03-17 16:11:22');
INSERT INTO tb_log_financeiro VALUES ( '13', '2', '40', '562.00', '582.00', '2015-03-17 16:04:05', '2015-03-17 17:04:05');
INSERT INTO tb_log_financeiro VALUES ( '14', '3', '41', '5739.00', '5789.00', '2015-04-06 15:31:49', '2015-04-06 16:31:49');
INSERT INTO tb_log_financeiro VALUES ( '15', '3', '42', '5789.00', '5889.00', '2015-04-06 15:35:13', '2015-04-06 16:35:13');
INSERT INTO tb_log_financeiro VALUES ( '16', '3', '42', '5889.00', '5789.00', '2015-04-06 16:20:21', '2015-04-06 17:20:21');
INSERT INTO tb_log_financeiro VALUES ( '17', '3', '43', '5789.00', '5639.00', '2015-04-06 16:23:58', '2015-04-06 17:23:58');
INSERT INTO tb_log_financeiro VALUES ( '18', '3', '42', '5639.00', '5739.00', '2015-04-06 16:24:57', '2015-04-06 17:24:57');
INSERT INTO tb_log_financeiro VALUES ( '19', '3', '43', '5739.00', '5889.00', '2015-04-06 17:17:02', '2015-04-06 18:17:02');
INSERT INTO tb_log_financeiro VALUES ( '20', '3', '44', '5889.00', '6089.00', '2015-04-07 08:15:47', '2015-04-07 09:15:47');
INSERT INTO tb_log_financeiro VALUES ( '21', '4', '45', '500.00', '1500.00', '2015-04-07 08:40:30', '2015-04-07 09:40:30');
INSERT INTO tb_log_financeiro VALUES ( '22', '4', '46', '1500.00', '1600.00', '2015-04-07 19:29:56', '2015-04-07 20:29:56');
INSERT INTO tb_log_financeiro VALUES ( '23', '4', '47', '1600.00', '1700.00', '2015-04-08 15:04:49', '2015-04-08 16:04:49');
INSERT INTO tb_log_financeiro VALUES ( '24', '4', '48', '1700.00', '2000.00', '2015-04-10 13:33:34', '2015-04-10 14:33:34');
INSERT INTO tb_log_financeiro VALUES ( '25', '4', '49', '2000.00', '1800.00', '2015-04-11 11:49:48', '2015-04-11 12:49:48');
INSERT INTO tb_log_financeiro VALUES ( '26', '3', '50', '6089.00', '6089.00', '2015-04-16 15:22:48', '2015-04-16 16:22:48');
INSERT INTO tb_log_financeiro VALUES ( '27', '3', '51', '6089.00', '6189.00', '2015-04-16 15:25:22', '2015-04-16 16:25:22');
INSERT INTO tb_log_financeiro VALUES ( '28', '4', '52', '1800.00', '2000.00', '2015-04-16 15:26:55', '2015-04-16 16:26:55');
INSERT INTO tb_log_financeiro VALUES ( '29', '3', '53', '6189.00', '6240.00', '2015-04-16 15:28:25', '2015-04-16 16:28:25');
INSERT INTO tb_log_financeiro VALUES ( '30', '3', '54', '6240.00', '6406.67', '2015-07-28 15:14:38', '2015-07-28 16:14:38');
INSERT INTO tb_log_financeiro VALUES ( '31', '4', '57', '2000.00', '2500.00', '2015-09-22 12:29:39', '2015-09-22 13:29:39');
INSERT INTO tb_log_financeiro VALUES ( '32', '3', '58', '6406.67', '6506.67', '2016-02-17 04:54:01', '2016-02-17 08:54:01');
INSERT INTO tb_log_financeiro VALUES ( '33', '3', '59', '6506.67', '6306.67', '2016-02-18 06:48:03', '2016-02-18 10:48:03');
INSERT INTO tb_log_financeiro VALUES ( '34', '4', '60', '2500.00', '2480.00', '2016-02-18 06:51:24', '2016-02-18 10:51:24');
INSERT INTO tb_log_financeiro VALUES ( '35', '2', '61', '582.00', '232.00', '2016-02-18 07:49:50', '2016-02-18 11:49:50');
INSERT INTO tb_log_financeiro VALUES ( '36', '2', '64', '732.00', '2484.00', '2016-03-30 13:35:01', '2016-03-30 15:35:01');
INSERT INTO tb_log_financeiro VALUES ( '37', '4', '65', '1980.00', '2480.00', '2016-03-30 14:14:27', '2016-03-30 16:14:27');
INSERT INTO tb_log_financeiro VALUES ( '38', '3', '66', '6501.07', '7001.07', '2016-04-13 09:39:10', '2016-04-13 11:39:10');
INSERT INTO tb_log_financeiro VALUES ( '39', '4', '67', '2480.00', '2230.00', '2016-04-20 09:06:10', '2016-04-20 11:06:10');
INSERT INTO tb_log_financeiro VALUES ( '40', '4', '68', '2230.00', '2630.00', '2016-04-20 09:07:20', '2016-04-20 11:07:20');
INSERT INTO tb_log_financeiro VALUES ( '41', '4', '69', '2630.00', '2680.00', '2016-04-20 16:26:53', '2016-04-20 18:26:53');
INSERT INTO tb_log_financeiro VALUES ( '42', '4', '70', '2680.00', '2830.00', '2016-04-20 19:07:25', '2016-04-20 21:07:25');

#
# Criação da Tabela : tb_membros
#

CREATE TABLE `tb_membros` (
  `id_membro` int(11) NOT NULL AUTO_INCREMENT,
  `forma_entrada` varchar(250) NOT NULL,
  `id_congregacao` int(11) NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `ativo` char(3) NOT NULL,
  `afastado` varchar(250) NOT NULL,
  `sexo` char(1) NOT NULL,
  `pastor` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `rg` varchar(250) NOT NULL,
  `cpf` varchar(250) NOT NULL,
  `data_nascimento` date NOT NULL,
  `cidade_nascimento` varchar(250) NOT NULL,
  `estado_nascimento` varchar(250) NOT NULL,
  `foto` varchar(250) NOT NULL,
  `tipo_sanguineo` varchar(250) NOT NULL,
  `doador` varchar(250) NOT NULL,
  `profissao` varchar(250) NOT NULL,
  `estado_civil` varchar(250) NOT NULL,
  `cep` varchar(250) NOT NULL,
  `endereco` varchar(250) NOT NULL,
  `numero` varchar(250) NOT NULL,
  `complemento` varchar(250) NOT NULL,
  `bairro` varchar(250) NOT NULL,
  `cidade` varchar(250) NOT NULL,
  `estado` varchar(250) NOT NULL,
  `comungante` varchar(250) NOT NULL,
  `votante` varchar(30) NOT NULL,
  `envelope_oferta` varchar(30) NOT NULL,
  `horario_visita` varchar(250) NOT NULL,
  `enfermo` varchar(30) NOT NULL,
  `observacoes` text NOT NULL,
  `latitude` varchar(250) NOT NULL,
  `longitude` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_membro`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros VALUES ( '5', 'Batismo', '5', 'membro', 'sim', '', 'f', 'nao', 'Maria da Silva', '8089050671', '010.226.510-05', '1990-08-16', 'Porto Alegre', 'RS', '', '', '', '', 'casado', '93334-290', 'Avenida Vereador Adão Rodrigues de Oliveira', '737', '', 'Ideal', 'Novo Hamburgo', 'RS', '', 'sim', 'nao', '', 'nao', '', '-29.6949224', '-51.1426462', '2015-04-10 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '8', 'Profissão de fé', '5', 'membro', 'sim', '', 'm', 'sim', 'José Fonseca', '1111111111', '111.111.111-11', '1980-03-19', '', '', 'ff5154df1da755db5cc33e1d0613c2c4.jpg', 'O+', 'sim', 'Desenvolvedor Web', 'casado', '11111-111', 'Rua das Flores', '121', 'sala 2', 'Industrial', 'Novo Hamburgo', 'RS', '', 'nao', 'nao', '', 'sim', '', '-29.6798093', '-51.1264682', '0000-00-00 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '9', 'Batismo', '5', 'membro', 'sim', '', 'm', '', 'Pedro Luna Volantes', '', '131.231.231-44', '1976-02-18', '', '', '', '', '', 'Empresário', 'casado', '00000-000', 'Rua Benício', '31', '', 'Primavera', 'Novo Hamburgo', 'RS', '', 'sim', 'nao', '', '', '', '-29.6880479', '-51.1333376', '0000-00-00 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '10', 'Batismo', '5', 'membro', 'nao', '', 'm', '', 'Caio Marques dos Santos', '312321313123', '012.310.293-02', '1985-04-09', '', '', 'd2de3da9efbe85788e2499961e9caacd.jpg', '', '', '', '', '93334-400', 'Rua Monte Alegre', '1631', 'Ap 304', 'Ideal', 'Novo Hamburgo', 'RS', '', '', '', '', '', '', '-29.7003630', '-51.1444319', '2015-05-11 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '11', 'Batismo', '5', 'membro', 'sim', '', 'm', 'sim', 'Jason Litz', '123163461', '139.812.938-14', '1994-08-16', '', '', '1855e6e88b7a93d93f6591e35563e3b4.jpg', 'A+', 'sim', 'Ator', 'casado', '00000-000', 'Rua Maestrino', '09', '', 'Centro', 'Novo Hamburgo', 'RS', '', 'nao', 'nao', '', 'nao', '', '-29.6880479', '-51.1333376', '0000-00-00 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '12', 'Batismo', '5', 'membro', 'nao', '', 'f', '', 'Rosa Gonçalves Fiorina', '123145124', '213.131.241-51', '1979-08-09', '', '', '3ca0864dc21f52ed80667ad3a0d527d8.jpg', 'A-', 'nao', 'Professora', 'casado', '13111-111', 'Rua Pedro Adams Filho', '1321', 'Ap 501', 'Centro', 'Novo Hamburgo', 'RS', '', 'sim', 'nao', '', '', '', '-29.7199146', '-51.1297800', '2015-05-07 00:00:00', '2016-03-15 16:30:47');
INSERT INTO tb_membros VALUES ( '13', 'Batismo', '7', 'membro', 'sim', '', 'f', 'nao', 'Jussara Dias Golveia', '', '124.311.123-11', '1982-09-27', '', '', '5c52bb5255139e1efa2504cf145ef42e.jpg', 'A-', 'sim', 'Médica Ortopedista', 'separado', '00000-000', 'Rua Largo Schmitz', '912', 'Apto 32', 'Centro', 'Campo Bom', 'RS', '', 'nao', 'nao', '', 'nao', '', '-29.6628051', '-51.0345853', '0000-00-00 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '14', 'Batismo', '7', 'membro', 'sim', '', 'f', 'nao', 'Carolina Gütz', '23948194891', '411.929.919-21', '1988-02-08', 'Novo Hamburgo', 'RS', '137b96b2ddbfe8d45b4a0476e5ba2c33.jpg', '', '', 'Pedagoga', 'casado', '00000-000', 'Rua Renato Vasqueto', '91', '', 'Petrópolis', 'Novo Hamburgo', 'RS', '', 'nao', 'nao', '', 'nao', '', '-29.6880479', '-51.1333376', '2015-05-07 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '15', 'Batismo', '5', 'simpatizante', 'sim', '', 'f', '', 'Vanessa Dalponto', '', '919.248.181-88', '1982-03-11', '', '', '61bdc71ae0c8a724eb950b2df892ec56.jpg', 'O-', 'nao', 'Psicóloga', 'casado', '00000-000', 'Rua Benício', '1099', 'Apto 201', 'Pátria Nova', 'Novo Hamburgo', 'RS', '', '', '', '', '', '', '-29.6880479', '-51.1333376', '2015-04-06 14:30:00', '2015-11-12 15:01:16');
INSERT INTO tb_membros VALUES ( '17', 'Batismo', '7', 'membro', 'sim', '', 'f', 'nao', 'Júlia Vasconcellos', '1032910947', '921.949.147-19', '1995-05-29', '', '', 'eb00416f22187e275217a378a12ea6fe.jpg', '', '', 'Estudante', 'casado', '93334-290', 'Avenida Vereador Adão Rodrigues de Oliveira', '737', '', 'Ideal', 'Novo Hamburgo', 'RS', '', 'nao', 'nao', '', 'nao', '', '-29.6949224', '-51.1426462', '0000-00-00 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '18', 'Batismo', '7', 'membro', 'sim', '', 'm', '', 'Ricardo Pietro Leal', '99128273112', '984.194.789-18', '1990-08-30', '', '', 'de89aa2011b9715091f5e3976d1713fb.jpg', 'A+', 'sim', 'Economista', 'casado', '00000-000', 'Rua Vinicius de Moraes', '129', 'Ap 501', 'Centro', 'Novo Hamburgo', 'RS', '', 'sim', 'nao', '', '', '', '-29.6810973', '-51.1061503', '2015-05-07 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '19', 'Batismo', '5', 'membro', 'nao', '', 'm', '', 'Vinicius Jardins', '', '989.481.481-20', '1995-06-09', '', '', '839cc77a882ade2162d3de06b72a597c.jpg', '', '', 'Estudante', 'solteiro', '00000-000', 'Rua Pedro Adams Filho', '2831', 'Ap 304', 'Ouro Branco', 'Novo Hamburgo', 'RS', '', '', '', '', '', '', '-29.7069193', '-51.1313895', '0000-00-00 00:00:00', '2015-12-09 19:26:25');
INSERT INTO tb_membros VALUES ( '20', 'Batismo', '5', 'membro', 'sim', 'sim', 'm', 'sim', 'Alberto Solimões', '10932103901', '312.039.102-39', '1985-02-12', 'Novo Hamburgo', 'RS', 'a3a815ab086c46a5134b889b9c0b19c3.jpg', 'A-', 'nao', 'Motoboy', 'casado', '00000-000', 'Rua das Flores', '52', '', 'Primavera', 'Novo Hamburgo', 'RS', '', 'sim', 'nao', '', 'nao', '', '-29.6800040', '-51.1271620', '2015-04-01 00:00:00', '2016-04-13 15:38:42');
INSERT INTO tb_membros VALUES ( '21', 'Batismo', '5', 'membro', 'sim', '', 'm', '', 'Alfredo Bitencourt', '', '084.912.049-12', '1948-11-23', '', '', '49f8efa6de6d5867c50e4b98d4d9f2c9.jpg', '', '', 'Aposentado', 'casado', '00000-000', 'Rua Luiza Santos', '963', '', 'Rio Branco', 'Novo Hamburgo', 'RS', '', 'nao', 'nao', '', '', '', '-29.6880479', '-51.1333376', '0000-00-00 00:00:00', '2015-12-09 19:26:26');
INSERT INTO tb_membros VALUES ( '22', 'Batismo', '5', 'membro', 'sim', '', 'f', 'nao', 'Gertrudes Afonseca', '29843198112', '984.129.489-12', '1942-08-07', 'Novo Hamburgo', 'RS', '', '', '', 'Aposentada', 'viuvo', '00000-000', 'Rua Bento Gonçalves', '819', 'Apto 201', 'Centro', 'Novo Hamburgo', 'RS', '', 'nao', 'nao', '', 'nao', '', '-29.6992131', '-51.1271266', '2015-05-07 00:00:00', '2015-12-09 19:26:26');
INSERT INTO tb_membros VALUES ( '23', 'Batismo', '5', 'membro', 'nao', '', 'f', '', 'Joana Soares Trumann', '', '941.023.479-12', '1949-01-17', '', '', '035367916cb211a999ff30cc374a1f25.jpg', 'B-', 'sim', 'Aposentada', 'viuvo', '00000-000', 'Rua Benício', '287', 'Apto 603', 'Ideal', 'Novo Hamburgo', 'RS', '', '', '', '', '', '', '-29.6880479', '-51.1333376', '0000-00-00 00:00:00', '2015-12-09 19:26:26');
INSERT INTO tb_membros VALUES ( '26', 'Transferência', '5', 'membro', 'sim', 'nao', 'm', 'nao', 'Carlos Eduardo Souza', '2354235353', '235.923.592-39', '1989-12-10', 'Porto Alegre', 'RS', '', '', '', '', 'casado', '93334-290', 'Avenida Vereador Adão Rodrigues de Oliveira', '737', '', 'Ideal', 'Novo Hamburgo', 'RS', 'nao', 'nao', 'nao', '', 'nao', '', '-29.6958086', '-51.1422493', '1990-04-29 00:00:00', '2017-08-18 17:56:53');
INSERT INTO tb_membros VALUES ( '29', 'Profissão de fé', '5', 'membro', 'nao', '', 'f', 'nao', 'Abigail Solimões', '91248910134', '019.301.293-01', '1978-05-15', 'Porto Alegre', 'RS', 'd1326c0b04b06f4bbf6e0b11f84ed41c.jpg', 'O+', 'nao', 'Empresária', 'solteiro', '00000-000', 'Rua Bento Gonçalves', '991', '', 'Centro', 'Novo Hamburgo', 'RS', '', 'sim', 'sim', '15:30', 'sim', '', '-29.6978177', '-51.1270371', '2015-04-01 00:00:00', '2015-12-09 19:26:26');
INSERT INTO tb_membros VALUES ( '30', 'Profissão de fé', '5', 'membro', 'nao', '', 'm', 'nao', 'Andrés D\'alessandro', '651', '161.651.651-16', '1990-06-26', 'Buenos Aires', 'AR', '', '', '', '', '', '', '', '', '', '', '', '', '', 'nao', 'nao', '10:15', 'nao', '', '', '', '0000-00-00 00:00:00', '2016-02-24 21:40:46');
INSERT INTO tb_membros VALUES ( '33', 'Batismo', '5', 'membro', 'nao', '', 'm', 'nao', 'Fabio Teste', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'sim', 'sim', '', 'nao', '', '', '', '0000-00-00 00:00:00', '2015-12-09 19:26:26');
INSERT INTO tb_membros VALUES ( '34', 'Batismo', '5', 'membro', 'nao', '', 'm', 'nao', 'Alessandra', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'nao', 'nao', '09:30', 'nao', '', '', '', '0000-00-00 00:00:00', '2016-04-19 17:33:35');
INSERT INTO tb_membros VALUES ( '35', 'Profissão de fé', '5', 'membro', 'sim', '', 'm', 'nao', 'teste de memro', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'nao', 'sim', '', 'nao', '', '', '', '0000-00-00 00:00:00', '2015-12-09 19:26:26');
INSERT INTO tb_membros VALUES ( '37', 'Profissão de fé', '5', 'membro', 'sim', '', 'm', 'nao', 'Eduardo Levi Kuhn', '1043946464', '508.542.160-49', '1966-05-23', 'Alvorada', 'Rio Grande do Sul', '', 'A negativo', 'sim', 'Professor', 'casado', '94920-100', 'Avenida Coronel João Batista S. da Silveira e Souza', '398', '304', 'Vila Eunice Nova', 'Cachoeirinha', 'RS', '', 'nao', 'sim', '', 'nao', '', '-29.9555427', '-51.1014186', '1986-09-12 00:00:00', '2016-03-30 14:55:10');
INSERT INTO tb_membros VALUES ( '38', 'Batismo', '7', 'membro', 'sim', 'sim', 'm', 'nao', 'Evanir Johann Oliveira', '212165166164', '626.161.616-16', '1973-06-04', 'Canoas', 'RS', '', 'A+', 'sim', 'Marceneiro', 'casado', '95709-899', 'Área Rural', '3465', 'ap 405', 'Área Rural de Bento Gonçalves', 'Bento Gonçalves', 'RS', '', 'sim', 'sim', '', 'sim', '', '-29.1667089', '-51.5169861', '2016-04-13 00:00:00', '2016-04-13 16:20:19');
INSERT INTO tb_membros VALUES ( '39', 'Batismo', '5', 'membro', 'sim', 'nao', 'm', 'nao', 'Anderson Glaeser', '', '', '2016-04-16', 'Novo Hamburgo', 'RS', '875038b2516f6c136a62e535e621c974.jpg', '', '', '', 'casado', '', '', '', '', '', '', '', '', 'nao', 'sim', '', 'nao', '', '-14.2350040', '-51.9252800', '2016-04-14 00:00:00', '2017-01-06 09:37:40');
INSERT INTO tb_membros VALUES ( '40', 'Batismo', '5', 'membro', 'sim', 'nao', 'm', 'nao', 'José Glaeser', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'nao', 'nao', 'sim', '', 'nao', '', '-14.2350040', '-51.9252800', '2016-04-19 00:00:00', '2017-01-06 10:28:50');
INSERT INTO tb_membros VALUES ( '41', 'Batismo', '5', 'simpatizante', 'sim', 'nao', 'm', 'nao', 'Teste da silva', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'nao', 'sim', '', 'nao', '', '-14.2350040', '-51.9252800', '0000-00-00 00:00:00', '2016-05-31 14:24:51');

#
# Criação da Tabela : tb_membros_batismo
#

CREATE TABLE `tb_membros_batismo` (
  `id_batismo` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `data_batismo` date NOT NULL,
  `pai` varchar(250) NOT NULL,
  `mae` varchar(250) NOT NULL,
  `congregacao` varchar(250) NOT NULL,
  `oficiante` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_batismo`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_batismo VALUES ( '10', '5', '2015-04-10', '8', '12', 'Congregação Ev. Luterana São Paulo - Novo Hamburgo/RS', 'José Fonseca', '2015-04-10 16:25:58', '2015-04-11 11:36:28');
INSERT INTO tb_membros_batismo VALUES ( '11', '20', '2015-04-01', '29', '20', 'Paróquia de testes - Novo Hamburgo/RS', '', '2015-04-11 10:46:24', '2015-04-11 11:46:24');
INSERT INTO tb_membros_batismo VALUES ( '13', '29', '2015-04-11', '26', '5', 'Paróquia de testes - Novo Hamburgo/RS', 'Salavar Silva', '2015-04-11 10:58:35', '2015-04-11 11:58:35');
INSERT INTO tb_membros_batismo VALUES ( '14', '26', '1990-04-29', 'Arnoni Lauri Schünke', '29', 'Suporte F5 SAPI - Novo Hamburgo/RS', 'Antônio Silva', '2015-04-29 10:46:45', '2015-04-29 12:02:01');
INSERT INTO tb_membros_batismo VALUES ( '15', '12', '2015-05-07', 'teste 2', 'teste 1', 'Suporte F5 SAPI - Novo Hamburgo/RS', 'teste', '2015-05-07 10:23:31', '2015-05-07 11:23:31');
INSERT INTO tb_membros_batismo VALUES ( '16', '10', '2015-05-11', '29', '26', 'Suporte F5 SAPI - Novo Hamburgo/RS', 'aaa', '2015-05-07 10:59:47', '2015-05-07 11:59:47');
INSERT INTO tb_membros_batismo VALUES ( '17', '22', '2015-05-07', 'aefeafaf', 'efafaef', 'Suporte F5 SAPI - Novo Hamburgo/RS', '25325', '2015-05-07 13:48:36', '2015-05-07 14:48:36');
INSERT INTO tb_membros_batismo VALUES ( '18', '14', '2015-05-07', 'José', 'Maria', 'Suporte F5 SAPI - Novo Hamburgo/RS', 'João', '2015-05-07 14:04:50', '2015-05-07 15:04:50');
INSERT INTO tb_membros_batismo VALUES ( '19', '18', '2015-05-07', '26', '29', 'Suporte F5 SAPI - Novo Hamburgo/RS', 'teste', '2015-05-07 15:08:40', '2015-05-07 16:08:40');
INSERT INTO tb_membros_batismo VALUES ( '20', '39', '1990-08-16', 'Eloi', 'Maria', 'Suporte F5 SAPI - Novo Hamburgo/RS', 'joao da silva', '2016-04-19 14:30:22', '2016-04-19 16:30:22');

#
# Criação da Tabela : tb_membros_batismo_padrinhos
#

CREATE TABLE `tb_membros_batismo_padrinhos` (
  `id_padrinho` int(11) NOT NULL AUTO_INCREMENT,
  `id_batismo` int(11) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_padrinho`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_batismo_padrinhos VALUES ( '35', '1', 'Darlene', '2015-03-03 18:51:22', '2015-03-03 20:51:22');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '36', '1', 'Leomar', '2015-03-03 18:51:22', '2015-03-03 20:51:22');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '37', '8', 'beckerts', '2015-03-06 17:46:08', '2015-03-06 19:46:08');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '38', '8', 'elwanger krauses', '2015-03-06 17:46:08', '2015-03-06 19:46:08');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '39', '7', 'Lucas', '2015-03-13 19:37:52', '2015-03-13 20:37:52');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '40', '7', 'Maria', '2015-03-13 19:37:52', '2015-03-13 20:37:52');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '41', '9', '', '2015-04-01 16:12:04', '2015-04-01 17:12:04');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '43', '11', '', '2015-04-11 10:46:24', '2015-04-11 11:46:24');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '44', '13', 'Teste ção 1', '2015-04-11 10:58:35', '2015-04-11 11:58:35');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '45', '13', 'Teste ção 2', '2015-04-11 10:58:35', '2015-04-11 11:58:35');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '54', '14', 'Padrinho 1', '2015-04-29 11:02:01', '2015-04-29 12:02:01');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '55', '15', 'teste 4', '2015-05-07 10:23:31', '2015-05-07 11:23:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '56', '15', 'teste 5', '2015-05-07 10:23:31', '2015-05-07 11:23:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '57', '16', 'aaaa', '2015-05-07 10:59:47', '2015-05-07 11:59:47');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '58', '17', '23523532', '2015-05-07 13:48:36', '2015-05-07 14:48:36');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '60', '19', 'teste', '2015-05-07 15:08:40', '2015-05-07 16:08:40');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '61', '18', 'Roberto', '2015-10-20 08:42:11', '2015-10-20 10:42:11');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '62', '18', 'Roberto aaa', '2015-10-20 08:42:11', '2015-10-20 10:42:11');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '63', '18', 'Roberto', '2015-10-20 08:42:12', '2015-10-20 10:42:12');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '64', '18', 'Roberto aaa', '2015-10-20 08:42:12', '2015-10-20 10:42:12');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '65', '18', 'Roberto', '2015-10-20 08:42:12', '2015-10-20 10:42:12');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '66', '18', 'Roberto aaa', '2015-10-20 08:42:12', '2015-10-20 10:42:12');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '90', '20', 'a', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '91', '20', 'b', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '92', '20', 'c', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '93', '20', 'd', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '94', '20', 'e', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '95', '20', 'f', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '96', '20', 'g', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '97', '20', 'h', '2016-04-27 09:28:31', '2016-04-27 11:28:31');
INSERT INTO tb_membros_batismo_padrinhos VALUES ( '98', '20', 'i', '2016-04-27 09:28:31', '2016-04-27 11:28:31');

#
# Criação da Tabela : tb_membros_casamentos
#

CREATE TABLE `tb_membros_casamentos` (
  `id_casamento` int(11) NOT NULL AUTO_INCREMENT,
  `membro1` varchar(250) NOT NULL,
  `membro2` varchar(250) NOT NULL,
  `data_casamento` date NOT NULL,
  `oficiante` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_casamento`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_casamentos VALUES ( '4', '9', '12', '2008-04-02', 'Lázaro Ramos', '2015-04-01 16:09:27', '2015-04-10 16:40:28');
INSERT INTO tb_membros_casamentos VALUES ( '5', '26', '29', '2015-04-07', 'Ludovico Silva', '2015-04-06 21:07:12', '2015-04-10 16:40:48');
INSERT INTO tb_membros_casamentos VALUES ( '6', '18', '5', '2015-04-10', 'José Fonseca', '2015-04-10 00:00:00', '2015-04-10 16:37:36');
INSERT INTO tb_membros_casamentos VALUES ( '9', '20', '14', '2014-02-25', 'Jason Litz', '2015-04-10 16:40:50', '2015-04-10 17:40:50');
INSERT INTO tb_membros_casamentos VALUES ( '10', '17', '21', '2015-04-01', 'Gilnei Abençoado', '2015-04-10 17:59:12', '2015-04-10 18:59:12');
INSERT INTO tb_membros_casamentos VALUES ( '11', '11', '15', '2015-10-23', 'teste', '2015-10-23 09:06:22', '2015-10-23 11:06:22');
INSERT INTO tb_membros_casamentos VALUES ( '12', '39', '', '0000-00-00', '', '2017-01-06 05:37:40', '2017-01-06 09:37:40');

#
# Criação da Tabela : tb_membros_casamentos_padrinhos
#

CREATE TABLE `tb_membros_casamentos_padrinhos` (
  `id_padrinho` int(11) NOT NULL AUTO_INCREMENT,
  `id_casamento` int(11) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_padrinho`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '8', '3', 'Pedro', '2015-02-26 16:13:27', '2015-02-26 18:13:27');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '9', '4', '', '2015-04-01 16:09:27', '2015-04-01 17:09:27');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '17', '10', 'Cassandra Mesquita', '2015-04-10 17:59:53', '2015-04-10 18:59:53');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '18', '10', 'Guilherme Villa', '2015-04-10 17:59:53', '2015-04-10 18:59:53');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '19', '5', 'Silva Regina', '2015-04-11 10:45:07', '2015-04-11 11:45:07');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '20', '5', 'Rogério Bastille', '2015-04-11 10:45:07', '2015-04-11 11:45:07');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '23', '11', 'josé da silva', '2015-10-23 09:07:20', '2015-10-23 11:07:20');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '24', '11', 'maria silva', '2015-10-23 09:07:20', '2015-10-23 11:07:20');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '25', '9', 'Pedro Lula Volantez', '2016-04-20 11:53:06', '2016-04-20 13:53:06');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '26', '9', 'joao', '2016-04-20 11:53:06', '2016-04-20 13:53:06');
INSERT INTO tb_membros_casamentos_padrinhos VALUES ( '27', '12', '', '2017-01-06 05:37:40', '2017-01-06 09:37:40');

#
# Criação da Tabela : tb_membros_confirmacao
#

CREATE TABLE `tb_membros_confirmacao` (
  `id_confirmacao` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `data_confirmacao` date NOT NULL,
  `oficiante` varchar(250) NOT NULL,
  `versiculo` varchar(250) NOT NULL DEFAULT 'Ponha sua vida nas mãos do SENHOR, confia nele, e ele o ajudará.',
  `livro` varchar(250) NOT NULL DEFAULT 'Salmos 37.5',
  `local` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_confirmacao`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_confirmacao VALUES ( '7', '6', '2015-02-11', 'Pedro & João', 'Ponha sua vida nas mãos do SENHOR, confia nele, e ele o ajudará.', 'Salmos 37.5', '', '2015-02-26 08:21:16', '2015-02-26 16:40:05');
INSERT INTO tb_membros_confirmacao VALUES ( '8', '5', '2015-03-03', 'Anderson Glaeser', 'Ponha sua vida nas mãos do SENHOR, confia nele, e ele o ajudará.', 'Salmos 37.5', '', '2015-03-03 17:07:26', '2015-09-11 16:03:46');
INSERT INTO tb_membros_confirmacao VALUES ( '9', '18', '2016-03-16', 'Teste de oficiante', 'Lorem ipsum dolor sit amet, consectuer gravida. Dolorem ipsum.', 'Teste de mensagem na certidão', '', '2016-03-16 14:13:29', '2016-03-16 16:13:29');

#
# Criação da Tabela : tb_membros_desligamento
#

CREATE TABLE `tb_membros_desligamento` (
  `id_desligamento` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `data_desligamento` date NOT NULL,
  `admissao_desatualizada` char(3) NOT NULL,
  `paroquia_destino` varchar(250) NOT NULL,
  `pastor_destino` varchar(250) NOT NULL,
  `versiculo` text NOT NULL,
  `pastor_assinatura` varchar(250) NOT NULL,
  `diretoria_assinatura` varchar(250) NOT NULL,
  `auto_exclusao` varchar(250) NOT NULL,
  `observacoes` text NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_desligamento`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_desligamento VALUES ( '1', '10', 'Transferência paroquial', '2015-04-06', '', 'Bom Pastor', '', '', '', '', '', 'Motivos profissionais.', '2015-04-06 13:39:33', '2015-04-06 15:42:02');
INSERT INTO tb_membros_desligamento VALUES ( '2', '23', 'Óbito', '2015-04-06', '', '', '', '', '', '', '', 'Falecimento por causa de câncer.', '2015-04-06 17:02:30', '2015-04-06 18:02:30');
INSERT INTO tb_membros_desligamento VALUES ( '3', '33', 'Transferência paroquial', '2015-10-24', '', 'igreja católica', 'teste1', 'teste2', 'teste3', 'teste4', '', '', '2015-10-24 11:28:01', '2015-10-24 13:28:01');
INSERT INTO tb_membros_desligamento VALUES ( '4', '29', 'Transferência paroquial', '2015-11-19', '', 'Teste', 'Pastor Teste', 'João 15.2', 'Pastor Teste 2', 'Testezinho', '', 'Nada', '2015-11-20 10:42:48', '2015-11-20 13:52:53');
INSERT INTO tb_membros_desligamento VALUES ( '5', '20', 'Desligamento da igreja', '2015-11-19', '', 'Teste', 'Pastor Teste', 'João 15.2', 'Pastor Teste 2', 'Testezinho', '', 'Nada', '2015-11-20 10:42:48', '2016-01-13 10:37:17');
INSERT INTO tb_membros_desligamento VALUES ( '6', '21', 'Transferência paroquial', '2015-11-19', '', 'Teste', 'Pastor Teste', 'João 15.2', 'Pastor Teste 2', 'Testezinho', '', 'Nada', '2015-11-20 10:42:48', '2015-11-20 13:52:53');
INSERT INTO tb_membros_desligamento VALUES ( '7', '30', 'Desligamento da igreja', '2016-02-24', '', '', '', '', '', '', '', '', '2016-02-24 18:40:46', '2016-02-24 21:40:46');
INSERT INTO tb_membros_desligamento VALUES ( '8', '0', 'Óbito', '2016-04-19', '', '', '', '', '', '', '', '', '2016-02-24 18:40:46', '2016-04-19 17:33:35');
INSERT INTO tb_membros_desligamento VALUES ( '9', '12', 'Transferência paroquial', '2016-03-15', '', 'Teste', 'Teste', 'Teste', 'Teste', 'Teste', '', 'Teste', '2016-03-15 14:30:47', '2016-03-15 16:30:47');
INSERT INTO tb_membros_desligamento VALUES ( '10', '35', 'Transferência paroquial', '2016-03-15', '', 'Teste', 'Teste', 'Teste', 'Teste', 'Teste', '', 'Teste', '2016-03-15 14:30:47', '2016-03-15 16:30:47');
INSERT INTO tb_membros_desligamento VALUES ( '11', '22', 'Transferência paroquial', '2016-03-15', '', 'Teste', 'Teste', 'Teste', 'Teste', 'Teste', '', 'Teste', '2016-03-15 14:30:47', '2016-03-15 16:30:47');
INSERT INTO tb_membros_desligamento VALUES ( '12', '34', 'Óbito', '2016-04-19', '', '', '', '', '', '', '', '', '2016-04-19 15:33:35', '2016-04-19 17:33:35');

#
# Criação da Tabela : tb_membros_emails
#

CREATE TABLE `tb_membros_emails` (
  `id_email` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `email` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_email`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_emails VALUES ( '28', '4', 'arnoni@f5digital.com.br', '2015-02-19 11:42:24', '2015-02-19 14:42:24');
INSERT INTO tb_membros_emails VALUES ( '29', '4', 'anderson@f5digital.com.br', '2015-02-19 11:42:24', '2015-02-19 14:42:24');
INSERT INTO tb_membros_emails VALUES ( '46', '6', 'anderson@f5digital.com.br', '2015-03-10 17:28:23', '2015-03-10 18:28:23');
INSERT INTO tb_membros_emails VALUES ( '47', '3', 'fabio@f5digital.com.br', '2015-03-12 17:30:19', '2015-03-12 18:30:19');
INSERT INTO tb_membros_emails VALUES ( '56', '12', 'rosa091@hotmail.com', '2015-04-01 16:36:47', '2015-04-01 17:36:47');
INSERT INTO tb_membros_emails VALUES ( '57', '9', 'pedroluna01@yahoo.com.br', '2015-04-01 16:37:54', '2015-04-01 17:37:54');
INSERT INTO tb_membros_emails VALUES ( '60', '15', 'dalponto.vek@hotmail.com', '2015-04-06 14:30:00', '2015-04-06 15:30:00');
INSERT INTO tb_membros_emails VALUES ( '61', '16', 'julialegal@gmail.com', '2015-04-06 14:34:40', '2015-04-06 15:34:40');
INSERT INTO tb_membros_emails VALUES ( '64', '19', 'vinicius.klak@gmail.com', '2015-04-06 14:42:58', '2015-04-06 15:42:58');
INSERT INTO tb_membros_emails VALUES ( '68', '18', 'ricardo.leal@gmail.com', '2015-04-08 15:38:37', '2015-04-08 16:38:37');
INSERT INTO tb_membros_emails VALUES ( '84', '17', 'julialegal@gmail.com', '2015-04-12 10:26:38', '2015-04-12 11:26:38');
INSERT INTO tb_membros_emails VALUES ( '87', '11', 'jasonlitz@gmail.com', '2015-04-29 17:29:03', '2015-04-29 18:29:03');
INSERT INTO tb_membros_emails VALUES ( '89', '14', 'carolzinha123@uol.com.br', '2015-05-07 14:05:14', '2015-05-07 15:05:14');
INSERT INTO tb_membros_emails VALUES ( '91', '13', 'jussaragolveia@gmail.com', '2015-08-12 09:45:45', '2015-08-12 10:45:45');
INSERT INTO tb_membros_emails VALUES ( '92', '8', 'fonsecajose@gmail.com', '2015-08-25 08:36:06', '2015-08-25 09:36:06');
INSERT INTO tb_membros_emails VALUES ( '94', '29', 'abigail@gmail.com', '2015-08-25 10:14:15', '2015-08-25 11:14:15');
INSERT INTO tb_membros_emails VALUES ( '100', '37', 'eduardo.kibe@hotmail.com', '2016-03-30 13:04:26', '2016-03-30 15:04:26');
INSERT INTO tb_membros_emails VALUES ( '101', '20', 'albertogenuino@gmail.com', '2016-04-13 13:38:43', '2016-04-13 15:38:43');
INSERT INTO tb_membros_emails VALUES ( '105', '38', 'evanir.johann@hotmail.com', '2016-04-13 14:20:20', '2016-04-13 16:20:20');
INSERT INTO tb_membros_emails VALUES ( '108', '39', 'anderson@f5digital.com.br', '2016-04-15 01:57:39', '2016-04-15 03:57:39');

#
# Criação da Tabela : tb_membros_entrada_transferencia
#

CREATE TABLE `tb_membros_entrada_transferencia` (
  `id_entrada` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `data_transferencia` date NOT NULL,
  `paroquia_anterior` varchar(250) NOT NULL,
  `observacoes` text NOT NULL,
  `arquivo_historico` varchar(300) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_entrada`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_entrada_transferencia VALUES ( '10', '27', '2015-04-06', 'São Lucas', 'Transferência por motivos de trabalho.', 'layout.jpg', '2015-04-06 20:51:28', '2015-04-06 21:51:28');
INSERT INTO tb_membros_entrada_transferencia VALUES ( '11', '28', '2015-04-07', 'teste', 'teste', '1.jpg', '2015-04-07 17:30:40', '2015-04-07 18:30:40');

#
# Criação da Tabela : tb_membros_familias
#

CREATE TABLE `tb_membros_familias` (
  `id_familia` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `id_membro2` int(11) NOT NULL,
  `parentesco` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_familia`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_familias VALUES ( '40', '20', '14', 'esposa', '2015-04-10 16:40:50', '2015-04-10 17:40:50');
INSERT INTO tb_membros_familias VALUES ( '18', '14', '8', 'Irmão(a)', '2015-04-08 16:24:16', '2015-04-08 17:24:16');
INSERT INTO tb_membros_familias VALUES ( '17', '8', '14', 'Irmão(a)', '2015-04-08 16:24:16', '2015-04-08 17:24:16');
INSERT INTO tb_membros_familias VALUES ( '15', '9', '5', 'Esposa', '2015-03-20 16:12:00', '2015-03-20 17:12:00');
INSERT INTO tb_membros_familias VALUES ( '43', '18', '26', 'Pai', '2015-05-07 15:08:40', '2015-05-07 16:08:40');
INSERT INTO tb_membros_familias VALUES ( '31', '18', '5', 'Esposa', '2015-04-10 15:35:47', '2015-04-10 16:35:47');
INSERT INTO tb_membros_familias VALUES ( '32', '5', '18', 'Marido', '2015-04-10 15:35:47', '2015-04-10 16:35:47');
INSERT INTO tb_membros_familias VALUES ( '39', '14', '20', 'marido', '2015-04-10 16:40:50', '2015-04-10 17:40:50');
INSERT INTO tb_membros_familias VALUES ( '42', '17', '21', 'marido', '2015-04-10 17:59:12', '2015-04-10 18:59:12');
INSERT INTO tb_membros_familias VALUES ( '41', '21', '17', 'esposa', '2015-04-10 17:59:12', '2015-04-10 18:59:12');
INSERT INTO tb_membros_familias VALUES ( '44', '26', '18', 'Filho(a)', '2015-05-07 15:08:40', '2015-05-07 16:08:40');
INSERT INTO tb_membros_familias VALUES ( '45', '18', '29', 'Mãe', '2015-05-07 15:08:40', '2015-05-07 16:08:40');
INSERT INTO tb_membros_familias VALUES ( '46', '29', '18', 'Filho(a)', '2015-05-07 15:08:40', '2015-05-07 16:08:40');
INSERT INTO tb_membros_familias VALUES ( '47', '20', '26', 'Avô', '2015-09-25 14:25:34', '2015-09-25 15:25:34');
INSERT INTO tb_membros_familias VALUES ( '48', '26', '20', 'Neto(a)', '2015-09-25 14:25:34', '2015-09-25 15:25:34');
INSERT INTO tb_membros_familias VALUES ( '49', '15', '11', 'marido', '2015-10-23 09:06:38', '2015-10-23 11:06:38');
INSERT INTO tb_membros_familias VALUES ( '50', '11', '15', 'esposa', '2015-10-23 09:06:41', '2015-10-23 11:06:41');
INSERT INTO tb_membros_familias VALUES ( '51', '20', '10', 'Irmão(a)', '2015-12-01 13:21:14', '2015-12-01 13:21:14');
INSERT INTO tb_membros_familias VALUES ( '52', '10', '20', 'Irmão(a)', '2015-12-01 13:21:14', '2015-12-01 13:21:14');
INSERT INTO tb_membros_familias VALUES ( '53', '17', '29', 'Irmão(a)', '2016-04-20 15:16:24', '2016-04-20 17:16:24');
INSERT INTO tb_membros_familias VALUES ( '54', '29', '17', 'Irmão(a)', '2016-04-20 15:16:24', '2016-04-20 17:16:24');
INSERT INTO tb_membros_familias VALUES ( '55', '0', '39', 'marido', '2017-01-06 05:37:40', '2017-01-06 09:37:40');
INSERT INTO tb_membros_familias VALUES ( '56', '39', '0', 'esposa', '2017-01-06 05:37:40', '2017-01-06 09:37:40');
INSERT INTO tb_membros_familias VALUES ( '57', '21', '15', 'Mãe', '2017-08-18 20:33:22', '2017-08-18 20:33:22');
INSERT INTO tb_membros_familias VALUES ( '58', '15', '21', 'Filho(a)', '2017-08-18 20:33:22', '2017-08-18 20:33:22');

#
# Criação da Tabela : tb_membros_ofertas
#

CREATE TABLE `tb_membros_ofertas` (
  `id_oferta` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `id_financeiro` int(11) NOT NULL,
  `id_centro_custo` int(11) NOT NULL,
  `valor` decimal(15,2) NOT NULL,
  `data_pagamento` date NOT NULL,
  `referencia` varchar(250) NOT NULL,
  `data_cadastro` date NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_oferta`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_ofertas VALUES ( '9', '29', '53', '6', '49.00', '2015-04-16', '123', '2015-04-16', '2015-04-16 17:04:31');
INSERT INTO tb_membros_ofertas VALUES ( '10', '20', '53', '6', '61.00', '2015-04-16', '456', '2015-04-16', '2015-04-16 17:04:31');
INSERT INTO tb_membros_ofertas VALUES ( '11', '20', '57', '2', '500.00', '2015-09-22', 'setembro/2015', '2015-09-22', '2015-09-22 13:29:39');
INSERT INTO tb_membros_ofertas VALUES ( '12', '29', '57', '2', '500.00', '2015-09-22', '', '2015-09-22', '2015-09-22 13:29:39');
INSERT INTO tb_membros_ofertas VALUES ( '13', '20', '66', '2', '100.00', '2016-04-13', '', '2016-04-13', '2016-04-13 11:39:10');
INSERT INTO tb_membros_ofertas VALUES ( '14', '21', '66', '2', '100.00', '2016-04-13', '', '2016-04-13', '2016-04-13 11:39:10');
INSERT INTO tb_membros_ofertas VALUES ( '15', '26', '66', '2', '100.00', '2016-04-13', '', '2016-04-13', '2016-04-13 11:39:10');
INSERT INTO tb_membros_ofertas VALUES ( '16', '11', '66', '2', '100.00', '2016-04-13', '', '2016-04-13', '2016-04-13 11:39:10');
INSERT INTO tb_membros_ofertas VALUES ( '17', '17', '66', '2', '100.00', '2016-04-13', '', '2016-04-13', '2016-04-13 11:39:10');
INSERT INTO tb_membros_ofertas VALUES ( '18', '21', '69', '2', '50.00', '2016-04-20', 'Abril/2016', '2016-04-20', '2016-04-20 18:26:53');
INSERT INTO tb_membros_ofertas VALUES ( '19', '22', '70', '2', '50.00', '2016-04-20', 'janeiro/2016', '2016-04-20', '2016-04-20 21:07:25');
INSERT INTO tb_membros_ofertas VALUES ( '20', '22', '70', '2', '100.00', '2016-04-20', 'fevereiro/2016', '2016-04-20', '2016-04-20 21:07:25');

#
# Criação da Tabela : tb_membros_profissao_de_fe
#

CREATE TABLE `tb_membros_profissao_de_fe` (
  `id_profissao_de_fe` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `data_profissao_de_fe` date NOT NULL,
  `oficiante` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_profissao_de_fe`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_profissao_de_fe VALUES ( '2', '6', '2015-02-12', 'Pedro José Silva', '2015-02-26 15:04:49', '2015-02-26 17:26:10');
INSERT INTO tb_membros_profissao_de_fe VALUES ( '3', '29', '2015-04-01', 'Rodrigo Fontoura', '2015-04-08 15:56:48', '2015-04-08 16:56:48');
INSERT INTO tb_membros_profissao_de_fe VALUES ( '4', '20', '2015-06-25', 'Pastor Fernando', '2015-06-26 12:16:55', '2015-06-26 13:16:55');
INSERT INTO tb_membros_profissao_de_fe VALUES ( '5', '13', '2015-08-12', 'Nome do oficiante', '2015-08-12 09:45:38', '2015-08-12 10:45:38');

#
# Criação da Tabela : tb_membros_telefones
#

CREATE TABLE `tb_membros_telefones` (
  `id_telefone` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `numero` varchar(250) NOT NULL,
  `operadora` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_telefone`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_membros_telefones VALUES ( '19', '4', '(51) 9910.8062', '', '2015-02-19 11:42:24', '2015-02-19 14:42:24');
INSERT INTO tb_membros_telefones VALUES ( '20', '4', '(51) 3066.0669', '', '2015-02-19 11:42:24', '2015-02-19 14:42:24');
INSERT INTO tb_membros_telefones VALUES ( '36', '6', '(51) 3066.0669', '', '2015-03-10 17:28:23', '2015-03-10 18:28:23');
INSERT INTO tb_membros_telefones VALUES ( '37', '3', '(51) 3066.0669', '', '2015-03-12 17:30:19', '2015-03-12 18:30:19');
INSERT INTO tb_membros_telefones VALUES ( '47', '9', '(51) 9912.3191', '', '2015-04-01 16:37:54', '2015-04-01 17:37:54');
INSERT INTO tb_membros_telefones VALUES ( '50', '16', '(51) 9091.2922', '', '2015-04-06 14:34:40', '2015-04-06 15:34:40');
INSERT INTO tb_membros_telefones VALUES ( '52', '19', '(51) 9928.3918', '', '2015-04-06 14:42:58', '2015-04-06 15:42:58');
INSERT INTO tb_membros_telefones VALUES ( '54', '21', '(51) 3030.1123', '', '2015-04-06 16:56:53', '2015-04-06 17:56:53');
INSERT INTO tb_membros_telefones VALUES ( '67', '17', '(51) 9912.8911', '', '2015-04-12 10:26:38', '2015-04-12 11:26:38');
INSERT INTO tb_membros_telefones VALUES ( '68', '11', '(51) 9912.9314', '', '2015-04-29 17:29:03', '2015-04-29 18:29:03');
INSERT INTO tb_membros_telefones VALUES ( '70', '22', '(51) 9201.2391', '', '2015-05-07 14:03:39', '2015-05-07 15:03:39');
INSERT INTO tb_membros_telefones VALUES ( '71', '14', '(51) 9128.3912', '', '2015-05-07 14:05:14', '2015-05-07 15:05:14');
INSERT INTO tb_membros_telefones VALUES ( '72', '13', '(51) 9921.2319', '', '2015-08-12 09:45:45', '2015-08-12 10:45:45');
INSERT INTO tb_membros_telefones VALUES ( '73', '8', '(51) 1234.5678', '', '2015-08-25 08:36:06', '2015-08-25 09:36:06');
INSERT INTO tb_membros_telefones VALUES ( '76', '29', '(51) 1234.5678', '', '2015-08-25 10:14:15', '2015-08-25 11:14:15');
INSERT INTO tb_membros_telefones VALUES ( '77', '29', '(51) 8765.4321', '', '2015-08-25 10:14:15', '2015-08-25 11:14:15');
INSERT INTO tb_membros_telefones VALUES ( '80', '37', '(51) 8317.1029', 'Tim', '2016-03-30 13:04:26', '2016-03-30 15:04:26');
INSERT INTO tb_membros_telefones VALUES ( '84', '38', '(51) 9875.4546', 'Vivo', '2016-04-13 14:20:20', '2016-04-13 16:20:20');

#
# Criação da Tabela : tb_obreiros
#

CREATE TABLE `tb_obreiros` (
  `id_obreiro` int(11) NOT NULL AUTO_INCREMENT,
  `id_membro` int(11) NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `vinculo` varchar(250) NOT NULL,
  `dedicacao` varchar(250) NOT NULL,
  `remuneracao` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_obreiro`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_obreiros VALUES ( '2', '8', 'Pastor', 'Chamado', 'Integral', 'Integral', '2015-01-10 16:40:55', '2015-03-18 18:41:14');
INSERT INTO tb_obreiros VALUES ( '4', '11', 'Pastor', 'Chamado', 'Integral', 'Integral', '2015-04-07 17:58:46', '2015-04-07 18:58:46');

#
# Criação da Tabela : tb_paginas_site
#

CREATE TABLE `tb_paginas_site` (
  `id_pagina` int(11) NOT NULL AUTO_INCREMENT,
  `ativo` varchar(250) NOT NULL,
  `titulo` varchar(250) NOT NULL,
  `texto` text NOT NULL,
  `posicao_menu` int(11) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_pagina`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_paginas_site VALUES ( '1', 'sim', 'Quem somos', '', '4', '2015-01-03 22:05:14', '2015-02-06 17:08:58');

#
# Criação da Tabela : tb_paginas_site_imagens
#

CREATE TABLE `tb_paginas_site_imagens` (
  `id_imagem` int(11) NOT NULL AUTO_INCREMENT,
  `id_paroquia` int(11) NOT NULL,
  `id_pagina` int(11) NOT NULL,
  `arquivo` varchar(250) NOT NULL,
  `nome` varchar(250) NOT NULL,
  `link` varchar(250) NOT NULL,
  `posicao` varchar(250) NOT NULL,
  `foto_destaque` int(11) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_imagem`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_paginas_site_imagens VALUES ( '1', '1', '1', '9daffb051f016f0ec2737f60e7a72eeb.jpg', 'Associado ção 1', '1', '11', '0', '2015-02-05 14:31:51', '2015-02-06 17:17:58');
INSERT INTO tb_paginas_site_imagens VALUES ( '2', '1', '1', '880ad8d29c534956eb5d8d92a136e1e5.jpg', 'associado2.jpg', '2', '22', '0', '2015-02-05 14:49:46', '2015-02-06 17:17:34');
INSERT INTO tb_paginas_site_imagens VALUES ( '4', '1', '1', '89e85859fdd05f673b0f69cc85d95a4a.png', 'bgTopo.png', '', '', '0', '2015-02-05 14:54:42', '2015-02-06 00:54:42');
INSERT INTO tb_paginas_site_imagens VALUES ( '9', '1', '3', '9daffb051f016f0ec2737f60e7a72eeb.jpg', 'Teste 1 ção', 'linktesteado.com.br', '1', '0', '2015-02-06 08:03:53', '2015-02-06 18:04:23');
INSERT INTO tb_paginas_site_imagens VALUES ( '10', '1', '3', '880ad8d29c534956eb5d8d92a136e1e5.jpg', 'Teste 2 ção', '22linktesteado.com.br', '2', '0', '2015-02-06 08:03:56', '2015-02-06 18:04:23');
INSERT INTO tb_paginas_site_imagens VALUES ( '11', '1', '4', 'aaaeebe60e0d3a95950965834ec9ea1d.jpg', '', '', '', '0', '2015-02-11 08:19:41', '2015-02-11 18:19:48');

#
# Criação da Tabela : tb_site
#

CREATE TABLE `tb_site` (
  `id_site` int(11) NOT NULL AUTO_INCREMENT,
  `ativo` varchar(250) NOT NULL,
  `aniversariantes` varchar(250) NOT NULL,
  `agenda_paroquia` varchar(250) NOT NULL,
  `id_layout` int(11) NOT NULL,
  `logotipo` varchar(250) NOT NULL,
  `data_cadastro` datetime NOT NULL,
  `atualizacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_site`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ;

#
# Dados a serem incluídos na tabela
#

INSERT INTO tb_site VALUES ( '2', 'sim', 'nao', 'nao', '2', 'jquery.jpg', '2015-01-03 22:29:41', '2017-11-21 01:35:07');
INSERT INTO tb_site VALUES ( '3', 'sim', 'nao', 'nao', '2', 'jquery.jpg.php5', '2017-11-21 01:31:05', '2017-11-21 01:31:05');
INSERT INTO tb_site VALUES ( '4', 'sim', 'nao', 'nao', '0', 'jqueryphp.php5.jpg', '2017-11-21 01:35:50', '2017-11-21 01:35:50');
