ALTER TABLE `fc_events`.`advertisement`
CHANGE COLUMN `raw_data` `raw_data` TEXT NULL ,
CHANGE COLUMN `start_date` `start_date` DATETIME NOT NULL ,
CHANGE COLUMN `end_date` `end_date` DATETIME NOT NULL ,
CHANGE COLUMN `advertiser_name` `advertiser_name` VARCHAR(255) NOT NULL ,
CHANGE COLUMN `status` `status` VARCHAR(45) NOT NULL ,
DROP INDEX `status_UNIQUE` ,
DROP INDEX `advertiser_name_UNIQUE` ,
DROP INDEX `end_date_UNIQUE` ,
DROP INDEX `start_date_UNIQUE` ;