<?php

class AlterUmUserJwtDataMigration_460 extends \Phalcon\Mvc\Model\Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.um_user ADD COLUMN IF NOT EXISTS last_login TIMESTAMP WITHOUT time zone;
            ALTER TABLE jaga.jwt_data ADD COLUMN IF NOT EXISTS ip_address VARCHAR(30);

            UPDATE jaga.um_user SET last_login = jwt.last_login
            FROM
            (
                SELECT distinct(user_id), max(updated_at) as last_login FROM jaga.jwt_data GROUP BY user_id
            ) as jwt
            WHERE um_id = user_id
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.um_user DROP COLUMN IF EXISTS last_login;
            ALTER TABLE jaga.jwt_data DROP COLUMN IF EXISTS ip_address;
        ");
    }
}