--
DROP TABLE IF EXISTS /*$wgDBprefix*/links;
CREATE TABLE /*$wgDBprefix*/links (
- l_from int(8) unsigned NOT NULL default '0',
- l_to int(8) unsigned NOT NULL default '0',
+ -- Key to the page_id of the page containing the link.
+ l_from int unsigned NOT NULL default '0',
+
+ -- Key to the page_id of the link target.
+ -- An unfortunate consequence of this is that rename
+ -- operations require changing the links entries for
+ -- all links to the moved page.
+ l_to int unsigned NOT NULL default '0',
+
UNIQUE KEY l_from(l_from,l_to),
KEY (l_to)
-);
+
+) /*$wgDBTableOptions*/;
--
-- Track links to pages that don't yet exist.
--
DROP TABLE IF EXISTS /*$wgDBprefix*/brokenlinks;
CREATE TABLE /*$wgDBprefix*/brokenlinks (
- bl_from int(8) unsigned NOT NULL default '0',
+ -- Key to the page_id of the page containing the link.
+ bl_from int unsigned NOT NULL default '0',
+
+ -- Text of the target page title ("namesapce:title").
+ -- Unfortunately this doesn't split the namespace index
+ -- key and therefore can't easily be joined to anything.
bl_to varchar(255) binary NOT NULL default '',
UNIQUE KEY bl_from(bl_from,bl_to),
KEY (bl_to)
-);
+
+) /*$wgDBTableOptions*/;
--
-- Track links to images *used inline*
--
DROP TABLE IF EXISTS /*$wgDBprefix*/imagelinks;
CREATE TABLE /*$wgDBprefix*/imagelinks (
- il_from int(8) unsigned NOT NULL default '0',
+ -- Key to page_id of the page containing the image / media link.
+ il_from int unsigned NOT NULL default '0',
+
+ -- Filename of target image.
+ -- This is also the page_title of the file's description page;
+ -- all such pages are in namespace 6 (NS_FILE).
il_to varchar(255) binary NOT NULL default '',
+
UNIQUE KEY il_from(il_from,il_to),
KEY (il_to)
-);
+
+) /*$wgDBTableOptions*/;
--
-- Stores (possibly gzipped) serialized objects with
CREATE TABLE /*$wgDBprefix*/linkscc (
lcc_pageid INT UNSIGNED NOT NULL UNIQUE KEY,
lcc_cacheobj MEDIUMBLOB NOT NULL
-);
+
+) /*$wgDBTableOptions*/;