[Summary view] [Print] [Text view]

   1  CREATE TABLE /*_*/log_search (
   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  ) /*$wgDBTableOptions*/;
   9  CREATE UNIQUE INDEX /*i*/ls_field_val ON /*_*/log_search (ls_field,ls_value,ls_log_id);
  10  CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id);