<?php

use Phalcon\Mvc\Model\Migration;

class AlterDiskusiBansosMigration_426 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.diskusi_bansos ADD COLUMN IF NOT EXISTS source VARCHAR(30) DEFAULT 'jaga';
            CREATE TABLE IF NOT EXISTS jaga.keluhan_desa_sipemandu_attachments (
                id SERIAL PRIMARY KEY,
                id_keluhan_desa_sipemandu INTEGER NOT NULL,
                filename VARCHAR (255) NOT NULL,
                type VARCHAR (50),
                url VARCHAR (255) NOT NULL
            );
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.diskusi_bansos DROP COLUMN IF EXISTS source;
            DROP TABLE IF EXISTS jaga.keluhan_desa_sipemandu_attachments;
        ");
    }
}