The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I need 1 database delivered for me which has about 80,000 records. The records need to be delivered in a MySQL database. The URL is in the attachment.
The MYSQL table structures are attached. We call each record a "prospect" which will help you when you see the attached MySQL database structure.
Payment terms: Full amount in escrow on engagement. 100% on delivery of 80,000 records.
There are 4 tables included: sub_categories, suburbs, prospects, prospects_sub_categories.
Two tables are reference tables (suburbs and sub_categories) The remaining two need to be filled with new prospect data.
I have included a sample record below so that you can see how the data is structured once you have loaded the attached sql file. If you have any questions, please ask.
Sample record: "insert into prospects (name, street_address, suburb_name, postcode, suburb_id, phone, fax, mobile, email, website_url, source_url, status, created_at, provider_account_id, source_type, source_id, band) valu...
Sign in or Register to see more