From 3e2315637c6ed40a683633c8b893109370a2b1f5 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Tue, 19 Feb 2008 00:58:52 +0000 Subject: [PATCH] Add ipb_by_text to Postgres schema. --- maintenance/postgres/tables.sql | 1 + maintenance/updaters.inc | 1 + 2 files changed, 2 insertions(+) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 97ff17d508..9ea22bcfd7 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -220,6 +220,7 @@ CREATE TABLE ipblocks ( ipb_address TEXT NULL, ipb_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, ipb_by INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE CASCADE, + ipb_by_text TEXT NOT NULL DEFAULT '', ipb_reason TEXT NOT NULL, ipb_timestamp TIMESTAMPTZ NOT NULL, ipb_auto SMALLINT NOT NULL DEFAULT 0, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index e9a6ffc49d..15a578e556 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1340,6 +1340,7 @@ function do_postgres_updates() { array("archive", "ar_page_id", "INTEGER"), array("image", "img_sha1", "TEXT NOT NULL DEFAULT ''"), array("ipblocks", "ipb_anon_only", "CHAR NOT NULL DEFAULT '0'"), + array("ipblocks", "ipb_by_text", "TEXT NOT NULL DEFAULT ''"), array("ipblocks", "ipb_block_email", "CHAR NOT NULL DEFAULT '0'"), array("ipblocks", "ipb_create_account", "CHAR NOT NULL DEFAULT '1'"), array("ipblocks", "ipb_deleted", "SMALLINT NOT NULL DEFAULT 0"), -- 2.20.1