<?php

use Phalcon\Mvc\Model\Migration;
class BannerMigration_408 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE IF NOT EXISTS jaga.banner
            (
                id SERIAL NOT NULL PRIMARY KEY,
                attachment_id INTEGER,
                filename CHARACTER VARYING(255),
                click_url CHARACTER VARYING (100),
                param_url TEXT,
                view_order SMALLINT,
                show_start TIMESTAMP(6),
                show_end TIMESTAMP(6),
                is_active BOOL,
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6),
                deleted_at timestamp(6)
            );
        ");
    }

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