Data and storage¶
MariaDB, through Battlecore's connection pool:
| Table | Holds |
|---|---|
daily_research_assignments, weekly_research_assignments |
Each player's tasks per period, progress, reward and completion. The unique key on (player_uuid, assignment_date, slot_index) stops two servers issuing different tasks |
research_task_overrides |
Retired or force-enabled tasks, who set them and why. Read by every server every 30 seconds |
Each assignment row stores its own task text and rewards, so a config difference between servers cannot change a task after it is issued. Do not edit rows by hand; use the commands.