Tables/updates: Difference between revisions
From Joomla! Documentation
< Tables
< Tables
m categorisation |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
== Usage | == Usage == | ||
* Since: | * Since: | ||
== Description | == Description == | ||
Available Updates table. | Available Updates table. | ||
{| border="1" | {| class="wikitable" border="1" | ||
|+ '''updates Table (#__updates)''' | |+ '''updates Table (#__updates)''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Line 39: | Line 39: | ||
== Notes == | == Notes == | ||
{| border="1" | {|class="wikitable" border="1" | ||
|+ '''Indices''' | |+ '''Indices''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Line 46: | Line 46: | ||
* Default character set: '''utf8''' | * Default character set: '''utf8''' | ||
<noinclude>[[Category:Database]]</noinclude> | |||
Latest revision as of 15:38, 16 March 2013
Usage
- Since:
Description
Available Updates table.
| Field | Type | Nullable | Default | Key | Extra | Comments |
| update_id | int(11) | NOT NULL | PK | auto_increment | ||
| update_site_id | int(11) | 0 | ||||
| extension_id | int(11) | 0 | ||||
| categoryid | int(11) | 0 | ||||
| name | varchar(100) | |||||
| description | text | NOT NULL | ||||
| element | varchar(100) | |||||
| type | varchar(20) | |||||
| folder | varchar(20) | |||||
| client_id | tinyint(3) | 0 | ||||
| version | varchar(10) | |||||
| data | text | NOT NULL | ||||
| detailsurl | text | NOT NULL |
Notes
| Index Name | Column(s) | Unique? |
- Default character set: utf8