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

diff --git a/README.1.5.8 b/README.1.5.8
index 6ad19b063..4335a5677 100644
--- a/README.1.5.8
+++ b/README.1.5.8
@@ -8,6 +8,15 @@ install DBIx::DBSchema 0.27 (or later)
 install HTML::Widgets:SelectLayers 0.05 (or later)
 install Business::CreditCard 0.28 (or later)
 
+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