Z2SGcw3E

1-- phpMyAdmin SQL Dump
2-- version 4.8.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Tempo de geração: 11/04/2019 às 01:25
7-- Versão do servidor: 5.7.24
8-- Versão do PHP: 7.2.14
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Banco de dados: `vocesolidario`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Estrutura para tabela `administrador_instituicao`
29--
30
31DROP TABLE IF EXISTS `administrador_instituicao`;
32CREATE TABLE IF NOT EXISTS `administrador_instituicao` (
33  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
34  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
35  `cargo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
36  `telefone_pessoal` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
37  `cpf` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
38  `instituicao_id` int(10) UNSIGNED NOT NULL,
39  `created_at` timestamp NULL DEFAULT NULL,
40  `updated_at` timestamp NULL DEFAULT NULL,
41  PRIMARY KEY (`id`),
42  KEY `administrador_instituicao_instituicao_id_foreign` (`instituicao_id`)
43) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
44
45--
46-- Despejando dados para a tabela `administrador_instituicao`
47--
48
49INSERT INTO `administrador_instituicao` (`id`, `nome`, `cargo`, `telefone_pessoal`, `cpf`, `instituicao_id`, `created_at`, `updated_at`) VALUES
50(1, 'Hernani Rodrigues Franco Sobrinho', 'illo', '(73) 94330-4882', '003.395.627-81', 1, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
51(2, 'Sr. Ziraldo Fonseca Sandoval Sobrinho', 'et', '(83) 4722-3428', '732.517.258-31', 2, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
52(3, 'Franco Rico Neto', 'vel', '(22) 4610-3580', '053.557.656-02', 3, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
53(4, 'Everton Thales Faro Sobrinho', 'asperiores', '(53) 97873-4834', '060.052.956-83', 4, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
54(5, 'Leandro Ziraldo Cortês', 'accusantium', '(24) 93098-0454', '745.349.504-03', 5, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
55(6, 'Dr. Adriana Sabrina Marin Neto', 'rerum', '(83) 3901-4783', '382.264.913-98', 6, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
56(7, 'Sra. Alexa Santacruz Feliciano Jr.', 'veritatis', '(71) 4878-8415', '484.209.209-24', 7, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
57(8, 'Dr. Luis Cruz Jr.', 'rem', '(63) 4758-2763', '128.642.142-02', 8, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
58(9, 'Carolina Camila Teles Filho', 'deleniti', '(84) 95222-5579', '247.174.828-75', 9, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
59(10, 'Sr. Henrique Leon Dominato Filho', 'deleniti', '(94) 92539-0227', '857.030.887-63', 10, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
60(11, 'Ariadna Aranda Gonçalves Jr.', 'qui', '(34) 3634-2931', '556.685.657-85', 11, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
61(12, 'Dr. Kevin de Aguiar Salgado Filho', 'vel', '(98) 97673-2054', '053.765.260-46', 12, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
62(13, 'Sr. Santiago Perez Neto', 'et', '(21) 99142-6422', '516.870.682-75', 13, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
63(14, 'Dr. Carolina Fonseca', 'quis', '(14) 93781-9775', '820.084.473-08', 14, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
64(15, 'Sr. Everton Estrada Jr.', 'sed', '(73) 92369-4757', '410.390.023-74', 15, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
65(16, 'Everton Queirós Neto', 'id', '(11) 99500-7757', '457.477.462-27', 16, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
66(17, 'Ivan Aguiar Sobrinho', 'ea', '(99) 2428-9125', '453.599.073-55', 17, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
67(18, 'Samuel Mascarenhas', 'ipsa', '(64) 95338-0862', '888.676.371-93', 18, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
68(19, 'Miranda Valência', 'ut', '(41) 4321-8292', '994.279.227-96', 19, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
69(20, 'Bruno Henrique Aguiar Filho', 'ratione', '(42) 94563-7809', '704.437.746-76', 20, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
70(21, 'Carolina Suzana Flores Filho', 'nihil', '(84) 92940-9439', '271.825.414-91', 21, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
71(22, 'Sr. Martinho Feliciano Leon Filho', 'ut', '(11) 98222-0229', '950.012.793-80', 22, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
72(23, 'Ketlin Neves Pereira Jr.', 'eaque', '(22) 92680-4161', '419.248.417-03', 23, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
73(24, 'Constância Fátima Escobar Sobrinho', 'nemo', '(54) 94060-8274', '435.823.613-81', 24, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
74(25, 'Sra. Irene Ornela Ramos Neto', 'est', '(94) 99173-4766', '467.011.605-30', 25, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
75(26, 'Isadora Irene Grego', 'facere', '(74) 4283-4319', '743.230.758-04', 26, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
76(27, 'Dr. Pablo Simão Cordeiro', 'voluptatem', '(38) 3203-6851', '422.712.971-09', 27, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
77(28, 'Mariana Batista Jr.', 'qui', '(32) 93641-3185', '461.670.067-25', 28, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
78(29, 'Christopher Balestero', 'ut', '(18) 4594-3105', '008.135.205-09', 29, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
79(30, 'Fabiana Queirós', 'nihil', '(66) 3685-6227', '800.744.650-82', 30, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
80(31, 'Srta. Renata Ávila', 'ipsa', '(28) 95529-0777', '435.069.461-70', 31, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
81(32, 'Clara Bianca Vila Neto', 'ut', '(81) 90527-1711', '524.414.990-33', 32, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
82(33, 'Srta. Pâmela Pedrosa Sobrinho', 'tempore', '(74) 95382-9481', '309.327.963-11', 33, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
83(34, 'Vicente Jorge Medina', 'est', '(37) 98691-2421', '455.668.753-51', 34, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
84(35, 'Sr. Emílio Zamana Uchoa', 'dicta', '(22) 4055-3544', '782.595.114-01', 35, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
85(36, 'Tessália Zambrano Neto', 'labore', '(28) 4410-1123', '203.169.898-27', 36, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
86(37, 'Sra. Júlia Cortês', 'enim', '(28) 95084-5369', '350.959.865-23', 37, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
87(38, 'Sr. Carlos Christian Valentin Neto', 'rerum', '(65) 99319-5365', '644.456.285-65', 38, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
88(39, 'Suzana Matias Prado', 'consequatur', '(19) 3180-9064', '489.175.511-30', 39, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
89(40, 'Christian Carrara Zamana', 'in', '(33) 93450-3310', '332.590.230-89', 40, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
90(41, 'Sra. Mel Rezende Ferreira', 'dolor', '(64) 4003-2433', '882.394.445-71', 41, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
91(42, 'Josefina Fernandes', 'enim', '(32) 96032-1725', '810.529.141-01', 42, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
92(43, 'Dr. José Matos', 'fugiat', '(47) 4385-6374', '535.867.703-83', 43, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
93(44, 'Thalissa Malena Zaragoça Neto', 'incidunt', '(63) 96599-8840', '482.632.792-75', 44, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
94(45, 'Jerônimo Soares', 'praesentium', '(66) 93840-3738', '118.048.024-41', 45, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
95(46, 'Thalissa Brito', 'dignissimos', '(13) 93785-6358', '044.978.019-85', 46, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
96(47, 'Sr. Benjamin Fontes Godói Sobrinho', 'rem', '(54) 4253-0993', '467.615.522-06', 47, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
97(48, 'Dr. Mariana Dias Franco', 'earum', '(68) 91166-3728', '226.610.864-63', 48, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
98(49, 'Samuel Matias Abreu Jr.', 'inventore', '(61) 97775-9721', '652.020.395-57', 49, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
99(50, 'Sr. Pablo Roque Vega', 'sint', '(54) 96651-4199', '682.526.689-68', 50, '2019-04-05 05:05:35', '2019-04-05 05:05:35');
100
101-- --------------------------------------------------------
102
103--
104-- Estrutura para tabela `area_atuacao`
105--
106
107DROP TABLE IF EXISTS `area_atuacao`;
108CREATE TABLE IF NOT EXISTS `area_atuacao` (
109  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
110  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
111  `created_at` timestamp NULL DEFAULT NULL,
112  `updated_at` timestamp NULL DEFAULT NULL,
113  PRIMARY KEY (`id`)
114) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
115
116--
117-- Despejando dados para a tabela `area_atuacao`
118--
119
120INSERT INTO `area_atuacao` (`id`, `nome`, `created_at`, `updated_at`) VALUES
121(1, 'Assistencia Social', '2019-04-05 05:05:33', NULL),
122(2, 'Cultura', '2019-04-05 05:05:33', NULL),
123(3, 'Saúde', '2019-04-05 05:05:33', NULL),
124(4, 'Meio Ambiente', '2019-04-05 05:05:33', NULL),
125(5, 'Esporte e Lazer', '2019-04-05 05:05:33', NULL),
126(6, 'Educação', '2019-04-05 05:05:33', NULL);
127
128-- --------------------------------------------------------
129
130--
131-- Estrutura para tabela `cache`
132--
133
134DROP TABLE IF EXISTS `cache`;
135CREATE TABLE IF NOT EXISTS `cache` (
136  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
137  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
138  `expiration` int(11) NOT NULL,
139  UNIQUE KEY `cache_key_unique` (`key`)
140) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
141
142-- --------------------------------------------------------
143
144--
145-- Estrutura para tabela `categorias`
146--
147
148DROP TABLE IF EXISTS `categorias`;
149CREATE TABLE IF NOT EXISTS `categorias` (
150  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
151  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
152  `created_at` timestamp NULL DEFAULT NULL,
153  `updated_at` timestamp NULL DEFAULT NULL,
154  PRIMARY KEY (`id`)
155) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
156
157--
158-- Despejando dados para a tabela `categorias`
159--
160
161INSERT INTO `categorias` (`id`, `nome`, `created_at`, `updated_at`) VALUES
162(1, 'Alimentos e Bebidas', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
163(2, 'Armarinho, Artesanato e Pintura', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
164(3, 'Artigos de Bebê', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
165(4, 'Artigos Descartáveis', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
166(5, 'Automóveis e Veículos', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
167(6, 'Bolsas de Estudo e Recursos Financeiros', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
168(7, 'Brinquedos', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
169(8, 'Cama, mesa e banho', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
170(9, 'Eletrodomésticos', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
171(10, 'Eletrônicos', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
172(11, 'Equipamentos, Máquinas e Ferramentas', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
173(12, 'Esporte e Lazer', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
174(13, 'Higiene e Perfumaria', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
175(14, 'Imóveis', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
176(15, 'Informática e Celular', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
177(16, 'Instrumentos Músicais e Acessórios', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
178(17, 'Livros, CD e DVD', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
179(18, 'Material de Construção', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
180(19, 'Material de Limpeza', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
181(20, 'Móveis e Decoração', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
182(21, 'Papelaria e Material Escolar', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
183(22, 'Saúde', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
184(23, 'Uso animal', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
185(24, 'Utilidade Doméstica', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
186(25, 'Vestuário, Calçado e Acessórios', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
187(26, 'Outro', '2019-04-05 05:05:33', '2019-04-05 05:05:33');
188
189-- --------------------------------------------------------
190
191--
192-- Estrutura para tabela `contatos`
193--
194
195DROP TABLE IF EXISTS `contatos`;
196CREATE TABLE IF NOT EXISTS `contatos` (
197  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
198  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
199  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
200  `telefone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
201  `assunto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
202  `mensagem` text COLLATE utf8mb4_unicode_ci NOT NULL,
203  `respondido` tinyint(1) NOT NULL DEFAULT '0',
204  `created_at` timestamp NULL DEFAULT NULL,
205  `updated_at` timestamp NULL DEFAULT NULL,
206  PRIMARY KEY (`id`)
207) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
208
209-- --------------------------------------------------------
210
211--
212-- Estrutura para tabela `doacoes`
213--
214
215DROP TABLE IF EXISTS `doacoes`;
216CREATE TABLE IF NOT EXISTS `doacoes` (
217  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
218  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
219  `descricao` text COLLATE utf8mb4_unicode_ci NOT NULL,
220  `quantidade` int(11) NOT NULL,
221  `estado` enum('Aberto','Fechado') COLLATE utf8mb4_unicode_ci NOT NULL,
222  `categoria_id` int(10) UNSIGNED NOT NULL,
223  `defeito` enum('sim','nao') COLLATE utf8mb4_unicode_ci NOT NULL,
224  `descricao_defeito` text COLLATE utf8mb4_unicode_ci,
225  `entrega_objeto` enum('sim','nao') COLLATE utf8mb4_unicode_ci NOT NULL,
226  `posso_entregar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
227  `posso_enviar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
228  `nome_retirada` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
229  `telefone_retirada` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
230  `imagem` json DEFAULT NULL,
231  `doador_id` int(10) UNSIGNED NOT NULL,
232  `created_at` timestamp NULL DEFAULT NULL,
233  `updated_at` timestamp NULL DEFAULT NULL,
234  PRIMARY KEY (`id`),
235  KEY `doacoes_categoria_id_foreign` (`categoria_id`),
236  KEY `doacoes_doador_id_foreign` (`doador_id`)
237) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
238
239--
240-- Despejando dados para a tabela `doacoes`
241--
242
243INSERT INTO `doacoes` (`id`, `nome`, `descricao`, `quantidade`, `estado`, `categoria_id`, `defeito`, `descricao_defeito`, `entrega_objeto`, `posso_entregar`, `posso_enviar`, `nome_retirada`, `telefone_retirada`, `imagem`, `doador_id`, `created_at`, `updated_at`) VALUES
244(1, 'Quaerat iure.', 'Dolore ipsa laborum cumque.', 8, 'Aberto', 1, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 4, '2018-09-15 08:29:12', '2019-04-05 05:05:38'),
245(2, 'Incidunt et porro.', 'Explicabo molestiae suscipit nesciunt et ut fugiat minus autem et vero ut.', 9, 'Aberto', 7, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 3, '2018-11-18 17:09:34', '2019-04-05 05:05:38'),
246(3, 'Atque nisi qui expedita debitis.', 'Totam molestias sunt incidunt doloribus eum.', 3, 'Aberto', 5, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 5, '2018-02-05 09:42:47', '2019-04-05 05:05:38'),
247(5, 'Sed quasi ipsum et aut.', 'Dolor officia nemo impedit.', 8, 'Aberto', 7, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2018-07-09 18:42:16', '2019-04-05 05:05:38'),
248(8, 'Odit consequatur qui cumque laboriosam maiores similique.', 'Est illum magnam aut et.', 2, 'Aberto', 2, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2019-02-27 16:44:21', '2019-04-05 05:05:38'),
249(10, 'Totam earum perferendis.', 'Nemo veniam assumenda qui nesciunt sit sint sapiente.', 3, 'Aberto', 4, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2019-03-28 03:06:45', '2019-04-05 05:05:38'),
250(11, 'Dolores fuga ratione.', 'Dolor qui nobis accusamus non iusto quo mollitia.', 5, 'Aberto', 3, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 3, '2018-07-22 09:44:40', '2019-04-05 05:05:38'),
251(12, 'Cupiditate eius cumque.', 'Expedita quisquam consequatur aut laudantium.', 3, 'Aberto', 4, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 3, '2018-01-08 23:03:12', '2019-04-05 05:05:38'),
252(13, 'Qui voluptas error libero.', 'Rerum veniam reprehenderit architecto sit facilis sint accusantium.', 7, 'Aberto', 7, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2019-02-19 17:14:45', '2019-04-05 05:05:38'),
253(14, 'Fuga eaque sint alias iste tempore.', 'Est vel sit provident mollitia eveniet.', 3, 'Aberto', 1, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 5, '2018-08-29 20:12:16', '2019-04-05 05:05:39'),
254(15, 'Numquam ratione dolores.', 'Aspernatur magnam est ea rem dolor quae.', 6, 'Aberto', 3, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 4, '2019-02-15 13:11:55', '2019-04-05 05:05:39'),
255(16, 'Sapiente vitae dignissimos modi.', 'Voluptas molestiae est facilis ad labore.', 6, 'Aberto', 1, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 5, '2019-02-09 22:57:20', '2019-04-05 05:05:39'),
256(17, 'Voluptatem accusantium ab est dicta.', 'Qui autem eligendi voluptas rem.', 6, 'Aberto', 9, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2018-04-13 17:26:38', '2019-04-05 05:05:39'),
257(18, 'Ut quam cupiditate.', 'Possimus voluptatem vitae quod.', 6, 'Aberto', 8, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 3, '2018-02-04 10:57:37', '2019-04-05 05:05:39'),
258(19, 'Culpa est autem.', 'Sit quos hic dolore.', 9, 'Aberto', 6, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 5, '2018-11-15 10:07:30', '2019-04-05 05:05:39'),
259(20, 'Ex inventore unde.', 'Sed praesentium autem ad inventore dolor sunt.', 7, 'Aberto', 3, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 5, '2018-09-24 07:32:15', '2019-04-05 05:05:39'),
260(21, 'Illo maxime ut modi.', 'Veritatis atque voluptate harum perspiciatis.', 8, 'Aberto', 8, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 3, '2018-04-19 21:06:25', '2019-04-05 05:05:39'),
261(22, 'Est est et voluptates.', 'Incidunt voluptatem ducimus in est eos eaque perspiciatis.', 3, 'Aberto', 2, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2019-02-23 08:14:40', '2019-04-05 05:05:39'),
262(23, 'Aut ipsum recusandae et et aspernatur.', 'Eaque voluptatem aut minima non.', 9, 'Aberto', 3, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2018-08-10 18:40:14', '2019-04-05 05:05:39'),
263(25, 'Ducimus sunt error rem dignissimos fuga sit.', 'Eveniet aspernatur reiciendis consequatur.', 3, 'Aberto', 1, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2018-01-01 05:33:42', '2019-04-05 05:05:39'),
264(26, 'Totam culpa commodi.', 'Aliquid quia officiis.', 4, 'Aberto', 6, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 4, '2019-03-01 08:29:47', '2019-04-05 05:05:39'),
265(27, 'Repellendus officiis ut voluptatem optio.', 'Corporis sint non autem corrupti blanditiis ut.', 1, 'Aberto', 6, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 3, '2018-01-30 07:13:51', '2019-04-05 05:05:39'),
266(28, 'Perspiciatis quaerat illum at nihil.', 'Asperiores quia architecto sunt aut.', 2, 'Aberto', 2, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 2, '2018-10-21 19:50:09', '2019-04-05 05:05:39'),
267(29, 'Eum et quia deleniti eligendi et sequi.', 'Voluptatem distinctio est sed qui.', 5, 'Aberto', 4, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 3, '2019-03-23 02:21:19', '2019-04-05 05:05:39'),
268(30, 'Voluptatibus facere qui excepturi.', 'Tenetur reprehenderit nihil quo fugiat sint est enim occaecati.', 1, 'Aberto', 2, 'nao', NULL, 'sim', '1', '1', NULL, NULL, NULL, 4, '2018-01-23 04:01:21', '2019-04-05 05:05:39');
269
270-- --------------------------------------------------------
271
272--
273-- Estrutura para tabela `doacoes_instituicoes`
274--
275
276DROP TABLE IF EXISTS `doacoes_instituicoes`;
277CREATE TABLE IF NOT EXISTS `doacoes_instituicoes` (
278  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
279  `doacao_id` int(10) UNSIGNED NOT NULL,
280  `instituicao_id` int(10) UNSIGNED NOT NULL,
281  PRIMARY KEY (`id`),
282  KEY `doacoes_instituicoes_doacao_id_foreign` (`doacao_id`),
283  KEY `doacoes_instituicoes_instituicao_id_foreign` (`instituicao_id`)
284) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
285
286--
287-- Despejando dados para a tabela `doacoes_instituicoes`
288--
289
290INSERT INTO `doacoes_instituicoes` (`id`, `doacao_id`, `instituicao_id`) VALUES
291(12, 1, 9),
292(13, 1, 39),
293(14, 1, 4),
294(15, 5, 9);
295
296-- --------------------------------------------------------
297
298--
299-- Estrutura para tabela `doadores`
300--
301
302DROP TABLE IF EXISTS `doadores`;
303CREATE TABLE IF NOT EXISTS `doadores` (
304  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
305  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
306  `cpf` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
307  `sexo` enum('F','M') COLLATE utf8mb4_unicode_ci NOT NULL,
308  `data_nascimento` date NOT NULL,
309  `telefone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
310  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
311  `created_at` timestamp NULL DEFAULT NULL,
312  `updated_at` timestamp NULL DEFAULT NULL,
313  PRIMARY KEY (`id`)
314) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
315
316--
317-- Despejando dados para a tabela `doadores`
318--
319
320INSERT INTO `doadores` (`id`, `nome`, `cpf`, `sexo`, `data_nascimento`, `telefone`, `foto`, `created_at`, `updated_at`) VALUES
321(1, 'Sr. Demian Jorge Ávila Filho', '783.667.571-88', 'F', '1982-01-07', '(96) 3930-8556', 'https://lorempixel.com/640/480/?57655', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
322(2, 'Dr. Simon Gustavo Vieira', '678.247.277-50', 'F', '1991-07-31', '(75) 3421-3118', 'https://lorempixel.com/640/480/?75183', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
323(3, 'Thalissa Alexa Delvalle', '820.507.457-70', 'M', '1976-10-24', '(82) 2686-6302', 'https://lorempixel.com/640/480/?16183', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
324(4, 'Adriana Malena Benites', '378.509.664-06', 'M', '2016-05-22', '(71) 92250-9740', 'https://lorempixel.com/640/480/?20270', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
325(5, 'Dr. Luciana Sanches Verdugo', '360.950.153-75', 'F', '1992-01-01', '(64) 96286-6901', 'https://lorempixel.com/640/480/?21202', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
326(6, 'Joaquin Teobaldo Velasques Filho', '097.242.239-06', 'M', '2001-01-23', '(61) 4283-8094', 'https://lorempixel.com/640/480/?40045', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
327(7, 'Alessandra Julieta Zambrano Sobrinho', '396.848.160-73', 'F', '1990-07-20', '(32) 2287-8791', 'https://lorempixel.com/640/480/?91406', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
328(8, 'Diego Matos Chaves', '192.645.934-20', 'M', '1975-05-07', '(71) 2999-1735', 'https://lorempixel.com/640/480/?60477', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
329(9, 'Ivan Roque Rios Sobrinho', '853.798.264-40', 'F', '1989-10-05', '(81) 96675-5696', 'https://lorempixel.com/640/480/?98438', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
330(10, 'Srta. Antonieta Laura Romero', '759.027.756-80', 'M', '2001-02-07', '(55) 98478-9576', 'https://lorempixel.com/640/480/?55921', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
331(11, 'Alonso Faro Gil Neto', '379.936.658-09', 'F', '2017-02-17', '(44) 3527-7077', 'https://lorempixel.com/640/480/?31767', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
332(12, 'Srta. Salomé Valentin', '542.187.553-96', 'F', '2000-12-17', '(16) 98534-1803', 'https://lorempixel.com/640/480/?26160', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
333(13, 'Gian Everton Bittencourt Jr.', '992.947.244-41', 'F', '2001-05-09', '(24) 91793-8116', 'https://lorempixel.com/640/480/?70855', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
334(14, 'Srta. Camila Amanda Perez Jr.', '455.880.663-91', 'F', '2012-01-02', '(22) 3035-6617', 'https://lorempixel.com/640/480/?57933', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
335(15, 'Mia Pedrosa Jr.', '837.243.412-37', 'M', '1977-04-09', '(28) 99106-6554', 'https://lorempixel.com/640/480/?81140', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
336(16, 'Dr. Natália Prado Sobrinho', '140.979.433-40', 'M', '2005-03-10', '(64) 91208-7903', 'https://lorempixel.com/640/480/?40246', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
337(17, 'Luzia D\'ávila', '182.736.680-02', 'M', '1989-02-20', '(65) 93378-5685', 'https://lorempixel.com/640/480/?82272', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
338(18, 'Srta. Isadora Serra', '068.136.905-15', 'M', '1986-06-26', '(67) 99753-7956', 'https://lorempixel.com/640/480/?70271', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
339(19, 'Catarina Cruz', '580.248.586-81', 'F', '1987-01-15', '(73) 90360-4401', 'https://lorempixel.com/640/480/?94002', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
340(20, 'Mateus de Aguiar Lutero', '708.470.202-40', 'M', '2007-06-11', '(21) 96787-6798', 'https://lorempixel.com/640/480/?10643', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
341(21, 'Srta. Michele Carla Marés Neto', '777.059.458-86', 'M', '1999-02-03', '(31) 4580-5784', 'https://lorempixel.com/640/480/?80011', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
342(22, 'Leonardo Lira', '147.059.846-92', 'F', '1991-12-13', '(71) 4017-6127', 'https://lorempixel.com/640/480/?47584', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
343(23, 'Sr. Maximiano Hernani Montenegro Jr.', '204.331.304-58', 'M', '1993-06-23', '(27) 3720-1303', 'https://lorempixel.com/640/480/?77059', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
344(24, 'Sr. Inácio da Rosa Neto', '317.723.304-77', 'F', '1982-04-10', '(63) 3584-6899', 'https://lorempixel.com/640/480/?85826', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
345(25, 'David Teobaldo Assunção', '493.846.217-65', 'F', '1971-01-05', '(84) 3163-0394', 'https://lorempixel.com/640/480/?69599', '2019-04-05 05:05:33', '2019-04-05 05:05:33');
346
347-- --------------------------------------------------------
348
349--
350-- Estrutura para tabela `instituicoes`
351--
352
353DROP TABLE IF EXISTS `instituicoes`;
354CREATE TABLE IF NOT EXISTS `instituicoes` (
355  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
356  `nome` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
357  `sigla` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
358  `site` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
359  `fundacao` date NOT NULL,
360  `cnpj` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
361  `telefone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
362  `pessoas_atendidas_id` int(10) UNSIGNED NOT NULL,
363  `quantidade_projetos_id` int(10) UNSIGNED NOT NULL,
364  `area_atuacao_id` int(10) UNSIGNED NOT NULL,
365  `publico_alvo_id` int(10) UNSIGNED NOT NULL,
366  `proposta` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
367  `atividades` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
368  `missao` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
369  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
370  `created_at` timestamp NULL DEFAULT NULL,
371  `updated_at` timestamp NULL DEFAULT NULL,
372  PRIMARY KEY (`id`),
373  KEY `instituicoes_pessoas_atendidas_id_foreign` (`pessoas_atendidas_id`),
374  KEY `instituicoes_quantidade_projetos_id_foreign` (`quantidade_projetos_id`),
375  KEY `instituicoes_area_atuacao_id_foreign` (`area_atuacao_id`),
376  KEY `instituicoes_publico_alvo_id_foreign` (`publico_alvo_id`)
377) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
378
379--
380-- Despejando dados para a tabela `instituicoes`
381--
382
383INSERT INTO `instituicoes` (`id`, `nome`, `sigla`, `site`, `fundacao`, `cnpj`, `telefone`, `pessoas_atendidas_id`, `quantidade_projetos_id`, `area_atuacao_id`, `publico_alvo_id`, `proposta`, `atividades`, `missao`, `foto`, `created_at`, `updated_at`) VALUES
384(1, 'Soto e Romero', 'e Associados', 'mascarenhas.com.br', '1974-12-28', '76.639.711/0001-72', '(91) 92349-4804', 1, 2, 1, 10, 'Et temporibus porro explicabo incidunt aut voluptas.', 'Perferendis unde consequatur delectus alias repellat eius ut.', 'Velit odio aut est eum et quibusdam id. Harum non qui recusandae quasi ab.', 'https://lorempixel.com/640/480/?32493', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
385(2, 'Matias e Associados', 'e Associados', 'mendonca.org', '1987-02-26', '84.283.890/0001-86', '(99) 3891-5873', 2, 4, 2, 7, 'Vel nostrum sit omnis voluptate aliquam. Dicta rerum dolor inventore autem consequatur tenetur illum.', 'Iste voluptatem voluptates quia blanditiis sit tenetur reprehenderit quidem. Aliquam consequuntur eos quidem est in laborum sed ad.', 'Nihil aliquid tenetur labore voluptatem aliquid voluptatem. Dolor nihil recusandae perspiciatis placeat cupiditate quidem consequatur vel.', 'https://lorempixel.com/640/480/?60106', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
386(3, 'Vieira e Associados', 'Ltda.', 'vila.org', '1993-11-20', '31.930.465/0001-75', '(37) 2560-3811', 3, 1, 3, 3, 'Ullam ullam maiores vel qui sapiente.', 'Sunt consequatur reprehenderit quo quo quam molestiae aliquam. Maxime illum quasi et nulla.', 'Itaque optio rerum iusto omnis illo est rerum officiis.', 'https://lorempixel.com/640/480/?54667', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
387(4, 'Benites-Zamana', 'e Filhos', 'vila.org', '2018-03-08', '37.849.045/0001-45', '(24) 98279-9505', 1, 2, 2, 8, 'Omnis non facere eveniet odit id. Impedit consequatur qui animi quia.', 'Harum numquam cum velit illum porro voluptatem pariatur rerum.', 'Ut et quia repellendus accusamus. Nihil temporibus excepturi omnis.', 'https://lorempixel.com/640/480/?22128', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
388(5, 'da Silva Ltda.', 'e Associados', 'dias.br', '2017-11-12', '41.061.809/0001-00', '(98) 92221-9225', 3, 2, 2, 5, 'Saepe consectetur qui quis doloribus est. Non libero beatae corrupti tenetur saepe officiis laborum aliquam.', 'Labore ipsam nulla ipsa eius consectetur. Adipisci distinctio explicabo aliquid quae perferendis beatae hic facere.', 'Officia molestiae veritatis voluptas alias quasi minima dolorem.', 'https://lorempixel.com/640/480/?58750', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
389(6, 'Duarte Comercial Ltda.', 'e Associados', 'feliciano.com', '1989-10-14', '69.576.278/0001-08', '(14) 4185-9399', 3, 1, 3, 4, 'Eum dolores similique ratione cupiditate non maiores.', 'Eum quo repellat voluptatibus eligendi eaque quo vitae. Quidem nostrum aspernatur consequuntur.', 'Reprehenderit qui ipsum quas non repellendus. Aut corrupti qui accusamus voluptates beatae et.', 'https://lorempixel.com/640/480/?37506', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
390(7, 'Galvão e Soto Ltda.', 'Ltda.', 'batista.br', '2011-11-14', '78.671.690/0001-06', '(74) 4170-3983', 2, 3, 3, 1, 'Explicabo nulla adipisci amet et ducimus. Nihil sint aut ut est dicta.', 'Quia occaecati ullam rerum enim voluptates aut natus. Libero odio sit ut labore et.', 'Quas blanditiis ut iste doloribus. Maxime qui nihil saepe architecto quisquam.', 'https://lorempixel.com/640/480/?62385', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
391(8, 'Perez-Lozano', 'S.A.', 'correia.net', '1981-06-26', '79.274.334/0001-03', '(12) 91352-4167', 2, 2, 4, 1, 'Aperiam illum quo voluptatibus iure quo ipsam. Quaerat et inventore beatae voluptatibus aliquam.', 'Ex qui itaque saepe distinctio consequuntur iure voluptatem. Debitis ex ex illum quas alias libero.', 'Debitis culpa qui illum similique cum provident. Accusantium occaecati aliquam nemo.', 'https://lorempixel.com/640/480/?92326', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
392(9, 'Cordeiro-Bittencourt', 'e Filhos', 'delvalle.com.br', '2000-03-31', '33.312.599/0001-58', '(63) 2535-0482', 1, 3, 4, 4, 'Eos sequi dolorem rerum facere velit hic.', 'Eveniet nisi ea voluptas dolor magni. Sapiente ut libero repudiandae dolore assumenda voluptatum enim.', 'Molestias modi voluptate est hic corporis optio quaerat. Quam voluptates quia sint sed.', 'https://lorempixel.com/640/480/?30811', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
393(10, 'das Neves e Filhos', 'e Associados', 'assuncao.com.br', '2011-07-24', '98.976.910/0001-09', '(42) 2368-8324', 2, 4, 2, 3, 'Recusandae ratione laboriosam dolores sint itaque ut at enim. Quod reprehenderit et est molestias quia voluptas aliquam culpa.', 'Quis placeat est eaque voluptas consequatur voluptatum et. Qui labore magnam quo laboriosam impedit esse beatae.', 'Cumque voluptas est sit sint.', 'https://lorempixel.com/640/480/?71544', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
394(11, 'Faro S.A.', 'e Associados', 'rocha.br', '1995-02-06', '45.908.083/0001-50', '(32) 97112-3311', 1, 1, 4, 8, 'Distinctio voluptatem velit sit et quo nulla qui assumenda. Sit repellendus voluptas eos non consectetur recusandae.', 'Et dicta sunt magni explicabo sapiente explicabo reiciendis blanditiis. Veritatis itaque accusamus architecto.', 'Eius quia et aut. Laboriosam nostrum quo quo repellat quia recusandae officia sunt.', 'https://lorempixel.com/640/480/?84714', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
395(12, 'Pacheco Comercial Ltda.', 'S.A.', 'fernandes.com', '1972-12-31', '24.274.044/0001-78', '(69) 4402-4556', 1, 3, 1, 5, 'Eum consequuntur dolorem dolores.', 'Quis voluptatem praesentium aut.', 'Aut et asperiores eum facilis voluptas recusandae fuga.', 'https://lorempixel.com/640/480/?35557', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
396(13, 'Rangel e Teles', 'Ltda.', 'fontes.com', '2004-09-16', '87.259.381/0001-06', '(37) 94740-7766', 3, 4, 4, 6, 'Rerum rerum aut dolore dolor beatae ut at.', 'Omnis odio natus totam ad itaque sed. Impedit maiores minus exercitationem quae.', 'Odit voluptatem voluptatibus ut facilis dolores inventore dolor.', 'https://lorempixel.com/640/480/?67347', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
397(14, 'Grego Comercial Ltda.', 'e Associados', 'dias.br', '1974-11-24', '68.275.394/0001-24', '(79) 2538-1605', 3, 2, 1, 3, 'Non inventore ab dolor provident alias. Asperiores minus pariatur saepe similique temporibus facilis.', 'Qui error et dolorem porro.', 'Ea qui sunt id qui qui numquam architecto. Quibusdam magni vel unde quae quibusdam aut voluptatem.', 'https://lorempixel.com/640/480/?63653', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
398(15, 'da Silva Ltda.', 'Ltda.', 'neves.org', '1989-06-04', '61.492.192/0001-95', '(51) 98855-8185', 3, 1, 3, 7, 'Dolores libero error reiciendis sapiente incidunt.', 'Placeat velit quia incidunt aut omnis ipsum. Molestiae exercitationem libero vel consequatur error iure.', 'Quas in dolore eum pariatur doloribus illum. Voluptatem animi nulla quis delectus.', 'https://lorempixel.com/640/480/?73993', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
399(16, 'Fonseca e Saraiva', 'e Associados', 'santacruz.com', '1973-10-19', '68.927.355/0001-64', '(87) 3058-8305', 2, 4, 2, 4, 'Harum sit ea ullam dolore quia temporibus ex eum.', 'Omnis illo qui quibusdam iusto dolorum id.', 'Excepturi sunt accusantium blanditiis eaque aut. Dignissimos a et blanditiis error et sed rerum.', 'https://lorempixel.com/640/480/?33353', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
400(17, 'Molina e Fonseca', 'S.A.', 'faria.com', '1987-12-02', '87.843.643/0001-85', '(24) 93028-2339', 4, 3, 1, 6, 'Recusandae impedit deleniti ut eligendi tempora atque quas.', 'Unde sequi occaecati rerum veniam non.', 'Neque labore repudiandae rem et.', 'https://lorempixel.com/640/480/?33207', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
401(18, 'Esteves e Pontes e Filhos', 'S.A.', 'soto.net', '1997-06-01', '59.043.314/0001-14', '(83) 93804-5781', 1, 3, 4, 7, 'Nulla rerum dolorem omnis.', 'Numquam est aut ex sint vel.', 'Non nesciunt expedita quia soluta cumque quis. Ut sit quos fuga at.', 'https://lorempixel.com/640/480/?23184', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
402(19, 'Delvalle-Mendes', 'Ltda.', 'ferreira.com', '1973-07-11', '60.794.845/0001-28', '(45) 92928-6715', 4, 2, 2, 9, 'Ex dolorem sit ratione deleniti mollitia. Enim commodi numquam exercitationem vel voluptatem qui.', 'Ut modi ea totam voluptatem numquam nam. Minima id ex tempore et nemo maxime inventore.', 'Magni incidunt doloremque ipsa fuga similique.', 'https://lorempixel.com/640/480/?24165', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
403(20, 'Roque-Velasques', 'S.A.', 'valentin.net', '1983-06-07', '42.940.359/0001-99', '(24) 2089-2764', 4, 3, 3, 8, 'Et qui mollitia officiis dolor recusandae saepe. Itaque voluptatum sequi ut molestiae ut.', 'Aspernatur enim sit aperiam. Molestias porro quaerat quae asperiores adipisci aliquid.', 'Ea voluptas ad dolorum et dolore omnis enim.', 'https://lorempixel.com/640/480/?44042', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
404(21, 'Uchoa Comercial Ltda.', 'e Associados', 'matos.org', '1980-04-22', '47.703.073/0001-03', '(35) 94799-2963', 2, 1, 4, 7, 'Ea autem officia qui quia. Ducimus veniam dolores at ea et consequatur necessitatibus.', 'Qui ab eaque vero velit et ut quaerat. Facilis voluptas ut qui doloribus at.', 'Et officia ut distinctio.', 'https://lorempixel.com/640/480/?32338', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
405(22, 'Vega Comercial Ltda.', 'S.A.', 'pena.com', '1989-08-02', '68.143.632/0001-48', '(62) 3020-8330', 4, 4, 2, 4, 'Quis quos illum in id molestiae.', 'Aliquam excepturi totam quos quis totam vel nihil. Vitae occaecati nulla voluptas accusantium.', 'Quos deleniti consequatur voluptas aut distinctio et quibusdam. Odio est accusantium quis nisi.', 'https://lorempixel.com/640/480/?30099', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
406(23, 'Carrara-Grego', 'e Filhos', 'mares.com.br', '1987-09-23', '66.587.905/0001-18', '(38) 2808-3167', 4, 1, 4, 6, 'Fuga sint blanditiis cupiditate.', 'Est maxime blanditiis non qui est sunt. Excepturi doloribus magni impedit.', 'Quia unde et illum dolorem.', 'https://lorempixel.com/640/480/?60023', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
407(24, 'Salazar Ltda.', 'e Filhos', 'barreto.org', '1979-10-12', '01.311.399/0001-94', '(94) 95000-6000', 1, 2, 2, 8, 'Quis ut aspernatur exercitationem quos.', 'Sunt nihil maiores dolor possimus.', 'Et est rem dolor ad voluptatibus libero quaerat.', 'https://lorempixel.com/640/480/?37492', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
408(25, 'Aguiar-Fidalgo', 'e Filhos', 'toledo.org', '1995-11-10', '62.938.257/0001-46', '(54) 98896-9184', 1, 4, 3, 2, 'Neque rerum iusto omnis a.', 'Voluptatem in voluptatum adipisci explicabo earum. Consequatur neque ullam veniam eum doloremque at beatae ut.', 'Labore nostrum eos facere occaecati animi.', 'https://lorempixel.com/640/480/?73458', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
409(26, 'Oliveira S.A.', 'e Filhos', 'chaves.net', '2016-08-10', '86.532.567/0001-24', '(89) 3019-3224', 1, 2, 3, 7, 'Accusamus debitis maiores ipsam et ut ut error. Quia vero id laboriosam sit dolores nihil quia.', 'Velit dolores ut dolor ut commodi iusto.', 'Eos culpa minima qui qui illum enim dolor.', 'https://lorempixel.com/640/480/?71406', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
410(27, 'Lovato Comercial Ltda.', 'e Filhos', 'urias.net', '1970-10-11', '44.006.106/0001-78', '(51) 91435-1435', 1, 4, 3, 5, 'Ea accusantium vitae officia. Ab veritatis ipsam ut non dolorem eveniet.', 'Error molestiae ut quis officia aperiam praesentium. Voluptates ex laboriosam et delectus.', 'Provident nihil similique aut. Reprehenderit necessitatibus corrupti nihil id fugiat sapiente asperiores.', 'https://lorempixel.com/640/480/?69690', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
411(28, 'Vieira-Sandoval', 'S.A.', 'marin.org', '1973-08-12', '83.380.661/0001-17', '(45) 99533-5068', 1, 2, 2, 8, 'Esse veniam ex ut voluptas.', 'Quasi quisquam qui facere.', 'Quaerat eum eos et blanditiis perferendis.', 'https://lorempixel.com/640/480/?33734', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
412(29, 'Galhardo Comercial Ltda.', 'Ltda.', 'oliveira.com.br', '1988-01-13', '06.099.293/0001-92', '(99) 2962-6623', 4, 4, 4, 7, 'Labore animi sed non. Voluptas aut odit neque voluptatem sed alias nostrum.', 'Ex accusantium error libero qui eveniet accusantium blanditiis. Dolores repudiandae et voluptatem laborum omnis officia.', 'Eum ratione temporibus ut porro.', 'https://lorempixel.com/640/480/?59783', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
413(30, 'Feliciano e Maldonado', 'e Associados', 'leal.com.br', '1974-12-28', '46.028.099/0001-30', '(61) 90949-1414', 1, 4, 4, 9, 'Iure non explicabo ea quo rerum saepe.', 'Sequi quia velit consequatur laudantium similique nulla perspiciatis.', 'Omnis deserunt omnis laudantium adipisci unde porro explicabo.', 'https://lorempixel.com/640/480/?74294', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
414(31, 'Caldeira e Assunção Ltda.', 'e Filhos', 'campos.net', '1998-02-23', '64.825.887/0001-30', '(49) 3928-6427', 4, 1, 4, 2, 'Aut assumenda eos corrupti doloremque ea.', 'Voluptate et numquam non rerum soluta quia. Laboriosam rerum quisquam est fugiat maxime.', 'Dolores esse repellat architecto sunt corrupti. Soluta ex aspernatur tempore mollitia provident nisi.', 'https://lorempixel.com/640/480/?36047', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
415(32, 'Carmona-Fernandes', 'S.A.', 'flores.com', '2011-08-23', '00.989.009/0001-77', '(74) 93275-2606', 3, 2, 2, 2, 'Id rerum fugit excepturi. Explicabo illo dolores occaecati velit.', 'Repellendus commodi officia quo dolorum error qui optio. Est nostrum accusantium odit repellendus perspiciatis similique exercitationem.', 'Consequuntur quibusdam atque ipsum qui deserunt qui. Ad temporibus sed sit ab nisi.', 'https://lorempixel.com/640/480/?45110', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
416(33, 'Franco-Solano', 'Ltda.', 'darosa.org', '1987-05-30', '34.778.649/0001-50', '(16) 93936-8972', 1, 3, 2, 3, 'Voluptatem cupiditate in beatae cumque. Sed rerum voluptatem nobis.', 'Aut sed perspiciatis ea assumenda doloremque sequi autem.', 'Voluptatem aperiam quia consectetur debitis ut voluptate.', 'https://lorempixel.com/640/480/?41487', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
417(34, 'Correia e Paz', 'Ltda.', 'santacruz.org', '2015-07-06', '38.947.274/0001-65', '(34) 96331-1000', 1, 4, 3, 2, 'Ipsam qui totam omnis omnis consequuntur. Nihil consequuntur nisi praesentium quidem quia laborum dolores consectetur.', 'Et laboriosam voluptatem non reiciendis asperiores illum in.', 'Enim voluptatibus qui qui in et ut sit eos. Recusandae et quibusdam porro aspernatur.', 'https://lorempixel.com/640/480/?64621', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
418(35, 'Godói-Ferreira', 'e Filhos', 'meireles.net.br', '1984-08-29', '06.668.406/0001-23', '(33) 4024-2728', 4, 2, 4, 7, 'Velit sint aperiam eum tempore nihil iusto recusandae.', 'Qui ullam sint facere nobis mollitia.', 'Iure impedit unde error eius sint consectetur. Omnis repudiandae dolor qui numquam.', 'https://lorempixel.com/640/480/?88284', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
419(36, 'Ávila-Grego', 'e Filhos', 'rico.com.br', '1979-10-04', '75.856.656/0001-00', '(21) 4540-9134', 4, 2, 2, 9, 'Omnis rerum rerum quia debitis ullam omnis sequi. Incidunt minima est optio quod alias ex velit.', 'Voluptas quos voluptatem tempore ad quam quaerat deserunt.', 'Fuga molestiae reprehenderit nihil tempora sunt.', 'https://lorempixel.com/640/480/?47794', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
420(37, 'Dias e Sepúlveda', 'S.A.', 'matos.org', '1985-01-24', '08.430.322/0001-82', '(16) 99183-9826', 1, 4, 2, 6, 'Ut aut aut et repudiandae. Quo ea placeat sint veritatis consequuntur deserunt voluptas.', 'Assumenda occaecati commodi mollitia perferendis.', 'Voluptates laboriosam ut porro labore. Et quia et consequatur omnis dolorem.', 'https://lorempixel.com/640/480/?85740', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
421(38, 'Ávila e Batista S.A.', 'Ltda.', 'maldonado.com', '1975-06-26', '41.463.845/0001-09', '(42) 98197-5622', 4, 3, 3, 3, 'Vel dolor fuga incidunt qui iure molestias.', 'Eos distinctio et quo sunt qui dolores nesciunt. Sunt nam quibusdam dignissimos ut consequatur quia voluptatem.', 'Sint autem fugit voluptas dolorem. Dolorem itaque ut consequatur reiciendis laborum qui.', 'https://lorempixel.com/640/480/?52680', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
422(39, 'Cervantes e Matias S.A.', 'e Associados', 'quintana.com', '1982-10-04', '38.623.078/0001-35', '(49) 99366-7384', 3, 1, 4, 4, 'Placeat dolore omnis qui aut est harum delectus dignissimos.', 'Ut perspiciatis maxime sit officia quam sint vero. Quod laudantium eos ex cumque aperiam.', 'Reprehenderit harum quasi velit eum. Nihil nihil veniam omnis vel omnis tempora.', 'https://lorempixel.com/640/480/?53622', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
423(40, 'Faro-Ferreira', 'Ltda.', 'ferreira.net', '2011-12-06', '03.192.440/0001-86', '(93) 94725-0237', 1, 4, 2, 1, 'Exercitationem sit doloremque a sunt saepe dolor natus deserunt. Quidem ea animi omnis deserunt possimus voluptatem eum et.', 'Commodi deleniti ut deleniti est sint perferendis.', 'Velit quia dolor aliquid eligendi id blanditiis dolor.', 'https://lorempixel.com/640/480/?18359', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
424(41, 'Brito e Velasques Ltda.', 'Ltda.', 'jimenes.com.br', '2013-11-27', '89.694.190/0001-06', '(83) 97568-3760', 3, 1, 1, 10, 'Iusto expedita et aperiam repellat. Saepe ad inventore cumque et id libero voluptatem.', 'In neque quisquam cupiditate commodi possimus voluptate. Totam ut explicabo rerum animi corporis.', 'Rem ullam esse maxime quos et. Provident ea unde perferendis ut.', 'https://lorempixel.com/640/480/?17688', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
425(42, 'Corona e Marques e Filhos', 'S.A.', 'correia.org', '2016-01-21', '94.485.195/0001-50', '(69) 97785-1900', 4, 1, 3, 10, 'Repudiandae dolor quia assumenda id culpa aspernatur quia fugiat.', 'Modi dolor sapiente aliquid.', 'Vero et maiores eius et. Dolore atque rerum aut iste delectus voluptatem unde.', 'https://lorempixel.com/640/480/?55784', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
426(43, 'Duarte e Associados', 'e Associados', 'deaguiar.br', '2015-07-02', '53.385.242/0001-07', '(45) 4533-0501', 4, 1, 1, 6, 'Voluptas ipsam quo quia asperiores soluta cum sed ut. Aut mollitia incidunt maxime est iure est.', 'Laudantium atque consequuntur reiciendis nisi atque.', 'Pariatur veritatis nihil assumenda autem sit adipisci. Id voluptatibus molestiae est accusantium corporis.', 'https://lorempixel.com/640/480/?55809', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
427(44, 'Cruz e Roque', 'Ltda.', 'zamana.net.br', '1985-07-07', '65.185.040/0001-09', '(55) 90124-3270', 1, 3, 1, 4, 'Nesciunt nisi in sunt aut.', 'Repellat totam quibusdam est et. Qui molestiae est ipsa sit at qui.', 'Quis veritatis veniam tenetur ducimus. Aliquid ea ut velit in.', 'https://lorempixel.com/640/480/?54313', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
428(45, 'Dominato e Vale e Associados', 'e Filhos', 'branco.br', '2018-12-17', '02.031.695/0001-02', '(11) 4975-2090', 2, 2, 1, 10, 'Voluptatem dolor cupiditate libero blanditiis totam veritatis. Blanditiis quod commodi ipsa quibusdam.', 'Dolores similique voluptatem labore quo enim.', 'Eius et eaque saepe autem reprehenderit qui porro harum.', 'https://lorempixel.com/640/480/?55595', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
429(46, 'Escobar Comercial Ltda.', 'e Associados', 'dasdores.com.br', '1992-10-03', '85.635.124/0001-04', '(21) 4065-9998', 2, 4, 4, 3, 'Et praesentium unde fugiat necessitatibus excepturi.', 'Consequatur nam veritatis voluptatem architecto quia accusamus dolorum.', 'Odit tempora nulla autem velit repellat aut cupiditate.', 'https://lorempixel.com/640/480/?84500', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
430(47, 'Garcia Comercial Ltda.', 'Ltda.', 'romero.com.br', '1991-05-19', '10.942.694/0001-30', '(33) 96800-2748', 1, 1, 3, 6, 'Fuga debitis rerum aliquam culpa qui vel molestiae. Cum neque modi rem.', 'Quae enim qui ipsum molestiae quaerat.', 'Deleniti consectetur hic animi soluta est nihil ut. Alias debitis repellendus quod asperiores.', 'https://lorempixel.com/640/480/?47106', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
431(48, 'Esteves e Filhos', 'S.A.', 'carmona.net', '2013-02-15', '29.119.212/0001-74', '(63) 3865-4245', 1, 1, 3, 4, 'Dignissimos fugiat accusamus totam.', 'Doloremque optio id sequi consequuntur quasi non et. Vel eveniet et iure ut facere excepturi delectus.', 'Eius sunt aperiam dicta autem et. Ab qui magni quo voluptates.', 'https://lorempixel.com/640/480/?99590', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
432(49, 'Delatorre e Filhos', 'S.A.', 'mendonca.org', '1976-10-16', '34.239.040/0001-02', '(69) 4010-9190', 4, 1, 1, 10, 'Blanditiis asperiores ullam sapiente quos numquam consequatur. Consectetur consectetur non dolores.', 'Provident est blanditiis vero omnis est in. Et rerum ut earum dolor quis velit ea.', 'Sunt quaerat et dolores repudiandae rerum.', 'https://lorempixel.com/640/480/?49655', '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
433(50, 'Carmona Comercial Ltda.', 'S.A.', 'ferminiano.net', '1973-06-16', '52.449.559/0001-05', '(37) 97339-0562', 4, 4, 3, 8, 'Molestias enim qui est aut.', 'Nostrum voluptatem nihil itaque tempore magni occaecati.', 'Ipsam et modi natus vel praesentium aut eum.', 'https://lorempixel.com/640/480/?63351', '2019-04-05 05:05:35', '2019-04-05 05:05:35');
434
435-- --------------------------------------------------------
436
437--
438-- Estrutura para tabela `localizacoes`
439--
440
441DROP TABLE IF EXISTS `localizacoes`;
442CREATE TABLE IF NOT EXISTS `localizacoes` (
443  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
444  `lat` decimal(10,7) NOT NULL,
445  `lng` decimal(11,8) NOT NULL,
446  `endereco` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
447  `instituicao_id` int(10) UNSIGNED NOT NULL,
448  `created_at` timestamp NULL DEFAULT NULL,
449  `updated_at` timestamp NULL DEFAULT NULL,
450  PRIMARY KEY (`id`),
451  KEY `localizacoes_instituicao_id_foreign` (`instituicao_id`)
452) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
453
454--
455-- Despejando dados para a tabela `localizacoes`
456--
457
458INSERT INTO `localizacoes` (`id`, `lat`, `lng`, `endereco`, `instituicao_id`, `created_at`, `updated_at`) VALUES
459(1, '51.7215720', '155.83284900', '09132-014, Rua Lucas Cervantes, 8517\nPorto Rebeca do Norte - PB', 1, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
460(2, '63.3902610', '57.02117600', '89905-988, Travessa Noelí, 16996\nGomes do Norte - DF', 2, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
461(3, '-7.8882970', '-112.85829500', '37277-436, Largo Estêvão, 42\nBenjamin do Sul - RJ', 3, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
462(4, '-39.6128730', '-90.29054700', '04227-708, Travessa Vila, 13\nSamanta do Sul - MA', 4, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
463(5, '77.7481360', '-6.69771300', '87648-885, R. Kevin, 2367. Apto 9848\nPorto Gustavo - TO', 5, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
464(6, '26.0026890', '50.19320000', '73971-700, Avenida Salazar, 7061\nSão Gabriela d\'Oeste - MT', 6, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
465(7, '86.2118160', '-116.07914300', '02463-384, R. Adriano, 068. Bloco B\nJimenes do Leste - SC', 7, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
466(8, '68.2137750', '70.39748400', '48244-341, Largo Rodrigues, 230. Apto 9707\nVila Ricardo d\'Oeste - PE', 8, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
467(9, '3.8837440', '140.58322000', '83596-724, Travessa Santiago Prado, 705. Bloco B\nSanta Gian do Leste - RS', 9, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
468(10, '-44.1232130', '-110.88449600', '60738-065, Av. Malena das Neves, 2\nSanta Adriano d\'Oeste - SP', 10, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
469(11, '-70.3233660', '-116.48527800', '74250-050, R. Rebeca, 308. F\nBalestero do Norte - AC', 11, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
470(12, '-85.8880240', '95.19797500', '38714-813, R. Silvana Martines, 159\nThales do Norte - RJ', 12, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
471(13, '33.1111840', '-114.91332300', '13724-566, Avenida Amélia, 49388. Apto 62\nSão Isabella - RN', 13, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
472(14, '89.5726610', '35.48016400', '39118-385, Rua Amanda, 41465. Bloco C\nNatal do Sul - GO', 14, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
473(15, '-79.2592840', '94.74318400', '83205-925, Av. Guerra, 7. 5º Andar\nSanta Emiliano do Norte - GO', 15, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
474(16, '37.4541990', '170.38618200', '16736-242, Av. Rebeca Uchoa, 22\nVila Violeta d\'Oeste - SE', 16, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
475(17, '-6.2036600', '10.28633900', '81250-494, Travessa Pedro, 363. Bc. 5 Ap. 98\nInácio do Sul - RN', 17, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
476(18, '61.1883000', '28.57333200', '62150-746, Rua de Souza, 5913. Apto 9\nPorto Natália - RO', 18, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
477(19, '83.5827110', '97.51608800', '19303-323, Avenida Sabrina Sepúlveda, 959\nToledo d\'Oeste - PB', 19, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
478(20, '48.3735900', '-19.98569700', '65303-673, Rua Julieta Aragão, 8. Fundos\nToledo d\'Oeste - PI', 20, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
479(21, '32.9357380', '78.27663700', '74008-082, Travessa Daniela Queirós, 6576\nAguiar do Norte - DF', 21, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
480(22, '-83.3619280', '20.19532600', '17447-473, Av. Antônio Ortiz, 0408. Apto 26\nMolina do Leste - AM', 22, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
481(23, '80.1999000', '81.48921200', '46986-293, Av. Serna, 842\nSanta Henrique - SC', 23, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
482(24, '-10.3147920', '-107.47839800', '26979-326, Rua Nicole, 0\nSão Helena - MT', 24, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
483(25, '-5.0044260', '95.97328700', '68023-331, Av. Gabriel Soares, 556. 290º Andar\nVila Felipe do Norte - DF', 25, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
484(26, '-12.5934530', '-127.66973000', '50238-537, Avenida Furtado, 266\nRangel do Norte - MG', 26, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
485(27, '-27.5767990', '-170.32848200', '79317-572, Travessa Fernandes, 73655. Bloco C\nSalgado do Sul - PA', 27, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
486(28, '81.5367510', '-129.56964800', '09291-168, Avenida Jorge, 1208. Bloco B\nJosefina d\'Oeste - DF', 28, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
487(29, '-23.5899200', '-110.97430200', '41493-920, Rua Serna, 1223. Bloco C\nCarolina do Norte - SE', 29, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
488(30, '3.6078800', '-56.49915100', '66632-778, Avenida Jasmin, 048. Fundos\nPorto Jasmin - RS', 30, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
489(31, '-87.5848310', '28.61967800', '23662-342, Avenida Helena, 3646. Apto 799\nSanta Luciana do Norte - PB', 31, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
490(32, '40.9581810', '-96.52716200', '28011-222, Largo Sabrina das Neves, 210. Fundos\nVila Madalena - MS', 32, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
491(33, '24.5014970', '110.53597000', '97116-770, Largo Rezende, 33. 789º Andar\nVale do Norte - TO', 33, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
492(34, '87.5236450', '46.07670100', '98280-983, Avenida Alan das Neves, 94446. Bc. 4 Ap. 21\nPorto Thales - TO', 34, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
493(35, '46.9677260', '-6.00689800', '26702-040, Travessa Regina, 651\nPorto Tábata do Leste - MS', 35, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
494(36, '20.7933180', '158.00006800', '58930-636, Travessa Isabella, 537\nBruno do Sul - CE', 36, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
495(37, '-54.3101070', '19.38623300', '61150-463, Av. Galvão, 16\nMatias d\'Oeste - PI', 37, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
496(38, '-43.2093340', '136.93645900', '85217-314, Rua Pena, 480\nFaria do Leste - SE', 38, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
497(39, '55.5106220', '138.63647500', '99196-871, Travessa Sebastião, 61283\nVila Teobaldo d\'Oeste - PI', 39, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
498(40, '75.1963930', '-35.29777300', '70342-258, Travessa Josefina, 32\nChristian do Sul - RS', 40, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
499(41, '-15.6908720', '12.92428500', '44382-056, R. Galvão, 12. Bloco B\nSão Diego - AL', 41, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
500(42, '-54.7904510', '-2.66808900', '91306-064, Travessa Noelí Paz, 0885\nSanta Andres - PR', 42, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
501(43, '72.6915580', '103.89339600', '94939-367, Rua Fátima Mendonça, 9861\nRafael d\'Oeste - ES', 43, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
502(44, '-65.4883180', '-143.97876900', '22492-800, R. Tessália Ferminiano, 68486. Apto 84\nSanta Melissa - MT', 44, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
503(45, '43.6187050', '127.16587000', '16652-904, R. Fonseca, 4\nAlessandra do Norte - AM', 45, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
504(46, '-64.7651900', '44.24415800', '47794-011, R. Beatriz Grego, 4. 988º Andar\nBalestero do Sul - BA', 46, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
505(47, '67.4722410', '7.93855000', '13127-958, Avenida Cruz, 6084\nFlores d\'Oeste - PR', 47, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
506(48, '-69.3650920', '65.57582700', '39238-294, R. Fidalgo, 71249. 2º Andar\nSanta Sabrina - MG', 48, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
507(49, '71.8464740', '144.19429200', '15174-350, R. Bonilha, 6\nSanta Adriana - RR', 49, '2019-04-05 05:05:35', '2019-04-05 05:05:35'),
508(50, '-9.7025540', '139.06286200', '53552-758, Avenida Emanuel, 6980. 3º Andar\nSofia do Sul - MA', 50, '2019-04-05 05:05:35', '2019-04-05 05:05:35');
509
510-- --------------------------------------------------------
511
512--
513-- Estrutura para tabela `migrations`
514--
515
516DROP TABLE IF EXISTS `migrations`;
517CREATE TABLE IF NOT EXISTS `migrations` (
518  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
519  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
520  `batch` int(11) NOT NULL,
521  PRIMARY KEY (`id`)
522) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
523
524--
525-- Despejando dados para a tabela `migrations`
526--
527
528INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
529(1, '2014_10_12_000000_create_users_table', 1),
530(2, '2014_10_12_100000_create_password_resets_table', 1),
531(3, '2018_09_01_030212_create_permission_tables', 1),
532(4, '2018_09_01_0323100_area_atuacao', 1),
533(5, '2018_09_01_0324000_create_publico_alvo_table', 1),
534(6, '2018_09_01_0324100_quantidade_projetos', 1),
535(7, '2018_09_01_0324200_pessoas_atendidas', 1),
536(8, '2018_09_01_03242012_create_instituicoes_table', 1),
537(9, '2018_09_01_0324201_create_localizacoes_table', 1),
538(10, '2018_09_03_004227_create_doadores_table', 1),
539(11, '2018_09_09_215100_create_administrador_instituicao_table', 1),
540(12, '2018_09_23_221702_create_categorias_table', 1),
541(13, '2018_10_01_143510_create_doacoes_table', 1),
542(14, '2018_10_20_202427_create_pedidos_table', 1),
543(15, '2019_03_04_203242_create_cache_table', 1),
544(16, '2019_03_31_164847_create_contatos_table', 1),
545(17, '2019_03_31_164848_create_doacoes_instituicoes_table', 1);
546
547-- --------------------------------------------------------
548
549--
550-- Estrutura para tabela `model_has_permissions`
551--
552
553DROP TABLE IF EXISTS `model_has_permissions`;
554CREATE TABLE IF NOT EXISTS `model_has_permissions` (
555  `permission_id` int(10) UNSIGNED NOT NULL,
556  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
557  `model_id` bigint(20) UNSIGNED NOT NULL,
558  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
559  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
560) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
561
562-- --------------------------------------------------------
563
564--
565-- Estrutura para tabela `model_has_roles`
566--
567
568DROP TABLE IF EXISTS `model_has_roles`;
569CREATE TABLE IF NOT EXISTS `model_has_roles` (
570  `role_id` int(10) UNSIGNED NOT NULL,
571  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
572  `model_id` bigint(20) UNSIGNED NOT NULL,
573  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
574  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
575) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
576
577--
578-- Despejando dados para a tabela `model_has_roles`
579--
580
581INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
582(2, 'VoceSolidario\\Models\\User', 1),
583(2, 'VoceSolidario\\Models\\User', 2),
584(2, 'VoceSolidario\\Models\\User', 3),
585(2, 'VoceSolidario\\Models\\User', 4),
586(2, 'VoceSolidario\\Models\\User', 5),
587(2, 'VoceSolidario\\Models\\User', 6),
588(2, 'VoceSolidario\\Models\\User', 7),
589(2, 'VoceSolidario\\Models\\User', 8),
590(2, 'VoceSolidario\\Models\\User', 9),
591(2, 'VoceSolidario\\Models\\User', 10),
592(2, 'VoceSolidario\\Models\\User', 11),
593(2, 'VoceSolidario\\Models\\User', 12),
594(2, 'VoceSolidario\\Models\\User', 13),
595(2, 'VoceSolidario\\Models\\User', 14),
596(2, 'VoceSolidario\\Models\\User', 15),
597(2, 'VoceSolidario\\Models\\User', 16),
598(2, 'VoceSolidario\\Models\\User', 17),
599(2, 'VoceSolidario\\Models\\User', 18),
600(2, 'VoceSolidario\\Models\\User', 19),
601(2, 'VoceSolidario\\Models\\User', 20),
602(2, 'VoceSolidario\\Models\\User', 21),
603(2, 'VoceSolidario\\Models\\User', 22),
604(2, 'VoceSolidario\\Models\\User', 23),
605(2, 'VoceSolidario\\Models\\User', 24),
606(2, 'VoceSolidario\\Models\\User', 25),
607(1, 'VoceSolidario\\Models\\User', 26),
608(1, 'VoceSolidario\\Models\\User', 27),
609(1, 'VoceSolidario\\Models\\User', 28),
610(1, 'VoceSolidario\\Models\\User', 29),
611(1, 'VoceSolidario\\Models\\User', 30),
612(1, 'VoceSolidario\\Models\\User', 31),
613(1, 'VoceSolidario\\Models\\User', 32),
614(1, 'VoceSolidario\\Models\\User', 33),
615(1, 'VoceSolidario\\Models\\User', 34),
616(1, 'VoceSolidario\\Models\\User', 35),
617(1, 'VoceSolidario\\Models\\User', 36),
618(1, 'VoceSolidario\\Models\\User', 37),
619(1, 'VoceSolidario\\Models\\User', 38),
620(1, 'VoceSolidario\\Models\\User', 39),
621(1, 'VoceSolidario\\Models\\User', 40),
622(1, 'VoceSolidario\\Models\\User', 41),
623(1, 'VoceSolidario\\Models\\User', 42),
624(1, 'VoceSolidario\\Models\\User', 43),
625(1, 'VoceSolidario\\Models\\User', 44),
626(1, 'VoceSolidario\\Models\\User', 45),
627(1, 'VoceSolidario\\Models\\User', 46),
628(1, 'VoceSolidario\\Models\\User', 47),
629(1, 'VoceSolidario\\Models\\User', 48),
630(1, 'VoceSolidario\\Models\\User', 49),
631(1, 'VoceSolidario\\Models\\User', 50),
632(1, 'VoceSolidario\\Models\\User', 51),
633(1, 'VoceSolidario\\Models\\User', 52),
634(1, 'VoceSolidario\\Models\\User', 53),
635(1, 'VoceSolidario\\Models\\User', 54),
636(1, 'VoceSolidario\\Models\\User', 55),
637(1, 'VoceSolidario\\Models\\User', 56),
638(1, 'VoceSolidario\\Models\\User', 57),
639(1, 'VoceSolidario\\Models\\User', 58),
640(1, 'VoceSolidario\\Models\\User', 59),
641(1, 'VoceSolidario\\Models\\User', 60),
642(1, 'VoceSolidario\\Models\\User', 61),
643(1, 'VoceSolidario\\Models\\User', 62),
644(1, 'VoceSolidario\\Models\\User', 63),
645(1, 'VoceSolidario\\Models\\User', 64),
646(1, 'VoceSolidario\\Models\\User', 65),
647(1, 'VoceSolidario\\Models\\User', 66),
648(1, 'VoceSolidario\\Models\\User', 67),
649(1, 'VoceSolidario\\Models\\User', 68),
650(1, 'VoceSolidario\\Models\\User', 69),
651(1, 'VoceSolidario\\Models\\User', 70),
652(1, 'VoceSolidario\\Models\\User', 71),
653(1, 'VoceSolidario\\Models\\User', 72),
654(1, 'VoceSolidario\\Models\\User', 73),
655(1, 'VoceSolidario\\Models\\User', 74),
656(1, 'VoceSolidario\\Models\\User', 75);
657
658-- --------------------------------------------------------
659
660--
661-- Estrutura para tabela `password_resets`
662--
663
664DROP TABLE IF EXISTS `password_resets`;
665CREATE TABLE IF NOT EXISTS `password_resets` (
666  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
667  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
668  `created_at` timestamp NULL DEFAULT NULL,
669  KEY `password_resets_email_index` (`email`)
670) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
671
672-- --------------------------------------------------------
673
674--
675-- Estrutura para tabela `pedidos`
676--
677
678DROP TABLE IF EXISTS `pedidos`;
679CREATE TABLE IF NOT EXISTS `pedidos` (
680  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
681  `tituloPedido` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
682  `quantidadeSolicitada` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
683  `necessidade` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
684  `posso_retirar` enum('sim','não') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
685  `imagem` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
686  `estado` enum('atendido','em aberto') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'em aberto',
687  `instituicao_id` int(10) UNSIGNED NOT NULL,
688  `created_at` timestamp NULL DEFAULT NULL,
689  `updated_at` timestamp NULL DEFAULT NULL,
690  PRIMARY KEY (`id`),
691  KEY `pedidos_instituicao_id_foreign` (`instituicao_id`)
692) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
693
694--
695-- Despejando dados para a tabela `pedidos`
696--
697
698INSERT INTO `pedidos` (`id`, `tituloPedido`, `quantidadeSolicitada`, `necessidade`, `posso_retirar`, `imagem`, `estado`, `instituicao_id`, `created_at`, `updated_at`) VALUES
699(1, 'Ipsam quibusdam voluptatem ullam accusamus.', '3', 'Asperiores eius enim aut possimus dicta.', 'sim', NULL, 'em aberto', 9, '2018-11-23 09:16:07', '2019-04-05 05:05:39'),
700(2, 'Neque omnis et aut consequatur odit aspernatur.', '3', 'Quibusdam deserunt vitae quaerat exercitationem autem quod.', 'sim', NULL, 'em aberto', 3, '2018-03-02 05:08:32', '2019-04-05 05:05:39'),
701(3, 'Sunt dolorum perferendis.', '2', 'Aut explicabo neque asperiores ab dolorem.', 'não', NULL, 'em aberto', 9, '2019-04-02 23:31:24', '2019-04-05 05:05:39'),
702(4, 'Ut modi dignissimos.', '5', 'Facere laudantium molestiae.', 'não', NULL, 'em aberto', 9, '2018-04-08 11:31:18', '2019-04-05 05:05:39'),
703(5, 'Accusantium itaque.', '1', 'Ab commodi modi illum.', 'não', NULL, 'em aberto', 2, '2018-11-06 06:53:29', '2019-04-05 05:05:39'),
704(6, 'Rerum omnis velit.', '5', 'Non veniam aut in.', 'não', NULL, 'em aberto', 2, '2018-01-12 19:05:49', '2019-04-05 05:05:39'),
705(7, 'Optio adipisci sequi optio sit nihil.', '9', 'Est iste tenetur.', 'sim', NULL, 'em aberto', 8, '2018-05-17 10:15:51', '2019-04-05 05:05:39'),
706(8, 'Aut dolorem non perspiciatis.', '7', 'Saepe qui nihil quis at.', 'sim', NULL, 'em aberto', 9, '2018-06-17 04:05:42', '2019-04-05 05:05:39'),
707(9, 'Et et voluptatem.', '2', 'Sint ex omnis accusantium vitae saepe ad culpa.', 'não', NULL, 'em aberto', 2, '2018-09-30 06:49:21', '2019-04-05 05:05:39'),
708(10, 'Impedit aspernatur non.', '8', 'Aut voluptas soluta.', 'não', NULL, 'em aberto', 3, '2018-12-08 18:31:20', '2019-04-05 05:05:39'),
709(11, 'Quidem minus laudantium.', '8', 'Id dolores fugit.', 'não', NULL, 'em aberto', 8, '2018-08-24 08:42:48', '2019-04-05 05:05:39'),
710(12, 'Dicta cumque cupiditate ipsa veniam repudiandae.', '4', 'Quia non aut.', 'não', NULL, 'em aberto', 6, '2018-07-03 15:16:05', '2019-04-05 05:05:39'),
711(13, 'Vero ullam ipsam.', '3', 'Dicta error voluptatem voluptatum doloremque ab.', 'não', NULL, 'em aberto', 8, '2018-08-26 12:24:04', '2019-04-05 05:05:39'),
712(14, 'Labore ut consequatur et modi possimus.', '7', 'Eveniet qui reiciendis unde aut.', 'não', NULL, 'em aberto', 5, '2018-07-14 21:40:42', '2019-04-05 05:05:39'),
713(15, 'Aspernatur ducimus.', '7', 'Voluptate minus id aperiam.', 'sim', NULL, 'em aberto', 7, '2018-11-26 09:47:29', '2019-04-05 05:05:39'),
714(16, 'Sunt veritatis earum aspernatur voluptate ex veniam.', '7', 'Delectus necessitatibus maxime.', 'sim', NULL, 'em aberto', 5, '2018-04-24 16:09:05', '2019-04-05 05:05:39'),
715(17, 'Suscipit ut similique.', '3', 'Culpa iste impedit eligendi quasi eum autem eligendi.', 'sim', NULL, 'em aberto', 7, '2018-10-24 23:16:14', '2019-04-05 05:05:39'),
716(18, 'Rerum odit qui quia vitae animi.', '1', 'Et voluptatibus et magnam cumque autem consequatur.', 'não', NULL, 'em aberto', 9, '2019-01-20 09:32:29', '2019-04-05 05:05:39'),
717(19, 'Autem dolores nobis porro beatae numquam.', '5', 'Deserunt voluptas commodi dolorum ut rerum ut cum.', 'não', NULL, 'em aberto', 1, '2018-06-02 11:34:31', '2019-04-05 05:05:39'),
718(20, 'Cum quisquam.', '9', 'Magnam id non perferendis maxime qui.', 'sim', NULL, 'em aberto', 6, '2018-08-06 12:10:07', '2019-04-05 05:05:39'),
719(21, 'Dolor aut nulla optio quaerat.', '1', 'Reiciendis non sed quae et delectus.', 'sim', NULL, 'em aberto', 4, '2018-03-06 11:58:34', '2019-04-05 05:05:39'),
720(22, 'Reiciendis enim.', '1', 'Omnis qui sunt provident optio illo.', 'sim', NULL, 'em aberto', 4, '2018-08-19 02:12:18', '2019-04-05 05:05:39'),
721(23, 'Velit accusantium ipsam sit quis.', '1', 'Molestias quas distinctio.', 'não', NULL, 'em aberto', 3, '2019-03-14 20:03:43', '2019-04-05 05:05:39'),
722(24, 'Maiores sequi recusandae.', '1', 'Non similique perspiciatis eveniet.', 'não', NULL, 'em aberto', 3, '2018-11-20 00:39:10', '2019-04-05 05:05:39'),
723(25, 'Eos nihil.', '1', 'Eaque autem aperiam aut et occaecati.', 'sim', NULL, 'em aberto', 1, '2019-02-14 18:15:27', '2019-04-05 05:05:39'),
724(26, 'Aperiam nesciunt et quisquam corrupti.', '8', 'Aspernatur non doloribus dolorem soluta exercitationem voluptate saepe repellendus iure enim consequuntur.', 'sim', NULL, 'em aberto', 1, '2018-03-02 22:08:26', '2019-04-05 05:05:39'),
725(27, 'Explicabo ut culpa nihil.', '6', 'Error provident ut amet.', 'não', NULL, 'em aberto', 1, '2019-03-09 01:25:31', '2019-04-05 05:05:39'),
726(28, 'Ut id ex.', '9', 'Sit assumenda ipsam animi.', 'não', NULL, 'em aberto', 4, '2018-09-25 07:52:22', '2019-04-05 05:05:39'),
727(29, 'Repellat quam dicta aut cupiditate.', '9', 'Asperiores minima commodi.', 'sim', NULL, 'em aberto', 9, '2018-03-23 19:46:31', '2019-04-05 05:05:39'),
728(30, 'Totam quia totam et.', '4', 'Et quo sequi odit.', 'não', NULL, 'em aberto', 9, '2019-03-24 22:22:19', '2019-04-05 05:05:39'),
729(31, 'Laboriosam rem aliquam.', '5', 'Dolorum adipisci modi earum.', 'não', NULL, 'em aberto', 4, '2018-01-08 11:44:04', '2019-04-05 05:05:39'),
730(32, 'Qui et delectus molestiae.', '1', 'Aut similique aut illo.', 'sim', NULL, 'em aberto', 2, '2018-03-14 15:14:30', '2019-04-05 05:05:39'),
731(33, 'Molestiae eveniet et cupiditate.', '8', 'Quibusdam perferendis reprehenderit iste porro debitis neque.', 'sim', NULL, 'em aberto', 2, '2019-03-07 22:19:20', '2019-04-05 05:05:39'),
732(34, 'Id enim nesciunt.', '4', 'Tempora magni sint nobis id eius consequatur non minima.', 'não', NULL, 'em aberto', 9, '2019-02-12 23:22:53', '2019-04-05 05:05:39'),
733(35, 'Et explicabo.', '3', 'Odio molestiae odio omnis quia omnis et.', 'sim', NULL, 'em aberto', 8, '2018-12-25 20:08:36', '2019-04-05 05:05:39');
734
735-- --------------------------------------------------------
736
737--
738-- Estrutura para tabela `permissions`
739--
740
741DROP TABLE IF EXISTS `permissions`;
742CREATE TABLE IF NOT EXISTS `permissions` (
743  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
744  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
745  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
746  `created_at` timestamp NULL DEFAULT NULL,
747  `updated_at` timestamp NULL DEFAULT NULL,
748  PRIMARY KEY (`id`)
749) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
750
751--
752-- Despejando dados para a tabela `permissions`
753--
754
755INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
756(1, 'Criar Evento', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
757(2, 'Editar Evento', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
758(3, 'Deletar Evento', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
759(4, 'Solicitar Doação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
760(5, 'Criar Solicitação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
761(6, 'Editar Solicitação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
762(7, 'Deletar Solicitação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
763(8, 'Realizar Doação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
764(9, 'Cadastrar Doação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
765(10, 'Editar Doação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
766(11, 'Deletar Doação', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
767(12, 'Confirmar Presença no evento', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
768(13, 'Administrador do Sistema', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33');
769
770-- --------------------------------------------------------
771
772--
773-- Estrutura para tabela `pessoas_atendidas`
774--
775
776DROP TABLE IF EXISTS `pessoas_atendidas`;
777CREATE TABLE IF NOT EXISTS `pessoas_atendidas` (
778  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
779  `atendidos` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
780  `created_at` timestamp NULL DEFAULT NULL,
781  `updated_at` timestamp NULL DEFAULT NULL,
782  PRIMARY KEY (`id`)
783) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
784
785--
786-- Despejando dados para a tabela `pessoas_atendidas`
787--
788
789INSERT INTO `pessoas_atendidas` (`id`, `atendidos`, `created_at`, `updated_at`) VALUES
790(1, 'até 25', '2019-04-05 05:05:33', NULL),
791(2, 'entre 26 e 50', '2019-04-05 05:05:33', NULL),
792(3, 'entre 51 e 100', '2019-04-05 05:05:33', NULL),
793(4, 'mais de 100', '2019-04-05 05:05:33', NULL);
794
795-- --------------------------------------------------------
796
797--
798-- Estrutura para tabela `publico_alvo`
799--
800
801DROP TABLE IF EXISTS `publico_alvo`;
802CREATE TABLE IF NOT EXISTS `publico_alvo` (
803  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
804  `publico` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
805  `created_at` timestamp NULL DEFAULT NULL,
806  `updated_at` timestamp NULL DEFAULT NULL,
807  PRIMARY KEY (`id`)
808) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
809
810--
811-- Despejando dados para a tabela `publico_alvo`
812--
813
814INSERT INTO `publico_alvo` (`id`, `publico`, `created_at`, `updated_at`) VALUES
815(1, 'Adolecentes', '2019-04-05 05:05:33', NULL),
816(2, 'Crianças', '2019-04-05 05:05:33', NULL),
817(3, 'Crianças e Adolecentes', '2019-04-05 05:05:33', NULL),
818(4, 'Deficiêntes ou portadores de deficiências', '2019-04-05 05:05:33', NULL),
819(5, 'Famílias', '2019-04-05 05:05:33', NULL),
820(6, 'Homens', '2019-04-05 05:05:33', NULL),
821(7, 'Idosos', '2019-04-05 05:05:33', NULL),
822(8, 'Jovens', '2019-04-05 05:05:33', NULL),
823(9, 'Jovens e Adultos', '2019-04-05 05:05:33', NULL),
824(10, 'Mulheres', '2019-04-05 05:05:33', NULL);
825
826-- --------------------------------------------------------
827
828--
829-- Estrutura para tabela `quantidade_projetos`
830--
831
832DROP TABLE IF EXISTS `quantidade_projetos`;
833CREATE TABLE IF NOT EXISTS `quantidade_projetos` (
834  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
835  `projetos` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
836  `created_at` timestamp NULL DEFAULT NULL,
837  `updated_at` timestamp NULL DEFAULT NULL,
838  PRIMARY KEY (`id`)
839) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
840
841--
842-- Despejando dados para a tabela `quantidade_projetos`
843--
844
845INSERT INTO `quantidade_projetos` (`id`, `projetos`, `created_at`, `updated_at`) VALUES
846(1, '1', '2019-04-05 05:05:33', NULL),
847(2, '2', '2019-04-05 05:05:33', NULL),
848(3, '3', '2019-04-05 05:05:33', NULL),
849(4, 'mais de 4', '2019-04-05 05:05:33', NULL);
850
851-- --------------------------------------------------------
852
853--
854-- Estrutura para tabela `roles`
855--
856
857DROP TABLE IF EXISTS `roles`;
858CREATE TABLE IF NOT EXISTS `roles` (
859  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
860  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
861  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
862  `created_at` timestamp NULL DEFAULT NULL,
863  `updated_at` timestamp NULL DEFAULT NULL,
864  PRIMARY KEY (`id`)
865) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
866
867--
868-- Despejando dados para a tabela `roles`
869--
870
871INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
872(1, 'Instituição', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
873(2, 'Doador', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33'),
874(3, 'Administrador', 'web', '2019-04-05 05:05:33', '2019-04-05 05:05:33');
875
876-- --------------------------------------------------------
877
878--
879-- Estrutura para tabela `role_has_permissions`
880--
881
882DROP TABLE IF EXISTS `role_has_permissions`;
883CREATE TABLE IF NOT EXISTS `role_has_permissions` (
884  `permission_id` int(10) UNSIGNED NOT NULL,
885  `role_id` int(10) UNSIGNED NOT NULL,
886  PRIMARY KEY (`permission_id`,`role_id`),
887  KEY `role_has_permissions_role_id_foreign` (`role_id`)
888) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
889
890--
891-- Despejando dados para a tabela `role_has_permissions`
892--
893
894INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
895(1, 1),
896(2, 1),
897(3, 1),
898(4, 1),
899(5, 1),
900(6, 1),
901(7, 1),
902(8, 2),
903(9, 2),
904(10, 2),
905(11, 2),
906(12, 2),
907(13, 3);
908
909-- --------------------------------------------------------
910
911--
912-- Estrutura para tabela `users`
913--
914
915DROP TABLE IF EXISTS `users`;
916CREATE TABLE IF NOT EXISTS `users` (
917  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
918  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
919  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
920  `perfil_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
921  `perfil_id` int(11) NOT NULL,
922  `ativo` tinyint(1) NOT NULL DEFAULT '0',
923  `confirmado` tinyint(1) NOT NULL DEFAULT '0',
924  `email_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
925  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
926  `created_at` timestamp NULL DEFAULT NULL,
927  `updated_at` timestamp NULL DEFAULT NULL,
928  PRIMARY KEY (`id`),
929  UNIQUE KEY `users_email_unique` (`email`)
930) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
931
932--
933-- Despejando dados para a tabela `users`
934--
935
936INSERT INTO `users` (`id`, `email`, `password`, `perfil_type`, `perfil_id`, `ativo`, `confirmado`, `email_token`, `remember_token`, `created_at`, `updated_at`) VALUES
937(1, 'catarina74@yahoo.com', '$2y$10$O2DJv3.bxPIvwRW6XXo7n.qssaqG.wo5xAnTivGOKUBydgZoCrbTm', 'VoceSolidario\\Models\\Doador', 1, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-06-29 08:06:01', '2019-04-05 05:05:33'),
938(2, 'josue.chaves@r7.com', '$2y$10$q874HIX6vNdViIetAPHGNOGxrIkrypA4TPOIZ3hibn6uXLmUnoPve', 'VoceSolidario\\Models\\Doador', 2, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-08-16 08:25:32', '2019-04-05 05:05:33'),
939(3, 'andrea11@terra.com.br', '$2y$10$01EuLvUD/9HTDfdtixvNL.2qI3iWMj7Q7qNHLTxT5IGSxj6GAIxB.', 'VoceSolidario\\Models\\Doador', 3, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-02 20:36:12', '2019-04-05 05:05:33'),
940(4, 'benjamin22@campos.net', '$2y$10$brcvqWdpsVHfn5b77uJ3Fe9gLfHdJFgFKDQVEXyVMcASQAnDsLAdu', 'VoceSolidario\\Models\\Doador', 4, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-02-22 03:52:22', '2019-04-05 05:05:33'),
941(5, 'joaquin09@gomes.com', '$2y$10$mJhcGniQVhoB7PmF1bSq1Oqr.EbE7LYZHRMcp6785ygzZ/Ha8OGdq', 'VoceSolidario\\Models\\Doador', 5, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-30 18:40:54', '2019-04-05 05:05:34'),
942(6, 'dsantacruz@bezerra.com.br', '$2y$10$hUpbtmnOm6bLoPqB6EDa.OerDKLnrOaVmbUmcw.yFuWwfZmZaLZLW', 'VoceSolidario\\Models\\Doador', 6, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-01-18 10:47:17', '2019-04-05 05:05:34'),
943(7, 'prico@uol.com.br', '$2y$10$yUXxMI1VKGn8gHgmIjhlvOog66xIXU/j0N1LHH4C4tusiJvtG6h1i', 'VoceSolidario\\Models\\Doador', 7, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-07-09 14:28:57', '2019-04-05 05:05:34'),
944(8, 'fernando.solano@yahoo.com', '$2y$10$eCM0PJht3h1Y9ox55bC.9OeCgXYLSrvI3PV45Q8Lb/bE6eaAya2G.', 'VoceSolidario\\Models\\Doador', 8, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-07-11 13:32:20', '2019-04-05 05:05:34'),
945(9, 'cordeiro.mia@chaves.br', '$2y$10$lkcTnSc.S5o3EU7H7byOAuaEexnqst4ux.8NGTzWCKwxI/4FwRe.q', 'VoceSolidario\\Models\\Doador', 9, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-02-13 10:16:12', '2019-04-05 05:05:34'),
946(10, 'daniel.aranda@ig.com.br', '$2y$10$aklhqRotDgA2wCylktz/GOU/BppPCrf2uRFE3g3eCmfIEKO24hYC2', 'VoceSolidario\\Models\\Doador', 10, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-12-21 14:02:06', '2019-04-05 05:05:34'),
947(11, 'micaela.delvalle@r7.com', '$2y$10$uWoCYt50b6tIXitC1Y3UTuhb5udS94kKBbNBK.MHgxsvc4a0glGn6', 'VoceSolidario\\Models\\Doador', 11, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-10-28 11:56:30', '2019-04-05 05:05:34'),
948(12, 'zamana.guilherme@montenegro.br', '$2y$10$ExEcxIgeBOIn2QP5cekOmOJB.uWPBMCbsgsjDrZd8DCgTXeiR88iu', 'VoceSolidario\\Models\\Doador', 12, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-11-22 20:49:07', '2019-04-05 05:05:34'),
949(13, 'hvalencia@espinoza.net', '$2y$10$2TwhTg62xSB0NKjEVFkdduZy3P09UWxzcli.2tawQSWcZB8qLMPVy', 'VoceSolidario\\Models\\Doador', 13, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-03-29 07:02:09', '2019-04-05 05:05:34'),
950(14, 'wgarcia@davila.com', '$2y$10$x.y8Dln6dF0xAyXmFD56KeiffLNvRH61nGRRKFYVw8Dlw/htCdbGC', 'VoceSolidario\\Models\\Doador', 14, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-07-14 14:25:57', '2019-04-05 05:05:34'),
951(15, 'diego.godoi@correia.org', '$2y$10$4oVckj6n74ly0FKBaK.ss.48aZMJHPIKgLYKsvcV7Kbned2CbAQLa', 'VoceSolidario\\Models\\Doador', 15, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-02-12 18:46:18', '2019-04-05 05:05:34'),
952(16, 'jrosa@hotmail.com', '$2y$10$zs/r7Ag160W6FVty83JKT.8TNG8qqG2JKWb5QSRowec5bvKx7rILW', 'VoceSolidario\\Models\\Doador', 16, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-02-04 11:43:59', '2019-04-05 05:05:34'),
953(17, 'valentina82@correia.br', '$2y$10$4QyVYEpqA.F6u4HTB6eFHu2oY1rpL8V5Db4kPd1Gu3oET78cXb90i', 'VoceSolidario\\Models\\Doador', 17, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-04 21:33:25', '2019-04-05 05:05:34'),
954(18, 'ana.quintana@hotmail.com', '$2y$10$gBgUsn8WHdf9hEAqiPNuLe/SzRLKGK.3rNuOQpeTTQNii1EP.PtCq', 'VoceSolidario\\Models\\Doador', 18, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-02-08 09:56:33', '2019-04-05 05:05:34'),
955(19, 'tabata.velasques@madeira.com.br', '$2y$10$DjCOj4o.7MNZYsP.eBYcTeMQEImzjQ7YL9xp9cRkltQ3xmlkS8OCu', 'VoceSolidario\\Models\\Doador', 19, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-01-17 03:29:07', '2019-04-05 05:05:34'),
956(20, 'jacomo84@leal.net.br', '$2y$10$wH/W3MOXeeWgIcQjWG7vaeY9Susj0704tBqnUB/mTL2TzIwptaoBm', 'VoceSolidario\\Models\\Doador', 20, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-10-05 05:57:54', '2019-04-05 05:05:35'),
957(21, 'regina85@gmail.com', '$2y$10$NdinHRLgv0Y0ZaXdLWmUT.hSGpVxDXhvjYsFdNYDdXi1kSIhcAuB.', 'VoceSolidario\\Models\\Doador', 21, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-01-04 12:14:53', '2019-04-05 05:05:35'),
958(22, 'sfeliciano@aragao.com.br', '$2y$10$/qupRbPS7grCYs8NZqtWd.L5RTHNmzAAH15GqipWHOA/z7Szu5U2e', 'VoceSolidario\\Models\\Doador', 22, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-01-05 09:45:46', '2019-04-05 05:05:35'),
959(23, 'sanches.agostinho@yahoo.com', '$2y$10$fkxiDsbbyBZQauNHD7kmOunU2mOgM94ekG6syK0Jil5NnMQi/l6m2', 'VoceSolidario\\Models\\Doador', 23, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-10-07 07:21:06', '2019-04-05 05:05:35'),
960(24, 'azevedo.rafaela@jimenes.com', '$2y$10$ha9rmMaY1cVyrkEwt7Otr.M1a.tuHvB198FlnllGuUNAkrAaqC/La', 'VoceSolidario\\Models\\Doador', 24, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-04-02 04:52:12', '2019-04-05 05:05:35'),
961(25, 'christopher26@beltrao.net.br', '$2y$10$TsGQRSr5AsLiFxA4wjJFQOOfwahgGtemEnDYvNx3fcch30kUs70..', 'VoceSolidario\\Models\\Doador', 25, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-24 16:07:42', '2019-04-05 05:05:35'),
962(26, 'desteves@r7.com', '$2y$10$RXnDyF0wmDfEoTt6NH4ZsuWlHzVlK1d3QekUJRKNNfBpgLUV1frle', 'VoceSolidario\\Models\\Instituicao', 1, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-12-27 23:57:38', '2019-04-05 05:05:35'),
963(27, 'vale.olivia@r7.com', '$2y$10$9Uk8J1r8SQPPNsFSnyFuoOizdEopZGfYozy78Pso5za/ay7yN1w8e', 'VoceSolidario\\Models\\Instituicao', 2, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-14 02:51:41', '2019-04-05 05:05:35'),
964(28, 'agustina.correia@martines.com', '$2y$10$gOVCX6bv7q5LcgmpMjcTgub4COK/vA6Vf0bm80hunfHSQ8iohnlme', 'VoceSolidario\\Models\\Instituicao', 3, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-12-29 03:56:38', '2019-04-05 05:05:35'),
965(29, 'sleon@verdara.net.br', '$2y$10$R6hZx9CNxcnd9Gv0AGvI/uULmd7UR1vm8cvbtNn6QF4pXt/W0wx86', 'VoceSolidario\\Models\\Instituicao', 4, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-07-21 11:52:24', '2019-04-05 05:05:35'),
966(30, 'sara.vila@galvao.net', '$2y$10$RwXDFbNwLfeQmnR/368OHuPIzQTpFiqRs03vV/OqlOwfFoJvyU/2m', 'VoceSolidario\\Models\\Instituicao', 5, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-03-12 20:19:44', '2019-04-05 05:05:35'),
967(31, 'branco.christopher@soto.com', '$2y$10$OxHR/drpUjaWPg0Kb5g.MOWz8MftBlZhxmlU1b1TwkjCdq05vIF7e', 'VoceSolidario\\Models\\Instituicao', 6, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-21 05:10:54', '2019-04-05 05:05:36'),
968(32, 'nadia81@solano.br', '$2y$10$g1NXL61bvhcgC0ZIWlLyxe3aSMa0TJ0Dk4Cp1yH1ZWPy6vQU24xrO', 'VoceSolidario\\Models\\Instituicao', 7, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-10-06 17:29:30', '2019-04-05 05:05:36'),
969(33, 'demian30@carrara.com', '$2y$10$spabN5P/dX7yzNdUqrXorO7v65ExOh533pljoIq2ylqowTcI7Zg0a', 'VoceSolidario\\Models\\Instituicao', 8, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-01-10 03:22:39', '2019-04-05 05:05:36'),
970(34, 'corona.alonso@terra.com.br', '$2y$10$uOc3VBwe4xsiY8K0aH/CqOcWysbKH2mhjZz7qMTJDuP.bPN/iivQS', 'VoceSolidario\\Models\\Instituicao', 9, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', 'OkP6GJKxvkN7rGTnC7zf91RsQmrO253a2NJ6WWDHbliFcon6wND5BicUHhZa', '2018-09-24 12:18:46', '2019-04-05 05:05:36'),
971(35, 'carla83@maia.net', '$2y$10$LSd04G8MLdX5k3477AJnL.qNhqpqkjHRI.jeHzds2x7xy2nhm3xo2', 'VoceSolidario\\Models\\Instituicao', 10, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-11-02 10:19:34', '2019-04-05 05:05:36'),
972(36, 'nicole.colaco@delgado.com', '$2y$10$yMwrPDOjClB5BBYhO/.pkOmy5zG10/t0NNWnq4JD72i2YbYq.PHH6', 'VoceSolidario\\Models\\Instituicao', 11, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-03-20 16:36:36', '2019-04-05 05:05:36'),
973(37, 'salome.soto@montenegro.com.br', '$2y$10$UfxlOsvswRT7hJZQLmBXMeyRrsNwi1WFWkGQyN2lpahTdsp3k7CUq', 'VoceSolidario\\Models\\Instituicao', 12, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-02-13 12:12:30', '2019-04-05 05:05:36'),
974(38, 'uteles@barros.br', '$2y$10$n7pRAFHwyHdlcDLZAU5uW.Mr35/4i/C.Qfm/EuZf0zpEhHtOTHWh6', 'VoceSolidario\\Models\\Instituicao', 13, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-10 09:57:07', '2019-04-05 05:05:36'),
975(39, 'azevedo.hortencia@gmail.com', '$2y$10$G.FOWO9c.2ROMO65sTi/POxpC2EKBCx2isBbhizEGhOOdwlqz5QbG', 'VoceSolidario\\Models\\Instituicao', 14, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-03-19 12:14:34', '2019-04-05 05:05:36'),
976(40, 'goncalves.maite@vasques.com.br', '$2y$10$qlU5S6c4SiyyhTfLKs3K5exVLLa8yWKdi7oa5VQxsKX8Sucyf54Dy', 'VoceSolidario\\Models\\Instituicao', 15, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-08-25 20:28:08', '2019-04-05 05:05:36'),
977(41, 'pbrito@r7.com', '$2y$10$8YeAo8CbPeK2LYcPALU0AujTl/H7CkVW0sxNrZvMj.4Dqa.84vRw2', 'VoceSolidario\\Models\\Instituicao', 16, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-12 12:23:51', '2019-04-05 05:05:36'),
978(42, 'ariadna.franco@furtado.com.br', '$2y$10$MiUfDf8157JGc8.ZbXMDJOk8KtafMlRNOtROnHZuptnSYz.hP.b3q', 'VoceSolidario\\Models\\Instituicao', 17, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-05 19:35:25', '2019-04-05 05:05:36'),
979(43, 'miguel.abreu@terra.com.br', '$2y$10$YMa.Ie0QLPNG59p4C4q0wej2/meppyhQn1wuKzFluXv.3THUBG0RO', 'VoceSolidario\\Models\\Instituicao', 18, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-03-18 02:17:10', '2019-04-05 05:05:36'),
980(44, 'ibeltrao@yahoo.com', '$2y$10$2UGi9hKwPIpU0cckg.QiWOw/U.ho9htBMk9YxM76WSgZULCJzSmjC', 'VoceSolidario\\Models\\Instituicao', 19, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-09-28 03:32:16', '2019-04-05 05:05:36'),
981(45, 'ziraldo.fontes@paes.com', '$2y$10$Os2iLsfz4Uo.wzGYPL/1EOFDf5sQZXVixaH8LylhQaqj.ygCZps2O', 'VoceSolidario\\Models\\Instituicao', 20, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-07-28 13:44:00', '2019-04-05 05:05:36'),
982(46, 'diego05@mendes.com.br', '$2y$10$Bu/ZRMevLtVHnmPgDuFiW.QpoW0l4XjEsDWGiIsNZVhYQY22EbtVW', 'VoceSolidario\\Models\\Instituicao', 21, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-12-09 01:40:49', '2019-04-05 05:05:36'),
983(47, 'vila.nadia@prado.org', '$2y$10$gX.DqTXguhAVGzJcV2P7CuQIsmsqZ/TGYn28YQDB7gcu2R9HTQ1x6', 'VoceSolidario\\Models\\Instituicao', 22, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-12-21 22:43:37', '2019-04-05 05:05:37'),
984(48, 'qmadeira@caldeira.com.br', '$2y$10$a8aTkrZ4eMLKEiFpnevloe0eYfuXLOlsJdsYhbo9p8Uy0ugKB45YC', 'VoceSolidario\\Models\\Instituicao', 23, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-12-17 20:31:55', '2019-04-05 05:05:37'),
985(49, 'antonio76@branco.com.br', '$2y$10$19YP4/cdOYQluoogpffNw.c.iYLZnfDmw4kPjH8/L4nxU0FzMRbTa', 'VoceSolidario\\Models\\Instituicao', 24, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-01 19:36:39', '2019-04-05 05:05:37'),
986(50, 'simon93@r7.com', '$2y$10$kjGPg4fu9P//BHTQRtVWqe0xXqW3/VNnOoezONdVYs/jPh4ih/JqW', 'VoceSolidario\\Models\\Instituicao', 25, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-15 18:28:04', '2019-04-05 05:05:37'),
987(51, 'dacruz.noel@meireles.com.br', '$2y$10$nGhKMzUDbtdWHiKx6fSwZuecnFtjuPZlDjUnooB965Mwcu6kuNY9i', 'VoceSolidario\\Models\\Instituicao', 26, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-26 15:48:44', '2019-04-05 05:05:37'),
988(52, 'lucas42@ig.com.br', '$2y$10$T6OzcOXOVsl0EkxfEQyXCuLdem5t6PFBX4SdNbiC/PqdgUUmYwpk6', 'VoceSolidario\\Models\\Instituicao', 27, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-03-10 01:37:00', '2019-04-05 05:05:37'),
989(53, 'michele75@hotmail.com', '$2y$10$nQ8PNtz4z0QxC3QAcMWyH.c8kcoG4iFMnT/OlAVm2XOSIJoSGkzcy', 'VoceSolidario\\Models\\Instituicao', 28, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-02-16 09:08:20', '2019-04-05 05:05:37'),
990(54, 'alexandre.bittencourt@ig.com.br', '$2y$10$TCl6WvId.YDWBn7lKZFZU.EaOz4rVrE.VlfxOgkXcrmCacspftGEe', 'VoceSolidario\\Models\\Instituicao', 29, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-09-23 22:05:31', '2019-04-05 05:05:37'),
991(55, 'pedrosa.maximiano@carmona.com.br', '$2y$10$XsWBvpHGiYOwadXqhbqvxev0US6VkoeW3JhdkQNlVT9m6IoOcud5q', 'VoceSolidario\\Models\\Instituicao', 30, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-11-29 00:27:40', '2019-04-05 05:05:37'),
992(56, 'alexa.serrano@terra.com.br', '$2y$10$p6cWbXiREbqGc2qptuBT3OiKet5IPYpvsehSaEf2H3NhJpuZ.5Om2', 'VoceSolidario\\Models\\Instituicao', 31, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-03-11 21:45:33', '2019-04-05 05:05:37'),
993(57, 'qsolano@uol.com.br', '$2y$10$TI8gDLmIjCKhyX5q6ggBKu7dUCfeUwv3mVNLz/epXgxAqB8Sg9nx2', 'VoceSolidario\\Models\\Instituicao', 32, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-09-21 12:25:43', '2019-04-05 05:05:37'),
994(58, 'rafaela38@gmail.com', '$2y$10$bFT7ihW.XBX3I78bxCOTeeWji8KYdDyCrduNRTv5X6DFG3IQZbRbm', 'VoceSolidario\\Models\\Instituicao', 33, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-03-18 20:40:23', '2019-04-05 05:05:37'),
995(59, 'leonardo60@ferminiano.net', '$2y$10$WdRRTgTcPWPNxS.RQSVS8.TG6tdP7pkUClsuEVV5Btgcd.HW7ViHm', 'VoceSolidario\\Models\\Instituicao', 34, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-07-05 15:52:50', '2019-04-05 05:05:37'),
996(60, 'barros.andres@gmail.com', '$2y$10$FD8RLiir0Y69yvesDfI0R.A0Y9ZpdLSyhZKPCw3MpDgjS0Op9wWNW', 'VoceSolidario\\Models\\Instituicao', 35, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-10-30 00:35:52', '2019-04-05 05:05:37'),
997(61, 'pedro.matias@brito.com', '$2y$10$7Bgw6CadM.Hhn/aTFEtFbOsK0J6I2fIlmo40qOZhdVuqfWUZPWXJu', 'VoceSolidario\\Models\\Instituicao', 36, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-12-07 11:06:36', '2019-04-05 05:05:37'),
998(62, 'ornela92@uol.com.br', '$2y$10$60CNwkn/YvtWGLrJv/QkfOeED3pvdPLEUauUyKPNbbtSLuxSThoG6', 'VoceSolidario\\Models\\Instituicao', 37, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-08-24 18:45:54', '2019-04-05 05:05:38'),
999(63, 'bianca47@yahoo.com', '$2y$10$EFxw.T4kzawl1VDKEI5Vjug80InxxUtWVaALCgPL4h5QTwVzgY6RO', 'VoceSolidario\\Models\\Instituicao', 38, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-28 21:28:27', '2019-04-05 05:05:38'),
1000(64, 'gdomingues@camacho.com.br', '$2y$10$w1GfUO6/uySwNJdc3kkKOuLeRSxlRYLf88tGD0WTCS0mLGlYgeyPa', 'VoceSolidario\\Models\\Instituicao', 39, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-09 03:36:10', '2019-04-05 05:05:38'),
1001(65, 'luzia15@hotmail.com', '$2y$10$gh2bRP5GJwzBkOBWhYo1VOaJSRlkh9c6WLfnL07cbnXInCJQ1FovO', 'VoceSolidario\\Models\\Instituicao', 40, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-10-28 16:24:07', '2019-04-05 05:05:38'),
1002(66, 'joao93@terra.com.br', '$2y$10$BrmZSs1337xF378fLCaQYe2im/WK9nrxfdyNRMRAvFw6fJkkHRvxq', 'VoceSolidario\\Models\\Instituicao', 41, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-09-27 00:51:52', '2019-04-05 05:05:38'),
1003(67, 'rebeca.pacheco@ig.com.br', '$2y$10$zdt34OtVss3Yw8BWTNi/n./Bt1IEX/KSixjVD6rUh13HKsMvmsJXq', 'VoceSolidario\\Models\\Instituicao', 42, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-22 18:40:38', '2019-04-05 05:05:38'),
1004(68, 'sbeltrao@hotmail.com', '$2y$10$2CbyQeX3kNuAKRdGcb.jGud8xcRGGD9io4ujJ6SdubsFRmo7vXwby', 'VoceSolidario\\Models\\Instituicao', 43, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-08-09 03:07:02', '2019-04-05 05:05:38'),
1005(69, 'pedro.valencia@pena.br', '$2y$10$Dx1DarMYjUoNfgymmz4APuHPSN4qYWZ/9Tu3FEFtJ4Fn3pr3qaHHG', 'VoceSolidario\\Models\\Instituicao', 44, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-01-05 05:12:38', '2019-04-05 05:05:38'),
1006(70, 'sfonseca@benites.br', '$2y$10$JT9xPcnlw97YA8IgJDQrB.YceVi8SLF.vCYwFJQxxP/igc6DUsW/m', 'VoceSolidario\\Models\\Instituicao', 45, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-01-23 07:49:13', '2019-04-05 05:05:38'),
1007(71, 'oliveira.olivia@carrara.com', '$2y$10$6qdjWVhjBNtSnfaZjKqsB.BGSrN8Vl2y1U8jg0px1oQ50VI/zJGgq', 'VoceSolidario\\Models\\Instituicao', 46, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2019-02-04 12:39:39', '2019-04-05 05:05:38'),
1008(72, 'simon.darosa@terra.com.br', '$2y$10$qq.Ws/wHngW.ULh5ZI01eex8yq4RGgJ6Op1dJmHcRvTuI9U1OpLdO', 'VoceSolidario\\Models\\Instituicao', 47, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-02-21 09:46:44', '2019-04-05 05:05:38'),
1009(73, 'goncalves.lucas@yahoo.com', '$2y$10$jRrhrI3FDa7HTjiOheen6uXeQ5ZHJ4jO3gTqBIUbXHHfcLRgS4uqi', 'VoceSolidario\\Models\\Instituicao', 48, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-09-06 22:35:39', '2019-04-05 05:05:38'),
1010(74, 'casanova.fabiana@terra.com.br', '$2y$10$HdW5hKjqPx7z.Gyqkq5G3uVHRJOwn1ReeKN/pX4E4fxVxK0677rwy', 'VoceSolidario\\Models\\Instituicao', 49, 1, 1, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-08-03 16:23:12', '2019-04-05 05:05:38'),
1011(75, 'fsandoval@pena.com.br', '$2y$10$uw3OTVLYoiTVd8FtjGJbxuLXYQdgPjCoiBPdbZUQg.jU4dcYnaofa', 'VoceSolidario\\Models\\Instituicao', 50, 1, 0, 'QHZvY2Vzb2xpZGFyaW86KQ==', NULL, '2018-05-03 02:20:32', '2019-04-05 05:05:38');
1012
1013--
1014-- Restrições para dumps de tabelas
1015--
1016
1017--
1018-- Restrições para tabelas `administrador_instituicao`
1019--
1020ALTER TABLE `administrador_instituicao`
1021  ADD CONSTRAINT `administrador_instituicao_instituicao_id_foreign` FOREIGN KEY (`instituicao_id`) REFERENCES `instituicoes` (`id`) ON DELETE CASCADE;
1022
1023--
1024-- Restrições para tabelas `doacoes`
1025--
1026ALTER TABLE `doacoes`
1027  ADD CONSTRAINT `doacoes_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`),
1028  ADD CONSTRAINT `doacoes_doador_id_foreign` FOREIGN KEY (`doador_id`) REFERENCES `doadores` (`id`);
1029
1030--
1031-- Restrições para tabelas `doacoes_instituicoes`
1032--
1033ALTER TABLE `doacoes_instituicoes`
1034  ADD CONSTRAINT `doacoes_instituicoes_doacao_id_foreign` FOREIGN KEY (`doacao_id`) REFERENCES `doacoes` (`id`),
1035  ADD CONSTRAINT `doacoes_instituicoes_instituicao_id_foreign` FOREIGN KEY (`instituicao_id`) REFERENCES `instituicoes` (`id`);
1036
1037--
1038-- Restrições para tabelas `instituicoes`
1039--
1040ALTER TABLE `instituicoes`
1041  ADD CONSTRAINT `instituicoes_area_atuacao_id_foreign` FOREIGN KEY (`area_atuacao_id`) REFERENCES `area_atuacao` (`id`),
1042  ADD CONSTRAINT `instituicoes_pessoas_atendidas_id_foreign` FOREIGN KEY (`pessoas_atendidas_id`) REFERENCES `pessoas_atendidas` (`id`),
1043  ADD CONSTRAINT `instituicoes_publico_alvo_id_foreign` FOREIGN KEY (`publico_alvo_id`) REFERENCES `publico_alvo` (`id`),
1044  ADD CONSTRAINT `instituicoes_quantidade_projetos_id_foreign` FOREIGN KEY (`quantidade_projetos_id`) REFERENCES `quantidade_projetos` (`id`);
1045
1046--
1047-- Restrições para tabelas `localizacoes`
1048--
1049ALTER TABLE `localizacoes`
1050  ADD CONSTRAINT `localizacoes_instituicao_id_foreign` FOREIGN KEY (`instituicao_id`) REFERENCES `instituicoes` (`id`) ON DELETE CASCADE;
1051
1052--
1053-- Restrições para tabelas `model_has_permissions`
1054--
1055ALTER TABLE `model_has_permissions`
1056  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;
1057
1058--
1059-- Restrições para tabelas `model_has_roles`
1060--
1061ALTER TABLE `model_has_roles`
1062  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
1063
1064--
1065-- Restrições para tabelas `pedidos`
1066--
1067ALTER TABLE `pedidos`
1068  ADD CONSTRAINT `pedidos_instituicao_id_foreign` FOREIGN KEY (`instituicao_id`) REFERENCES `instituicoes` (`id`);
1069
1070--
1071-- Restrições para tabelas `role_has_permissions`
1072--
1073ALTER TABLE `role_has_permissions`
1074  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
1075  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
1076COMMIT;
1077
1078/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1079/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1080/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;