20170728074645_create_entity_relationships_table.php

Go to the documentation of this file.

<?php

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

class CreateEntityRelationshipsTable extends AbstractMigration {
    public function change() {

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

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

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

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

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

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

        $table->addIndex([
            'guid_one',
            'relationship',
            'guid_two'
        ], [
            'name' => "guid_one",
            'unique' => true,
        ]);

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

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

        $table->save();

    }
}