diff options
| author | jeff <jeff> | 2001-09-01 22:28:51 +0000 |
|---|---|---|
| committer | jeff <jeff> | 2001-09-01 22:28:51 +0000 |
| commit | 42ac86258bce00f5e7fa2db7e375c4a344295a15 (patch) | |
| tree | 44427da300d3334d92689082c32a7cc79333d587 /httemplate/docs | |
| parent | 60c10ab363668ec3016306e6069eaade9e04d544 (diff) | |
haste makes waste... and left a method out
Diffstat (limited to 'httemplate/docs')
| -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> |