From c0aade671ebcf6afe6c918e1d2192fe5cf4cb32c Mon Sep 17 00:00:00 2001
From: Jan-Hendrik Willms <tleilax+studip@gmail.com>
Date: Tue, 21 May 2024 08:45:14 +0000
Subject: fixes #4196

Closes #4196

Merge request studip/studip!3027
---
 db/migrations/6.0.6_adjust_default_cache_name.php | 27 +++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 db/migrations/6.0.6_adjust_default_cache_name.php

diff --git a/db/migrations/6.0.6_adjust_default_cache_name.php b/db/migrations/6.0.6_adjust_default_cache_name.php
new file mode 100644
index 0000000..ea71f35
--- /dev/null
+++ b/db/migrations/6.0.6_adjust_default_cache_name.php
@@ -0,0 +1,27 @@
+<?php
+/**
+ * @see https://gitlab.studip.de/studip/studip/-/issues/4196
+ */
+return new class extends Migration
+{
+    public function description()
+    {
+        return 'Adjust the default cache in table "config" as well"';
+    }
+
+    protected function up()
+    {
+        $query = "UPDATE `config`
+                  SET `value` = JSON_REPLACE(`value`, '$.type', ?)
+                  WHERE `field` = 'SYSTEMCACHE'";
+        DBManager::get()->execute($query, [Studip\Cache\DbCache::class]);
+    }
+
+    protected function down()
+    {
+        $query = "UPDATE `config`
+                  SET `value` = JSON_REPLACE(`value`, '$.type', ?)
+                  WHERE `field` = 'SYSTEMCACHE'";
+        DBManager::get()->execute($query, [StudipDbCache::class]);
+    }
+};
-- 
cgit v1.0