Find Jobs
Hire Freelancers

MySQL database refinements

$100-300 USD

Dalam Kemajuan
Disiarkan lebih dari 16 tahun yang lalu

$100-300 USD

Dibayar semasa penghantaran
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.
ID Projek: 184490

Tentang projek

27 cadangan
Projek jarak jauh
Aktif 16 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan

Tentang klien

Bendera UNITED STATES
Roseville, United States
5.0
6
Ahli sejak Mac 1, 2007

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.