From dba3ca83e44b812ab4adcea8561ee5edf5eb1b89 Mon Sep 17 00:00:00 2001 From: Alexandre Emsenhuber Date: Fri, 24 Apr 2009 08:49:29 +0000 Subject: [PATCH] Follow-up r49790: update the PostgreSQL schema --- maintenance/postgres/archives/patch-user_properties.sql | 8 ++++++++ maintenance/postgres/tables.sql | 8 ++++++++ maintenance/updaters.inc | 5 +++-- 3 files changed, 19 insertions(+), 2 deletions(-) create mode 100644 maintenance/postgres/archives/patch-user_properties.sql diff --git a/maintenance/postgres/archives/patch-user_properties.sql b/maintenance/postgres/archives/patch-user_properties.sql new file mode 100644 index 0000000000..4c930c80c8 --- /dev/null +++ b/maintenance/postgres/archives/patch-user_properties.sql @@ -0,0 +1,8 @@ +CREATE TABLE user_properties( + up_user BIGINT NOT NULL, + up_property TEXT NOT NULL, + up_value TEXT +); + +CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property); +CREATE INDEX user_properties_property on user_properties (up_property); diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 74c3139c0a..e6485f7f8b 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -580,6 +580,14 @@ CREATE TABLE valid_tag ( vt_tag TEXT NOT NULL PRIMARY KEY ); +CREATE TABLE user_properties( + up_user BIGINT NOT NULL, + up_property TEXT NOT NULL, + up_value TEXT +); +CREATE UNIQUE INDEX user_properties_user_property on user_properties (up_user,up_property); +CREATE INDEX user_properties_property on user_properties (up_property); + CREATE TABLE mediawiki_version ( type TEXT NOT NULL, mw_version TEXT NOT NULL, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 72ccc8d50c..b404e9f0a5 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1503,8 +1503,9 @@ function do_postgres_updates() { array("redirect", "patch-redirect.sql"), array("updatelog", "patch-updatelog.sql"), array('change_tag', 'patch-change_tag.sql'), - array('tag_summary', 'patch-change_tag.sql'), - array('valid_tag', 'patch-change_tag.sql'), + array('tag_summary', 'patch-change_tag.sql'), + array('valid_tag', 'patch-change_tag.sql'), + array('user_properties', 'patch-user_properties.sql'), ); $newcols = array( -- 2.20.1