From f8299618ea6133cc10edbebfa8a8f3ece83a704e Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Wed, 22 Nov 2006 14:21:53 +0000 Subject: [PATCH] revert until proper cleanup --- maintenance/archives/patch-ipb_anon_only.sql | 2 +- maintenance/mysql5/tables-binary.sql | 2 +- maintenance/mysql5/tables.sql | 2 +- maintenance/tables.sql | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-) diff --git a/maintenance/archives/patch-ipb_anon_only.sql b/maintenance/archives/patch-ipb_anon_only.sql index 1a534954be..709308a238 100644 --- a/maintenance/archives/patch-ipb_anon_only.sql +++ b/maintenance/archives/patch-ipb_anon_only.sql @@ -24,7 +24,7 @@ CREATE TABLE /*$wgDBprefix*/ipblocks_newunique ( ipb_range_end tinyblob NOT NULL default '', PRIMARY KEY ipb_id (ipb_id), - UNIQUE INDEX ipb_address_unique (ipb_address, ipb_user, ipb_auto), + UNIQUE INDEX ipb_address_unique (ipb_address(255), ipb_user, ipb_auto), INDEX ipb_user (ipb_user), INDEX ipb_range (ipb_range_start(8), ipb_range_end(8)), INDEX ipb_timestamp (ipb_timestamp), diff --git a/maintenance/mysql5/tables-binary.sql b/maintenance/mysql5/tables-binary.sql index f23faaf2b6..0d5dc3fe06 100644 --- a/maintenance/mysql5/tables-binary.sql +++ b/maintenance/mysql5/tables-binary.sql @@ -619,7 +619,7 @@ CREATE TABLE /*$wgDBprefix*/ipblocks ( -- Unique index to support "user already blocked" messages -- Any new options which prevent collisions should be included - UNIQUE INDEX ipb_address (ipb_address, ipb_user, ipb_auto, ipb_anon_only), + UNIQUE INDEX ipb_address (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only), INDEX ipb_user (ipb_user), INDEX ipb_range (ipb_range_start(8), ipb_range_end(8)), diff --git a/maintenance/mysql5/tables.sql b/maintenance/mysql5/tables.sql index ec3c44a160..ed8c68465c 100644 --- a/maintenance/mysql5/tables.sql +++ b/maintenance/mysql5/tables.sql @@ -610,7 +610,7 @@ CREATE TABLE /*$wgDBprefix*/ipblocks ( -- Unique index to support "user already blocked" messages -- Any new options which prevent collisions should be included - UNIQUE INDEX ipb_address (ipb_address, ipb_user, ipb_auto, ipb_anon_only), + UNIQUE INDEX ipb_address (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only), INDEX ipb_user (ipb_user), INDEX ipb_range (ipb_range_start(8), ipb_range_end(8)), diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 651c5e4719..d210179657 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -598,7 +598,7 @@ CREATE TABLE /*$wgDBprefix*/ipblocks ( -- Unique index to support "user already blocked" messages -- Any new options which prevent collisions should be included - UNIQUE INDEX ipb_address (ipb_address, ipb_user, ipb_auto, ipb_anon_only), + UNIQUE INDEX ipb_address (ipb_address(255), ipb_user, ipb_auto, ipb_anon_only), INDEX ipb_user (ipb_user), INDEX ipb_range (ipb_range_start(8), ipb_range_end(8)), -- 2.20.1