X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=database%2Fmigrations%2F2022_04_29_154903_create_discord_bot_commands_table.php;fp=database%2Fmigrations%2F2022_04_29_154903_create_discord_bot_commands_table.php;h=388240ec5f608fab94f2ee946205f3417b905d8c;hb=12f64085fd212a9744db01790cefad53c970e8d9;hp=0000000000000000000000000000000000000000;hpb=04eb1ab6316aba62b5cbf6f9b729782df1fe5015;p=alttp.git

diff --git a/database/migrations/2022_04_29_154903_create_discord_bot_commands_table.php b/database/migrations/2022_04_29_154903_create_discord_bot_commands_table.php
new file mode 100644
index 0000000..388240e
--- /dev/null
+++ b/database/migrations/2022_04_29_154903_create_discord_bot_commands_table.php
@@ -0,0 +1,38 @@
+<?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::create('discord_bot_commands', function (Blueprint $table) {
+			$table->id();
+			$table->foreignId('tournament_id')->nullable()->constrained();
+			$table->foreignId('user_id')->nullable()->constrained();
+			$table->string('command');
+			$table->text('parameters')->nullable()->default(null);
+			$table->string('status')->default('hold');
+			$table->text('result')->nullable()->default(null);
+			$table->timestamp('executed_at')->nullable()->default(null);
+			$table->timestamps();
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 *
+	 * @return void
+	 */
+	public function down()
+	{
+		Schema::dropIfExists('discord_bot_commands');
+	}
+};