ALTER TABLE `activity` ADD COLUMN `act_recovery_ref` VARCHAR(45) NULL DEFAULT NULL AFTER `download_attachment_act`, ADD COLUMN `is_recovery` ENUM('YES','NO') NOT NULL DEFAULT 'NO' AFTER `act_recovery_ref`;