<?php


use Phinx\Migration\AbstractMigration;

class CreateRequestMetaTable extends AbstractMigration
{
    public function up()
    {
        $table = $this->table('request_meta');

        $table->addColumn('callbackid', 'integer');
        $table->addForeignKey(
            'callbackid',
            'callback',
            ['id'],
            ['constraint' => 'FK_callback']
        );

        $table->addColumn('source_ip', 'string', [
            'limit' => 50,
            'null' => true,
        ]);

        $table->addColumn('method', 'enum', [
            'null' => false,
            'default' => 'GET',
            'values' => ['GET', 'POST']
        ]);

        $table->addColumn('uri', 'string', [
            'limit' => 255,
            'null' => true,
        ]);

        $table->addColumn('timestamp', 'timestamp', [
            'default' => 'CURRENT_TIMESTAMP',
            'null' => false,
        ]);

        $table->save();
    }
}