diff options
Diffstat (limited to 'www/wiki/maintenance/postgres/archives/patch-log_search.sql')
-rw-r--r-- | www/wiki/maintenance/postgres/archives/patch-log_search.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/www/wiki/maintenance/postgres/archives/patch-log_search.sql b/www/wiki/maintenance/postgres/archives/patch-log_search.sql new file mode 100644 index 00000000..4c0b3c61 --- /dev/null +++ b/www/wiki/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_pkey PRIMARY KEY(ls_field, ls_value, ls_log_id); +CREATE INDEX ls_log_id ON log_search (ls_log_id); |