X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=9ca7cb7b9098d9a42e4844434ce4aab391d01c2b;hb=dfd4f9377b21a5eab563e1739f296e04668ce6ca;hp=cf60a8582b69bc18af7a5ae05de5513104518d8d;hpb=eb9668a6f3181ee02cb335272c5ee4616e61fd09;p=freeside.git diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index cf60a8582..9ca7cb7b9 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -149,7 +149,9 @@ CREATE TABLE cust_bill_event ( eventnum int primary key, invnum int not null, eventpart int not null, - _date int not null + _date int not null, + status varchar(80) not null, + statustext text ); CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum ); CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum );