| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 2 days | Fix initial clock SQL trigger.HEADmaster | Tor Andersson | |
| 2025-02-23 | Tweak winner logic to scale threshold by player count. | Tor Andersson | |
| 2025-02-23 | Track is_active in players table. Improve SQL triggers for time control. | Tor Andersson | |
| Use triggers to update is_active and time control data and move time statistics. Show median and interquartile range move times on profile. | |||
| 2025-02-14 | Show play stats on user pages. | Tor Andersson | |
| Timeout and move time. Most played games. | |||
| 2025-02-12 | Support multi-active player states for 3p+ games. | Tor Andersson | |
| 2025-02-12 | Track time to move per user. | Tor Andersson | |
| 2025-02-12 | Track all game timeouts. | Tor Andersson | |
| 2025-02-12 | Games that time out should result in "None" instead of resign. | Tor Andersson | |
| Clean up resignation handling. Prepare for collectively abandoning games as well. | |||
| 2025-02-12 | Use state.active to detect finished games. | Tor Andersson | |
| Instead of looking for (state.state === "game_over"). Add is_active_role helper function. | |||
| 2025-02-12 | Split and clean up user table into more sub-tables. | Tor Andersson | |
| 2024-11-24 | Add log entry for all timed out tournament games. | Tor Andersson | |
| 2024-11-23 | Pause inactive users from tournament queue. | Tor Andersson | |
| Remove very inactive users from tournament queue. Count tournaments as "open" while they still have players queued. | |||
| 2024-11-05 | Improve tournament sorting order. | Tor Andersson | |
| 2024-10-17 | Fix tournament timeout bans. | Tor Andersson | |
| 2024-10-13 | Tournaments! | Tor Andersson | |
| 2024-10-07 | Zap "setups" table. | Tor Andersson | |
| 2024-10-03 | Be more robust when deleting accounts. | Tor Andersson | |
| Leave player assignment to not mess with Elo ratings and tournament data. Reset ctime when game is actually started. | |||
| 2024-09-26 | Simplify notification logic and don't send reminders. | Tor Andersson | |
| 2024-08-22 | Don't count unstarted games as "waiting" in header. | Tor Andersson | |
| 2024-08-20 | New time control. | Tor Andersson | |
| 2024-07-23 | New join page! | Tor Andersson | |
| * Remove explicit (and redundant) role=Observer parameter. * Remove old /play/:id redirects. * Show "private" badge on game boxes. * Forbid leave/kick in public games. * Allow "rewind" by owner in public games. | |||
| 2024-03-16 | Fix typo in schema. | Tor Andersson | |
| 2024-03-16 | Add and track score in player/role assignment. | Tor Andersson | |
| 2 points for a win, 1 point for a tie, 0 points for a loss. | |||
| 2024-02-15 | Add import-game and export-game scripts. | Tor Andersson | |
| To bulk transfer all game state, replay, and snapshots into a new game. | |||
| 2024-02-07 | Store matching replay_id in game_snap. | Tor Andersson | |
| 2024-01-28 | Fix rating_view schema. | Tor Andersson | |
| 2024-01-28 | Add time control enforcement. | Tor Andersson | |
| 2024-01-11 | Send chat message when a user leaves games by deleting their account. | Tor Andersson | |
| 2024-01-02 | Handle multiple winners for Elo calculations. | Tor Andersson | |
| 2024-01-01 | Track total time used and time added for each player. | Tor Andersson | |
| TODO: Add time control and resign timed out games. | |||
| 2024-01-01 | Don't count games that end early (resigned/timed out) in stats. | Tor Andersson | |
| 2024-01-01 | Start games automatically instead of sending reminders to start. | Tor Andersson | |
| Blacklists and invitations handle the cases for which manual starting of games was needed. | |||
| 2024-01-01 | Use table for forbidden user names. | Tor Andersson | |
| 2023-12-27 | Move more player/game info stuff into SQL. | Tor Andersson | |
| Update invite_count with triggers. Add games.is_ready generated column. Add games.is_opposed generated column. Add player_view with is_active column. | |||
| 2023-12-23 | Send system chat messages when players join and part active games. | Tor Andersson | |
| 2023-11-30 | Log IP access. | Tor Andersson | |
| 2023-10-21 | Add color themes. | Tor Andersson | |
| 2023-10-13 | Fix SQL game view to show games with no owner. | Tor Andersson | |
| 2023-10-07 | Fix sending out ready to start reminders. | Tor Andersson | |
| 2023-10-05 | Revert "Add match making." | Tor Andersson | |
| This reverts commit b5a31813aa284b8b64bfd2660ea3a048275cee89. | |||
| 2023-10-05 | Add match making. | Tor Andersson | |
| 2023-10-05 | Add game "setups" for automated match making and tournaments. | Tor Andersson | |
| 2023-10-05 | Avoid "natural" joins for future proofing schema changes. | Tor Andersson | |
| 2023-09-21 | Only update ELO if at least 5 moves were made. | Tor Andersson | |
| 2023-09-20 | Add pace property to games. | Tor Andersson | |
| Currently unenforced and only visual effect in game listings.- Future time control and user penalty features may make use of it. | |||
| 2023-09-20 | Move mtime and active into games table. | Tor Andersson | |
| Avoid joining with game_state for all the game list views. | |||
| 2023-09-13 | Calculate Elo ratings. | Tor Andersson | |
| Primarily for use with future matchmaking system to provide better games for everyone. Show top 5 players of each game on the game pages. | |||
| 2023-09-13 | Set player_count in database for faster and easier logic. | Tor Andersson | |
| Track ready to start and unjoined games in "active" header. | |||
| 2023-09-13 | Add mail verification. | Tor Andersson | |
| 2023-09-13 | Don't recreate forum FTS search tables every time we update the schema. | Tor Andersson | |
 |
index : server | |
| Rally the Troops server | Tor |
| summaryrefslogtreecommitdiff |
path: root/schema.sql