Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: poll_logpoll_log
An index has been added on poll_id (Query took 0.0073 sec)
SQL-query: 
ALTER TABLE `poll_log` ADD INDEX ( `poll_id` )
 [Edit] [Create PHP Code]


   Field  Type Collation Attributes Null Default Extra Action
   int(11)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(15) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_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 log_id
log_id_2 UNIQUE Edit Drop log_id
timestamp_2 UNIQUE Edit Drop timestamp
timestamp_4 UNIQUE Edit Drop timestamp
log_id_4 UNIQUE Edit Drop log_id
timestamp_5 UNIQUE Edit Drop timestamp
log_id_5 UNIQUE Edit Drop log_id
timestamp_7 UNIQUE Edit Drop timestamp
log_id INDEX None  Edit Drop log_id
poll_id INDEX None  Edit Drop poll_id
option_id INDEX None  Edit Drop option_id
timestamp INDEX None  Edit Drop timestamp
ip_addr INDEX None  Edit Drop ip_addr
host INDEX None  Edit Drop host
agent INDEX None  Edit Drop agent
timestamp_3 INDEX None  Edit Drop timestamp
agent_4 INDEX None  Edit Drop agent
option_id_2 INDEX None  Edit Drop option_id
poll_id_2 INDEX None  Edit Drop poll_id
host_4 INDEX None  Edit Drop host
ip_addr_4 INDEX None  Edit Drop ip_addr
log_id_3 INDEX None  Edit Drop log_id
agent_5 INDEX None  Edit Drop agent
agent_6 INDEX None  Edit Drop agent
option_id_3 INDEX None  Edit Drop option_id
timestamp_6 INDEX None  Edit Drop timestamp
host_6 INDEX None  Edit Drop host
poll_id_3 INDEX None  Edit Drop poll_id
log_id_6 INDEX None  Edit Drop log_id
ip_addr_6 INDEX None  Edit Drop ip_addr
agent_8 INDEX None  Edit Drop agent
option_id_4 INDEX None  Edit Drop option_id
timestamp_8 INDEX None  Edit Drop timestamp
ip_addr_8 INDEX None  Edit Drop ip_addr
poll_id_4 INDEX None  Edit Drop poll_id
ip_addr_2 FULLTEXT None  Edit Drop ip_addr
host_2 FULLTEXT None  Edit Drop host
agent_2 FULLTEXT None  Edit Drop agent
ip_addr_3 FULLTEXT None  Edit Drop ip_addr
agent_3 FULLTEXT None  Edit Drop agent
host_3 FULLTEXT None  Edit Drop host
ip_addr_5 FULLTEXT None  Edit Drop ip_addr
agent_7 FULLTEXT None  Edit Drop agent
host_5 FULLTEXT None  Edit Drop host
ip_addr_7 FULLTEXT None  Edit Drop ip_addr
agent_9 FULLTEXT None  Edit Drop agent
host_7 FULLTEXT None  Edit Drop host
Create an index on  columns  
 
Space usage: 
Type Usage
Data 440 Bytes
Index 55,296 Bytes
Total 55,736 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 2
Row length ø 220
Row size  ø 27,868 Bytes
Next Autoindex 3
Creation Apr 20, 2018 at 08:21 PM
Last update Apr 20, 2018 at 08:21 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: