ALTER TABLE `locations` CHANGE `resource_id` `resource_id` VARCHAR(20) NULL DEFAULT NULL;