<?php

use Phalcon\Mvc\Model\Migration;

class JejakKasusAttachmentMigration_197 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE jaga.jejak_kasus_attachment (
                id serial PRIMARY KEY,
                id_jejak_kasus INT,
                id_attachment 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 jaga.jejak_kasus_attachment");
    }
}