| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 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 | |
| 2023-09-12 | Notification 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-13 | Add trigger to prune game data when archiving a game. | Tor Andersson | |
| 2023-07-13 | Add "xtime" column for games to record finish date when state is missing. | Tor Andersson | |
| 2023-07-13 | Use sequential per-game chat ids. | Tor Andersson | |
| 2023-07-01 | Add "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-23 | Improve 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-28 | Rename game "description" to "notice". | Tor Andersson | |
| 2023-04-18 | Make 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-18 | Forum search using FTS5. | Tor Andersson | |
| 2023-03-17 | Update Webhooks to allow custom JSON property for message content. | Tor Andersson | |
| Support Slack and others. | |||
| 2023-03-05 | Update schema. | Tor Andersson | |
| 2023-02-26 | Count invites as active games in header. | Tor Andersson | |
| 2023-02-26 | Invite player system. | Tor Andersson | |
| 2023-02-01 | Add Webhook notifications. | Tor Andersson | |
| 2023-01-31 | Move user dynamic info into SQL view. | Tor Andersson | |
| 2022-11-14 | Log deleted user names. | Tor Andersson | |
| 2022-10-05 | Track read status of in-game chat messages. | Tor Andersson | |
| 2022-10-05 | Track forum thread read/unread status for logged in users. | Tor Andersson | |
| 2022-10-05 | Use julianday time stamps. | Tor Andersson | |
| 2022-10-05 | Add contact list with friends and blacklisted users. | Tor Andersson | |
| 2022-10-05 | Remove foreign key syntax. | Tor Andersson | |
| Use explicit triggers instead. | |||
| 2022-10-05 | Add "delete account" screen. | Tor Andersson | |
| 2022-10-05 | Add notepad. | Tor Andersson | |
 |
index : server | |
| Rally the Troops server | Tor |
| summaryrefslogtreecommitdiff |
path: root/schema.sql