Members Database

Imefungwa Ilichapishwa Mar 18, 2007 Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

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

PHP

Kitambulisho cha Mradi: #132856

Kuhusu mradi

7 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%