diff options
Diffstat (limited to 'maintenance/postgres/archives/patch-log_search.sql')
-rw-r--r-- | maintenance/postgres/archives/patch-log_search.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-log_search.sql b/maintenance/postgres/archives/patch-log_search.sql new file mode 100644 index 00000000..20a61fd7 --- /dev/null +++ b/maintenance/postgres/archives/patch-log_search.sql @@ -0,0 +1,9 @@ + +CREATE TABLE log_search ( + ls_field TEXT NOT NULL, + ls_value TEXT NOT NULL, + ls_log_id INTEGER NOT NULL DEFAULT 0 +); + +ALTER TABLE log_search ADD CONSTRAINT log_search_pk PRIMARY KEY(ls_field, ls_value, ls_log_id); +CREATE INDEX ls_log_id ON log_search (ls_log_id); |