text: -- phpMyAdmin SQL Dump
  -- version 5.0.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: localhost:3306
  -- Tempo de geração: 19-Jul-2021 às 18:28
  -- Versão do servidor: 5.7.24
  -- versão do PHP: 7.4.16
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Banco de dados: `edital`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `editals`
  --
  
  CREATE TABLE `editals` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `user_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `tipo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `path_pdf` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `orgao` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ano` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Extraindo dados da tabela `editals`
  --
  
  INSERT INTO `editals` (`id`, `user_id`, `tipo`, `path_pdf`, `orgao`, `ano`, `created_at`, `updated_at`) VALUES
  (7, '1', 'na', 'pdfs/ppRsngqhJotRpgpT6apoeHyGorpVmtLxORGDkv5C.pdf', 'detran', '2000', '2021-07-16 15:11:36', '2021-07-16 15:11:36'),
  (8, '1', 'np', 'pdfs/hIS6QVUeV57z2Qf9sUcmZmOCXRl6W0NCfJDs5UKb.pdf', 'detran', '2000', '2021-07-16 23:15:35', '2021-07-16 23:15:35'),
  (9, '1', 'na', 'pdfs/7PoVOQIILUV2nURYu7tZ7xXVnxlVsKKL6PZJm2sI.pdf', 'detran', '2000', '2021-07-16 23:18:21', '2021-07-16 23:18:21');
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `failed_jobs`
  --
  
  CREATE TABLE `failed_jobs` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `items`
  --
  
  CREATE TABLE `items` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `id_user` int(11) DEFAULT NULL,
    `descricao` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `condicao` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Extraindo dados da tabela `items`
  --
  
  INSERT INTO `items` (`id`, `id_user`, `descricao`, `condicao`, `name`, `created_at`, `updated_at`) VALUES
  (1, 1, 'Tipos de Notificação', 'na/np/np e na', 'tipo', NULL, '2021-07-16 13:16:49'),
  (2, 1, 'Orgãos', 'detran/serpro', 'orgao', NULL, '2021-07-16 13:19:23');
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Extraindo dados da tabela `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2014_10_12_000000_create_users_table', 1),
  (2, '2014_10_12_100000_create_password_resets_table', 1),
  (3, '2019_08_19_000000_create_failed_jobs_table', 1),
  (4, '2021_07_14_103920_create_permission_tables', 1),
  (5, '2021_07_14_182502_create_editals_table', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `model_has_permissions`
  --
  
  CREATE TABLE `model_has_permissions` (
    `permission_id` bigint(20) UNSIGNED NOT NULL,
    `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `model_id` bigint(20) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Extraindo dados da tabela `model_has_permissions`
  --
  
  INSERT INTO `model_has_permissions` (`permission_id`, `model_type`, `model_id`) VALUES
  (5, 'App\\Models\\User', 1),
  (1, 'App\\Models\\User', 2),
  (5, 'App\\Models\\User', 3),
  (5, 'App\\Models\\User', 4),
  (4, 'App\\Models\\User', 6),
  (1, 'App\\Models\\User', 7),
  (1, 'App\\Models\\User', 13),
  (1, 'App\\Models\\User', 14);
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `model_has_roles`
  --
  
  CREATE TABLE `model_has_roles` (
    `role_id` bigint(20) UNSIGNED NOT NULL,
    `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `model_id` bigint(20) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `permissions`
  --
  
  CREATE TABLE `permissions` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Extraindo dados da tabela `permissions`
  --
  
  INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
  (1, 'admin', 'web', '2021-07-14 13:49:03', '2021-07-14 13:49:03'),
  (2, 'gerente', 'web', '2021-07-14 13:49:11', '2021-07-14 13:49:11'),
  (3, 'inspetor', 'web', '2021-07-14 13:49:17', '2021-07-14 13:49:17'),
  (4, 'chefe', 'web', '2021-07-14 13:49:26', '2021-07-14 13:49:26'),
  (5, 'user', 'web', '2021-07-14 13:49:35', '2021-07-14 13:49:35');
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `roles`
  --
  
  CREATE TABLE `roles` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `role_has_permissions`
  --
  
  CREATE TABLE `role_has_permissions` (
    `permission_id` bigint(20) UNSIGNED NOT NULL,
    `role_id` bigint(20) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Estrutura da tabela `users`
  --
  
  CREATE TABLE `users` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Extraindo dados da tabela `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'josenildo tiago', 'josenildo.tiago.designer@gmail.com', NULL, '$2y$10$Ryrc6Jf99HaPxiTdR9a7v.FrlFaYueBWCLE7mVk9ntbeG9it0AQc.', NULL, '2021-07-14 13:50:09', '2021-07-14 13:50:09'),
  (2, 'josenildo admin', 'josenildo.tiago@hotmail.com', NULL, '$2y$10$AEsOqp4t.5qVbM5aBQGmtumnzhrjdL5cnX8cqTCrqJo5dbaLY8Wve', NULL, '2021-07-14 14:16:06', '2021-07-14 14:16:06'),
  (3, 'josenildo tiago', 'josenildo.tiago.designer2@gmail.com', NULL, '$2y$10$ftsN0i9T3JoV3Bh2lMdyBONP08tFvs.lzNAkyKkzAD6WgF4i69aFe', NULL, '2021-07-18 14:16:30', '2021-07-18 14:16:30'),
  (4, 'joka tibeu', 'joka@gmail.com', NULL, '$2y$10$tdjNPBJ7T2Y6LJG2HsF9F.PqmSbsTaAyZguXP/6sa0TnLhrte1aPi', NULL, '2021-07-18 14:22:42', '2021-07-18 14:22:42'),
  (6, 'josenildo tiago da silva', 'josenildo.tiago2@hotmail.com', NULL, '$2y$10$OKxSeJNqaXSj79MjgCCNB.6R.qkLioYqAELKZmZ4ZwSD.M/M2i.xK', NULL, '2021-07-18 14:27:54', '2021-07-18 14:27:54'),
  (7, 'josenildo tiago', 'admin@admin.com', NULL, '$2y$10$W9ftzq0XkI8kytUNdP34EOtRaB/3JIIEJ0h3P9AdqPtgbNhLgjMgS', NULL, '2021-07-18 14:31:51', '2021-07-18 14:31:51'),
  (13, 'josenildo tiago', 'matheus@gmail.com', NULL, '$2y$10$IYRExQ7GgFJPLP5ctOOZSeibD13MxqhH09qaKIYD4uXNih3YMdgWq', NULL, '2021-07-18 15:01:53', '2021-07-18 15:01:53'),
  (14, 'drica morais', 'josenildo.tiago.designer3@gmail.com', NULL, '$2y$10$/M.2vVn5ZoAJJbPweCa6ke7FuFrRqM8gmsOA.g0VNQPvBQ/Y2ViIq', NULL, '2021-07-18 15:16:23', '2021-07-18 15:16:23');
  
  --
  -- Índices para tabelas despejadas
  --
  
  --
  -- Índices para tabela `editals`
  --
  ALTER TABLE `editals`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices para tabela `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
  
  --
  -- Índices para tabela `items`
  --
  ALTER TABLE `items`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices para tabela `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Índices para tabela `model_has_permissions`
  --
  ALTER TABLE `model_has_permissions`
    ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
    ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);
  
  --
  -- Índices para tabela `model_has_roles`
  --
  ALTER TABLE `model_has_roles`
    ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
    ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);
  
  --
  -- Índices para tabela `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Índices para tabela `permissions`
  --
  ALTER TABLE `permissions`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);
  
  --
  -- Índices para tabela `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);
  
  --
  -- Índices para tabela `role_has_permissions`
  --
  ALTER TABLE `role_has_permissions`
    ADD PRIMARY KEY (`permission_id`,`role_id`),
    ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);
  
  --
  -- Índices para tabela `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT de tabelas despejadas
  --
  
  --
  -- AUTO_INCREMENT de tabela `editals`
  --
  ALTER TABLE `editals`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT de tabela `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de tabela `items`
  --
  ALTER TABLE `items`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT de tabela `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT de tabela `permissions`
  --
  ALTER TABLE `permissions`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT de tabela `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT de tabela `users`
  --
  ALTER TABLE `users`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
  
  --
  -- Restrições para despejos de tabelas
  --
  
  --
  -- Limitadores para a tabela `model_has_permissions`
  --
  ALTER TABLE `model_has_permissions`
    ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;
  
  --
  -- Limitadores para a tabela `model_has_roles`
  --
  ALTER TABLE `model_has_roles`
    ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
  
  --
  -- Limitadores para a tabela `role_has_permissions`
  --
  ALTER TABLE `role_has_permissions`
    ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  