_scripts

Overview ¶

setup_pocketbase.go — Create all FFPL PocketBase collections via the Admin API.

Run ONCE after a fresh PocketBase install:

go run _scripts/setup_pocketbase.go

Prompts for admin email + password (or reads FFPL_PB_EMAIL / FFPL_PB_PASS env vars). Safe to re-run — skips collections that already exist.

Collections created (unified schema from Main PB + ffpl-server PB):

ac_loadouts            — registered AC builds (one per AC per player)
matches                — match records (queued → running → completed)
challenges             — challenge requests between pilots
disputes               — disputed match results awaiting commissioner review
announcements          — league announcements / news feed
season_info            — singleton season metadata
pilot_profiles         — pilot-curated profile: handle, bio, challenge mode, replay prefs
rewards                — prize pool rewards for pilots
league_sponsors        — in-universe sponsor entities (factions / patrons)
events                 — live and upcoming events (all game modes)
season_titles          — pilot titles earned during seasons
antipad_flags          — antipad cheat detection flags
event_holdings         — CTVIP ball / Siege fortress holder tracking
event_modifiers        — event modifier toggles (iron_man, attrition, etc.)
event_pairings         — bracket pairings for tournaments
event_participants     — registered participants for structured events
marketplace_listings   — marketplace for selling items
pilot_sponsor_badges   — in-universe patronage badges for pilots
pilot_color_packs      — owned color pack wares
color_packs            — available color packs (official + community)
commissioner_licenses  — commissioner license records
commissioners          — commissioner dashboard records
koth_queue             — King of the Hill challenger queue
grand_prix_packages    — Grand Prix stage bundles
prize_pools            — event prize pool tracking
sponsor_badges         — event donation / sponsorship badges
sponsorship_applications — pilot applications for in-universe patronage
chips_wallets          — in-universe currency wallets
teams                  — team / clan records