From 7764aac112b77665b43010d4d1bd24ee219c8616 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Mon, 6 Nov 2006 02:31:59 +0000 Subject: [PATCH] Change ipb_address to text due to recent report. --- maintenance/postgres/tables.sql | 2 +- maintenance/updaters.inc | 3 +++ 2 files changed, 4 insertions(+), 1 deletion(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index a74e7348ff..fffa8910e5 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -211,7 +211,7 @@ CREATE TABLE hitcounter ( CREATE SEQUENCE ipblocks_ipb_id_val; CREATE TABLE ipblocks ( ipb_id INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('ipblocks_ipb_id_val'), - ipb_address CIDR NULL, + 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_reason TEXT NOT NULL, diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 009882ae4f..6552c7b259 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -982,6 +982,9 @@ ALTER TABLE mwuser ADD user_newpass_time TIMESTAMPTZ; -- New column for autoblocking problem users ALTER TABLE ipblocks ADD ipb_enable_autoblock CHAR NOT NULL DEFAULT '1'; +-- Despite it's name, ipb_address does not necessarily contain IP addresses :) +ALTER TABLE ipblocks ALTER ipb_address TYPE TEXT USING ipb_address::TEXT; + -- New tables: CREATE TABLE redirect ( rd_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, -- 2.20.1