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/m140209_132017_init.php (2805B)

<?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 m140209_132017_init extends Migration
{
    public function up()
    {
        $this->createTable('{{%user}}', [
            'id'                   => $this->primaryKey(),
            'username'             => $this->string(25)->notNull(),
            'email'                => $this->string(255)->notNull(),
            'password_hash'        => $this->string(60)->notNull(),
            'auth_key'             => $this->string(32)->notNull(),
            'confirmation_token'   => $this->string(32)->null(),
            'confirmation_sent_at' => $this->integer()->null(),
            'confirmed_at'         => $this->integer()->null(),
            'unconfirmed_email'    => $this->string(255)->null(),
            'recovery_token'       => $this->string(32)->null(),
            'recovery_sent_at'     => $this->integer()->null(),
            'blocked_at'           => $this->integer()->null(),
            'registered_from'      => $this->integer()->null(),
            'logged_in_from'       => $this->integer()->null(),
            'logged_in_at'         => $this->integer()->null(),
            'created_at'           => $this->integer()->notNull(),
            'updated_at'           => $this->integer()->notNull(),
        ], $this->tableOptions);

$this->createIndex('{{%user_unique_username}}', '{{%user}}', 'username', true);
        $this->createIndex('{{%user_unique_email}}', '{{%user}}', 'email', true);
        $this->createIndex('{{%user_confirmation}}', '{{%user}}', 'id, confirmation_token', true);
        $this->createIndex('{{%user_recovery}}', '{{%user}}', 'id, recovery_token', true);

$this->createTable('{{%profile}}', [
            'user_id'        => $this->integer()->notNull()->append('PRIMARY KEY'),
            'name'           => $this->string(255)->null(),
            'public_email'   => $this->string(255)->null(),
            'gravatar_email' => $this->string(255)->null(),
            'gravatar_id'    => $this->string(32)->null(),
            'location'       => $this->string(255)->null(),
            'website'        => $this->string(255)->null(),
            'bio'            => $this->text()->null(),
        ], $this->tableOptions);

$this->addForeignKey('{{%fk_user_profile}}', '{{%profile}}', 'user_id', '{{%user}}', 'id', $this->cascade, $this->restrict);
    }

public function down()
    {
        $this->dropTable('{{%profile}}');
        $this->dropTable('{{%user}}');
    }
}

cmd: