<?php

use Phalcon\Mvc\Model\Migration;
class AlterBannerMigration_409 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.banner ADD COLUMN IF NOT EXISTS mode character varying (10);
            ALTER TABLE jaga.banner ADD COLUMN IF NOT EXISTS created_by integer;
            ALTER TABLE jaga.banner ADD COLUMN IF NOT EXISTS updated_by integer;
            ALTER TABLE jaga.banner ADD COLUMN IF NOT EXISTS deleted_by integer;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.banner DROP COLUMN IF EXISTS mode;
            ALTER TABLE jaga.banner DROP COLUMN IF EXISTS created_by;
            ALTER TABLE jaga.banner DROP COLUMN IF EXISTS updated_by;
            ALTER TABLE jaga.banner DROP COLUMN IF EXISTS deleted_by;
        ");
    }
}