haste makes waste... and left a method out

[freeside.git] / httemplate / docs / upgrade8.html

diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index b35194d..765c2b8 100644 (file)
--- 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>