joomla_contact_details
PK
id  
INT(11)
NN
name  
VARCHAR(255)
NN
alias  
VARCHAR(400)
NN
con_position  
VARCHAR(255)
address  
TEXT
suburb  
VARCHAR(100)
state  
VARCHAR(100)
country  
VARCHAR(100)
postcode  
VARCHAR(100)
telephone  
VARCHAR(255)
fax  
VARCHAR(255)
misc  
MEDIUMTEXT
image  
VARCHAR(255)
email_to  
VARCHAR(255)
default_con  
TINYINT(3)
NN
published  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
ordering  
INT(11)
NN
params  
TEXT
NN
user_id  
INT(11)
NN
catid  
INT(11)
NN
access  
INT(10)
NN
mobile  
VARCHAR(255)
NN
webpage  
VARCHAR(255)
NN
sortname1  
VARCHAR(255)
NN
sortname2  
VARCHAR(255)
NN
sortname3  
VARCHAR(255)
NN
language  
VARCHAR(7)
NN
created  
DATETIME
NN
created_by  
INT(10)
NN
created_by_alias  
VARCHAR(255)
NN
modified  
DATETIME
NN
modified_by  
INT(10)
NN
metakey  
TEXT
metadesc  
TEXT
NN
metadata  
TEXT
NN
featured  
TINYINT(3)
NN
publish_up  
DATETIME
publish_down  
DATETIME
version  
INT(10)
NN
hits  
INT(10)
NN
KEY
PRIMARY
IX
idx_access
IX
idx_checkout
IX
idx_state
IX
idx_catid
IX
idx_createdby
IX
idx_featured_catid
IX
idx_language
joomla_action_logs_users
PK
user_id  
INT(10)
NN
notify  
TINYINT(3)
NN
extensions  
TEXT
NN
KEY
PRIMARY
IX
idx_notify
joomla_usergroups
PK
id  
INT(10)
NN
AK
parent_id  
INT(10)
NN
lft  
INT(11)
NN
rgt  
INT(11)
NN
AK
title  
VARCHAR(100)
NN
KEY
PRIMARY
KEY
idx_usergroup_parent_title_lookup
IX
idx_usergroup_title_lookup
IX
idx_usergroup_adjacency_lookup
IX
idx_usergroup_nested_set_lookup
joomla_workflow_associations
PK
item_id  
INT(11)
NN
stage_id  
INT(11)
NN
PK
extension  
VARCHAR(50)
NN
KEY
PRIMARY
IX
idx_item_stage_extension
IX
idx_item_id
IX
idx_stage_id
IX
idx_extension
joomla_workflows
PK
id  
INT(11)
NN
asset_id  
INT(11)
published  
TINYINT(4)
NN
title  
VARCHAR(255)
NN
description  
TEXT
NN
extension  
VARCHAR(50)
NN
default  
TINYINT(4)
NN
ordering  
INT(11)
NN
created  
DATETIME
NN
created_by  
INT(11)
NN
modified  
DATETIME
NN
modified_by  
INT(11)
NN
checked_out_time  
DATETIME
checked_out  
INT(10)
KEY
PRIMARY
IX
idx_asset_id
IX
idx_title
IX
idx_extension
IX
idx_default
IX
idx_created
IX
idx_created_by
IX
idx_modified
IX
idx_modified_by
IX
idx_checked_out
joomla_finder_taxonomy_map
PK
link_id  
INT(10)
NN
PK
node_id  
INT(10)
NN
KEY
PRIMARY
IX
link_id
IX
node_id
joomla_user_usergroup_map
PK
user_id  
INT(10)
NN
PK
group_id  
INT(10)
NN
KEY
PRIMARY
joomla_finder_filters
PK
filter_id  
INT(10)
NN
title  
VARCHAR(255)
NN
alias  
VARCHAR(255)
NN
state  
TINYINT(4)
NN
created  
DATETIME
NN
created_by  
INT(10)
NN
created_by_alias  
VARCHAR(255)
NN
modified  
DATETIME
NN
modified_by  
INT(10)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
map_count  
INT(10)
NN
data  
TEXT
params  
MEDIUMTEXT
KEY
PRIMARY
joomla_contentitem_tag_map
type_alias  
VARCHAR(255)
NN
core_content_id  
INT(10)
NN
AK
content_item_id  
INT(11)
NN
AK
tag_id  
INT(10)
NN
tag_date  
TIMESTAMP
NN
AK
type_id  
MEDIUMINT(9)
NN
KEY
uc_ItemnameTagid
KEY
Primary key
IX
idx_tag_type
IX
idx_date_id
IX
idx_core_content_id
joomla_modules_menu
PK
moduleid  
INT(11)
NN
PK
menuid  
INT(11)
NN
KEY
PRIMARY
joomla_assets
PK
id  
INT(10)
NN
parent_id  
INT(11)
NN
lft  
INT(11)
NN
rgt  
INT(11)
NN
level  
INT(10)
NN
AK
name  
VARCHAR(50)
NN
title  
VARCHAR(100)
NN
rules  
VARCHAR(5120)
NN
KEY
PRIMARY
KEY
idx_asset_name
IX
idx_lft_rgt
IX
idx_parent_id
joomla_finder_tokens_aggregate
term_id  
INT(10)
NN
term  
VARCHAR(75)
NN
stem  
VARCHAR(75)
NN
common  
TINYINT(3)
NN
phrase  
TINYINT(3)
NN
term_weight  
FLOAT
NN
context  
TINYINT(3)
NN
context_weight  
FLOAT
NN
total_weight  
FLOAT
NN
language  
CHAR(7)
NN
KEY
Primary key
IX
token
IX
keyword_id
joomla_finder_taxonomy
PK
id  
INT(10)
NN
parent_id  
INT(10)
NN
lft  
INT(11)
NN
rgt  
INT(11)
NN
level  
INT(10)
NN
path  
VARCHAR(400)
NN
title  
VARCHAR(255)
NN
alias  
VARCHAR(400)
NN
state  
TINYINT(3)
NN
access  
TINYINT(3)
NN
language  
CHAR(7)
NN
KEY
PRIMARY
IX
idx_state
IX
idx_access
IX
idx_path
IX
idx_level
IX
idx_left_right
IX
idx_alias
IX
idx_language
IX
idx_parent_published
joomla_template_styles
PK
id  
INT(10)
NN
template  
VARCHAR(50)
NN
client_id  
TINYINT(3)
NN
home  
CHAR(7)
NN
title  
VARCHAR(255)
NN
inheritable  
TINYINT(4)
NN
parent  
VARCHAR(50)
params  
TEXT
NN
KEY
PRIMARY
IX
idx_template
IX
idx_client_id
IX
idx_client_id_home
joomla_tags
PK
id  
INT(10)
NN
parent_id  
INT(10)
NN
lft  
INT(11)
NN
rgt  
INT(11)
NN
level  
INT(10)
NN
path  
VARCHAR(400)
NN
title  
VARCHAR(255)
NN
alias  
VARCHAR(400)
NN
note  
VARCHAR(255)
NN
description  
MEDIUMTEXT
NN
published  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
access  
INT(10)
NN
params  
TEXT
NN
metadesc  
VARCHAR(1024)
NN
metakey  
VARCHAR(1024)
NN
metadata  
VARCHAR(2048)
NN
created_user_id  
INT(10)
NN
created_time  
DATETIME
NN
created_by_alias  
VARCHAR(255)
NN
modified_user_id  
INT(10)
NN
modified_time  
DATETIME
NN
images  
TEXT
NN
urls  
TEXT
NN
hits  
INT(10)
NN
language  
CHAR(7)
NN
version  
INT(10)
NN
publish_up  
DATETIME
publish_down  
DATETIME
KEY
PRIMARY
IX
tag_idx
IX
idx_access
IX
idx_checkout
IX
idx_path
IX
idx_left_right
IX
idx_alias
IX
idx_language
joomla_finder_types
PK
id  
INT(10)
NN
AK
title  
VARCHAR(100)
NN
mime  
VARCHAR(100)
NN
KEY
PRIMARY
KEY
title
joomla_languages
PK
lang_id  
INT(10)
NN
asset_id  
INT(10)
NN
AK
lang_code  
CHAR(7)
NN
title  
VARCHAR(50)
NN
title_native  
VARCHAR(50)
NN
AK
sef  
VARCHAR(50)
NN
image  
VARCHAR(50)
NN
description  
VARCHAR(512)
NN
metakey  
TEXT
metadesc  
TEXT
NN
sitename  
VARCHAR(1024)
NN
published  
INT(11)
NN
access  
INT(10)
NN
ordering  
INT(11)
NN
KEY
PRIMARY
KEY
idx_sef
KEY
idx_langcode
IX
idx_access
IX
idx_ordering
joomla_ucm_base
PK
ucm_id  
INT(10)
NN
ucm_item_id  
INT(11)
NN
ucm_type_id  
INT(11)
NN
ucm_language_id  
INT(11)
NN
KEY
PRIMARY
IX
idx_ucm_item_id
IX
idx_ucm_type_id
IX
idx_ucm_language_id
joomla_users
PK
id  
INT(11)
NN
name  
VARCHAR(400)
NN
AK
username  
VARCHAR(150)
NN
email  
VARCHAR(100)
NN
password  
VARCHAR(100)
NN
block  
TINYINT(4)
NN
sendEmail  
TINYINT(4)
registerDate  
DATETIME
NN
lastvisitDate  
DATETIME
activation  
VARCHAR(100)
NN
params  
TEXT
NN
lastResetTime  
DATETIME
resetCount  
INT(11)
NN
otpKey  
VARCHAR(1000)
NN
otep  
VARCHAR(1000)
NN
requireReset  
TINYINT(4)
NN
authProvider  
VARCHAR(100)
NN
KEY
PRIMARY
KEY
idx_username
IX
idx_name
IX
idx_block
IX
email
joomla_workflow_transitions
PK
id  
INT(11)
NN
asset_id  
INT(11)
ordering  
INT(11)
NN
workflow_id  
INT(11)
NN
published  
TINYINT(4)
NN
title  
VARCHAR(255)
NN
description  
TEXT
NN
from_stage_id  
INT(11)
NN
to_stage_id  
INT(11)
NN
options  
TEXT
NN
checked_out_time  
DATETIME
checked_out  
INT(10)
KEY
PRIMARY
IX
idx_title
IX
idx_asset_id
IX
idx_checked_out
IX
idx_from_stage_id
IX
idx_to_stage_id
IX
idx_workflow_id
joomla_fields_values
field_id  
INT(10)
NN
item_id  
VARCHAR(255)
NN
value  
TEXT
KEY
Primary key
IX
idx_field_id
IX
idx_item_id
joomla_content
PK
id  
INT(10)
NN
asset_id  
INT(10)
NN
title  
VARCHAR(255)
NN
alias  
VARCHAR(400)
NN
introtext  
MEDIUMTEXT
NN
fulltext  
MEDIUMTEXT
NN
state  
TINYINT(4)
NN
catid  
INT(10)
NN
created  
DATETIME
NN
created_by  
INT(10)
NN
created_by_alias  
VARCHAR(255)
NN
modified  
DATETIME
NN
modified_by  
INT(10)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
publish_up  
DATETIME
publish_down  
DATETIME
images  
TEXT
NN
urls  
TEXT
NN
attribs  
VARCHAR(5120)
NN
version  
INT(10)
NN
ordering  
INT(11)
NN
metakey  
TEXT
metadesc  
TEXT
NN
access  
INT(10)
NN
hits  
INT(10)
NN
metadata  
TEXT
NN
featured  
TINYINT(3)
NN
language  
CHAR(7)
NN
note  
VARCHAR(255)
NN
KEY
PRIMARY
IX
idx_access
IX
idx_checkout
IX
idx_state
IX
idx_catid
IX
idx_createdby
IX
idx_featured_catid
IX
idx_language
IX
idx_alias
joomla_action_logs_extensions
PK
id  
INT(10)
NN
extension  
VARCHAR(255)
NN
KEY
PRIMARY
joomla_content_frontpage
PK
content_id  
INT(11)
NN
ordering  
INT(11)
NN
featured_up  
DATETIME
featured_down  
DATETIME
KEY
PRIMARY
joomla_updates
PK
update_id  
INT(11)
NN
update_site_id  
INT(11)
extension_id  
INT(11)
name  
VARCHAR(100)
description  
TEXT
NN
element  
VARCHAR(100)
type  
VARCHAR(20)
folder  
VARCHAR(20)
client_id  
TINYINT(4)
version  
VARCHAR(32)
data  
TEXT
NN
detailsurl  
TEXT
NN
infourl  
TEXT
NN
changelogurl  
TEXT
extra_query  
VARCHAR(1000)
KEY
PRIMARY
joomla_extensions
PK
extension_id  
INT(11)
NN
package_id  
INT(11)
NN
name  
VARCHAR(100)
NN
type  
VARCHAR(20)
NN
element  
VARCHAR(100)
NN
changelogurl  
TEXT
folder  
VARCHAR(100)
NN
client_id  
TINYINT(4)
NN
enabled  
TINYINT(4)
NN
access  
INT(10)
NN
protected  
TINYINT(4)
NN
locked  
TINYINT(4)
NN
manifest_cache  
TEXT
NN
params  
TEXT
NN
custom_data  
TEXT
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
ordering  
INT(11)
state  
INT(11)
note  
VARCHAR(255)
KEY
PRIMARY
IX
element_clientid
IX
element_folder_clientid
IX
extension
joomla_messages
PK
message_id  
INT(10)
NN
user_id_from  
INT(10)
NN
user_id_to  
INT(10)
NN
folder_id  
TINYINT(3)
NN
date_time  
DATETIME
NN
state  
TINYINT(4)
NN
priority  
TINYINT(3)
NN
subject  
VARCHAR(255)
NN
message  
TEXT
NN
KEY
PRIMARY
IX
useridto_state
joomla_fields
PK
id  
INT(10)
NN
asset_id  
INT(10)
NN
context  
VARCHAR(255)
NN
group_id  
INT(10)
NN
title  
VARCHAR(255)
NN
name  
VARCHAR(255)
NN
label  
VARCHAR(255)
NN
default_value  
TEXT
type  
VARCHAR(255)
NN
note  
VARCHAR(255)
NN
description  
TEXT
NN
state  
TINYINT(4)
NN
required  
TINYINT(4)
NN
only_use_in_subform  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
ordering  
INT(11)
NN
params  
TEXT
NN
fieldparams  
TEXT
NN
language  
CHAR(7)
NN
created_time  
DATETIME
NN
created_user_id  
INT(10)
NN
modified_time  
DATETIME
NN
modified_by  
INT(10)
NN
access  
INT(11)
NN
KEY
PRIMARY
IX
idx_checkout
IX
idx_state
IX
idx_created_user_id
IX
idx_access
IX
idx_context
IX
idx_language
joomla_categories
PK
id  
INT(11)
NN
asset_id  
INT(10)
NN
parent_id  
INT(10)
NN
lft  
INT(11)
NN
rgt  
INT(11)
NN
level  
INT(10)
NN
path  
VARCHAR(400)
NN
extension  
VARCHAR(50)
NN
title  
VARCHAR(255)
NN
alias  
VARCHAR(400)
NN
note  
VARCHAR(255)
NN
description  
MEDIUMTEXT
published  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
access  
INT(10)
NN
params  
TEXT
metadesc  
VARCHAR(1024)
NN
metakey  
VARCHAR(1024)
NN
metadata  
VARCHAR(2048)
NN
created_user_id  
INT(10)
NN
created_time  
DATETIME
NN
modified_user_id  
INT(10)
NN
modified_time  
DATETIME
NN
hits  
INT(10)
NN
language  
CHAR(7)
NN
version  
INT(10)
NN
KEY
PRIMARY
IX
cat_idx
IX
idx_access
IX
idx_checkout
IX
idx_path
IX
idx_left_right
IX
idx_alias
IX
idx_language
joomla_template_overrides
PK
id  
INT(10)
NN
template  
VARCHAR(50)
NN
hash_id  
VARCHAR(255)
NN
extension_id  
INT(11)
state  
TINYINT(4)
NN
action  
VARCHAR(50)
NN
client_id  
TINYINT(3)
NN
created_date  
DATETIME
NN
modified_date  
DATETIME
KEY
PRIMARY
IX
idx_template
IX
idx_extension_id
joomla_action_logs
PK
id  
INT(10)
NN
message_language_key  
VARCHAR(255)
NN
message  
TEXT
NN
log_date  
DATETIME
NN
extension  
VARCHAR(50)
NN
user_id  
INT(11)
NN
item_id  
INT(11)
NN
ip_address  
VARCHAR(40)
NN
KEY
PRIMARY
IX
idx_user_id
IX
idx_user_id_logdate
IX
idx_user_id_extension
IX
idx_extension_item_id
joomla_history
PK
version_id  
INT(10)
NN
item_id  
VARCHAR(50)
NN
version_note  
VARCHAR(255)
NN
save_date  
DATETIME
NN
editor_user_id  
INT(10)
NN
character_count  
INT(10)
NN
sha1_hash  
VARCHAR(50)
NN
version_data  
MEDIUMTEXT
NN
keep_forever  
TINYINT(4)
NN
KEY
PRIMARY
IX
idx_ucm_item_id
IX
idx_save_date
joomla_menu_types
PK
id  
INT(10)
NN
asset_id  
INT(10)
NN
AK
menutype  
VARCHAR(24)
NN
title  
VARCHAR(48)
NN
description  
VARCHAR(255)
NN
client_id  
INT(11)
NN
KEY
PRIMARY
KEY
idx_menutype
joomla_session
PK
session_id  
VARBINARY(192)
NN
client_id  
TINYINT(3)
guest  
TINYINT(3)
time  
INT(11)
NN
data  
MEDIUMTEXT
userid  
INT(11)
username  
VARCHAR(150)
KEY
PRIMARY
IX
userid
IX
time
IX
client_id_guest
joomla_newsfeeds
catid  
INT(11)
NN
PK
id  
INT(10)
NN
name  
VARCHAR(100)
NN
alias  
VARCHAR(400)
NN
link  
VARCHAR(2048)
NN
published  
TINYINT(4)
NN
numarticles  
INT(10)
NN
cache_time  
INT(10)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
ordering  
INT(11)
NN
rtl  
TINYINT(4)
NN
access  
INT(10)
NN
language  
CHAR(7)
NN
params  
TEXT
NN
created  
DATETIME
NN
created_by  
INT(10)
NN
created_by_alias  
VARCHAR(255)
NN
modified  
DATETIME
NN
modified_by  
INT(10)
NN
metakey  
TEXT
metadesc  
TEXT
NN
metadata  
TEXT
NN
publish_up  
DATETIME
publish_down  
DATETIME
description  
TEXT
NN
version  
INT(10)
NN
hits  
INT(10)
NN
images  
TEXT
NN
KEY
PRIMARY
IX
idx_access
IX
idx_checkout
IX
idx_state
IX
idx_catid
IX
idx_createdby
IX
idx_language
joomla_action_log_config
PK
id  
INT(10)
NN
type_title  
VARCHAR(255)
NN
type_alias  
VARCHAR(255)
NN
id_holder  
VARCHAR(255)
title_holder  
VARCHAR(255)
table_name  
VARCHAR(255)
text_prefix  
VARCHAR(255)
KEY
PRIMARY
joomla_finder_terms_common
AK
term  
VARCHAR(75)
NN
AK
language  
CHAR(7)
NN
custom  
INT(11)
NN
KEY
idx_term_language
KEY
Primary key
IX
idx_lang
joomla_modules
PK
id  
INT(11)
NN
asset_id  
INT(10)
NN
title  
VARCHAR(100)
NN
note  
VARCHAR(255)
NN
content  
TEXT
ordering  
INT(11)
NN
position  
VARCHAR(50)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
publish_up  
DATETIME
publish_down  
DATETIME
published  
TINYINT(4)
NN
module  
VARCHAR(50)
access  
INT(10)
NN
showtitle  
TINYINT(3)
NN
params  
TEXT
NN
client_id  
TINYINT(4)
NN
language  
CHAR(7)
NN
KEY
PRIMARY
IX
published
IX
newsfeeds
IX
idx_language
joomla_redirect_links
PK
id  
INT(10)
NN
old_url  
VARCHAR(2048)
NN
new_url  
VARCHAR(2048)
referer  
VARCHAR(2048)
NN
comment  
VARCHAR(255)
NN
hits  
INT(10)
NN
published  
TINYINT(4)
NN
created_date  
DATETIME
NN
modified_date  
DATETIME
NN
header  
SMALLINT(6)
NN
KEY
PRIMARY
IX
idx_old_url
IX
idx_link_modified
joomla_update_sites
PK
update_site_id  
INT(11)
NN
name  
VARCHAR(100)
type  
VARCHAR(20)
location  
TEXT
NN
enabled  
INT(11)
last_check_timestamp  
BIGINT(20)
extra_query  
VARCHAR(1000)
checked_out  
INT(10)
checked_out_time  
DATETIME
KEY
PRIMARY
joomla_menu
PK
id  
INT(11)
NN
menutype  
VARCHAR(24)
NN
title  
VARCHAR(255)
NN
AK
alias  
VARCHAR(400)
NN
note  
VARCHAR(255)
NN
path  
VARCHAR(1024)
NN
link  
VARCHAR(1024)
NN
type  
VARCHAR(16)
NN
published  
TINYINT(4)
NN
AK
parent_id  
INT(10)
NN
level  
INT(10)
NN
component_id  
INT(10)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
browserNav  
TINYINT(4)
NN
access  
INT(10)
NN
img  
VARCHAR(255)
NN
template_style_id  
INT(10)
NN
params  
TEXT
NN
lft  
INT(11)
NN
rgt  
INT(11)
NN
home  
TINYINT(3)
NN
AK
language  
CHAR(7)
NN
AK
client_id  
TINYINT(4)
NN
publish_up  
DATETIME
publish_down  
DATETIME
KEY
PRIMARY
KEY
idx_client_id_parent_id_alias_language
IX
idx_componentid
IX
idx_menutype
IX
idx_left_right
IX
idx_alias
IX
idx_path
IX
idx_language
joomla_content_types
PK
type_id  
INT(10)
NN
type_title  
VARCHAR(255)
NN
type_alias  
VARCHAR(400)
NN
table  
VARCHAR(2048)
NN
rules  
TEXT
NN
field_mappings  
TEXT
NN
router  
VARCHAR(255)
NN
content_history_options  
VARCHAR(5120)
KEY
PRIMARY
IX
idx_alias
joomla_finder_logging
searchterm  
VARCHAR(255)
NN
PK
md5sum  
VARCHAR(32)
NN
query  
BLOB
NN
hits  
INT(11)
NN
results  
INT(11)
NN
KEY
PRIMARY
IX
searchterm
joomla_user_profiles
AK
user_id  
INT(11)
NN
AK
profile_key  
VARCHAR(100)
NN
profile_value  
TEXT
NN
ordering  
INT(11)
NN
KEY
idx_user_id_profile_key
KEY
Primary key
joomla_finder_tokens
term  
VARCHAR(75)
NN
stem  
VARCHAR(75)
NN
common  
TINYINT(3)
NN
phrase  
TINYINT(3)
NN
weight  
FLOAT
NN
context  
TINYINT(3)
NN
language  
CHAR(7)
NN
KEY
Primary key
IX
idx_word
IX
idx_stem
IX
idx_context
IX
idx_language
joomla_finder_links
PK
link_id  
INT(10)
NN
url  
VARCHAR(255)
NN
route  
VARCHAR(400)
NN
title  
VARCHAR(400)
description  
TEXT
indexdate  
DATETIME
NN
md5sum  
VARCHAR(32)
published  
TINYINT(4)
NN
state  
INT(11)
NN
access  
INT(11)
NN
language  
CHAR(7)
NN
publish_start_date  
DATETIME
publish_end_date  
DATETIME
start_date  
DATETIME
end_date  
DATETIME
list_price  
DOUBLE
NN
sale_price  
DOUBLE
NN
type_id  
INT(11)
NN
object  
MEDIUMBLOB
KEY
PRIMARY
IX
idx_type
IX
idx_title
IX
idx_md5
IX
idx_url
IX
idx_language
IX
idx_published_list
IX
idx_published_sale
joomla_user_mfa
PK
id  
INT(11)
NN
user_id  
INT(10)
NN
title  
VARCHAR(255)
NN
method  
VARCHAR(100)
NN
default  
TINYINT(4)
NN
options  
MEDIUMTEXT
NN
created_on  
DATETIME
NN
last_used  
DATETIME
tries  
INT(11)
NN
last_try  
DATETIME
KEY
PRIMARY
IX
idx_user_id
joomla_privacy_requests
PK
id  
INT(10)
NN
email  
VARCHAR(100)
NN
requested_at  
DATETIME
NN
status  
TINYINT(4)
NN
request_type  
VARCHAR(25)
NN
confirm_token  
VARCHAR(100)
NN
confirm_token_created_at  
DATETIME
KEY
PRIMARY
joomla_update_sites_extensions
PK
update_site_id  
INT(11)
NN
PK
extension_id  
INT(11)
NN
KEY
PRIMARY
joomla_user_keys
PK
id  
INT(10)
NN
user_id  
VARCHAR(150)
NN
token  
VARCHAR(255)
NN
AK
series  
VARCHAR(191)
NN
time  
VARCHAR(200)
NN
uastring  
VARCHAR(255)
NN
KEY
PRIMARY
KEY
series
IX
user_id
joomla_banner_clients
PK
id  
INT(11)
NN
name  
VARCHAR(255)
NN
contact  
VARCHAR(255)
NN
email  
VARCHAR(255)
NN
extrainfo  
TEXT
NN
state  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
metakey  
TEXT
own_prefix  
TINYINT(4)
NN
metakey_prefix  
VARCHAR(400)
NN
purchase_type  
TINYINT(4)
NN
track_clicks  
TINYINT(4)
NN
track_impressions  
TINYINT(4)
NN
KEY
PRIMARY
IX
idx_own_prefix
IX
idx_metakey_prefix
joomla_ucm_content
PK
core_content_id  
INT(10)
NN
core_type_alias  
VARCHAR(400)
NN
core_title  
VARCHAR(400)
NN
core_alias  
VARCHAR(400)
NN
core_body  
MEDIUMTEXT
core_state  
TINYINT(4)
NN
core_checked_out_time  
DATETIME
core_checked_out_user_id  
INT(10)
core_access  
INT(10)
NN
core_params  
TEXT
core_featured  
TINYINT(3)
NN
core_metadata  
VARCHAR(2048)
NN
core_created_user_id  
INT(10)
NN
core_created_by_alias  
VARCHAR(255)
NN
core_created_time  
DATETIME
NN
core_modified_user_id  
INT(10)
NN
core_modified_time  
DATETIME
NN
core_language  
CHAR(7)
NN
core_publish_up  
DATETIME
core_publish_down  
DATETIME
core_content_item_id  
INT(10)
NN
asset_id  
INT(10)
NN
core_images  
TEXT
core_urls  
TEXT
core_hits  
INT(10)
NN
core_version  
INT(10)
NN
core_ordering  
INT(11)
NN
core_metakey  
TEXT
core_metadesc  
TEXT
core_catid  
INT(10)
NN
core_type_id  
INT(10)
NN
KEY
PRIMARY
IX
tag_idx
IX
idx_access
IX
idx_alias
IX
idx_language
IX
idx_title
IX
idx_modified_time
IX
idx_created_time
IX
idx_content_type
IX
idx_core_modified_user_id
IX
idx_core_checked_out_user_id
IX
idx_core_created_user_id
IX
idx_core_type_id
joomla_banners
PK
id  
INT(11)
NN
cid  
INT(11)
NN
type  
INT(11)
NN
name  
VARCHAR(255)
NN
alias  
VARCHAR(400)
NN
imptotal  
INT(11)
NN
impmade  
INT(11)
NN
clicks  
INT(11)
NN
clickurl  
VARCHAR(2048)
NN
state  
TINYINT(4)
NN
catid  
INT(10)
NN
description  
TEXT
NN
custombannercode  
VARCHAR(2048)
NN
sticky  
TINYINT(3)
NN
ordering  
INT(11)
NN
metakey  
TEXT
params  
TEXT
NN
own_prefix  
TINYINT(4)
NN
metakey_prefix  
VARCHAR(400)
NN
purchase_type  
TINYINT(4)
NN
track_clicks  
TINYINT(4)
NN
track_impressions  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
publish_up  
DATETIME
publish_down  
DATETIME
reset  
DATETIME
created  
DATETIME
NN
language  
CHAR(7)
NN
created_by  
INT(10)
NN
created_by_alias  
VARCHAR(255)
NN
modified  
DATETIME
NN
modified_by  
INT(10)
NN
version  
INT(10)
NN
KEY
PRIMARY
IX
idx_state
IX
idx_own_prefix
IX
idx_metakey_prefix
IX
idx_banner_catid
IX
idx_language
joomla_messages_cfg
AK
user_id  
INT(10)
NN
AK
cfg_name  
VARCHAR(100)
NN
cfg_value  
VARCHAR(255)
NN
KEY
idx_user_var_name
KEY
Primary key
joomla_workflow_stages
PK
id  
INT(11)
NN
asset_id  
INT(11)
ordering  
INT(11)
NN
workflow_id  
INT(11)
NN
published  
TINYINT(4)
NN
title  
VARCHAR(255)
NN
description  
TEXT
NN
default  
TINYINT(4)
NN
checked_out_time  
DATETIME
checked_out  
INT(10)
KEY
PRIMARY
IX
idx_workflow_id
IX
idx_checked_out
IX
idx_title
IX
idx_asset_id
IX
idx_default
joomla_fields_categories
PK
field_id  
INT(11)
NN
PK
category_id  
INT(11)
NN
KEY
PRIMARY
joomla_content_rating
PK
content_id  
INT(11)
NN
rating_sum  
INT(10)
NN
rating_count  
INT(10)
NN
lastip  
VARCHAR(50)
NN
KEY
PRIMARY
joomla_fields_groups
PK
id  
INT(10)
NN
asset_id  
INT(10)
NN
context  
VARCHAR(255)
NN
title  
VARCHAR(255)
NN
note  
VARCHAR(255)
NN
description  
TEXT
NN
state  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
ordering  
INT(11)
NN
params  
TEXT
NN
language  
CHAR(7)
NN
created  
DATETIME
NN
created_by  
INT(10)
NN
modified  
DATETIME
NN
modified_by  
INT(10)
NN
access  
INT(11)
NN
KEY
PRIMARY
IX
idx_checkout
IX
idx_state
IX
idx_created_by
IX
idx_access
IX
idx_context
IX
idx_language
joomla_overrider
PK
id  
INT(11)
NN
constant  
VARCHAR(255)
NN
string  
TEXT
NN
file  
VARCHAR(255)
NN
KEY
PRIMARY
joomla_banner_tracks
PK
track_date  
DATETIME
NN
PK
track_type  
INT(10)
NN
PK
banner_id  
INT(10)
NN
count  
INT(10)
NN
KEY
PRIMARY
IX
idx_track_date
IX
idx_track_type
IX
idx_banner_id
joomla_scheduler_tasks
PK
id  
INT(10)
NN
asset_id  
INT(10)
NN
title  
VARCHAR(255)
NN
type  
VARCHAR(128)
NN
execution_rules  
TEXT
cron_rules  
TEXT
state  
TINYINT(4)
NN
last_exit_code  
INT(11)
NN
last_execution  
DATETIME
next_execution  
DATETIME
times_executed  
INT(11)
times_failed  
INT(11)
locked  
DATETIME
priority  
SMALLINT(6)
NN
ordering  
INT(11)
NN
cli_exclusive  
SMALLINT(6)
NN
params  
TEXT
NN
note  
TEXT
created  
DATETIME
NN
created_by  
INT(10)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
KEY
PRIMARY
IX
idx_type
IX
idx_state
IX
idx_last_exit
IX
idx_next_exec
IX
idx_locked
IX
idx_priority
IX
idx_cli_exclusive
IX
idx_checked_out
joomla_mail_templates
PK
template_id  
VARCHAR(127)
NN
extension  
VARCHAR(127)
NN
PK
language  
CHAR(7)
NN
subject  
VARCHAR(255)
NN
body  
TEXT
NN
htmlbody  
MEDIUMTEXT
NN
attachments  
TEXT
NN
params  
TEXT
NN
KEY
PRIMARY
joomla_schemas
PK
extension_id  
INT(11)
NN
PK
version_id  
VARCHAR(20)
NN
KEY
PRIMARY
joomla_webauthn_credentials
PK
id  
VARCHAR(1000)
NN
user_id  
VARCHAR(128)
NN
label  
VARCHAR(190)
NN
credential  
MEDIUMTEXT
NN
KEY
PRIMARY
IX
user_id
joomla_user_notes
PK
id  
INT(10)
NN
user_id  
INT(10)
NN
catid  
INT(10)
NN
subject  
VARCHAR(100)
NN
body  
TEXT
NN
state  
TINYINT(4)
NN
checked_out  
INT(10)
checked_out_time  
DATETIME
created_user_id  
INT(10)
NN
created_time  
DATETIME
NN
modified_user_id  
INT(10)
NN
modified_time  
DATETIME
NN
review_time  
DATETIME
publish_up  
DATETIME
publish_down  
DATETIME
KEY
PRIMARY
IX
idx_user_id
IX
idx_category_id
joomla_finder_links_terms
PK
link_id  
INT(10)
NN
PK
term_id  
INT(10)
NN
weight  
FLOAT
NN
KEY
PRIMARY
IX
idx_term_weight
IX
idx_link_term_weight
joomla_guidedtour_steps
PK
id  
INT(11)
NN
tour_id  
INT(11)
NN
title  
VARCHAR(255)
NN
published  
TINYINT(4)
NN
description  
TEXT
NN
ordering  
INT(11)
NN
position  
VARCHAR(255)
NN
target  
VARCHAR(255)
NN
type  
INT(11)
NN
interactive_type  
INT(11)
NN
url  
VARCHAR(255)
NN
created  
DATETIME
NN
created_by  
INT(10)
NN
modified  
DATETIME
NN
modified_by  
INT(10)
NN
checked_out_time  
DATETIME
checked_out  
INT(10)
language  
VARCHAR(7)
NN
note  
VARCHAR(255)
NN
KEY
PRIMARY
IX
idx_tour
IX
idx_state
IX
idx_language
joomla_associations
PK
id  
INT(11)
NN
PK
context  
VARCHAR(50)
NN
key  
CHAR(32)
NN
KEY
PRIMARY
IX
idx_key
joomla_guidedtours
PK
id  
INT(11)
NN
title  
VARCHAR(255)
NN
description  
TEXT
NN
ordering  
INT(11)
NN
extensions  
TEXT
NN
url  
VARCHAR(255)
NN
created  
DATETIME
NN
created_by  
INT(11)
NN
modified  
DATETIME
NN
modified_by  
INT(11)
NN
checked_out_time  
DATETIME
checked_out  
INT(10)
published  
TINYINT(4)
NN
language  
VARCHAR(7)
NN
note  
VARCHAR(255)
NN
access  
INT(10)
NN
KEY
PRIMARY
IX
idx_access
IX
idx_state
IX
idx_language
joomla_privacy_consents
PK
id  
INT(10)
NN
user_id  
INT(10)
NN
state  
INT(11)
NN
created  
DATETIME
NN
subject  
VARCHAR(255)
NN
body  
TEXT
NN
remind  
TINYINT(4)
NN
token  
VARCHAR(100)
NN
KEY
PRIMARY
IX
idx_user_id
joomla_viewlevels
PK
id  
INT(10)
NN
AK
title  
VARCHAR(100)
NN
ordering  
INT(11)
NN
rules  
VARCHAR(5120)
NN
KEY
PRIMARY
KEY
idx_assetgroup_title_lookup
joomla_postinstall_messages
PK
postinstall_message_id  
BIGINT(20)
NN
extension_id  
BIGINT(20)
NN
title_key  
VARCHAR(255)
NN
description_key  
VARCHAR(255)
NN
action_key  
VARCHAR(255)
NN
language_extension  
VARCHAR(255)
NN
language_client_id  
TINYINT(4)
NN
type  
VARCHAR(10)
NN
action_file  
VARCHAR(255)
action  
VARCHAR(255)
condition_file  
VARCHAR(255)
condition_method  
VARCHAR(255)
version_introduced  
VARCHAR(50)
NN
enabled  
TINYINT(4)
NN
KEY
PRIMARY
joomla_finder_terms
PK
term_id  
INT(10)
NN
AK
term  
VARCHAR(75)
NN
stem  
VARCHAR(75)
NN
common  
TINYINT(3)
NN
phrase  
TINYINT(3)
NN
weight  
FLOAT
NN
soundex  
VARCHAR(75)
NN
links  
INT(11)
NN
AK
language  
CHAR(7)
NN
KEY
PRIMARY
KEY
idx_term_language
IX
idx_stem
IX
idx_term_phrase
IX
idx_stem_phrase
IX
idx_soundex_phrase
IX
idx_language

Joomla Licenses

From Joomla! Documentation

https://docs.joomla.org/Joomla_Licenses

LUNA MODELER

WWW.DATENSEN.COM

Entity Relationship Diagram

Joomla - MariaDB

Documentation for project Joomla
Joomla
Project
Name
Joomla
Diagram
Name
Main Diagram
Report
Generated
11/6/2026 | 10:35:48 PM
tables
Name
joomla_action_logs
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
message_language_key
VARCHAR
255
Yes
Default value
''
message
TEXT
Yes
log_date
DATETIME
Yes
extension
VARCHAR
50
Yes
Default value
''
user_id
INT
11
Yes
Default value
0
item_id
INT
11
Yes
Default value
0
ip_address
VARCHAR
40
Yes
Default value
'0.0.0.0'
Indexes
idx_user_id
Column name
user_id
idx_user_id_logdate
Column name
user_id
Column name
log_date
idx_user_id_extension
Column name
user_id
Column name
extension
idx_extension_item_id
Column name
extension
Column name
item_id
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_action_logs_extensions
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
extension
VARCHAR
255
Yes
Default value
''
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_action_logs_users
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
user_id
INT
10
Yes
Yes
Unsigned
Yes
notify
TINYINT
3
Yes
Unsigned
Yes
extensions
TEXT
Yes
Indexes
idx_notify
Column name
notify
Keys
PRIMARY
Column in PRIMARY
user_id
Name
joomla_action_log_config
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
type_title
VARCHAR
255
Yes
Default value
''
type_alias
VARCHAR
255
Yes
Default value
''
id_holder
VARCHAR
255
title_holder
VARCHAR
255
table_name
VARCHAR
255
text_prefix
VARCHAR
255
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_assets
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
Description
Primary Key
parent_id
INT
11
Yes
Default value
0
Description
Nested set parent.
lft
INT
11
Yes
Default value
0
Description
Nested set lft.
rgt
INT
11
Yes
Default value
0
Description
Nested set rgt.
level
INT
10
Yes
Unsigned
Yes
Description
The cached level in the nested tree.
name
VARCHAR
50
Yes
Description
The unique name for the asset.
title
VARCHAR
100
Yes
Description
The descriptive title for the asset.
rules
VARCHAR
5120
Yes
Description
JSON encoded access control.
Indexes
idx_lft_rgt
Column name
lft
Column name
rgt
idx_parent_id
Column name
parent_id
Keys
PRIMARY
Column in PRIMARY
id
idx_asset_name
Column in idx_asset_name
name
Name
joomla_associations
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Description
A reference to the associated item.
context
VARCHAR
50
Yes
Yes
Description
The context of the associated item.
key
CHAR
32
Yes
Description
The key for the association computed from an md5 on associated ids.
Indexes
idx_key
Column name
key
Keys
PRIMARY
Column in PRIMARY
context
Column in PRIMARY
id
Name
joomla_banners
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
cid
INT
11
Yes
Default value
0
type
INT
11
Yes
Default value
0
name
VARCHAR
255
Yes
Default value
''
alias
VARCHAR
400
Yes
Default value
''
Collation
utf8mb4_bin
imptotal
INT
11
Yes
Default value
0
impmade
INT
11
Yes
Default value
0
clicks
INT
11
Yes
Default value
0
clickurl
VARCHAR
2048
Yes
Default value
''
state
TINYINT
4
Yes
Default value
0
catid
INT
10
Yes
Default value
0
Unsigned
Yes
description
TEXT
Yes
custombannercode
VARCHAR
2048
Yes
sticky
TINYINT
3
Yes
Default value
0
Unsigned
Yes
ordering
INT
11
Yes
Default value
0
metakey
TEXT
params
TEXT
Yes
own_prefix
TINYINT
4
Yes
Default value
0
metakey_prefix
VARCHAR
400
Yes
Default value
''
purchase_type
TINYINT
4
Yes
Default value
-1
track_clicks
TINYINT
4
Yes
Default value
-1
track_impressions
TINYINT
4
Yes
Default value
-1
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
publish_up
DATETIME
publish_down
DATETIME
reset
DATETIME
created
DATETIME
Yes
language
CHAR
7
Yes
Default value
''
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
created_by_alias
VARCHAR
255
Yes
Default value
''
modified
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
version
INT
10
Yes
Default value
1
Unsigned
Yes
Indexes
idx_state
Column name
state
idx_own_prefix
Column name
own_prefix
idx_metakey_prefix
Column name
metakey_prefix
idx_banner_catid
Column name
catid
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_banner_clients
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
name
VARCHAR
255
Yes
Default value
''
contact
VARCHAR
255
Yes
Default value
''
email
VARCHAR
255
Yes
Default value
''
extrainfo
TEXT
Yes
state
TINYINT
4
Yes
Default value
0
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
metakey
TEXT
own_prefix
TINYINT
4
Yes
Default value
0
metakey_prefix
VARCHAR
400
Yes
Default value
''
purchase_type
TINYINT
4
Yes
Default value
-1
track_clicks
TINYINT
4
Yes
Default value
-1
track_impressions
TINYINT
4
Yes
Default value
-1
Indexes
idx_own_prefix
Column name
own_prefix
idx_metakey_prefix
Column name
metakey_prefix
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_banner_tracks
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
track_date
DATETIME
Yes
Yes
track_type
INT
10
Yes
Yes
Unsigned
Yes
banner_id
INT
10
Yes
Yes
Unsigned
Yes
count
INT
10
Yes
Default value
0
Unsigned
Yes
Indexes
idx_track_date
Column name
track_date
idx_track_type
Column name
track_type
idx_banner_id
Column name
banner_id
Keys
PRIMARY
Column in PRIMARY
track_date
Column in PRIMARY
track_type
Column in PRIMARY
banner_id
Name
joomla_categories
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
FK to the #__assets table.
parent_id
INT
10
Yes
Default value
0
Unsigned
Yes
lft
INT
11
Yes
Default value
0
rgt
INT
11
Yes
Default value
0
level
INT
10
Yes
Default value
0
Unsigned
Yes
path
VARCHAR
400
Yes
Default value
''
extension
VARCHAR
50
Yes
Default value
''
title
VARCHAR
255
Yes
Default value
''
alias
VARCHAR
400
Yes
Default value
''
Collation
utf8mb4_bin
note
VARCHAR
255
Yes
Default value
''
description
MEDIUMTEXT
published
TINYINT
4
Yes
Default value
0
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
access
INT
10
Yes
Default value
0
Unsigned
Yes
params
TEXT
metadesc
VARCHAR
1024
Yes
Default value
''
Description
The meta description for the page.
metakey
VARCHAR
1024
Yes
Default value
''
Description
The keywords for the page.
metadata
VARCHAR
2048
Yes
Default value
''
Description
JSON encoded metadata properties.
created_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
created_time
DATETIME
Yes
modified_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
modified_time
DATETIME
Yes
hits
INT
10
Yes
Default value
0
Unsigned
Yes
language
CHAR
7
Yes
Default value
''
version
INT
10
Yes
Default value
1
Unsigned
Yes
Indexes
cat_idx
Column name
extension
Column name
published
Column name
access
idx_access
Column name
access
idx_checkout
Column name
checked_out
idx_path
Column name
path
idx_left_right
Column name
lft
Column name
rgt
idx_alias
Column name
alias
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_contact_details
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
name
VARCHAR
255
Yes
alias
VARCHAR
400
Yes
Collation
utf8mb4_bin
con_position
VARCHAR
255
address
TEXT
suburb
VARCHAR
100
state
VARCHAR
100
country
VARCHAR
100
postcode
VARCHAR
100
telephone
VARCHAR
255
fax
VARCHAR
255
misc
MEDIUMTEXT
image
VARCHAR
255
email_to
VARCHAR
255
default_con
TINYINT
3
Yes
Default value
0
Unsigned
Yes
published
TINYINT
4
Yes
Default value
0
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
ordering
INT
11
Yes
Default value
0
params
TEXT
Yes
user_id
INT
11
Yes
Default value
0
catid
INT
11
Yes
Default value
0
access
INT
10
Yes
Default value
0
Unsigned
Yes
mobile
VARCHAR
255
Yes
Default value
''
webpage
VARCHAR
255
Yes
Default value
''
sortname1
VARCHAR
255
Yes
Default value
''
sortname2
VARCHAR
255
Yes
Default value
''
sortname3
VARCHAR
255
Yes
Default value
''
language
VARCHAR
7
Yes
created
DATETIME
Yes
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
created_by_alias
VARCHAR
255
Yes
Default value
''
modified
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
metakey
TEXT
metadesc
TEXT
Yes
metadata
TEXT
Yes
featured
TINYINT
3
Yes
Default value
0
Unsigned
Yes
Description
Set if contact is featured.
publish_up
DATETIME
publish_down
DATETIME
version
INT
10
Yes
Default value
1
Unsigned
Yes
hits
INT
10
Yes
Default value
0
Unsigned
Yes
Indexes
idx_access
Column name
access
idx_checkout
Column name
checked_out
idx_state
Column name
published
idx_catid
Column name
catid
idx_createdby
Column name
created_by
idx_featured_catid
Column name
featured
Column name
catid
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_content
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
FK to the #__assets table.
title
VARCHAR
255
Yes
Default value
''
alias
VARCHAR
400
Yes
Default value
''
Collation
utf8mb4_bin
introtext
MEDIUMTEXT
Yes
fulltext
MEDIUMTEXT
Yes
state
TINYINT
4
Yes
Default value
0
catid
INT
10
Yes
Default value
0
Unsigned
Yes
created
DATETIME
Yes
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
created_by_alias
VARCHAR
255
Yes
Default value
''
modified
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
publish_up
DATETIME
publish_down
DATETIME
images
TEXT
Yes
urls
TEXT
Yes
attribs
VARCHAR
5120
Yes
version
INT
10
Yes
Default value
1
Unsigned
Yes
ordering
INT
11
Yes
Default value
0
metakey
TEXT
metadesc
TEXT
Yes
access
INT
10
Yes
Default value
0
Unsigned
Yes
hits
INT
10
Yes
Default value
0
Unsigned
Yes
metadata
TEXT
Yes
featured
TINYINT
3
Yes
Default value
0
Unsigned
Yes
Description
Set if article is featured.
language
CHAR
7
Yes
Description
The language code for the article.
note
VARCHAR
255
Yes
Default value
''
Indexes
idx_access
Column name
access
idx_checkout
Column name
checked_out
idx_state
Column name
state
idx_catid
Column name
catid
idx_createdby
Column name
created_by
idx_featured_catid
Column name
featured
Column name
catid
idx_language
Column name
language
idx_alias
Column name
alias
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_contentitem_tag_map
Description
Maps items from content tables to tags
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
type_alias
VARCHAR
255
Yes
Default value
''
core_content_id
INT
10
Yes
Unsigned
Yes
Description
PK from the core content table
content_item_id
INT
11
Yes
Description
PK from the content type table
tag_id
INT
10
Yes
Unsigned
Yes
Description
PK from the tag table
tag_date
TIMESTAMP
Yes
Default value
current_timestamp()
Description
Date of most recent save for this tag-item
type_id
MEDIUMINT
9
Yes
Description
PK from the content_type table
Indexes
idx_tag_type
Column name
tag_id
Column name
type_id
idx_date_id
Column name
tag_date
Column name
tag_id
idx_core_content_id
Column name
core_content_id
Keys
uc_ItemnameTagid
Column in uc_ItemnameTagid
type_id
Column in uc_ItemnameTagid
content_item_id
Column in uc_ItemnameTagid
tag_id
Primary key
Name
joomla_content_frontpage
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
content_id
INT
11
Yes
Yes
Default value
0
ordering
INT
11
Yes
Default value
0
featured_up
DATETIME
featured_down
DATETIME
Keys
PRIMARY
Column in PRIMARY
content_id
Name
joomla_content_rating
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
content_id
INT
11
Yes
Yes
Default value
0
rating_sum
INT
10
Yes
Default value
0
Unsigned
Yes
rating_count
INT
10
Yes
Default value
0
Unsigned
Yes
lastip
VARCHAR
50
Yes
Default value
''
Keys
PRIMARY
Column in PRIMARY
content_id
Name
joomla_content_types
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
type_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
type_title
VARCHAR
255
Yes
Default value
''
type_alias
VARCHAR
400
Yes
Default value
''
table
VARCHAR
2048
Yes
Default value
''
rules
TEXT
Yes
field_mappings
TEXT
Yes
router
VARCHAR
255
Yes
Default value
''
content_history_options
VARCHAR
5120
Description
JSON string for com_contenthistory options
Indexes
idx_alias
Column name
type_alias
Keys
PRIMARY
Column in PRIMARY
type_id
Name
joomla_extensions
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
extension_id
INT
11
Yes
Yes
Autoincrement
Yes
package_id
INT
11
Yes
Default value
0
Description
Parent package ID for extensions installed as a package.
name
VARCHAR
100
Yes
type
VARCHAR
20
Yes
element
VARCHAR
100
Yes
changelogurl
TEXT
folder
VARCHAR
100
Yes
client_id
TINYINT
4
Yes
enabled
TINYINT
4
Yes
Default value
0
access
INT
10
Yes
Default value
1
Unsigned
Yes
protected
TINYINT
4
Yes
Default value
0
Description
Flag to indicate if the extension is protected. Protected extensions cannot be disabled.
locked
TINYINT
4
Yes
Default value
0
Description
Flag to indicate if the extension is locked. Locked extensions cannot be uninstalled.
manifest_cache
TEXT
Yes
params
TEXT
Yes
custom_data
TEXT
Yes
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
ordering
INT
11
Default value
0
state
INT
11
Default value
0
note
VARCHAR
255
Indexes
element_clientid
Column name
element
Column name
client_id
element_folder_clientid
Column name
element
Column name
folder
Column name
client_id
extension
Column name
type
Column name
element
Column name
folder
Column name
client_id
Keys
PRIMARY
Column in PRIMARY
extension_id
Name
joomla_fields
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
context
VARCHAR
255
Yes
Default value
''
group_id
INT
10
Yes
Default value
0
Unsigned
Yes
title
VARCHAR
255
Yes
Default value
''
name
VARCHAR
255
Yes
Default value
''
label
VARCHAR
255
Yes
Default value
''
default_value
TEXT
type
VARCHAR
255
Yes
Default value
'text'
note
VARCHAR
255
Yes
Default value
''
description
TEXT
Yes
state
TINYINT
4
Yes
Default value
0
required
TINYINT
4
Yes
Default value
0
only_use_in_subform
TINYINT
4
Yes
Default value
0
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
ordering
INT
11
Yes
Default value
0
params
TEXT
Yes
fieldparams
TEXT
Yes
language
CHAR
7
Yes
Default value
''
created_time
DATETIME
Yes
created_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
modified_time
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
access
INT
11
Yes
Default value
1
Indexes
idx_checkout
Column name
checked_out
idx_state
Column name
state
idx_created_user_id
Column name
created_user_id
idx_access
Column name
access
idx_context
Column name
context
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_fields_categories
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
field_id
INT
11
Yes
Yes
Default value
0
category_id
INT
11
Yes
Yes
Default value
0
Keys
PRIMARY
Column in PRIMARY
field_id
Column in PRIMARY
category_id
Name
joomla_fields_groups
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
context
VARCHAR
255
Yes
Default value
''
title
VARCHAR
255
Yes
Default value
''
note
VARCHAR
255
Yes
Default value
''
description
TEXT
Yes
state
TINYINT
4
Yes
Default value
0
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
ordering
INT
11
Yes
Default value
0
params
TEXT
Yes
language
CHAR
7
Yes
Default value
''
created
DATETIME
Yes
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
modified
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
access
INT
11
Yes
Default value
1
Indexes
idx_checkout
Column name
checked_out
idx_state
Column name
state
idx_created_by
Column name
created_by
idx_access
Column name
access
idx_context
Column name
context
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_fields_values
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
field_id
INT
10
Yes
Unsigned
Yes
item_id
VARCHAR
255
Yes
Description
Allow references to items which have strings as ids, eg. none db systems.
value
TEXT
Indexes
idx_field_id
Column name
field_id
idx_item_id
Column name
item_id
Keys
Primary key
Name
joomla_finder_filters
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
filter_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
title
VARCHAR
255
Yes
alias
VARCHAR
255
Yes
state
TINYINT
4
Yes
Default value
1
created
DATETIME
Yes
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
created_by_alias
VARCHAR
255
Yes
Default value
''
modified
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
map_count
INT
10
Yes
Default value
0
Unsigned
Yes
data
TEXT
params
MEDIUMTEXT
Keys
PRIMARY
Column in PRIMARY
filter_id
Name
joomla_finder_links
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
link_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
url
VARCHAR
255
Yes
route
VARCHAR
400
Yes
title
VARCHAR
400
description
TEXT
indexdate
DATETIME
Yes
md5sum
VARCHAR
32
published
TINYINT
4
Yes
Default value
1
state
INT
11
Yes
Default value
1
access
INT
11
Yes
Default value
0
language
CHAR
7
Yes
Default value
''
publish_start_date
DATETIME
publish_end_date
DATETIME
start_date
DATETIME
end_date
DATETIME
list_price
DOUBLE
Yes
Default value
0
Unsigned
Yes
sale_price
DOUBLE
Yes
Default value
0
Unsigned
Yes
type_id
INT
11
Yes
object
MEDIUMBLOB
Indexes
idx_type
Column name
type_id
idx_title
Column name
title
idx_md5
Column name
md5sum
idx_url
Column name
url
idx_language
Column name
language
idx_published_list
Column name
published
Column name
state
Column name
access
Column name
publish_start_date
Column name
publish_end_date
Column name
list_price
idx_published_sale
Column name
published
Column name
state
Column name
access
Column name
publish_start_date
Column name
publish_end_date
Column name
sale_price
Keys
PRIMARY
Column in PRIMARY
link_id
Name
joomla_finder_links_terms
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
link_id
INT
10
Yes
Yes
Unsigned
Yes
term_id
INT
10
Yes
Yes
Unsigned
Yes
weight
FLOAT
Yes
Default value
0
Unsigned
Yes
Indexes
idx_term_weight
Column name
term_id
Column name
weight
idx_link_term_weight
Column name
link_id
Column name
term_id
Column name
weight
Keys
PRIMARY
Column in PRIMARY
link_id
Column in PRIMARY
term_id
Name
joomla_finder_logging
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
searchterm
VARCHAR
255
Yes
Default value
''
md5sum
VARCHAR
32
Yes
Yes
Default value
''
query
BLOB
Yes
hits
INT
11
Yes
Default value
1
results
INT
11
Yes
Default value
0
Indexes
searchterm
Column name
searchterm
Keys
PRIMARY
Column in PRIMARY
md5sum
Name
joomla_finder_taxonomy
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
parent_id
INT
10
Yes
Default value
0
Unsigned
Yes
lft
INT
11
Yes
Default value
0
rgt
INT
11
Yes
Default value
0
level
INT
10
Yes
Default value
0
Unsigned
Yes
path
VARCHAR
400
Yes
Default value
''
title
VARCHAR
255
Yes
Default value
''
alias
VARCHAR
400
Yes
Default value
''
state
TINYINT
3
Yes
Default value
1
Unsigned
Yes
access
TINYINT
3
Yes
Default value
1
Unsigned
Yes
language
CHAR
7
Yes
Default value
''
Indexes
idx_state
Column name
state
idx_access
Column name
access
idx_path
Column name
path
idx_level
Column name
level
idx_left_right
Column name
lft
Column name
rgt
idx_alias
Column name
alias
idx_language
Column name
language
idx_parent_published
Column name
parent_id
Column name
state
Column name
access
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_finder_taxonomy_map
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
link_id
INT
10
Yes
Yes
Unsigned
Yes
node_id
INT
10
Yes
Yes
Unsigned
Yes
Indexes
link_id
Column name
link_id
node_id
Column name
node_id
Keys
PRIMARY
Column in PRIMARY
link_id
Column in PRIMARY
node_id
Name
joomla_finder_terms
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
term_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
term
VARCHAR
75
Yes
Collation
utf8mb4_bin
stem
VARCHAR
75
Yes
Default value
''
Collation
utf8mb4_bin
common
TINYINT
3
Yes
Default value
0
Unsigned
Yes
phrase
TINYINT
3
Yes
Default value
0
Unsigned
Yes
weight
FLOAT
Yes
Default value
0
Unsigned
Yes
soundex
VARCHAR
75
Yes
Default value
''
Collation
utf8mb4_bin
links
INT
11
Yes
Default value
0
language
CHAR
7
Yes
Default value
''
Indexes
idx_stem
Column name
stem
idx_term_phrase
Column name
term
Column name
phrase
idx_stem_phrase
Column name
stem
Column name
phrase
idx_soundex_phrase
Column name
soundex
Column name
phrase
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
term_id
idx_term_language
Column in idx_term_language
term
Column in idx_term_language
language
Name
joomla_finder_terms_common
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
term
VARCHAR
75
Yes
Default value
''
Collation
utf8mb4_bin
language
CHAR
7
Yes
Default value
''
custom
INT
11
Yes
Default value
0
Indexes
idx_lang
Column name
language
Keys
idx_term_language
Column in idx_term_language
term
Column in idx_term_language
language
Primary key
Name
joomla_finder_tokens
Properties
Database
joomla
Engine
MEMORY
Row format
Fixed
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
term
VARCHAR
75
Yes
Collation
utf8mb4_bin
stem
VARCHAR
75
Yes
Default value
''
Collation
utf8mb4_bin
common
TINYINT
3
Yes
Default value
0
Unsigned
Yes
phrase
TINYINT
3
Yes
Default value
0
Unsigned
Yes
weight
FLOAT
Yes
Default value
1
Unsigned
Yes
context
TINYINT
3
Yes
Default value
2
Unsigned
Yes
language
CHAR
7
Yes
Default value
''
Indexes
idx_word
Column name
term
idx_stem
Column name
stem
idx_context
Column name
context
idx_language
Column name
language
Keys
Primary key
Name
joomla_finder_tokens_aggregate
Properties
Database
joomla
Engine
MEMORY
Row format
Fixed
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
term_id
INT
10
Yes
Unsigned
Yes
term
VARCHAR
75
Yes
Collation
utf8mb4_bin
stem
VARCHAR
75
Yes
Default value
''
Collation
utf8mb4_bin
common
TINYINT
3
Yes
Default value
0
Unsigned
Yes
phrase
TINYINT
3
Yes
Default value
0
Unsigned
Yes
term_weight
FLOAT
Yes
Default value
0
Unsigned
Yes
context
TINYINT
3
Yes
Default value
2
Unsigned
Yes
context_weight
FLOAT
Yes
Default value
0
Unsigned
Yes
total_weight
FLOAT
Yes
Default value
0
Unsigned
Yes
language
CHAR
7
Yes
Default value
''
Indexes
token
Column name
term
keyword_id
Column name
term_id
Keys
Primary key
Name
joomla_finder_types
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
title
VARCHAR
100
Yes
mime
VARCHAR
100
Yes
Default value
''
Keys
PRIMARY
Column in PRIMARY
id
title
Column in title
title
Name
joomla_guidedtours
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
title
VARCHAR
255
Yes
Default value
''
description
TEXT
Yes
ordering
INT
11
Yes
Default value
0
extensions
TEXT
Yes
url
VARCHAR
255
Yes
created
DATETIME
Yes
created_by
INT
11
Yes
Default value
0
modified
DATETIME
Yes
modified_by
INT
11
Yes
Default value
0
checked_out_time
DATETIME
checked_out
INT
10
Unsigned
Yes
published
TINYINT
4
Yes
Default value
0
language
VARCHAR
7
Yes
note
VARCHAR
255
Yes
Default value
''
access
INT
10
Yes
Default value
0
Unsigned
Yes
Indexes
idx_access
Column name
access
idx_state
Column name
published
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_guidedtour_steps
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
tour_id
INT
11
Yes
Default value
0
title
VARCHAR
255
Yes
published
TINYINT
4
Yes
Default value
0
description
TEXT
Yes
ordering
INT
11
Yes
Default value
0
position
VARCHAR
255
Yes
target
VARCHAR
255
Yes
type
INT
11
Yes
interactive_type
INT
11
Yes
Default value
1
url
VARCHAR
255
Yes
created
DATETIME
Yes
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
modified
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
checked_out_time
DATETIME
checked_out
INT
10
Unsigned
Yes
language
VARCHAR
7
Yes
note
VARCHAR
255
Yes
Default value
''
Indexes
idx_tour
Column name
tour_id
idx_state
Column name
published
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_history
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
version_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
item_id
VARCHAR
50
Yes
version_note
VARCHAR
255
Yes
Default value
''
Description
Optional version name
save_date
DATETIME
Yes
editor_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
character_count
INT
10
Yes
Default value
0
Unsigned
Yes
Description
Number of characters in this version.
sha1_hash
VARCHAR
50
Yes
Default value
''
Description
SHA1 hash of the version_data column.
version_data
MEDIUMTEXT
Yes
Description
json-encoded string of version data
keep_forever
TINYINT
4
Yes
Default value
0
Description
0=auto delete; 1=keep
Indexes
idx_ucm_item_id
Column name
item_id
idx_save_date
Column name
save_date
Keys
PRIMARY
Column in PRIMARY
version_id
Name
joomla_languages
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
lang_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
lang_code
CHAR
7
Yes
Collation
utf8mb4_bin
title
VARCHAR
50
Yes
title_native
VARCHAR
50
Yes
sef
VARCHAR
50
Yes
image
VARCHAR
50
Yes
description
VARCHAR
512
Yes
metakey
TEXT
metadesc
TEXT
Yes
sitename
VARCHAR
1024
Yes
Default value
''
published
INT
11
Yes
Default value
0
access
INT
10
Yes
Default value
0
Unsigned
Yes
ordering
INT
11
Yes
Default value
0
Indexes
idx_access
Column name
access
idx_ordering
Column name
ordering
Keys
PRIMARY
Column in PRIMARY
lang_id
idx_sef
Column in idx_sef
sef
idx_langcode
Column in idx_langcode
lang_code
Name
joomla_mail_templates
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
template_id
VARCHAR
127
Yes
Yes
Default value
''
extension
VARCHAR
127
Yes
Default value
''
language
CHAR
7
Yes
Yes
Default value
''
subject
VARCHAR
255
Yes
Default value
''
body
TEXT
Yes
htmlbody
MEDIUMTEXT
Yes
attachments
TEXT
Yes
params
TEXT
Yes
Keys
PRIMARY
Column in PRIMARY
template_id
Column in PRIMARY
language
Name
joomla_menu
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
menutype
VARCHAR
24
Yes
Description
The type of menu this item belongs to. FK to #__menu_types.menutype
title
VARCHAR
255
Yes
Description
The display title of the menu item.
alias
VARCHAR
400
Yes
Collation
utf8mb4_bin
Description
The SEF alias of the menu item.
note
VARCHAR
255
Yes
Default value
''
path
VARCHAR
1024
Yes
Description
The computed path of the menu item based on the alias field.
link
VARCHAR
1024
Yes
Description
The actually link the menu item refers to.
type
VARCHAR
16
Yes
Description
The type of link: Component, URL, Alias, Separator
published
TINYINT
4
Yes
Default value
0
Description
The published state of the menu link.
parent_id
INT
10
Yes
Default value
1
Unsigned
Yes
Description
The parent menu item in the menu tree.
level
INT
10
Yes
Default value
0
Unsigned
Yes
Description
The relative level in the tree.
component_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
FK to #__extensions.id
checked_out
INT
10
Unsigned
Yes
Description
FK to #__users.id
checked_out_time
DATETIME
Description
The time the menu item was checked out.
browserNav
TINYINT
4
Yes
Default value
0
Description
The click behaviour of the link.
access
INT
10
Yes
Default value
0
Unsigned
Yes
Description
The access level required to view the menu item.
img
VARCHAR
255
Yes
Description
The image of the menu item.
template_style_id
INT
10
Yes
Default value
0
Unsigned
Yes
params
TEXT
Yes
Description
JSON encoded data for the menu item.
lft
INT
11
Yes
Default value
0
Description
Nested set lft.
rgt
INT
11
Yes
Default value
0
Description
Nested set rgt.
home
TINYINT
3
Yes
Default value
0
Unsigned
Yes
Description
Indicates if this menu item is the home or default page.
language
CHAR
7
Yes
Default value
''
client_id
TINYINT
4
Yes
Default value
0
publish_up
DATETIME
publish_down
DATETIME
Indexes
idx_componentid
Column name
component_id
Column name
menutype
Column name
published
Column name
access
idx_menutype
Column name
menutype
idx_left_right
Column name
lft
Column name
rgt
idx_alias
Column name
alias
idx_path
Column name
path
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
idx_client_id_parent_id_alias_language
Column in idx_client_id_parent_id_alias_language
client_id
Column in idx_client_id_parent_id_alias_language
parent_id
Column in idx_client_id_parent_id_alias_language
alias
Column in idx_client_id_parent_id_alias_language
language
Name
joomla_menu_types
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
menutype
VARCHAR
24
Yes
title
VARCHAR
48
Yes
description
VARCHAR
255
Yes
Default value
''
client_id
INT
11
Yes
Default value
0
Keys
PRIMARY
Column in PRIMARY
id
idx_menutype
Column in idx_menutype
menutype
Name
joomla_messages
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
message_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
user_id_from
INT
10
Yes
Default value
0
Unsigned
Yes
user_id_to
INT
10
Yes
Default value
0
Unsigned
Yes
folder_id
TINYINT
3
Yes
Default value
0
Unsigned
Yes
date_time
DATETIME
Yes
state
TINYINT
4
Yes
Default value
0
priority
TINYINT
3
Yes
Default value
0
Unsigned
Yes
subject
VARCHAR
255
Yes
Default value
''
message
TEXT
Yes
Indexes
useridto_state
Column name
user_id_to
Column name
state
Keys
PRIMARY
Column in PRIMARY
message_id
Name
joomla_messages_cfg
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
user_id
INT
10
Yes
Default value
0
Unsigned
Yes
cfg_name
VARCHAR
100
Yes
Default value
''
cfg_value
VARCHAR
255
Yes
Default value
''
Keys
idx_user_var_name
Column in idx_user_var_name
user_id
Column in idx_user_var_name
cfg_name
Primary key
Name
joomla_modules
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
FK to the #__assets table.
title
VARCHAR
100
Yes
Default value
''
note
VARCHAR
255
Yes
Default value
''
content
TEXT
ordering
INT
11
Yes
Default value
0
position
VARCHAR
50
Yes
Default value
''
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
publish_up
DATETIME
publish_down
DATETIME
published
TINYINT
4
Yes
Default value
0
module
VARCHAR
50
access
INT
10
Yes
Default value
0
Unsigned
Yes
showtitle
TINYINT
3
Yes
Default value
1
Unsigned
Yes
params
TEXT
Yes
client_id
TINYINT
4
Yes
Default value
0
language
CHAR
7
Yes
Indexes
published
Column name
published
Column name
access
newsfeeds
Column name
module
Column name
published
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_modules_menu
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
moduleid
INT
11
Yes
Yes
Default value
0
menuid
INT
11
Yes
Yes
Default value
0
Keys
PRIMARY
Column in PRIMARY
moduleid
Column in PRIMARY
menuid
Name
joomla_newsfeeds
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
catid
INT
11
Yes
Default value
0
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
name
VARCHAR
100
Yes
Default value
''
alias
VARCHAR
400
Yes
Default value
''
Collation
utf8mb4_bin
link
VARCHAR
2048
Yes
Default value
''
published
TINYINT
4
Yes
Default value
0
numarticles
INT
10
Yes
Default value
1
Unsigned
Yes
cache_time
INT
10
Yes
Default value
3600
Unsigned
Yes
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
ordering
INT
11
Yes
Default value
0
rtl
TINYINT
4
Yes
Default value
0
access
INT
10
Yes
Default value
0
Unsigned
Yes
language
CHAR
7
Yes
Default value
''
params
TEXT
Yes
created
DATETIME
Yes
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
created_by_alias
VARCHAR
255
Yes
Default value
''
modified
DATETIME
Yes
modified_by
INT
10
Yes
Default value
0
Unsigned
Yes
metakey
TEXT
metadesc
TEXT
Yes
metadata
TEXT
Yes
publish_up
DATETIME
publish_down
DATETIME
description
TEXT
Yes
version
INT
10
Yes
Default value
1
Unsigned
Yes
hits
INT
10
Yes
Default value
0
Unsigned
Yes
images
TEXT
Yes
Indexes
idx_access
Column name
access
idx_checkout
Column name
checked_out
idx_state
Column name
published
idx_catid
Column name
catid
idx_createdby
Column name
created_by
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_overrider
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
Description
Primary Key
constant
VARCHAR
255
Yes
string
TEXT
Yes
file
VARCHAR
255
Yes
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_postinstall_messages
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
postinstall_message_id
BIGINT
20
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
extension_id
BIGINT
20
Yes
Default value
700
Description
FK to #__extensions
title_key
VARCHAR
255
Yes
Default value
''
Description
Lang key for the title
description_key
VARCHAR
255
Yes
Default value
''
Description
Lang key for description
action_key
VARCHAR
255
Yes
Default value
''
language_extension
VARCHAR
255
Yes
Default value
'com_postinstall'
Description
Extension holding lang keys
language_client_id
TINYINT
4
Yes
Default value
1
type
VARCHAR
10
Yes
Default value
'link'
Description
Message type - message, link, action
action_file
VARCHAR
255
Default value
''
Description
RAD URI to the PHP file containing action method
action
VARCHAR
255
Default value
''
Description
Action method name or URL
condition_file
VARCHAR
255
Description
RAD URI to file holding display condition method
condition_method
VARCHAR
255
Description
Display condition method, must return boolean
version_introduced
VARCHAR
50
Yes
Default value
'3.2.0'
Description
Version when this message was introduced
enabled
TINYINT
4
Yes
Default value
1
Keys
PRIMARY
Column in PRIMARY
postinstall_message_id
Name
joomla_privacy_consents
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
user_id
INT
10
Yes
Default value
0
Unsigned
Yes
state
INT
11
Yes
Default value
1
created
DATETIME
Yes
subject
VARCHAR
255
Yes
Default value
''
body
TEXT
Yes
remind
TINYINT
4
Yes
Default value
0
token
VARCHAR
100
Yes
Default value
''
Indexes
idx_user_id
Column name
user_id
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_privacy_requests
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
email
VARCHAR
100
Yes
Default value
''
requested_at
DATETIME
Yes
status
TINYINT
4
Yes
Default value
0
request_type
VARCHAR
25
Yes
Default value
''
confirm_token
VARCHAR
100
Yes
Default value
''
confirm_token_created_at
DATETIME
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_redirect_links
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
old_url
VARCHAR
2048
Yes
new_url
VARCHAR
2048
referer
VARCHAR
2048
Yes
comment
VARCHAR
255
Yes
Default value
''
hits
INT
10
Yes
Default value
0
Unsigned
Yes
published
TINYINT
4
Yes
created_date
DATETIME
Yes
modified_date
DATETIME
Yes
header
SMALLINT
6
Yes
Default value
301
Indexes
idx_old_url
Column name
old_url
idx_link_modified
Column name
modified_date
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_scheduler_tasks
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
FK to the #__assets table.
title
VARCHAR
255
Yes
Default value
''
type
VARCHAR
128
Yes
Description
unique identifier for job defined by plugin
execution_rules
TEXT
Description
Execution Rules, Unprocessed
cron_rules
TEXT
Description
Processed execution rules, crontab-like JSON form
state
TINYINT
4
Yes
Default value
0
last_exit_code
INT
11
Yes
Default value
0
Description
Exit code when job was last run
last_execution
DATETIME
Description
Timestamp of last run
next_execution
DATETIME
Description
Timestamp of next (planned) run, referred for execution on trigger
times_executed
INT
11
Default value
0
Description
Count of successful triggers
times_failed
INT
11
Default value
0
Description
Count of failures
locked
DATETIME
priority
SMALLINT
6
Yes
Default value
0
ordering
INT
11
Yes
Default value
0
Description
Configurable list ordering
cli_exclusive
SMALLINT
6
Yes
Default value
0
Description
If 1, the task is only accessible via CLI
params
TEXT
Yes
note
TEXT
created
DATETIME
Yes
created_by
INT
10
Yes
Default value
0
Unsigned
Yes
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
Indexes
idx_type
Column name
type
idx_state
Column name
state
idx_last_exit
Column name
last_exit_code
idx_next_exec
Column name
next_execution
idx_locked
Column name
locked
idx_priority
Column name
priority
idx_cli_exclusive
Column name
cli_exclusive
idx_checked_out
Column name
checked_out
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_schemas
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
extension_id
INT
11
Yes
Yes
version_id
VARCHAR
20
Yes
Yes
Keys
PRIMARY
Column in PRIMARY
extension_id
Column in PRIMARY
version_id
Name
joomla_session
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
session_id
VARBINARY
192
Yes
Yes
client_id
TINYINT
3
Unsigned
Yes
guest
TINYINT
3
Default value
1
Unsigned
Yes
time
INT
11
Yes
Default value
0
data
MEDIUMTEXT
userid
INT
11
Default value
0
username
VARCHAR
150
Default value
''
Indexes
userid
Column name
userid
time
Column name
time
client_id_guest
Column name
client_id
Column name
guest
Keys
PRIMARY
Column in PRIMARY
session_id
Name
joomla_tags
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
parent_id
INT
10
Yes
Default value
0
Unsigned
Yes
lft
INT
11
Yes
Default value
0
rgt
INT
11
Yes
Default value
0
level
INT
10
Yes
Default value
0
Unsigned
Yes
path
VARCHAR
400
Yes
Default value
''
title
VARCHAR
255
Yes
alias
VARCHAR
400
Yes
Default value
''
Collation
utf8mb4_bin
note
VARCHAR
255
Yes
Default value
''
description
MEDIUMTEXT
Yes
published
TINYINT
4
Yes
Default value
0
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
access
INT
10
Yes
Default value
0
Unsigned
Yes
params
TEXT
Yes
metadesc
VARCHAR
1024
Yes
Description
The meta description for the page.
metakey
VARCHAR
1024
Yes
Default value
''
Description
The keywords for the page.
metadata
VARCHAR
2048
Yes
Description
JSON encoded metadata properties.
created_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
created_time
DATETIME
Yes
created_by_alias
VARCHAR
255
Yes
Default value
''
modified_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
modified_time
DATETIME
Yes
images
TEXT
Yes
urls
TEXT
Yes
hits
INT
10
Yes
Default value
0
Unsigned
Yes
language
CHAR
7
Yes
version
INT
10
Yes
Default value
1
Unsigned
Yes
publish_up
DATETIME
publish_down
DATETIME
Indexes
tag_idx
Column name
published
Column name
access
idx_access
Column name
access
idx_checkout
Column name
checked_out
idx_path
Column name
path
idx_left_right
Column name
lft
Column name
rgt
idx_alias
Column name
alias
idx_language
Column name
language
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_template_overrides
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
template
VARCHAR
50
Yes
Default value
''
hash_id
VARCHAR
255
Yes
Default value
''
extension_id
INT
11
Default value
0
state
TINYINT
4
Yes
Default value
0
action
VARCHAR
50
Yes
Default value
''
client_id
TINYINT
3
Yes
Default value
0
Unsigned
Yes
created_date
DATETIME
Yes
modified_date
DATETIME
Indexes
idx_template
Column name
template
idx_extension_id
Column name
extension_id
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_template_styles
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
template
VARCHAR
50
Yes
Default value
''
client_id
TINYINT
3
Yes
Default value
0
Unsigned
Yes
home
CHAR
7
Yes
Default value
'0'
title
VARCHAR
255
Yes
Default value
''
inheritable
TINYINT
4
Yes
Default value
0
parent
VARCHAR
50
Default value
''
params
TEXT
Yes
Indexes
idx_template
Column name
template
idx_client_id
Column name
client_id
idx_client_id_home
Column name
client_id
Column name
home
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_ucm_base
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
ucm_id
INT
10
Yes
Yes
Unsigned
Yes
ucm_item_id
INT
11
Yes
ucm_type_id
INT
11
Yes
ucm_language_id
INT
11
Yes
Indexes
idx_ucm_item_id
Column name
ucm_item_id
idx_ucm_type_id
Column name
ucm_type_id
idx_ucm_language_id
Column name
ucm_language_id
Keys
PRIMARY
Column in PRIMARY
ucm_id
Name
joomla_ucm_content
Description
Contains core content data in name spaced fields
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
core_content_id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
core_type_alias
VARCHAR
400
Yes
Default value
''
Description
FK to the content types table
core_title
VARCHAR
400
Yes
Default value
''
core_alias
VARCHAR
400
Yes
Default value
''
Collation
utf8mb4_bin
core_body
MEDIUMTEXT
core_state
TINYINT
4
Yes
Default value
0
core_checked_out_time
DATETIME
core_checked_out_user_id
INT
10
Unsigned
Yes
core_access
INT
10
Yes
Default value
0
Unsigned
Yes
core_params
TEXT
core_featured
TINYINT
3
Yes
Default value
0
Unsigned
Yes
core_metadata
VARCHAR
2048
Yes
Default value
''
Description
JSON encoded metadata properties.
core_created_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
core_created_by_alias
VARCHAR
255
Yes
Default value
''
core_created_time
DATETIME
Yes
core_modified_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
Most recent user that modified
core_modified_time
DATETIME
Yes
core_language
CHAR
7
Yes
Default value
''
core_publish_up
DATETIME
core_publish_down
DATETIME
core_content_item_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
ID from the individual type table
asset_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
FK to the #__assets table.
core_images
TEXT
core_urls
TEXT
core_hits
INT
10
Yes
Default value
0
Unsigned
Yes
core_version
INT
10
Yes
Default value
1
Unsigned
Yes
core_ordering
INT
11
Yes
Default value
0
core_metakey
TEXT
core_metadesc
TEXT
core_catid
INT
10
Yes
Default value
0
Unsigned
Yes
core_type_id
INT
10
Yes
Default value
0
Unsigned
Yes
Indexes
tag_idx
Column name
core_state
Column name
core_access
idx_access
Column name
core_access
idx_alias
Column name
core_alias
idx_language
Column name
core_language
idx_title
Column name
core_title
idx_modified_time
Column name
core_modified_time
idx_created_time
Column name
core_created_time
idx_content_type
Column name
core_type_alias
idx_core_modified_user_id
Column name
core_modified_user_id
idx_core_checked_out_user_id
Column name
core_checked_out_user_id
idx_core_created_user_id
Column name
core_created_user_id
idx_core_type_id
Column name
core_type_id
Keys
PRIMARY
Column in PRIMARY
core_content_id
Name
joomla_updates
Description
Available Updates
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
update_id
INT
11
Yes
Yes
Autoincrement
Yes
update_site_id
INT
11
Default value
0
extension_id
INT
11
Default value
0
name
VARCHAR
100
Default value
''
description
TEXT
Yes
element
VARCHAR
100
Default value
''
type
VARCHAR
20
Default value
''
folder
VARCHAR
20
Default value
''
client_id
TINYINT
4
Default value
0
version
VARCHAR
32
Default value
''
data
TEXT
Yes
detailsurl
TEXT
Yes
infourl
TEXT
Yes
changelogurl
TEXT
extra_query
VARCHAR
1000
Default value
''
Keys
PRIMARY
Column in PRIMARY
update_id
Name
joomla_update_sites
Description
Update Sites
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
update_site_id
INT
11
Yes
Yes
Autoincrement
Yes
name
VARCHAR
100
Default value
''
type
VARCHAR
20
Default value
''
location
TEXT
Yes
enabled
INT
11
Default value
0
last_check_timestamp
BIGINT
20
Default value
0
extra_query
VARCHAR
1000
Default value
''
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
Keys
PRIMARY
Column in PRIMARY
update_site_id
Name
joomla_update_sites_extensions
Description
Links extensions to update sites
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
update_site_id
INT
11
Yes
Yes
Default value
0
extension_id
INT
11
Yes
Yes
Default value
0
Keys
PRIMARY
Column in PRIMARY
update_site_id
Column in PRIMARY
extension_id
Name
joomla_usergroups
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
Description
Primary Key
parent_id
INT
10
Yes
Default value
0
Unsigned
Yes
Description
Adjacency List Reference Id
lft
INT
11
Yes
Default value
0
Description
Nested set lft.
rgt
INT
11
Yes
Default value
0
Description
Nested set rgt.
title
VARCHAR
100
Yes
Default value
''
Indexes
idx_usergroup_title_lookup
Column name
title
idx_usergroup_adjacency_lookup
Column name
parent_id
idx_usergroup_nested_set_lookup
Column name
lft
Column name
rgt
Keys
PRIMARY
Column in PRIMARY
id
idx_usergroup_parent_title_lookup
Column in idx_usergroup_parent_title_lookup
parent_id
Column in idx_usergroup_parent_title_lookup
title
Name
joomla_users
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
name
VARCHAR
400
Yes
Default value
''
username
VARCHAR
150
Yes
Default value
''
email
VARCHAR
100
Yes
Default value
''
password
VARCHAR
100
Yes
Default value
''
block
TINYINT
4
Yes
Default value
0
sendEmail
TINYINT
4
Default value
0
registerDate
DATETIME
Yes
lastvisitDate
DATETIME
activation
VARCHAR
100
Yes
Default value
''
params
TEXT
Yes
lastResetTime
DATETIME
Description
Date of last password reset
resetCount
INT
11
Yes
Default value
0
Description
Count of password resets since lastResetTime
otpKey
VARCHAR
1000
Yes
Default value
''
Description
Two factor authentication encrypted keys
otep
VARCHAR
1000
Yes
Default value
''
Description
Backup Codes
requireReset
TINYINT
4
Yes
Default value
0
Description
Require user to reset password on next login
authProvider
VARCHAR
100
Yes
Default value
''
Description
Name of used authentication plugin
Indexes
idx_name
Column name
name
idx_block
Column name
block
email
Column name
email
Keys
PRIMARY
Column in PRIMARY
id
idx_username
Column in idx_username
username
Name
joomla_user_keys
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
user_id
VARCHAR
150
Yes
token
VARCHAR
255
Yes
series
VARCHAR
191
Yes
time
VARCHAR
200
Yes
uastring
VARCHAR
255
Yes
Indexes
user_id
Column name
user_id
Keys
PRIMARY
Column in PRIMARY
id
series
Column in series
series
Name
joomla_user_mfa
Description
Multi-factor Authentication settings
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
user_id
INT
10
Yes
Unsigned
Yes
title
VARCHAR
255
Yes
Default value
''
method
VARCHAR
100
Yes
default
TINYINT
4
Yes
Default value
0
options
MEDIUMTEXT
Yes
created_on
DATETIME
Yes
last_used
DATETIME
tries
INT
11
Yes
Default value
0
last_try
DATETIME
Indexes
idx_user_id
Column name
user_id
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_user_notes
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
user_id
INT
10
Yes
Default value
0
Unsigned
Yes
catid
INT
10
Yes
Default value
0
Unsigned
Yes
subject
VARCHAR
100
Yes
Default value
''
body
TEXT
Yes
state
TINYINT
4
Yes
Default value
0
checked_out
INT
10
Unsigned
Yes
checked_out_time
DATETIME
created_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
created_time
DATETIME
Yes
modified_user_id
INT
10
Yes
Default value
0
Unsigned
Yes
modified_time
DATETIME
Yes
review_time
DATETIME
publish_up
DATETIME
publish_down
DATETIME
Indexes
idx_user_id
Column name
user_id
idx_category_id
Column name
catid
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_user_profiles
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
user_id
INT
11
Yes
profile_key
VARCHAR
100
Yes
profile_value
TEXT
Yes
ordering
INT
11
Yes
Default value
0
Keys
idx_user_id_profile_key
Column in idx_user_id_profile_key
user_id
Column in idx_user_id_profile_key
profile_key
Primary key
Name
joomla_user_usergroup_map
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
user_id
INT
10
Yes
Yes
Default value
0
Unsigned
Yes
Description
Foreign Key to #__users.id
group_id
INT
10
Yes
Yes
Default value
0
Unsigned
Yes
Description
Foreign Key to #__usergroups.id
Keys
PRIMARY
Column in PRIMARY
user_id
Column in PRIMARY
group_id
Name
joomla_viewlevels
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
10
Yes
Yes
Autoincrement
Yes
Unsigned
Yes
Description
Primary Key
title
VARCHAR
100
Yes
Default value
''
ordering
INT
11
Yes
Default value
0
rules
VARCHAR
5120
Yes
Description
JSON encoded access control.
Keys
PRIMARY
Column in PRIMARY
id
idx_assetgroup_title_lookup
Column in idx_assetgroup_title_lookup
title
Name
joomla_webauthn_credentials
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
VARCHAR
1000
Yes
Yes
Description
Credential ID
user_id
VARCHAR
128
Yes
Description
User handle
label
VARCHAR
190
Yes
Description
Human readable label
credential
MEDIUMTEXT
Yes
Description
Credential source data, JSON format
Indexes
user_id
Column name
user_id
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_workflows
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
asset_id
INT
11
Default value
0
published
TINYINT
4
Yes
Default value
0
title
VARCHAR
255
Yes
description
TEXT
Yes
extension
VARCHAR
50
Yes
default
TINYINT
4
Yes
Default value
0
ordering
INT
11
Yes
Default value
0
created
DATETIME
Yes
created_by
INT
11
Yes
Default value
0
modified
DATETIME
Yes
modified_by
INT
11
Yes
Default value
0
checked_out_time
DATETIME
checked_out
INT
10
Unsigned
Yes
Indexes
idx_asset_id
Column name
asset_id
idx_title
Column name
title
idx_extension
Column name
extension
idx_default
Column name
default
idx_created
Column name
created
idx_created_by
Column name
created_by
idx_modified
Column name
modified
idx_modified_by
Column name
modified_by
idx_checked_out
Column name
checked_out
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_workflow_associations
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
item_id
INT
11
Yes
Yes
Default value
0
Description
Extension table id value
stage_id
INT
11
Yes
Description
Foreign Key to #__workflow_stages.id
extension
VARCHAR
50
Yes
Yes
Indexes
idx_item_stage_extension
Column name
item_id
Column name
stage_id
Column name
extension
idx_item_id
Column name
item_id
idx_stage_id
Column name
stage_id
idx_extension
Column name
extension
Keys
PRIMARY
Column in PRIMARY
item_id
Column in PRIMARY
extension
Name
joomla_workflow_stages
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
asset_id
INT
11
Default value
0
ordering
INT
11
Yes
Default value
0
workflow_id
INT
11
Yes
published
TINYINT
4
Yes
Default value
0
title
VARCHAR
255
Yes
description
TEXT
Yes
default
TINYINT
4
Yes
Default value
0
checked_out_time
DATETIME
checked_out
INT
10
Unsigned
Yes
Indexes
idx_workflow_id
Column name
workflow_id
idx_checked_out
Column name
checked_out
idx_title
Column name
title
idx_asset_id
Column name
asset_id
idx_default
Column name
default
Keys
PRIMARY
Column in PRIMARY
id
Name
joomla_workflow_transitions
Properties
Database
joomla
Engine
InnoDB
Row format
Dynamic
Collation
utf8mb4_unicode_ci
Char set
utf8mb4
Columns
Name
Data type
Param
Key
Not Null
id
INT
11
Yes
Yes
Autoincrement
Yes
asset_id
INT
11
Default value
0
ordering
INT
11
Yes
Default value
0
workflow_id
INT
11
Yes
published
TINYINT
4
Yes
Default value
0
title
VARCHAR
255
Yes
description
TEXT
Yes
from_stage_id
INT
11
Yes
to_stage_id
INT
11
Yes
options
TEXT
Yes
checked_out_time
DATETIME
checked_out
INT
10
Unsigned
Yes
Indexes
idx_title
Column name
title
idx_asset_id
Column name
asset_id
idx_checked_out
Column name
checked_out
idx_from_stage_id
Column name
from_stage_id
idx_to_stage_id
Column name
to_stage_id
idx_workflow_id
Column name
workflow_id
Keys
PRIMARY
Column in PRIMARY
id
Notes
Name
note1
Note

Entity Relationship Diagram

Joomla - MariaDB

Name
note3
Note

Name
note2
Note

LUNA MODELER

WWW.DATENSEN.COM

Name
Joomla Licenses
Note

Joomla Licenses

From Joomla! Documentation

https://docs.joomla.org/Joomla_Licenses

Name
GNU GENERAL PUBLIC LICENSE
Note
GNU GENERAL PUBLIC LICENSE Version 2, June 1991 Copyright (C) 1989, 1991 Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The licenses for most software are designed to take away your freedom to share and change it. By contrast, the GNU General Public License is intended to guarantee your freedom to share and change free software--to make sure the software is free for all its users. This General Public License applies to most of the Free Software Foundation's software and to any other program whose authors commit to using it. (Some other Free Software Foundation software is covered by the GNU Lesser General Public License instead.) You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish), that you receive source code or can get it if you want it, that you can change the software or use pieces of it in new free programs; and that you know you can do these things. To protect your rights, we need to make restrictions that forbid anyone to deny you these rights or to ask you to surrender the rights. These restrictions translate to certain responsibilities for you if you distribute copies of the software, or if you modify it. For example, if you distribute copies of such a program, whether gratis or for a fee, you must give the recipients all the rights that you have. You must make sure that they, too, receive or can get the source code. And you must show them these terms so they know their rights. We protect your rights with two steps: (1) copyright the software, and (2) offer you this license which gives you legal permission to copy, distribute and/or modify the software. Also, for each author's protection and ours, we want to make certain that everyone understands that there is no warranty for this free software. If the software is modified by someone else and passed on, we want its recipients to know that what they have is not the original, so that any problems introduced by others will not reflect on the original authors' reputations. Finally, any free program is threatened constantly by software patents. We wish to avoid the danger that redistributors of a free program will individually obtain patent licenses, in effect making the program proprietary. To prevent this, we have made it clear that any patent must be licensed for everyone's free use or not licensed at all. The precise terms and conditions for copying, distribution and modification follow. GNU GENERAL PUBLIC LICENSE TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION 0. This License applies to any program or other work which contains a notice placed by the copyright holder saying it may be distributed under the terms of this General Public License. The "Program", below, refers to any such program or work, and a "work based on the Program" means either the Program or any derivative work under copyright law: that is to say, a work containing the Program or a portion of it, either verbatim or with modifications and/or translated into another language. (Hereinafter, translation is included without limitation in the term "modification".) Each licensee is addressed as "you". Activities other than copying, distribution and modification are not covered by this License; they are outside its scope. The act of running the Program is not restricted, and the output from the Program is covered only if its contents constitute a work based on the Program (independent of having been made by running the Program). Whether that is true depends on what the Program does. 1. You may copy and distribute verbatim copies of the Program's source code as you receive it, in any medium, provided that you conspicuously and appropriately publish on each copy an appropriate copyright notice and disclaimer of warranty; keep intact all the notices that refer to this License and to the absence of any warranty; and give any other recipients of the Program a copy of this License along with the Program. You may charge a fee for the physical act of transferring a copy, and you may at your option offer warranty protection in exchange for a fee. 2. You may modify your copy or copies of the Program or any portion of it, thus forming a work based on the Program, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions: a) You must cause the modified files to carry prominent notices stating that you changed the files and the date of any change. b) You must cause any work that you distribute or publish, that in whole or in part contains or is derived from the Program or any part thereof, to be licensed as a whole at no charge to all third parties under the terms of this License. c) If the modified program normally reads commands interactively when run, you must cause it, when started running for such interactive use in the most ordinary way, to print or display an announcement including an appropriate copyright notice and a notice that there is no warranty (or else, saying that you provide a warranty) and that users may redistribute the program under these conditions, and telling the user how to view a copy of this License. (Exception: if the Program itself is interactive but does not normally print such an announcement, your work based on the Program is not required to print an announcement.) These requirements apply to the modified work as a whole. If identifiable sections of that work are not derived from the Program, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works. But when you distribute the same sections as part of a whole which is a work based on the Program, the distribution of the whole must be on the terms of this License, whose permissions for other licensees extend to the entire whole, and thus to each and every part regardless of who wrote it. Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative or collective works based on the Program. In addition, mere aggregation of another work not based on the Program with the Program (or with a work based on the Program) on a volume of a storage or distribution medium does not bring the other work under the scope of this License. 3. You may copy and distribute the Program (or a work based on it, under Section 2) in object code or executable form under the terms of Sections 1 and 2 above provided that you also do one of the following: a) Accompany it with the complete corresponding machine-readable source code, which must be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or, b) Accompany it with a written offer, valid for at least three years, to give any third party, for a charge no more than your cost of physically performing source distribution, a complete machine-readable copy of the corresponding source code, to be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or, c) Accompany it with the information you received as to the offer to distribute corresponding source code. (This alternative is allowed only for noncommercial distribution and only if you received the program in object code or executable form with such an offer, in accord with Subsection b above.) The source code for a work means the preferred form of the work for making modifications to it. For an executable work, complete source code means all the source code for all modules it contains, plus any associated interface definition files, plus the scripts used to control compilation and installation of the executable. However, as a special exception, the source code distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable. If distribution of executable or object code is made by offering access to copy from a designated place, then offering equivalent access to copy the source code from the same place counts as distribution of the source code, even though third parties are not compelled to copy the source along with the object code. 4. You may not copy, modify, sublicense, or distribute the Program except as expressly provided under this License. Any attempt otherwise to copy, modify, sublicense or distribute the Program is void, and will automatically terminate your rights under this License. However, parties who have received copies, or rights, from you under this License will not have their licenses terminated so long as such parties remain in full compliance. 5. You are not required to accept this License, since you have not signed it. However, nothing else grants you permission to modify or distribute the Program or its derivative works. These actions are prohibited by law if you do not accept this License. Therefore, by modifying or distributing the Program (or any work based on the Program), you indicate your acceptance of this License to do so, and all its terms and conditions for copying, distributing or modifying the Program or works based on it. 6. Each time you redistribute the Program (or any work based on the Program), the recipient automatically receives a license from the original licensor to copy, distribute or modify the Program subject to these terms and conditions. You may not impose any further restrictions on the recipients' exercise of the rights granted herein. You are not responsible for enforcing compliance by third parties to this License. 7. If, as a consequence of a court judgment or allegation of patent infringement or for any other reason (not limited to patent issues), conditions are imposed on you (whether by court order, agreement or otherwise) that contradict the conditions of this License, they do not excuse you from the conditions of this License. If you cannot distribute so as to satisfy simultaneously your obligations under this License and any other pertinent obligations, then as a consequence you may not distribute the Program at all. For example, if a patent license would not permit royalty-free redistribution of the Program by all those who receive copies directly or indirectly through you, then the only way you could satisfy both it and this License would be to refrain entirely from distribution of the Program. If any portion of this section is held invalid or unenforceable under any particular circumstance, the balance of the section is intended to apply and the section as a whole is intended to apply in other circumstances. It is not the purpose of this section to induce you to infringe any patents or other property right claims or to contest validity of any such claims; this section has the sole purpose of protecting the integrity of the free software distribution system, which is implemented by public license practices. Many people have made generous contributions to the wide range of software distributed through that system in reliance on consistent application of that system; it is up to the author/donor to decide if he or she is willing to distribute software through any other system and a licensee cannot impose that choice. This section is intended to make thoroughly clear what is believed to be a consequence of the rest of this License. 8. If the distribution and/or use of the Program is restricted in certain countries either by patents or by copyrighted interfaces, the original copyright holder who places the Program under this License may add an explicit geographical distribution limitation excluding those countries, so that distribution is permitted only in or among countries not thus excluded. In such case, this License incorporates the limitation as if written in the body of this License. 9. The Free Software Foundation may publish revised and/or new versions of the General Public License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns. Each version is given a distinguishing version number. If the Program specifies a version number of this License which applies to it and "any later version", you have the option of following the terms and conditions either of that version or of any later version published by the Free Software Foundation. If the Program does not specify a version number of this License, you may choose any version ever published by the Free Software Foundation. 10. If you wish to incorporate parts of the Program into other free programs whose distribution conditions are different, write to the author to ask for permission. For software which is copyrighted by the Free Software Foundation, write to the Free Software Foundation; we sometimes make exceptions for this. Our decision will be guided by the two goals of preserving the free status of all derivatives of our free software and of promoting the sharing and reuse of software generally. NO WARRANTY 11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. 12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. END OF TERMS AND CONDITIONS How to Apply These Terms to Your New Programs If you develop a new program, and you want it to be of the greatest possible use to the public, the best way to achieve this is to make it free software which everyone can redistribute and change under these terms. To do so, attach the following notices to the program. It is safest to attach them to the start of each source file to most effectively convey the exclusion of warranty; and each file should have at least the "copyright" line and a pointer to where the full notice is found. Copyright (C) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. Also add information on how to contact you by electronic and paper mail. If the program is interactive, make it output a short notice like this when it starts in an interactive mode: Gnomovision version 69, Copyright (C) year name of author Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'. This is free software, and you are welcome to redistribute it under certain conditions; type `show c' for details. The hypothetical commands `show w' and `show c' should show the appropriate parts of the General Public License. Of course, the commands you use may be called something other than `show w' and `show c'; they could even be mouse-clicks or menu items--whatever suits your program. You should also get your employer (if you work as a programmer) or your school, if any, to sign a "copyright disclaimer" for the program, if necessary. Here is a sample; alter the names: Yoyodyne, Inc., hereby disclaims all copyright interest in the program `Gnomovision' (which makes passes at compilers) written by James Hacker. , 1 April 1989 Ty Coon, President of Vice This General Public License does not permit incorporating your program into proprietary programs. If your program is a subroutine library, you may consider it more useful to permit linking proprietary applications with the library. If this is what you want to do, use the GNU Lesser General Public License instead of this License.