[encoded data, 256730 characters]\";', 465, 'Christian');
INSERT INTO `lfuve_session` (`session_id`, `client_id`, `guest`, `time`, `data`, `userid`, `username`) VALUES
(0x683032376261636838346e327376757571326938677233636871, 0, 1, 1723960433, 'joomla|s:700:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjM7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzIzOTYwMzk0O3M6NDoibGFzdCI7aToxNzIzOTYwNDE5O3M6Mzoibm93IjtpOjE3MjM5NjA0MzM7fXM6NToidG9rZW4iO3M6MzI6ImJhNTgzNTA1ZDRjNThkMzI4YjhmYmM0YmRiZDI3NzRjIjt9czo4OiJyZWdpc3RyeSI7TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e31zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6MTI6IgAqAHNlcGFyYXRvciI7czoxOiIuIjt9czo0OiJ1c2VyIjtPOjIwOiJKb29tbGFcQ01TXFVzZXJcVXNlciI6MTp7czoyOiJpZCI7aTowO319czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjEyOiIAKgBzZXBhcmF0b3IiO3M6MToiLiI7fQ==\";', 0, ''),
(0x686365396b72686c6b76666776726e3167326964683138733471, 0, 1, 1723942916, 'joomla|s:700:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjM6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjM1O3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTcyMzk0MTA5MztzOjQ6Imxhc3QiO2k6MTcyMzk0MjcyNDtzOjM6Im5vdyI7aToxNzIzOTQyOTE2O31zOjU6InRva2VuIjtzOjMyOiJlOWMwNDBkYTExOGIwMWE1ZjY2MmRiZWI3OTE2ZWQxMSI7fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6Mzp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjEyOiIAKgBzZXBhcmF0b3IiO3M6MToiLiI7fXM6NDoidXNlciI7TzoyMDoiSm9vbWxhXENNU1xVc2VyXFVzZXIiOjE6e3M6MjoiaWQiO2k6MDt9fXM6MTQ6IgAqAGluaXRpYWxpemVkIjtiOjA7czoxMjoiACoAc2VwYXJhdG9yIjtzOjE6Ii4iO30=\";', 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_tags`
--

CREATE TABLE `lfuve_tags` (
  `id` int UNSIGNED NOT NULL,
  `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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `access` int UNSIGNED NOT NULL DEFAULT '0',
  `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadesc` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The meta description for the page.',
  `metakey` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `metadata` varchar(2048) CHARACTER SET utf8mb4 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `modified_user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `modified_time` datetime NOT NULL,
  `images` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `urls` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hits` int UNSIGNED NOT NULL DEFAULT '0',
  `language` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` int UNSIGNED NOT NULL DEFAULT '1',
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_tags`
--

INSERT INTO `lfuve_tags` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `created_by_alias`, `modified_user_id`, `modified_time`, `images`, `urls`, `hits`, `language`, `version`, `publish_up`, `publish_down`) VALUES
(1, 0, 0, 1, 0, '', 'ROOT', 'root', '', '', 1, NULL, NULL, 1, '{}', '', '', '', 0, '2011-01-01 00:00:01', '', 0, '2011-01-01 00:00:01', '', '', 0, '*', 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_template_overrides`
--

CREATE TABLE `lfuve_template_overrides` (
  `id` int UNSIGNED NOT NULL,
  `template` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `hash_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `extension_id` int DEFAULT '0',
  `state` tinyint NOT NULL DEFAULT '0',
  `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `client_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `created_date` datetime NOT NULL,
  `modified_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_template_overrides`
--

INSERT INTO `lfuve_template_overrides` (`id`, `template`, `hash_id`, `extension_id`, `state`, `action`, `client_id`, `created_date`, `modified_date`) VALUES
(1, 'ja_healthcare', 'L2h0bWwvY29tX2NvbnRhY3QvY29udGFjdC9kZWZhdWx0LnBocA==', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-01-15 04:11:59'),
(2, 'ja_healthcare', 'L2h0bWwvY29tX2NvbnRhY3QvY29udGFjdC9kZWZhdWx0X2FkZHJlc3MucGhw', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-03-28 00:55:30'),
(3, 'ja_healthcare', 'L2h0bWwvY29tX2NvbnRhY3QvY29udGFjdC9kZWZhdWx0X2xpbmtzLnBocA==', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-04-18 10:57:02'),
(4, 'ja_healthcare', 'L2h0bWwvY29tX2NvbnRlbnQvY2F0ZWdvcnkvYmxvZy5waHA=', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-04-18 10:57:02'),
(5, 'ja_healthcare', 'L2h0bWwvY29tX2NvbnRlbnQvYXJ0aWNsZS9kZWZhdWx0LnBocA==', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-04-18 10:57:02'),
(6, 'ja_healthcare', 'L2h0bWwvY29tX2NvbnRlbnQvZmVhdHVyZWQvZGVmYXVsdF9pdGVtLnBocA==', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-01-15 04:11:59'),
(7, 'ja_healthcare', 'L2h0bWwvY29tX3RhZ3MvdGFnL2RlZmF1bHRfaXRlbXMucGhw', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-01-15 04:11:59'),
(8, 'ja_healthcare', 'L2h0bWwvY29tX3VzZXJzL3Byb2ZpbGUvZGVmYXVsdC5waHA=', 10161, 1, 'Joomla Update', 0, '2024-01-15 04:11:59', '2024-01-15 04:11:59');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_template_styles`
--

CREATE TABLE `lfuve_template_styles` (
  `id` int UNSIGNED NOT NULL,
  `template` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `client_id` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `home` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `inheritable` tinyint NOT NULL DEFAULT '0',
  `parent` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_template_styles`
--

INSERT INTO `lfuve_template_styles` (`id`, `template`, `client_id`, `home`, `title`, `params`, `inheritable`, `parent`) VALUES
(16, 'ja_healthcare', 0, '1', 'ja_healthcare - Default', '{\"t3_template\":\"1\",\"devmode\":\"0\",\"themermode\":\"1\",\"legacy_css\":\"0\",\"responsive\":\"1\",\"non_responsive_width\":\"970px\",\"build_rtl\":\"0\",\"t3-assets\":\"t3-assets\",\"t3-rmvlogo\":\"0\",\"minify\":\"1\",\"minify_js\":\"0\",\"minify_js_tool\":\"jsmin\",\"minify_exclude\":\"js-fa1f2-07890.js,js-1eaa8-25150.js\",\"link_titles\":\"\",\"theme\":\"gym\",\"logotype\":\"image\",\"sitename\":\"Jull Cars\",\"slogan\":\"\",\"logoimage\":\"images\\/jull-cars-logo.png\",\"enable_logoimage_sm\":\"1\",\"logoimage_sm\":\"images\\/jull-cars-logo-sm.png\",\"mainlayout\":\"default-nosidebar\",\"sublayout\":\"default-nosidebar\",\"mm_type\":\"mainmenu\",\"navigation_trigger\":\"hover\",\"navigation_type\":\"megamenu\",\"navigation_animation\":\"zoom\",\"navigation_animation_duration\":\"400\",\"mm_config\":\"{\\\"mainmenu\\\":{\\\"item-117\\\":{\\\"sub\\\":{\\\"width\\\":\\\"450\\\",\\\"rows\\\":[[{\\\"item\\\":118,\\\"width\\\":6},{\\\"item\\\":122,\\\"width\\\":6}]]}},\\\"item-127\\\":{\\\"sub\\\":{\\\"width\\\":\\\"450\\\",\\\"rows\\\":[[{\\\"item\\\":128,\\\"width\\\":6},{\\\"item\\\":136,\\\"width\\\":6}]]}},\\\"item-144\\\":{\\\"sub\\\":{\\\"width\\\":\\\"375\\\",\\\"rows\\\":[[{\\\"item\\\":145,\\\"width\\\":12}]]}},\\\"item-110\\\":{\\\"sub\\\":{\\\"width\\\":300,\\\"rows\\\":[[{\\\"item\\\":111,\\\"width\\\":12}]]}}}}\",\"navigation_collapse_enable\":\"1\",\"addon_offcanvas_enable\":\"0\",\"addon_offcanvas_effect\":\"off-canvas-effect-4\",\"snippet_open_head\":\"\",\"snippet_close_head\":\"\",\"snippet_open_body\":\"\",\"snippet_close_body\":\"\",\"snippet_debug\":\"0\"}', 0, ''),
(17, 'atum', 1, '1', 'Atum - Default', '{\"hue\": \"hsl(214, 63%, 20%)\", \"bg-light\": \"#f0f4fb\", \"loginLogo\": \"\", \"text-dark\": \"#495057\", \"link-color\": \"#2a69b8\", \"monochrome\": \"0\", \"text-light\": \"#ffffff\", \"colorScheme\": \"os\", \"loginLogoAlt\": \"\", \"special-color\": \"#001b4c\", \"logoBrandLarge\": \"\", \"logoBrandSmall\": \"\", \"logoBrandLargeAlt\": \"\", \"logoBrandSmallAlt\": \"\"}', 1, ''),
(18, 'cassiopeia', 0, '0', 'Cassiopeia - Default', '{}', 1, '');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_tuf_metadata`
--

CREATE TABLE `lfuve_tuf_metadata` (
  `id` int NOT NULL,
  `update_site_id` int DEFAULT '0',
  `root` text COLLATE utf8mb4_unicode_ci,
  `targets` text COLLATE utf8mb4_unicode_ci,
  `snapshot` text COLLATE utf8mb4_unicode_ci,
  `timestamp` text COLLATE utf8mb4_unicode_ci,
  `mirrors` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Secure TUF Updates';

--
-- Dumping data for table `lfuve_tuf_metadata`
--

INSERT INTO `lfuve_tuf_metadata` (`id`, `update_site_id`, `root`, `targets`, `snapshot`, `timestamp`, `mirrors`) VALUES
(1, 1, '{\"signed\":{\"_type\":\"root\",\"spec_version\":\"1.0\",\"version\":4,\"expires\":\"2025-03-02T16:38:55Z\",\"keys\":{\"07eb082f367c034a95878687f6648aa76d93652b6ee73e58817053d89af6c44f\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"9b2af2d9b9727227735253d795bd27ea8f0e294a5f3603e822dc5052b44802b9\"}},\"1b1b1dd55b2c1c7258714cf1c1ae06f23e4607b28c762d016a9d81c48ffe5669\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"a18e5ebabc19d5d5984b601a292ece61ba3662ab2d071dc520da5bd4f8948799\"}},\"2dcaf3d0e552f150792f7c636d45429246dcfa34ac35b46a44f5c87cd17d457e\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"cb0a7a131961a20edea051d6dc2b091fb650bd399bd8514adb67b3c60db9f8f9\"}},\"31dd7c7290d664c9b88c0dead2697175293ea7df81b7f24153a37370fd3901c3\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"589d029a68b470deff1ca16dbf3eea6b5b3fcba0ae7bb52c468abc7fb058b2a2\"}},\"9e41a9d62d94c6a1c8a304f62c5bd72d84a9f286f27e8327cedeacb09e5156cc\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"6043c8bacc76ac5c9750f45454dd865c6ca1fc57d69e14cc192cfd420f6a66a9\"}},\"e2229942b0fc1e6d7f82adf258e5bdadac10046d1470b7ec459c9eb4e076026b\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"ad1950e117b29ebe7a38635a2e574123e07571e4f9a011783e053b5f15d2562a\"}},\"ecc851a051c8d6439331ff0a37c7727321fc39896a34f950f73638b8a7cb472e\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"5d451915bc2b93a0e4e4745bc6a8b292d58996d50e0fb66c78c7827152a65879\"}}},\"roles\":{\"root\":{\"keyids\":[\"1b1b1dd55b2c1c7258714cf1c1ae06f23e4607b28c762d016a9d81c48ffe5669\",\"2dcaf3d0e552f150792f7c636d45429246dcfa34ac35b46a44f5c87cd17d457e\"],\"threshold\":1},\"snapshot\":{\"keyids\":[\"07eb082f367c034a95878687f6648aa76d93652b6ee73e58817053d89af6c44f\",\"2dcaf3d0e552f150792f7c636d45429246dcfa34ac35b46a44f5c87cd17d457e\",\"ecc851a051c8d6439331ff0a37c7727321fc39896a34f950f73638b8a7cb472e\",\"e2229942b0fc1e6d7f82adf258e5bdadac10046d1470b7ec459c9eb4e076026b\"],\"threshold\":1},\"targets\":{\"keyids\":[\"31dd7c7290d664c9b88c0dead2697175293ea7df81b7f24153a37370fd3901c3\",\"ecc851a051c8d6439331ff0a37c7727321fc39896a34f950f73638b8a7cb472e\",\"e2229942b0fc1e6d7f82adf258e5bdadac10046d1470b7ec459c9eb4e076026b\"],\"threshold\":1},\"timestamp\":{\"keyids\":[\"9e41a9d62d94c6a1c8a304f62c5bd72d84a9f286f27e8327cedeacb09e5156cc\"],\"threshold\":1}},\"consistent_snapshot\":true},\"signatures\":[{\"keyid\":\"1b1b1dd55b2c1c7258714cf1c1ae06f23e4607b28c762d016a9d81c48ffe5669\",\"sig\":\"1c8060aab4c5290dc398199d8f124701bd3f7d3fb47d688e3e61d20eeb90d6e387556ce680ba8db9b99f15332df64da349a03344f50ab4f1fe491efdf88f170c\"}]}', '{\"signed\":{\"_type\":\"targets\",\"spec_version\":\"1.0\",\"version\":19,\"expires\":\"2024-11-12T09:12:43Z\",\"targets\":{\"Joomla_5.1.2-Stable-Update_Package.zip\":{\"length\":28134889,\"hashes\":{\"sha512\":\"d6b46cdedb9b31d01a607fe4c2f3a830a3265ed6ae5c0cb7b0f836b1b016ee7c639bd8948df00baf1b61a87f2fc71368a80b39e67ef9ec2b8842ee0ab09a620f\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.1.2 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla5/5-1-2/Joomla_5.1.2-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.1.2/Joomla_5.1.2-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/5.1.2/Joomla_5.1.2-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5909-joomla-5-1-2-and-joomla-4-4-6-security-and-bug-fix-release.html\",\"title\":\"Joomla! 5.1.2 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.1.2\",\"php_minimum\":\"8.1.0\",\"channel\":\"5.x\",\"stability\":\"Stable\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"11.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(5\\\\.[0-4])|^(4\\\\.4)\"},\"type\":\"file\",\"version\":\"5.1.2\"}},\"Joomla_5.1.2-Stable-Upgrade_Package.zip\":{\"length\":28134889,\"hashes\":{\"sha512\":\"d6b46cdedb9b31d01a607fe4c2f3a830a3265ed6ae5c0cb7b0f836b1b016ee7c639bd8948df00baf1b61a87f2fc71368a80b39e67ef9ec2b8842ee0ab09a620f\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.1.2 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla5/5-1-2/Joomla_5.1.2-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.1.2/Joomla_5.1.2-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/5.1.2/Joomla_5.1.2-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5909-joomla-5-1-2-and-joomla-4-4-6-security-and-bug-fix-release.html\",\"title\":\"Joomla! 5.1.2 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.1.2\",\"php_minimum\":\"8.1.0\",\"channel\":\"6.x\",\"stability\":\"Stable\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"11.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(5\\\\.[0-4])|^(4\\\\.4)\"},\"type\":\"file\",\"version\":\"5.1.2\"}},\"Joomla_5.1.3-rc1-Release_Candidate-Update_Package.zip\":{\"length\":28249605,\"hashes\":{\"sha512\":\"83f48e1ca0a8b9fc01b4a77340bee7ce826ab2fedf7e63d194622347c36bbdee6fc75070e0b078fb53c0978ee9d2fba67e7ccd2b4bf9dd9139cffeaba55dd506\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.1.3-rc1 Release Candidate 1\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.1.3-rc1/Joomla_5.1.3-rc1-Release_Candidate-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://github.com/joomla/joomla-cms/releases/tag/5.1.3-rc1\",\"title\":\"Joomla! 5.1.3-rc1 Release Candidate 1\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.1.3-rc1\",\"php_minimum\":\"8.1.0\",\"channel\":\"5.x\",\"stability\":\"RC\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"11.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(5\\\\.[0-4])|^(4\\\\.4)\"},\"type\":\"file\",\"version\":\"5.1.3-rc1\"}},\"Joomla_5.2.0-alpha2-Alpha-Update_Package.zip\":{\"length\":27543535,\"hashes\":{\"sha512\":\"367d4e553730d4a462891d543e8eafbca8c79159d86eef800ff56521557447c733e72dbdbc87b34ae00aac82ec3ac19948af17ce41a2341ea22386f52bc8edde\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.2.0-alpha2 Release\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.2.0-alpha2/Joomla_5.2.0-alpha2-Alpha-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://github.com/joomla/joomla-cms/releases/tag/5.2.0-alpha2\",\"title\":\"Joomla! 5.2.0-alpha2 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.2.0-alpha2\",\"php_minimum\":\"8.1.0\",\"channel\":\"5.x\",\"stability\":\"Alpha\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"11.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(5\\\\.[0-4])|^(4\\\\.4)\"},\"type\":\"file\",\"version\":\"5.2.0-alpha2\"}},\"Joomla_5.2.0-alpha3-Alpha-Update_Package.zip\":{\"length\":27582778,\"hashes\":{\"sha512\":\"9e517f9878f5860295ca5908eceda7fa4954bd5050ad088f57e65b52a45c314a8de36e843a5f892d063dd7d38956a80b437ffebc806983fb198ad78c0145d464\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.2.0-alpha3 Release\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.2.0-alpha3/Joomla_5.2.0-alpha3-Alpha-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://developer.joomla.org/news/940-joomla-5-2-0-alpha-3-needs-your-help.html\",\"title\":\"Joomla! 5.2.0-alpha3 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.2.0-alpha3\",\"php_minimum\":\"8.1.0\",\"channel\":\"5.x\",\"stability\":\"Alpha\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"11.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(5\\\\.[0-4])|^(4\\\\.4)\"},\"type\":\"file\",\"version\":\"5.2.0-alpha3\"}}}},\"signatures\":[{\"keyid\":\"e2229942b0fc1e6d7f82adf258e5bdadac10046d1470b7ec459c9eb4e076026b\",\"sig\":\"665af259090eb54dc7795ad1b8b402eb507049ad9152925a57fd9bb606d1472c5cf496226b1e1827527f2658ff99aee12e22b46aefb2ed8b859a8657f7dd7203\"}]}', '{\"signed\":{\"_type\":\"snapshot\",\"spec_version\":\"1.0\",\"version\":22,\"expires\":\"2025-03-10T09:13:39Z\",\"meta\":{\"targets.json\":{\"length\":5665,\"hashes\":{\"sha512\":\"4808dd9cda026d3a01e92bd7e4ea76bb8f0c02d75dbc6cdbbdd4a45951920484d733b475aabf02f62d016813bcb14bb0c2c9696bb367fb3dec8f6ca62eb59672\"},\"version\":19}}},\"signatures\":[{\"keyid\":\"07eb082f367c034a95878687f6648aa76d93652b6ee73e58817053d89af6c44f\",\"sig\":\"860d30b52c60231f3fa031e5dbfb82619e835929937cff00a076ec7eae941c592f63182b95e1046a8dbb3296e53c8f2c9d0fbae34607003a0546299fa99e7707\"}]}', '{\"signed\":{\"_type\":\"timestamp\",\"spec_version\":\"1.0\",\"version\":247,\"expires\":\"2024-08-19T01:21:58Z\",\"meta\":{\"snapshot.json\":{\"length\":531,\"hashes\":{\"sha512\":\"551440ff6c4f2cbfa82e047e5a4a94aba575ef706639be684b1a63ab41f7b2de7b75861742f89d9365d1846e6edb0cc93829889f2f3ff949b628c5af937cf9e4\"},\"version\":22}}},\"signatures\":[{\"keyid\":\"9e41a9d62d94c6a1c8a304f62c5bd72d84a9f286f27e8327cedeacb09e5156cc\",\"sig\":\"ebed4178542d045c21fad0d1300070c0561ce2c0628819fd4609b0d9153347b0f72a7389feb3e0b758a0b026754dddeb33bc3b142f17119b9d23f87f378f760b\"}]}', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_ucm_base`
--

CREATE TABLE `lfuve_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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_ucm_content`
--

CREATE TABLE `lfuve_ucm_content` (
  `core_content_id` int UNSIGNED NOT NULL,
  `core_type_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'FK to the content types table',
  `core_title` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `core_body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `core_state` tinyint(1) NOT NULL DEFAULT '0',
  `core_checked_out_time` datetime DEFAULT NULL,
  `core_checked_out_user_id` int UNSIGNED DEFAULT NULL,
  `core_access` int UNSIGNED NOT NULL DEFAULT '0',
  `core_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `core_featured` tinyint UNSIGNED NOT NULL DEFAULT '0',
  `core_metadata` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.',
  `core_created_user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `core_created_by_alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `core_created_time` datetime NOT NULL,
  `core_modified_user_id` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Most recent user that modified',
  `core_modified_time` datetime NOT NULL,
  `core_language` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `core_publish_up` datetime DEFAULT NULL,
  `core_publish_down` datetime DEFAULT NULL,
  `core_content_item_id` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'ID from the individual type table',
  `asset_id` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
  `core_images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `core_urls` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `core_hits` int UNSIGNED NOT NULL DEFAULT '0',
  `core_version` int UNSIGNED NOT NULL DEFAULT '1',
  `core_ordering` int NOT NULL DEFAULT '0',
  `core_metakey` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `core_metadesc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `core_catid` int UNSIGNED NOT NULL DEFAULT '0',
  `core_xreference` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
  `core_type_id` int UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Contains core content data in name spaced fields';

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_updates`
--

CREATE TABLE `lfuve_updates` (
  `update_id` int NOT NULL,
  `update_site_id` int DEFAULT '0',
  `extension_id` int DEFAULT '0',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `element` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `folder` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `client_id` tinyint DEFAULT '0',
  `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `detailsurl` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `infourl` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `changelogurl` text COLLATE utf8mb4_unicode_ci,
  `extra_query` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';

--
-- Dumping data for table `lfuve_updates`
--

INSERT INTO `lfuve_updates` (`update_id`, `update_site_id`, `extension_id`, `name`, `description`, `element`, `type`, `folder`, `client_id`, `version`, `data`, `detailsurl`, `infourl`, `changelogurl`, `extra_query`) VALUES
(2, 3, 0, 'Afrikaans', '', 'pkg_af-ZA', 'package', '', 0, '5.0.2.1', '', 'https://update.joomla.org/language/details5/af-ZA_details.xml', '', '', ''),
(3, 3, 0, 'Belarusian', '', 'pkg_be-BY', 'package', '', 0, '5.1.1.1', '', 'https://update.joomla.org/language/details5/be-BY_details.xml', '', '', ''),
(4, 3, 0, 'Catalan', '', 'pkg_ca-ES', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/ca-ES_details.xml', '', '', ''),
(5, 3, 0, 'Chinese, Simplified', '', 'pkg_zh-CN', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/zh-CN_details.xml', '', '', ''),
(6, 3, 0, 'Chinese, Traditional', '', 'pkg_zh-TW', 'package', '', 0, '5.0.3.1', '', 'https://update.joomla.org/language/details5/zh-TW_details.xml', '', '', ''),
(7, 3, 0, 'Czech', '', 'pkg_cs-CZ', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/cs-CZ_details.xml', '', '', ''),
(8, 3, 0, 'Danish', '', 'pkg_da-DK', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/da-DK_details.xml', '', '', ''),
(9, 3, 0, 'Dutch', '', 'pkg_nl-NL', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/nl-NL_details.xml', '', '', ''),
(10, 3, 0, 'English, Australia', '', 'pkg_en-AU', 'package', '', 0, '5.0.3.1', '', 'https://update.joomla.org/language/details5/en-AU_details.xml', '', '', ''),
(11, 3, 0, 'English, Canada', '', 'pkg_en-CA', 'package', '', 0, '5.0.3.1', '', 'https://update.joomla.org/language/details5/en-CA_details.xml', '', '', ''),
(12, 3, 0, 'English, New Zealand', '', 'pkg_en-NZ', 'package', '', 0, '5.0.3.2', '', 'https://update.joomla.org/language/details5/en-NZ_details.xml', '', '', ''),
(13, 3, 0, 'English, USA', '', 'pkg_en-US', 'package', '', 0, '5.0.3.1', '', 'https://update.joomla.org/language/details5/en-US_details.xml', '', '', ''),
(14, 3, 0, 'Estonian', '', 'pkg_et-EE', 'package', '', 0, '5.1.0.1', '', 'https://update.joomla.org/language/details5/et-EE_details.xml', '', '', ''),
(15, 3, 0, 'Finnish', '', 'pkg_fi-FI', 'package', '', 0, '5.1.0.1', '', 'https://update.joomla.org/language/details5/fi-FI_details.xml', '', '', ''),
(16, 3, 0, 'Flemish', '', 'pkg_nl-BE', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/nl-BE_details.xml', '', '', ''),
(17, 3, 0, 'French', '', 'pkg_fr-FR', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/fr-FR_details.xml', '', '', ''),
(18, 3, 0, 'French, Canada', '', 'pkg_fr-CA', 'package', '', 0, '5.1.1.1', '', 'https://update.joomla.org/language/details5/fr-CA_details.xml', '', '', ''),
(19, 3, 0, 'Georgian', '', 'pkg_ka-GE', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/ka-GE_details.xml', '', '', ''),
(20, 3, 0, 'German', '', 'pkg_de-DE', 'package', '', 0, '5.1.2.2', '', 'https://update.joomla.org/language/details5/de-DE_details.xml', '', '', ''),
(21, 3, 0, 'German, Austria', '', 'pkg_de-AT', 'package', '', 0, '5.1.2.2', '', 'https://update.joomla.org/language/details5/de-AT_details.xml', '', '', ''),
(22, 3, 0, 'German, Liechtenstein', '', 'pkg_de-LI', 'package', '', 0, '5.1.2.2', '', 'https://update.joomla.org/language/details5/de-LI_details.xml', '', '', ''),
(23, 3, 0, 'German, Luxembourg', '', 'pkg_de-LU', 'package', '', 0, '5.1.2.2', '', 'https://update.joomla.org/language/details5/de-LU_details.xml', '', '', ''),
(24, 3, 0, 'German, Switzerland', '', 'pkg_de-CH', 'package', '', 0, '5.1.2.2', '', 'https://update.joomla.org/language/details5/de-CH_details.xml', '', '', ''),
(25, 3, 0, 'Greek', '', 'pkg_el-GR', 'package', '', 0, '5.1.2.2', '', 'https://update.joomla.org/language/details5/el-GR_details.xml', '', '', ''),
(26, 3, 0, 'Hungarian', '', 'pkg_hu-HU', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/hu-HU_details.xml', '', '', ''),
(27, 3, 0, 'Italian', '', 'pkg_it-IT', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/it-IT_details.xml', '', '', ''),
(28, 3, 0, 'Japanese', '', 'pkg_ja-JP', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/ja-JP_details.xml', '', '', ''),
(29, 3, 0, 'Kazakh', '', 'pkg_kk-KZ', 'package', '', 0, '5.0.0.4', '', 'https://update.joomla.org/language/details5/kk-KZ_details.xml', '', '', ''),
(30, 3, 0, 'Korean', '', 'pkg_ko-KR', 'package', '', 0, '5.0.2.1', '', 'https://update.joomla.org/language/details5/ko-KR_details.xml', '', '', ''),
(31, 3, 0, 'Latvian', '', 'pkg_lv-LV', 'package', '', 0, '5.0.1.1', '', 'https://update.joomla.org/language/details5/lv-LV_details.xml', '', '', ''),
(32, 3, 0, 'Pashto Afghanistan', '', 'pkg_ps-AF', 'package', '', 0, '5.0.1.1', '', 'https://update.joomla.org/language/details5/ps-AF_details.xml', '', '', ''),
(33, 3, 0, 'Persian Farsi', '', 'pkg_fa-IR', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/fa-IR_details.xml', '', '', ''),
(34, 3, 0, 'Polish', '', 'pkg_pl-PL', 'package', '', 0, '5.1.1.1', '', 'https://update.joomla.org/language/details5/pl-PL_details.xml', '', '', ''),
(35, 3, 0, 'Portuguese, Brazil', '', 'pkg_pt-BR', 'package', '', 0, '5.1.2.3', '', 'https://update.joomla.org/language/details5/pt-BR_details.xml', '', '', ''),
(36, 3, 0, 'Romanian', '', 'pkg_ro-RO', 'package', '', 0, '5.1.1.1', '', 'https://update.joomla.org/language/details5/ro-RO_details.xml', '', '', ''),
(37, 3, 0, 'Russian', '', 'pkg_ru-RU', 'package', '', 0, '5.1.1.1', '', 'https://update.joomla.org/language/details5/ru-RU_details.xml', '', '', ''),
(38, 3, 0, 'Serbian, Cyrillic', '', 'pkg_sr-RS', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/sr-RS_details.xml', '', '', ''),
(39, 3, 0, 'Serbian, Latin', '', 'pkg_sr-YU', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/sr-YU_details.xml', '', '', ''),
(40, 3, 0, 'Slovak', '', 'pkg_sk-SK', 'package', '', 0, '5.1.3.1', '', 'https://update.joomla.org/language/details5/sk-SK_details.xml', '', '', ''),
(41, 3, 0, 'Slovenian', '', 'pkg_sl-SI', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/sl-SI_details.xml', '', '', ''),
(42, 3, 0, 'Spanish', '', 'pkg_es-ES', 'package', '', 0, '5.1.0.1', '', 'https://update.joomla.org/language/details5/es-ES_details.xml', '', '', ''),
(43, 3, 0, 'Swedish', '', 'pkg_sv-SE', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/sv-SE_details.xml', '', '', ''),
(44, 3, 0, 'Tamil, India', '', 'pkg_ta-IN', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/ta-IN_details.xml', '', '', ''),
(45, 3, 0, 'Thai', '', 'pkg_th-TH', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/th-TH_details.xml', '', '', ''),
(46, 3, 0, 'Turkish', '', 'pkg_tr-TR', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/tr-TR_details.xml', '', '', ''),
(47, 3, 0, 'Ukrainian', '', 'pkg_uk-UA', 'package', '', 0, '5.1.1.1', '', 'https://update.joomla.org/language/details5/uk-UA_details.xml', '', '', ''),
(48, 3, 0, 'Urdu, Pakistan', '', 'pkg_ur-PK', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/ur-PK_details.xml', '', '', ''),
(49, 3, 0, 'Welsh', '', 'pkg_cy-GB', 'package', '', 0, '5.1.2.1', '', 'https://update.joomla.org/language/details5/cy-GB_details.xml', '', '', ''),
(50, 232, 0, 'Regular Labs - Regular Labs Library', '', 'library', 'library', '', 0, '21.8.0', '', 'https://download.regularlabs.com/updates.xml?e=library&type=.xml', '', NULL, '');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_update_sites`
--

CREATE TABLE `lfuve_update_sites` (
  `update_site_id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `location` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` int DEFAULT '0',
  `last_check_timestamp` bigint DEFAULT '0',
  `extra_query` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `checked_out` int UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites';

--
-- Dumping data for table `lfuve_update_sites`
--

INSERT INTO `lfuve_update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`, `extra_query`, `checked_out`, `checked_out_time`) VALUES
(1, 'Joomla! Core', 'tuf', 'https://update.joomla.org/cms/', 1, 1723942870, '', NULL, NULL),
(3, 'Accredited Joomla! Translations', 'collection', 'https://update.joomla.org/language/translationlist_5.xml', 1, 1723942870, '', NULL, NULL),
(16, 'Joomla! Update Component', 'extension', 'https://update.joomla.org/core/extensions/com_joomlaupdate.xml', 1, 1723942892, '', NULL, NULL),
(165, '', 'extension', 'http://update.joomlart.com/service/tracking/j16/mod_ja_acm.xml', 1, 1723942871, '', NULL, NULL),
(166, 'JCE MediaBox Updates', 'extension', 'https://www.joomlacontenteditor.net/index.php?option=com_updates&view=update&format=xml&file=jcemediabox.xml', 0, 0, '', NULL, NULL),
(171, '', 'extension', 'http://update.joomlart.com/service/tracking/j16/plg_system_t3.xml', 1, 1723942871, '', NULL, NULL),
(177, 'WebInstaller Update Site', 'extension', 'https://appscdn.joomla.org/webapps/jedapps/webinstaller.xml', 1, 1723942871, '', NULL, NULL),
(178, '', 'extension', 'http://update.joomlart.com/service/tracking/j31/ja_healthcare.xml', 1, 1723942872, '', NULL, NULL),
(184, 'JA Extension Manager', 'extension', 'http://update.joomlart.com/service/tracking/j16/com_com_jaextmanager.xml', 1, 1723942872, '', NULL, NULL),
(187, 'Weblinks Update Site', 'extension', 'https://raw.githubusercontent.com/joomla-extensions/weblinks/master/manifest.xml', 1, 1723942872, '', NULL, NULL),
(200, 'JCE Editor Package', 'collection', 'https://cdn.joomlacontenteditor.net/updates/xml/pkg_jce.xml', 1, 1723942872, '', NULL, NULL),
(219, 'Simple Audio Player - Shortcode', 'extension', 'http://www.sudesign.fr?option=com_sudesign&task=update.extension&id=5&key=de2f2468ad932d40633c4d49d4fd071d', 1, 1723942873, '', NULL, NULL),
(227, 'JCE Editor Package', 'extension', 'https://cdn.joomlacontenteditor.net/updates/xml/editor/pkg_jce.xml', 1, 1723942873, '', NULL, NULL),
(228, 'JA Extension Manager', 'extension', 'http://update.joomlart.com/service/tracking/j16/com_jaextmanager.xml', 1, 1723942873, '', NULL, NULL),
(229, 'JCE MediaBox Updates', 'extension', 'https://cdn.joomlacontenteditor.net/updates/xml/mediabox/plg_system_jcemediabox.xml', 1, 1723942873, '', NULL, NULL),
(231, 'Search Update Site', 'extension', 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml', 1, 1723942873, '', NULL, NULL),
(232, 'Regular Labs Library', 'extension', 'https://download.regularlabs.com/updates.xml?e=library&type=.xml', 1, 1723942874, '', NULL, NULL),
(233, 'Regular Labs - Tabs & Accordions', 'extension', 'https://download.regularlabs.com/updates.xml?e=tabsaccordions&type=.xml', 1, 1723942874, '', NULL, NULL),
(234, 'Easy Joomla Backup Pro', 'extension', 'https://check.kubik-rubik.de/updates/pro/com_easyjoomlabackup_j4.xml', 1, 1723942874, 'proUpdateId=ZAuoowAEfC7ppr1bw0Jk%2Bcb%2Fq9kD7P4ZMBTppqXd3FU%3D', NULL, NULL),
(235, 'Easy Joomla Backup Pro', 'extension', 'https://check.kubik-rubik.de/updates/pro/com_easyjoomlabackup_j5.xml', 1, 1723942874, 'proUpdateId=ZAuoowAEfC7ppr1bw0Jk%2Bcb%2Fq9kD7P4ZMBTppqXd3FU%3D', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_update_sites_extensions`
--

CREATE TABLE `lfuve_update_sites_extensions` (
  `update_site_id` int NOT NULL DEFAULT '0',
  `extension_id` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites';

--
-- Dumping data for table `lfuve_update_sites_extensions`
--

INSERT INTO `lfuve_update_sites_extensions` (`update_site_id`, `extension_id`) VALUES
(1, 700),
(3, 802),
(16, 28),
(165, 10163),
(166, 10023),
(171, 10160),
(177, 10026),
(178, 10161),
(184, 10233),
(187, 801),
(200, 10212),
(219, 10260),
(227, 10277),
(228, 10233),
(229, 10023),
(231, 10333),
(232, 10356),
(233, 10359),
(234, 10360),
(235, 10377);

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_usergroups`
--

CREATE TABLE `lfuve_usergroups` (
  `id` int UNSIGNED NOT NULL COMMENT 'Primary Key',
  `parent_id` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
  `lft` int NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
  `rgt` int NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_usergroups`
--

INSERT INTO `lfuve_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES
(1, 0, 1, 18, 'Public'),
(2, 1, 8, 15, 'Registered'),
(3, 2, 9, 14, 'Author'),
(4, 3, 10, 13, 'Editor'),
(5, 4, 11, 12, 'Publisher'),
(6, 1, 4, 7, 'Manager'),
(7, 6, 5, 6, 'Administrator'),
(8, 1, 16, 17, 'Super Users'),
(9, 1, 2, 3, 'Guest');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_users`
--

CREATE TABLE `lfuve_users` (
  `id` int NOT NULL,
  `name` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `block` tinyint NOT NULL DEFAULT '0',
  `sendEmail` tinyint DEFAULT '0',
  `registerDate` datetime NOT NULL,
  `lastvisitDate` datetime DEFAULT NULL,
  `activation` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastResetTime` datetime DEFAULT NULL,
  `resetCount` int NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime',
  `otpKey` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
  `otep` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
  `requireReset` tinyint NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login',
  `authProvider` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Name of used authentication plugin'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_users`
--

INSERT INTO `lfuve_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`, `authProvider`) VALUES
(464, 'Super User', 'cjull', 'christianjull@gmail.com', 'd4e8e35d8c178246ea7a37de5cd78da0:NbTrmVJU7L33PJcq1bigAMAbIwuWPRvJ', 1, 1, '2013-08-15 08:56:29', '2013-08-15 09:43:24', '0', '', NULL, 0, '', '', 0, ''),
(465, 'Christian Jull', 'Christian', 'christian@jull.net', '$2y$10$sb.77iKwlzPVWEGTHa9cMOPs/Cbo2U81bosaxdzpIQm5PoqfEcEXK', 0, 0, '2013-08-15 22:09:57', '2024-08-18 00:59:23', '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\",\"tfa\":{\"activate\":\"1\",\"authentication\":{\"username\":\"Christian@www.jull.net\",\"secret\":\"BW3PIKBMIYTNYNMD\"},\"backup\":{\"code\":\"490296\",\"count\":\"0\"}}}', NULL, 0, '', '', 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_user_keys`
--

CREATE TABLE `lfuve_user_keys` (
  `id` int UNSIGNED NOT NULL,
  `user_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `time` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `uastring` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_user_mfa`
--

CREATE TABLE `lfuve_user_mfa` (
  `id` int NOT NULL,
  `user_id` int UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `method` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default` tinyint NOT NULL DEFAULT '0',
  `options` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_on` datetime NOT NULL,
  `last_used` datetime DEFAULT NULL,
  `tries` int NOT NULL DEFAULT '0',
  `last_try` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Multi-factor Authentication settings';

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_user_notes`
--

CREATE TABLE `lfuve_user_notes` (
  `id` int UNSIGNED NOT NULL,
  `user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `catid` int UNSIGNED NOT NULL DEFAULT '0',
  `subject` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` tinyint NOT NULL DEFAULT '0',
  `checked_out` int UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `created_user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `created_time` datetime NOT NULL,
  `modified_user_id` int UNSIGNED NOT NULL DEFAULT '0',
  `modified_time` datetime NOT NULL,
  `review_time` datetime DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_user_profiles`
--

CREATE TABLE `lfuve_user_profiles` (
  `user_id` int NOT NULL,
  `profile_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ordering` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_user_usergroup_map`
--

CREATE TABLE `lfuve_user_usergroup_map` (
  `user_id` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id',
  `group_id` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_user_usergroup_map`
--

INSERT INTO `lfuve_user_usergroup_map` (`user_id`, `group_id`) VALUES
(464, 8),
(465, 8);

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_viewlevels`
--

CREATE TABLE `lfuve_viewlevels` (
  `id` int UNSIGNED NOT NULL COMMENT 'Primary Key',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `ordering` int NOT NULL DEFAULT '0',
  `rules` varchar(5120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_viewlevels`
--

INSERT INTO `lfuve_viewlevels` (`id`, `title`, `ordering`, `rules`) VALUES
(1, 'Public', 0, '[1]'),
(2, 'Registered', 1, '[6,2,8]'),
(3, 'Special', 2, '[6,3,8]'),
(5, 'Guest', 0, '[9]');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_webauthn_credentials`
--

CREATE TABLE `lfuve_webauthn_credentials` (
  `id` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Credential ID',
  `user_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'User handle',
  `label` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Human readable label',
  `credential` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Credential source data, JSON format'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_weblinks`
--

CREATE TABLE `lfuve_weblinks` (
  `id` int UNSIGNED NOT NULL,
  `catid` int NOT NULL DEFAULT '0',
  `title` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `url` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hits` int NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `ordering` int NOT NULL DEFAULT '0',
  `access` int NOT NULL DEFAULT '1',
  `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `language` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `created_by` int UNSIGNED NOT NULL DEFAULT '0',
  `created_by_alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `modified` datetime NOT NULL,
  `modified_by` int UNSIGNED NOT NULL DEFAULT '0',
  `metakey` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadesc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured` tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.',
  `xreference` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `version` int UNSIGNED NOT NULL DEFAULT '1',
  `images` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_wf_profiles`
--

CREATE TABLE `lfuve_wf_profiles` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `users` text NOT NULL,
  `types` text NOT NULL,
  `components` text NOT NULL,
  `area` tinyint NOT NULL,
  `device` varchar(255) NOT NULL,
  `rows` text NOT NULL,
  `plugins` text NOT NULL,
  `published` tinyint NOT NULL,
  `ordering` int NOT NULL,
  `checked_out` int UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `params` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `lfuve_wf_profiles`
--

INSERT INTO `lfuve_wf_profiles` (`id`, `name`, `description`, `users`, `types`, `components`, `area`, `device`, `rows`, `plugins`, `published`, `ordering`, `checked_out`, `checked_out_time`, `params`) VALUES
(1, 'Default', 'Default Profile for all users', '', '6,7,3,4,5,8', '', 0, 'desktop,tablet,phone', 'help,newdocument,undo,redo,spacer,bold,italic,underline,strikethrough,justifyfull,justifycenter,justifyleft,justifyright,spacer,blockquote,formatselect,styleselect,removeformat,cleanup;fontselect,fontsizeselect,forecolor,backcolor,spacer,clipboard,indent,outdent,lists,sub,sup,textcase,charmap,hr;directionality,fullscreen,preview,source,print,searchreplace,spacer,table;visualaid,visualchars,visualblocks,nonbreaking,style,xhtmlxtras,anchor,unlink,link,imgmanager,spellchecker,article,caption,emotions,filemanager,mediamanager,templatemanager,imgmanager_ext', 'charmap,contextmenu,browser,inlinepopups,media,help,clipboard,searchreplace,directionality,fullscreen,preview,source,table,textcase,print,style,nonbreaking,visualchars,visualblocks,xhtmlxtras,imgmanager,anchor,link,spellchecker,article,lists,caption,emotions,filemanager,mediamanager,templatemanager,imgmanager_ext,formatselect,styleselect,fontselect,fontsizeselect,fontcolor,hr', 1, 1, NULL, NULL, '{\"editor\":{\"filesystem\":{\"joomla\":{\"allow_root\":\"1\"}},\"verify_html\":\"0\"},\"media\":{\"iframes\":\"1\"}}'),
(2, 'Front End', 'Sample Front-end Profile', '', '3,4,5', '', 1, 'desktop,tablet,phone', 'help,newdocument,undo,redo,spacer,bold,italic,underline,strikethrough,justifyfull,justifycenter,justifyleft,justifyright,spacer,formatselect,styleselect;clipboard,searchreplace,indent,outdent,lists,cleanup,charmap,removeformat,hr,sub,sup,textcase,nonbreaking,visualchars,visualblocks;fullscreen,preview,print,visualaid,style,xhtmlxtras,anchor,unlink,link,imgmanager,spellchecker,article', 'charmap,contextmenu,inlinepopups,help,clipboard,searchreplace,fullscreen,preview,print,style,textcase,nonbreaking,visualchars,visualblocks,xhtmlxtras,imgmanager,anchor,link,spellchecker,article,lists,formatselect,styleselect,hr', 0, 2, NULL, NULL, ''),
(3, 'Blogger', 'Simple Blogging Profile', '', '3,4,5,6,8,7', '', 0, 'desktop,tablet,phone', 'bold,italic,strikethrough,lists,blockquote,spacer,justifyleft,justifycenter,justifyright,spacer,link,unlink,imgmanager,article,spellchecker,fullscreen,kitchensink;formatselect,underline,justifyfull,forecolor,clipboard,removeformat,charmap,indent,outdent,undo,redo,help', 'link,imgmanager,article,spellchecker,fullscreen,kitchensink,clipboard,contextmenu,inlinepopups,lists,formatselect,fontcolor,hr', 0, 3, NULL, NULL, '{\"editor\":{\"toggle\":\"0\"}}'),
(4, 'Mobile', 'Sample Mobile Profile', '', '3,4,5,6,8,7', '', 0, 'tablet,phone', 'undo,redo,spacer,bold,italic,underline,formatselect,spacer,justifyleft,justifycenter,justifyfull,justifyright,spacer,fullscreen,kitchensink;styleselect,lists,spellchecker,article,link,unlink', 'fullscreen,kitchensink,spellchecker,article,link,inlinepopups,lists,formatselect,styleselect', 0, 4, NULL, NULL, '{\"editor\":{\"toolbar_theme\":\"mobile\",\"resizing\":\"0\",\"resize_horizontal\":\"0\",\"resizing_use_cookie\":\"0\",\"toggle\":\"0\",\"links\":{\"popups\":{\"default\":\"\",\"jcemediabox\":{\"enable\":\"0\"},\"window\":{\"enable\":\"0\"}}}}}');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_workflows`
--

CREATE TABLE `lfuve_workflows` (
  `id` int NOT NULL,
  `asset_id` int DEFAULT '0',
  `published` tinyint NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `default` tinyint NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_workflows`
--

INSERT INTO `lfuve_workflows` (`id`, `asset_id`, `published`, `title`, `description`, `extension`, `default`, `ordering`, `created`, `created_by`, `modified`, `modified_by`, `checked_out_time`, `checked_out`) VALUES
(1, 0, 1, 'COM_WORKFLOW_BASIC_WORKFLOW', '', 'com_content.article', 1, 1, '2024-01-15 05:38:39', 0, '2024-01-15 05:38:39', 0, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_workflow_associations`
--

CREATE TABLE `lfuve_workflow_associations` (
  `item_id` int NOT NULL DEFAULT '0' COMMENT 'Extension table id value',
  `stage_id` int NOT NULL COMMENT 'Foreign Key to #__workflow_stages.id',
  `extension` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_workflow_associations`
--

INSERT INTO `lfuve_workflow_associations` (`item_id`, `stage_id`, `extension`) VALUES
(88, 1, 'com_content.article'),
(89, 1, 'com_content.article'),
(90, 1, 'com_content.article'),
(91, 1, 'com_content.article'),
(92, 1, 'com_content.article'),
(93, 1, 'com_content.article'),
(94, 1, 'com_content.article'),
(95, 1, 'com_content.article'),
(96, 1, 'com_content.article'),
(97, 1, 'com_content.article'),
(98, 1, 'com_content.article'),
(99, 1, 'com_content.article'),
(100, 1, 'com_content.article'),
(101, 1, 'com_content.article'),
(102, 1, 'com_content.article'),
(103, 1, 'com_content.article'),
(104, 1, 'com_content.article'),
(105, 1, 'com_content.article'),
(106, 1, 'com_content.article'),
(107, 1, 'com_content.article'),
(108, 1, 'com_content.article'),
(109, 1, 'com_content.article'),
(110, 1, 'com_content.article'),
(111, 1, 'com_content.article'),
(112, 1, 'com_content.article'),
(113, 1, 'com_content.article'),
(114, 1, 'com_content.article'),
(115, 1, 'com_content.article'),
(116, 1, 'com_content.article'),
(117, 1, 'com_content.article'),
(118, 1, 'com_content.article'),
(119, 1, 'com_content.article'),
(120, 1, 'com_content.article'),
(121, 1, 'com_content.article'),
(122, 1, 'com_content.article');

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_workflow_stages`
--

CREATE TABLE `lfuve_workflow_stages` (
  `id` int NOT NULL,
  `asset_id` int DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  `workflow_id` int NOT NULL,
  `published` tinyint NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `default` tinyint NOT NULL DEFAULT '0',
  `checked_out_time` datetime DEFAULT NULL,
  `checked_out` int UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_workflow_stages`
--

INSERT INTO `lfuve_workflow_stages` (`id`, `asset_id`, `ordering`, `workflow_id`, `published`, `title`, `description`, `default`, `checked_out_time`, `checked_out`) VALUES
(1, 0, 1, 1, 1, 'COM_WORKFLOW_BASIC_STAGE', '', 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `lfuve_workflow_transitions`
--

CREATE TABLE `lfuve_workflow_transitions` (
  `id` int NOT NULL,
  `asset_id` int DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0',
  `workflow_id` int NOT NULL,
  `published` tinyint NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_stage_id` int NOT NULL,
  `to_stage_id` int NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `checked_out` int UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_workflow_transitions`
--

INSERT INTO `lfuve_workflow_transitions` (`id`, `asset_id`, `ordering`, `workflow_id`, `published`, `title`, `description`, `from_stage_id`, `to_stage_id`, `options`, `checked_out_time`, `checked_out`) VALUES
(1, 0, 1, 1, 1, 'UNPUBLISH', '', -1, 1, '{\"publishing\":\"0\"}', NULL, NULL),
(2, 0, 2, 1, 1, 'PUBLISH', '', -1, 1, '{\"publishing\":\"1\"}', NULL, NULL),
(3, 0, 3, 1, 1, 'TRASH', '', -1, 1, '{\"publishing\":\"-2\"}', NULL, NULL),
(4, 0, 4, 1, 1, 'ARCHIVE', '', -1, 1, '{\"publishing\":\"2\"}', NULL, NULL),
(5, 0, 5, 1, 1, 'FEATURE', '', -1, 1, '{\"featuring\":\"1\"}', NULL, NULL),
(6, 0, 6, 1, 1, 'UNFEATURE', '', -1, 1, '{\"featuring\":\"0\"}', NULL, NULL),
(7, 0, 7, 1, 1, 'PUBLISH_AND_FEATURE', '', -1, 1, '{\"publishing\":\"1\",\"featuring\":\"1\"}', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `lfuve_action_logs`
--
ALTER TABLE `lfuve_action_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_user_id_logdate` (`user_id`,`log_date`),
  ADD KEY `idx_user_id_extension` (`user_id`,`extension`),
  ADD KEY `idx_extension_item_id` (`extension`,`item_id`);

--
-- Indexes for table `lfuve_action_logs_extensions`
--
ALTER TABLE `lfuve_action_logs_extensions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_action_logs_users`
--
ALTER TABLE `lfuve_action_logs_users`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `idx_notify` (`notify`);

--
-- Indexes for table `lfuve_action_log_config`
--
ALTER TABLE `lfuve_action_log_config`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_akeeba_common`
--
ALTER TABLE `lfuve_akeeba_common`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `lfuve_assets`
--
ALTER TABLE `lfuve_assets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_asset_name` (`name`),
  ADD KEY `idx_lft_rgt` (`lft`,`rgt`),
  ADD KEY `idx_parent_id` (`parent_id`);

--
-- Indexes for table `lfuve_associations`
--
ALTER TABLE `lfuve_associations`
  ADD PRIMARY KEY (`context`,`id`),
  ADD KEY `idx_key` (`key`);

--
-- Indexes for table `lfuve_banners`
--
ALTER TABLE `lfuve_banners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_state` (`state`),
  ADD KEY `idx_own_prefix` (`own_prefix`),
  ADD KEY `idx_banner_catid` (`catid`),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_metakey_prefix` (`metakey_prefix`(100));

--
-- Indexes for table `lfuve_banner_clients`
--
ALTER TABLE `lfuve_banner_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_own_prefix` (`own_prefix`),
  ADD KEY `idx_metakey_prefix` (`metakey_prefix`(100));

--
-- Indexes for table `lfuve_banner_tracks`
--
ALTER TABLE `lfuve_banner_tracks`
  ADD PRIMARY KEY (`track_date`,`track_type`,`banner_id`),
  ADD KEY `idx_track_date` (`track_date`),
  ADD KEY `idx_track_type` (`track_type`),
  ADD KEY `idx_banner_id` (`banner_id`);

--
-- Indexes for table `lfuve_categories`
--
ALTER TABLE `lfuve_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cat_idx` (`extension`,`published`,`access`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_left_right` (`lft`,`rgt`),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_path` (`path`(100)),
  ADD KEY `idx_alias` (`alias`(100));

--
-- Indexes for table `lfuve_contact_details`
--
ALTER TABLE `lfuve_contact_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_state` (`published`),
  ADD KEY `idx_catid` (`catid`),
  ADD KEY `idx_createdby` (`created_by`),
  ADD KEY `idx_featured_catid` (`featured`,`catid`),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_content`
--
ALTER TABLE `lfuve_content`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_state` (`state`),
  ADD KEY `idx_catid` (`catid`(191)),
  ADD KEY `idx_createdby` (`created_by`),
  ADD KEY `idx_featured_catid` (`featured`,`catid`(191)),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_alias` (`alias`(191));

--
-- Indexes for table `lfuve_contentitem_tag_map`
--
ALTER TABLE `lfuve_contentitem_tag_map`
  ADD UNIQUE KEY `uc_ItemnameTagid` (`type_id`,`content_item_id`,`tag_id`),
  ADD KEY `idx_tag_type` (`tag_id`,`type_id`),
  ADD KEY `idx_date_id` (`tag_date`,`tag_id`),
  ADD KEY `idx_core_content_id` (`core_content_id`);

--
-- Indexes for table `lfuve_content_frontpage`
--
ALTER TABLE `lfuve_content_frontpage`
  ADD PRIMARY KEY (`content_id`);

--
-- Indexes for table `lfuve_content_rating`
--
ALTER TABLE `lfuve_content_rating`
  ADD PRIMARY KEY (`content_id`);

--
-- Indexes for table `lfuve_content_types`
--
ALTER TABLE `lfuve_content_types`
  ADD PRIMARY KEY (`type_id`),
  ADD KEY `idx_alias` (`type_alias`(100));

--
-- Indexes for table `lfuve_easyjoomlabackup`
--
ALTER TABLE `lfuve_easyjoomlabackup`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `lfuve_extensions`
--
ALTER TABLE `lfuve_extensions`
  ADD PRIMARY KEY (`extension_id`),
  ADD KEY `element_clientid` (`element`,`client_id`),
  ADD KEY `element_folder_clientid` (`element`,`folder`,`client_id`),
  ADD KEY `extension` (`type`,`element`,`folder`,`client_id`);

--
-- Indexes for table `lfuve_fields`
--
ALTER TABLE `lfuve_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_state` (`state`),
  ADD KEY `idx_created_user_id` (`created_user_id`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_context` (`context`(191)),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_fields_categories`
--
ALTER TABLE `lfuve_fields_categories`
  ADD PRIMARY KEY (`field_id`,`category_id`);

--
-- Indexes for table `lfuve_fields_groups`
--
ALTER TABLE `lfuve_fields_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_state` (`state`),
  ADD KEY `idx_created_by` (`created_by`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_context` (`context`(191)),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_fields_values`
--
ALTER TABLE `lfuve_fields_values`
  ADD KEY `idx_field_id` (`field_id`),
  ADD KEY `idx_item_id` (`item_id`(191));

--
-- Indexes for table `lfuve_finder_filters`
--
ALTER TABLE `lfuve_finder_filters`
  ADD PRIMARY KEY (`filter_id`);

--
-- Indexes for table `lfuve_finder_links`
--
ALTER TABLE `lfuve_finder_links`
  ADD PRIMARY KEY (`link_id`),
  ADD KEY `idx_type` (`type_id`),
  ADD KEY `idx_md5` (`md5sum`),
  ADD KEY `idx_url` (`url`(75)),
  ADD KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
  ADD KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`),
  ADD KEY `idx_title` (`title`(100)),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_finder_links_terms`
--
ALTER TABLE `lfuve_finder_links_terms`
  ADD PRIMARY KEY (`link_id`,`term_id`),
  ADD KEY `idx_term_weight` (`term_id`,`weight`),
  ADD KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`);

--
-- Indexes for table `lfuve_finder_logging`
--
ALTER TABLE `lfuve_finder_logging`
  ADD PRIMARY KEY (`md5sum`),
  ADD KEY `searchterm` (`searchterm`(191));

--
-- Indexes for table `lfuve_finder_taxonomy`
--
ALTER TABLE `lfuve_finder_taxonomy`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_state` (`state`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_path` (`path`(100)),
  ADD KEY `idx_left_right` (`lft`,`rgt`),
  ADD KEY `idx_alias` (`alias`(100)),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_parent_published` (`parent_id`,`state`,`access`),
  ADD KEY `idx_level` (`level`);

--
-- Indexes for table `lfuve_finder_taxonomy_map`
--
ALTER TABLE `lfuve_finder_taxonomy_map`
  ADD PRIMARY KEY (`link_id`,`node_id`),
  ADD KEY `link_id` (`link_id`),
  ADD KEY `node_id` (`node_id`);

--
-- Indexes for table `lfuve_finder_terms`
--
ALTER TABLE `lfuve_finder_terms`
  ADD PRIMARY KEY (`term_id`),
  ADD UNIQUE KEY `idx_term_language` (`term`,`language`),
  ADD KEY `idx_term_phrase` (`term`,`phrase`),
  ADD KEY `idx_stem_phrase` (`stem`,`phrase`),
  ADD KEY `idx_soundex_phrase` (`soundex`,`phrase`),
  ADD KEY `idx_stem` (`stem`),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_finder_terms_common`
--
ALTER TABLE `lfuve_finder_terms_common`
  ADD UNIQUE KEY `idx_term_language` (`term`,`language`),
  ADD KEY `idx_lang` (`language`);

--
-- Indexes for table `lfuve_finder_tokens`
--
ALTER TABLE `lfuve_finder_tokens`
  ADD KEY `idx_word` (`term`),
  ADD KEY `idx_context` (`context`),
  ADD KEY `idx_stem` (`stem`),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_finder_tokens_aggregate`
--
ALTER TABLE `lfuve_finder_tokens_aggregate`
  ADD KEY `token` (`term`),
  ADD KEY `keyword_id` (`term_id`);

--
-- Indexes for table `lfuve_finder_types`
--
ALTER TABLE `lfuve_finder_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `title` (`title`);

--
-- Indexes for table `lfuve_guidedtours`
--
ALTER TABLE `lfuve_guidedtours`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_state` (`published`),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_uid` (`uid`(191));

--
-- Indexes for table `lfuve_guidedtour_steps`
--
ALTER TABLE `lfuve_guidedtour_steps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tour` (`tour_id`),
  ADD KEY `idx_state` (`published`),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_history`
--
ALTER TABLE `lfuve_history`
  ADD PRIMARY KEY (`version_id`),
  ADD KEY `idx_ucm_item_id` (`item_id`),
  ADD KEY `idx_save_date` (`save_date`);

--
-- Indexes for table `lfuve_jaem_log`
--
ALTER TABLE `lfuve_jaem_log`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ext_id` (`ext_id`);

--
-- Indexes for table `lfuve_jaem_services`
--
ALTER TABLE `lfuve_jaem_services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_jsecurelog`
--
ALTER TABLE `lfuve_jsecurelog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_jsecurepassword`
--
ALTER TABLE `lfuve_jsecurepassword`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_jsecure_hits`
--
ALTER TABLE `lfuve_jsecure_hits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_languages`
--
ALTER TABLE `lfuve_languages`
  ADD PRIMARY KEY (`lang_id`),
  ADD UNIQUE KEY `idx_sef` (`sef`),
  ADD UNIQUE KEY `idx_langcode` (`lang_code`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_ordering` (`ordering`);

--
-- Indexes for table `lfuve_mail_templates`
--
ALTER TABLE `lfuve_mail_templates`
  ADD PRIMARY KEY (`template_id`,`language`);

--
-- Indexes for table `lfuve_menu`
--
ALTER TABLE `lfuve_menu`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`(100),`language`),
  ADD KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`),
  ADD KEY `idx_menutype` (`menutype`),
  ADD KEY `idx_left_right` (`lft`,`rgt`),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_alias` (`alias`(100)),
  ADD KEY `idx_path` (`path`(100));

--
-- Indexes for table `lfuve_menu_types`
--
ALTER TABLE `lfuve_menu_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_menutype` (`menutype`);

--
-- Indexes for table `lfuve_messages`
--
ALTER TABLE `lfuve_messages`
  ADD PRIMARY KEY (`message_id`),
  ADD KEY `useridto_state` (`user_id_to`,`state`);

--
-- Indexes for table `lfuve_messages_cfg`
--
ALTER TABLE `lfuve_messages_cfg`
  ADD UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`);

--
-- Indexes for table `lfuve_modules`
--
ALTER TABLE `lfuve_modules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `published` (`published`,`access`),
  ADD KEY `newsfeeds` (`module`,`published`),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_modules_menu`
--
ALTER TABLE `lfuve_modules_menu`
  ADD PRIMARY KEY (`moduleid`,`menuid`);

--
-- Indexes for table `lfuve_newsfeeds`
--
ALTER TABLE `lfuve_newsfeeds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_state` (`published`),
  ADD KEY `idx_catid` (`catid`),
  ADD KEY `idx_createdby` (`created_by`),
  ADD KEY `idx_language` (`language`);

--
-- Indexes for table `lfuve_oseav_actionlogs`
--
ALTER TABLE `lfuve_oseav_actionlogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_oseav_detected`
--
ALTER TABLE `lfuve_oseav_detected`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_oseav_quarantined`
--
ALTER TABLE `lfuve_oseav_quarantined`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_oseav_scanitems`
--
ALTER TABLE `lfuve_oseav_scanitems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Filepath` (`filepath`);

--
-- Indexes for table `lfuve_oseav_scanlogs`
--
ALTER TABLE `lfuve_oseav_scanlogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_oseav_whitelisted`
--
ALTER TABLE `lfuve_oseav_whitelisted`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_ose_activation`
--
ALTER TABLE `lfuve_ose_activation`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_ose_secConfig`
--
ALTER TABLE `lfuve_ose_secConfig`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_osmap_itemscache`
--
ALTER TABLE `lfuve_osmap_itemscache`
  ADD PRIMARY KEY (`sitemap_id`,`ordering`),
  ADD KEY `sitemap_id_2` (`sitemap_id`,`duplicate`,`news_item`,`has_images`);

--
-- Indexes for table `lfuve_osmap_itemscacheimg`
--
ALTER TABLE `lfuve_osmap_itemscacheimg`
  ADD PRIMARY KEY (`sitemap_id`,`ordering`,`index`);

--
-- Indexes for table `lfuve_osmap_itemscacheimg_tmp`
--
ALTER TABLE `lfuve_osmap_itemscacheimg_tmp`
  ADD PRIMARY KEY (`sitemap_id`,`ordering`,`index`);

--
-- Indexes for table `lfuve_osmap_itemscache_tmp`
--
ALTER TABLE `lfuve_osmap_itemscache_tmp`
  ADD PRIMARY KEY (`sitemap_id`,`ordering`),
  ADD KEY `sitemap_id_2` (`sitemap_id`,`duplicate`,`news_item`,`has_images`);

--
-- Indexes for table `lfuve_overrider`
--
ALTER TABLE `lfuve_overrider`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_plg_easyfrontendseo`
--
ALTER TABLE `lfuve_plg_easyfrontendseo`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `lfuve_postinstall_messages`
--
ALTER TABLE `lfuve_postinstall_messages`
  ADD PRIMARY KEY (`postinstall_message_id`);

--
-- Indexes for table `lfuve_privacy_consents`
--
ALTER TABLE `lfuve_privacy_consents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- Indexes for table `lfuve_privacy_requests`
--
ALTER TABLE `lfuve_privacy_requests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_redirect_links`
--
ALTER TABLE `lfuve_redirect_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_old_url` (`old_url`(100)),
  ADD KEY `idx_link_modified` (`modified_date`);

--
-- Indexes for table `lfuve_scheduler_tasks`
--
ALTER TABLE `lfuve_scheduler_tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_type` (`type`),
  ADD KEY `idx_state` (`state`),
  ADD KEY `idx_last_exit` (`last_exit_code`),
  ADD KEY `idx_next_exec` (`next_execution`),
  ADD KEY `idx_locked` (`locked`),
  ADD KEY `idx_priority` (`priority`),
  ADD KEY `idx_cli_exclusive` (`cli_exclusive`),
  ADD KEY `idx_checked_out` (`checked_out`);

--
-- Indexes for table `lfuve_schemaorg`
--
ALTER TABLE `lfuve_schemaorg`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_schemas`
--
ALTER TABLE `lfuve_schemas`
  ADD PRIMARY KEY (`extension_id`,`version_id`);

--
-- Indexes for table `lfuve_securitycheckpro_online_checks`
--
ALTER TABLE `lfuve_securitycheckpro_online_checks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_session`
--
ALTER TABLE `lfuve_session`
  ADD PRIMARY KEY (`session_id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `time` (`time`),
  ADD KEY `client_id_guest` (`client_id`,`guest`);

--
-- Indexes for table `lfuve_tags`
--
ALTER TABLE `lfuve_tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tag_idx` (`published`,`access`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_left_right` (`lft`,`rgt`),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_path` (`path`(100)),
  ADD KEY `idx_alias` (`alias`(100));

--
-- Indexes for table `lfuve_template_overrides`
--
ALTER TABLE `lfuve_template_overrides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_template` (`template`),
  ADD KEY `idx_extension_id` (`extension_id`);

--
-- Indexes for table `lfuve_template_styles`
--
ALTER TABLE `lfuve_template_styles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_template` (`template`),
  ADD KEY `idx_client_id` (`client_id`),
  ADD KEY `idx_client_id_home` (`client_id`,`home`);

--
-- Indexes for table `lfuve_tuf_metadata`
--
ALTER TABLE `lfuve_tuf_metadata`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_ucm_base`
--
ALTER TABLE `lfuve_ucm_base`
  ADD PRIMARY KEY (`ucm_id`),
  ADD KEY `idx_ucm_item_id` (`ucm_item_id`),
  ADD KEY `idx_ucm_type_id` (`ucm_type_id`),
  ADD KEY `idx_ucm_language_id` (`ucm_language_id`);

--
-- Indexes for table `lfuve_ucm_content`
--
ALTER TABLE `lfuve_ucm_content`
  ADD PRIMARY KEY (`core_content_id`),
  ADD KEY `tag_idx` (`core_state`,`core_access`),
  ADD KEY `idx_access` (`core_access`),
  ADD KEY `idx_language` (`core_language`),
  ADD KEY `idx_modified_time` (`core_modified_time`),
  ADD KEY `idx_created_time` (`core_created_time`),
  ADD KEY `idx_core_modified_user_id` (`core_modified_user_id`),
  ADD KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`),
  ADD KEY `idx_core_created_user_id` (`core_created_user_id`),
  ADD KEY `idx_core_type_id` (`core_type_id`),
  ADD KEY `idx_alias` (`core_alias`(100)),
  ADD KEY `idx_title` (`core_title`(100)),
  ADD KEY `idx_content_type` (`core_type_alias`(100));

--
-- Indexes for table `lfuve_updates`
--
ALTER TABLE `lfuve_updates`
  ADD PRIMARY KEY (`update_id`);

--
-- Indexes for table `lfuve_update_sites`
--
ALTER TABLE `lfuve_update_sites`
  ADD PRIMARY KEY (`update_site_id`);

--
-- Indexes for table `lfuve_update_sites_extensions`
--
ALTER TABLE `lfuve_update_sites_extensions`
  ADD PRIMARY KEY (`update_site_id`,`extension_id`);

--
-- Indexes for table `lfuve_usergroups`
--
ALTER TABLE `lfuve_usergroups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
  ADD KEY `idx_usergroup_title_lookup` (`title`),
  ADD KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
  ADD KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE;

--
-- Indexes for table `lfuve_users`
--
ALTER TABLE `lfuve_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_username` (`username`),
  ADD KEY `idx_block` (`block`),
  ADD KEY `email` (`email`),
  ADD KEY `idx_name` (`name`(100));

--
-- Indexes for table `lfuve_user_keys`
--
ALTER TABLE `lfuve_user_keys`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `series` (`series`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `lfuve_user_mfa`
--
ALTER TABLE `lfuve_user_mfa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- Indexes for table `lfuve_user_notes`
--
ALTER TABLE `lfuve_user_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_category_id` (`catid`);

--
-- Indexes for table `lfuve_user_profiles`
--
ALTER TABLE `lfuve_user_profiles`
  ADD UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`);

--
-- Indexes for table `lfuve_user_usergroup_map`
--
ALTER TABLE `lfuve_user_usergroup_map`
  ADD PRIMARY KEY (`user_id`,`group_id`);

--
-- Indexes for table `lfuve_viewlevels`
--
ALTER TABLE `lfuve_viewlevels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_assetgroup_title_lookup` (`title`);

--
-- Indexes for table `lfuve_webauthn_credentials`
--
ALTER TABLE `lfuve_webauthn_credentials`
  ADD PRIMARY KEY (`id`(100)),
  ADD KEY `user_id` (`user_id`(60));

--
-- Indexes for table `lfuve_weblinks`
--
ALTER TABLE `lfuve_weblinks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_checkout` (`checked_out`),
  ADD KEY `idx_state` (`state`),
  ADD KEY `idx_catid` (`catid`),
  ADD KEY `idx_createdby` (`created_by`),
  ADD KEY `idx_featured_catid` (`featured`,`catid`),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_xreference` (`xreference`);

--
-- Indexes for table `lfuve_wf_profiles`
--
ALTER TABLE `lfuve_wf_profiles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lfuve_workflows`
--
ALTER TABLE `lfuve_workflows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_asset_id` (`asset_id`),
  ADD KEY `idx_title` (`title`(191)),
  ADD KEY `idx_extension` (`extension`),
  ADD KEY `idx_default` (`default`),
  ADD KEY `idx_created` (`created`),
  ADD KEY `idx_created_by` (`created_by`),
  ADD KEY `idx_modified` (`modified`),
  ADD KEY `idx_modified_by` (`modified_by`),
  ADD KEY `idx_checked_out` (`checked_out`);

--
-- Indexes for table `lfuve_workflow_associations`
--
ALTER TABLE `lfuve_workflow_associations`
  ADD PRIMARY KEY (`item_id`,`extension`),
  ADD KEY `idx_item_stage_extension` (`item_id`,`stage_id`,`extension`),
  ADD KEY `idx_item_id` (`item_id`),
  ADD KEY `idx_stage_id` (`stage_id`),
  ADD KEY `idx_extension` (`extension`);

--
-- Indexes for table `lfuve_workflow_stages`
--
ALTER TABLE `lfuve_workflow_stages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_workflow_id` (`workflow_id`),
  ADD KEY `idx_checked_out` (`checked_out`),
  ADD KEY `idx_title` (`title`(191)),
  ADD KEY `idx_asset_id` (`asset_id`),
  ADD KEY `idx_default` (`default`);

--
-- Indexes for table `lfuve_workflow_transitions`
--
ALTER TABLE `lfuve_workflow_transitions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_title` (`title`(191)),
  ADD KEY `idx_asset_id` (`asset_id`),
  ADD KEY `idx_checked_out` (`checked_out`),
  ADD KEY `idx_from_stage_id` (`from_stage_id`),
  ADD KEY `idx_to_stage_id` (`to_stage_id`),
  ADD KEY `idx_workflow_id` (`workflow_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `lfuve_action_logs`
--
ALTER TABLE `lfuve_action_logs`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_action_logs_extensions`
--
ALTER TABLE `lfuve_action_logs_extensions`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `lfuve_action_log_config`
--
ALTER TABLE `lfuve_action_log_config`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `lfuve_assets`
--
ALTER TABLE `lfuve_assets`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', AUTO_INCREMENT=220;

--
-- AUTO_INCREMENT for table `lfuve_banners`
--
ALTER TABLE `lfuve_banners`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_banner_clients`
--
ALTER TABLE `lfuve_banner_clients`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_categories`
--
ALTER TABLE `lfuve_categories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `lfuve_contact_details`
--
ALTER TABLE `lfuve_contact_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_content`
--
ALTER TABLE `lfuve_content`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;

--
-- AUTO_INCREMENT for table `lfuve_content_types`
--
ALTER TABLE `lfuve_content_types`
  MODIFY `type_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `lfuve_easyjoomlabackup`
--
ALTER TABLE `lfuve_easyjoomlabackup`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `lfuve_extensions`
--
ALTER TABLE `lfuve_extensions`
  MODIFY `extension_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10384;

--
-- AUTO_INCREMENT for table `lfuve_fields`
--
ALTER TABLE `lfuve_fields`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_fields_groups`
--
ALTER TABLE `lfuve_fields_groups`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_finder_filters`
--
ALTER TABLE `lfuve_finder_filters`
  MODIFY `filter_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_finder_links`
--
ALTER TABLE `lfuve_finder_links`
  MODIFY `link_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_finder_taxonomy`
--
ALTER TABLE `lfuve_finder_taxonomy`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_finder_terms`
--
ALTER TABLE `lfuve_finder_terms`
  MODIFY `term_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_finder_types`
--
ALTER TABLE `lfuve_finder_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `lfuve_guidedtours`
--
ALTER TABLE `lfuve_guidedtours`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `lfuve_guidedtour_steps`
--
ALTER TABLE `lfuve_guidedtour_steps`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;

--
-- AUTO_INCREMENT for table `lfuve_history`
--
ALTER TABLE `lfuve_history`
  MODIFY `version_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_jaem_log`
--
ALTER TABLE `lfuve_jaem_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `lfuve_jaem_services`
--
ALTER TABLE `lfuve_jaem_services`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `lfuve_jsecurelog`
--
ALTER TABLE `lfuve_jsecurelog`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `lfuve_jsecurepassword`
--
ALTER TABLE `lfuve_jsecurepassword`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_jsecure_hits`
--
ALTER TABLE `lfuve_jsecure_hits`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `lfuve_languages`
--
ALTER TABLE `lfuve_languages`
  MODIFY `lang_id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_menu`
--
ALTER TABLE `lfuve_menu`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=849;

--
-- AUTO_INCREMENT for table `lfuve_menu_types`
--
ALTER TABLE `lfuve_menu_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `lfuve_messages`
--
ALTER TABLE `lfuve_messages`
  MODIFY `message_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_modules`
--
ALTER TABLE `lfuve_modules`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=139;

--
-- AUTO_INCREMENT for table `lfuve_newsfeeds`
--
ALTER TABLE `lfuve_newsfeeds`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_oseav_actionlogs`
--
ALTER TABLE `lfuve_oseav_actionlogs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_oseav_detected`
--
ALTER TABLE `lfuve_oseav_detected`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_oseav_quarantined`
--
ALTER TABLE `lfuve_oseav_quarantined`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `lfuve_oseav_scanitems`
--
ALTER TABLE `lfuve_oseav_scanitems`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13088;

--
-- AUTO_INCREMENT for table `lfuve_oseav_scanlogs`
--
ALTER TABLE `lfuve_oseav_scanlogs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `lfuve_oseav_whitelisted`
--
ALTER TABLE `lfuve_oseav_whitelisted`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `lfuve_ose_activation`
--
ALTER TABLE `lfuve_ose_activation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_ose_secConfig`
--
ALTER TABLE `lfuve_ose_secConfig`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `lfuve_overrider`
--
ALTER TABLE `lfuve_overrider`
  MODIFY `id` int NOT NULL AUTO_INCREMENT COMMENT 'Primary Key';

--
-- AUTO_INCREMENT for table `lfuve_plg_easyfrontendseo`
--
ALTER TABLE `lfuve_plg_easyfrontendseo`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_postinstall_messages`
--
ALTER TABLE `lfuve_postinstall_messages`
  MODIFY `postinstall_message_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `lfuve_privacy_consents`
--
ALTER TABLE `lfuve_privacy_consents`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_privacy_requests`
--
ALTER TABLE `lfuve_privacy_requests`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_redirect_links`
--
ALTER TABLE `lfuve_redirect_links`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12337;

--
-- AUTO_INCREMENT for table `lfuve_scheduler_tasks`
--
ALTER TABLE `lfuve_scheduler_tasks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `lfuve_schemaorg`
--
ALTER TABLE `lfuve_schemaorg`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_securitycheckpro_online_checks`
--
ALTER TABLE `lfuve_securitycheckpro_online_checks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `lfuve_tags`
--
ALTER TABLE `lfuve_tags`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_template_overrides`
--
ALTER TABLE `lfuve_template_overrides`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `lfuve_template_styles`
--
ALTER TABLE `lfuve_template_styles`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `lfuve_tuf_metadata`
--
ALTER TABLE `lfuve_tuf_metadata`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_ucm_content`
--
ALTER TABLE `lfuve_ucm_content`
  MODIFY `core_content_id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_updates`
--
ALTER TABLE `lfuve_updates`
  MODIFY `update_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `lfuve_update_sites`
--
ALTER TABLE `lfuve_update_sites`
  MODIFY `update_site_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=236;

--
-- AUTO_INCREMENT for table `lfuve_usergroups`
--
ALTER TABLE `lfuve_usergroups`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `lfuve_users`
--
ALTER TABLE `lfuve_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=466;

--
-- AUTO_INCREMENT for table `lfuve_user_keys`
--
ALTER TABLE `lfuve_user_keys`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_user_mfa`
--
ALTER TABLE `lfuve_user_mfa`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_user_notes`
--
ALTER TABLE `lfuve_user_notes`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_viewlevels`
--
ALTER TABLE `lfuve_viewlevels`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `lfuve_weblinks`
--
ALTER TABLE `lfuve_weblinks`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lfuve_wf_profiles`
--
ALTER TABLE `lfuve_wf_profiles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `lfuve_workflows`
--
ALTER TABLE `lfuve_workflows`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_workflow_stages`
--
ALTER TABLE `lfuve_workflow_stages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lfuve_workflow_transitions`
--
ALTER TABLE `lfuve_workflow_transitions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

