Просмотр файла app/database/migrations/20161216115945_create_catsblog_table.php

Размер файла: 619B
  1. <?php
  2.  
  3. use Phinx\Migration\AbstractMigration;
  4. use Phinx\Db\Adapter\MysqlAdapter;
  5.  
  6. class CreateCatsblogTable extends AbstractMigration
  7. {
  8. /**
  9. * Change Method.
  10. */
  11. public function change()
  12. {
  13. $table = $this->table('catsblog', ['collation' => 'utf8mb4_unicode_ci']);
  14. $table->addColumn('sort', 'integer', ['limit' => MysqlAdapter::INT_SMALL, 'signed' => false, 'default' => 0])
  15. ->addColumn('name', 'string', ['limit' => 100])
  16. ->addColumn('count', 'integer', ['limit' => MysqlAdapter::INT_MEDIUM, 'signed' => false, 'default' => 0])
  17. ->create();
  18. }
  19. }