diff options
Diffstat (limited to 'httemplate/docs/upgrade10.html')
| -rw-r--r-- | httemplate/docs/upgrade10.html | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html index 7cd1d8e50..2a4b0d975 100644 --- a/httemplate/docs/upgrade10.html +++ b/httemplate/docs/upgrade10.html @@ -46,6 +46,14 @@ DROP INDEX cust_bill_pkg1; <pre> ALTER TABLE cust_main ALTER COLUMN payinfo varchar(512) NULL; ALTER TABLE h_cust_main ALTER COLUMN payinfo varchar(512) NULL; +ALTER TABLE cust_pay_batch ADD COLUMN batchnum int NOT NULL; +ALTER TABLE cust_pay_batch ALTER COLUMN batchnum SET NOT NULL; +ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512) NULL; +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) NULL; +UPDATE h_cust_pay_batch SET payinfo = cardnum; +ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum; </pre> On older Pg versions that don't support altering columns directly, you will need to dump the database, edit the schema definitions in the dump file, and reload. |