jucai/database/migrations/Subsites/2018_10_20_181746_create_subsites_table.php

<?php

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

class CreateSubsitesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('subsites', function (Blueprint $table) {
            $table->increments('id');
            $table->string('sitename')->comment('分站名称');
            $table->tinyInteger('effective')->index()->default('1')->comment('分站状态')->nullable();
            $table->string('domain')->comment('分站域名');
            $table->integer('tpl')->comment('分站模板');
            $table->integer('order')->index()->comment('排序')->nullable();
            $table->string('logo')->comment('网站logo')->nullable();
            $table->string('logo_white')->comment('网站Logo(白底)')->nullable();
            $table->string('logo_mini')->comment('网站Logo mini')->nullable();
            $table->string('logo_white_mini')->comment('网站Logo mini(白底)')->nullable();
            $table->string('site_name')->comment('网站名称')->nullable();
            $table->string('site_keyword')->comment('网站默认关键字')->nullable();
            $table->string('site_description')->comment('网站默认描述')->nullable();
            $table->string('district')->index()->comment('分站地区');
            $table->string('districtname')->comment('分站地区名称');
            $table->string('map_ak')->comment('百度地图AK')->nullable();
            $table->string('map_x')->comment('默认中心点X坐标')->nullable();
            $table->string('map_y')->comment('默认中心点Y坐标')->nullable();
            $table->tinyInteger('is_open')->index()->default('0')->comment('是否开启微信公众号平台')->nullable();
            $table->string('app_id')->comment('微信AppID')->nullable();
            $table->string('app_secret')->comment('AppSecret')->nullable();
            $table->string('app_token')->comment('AppToken')->nullable();
            $table->string('aes_key')->comment('EncodingAESKey, 消息加密密钥')->nullable();
            $table->string('wechat_name')->comment('公众号名称')->nullable();
            $table->string('wechat_id')->comment('微信号')->nullable();
            $table->string('wechat_qrcode')->comment('微信二维码')->nullable();
            $table->smallInteger('max_level')->comment('默认缩放级别')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });
    }

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