Index: branches/release-41/lib/MT/Upgrade.pm
===================================================================
--- branches/release-41/lib/MT/Upgrade.pm (revision 2672)
+++ branches/release-41/lib/MT/Upgrade.pm (revision 2677)
@@ -992,5 +992,5 @@
         },
         'core_recover_sysadmin_permissions' => {
-            version_limit => 4.0067,
+            version_limit => 4.0066,
             priority => 3.5,
             updater => {
Index: branches/release-41/lib/MT/ObjectScore.pm
===================================================================
--- branches/release-41/lib/MT/ObjectScore.pm (revision 1174)
+++ branches/release-41/lib/MT/ObjectScore.pm (revision 2677)
@@ -21,8 +21,20 @@
     },
     indexes => {
-        namespace => 1,
-        object_id => 1,
-        author_id => 1,
-        ip        => 1,
+        # usually used to remove all scores for a given object
+        ds_obj => {
+            columns => ['object_ds', 'object_id'],
+        },
+        # common requests for scoring
+        ns_user_ds_obj => {
+            columns => ['namespace', 'author_id', 'object_ds', 'object_id'],
+        },
+        # common requests for anonymous scoring (ip-based)
+        ns_ip_ds_obj => {
+            columns => ['namespace', 'ip', 'object_ds', 'object_id'],
+        },
+        # for scored_by method
+        user_ns => {
+            columns => ['author_id', 'namespace'],
+        },
     },
     defaults => {