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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(150) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(25) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     Yes    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

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

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop id
id_2 UNIQUE Edit Drop id
name_2 UNIQUE Edit Drop name
username_3 UNIQUE Edit Drop username
email_3 UNIQUE Edit Drop email
password_2 UNIQUE Edit Drop password
usertype_3 UNIQUE Edit Drop usertype
block_2 UNIQUE Edit Drop block
gid_2 UNIQUE Edit Drop gid
registerDate_2 UNIQUE Edit Drop registerDate
lastvisitDate_2 UNIQUE Edit Drop lastvisitDate
activation_2 UNIQUE Edit Drop activation
activation_4 UNIQUE Edit Drop activation
name_4 UNIQUE Edit Drop name
id_3 UNIQUE Edit Drop id
password_4 UNIQUE Edit Drop password
block_3 UNIQUE Edit Drop block
email_5 UNIQUE Edit Drop email
username_7 UNIQUE Edit Drop username
lastvisitDate_3 UNIQUE Edit Drop lastvisitDate
usertype_6 UNIQUE Edit Drop usertype
sendEmail_2 UNIQUE None  Edit Drop sendEmail
usertype INDEX None  Edit Drop usertype
idx_name INDEX None  Edit Drop name
gid_block INDEX None  Edit Drop gid
block
username INDEX None  Edit Drop username
email INDEX None  Edit Drop email
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
username_2 INDEX None  Edit Drop username
email_2 INDEX None  Edit Drop email
password INDEX None  Edit Drop password
usertype_2 INDEX None  Edit Drop usertype
block INDEX None  Edit Drop block
sendEmail INDEX None  Edit Drop sendEmail
gid INDEX None  Edit Drop gid
registerDate INDEX None  Edit Drop registerDate
lastvisitDate INDEX None  Edit Drop lastvisitDate
activation INDEX None  Edit Drop activation
activation_5 INDEX None  Edit Drop activation
username_5 INDEX None  Edit Drop username
email_6 INDEX None  Edit Drop email
id_4 INDEX None  Edit Drop id
sendEmail_3 INDEX None  Edit Drop sendEmail
block_4 INDEX None  Edit Drop block
password_6 INDEX None  Edit Drop password
gid_3 INDEX None  Edit Drop gid
registerDate_3 INDEX None  Edit Drop registerDate
usertype_7 INDEX None  Edit Drop usertype
name_6 INDEX None  Edit Drop name
lastvisitDate_4 INDEX None  Edit Drop lastvisitDate
name_3 FULLTEXT None  Edit Drop name
username_4 FULLTEXT None  Edit Drop username
email_4 FULLTEXT None  Edit Drop email
password_3 FULLTEXT None  Edit Drop password
usertype_4 FULLTEXT None  Edit Drop usertype
activation_3 FULLTEXT None  Edit Drop activation
params FULLTEXT None  Edit Drop params
usertype_5 FULLTEXT None  Edit Drop usertype
name_5 FULLTEXT None  Edit Drop name
password_5 FULLTEXT None  Edit Drop password
username_6 FULLTEXT None  Edit Drop username
email_7 FULLTEXT None  Edit Drop email
activation_6 FULLTEXT None  Edit Drop activation
Create an index on  columns  
 
Space usage: 
Type Usage
Data 156 Bytes
Index 4,096 Bytes
Total 4,252 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 1
Row length ø 156
Row size  ø 4,252 Bytes
Next Autoindex 63
Creation Oct 23, 2017 at 07:51 AM
Last update Mar 24, 2018 at 12:38 AM
Last check Mar 24, 2018 at 12:38 AM

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: