=== MIGRATION EEX_SYMBOLS_REFERENCE VERS MEGA CATALOGUE ===

📋 Structure des tables:
   eex_symbols_reference:
     - id (int(11))
     - symbol_native (varchar(255))
     - symbol_api_format (varchar(255))
     - symbol_stored_format (varchar(255))
     - symbol_type (enum('FUTURES','SPOT','POWER_SPOT'))
     - market_category (enum('POWER','GAS','EUA','CO2'))
     - country_code (varchar(10))
     - country_name (varchar(50))
     - product_type (enum('BASE','PEAK','DAY_AHEAD','WEEKEND','NEXT_DAY'))
     - period_type (enum('YEAR','QUARTER','MONTH','SEASON','DAILY'))
     - exchange_name (varchar(50))
     - description_fr (text)
     - description_en (text)
     - is_active (tinyint(1))
     - created_at (timestamp)
     - updated_at (timestamp)

   eex_v2_mega_catalog:
     - id (int(11))
     - provider (enum('EPEX','EEX','Nordpool'))
     - product_type (enum('SPOT_POWER','POWER_FUTURE','GAS_FUTURE','GAS_SPOT','CO2_FUTURE','GO','AGRICULTURAL_FUTURE','FREIGHT_FUTURE','UNKNOWN_FUTURE'))
     - contract_level (enum('generic','specific'))
     - parent_code (varchar(50))
     - product_code (varchar(100))
     - product_name (varchar(200))
     - scraping_method (enum('API','HTML','HYBRID'))
     - is_active (tinyint(1))
     - country_code (varchar(10))
     - country_name (varchar(100))
     - api_symbol (varchar(200))
     - api_endpoint (varchar(500))
     - api_method (varchar(20))
     - contract_period (varchar(50))
     - maturity_date (date)
     - contract_year (year(4))
     - contract_quarter (tinyint(4))
     - contract_month (tinyint(4))
     - is_favorite (tinyint(1))
     - has_year_variants (tinyint(1))
     - has_quarter_variants (tinyint(1))
     - has_month_variants (tinyint(1))
     - target_table (varchar(100))
     - delivery_type (varchar(50))
     - spot_market_type (varchar(50))
     - delivery_start (date)
     - delivery_end (date)
     - granularity (varchar(50))
     - region (varchar(100))
     - market_area (varchar(100))
     - expected_records_per_day (int(11))
     - expected_frequency (varchar(50))
     - data_available_from (date)
     - data_available_to (date)
     - currency (varchar(10))
     - unit (varchar(50))
     - importance (enum('principal','secondaire','mineur'))
     - priority (int(11))
     - is_available (tinyint(1))
     - trading_status (enum('active','expired','future','suspended'))
     - is_deprecated (tinyint(1))
     - service_id (varchar(50))
     - first_seen_date (date)
     - last_checked_date (datetime)
     - activated_date (datetime)
     - deactivated_date (datetime)
     - deprecated_date (datetime)
     - total_scraped_records (int(11))
     - last_scraped_date (date)
     - last_scrape_success (datetime)
     - last_scrape_error (datetime)
     - error_count (int(11))
     - success_rate (decimal(5,2))
     - description (text)
     - notes (text)
     - tags (varchar(500))
     - config_json (longtext)
     - created_at (timestamp)
     - updated_at (timestamp)
     - created_by (varchar(100))
     - updated_by (varchar(100))

📊 Contenu de eex_symbols_reference:
   - FUTURES / POWER / DE: 6 total, 6 actifs
   - FUTURES / POWER / F7: 6 total, 6 actifs
   - FUTURES / GAS / EU: 4 total, 4 actifs
   - FUTURES / EUA / EU: 1 total, 1 actifs
   - FUTURES / CO2 / EU: 1 total, 1 actifs
   - SPOT / GAS / AT: 2 total, 2 actifs
   - SPOT / GAS / CZ: 2 total, 2 actifs
   - SPOT / GAS / DE: 2 total, 2 actifs
   - SPOT / GAS / ES: 2 total, 2 actifs
   - SPOT / GAS / FR: 4 total, 4 actifs
   - SPOT / GAS / GB: 2 total, 2 actifs
   - SPOT / GAS / IT: 2 total, 2 actifs
   - SPOT / GAS / NL: 2 total, 2 actifs
   - POWER_SPOT / POWER / FR: 1 total, 1 actifs

🔍 Vérification doublons avec mega catalogue: