1 CREATE TABLE /*_*/log_search (
2 -- The type of ID (rev ID, log ID, timestamp, other)
3 ls_field
varbinary(32) NOT NULL,
5 ls_value
varchar(255) NOT NULL,
7 ls_log_id
int unsigned
NOT NULL default 0
9 CREATE INDEX /*i*/log_field_value
ON /*_*/log_search (ls_field
,ls_value
,ls_log_id
);