maintenance/sqlite/archives/patch-log_search-fix-pk.sql

   1 CREATE TABLE /*_*/log_search_tmp (
   2   -- The type of ID (rev ID, log ID, rev timestamp, username)
   3   ls_field varbinary(32) NOT NULL,
   4   -- The value of the ID
   5   ls_value varchar(255) NOT NULL,
   6   -- Key to log_id
   7   ls_log_id int unsigned NOT NULL default 0,
   8   PRIMARY KEY (ls_field,ls_value,ls_log_id)
   9 ) /*$wgDBTableOptions*/;
  10
  11 INSERT INTO /*_*/log_search_tmp
  12         SELECT * FROM /*_*/log_search;
  13
  14 DROP TABLE /*_*/log_search;
  15
  16 ALTER TABLE /*_*/log_search_tmp RENAME TO /*_*/log_search;
  17
  18 CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id);