Split down patch-comment-table.sql
[lhc/web/wiklou.git] / maintenance / archives / patch-interwiki.sql
1 -- Creates interwiki prefix<->url mapping table
2 -- used from 2003-08-21 dev version.
3 -- Import the default mappings from maintenance/interwiki.sql
4
5 CREATE TABLE /*$wgDBprefix*/interwiki (
6 -- The interwiki prefix, (e.g. "Meatball", or the language prefix "de")
7 iw_prefix varchar(32) NOT NULL,
8
9 -- The URL of the wiki, with "$1" as a placeholder for an article name.
10 -- Any spaces in the name will be transformed to underscores before
11 -- insertion.
12 iw_url blob NOT NULL,
13
14 -- A boolean value indicating whether the wiki is in this project
15 -- (used, for example, to detect redirect loops)
16 iw_local BOOL NOT NULL,
17
18 UNIQUE KEY iw_prefix (iw_prefix)
19
20 ) /*$wgDBTableOptions*/;