-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 19, 2025 at 04:07 AM -- Server version: 10.6.23-MariaDB -- PHP Version: 8.4.11 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `flixoo` -- -- -------------------------------------------------------- -- -- Table structure for table `ads` -- CREATE TABLE `ads` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `type` varchar(20) NOT NULL, `position` varchar(50) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 1, `start_date` varchar(191) DEFAULT NULL, `end_date` varchar(191) DEFAULT NULL, `redirect_url` varchar(191) DEFAULT NULL, `size` varchar(20) DEFAULT NULL, `banner` text DEFAULT NULL, `content` text DEFAULT NULL, `video_link` text DEFAULT NULL, `total_views` int(11) DEFAULT 0, `views_count` int(11) DEFAULT 0, `ad_duration` int(11) DEFAULT NULL, `skip_after` int(11) DEFAULT NULL, `frequency_capping` int(11) DEFAULT NULL, `start_time` varchar(191) DEFAULT NULL, `end_time` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `ads` -- INSERT INTO `ads` (`id`, `title`, `type`, `position`, `status`, `start_date`, `end_date`, `redirect_url`, `size`, `banner`, `content`, `video_link`, `total_views`, `views_count`, `ad_duration`, `skip_after`, `frequency_capping`, `start_time`, `end_time`, `created_at`, `updated_at`) VALUES (1, 'Movie details sidebar one', 'local', 'movie_details_sidebar_1', 1, '2025-07-01T15:12', '2026-07-01T15:12', '#', '300x250', '{\"storage\":\"local\",\"original_image\":\"images/default.jpg\"}', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Movie details sidebar two', 'local', 'movie_details_sidebar_2', 1, '2025-07-01T15:12', '2026-07-01T15:12', '#', '300x600', '{\"storage\":\"local\",\"original_image\":\"images/default.jpg\"}', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Home page promotional left', 'local', 'home_page_promotional_left', 1, '2025-07-01T15:12', '2026-07-01T15:12', '#', '300x250', '{\"storage\":\"local\",\"original_image\":\"images/default.jpg\"}', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Home page promotional right', 'local', 'home_page_promotional_right', 1, '2025-07-01T15:12', '2026-07-01T15:12', '#', '300x250', '{\"storage\":\"local\",\"original_image\":\"images/default.jpg\"}', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Movie details middle', 'local', 'movie_details_middle', 1, '2025-07-01T15:12', '2026-07-01T15:12', '#', '728x90', '{\"storage\":\"local\",\"original_image\":\"images/default.png\"}', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'Footer', 'local', 'footer', 1, '2025-07-01T15:12', '2026-07-01T15:12', '#', '728x90', '{\"storage\":\"local\",\"original_image\":\"images/default.png\"}', NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `api_keys` -- CREATE TABLE `api_keys` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `key` varchar(255) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `user_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `api_keys` -- INSERT INTO `api_keys` (`id`, `title`, `key`, `status`, `user_id`, `created_at`, `updated_at`) VALUES (1, 'api', 'gq9OHcODH4Vi2zEJ', 1, 1, '2025-09-19 10:04:38', '2025-09-19 10:04:38'); -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `slug` varchar(191) NOT NULL, `description` longtext DEFAULT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `image` longtext DEFAULT NULL, `seo_title` varchar(191) DEFAULT NULL, `meta_description` varchar(191) DEFAULT NULL, `focus_keyword` varchar(191) DEFAULT NULL, `tags` varchar(191) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 0, `is_top` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE `blog_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(191) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(191) NOT NULL, `owner` varchar(191) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `video_type` varchar(191) NOT NULL, `video_type_desc` text DEFAULT NULL, `primary_menu` tinyint(4) NOT NULL DEFAULT 0, `footer_menu` tinyint(4) NOT NULL DEFAULT 0, `thumbnail_style` tinyint(4) NOT NULL DEFAULT 1, `order` tinyint(4) NOT NULL DEFAULT 1, `slug` varchar(100) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `video_type`, `video_type_desc`, `primary_menu`, `footer_menu`, `thumbnail_style`, `order`, `slug`, `created_at`, `updated_at`) VALUES (1, 'Comedy', NULL, 0, 0, 1, 1, 'comedy', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Drama', NULL, 0, 0, 1, 1, 'drama', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Action', NULL, 0, 0, 1, 1, 'action', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Romance', NULL, 0, 0, 1, 1, 'romance', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Thriller', NULL, 0, 0, 1, 1, 'thriller', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'Sports', NULL, 0, 0, 1, 1, 'sports', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'Sci-Fi', NULL, 0, 0, 1, 1, 'sci-Fi', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'Horror', NULL, 0, 0, 1, 1, 'horror', '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `clients` -- CREATE TABLE `clients` ( `id` bigint(20) UNSIGNED NOT NULL, `first_name` varchar(191) NOT NULL, `last_name` varchar(191) NOT NULL, `company_name` varchar(191) NOT NULL, `logo` text DEFAULT NULL, `slug` varchar(191) NOT NULL, `country_id` bigint(20) UNSIGNED DEFAULT NULL, `address` text DEFAULT NULL, `payment_method` varchar(191) DEFAULT NULL, `payment_details` varchar(191) DEFAULT NULL, `stripe_customer_id` varchar(191) DEFAULT NULL, `paddle_customer_id` varchar(191) DEFAULT NULL, `webhook_verify_token` varchar(100) DEFAULT NULL COMMENT 'Generated By System: for webhook request verification', `api_key` varchar(100) DEFAULT NULL COMMENT 'Generated By System: for API request verification', `default_ai` varchar(191) DEFAULT NULL, `openai_api_key` varchar(191) DEFAULT NULL, `deepseek_api_key` varchar(191) DEFAULT NULL, `default_language` varchar(191) DEFAULT NULL, `default_length` int(11) DEFAULT NULL, `default_tone` varchar(191) DEFAULT NULL, `default_level` varchar(191) DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `configs` -- CREATE TABLE `configs` ( `id` bigint(20) UNSIGNED NOT NULL, `lang` varchar(10) DEFAULT 'en', `title` varchar(100) DEFAULT NULL, `value` mediumtext DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `configs` -- INSERT INTO `configs` (`id`, `lang`, `title`, `value`, `created_at`, `updated_at`) VALUES (1, 'en', 'system_name', 'Flixoo', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'en', 'default_time_zone', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'en', 'default_currency', '97', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'en', 'currency_symbol', '97', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'en', 'default_language', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'en', 'currency_symbol_position', 'left', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'en', 'exchange_rate', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'en', 'system_email', 'admin@spagreen.net', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (9, 'en', 'business_address', 'Dhaka, Bangladesh', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (10, 'en', 'business_phone', '+8801400620055', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (11, 'en', 'contact_email', 'contact@spagreen.net', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (12, 'en', 'registration_enable', '0', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (13, 'en', 'google_recaptcha', '0', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (14, 'en', 'recaptcha_site_key', 'Recaptcha site key', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (15, 'en', 'recaptcha_secret_key', 'Recaptcha secret key', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (16, 'en', 'tmdb_default_language', 'english', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (17, 'en', 'tmdb_api_key', 'Api key', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (18, 'en', 'android_tv_btn_link', 'https://example.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (19, 'en', 'show_android_tv_btn_banner', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (20, 'en', 'android_device_btn_link', 'https://example.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (21, 'en', 'show_android_device_btn_banner', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (22, 'en', 'apple_device_btn_link', 'https://example.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (23, 'en', 'show_apple_device_btn_banner', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (24, 'en', 'show_social_links', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (25, 'en', 'facebook_link', 'https://facebook.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (26, 'en', 'twitter_link', 'https://twitter.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (27, 'en', 'instagram_link', 'https://instagram.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (28, 'en', 'pinterest_link', 'https://pinterest.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (29, 'en', 'linkedin_link', 'https://linkedin.com', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (30, 'en', 'show_copyright', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (31, 'en', 'copyright_title', 'Copyright ©SpaGreen 2025', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (32, 'en', 'show_payment_method_banner', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (33, 'en', 'payment_method_banner', '{\"storage\":\"local\",\"original_image\":\"https://placehold.co/310x30\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (34, 'en', 'high_lighted_text', 'Your movie site could offer comprehensive film information, reviews, and ratings.', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (35, 'en', 'show_help_center_links', '1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (36, 'en', 'faqs_link', 'https://check.belovevn.com/public/faqs', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (37, 'en', 'contact_link', 'https://check.belovevn.com/public/contact-us', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (38, 'en', 'promotion', '{\"storage\":\"local\",\"original_image\":\"images/bg.jpg\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (39, 'en', 'version_code', '1.0.1', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (40, 'en', 'current_version', '101', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (41, 'en', 'paginate', '\"10\"', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (42, 'en', 'openai_secret_key', 'Your api key here', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (43, 'en', 'light_logo', '{\"storage\":\"local\",\"original_image\":\"images/default/logo/logo.png\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (44, 'en', 'favicon', '{\"storage\":\"local\",\"original_image\":\"images/default/logo/logo-mini.png\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (45, 'en', 'activation_code', 'spagreen68ccd36c39628', '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `countries` -- CREATE TABLE `countries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `slug` varchar(100) NOT NULL, `description` text DEFAULT NULL, `flag` text DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `countries` -- INSERT INTO `countries` (`id`, `name`, `slug`, `description`, `flag`, `status`, `created_at`, `updated_at`) VALUES (1, 'Afghanistan', 'afghanistan', NULL, 'af', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Albania', 'albania', NULL, 'al', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Algeria', 'algeria', NULL, 'dz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Andorra', 'andorra', NULL, 'ad', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Angola', 'angola', NULL, 'ao', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'Antigua and Barbuda', 'antigua-and-barbuda', NULL, 'ag', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'Argentina', 'argentina', NULL, 'ar', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'Armenia', 'armenia', NULL, 'am', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (9, 'Australia', 'australia', NULL, 'au', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (10, 'Austria', 'austria', NULL, 'at', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (11, 'Azerbaijan', 'azerbaijan', NULL, 'az', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (12, 'Bahamas', 'bahamas', NULL, 'bs', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (13, 'Bahrain', 'bahrain', NULL, 'bh', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (14, 'Bangladesh', 'bangladesh', NULL, 'bd', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (15, 'Barbados', 'barbados', NULL, 'bb', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (16, 'Belarus', 'belarus', NULL, 'by', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (17, 'Belgium', 'belgium', NULL, 'be', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (18, 'Belize', 'belize', NULL, 'bz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (19, 'Benin', 'benin', NULL, 'bj', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (20, 'Bhutan', 'bhutan', NULL, 'bt', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (21, 'Bolivia', 'bolivia', NULL, 'bo', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (22, 'Bosnia and Herzegovina', 'bosnia-and-herzegovina', NULL, 'ba', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (23, 'Botswana', 'botswana', NULL, 'bw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (24, 'Brazil', 'brazil', NULL, 'br', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (25, 'Brunei', 'brunei', NULL, 'bn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (26, 'Bulgaria', 'bulgaria', NULL, 'bg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (27, 'Burkina Faso', 'burkina-faso', NULL, 'bf', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (28, 'Burundi', 'burundi', NULL, 'bi', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (29, 'Cabo Verde', 'cabo-verde', NULL, 'cv', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (30, 'Cambodia', 'cambodia', NULL, 'kh', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (31, 'Cameroon', 'cameroon', NULL, 'cm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (32, 'Canada', 'canada', NULL, 'ca', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (33, 'Central African Republic', 'central-african-republic', NULL, 'cf', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (34, 'Chad', 'chad', NULL, 'td', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (35, 'Chile', 'chile', NULL, 'cl', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (36, 'China', 'china', NULL, 'cn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (37, 'Colombia', 'colombia', NULL, 'co', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (38, 'Comoros', 'comoros', NULL, 'km', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (39, 'Congo', 'congo', NULL, 'cg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (40, 'Costa Rica', 'costa-rica', NULL, 'cr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (41, 'Croatia', 'croatia', NULL, 'hr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (42, 'Cuba', 'cuba', NULL, 'cu', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (43, 'Cyprus', 'cyprus', NULL, 'cy', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (44, 'Czech Republic', 'czech-republic', NULL, 'cz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (45, 'Denmark', 'denmark', NULL, 'dk', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (46, 'Djibouti', 'djibouti', NULL, 'dj', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (47, 'Dominica', 'dominica', NULL, 'dm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (48, 'Dominican Republic', 'dominican-republic', NULL, 'do', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (49, 'Ecuador', 'ecuador', NULL, 'ec', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (50, 'Egypt', 'egypt', NULL, 'eg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (51, 'El Salvador', 'el-salvador', NULL, 'sv', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (52, 'Equatorial Guinea', 'equatorial-guinea', NULL, 'gq', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (53, 'Eritrea', 'eritrea', NULL, 'er', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (54, 'Estonia', 'estonia', NULL, 'ee', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (55, 'Eswatini', 'eswatini', NULL, 'sz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (56, 'Ethiopia', 'ethiopia', NULL, 'et', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (57, 'Fiji', 'fiji', NULL, 'fj', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (58, 'Finland', 'finland', NULL, 'fi', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (59, 'France', 'france', NULL, 'fr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (60, 'Gabon', 'gabon', NULL, 'ga', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (61, 'Gambia', 'gambia', NULL, 'gm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (62, 'Georgia', 'georgia', NULL, 'ge', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (63, 'Germany', 'germany', NULL, 'de', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (64, 'Ghana', 'ghana', NULL, 'gh', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (65, 'Greece', 'greece', NULL, 'gr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (66, 'Grenada', 'grenada', NULL, 'gd', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (67, 'Guatemala', 'guatemala', NULL, 'gt', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (68, 'Guinea', 'guinea', NULL, 'gn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (69, 'Guinea-Bissau', 'guinea-bissau', NULL, 'gw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (70, 'Guyana', 'guyana', NULL, 'gy', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (71, 'Haiti', 'haiti', NULL, 'ht', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (72, 'Honduras', 'honduras', NULL, 'hn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (73, 'Hungary', 'hungary', NULL, 'hu', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (74, 'Iceland', 'iceland', NULL, 'is', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (75, 'India', 'india', NULL, 'in', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (76, 'Indonesia', 'indonesia', NULL, 'id', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (77, 'Iran', 'iran', NULL, 'ir', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (78, 'Iraq', 'iraq', NULL, 'iq', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (79, 'Ireland', 'ireland', NULL, 'ie', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (80, 'Israel', 'israel', NULL, 'il', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (81, 'Italy', 'italy', NULL, 'it', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (82, 'Jamaica', 'jamaica', NULL, 'jm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (83, 'Japan', 'japan', NULL, 'jp', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (84, 'Jordan', 'jordan', NULL, 'jo', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (85, 'Kazakhstan', 'kazakhstan', NULL, 'kz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (86, 'Kenya', 'kenya', NULL, 'ke', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (87, 'Kiribati', 'kiribati', NULL, 'ki', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (88, 'Korea, North', 'korea-north', NULL, 'kp', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (89, 'Korea, South', 'korea-south', NULL, 'kr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (90, 'Kosovo', 'kosovo', NULL, 'xk', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (91, 'Kuwait', 'kuwait', NULL, 'kw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (92, 'Kyrgyzstan', 'kyrgyzstan', NULL, 'kg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (93, 'Laos', 'laos', NULL, 'la', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (94, 'Latvia', 'latvia', NULL, 'lv', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (95, 'Lebanon', 'lebanon', NULL, 'lb', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (96, 'Lesotho', 'lesotho', NULL, 'ls', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (97, 'Liberia', 'liberia', NULL, 'lr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (98, 'Libya', 'libya', NULL, 'ly', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (99, 'Liechtenstein', 'liechtenstein', NULL, 'li', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (100, 'Lithuania', 'lithuania', NULL, 'lt', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (101, 'Luxembourg', 'luxembourg', NULL, 'lu', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (102, 'Madagascar', 'madagascar', NULL, 'mg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (103, 'Malawi', 'malawi', NULL, 'mw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (104, 'Malaysia', 'malaysia', NULL, 'my', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (105, 'Maldives', 'maldives', NULL, 'mv', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (106, 'Mali', 'mali', NULL, 'ml', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (107, 'Malta', 'malta', NULL, 'mt', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (108, 'Marshall Islands', 'marshall-islands', NULL, 'mh', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (109, 'Mauritania', 'mauritania', NULL, 'mr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (110, 'Mauritius', 'mauritius', NULL, 'mu', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (111, 'Mexico', 'mexico', NULL, 'mx', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (112, 'Micronesia', 'micronesia', NULL, 'fm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (113, 'Moldova', 'moldova', NULL, 'md', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (114, 'Monaco', 'monaco', NULL, 'mc', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (115, 'Mongolia', 'mongolia', NULL, 'mn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (116, 'Montenegro', 'montenegro', NULL, 'me', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (117, 'Morocco', 'morocco', NULL, 'ma', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (118, 'Mozambique', 'mozambique', NULL, 'mz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (119, 'Myanmar', 'myanmar', NULL, 'mm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (120, 'Namibia', 'namibia', NULL, 'na', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (121, 'Nauru', 'nauru', NULL, 'nr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (122, 'Nepal', 'nepal', NULL, 'np', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (123, 'Netherlands', 'netherlands', NULL, 'nl', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (124, 'New Zealand', 'new-zealand', NULL, 'nz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (125, 'Nicaragua', 'nicaragua', NULL, 'ni', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (126, 'Niger', 'niger', NULL, 'ne', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (127, 'Nigeria', 'nigeria', NULL, 'ng', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (128, 'North Macedonia', 'north-macedonia', NULL, 'mk', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (129, 'Norway', 'norway', NULL, 'no', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (130, 'Oman', 'oman', NULL, 'om', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (131, 'Pakistan', 'pakistan', NULL, 'pk', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (132, 'Palau', 'palau', NULL, 'pw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (133, 'Panama', 'panama', NULL, 'pa', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (134, 'Papua New Guinea', 'papua-new-guinea', NULL, 'pg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (135, 'Paraguay', 'paraguay', NULL, 'py', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (136, 'Peru', 'peru', NULL, 'pe', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (137, 'Philippines', 'philippines', NULL, 'ph', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (138, 'Poland', 'poland', NULL, 'pl', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (139, 'Portugal', 'portugal', NULL, 'pt', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (140, 'Qatar', 'qatar', NULL, 'qa', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (141, 'Romania', 'romania', NULL, 'ro', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (142, 'Russia', 'russia', NULL, 'ru', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (143, 'Rwanda', 'rwanda', NULL, 'rw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (144, 'Saint Kitts and Nevis', 'saint-kitts-and-nevis', NULL, 'kn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (145, 'Saint Lucia', 'saint-lucia', NULL, 'lc', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (146, 'Saint Vincent and the Grenadines', 'saint-vincent-and-the-grenadines', NULL, 'vc', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (147, 'Samoa', 'samoa', NULL, 'ws', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (148, 'San Marino', 'san-marino', NULL, 'sm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (149, 'Sao Tome and Principe', 'sao-tome-and-principe', NULL, 'st', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (150, 'Saudi Arabia', 'saudi-arabia', NULL, 'sa', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (151, 'Senegal', 'senegal', NULL, 'sn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (152, 'Serbia', 'serbia', NULL, 'rs', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (153, 'Seychelles', 'seychelles', NULL, 'sc', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (154, 'Sierra Leone', 'sierra-leone', NULL, 'sl', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (155, 'Singapore', 'singapore', NULL, 'sg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (156, 'Slovakia', 'slovakia', NULL, 'sk', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (157, 'Slovenia', 'slovenia', NULL, 'si', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (158, 'Solomon Islands', 'solomon-islands', NULL, 'sb', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (159, 'Somalia', 'somalia', NULL, 'so', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (160, 'South Africa', 'south-africa', NULL, 'za', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (161, 'South Sudan', 'south-sudan', NULL, 'ss', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (162, 'Spain', 'spain', NULL, 'es', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (163, 'Sri Lanka', 'sri-lanka', NULL, 'lk', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (164, 'Sudan', 'sudan', NULL, 'sd', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (165, 'Suriname', 'suriname', NULL, 'sr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (166, 'Sweden', 'sweden', NULL, 'se', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (167, 'Switzerland', 'switzerland', NULL, 'ch', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (168, 'Syria', 'syria', NULL, 'sy', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (169, 'Taiwan', 'taiwan', NULL, 'tw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (170, 'Tajikistan', 'tajikistan', NULL, 'tj', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (171, 'Tanzania', 'tanzania', NULL, 'tz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (172, 'Thailand', 'thailand', NULL, 'th', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (173, 'Togo', 'togo', NULL, 'tg', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (174, 'Tonga', 'tonga', NULL, 'to', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (175, 'Trinidad and Tobago', 'trinidad-and-tobago', NULL, 'tt', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (176, 'Tunisia', 'tunisia', NULL, 'tn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (177, 'Turkey', 'turkey', NULL, 'tr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (178, 'Turkmenistan', 'turkmenistan', NULL, 'tm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (179, 'Tuvalu', 'tuvalu', NULL, 'tv', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (180, 'Uganda', 'uganda', NULL, 'ug', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (181, 'Ukraine', 'ukraine', NULL, 'ua', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (182, 'United Arab Emirates', 'united-arab-emirates', NULL, 'ae', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (183, 'United Kingdom', 'united-kingdom', NULL, 'gb', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (184, 'United States', 'united-states', NULL, 'us', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (185, 'Uruguay', 'uruguay', NULL, 'uy', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (186, 'Uzbekistan', 'uzbekistan', NULL, 'uz', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (187, 'Vanuatu', 'vanuatu', NULL, 'vu', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (188, 'Vatican City', 'vatican-city', NULL, 'va', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (189, 'Venezuela', 'venezuela', NULL, 've', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (190, 'Vietnam', 'vietnam', NULL, 'vn', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (191, 'Yemen', 'yemen', NULL, 'ye', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (192, 'Zambia', 'zambia', NULL, 'zm', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (193, 'Zimbabwe', 'zimbabwe', NULL, 'zw', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `id` bigint(20) UNSIGNED NOT NULL, `country` varchar(100) DEFAULT NULL, `currency` varchar(100) DEFAULT NULL, `iso_code` varchar(100) DEFAULT NULL, `symbol` varchar(100) DEFAULT NULL, `exchange_rate` double NOT NULL DEFAULT 1, `default` int(11) NOT NULL DEFAULT 0, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `currencies` -- INSERT INTO `currencies` (`id`, `country`, `currency`, `iso_code`, `symbol`, `exchange_rate`, `default`, `status`, `created_at`, `updated_at`) VALUES (1, 'Afghani', 'AFN', NULL, '؋', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Lek', 'ALL', NULL, 'Lek', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Netherlands Antillian Guilder', 'ANG', NULL, 'ƒ', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Argentine Peso', 'ARS', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Australian Dollar', 'AUD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'Aruban Guilder', 'AWG', NULL, 'ƒ', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'Azerbaijanian Manat', 'AZN', NULL, 'ман', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'Convertible Marks', 'BAM', NULL, 'KM', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (9, 'Bangladeshi Taka', 'BDT', NULL, '৳', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (10, 'Barbados Dollar', 'BBD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (11, 'Bulgarian Lev', 'BGN', NULL, 'лв', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (12, 'Bermudian Dollar', 'BMD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (13, 'Brunei Dollar', 'BND', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (14, 'BOV Boliviano Mvdol', 'BOB', NULL, '$b', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (15, 'Brazilian Real', 'BRL', NULL, 'R$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (16, 'Bahamian Dollar', 'BSD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (17, 'Pula', 'BWP', NULL, 'P', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (18, 'Belarussian Ruble', 'BYR', NULL, '₽', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (19, 'Belize Dollar', 'BZD', NULL, 'BZ$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (20, 'Canadian Dollar', 'CAD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (21, 'Swiss Franc', 'CHF', NULL, 'CHF', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (22, 'CLF Chilean Peso Unidades de fomento', 'CLP', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (23, 'Yuan Renminbi', 'CNY', NULL, '¥', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (24, 'COU Colombian Peso Unidad de Valor Real', 'COP', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (25, 'Costa Rican Colon', 'CRC', NULL, '₡', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (26, 'CUC Cuban Peso Peso Convertible', 'CUP', NULL, '₱', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (27, 'Czech Koruna', 'CZK', NULL, 'Kč', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (28, 'Danish Krone', 'DKK', NULL, 'kr', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (29, 'Dominican Peso', 'DOP', NULL, 'RD$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (30, 'Egyptian Pound', 'EGP', NULL, '£', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (31, 'Euro', 'EUR', NULL, '€', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (32, 'Fiji Dollar', 'FJD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (33, 'Falkland Islands Pound', 'FKP', NULL, '£', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (34, 'Pound Sterling', 'GBP', NULL, '£', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (35, 'Gibraltar Pound', 'GIP', NULL, '£', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (36, 'Quetzal', 'GTQ', NULL, 'Q', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (37, 'Guyana Dollar', 'GYD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (38, 'Hong Kong Dollar', 'HKD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (39, 'Lempira', 'HNL', NULL, 'L', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (40, 'Croatian Kuna', 'HRK', NULL, 'kn', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (41, 'Forint', 'HUF', NULL, 'Ft', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (42, 'Rupiah', 'IDR', NULL, 'Rp', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (43, 'New Israeli Sheqel', 'ILS', NULL, '₪', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (44, 'Iranian Rial', 'IRR', NULL, '﷼', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (45, 'Iceland Krona', 'ISK', NULL, 'kr', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (46, 'Jamaican Dollar', 'JMD', NULL, 'J$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (47, 'Yen', 'JPY', NULL, '¥', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (48, 'Som', 'KGS', NULL, 'лв', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (49, 'Riel', 'KHR', NULL, '៛', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (50, 'North Korean Won', 'KPW', NULL, '₩', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (51, 'Won', 'KRW', NULL, '₩', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (52, 'Cayman Islands Dollar', 'KYD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (53, 'Tenge', 'KZT', NULL, 'лв', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (54, 'Kip', 'LAK', NULL, '₭', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (55, 'Lebanese Pound', 'LBP', NULL, '£', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (56, 'Sri Lanka Rupee', 'LKR', NULL, '₨', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (57, 'Liberian Dollar', 'LRD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (58, 'Lithuanian Litas', 'LTL', NULL, 'Lt', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (59, 'Latvian Lats', 'LVL', NULL, 'Ls', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (60, 'Denar', 'MKD', NULL, 'ден', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (61, 'Tugrik', 'MNT', NULL, '₮', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (62, 'Mauritius Rupee', 'MUR', NULL, '₨', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (63, 'MXV Mexican Peso Mexican Unidad de Inversion (UDI]', 'MXN', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (64, 'Malaysian Ringgit', 'MYR', NULL, 'RM', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (65, 'Metical', 'MZN', NULL, 'MT', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (66, 'Naira', 'NGN', NULL, '₦', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (67, 'Cordoba Oro', 'NIO', NULL, 'C$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (68, 'Norwegian Krone', 'NOK', NULL, 'kr', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (69, 'Nepalese Rupee', 'NPR', NULL, '₨', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (70, 'New Zealand Dollar', 'NZD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (71, 'Rial Omani', 'OMR', NULL, '﷼', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (72, 'USD Balboa US Dollar', 'PAB', NULL, 'B/.', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (73, 'Nuevo Sol', 'PEN', NULL, 'S/.', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (74, 'Philippine Peso', 'PHP', NULL, 'Php', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (75, 'Pakistan Rupee', 'PKR', NULL, '₨', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (76, 'Zloty', 'PLN', NULL, 'zł', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (77, 'Guarani', 'PYG', NULL, 'Gs', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (78, 'Qatari Rial', 'QAR', NULL, '﷼', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (79, 'New Leu', 'RON', NULL, 'lei', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (80, 'Serbian Dinar', 'RSD', NULL, 'Дин.', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (81, 'Russian Ruble', 'RUB', NULL, 'руб', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (82, 'Saudi Riyal', 'SAR', NULL, '﷼', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (83, 'Solomon Islands Dollar', 'SBD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (84, 'Seychelles Rupee', 'SCR', NULL, '₨', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (85, 'Swedish Krona', 'SEK', NULL, 'kr', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (86, 'Singapore Dollar', 'SGD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (87, 'Saint Helena Pound', 'SHP', NULL, '£', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (88, 'Somali Shilling', 'SOS', NULL, 'S', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (89, 'Surinam Dollar', 'SRD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (90, 'USD El Salvador Colon US Dollar', 'SVC', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (91, 'Syrian Pound', 'SYP', NULL, '£', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (92, 'Baht', 'THB', NULL, '฿', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (93, 'Turkish Lira', 'TRY', NULL, 'TL', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (94, 'Trinidad and Tobago Dollar', 'TTD', NULL, 'TT$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (95, 'New Taiwan Dollar', 'TWD', NULL, 'NT$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (96, 'Hryvnia', 'UAH', NULL, '₴', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (97, 'US Dollar', 'USD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (98, 'UYI Uruguay Peso en Unidades Indexadas', 'UYU', NULL, '$U', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (99, 'Uzbekistan Sum', 'UZS', NULL, 'лв', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (100, 'Bolivar Fuerte', 'VEF', NULL, 'Bs', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (101, 'Dong', 'VND', NULL, '₫', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (102, 'East Caribbean Dollar', 'XCD', NULL, '$', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (103, 'Yemeni Rial', 'YER', NULL, '﷼', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (104, 'Rand', 'ZAR', NULL, 'R', 1, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `customer_queries` -- CREATE TABLE `customer_queries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `email` varchar(191) NOT NULL, `subject` varchar(191) NOT NULL, `message` text NOT NULL, `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 = pending, 1 = replied', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `customer_query_replies` -- CREATE TABLE `customer_query_replies` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_query_id` bigint(20) UNSIGNED NOT NULL, `admin_id` bigint(20) UNSIGNED DEFAULT NULL, `reply` text NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `download_links` -- CREATE TABLE `download_links` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `link` text NOT NULL, `resolution` varchar(50) NOT NULL DEFAULT '720p', `file_size` varchar(50) NOT NULL DEFAULT '00MB', `status` int(11) NOT NULL DEFAULT 1, `downloadable_type` varchar(191) NOT NULL, `downloadable_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_templates` -- CREATE TABLE `email_templates` ( `id` bigint(20) UNSIGNED NOT NULL, `subject` varchar(191) NOT NULL, `identifier` varchar(191) NOT NULL, `title` varchar(191) DEFAULT NULL, `body` longtext DEFAULT NULL, `short_codes` varchar(191) DEFAULT NULL, `email_type` varchar(191) NOT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` (`id`, `subject`, `identifier`, `title`, `body`, `short_codes`, `email_type`, `status`, `created_at`, `updated_at`) VALUES (1, 'SMTP Configuration Test', 'test_email', 'SMTP Test Mail', 'Great News!!Email is working Perfectly.', '{name},{email},{site_name},{login_link}', 'system', 1, '2025-09-19 09:57:54', '2025-09-19 09:57:54'), (2, 'Confirm your email', 'confirmation_email', 'Email Confirmation', '

Hi {name},

Please confirm your email by clicking the link below:

{confirmation_link}


Thanks

{site_name}

', '{name},{email},{site_name},{confirmation_link}', 'user', 1, '2025-09-19 09:57:54', '2025-09-19 09:57:54'), (3, 'Welcome to', 'welcome_email', 'Welcome Email', 'Welcome to {site_name}', '{name},{email},{site_name},{login_link}', 'user', 1, '2025-09-19 09:57:54', '2025-09-19 09:57:54'), (4, 'Reset your password', 'password_reset_email', 'password_reset', 'Hi {name},
Reset your password using below link:{reset_link}', '{name},{email},{site_name},{reset_link}', 'user', 1, '2025-09-19 09:57:54', '2025-09-19 09:57:54'), (5, 'Your password has been changed', 'recovery_email', 'recovery_mail', 'Hi {name},\n

Your password has been successfully changed.

\n

If you did not request this change, please contact us immediately.

\n

Best regards,

\n {site_name}', '{name},{email},{site_name},{login_link}', 'user', 1, '2025-09-19 09:57:54', '2025-09-19 09:57:54'); -- -------------------------------------------------------- -- -- Table structure for table `episodes` -- CREATE TABLE `episodes` ( `id` bigint(20) UNSIGNED NOT NULL, `season_id` int(11) DEFAULT NULL, `series_id` int(11) DEFAULT NULL, `episode_name` varchar(191) DEFAULT NULL, `slug` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `file_source` varchar(191) DEFAULT NULL, `source_type` varchar(191) DEFAULT NULL, `file_url` varchar(191) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `runtime` int(11) NOT NULL DEFAULT 0, `poster` longtext DEFAULT NULL, `total_view` int(11) DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(191) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `faqs` -- CREATE TABLE `faqs` ( `id` bigint(20) UNSIGNED NOT NULL, `question` varchar(191) NOT NULL, `answer` text DEFAULT NULL, `type` varchar(191) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `favorite_live_tvs` -- CREATE TABLE `favorite_live_tvs` ( `user_id` bigint(20) UNSIGNED NOT NULL, `live_tv_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `favorite_movies` -- CREATE TABLE `favorite_movies` ( `user_id` bigint(20) UNSIGNED NOT NULL, `movie_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `favorite_tv_shows` -- CREATE TABLE `favorite_tv_shows` ( `user_id` bigint(20) UNSIGNED NOT NULL, `tv_show_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `flag_icons` -- CREATE TABLE `flag_icons` ( `id` bigint(20) UNSIGNED NOT NULL, `image` varchar(50) NOT NULL, `title` varchar(10) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `flag_icons` -- INSERT INTO `flag_icons` (`id`, `image`, `title`, `created_at`, `updated_at`) VALUES (1, 'images/flags/ad.png', 'AD', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'images/flags/ae.png', 'AE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'images/flags/af.png', 'AF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'images/flags/ag.png', 'AG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'images/flags/ai.png', 'AI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'images/flags/al.png', 'AL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'images/flags/am.png', 'AM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'images/flags/ao.png', 'AO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (9, 'images/flags/ar.png', 'AR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (10, 'images/flags/as.png', 'AS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (11, 'images/flags/at.png', 'AT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (12, 'images/flags/au.png', 'AU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (13, 'images/flags/aw.png', 'AW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (14, 'images/flags/ax.png', 'AX', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (15, 'images/flags/az.png', 'AZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (16, 'images/flags/ba.png', 'BA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (17, 'images/flags/bb.png', 'BB', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (18, 'images/flags/bd.png', 'BD', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (19, 'images/flags/be.png', 'BE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (20, 'images/flags/bf.png', 'BF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (21, 'images/flags/bg.png', 'BG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (22, 'images/flags/bh.png', 'BH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (23, 'images/flags/bi.png', 'BI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (24, 'images/flags/bj.png', 'BJ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (25, 'images/flags/bm.png', 'BM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (26, 'images/flags/bn.png', 'BN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (27, 'images/flags/bo.png', 'BO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (28, 'images/flags/br.png', 'BR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (29, 'images/flags/bs.png', 'BS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (30, 'images/flags/bt.png', 'BT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (31, 'images/flags/bv.png', 'BV', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (32, 'images/flags/bw.png', 'BW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (33, 'images/flags/by.png', 'BY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (34, 'images/flags/bz.png', 'BZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (35, 'images/flags/ca.png', 'CA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (36, 'images/flags/cc.png', 'CC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (37, 'images/flags/cd.png', 'CD', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (38, 'images/flags/cf.png', 'CF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (39, 'images/flags/cg.png', 'CG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (40, 'images/flags/ch.png', 'CH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (41, 'images/flags/ci.png', 'CI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (42, 'images/flags/ck.png', 'CK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (43, 'images/flags/cl.png', 'CL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (44, 'images/flags/cm.png', 'CM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (45, 'images/flags/cn.png', 'CN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (46, 'images/flags/co.png', 'CO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (47, 'images/flags/cr.png', 'CR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (48, 'images/flags/cv.png', 'CV', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (49, 'images/flags/cv.png', 'CV', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (50, 'images/flags/cx.png', 'CX', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (51, 'images/flags/cy.png', 'CY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (52, 'images/flags/cz.png', 'CZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (53, 'images/flags/de.png', 'DE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (54, 'images/flags/dj.png', 'DJ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (55, 'images/flags/dk.png', 'DK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (56, 'images/flags/dm.png', 'DM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (57, 'images/flags/do.png', 'DO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (58, 'images/flags/dz.png', 'DZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (59, 'images/flags/ec.png', 'EC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (60, 'images/flags/ee.png', 'EE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (61, 'images/flags/eg.png', 'EG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (62, 'images/flags/eh.png', 'EH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (63, 'images/flags/er.png', 'ER', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (64, 'images/flags/es.png', 'ES', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (65, 'images/flags/et.png', 'ET', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (66, 'images/flags/fi.png', 'FI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (67, 'images/flags/fj.png', 'FJ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (68, 'images/flags/fk.png', 'FK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (69, 'images/flags/fm.png', 'FM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (70, 'images/flags/fo.png', 'FO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (71, 'images/flags/fr.png', 'FR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (72, 'images/flags/ga.png', 'GA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (73, 'images/flags/gb.png', 'GB', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (74, 'images/flags/gd.png', 'GD', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (75, 'images/flags/ge.png', 'GE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (76, 'images/flags/gf.png', 'GF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (77, 'images/flags/gh.png', 'GH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (78, 'images/flags/gi.png', 'GI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (79, 'images/flags/gl.png', 'GL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (80, 'images/flags/gm.png', 'GM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (81, 'images/flags/gn.png', 'GN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (82, 'images/flags/gn.png', 'GN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (83, 'images/flags/gp.png', 'GP', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (84, 'images/flags/gq.png', 'GQ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (85, 'images/flags/gr.png', 'GR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (86, 'images/flags/gs.png', 'GS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (87, 'images/flags/gt.png', 'GT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (88, 'images/flags/gu.png', 'GU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (89, 'images/flags/gw.png', 'GW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (90, 'images/flags/gy.png', 'GY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (91, 'images/flags/hk.png', 'HK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (92, 'images/flags/hm.png', 'HM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (93, 'images/flags/hn.png', 'HN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (94, 'images/flags/hr.png', 'HR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (95, 'images/flags/ht.png', 'HT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (96, 'images/flags/hu.png', 'HU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (97, 'images/flags/id.png', 'ID', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (98, 'images/flags/ie.png', 'IE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (99, 'images/flags/il.png', 'IL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (100, 'images/flags/in.png', 'IN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (101, 'images/flags/io.png', 'IO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (102, 'images/flags/iq.png', 'IQ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (103, 'images/flags/ir.png', 'IR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (104, 'images/flags/is.png', 'IS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (105, 'images/flags/it.png', 'IT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (106, 'images/flags/jm.png', 'JM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (107, 'images/flags/jo.png', 'JO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (108, 'images/flags/jp.png', 'JP', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (109, 'images/flags/ke.png', 'KE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (110, 'images/flags/kg.png', 'KG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (111, 'images/flags/kh.png', 'KH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (112, 'images/flags/ki.png', 'KI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (113, 'images/flags/km.png', 'KM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (114, 'images/flags/kn.png', 'KN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (115, 'images/flags/kp.png', 'KP', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (116, 'images/flags/kr.png', 'KR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (117, 'images/flags/kw.png', 'KW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (118, 'images/flags/ky.png', 'KY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (119, 'images/flags/kz.png', 'KZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (120, 'images/flags/la.png', 'LA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (121, 'images/flags/lb.png', 'LB', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (122, 'images/flags/lc.png', 'LC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (123, 'images/flags/li.png', 'LI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (124, 'images/flags/lk.png', 'LK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (125, 'images/flags/lr.png', 'LR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (126, 'images/flags/ls.png', 'LS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (127, 'images/flags/lt.png', 'LT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (128, 'images/flags/lu.png', 'LU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (129, 'images/flags/lv.png', 'LV', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (130, 'images/flags/ly.png', 'LY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (131, 'images/flags/ma.png', 'MA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (132, 'images/flags/mc.png', 'MC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (133, 'images/flags/md.png', 'MD', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (134, 'images/flags/me.png', 'ME', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (135, 'images/flags/mg.png', 'MG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (136, 'images/flags/mh.png', 'MH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (137, 'images/flags/mk.png', 'MK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (138, 'images/flags/ml.png', 'ML', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (139, 'images/flags/mm.png', 'MM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (140, 'images/flags/mn.png', 'MN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (141, 'images/flags/mo.png', 'MO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (142, 'images/flags/mp.png', 'MP', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (143, 'images/flags/mq.png', 'MQ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (144, 'images/flags/mr.png', 'MR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (145, 'images/flags/ms.png', 'MS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (146, 'images/flags/mt.png', 'MT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (147, 'images/flags/mu.png', 'MU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (148, 'images/flags/mv.png', 'MV', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (149, 'images/flags/mw.png', 'MW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (150, 'images/flags/mx.png', 'MX', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (151, 'images/flags/my.png', 'MY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (152, 'images/flags/mz.png', 'MZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (153, 'images/flags/na.png', 'NA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (154, 'images/flags/nc.png', 'NC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (155, 'images/flags/ne.png', 'NE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (156, 'images/flags/nf.png', 'NF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (157, 'images/flags/ng.png', 'NG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (158, 'images/flags/ni.png', 'NI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (159, 'images/flags/nl.png', 'NL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (160, 'images/flags/no.png', 'NO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (161, 'images/flags/np.png', 'NP', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (162, 'images/flags/nr.png', 'NR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (163, 'images/flags/nu.png', 'NU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (164, 'images/flags/nz.png', 'NZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (165, 'images/flags/om.png', 'OM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (166, 'images/flags/pa.png', 'PA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (167, 'images/flags/pe.png', 'PE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (168, 'images/flags/pf.png', 'PF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (169, 'images/flags/pg.png', 'PG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (170, 'images/flags/ph.png', 'PH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (171, 'images/flags/pk.png', 'PK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (172, 'images/flags/pl.png', 'PL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (173, 'images/flags/pm.png', 'PM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (174, 'images/flags/pn.png', 'PN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (175, 'images/flags/pr.png', 'PR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (176, 'images/flags/ps.png', 'PS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (177, 'images/flags/pt.png', 'PT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (178, 'images/flags/pw.png', 'PW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (179, 'images/flags/py.png', 'PY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (180, 'images/flags/qa.png', 'QA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (181, 'images/flags/re.png', 'RE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (182, 'images/flags/ro.png', 'RO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (183, 'images/flags/rs.png', 'RS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (184, 'images/flags/ru.png', 'RU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (185, 'images/flags/rw.png', 'RW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (186, 'images/flags/sa.png', 'SA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (187, 'images/flags/sb.png', 'SB', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (188, 'images/flags/sc.png', 'SC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (189, 'images/flags/sd.png', 'SD', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (190, 'images/flags/se.png', 'SE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (191, 'images/flags/sg.png', 'SG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (192, 'images/flags/sh.png', 'SH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (193, 'images/flags/si.png', 'SI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (194, 'images/flags/sj.png', 'SJ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (195, 'images/flags/sk.png', 'SK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (196, 'images/flags/sl.png', 'SL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (197, 'images/flags/sm.png', 'SM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (198, 'images/flags/sn.png', 'SN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (199, 'images/flags/so.png', 'SO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (200, 'images/flags/sr.png', 'SR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (201, 'images/flags/st.png', 'ST', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (202, 'images/flags/sv.png', 'SV', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (203, 'images/flags/sy.png', 'SY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (204, 'images/flags/sz.png', 'SZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (205, 'images/flags/tc.png', 'TC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (206, 'images/flags/td.png', 'TD', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (207, 'images/flags/tf.png', 'TF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (208, 'images/flags/tg.png', 'TG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (209, 'images/flags/th.png', 'TH', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (210, 'images/flags/tj.png', 'TJ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (211, 'images/flags/tk.png', 'TK', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (212, 'images/flags/tl.png', 'TL', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (213, 'images/flags/tm.png', 'TM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (214, 'images/flags/tn.png', 'TN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (215, 'images/flags/to.png', 'TO', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (216, 'images/flags/tr.png', 'TR', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (217, 'images/flags/tt.png', 'TT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (218, 'images/flags/tv.png', 'TV', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (219, 'images/flags/tw.png', 'TW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (220, 'images/flags/tz.png', 'TZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (221, 'images/flags/ua.png', 'UA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (222, 'images/flags/us.png', 'US', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (223, 'images/flags/ug.png', 'UG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (224, 'images/flags/um.png', 'UM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (225, 'images/flags/uy.png', 'UY', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (226, 'images/flags/uz.png', 'UZ', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (227, 'images/flags/va.png', 'VA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (228, 'images/flags/vc.png', 'VC', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (229, 'images/flags/ve.png', 'VE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (230, 'images/flags/vg.png', 'VG', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (231, 'images/flags/vi.png', 'VI', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (232, 'images/flags/vn.png', 'VN', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (233, 'images/flags/vu.png', 'VU', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (234, 'images/flags/wf.png', 'WF', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (235, 'images/flags/ws.png', 'WS', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (236, 'images/flags/ye.png', 'YE', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (237, 'images/flags/yt.png', 'YT', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (238, 'images/flags/za.png', 'ZA', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (239, 'images/flags/zm.png', 'ZM', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (240, 'images/flags/zw.png', 'ZW', '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `genres` -- CREATE TABLE `genres` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `slug` varchar(100) DEFAULT NULL, `description` text DEFAULT NULL, `icon` text DEFAULT NULL, `featured` tinyint(4) DEFAULT 0, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `genres` -- INSERT INTO `genres` (`id`, `name`, `slug`, `description`, `icon`, `featured`, `status`, `created_at`, `updated_at`) VALUES (1, 'Action', 'action', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Thriller', 'thriller', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Crime', 'crime', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Comedy', 'comedy', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Animation', 'animation', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'Fantasy', 'fantasy', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'Music', 'music', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'Family', 'family', NULL, NULL, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `interests` -- CREATE TABLE `interests` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `interests` -- INSERT INTO `interests` (`id`, `title`, `status`, `created_at`, `updated_at`) VALUES (1, 'Action', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Drama', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Cartoon', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Animation', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Fiction', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'Non-Fiction', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'Novel', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'Science fiction', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(191) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(191) NOT NULL, `name` varchar(191) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `languages` -- CREATE TABLE `languages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `locale` varchar(30) NOT NULL, `flag` varchar(50) DEFAULT NULL, `text_direction` varchar(30) DEFAULT 'ltr', `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `languages` -- INSERT INTO `languages` (`id`, `name`, `locale`, `flag`, `text_direction`, `status`, `created_at`, `updated_at`) VALUES (1, 'English', 'en', 'images/flags/us.png', 'ltr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Bangla', 'bd', 'images/flags/bd.png', 'ltr', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `live_tvs` -- CREATE TABLE `live_tvs` ( `id` bigint(20) UNSIGNED NOT NULL, `tv_name` varchar(191) DEFAULT NULL, `slug` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `live_tv_category_id` int(11) DEFAULT NULL, `country_id` int(11) DEFAULT NULL, `language` varchar(10) DEFAULT 'en', `stream_from` varchar(191) DEFAULT NULL, `stream_label` varchar(191) DEFAULT NULL, `stream_url` varchar(191) DEFAULT NULL, `thumbnail` longtext DEFAULT NULL, `tags` longtext DEFAULT NULL, `seo_title` varchar(191) DEFAULT NULL, `focus_keyword` longtext DEFAULT NULL, `meta_description` longtext DEFAULT NULL, `today_view` int(10) UNSIGNED NOT NULL DEFAULT 0, `weekly_view` int(10) UNSIGNED NOT NULL DEFAULT 0, `monthly_view` mediumint(8) UNSIGNED NOT NULL DEFAULT 0, `total_view` bigint(20) UNSIGNED NOT NULL DEFAULT 1, `featured` int(11) DEFAULT 1, `is_free` int(11) NOT NULL DEFAULT 1, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `live_tvs` -- INSERT INTO `live_tvs` (`id`, `tv_name`, `slug`, `description`, `live_tv_category_id`, `country_id`, `language`, `stream_from`, `stream_label`, `stream_url`, `thumbnail`, `tags`, `seo_title`, `focus_keyword`, `meta_description`, `today_view`, `weekly_view`, `monthly_view`, `total_view`, `featured`, `is_free`, `status`, `created_at`, `updated_at`) VALUES (1, 'channel', 'channel', '', 1, 14, 'en', 'hls', 'HD', 'http://103.230.105.252:1935/live/btv/manifest.m3u8-48aa-adcf-5a6c64da8c5c_3_playlist.m3u8', '{\"storage\":\"local\",\"original_image\":\"https:\\/\\/placehold.co\\/400x320\",\"image_240x240\":\"https:\\/\\/placehold.co\\/240x240\",\"image_80x80\":\"https:\\/\\/placehold.co\\/80x80\",\"image_1080x720\":\"https:\\/\\/placehold.co\\/1080x1920\"}', '', '', '', '', 0, 0, 0, 1, 1, 1, 1, '2025-08-11 10:39:29', '2025-08-11 10:54:54'); -- -------------------------------------------------------- -- -- Table structure for table `live_tv_categories` -- CREATE TABLE `live_tv_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `live_tv_category` varchar(191) DEFAULT NULL, `slug` mediumtext NOT NULL, `live_tv_category_desc` mediumtext DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `live_tv_categories` -- INSERT INTO `live_tv_categories` (`id`, `live_tv_category`, `slug`, `live_tv_category_desc`, `status`, `created_at`, `updated_at`) VALUES (1, 'News', 'news', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Music', 'music', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Comedy', 'comedy', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Drama', 'drama', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Comedy Drama', 'comedy-drama', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'Teen Drama', 'teen-drama', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'Teen Drama', 'teen-drama', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'Romantic Drama', 'romantic-drama', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (9, 'Political Drama', 'political-drama', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (10, 'Movie', 'movie', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (11, 'Entertainment', 'entertainment', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (12, 'Factual', 'factual', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (13, 'Sports', 'sports', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (14, 'Sci-Fi', 'sci-Fi', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (15, 'Animated', 'animated', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (16, 'Mokumentary', 'mokumentary', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (17, 'Telenovela', 'telenovela', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (18, 'TV Documentary', 'tv-documentary', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (19, 'Streaming TV', 'streaming-tv', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (20, 'Soap Opera', 'soap-opera', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (21, 'Reality TV', 'reality-tv', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (22, 'Sitcom', 'sitcom', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (23, 'Horror', 'horror', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `live_tv_urls` -- CREATE TABLE `live_tv_urls` ( `id` bigint(20) UNSIGNED NOT NULL, `stream_key` varchar(50) DEFAULT NULL, `live_tv_id` int(11) DEFAULT NULL, `url_for` varchar(191) DEFAULT NULL, `source` varchar(191) DEFAULT NULL, `label` varchar(191) DEFAULT NULL, `quality` varchar(191) DEFAULT NULL, `url` mediumtext DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(191) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2025_03_04_100437_create_movies_table', 1), (5, '2025_03_08_031102_create_categories_table', 1), (6, '2025_03_08_054200_create_countries_table', 1), (7, '2025_03_08_060009_create_stars_table', 1), (8, '2025_03_09_032819_create_movie_languages_table', 1), (9, '2025_03_09_050059_create_genres_table', 1), (10, '2025_03_10_035013_create_packages_table', 1), (11, '2025_03_10_052418_create_video_qualities_table', 1), (12, '2025_03_11_031947_create_tv_shows_table', 1), (13, '2025_03_12_051942_create_configs_table', 1), (14, '2025_03_12_080517_create_seasons_table', 1), (15, '2025_03_12_085022_create_episodes_table', 1), (16, '2025_03_13_065139_create_movie_files_table', 1), (17, '2025_03_16_035545_create_live_tv_categories_table', 1), (18, '2025_03_19_050111_create_live_tvs_table', 1), (19, '2025_03_19_080018_create_live_tv_urls_table', 1), (20, '2025_03_20_045421_create_timezones_table', 1), (21, '2025_03_20_054706_create_currencies_table', 1), (22, '2025_03_22_033032_create_blogs_table', 1), (23, '2025_03_22_041033_create_blog_categories_table', 1), (24, '2025_04_12_040457_create_pages_table', 1), (25, '2025_04_13_102254_create_personal_access_tokens_table', 1), (26, '2025_04_19_065834_create_interests_table', 1), (27, '2025_04_23_042304_create_faqs_table', 1), (28, '2025_05_01_052118_create_email_templates_table', 1), (29, '2025_05_08_033311_create_play_lists_table', 1), (30, '2025_05_08_033322_create_play_list_movies_table', 1), (31, '2025_05_12_042334_create_page_languages_table', 1), (32, '2025_05_12_110435_create_customer_queries_table', 1), (33, '2025_05_13_045004_create_favorite_movies_table', 1), (34, '2025_05_13_045022_create_favorite_tv_shows_table', 1), (35, '2025_05_13_045031_create_favorite_live_tvs_table', 1), (36, '2025_05_20_035712_create_movie_industries_table', 1), (37, '2025_05_20_090049_create_customer_query_replies_table', 1), (38, '2025_05_21_034932_create_reviews_table', 1), (39, '2025_05_21_054830_create_languages_table', 1), (40, '2025_05_21_071336_create_flag_icons_table', 1), (41, '2025_05_22_094845_create_download_links_table', 1), (42, '2025_05_23_161713_update_email_template_body', 1), (43, '2025_06_23_085336_create_ads_table', 1), (44, '2025_07_02_032327_create_watch_histories_table', 1), (45, '2025_07_07_063746_create_review_likes_table', 1), (46, '2025_07_10_114347_create_rental_histories_table', 1), (47, '2025_07_16_084315_create_movie_requests_table', 1), (48, '2025_07_16_104825_create_reports_table', 1), (49, '2025_07_26_091633_create_payment_methods_table', 1), (50, '2025_07_26_091921_create_clients_table', 1), (51, '2025_07_26_091922_create_subscriptions_table', 1), (52, '2025_07_26_092940_create_plan_credentials_table', 1), (53, '2025_07_27_060122_create_stripe_sessions_table', 1), (54, '2025_07_27_085045_create_subscription_transaction_logs_table', 1), (55, '2025_08_03_050628_create_roles_table', 1), (56, '2025_08_03_050921_create_permissions_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `movies` -- CREATE TABLE `movies` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text DEFAULT NULL, `thumbnail` text DEFAULT NULL, `poster` text DEFAULT NULL, `slug` varchar(191) DEFAULT NULL, `seo_title` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `stars` text DEFAULT NULL, `director` text DEFAULT NULL, `writer` text DEFAULT NULL, `rating` varchar(5) DEFAULT '0', `release` varchar(25) DEFAULT NULL, `country` varchar(191) DEFAULT NULL, `genre` varchar(191) DEFAULT NULL, `language` varchar(191) DEFAULT NULL, `video_type` varchar(50) DEFAULT NULL, `runtime` varchar(10) DEFAULT NULL, `video_quality` varchar(191) DEFAULT 'HD', `is_original` tinyint(4) NOT NULL DEFAULT 0, `is_trending` tinyint(4) NOT NULL DEFAULT 0, `is_featured` tinyint(4) NOT NULL DEFAULT 0, `is_recommended` tinyint(4) NOT NULL DEFAULT 0, `is_blockbuster` tinyint(4) NOT NULL DEFAULT 0, `is_real_life_story` tinyint(4) NOT NULL DEFAULT 0, `status` tinyint(4) NOT NULL DEFAULT 1, `trailer` tinyint(4) DEFAULT 0, `trailler_youtube_source` mediumtext DEFAULT NULL, `enable_download` tinyint(4) DEFAULT 1, `focus_keyword` mediumtext DEFAULT NULL, `meta_description` mediumtext DEFAULT NULL, `tags` mediumtext DEFAULT NULL, `imdb_rating` varchar(5) DEFAULT NULL, `is_tvseries` tinyint(4) NOT NULL DEFAULT 0, `total_rating` int(11) DEFAULT 1, `is_free` tinyint(4) NOT NULL DEFAULT 0, `is_rental` int(11) NOT NULL DEFAULT 0, `rental_price` int(11) DEFAULT NULL, `rental_duration` int(11) DEFAULT NULL, `rental_type` varchar(191) DEFAULT NULL, `today_view` int(10) UNSIGNED NOT NULL DEFAULT 0, `weekly_view` int(10) UNSIGNED NOT NULL DEFAULT 0, `monthly_view` mediumint(8) UNSIGNED NOT NULL DEFAULT 0, `total_view` bigint(20) UNSIGNED NOT NULL DEFAULT 1, `last_view_reset` timestamp NULL DEFAULT '2025-04-04 00:00:00', `last_ep_added` timestamp NULL DEFAULT '2025-04-04 00:00:00', `imdbid` varchar(191) DEFAULT NULL, `tmdb_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `movies` -- INSERT INTO `movies` (`id`, `title`, `thumbnail`, `poster`, `slug`, `seo_title`, `description`, `stars`, `director`, `writer`, `rating`, `release`, `country`, `genre`, `language`, `video_type`, `runtime`, `video_quality`, `is_original`, `is_trending`, `is_featured`, `is_recommended`, `is_blockbuster`, `is_real_life_story`, `status`, `trailer`, `trailler_youtube_source`, `enable_download`, `focus_keyword`, `meta_description`, `tags`, `imdb_rating`, `is_tvseries`, `total_rating`, `is_free`, `is_rental`, `rental_price`, `rental_duration`, `rental_type`, `today_view`, `weekly_view`, `monthly_view`, `total_view`, `last_view_reset`, `last_ep_added`, `imdbid`, `tmdb_id`, `created_at`, `updated_at`) VALUES (1, 'Jurassic World Rebirth', '{\"original_image\":\"https://placehold.co/500x750\"}', '{\"original_image\":\"https://placehold.co/1920x1080\"}', 'jurassic-world-rebirth', 'Jurassic World Rebirth', 'Five years after the events of Jurassic World Dominion, covert operations expert Zora Bennett is contracted to lead a skilled team on a top-secret mission to secure genetic material from the world\'s three most massive dinosaurs. When Zora\'s operation intersects with a civilian family whose boating expedition was capsized, they all find themselves stranded on an island where they come face-to-face with a sinister, shocking discovery that\'s been hidden from the world for decades.', '[\"1\",\"2\",\"3\"]', '[\"3\"]', '[\"4\"]', NULL, '2025-07-01', '[\"194\"]', '[\"1\",\"2\",\"3\"]', '[\"2\",\"5\"]', '1', '134', '1', 0, 1, 1, 1, 1, 0, 1, 0, NULL, 1, '', 'Five years after the events of Jurassic World Dominion, covert operations expert Zora Bennett is contracted to lead a skilled team on a top-secret mission to secure genetic material from the world\'s three most massive dinosaurs. When Zora\'s operation intersects with a civilian family whose boating expedition was capsized, they all find themselves stranded on an island where they come face-to-face with a sinister, shocking discovery that\'s been hidden from the world for decades.', '', '6.399', 0, 1, 1, 0, NULL, NULL, NULL, 0, 0, 0, 1, '2025-04-03 18:00:00', '2025-04-03 18:00:00', '1234821', 1234821, '2025-08-11 08:46:42', '2025-08-11 08:46:42'); -- -------------------------------------------------------- -- -- Table structure for table `movie_files` -- CREATE TABLE `movie_files` ( `id` bigint(20) UNSIGNED NOT NULL, `stream_key` varchar(50) DEFAULT NULL, `video_id` bigint(20) DEFAULT NULL, `file_source` varchar(191) DEFAULT NULL, `source_type` varchar(191) DEFAULT NULL, `file_url` varchar(191) DEFAULT NULL, `label` varchar(191) NOT NULL DEFAULT 'Server#1', `order` int(11) NOT NULL DEFAULT 0, `conversion_status` varchar(191) NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `movie_industries` -- CREATE TABLE `movie_industries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `country_id` varchar(191) NOT NULL, `status` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `movie_industries` -- INSERT INTO `movie_industries` (`id`, `name`, `country_id`, `status`, `created_at`, `updated_at`) VALUES (1, 'Bollywood', '75', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Hollywood', '184', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Tollywood', '75', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Japan', '84', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'Chinese cinema', '36', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'South Korea', '60', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `movie_languages` -- CREATE TABLE `movie_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `slug` varchar(100) NOT NULL, `description` text DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `movie_languages` -- INSERT INTO `movie_languages` (`id`, `name`, `slug`, `description`, `status`, `created_at`, `updated_at`) VALUES (1, 'Bangla', 'bangla', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'English', 'english', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Arabic', 'arabic', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'Spanish', 'spanish', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `movie_requests` -- CREATE TABLE `movie_requests` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `email` varchar(191) NOT NULL, `movie_name` varchar(191) NOT NULL, `message` text DEFAULT NULL, `status` enum('pending','approved','denied') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `packages` -- CREATE TABLE `packages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `day` int(10) UNSIGNED NOT NULL DEFAULT 0, `screens` int(11) DEFAULT NULL, `type` varchar(191) NOT NULL, `price_id` varchar(191) DEFAULT NULL, `price` double NOT NULL, `discount` int(11) DEFAULT 0, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `packages` -- INSERT INTO `packages` (`id`, `name`, `day`, `screens`, `type`, `price_id`, `price`, `discount`, `status`, `created_at`, `updated_at`) VALUES (1, 'Basic', 7, 3, 'monthly', 'price_id', 200, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Professional ', 14, 5, 'monthly', 'price_id', 300, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Ultra ', 28, 8, 'monthly', 'price_id', 500, 0, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `content` text DEFAULT NULL, `type` varchar(100) DEFAULT NULL, `link` varchar(191) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `meta_title` varchar(191) DEFAULT NULL, `meta_keywords` varchar(191) DEFAULT NULL, `meta_description` text DEFAULT NULL, `meta_image_id` bigint(20) UNSIGNED DEFAULT NULL, `meta_image` text DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Inactive', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `page_languages` -- CREATE TABLE `page_languages` ( `id` bigint(20) UNSIGNED NOT NULL, `page_id` bigint(20) UNSIGNED DEFAULT NULL, `lang` varchar(50) DEFAULT NULL, `title` varchar(191) DEFAULT NULL, `content` text DEFAULT NULL, `meta_title` varchar(191) DEFAULT NULL, `meta_keywords` varchar(191) DEFAULT NULL, `meta_description` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(191) NOT NULL, `token` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_methods` -- CREATE TABLE `payment_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `trx_id` varchar(191) NOT NULL, `code` varchar(191) DEFAULT NULL, `api_token` text DEFAULT NULL, `guest_id` tinyint(4) NOT NULL DEFAULT 0, `amount` double NOT NULL DEFAULT 0, `type` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(151) NOT NULL, `attribute` varchar(191) DEFAULT NULL, `keywords` mediumtext DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `name`, `attribute`, `keywords`, `created_at`, `updated_at`) VALUES (1, 'dashboard', 'dashboard', '{\"dashboard\":\"admin.dashboard\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'email', 'email', '{\"server_configuration\":\"email.server-configuration\",\"update_server_configuration\":\"email.server-configuration.update\",\"test_email\":\"email.test\",\"template\":\"email.template\",\"update_template\":\"email.template.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'movies', 'movies', '{\"view\":\"admin.movies\",\"add\":\"admin.movie.add\",\"store\":\"admin.movie.store\",\"delete\":\"admin.movie.delete\",\"edit\":\"admin.movie.edit\",\"update\":\"admin.movie.update\",\"uploads_view\":\"admin.movie.upload.downloads\",\"file_add\":\"admin.movie.file.add\",\"file_store\":\"admin.movie.file.store\",\"file_delete\":\"admin.movie.file.delete\",\"file_edit\":\"admin.movie.file.edit\",\"file_update\":\"admin.movie.file.update\",\"make_rental\":\"admin.make.rental\",\"make_rental_store\":\"admin.make.rent.store\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 'downloads', 'downloads', '{\"view\":\"admin.download.links\",\"add\":\"admin.download.link.add\",\"store\":\"admin.download_link.store\",\"edit\":\"admin.download_link.edit\",\"update\":\"admin.download_link.update\",\"delete\":\"admin.download_link.delete\",\"status\":\"admin.download_link.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'categories', 'categories', '{\"view\":\"admin.categories\",\"add\":\"admin.category.add\",\"store\":\"admin.category.store\",\"delete\":\"admin.category.delete\",\"edit\":\"admin.category.edit\",\"update\":\"admin.category.update\",\"primary_status\":\"admin.category.primary.status\",\"footer_status\":\"admin.category.footer.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 'tv shows', 'tv_shows', '{\"view\":\"admin.tv.shows\",\"add\":\"admin.tv.show.add\",\"store\":\"admin.tv.show.store\",\"delete\":\"admin.tv.show.delete\",\"edit\":\"admin.tv.show.edit\",\"update\":\"admin.tv.show.update\",\"settings\":\"admin.tv.show.settings\",\"config\":\"admin.tv.show.config\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, 'live tv categories', 'live_tv_categories', '{\"view\":\"admin.live.tv.categories\",\"add\":\"admin.live.tv.category.add\",\"store\":\"admin.live.tv.category.store\",\"delete\":\"admin.live.tv.category.delete\",\"edit\":\"admin.live.tv.category.edit\",\"update\":\"admin.live.tv.category.update\",\"status\":\"admin.live.tv.category.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, 'live tv', 'live_tv', '{\"view\":\"admin.live.tvs\",\"add\":\"admin.live.tv.add\",\"store\":\"admin.live.tv.store\",\"delete\":\"admin.live.tv.delete\",\"edit\":\"admin.live.tv.edit\",\"update\":\"admin.live.tv.update\",\"status\":\"admin.live.tv.status\",\"feature\":\"admin.live.tv.feature\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (9, 'seasons', 'seasons', '{\"view\":\"admin.seasons\",\"add\":\"admin.season.add\",\"store\":\"admin.season.store\",\"delete\":\"admin.season.delete\",\"edit\":\"admin.season.edit\",\"update\":\"admin.season.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (10, 'episodes', 'episodes', '{\"view\":\"admin.episodes\",\"add\":\"admin.episode.add\",\"store\":\"admin.episode.store\",\"delete\":\"admin.episode.delete\",\"edit\":\"admin.episode.edit\",\"update\":\"admin.episode.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (11, 'stars', 'stars', '{\"view\":\"admin.stars\",\"add\":\"admin.star.add\",\"store\":\"admin.star.store\",\"delete\":\"admin.star.delete\",\"edit\":\"admin.star.edit\",\"update\":\"admin.star.update\",\"status\":\"admin.star.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (12, 'movie industries', 'movie_industries', '{\"view\":\"admin.movie_industries\",\"add\":\"admin.movie_industry.add\",\"store\":\"admin.movie_industry.store\",\"delete\":\"admin.movie_industry.delete\",\"edit\":\"admin.movie_industry.edit\",\"update\":\"admin.movie_industry.update\",\"status\":\"admin.movie_industry.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (13, 'movie languages', 'movie_languages', '{\"view\":\"admin.languages\",\"add\":\"admin.language.add\",\"store\":\"admin.language.store\",\"delete\":\"admin.language.delete\",\"edit\":\"admin.language.edit\",\"update\":\"admin.language.update\",\"status\":\"admin.language.status\",\"translations_page\":\"admin.language.translations.page\",\"translations_update\":\"admin.language.key.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (14, 'countries', 'countries', '{\"view\":\"admin.countries\",\"add\":\"admin.country.add\",\"store\":\"admin.country.store\",\"delete\":\"admin.country.delete\",\"edit\":\"admin.country.edit\",\"update\":\"admin.country.update\",\"status\":\"admin.country.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (15, 'staff', 'staff', '{\"view\":\"admin.staffs\",\"add\":\"admin.staff.add\",\"store\":\"admin.staff.store\",\"delete\":\"admin.staff.delete\",\"edit\":\"admin.staff.edit\",\"update\":\"admin.staff.update\",\"status\":\"admin.staff.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (16, 'roles', 'roles', '{\"view\":\"roles.index\",\"create\":\"roles.create\",\"edit\":\"roles.edit\",\"update\":\"roles.update\",\"delete\":\"roles.destroy\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (17, 'subscribers', 'subscribers', '{\"view\":\"admin.subscribers\",\"add\":\"admin.subscriber.add\",\"store\":\"admin.subscriber.store\",\"delete\":\"admin.subscriber.delete\",\"edit\":\"admin.subscriber.edit\",\"update\":\"admin.subscriber.update\",\"status\":\"admin.subscriber.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (18, 'packages', 'packages', '{\"view\":\"admin.packages\",\"add\":\"admin.package.add\",\"store\":\"admin.package.store\",\"delete\":\"admin.package.delete\",\"edit\":\"admin.package.edit\",\"update\":\"admin.package.update\",\"status\":\"admin.package.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (19, 'video qualities', 'video_qualities', '{\"view\":\"admin.video.qualities\",\"add\":\"admin.video.quality.add\",\"store\":\"admin.video.quality.store\",\"delete\":\"admin.video.quality.delete\",\"edit\":\"admin.video.quality.edit\",\"update\":\"admin.video.quality.update\",\"status\":\"admin.video.quality.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (20, 'importer', 'importer', '{\"view\":\"admin.importer\",\"fetch_movies\":\"admin.fetch.movies\",\"import_db\":\"admin.import.db\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (21, 'interest', 'interest', '{\"view\":\"admin.interest\",\"add\":\"admin.interest.add\",\"store\":\"admin.interest.store\",\"delete\":\"admin.interest.delete\",\"edit\":\"admin.interest.edit\",\"update\":\"admin.interest.update\",\"status\":\"admin.interest.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (22, 'settings', 'settings', '{\"system\":\"admin.system.settings\",\"admin\":\"admin.settings\",\"tmdb\":\"admin.tmdb.settings\",\"social\":\"admin.social.settings\",\"recaptcha\":\"admin.recaptcha.settings\",\"update\":\"admin.setting.update\",\"status_change\":\"setting.status.change\",\"sms_gateway\":\"admin.sms-gateway-settings\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (23, 'blog categories', 'blog_categories', '{\"view\":\"admin.blog.categories\",\"add\":\"admin.blog.category.add\",\"store\":\"admin.blog.category.store\",\"delete\":\"admin.blog.category.delete\",\"edit\":\"admin.blog.category.edit\",\"update\":\"admin.blog.category.update\",\"status\":\"admin.blog.category.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (24, 'blogs', 'blogs', '{\"view\":\"admin.blogs\",\"add\":\"admin.blog.add\",\"store\":\"admin.blog.store\",\"delete\":\"admin.blog.delete\",\"edit\":\"admin.blog.edit\",\"update\":\"admin.blog.update\",\"status\":\"admin.blog.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (25, 'faqs', 'faqs', '{\"view\":\"admin.faqs\",\"add\":\"admin.faq.add\",\"store\":\"admin.faq.store\",\"delete\":\"admin.faq.delete\",\"edit\":\"admin.faq.edit\",\"update\":\"admin.faq.update\",\"status\":\"admin.faq.status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (26, 'pages', 'pages', '{\"index\":\"pages.index\",\"create\":\"pages.create\",\"store\":\"pages.store\",\"edit\":\"pages.edit\",\"update\":\"pages.update\",\"delete\":\"page.delete\",\"status_change\":\"page.status.change\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (27, 'ads', 'ads', '{\"index\":\"admin.ads\",\"delete\":\"admin.ads.delete\",\"edit\":\"admin.ads.edit\",\"update\":\"admin.ads.update\",\"status\":\"admin.ads.status\",\"pre_roll_index\":\"admin.ads.pre_roll.index\",\"pre_roll_add\":\"admin.ads.pre_roll.add\",\"pre_roll_edit\":\"admin.ads.pre_roll.edit\",\"pre_roll_update\":\"admin.ads.pre_roll.update\",\"pre_roll_store\":\"admin.ads.pre_roll.store\",\"mid_roll_index\":\"admin.ads.mid_roll.index\",\"mid_roll_add\":\"admin.ads.mid_roll.add\",\"mid_roll_edit\":\"admin.ads.mid_roll.edit\",\"mid_roll_update\":\"admin.ads.mid_roll.update\",\"mid_roll_store\":\"admin.ads.mid_roll.store\",\"post_roll_index\":\"admin.ads.post_roll.index\",\"post_roll_add\":\"admin.ads.post_roll.add\",\"post_roll_edit\":\"admin.ads.post_roll.edit\",\"post_roll_update\":\"admin.ads.post_roll.update\",\"post_roll_store\":\"admin.ads.post_roll.store\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (28, 'profile', 'profile', '{\"manage_profile\":\"admin.manage.profile\",\"update_profile\":\"admin.update.profile\",\"change_password\":\"admin.change.password\",\"password_update\":\"admin.password.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (29, 'subscription', 'subscription', '{\"payment_gateway_view\":\"payment.gateways\",\"payment_gateway_save\":\"payment.gateway\",\"all_subscription\":\"all.subscription\",\"transaction_log\":\"transaction.log\",\"rental_history\":\"rental.history\",\"subscription_status\":\"subscribe-list.status\",\"add_subscription\":\"admin.add.subscription\",\"create_subscription\":\"create.subscription\",\"rent_status\":\"rent-list.status\",\"stop_recurring\":\"stop.recurring\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (30, 'website theme', 'website_theme', '{\"theme_options_view\":\"admin.theme.options\",\"theme_options_update\":\"admin.theme.options.post\",\"website_seo\":\"website.seo\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (31, 'system', 'system', '{\"server_info\":\"server.info\",\"system_info\":\"system.info\",\"extension_library\":\"extension.library\",\"file_system_permission\":\"file.system.permission\",\"system_update_view\":\"system.update\",\"system_update_post\":\"download.system.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (32, 'footer', 'footer', '{\"footer_content\":\"footer.content\",\"primary_content_setting_view\":\"footer.primary-content\",\"primary_content_setting_save\":\"footer.primary-content\",\"payment_banner_setting\":\"footer.payment-banner-settings\",\"copyright_setting\":\"footer.copyright\",\"update_footer_setting\":\"footer.update-setting\",\"update_footer_menu\":\"footer.update-menu\",\"social_link\":\"footer.social-link\",\"app_links\":\"footer.app_links\",\"legal_pages_link_setting\":\"footer.legal_pages_link_setting\",\"help_center_link_setting\":\"footer.help_center_link_setting\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (33, 'movie requests', 'movie_requests', '{\"index\":\"admin.movie_requests\",\"delete\":\"admin.movie_request.delete\",\"update\":\"admin.movie_request.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (34, 'reports', 'reports', '{\"index\":\"admin.reports\",\"delete\":\"admin.report.delete\",\"update\":\"admin.report.update\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (35, 'system languages', 'system_languages', '{\"view\":\"admin.system.languages\",\"add\":\"admin.system.language.add\",\"store\":\"admin.system.language.store\",\"edit\":\"admin.system.language.edit\",\"update\":\"admin.system.language.update\",\"delete\":\"admin.system.language.destroy\",\"translations_page\":\"admin.language.translations.page\",\"translations_update\":\"admin.language.key.update\",\"translations_delete\":\"admin.language.translations.delete\",\"missing_keys\":\"admin.language.missing-keys\",\"scan_and_store\":\"admin.language.scan\",\"status_change\":\"system-language-status\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (36, 'genres', 'genres', '{\"view\":\"admin.genres\",\"add\":\"admin.genre.add\",\"store\":\"admin.genre.store\",\"delete\":\"admin.genre.delete\",\"edit\":\"admin.genre.edit\",\"update\":\"admin.genre.update\",\"status\":\"admin.genre.status\",\"featured\":\"admin.genre.featured\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (37, 'reviews', 'reviews', '{\"view\":\"admin.reviews\",\"details\":\"admin.review.details\",\"reply_view\":\"admin.review.reply.view\",\"reply\":\"admin.review.reply\",\"delete\":\"admin.review.delete\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (38, 'customer queries', 'customer_queries', '{\"view\":\"admin.customer_queries.index\",\"delete\":\"admin.customer_queries.delete\",\"reply_view\":\"admin.customer_queries.reply.view\",\"reply\":\"admin.customer_queries.reply\"}', '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(191) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `plan_credentials` -- CREATE TABLE `plan_credentials` ( `id` bigint(20) UNSIGNED NOT NULL, `plan_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(191) NOT NULL, `value` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `plan_credentials` -- INSERT INTO `plan_credentials` (`id`, `plan_id`, `title`, `value`, `created_at`, `updated_at`) VALUES (1, 2, 'stripe', 'price_1OmLoXJUxq2pPEOHfvBIVgmt', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 3, 'stripe', 'price_1Ol70AJUxq2pPEOH9iYo69nr', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 5, 'stripe', 'price_1OmLq4JUxq2pPEOHJiIwCcTP', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, 6, 'stripe', 'price_1OmK7ZJUxq2pPEOHiAgV690p', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 6, 'paddle', 'pri_01hq5k3xh0qag89kq0fd6x0yyg', '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, 6, 'paypal', 'P-3D044458N8455713HMWGAJII', '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `play_lists` -- CREATE TABLE `play_lists` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `slug` varchar(191) NOT NULL, `thumbnail` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `play_list_movies` -- CREATE TABLE `play_list_movies` ( `id` bigint(20) UNSIGNED NOT NULL, `play_list_id` bigint(20) UNSIGNED NOT NULL, `movie_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `rental_histories` -- CREATE TABLE `rental_histories` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `video_id` int(11) NOT NULL, `video_type` varchar(191) NOT NULL COMMENT '1: Movie, 2: TV Show, 3: Live TV', `type` varchar(191) DEFAULT NULL, `file` text DEFAULT NULL, `status` int(11) DEFAULT 0, `transaction_id` varchar(191) DEFAULT NULL, `price` double DEFAULT NULL, `duration` int(11) DEFAULT NULL COMMENT 'in hours', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `reports` -- CREATE TABLE `reports` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `reportable_type` varchar(191) NOT NULL, `reportable_id` bigint(20) UNSIGNED NOT NULL, `video_issue` enum('broken','wrong_movie','others') DEFAULT NULL, `audio_issue` enum('not_synced','wrong_audio','others') DEFAULT NULL, `subtitle_issue` enum('not_synced','wrong_subtitle','others') DEFAULT NULL, `message` text DEFAULT NULL, `status` enum('pending','resolved') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `reviewable_type` varchar(191) NOT NULL, `reviewable_id` bigint(20) UNSIGNED NOT NULL, `review` text DEFAULT NULL, `rating` tinyint(3) UNSIGNED NOT NULL, `reply` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `review_likes` -- CREATE TABLE `review_likes` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `review_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `slug` varchar(191) DEFAULT NULL, `permissions` text DEFAULT NULL, `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `name`, `slug`, `permissions`, `status`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin', '[\"admin.dashboard\",\"email.server-configuration\",\"email.server-configuration.update\",\"email.test\",\"email.template\",\"email.template.update\",\"admin.movies\",\"admin.movie.add\",\"admin.movie.store\",\"admin.movie.delete\",\"admin.movie.edit\",\"admin.movie.update\",\"admin.movie.upload.downloads\",\"admin.movie.file.add\",\"admin.movie.file.store\",\"admin.movie.file.delete\",\"admin.movie.file.edit\",\"admin.movie.file.update\",\"admin.make.rental\",\"admin.make.rent.store\",\"admin.download.links\",\"admin.download.link.add\",\"admin.download_link.store\",\"admin.download_link.edit\",\"admin.download_link.update\",\"admin.download_link.delete\",\"admin.download_link.status\",\"admin.categories\",\"admin.category.add\",\"admin.category.store\",\"admin.category.delete\",\"admin.category.edit\",\"admin.category.update\",\"admin.category.primary.status\",\"admin.category.footer.status\",\"admin.tv.shows\",\"admin.tv.show.add\",\"admin.tv.show.store\",\"admin.tv.show.delete\",\"admin.tv.show.edit\",\"admin.tv.show.update\",\"admin.tv.show.settings\",\"admin.tv.show.config\",\"admin.live.tv.categories\",\"admin.live.tv.category.add\",\"admin.live.tv.category.store\",\"admin.live.tv.category.delete\",\"admin.live.tv.category.edit\",\"admin.live.tv.category.update\",\"admin.live.tv.category.status\",\"admin.live.tvs\",\"admin.live.tv.add\",\"admin.live.tv.store\",\"admin.live.tv.delete\",\"admin.live.tv.edit\",\"admin.live.tv.update\",\"admin.live.tv.status\",\"admin.live.tv.feature\",\"admin.seasons\",\"admin.season.add\",\"admin.season.store\",\"admin.season.delete\",\"admin.season.edit\",\"admin.season.update\",\"admin.episodes\",\"admin.episode.add\",\"admin.episode.store\",\"admin.episode.delete\",\"admin.episode.edit\",\"admin.episode.update\",\"admin.stars\",\"admin.star.add\",\"admin.star.store\",\"admin.star.delete\",\"admin.star.edit\",\"admin.star.update\",\"admin.star.status\",\"admin.languages\",\"admin.language.add\",\"admin.language.store\",\"admin.language.delete\",\"admin.language.edit\",\"admin.language.update\",\"admin.language.status\",\"admin.language.translations.page\",\"admin.language.key.update\",\"admin.countries\",\"admin.country.add\",\"admin.country.store\",\"admin.country.delete\",\"admin.country.edit\",\"admin.country.update\",\"admin.country.status\",\"admin.staffs\",\"admin.staff.add\",\"admin.staff.store\",\"admin.staff.delete\",\"admin.staff.edit\",\"admin.staff.update\",\"admin.staff.status\",\"roles.index\",\"roles.create\",\"roles.edit\",\"roles.update\",\"roles.destroy\",\"admin.subscribers\",\"admin.subscriber.add\",\"admin.subscriber.store\",\"admin.subscriber.delete\",\"admin.subscriber.edit\",\"admin.subscriber.update\",\"admin.subscriber.status\",\"admin.packages\",\"admin.package.add\",\"admin.package.store\",\"admin.package.delete\",\"admin.package.edit\",\"admin.package.update\",\"admin.package.status\",\"admin.video.qualities\",\"admin.video.quality.add\",\"admin.video.quality.store\",\"admin.video.quality.delete\",\"admin.video.quality.edit\",\"admin.video.quality.update\",\"admin.video.quality.status\",\"admin.importer\",\"admin.fetch.movies\",\"admin.import.db\",\"admin.interest\",\"admin.interest.add\",\"admin.interest.store\",\"admin.interest.delete\",\"admin.interest.edit\",\"admin.interest.update\",\"admin.interest.status\",\"admin.system.settings\",\"admin.settings\",\"admin.tmdb.settings\",\"admin.social.settings\",\"admin.recaptcha.settings\",\"admin.setting.update\",\"setting.status.change\",\"admin.sms-gateway-settings\",\"admin.blog.categories\",\"admin.blog.category.add\",\"admin.blog.category.store\",\"admin.blog.category.delete\",\"admin.blog.category.edit\",\"admin.blog.category.update\",\"admin.blog.category.status\",\"admin.blogs\",\"admin.blog.add\",\"admin.blog.store\",\"admin.blog.delete\",\"admin.blog.edit\",\"admin.blog.update\",\"admin.blog.status\",\"admin.faqs\",\"admin.faq.add\",\"admin.faq.store\",\"admin.faq.delete\",\"admin.faq.edit\",\"admin.faq.update\",\"admin.faq.status\",\"pages.index\",\"pages.create\",\"pages.store\",\"pages.edit\",\"pages.update\",\"page.delete\",\"page.status.change\",\"admin.ads\",\"admin.ads.delete\",\"admin.ads.edit\",\"admin.ads.update\",\"admin.ads.status\",\"admin.ads.pre_roll.index\",\"admin.ads.pre_roll.add\",\"admin.ads.pre_roll.edit\",\"admin.ads.pre_roll.update\",\"admin.ads.pre_roll.store\",\"admin.ads.mid_roll.index\",\"admin.ads.mid_roll.add\",\"admin.ads.mid_roll.edit\",\"admin.ads.mid_roll.update\",\"admin.ads.mid_roll.store\",\"admin.ads.post_roll.index\",\"admin.ads.post_roll.add\",\"admin.ads.post_roll.edit\",\"admin.ads.post_roll.update\",\"admin.ads.post_roll.store\",\"admin.manage.profile\",\"admin.update.profile\",\"admin.change.password\",\"admin.password.update\",\"payment.gateways\",\"payment.gateway\",\"all.subscription\",\"transaction.log\",\"rental.history\",\"subscribe-list.status\",\"admin.add.subscription\",\"create.subscription\",\"rent-list.status\",\"stop.recurring\",\"admin.theme.options\",\"admin.theme.options.post\",\"website.seo\",\"server.info\",\"system.info\",\"extension.library\",\"file.system.permission\",\"system.update\",\"download.system.update\",\"footer.content\",\"footer.primary-content\",\"footer.primary-content\",\"footer.payment-banner-settings\",\"footer.copyright\",\"footer.update-setting\",\"footer.update-menu\",\"footer.social-link\",\"footer.app_links\",\"footer.legal_pages_link_setting\",\"footer.help_center_link_setting\",\"admin.movie_requests\",\"admin.movie_request.delete\",\"admin.movie_request.update\",\"admin.reports\",\"admin.report.delete\",\"admin.report.update\"]', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'Staff', 'staff', '[\"admin.dashboard\",\"email.server-configuration\",\"email.server-configuration.update\",\"email.test\",\"email.template\",\"email.template.update\",\"admin.movies\",\"admin.movie.add\",\"admin.movie.store\",\"admin.movie.delete\",\"admin.movie.edit\",\"admin.movie.update\",\"admin.movie.upload.downloads\",\"admin.movie.file.add\",\"admin.movie.file.store\",\"admin.movie.file.delete\",\"admin.movie.file.edit\",\"admin.movie.file.update\",\"admin.make.rental\",\"admin.make.rent.store\",\"admin.download.links\",\"admin.download.link.add\",\"admin.download_link.store\",\"admin.download_link.edit\",\"admin.download_link.update\",\"admin.download_link.delete\",\"admin.download_link.status\",\"admin.categories\",\"admin.category.add\",\"admin.category.store\",\"admin.category.delete\",\"admin.category.edit\",\"admin.category.update\",\"admin.category.primary.status\",\"admin.category.footer.status\",\"admin.tv.shows\",\"admin.tv.show.add\",\"admin.tv.show.store\",\"admin.tv.show.delete\",\"admin.tv.show.edit\",\"admin.tv.show.update\",\"admin.tv.show.settings\",\"admin.tv.show.config\",\"admin.live.tv.categories\",\"admin.live.tv.category.add\",\"admin.live.tv.category.store\",\"admin.live.tv.category.delete\",\"admin.live.tv.category.edit\",\"admin.live.tv.category.update\",\"admin.live.tv.category.status\",\"admin.live.tvs\",\"admin.live.tv.add\",\"admin.live.tv.store\",\"admin.live.tv.delete\",\"admin.live.tv.edit\",\"admin.live.tv.update\",\"admin.live.tv.status\",\"admin.live.tv.feature\",\"admin.seasons\",\"admin.season.add\",\"admin.season.store\",\"admin.season.delete\",\"admin.season.edit\",\"admin.season.update\",\"admin.episodes\",\"admin.episode.add\",\"admin.episode.store\",\"admin.episode.delete\",\"admin.episode.edit\",\"admin.episode.update\",\"admin.stars\",\"admin.star.add\",\"admin.star.store\",\"admin.star.delete\",\"admin.star.edit\",\"admin.star.update\",\"admin.star.status\",\"admin.languages\",\"admin.language.add\",\"admin.language.store\",\"admin.language.delete\",\"admin.language.edit\",\"admin.language.update\",\"admin.language.status\",\"admin.language.translations.page\",\"admin.language.key.update\",\"admin.countries\",\"admin.country.add\",\"admin.country.store\",\"admin.country.delete\",\"admin.country.edit\",\"admin.country.update\",\"admin.country.status\",\"admin.staffs\",\"admin.staff.add\",\"admin.staff.store\",\"admin.staff.delete\",\"admin.staff.edit\",\"admin.staff.update\",\"admin.staff.status\",\"roles.index\",\"roles.create\",\"roles.edit\",\"roles.update\",\"roles.destroy\",\"admin.subscribers\",\"admin.subscriber.add\",\"admin.subscriber.store\",\"admin.subscriber.delete\",\"admin.subscriber.edit\",\"admin.subscriber.update\",\"admin.subscriber.status\",\"admin.packages\",\"admin.package.add\",\"admin.package.store\",\"admin.package.delete\",\"admin.package.edit\",\"admin.package.update\",\"admin.package.status\",\"admin.video.qualities\",\"admin.video.quality.add\",\"admin.video.quality.store\",\"admin.video.quality.delete\",\"admin.video.quality.edit\",\"admin.video.quality.update\",\"admin.video.quality.status\",\"admin.importer\",\"admin.fetch.movies\",\"admin.import.db\",\"admin.interest\",\"admin.interest.add\",\"admin.interest.store\",\"admin.interest.delete\",\"admin.interest.edit\",\"admin.interest.update\",\"admin.interest.status\",\"admin.system.settings\",\"admin.settings\",\"admin.tmdb.settings\",\"admin.social.settings\",\"admin.recaptcha.settings\",\"admin.setting.update\",\"setting.status.change\",\"admin.sms-gateway-settings\",\"admin.blog.categories\",\"admin.blog.category.add\",\"admin.blog.category.store\",\"admin.blog.category.delete\",\"admin.blog.category.edit\",\"admin.blog.category.update\",\"admin.blog.category.status\",\"admin.blogs\",\"admin.blog.add\",\"admin.blog.store\",\"admin.blog.delete\",\"admin.blog.edit\",\"admin.blog.update\",\"admin.blog.status\",\"admin.faqs\",\"admin.faq.add\",\"admin.faq.store\",\"admin.faq.delete\",\"admin.faq.edit\",\"admin.faq.update\",\"admin.faq.status\",\"pages.index\",\"pages.create\",\"pages.store\",\"pages.edit\",\"pages.update\",\"page.delete\",\"page.status.change\",\"admin.ads\",\"admin.ads.delete\",\"admin.ads.edit\",\"admin.ads.update\",\"admin.ads.status\",\"admin.ads.pre_roll.index\",\"admin.ads.pre_roll.add\",\"admin.ads.pre_roll.edit\",\"admin.ads.pre_roll.update\",\"admin.ads.pre_roll.store\",\"admin.ads.mid_roll.index\",\"admin.ads.mid_roll.add\",\"admin.ads.mid_roll.edit\",\"admin.ads.mid_roll.update\",\"admin.ads.mid_roll.store\",\"admin.ads.post_roll.index\",\"admin.ads.post_roll.add\",\"admin.ads.post_roll.edit\",\"admin.ads.post_roll.update\",\"admin.ads.post_roll.store\",\"admin.manage.profile\",\"admin.update.profile\",\"admin.change.password\",\"admin.password.update\",\"payment.gateways\",\"payment.gateway\",\"all.subscription\",\"transaction.log\",\"rental.history\",\"subscribe-list.status\",\"admin.add.subscription\",\"create.subscription\",\"rent-list.status\",\"stop.recurring\",\"admin.theme.options\",\"admin.theme.options.post\",\"website.seo\",\"server.info\",\"system.info\",\"extension.library\",\"file.system.permission\",\"system.update\",\"download.system.update\",\"footer.content\",\"footer.primary-content\",\"footer.primary-content\",\"footer.payment-banner-settings\",\"footer.copyright\",\"footer.update-setting\",\"footer.update-menu\",\"footer.social-link\",\"footer.app_links\",\"footer.legal_pages_link_setting\",\"footer.help_center_link_setting\",\"admin.movie_requests\",\"admin.movie_request.delete\",\"admin.movie_request.update\",\"admin.reports\",\"admin.report.delete\",\"admin.report.update\"]', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `seasons` -- CREATE TABLE `seasons` ( `id` bigint(20) UNSIGNED NOT NULL, `tv_show_id` text DEFAULT NULL, `slug` varchar(191) NOT NULL, `season_name` varchar(191) DEFAULT NULL, `order` int(11) NOT NULL DEFAULT 0, `status` tinyint(4) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `seasons` -- INSERT INTO `seasons` (`id`, `tv_show_id`, `slug`, `season_name`, `order`, `status`, `created_at`, `updated_at`) VALUES (1, NULL, 'season-01', 'Season 01', 1, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, NULL, 'season-02', 'Season 02', 2, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, NULL, 'season-03', 'Season 03', 3, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, NULL, 'season-04', 'Season 04', 4, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, NULL, 'season-05', 'Season 05', 5, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, NULL, 'season-06', 'Season 06', 6, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (7, NULL, 'season-07', 'Season 07', 7, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (8, NULL, 'season-08', 'Season 08', 8, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (9, NULL, 'season-09', 'Season 09', 9, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (10, NULL, 'season-10', 'Season 10', 10, 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(191) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `stars` -- CREATE TABLE `stars` ( `id` bigint(20) UNSIGNED NOT NULL, `star_name` varchar(191) DEFAULT NULL, `slug` varchar(191) DEFAULT NULL, `star_type` varchar(191) DEFAULT NULL, `country_id` bigint(20) UNSIGNED DEFAULT NULL, `star_dob` date DEFAULT NULL, `ranking` varchar(191) DEFAULT NULL, `gender` varchar(191) DEFAULT NULL, `industries` text DEFAULT NULL, `star_image` mediumtext DEFAULT NULL, `star_desc` mediumtext DEFAULT NULL, `view` int(11) NOT NULL DEFAULT 1, `status` tinyint(4) NOT NULL DEFAULT 1, `facebook` varchar(191) DEFAULT NULL, `twitter` varchar(191) DEFAULT NULL, `instagram` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `stars` -- INSERT INTO `stars` (`id`, `star_name`, `slug`, `star_type`, `country_id`, `star_dob`, `ranking`, `gender`, `industries`, `star_image`, `star_desc`, `view`, `status`, `facebook`, `twitter`, `instagram`, `created_at`, `updated_at`) VALUES (1, 'Scarlett Johansson', 'scarlett-johansson', 'actor', NULL, NULL, NULL, NULL, NULL, '{\"original_image\":\"https://placehold.co/100x100\"}', NULL, 1, 1, NULL, NULL, NULL, '2025-08-11 08:46:40', '2025-08-11 08:46:40'), (2, 'Jonathan Bailey', 'jonathan-bailey', 'actor', NULL, NULL, NULL, NULL, NULL, '{\"original_image\":\"https://placehold.co/100x100\"}', NULL, 1, 1, NULL, NULL, NULL, '2025-08-11 08:46:40', '2025-08-11 08:46:40'), (3, 'Mahershala Ali', 'mahershala-ali', 'actor', NULL, NULL, NULL, NULL, NULL, '{\"original_image\":\"https://placehold.co/100x100\"}', NULL, 1, 1, NULL, NULL, NULL, '2025-08-11 08:46:40', '2025-08-11 08:46:40'), (4, 'Rupert Friend', 'rupert-friend', 'actor', NULL, NULL, NULL, NULL, NULL, '{\"original_image\":\"https://placehold.co/100x100\"}', NULL, 1, 1, NULL, NULL, NULL, '2025-08-11 08:46:40', '2025-08-11 08:46:40'), (5, 'Manuel Garcia-Rulfo', 'manuel-garcia-rulfo', 'actor', NULL, NULL, NULL, NULL, NULL, '{\"original_image\":\"https://placehold.co/100x100\"}', NULL, 1, 1, NULL, NULL, NULL, '2025-08-11 08:46:40', '2025-08-11 08:46:40'); -- -------------------------------------------------------- -- -- Table structure for table `stripe_sessions` -- CREATE TABLE `stripe_sessions` ( `id` bigint(20) UNSIGNED NOT NULL, `plan_id` varchar(191) NOT NULL, `stripe_session_id` varchar(191) DEFAULT NULL, `client_id` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` bigint(20) UNSIGNED NOT NULL, `client_id` bigint(20) UNSIGNED DEFAULT NULL, `plan_id` bigint(20) UNSIGNED DEFAULT NULL, `is_recurring` varchar(191) NOT NULL, `team_limit` int(11) DEFAULT NULL, `team_limit_remaining` int(11) DEFAULT 0, `profile_limit` int(11) DEFAULT NULL, `profile_limit_remaining` int(11) DEFAULT 0, `post_limit` int(11) DEFAULT NULL, `post_limit_remaining` int(11) DEFAULT 0, `purchase_date` datetime DEFAULT NULL, `price` double NOT NULL DEFAULT 0, `package_type` varchar(191) DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0:pending,1:active,2:rejected,3:inactive', `expire_date` date DEFAULT NULL, `canceled_at` date DEFAULT NULL, `trx_id` varchar(191) DEFAULT NULL, `payment_method` varchar(191) DEFAULT NULL, `payment_details` text DEFAULT NULL, `billing_name` varchar(191) DEFAULT NULL, `billing_email` varchar(191) DEFAULT NULL, `billing_address` varchar(191) DEFAULT NULL, `billing_city` varchar(191) DEFAULT NULL, `billing_state` varchar(191) DEFAULT NULL, `billing_zip_code` varchar(191) DEFAULT NULL, `billing_country` varchar(191) DEFAULT NULL, `billing_phone` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `subscription_transaction_logs` -- CREATE TABLE `subscription_transaction_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `description` longtext DEFAULT NULL, `client_id` bigint(20) UNSIGNED DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_by` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `timezones` -- CREATE TABLE `timezones` ( `id` bigint(20) UNSIGNED NOT NULL, `country_code` varchar(5) NOT NULL, `timezone` varchar(191) NOT NULL, `gmt_offset` varchar(8) NOT NULL, `dst_offset` varchar(8) NOT NULL, `raw_offset` varchar(8) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `timezones` -- INSERT INTO `timezones` (`id`, `country_code`, `timezone`, `gmt_offset`, `dst_offset`, `raw_offset`, `created_at`, `updated_at`) VALUES (1, 'AD', 'Europe/Andorra', '1.00', '2.00', '1.00', NULL, NULL), (2, 'AE', 'Asia/Dubai', '4.00', '4.00', '4.00', NULL, NULL), (3, 'AF', 'Asia/Kabul', '4.50', '4.50', '4.50', NULL, NULL), (4, 'AG', 'America/Antigua', '-4.00', '-4.00', '-4.00', NULL, NULL), (5, 'AI', 'America/Anguilla', '-4.00', '-4.00', '-4.00', NULL, NULL), (6, 'AL', 'Europe/Tirane', '1.00', '2.00', '1.00', NULL, NULL), (7, 'AM', 'Asia/Yerevan', '4.00', '4.00', '4.00', NULL, NULL), (8, 'AO', 'Africa/Luanda', '1.00', '1.00', '1.00', NULL, NULL), (9, 'AQ', 'Antarctica/Casey', '8.00', '8.00', '8.00', NULL, NULL), (10, 'AQ', 'Antarctica/Davis', '7.00', '7.00', '7.00', NULL, NULL), (11, 'AQ', 'Antarctica/DumontDUrville', '10.00', '10.00', '10.00', NULL, NULL), (12, 'AQ', 'Antarctica/Mawson', '5.00', '5.00', '5.00', NULL, NULL), (13, 'AQ', 'Antarctica/McMurdo', '13.00', '12.00', '12.00', NULL, NULL), (14, 'AQ', 'Antarctica/Palmer', '-3.00', '-4.00', '-4.00', NULL, NULL), (15, 'AQ', 'Antarctica/Rothera', '-3.00', '-3.00', '-3.00', NULL, NULL), (16, 'AQ', 'Antarctica/South_Pole', '13.00', '12.00', '12.00', NULL, NULL), (17, 'AQ', 'Antarctica/Syowa', '3.00', '3.00', '3.00', NULL, NULL), (18, 'AQ', 'Antarctica/Vostok', '6.00', '6.00', '6.00', NULL, NULL), (19, 'AR', 'America/Argentina/Buenos_Aires', '-3.00', '-3.00', '-3.00', NULL, NULL), (20, 'AR', 'America/Argentina/Catamarca', '-3.00', '-3.00', '-3.00', NULL, NULL), (21, 'AR', 'America/Argentina/Cordoba', '-3.00', '-3.00', '-3.00', NULL, NULL), (22, 'AR', 'America/Argentina/Jujuy', '-3.00', '-3.00', '-3.00', NULL, NULL), (23, 'AR', 'America/Argentina/La_Rioja', '-3.00', '-3.00', '-3.00', NULL, NULL), (24, 'AR', 'America/Argentina/Mendoza', '-3.00', '-3.00', '-3.00', NULL, NULL), (25, 'AR', 'America/Argentina/Rio_Gallegos', '-3.00', '-3.00', '-3.00', NULL, NULL), (26, 'AR', 'America/Argentina/Salta', '-3.00', '-3.00', '-3.00', NULL, NULL), (27, 'AR', 'America/Argentina/San_Juan', '-3.00', '-3.00', '-3.00', NULL, NULL), (28, 'AR', 'America/Argentina/San_Luis', '-3.00', '-3.00', '-3.00', NULL, NULL), (29, 'AR', 'America/Argentina/Tucuman', '-3.00', '-3.00', '-3.00', NULL, NULL), (30, 'AR', 'America/Argentina/Ushuaia', '-3.00', '-3.00', '-3.00', NULL, NULL), (31, 'AS', 'Pacific/Pago_Pago', '-11.00', '-11.00', '-11.00', NULL, NULL), (32, 'AT', 'Europe/Vienna', '1.00', '2.00', '1.00', NULL, NULL), (33, 'AU', 'Antarctica/Macquarie', '11.00', '11.00', '11.00', NULL, NULL), (34, 'AU', 'Australia/Adelaide', '10.50', '9.50', '9.50', NULL, NULL), (35, 'AU', 'Australia/Brisbane', '10.00', '10.00', '10.00', NULL, NULL), (36, 'AU', 'Australia/Broken_Hill', '10.50', '9.50', '9.50', NULL, NULL), (37, 'AU', 'Australia/Currie', '11.00', '10.00', '10.00', NULL, NULL), (38, 'AU', 'Australia/Darwin', '9.50', '9.50', '9.50', NULL, NULL), (39, 'AU', 'Australia/Eucla', '8.75', '8.75', '8.75', NULL, NULL), (40, 'AU', 'Australia/Hobart', '11.00', '10.00', '10.00', NULL, NULL), (41, 'AU', 'Australia/Lindeman', '10.00', '10.00', '10.00', NULL, NULL), (42, 'AU', 'Australia/Lord_Howe', '11.00', '10.50', '10.50', NULL, NULL), (43, 'AU', 'Australia/Melbourne', '11.00', '10.00', '10.00', NULL, NULL), (44, 'AU', 'Australia/Perth', '8.00', '8.00', '8.00', NULL, NULL), (45, 'AU', 'Australia/Sydney', '11.00', '10.00', '10.00', NULL, NULL), (46, 'AW', 'America/Aruba', '-4.00', '-4.00', '-4.00', NULL, NULL), (47, 'AX', 'Europe/Mariehamn', '2.00', '3.00', '2.00', NULL, NULL), (48, 'AZ', 'Asia/Baku', '4.00', '5.00', '4.00', NULL, NULL), (49, 'BA', 'Europe/Sarajevo', '1.00', '2.00', '1.00', NULL, NULL), (50, 'BB', 'America/Barbados', '-4.00', '-4.00', '-4.00', NULL, NULL), (51, 'BD', 'Asia/Dhaka', '6.00', '6.00', '6.00', NULL, NULL), (52, 'BE', 'Europe/Brussels', '1.00', '2.00', '1.00', NULL, NULL), (53, 'BF', 'Africa/Ouagadougou', '0.00', '0.00', '0.00', NULL, NULL), (54, 'BG', 'Europe/Sofia', '2.00', '3.00', '2.00', NULL, NULL), (55, 'BH', 'Asia/Bahrain', '3.00', '3.00', '3.00', NULL, NULL), (56, 'BI', 'Africa/Bujumbura', '2.00', '2.00', '2.00', NULL, NULL), (57, 'BJ', 'Africa/Porto-Novo', '1.00', '1.00', '1.00', NULL, NULL), (58, 'BL', 'America/St_Barthelemy', '-4.00', '-4.00', '-4.00', NULL, NULL), (59, 'BM', 'Atlantic/Bermuda', '-4.00', '-3.00', '-4.00', NULL, NULL), (60, 'BN', 'Asia/Brunei', '8.00', '8.00', '8.00', NULL, NULL), (61, 'BO', 'America/La_Paz', '-4.00', '-4.00', '-4.00', NULL, NULL), (62, 'BQ', 'America/Kralendijk', '-4.00', '-4.00', '-4.00', NULL, NULL), (63, 'BR', 'America/Araguaina', '-3.00', '-3.00', '-3.00', NULL, NULL), (64, 'BR', 'America/Bahia', '-3.00', '-3.00', '-3.00', NULL, NULL), (65, 'BR', 'America/Belem', '-3.00', '-3.00', '-3.00', NULL, NULL), (66, 'BR', 'America/Boa_Vista', '-4.00', '-4.00', '-4.00', NULL, NULL), (67, 'BR', 'America/Campo_Grande', '-3.00', '-4.00', '-4.00', NULL, NULL), (68, 'BR', 'America/Cuiaba', '-3.00', '-4.00', '-4.00', NULL, NULL), (69, 'BR', 'America/Eirunepe', '-5.00', '-5.00', '-5.00', NULL, NULL), (70, 'BR', 'America/Fortaleza', '-3.00', '-3.00', '-3.00', NULL, NULL), (71, 'BR', 'America/Maceio', '-3.00', '-3.00', '-3.00', NULL, NULL), (72, 'BR', 'America/Manaus', '-4.00', '-4.00', '-4.00', NULL, NULL), (73, 'BR', 'America/Noronha', '-2.00', '-2.00', '-2.00', NULL, NULL), (74, 'BR', 'America/Porto_Velho', '-4.00', '-4.00', '-4.00', NULL, NULL), (75, 'BR', 'America/Recife', '-3.00', '-3.00', '-3.00', NULL, NULL), (76, 'BR', 'America/Rio_Branco', '-5.00', '-5.00', '-5.00', NULL, NULL), (77, 'BR', 'America/Santarem', '-3.00', '-3.00', '-3.00', NULL, NULL), (78, 'BR', 'America/Sao_Paulo', '-2.00', '-3.00', '-3.00', NULL, NULL), (79, 'BS', 'America/Nassau', '-5.00', '-4.00', '-5.00', NULL, NULL), (80, 'BT', 'Asia/Thimphu', '6.00', '6.00', '6.00', NULL, NULL), (81, 'BW', 'Africa/Gaborone', '2.00', '2.00', '2.00', NULL, NULL), (82, 'BY', 'Europe/Minsk', '3.00', '3.00', '3.00', NULL, NULL), (83, 'BZ', 'America/Belize', '-6.00', '-6.00', '-6.00', NULL, NULL), (84, 'CA', 'America/Atikokan', '-5.00', '-5.00', '-5.00', NULL, NULL), (85, 'CA', 'America/Blanc-Sablon', '-4.00', '-4.00', '-4.00', NULL, NULL), (86, 'CA', 'America/Cambridge_Bay', '-7.00', '-6.00', '-7.00', NULL, NULL), (87, 'CA', 'America/Creston', '-7.00', '-7.00', '-7.00', NULL, NULL), (88, 'CA', 'America/Dawson', '-8.00', '-7.00', '-8.00', NULL, NULL), (89, 'CA', 'America/Dawson_Creek', '-7.00', '-7.00', '-7.00', NULL, NULL), (90, 'CA', 'America/Edmonton', '-7.00', '-6.00', '-7.00', NULL, NULL), (91, 'CA', 'America/Glace_Bay', '-4.00', '-3.00', '-4.00', NULL, NULL), (92, 'CA', 'America/Goose_Bay', '-4.00', '-3.00', '-4.00', NULL, NULL), (93, 'CA', 'America/Halifax', '-4.00', '-3.00', '-4.00', NULL, NULL), (94, 'CA', 'America/Inuvik', '-7.00', '-6.00', '-7.00', NULL, NULL), (95, 'CA', 'America/Iqaluit', '-5.00', '-4.00', '-5.00', NULL, NULL), (96, 'CA', 'America/Moncton', '-4.00', '-3.00', '-4.00', NULL, NULL), (97, 'CA', 'America/Montreal', '-5.00', '-4.00', '-5.00', NULL, NULL), (98, 'CA', 'America/Nipigon', '-5.00', '-4.00', '-5.00', NULL, NULL), (99, 'CA', 'America/Pangnirtung', '-5.00', '-4.00', '-5.00', NULL, NULL), (100, 'CA', 'America/Rainy_River', '-6.00', '-5.00', '-6.00', NULL, NULL), (101, 'CA', 'America/Rankin_Inlet', '-6.00', '-5.00', '-6.00', NULL, NULL), (102, 'CA', 'America/Regina', '-6.00', '-6.00', '-6.00', NULL, NULL), (103, 'CA', 'America/Resolute', '-6.00', '-5.00', '-6.00', NULL, NULL), (104, 'CA', 'America/St_Johns', '-3.50', '-2.50', '-3.50', NULL, NULL), (105, 'CA', 'America/Swift_Current', '-6.00', '-6.00', '-6.00', NULL, NULL), (106, 'CA', 'America/Thunder_Bay', '-5.00', '-4.00', '-5.00', NULL, NULL), (107, 'CA', 'America/Toronto', '-5.00', '-4.00', '-5.00', NULL, NULL), (108, 'CA', 'America/Vancouver', '-8.00', '-7.00', '-8.00', NULL, NULL), (109, 'CA', 'America/Whitehorse', '-8.00', '-7.00', '-8.00', NULL, NULL), (110, 'CA', 'America/Winnipeg', '-6.00', '-5.00', '-6.00', NULL, NULL), (111, 'CA', 'America/Yellowknife', '-7.00', '-6.00', '-7.00', NULL, NULL), (112, 'CC', 'Indian/Cocos', '6.50', '6.50', '6.50', NULL, NULL), (113, 'CD', 'Africa/Kinshasa', '1.00', '1.00', '1.00', NULL, NULL), (114, 'CD', 'Africa/Lubumbashi', '2.00', '2.00', '2.00', NULL, NULL), (115, 'CF', 'Africa/Bangui', '1.00', '1.00', '1.00', NULL, NULL), (116, 'CG', 'Africa/Brazzaville', '1.00', '1.00', '1.00', NULL, NULL), (117, 'CH', 'Europe/Zurich', '1.00', '2.00', '1.00', NULL, NULL), (118, 'CI', 'Africa/Abidjan', '0.00', '0.00', '0.00', NULL, NULL), (119, 'CK', 'Pacific/Rarotonga', '-10.00', '-10.00', '-10.00', NULL, NULL), (120, 'CL', 'America/Santiago', '-3.00', '-4.00', '-4.00', NULL, NULL), (121, 'CL', 'Pacific/Easter', '-5.00', '-6.00', '-6.00', NULL, NULL), (122, 'CM', 'Africa/Douala', '1.00', '1.00', '1.00', NULL, NULL), (123, 'CN', 'Asia/Chongqing', '8.00', '8.00', '8.00', NULL, NULL), (124, 'CN', 'Asia/Harbin', '8.00', '8.00', '8.00', NULL, NULL), (125, 'CN', 'Asia/Kashgar', '8.00', '8.00', '8.00', NULL, NULL), (126, 'CN', 'Asia/Shanghai', '8.00', '8.00', '8.00', NULL, NULL), (127, 'CN', 'Asia/Urumqi', '8.00', '8.00', '8.00', NULL, NULL), (128, 'CO', 'America/Bogota', '-5.00', '-5.00', '-5.00', NULL, NULL), (129, 'CR', 'America/Costa_Rica', '-6.00', '-6.00', '-6.00', NULL, NULL), (130, 'CU', 'America/Havana', '-5.00', '-4.00', '-5.00', NULL, NULL), (131, 'CV', 'Atlantic/Cape_Verde', '-1.00', '-1.00', '-1.00', NULL, NULL), (132, 'CW', 'America/Curacao', '-4.00', '-4.00', '-4.00', NULL, NULL), (133, 'CX', 'Indian/Christmas', '7.00', '7.00', '7.00', NULL, NULL), (134, 'CY', 'Asia/Nicosia', '2.00', '3.00', '2.00', NULL, NULL), (135, 'CZ', 'Europe/Prague', '1.00', '2.00', '1.00', NULL, NULL), (136, 'DE', 'Europe/Berlin', '1.00', '2.00', '1.00', NULL, NULL), (137, 'DE', 'Europe/Busingen', '1.00', '2.00', '1.00', NULL, NULL), (138, 'DJ', 'Africa/Djibouti', '3.00', '3.00', '3.00', NULL, NULL), (139, 'DK', 'Europe/Copenhagen', '1.00', '2.00', '1.00', NULL, NULL), (140, 'DM', 'America/Dominica', '-4.00', '-4.00', '-4.00', NULL, NULL), (141, 'DO', 'America/Santo_Domingo', '-4.00', '-4.00', '-4.00', NULL, NULL), (142, 'DZ', 'Africa/Algiers', '1.00', '1.00', '1.00', NULL, NULL), (143, 'EC', 'America/Guayaquil', '-5.00', '-5.00', '-5.00', NULL, NULL), (144, 'EC', 'Pacific/Galapagos', '-6.00', '-6.00', '-6.00', NULL, NULL), (145, 'EE', 'Europe/Tallinn', '2.00', '3.00', '2.00', NULL, NULL), (146, 'EG', 'Africa/Cairo', '2.00', '2.00', '2.00', NULL, NULL), (147, 'EH', 'Africa/El_Aaiun', '0.00', '0.00', '0.00', NULL, NULL), (148, 'ER', 'Africa/Asmara', '3.00', '3.00', '3.00', NULL, NULL), (149, 'ES', 'Africa/Ceuta', '1.00', '2.00', '1.00', NULL, NULL), (150, 'ES', 'Atlantic/Canary', '0.00', '1.00', '0.00', NULL, NULL), (151, 'ES', 'Europe/Madrid', '1.00', '2.00', '1.00', NULL, NULL), (152, 'ET', 'Africa/Addis_Ababa', '3.00', '3.00', '3.00', NULL, NULL), (153, 'FI', 'Europe/Helsinki', '2.00', '3.00', '2.00', NULL, NULL), (154, 'FJ', 'Pacific/Fiji', '13.00', '12.00', '12.00', NULL, NULL), (155, 'FK', 'Atlantic/Stanley', '-3.00', '-3.00', '-3.00', NULL, NULL), (156, 'FM', 'Pacific/Chuuk', '10.00', '10.00', '10.00', NULL, NULL), (157, 'FM', 'Pacific/Kosrae', '11.00', '11.00', '11.00', NULL, NULL), (158, 'FM', 'Pacific/Pohnpei', '11.00', '11.00', '11.00', NULL, NULL), (159, 'FO', 'Atlantic/Faroe', '0.00', '1.00', '0.00', NULL, NULL), (160, 'FR', 'Europe/Paris', '1.00', '2.00', '1.00', NULL, NULL), (161, 'GA', 'Africa/Libreville', '1.00', '1.00', '1.00', NULL, NULL), (162, 'GB', 'Europe/London', '0.00', '1.00', '0.00', NULL, NULL), (163, 'GD', 'America/Grenada', '-4.00', '-4.00', '-4.00', NULL, NULL), (164, 'GE', 'Asia/Tbilisi', '4.00', '4.00', '4.00', NULL, NULL), (165, 'GF', 'America/Cayenne', '-3.00', '-3.00', '-3.00', NULL, NULL), (166, 'GG', 'Europe/Guernsey', '0.00', '1.00', '0.00', NULL, NULL), (167, 'GH', 'Africa/Accra', '0.00', '0.00', '0.00', NULL, NULL), (168, 'GI', 'Europe/Gibraltar', '1.00', '2.00', '1.00', NULL, NULL), (169, 'GL', 'America/Danmarkshavn', '0.00', '0.00', '0.00', NULL, NULL), (170, 'GL', 'America/Godthab', '-3.00', '-2.00', '-3.00', NULL, NULL), (171, 'GL', 'America/Scoresbysund', '-1.00', '0.00', '-1.00', NULL, NULL), (172, 'GL', 'America/Thule', '-4.00', '-3.00', '-4.00', NULL, NULL), (173, 'GM', 'Africa/Banjul', '0.00', '0.00', '0.00', NULL, NULL), (174, 'GN', 'Africa/Conakry', '0.00', '0.00', '0.00', NULL, NULL), (175, 'GP', 'America/Guadeloupe', '-4.00', '-4.00', '-4.00', NULL, NULL), (176, 'GQ', 'Africa/Malabo', '1.00', '1.00', '1.00', NULL, NULL), (177, 'GR', 'Europe/Athens', '2.00', '3.00', '2.00', NULL, NULL), (178, 'GS', 'Atlantic/South_Georgia', '-2.00', '-2.00', '-2.00', NULL, NULL), (179, 'GT', 'America/Guatemala', '-6.00', '-6.00', '-6.00', NULL, NULL), (180, 'GU', 'Pacific/Guam', '10.00', '10.00', '10.00', NULL, NULL), (181, 'GW', 'Africa/Bissau', '0.00', '0.00', '0.00', NULL, NULL), (182, 'GY', 'America/Guyana', '-4.00', '-4.00', '-4.00', NULL, NULL), (183, 'HK', 'Asia/Hong_Kong', '8.00', '8.00', '8.00', NULL, NULL), (184, 'HN', 'America/Tegucigalpa', '-6.00', '-6.00', '-6.00', NULL, NULL), (185, 'HR', 'Europe/Zagreb', '1.00', '2.00', '1.00', NULL, NULL), (186, 'HT', 'America/Port-au-Prince', '-5.00', '-4.00', '-5.00', NULL, NULL), (187, 'HU', 'Europe/Budapest', '1.00', '2.00', '1.00', NULL, NULL), (188, 'ID', 'Asia/Jakarta', '7.00', '7.00', '7.00', NULL, NULL), (189, 'ID', 'Asia/Jayapura', '9.00', '9.00', '9.00', NULL, NULL), (190, 'ID', 'Asia/Makassar', '8.00', '8.00', '8.00', NULL, NULL), (191, 'ID', 'Asia/Pontianak', '7.00', '7.00', '7.00', NULL, NULL), (192, 'IE', 'Europe/Dublin', '0.00', '1.00', '0.00', NULL, NULL), (193, 'IL', 'Asia/Jerusalem', '2.00', '3.00', '2.00', NULL, NULL), (194, 'IM', 'Europe/Isle_of_Man', '0.00', '1.00', '0.00', NULL, NULL), (195, 'IN', 'Asia/Kolkata', '5.50', '5.50', '5.50', NULL, NULL), (196, 'IO', 'Indian/Chagos', '6.00', '6.00', '6.00', NULL, NULL), (197, 'IQ', 'Asia/Baghdad', '3.00', '3.00', '3.00', NULL, NULL), (198, 'IR', 'Asia/Tehran', '3.50', '4.50', '3.50', NULL, NULL), (199, 'IS', 'Atlantic/Reykjavik', '0.00', '0.00', '0.00', NULL, NULL), (200, 'IT', 'Europe/Rome', '1.00', '2.00', '1.00', NULL, NULL), (201, 'JE', 'Europe/Jersey', '0.00', '1.00', '0.00', NULL, NULL), (202, 'JM', 'America/Jamaica', '-5.00', '-5.00', '-5.00', NULL, NULL), (203, 'JO', 'Asia/Amman', '2.00', '3.00', '2.00', NULL, NULL), (204, 'JP', 'Asia/Tokyo', '9.00', '9.00', '9.00', NULL, NULL), (205, 'KE', 'Africa/Nairobi', '3.00', '3.00', '3.00', NULL, NULL), (206, 'KG', 'Asia/Bishkek', '6.00', '6.00', '6.00', NULL, NULL), (207, 'KH', 'Asia/Phnom_Penh', '7.00', '7.00', '7.00', NULL, NULL), (208, 'KI', 'Pacific/Enderbury', '13.00', '13.00', '13.00', NULL, NULL), (209, 'KI', 'Pacific/Kiritimati', '14.00', '14.00', '14.00', NULL, NULL), (210, 'KI', 'Pacific/Tarawa', '12.00', '12.00', '12.00', NULL, NULL), (211, 'KM', 'Indian/Comoro', '3.00', '3.00', '3.00', NULL, NULL), (212, 'KN', 'America/St_Kitts', '-4.00', '-4.00', '-4.00', NULL, NULL), (213, 'KP', 'Asia/Pyongyang', '9.00', '9.00', '9.00', NULL, NULL), (214, 'KR', 'Asia/Seoul', '9.00', '9.00', '9.00', NULL, NULL), (215, 'KW', 'Asia/Kuwait', '3.00', '3.00', '3.00', NULL, NULL), (216, 'KY', 'America/Cayman', '-5.00', '-5.00', '-5.00', NULL, NULL), (217, 'KZ', 'Asia/Almaty', '6.00', '6.00', '6.00', NULL, NULL), (218, 'KZ', 'Asia/Aqtau', '5.00', '5.00', '5.00', NULL, NULL), (219, 'KZ', 'Asia/Aqtobe', '5.00', '5.00', '5.00', NULL, NULL), (220, 'KZ', 'Asia/Oral', '5.00', '5.00', '5.00', NULL, NULL), (221, 'KZ', 'Asia/Qyzylorda', '6.00', '6.00', '6.00', NULL, NULL), (222, 'LA', 'Asia/Vientiane', '7.00', '7.00', '7.00', NULL, NULL), (223, 'LB', 'Asia/Beirut', '2.00', '3.00', '2.00', NULL, NULL), (224, 'LC', 'America/St_Lucia', '-4.00', '-4.00', '-4.00', NULL, NULL), (225, 'LI', 'Europe/Vaduz', '1.00', '2.00', '1.00', NULL, NULL), (226, 'LK', 'Asia/Colombo', '5.50', '5.50', '5.50', NULL, NULL), (227, 'LR', 'Africa/Monrovia', '0.00', '0.00', '0.00', NULL, NULL), (228, 'LS', 'Africa/Maseru', '2.00', '2.00', '2.00', NULL, NULL), (229, 'LT', 'Europe/Vilnius', '2.00', '3.00', '2.00', NULL, NULL), (230, 'LU', 'Europe/Luxembourg', '1.00', '2.00', '1.00', NULL, NULL), (231, 'LV', 'Europe/Riga', '2.00', '3.00', '2.00', NULL, NULL), (232, 'LY', 'Africa/Tripoli', '2.00', '2.00', '2.00', NULL, NULL), (233, 'MA', 'Africa/Casablanca', '0.00', '0.00', '0.00', NULL, NULL), (234, 'MC', 'Europe/Monaco', '1.00', '2.00', '1.00', NULL, NULL), (235, 'MD', 'Europe/Chisinau', '2.00', '3.00', '2.00', NULL, NULL), (236, 'ME', 'Europe/Podgorica', '1.00', '2.00', '1.00', NULL, NULL), (237, 'MF', 'America/Marigot', '-4.00', '-4.00', '-4.00', NULL, NULL), (238, 'MG', 'Indian/Antananarivo', '3.00', '3.00', '3.00', NULL, NULL), (239, 'MH', 'Pacific/Kwajalein', '12.00', '12.00', '12.00', NULL, NULL), (240, 'MH', 'Pacific/Majuro', '12.00', '12.00', '12.00', NULL, NULL), (241, 'MK', 'Europe/Skopje', '1.00', '2.00', '1.00', NULL, NULL), (242, 'ML', 'Africa/Bamako', '0.00', '0.00', '0.00', NULL, NULL), (243, 'MM', 'Asia/Rangoon', '6.50', '6.50', '6.50', NULL, NULL), (244, 'MN', 'Asia/Choibalsan', '8.00', '8.00', '8.00', NULL, NULL), (245, 'MN', 'Asia/Hovd', '7.00', '7.00', '7.00', NULL, NULL), (246, 'MN', 'Asia/Ulaanbaatar', '8.00', '8.00', '8.00', NULL, NULL), (247, 'MO', 'Asia/Macau', '8.00', '8.00', '8.00', NULL, NULL), (248, 'MP', 'Pacific/Saipan', '10.00', '10.00', '10.00', NULL, NULL), (249, 'MQ', 'America/Martinique', '-4.00', '-4.00', '-4.00', NULL, NULL), (250, 'MR', 'Africa/Nouakchott', '0.00', '0.00', '0.00', NULL, NULL), (251, 'MS', 'America/Montserrat', '-4.00', '-4.00', '-4.00', NULL, NULL), (252, 'MT', 'Europe/Malta', '1.00', '2.00', '1.00', NULL, NULL), (253, 'MU', 'Indian/Mauritius', '4.00', '4.00', '4.00', NULL, NULL), (254, 'MV', 'Indian/Maldives', '5.00', '5.00', '5.00', NULL, NULL), (255, 'MW', 'Africa/Blantyre', '2.00', '2.00', '2.00', NULL, NULL), (256, 'MX', 'America/Bahia_Banderas', '-6.00', '-5.00', '-6.00', NULL, NULL), (257, 'MX', 'America/Cancun', '-6.00', '-5.00', '-6.00', NULL, NULL), (258, 'MX', 'America/Chihuahua', '-7.00', '-6.00', '-7.00', NULL, NULL), (259, 'MX', 'America/Hermosillo', '-7.00', '-7.00', '-7.00', NULL, NULL), (260, 'MX', 'America/Matamoros', '-6.00', '-5.00', '-6.00', NULL, NULL), (261, 'MX', 'America/Mazatlan', '-7.00', '-6.00', '-7.00', NULL, NULL), (262, 'MX', 'America/Merida', '-6.00', '-5.00', '-6.00', NULL, NULL), (263, 'MX', 'America/Mexico_City', '-6.00', '-5.00', '-6.00', NULL, NULL), (264, 'MX', 'America/Monterrey', '-6.00', '-5.00', '-6.00', NULL, NULL), (265, 'MX', 'America/Ojinaga', '-7.00', '-6.00', '-7.00', NULL, NULL), (266, 'MX', 'America/Santa_Isabel', '-8.00', '-7.00', '-8.00', NULL, NULL), (267, 'MX', 'America/Tijuana', '-8.00', '-7.00', '-8.00', NULL, NULL), (268, 'MY', 'Asia/Kuala_Lumpur', '8.00', '8.00', '8.00', NULL, NULL), (269, 'MY', 'Asia/Kuching', '8.00', '8.00', '8.00', NULL, NULL), (270, 'MZ', 'Africa/Maputo', '2.00', '2.00', '2.00', NULL, NULL), (271, 'NA', 'Africa/Windhoek', '2.00', '1.00', '1.00', NULL, NULL), (272, 'NC', 'Pacific/Noumea', '11.00', '11.00', '11.00', NULL, NULL), (273, 'NE', 'Africa/Niamey', '1.00', '1.00', '1.00', NULL, NULL), (274, 'NF', 'Pacific/Norfolk', '11.50', '11.50', '11.50', NULL, NULL), (275, 'NG', 'Africa/Lagos', '1.00', '1.00', '1.00', NULL, NULL), (276, 'NI', 'America/Managua', '-6.00', '-6.00', '-6.00', NULL, NULL), (277, 'NL', 'Europe/Amsterdam', '1.00', '2.00', '1.00', NULL, NULL), (278, 'NO', 'Europe/Oslo', '1.00', '2.00', '1.00', NULL, NULL), (279, 'NP', 'Asia/Kathmandu', '5.75', '5.75', '5.75', NULL, NULL), (280, 'NR', 'Pacific/Nauru', '12.00', '12.00', '12.00', NULL, NULL), (281, 'NU', 'Pacific/Niue', '-11.00', '-11.00', '-11.00', NULL, NULL), (282, 'NZ', 'Pacific/Auckland', '13.00', '12.00', '12.00', NULL, NULL), (283, 'NZ', 'Pacific/Chatham', '13.75', '12.75', '12.75', NULL, NULL), (284, 'OM', 'Asia/Muscat', '4.00', '4.00', '4.00', NULL, NULL), (285, 'PA', 'America/Panama', '-5.00', '-5.00', '-5.00', NULL, NULL), (286, 'PE', 'America/Lima', '-5.00', '-5.00', '-5.00', NULL, NULL), (287, 'PF', 'Pacific/Gambier', '-9.00', '-9.00', '-9.00', NULL, NULL), (288, 'PF', 'Pacific/Marquesas', '-9.50', '-9.50', '-9.50', NULL, NULL), (289, 'PF', 'Pacific/Tahiti', '-10.00', '-10.00', '-10.00', NULL, NULL), (290, 'PG', 'Pacific/Port_Moresby', '10.00', '10.00', '10.00', NULL, NULL), (291, 'PH', 'Asia/Manila', '8.00', '8.00', '8.00', NULL, NULL), (292, 'PK', 'Asia/Karachi', '5.00', '5.00', '5.00', NULL, NULL), (293, 'PL', 'Europe/Warsaw', '1.00', '2.00', '1.00', NULL, NULL), (294, 'PM', 'America/Miquelon', '-3.00', '-2.00', '-3.00', NULL, NULL), (295, 'PN', 'Pacific/Pitcairn', '-8.00', '-8.00', '-8.00', NULL, NULL), (296, 'PR', 'America/Puerto_Rico', '-4.00', '-4.00', '-4.00', NULL, NULL), (297, 'PS', 'Asia/Gaza', '2.00', '3.00', '2.00', NULL, NULL), (298, 'PS', 'Asia/Hebron', '2.00', '3.00', '2.00', NULL, NULL), (299, 'PT', 'Atlantic/Azores', '-1.00', '0.00', '-1.00', NULL, NULL), (300, 'PT', 'Atlantic/Madeira', '0.00', '1.00', '0.00', NULL, NULL), (301, 'PT', 'Europe/Lisbon', '0.00', '1.00', '0.00', NULL, NULL), (302, 'PW', 'Pacific/Palau', '9.00', '9.00', '9.00', NULL, NULL), (303, 'PY', 'America/Asuncion', '-3.00', '-4.00', '-4.00', NULL, NULL), (304, 'QA', 'Asia/Qatar', '3.00', '3.00', '3.00', NULL, NULL), (305, 'RE', 'Indian/Reunion', '4.00', '4.00', '4.00', NULL, NULL), (306, 'RO', 'Europe/Bucharest', '2.00', '3.00', '2.00', NULL, NULL), (307, 'RS', 'Europe/Belgrade', '1.00', '2.00', '1.00', NULL, NULL), (308, 'RU', 'Asia/Anadyr', '12.00', '12.00', '12.00', NULL, NULL), (309, 'RU', 'Asia/Irkutsk', '9.00', '9.00', '9.00', NULL, NULL), (310, 'RU', 'Asia/Kamchatka', '12.00', '12.00', '12.00', NULL, NULL), (311, 'RU', 'Asia/Khandyga', '10.00', '10.00', '10.00', NULL, NULL), (312, 'RU', 'Asia/Krasnoyarsk', '8.00', '8.00', '8.00', NULL, NULL), (313, 'RU', 'Asia/Magadan', '12.00', '12.00', '12.00', NULL, NULL), (314, 'RU', 'Asia/Novokuznetsk', '7.00', '7.00', '7.00', NULL, NULL), (315, 'RU', 'Asia/Novosibirsk', '7.00', '7.00', '7.00', NULL, NULL), (316, 'RU', 'Asia/Omsk', '7.00', '7.00', '7.00', NULL, NULL), (317, 'RU', 'Asia/Sakhalin', '11.00', '11.00', '11.00', NULL, NULL), (318, 'RU', 'Asia/Ust-Nera', '11.00', '11.00', '11.00', NULL, NULL), (319, 'RU', 'Asia/Vladivostok', '11.00', '11.00', '11.00', NULL, NULL), (320, 'RU', 'Asia/Yakutsk', '10.00', '10.00', '10.00', NULL, NULL), (321, 'RU', 'Asia/Yekaterinburg', '6.00', '6.00', '6.00', NULL, NULL), (322, 'RU', 'Europe/Kaliningrad', '3.00', '3.00', '3.00', NULL, NULL), (323, 'RU', 'Europe/Moscow', '4.00', '4.00', '4.00', NULL, NULL), (324, 'RU', 'Europe/Samara', '4.00', '4.00', '4.00', NULL, NULL), (325, 'RU', 'Europe/Volgograd', '4.00', '4.00', '4.00', NULL, NULL), (326, 'RW', 'Africa/Kigali', '2.00', '2.00', '2.00', NULL, NULL), (327, 'SA', 'Asia/Riyadh', '3.00', '3.00', '3.00', NULL, NULL), (328, 'SB', 'Pacific/Guadalcanal', '11.00', '11.00', '11.00', NULL, NULL), (329, 'SC', 'Indian/Mahe', '4.00', '4.00', '4.00', NULL, NULL), (330, 'SD', 'Africa/Khartoum', '3.00', '3.00', '3.00', NULL, NULL), (331, 'SE', 'Europe/Stockholm', '1.00', '2.00', '1.00', NULL, NULL), (332, 'SG', 'Asia/Singapore', '8.00', '8.00', '8.00', NULL, NULL), (333, 'SH', 'Atlantic/St_Helena', '0.00', '0.00', '0.00', NULL, NULL), (334, 'SI', 'Europe/Ljubljana', '1.00', '2.00', '1.00', NULL, NULL), (335, 'SJ', 'Arctic/Longyearbyen', '1.00', '2.00', '1.00', NULL, NULL), (336, 'SK', 'Europe/Bratislava', '1.00', '2.00', '1.00', NULL, NULL), (337, 'SL', 'Africa/Freetown', '0.00', '0.00', '0.00', NULL, NULL), (338, 'SM', 'Europe/San_Marino', '1.00', '2.00', '1.00', NULL, NULL), (339, 'SN', 'Africa/Dakar', '0.00', '0.00', '0.00', NULL, NULL), (340, 'SO', 'Africa/Mogadishu', '3.00', '3.00', '3.00', NULL, NULL), (341, 'SR', 'America/Paramaribo', '-3.00', '-3.00', '-3.00', NULL, NULL), (342, 'SS', 'Africa/Juba', '3.00', '3.00', '3.00', NULL, NULL), (343, 'ST', 'Africa/Sao_Tome', '0.00', '0.00', '0.00', NULL, NULL), (344, 'SV', 'America/El_Salvador', '-6.00', '-6.00', '-6.00', NULL, NULL), (345, 'SX', 'America/Lower_Princes', '-4.00', '-4.00', '-4.00', NULL, NULL), (346, 'SY', 'Asia/Damascus', '2.00', '3.00', '2.00', NULL, NULL), (347, 'SZ', 'Africa/Mbabane', '2.00', '2.00', '2.00', NULL, NULL), (348, 'TC', 'America/Grand_Turk', '-5.00', '-4.00', '-5.00', NULL, NULL), (349, 'TD', 'Africa/Ndjamena', '1.00', '1.00', '1.00', NULL, NULL), (350, 'TF', 'Indian/Kerguelen', '5.00', '5.00', '5.00', NULL, NULL), (351, 'TG', 'Africa/Lome', '0.00', '0.00', '0.00', NULL, NULL), (352, 'TH', 'Asia/Bangkok', '7.00', '7.00', '7.00', NULL, NULL), (353, 'TJ', 'Asia/Dushanbe', '5.00', '5.00', '5.00', NULL, NULL), (354, 'TK', 'Pacific/Fakaofo', '13.00', '13.00', '13.00', NULL, NULL), (355, 'TL', 'Asia/Dili', '9.00', '9.00', '9.00', NULL, NULL), (356, 'TM', 'Asia/Ashgabat', '5.00', '5.00', '5.00', NULL, NULL), (357, 'TN', 'Africa/Tunis', '1.00', '1.00', '1.00', NULL, NULL), (358, 'TO', 'Pacific/Tongatapu', '13.00', '13.00', '13.00', NULL, NULL), (359, 'TR', 'Europe/Istanbul', '2.00', '3.00', '2.00', NULL, NULL), (360, 'TT', 'America/Port_of_Spain', '-4.00', '-4.00', '-4.00', NULL, NULL), (361, 'TV', 'Pacific/Funafuti', '12.00', '12.00', '12.00', NULL, NULL), (362, 'TW', 'Asia/Taipei', '8.00', '8.00', '8.00', NULL, NULL), (363, 'TZ', 'Africa/Dar_es_Salaam', '3.00', '3.00', '3.00', NULL, NULL), (364, 'UA', 'Europe/Kiev', '2.00', '3.00', '2.00', NULL, NULL), (365, 'UA', 'Europe/Simferopol', '2.00', '4.00', '4.00', NULL, NULL), (366, 'UA', 'Europe/Uzhgorod', '2.00', '3.00', '2.00', NULL, NULL), (367, 'UA', 'Europe/Zaporozhye', '2.00', '3.00', '2.00', NULL, NULL), (368, 'UG', 'Africa/Kampala', '3.00', '3.00', '3.00', NULL, NULL), (369, 'UM', 'Pacific/Johnston', '-10.00', '-10.00', '-10.00', NULL, NULL), (370, 'UM', 'Pacific/Midway', '-11.00', '-11.00', '-11.00', NULL, NULL), (371, 'UM', 'Pacific/Wake', '12.00', '12.00', '12.00', NULL, NULL), (372, 'US', 'America/Adak', '-10.00', '-9.00', '-10.00', NULL, NULL), (373, 'US', 'America/Anchorage', '-9.00', '-8.00', '-9.00', NULL, NULL), (374, 'US', 'America/Boise', '-7.00', '-6.00', '-7.00', NULL, NULL), (375, 'US', 'America/Chicago', '-6.00', '-5.00', '-6.00', NULL, NULL), (376, 'US', 'America/Denver', '-7.00', '-6.00', '-7.00', NULL, NULL), (377, 'US', 'America/Detroit', '-5.00', '-4.00', '-5.00', NULL, NULL), (378, 'US', 'America/Indiana/Indianapolis', '-5.00', '-4.00', '-5.00', NULL, NULL), (379, 'US', 'America/Indiana/Knox', '-6.00', '-5.00', '-6.00', NULL, NULL), (380, 'US', 'America/Indiana/Marengo', '-5.00', '-4.00', '-5.00', NULL, NULL), (381, 'US', 'America/Indiana/Petersburg', '-5.00', '-4.00', '-5.00', NULL, NULL), (382, 'US', 'America/Indiana/Tell_City', '-6.00', '-5.00', '-6.00', NULL, NULL), (383, 'US', 'America/Indiana/Vevay', '-5.00', '-4.00', '-5.00', NULL, NULL), (384, 'US', 'America/Indiana/Vincennes', '-5.00', '-4.00', '-5.00', NULL, NULL), (385, 'US', 'America/Indiana/Winamac', '-5.00', '-4.00', '-5.00', NULL, NULL), (386, 'US', 'America/Juneau', '-9.00', '-8.00', '-9.00', NULL, NULL), (387, 'US', 'America/Kentucky/Louisville', '-5.00', '-4.00', '-5.00', NULL, NULL), (388, 'US', 'America/Kentucky/Monticello', '-5.00', '-4.00', '-5.00', NULL, NULL), (389, 'US', 'America/Los_Angeles', '-8.00', '-7.00', '-8.00', NULL, NULL), (390, 'US', 'America/Menominee', '-6.00', '-5.00', '-6.00', NULL, NULL), (391, 'US', 'America/Metlakatla', '-8.00', '-8.00', '-8.00', NULL, NULL), (392, 'US', 'America/New_York', '-5.00', '-4.00', '-5.00', NULL, NULL), (393, 'US', 'America/Nome', '-9.00', '-8.00', '-9.00', NULL, NULL), (394, 'US', 'America/North_Dakota/Beulah', '-6.00', '-5.00', '-6.00', NULL, NULL), (395, 'US', 'America/North_Dakota/Center', '-6.00', '-5.00', '-6.00', NULL, NULL), (396, 'US', 'America/North_Dakota/New_Salem', '-6.00', '-5.00', '-6.00', NULL, NULL), (397, 'US', 'America/Phoenix', '-7.00', '-7.00', '-7.00', NULL, NULL), (398, 'US', 'America/Shiprock', '-7.00', '-6.00', '-7.00', NULL, NULL), (399, 'US', 'America/Sitka', '-9.00', '-8.00', '-9.00', NULL, NULL), (400, 'US', 'America/Yakutat', '-9.00', '-8.00', '-9.00', NULL, NULL), (401, 'US', 'Pacific/Honolulu', '-10.00', '-10.00', '-10.00', NULL, NULL), (402, 'UY', 'America/Montevideo', '-2.00', '-3.00', '-3.00', NULL, NULL), (403, 'UZ', 'Asia/Samarkand', '5.00', '5.00', '5.00', NULL, NULL), (404, 'UZ', 'Asia/Tashkent', '5.00', '5.00', '5.00', NULL, NULL), (405, 'VA', 'Europe/Vatican', '1.00', '2.00', '1.00', NULL, NULL), (406, 'VC', 'America/St_Vincent', '-4.00', '-4.00', '-4.00', NULL, NULL), (407, 'VE', 'America/Caracas', '-4.50', '-4.50', '-4.50', NULL, NULL), (408, 'VG', 'America/Tortola', '-4.00', '-4.00', '-4.00', NULL, NULL), (409, 'VI', 'America/St_Thomas', '-4.00', '-4.00', '-4.00', NULL, NULL), (410, 'VN', 'Asia/Ho_Chi_Minh', '7.00', '7.00', '7.00', NULL, NULL), (411, 'VU', 'Pacific/Efate', '11.00', '11.00', '11.00', NULL, NULL), (412, 'WF', 'Pacific/Wallis', '12.00', '12.00', '12.00', NULL, NULL), (413, 'WS', 'Pacific/Apia', '14.00', '13.00', '13.00', NULL, NULL), (414, 'YE', 'Asia/Aden', '3.00', '3.00', '3.00', NULL, NULL), (415, 'YT', 'Indian/Mayotte', '3.00', '3.00', '3.00', NULL, NULL), (416, 'ZA', 'Africa/Johannesburg', '2.00', '2.00', '2.00', NULL, NULL), (417, 'ZM', 'Africa/Lusaka', '2.00', '2.00', '2.00', NULL, NULL), (418, 'ZW', 'Africa/Harare', '2.00', '2.00', '2.00', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `tv_shows` -- CREATE TABLE `tv_shows` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text DEFAULT NULL, `thumbnail` text DEFAULT NULL, `poster` text DEFAULT NULL, `slug` varchar(191) DEFAULT NULL, `seo_title` varchar(191) DEFAULT NULL, `description` longtext DEFAULT NULL, `stars` text DEFAULT NULL, `director` text DEFAULT NULL, `writer` text DEFAULT NULL, `rating` varchar(5) DEFAULT '0', `release` varchar(25) DEFAULT NULL, `country` varchar(191) DEFAULT NULL, `genre` varchar(191) DEFAULT NULL, `language` varchar(191) DEFAULT NULL, `video_type` varchar(50) DEFAULT NULL, `runtime` varchar(10) DEFAULT NULL, `video_quality` varchar(191) DEFAULT 'HD', `is_original` tinyint(4) NOT NULL DEFAULT 0, `is_featured` tinyint(4) NOT NULL DEFAULT 0, `is_blockbuster` tinyint(4) NOT NULL DEFAULT 0, `is_recommended` tinyint(4) NOT NULL DEFAULT 0, `is_real_life_story` tinyint(4) NOT NULL DEFAULT 0, `status` tinyint(4) NOT NULL DEFAULT 1, `trailer` tinyint(4) DEFAULT 0, `trailler_youtube_source` mediumtext DEFAULT NULL, `enable_download` tinyint(4) DEFAULT 1, `focus_keyword` mediumtext DEFAULT NULL, `meta_description` mediumtext DEFAULT NULL, `tags` mediumtext DEFAULT NULL, `imdb_rating` varchar(5) DEFAULT NULL, `is_tvseries` tinyint(4) NOT NULL DEFAULT 0, `is_popular` tinyint(4) DEFAULT 0, `total_rating` int(11) DEFAULT 1, `is_free` int(11) NOT NULL DEFAULT 0, `is_rental` int(11) NOT NULL DEFAULT 0, `rental_price` int(11) DEFAULT NULL, `rental_duration` int(11) DEFAULT NULL, `rental_type` varchar(191) DEFAULT NULL, `today_view` int(10) UNSIGNED NOT NULL DEFAULT 0, `weekly_view` int(10) UNSIGNED NOT NULL DEFAULT 0, `monthly_view` mediumint(8) UNSIGNED NOT NULL DEFAULT 0, `total_view` bigint(20) UNSIGNED NOT NULL DEFAULT 1, `last_view_reset` timestamp NULL DEFAULT '2025-04-04 00:00:00', `last_ep_added` timestamp NULL DEFAULT '2025-04-04 00:00:00', `imdbid` varchar(191) DEFAULT NULL, `tmdb_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tv_shows` -- INSERT INTO `tv_shows` (`id`, `title`, `thumbnail`, `poster`, `slug`, `seo_title`, `description`, `stars`, `director`, `writer`, `rating`, `release`, `country`, `genre`, `language`, `video_type`, `runtime`, `video_quality`, `is_original`, `is_featured`, `is_blockbuster`, `is_recommended`, `is_real_life_story`, `status`, `trailer`, `trailler_youtube_source`, `enable_download`, `focus_keyword`, `meta_description`, `tags`, `imdb_rating`, `is_tvseries`, `is_popular`, `total_rating`, `is_free`, `is_rental`, `rental_price`, `rental_duration`, `rental_type`, `today_view`, `weekly_view`, `monthly_view`, `total_view`, `last_view_reset`, `last_ep_added`, `imdbid`, `tmdb_id`, `created_at`, `updated_at`) VALUES (1, 'Wednesday', '{\"original_image\":\"https:\\/\\/placehold.co\\/500x750\"}', '{\"original_image\":\"https:\\/\\/placehold.co\\/1920x1080\"}', 'wednesday', 'Wednesday', 'Smart, sarcastic and a little dead inside, Wednesday Addams investigates twisted mysteries while making new friends — and foes — at Nevermore Academy.', '[\"1\",\"2\",\"3\",\"4\"]', '[\"3\"]', '[\"4\"]', NULL, '2022-11-23', '[\"194\"]', '[\"1\",\"2\",\"4\"]', '[\"2\"]', '1', NULL, '1', 1, 1, 0, 1, 0, 1, 0, NULL, 1, '', 'Smart, sarcastic and a little dead inside, Wednesday Addams investigates twisted mysteries while making new friends — and foes — at Nevermore Academy.', '', '8.408', 1, 0, 1, 1, 0, NULL, NULL, NULL, 0, 0, 0, 1, '2025-04-03 18:00:00', '2025-04-03 18:00:00', '119051', 119051, '2025-08-11 08:47:57', '2025-08-11 08:47:57'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `email` varchar(191) NOT NULL, `password` varchar(191) NOT NULL, `username` varchar(191) DEFAULT NULL, `first_name` varchar(191) DEFAULT NULL, `last_name` varchar(191) DEFAULT NULL, `phone` varchar(191) DEFAULT NULL, `image` text DEFAULT NULL, `date_of_birth` varchar(191) DEFAULT NULL, `user_type` enum('admin','user','staff') NOT NULL DEFAULT 'user', `gender` tinyint(4) DEFAULT 1 COMMENT '1 Male, 2 Female, Rather not say 0', `token` mediumtext DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `theme` varchar(50) DEFAULT 'default', `theme_color` varchar(50) DEFAULT '#16163F', `join_date` datetime DEFAULT NULL, `deactivate_reason` mediumtext DEFAULT NULL, `firebase_auth_uid` varchar(191) DEFAULT NULL, `permissions` text DEFAULT NULL, `interests` text DEFAULT NULL, `last_login` timestamp NULL DEFAULT NULL, `is_user_banned` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 unban, 1 ban', `is_password_set` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 for social login', `socials` longtext DEFAULT NULL COMMENT 'it will be array data', `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 inactive, 1 active', `role_id` int(10) UNSIGNED DEFAULT NULL, `client_id` int(10) UNSIGNED DEFAULT NULL, `subscription_id` int(10) UNSIGNED DEFAULT NULL, `remember_token` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `email`, `password`, `username`, `first_name`, `last_name`, `phone`, `image`, `date_of_birth`, `user_type`, `gender`, `token`, `expires_at`, `theme`, `theme_color`, `join_date`, `deactivate_reason`, `firebase_auth_uid`, `permissions`, `interests`, `last_login`, `is_user_banned`, `is_password_set`, `socials`, `status`, `role_id`, `client_id`, `subscription_id`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'admin@spagreen.net', '$2y$12$7QJFGOvqzljtrt8IOP2aVedzqXPQgnLLUYSfY.YYHOdHlhxWpULkm', NULL, 'Admin', 'Flixoo', '01726184147', NULL, NULL, 'admin', 1, NULL, NULL, 'default', '#16163F', NULL, NULL, NULL, '[\"admin.dashboard\",\"email.server-configuration\",\"email.server-configuration.update\",\"email.test\",\"email.template\",\"email.template.update\",\"admin.movies\",\"admin.movie.add\",\"admin.movie.store\",\"admin.movie.delete\",\"admin.movie.edit\",\"admin.movie.update\",\"admin.movie.upload.downloads\",\"admin.movie.file.add\",\"admin.movie.file.store\",\"admin.movie.file.delete\",\"admin.movie.file.edit\",\"admin.movie.file.update\",\"admin.make.rental\",\"admin.make.rent.store\",\"admin.download.links\",\"admin.download.link.add\",\"admin.download_link.store\",\"admin.download_link.edit\",\"admin.download_link.update\",\"admin.download_link.delete\",\"admin.download_link.status\",\"admin.categories\",\"admin.category.add\",\"admin.category.store\",\"admin.category.delete\",\"admin.category.edit\",\"admin.category.update\",\"admin.category.primary.status\",\"admin.category.footer.status\",\"admin.tv.shows\",\"admin.tv.show.add\",\"admin.tv.show.store\",\"admin.tv.show.delete\",\"admin.tv.show.edit\",\"admin.tv.show.update\",\"admin.tv.show.settings\",\"admin.tv.show.config\",\"admin.live.tv.categories\",\"admin.live.tv.category.add\",\"admin.live.tv.category.store\",\"admin.live.tv.category.delete\",\"admin.live.tv.category.edit\",\"admin.live.tv.category.update\",\"admin.live.tv.category.status\",\"admin.live.tvs\",\"admin.live.tv.add\",\"admin.live.tv.store\",\"admin.live.tv.delete\",\"admin.live.tv.edit\",\"admin.live.tv.update\",\"admin.live.tv.status\",\"admin.live.tv.feature\",\"admin.seasons\",\"admin.season.add\",\"admin.season.store\",\"admin.season.delete\",\"admin.season.edit\",\"admin.season.update\",\"admin.episodes\",\"admin.episode.add\",\"admin.episode.store\",\"admin.episode.delete\",\"admin.episode.edit\",\"admin.episode.update\",\"admin.stars\",\"admin.star.add\",\"admin.star.store\",\"admin.star.delete\",\"admin.star.edit\",\"admin.star.update\",\"admin.star.status\",\"admin.movie_industries\",\"admin.movie_industry.add\",\"admin.movie_industry.store\",\"admin.movie_industry.delete\",\"admin.movie_industry.edit\",\"admin.movie_industry.update\",\"admin.movie_industry.status\",\"admin.languages\",\"admin.language.add\",\"admin.language.store\",\"admin.language.delete\",\"admin.language.edit\",\"admin.language.update\",\"admin.language.status\",\"admin.language.translations.page\",\"admin.language.key.update\",\"admin.countries\",\"admin.country.add\",\"admin.country.store\",\"admin.country.delete\",\"admin.country.edit\",\"admin.country.update\",\"admin.country.status\",\"admin.staffs\",\"admin.staff.add\",\"admin.staff.store\",\"admin.staff.delete\",\"admin.staff.edit\",\"admin.staff.update\",\"admin.staff.status\",\"roles.index\",\"roles.create\",\"roles.edit\",\"roles.update\",\"roles.destroy\",\"admin.subscribers\",\"admin.subscriber.add\",\"admin.subscriber.store\",\"admin.subscriber.delete\",\"admin.subscriber.edit\",\"admin.subscriber.update\",\"admin.subscriber.status\",\"admin.packages\",\"admin.package.add\",\"admin.package.store\",\"admin.package.delete\",\"admin.package.edit\",\"admin.package.update\",\"admin.package.status\",\"admin.video.qualities\",\"admin.video.quality.add\",\"admin.video.quality.store\",\"admin.video.quality.delete\",\"admin.video.quality.edit\",\"admin.video.quality.update\",\"admin.video.quality.status\",\"admin.importer\",\"admin.fetch.movies\",\"admin.import.db\",\"admin.interest\",\"admin.interest.add\",\"admin.interest.store\",\"admin.interest.delete\",\"admin.interest.edit\",\"admin.interest.update\",\"admin.interest.status\",\"admin.system.settings\",\"admin.settings\",\"admin.tmdb.settings\",\"admin.social.settings\",\"admin.recaptcha.settings\",\"admin.setting.update\",\"setting.status.change\",\"admin.sms-gateway-settings\",\"admin.blog.categories\",\"admin.blog.category.add\",\"admin.blog.category.store\",\"admin.blog.category.delete\",\"admin.blog.category.edit\",\"admin.blog.category.update\",\"admin.blog.category.status\",\"admin.blogs\",\"admin.blog.add\",\"admin.blog.store\",\"admin.blog.delete\",\"admin.blog.edit\",\"admin.blog.update\",\"admin.blog.status\",\"admin.faqs\",\"admin.faq.add\",\"admin.faq.store\",\"admin.faq.delete\",\"admin.faq.edit\",\"admin.faq.update\",\"admin.faq.status\",\"pages.index\",\"pages.create\",\"pages.store\",\"pages.edit\",\"pages.update\",\"page.delete\",\"page.status.change\",\"admin.ads\",\"admin.ads.delete\",\"admin.ads.edit\",\"admin.ads.update\",\"admin.ads.status\",\"admin.ads.pre_roll.index\",\"admin.ads.pre_roll.add\",\"admin.ads.pre_roll.edit\",\"admin.ads.pre_roll.update\",\"admin.ads.pre_roll.store\",\"admin.ads.mid_roll.index\",\"admin.ads.mid_roll.add\",\"admin.ads.mid_roll.edit\",\"admin.ads.mid_roll.update\",\"admin.ads.mid_roll.store\",\"admin.ads.post_roll.index\",\"admin.ads.post_roll.add\",\"admin.ads.post_roll.edit\",\"admin.ads.post_roll.update\",\"admin.ads.post_roll.store\",\"admin.manage.profile\",\"admin.update.profile\",\"admin.change.password\",\"admin.password.update\",\"payment.gateways\",\"payment.gateway\",\"all.subscription\",\"transaction.log\",\"rental.history\",\"subscribe-list.status\",\"admin.add.subscription\",\"create.subscription\",\"rent-list.status\",\"stop.recurring\",\"admin.theme.options\",\"admin.theme.options.post\",\"website.seo\",\"server.info\",\"system.info\",\"extension.library\",\"file.system.permission\",\"system.update\",\"download.system.update\",\"footer.content\",\"footer.primary-content\",\"footer.primary-content\",\"footer.payment-banner-settings\",\"footer.copyright\",\"footer.update-setting\",\"footer.update-menu\",\"footer.social-link\",\"footer.app_links\",\"footer.legal_pages_link_setting\",\"footer.help_center_link_setting\",\"admin.movie_requests\",\"admin.movie_request.delete\",\"admin.movie_request.update\",\"admin.reports\",\"admin.report.delete\",\"admin.report.update\",\"admin.system.languages\",\"admin.system.language.add\",\"admin.system.language.store\",\"admin.system.language.edit\",\"admin.system.language.update\",\"admin.system.language.destroy\",\"admin.language.translations.page\",\"admin.language.key.update\",\"admin.language.translations.delete\",\"admin.language.missing-keys\",\"admin.language.scan\",\"system-language-status\",\"admin.genres\",\"admin.genre.add\",\"admin.genre.store\",\"admin.genre.delete\",\"admin.genre.edit\",\"admin.genre.update\",\"admin.genre.status\",\"admin.genre.featured\",\"admin.reviews\",\"admin.review.details\",\"admin.review.reply.view\",\"admin.review.reply\",\"admin.review.delete\",\"admin.customer_queries.index\",\"admin.customer_queries.delete\",\"admin.customer_queries.reply.view\",\"admin.customer_queries.reply\"]', NULL, NULL, 0, 1, NULL, 1, 1, NULL, NULL, NULL, '2025-09-19 09:57:54', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `video_qualities` -- CREATE TABLE `video_qualities` ( `id` bigint(20) UNSIGNED NOT NULL, `quality` varchar(191) NOT NULL, `description` text DEFAULT NULL, `status` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `video_qualities` -- INSERT INTO `video_qualities` (`id`, `quality`, `description`, `status`, `created_at`, `updated_at`) VALUES (1, 'SD', 'Standard Definition', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (2, 'HD', 'High Definition', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (3, 'Full HD', 'High Definition', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (4, '2K', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (5, 'UHD/4K', 'Ultra High Definition', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'), (6, '8K', '', 1, '2025-09-19 09:57:55', '2025-09-19 09:57:55'); -- -------------------------------------------------------- -- -- Table structure for table `watch_histories` -- CREATE TABLE `watch_histories` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `watchable_type` varchar(191) NOT NULL, `watchable_id` bigint(20) UNSIGNED NOT NULL, `duration` int(11) NOT NULL DEFAULT 0, `watched_seconds` int(11) NOT NULL DEFAULT 0, `watch_count` int(11) NOT NULL DEFAULT 1, `completion_percentage` double NOT NULL DEFAULT 0, `last_watched_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `ads` -- ALTER TABLE `ads` ADD PRIMARY KEY (`id`); -- -- Indexes for table `api_keys` -- ALTER TABLE `api_keys` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blog_categories` -- ALTER TABLE `blog_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `clients` -- ALTER TABLE `clients` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `clients_webhook_verify_token_unique` (`webhook_verify_token`), ADD UNIQUE KEY `clients_api_key_unique` (`api_key`); -- -- Indexes for table `configs` -- ALTER TABLE `configs` ADD PRIMARY KEY (`id`), ADD KEY `configs_lang_index` (`lang`), ADD KEY `configs_title_index` (`title`); -- -- Indexes for table `countries` -- ALTER TABLE `countries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `currencies` -- ALTER TABLE `currencies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer_queries` -- ALTER TABLE `customer_queries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer_query_replies` -- ALTER TABLE `customer_query_replies` ADD PRIMARY KEY (`id`), ADD KEY `customer_query_replies_customer_query_id_foreign` (`customer_query_id`), ADD KEY `customer_query_replies_admin_id_foreign` (`admin_id`); -- -- Indexes for table `download_links` -- ALTER TABLE `download_links` ADD PRIMARY KEY (`id`), ADD KEY `download_links_downloadable_type_downloadable_id_index` (`downloadable_type`,`downloadable_id`); -- -- Indexes for table `email_templates` -- ALTER TABLE `email_templates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `episodes` -- ALTER TABLE `episodes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `favorite_live_tvs` -- ALTER TABLE `favorite_live_tvs` ADD PRIMARY KEY (`user_id`,`live_tv_id`), ADD KEY `favorite_live_tvs_live_tv_id_foreign` (`live_tv_id`); -- -- Indexes for table `favorite_movies` -- ALTER TABLE `favorite_movies` ADD PRIMARY KEY (`user_id`,`movie_id`), ADD KEY `favorite_movies_movie_id_foreign` (`movie_id`); -- -- Indexes for table `favorite_tv_shows` -- ALTER TABLE `favorite_tv_shows` ADD PRIMARY KEY (`user_id`,`tv_show_id`), ADD KEY `favorite_tv_shows_tv_show_id_foreign` (`tv_show_id`); -- -- Indexes for table `flag_icons` -- ALTER TABLE `flag_icons` ADD PRIMARY KEY (`id`); -- -- Indexes for table `genres` -- ALTER TABLE `genres` ADD PRIMARY KEY (`id`); -- -- Indexes for table `interests` -- ALTER TABLE `interests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `languages` -- ALTER TABLE `languages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `languages_locale_unique` (`locale`), ADD KEY `languages_name_index` (`name`); -- -- Indexes for table `live_tvs` -- ALTER TABLE `live_tvs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `live_tv_categories` -- ALTER TABLE `live_tv_categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `live_tv_urls` -- ALTER TABLE `live_tv_urls` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `movies` -- ALTER TABLE `movies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `movie_files` -- ALTER TABLE `movie_files` ADD PRIMARY KEY (`id`); -- -- Indexes for table `movie_industries` -- ALTER TABLE `movie_industries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `movie_languages` -- ALTER TABLE `movie_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `movie_requests` -- ALTER TABLE `movie_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `packages` -- ALTER TABLE `packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `page_languages` -- ALTER TABLE `page_languages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `payment_methods` -- ALTER TABLE `payment_methods` ADD PRIMARY KEY (`id`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `plan_credentials` -- ALTER TABLE `plan_credentials` ADD PRIMARY KEY (`id`); -- -- Indexes for table `play_lists` -- ALTER TABLE `play_lists` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `play_lists_user_id_name_unique` (`user_id`,`name`); -- -- Indexes for table `play_list_movies` -- ALTER TABLE `play_list_movies` ADD PRIMARY KEY (`id`), ADD KEY `play_list_movies_play_list_id_foreign` (`play_list_id`), ADD KEY `play_list_movies_movie_id_foreign` (`movie_id`); -- -- Indexes for table `rental_histories` -- ALTER TABLE `rental_histories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reports` -- ALTER TABLE `reports` ADD PRIMARY KEY (`id`), ADD KEY `reports_user_id_foreign` (`user_id`), ADD KEY `reports_reportable_type_reportable_id_index` (`reportable_type`,`reportable_id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`), ADD KEY `reviews_reviewable_type_reviewable_id_index` (`reviewable_type`,`reviewable_id`), ADD KEY `reviews_user_id_foreign` (`user_id`); -- -- Indexes for table `review_likes` -- ALTER TABLE `review_likes` ADD PRIMARY KEY (`id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `seasons` -- ALTER TABLE `seasons` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `stars` -- ALTER TABLE `stars` ADD PRIMARY KEY (`id`), ADD KEY `stars_country_id_foreign` (`country_id`); -- -- Indexes for table `stripe_sessions` -- ALTER TABLE `stripe_sessions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`), ADD KEY `subscriptions_client_id_foreign` (`client_id`); -- -- Indexes for table `subscription_transaction_logs` -- ALTER TABLE `subscription_transaction_logs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `timezones` -- ALTER TABLE `timezones` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tv_shows` -- ALTER TABLE `tv_shows` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `video_qualities` -- ALTER TABLE `video_qualities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `watch_histories` -- ALTER TABLE `watch_histories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `watch_histories_user_id_watchable_id_watchable_type_unique` (`user_id`,`watchable_id`,`watchable_type`), ADD KEY `watch_histories_watchable_type_watchable_id_index` (`watchable_type`,`watchable_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ads` -- ALTER TABLE `ads` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `api_keys` -- ALTER TABLE `api_keys` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `blog_categories` -- ALTER TABLE `blog_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `clients` -- ALTER TABLE `clients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `configs` -- ALTER TABLE `configs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `countries` -- ALTER TABLE `countries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194; -- -- AUTO_INCREMENT for table `currencies` -- ALTER TABLE `currencies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105; -- -- AUTO_INCREMENT for table `customer_queries` -- ALTER TABLE `customer_queries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `customer_query_replies` -- ALTER TABLE `customer_query_replies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `download_links` -- ALTER TABLE `download_links` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `email_templates` -- ALTER TABLE `email_templates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `episodes` -- ALTER TABLE `episodes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `faqs` -- ALTER TABLE `faqs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `flag_icons` -- ALTER TABLE `flag_icons` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=241; -- -- AUTO_INCREMENT for table `genres` -- ALTER TABLE `genres` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `interests` -- ALTER TABLE `interests` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `languages` -- ALTER TABLE `languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `live_tvs` -- ALTER TABLE `live_tvs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `live_tv_categories` -- ALTER TABLE `live_tv_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `live_tv_urls` -- ALTER TABLE `live_tv_urls` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57; -- -- AUTO_INCREMENT for table `movies` -- ALTER TABLE `movies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `movie_files` -- ALTER TABLE `movie_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie_industries` -- ALTER TABLE `movie_industries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `movie_languages` -- ALTER TABLE `movie_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `movie_requests` -- ALTER TABLE `movie_requests` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `packages` -- ALTER TABLE `packages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `page_languages` -- ALTER TABLE `page_languages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payment_methods` -- ALTER TABLE `payment_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `plan_credentials` -- ALTER TABLE `plan_credentials` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `play_lists` -- ALTER TABLE `play_lists` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `play_list_movies` -- ALTER TABLE `play_list_movies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `rental_histories` -- ALTER TABLE `rental_histories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `reports` -- ALTER TABLE `reports` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `review_likes` -- ALTER TABLE `review_likes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `seasons` -- ALTER TABLE `seasons` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `stars` -- ALTER TABLE `stars` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `stripe_sessions` -- ALTER TABLE `stripe_sessions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `subscription_transaction_logs` -- ALTER TABLE `subscription_transaction_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `timezones` -- ALTER TABLE `timezones` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=419; -- -- AUTO_INCREMENT for table `tv_shows` -- ALTER TABLE `tv_shows` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `video_qualities` -- ALTER TABLE `video_qualities` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `watch_histories` -- ALTER TABLE `watch_histories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `customer_query_replies` -- ALTER TABLE `customer_query_replies` ADD CONSTRAINT `customer_query_replies_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `customer_query_replies_customer_query_id_foreign` FOREIGN KEY (`customer_query_id`) REFERENCES `customer_queries` (`id`) ON DELETE CASCADE; -- -- Constraints for table `favorite_live_tvs` -- ALTER TABLE `favorite_live_tvs` ADD CONSTRAINT `favorite_live_tvs_live_tv_id_foreign` FOREIGN KEY (`live_tv_id`) REFERENCES `live_tvs` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `favorite_live_tvs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `favorite_movies` -- ALTER TABLE `favorite_movies` ADD CONSTRAINT `favorite_movies_movie_id_foreign` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `favorite_movies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `favorite_tv_shows` -- ALTER TABLE `favorite_tv_shows` ADD CONSTRAINT `favorite_tv_shows_tv_show_id_foreign` FOREIGN KEY (`tv_show_id`) REFERENCES `tv_shows` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `favorite_tv_shows_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `play_lists` -- ALTER TABLE `play_lists` ADD CONSTRAINT `play_lists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `play_list_movies` -- ALTER TABLE `play_list_movies` ADD CONSTRAINT `play_list_movies_movie_id_foreign` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `play_list_movies_play_list_id_foreign` FOREIGN KEY (`play_list_id`) REFERENCES `play_lists` (`id`) ON DELETE CASCADE; -- -- Constraints for table `reports` -- ALTER TABLE `reports` ADD CONSTRAINT `reports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `reviews` -- ALTER TABLE `reviews` ADD CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `stars` -- ALTER TABLE `stars` ADD CONSTRAINT `stars_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL; -- -- Constraints for table `subscriptions` -- ALTER TABLE `subscriptions` ADD CONSTRAINT `subscriptions_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `watch_histories` -- ALTER TABLE `watch_histories` ADD CONSTRAINT `watch_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;