Tables/modules
From Joomla! Documentation
< Tables
Usage:[edit]
- Since:
Description:[edit]
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[edit]
Index Name | Column(s) | Unique? |
published | published, access | No |
newsfeeds | module, published | No |
idx_language | language | No |
- Default character set: utf8