Tables/schemas

From Joomla! Documentation

Revision as of 13:38, 13 April 2009 by Pasamio (talk | contribs) (New page: = Usage = * '''Since: ''' 1.6 * '''Deprecated since: ''' N/A * '''Previously: ''' N/a = Description = The schemas table is used during component installation to handle installing bulk SQL...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Usage

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

Description

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) PRI NOT NULL Unique extension identifier, see #__extensions
schemaid varchar(20) PRI NOT NULL Schema Unique Identifier

Notes

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.