The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Description:[edit]
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' |
|
|
|
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