Changeset 2677

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

Updates to indexes for mt_objectscore.

Location:
branches/release-41
Files:
3 modified

Legend:

Unmodified
Added
Removed
  • branches/release-41/build/mt-dists/default.mk

    r2627 r2677  
    22 
    33PRODUCT_VERSION = 4.2 
    4 SCHEMA_VERSION = 4.0066 
     4SCHEMA_VERSION = 4.0067 
    55API_VERSION = 4.2 
    66 
  • 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 => { 
  • branches/release-41/lib/MT/Upgrade.pm

    r2672 r2677  
    992992        }, 
    993993        'core_recover_sysadmin_permissions' => { 
    994             version_limit => 4.0067, 
     994            version_limit => 4.0066, 
    995995            priority => 3.5, 
    996996            updater => {