committing changes made to show preferred locations and changing pincode to varchar