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

   Field  Type Collation Attributes Null Default Extra Action
   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
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 user_id
forum_id
message_id
message_id_2 UNIQUE Edit Drop message_id
message_id_4 UNIQUE Edit Drop message_id
message_id_5 UNIQUE Edit Drop message_id
message_id_7 UNIQUE Edit Drop message_id
message_id_10 UNIQUE Edit Drop message_id
user_id INDEX None  Edit Drop user_id
forum_id INDEX None  Edit Drop forum_id
message_id INDEX None  Edit Drop message_id
user_id_2 INDEX None  Edit Drop user_id
message_id_3 INDEX None  Edit Drop message_id
forum_id_2 INDEX None  Edit Drop forum_id
user_id_3 INDEX None  Edit Drop user_id
message_id_6 INDEX None  Edit Drop message_id
forum_id_3 INDEX None  Edit Drop forum_id
user_id_4 INDEX None  Edit Drop user_id
message_id_8 INDEX None  Edit Drop message_id
user_id_5 INDEX None  Edit Drop user_id
forum_id_4 INDEX None  Edit Drop forum_id
user_id_6 INDEX None  Edit Drop user_id
forum_id_5 INDEX None  Edit Drop forum_id
message_id_9 INDEX None  Edit Drop message_id
Create an index on  columns  
 
Space usage: 
Type Usage
Data 52 Bytes
Index 24,576 Bytes
Total 24,628 Bytes
 
Row Statistic: 
Statements Value
Format fixed
Collation latin1_swedish_ci
Rows 4
Row length ø 13
Row size  ø 6,157 Bytes
Creation Apr 20, 2018 at 06:50 PM
Last update Apr 20, 2018 at 06:50 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: