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