<?php

use Phalcon\Mvc\Model\Migration;

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

        self::$connection->execute("
            ALTER TABLE jaga.sekolah ADD COLUMN IF NOT EXISTS kode_provinsi_dagri character varying(10), ADD COLUMN IF NOT EXISTS kode_kabupaten_dagri character varying(10);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.sekolah DROP COLUMN IF EXISTS kode_provinsi_dagri, DROP COLUMN IF EXISTS kode_kabupaten_dagri;
        ");
    }
}