bab-icon/database/migrations/2022_10_18_091958_create_member_coins_table.php

<?php

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

/**
 * Class CreateMemberCoinsTable.
 */
class CreateMemberCoinsTable extends Migration
{
	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('member_coins', function(Blueprint $table) {
            $table->increments('id');
            $table->integer('m_id')->index('m_id')->default('0')->comment('m_id');
            $table->integer('coin_id')->index('coin_id')->default('0')->comment('coin_id');
            $table->string('coin_name')->default('')->comment('币名');
            $table->double('num',12,6)->default('0')->comment('余额');
            $table->double('lock_num',12,6)->default('0')->comment('锁定数量');
            $table->string('address')->default('')->comment('address');
            $table->string('private')->default('')->comment('');
            $table->string('code_img')->default('')->comment('');
            $table->timestamps();
		});
	}

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