FM / migrations

/var/www/vhosts/nabawater/vendor/dektrium/yii2-user/migrations/

/var/www/vhosts/nabawater/vendor/dektrium/yii2-user/migrations

Name	Size	Mode	Actions
m140209_132017_init.php	2805	0644	edit dl rm
m140403_174025_create_account_table.php	1106	0644	edit dl rm
m140504_113157_update_tables.php	2344	0644	edit dl rm
m140504_130429_create_token_table.php	1060	0644	edit dl rm
m140830_171933_fix_ip_field.php	635	0644	edit dl rm
m140830_172703_change_account_table_name.php	623	0644	edit dl rm
m141222_110026_update_ip_field.php	2092	0644	edit dl rm
m141222_135246_alter_username_length.php	1420	0644	edit dl rm
m150614_103145_update_social_account_table.php	1509	0644	edit dl rm
m150623_212711_fix_username_notnull.php	1464	0644	edit dl rm
m151218_234654_add_timezone_to_profile.php	569	0644	edit dl rm
m160929_103127_add_last_login_at_to_user_table.php	294	0644	edit dl rm
Migration.php	2316	0644	edit dl rm

Edit: /var/www/vhosts/nabawater/vendor/dektrium/yii2-user/migrations/m140504_113157_update_tables.php (2344B)

<?php

/*
 * This file is part of the Dektrium project.
 *
 * (c) Dektrium project <http://github.com/dektrium/>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

use dektrium\user\migrations\Migration;

/**
 * @author Dmitry Erofeev <dmeroff@gmail.com>
 */
class m140504_113157_update_tables extends Migration
{
    public function up()
    {
        // user table
        $this->dropIndex('{{%user_confirmation}}', '{{%user}}');
        $this->dropIndex('{{%user_recovery}}', '{{%user}}');
        $this->dropColumn('{{%user}}', 'confirmation_token');
        $this->dropColumn('{{%user}}', 'confirmation_sent_at');
        $this->dropColumn('{{%user}}', 'recovery_token');
        $this->dropColumn('{{%user}}', 'recovery_sent_at');
        $this->dropColumn('{{%user}}', 'logged_in_from');
        $this->dropColumn('{{%user}}', 'logged_in_at');
        $this->renameColumn('{{%user}}', 'registered_from', 'registration_ip');
        $this->addColumn('{{%user}}', 'flags', $this->integer()->notNull()->defaultValue(0));

// account table
        $this->renameColumn('{{%account}}', 'properties', 'data');
    }

public function down()
    {
        // account table
        $this->renameColumn('{{%account}}', 'data', 'properties');

// user table
        if ($this->dbType == 'sqlsrv') {
            // this is needed because we need to drop the default constraint first
            $this->dropColumnConstraints('{{%user}}', 'flags');
        }
        $this->dropColumn('{{%user}}', 'flags');
        $this->renameColumn('{{%user}}', 'registration_ip', 'registered_from');
        $this->addColumn('{{%user}}', 'logged_in_at', $this->integer());
        $this->addColumn('{{%user}}', 'logged_in_from', $this->integer());
        $this->addColumn('{{%user}}', 'recovery_sent_at', $this->integer());
        $this->addColumn('{{%user}}', 'recovery_token', $this->string(32));
        $this->addColumn('{{%user}}', 'confirmation_sent_at', $this->integer());
        $this->addColumn('{{%user}}', 'confirmation_token', $this->string(32));
        $this->createIndex('{{%user_confirmation}}', '{{%user}}', 'id, confirmation_token', true);
        $this->createIndex('{{%user_recovery}}', '{{%user}}', 'id, recovery_token', true);
    }
}

cmd: