rhosocial / yii2-user

migrations/M170307150614CreatePasswordHistoryTable.php

<?php

/**
 *   _   __ __ _____ _____ ___  ____  _____
 *  | | / // // ___//_  _//   ||  __||_   _|
 *  | |/ // /(__  )  / / / /| || |     | |
 *  |___//_//____/  /_/ /_/ |_||_|     |_|
 * @link https://vistart.me/
 * @copyright Copyright (c) 2016 - 2017 vistart
 * @license https://vistart.me/license/
 */

namespace rhosocial\user\migrations;

use rhosocial\user\User;
use rhosocial\user\security\PasswordHistory;

/**
 * Create Password History Table.
 *
 * This migration is equivalent to:
```SQL
CREATE TABLE `password_history` (
    `guid` varbinary(16) NOT NULL COMMENT 'Password GUID',
    `user_guid` varbinary(16) NOT NULL COMMENT 'Created By',
    `created_at` datetime NOT NULL COMMENT 'Created At',
    `pass_hash` varchar(80) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Password Hash',
    PRIMARY KEY (`guid`),
    KEY `user_password_fk` (`user_guid`),
    KEY `user_password_created_at_normal` (`created_at`) USING BTREE,
    CONSTRAINT `user_password_fk` FOREIGN KEY (`user_guid`) REFERENCES `user` (`guid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Password History';
```
 *
 * If you want to go back, please execute `yii migrate/to rhosocial\user\migrations\M170307150614CreatePasswordHistoryTable`,
 * instead of droping password history table yourself.
 * Note: this execution will reverse all the migrations after this migration.
 *
 * @version 1.0
 * @author vistart <i@vistart.me>
 */
class M170307150614CreatePasswordHistoryTable extends Migration
{
    public function up()
    {
        $tableOptions = null;

$tableOptions is not used, you could remove the assignment.

        if ($this->getDb()->driverName == 'mysql') {
            // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
            $tableOptions = "ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Password History'";
            $this->createTable(PasswordHistory::tableName(), [
                'guid' => $this->varbinary(16)->notNull()->comment('Password GUID'),
                'user_guid' => $this->varbinary(16)->notNull()->comment('Created By'),
                'created_at' => $this->dateTime()->notNull()->comment('Created At'),
                'pass_hash' => $this->varchar(80)->notNull()->comment('Password Hash'),
            ], $tableOptions);
        }
        $this->addPrimaryKey('password_guid_pk', PasswordHistory::tableName(), 'guid');
        $this->addForeignKey('user_password_fk', PasswordHistory::tableName(), 'user_guid', User::tableName(), 'guid', 'CASCADE', 'CASCADE');
        $this->createIndex('user_password_created_at_normal', PasswordHistory::tableName(), 'created_at');
    }

    public function down()
    {
        $this->dropTable(PasswordHistory::tableName());
    }

    /*
    // Use safeUp/safeDown to run migration code within a transaction
    public function safeUp()
    {
    }

    public function safeDown()
    {
    }
    */
}