<?php

use Phalcon\Mvc\Model\Migration;

class CleansingDetailProdiPTMigration_370 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            DELETE FROM
                jaga.detail_prodi_pt a USING jaga.detail_prodi_pt b
            WHERE
                a.id > b.id
                AND a.perguruan_tinggi_id = b.perguruan_tinggi_id
                AND a.jenjang = b.jenjang
                AND a.kode_prodi = b.kode_prodi
                AND a.nama_prodi = b.nama_prodi;
            SELECT setval('jaga.detail_prodi_pt_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.detail_prodi_pt), 1), false);
        ");
    }

    public function down()
    {
        // cannot be rollback
    }
}