In Progress

MySQL database refinements

I have a dating website that has over 60,000 fake [login to view URL] profiles are already integrated into the database, but some of them are missing the password field, so I need someone to auto-generate random passwords and apply them to the profiles that are missing them. They can be as simple as "test1", "test2", "test3" etc, or a string of random letters.

Next, I have a zip code database that is integrated as well, but it is incomplete or outdated, since a lot of people complain that they get errors when trying to register with their zip codes. I need someone to add on to, or replace the existing zip code database, with one that is complete for all US zips.

Finally, I need someone to enter in random zip codes to the appropriate field of the fake profiles (the real profiles must not be altered - I have the ID #'s of the real profiles. The fake ones are in one block, for instance id #1 - id #60 are real, then id #61 - id #61250 are fake, then all the ones after #61250 are real). Many of the fake profiles already have zip codes, but I want them all overwritten to include only zip codes from the 20 - 30 largest metropolitan areas in the US. For instance, for Detroit the zip codes for the city of Detroit could be used as well as zip codes for Warren, Pontiac, Ferndale, Southfield etc. can be used as long as these still show up when someone does a search for anyone within 50 miles of Detroit.

All three of these things should be easily accomplished by someone who is familiar enough with MySQL. I'd rather someone spend a week and do this right, then promise me they'll have it done in 2 days, and it ends up screwed up. I've hired freelancers on here before so read my feedback.

Skills: Data Entry, Data Processing

See more: fake profiles database, mysql refinements, up string, string processing in c, some search string, people as letters, mysql freelancers, id freelancers, get code freelancers, freelancers days, freelancers city, dating freelancers, data entry real or fake, database of freelancers, city of warren, auto codes, a. d. miles, fake user profile database dating site, world city database mysql online dating, dating fake profiles database

About the Employer:
( 6 reviews ) Roseville, United States

Project ID: #184490