PhraseFts::createTable

static function createTable(string $langId): void
{
	$partitionTable = self::getPartitionTableName($langId);

	$suffix = mb_strtoupper($langId);

	Application::getConnection()->queryExecute("
		CREATE TABLE IF NOT EXISTS `{$partitionTable}` (
			`ID` int not null,
			`FILE_ID` int not null,
			`PATH_ID` int not null,
			`CODE` varchar(255) BINARY not null,
			`PHRASE` text,
			PRIMARY KEY (`ID`),
			UNIQUE KEY `IXU_TRNSL_FTS_PT_{$suffix}` (`PATH_ID`, `CODE`),
			UNIQUE KEY `IXU_TRNSL_FTS_FL_{$suffix}` (`FILE_ID`, `CODE`),
			FULLTEXT INDEX `IXF_TRNSL_FTS_PH_{$suffix}` (`PHRASE`)
		) DELAY_KEY_WRITE=1
	");
}