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 other 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) || | + | | extensionid || int(11) || NOT NULL || PRI || || || Unique extension identifier, see [[Tables/extensions|#__extensions]] |
|- | |- | ||
− | | schemaid || varchar(20) || | + | | 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[edit]
- Since: 1.6
- Deprecated since: N/A
- Previously: N/a
Description[edit]
The schemas table is used during component installation to handle installing bulk SQL queries and progressively playing through them.
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[edit]
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.