
        -- phpMyAdmin SQL Dump
        -- version 4.9.11
        -- https://www.phpmyadmin.net/
        --
        -- Host: localhost:3306
        -- Tempo de geração: 06-Mar-2023 às 22:04
        -- Versão do servidor: 8.0.32
        -- versão do PHP: 7.4.33
        
        SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
        SET AUTOCOMMIT = 0;
        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 */;
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `ad_settings`
        --
        
        CREATE TABLE `ad_settings` (
          `id` bigint UNSIGNED NOT NULL,
          `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `banner_ad_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `banner_ad_is_enable` tinyint(1) NOT NULL DEFAULT '0',
          `interstitial_ad_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `interstitial_ad_is_enable` tinyint(1) NOT NULL DEFAULT '0',
          `created_at` timestamp NULL DEFAULT NULL,
          `updated_at` timestamp NULL DEFAULT NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `background_images`
        --
        
        CREATE TABLE `background_images` (
          `id` bigint UNSIGNED NOT NULL,
          `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `image` varchar(255) CHARACTER SET utf8mb4 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 `background_images`
        --
        
        INSERT INTO `background_images` (`id`, `title`, `image`, `created_at`, `updated_at`) VALUES
        (1, 'Logo', '2022-12-26-05-50-38-85193-1.png', '2021-12-15 08:51:33', '2022-12-26 20:50:38');
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `failed_jobs`
        --
        
        CREATE TABLE `failed_jobs` (
          `id` bigint UNSIGNED NOT NULL,
          `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
          `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
          `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
          `exception` longtext CHARACTER SET utf8mb4 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 `feedback`
        --
        
        CREATE TABLE `feedback` (
          `id` bigint UNSIGNED NOT NULL,
          `feedback_type_id` int NOT NULL DEFAULT '0',
          `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
          `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
          `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 `feedback`
        --
        
        INSERT INTO `feedback` (`id`, `feedback_type_id`, `email`, `title`, `description`, `images`, `created_at`, `updated_at`) VALUES
        (21, 0, 'eduardo.jorgep@hotmail.com', 'Eduardo', 'o melhor e mais original cultural. abidoral', NULL, '2022-12-29 04:15:27', '2022-12-29 04:15:27'),
        (22, 0, 'eduardo.jorgep@hotmail.com', 'Eduardo', 'poxa bicho que massa', NULL, '2022-12-29 04:16:56', '2022-12-29 04:16:56'),
        (23, 0, 'claudio_cavalcante2012@hotmail.com', 'Cláudio Cavalcante', 'Sabiá - Luiz Gonzaga', NULL, '2022-12-29 04:39:28', '2022-12-29 04:39:28'),
        (24, 0, 'janunciodecustodia@gmail.com', 'Januncio de Custódia', 'Prá Dançar Forr Jó', NULL, '2023-01-03 15:02:28', '2023-01-03 15:02:28'),
        (25, 0, 'gracas.sfm@gmail.com', 'Maria das Graças Souza Ferreira', 'Tô ligada no programa do veio Abdoral . Muito bom músicas,  lorotas contos e poesias. gosto muito. Peço música de Jorge de Altinho. beijão pra vcs.', NULL, '2023-01-19 00:25:17', '2023-01-19 00:25:17');
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `livetvs`
        --
        
        CREATE TABLE `livetvs` (
          `id` bigint UNSIGNED NOT NULL,
          `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `genres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `streaming_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
          `created_at` timestamp NULL DEFAULT NULL,
          `updated_at` timestamp NULL DEFAULT NULL,
          `status` tinyint(1) NOT NULL DEFAULT '1'
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        
        --
        -- Extraindo dados da tabela `livetvs`
        --
        
        INSERT INTO `livetvs` (`id`, `country`, `genres`, `language`, `name`, `image`, `streaming_link`, `description`, `created_at`, `updated_at`, `status`) VALUES
        (1, 'BELÉM', NULL, 'Português', 'TVONEBELÉM', '2022-11-06-05-18-12-25289-1.png', 'https://video02.logicahost.com.br/tvone/tvone/playlist.m3u8', 'A sua Tv n. 1! Esporte , jornalismo, entretenimento, cultura!', '2021-12-15 08:55:11', '2022-12-26 20:41:21', 0);
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `migrations`
        --
        
        CREATE TABLE `migrations` (
          `id` int UNSIGNED NOT NULL,
          `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
          `batch` int 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, '2019_08_19_000000_create_failed_jobs_table', 1),
        (3, '2020_08_20_080141_create_admins_table', 1),
        (4, '2020_08_23_101548_create_notifications_table', 1),
        (5, '2020_09_09_054944_create_feedback_table', 1),
        (6, '2020_09_09_060426_create_streaming_issue_reports_table', 1),
        (7, '2020_09_19_060712_create_radios_table', 1),
        (8, '2021_02_17_060013_create_ad_settings_table', 1),
        (9, '2021_02_17_060013_create_social_links_table', 1),
        (10, '2021_07_12_072121_create_livetvs_table', 1),
        (11, '2021_12_14_191336_create_privacy_policies_table', 1),
        (12, '2021_12_15_050454_create_background_images_table', 1),
        (13, '2021_12_23_052437_add_status_to_livetvs_table', 2),
        (14, '2022_01_22_133731_add_status_to_radios_table', 3),
        (15, '2022_01_22_140004_add_websitelink_youtube_to_social_links_table', 3),
        (16, '2022_01_23_125035_add_websitelink_status_to_social_links_table', 4);
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `notifications`
        --
        
        CREATE TABLE `notifications` (
          `id` bigint UNSIGNED NOT NULL,
          `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
          `image` varchar(255) CHARACTER SET utf8mb4 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;
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `privacy_policies`
        --
        
        CREATE TABLE `privacy_policies` (
          `id` bigint UNSIGNED NOT NULL,
          `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
          `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 `privacy_policies`
        --
        
        INSERT INTO `privacy_policies` (`id`, `text`, `created_at`, `updated_at`) VALUES
        (1, 'TESTE', '2022-01-28 17:43:59', '2022-04-19 15:37:21');
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `radios`
        --
        
        CREATE TABLE `radios` (
          `id` bigint UNSIGNED NOT NULL,
          `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `genres` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `streaming_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
          `created_at` timestamp NULL DEFAULT NULL,
          `updated_at` timestamp NULL DEFAULT NULL,
          `status` tinyint(1) NOT NULL DEFAULT '1'
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        
        --
        -- Extraindo dados da tabela `radios`
        --
        
        INSERT INTO `radios` (`id`, `country`, `genres`, `language`, `name`, `image`, `streaming_link`, `description`, `created_at`, `updated_at`, `status`) VALUES
        (1, 'Brasil', 'Forro', 'Portugues', 'Forró do Abidoral', '2022-12-26-05-42-16-83967-1.png', 'https://live9.livemus.com.br:27140', 'Muito forró, humor poesia e alegria', '2021-12-15 08:56:41', '2022-12-27 16:11:15', 1);
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `social_links`
        --
        
        CREATE TABLE `social_links` (
          `id` bigint UNSIGNED NOT NULL,
          `instagram` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `facebook` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `twitter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `whatsapp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `created_at` timestamp NULL DEFAULT NULL,
          `updated_at` timestamp NULL DEFAULT NULL,
          `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `youtube` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
          `website_status` tinyint(1) NOT NULL DEFAULT '1',
          `feedback_status` tinyint(1) NOT NULL DEFAULT '1'
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        
        --
        -- Extraindo dados da tabela `social_links`
        --
        
        INSERT INTO `social_links` (`id`, `instagram`, `facebook`, `twitter`, `whatsapp`, `created_at`, `updated_at`, `website`, `youtube`, `website_status`, `feedback_status`) VALUES
        (1, 'abidoraloficial', 'https://www.facebook.com/VAbidoral', NULL, '+5581999687283', '2022-01-24 16:24:43', '2022-12-26 20:46:12', 'https://www.facebook.com/VAbidoral', 'https://youtube.com/@Abidoral', 1, 1);
        
        -- --------------------------------------------------------
        
        --
        -- Estrutura da tabela `streaming_issue_reports`
        --
        
        CREATE TABLE `streaming_issue_reports` (
          `id` bigint UNSIGNED NOT NULL,
          `livetv_id` int NOT NULL DEFAULT '0',
          `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
          `created_at` timestamp NULL DEFAULT NULL,
          `updated_at` timestamp NULL DEFAULT NULL
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
        
        --
        -- Índices para tabela `ad_settings`
        --
        ALTER TABLE `ad_settings`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `background_images`
        --
        ALTER TABLE `background_images`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `failed_jobs`
        --
        ALTER TABLE `failed_jobs`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `feedback`
        --
        ALTER TABLE `feedback`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `livetvs`
        --
        ALTER TABLE `livetvs`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `migrations`
        --
        ALTER TABLE `migrations`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `notifications`
        --
        ALTER TABLE `notifications`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `privacy_policies`
        --
        ALTER TABLE `privacy_policies`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `radios`
        --
        ALTER TABLE `radios`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `social_links`
        --
        ALTER TABLE `social_links`
          ADD PRIMARY KEY (`id`);
        
        --
        -- Índices para tabela `streaming_issue_reports`
        --
        ALTER TABLE `streaming_issue_reports`
          ADD PRIMARY KEY (`id`);
        
        --
        -- AUTO_INCREMENT de tabela `ad_settings`
        --
        ALTER TABLE `ad_settings`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
        
        --
        -- AUTO_INCREMENT de tabela `background_images`
        --
        ALTER TABLE `background_images`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
        
        --
        -- AUTO_INCREMENT de tabela `failed_jobs`
        --
        ALTER TABLE `failed_jobs`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
        
        --
        -- AUTO_INCREMENT de tabela `feedback`
        --
        ALTER TABLE `feedback`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
        
        --
        -- AUTO_INCREMENT de tabela `livetvs`
        --
        ALTER TABLE `livetvs`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
        
        --
        -- AUTO_INCREMENT de tabela `migrations`
        --
        ALTER TABLE `migrations`
          MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
        
        --
        -- AUTO_INCREMENT de tabela `notifications`
        --
        ALTER TABLE `notifications`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
        
        --
        -- AUTO_INCREMENT de tabela `privacy_policies`
        --
        ALTER TABLE `privacy_policies`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
        
        --
        -- AUTO_INCREMENT de tabela `radios`
        --
        ALTER TABLE `radios`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
        
        --
        -- AUTO_INCREMENT de tabela `social_links`
        --
        ALTER TABLE `social_links`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
        
        --
        -- AUTO_INCREMENT de tabela `streaming_issue_reports`
        --
        ALTER TABLE `streaming_issue_reports`
          MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
        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 */;