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

1 files changed, 6 insertions, 3 deletions

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;