X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=database%2Fmigrations%2F2024_02_28_102210_channel_guessing_game.php;fp=database%2Fmigrations%2F2024_02_28_102210_channel_guessing_game.php;h=28fb7ec85cefa9a434ae3a870aa02f6ae135290b;hb=7fc357a5943bf280ce2fa9aa97ec516af61efd69;hp=0000000000000000000000000000000000000000;hpb=98135a55c26ba5d485a0aa08aa4a3d1d42374cd9;p=alttp.git

diff --git a/database/migrations/2024_02_28_102210_channel_guessing_game.php b/database/migrations/2024_02_28_102210_channel_guessing_game.php
new file mode 100644
index 0000000..28fb7ec
--- /dev/null
+++ b/database/migrations/2024_02_28_102210_channel_guessing_game.php
@@ -0,0 +1,36 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+	/**
+	 * Run the migrations.
+	 *
+	 * @return void
+	 */
+	public function up()
+	{
+		Schema::table('channels', function (Blueprint $table) {
+			$table->string('guessing_type')->default('');
+			$table->datetime('guessing_start')->nullable()->default(null);
+			$table->datetime('guessing_end')->nullable()->default(null);
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		Schema::table('channels', function (Blueprint $table) {
+			$table->dropColumn('guessing_type');
+			$table->dropColumn('guessing_start');
+			$table->dropColumn('guessing_end');
+		});
+	}
+};