diff options
Diffstat (limited to 'httemplate/docs/upgrade8.html')
| -rw-r--r-- | httemplate/docs/upgrade8.html | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index b35194df2..765c2b8d5 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -75,8 +75,7 @@ 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) + amount decimal(10,2) not null ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; @@ -93,6 +92,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_bill1 ON cust_credit_bill ( crednum ); CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum ); </pre> |