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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(15)     No    Change Drop Primary Index Unique Fulltext
   float(12,2)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   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
   int(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(32) latin1_swedish_ci   Yes    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
username_2 UNIQUE Edit Drop username
userid_2 UNIQUE Edit Drop userid
date_2 UNIQUE Edit Drop date
photo_3 UNIQUE Edit Drop photo
cat_3 UNIQUE Edit Drop cat
approved_2 UNIQUE Edit Drop approved
date_3 UNIQUE Edit Drop date
username_5 UNIQUE Edit Drop username
userid_3 UNIQUE Edit Drop userid
cat_4 UNIQUE Edit Drop cat
approved_3 UNIQUE Edit Drop approved
photo_4 UNIQUE Edit Drop photo
id_3 UNIQUE Edit Drop id
id_5 UNIQUE Edit Drop id
approved_6 UNIQUE Edit Drop approved
date_5 UNIQUE Edit Drop date
photo_6 UNIQUE Edit Drop photo
userid_6 UNIQUE Edit Drop userid
cat_7 UNIQUE Edit Drop cat
username_9 UNIQUE Edit Drop username
rating_2 UNIQUE None  Edit Drop rating
ipaddress_2 UNIQUE None  Edit Drop ipaddress
rating_3 UNIQUE None  Edit Drop rating
ipaddress_5 UNIQUE None  Edit Drop ipaddress
rating_5 UNIQUE None  Edit Drop rating
ipaddress_8 UNIQUE None  Edit Drop ipaddress
photo INDEX None  Edit Drop photo
cat INDEX None  Edit Drop cat
id INDEX None  Edit Drop id
username INDEX None  Edit Drop username
userid INDEX None  Edit Drop userid
date INDEX None  Edit Drop date
rating INDEX None  Edit Drop rating
photo_2 INDEX None  Edit Drop photo
cat_2 INDEX None  Edit Drop cat
approved INDEX None  Edit Drop approved
ipaddress INDEX None  Edit Drop ipaddress
rating_4 INDEX None  Edit Drop rating
username_6 INDEX None  Edit Drop username
date_4 INDEX None  Edit Drop date
ipaddress_4 INDEX None  Edit Drop ipaddress
cat_5 INDEX None  Edit Drop cat
photo_5 INDEX None  Edit Drop photo
userid_4 INDEX None  Edit Drop userid
id_4 INDEX None  Edit Drop id
approved_4 INDEX None  Edit Drop approved
approved_5 INDEX None  Edit Drop approved
userid_5 INDEX None  Edit Drop userid
ipaddress_7 INDEX None  Edit Drop ipaddress
date_6 INDEX None  Edit Drop date
cat_6 INDEX None  Edit Drop cat
username_8 INDEX None  Edit Drop username
photo_7 INDEX None  Edit Drop photo
rating_6 INDEX None  Edit Drop rating
id_6 INDEX None  Edit Drop id
username_3 FULLTEXT None  Edit Drop username
comment FULLTEXT None  Edit Drop comment
ipaddress_3 FULLTEXT None  Edit Drop ipaddress
username_4 FULLTEXT None  Edit Drop username
ipaddress_6 FULLTEXT None  Edit Drop ipaddress
comment_2 FULLTEXT None  Edit Drop comment
username_7 FULLTEXT None  Edit Drop username
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 Jan 19, 2018 at 10:37 PM
Last update Jan 19, 2018 at 10:37 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: