// Ensure unique index exists for (user_id, game_id, period_start)
$uniq_exists = $wpdb->get_results("SHOW INDEX FROM $leaderboard_table WHERE Key_name = 'uniq_user_game_period'");
if (empty($uniq_exists)) {
$wpdb->query("ALTER TABLE $leaderboard_table ADD UNIQUE KEY uniq_user_game_period (user_id, game_id, period_start)");
}
Update: Covid-19 - 102.3 Max FM
