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

START TRANSACTION;



--
-- Database: `mini_ott_codecanyon2`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: blocked',
  `remember_token` varchar(100) 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 `admins`
--

INSERT INTO `admins` (`id`, `username`, `name`, `email`, `email_verified_at`, `password`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'abumotaleb', 'Abu Motaleb', 'abumotaleb1111@gmail.com', NULL, '$2y$12$.LnnpbWhBGldyBG6th2sPOE4AIvfg6xa0kIo/69V0w2dcU4EVO.I2', 0, 'Kr5NVUL0phmJxeRVIFCXblphVORLjjZPGtTyQrpVzsVW1SQJgCaTrtNLVHZg', '2024-09-17 11:11:38', '2024-09-17 11:11:38');

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

--
-- Table structure for table `advertisements`
--

CREATE TABLE `advertisements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `admob_android_publisher_account_id` varchar(255) DEFAULT NULL,
  `admob_android_banner_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_android_interstitial_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_android_native_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_android_reward_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_android_app_open_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_ios_banner_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_ios_interstitial_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_ios_native_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_ios_reward_ad_unit_id` varchar(255) DEFAULT NULL,
  `admob_ios_app_open_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_android_banner_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_android_interstitial_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_android_native_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_android_reward_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_ios_banner_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_ios_interstitial_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_ios_native_ad_unit_id` varchar(255) DEFAULT NULL,
  `facebook_ios_reward_ad_unit_id` varchar(255) DEFAULT NULL,
  `unity_game_id` varchar(255) DEFAULT NULL,
  `unity_banner_ad_placement_id` varchar(255) DEFAULT NULL,
  `unity_interstitial_ad_placement_id` varchar(255) DEFAULT NULL,
  `ironsource_app_key` varchar(255) DEFAULT NULL,
  `interstitial_ad_interval` varchar(255) DEFAULT NULL,
  `native_ad_index` varchar(255) DEFAULT NULL,
  `ads_type` 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 `advertisements`
--

INSERT INTO `advertisements` (`id`, `admob_android_publisher_account_id`, `admob_android_banner_ad_unit_id`, `admob_android_interstitial_ad_unit_id`, `admob_android_native_ad_unit_id`, `admob_android_reward_ad_unit_id`, `admob_android_app_open_ad_unit_id`, `admob_ios_banner_ad_unit_id`, `admob_ios_interstitial_ad_unit_id`, `admob_ios_native_ad_unit_id`, `admob_ios_reward_ad_unit_id`, `admob_ios_app_open_ad_unit_id`, `facebook_android_banner_ad_unit_id`, `facebook_android_interstitial_ad_unit_id`, `facebook_android_native_ad_unit_id`, `facebook_android_reward_ad_unit_id`, `facebook_ios_banner_ad_unit_id`, `facebook_ios_interstitial_ad_unit_id`, `facebook_ios_native_ad_unit_id`, `facebook_ios_reward_ad_unit_id`, `unity_game_id`, `unity_banner_ad_placement_id`, `unity_interstitial_ad_placement_id`, `ironsource_app_key`, `interstitial_ad_interval`, `native_ad_index`, `ads_type`, `created_at`, `updated_at`) VALUES
(1, '1', '3', '5', '2', '4', '6', '7', '9', '11', '8', '10', '123', '14', '13', NULL, '15', '17', '166', '18', '19', '21', '20', '22', '10', '3', '0', '2024-11-14 10:58:27', '2024-11-14 11:12:27');

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('spatie.permission.cache', 'a:3:{s:5:\"alias\";a:5:{s:1:\"a\";s:2:\"id\";s:1:\"b\";s:4:\"name\";s:1:\"c\";s:10:\"guard_name\";s:1:\"d\";s:10:\"group_name\";s:1:\"r\";s:5:\"roles\";}s:11:\"permissions\";a:43:{i:0;a:5:{s:1:\"a\";i:1;s:1:\"b\";s:14:\"dashboard.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:9:\"dashboard\";s:1:\"r\";a:1:{i:0;i:1;}}i:1;a:5:{s:1:\"a\";i:2;s:1:\"b\";s:9:\"role.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"role\";s:1:\"r\";a:1:{i:0;i:1;}}i:2;a:5:{s:1:\"a\";i:3;s:1:\"b\";s:11:\"role.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"role\";s:1:\"r\";a:1:{i:0;i:1;}}i:3;a:5:{s:1:\"a\";i:4;s:1:\"b\";s:9:\"role.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"role\";s:1:\"r\";a:1:{i:0;i:1;}}i:4;a:5:{s:1:\"a\";i:5;s:1:\"b\";s:11:\"role.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"role\";s:1:\"r\";a:1:{i:0;i:1;}}i:5;a:5:{s:1:\"a\";i:6;s:1:\"b\";s:10:\"admin.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"admin\";s:1:\"r\";a:1:{i:0;i:1;}}i:6;a:5:{s:1:\"a\";i:7;s:1:\"b\";s:12:\"admin.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"admin\";s:1:\"r\";a:1:{i:0;i:1;}}i:7;a:5:{s:1:\"a\";i:8;s:1:\"b\";s:10:\"admin.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"admin\";s:1:\"r\";a:1:{i:0;i:1;}}i:8;a:5:{s:1:\"a\";i:9;s:1:\"b\";s:12:\"admin.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"admin\";s:1:\"r\";a:1:{i:0;i:1;}}i:9;a:5:{s:1:\"a\";i:10;s:1:\"b\";s:13:\"category.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"category\";s:1:\"r\";a:1:{i:0;i:1;}}i:10;a:5:{s:1:\"a\";i:11;s:1:\"b\";s:15:\"category.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"category\";s:1:\"r\";a:1:{i:0;i:1;}}i:11;a:5:{s:1:\"a\";i:12;s:1:\"b\";s:13:\"category.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"category\";s:1:\"r\";a:1:{i:0;i:1;}}i:12;a:5:{s:1:\"a\";i:13;s:1:\"b\";s:15:\"category.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"category\";s:1:\"r\";a:1:{i:0;i:1;}}i:13;a:5:{s:1:\"a\";i:14;s:1:\"b\";s:10:\"video.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"video\";s:1:\"r\";a:1:{i:0;i:1;}}i:14;a:5:{s:1:\"a\";i:15;s:1:\"b\";s:12:\"video.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"video\";s:1:\"r\";a:1:{i:0;i:1;}}i:15;a:5:{s:1:\"a\";i:16;s:1:\"b\";s:10:\"video.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"video\";s:1:\"r\";a:1:{i:0;i:1;}}i:16;a:5:{s:1:\"a\";i:17;s:1:\"b\";s:12:\"video.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"video\";s:1:\"r\";a:1:{i:0;i:1;}}i:17;a:5:{s:1:\"a\";i:18;s:1:\"b\";s:11:\"slider.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:6:\"slider\";s:1:\"r\";a:1:{i:0;i:1;}}i:18;a:5:{s:1:\"a\";i:19;s:1:\"b\";s:13:\"slider.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:6:\"slider\";s:1:\"r\";a:1:{i:0;i:1;}}i:19;a:5:{s:1:\"a\";i:20;s:1:\"b\";s:11:\"slider.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:6:\"slider\";s:1:\"r\";a:1:{i:0;i:1;}}i:20;a:5:{s:1:\"a\";i:21;s:1:\"b\";s:13:\"slider.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:6:\"slider\";s:1:\"r\";a:1:{i:0;i:1;}}i:21;a:5:{s:1:\"a\";i:22;s:1:\"b\";s:19:\"match-category.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"match-category\";s:1:\"r\";a:1:{i:0;i:1;}}i:22;a:5:{s:1:\"a\";i:23;s:1:\"b\";s:21:\"match-category.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"match-category\";s:1:\"r\";a:1:{i:0;i:1;}}i:23;a:5:{s:1:\"a\";i:24;s:1:\"b\";s:19:\"match-category.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"match-category\";s:1:\"r\";a:1:{i:0;i:1;}}i:24;a:5:{s:1:\"a\";i:25;s:1:\"b\";s:21:\"match-category.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"match-category\";s:1:\"r\";a:1:{i:0;i:1;}}i:25;a:5:{s:1:\"a\";i:26;s:1:\"b\";s:10:\"match.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"match\";s:1:\"r\";a:1:{i:0;i:1;}}i:26;a:5:{s:1:\"a\";i:27;s:1:\"b\";s:12:\"match.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"match\";s:1:\"r\";a:1:{i:0;i:1;}}i:27;a:5:{s:1:\"a\";i:28;s:1:\"b\";s:10:\"match.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"match\";s:1:\"r\";a:1:{i:0;i:1;}}i:28;a:5:{s:1:\"a\";i:29;s:1:\"b\";s:12:\"match.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:5:\"match\";s:1:\"r\";a:1:{i:0;i:1;}}i:29;a:5:{s:1:\"a\";i:30;s:1:\"b\";s:17:\"notification.send\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:12:\"notification\";s:1:\"r\";a:1:{i:0;i:1;}}i:30;a:5:{s:1:\"a\";i:31;s:1:\"b\";s:9:\"page.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"page\";s:1:\"r\";a:1:{i:0;i:1;}}i:31;a:5:{s:1:\"a\";i:32;s:1:\"b\";s:11:\"page.create\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"page\";s:1:\"r\";a:1:{i:0;i:1;}}i:32;a:5:{s:1:\"a\";i:33;s:1:\"b\";s:9:\"page.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"page\";s:1:\"r\";a:1:{i:0;i:1;}}i:33;a:5:{s:1:\"a\";i:34;s:1:\"b\";s:11:\"page.delete\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:4:\"page\";s:1:\"r\";a:1:{i:0;i:1;}}i:34;a:5:{s:1:\"a\";i:35;s:1:\"b\";s:19:\"email-settings.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"email-settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:35;a:5:{s:1:\"a\";i:36;s:1:\"b\";s:24:\"email-configuration.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"email-settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:36;a:5:{s:1:\"a\";i:37;s:1:\"b\";s:20:\"email-templates.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"email-settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:37;a:5:{s:1:\"a\";i:38;s:1:\"b\";s:27:\"email-global-templates.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:14:\"email-settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:38;a:5:{s:1:\"a\";i:39;s:1:\"b\";s:13:\"settings.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:39;a:5:{s:1:\"a\";i:40;s:1:\"b\";s:26:\"notification-settings.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:40;a:5:{s:1:\"a\";i:41;s:1:\"b\";s:26:\"notification-settings.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:41;a:5:{s:1:\"a\";i:42;s:1:\"b\";s:27:\"advertisement-settings.view\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"settings\";s:1:\"r\";a:1:{i:0;i:1;}}i:42;a:5:{s:1:\"a\";i:43;s:1:\"b\";s:27:\"advertisement-settings.edit\";s:1:\"c\";s:5:\"admin\";s:1:\"d\";s:8:\"settings\";s:1:\"r\";a:1:{i:0;i:1;}}}s:5:\"roles\";a:1:{i:0;a:3:{s:1:\"a\";i:1;s:1:\"b\";s:11:\"Super Admin\";s:1:\"c\";s:5:\"admin\";}}}', 1731649440);

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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`, `name`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Adventure', 'assets/uploads/categories/1726139795_adventure_.png', 0, '2024-09-12 05:11:50', '2024-09-12 05:16:35'),
(2, 'Animation123', 'assets/uploads/categories/1726139768_animation.png', 0, '2024-09-12 05:12:10', '2024-10-22 05:01:10'),
(3, 'Fantsy', 'assets/uploads/categories/1726139837_fantasy.png', 0, '2024-09-12 05:17:17', '2024-09-12 05:17:17'),
(4, 'Sci-fi', 'assets/uploads/categories/1726139848_sci-fi.png', 0, '2024-09-12 05:17:28', '2024-09-12 05:17:28');

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

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `device_id` varchar(255) NOT NULL,
  `fcm_token` 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 `devices`
--

INSERT INTO `devices` (`id`, `device_id`, `fcm_token`, `created_at`, `updated_at`) VALUES
(1, '1234', 'abcsd5', '2024-09-18 12:50:03', '2024-09-18 12:50:03'),
(2, 'joyeuse', 'd42NTbUETp6l7unucXPqBc:APA91bG-cR9HX8SgihhN10H0vTwmrkWjPglTQPzfLq1y0HIpmtrVFRoJXPGYTIx2LVNWyxNU_Nt9-efrkz5HlitqaxDHIToduwZHOAjLVSyfChxpMFWLVN0g2h47KWJXxZynyYLY54PD', '2024-09-18 12:53:20', '2024-10-01 06:04:49');

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

--
-- Table structure for table `email_configurations`
--

CREATE TABLE `email_configurations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email_send_method` varchar(255) DEFAULT NULL,
  `mail_host` varchar(255) DEFAULT NULL,
  `mail_port` varchar(255) DEFAULT NULL,
  `mail_encryption_method` varchar(255) DEFAULT NULL,
  `mail_username` varchar(255) DEFAULT NULL,
  `mail_password` varchar(255) DEFAULT NULL,
  `mail_from_address` varchar(255) DEFAULT NULL,
  `mail_from_name` 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 `email_configurations`
--

INSERT INTO `email_configurations` (`id`, `email_send_method`, `mail_host`, `mail_port`, `mail_encryption_method`, `mail_username`, `mail_password`, `mail_from_address`, `mail_from_name`, `created_at`, `updated_at`) VALUES
(1, 'smtp', 'sandbox.smtp.mailtrap.io', '2525', NULL, 'f8624572214bb7', '48ad672bec9e20', 'miniott@example.com', 'Mini OTT', '2024-07-06 23:44:24', '2024-09-03 17:51:07');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `content` text 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 `email_templates`
--

INSERT INTO `email_templates` (`id`, `name`, `slug`, `subject`, `content`, `created_at`, `updated_at`) VALUES
(1, 'Password Reset Link Mail', 'admin-reset-password', 'Password Reset Link Mail', '<p>Dear <strong>{{ user_name }}</strong>,</p>\r\n\r\n<p>We understand that you&#39;ve requested to reset your password.</p>\r\n\r\n<p>If you didn&#39;t make this request, you can safely ignore this email. Your account security is important to us.</p>\r\n\r\n<p>{{ reset_button }}</p>\r\n\r\n<p>If you didn&#39;t make this request, you can safely ignore this email. Your account security is important to us.If you encounter any issues while resetting your password or need further assistance, please don&#39;t hesitate to reach out to our support team.</p>\r\n\r\n<p>Best regards,<br />\r\nMini OTT</p>', '2024-09-03 17:26:36', '2024-09-03 17:28:01');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `global_email_templates`
--

CREATE TABLE `global_email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email_header` text NOT NULL DEFAULT '',
  `email_footer` varchar(255) NOT NULL DEFAULT '',
  `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 `global_email_templates`
--

INSERT INTO `global_email_templates` (`id`, `email_header`, `email_footer`, `created_at`, `updated_at`) VALUES
(1, 'assets/uploads/email_templates/1726138353_1725452668_logo.png', '<p>miniott@gmail.com</p>', '2024-09-12 04:52:33', '2024-09-12 04:52:33');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `match_models`
--

CREATE TABLE `match_models` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `league_name` varchar(255) NOT NULL,
  `league_type` enum('cricket','football') NOT NULL,
  `team_one_name` varchar(100) NOT NULL,
  `team_one_flag` varchar(255) NOT NULL,
  `team_two_name` varchar(100) NOT NULL,
  `team_two_flag` varchar(255) NOT NULL,
  `match_date` date NOT NULL,
  `match_time` time NOT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `match_models`
--

INSERT INTO `match_models` (`id`, `league_name`, `league_type`, `team_one_name`, `team_one_flag`, `team_two_name`, `team_two_flag`, `match_date`, `match_time`, `status`, `created_at`, `updated_at`) VALUES
(9, 'League 1', 'football', 'Name1', 'assets/uploads/matches/1727679081_1726662086_FC_Barcelona_(crest).svg.png', 'Name2', 'assets/uploads/matches/1727679081_1726661161_deli0ap-8cda52f6-9a9f-4562-85da-7a281a16af04.png', '2024-10-11', '12:51:00', 0, '2024-09-30 06:51:21', '2024-09-30 06:51:21'),
(10, 'Indian Premier League', 'cricket', 'Mumbia Indians', 'assets/uploads/matches/1727774820_deli0hx-9bb0c24f-d346-4e3b-accf-d0dbbea99021.png', 'Kolkata Knight Riders', 'assets/uploads/matches/1727774820_deli20r-22b9a83f-db6a-43b9-8908-05d61cb13a95.png', '2024-10-10', '19:00:00', 0, '2024-10-01 09:25:36', '2024-10-01 09:27:00');

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

--
-- 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
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_08_08_100120_create_admins_table', 1),
(5, '2024_08_08_101551_create_personal_access_tokens_table', 1),
(6, '2024_08_11_060739_create_permission_tables', 1),
(7, '2024_08_12_082558_create_email_configurations_table', 1),
(8, '2024_08_12_082620_create_email_templates_table', 1),
(9, '2024_08_12_082641_create_global_email_templates_table', 1),
(10, '2024_08_29_110606_create_categories_table', 1),
(11, '2024_09_04_184356_create_pages_table', 1),
(12, '2024_09_05_122712_create_sliders_table', 1),
(13, '2024_09_05_185036_create_videos_table', 1),
(14, '2024_09_11_151600_create_devices_table', 1),
(20, '2024_09_17_131904_create_match_models_table', 4),
(21, '2024_09_29_174952_create_streaming_urls_table', 5),
(22, '2024_09_30_130523_create_tv_categories_table', 6),
(23, '2024_09_30_130806_create_tvs_table', 6),
(24, '2024_10_27_112550_create_radio_categories_table', 7),
(25, '2024_10_27_124834_create_radios_table', 8),
(26, '2024_09_11_175416_create_advertisements_table', 9);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\Admin', 1);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `page_content` text NOT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `page_content`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Terms & Conditions', 'terms-conditions', '<p>Don&#39;t misuse our Services.<br />\r\nYou may use our Services only as permitted by law, including applicable export and re-export control laws and regulations. We may suspend or stop providing our Services to you if you do not comply with our terms or policies or if we are investigating suspected misconduct.</p>\r\n\r\n<p>&nbsp;</p>', 0, '2024-09-04 01:19:34', '2024-09-12 04:54:47'),
(2, 'Privacy Policy', 'privacy-policy', '<p>Frequently asked question (FAQ) pages are often overlooked in lieu of other website additions, like product pages, or general company needs, like hiring and product integrations.</p>\r\n\r\n<p>While all these resources benefit a business, creating an asset that allows customers to find their own answers is invaluable. Between the cost savings self-service options bring and the customer satisfaction that comes with fast support, you shouldn&rsquo;t overlook FAQs.</p>\r\n\r\n<p>In this guide, we&rsquo;ll go over the basics of FAQs and answer common questions about this self-service tool. Here&rsquo;s a quick look at everything we&rsquo;ll cover:</p>\r\n\r\n<ul>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#What%20is%20an%20FAQ%20page?\">What is an FAQ page?</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Why%20are%20FAQ%20pages%20important%20to%20have?\">Why are FAQ pages important to have?</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#FAQ%20page%20examples\">FAQ page examples</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#How%20to%20create%20an%20FAQ%20page:%208%20best%20practices\">How to create an FAQ page: 8 best practices</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#FAQ%20page%20template\">FAQ page template</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#FAQs%20about%20FAQ%20pages\">FAQs about FAQ pages</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Do%20more%20with%20your%20FAQs\">Do more with your FAQs</a></li>\r\n</ul>\r\n\r\n<h2 id=\"What is an FAQ page?\">What is an FAQ page?</h2>\r\n\r\n<p>A frequently asked questions page&mdash;or an FAQ page for short&mdash;is a key part of a knowledge base because it addresses your customers&rsquo; most common questions and is useful at all stages of the customer journey. FAQs start with a question and then provide a concise answer.</p>\r\n\r\n<p>While many think of FAQs as a basic list of questions and answers, some businesses incorporate them into a single section when&nbsp;<a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/data-driven-path-building-great-help-center/\" rel=\"noopener noreferrer\" target=\"_blank\">building a larger help center</a>. The help center functions as a comprehensive knowledge base that empowers customers to independently find solutions.</p>\r\n\r\n<p>Within a&nbsp;<a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/knowledge-base-article-template/\" rel=\"noopener noreferrer\" target=\"_blank\">knowledge base template</a>, FAQs can function as standalone articles. For example, businesses can incorporate the question &ldquo;How do I set up a password?&rdquo; into a longer series such as &ldquo;How to set up your account.&rdquo;</p>\r\n\r\n<h2 id=\"Why are FAQ pages important to have?\">Why are FAQ pages important to have?</h2>\r\n\r\n<p>FAQs are important for a few reasons, including:</p>\r\n\r\n<ul>\r\n	<li><strong>Accessibility:</strong>&nbsp;Links on an FAQ page guide users through your website, helping them find the information they need at any time.</li>\r\n	<li><strong>Accuracy:</strong>&nbsp;The FAQ page should be a single source of truth, offering customers answers to general questions.</li>\r\n	<li><strong>Affordability:</strong>&nbsp;When customers can get answers themselves, they don&rsquo;t have to rely on customer service agents. This ultimately lowers payroll costs.</li>\r\n</ul>\r\n\r\n<p>The purpose of an FAQ page is to provide quick answers to common questions that your business can anticipate. Companies should continuously expand this resource as they acquire more data.</p>\r\n\r\n<p><strong>&ldquo;Having an FAQ page is a way to be more proactive and predictive with what your customers or clients are going to need help with. It&rsquo;s also an opportunity to point people in the direction you want them to go. If there&rsquo;s something you want to make sure they see, an FAQ is a great place to put it.&rdquo;</strong></p>\r\n\r\n<p><strong>&ndash;Maddie Hoffman, director of self-service and automation at Zendesk</strong></p>\r\n\r\n<h2 id=\"FAQ page examples\">19 FAQ page examples</h2>\r\n\r\n<p>Before you build your own FAQ page, you should know what features to include.</p>\r\n\r\n<p>We rounded up a selection of 19 FAQ examples with unique characteristics&mdash;such as user experience (UX), design, and additional self-service offerings&mdash;that make these pages especially successful.</p>\r\n\r\n<ul>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#AdEspresso\">AdEspresso</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Adobe%20Creative%20Cloud\">Adobe Creative Cloud</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Airbnb\">Airbnb</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Airtable\">Airtable</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Ancestry\">Ancestry</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#DoggieLawn\">DoggieLawn</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Etsy\">Etsy</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Fabletics\">Fabletics</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Liquid%20Death\">Liquid Death</a></li>\r\n</ul>\r\n\r\n<ul>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Mailchimp\">Mailchimp</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#McDonald%E2%80%99s\">McDonald&rsquo;s</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Microsoft\">Microsoft</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Nintendo\">Nintendo</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Upwork\">Upwork</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Vrbo\">Vrbo</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Wandering%20Bear\">Wandering Bear</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#WhatsApp\">WhatsApp</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Wistia\">Wistia</a></li>\r\n	<li><a data-garden-id=\"buttons.anchor\" data-garden-version=\"8.76.2\" data-interaction-type=\"link-inline-primary\" href=\"https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/#Zendesk\">Zendesk</a></li>\r\n</ul>', 0, '2024-09-04 01:20:38', '2024-10-02 10:57:28'),
(3, 'Faq', 'faq', '<p>https://www.zendesk.com/blog/the-best-faq-page-examples-and-how-to-make-your-own/</p>', 0, '2024-10-02 10:31:30', '2024-10-02 10:56:07'),
(4, 'Telegram', 'telegram', '<p>https://nicegram.app/blog/music-telegram-group<br />\r\n&nbsp;</p>\r\n\r\n<h1>Music Telegram Group Links</h1>\r\n\r\n<p>04.03.2024</p>\r\n\r\n<p>Author:</p>\r\n\r\n<p><a href=\"https://nicegram.app/blog/author/stella-ladis\" rel=\"author\" title=\"Posts by Stella Ladis\">Stella Ladis</a></p>\r\n\r\n<p><em><em>Are you a musician and consider music your vocation? Or are you just a fan of popular music tracks and would like to understand more about musical terms and devices? Then music Telegram groups are what you need. In the vastness of the Telegram communities, you can find music for every taste, as well as interesting stories about the creation of tracks, and get musical notation.</em></em></p>\r\n\r\n<p>In a rapidly changing world, almost nothing remains the same. Except that the music tracks come out without delay and delight their listeners. Even the way they are listened to or downloaded has changed. Now you don&rsquo;t need to search for websites where you can listen to or download the track you like. You don&rsquo;t have to pay money to streaming platforms like Spotify or Apple Music. Now all new and popular musical compositions can be found in music group links.</p>\r\n\r\n<h2>What is Music Telegram Group Link?</h2>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The music Telegram group link is a specially created Telegram group for all music lovers. Subscribing to such a group makes life easier for all fans of various musical genres. Now you don&rsquo;t have to waste time to find popular or new music. With the help of Telegram groups and convenient search, you can delight yourself with your favorite tracks in a matter of seconds, both online and offline.&nbsp;</p>\r\n\r\n<p>In addition, such groups are free, and you do not have to sign up for a monthly or annual subscription. At the same time, all music appears and is downloaded in high quality and without ads.</p>\r\n\r\n<p>Let&rsquo;s learn everything about Telegram group links for music fans.</p>\r\n\r\n<h2>The List of the Best Telegram Music Group Links</h2>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Would you like to find out a selection of music Telegram and most popular music Telegram group links and get subscription links? Here is a list of the proven, active, and best music Telegram groups for every taste and preference.</p>\r\n\r\n<p>Find Telegram group links for music from this list.</p>\r\n\r\n<h3>1. Spotify Music Downloader</h3>\r\n\r\n<p><strong>Subscribers: 58K</strong></p>\r\n\r\n<p>A popular community, where there are many tracks divided by genre. At the same time, all tracks are available for download. Most of the group members came from Spotify, with the desire to download tracks.</p>\r\n\r\n<p>In addition, on this website/group all musical compositions are available for online listening without ads. During the listening session, you can discuss with other participants your favorite tracks and news from the music world.</p>\r\n\r\n<p><em>P.S.: The chat is not affiliated with Spotify.</em></p>\r\n\r\n<p><a href=\"https://t.me/Music_Downloader_Bot_Spotify\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<figure><a href=\"https://nicegram.app/download?utm_source=banner_blog&amp;utm_medium=general\" rel=\"noreferrer noopener\" target=\"_blank\"><img alt=\"\" decoding=\"async\" height=\"822\" src=\"https://nicegram.app/blog/wp-content/webp-express/webp-images/doc-root/wp-content/uploads/2024/02/banner-2-21_9.jpg.webp\" width=\"1920\" /></a></figure>\r\n\r\n<h3>2. АВАРСКИЕ ПЕСНИ 🎼🎶</h3>\r\n\r\n<p><strong>Subscribers: 42K</strong></p>\r\n\r\n<p>If you are a fan of avar music, then the group link is definitely what you need. Many avar-style tracks are available to listen to online and download to your device.</p>\r\n\r\n<p><em>P.S.: Some songs may be copyrighted. Materials might be copyrighted to. But don&rsquo;t worry, no violation expected.</em></p>\r\n\r\n<p><a href=\"https://t.me/avar_pesni\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>3. CULTURE ☻</h3>\r\n\r\n<p><strong>Subscribers: 18K</strong></p>\r\n\r\n<p>The chat is a kind of online poster of upcoming events in the music world. In addition, it is not uncommon to find musical compositions that are added by other participants.</p>\r\n\r\n<p>All communication is conducted in the group chat and is permanent.</p>\r\n\r\n<p>So let&rsquo;s find link new songs inside.</p>\r\n\r\n<p><a href=\"https://t.me/culturesg\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>4. Hi-Res Songs Communit</h3>\r\n\r\n<p><strong>Subscribers: 19K</strong></p>\r\n\r\n<p>One of the most popular Telegram groups. Here you can find various link world music, collections, and playlists by genre, and learn a lot about music in general.</p>\r\n\r\n<p>In addition, there is a lively conversation going on in the chat all day, which you can join at any time and participate in discussing the impact of a particular track on the development of the entire industry.</p>\r\n\r\n<p>Join music Telegram group to listen to the best songs.</p>\r\n\r\n<p><a href=\"https://t.me/tamilflacsong\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>5. Videodagi_musiqani_topsh</h3>\r\n\r\n<p><strong>Subscribers: 17K</strong></p>\r\n\r\n<p>A group of fans of oriental music. Admins replenish the track catalog daily by sending them to the group. In addition, each of the participants contributes to the development of the group.</p>\r\n\r\n<p>In addition to musical compositions, there are many music videos in the group. Therefore, if you like not only to listen but also to watch, welcome to the group.</p>\r\n\r\n<p><a href=\"https://t.me/Videodagi_musiqani_topish_mr3\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>6. 🔵🎵JUST MUSIC🎵</h3>\r\n\r\n<p><strong>Subscribers: 14K</strong></p>\r\n\r\n<p>An Arabic group where all the tracks are in Arabic. If you are a fan of Arabic culture, you will find everything you need in the group.</p>\r\n\r\n<p>In addition, the group often announces various events and concerts. However, the chat is conducted exclusively in Arabic.</p>\r\n\r\n<p><a href=\"https://t.me/musical_just\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>7. 🔝ТОП🔝🎧 МУЗОН 🎧💬 МУЗЫКА 💬</h3>\r\n\r\n<p><strong>Subscribers: 11K</strong></p>\r\n\r\n<p>A group to music with all the top and popular music, the list of which is updated daily. The group members discuss all the new music and news from the world of the industry.</p>\r\n\r\n<p><a href=\"https://t.me/muzykal_chat\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>8. ♛ 𝕄𝕌𝕊𝕀ℂ ℙ𝕃𝔸𝕐 𝔾ℝ𝕆𝕌ℙ ♛</h3>\r\n\r\n<p><strong>Subscribers: 10K</strong></p>\r\n\r\n<p>This group is a real paradise for music lovers. Here you can find various musical selections decorated with inspiring pictures.</p>\r\n\r\n<p>In addition, all participants are open to communication and always complement the collections with their favorite compositions.</p>\r\n\r\n<p><a href=\"https://t.me/Music_Play_House\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>9. ROminimal.club Track Discovery for DJs</h3>\r\n\r\n<p><strong>Subscribers: 7K</strong></p>\r\n\r\n<p>The group is a collection of DJ sets, bass tracks, mix songs, music videos from YouTube, as well as compilations. You can find everything for every taste and genre.&nbsp;</p>\r\n\r\n<p>In addition, participants often look for a traveling companion to go to a musical concert of their favorite band.</p>\r\n\r\n<p><em>P.S.: Share the link or the group name with your friends.</em></p>\r\n\r\n<p><a href=\"https://t.me/ROminimal_club\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<h3>10. Music Chatroom 🎧</h3>\r\n\r\n<p><strong>Subscribers: 1K</strong></p>\r\n\r\n<p>The community has a lot of music selections and videos. There is no specific genre, so the group is suitable for music lovers. There is a heated discussion of new products in the chat.</p>\r\n\r\n<p><a href=\"https://t.me/music_chatroom\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></p>\r\n\r\n<figure>\r\n<table>\r\n	<tbody>\r\n		<tr>\r\n			<td><strong><em>Stella Ladis (the author of the article) is not responsible for the actions of the readers. Joining Telegram music groups is a personal choice for everyone. By joining, you confirm that you are over 18 years old. Internal links in groups are a personal responsibility of everyone. All materials displayed on this list are for informational purposes only.</em></strong></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</figure>\r\n\r\n<h2>Music Telegram Group Active Links</h2>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<figure>\r\n<table>\r\n	<thead>\r\n		<tr>\r\n			<th>Music Telegram Group Name</th>\r\n			<th data-align=\"center\"><strong>Number of Subscribers</strong></th>\r\n			<th data-align=\"center\"><strong>Join Link</strong></th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>Spotify Music Downloader</td>\r\n			<td data-align=\"center\"><strong>58K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/Music_Downloader_Bot_Spotify\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>АВАРСКИЕ ПЕСНИ 🎼🎶</td>\r\n			<td data-align=\"center\"><strong>42K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/avar_pesni\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>CULTURE ☻</td>\r\n			<td data-align=\"center\"><strong>18K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/culturesg\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>Hi-Res Songs Communit</td>\r\n			<td data-align=\"center\"><strong>19K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/tamilflacsong\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>Videodagi_musiqani_topsh</td>\r\n			<td data-align=\"center\"><strong>17K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/Videodagi_musiqani_topish_mr3\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>🔵🎵JUST MUSIC🎵</td>\r\n			<td data-align=\"center\"><strong>14K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/musical_just\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>🔝ТОП🔝🎧 МУЗОН 🎧💬 МУЗЫКА 💬</td>\r\n			<td data-align=\"center\"><strong>11K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/muzykal_chat\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>♛ 𝕄𝕌𝕊𝕀ℂ ℙ𝕃𝔸𝕐 𝔾ℝ𝕆𝕌ℙ ♛</td>\r\n			<td data-align=\"center\"><strong>10K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/Music_Play_House\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>ROminimal.club Track Discovery for DJs</td>\r\n			<td data-align=\"center\"><strong>7K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/ROminimal_club\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n		<tr>\r\n			<td>Music Chatroom 🎧</td>\r\n			<td data-align=\"center\"><strong>1K</strong></td>\r\n			<td data-align=\"center\"><a href=\"https://t.me/music_chatroom\" rel=\"noreferrer noopener nofollow\" target=\"_blank\">Join Now</a></td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</figure>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Related posts</strong></p>\r\n\r\n<ul>\r\n	<li><a href=\"https://nicegram.app/blog/telegram-group\" rel=\"noreferrer noopener\" target=\"_blank\"><strong>Best Telegram Group Links 2024</strong></a></li>\r\n	<li><a href=\"https://nicegram.app/blog/crypto-telegram-groups\" rel=\"noreferrer noopener\" target=\"_blank\"><strong>Crypto Telegram Groups Links</strong></a></li>\r\n	<li><strong><a href=\"https://nicegram.app/blog/music-telegram-channels\" rel=\"noreferrer noopener\" target=\"_blank\">Music Telegram Channels Links</a></strong></li>\r\n</ul>\r\n\r\n<h2>FAQ</h2>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h3>How to join the Telegram music group link?</h3>\r\n\r\n<p>To join music Telegram group you like, you need to follow the group links or use the internal search in Telegram by typing the name of the group. Some groups are private, so you will need admin approval for the application. After approval, you will be able to listen to Telegram songs, learn new things, chat with other participants, and download tracks you like.</p>\r\n\r\n<h3>Is it safe to save music from the Telegram group?</h3>\r\n\r\n<p>Many people are afraid to download tracks from Telegram since you can download a virus to your device along with the track. But this is not the case. Telegram takes all necessary measures to protect users from both external and internal threats. Don&rsquo;t forget about the copyright Telegram group.</p>\r\n\r\n<h3>What are the rules in the Telegram music groups?</h3>\r\n\r\n<p>When joining a group, you need to know and follow certain rules. Each group can have its own list of rules. Here are the most popular rules of music Telegram groups:</p>\r\n\r\n<ul>\r\n	<li>Only fans of music can join.</li>\r\n	<li>Share new music tracks.</li>\r\n	<li>Respect all members of the group.</li>\r\n	<li>No spam and ads.</li>\r\n	<li>Have fun and enjoy.</li>\r\n</ul>\r\n\r\n<h3>Is it possible to add music to the Telegram music group?</h3>\r\n\r\n<p>Each member of the group can add any music link track and songs to content Telegram group available in the Telegram database. To add a track, you need to use the multimedia capabilities of the Telegram messenger.</p>\r\n\r\n<h2>Conclusion: Which Telegram Music Group Links are The Best to Join?</h2>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>If you are a big fan of music from the world, and it doesn&rsquo;t matter what genre, then you will definitely be able to find in this best music collection of Telegram music groups exactly the groups that you want to join. Don&rsquo;t be shy and start chatting with other group members. This way, you are more likely to join the group and discover something new in the industry from the list Telegram group links above.</p>\r\n\r\n<p>Tags:&nbsp;<a href=\"https://nicegram.app/blog/tag/best-telegram-music-group\" rel=\"tag\">Best Telegram Music Group</a>, <a href=\"https://nicegram.app/blog/tag/music-telegram-group\" rel=\"tag\">Music Telegram Group</a>, <a href=\"https://nicegram.app/blog/tag/telegram-groups-list\" rel=\"tag\">Telegram Groups list</a>, <a href=\"https://nicegram.app/blog/tag/telegram-music\" rel=\"tag\">Telegram Music</a>, <a href=\"https://nicegram.app/blog/tag/telegram-music-download\" rel=\"tag\">Telegram Music Download</a></p>\r\n\r\n<p>&larr; Prev Post<br />\r\n<a href=\"https://nicegram.app/blog/dating-telegram-group\" rel=\"prev\">Dating Telegram Group Links</a></p>', 0, '2024-10-02 11:29:01', '2024-10-02 11:29:01');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

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

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `group_name`, `created_at`, `updated_at`) VALUES
(1, 'dashboard.view', 'admin', 'dashboard', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(2, 'role.view', 'admin', 'role', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(3, 'role.create', 'admin', 'role', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(4, 'role.edit', 'admin', 'role', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(5, 'role.delete', 'admin', 'role', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(6, 'admin.view', 'admin', 'admin', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(7, 'admin.create', 'admin', 'admin', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(8, 'admin.edit', 'admin', 'admin', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(9, 'admin.delete', 'admin', 'admin', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(10, 'category.view', 'admin', 'category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(11, 'category.create', 'admin', 'category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(12, 'category.edit', 'admin', 'category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(13, 'category.delete', 'admin', 'category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(14, 'video.view', 'admin', 'video', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(15, 'video.create', 'admin', 'video', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(16, 'video.edit', 'admin', 'video', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(17, 'video.delete', 'admin', 'video', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(18, 'slider.view', 'admin', 'slider', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(19, 'slider.create', 'admin', 'slider', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(20, 'slider.edit', 'admin', 'slider', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(21, 'slider.delete', 'admin', 'slider', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(22, 'match-category.view', 'admin', 'match-category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(23, 'match-category.create', 'admin', 'match-category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(24, 'match-category.edit', 'admin', 'match-category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(25, 'match-category.delete', 'admin', 'match-category', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(26, 'match.view', 'admin', 'match', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(27, 'match.create', 'admin', 'match', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(28, 'match.edit', 'admin', 'match', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(29, 'match.delete', 'admin', 'match', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(30, 'notification.send', 'admin', 'notification', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(31, 'page.view', 'admin', 'page', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(32, 'page.create', 'admin', 'page', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(33, 'page.edit', 'admin', 'page', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(34, 'page.delete', 'admin', 'page', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(35, 'email-settings.view', 'admin', 'email-settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(36, 'email-configuration.edit', 'admin', 'email-settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(37, 'email-templates.edit', 'admin', 'email-settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(38, 'email-global-templates.edit', 'admin', 'email-settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(39, 'settings.view', 'admin', 'settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(40, 'notification-settings.view', 'admin', 'settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(41, 'notification-settings.edit', 'admin', 'settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(42, 'advertisement-settings.view', 'admin', 'settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39'),
(43, 'advertisement-settings.edit', 'admin', 'settings', '2024-09-17 11:11:39', '2024-09-17 11:11:39');

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL 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 `radios`
--

CREATE TABLE `radios` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `radio_category_id` bigint(20) UNSIGNED NOT NULL,
  `thumbnail_image` varchar(255) NOT NULL,
  `video_type` enum('upload','youtube','radio','other') NOT NULL COMMENT 'upload: video file, youtube: YouTube URL, radio: Radio URL, other: other URL',
  `youtube_url` varchar(255) DEFAULT NULL,
  `radio_url` varchar(255) DEFAULT NULL,
  `other_url` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT 0,
  `is_slider` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `radios`
--

INSERT INTO `radios` (`id`, `title`, `radio_category_id`, `thumbnail_image`, `video_type`, `youtube_url`, `radio_url`, `other_url`, `video`, `description`, `total_views`, `is_slider`, `status`, `created_at`, `updated_at`) VALUES
(4, 'Kid’s Corner', 4, 'assets/uploads/radio/images/1730017917_0126933-QUIZ-KIDS-1950s-Young-contestants-and-the-quizmaster-photographed-during-a-session-of-Quiz-Kids-a-radio-program-in-the-1940s-that-continued-on-television-in-the-1950s.jpg', 'youtube', 'https://youtu.be/rHIAOd-h3iA', NULL, NULL, NULL, '<p>Laravel is a web application framework with expressive, elegant syntax. A web framework provides a structure and starting point for creating your application, allowing you to focus on creating something amazing while we sweat the details.</p>', 0, 0, 0, '2024-10-27 08:31:57', '2024-10-27 08:31:57');

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

--
-- Table structure for table `radio_categories`
--

CREATE TABLE `radio_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `radio_categories`
--

INSERT INTO `radio_categories` (`id`, `name`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(4, 'Kid\'s Radio', 'assets/uploads/radio-categories/1730011405_unnamed.png', 0, '2024-10-27 06:43:25', '2024-10-27 06:43:25'),
(5, 'Community  Radio', 'assets/uploads/radio-categories/1730011483_istockphoto-1353436052-612x612.jpg', 0, '2024-10-27 06:44:43', '2024-10-27 06:44:43');

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

--
-- Table structure for table `roles`
--

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'admin', '2024-09-17 11:11:38', '2024-09-17 11:11:38');

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

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

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1);

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('AfwAzD7LTfMsbgMkTQ0pDZFGvUqGvGq7XiaaChsI', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiODNyRW5RTHplWHh5djVhbGpxZXFvZkhoUjVoVEh3NVFVaGpMVThWbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9hZG1pbi9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUyOiJsb2dpbl9hZG1pbl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1731582761);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `thumbnail_image` varchar(255) NOT NULL,
  `video_type` enum('upload','youtube','radio','other') NOT NULL COMMENT 'upload: video file, youtube: YouTube URL, radio: Radio URL, other: other URL',
  `youtube_url` varchar(255) DEFAULT NULL,
  `radio_url` varchar(255) DEFAULT NULL,
  `other_url` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT 0,
  `is_slider` tinyint(1) NOT NULL DEFAULT 1,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `category_id`, `thumbnail_image`, `video_type`, `youtube_url`, `radio_url`, `other_url`, `video`, `description`, `total_views`, `is_slider`, `status`, `created_at`, `updated_at`) VALUES
(1, '99 Songs | The Life of Ram Movie', 4, 'assets/uploads/sliders/images/1726140179_q7fXcrDPJcf6t3rzutaNwTzuKP1 1.webp', 'upload', NULL, NULL, NULL, 'assets/uploads/sliders/videos/1726140179_1701079899_Close shot of a soccer player shooting a penalty - Free Stock Video.mp4', '<p>Unlike offset based pagination, which includes a page number in the query string of the URLs generated by the paginator, cursor based pagination places a &quot;cursor&quot; string in the query string. The cursor is an encoded string containing the location that the next paginated query should start paginating and the direction that it should paginate:</p>', 0, 1, 0, '2024-09-12 05:22:59', '2024-09-12 05:22:59'),
(2, 'Bigil ( transl. Whistle)', 1, 'assets/uploads/sliders/images/1726140355_image.png', 'youtube', 'https://www.youtube.com/watch?v=GR-Ui8-V2M0', NULL, NULL, NULL, '<p>Unlike offset based pagination, which includes a page number in the query string of the URLs generated by the paginator, cursor based pagination places a &quot;cursor&quot; string in the query string. The cursor is an encoded string containing the location that the next paginated query should start paginating and the direction that it should paginate:</p>', 1, 1, 0, '2024-09-12 05:25:55', '2024-09-12 05:31:05'),
(3, 'Titanic (1997)', 3, 'assets/uploads/sliders/images/1726140472_image 20.png', 'other', NULL, NULL, 'https://dai.ly/x8ahgp2', NULL, '<p>Unlike offset based pagination, which includes a page number in the query string of the URLs generated by the paginator, cursor based pagination places a &quot;cursor&quot; string in the query string. The cursor is an encoded string containing the location that the next paginated query should start paginating and the direction that it should paginate:</p>', 0, 1, 0, '2024-09-12 05:27:52', '2024-09-12 05:27:52');

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

--
-- Table structure for table `streaming_urls`
--

CREATE TABLE `streaming_urls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `match_id` bigint(20) UNSIGNED NOT NULL,
  `url` text 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 `streaming_urls`
--

INSERT INTO `streaming_urls` (`id`, `match_id`, `url`, `created_at`, `updated_at`) VALUES
(56, 9, 'https://d2q8p4pe5spbak.cloudfront.net/bpk-tv/9XM/9XM.isml/index.m3u8', '2024-10-01 09:21:28', '2024-10-01 09:21:28'),
(57, 9, 'https://entezeetv.fun/bdcast/hls/index.m3u8?id=5150x44c&e=.m3u8', '2024-10-01 09:21:28', '2024-10-01 09:21:28'),
(58, 9, 'https://vods1.aynaott.com/kidscreation_test/tracks-v1a1/mono.m3u8', '2024-10-01 09:21:28', '2024-10-01 09:21:28'),
(65, 10, 'https://live-stream.utkalbongo.com/utkalbongo/stream2/hls/amarbanglatwolivestream.m3u8', '2024-10-27 04:57:04', '2024-10-27 04:57:04'),
(66, 10, 'https://live-stream.utkalbongo.com/utkalbongo/stream10/hls/amarbangla.m3u8', '2024-10-27 04:57:04', '2024-10-27 04:57:04');

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

--
-- Table structure for table `tvs`
--

CREATE TABLE `tvs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `tv_category_id` bigint(20) UNSIGNED NOT NULL,
  `thumbnail_image` varchar(255) NOT NULL,
  `video_type` enum('upload','youtube','radio','other') NOT NULL COMMENT 'upload: video file, youtube: YouTube URL, radio: Radio URL, other: other URL',
  `youtube_url` varchar(255) DEFAULT NULL,
  `radio_url` varchar(255) DEFAULT NULL,
  `other_url` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT 0,
  `is_slider` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `tvs`
--

INSERT INTO `tvs` (`id`, `title`, `tv_category_id`, `thumbnail_image`, `video_type`, `youtube_url`, `radio_url`, `other_url`, `video`, `description`, `total_views`, `is_slider`, `status`, `created_at`, `updated_at`) VALUES
(2, 'TV 1', 6, 'assets/uploads/tv/images/1727699728_1727682025_1727682023768.png', 'upload', NULL, NULL, NULL, 'assets/uploads/tv/videos/1727699746_1701082471_Chicago City at late afternoon - Free Stock Video.mp4', '<p>Laravel strives to provide an amazing developer experience while providing powerful features such as thorough dependency injection, an expressive database abstraction layer, queues and scheduled jobs, unit and integration testing, and more.</p>', 2, 0, 0, '2024-09-30 12:35:28', '2024-10-02 06:55:06'),
(3, 'TV 2', 7, 'assets/uploads/tv/images/1727699778_1726140724_image (2).png', 'youtube', 'https://youtu.be/USWadiXu5q0', NULL, NULL, NULL, '<p>Laravel strives to provide an amazing developer experience while providing powerful features such as thorough dependency injection, an expressive database abstraction layer, queues and scheduled jobs, unit and integration testing, and more.</p>', 5, 0, 0, '2024-09-30 12:36:18', '2024-10-02 06:54:17');

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

--
-- Table structure for table `tv_categories`
--

CREATE TABLE `tv_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `tv_categories`
--

INSERT INTO `tv_categories` (`id`, `name`, `icon`, `status`, `created_at`, `updated_at`) VALUES
(6, 'Movies', 'assets/uploads/tv-categories/1727695132_movie-clapper-open.png', 0, '2024-09-30 11:18:52', '2024-09-30 11:18:52'),
(7, 'Music', 'assets/uploads/tv-categories/1727695145_musical-note.png', 0, '2024-09-30 11:19:05', '2024-09-30 11:19:05');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: blocked',
  `remember_token` varchar(100) 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 `videos`
--

CREATE TABLE `videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `thumbnail_image` varchar(255) NOT NULL,
  `video_type` enum('upload','youtube','radio','other') NOT NULL COMMENT 'upload: video file, youtube: YouTube URL, radio: Radio URL, other: other URL',
  `youtube_url` varchar(255) DEFAULT NULL,
  `radio_url` varchar(255) DEFAULT NULL,
  `other_url` varchar(255) DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `total_views` int(11) NOT NULL DEFAULT 0,
  `is_slider` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(3) UNSIGNED DEFAULT 0 COMMENT '0: active, 1: inactive',
  `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 `videos`
--

INSERT INTO `videos` (`id`, `title`, `category_id`, `thumbnail_image`, `video_type`, `youtube_url`, `radio_url`, `other_url`, `video`, `description`, `total_views`, `is_slider`, `status`, `created_at`, `updated_at`) VALUES
(1, 'The Greatest of All Time (GOAT) V2 2024 South', 1, 'assets/uploads/videos/images/1726140588_Rectangle 1569.png', 'upload', NULL, NULL, NULL, 'assets/uploads/videos/videos/1726140588_1701081661_Paradise port on an island - Free Stock Video.mp4', '<p>Unlike offset based pagination, which includes a page number in the query string of the URLs generated by the paginator, cursor based pagination places a &quot;cursor&quot; string in the query string. The cursor is an encoded string containing the location that the next paginated query should start paginating and the direction that it should paginate:</p>', 0, 0, 0, '2024-09-12 05:29:48', '2024-09-12 05:29:48'),
(2, 'Download Visfot (2024) Hindi [DDP5.1] WEB', 1, 'assets/uploads/videos/images/1726140675_image (1).png', 'upload', NULL, NULL, NULL, 'assets/uploads/videos/videos/1726140675_1701082471_Chicago City at late afternoon - Free Stock Video.mp4', '<p>Unlike offset based pagination, which includes a page number in the query string of the URLs generated by the paginator, cursor based pagination places a &quot;cursor&quot; string in the query string. The cursor is an encoded string containing the location that the next paginated query should start paginating and the direction that it should paginate:</p>', 2, 0, 0, '2024-09-12 05:31:15', '2024-10-02 06:54:39'),
(3, 'Download Double Ismart (2024) Hindi + Telugu', 1, 'assets/uploads/videos/images/1726140724_image (2).png', 'youtube', 'https://youtu.be/Gtx1pPeKJsA', NULL, NULL, NULL, '<p>Unlike offset based pagination, which includes a page number in the query string of the URLs generated by the paginator, cursor based pagination places a &quot;cursor&quot; string in the query string. The cursor is an encoded string containing the location that the next paginated query should start paginating and the direction that it should paginate:</p>', 3, 0, 0, '2024-09-12 05:32:04', '2024-10-27 09:07:51'),
(4, 'Download Bad Newz (2024) Hindi [DDP5.1]', 3, 'assets/uploads/videos/images/1726140807_image (3).png', 'youtube', 'https://youtu.be/dvu3y8vcZy4', NULL, NULL, NULL, '<p>Unlike offset based pagination, which includes a page number in the query string of the URLs generated by the paginator, cursor based pagination places a &quot;cursor&quot; string in the query string. The cursor is an encoded string containing the location that the next paginated query should start paginating and the direction that it should paginate:</p>', 3, 0, 0, '2024-09-12 05:33:27', '2024-10-27 09:07:45');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_username_unique` (`username`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

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

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

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

--
-- Indexes for table `devices`
--
ALTER TABLE `devices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `devices_device_id_fcm_token_unique` (`device_id`,`fcm_token`),
  ADD KEY `devices_device_id_index` (`device_id`),
  ADD KEY `devices_fcm_token_index` (`fcm_token`);

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

--
-- Indexes for table `email_templates`
--
ALTER TABLE `email_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email_templates_slug_unique` (`slug`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

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

--
-- Indexes for table `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`);

--
-- Indexes for table `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`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pages_slug_unique` (`slug`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `radios`
--
ALTER TABLE `radios`
  ADD PRIMARY KEY (`id`),
  ADD KEY `radios_radio_category_id_foreign` (`radio_category_id`);

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `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`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `streaming_urls`
--
ALTER TABLE `streaming_urls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `streaming_urls_match_id_foreign` (`match_id`);

--
-- Indexes for table `tvs`
--
ALTER TABLE `tvs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tvs_tv_category_id_foreign` (`tv_category_id`);

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

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

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `videos_category_id_foreign` (`category_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

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

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

--
-- Constraints for table `radios`
--
ALTER TABLE `radios`
  ADD CONSTRAINT `radios_radio_category_id_foreign` FOREIGN KEY (`radio_category_id`) REFERENCES `radio_categories` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `sliders`
--
ALTER TABLE `sliders`
  ADD CONSTRAINT `sliders_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `streaming_urls`
--
ALTER TABLE `streaming_urls`
  ADD CONSTRAINT `streaming_urls_match_id_foreign` FOREIGN KEY (`match_id`) REFERENCES `match_models` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tvs`
--
ALTER TABLE `tvs`
  ADD CONSTRAINT `tvs_tv_category_id_foreign` FOREIGN KEY (`tv_category_id`) REFERENCES `tv_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `videos`
--
ALTER TABLE `videos`
  ADD CONSTRAINT `videos_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;
COMMIT;

