maintenance/archives/patch-globalnamespaces.sql

   1 -- Table listing distant wiki namespace texts.
   2 CREATE TABLE /*_*/globalnamespaces (
   3   -- The wiki ID of the remote wiki
   4   gn_wiki varchar(64) NOT NULL,
   5
   6   -- The namespace ID of the transcluded page on that wiki
   7   gn_namespace int NOT NULL,
   8
   9   -- The namespace text of transcluded page
  10   -- Needed for display purposes, since the local namespace ID doesn't necessarily match a distant one
  11   gn_namespacetext varchar(255) NOT NULL
  12
  13 ) /*$wgDBTableOptions*/;
  14 CREATE UNIQUE INDEX /*i*/gn_index ON /*_*/globalnamespaces (gn_wiki, gn_namespace, gn_namespacetext);