X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade6.html;h=dc82975f33bcb68b827ebe4da900e88595b64f10;hp=f27cadc633787ec7b4260dc116e3f8305e0dded3;hb=e6cf4af2b9d3ffefebe1a3e358f0674f566b56bc;hpb=07d8271c8f91e6a2b34b33133ef22aad96e834ad diff --git a/htdocs/docs/upgrade6.html b/htdocs/docs/upgrade6.html index f27cadc63..dc82975f3 100644 --- a/htdocs/docs/upgrade6.html +++ b/htdocs/docs/upgrade6.html @@ -1,8 +1,8 @@
-CREATE TABLE domain_record ( @@ -27,14 +30,28 @@ CREATE TABLE svc_www ( usersvc int NOT NULL, PRIMARY KEY (svcnum) ); -ALTER TABLE part_svc ADD svc_www__svcnum varchar(80) NULL; -ALTER TABLE part_svc ADD svc_www__svcnum_flag char(1) NULL; 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); ++