jucai/database/migrations/2018_09_27_053424_create_configs_table.php

<?php

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

class CreateConfigsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('configs', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedInteger('type_id')->index()->comment('config_types.id');
            $table->string('name')->index()->comment('配置名称');
            $table->string('alias')->index()->comment('别名');
            $table->text('value')->comment('配置值');
            $table->unsignedInteger('listorder')->comment('排序');
            $table->string('input_type')->comment('输入框类型:同admin的form组件');
            $table->string('default_values')->comment('默认值');
            $table->string('option_values')->comment('提供的选择项:json对象{"name":"value"}');
            $table->string('tips')->comment('提示信息');
            $table->string('placeholder')->comment('placeholder');
            $table->string('rules')->comment('验证规则');
            $table->string('rule_messages')->comment('验证错误信息,json对象');
            $table->string('def_value')->comment('配置选项默认值');
            $table->tinyInteger('input_type')->comment('输入框类型');
            $table->tinyInteger('type')->index()->comment('类型(1:配置 2: 注册配置 3:电子地图 4:注册协议 5:积分配置 6:首页底部 7:其他 8:关键词过滤 9:职位层级)');
            $table->timestamps();
            $table->softDeletes();
        });
    }

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