From 3bf3b6686c699292fb86c9d24658eab0ce5beb71 Mon Sep 17 00:00:00 2001 From: Zach Copley Date: Sun, 18 Sep 2011 14:17:41 -0700 Subject: [PATCH] Remove fulltext indexes from notice and profile tables. The default for fulltext search is 'like' (MySQLLikeSearch) which doesn't require them. --- classes/Notice.php | 3 --- classes/Profile.php | 5 +---- 2 files changed, 1 insertion(+), 7 deletions(-) diff --git a/classes/Notice.php b/classes/Notice.php index e34dab549f..a38f54f050 100644 --- a/classes/Notice.php +++ b/classes/Notice.php @@ -127,9 +127,6 @@ class Notice extends Managed_DataObject 'notice_created_idx' => array('created'), 'notice_replyto_idx' => array('reply_to'), 'notice_repeatof_idx' => array('repeat_of'), - ), - 'fulltext indexes' => array( - 'content' => array('content'), ) ); } diff --git a/classes/Profile.php b/classes/Profile.php index 5ace57004c..8cea91ece6 100644 --- a/classes/Profile.php +++ b/classes/Profile.php @@ -72,10 +72,7 @@ class Profile extends Managed_DataObject 'primary key' => array('id'), 'indexes' => array( 'profile_nickname_idx' => array('nickname'), - ), - 'fulltext indexes' => array( - 'nickname' => array('nickname', 'fullname', 'location', 'bio', 'homepage') - ), + ) ); } -- 2.39.2