Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: jos_content_ratingjos_content_rating
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0280 sec)
SQL-query: 
SELECT *
FROM `jos_content_rating`
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)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_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 content_id
content_id_2 UNIQUE Edit Drop content_id
rating_sum_2 UNIQUE Edit Drop rating_sum
rating_count_2 UNIQUE Edit Drop rating_count
lastip_2 UNIQUE Edit Drop lastip
lastip_5 UNIQUE Edit Drop lastip
rating_sum_4 UNIQUE Edit Drop rating_sum
content_id_4 UNIQUE Edit Drop content_id
rating_count_4 UNIQUE Edit Drop rating_count
rating_count_5 UNIQUE Edit Drop rating_count
rating_sum_5 UNIQUE Edit Drop rating_sum
content_id_6 UNIQUE Edit Drop content_id
lastip_9 UNIQUE Edit Drop lastip
rating_sum_7 UNIQUE Edit Drop rating_sum
lastip_12 UNIQUE Edit Drop lastip
content_id_8 UNIQUE Edit Drop content_id
rating_count_8 UNIQUE Edit Drop rating_count
lastip_14 UNIQUE Edit Drop lastip
rating_sum_9 UNIQUE Edit Drop rating_sum
rating_count_9 UNIQUE Edit Drop rating_count
lastip_16 UNIQUE Edit Drop lastip
content_id_10 UNIQUE Edit Drop content_id
rating_sum_11 UNIQUE Edit Drop rating_sum
content_id_12 UNIQUE Edit Drop content_id
rating_count_12 UNIQUE Edit Drop rating_count
content_id_14 UNIQUE Edit Drop content_id
rating_sum_14 UNIQUE Edit Drop rating_sum
rating_count_14 UNIQUE Edit Drop rating_count
lastip_20 UNIQUE Edit Drop lastip
content_id INDEX None  Edit Drop content_id
rating_sum INDEX None  Edit Drop rating_sum
rating_count INDEX None  Edit Drop rating_count
lastip INDEX None  Edit Drop lastip
lastip_4 INDEX None  Edit Drop lastip
rating_count_3 INDEX None  Edit Drop rating_count
content_id_3 INDEX None  Edit Drop content_id
rating_sum_3 INDEX None  Edit Drop rating_sum
content_id_5 INDEX None  Edit Drop content_id
lastip_7 INDEX None  Edit Drop lastip
rating_count_6 INDEX None  Edit Drop rating_count
rating_sum_6 INDEX None  Edit Drop rating_sum
content_id_7 INDEX None  Edit Drop content_id
lastip_11 INDEX None  Edit Drop lastip
rating_sum_8 INDEX None  Edit Drop rating_sum
rating_count_7 INDEX None  Edit Drop rating_count
lastip_13 INDEX None  Edit Drop lastip
rating_sum_10 INDEX None  Edit Drop rating_sum
content_id_9 INDEX None  Edit Drop content_id
content_id_11 INDEX None  Edit Drop content_id
rating_count_10 INDEX None  Edit Drop rating_count
rating_sum_12 INDEX None  Edit Drop rating_sum
lastip_18 INDEX None  Edit Drop lastip
rating_count_11 INDEX None  Edit Drop rating_count
content_id_13 INDEX None  Edit Drop content_id
rating_sum_13 INDEX None  Edit Drop rating_sum
rating_count_13 INDEX None  Edit Drop rating_count
lastip_19 INDEX None  Edit Drop lastip
lastip_3 FULLTEXT None  Edit Drop lastip
lastip_6 FULLTEXT None  Edit Drop lastip
lastip_8 FULLTEXT None  Edit Drop lastip
lastip_10 FULLTEXT None  Edit Drop lastip
lastip_15 FULLTEXT None  Edit Drop lastip
lastip_17 FULLTEXT None  Edit Drop lastip
lastip_21 FULLTEXT None  Edit Drop lastip
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 utf8_general_ci
Rows 0
Creation Apr 18, 2018 at 04:38 PM
Last update Apr 18, 2018 at 04:38 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: