jucai/database/migrations/Content/2018_10_08_100301_create_articles_table.php

<?php

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

class CreateArticlesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('articles', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('type_id')->comment('新闻分类');
            $table->integer('parent_id')->comment('新闻分类父id');
            $table->string('title')->comment('新闻标题');
            $table->mediumText('content')->comment('新闻内容')->nullable();
            $table->string('tit_color')->default('#000000')->comment('新闻标题颜色');
            $table->tinyInteger('tit_b')->comment('新闻标题是否加粗（1：加粗，0：不加粗）');
            $table->string('small_img')->comment('新闻缩略图')->nullable();
            $table->tinyInteger('is_display')->default('1')->comment('是否显示（1：显示，0：不显示）');
            $table->string('released_at')->comment('新闻发布日期');
            $table->integer('list_order')->comment('排序');
            $table->string('author')->comment('作者');
            $table->string('source')->comment('新闻来源');
            $table->integer('property_id')->comment('新闻属性');
            $table->string('is_url')->comment('外部链接');
            $table->string('seo_keywords')->comment('Seo优化关键字');
            $table->string('seo_description')->comment('Seo优化描述');
            $table->integer('click')->comment('点击量');
            $table->tinyInteger('robot')->comment('0：人工，1：采集');
            $table->integer('subsite_id')->default('0')->comment('分站id(0:总站)');
            $table->timestamps();
            $table->softDeletes();
        });
    }

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