add status and statustext fields to cust_bill_event

2 files changed, 4 insertions, 0 deletions

diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html
index 8420161bf..b828213ff 100644
--- a/httemplate/docs/schema.html
+++ b/httemplate/docs/schema.html
@@ -32,6 +32,8 @@
         <li>invnum - <a href="#cust_bill">invoice</a>
         <li>eventpart - <a href="#part_bill_event">event definition</a>
         <li>_date
+        <li>status
+        <li>statustext
       </ul>
     <li><a name="part_bill_event" href="man/FS/part_bill_event.html">part_bill_event</a> - Invoice event definitions
       <ul>
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 );