AddRelationsTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	22
Duplicated Lines	0 %

Importance

Changes

0

<?php
class AddRelationsTable extends Migration
{
    public function up()
    {
        Schema::create('relations', function (Blueprint $table) {
            $table->string("parent_type");
            $table->unsignedBigInteger("parent_id");
            $table->string("child_type");
            $table->unsignedBigInteger("child_id");

            $table->tinyInteger('sort')->default(0);

            $table->index(["parent_type", "parent_id"], 'parent_index');
            $table->index(["child_type", "child_id"], 'child_index');

            $table->primary(["parent_type", "parent_id", "child_type", "child_id"]);
        });
    }

    public function down()
    {
        Schema::dropIfExists('relations');
    }