diff options
| -rw-r--r-- | FS/FS/Schema.pm | 2 | ||||
| -rw-r--r-- | README.1.5.8 | 3 |
2 files changed, 4 insertions, 1 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index aacc16474..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' => { diff --git a/README.1.5.8 b/README.1.5.8 index b5ba98005..ce5a5d09f 100644 --- a/README.1.5.8 +++ b/README.1.5.8 @@ -8,6 +8,9 @@ install Business::CreditCard 0.28 install the new version run "freeside-upgrade username" to uprade your database schema +Optional: +CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart ); + Optional for better VoIP performance: CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum ); |