Show
Ignore:
Timestamp:
07/02/08 17:18:54 (17 months ago)
Author:
bchoate
Message:

Updates to indexes for mt_objectscore.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • branches/release-41/lib/MT/ObjectScore.pm

    r1174 r2677  
    2121    }, 
    2222    indexes => { 
    23         namespace => 1, 
    24         object_id => 1, 
    25         author_id => 1, 
    26         ip        => 1, 
     23        # usually used to remove all scores for a given object 
     24        ds_obj => { 
     25            columns => ['object_ds', 'object_id'], 
     26        }, 
     27        # common requests for scoring 
     28        ns_user_ds_obj => { 
     29            columns => ['namespace', 'author_id', 'object_ds', 'object_id'], 
     30        }, 
     31        # common requests for anonymous scoring (ip-based) 
     32        ns_ip_ds_obj => { 
     33            columns => ['namespace', 'ip', 'object_ds', 'object_id'], 
     34        }, 
     35        # for scored_by method 
     36        user_ns => { 
     37            columns => ['author_id', 'namespace'], 
     38        }, 
    2739    }, 
    2840    defaults => {