Manual:iwlinks table

From MediaWiki.org
Jump to navigation Jump to search
Translate this page
Other languages:
English • ‎español • ‎polski • ‎日本語
↑ Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout iwlinks table


MediaWiki version: ≥ 1.17

The iwlinks table stores the interwiki links with their targets. Not to confuse with the LanglinksManual:Langlinks table table.

Fields[edit]

iwl_from[edit]

The page_idManual:Page table#page_id of the referring page (i.e. the local page that the link appears on).

iwl_prefix[edit]

interwiki prefix code of the target. This is used the same way as a namespace is used when editing.

iwl_title[edit]

The title of the target page, including namespace (FULLPAGENAMEE style). Spaces are converted to underscores, but the first letter is not automatically capitalized. So for example, an interwiki link to w:foo bar would have an iwl_title of "foo_bar".

Schema summary[edit]

MediaWiki version: 1.17

DESCRIBE iwlinks; 

+------------+---------------------+------+-----+---------+-------+
| Field      | Type                | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| iwl_from   | int(10) unsigned    | NO   | PRI | 0       |       |
| iwl_prefix | varbinary(20)       | NO   | PRI |         |       |
| iwl_title  | varchar(255) binary | NO   | PRI |         |       |
+------------+---------------------+------+-----+---------+-------+

See also[edit]


Engines
Technical documentation
Configuration
Development
Core tables
actor – archive – bot_passwords – category – categorylinks – change_tag – comment – config – content – content_models – externallinks – filearchive – hitcounter – image – imagelinks – image_comment_temp – interwiki – iwlinks – ipblocks – ip_changes – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – revision_comment_temp – searchindex – sites – site_identifiers – site_stats – slots – slot_roles – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist
Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Iwlinks_table&oldid=2605579"