X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.7.0;h=a6e18d05d4de9eda68ae7323a05788ddc309e664;hb=1904b218cacfe4e96f3fd3b57f7242617099c485;hp=834972ae2311164c12b95aa351a2cc13a674f86a;hpb=fadaa67e77ad8d5d966e252aba7f193e9e3840e3;p=freeside.git

diff --git a/README.1.7.0 b/README.1.7.0
index 834972ae2..a6e18d05d 100644
--- a/README.1.7.0
+++ b/README.1.7.0
@@ -1,5 +1,16 @@
 
-install DBIx::DBSchema 0.29 (or later)
+install DBIx::DBSchema 0.31 (or later)
+install Color::Scheme
+install Data::Table
+
+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
@@ -12,8 +23,18 @@ to the new cust_tax_exempt_pkg table.  An example script to get you started is
 in bin/fs-migrate-cust_tax_exempt - it may need to be customized for your
 specific data.
 
+Optional for better zip code report performance:
+CREATE INDEX cust_main16 on cust_main ( zip );
+CREATE INDEX cust_main17 on cust_main ( ship_zip );
+
+Optional to eliminate harmless but noisy warnings:
+UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;
+
 ------
 
 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)
+