Server: mysql.puroparty.com | Database: puroparty | Table: email_users |
Field | Type | Null | Default |
---|---|---|---|
userid | int(11) | No | |
username | varchar(255) | Yes | NULL |
password | varchar(32) | Yes | NULL |
admintype | char(1) | Yes | NULL |
listadmintype | char(1) | Yes | NULL |
templateadmintype | char(1) | Yes | NULL |
segmentadmintype | char(1) | Yes | NULL |
status | char(1) | Yes | 0 |
fullname | varchar(255) | Yes | NULL |
emailaddress | varchar(100) | Yes | NULL |
settings | text | Yes | NULL |
editownsettings | char(1) | Yes | 1 |
usertimezone | varchar(10) | Yes | NULL |
textfooter | mediumtext | Yes | NULL |
htmlfooter | mediumtext | Yes | NULL |
maxlists | int(11) | Yes | 0 |
perhour | int(11) | Yes | 0 |
permonth | int(11) | Yes | 0 |
unlimitedmaxemails | char(1) | Yes | 0 |
maxemails | int(11) | Yes | 0 |
infotips | char(1) | Yes | 1 |
smtpserver | varchar(255) | Yes | NULL |
smtpusername | varchar(255) | Yes | NULL |
smtppassword | varchar(255) | Yes | NULL |
smtpport | int(11) | Yes | 0 |
createdate | int(11) | Yes | 0 |
lastloggedin | int(11) | Yes | 0 |
forgotpasscode | varchar(32) | Yes | |
usewysiwyg | char(1) | Yes | 1 |
xmlapi | char(1) | Yes | 0 |
xmltoken | varchar(40) | Yes | NULL |
gettingstarted | int(11) | No | 0 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 2 | userid | |
userid_2 | UNIQUE | 2 | userid | |
userid_3 | UNIQUE | 2 | userid | |
username_2 | UNIQUE | 2 | username | |
password_2 | UNIQUE | 2 | password | |
admintype_2 | UNIQUE | 2 | admintype | |
listadmintype_2 | UNIQUE | 2 | listadmintype | |
segmentadmintype_2 | UNIQUE | 2 | segmentadmintype | |
emailaddress_2 | UNIQUE | 2 | emailaddress | |
usertimezone_2 | UNIQUE | 2 | usertimezone | |
createdate_2 | UNIQUE | 2 | createdate | |
lastloggedin_2 | UNIQUE | 2 | lastloggedin | |
admintype_3 | UNIQUE | 2 | admintype | |
listadmintype_4 | UNIQUE | 2 | listadmintype | |
segmentadmintype_3 | UNIQUE | 2 | segmentadmintype | |
lastloggedin_3 | UNIQUE | 2 | lastloggedin | |
usertimezone_4 | UNIQUE | 2 | usertimezone | |
username_4 | UNIQUE | 2 | username | |
password_3 | UNIQUE | 2 | password | |
email_users_logincheck_idx | INDEX | 2 | username | |
password | ||||
userid | INDEX | 2 | userid | |
username | INDEX | 2 | username | |
password | INDEX | 2 | password | |
admintype | INDEX | 2 | admintype | |
listadmintype | INDEX | 2 | listadmintype | |
templateadmintype | INDEX | 2 | templateadmintype | |
segmentadmintype | INDEX | 2 | segmentadmintype | |
status | INDEX | 2 | status | |
fullname | INDEX | 2 | fullname | |
emailaddress | INDEX | 2 | emailaddress | |
editownsettings | INDEX | 2 | editownsettings | |
usertimezone | INDEX | 2 | usertimezone | |
maxlists | INDEX | 2 | maxlists | |
perhour | INDEX | 2 | perhour | |
permonth | INDEX | 2 | permonth | |
unlimitedmaxemails | INDEX | 2 | unlimitedmaxemails | |
maxemails | INDEX | 2 | maxemails | |
infotips | INDEX | 2 | infotips | |
smtpserver | INDEX | 2 | smtpserver | |
smtpusername | INDEX | 2 | smtpusername | |
smtppassword | INDEX | 2 | smtppassword | |
smtpport | INDEX | 2 | smtpport | |
createdate | INDEX | 2 | createdate | |
lastloggedin | INDEX | 2 | lastloggedin | |
forgotpasscode | INDEX | 2 | forgotpasscode | |
usewysiwyg | INDEX | 2 | usewysiwyg | |
xmlapi | INDEX | 2 | xmlapi | |
xmltoken | INDEX | 2 | xmltoken | |
gettingstarted | INDEX | 2 | gettingstarted | |
listadmintype_3 | INDEX | 2 | listadmintype | |
usertimezone_3 | INDEX | 2 | usertimezone | |
gettingstarted_2 | INDEX | 2 | gettingstarted | |
smtpport_2 | INDEX | 2 | smtpport | |
maxlists_2 | INDEX | 2 | maxlists | |
usewysiwyg_2 | INDEX | 2 | usewysiwyg | |
xmltoken_2 | INDEX | 2 | xmltoken | |
lastloggedin_4 | INDEX | 2 | lastloggedin | |
fullname_2 | INDEX | 2 | fullname | |
username_3 | INDEX | 2 | username | |
smtpusername_2 | INDEX | 2 | smtpusername | |
templateadmintype_2 | INDEX | 2 | templateadmintype | |
editownsettings_2 | INDEX | 2 | editownsettings | |
admintype_4 | INDEX | 2 | admintype | |
maxemails_2 | INDEX | 2 | maxemails |
Space usage :
|
Row Statistic :
|