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