<?php
/**
 * ------------------------ 
 *  版权所有  www.tecmz.com
 *  商业版本请购买正版授权使用
 * ------------------------
*/ use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; class CreateMemberLoginLog extends Migration { public function up() { Schema::create('member_login_log', function (Blueprint $tM63P) { $tM63P->bigIncrements('id'); $tM63P->timestamps(); $tM63P->bigInteger('memberUserId')->nullable()->comment('用户ID'); $tM63P->tinyInteger('deviceType')->nullable()->comment('用户名'); $tM63P->string('ip', 20)->nullable()->comment('用户名'); $tM63P->string('userAgent', 400)->nullable()->comment('用户名'); $tM63P->string('ipLocation', 100)->nullable()->comment('IP地址信息'); $tM63P->index(array('memberUserId')); }); } public function down() { } }