IP : 3.145.105.116Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
./
../
var/
lve/
./
../
softaculous/
collab/
../
rainloop/
../
joomla30/
joomla30.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `[[dbprefix]]assets` --
CREATE TABLE `[[dbprefix]]assets` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int NOT NULL DEFAULT '0' COMMENT 'Nested set parent.', `lft` int NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `level` int unsigned NOT NULL COMMENT 'The cached level in the nested tree.', `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The unique name for the asset.', `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.', `rules` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_asset_name` (`name`), KEY `idx_lft_rgt` (`lft`,`rgt`), KEY `idx_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=100 ;
-- -- Dumping data for table `[[dbprefix]]assets` --
-- -- Table structure for table `[[dbprefix]]associations` --
CREATE TABLE `[[dbprefix]]associations` ( `id` int NOT NULL COMMENT 'A reference to the associated item.', `context` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The context of the associated item.', `key` char(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.', PRIMARY KEY (`context`,`id`), KEY `idx_key` (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table `[[dbprefix]]content` --
CREATE TABLE `[[dbprefix]]content` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `asset_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `introtext` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `fulltext` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `state` tinyint NOT NULL DEFAULT '0', `catid` int unsigned NOT NULL DEFAULT '0', `created` datetime NOT NULL, `created_by` int unsigned NOT NULL DEFAULT '0', `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `modified` datetime NOT NULL, `modified_by` int unsigned NOT NULL DEFAULT '0', `checked_out` int unsigned DEFAULT NULL, `checked_out_time` datetime DEFAULT NULL, `publish_up` datetime DEFAULT NULL, `publish_down` datetime DEFAULT NULL, `images` text COLLATE utf8mb4_unicode_ci NOT NULL, `urls` text COLLATE utf8mb4_unicode_ci NOT NULL, `attribs` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL, `version` int unsigned NOT NULL DEFAULT '1', `ordering` int NOT NULL DEFAULT '0', `metakey` text COLLATE utf8mb4_unicode_ci, `metadesc` text COLLATE utf8mb4_unicode_ci NOT NULL, `access` int unsigned NOT NULL DEFAULT '0', `hits` int unsigned NOT NULL DEFAULT '0', `metadata` text COLLATE utf8mb4_unicode_ci NOT NULL, `featured` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Set if article is featured.', `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The language code for the article.', `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`state`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_featured_catid` (`featured`,`catid`), KEY `idx_language` (`language`), KEY `idx_alias` (`alias`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table `[[dbprefix]]contentitem_tag_map` --
CREATE TABLE `[[dbprefix]]contentitem_tag_map` ( `type_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `core_content_id` int unsigned NOT NULL COMMENT 'PK from the core content table', `content_item_id` int NOT NULL COMMENT 'PK from the content type table', `tag_id` int unsigned NOT NULL COMMENT 'PK from the tag table', `tag_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of most recent save for this tag-item', `type_id` mediumint NOT NULL COMMENT 'PK from the content_type table', UNIQUE KEY `uc_ItemnameTagid` (`type_id`,`content_item_id`,`tag_id`), KEY `idx_tag_type` (`tag_id`,`type_id`), KEY `idx_date_id` (`tag_date`,`tag_id`), KEY `idx_core_content_id` (`core_content_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Maps items from content tables to tags';
-- -- Table structure for table `[[dbprefix]]extensions` --
CREATE TABLE `[[dbprefix]]extensions` ( `extension_id` int NOT NULL AUTO_INCREMENT, `package_id` int NOT NULL DEFAULT '0' COMMENT 'Parent package ID for extensions installed as a package.', `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `element` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `changelogurl` text COLLATE utf8mb4_unicode_ci, `folder` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `client_id` tinyint NOT NULL, `enabled` tinyint NOT NULL DEFAULT '0', `access` int unsigned NOT NULL DEFAULT '1', `protected` tinyint NOT NULL DEFAULT '0' COMMENT 'Flag to indicate if the extension is protected. Protected extensions cannot be disabled.', `locked` tinyint NOT NULL DEFAULT '0' COMMENT 'Flag to indicate if the extension is locked. Locked extensions cannot be uninstalled.', `manifest_cache` text COLLATE utf8mb4_unicode_ci NOT NULL, `params` text COLLATE utf8mb4_unicode_ci NOT NULL, `custom_data` text COLLATE utf8mb4_unicode_ci NOT NULL, `checked_out` int unsigned DEFAULT NULL, `checked_out_time` datetime DEFAULT NULL, `ordering` int DEFAULT '0', `state` int DEFAULT '0', `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`extension_id`), KEY `element_clientid` (`element`,`client_id`), KEY `element_folder_clientid` (`element`,`folder`,`client_id`), KEY `extension` (`type`,`element`,`folder`,`client_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=245 ;
-- -- Dumping data for table `[[dbprefix]]extensions` --
-- -- Table structure for table `[[dbprefix]]guidedtours` --
CREATE TABLE `[[dbprefix]]guidedtours` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `uid` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `ordering` int NOT NULL DEFAULT '0', `extensions` text COLLATE utf8mb4_unicode_ci NOT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, `created_by` int NOT NULL DEFAULT '0', `modified` datetime NOT NULL, `modified_by` int NOT NULL DEFAULT '0', `checked_out_time` datetime DEFAULT NULL, `checked_out` int unsigned DEFAULT NULL, `published` tinyint NOT NULL DEFAULT '0', `language` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL, `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `access` int unsigned NOT NULL DEFAULT '0', `autostart` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_state` (`published`), KEY `idx_language` (`language`), KEY `idx_uid` (`uid`(191)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=13 ;
-- -- Dumping data for table `[[dbprefix]]guidedtours` --
-- -- Table structure for table `[[dbprefix]]guidedtour_steps` --
CREATE TABLE `[[dbprefix]]guidedtour_steps` ( `id` int NOT NULL AUTO_INCREMENT, `tour_id` int NOT NULL DEFAULT '0', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `published` tinyint NOT NULL DEFAULT '0', `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `ordering` int NOT NULL DEFAULT '0', `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `target` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `type` int NOT NULL, `interactive_type` int NOT NULL DEFAULT '1', `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, `created_by` int unsigned NOT NULL DEFAULT '0', `modified` datetime NOT NULL, `modified_by` int unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime DEFAULT NULL, `checked_out` int unsigned DEFAULT NULL, `language` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL, `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `params` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `idx_tour` (`tour_id`), KEY `idx_state` (`published`), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=118 ;
-- -- Dumping data for table `[[dbprefix]]guidedtour_steps` --
-- -- Table structure for table `[[dbprefix]]menu` --
CREATE TABLE `[[dbprefix]]menu` ( `id` int NOT NULL AUTO_INCREMENT, `menutype` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The display title of the menu item.', `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'The SEF alias of the menu item.', `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `path` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The computed path of the menu item based on the alias field.', `link` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The actually link the menu item refers to.', `type` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator', `published` tinyint NOT NULL DEFAULT '0' COMMENT 'The published state of the menu link.', `parent_id` int unsigned NOT NULL DEFAULT '1' COMMENT 'The parent menu item in the menu tree.', `level` int unsigned NOT NULL DEFAULT '0' COMMENT 'The relative level in the tree.', `component_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__extensions.id', `checked_out` int unsigned DEFAULT NULL COMMENT 'FK to #__users.id', `checked_out_time` datetime DEFAULT NULL COMMENT 'The time the menu item was checked out.', `browserNav` tinyint NOT NULL DEFAULT '0' COMMENT 'The click behaviour of the link.', `access` int unsigned NOT NULL DEFAULT '0' COMMENT 'The access level required to view the menu item.', `img` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The image of the menu item.', `template_style_id` int unsigned NOT NULL DEFAULT '0', `params` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded data for the menu item.', `lft` int NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `home` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Indicates if this menu item is the home or default page.', `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `client_id` tinyint NOT NULL DEFAULT '0', `publish_up` datetime DEFAULT NULL, `publish_down` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`(100),`language`), KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`), KEY `idx_menutype` (`menutype`), KEY `idx_left_right` (`lft`,`rgt`), KEY `idx_alias` (`alias`(100)), KEY `idx_path` (`path`(100)), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=102 ;
-- -- Dumping data for table `[[dbprefix]]menu` --
-- -- Table structure for table `[[dbprefix]]newsfeeds` --
CREATE TABLE `[[dbprefix]]newsfeeds` ( `catid` int NOT NULL DEFAULT '0', `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `link` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `published` tinyint NOT NULL DEFAULT '0', `numarticles` int unsigned NOT NULL DEFAULT '1', `cache_time` int unsigned NOT NULL DEFAULT '3600', `checked_out` int unsigned DEFAULT NULL, `checked_out_time` datetime DEFAULT NULL, `ordering` int NOT NULL DEFAULT '0', `rtl` tinyint NOT NULL DEFAULT '0', `access` int unsigned NOT NULL DEFAULT '0', `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `params` text COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, `created_by` int unsigned NOT NULL DEFAULT '0', `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `modified` datetime NOT NULL, `modified_by` int unsigned NOT NULL DEFAULT '0', `metakey` text COLLATE utf8mb4_unicode_ci, `metadesc` text COLLATE utf8mb4_unicode_ci NOT NULL, `metadata` text COLLATE utf8mb4_unicode_ci NOT NULL, `publish_up` datetime DEFAULT NULL, `publish_down` datetime DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `version` int unsigned NOT NULL DEFAULT '1', `hits` int unsigned NOT NULL DEFAULT '0', `images` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`published`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table `[[dbprefix]]scheduler_tasks` --
CREATE TABLE `[[dbprefix]]scheduler_tasks` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `asset_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `type` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'unique identifier for job defined by plugin', `execution_rules` text COLLATE utf8mb4_unicode_ci COMMENT 'Execution Rules, Unprocessed', `cron_rules` text COLLATE utf8mb4_unicode_ci COMMENT 'Processed execution rules, crontab-like JSON form', `state` tinyint NOT NULL DEFAULT '0', `last_exit_code` int NOT NULL DEFAULT '0' COMMENT 'Exit code when job was last run', `last_execution` datetime DEFAULT NULL COMMENT 'Timestamp of last run', `next_execution` datetime DEFAULT NULL COMMENT 'Timestamp of next (planned) run, referred for execution on trigger', `times_executed` int DEFAULT '0' COMMENT 'Count of successful triggers', `times_failed` int DEFAULT '0' COMMENT 'Count of failures', `locked` datetime DEFAULT NULL, `priority` smallint NOT NULL DEFAULT '0', `ordering` int NOT NULL DEFAULT '0' COMMENT 'Configurable list ordering', `cli_exclusive` smallint NOT NULL DEFAULT '0' COMMENT 'If 1, the task is only accessible via CLI', `params` text COLLATE utf8mb4_unicode_ci NOT NULL, `note` text COLLATE utf8mb4_unicode_ci, `created` datetime NOT NULL, `created_by` int unsigned NOT NULL DEFAULT '0', `checked_out` int unsigned DEFAULT NULL, `checked_out_time` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_type` (`type`), KEY `idx_state` (`state`), KEY `idx_last_exit` (`last_exit_code`), KEY `idx_next_exec` (`next_execution`), KEY `idx_locked` (`locked`), KEY `idx_priority` (`priority`), KEY `idx_cli_exclusive` (`cli_exclusive`), KEY `idx_checked_out` (`checked_out`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;
-- -- Dumping data for table `[[dbprefix]]scheduler_tasks` --
-- -- Table structure for table `[[dbprefix]]tags` --
CREATE TABLE `[[dbprefix]]tags` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `parent_id` int unsigned NOT NULL DEFAULT '0', `lft` int NOT NULL DEFAULT '0', `rgt` int NOT NULL DEFAULT '0', `level` int unsigned NOT NULL DEFAULT '0', `path` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `published` tinyint NOT NULL DEFAULT '0', `checked_out` int unsigned DEFAULT NULL, `checked_out_time` datetime DEFAULT NULL, `access` int unsigned NOT NULL DEFAULT '0', `params` text COLLATE utf8mb4_unicode_ci NOT NULL, `metadesc` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The meta description for the page.', `metakey` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'The keywords for the page.', `metadata` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded metadata properties.', `created_user_id` int unsigned NOT NULL DEFAULT '0', `created_time` datetime NOT NULL, `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `modified_user_id` int unsigned NOT NULL DEFAULT '0', `modified_time` datetime NOT NULL, `images` text COLLATE utf8mb4_unicode_ci NOT NULL, `urls` text COLLATE utf8mb4_unicode_ci NOT NULL, `hits` int unsigned NOT NULL DEFAULT '0', `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL, `version` int unsigned NOT NULL DEFAULT '1', `publish_up` datetime DEFAULT NULL, `publish_down` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `tag_idx` (`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_path` (`path`(100)), KEY `idx_left_right` (`lft`,`rgt`), KEY `idx_alias` (`alias`(100)), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
-- -- Dumping data for table `[[dbprefix]]tags` --
-- -- Table structure for table `[[dbprefix]]ucm_base` --
CREATE TABLE `[[dbprefix]]ucm_base` ( `ucm_id` int unsigned NOT NULL, `ucm_item_id` int NOT NULL, `ucm_type_id` int NOT NULL, `ucm_language_id` int NOT NULL, PRIMARY KEY (`ucm_id`), KEY `idx_ucm_item_id` (`ucm_item_id`), KEY `idx_ucm_type_id` (`ucm_type_id`), KEY `idx_ucm_language_id` (`ucm_language_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- -- Table structure for table `[[dbprefix]]user_profiles` --
CREATE TABLE `[[dbprefix]]user_profiles` ( `user_id` int NOT NULL, `profile_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `profile_value` text COLLATE utf8mb4_unicode_ci NOT NULL, `ordering` int NOT NULL DEFAULT '0', UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';
/*!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 */;