From 1acb0c227dab546799131c824d57c6e5d58a5802 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.5