fix(migration): Check if column exits before adding itcheckColExists

Signed-off-by: Git'Fellow <12234510+solracsf@users.noreply.github.com>

1 files changed, 21 insertions, 15 deletions

diff --git a/core/Migrations/Version30000Date20240708160048.php b/core/Migrations/Version30000Date20240708160048.php
index 253b9cc7a64..83edd84e56a 100644
--- a/core/Migrations/Version30000Date20240708160048.php
+++ b/core/Migrations/Version30000Date20240708160048.php
@@ -37,21 +37,27 @@ class Version30000Date20240708160048 extends SimpleMigrationStep {
 		if ($schema->hasTable('taskprocessing_tasks')) {
 			$table = $schema->getTable('taskprocessing_tasks');
 
-			$table->addColumn('scheduled_at', Types::INTEGER, [
-				'notnull' => false,
-				'default' => null,
-				'unsigned' => true,
-			]);
-			$table->addColumn('started_at', Types::INTEGER, [
-				'notnull' => false,
-				'default' => null,
-				'unsigned' => true,
-			]);
-			$table->addColumn('ended_at', Types::INTEGER, [
-				'notnull' => false,
-				'default' => null,
-				'unsigned' => true,
-			]);
+			if (!$table->hasColumn('scheduled_at')) {
+				$table->addColumn('scheduled_at', Types::INTEGER, [
+					'notnull' => false,
+					'default' => null,
+					'unsigned' => true,
+				]);
+			}
+			if (!$table->hasColumn('started_at')) {
+				$table->addColumn('started_at', Types::INTEGER, [
+					'notnull' => false,
+					'default' => null,
+					'unsigned' => true,
+				]);
+			}
+			if (!$table->hasColumn('ended_at')) {
+				$table->addColumn('ended_at', Types::INTEGER, [
+					'notnull' => false,
+					'default' => null,
+					'unsigned' => true,
+				]);
+			}
 
 			return $schema;
 		}