CreateSubscriptionsTable::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
eloc 1
nc 1
nop 0
dl 0
loc 3
c 1
b 0
f 0
cc 1
rs 10
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Support\Facades\Schema;
6
7
class CreateSubscriptionsTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('subscriptions', function (Blueprint $table) {
17
            $table->bigIncrements('id');
18
            $table->unsignedBigInteger('donator_id');
19
            $table->unsignedBigInteger('campaign_id');
20
            $table->string('payment_gateway');
21
            $table->string('payment_gateway_subscription_id')->comment('Native subscription ID on PG');
22
            $table->unsignedInteger('amount')->comment('Amount in cents');
23
            $table->string('currency', 3);
24
            $table->string('payment_interval')->comment('An ISO 8601 repeating interval specification');
25
            $table->timestamps();
26
27
            $table->foreign('donator_id')->references('id')->on('donators');
28
            $table->foreign('campaign_id')->references('id')->on('campaigns');
29
        });
30
    }
31
32
    /**
33
     * Reverse the migrations.
34
     *
35
     * @return void
36
     */
37
    public function down()
38
    {
39
        Schema::dropIfExists('subscriptions');
40
    }
41
}
42