Joomla! Documentation - User contributions [en]

Tables/viewlevels

2010-09-01T22:48:17Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''viewlevels Table (#__viewlevels)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''viewlevels Table (#__viewlevels)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || int(10) unsigned || NOT NULL ||PK|| || AUTO_INCREMENT || Primary Key
|-
| title || varchar(100) || NOT NULL ||''|| || ||
|-
| ordering || int(11) || NOT NULL ||0 || || ||
|-
| rules || varchar(5120) || NOT NULL || || || || JSON-encoded access control.
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_assetgroup_title_lookup || title || Yes
|}

* Default character set: '''utf8'''

Tables

2010-09-01T22:48:01Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/template_styles|template_styles Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_categories|update_categories Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/update_sites_extensions|update_sites_extensions Table]]
* [[Tables/user_profiles|user_profiles Table]]
* [[Tables/user_usergroup_map|user_usergroup_map Table]]
* [[Tables/usergroups|usergroups Table]]
* [[Tables/users|users Table]]
* [[Table/viewlevels|viewlevels Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/user profiles

2010-09-01T22:42:39Z

Dsiders: New page: == Usage: == * Since: == Description: == Simple user profile storage table. {| border="1" |+ '''user_profiles Table (#__user_profiles)''' |- bgcolor="lightgrey" | Field || Type || Nullab...

== Usage: ==
* Since:

== Description: ==
Simple user profile storage table.

{| border="1"
|+ '''user_profiles Table (#__user_profiles)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| user_id || int(11) || NOT NULL || || || ||
|-
| profile_key || varchar(100) || NOT NULL || || || ||
|-
| profile_value || varchar(255) || NOT NULL || || || ||
|-
| ordering || int(11) || NOT NULL ||0 || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_user_id_profile_key || user_id, profile_key || Yes
|}

* Default character set: '''utf8'''

Tables

2010-09-01T22:41:52Z

Dsiders:

Tablesuser profiles/

2010-09-01T22:41:06Z

Tables

2010-09-01T22:40:47Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/template_styles|template_styles Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_categories|update_categories Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/update_sites_extensions|update_sites_extensions Table]]
* [[Tablesuser_profiles/|user_profiles Table]]
* [[Tables/user_usergroup_map|user_usergroup_map Table]]
* [[Tables/usergroups|usergroups Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/weblinks

2010-09-01T22:38:55Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''weblinks Table (#__weblinks)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''weblinks Table (#__weblinks)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer unsigned || NOT NULL || ||PK|| auto_increment||
|-
| catid || integer || NOT NULL ||0 || || ||
|-
| sid || integer || NOT NULL ||0 || || ||
|-
| title || varchar(250) || NOT NULL ||''|| || ||
|-
| alias || varchar(255) || NOT NULL ||''|| || ||
|-
| url || varchar(250) || NOT NULL ||''|| || ||
|-
| description || text || NOT NULL || || || ||
|-
| date || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| hits || integer || NOT NULL ||0 || || ||
|-
| state || tinyint(1) || NOT NULL ||0 || || ||
|-
| checked_out || integer || NOT NULL ||0 || || ||
|-
| checked_out_time || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| ordering || integer || NOT NULL ||0 || || ||
|-
| archived || tinyint(1) || NOT NULL ||0 || || ||
|-
| approved || tinyint(1) || NOT NULL ||1 || || ||
|-
| access || integer || NOT NULL ||1 || || ||
|-
| params || text || NOT NULL || || || ||
|-
| language || char(7) || NOT NULL ||''|| || ||
|-
| created || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| created_by || int(10) unsigned || NOT NULL ||0 || || ||
|-
| created_by_alias || varchar(255) || NOT NULL ||''|| || ||
|-
| modified || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| modified_by || int(10) unsigned || NOT NULL ||0 || || ||
|-
| metakey || text || NOT NULL || || || ||
|-
| metadesc || text || NOT NULL || || || ||
|-
| metadata || text || NOT NULL || || || ||
|-
| featured || tinyint(3) unsigned ||NOT NULL||0|| || || Set if link is featured.
|-
| xreference || varchar(50) || NOT NULL || || || || A reference to enable linkages to external data sets.
|-
| publish_up || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| publish_down || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_state || state || No
|-
| idx_catid || catid || No
|-
| idx_createdby || created_by || No
|-
| idx_featured_catid || featured,catid || No
|-
| idx_language || language || No
|-
| idx_xreference || xreference || No
|}

* Default character set: '''utf8'''

Tables/user usergroup map

2010-08-31T20:47:00Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''user_usergroup_map Table (#__user_usergroup_map)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || E...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''user_usergroup_map Table (#__user_usergroup_map)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| user_id || integer unsigned || NOT NULL || 0 || PK || || FK reference to #__users.id
|-
| group_id || integer unsigned || NOT NULL || 0 || PK || || FK reference to #__usergroups.id
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

* Default character set: '''utf8'''

Tables

2010-08-31T20:46:47Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/template_styles|template_styles Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_categories|update_categories Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/update_sites_extensions|update_sites_extensions Table]]
* [[Tables/user_usergroup_map|user_usergroup_map Table]]
* [[Tables/usergroups|usergroups Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/usergroups

2010-08-31T18:25:05Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''usergroups Table (#__usergroups)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''usergroups Table (#__usergroups)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer unsigned || NOT NULL || || PK || auto_increment || Primary Key
|-
| parent_id || integer unsigned || NOT NULL ||0 || || || Adjacency List Reference ID
|-
| lft || integer || NOT NULL ||0 || || || Nested set lft.
|-
| rgt || integer || NOT NULL ||0 || || || Nested set rgt.
|-
| title || varchar(100) || NOT NULL ||''|| || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique? || Comments
|-
| idx_usergroup_title_lookup || title || Yes ||
|-
| idx_usergroup_adjacency_lookup || parent_id || No ||
|-
| idx_usergroup_nested_set_lookup || lft, rgt || No || BTREE
|}

* Default character set: '''utf8'''

Tables

2010-08-31T18:24:53Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/template_styles|template_styles Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_categories|update_categories Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/update_sites_extensions|update_sites_extensions Table]]
* [[Tables/usergroups|usergroups Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/users

2010-08-31T18:00:28Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''users Table (#__users)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | id ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''users Table (#__users)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer || NOT NULL || || PK || auto_increment ||
|-
| name || varchar(255) || NOT NULL ||''|| || ||
|-
| username || varchar(150) || NOT NULL ||''|| || ||
|-
| email || varchar(100) || NOT NULL ||''|| || ||
|-
| password || varchar(100) || NOT NULL ||''|| || ||
|-
| usertype || varchar(25) || NOT NULL ||''|| || ||
|-
| block || tinyint(4) || NOT NULL ||0 || || ||
|-
| sendEmail || tinyint(4) || ||0 || || ||
|-
| registerDate || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| lastvisitDate || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| activation || varchar(100) || NOT NULL ||''|| || ||
|-
| params || text || NOT NULL || || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| usertype || usertype || No
|-
| idx_name || name || No
|-
| idx_block || block || No
|-
| username || username || No
|-
| email || email || No
|}

* Default character set: '''utf8'''

Tables/template styles

2010-08-31T17:34:22Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''template_styles Table (#__template_styles)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''template_styles Table (#__template_styles)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer unsigned || NOT NULL || || PK || auto_increment ||
|-
| template || varchar(50) || NOT NULL || '' || || ||
|-
| client_id || tinyint(1) unsigned || NOT NULL || 0 || || ||
|-
| home || tinyint(1) unsigned || NOT NULL || 0 || || ||
|-
| title || varchar(255) || NOT NULL || '' || || ||
|-
| params || varchar(2048) || NOT NULL || '' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_template || template) || No
|-
| idx_home || home || No
|}

*

Tables

2010-08-31T17:30:03Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/template_styles|template_styles Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_categories|update_categories Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/update_sites_extensions|update_sites_extensions Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/update categories

2010-08-31T16:58:40Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''update_categories Table (#__update_categories)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Ext...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''update_categories Table (#__update_categories)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| categoryid || int(11) || NOT NULL || || PK || auto_increment ||
|-
| name || varchar(20) || || '' || || ||
|-
| description || text || NOT NULL || || || ||
|-
| parent || int(11) || || 0 || || ||
|-
| updatesite || int(11) || || 0 || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

* Default character set: '''utf8'''

Tables

2010-08-31T16:58:28Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_categories|update_categories Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/update_sites_extensions|update_sites_extensions Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/update sites extensions

2010-08-31T16:43:07Z

Dsiders: New page: == Usage: == * Since: == Description: == The update_sites_extensions table links extensions to update sites. {| border="1" |+ '''update_sites_extensions Table (#__update_sites_extensions...

== Usage: ==
* Since:

== Description: ==
The update_sites_extensions table links extensions to update sites.

{| border="1"
|+ '''update_sites_extensions Table (#__update_sites_extensions)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| update_site_id || int || || 0 || || ||
|-
| extension_id || int || || 0 || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| newindex || update_site_id, extension_id || No
|}

* Default character set: '''utf8'''

Tables

2010-08-31T16:42:51Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/update_sites_extensions|update_sites_extensions Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/update sites

2010-08-31T16:33:16Z

Dsiders: New page: == Usage: == * Since: == Description: == Update Sites table. {| border="1" |+ '''update_sites Table (#__update_sites)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || ...

== Usage: ==
* Since:

== Description: ==
Update Sites table.

{| border="1"
|+ '''update_sites Table (#__update_sites)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| update_site_id || int(11) || NOT NULL || || PK || auto_increment ||
|-
| name || varchar(100) || || '' || || ||
|-
| type || varchar(20) || || '' || || ||
|-
| location || text || NOT NULL || || || ||
|-
| enabled || int(11) || || 0 || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

* Default character set: '''utf8'''

Tables

2010-08-31T16:32:49Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/updates|updates Table]]
* [[Tables/update_sites|update_sites Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/updates

2010-08-31T16:22:10Z

Dsiders: /* Description: */

== Usage: ==
* Since:

== Description: ==
Available Updates table.

{| border="1"
|+ '''updates Table (#__updates)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| update_id || int(11) || NOT NULL || || PK || auto_increment ||
|-
| update_site_id || int(11) || || 0 || || ||
|-
| extension_id || int(11) || || 0 || || ||
|-
| categoryid || int(11) || || 0 || || ||
|-
| name || varchar(100) || || '' || || ||
|-
| description || text || NOT NULL || || || ||
|-
| element || varchar(100) || || '' || || ||
|-
| type || varchar(20) || || '' || || ||
|-
| folder || varchar(20) || || '' || || ||
|-
| client_id || tinyint(3) || || 0 || || ||
|-
| version || varchar(10) || || '' || || ||
|-
| data || text || NOT NULL || || || ||
|-
| detailsurl || text || NOT NULL || || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

* Default character set: '''utf8'''

Tables/updates

2010-08-31T16:21:45Z

Dsiders: New page: == Usage: == * Since: == Description: == Available Updates table. {| border="1" |+ '''updates Table (#__updates)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key ...

Tables

2010-08-31T16:21:34Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/updates|updates Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/session

2010-08-31T16:08:25Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''session Table (#__session)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''session Table (#__session)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| session_id || varchar(32) || NOT NULL || '' || PK || ||
|-
| client_id || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| guest || tinyint(4) unsigned || || 1 || || ||
|-
| time || varchar(14) || || '' || || ||
|-
| data || varchar(20480) || || NULL || || ||
|-
| userid || int(11) || || 0 || || ||
|-
| username || varchar(150) || || '' || || ||
|-
| usertype || varchar(50) || || '' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| whosonline || guest, usertype || No
|-
| userid || userid || No
|-
| time || time || No
|}

* Default character set: '''utf8'''

Tables/redirect links

2010-08-31T16:02:15Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''redirect_links Table (#__redirect_links)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''redirect_links Table (#__redirect_links)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer unsigned || NOT NULL || || PK || auto_increment ||
|-
| old_url || varchar(150) || NOT NULL || || || ||
|-
| new_url || varchar(150) || NOT NULL || || || ||
|-
| referer || varchar(150) || NOT NULL || || || ||
|-
| comment || varchar(255) || NOT NULL || || || ||
|-
| published || tinyint(4) || NOT NULL || || || ||
|-
| created_date || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_date || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_link_old || old_url || Yes
|-
| idx_link_modifed || modified_date || No
|}

* Default character set: '''utf8'''

Tables

2010-08-31T16:01:51Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/redirect_links|redirect_links Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/newsfeeds

2010-08-31T16:00:24Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''newsfeeds Table (#__newsfeeds)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''newsfeeds Table (#__newsfeeds)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
|catid || integer || NOT NULL || 0 || || ||
|-
| id || integer(10) unsigned || NOT NULL || || PK || auto_increment ||
|-
| name || varchar(100) || NOT NULL || '' || || ||
|-
| alias || varchar(100) || NOT NULL || '' || || ||
|-
| link || varchar(200) || NOT NULL || '' || || ||
|-
| filename || varchar(200) || || NULL || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| numarticles || integer unsigned || NOT NULL || 1 || || ||
|-
| cache_time || integer unsigned || NOT NULL || 3600 || || ||
|-
| checked_out || integer(10) unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| ordering || integer || NOT NULL || 0 || || ||
|-
| rtl || tinyint(4) || NOT NULL || 0 || || ||
|-
| access || tinyint UNSIGNED || NOT NULL || 0 || || ||
|-
| language || char(7) || NOT NULL || '' || || ||
|-
| params || text || NOT NULL || || || ||
|-
| created || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| created_by || int(10) unsigned || NOT NULL || 0 || || ||
|-
| created_by_alias || varchar(255) || NOT NULL || '' || || ||
|-
| modified || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_by || int(10) unsigned || NOT NULL || 0 || || ||
|-
| metakey || text || NOT NULL || || || ||
|-
| metadesc || text || NOT NULL || || || ||
|-
| metadata || text || NOT NULL || || || ||
|-
| xreference || varchar(50) || NOT NULL || || || || A reference to enable linkages to external data sets.
|-
| publish_up || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| publish_down || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_state || published || No
|-
| idx_catid || catid || No
|-
| idx_createdby || created_by || No
|-
| idx_language || language || No
|-
| idx_xreference || xreference || No
|}

* Default character set: '''utf8'''

Tables/modules menu

2010-08-31T15:59:54Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''modules_menu Table (#__modules_menu)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comm...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''modules_menu Table (#__modules_menu)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| moduleid || integer || NOT NULL || 0 || PK || ||
|-
| menuid || integer || NOT NULL || 0 || PK || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

* Default character set: '''utf8'''

Tables/modules

2010-08-31T15:59:15Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''modules Table (#__modules)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''modules Table (#__modules)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || int(11) || NOT NULL || || PK || AUTO_INCREMENT ||
|-
| title || varchar(100) || NOT NULL || '' || || ||
|-
| note || varchar(255) || NOT NULL || '' || || ||
|-
| content || text || NOT NULL || || || ||
|-
| ordering || int(11) || NOT NULL || 0 || || ||
|-
| position || varchar(50) || || NULL || || ||
|-
| checked_out || int(10) unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| publish_up || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| publish_down || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| module || varchar(50) || || NULL || || ||
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| showtitle || tinyint(3) unsigned || NOT NULL || 1 || || ||
|-
| params || varchar(5120) || NOT NULL || '' || || ||
|-
| client_id || tinyint(4) || NOT NULL || 0 || || ||
|-
| language || char(7) || NOT NULL || || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| published || published, access || No
|-
| newsfeeds || module, published || No
|-
| idx_language || language || No
|}

* Default character set: '''utf8'''

Tables/messages cfg

2010-08-31T15:58:49Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''messages_cfg Table (#__messages_cfg)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comm...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''messages_cfg Table (#__messages_cfg)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| user_id || integer unsigned || NOT NULL || 0 || || ||
|-
| cfg_name || varchar(100) || NOT NULL || '' || || ||
|-
| cfg_value || varchar(255) || NOT NULL || '' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_user_var_name || user_id, cfg_name || Yes
|}

* Default character set: '''utf8'''

Tables/messages

2010-08-31T15:58:18Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''messages Table (#__messages)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''messages Table (#__messages)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| message_id || integer unsigned || NOT NULL || || PK || auto_increment ||
|-
| user_id_from || integer unsigned || NOT NULL || 0 || || ||
|-
| user_id_to || integer unsigned || NOT NULL || 0 || || ||
|-
| folder_id || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| date_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| state || tinyint(1) || NOT NULL || 0 || || ||
|-
| priority || tinyint(1) unsigned || NOT NULL || 0 || || ||
|-
| subject || varchar(255) || NOT NULL || '' || || ||
|-
| message || text || NOT NULL || || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| useridto_state || user_id_to, state || No
|}

* Default character set: '''utf8'''

Tables/menu types

2010-08-31T15:57:48Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''menu_types Table (#__menu_types)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''menu_types Table (#__menu_types)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer unsigned || NOT NULL || || PK || auto_increment ||
|-
| menutype || varchar(24) || NOT NULL || || || ||
|-
| title || varchar(48) || NOT NULL || || || ||
|-
| description || varchar(255) || NOT NULL || '' || || ||
|}

== Notes ==
The menu_types tables does not contain an entry for the Adminstrator menu.

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_menutype || menutype || Yes
|}

* Default character set: '''utf8'''

Tables/menu

2010-08-31T15:56:29Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''menu Table (#__menu)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | id ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''menu Table (#__menu)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer || NOT NULL || || PK || auto_increment ||
|-
|menutype || varchar(24) || NOT NULL || || || || The type of menu for the item. FK to #__menu_types.menutype
|-
| title || varchar(255) || NOT NULL || || || || The display title for the menu item.
|-
| alias || varchar(255) || NOT NULL || || || || The SEF alias for the menu item.
|-
| note || varchar(255) || NOT NULL || '' || || ||
|-
| path || varchar(1024) || NOT NULL || || || || The computed path for the menu item based on the alias field.
|-
| link || varchar(1024) || NOT NULL || || || || The actually link that the menu item references.
|-
| type || varchar(16) || NOT NULL || || || || The type of link: Component, URL, Alias, Separator.
|-
| published || tinyint(4) || NOT NULL || 0 || || || The published state of the menu link.
|-
| parent_id || integer unsigned || NOT NULL || 1 || || || The parent menu item in the menu tree.
|-
| level || integer unsigned || NOT NULL || 0 || || || The relative level in the menu tree.
|-
| component_id || integer unsigned || NOT NULL || 0 || || || FK to #__extensions.id
|-
| ordering || integer || NOT NULL || 0 || || || The relative ordering of the menu item in the tree.
|-
| checked_out || integer unsigned || NOT NULL || 0 || || || FK to #__users.id
|-
| checked_out_time || timestamp || NOT NULL || '0000-00-00 00:00:00' || || || The time the menu item was checked out.
|-
| browserNav || tinyint(4) || NOT NULL || 0 || || || The click behaviour for the link.
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || || The access level required to view the menu item.
|-
| img || varchar(255) || NOT NULL || || || || The image of the menu item.
|-
| template_style_id || integer unsigned || NOT NULL || 0 || || ||
|-
| params || varchar(10240) || NOT NULL || || || || JSON-encoded data for the menu item.
|-
| lft || integer || NOT NULL || 0 || || || Nested set lft.
|-
| rgt || integer || NOT NULL || 0 || || || Nested set rgt.
|-
| home || tinyint(3) unsigned || NOT NULL || 0 || || || Indicates if this menu item is the home or default page.
|-
| language || char(7) || NOT NULL || '' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_alias_parent_id || alias, parent_id || Yes
|-
| idx_componentid || component_id, menutype, published,access || No
|-
| idx_menutype || menutype || No
|-
| idx_left_right || lft, rgt || No
|-
| idx_alias || alias || No
|-
| idx_path || path(333) || No
|-
| idx_language || language || No
|}

* Default character set: '''utf8'''

Tables/languages

2010-08-30T22:28:20Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''languages Table (#__languages)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''languages Table (#__languages)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| lang_id || int(11) unsigned || NOT NULL || || PK || auto_increment ||
|-
| lang_code || char(7) || NOT NULL || || || ||
|-
| title || varchar(50) || NOT NULL || || || ||
|-
| title_native || varchar(50) || NOT NULL || || || ||
|-
| sef || varchar(50) || NOT NULL || || || ||
|-
| image || varchar(50) || NOT NULL || || || ||
|-
| description || varchar(512) || NOT NULL || || || ||
|-
| metakey || text || NOT NULL || || || ||
|-
| metadesc || text || NOT NULL || || || ||
|-
| published || int(11) || NOT NULL || 0 || || ||
|}

== Notes ==
The default Joomla! installation includes entries in the languages table for
the following language codes:

* en-GB
* xx-XX

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_sef || sef || Yes
|}

*

Tables

2010-08-30T22:28:02Z

Dsiders:

The core Joomla! distribution includes the following tables by default:
* [[Tables/banner|banner Table]]
* [[Tables/bannerclient|bannerclient Table]]
* [[Tables/bannertrack|bannertrack Table]]
* [[Tables/categories|categories Table]]
* [[Tables/components|components Table]]
* [[Tables/contact_details|contact_details Table]]
* [[Tables/content|content Table]]
* [[Tables/content_frontpage|content_frontpage Table]]
* [[Tables/content_rating|content_rating Table]]
* [[Tables/core_acl_aro|core_acl_aro Table]]
* [[Tables/core_acl_aro_groups|core_acl_aro_groups Table]]
* [[Tables/core_acl_aro_map|core_acl_aro_map Table]]
* [[Tables/core_acl_aro_sections|core_acl_aro_sections Table]]
* [[Tables/core_acl_groups_aro_map|core_acl_groups_aro_map Table]]
* [[Tables/core_log_items|core_log_items Table]]
* [[Tables/core_log_searches|core_log_searches Table]]
* [[Tables/extensions|extensions Table]]
* [[Tables/groups|groups Table]]
* [[Tables/languages|languages Table]]
* [[Tables/menu|menu Table]]
* [[Tables/menu_types|menu_types Table]]
* [[Tables/messages|messages Table]]
* [[Tables/messages_cfg|messages_cfg Table]]
* [[Tables/migration_backlinks|migration_backlinks Table]]
* [[Tables/modules|modules Table]]
* [[Tables/modules_menu|modules_menu Table]]
* [[Tables/newsfeeds|newsfeeds Table]]
* [[Tables/plugins|plugins Table]]
* [[Tables/poll_data|poll_data Table]]
* [[Tables/poll_date|poll_date Table]]
* [[Tables/poll_menu|poll_menu Table]]
* [[Tables/polls|polls Table]]
* [[Tables/schemas|Schemas Table]]
* [[Tables/sections|sections Table]]
* [[Tables/session|session Table]]
* [[Tables/stats_agents|stats_agents Table]]
* [[Tables/templates_menu|templates_menu Table]]
* [[Tables/users|users Table]]
* [[Tables/weblinks|weblinks Table]]

Tables/core log searches

2010-08-30T21:48:26Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''core_log_searches Table (#__core_log_searches)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Ext...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''core_log_searches Table (#__core_log_searches)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| search_term || varchar(128) || NOT NULL || '' || || ||
|-
| hits || integer unsigned || NOT NULL || 0 || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

* Default character set: '''utf8'''

Tables/content rating

2010-08-30T21:45:35Z

Dsiders:

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''content_rating Table (#__content_rating)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| content_id || integer || NOT NULL || 0 || PK || ||
|-
| rating_sum || integer unsigned || NOT NULL || 0 || || ||
|-
| rating_count || integer unsigned || NOT NULL || 0 || || ||
|-
| lastip || varchar(50) || NOT NULL || '' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

* Default character set: '''utf8'''

Tables/content rating

2010-08-30T21:44:52Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''content_rating Table (#__content_rating)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || ...

Tables/content frontpage

2010-08-30T21:40:44Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''content_frontpage Table (#__content_frontpage)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Ex...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''content_frontpage Table (#__content_frontpage)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| content_id || integer || NOT NULL || 0 || PK || ||
|-
| ordering || integer || NOT NULL || 0 || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|}

*

Tables/content

2010-08-30T21:36:43Z

Dsiders:

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''contents Table (#__contents)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer unsigned || NOT NULL || || PK || auto_increment ||
|-
| asset_id || integer unsigned || NOT NULL || 0 || || || FK to the #__assets table.
|-
| title || varchar(255) || NOT NULL || '' || || ||
|-
| alias || varchar(255) || NOT NULL || '' || || ||
|-
| title_alias || varchar(255) || NOT NULL || '' || || ||
|-
| introtext || mediumtext || NOT NULL || || || ||
|-
| fulltext || mediumtext || NOT NULL || || || ||
|-
| state || tinyint(3) || NOT NULL || 0 || || ||
|-
| sectionid || integer unsigned || NOT NULL || 0 || || ||
|-
| mask || integer unsigned || NOT NULL || 0 || || ||
|-
| catid || integer unsigned || NOT NULL || 0 || || ||
|-
| created || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| created_by || integer unsigned || NOT NULL || 0 || || ||
|-
| created_by_alias || varchar(255) || NOT NULL || '' || || ||
|-
| modified || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_by || integer unsigned || NOT NULL || 0 || || ||
|-
| checked_out || integer unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| publish_up || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| publish_down || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| images || text || NOT NULL || || || ||
|-
| urls || text || NOT NULL || || || ||
|-
| attribs || varchar(5120) || NOT NULL || || || ||
|-
| version || integer unsigned || NOT NULL || 1 || || ||
|-
| parentid || integer unsigned || NOT NULL || 0 || || ||
|-
| ordering || integer || NOT NULL || 0 || || ||
|-
| metakey || text || NOT NULL || || || ||
|-
| metadesc || text || NOT NULL || || || ||
|-
| access || integer unsigned || NOT NULL || 0 || || ||
|-
| hits || integer unsigned || NOT NULL || 0 || || ||
|-
| metadata || text || NOT NULL || || || ||
|-
|featured || tinyint(3) unsigned || NOT NULL || 0 || || || Flag indicating if article is featured.
|-
| language || char(7) || NOT NULL || || || || The language code for the article.
|-
| xreference || varchar(50) || NOT NULL || || || || A reference to enable linkages to external data sets.
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_state || state || No
|-
| idx_catid || catid || No
|-
| idx_createdby || created_by || No
|-
| idx_featured_cati|| featured,catid || No
|-
| idx_language || language || No
|-
| idx_xreference || xreference || No
|}

* Default character set: '''utf8'''

Tables/content

2010-08-30T20:54:16Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''contents Table (#__contents)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''contents Table (#__contents)'''
|- bgcolor="lightgrey"
| Field || Type || Nullable || Default || Key || Extra || Comments
|-

|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| Index Name || Column(s) || Unique?
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_state || state || No
|-
| idx_catid || catid || No
|-
| idx_createdby || created_by || No
|-
| idx_featured_cati|| featured,catid || No
|-
| idx_language || language || No
|-
| idx_xreference || xreference || No
|}

* Default character set: '''utf8'''

Tables/contact details

2010-08-30T20:37:29Z

Dsiders:

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''contact_details Table (#__contact_details)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id || integer || NOT NULL || || PK || auto_increment ||
|-
| name || varchar(255) || NOT NULL || '' || || ||
|-
| alias || varchar(255) || NOT NULL || '' || || ||
|-
| con_position || varchar(255) || || NULL || || ||
|-
| address || text || || || || ||
|-
| suburb || varchar(100) || || NULL || || ||
|-
| state || varchar(100) || || NULL || || ||
|-
| country || varchar(100) || || NULL || || ||
|-
| postcode || varchar(100) || || NULL || || ||
|-
| telephone || varchar(255) || || NULL || || ||
|-
| fax || varchar(255) || || NULL || || ||
|-
| misc || mediumtext || || || || ||
|-
| image || varchar(255) || || NULL || || ||
|-
| imagepos || varchar(20) || || NULL || || ||
|-
| email_to || varchar(255) || || NULL || || ||
|-
| default_con || tinyint(1) unsigned || NOT NULL || 0 || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| checked_out || integer unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL ||'0000-00-00 00:00:00'|| || ||
|-
| ordering || integer || NOT NULL || 0 || || ||
|-
| params || text || NOT NULL || || || ||
|-
| user_id || integer || NOT NULL || 0 || || ||
|-
| catid || integer || NOT NULL || 0 || || ||
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| mobile || varchar(255) || NOT NULL || '' || || ||
|-
| webpage || varchar(255) || NOT NULL || '' || || ||
|-
| sortname1 || varchar(255) || NOT NULL || || || ||
|-
| sortname2 || varchar(255) || NOT NULL || || || ||
|-
| sortname3 || varchar(255) || NOT NULL || || || ||
|-
| language || char(7) || NOT NULL || || || ||
|-
| created || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| created_by || int(10) unsigned || NOT NULL || 0 || || ||
|-
| created_by_alias || varchar(255) || NOT NULL || '' || || ||
|-
| modified || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_by || int(10) unsigned || NOT NULL || 0 || || ||
|-
| metakey || text || NOT NULL || || || ||
|-
| metadesc || text || NOT NULL || || || ||
|-
| metadata || text || NOT NULL || || || ||
|-
| featured || tinyint(3) unsigned || NOT NULL || 0 || || || Flag indicating if article is featured.
|-
| xreference || varchar(50) || NOT NULL || || || || A reference to enable linkages to external data sets.
|-
| publish_up || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| publish_down || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_state || published || No
|-
| idx_catid || catid || No
|-
| idx_createdby || created_by || No
|-
| idx_featured_catid || featured,catid || No
|-
| idx_language || language || No
|-
| idx_xreference || xreference || No
|}

* Default character set: '''utf8'''

Tables/contact details

2010-08-30T20:02:18Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''contact_details Table (#__contact_details)''' |- bgcolor="lightgrey" || Field || Type || Nullable || Default || Key || Extra ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''contact_details Table (#__contact_details)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
|}

* Default character set: '''utf8'''

Tables/categories

2010-08-30T19:58:54Z

Dsiders: /* Notes */

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''categories Table (#__categories)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id int|| (11) || NOT NULL || || PK || auto_increment || Category identifier.
|-
| asset_id || INTEGER UNSIGNED || NOT NULL || 0 || || || FK to the #__assets table
|-
| parent_id || int(10) unsigned || NOT NULL|| 0 || || ||
|-
| lft || int(11) || NOT NULL || 0 || || ||
|-
| rgt || int(11) || NOT NULL || 0 || || ||
|-
| level || int(10) unsigned || NOT NULL || 0 || || ||
|-
| path || varchar(255) || NOT NULL || '' || || ||
|-
| extension || varchar(50) || NOT NULL || '' || || ||
|-
| title || varchar(255) || NOT NULL || || || ||
|-
| alias || varchar(255) || NOT NULL || '' || || ||
|-
| note || varchar(255) || NOT NULL || '' || || ||
|-
| description || varchar(5120) || NOT NULL || '' || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| checked_out || int(11) unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| params || varchar(2048) || NOT NULL || '' || || ||
|-
| metadesc || varchar(1024) || NOT NULL || || || || The meta description for the page.
|-
| metakey || varchar(1024) || NOT NULL || || || || The meta keywords for the page.
|-
| metadata || varchar(2048) || NOT NULL || || || || JSON-encoded metadata properties.
|-
| created_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| created_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| modified_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| hits || int(10) unsigned || NOT NULL || 0 || || ||
|-
| language || char(7) || NOT NULL || || || ||
|}

== Notes ==
The default Joomla! installation includes a category with the value "uncategorised" for the following extensions:

* com_content
* com_banners
* com_contact
* com_newsfeeds
* com_weblinks

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
| cat_idx || extension,published,access || No
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_path || path || No
|-
| idx_left_right || lft, rgt || No
|-
| idx_alias || alias || No
|-
| idx_language || language || No
|}

* Default character set: '''utf8'''

Tables/categories

2010-08-30T19:58:01Z

Dsiders: /* Notes */

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''categories Table (#__categories)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id int|| (11) || NOT NULL || || PK || auto_increment || Category identifier.
|-
| asset_id || INTEGER UNSIGNED || NOT NULL || 0 || || || FK to the #__assets table
|-
| parent_id || int(10) unsigned || NOT NULL|| 0 || || ||
|-
| lft || int(11) || NOT NULL || 0 || || ||
|-
| rgt || int(11) || NOT NULL || 0 || || ||
|-
| level || int(10) unsigned || NOT NULL || 0 || || ||
|-
| path || varchar(255) || NOT NULL || '' || || ||
|-
| extension || varchar(50) || NOT NULL || '' || || ||
|-
| title || varchar(255) || NOT NULL || || || ||
|-
| alias || varchar(255) || NOT NULL || '' || || ||
|-
| note || varchar(255) || NOT NULL || '' || || ||
|-
| description || varchar(5120) || NOT NULL || '' || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| checked_out || int(11) unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| params || varchar(2048) || NOT NULL || '' || || ||
|-
| metadesc || varchar(1024) || NOT NULL || || || || The meta description for the page.
|-
| metakey || varchar(1024) || NOT NULL || || || || The meta keywords for the page.
|-
| metadata || varchar(2048) || NOT NULL || || || || JSON-encoded metadata properties.
|-
| created_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| created_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| modified_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| hits || int(10) unsigned || NOT NULL || 0 || || ||
|-
| language || char(7) || NOT NULL || || || ||
|}

== Notes ==
The default Joomla! installation includes a category with the value "uncategorised" for the following components:

* com_content
* com_banners
* com_contact
* com_newsfeeds
* com_weblinks

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
| cat_idx || extension,published,access || No
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_path || path || No
|-
| idx_left_right || lft, rgt || No
|-
| idx_alias || alias || No
|-
| idx_language || language || No
|}

* Default character set: '''utf8'''

Tables/categories

2010-08-30T19:57:49Z

Dsiders: /* Notes */

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''categories Table (#__categories)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id int|| (11) || NOT NULL || || PK || auto_increment || Category identifier.
|-
| asset_id || INTEGER UNSIGNED || NOT NULL || 0 || || || FK to the #__assets table
|-
| parent_id || int(10) unsigned || NOT NULL|| 0 || || ||
|-
| lft || int(11) || NOT NULL || 0 || || ||
|-
| rgt || int(11) || NOT NULL || 0 || || ||
|-
| level || int(10) unsigned || NOT NULL || 0 || || ||
|-
| path || varchar(255) || NOT NULL || '' || || ||
|-
| extension || varchar(50) || NOT NULL || '' || || ||
|-
| title || varchar(255) || NOT NULL || || || ||
|-
| alias || varchar(255) || NOT NULL || '' || || ||
|-
| note || varchar(255) || NOT NULL || '' || || ||
|-
| description || varchar(5120) || NOT NULL || '' || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| checked_out || int(11) unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| params || varchar(2048) || NOT NULL || '' || || ||
|-
| metadesc || varchar(1024) || NOT NULL || || || || The meta description for the page.
|-
| metakey || varchar(1024) || NOT NULL || || || || The meta keywords for the page.
|-
| metadata || varchar(2048) || NOT NULL || || || || JSON-encoded metadata properties.
|-
| created_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| created_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| modified_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| hits || int(10) unsigned || NOT NULL || 0 || || ||
|-
| language || char(7) || NOT NULL || || || ||
|}

== Notes ==
The default Joomla! installation includes a category with the value "uncategorised" for the following components:

* com_content
* com_banners
* com_contact
* com_newsfeeds
* com_weblinks

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
| cat_idx || extension,published,access || No
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_path || path || No
|-
| idx_left_right || lft, rgt || No
|-
| idx_alias || alias || No
|-
| idx_language || language || No
|}

* Default character set: '''utf8'''

Tables/categories

2010-08-30T19:51:52Z

Dsiders: /* Notes */

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''categories Table (#__categories)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id int|| (11) || NOT NULL || || PK || auto_increment || Category identifier.
|-
| asset_id || INTEGER UNSIGNED || NOT NULL || 0 || || || FK to the #__assets table
|-
| parent_id || int(10) unsigned || NOT NULL|| 0 || || ||
|-
| lft || int(11) || NOT NULL || 0 || || ||
|-
| rgt || int(11) || NOT NULL || 0 || || ||
|-
| level || int(10) unsigned || NOT NULL || 0 || || ||
|-
| path || varchar(255) || NOT NULL || '' || || ||
|-
| extension || varchar(50) || NOT NULL || '' || || ||
|-
| title || varchar(255) || NOT NULL || || || ||
|-
| alias || varchar(255) || NOT NULL || '' || || ||
|-
| note || varchar(255) || NOT NULL || '' || || ||
|-
| description || varchar(5120) || NOT NULL || '' || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| checked_out || int(11) unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| params || varchar(2048) || NOT NULL || '' || || ||
|-
| metadesc || varchar(1024) || NOT NULL || || || || The meta description for the page.
|-
| metakey || varchar(1024) || NOT NULL || || || || The meta keywords for the page.
|-
| metadata || varchar(2048) || NOT NULL || || || || JSON-encoded metadata properties.
|-
| created_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| created_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| modified_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| hits || int(10) unsigned || NOT NULL || 0 || || ||
|-
| language || char(7) || NOT NULL || || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
| cat_idx || extension,published,access || No
|-
| idx_access || access || No
|-
| idx_checkout || checked_out || No
|-
| idx_path || path || No
|-
| idx_left_right || lft, rgt || No
|-
| idx_alias || alias || No
|-
| idx_language || language || No
|}

* Default character set: '''utf8'''

Tables/categories

2010-08-30T19:48:51Z

Dsiders: /* Description: */

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''categories Table (#__categories)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
| id int|| (11) || NOT NULL || || PK || auto_increment || Category identifier.
|-
| asset_id || INTEGER UNSIGNED || NOT NULL || 0 || || || FK to the #__assets table
|-
| parent_id || int(10) unsigned || NOT NULL|| 0 || || ||
|-
| lft || int(11) || NOT NULL || 0 || || ||
|-
| rgt || int(11) || NOT NULL || 0 || || ||
|-
| level || int(10) unsigned || NOT NULL || 0 || || ||
|-
| path || varchar(255) || NOT NULL || '' || || ||
|-
| extension || varchar(50) || NOT NULL || '' || || ||
|-
| title || varchar(255) || NOT NULL || || || ||
|-
| alias || varchar(255) || NOT NULL || '' || || ||
|-
| note || varchar(255) || NOT NULL || '' || || ||
|-
| description || varchar(5120) || NOT NULL || '' || || ||
|-
| published || tinyint(1) || NOT NULL || 0 || || ||
|-
| checked_out || int(11) unsigned || NOT NULL || 0 || || ||
|-
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
|-
| params || varchar(2048) || NOT NULL || '' || || ||
|-
| metadesc || varchar(1024) || NOT NULL || || || || The meta description for the page.
|-
| metakey || varchar(1024) || NOT NULL || || || || The meta keywords for the page.
|-
| metadata || varchar(2048) || NOT NULL || || || || JSON-encoded metadata properties.
|-
| created_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| created_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| modified_user_id || int(10) unsigned || NOT NULL || 0 || || ||
|-
| modified_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
|-
| hits || int(10) unsigned || NOT NULL || 0 || || ||
|-
| language || char(7) || NOT NULL || || || ||
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
|}

* Default character set: '''utf8'''

Tables/components

2010-08-30T19:36:16Z

Dsiders:

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''components Table (#__components)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
|}

* Default character set: '''utf8'''

Tables/components

2010-08-30T19:35:24Z

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''Table (#__)''' |- bgcolor="lightgrey" || Field || Type || Nullable || Default || Key || Extra || Comments |- |} == Notes == ...

== Usage: ==
* Since:

== Description: ==

{| border="1"
|+ '''Table (#__)'''
|- bgcolor="lightgrey"
|| Field || Type || Nullable || Default || Key || Extra || Comments
|-
|}

== Notes ==

{| border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
|| Index Name || Column(s) || Unique?
|-
|}

* Default character set: '''utf8'''