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]
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]
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