<?php

use Phalcon\Mvc\Model\Migration;

class UserActivityMigration_267 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."user_activity" (
                id SERIAL PRIMARY KEY,
                user_id INTEGER,
                produk_id INTEGER,
                objek_id VARCHAR(255),
                diskusi_id INTEGER,
                latitude VARCHAR(255),
                longitude VARCHAR(255),
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6)
            );
        ');

        // self::$connection->execute('
        //     ALTER TABLE "jaga"."user_activity" 
        //         ADD IF NOT EXISTS diskusi_id INTEGER;
        // ');
    }
}