<?php

use Phalcon\Mvc\Model\Migration;

class AddKelasToJenjangMigration_294 extends Migration
{
    public function up()
    {
        $this->down();
        self::$connection->execute('
            ALTER TABLE IF EXISTS "jaga"."jenjang"
                ADD COLUMN IF NOT EXISTS kelas VARCHAR;
        ');

        self::$connection->execute("
            UPDATE jaga.jenjang SET kelas = '1,2,3,4,5,6' WHERE nama_jenjang='SD';
            UPDATE jaga.jenjang SET kelas = '7,8,9' WHERE nama_jenjang='SMP';
            UPDATE jaga.jenjang SET kelas = '10,11,12' WHERE nama_jenjang='SMA';
            UPDATE jaga.jenjang SET kelas = '10,11,12' WHERE nama_jenjang='SMK';
            UPDATE jaga.jenjang SET kelas = '10,11,12' WHERE nama_jenjang='MAN';
            UPDATE jaga.jenjang SET kelas = '10,11,12' WHERE nama_jenjang='MAS';
        ");
    }

    public function down()
    {
        self::$connection->execute('
            ALTER TABLE IF EXISTS "jaga"."jenjang"
                DROP COLUMN IF EXISTS kelas;
        ');

    }
}