Completed
Branch master (2f299a)
by Ron
09:20
created

CreateCustomerContactPhonesTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 11
Code Lines 9

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 9
c 1
b 0
f 0
nc 1
nop 0
dl 0
loc 11
rs 9.9666
1
<?php
2
3
use Illuminate\Support\Facades\Schema;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Database\Migrations\Migration;
6
7
class CreateCustomerContactPhonesTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('customer_contact_phones', function (Blueprint $table) {
17
            $table->increments('id');
18
            $table->integer('cont_id')->unsigned();
19
            $table->integer('phone_type_id')->unsigned();
20
            $table->text('phone_number');
21
            $table->text('extension')->nullable();
22
            $table->timestamps();
23
            $table->foreign('cont_id')->references('cont_id')->on('customer_contacts')->onUpdate('cascade')->onDelete('cascade');
24
            $table->foreign('phone_type_id')->references('phone_type_id')->on('phone_number_types')->onUpdate('cascade');
25
        });
26
    }
27
28
    /**
29
     * Reverse the migrations.
30
     *
31
     * @return void
32
     */
33
    public function down()
34
    {
35
        Schema::dropIfExists('customer_contact_phones');
36
    }
37
}
38