[Summary view] [Print] [Text view]

   1  --
   2  -- Track inline interwiki links
   3  --
   4  CREATE TABLE /*_*/iwlinks (
   5    -- page_id of the referring page
   6    iwl_from int unsigned NOT NULL default 0,
   7  
   8    -- Interwiki prefix code of the target
   9    iwl_prefix varbinary(20) NOT NULL default '',
  10  
  11    -- Title of the target, including namespace
  12    iwl_title varchar(255) binary NOT NULL default ''
  13  ) /*$wgDBTableOptions*/;
  14  
  15  CREATE UNIQUE INDEX /*i*/iwl_from ON /*_*/iwlinks (iwl_from, iwl_prefix, iwl_title);
  16  CREATE UNIQUE INDEX /*i*/iwl_prefix_title_from ON /*_*/iwlinks (iwl_prefix, iwl_title, iwl_from);