summaryrefslogtreecommitdiff
path: root/schema.sql
AgeCommit message (Collapse)Author
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
2022-11-14Log deleted user names.Tor Andersson
2022-10-05Track read status of in-game chat messages.Tor Andersson
2022-10-05Track forum thread read/unread status for logged in users.Tor Andersson
2022-10-05Use julianday time stamps.Tor Andersson
2022-10-05Add contact list with friends and blacklisted users.Tor Andersson
2022-10-05Remove foreign key syntax.Tor Andersson
Use explicit triggers instead.
2022-10-05Add "delete account" screen.Tor Andersson
2022-10-05Add notepad.Tor Andersson
2022-10-05Set affinity of json columns back to "text".Tor Andersson
2022-08-02Moderation tools for admin user.Tor Andersson
Ban and unban users. Delete forum posts and threads.
2022-06-21Some more mobile friendly layout tuning.Tor Andersson
2022-06-16Drop time column from game replay table.Tor Andersson
2022-06-09Allow users to leave and join active games.Tor Andersson
Add "Need replacement" list of games.
2022-04-15Don't log IP addresses.Tor Andersson
2022-04-15Drop IP blacklist. Just use iptables instead.Tor Andersson
2022-03-05Use JSON type in schema.Tor Andersson
2022-02-15Drop table roles.Tor Andersson
2022-01-01Don't hardwire card drop shadow and behavior in grid.cssTor Andersson
2021-12-31Parameterize site name and domain.Tor Andersson