Database
Schema and persistence behavior for gcm_referral.
Tables
gcm_referral_users
- Stores player identity, referral code, points, uses, claimed claims, claimed code, and played time.
- Primary key:
id - Unique key:
code
gcm_referral_categories
- Stores referral store categories (
value,name,icon). - Primary key:
value
gcm_referral_items
- Stores redeemable items and metadata (
rewardType,price,stock,vipaccess,variables). - Primary key: auto-increment
id
gcm_referral_claims
- Stores claim definitions (
amount,hours,type,limit). - Primary key: auto-increment
id
Startup verification
On MySQL.ready, the resource verifies the structure of all four tables before loading runtime caches.