X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=9ca7cb7b9098d9a42e4844434ce4aab391d01c2b;hb=b6343424437589018faba310159efaff6cecac18;hp=0210430eff62066706c16a7c023189811ec2ae04;hpb=6fb47adef49450c1fb237251aae911b0825e6869;p=freeside.git diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 0210430ef..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 ); @@ -369,7 +371,7 @@ ALTER TABLE cust_refund DROP COLUMN crednum;