Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_subscribersphorum_subscribers
An index has been added on thread (Query took 0.0105 sec)
SQL-query: 
ALTER TABLE `phorum_subscribers` ADD INDEX ( `thread` )
 [Edit] [Create PHP Code]


   Field  Type Collation Attributes Null Default Extra Action
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED 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
thread
user_id_2 UNIQUE Edit Drop user_id
forum_id_3 UNIQUE Edit Drop forum_id
sub_type_2 UNIQUE Edit Drop sub_type
thread_2 UNIQUE Edit Drop thread
sub_type_3 UNIQUE Edit Drop sub_type
forum_id_4 UNIQUE Edit Drop forum_id
user_id_4 UNIQUE Edit Drop user_id
thread_4 UNIQUE Edit Drop thread
thread_5 UNIQUE Edit Drop thread
forum_id_6 UNIQUE Edit Drop forum_id
sub_type_5 UNIQUE Edit Drop sub_type
user_id_6 UNIQUE Edit Drop user_id
forum_id_8 UNIQUE Edit Drop forum_id
sub_type_7 UNIQUE Edit Drop sub_type
user_id_8 UNIQUE Edit Drop user_id
thread_8 UNIQUE Edit Drop thread
sub_type_10 UNIQUE Edit Drop sub_type
user_id_9 UNIQUE Edit Drop user_id
forum_id_11 UNIQUE Edit Drop forum_id
thread_11 UNIQUE Edit Drop thread
forum_id_13 UNIQUE Edit Drop forum_id
sub_type_11 UNIQUE Edit Drop sub_type
user_id_12 UNIQUE Edit Drop user_id
user_id_14 UNIQUE Edit Drop user_id
forum_id_15 UNIQUE Edit Drop forum_id
sub_type_13 UNIQUE Edit Drop sub_type
thread_13 UNIQUE Edit Drop thread
thread_14 UNIQUE Edit Drop thread
forum_id_16 UNIQUE Edit Drop forum_id
forum_id INDEX None  Edit Drop forum_id
thread
sub_type
user_id INDEX None  Edit Drop user_id
forum_id_2 INDEX None  Edit Drop forum_id
sub_type INDEX None  Edit Drop sub_type
thread INDEX None  Edit Drop thread
user_id_3 INDEX None  Edit Drop user_id
forum_id_5 INDEX None  Edit Drop forum_id
thread_3 INDEX None  Edit Drop thread
sub_type_4 INDEX None  Edit Drop sub_type
user_id_5 INDEX None  Edit Drop user_id
forum_id_7 INDEX None  Edit Drop forum_id
sub_type_6 INDEX None  Edit Drop sub_type
thread_6 INDEX None  Edit Drop thread
thread_7 INDEX None  Edit Drop thread
forum_id_9 INDEX None  Edit Drop forum_id
user_id_7 INDEX None  Edit Drop user_id
sub_type_8 INDEX None  Edit Drop sub_type
forum_id_10 INDEX None  Edit Drop forum_id
thread_9 INDEX None  Edit Drop thread
sub_type_9 INDEX None  Edit Drop sub_type
thread_10 INDEX None  Edit Drop thread
user_id_10 INDEX None  Edit Drop user_id
forum_id_12 INDEX None  Edit Drop forum_id
user_id_11 INDEX None  Edit Drop user_id
user_id_13 INDEX None  Edit Drop user_id
forum_id_14 INDEX None  Edit Drop forum_id
sub_type_12 INDEX None  Edit Drop sub_type
thread_12 INDEX None  Edit Drop thread
sub_type_14 INDEX None  Edit Drop sub_type
thread_15 INDEX None  Edit Drop thread
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 fixed
Collation latin1_swedish_ci
Rows 0
Creation Jun 19, 2018 at 08:34 AM
Last update Jun 19, 2018 at 08:34 AM
Last check Jun 19, 2018 at 08:34 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: