-- ==========================================================================
--  Diagnostic MySQL score live
--  A executer dans phpMyAdmin si la mise a jour echoue.
-- ==========================================================================

SELECT DATABASE() AS base_selectionnee;

SELECT COUNT(*) AS table_pronostics_existe
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'pronostics';

SELECT COLUMN_NAME, COLUMN_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'pronostics'
  AND COLUMN_NAME IN (
    'result_checked_at',
    'live_home_score',
    'live_away_score',
    'live_score_completed',
    'live_score_last_update',
    'live_score_checked_at'
  )
ORDER BY ORDINAL_POSITION;