<?php

use Phalcon\Mvc\Model\Migration;
class JwtDataMigration_466 extends Migration {
    public function up()
    {
        $this->down();

        self::$connection->execute("
            ALTER TABLE jaga.jwt_data ADD COLUMN IF NOT EXISTS login_type character varying(20);
        ");
    }

    public function down()
    {
        $checkColumn = self::$connection->fetchColumn("
            SELECT COUNT(*)
            FROM information_schema.columns
            WHERE table_name = 'jwt_data'
            AND column_name = 'login_type'
            AND table_schema = 'jaga'
        ");

        if ($checkColumn == 1) {
            self::$connection->execute("
                DELETE FROM jaga.jwt_data WHERE login_type = 'ADMIN';
            ");

            self::$connection->execute("
                ALTER TABLE jaga.jwt_data DROP COLUMN login_type;
            ");
        }
    }
}