<?php

use Phalcon\Mvc\Model\Migration;

class AlterTableMadrasahMigration_472 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.madrasah ADD COLUMN IF NOT EXISTS created_at timestamp without time zone NOT NULL DEFAULT '1900-01-01';
            ALTER TABLE jaga.madrasah ADD COLUMN IF NOT EXISTS updated_at timestamp without time zone;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.madrasah DROP COLUMN IF EXISTS created_at;
            ALTER TABLE jaga.madrasah DROP COLUMN IF EXISTS updated_at;
        ");
    }
}