--
-- Host: localhost    Database: shafakhana
-- ------------------------------------------------------


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

CREATE TABLE `actors` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `biography` text COLLATE utf8mb4_unicode_ci,
  `place_of_birth` text COLLATE utf8mb4_unicode_ci,
  `DOB` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `slug` longtext 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_video` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_location` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ad_target` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ad_hold` int DEFAULT NULL,
  `time` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `endtime` varchar(100) 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 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 12: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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) 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) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` varchar(5000) 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 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 COLLATE utf8mb4_unicode_ci,
  `ip_block` tinyint(1) NOT NULL DEFAULT '1',
  `block_ips` longtext COLLATE utf8mb4_unicode_ci,
  `maintenance` tinyint(1) NOT NULL DEFAULT '1',
  `comming_soon_text` longtext 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 COLLATE utf8mb4_unicode_ci,
  `remove_thumbnail` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `buttons` VALUES (1,0,1,1,0,1,0,'2018-07-31 11:30:00','2022-12-12 14:24:05',NULL,0,NULL,1,NULL,0,1,0,0,0,0,0,NULL,0);

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

CREATE TABLE `callback_addresses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `address` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pubkey` text COLLATE utf8mb4_unicode_ci,
  `ipn_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_navigation_color` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_navigation_color` text COLLATE utf8mb4_unicode_ci,
  `default_text_color` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_text_color` text COLLATE utf8mb4_unicode_ci,
  `default_text_on_color` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_text_on_color` text COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_color` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_color` text COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_bgcolor` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_bgcolor` text COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_bgcolor_on_hover` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_bgcolor_on_hover` text COLLATE utf8mb4_unicode_ci,
  `default_back_to_top_color_on_hover` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_back_to_top_color_on_hover` text COLLATE utf8mb4_unicode_ci,
  `default_footer_background_color` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_footer_background_color` text 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 15:54:15');

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

CREATE TABLE `comments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `blog_id` int NOT NULL,
  `comment` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_id` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `to` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `percent_off` double(8,2) DEFAULT NULL,
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount_off` double(8,2) DEFAULT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'once',
  `max_redemptions` varchar(191) 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 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `format` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exchange_rate` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` longtext 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 17:11:27','2021-10-18 11:30:00'),(2,'US Dollar','USD','$','$1,0.00','1','[\"stripe\",\"paypal\",\"braintree\",\"omise\",\"payhere\",\"flutterrave\",\"mollie\"]',0,'2021-09-08 17:13:00','2021-10-18 11:30:00'),(3,'Euro','EUR','€','1.0,00 €','0.863677','[\"stripe\",\"paypal\",\"braintree\",\"omise\",\"payhere\",\"flutterrave\"]',0,'2021-09-08 17:13:39','2021-10-18 11:30:00'),(4,'Sri Lanka Rupee','LKR','₨','₨ 1,0.','202.450844','[\"payhere\"]',0,'2021-09-08 17:52:46','2021-10-18 11:30:00'),(5,'UAE Dirham','AED','دإ‏','دإ‏ 1,0.00','3.6731','[\"mollie\",\"cashfree\"]',0,'2021-09-09 15:58:19','2021-10-18 11:30:00'),(6,'Nigeria, Naira','NGN','₦','₦1,0.00','411.92','[\"stripe\",\"flutterrave\",\"paystack\"]',0,'2021-09-13 15:03:42','2021-10-18 11:30:00'),(7,'Angola, Kwanza','AOA','Kz','Kz1,0.00','597.698','[\"stripe\"]',0,'2021-10-01 14:01:26','2021-10-18 11:30:00'),(8,'Tunisian Dinar','TND','د.ت.‏','د.ت.‏ 1,0.000','2.8235','[\"stripe\"]',0,'2021-10-04 12:33:43','2021-10-18 11:30:00'),(9,'Kenyan Shilling','KES','S','S1,0.00','110.9','[\"stripe\"]',0,'2021-10-04 13:46:10','2021-10-18 11:30:00');

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

CREATE TABLE `custom_pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `in_show_menu` tinyint(1) DEFAULT NULL,
  `detail` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `txn_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL,
  `status_text` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirms` tinyint unsigned NOT NULL,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amounti` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fee` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feei` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) 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 DELETE RESTRICT 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `biography` text COLLATE utf8mb4_unicode_ci,
  `place_of_birth` text COLLATE utf8mb4_unicode_ci,
  `DOB` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `slug` longtext 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `donor_msg` text COLLATE utf8mb4_unicode_ci,
  `amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_id` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `episode_no` int DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tmdb` char(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8mb4_unicode_ci,
  `a_language` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle` tinyint(1) DEFAULT NULL,
  `released` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` char(191) 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 COLLATE utf8mb4_unicode_ci,
  `answer` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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


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

CREATE TABLE `genres` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) 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=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `genres` VALUES (16,'{\"en\":\"\\u0627\\u0637\\u0641\\u0627\\u0644\",\"ar\":\"\\u0627\\u0637\\u0641\\u0627\\u0644\"}','genre_1671560050shafakhana-Geners-02.png',8,'2022-12-18 17:31:57','2022-12-20 23:44:10'),(20,'{\"ar\":\"\\u0627\\u0644\\u062c\\u0647\\u0627\\u0632 \\u0627\\u0644\\u0639\\u0635\\u0628\\u064a\"}','genre_1672143572shafakhana-Geners-09.png',2,'2022-12-27 16:19:52','2022-12-27 18:14:48'),(21,'{\"ar\":\"\\u0627\\u0644\\u062c\\u0647\\u0627\\u0632 \\u0627\\u0644\\u0647\\u0636\\u0645\\u064a\"}','genre_1672143598shafakhana-Geners-08.png',3,'2022-12-27 16:20:14','2022-12-27 18:15:00'),(23,'{\"ar\":\"\\u0627\\u0644\\u0645\\u0631\\u0623\\u0629\"}','genre_1672143647shafakhana-Geners-06.png',5,'2022-12-27 16:20:43','2022-12-27 18:15:29'),(24,'{\"ar\":\"\\u0627\\u0644\\u0639\\u0627\\u0645\\u0647\"}','genre_1672143669shafakhana-Geners-05.png',6,'2022-12-27 16:20:54','2022-12-27 18:15:37'),(25,'{\"ar\":\"\\u062a\\u063a\\u0630\\u064a\\u0629 \\u0648 \\u062d\\u0645\\u064a\\u0647\"}','genre_1672143697shafakhana-Geners-04.png',7,'2022-12-27 16:21:14','2022-12-27 18:15:55'),(32,'{\"ar\":\"\\u0627\\u0644\\u0627\\u0645\\u0631\\u0627\\u0636 \\u0627\\u0644\\u0645\\u0632\\u0645\\u0646\\u0647\"}','genre_1672143721shafakhana-Geners-03.png',9,'2022-12-27 16:24:03','2022-12-27 18:16:08'),(33,'{\"ar\":\"\\u0627\\u0644\\u0623\\u0645\\u0631\\u0627\\u0636 \\u0627\\u0644\\u0645\\u0639\\u062f\\u064a\\u0629\"}','genre_1672143805shafakhana-Geners-10.png',10,'2022-12-27 16:24:28','2022-12-27 18:16:38'),(35,'{\"ar\":\"\\u0627\\u0644\\u062c\\u0647\\u0627\\u0632 \\u0627\\u0644\\u062a\\u0646\\u0641\\u0633\\u064a\"}',NULL,9,'2022-12-27 18:28:03','2022-12-27 18:33:06'),(36,'{\"ar\":\"\\u0627\\u0644\\u0635\\u062f\\u0631 \\u0648 \\u0627\\u0644\\u062c\\u0647\\u0627\\u0632 \\u0627\\u0644\\u062a',NULL,10,'2022-12-28 10:16:46','2022-12-28 10:16:46'),(37,'{\"ar\":\"\\u0645\\u0639\\u062a\\u0632 \\u0639\\u062f\\u0644\\u064a \\u0645\\u062d\\u0645\\u062f \\u0639\\u0628\\u062f',NULL,11,'2022-12-28 10:17:29','2022-12-28 10:17:29'),(38,'{\"ar\":\"\\u0645\\u0639\\u062a\\u0632-\\u0639\\u062f\\u0644\\u064a-\\u0645\\u062d\\u0645\\u062f\"}',NULL,12,'2022-12-28 10:17:51','2022-12-28 10:17:51'),(39,'{\"ar\":\"mutaz adli siam\"}',NULL,13,'2022-12-28 10:18:32','2022-12-28 10:18:32');

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

CREATE TABLE `google_ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `google_ad_client` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_slot` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_width` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_height` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_starttime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `google_ad_endtime` varchar(191) 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) 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=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `home_sliders` VALUES (11,NULL,NULL,'slide_1671527065shafakhana-SLIDER-111.png',1,1,'2022-12-20 14:34:27','2022-12-20 14:34:27'),(12,NULL,NULL,'slide_1671527079shafakhana-SLIDER 2222.png',1,2,'2022-12-20 14:34:40','2022-12-20 14:34:40');

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

CREATE TABLE `ipns` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ipn_version` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ipn_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ref_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ipn_mode` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
  `merchant` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ipn_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(128) 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) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amounti` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buyer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom` text COLLATE utf8mb4_unicode_ci,
  `send_tx` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_confirms` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text 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 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8mb4_unicode_ci,
  `button` tinyint(1) NOT NULL DEFAULT '1',
  `button_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `button_link` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) 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-12-12 14:23:01',0),(2,'ar','arabic',1,'2022-12-12 14:23:01','2022-12-12 14:23:01',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) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iframeurl` text COLLATE utf8mb4_unicode_ci,
  `ready_url` text COLLATE utf8mb4_unicode_ci,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  `thumbnail` text COLLATE utf8mb4_unicode_ci,
  `poster` text COLLATE utf8mb4_unicode_ci,
  `genre_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` longtext COLLATE utf8mb4_unicode_ci,
  `organized_by` text 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `log` text 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_name` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_from` datetime DEFAULT NULL,
  `subscription_to` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

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


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

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

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

INSERT INTO `menu_genre_shows` VALUES (15,1,2,9),(16,1,2,10),(17,1,2,11),(18,1,2,12),(19,1,2,13),(20,1,2,14),(21,1,2,15),(22,1,2,16),(23,1,2,17),(24,1,2,18);

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

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

INSERT INTO `menu_sections` VALUES (5,1,2,6,1,0);

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

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


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

CREATE TABLE `menus` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) 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\":\"\\u0627\\u0644\\u0631\\u0626\\u064a\\u0633\\u064a\\u0629\",\"ar\":\"\\u0627\\u0644\\u0631\\u0626\\u064a\\u0633\\u064a\\u0629\"}','alryysy',1,'2022-12-11 18:36:31','2022-12-19 19:45:46');

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) 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) 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) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `movie_id` int DEFAULT NULL,
  `tv_series_id` int DEFAULT NULL,
  `comment` text 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) 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) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen2` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen3` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen4` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned NOT NULL,
  `activescreen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen_1_used` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `screen_2_used` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `screen_3_used` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `screen_4_used` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `device_mac_1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_mac_2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_mac_3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_mac_4` varchar(100) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` longtext COLLATE utf8mb4_unicode_ci,
  `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text 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) 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) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `interval` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `interval_count` int DEFAULT NULL,
  `trial_period_days` varchar(191) 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 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_name` varchar(191) 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) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) 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 12:50:34','2021-09-01 12:50:34'),(2,'users.create','web','2021-09-01 12:50:34','2021-09-01 12:50:34'),(3,'users.edit','web','2021-09-01 12:50:34','2021-09-01 12:50:34'),(4,'users.delete','web','2021-09-01 12:50:34','2021-09-01 12:50:34'),(5,'menu.view','web','2021-09-01 13:08:10','2021-09-01 13:08:10'),(6,'menu.create','web','2021-09-01 13:08:10','2021-09-01 13:08:10'),(7,'menu.edit','web','2021-09-01 13:08:10','2021-09-01 13:08:10'),(8,'menu.delete','web','2021-09-01 13:08:10','2021-09-01 13:08:10'),(9,'movies.view','web','2021-09-02 12:14:20','2021-09-02 12:14:20'),(10,'movies.create','web','2021-09-02 12:14:20','2021-09-02 12:14:20'),(11,'movies.edit','web','2021-09-02 12:14:20','2021-09-02 12:14:20'),(12,'movies.delete','web','2021-09-02 12:14:20','2021-09-02 12:14:20'),(13,'tvseries.view','web','2021-09-02 12:14:28','2021-09-02 12:14:28'),(14,'tvseries.create','web','2021-09-02 12:14:28','2021-09-02 12:14:28'),(15,'tvseries.edit','web','2021-09-02 12:14:28','2021-09-02 12:14:28'),(16,'tvseries.delete','web','2021-09-02 12:14:29','2021-09-02 12:14:29'),(17,'livetv.view','web','2021-09-02 12:14:37','2021-09-02 12:14:37'),(18,'livetv.create','web','2021-09-02 12:14:37','2021-09-02 12:14:37'),(19,'livetv.edit','web','2021-09-02 12:14:37','2021-09-02 12:14:37'),(20,'livetv.delete','web','2021-09-02 12:14:37','2021-09-02 12:14:37'),(21,'liveevent.view','web','2021-09-02 12:14:44','2021-09-02 12:14:44'),(22,'liveevent.create','web','2021-09-02 12:14:44','2021-09-02 12:14:44'),(23,'liveevent.edit','web','2021-09-02 12:14:44','2021-09-02 12:14:44'),(24,'liveevent.delete','web','2021-09-02 12:14:44','2021-09-02 12:14:44'),(25,'audio.view','web','2021-09-02 12:14:55','2021-09-02 12:14:55'),(26,'audio.create','web','2021-09-02 12:14:55','2021-09-02 12:14:55'),(27,'audio.edit','web','2021-09-02 12:14:55','2021-09-02 12:14:55'),(28,'audio.delete','web','2021-09-02 12:14:55','2021-09-02 12:14:55'),(29,'package.view','web','2021-09-02 12:17:22','2021-09-02 12:17:22'),(30,'package.create','web','2021-09-02 12:17:23','2021-09-02 12:17:23'),(31,'package.edit','web','2021-09-02 12:17:23','2021-09-02 12:17:23'),(32,'package.delete','web','2021-09-02 12:17:23','2021-09-02 12:17:23'),(33,'blog.view','web','2021-09-02 12:17:53','2021-09-02 12:17:53'),(34,'blog.create','web','2021-09-02 12:17:53','2021-09-02 12:17:53'),(35,'blog.edit','web','2021-09-02 12:17:53','2021-09-02 12:17:53'),(36,'blog.delete','web','2021-09-02 12:17:54','2021-09-02 12:17:54'),(37,'coupon.view','web','2021-09-02 12:19:58','2021-09-02 12:19:58'),(38,'coupon.create','web','2021-09-02 12:19:58','2021-09-02 12:19:58'),(39,'coupon.edit','web','2021-09-02 12:19:58','2021-09-02 12:19:58'),(40,'coupon.delete','web','2021-09-02 12:19:58','2021-09-02 12:19:58'),(41,'addon-manager.manage','web','2021-09-02 12:40:25','2021-09-02 12:40:25'),(42,'actor.view','web','2021-09-02 16:44:09','2021-09-02 16:44:09'),(43,'actor.create','web','2021-09-02 16:44:09','2021-09-02 16:44:09'),(44,'actor.edit','web','2021-09-02 16:44:10','2021-09-02 16:44:10'),(45,'actor.delete','web','2021-09-02 16:44:10','2021-09-02 16:44:10'),(46,'genre.view','web','2021-09-02 16:44:19','2021-09-02 16:44:19'),(47,'genre.create','web','2021-09-02 16:44:19','2021-09-02 16:44:19'),(48,'genre.edit','web','2021-09-02 16:44:19','2021-09-02 16:44:19'),(49,'genre.delete','web','2021-09-02 16:44:19','2021-09-02 16:44:19'),(50,'director.view','web','2021-09-02 16:44:48','2021-09-02 16:44:48'),(51,'director.create','web','2021-09-02 16:44:48','2021-09-02 16:44:48'),(52,'director.edit','web','2021-09-02 16:44:49','2021-09-02 16:44:49'),(53,'director.delete','web','2021-09-02 16:44:49','2021-09-02 16:44:49'),(54,'label.view','web','2021-09-02 16:45:23','2021-09-02 16:45:23'),(55,'label.create','web','2021-09-02 16:45:23','2021-09-02 16:45:23'),(56,'label.edit','web','2021-09-02 16:45:23','2021-09-02 16:45:23'),(57,'label.delete','web','2021-09-02 16:45:23','2021-09-02 16:45:23'),(58,'audiolanguage.view','web','2021-09-02 17:07:35','2021-09-02 17:07:35'),(59,'audiolanguage.create','web','2021-09-02 17:07:35','2021-09-02 17:07:35'),(60,'audiolanguage.edit','web','2021-09-02 17:07:35','2021-09-02 17:07:35'),(61,'audiolanguage.delete','web','2021-09-02 17:07:36','2021-09-02 17:07:36'),(62,'manual-payment.view','web','2021-09-02 17:49:38','2021-09-02 17:49:38'),(63,'manual-payment.create','web','2021-09-02 17:49:38','2021-09-02 17:49:38'),(64,'manual-payment.edit','web','2021-09-02 17:49:38','2021-09-02 17:49:38'),(65,'manual-payment.delete','web','2021-09-02 17:49:38','2021-09-02 17:49:38'),(66,'pages.view','web','2021-09-02 17:49:51','2021-09-02 17:49:51'),(67,'pages.create','web','2021-09-02 17:49:51','2021-09-02 17:49:51'),(68,'pages.edit','web','2021-09-02 17:49:52','2021-09-02 17:49:52'),(69,'pages.delete','web','2021-09-02 17:49:52','2021-09-02 17:49:52'),(70,'faq.view','web','2021-09-02 17:50:01','2021-09-02 17:50:01'),(71,'faq.create','web','2021-09-02 17:50:01','2021-09-02 17:50:01'),(72,'faq.edit','web','2021-09-02 17:50:01','2021-09-02 17:50:01'),(73,'faq.delete','web','2021-09-02 17:50:02','2021-09-02 17:50:02'),(74,'site-settings.language','web','2021-09-02 17:52:36','2021-09-02 17:52:36'),(75,'pushnotification.settings','web','2021-09-02 17:53:18','2021-09-02 17:53:18'),(76,'front-settings.sliders','web','2021-09-02 17:54:07','2021-09-02 17:54:07'),(77,'reports.viewtraker','web','2021-09-02 17:54:38','2021-09-02 17:54:38'),(78,'site-settings.genral-settings','web','2021-09-02 17:54:54','2021-09-02 17:54:54'),(79,'site-settings.mail-settings','web','2021-09-02 17:55:10','2021-09-02 17:55:10'),(80,'site-settings.social-login-settings','web','2021-09-02 17:55:48','2021-09-02 17:55:48'),(81,'site-settings.style-settings','web','2021-09-02 17:58:12','2021-09-02 17:58:12'),(82,'site-settings.seo','web','2021-09-02 17:58:31','2021-09-02 17:58:31'),(83,'comment-settings.comments','web','2021-09-04 14:33:08','2021-09-04 14:33:08'),(84,'help.db-backup','web','2021-09-04 14:33:42','2021-09-04 14:33:42'),(85,'producer-content.manage','web','2021-09-04 14:34:07','2021-09-04 14:34:07'),(86,'notification.manage','web','2021-09-04 14:34:33','2021-09-04 14:34:33'),(87,'front-settings.landing-page','web','2021-09-04 14:35:38','2021-09-04 14:35:38'),(88,'front-settings.auth-customization','web','2021-09-04 14:36:46','2021-09-04 14:36:46'),(89,'front-settings.short-promo','web','2021-09-04 14:37:17','2021-09-04 14:37:17'),(90,'site-settings.player-setting','web','2021-09-04 14:43:34','2021-09-04 14:43:34'),(91,'site-settings.pwa','web','2021-09-04 14:48:59','2021-09-04 14:48:59'),(92,'comment-settings.subcomments','web','2021-09-04 17:32:14','2021-09-04 17:32:14'),(93,'site-settings.color-option','web','2021-09-04 17:35:06','2021-09-04 17:35:06'),(94,'site-settings.adsense','web','2021-09-04 17:35:25','2021-09-04 17:35:25'),(95,'site-settings.chat-setting','web','2021-09-04 17:35:41','2021-09-04 17:35:41'),(96,'site-settings.api-settings','web','2021-09-04 17:36:05','2021-09-04 17:36:05'),(97,'site-settings.termsandcondition','web','2021-09-04 17:36:44','2021-09-04 17:36:44'),(98,'site-settings.privacy-policy','web','2021-09-04 17:37:07','2021-09-04 17:37:07'),(99,'site-settings.refund-policy','web','2021-09-04 17:37:51','2021-09-04 17:37:51'),(100,'site-settings.copyrights','web','2021-09-04 17:38:12','2021-09-04 17:38:12'),(101,'reports.user-subscription','web','2021-09-04 17:38:33','2021-09-04 17:38:33'),(102,'reports.device-history','web','2021-09-04 17:38:47','2021-09-04 17:38:47'),(103,'reports.revenue','web','2021-09-04 17:39:10','2021-09-04 17:39:10'),(104,'help.system-status','web','2021-09-04 17:40:52','2021-09-04 17:40:52'),(105,'help.remove-public','web','2021-09-04 17:41:10','2021-09-04 17:41:10'),(106,'help.clear-cache','web','2021-09-04 17:41:28','2021-09-04 17:41:28'),(107,'ads.view','web','2021-09-04 17:42:23','2021-09-04 17:42:23'),(108,'ads.create','web','2021-09-04 17:42:23','2021-09-04 17:42:23'),(109,'ads.edit','web','2021-09-04 17:42:24','2021-09-04 17:42:24'),(110,'ads.delete','web','2021-09-04 17:42:24','2021-09-04 17:42:24'),(111,'googleads.view','web','2021-09-04 17:42:34','2021-09-04 17:42:34'),(112,'googleads.create','web','2021-09-04 17:42:34','2021-09-04 17:42:34'),(113,'googleads.edit','web','2021-09-04 17:42:34','2021-09-04 17:42:34'),(114,'googleads.delete','web','2021-09-04 17:42:34','2021-09-04 17:42:34'),(115,'package-feature.view','web','2021-09-04 17:42:48','2021-09-04 17:42:48'),(116,'package-feature.create','web','2021-09-04 17:42:48','2021-09-04 17:42:48'),(117,'package-feature.edit','web','2021-09-04 17:42:48','2021-09-04 17:42:48'),(118,'package-feature.delete','web','2021-09-04 17:42:48','2021-09-04 17:42:48'),(119,'front-settings.social-icon','web','2021-09-06 10:44:57','2021-09-06 10:44:57'),(120,'site-settings.manualpayment','web','2021-09-06 11:01:27','2021-09-06 11:01:27'),(121,'reports.stripe-report','web','2021-09-06 12:28:20','2021-09-06 12:28:20'),(122,'help.import-demo','web','2021-09-22 11:56:05','2021-09-22 11:56:05'),(123,'site-settings.currency','web','2021-09-22 11:56:49','2021-09-22 11:56:49'),(124,'roles.view','web','2021-09-22 12:05:12','2021-09-22 12:05:12'),(125,'roles.create','web','2021-09-22 12:06:30','2021-09-22 12:06:30'),(126,'roles.edit','web','2021-09-22 12:06:30','2021-09-22 12:06:30'),(127,'roles.delete','web','2021-09-22 12:06:30','2021-09-22 12:06:30'),(128,'dashboard.states','web','2021-10-20 14:10:22','2021-10-20 14:10:22'),(129,'app-settings.setting','web','2021-10-21 12:03:43','2021-10-21 12:03:43'),(130,'app-settings.slider','web','2021-10-21 12:03:54','2021-10-21 12:03:54');

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

CREATE TABLE `player_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_enable` tinyint(1) DEFAULT NULL,
  `cpy_text` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `loop_video` tinyint(1) DEFAULT NULL,
  `is_resume` tinyint(1) DEFAULT '0',
  `player_google_analytics_id` varchar(199) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle_font_size` int DEFAULT NULL,
  `subtitle_color` varchar(191) 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 12: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 COLLATE utf8mb4_unicode_ci,
  `title2` text COLLATE utf8mb4_unicode_ci,
  `title3` text COLLATE utf8mb4_unicode_ci,
  `title4` text COLLATE utf8mb4_unicode_ci,
  `title5` text COLLATE utf8mb4_unicode_ci,
  `title6` text 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) 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 12:54:28','2021-09-01 12:54:28'),(2,'Producer','web','2021-09-04 14:52:18','2021-09-04 14: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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fb` text COLLATE utf8mb4_unicode_ci,
  `google` text COLLATE utf8mb4_unicode_ci,
  `metadata` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `keyword` text 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 11:41:55');

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

CREATE TABLE `sessions` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` text 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 ('0kMl0bXL0eJ44inE2qzVFic8nGPdDpcnen86NTqM',NULL,'89.104.101.214','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoibnVScFUwWktsY3l5Sno3VWJETGZUTGMxU0RteEtnSnpsNWIzUHBvZCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672189635),('1ZwzF5nUSJi9YWtfqZu5OGIdcWokW1fttFEqVbZR',NULL,'15.235.200.217','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoic2tocHRMMDZqTFpTbFZvdkF3WjJVSWFtbVBvckxsakw2V3BwM1FZRSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6Mzc6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC94bWxycGMucGhwP3JzZD0iO319',1672140797),('7kThFCyjvTGvKCT2zq63RlkqWnVJ2yS6vMGeZ99d',NULL,'176.74.192.85','Mozilla/5.0 (iPad; CPU OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5355d Safari/8536.25','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidklYZ2xTdHBQUHUyUEFlWkN3bzl4ekdJRVY4Umd1cDQwMmxiQ1B4dSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozMjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2h1bWFucy50eHQiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2h1bWFucy50eHQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672153173),('7rQGeLOsxsYtJK56YWGpj8FhVpofk1h72oSg3HYx',NULL,'176.74.192.85','Mozilla/5.0 (iPad; CPU OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5355d Safari/8536.25','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMFZ6U1JmSnJiaHBiaEowcnExYk5xZHhxWTdkWDVzaUNMRHZ5YWpmZSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672153173),('8cb6eJDnkNPVcyy1OTuOumyh0Yr8XBeLFwjJuFKz',1,'41.95.59.110','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiZ0Fxdmc3WER0YnNzRmRzREpJMlR1TXk0dEozODdEcFdxMVM5Y0J5SCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjQ6InVzZXIiO2E6Mjp7czo1OiJlbWFpbCI7czoyMToiYWRtaW5AbWVkaWFjaXR5LmNvLmluIjtzOjQ6Im5hbWUiO3M6NToiQWRtaW4iO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0MToiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcz9wYWdlPTIiO319',1672202917),('9X9W35giVaI0ZzpdNYX1BoJ0RfgV2B572Hy7f9dK',NULL,'192.241.137.43','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTnBUU2NqZWR5ZVEyWENJNHN1V2RmajFNdDd3RlBZekZsZWt5S2dEdyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNjoiaHR0cDovL3NoYWZha2hhbmEubmV0L3dhdGNoL21vdmllLzE3Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC93YXRjaC9tb3ZpZS8xNyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672147160),('BOicILGsalY3vYqOxaYMIE8YEjG4Q8jfklAvqwvM',NULL,'176.74.192.85','Mozilla/5.0 (iPad; CPU OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5355d Safari/8536.25','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS0pBWVFDUldDMGw4NHM0aWxiNzNQVUQydmRCaDQwYmdhZW9yRnJmTSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672153173),('CLvRaQy4ldNG2MaQ3cPCwIN9VMEfUFZ1iNbrlQu5',NULL,'161.35.183.194','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTXZjYU0yVEFsMHhjc0RxZkttdTBDZldMbXhzMk5CUDVvMG5UTFdWaiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcy8yMi9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMvMjIvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672145105),('dFp7iXqEj2RBP2u0sgWSPVFXPzgF85JdHMSVDv7V',NULL,'168.119.123.34','Mozilla/5.0 (iPhone; CPU iPhone OS 12_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) FxiOS/22.0 Mobile/16B92 Safari/605.1.15','YTo0OntzOjY6Il90b2tlbiI7czo0MDoicHNVcFZSa2xlZURVdng2YU1qcnpzb2cyc202VGdmNGlxOXhMMTFWNiI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672176382),('FRKga8ZnDuWjzAHGTPtHfqoF3oLxo9iELHarwSb8',1,'41.209.93.67','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiVkdrTlZNY1VOUGpIZ05YV0U0M3hqRXBlN2RsOERXQnJoRjlEdTJXZiI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO3M6NDoidXNlciI7YToyOntzOjU6ImVtYWlsIjtzOjIxOiJhZG1pbkBtZWRpYWNpdHkuY28uaW4iO3M6NDoibmFtZSI7czo1OiJBZG1pbiI7fX0=',1672146187),('Fum1IKZ1y7ZOzgfbdTDexfmKPxv6p6Rj46Fm0iWK',NULL,'162.241.174.216','Mozilla/5.0 (Windows NT 10; Win64; x64; rv:75.0) Gecko/20100101 Firefox/75.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaU1rVndSRHY3eTdxc2VTYk5VT1pYMlluQmcza0Rmang2eFFVSmtpaCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672173757),('GZBNr10xTbVk2mzQypsFUBjWrLjWSUoJVU8xWvKF',NULL,'66.249.65.248','Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.5304.115 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOXhadHVZRWx6UHB5QU91ZmlJcjB2SnFwRTlFOFR6V3RWSlljaVBEOSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9mYXEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672155490),('JdxCQ4mshkMyP8x0NnXCQuNfxhOvV2icSt57cQq1',NULL,'176.74.192.85','Mozilla/5.0 (iPad; CPU OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5355d Safari/8536.25','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMFowNWZITDM1TXFvaWJxcGhobmRMNlNyUE9tY1kyU1JiUFZqTkJpdiI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672153173),('Jex6Dp2OusGoK6nr6CTNQitAFWw6cRoXel1cxTtC',NULL,'66.249.65.244','Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.5304.115 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSklWeUhERWowakcwYkZoT3NpdjYxamNuMTZUMktWN2Y2TlJJQ3hLdyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNToiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkZHRvd2lzaGxpc3QiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNzoiaHR0cDovL3NoYWZha2hhbmEubmV0L2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7fQ==',1672148741),('kaZk6rxLWK7yXZX9bHR4aJlTq0WdtUSAmsN8v8bM',1,'41.209.93.67','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54','YTo3OntzOjY6Il90b2tlbiI7czo0MDoiMmNNd09lQm9GMkNFazE3U1JHWnc1V1lpUXpsdGo3TktrbWZmeXNRMCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNzoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9tb3ZpZXMvY3JlYXRlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJlbiI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjQ6InVzZXIiO2E6Mjp7czo1OiJlbWFpbCI7czoyMToiYWRtaW5AbWVkaWFjaXR5LmNvLmluIjtzOjQ6Im5hbWUiO3M6NToiQWRtaW4iO319',1672147045),('LefjFzleGxPeaD8zvkBErHHTR3ovKrfnOmibAAlQ',NULL,'45.138.16.66','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.2628.16 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVFltb2dNNVVEcXkyT3RHRVdFVWJhY2ZNaEhLR0JnUVUyT2xGY3plbiI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672160424),('lWmNYO6zUnrHZe48fp8MnkIGAXw208qeqcVbMQeN',NULL,'45.55.112.20','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVFhpVUxaRnl4MmV4bk13bkcybjZJbHN6SDd2YlRVYTllSmR2YXdqZyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcy8yMC9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMvMjAvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672142499),('mBuA6uVAgM3BQ4rBCHHkjJiT670g43nb7vHvdBoM',NULL,'176.74.192.85','Mozilla/5.0 (iPad; CPU OS 6_0 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5355d Safari/8536.25','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiczFneVlGNUd0YVp5b2JpVUFHOGZHTU5WNDBuMEhnSnpQNnExQzFhNCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyOToiaHR0cDovL3NoYWZha2hhbmEubmV0L2Fkcy50eHQiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyOToiaHR0cDovL3NoYWZha2hhbmEubmV0L2Fkcy50eHQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672153173),('nAhhozBhg1ZGKywwgwMpGn3n0FG4buxN5o5UML2v',NULL,'185.241.208.93','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNE9rdzgxVlYxdU43Vlp3RzJGNzFWQkhYVmRYWDNQSkRDc0xiaFcyQiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNjoiaHR0cDovL3NoYWZha2hhbmEubmV0Ly5lbnYiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoyNjoiaHR0cDovL3NoYWZha2hhbmEubmV0Ly5lbnYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672198765),('nH4FE9iIQKmEwp2XcCNe7eeUrhXQxHNDnoBgoydy',NULL,'104.248.75.7','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOHppaHFYOFhIS0sxemZ5cnNqeGdXNjlkY0VEN1A2OTlVdGVlQ2p6UCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcy8yMy9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMvMjMvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672145123),('OnYoNTFjEwn5Qt5pYG5loTW3TU6h6pdjzqJljn0Z',NULL,'104.248.75.7','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYzA5UEhVaVozczRac2FnUDhwVXFNeFVZc3ZPMWJOUHhUUE5sN0JVbiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcy8zMy9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMvMzMvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672145189),('PgNxfESZniL1ODYZC6kOHmIM1mS7bFijS0hkqIXB',NULL,'138.197.170.20','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiY2VyYTZlSTZKSkdYek9ZTTBDQVNFVTVtRjN5SUE3d0hRNzdCR29nTSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL21vdmllcy8xNy9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9tb3ZpZXMvMTcvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672143301),('Q2LAK4XNH97Rj4FD3QbA6UMOtvQU9hxFW8g9AVEU',1,'41.209.93.67','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.54','YTo2OntzOjY6Il90b2tlbiI7czo0MDoieEhQZVA4QjhCTVpsSVV1Y3hySlZpcjBmcEV0dVVuYzVldjVLcEduNiI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9tb3ZpZXMvY3JlYXRlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTtzOjQ6InVzZXIiO2E6Mjp7czo1OiJlbWFpbCI7czoyMToiYWRtaW5AbWVkaWFjaXR5LmNvLmluIjtzOjQ6Im5hbWUiO3M6NToiQWRtaW4iO319',1672145425),('R4Kwk1EgQsqNDJw2cTU3ecwfPnIFq5NpLhqnFZU4',NULL,'45.55.112.20','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSktMWjBQeWZ4enVRaHJDVmJMTnNSVTAxZ3J0Y3dWMUNFRW1GVW1TbCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcy8zNS9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMvMzUvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672146174),('riFm7uFXVETqDyeWU1FkgvHYusBV4RRHGBrUS2WG',NULL,'162.243.4.24','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUzFaTWxxbVVRaXZlem9vMHFjTHJGNVF3TUhaZFZhZW9BRk16VkFFdCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcy8zMS9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMvMzEvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672146814),('SXjZTqX2XsbjoeG9mQAPcdbEVFTQlqxEsyF1Cv7B',NULL,'66.249.65.244','Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.5304.115 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiR05jRk5vNnNYQ29qd1h4bnZzVHdpc3lkVVBmWGNXNmE3R2t5S1J2SSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9zaWdudXAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672152790),('T3HHB6e4zK0UJoO3zGd1Jc5BIRRGIrEforUKlkOB',NULL,'95.179.197.202','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.109 Safari/537.36 OPR/84.0.4316.42','YTo0OntzOjY6Il90b2tlbiI7czo0MDoieVRhVG13aGVJMExKeU5wbWpRZjNwVjNnczJJQWlPbFBkNTdxZkxXeSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672188598),('TWZwzZGC7Zwvd5zQfNzDooEPNXAvRu6Snwd441eQ',NULL,'162.243.4.24','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoick5RM0o3WE5vU2JZUExEdG1Kd3g4c2JIQURydzZGVFp1WGVtTXptSSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MjoiaHR0cDovL3NoYWZha2hhbmEubmV0L2FkbWluL2dlbnJlcy8yMS9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9hZG1pbi9nZW5yZXMvMjEvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672143579),('w03vJdhNUx4uoaBZQFhNGIwlftdyL4Jw7OVCckfC',NULL,'192.241.137.43','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVUdGbWR5OVhKVjF5b3ZnUEFNWWtWc0hWdjRzSmVVYmJ3WDFiQXdMcyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MToiaHR0cDovL3NoYWZha2hhbmEubmV0L21vdmllL2RldGFpbC9hdXRpc20iO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0MToiaHR0cDovL3NoYWZha2hhbmEubmV0L21vdmllL2RldGFpbC9hdXRpc20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672142851),('wPQ4gJF6alFKOxiwDQaUpw1nKSwO0RazgwsqadIJ',NULL,'223.247.179.42','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVGc1NjJFQnRpM3JpdHdKTWVvUUtMd0x2TG1TWE1YSHNvSVJleG5OaSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672158475),('WuUEmzjayImaZh36otsoPhSg3qwSIvh72JpbfFXm',NULL,'162.243.4.24','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:33.0) Gecko/20100101 Firefox/33.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZkE5N2tjU2oyUHk4RGgwYUFGS0drUEJQSHFLUG4yRTdqYTRPT21kSSI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTI6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC91c2VyL21vdmllL3RpbWUvdW5kZWZpbmVkLzE3LzEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1672142784),('XMoxHZLlcRe1RONnkkHMW5qZSCCpR84WQfiOJnhd',NULL,'197.252.212.155','Mozilla/5.0 (Linux; Android 13; IN2013) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Mobile Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSGJCc1pVcXpkNWZMYXNOVmdSN2dKSEJucDFsdmZrS0VFdTc3eWQ4ViI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC9ndWVzdC9hbHJ5eXN5Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672145441),('YAnaUyrjd8D6DuInLf5K0SMDyMzj9WbddOvQPyeJ',NULL,'178.128.83.39','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQXd0OGdEeVNqZXQ3RWJQcU9QTXpXVjBTR1JDaHVKQ1J2YUVTYXhtRiI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjE6e3M6ODoiaW50ZW5kZWQiO3M6Mzc6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldC94bWxycGMucGhwP3JzZD0iO319',1672148777),('yf5qCIUzD6RUTr8VmHcKUSoqNHwKUzcgNzebeytO',NULL,'207.46.13.165','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/103.0.5060.134 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVmNPVGpreTFiQjRoRHRManlhUW53eG9JYmFIQU5ydWp5WDFTdmQwNCI7czoxNjoiY2hhbmdlZF9sYW5ndWFnZSI7czoyOiJhciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9zaGFmYWtoYW5hLm5ldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1672183079),('z5WOyFMNRH0GHSmNomj0JFa4oeIu2YCMXow6YjkY',NULL,'162.241.174.216','Mozilla/5.0 (Windows NT 10; Win64; x64; rv:75.0) Gecko/20100101 Firefox/75.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMDFNVVA4SWlPS0Q2TXJ4Zkg0QzYyQXlWWVVhamw2aTI4RmJ2SVlkbiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNDoiaHR0cDovL3NoYWZha2hhbmEubmV0L3dwLWxvZ2luLnBocCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM0OiJodHRwOi8vc2hhZmFraGFuYS5uZXQvd3AtbG9naW4ucGhwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1672173756);

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

CREATE TABLE `social_icons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url3` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo_enable` tinyint(1) NOT NULL DEFAULT '1',
  `logo` varchar(191) 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) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_plan` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stripe_plan` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_t` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `m_t_id` varchar(100) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency1` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency2` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fee` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buyer_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buyer_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom` text COLLATE utf8mb4_unicode_ci,
  `ipn_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `txn_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirms_needed` tinyint unsigned NOT NULL,
  `timeout` int unsigned NOT NULL,
  `status_url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `qrcode_url` varchar(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_confirms` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `received_amount` varchar(191) 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `merchant` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pbntag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_confirm` tinyint(1) NOT NULL DEFAULT '0',
  `ref_id` varchar(128) 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 COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tmdb_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tmdb` char(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fetch_by` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `poster` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `genre_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail` text COLLATE utf8mb4_unicode_ci,
  `rating` double(8,2) DEFAULT NULL,
  `episode_runtime` double(8,2) DEFAULT NULL,
  `maturity_rating` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `type` char(191) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iframeurl` text COLLATE utf8mb4_unicode_ci,
  `ready_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_360` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_480` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_720` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url_1080` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `upload_video` longtext 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `views` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `viewable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `viewable_id` bigint unsigned NOT NULL,
  `visitor` text COLLATE utf8mb4_unicode_ci,
  `collection` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `viewed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `views_viewable_type_viewable_id_index` (`viewable_type`,`viewable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 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=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `watch_histories` VALUES (8,14,NULL,1,'2022-12-23 17:46:51','2022-12-23 17:46:51');

--
-- 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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amounti` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency2` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pbntag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dest_tag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ipn_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auto_confirm` tinyint(1) NOT NULL DEFAULT '0',
  `note` text COLLATE utf8mb4_unicode_ci,
  `ref_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` smallint NOT NULL,
  `status_text` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `txn_id` varchar(128) 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 DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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



