<?php

use Phalcon\Mvc\Model\Migration;

class SekolahLikeMigration_393 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE jaga.sekolah_like
            (
                id bigserial NOT NULL,
                sekolah_npsn character varying(20) not null,
                user_id bigint not null,
            	created_at timestamp(6) DEFAULT now(),
            	
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ");

        self::$connection->execute("
            ALTER TABLE jaga.pak_isian_sekolah_detail
                ADD COLUMN is_favorited smallint;
        ");

        self::$connection->execute("
            UPDATE jaga.pak_isian_sekolah_detail
                SET is_favorited = 0;
        ");
    }

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

        self::$connection->execute("
            ALTER TABLE jaga.pak_isian_sekolah_detail
                DROP COLUMN IF EXISTS is_favorited;
        ");
    }
}