20170728075232_create_system_log_table.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;
use Phinx\Db\Adapter\MysqlAdapter;

class CreateSystemLogTable extends AbstractMigration {
    public function change() {

        if ($this->hasTable("system_log")) {
            return;
        }

        $table = $this->table("system_log", [
            'engine' => "InnoDB",
            'encoding' => "utf8mb4",
            'collation' => "utf8mb4_general_ci",
        ]);

        $table->addColumn('object_id', 'integer', [
            'null' => false,
            'limit' => MysqlAdapter::INT_REGULAR,
            'precision' => 11,
        ]);

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

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

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

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

        $table->addColumn('performed_by_guid', 'integer', [
            'null' => false,
            'limit' => MysqlAdapter::INT_BIG,
            'precision' => 20,
            'signed' => false,
        ]);

        $table->addColumn('owner_guid', 'integer', [
            'null' => false,
            'limit' => MysqlAdapter::INT_BIG,
            'precision' => 20,
            'signed' => false,
        ]);

        $table->addColumn('access_id', 'integer', [
            'null' => false,
            'limit' => MysqlAdapter::INT_REGULAR,
            'precision' => 11,
        ]);

        $table->addColumn('enabled', 'enum', [
            'null' => false,
            'default' => 'yes',
            'limit' => 3,
            'values' => [
                'yes',
                'no'
            ],
        ]);

        $table->addColumn('time_created', 'integer', [
            'null' => false,
            'limit' => MysqlAdapter::INT_REGULAR,
            'precision' => 11,
        ]);

        $table->addColumn('ip_address', 'string', [
            'null' => false,
            'limit' => 46,
        ]);

        $table->addIndex(['object_id'], [
            'name' => "object_id",
            'unique' => false,
        ]);

        $table->addIndex(['object_class'], [
            'name' => "object_class",
            'unique' => false,
        ]);

        $table->addIndex(['object_type'], [
            'name' => "object_type",
            'unique' => false,
        ]);

        $table->addIndex(['object_subtype'], [
            'name' => "object_subtype",
            'unique' => false,
        ]);

        $table->addIndex(['event'], [
            'name' => "event",
            'unique' => false,
        ]);

        $table->addIndex(['performed_by_guid'], [
            'name' => "performed_by_guid",
            'unique' => false,
        ]);

        $table->addIndex(['access_id'], [
            'name' => "access_id",
            'unique' => false,
        ]);

        $table->addIndex(['time_created'], [
            'name' => "time_created",
            'unique' => false,
        ]);

        $table->addIndex([
            'object_type',
            'object_subtype',
            'event'
        ], [
            'name' => "river_key",
            'unique' => false
        ]);

        $table->save();

    }
}