--
-- Host: localhost    Database: capsola
-- ------------------------------------------------------


--
-- 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 11:43:44','2020-02-11 11: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 15: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 14:47:00','2020-11-29 15:05:28'),(2,NULL,NULL,'app_slide_1606642578tvshow.jpg',1,2,'2020-11-29 15:06:18','2020-11-29 15:06:18');

--
-- 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 14: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,0,1,0,1,0,'2018-07-31 10:30:00','2022-06-28 17:54:35',NULL,0,NULL,1,NULL,1,1,0,0,0,1,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 14: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 16:11:27','2021-10-18 10:30:00'),(2,'US Dollar','USD','$','$1,0.00','1','[\"stripe\",\"paypal\",\"braintree\",\"omise\",\"payhere\",\"flutterrave\",\"mollie\"]',0,'2021-09-08 16:13:00','2021-10-18 10:30:00'),(3,'Euro','EUR','€','1.0,00 €','0.863677','[\"stripe\",\"paypal\",\"braintree\",\"omise\",\"payhere\",\"flutterrave\"]',0,'2021-09-08 16:13:39','2021-10-18 10:30:00'),(4,'Sri Lanka Rupee','LKR','₨','₨ 1,0.','202.450844','[\"payhere\"]',0,'2021-09-08 16:52:46','2021-10-18 10:30:00'),(5,'UAE Dirham','AED','دإ‏','دإ‏ 1,0.00','3.6731','[\"mollie\",\"cashfree\"]',0,'2021-09-09 14:58:19','2021-10-18 10:30:00'),(6,'Nigeria, Naira','NGN','₦','₦1,0.00','411.92','[\"stripe\",\"flutterrave\",\"paystack\"]',0,'2021-09-13 14:03:42','2021-10-18 10:30:00'),(7,'Angola, Kwanza','AOA','Kz','Kz1,0.00','597.698','[\"stripe\"]',0,'2021-10-01 13:01:26','2021-10-18 10:30:00'),(8,'Tunisian Dinar','TND','د.ت.‏','د.ت.‏ 1,0.000','2.8235','[\"stripe\"]',0,'2021-10-04 11:33:43','2021-10-18 10:30:00'),(9,'Kenyan Shilling','KES','S','S1,0.00','110.9','[\"stripe\"]',0,'2021-10-04 12:46:10','2021-10-18 10: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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `faqs` VALUES (1,'{\"en\":\"\\u0645\\u0627 \\u0647\\u064a \\u0627\\u0644\\u062e\\u062f\\u0645\\u0629 \\u0627\\u0644\\u062a\\u064a \\u064a\\u0642\\u062f\\u0645\\u0647\\u0627 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639 \\u061f\",\"ar\":\"\\u0645\\u0627 \\u0647\\u064a \\u0627\\u0644\\u062e\\u062f\\u0645\\u0629 \\u0627\\u0644\\u062a\\u064a \\u064a\\u0642\\u062f\\u0645\\u0647\\u0627 \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639 \\u061f\"}','{\"en\":\"\\u064a\\u0642\\u062f\\u0645 \\u0645\\u0648\\u0642\\u0639 \\u0643\\u0628\\u0633\\u0648\\u0644\\u0629 \\u0646\\u0635\\u0627\\u0626\\u062d \\u0648\\u0627\\u0631\\u0634\\u0627\\u062f\\u0627\\u062a \\u0637\\u0628\\u064a\\u0629 \\u0645\\u0647\\u0645\\u0629\",\"ar\":\"\\u064a\\u0642\\u062f\\u0645 \\u0645\\u0648\\u0642\\u0639 \\u062a\\u0631\\u064a\\u0627\\u0642 \\u0646\\u0635\\u0627\\u0626\\u062d \\u0648\\u0627\\u0631\\u0634\\u0627\\u062f\\u0627\\u062a \\u0637\\u0628\\u064a\\u0629 \\u0645\\u0647\\u0645\\u0629\"}','2022-08-02 14:26:01','2023-03-15 15:16:11'),(2,'{\"en\":\"\\u0643\\u064a\\u0641 \\u062a\\u0642\\u0648\\u0645 \\u0628\\u0627\\u0644\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0641\\u064a \\u0627\\u0644\\u0645\\u0648\\u0642\\u0639 \\u061f\"}','{\"en\":\"\\u0628\\u0627\\u0644\\u0636\\u063a\\u0637 \\u0639\\u0644\\u0649 \\u0632\\u0631 \\u0627\\u0644\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643\"}','2022-08-02 14:26:24','2022-08-02 14:26:24'),(3,'{\"en\":\"\\u0647\\u0644 \\u064a\\u0645\\u0643\\u0646\\u0646\\u064a \\u0627\\u0644\\u063a\\u0627\\u0621 \\u0627\\u0644\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0641\\u064a \\u0627\\u064a \\u0648\\u0642\\u062a \\u061f\",\"ar\":\"\\u0647\\u0644 \\u064a\\u0645\\u0643\\u0646\\u0646\\u064a \\u0627\\u0644\\u063a\\u0627\\u0621 \\u0627\\u0644\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0641\\u064a \\u0627\\u064a \\u0648\\u0642\\u062a \\u061f\"}','{\"en\":\"\\u0646\\u0639\\u0645 \\u0639\\u0646 \\u0637\\u0631\\u064a\\u0642 \\u0627\\u0644\\u0636\\u063a\\u0637 \\u0639\\u0644\\u0649 \\u0632\\u0631 \\u0627\\u0644\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643\",\"ar\":\"\\u0646\\u0639\\u0645 \\u0639\\u0646 \\u0637\\u0631\\u064a\\u0642 \\u0627\\u0644\\u0636\\u063a\\u0637 \\u0639\\u0644\\u0649 \\u0632\\u0631\\u0627\\u0644\\u063a\\u0627\\u0621 \\u0627\\u0644\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643\"}','2022-08-02 14:26:46','2023-03-16 18:10:58');

--
-- 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `genres` VALUES (4,'{\"ar\":\"\\u0627\\u0644\\u0628\\u0627\\u0637\\u0646\\u064a\\u0629\"}','genre_1658752132images.png',1,'2022-07-25 17:58:52','2022-07-25 17:58:52'),(5,'{\"ar\":\"\\u0627\\u0644\\u062c\\u0647\\u0627\\u0632 \\u0627\\u0644\\u062a\\u0646\\u0641\\u0633\\u064a\"}','genre_1658752150278021b5-062a-4d08-a809-5d523cae4deb.jpeg',2,'2022-07-25 17:59:10','2022-07-25 17:59:10'),(6,'{\"ar\":\"\\u0627\\u0644\\u0635\\u062d\\u0629 \\u0627\\u0644\\u0646\\u0641\\u0633\\u064a\\u0629\"}','genre_1658752197OTY4NzIq.jpg',3,'2022-07-25 17:59:58','2022-07-25 17:59:58'),(7,'{\"ar\":\"\\u0627\\u0644\\u0646\\u0633\\u0627\\u0621 \\u0648\\u0627\\u0644\\u062a\\u0648\\u0644\\u064a\\u062f\"}',NULL,4,'2022-08-10 13:28:58','2022-08-10 13:28:58');

--
-- 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=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `home_sliders` VALUES (12,NULL,NULL,'slide_1678627071pic-2.png',1,1,'2023-03-12 18:47:51','2023-03-12 18:47:51'),(13,NULL,NULL,'slide_1678627141pic-5 د.مينا.png',1,2,'2023-03-12 18:49:01','2023-03-12 18:49:01'),(14,NULL,NULL,'slide_1678627154pic-4 د.محمد صالح.png',1,3,'2023-03-12 18:49:14','2023-03-12 18:49:14'),(15,NULL,NULL,'slide_1678627167د.ايمن.png',1,4,'2023-03-12 18:49:28','2023-03-12 18:49:28');

--
-- 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 14:29:21','2020-11-02 14: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 14:29:39','2020-11-02 14: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 14:30:01','2020-11-02 14: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 14:30:18','2020-11-02 14: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 14:19:55','2022-06-28 17:58:25',0),(2,'ar','arabic',1,'2022-06-28 17:58:25','2022-06-28 17:58:25',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=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menu_genre_shows` VALUES (14,1,2,4),(15,1,2,5),(16,1,2,6),(17,1,2,7);

--
-- 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menu_sections` VALUES (7,1,2,9,1,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=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menu_videos` VALUES (50,1,33,NULL,NULL,NULL,'2023-03-12 18:06:08','2023-03-12 18:06:08'),(51,1,34,NULL,NULL,NULL,'2023-03-12 18:07:19','2023-03-12 18:07:19'),(52,1,35,NULL,NULL,NULL,'2023-03-12 18:08:26','2023-03-12 18:08:26'),(53,1,36,NULL,NULL,NULL,'2023-03-12 18:09:36','2023-03-12 18:09:36'),(54,1,37,NULL,NULL,NULL,'2023-03-12 18:14:21','2023-03-12 18:14:21'),(55,1,38,NULL,NULL,NULL,'2023-03-12 18:15:30','2023-03-12 18:15:30'),(56,1,39,NULL,NULL,NULL,'2023-03-12 18:16:27','2023-03-12 18:16:27'),(57,1,41,NULL,NULL,NULL,'2023-03-12 18:18:45','2023-03-12 18:18:45'),(58,1,42,NULL,NULL,NULL,'2023-03-12 18:22:16','2023-03-12 18:22:16'),(59,1,43,NULL,NULL,NULL,'2023-03-12 18:23:37','2023-03-12 18:23:37'),(60,1,44,NULL,NULL,NULL,'2023-03-12 18:24:40','2023-03-12 18:24:40'),(61,1,45,NULL,NULL,NULL,'2023-03-12 18:25:53','2023-03-12 18:25:53'),(62,1,46,NULL,NULL,NULL,'2023-03-12 18:26:45','2023-03-12 18:26:45'),(63,1,47,NULL,NULL,NULL,'2023-03-12 18:30:25','2023-03-12 18:30:25'),(64,1,48,NULL,NULL,NULL,'2023-03-12 18:31:19','2023-03-12 18:31:19'),(65,1,49,NULL,NULL,NULL,'2023-03-12 18:32:06','2023-03-12 18:32:06'),(66,1,50,NULL,NULL,NULL,'2023-03-12 18:34:10','2023-03-12 18:34:10'),(67,1,51,NULL,NULL,NULL,'2023-03-12 18:34:58','2023-03-12 18:34:58'),(68,1,40,NULL,NULL,NULL,'2023-03-12 18:37:27','2023-03-12 18:37:27'),(69,1,52,NULL,NULL,NULL,'2023-03-12 18:39:40','2023-03-12 18:39:40');

--
-- 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `menus` VALUES (1,'{\"en\":\"\\u0637\\u0628\\u064a\\u0629\",\"ar\":\"\\u0627\\u0644\\u0631\\u0626\\u064a\\u0633\\u064a\\u0629\"}','alryysy',1,'2022-06-28 18:02:30','2022-08-10 19:23:30');

--
-- 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 09:59:27','2019-12-09 09: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 11:50:34','2021-09-01 11:50:34'),(2,'users.create','web','2021-09-01 11:50:34','2021-09-01 11:50:34'),(3,'users.edit','web','2021-09-01 11:50:34','2021-09-01 11:50:34'),(4,'users.delete','web','2021-09-01 11:50:34','2021-09-01 11:50:34'),(5,'menu.view','web','2021-09-01 12:08:10','2021-09-01 12:08:10'),(6,'menu.create','web','2021-09-01 12:08:10','2021-09-01 12:08:10'),(7,'menu.edit','web','2021-09-01 12:08:10','2021-09-01 12:08:10'),(8,'menu.delete','web','2021-09-01 12:08:10','2021-09-01 12:08:10'),(9,'movies.view','web','2021-09-02 11:14:20','2021-09-02 11:14:20'),(10,'movies.create','web','2021-09-02 11:14:20','2021-09-02 11:14:20'),(11,'movies.edit','web','2021-09-02 11:14:20','2021-09-02 11:14:20'),(12,'movies.delete','web','2021-09-02 11:14:20','2021-09-02 11:14:20'),(13,'tvseries.view','web','2021-09-02 11:14:28','2021-09-02 11:14:28'),(14,'tvseries.create','web','2021-09-02 11:14:28','2021-09-02 11:14:28'),(15,'tvseries.edit','web','2021-09-02 11:14:28','2021-09-02 11:14:28'),(16,'tvseries.delete','web','2021-09-02 11:14:29','2021-09-02 11:14:29'),(17,'livetv.view','web','2021-09-02 11:14:37','2021-09-02 11:14:37'),(18,'livetv.create','web','2021-09-02 11:14:37','2021-09-02 11:14:37'),(19,'livetv.edit','web','2021-09-02 11:14:37','2021-09-02 11:14:37'),(20,'livetv.delete','web','2021-09-02 11:14:37','2021-09-02 11:14:37'),(21,'liveevent.view','web','2021-09-02 11:14:44','2021-09-02 11:14:44'),(22,'liveevent.create','web','2021-09-02 11:14:44','2021-09-02 11:14:44'),(23,'liveevent.edit','web','2021-09-02 11:14:44','2021-09-02 11:14:44'),(24,'liveevent.delete','web','2021-09-02 11:14:44','2021-09-02 11:14:44'),(25,'audio.view','web','2021-09-02 11:14:55','2021-09-02 11:14:55'),(26,'audio.create','web','2021-09-02 11:14:55','2021-09-02 11:14:55'),(27,'audio.edit','web','2021-09-02 11:14:55','2021-09-02 11:14:55'),(28,'audio.delete','web','2021-09-02 11:14:55','2021-09-02 11:14:55'),(29,'package.view','web','2021-09-02 11:17:22','2021-09-02 11:17:22'),(30,'package.create','web','2021-09-02 11:17:23','2021-09-02 11:17:23'),(31,'package.edit','web','2021-09-02 11:17:23','2021-09-02 11:17:23'),(32,'package.delete','web','2021-09-02 11:17:23','2021-09-02 11:17:23'),(33,'blog.view','web','2021-09-02 11:17:53','2021-09-02 11:17:53'),(34,'blog.create','web','2021-09-02 11:17:53','2021-09-02 11:17:53'),(35,'blog.edit','web','2021-09-02 11:17:53','2021-09-02 11:17:53'),(36,'blog.delete','web','2021-09-02 11:17:54','2021-09-02 11:17:54'),(37,'coupon.view','web','2021-09-02 11:19:58','2021-09-02 11:19:58'),(38,'coupon.create','web','2021-09-02 11:19:58','2021-09-02 11:19:58'),(39,'coupon.edit','web','2021-09-02 11:19:58','2021-09-02 11:19:58'),(40,'coupon.delete','web','2021-09-02 11:19:58','2021-09-02 11:19:58'),(41,'addon-manager.manage','web','2021-09-02 11:40:25','2021-09-02 11:40:25'),(42,'actor.view','web','2021-09-02 15:44:09','2021-09-02 15:44:09'),(43,'actor.create','web','2021-09-02 15:44:09','2021-09-02 15:44:09'),(44,'actor.edit','web','2021-09-02 15:44:10','2021-09-02 15:44:10'),(45,'actor.delete','web','2021-09-02 15:44:10','2021-09-02 15:44:10'),(46,'genre.view','web','2021-09-02 15:44:19','2021-09-02 15:44:19'),(47,'genre.create','web','2021-09-02 15:44:19','2021-09-02 15:44:19'),(48,'genre.edit','web','2021-09-02 15:44:19','2021-09-02 15:44:19'),(49,'genre.delete','web','2021-09-02 15:44:19','2021-09-02 15:44:19'),(50,'director.view','web','2021-09-02 15:44:48','2021-09-02 15:44:48'),(51,'director.create','web','2021-09-02 15:44:48','2021-09-02 15:44:48'),(52,'director.edit','web','2021-09-02 15:44:49','2021-09-02 15:44:49'),(53,'director.delete','web','2021-09-02 15:44:49','2021-09-02 15:44:49'),(54,'label.view','web','2021-09-02 15:45:23','2021-09-02 15:45:23'),(55,'label.create','web','2021-09-02 15:45:23','2021-09-02 15:45:23'),(56,'label.edit','web','2021-09-02 15:45:23','2021-09-02 15:45:23'),(57,'label.delete','web','2021-09-02 15:45:23','2021-09-02 15:45:23'),(58,'audiolanguage.view','web','2021-09-02 16:07:35','2021-09-02 16:07:35'),(59,'audiolanguage.create','web','2021-09-02 16:07:35','2021-09-02 16:07:35'),(60,'audiolanguage.edit','web','2021-09-02 16:07:35','2021-09-02 16:07:35'),(61,'audiolanguage.delete','web','2021-09-02 16:07:36','2021-09-02 16:07:36'),(62,'manual-payment.view','web','2021-09-02 16:49:38','2021-09-02 16:49:38'),(63,'manual-payment.create','web','2021-09-02 16:49:38','2021-09-02 16:49:38'),(64,'manual-payment.edit','web','2021-09-02 16:49:38','2021-09-02 16:49:38'),(65,'manual-payment.delete','web','2021-09-02 16:49:38','2021-09-02 16:49:38'),(66,'pages.view','web','2021-09-02 16:49:51','2021-09-02 16:49:51'),(67,'pages.create','web','2021-09-02 16:49:51','2021-09-02 16:49:51'),(68,'pages.edit','web','2021-09-02 16:49:52','2021-09-02 16:49:52'),(69,'pages.delete','web','2021-09-02 16:49:52','2021-09-02 16:49:52'),(70,'faq.view','web','2021-09-02 16:50:01','2021-09-02 16:50:01'),(71,'faq.create','web','2021-09-02 16:50:01','2021-09-02 16:50:01'),(72,'faq.edit','web','2021-09-02 16:50:01','2021-09-02 16:50:01'),(73,'faq.delete','web','2021-09-02 16:50:02','2021-09-02 16:50:02'),(74,'site-settings.language','web','2021-09-02 16:52:36','2021-09-02 16:52:36'),(75,'pushnotification.settings','web','2021-09-02 16:53:18','2021-09-02 16:53:18'),(76,'front-settings.sliders','web','2021-09-02 16:54:07','2021-09-02 16:54:07'),(77,'reports.viewtraker','web','2021-09-02 16:54:38','2021-09-02 16:54:38'),(78,'site-settings.genral-settings','web','2021-09-02 16:54:54','2021-09-02 16:54:54'),(79,'site-settings.mail-settings','web','2021-09-02 16:55:10','2021-09-02 16:55:10'),(80,'site-settings.social-login-settings','web','2021-09-02 16:55:48','2021-09-02 16:55:48'),(81,'site-settings.style-settings','web','2021-09-02 16:58:12','2021-09-02 16:58:12'),(82,'site-settings.seo','web','2021-09-02 16:58:31','2021-09-02 16:58:31'),(83,'comment-settings.comments','web','2021-09-04 13:33:08','2021-09-04 13:33:08'),(84,'help.db-backup','web','2021-09-04 13:33:42','2021-09-04 13:33:42'),(85,'producer-content.manage','web','2021-09-04 13:34:07','2021-09-04 13:34:07'),(86,'notification.manage','web','2021-09-04 13:34:33','2021-09-04 13:34:33'),(87,'front-settings.landing-page','web','2021-09-04 13:35:38','2021-09-04 13:35:38'),(88,'front-settings.auth-customization','web','2021-09-04 13:36:46','2021-09-04 13:36:46'),(89,'front-settings.short-promo','web','2021-09-04 13:37:17','2021-09-04 13:37:17'),(90,'site-settings.player-setting','web','2021-09-04 13:43:34','2021-09-04 13:43:34'),(91,'site-settings.pwa','web','2021-09-04 13:48:59','2021-09-04 13:48:59'),(92,'comment-settings.subcomments','web','2021-09-04 16:32:14','2021-09-04 16:32:14'),(93,'site-settings.color-option','web','2021-09-04 16:35:06','2021-09-04 16:35:06'),(94,'site-settings.adsense','web','2021-09-04 16:35:25','2021-09-04 16:35:25'),(95,'site-settings.chat-setting','web','2021-09-04 16:35:41','2021-09-04 16:35:41'),(96,'site-settings.api-settings','web','2021-09-04 16:36:05','2021-09-04 16:36:05'),(97,'site-settings.termsandcondition','web','2021-09-04 16:36:44','2021-09-04 16:36:44'),(98,'site-settings.privacy-policy','web','2021-09-04 16:37:07','2021-09-04 16:37:07'),(99,'site-settings.refund-policy','web','2021-09-04 16:37:51','2021-09-04 16:37:51'),(100,'site-settings.copyrights','web','2021-09-04 16:38:12','2021-09-04 16:38:12'),(101,'reports.user-subscription','web','2021-09-04 16:38:33','2021-09-04 16:38:33'),(102,'reports.device-history','web','2021-09-04 16:38:47','2021-09-04 16:38:47'),(103,'reports.revenue','web','2021-09-04 16:39:10','2021-09-04 16:39:10'),(104,'help.system-status','web','2021-09-04 16:40:52','2021-09-04 16:40:52'),(105,'help.remove-public','web','2021-09-04 16:41:10','2021-09-04 16:41:10'),(106,'help.clear-cache','web','2021-09-04 16:41:28','2021-09-04 16:41:28'),(107,'ads.view','web','2021-09-04 16:42:23','2021-09-04 16:42:23'),(108,'ads.create','web','2021-09-04 16:42:23','2021-09-04 16:42:23'),(109,'ads.edit','web','2021-09-04 16:42:24','2021-09-04 16:42:24'),(110,'ads.delete','web','2021-09-04 16:42:24','2021-09-04 16:42:24'),(111,'googleads.view','web','2021-09-04 16:42:34','2021-09-04 16:42:34'),(112,'googleads.create','web','2021-09-04 16:42:34','2021-09-04 16:42:34'),(113,'googleads.edit','web','2021-09-04 16:42:34','2021-09-04 16:42:34'),(114,'googleads.delete','web','2021-09-04 16:42:34','2021-09-04 16:42:34'),(115,'package-feature.view','web','2021-09-04 16:42:48','2021-09-04 16:42:48'),(116,'package-feature.create','web','2021-09-04 16:42:48','2021-09-04 16:42:48'),(117,'package-feature.edit','web','2021-09-04 16:42:48','2021-09-04 16:42:48'),(118,'package-feature.delete','web','2021-09-04 16:42:48','2021-09-04 16:42:48'),(119,'front-settings.social-icon','web','2021-09-06 09:44:57','2021-09-06 09:44:57'),(120,'site-settings.manualpayment','web','2021-09-06 10:01:27','2021-09-06 10:01:27'),(121,'reports.stripe-report','web','2021-09-06 11:28:20','2021-09-06 11:28:20'),(122,'help.import-demo','web','2021-09-22 10:56:05','2021-09-22 10:56:05'),(123,'site-settings.currency','web','2021-09-22 10:56:49','2021-09-22 10:56:49'),(124,'roles.view','web','2021-09-22 11:05:12','2021-09-22 11:05:12'),(125,'roles.create','web','2021-09-22 11:06:30','2021-09-22 11:06:30'),(126,'roles.edit','web','2021-09-22 11:06:30','2021-09-22 11:06:30'),(127,'roles.delete','web','2021-09-22 11:06:30','2021-09-22 11:06:30'),(128,'dashboard.states','web','2021-10-20 13:10:22','2021-10-20 13:10:22'),(129,'app-settings.setting','web','2021-10-21 11:03:43','2021-10-21 11:03:43'),(130,'app-settings.slider','web','2021-10-21 11:03:54','2021-10-21 11: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 11: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 11:54:28','2021-09-01 11:54:28'),(2,'Producer','web','2021-09-04 13:52:18','2021-09-04 13: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 10: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 ('1ByDH0AteaVnWFvJRMQlQAWrHaWOw6IHXKOwrZin',NULL,'170.64.162.67','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4859.172 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibG5wdlh3bkM5OUk3VDh3OU9VczRpbmEySWNuRnRzN0lsbUNuQ3ZhVSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTc6Imh0dHA6Ly90aXJ5YXEubmV0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1680509152),('DH7ZcDvWUdMgvSwOnqlkdcGZGkmNKND8x86CmjGE',NULL,'152.231.50.139','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRHlmUXJjRFVBOGI4eTJMQVZpMkw4WUtITHRKZ3pHTHdLbG9peXNBSCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xNjQuOTIuMTg0LjI0OjgwODAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1680512984),('dkOdLFLjzUtlKHz0fLl6htwIXU6rWhOyCcGk72kJ',NULL,'66.249.69.136','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkduVk1jTEVaWTRUQ2Ezam1tcUtvYzI4WjREaGZaaWM2eU41V05pSSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1680513951),('IgToUU096zVP9lOZJrg2PU3J9QMiYpI7TeJyv10e',NULL,'58.187.9.230','masscan/1.0 (https://github.com/robertdavidgraham/masscan)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQXpwWTVoWVE1ZGVXQ0tmVFNONUZ0aWhkbk9aNGZxQUR3aDFJS25IaCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly93d3cuY2Fwc29sYS5ueHRzZXJ2ZXIuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1680516706),('juA9mIsAyKe2SOJDwSZjagG1MZCAzVJCYFEKrfNL',NULL,'94.78.99.66','Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNkVsUk0yWkV1QXh5S25RUW5tZ0h6Y3VGSThHa3VIaENmak15d3ZSMyI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xNjQuOTIuMTg0LjI0OjgwODAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1680509191),('KEIToBS4dqDy7F3rwET2zB5ze0HSrKzEiHmunER0',NULL,'196.1.195.5','Mozilla/5.0 (Linux; Android 6.0.1; SM-G532F Build/MMB29T) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Mobile Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRGs5NTJyTE9MZUhCY0F3cHN6eGJoSzB6WFd3cnNVVGVBOWxQV2NaZiI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly8xNjQuOTIuMTg0LjI0OjgwODAvZ3Vlc3QvYWxyeXlzeSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1680513981),('MJNHFKuL8SRle34t3fgObQpHZ7cC9c5zw7CmQu9R',NULL,'183.136.225.44','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko/20100101 Firefox/47.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidjRuYzlhVk9ibGhFRFlKTEFlaHVyMzZiTGg5M2hRTlV0N3RDb3pTYyI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly93d3cudGlyeWFxLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1680513359),('neuP2Wl7zPgS44vPqlJubr4k8hcU9viT6M9MAWzi',NULL,'23.249.172.151','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiR0tzYnl2cVd6N2owMUZBOUh6dDNzYmhRcDZ3cXRXNEs3WGw0d3RnQSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly90aXJ5YXEubmV0L2d1ZXN0L2Fscnl5c3kiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1680516334),('uprDg7lAs4UPtm6vLNa0MeElsjogMlzM8OcMtG7M',NULL,'83.142.52.110','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.5563.146 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQk1wa0ViMTQ4WVpJeUpZZ1FZUmNubURUelB0WVhaVDV1cjk0T0hIayI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly90aXJ5YXEubmV0L2d1ZXN0L2Fscnl5c3kiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1680506687),('vdyCJ2D0Ie59EOo8DZvUYBaIclu0SVgQUBCvRxLe',NULL,'46.174.191.31','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_0) AppleWebKit/534.30 (KHTML, like Gecko) Chrome/12.0.742.100 Safari/534.30','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZktlQlE5TzVjRExzbzJGZUZvcGZjRlo2VEFmYXA1WlBsRWM4UFB1diI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly93d3cuY2Fwc29sYS5ueHRzZXJ2ZXIuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1680511784),('VUqXuesXpf3ts0Ty8G3RFvvcRawAgDJiul3Zl90E',NULL,'172.104.11.51','Mozilla/5.0 (Macintosh; Intel Mac OS X 13_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZGVWeGxhVTNmOW50UjIwM04wQ2lQUVk0UEJxVEhDY2JHVEh0dllGUSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xNjQuOTIuMTg0LjI0OjgwODAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1680506221),('WmkDlCuHpSuc5UXxrYrbEmNX280KXK1Nq0bN4c9A',NULL,'154.103.148.37','Mozilla/5.0 (Linux; Android 10; STK-L21) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Mobile Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaDBNeWxXSzd3VFBrS3FocEZONlFaTGJvWXhiWDBNYmZqOWhnZ1hZWSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly8xNjQuOTIuMTg0LjI0OjgwODAvZ3Vlc3QvYWxyeXlzeSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1680514017),('Y6qh4sJe2cOwxNwGAgpzjNVt11DvQZZL027mtse3',NULL,'89.169.19.74','Xenu Link Sleuth/1.3.8','YToyOntzOjY6Il90b2tlbiI7czo0MDoiV0IwTEtmVWxmdDdIekJURndEdWo0V0kxUDJSTjJHQzFZOGlGbHpqRyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1680510258),('YPWtvuwEYFKdjivCJgL1wzH8OPqWoFTfcs0xMyW2',NULL,'183.136.225.44','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:47.0) Gecko/20100101 Firefox/47.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZzdCbWEzQXVOSmNzOFZ6ZFFKSW5lWU9vRGE2NXlMckVJNFBLMlBORSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly93d3cudGlyeWFxLm5ldC9ndWVzdC9hbHJ5eXN5Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1680513364),('zxuKgC4sk3kEHuIPQRPIvCeXQiFxcefDLKR943XR',NULL,'162.243.147.29','Mozilla/5.0 zgrab/0.x','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSnFRdGZvNWtoMnNZN3k4YXNZYkRGSTVrSVg5c3ViM3ZHVkI5WkVRVCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xNjQuOTIuMTg0LjI0OjgwODAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1680509532),('ZZPduqYqCshi55u4dISQjVrdhyxAoeJY7jOlhyLE',NULL,'170.64.162.67','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4859.172 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoib1pUY2Nrd2RBVUo4d1ZvRVFxeWRScU55TFpSdHdUbEllTmZaU3k4NSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly90aXJ5YXEubmV0L2d1ZXN0L2Fscnl5c3kiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1680509153);

--
-- 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 09:09:08','2020-11-02 09: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=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `videolinks` VALUES (33,33,NULL,'iframeurl','https://player.vimeo.com/video/807212701?h=808d7c51a3',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:06:08','2023-03-12 18:06:08',NULL),(34,34,NULL,'iframeurl','https://player.vimeo.com/video/807212435?h=8b56d8d541',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:07:19','2023-03-12 18:07:19',NULL),(35,35,NULL,'iframeurl','https://player.vimeo.com/video/807212103?h=b532e6bb31',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:08:26','2023-03-12 18:08:26',NULL),(36,36,NULL,'iframeurl','https://player.vimeo.com/video/807211515?h=182948670b',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:09:36','2023-03-12 18:09:36',NULL),(37,37,NULL,'iframeurl','https://player.vimeo.com/video/807217507?h=dd7cf335d9',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:14:21','2023-03-12 18:14:21',NULL),(38,38,NULL,'iframeurl','https://player.vimeo.com/video/807217262?h=338facf27f',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:15:30','2023-03-12 18:15:30',NULL),(39,39,NULL,'iframeurl','https://player.vimeo.com/video/807216199?h=0d43b91280',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:16:27','2023-03-12 18:16:27',NULL),(40,40,NULL,'iframeurl','https://player.vimeo.com/video/807215952?h=e33486b9c7',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:17:37','2023-03-12 18:17:37',NULL),(41,41,NULL,'iframeurl','https://player.vimeo.com/video/807215647?h=272e775e91',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:18:45','2023-03-12 18:18:45',NULL),(42,42,NULL,'iframeurl','https://player.vimeo.com/video/807207162?h=8cf22c594f',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:22:16','2023-03-12 18:22:16',NULL),(43,43,NULL,'iframeurl','https://player.vimeo.com/video/807207024?h=aff1b50962',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:23:37','2023-03-12 18:23:37',NULL),(44,44,NULL,'iframeurl','https://player.vimeo.com/video/807206850?h=9dc2b9da2b',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:24:40','2023-03-12 18:24:40',NULL),(45,45,NULL,'iframeurl','https://player.vimeo.com/video/807206589?h=25c4ceaa5e',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:25:53','2023-03-12 18:25:53',NULL),(46,46,NULL,'iframeurl','https://player.vimeo.com/video/807206376?h=ec4207c7f8',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:26:45','2023-03-12 18:26:45',NULL),(47,47,NULL,'iframeurl','https://player.vimeo.com/video/807194856?h=c9cacf5dae',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:30:25','2023-03-12 18:30:25',NULL),(48,48,NULL,'iframeurl','https://player.vimeo.com/video/807194705?h=21b32843b6',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:31:19','2023-03-12 18:31:19',NULL),(49,49,NULL,'iframeurl','https://player.vimeo.com/video/807194373?h=989788fe11',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:32:06','2023-03-12 18:32:06',NULL),(50,50,NULL,'iframeurl','https://player.vimeo.com/video/807194171?h=0bb533eda5',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:34:10','2023-03-12 18:34:10',NULL),(51,51,NULL,'iframeurl','https://player.vimeo.com/video/807192610?h=9ee30a5462',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:34:58','2023-03-12 18:34:58',NULL),(52,52,NULL,'iframeurl','https://player.vimeo.com/video/807212961?h=e417c0d8f0',NULL,NULL,NULL,NULL,NULL,'2023-03-12 18:39:40','2023-03-12 18:39:40',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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- 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=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- 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`
--



