Tables/newsfeeds

Usage

• Since:

Description

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'

Notes

Indices

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