ALTER TABLE `locations` CHANGE `site_code` `site_code_id` INT NULL DEFAULT NULL;