<?php

use Phalcon\Mvc\Model\Migration;
class LogEmailMigration_438 extends Migration {
    public function up() {
        self::$connection->execute("
            DROP TABLE IF EXISTS jaga.log_email;
            CREATE TABLE jaga.log_email (
                id bigserial primary key,
                mail_to character varying(100) NOT NULL,
                mail_subject character varying(255) NOT NULL,
                mail_message text NOT NULL,
                is_html boolean NOT NULL,
                created_at timestamp(6) DEFAULT now(),
                created_by integer NOT NULL,
                last_sent timestamp(6),
                status character varying(30) NOT NULL 
            );
        ");

        self::$connection->execute("
            INSERT INTO jaga.app_config(kode, nilai, keterangan) VALUES ('USE_MAIL_BACKGROUND', 'false', 'Enable pengiriman email melalaui scheduled task');
        ");
    }

    public function down() {
        self::$connection->execute("DROP TABLE IF EXISTS jaga.log_email;");
        self::$connection->execute("
            DELETE FROM jaga.app_config WHERE kode = 'USE_MAIL_BACKGROUND';
        ");
    }
}