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/User.php b/lib/models/User.php
index 190df2b..45c3b91 100644
--- a/lib/models/User.php
+++ b/lib/models/User.php
@@ -223,6 +223,12 @@ class User extends AuthUserMd5 implements Range, PrivacyObject, Studip\Calendar\
             'on_delete'  => 'delete',
         ];
 
+        $config['has_many']['studygroup_invitations'] = [
+            'class_name' => StudygroupInvitation::class,
+            'assoc_foreign_key' => 'user_id',
+            'on_delete'  => 'delete',
+        ];
+
         $config['additional_fields']['config']['get'] = function ($user) {
             return UserConfig::get($user->id);
         };