From Joomla! Documentation

< Tables


  • Since:


newsfeeds Table (#__newsfeeds)
Field Type Nullable Default Key Extra Comments
catid integer NOT NULL 0
id integer(10) unsigned NOT NULL PK auto_increment
name varchar(100) NOT NULL
alias varchar(100) NOT NULL
link varchar(200) NOT NULL
filename varchar(200) NULL
published tinyint(1) NOT NULL 0
numarticles integer unsigned NOT NULL 1
cache_time integer unsigned NOT NULL 3600
checked_out integer(10) unsigned NOT NULL 0
checked_out_time datetime NOT NULL '0000-00-00 00:00:00'
ordering integer NOT NULL 0
rtl tinyint(4) NOT NULL 0
access tinyint UNSIGNED NOT NULL 0
language char(7) NOT NULL
params text NOT NULL
created datetime NOT NULL '0000-00-00 00:00:00'
created_by int(10) unsigned NOT NULL 0
created_by_alias varchar(255) NOT NULL
modified datetime NOT NULL '0000-00-00 00:00:00'
modified_by int(10) unsigned NOT NULL 0
metakey text NOT NULL
metadesc text NOT NULL
metadata text NOT NULL
xreference varchar(50) NOT NULL A reference to enable linkages to external data sets.
publish_up datetime NOT NULL '0000-00-00 00:00:00'
publish_down datetime NOT NULL '0000-00-00 00:00:00'


Index Name Column(s) Unique?
idx_access access No
idx_checkout checked_out No
idx_state published No
idx_catid catid No
idx_createdby created_by No
idx_language language No
idx_xreference xreference No
  • Default character set: utf8