--
-- Host: localhost    Database: mondialy
-- ------------------------------------------------------


--
-- Table structure for table `actors`
--

CREATE TABLE `actors` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `biography` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `place_of_birth` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `DOB` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `slug` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `actors`
--


--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ad_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_video` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_location` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_target` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_hold` int DEFAULT NULL,
  `time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `endtime` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ads`
--


--
-- Table structure for table `adsenses`
--

CREATE TABLE `adsenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `ishome` tinyint(1) NOT NULL,
  `isviewall` tinyint(1) NOT NULL,
  `issearch` tinyint(1) NOT NULL,
  `iswishlist` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `adsenses`
--

INSERT INTO `adsenses` VALUES (1,'<script type=\"text/javascript\">\r\ngoogle_ad_client = \"\";  \r\ngoogle_ad_slot = \"99*****99\"; \r\ngoogle_ad_width = 728;\r\ngoogle_ad_height =  90; \r\n\n</script>',0,0,0,0,0,'2019-09-09 10:43:44','2020-02-11 09:08:26');

--
-- Table structure for table `app_configs`
--

CREATE TABLE `app_configs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stripe_payment` tinyint(1) NOT NULL DEFAULT '0',
  `paypal_payment` tinyint(1) NOT NULL DEFAULT '0',
  `razorpay_payment` tinyint(1) NOT NULL DEFAULT '0',
  `brainetree_payment` tinyint(1) NOT NULL DEFAULT '0',
  `paystack_payment` tinyint(1) NOT NULL DEFAULT '0',
  `bankdetails` tinyint(1) NOT NULL DEFAULT '0',
  `fb_check` tinyint(1) NOT NULL DEFAULT '0',
  `google_login` tinyint(1) NOT NULL DEFAULT '0',
  `git_lab_check` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `inapp_payment` tinyint(1) NOT NULL DEFAULT '0',
  `push_key` tinyint(1) NOT NULL DEFAULT '0',
  `remove_ads` tinyint(1) NOT NULL DEFAULT '0',
  `paytm_payment` tinyint(1) NOT NULL DEFAULT '0',
  `amazon_login` tinyint(1) NOT NULL DEFAULT '0',
  `is_admob` tinyint(1) NOT NULL DEFAULT '0',
  `instamojo_payment` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_configs`
--

INSERT INTO `app_configs` VALUES (1,'applogo_1606642921logo.png','Nexthour',0,0,0,0,0,0,0,0,0,NULL,'2020-11-29 13:12:01',0,0,0,0,0,0,0);

--
-- Table structure for table `app_sliders`
--

CREATE TABLE `app_sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `movie_id` int unsigned DEFAULT NULL,
  `tv_series_id` int unsigned DEFAULT NULL,
  `slide_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `position` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `app_sliders_movie_id_foreign` (`movie_id`),
  KEY `app_sliders_tv_series_id_foreign` (`tv_series_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `app_sliders`
--

INSERT INTO `app_sliders` VALUES (1,NULL,NULL,'app_slide_1606642528movie.jpg',1,1,'2020-11-29 12:47:00','2020-11-29 13:05:28'),(2,NULL,NULL,'app_slide_1606642578tvshow.jpg',1,2,'2020-11-29 13:06:18','2020-11-29 13:06:18');

--
-- Table structure for table `audio_genre`
--

CREATE TABLE `audio_genre` (
  `genre_id` int NOT NULL,
  `audio_id` int NOT NULL,
  `updated_at` date DEFAULT NULL,
  `created_at` int DEFAULT NULL,
  UNIQUE KEY `genre_id` (`genre_id`,`audio_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `audio_genre`
--

INSERT INTO `audio_genre` VALUES (11,16,'2022-10-31',2022);

--
-- Table structure for table `audio_languages`
--

CREATE TABLE `audio_languages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `language` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audio_languages`
--


--
-- Table structure for table `auth_customizes`
--

CREATE TABLE `auth_customizes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auth_customizes`
--

INSERT INTO `auth_customizes` VALUES (1,'{\"en\":\"auth_page1604309119login.jpg\"}','{\"en\":\"<h1>Welcome to<br \\/>\\r\\nNext Hour<\\/h1>\\r\\n\\r\\n<h2>Are you ready to join the elite?<\\/h2>\"}',NULL,'2020-11-02 12:55:19');

--
-- Table structure for table `blog_menu`
--

CREATE TABLE `blog_menu` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int NOT NULL,
  `blog_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_menu`
--


--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `title` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `poster` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--


--
-- Table structure for table `buttons`
--

CREATE TABLE `buttons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rightclick` tinyint(1) NOT NULL DEFAULT '1',
  `inspect` tinyint(1) DEFAULT NULL,
  `goto` tinyint(1) NOT NULL DEFAULT '1',
  `color` tinyint(1) NOT NULL DEFAULT '1',
  `uc_browser` tinyint(1) NOT NULL DEFAULT '1',
  `comming_soon` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `commingsoon_enabled_ip` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ip_block` tinyint(1) NOT NULL DEFAULT '1',
  `block_ips` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `maintenance` tinyint(1) NOT NULL DEFAULT '1',
  `comming_soon_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remove_subscription` tinyint(1) NOT NULL DEFAULT '0',
  `protip` tinyint(1) NOT NULL DEFAULT '1',
  `multiplescreen` tinyint(1) NOT NULL DEFAULT '0',
  `two_factor` tinyint(1) NOT NULL DEFAULT '0',
  `countviews` tinyint(1) NOT NULL DEFAULT '0',
  `remove_ads` tinyint(1) NOT NULL DEFAULT '0',
  `is_toprated` tinyint(1) NOT NULL DEFAULT '0',
  `toprated_count` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `remove_thumbnail` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `buttons`
--

INSERT INTO `buttons` VALUES (1,0,1,1,0,1,0,'2018-07-31 09:30:00','2022-10-31 13:40:55',NULL,0,NULL,1,NULL,1,1,0,0,0,0,0,NULL,0);

--
-- Table structure for table `callback_addresses`
--

CREATE TABLE `callback_addresses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pubkey` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ipn_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `callback_addresses_address_currency_unique` (`address`,`currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `callback_addresses`
--


--
-- Table structure for table `color_schemes`
--

CREATE TABLE `color_schemes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `color_scheme` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_navigation_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_navigation_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `default_text_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_text_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `default_text_on_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_text_on_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_bgcolor` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_bgcolor` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_bgcolor_on_hover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_bgcolor_on_hover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_color_on_hover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_color_on_hover` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `default_footer_background_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_footer_background_color` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `color_schemes`
--

INSERT INTO `color_schemes` VALUES (1,'dark','#111111FA',NULL,'#48A3C6',NULL,'#90DFFE',NULL,'#111',NULL,'#FFF',NULL,'#48A3C6',NULL,'#FFF',NULL,'#111',NULL,NULL,'2021-08-17 13:54:15');

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `blog_id` int NOT NULL,
  `comment` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--


--
-- Table structure for table `conversions`
--

CREATE TABLE `conversions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `to` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `conversions_ref_id_unique` (`ref_id`),
  KEY `conversions_from_index` (`from`),
  KEY `conversions_to_index` (`to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `conversions`
--


--
-- Table structure for table `coupon_applies`
--

CREATE TABLE `coupon_applies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `coupon_id` int NOT NULL,
  `redeem` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupon_applies`
--


--
-- Table structure for table `coupon_codes`
--

CREATE TABLE `coupon_codes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `coupon_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `percent_off` double(8,2) DEFAULT NULL,
  `currency` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount_off` double(8,2) DEFAULT NULL,
  `duration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'once',
  `max_redemptions` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redeem_by` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `in_stripe` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupon_codes`
--


--
-- Table structure for table `cps_cpp`
--

CREATE TABLE `cps_cpp` (
  `userid` int NOT NULL,
  `expire` int NOT NULL,
  `info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `plan` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cps_cpp`
--


--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `format` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `currencies_code_index` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES (1,'Indian Rupee','INR','₹','1,0.00₹','75.298292','[\"flutterrave\",\"instamojo\",\"paytm\",\"mollie\",\"cashfree\",\"razorpay\"]',0,'2021-09-08 15:11:27','2021-10-18 09:30:00'),(2,'US Dollar','USD','$','$1,0.00','1','[\"stripe\",\"paypal\",\"braintree\",\"omise\",\"payhere\",\"flutterrave\",\"mollie\"]',0,'2021-09-08 15:13:00','2021-10-18 09:30:00'),(3,'Euro','EUR','€','1.0,00 €','0.863677','[\"stripe\",\"paypal\",\"braintree\",\"omise\",\"payhere\",\"flutterrave\"]',0,'2021-09-08 15:13:39','2021-10-18 09:30:00'),(4,'Sri Lanka Rupee','LKR','₨','₨ 1,0.','202.450844','[\"payhere\"]',0,'2021-09-08 15:52:46','2021-10-18 09:30:00'),(5,'UAE Dirham','AED','دإ‏','دإ‏ 1,0.00','3.6731','[\"mollie\",\"cashfree\"]',0,'2021-09-09 13:58:19','2021-10-18 09:30:00'),(6,'Nigeria, Naira','NGN','₦','₦1,0.00','411.92','[\"stripe\",\"flutterrave\",\"paystack\"]',0,'2021-09-13 13:03:42','2021-10-18 09:30:00'),(7,'Angola, Kwanza','AOA','Kz','Kz1,0.00','597.698','[\"stripe\"]',0,'2021-10-01 12:01:26','2021-10-18 09:30:00'),(8,'Tunisian Dinar','TND','د.ت.‏','د.ت.‏ 1,0.000','2.8235','[\"stripe\"]',0,'2021-10-04 10:33:43','2021-10-18 09:30:00'),(9,'Kenyan Shilling','KES','S','S1,0.00','110.9','[\"stripe\"]',0,'2021-10-04 11:46:10','2021-10-18 09:30:00');

--
-- Table structure for table `custom_pages`
--

CREATE TABLE `custom_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `in_show_menu` tinyint(1) DEFAULT NULL,
  `detail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `custom_pages`
--


--
-- Table structure for table `deposits`
--

CREATE TABLE `deposits` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `txn_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL,
  `status_text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirms` tinyint unsigned NOT NULL,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amounti` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fee` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feei` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `deposits_txn_id_unique` (`txn_id`),
  KEY `deposits_address_index` (`address`),
  CONSTRAINT `deposits_address_foreign` FOREIGN KEY (`address`) REFERENCES `callback_addresses` (`address`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deposits`
--


--
-- Table structure for table `directors`
--

CREATE TABLE `directors` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `biography` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `place_of_birth` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `DOB` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `slug` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `directors`
--


--
-- Table structure for table `donater_lists`
--

CREATE TABLE `donater_lists` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `donor_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `donater_lists`
--


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

CREATE TABLE `episodes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `seasons_id` int unsigned NOT NULL,
  `tmdb_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `episode_no` int DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tmdb` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `a_language` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` tinyint(1) DEFAULT NULL,
  `released` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'E',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `episodes_seasons_id_foreign` (`seasons_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `episodes`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `question` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `answer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--


--
-- Table structure for table `front_slider_updates`
--

CREATE TABLE `front_slider_updates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `item_show` int unsigned DEFAULT NULL,
  `orderby` int DEFAULT '1',
  `sliderview` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `front_slider_updates`
--


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

CREATE TABLE `genres` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `genres` VALUES (11,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u0623\\u0648\\u0644\\u0649\"}','genre_166721225211.png',1,'2022-10-30 14:46:27','2022-10-31 16:00:52'),(13,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u062b\\u0627\\u0646\\u064a\\u0629\"}','genre_166721421522.png',2,'2022-10-30 15:10:29','2022-10-31 16:33:35'),(14,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u062b\\u0627\\u0644\\u062b\\u0629\"}','genre_16672142393.jpg',3,'2022-10-30 15:10:45','2022-10-31 16:33:59'),(15,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u0631\\u0627\\u0628\\u0639\\u0629\"}','genre_16672142604.png',4,'2022-10-30 15:10:58','2022-10-31 16:34:20'),(16,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u062e\\u0627\\u0645\\u0633\\u0629\"}','genre_16672142745.png',5,'2022-10-30 15:11:13','2022-10-31 16:34:34'),(17,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u0633\\u0627\\u062f\\u0633\\u0629\"}','genre_16672142866.png',6,'2022-10-30 15:11:26','2022-10-31 16:34:46'),(18,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u0633\\u0627\\u0628\\u0639\\u0629\"}','genre_16672142987.png',7,'2022-10-30 15:11:38','2022-10-31 16:34:58'),(19,'{\"ar\":\"\\u0627\\u0644\\u0645\\u062c\\u0645\\u0648\\u0639\\u0629 \\u0627\\u0644\\u062b\\u0627\\u0645\\u0646\\u0629\"}','genre_16672143108.png',8,'2022-10-30 15:11:52','2022-10-31 16:35:10'),(21,'{\"ar\":\"\\u062a\\u062c\\u0631\\u0628\\u0629 \\u0628\\u062b \\u062d\\u064a\"}',NULL,9,'2022-11-06 17:10:36','2022-11-06 17:10:36');

--
-- Table structure for table `google_ads`
--

CREATE TABLE `google_ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `google_ad_client` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_slot` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_width` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_height` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_starttime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_endtime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `google_ads`
--


--
-- Table structure for table `home_blocks`
--

CREATE TABLE `home_blocks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `movie_id` int DEFAULT NULL,
  `tv_series_id` int DEFAULT NULL,
  `is_active` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_blocks`
--


--
-- Table structure for table `home_sliders`
--

CREATE TABLE `home_sliders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `movie_id` int unsigned DEFAULT NULL,
  `tv_series_id` int unsigned DEFAULT NULL,
  `slide_image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  `position` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `home_sliders_movie_id_foreign` (`movie_id`),
  KEY `home_sliders_tv_series_id_foreign` (`tv_series_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_sliders`
--

INSERT INTO `home_sliders` VALUES (3,NULL,NULL,'slide_1667211649audi4.png',1,3,'2022-10-31 15:50:50','2022-10-31 15:50:50'),(4,4,NULL,'slide_1667986053audi.png',1,2,'2022-11-09 14:57:34','2022-11-09 14:57:34'),(6,NULL,NULL,'slide_1667986157DAY2.jpg',1,3,'2022-11-09 14:59:17','2022-11-09 14:59:17'),(7,NULL,NULL,'slide_1667986165DAY3.jpg',1,4,'2022-11-09 14:59:25','2022-11-09 14:59:25'),(8,NULL,NULL,'slide_1667986329ff.jpg',1,5,'2022-11-09 15:02:09','2022-11-09 15:02:09');

--
-- Table structure for table `ipns`
--

CREATE TABLE `ipns` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ipn_version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ipn_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ipn_mode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `merchant` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ipn_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txn_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  `status_text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `confirms` tinyint unsigned DEFAULT NULL,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amounti` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fee` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feei` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buyer_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `send_tx` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_confirms` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ipns_ipn_id_unique` (`ipn_id`),
  KEY `ipns_address_index` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ipns`
--


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

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(1) NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `labels`
--


--
-- Table structure for table `landing_pages`
--

CREATE TABLE `landing_pages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heading` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `button` tinyint(1) NOT NULL DEFAULT '1',
  `button_text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_link` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `left` tinyint(1) NOT NULL DEFAULT '1',
  `position` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_pages`
--

INSERT INTO `landing_pages` VALUES (1,'landing_page_1604308741home_1.jpg','{\"en\":\"Welcome!  Join Next Hour\"}','{\"en\":\"Join Next Hour to watch the most recent motion pictures, elite TV appears and grant winning Next Hour membership at simply least cost.\"}',1,'{\"en\":\"Join Next Hour\"}','login',0,1,'2020-11-02 12:29:21','2020-11-02 12:49:01'),(2,'landing_page_1604308752home_2.jpg','{\"en\":\"Don\'t Miss TV Shows\"}','{\"en\":\"With your Next Hour membership, you approach select US and all TV shows, grant winning Next Hour Original Series and kids and children shows.\"}',1,'{\"en\":\"Register Now\"}','register',1,2,'2020-11-02 12:29:39','2020-11-02 12:49:12'),(3,'landing_page_1604308763home_3.jpg','{\"en\":\"Membership for Movies & TV shows\"}','{\"en\":\"Notwithstanding boundless gushing, your Next Hour membership incorporates elite Bollywood, Hollywood films, US and all TV shows, grant winning Next Hour Series and kids shows.\"}',1,'{\"en\":\"Login Now\"}','login',0,3,'2020-11-02 12:30:01','2020-11-02 12:49:23'),(4,'landing_page_1604308776home_4.jpg','{\"en\":\"Kids Special\"}','{\"en\":\"With simple to utilize parental controls and a committed children page, you can appreciate secure, advertisement free children and kids diversion. Children and kids can appreciate famous TV shows.\"}',1,'{\"en\":\"Get Now\"}','register',0,4,'2020-11-02 12:30:18','2020-11-02 12:49:36');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `local` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `def` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `rtl` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` VALUES (1,'en','English',0,'2020-11-02 12:19:55','2022-09-05 15:11:46',0),(2,'ar','arabic',1,'2022-09-05 15:11:46','2022-09-05 15:11:46',1);

--
-- Table structure for table `likes`
--

CREATE TABLE `likes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `blog_id` int NOT NULL,
  `added` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `likes`
--


--
-- Table structure for table `live_events`
--

CREATE TABLE `live_events` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `iframeurl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ready_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  `thumbnail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `poster` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `genre_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `organized_by` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `live_events`
--


--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `log` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `log`
--


--
-- Table structure for table `manual_payment_methods`
--

CREATE TABLE `manual_payment_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `manual_payment_methods_payment_name_unique` (`payment_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manual_payment_methods`
--


--
-- Table structure for table `manual_payments`
--

CREATE TABLE `manual_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `payment_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `price` double(8,2) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_from` datetime DEFAULT NULL,
  `subscription_to` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manual_payments`
--


--
-- Table structure for table `mass_withdrawals`
--

CREATE TABLE `mass_withdrawals` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mass_withdrawals`
--


--
-- Table structure for table `menu_genre_shows`
--

CREATE TABLE `menu_genre_shows` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int unsigned NOT NULL,
  `menu_section_id` int unsigned NOT NULL,
  `genre_id` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_genre_shows`
--

INSERT INTO `menu_genre_shows` VALUES (24,7,2,21);

--
-- Table structure for table `menu_sections`
--

CREATE TABLE `menu_sections` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int unsigned DEFAULT NULL,
  `section_id` int unsigned DEFAULT NULL,
  `item_limit` int unsigned DEFAULT NULL,
  `view` int unsigned NOT NULL DEFAULT '1',
  `order` int unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_sections`
--

INSERT INTO `menu_sections` VALUES (30,2,2,100,1,1),(31,2,11,NULL,1,1),(32,7,2,5,0,1);

--
-- Table structure for table `menu_videos`
--

CREATE TABLE `menu_videos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int unsigned NOT NULL,
  `movie_id` int unsigned DEFAULT NULL,
  `tv_series_id` int unsigned DEFAULT NULL,
  `live_event_id` int DEFAULT NULL,
  `audio_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_videos_menu_id_foreign` (`menu_id`),
  KEY `menu_videos_movie_id_foreign` (`movie_id`),
  KEY `menu_videos_tv_series_id_foreign` (`tv_series_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_videos`
--

INSERT INTO `menu_videos` VALUES (1,1,NULL,NULL,NULL,NULL,'2022-09-05 15:20:30','2022-09-05 15:20:30'),(2,2,NULL,NULL,NULL,NULL,'2022-09-05 15:59:39','2022-09-05 15:59:39'),(3,2,2,NULL,NULL,NULL,'2022-10-31 16:49:08','2022-10-31 16:49:08');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (2,'{\"ar\":\"World Cup 2022\"}','world-cup-2022',1,'2022-09-05 15:59:23','2022-11-06 15:40:12'),(7,'{\"ar\":\"Test\"}','test',2,'2022-11-07 18:36:25','2022-11-07 18:36:25');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2016_06_01_000001_create_oauth_auth_codes_table',1),(2,'2016_06_01_000002_create_oauth_access_tokens_table',1),(3,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(4,'2016_06_01_000004_create_oauth_clients_table',1),(5,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(6,'2017_09_15_051156_setup_coinpayment_tables',1),(7,'2018_03_24_032432_create_callback_address_table',1),(8,'2018_05_07_123123_fix_transactions_table',1),(9,'2018_05_08_037214_cp_create_mass_withdrawal',1),(10,'2018_07_01_112608_add_column_dest_tag_to_transactions_table',1),(11,'2018_08_29_205156_create_translations_table',1),(12,'2019_05_03_000002_create_subscriptions_table',1),(13,'2019_05_03_000003_create_subscription_items_table',1),(14,'2020_06_14_180448_create_actors_table',1),(15,'2020_06_14_180448_create_ads_table',1),(16,'2020_06_14_180448_create_adsenses_table',1),(17,'2020_06_14_180448_create_audio_languages_table',1),(18,'2020_06_14_180448_create_auth_customizes_table',1),(19,'2020_06_14_180448_create_blog_menu_table',1),(20,'2020_06_14_180448_create_blogs_table',1),(21,'2020_06_14_180448_create_buttons_table',1),(22,'2020_06_14_180448_create_comments_table',1),(23,'2020_06_14_180448_create_configs_table',1),(24,'2020_06_14_180448_create_coupon_codes_table',1),(25,'2020_06_14_180448_create_cps_cpp_table',1),(26,'2020_06_14_180448_create_custom_pages_table',1),(27,'2020_06_14_180448_create_directors_table',1),(28,'2020_06_14_180448_create_donater_lists_table',1),(29,'2020_06_14_180448_create_episodes_table',1),(30,'2020_06_14_180448_create_faqs_table',1),(31,'2020_06_14_180448_create_front_slider_updates_table',1),(32,'2020_06_14_180448_create_genres_table',1),(33,'2020_06_14_180448_create_home_blocks_table',1),(34,'2020_06_14_180448_create_home_sliders_table',1),(35,'2020_06_14_180448_create_home_translations_table',1),(36,'2020_06_14_180448_create_jobs_table',1),(37,'2020_06_14_180448_create_landing_pages_table',1),(38,'2020_06_14_180448_create_languages_table',1),(39,'2020_06_14_180448_create_likes_table',1),(40,'2020_06_14_180448_create_live_events_table',1),(41,'2020_06_14_180448_create_menu_sections_table',1),(42,'2020_06_14_180448_create_menu_videos_table',1),(43,'2020_06_14_180448_create_menus_table',1),(44,'2020_06_14_180448_create_movie_comments_table',1),(45,'2020_06_14_180448_create_movie_series_table',1),(46,'2020_06_14_180448_create_movie_subcomments_table',1),(47,'2020_06_14_180448_create_movies_table',1),(48,'2020_06_14_180448_create_multiple_links_table',1),(49,'2020_06_14_180448_create_multiplescreens_table',1),(50,'2020_06_14_180448_create_notifications_table',1),(51,'2020_06_14_180448_create_package_menu_table',1),(52,'2020_06_14_180448_create_packages_table',1),(53,'2020_06_14_180448_create_password_resets_table',1),(54,'2020_06_14_180448_create_paypal_subscriptions_table',1),(55,'2020_06_14_180448_create_plans_table',1),(56,'2020_06_14_180448_create_player_settings_table',1),(57,'2020_06_14_180448_create_pricing_texts_table',1),(58,'2020_06_14_180448_create_seasons_table',1),(59,'2020_06_14_180448_create_seos_table',1),(60,'2020_06_14_180448_create_sessions_table',1),(61,'2020_06_14_180448_create_social_icons_table',1),(62,'2020_06_14_180448_create_subcomments_table',1),(63,'2020_06_14_180448_create_subtitles_table',1),(64,'2020_06_14_180448_create_tv_series_table',1),(65,'2020_06_14_180448_create_user_ratings_table',1),(66,'2020_06_14_180448_create_users_table',1),(67,'2020_06_14_180448_create_videolinks_table',1),(68,'2020_06_14_180448_create_views_table',1),(69,'2020_06_14_180448_create_watch_histories_table',1),(70,'2020_06_14_180448_create_wishlists_table',1),(71,'2020_06_14_180452_add_foreign_keys_to_episodes_table',1),(72,'2020_06_14_180452_add_foreign_keys_to_home_sliders_table',1),(73,'2020_06_22_122007_create_audio_table',1),(74,'2020_06_24_150735_create_manual_payments_table',1),(75,'2020_06_25_115048_create_app_configs_table',1),(76,'2020_06_25_132738_create_splash_screens_table',1),(77,'2020_06_25_180556_create_app_sliders_table',1),(78,'2020_06_29_102308_commingsoon_enabled_ip_to_buttons_table',1),(79,'2020_10_31_114942_add_column_to_player_settings_table',1),(80,'2020_11_02_113133_add_columns',1),(81,'2020_11_02_114440_create_reminder_mails_table',1),(82,'2020_11_07_135552_create_chat_setting_table',1),(83,'2021_06_05_112917_add_columns_in_users_table_custom',1),(84,'2021_06_05_130920_add_columns_existing',1),(85,'2020_11_06_114837_create_table',2),(86,'2020_11_06_115740_add_column_table',2),(87,'2020_12_03_153005_add_column_update_31_table',3),(88,'2020_12_24_121353_add_column_update_v3_2',4),(89,'2021_03_07_162535_create_coupon_applies_table',4),(90,'2021_03_22_112446_create_menu_genre_shows_table',5),(91,'2021_04_17_131827_create_google_ads_table',5),(92,'2021_05_03_144635_add_column_update_v3_3',5),(93,'2020_12_02_123844_create_manual_payment_methods_table',6),(94,'2021_06_13_182042_remove_column_update_v3_4',6),(95,'2021_06_13_185438_add_column_update_v3_4',6),(96,'2021_06_12_145328_create_package_features_table',7),(97,'2021_06_18_112730_add_column_update_v4_0',7),(98,'2021_07_03_084019_create_color_schemes_table',7),(99,'2021_07_20_094823_create_labels_table',7),(100,'2021_08_20_183347_remove_column_v4_0',7),(101,'2013_11_26_161501_create_currency_table',8),(102,'2021_08_30_180428_create_new_permission_tables',8),(103,'2021_08_30_180428_create_permission_tables',8),(104,'2021_09_04_110417_add_column_update_v_4_1',8),(105,'2021_09_17_182123_remove_column_v4_1',8);

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

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


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

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `model_has_roles` VALUES (1,'App\\User',1);

--
-- Table structure for table `movie_comments`
--

CREATE TABLE `movie_comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `movie_id` int DEFAULT NULL,
  `tv_series_id` int DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `movie_comments`
--


--
-- Table structure for table `movie_series`
--

CREATE TABLE `movie_series` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `movie_id` int unsigned NOT NULL,
  `series_movie_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `movie_series_movie_id_foreign` (`movie_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `movie_series`
--


--
-- Table structure for table `movie_subcomments`
--

CREATE TABLE `movie_subcomments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `comment_id` int DEFAULT NULL,
  `reply` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `movie_subcomments`
--


--
-- Table structure for table `multiple_links`
--

CREATE TABLE `multiple_links` (
  `id` int NOT NULL AUTO_INCREMENT,
  `movie_id` int DEFAULT NULL,
  `episode_id` int DEFAULT NULL,
  `download` tinyint(1) NOT NULL,
  `quality` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `clicks` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `multiple_links`
--


--
-- Table structure for table `multiplescreens`
--

CREATE TABLE `multiplescreens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `screen1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen3` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen4` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned NOT NULL,
  `activescreen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen_1_used` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `screen_2_used` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `screen_3_used` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `screen_4_used` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `device_mac_1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_mac_2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_mac_3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_mac_4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_1` int DEFAULT NULL,
  `download_2` int DEFAULT NULL,
  `download_3` int DEFAULT NULL,
  `download_4` int DEFAULT NULL,
  `pkg_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `multiplescreens`
--


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

CREATE TABLE `notifications` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `notifiable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `movie_id` int DEFAULT NULL,
  `tv_id` int DEFAULT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2019-12-09 07:59:27','2019-12-09 07:59:27');

--
-- Table structure for table `package_features`
--

CREATE TABLE `package_features` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_features`
--


--
-- Table structure for table `package_menu`
--

CREATE TABLE `package_menu` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` int NOT NULL,
  `pkg_id` int NOT NULL,
  `package_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `package_menu`
--


--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `plan_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `interval` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `interval_count` int DEFAULT NULL,
  `trial_period_days` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `screens` int unsigned NOT NULL DEFAULT '1',
  `download` tinyint(1) NOT NULL DEFAULT '0',
  `downloadlimit` int DEFAULT NULL,
  `delete_status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `free` tinyint(1) NOT NULL DEFAULT '0',
  `feature` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ads_in_web` tinyint(1) NOT NULL DEFAULT '0',
  `ads_in_app` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--


--
-- Table structure for table `paypal_subscriptions`
--

CREATE TABLE `paypal_subscriptions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `payment_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `package_id` int DEFAULT NULL,
  `price` double(8,2) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `method` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscription_from` datetime DEFAULT NULL,
  `subscription_to` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `paypal_subscriptions`
--


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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'users.view','web','2021-09-01 10:50:34','2021-09-01 10:50:34'),(2,'users.create','web','2021-09-01 10:50:34','2021-09-01 10:50:34'),(3,'users.edit','web','2021-09-01 10:50:34','2021-09-01 10:50:34'),(4,'users.delete','web','2021-09-01 10:50:34','2021-09-01 10:50:34'),(5,'menu.view','web','2021-09-01 11:08:10','2021-09-01 11:08:10'),(6,'menu.create','web','2021-09-01 11:08:10','2021-09-01 11:08:10'),(7,'menu.edit','web','2021-09-01 11:08:10','2021-09-01 11:08:10'),(8,'menu.delete','web','2021-09-01 11:08:10','2021-09-01 11:08:10'),(9,'movies.view','web','2021-09-02 10:14:20','2021-09-02 10:14:20'),(10,'movies.create','web','2021-09-02 10:14:20','2021-09-02 10:14:20'),(11,'movies.edit','web','2021-09-02 10:14:20','2021-09-02 10:14:20'),(12,'movies.delete','web','2021-09-02 10:14:20','2021-09-02 10:14:20'),(13,'tvseries.view','web','2021-09-02 10:14:28','2021-09-02 10:14:28'),(14,'tvseries.create','web','2021-09-02 10:14:28','2021-09-02 10:14:28'),(15,'tvseries.edit','web','2021-09-02 10:14:28','2021-09-02 10:14:28'),(16,'tvseries.delete','web','2021-09-02 10:14:29','2021-09-02 10:14:29'),(17,'livetv.view','web','2021-09-02 10:14:37','2021-09-02 10:14:37'),(18,'livetv.create','web','2021-09-02 10:14:37','2021-09-02 10:14:37'),(19,'livetv.edit','web','2021-09-02 10:14:37','2021-09-02 10:14:37'),(20,'livetv.delete','web','2021-09-02 10:14:37','2021-09-02 10:14:37'),(21,'liveevent.view','web','2021-09-02 10:14:44','2021-09-02 10:14:44'),(22,'liveevent.create','web','2021-09-02 10:14:44','2021-09-02 10:14:44'),(23,'liveevent.edit','web','2021-09-02 10:14:44','2021-09-02 10:14:44'),(24,'liveevent.delete','web','2021-09-02 10:14:44','2021-09-02 10:14:44'),(25,'audio.view','web','2021-09-02 10:14:55','2021-09-02 10:14:55'),(26,'audio.create','web','2021-09-02 10:14:55','2021-09-02 10:14:55'),(27,'audio.edit','web','2021-09-02 10:14:55','2021-09-02 10:14:55'),(28,'audio.delete','web','2021-09-02 10:14:55','2021-09-02 10:14:55'),(29,'package.view','web','2021-09-02 10:17:22','2021-09-02 10:17:22'),(30,'package.create','web','2021-09-02 10:17:23','2021-09-02 10:17:23'),(31,'package.edit','web','2021-09-02 10:17:23','2021-09-02 10:17:23'),(32,'package.delete','web','2021-09-02 10:17:23','2021-09-02 10:17:23'),(33,'blog.view','web','2021-09-02 10:17:53','2021-09-02 10:17:53'),(34,'blog.create','web','2021-09-02 10:17:53','2021-09-02 10:17:53'),(35,'blog.edit','web','2021-09-02 10:17:53','2021-09-02 10:17:53'),(36,'blog.delete','web','2021-09-02 10:17:54','2021-09-02 10:17:54'),(37,'coupon.view','web','2021-09-02 10:19:58','2021-09-02 10:19:58'),(38,'coupon.create','web','2021-09-02 10:19:58','2021-09-02 10:19:58'),(39,'coupon.edit','web','2021-09-02 10:19:58','2021-09-02 10:19:58'),(40,'coupon.delete','web','2021-09-02 10:19:58','2021-09-02 10:19:58'),(41,'addon-manager.manage','web','2021-09-02 10:40:25','2021-09-02 10:40:25'),(42,'actor.view','web','2021-09-02 14:44:09','2021-09-02 14:44:09'),(43,'actor.create','web','2021-09-02 14:44:09','2021-09-02 14:44:09'),(44,'actor.edit','web','2021-09-02 14:44:10','2021-09-02 14:44:10'),(45,'actor.delete','web','2021-09-02 14:44:10','2021-09-02 14:44:10'),(46,'genre.view','web','2021-09-02 14:44:19','2021-09-02 14:44:19'),(47,'genre.create','web','2021-09-02 14:44:19','2021-09-02 14:44:19'),(48,'genre.edit','web','2021-09-02 14:44:19','2021-09-02 14:44:19'),(49,'genre.delete','web','2021-09-02 14:44:19','2021-09-02 14:44:19'),(50,'director.view','web','2021-09-02 14:44:48','2021-09-02 14:44:48'),(51,'director.create','web','2021-09-02 14:44:48','2021-09-02 14:44:48'),(52,'director.edit','web','2021-09-02 14:44:49','2021-09-02 14:44:49'),(53,'director.delete','web','2021-09-02 14:44:49','2021-09-02 14:44:49'),(54,'label.view','web','2021-09-02 14:45:23','2021-09-02 14:45:23'),(55,'label.create','web','2021-09-02 14:45:23','2021-09-02 14:45:23'),(56,'label.edit','web','2021-09-02 14:45:23','2021-09-02 14:45:23'),(57,'label.delete','web','2021-09-02 14:45:23','2021-09-02 14:45:23'),(58,'audiolanguage.view','web','2021-09-02 15:07:35','2021-09-02 15:07:35'),(59,'audiolanguage.create','web','2021-09-02 15:07:35','2021-09-02 15:07:35'),(60,'audiolanguage.edit','web','2021-09-02 15:07:35','2021-09-02 15:07:35'),(61,'audiolanguage.delete','web','2021-09-02 15:07:36','2021-09-02 15:07:36'),(62,'manual-payment.view','web','2021-09-02 15:49:38','2021-09-02 15:49:38'),(63,'manual-payment.create','web','2021-09-02 15:49:38','2021-09-02 15:49:38'),(64,'manual-payment.edit','web','2021-09-02 15:49:38','2021-09-02 15:49:38'),(65,'manual-payment.delete','web','2021-09-02 15:49:38','2021-09-02 15:49:38'),(66,'pages.view','web','2021-09-02 15:49:51','2021-09-02 15:49:51'),(67,'pages.create','web','2021-09-02 15:49:51','2021-09-02 15:49:51'),(68,'pages.edit','web','2021-09-02 15:49:52','2021-09-02 15:49:52'),(69,'pages.delete','web','2021-09-02 15:49:52','2021-09-02 15:49:52'),(70,'faq.view','web','2021-09-02 15:50:01','2021-09-02 15:50:01'),(71,'faq.create','web','2021-09-02 15:50:01','2021-09-02 15:50:01'),(72,'faq.edit','web','2021-09-02 15:50:01','2021-09-02 15:50:01'),(73,'faq.delete','web','2021-09-02 15:50:02','2021-09-02 15:50:02'),(74,'site-settings.language','web','2021-09-02 15:52:36','2021-09-02 15:52:36'),(75,'pushnotification.settings','web','2021-09-02 15:53:18','2021-09-02 15:53:18'),(76,'front-settings.sliders','web','2021-09-02 15:54:07','2021-09-02 15:54:07'),(77,'reports.viewtraker','web','2021-09-02 15:54:38','2021-09-02 15:54:38'),(78,'site-settings.genral-settings','web','2021-09-02 15:54:54','2021-09-02 15:54:54'),(79,'site-settings.mail-settings','web','2021-09-02 15:55:10','2021-09-02 15:55:10'),(80,'site-settings.social-login-settings','web','2021-09-02 15:55:48','2021-09-02 15:55:48'),(81,'site-settings.style-settings','web','2021-09-02 15:58:12','2021-09-02 15:58:12'),(82,'site-settings.seo','web','2021-09-02 15:58:31','2021-09-02 15:58:31'),(83,'comment-settings.comments','web','2021-09-04 12:33:08','2021-09-04 12:33:08'),(84,'help.db-backup','web','2021-09-04 12:33:42','2021-09-04 12:33:42'),(85,'producer-content.manage','web','2021-09-04 12:34:07','2021-09-04 12:34:07'),(86,'notification.manage','web','2021-09-04 12:34:33','2021-09-04 12:34:33'),(87,'front-settings.landing-page','web','2021-09-04 12:35:38','2021-09-04 12:35:38'),(88,'front-settings.auth-customization','web','2021-09-04 12:36:46','2021-09-04 12:36:46'),(89,'front-settings.short-promo','web','2021-09-04 12:37:17','2021-09-04 12:37:17'),(90,'site-settings.player-setting','web','2021-09-04 12:43:34','2021-09-04 12:43:34'),(91,'site-settings.pwa','web','2021-09-04 12:48:59','2021-09-04 12:48:59'),(92,'comment-settings.subcomments','web','2021-09-04 15:32:14','2021-09-04 15:32:14'),(93,'site-settings.color-option','web','2021-09-04 15:35:06','2021-09-04 15:35:06'),(94,'site-settings.adsense','web','2021-09-04 15:35:25','2021-09-04 15:35:25'),(95,'site-settings.chat-setting','web','2021-09-04 15:35:41','2021-09-04 15:35:41'),(96,'site-settings.api-settings','web','2021-09-04 15:36:05','2021-09-04 15:36:05'),(97,'site-settings.termsandcondition','web','2021-09-04 15:36:44','2021-09-04 15:36:44'),(98,'site-settings.privacy-policy','web','2021-09-04 15:37:07','2021-09-04 15:37:07'),(99,'site-settings.refund-policy','web','2021-09-04 15:37:51','2021-09-04 15:37:51'),(100,'site-settings.copyrights','web','2021-09-04 15:38:12','2021-09-04 15:38:12'),(101,'reports.user-subscription','web','2021-09-04 15:38:33','2021-09-04 15:38:33'),(102,'reports.device-history','web','2021-09-04 15:38:47','2021-09-04 15:38:47'),(103,'reports.revenue','web','2021-09-04 15:39:10','2021-09-04 15:39:10'),(104,'help.system-status','web','2021-09-04 15:40:52','2021-09-04 15:40:52'),(105,'help.remove-public','web','2021-09-04 15:41:10','2021-09-04 15:41:10'),(106,'help.clear-cache','web','2021-09-04 15:41:28','2021-09-04 15:41:28'),(107,'ads.view','web','2021-09-04 15:42:23','2021-09-04 15:42:23'),(108,'ads.create','web','2021-09-04 15:42:23','2021-09-04 15:42:23'),(109,'ads.edit','web','2021-09-04 15:42:24','2021-09-04 15:42:24'),(110,'ads.delete','web','2021-09-04 15:42:24','2021-09-04 15:42:24'),(111,'googleads.view','web','2021-09-04 15:42:34','2021-09-04 15:42:34'),(112,'googleads.create','web','2021-09-04 15:42:34','2021-09-04 15:42:34'),(113,'googleads.edit','web','2021-09-04 15:42:34','2021-09-04 15:42:34'),(114,'googleads.delete','web','2021-09-04 15:42:34','2021-09-04 15:42:34'),(115,'package-feature.view','web','2021-09-04 15:42:48','2021-09-04 15:42:48'),(116,'package-feature.create','web','2021-09-04 15:42:48','2021-09-04 15:42:48'),(117,'package-feature.edit','web','2021-09-04 15:42:48','2021-09-04 15:42:48'),(118,'package-feature.delete','web','2021-09-04 15:42:48','2021-09-04 15:42:48'),(119,'front-settings.social-icon','web','2021-09-06 08:44:57','2021-09-06 08:44:57'),(120,'site-settings.manualpayment','web','2021-09-06 09:01:27','2021-09-06 09:01:27'),(121,'reports.stripe-report','web','2021-09-06 10:28:20','2021-09-06 10:28:20'),(122,'help.import-demo','web','2021-09-22 09:56:05','2021-09-22 09:56:05'),(123,'site-settings.currency','web','2021-09-22 09:56:49','2021-09-22 09:56:49'),(124,'roles.view','web','2021-09-22 10:05:12','2021-09-22 10:05:12'),(125,'roles.create','web','2021-09-22 10:06:30','2021-09-22 10:06:30'),(126,'roles.edit','web','2021-09-22 10:06:30','2021-09-22 10:06:30'),(127,'roles.delete','web','2021-09-22 10:06:30','2021-09-22 10:06:30'),(128,'dashboard.states','web','2021-10-20 12:10:22','2021-10-20 12:10:22'),(129,'app-settings.setting','web','2021-10-21 10:03:43','2021-10-21 10:03:43'),(130,'app-settings.slider','web','2021-10-21 10:03:54','2021-10-21 10:03:54');

--
-- Table structure for table `player_settings`
--

CREATE TABLE `player_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_enable` tinyint(1) DEFAULT NULL,
  `cpy_text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `share_opt` tinyint(1) DEFAULT NULL,
  `auto_play` tinyint(1) DEFAULT NULL,
  `speed` tinyint(1) DEFAULT NULL,
  `thumbnail` tinyint(1) DEFAULT NULL,
  `info_window` tinyint(1) DEFAULT NULL,
  `skin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `loop_video` tinyint(1) DEFAULT NULL,
  `is_resume` tinyint(1) DEFAULT '0',
  `player_google_analytics_id` varchar(199) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle_font_size` int DEFAULT NULL,
  `subtitle_color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chromecast` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `player_settings`
--

INSERT INTO `player_settings` VALUES (1,'logo.png',1,'2021 Nexthour',1,NULL,1,NULL,1,'minimal_skin_dark',NULL,NULL,NULL,20,'#48a3c6',NULL,NULL,'2021-10-19 10:17:38');

--
-- Table structure for table `pricing_texts`
--

CREATE TABLE `pricing_texts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `package_id` int NOT NULL,
  `title1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `title2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `title3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `title4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `title5` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `title6` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pricing_texts`
--


--
-- Table structure for table `reminder_mails`
--

CREATE TABLE `reminder_mails` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `subscription_id` int unsigned NOT NULL,
  `today` int DEFAULT NULL,
  `before_7day` int DEFAULT NULL,
  `after_7day` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reminder_mails`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(5,2),(6,1),(6,2),(7,1),(7,2),(8,1),(8,2),(9,1),(9,2),(10,1),(10,2),(11,1),(11,2),(12,1),(12,2),(13,1),(13,2),(14,1),(14,2),(15,1),(15,2),(16,1),(16,2),(17,1),(17,2),(18,1),(18,2),(19,1),(19,2),(20,1),(20,2),(21,1),(21,2),(22,1),(22,2),(23,1),(23,2),(24,1),(24,2),(25,1),(25,2),(26,1),(26,2),(27,1),(27,2),(28,1),(28,2),(29,1),(30,1),(31,1),(32,1),(33,1),(33,2),(34,1),(34,2),(35,1),(35,2),(36,1),(36,2),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(42,2),(43,1),(43,2),(44,1),(44,2),(45,1),(45,2),(46,1),(46,2),(47,1),(47,2),(48,1),(48,2),(49,1),(49,2),(50,1),(50,2),(51,1),(51,2),(52,1),(52,2),(53,1),(53,2),(54,1),(54,2),(55,1),(55,2),(56,1),(56,2),(57,1),(57,2),(58,1),(58,2),(59,1),(59,2),(60,1),(60,2),(61,1),(61,2),(62,1),(63,1),(64,1),(65,1),(66,1),(67,1),(68,1),(69,1),(70,1),(70,2),(71,1),(71,2),(72,1),(72,2),(73,1),(73,2),(74,1),(75,1),(76,1),(77,1),(78,1),(79,1),(80,1),(81,1),(82,1),(83,1),(84,1),(85,1),(86,1),(87,1),(88,1),(89,1),(90,1),(91,1),(92,1),(93,1),(94,1),(95,1),(96,1),(97,1),(98,1),(99,1),(100,1),(101,1),(102,1),(103,1),(104,1),(105,1),(106,1),(107,1),(108,1),(109,1),(110,1),(111,1),(112,1),(113,1),(114,1),(115,1),(116,1),(117,1),(118,1),(119,1),(120,1),(121,1),(122,1),(123,1),(124,1),(125,1),(126,1),(127,1),(128,1),(129,1),(130,1);

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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Super Admin','web','2021-09-01 10:54:28','2021-09-01 10:54:28'),(2,'Producer','web','2021-09-04 12:52:18','2021-09-04 12:52:18'),(3,'User','web',NULL,NULL);

--
-- Table structure for table `seos`
--

CREATE TABLE `seos` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `author` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `google` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `metadata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keyword` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seos`
--

INSERT INTO `seos` VALUES (1,'{\"en\":\"Next Hour - Movie Tv Show & Video Subscription Portal Cms\"}',NULL,NULL,'{\"en\":\"this ts a next hour\"}','{\"en\":\"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.\"}','{\"en\":\"Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.\"}',NULL,'2021-10-19 09:41:55');

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

CREATE TABLE `sessions` (
  `id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  UNIQUE KEY `sessions_id_unique` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` VALUES ('7bQzI8IRBqrlPoW0a5LSrVdurhbaQPtp2hfvL5Wg',NULL,'104.248.75.7','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQWR0c1RlcXFZejF4dTY3eTRpWm00TGZOWWZGTHBrZjV4MTRHZ0dwaiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MDoiaHR0cDovL21vbmRpYWx5Lm5ldC9hZG1pbi93b3JsZGN1cHJlc3VsdCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQwOiJodHRwOi8vbW9uZGlhbHkubmV0L2FkbWluL3dvcmxkY3VwcmVzdWx0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1668328959),('b0GVexcswaL7HfKPFj1axJaDmaSbj2Zm15Fiz3J8',NULL,'162.243.4.24','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOU5kdjJ4UndpdzZaM0ROZ2pBRDNkWDdvSVpUdHNyVWdEbmw1Zm9UOCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9tb25kaWFseS5uZXQvcmVzdWx0cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1668325566),('EZy0h2lxDuRFuqrKs3tsgfXkcYRIs1EVWufDVx2c',NULL,'197.252.202.187','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.35','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidk1xdlRxN2d4UGN3dUJ2WjdaQnJud3dpSE9GdnZWS0FaT0xHTlRqeSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9tb25kaWFseS5uZXQvZ3Vlc3Qvd29ybGQtY3VwLTIwMjIiO319',1668326298),('gz3384W7Er7K2gx27N6kcE2NHSpozOh82iBRCdJL',1,'197.252.202.187','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.35','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiaW9iR0xlWjdqT0VQQ05rQUUwZUQ1Ujl1V1JoOVFFUjFpVXdRQ0M1byI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9tb25kaWFseS5uZXQvYWRtaW4vd29ybGRjdXByZXN1bHQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO3M6NDoidXNlciI7YToyOntzOjU6ImVtYWlsIjtzOjIxOiJhZG1pbkBtZWRpYWNpdHkuY28uaW4iO3M6NDoibmFtZSI7czo1OiJBZG1pbiI7fX0=',1668328973),('IqaM14FVqLfuCkE8j6PX5e1oivWUFbcnVmQAGyGJ',NULL,'18.220.240.73','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.5304.87 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidWI5Q1pxdjdGbmttYUdkMzZ6VUlXc05JemZ3NVMwY3h0aTFMNVNoTSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly9tb25kaWFseS5uZXQvZ3Vlc3Qvd29ybGQtY3VwLTIwMjIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1668324481),('MjgbbG5MimMZfdSPm2kP6BX3X344dhCVBS8MmLqM',1,'197.252.202.234','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.35','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiekNPUzVDWmppVmYzTWJHOFcwblVDUDZtRXV6WXU5cWlyU3N3TTk2diI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9tb25kaWFseS5uZXQvcmVzdWx0cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7czo0OiJ1c2VyIjthOjI6e3M6NToiZW1haWwiO3M6MjE6ImFkbWluQG1lZGlhY2l0eS5jby5pbiI7czo0OiJuYW1lIjtzOjU6IkFkbWluIjt9fQ==',1668329175),('nToP6V2a0nGznYaGXBDWCZE7PaKZHRyDQBdYw63G',NULL,'197.252.202.187','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36 Edg/107.0.1418.35','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidHlHeFZtRmxjdkRWblg4OTRhR1lkUE5QUDFVWm10UWpDUEVtYUE1ZCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9tb25kaWFseS5uZXQvcmVzdWx0cyI7fX0=',1668327248),('yI3nkHtAGoHy2g4diPdq9bpiuVJIK1J9ebtlPe2H',NULL,'162.243.4.24','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTW50Y2pPVkFKNGxaVmQ4Sk5sR25jWmJjcFdEb2k1QTlZc2dZa0pHdSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NzoiaHR0cDovL21vbmRpYWx5Lm5ldC9hZG1pbi93b3JsZGN1cHJlc3VsdC9jcmVhdGUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NzoiaHR0cDovL21vbmRpYWx5Lm5ldC9hZG1pbi93b3JsZGN1cHJlc3VsdC9jcmVhdGUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1668327567),('Z9B4IvyIrCeoigQkqZrMlExMenc48f8e1CB0WEGR',NULL,'14.116.158.108','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibDI0UE5FbjdZWHd2YUJ6ZURtSEN5UWVVNGtkUnBER0lubzlvbENWRSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHA6Ly9tb25kaWFseS5uZXQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1668326209);

--
-- Table structure for table `social_icons`
--

CREATE TABLE `social_icons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url3` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_icons`
--

INSERT INTO `social_icons` VALUES (1,'#','#','#','2020-11-02 07:09:08','2020-11-02 07:10:18');

--
-- Table structure for table `splash_screens`
--

CREATE TABLE `splash_screens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_enable` tinyint(1) NOT NULL DEFAULT '1',
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `splash_screens`
--


--
-- Table structure for table `subcomments`
--

CREATE TABLE `subcomments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `blog_id` int NOT NULL,
  `comment_id` int NOT NULL,
  `reply` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subcomments`
--


--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint unsigned NOT NULL,
  `stripe_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_plan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_subscription_id_stripe_plan_unique` (`subscription_id`,`stripe_plan`),
  KEY `subscription_items_stripe_id_index` (`stripe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscription_items`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_plan` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `subscription_from` timestamp NULL DEFAULT NULL,
  `subscription_to` timestamp NULL DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `subtitles`
--

CREATE TABLE `subtitles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `sub_lang` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_t` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `m_t_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ep_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subtitles`
--


--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `amount1` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency1` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency2` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fee` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buyer_email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buyer_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ipn_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txn_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirms_needed` tinyint unsigned NOT NULL,
  `timeout` int unsigned NOT NULL,
  `status_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `qrcode_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` smallint DEFAULT NULL,
  `status_text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_confirms` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transactions_txn_id_unique` (`txn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--


--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `merchant` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pbntag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_confirm` tinyint(1) NOT NULL DEFAULT '0',
  `ref_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transfers_ref_id_unique` (`ref_id`),
  KEY `transfers_status_index` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transfers`
--


--
-- Table structure for table `tv_series`
--

CREATE TABLE `tv_series` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `keyword` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tmdb_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tmdb` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fetch_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `poster` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `genre_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `rating` double(8,2) DEFAULT NULL,
  `episode_runtime` double(8,2) DEFAULT NULL,
  `maturity_rating` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `type` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'T',
  `status` int unsigned NOT NULL DEFAULT '1',
  `created_by` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_custom_label` tinyint(1) NOT NULL DEFAULT '0',
  `label_id` int DEFAULT NULL,
  `is_upcoming` tinyint(1) NOT NULL DEFAULT '0',
  `upcoming_date` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tv_series`
--


--
-- Table structure for table `user_ratings`
--

CREATE TABLE `user_ratings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `tv_id` int DEFAULT NULL,
  `movie_id` int DEFAULT NULL,
  `rating` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_ratings`
--


--
-- Table structure for table `videolinks`
--

CREATE TABLE `videolinks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `movie_id` int unsigned DEFAULT NULL,
  `episode_id` int unsigned DEFAULT NULL,
  `type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iframeurl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ready_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_360` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_480` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_720` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_1080` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `upload_video` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `videolinks_movie_id_foreign` (`movie_id`),
  KEY `videolinks_episode_id_foreign` (`episode_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `videolinks`
--

INSERT INTO `videolinks` VALUES (2,2,NULL,'multiquality',NULL,NULL,'http://mondialy.net/movies_upload/1667215147الشفخانة_حكاوينا.mp4',NULL,NULL,NULL,'2022-10-31 16:49:08','2022-10-31 16:49:08',NULL),(3,3,NULL,'iframeurl','https://player.vimeo.com/video/767772849',NULL,NULL,NULL,NULL,NULL,'2022-11-06 17:37:32','2022-11-06 18:37:25',NULL),(4,4,NULL,'iframeurl','https://player.vimeo.com/video/767783531',NULL,NULL,NULL,NULL,NULL,'2022-11-06 18:27:56','2022-11-06 18:36:41',NULL),(5,5,NULL,'iframeurl','https://player.vimeo.com/video/767792274',NULL,NULL,NULL,NULL,NULL,'2022-11-06 19:20:17','2022-11-06 19:20:17',NULL),(6,6,NULL,'iframeurl','https://player.vimeo.com/video/769407902',NULL,NULL,NULL,NULL,NULL,'2022-11-10 17:33:23','2022-11-10 17:43:15',NULL),(7,7,NULL,'iframeurl','https://player.vimeo.com/video/769426168',NULL,NULL,NULL,NULL,NULL,'2022-11-10 18:24:53','2022-11-10 18:24:53',NULL),(8,8,NULL,'iframeurl','https://player.vimeo.com/video/769449352',NULL,NULL,NULL,NULL,NULL,'2022-11-10 19:26:39','2022-11-10 19:26:39',NULL);

--
-- Table structure for table `views`
--

CREATE TABLE `views` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `viewable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `viewable_id` bigint unsigned NOT NULL,
  `visitor` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `collection` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `viewed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `views_viewable_type_viewable_id_index` (`viewable_type`,`viewable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `views`
--

INSERT INTO `views` VALUES (2,'App\\Movie',2,'MycZPF0LOJiU3a2fViR7d33ObOaY5LCJuEN4j3o1GBhwAxdAB7hlFKKr9agRUwd0MnC2Q3M59ZLEPEIf',NULL,'2022-10-31 17:17:26'),(3,'App\\Movie',2,'MycZPF0LOJiU3a2fViR7d33ObOaY5LCJuEN4j3o1GBhwAxdAB7hlFKKr9agRUwd0MnC2Q3M59ZLEPEIf',NULL,'2022-11-02 13:39:52'),(4,'App\\Movie',3,'EXvO4EMUJvUHScdOojssoA2gLEzvMsP0r4zaG5fLD6rFJQ2vZwOmFVHESJ519mOKPmdf0n2NHeofw4pC',NULL,'2022-11-06 17:37:39'),(5,'App\\Movie',3,'EXvO4EMUJvUHScdOojssoA2gLEzvMsP0r4zaG5fLD6rFJQ2vZwOmFVHESJ519mOKPmdf0n2NHeofw4pC',NULL,'2022-11-06 17:39:05'),(6,'App\\Movie',4,'EXvO4EMUJvUHScdOojssoA2gLEzvMsP0r4zaG5fLD6rFJQ2vZwOmFVHESJ519mOKPmdf0n2NHeofw4pC',NULL,'2022-11-06 18:28:44'),(7,'App\\Movie',4,'EXvO4EMUJvUHScdOojssoA2gLEzvMsP0r4zaG5fLD6rFJQ2vZwOmFVHESJ519mOKPmdf0n2NHeofw4pC',NULL,'2022-11-06 18:29:27'),(8,'App\\Movie',4,'EXvO4EMUJvUHScdOojssoA2gLEzvMsP0r4zaG5fLD6rFJQ2vZwOmFVHESJ519mOKPmdf0n2NHeofw4pC',NULL,'2022-11-06 18:35:16'),(9,'App\\Movie',3,'EXvO4EMUJvUHScdOojssoA2gLEzvMsP0r4zaG5fLD6rFJQ2vZwOmFVHESJ519mOKPmdf0n2NHeofw4pC',NULL,'2022-11-06 18:35:41'),(10,'App\\Movie',5,'Da8WCY3bAdIb5OWQAjesbpuSRB34cz4a9Zv0kIInj6pNppNhwLjhG3ChNqAWcxnDbzmvbYP7venPe5Gh',NULL,'2022-11-06 20:05:46'),(11,'App\\Movie',3,'EXvO4EMUJvUHScdOojssoA2gLEzvMsP0r4zaG5fLD6rFJQ2vZwOmFVHESJ519mOKPmdf0n2NHeofw4pC',NULL,'2022-11-07 13:09:55'),(12,'App\\Movie',3,'s8zkgPIi5Xfq3ay3Aa3JWsZzVCjUV2iLLYf4tlxfAAuHEnC0NsxdcrCUKe3X0fg5OcJL3CNpdK9Kv83Q',NULL,'2022-11-07 13:09:55'),(13,'App\\Movie',5,'D2KooGnDykZ7Nwo7FUydQLJF7PxBglyWQfXBK4YlSbAslqpI3PEhBGA5XHTE5Z2l0Bj6BEfmTkXPgPNS',NULL,'2022-11-07 13:29:43'),(14,'App\\Movie',5,'ktbo3B76CkVLJbHmICMDNQTU6GZhAMJNMdeShxBjO6QGZ6El3MECHOgDAq1zWyyb0teKnCI4dObkuboO',NULL,'2022-11-07 13:29:44'),(15,'App\\Movie',4,'0S40iqOKliN6ijgt8SO1mbJsbZsvw3cAgmoLDiWCfTiLEBPkYTMQls1c9ZMZzfiItPnoTdQFZjA4kQtb',NULL,'2022-11-09 15:00:09');

--
-- Table structure for table `watch_histories`
--

CREATE TABLE `watch_histories` (
  `id` int NOT NULL AUTO_INCREMENT,
  `movie_id` int DEFAULT NULL,
  `tv_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `watch_histories`
--

INSERT INTO `watch_histories` VALUES (1,2,NULL,1,'2022-10-31 17:17:37','2022-10-31 17:17:37'),(2,3,NULL,1,'2022-11-06 17:38:23','2022-11-06 17:38:23'),(3,4,NULL,1,'2022-11-06 18:28:55','2022-11-06 18:28:55');

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `movie_id` int DEFAULT NULL,
  `season_id` int DEFAULT NULL,
  `added` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wishlists_user_id_foreign` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wishlists`
--


--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `mass_withdrawal_id` int unsigned DEFAULT NULL,
  `amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount2` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amounti` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency2` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pbntag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ipn_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_confirm` tinyint(1) NOT NULL DEFAULT '0',
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ref_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `status_text` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `txn_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `withdrawals_ref_id_unique` (`ref_id`),
  UNIQUE KEY `withdrawals_txn_id_unique` (`txn_id`),
  KEY `withdrawals_mass_withdrawal_id_index` (`mass_withdrawal_id`),
  CONSTRAINT `withdrawals_mass_withdrawal_id_foreign` FOREIGN KEY (`mass_withdrawal_id`) REFERENCES `mass_withdrawals` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawals`
--


--
-- Table structure for table `world_cup_lives`
--

CREATE TABLE `world_cup_lives` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `url` varchar(500) NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `world_cup_lives`
--

INSERT INTO `world_cup_lives` VALUES (1,'Livefootball','Test live from video','',NULL,'2022-11-10'),(2,'Demo Livefootball','Test live from viemo','',NULL,'2022-11-10');

--
-- Table structure for table `world_cup_news`
--

CREATE TABLE `world_cup_news` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `new` text NOT NULL,
  `order` int NOT NULL,
  `thumbnail` varchar(100) NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `world_cup_news`
--

INSERT INTO `world_cup_news` VALUES (12,'متى يفوز منتخب أفريقي بكأس العالم؟','لم يسبق لأي منتخب أفريقي تجاوز ما هو أبعد من الدور ربع النهائي لبطولة كأس العالم لكرة القدم بعد مرور 21 نسخة، بانتظار بطولة 2022 التي تستضيفها قطر خلال الفترة بين 20 نوفمبر/تشرين الثاني و18 ديسمبر/كانون الأول 2022.  ورغم الحضور المميز للاعبين الأفارقة في الدوريات الأوروبية الكبرى وتأثيرهم القوي، فإن حلم صعود أحد منتخبات القارة السمراء إلى منصة التتويج في المونديال لم يتحقق بعد، واقتصر التتويج باللقب على منتخبات قارتين فقط: أوروبا وأميركا الجنوبية.  اقرأ أيضا',0,'thumb_1667129516الالال.webp','2022-10-30','2022-10-30'),(13,'تعددت الأسماء والخيبة واحدة.. صلاح ومحرز وهالاند أبرز 20 نجما يغيبون عن مونديال قطر','تظل مسابقة كأس العالم، بوصفها التظاهرة الرياضية الأعظم، حلما يراود كل اللاعبين في العالم، لكن كثيرا من نجوم كرة القدم ممن يتألقون في الدوريات الأوروبية الكبرى خاصة ويصنعون ربيع أنديتهم سيكونون خارج مونديال قطر 2022، بعد أن رافقهم الفشل مع منتخباتهم في مشوار التصفيات. وفي انتظار بدايته يوم 20 نوفمبر/تشرين الثاني المقبل، سيحرم عشاق كرة القدم ومتابعو مونديال قطر من مشاهدة أكثر من 50 لاعبا يشكلون \"مجموعة النجوم الغائبين عن النهائيات\". وكشف تقرير نشرته صحيفة \"ماركا\" الإسبانية عن قائمة لأبرز نجوم كرة القدم الذين لن يخوضوا المونديال، وفي مقدمتهم نجم ليفربول الإنجليزي ومهاجم منتخب مصر محمد صلاح، ولويس دياز زميله في ليفربول ولاعب منتخب كولومبيا، وإيرلينغ هالاند هداف الدوري الإنجليزي ومانشستر سيتي، وجيان لويجي دوناروما حارس منتخب إيطاليا وباري سان جرمان الفرنسي وغيرهم.',0,'thumb_1667129702lhkln.webp','2022-10-30','2022-10-30'),(14,'مهاجم السعودية: لن نأتي إلى قطر لمجرد المشاركة في المونديال.. وهذا رأيي في منافسينا','تحدّث هتان باهبري لموقع \"فيفا\" الرسمي، قائلاً: \"لن نأتي (إلى قطر) لمجرد المشاركة، مع كلّ مشاركة جديدة يكون لدينا دافع لتقديم المزيد، علينا تحقيق شيء ما لأجل السعودية\"، مُضيفاً: \"حضور الجمهور السعودي يعطينا حقاً دافعاً كبيراً، سيكونوا في كلّ مكان\".  وعن منافسي منتخب بلاده، قال باهبري: \"الأرجنتين فريق يمتلك لاعبين من الطراز العالمي، وعلى رأسهم ليونيل ميسي، فيما بولندا لديها الهدّاف الأهم في العالم (روبرت ليفاندوفسكي)، بينما المكسيك لديهم حارس مرمى جيد\".  وتابع باهبري: \"أمتلك الخبرة اللازمة للنسخة القادمة من كأس العالم، لكني لست أول لاعب من المجموعة شارك في البطولة، لدينا لاعبين آخرين يمتلكون خبرة المونديال، وآمل أن ننجح في نقل خبراتنا للاعبين الآخرين الذين لم يحظوا بتلك التجربة من قبل، وأتمنى أن نكون على قدر التوقعات\".',0,'thumb_1667129790su,]di.webp','2022-10-30','2022-10-30'),(16,'سُميت بـ\"الرحلة\".. تعرف إلى أهم خصائص كرة القدم الرسمية لكأس العالم في قطر','\"الرحلة\" باللغة العربية مستوحاة من الثقافة والعمارة والقوارب الشهيرة وعلم قطر، التي تمثل البلد المضيف لكأس العالم FIFA وتعكس ميزات السرعة المستمرة والمتزايدة أثناء اللعبة. وتم تصميم الكرة مع أسس الاستدامة كأولوية، حيث تعتبر كرة \"الرحلة\" أول كرة في كأس العالم تُصنع حصريًا من الأحبار والمواد اللاصقة التي تعتمد على الماء.  ومن أهم ميزاتها:  - تصميم الكرة الداخلي يوفر السرعة والدقة والاتساق للحركة السريعة والدقة، مع أقصى قدر من الشكل والاحتفاظ بالهواء، فضلاً عن دقة الارتداد  - الغشاء الخارجي مصنوع من جلد البولي يوريثين مع شكل لوحة جديدة مكونة من 20 قطعة، مما يحسن الدقة واستقرار الطيران والانحراف.',0,'thumb_1667130399الرحلة.jpeg','2022-10-30','2022-10-30'),(17,'تجربة الخبر','لخبر',0,'','2022-11-07','2022-11-07');

--
-- Table structure for table `world_cup_players`
--

CREATE TABLE `world_cup_players` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `team` varchar(100) NOT NULL,
  `position` int NOT NULL,
  `points` int NOT NULL,
  `rank` int NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `world_cup_players`
--

INSERT INTO `world_cup_players` VALUES (2,'motaz siam','TZA Team',3,12,11,'2022-11-02','2022-11-03'),(4,'motaz siam','TZA Team',2,50,3,'2022-11-03','2022-11-03'),(5,'Live test','TZA Team',2,9,6,'2022-11-03','2022-11-03'),(6,'motaz nxt-level','TZA Team',1,3,1,'2022-11-06','2022-11-06');

--
-- Table structure for table `world_cup_results`
--

CREATE TABLE `world_cup_results` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `firstteam_id` int NOT NULL,
  `secondteam_id` int NOT NULL,
  `firstteamresult` int NOT NULL DEFAULT '0',
  `secondteamresult` int NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `genre_id` int NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `world_cup_results`
--

INSERT INTO `world_cup_results` VALUES (4,'2022-11-20','18:00:00',1,0,0,0,0,11,'2022-11-13','2022-11-13'),(5,'2022-11-21','15:00:00',5,6,0,0,0,13,'2022-11-13','2022-11-13'),(6,'2022-11-21','18:00:00',3,4,0,0,0,11,'2022-11-13','2022-11-13'),(7,'2022-11-21','21:00:00',7,8,0,0,0,13,'2022-11-13','2022-11-13'),(8,'2022-11-22','12:00:00',9,10,0,0,0,14,'2022-11-13','2022-11-13'),(9,'2022-11-22','15:00:00',15,16,0,0,0,15,'2022-11-13','2022-11-13'),(10,'2022-11-22','18:00:00',11,12,0,0,0,14,'2022-11-13','2022-11-13'),(11,'2022-11-22','21:00:00',13,14,0,0,0,15,'2022-11-13','2022-11-13'),(12,'2022-11-23','12:00:00',23,24,0,0,0,17,'2022-11-13','2022-11-13'),(13,'2022-11-23','15:00:00',19,20,0,0,0,16,'2022-11-13','2022-11-13'),(14,'2022-11-23','18:00:00',17,18,0,0,0,16,'2022-11-13','2022-11-13'),(15,'2022-11-23','21:00:00',21,22,0,0,0,17,'2022-11-13','2022-11-13'),(16,'2022-11-24','12:00:00',27,28,0,0,0,18,'2022-11-13','2022-11-13'),(17,'2022-11-24','15:00:00',32,33,0,0,0,19,'2022-11-13','2022-11-13'),(18,'2022-11-24','18:00:00',29,31,0,0,0,19,'2022-11-13','2022-11-13'),(19,'2022-11-24','21:00:00',25,26,0,0,0,18,'2022-11-13','2022-11-13'),(20,'2022-11-25','12:00:00',8,6,0,0,0,13,'2022-11-13','2022-11-13'),(21,'2022-11-25','15:00:00',1,3,0,0,0,11,'2022-11-13','2022-11-13'),(22,'2022-11-25','18:00:00',4,0,0,0,0,11,'2022-11-13','2022-11-13'),(23,'2022-11-25','21:00:00',5,0,0,0,0,13,'2022-11-13','2022-11-13'),(24,'2022-11-26','12:00:00',16,14,0,0,0,15,'2022-11-13','2022-11-13'),(25,'2022-11-26','15:00:00',12,10,0,0,0,14,'2022-11-13','2022-11-13'),(26,'2022-11-26','18:00:00',13,15,0,0,0,15,'2022-11-13','2022-11-13'),(27,'2022-11-26','21:00:00',9,11,0,0,0,14,'2022-11-13','2022-11-13'),(28,'2022-11-27','12:00:00',20,18,0,0,0,16,'2022-11-13','2022-11-13'),(29,'2022-11-27','15:00:00',21,23,0,0,0,17,'2022-11-13','2022-11-13'),(30,'2022-11-27','18:00:00',24,22,0,0,0,17,'2022-11-13','2022-11-13'),(31,'2022-11-27','21:00:00',17,19,0,0,0,16,'2022-11-13','2022-11-13'),(32,'2022-11-28','12:00:00',28,26,0,0,0,18,'2022-11-13','2022-11-13'),(33,'2022-11-28','15:00:00',33,31,0,0,0,19,'2022-11-13','2022-11-13'),(34,'2022-11-28','18:00:00',25,27,0,0,0,18,'2022-11-13','2022-11-13'),(35,'2022-11-28','21:00:00',29,32,0,0,0,19,'2022-11-13','2022-11-13'),(36,'2022-11-29','18:00:00',0,3,0,0,0,11,'2022-11-13','2022-11-13'),(37,'2022-11-29','18:00:00',4,1,0,0,0,11,'2022-11-13','2022-11-13'),(38,'2022-11-29','21:00:00',8,5,0,0,0,13,'2022-11-13','2022-11-13');

--
-- Table structure for table `world_cup_teams`
--

CREATE TABLE `world_cup_teams` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `played` int NOT NULL DEFAULT '0',
  `win` int NOT NULL DEFAULT '0',
  `lost` int NOT NULL DEFAULT '0',
  `draw` int NOT NULL DEFAULT '0',
  `goals` int NOT NULL DEFAULT '0',
  `considered` int NOT NULL DEFAULT '0',
  `difference` int NOT NULL DEFAULT '0',
  `totalpoints` int NOT NULL DEFAULT '0',
  `genre_id` int NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `image` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `world_cup_teams`
--

INSERT INTO `world_cup_teams` VALUES (1,'قطر',7,7,5,0,4,4,3,4,11,NULL,'2022-11-09','team_1667999821audi3.png'),(3,'السنغال',0,0,0,0,0,0,0,0,11,'2022-10-23','2022-10-30',NULL),(4,'هولندا',0,0,0,0,0,0,0,0,11,'2022-10-23','2022-10-30',NULL),(5,'انجلترا',0,0,0,0,0,0,0,0,13,'2022-10-30','2022-10-30',NULL),(6,'ايران',0,0,0,0,0,0,0,0,13,'2022-10-30','2022-10-30',NULL),(7,'امريكا',0,0,0,0,0,0,0,0,13,'2022-10-30','2022-10-30',NULL),(8,'ويلز',0,0,0,0,0,0,0,0,13,'2022-10-30','2022-10-30',NULL),(9,'الارجنتين',0,0,0,0,0,0,0,0,14,'2022-10-30','2022-10-30',NULL),(10,'السعودية',0,0,0,0,0,0,0,0,14,'2022-10-30','2022-10-30',NULL),(11,'المكسيك',0,0,0,0,0,0,0,0,14,'2022-10-30','2022-10-30',NULL),(12,'بولندا',0,0,0,0,0,0,0,0,14,'2022-10-30','2022-10-30',NULL),(13,'فرنسا',0,0,0,0,0,0,0,0,15,'2022-10-30','2022-10-30',NULL),(14,'استراليا',0,0,0,0,0,0,0,0,15,'2022-10-30','2022-10-30',NULL),(15,'الدنمارك',0,0,0,0,0,0,0,0,15,'2022-10-30','2022-10-30',NULL),(16,'تونس',0,0,0,0,0,0,0,0,15,'2022-10-30','2022-10-30',NULL),(17,'اسبانيا',0,0,0,0,0,0,0,0,16,'2022-10-30','2022-10-30',NULL),(18,'كوستاريكا',0,0,0,0,0,0,0,0,16,'2022-10-30','2022-10-30',NULL),(19,'المانيا',0,0,0,0,0,0,0,0,16,'2022-10-30','2022-10-30',NULL),(20,'اليابان',0,0,0,0,0,0,0,0,16,'2022-10-30','2022-10-30',NULL),(21,'بلجيكا',0,0,0,0,0,0,0,0,17,'2022-10-30','2022-10-30',NULL),(22,'كندا',0,0,0,0,0,0,0,0,17,'2022-10-30','2022-10-30',NULL),(23,'المغرب',0,0,0,0,0,0,0,0,17,'2022-10-30','2022-10-30',NULL),(24,'كرواتيا',0,0,0,0,0,0,0,0,17,'2022-10-30','2022-10-30',NULL),(25,'البرازيل',0,0,0,0,0,0,0,0,18,'2022-10-30','2022-10-30',NULL),(26,'صربيا',0,0,0,0,0,0,0,0,18,'2022-10-30','2022-10-30',NULL),(27,'سويسرا',0,0,0,0,0,0,0,0,18,'2022-10-30','2022-10-30',NULL),(28,'الكاميرون',0,0,0,0,0,0,0,0,18,'2022-10-30','2022-10-30',NULL),(29,'البرتغال',0,0,0,0,0,0,0,0,19,'2022-10-30','2022-10-30',NULL),(31,'غانا',0,0,0,0,0,0,0,0,19,'2022-10-30','2022-10-30',NULL),(32,'الاوروغواي',0,0,0,0,0,0,0,0,19,'2022-10-30','2022-10-30',NULL),(33,'كوريا الجنوبية',0,0,0,0,0,0,0,0,19,'2022-10-30','2022-10-30',NULL);


