+global\CreateCategoriesTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	24
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->increments('id');
            // nested sets fields
            $table->unsignedInteger('parent_id')->nullable()->index();
            $table->unsignedInteger('lft')->nullable()->index();
            $table->unsignedInteger('rgt')->nullable()->index();
            $table->unsignedInteger('depth')->nullable();

            $table->string('title');
            $table->string('alias');
            $table->string('note')->nullable();
            $table->boolean('published')->default(false)->index();
            $table->boolean('authenticated')->default(false)->index();
            $table->integer('hits')->default(0);
            $table->mediumText('description')->nullable();
            $table->text('parameters')->nullable();

            $table->unsignedInteger('created_by')->nullable()->index();
            $table->unsignedInteger('updated_by')->nullable()->index();
            $table->timestamps();
        });
    }