CreateAccessLogTable::down() - Code Metrics - vojtasvoboda/oc-useraccesslog-plugin - Measure and Improve Code Quality continuously with Scrutinizer

CreateAccessLogTable::down() A
last analyzed 2020-09-20 20:45 UTC

↳ Parent: CreateAccessLogTable

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	10
rs	9.9332
c	0
b	0
f	0
cc	1
nc	1
nop	0

<?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");
	}

}


1			<?php
2
3			namespace VojtaSvoboda\UserAccessLog\Updates;
4
5			use Schema;
6			use Illuminate\Support\Facades\DB;
7			use October\Rain\Database\Updates\Migration;
8
9			class CreateAccessLogTable extends Migration
10			{
11
12			public function up()
13			{
14			Schema::create('user_access_log', function($table)
15			{
16			$table->engine = 'InnoDB';
17			$table->increments('id');
18
19			$table->integer('user_id')->unsigned()->nullable();
20			$table->foreign('user_id')->references('id')->on('users')->onDelete('set null');
21
22			$table->string('ip_address')->nullable();
23
24			$table->timestamps();
25			});
26			}
27
28			public function down()
29			{
30			DB::statement("SET foreign_key_checks = 0");
31			Schema::table('user_access_log', function($table)
32			{
33			$table->dropForeign('user_access_log_user_id_foreign');
34			});
35			Schema::dropIfExists('user_access_log');
36			DB::statement("SET foreign_key_checks = 1");
37			}
38
39			}
40

vojtasvoboda / oc-useraccesslog-plugin

CreateAccessLogTable::down() A last analyzed 2020-09-20 20:45 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CreateAccessLogTable::down() A
last analyzed 2020-09-20 20:45 UTC