Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: phorum_user_group_xrefphorum_user_group_xref
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
SQL-query: 
SELECT *
FROM `phorum_user_group_xref`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   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
   tinyint(3)     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
group_id
user_id_2 UNIQUE Edit Drop user_id
group_id_2 UNIQUE Edit Drop group_id
status_2 UNIQUE Edit Drop status
group_id_4 UNIQUE Edit Drop group_id
user_id_4 UNIQUE Edit Drop user_id
status_3 UNIQUE Edit Drop status
group_id_5 UNIQUE Edit Drop group_id
user_id_5 UNIQUE Edit Drop user_id
status_5 UNIQUE Edit Drop status
status_7 UNIQUE Edit Drop status
group_id_8 UNIQUE Edit Drop group_id
user_id_7 UNIQUE Edit Drop user_id
status_9 UNIQUE Edit Drop status
user_id_9 UNIQUE Edit Drop user_id
status_10 UNIQUE Edit Drop status
group_id_11 UNIQUE Edit Drop group_id
user_id_12 UNIQUE Edit Drop user_id
group_id_12 UNIQUE Edit Drop group_id
user_id INDEX None  Edit Drop user_id
group_id INDEX None  Edit Drop group_id
status INDEX None  Edit Drop status
group_id_3 INDEX None  Edit Drop group_id
user_id_3 INDEX None  Edit Drop user_id
status_4 INDEX None  Edit Drop status
group_id_6 INDEX None  Edit Drop group_id
user_id_6 INDEX None  Edit Drop user_id
status_6 INDEX None  Edit Drop status
group_id_7 INDEX None  Edit Drop group_id
user_id_8 INDEX None  Edit Drop user_id
status_8 INDEX None  Edit Drop status
group_id_9 INDEX None  Edit Drop group_id
group_id_10 INDEX None  Edit Drop group_id
user_id_10 INDEX None  Edit Drop user_id
user_id_11 INDEX None  Edit Drop user_id
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 2,048 Bytes
Total 2,048 Bytes
 
Row Statistic: 
Statements Value
Format fixed
Collation latin1_swedish_ci
Rows 0
Creation Apr 09, 2018 at 04:08 AM
Last update Apr 09, 2018 at 04:08 AM
Last check Apr 09, 2018 at 04:08 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: