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

InnoDB free: 775168 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(32) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   varchar(10) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(32) utf8_general_ci   Yes      Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   varchar(40) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Relation viewRelation view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop userid
userid_2 UNIQUE Edit Drop userid
userid_3 UNIQUE Edit Drop userid
username_2 UNIQUE Edit Drop username
password_2 UNIQUE Edit Drop password
admintype_2 UNIQUE Edit Drop admintype
listadmintype_2 UNIQUE Edit Drop listadmintype
segmentadmintype_2 UNIQUE Edit Drop segmentadmintype
emailaddress_2 UNIQUE Edit Drop emailaddress
usertimezone_2 UNIQUE Edit Drop usertimezone
createdate_2 UNIQUE Edit Drop createdate
lastloggedin_2 UNIQUE Edit Drop lastloggedin
admintype_3 UNIQUE Edit Drop admintype
listadmintype_4 UNIQUE Edit Drop listadmintype
segmentadmintype_3 UNIQUE Edit Drop segmentadmintype
lastloggedin_3 UNIQUE Edit Drop lastloggedin
usertimezone_4 UNIQUE Edit Drop usertimezone
username_4 UNIQUE Edit Drop username
password_3 UNIQUE Edit Drop password
email_users_logincheck_idx INDEX Edit Drop username
password
userid INDEX Edit Drop userid
username INDEX Edit Drop username
password INDEX Edit Drop password
admintype INDEX Edit Drop admintype
listadmintype INDEX Edit Drop listadmintype
templateadmintype INDEX Edit Drop templateadmintype
segmentadmintype INDEX Edit Drop segmentadmintype
status INDEX Edit Drop status
fullname INDEX Edit Drop fullname
emailaddress INDEX Edit Drop emailaddress
editownsettings INDEX Edit Drop editownsettings
usertimezone INDEX Edit Drop usertimezone
maxlists INDEX Edit Drop maxlists
perhour INDEX Edit Drop perhour
permonth INDEX Edit Drop permonth
unlimitedmaxemails INDEX Edit Drop unlimitedmaxemails
maxemails INDEX Edit Drop maxemails
infotips INDEX Edit Drop infotips
smtpserver INDEX Edit Drop smtpserver
smtpusername INDEX Edit Drop smtpusername
smtppassword INDEX Edit Drop smtppassword
smtpport INDEX Edit Drop smtpport
createdate INDEX Edit Drop createdate
lastloggedin INDEX Edit Drop lastloggedin
forgotpasscode INDEX Edit Drop forgotpasscode
usewysiwyg INDEX Edit Drop usewysiwyg
xmlapi INDEX Edit Drop xmlapi
xmltoken INDEX Edit Drop xmltoken
gettingstarted INDEX Edit Drop gettingstarted
listadmintype_3 INDEX Edit Drop listadmintype
usertimezone_3 INDEX Edit Drop usertimezone
gettingstarted_2 INDEX Edit Drop gettingstarted
smtpport_2 INDEX Edit Drop smtpport
maxlists_2 INDEX Edit Drop maxlists
usewysiwyg_2 INDEX Edit Drop usewysiwyg
xmltoken_2 INDEX Edit Drop xmltoken
lastloggedin_4 INDEX Edit Drop lastloggedin
fullname_2 INDEX Edit Drop fullname
username_3 INDEX Edit Drop username
smtpusername_2 INDEX Edit Drop smtpusername
templateadmintype_2 INDEX Edit Drop templateadmintype
editownsettings_2 INDEX Edit Drop editownsettings
admintype_4 INDEX Edit Drop admintype
maxemails_2 INDEX Edit Drop maxemails
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 3
Creation Jun 13, 2018 at 06:59 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: