From 908c43105feb5b2f0ad8ad1f09bb5610baefc306 Mon Sep 17 00:00:00 2001 From: Alexandre Emsenhuber Date: Fri, 15 May 2009 11:34:18 +0000 Subject: [PATCH] Follow-up r50567: also update PostgreSQL and SQLite schema --- maintenance/postgres/archives/patch-log_search.sql | 9 +++++++++ maintenance/updaters.inc | 3 +++ 2 files changed, 12 insertions(+) create mode 100644 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 index 0000000000..20a61fd767 --- /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); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 1507936a43..42be378fb6 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -173,6 +173,8 @@ $wgUpdates = array( array( 'add_table', 'tag_summary', 'patch-change_tag.sql' ), array( 'add_table', 'valid_tag', 'patch-change_tag.sql' ), array( 'add_table', 'user_properties', 'patch-user_properties.sql' ), + array( 'add_table', 'log_search', 'patch-log_search.sql' ), + array( 'do_log_search_population' ), ), ); @@ -1537,6 +1539,7 @@ function do_postgres_updates() { array('tag_summary', 'patch-change_tag.sql'), array('valid_tag', 'patch-change_tag.sql'), array('user_properties', 'patch-user_properties.sql'), + array('log_search', 'patch-log_search.sql'), ); $newcols = array( -- 2.20.1