psecio/gatekeeper

View on GitHub
migrations/20141214082627_create_group_permission_table.php

Summary

Maintainability
A
2 hrs
Test Coverage
<?php

class CreateGroupPermissionTable extends \Psecio\Gatekeeper\PhinxMigration
{
    protected $tableName = 'group_permission';

    /**
     * Migrate Up.
     */
    public function up()
    {
        $permissions = $this->table($this->getTableName());
        $permissions->addColumn('permission_id', 'integer')
              ->addColumn('group_id', 'integer')
              ->addColumn('created', 'datetime')
              ->addColumn('updated', 'datetime', array('default' => null))
              ->addIndex(array('permission_id', 'group_id'), array('unique' => true))
              ->save();
    }

    /**
     * Migrate Down.
     */
    public function down()
    {
        $this->dropTable($this->getTableName());
    }
}