VojtaSvoboda\UserAccessLog\Updates\CreateAccessLogTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	31
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	15	1
A	down()	0	10	1

<?php

namespace VojtaSvoboda\UserAccessLog\Updates;

use Schema;
use Illuminate\Support\Facades\DB;
use October\Rain\Database\Updates\Migration;

class CreateAccessLogTable extends Migration
{

	public function up()
	{
		Schema::create('user_access_log', function($table)
		{
			$table->engine = 'InnoDB';
			$table->increments('id');

			$table->integer('user_id')->unsigned()->nullable();
			$table->foreign('user_id')->references('id')->on('users')->onDelete('set null');

			$table->string('ip_address')->nullable();

			$table->timestamps();
		});
	}

	public function down()
	{
		DB::statement("SET foreign_key_checks = 0");
		Schema::table('user_access_log', function($table)
		{
			$table->dropForeign('user_access_log_user_id_foreign');
		});
		Schema::dropIfExists('user_access_log');
		DB::statement("SET foreign_key_checks = 1");
	}

}