summaryrefslogtreecommitdiff
path: root/schema.sql
AgeCommit message (Expand)Author
2 daysFix initial clock SQL trigger.HEADmasterTor Andersson
2025-02-23Tweak winner logic to scale threshold by player count.Tor Andersson
2025-02-23Track is_active in players table. Improve SQL triggers for time control.Tor Andersson
2025-02-14Show play stats on user pages.Tor Andersson
2025-02-12Support multi-active player states for 3p+ games.Tor Andersson
2025-02-12Track time to move per user.Tor Andersson
2025-02-12Track all game timeouts.Tor Andersson
2025-02-12Games that time out should result in "None" instead of resign.Tor Andersson
2025-02-12Use state.active to detect finished games.Tor Andersson
2025-02-12Split and clean up user table into more sub-tables.Tor Andersson
2024-11-24Add log entry for all timed out tournament games.Tor Andersson
2024-11-23Pause inactive users from tournament queue.Tor Andersson
2024-11-05Improve tournament sorting order.Tor Andersson
2024-10-17Fix tournament timeout bans.Tor Andersson
2024-10-13Tournaments!Tor Andersson
2024-10-07Zap "setups" table.Tor Andersson
2024-10-03Be more robust when deleting accounts.Tor Andersson
2024-09-26Simplify notification logic and don't send reminders.Tor Andersson
2024-08-22Don't count unstarted games as "waiting" in header.Tor Andersson
2024-08-20New time control.Tor Andersson
2024-07-23New join page!Tor Andersson
2024-03-16Fix typo in schema.Tor Andersson
2024-03-16Add and track score in player/role assignment.Tor Andersson
2024-02-15Add import-game and export-game scripts.Tor Andersson
2024-02-07Store matching replay_id in game_snap.Tor Andersson
2024-01-28Fix rating_view schema.Tor Andersson
2024-01-28Add time control enforcement.Tor Andersson
2024-01-11Send chat message when a user leaves games by deleting their account.Tor Andersson
2024-01-02Handle multiple winners for Elo calculations.Tor Andersson
2024-01-01Track total time used and time added for each player.Tor Andersson
2024-01-01Don't count games that end early (resigned/timed out) in stats.Tor Andersson
2024-01-01Start games automatically instead of sending reminders to start.Tor Andersson
2024-01-01Use table for forbidden user names.Tor Andersson
2023-12-27Move more player/game info stuff into SQL.Tor Andersson
2023-12-23Send system chat messages when players join and part active games.Tor Andersson
2023-11-30Log IP access.Tor Andersson
2023-10-21Add color themes.Tor Andersson
2023-10-13Fix SQL game view to show games with no owner.Tor Andersson
2023-10-07Fix sending out ready to start reminders.Tor Andersson
2023-10-05Revert "Add match making."Tor Andersson
2023-10-05Add match making.Tor Andersson
2023-10-05Add game "setups" for automated match making and tournaments.Tor Andersson
2023-10-05Avoid "natural" joins for future proofing schema changes.Tor Andersson
2023-09-21Only update ELO if at least 5 moves were made.Tor Andersson
2023-09-20Add pace property to games.Tor Andersson
2023-09-20Move mtime and active into games table.Tor Andersson
2023-09-13Calculate Elo ratings.Tor Andersson
2023-09-13Set player_count in database for faster and easier logic.Tor Andersson
2023-09-13Add mail verification.Tor Andersson
2023-09-13Don't recreate forum FTS search tables every time we update the schema.Tor Andersson