diff options
Diffstat (limited to 'httemplate/docs/upgrade8.html')
-rw-r--r-- | httemplate/docs/upgrade8.html | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 3edc87864..b35194df2 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -70,6 +70,15 @@ CREATE TABLE svc_forward ( dst varchar(80), PRIMARY KEY (svcnum) ); + +CREATE TABLE cust_credit_bill ( + crednum int not null, + invnum int not null, + _date timestamp not null, + amount decimal(10,2) not null, + PRIMARY KEY (crednum) +); + ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL; @@ -84,6 +93,7 @@ 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; CREATE INDEX cust_main3 ON cust_main ( referral_custnum ); +CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum ); </pre> <li>If you are using PostgreSQL, apply the following changes to your database: |