Members Database
$30-100 USD
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
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
Kitambulisho cha Mradi: #132856