[Summary view] [Print] [Text view]

   1  --
   2  -- Add iw_api and iw_wikiid to interwiki table
   3  --
   4  
   5  
   6  CREATE TABLE /*_*/interwiki_tmp (
   7    iw_prefix TEXT NOT NULL,
   8    iw_url BLOB NOT NULL,
   9    iw_api BLOB NOT NULL,
  10    iw_wikiid TEXT NOT NULL,
  11    iw_local INTEGER NOT NULL,
  12    iw_trans INTEGER NOT NULL default 0
  13  ) /*$wgDBTableOptions*/;
  14  
  15  INSERT INTO /*_*/interwiki_tmp SELECT iw_prefix, iw_url, '', '', iw_local, iw_trans FROM /*_*/interwiki;
  16  DROP TABLE /*_*/interwiki;
  17  ALTER TABLE /*_*/interwiki_tmp RENAME TO /*_*/interwiki;
  18  
  19  CREATE UNIQUE INDEX /*i*/iw_prefix ON /*_*/interwiki (iw_prefix);