summaryrefslogtreecommitdiff
path: root/schema.sql
AgeCommit message (Expand)Author
2024-01-01Use table for forbidden user names.Tor Andersson
2023-12-27Move more player/game info stuff into SQL.Tor Andersson
2023-12-23Send system chat messages when players join and part active games.Tor Andersson
2023-11-30Log IP access.Tor Andersson
2023-10-21Add color themes.Tor Andersson
2023-10-13Fix SQL game view to show games with no owner.Tor Andersson
2023-10-07Fix sending out ready to start reminders.Tor Andersson
2023-10-05Revert "Add match making."Tor Andersson
2023-10-05Add match making.Tor Andersson
2023-10-05Add game "setups" for automated match making and tournaments.Tor Andersson
2023-10-05Avoid "natural" joins for future proofing schema changes.Tor Andersson
2023-09-21Only update ELO if at least 5 moves were made.Tor Andersson
2023-09-20Add pace property to games.Tor Andersson
2023-09-20Move mtime and active into games table.Tor Andersson
2023-09-13Calculate Elo ratings.Tor Andersson
2023-09-13Set player_count in database for faster and easier logic.Tor Andersson
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
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
2023-05-23Improve replay id handling.Tor Andersson
2023-04-28Rename game "description" to "notice".Tor Andersson
2023-04-18Make date and time handling usable with both julianday and datetime.Tor Andersson
2023-04-18Forum search using FTS5.Tor Andersson
2023-03-17Update Webhooks to allow custom JSON property for message content.Tor Andersson
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
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
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
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