Here you go Rudy.
CREATE TABLE users
(
uID
int(8) NOT NULL AUTO_INCREMENT,
IPaddress
varchar(15) DEFAULT NULL,
registerDate
datetime DEFAULT NULL,
confirmed
char(3) DEFAULT ‘No’,
confirmProds
int(2) DEFAULT ‘0’,
lastConfirmProd
date DEFAULT NULL,
postProds
int(2) DEFAULT ‘0’,
lastPostProd
date DEFAULT NULL,
lazyProds
int(2) DEFAULT ‘0’,
lastLazyProd
date DEFAULT NULL,
approved
char(3) DEFAULT ‘No’,
visited
int(4) DEFAULT ‘0’,
logins
int(4) DEFAULT NULL,
last
datetime DEFAULT NULL,
lastLogin
datetime DEFAULT NULL,
lastTemp
datetime DEFAULT NULL,
lastMatch
datetime DEFAULT NULL,
searchProds
int(2) DEFAULT ‘0’,
lastSearchProd
date DEFAULT NULL,
companyName
varchar(50) DEFAULT NULL,
companyURL
varchar(50) DEFAULT NULL,
firstname
varchar(30) DEFAULT NULL,
spouseName
varchar(30) DEFAULT NULL,
lastname
varchar(30) DEFAULT NULL,
city
varchar(30) DEFAULT NULL,
state
varchar(30) DEFAULT NULL,
zip
varchar(10) DEFAULT NULL,
country
varchar(50) DEFAULT NULL,
phone
varchar(15) DEFAULT NULL,
password
varchar(30) DEFAULT NULL,
reminders
int(2) DEFAULT ‘0’,
email
varchar(50) DEFAULT NULL,
bouncing
varchar(3) NOT NULL DEFAULT ‘No’,
sendMatches
varchar(3) NOT NULL DEFAULT ‘Yes’,
searchesStopped
int(3) NOT NULL DEFAULT ‘0’,
grandFathered
varchar(3) DEFAULT ‘No’,
contact
char(3) DEFAULT ‘No’,
contacted
int(4) DEFAULT ‘0’,
skills
varchar(50) DEFAULT NULL,
googleTopicID
int(3) DEFAULT NULL,
interests
int(2) DEFAULT NULL,
member
varchar(11) DEFAULT NULL,
memberType
varchar(11) DEFAULT NULL,
membernumber
int(8) DEFAULT NULL,
ourDownline
varchar(3) NOT NULL DEFAULT ‘No’,
enrollDate
date DEFAULT NULL,
referSource
varchar(20) DEFAULT NULL,
referURL
mediumtext,
guide
int(8) DEFAULT NULL,
sponsorID
int(8) DEFAULT NULL,
guideUpdated
datetime DEFAULT NULL,
sponsorUpdated
datetime DEFAULT NULL,
totalReferrals
int(4) DEFAULT ‘0’,
totalSearches
int(4) DEFAULT ‘0’,
totalQuestions
int(4) DEFAULT ‘0’,
subscription
varchar(7) DEFAULT NULL,
wantSilver
varchar(3) DEFAULT ‘No’,
timeStamp
timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (uID
)
) ENGINE=MyISAM AUTO_INCREMENT=31754 DEFAULT CHARSET=latin1