X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=htdocs%2Fdocs%2Fupgrade6.html;h=8e70b5586c4f404ec6e0cefec4b31446988dc1a2;hp=f27cadc633787ec7b4260dc116e3f8305e0dded3;hb=d220c8a4bfa1aee8f17ed71c2dba655160dd3595;hpb=07d8271c8f91e6a2b34b33133ef22aad96e834ad diff --git a/htdocs/docs/upgrade6.html b/htdocs/docs/upgrade6.html index f27cadc63..8e70b5586 100644 --- a/htdocs/docs/upgrade6.html +++ b/htdocs/docs/upgrade6.html @@ -10,6 +10,8 @@
CREATE TABLE domain_record ( @@ -27,12 +29,15 @@ 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;