maintenance/sqlite/archives/patch-externallinks-el_index_60-drop-default.sql

   1 -- To change the default on one column, sqlite requires we copy the whole table
   2
   3 CREATE TABLE /*_*/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   el_index_60 varbinary(60) NOT NULL
   9 ) /*$wgDBTableOptions*/;
  10
  11 INSERT INTO /*_*/externallinks_tmp
  12         SELECT el_id, el_from, el_to, el_index, el_index_60 FROM /*_*/externallinks;
  13
  14 DROP TABLE /*_*/externallinks;
  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));
  20 CREATE INDEX /*i*/el_index_60 ON /*_*/externallinks (el_index_60, el_id);
  21 CREATE INDEX /*i*/el_from_index_60 ON /*_*/externallinks (el_from, el_index_60, el_id);