Tables/updates: Difference between revisions
From Joomla! Documentation
< Tables
< Tables
New page: == Usage: == * Since: == Description: == Available Updates table. {| border="1" |+ '''updates Table (#__updates)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key ... |
m categorisation |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
== Usage | == Usage == | ||
* Since: | * Since: | ||
== Description | == Description == | ||
Available Updates table. | Available Updates table. | ||
{| class="wikitable" border="1" | |||
{| border="1" | |||
|+ '''updates Table (#__updates)''' | |+ '''updates Table (#__updates)''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Line 37: | Line 36: | ||
| detailsurl || text || NOT NULL || || || || | | detailsurl || text || NOT NULL || || || || | ||
|} | |} | ||
== Notes == | == Notes == | ||
{| border="1" | {|class="wikitable" border="1" | ||
|+ '''Indices''' | |+ '''Indices''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Line 48: | 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