En curso

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.

Habilidades: Entrada de datos, Procesamiento de datos

Ver más: run multiple mysql database queries php send xml, collecting information mysql database, building front end mysql database, query mysql database information, php script updates mysql database, php script read pop3 email message mysql database, create pdf mysql database, javascript mysql database update click, xml parser mysql database, vbulletin mysql database move, mysql database splitter, creating mysql database contact form, create mysql database iis, simple php mysql database, mysql database locked repair, building mysql database, outsource help mysql database, change encoding mysql database joomla, collect feedback php store mysql database, feedback form mysql database

Información del empleador:
( 6 comentarios ) Roseville, United States

Nº del proyecto: #184490