X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade6.html;h=807146f891142d5f9d04958619e68dad722c52aa;hb=ec50de2b78ef1796085f4949265fbe6bc0564086;hp=7615fa71ada415df76c2dc2fa135ff8d81cd5f4a;hpb=c30183b25bfe0f99b96bbe9f1baf099fec323d02;p=freeside.git diff --git a/htdocs/docs/upgrade6.html b/htdocs/docs/upgrade6.html index 7615fa71a..807146f89 100644 --- a/htdocs/docs/upgrade6.html +++ b/htdocs/docs/upgrade6.html @@ -1,8 +1,8 @@
-CREATE TABLE domain_record ( @@ -31,8 +34,24 @@ ALTER TABLE part_svc ADD svc_www__recnum varchar(80) NULL; 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); ++