<?php

use Phalcon\Mvc\Model\Migration;

class JenjangMigration_292 extends Migration
{
    public function up()
    {
        $this->down(); 

        self::$connection->execute("
            UPDATE jaga.jenjang
                SET sort_order = 1
                WHERE nama_jenjang = 'KB';

            UPDATE jaga.jenjang
                SET sort_order = 2
                WHERE nama_jenjang = 'TK';

            UPDATE jaga.jenjang
                SET sort_order = 3
                WHERE nama_jenjang = 'SD';

            UPDATE jaga.jenjang
                SET sort_order = 4
                WHERE nama_jenjang = 'SMP';

            UPDATE jaga.jenjang
                SET sort_order = 5
                WHERE nama_jenjang = 'SMK';

            UPDATE jaga.jenjang
                SET sort_order = 6
                WHERE nama_jenjang = 'SMA';

        ");
    }

    public function down()
    {
        self::$connection->execute("
            UPDATE jaga.jenjang
                SET sort_order = NULL
                WHERE nama_jenjang = 'KB';

            UPDATE jaga.jenjang
                SET sort_order = NULL
                WHERE nama_jenjang = 'TK';

            UPDATE jaga.jenjang
                SET sort_order = NULL
                WHERE nama_jenjang = 'SD';

            UPDATE jaga.jenjang
                SET sort_order = NULL
                WHERE nama_jenjang = 'SMP';

            UPDATE jaga.jenjang
                SET sort_order = NULL
                WHERE nama_jenjang = 'SMK';

            UPDATE jaga.jenjang
                SET sort_order = NULL
                WHERE nama_jenjang = 'SMA';
        ");
    }
}