| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/water/vendor/amnah/yii2-user/migrations/ |
Upload File : |
<?php
use yii\db\Schema;
use yii\db\Migration;
class m150214_044831_init_user extends Migration
{
public function up()
{
$tableOptions = null;
if ($this->db->driverName === 'mysql') {
$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
}
// create tables. note the specific order
$this->createTable('{{%role}}', [
'id' => Schema::TYPE_PK,
'name' => Schema::TYPE_STRING . ' not null',
'created_at' => Schema::TYPE_TIMESTAMP . ' null',
'updated_at' => Schema::TYPE_TIMESTAMP . ' null',
'can_admin' => Schema::TYPE_SMALLINT . ' not null default 0',
], $tableOptions);
$this->createTable('{{%user}}', [
'id' => Schema::TYPE_PK,
'role_id' => Schema::TYPE_INTEGER . ' not null',
'status' => Schema::TYPE_SMALLINT . ' not null',
'email' => Schema::TYPE_STRING . ' null',
'username' => Schema::TYPE_STRING . ' null',
'password' => Schema::TYPE_STRING . ' null',
'auth_key' => Schema::TYPE_STRING . ' null',
'access_token' => Schema::TYPE_STRING . ' null',
'logged_in_ip' => Schema::TYPE_STRING . ' null',
'logged_in_at' => Schema::TYPE_TIMESTAMP . ' null',
'created_ip' => Schema::TYPE_STRING . ' null',
'created_at' => Schema::TYPE_TIMESTAMP . ' null',
'updated_at' => Schema::TYPE_TIMESTAMP . ' null',
'banned_at' => Schema::TYPE_TIMESTAMP . ' null',
'banned_reason' => Schema::TYPE_STRING . ' null',
], $tableOptions);
$this->createTable('{{%user_token}}', [
'id' => Schema::TYPE_PK,
'user_id' => Schema::TYPE_INTEGER . ' null',
'type' => Schema::TYPE_SMALLINT . ' not null',
'token' => Schema::TYPE_STRING . ' not null',
'data' => Schema::TYPE_STRING . ' null',
'created_at' => Schema::TYPE_TIMESTAMP . ' null',
'expired_at' => Schema::TYPE_TIMESTAMP . ' null',
], $tableOptions);
$this->createTable('{{%profile}}', [
'id' => Schema::TYPE_PK,
'user_id' => Schema::TYPE_INTEGER . ' not null',
'created_at' => Schema::TYPE_TIMESTAMP . ' null',
'updated_at' => Schema::TYPE_TIMESTAMP . ' null',
'full_name' => Schema::TYPE_STRING . ' null',
'timezone' => Schema::TYPE_STRING . ' null',
], $tableOptions);
$this->createTable('{{%user_auth}}', [
'id' => Schema::TYPE_PK,
'user_id' => Schema::TYPE_INTEGER . ' not null',
'provider' => Schema::TYPE_STRING . ' not null',
'provider_id' => Schema::TYPE_STRING . ' not null',
'provider_attributes' => Schema::TYPE_TEXT . ' not null',
'created_at' => Schema::TYPE_TIMESTAMP . ' null',
'updated_at' => Schema::TYPE_TIMESTAMP . ' null'
], $tableOptions);
// add indexes for performance optimization
$this->createIndex('{{%user_email}}', '{{%user}}', 'email', true);
$this->createIndex('{{%user_username}}', '{{%user}}', 'username', true);
$this->createIndex('{{%user_token_token}}', '{{%user_token}}', 'token', true);
$this->createIndex('{{%user_auth_provider_id}}', '{{%user_auth}}', 'provider_id', false);
// add foreign keys for data integrity
$this->addForeignKey('{{%user_role_id}}', '{{%user}}', 'role_id', '{{%role}}', 'id');
$this->addForeignKey('{{%profile_user_id}}', '{{%profile}}', 'user_id', '{{%user}}', 'id');
$this->addForeignKey('{{%user_token_user_id}}', '{{%user_token}}', 'user_id', '{{%user}}', 'id');
$this->addForeignKey('{{%user_auth_user_id}}', '{{%user_auth}}', 'user_id', '{{%user}}', 'id');
// insert role data
$columns = ['name', 'can_admin', 'created_at'];
$this->batchInsert('{{%role}}', $columns, [
['Admin', 1, gmdate('Y-m-d H:i:s')],
['User', 0, gmdate('Y-m-d H:i:s')],
]);
// insert admin user: neo/neo
$security = Yii::$app->security;
$columns = ['role_id', 'email', 'username', 'password', 'status', 'created_at', 'access_token', 'auth_key'];
$this->batchInsert('{{%user}}', $columns, [
[
1, // Role::ROLE_ADMIN
'neo@neo.com',
'neo',
'$2y$13$dyVw4WkZGkABf2UrGWrhHO4ZmVBv.K4puhOL59Y9jQhIdj63TlV.O', // neo
1, // User::STATUS_ACTIVE
gmdate('Y-m-d H:i:s'),
$security->generateRandomString(),
$security->generateRandomString(),
],
]);
// insert profile data
$columns = ['user_id', 'full_name', 'created_at'];
$this->batchInsert('{{%profile}}', $columns, [
[1, 'the one', gmdate('Y-m-d H:i:s')],
]);
}
public function down()
{
// drop tables in reverse order (for foreign key constraints)
$this->dropTable('{{%user_auth}}');
$this->dropTable('{{%profile}}');
$this->dropTable('{{%user_token}}');
$this->dropTable('{{%user}}');
$this->dropTable('{{%role}}');
}
}