From 2a6c9a1dfc96d67549d18c6ca1db7155c778b08e Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Thu, 12 Mar 2009 14:35:40 +0000 Subject: [PATCH] Add user_hidden column to mwuser table for Postgres schema. --- maintenance/postgres/tables.sql | 3 ++- maintenance/updaters.inc | 1 + 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 4ffd3e098a..2dd02da902 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -25,7 +25,8 @@ CREATE TABLE mwuser ( -- replace reserved word 'user' user_options TEXT, user_touched TIMESTAMPTZ, user_registration TIMESTAMPTZ, - user_editcount INTEGER + user_editcount INTEGER, + user_hidden SMALLINT NOT NULL DEFAULT 0 ); CREATE INDEX user_email_token_idx ON mwuser (user_email_token); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 6d0003d540..bd01eec4d8 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1523,6 +1523,7 @@ function do_postgres_updates() { array("logging", "log_id", "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('log_log_id_seq')"), array("logging", "log_params", "TEXT"), array("mwuser", "user_editcount", "INTEGER"), + array("mwuser", "user_hidden", "SMALLINT NOT NULL DEFAULT 0"), array("mwuser", "user_newpass_time", "TIMESTAMPTZ"), array("oldimage", "oi_deleted", "SMALLINT NOT NULL DEFAULT 0"), array("oldimage", "oi_major_mime", "TEXT NOT NULL DEFAULT 'unknown'"), -- 2.20.1