Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_usersemail_users

email_users

Table comments : InnoDB free: 780288 kB

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 
fullname  varchar(255) Yes  NULL 
emailaddress  varchar(100) Yes  NULL 
settings  text Yes  NULL 
editownsettings  char(1) Yes 
usertimezone  varchar(10) Yes  NULL 
textfooter  mediumtext Yes  NULL 
htmlfooter  mediumtext Yes  NULL 
maxlists  int(11) Yes 
perhour  int(11) Yes 
permonth  int(11) Yes 
unlimitedmaxemails  char(1) Yes 
maxemails  int(11) Yes 
infotips  char(1) Yes 
smtpserver  varchar(255) Yes  NULL 
smtpusername  varchar(255) Yes  NULL 
smtppassword  varchar(255) Yes  NULL 
smtpport  int(11) Yes 
createdate  int(11) Yes 
lastloggedin  int(11) Yes 
forgotpasscode  varchar(32) Yes   
usewysiwyg  char(1) Yes 
xmlapi  char(1) Yes 
xmltoken  varchar(40) Yes  NULL 
gettingstarted  int(11) No 


 Indexes :
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 :
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
   Row Statistic :
Statements Value
Format dynamic
Rows 2
Row length ø 8,192
Row size  ø 524,288 Bytes
Next Autoindex 3
Creation Mar 10, 2018 at 02:30 PM