projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
3c0e96d
)
add cust_pkg2 index on cust_pkg.pkgpart
author
ivan
<ivan>
Thu, 17 Nov 2005 12:27:39 +0000
(12:27 +0000)
committer
ivan
<ivan>
Thu, 17 Nov 2005 12:27:39 +0000
(12:27 +0000)
FS/FS/Schema.pm
patch
|
blob
|
history
README.1.5.8
patch
|
blob
|
history
diff --git
a/FS/FS/Schema.pm
b/FS/FS/Schema.pm
index
aacc164
..
aaca5ef
100644
(file)
--- 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
b5ba980
..
ce5a5d0
100644
(file)
--- 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 );