Members Database

CLOSED
Bids
7
Avg Bid (USD)
N/A
Project Budget (USD)
$30 - $100

Project Description:
I need a Sample Members MySQL Database script for a Member Database of approx 20,000 Users accounts. These are to be made up accounts of random data for stress testing on a MySQL datatase. The email address and user names must all be unique and different. The City, State, Zip Code and country must be legitimate and correct. The database script should contain random names and data and the Datatype field are listed below:
user
password
email
gender
age
day
month
year
city
state
zip
location (Country)

Please let me know if there are any questions

Here is the details of the requested Data Field Types.

id INTERGER NOTNULL AUTOINC (PK)
admin CHAR(1)
type CHAR(2)
user VARCHAR(25) NOT NULL
password VARCHAR(35) NOT NULL
email VARCHAR(50) NOT NULL
gender VARCHAR(6) NOT NULL
age CHAR(2)
day CHAR(2)
month CHAR(2)
year VARCHAR(4)
city VARCHAR(30) NOT NULL
state VARCHAR(20) NOT NULL
zip INT(10)
location (Country) VARCHAR(25) NOT NULL

Skills required:
PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.