<?php

use Phalcon\Mvc\Model\Migration;
class PerbaikanPengembanganPancekMigration_534 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            UPDATE jaga.pancek_answer
            SET verify_status = 'UPDATED'
            WHERE id IN (
                SELECT answer_id
                FROM jaga.pancek_answer_attachment
                WHERE deleted_at IS NULL
            )
            AND verify_status IS NULL
            ;
        ");
    }

    public function down()
    {
    }
}