summaryrefslogtreecommitdiff
path: root/schema.sql
AgeCommit message (Expand)Author
2024-03-16Fix typo in schema.Tor Andersson
2024-03-16Add and track score in player/role assignment.Tor Andersson
2024-02-15Add import-game and export-game scripts.Tor Andersson
2024-02-07Store matching replay_id in game_snap.Tor Andersson
2024-01-28Fix rating_view schema.Tor Andersson
2024-01-28Add time control enforcement.Tor Andersson
2024-01-11Send chat message when a user leaves games by deleting their account.Tor Andersson
2024-01-02Handle multiple winners for Elo calculations.Tor Andersson
2024-01-01Track total time used and time added for each player.Tor Andersson
2024-01-01Don't count games that end early (resigned/timed out) in stats.Tor Andersson
2024-01-01Start games automatically instead of sending reminders to start.Tor Andersson
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