Closed

Members Database

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: PHP

See more: php script null, not legitimate, mysql city state database, location testing, int i, country state and city database mysql, correct password, correct email address, city year, stress testing, password zip, null, int, database script, database email, database admin, city state, city state country php, zip city state, stress questions, location zip code, location sample code, city country state database php, random data, questions stress

About the Employer:
( 0 reviews ) Bellevuew, United States

Project ID: #132856