Joomla! Issue Tracker | Joomla! CMS #32174 - [4.0.0-beta 6] Column 'checked

Closed
28 Jan 2021
Medium
Build: staging
# 32174

Bond97
26 Jan 2021

Steps to reproduce the issue

I have created new article with no content.

When article open, it will be in "checked-in" state in Joomla database.

I didn't do any changes in article and try to close it by clicking on button "close".

Expected result

Article will be closed and update to state "checked-out" in Joomla database.

Actual result

Article will be closed and showing error.

System information (as much as possible)

PHP 7.4.0, mysql database version 5.7.21.

Additional comments

I can update article state only in system settings->global check-in. In component "articles" it can't to be update article state to "checked-out" (lock icon hasn't disappeared).

Bond97 - open - 26 Jan 2021

joomla-cms-bot - change - 26 Jan 2021

Labels

Added: ?

joomla-cms-bot - labeled - 26 Jan 2021

wilsonge - comment - 26 Jan 2021

The value in the database should be nullable (and it's intended behaviour to set it to null). I'm not quite sure why your database is in a bad state. But I guess if you go to the installer it will suggest there are database fixes to be made which should fix this

HLeithner - change - 28 Jan 2021

Status	New	⇒	Closed
Closed_Date	0000-00-00 00:00:00	⇒	2021-01-28 11:05:05
Closed_By		⇒	HLeithner

HLeithner - close - 28 Jan 2021

HLeithner - comment - 28 Jan 2021

@Bond97 please go to administrator/index.php?option=com_installer&view=database and check if you have database problems and if so plz press the fix button

I'm closing this but can be reopened if needed.

k1ll3r8e - comment - 26 Aug 2021

@HLeithner hey there, I have the exact same issue after an update from 3.9.20 to 3.10.x to 4.0.2. All structures like: _banners, _categories, _content, _menu and _modules have "checked_out" set to "NotNull" and "0" by default. The database fixer doesn't show any errors and so it doesn't fix anything when you hit the "fix" button. There are also some other things like for example the length of some fields have changed from 3.9.20 to 4.0.2 but the changes are not migrated during the update. (There are also no errors shown when you check the database fixer.)

HLeithner - comment - 26 Aug 2021

can you post an sql dump (only structure) please?

k1ll3r8e - comment - 26 Aug 2021

I wish I could, but I have already manually fixed the structures on my first site... But(!) I still have another site which I update tomorrow. (There should the same issue occur, both had the same base configuration.) So I hope that I'm able to post one tomorrow.

HLeithner - comment - 26 Aug 2021

I wish I could, but I have already manually fixed the structures on my first site... But(!) I still have another site which I update tomorrow. (There should the same issue occur, both had the same base configuration.) So I hope that I'm able to post one tomorrow.

ok thanks, please report back even if the structure is ok

k1ll3r8e - comment - 27 Aug 2021

I wish I could, but I have already manually fixed the structures on my first site... But(!) I still have another site which I update tomorrow. (There should the same issue occur, both had the same base configuration.) So I hope that I'm able to post one tomorrow.

ok thanks, please report back even if the structure is ok

Heyho, here is the sql dump (only structure) after the update to 4.0.2. There are many diffs and also some structure field-order errors. Like for example _extensions, there is "locked" the last field but it should be after "protected". Also the "xreference" field is not removed from some structures. Another wrong ordered field is "only_use_in_subform" from -fields which is at the end and should be after "required". Seems there are lots of minor field bugs which ends in some trouble for some users.

DROP TABLE IF EXISTS #__action_log_config; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE #__action_log_config(idint(10) unsigned NOT NULL AUTO_INCREMENT,type_titlevarchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',type_aliasvarchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',id_holdervarchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,title_holdervarchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,table_namevarchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,text_prefix varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__action_logs;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__action_logs (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
message_language_key varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
message text COLLATE utf8mb4_unicode_ci NOT NULL,
log_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
extension varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
user_id int(11) NOT NULL DEFAULT 0,
item_id int(11) NOT NULL DEFAULT 0,
ip_address varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0.0.0.0',
PRIMARY KEY (id),
KEY idx_user_id (user_id),
KEY idx_user_id_logdate (user_id,log_date),
KEY idx_user_id_extension (user_id,extension),
KEY idx_extension_item_id (extension,item_id)
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__action_logs_extensions;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__action_logs_extensions (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
extension varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__action_logs_users;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__action_logs_users (
user_id int(11) unsigned NOT NULL,
notify tinyint(1) unsigned NOT NULL,
extensions text COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (user_id),
KEY idx_notify (notify)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__assets;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__assets (
id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
parent_id int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set parent.',
lft int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
rgt int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
level int(10) unsigned NOT NULL COMMENT 'The cached level in the nested tree.',
name varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The unique name for the asset.\n',
title varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The descriptive title for the asset.',
rules varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY (id),
UNIQUE KEY idx_asset_name (name),
KEY idx_lft_rgt (lft,rgt),
KEY idx_parent_id (parent_id)
) ENGINE=InnoDB AUTO_INCREMENT=294 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__associations;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__associations (
id int(11) NOT NULL COMMENT 'A reference to the associated item.',
context varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The context of the associated item.',
key char(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
PRIMARY KEY (context,id),
KEY idx_key (key)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__banner_clients;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__banner_clients (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
contact varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
email varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
extrainfo mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
state tinyint(3) NOT NULL DEFAULT 0,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
metakey mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
own_prefix tinyint(4) NOT NULL DEFAULT 0,
metakey_prefix varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
purchase_type tinyint(4) NOT NULL DEFAULT -1,
track_clicks tinyint(4) NOT NULL DEFAULT -1,
track_impressions tinyint(4) NOT NULL DEFAULT -1,
PRIMARY KEY (id),
KEY idx_own_prefix (own_prefix),
KEY idx_metakey_prefix (metakey_prefix(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__banner_tracks;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__banner_tracks (
track_date datetime NOT NULL,
track_type int(10) unsigned NOT NULL,
banner_id int(10) unsigned NOT NULL,
count int(10) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (track_date,track_type,banner_id),
KEY idx_track_date (track_date),
KEY idx_track_type (track_type),
KEY idx_banner_id (banner_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__banners;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__banners (
id int(11) NOT NULL AUTO_INCREMENT,
cid int(11) NOT NULL DEFAULT 0,
type int(11) NOT NULL DEFAULT 0,
name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
imptotal int(11) NOT NULL DEFAULT 0,
impmade int(11) NOT NULL DEFAULT 0,
clicks int(11) NOT NULL DEFAULT 0,
clickurl varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
state tinyint(3) NOT NULL DEFAULT 0,
catid int(10) unsigned NOT NULL DEFAULT 0,
description mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
custombannercode varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
sticky tinyint(1) unsigned NOT NULL DEFAULT 0,
ordering int(11) NOT NULL DEFAULT 0,
metakey mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
own_prefix tinyint(1) NOT NULL DEFAULT 0,
metakey_prefix varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
purchase_type tinyint(4) NOT NULL DEFAULT -1,
track_clicks tinyint(4) NOT NULL DEFAULT -1,
track_impressions tinyint(4) NOT NULL DEFAULT -1,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
reset datetime DEFAULT NULL,
created datetime NOT NULL,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
created_by int(10) unsigned NOT NULL DEFAULT 0,
created_by_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
modified datetime NOT NULL,
modified_by int(10) unsigned NOT NULL DEFAULT 0,
version int(10) unsigned NOT NULL DEFAULT 1,
PRIMARY KEY (id),
KEY idx_state (state),
KEY idx_own_prefix (own_prefix),
KEY idx_banner_catid (catid),
KEY idx_language (language),
KEY idx_metakey_prefix (metakey_prefix(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__categories;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__categories (
id int(11) NOT NULL AUTO_INCREMENT,
asset_id int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
extension varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
description mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
published tinyint(1) NOT NULL DEFAULT 0,
checked_out int(11) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
access int(10) unsigned NOT NULL DEFAULT 0,
params text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
metadesc varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'The meta description for the page.',
metakey varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'The meta keywords for the page.',
metadata varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.',
created_user_id int(10) unsigned NOT NULL DEFAULT 0,
created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
modified_user_id int(10) unsigned NOT NULL DEFAULT 0,
modified_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
hits int(10) unsigned NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
version int(10) unsigned NOT NULL DEFAULT 1,
PRIMARY KEY (id),
KEY cat_idx (extension,published,access),
KEY idx_access (access),
KEY idx_checkout (checked_out),
KEY idx_left_right (lft,rgt),
KEY idx_language (language),
KEY idx_path (path(100)),
KEY idx_alias (alias(100))
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__contact_details;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__contact_details (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
con_position varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
address mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
suburb varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
state varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
country varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
postcode varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
telephone varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
fax varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
misc longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
image varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
email_to varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
default_con tinyint(1) unsigned NOT NULL DEFAULT 0,
published tinyint(1) NOT NULL DEFAULT 0,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
ordering int(11) NOT NULL DEFAULT 0,
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
user_id int(11) NOT NULL DEFAULT 0,
catid int(11) NOT NULL DEFAULT 0,
access int(10) unsigned NOT NULL DEFAULT 0,
mobile varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
webpage varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
sortname1 varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
sortname2 varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
sortname3 varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
language varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL,
created datetime NOT NULL,
created_by int(10) unsigned NOT NULL DEFAULT 0,
created_by_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
modified datetime NOT NULL,
modified_by int(10) unsigned NOT NULL DEFAULT 0,
metakey mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadesc mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadata mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
featured tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
version int(10) unsigned NOT NULL DEFAULT 1,
hits int(10) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (id),
KEY idx_access (access),
KEY idx_checkout (checked_out),
KEY idx_state (published),
KEY idx_catid (catid),
KEY idx_createdby (created_by),
KEY idx_featured_catid (featured,catid),
KEY idx_language (language)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__content;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__content (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
asset_id int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
introtext longtext COLLATE utf8mb4_unicode_ci NOT NULL,
fulltext longtext COLLATE utf8mb4_unicode_ci NOT NULL,
state tinyint(3) NOT NULL DEFAULT 0,
catid int(10) unsigned NOT NULL DEFAULT 0,
created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
created_by int(10) unsigned NOT NULL DEFAULT 0,
created_by_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
modified_by int(10) unsigned NOT NULL DEFAULT 0,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
images mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
urls mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
attribs varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL,
version int(10) unsigned NOT NULL DEFAULT 1,
ordering int(11) NOT NULL DEFAULT 0,
metakey mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadesc mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
access int(10) unsigned NOT NULL DEFAULT 0,
hits int(10) unsigned NOT NULL DEFAULT 0,
metadata mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
featured tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The language code for the article.',
note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (id),
KEY idx_access (access),
KEY idx_checkout (checked_out),
KEY idx_state (state),
KEY idx_catid (catid),
KEY idx_createdby (created_by),
KEY idx_featured_catid (featured,catid),
KEY idx_language (language),
KEY idx_alias (alias(191))
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=0;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__content_frontpage;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__content_frontpage (
content_id int(11) NOT NULL DEFAULT 0,
ordering int(11) NOT NULL DEFAULT 0,
featured_up datetime DEFAULT NULL,
featured_down datetime DEFAULT NULL,
PRIMARY KEY (content_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__content_rating;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__content_rating (
content_id int(11) NOT NULL DEFAULT 0,
rating_sum int(10) unsigned NOT NULL DEFAULT 0,
rating_count int(10) unsigned NOT NULL DEFAULT 0,
lastip varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (content_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__content_types;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__content_types (
type_id int(10) unsigned NOT NULL AUTO_INCREMENT,
type_title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
type_alias varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
table varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
rules mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
field_mappings mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
router varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
content_history_options varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON string for com_contenthistory options',
PRIMARY KEY (type_id),
KEY idx_alias (type_alias(100))
) ENGINE=InnoDB AUTO_INCREMENT=10007 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__contentitem_tag_map;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__contentitem_tag_map (
type_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
core_content_id int(10) unsigned NOT NULL COMMENT 'PK from the core content table',
content_item_id int(11) NOT NULL COMMENT 'PK from the content type table',
tag_id int(10) unsigned NOT NULL COMMENT 'PK from the tag table',
tag_date timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Date of most recent save for this tag-item',
type_id mediumint(8) NOT NULL COMMENT 'PK from the content_type table',
UNIQUE KEY uc_ItemnameTagid (type_id,content_item_id,tag_id),
KEY idx_tag_type (tag_id,type_id),
KEY idx_date_id (tag_date,tag_id),
KEY idx_core_content_id (core_content_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Maps items from content tables to tags';
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__core_log_searches;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__core_log_searches (
search_term varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
hits int(10) unsigned NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__extensions;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__extensions (
extension_id int(11) NOT NULL AUTO_INCREMENT,
package_id int(11) NOT NULL DEFAULT 0 COMMENT 'Parent package ID for extensions installed as a package.',
name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
type varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
element varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
changelogurl text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
folder varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
client_id tinyint(3) NOT NULL,
enabled tinyint(3) NOT NULL DEFAULT 0,
access int(10) unsigned NOT NULL DEFAULT 1,
protected tinyint(3) NOT NULL DEFAULT 0,
manifest_cache mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
custom_data mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
ordering int(11) DEFAULT 0,
state int(11) DEFAULT 0,
note varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
locked tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Flag to indicate if the extension is locked. Locked extensions cannot be uninstalled.',
PRIMARY KEY (extension_id),
KEY element_clientid (element,client_id),
KEY element_folder_clientid (element,folder,client_id),
KEY extension (type,element,folder,client_id)
) ENGINE=InnoDB AUTO_INCREMENT=10073 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__fields;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__fields (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
asset_id int(10) unsigned NOT NULL DEFAULT 0,
context varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
group_id int(10) unsigned NOT NULL DEFAULT 0,
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
label varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
default_value text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
type varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text',
note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
description text COLLATE utf8mb4_unicode_ci NOT NULL,
state tinyint(1) NOT NULL DEFAULT 0,
required tinyint(1) NOT NULL DEFAULT 0,
checked_out int(10) unsigned DEFAULT NULL,
checked_out_time datetime DEFAULT NULL,
ordering int(11) NOT NULL DEFAULT 0,
params text COLLATE utf8mb4_unicode_ci NOT NULL,
fieldparams text COLLATE utf8mb4_unicode_ci NOT NULL,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
created_user_id int(10) unsigned NOT NULL DEFAULT 0,
modified_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
modified_by int(10) unsigned NOT NULL DEFAULT 0,
access int(11) NOT NULL DEFAULT 1,
only_use_in_subform tinyint(4) NOT NULL DEFAULT 0,
PRIMARY KEY (id),
KEY idx_checkout (checked_out),
KEY idx_state (state),
KEY idx_created_user_id (created_user_id),
KEY idx_access (access),
KEY idx_context (context(191)),
KEY idx_language (language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__fields_categories;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__fields_categories (
field_id int(11) NOT NULL DEFAULT 0,
category_id int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (field_id,category_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__fields_groups;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__fields_groups (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
asset_id int(10) unsigned NOT NULL DEFAULT 0,
context varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
description text COLLATE utf8mb4_unicode_ci NOT NULL,
state tinyint(1) NOT NULL DEFAULT 0,
checked_out int(10) unsigned DEFAULT NULL,
checked_out_time datetime DEFAULT NULL,
ordering int(11) NOT NULL DEFAULT 0,
params text COLLATE utf8mb4_unicode_ci NOT NULL,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
created_by int(10) unsigned NOT NULL DEFAULT 0,
modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
modified_by int(10) unsigned NOT NULL DEFAULT 0,
access int(11) NOT NULL DEFAULT 1,
PRIMARY KEY (id),
KEY idx_checkout (checked_out),
KEY idx_state (state),
KEY idx_created_by (created_by),
KEY idx_access (access),
KEY idx_context (context(191)),
KEY idx_language (language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__fields_values;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__fields_values (
field_id int(10) unsigned NOT NULL,
item_id varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Allow references to items which have strings as ids, eg. none db systems.',
value text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
KEY idx_field_id (field_id),
KEY idx_item_id (item_id(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_filters;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_filters (
filter_id int(10) unsigned NOT NULL AUTO_INCREMENT,
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
state tinyint(1) NOT NULL DEFAULT 1,
created datetime NOT NULL,
created_by int(10) unsigned NOT NULL DEFAULT 0,
created_by_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
modified datetime NOT NULL,
modified_by int(10) unsigned NOT NULL DEFAULT 0,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
map_count int(10) unsigned NOT NULL DEFAULT 0,
data mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
params longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (filter_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_links;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_links (
link_id int(10) unsigned NOT NULL AUTO_INCREMENT,
url varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
route varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
title varchar(400) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
description text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
indexdate datetime NOT NULL,
md5sum varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
published tinyint(1) NOT NULL DEFAULT 1,
state int(11) NOT NULL DEFAULT 1,
access int(11) NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
publish_start_date datetime DEFAULT NULL,
publish_end_date datetime DEFAULT NULL,
start_date datetime DEFAULT NULL,
end_date datetime DEFAULT NULL,
list_price double unsigned NOT NULL DEFAULT 0,
sale_price double unsigned NOT NULL DEFAULT 0,
type_id int(11) NOT NULL,
object mediumblob NOT NULL,
PRIMARY KEY (link_id),
KEY idx_type (type_id),
KEY idx_md5 (md5sum),
KEY idx_url (url(75)),
KEY idx_published_list (published,state,access,publish_start_date,publish_end_date,list_price),
KEY idx_published_sale (published,state,access,publish_start_date,publish_end_date,sale_price),
KEY idx_title (title(100)),
KEY idx_language (language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_links_terms;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_links_terms (
link_id int(10) unsigned NOT NULL,
term_id int(10) unsigned NOT NULL,
weight float unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (link_id,term_id),
KEY idx_term_weight (term_id,weight),
KEY idx_link_term_weight (link_id,term_id,weight)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_logging;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_logging (
searchterm varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
md5sum varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
query blob NOT NULL,
hits int(11) NOT NULL DEFAULT 1,
results int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (md5sum),
KEY searchterm (searchterm(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_taxonomy;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_taxonomy (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
alias varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
state tinyint(3) unsigned NOT NULL DEFAULT 1,
access tinyint(3) unsigned NOT NULL DEFAULT 1,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (id),
KEY idx_state (state),
KEY idx_access (access),
KEY idx_path (path(100)),
KEY idx_left_right (lft,rgt),
KEY idx_alias (alias(100)),
KEY idx_language (language),
KEY idx_parent_published (parent_id,state,access),
KEY idx_level (level)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_taxonomy_map;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_taxonomy_map (
link_id int(10) unsigned NOT NULL,
node_id int(10) unsigned NOT NULL,
PRIMARY KEY (link_id,node_id),
KEY link_id (link_id),
KEY node_id (node_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_terms;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_terms (
term_id int(10) unsigned NOT NULL AUTO_INCREMENT,
term varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
stem varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
common tinyint(1) unsigned NOT NULL DEFAULT 0,
phrase tinyint(1) unsigned NOT NULL DEFAULT 0,
weight float unsigned NOT NULL DEFAULT 0,
soundex varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
links int(10) NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (term_id),
UNIQUE KEY idx_term_language (term,language),
KEY idx_term_phrase (term,phrase),
KEY idx_stem_phrase (stem,phrase),
KEY idx_soundex_phrase (soundex,phrase),
KEY idx_stem (stem),
KEY idx_language (language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_terms_common;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_terms_common (
term varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
custom int(11) NOT NULL DEFAULT 0,
UNIQUE KEY idx_term_language (term,language),
KEY idx_lang (language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_tokens;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_tokens (
term varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
stem varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
common tinyint(1) unsigned NOT NULL DEFAULT 0,
phrase tinyint(1) unsigned NOT NULL DEFAULT 0,
weight float unsigned NOT NULL DEFAULT 1,
context tinyint(1) unsigned NOT NULL DEFAULT 2,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
KEY idx_word (term),
KEY idx_context (context),
KEY idx_stem (stem),
KEY idx_language (language)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_tokens_aggregate;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_tokens_aggregate (
term_id int(10) unsigned NOT NULL,
term varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
stem varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
common tinyint(1) unsigned NOT NULL DEFAULT 0,
phrase tinyint(1) unsigned NOT NULL DEFAULT 0,
term_weight float unsigned NOT NULL DEFAULT 0,
context tinyint(1) unsigned NOT NULL DEFAULT 2,
context_weight float unsigned NOT NULL DEFAULT 0,
total_weight float unsigned NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
KEY token (term),
KEY keyword_id (term_id)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__finder_types;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__finder_types (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
title varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
mime varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (id),
UNIQUE KEY title (title)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__history;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__history (
version_id int(10) unsigned NOT NULL AUTO_INCREMENT,
item_id varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
version_note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Optional version name',
save_date datetime NOT NULL,
editor_user_id int(10) unsigned NOT NULL DEFAULT 0,
character_count int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Number of characters in this version.',
sha1_hash varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'SHA1 hash of the version_data column.',
version_data longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'json-encoded string of version data',
keep_forever tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=auto delete; 1=keep',
PRIMARY KEY (version_id),
KEY idx_ucm_item_id (item_id),
KEY idx_save_date (save_date)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__languages;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__languages (
lang_id int(11) unsigned NOT NULL AUTO_INCREMENT,
asset_id int(10) unsigned NOT NULL DEFAULT 0,
lang_code char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
title varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
title_native varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
sef varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
image varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
description varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL,
metakey mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadesc mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
sitename varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
published int(11) NOT NULL DEFAULT 0,
access int(10) unsigned NOT NULL DEFAULT 0,
ordering int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (lang_id),
UNIQUE KEY idx_sef (sef),
UNIQUE KEY idx_langcode (lang_code),
KEY idx_access (access),
KEY idx_ordering (ordering)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__mail_templates;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__mail_templates (
template_id varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
extension varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
subject varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
body text COLLATE utf8mb4_unicode_ci NOT NULL,
htmlbody text COLLATE utf8mb4_unicode_ci NOT NULL,
attachments text COLLATE utf8mb4_unicode_ci NOT NULL,
params text COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (template_id,language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__menu;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__menu (
id int(11) NOT NULL AUTO_INCREMENT,
menutype varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype',
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The display title of the menu item.',
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'The SEF alias of the menu item.',
note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
path varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The computed path of the menu item based on the alias field.',
link varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The actually link the menu item refers to.',
type varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator',
published tinyint(4) NOT NULL DEFAULT 0 COMMENT 'The published state of the menu link.',
parent_id int(10) unsigned NOT NULL DEFAULT 1 COMMENT 'The parent menu item in the menu tree.',
level int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The relative level in the tree.',
component_id int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to #__extensions.id',
checked_out int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to #__users.id',
checked_out_time datetime DEFAULT NULL,
browserNav tinyint(4) NOT NULL DEFAULT 0 COMMENT 'The click behaviour of the link.',
access int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The access level required to view the menu item.',
img varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The image of the menu item.',
template_style_id int(10) unsigned NOT NULL DEFAULT 0,
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded data for the menu item.',
lft int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
rgt int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
home tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Indicates if this menu item is the home or default page.',
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
client_id tinyint(4) NOT NULL DEFAULT 0,
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY idx_client_id_parent_id_alias_language (client_id,parent_id,alias(100),language),
KEY idx_componentid (component_id,menutype,published,access),
KEY idx_menutype (menutype),
KEY idx_left_right (lft,rgt),
KEY idx_language (language),
KEY idx_alias (alias(100)),
KEY idx_path (path(100))
) ENGINE=InnoDB AUTO_INCREMENT=570 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__menu_types;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__menu_types (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
asset_id int(10) unsigned NOT NULL DEFAULT 0,
menutype varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
title varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL,
description varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
client_id int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (id),
UNIQUE KEY idx_menutype (menutype)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__messages;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__messages (
message_id int(10) unsigned NOT NULL AUTO_INCREMENT,
user_id_from int(10) unsigned NOT NULL DEFAULT 0,
user_id_to int(10) unsigned NOT NULL DEFAULT 0,
folder_id tinyint(3) unsigned NOT NULL DEFAULT 0,
date_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
state tinyint(1) NOT NULL DEFAULT 0,
priority tinyint(1) unsigned NOT NULL DEFAULT 0,
subject varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
message mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (message_id),
KEY useridto_state (user_id_to,state)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__messages_cfg;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__messages_cfg (
user_id int(10) unsigned NOT NULL DEFAULT 0,
cfg_name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
cfg_value varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
UNIQUE KEY idx_user_var_name (user_id,cfg_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__modules;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__modules (
id int(11) NOT NULL AUTO_INCREMENT,
asset_id int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
title varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
content text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
ordering int(11) NOT NULL DEFAULT 0,
position varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
published tinyint(1) NOT NULL DEFAULT 0,
module varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
access int(10) unsigned NOT NULL DEFAULT 0,
showtitle tinyint(3) unsigned NOT NULL DEFAULT 1,
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
client_id tinyint(4) NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id),
KEY published (published,access),
KEY newsfeeds (module,published),
KEY idx_language (language)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__modules_menu;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__modules_menu (
moduleid int(11) NOT NULL DEFAULT 0,
menuid int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (moduleid,menuid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__newsfeeds;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__newsfeeds (
catid int(11) NOT NULL DEFAULT 0,
id int(10) unsigned NOT NULL AUTO_INCREMENT,
name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
link varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
published tinyint(1) NOT NULL DEFAULT 0,
numarticles int(10) unsigned NOT NULL DEFAULT 1,
cache_time int(10) unsigned NOT NULL DEFAULT 3600,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
ordering int(11) NOT NULL DEFAULT 0,
rtl tinyint(4) NOT NULL DEFAULT 0,
access int(10) unsigned NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
created datetime NOT NULL,
created_by int(10) unsigned NOT NULL DEFAULT 0,
created_by_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
modified datetime NOT NULL,
modified_by int(10) unsigned NOT NULL DEFAULT 0,
metakey mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadesc mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadata mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
description mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
version int(10) unsigned NOT NULL DEFAULT 1,
hits int(10) unsigned NOT NULL DEFAULT 0,
images mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id),
KEY idx_access (access),
KEY idx_checkout (checked_out),
KEY idx_state (published),
KEY idx_catid (catid),
KEY idx_createdby (created_by),
KEY idx_language (language)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__overrider;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__overrider (
id int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
constant varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
string mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
file varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__postinstall_messages;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__postinstall_messages (
postinstall_message_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
extension_id bigint(20) NOT NULL DEFAULT 700 COMMENT 'FK to #__extensions',
title_key varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Lang key for the title',
description_key varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Lang key for description',
action_key varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
language_extension varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'com_postinstall' COMMENT 'Extension holding lang keys',
language_client_id tinyint(3) NOT NULL DEFAULT 1,
type varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'link' COMMENT 'Message type - message, link, action',
action_file varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'RAD URI to the PHP file containing action method',
action varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Action method name or URL',
condition_file varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'RAD URI to file holding display condition method',
condition_method varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Display condition method, must return boolean',
version_introduced varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '3.2.0' COMMENT 'Version when this message was introduced',
enabled tinyint(3) NOT NULL DEFAULT 1,
PRIMARY KEY (postinstall_message_id)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__privacy_consents;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__privacy_consents (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
user_id int(10) unsigned NOT NULL DEFAULT 0,
state int(10) NOT NULL DEFAULT 1,
created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
subject varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
body text COLLATE utf8mb4_unicode_ci NOT NULL,
remind tinyint(4) NOT NULL DEFAULT 0,
token varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (id),
KEY idx_user_id (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__privacy_requests;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__privacy_requests (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
email varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
requested_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
status tinyint(4) NOT NULL DEFAULT 0,
request_type varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
confirm_token varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
confirm_token_created_at datetime DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__redirect_links;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__redirect_links (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
old_url varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
new_url varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
referer varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
comment varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
hits int(10) unsigned NOT NULL DEFAULT 0,
published tinyint(4) NOT NULL,
created_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
modified_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
header smallint(3) NOT NULL DEFAULT 301,
PRIMARY KEY (id),
KEY idx_link_modifed (modified_date),
KEY idx_old_url (old_url(100))
) ENGINE=InnoDB AUTO_INCREMENT=3458 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__schemas;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__schemas (
extension_id int(11) NOT NULL,
version_id varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (extension_id,version_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__session;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__session (
session_id varbinary(192) NOT NULL,
client_id tinyint(3) unsigned DEFAULT NULL,
guest tinyint(3) unsigned DEFAULT 1,
time int(11) NOT NULL DEFAULT 0,
data longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
userid int(11) DEFAULT 0,
username varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT '',
PRIMARY KEY (session_id),
KEY userid (userid),
KEY time (time),
KEY client_id_guest (client_id,guest)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__tags;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__tags (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
note varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
description longtext COLLATE utf8mb4_unicode_ci NOT NULL,
published tinyint(1) NOT NULL DEFAULT 0,
checked_out int(11) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
access int(10) unsigned NOT NULL DEFAULT 0,
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadesc varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The meta description for the page.',
metakey varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
metadata varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded metadata properties.',
created_user_id int(10) unsigned NOT NULL DEFAULT 0,
created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
created_by_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
modified_user_id int(10) unsigned NOT NULL DEFAULT 0,
modified_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
images mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
urls mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
hits int(10) unsigned NOT NULL DEFAULT 0,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL,
version int(10) unsigned NOT NULL DEFAULT 1,
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY tag_idx (published,access),
KEY idx_access (access),
KEY idx_checkout (checked_out),
KEY idx_left_right (lft,rgt),
KEY idx_language (language),
KEY idx_path (path(100)),
KEY idx_alias (alias(100))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__template_overrides;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__template_overrides (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
template varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
hash_id varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
extension_id int(11) DEFAULT 0,
state tinyint(4) NOT NULL DEFAULT 0,
action varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
client_id tinyint(3) unsigned NOT NULL DEFAULT 0,
created_date datetime NOT NULL,
modified_date datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY idx_template (template),
KEY idx_extension_id (extension_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__template_styles;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__template_styles (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
template varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
client_id tinyint(1) unsigned NOT NULL DEFAULT 0,
home char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
inheritable tinyint(4) NOT NULL DEFAULT 0,
parent varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '',
PRIMARY KEY (id),
KEY idx_template (template),
KEY idx_client_id (client_id),
KEY idx_client_id_home (client_id,home)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__ucm_base;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__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,
PRIMARY KEY (ucm_id),
KEY idx_ucm_item_id (ucm_item_id),
KEY idx_ucm_type_id (ucm_type_id),
KEY idx_ucm_language_id (ucm_language_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__ucm_content;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__ucm_content (
core_content_id int(10) unsigned NOT NULL AUTO_INCREMENT,
core_type_alias varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'FK to the content types table',
core_title varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
core_alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
core_body mediumtext COLLATE utf8mb4_unicode_ci 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 NOT NULL DEFAULT 0,
core_access int(10) unsigned NOT NULL DEFAULT 0,
core_params text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
core_featured tinyint(4) unsigned NOT NULL DEFAULT 0,
core_metadata varchar(2048) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
core_urls text COLLATE utf8mb4_unicode_ci 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 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
core_metadesc text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
core_catid int(10) unsigned NOT NULL DEFAULT 0,
core_xreference varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
core_type_id int(10) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (core_content_id),
KEY tag_idx (core_state,core_access),
KEY idx_access (core_access),
KEY idx_language (core_language),
KEY idx_modified_time (core_modified_time),
KEY idx_created_time (core_created_time),
KEY idx_core_modified_user_id (core_modified_user_id),
KEY idx_core_checked_out_user_id (core_checked_out_user_id),
KEY idx_core_created_user_id (core_created_user_id),
KEY idx_core_type_id (core_type_id),
KEY idx_alias (core_alias(100)),
KEY idx_title (core_title(100)),
KEY idx_content_type (core_type_alias(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Contains core content data in name spaced fields';
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__update_sites;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__update_sites (
update_site_id int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
type varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
location mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
enabled int(11) DEFAULT 0,
last_check_timestamp bigint(20) DEFAULT 0,
extra_query varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '',
checked_out int(10) unsigned DEFAULT NULL,
checked_out_time datetime DEFAULT NULL,
PRIMARY KEY (update_site_id)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites';
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__update_sites_extensions;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__update_sites_extensions (
update_site_id int(11) NOT NULL DEFAULT 0,
extension_id int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (update_site_id,extension_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites';
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__updates;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__updates (
update_id int(11) NOT NULL AUTO_INCREMENT,
update_site_id int(11) DEFAULT 0,
extension_id int(11) DEFAULT 0,
name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
description mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
element varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
type varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
folder varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
client_id tinyint(3) DEFAULT 0,
version varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '',
data mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
detailsurl mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
infourl mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
changelogurl text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
extra_query varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '',
PRIMARY KEY (update_id)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__user_keys;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__user_keys (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
user_id varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
token varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
series varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
time varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
uastring varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY series (series),
KEY user_id (user_id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__user_notes;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__user_notes (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
user_id int(10) unsigned NOT NULL DEFAULT 0,
catid int(10) unsigned NOT NULL DEFAULT 0,
subject varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
body mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
state tinyint(3) NOT NULL DEFAULT 0,
checked_out int(10) unsigned NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
created_user_id int(10) unsigned NOT NULL DEFAULT 0,
created_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
modified_user_id int(10) unsigned NOT NULL DEFAULT 0,
modified_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
review_time datetime DEFAULT NULL,
publish_up datetime DEFAULT NULL,
publish_down datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY idx_user_id (user_id),
KEY idx_category_id (catid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__user_profiles;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__user_profiles (
user_id int(11) NOT NULL,
profile_key varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
profile_value mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
ordering int(11) NOT NULL DEFAULT 0,
UNIQUE KEY idx_user_id_profile_key (user_id,profile_key)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__user_usergroup_map;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__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',
PRIMARY KEY (user_id,group_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__usergroups;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__usergroups (
id int(10) unsigned NOT NULL AUTO_INCREMENT 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (id),
UNIQUE KEY idx_usergroup_parent_title_lookup (parent_id,title),
KEY idx_usergroup_title_lookup (title),
KEY idx_usergroup_adjacency_lookup (parent_id),
KEY idx_usergroup_nested_set_lookup (lft,rgt) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__users;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__users (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
username varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
email varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
password varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
block tinyint(4) NOT NULL DEFAULT 0,
sendEmail tinyint(4) DEFAULT 0,
registerDate datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
lastvisitDate datetime DEFAULT NULL,
activation varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
lastResetTime datetime DEFAULT NULL,
resetCount int(11) NOT NULL DEFAULT 0 COMMENT 'Count of password resets since lastResetTime',
otpKey varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
otep varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
requireReset tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Require user to reset password on next login',
PRIMARY KEY (id),
UNIQUE KEY idx_username (username),
KEY idx_block (block),
KEY email (email),
KEY idx_name (name(100))
) ENGINE=InnoDB AUTO_INCREMENT=858 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__viewlevels;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__viewlevels (
id int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
title varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
ordering int(11) NOT NULL DEFAULT 0,
rules varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.',
PRIMARY KEY (id),
UNIQUE KEY idx_assetgroup_title_lookup (title)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__webauthn_credentials;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__webauthn_credentials (
id varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Credential ID',
user_id varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'User handle',
label varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Human readable label',
credential mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Credential source data, JSON format',
PRIMARY KEY (id(100)),
KEY user_id (user_id(60))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__weblinks;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__weblinks (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
catid int(11) NOT NULL DEFAULT 0,
title varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
alias varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
url varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
description mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
hits int(11) NOT NULL DEFAULT 0,
state tinyint(1) NOT NULL DEFAULT 0,
checked_out int(11) NOT NULL DEFAULT 0,
checked_out_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
ordering int(11) NOT NULL DEFAULT 0,
access int(11) NOT NULL DEFAULT 1,
params mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
language char(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
created_by int(10) unsigned NOT NULL DEFAULT 0,
created_by_alias varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
modified datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
modified_by int(10) unsigned NOT NULL DEFAULT 0,
metakey mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadesc mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
metadata mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
featured tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if link is featured.',
xreference varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
publish_up datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
publish_down datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
version int(10) unsigned NOT NULL DEFAULT 1,
images mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (id),
KEY idx_access (access),
KEY idx_checkout (checked_out),
KEY idx_state (state),
KEY idx_catid (catid),
KEY idx_createdby (created_by),
KEY idx_featured_catid (featured,catid),
KEY idx_language (language),
KEY idx_xreference (xreference)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__workflow_associations;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__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) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (item_id,extension),
KEY idx_item_stage_extension (item_id,stage_id,extension),
KEY idx_item_id (item_id),
KEY idx_stage_id (stage_id),
KEY idx_extension (extension)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__workflow_stages;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__workflow_stages (
id int(11) NOT NULL AUTO_INCREMENT,
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) COLLATE utf8mb4_unicode_ci NOT NULL,
description text COLLATE utf8mb4_unicode_ci NOT NULL,
default tinyint(4) NOT NULL DEFAULT 0,
checked_out_time datetime DEFAULT NULL,
checked_out int(10) unsigned DEFAULT NULL,
PRIMARY KEY (id),
KEY idx_workflow_id (workflow_id),
KEY idx_checked_out (checked_out),
KEY idx_title (title(191)),
KEY idx_asset_id (asset_id),
KEY idx_default (default)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__workflow_transitions;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__workflow_transitions (
id int(11) NOT NULL AUTO_INCREMENT,
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) COLLATE utf8mb4_unicode_ci NOT NULL,
description text COLLATE utf8mb4_unicode_ci NOT NULL,
from_stage_id int(11) NOT NULL,
to_stage_id int(11) NOT NULL,
options text COLLATE utf8mb4_unicode_ci NOT NULL,
checked_out_time datetime DEFAULT NULL,
checked_out int(10) unsigned DEFAULT NULL,
PRIMARY KEY (id),
KEY idx_title (title(191)),
KEY idx_asset_id (asset_id),
KEY idx_checked_out (checked_out),
KEY idx_from_stage_id (from_stage_id),
KEY idx_to_stage_id (to_stage_id),
KEY idx_workflow_id (workflow_id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS #__workflows;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE #__workflows (
id int(11) NOT NULL AUTO_INCREMENT,
asset_id int(11) DEFAULT 0,
published tinyint(4) NOT NULL DEFAULT 0,
title varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
description text COLLATE utf8mb4_unicode_ci NOT NULL,
extension varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
default tinyint(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,
PRIMARY KEY (id),
KEY idx_asset_id (asset_id),
KEY idx_title (title(191)),
KEY idx_extension (extension),
KEY idx_default (default),
KEY idx_created (created),
KEY idx_created_by (created_by),
KEY idx_modified (modified),
KEY idx_modified_by (modified_by),
KEY idx_checked_out (checked_out)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/!40101 SET character_set_client = @saved_cs_client */;`

richard67 - comment - 27 Aug 2021

Like for example _extensions, there is "locked" the last field but it should be after "protected".

Another wrong ordered field is "only_use_in_subform" from -fields which is at the end and should be after "required". Seems there are lots of minor field bugs which ends in some trouble for some users.

@k1ll3r8e The order of fields has absolutely no meaning in a relational database. Therefore it is absolutely ok to append them to the end of the table when adding them on an update. On PostgreSQL and other kinds of databases there is even no other way to do it. A different order of fields in a table cannot cause any problem and is definitely bot a bug.

k1ll3r8e - comment - 27 Aug 2021

@richard67 I would say, it depends on the way you use "insert into" because here for example, https://www.w3schools.com/sql/sql_insert.asp is stated that you should care on the field order in the table. (But I'm no sql pro)

richard67 - comment - 27 Aug 2021

@k1ll3r8e We shall not and we do not support the 2nd method because as I said, PostgreSQL dies not allow to define where a column is added, it adds it always to the end, and as you hopefully know Joomla 4 supports also PostgreSQL databases.

Add a Comment

Older
Newer

Joomla! Issue Tracker - CMS