diff options
| author | Marcel Klehr <mklehr@gmx.net> | 2023-06-28 14:59:20 +0200 |
|---|---|---|
| committer | Marcel Klehr <mklehr@gmx.net> | 2023-07-07 13:39:10 +0200 |
| commit | cb0f918d2101bf7644d7d84f811b37e3e672f091 (patch) | |
| tree | 6997ecf25693b7a812047f8d12a58db21aa48db9 /core/Migrations | |
| parent | 1d3661ded9c4ca80c30a1ae4eb08a2d4967da8cf (diff) | |
| download | nextcloud-server-cb0f918d2101bf7644d7d84f811b37e3e672f091.tar.gz nextcloud-server-cb0f918d2101bf7644d7d84f811b37e3e672f091.zip | |
Add tasks::last_updated column and vacate tasks after a week
Signed-off-by: Marcel Klehr <mklehr@gmx.net>
Diffstat (limited to 'core/Migrations')
| -rw-r--r-- | core/Migrations/Version28000Date20230616104802.php | 7 |
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; |