CreateForeignKeys::up() - Code Metrics - bantenprov/dashboard-apel - Measure and Improve Code Quality continuously with Scrutinizer

CreateForeignKeys::up() A
last analyzed 2018-03-14 12:08 UTC

↳ Parent: CreateForeignKeys

Complexity

Conditions	1
Paths	1

Size

Total Lines	16
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	12
nc	1
nop	0
dl	0
loc	16
rs	9.4285
c	0
b	0
f	0

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Eloquent\Model;

class CreateForeignKeys extends Migration {

	public function up()
	{
		Schema::table('dashboard_apels', function(Blueprint $table) {
			$table->foreign('province_id')->references('id')->on('provinces')
						->onDelete('set null')
						->onUpdate('restrict');
		});
		Schema::table('dashboard_apels', function(Blueprint $table) {
			$table->foreign('regency_id')->references('id')->on('regencies')
						->onDelete('set null')
						->onUpdate('restrict');
		});
		Schema::table('regencies', function(Blueprint $table) {
			$table->foreign('province_id')->references('id')->on('provinces')
						->onDelete('set null')
						->onUpdate('restrict');
		});
	}

	public function down()
	{
		Schema::table('dashboard_apels', function(Blueprint $table) {
			$table->dropForeign('dashboard_apels_province_id_foreign');
		});
		Schema::table('dashboard_apels', function(Blueprint $table) {
			$table->dropForeign('dashboard_apels_regency_id_foreign');
		});
		Schema::table('regencies', function(Blueprint $table) {
			$table->dropForeign('regencies_province_id_foreign');
		});
	}
}

1			<?php
2
3			use Illuminate\Database\Migrations\Migration;
4			use Illuminate\Database\Schema\Blueprint;
5			use Illuminate\Database\Eloquent\Model;
6
7			class CreateForeignKeys extends Migration {
8
9			public function up()
10			{
11			Schema::table('dashboard_apels', function(Blueprint $table) {
12			$table->foreign('province_id')->references('id')->on('provinces')
13			->onDelete('set null')
14			->onUpdate('restrict');
15			});
16			Schema::table('dashboard_apels', function(Blueprint $table) {
17			$table->foreign('regency_id')->references('id')->on('regencies')
18			->onDelete('set null')
19			->onUpdate('restrict');
20			});
21			Schema::table('regencies', function(Blueprint $table) {
22			$table->foreign('province_id')->references('id')->on('provinces')
23			->onDelete('set null')
24			->onUpdate('restrict');
25			});
26			}
27
28			public function down()
29			{
30			Schema::table('dashboard_apels', function(Blueprint $table) {
31			$table->dropForeign('dashboard_apels_province_id_foreign');
32			});
33			Schema::table('dashboard_apels', function(Blueprint $table) {
34			$table->dropForeign('dashboard_apels_regency_id_foreign');
35			});
36			Schema::table('regencies', function(Blueprint $table) {
37			$table->dropForeign('regencies_province_id_foreign');
38			});
39			}
40			}

bantenprov / dashboard-apel

CreateForeignKeys::up() A last analyzed 2018-03-14 12:08 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CreateForeignKeys::up() A
last analyzed 2018-03-14 12:08 UTC