Database table art_lang
- dominik.ziegler
- mischa.holz
Owned by dominik.ziegler
Usage
The table art_lang contains all language related information about an Article, but not its content.
Normally, data of this table is managed automatically and must not be set explicitly.
Table structure
| 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 |
Generic DB information
| ItemCollection | Item |
|---|---|
| cApiArticleLanguageCollection | cApiArticleLanguage |
Previous changes of this table
| Field name | Description | Introduced with version |
|---|---|---|
| redirect_code | Added to the database table. | 4.9.3 |