<?php

use Phalcon\Mvc\Model\Migration;

class AlterUmUserMigration_433 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.um_user ADD COLUMN IF NOT EXISTS last_try_login timestamp;
            ALTER TABLE jaga.um_user ADD COLUMN IF NOT EXISTS try_login integer default 0;

            INSERT INTO jaga.app_config (kode, nilai, keterangan) VALUES ('TRY_LOGIN_LIMIT', '5', 'Jumlah maksimum percobaan login gagal');
            INSERT INTO jaga.app_config (kode, nilai, keterangan) VALUES ('CAPTCHA_LOGIN_LIMIT', '3', 'Jumlah maksimum percobaan login gagal sebelum mewajibkan input captcha');
            INSERT INTO jaga.app_config (kode, nilai, keterangan) VALUES ('TIME_LOGIN_LIMIT', '1800', 'Durasi blok akun setelah mencapai batas percobaan login (dalam detik)');
        ");
    }

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

            DELETE FROM jaga.app_config WHERE kode = 'TRY_LOGIN_LIMIT';
            DELETE FROM jaga.app_config WHERE kode = 'CAPTCHA_LOGIN_LIMIT';
            DELETE FROM jaga.app_config WHERE kode = 'TIME_LOGIN_LIMIT';
        ");
    }
}