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]
weblinks Table (#__weblinks)
Field |
Type |
Nullable |
Default |
Key |
Extra |
Comments
|
id |
integer unsigned |
NOT NULL |
|
PK |
auto_increment |
|
catid |
integer |
NOT NULL |
0 |
|
|
|
sid |
integer |
NOT NULL |
0 |
|
|
|
title |
varchar(250) |
NOT NULL |
|
|
|
|
alias |
varchar(255) |
NOT NULL |
|
|
|
|
url |
varchar(250) |
NOT NULL |
|
|
|
|
description |
text |
NOT NULL |
|
|
|
|
date |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
hits |
integer |
NOT NULL |
0 |
|
|
|
state |
tinyint(1) |
NOT NULL |
0 |
|
|
|
checked_out |
integer |
NOT NULL |
0 |
|
|
|
checked_out_time |
datetime |
NOT NULL |
'0000-00-00 00:00:00' |
|
|
|
ordering |
integer |
NOT NULL |
0 |
|
|
|
archived |
tinyint(1) |
NOT NULL |
0 |
|
|
|
approved |
tinyint(1) |
NOT NULL |
1 |
|
|
|
access |
integer |
NOT NULL |
1 |
|
|
|
params |
text |
NOT NULL |
|
|
|
|
language |
char(7) |
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 |
|
|
|
|
featured |
tinyint(3) unsigned |
NOT NULL |
0 |
|
|
Set if link is featured.
|
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 |
state |
No
|
idx_catid |
catid |
No
|
idx_createdby |
created_by |
No
|
idx_featured_catid |
featured,catid |
No
|
idx_language |
language |
No
|
idx_xreference |
xreference |
No
|
- Default character set: utf8