Database

gcm_vips

Stores active VIP records.

Key fields:

• identifier
• discordID
• playerName
• type
• since
• expires
• lifetime

gcm_vips_codes

Stores redeem codes.

Key fields:

• code (primary key)
• viptype
• days
• lifetime

Runtime usage

• Startup loads all VIP records into in-memory cache (listaVip).
• Expired non-lifetime VIPs are periodically removed from DB.
• Code redemption deletes code row after successful use.