X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade6.html;h=807146f891142d5f9d04958619e68dad722c52aa;hb=15f65a0c56cbce6951d9cb4f71119725a2009f79;hp=c9cdf331432c2f7395d8eecf9f627d75b72d6822;hpb=e446c1f657b37034e1867e82857a1741572da07f;p=freeside.git diff --git a/htdocs/docs/upgrade6.html b/htdocs/docs/upgrade6.html index c9cdf3314..807146f89 100644 --- a/htdocs/docs/upgrade6.html +++ b/htdocs/docs/upgrade6.html @@ -1,8 +1,8 @@
-CREATE TABLE domain_record ( @@ -32,8 +35,23 @@ ALTER TABLE part_svc ADD svc_www__recnum_flag char(1) NULL; ALTER TABLE part_svc ADD svc_www__usersvc varchar(80) NULL; ALTER TABLE part_svc ADD svc_www__uesrsvc_flag char(1) NULL; ALTER TABLE svc_acct CHANGE _password _password varchar(50) NULL; +ALTER TABLE svc_acct ADD seconds integer NULL; +ALTER TABLE part_svc ADD svc_acct__seconds integer NULL; +ALTER TABLE part_svc ADD svc_acct__seconds_flag char(1) NULL; +ALTER TABLE prepay_credit ADD seconds integer NULL;+
+ALTER TABLE cust_bill DROP owed; +ALTER TABLE cust_credit DROP credited; ++ Or, if your database does not support dropping columns, you can do this: +
+ALTER TABLE cust_bill CHANGE owed depriciated decimal(10,2); +ALTER TABLE cust_credit CHANGE credited depriciated2 decimal(10,2); ++