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

   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_7 UNIQUE Edit Drop log_id
log_id_9 UNIQUE Edit Drop log_id
timestamp_10 UNIQUE Edit Drop timestamp
log_id_12 UNIQUE Edit Drop log_id
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
host_8 INDEX None  Edit Drop host
log_id_8 INDEX None  Edit Drop log_id
poll_id_5 INDEX None  Edit Drop poll_id
option_id_5 INDEX None  Edit Drop option_id
timestamp_9 INDEX None  Edit Drop timestamp
ip_addr_9 INDEX None  Edit Drop ip_addr
host_9 INDEX None  Edit Drop host
agent_10 INDEX None  Edit Drop agent
log_id_10 INDEX None  Edit Drop log_id
log_id_11 INDEX None  Edit Drop log_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
ip_addr_10 FULLTEXT None  Edit Drop ip_addr
host_10 FULLTEXT None  Edit Drop host
agent_11 FULLTEXT None  Edit Drop agent
Create an index on  columns  
 
Space usage: 
Type Usage
Data 440 Bytes
Index 3,072 Bytes
Total 3,512 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 2
Row length ø 220
Row size  ø 1,756 Bytes
Next Autoindex 3
Creation May 19, 2018 at 09:20 AM
Last update May 19, 2018 at 09:20 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: