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

   Field  Type Collation Attributes Null Default Extra Action
   int(10)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(25)     No    Change Drop Primary Index Unique Fulltext
   varchar(75) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(4) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(10)     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
userid_2 UNIQUE Edit Drop userid
ipaddr_2 UNIQUE Edit Drop ipaddr
type_2 UNIQUE Edit Drop type
photo_2 UNIQUE Edit Drop photo
id_3 UNIQUE Edit Drop id
photo_3 UNIQUE Edit Drop photo
type_5 UNIQUE Edit Drop type
ipaddr_6 UNIQUE Edit Drop ipaddr
userid_4 UNIQUE Edit Drop userid
photo_5 UNIQUE Edit Drop photo
type_7 UNIQUE Edit Drop type
id_6 UNIQUE Edit Drop id
ipaddr_9 UNIQUE Edit Drop ipaddr
userid_6 UNIQUE Edit Drop userid
photo_7 UNIQUE Edit Drop photo
type_11 UNIQUE Edit Drop type
id_8 UNIQUE Edit Drop id
ipaddr_12 UNIQUE Edit Drop ipaddr
id_10 UNIQUE Edit Drop id
userid_9 UNIQUE Edit Drop userid
ipaddr_14 UNIQUE Edit Drop ipaddr
date_2 UNIQUE None  Edit Drop date
date_4 UNIQUE None  Edit Drop date
date_6 UNIQUE None  Edit Drop date
date_9 UNIQUE None  Edit Drop date
id INDEX None  Edit Drop id
userid INDEX None  Edit Drop userid
ipaddr INDEX None  Edit Drop ipaddr
date INDEX None  Edit Drop date
type INDEX None  Edit Drop type
photo INDEX None  Edit Drop photo
ipaddr_4 INDEX None  Edit Drop ipaddr
date_3 INDEX None  Edit Drop date
userid_3 INDEX None  Edit Drop userid
id_4 INDEX None  Edit Drop id
type_6 INDEX None  Edit Drop type
photo_4 INDEX None  Edit Drop photo
ipaddr_7 INDEX None  Edit Drop ipaddr
date_5 INDEX None  Edit Drop date
type_9 INDEX None  Edit Drop type
userid_5 INDEX None  Edit Drop userid
id_5 INDEX None  Edit Drop id
photo_6 INDEX None  Edit Drop photo
date_7 INDEX None  Edit Drop date
ipaddr_11 INDEX None  Edit Drop ipaddr
type_12 INDEX None  Edit Drop type
userid_7 INDEX None  Edit Drop userid
id_7 INDEX None  Edit Drop id
photo_8 INDEX None  Edit Drop photo
id_9 INDEX None  Edit Drop id
userid_8 INDEX None  Edit Drop userid
ipaddr_13 INDEX None  Edit Drop ipaddr
date_8 INDEX None  Edit Drop date
ipaddr_3 FULLTEXT None  Edit Drop ipaddr
type_3 FULLTEXT None  Edit Drop type
ipaddr_5 FULLTEXT None  Edit Drop ipaddr
type_4 FULLTEXT None  Edit Drop type
ipaddr_8 FULLTEXT None  Edit Drop ipaddr
type_8 FULLTEXT None  Edit Drop type
type_10 FULLTEXT None  Edit Drop type
ipaddr_10 FULLTEXT None  Edit Drop ipaddr
ipaddr_15 FULLTEXT None  Edit Drop ipaddr
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 3,072 Bytes
Total 3,072 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 0
Next Autoindex 1
Creation Apr 21, 2018 at 04:53 AM
Last update Apr 21, 2018 at 04:53 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: