X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.5.8;h=4335a5677e300e62ca67663b98fa79c4cc385ade;hb=50f25b285b2caf77d267ed66f03e56924ad7229f;hp=ce5a5d09f477e5711cac2944b883be35e9cc0b6e;hpb=85aee8e40103f4e9d547258f8a06fea580345519;p=freeside.git

diff --git a/README.1.5.8 b/README.1.5.8
index ce5a5d09f..4335a5677 100644
--- a/README.1.5.8
+++ b/README.1.5.8
@@ -1,16 +1,39 @@
 
 install JSON
+install Term::ReadKey
 
-install DBIx::DBSchema 0.27
-install HTML::Widgets:SelectLayers 0.05
-install Business::CreditCard 0.28
+install DBIx::DBSchema 0.27 (or later)
+  (if you are running Pg version 7.2.x or earlier, install at least
+   DBIx::DBSchema 0.29)
+install HTML::Widgets:SelectLayers 0.05 (or later)
+install Business::CreditCard 0.28 (or later)
 
-install the new version
+ALTER TABLE cust_pay_batch ADD COLUMN batchnum int;
+ALTER TABLE cust_pay_batch ALTER COLUMN batchnum SET NOT NULL;
+ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);
+UPDATE cust_pay_batch SET payinfo = cardnum;
+ALTER TABLE cust_pay_batch DROP COLUMN cardnum;
+ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);
+UPDATE h_cust_pay_batch SET payinfo = cardnum;
+ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
+
+make install-perl-modules
 run "freeside-upgrade username" to uprade your database schema
 
+(if freeside-upgrade hangs, try stopping Apache, all Freeside processes, and
+ anything else connected to your database, especially on older Pg versions)
+
 Optional:
 CREATE INDEX cust_pkg2 ON cust_pkg ( pkgpart );
 
+CREATE INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum );
+CREATE INDEX cust_main9 ON cust_main ( county );
+CREATE INDEX cust_main10 ON cust_main ( state );
+CREATE INDEX cust_main11 ON cust_main ( country );
+CREATE INDEX cust_main_county1 ON cust_main_county ( county );
+CREATE INDEX cust_main_county2 ON cust_main_county ( state );
+CREATE INDEX cust_main_county3 ON cust_main_county ( country );
+
 Optional for better VoIP performance:
 CREATE INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum );
 
@@ -35,3 +58,11 @@ Installs w/integrated RT:
 
   make configure-rt
 
+------
+
+make install-docs
+ (or "make deploy" if you've got everything setup in the Makefile)
+
+(errors?  try "make clean" then "make install-perl-modules", then
+ "make install-docs" or "make deploy" again)
+