🫧💦 ↝ Weekly Milestone Automation

[Gizmotronn]

This task sets up a backend process to clear and reset the user_milestones table every week, as well as assigning new milestones

✅ Requirements

• Add a user_milestones SQL table to track per-user milestone assignments
• Build a Go program to delete expired milestone rows weekly (based on week_start)
• Add logging to the cleanup script
• Create a GitHub Action that:
  • Runs every Sunday 00:01 AEST

Later: We’ll add milestone assignment logic based on player activity (e.g., past 2 weeks).

File

• Go file: jobs/reset_user_milestones.go
• Workflow: .github/workflows/reset_user_milestones.yml

[riturajFi]

would love to contribute! Can you please assign it to me?