MediaWiki 1.16.0

[autoinstallsdev/mediawiki.git] / maintenance / postgres / archives / patch-log_search.sql

diff --git a/maintenance/postgres/archives/patch-log_search.sql b/maintenance/postgres/archives/patch-log_search.sql
new file mode 100644 (file)
index 0000000..20a61fd
--- /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);