CreateMenuitemTranslationTable::up()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 18
Code Lines 13

Duplication

Lines 0
Ratio 0 %
Metric Value
dl 0
loc 18
rs 9.4286
cc 1
eloc 13
nc 1
nop 0
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
6
class CreateMenuitemTranslationTable extends Migration
7
{
8
    /**
9
     * Run the migrations.
10
     *
11
     * @return void
12
     */
13
    public function up()
14
    {
15
        Schema::create('menu__menuitem_translations', function (Blueprint $table) {
16
            $table->engine = 'InnoDB';
17
            $table->increments('id');
18
            $table->integer('menuitem_id')->unsigned();
19
            $table->string('locale')->index();
20
21
            $table->tinyInteger('status')->default(0);
22
            $table->string('title');
23
            $table->string('url')->nullable();
24
            $table->string('uri')->nullable();
25
26
            $table->unique(['menuitem_id', 'locale']);
27
            $table->foreign('menuitem_id')->references('id')->on('menu__menuitems')->onDelete('cascade');
28
            $table->timestamps();
29
        });
30
    }
31
32
    /**
33
     * Reverse the migrations.
34
     *
35
     * @return void
36
     */
37
    public function down()
38
    {
39
        Schema::drop('menu__menuitem_translations');
40
    }
41
}
42