Difference between revisions of "Tables/weblinks"

From Joomla! Documentation

< Tables
(New page: == Usage: == * Since: == Description: == {| border="1" |+ '''weblinks Table (#__weblinks)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- ...)
 
m (categorisation)
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
== Usage: ==
+
== Usage ==
 
* Since:
 
* Since:
  
== Description: ==
+
== Description ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''weblinks Table (#__weblinks)'''
 
|+ '''weblinks Table (#__weblinks)'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
Line 72: Line 72:
 
== Notes ==
 
== Notes ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''Indices'''
 
|+ '''Indices'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
Line 95: Line 95:
  
 
* Default character set: '''utf8'''
 
* Default character set: '''utf8'''
 +
 +
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 10:39, 16 March 2013

Usage[edit]

  • Since:

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'

Notes[edit]

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