<?php

use Phalcon\Mvc\Model\Migration;

class IsianSekolahPAKMigration_303 extends Migration
{
    public function up()
    {
        $this->down();
        self::$connection->execute('
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah_detail"
                ADD COLUMN IF NOT EXISTS link_youtube VARCHAR(255);
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah_detail"
                ADD COLUMN IF NOT EXISTS link_facebook VARCHAR(255);
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah_detail"
                ADD COLUMN IF NOT EXISTS link_blog VARCHAR(255);
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah"
                ADD COLUMN IF NOT EXISTS is_published boolean default false;
        ');

    }

    public function down()
    {
        self::$connection->execute('
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah_detail"
                DROP COLUMN IF EXISTS link_youtube;
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah_detail"
                DROP COLUMN IF EXISTS link_facebook;
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah_detail"
                DROP COLUMN IF EXISTS link_blog;
            ALTER TABLE IF EXISTS "jaga"."pak_isian_sekolah"
                DROP COLUMN IF EXISTS is_published;
        ');

    }
}