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

<?php

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

class CreatePagesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('pages', function (Blueprint $table) {
            $table->increments('id');
            $table->tinyInteger('systemclass')->default('0')->comment('系统内置类型编号(1:系统 0 : 自定义)');
            $table->tinyInteger('pagetpye')->default('1')->comment('页面类型(1:首页或频道首页 2:信息列表页 3:信息内容页)');
            $table->string('alias')->comment('别名');
            $table->string('pname')->comment('页面名称');
            $table->string('route')->comment('路由指向');
            $table->string('rewrite')->default(null)->comment('伪静态规则');
            $table->tinyInteger('url')->default('1')->comment('优化链接(1:伪静态)');
            $table->integer('caching')->default('0')->comment('缓存时间(分钟)');
            $table->string('tag')->comment('导航关联标记(缓存)');
            $table->string('title')->comment('Seo标题');
            $table->string('description')->comment('Seo描述');
            $table->string('keywords')->comment('Seo关键字');
            $table->tinyInteger('subsite_id')->default('0')->comment('分站信息(0:总站)');
            $table->timestamps();
            $table->softDeletes();
        });
    }

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