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

chrisp/brackt

1 line

83 B

MySQL

Raw Permalink Normal View History

Add event_starts_at timestamp to scoring events for sub-day ordering (#146) - New `event_starts_at timestamptz` column on `scoring_events`; backfilled from `event_date` (midnight UTC) via migration for all existing rows - Admin create/edit forms consolidated from separate Date + Time inputs into a single `datetime-local` field; server derives `eventDate` from the UTC date portion of `eventStartsAt` so calendar-window queries continue to work - Edit form pre-fill computed client-side via useEffect to avoid server-timezone mismatch for non-UTC admins - Sort fix: replaced `eventDate ?? earliestGameTime.split("T")[0]` with `toEventSortKey` helper that prefers `earliestGameTime ?? eventDate` so bracket events with only per-game timestamps sort in the correct calendar position - DB sort queries updated to use `eventStartsAt` as a tiebreaker after `eventDate` - F1/IndyCar/golf events now populate `earliestGameTime` from `eventStartsAt`, giving time display in `UpcomingCalendarPanel` - Bulk import gains optional `HH:MM` (UTC) third column - New unit tests for `toEventSortKey` and `eventStartsAt` model behavior Co-authored-by: Claude Sonnet 4.6 <noreply@anthropic.com>

2026-03-15 10:22:42 -07:00

ALTER TABLE "scoring_events" ADD COLUMN "event_starts_at" timestamp with time zone;