<?php

use Phalcon\Mvc\Model\Migration;

class SPIDataConfigValueMigration_541 extends Migration {
    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.app_config(kode, nilai, keterangan) VALUES ('DATA_SPI_UUID_2024', 'b7a3f3e2-4a8d-4f1a-8b9b-8b0e7f5f9d87', 'UUID dokumen Data SPI tahun 2024');
            INSERT INTO jaga.attachments(tipe, uuid, filename, metadata, status, created_by) values
                (0, 'b7a3f3e2-4a8d-4f1a-8b9b-8b0e7f5f9d87', 'Ringkasan_Data_SPI_2024.xlsx', -1, 0, 7623);
            CREATE TABLE jaga.spi_data_accessor
			(
				id serial NOT NULL,
				user_id integer NOT NULL,
				background VARCHAR(20),
                purpose VARCHAR(32),
                accessed_at timestamp without time zone NOT NULL DEFAULT now(),
				FOREIGN KEY (user_id)
					REFERENCES jaga.um_user (um_id) MATCH SIMPLE
			);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.app_config WHERE kode = 'DATA_SPI_UUID_2024';
            DELETE FROM jaga.attachments where uuid = 'b7a3f3e2-4a8d-4f1a-8b9b-8b0e7f5f9d87';
            DROP TABLE IF EXISTS jaga.spi_data_accessor;
        ");
    }
}