Welcome to MXCloud , we value your privacy and strive to protect your personal information. This Privacy Policy outlines the types of data we collect, how we use and protect it, and your rights regarding your personal information.
We may collect various types of information from you, including:
Personal Information: When you register for an account, place an order, subscribe to our newsletter, or interact with our website, we may collect personal information such as your name, email address, postal address, phone number, and payment information.
Usage Data: We may automatically collect information about how you use our website, including your IP address, browser type, operating system, referring URLs, access times, and pages viewed.
Cookies and Tracking Technologies: We use cookies and similar tracking technologies to enhance your browsing experience and collect data about your interactions with our website.
We use the collected information for various purposes, including:
Providing and improving our services to you.
Processing your orders and payments.
Sending you newsletters and promotional materials.
Analyzing website usage and trends to enhance user experience.
Responding to your inquiries and providing customer support.
Protecting our legal rights and preventing fraud.
We may share your personal information with:
Third-party service providers who assist us in operating our website and delivering services to you.
Legal authorities when required by law or to protect our rights and safety.
We do not sell, rent, or trade your personal information to third parties for marketing purposes.
You have the right to:
Access, correct, or delete your personal information.
Withdraw your consent for processing your data.
Object to processing of your personal data.
Lodge a complaint with a supervisory authority.
We take reasonable measures to protect your personal information from unauthorized access, alteration, or disclosure. However, no data transmission over the internet or storage system can be guaranteed to be 100% secure.
Our services are not intended for children under the age of 13. We do not knowingly collect or maintain personal information from children.
We may update our Privacy Policy from time to time. Any changes will be posted on this page, and the \"Last updated\" date will be revised accordingly.
If you have any questions, concerns, or requests regarding your personal information or our Privacy Policy, please contact us at .
', 'privacy-policy', NULL, 'default', '2023-10-24 13:00:53', '2024-05-28 09:23:44', NULL, 0, NULL), (2, 'Terms of Service', 'Welcome to MXCloud. By accessing and using our website, you agree to comply with and be bound by the following Terms of Service. Please read these terms carefully before using our services.
By using our website, you acknowledge that you have read, understood, and agree to abide by these Terms of Service. If you do not agree with these terms, please do not use our services.
You may use our website and services only for lawful purposes and in compliance with all applicable laws and regulations. You agree not to engage in any activity that may disrupt or interfere with the functioning of our website.
If you create an account on our website, you are responsible for maintaining the confidentiality of your account information and password. You agree to notify us immediately of any unauthorized use of your account.
Any content you submit to our website, including text, images, and other materials, must comply with our content guidelines. You retain ownership of your content, but you grant us a non-exclusive, royalty-free license to use, reproduce, and distribute your content on our platform.
Unless otherwise stated, all content and materials on our website are the property of [Website Name] and are protected by copyright, trademark, and other intellectual property laws.
Our website is provided \"as is\" and \"as available\" without any warranties of any kind, whether express or implied. We do not guarantee the accuracy, completeness, or reliability of any content or materials on our website.
We shall not be liable for any indirect, incidental, special, consequential, or punitive damages arising out of or relating to your use of our website.
These Terms of Service shall be governed by and construed in accordance with the laws of [Your Country/State], without regard to its conflict of law principles.
We reserve the right to modify or update these Terms of Service at any time. It is your responsibility to review these terms periodically. Your continued use of our website after any changes signifies your acceptance of the modified terms.
If you have any questions or concerns regarding these Terms of Service, please contact us at .
', 'terms-of-service', NULL, 'default', '2023-10-24 13:00:53', '2024-05-28 09:24:10', NULL, 0, NULL), (3, 'About Us', 'MXCloud is a versatile cloud computing platform designed to streamline business operations through comprehensive solutions in data storage, application deployment, and IT infrastructure management. It offers a robust and scalable environment tailored for enterprises of all sizes, ensuring flexibility and efficiency in handling complex workflows and large datasets.
One of MXCloud’s standout features is its seamless integration with various third-party applications and services, enabling businesses to create a cohesive ecosystem. This interoperability ensures that organizations can leverage their existing tools while capitalizing on MXCloud’s advanced capabilities.
Security is a top priority for MXCloud, providing multi-layered protection measures, including encryption, identity management, and compliance with industry standards such as GDPR and HIPAA. This ensures that sensitive data remains secure and accessible only to authorized users.
The platform supports a range of deployment models, including public, private, and hybrid clouds, allowing businesses to choose the best configuration for their specific needs. MXCloud’s intuitive management interface simplifies the administration of resources, while its powerful analytics tools provide actionable insights to drive informed decision-making.
Additionally, MXCloud’s support for automation and artificial intelligence helps businesses optimize their operations, reduce costs, and improve productivity. With features like automated scaling, predictive maintenance, and intelligent resource allocation, organizations can achieve higher levels of efficiency and agility.
In summary, MXCloud offers a comprehensive, secure, and flexible cloud computing solution designed to meet the diverse needs of modern businesses. Its integration capabilities, robust security measures, and advanced features position it as a valuable asset for any organization looking to enhance its IT infrastructure and drive growth.
', 'about-us', NULL, 'default', '2023-10-24 13:00:53', '2024-05-28 09:23:27', NULL, 0, NULL); -- -------------------------------------------------------- -- -- 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 `fcm_tokens` -- CREATE TABLE `fcm_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `device_id` varchar(40) NOT NULL, `token` varchar(180) NOT NULL, `user_id` int(10) 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 `file_entries` -- CREATE TABLE `file_entries` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `description` varchar(150) DEFAULT NULL, `file_name` varchar(50) NOT NULL, `mime` varchar(100) DEFAULT NULL, `file_size` bigint(20) UNSIGNED NOT NULL DEFAULT 0, `user_id` int(11) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `path` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `disk_prefix` varchar(191) DEFAULT NULL, `type` varchar(20) DEFAULT NULL, `extension` varchar(10) DEFAULT NULL, `public` tinyint(1) NOT NULL DEFAULT 0, `preview_token` varchar(15) DEFAULT NULL, `thumbnail` tinyint(1) NOT NULL DEFAULT 0, `workspace_id` int(10) UNSIGNED DEFAULT NULL, `owner_id` bigint(20) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `file_entries` -- INSERT INTO `file_entries` (`id`, `name`, `description`, `file_name`, `mime`, `file_size`, `user_id`, `parent_id`, `created_at`, `updated_at`, `deleted_at`, `path`, `disk_prefix`, `type`, `extension`, `public`, `preview_token`, `thumbnail`, `workspace_id`, `owner_id`) VALUES (1, '512.png', NULL, 'ad3f270e-256a-468a-a8ba-b3afdb2bf637.png', 'image/png', 37564, NULL, NULL, '2023-10-24 13:10:00', '2023-10-24 13:10:00', NULL, NULL, 'branding_media', 'image', 'png', 1, NULL, 0, 0, 1), (2, 'logo.png', NULL, 'e5e4b0db-2750-4540-9a38-90cfd588b30b.png', 'image/png', 32134, NULL, NULL, '2023-10-24 13:10:06', '2023-10-24 13:10:06', NULL, NULL, 'branding_media', 'image', 'png', 1, NULL, 0, 0, 1), (3, 'logo.png', NULL, 'c0bfd80b-c3c4-44d0-b726-63ddd89a911b.png', 'image/png', 32134, NULL, NULL, '2023-10-24 13:10:15', '2023-10-24 13:10:15', NULL, NULL, 'branding_media', 'image', 'png', 1, NULL, 0, 0, 1), (4, 'logo.png', NULL, '15be993b-745c-4608-b56f-fe080701eb02.png', 'image/png', 32134, NULL, NULL, '2023-10-24 13:10:19', '2023-10-24 13:10:19', NULL, NULL, 'branding_media', 'image', 'png', 1, NULL, 0, 0, 1), (5, 'logo.png', NULL, '462c3637-b016-4438-a8fb-a0af69d19a99.png', 'image/png', 32134, NULL, NULL, '2023-10-24 13:10:23', '2023-10-24 13:10:23', NULL, NULL, 'branding_media', 'image', 'png', 1, NULL, 0, 0, 1), (6, 'Demo', NULL, 'Demo', NULL, 0, NULL, NULL, '2023-10-24 13:16:04', '2023-10-24 13:16:04', NULL, '6', NULL, 'folder', NULL, 0, NULL, 0, 0, 2), (7, 'logo.png', NULL, '80bf2a19-0fda-47e7-8e8c-1daec655db70', 'image/png', 61029, NULL, NULL, '2023-10-24 13:16:16', '2024-06-28 10:51:56', '2024-06-28 10:51:56', '7', '80bf2a19-0fda-47e7-8e8c-1daec655db70', 'image', 'png', 0, NULL, 0, 0, 2), (8, 'sample-5s.mp4', NULL, '348e03ba-6635-46ca-ad28-077c79c06092', 'video/mp4', 2848208, NULL, NULL, '2023-10-24 13:16:25', '2023-10-24 13:16:25', NULL, '8', '348e03ba-6635-46ca-ad28-077c79c06092', 'video', 'mp4', 0, NULL, 0, 0, 2), (9, 'Xuldime Marketplace.docx', NULL, 'd1d7fa4a-8a36-401f-89a0-a4065d300bd2', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 15421, NULL, NULL, '2023-10-24 13:16:37', '2023-10-24 13:16:42', NULL, '9', 'd1d7fa4a-8a36-401f-89a0-a4065d300bd2', 'word', 'docx', 0, 'MKqgwfVODp0vJo2', 0, 0, 2), (11, 'Hero_FreeCloudStorage_2x_RE4HSJi.png', NULL, 'e7e89653-318c-41fb-843a-5939004bf6a3.png', 'image/png', 161229, NULL, NULL, '2023-10-25 01:41:19', '2023-10-25 01:41:19', NULL, NULL, 'homepage', 'image', 'png', 1, NULL, 0, 0, 1), (12, 'hkcert-Cloud Storage Security banner-1860x1046.jpg', NULL, '755b5848-5aee-4335-ad07-20b3fbdd8763.jpg', 'image/jpeg', 74140, NULL, NULL, '2023-10-25 01:41:29', '2023-10-25 01:41:29', NULL, NULL, 'homepage', 'image', 'jpg', 1, NULL, 0, 0, 1), (13, 'instructor.png', NULL, '5aa4ea5f-6405-45a7-af3d-85f8332d66e4', 'image/png', 37364, NULL, NULL, '2024-06-28 10:51:47', '2024-06-28 10:52:00', '2024-06-28 10:52:00', 'd', '5aa4ea5f-6405-45a7-af3d-85f8332d66e4', 'image', 'png', 0, NULL, 0, 0, 2); -- -------------------------------------------------------- -- -- Table structure for table `file_entry_models` -- CREATE TABLE `file_entry_models` ( `id` int(10) UNSIGNED NOT NULL, `file_entry_id` int(10) UNSIGNED NOT NULL, `model_id` int(10) UNSIGNED NOT NULL, `model_type` varchar(60) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `owner` tinyint(1) NOT NULL DEFAULT 0, `permissions` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `file_entry_models` -- INSERT INTO `file_entry_models` (`id`, `file_entry_id`, `model_id`, `model_type`, `created_at`, `updated_at`, `owner`, `permissions`) VALUES (1, 1, 1, 'user', '2023-10-24 13:10:00', '2023-10-24 13:10:00', 1, NULL), (2, 2, 1, 'user', '2023-10-24 13:10:06', '2023-10-24 13:10:06', 1, NULL), (3, 3, 1, 'user', '2023-10-24 13:10:15', '2023-10-24 13:10:15', 1, NULL), (4, 4, 1, 'user', '2023-10-24 13:10:19', '2023-10-24 13:10:19', 1, NULL), (5, 5, 1, 'user', '2023-10-24 13:10:23', '2023-10-24 13:10:23', 1, NULL), (6, 6, 2, 'user', '2023-10-24 13:16:04', '2023-10-24 13:16:04', 1, NULL), (7, 7, 2, 'user', '2023-10-24 13:16:16', '2023-10-24 13:16:16', 1, NULL), (8, 8, 2, 'user', '2023-10-24 13:16:25', '2023-10-24 13:16:25', 1, NULL), (9, 9, 2, 'user', '2023-10-24 13:16:37', '2023-10-24 13:16:37', 1, NULL), (11, 11, 1, 'user', '2023-10-25 01:41:19', '2023-10-25 01:41:19', 1, NULL), (12, 12, 1, 'user', '2023-10-25 01:41:30', '2023-10-25 01:41:30', 1, NULL), (13, 13, 2, 'user', '2024-06-28 10:51:47', '2024-06-28 10:51:47', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `folders` -- CREATE TABLE `folders` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `description` varchar(150) DEFAULT NULL, `path` text DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `folder_id` int(11) DEFAULT NULL, `share_id` varchar(20) NOT NULL, `password` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `follows` -- CREATE TABLE `follows` ( `id` int(10) UNSIGNED NOT NULL, `follower_id` int(11) NOT NULL, `followed_id` int(11) 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 `invoices` -- CREATE TABLE `invoices` ( `id` int(10) UNSIGNED NOT NULL, `subscription_id` int(11) NOT NULL, `paid` tinyint(1) NOT NULL, `uuid` varchar(10) NOT NULL, `notes` 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 `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 `localizations` -- CREATE TABLE `localizations` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `language` varchar(5) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `localizations` -- INSERT INTO `localizations` (`id`, `name`, `created_at`, `updated_at`, `language`) VALUES (1, 'English', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'en'); -- -------------------------------------------------------- -- -- 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, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1), (4, '2015_04_127_156842_create_social_profiles_table', 1), (5, '2015_04_127_156842_create_users_oauth_table', 1), (6, '2015_04_13_140047_create_files_models_table', 1), (7, '2015_04_18_134312_create_folders_table', 1), (8, '2015_05_29_131549_create_settings_table', 1), (9, '2015_10_23_164355_create_follows_table', 1), (10, '2016_04_06_140017_add_folder_id_index_to_files_table', 1), (11, '2016_05_12_190852_create_tags_table', 1), (12, '2016_05_12_190958_create_taggables_table', 1), (13, '2016_05_26_170044_create_uploads_table', 1), (14, '2016_05_27_143158_create_uploadables_table', 1), (15, '2016_07_14_153703_create_groups_table', 1), (16, '2016_07_14_153921_create_user_group_table', 1), (17, '2016_10_17_152159_add_space_available_column_to_users_table', 1), (18, '2017_07_02_120142_create_pages_table', 1), (19, '2017_07_11_122825_create_localizations_table', 1), (20, '2017_08_26_131330_add_private_field_to_settings_table', 1), (21, '2017_09_17_144728_add_columns_to_users_table', 1), (22, '2017_09_17_152854_make_password_column_nullable', 1), (23, '2017_09_30_152855_make_settings_value_column_nullable', 1), (24, '2017_10_01_152897_add_public_column_to_uploads_table', 1), (25, '2017_12_04_132911_add_avatar_column_to_users_table', 1), (26, '2018_01_10_140732_create_subscriptions_table', 1), (27, '2018_01_10_140746_add_billing_to_users_table', 1), (28, '2018_01_10_161706_create_billing_plans_table', 1), (29, '2018_06_05_142932_rename_files_table_to_file_entries', 1), (30, '2018_06_06_141629_rename_file_entries_table_columns', 1), (31, '2018_06_07_141630_merge_files_and_folders_tables', 1), (32, '2018_07_03_114346_create_shareable_links_table', 1), (33, '2018_07_24_113757_add_available_space_to_billing_plans_table', 1), (34, '2018_07_24_124254_add_available_space_to_users_table', 1), (35, '2018_07_26_142339_rename_groups_to_roles', 1), (36, '2018_07_26_142842_rename_user_role_table_columns_to_roles', 1), (37, '2018_08_07_124200_rename_uploads_to_file_entries', 1), (38, '2018_08_07_124327_refactor_file_entries_columns', 1), (39, '2018_08_07_130653_add_folder_path_column_to_file_entries_table', 1), (40, '2018_08_07_140328_delete_legacy_root_folders', 1), (41, '2018_08_07_140330_move_folders_into_file_entries_table', 1), (42, '2018_08_07_140440_migrate_file_entry_users_to_many_to_many', 1), (43, '2018_08_10_142251_update_users_table_to_v2', 1), (44, '2018_08_15_132225_move_uploads_into_subfolders', 1), (45, '2018_08_16_111525_transform_file_entries_records_to_v2', 1), (46, '2018_08_31_104145_rename_uploadables_table', 1), (47, '2018_08_31_104325_rename_file_entry_models_table_columns', 1), (48, '2018_11_26_171703_add_type_and_title_columns_to_pages_table', 1), (49, '2018_12_01_144233_change_unique_index_on_tags_table', 1), (50, '2019_02_16_150049_delete_old_seo_settings', 1), (51, '2019_02_24_141457_create_jobs_table', 1), (52, '2019_03_11_162627_add_preview_token_to_file_entries_table', 1), (53, '2019_03_12_160803_add_thumbnail_column_to_file_entries_table', 1), (54, '2019_03_16_161836_add_paypal_id_column_to_billing_plans_table', 1), (55, '2019_05_14_120930_index_description_column_in_file_entries_table', 1), (56, '2019_06_08_120504_create_custom_domains_table', 1), (57, '2019_06_13_140318_add_user_id_column_to_pages_table', 1), (58, '2019_06_15_114320_rename_pages_table_to_custom_pages', 1), (59, '2019_06_18_133933_create_permissions_table', 1), (60, '2019_06_18_134203_create_permissionables_table', 1), (61, '2019_06_18_135822_rename_permissions_columns', 1), (62, '2019_07_08_122001_create_css_themes_table', 1), (63, '2019_07_20_141752_create_invoices_table', 1), (64, '2019_08_19_121112_add_global_column_to_custom_domains_table', 1), (65, '2019_09_13_141123_change_plan_amount_to_float', 1), (66, '2019_10_14_171943_add_index_to_username_column', 1), (67, '2019_10_20_143522_create_comments_table', 1), (68, '2019_10_23_134520_create_notifications_table', 1), (69, '2019_11_21_144956_add_resource_id_and_type_to_custom_domains_table', 1), (70, '2019_12_14_000001_create_personal_access_tokens_table', 1), (71, '2019_12_14_194512_rename_public_path_column_to_disk_prefix', 1), (72, '2019_12_24_165237_change_file_size_column_default_value_to_0', 1), (73, '2019_12_28_190836_update_file_entry_models_table_to_v2', 1), (74, '2019_12_28_191105_move_user_file_entry_table_records_to_file_entry_models', 1), (75, '2020_01_26_143733_create_notification_subscriptions_table', 1), (76, '2020_03_03_140720_add_language_col_to_localizations_table', 1), (77, '2020_03_03_143142_add_lang_code_to_existing_localizations', 1), (78, '2020_04_14_163347_add_hidden_column_to_plans_table', 1), (79, '2020_06_27_180040_add_verified_at_column_to_users_table', 1), (80, '2020_06_27_180253_move_confirmed_column_to_email_verified_at', 1), (81, '2020_07_15_144024_fix_issues_with_migration_to_laravel_7', 1), (82, '2020_07_22_165126_create_workspaces_table', 1), (83, '2020_07_23_145652_create_workspace_invites_table', 1), (84, '2020_07_23_164502_create_workspace_user_table', 1), (85, '2020_07_26_165349_add_columns_to_roles_table', 1), (86, '2020_07_29_141418_add_workspace_id_column_to_workspaceable_models', 1), (87, '2020_07_30_152330_add_type_column_to_permissions_table', 1), (88, '2020_08_29_165057_add_hide_nav_column_to_custom_pages_table', 1), (89, '2020_12_14_155112_create_table_fcm_tokens', 1), (90, '2020_12_17_124109_subscribe_users_to_notifications', 1), (91, '2021_04_22_172459_add_internal_columm_to_roles_table', 1), (92, '2021_05_03_173446_add_deleted_column_to_comments_table', 1), (93, '2021_05_12_164940_add_advanced_column_to_permissions_table', 1), (94, '2021_06_04_143405_add_workspace_id_col_to_custom_domains_table', 1), (95, '2021_06_04_143406_add_workspace_id_col_to_custom_pages_table', 1), (96, '2021_06_04_143406_add_workspace_id_col_to_file_entries_table', 1), (97, '2021_06_05_182202_create_csv_exports_table', 1), (98, '2021_06_18_161030_rename_gateway_col_in_subscriptions_table', 1), (99, '2021_06_19_111939_add_owner_id_column_to_file_entries_table', 1), (100, '2021_06_19_112035_materialize_owner_id_in_file_entries_table', 1), (101, '2021_07_06_144837_migrate_landing_page_config_to_20', 1), (102, '2021_07_17_093454_add_created_at_col_to_user_role_table', 1), (103, '2021_09_30_123758_slugify_tag_name_column', 1), (104, '2021_10_13_132915_add_token_cols_to_social_profiles_table', 1), (105, '2022_04_08_122553_change_default_workspace_id_from_null_to_zero', 1), (106, '2022_04_23_115027_add_id_to_all_menus', 1), (107, '2022_07_30_181012_transform_landing_page_cta', 1), (108, '2022_08_10_200344_add_produce_id_column_to_subscriptions_table', 1), (109, '2022_08_11_160401_create_prices_table', 1), (110, '2022_08_11_170041_create_products_table', 1), (111, '2022_08_11_170117_move_billing_plans_to_products_and_prices_tables', 1), (112, '2022_08_17_184337_add_card_expires_column_to_users_table', 1), (113, '2022_08_20_125319_add_paypal_id_to_users_table', 1), (114, '2022_08_24_192127_migrate_common_settings_to_v3', 1), (115, '2022_09_03_164633_add_expires_at_column_to_personal_access_tokens_table', 1), (116, '2022_09_27_124344_change_available_space_column_to_big_int', 1), (117, '2022_09_28_121423_migrate_notif_settings_from_array_to_obj', 1), (118, '2022_11_06_115107_increase_file_name_column_length', 1), (119, '2023_03_17_175502_add_user_id_to_tags_table', 1), (120, '2023_03_17_180355_change_name_index_to_name_user_id_in_tags_table', 1), (121, '2023_05_09_124348_create_bans_table', 1), (122, '2023_05_09_133514_add_banned_at_column_to_users_table', 1), (123, '2023_05_11_200001_add_two_factor_columns_to_users_table', 1), (124, '2023_05_13_132948_active_sessions_table', 1), (125, '2023_05_16_150805_change_social_profiles_token_length', 1), (126, '2023_06_10_131615_add_pos_and_neg_votes_to_comments_table', 1), (127, '2023_06_10_132135_add_comment_ratings_table', 1), (128, '2023_06_11_124655_create_comment_reports_table', 1), (129, '2023_08_08_103123_add_timestamp_indexes_to_comments_table', 1), (130, '2023_08_31_124910_update_model_types_from_namespace_to_string', 2), (131, '2023_09_14_172633_create_failed_jobs_table', 2); -- -------------------------------------------------------- -- -- Table structure for table `notifications` -- CREATE TABLE `notifications` ( `id` char(36) NOT NULL, `type` varchar(191) NOT NULL, `notifiable_type` varchar(191) NOT NULL, `notifiable_id` bigint(20) UNSIGNED NOT NULL, `data` text NOT NULL, `read_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 `notification_subscriptions` -- CREATE TABLE `notification_subscriptions` ( `id` char(36) NOT NULL, `notif_id` varchar(5) NOT NULL, `user_id` int(11) NOT NULL, `channels` varchar(191) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `notification_subscriptions` -- INSERT INTO `notification_subscriptions` (`id`, `notif_id`, `user_id`, `channels`) VALUES ('0793a7cc-1ea0-48b6-8cac-f56ef4d6c0a7', 'W01', 3, '{\"email\":true,\"browser\":true,\"mobile\":true}'), ('145e32d3-228a-49bf-83ca-37f73d878b5a', 'A01', 3, '{\"email\":true,\"browser\":true,\"mobile\":true}'), ('723811ab-6480-446e-ab2d-a8279d4f837f', 'A01', 2, '{\"email\":true,\"browser\":true,\"mobile\":true}'), ('bdb004bd-2d1a-42c4-9e0f-bca1c2cd630c', 'W01', 2, '{\"email\":true,\"browser\":true,\"mobile\":true}'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `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 `permissionables` -- CREATE TABLE `permissionables` ( `id` int(10) UNSIGNED NOT NULL, `permission_id` int(11) NOT NULL, `permissionable_id` int(11) NOT NULL, `permissionable_type` varchar(40) NOT NULL, `restrictions` text DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `permissionables` -- INSERT INTO `permissionables` (`id`, `permission_id`, `permissionable_id`, `permissionable_type`, `restrictions`) VALUES (1, 1, 1, 'user', NULL), (2, 4, 1, 'role', '[]'), (3, 9, 1, 'role', '[]'), (4, 18, 1, 'role', '[]'), (5, 22, 1, 'role', '[]'), (6, 26, 1, 'role', '[]'), (7, 32, 1, 'role', '[]'), (8, 37, 1, 'role', '[]'), (9, 42, 1, 'role', '[]'), (10, 48, 1, 'role', '[]'), (11, 49, 1, 'role', '[]'), (12, 52, 1, 'role', '[]'), (13, 9, 2, 'role', '[]'), (14, 48, 2, 'role', '[]'), (15, 26, 2, 'role', '[]'), (16, 32, 2, 'role', '[]'), (17, 37, 2, 'role', '[]'), (18, 22, 2, 'role', '[]'), (19, 17, 3, 'role', NULL), (20, 18, 3, 'role', NULL), (21, 19, 3, 'role', NULL), (22, 20, 3, 'role', NULL), (23, 21, 3, 'role', NULL), (24, 45, 3, 'role', NULL), (25, 46, 3, 'role', NULL), (26, 47, 3, 'role', NULL), (27, 17, 4, 'role', NULL), (28, 18, 4, 'role', NULL), (29, 19, 4, 'role', NULL), (30, 20, 4, 'role', NULL), (31, 21, 4, 'role', NULL), (32, 17, 5, 'role', NULL), (33, 52, 6, 'role', '[]'), (34, 48, 6, 'role', '[]'), (35, 49, 6, 'role', '[]'), (36, 41, 6, 'role', '[]'), (37, 42, 6, 'role', '[{\"name\":\"count\",\"value\":20},{\"name\":\"member_count\",\"value\":20}]'), (38, 37, 6, 'role', '[]'), (39, 38, 6, 'role', '[]'), (40, 36, 6, 'role', '[]'), (41, 32, 6, 'role', '[]'), (42, 33, 6, 'role', '[]'), (43, 30, 6, 'role', '[]'), (44, 26, 6, 'role', '[]'), (45, 27, 6, 'role', '[]'), (46, 22, 6, 'role', '[]'), (47, 23, 6, 'role', '[]'), (48, 17, 6, 'role', '[]'), (49, 18, 6, 'role', '[]'), (50, 9, 6, 'role', '[]'), (51, 10, 6, 'role', '[{\"name\":\"count\",\"value\":20}]'), (52, 22, 3, 'user', '[]'), (53, 41, 3, 'user', '[]'), (54, 42, 3, 'user', '[{\"name\":\"count\",\"value\":20},{\"name\":\"member_count\",\"value\":19}]'), (55, 48, 3, 'user', '[]'), (56, 49, 3, 'user', '[]'), (57, 52, 3, 'user', '[]'), (58, 23, 3, 'user', '[]'), (59, 26, 3, 'user', '[]'), (60, 27, 3, 'user', '[]'), (61, 30, 3, 'user', '[]'), (62, 32, 3, 'user', '[]'), (63, 33, 3, 'user', '[]'), (64, 36, 3, 'user', '[]'), (65, 37, 3, 'user', '[]'), (66, 38, 3, 'user', '[]'), (67, 2, 3, 'user', '[]'), (68, 2, 6, 'role', '[]'); -- -------------------------------------------------------- -- -- Table structure for table `permissions` -- CREATE TABLE `permissions` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(30) NOT NULL, `display_name` varchar(191) NOT NULL, `description` varchar(191) DEFAULT NULL, `group` varchar(30) NOT NULL, `restrictions` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `type` varchar(20) NOT NULL DEFAULT 'sitewide', `advanced` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `permissions` -- INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `group`, `restrictions`, `created_at`, `updated_at`, `type`, `advanced`) VALUES (1, 'admin', 'Super Admin', 'Give all permissions to user.', 'admin', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (2, 'admin.access', 'Access Admin', 'Required in order to access any admin area page.', 'admin', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (3, 'appearance.update', 'Update Appearance', 'Allows access to appearance editor.', 'admin', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (4, 'api.access', 'Access Api', 'Required in order for users to be able to use the API.', 'api', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (5, 'roles.view', 'View Roles', 'Allow viewing ALL roles, regardless of who is the owner.', 'roles', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (6, 'roles.create', 'Create Roles', 'Allow creating new roles, regardless of who is the owner.', 'roles', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (7, 'roles.update', 'Update Roles', 'Allow updating ALL roles, regardless of who is the owner.', 'roles', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (8, 'roles.delete', 'Delete Roles', 'Allow deleting ALL roles, regardless of who is the owner.', 'roles', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (9, 'custom_pages.view', 'View Custom Pages', 'Allow viewing of all pages on the site, regardless of who created them. User can view their own pages without this permission.', 'custom_pages', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (10, 'custom_pages.create', 'Create Custom Pages', 'Allow creating new custom pages, regardless of who is the owner.', 'custom_pages', '[{\"name\":\"count\",\"type\":\"number\",\"description\":\"Maximum number of pages user will be able to create. Leave empty for unlimited.\"}]', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (11, 'custom_pages.update', 'Update Custom Pages', 'Allow editing of all pages on the site, regardless of who created them. User can edit their own pages without this permission.', 'custom_pages', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (12, 'custom_pages.delete', 'Delete Custom Pages', 'Allow deleting of all pages on the site, regardless of who created them. User can delete their own pages without this permission.', 'custom_pages', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (13, 'custom_domains.view', 'View Custom Domains', 'Allow viewing all domains on the site, regardless of who created them. User can view their own domains without this permission.', 'custom_domains', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (14, 'custom_domains.create', 'Create Custom Domains', 'Allow user to connect their own custom domains.', 'custom_domains', '[{\"name\":\"count\",\"type\":\"number\",\"description\":\"Maximum number of domains user will be able to create. Leave empty for unlimited.\"}]', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (15, 'custom_domains.update', 'Update Custom Domains', 'Allow editing all domains on the site, regardless of who created them. User can edit their own domains without this permission.', 'custom_domains', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (16, 'custom_domains.delete', 'Delete Custom Domains', 'Allow deleting all domains on the site, regardless of who created them. User can delete their own domains without this permission.', 'custom_domains', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (17, 'files.view', 'View Files', 'Allow viewing all uploaded files on the site. Users can view their own uploads without this permission.', 'files', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (18, 'files.create', 'Create Files', 'Allow uploading files on the site. This permission is used by any page where it is possible for user to upload files.', 'files', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (19, 'files.update', 'Update Files', 'Allow editing all uploaded files on the site. Users can edit their own uploads without this permission.', 'files', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (20, 'files.delete', 'Delete Files', 'Allow deleting all uploaded files on the site. Users can delete their own uploads (where applicable) without this permission.', 'files', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (21, 'files.download', 'Download Files', 'Allow downloading all uploaded files on the site. Users can download their own uploads (where applicable) without this permission.', 'files', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (22, 'users.view', 'View Users', 'Allow viewing user profile pages on the site. User can view their own profile without this permission.', 'users', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (23, 'users.create', 'Create Users', 'Allow creating users from admin area. Users can register for new accounts without this permission. Registration can be disabled from settings page.', 'users', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (24, 'users.update', 'Update Users', 'Allow editing details of any user on the site. User can edit their own details without this permission.', 'users', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (25, 'users.delete', 'Delete Users', 'Allow deleting any user on the site. User can request deletion of their own account without this permission.', 'users', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (26, 'localizations.view', 'View Localizations', 'Allow viewing ALL localizations, regardless of who is the owner.', 'localizations', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (27, 'localizations.create', 'Create Localizations', 'Allow creating new localizations, regardless of who is the owner.', 'localizations', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (28, 'localizations.update', 'Update Localizations', 'Allow updating ALL localizations, regardless of who is the owner.', 'localizations', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (29, 'localizations.delete', 'Delete Localizations', 'Allow deleting ALL localizations, regardless of who is the owner.', 'localizations', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (30, 'settings.view', 'View Settings', 'Allow viewing ALL settings, regardless of who is the owner.', 'settings', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (31, 'settings.update', 'Update Settings', 'Allow updating ALL settings, regardless of who is the owner.', 'settings', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (32, 'plans.view', 'View Plans', 'Allow viewing ALL plans, regardless of who is the owner.', 'plans', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (33, 'plans.create', 'Create Plans', 'Allow creating new plans, regardless of who is the owner.', 'plans', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (34, 'plans.update', 'Update Plans', 'Allow updating ALL plans, regardless of who is the owner.', 'plans', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (35, 'plans.delete', 'Delete Plans', 'Allow deleting ALL plans, regardless of who is the owner.', 'plans', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (36, 'invoices.view', 'View Invoices', 'Allow viewing ALL invoices, regardless of who is the owner.', 'invoices', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (37, 'tags.view', 'View Tags', 'Allow viewing ALL tags, regardless of who is the owner.', 'tags', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (38, 'tags.create', 'Create Tags', 'Allow creating new tags, regardless of who is the owner.', 'tags', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (39, 'tags.update', 'Update Tags', 'Allow updating ALL tags, regardless of who is the owner.', 'tags', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (40, 'tags.delete', 'Delete Tags', 'Allow deleting ALL tags, regardless of who is the owner.', 'tags', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 1), (41, 'workspaces.view', 'View Workspaces', 'Allow viewing ALL workspaces, regardless of who is the owner.', 'workspaces', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (42, 'workspaces.create', 'Create Workspaces', 'Allow creating new workspaces, regardless of who is the owner.', 'workspaces', '[{\"name\":\"count\",\"type\":\"number\",\"description\":\"Maximum number of workspaces user will be able to create. Leave empty for unlimited.\"},{\"name\":\"member_count\",\"type\":\"number\",\"description\":\"Maximum number of members workspace is allowed to have.\"}]', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (43, 'workspaces.update', 'Update Workspaces', 'Allow updating ALL workspaces, regardless of who is the owner.', 'workspaces', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (44, 'workspaces.delete', 'Delete Workspaces', 'Allow deleting ALL workspaces, regardless of who is the owner.', 'workspaces', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (45, 'workspace_members.invite', 'Invite Members', 'Allow user to invite new members into a workspace.', 'workspace_members', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'workspace', 0), (46, 'workspace_members.update', 'Update Members', 'Allow user to change role of other members.', 'workspace_members', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'workspace', 0), (47, 'workspace_members.delete', 'Delete Members', 'Allow user to remove members from workspace.', 'workspace_members', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'workspace', 0), (48, 'links.view', 'View Links', 'Allow viewing ALL links, regardless of who is the owner.', 'links', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (49, 'links.create', 'Create Links', 'Allow creating new links, regardless of who is the owner.', 'links', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (50, 'links.update', 'Update Links', 'Allow updating ALL links, regardless of who is the owner.', 'links', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (51, 'links.delete', 'Delete Links', 'Allow deleting ALL links, regardless of who is the owner.', 'links', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0), (52, 'notifications.subscribe', 'Subscribe Notifications', 'Allows agents to subscribe to various conversation notifications.', 'notifications', NULL, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'sitewide', 0); -- -------------------------------------------------------- -- -- 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, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `prices` -- CREATE TABLE `prices` ( `id` bigint(20) UNSIGNED NOT NULL, `amount` decimal(13,2) NOT NULL, `currency` varchar(191) NOT NULL, `interval` varchar(191) NOT NULL DEFAULT 'month', `interval_count` int(11) NOT NULL DEFAULT 1, `product_id` int(11) NOT NULL, `stripe_id` varchar(50) DEFAULT NULL, `paypal_id` varchar(50) DEFAULT NULL, `default` tinyint(1) 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 `prices` -- INSERT INTO `prices` (`id`, `amount`, `currency`, `interval`, `interval_count`, `product_id`, `stripe_id`, `paypal_id`, `default`, `created_at`, `updated_at`) VALUES (1, 9.00, 'USD', 'month', 1, 2, NULL, NULL, 0, '2023-10-24 13:14:44', '2023-10-25 04:55:22'), (2, 90.00, 'USD', 'year', 1, 2, NULL, NULL, 0, '2023-10-25 04:54:33', '2023-10-25 04:55:22'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `description` text DEFAULT NULL, `uuid` char(36) NOT NULL, `feature_list` text DEFAULT NULL, `position` smallint(6) NOT NULL DEFAULT 0, `recommended` tinyint(1) NOT NULL DEFAULT 0, `free` tinyint(1) NOT NULL DEFAULT 0, `hidden` tinyint(1) NOT NULL DEFAULT 0, `available_space` 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 `products` -- INSERT INTO `products` (`id`, `name`, `description`, `uuid`, `feature_list`, `position`, `recommended`, `free`, `hidden`, `available_space`, `created_at`, `updated_at`) VALUES (1, 'Free', 'Free for everyone', '28121374-9bba-4781-9dd9-af1bd0ce1d49', '[]', 0, 0, 1, 0, 104857600, '2023-10-24 13:13:51', '2023-10-24 13:13:51'), (2, 'Pro', 'Pro Plan', 'e50782bb-90d9-4d66-bf7a-6e696a79b6d8', '[]', 0, 1, 0, 0, 1073741824, '2023-10-24 13:14:44', '2023-10-24 13:14:44'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `legacy_permissions` text DEFAULT NULL, `default` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `guests` tinyint(1) UNSIGNED NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `description` varchar(191) DEFAULT NULL, `type` varchar(20) NOT NULL DEFAULT 'sitewide', `internal` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`id`, `name`, `legacy_permissions`, `default`, `guests`, `created_at`, `updated_at`, `description`, `type`, `internal`) VALUES (1, 'users', NULL, 1, 0, '2023-10-24 13:00:53', '2023-10-24 13:00:53', NULL, 'sitewide', 1), (2, 'guests', NULL, 0, 1, '2023-10-24 13:00:53', '2023-10-24 13:00:53', NULL, 'sitewide', 1), (3, 'Workspace Admin', NULL, 0, 0, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'Manage workspace content, members, settings and invite new members.', 'workspace', 0), (4, 'Workspace Editor', NULL, 0, 0, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'Add, edit, move and delete workspace files.', 'workspace', 0), (5, 'Workspace Contributor', NULL, 0, 0, '2023-10-24 13:00:53', '2023-10-24 13:00:53', 'Add and edit files.', 'workspace', 0), (6, 'Admin', NULL, 0, 0, '2023-11-04 05:48:06', '2023-11-04 05:48:06', 'Admin', 'sitewide', 0); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `value` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `private` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `name`, `value`, `created_at`, `updated_at`, `private`) VALUES (1, 'dates.format', 'short', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (2, 'dates.locale', 'en_US', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (3, 'dates.default_timezone', 'auto', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (4, 'locale.default', 'auto', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (5, 'social.google.enable', 'true', '2023-10-24 13:00:53', '2023-10-24 13:10:33', 0), (6, 'social.twitter.enable', 'true', '2023-10-24 13:00:53', '2023-10-24 13:10:33', 0), (7, 'social.facebook.enable', 'true', '2023-10-24 13:00:53', '2023-10-24 13:10:33', 0), (8, 'social.compact_buttons', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (9, 'realtime.enable', 'false', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (10, 'registration.disable', 'false', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (11, 'branding.logo_dark', 'storage/branding_media/c0bfd80b-c3c4-44d0-b726-63ddd89a911b.png', '2023-10-24 13:00:53', '2023-10-24 13:10:33', 0), (12, 'branding.logo_light', 'storage/branding_media/e5e4b0db-2750-4540-9a38-90cfd588b30b.png', '2023-10-24 13:00:53', '2023-10-24 13:10:33', 0), (13, 'i18n.default_localization', 'en', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (14, 'i18n.enable', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (15, 'logging.sentry_public', '', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (16, 'realtime.pusher_key', '', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (17, 'themes.user_change', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (18, 'themes.default_id', '0', '2023-10-24 13:00:53', '2023-10-24 13:10:33', 0), (19, 'billing.enable', 'true', '2023-10-24 13:00:53', '2023-10-25 04:52:51', 0), (20, 'billing.paypal_test_mode', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (21, 'billing.stripe_test_mode', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (22, 'billing.stripe.enable', 'false', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (23, 'billing.paypal.enable', 'false', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (24, 'billing.accepted_cards', '[\"visa\",\"mastercard\",\"american-express\",\"discover\"]', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (25, 'uploads.chunk', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (26, 'cookie_notice.enable', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (27, 'cookie_notice.position', 'bottom', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (28, 'cache.report_minutes', '60', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (29, 'homepage.type', 'landingPage', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (30, 'menus', '[{\"name\":\"Drive Sidebar\",\"positions\":[\"drive-sidebar\"],\"id\":\"v01akw\",\"items\":[{\"id\":\"wkd771\",\"type\":\"route\",\"order\":1,\"label\":\"Shared with me\",\"action\":\"\\/drive\\/shares\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M9 13.75c-2.34 0-7 1.17-7 3.5V19h14v-1.75c0-2.33-4.66-3.5-7-3.5zM4.34 17c.84-.58 2.87-1.25 4.66-1.25s3.82.67 4.66 1.25H4.34zM9 12c1.93 0 3.5-1.57 3.5-3.5S10.93 5 9 5 5.5 6.57 5.5 8.5 7.07 12 9 12zm0-5c.83 0 1.5.67 1.5 1.5S9.83 10 9 10s-1.5-.67-1.5-1.5S8.17 7 9 7zm7.04 6.81c1.16.84 1.96 1.96 1.96 3.44V19h4v-1.75c0-2.02-3.5-3.17-5.96-3.44zM15 12c1.93 0 3.5-1.57 3.5-3.5S16.93 5 15 5c-.54 0-1.04.13-1.5.35.63.89 1 1.98 1 3.15s-.37 2.26-1 3.15c.46.22.96.35 1.5.35z\"}}]},{\"id\":\"jo2m1s\",\"type\":\"route\",\"order\":2,\"label\":\"Recent\",\"action\":\"\\/drive\\/recent\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M13 3c-4.97 0-9 4.03-9 9H1l3.89 3.89.07.14L9 12H6c0-3.87 3.13-7 7-7s7 3.13 7 7-3.13 7-7 7c-1.93 0-3.68-.79-4.94-2.06l-1.42 1.42C8.27 19.99 10.51 21 13 21c4.97 0 9-4.03 9-9s-4.03-9-9-9zm-1 5v5l4.25 2.52.77-1.28-3.52-2.09V8z\"}}]},{\"id\":\"4e6cie\",\"type\":\"route\",\"order\":3,\"label\":\"Starred\",\"action\":\"\\/drive\\/starred\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M12 17.27 18.18 21l-1.64-7.03L22 9.24l-7.19-.61L12 2 9.19 8.63 2 9.24l5.46 4.73L5.82 21 12 17.27z\"}}]},{\"id\":\"h5p54n\",\"type\":\"route\",\"order\":4,\"label\":\"Trash\",\"action\":\"\\/drive\\/trash\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M16 9v10H8V9h8m-1.5-6h-5l-1 1H5v2h14V4h-3.5l-1-1zM18 7H6v12c0 1.1.9 2 2 2h8c1.1 0 2-.9 2-2V7z\"}}]}]},{\"name\":\"footer\",\"id\":\"4tbwog\",\"positions\":[\"footer\"],\"items\":[{\"type\":\"route\",\"id\":\"c1sf2g\",\"position\":1,\"label\":\"Developers\",\"action\":\"\\/api-docs\",\"condition\":\"auth\"},{\"type\":\"route\",\"id\":\"rlz27v\",\"position\":2,\"label\":\"Privacy Policy\",\"action\":\"\\/pages\\/privacy-policy\"},{\"type\":\"route\",\"id\":\"p80pvk\",\"position\":3,\"label\":\"Terms of Service\",\"action\":\"\\/pages\\/terms-of-service\"},{\"type\":\"route\",\"id\":\"q8dtht\",\"position\":4,\"label\":\"Contact Us\",\"action\":\"\\/contact\"}]},{\"name\":\"Footer Social\",\"id\":\"odw4ah\",\"positions\":[\"footer-secondary\"],\"items\":[{\"type\":\"link\",\"id\":\"6j747e\",\"position\":1,\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M19 3H5a2 2 0 00-2 2v14a2 2 0 002 2h7.621v-6.961h-2.343v-2.725h2.343V9.309c0-2.324 1.421-3.591 3.495-3.591.699-.002 1.397.034 2.092.105v2.43H16.78c-1.13 0-1.35.534-1.35 1.322v1.735h2.7l-.351 2.725h-2.365V21H19a2 2 0 002-2V5a2 2 0 00-2-2z\"}}],\"action\":\"https:\\/\\/facebook.com\"},{\"type\":\"link\",\"id\":\"jo96zw\",\"position\":2,\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M24 4.3c-.898.4-1.8.7-2.8.802 1-.602 1.8-1.602 2.198-2.704-1 .602-2 1-3.097 1.204C19.3 2.602 18 2 16.6 2a4.907 4.907 0 00-4.9 4.898c0 .403 0 .801.102 1.102C7.7 7.8 4.102 5.898 1.7 2.898c-.5.704-.7 1.602-.7 2.5 0 1.704.898 3.204 2.2 4.102-.802-.102-1.598-.3-2.2-.602V9c0 2.398 1.7 4.398 3.898 4.8-.398.098-.796.2-1.296.2-.301 0-.602 0-.903-.102.602 2 2.403 3.403 4.602 3.403-1.7 1.3-3.801 2.097-6.102 2.097-.398 0-.8 0-1.199-.097C2.2 20.699 4.8 21.5 7.5 21.5c9.102 0 14-7.5 14-14v-.602c1-.699 1.8-1.597 2.5-2.597\"}}],\"action\":\"https:\\/\\/twitter.com\"},{\"type\":\"link\",\"id\":\"57dsea\",\"position\":3,\"action\":\"https:\\/\\/instagram.com\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M12 0C8.74 0 8.333.015 7.053.072 5.775.132 4.905.333 4.14.63c-.789.306-1.459.717-2.126 1.384S.935 3.35.63 4.14C.333 4.905.131 5.775.072 7.053.012 8.333 0 8.74 0 12s.015 3.667.072 4.947c.06 1.277.261 2.148.558 2.913a5.885 5.885 0 001.384 2.126A5.868 5.868 0 004.14 23.37c.766.296 1.636.499 2.913.558C8.333 23.988 8.74 24 12 24s3.667-.015 4.947-.072c1.277-.06 2.148-.262 2.913-.558a5.898 5.898 0 002.126-1.384 5.86 5.86 0 001.384-2.126c.296-.765.499-1.636.558-2.913.06-1.28.072-1.687.072-4.947s-.015-3.667-.072-4.947c-.06-1.277-.262-2.149-.558-2.913a5.89 5.89 0 00-1.384-2.126A5.847 5.847 0 0019.86.63c-.765-.297-1.636-.499-2.913-.558C15.667.012 15.26 0 12 0zm0 2.16c3.203 0 3.585.016 4.85.071 1.17.055 1.805.249 2.227.415.562.217.96.477 1.382.896.419.42.679.819.896 1.381.164.422.36 1.057.413 2.227.057 1.266.07 1.646.07 4.85s-.015 3.585-.074 4.85c-.061 1.17-.256 1.805-.421 2.227a3.81 3.81 0 01-.899 1.382 3.744 3.744 0 01-1.38.896c-.42.164-1.065.36-2.235.413-1.274.057-1.649.07-4.859.07-3.211 0-3.586-.015-4.859-.074-1.171-.061-1.816-.256-2.236-.421a3.716 3.716 0 01-1.379-.899 3.644 3.644 0 01-.9-1.38c-.165-.42-.359-1.065-.42-2.235-.045-1.26-.061-1.649-.061-4.844 0-3.196.016-3.586.061-4.861.061-1.17.255-1.814.42-2.234.21-.57.479-.96.9-1.381.419-.419.81-.689 1.379-.898.42-.166 1.051-.361 2.221-.421 1.275-.045 1.65-.06 4.859-.06l.045.03zm0 3.678a6.162 6.162 0 100 12.324 6.162 6.162 0 100-12.324zM12 16c-2.21 0-4-1.79-4-4s1.79-4 4-4 4 1.79 4 4-1.79 4-4 4zm7.846-10.405a1.441 1.441 0 01-2.88 0 1.44 1.44 0 012.88 0z\"}}]},{\"type\":\"link\",\"id\":\"lzntr2\",\"position\":4,\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M5.68 2l1.478 5.344v2.562H8.44V7.344L9.937 2h-1.29l-.538 2.432a27.21 27.21 0 00-.29 1.515h-.04c-.063-.42-.159-.93-.29-1.525L6.97 2H5.68zm5.752 2.018c-.434 0-.784.084-1.051.257-.267.172-.464.448-.59.825-.125.377-.187.876-.187 1.498v.84c0 .615.054 1.107.164 1.478.11.371.295.644.556.82.261.176.62.264 1.078.264.446 0 .8-.087 1.06-.26.26-.173.45-.444.565-.818.116-.374.174-.869.174-1.485v-.84c0-.62-.059-1.118-.178-1.492-.119-.373-.308-.648-.566-.824-.258-.176-.598-.263-1.025-.263zm2.447.113v4.314c0 .534.09.927.271 1.178.182.251.465.377.848.377.552 0 .968-.267 1.244-.8h.028l.113.706H17.4V4.131h-1.298v4.588a.635.635 0 01-.23.263.569.569 0 01-.325.104c-.132 0-.226-.054-.283-.164-.057-.11-.086-.295-.086-.553V4.131h-1.3zm-2.477.781c.182 0 .311.095.383.287.072.191.108.495.108.91v1.8c0 .426-.036.735-.108.923-.072.188-.2.282-.38.283-.183 0-.309-.095-.378-.283-.07-.188-.103-.497-.103-.924V6.11c0-.414.035-.718.107-.91.072-.19.195-.287.371-.287zM5 11c-1.1 0-2 .9-2 2v7c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2v-7c0-1.1-.9-2-2-2H5zm7.049 2h1.056v2.568h.008c.095-.186.232-.335.407-.449.175-.114.364-.17.566-.17.26 0 .463.07.611.207.148.138.257.361.323.668.066.308.097.735.097 1.281v.772h.002c0 .727-.089 1.26-.264 1.602-.175.342-.447.513-.818.513-.207 0-.394-.047-.564-.142a.93.93 0 01-.383-.391h-.024l-.11.46h-.907V13zm-6.563.246h3.252v.885h-1.09v5.789H6.576v-5.79h-1.09v-.884zm11.612 1.705c.376 0 .665.07.867.207.2.138.343.354.426.645.082.292.123.695.123 1.209v.836h-1.836v.248c0 .313.008.547.027.703.02.156.057.27.115.342.058.072.148.107.27.107.164 0 .277-.064.338-.191.06-.127.094-.338.1-.635l.947.055a1.6 1.6 0 01.007.175c0 .451-.124.788-.37 1.01-.248.223-.595.334-1.046.334-.54 0-.92-.17-1.138-.51-.218-.339-.326-.863-.326-1.574v-.851c0-.732.112-1.267.337-1.604.225-.337.613-.506 1.159-.506zm-8.688.094h1.1v3.58c0 .217.024.373.072.465.048.093.126.139.238.139a.486.486 0 00.276-.088.538.538 0 00.193-.223v-3.873h1.1v4.875h-.862l-.093-.598h-.026c-.234.452-.584.678-1.05.678-.325 0-.561-.106-.715-.318-.154-.212-.233-.544-.233-.994v-3.643zm8.664.648c-.117 0-.204.036-.26.104-.056.069-.093.182-.11.338a6.504 6.504 0 00-.028.71v.35h.803v-.35c0-.312-.01-.548-.032-.71-.02-.162-.059-.276-.115-.342-.056-.066-.14-.1-.258-.1zm-3.482.036a.418.418 0 00-.293.126.699.699 0 00-.192.327v2.767a.487.487 0 00.438.256.337.337 0 00.277-.127c.07-.085.12-.228.149-.43.029-.2.043-.48.043-.835v-.627c0-.382-.011-.676-.035-.883-.024-.207-.067-.357-.127-.444a.299.299 0 00-.26-.13z\"}}],\"action\":\"https:\\/\\/youtube.com\"}]},{\"name\":\"Auth Dropdown\",\"id\":\"h8r6vg\",\"items\":[{\"label\":\"Admin Area\",\"id\":\"upm1rv\",\"action\":\"\\/admin\",\"type\":\"route\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M19 5v2h-4V5h4M9 5v6H5V5h4m10 8v6h-4v-6h4M9 17v2H5v-2h4M21 3h-8v6h8V3zM11 3H3v10h8V3zm10 8h-8v10h8V11zm-10 4H3v6h8v-6z\"}}],\"permissions\":[\"admin.access\"]},{\"label\":\"My Files\",\"id\":\"ehj0uk\",\"action\":\"\\/drive\",\"type\":\"route\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M20 6h-8l-2-2H4c-1.1 0-2 .9-2 2v12c0 1.1.9 2 2 2h16c1.1 0 2-.9 2-2V8c0-1.1-.9-2-2-2zm0 12H4V6h5.17l1.41 1.41.59.59H20v10zm-7.84-6H8v2h4.16l-1.59 1.59L11.99 17 16 13.01 11.99 9l-1.41 1.41L12.16 12z\"}}]},{\"label\":\"Account Settings\",\"id\":\"6a89z5\",\"action\":\"\\/account-settings\",\"type\":\"route\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M19.43 12.98c.04-.32.07-.64.07-.98 0-.34-.03-.66-.07-.98l2.11-1.65c.19-.15.24-.42.12-.64l-2-3.46c-.09-.16-.26-.25-.44-.25-.06 0-.12.01-.17.03l-2.49 1c-.52-.4-1.08-.73-1.69-.98l-.38-2.65C14.46 2.18 14.25 2 14 2h-4c-.25 0-.46.18-.49.42l-.38 2.65c-.61.25-1.17.59-1.69.98l-2.49-1c-.06-.02-.12-.03-.18-.03-.17 0-.34.09-.43.25l-2 3.46c-.13.22-.07.49.12.64l2.11 1.65c-.04.32-.07.65-.07.98 0 .33.03.66.07.98l-2.11 1.65c-.19.15-.24.42-.12.64l2 3.46c.09.16.26.25.44.25.06 0 .12-.01.17-.03l2.49-1c.52.4 1.08.73 1.69.98l.38 2.65c.03.24.24.42.49.42h4c.25 0 .46-.18.49-.42l.38-2.65c.61-.25 1.17-.59 1.69-.98l2.49 1c.06.02.12.03.18.03.17 0 .34-.09.43-.25l2-3.46c.12-.22.07-.49-.12-.64l-2.11-1.65zm-1.98-1.71c.04.31.05.52.05.73 0 .21-.02.43-.05.73l-.14 1.13.89.7 1.08.84-.7 1.21-1.27-.51-1.04-.42-.9.68c-.43.32-.84.56-1.25.73l-1.06.43-.16 1.13-.2 1.35h-1.4l-.19-1.35-.16-1.13-1.06-.43c-.43-.18-.83-.41-1.23-.71l-.91-.7-1.06.43-1.27.51-.7-1.21 1.08-.84.89-.7-.14-1.13c-.03-.31-.05-.54-.05-.74s.02-.43.05-.73l.14-1.13-.89-.7-1.08-.84.7-1.21 1.27.51 1.04.42.9-.68c.43-.32.84-.56 1.25-.73l1.06-.43.16-1.13.2-1.35h1.39l.19 1.35.16 1.13 1.06.43c.43.18.83.41 1.23.71l.91.7 1.06-.43 1.27-.51.7 1.21-1.07.85-.89.7.14 1.13zM12 8c-2.21 0-4 1.79-4 4s1.79 4 4 4 4-1.79 4-4-1.79-4-4-4zm0 6c-1.1 0-2-.9-2-2s.9-2 2-2 2 .9 2 2-.9 2-2 2z\"}}]}],\"positions\":[\"auth-dropdown\"]},{\"name\":\"Admin Sidebar\",\"id\":\"2d43u1\",\"items\":[{\"label\":\"Analytics\",\"id\":\"886nz4\",\"action\":\"\\/admin\",\"type\":\"route\",\"condition\":\"admin\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zm0 16H5V5h14v14z\"}},{\"tag\":\"path\",\"attr\":{\"d\":\"M7 12h2v5H7zm8-5h2v10h-2zm-4 7h2v3h-2zm0-4h2v2h-2z\"}}],\"role\":1,\"permissions\":[\"admin.access\"],\"roles\":[]},{\"label\":\"Appearance\",\"id\":\"slcqm0\",\"action\":\"\\/admin\\/appearance\",\"type\":\"route\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"m2.53 19.65 1.34.56v-9.03l-2.43 5.86c-.41 1.02.08 2.19 1.09 2.61zm19.5-3.7L17.07 3.98c-.31-.75-1.04-1.21-1.81-1.23-.26 0-.53.04-.79.15L7.1 5.95c-.75.31-1.21 1.03-1.23 1.8-.01.27.04.54.15.8l4.96 11.97c.31.76 1.05 1.22 1.83 1.23.26 0 .52-.05.77-.15l7.36-3.05c1.02-.42 1.51-1.59 1.09-2.6zm-9.2 3.8L7.87 7.79l7.35-3.04h.01l4.95 11.95-7.35 3.05z\"}},{\"tag\":\"circle\",\"attr\":{\"cx\":\"11\",\"cy\":\"9\",\"r\":\"1\"}},{\"tag\":\"path\",\"attr\":{\"d\":\"M5.88 19.75c0 1.1.9 2 2 2h1.45l-3.45-8.34v6.34z\"}}],\"permissions\":[\"appearance.update\"]},{\"label\":\"Settings\",\"id\":\"x5k484\",\"action\":\"\\/admin\\/settings\",\"type\":\"route\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M19.43 12.98c.04-.32.07-.64.07-.98 0-.34-.03-.66-.07-.98l2.11-1.65c.19-.15.24-.42.12-.64l-2-3.46c-.09-.16-.26-.25-.44-.25-.06 0-.12.01-.17.03l-2.49 1c-.52-.4-1.08-.73-1.69-.98l-.38-2.65C14.46 2.18 14.25 2 14 2h-4c-.25 0-.46.18-.49.42l-.38 2.65c-.61.25-1.17.59-1.69.98l-2.49-1c-.06-.02-.12-.03-.18-.03-.17 0-.34.09-.43.25l-2 3.46c-.13.22-.07.49.12.64l2.11 1.65c-.04.32-.07.65-.07.98 0 .33.03.66.07.98l-2.11 1.65c-.19.15-.24.42-.12.64l2 3.46c.09.16.26.25.44.25.06 0 .12-.01.17-.03l2.49-1c.52.4 1.08.73 1.69.98l.38 2.65c.03.24.24.42.49.42h4c.25 0 .46-.18.49-.42l.38-2.65c.61-.25 1.17-.59 1.69-.98l2.49 1c.06.02.12.03.18.03.17 0 .34-.09.43-.25l2-3.46c.12-.22.07-.49-.12-.64l-2.11-1.65zm-1.98-1.71c.04.31.05.52.05.73 0 .21-.02.43-.05.73l-.14 1.13.89.7 1.08.84-.7 1.21-1.27-.51-1.04-.42-.9.68c-.43.32-.84.56-1.25.73l-1.06.43-.16 1.13-.2 1.35h-1.4l-.19-1.35-.16-1.13-1.06-.43c-.43-.18-.83-.41-1.23-.71l-.91-.7-1.06.43-1.27.51-.7-1.21 1.08-.84.89-.7-.14-1.13c-.03-.31-.05-.54-.05-.74s.02-.43.05-.73l.14-1.13-.89-.7-1.08-.84.7-1.21 1.27.51 1.04.42.9-.68c.43-.32.84-.56 1.25-.73l1.06-.43.16-1.13.2-1.35h1.39l.19 1.35.16 1.13 1.06.43c.43.18.83.41 1.23.71l.91.7 1.06-.43 1.27-.51.7 1.21-1.07.85-.89.7.14 1.13zM12 8c-2.21 0-4 1.79-4 4s1.79 4 4 4 4-1.79 4-4-1.79-4-4-4zm0 6c-1.1 0-2-.9-2-2s.9-2 2-2 2 .9 2 2-.9 2-2 2z\"}}],\"permissions\":[\"settings.update\"]},{\"label\":\"Plans\",\"id\":\"7o42rt\",\"action\":\"\\/admin\\/plans\",\"type\":\"route\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M7 15h7v2H7zm0-4h10v2H7zm0-4h10v2H7zm12-4h-4.18C14.4 1.84 13.3 1 12 1c-1.3 0-2.4.84-2.82 2H5c-.14 0-.27.01-.4.04-.39.08-.74.28-1.01.55-.18.18-.33.4-.43.64-.1.23-.16.49-.16.77v14c0 .27.06.54.16.78s.25.45.43.64c.27.27.62.47 1.01.55.13.02.26.03.4.03h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zm-7-.25c.41 0 .75.34.75.75s-.34.75-.75.75-.75-.34-.75-.75.34-.75.75-.75zM19 19H5V5h14v14z\"}}],\"permissions\":[\"plans.update\"]},{\"label\":\"Subscriptions\",\"action\":\"\\/admin\\/subscriptions\",\"type\":\"route\",\"id\":\"sdcb5a\",\"condition\":\"admin\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M4 6h16v2H4zm2-4h12v2H6zm14 8H4c-1.1 0-2 .9-2 2v8c0 1.1.9 2 2 2h16c1.1 0 2-.9 2-2v-8c0-1.1-.9-2-2-2zm0 10H4v-8h16v8zm-10-7.27v6.53L16 16z\"}}],\"permissions\":[\"subscriptions.update\"]},{\"label\":\"Users\",\"action\":\"\\/admin\\/users\",\"type\":\"route\",\"id\":\"fzfb45\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M12 6c1.1 0 2 .9 2 2s-.9 2-2 2-2-.9-2-2 .9-2 2-2m0 10c2.7 0 5.8 1.29 6 2H6c.23-.72 3.31-2 6-2m0-12C9.79 4 8 5.79 8 8s1.79 4 4 4 4-1.79 4-4-1.79-4-4-4zm0 10c-2.67 0-8 1.34-8 4v2h16v-2c0-2.66-5.33-4-8-4z\"}}],\"permissions\":[\"users.update\"]},{\"label\":\"Roles\",\"action\":\"\\/admin\\/roles\",\"type\":\"route\",\"id\":\"mwdkf0\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M9 13.75c-2.34 0-7 1.17-7 3.5V19h14v-1.75c0-2.33-4.66-3.5-7-3.5zM4.34 17c.84-.58 2.87-1.25 4.66-1.25s3.82.67 4.66 1.25H4.34zM9 12c1.93 0 3.5-1.57 3.5-3.5S10.93 5 9 5 5.5 6.57 5.5 8.5 7.07 12 9 12zm0-5c.83 0 1.5.67 1.5 1.5S9.83 10 9 10s-1.5-.67-1.5-1.5S8.17 7 9 7zm7.04 6.81c1.16.84 1.96 1.96 1.96 3.44V19h4v-1.75c0-2.02-3.5-3.17-5.96-3.44zM15 12c1.93 0 3.5-1.57 3.5-3.5S16.93 5 15 5c-.54 0-1.04.13-1.5.35.63.89 1 1.98 1 3.15s-.37 2.26-1 3.15c.46.22.96.35 1.5.35z\"}}],\"permissions\":[\"roles.update\"]},{\"label\":\"Pages\",\"action\":\"\\/admin\\/custom-pages\",\"type\":\"route\",\"id\":\"63bwv9\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M19 5v14H5V5h14m0-2H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2z\"}},{\"tag\":\"path\",\"attr\":{\"d\":\"M14 17H7v-2h7v2zm3-4H7v-2h10v2zm0-4H7V7h10v2z\"}}],\"permissions\":[\"custom_pages.update\"]},{\"label\":\"Tags\",\"action\":\"\\/admin\\/tags\",\"type\":\"route\",\"id\":\"2x0pzq\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M17.63 5.84C17.27 5.33 16.67 5 16 5L5 5.01C3.9 5.01 3 5.9 3 7v10c0 1.1.9 1.99 2 1.99L16 19c.67 0 1.27-.33 1.63-.84L22 12l-4.37-6.16zM16 17H5V7h11l3.55 5L16 17z\"}}],\"permissions\":[\"tags.update\"]},{\"label\":\"Files\",\"action\":\"\\/admin\\/files\",\"type\":\"route\",\"id\":\"vguvti\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M16 1H4c-1.1 0-2 .9-2 2v14h2V3h12V1zm-1 4H8c-1.1 0-1.99.9-1.99 2L6 21c0 1.1.89 2 1.99 2H19c1.1 0 2-.9 2-2V11l-6-6zM8 21V7h6v5h5v9H8z\"}}],\"permissions\":[\"files.update\"]},{\"label\":\"Localizations\",\"action\":\"\\/admin\\/localizations\",\"type\":\"route\",\"id\":\"w91yql\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"m12.87 15.07-2.54-2.51.03-.03c1.74-1.94 2.98-4.17 3.71-6.53H17V4h-7V2H8v2H1v1.99h11.17C11.5 7.92 10.44 9.75 9 11.35 8.07 10.32 7.3 9.19 6.69 8h-2c.73 1.63 1.73 3.17 2.98 4.56l-5.09 5.02L4 19l5-5 3.11 3.11.76-2.04zM18.5 10h-2L12 22h2l1.12-3h4.75L21 22h2l-4.5-12zm-2.62 7 1.62-4.33L19.12 17h-3.24z\"}}],\"permissions\":[\"localizations.update\"]},{\"label\":\"Ads\",\"action\":\"\\/admin\\/ads\",\"type\":\"route\",\"id\":\"ohj4qk\",\"icon\":[{\"tag\":\"path\",\"attr\":{\"d\":\"M17 1H7c-1.1 0-2 .9-2 2v18c0 1.1.9 2 2 2h10c1.1 0 2-.9 2-2V3c0-1.1-.9-2-2-2zM7 4V3h10v1H7zm0 14V6h10v12H7zm0 3v-1h10v1H7z\"}},{\"tag\":\"path\",\"attr\":{\"d\":\"M16 7H8v2h8V7z\"}}],\"permissions\":[\"settings.update\"]}],\"positions\":[\"admin-sidebar\"]}]', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (31, 'uploads.max_size', '52428800', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (32, 'uploads.chunk_size', '15728640', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (33, 'uploads.available_space', '104857600', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (34, 's3_direct_upload', 'true', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (35, 'uploads.blocked_extensions', '[\"exe\",\"application\\/x-msdownload\",\"x-dosexec\"]', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (36, 'homepage.appearance', '{\"headerTitle\":\"MXCloud. A new home for your files.\",\"headerSubtitle\":\"Register or Login now to upload, backup, manage and access your files on any device, from anywhere, free.\",\"headerImage\":\"images\\/homepage\\/homepage-header-bg.jpg\",\"headerImageOpacity\":1,\"headerOverlayColor2\":null,\"footerTitle\":\"Get started with MXCloud\",\"footerSubtitle\":\"Start Free Today.\",\"footerImage\":\"images\\/homepage\\/homepage-footer-bg.svg\",\"actions\":{\"cta1\":{\"label\":\"Register Now\",\"type\":\"route\",\"action\":\"\\/register\"},\"cta2\":{\"label\":null,\"type\":null,\"roles\":null,\"permissions\":null},\"cta3\":{\"label\":\"Sign up for free\",\"type\":\"route\",\"action\":\"\\/register\"}},\"primaryFeatures\":[{\"title\":\"Store any file\",\"subtitle\":\"Keep photos, stories, designs, drawings, recordings, videos, and more. Your first 15 GB of storage are free.\",\"image\":\"images\\/homepage\\/upload.svg\"},{\"title\":\"See your stuff anywhere\",\"subtitle\":\"Your files in MXCloud can be reached from any smartphone, tablet, or computer.\",\"image\":\"images\\/homepage\\/web-devices.svg\"},{\"title\":\"Share files and folders\",\"subtitle\":\"You can quickly invite others to view, download, and collaborate on all the files you want.\",\"image\":\"images\\/homepage\\/share.svg\"}],\"secondaryFeatures\":[{\"title\":\"Keep your files safe\",\"image\":\"storage\\/homepage\\/e7e89653-318c-41fb-843a-5939004bf6a3.png\",\"description\":\"If something happens to your device, you don\'t have to worry about losing your files or photos \\u2013 they\'re in your MXCloud. And MXCloud is encrypted using SSL.\"},{\"title\":\"Reliable storage and fast transfers\",\"image\":\"storage\\/homepage\\/755b5848-5aee-4335-ad07-20b3fbdd8763.jpg\",\"description\":\"We make secure cloud storage simple and convenient. Create a free MyDrive account today!\"}]}', '2023-10-24 13:00:53', '2024-05-28 09:18:59', 0), (37, 'drive.default_view', 'grid', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (38, 'drive.send_share_notification', 'false', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (39, 'share.suggest_emails', 'false', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (40, 'branding.favicon', 'favicon/icon-144x144.png', '2023-10-24 13:00:53', '2023-10-24 13:00:53', 0), (41, 'seo.custom-page.show.og:title', '{{page.title}} - {{site_name}}', '2023-10-24 13:02:44', '2023-10-24 13:02:44', 0), (42, 'seo.custom-page.show.og:description', '{{page.body}}', '2023-10-24 13:02:44', '2023-10-24 13:02:44', 0), (43, 'branding.logo_light_mobile', 'storage/branding_media/15be993b-745c-4608-b56f-fe080701eb02.png', '2023-10-24 13:10:33', '2023-10-24 13:10:33', 0), (44, 'branding.logo_dark_mobile', 'storage/branding_media/462c3637-b016-4438-a8fb-a0af69d19a99.png', '2023-10-24 13:10:33', '2023-10-24 13:10:33', 0); -- -------------------------------------------------------- -- -- Table structure for table `shareable_links` -- CREATE TABLE `shareable_links` ( `id` int(10) UNSIGNED NOT NULL, `hash` varchar(30) NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `entry_id` int(10) UNSIGNED NOT NULL, `allow_edit` tinyint(1) NOT NULL DEFAULT 0, `allow_download` tinyint(1) NOT NULL DEFAULT 1, `password` varchar(191) 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 `social_profiles` -- CREATE TABLE `social_profiles` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `service_name` varchar(20) NOT NULL, `user_service_id` varchar(191) NOT NULL, `username` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `access_token` text DEFAULT NULL, `refresh_token` text DEFAULT NULL, `access_expires_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `subscriptions` -- CREATE TABLE `subscriptions` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `price_id` varchar(191) NOT NULL, `gateway_name` varchar(191) NOT NULL DEFAULT 'none', `gateway_id` varchar(191) DEFAULT NULL, `quantity` int(11) NOT NULL DEFAULT 1, `description` text DEFAULT NULL, `trial_ends_at` timestamp NULL DEFAULT NULL, `ends_at` timestamp NULL DEFAULT NULL, `renews_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `product_id` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `taggables` -- CREATE TABLE `taggables` ( `id` int(10) UNSIGNED NOT NULL, `tag_id` int(10) UNSIGNED NOT NULL, `taggable_id` int(10) UNSIGNED NOT NULL, `taggable_type` varchar(80) NOT NULL, `user_id` int(10) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tags` -- CREATE TABLE `tags` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `display_name` varchar(191) DEFAULT NULL, `type` varchar(30) NOT NULL DEFAULT 'custom', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tags` -- INSERT INTO `tags` (`id`, `name`, `display_name`, `type`, `created_at`, `updated_at`, `user_id`) VALUES (1, 'starred', 'Starred', 'label', '2023-10-24 13:00:53', '2023-10-24 13:00:53', NULL); -- -------------------------------------------------------- -- -- Table structure for table `uploads` -- CREATE TABLE `uploads` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `file_name` varchar(36) NOT NULL, `file_size` varchar(191) NOT NULL, `mime` varchar(191) NOT NULL, `extension` varchar(191) NOT NULL, `user_id` varchar(191) NOT NULL, `url` varchar(191) DEFAULT NULL, `thumbnail_url` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `public` tinyint(1) NOT NULL DEFAULT 0, `path` varchar(191) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `username` varchar(100) DEFAULT NULL, `first_name` varchar(100) DEFAULT NULL, `last_name` varchar(100) DEFAULT NULL, `avatar_url` varchar(191) DEFAULT NULL, `gender` varchar(20) DEFAULT NULL, `legacy_permissions` text DEFAULT NULL, `email` varchar(191) NOT NULL, `password` varchar(60) DEFAULT NULL, `two_factor_secret` text DEFAULT NULL, `two_factor_recovery_codes` text DEFAULT NULL, `two_factor_confirmed_at` timestamp NULL DEFAULT NULL, `card_brand` varchar(30) DEFAULT NULL, `card_last_four` varchar(4) DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `space_available` bigint(20) UNSIGNED DEFAULT NULL, `language` varchar(6) DEFAULT NULL, `country` varchar(40) DEFAULT NULL, `timezone` varchar(30) DEFAULT NULL, `avatar` varchar(191) DEFAULT NULL, `stripe_id` varchar(191) DEFAULT NULL, `available_space` bigint(20) UNSIGNED DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `card_expires` varchar(10) DEFAULT NULL, `paypal_id` varchar(20) DEFAULT NULL, `banned_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `first_name`, `last_name`, `avatar_url`, `gender`, `legacy_permissions`, `email`, `password`, `two_factor_secret`, `two_factor_recovery_codes`, `two_factor_confirmed_at`, `card_brand`, `card_last_four`, `remember_token`, `created_at`, `updated_at`, `space_available`, `language`, `country`, `timezone`, `avatar`, `stripe_id`, `available_space`, `email_verified_at`, `card_expires`, `paypal_id`, `banned_at`) VALUES (1, 'master', 'Master', 'demo', NULL, NULL, NULL, 'mira@mxcloud.com', '$2y$10$01UMSlbnq1BC438QVavzx.KqtBMgHcTwYARLzTgttGl4kY.w/Lxo.', NULL, NULL, NULL, NULL, NULL, 'JE0bcPjaMcpF0Oo9Oo54lSDyakxLHxtcf8CSVuoy7HoCzHv7CHhkN2Zb3VsS', '2023-10-24 13:00:53', '2024-06-11 10:23:07', NULL, 'en', NULL, NULL, 'https://www.gravatar.com/avatar/c214ff3ad9401e3da5a04e11d884f9ed?s=&d=retro', NULL, NULL, '2024-06-11 10:16:36', NULL, NULL, NULL), (2, NULL, NULL, NULL, NULL, NULL, NULL, 'user@demo.com', '$2y$10$vD3GqxefsP26u9SjLEpSFuWlXbea83atTcCbhXldClB4ffzP1SNGC', NULL, NULL, NULL, NULL, NULL, 'fLzPVsHWxRriGCb6DxxNcKMGa87DNvdtl1zChGWXm2TIrNhEjcazQDj0FuM4', '2023-10-24 13:15:50', '2023-10-24 13:15:50', NULL, 'en', NULL, NULL, NULL, NULL, NULL, '2023-10-24 13:15:50', NULL, NULL, NULL), (3, NULL, 'Admin', 'Demo', NULL, NULL, NULL, 'admin@demo.com', '$2y$10$RFvdoEcp1QOIzdSWjR64hu6zprNDL176rNLA5vePIqqAkkypRB6Ay', NULL, NULL, NULL, NULL, NULL, 'ds9HmCFz9IhCG6o8kUl3ivtpzEqEhCmaPdrOi0067dWNh1TNl38gakJ53K05', '2023-11-04 05:53:00', '2024-06-28 10:54:41', NULL, 'en', NULL, NULL, 'https://www.gravatar.com/avatar/454141dab8fba2c55bc2d81247a629a4?s=&d=retro', NULL, NULL, '2024-06-28 10:54:41', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `users_oauth` -- CREATE TABLE `users_oauth` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `service` varchar(191) NOT NULL, `token` 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 `user_role` -- CREATE TABLE `user_role` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `user_role` -- INSERT INTO `user_role` (`id`, `user_id`, `role_id`, `created_at`) VALUES (1, 1, 1, '2023-10-24 13:00:53'), (2, 2, 1, NULL), (4, 3, 6, NULL); -- -------------------------------------------------------- -- -- Table structure for table `workspaces` -- CREATE TABLE `workspaces` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `owner_id` int(10) 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 `workspace_invites` -- CREATE TABLE `workspace_invites` ( `id` char(36) NOT NULL, `avatar` varchar(80) DEFAULT NULL, `workspace_id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED DEFAULT NULL, `email` varchar(80) NOT NULL, `role_id` int(10) 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 `workspace_user` -- CREATE TABLE `workspace_user` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `workspace_id` int(10) UNSIGNED NOT NULL, `role_id` int(10) UNSIGNED DEFAULT NULL, `is_owner` tinyint(1) 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; -- -- Indexes for dumped tables -- -- -- Indexes for table `active_sessions` -- ALTER TABLE `active_sessions` ADD PRIMARY KEY (`id`), ADD KEY `active_sessions_session_id_index` (`session_id`), ADD KEY `active_sessions_token_index` (`token`), ADD KEY `active_sessions_user_id_index` (`user_id`); -- -- Indexes for table `bans` -- ALTER TABLE `bans` ADD PRIMARY KEY (`id`), ADD KEY `bans_bannable_type_bannable_id_index` (`bannable_type`,`bannable_id`), ADD KEY `bans_created_by_type_created_by_id_index` (`created_by_type`,`created_by_id`), ADD KEY `bans_expired_at_index` (`expired_at`); -- -- Indexes for table `billing_plans` -- ALTER TABLE `billing_plans` ADD PRIMARY KEY (`id`), ADD KEY `billing_plans_hidden_index` (`hidden`); -- -- Indexes for table `comments` -- ALTER TABLE `comments` ADD PRIMARY KEY (`id`), ADD KEY `comments_parent_id_index` (`parent_id`), ADD KEY `comments_path_index` (`path`), ADD KEY `comments_user_id_index` (`user_id`), ADD KEY `comments_commentable_id_index` (`commentable_id`), ADD KEY `comments_commentable_type_index` (`commentable_type`), ADD KEY `comments_deleted_index` (`deleted`), ADD KEY `comments_upvotes_index` (`upvotes`), ADD KEY `comments_downvotes_index` (`downvotes`), ADD KEY `comments_reports_count_index` (`reports_count`), ADD KEY `comments_created_at_index` (`created_at`), ADD KEY `comments_updated_at_index` (`updated_at`); -- -- Indexes for table `comment_reports` -- ALTER TABLE `comment_reports` ADD PRIMARY KEY (`id`), ADD KEY `comment_reports_user_id_index` (`user_id`), ADD KEY `comment_reports_comment_id_index` (`comment_id`); -- -- Indexes for table `comment_votes` -- ALTER TABLE `comment_votes` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `comment_votes_user_ip_comment_id_unique` (`user_ip`,`comment_id`), ADD UNIQUE KEY `comment_votes_user_id_comment_id_unique` (`user_id`,`comment_id`), ADD KEY `comment_votes_user_id_index` (`user_id`), ADD KEY `comment_votes_comment_id_index` (`comment_id`), ADD KEY `comment_votes_user_ip_index` (`user_ip`); -- -- Indexes for table `css_themes` -- ALTER TABLE `css_themes` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `css_themes_name_unique` (`name`), ADD KEY `css_themes_default_light_index` (`default_light`), ADD KEY `css_themes_default_dark_index` (`default_dark`), ADD KEY `css_themes_user_id_index` (`user_id`); -- -- Indexes for table `csv_exports` -- ALTER TABLE `csv_exports` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `csv_exports_cache_name_unique` (`cache_name`), ADD KEY `csv_exports_user_id_index` (`user_id`); -- -- Indexes for table `custom_domains` -- ALTER TABLE `custom_domains` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `custom_domains_host_unique` (`host`), ADD KEY `custom_domains_user_id_index` (`user_id`), ADD KEY `custom_domains_created_at_index` (`created_at`), ADD KEY `custom_domains_updated_at_index` (`updated_at`), ADD KEY `custom_domains_global_index` (`global`), ADD KEY `custom_domains_resource_id_index` (`resource_id`), ADD KEY `custom_domains_resource_type_index` (`resource_type`), ADD KEY `custom_domains_workspace_id_index` (`workspace_id`); -- -- Indexes for table `custom_pages` -- ALTER TABLE `custom_pages` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `pages_slug_unique` (`slug`), ADD KEY `pages_type_index` (`type`), ADD KEY `pages_user_id_index` (`user_id`), ADD KEY `custom_pages_workspace_id_index` (`workspace_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 `fcm_tokens` -- ALTER TABLE `fcm_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `fcm_tokens_device_id_user_id_unique` (`device_id`,`user_id`), ADD KEY `fcm_tokens_device_id_index` (`device_id`), ADD KEY `fcm_tokens_token_index` (`token`), ADD KEY `fcm_tokens_user_id_index` (`user_id`); -- -- Indexes for table `file_entries` -- ALTER TABLE `file_entries` ADD PRIMARY KEY (`id`), ADD KEY `files_user_id_index` (`user_id`), ADD KEY `files_folder_id_index` (`parent_id`), ADD KEY `file_entries_name_index` (`name`), ADD KEY `file_entries_path_index` (`path`), ADD KEY `file_entries_type_index` (`type`), ADD KEY `file_entries_public_index` (`public`), ADD KEY `file_entries_description_index` (`description`), ADD KEY `file_entries_workspace_id_index` (`workspace_id`), ADD KEY `file_entries_owner_id_index` (`owner_id`); -- -- Indexes for table `file_entry_models` -- ALTER TABLE `file_entry_models` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uploadable_unique` (`file_entry_id`,`model_id`,`model_type`), ADD KEY `file_entry_models_owner_index` (`owner`); -- -- Indexes for table `folders` -- ALTER TABLE `folders` ADD PRIMARY KEY (`id`), ADD KEY `folders_user_id_index` (`user_id`), ADD KEY `folders_share_id_index` (`share_id`), ADD KEY `folders_folder_id_index` (`folder_id`); -- -- Indexes for table `follows` -- ALTER TABLE `follows` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `follows_follower_id_followed_id_unique` (`follower_id`,`followed_id`); -- -- Indexes for table `invoices` -- ALTER TABLE `invoices` ADD PRIMARY KEY (`id`), ADD KEY `invoices_subscription_id_index` (`subscription_id`), ADD KEY `invoices_uuid_index` (`uuid`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`); -- -- Indexes for table `localizations` -- ALTER TABLE `localizations` ADD PRIMARY KEY (`id`), ADD KEY `localizations_name_index` (`name`), ADD KEY `localizations_language_index` (`language`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`), ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`); -- -- Indexes for table `notification_subscriptions` -- ALTER TABLE `notification_subscriptions` ADD PRIMARY KEY (`id`), ADD KEY `notification_subscriptions_notif_id_index` (`notif_id`), ADD KEY `notification_subscriptions_user_id_index` (`user_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `permissionables` -- ALTER TABLE `permissionables` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissionable_unique` (`permission_id`,`permissionable_id`,`permissionable_type`), ADD KEY `permissionables_permission_id_index` (`permission_id`), ADD KEY `permissionables_permissionable_id_index` (`permissionable_id`), ADD KEY `permissionables_permissionable_type_index` (`permissionable_type`); -- -- Indexes for table `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissions_name_unique` (`name`), ADD KEY `permissions_advanced_index` (`advanced`); -- -- 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 `prices` -- ALTER TABLE `prices` ADD PRIMARY KEY (`id`), ADD KEY `prices_product_id_index` (`product_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD KEY `products_position_index` (`position`), ADD KEY `products_free_index` (`free`), ADD KEY `products_hidden_index` (`hidden`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `groups_name_unique` (`name`), ADD KEY `groups_default_index` (`default`), ADD KEY `groups_guests_index` (`guests`), ADD KEY `roles_internal_index` (`internal`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `settings_name_unique` (`name`), ADD KEY `settings_private_index` (`private`); -- -- Indexes for table `shareable_links` -- ALTER TABLE `shareable_links` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `shareable_links_hash_unique` (`hash`), ADD KEY `shareable_links_user_id_index` (`user_id`), ADD KEY `shareable_links_entry_id_index` (`entry_id`); -- -- Indexes for table `social_profiles` -- ALTER TABLE `social_profiles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `social_profiles_user_id_service_name_unique` (`user_id`,`service_name`), ADD UNIQUE KEY `social_profiles_service_name_user_service_id_unique` (`service_name`,`user_service_id`), ADD KEY `social_profiles_user_id_index` (`user_id`); -- -- Indexes for table `subscriptions` -- ALTER TABLE `subscriptions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `subscriptions_gateway_id_unique` (`gateway_id`), ADD KEY `subscriptions_user_id_index` (`user_id`), ADD KEY `subscriptions_plan_id_index` (`price_id`), ADD KEY `subscriptions_gateway_index` (`gateway_name`), ADD KEY `subscriptions_product_id_index` (`product_id`); -- -- Indexes for table `taggables` -- ALTER TABLE `taggables` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `taggable_unique` (`tag_id`,`taggable_id`,`user_id`,`taggable_type`), ADD KEY `taggables_tag_id_index` (`tag_id`), ADD KEY `taggables_taggable_id_index` (`taggable_id`), ADD KEY `taggables_taggable_type_index` (`taggable_type`), ADD KEY `taggables_user_id_index` (`user_id`); -- -- Indexes for table `tags` -- ALTER TABLE `tags` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tags_name_user_id_type_unique` (`name`,`user_id`,`type`), ADD KEY `tags_type_index` (`type`), ADD KEY `tags_created_at_index` (`created_at`), ADD KEY `tags_updated_at_index` (`updated_at`), ADD KEY `tags_user_id_index` (`user_id`); -- -- Indexes for table `uploads` -- ALTER TABLE `uploads` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uploads_file_name_unique` (`file_name`), ADD KEY `uploads_name_index` (`name`), ADD KEY `uploads_user_id_index` (`user_id`), ADD KEY `uploads_public_index` (`public`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_created_at_index` (`created_at`), ADD KEY `users_updated_at_index` (`updated_at`), ADD KEY `users_username_index` (`username`), ADD KEY `users_paypal_id_index` (`paypal_id`); -- -- Indexes for table `users_oauth` -- ALTER TABLE `users_oauth` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_oauth_user_id_service_unique` (`user_id`,`service`), ADD UNIQUE KEY `users_oauth_token_unique` (`token`), ADD KEY `users_oauth_user_id_index` (`user_id`); -- -- Indexes for table `user_role` -- ALTER TABLE `user_role` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_group_user_id_group_id_unique` (`user_id`,`role_id`); -- -- Indexes for table `workspaces` -- ALTER TABLE `workspaces` ADD PRIMARY KEY (`id`), ADD KEY `workspaces_owner_id_index` (`owner_id`), ADD KEY `workspaces_created_at_index` (`created_at`), ADD KEY `workspaces_updated_at_index` (`updated_at`); -- -- Indexes for table `workspace_invites` -- ALTER TABLE `workspace_invites` ADD PRIMARY KEY (`id`), ADD KEY `workspace_invites_workspace_id_index` (`workspace_id`), ADD KEY `workspace_invites_user_id_index` (`user_id`), ADD KEY `workspace_invites_email_index` (`email`), ADD KEY `workspace_invites_role_id_index` (`role_id`); -- -- Indexes for table `workspace_user` -- ALTER TABLE `workspace_user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `workspace_user_workspace_id_user_id_unique` (`workspace_id`,`user_id`), ADD KEY `workspace_user_user_id_index` (`user_id`), ADD KEY `workspace_user_workspace_id_index` (`workspace_id`), ADD KEY `workspace_user_role_id_index` (`role_id`), ADD KEY `workspace_user_is_owner_index` (`is_owner`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `active_sessions` -- ALTER TABLE `active_sessions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `bans` -- ALTER TABLE `bans` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `billing_plans` -- ALTER TABLE `billing_plans` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `comments` -- ALTER TABLE `comments` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `comment_reports` -- ALTER TABLE `comment_reports` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `comment_votes` -- ALTER TABLE `comment_votes` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `css_themes` -- ALTER TABLE `css_themes` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `csv_exports` -- ALTER TABLE `csv_exports` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `custom_domains` -- ALTER TABLE `custom_domains` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `custom_pages` -- ALTER TABLE `custom_pages` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `fcm_tokens` -- ALTER TABLE `fcm_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file_entries` -- ALTER TABLE `file_entries` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `file_entry_models` -- ALTER TABLE `file_entry_models` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `folders` -- ALTER TABLE `folders` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `follows` -- ALTER TABLE `follows` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `invoices` -- ALTER TABLE `invoices` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `localizations` -- ALTER TABLE `localizations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=132; -- -- AUTO_INCREMENT for table `permissionables` -- ALTER TABLE `permissionables` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69; -- -- AUTO_INCREMENT for table `permissions` -- ALTER TABLE `permissions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53; -- -- 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 `prices` -- ALTER TABLE `prices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `shareable_links` -- ALTER TABLE `shareable_links` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `social_profiles` -- ALTER TABLE `social_profiles` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `subscriptions` -- ALTER TABLE `subscriptions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `taggables` -- ALTER TABLE `taggables` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tags` -- ALTER TABLE `tags` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `uploads` -- ALTER TABLE `uploads` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users_oauth` -- ALTER TABLE `users_oauth` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user_role` -- ALTER TABLE `user_role` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `workspaces` -- ALTER TABLE `workspaces` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `workspace_user` -- ALTER TABLE `workspace_user` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; 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 */;