X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fdocs%2Fupgrade8.html;h=cd537119eca043a9c38a194ea99d9b368a39a423;hb=02b16ae5152826a2dfc3ec9a2e173198e2d013d3;hp=1e4064e8d047e00fad6ae977af06d511ac124b8e;hpb=98ddc878969bb39e576e3bd316f96ff7eeedb750;p=freeside.git diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 1e4064e8d..cd537119e 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -109,6 +109,8 @@ ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_forward__dst integer NULL; ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL; ALTER TABLE cust_main ADD referral_custnum integer NULL; +ALTER TABLE cust_pay ADD custnum integer; +ALTER TABLE cust_refund ADD custnum integer; CREATE INDEX cust_main3 ON cust_main ( referral_custnum ); CREATE INDEX cust_credit_bill1 ON cust_credit_bill ( crednum ); CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum ); @@ -175,5 +177,19 @@ ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
PostgreSQL | MySQL, others |
---|---|
++ALTER TABLE cust_pay RENAME COLUMN invnum TO depreciated; +ALTER TABLE cust_refund RENAME COLUMN crednum TO depreciated; ++ |
++ALTER TABLE cust_pay DROP COLUMN invnum; +ALTER TABLE cust_refund DROP COLUMN crednum; ++ |