From 1e214a16c2d92c12383da8a17acd27f3cfcaa895 Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Wed, 22 Nov 2006 14:06:00 +0000 Subject: [PATCH] remove 'subkey' (255) for a field which is 40-chars long, fixes stuff... --- 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 709308a238..1a534954be 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(255), ipb_user, ipb_auto), + UNIQUE INDEX ipb_address_unique (ipb_address, 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 0d5dc3fe06..f23faaf2b6 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(255), ipb_user, ipb_auto, ipb_anon_only), + UNIQUE INDEX ipb_address (ipb_address, 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 ed8c68465c..ec3c44a160 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(255), ipb_user, ipb_auto, ipb_anon_only), + UNIQUE INDEX ipb_address (ipb_address, 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 d210179657..651c5e4719 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(255), ipb_user, ipb_auto, ipb_anon_only), + UNIQUE INDEX ipb_address (ipb_address, 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