<?php

use Phalcon\Mvc\Model\Migration;

class UpdateGratifikasiPetaKerawananMigration_577 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            UPDATE jaga.gratifikasi_peta_kerawanan
            SET sub_sektor = REPLACE(sub_sektor, ';', '')
            WHERE sub_sektor LIKE '%;';
        ");
    }

    public function down()
    {
        self::$connection->execute("
            UPDATE jaga.gratifikasi_peta_kerawanan
            SET sub_sektor = REPLACE(sub_sektor, ';', '')
            WHERE sub_sektor LIKE '%;';
        ");
    }
}