ALTER TABLE `rooms101_rtsdev`.`destinations`
    MODIFY COLUMN `destType` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `destCountry`,
    MODIFY COLUMN `destIdentifier` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `destType`;
