<?php
use Phalcon\Mvc\Model\Migration;

class AlterColumnsSpiRtlMigration_556 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE IF EXISTS jaga.spi_rtl
                ADD COLUMN IF NOT EXISTS is_updated_q3 boolean DEFAULT FALSE,
                ADD COLUMN IF NOT EXISTS q3_updated_at timestamp(6),
                ADD COLUMN IF NOT EXISTS is_updated_q4 boolean DEFAULT FALSE,
                ADD COLUMN IF NOT EXISTS q4_updated_at timestamp(6);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE IF EXISTS jaga.spi_rtl
                DROP COLUMN IF EXISTS is_updated_q3,
                DROP COLUMN IF EXISTS q3_updated_at,
                DROP COLUMN IF EXISTS is_updated_q4,
                DROP COLUMN IF EXISTS q4_updated_at;
        ");
    }
}