<?php 

use Phalcon\Db\Column;
use Phalcon\Db\Index;
use Phalcon\Db\Reference;
use Phalcon\Mvc\Model\Migration;

class NewPeriodMigration_254 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            --[1]
            drop table if exists "jaga"."temp_newtarget";

            CREATE TABLE jaga.temp_newtarget (
              id_instansi int4 NULL,
              id_periode int4 NULL,
              new_id_periode int4 NULL,
              id_survey int4 NULL,
              id_survey_template int4 NULL,
              id_target int4 NULL,
              target_check int4 NULL,
              verifikasi_terakhir int4 NULL,
              new_id_survey int4 null,
              new_id_survey_template int4 null
            );
            ');
    }
}