<?php

use Phalcon\Db\Column;
use Phalcon\Db\Index;
use Phalcon\Db\Reference;
use Phalcon\Mvc\Model\Migration;

/**
 * Class RolesMigration_211
 */
class AttachmentsMigration_165 extends Migration
{
    /**
     * Run the migrations
     *
     * @return void
     */
    public function up()
    {
        self::$connection->execute('
            ALTER TABLE jaga.attachments RENAME COLUMN metadata2 TO status;
            ALTER TABLE jaga.attachments RENAME COLUMN metadata3 TO referer;
            ALTER TABLE jaga.attachments ALTER COLUMN status SET DEFAULT 0;
        ');
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    { }
}