| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 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 | |
| 2022-10-05 | Set affinity of json columns back to "text". | Tor Andersson | |
| 2022-08-02 | Moderation tools for admin user. | Tor Andersson | |
| Ban and unban users. Delete forum posts and threads. | |||
| 2022-06-21 | Some more mobile friendly layout tuning. | Tor Andersson | |
| 2022-06-16 | Drop time column from game replay table. | Tor Andersson | |
| 2022-06-09 | Allow users to leave and join active games. | Tor Andersson | |
| Add "Need replacement" list of games. | |||
| 2022-04-15 | Don't log IP addresses. | Tor Andersson | |
| 2022-04-15 | Drop IP blacklist. Just use iptables instead. | Tor Andersson | |
| 2022-03-05 | Use JSON type in schema. | Tor Andersson | |
| 2022-02-15 | Drop table roles. | Tor Andersson | |
| 2022-01-01 | Don't hardwire card drop shadow and behavior in grid.css | Tor Andersson | |
| 2021-12-31 | Parameterize site name and domain. | Tor Andersson | |
 |
index : server | |
| Rally the Troops server | Tor |
| summaryrefslogtreecommitdiff |
path: root/schema.sql