2 CREATE TABLE log_search (
3 ls_field
TEXT NOT NULL,
4 ls_value
TEXT NOT NULL,
5 ls_log_id
INTEGER NOT NULL DEFAULT 0
8 ALTER TABLE log_search
ADD CONSTRAINT log_search_pk
PRIMARY KEY(ls_field
, ls_value
, ls_log_id
);
9 CREATE INDEX ls_log_id
ON log_search (ls_log_id
);