Lars
fa10450315
All checks were successful
Deploy Development / deploy (push) Successful in 42s
Test Suite / pytest-backend (push) Successful in 39s
Test Suite / lint-backend (push) Successful in 0s
Test Suite / build-frontend (push) Successful in 13s
Test Suite / k6 /health Baseline (push) Successful in 33s
Test Suite / playwright-tests (push) Successful in 1m20s
- Incremented application version to 0.8.192 and database schema version to 20260606081. - Updated club module versions for 'clubs' and 'club_creation_requests' to reflect recent changes. - Implemented logic to mark approved club creation requests as 'superseded' when the associated club is deleted. - Refactored frontend components to clear session storage for coach-related keys upon logout and during login checks. - Enhanced onboarding page to accurately display the status of club creation requests based on their validity.
14 lines
573 B
SQL
14 lines
573 B
SQL
-- Migration 081: Status superseded wenn freigegebener Verein gelöscht wurde
|
|
|
|
ALTER TABLE club_creation_requests
|
|
DROP CONSTRAINT IF EXISTS club_creation_requests_status_check;
|
|
|
|
ALTER TABLE club_creation_requests
|
|
ADD CONSTRAINT club_creation_requests_status_check
|
|
CHECK (status IN ('pending', 'approved', 'rejected', 'withdrawn', 'superseded'));
|
|
|
|
-- Bestehende Drift: approved ohne Verein (ON DELETE SET NULL auf created_club_id)
|
|
UPDATE club_creation_requests
|
|
SET status = 'superseded', updated_at = NOW()
|
|
WHERE status = 'approved' AND created_club_id IS NULL;
|