Encerrado

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

Habilidades: PHP

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

Acerca do Empregador:
( 0 comentários ) Bellevuew, United States

ID do Projeto: #132856