summaryrefslogtreecommitdiff
path: root/schema.sql
AgeCommit message (Expand)Author
10 hoursSupport multi-active player states for 3p+ games.Tor Andersson
10 hoursTrack time to move per user.Tor Andersson
10 hoursTrack all game timeouts.Tor Andersson
10 hoursGames that time out should result in "None" instead of resign.Tor Andersson
10 hoursUse state.active to detect finished games.Tor Andersson
10 hoursSplit 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
2023-09-12Notification system improvements.Tor Andersson
2023-07-13Add trigger to prune game data when archiving a game.Tor Andersson
2023-07-13Add "xtime" column for games to record finish date when state is missing.Tor Andersson
2023-07-13Use sequential per-game chat ids.Tor Andersson