Tables/modules: Difference between revisions
From Joomla! Documentation
< Tables
< Tables
class="wikitable" |
m categorisation |
||
| Line 1: | Line 1: | ||
== Usage | == Usage == | ||
* Since: | * Since: | ||
== Description | == Description == | ||
{| class="wikitable" border="1" | {| class="wikitable" border="1" | ||
| Line 59: | Line 59: | ||
* Default character set: '''utf8''' | * Default character set: '''utf8''' | ||
<noinclude>[[Category:Database]]</noinclude> | |||
Latest revision as of 15:38, 16 March 2013
Usage
- Since:
Description
| Field | Type | Nullable | Default | Key | Extra | Comments |
| id | int(11) | NOT NULL | PK | AUTO_INCREMENT | ||
| title | varchar(100) | NOT NULL | ||||
| note | varchar(255) | NOT NULL | ||||
| content | text | NOT NULL | ||||
| ordering | int(11) | NOT NULL | 0 | |||
| position | varchar(50) | NULL | ||||
| checked_out | int(10) unsigned | NOT NULL | 0 | |||
| checked_out_time | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
| publish_up | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
| publish_down | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
| published | tinyint(1) | NOT NULL | 0 | |||
| module | varchar(50) | NULL | ||||
| access | tinyint(3) unsigned | NOT NULL | 0 | |||
| showtitle | tinyint(3) unsigned | NOT NULL | 1 | |||
| params | varchar(5120) | NOT NULL | ||||
| client_id | tinyint(4) | NOT NULL | 0 | |||
| language | char(7) | NOT NULL |
Notes
| Index Name | Column(s) | Unique? |
| published | published, access | No |
| newsfeeds | module, published | No |
| idx_language | language | No |
- Default character set: utf8