maintenance/archives/patch-log_search.sql

   1 CREATE TABLE /*_*/log_search (
   2         -- Key to log_type
   3         ls_log_type varbinary(32) NOT NULL,
   4         -- Key to log_action
   5         ls_log_action varbinary(32) NOT NULL,
   6         -- The type of ID (rev ID, timestamp, other)
   7         ls_field varbinary(32) NOT NULL,
   8         -- The value of the ID
   9         ls_value varchar(255) NOT NULL,
  10         -- Key to log_id
  11         ls_log_id int unsigned NOT NULL default 0
  12 );
  13 CREATE INDEX /*i*/log_field_value ON /*_*/log_search (ls_field,ls_value,ls_log_id);