From 4f956151936eed1cf15d91e57b3148f235d03215 Mon Sep 17 00:00:00 2001 From: Mateja Date: Mon, 19 Oct 2020 12:41:22 +0200 Subject: foreign key --- database/migrations/2020_10_18_142649_create_reservations_table.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'database') 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'); }); } -- cgit v1.2.3