fuelphp_migration.php

<?php

/* Aug. 21, 2015 - Akihiro TAKASE
 *
 * 本ファイルは User テーブル用のマイグレーションスクリプトです。
 *
 */

namespace Fuel\Migrations;

class Create_users {
  public function up() {
    \DBUtil::create_table('users', array(
      'id'              => array('constraint' => 11,  'type' => 'int', 'auto_increment' => true, 'unsigned' => true),
      'name'            => array('constraint' => 50,  'type' => 'varchar'),
      'email'           => array('constraint' => 255, 'type' => 'varchar'),
      'hashed_password' => array('constraint' => 64,  'type' => 'char'),
      'salt'            => array('constraint' => 32,  'type' => 'char'),
      're'              => array('type' => 'boolean'),
    ), array('id'));
  }

  public function down() {
    \DBUtil::drop_table('users');
  }
}