Tables/schemas
From Joomla! Documentation
< Tables(Difference between revisions)
(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...) |
(→Description) |
||
| Line 13: | Line 13: | ||
! 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 08:40, 13 April 2009
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.
| 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.
