summaryrefslogtreecommitdiff
path: root/schema.sql
AgeCommit message (Collapse)Author
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