[Summary view] [Print] [Text view]

   1  DROP TABLE IF EXISTS /*_*/externallinks_tmp;
   2  
   3  CREATE TABLE /*$wgDBprefix*/externallinks_tmp (
   4     el_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
   5     el_from int unsigned NOT NULL default 0,
   6     el_to blob NOT NULL,
   7     el_index blob NOT NULL
   8  );
   9  
  10  INSERT OR IGNORE INTO /*_*/externallinks_tmp (el_from, el_to, el_index) SELECT
  11      el_from, el_to, el_index FROM /*_*/externallinks;
  12  
  13  DROP TABLE /*_*/externallinks;
  14  
  15  ALTER TABLE /*_*/externallinks_tmp RENAME TO /*_*/externallinks;
  16  
  17  CREATE INDEX /*i*/el_from ON /*_*/externallinks (el_from, el_to(40));
  18  CREATE INDEX /*i*/el_to ON /*_*/externallinks (el_to(60), el_from);
  19  CREATE INDEX /*i*/el_index ON /*_*/externallinks (el_index(60));