User deletion related trigger #72

New issue

Closed

opened 2026-03-22 22:36:30 +00:00 by charlie · 1 comment

charlie commented

2026-03-22 22:36:30 +00:00

Owner

Create triggers that on user deletion

If the user is waiting aproval remove his entry from coach_history before his removal
If the user is currently a coach remove him as the coach of the club and make the new coach ID null

In addition a trigger that

Set the endtime in coach_history to current time when a coach stop coaching

Create triggers that on user deletion - If the user is waiting aproval remove his entry from coach_history before his removal - If the user is currently a coach remove him as the coach of the club and make the new coach ID null In addition a trigger that - Set the endtime in coach_history to current time when a coach stop coaching

charlie added reference feature/user-procs

2026-03-22 22:36:34 +00:00

charlie closed this issue

2026-04-05 22:21:37 +00:00

charlie commented

2026-04-05 22:22:03 +00:00

Author

Owner

we're short on time PRs are the new issues