From 6a37289c12238d48ea864b8177216ca276b33a40 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 27 Feb 2002 22:39:14 +0000 Subject: add status and statustext fields to cust_bill_event --- httemplate/docs/upgrade8.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 3edf425bf..a4fb1762f 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -188,6 +188,8 @@ ALTER TABLE cust_bill ADD closed char(1) NULL; ALTER TABLE cust_pay ADD closed char(1) NULL; ALTER TABLE cust_credit ADD closed char(1) NULL; ALTER TABLE cust_refund ADD closed char(1) NULL; +ALTER TABLE cust_bill_event ADD status varchar(80); +ALTER TABLE cust_bill_event ADD statustext text 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 ); -- cgit v1.2.1