From f090ba60d3868d22be39a603097637f3913dc475 Mon Sep 17 00:00:00 2001
From: Jan-Hendrik Willms <tleilax+studip@gmail.com>
Date: Wed, 2 Jul 2025 13:38:32 +0200
Subject: add migration that removes all orphaned entries from
 mvv_lvgruppe_seminar, fixes #28

Closes #28

Merge request studip/studip!4312
---
 .../5.3.31_cleanup_mvv_lvgruppe_seminar.php         | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 db/migrations/5.3.31_cleanup_mvv_lvgruppe_seminar.php

diff --git a/db/migrations/5.3.31_cleanup_mvv_lvgruppe_seminar.php b/db/migrations/5.3.31_cleanup_mvv_lvgruppe_seminar.php
new file mode 100644
index 0000000..3b671a4
--- /dev/null
+++ b/db/migrations/5.3.31_cleanup_mvv_lvgruppe_seminar.php
@@ -0,0 +1,21 @@
+<?php
+/**
+ * @see https://gitlab.studip.de/studip/studip/-/issues/28
+ */
+final class CleanupMvvLvgruppeSeminar extends Migration
+{
+    public function description()
+    {
+        return 'Removed orphaned course ids from table mvv_lvgruppe_seminar';
+    }
+
+    public function up()
+    {
+        $query = "DELETE FROM `mvv_lvgruppe_seminar`
+                  WHERE `seminar_id` NOT IN (
+                    SELECT `Seminar_id`
+                    FROM `seminare`
+                  )";
+        DBManager::get()->exec($query);
+    }
+}
-- 
cgit v1.0