View file visavi-rotorcms-63832fa/app/database/migrations/20150921185050_create_topics_table.php

<?php

use Phinx\Migration\AbstractMigration;
use Phinx\Db\Adapter\MysqlAdapter;

class CreateTopicsTable extends AbstractMigration
{

	/**
	 * Change Method.
	 */
	public function change()
	{
		$table = $this->table('topics');
		$table->addColumn('forum_id', 'integer')
			->addColumn('user_id', 'integer')
			->addColumn('title', 'string', ['limit' => 50])
			->addColumn('closed', 'boolean', ['default' => false])
			->addColumn('locked', 'boolean', ['default' => false])
			->addColumn('mods', 'string', ['limit' => 100, 'null' => true])
			->addColumn('note', 'string', ['null' => true])
			->addColumn('post_last_id', 'integer', ['null' => true])
			->addColumn('updated_at', 'timestamp')
			->addColumn('created_at', 'timestamp')
			->addIndex('forum_id')
			->addIndex('locked')
			->addIndex('updated_at')
			->create();

			// Удалить эту строку если версия MySQL ниже 5.6
			$mysql = $this->query("SHOW VARIABLES LIKE 'version'")->fetch();

			if(version_compare($mysql['Value'], '5.6.0', '>=')) {
				$this->execute('ALTER TABLE `topics` ADD FULLTEXT KEY (`title`)');
			}
	}
}