<?php

use Phalcon\Mvc\Model\Migration;

/**
 * Class RolesMigration_211
 */
class StranasSurveyTemplateMigration_160 extends Migration
{
    public function up()
    {
        self::$connection->execute('
        CREATE TABLE jaga.stranas_survey_template (
            id serial PRIMARY KEY,
            nama varchar(255),
            keterangan text,
            created_at timestamp(6) DEFAULT now(),
            updated_at timestamp(6) DEFAULT now(),
            deleted_at timestamp(6),
            created_by int,
            updated_by int
        )');
    }

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