<?php

use Phalcon\Mvc\Model\Migration;

class AlterTableLitbangKajianMigration_564 extends Migration {
    public function up() {
        self::$connection->execute("
            ALTER TABLE jaga.litbang_kajian
            ALTER COLUMN sektor_id DROP NOT NULL,
            ALTER COLUMN jenis_id DROP NOT NULL,
            ALTER COLUMN kode DROP NOT NULL;
        ");
    }
    public function down() {
        self::$connection->execute("
            ALTER TABLE jaga.litbang_kajian
            ALTER COLUMN sektor_id SET NOT NULL,
            ALTER COLUMN jenis_id SET NOT NULL,
            ALTER COLUMN kode SET NOT NULL;
        ");
    }
}