<?php

use Phalcon\Mvc\Model\Migration;

class PAK293CreateUserSekolahMigration_293 extends Migration
{
    public function up()
    {
        $this->down(); 

        self::$connection->execute('
            ALTER TABLE IF EXISTS "public"."um_user"
                DROP COLUMN IF EXISTS id_sekolah;
        ');

        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."users_sekolah" (
                id SERIAL PRIMARY KEY,
                um_id INTEGER NOT NULL,
                sekolah_id uuid NOT NULL,
                npsn VARCHAR NOT NULL,
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6),
                deleted_at timestamp(6),
                CONSTRAINT unique_um_id_sekolah_id UNIQUE(um_id,sekolah_id)
            );
        ');

    }

    public function down()
    {
        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."users_sekolah";
        ');
    }
}