20161031101316_AddSecretToUsers.php

<?php
/**
 * Copyright 2010 - 2019, Cake Development Corporation (https://www.cakedc.com)
 *
 * Licensed under The MIT License
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright Copyright 2010 - 2018, Cake Development Corporation (https://www.cakedc.com)
 * @license MIT License (http://www.opensource.org/licenses/mit-license.php)
 */

use Migrations\AbstractMigration;

class AddSecretToUsers extends AbstractMigration
{
    /**
     * Change Method.
     *
     * More information on this method is available here:
     * http://docs.phinx.org/en/latest/migrations.html#the-change-method
     * @return void
     */
    public function change()
    {
        $table = $this->table('users');
        /**
         * Limiting secret field to 32 chars
         * @see https://en.wikipedia.org/wiki/Google_Authenticator#Technical_description
         */
        $table->addColumn('secret', 'string', [
            'after' => 'activation_date',
            'default' => null,
            'limit' => 32,
            'null' => true,
        ]);
        $table->addColumn('secret_verified', 'boolean', [
            'after' => 'secret',
            'default' => null,
            'null' => true,
        ]);
        $table->update();
    }
}