<?php
use Phalcon\Mvc\Model\Migration;

class AlterSpiRtlMigration_552 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.spi_rtl
                ADD COLUMN IF NOT EXISTS created_at timestamp(6) DEFAULT now(),
                ADD COLUMN IF NOT EXISTS created_by INTEGER,
                ADD COLUMN IF NOT EXISTS updated_at timestamp(6),
                ADD COLUMN IF NOT EXISTS updated_by INTEGER,
                ADD COLUMN IF NOT EXISTS deleted_at timestamp(6),
                ADD COLUMN IF NOT EXISTS deleted_by INTEGER;
        ");

        self::$connection->execute("
            ALTER TABLE jaga.spi_rtl_verifikasi
                ADD COLUMN IF NOT EXISTS created_at timestamp(6) DEFAULT now(),
                ADD COLUMN IF NOT EXISTS created_by INTEGER,
                ADD COLUMN IF NOT EXISTS updated_at timestamp(6),
                ADD COLUMN IF NOT EXISTS updated_by INTEGER,
                ADD COLUMN IF NOT EXISTS deleted_at timestamp(6),
                ADD COLUMN IF NOT EXISTS deleted_by INTEGER;
        ");

        self::$connection->execute("
            ALTER TABLE jaga.spi_rtl
                ADD CONSTRAINT spi_rtl_created_by_fkey FOREIGN KEY (created_by) REFERENCES um_user(um_id) ON DELETE SET NULL,
                ADD CONSTRAINT spi_rtl_updated_by_fkey FOREIGN KEY (updated_by) REFERENCES um_user(um_id) ON DELETE SET NULL,
                ADD CONSTRAINT spi_rtl_deleted_by_fkey FOREIGN KEY (deleted_by) REFERENCES um_user(um_id) ON DELETE SET NULL;
        ");

        self::$connection->execute("
            ALTER TABLE jaga.spi_rtl_verifikasi
                ADD CONSTRAINT spi_rtl_verifikasi_created_by_fkey FOREIGN KEY (created_by) REFERENCES um_user(um_id) ON DELETE SET NULL,
                ADD CONSTRAINT spi_rtl_verifikasi_updated_by_fkey FOREIGN KEY (updated_by) REFERENCES um_user(um_id) ON DELETE SET NULL,
                ADD CONSTRAINT spi_rtl_verifikasi_deleted_by_fkey FOREIGN KEY (deleted_by) REFERENCES um_user(um_id) ON DELETE SET NULL;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.spi_rtl_verifikasi
                DROP CONSTRAINT IF EXISTS spi_rtl_created_by_fkey,
                DROP CONSTRAINT IF EXISTS spi_rtl_updated_by_fkey,
                DROP CONSTRAINT IF EXISTS spi_rtl_deleted_by_fkey,
                DROP COLUMN IF EXISTS created_at,
                DROP COLUMN IF EXISTS created_by,
                DROP COLUMN IF EXISTS updated_at,
                DROP COLUMN IF EXISTS updated_by,
                DROP COLUMN IF EXISTS deleted_at,
                DROP COLUMN IF EXISTS deleted_by;
        ");

        self::$connection->execute("
            ALTER TABLE jaga.spi_rtl
                DROP CONSTRAINT IF EXISTS spi_rtl_verifikasi_created_by_fkey,
                DROP CONSTRAINT IF EXISTS spi_rtl_verifikasi_updated_by_fkey,
                DROP CONSTRAINT IF EXISTS spi_rtl_verifikasi_deleted_by_fkey,
                DROP COLUMN IF EXISTS created_at,
                DROP COLUMN IF EXISTS created_by,
                DROP COLUMN IF EXISTS updated_at,
                DROP COLUMN IF EXISTS updated_by,
                DROP COLUMN IF EXISTS deleted_at,
                DROP COLUMN IF EXISTS deleted_by;
        ");
    }
}