PATH:
home
/
lab2454c
/
omvstudio.com
/
db
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Sep 23, 2022 at 02:54 PM -- Server version: 10.4.24-MariaDB -- PHP Version: 8.1.6 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: `mogul` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_menus` -- CREATE TABLE `admin_menus` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `admin_menus` -- INSERT INTO `admin_menus` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'Header Menu', '2022-08-26 12:50:57', '2022-08-26 12:50:57'), (2, 'Pages', '2022-08-26 12:54:00', '2022-08-26 13:01:28'), (3, 'Terms Menu', '2022-08-26 13:01:59', '2022-08-26 13:01:59'); -- -------------------------------------------------------- -- -- Table structure for table `admin_menu_items` -- CREATE TABLE `admin_menu_items` ( `id` bigint(20) UNSIGNED NOT NULL, `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `parent` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `sort` int(11) NOT NULL DEFAULT 0, `class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `menu` bigint(20) UNSIGNED NOT NULL, `depth` 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 `admin_menu_items` -- INSERT INTO `admin_menu_items` (`id`, `label`, `link`, `parent`, `sort`, `class`, `menu`, `depth`, `created_at`, `updated_at`) VALUES (1, 'Movie', 'category-list', 0, 0, NULL, 1, 0, '2022-08-26 12:51:12', '2022-09-05 02:28:33'), (2, 'Contact Us', 'contact-us', 0, 1, NULL, 1, 0, '2022-08-26 12:52:26', '2022-08-26 12:52:42'), (3, 'Home', 'home', 0, 0, NULL, 2, 0, '2022-08-26 12:54:09', '2022-08-26 12:55:11'), (4, 'ABOUT', 'about-us', 0, 1, NULL, 2, 0, '2022-08-26 12:54:31', '2022-08-26 12:55:30'), (5, 'MOVIES', '#', 0, 2, NULL, 2, 0, '2022-08-26 12:54:43', '2022-08-26 12:54:50'), (6, 'FAQS', 'faq', 0, 3, NULL, 2, 0, '2022-08-26 12:54:49', '2022-08-26 12:58:47'), (7, 'Contact Us', 'contact-us', 0, 4, NULL, 2, 0, '2022-08-26 12:54:58', '2022-08-26 12:58:26'), (8, 'PRIVACY POLICY', 'privacy-policy', 0, 0, NULL, 3, 0, '2022-08-26 13:02:15', '2022-08-26 13:02:43'), (9, 'TERMS & CONDITIONS', 'terms-conditions', 0, 1, NULL, 3, 0, '2022-08-26 13:02:28', '2022-08-26 13:04:05'); -- -------------------------------------------------------- -- -- Table structure for table `bank_details` -- CREATE TABLE `bank_details` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `account_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `route_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `account_holder_name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `bank_details` -- INSERT INTO `bank_details` (`id`, `user_id`, `account_no`, `route_no`, `account_holder_name`, `created_at`, `updated_at`) VALUES (1, 13, '42424242424242', '123', 'Sam', '2022-09-23 06:44:51', '2022-09-23 06:44:51'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `watch_now_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `more_info_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_featured` tinyint(4) NOT NULL DEFAULT 0, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '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 `categories` -- INSERT INTO `categories` (`id`, `title`, `slug`, `description`, `cover_image`, `watch_now_link`, `more_info_link`, `is_featured`, `status`, `created_at`, `updated_at`) VALUES (1, 'Biography', 'biography', NULL, '630dc6bc2d01c.jpg', '#', '##', 1, 'active', '2022-08-30 02:43:48', '2022-08-30 02:43:48'), (2, 'Science Fiction', 'science-fiction', NULL, '630dc76c4ca05.jpg', '#', NULL, 1, 'active', '2022-08-30 02:46:44', '2022-08-30 02:46:44'), (3, 'Mystery', 'mystery', NULL, '630dc77f28725.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:47:03', '2022-08-30 02:47:03'), (4, 'Anime', 'anime', NULL, '630dc7924bf7d.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:47:22', '2022-08-30 02:47:22'), (5, 'Documentaries', 'documentaries', NULL, '630dc7a828257.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:47:44', '2022-08-30 02:47:44'), (6, 'Children & Family', 'children-family', NULL, '630dc7bfb0043.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:48:07', '2022-08-30 02:48:07'), (7, 'Fantasy', 'fantasy', NULL, '630dc7d42915a.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:48:28', '2022-08-30 02:48:28'), (8, 'Thriller', 'thriller', NULL, '630dc7ee98df5.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:48:54', '2022-08-30 02:48:54'), (9, 'Dramas', 'dramas', NULL, '630dc81001143.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:49:28', '2022-08-30 02:49:28'), (10, 'Horror', 'horror', NULL, '630dc827b4ceb.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:49:51', '2022-08-30 02:49:51'), (11, 'Comedy', 'comedy', NULL, '630dc837ae7d3.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:50:07', '2022-08-30 02:50:07'), (12, 'Suspense', 'suspense', NULL, '630dc84e0c50e.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:50:30', '2022-08-30 02:50:30'), (13, 'Romance', 'romance', NULL, '630eed477be0b.png', NULL, NULL, 1, 'active', '2022-08-30 02:50:48', '2022-08-30 23:40:31'), (14, 'Action', 'action', NULL, '630dc8712612e.jpg', NULL, NULL, 1, 'active', '2022-08-30 02:51:05', '2022-08-30 02:51:05'); -- -------------------------------------------------------- -- -- Table structure for table `category_movie` -- CREATE TABLE `category_movie` ( `id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `movie_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `category_movie` -- INSERT INTO `category_movie` (`id`, `category_id`, `movie_id`) VALUES (1, 14, 1), (2, 9, 3), (3, 12, 3), (4, 9, 4), (5, 12, 4), (6, 10, 5), (15, 13, 3), (16, 2, 1), (17, 12, 1), (18, 13, 1), (19, 5, 11), (20, 7, 11), (21, 8, 11), (22, 9, 11), (23, 13, 11), (24, 14, 12), (25, 4, 12), (26, 5, 12), (27, 6, 12), (28, 8, 12), (29, 9, 12), (30, 10, 12), (31, 11, 12), (32, 12, 12), (33, 13, 12); -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `id` bigint(20) UNSIGNED NOT NULL, `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message` text COLLATE utf8mb4_unicode_ci 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 `contacts` -- INSERT INTO `contacts` (`id`, `first_name`, `last_name`, `email`, `phone`, `message`, `created_at`, `updated_at`) VALUES (1, 'Sam', 'Kumar', 'sam@gmail.com', '1234567892', 'hello', '2022-09-06 23:45:13', '2022-09-06 23:45:13'), (2, 'Sam', 'Kumar', 'sam@gmail.com', '1234567892', 'hello', '2022-09-06 23:46:08', '2022-09-06 23:46:08'), (3, 'Leo', 'Messi', 'messi@gmail.com', '1234567892', 'hello', '2022-09-06 23:46:49', '2022-09-06 23:46:49'); -- -------------------------------------------------------- -- -- Table structure for table `entertains` -- CREATE TABLE `entertains` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `price` double(6,2) NOT NULL, `tenure` varchar(150) COLLATE utf8mb4_unicode_ci 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 `entertains` -- INSERT INTO `entertains` (`id`, `title`, `price`, `tenure`, `created_at`, `updated_at`) VALUES (1, 'Unlimited', 10.99, 'MONTH', '2022-08-30 00:45:24', '2022-08-30 00:51:47'), (2, 'Rent', 1.99, 'ANY MOVIE', '2022-08-30 00:45:58', '2022-08-30 00:51:39'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci 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` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `answer` longtext COLLATE utf8mb4_unicode_ci 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 `faqs` -- INSERT INTO `faqs` (`id`, `question`, `answer`, `created_at`, `updated_at`) VALUES (1, 'What is Mogul PIX?', 'Lorem, ipsum dolor sit amet consectetur adipisicing elit. Omnis dolor ratione quaerat eum provident laudantium doloremque, quidem id et maxime ducimus quasi tenetur veritatis sit error possimus eius fuga. Aspernatur quis totam distinctio tempora, minus officia odio atque! Corporis consectetur iure magnam recusandae quibusdam at placeat earum vero, nam quam sapiente est. Non optio explicabo doloremque architecto eos sint vero iste ut ab reiciendis perferendis libero quis laboriosam suscipit, natus officia possimus veritatis, eligendi. Sapiente porro provident, rem reiciendis laudantium neque deserunt a, suscipit placeat quo odit esse temporibus fugiat cum modi saepe nihil quibusdam nam iure, sequi autem. Nam, repellat ea ipsam assumenda alias dolore unde, quibusdam fugiat vel laborum amet dolorum corrupti voluptate nostrum sapiente necessitatibus totam numquam.', '2022-08-26 05:03:40', '2022-08-26 05:06:48'), (2, 'How much does Mogul PIX cost?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur consequat erat sit amet sapien varius, vitae scelerisque est porttitor. Donec ornare a nunc id aliquam. Donec convallis, justo ac feugiat vestibulum, leo elit facilisis massa, vel luctus dui turpis bibendum ante. Praesent eget pretium arcu. Pellentesque metus quam, venenatis vel nulla eget, vulputate ultricies libero. Sed scelerisque dapibus sem, ut ultrices odio ultrices in. Integer convallis sollicitudin justo non varius. Duis id suscipit leo. Phasellus tempor massa ut quam interdum, non bibendum enim feugiat. Fusce tellus purus, pellentesque efficitur tristique sed, egestas quis libero. Vestibulum eu malesuada orci. Ut pulvinar condimentum neque non rutrum.', '2022-09-16 04:03:07', '2022-09-16 04:03:07'), (3, 'Where can I watch?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur consequat erat sit amet sapien varius, vitae scelerisque est porttitor. Donec ornare a nunc id aliquam. Donec convallis, justo ac feugiat vestibulum, leo elit facilisis massa, vel luctus dui turpis bibendum ante. Praesent eget pretium arcu. Pellentesque metus quam, venenatis vel nulla eget, vulputate ultricies libero. Sed scelerisque dapibus sem, ut ultrices odio ultrices in. Integer convallis sollicitudin justo non varius. Duis id suscipit leo. Phasellus tempor massa ut quam interdum, non bibendum enim feugiat. Fusce tellus purus, pellentesque efficitur tristique sed, egestas quis libero. Vestibulum eu malesuada orci. Ut pulvinar condimentum neque non rutrum.', '2022-09-16 04:03:38', '2022-09-16 04:03:38'), (4, 'How do I cancel?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur consequat erat sit amet sapien varius, vitae scelerisque est porttitor. Donec ornare a nunc id aliquam. Donec convallis, justo ac feugiat vestibulum, leo elit facilisis massa, vel luctus dui turpis bibendum ante. Praesent eget pretium arcu. Pellentesque metus quam, venenatis vel nulla eget, vulputate ultricies libero. Sed scelerisque dapibus sem, ut ultrices odio ultrices in. Integer convallis sollicitudin justo non varius. Duis id suscipit leo. Phasellus tempor massa ut quam interdum, non bibendum enim feugiat. Fusce tellus purus, pellentesque efficitur tristique sed, egestas quis libero. Vestibulum eu malesuada orci. Ut pulvinar condimentum neque non rutrum.', '2022-09-16 04:04:07', '2022-09-16 04:04:07'), (5, 'What can I watch on Mogul PIX?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur consequat erat sit amet sapien varius, vitae scelerisque est porttitor. Donec ornare a nunc id aliquam. Donec convallis, justo ac feugiat vestibulum, leo elit facilisis massa, vel luctus dui turpis bibendum ante. Praesent eget pretium arcu. Pellentesque metus quam, venenatis vel nulla eget, vulputate ultricies libero. Sed scelerisque dapibus sem, ut ultrices odio ultrices in. Integer convallis sollicitudin justo non varius. Duis id suscipit leo. Phasellus tempor massa ut quam interdum, non bibendum enim feugiat. Fusce tellus purus, pellentesque efficitur tristique sed, egestas quis libero. Vestibulum eu malesuada orci. Ut pulvinar condimentum neque non rutrum.', '2022-09-16 04:04:32', '2022-09-16 04:04:32'), (6, 'Is Mogul PIX good for kids?', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur consequat erat sit amet sapien varius, vitae scelerisque est porttitor. Donec ornare a nunc id aliquam. Donec convallis, justo ac feugiat vestibulum, leo elit facilisis massa, vel luctus dui turpis bibendum ante. Praesent eget pretium arcu. Pellentesque metus quam, venenatis vel nulla eget, vulputate ultricies libero. Sed scelerisque dapibus sem, ut ultrices odio ultrices in. Integer convallis sollicitudin justo non varius. Duis id suscipit leo. Phasellus tempor massa ut quam interdum, non bibendum enim feugiat. Fusce tellus purus, pellentesque efficitur tristique sed, egestas quis libero. Vestibulum eu malesuada orci. Ut pulvinar condimentum neque non rutrum.', '2022-09-16 04:04:51', '2022-09-16 04:04:51'), (7, '<p>helloefew<br></p>', '<p>mjdskgsdasdasasfa<br></p>', '2022-09-21 01:24:07', '2022-09-21 01:24:29'); -- -------------------------------------------------------- -- -- Table structure for table `home_config_works` -- CREATE TABLE `home_config_works` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '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 `home_config_works` -- INSERT INTO `home_config_works` (`id`, `title`, `slug`, `content`, `image`, `status`, `created_at`, `updated_at`) VALUES (1, 'Earn money', 'earn-money', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam eleifend sem eu sodales iaculis. Nulla elit diam, pharetra a dolor at, maximus consequat ante. Aliquam tristique ac nulla vel dictum.', '630a0c62732ae.svg', 'active', '2022-08-27 05:16:52', '2022-08-27 06:51:54'), (2, 'Refer friends', 'refer-friends', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam eleifend sem eu sodales iaculis.\n\n Nulla elit diam, pharetra a dolor at, maximus consequat ante. Aliquam tristique ac nulla vel\n\n dictum.', '630a0cb149789.svg', 'active', '2022-08-27 00:56:23', '2022-08-27 01:23:13'), (3, 'Watch movies', 'watch-movies', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam eleifend sem eu sodales iaculis.\r\n Nulla elit diam, pharetra a dolor at, maximus consequat ante. Aliquam tristique ac nulla vel\r\n dictum.', '630a0c9e76509.svg', 'active', '2022-08-27 06:29:47', '2022-08-27 06:52:54'), (4, 'Payment', 'payment', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam eleifend sem eu sodales iaculis.\r\n Nulla elit diam, pharetra a dolor at, maximus consequat ante. Aliquam tristique ac nulla vel\r\n dictum.', '630a0c8e8c6ae.svg', 'active', '2022-08-27 06:30:14', '2022-08-27 06:52:38'), (5, 'Register', 'register', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam eleifend sem eu sodales iaculis.\r\n Nulla elit diam, pharetra a dolor at, maximus consequat ante. Aliquam tristique ac nulla vel\r\n dictum', '630a0c7a46646.svg', 'active', '2022-08-27 06:30:34', '2022-09-21 04:23:57'); -- -------------------------------------------------------- -- -- Table structure for table `medias` -- CREATE TABLE `medias` ( `id` bigint(20) UNSIGNED NOT NULL, `tab_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tab_icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tab_content_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `link` varchar(255) COLLATE utf8mb4_unicode_ci 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 `medias` -- INSERT INTO `medias` (`id`, `tab_title`, `tab_icon`, `tab_content_image`, `link`, `created_at`, `updated_at`) VALUES (1, 'Watch onlinee', '630c6e5b8444b.svg', '630e03003d1ab.png', NULL, '2022-08-29 01:35:38', '2022-08-30 07:00:56'), (2, 'Watch on Mobile', '630c6e28bc4a9.png', '6315b32c3079d.png', NULL, '2022-08-29 02:13:36', '2022-09-05 02:58:28'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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 (25, '2022_08_25_061935_create_category_movies_table', 11), (29, '2014_10_12_100000_create_password_resets_table', 12), (30, '2017_08_11_073824_create_menus_wp_table', 12), (31, '2017_08_11_074006_create_menu_items_wp_table', 12), (32, '2019_08_19_000000_create_failed_jobs_table', 12), (33, '2019_12_14_000001_create_personal_access_tokens_table', 12), (35, '2022_08_19_061902_create_pages_table', 12), (37, '2022_08_23_113004_create_faqs_table', 12), (44, '2022_08_22_102929_create_page_banners_table', 14), (47, '2022_08_23_122941_create_contacts_table', 15), (49, '2022_08_25_093559_create_category_movie_table', 17), (50, '2022_08_25_060715_create_movies_table', 18), (53, '2022_08_27_095725_create_home_config_works_table', 19), (55, '2022_08_29_055347_create_media_table', 20), (56, '2014_10_11_091805_create_roles_table', 21), (57, '2014_10_12_000000_create_users_table', 22), (58, '2022_08_30_054631_create_entertains_table', 23), (59, '2022_08_24_103328_create_categories_table', 24), (60, '2019_05_03_000001_create_customer_columns', 25), (61, '2019_05_03_000002_create_subscriptions_table', 25), (62, '2019_05_03_000003_create_subscription_items_table', 25), (65, '2022_08_18_104751_create_site_settings_table', 26), (71, '2022_09_09_074903_create_payments_table', 27), (73, '2022_09_19_062822_create_reviews_table', 28), (74, '2022_09_23_112402_create_bank_details_table', 29); -- -------------------------------------------------------- -- -- Table structure for table `movies` -- CREATE TABLE `movies` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `price` decimal(5,2) NOT NULL, `movie_length` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `star_cast` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `passcode` char(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `trailer` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `video_upload` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `video_type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_featured` tinyint(4) NOT NULL DEFAULT 0, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '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 `movies` -- INSERT INTO `movies` (`id`, `title`, `slug`, `price`, `movie_length`, `description`, `star_cast`, `passcode`, `cover_image`, `trailer`, `video_upload`, `video_type`, `is_featured`, `status`, `created_at`, `updated_at`) VALUES (1, 'Avenger', 'avenger', '502.00', '150', NULL, NULL, NULL, '630898d5d1189.jpg', '6322d9fc5b6d9.mp4', '6322d9fc5feaf.mp4', 'mp4', 1, 'active', '2022-08-26 04:20:20', '2022-08-30 04:41:54'), (2, 'Bat Man', 'bat-man', '500.00', '180', NULL, NULL, NULL, '63089860c343c.jpg', '', NULL, NULL, 1, 'active', '2022-08-26 04:23:07', '2022-08-30 04:41:36'), (3, 'Joker', 'joker', '550.00', '1h 30m', '<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Vel repellendus rem iure dolores nam, beatae, ad expedita doloremque libero animi eligendi veniam illum quaerat accusamus minus dolorum similique, maxime? Architecto voluptas iste explicabo dolorem, autem laboriosam officia necessitatibus aliquam nisi blanditiis illo? Repudiandae impedit, eius inventore aut rerum quasi recusandae unde molestiae obcaecati vitae porro asperiores qui similique! Optio totam, excepturi nostrum inventore at tempora assumenda corrupti ullam provident corporis neque quas enim modi officia animi suscipit rerum placeat perferendis pariatur! Laborum consectetur rem velit blanditiis at voluptatibus. Autem vel quos sed similique accusamus nulla nostrum aliquam dicta at in.<br></p>', '{\"director\":\"Jordan Vogt-Roberts\",\"cast\":\"Tom Hiddleston, Samuel L. Jackson, Brie Larson, John C. Reilly, John Goodman, Corey Hawkins, John Ortiz, Toby Kebbell, Jason Mitchell, Shea Whigham, Terry Notary\",\"writer\":\"John Gatins, Dan Gilroy, Max Borenstein, Derek Connolly\",\"genres\":\"Action & Adventure\"}', NULL, '63089857f09d3.jpg', '6322d9fc5b6d9.mp4', '6322d9fc5feaf.mp4', 'mp4', 1, 'active', '2022-08-26 04:23:49', '2022-08-31 02:08:11'), (4, 'King Kong', 'king-kong', '360.00', '2h 40m', NULL, NULL, NULL, '630898823ac38.jpg', '', NULL, NULL, 1, 'active', '2022-08-26 04:25:14', '2022-08-30 05:16:13'), (5, 'Green Room', 'green-room', '650.00', '2h 30m', NULL, '{\"director\":\"Jordan Vogt-Roberts\",\"cast\":\"Tom Hiddleston, Samuel L. Jackson, Brie Larson, John C. Reilly, John Goodman, Corey Hawkins, John Ortiz, Toby Kebbell, Jason Mitchell, Shea Whigham, Terry Notary\",\"writer\":\"John Gatins, Dan Gilroy, Max Borenstein, Derek Connolly\",\"genres\":\"Action & Adventure\"}', NULL, '630898a5ab2f9.jpg', '', NULL, NULL, 1, 'active', '2022-08-26 04:25:49', '2022-08-31 00:57:30'), (11, 'Cupidatat enim dolor', 'cupidatat-enim-dolor', '269.00', 'Do dolor do mollit q', NULL, '{\"director\":\"Sunt temporibus dese\",\"cast\":\"Cumque omnis ea vita\",\"writer\":\"Sequi et et est sunt\",\"genres\":\"Est ab velit et co\"}', NULL, NULL, NULL, NULL, NULL, 0, 'active', '2022-09-05 05:49:53', '2022-09-05 05:49:53'), (12, 'Illum amet blandit', 'illum-amet-blandit', '739.00', 'Elit dolor ad aut e', NULL, '{\"director\":\"Necessitatibus paria\",\"cast\":\"Quia fugiat omnis q\",\"writer\":\"Ea ut omnis nesciunt\",\"genres\":\"Tempor laborum unde\"}', NULL, NULL, NULL, NULL, NULL, 0, 'active', '2022-09-05 05:54:39', '2022-09-05 05:54:39'); -- -------------------------------------------------------- -- -- Table structure for table `pages` -- CREATE TABLE `pages` ( `id` bigint(20) UNSIGNED NOT NULL, `page_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `page_slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `page_content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `banner_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `banner_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `banner_content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keyword` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `home_section_title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '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 `pages` -- INSERT INTO `pages` (`id`, `page_name`, `page_slug`, `page_content`, `banner_title`, `banner_image`, `banner_content`, `meta_keyword`, `meta_description`, `home_section_title`, `status`, `created_at`, `updated_at`) VALUES (1, 'About Us', 'about-us', 'Lorem ipsum, dolor sit amet consectetur adipisicing elit. Magni, quibusdam, ab! Ratione esse ut nobis officia repellat fugit cumque. Corporis consequuntur vel labore veniam praesentium nisi perspiciatis, ex voluptas nihil maxime voluptatum laboriosam amet repellendus adipisci tempore unde iusto perferendis nesciunt magni officia porro dicta eos quas? Molestiae vitae optio, perspiciatis deserunt consectetur facere, amet nesciunt praesentium. Blanditiis dolores, dolor id non facere, aut ullam nihil amet cupiditate ratione veniam. Culpa pariatur in ratione placeat, explicabo nemo ipsam, reprehenderit tempore. Suscipit reprehenderit laborum mollitia, beatae repellendus fuga ipsam dolore optio amet consectetur quasi obcaecati quia sapiente iste. Neque doloribus beatae repudiandae, at laudantium laboriosam iusto consequuntur excepturi, impedit. Fugit eaque, consectetur accusamus, cumque voluptates commodi delectus adipisci atque quibusdam earum at quisquam, enim magni officia a praesentium dolore reiciendis veniam veritatis ex nam rerum? Recusandae mollitia assumenda, voluptatum voluptate nesciunt ex nostrum minus obcaecati neque culpa accusamus voluptatem possimus nulla dignissimos doloremque ab labore sed quis similique eveniet nihil molestiae aut architecto. Vel eum odio, enim ullam laborum rem recusandae magnam nisi excepturi quis, aliquid optio, iusto. Magni dignissimos, eligendi vel quae! Necessitatibus quis dolorum debitis nemo minima praesentium aperiam deserunt ea. Cupiditate perferendis, corrupti esse laborum! Recusandae dolorum, excepturi quidem doloribus necessitatibus, autem consequatur magni assumenda dolores sit, voluptate. Consequuntur iste commodi, aliquid perspiciatis explicabo. In quos repudiandae animi incidunt? Atque deleniti fugiat voluptas harum aliquid, architecto, voluptate hic maiores delectus at sapiente. Nemo consectetur sed sequi aliquam sit, labore aliquid, ad vel voluptas expedita ipsum quisquam facere, eveniet?', 'About Us', '', '', 'test meta keyword', '<p>test meta derscription</p>', '{\"home_category_sec_title\":null,\"home_movie_sec_title\":null,\"home_work_sec_title\":null,\"home_media_sec_title\":null,\"home_media_sec_subtitle\":null,\"home_media_sec_bottom_title\":null,\"home_entertain_sec_title\":null,\"home_faq_sec_title\":null}', 'active', '2022-08-24 23:53:19', '2022-09-15 22:27:12'), (2, 'Contact Us', 'contact-us', '<h2>UNLIMITED ENTERTAINMENT WITH CASH BENIFITS</h2>\n\n <p>Phasellus dictum, turpis sit amet consectetur commodo, dui justo iaculis erat, nec porta magna mi in ex.</p>', '', '', '', '', '', '{\"home_category_sec_title\":null,\"home_movie_sec_title\":null,\"home_work_sec_title\":null,\"home_media_sec_title\":null,\"home_media_sec_subtitle\":null,\"home_media_sec_bottom_title\":null,\"home_entertain_sec_title\":null,\"home_faq_sec_title\":null}', 'active', '2022-08-24 23:54:52', '2022-09-15 22:29:41'), (3, 'Privacy Policy', 'privacy-policy', 'Lorem ipsum dolor sit amet consectetur, adipisicing elit. Quisquam hic non tempore sed nemo quam provident fugit similique ex! Molestiae porro ipsa praesentium tenetur reiciendis id alias odio sapiente soluta obcaecati nesciunt, perspiciatis impedit ut inventore minima laborum dolore? Qui sunt velit nostrum laboriosam repellendus ullam, sit similique unde esse magnam neque animi soluta ad et fuga, ipsa. Maiores voluptatum dolorum corrupti delectus nihil laborum, autem accusantium? Asperiores minus qui, reiciendis eveniet eius illum repudiandae rerum iure molestiae debitis, nihil doloremque minima magnam tempora voluptates sed autem. Impedit assumenda enim necessitatibus aspernatur qui explicabo quis possimus ut veniam dolore, molestias totam voluptatem eum sunt eos ab maiores eligendi quod itaque voluptates beatae autem deserunt facere iusto sequi. Fugiat sapiente eos voluptates quidem cum nam officia id et accusantium explicabo sed error molestiae magni beatae harum reprehenderit, ratione hic officiis ullam provident maiores in porro! Atque qui totam neque consequatur corrupti pariatur nisi maxime voluptatem autem quasi sequi facilis non porro iste in, perferendis repellat adipisci soluta debitis nam omnis quaerat molestias perspiciatis ab! Ad, tenetur. Est vero laboriosam delectus minima architecto illo temporibus placeat exercitationem adipisci, laudantium, expedita eveniet obcaecati aut ab, deserunt nulla amet. Soluta dolore, eos architecto, impedit magni velit molestiae sapiente fugiat quis facere aliquid earum dolores perferendis culpa voluptatem? Dolores dolor, cumque accusamus commodi ullam magni obcaecati molestias, ratione voluptatibus distinctio deleniti sapiente. Sit est eos sequi, rem ex enim animi ducimus non error laudantium quia accusantium a magni tempora aliquam reprehenderit. Amet fugiat, fuga hic.', 'Privacy Policy', '', '', '', '', '{\"home_category_sec_title\":null,\"home_movie_sec_title\":null,\"home_work_sec_title\":null,\"home_media_sec_title\":null,\"home_media_sec_subtitle\":null,\"home_media_sec_bottom_title\":null,\"home_entertain_sec_title\":null,\"home_faq_sec_title\":null}', 'active', '2022-08-24 23:56:54', '2022-09-15 22:59:40'), (4, 'Home', 'home', '', 'Home', '', '<h1>UNLIMITED ENTERTAINMENT WITH CASH BENIFITS</h1>\n\n\n\n <ul>\n\n\n\n <li>SEARCH MOVIES</li>\n\n\n\n <li>WATCH MOVIES ANYTIME</li>\n\n\n\n <li>REFER TO EARN BONUS</li>\n\n\n\n </ul>', '', '', '{\"home_category_sec_title\":\"TOP CATEGORIES\",\"home_movie_sec_title\":\"NEW RELEASE\",\"home_work_sec_title\":\"HOW IT WORKS\",\"home_media_sec_title\":\"WATCH IT EVERYWHERE YOU GO!\",\"home_media_sec_subtitle\":\"Unlimited movies on your phone and laptop\",\"home_media_sec_bottom_title\":\"Save your favourites easily and always have something to watch.\",\"home_entertain_sec_title\":\"ENTERTAIN YOURSELF\",\"home_faq_sec_title\":\"FREQUENTLY ASKED QUESTIONS\"}', 'active', '2022-08-25 01:21:41', '2022-08-28 22:09:20'), (5, 'Faq', 'faq', '', 'Faq', '', '', '', '', '', 'active', '2022-08-25 23:35:39', '2022-08-25 23:35:39'), (6, 'TERMS & CONDITIONS', 'terms-conditions', 'Lorem ipsum dolor sit amet consectetur, adipisicing elit. Quisquam hic non tempore sed nemo quam provident fugit similique ex! Molestiae porro ipsa praesentium tenetur reiciendis id alias odio sapiente soluta obcaecati nesciunt, perspiciatis impedit ut inventore minima laborum dolore? Qui sunt velit nostrum laboriosam repellendus ullam, sit similique unde esse magnam neque animi soluta ad et fuga, ipsa. Maiores voluptatum dolorum corrupti delectus nihil laborum, autem accusantium? Asperiores minus qui, reiciendis eveniet eius illum repudiandae rerum iure molestiae debitis, nihil doloremque minima magnam tempora voluptates sed autem. Impedit assumenda enim necessitatibus aspernatur qui explicabo quis possimus ut veniam dolore, molestias totam voluptatem eum sunt eos ab maiores eligendi quod itaque voluptates beatae autem deserunt facere iusto sequi. Fugiat sapiente eos voluptates quidem cum nam officia id et accusantium explicabo sed error molestiae magni beatae harum reprehenderit, ratione hic officiis ullam provident maiores in porro! Atque qui totam neque consequatur corrupti pariatur nisi maxime voluptatem autem quasi sequi facilis non porro iste in, perferendis repellat adipisci soluta debitis nam omnis quaerat molestias perspiciatis ab! Ad, tenetur. Est vero laboriosam delectus minima architecto illo temporibus placeat exercitationem adipisci, laudantium, expedita eveniet obcaecati aut ab, deserunt nulla amet. Soluta dolore, eos architecto, impedit magni velit molestiae sapiente fugiat quis facere aliquid earum dolores perferendis culpa voluptatem? Dolores dolor, cumque accusamus commodi ullam magni obcaecati molestias, ratione voluptatibus distinctio deleniti sapiente. Sit est eos sequi, rem ex enim animi ducimus non error laudantium quia accusantium a magni tempora aliquam reprehenderit. Amet fugiat, fuga hic.', 'TERMS & CONDITIONS', '1663742875.jpg', '<p>sfdfdffdf<br></p>', '', '', '{\"home_category_sec_title\":null,\"home_movie_sec_title\":null,\"home_work_sec_title\":null,\"home_media_sec_title\":null,\"home_media_sec_subtitle\":null,\"home_media_sec_bottom_title\":null,\"home_entertain_sec_title\":null,\"home_faq_sec_title\":null}', 'active', '2022-08-26 07:33:15', '2022-09-21 01:17:55'), (7, 'Bert Chapman', 'bert-chapman', '', 'Nostrum amet volupt', '1663742958.jpg', '', 'Velit sequi illum a', '', '', 'active', '2022-09-21 01:19:18', '2022-09-21 01:19:18'); -- -------------------------------------------------------- -- -- Table structure for table `page_banners` -- CREATE TABLE `page_banners` ( `id` bigint(20) UNSIGNED NOT NULL, `page_id` bigint(20) UNSIGNED NOT NULL, `banner_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `banner_content` text COLLATE utf8mb4_unicode_ci 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 `page_banners` -- INSERT INTO `page_banners` (`id`, `page_id`, `banner_image`, `banner_content`, `created_at`, `updated_at`) VALUES (1, 1, '630769f8ed3ff.jpg', NULL, '2022-08-25 06:54:24', '2022-08-25 06:54:24'), (2, 1, '630769f8eed24.jpg', NULL, '2022-08-25 06:54:24', '2022-08-25 06:54:24'), (3, 1, '630769f8efd27.jpg', NULL, '2022-08-25 06:54:24', '2022-08-25 06:54:24'), (4, 4, '63076a07e22ba.jpg', '<p>hello</p>', '2022-08-25 01:24:39', '2022-08-25 01:24:39'), (5, 4, '63076a07e3eae.jpg', '<p>hello</p>', '2022-08-25 06:54:39', '2022-08-25 06:54:39'), (6, 4, '63076a07e505e.jpg', '<p>hello</p>', '2022-08-25 06:54:39', '2022-08-25 06:54:39'), (7, 4, '63076a07e5a73.jpg', '<p>hello</p>', '2022-08-25 06:54:39', '2022-08-25 06:54:39'), (8, 7, '632ab4803a6fb.jpg', '', '2022-09-21 01:21:44', '2022-09-21 01:21:44'), (9, 4, '632ada49bdd33.png', 'lorem<br>', '2022-09-21 04:02:57', '2022-09-21 04:02:57'), (10, 7, '632ab4803bbb7.jpg', '', '2022-09-21 01:21:44', '2022-09-21 01:21:44'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payments` -- CREATE TABLE `payments` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `movie_id` bigint(20) UNSIGNED NOT NULL, `unit_price` double(6,2) NOT NULL, `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payment_validity` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `passcode` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `payment_status` enum('pending','success','failed') COLLATE utf8mb4_unicode_ci 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; -- -- Dumping data for table `payments` -- INSERT INTO `payments` (`id`, `user_id`, `movie_id`, `unit_price`, `transaction_id`, `payment_method`, `stripe_email`, `payment_validity`, `passcode`, `payment_status`, `created_at`, `updated_at`) VALUES (1, 19, 11, 1.99, 'ch_3LhUDDFrptn7tD2n02oDuhTr', 'STRIPE', 'jordan@example.com', '2022-09-14 09:41:31', '', 'pending', '2022-09-13 02:41:20', '2022-09-13 02:41:20'), (2, 22, 3, 1.99, 'ch_3LhsaCFrptn7tD2n1B9xHhG5', 'STRIPE', 'sepir@mailinator.com', '2022-09-15 04:42:41', '', 'pending', '2022-09-14 04:42:41', '2022-09-14 04:42:41'), (3, 22, 3, 1.99, 'ch_3LiGuGFrptn7tD2n0EB8qUwf', 'STRIPE', 'joker@example.com', '2022-09-16 04:41:01', '', 'pending', '2022-09-15 04:41:01', '2022-09-15 04:41:01'), (4, 22, 4, 1.99, 'ch_3LiGzxFrptn7tD2n0ZKHsCWp', 'STRIPE', 'king@example.com', '2022-09-16 06:46:54', '', 'pending', '2022-09-15 06:46:54', '2022-09-15 06:46:54'), (5, 25, 1, 1.99, 'ch_3LidzHFrptn7tD2n0jDICNGC', 'STRIPE', 'mukihejyky@mailinator.com', '2022-09-17 07:19:43', '', 'pending', '2022-09-16 07:19:43', '2022-09-16 07:19:43'), (6, 26, 3, 1.99, 'ch_3Lie28Frptn7tD2n0Qay4As0', 'STRIPE', 'qadoriz@mailinator.com', '2022-09-17 07:22:41', '', 'pending', '2022-09-16 07:22:41', '2022-09-16 07:22:41'), (7, 26, 4, 1.99, 'ch_3Lie2oFrptn7tD2n15kpHvos', 'STRIPE', 'qadoriz@mailinator.com', '2022-09-17 07:23:23', '', 'pending', '2022-09-16 07:23:23', '2022-09-16 07:23:23'), (8, 26, 4, 1.99, 'ch_3LjcjTFrptn7tD2n1kSgApyy', 'STRIPE', 'qadoriz@mailinator.com', '2022-09-20 00:11:27', '', 'pending', '2022-09-19 00:11:27', '2022-09-19 00:11:27'), (9, 22, 3, 1.99, 'ch_3LjeekFrptn7tD2n01QPpVRy', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-20 02:14:43', '', 'pending', '2022-09-19 02:14:43', '2022-09-19 02:14:43'), (10, 22, 4, 1.99, 'ch_3LjgLxFrptn7tD2n07alFSb9', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-20 04:03:26', '', 'pending', '2022-09-19 04:03:26', '2022-09-19 04:03:26'), (11, 22, 1, 1.99, 'ch_3LjilpFrptn7tD2n1lKb1J8a', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-20 06:38:19', '', 'pending', '2022-09-19 06:38:19', '2022-09-19 06:38:19'), (12, 22, 4, 1.99, 'ch_3Lk4WrFrptn7tD2n0LWOPqp1', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-21 05:52:19', 'ave-ejOHRI', 'pending', '2022-09-20 05:52:19', '2022-09-20 05:52:19'), (13, 22, 3, 1.99, 'ch_3LkLYSFrptn7tD2n1Xj0cgv4', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-22 00:03:07', 'jok-t46sm9', 'pending', '2022-09-21 00:03:07', '2022-09-21 00:03:07'), (14, 22, 4, 1.99, 'ch_3LkR6dFrptn7tD2n0jx1aW09', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-22 05:58:44', 'Kin-ckzhjS', 'pending', '2022-09-21 05:58:44', '2022-09-21 05:58:44'), (15, 22, 1, 1.99, 'ch_3LkRjrFrptn7tD2n1cQH9Gas', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-22 06:39:16', 'Ave-D4d2Ve', 'pending', '2022-09-21 06:39:16', '2022-09-21 06:39:16'), (16, 22, 3, 1.99, 'ch_3Ll4HAFrptn7tD2n07nCQjSw', 'STRIPE', 'cogedokeva@mailinator.com', '2022-09-23 23:48:12', 'Jok-amuJEGn', 'success', '2022-09-22 23:48:12', '2022-09-22 23:48:12'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci 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 `reviews` -- CREATE TABLE `reviews` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `movie_id` bigint(20) UNSIGNED NOT NULL, `rating` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '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 `reviews` -- INSERT INTO `reviews` (`id`, `user_id`, `movie_id`, `rating`, `description`, `status`, `created_at`, `updated_at`) VALUES (1, 26, 4, '5', 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Ea, itaque atque ad ut nihil nostrum voluptatum sunt rerum, aliquam ab? Porro officiis magnam nihil amet a accusantium eum placeat accusamus.', 'active', '2022-09-19 01:49:50', '2022-09-19 07:07:48'), (2, 22, 4, '5', 'very nice', 'active', '2022-09-19 02:15:02', '2022-09-19 07:07:49'), (3, 22, 4, '2', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Eaque suscipit, excepturi vero qui officiis deleniti quibusdam quasi blanditiis repudiandae, repellendus, ex quod, nulla corporis possimus incidunt neque laborum maiores! Repellendus ipsa minima asperiores nisi quasi in neque perferendis animi optio.dsdaaaa', 'active', '2022-09-19 04:03:45', '2022-09-21 05:11:30'), (4, 22, 5, '3', 'very nice', 'active', '2022-09-22 04:16:37', '2022-09-22 04:16:37'), (5, 13, 4, '4', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Eaque suscipit, excepturi vero qui officiis deleniti quibusdam quasi blanditiis repudiandae, repellendus, ex quod, nulla corporis possimus incidunt neque laborum maiores! Repellendus ipsa minima asperiores nisi quasi in neque perferendis animi optio.dsdaaaa', 'active', '2022-09-19 04:03:45', '2022-09-21 05:11:30'), (6, 18, 4, '3', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Eaque suscipit, excepturi vero qui officiis deleniti quibusdam quasi blanditiis repudiandae, repellendus, ex quod, nulla corporis possimus incidunt neque laborum maiores! Repellendus ipsa minima asperiores nisi quasi in neque perferendis animi optio.dsdaaaa', 'active', '2022-09-19 04:03:45', '2022-09-21 05:11:30'), (7, 3, 2, '3', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Eaque suscipit, excepturi vero qui officiis deleniti quibusdam quasi blanditiis repudiandae, repellendus, ex quod, nulla corporis possimus incidunt neque laborum maiores! Repellendus ipsa minima asperiores nisi quasi in neque perferendis animi optio.dsdaaaa', 'active', '2022-09-19 04:03:45', '2022-09-21 05:11:30'), (8, 13, 3, '3', 'fav', 'active', '2022-09-22 06:41:55', '2022-09-22 06:41:55'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `name`, `created_at`, `updated_at`) VALUES (1, 'admin', '2022-08-29 03:58:35', '2022-08-29 03:58:35'), (2, 'user', '2022-08-29 03:58:35', '2022-08-29 03:58:35'); -- -------------------------------------------------------- -- -- Table structure for table `site_settings` -- CREATE TABLE `site_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `site_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `admin_email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `site_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `light_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `footer_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `copyright_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_keyword` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facebook_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `twitter_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `instagram_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `linkedin_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `app_store_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `google_store_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subscription_price_id` varchar(255) COLLATE utf8mb4_unicode_ci 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 `site_settings` -- INSERT INTO `site_settings` (`id`, `site_name`, `admin_email`, `site_logo`, `light_logo`, `favicon`, `footer_text`, `copyright_text`, `meta_title`, `meta_keyword`, `meta_description`, `facebook_link`, `twitter_link`, `instagram_link`, `linkedin_link`, `app_store_link`, `google_store_link`, `subscription_price_id`, `created_at`, `updated_at`) VALUES (1, 'Mogul Pix', 'samim.molla@thecodersmind.com', '1663322468.png', NULL, NULL, NULL, 'MOGUL PIX. ALL RIGHTS RESERVED.', 'test meta', 'test keyword', NULL, NULL, NULL, NULL, NULL, NULL, 'https://www.google.co.in/', NULL, NULL, '2022-09-16 04:31:08'); -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `trial_ends_at` timestamp NULL DEFAULT NULL, `ends_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; -- -- Dumping data for table `subscriptions` -- INSERT INTO `subscriptions` (`id`, `user_id`, `name`, `stripe_id`, `stripe_status`, `stripe_price`, `quantity`, `trial_ends_at`, `ends_at`, `created_at`, `updated_at`) VALUES (1, 7, 'main', 'sub_1LdXMdFrptn7tD2nQVkneZXq', 'active', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, NULL, '2022-10-02 05:14:43', '2022-09-02 05:14:44', '2022-09-08 04:32:21'), (2, 12, 'main', 'sub_1LfJrXFrptn7tD2nwRXxHW4y', 'active', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, NULL, NULL, '2022-09-07 03:14:00', '2022-09-07 03:14:04'), (3, 13, 'main', 'sub_1LhYtpFrptn7tD2nrbSlommC', 'active', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, NULL, NULL, '2022-09-13 07:41:38', '2022-09-13 07:41:42'), (4, 27, 'main', 'sub_1Lie5QFrptn7tD2n8UGvvBgP', 'active', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, NULL, NULL, '2022-09-16 07:26:05', '2022-09-16 07:26:08'), (5, 28, 'main', 'sub_1LkQvEFrptn7tD2n457ApE5L', 'active', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, NULL, NULL, '2022-09-21 05:46:57', '2022-09-21 05:47:00'); -- -------------------------------------------------------- -- -- Table structure for table `subscription_items` -- CREATE TABLE `subscription_items` ( `id` bigint(20) UNSIGNED NOT NULL, `subscription_id` bigint(20) UNSIGNED NOT NULL, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_product` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `stripe_price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` 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 `subscription_items` -- INSERT INTO `subscription_items` (`id`, `subscription_id`, `stripe_id`, `stripe_product`, `stripe_price`, `quantity`, `created_at`, `updated_at`) VALUES (1, 1, 'si_MMFshcEpRGBP0b', 'prod_MMFHUSYYYCv3dw', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, '2022-09-02 05:14:44', '2022-09-02 05:14:44'), (2, 2, 'si_MO63MGY5UnNiIE', 'prod_MMFHUSYYYCv3dw', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, '2022-09-07 03:14:00', '2022-09-07 03:14:00'), (3, 3, 'si_MQPjU5qzYPlFGj', 'prod_MMFHUSYYYCv3dw', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, '2022-09-13 07:41:38', '2022-09-13 07:41:38'), (4, 4, 'si_MRX9iOArGFIuH4', 'prod_MMFHUSYYYCv3dw', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, '2022-09-16 07:26:05', '2022-09-16 07:26:05'), (5, 5, 'si_MTNga2PUHtEZyF', 'prod_MMFHUSYYYCv3dw', 'price_1LdWnAFrptn7tD2nhBK5qvtA', 1, '2022-09-21 05:46:57', '2022-09-21 05:46:57'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `first_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone_number` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `profile_picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role_id` bigint(20) UNSIGNED NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `stripe_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `pm_last_four` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `trial_ends_at` timestamp NULL DEFAULT NULL, `is_one_time` tinyint(1) NOT NULL DEFAULT 0, `hear_from` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `referrer_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `email_verified_at`, `username`, `password`, `phone_number`, `profile_picture`, `role_id`, `remember_token`, `deleted_at`, `created_at`, `updated_at`, `stripe_id`, `pm_type`, `pm_last_four`, `trial_ends_at`, `is_one_time`, `hear_from`, `referrer_id`) VALUES (1, 'Lawrence', 'Weimann', 'admin@example.com', '2022-08-29 04:17:31', 'Mr. Seamus Kling V', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+1-757-523-3419', NULL, 1, 'qfAjV2fMuofa8h4JOrwF1zHtABjMgtlHcK6qQM5luUOkJnbCMRUAskFZuh3s', NULL, '2022-08-29 04:17:31', '2022-08-29 04:17:31', NULL, NULL, NULL, NULL, 0, NULL, NULL), (2, 'Geovanni', 'Mosciski', 'user@example.net', '2022-08-29 04:17:31', 'Ahmed Bechtelar', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', '+1-530-402-9403', NULL, 2, 'JLqUjUcJnUoPTJ3RdpQUsOUuGLfiLt1GcAWbC69LHmwSnQC6MzoMTOhMUz0p', NULL, '2022-08-29 04:17:31', '2022-08-29 04:17:31', NULL, NULL, NULL, NULL, 0, NULL, NULL), (3, 'Leo', 'Messi', 'leo@gmail.com', NULL, 'leo', '$2y$10$eW9kcD5CdljhN6wFZfVhSOm0uxrqZmLRw.Mi683BPORvsF5PjJP/6', '7895869685', NULL, 2, NULL, NULL, '2022-09-01 05:07:31', '2022-09-01 05:07:31', NULL, NULL, NULL, NULL, 0, NULL, NULL), (4, 'Ronaldo', 'Christan', 'ronaldo@gmail.com', '2022-09-01 06:21:24', 'Ronaldo', '$2y$10$YEwnlM37FDlYesolUGE0r.VqmmtLfKhHbT70Y4dm1mJ1x4/53IRiq', '7985669859', NULL, 2, NULL, NULL, '2022-09-01 06:02:32', '2022-09-01 06:21:24', NULL, NULL, NULL, NULL, 0, NULL, NULL), (5, 'Uttam', 'Kumar', 'uttam@gmail.com', '2022-09-01 06:13:18', 'uttam', '$2y$10$a1YIt99Q.y2un2h9fRIi9OSMxhkoG9jKfxxxTSK7u3qI527jGjWMi', '7896859685', NULL, 2, NULL, NULL, '2022-09-01 06:08:33', '2022-09-01 06:13:18', NULL, NULL, NULL, NULL, 0, NULL, NULL), (6, 'Joe', 'root', 'joe@example.com', NULL, 'jeo', '$2y$10$Dd2jzjawb8R/lWkf/eyVl.avAdVrQqbVCCKxHs.3/KNH3Lj7EZeYe', '7895846985', NULL, 2, NULL, NULL, '2022-09-02 04:58:59', '2022-09-02 04:58:59', NULL, NULL, NULL, NULL, 0, NULL, NULL), (7, 'John', 'Moxli', 'moxli@gmail.com', '2022-09-04 23:48:10', 'Moxli', '$2y$10$4IKefU6e.12oJrwBTpn.YeKGvn00/ovrux3C16pRuqVitOOGnYWF.', '7485968526', NULL, 2, NULL, NULL, '2022-09-02 05:01:39', '2022-09-04 23:48:10', 'cus_MMFsFPzwtBvHvw', 'visa', '4242', NULL, 0, NULL, NULL), (8, 'Idona', 'Bowen', 'zofako@mailinator.com', NULL, 'lowyryfiw', '$2y$10$.Ge9Hxnju4ndLZ/tGMr.YeEJIRD3fc4ZWyppwFJeoBfXwP7xG0JjW', '123984-9474', NULL, 2, NULL, NULL, '2022-09-05 01:25:23', '2022-09-05 01:25:23', NULL, NULL, NULL, NULL, 0, NULL, NULL), (9, 'Ivory', 'Velazquez', 'gukidamo@mailinator.com', NULL, 'rogasa', '$2y$10$Ju8IElnuILSOGtx5nzf08eCBeZ/xhrhMKd07nGn3btME1R1pCwGTm', '25786-1172', NULL, 2, NULL, NULL, '2022-09-05 01:26:49', '2022-09-05 01:26:49', NULL, NULL, NULL, NULL, 0, NULL, NULL), (10, 'Herman', 'Jensen', 'xyxoxubixi@mailinator.com', NULL, 'ziguzazib', '$2y$10$KuSTK3nN/9km0wIni86iE.qM9jF0QTpX0zVtd6hOpeUPAdfDZRmN.', '156433-8199', NULL, 2, NULL, NULL, '2022-09-05 01:28:37', '2022-09-05 01:28:37', NULL, NULL, NULL, NULL, 0, NULL, NULL), (11, 'my first name', 'my last name', 'me@mydomain.com', '2022-09-05 02:21:14', 'my-user-name', '$2y$10$0gQGjJBt1Veoy4oiCWoUC.BlEcGf5epRPl2QDLPqtVs3ljNjCnXIO', '1-456-7890', NULL, 2, NULL, NULL, '2022-09-05 02:19:42', '2022-09-05 02:21:14', NULL, NULL, NULL, NULL, 0, NULL, NULL), (12, 'Antony', 'Gonjalez', 'lojovikeru@mailinator.com', NULL, 'gagalus', '$2y$10$jbqhdtfXVDlUU3AVQ9NZ0uf/BdaMBnEW64gwPnwUqS4T2fHJk9Y3a', '12976-2003', '6318764f56e2a.png', 2, NULL, NULL, '2022-09-07 03:11:53', '2022-09-07 06:05:39', 'cus_MO63DngJu5syGR', 'visa', '4242', NULL, 0, NULL, NULL), (13, 'Winifred', 'Battle', 'hosokepocu@mailinator.com', NULL, 'fyxaddd', '$2y$10$WdshB9pxUstua8aKjDXNQeiaTwVJSp3kjizhQs70sQXLQM8nap.IC', '478-1591', '632c513a5aacd.jpg', 2, NULL, NULL, '2022-09-09 06:42:30', '2022-09-22 06:42:42', 'cus_MQPjfAFbpbtGNe', 'visa', '4242', NULL, 0, NULL, NULL), (14, 'Graiden', 'Cox', 'zygeperyke@mailinator.com', NULL, 'vabahogin', '$2y$10$zu9YPDZ7pGs7MTcd7fWFWOvQph9qCLCopaMAzjt0SagnbdEQgXNk.', '619-5787', NULL, 2, 'z88srDRnTMGX3VdQzyjTl60SMnbIwX4vX12X7RJ9jLiW7Tm4L0kDwLUCFAMo', NULL, '2022-09-13 00:25:46', '2022-09-16 00:57:06', NULL, NULL, NULL, NULL, 0, NULL, NULL), (15, 'Bradley', 'Oneill', 'haduje@mailinator.com', NULL, 'nedigobaq', '$2y$10$0Bc9dC6IHqjb8R2liNwAmOZJpKMuQYrcV3DVUiNSeH/GKLd.iBx1e', '533-2229', NULL, 2, NULL, NULL, '2022-09-13 01:16:48', '2022-09-13 01:16:48', NULL, NULL, NULL, NULL, 1, NULL, NULL), (16, 'Jordan', 'Tyler', 'pivucisor@mailinator.com', NULL, 'padimihiky', '$2y$10$xf/ZmMtLLO1Y9Ld6KoajI.A9VzxmRpn9LU9oGy6mfEfjfP0Ufbe.a', '407-7332', NULL, 2, NULL, NULL, '2022-09-13 01:51:57', '2022-09-13 01:51:57', NULL, NULL, NULL, NULL, 1, NULL, NULL), (17, 'Benjamin', 'Hubbard', 'jybiwafeb@mailinator.com', NULL, 'dyzehuhah', '$2y$10$wGnaCgXpY/2oCYe3H8EpluQXtVZAlozMRG5RkCfmdJCgry5KyFHSe', '765-1122', NULL, 2, NULL, NULL, '2022-09-13 02:02:36', '2022-09-13 02:02:36', NULL, NULL, NULL, NULL, 0, NULL, NULL), (18, 'Stacy', 'Snider', 'fity@mailinator.com', NULL, 'pavixa', '$2y$10$7a2du2k1UNjxpwlhgbGddOjUybPsDFHtSqc7K4UEjMtaD9otU4FRe', '171-8953', NULL, 2, NULL, NULL, '2022-09-13 02:04:20', '2022-09-13 02:04:20', NULL, NULL, NULL, NULL, 1, NULL, NULL), (19, 'Yetta', 'Salazar', 'ruquz@mailinator.com', NULL, 'xejaza', '$2y$10$460frka45HaAkf5p8RWdhOZq6A1/IYT9HQ43Lxx46FOQTIKzepNvq', '648-5843', NULL, 2, NULL, NULL, '2022-09-13 02:26:01', '2022-09-13 02:26:01', NULL, NULL, NULL, NULL, 1, NULL, NULL), (22, 'Raja', 'Frank', 'cogedokeva@mailinator.com', NULL, 'lusobim', '$2y$10$rcdF2aRamSdJqckE7fuABuntZZtmJ5IbFv6Er0hGKBBEvETevPiS.', '951-3687', '63284571030d1.jpg', 2, NULL, NULL, '2022-09-14 02:32:01', '2022-09-19 05:03:21', NULL, NULL, NULL, NULL, 1, NULL, NULL), (25, 'Nathan', 'Graham', 'mukihejyky@mailinator.com', NULL, 'fajexoty', '$2y$10$8KjtLjPKrHISgvjc09tFBOcCQI1C4yMNptzU.hPHLTWvHvCbDXvbe', '607-8131', NULL, 2, NULL, NULL, '2022-09-16 07:18:52', '2022-09-16 07:19:43', NULL, NULL, NULL, NULL, 1, NULL, NULL), (26, 'Kellie', 'Garrett', 'qadoriz@mailinator.com', NULL, 'jabeq', '$2y$10$7jAVdiXVn/VwFR1FkrEbMuxwiDJXEWl.palJDnDHZ7bwbeHop.rD6', '645-8383', NULL, 2, NULL, NULL, '2022-09-16 07:22:05', '2022-09-16 07:22:41', NULL, NULL, NULL, NULL, 1, NULL, NULL), (27, 'Jolie', 'Holt', 'beni@mailinator.com', NULL, 'ruvef', '$2y$10$XCTwVTEJTY2PMl5a.R4fDevT6rIO0BbRDNOkYvaa2n/Sn1p7uAl.C', '815-1485', NULL, 2, NULL, NULL, '2022-09-16 07:25:06', '2022-09-16 07:26:08', 'cus_MRX9znwF1yGLFi', 'visa', '4242', NULL, 0, NULL, NULL), (28, 'Whilemina', 'Goodman', 'cisomy@mailinator.com', NULL, 'ligucewu', '$2y$10$m1PQCaSZIZaaN7jjKuUJL.UffF4zms66nHDKn7eTCzWIV/Rl.981e', '697-7712', NULL, 2, NULL, NULL, '2022-09-21 05:41:31', '2022-09-21 05:47:00', 'cus_MTNgWg7AlMMb6x', 'visa', '4242', NULL, 0, NULL, NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_menus` -- ALTER TABLE `admin_menus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `admin_menu_items` -- ALTER TABLE `admin_menu_items` ADD PRIMARY KEY (`id`), ADD KEY `admin_menu_items_menu_foreign` (`menu`); -- -- Indexes for table `bank_details` -- ALTER TABLE `bank_details` ADD PRIMARY KEY (`id`), ADD KEY `bank_details_user_id_foreign` (`user_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category_movie` -- ALTER TABLE `category_movie` ADD PRIMARY KEY (`id`), ADD KEY `category_movie_category_id_foreign` (`category_id`), ADD KEY `category_movie_movie_id_foreign` (`movie_id`); -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `entertains` -- ALTER TABLE `entertains` 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 `home_config_works` -- ALTER TABLE `home_config_works` ADD PRIMARY KEY (`id`); -- -- Indexes for table `medias` -- ALTER TABLE `medias` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `media_tab_title_unique` (`tab_title`); -- -- 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 `pages` -- ALTER TABLE `pages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `pages_page_name_unique` (`page_name`), ADD UNIQUE KEY `pages_page_slug_unique` (`page_slug`); -- -- Indexes for table `page_banners` -- ALTER TABLE `page_banners` ADD PRIMARY KEY (`id`), ADD KEY `page_banners_page_id_foreign` (`page_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `payments` -- ALTER TABLE `payments` ADD PRIMARY KEY (`id`), ADD KEY `payments_user_id_foreign` (`user_id`), ADD KEY `payments_movie_id_foreign` (`movie_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 `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`), ADD KEY `reviews_user_id_foreign` (`user_id`), ADD KEY `reviews_movie_id_foreign` (`movie_id`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`); -- -- Indexes for table `site_settings` -- ALTER TABLE `site_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `subscriptions_stripe_id_unique` (`stripe_id`), ADD KEY `subscriptions_user_id_stripe_status_index` (`user_id`,`stripe_status`); -- -- Indexes for table `subscription_items` -- ALTER TABLE `subscription_items` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `subscription_items_subscription_id_stripe_price_unique` (`subscription_id`,`stripe_price`), ADD UNIQUE KEY `subscription_items_stripe_id_unique` (`stripe_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `users_username_unique` (`username`), ADD KEY `users_role_id_foreign` (`role_id`), ADD KEY `users_stripe_id_index` (`stripe_id`), ADD KEY `users_referrer_id_foreign` (`referrer_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_menus` -- ALTER TABLE `admin_menus` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `admin_menu_items` -- ALTER TABLE `admin_menu_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `bank_details` -- ALTER TABLE `bank_details` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `category_movie` -- ALTER TABLE `category_movie` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `entertains` -- ALTER TABLE `entertains` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- 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=10; -- -- AUTO_INCREMENT for table `home_config_works` -- ALTER TABLE `home_config_works` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `medias` -- ALTER TABLE `medias` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75; -- -- AUTO_INCREMENT for table `movies` -- ALTER TABLE `movies` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `pages` -- ALTER TABLE `pages` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `page_banners` -- ALTER TABLE `page_banners` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `payments` -- ALTER TABLE `payments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- 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 `reviews` -- ALTER TABLE `reviews` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `site_settings` -- ALTER TABLE `site_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `subscription_items` -- ALTER TABLE `subscription_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- Constraints for dumped tables -- -- -- Constraints for table `admin_menu_items` -- ALTER TABLE `admin_menu_items` ADD CONSTRAINT `admin_menu_items_menu_foreign` FOREIGN KEY (`menu`) REFERENCES `admin_menus` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `bank_details` -- ALTER TABLE `bank_details` ADD CONSTRAINT `bank_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `category_movie` -- ALTER TABLE `category_movie` ADD CONSTRAINT `category_movie_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `category_movie_movie_id_foreign` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE; -- -- Constraints for table `page_banners` -- ALTER TABLE `page_banners` ADD CONSTRAINT `page_banners_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`); -- -- Constraints for table `payments` -- ALTER TABLE `payments` ADD CONSTRAINT `payments_movie_id_foreign` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `reviews` -- ALTER TABLE `reviews` ADD CONSTRAINT `reviews_movie_id_foreign` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`); 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 */;
[+]
..
[-] wp-blog-header.php
[edit]
[-] admin.php
[edit]
[-] mogul_23_09.zip
[edit]
[-] mogul_23_09.sql
[edit]
[-] .htaccess
[edit]
[-] mogul_24_09.zip
[edit]
[-] wp-cron.php
[edit]