From 4dc70e763d4e79525567a91abdc2ab52d7666635 Mon Sep 17 00:00:00 2001 From: "Pierre Habouzit (MadCoder" Date: Tue, 12 Apr 2005 16:05:18 +0000 Subject: [PATCH] smaller sql index git-archimport-id: opensource@polytechnique.org--2005/platal--mainline--0.9--patch-536 --- htdocs/.arch-inventory | 1 + upgrade/0.9.6/10_search_name.sql | 4 ++-- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/htdocs/.arch-inventory b/htdocs/.arch-inventory index 9999134..f230e38 100644 --- a/htdocs/.arch-inventory +++ b/htdocs/.arch-inventory @@ -1 +1,2 @@ precious ^valid.html +precious phps$ diff --git a/upgrade/0.9.6/10_search_name.sql b/upgrade/0.9.6/10_search_name.sql index 0c49a14..111b75b 100644 --- a/upgrade/0.9.6/10_search_name.sql +++ b/upgrade/0.9.6/10_search_name.sql @@ -3,8 +3,8 @@ CREATE TABLE `search_name` ( `uid` int(11) NOT NULL default '0', `token` char(255) NOT NULL default '', `score` int(11) NOT NULL default '0', - PRIMARY KEY (uid, token), - INDEX (token) + PRIMARY KEY (token,uid), + INDEX (uid) ); -- 2.1.4