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