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
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 );
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)
+