X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FSchema.pm;h=aaca5ef3bf3983691e1943cbc89fb64ff8fd5767;hb=85aee8e40103f4e9d547258f8a06fea580345519;hp=12a4fd5d2d058949be5df85cd5444b3357e3cb5d;hpb=4b4b3ca9cb0b7336293b759549b78fc903a7d8c8;p=freeside.git

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index 12a4fd5d2..aaca5ef3b 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -561,7 +561,7 @@ sub tables_hashref {
       ],
       'primary_key' => 'pkgnum',
       'unique' => [],
-      'index' => [ ['custnum'] ],
+      'index' => [ ['custnum'], ['pkgpart'] ],
     },
 
     'cust_refund' => {
@@ -1122,7 +1122,7 @@ sub tables_hashref {
       ],
       'primary_key' => 'ratedetailnum',
       'unique'      => [ [ 'ratenum', 'orig_regionnum', 'dest_regionnum' ] ],
-      'index'       => [],
+      'index'       => [ [ 'ratenum', 'dest_regionnum' ] ],
     },
 
     'rate_region' => {