aboutsummaryrefslogtreecommitdiff
path: root/database/migrations
diff options
context:
space:
mode:
authorMateja <mail@matejamaric.com>2020-10-18 22:09:53 +0200
committerMateja <mail@matejamaric.com>2020-10-18 22:09:53 +0200
commit75e4ed82769143be8968edf9110e6e2fd5d85028 (patch)
tree77487b68567767ae01c832aa8b47148d4ab86137 /database/migrations
parent4cd3e2eacb4e81950dddd3e64c6c81b5f1e3f24d (diff)
downloadyota-laravel-75e4ed82769143be8968edf9110e6e2fd5d85028.tar.gz
yota-laravel-75e4ed82769143be8968edf9110e6e2fd5d85028.zip
forms and migrations
Diffstat (limited to 'database/migrations')
-rw-r--r--database/migrations/2020_10_18_142649_create_reservations_table.php10
-rw-r--r--database/migrations/2020_10_18_183257_create_special_calls_table.php33
2 files changed, 43 insertions, 0 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 fc8e39a..c8b96f2 100644
--- a/database/migrations/2020_10_18_142649_create_reservations_table.php
+++ b/database/migrations/2020_10_18_142649_create_reservations_table.php
@@ -16,6 +16,16 @@ class CreateReservationsTable extends Migration
Schema::create('reservations', function (Blueprint $table) {
$table->id();
$table->boolean('approved')->default(false);
+ $table->string('specialCall');
+ $table->dateTime('fromTime');
+ $table->dateTime('toTime');
+ $table->string('frequencies', 255);
+ $table->string('modes', 255);
+ $table->string('operatorCall');
+ $table->string('operatorName');
+ $table->string('operatorEmail');
+ $table->string('operatorPhone', 50);
+ $table->integer('qso')->default(0);
$table->timestamps();
});
}
diff --git a/database/migrations/2020_10_18_183257_create_special_calls_table.php b/database/migrations/2020_10_18_183257_create_special_calls_table.php
new file mode 100644
index 0000000..07e92be
--- /dev/null
+++ b/database/migrations/2020_10_18_183257_create_special_calls_table.php
@@ -0,0 +1,33 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+class CreateSpecialCallsTable extends Migration
+{
+ /**
+ * Run the migrations.
+ *
+ * @return void
+ */
+ public function up()
+ {
+ Schema::create('special_calls', function (Blueprint $table) {
+ $table->id();
+ $table->string('sign')->unique();
+ $table->text('description');
+ $table->timestamps();
+ });
+ }
+
+ /**
+ * Reverse the migrations.
+ *
+ * @return void
+ */
+ public function down()
+ {
+ Schema::dropIfExists('special_calls');
+ }
+}