summaryrefslogtreecommitdiffstats
path: root/core/Migrations
diff options
context:
space:
mode:
authorMarcel Klehr <mklehr@gmx.net>2023-06-28 14:59:20 +0200
committerMarcel Klehr <mklehr@gmx.net>2023-08-09 10:01:10 +0200
commit91325efa7808bd54c15950fdb0a1efc866aea79e (patch)
treed35afa2592bc8b88bf51b941f976c23dc96b026e /core/Migrations
parent44ce2854697c61d10f00abc86493d49cfec8d34b (diff)
downloadnextcloud-server-91325efa7808bd54c15950fdb0a1efc866aea79e.tar.gz
nextcloud-server-91325efa7808bd54c15950fdb0a1efc866aea79e.zip
Add tasks::last_updated column and vacate tasks after a week
Signed-off-by: Marcel Klehr <mklehr@gmx.net> (cherry picked from commit cb0f918d2101bf7644d7d84f811b37e3e672f091)
Diffstat (limited to 'core/Migrations')
-rw-r--r--core/Migrations/Version28000Date20230616104802.php7
1 files changed, 7 insertions, 0 deletions
diff --git a/core/Migrations/Version28000Date20230616104802.php b/core/Migrations/Version28000Date20230616104802.php
index 76d8173861f..ab7347608e2 100644
--- a/core/Migrations/Version28000Date20230616104802.php
+++ b/core/Migrations/Version28000Date20230616104802.php
@@ -78,9 +78,16 @@ class Version28000Date20230616104802 extends SimpleMigrationStep {
'length' => 32,
'default' => '',
]);
+ $table->addColumn('last_updated', 'integer', [
+ 'notnull' => false,
+ 'length' => 4,
+ 'default' => 0,
+ 'unsigned' => true,
+ ]);
$table->setPrimaryKey(['id'], 'llm_tasks_id_index');
$table->addUniqueIndex(['status', 'type'], 'llm_tasks_status_type');
+ $table->addIndex(['last_updated'], 'llm_tasks_updated');
}
return $schema;