9.5/indexed__search_2_classes_2_service_2_database_schema_service_8php_source.html

<?php

namespace ‪TYPO3\CMS\IndexedSearch\Service;


/*

 * This file is part of the TYPO3 CMS project.

 *

 * It is free software; you can redistribute it and/or modify it under

 * the terms of the GNU General Public License, either version 2

 * of the License, or any later version.

 *

 * For the full copyright and license information, please read the

 * LICENSE.txt file that was distributed with this source code.

 *

 * The TYPO3 project - inspiring people to share!

 */

use ‪TYPO3\CMS\Core\Configuration\ExtensionConfiguration;

use ‪TYPO3\CMS\Core\Utility\GeneralUtility;


class ‪DatabaseSchemaService

{

    public function ‪addMysqlFulltextIndex(array $sqlString)

    {

        $useMysqlFulltext = (bool)GeneralUtility::makeInstance(ExtensionConfiguration::class)->get('indexed_search', 'useMysqlFulltext');

        if ($useMysqlFulltext) {

            // @todo: With MySQL 5.7 fulltext index on InnoDB is possible, check for that and keep inno if so.

            $sqlString[] = 'CREATE TABLE index_fulltext ('

                . LF . 'fulltextdata mediumtext,'

                . LF . 'metaphonedata mediumtext,'

                . LF . 'FULLTEXT fulltextdata (fulltextdata),'

                . LF . 'FULLTEXT metaphonedata (metaphonedata)'

                . LF . ') ENGINE=MyISAM;';

        }

        return [$sqlString];

    }

}