MatchOnSat API (latest)
=======================

Generated: 2025-12-19T14:52:23.373555Z

Folders:
- config.php      : DB config + CORS headers
- db.php          : mysqli connection
- helpers.php     : JSON helpers, auth helpers
- api/index.php   : simple health check
- api/auth/*.php  : login, register, me
- api/matches/*.php : today, show
- api/favorites/*.php : list, save
- api/settings/*.php  : get, save

Expected tables (MySQL):
- users (id, name, email, password_hash, created_at)
- user_tokens (id, user_id, token, created_at, expires_at)
- matches (id, league_name_en, league_name_ar, home_name_en, home_name_ar, away_name_en, away_name_ar, home_score, away_score, status, kickoff_utc, ...)
- match_events (id, match_id, minute, team_side, player_name, type, detail)
- match_stats (id, match_id, stat_key, home_value, away_value)
- channels (id, name, sat_name, freq, polarization, symbol_rate, lang)
- match_channels (id, match_id, channel_id)
- favorites (id, user_id, fav_type, fav_id, created_at)
- user_settings (user_id PK, lang, notif_goals, notif_before_15, notif_favorites)
