From 6293e4a1ddb10d818e238187c04034162c717205 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sun, 27 Jan 2008 19:20:48 +0000 Subject: [PATCH] * Make rev_deleted an integer * Add rev_deleted to updaters.inc --- maintenance/postgres/tables.sql | 6 +++--- maintenance/updaters.inc | 1 + 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 1d05c51fa8..a0d19e13a6 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -89,10 +89,10 @@ CREATE TABLE revision ( rev_text_id INTEGER NULL, -- FK rev_comment TEXT, rev_user INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE RESTRICT, - rev_user_text TEXT NOT NULL, - rev_timestamp TIMESTAMPTZ NOT NULL, + rev_user_text TEXT NOT NULL, + rev_timestamp TIMESTAMPTZ NOT NULL, rev_minor_edit CHAR NOT NULL DEFAULT '0', - rev_deleted CHAR NOT NULL DEFAULT '0', + rev_deleted INTEGER NOT NULL DEFAULT 0, rev_len INTEGER NULL, rev_parent_id INTEGER NULL ); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 9f7ce2a29f..62aa4bddf3 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1360,6 +1360,7 @@ function do_postgres_updates() { array("recentchanges", "rc_old_len", "INTEGER"), array("recentchanges", "rc_params", "TEXT"), array("revision", "rev_len", "INTEGER"), + array("revision", "rev_deleted", "INTEGER NOT NULL DEFAULT 0"), ); -- 2.20.1