Joomla! Documentation™

Usage

• Since:

Description

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'

Notes

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