VojtaSvoboda\Brands\Updates\CreateBrandCategoryTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	22
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	14	1
A	down()	0	4	1

<?php namespace VojtaSvoboda\Brands\Updates;

use October\Rain\Database\Schema\Blueprint;
use October\Rain\Database\Updates\Migration;
use Schema;

class CreateBrandCategoryTable extends Migration
{
    public function up()
    {
        Schema::create('vojtasvoboda_brands_brand_category', function($table)
        {
            $table->engine = 'InnoDB';
            $table->increments('id')->unsigned();
            $table->integer('brand_id')->unsigned()->nullable()->default(null);
            $table->integer('category_id')->unsigned()->nullable()->default(null);
            $table->index(['brand_id', 'category_id']);
            $table->foreign('brand_id')->references('id')->on('vojtasvoboda_brands_brands')->onDelete('cascade');
            $table->foreign('category_id')->references('id')->on('vojtasvoboda_brands_categories')->onDelete('cascade');
            $table->timestamps();
        });
    }

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