chrisp/brackt - Forgejo: Beyond coding. We Forge.

chrisp/brackt

1 line

121 B

MySQL

Raw Permalink Normal View History

Enforce unique team names within a season - Add findTeamByNameInSeason (exact case-insensitive match via lower()) to the team model - Validate uniqueness in the user-facing team settings rename action - Validate uniqueness in admin assign-owner and remove-owner paths that auto-generate names - Reject whitespace-only team names that would trim to an empty string - Add DB-level unique index on (season_id, lower(name)) to close the TOCTOU race Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>

2026-05-23 16:55:08 -07:00

CREATE UNIQUE INDEX IF NOT EXISTS "teams_season_id_lower_name_unique" ON "teams" USING btree ("season_id",lower("name"));