Tables/schemas - Revision history

JoomlaWikiBot: /* Notes */categorisation

2013-03-16T15:38:34Z

‎Notes: categorisation

Cadrlp: class="wikitable"

2011-09-25T03:19:39Z

class="wikitable"

Pasamio: /* Description */

2009-04-13T13:40:18Z

‎Description

Pasamio: 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...

2009-04-13T13:38:57Z

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...

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 queries and progressively playing through them.

{| border=1
|+ '''Schemas Table'''
|- bgcolor=grey
! Field !! Type !! Null !! Key !! Default !! Extra !! Comments
|-
| extensionid || int(11) || || PRI || NOT NULL || || Unique extension identifier, see [[Tables/extensions|#__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.

← Older revision		Revision as of 15:38, 16 March 2013
Line 20:		Line 20:
	= 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.
		+
		+	<noinclude>[[Category:Database]]</noinclude>

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

@@ Line 13: / Line 13: @@
 ! 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 =
 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.