foreign key

1 files changed, 2 insertions, 1 deletions

diff --git a/database/migrations/2020_10_18_142649_create_reservations_table.php b/database/migrations/2020_10_18_142649_create_reservations_table.php
index c8b96f2..812d544 100644
--- a/database/migrations/2020_10_18_142649_create_reservations_table.php
+++ b/database/migrations/2020_10_18_142649_create_reservations_table.php
@@ -16,7 +16,7 @@ class CreateReservationsTable extends Migration
         Schema::create('reservations', function (Blueprint $table) {
             $table->id();
             $table->boolean('approved')->default(false);
-            $table->string('specialCall');
+            $table->unsignedBigInteger('specialCall')
             $table->dateTime('fromTime');
             $table->dateTime('toTime');
             $table->string('frequencies', 255);
@@ -27,6 +27,7 @@ class CreateReservationsTable extends Migration
             $table->string('operatorPhone', 50);
             $table->integer('qso')->default(0);
             $table->timestamps();
+            $table->foreign('specialCall')->references('id')->on('special_calls');
         });
     }