<?php

use Phalcon\Mvc\Model\Migration;

class JwtDataMigration_296 extends Migration
{
    public function up()
    {
        $this->down(); 

        self::$connection->execute("
            ALTER TABLE jaga.jwt_data
            ADD CONSTRAINT jwt_data_user_id_tenant_id_fkey FOREIGN KEY (user_id)
            REFERENCES jaga.um_user (um_id) MATCH SIMPLE
            ON UPDATE CASCADE
            ON DELETE NO ACTION;
        ");
    }

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