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


   Field  Type Collation Attributes Null Default Extra Action
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   int(15)     No    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   mediumtext latin1_swedish_ci   Yes  NULL    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_3 UNIQUE Edit Drop id
timestamp_2 UNIQUE Edit Drop timestamp
id_4 UNIQUE Edit Drop id
timestamp_4 UNIQUE Edit Drop timestamp
id_6 UNIQUE Edit Drop id
timestamp_6 UNIQUE Edit Drop timestamp
id_8 UNIQUE Edit Drop id
id_11 UNIQUE Edit Drop id
timestamp_9 UNIQUE Edit Drop timestamp
timestamp_10 UNIQUE Edit Drop timestamp
id_12 UNIQUE Edit Drop id
id INDEX None  Edit Drop id
id_2 INDEX None  Edit Drop id
timestamp INDEX None  Edit Drop timestamp
timestamp_3 INDEX None  Edit Drop timestamp
id_5 INDEX None  Edit Drop id
timestamp_5 INDEX None  Edit Drop timestamp
id_7 INDEX None  Edit Drop id
timestamp_7 INDEX None  Edit Drop timestamp
id_9 INDEX None  Edit Drop id
id_10 INDEX None  Edit Drop id
timestamp_8 INDEX None  Edit Drop timestamp
statscache FULLTEXT None  Edit Drop statscache
recentcache FULLTEXT None  Edit Drop recentcache
popularcache FULLTEXT None  Edit Drop popularcache
randomcache FULLTEXT None  Edit Drop randomcache
calcache FULLTEXT None  Edit Drop calcache
catcache FULLTEXT None  Edit Drop catcache
catprops FULLTEXT None  Edit Drop catprops
calcache_2 FULLTEXT None  Edit Drop calcache
catprops_2 FULLTEXT None  Edit Drop catprops
recentcache_2 FULLTEXT None  Edit Drop recentcache
popularcache_2 FULLTEXT None  Edit Drop popularcache
catcache_2 FULLTEXT None  Edit Drop catcache
randomcache_2 FULLTEXT None  Edit Drop randomcache
statscache_2 FULLTEXT None  Edit Drop statscache
catprops_3 FULLTEXT None  Edit Drop catprops
calcache_3 FULLTEXT None  Edit Drop calcache
recentcache_3 FULLTEXT None  Edit Drop recentcache
randomcache_3 FULLTEXT None  Edit Drop randomcache
catcache_3 FULLTEXT None  Edit Drop catcache
popularcache_3 FULLTEXT None  Edit Drop popularcache
statscache_3 FULLTEXT None  Edit Drop statscache
catprops_4 FULLTEXT None  Edit Drop catprops
recentcache_4 FULLTEXT None  Edit Drop recentcache
randomcache_4 FULLTEXT None  Edit Drop randomcache
calcache_4 FULLTEXT None  Edit Drop calcache
statscache_4 FULLTEXT None  Edit Drop statscache
recentcache_5 FULLTEXT None  Edit Drop recentcache
popularcache_4 FULLTEXT None  Edit Drop popularcache
randomcache_5 FULLTEXT None  Edit Drop randomcache
calcache_5 FULLTEXT None  Edit Drop calcache
catcache_4 FULLTEXT None  Edit Drop catcache
catprops_5 FULLTEXT None  Edit Drop catprops
popularcache_5 FULLTEXT None  Edit Drop popularcache
catcache_5 FULLTEXT None  Edit Drop catcache
Create an index on  columns  
 
Space usage: 
Type Usage
Data 6,552 Bytes
Index 56,320 Bytes
Total 62,872 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1
Row length ø 6,552
Row size  ø 62,872 Bytes
Creation Apr 26, 2018 at 11:05 AM
Last update Apr 26, 2018 at 11:05 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: