summaryrefslogtreecommitdiff
path: root/README.1.5.8
diff options
context:
space:
mode:
Diffstat (limited to 'README.1.5.8')
-rw-r--r--README.1.5.89
1 files changed, 9 insertions, 0 deletions
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