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,
8 PRIMARY KEY (ls_field
,ls_value
,ls_log_id
)
10 CREATE INDEX /*i*/ls_log_id
ON /*_*/log_search (ls_log_id
);