psecio/gatekeeper

View on GitHub
migrations/20150218151720_create_security_questions_table.php

Summary

Maintainability
A
0 mins
Test Coverage
<?php

class CreateSecurityQuestionsTable extends \Psecio\Gatekeeper\PhinxMigration
{
    protected $tableName = 'security_questions';

    /**
     * Migrate Up.
     */
    public function up()
    {
        $tokens = $this->table($this->getTableName());
        $tokens->addColumn('question', 'string')
            ->addColumn('answer', 'string', array('limit' => 100))
            ->addColumn('user_id', 'integer')
            ->addColumn('created', 'datetime')
            ->addColumn('updated', 'datetime', array('default' => null))
            ->save();
    }

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