X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=765c2b8d50d1bd4694d67f498dfe247ca778dfb5;hp=b35194df2a82ce9b942a49d2853a142476387bb2;hb=42ac86258bce00f5e7fa2db7e375c4a344295a15;hpb=60c10ab363668ec3016306e6069eaade9e04d544

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>