<?php 

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

class SPIMetodologiMigrationMigration_265 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            --[1]

            DROP TABLE if exists jaga.metodologi;
            DROP SEQUENCE if exists jaga.metodologi_id_seq;
            
            CREATE SEQUENCE jaga.metodologi_id_seq
                INCREMENT 1
                START 1
                MINVALUE 1
                MAXVALUE 9223372036854775807
                CACHE 1;

            CREATE TABLE jaga.metodologi
            (
                id integer NOT NULL DEFAULT nextval('jaga.metodologi_id_seq'::regclass),
                code character varying COLLATE pg_catalog.\"default\" NOT NULL,
                nama character varying COLLATE pg_catalog.\"default\" NOT NULL,
                keterangan text COLLATE pg_catalog.\"default\" NOT NULL,
                tahun integer NOT NULL,
                is_active boolean,
                CONSTRAINT metodologi_pkey PRIMARY KEY (id)
            );
        ");
    }
}