From 7d3e76c415859151e7d955bffa69ae4574c0acb7 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Fri, 20 Mar 2009 01:15:41 +0000 Subject: [PATCH] Revert r48212 "Add user_hidden field to complement ipb_deleted and gu_hidden" Unauthorized schema change, also appears to be unused. --- maintenance/archives/patch-user_hidden.sql | 3 --- maintenance/postgres/tables.sql | 3 +-- maintenance/tables.sql | 5 +---- maintenance/updaters.inc | 1 - 4 files changed, 2 insertions(+), 10 deletions(-) delete mode 100644 maintenance/archives/patch-user_hidden.sql diff --git a/maintenance/archives/patch-user_hidden.sql b/maintenance/archives/patch-user_hidden.sql deleted file mode 100644 index bca1d21baf..0000000000 --- a/maintenance/archives/patch-user_hidden.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Adding user_hidden field for revisiondelete -ALTER TABLE /*$wgDBprefix*/user - ADD user_hidden bool NOT NULL default 0; diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index a92b719ed0..74c3139c0a 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -25,8 +25,7 @@ CREATE TABLE mwuser ( -- replace reserved word 'user' user_options TEXT, user_touched TIMESTAMPTZ, user_registration TIMESTAMPTZ, - user_editcount INTEGER, - user_hidden SMALLINT NOT NULL DEFAULT 0 + user_editcount INTEGER ); CREATE INDEX user_email_token_idx ON mwuser (user_email_token); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 7d4fc619d4..2927833248 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -126,10 +126,7 @@ CREATE TABLE /*_*/user ( -- Meant primarily for heuristic checks to give an impression of whether -- the account has been used much. -- - user_editcount int, - - -- Flag for entries hidden from users and Sysops - user_hidden bool NOT NULL default 0 + user_editcount int ) /*$wgDBTableOptions*/; CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user (user_name); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 33e791332a..b9f491e8de 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -155,7 +155,6 @@ $wgUpdates = array( array( 'add_table', 'change_tag', 'patch-change_tag.sql' ), array( 'add_table', 'tag_summary', 'patch-change_tag.sql' ), array( 'add_table', 'valid_tag', 'patch-change_tag.sql' ), - array( 'add_field', 'user', 'user_hidden', 'patch-user_hidden.sql' ), ), 'sqlite' => array( -- 2.20.1