<?php

use Phalcon\Mvc\Model\Migration;

class KorsupgahAnswerMigration_176 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE jaga.korsupgah_answer (
                id serial PRIMARY KEY,
                id_survey INT NOT NULL,
                id_question INT NOT NULL,
                nilai INT,
                keterangan TEXT,
                nilai_verifikasi INT,
                keterangan_verifikasi TEXT,
                status INT,
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6),
                created_by int,
                updated_by int	
            )");
    }

    public function down()
    {
        self::$connection->execute("
            DROP TABLE korsupgah_answer
        ");
    }
}