Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: poll_userpoll_user
An index has been added on session (Query took 0.0114 sec)
SQL-query: 
ALTER TABLE `poll_user` ADD FULLTEXT (
`session`
)
 [Edit] [Create PHP Code]


   Field  Type Collation Attributes Null Default Extra Action
   smallint(5)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(30) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   No      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    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop user_id
user_id_2 UNIQUE Edit Drop user_id
username_2 UNIQUE Edit Drop username
userpass_2 UNIQUE Edit Drop userpass
session_2 UNIQUE Edit Drop session
last_visit_2 UNIQUE Edit Drop last_visit
last_visit_4 UNIQUE Edit Drop last_visit
username_4 UNIQUE Edit Drop username
session_4 UNIQUE Edit Drop session
user_id_3 UNIQUE Edit Drop user_id
userpass_6 UNIQUE Edit Drop userpass
last_visit_5 UNIQUE Edit Drop last_visit
session_7 UNIQUE Edit Drop session
user_id_6 UNIQUE Edit Drop user_id
username_9 UNIQUE Edit Drop username
last_visit_7 UNIQUE Edit Drop last_visit
userpass_9 UNIQUE Edit Drop userpass
user_id_7 UNIQUE Edit Drop user_id
username_11 UNIQUE Edit Drop username
session_11 UNIQUE Edit Drop session
last_visit_9 UNIQUE Edit Drop last_visit
userpass_12 UNIQUE Edit Drop userpass
user_id INDEX None  Edit Drop user_id
username INDEX None  Edit Drop username
userpass INDEX None  Edit Drop userpass
session INDEX None  Edit Drop session
last_visit INDEX None  Edit Drop last_visit
last_visit_3 INDEX None  Edit Drop last_visit
userpass_4 INDEX None  Edit Drop userpass
user_id_4 INDEX None  Edit Drop user_id
session_5 INDEX None  Edit Drop session
username_6 INDEX None  Edit Drop username
user_id_5 INDEX None  Edit Drop user_id
username_7 INDEX None  Edit Drop username
userpass_7 INDEX None  Edit Drop userpass
last_visit_6 INDEX None  Edit Drop last_visit
session_8 INDEX None  Edit Drop session
session_10 INDEX None  Edit Drop session
username_12 INDEX None  Edit Drop username
user_id_8 INDEX None  Edit Drop user_id
userpass_10 INDEX None  Edit Drop userpass
last_visit_8 INDEX None  Edit Drop last_visit
username_3 FULLTEXT None  Edit Drop username
userpass_3 FULLTEXT None  Edit Drop userpass
session_3 FULLTEXT None  Edit Drop session
username_5 FULLTEXT None  Edit Drop username
userpass_5 FULLTEXT None  Edit Drop userpass
session_6 FULLTEXT None  Edit Drop session
username_8 FULLTEXT None  Edit Drop username
userpass_8 FULLTEXT None  Edit Drop userpass
session_9 FULLTEXT None  Edit Drop session
username_10 FULLTEXT None  Edit Drop username
userpass_11 FULLTEXT None  Edit Drop userpass
session_12 FULLTEXT None  Edit Drop session
Create an index on  columns  
 
Space usage: 
Type Usage
Data 80 Bytes
Index 58,368 Bytes
Total 58,448 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1
Row length ø 80
Row size  ø 58,448 Bytes
Next Autoindex 2
Creation Apr 20, 2018 at 04:36 AM
Last update Apr 20, 2018 at 04:36 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: