From 42ac86258bce00f5e7fa2db7e375c4a344295a15 Mon Sep 17 00:00:00 2001
From: jeff <jeff>
Date: Sat, 1 Sep 2001 22:28:51 +0000
Subject: haste makes waste... and left a method out

---
 httemplate/docs/upgrade8.html | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'httemplate/docs/upgrade8.html')

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>
 
-- 
cgit v1.2.1