UpdateEventsAddTimestamp::down() - Code Metrics - Inspection of "Laravel 9 migrations" - familytree365/laravel-gedcom - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 5d9325...8a350f )

by Curtis

created 2022-03-13 15:56 UTC

UpdateEventsAddTimestamp::down() A

↳ Parent: Project

Complexity

Conditions	1
Paths	1

Size

Total Lines	31
Code Lines	28

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	1

Metric	Value
cc	1
eloc	28
nc	1
nop	0
dl	0
loc	31
rs	9.472
c	2
b	0
f	1

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('person_events', function (Blueprint $table) {
            $table->integer('year')->nullable();
            $table->integer('month')->nullable();
            $table->integer('day')->nullable();
            $table->string('type')->nullable();
            $table->string('attr')->nullable();
            $table->string('plac')->nullable();
            $table->integer('addr_id')->nullable();
            $table->string('phon')->nullable();
            $table->text('caus')->nullable();
            $table->string('age')->nullable();
            $table->string('agnc')->nullable();
            $table->string('adop')->nullable();
            $table->string('adop_famc')->nullable();
            $table->string('birt_famc')->nullable();
        });
        Schema::table('family_events', function (Blueprint $table) {
            $table->integer('year')->nullable();
            $table->integer('month')->nullable();
            $table->integer('day')->nullable();
            $table->string('type')->nullable();
            $table->string('plac')->nullable();
            $table->integer('addr_id')->nullable();
            $table->string('phon')->nullable();
            $table->text('caus')->nullable();
            $table->string('age')->nullable();
            $table->string('agnc')->nullable();
            $table->integer('husb')->nullable();
            $table->integer('wife')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('person_events', function (Blueprint $table) {
            $table->dropColumn('year');
            $table->dropColumn('month');
            $table->dropColumn('day');
            $table->dropColumn('type');
            $table->dropColumn('attr');
            $table->dropColumn('plac');
            $table->dropColumn('addr_id');
            $table->dropColumn('phon');
            $table->dropColumn('caus');
            $table->dropColumn('age');
            $table->dropColumn('agnc');
            $table->dropColumn('adop');
            $table->dropColumn('adop_famc');
            $table->dropColumn('birt_famc');
        });
        Schema::table('family_events', function (Blueprint $table) {
            $table->dropColumn('year');
            $table->dropColumn('month');
            $table->dropColumn('day');
            $table->dropColumn('type');
            $table->dropColumn('plac');
            $table->dropColumn('addr_id');
            $table->dropColumn('phon');
            $table->dropColumn('caus');
            $table->dropColumn('age');
            $table->dropColumn('agnc');
            $table->dropColumn('husb');
            $table->dropColumn('wife');
        });
    }
}



1			<?php
2
3			use Illuminate\Database\Migrations\Migration;
4			use Illuminate\Database\Schema\Blueprint;
5			use Illuminate\Support\Facades\Schema;
6
7			return new class extends Migration
8			{
9			/**
10			* Run the migrations.
11			*
12			* @return void
13			*/
14			public function up()
15			{
16			Schema::table('person_events', function (Blueprint $table) {
17			$table->integer('year')->nullable();
18			$table->integer('month')->nullable();
19			$table->integer('day')->nullable();
20			$table->string('type')->nullable();
21			$table->string('attr')->nullable();
22			$table->string('plac')->nullable();
23			$table->integer('addr_id')->nullable();
24			$table->string('phon')->nullable();
25			$table->text('caus')->nullable();
26			$table->string('age')->nullable();
27			$table->string('agnc')->nullable();
28			$table->string('adop')->nullable();
29			$table->string('adop_famc')->nullable();
30			$table->string('birt_famc')->nullable();
31			});
32			Schema::table('family_events', function (Blueprint $table) {
33			$table->integer('year')->nullable();
34			$table->integer('month')->nullable();
35			$table->integer('day')->nullable();
36			$table->string('type')->nullable();
37			$table->string('plac')->nullable();
38			$table->integer('addr_id')->nullable();
39			$table->string('phon')->nullable();
40			$table->text('caus')->nullable();
41			$table->string('age')->nullable();
42			$table->string('agnc')->nullable();
43			$table->integer('husb')->nullable();
44			$table->integer('wife')->nullable();
45			});
46			}
47
48			/**
49			* Reverse the migrations.
50			*
51			* @return void
52			*/
53			public function down()
54			{
55			Schema::table('person_events', function (Blueprint $table) {
56			$table->dropColumn('year');
57			$table->dropColumn('month');
58			$table->dropColumn('day');
59			$table->dropColumn('type');
60			$table->dropColumn('attr');
61			$table->dropColumn('plac');
62			$table->dropColumn('addr_id');
63			$table->dropColumn('phon');
64			$table->dropColumn('caus');
65			$table->dropColumn('age');
66			$table->dropColumn('agnc');
67			$table->dropColumn('adop');
68			$table->dropColumn('adop_famc');
69			$table->dropColumn('birt_famc');
70			});
71			Schema::table('family_events', function (Blueprint $table) {
72			$table->dropColumn('year');
73			$table->dropColumn('month');
74			$table->dropColumn('day');
75			$table->dropColumn('type');
76			$table->dropColumn('plac');
77			$table->dropColumn('addr_id');
78			$table->dropColumn('phon');
79			$table->dropColumn('caus');
80			$table->dropColumn('age');
81			$table->dropColumn('agnc');
82			$table->dropColumn('husb');
83			$table->dropColumn('wife');
84			});
85			}
86			}
			0 ignored issues – show Bug introduced 2022-03-13 16:07 UTC by Report Bug Copy Issue Report A parse error occurred: Syntax error, unexpected EOF, expecting ';' on line 86 at column 0 Loading history...
87

familytree365 / laravel-gedcom

Push — master ( 5d9325...8a350f )

UpdateEventsAddTimestamp::down() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like