introduce StudygroupInvitation model and use it as relation for course and user and cleanup the orphaned studygroup invitations, fixes #5195

Closes #5195

Merge request studip/studip!3879

1 files changed, 6 insertions, 0 deletions

diff --git a/lib/models/Course.php b/lib/models/Course.php
index 4fc32e3..4fa8222 100644
--- a/lib/models/Course.php
+++ b/lib/models/Course.php
@@ -304,6 +304,12 @@ class Course extends SimpleORMap implements Range, PrivacyObject, StudipItem, Fe
             'assoc_foreign_key' => 'course_id',
             'on_delete'         => 'delete',
         ];
+        $config['has_many']['studygroup_invitations'] = [
+            'class_name' => StudygroupInvitation::class,
+            'assoc_foreign_key' => 'sem_id',
+            'on_delete'  => 'delete',
+        ];
+
 
         $config['default_values']['lesezugriff'] = 1;
         $config['default_values']['schreibzugriff'] = 1;