From e06d5db3f81d9357329e643b1e3c170d7d47324e Mon Sep 17 00:00:00 2001 From: marcus Date: Wed, 18 Jun 2008 14:40:20 +0000 Subject: Fixes #41: User full text search. See caveats in function search_for_user() git-svn-id: https://code.elgg.org/elgg/trunk@967 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'engine/schema') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index c981b0a56..749ee5bcf 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -104,7 +104,8 @@ CREATE TABLE `prefix_objects_entity` ( `title` text NOT NULL, `description` text NOT NULL, - PRIMARY KEY (`guid`) + PRIMARY KEY (`guid`), + FULLTEXT KEY (`title`,`description`) ) ; -- Extra information relating to "sites" @@ -116,7 +117,8 @@ CREATE TABLE `prefix_sites_entity` ( `url` varchar(255) NOT NULL, PRIMARY KEY (`guid`), - UNIQUE KEY (`url`) + UNIQUE KEY (`url`), + FULLTEXT KEY (`name`,`description`, `url`) ) ; -- Extra information relating to "users" @@ -138,7 +140,8 @@ CREATE TABLE `prefix_users_entity` ( PRIMARY KEY (`guid`), KEY `password` (`password`), - FULLTEXT KEY `name` (`name`) + FULLTEXT KEY `name` (`name`), + FULLTEXT KEY (`name`,`username`) ) ENGINE=MyISAM; -- cgit v1.2.3