I have created an extensive database. it lists every city and zip code in the united states. Some zipcodes cover more than one city. Also, some (a lot) cities have more than one zipcode.
it can be found
here.
Feel free to incorporate as much or as little as you'd like into your updated cities file.
jpalmer