Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: photopost_iponlinephotopost_iponline
An index has been added on date (Query took 0.0082 sec)
SQL-query: 
ALTER TABLE `photopost_iponline` ADD UNIQUE (
`date`
)
 [Edit] [Create PHP Code]


   Field  Type Collation Attributes Null Default Extra Action
   varchar(128) latin1_swedish_ci   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(64) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(16) 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 ipaddr
userid_2 UNIQUE Edit Drop userid
ipaddr_2 UNIQUE Edit Drop ipaddr
what_2 UNIQUE Edit Drop what
item_2 UNIQUE Edit Drop item
userid_4 UNIQUE Edit Drop userid
item_4 UNIQUE Edit Drop item
ipaddr_4 UNIQUE Edit Drop ipaddr
what_6 UNIQUE Edit Drop what
item_7 UNIQUE Edit Drop item
userid_7 UNIQUE Edit Drop userid
what_8 UNIQUE Edit Drop what
ipaddr_8 UNIQUE Edit Drop ipaddr
item_12 UNIQUE Edit Drop item
userid_11 UNIQUE Edit Drop userid
ipaddr_11 UNIQUE Edit Drop ipaddr
what_12 UNIQUE Edit Drop what
date_2 UNIQUE None  Edit Drop date
date_4 UNIQUE None  Edit Drop date
date_6 UNIQUE None  Edit Drop date
date_8 UNIQUE None  Edit Drop date
userid INDEX None  Edit Drop userid
ipaddr INDEX None  Edit Drop ipaddr
date INDEX None  Edit Drop date
what INDEX None  Edit Drop what
item INDEX None  Edit Drop item
what_5 INDEX None  Edit Drop what
date_3 INDEX None  Edit Drop date
userid_5 INDEX None  Edit Drop userid
item_6 INDEX None  Edit Drop item
ipaddr_6 INDEX None  Edit Drop ipaddr
date_5 INDEX None  Edit Drop date
item_8 INDEX None  Edit Drop item
what_9 INDEX None  Edit Drop what
userid_8 INDEX None  Edit Drop userid
ipaddr_9 INDEX None  Edit Drop ipaddr
item_10 INDEX None  Edit Drop item
date_7 INDEX None  Edit Drop date
userid_10 INDEX None  Edit Drop userid
what_11 INDEX None  Edit Drop what
userid_3 FULLTEXT None  Edit Drop userid
ipaddr_3 FULLTEXT None  Edit Drop ipaddr
what_3 FULLTEXT None  Edit Drop what
item_3 FULLTEXT None  Edit Drop item
what_4 FULLTEXT None  Edit Drop what
ipaddr_5 FULLTEXT None  Edit Drop ipaddr
item_5 FULLTEXT None  Edit Drop item
userid_6 FULLTEXT None  Edit Drop userid
what_7 FULLTEXT None  Edit Drop what
item_9 FULLTEXT None  Edit Drop item
ipaddr_7 FULLTEXT None  Edit Drop ipaddr
userid_9 FULLTEXT None  Edit Drop userid
what_10 FULLTEXT None  Edit Drop what
item_11 FULLTEXT None  Edit Drop item
ipaddr_10 FULLTEXT None  Edit Drop ipaddr
userid_12 FULLTEXT None  Edit Drop userid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 32 Bytes
Index 48,128 Bytes
Total 48,160 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1
Row length ø 32
Row size  ø 48,160 Bytes
Creation Apr 19, 2018 at 09:59 AM
Last update Apr 19, 2018 at 09:59 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: