<?php

use yii\db\Migration;

class m161216_101038_user_fb extends Migration
{
    public function up()
    {
        $this->addColumn('{{%user}}', 'facebookId', $this->bigInteger());
        $this->addColumn('{{%user}}', 'role', $this->integer());

        $this->execute('INSERT INTO {{%user}} (username, auth_key, password_hash, email, status, created_at, role)
          VALUES (
            "admin",
            "yCAEfpjGOdQA7KUfGpmFdjc0Hd4aaPba",
            "$2y$13$HktnI9UrmO6l6mDjELBvLuSg97lIoJeinpdHiJRm/TlG1EVJ.bJES",
             "admin@divebooker.com",
             10,
             '.time().',
             3
            )');
    }

    public function down()
    {
        $this->dropColumn('{{%user}}', 'facebookId');
        $this->dropColumn('{{%user}}', 'role');
        $this->execute('DELETE FROM {{%user}} WHERE username = "admin"');
    }
}