Insert new `identifier` column for background jobs

diff --git a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.1.php b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.1.php
index f15d1743801dbdc37ec43b5ca61137c6b9977593..26e50c3d5fb1e67a53eefec2c5f145cd74d73a3b 100644 (file)
--- a/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.1.php
+++ b/wcfsetup/install/files/acp/database/update_com.woltlab.wcf_6.1.php
@@ -11,6 +11,7 @@
 use wcf\system\database\table\column\DefaultFalseBooleanDatabaseTableColumn;
 use wcf\system\database\table\column\NotNullInt10DatabaseTableColumn;
 use wcf\system\database\table\column\NotNullVarchar191DatabaseTableColumn;
+use wcf\system\database\table\column\VarcharDatabaseTableColumn;
 use wcf\system\database\table\DatabaseTable;
 use wcf\system\database\table\index\DatabaseTableForeignKey;
 use wcf\system\database\table\index\DatabaseTableIndex;
@@ -41,5 +42,15 @@ return [
             DatabaseTableIndex::create('messageEmbeddedObject')
                 ->type(DatabaseTableIndex::UNIQUE_TYPE)
                 ->columns(['messageObjectTypeID', 'messageID', 'embeddedObjectTypeID', 'embeddedObjectID']),
+        ]),
+    PartialDatabaseTable::create('wcf1_background_job')
+        ->columns([
+            VarcharDatabaseTableColumn::create('identifier')
+                ->length(191)
+                ->defaultValue(null),
+        ])
+        ->indices([
+            DatabaseTableIndex::create('identifier')
+                ->columns(['identifier']),
         ])
 ];

diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql
index f4407cd6e614af9c94c7e743de631ea826e501ca..59aecbe0ebcfae15586accb48d44dbfe869b9f51 100644 (file)
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -234,6 +234,9 @@ CREATE TABLE wcf1_background_job (
        job MEDIUMBLOB NOT NULL,
        status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready',
        time INT(10) NOT NULL,
+       identifier VARCHAR(191) NULL,
+
+       KEY identifier (identifier),
        KEY (status, time)
 );