From bc07bc7acb089b7712e0b710aaaa18ae3fd8134e Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Thu, 15 Jan 2009 22:47:39 +0100 Subject: [PATCH] Same on pid. Signed-off-by: Florent Bruneau --- upgrade/newdirectory-0.0.1/00_names.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/upgrade/newdirectory-0.0.1/00_names.sql b/upgrade/newdirectory-0.0.1/00_names.sql index c4a0ce4..7497faf 100644 --- a/upgrade/newdirectory-0.0.1/00_names.sql +++ b/upgrade/newdirectory-0.0.1/00_names.sql @@ -60,7 +60,8 @@ CREATE TABLE IF NOT EXISTS profile_name_search ( name VARCHAR(255) NOT NULL COMMENT 'name to search for', particle VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'particle of the name to search for', typeid TINYINT(2) UNSIGNED NOT NULL COMMENT 'type of name', - PRIMARY KEY (pid, id) + PRIMARY KEY (pid, id), + INDEX pid (pid) ) CHARSET=utf8 COMMENT = 'Names of alumni (search table)'; INSERT INTO profile_name_search (pid, name, typeid) -- 2.1.4