source: database/migrations/2019_05_03_000003_create_subscription_items_table.php

Last change on this file was dfae77e, checked in by Igor Danilovski <igor_danilovski@…>, 2 years ago
  • Initial commit;
  • Property mode set to 100644
File size: 946 bytes
Line 
1<?php
2
3use Illuminate\Database\Migrations\Migration;
4use Illuminate\Database\Schema\Blueprint;
5use Illuminate\Support\Facades\Schema;
6
7class CreateSubscriptionItemsTable extends Migration
8{
9 /**
10 * Run the migrations.
11 *
12 * @return void
13 */
14 public function up()
15 {
16 Schema::create('subscription_items', function (Blueprint $table) {
17 $table->bigIncrements('id');
18 $table->unsignedBigInteger('subscription_id');
19 $table->string('stripe_id')->unique();
20 $table->string('stripe_product');
21 $table->string('stripe_price');
22 $table->integer('quantity')->nullable();
23 $table->timestamps();
24
25 $table->unique(['subscription_id', 'stripe_price']);
26 });
27 }
28
29 /**
30 * Reverse the migrations.
31 *
32 * @return void
33 */
34 public function down()
35 {
36 Schema::dropIfExists('subscription_items');
37 }
38}
Note: See TracBrowser for help on using the repository browser.