<?php

use Phalcon\Mvc\Model\Migration;

class TodoMigration_235 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."todo" (
                id serial primary key,
                title varchar(255) NOT NULL,
                content text,
                user_id integer NOT NULL,
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6)
            );

        ');
    }
}