<?php

use Phalcon\Mvc\Model\Migration;

/**
 * Class KeluhanCovid_309
 *
 */
class PakQuestionnaireMigration_311 extends Migration
{
    public function up()
    {
        $this->down();

        //NOTE: Add column `views_order` pada table `pak_questionnaire`
        self::$connection->execute("
        ALTER TABLE jaga.pak_questionnaire ADD COLUMN views_order smallint;
        ");

        //NOTE: UPDATE columns `views_order` set all as 1
        self::$connection->execute("
        UPDATE pak_questionnaire SET views_order = 1;
        ");
    }


    public function down()
    {
        //NOTE: Remove column `views_order` pada table `pak_questionnaire`
        self::$connection->execute("
        ALTER TABLE jaga.pak_questionnaire DROP COLUMN IF EXISTS views_order;
        ");
    }
}