INSERT INTO `jgkzw_sppagebuilder` (`id`, `asset_id`, `title`, `text`, `content`, `extension`, `extension_view`, `view_id`, `active`, `published`, `catid`, `access`, `ordering`, `created_on`, `created_by`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `attribs`, `og_title`, `og_image`, `og_description`, `language`, `hits`, `css`, `version`) VALUES
(26, 180, 'Test Shu', '[{\"id\":1637932126478,\"visibility\":true,\"collapse\":false,\"settings\":{\"admin_label\":\"\",\"title\":\"\",\"heading_selector\":\"h3\",\"title_fontsize\":\"\",\"title_fontweight\":\"\",\"title_position\":\"sppb-text-center\",\"columns_align_center\":0,\"columns_content_alignment\":\"center\",\"fullscreen\":0,\"no_gutter\":0,\"row_width\":{\"unit\":\"px\"},\"row_max_width\":{\"unit\":\"px\"},\"row_min_width\":{\"unit\":\"px\"},\"padding\":\"50px 0px 50px 0px\",\"margin\":\"0px 0px 0px 0px\",\"background_type\":\"none\",\"background_gradient\":{\"color\":\"#00c6fb\",\"color2\":\"#005bea\",\"deg\":\"45\",\"type\":\"linear\"},\"background_image\":{\"src\":\"\"},\"background_parallax\":\"0\",\"background_repeat\":\"no-repeat\",\"background_size\":\"cover\",\"background_size_custom\":{\"unit\":\"px\"},\"background_attachment\":\"fixed\",\"background_position\":\"0 0\",\"background_position_custom_x\":{\"unit\":\"px\"},\"background_position_custom_y\":{\"unit\":\"px\"},\"external_background_video\":\"0\",\"background_video_mp4\":{\"src\":\"\"},\"background_video_ogv\":{\"src\":\"\"},\"video_loop\":1,\"overlay_type\":\"overlay_none\",\"gradient_overlay\":{\"color\":\"rgba(127, 0, 255, 0.8)\",\"color2\":\"rgba(225, 0, 255, 0.7)\",\"deg\":\"45\",\"type\":\"linear\"},\"pattern_overlay\":\"\",\"overlay_pattern_color\":\"\",\"blend_mode\":\"normal\",\"row_border\":0,\"row_border_style\":\"solid\",\"row_border_radius\":0,\"row_boxshadow\":\"0 0 0 0 #ffffff\",\"show_top_shape\":\"\",\"shape_name\":\"clouds-flat\",\"shape_color\":\"#e5e5e5\",\"shape_width\":{\"md\":100,\"sm\":100,\"xs\":100},\"shape_height\":\"\",\"shape_flip\":false,\"shape_invert\":false,\"shape_to_front\":false,\"show_bottom_shape\":\"\",\"bottom_shape_name\":\"clouds-opacity\",\"bottom_shape_color\":\"#e5e5e5\",\"bottom_shape_width\":{\"md\":100,\"sm\":100,\"xs\":100},\"bottom_shape_height\":\"\",\"bottom_shape_flip\":false,\"bottom_shape_invert\":false,\"bottom_shape_to_front\":false,\"hidden_xs\":\"\",\"hidden_sm\":\"\",\"hidden_md\":\"\",\"animationduration\":\"300\",\"animationdelay\":\"0\"},\"layout\":\"12\",\"columns\":[{\"id\":1637932126477,\"class_name\":\"col-md-12\",\"visibility\":true,\"settings\":{\"items_align_center\":0,\"items_content_alignment\":\"center\",\"background_type\":\"none\",\"background_gradient\":{\"color\":\"#00c6fb\",\"color2\":\"#005bea\",\"deg\":\"45\",\"type\":\"linear\"},\"background_image\":{\"src\":\"\"},\"background_repeat\":\"no-repeat\",\"background_size\":\"cover\",\"background_size_custom\":{\"unit\":\"px\"},\"background_attachment\":\"scroll\",\"background_position\":\"0 0\",\"background_position_custom_x\":{\"unit\":\"px\"},\"background_position_custom_y\":{\"unit\":\"px\"},\"overlay_type\":\"overlay_color\",\"gradient_overlay\":{\"color\":\"rgba(127, 0, 255, 0.8)\",\"color2\":\"rgba(225, 0, 255, 0.7)\",\"deg\":\"45\",\"type\":\"linear\"},\"pattern_overlay\":{\"src\":\"\"},\"overlay_pattern_color\":\"\",\"blend_mode\":\"normal\",\"use_border\":0,\"border_width\":\"\",\"border_radius\":0,\"boxshadow\":\"0 0 0 0 #fff\",\"sm_col\":\"\",\"xs_col\":\"\",\"tablet_order\":\"\",\"mobile_order\":\"\",\"hidden_xs\":\"\",\"hidden_sm\":\"\",\"hidden_md\":\"\",\"animationduration\":\"300\",\"animationdelay\":\"0\"},\"addons\":[{\"id\":1637932126481,\"name\":\"text_block\",\"visibility\":true,\"settings\":{\"admin_label\":\"TEST SHU\",\"title\":\"TEST SHU\",\"heading_selector\":\"h3\",\"title_fontsize\":\"\",\"title_lineheight\":\"\",\"title_letterspace\":\"0\",\"text\":\"<h3 style=\\\"text-align: left;\\\"><strong><span style=\\\"font-size: 18pt;\\\">Graph of the last data made available (last 30 days)</span></strong></h3>\\n<table style=\\\"border: 1px solid #000000; width: 800px; height: 164px;\\\" align=\\\"left\\\">\\n<tbody>\\n<tr>\\n<td style=\\\"background-color: #b3b3b3; border: 1px solid #000000;\\\"><span style=\\\"font-size: 10pt;\\\"><strong><code>Station code</code></strong></span></td>\\n<td colspan=\\\"2\\\" style=\\\"border: 1px solid #000000;\\\">&nbsp;<strong><span style=\\\"font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\">{plotalot id=\\\"26\\\" P1=\\\"_MOScode\\\"}</span></code></span></strong></td>\\n</tr>\\n<tr>\\n<td style=\\\"background-color: #b3b3b3; border: 1px solid #000000;\\\"><span style=\\\"font-size: 10pt;\\\"><strong><code>Station name</code></strong></span></td>\\n<td style=\\\"border: 1px solid #000000;\\\">&nbsp;<span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\">{plotalot id=\\\"27\\\" P1=\\\"_MOScode\\\" error_txt=\\\"Sorry there is no data\\\"}</span></span></code></span></td>\\n<td style=\\\"border: 1px solid #000000;\\\"><span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\">{plotalot id=\\\"28\\\" P1=\\\"_MOScode\\\" error_txt=\\\"Sorry there is no data\\\"}</span></span></code></span></span></span></code></span></td>\\n</tr>\\n<tr>\\n<td style=\\\"background-color: #b3b3b3; border: 1px solid #000000;\\\"><span style=\\\"font-size: 10pt;\\\"><strong><code>Parameter name</code></strong></span></td>\\n<td style=\\\"border: 1px solid #000000;\\\"><span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\">&nbsp;{plotalot id=\\\"29\\\" P2=\\\"_MOPAcode\\\" error_txt=\\\"Sorry there is no data\\\"}</span></span></code></span></td>\\n<td style=\\\"border: 1px solid #000000;\\\"><span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\">{plotalot id=\\\"30\\\"\\\"<span style=\\\"background-color: #ffffff; color: #000000;\\\"> P2=\\\"_MOPAcode\\\" error_txt=\\\"Sorry there is no&nbsp; data\\\"</span>}</span></span></code></span></span></span></code></span></td>\\n</tr>\\n<tr>\\n<td style=\\\"background-color: #b3b3b3; border: 1px solid #000000;\\\"><span style=\\\"font-size: 10pt;\\\"><strong><span style=\\\"font-family: arial,helvetica,sans-serif;\\\"><code>Unit</code></span></strong></span></td>\\n<td colspan=\\\"2\\\" style=\\\"border: 1px solid #000000;\\\"><span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\">{plotalot id=\\\"31\\\" P2=\\\"_MOPAcode\\\"}</span></span></code></span><span style=\\\"font-family: arial,helvetica,sans-serif; font-size: 10pt;\\\"><code><span style=\\\"background-color: #ffffff; color: #000000;\\\"><span style=\\\"background-color: #ffffff; color: #000000;\\\"></span></span></code></span></td>\\n</tr>\\n</tbody>\\n</table>\\n<p style=\\\"text-align: center;\\\"><br />{plotalot id=\\\"32\\\" P1=\\\"_MOScode\\\" P2=\\\"_MOPAcode\\\" error_txt=\\\"Sorry there is no data available at this station for this parameter\\\"}<span style=\\\"color: #ffffff; font-size: 16.016px;\\\">({plotalot id=\\\"139\\\" P2=\\\"_MOPAcode\\\"})</span></p>\\n<p style=\\\"text-align: left;\\\"><a href=\\\"index.php/en/?option=com_fabrik&amp;view=form&amp;formid=27&amp;QTDSWFMOScode={plotalot id=&quot;20&quot; P1=&quot;_MOScode&quot;}\\\"><span style=\\\"text-decoration: underline;\\\">Graph for the other parameters at this point</span></a></p>\\n<p style=\\\"text-align: left;\\\"><span style=\\\"text-decoration: underline;\\\"><span style=\\\"color: #000080; text-decoration: underline;\\\"><a href=\\\"pl01-1y?MOScode={plotalot id=&quot;20&quot; P1=&quot;_MOScode&quot;}&amp;MOPAcode={plotalot id=&quot;139&quot; P2=&quot;_MOPAcode&quot;}\\\">Graph for the last year</a></span></span></p>\",\"alignment\":\"\",\"text_fontsize\":\"\",\"text_lineheight\":\"\",\"text_fontweight\":\"\",\"dropcap\":0,\"class\":\"\",\"global_background_type\":\"none\",\"global_background_gradient\":{\"color\":\"#00c6fb\",\"color2\":\"#005bea\",\"deg\":\"45\",\"type\":\"linear\"},\"global_background_image\":{\"src\":\"\"},\"global_background_repeat\":\"no-repeat\",\"global_background_size\":\"cover\",\"global_background_attachment\":\"inherit\",\"global_background_position\":\"50% 50%\",\"global_use_overlay\":0,\"global_overlay_type\":\"overlay_none\",\"global_gradient_overlay\":{\"color\":\"rgba(127, 0, 255, 0.8)\",\"color2\":\"rgba(225, 0, 255, 0.7)\",\"deg\":\"45\",\"type\":\"linear\"},\"global_pattern_overlay\":{\"src\":\"\"},\"global_overlay_pattern_color\":\"\",\"blend_mode\":\"normal\",\"global_user_border\":0,\"global_border_width\":\"\",\"global_border_radius\":0,\"global_margin\":{\"md\":\"0px 0px 30px 0px\",\"sm\":\"\",\"xs\":\"\"},\"global_padding\":\"\",\"global_boxshadow\":\"0 0 0 0 #ffffff\",\"global_use_animation\":0,\"global_animationduration\":\"300\",\"global_animationdelay\":\"0\",\"global_custom_css\":\"\",\"global_custom_position\":0,\"global_seclect_position\":\"relative\",\"global_addon_position_left\":{\"unit\":\"px\"},\"global_addon_position_top\":{\"unit\":\"px\"},\"use_global_width\":\"0\",\"hidden_md\":\"0\",\"hidden_sm\":\"0\",\"hidden_xs\":\"0\",\"acl\":\"\",\"while_scroll_view\":[{\"enable_while_scroll_view\":0,\"on_scroll_actions\":[{\"id\":\"b3fdc1c1e6bfde5942ea\",\"index\":0,\"keyframe\":0,\"name\":\"move\",\"property\":{\"x\":\"0\",\"y\":\"-100\",\"z\":\"0\"},\"range\":{\"max\":500,\"min\":-500,\"stop\":1},\"single\":true,\"title\":\"Move\"},{\"id\":\"936e0225e6dc8edfba7d\",\"index\":1,\"keyframe\":100,\"name\":\"move\",\"property\":{\"x\":0,\"y\":0,\"z\":0},\"range\":{\"max\":500,\"min\":-500,\"stop\":1},\"single\":true,\"title\":\"Move\"}],\"transition_origin_x\":\"center\",\"transition_origin_y\":\"center\",\"enable_tablet\":0,\"enable_mobile\":0}],\"mouse_movement\":[{\"enable_tilt_effect\":0,\"mouse_tilt_direction\":\"direct\",\"mouse_tilt_speed\":\"1\",\"mouse_tilt_max\":\"15\",\"enable_tablet\":0,\"enable_mobile\":0}]}}]}]}]', NULL, 'com_sppagebuilder', 'page', 0, 0, 1, 0, 1, 0, '2021-11-26 13:09:46', 925, '1970-01-01 00:00:00', 0, 0, '0000-00-00 00:00:00', '[]', '', '', '', '*', 1, '', '');

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

--
-- Structure de la table `jgkzw_sppagebuilder_addonlist`
--

CREATE TABLE `jgkzw_sppagebuilder_addonlist` (
  `id` int(5) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `ordering` int(5) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `is_favorite` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_addons`
--

CREATE TABLE `jgkzw_sppagebuilder_addons` (
  `id` int(5) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `code` mediumtext NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `created_by` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_assets`
--

CREATE TABLE `jgkzw_sppagebuilder_assets` (
  `id` bigint(20) NOT NULL,
  `type` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `assets` text NOT NULL,
  `css_path` text DEFAULT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `access` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_collections`
--

CREATE TABLE `jgkzw_sppagebuilder_collections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `asset_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `published` tinyint(4) NOT NULL DEFAULT 1,
  `access` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL DEFAULT '*',
  `created` datetime NOT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_collection_fields`
--

CREATE TABLE `jgkzw_sppagebuilder_collection_fields` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `collection_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(255) NOT NULL DEFAULT '' COMMENT 'title, alias, text, rich-text, image, video, datetime, link, number, switch, color, option, file, checkbox, reference, multi-reference, divider, and more',
  `description` text DEFAULT NULL,
  `options` text DEFAULT NULL,
  `max_length` int(10) UNSIGNED DEFAULT NULL,
  `min_length` int(10) UNSIGNED DEFAULT NULL,
  `default_value` text DEFAULT NULL,
  `placeholder` varchar(255) DEFAULT NULL,
  `required` tinyint(4) NOT NULL DEFAULT 0,
  `reference_collection_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_textarea` tinyint(4) NOT NULL DEFAULT 0,
  `show_time` tinyint(4) NOT NULL DEFAULT 0,
  `file_extensions` varchar(300) DEFAULT NULL COMMENT 'Comma separated extensions for file type',
  `number_format` varchar(100) DEFAULT NULL COMMENT 'Available values: decimal, integer. NULL for allow both.',
  `allow_negative` tinyint(4) NOT NULL DEFAULT 0,
  `number_unit` varchar(100) DEFAULT NULL COMMENT 'Available values: percent, degree. NULL for no unit.',
  `number_step` decimal(13,2) DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_collection_imports`
--

CREATE TABLE `jgkzw_sppagebuilder_collection_imports` (
  `id` bigint(20) NOT NULL,
  `data` text DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `created_by` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_collection_items`
--

CREATE TABLE `jgkzw_sppagebuilder_collection_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `asset_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `collection_id` bigint(20) UNSIGNED NOT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `access` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL DEFAULT '*',
  `created` datetime NOT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_collection_item_values`
--

CREATE TABLE `jgkzw_sppagebuilder_collection_item_values` (
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `field_id` bigint(20) UNSIGNED NOT NULL,
  `value` text DEFAULT NULL,
  `reference_item_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'The reference item id from the #__sppagebuilder_collection_items table.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_colors`
--

CREATE TABLE `jgkzw_sppagebuilder_colors` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `colors` text DEFAULT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_comments`
--

CREATE TABLE `jgkzw_sppagebuilder_comments` (
  `id` bigint(20) NOT NULL,
  `source_type` varchar(50) NOT NULL DEFAULT 'article',
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `content` text NOT NULL,
  `replies` int(11) NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `access` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `checked_out` int(10) NOT NULL DEFAULT 0,
  `checked_out_time` datetime DEFAULT NULL,
  `language` char(7) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_fonts`
--

CREATE TABLE `jgkzw_sppagebuilder_fonts` (
  `id` bigint(20) NOT NULL,
  `family_name` varchar(100) NOT NULL DEFAULT '',
  `data` text DEFAULT NULL,
  `type` enum('google','local') DEFAULT 'google',
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_image_shapes`
--

CREATE TABLE `jgkzw_sppagebuilder_image_shapes` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `shape` text DEFAULT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_integrations`
--

CREATE TABLE `jgkzw_sppagebuilder_integrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `component` varchar(255) NOT NULL DEFAULT '',
  `plugin` mediumtext NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_languages`
--

CREATE TABLE `jgkzw_sppagebuilder_languages` (
  `id` int(5) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `lang_tag` varchar(255) NOT NULL DEFAULT '',
  `lang_key` varchar(100) DEFAULT NULL,
  `version` varchar(255) NOT NULL DEFAULT '',
  `state` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_likes`
--

CREATE TABLE `jgkzw_sppagebuilder_likes` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `comment_id` bigint(20) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_presets`
--

CREATE TABLE `jgkzw_sppagebuilder_presets` (
  `id` int(5) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `addon_name` varchar(255) NOT NULL DEFAULT '',
  `preset` mediumtext NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `created_by` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_sections`
--

CREATE TABLE `jgkzw_sppagebuilder_sections` (
  `id` int(5) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `section` mediumtext NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `created_by` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_sppagebuilder_typography`
--

CREATE TABLE `jgkzw_sppagebuilder_typography` (
  `id` bigint(20) NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT '',
  `typography` text DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `created_by` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_tabulizer_user_permissions`
--

CREATE TABLE `jgkzw_tabulizer_user_permissions` (
  `action` varchar(255) NOT NULL,
  `roles` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Structure de la table `jgkzw_tags`
--

CREATE TABLE `jgkzw_tags` (
  `id` int(10) UNSIGNED NOT NULL,
  `parent_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `lft` int(11) NOT NULL DEFAULT 0,
  `rgt` int(11) NOT NULL DEFAULT 0,
  `level` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `path` varchar(400) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL,
  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `checked_out` int(10) UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `access` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.',
  `metakey` varchar(1024) NOT NULL DEFAULT '',
  `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.',
  `created_user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_time` datetime NOT NULL,
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified_user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `modified_time` datetime NOT NULL,
  `images` text NOT NULL,
  `urls` text NOT NULL,
  `hits` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL,
  `version` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `jgkzw_tags`
--

INSERT INTO `jgkzw_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, '', '', '', '', 925, '2019-06-17 13:44:22', '', 925, '2019-06-17 13:44:22', '', '', 0, '*', 1, NULL, NULL);

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

--
-- Structure de la table `jgkzw_template_overrides`
--

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

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

--
-- Structure de la table `jgkzw_template_styles`
--

CREATE TABLE `jgkzw_template_styles` (
  `id` int(10) UNSIGNED NOT NULL,
  `template` varchar(50) NOT NULL DEFAULT '',
  `client_id` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `home` char(7) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `inheritable` tinyint(4) NOT NULL DEFAULT 0,
  `parent` varchar(50) DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `jgkzw_template_styles`
--

INSERT INTO `jgkzw_template_styles` (`id`, `template`, `client_id`, `home`, `title`, `params`, `inheritable`, `parent`) VALUES
(9, 'g5_hydrogen', 0, '0', 'Hydrogen - Par défaut', '{\"preset\":null}', 0, ''),
(10, 'g5_hydrogen', 0, '0', 'Hydrogen - Home', '{\"preset\":null}', 0, ''),
(16, 'rt_fluent', 0, '0', 'Fluent - Home FR', '{\"configuration\":\"16\",\"preset\":\"default\"}', 0, ''),
(17, 'rt_fluent', 0, '1', 'Fluent - Home EN', '{\"configuration\":\"17\",\"preset\":\"default\"}', 0, ''),
(18, 'rt_fluent', 0, '0', 'Fluent - Home RU', '{\"configuration\":\"18\",\"preset\":\"default\"}', 0, ''),
(19, 'rt_fluent', 0, '0', 'Fluent - Home ES', '{\"configuration\":\"19\",\"preset\":\"default\"}', 0, ''),
(20, 'rt_fluent', 0, '0', 'Fluent - Home PT', '{\"configuration\":\"20\",\"preset\":\"default\"}', 0, ''),
(21, 'atum', 1, '1', 'Atum - Default', '{\"hue\":\"hsl(214, 63%, 20%)\",\"bg-light\":\"#f0f4fb\",\"text-dark\":\"#495057\",\"text-light\":\"#ffffff\",\"link-color\":\"#2a69b8\",\"special-color\":\"#001b4c\",\"monochrome\":\"0\",\"loginLogo\":\"\",\"loginLogoAlt\":\"\",\"logoBrandLarge\":\"\",\"logoBrandLargeAlt\":\"\",\"logoBrandSmall\":\"\",\"logoBrandSmallAlt\":\"\"}', 1, ''),
(22, 'cassiopeia', 0, '0', 'Cassiopeia - Default', '{}', 1, '');

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

--
-- Structure de la table `jgkzw_tuf_metadata`
--

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

--
-- Déchargement des données de la table `jgkzw_tuf_metadata`
--

INSERT INTO `jgkzw_tuf_metadata` (`id`, `update_site_id`, `root`, `targets`, `snapshot`, `timestamp`, `mirrors`) VALUES
(1, 1, '{\"signed\":{\"_type\":\"root\",\"spec_version\":\"1.0\",\"version\":12,\"expires\":\"2026-12-16T13:18:16Z\",\"keys\":{\"00e432b504508246e2bd536dd6c13e55e8b3256f0be9f767fae26da6c2a28663\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"250f8d293c49817a83909dead96ad82b62f7ac16844cf589f8d2f0e0b15cab21\"}},\"07eb082f367c034a95878687f6648aa76d93652b6ee73e58817053d89af6c44f\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"9b2af2d9b9727227735253d795bd27ea8f0e294a5f3603e822dc5052b44802b9\"}},\"179d107f20a2354ac5bd9a1f32a2df1763c0059617f0c132bebeb4816a1a8637\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"159a4195cbafce2bb959f09ab2b36a2127b8967f94d389f65f1e7892fccfe8b8\"}},\"192ad7343e7d431533d9577fd957b6f924680177db4dc6c0e146dad6810a90a4\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"042b66e1431a1f5c2c15b4a16ea60f23f466851b58e9ff057dbfc2a5e0d821d1\"}},\"1b1b1dd55b2c1c7258714cf1c1ae06f23e4607b28c762d016a9d81c48ffe5669\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"a18e5ebabc19d5d5984b601a292ece61ba3662ab2d071dc520da5bd4f8948799\"}},\"273e94e5477e306ad6de75be1524860e219e265ff9a57c81ababd0691e45706c\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"1cb6702338830ef1c9e76a022fed27172d475bbaace754d8141ebc96dad8b15f\"}},\"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\"}},\"9eabc37383b243cd236375c66693db385911914b52556e1ec05fc70ed45e1bfe\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"a4b8509488f1c29ab0b1f610e7452fbec78b4f33f1fba5a418d6ff087c567429\"}},\"a1a4b7fdbeedfdeff12d7776de098a2f8de8d2ab7bfe10062a281b3819b078c1\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"ea764b0b475b3c396627ac6689cbd8f54a5f93e87b6f5e3eb44a7ccafb542ff3\"}},\"a599a27a3ec4d520059c591338759dc401006b1c4cb1db85a286e667253d28b6\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"45e416d24d13a60ace5ab028827d5cfc8ba177bb9466bf2acd8efa6e3547911a\"}},\"bfee044dd4574a281c9b7c0b6829913ef292c66c0512d1091a298cfca8493da9\":{\"keytype\":\"ed25519\",\"scheme\":\"ed25519\",\"keyid_hash_algorithms\":[\"sha256\",\"sha512\"],\"keyval\":{\"public\":\"6eb44460e5914e8e0df726ddb90bd1f3771b8ce5af19b40fb01ac5a85b023a6f\"}},\"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\",\"192ad7343e7d431533d9577fd957b6f924680177db4dc6c0e146dad6810a90a4\"],\"threshold\":1},\"snapshot\":{\"keyids\":[\"07eb082f367c034a95878687f6648aa76d93652b6ee73e58817053d89af6c44f\",\"2dcaf3d0e552f150792f7c636d45429246dcfa34ac35b46a44f5c87cd17d457e\",\"ecc851a051c8d6439331ff0a37c7727321fc39896a34f950f73638b8a7cb472e\",\"e2229942b0fc1e6d7f82adf258e5bdadac10046d1470b7ec459c9eb4e076026b\",\"bfee044dd4574a281c9b7c0b6829913ef292c66c0512d1091a298cfca8493da9\",\"9eabc37383b243cd236375c66693db385911914b52556e1ec05fc70ed45e1bfe\",\"273e94e5477e306ad6de75be1524860e219e265ff9a57c81ababd0691e45706c\",\"00e432b504508246e2bd536dd6c13e55e8b3256f0be9f767fae26da6c2a28663\",\"179d107f20a2354ac5bd9a1f32a2df1763c0059617f0c132bebeb4816a1a8637\",\"a1a4b7fdbeedfdeff12d7776de098a2f8de8d2ab7bfe10062a281b3819b078c1\",\"192ad7343e7d431533d9577fd957b6f924680177db4dc6c0e146dad6810a90a4\",\"a599a27a3ec4d520059c591338759dc401006b1c4cb1db85a286e667253d28b6\"],\"threshold\":1},\"targets\":{\"keyids\":[\"31dd7c7290d664c9b88c0dead2697175293ea7df81b7f24153a37370fd3901c3\",\"ecc851a051c8d6439331ff0a37c7727321fc39896a34f950f73638b8a7cb472e\",\"e2229942b0fc1e6d7f82adf258e5bdadac10046d1470b7ec459c9eb4e076026b\",\"bfee044dd4574a281c9b7c0b6829913ef292c66c0512d1091a298cfca8493da9\",\"9eabc37383b243cd236375c66693db385911914b52556e1ec05fc70ed45e1bfe\",\"273e94e5477e306ad6de75be1524860e219e265ff9a57c81ababd0691e45706c\",\"00e432b504508246e2bd536dd6c13e55e8b3256f0be9f767fae26da6c2a28663\",\"179d107f20a2354ac5bd9a1f32a2df1763c0059617f0c132bebeb4816a1a8637\",\"a1a4b7fdbeedfdeff12d7776de098a2f8de8d2ab7bfe10062a281b3819b078c1\"],\"threshold\":1},\"timestamp\":{\"keyids\":[\"9e41a9d62d94c6a1c8a304f62c5bd72d84a9f286f27e8327cedeacb09e5156cc\"],\"threshold\":1}},\"consistent_snapshot\":true},\"signatures\":[{\"keyid\":\"1b1b1dd55b2c1c7258714cf1c1ae06f23e4607b28c762d016a9d81c48ffe5669\",\"sig\":\"566d6aa10932b36ebda6fbb56f17a683c0044cc1e94947fa26f454319e544bf83ccaaca8197874ef51c2eb51ba252297bc1b4f8c6d8b58ed31f30d6d8e100801\"}]}', '{\"signed\":{\"_type\":\"targets\",\"spec_version\":\"1.0\",\"version\":77,\"expires\":\"2026-02-25T21:11:18Z\",\"targets\":{\"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.3.3-Stable-Update_Package.zip\":{\"length\":29441974,\"hashes\":{\"sha512\":\"396cdba79e1c85138341e00f7e91fcb7d78e6de4126a7f9f76dc5a3973ceaf20dee90bb1b09492669dbaf4d4c9200df46677c09fb7fbd0535d14505d3c7cf3a2\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.3.3 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla5/5-3-3/Joomla_5.3.3-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.3.3/Joomla_5.3.3-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/5.3.3/Joomla_5.3.3-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5930-joomla-5-3-3-bugfix-release.html\",\"title\":\"Joomla! 5.3.3 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.3.3\",\"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.3.3\"}},\"Joomla_5.3.4-Stable-Update_Package.zip\":{\"length\":29854677,\"hashes\":{\"sha512\":\"12a386645464b4f973ec28b40252cca28f56fdbe3f89efa37a4deaebb3334088c427e74bb90fa3068efc2df785a96510befde496f6341bd83f2a1b45b3d693ea\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.3.4 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla5/5-3-4/Joomla_5.3.4-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.3.4/Joomla_5.3.4-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/5.3.4/Joomla_5.3.4-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5936-joomla-5-3-4-security-bugfix-release.html\",\"title\":\"Joomla! 5.3.4 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.3.4\",\"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.3.4\"}},\"Joomla_5.4.0-Stable-Update_Package.zip\":{\"length\":29974846,\"hashes\":{\"sha512\":\"c862b2674acd3f7da6062ea2a0defa35c2c5c9091eaf742106f6cf5793d321ed7a9b99901c7ad15845cef4e4cb7e2806af64794fdcf5a30b7e1c4db60bcd10ae\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.4.0 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla5/5-4-0/Joomla_5.4.0-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.4.0/Joomla_5.4.0-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/5.4.0/Joomla_5.4.0-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5939-joomla-6-0-and-joomla-5-4-are-here.html\",\"title\":\"Joomla! 5.4.0 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.4.0\",\"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.4.0\"}},\"Joomla_5.4.1-Stable-Update_Package.zip\":{\"length\":30009045,\"hashes\":{\"sha512\":\"aeddd1143cd574ff3f6e9bc7d7c67bf5d21dc1b404d98498a691b1fff12f5d245b48424f97155f20e2807e4ee2c1aed7313fae3ab8c0d27a08a20947c166c43e\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.4.1 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla5/5-4-1/Joomla_5.4.1-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.4.1/Joomla_5.4.1-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/5.4.1/Joomla_5.4.1-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5941-joomla-6-0-1-and-5-4-1-bugfix-release.html\",\"title\":\"Joomla! 5.4.1 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.4.1\",\"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.4.1\"}},\"Joomla_5.4.1-rc1-Release_Candidate-Update_Package.zip\":{\"length\":30010108,\"hashes\":{\"sha512\":\"facfd83e03d245c474ca166ebb0bf9635e7b225177c5dd96e18686db67dcd778a68cfaf346cc363761b1df4e5ad3f2d7870f0ea21ecc1a6fbbb46d85a40a00e1\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.4.1-rc1 Release\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.4.1-rc1/Joomla_5.4.1-rc1-Release_Candidate-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://github.com/joomla/joomla-cms/releases/tag/5.4.1\",\"title\":\"Joomla! 5.4.1-rc1 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.4.1-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.4.1-rc1\"}},\"Joomla_5.4.1-rc2-Release_Candidate-Update_Package.zip\":{\"length\":30009059,\"hashes\":{\"sha512\":\"9345d1d34e6ae6fd7611bff6c164638df2ad07dbdd985d20f3aec0072147d4aebe74f87c0eaf7e767aa5d8232a624ff1db87bc2950d7d83027bb693a17504a20\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 5.4.1-rc2 Release\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/5.4.1-rc2/Joomla_5.4.1-rc2-Release_Candidate-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://github.com/joomla/joomla-cms/releases/tag/5.4.1-rc2\",\"title\":\"Joomla! 5.4.1-rc2 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 5.4.1-rc2\",\"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.4.1-rc2\"}},\"Joomla_6.0.0-Stable-Update_Package.zip\":{\"length\":30236123,\"hashes\":{\"sha512\":\"ab69bb8305aa23f010695366ef769c99ec5a32343afbb418b6ed03c9ca541ad0222136d3a7ed4a8989f33d638ffdfc4c551e96250e0dbaa3fe45f2c2e8825018\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 6.0.0 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla6/6-0-0/Joomla_6.0.0-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/6.0.0/Joomla_6.0.0-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/6.0.0/Joomla_6.0.0-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5939-joomla-6-0-and-joomla-5-4-are-here.html\",\"title\":\"Joomla! 6.0.0 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 6.0.0\",\"php_minimum\":\"8.3.0\",\"channel\":\"6.x\",\"stability\":\"Stable\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"12.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(6\\\\.[0-4])|^(5\\\\.4)\"},\"type\":\"file\",\"version\":\"6.0.0\"}},\"Joomla_6.0.1-Stable-Update_Package.zip\":{\"length\":30247182,\"hashes\":{\"sha512\":\"38f8dd3ff1fd48b9973193a4484591b3b9f4a7516eb7640ff1687d84c81d4dc8cd05f6f58b9f48172bae41a466442f4a5af4a23e3d63869aeb1b05f4fdd6512e\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 6.0.1 Release\",\"downloads\":[{\"url\":\"https://downloads.joomla.org/cms/joomla6/6-0-1/Joomla_6.0.1-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/6.0.1/Joomla_6.0.1-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"},{\"url\":\"https://update.joomla.org/releases/6.0.1/Joomla_6.0.1-Stable-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://www.joomla.org/announcements/release-news/5941-joomla-6-0-1-and-5-4-1-bugfix-release.html\",\"title\":\"Joomla! 6.0.1 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 6.0.1\",\"php_minimum\":\"8.3.0\",\"channel\":\"6.x\",\"stability\":\"Stable\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"12.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(6\\\\.[0-4])|^(5\\\\.4)\"},\"type\":\"file\",\"version\":\"6.0.1\"}},\"Joomla_6.0.1-rc1-Release_Candidate-Update_Package.zip\":{\"length\":30248231,\"hashes\":{\"sha512\":\"fe48586af9382070dd6275885f931d7bb6eca63129e2a252587c7c48ca9d666d3a38f41a0122698f671657a729467f4eef4fde09dfc97dbfb3c633341b568839\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 6.0.1-rc1 Release\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/6.0.1-rc1/Joomla_6.0.1-rc1-Release_Candidate-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://github.com/joomla/joomla-cms/releases/tag/6.0.1-rc1\",\"title\":\"Joomla! 6.0.1-rc1 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 6.0.1-rc1\",\"php_minimum\":\"8.3.0\",\"channel\":\"6.x\",\"stability\":\"RC\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"12.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(6\\\\.[0-4])|^(5\\\\.4)\"},\"type\":\"file\",\"version\":\"6.0.1-rc1\"}},\"Joomla_6.0.1-rc2-Release_Candidate-Update_Package.zip\":{\"length\":30247185,\"hashes\":{\"sha512\":\"37aa3600138a3e61250060b6650276bccd975d2dd629a0fb074762024a77a2a94197b1424a49785aa1382d48d4526acc59932fe8ac00e1207d30cc9f82544343\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 6.0.1-rc2 Release\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/6.0.1-rc2/Joomla_6.0.1-rc2-Release_Candidate-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://github.com/joomla/joomla-cms/releases/tag/6.0.1-rc2\",\"title\":\"Joomla! 6.0.1-rc2 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 6.0.1-rc2\",\"php_minimum\":\"8.3.0\",\"channel\":\"6.x\",\"stability\":\"RC\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"12.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(6\\\\.[0-4])|^(5\\\\.4)\"},\"type\":\"file\",\"version\":\"6.0.1-rc2\"}},\"Joomla_6.1.0-alpha1-Alpha-Update_Package.zip\":{\"length\":30430173,\"hashes\":{\"sha512\":\"e229f74cff44e899ed699781a35bebee9a956728b0fbd7236e6c41f3e63df16b72c2355ef4266ec1561ebddcb4a9127979cfe671dd0b6c0912dc0e5214461a70\"},\"custom\":{\"client\":\"site\",\"description\":\"Joomla! 6.1.0-alpha1 Release\",\"downloads\":[{\"url\":\"https://github.com/joomla/joomla-cms/releases/download/6.1.0-alpha1/Joomla_6.1.0-alpha1-Alpha-Update_Package.zip\",\"format\":\"zip\",\"type\":\"full\"}],\"element\":\"joomla\",\"infourl\":{\"url\":\"https://developer.joomla.org/news/1014-joomla-6-1-alpha1-test-the-future-of-joomla.html\",\"title\":\"Joomla! 6.1.0-alpha1 Release\"},\"maintainer\":\"Joomla! Production Department\",\"maintainerurl\":\"https://www.joomla.org\",\"name\":\"Joomla! 6.1.0-alpha1\",\"php_minimum\":\"8.3.0\",\"channel\":\"6.x\",\"stability\":\"Alpha\",\"supported_databases\":{\"mariadb\":\"10.4\",\"mysql\":\"8.0.13\",\"postgresql\":\"12.0\"},\"targetplatform\":{\"name\":\"joomla\",\"version\":\"(6\\\\.[0-4])|^(5\\\\.4)\"},\"type\":\"file\",\"version\":\"6.1.0-alpha1\"}}}},\"signatures\":[{\"keyid\":\"31dd7c7290d664c9b88c0dead2697175293ea7df81b7f24153a37370fd3901c3\",\"sig\":\"6f807a1ad5f8a72f85845c6c5ed60058e3bf3398429e5b750a6ee933dddb2626957110cc46aba00d993530ea95300fdeb693c5469542e6372e8884a91678740c\"},{\"keyid\":\"a1a4b7fdbeedfdeff12d7776de098a2f8de8d2ab7bfe10062a281b3819b078c1\",\"sig\":\"503c82bd4e09ef4a2be29bb02e7559a454727d4dc28fe9a22fc1b831a266a7594c5a64d2accc59d5998fbc65154ca18ce92a178e2134a3a30c0097668c6ed504\"}]}', '{\"signed\":{\"_type\":\"snapshot\",\"spec_version\":\"1.0\",\"version\":88,\"expires\":\"2026-06-23T21:16:03Z\",\"meta\":{\"targets.json\":{\"length\":13669,\"hashes\":{\"sha512\":\"8a5b9b4ffbfbfbf8bd3b793c3e7c3a9cdc84fe3bca1f8c5993ec7b2c9de1cf90f94a098a3faea5e9f3fc0df299c6a89bb00d974f3bfbe7f95425c1b0791d0044\"},\"version\":77}}},\"signatures\":[{\"keyid\":\"07eb082f367c034a95878687f6648aa76d93652b6ee73e58817053d89af6c44f\",\"sig\":\"087de439eaa9cadfa143bedbd52e10b8ed65c089a60a9c09fd3af5711d52a494b7ea03ad072f4017301b6cd51422c5c902156fa17cb275d5533718669eab9801\"}]}', '{\"signed\":{\"_type\":\"timestamp\",\"spec_version\":\"1.0\",\"version\":864,\"expires\":\"2025-12-03T01:04:38Z\",\"meta\":{\"snapshot.json\":{\"length\":532,\"hashes\":{\"sha512\":\"36fb872771b243bc0ed9821733a5888dd80f68634a0baf50d517050bf35277ca6bb1f1db760f7885db17bfbdb49c8939070c5bedc3cb1535c80d5b247891d82c\"},\"version\":88}}},\"signatures\":[{\"keyid\":\"9e41a9d62d94c6a1c8a304f62c5bd72d84a9f286f27e8327cedeacb09e5156cc\",\"sig\":\"5ec05c2d8b4233b5e298f7d37747ce2c1d47197a0183968c0acde33d94b88ba06adcddd2c05333731b2134b03b1996f4fd23cbce2813ca155947b85030e4bf08\"}]}', NULL);

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

--
-- Structure de la table `jgkzw_ucm_base`
--

CREATE TABLE `jgkzw_ucm_base` (
  `ucm_id` int(10) UNSIGNED NOT NULL,
  `ucm_item_id` int(10) NOT NULL,
  `ucm_type_id` int(11) NOT NULL,
  `ucm_language_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `jgkzw_ucm_content`
--

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

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

--
-- Structure de la table `jgkzw_updates`
--

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

--
-- Déchargement des données de la table `jgkzw_updates`
--

INSERT INTO `jgkzw_updates` (`update_id`, `update_site_id`, `extension_id`, `name`, `description`, `element`, `type`, `folder`, `client_id`, `version`, `data`, `detailsurl`, `infourl`, `changelogurl`, `extra_query`) VALUES
(2, 2, 0, 'Afrikaans', '', 'pkg_af-ZA', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/af-ZA_details.xml', '', '', ''),
(3, 2, 0, 'Arabic Unitag', '', 'pkg_ar-AA', 'package', '', 0, '4.0.2.1', '', 'https://update.joomla.org/language/details4/ar-AA_details.xml', '', '', ''),
(4, 2, 0, 'Basque', '', 'pkg_eu-ES', 'package', '', 0, '4.4.9.3', '', 'https://update.joomla.org/language/details4/eu-ES_details.xml', '', '', ''),
(5, 2, 0, 'Belarusian', '', 'pkg_be-BY', 'package', '', 0, '4.4.2.1', '', 'https://update.joomla.org/language/details4/be-BY_details.xml', '', '', ''),
(6, 2, 0, 'Bulgarian', '', 'pkg_bg-BG', 'package', '', 0, '4.4.14.2', '', 'https://update.joomla.org/language/details4/bg-BG_details.xml', '', '', ''),
(7, 2, 0, 'Catalan', '', 'pkg_ca-ES', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/ca-ES_details.xml', '', '', ''),
(8, 2, 0, 'Chinese, Simplified', '', 'pkg_zh-CN', 'package', '', 0, '4.2.3.9', '', 'https://update.joomla.org/language/details4/zh-CN_details.xml', '', '', ''),
(9, 2, 0, 'Chinese, Traditional', '', 'pkg_zh-TW', 'package', '', 0, '4.4.2.1', '', 'https://update.joomla.org/language/details4/zh-TW_details.xml', '', '', ''),
(10, 2, 0, 'Croatian', '', 'pkg_hr-HR', 'package', '', 0, '4.3.1.1', '', 'https://update.joomla.org/language/details4/hr-HR_details.xml', '', '', ''),
(11, 2, 0, 'Czech', '', 'pkg_cs-CZ', 'package', '', 0, '4.4.15.2', '', 'https://update.joomla.org/language/details4/cs-CZ_details.xml', '', '', ''),
(12, 2, 0, 'Danish', '', 'pkg_da-DK', 'package', '', 0, '4.4.11.1', '', 'https://update.joomla.org/language/details4/da-DK_details.xml', '', '', ''),
(13, 2, 0, 'Dutch', '', 'pkg_nl-NL', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/nl-NL_details.xml', '', '', ''),
(14, 2, 0, 'English, Australia', '', 'pkg_en-AU', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/en-AU_details.xml', '', '', ''),
(15, 2, 0, 'English, Canada', '', 'pkg_en-CA', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/en-CA_details.xml', '', '', ''),
(16, 2, 0, 'English, New Zealand', '', 'pkg_en-NZ', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/en-NZ_details.xml', '', '', ''),
(17, 2, 0, 'English, USA', '', 'pkg_en-US', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/en-US_details.xml', '', '', ''),
(18, 2, 0, 'Estonian', '', 'pkg_et-EE', 'package', '', 0, '4.4.4.1', '', 'https://update.joomla.org/language/details4/et-EE_details.xml', '', '', ''),
(19, 2, 0, 'Finnish', '', 'pkg_fi-FI', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/fi-FI_details.xml', '', '', ''),
(20, 2, 0, 'Flemish', '', 'pkg_nl-BE', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/nl-BE_details.xml', '', '', ''),
(21, 2, 0, 'French, Canada', '', 'pkg_fr-CA', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/fr-CA_details.xml', '', '', ''),
(22, 2, 0, 'Georgian', '', 'pkg_ka-GE', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/ka-GE_details.xml', '', '', ''),
(23, 2, 0, 'German', '', 'pkg_de-DE', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/de-DE_details.xml', '', '', ''),
(24, 2, 0, 'German, Austria', '', 'pkg_de-AT', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/de-AT_details.xml', '', '', ''),
(25, 2, 0, 'German, Liechtenstein', '', 'pkg_de-LI', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/de-LI_details.xml', '', '', ''),
(26, 2, 0, 'German, Luxembourg', '', 'pkg_de-LU', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/de-LU_details.xml', '', '', ''),
(27, 2, 0, 'German, Switzerland', '', 'pkg_de-CH', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/de-CH_details.xml', '', '', ''),
(28, 2, 0, 'Greek', '', 'pkg_el-GR', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/el-GR_details.xml', '', '', ''),
(29, 2, 0, 'Hungarian', '', 'pkg_hu-HU', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/hu-HU_details.xml', '', '', ''),
(30, 2, 0, 'Irish', '', 'pkg_ga-IE', 'package', '', 0, '4.2.8.1', '', 'https://update.joomla.org/language/details4/ga-IE_details.xml', '', '', ''),
(31, 2, 0, 'Italian', '', 'pkg_it-IT', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/it-IT_details.xml', '', '', ''),
(32, 2, 0, 'Japanese', '', 'pkg_ja-JP', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/ja-JP_details.xml', '', '', ''),
(33, 2, 0, 'Kazakh', '', 'pkg_kk-KZ', 'package', '', 0, '4.4.0.3', '', 'https://update.joomla.org/language/details4/kk-KZ_details.xml', '', '', ''),
(34, 2, 0, 'Korean', '', 'pkg_ko-KR', 'package', '', 0, '4.4.2.1', '', 'https://update.joomla.org/language/details4/ko-KR_details.xml', '', '', ''),
(35, 2, 0, 'Latvian', '', 'pkg_lv-LV', 'package', '', 0, '4.4.1.1', '', 'https://update.joomla.org/language/details4/lv-LV_details.xml', '', '', ''),
(36, 2, 0, 'Lithuanian', '', 'pkg_lt-LT', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/lt-LT_details.xml', '', '', ''),
(37, 2, 0, 'North Macedonian', '', 'pkg_mk-MK', 'package', '', 0, '4.2.4.1', '', 'https://update.joomla.org/language/details4/mk-MK_details.xml', '', '', ''),
(38, 2, 0, 'Norwegian Bokmål', '', 'pkg_nb-NO', 'package', '', 0, '4.4.10.1', '', 'https://update.joomla.org/language/details4/nb-NO_details.xml', '', '', ''),
(39, 2, 0, 'Pashto Afghanistan', '', 'pkg_ps-AF', 'package', '', 0, '4.3.4.1', '', 'https://update.joomla.org/language/details4/ps-AF_details.xml', '', '', ''),
(40, 2, 0, 'Persian Farsi', '', 'pkg_fa-IR', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/fa-IR_details.xml', '', '', ''),
(41, 2, 0, 'Polish', '', 'pkg_pl-PL', 'package', '', 0, '4.4.4.1', '', 'https://update.joomla.org/language/details4/pl-PL_details.xml', '', '', ''),
(42, 2, 0, 'Portuguese, Brazil', '', 'pkg_pt-BR', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/pt-BR_details.xml', '', '', ''),
(43, 2, 0, 'Romanian', '', 'pkg_ro-RO', 'package', '', 0, '4.4.9.1', '', 'https://update.joomla.org/language/details4/ro-RO_details.xml', '', '', ''),
(44, 2, 0, 'Serbian, Cyrillic', '', 'pkg_sr-RS', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/sr-RS_details.xml', '', '', ''),
(45, 2, 0, 'Serbian, Latin', '', 'pkg_sr-YU', 'package', '', 0, '4.4.15.1', '', 'https://update.joomla.org/language/details4/sr-YU_details.xml', '', '', ''),
(46, 2, 0, 'Slovak', '', 'pkg_sk-SK', 'package', '', 0, '4.4.15.1', '', 'https://update.joomla.org/language/details4/sk-SK_details.xml', '', '', ''),
(47, 2, 0, 'Slovenian', '', 'pkg_sl-SI', 'package', '', 0, '4.4.14.2', '', 'https://update.joomla.org/language/details4/sl-SI_details.xml', '', '', ''),
(48, 2, 0, 'Swedish', '', 'pkg_sv-SE', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/sv-SE_details.xml', '', '', ''),
(49, 2, 0, 'Tamil, India', '', 'pkg_ta-IN', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/ta-IN_details.xml', '', '', ''),
(50, 2, 0, 'Thai', '', 'pkg_th-TH', 'package', '', 0, '4.4.13.1', '', 'https://update.joomla.org/language/details4/th-TH_details.xml', '', '', ''),
(51, 2, 0, 'Turkish', '', 'pkg_tr-TR', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/tr-TR_details.xml', '', '', ''),
(52, 2, 0, 'Ukrainian', '', 'pkg_uk-UA', 'package', '', 0, '4.4.5.1', '', 'https://update.joomla.org/language/details4/uk-UA_details.xml', '', '', ''),
(53, 2, 0, 'Vietnamese', '', 'pkg_vi-VN', 'package', '', 0, '4.2.2.1', '', 'https://update.joomla.org/language/details4/vi-VN_details.xml', '', '', ''),
(54, 2, 0, 'Welsh', '', 'pkg_cy-GB', 'package', '', 0, '4.4.14.1', '', 'https://update.joomla.org/language/details4/cy-GB_details.xml', '', '', ''),
(55, 9, 0, 'Gantry 5', 'Gantry 5 Framework', 'pkg_gantry5', 'package', '', 1, '5.5.25', '', 'http://updates.gantry.org/5.0/joomla/pkg_gantry5.xml', 'http://docs.gantry.org/gantry5', NULL, ''),
(56, 10, 0, 'Helium', 'Helium Template', 'tpl_g5_helium', 'template', '', 0, '5.5.25', '', 'https://updates.gantry.org/5.0/joomla/tpl_g5_helium.xml', '', '', ''),
(57, 10, 0, 'Hydrogen', 'Hydrogen Template', 'tpl_g5_hydrogen', 'template', '', 0, '5.5.25', '', 'https://updates.gantry.org/5.0/joomla/tpl_g5_hydrogen.xml', '', '', ''),
(58, 11, 0, 'Hydrogen', 'Hydrogen Template', 'tpl_g5_hydrogen', 'template', '', 1, '5.5.25', '', 'http://updates.gantry.org/5.0/joomla/tpl_g5_hydrogen.xml', 'https://gantry.org', NULL, ''),
(60, 58, 10026, 'SP Page Builder', '', 'com_sppagebuilder', 'component', '', 1, '6.1.2', '', 'https://www.joomshaper.com/updates/com-sp-page-builder-pro-next.xml', '', NULL, ''),
(65, 1, 700, 'Joomla', '', 'joomla', 'file', '', 0, '5.4.1', '', 'https://update.joomla.org/core/j4/next.xml', '', '', '');

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

--
-- Structure de la table `jgkzw_update_sites`
--

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

--
-- Déchargement des données de la table `jgkzw_update_sites`
--

INSERT INTO `jgkzw_update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`, `extra_query`, `checked_out`, `checked_out_time`) VALUES
(1, 'Joomla! Core', 'collection', 'https://update.joomla.org/core/sts/list_sts.xml', 1, 1765495917, '', NULL, NULL),
(2, 'Accredited Joomla! Translations', 'collection', 'https://update.joomla.org/language/translationlist_4.xml', 1, 1765375402, '', NULL, NULL),
(3, 'Joomla! Update Component', 'extension', 'https://update.joomla.org/core/extensions/com_joomlaupdate.xml', 1, 1765375402, '', NULL, NULL),
(5, 'FOF 3.x', 'extension', 'http://cdn.akeebabackup.com/updates/fof3_file.xml', 1, 1765375403, '', NULL, NULL),
(6, 'Akeeba FEF', 'extension', 'http://cdn.akeebabackup.com/updates/fef.xml', 1, 1765375403, '', NULL, NULL),
(8, 'SP Page Builder', 'extension', 'https://www.joomshaper.com/updates/com-sp-page-builder-pro.xml', 1, 1765375403, '', NULL, NULL),
(9, 'Gantry 5', 'extension', 'http://updates.gantry.org/5.0/joomla/pkg_gantry5.xml', 1, 1765375403, '', NULL, NULL),
(10, 'Gantry 5', 'collection', 'http://updates.gantry.org/5.0/joomla/list.xml', 1, 1765375404, '', NULL, NULL),
(11, 'Hydrogen Template', 'extension', 'http://updates.gantry.org/5.0/joomla/tpl_g5_hydrogen.xml', 1, 1765375404, '', NULL, NULL),
(26, 'JCE Editor Package', 'extension', 'https://cdn.joomlacontenteditor.net/updates/xml/editor/pkg_jce_pro.xml', 1, 1765375405, 'key=79a4490310409fac11145249495e19e5', NULL, NULL),
(29, 'Akeeba FEF', 'extension', 'http://cdn.akeeba.com/updates/fef.xml', 1, 1765375405, '', NULL, NULL),
(34, 'FOF 4.x', 'extension', 'http://cdn.akeeba.com/updates/fof4_file.xml', 1, 1765375405, '', NULL, NULL),
(38, 'COM_PHOCADOWNLOAD', 'extension', 'https://raw.githubusercontent.com/PhocaCz/PhocaDownload/master/manifest.xml', 1, 1765375405, '', NULL, NULL),
(42, 'Plotalot Plugin', 'extension', 'https://www.lesarbresdesign.info/jupdate?product=plg_plotalot', 1, 1765375407, '', NULL, NULL),
(43, 'Plotalot Component', 'extension', 'https://www.lesarbresdesign.info/jupdate?product=plotalot', 1, 1765375409, '', NULL, NULL),
(47, 'Akeeba Backup Professional', 'extension', 'https://cdn.akeeba.com/updates/pkgakeebapro.xml', 1, 1765375409, 'dlid=79a4490310409fac11145249495e19e5', NULL, NULL),
(49, 'Hydrogen Template', 'extension', 'https://updates.gantry.org/5.0/joomla/tpl_g5_hydrogen.xml', 1, 1765375409, '', NULL, NULL),
(58, 'SP Page Builder', 'extension', 'https://www.joomshaper.com/updates/com-sp-page-builder-pro-next.xml', 1, 1765375409, '', NULL, NULL),
(60, 'Smart Slider 3 Updates', 'extension', 'https://api.nextendweb.com/v1/?action=joomla_version&platform=joomla&product=smartslider3&pro=0&channel=stable', 1, 1765375409, '', NULL, NULL),
(61, 'Search Update Site', 'extension', 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml', 1, 1765375410, '', NULL, NULL),
(62, 'Fabrik Base', 'extension', 'https://fabrikar.com/index.php?option=com_ochsubscriptions&view=updater&format=xml&element=fabrikbase', 1, 1765375410, 'key=79a4490310409fac11145249495e19e5', NULL, NULL),
(63, 'Akeeba Backup Professional for Joomla!', 'extension', 'https://cdn.akeeba.com/updates/pkgakeebabackuppro.xml', 1, 1765375410, 'dlid=79a4490310409fac11145249495e19e5', NULL, NULL);

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

--
-- Structure de la table `jgkzw_update_sites_extensions`
--

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

--
-- Déchargement des données de la table `jgkzw_update_sites_extensions`
--

INSERT INTO `jgkzw_update_sites_extensions` (`update_site_id`, `extension_id`) VALUES
(1, 700),
(2, 802),
(2, 803),
(2, 10002),
(2, 10005),
(2, 10008),
(3, 28),
(5, 605),
(6, 10025),
(8, 10026),
(9, 10041),
(10, 10041),
(11, 10043),
(26, 10017),
(29, 10025),
(32, 10117),
(32, 10118),
(34, 10124),
(38, 10130),
(42, 10136),
(43, 10137),
(47, 10024),
(49, 10043),
(58, 10026),
(60, 10048),
(61, 10227),
(62, 10310),
(63, 10315);

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

--
-- Structure de la table `jgkzw_usergroups`
--

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

--
-- Déchargement des données de la table `jgkzw_usergroups`
--

INSERT INTO `jgkzw_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES
(1, 0, 1, 18, 'Public'),
(2, 1, 8, 15, 'Enregistré'),
(3, 2, 9, 14, 'Auteur'),
(4, 3, 10, 13, 'Rédacteur'),
(5, 4, 11, 12, 'Validateur'),
(6, 1, 4, 7, 'Gestionnaire'),
(7, 6, 5, 6, 'Administrateur'),
(8, 1, 16, 17, 'Super Utilisateur'),
(9, 1, 2, 3, 'Invité');

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

--
-- Structure de la table `jgkzw_users`
--

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

--
-- Déchargement des données de la table `jgkzw_users`
--

INSERT INTO `jgkzw_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`, `authProvider`) VALUES
(925, 'Hervé TRON', 'herve', 'h.tron@oieau.fr', '$2y$10$zFGhcgWfpYeyCGxB96tBm.i/YD4mffHSbfhJDUUid1yBiRTnS8rZW', 0, 1, '2019-06-17 13:44:23', '2025-12-11 14:12:37', '0', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, ''),
(926, 'Emanuella NANOVA', 'e.nanova', 'e.nanova@oieau.fr', '$2y$10$pmD1i4aU/0oEbECmC8mSAOA4EqkIxlqdyljvicmCEz5Ts4cmlzMHO', 0, 0, '2019-06-18 07:42:00', '2025-12-08 23:20:16', '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, ''),
(927, 'Marta BOYKO', 'm.boyko', 'm.boyko@oieau.fr', '$2y$10$fQNzvmgLxvSVSa3hX42xBu7DbrpSW1hyYZkiXZPCl8Tn2jIk1jge2', 0, 0, '2019-06-18 07:45:12', '2021-09-23 09:34:58', '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, ''),
(928, 'Paul HAENER', 'p.haener', 'p.haener@oieau.fr', '$2y$10$NaOjPxWFHILTPn.c7VqtSOeceU41W1xtwr2c21c7YDMI0gUypnna.', 0, 0, '2019-06-18 07:46:02', '2021-09-08 13:47:02', '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, ''),
(929, 'DD', 'superDD', 'denis.durand@mediances.fr', '$2y$10$UV2z4HiUBO4EPzojZxwWVet/xni2zZEOKFStSxTWxPDha3NjDgkS6', 1, 0, '2019-06-18 08:47:06', '2019-07-02 07:56:23', '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, ''),
(930, 'Rémi BOYER', 'r.boyer', 'r.boyer@oieau.fr', '$2y$10$TX5rUtcK9mA9jphSidZA/u7brJmaPMk8DACuL7Xt1zTxh/5IjLUYm', 1, 0, '2019-07-03 11:59:40', NULL, '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, ''),
(931, 'enregistré', 'registered', 'registered@oieau.fr', '$2y$10$0JDE5vDL8O9RTySydhgxhO.3NuxuahHLA1HZ7n9ctwJvV.w6TrGN6', 1, 0, '2019-07-03 12:00:27', NULL, '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, ''),
(932, 'Nicolas BRANCO', 'n.branco', 'n.branco@oieau.fr', '$2y$10$pcBaMcwkHmARXh21n/y55uxKDRic2S8drv/C.M/Dahdl.I6P16nSa', 0, 0, '2021-01-12 13:04:57', '2021-07-22 08:15:31', '', '{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"timezone\":\"\"}', NULL, 0, '', '', 0, '');

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

--
-- Structure de la table `jgkzw_user_keys`
--

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

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

--
-- Structure de la table `jgkzw_user_mfa`
--

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

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

--
-- Structure de la table `jgkzw_user_notes`
--

CREATE TABLE `jgkzw_user_notes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `catid` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `subject` varchar(100) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT 0,
  `checked_out` int(10) UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `created_user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_time` datetime NOT NULL,
  `modified_user_id` int(10) 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;

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

--
-- Structure de la table `jgkzw_user_profiles`
--

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

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

--
-- Structure de la table `jgkzw_user_usergroup_map`
--

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

--
-- Déchargement des données de la table `jgkzw_user_usergroup_map`
--

INSERT INTO `jgkzw_user_usergroup_map` (`user_id`, `group_id`) VALUES
(925, 8),
(926, 8),
(927, 7),
(928, 8),
(929, 7),
(930, 7),
(931, 2),
(932, 7);

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

--
-- Structure de la table `jgkzw_viewlevels`
--

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

--
-- Déchargement des données de la table `jgkzw_viewlevels`
--

INSERT INTO `jgkzw_viewlevels` (`id`, `title`, `ordering`, `rules`) VALUES
(1, 'Accès public', 0, '[1]'),
(2, 'Accès enregistré', 2, '[6,2,8]'),
(3, 'Accès spécial', 3, '[6,3,8]'),
(5, 'Accès invité', 1, '[9]'),
(6, 'Accès super utilisateur', 4, '[8]');

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

--
-- Structure de la table `jgkzw_webauthn_credentials`
--

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

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

--
-- Structure de la table `jgkzw_wf_profiles`
--

CREATE TABLE `jgkzw_wf_profiles` (
  `id` int(11) 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(3) NOT NULL,
  `device` varchar(255) NOT NULL,
  `rows` text NOT NULL,
  `plugins` text NOT NULL,
  `published` tinyint(3) NOT NULL,
  `ordering` int(11) NOT NULL,
  `checked_out` int(10) UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `params` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Déchargement des données de la table `jgkzw_wf_profiles`
--

INSERT INTO `jgkzw_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', '', '3,4,5,6,8,7', '', 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,fontcolor,spacer,clipboard,indent,outdent,lists,sub,sup,textcase,charmap,hr;directionality,fullscreen,print,searchreplace,spacer,table,style,xhtmlxtras;visualaid,visualchars,visualblocks,nonbreaking,anchor,unlink,link,imgmanager_ext,mediamanager,filemanager,templatemanager,caption,microdata,textpattern,spellchecker,article', 'formatselect,styleselect,cleanup,fontselect,fontsizeselect,fontcolor,clipboard,lists,textcase,charmap,hr,directionality,fullscreen,print,searchreplace,table,style,xhtmlxtras,visualchars,visualblocks,nonbreaking,anchor,link,imgmanager_ext,mediamanager,filemanager,templatemanager,caption,microdata,textpattern,spellchecker,article,spellchecker,article,browser,contextmenu,inlinepopups,media,preview,source', 1, 1, NULL, NULL, '{\"editor\":{\"toolbar_theme\":\"default\"}}'),
(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,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, '{\"editor\":{\"toolbar_theme\":\"default\"}}'),
(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,styleselect,underline,justifyfull,clipboard,removeformat,charmap,indent,outdent,undo,redo,help', 'link,imgmanager,article,spellchecker,fullscreen,kitchensink,clipboard,contextmenu,inlinepopups,lists,formatselect,styleselect,textpattern', 0, 3, NULL, NULL, '{\"editor\":{\"toolbar_theme\":\"default\"}}'),
(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,textpattern', 0, 4, NULL, NULL, '{\"editor\":{\"toolbar_theme\":\"default.touch\"}}'),
(5, 'Markdown', 'Sample Markdown Profile', '', '6,7,3,4,5,8', '', 0, 'desktop,tablet,phone', 'fullscreen,justifyleft,justifycenter,justifyfull,justifyright,link,unlink,imgmanager,styleselect', 'fullscreen,link,imgmanager,styleselect,inlinepopups,media,textpattern', 0, 5, NULL, NULL, '{\"editor\":{\"toolbar_theme\":\"default\"}}');

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

--
-- Structure de la table `jgkzw_workflows`
--

CREATE TABLE `jgkzw_workflows` (
  `id` int(11) NOT NULL,
  `asset_id` int(11) DEFAULT 0,
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `extension` varchar(50) NOT NULL,
  `default` tinyint(4) NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL DEFAULT 0,
  `checked_out_time` datetime DEFAULT NULL,
  `checked_out` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `jgkzw_workflows`
--

INSERT INTO `jgkzw_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, '2025-12-01 00:16:39', 0, '2025-12-01 00:16:39', 0, NULL, NULL);

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

--
-- Structure de la table `jgkzw_workflow_associations`
--

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

--
-- Déchargement des données de la table `jgkzw_workflow_associations`
--

INSERT INTO `jgkzw_workflow_associations` (`item_id`, `stage_id`, `extension`) VALUES
(1, 1, 'com_content.article'),
(2, 1, 'com_content.article'),
(3, 1, 'com_content.article'),
(4, 1, 'com_content.article'),
(5, 1, 'com_content.article'),
(6, 1, 'com_content.article'),
(7, 1, 'com_content.article'),
(8, 1, 'com_content.article'),
(9, 1, 'com_content.article');

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

--
-- Structure de la table `jgkzw_workflow_stages`
--

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

--
-- Déchargement des données de la table `jgkzw_workflow_stages`
--

INSERT INTO `jgkzw_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);

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

--
-- Structure de la table `jgkzw_workflow_transitions`
--

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

--
-- Déchargement des données de la table `jgkzw_workflow_transitions`
--

INSERT INTO `jgkzw_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);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `jgkzw_action_logs`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_action_logs_extensions`
--
ALTER TABLE `jgkzw_action_logs_extensions`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_action_logs_users`
--
ALTER TABLE `jgkzw_action_logs_users`
  ADD PRIMARY KEY (`user_id`),
  ADD KEY `idx_notify` (`notify`);

--
-- Index pour la table `jgkzw_action_log_config`
--
ALTER TABLE `jgkzw_action_log_config`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_akeebabackup_backups`
--
ALTER TABLE `jgkzw_akeebabackup_backups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_fullstatus` (`filesexist`,`status`),
  ADD KEY `idx_stale` (`status`,`origin`);

--
-- Index pour la table `jgkzw_akeebabackup_profiles`
--
ALTER TABLE `jgkzw_akeebabackup_profiles`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_akeebabackup_storage`
--
ALTER TABLE `jgkzw_akeebabackup_storage`
  ADD PRIMARY KEY (`tag`(100));

--
-- Index pour la table `jgkzw_akeeba_common`
--
ALTER TABLE `jgkzw_akeeba_common`
  ADD PRIMARY KEY (`key`);

--
-- Index pour la table `jgkzw_ak_profiles`
--
ALTER TABLE `jgkzw_ak_profiles`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_ak_stats`
--
ALTER TABLE `jgkzw_ak_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_fullstatus` (`filesexist`,`status`),
  ADD KEY `idx_stale` (`status`,`origin`);

--
-- Index pour la table `jgkzw_ak_storage`
--
ALTER TABLE `jgkzw_ak_storage`
  ADD PRIMARY KEY (`tag`(100));

--
-- Index pour la table `jgkzw_assets`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_associations`
--
ALTER TABLE `jgkzw_associations`
  ADD PRIMARY KEY (`context`,`id`),
  ADD KEY `idx_key` (`key`);

--
-- Index pour la table `jgkzw_banners`
--
ALTER TABLE `jgkzw_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));

--
-- Index pour la table `jgkzw_banner_clients`
--
ALTER TABLE `jgkzw_banner_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_own_prefix` (`own_prefix`),
  ADD KEY `idx_metakey_prefix` (`metakey_prefix`(100));

--
-- Index pour la table `jgkzw_banner_tracks`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_categories`
--
ALTER TABLE `jgkzw_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));

--
-- Index pour la table `jgkzw_contact_details`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_content`
--
ALTER TABLE `jgkzw_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`),
  ADD KEY `idx_createdby` (`created_by`),
  ADD KEY `idx_featured_catid` (`featured`,`catid`),
  ADD KEY `idx_language` (`language`),
  ADD KEY `idx_alias` (`alias`(191));

--
-- Index pour la table `jgkzw_contentitem_tag_map`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_content_frontpage`
--
ALTER TABLE `jgkzw_content_frontpage`
  ADD PRIMARY KEY (`content_id`);

--
-- Index pour la table `jgkzw_content_rating`
--
ALTER TABLE `jgkzw_content_rating`
  ADD PRIMARY KEY (`content_id`);

--
-- Index pour la table `jgkzw_content_types`
--
ALTER TABLE `jgkzw_content_types`
  ADD PRIMARY KEY (`type_id`),
  ADD KEY `idx_alias` (`type_alias`(100));

--
-- Index pour la table `jgkzw_extensions`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_fabrik_connections`
--
ALTER TABLE `jgkzw_fabrik_connections`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_fabrik_cron`
--
ALTER TABLE `jgkzw_fabrik_cron`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_fabrik_elements`
--
ALTER TABLE `jgkzw_fabrik_elements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `show_in_list_summary_INDEX` (`show_in_list_summary`),
  ADD KEY `plugin_INDEX` (`plugin`(10)),
  ADD KEY `checked_out_INDEX` (`checked_out`),
  ADD KEY `group_id_INDEX` (`group_id`),
  ADD KEY `parent_id_INDEX` (`parent_id`);

--
-- Index pour la table `jgkzw_fabrik_formgroup`
--
ALTER TABLE `jgkzw_fabrik_formgroup`
  ADD PRIMARY KEY (`id`),
  ADD KEY `form_id_INDEX` (`form_id`),
  ADD KEY `group_id_INDEX` (`group_id`),
  ADD KEY `ordering_INDEX` (`ordering`);

--
-- Index pour la table `jgkzw_fabrik_forms`
--
ALTER TABLE `jgkzw_fabrik_forms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `published_INDEX` (`published`);

--
-- Index pour la table `jgkzw_fabrik_form_sessions`
--
ALTER TABLE `jgkzw_fabrik_form_sessions`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_fabrik_groups`
--
ALTER TABLE `jgkzw_fabrik_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `published_INDEX` (`published`);

--
-- Index pour la table `jgkzw_fabrik_joins`
--
ALTER TABLE `jgkzw_fabrik_joins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `list_id_INDEX` (`list_id`),
  ADD KEY `element_id_INDEX` (`element_id`),
  ADD KEY `group_id_INDEX` (`group_id`),
  ADD KEY `table_join_INDEX` (`table_join`(10));

--
-- Index pour la table `jgkzw_fabrik_jsactions`
--
ALTER TABLE `jgkzw_fabrik_jsactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `element_id_INDEX` (`element_id`);

--
-- Index pour la table `jgkzw_fabrik_lists`
--
ALTER TABLE `jgkzw_fabrik_lists`
  ADD PRIMARY KEY (`id`),
  ADD KEY `form_id_INDEX` (`form_id`);

--
-- Index pour la table `jgkzw_fabrik_log`
--
ALTER TABLE `jgkzw_fabrik_log`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_fabrik_validations`
--
ALTER TABLE `jgkzw_fabrik_validations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_fabrik_visualizations`
--
ALTER TABLE `jgkzw_fabrik_visualizations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_fields`
--
ALTER TABLE `jgkzw_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_language` (`language`),
  ADD KEY `idx_context` (`context`(191));

--
-- Index pour la table `jgkzw_fields_categories`
--
ALTER TABLE `jgkzw_fields_categories`
  ADD PRIMARY KEY (`field_id`,`category_id`);

--
-- Index pour la table `jgkzw_fields_groups`
--
ALTER TABLE `jgkzw_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_language` (`language`),
  ADD KEY `idx_context` (`context`(191));

--
-- Index pour la table `jgkzw_fields_values`
--
ALTER TABLE `jgkzw_fields_values`
  ADD KEY `idx_field_id` (`field_id`),
  ADD KEY `idx_item_id` (`item_id`(191));

--
-- Index pour la table `jgkzw_finder_filters`
--
ALTER TABLE `jgkzw_finder_filters`
  ADD PRIMARY KEY (`filter_id`);

--
-- Index pour la table `jgkzw_finder_links`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_finder_links_terms`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_finder_logging`
--
ALTER TABLE `jgkzw_finder_logging`
  ADD PRIMARY KEY (`md5sum`),
  ADD KEY `searchterm` (`searchterm`(191));

--
-- Index pour la table `jgkzw_finder_taxonomy`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_finder_taxonomy_map`
--
ALTER TABLE `jgkzw_finder_taxonomy_map`
  ADD PRIMARY KEY (`link_id`,`node_id`),
  ADD KEY `link_id` (`link_id`),
  ADD KEY `node_id` (`node_id`);

--
-- Index pour la table `jgkzw_finder_terms`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_finder_terms_common`
--
ALTER TABLE `jgkzw_finder_terms_common`
  ADD UNIQUE KEY `idx_term_language` (`term`,`language`),
  ADD KEY `idx_lang` (`language`);

--
-- Index pour la table `jgkzw_finder_tokens`
--
ALTER TABLE `jgkzw_finder_tokens`
  ADD KEY `idx_word` (`term`),
  ADD KEY `idx_context` (`context`),
  ADD KEY `idx_stem` (`stem`),
  ADD KEY `idx_language` (`language`);

--
-- Index pour la table `jgkzw_finder_tokens_aggregate`
--
ALTER TABLE `jgkzw_finder_tokens_aggregate`
  ADD KEY `token` (`term`),
  ADD KEY `keyword_id` (`term_id`);

--
-- Index pour la table `jgkzw_finder_types`
--
ALTER TABLE `jgkzw_finder_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `title` (`title`);

--
-- Index pour la table `jgkzw_guidedtours`
--
ALTER TABLE `jgkzw_guidedtours`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_state` (`published`),
  ADD KEY `idx_language` (`language`);

--
-- Index pour la table `jgkzw_guidedtour_steps`
--
ALTER TABLE `jgkzw_guidedtour_steps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_tour` (`tour_id`),
  ADD KEY `idx_state` (`published`),
  ADD KEY `idx_language` (`language`);

--
-- Index pour la table `jgkzw_history`
--
ALTER TABLE `jgkzw_history`
  ADD PRIMARY KEY (`version_id`),
  ADD KEY `idx_ucm_item_id` (`item_id`),
  ADD KEY `idx_save_date` (`save_date`);

--
-- Index pour la table `jgkzw_languages`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_mail_templates`
--
ALTER TABLE `jgkzw_mail_templates`
  ADD PRIMARY KEY (`template_id`,`language`);

--
-- Index pour la table `jgkzw_menu`
--
ALTER TABLE `jgkzw_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));

--
-- Index pour la table `jgkzw_menu_types`
--
ALTER TABLE `jgkzw_menu_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_menutype` (`menutype`);

--
-- Index pour la table `jgkzw_messages`
--
ALTER TABLE `jgkzw_messages`
  ADD PRIMARY KEY (`message_id`),
  ADD KEY `useridto_state` (`user_id_to`,`state`);

--
-- Index pour la table `jgkzw_messages_cfg`
--
ALTER TABLE `jgkzw_messages_cfg`
  ADD UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`);

--
-- Index pour la table `jgkzw_modules`
--
ALTER TABLE `jgkzw_modules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `published` (`published`,`access`),
  ADD KEY `newsfeeds` (`module`,`published`),
  ADD KEY `idx_language` (`language`);

--
-- Index pour la table `jgkzw_modules_menu`
--
ALTER TABLE `jgkzw_modules_menu`
  ADD PRIMARY KEY (`moduleid`,`menuid`);

--
-- Index pour la table `jgkzw_newsfeeds`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_nextend2_image_storage`
--
ALTER TABLE `jgkzw_nextend2_image_storage`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `hash` (`hash`);

--
-- Index pour la table `jgkzw_nextend2_section_storage`
--
ALTER TABLE `jgkzw_nextend2_section_storage`
  ADD PRIMARY KEY (`id`),
  ADD KEY `editable` (`editable`),
  ADD KEY `isSystem` (`isSystem`),
  ADD KEY `application` (`application`,`section`(50),`referencekey`(50)),
  ADD KEY `application_2` (`application`,`section`(50));

--
-- Index pour la table `jgkzw_nextend2_smartslider3_generators`
--
ALTER TABLE `jgkzw_nextend2_smartslider3_generators`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_nextend2_smartslider3_sliders`
--
ALTER TABLE `jgkzw_nextend2_smartslider3_sliders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `time` (`time`),
  ADD KEY `slider_status` (`slider_status`);

--
-- Index pour la table `jgkzw_nextend2_smartslider3_sliders_xref`
--
ALTER TABLE `jgkzw_nextend2_smartslider3_sliders_xref`
  ADD PRIMARY KEY (`group_id`,`slider_id`),
  ADD KEY `ordering` (`ordering`);

--
-- Index pour la table `jgkzw_nextend2_smartslider3_slides`
--
ALTER TABLE `jgkzw_nextend2_smartslider3_slides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `published` (`published`),
  ADD KEY `publish_up` (`publish_up`),
  ADD KEY `publish_down` (`publish_down`),
  ADD KEY `generator_id` (`generator_id`),
  ADD KEY `ordering` (`ordering`),
  ADD KEY `slider` (`slider`),
  ADD KEY `thumbnail` (`thumbnail`(100));

--
-- Index pour la table `jgkzw_overrider`
--
ALTER TABLE `jgkzw_overrider`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload`
--
ALTER TABLE `jgkzw_phocadownload`
  ADD PRIMARY KEY (`id`),
  ADD KEY `catid` (`catid`,`published`);

--
-- Index pour la table `jgkzw_phocadownload_categories`
--
ALTER TABLE `jgkzw_phocadownload_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cat_idx` (`section`,`published`,`access`),
  ADD KEY `idx_access` (`access`),
  ADD KEY `idx_checkout` (`checked_out`);

--
-- Index pour la table `jgkzw_phocadownload_file_votes`
--
ALTER TABLE `jgkzw_phocadownload_file_votes`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload_file_votes_statistics`
--
ALTER TABLE `jgkzw_phocadownload_file_votes_statistics`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload_layout`
--
ALTER TABLE `jgkzw_phocadownload_layout`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload_licenses`
--
ALTER TABLE `jgkzw_phocadownload_licenses`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload_logging`
--
ALTER TABLE `jgkzw_phocadownload_logging`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload_styles`
--
ALTER TABLE `jgkzw_phocadownload_styles`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload_tags`
--
ALTER TABLE `jgkzw_phocadownload_tags`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_phocadownload_tags_ref`
--
ALTER TABLE `jgkzw_phocadownload_tags_ref`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`),
  ADD UNIQUE KEY `i_fileid` (`fileid`,`tagid`);

--
-- Index pour la table `jgkzw_phocadownload_user_stat`
--
ALTER TABLE `jgkzw_phocadownload_user_stat`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_plotalot`
--
ALTER TABLE `jgkzw_plotalot`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_plotalot_categories`
--
ALTER TABLE `jgkzw_plotalot_categories`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_plotalot_databases`
--
ALTER TABLE `jgkzw_plotalot_databases`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_postinstall_messages`
--
ALTER TABLE `jgkzw_postinstall_messages`
  ADD PRIMARY KEY (`postinstall_message_id`);

--
-- Index pour la table `jgkzw_privacy_consents`
--
ALTER TABLE `jgkzw_privacy_consents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- Index pour la table `jgkzw_privacy_requests`
--
ALTER TABLE `jgkzw_privacy_requests`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_redirect_links`
--
ALTER TABLE `jgkzw_redirect_links`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_old_url` (`old_url`(100)),
  ADD KEY `idx_link_modified` (`modified_date`);

--
-- Index pour la table `jgkzw_scheduler_logs`
--
ALTER TABLE `jgkzw_scheduler_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_taskname` (`taskname`),
  ADD KEY `idx_tasktype` (`tasktype`),
  ADD KEY `idx_lastdate` (`lastdate`),
  ADD KEY `idx_nextdate` (`nextdate`);

--
-- Index pour la table `jgkzw_scheduler_tasks`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_schemaorg`
--
ALTER TABLE `jgkzw_schemaorg`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_schemas`
--
ALTER TABLE `jgkzw_schemas`
  ADD PRIMARY KEY (`extension_id`,`version_id`);

--
-- Index pour la table `jgkzw_session`
--
ALTER TABLE `jgkzw_session`
  ADD PRIMARY KEY (`session_id`),
  ADD KEY `userid` (`userid`),
  ADD KEY `time` (`time`),
  ADD KEY `client_id_guest` (`client_id`,`guest`);

--
-- Index pour la table `jgkzw_spmedia`
--
ALTER TABLE `jgkzw_spmedia`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder`
--
ALTER TABLE `jgkzw_sppagebuilder`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_addonlist`
--
ALTER TABLE `jgkzw_sppagebuilder_addonlist`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_addons`
--
ALTER TABLE `jgkzw_sppagebuilder_addons`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_assets`
--
ALTER TABLE `jgkzw_sppagebuilder_assets`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_collections`
--
ALTER TABLE `jgkzw_sppagebuilder_collections`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_collection_fields`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_collection_id` (`collection_id`);

--
-- Index pour la table `jgkzw_sppagebuilder_collection_imports`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_imports`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_collection_items`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_collection_id` (`collection_id`);

--
-- Index pour la table `jgkzw_sppagebuilder_collection_item_values`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_item_values`
  ADD KEY `item_id` (`item_id`),
  ADD KEY `field_id` (`field_id`),
  ADD KEY `reference_item_id` (`reference_item_id`);

--
-- Index pour la table `jgkzw_sppagebuilder_colors`
--
ALTER TABLE `jgkzw_sppagebuilder_colors`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_comments`
--
ALTER TABLE `jgkzw_sppagebuilder_comments`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_fonts`
--
ALTER TABLE `jgkzw_sppagebuilder_fonts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `family_name` (`family_name`,`type`);

--
-- Index pour la table `jgkzw_sppagebuilder_image_shapes`
--
ALTER TABLE `jgkzw_sppagebuilder_image_shapes`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_integrations`
--
ALTER TABLE `jgkzw_sppagebuilder_integrations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_languages`
--
ALTER TABLE `jgkzw_sppagebuilder_languages`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_likes`
--
ALTER TABLE `jgkzw_sppagebuilder_likes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_comment_id` (`comment_id`);

--
-- Index pour la table `jgkzw_sppagebuilder_presets`
--
ALTER TABLE `jgkzw_sppagebuilder_presets`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_sections`
--
ALTER TABLE `jgkzw_sppagebuilder_sections`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_sppagebuilder_typography`
--
ALTER TABLE `jgkzw_sppagebuilder_typography`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_tabulizer_user_permissions`
--
ALTER TABLE `jgkzw_tabulizer_user_permissions`
  ADD PRIMARY KEY (`action`);

--
-- Index pour la table `jgkzw_tags`
--
ALTER TABLE `jgkzw_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));

--
-- Index pour la table `jgkzw_template_overrides`
--
ALTER TABLE `jgkzw_template_overrides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_template` (`template`),
  ADD KEY `idx_extension_id` (`extension_id`);

--
-- Index pour la table `jgkzw_template_styles`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_tuf_metadata`
--
ALTER TABLE `jgkzw_tuf_metadata`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_ucm_base`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_ucm_content`
--
ALTER TABLE `jgkzw_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));

--
-- Index pour la table `jgkzw_updates`
--
ALTER TABLE `jgkzw_updates`
  ADD PRIMARY KEY (`update_id`);

--
-- Index pour la table `jgkzw_update_sites`
--
ALTER TABLE `jgkzw_update_sites`
  ADD PRIMARY KEY (`update_site_id`);

--
-- Index pour la table `jgkzw_update_sites_extensions`
--
ALTER TABLE `jgkzw_update_sites_extensions`
  ADD PRIMARY KEY (`update_site_id`,`extension_id`);

--
-- Index pour la table `jgkzw_usergroups`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_users`
--
ALTER TABLE `jgkzw_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));

--
-- Index pour la table `jgkzw_user_keys`
--
ALTER TABLE `jgkzw_user_keys`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `series` (`series`),
  ADD KEY `user_id` (`user_id`);

--
-- Index pour la table `jgkzw_user_mfa`
--
ALTER TABLE `jgkzw_user_mfa`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`);

--
-- Index pour la table `jgkzw_user_notes`
--
ALTER TABLE `jgkzw_user_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_category_id` (`catid`);

--
-- Index pour la table `jgkzw_user_profiles`
--
ALTER TABLE `jgkzw_user_profiles`
  ADD UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`);

--
-- Index pour la table `jgkzw_user_usergroup_map`
--
ALTER TABLE `jgkzw_user_usergroup_map`
  ADD PRIMARY KEY (`user_id`,`group_id`);

--
-- Index pour la table `jgkzw_viewlevels`
--
ALTER TABLE `jgkzw_viewlevels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_assetgroup_title_lookup` (`title`);

--
-- Index pour la table `jgkzw_webauthn_credentials`
--
ALTER TABLE `jgkzw_webauthn_credentials`
  ADD PRIMARY KEY (`id`(100)),
  ADD KEY `user_id` (`user_id`(60));

--
-- Index pour la table `jgkzw_wf_profiles`
--
ALTER TABLE `jgkzw_wf_profiles`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `jgkzw_workflows`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_workflow_associations`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_workflow_stages`
--
ALTER TABLE `jgkzw_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`);

--
-- Index pour la table `jgkzw_workflow_transitions`
--
ALTER TABLE `jgkzw_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 pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `jgkzw_action_logs`
--
ALTER TABLE `jgkzw_action_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3366;

--
-- AUTO_INCREMENT pour la table `jgkzw_action_logs_extensions`
--
ALTER TABLE `jgkzw_action_logs_extensions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT pour la table `jgkzw_action_log_config`
--
ALTER TABLE `jgkzw_action_log_config`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT pour la table `jgkzw_akeebabackup_backups`
--
ALTER TABLE `jgkzw_akeebabackup_backups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `jgkzw_akeebabackup_profiles`
--
ALTER TABLE `jgkzw_akeebabackup_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_ak_profiles`
--
ALTER TABLE `jgkzw_ak_profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_ak_stats`
--
ALTER TABLE `jgkzw_ak_stats`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT pour la table `jgkzw_assets`
--
ALTER TABLE `jgkzw_assets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', AUTO_INCREMENT=190;

--
-- AUTO_INCREMENT pour la table `jgkzw_banners`
--
ALTER TABLE `jgkzw_banners`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_banner_clients`
--
ALTER TABLE `jgkzw_banner_clients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_categories`
--
ALTER TABLE `jgkzw_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT pour la table `jgkzw_contact_details`
--
ALTER TABLE `jgkzw_contact_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_content`
--
ALTER TABLE `jgkzw_content`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `jgkzw_content_types`
--
ALTER TABLE `jgkzw_content_types`
  MODIFY `type_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT pour la table `jgkzw_extensions`
--
ALTER TABLE `jgkzw_extensions`
  MODIFY `extension_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10322;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_connections`
--
ALTER TABLE `jgkzw_fabrik_connections`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_cron`
--
ALTER TABLE `jgkzw_fabrik_cron`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_elements`
--
ALTER TABLE `jgkzw_fabrik_elements`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_formgroup`
--
ALTER TABLE `jgkzw_fabrik_formgroup`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_forms`
--
ALTER TABLE `jgkzw_fabrik_forms`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_form_sessions`
--
ALTER TABLE `jgkzw_fabrik_form_sessions`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_groups`
--
ALTER TABLE `jgkzw_fabrik_groups`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_joins`
--
ALTER TABLE `jgkzw_fabrik_joins`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_jsactions`
--
ALTER TABLE `jgkzw_fabrik_jsactions`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_lists`
--
ALTER TABLE `jgkzw_fabrik_lists`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_log`
--
ALTER TABLE `jgkzw_fabrik_log`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_validations`
--
ALTER TABLE `jgkzw_fabrik_validations`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_fabrik_visualizations`
--
ALTER TABLE `jgkzw_fabrik_visualizations`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_fields`
--
ALTER TABLE `jgkzw_fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_fields_groups`
--
ALTER TABLE `jgkzw_fields_groups`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_finder_filters`
--
ALTER TABLE `jgkzw_finder_filters`
  MODIFY `filter_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_finder_links`
--
ALTER TABLE `jgkzw_finder_links`
  MODIFY `link_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_finder_taxonomy`
--
ALTER TABLE `jgkzw_finder_taxonomy`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_finder_terms`
--
ALTER TABLE `jgkzw_finder_terms`
  MODIFY `term_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_finder_types`
--
ALTER TABLE `jgkzw_finder_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_guidedtours`
--
ALTER TABLE `jgkzw_guidedtours`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT pour la table `jgkzw_guidedtour_steps`
--
ALTER TABLE `jgkzw_guidedtour_steps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;

--
-- AUTO_INCREMENT pour la table `jgkzw_history`
--
ALTER TABLE `jgkzw_history`
  MODIFY `version_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT pour la table `jgkzw_languages`
--
ALTER TABLE `jgkzw_languages`
  MODIFY `lang_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `jgkzw_menu`
--
ALTER TABLE `jgkzw_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=648;

--
-- AUTO_INCREMENT pour la table `jgkzw_menu_types`
--
ALTER TABLE `jgkzw_menu_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `jgkzw_messages`
--
ALTER TABLE `jgkzw_messages`
  MODIFY `message_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_modules`
--
ALTER TABLE `jgkzw_modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=172;

--
-- AUTO_INCREMENT pour la table `jgkzw_newsfeeds`
--
ALTER TABLE `jgkzw_newsfeeds`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_nextend2_image_storage`
--
ALTER TABLE `jgkzw_nextend2_image_storage`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT pour la table `jgkzw_nextend2_section_storage`
--
ALTER TABLE `jgkzw_nextend2_section_storage`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10386;

--
-- AUTO_INCREMENT pour la table `jgkzw_nextend2_smartslider3_generators`
--
ALTER TABLE `jgkzw_nextend2_smartslider3_generators`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_nextend2_smartslider3_sliders`
--
ALTER TABLE `jgkzw_nextend2_smartslider3_sliders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `jgkzw_nextend2_smartslider3_slides`
--
ALTER TABLE `jgkzw_nextend2_smartslider3_slides`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT pour la table `jgkzw_overrider`
--
ALTER TABLE `jgkzw_overrider`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key';

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload`
--
ALTER TABLE `jgkzw_phocadownload`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_categories`
--
ALTER TABLE `jgkzw_phocadownload_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_file_votes`
--
ALTER TABLE `jgkzw_phocadownload_file_votes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_file_votes_statistics`
--
ALTER TABLE `jgkzw_phocadownload_file_votes_statistics`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_layout`
--
ALTER TABLE `jgkzw_phocadownload_layout`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_licenses`
--
ALTER TABLE `jgkzw_phocadownload_licenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_logging`
--
ALTER TABLE `jgkzw_phocadownload_logging`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_styles`
--
ALTER TABLE `jgkzw_phocadownload_styles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_tags`
--
ALTER TABLE `jgkzw_phocadownload_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_tags_ref`
--
ALTER TABLE `jgkzw_phocadownload_tags_ref`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_phocadownload_user_stat`
--
ALTER TABLE `jgkzw_phocadownload_user_stat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_plotalot`
--
ALTER TABLE `jgkzw_plotalot`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT pour la table `jgkzw_plotalot_categories`
--
ALTER TABLE `jgkzw_plotalot_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `jgkzw_plotalot_databases`
--
ALTER TABLE `jgkzw_plotalot_databases`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `jgkzw_postinstall_messages`
--
ALTER TABLE `jgkzw_postinstall_messages`
  MODIFY `postinstall_message_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT pour la table `jgkzw_privacy_consents`
--
ALTER TABLE `jgkzw_privacy_consents`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_privacy_requests`
--
ALTER TABLE `jgkzw_privacy_requests`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_redirect_links`
--
ALTER TABLE `jgkzw_redirect_links`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_scheduler_logs`
--
ALTER TABLE `jgkzw_scheduler_logs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_scheduler_tasks`
--
ALTER TABLE `jgkzw_scheduler_tasks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_schemaorg`
--
ALTER TABLE `jgkzw_schemaorg`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_spmedia`
--
ALTER TABLE `jgkzw_spmedia`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder`
--
ALTER TABLE `jgkzw_sppagebuilder`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_addonlist`
--
ALTER TABLE `jgkzw_sppagebuilder_addonlist`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_addons`
--
ALTER TABLE `jgkzw_sppagebuilder_addons`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_assets`
--
ALTER TABLE `jgkzw_sppagebuilder_assets`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_collections`
--
ALTER TABLE `jgkzw_sppagebuilder_collections`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_collection_fields`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_fields`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_collection_imports`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_imports`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_collection_items`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_colors`
--
ALTER TABLE `jgkzw_sppagebuilder_colors`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_comments`
--
ALTER TABLE `jgkzw_sppagebuilder_comments`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_fonts`
--
ALTER TABLE `jgkzw_sppagebuilder_fonts`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_image_shapes`
--
ALTER TABLE `jgkzw_sppagebuilder_image_shapes`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_integrations`
--
ALTER TABLE `jgkzw_sppagebuilder_integrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_languages`
--
ALTER TABLE `jgkzw_sppagebuilder_languages`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_likes`
--
ALTER TABLE `jgkzw_sppagebuilder_likes`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_presets`
--
ALTER TABLE `jgkzw_sppagebuilder_presets`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_sections`
--
ALTER TABLE `jgkzw_sppagebuilder_sections`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_sppagebuilder_typography`
--
ALTER TABLE `jgkzw_sppagebuilder_typography`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_tags`
--
ALTER TABLE `jgkzw_tags`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_template_overrides`
--
ALTER TABLE `jgkzw_template_overrides`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_template_styles`
--
ALTER TABLE `jgkzw_template_styles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT pour la table `jgkzw_tuf_metadata`
--
ALTER TABLE `jgkzw_tuf_metadata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_ucm_content`
--
ALTER TABLE `jgkzw_ucm_content`
  MODIFY `core_content_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_updates`
--
ALTER TABLE `jgkzw_updates`
  MODIFY `update_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT pour la table `jgkzw_update_sites`
--
ALTER TABLE `jgkzw_update_sites`
  MODIFY `update_site_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT pour la table `jgkzw_usergroups`
--
ALTER TABLE `jgkzw_usergroups`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT pour la table `jgkzw_users`
--
ALTER TABLE `jgkzw_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=933;

--
-- AUTO_INCREMENT pour la table `jgkzw_user_keys`
--
ALTER TABLE `jgkzw_user_keys`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_user_mfa`
--
ALTER TABLE `jgkzw_user_mfa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_user_notes`
--
ALTER TABLE `jgkzw_user_notes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jgkzw_viewlevels`
--
ALTER TABLE `jgkzw_viewlevels`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `jgkzw_wf_profiles`
--
ALTER TABLE `jgkzw_wf_profiles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `jgkzw_workflows`
--
ALTER TABLE `jgkzw_workflows`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_workflow_stages`
--
ALTER TABLE `jgkzw_workflow_stages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `jgkzw_workflow_transitions`
--
ALTER TABLE `jgkzw_workflow_transitions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `jgkzw_sppagebuilder_collection_fields`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_fields`
  ADD CONSTRAINT `jgkzw_sppagebuilder_collection_fields_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `jgkzw_sppagebuilder_collections` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `jgkzw_sppagebuilder_collection_items`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_items`
  ADD CONSTRAINT `jgkzw_sppagebuilder_collection_items_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `jgkzw_sppagebuilder_collections` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `jgkzw_sppagebuilder_collection_item_values`
--
ALTER TABLE `jgkzw_sppagebuilder_collection_item_values`
  ADD CONSTRAINT `jgkzw_sppagebuilder_collection_item_values_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `jgkzw_sppagebuilder_collection_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jgkzw_sppagebuilder_collection_item_values_ibfk_2` FOREIGN KEY (`field_id`) REFERENCES `jgkzw_sppagebuilder_collection_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jgkzw_sppagebuilder_collection_item_values_ibfk_3` FOREIGN KEY (`reference_item_id`) REFERENCES `jgkzw_sppagebuilder_collection_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `jgkzw_sppagebuilder_likes`
--
ALTER TABLE `jgkzw_sppagebuilder_likes`
  ADD CONSTRAINT `jgkzw_sppagebuilder_likes_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `jgkzw_sppagebuilder_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

