jucai/database/migrations/Sys/2018_09_29_151403_create_navigations_table.php

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateNavigationsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('navigations', function (Blueprint $table) {
            $table->increments('id');
            $table->string('alias')->index()->comment('别名');
            $table->tinyInteger('urltype')->default('0')->comment('类型（1:系统内 0:系统外）');
            $table->tinyInteger('display')->default('1')->comment('是否显示（0:不显示 1:显示）');
            $table->string('title')->comment('栏目名称');
            $table->string('color')->comment('显示颜色')->nullable();
            $table->string('pagealias')->comment('系统页面别名');
            $table->string('tag')->comment('导航关联');
            $table->string('url')->comment('链接地址')->nullable();
            $table->string('target')->comment('打开方式');
            $table->integer('order')->comment('排序');
            $table->tinyInteger('is_personal')->comment('是否个人中心(0:不是 1:是)')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('navigations');
    }
}