diff options
| -rw-r--r-- | database/migrations/2020_10_18_142649_create_reservations_table.php | 3 |
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'); }); } |