=== REFACTORISATION MEGA CATALOGUE EEX === Date: 2026-04-14 05:10:22 ÉTAPE 1: Ajout des nouvelles colonnes... ℹ️ Colonne has_month_variants existe déjà ℹ️ Colonne has_quarter_variants existe déjà ÉTAPE 2: Analyse des produits avec variants d'années... Produits avec variants d'années trouvés: 106 --- Analyse: /E.DEBY (ID: 1920) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.DEPY (ID: 1967) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.F7BY (ID: 1766) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.F7PY (ID: 1813) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FCBY (ID: 2695) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FCPY (ID: 2742) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FDBY (ID: 2061) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FDPY (ID: 2108) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FEBY (ID: 2574) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FPBY (ID: 2478) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FPPY (ID: 2481) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FUBY (ID: 1864) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.FUPY (ID: 1873) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G0BS (ID: 10000) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G0BY (ID: 1364) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G1BS (ID: 10001) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G1BY (ID: 1243) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G3BS (ID: 10002) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G3BY (ID: 1428) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G5BS (ID: 10003) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G5BY (ID: 1368) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G8BY (ID: 1239) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.G9BY (ID: 1312) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.GBBY (ID: 1433) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.GCBY (ID: 1372) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.GDBY (ID: 1247) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.GEBY (ID: 1376) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.GFBY (ID: 1251) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.GLBY (ID: 1256) --- ❓ Type: Inconnu, garder tel quel --- Analyse: /E.GTBY (ID: 1260) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 1DBY (ID: 1578) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 1NBY (ID: 2245) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 1SBY (ID: 2624) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 2DBY (ID: 1625) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 2NBY (ID: 2253) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 2SBY (ID: 2632) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 3NBY (ID: 2256) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 3SBY (ID: 2640) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 4NBY (ID: 2260) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 4SBY (ID: 2648) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 5NBY (ID: 2263) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ATBY (ID: 1481) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ATPY (ID: 1528) --- ❓ Type: Inconnu, garder tel quel --- Analyse: CRBY (ID: 2279) --- ❓ Type: Inconnu, garder tel quel --- Analyse: CRPY (ID: 2287) --- ❓ Type: Inconnu, garder tel quel --- Analyse: EEX Norwegian NO4 Power Futures (ID: 2257) --- ❓ Type: Inconnu, garder tel quel --- Analyse: EGOS (ID: 2759) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ESPY (ID: 2621) --- ❓ Type: Inconnu, garder tel quel --- Analyse: F9BY (ID: 2428) --- ❓ Type: Inconnu, garder tel quel --- Analyse: F9PY (ID: 2475) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FBBY (ID: 2237) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FFBY (ID: 2014) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FHBY (ID: 2489) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FKBY (ID: 2271) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FNBY (ID: 1816) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOBF (ID: 2180) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOBS (ID: 2178) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOBY (ID: 2179) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOPF (ID: 2229) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOPS (ID: 2227) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOPY (ID: 2228) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQBF (ID: 2121) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQBS (ID: 2119) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQBY (ID: 2120) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQPF (ID: 2131) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQPS (ID: 2129) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQPY (ID: 2130) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FRPY (ID: 2497) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FUBS (ID: 1863) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FUPS (ID: 1872) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FVBY (ID: 2519) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FVPY (ID: 2527) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FXBY (ID: 2334) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FXPY (ID: 2381) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FYBY (ID: 2508) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FYPY (ID: 2511) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FZBY (ID: 2505) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G0BS (ID: 1363) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G1BS (ID: 1242) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G3BS (ID: 1427) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G3FS (ID: 1423) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G3FY (ID: 1424) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G5BS (ID: 1367) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G8BS (ID: 1238) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G8FS (ID: 1234) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G8FY (ID: 1235) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G9BS (ID: 1311) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G9FS (ID: 1307) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G9FY (ID: 1308) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GBBS (ID: 1432) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GCBS (ID: 1371) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GDBS (ID: 1246) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GEBS (ID: 1375) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GFBS (ID: 1250) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GGFS (ID: 1359) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GGFY (ID: 1360) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GLBS (ID: 1255) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GTBS (ID: 1259) --- ❓ Type: Inconnu, garder tel quel --- Analyse: IRBY (ID: 2111) --- ❓ Type: Inconnu, garder tel quel --- Analyse: O2FY (ID: 2748) --- ❓ Type: Inconnu, garder tel quel --- Analyse: O7FY (ID: 2745) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ODFY (ID: 2751) --- ❓ Type: Inconnu, garder tel quel --- Analyse: OEFY (ID: 2756) --- ❓ Type: Inconnu, garder tel quel --- Analyse: Q0BY (ID: 1672) --- ❓ Type: Inconnu, garder tel quel --- Analyse: Q0PY (ID: 1719) --- ❓ Type: Inconnu, garder tel quel --- Analyse: Q1BY (ID: 1531) --- ❓ Type: Inconnu, garder tel quel ÉTAPE 4: Application des modifications... ✅ ID 1920: /E.DEBY → /E.DEBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1967: /E.DEPY → /E.DEPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1766: /E.F7BY → /E.F7BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1813: /E.F7PY → /E.F7PY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2695: /E.FCBY → /E.FCBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2742: /E.FCPY → /E.FCPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2061: /E.FDBY → /E.FDBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2108: /E.FDPY → /E.FDPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2574: /E.FEBY → /E.FEBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2478: /E.FPBY → /E.FPBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2481: /E.FPPY → /E.FPPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1864: /E.FUBY → /E.FUBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1873: /E.FUPY → /E.FUPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 10000: /E.G0BS → /E.G0BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1364: /E.G0BY → /E.G0BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 10001: /E.G1BS → /E.G1BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1243: /E.G1BY → /E.G1BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 10002: /E.G3BS → /E.G3BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1428: /E.G3BY → /E.G3BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 10003: /E.G5BS → /E.G5BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1368: /E.G5BY → /E.G5BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1239: /E.G8BY → /E.G8BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1312: /E.G9BY → /E.G9BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1433: /E.GBBY → /E.GBBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1372: /E.GCBY → /E.GCBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1247: /E.GDBY → /E.GDBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1376: /E.GEBY → /E.GEBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1251: /E.GFBY → /E.GFBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1256: /E.GLBY → /E.GLBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1260: /E.GTBY → /E.GTBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1578: 1DBY → 1DBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2245: 1NBY → 1NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2624: 1SBY → 1SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1625: 2DBY → 2DBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2253: 2NBY → 2NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2632: 2SBY → 2SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2256: 3NBY → 3NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2640: 3SBY → 3SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2260: 4NBY → 4NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2648: 4SBY → 4SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2263: 5NBY → 5NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1481: ATBY → ATBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1528: ATPY → ATPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2279: CRBY → CRBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2287: CRPY → CRPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2257: EEX Norwegian NO4 Power Futures → EEX Norwegian NO4 Power Futures Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2759: EGOS → EGOS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2621: ESPY → ESPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2428: F9BY → F9BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2475: F9PY → F9PY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2237: FBBY → FBBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2014: FFBY → FFBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2489: FHBY → FHBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2271: FKBY → FKBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1816: FNBY → FNBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2180: FOBF → FOBF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2178: FOBS → FOBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2179: FOBY → FOBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2229: FOPF → FOPF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2227: FOPS → FOPS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2228: FOPY → FOPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2121: FQBF → FQBF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2119: FQBS → FQBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2120: FQBY → FQBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2131: FQPF → FQPF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2129: FQPS → FQPS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2130: FQPY → FQPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2497: FRPY → FRPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1863: FUBS → FUBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1872: FUPS → FUPS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2519: FVBY → FVBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2527: FVPY → FVPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2334: FXBY → FXBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2381: FXPY → FXPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2508: FYBY → FYBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2511: FYPY → FYPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2505: FZBY → FZBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1363: G0BS → G0BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1242: G1BS → G1BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1427: G3BS → G3BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1423: G3FS → G3FS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1424: G3FY → G3FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1367: G5BS → G5BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1238: G8BS → G8BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1234: G8FS → G8FS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1235: G8FY → G8FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1311: G9BS → G9BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1307: G9FS → G9FS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1308: G9FY → G9FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1432: GBBS → GBBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1371: GCBS → GCBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1246: GDBS → GDBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1375: GEBS → GEBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1250: GFBS → GFBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1359: GGFS → GGFS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1360: GGFY → GGFY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1255: GLBS → GLBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1259: GTBS → GTBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2111: IRBY → IRBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2748: O2FY → O2FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2745: O7FY → O7FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2751: ODFY → ODFY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2756: OEFY → OEFY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1672: Q0BY → Q0BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1719: Q0PY → Q0PY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1531: Q1BY → Q1BY Flags: Month=NO, Quarter=NO, Year=YES === RÉSUMÉ FINAL === ✅ Produits mis à jour: 106 ⚠️ Doublons détectés: 0 ÉTAPE 5: Vérification finale... 📊 Statistiques finales: Total produits EEX: 565 Avec variants année: 106 Avec variants mois: 112 Avec variants trimestre: 73 🎉 REFACTORISATION TERMINÉE !