Actions

Difference between revisions of "Tables/schemas"

From Joomla! Documentation

< Tables
(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...)
 
(class="wikitable")
(One intermediate revision by one user not shown)
Line 8: Line 8:
  
  
{| border=1
+
{| class="wikitable" border=1
 
|+ '''Schemas Table'''
 
|+ '''Schemas Table'''
 
|- bgcolor=grey
 
|- bgcolor=grey
 
! Field !! Type !! Null !! Key !! Default !! Extra !! Comments
 
! Field !! Type !! Null !! Key !! Default !! Extra !! Comments
 
|-
 
|-
| extensionid              || int(11)            ||     || PRI || NOT NULL                || || Unique extension identifier, see [[Tables/extensions|#__extensions]]
+
| extensionid              || int(11)            || NOT NULL    || PRI ||                 || || Unique extension identifier, see [[Tables/extensions|#__extensions]]
 
|-
 
|-
| schemaid            || varchar(20)        ||     ||  PRI  ||   NOT NULL                  ||                || Schema Unique Identifier
+
| schemaid            || varchar(20)        ||   NOT NULL  ||  PRI  ||                   ||                || Schema Unique Identifier
 
|}
 
|}
  
 
= Notes =
 
= 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.
 
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.

Revision as of 22:19, 24 September 2011

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