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

START TRANSACTION;



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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_image` varchar(255) 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 `categories`
--

INSERT INTO `categories` (`id`, `category_name`, `category_image`, `created_at`, `updated_at`) VALUES
(10, 'Songs', '1693894098.jpg', '2022-09-19 08:40:11', '2023-09-05 00:08:18'),
(11, 'News', '1693894114.png', '2023-09-05 00:08:34', '2023-09-05 00:08:34'),
(12, 'Comedy', '1693894133.jpg', '2023-09-05 00:08:53', '2023-09-05 00:08:53');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `flag` varchar(255) 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 `countries`
--

INSERT INTO `countries` (`id`, `name`, `flag`, `created_at`, `updated_at`) VALUES
(1, 'Germany', 'd2b4bcdf39474522e6214d93bc9b4a2b.jpg_1693894188.jpg', '2023-09-05 00:09:48', '2023-09-05 00:09:48'),
(2, 'Brazil', '15fcad522bb0817c4837026f1b118b72.jpg_1693894202.jpg', '2023-09-05 00:10:02', '2023-09-05 00:10:02'),
(3, 'Franch', '677a814bdb60fdcd815e3d97953a8a01.jpg_1693894222.jpg', '2023-09-05 00:10:22', '2023-09-05 00:10:22'),
(4, 'America', '4ff736715682f408b3683cbc89c8e166.jpg_1693894236.jpg', '2023-09-05 00:10:36', '2023-09-05 00:10:36');

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cat_id` bigint(20) UNSIGNED NOT NULL,
  `video_title` varchar(255) NOT NULL,
  `video_url` varchar(255) NOT NULL,
  `video_id` varchar(255) NOT NULL,
  `video_thumbnail` varchar(255) DEFAULT NULL,
  `video_duration` varchar(255) NOT NULL,
  `video_description` text NOT NULL,
  `video_type` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `total_views` int(11) NOT NULL,
  `date_time` timestamp NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `cat_id`, `video_title`, `video_url`, `video_id`, `video_thumbnail`, `video_duration`, `video_description`, `video_type`, `size`, `total_views`, `date_time`, `created_at`, `updated_at`) VALUES
(33, 10, '96 Songs | The Life of Ram Video Song', 'https://www.youtube.com/watch?v=6LD30ChPsSs', '6LD30ChPsSs', '1663576910.jpg', '00:00', '<span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">Madras Enterprises presents \"96\" Tamil Movie Songs\r\n\r\n96 Songs | </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/thelifeofram\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#TheLifeofRam</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\"> Video Song | </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/vijaysethupathi\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#VijaySethupathi</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">, </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/trisha\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#Trisha</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\"> | </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/hashtag/govindvasantha\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">#GovindVasantha</a><span dir=\"auto\" class=\"style-scope yt-formatted-string\" style=\"margin: 0px; padding: 0px; border: 0px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\"> | C. Prem Kumar\r\n\r\n#96 Ringback Tunes ► </span><a class=\"yt-simple-endpoint style-scope yt-formatted-string\" spellcheck=\"false\" href=\"https://www.youtube.com/redirect?event=video_description&amp;redir_token=QUFFLUhqa0JDSGhZZVZFY2E2cWdDZjJ5OWtQUGFIbEVkZ3xBQ3Jtc0trQlA3U3ZwSWlvR1E0Nmo2Mi0xbWEzZWhIQk9aZUpfcmRqM0dScEFaOU9sRUtkYjdyY05pSGppbW92VHBwMzhnOVdUSDZpOG0zYUUyNXVoLUNtV05hQW80UmQwY3ZEenI5Y2h4bF9QUjRnSzFGbUtFWQ&amp;q=https%3A%2F%2Fbit.ly%2F2woIXyu&amp;v=6LD30ChPsSs\" rel=\"nofollow\" target=\"_blank\" dir=\"auto\" style=\"display: var(--yt-endpoint-display,inline-block); cursor: pointer; text-decoration: var(--yt-endpoint-text-regular-decoration,none); overflow-wrap: var(--yt-endpoint-word-wrap,none); word-break: var(--yt-endpoint-word-break,none); font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;\">https://bit.ly/2woIXyu</a>', 'Youtube', '', 0, '2022-09-19 08:41:50', '2022-09-19 08:41:50', '2022-09-19 08:41:50');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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
(60, '2021_04_20_051617_create_regusers_table', 3),
(64, '2014_10_12_000000_create_users_table', 6),
(67, '2021_03_21_120852_create_admins_table', 6),
(81, '2021_06_24_112246_create_tokens_table', 8),
(82, '2021_06_29_060235_create_notifications_table', 8),
(88, '2021_07_14_080503_create_url_types_table', 8),
(89, '2021_07_14_090933_create_user_agent_types_table', 8),
(90, '2021_07_15_120252_create_token_types_table', 9),
(92, '2022_07_18_131753_create_categories_table', 11),
(95, '2021_05_27_075818_create_sliders_table', 13),
(96, '2022_07_19_064520_create_items_table', 14),
(97, '2023_08_31_054412_create_countries_table', 15),
(99, '2023_08_31_114912_create_sliders_table', 16),
(100, '2023_08_31_115049_create_radios_table', 16),
(104, '2023_11_12_092024_create_navigations_table', 18),
(106, '2021_06_21_062028_create_advertisements_table', 19),
(107, '2023_11_15_064509_create_settings_table', 20);

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

--
-- Table structure for table `navigations`
--

CREATE TABLE `navigations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` text NOT NULL,
  `type` varchar(255) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `url_dark` varchar(255) DEFAULT NULL,
  `target` varchar(255) DEFAULT NULL,
  `html_tag` varchar(255) DEFAULT NULL,
  `show_header` tinyint(1) NOT NULL,
  `show_footer` tinyint(1) 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 `navigations`
--

INSERT INTO `navigations` (`id`, `name`, `image`, `type`, `url`, `url_dark`, `target`, `html_tag`, `show_header`, `show_footer`, `created_at`, `updated_at`) VALUES
(6, 'Test Navigation', 'upload/navigation_images/1700640295_63.1655531599.0662.jpg', 'web_url', 'test url', 'test dark url', 'Internal', NULL, 1, 1, '2023-11-22 02:04:55', '2023-11-22 02:05:51');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `image_url` varchar(255) 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 `notifications`
--

INSERT INTO `notifications` (`id`, `title`, `message`, `url`, `image_url`, `created_at`, `updated_at`) VALUES
(1, 'Hair Cut', 'asdgfhjhhhgf', 'https://www.google.com/', 'https://i.pinimg.com/736x/5c/a9/6f/5ca96fe550aab0f2cc2768d3dee9417d.jpg', '2021-07-25 04:46:15', '2021-07-25 04:46:15'),
(2, 'ashbfdjhb', 'sdjbkjdbnkj', 'cdsbckjbn', 'https://i.pinimg.com/736x/5c/a9/6f/5ca96fe550aab0f2cc2768d3dee9417d.jpg', '2022-07-20 10:27:12', '2022-07-20 10:27:12'),
(3, 'hi', 'hello', 'how r you', 'https://i.pinimg.com/736x/5c/a9/6f/5ca96fe550aab0f2cc2768d3dee9417d.jpg', '2022-09-07 05:14:50', '2022-09-07 05:14:50'),
(4, 'test', 'hello', 'https://www.youtube.com/watch?v=P2ra45c4Gp4', 'https://media.istockphoto.com/vectors/hand-holding-mobile-phone-with-new-email-icon-vector-illustration-vector-id1256767138?k=20&m=1256767138&s=612x612&w=0&h=CCNflxf6O4nT2g2vYyAljOaNGTJBXpvPj6t4bQhfh44=', '2022-09-18 09:13:55', '2022-09-18 09:13:55'),
(5, 'test', 'go ahead', 'https://www.youtube.com/watch?v=P2ra45c4Gp4', 'https://media.istockphoto.com/vectors/hand-holding-mobile-phone-with-new-email-icon-vector-illustration-vector-id1256767138?k=20&m=1256767138&s=612x612&w=0&h=CCNflxf6O4nT2g2vYyAljOaNGTJBXpvPj6t4bQhfh44=', '2022-09-18 10:04:28', '2022-09-18 10:04:28'),
(6, 'test', 'hello, good evening', 'https://www.youtube.com/watch?v=7REPYx4XMW8', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b6/Image_created_with_a_mobile_phone.png/640px-Image_created_with_a_mobile_phone.png', '2022-10-03 12:40:12', '2022-10-03 12:40:12'),
(7, 'test 1', 'check', 'https://www.youtube.com/watch?v=7REPYx4XMW8', 'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b6/Image_created_with_a_mobile_phone.png/640px-Image_created_with_a_mobile_phone.png', '2022-10-03 12:43:12', '2022-10-03 12:43:12'),
(8, 'Test title', 'Test notification message', 'https://', 'https://', '2023-11-15 03:20:01', '2023-11-15 03:20:01'),
(9, 'Test Title', 'Test Message', 'https://github.com/abumotaleb99', 'https://', '2023-11-20 05:29:19', '2023-11-20 05:29:19');

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

--
-- Table structure for table `radios`
--

CREATE TABLE `radios` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `channel_title` varchar(255) NOT NULL,
  `channel_url` varchar(255) NOT NULL,
  `channel_signal` varchar(255) NOT NULL,
  `cover` varchar(255) NOT NULL,
  `description` text 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 `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cat_id` bigint(20) UNSIGNED NOT NULL,
  `video_title` varchar(255) NOT NULL,
  `video_url` varchar(255) NOT NULL,
  `video_id` varchar(255) NOT NULL,
  `video_thumbnail` varchar(255) NOT NULL,
  `video_duration` varchar(255) NOT NULL,
  `video_description` text NOT NULL,
  `video_type` varchar(255) NOT NULL,
  `size` varchar(255) NOT NULL,
  `total_views` int(11) 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 `token_types`
--

CREATE TABLE `token_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `token_name` varchar(255) NOT NULL,
  `token_type_value` varchar(255) 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 `token_types`
--

INSERT INTO `token_types` (`id`, `token_name`, `token_type_value`, `created_at`, `updated_at`) VALUES
(1, 'json', '0', NULL, NULL);

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

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

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sliders_cat_id_foreign` (`cat_id`);

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

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

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

--
-- Indexes for table `radios`
--
ALTER TABLE `radios`
  ADD PRIMARY KEY (`id`),
  ADD KEY `radios_category_id_foreign` (`category_id`),
  ADD KEY `radios_country_id_foreign` (`country_id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sliders_cat_id_foreign` (`cat_id`);

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `items`
--
ALTER TABLE `items`
  ADD CONSTRAINT `category_foregin_id_key` FOREIGN KEY (`cat_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `radios`
--
ALTER TABLE `radios`
  ADD CONSTRAINT `radios_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `radios_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `sliders`
--
ALTER TABLE `sliders`
  ADD CONSTRAINT `sliders_cat_id_foreign` FOREIGN KEY (`cat_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

