From 6ccceca064929af4f1c59da56586e3d3003bcdda Mon Sep 17 00:00:00 2001 From: Andreas Fischer Date: Sun, 13 Oct 2013 14:25:28 +0200 Subject: [ticket/11621] Add explanation to mysql_fulltext_drop. PHPBB3-11621 --- phpBB/phpbb/db/migration/data/v310/mysql_fulltext_drop.php | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'phpBB/phpbb/db/migration') diff --git a/phpBB/phpbb/db/migration/data/v310/mysql_fulltext_drop.php b/phpBB/phpbb/db/migration/data/v310/mysql_fulltext_drop.php index def4163190..97d174d4bc 100644 --- a/phpBB/phpbb/db/migration/data/v310/mysql_fulltext_drop.php +++ b/phpBB/phpbb/db/migration/data/v310/mysql_fulltext_drop.php @@ -26,6 +26,14 @@ class mysql_fulltext_drop extends \phpbb\db\migration\migration public function update_schema() { + /* + * Drop FULLTEXT indexes related to MySQL fulltext search. + * Doing so is equivalent to dropping the search index from the ACP. + * Possibly time-consuming recreation of the search index (i.e. + * FULLTEXT indexes) is left as a task to the admin to not + * unnecessarily stall the upgrade process. The new search index will + * then require about 40% less table space (also see PHPBB3-11621). + */ return array( 'drop_keys' => array( $this->table_prefix . 'posts' => array( -- cgit v1.2.1