1 CREATE TABLE /*_*/log_search (
2 -- The type of ID (rev ID, log ID, rev timestamp, username)
3 ls_field
varbinary(32) NOT NULL,
5 ls_value
varchar(255) NOT NULL,
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
);