View file visavi-rotorcms-63832fa/app/database/migrations/20150921184410_create_news_table.php

<?php

use Phinx\Migration\AbstractMigration;

class CreateNewsTable extends AbstractMigration
{
	/**
	 * Change Method.
	 */
	public function change()
	{
		$table = $this->table('news');
		$table->addColumn('user_id', 'integer')
			->addColumn('title', 'string', ['limit' => 50])
			->addColumn('text', 'text')
			->addColumn('image', 'string', ['limit' => 50, 'null' => true])
			->addColumn('updated_at', 'timestamp')
			->addColumn('created_at', 'timestamp')
			->addIndex('created_at')
			->create();
	}
}