CREATE TABLE `scrapp_epex_v2` (
  `trading_modality` varchar(255) DEFAULT 'Day-Ahead',
  `auction` varchar(255) DEFAULT NULL,
  `market_area` varchar(255) DEFAULT NULL,
  `CLE` varchar(255) NOT NULL,
  `date_epex` date DEFAULT NULL,
  `heure` int(11) DEFAULT NULL,
  `minute` int(11) DEFAULT NULL,
  `timezone_info` varchar(10) DEFAULT 'CET',
  `is_dst` tinyint(1) DEFAULT 0,
  `day_type` enum('normal','spring','autumn') DEFAULT 'normal',
  `buy_volume` decimal(10,2) DEFAULT NULL,
  `sell_volume` decimal(10,2) DEFAULT NULL,
  `volume` decimal(10,2) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `URL_query` text DEFAULT NULL,
  `date_crea` datetime DEFAULT curdate(),
  PRIMARY KEY (`CLE`),
  UNIQUE KEY `unique_cle` (`CLE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci