From fb58e16e640c8595893f7db9e2ba4017bc370a7c Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 1 Nov 2006 14:19:40 +0000 Subject: [PATCH] Update the updater. --- maintenance/updaters.inc | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index dbddc47019..6701498636 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -972,7 +972,7 @@ PGEND; BEGIN; --- Tighten up restrictions on the revisio table so we don't lose data: +-- Tighten up restrictions on the revision table so we don't lose data: ALTER TABLE revision DROP CONSTRAINT revision_rev_user_fkey; ALTER TABLE revision ADD CONSTRAINT revision_rev_user_fkey FOREIGN KEY (rev_user) REFERENCES mwuser(user_id) ON DELETE RESTRICT; @@ -980,6 +980,9 @@ ALTER TABLE revision ADD CONSTRAINT revision_rev_user_fkey -- New column for better password tracking: 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'; + -- New tables: CREATE TABLE redirect ( rd_from INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, -- 2.20.1