<?php

use Phalcon\Mvc\Model\Migration;

class JenjangMigration_378 extends Migration
{
    public function up() {
        self::$connection->execute("ALTER TABLE jaga.jenjang ADD COLUMN IF NOT EXISTS is_shown smallint DEFAULT 0;");
        self::$connection->execute("
            UPDATE jaga.jenjang SET is_shown = 1 WHERE nama_jenjang = 'TK';
            UPDATE jaga.jenjang SET is_shown = 1 WHERE nama_jenjang = 'SD';
            UPDATE jaga.jenjang SET is_shown = 1 WHERE nama_jenjang = 'SMP';
            UPDATE jaga.jenjang SET is_shown = 1 WHERE nama_jenjang = 'SMA';
            UPDATE jaga.jenjang SET is_shown = 1 WHERE nama_jenjang = 'SMK';
            UPDATE jaga.jenjang SET is_shown = 1 WHERE nama_jenjang = 'SLB';
        ");
    }
    public function down()
    {
        self::$connection->execute("ALTER TABLE jaga.jenjang DROP COLUMN IF EXISTS is_shown;");
    }
}