...
The table art_lang contains all language related information about an article Article, but not its content.
Normally, data of this table is managed automatically and must not be set explicitly.
...
Field name | Field specification | Comment / Explanation |
---|---|---|
idartlang | int(11) | Primary key (auto increment) |
idart | int(11) | Foreign key to table art |
idlang | int(11) | Foreign key to table lang |
idtplcfg | int(11) | Foreign key to table template_conf |
title | varchar(255) | Title of the article |
urlname | varchar(255) | Alias of the article |
pagetitle | varchar(255) | Page title of the article |
summary | text | Short summary of the article |
artspec | int(11) | Foreign key to table art_spec |
created | datetime | Date and time of creation |
lastmodified | datetime | Date and time of last modification |
author | varchar(32) | Username of the articles author |
modifiedby | varchar(32) | Username of the last modifier |
published | datetime | Date and time of the publication |
publishedby | varchar(32) | Username of the publisher |
online | tinyint(1) | Flag whether the article is online or not |
redirect | int(6) | Flag whether this article redirects to another location |
redirect_url | varchar(255) | Redirection location |
redirect_code | varchar(25) | Type of redirect (permanent or temporary) |
artsort | int(11) | Sort key of this article |
timemgmt | tinyint(1) | Flag for activation of time managed publication |
datestart | datetime | Start date and time for time managed publication |
dateend | datetime | Start date and time for time managed publication |
status | int(11) | Unused. |
free_use_01 | mediumint(7) | Free usage field 1 |
free_use_02 | mediumint(7) | Free usage field 2 |
free_use_03 | mediumint(7) | Free usage field 3 |
time_move_cat | mediumint(7) | Flag for moving to another category after reaching end date and time |
time_target_cat | mediumint(7) | Foreign key to table cat as reference for the target category to move |
time_online_move | mediumint(7)? | Flag whether article should be online after moving to target category or not |
external_redirect | char(1) | ? |
locked | int(1) | Flag for lock state of the article |
searchable | tinyint(1) | Flag for search engines to respect that article can be searched or not |
sitemapprio | float | Priority of article in XML sitemap |
changefreq | varchar(12) | Change frequency for XML sitemap |
...
Previous changes of this table
...
Field name | Description | Introduced with version |
---|---|---|
redirect_code | Added to the database table. | 4.9.3 |