[freeside-users] Upgrading From 1.58->1.73

[John]

Thank you again Amitay, your guidance was spot on.

For those who will scour the list in the future as we all have done many times in the past-

ALTER TABLE cust_pay_batch ADD COLUMN batchnum integer NOT NULL;
ALTER TABLE h_cust_pay_batch ADD COLUMN batchnum integer;
UPDATE h_cust_pay_batch SET batchnum = paybatchnum;
ALTER TABLE h_cust_pay_batch ALTER COLUMN batchnum SET NOT NULL;
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);
update h_cust_pay_batch set payby = 'CARD';
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;


Radius attributes and cc batching customisations were lost but everything else seems fine!

John
Central Coast Internet
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://420.am/pipermail/freeside-users/attachments/20090527/3e386347/attachment.htm>