Create table of the table we were trying to alter:

Create Table: CREATE TABLE `FLIGHT_REQUEST_NEW` (
  `ID_REQUEST` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id ricerca',
  `REQUEST_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Search Date',
  `DEPARTURE_AIRPORT` char(3) NOT NULL COMMENT 'Departure Airport',
  `ARRIVAL_AIRPORT` char(3) NOT NULL COMMENT 'Destination Airport',
  `OUTBOUND_DATE` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Departure Date',
  `RETURN_DATE` date DEFAULT NULL COMMENT 'Data volo di ritorno',
  `CLASS_FLIGHT` char(1) DEFAULT NULL COMMENT 'Flight Class',
  `FARE_TYPES` varchar(40) DEFAULT NULL,
  `EXTERNAL_ID` bigint(20) DEFAULT NULL COMMENT 'external search id',
  `EXTERNAL_SOURCE` char(3) DEFAULT NULL COMMENT 'external search type',
  `RESTRICTION` char(1) DEFAULT NULL COMMENT 'Null=Normale; W=No risultati perche fuori da whitelist; B=No risultati perch? rotta in blacklist',
  `PAYMENT_METHOD` varchar(5) DEFAULT NULL,
  `ADULTS` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Adults',
  `CHILDS` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Children',
  `INFANTS` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Babys',
  `ID_BUSINESS_PROFILE` varchar(30) NOT NULL COMMENT 'Profile',
  `EMAIL` varchar(100) DEFAULT NULL COMMENT 'Email',
  `UID` varchar(40) NOT NULL COMMENT 'Unique ID',
  `LANGUAGE` char(5) NOT NULL COMMENT 'Language',
  `IP_ADDRESS` varchar(20) NOT NULL COMMENT 'User IP',
  `SOURCE` varchar(5) DEFAULT NULL COMMENT 'Flight request Origin',
  `SERVER` varchar(128) DEFAULT NULL COMMENT 'Identification server',
  `BF_SOURCE` varchar(100) DEFAULT NULL,
  `BF_SUBSOURCE` varchar(100) DEFAULT NULL,
  `PROFILE` char(1) DEFAULT NULL,
  `APP_SERVER_SESSION_ID` varchar(50) DEFAULT NULL COMMENT 'JSession Id',
  `COUNTRY_ID` char(3) DEFAULT NULL COMMENT 'Country code obtained by Ip',
  `CURRENCY` char(3) DEFAULT NULL COMMENT 'Currency',
  PRIMARY KEY (`ID_REQUEST`,`REQUEST_DATE`),
  KEY `EMAIL` (`EMAIL`),
  KEY `UID` (`UID`),
  KEY `REQUEST_DATE` (`REQUEST_DATE`),
  KEY `IP_ADDRESS` (`IP_ADDRESS`),
  KEY `LANGUAGE` (`LANGUAGE`)
) ENGINE=InnoDB AUTO_INCREMENT=15167586660 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED COMMENT='User Searches'
/*!50100 PARTITION BY RANGE (TO_DAYS(REQUEST_DATE))
(PARTITION p237 VALUES LESS THAN (736232) ENGINE = InnoDB,
 PARTITION p238 VALUES LESS THAN (736233) ENGINE = InnoDB,
 PARTITION p239 VALUES LESS THAN (736234) ENGINE = InnoDB,
 PARTITION p240 VALUES LESS THAN (736235) ENGINE = InnoDB,
 PARTITION p241 VALUES LESS THAN (736236) ENGINE = InnoDB,
 PARTITION p242 VALUES LESS THAN (736237) ENGINE = InnoDB,
 PARTITION p243 VALUES LESS THAN (736238) ENGINE = InnoDB,
 PARTITION p244 VALUES LESS THAN (736239) ENGINE = InnoDB,
 PARTITION p245 VALUES LESS THAN (736240) ENGINE = InnoDB,
 PARTITION p246 VALUES LESS THAN (736241) ENGINE = InnoDB,
 PARTITION p247 VALUES LESS THAN (736242) ENGINE = InnoDB,
 PARTITION p248 VALUES LESS THAN (736243) ENGINE = InnoDB,
 PARTITION p249 VALUES LESS THAN (736244) ENGINE = InnoDB,
 PARTITION p250 VALUES LESS THAN (736245) ENGINE = InnoDB,
 PARTITION p251 VALUES LESS THAN (736246) ENGINE = InnoDB,
 PARTITION p252 VALUES LESS THAN (736247) ENGINE = InnoDB,
 PARTITION p253 VALUES LESS THAN (736248) ENGINE = InnoDB,
 PARTITION p254 VALUES LESS THAN (736249) ENGINE = InnoDB,
 PARTITION p255 VALUES LESS THAN (736250) ENGINE = InnoDB,
 PARTITION p256 VALUES LESS THAN (736251) ENGINE = InnoDB) */
1 row in set (0.00 sec)