<?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 $onV5E) { $onV5E->bigIncrements('id'); $onV5E->timestamps(); $onV5E->bigInteger('memberUserId')->nullable()->comment('用户ID'); $onV5E->tinyInteger('deviceType')->nullable()->comment('用户名'); $onV5E->string('ip', 20)->nullable()->comment('用户名'); $onV5E->string('userAgent', 400)->nullable()->comment('用户名'); $onV5E->string('ipLocation', 100)->nullable()->comment('IP地址信息'); $onV5E->index(array('memberUserId')); }); } public function down() { } }