summaryrefslogtreecommitdiff
path: root/schema.sql
AgeCommit message (Collapse)Author
2024-10-07Zap "setups" table.Tor Andersson
2024-10-03Be 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-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
* 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-16Fix typo in schema.Tor Andersson
2024-03-16Add 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-15Add import-game and export-game scripts.Tor Andersson
To bulk transfer all game state, replay, and snapshots into a new game.
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
TODO: Add time control and resign timed out games.
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
Blacklists and invitations handle the cases for which manual starting of games was needed.
2024-01-01Use table for forbidden user names.Tor Andersson
2023-12-27Move 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-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
This reverts commit b5a31813aa284b8b64bfd2660ea3a048275cee89.
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
Currently unenforced and only visual effect in game listings.- Future time control and user penalty features may make use of it.
2023-09-20Move mtime and active into games table.Tor Andersson
Avoid joining with game_state for all the game list views.
2023-09-13Calculate 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-13Set player_count in database for faster and easier logic.Tor Andersson
Track ready to start and unjoined games in "active" header.
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
Enable webhook notification support with .env WEBHOOKS=1 Send notifications when invited to a game. Use notification "too soon" logic for webhooks as well. Try sending webhooks 3 times before giving up. Check if player is on the join page instead of the funky "offline" check when sending "your game is ready" notification. Only show mail/webhook notification settings if they are enabled.
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
2023-07-01Add "snapshot" replay view during play.Tor Andersson
Snapshots store game state without undo and only log length. Combined with the final game state's log we can recreate the view from any snapshot quickly. Move replay code into separate script file, loaded only when used. Prefix system "setup", "resign", and "restore" actions with a period.
2023-05-23Improve replay id handling.Tor Andersson
Use a without rowid table and create the replay_id dynamically. This saves a lot of database space and performance as it removes the need for a separate index.
2023-04-28Rename game "description" to "notice".Tor Andersson
2023-04-18Make date and time handling usable with both julianday and datetime.Tor Andersson
Use datetime instead of julianday when not performance sensitive. Keep julianday for logins.
2023-04-18Forum search using FTS5.Tor Andersson
2023-03-17Update Webhooks to allow custom JSON property for message content.Tor Andersson
Support Slack and others.
2023-03-05Update schema.Tor Andersson
2023-02-26Count invites as active games in header.Tor Andersson
2023-02-26Invite player system.Tor Andersson
2023-02-01Add Webhook notifications.Tor Andersson
2023-01-31Move user dynamic info into SQL view.Tor Andersson