Add user_hidden column to mwuser table for Postgres schema.

[lhc/web/wiklou.git] / maintenance / postgres / tables.sql

diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql
index 6236f92..2dd02da 100644 (file)
--- 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);
 
@@ -555,11 +556,11 @@ CREATE UNIQUE INDEX category_title ON category(cat_title);
 CREATE INDEX category_pages ON category(cat_pages);
 
 CREATE TABLE change_tag (
-       ct_rc_id INTEGER NULL,
-       ct_log_id INTEGER NULL,
-       ct_rev_id INTEGER NULL,
-       ct_tag TEXT NOT NULL,
-       ct_params TEXT NULL
+  ct_rc_id   INTEGER      NULL,
+  ct_log_id  INTEGER      NULL,
+  ct_rev_id  INTEGER      NULL,
+  ct_tag     TEXT     NOT NULL,
+  ct_params  TEXT         NULL
 );
 CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag(ct_rc_id,ct_tag);
 CREATE UNIQUE INDEX change_tag_log_tag ON change_tag(ct_log_id,ct_tag);
@@ -567,17 +568,17 @@ CREATE UNIQUE INDEX change_tag_rev_tag ON change_tag(ct_rev_id,ct_tag);
 CREATE INDEX change_tag_tag_id ON change_tag(ct_tag,ct_rc_id,ct_rev_id,ct_log_id);
 
 CREATE TABLE tag_summary (
-       ts_rc_id INTEGER NULL,
-       ts_log_id INTEGER NULL,
-       ts_rev_id INTEGER NULL,
-       ts_tags TEXT NOT NULL
+  ts_rc_id   INTEGER     NULL,
+  ts_log_id  INTEGER     NULL,
+  ts_rev_id  INTEGER     NULL,
+  ts_tags    TEXT    NOT NULL
 );
 CREATE UNIQUE INDEX tag_summary_rc_id ON tag_summary(ts_rc_id);
 CREATE UNIQUE INDEX tag_summary_log_id ON tag_summary(ts_log_id);
 CREATE UNIQUE INDEX tag_summary_rev_id ON tag_summary(ts_rev_id);
 
 CREATE TABLE valid_tag (
-       vt_tag TEXT NOT NULL PRIMARY KEY
+  vt_tag TEXT NOT NULL PRIMARY KEY
 );
 
 CREATE TABLE mediawiki_version (