Difference between revisions of "Tables/schemas"

From Joomla! Documentation

< Tables
Line 8: Line 8:
{| border=1
{| class="wikitable" border=1
|+ '''Schemas Table'''
|+ '''Schemas Table'''
|- bgcolor=grey
|- bgcolor=grey

Revision as of 21:19, 24 September 2011


  • Since: 1.6
  • Deprecated since: N/A
  • Previously: N/a


The schemas table is used during component installation to handle installing bulk SQL queries and progressively playing through them.

Schemas Table
Field Type Null Key Default Extra Comments
extensionid int(11) NOT NULL PRI Unique extension identifier, see #__extensions
schemaid varchar(20) NOT NULL PRI Schema Unique Identifier


This table is a simple store of schema version numbers to be used with component upgrades in 1.6 that have schema upgrades. This is handled automatically by the system.