-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `play`
--

-- --------------------------------------------------------

--
-- Table structure for table `embeds`
--

CREATE TABLE `embeds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` text 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;

--
-- Dumping data for table `embeds`
--

INSERT INTO `embeds` (`id`, `code`, `created_at`, `updated_at`) VALUES
(1, '<iframe width=\"1070\" height=\"602\" src=\"https://www.youtube.com/embed/vb2swlxZjSg\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen></iframe>', '2020-05-18 06:52:10', '2020-05-18 06:52:10');

-- --------------------------------------------------------

--
-- Table structure for table `episodes`
--

CREATE TABLE `episodes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tmdb_id` int(10) UNSIGNED DEFAULT NULL,
  `season_id` bigint(20) UNSIGNED NOT NULL,
  `episode_number` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `overview` text COLLATE utf8mb4_unicode_ci,
  `still_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vote_average` double(8,2) UNSIGNED DEFAULT NULL,
  `vote_count` double(8,2) UNSIGNED DEFAULT NULL,
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `air_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `genres`
--

CREATE TABLE `genres` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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;

--
-- Dumping data for table `genres`
--

INSERT INTO `genres` (`id`, `name`, `created_at`, `updated_at`) VALUES
(12, 'Aventura', '2020-05-18 06:39:28', '2020-05-18 06:39:28'),
(14, 'Fantasia', '2020-05-18 06:40:14', '2020-05-18 06:40:14'),
(16, 'Animação', '2020-05-18 06:40:57', '2020-05-18 06:40:57'),
(18, 'Drama', '2020-05-18 06:39:01', '2020-05-18 06:39:01'),
(28, 'Ação', '2020-05-18 06:39:28', '2020-05-18 06:39:28'),
(35, 'Comedy', '2020-05-18 06:37:44', '2020-05-18 06:37:44'),
(53, 'Thriller', '2020-05-18 06:39:01', '2020-05-18 06:39:01'),
(80, 'Crime', '2020-05-18 06:40:40', '2020-05-18 06:40:40'),
(878, 'Ficção científica', '2020-05-18 06:39:28', '2020-05-18 06:39:28'),
(10749, 'Romance', '2020-05-18 06:37:44', '2020-05-18 06:37:44'),
(10751, 'Família', '2020-05-18 06:40:14', '2020-05-18 06:40:14');

-- --------------------------------------------------------

--
-- Table structure for table `livetvs`
--

CREATE TABLE `livetvs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `overview` text COLLATE utf8mb4_unicode_ci,
  `poster_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backdrop_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `views` int(10) UNSIGNED 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;

--
-- Dumping data for table `livetvs`
--

INSERT INTO `livetvs` (`id`, `name`, `overview`, `poster_path`, `backdrop_path`, `link`, `status`, `views`, `created_at`, `updated_at`) VALUES
(1, 'SBT', 'Sistema brasileiro de televizao', 'http://127.0.0.1/arrebenta-play/public/api/livetv/image/o2bYhYoS7Y4jOB4dFA54rahXpqkXVroDU55AcN55.jpeg', 'http://127.0.0.1/arrebenta-play/public/api/livetv/image/y79PL7x30FDOYZR9HRmumZjkoQM62ZkonHX4EGeC.jpeg', 'https://www.youtube.com/watch?v=vb2swlxZjSg', 1, 0, '2020-05-18 06:50:38', '2020-05-18 06:50:38');

-- --------------------------------------------------------

--
-- Table structure for table `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;

--
-- Dumping data for table `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_06_29_210234_create_movies_table', 1),
(4, '2019_06_29_210235_create_genres_table', 1),
(5, '2019_06_29_210255_create_movie_videos_table', 1),
(6, '2019_06_29_210310_create_movie_genres_table', 1),
(7, '2019_07_15_224942_create_servers_table', 1),
(8, '2019_07_21_001804_create_series_table', 1),
(9, '2019_07_21_001913_create_seasons_table', 1),
(10, '2019_07_21_001927_create_episodes_table', 1),
(11, '2019_07_21_002012_create_serie_genres_table', 1),
(12, '2019_07_23_085704_create_serie_videos_table', 1),
(13, '2019_07_28_232727_create_livetvs_table', 1),
(14, '2019_08_08_210737_create_settings_table', 1),
(15, '2019_08_25_142122_create_embeds_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `movies`
--

CREATE TABLE `movies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tmdb_id` int(10) UNSIGNED DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `overview` text COLLATE utf8mb4_unicode_ci,
  `poster_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backdrop_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preview_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vote_average` double(8,2) UNSIGNED DEFAULT NULL,
  `vote_count` double(8,2) UNSIGNED DEFAULT NULL,
  `popularity` double(8,2) UNSIGNED DEFAULT NULL,
  `views` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `release_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `movies`
--

INSERT INTO `movies` (`id`, `tmdb_id`, `title`, `overview`, `poster_path`, `backdrop_path`, `preview_path`, `vote_average`, `vote_count`, `popularity`, `views`, `status`, `release_date`, `created_at`, `updated_at`) VALUES
(1, 582596, 'The Wrong Missy', 'A guy meets the woman of his dreams and invites her to his company\'s corporate retreat, but realizes he sent the invite to the wrong person.', 'https://image.tmdb.org/t/p/w500/A2YlIrzypvhS3vTFMcDkG3xLvac.jpg', 'https://image.tmdb.org/t/p/w780/1xQtvgay8rDwSaZPwyhcecqV8UD.jpg', 'https://www.youtube.com/embed/2Cwaneq2w-4', 6.20, 133.00, 122.50, 0, 1, '2020-05-13', '2020-05-18 06:37:44', '2020-05-18 06:37:44'),
(2, 466272, 'Era Uma Vez em… Hollywood', 'Los Angeles (EUA). O ano é 1969. Rick Dalton é um actor de “westerns” televisivos que, juntamente com o seu duplo e amigo de longa data Cliff Booth, chega a Hollywood determinado a reavivar a sua carreira. Ali, os seus destinos vão cruzar-se com personagens que marcaram uma época. Entre elas está a jovem Sharon Tate, na altura grávida do cineasta Roman Polanski; e Charles Manson, cujos crimes cometidos por si e pelos seus seguidores chocaram o mundo, mudaram costumes e deram o mote ao fim do movimento “hippie”.', 'https://image.tmdb.org/t/p/w500/gMEKjlq4JcLR93oAVSD47MSeO9h.jpg', 'https://image.tmdb.org/t/p/w780/vm8C7lAob4hSn8MvHGa9RBLy7rR.jpg', 'https://www.youtube.com/embed/9hFRGyDUD04', 7.50, 6310.00, 63.81, 0, 1, '2019-07-25', '2020-05-18 06:39:01', '2020-05-18 06:39:01'),
(3, 299536, 'Vingadores: Guerra do Infinito', 'Após 10 anos de uma viagem cinematográfica sem precedentes e que abrange todo o universo cinematográfico Marvel, \"Vingadores: Guerra do Infinito\" traz ao grande ecrã o maior confronto de todos os tempos. Os Vingadores e os seus aliados Super-Heróis devem estar dispostos a sacrificar tudo para tentarem derrotar o poderoso Thanos antes que o seu ataque de devastação e ruína acabe com o universo.', 'https://image.tmdb.org/t/p/w500/89QTZmn34iwXYeCpVxhC9UrT8sX.jpg', 'https://image.tmdb.org/t/p/w780/lmZFxXgJE3vgrciwuDib0N8CfQo.jpg', 'https://www.youtube.com/embed/EQLRgEp6JUo', 8.30, 18123.00, 87.87, 4, 1, '2018-04-25', '2020-05-18 06:39:28', '2020-05-23 05:22:15'),
(4, 294050, 'O Garoto de Ouro', 'Mats é apenas um garoto comum como qualquer outro. Mas quando encontra uma calça que contêm uma quantidade ilimitada de dinheiro, tudo muda! De repente, o mundo está a seus pés e ele pode realizar todos os seus sonhos. No entanto, ele percebe que tinha abusado do poder que vem com riqueza e passa a usar o dinheiro para melhorar a vida dos sem-teto da cidade, e dos menos afortunados. Enquanto isso, forças poderosas da cidade estão procurando pela calça e a chance de encontrar é sequestrar o pai de Mats. Os problemas não param por ai e Mats descobre que o dinheiro que sai dos bolsos da calça, na verdade, vem de vários cofres bancários em todo o país. Agora, além do pai sequestrado ele tem também a polícia atrás dele. Sem ninguém para ajudá-lo além de seus amigos de confiança, David e Livlí, ele tem que salvar seu pai e colocar tudo nos eixos, antes que seja tarde demais.', 'https://image.tmdb.org/t/p/w500/tbcNJAsBXZqgRQ6xnMMSyFz76ob.jpg', 'https://image.tmdb.org/t/p/w780/xNV4e1Xx9k9YbZ9zjPJQZU9pjBu.jpg', NULL, 6.70, 12.00, 3.29, 0, 1, '2014-09-26', '2020-05-18 06:40:14', '2020-05-18 06:40:14'),
(5, 332349, 'De Boskampi\'s', NULL, 'https://image.tmdb.org/t/p/w500/gs60oRyetJStIlIECaWNvC2g3SN.jpg', 'https://image.tmdb.org/t/p/w780/5e1J5ujqAmsTb3dbGR9wtfgtS54.jpg', NULL, 7.50, 11.00, 3.32, 0, 1, '2015-04-29', '2020-05-18 06:40:40', '2020-05-18 06:40:40'),
(6, 239523, '劇場版 HUNTER×HUNTER -The LAST MISSION-', NULL, 'https://image.tmdb.org/t/p/w500/qfjGtlrMynBlkcLgNeziDTmm1M4.jpg', 'https://image.tmdb.org/t/p/w780/2zFHwJ4sLEW4EHdwRaeaBzMQ3oX.jpg', NULL, 6.60, 64.00, 7.44, 0, 1, '2013-12-27', '2020-05-18 06:40:57', '2020-05-18 06:40:57'),
(7, 495764, 'Birds of Prey (E a Fantabulástica Emancipação de uma Harley Quinn)', 'Harley Quinn decide lutar pela sua emancipação e separa-se de Joker. Uma notícia que agrada a muitos que querem contar com a sua ajuda para outros planos perigosos. Mas, Harley junta-se aos super-heróis Black Canary, Huntress e Renee Montoya para salvar uma jovem.', 'https://image.tmdb.org/t/p/w500/A50Ngq9lh9aCTGHC6kttrppHNoF.jpg', 'https://image.tmdb.org/t/p/w780/9xNOiv6DZZjH7ABoUUDP0ZynouU.jpg', 'https://www.youtube.com/embed/mHzkZ3FNyG8', 7.20, 3887.00, 119.97, 0, 1, '2020-02-05', '2020-05-18 06:41:50', '2020-05-18 06:41:50'),
(8, 618344, 'Liga da Justiça Sombria: Guerra de Apokolips', 'A conclusão de uma jornada, iniciada em Liga da Justiça: Guerra, de 2014, \"Liga da Justiça Sombria: Guerra de Apokolips\" lida agora com uma Terra dizimada após uma invasão do imperador de Apokolips, Darkseid, que derrota toda a Liga da Justiça após uma tentativa de ataque mal-sucedido dos maiores heróis da DC. Agora, os sobreviventes restantes da Liga da Justiça, Jovens Titãs, Esquadrão Suicida e outros heróis e vilões precisam se unir, montar uma estratégia e levar a guerra a Darkseid, em um levante final para salvar o planeta e seus habitantes. Essa é a guerra para acabar com todas as guerras, e só os vitoriosos poderão viver para aproveitar os espólios.', 'https://image.tmdb.org/t/p/w500/7bpiarodm3A9wTkRcMesMYNxIJJ.jpg', 'https://image.tmdb.org/t/p/w780/sQkRiQo3nLrQYMXZodDjNUJKHZV.jpg', 'https://www.youtube.com/embed/tnCkn5xD2jg', 8.60, 375.00, 142.78, 0, 1, '2020-05-05', '2020-05-18 06:42:02', '2020-05-18 06:42:02');

-- --------------------------------------------------------

--
-- Table structure for table `movie_genres`
--

CREATE TABLE `movie_genres` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `movie_id` bigint(20) UNSIGNED NOT NULL,
  `genre_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `movie_genres`
--

INSERT INTO `movie_genres` (`id`, `movie_id`, `genre_id`, `created_at`, `updated_at`) VALUES
(1, 1, 35, '2020-05-18 06:37:44', '2020-05-18 06:37:44'),
(2, 1, 10749, '2020-05-18 06:37:44', '2020-05-18 06:37:44'),
(3, 2, 35, '2020-05-18 06:39:01', '2020-05-18 06:39:01'),
(4, 2, 18, '2020-05-18 06:39:01', '2020-05-18 06:39:01'),
(5, 2, 53, '2020-05-18 06:39:01', '2020-05-18 06:39:01'),
(6, 3, 12, '2020-05-18 06:39:28', '2020-05-18 06:39:28'),
(7, 3, 28, '2020-05-18 06:39:28', '2020-05-18 06:39:28'),
(8, 3, 878, '2020-05-18 06:39:28', '2020-05-18 06:39:28'),
(9, 4, 14, '2020-05-18 06:40:14', '2020-05-18 06:40:14'),
(10, 4, 12, '2020-05-18 06:40:14', '2020-05-18 06:40:14'),
(11, 4, 10751, '2020-05-18 06:40:14', '2020-05-18 06:40:14'),
(12, 5, 35, '2020-05-18 06:40:40', '2020-05-18 06:40:40'),
(13, 5, 80, '2020-05-18 06:40:40', '2020-05-18 06:40:40'),
(14, 5, 12, '2020-05-18 06:40:40', '2020-05-18 06:40:40'),
(15, 5, 10751, '2020-05-18 06:40:40', '2020-05-18 06:40:40'),
(16, 6, 12, '2020-05-18 06:40:57', '2020-05-18 06:40:57'),
(17, 6, 16, '2020-05-18 06:40:57', '2020-05-18 06:40:57'),
(18, 6, 28, '2020-05-18 06:40:57', '2020-05-18 06:40:57'),
(19, 7, 28, '2020-05-18 06:41:50', '2020-05-18 06:41:50'),
(20, 7, 80, '2020-05-18 06:41:50', '2020-05-18 06:41:50'),
(21, 7, 35, '2020-05-18 06:41:50', '2020-05-18 06:41:50'),
(22, 8, 16, '2020-05-18 06:42:02', '2020-05-18 06:42:02'),
(23, 8, 28, '2020-05-18 06:42:02', '2020-05-18 06:42:02'),
(24, 8, 14, '2020-05-18 06:42:02', '2020-05-18 06:42:02'),
(25, 8, 878, '2020-05-18 06:42:02', '2020-05-18 06:42:02'),
(26, 8, 12, '2020-05-18 06:42:02', '2020-05-18 06:42:02');

-- --------------------------------------------------------

--
-- Table structure for table `movie_videos`
--

CREATE TABLE `movie_videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `movie_id` bigint(20) UNSIGNED NOT NULL,
  `server` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hd` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `movie_videos`
--

INSERT INTO `movie_videos` (`id`, `movie_id`, `server`, `link`, `lang`, `hd`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 'Local', 'http://19.16.0.249/arrebenta-play/filmes/Vingadores.Ultimato.2019.720p.BluRay.x264.DUAL-WWW.BLUDV.TV.mkv', 'pt', 1, 1, '2020-05-23 05:03:14', '2020-05-23 05:03:14');

-- --------------------------------------------------------

--
-- Table structure for table `seasons`
--

CREATE TABLE `seasons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tmdb_id` int(10) UNSIGNED DEFAULT NULL,
  `serie_id` bigint(20) UNSIGNED NOT NULL,
  `season_number` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `overview` text COLLATE utf8mb4_unicode_ci,
  `poster_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `air_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `series`
--

CREATE TABLE `series` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tmdb_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `overview` text COLLATE utf8mb4_unicode_ci,
  `poster_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `backdrop_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `preview_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vote_average` double(8,2) UNSIGNED DEFAULT NULL,
  `vote_count` double(8,2) UNSIGNED DEFAULT NULL,
  `popularity` double(8,2) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `first_air_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `serie_genres`
--

CREATE TABLE `serie_genres` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `serie_id` bigint(20) UNSIGNED NOT NULL,
  `genre_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `serie_videos`
--

CREATE TABLE `serie_videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `episode_id` bigint(20) UNSIGNED NOT NULL,
  `server` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lang` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hd` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `servers`
--

INSERT INTO `servers` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Local', 1, '2020-05-23 05:02:36', '2020-05-23 05:02:36'),
(2, 'Remoto', 1, '2020-05-23 05:02:43', '2020-05-23 05:02:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `embeds`
--
ALTER TABLE `embeds`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `episodes`
--
ALTER TABLE `episodes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `episodes_tmdb_id_unique` (`tmdb_id`),
  ADD KEY `episodes_season_id_foreign` (`season_id`);

--
-- Indexes for table `genres`
--
ALTER TABLE `genres`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `livetvs`
--
ALTER TABLE `livetvs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `movies`
--
ALTER TABLE `movies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `movies_tmdb_id_unique` (`tmdb_id`);

--
-- Indexes for table `movie_genres`
--
ALTER TABLE `movie_genres`
  ADD PRIMARY KEY (`id`),
  ADD KEY `movie_genres_movie_id_foreign` (`movie_id`),
  ADD KEY `movie_genres_genre_id_foreign` (`genre_id`);

--
-- Indexes for table `movie_videos`
--
ALTER TABLE `movie_videos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `movie_videos_movie_id_foreign` (`movie_id`);

--
-- Indexes for table `seasons`
--
ALTER TABLE `seasons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `seasons_tmdb_id_unique` (`tmdb_id`),
  ADD KEY `seasons_serie_id_foreign` (`serie_id`);

--
-- Indexes for table `series`
--
ALTER TABLE `series`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `series_tmdb_id_unique` (`tmdb_id`);

--
-- Indexes for table `serie_genres`
--
ALTER TABLE `serie_genres`
  ADD PRIMARY KEY (`id`),
  ADD KEY `serie_genres_serie_id_foreign` (`serie_id`),
  ADD KEY `serie_genres_genre_id_foreign` (`genre_id`);

--
-- Indexes for table `serie_videos`
--
ALTER TABLE `serie_videos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `serie_videos_episode_id_foreign` (`episode_id`);

--
-- Indexes for table `servers`
--
ALTER TABLE `servers`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `embeds`
--
ALTER TABLE `embeds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `episodes`
--
ALTER TABLE `episodes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `genres`
--
ALTER TABLE `genres`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10752;

--
-- AUTO_INCREMENT for table `livetvs`
--
ALTER TABLE `livetvs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `movies`
--
ALTER TABLE `movies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `movie_genres`
--
ALTER TABLE `movie_genres`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `movie_videos`
--
ALTER TABLE `movie_videos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `seasons`
--
ALTER TABLE `seasons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `series`
--
ALTER TABLE `series`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `serie_genres`
--
ALTER TABLE `serie_genres`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `serie_videos`
--
ALTER TABLE `serie_videos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `servers`
--
ALTER TABLE `servers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `episodes`
--
ALTER TABLE `episodes`
  ADD CONSTRAINT `episodes_season_id_foreign` FOREIGN KEY (`season_id`) REFERENCES `seasons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `movie_genres`
--
ALTER TABLE `movie_genres`
  ADD CONSTRAINT `movie_genres_genre_id_foreign` FOREIGN KEY (`genre_id`) REFERENCES `genres` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `movie_genres_movie_id_foreign` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `movie_videos`
--
ALTER TABLE `movie_videos`
  ADD CONSTRAINT `movie_videos_movie_id_foreign` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `seasons`
--
ALTER TABLE `seasons`
  ADD CONSTRAINT `seasons_serie_id_foreign` FOREIGN KEY (`serie_id`) REFERENCES `series` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `serie_genres`
--
ALTER TABLE `serie_genres`
  ADD CONSTRAINT `serie_genres_genre_id_foreign` FOREIGN KEY (`genre_id`) REFERENCES `genres` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `serie_genres_serie_id_foreign` FOREIGN KEY (`serie_id`) REFERENCES `series` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `serie_videos`
--
ALTER TABLE `serie_videos`
  ADD CONSTRAINT `serie_videos_episode_id_foreign` FOREIGN KEY (`episode_id`) REFERENCES `episodes` (`id`) ON DELETE CASCADE;
COMMIT;


