From 710a2ffc14074394786b67e2f614c4d84e5caa19 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Mon, 16 May 2011 21:49:36 +0200 Subject: [PATCH] Not unique key after all... MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.1.2/01_geocoding.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/upgrade/1.1.2/01_geocoding.sql b/upgrade/1.1.2/01_geocoding.sql index 051ff08..edae184 100644 --- a/upgrade/1.1.2/01_geocoding.sql +++ b/upgrade/1.1.2/01_geocoding.sql @@ -7,7 +7,7 @@ CREATE TABLE profile_addresses_components_enum ( long_name VARCHAR(255) NOT NULL DEFAULT '', types SET('street_address', 'route', 'intersection', 'political', 'country', 'administrative_area_level_1', 'administrative_area_level_2', 'administrative_area_level_3', 'colloquial_area', 'locality', 'sublocality', 'neighborhood', 'premise', 'subpremise', 'postal_code', 'natural_feature', 'airport', 'park', 'point_of_interest', 'post_box', 'street_number', 'floor', 'room') NOT NULL DEFAULT '', PRIMARY KEY (id), - UNIQUE KEY (types, long_name), + KEY (types, long_name), KEY (types, short_name) ) ENGINE=InnoDB, CHARSET=utf8; -- 2.1.4