summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2003-03-12 00:44:23 +0000
committerivan <ivan>2003-03-12 00:44:23 +0000
commit6609285a50f6c9110ae8d5a26a767fd895f1e325 (patch)
treeac73c8cf9daf9dc15b93fc4d01275f1d0d113a80
parent0857c5465840060a13b93e6c5a15af6ed6476a1f (diff)
doc from 1.4 branch
-rw-r--r--httemplate/docs/upgrade9.html5
1 files changed, 5 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade9.html b/httemplate/docs/upgrade9.html
index da5b643fb..c6afe2b0f 100644
--- a/httemplate/docs/upgrade9.html
+++ b/httemplate/docs/upgrade9.html
@@ -15,6 +15,11 @@
INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 18, 'daytime', 'en_US', 'Day Phone' );
INSERT INTO msgcat ( msgnum, msgcode, locale, msg ) VALUES ( 19, 'night', 'en_US', 'Night Phone' );
</pre>
+ <li>Optionally, apply the following changes to your database (performance improvement for large numbers of services or packages):
+<pre>
+CREATE INDEX part_pkg1 ON part_pkg ( disabled );
+CREATE INDEX part_svc1 ON part_svc ( disabled );
+</pre>
<li>If you want to use ACH (electronic checks), you will need to make changes to your database. The easiest way to make these changes is to dump your database (with pg_dump), change the payinfo field in the cust_pay, cust_refund, h_cust_pay and h_cust_refund tables from varchar(16) to varchar(80), reload the database from the dump, and run dbdef-create
<li>Restart Apache and freeside-queued.
</body>