aboutsummaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
Diffstat (limited to 'database')
-rw-r--r--database/migrations/2020_10_18_142649_create_reservations_table.php3
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');
});
}