From ab1edeb9a8e0167a61521943d12480fbfd45b402 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Mon, 28 Jan 2008 01:35:31 +0000 Subject: [PATCH] Normalize _deleted stuff --- maintenance/postgres/tables.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index a0d19e13a6..5fcd8b8dfa 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -92,7 +92,7 @@ CREATE TABLE revision ( rev_user_text TEXT NOT NULL, rev_timestamp TIMESTAMPTZ NOT NULL, rev_minor_edit CHAR NOT NULL DEFAULT '0', - rev_deleted INTEGER NOT NULL DEFAULT 0, + rev_deleted SMALLINT NOT NULL DEFAULT 0, rev_len INTEGER NULL, rev_parent_id INTEGER NULL ); @@ -229,7 +229,7 @@ CREATE TABLE ipblocks ( ipb_expiry TIMESTAMPTZ NOT NULL, ipb_range_start TEXT, ipb_range_end TEXT, - ipb_deleted CHAR NOT NULL DEFAULT '0', + ipb_deleted SMALLINT NOT NULL DEFAULT 0, ipb_block_email CHAR NOT NULL DEFAULT '0' ); @@ -423,7 +423,7 @@ CREATE TABLE logging ( log_title TEXT NOT NULL, log_comment TEXT, log_params TEXT, - log_deleted INTEGER NOT NULL DEFAULT 0 + log_deleted SMALLINT NOT NULL DEFAULT 0 ); CREATE INDEX logging_type_name ON logging (log_type, log_timestamp); CREATE INDEX logging_user_time ON logging (log_timestamp, log_user); -- 2.20.1