User:RichMorin/mw interwiki

Recognized InterWiki link prefixes

Inter-table Relationships

NA

MySQL Table Description

mysql> desc mw_interwiki;
+-----------+------------+------+-----+---------+-------+
| Field     | Type       | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| iw_prefix | char(32)   |      | PRI |         |       |
| iw_url    | char(127)  |      |     |         |       |
| iw_local  | tinyint(1) |      |     | 0       |       |
| iw_trans  | tinyint(1) |      |     | 0       |       |
+-----------+------------+------+-----+---------+-------+
4 rows in set

Annotated Table Creation Code

-- Recognized InterWiki link prefixes

CREATE TABLE /*$wgDBprefix*/interwiki (

  -- The interwiki prefix, (e.g. "Meatball",
  -- or the language prefix "de")

  iw_prefix           char(32)                    NOT NULL,
  
  -- The URL of the wiki, with "$1" as a placeholder
  -- for an article name. Any spaces in the name
  -- will be transformed to underscores before insertion.

  iw_url              char(127)                   NOT NULL,
  
  -- A Boolean value indicating whether the wiki
  -- is in this project. (used, for example,
  -- to detect redirect loops)

  iw_local            bool                        NOT NULL,
  
  -- Boolean value indicating whether InterWiki
  -- transclusions are allowed.

  iw_trans            tinyint(1)                  NOT NULL  default 0,
  
  UNIQUE KEY          iw_prefix (iw_prefix)

) ENGINE=InnoDB;