\CreateSettingConfigTable

<?php

use Hyperf\Database\Schema\Schema;
use Hyperf\Database\Schema\Blueprint;
use Hyperf\Database\Migrations\Migration;

class CreateSettingConfigTable extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('setting_config', function (Blueprint $table) {
            $table->engine = 'Innodb';
            $table->comment('参数配置信息表');
            $table->addColumn('string', 'key', ['length'=> 255, 'comment' => '配置键名'])->nullable();
            $table->addColumn('string', 'value', ['length'=> 255, 'comment' => '配置值'])->nullable();
            $table->addColumn('string', 'name', ['length'=> 255, 'comment' => '配置名称'])->nullable();
            $table->addColumn('string', 'group_name', ['length'=> 100, 'comment' => '组名称'])->nullable();
            $table->addColumn('tinyInteger', 'sort', ['unsigned' => true, 'default' => 0, 'comment' => '排序'])->nullable();
            $table->addColumn('string', 'remark', ['length' => 255, 'comment' => '备注'])->nullable();
            $table->primary('key');
            $table->index('group_name');
        });
    }

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