<?php

use Phalcon\Mvc\Model\Migration;

class StranasSnapshotNotificationMigration_399 extends Migration {
    public function up() {
        return; // migrasi dibatalkan
        self::$connection->execute("
            DROP TABLE if exists jaga.str_snapshot_notification;
            CREATE TABLE jaga.str_snapshot_notification
            (
                id integer NOT NULL,
                id_instansi integer NOT NULL,
                id_triwulan integer NOT NULL,
                email character varying,
                status int2 default NULL,
                UNIQUE(id, id_instansi),
                CONSTRAINT str_snapshot_notification_fkey
                    FOREIGN KEY (id)
                        REFERENCES jaga.str_snapshot(id)
            );
        ");
    }

    public function down() {
        return; // migrasi dibatalkan
        self::$connection->execute("
            DROP TABLE if exists jaga.str_snapshot_notification;
        ");
    }
}