-
-install DBIx::DBSchema 0.27
-install HTML::Widgets:SelectLayers 0.05
-install Business::CreditCard 0.28
+install Term::ReadKey
+
+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)
+
+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;