Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_usersbak_users
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec)
SQL-query: 
SELECT *
FROM `bak_users`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   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
registerDate_3 UNIQUE Edit Drop registerDate
password_5 UNIQUE Edit Drop password
lastvisitDate_4 UNIQUE Edit Drop lastvisitDate
id_4 UNIQUE Edit Drop id
gid_4 UNIQUE Edit Drop gid
email_6 UNIQUE Edit Drop email
block_4 UNIQUE Edit Drop block
name_6 UNIQUE Edit Drop name
usertype_7 UNIQUE Edit Drop usertype
activation_6 UNIQUE Edit Drop activation
sendEmail_2 UNIQUE None  Edit Drop sendEmail
sendEmail_3 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
lastvisitDate_3 INDEX None  Edit Drop lastvisitDate
password_4 INDEX None  Edit Drop password
username_5 INDEX None  Edit Drop username
usertype_6 INDEX None  Edit Drop usertype
id_3 INDEX None  Edit Drop id
name_5 INDEX None  Edit Drop name
gid_3 INDEX None  Edit Drop gid
sendEmail_4 INDEX None  Edit Drop sendEmail
block_3 INDEX None  Edit Drop block
email_5 INDEX None  Edit Drop email
activation_4 INDEX None  Edit Drop activation
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_4 FULLTEXT None  Edit Drop name
params_2 FULLTEXT None  Edit Drop params
activation_5 FULLTEXT None  Edit Drop activation
password_6 FULLTEXT None  Edit Drop password
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 4,096 Bytes
Total 4,096 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 0
Next Autoindex 1
Creation Oct 23, 2017 at 12:35 AM
Last update Mar 31, 2018 at 07:29 AM
Last check Apr 02, 2018 at 07:54 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: