<?php

use Phalcon\Mvc\Model\Migration;

/**
 * Class RolesMigration_211
 */
class StranasTargetTriwulanMigration_159 extends Migration
{
    public function up()
    {
        self::$connection->execute('
        CREATE TABLE jaga.stranas_target_triwulan (
            id serial PRIMARY KEY,
            id_survey int,
            id_ukuran_keberhasilan int,
            keterangan text,
            nilai int,
            nilai_verifikasi int,
            verified_by int,
            status int DEFAULT 0,
            info_nilai text,
            info_lampiran text,
            created_at timestamp(6) DEFAULT now(),
            updated_at timestamp(6) DEFAULT now(),
            deleted_at timestamp(6),
            created_by int,
            updated_by int
        )');

        $this->batchInsert('stranas_target_triwulan', [
            'id',
            'id_survey',
            'id_ukuran_keberhasilan',
            'keterangan',
            'info_nilai',
            'info_lampiran'
        ]);

        self::$connection->execute("SELECT setval('stranas_target_triwulan_id_seq', (SELECT MAX(id) FROM jaga.stranas_target_triwulan));");
    }

    public function down()
    {
        self::$connection->execute("
            DROP TABLE IF EXISTS jaga.stranas_target_triwulan;
        ");
    }
}