Tables/content
From Joomla! Documentation
< Tables(Difference between revisions)
(class="wikitable") |
|||
| Line 1: | Line 1: | ||
| − | |||
== Usage: == | == Usage: == | ||
* Since: | * Since: | ||
| Line 5: | Line 4: | ||
== Description: == | == Description: == | ||
| − | {| border="1" | + | {| class="wikitable" border="1" |
|+ '''contents Table (#__contents)''' | |+ '''contents Table (#__contents)''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Line 81: | Line 80: | ||
== Notes == | == Notes == | ||
| − | {| border="1" | + | {| class="wikitable" border="1" |
|+ '''Indices''' | |+ '''Indices''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
Revision as of 22:15, 24 September 2011
Usage:
- Since:
Description:
| Field | Type | Nullable | Default | Key | Extra | Comments |
| id | integer unsigned | NOT NULL | PK | auto_increment | ||
| asset_id | integer unsigned | NOT NULL | 0 | FK to the #__assets table. | ||
| title | varchar(255) | NOT NULL | ||||
| alias | varchar(255) | NOT NULL | ||||
| title_alias | varchar(255) | NOT NULL | ||||
| introtext | mediumtext | NOT NULL | ||||
| fulltext | mediumtext | NOT NULL | ||||
| state | tinyint(3) | NOT NULL | 0 | |||
| sectionid | integer unsigned | NOT NULL | 0 | |||
| mask | integer unsigned | NOT NULL | 0 | |||
| catid | integer unsigned | NOT NULL | 0 | |||
| created | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
| created_by | integer unsigned | NOT NULL | 0 | |||
| created_by_alias | varchar(255) | NOT NULL | ||||
| modified | datetime | NOT NULL | '0000-00-00 00:00:00' | |||
| modified_by | integer unsigned | NOT NULL | 0 | |||
| checked_out | integer 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' | |||
| images | text | NOT NULL | ||||
| urls | text | NOT NULL | ||||
| attribs | varchar(5120) | NOT NULL | ||||
| version | integer unsigned | NOT NULL | 1 | |||
| parentid | integer unsigned | NOT NULL | 0 | |||
| ordering | integer | NOT NULL | 0 | |||
| metakey | text | NOT NULL | ||||
| metadesc | text | NOT NULL | ||||
| access | integer unsigned | NOT NULL | 0 | |||
| hits | integer unsigned | NOT NULL | 0 | |||
| metadata | text | NOT NULL | ||||
| featured | tinyint(3) unsigned | NOT NULL | 0 | Flag indicating if article is featured. | ||
| language | char(7) | NOT NULL | The language code for the article. | |||
| xreference | varchar(50) | NOT NULL | A reference to enable linkages to external data sets. |
Notes
| Index Name | Column(s) | Unique? |
| idx_access | access | No |
| idx_checkout | checked_out | No |
| idx_state | state | No |
| idx_catid | catid | No |
| idx_createdby | created_by | No |
| idx_featured_cati | featured,catid | No |
| idx_language | language | No |
| idx_xreference | xreference | No |
- Default character set: utf8
