aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/schema.sql
AgeCommit message (Collapse)Author
2026-02-18feat: refactor tournament to generic DB-backed N-person bracketnsfisis
Replace hardcoded 6-person tournament with a generic single-elimination bracket system backed by new DB tables (tournaments, tournament_entries, tournament_matches). Includes admin CRUD, standard seeding algorithm, bye handling, and a CSS Grid bracket renderer on the frontend. Add comprehensive tests for backend API/admin handlers, seeding logic, and frontend bracket component. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-15refactor(auth): replace JWT authentication with server-side sessionsnsfisis
Migrate from stateless JWT tokens to server-side session management backed by PostgreSQL. Sessions are hashed with SHA-256 before storage, cleaned up periodically, and invalidated on logout. This removes the need for JWT_SECRET/COOKIE_SECRET environment variables and the golang-jwt dependency. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2025-09-06feat(backend): make problems.language non-nullnsfisis
2025-09-05feat(backend): support swift languagensfisis
2025-08-17fix(backend): order of table definitionnsfisis
2025-03-11feat: show user labelnsfisis
2025-03-08websocket to pollingnsfisis
2025-03-04rm registration tokennsfisis
2024-08-11feat(backend): make `games.problem_id` non-nullnsfisis
2024-08-09feat: support authentication via forteensfisis
2024-08-08feat(backend): add `code_hash` to `submissions` tablensfisis
2024-08-08feat(backend): create submission_results tablensfisis
2024-08-08feat(backend): add unique constraint to testcase_resultsnsfisis
2024-08-08feat(backend): add created_at column to testcase_resultsnsfisis
2024-08-08feat(backend): rename testcase_executions to testcase_resultsnsfisis
2024-08-08feat(backend): make testcase_executions.testcase_id non-nullnsfisis
2024-08-05feat(backend): create table `submissions` and `testcase_execution`nsfisis
2024-08-05feat(backend): add `game_type` column to `games`nsfisis
2024-07-31feat(backend): create indice on tablesnsfisis
2024-07-30fix(backend): add unique constraint to user_auths.user_idnsfisis
2024-07-30feat(backend): add fixture file for local devnsfisis
2024-07-29feat: add testcases tablensfisis
2024-07-28feat(backend): add game_players tablensfisis
2024-07-28feat(backend): change games table and create problems tablensfisis
2024-07-28chore: format schema.sqlnsfisis
2024-07-28rename user's display_username to display_namensfisis
2024-07-27db: rename users.icon_url to users.icon_pathnsfisis
2024-07-21add sqldef and sqlcnsfisis