diff options
author | ivan <ivan> | 2002-01-29 17:42:46 +0000 |
---|---|---|
committer | ivan <ivan> | 2002-01-29 17:42:46 +0000 |
commit | c5c0ba135749164ec8ba75d18f76c29625e1bc7e (patch) | |
tree | 6c855b5b5e0a4774d7f6737fc46bf357042e6d3c /httemplate/docs/upgrade8.html | |
parent | 6991d4986df7fb3a6c7c49b5ae1b3713e87a16c4 (diff) |
weight, plan and plandata fields in part_bill_event
Diffstat (limited to 'httemplate/docs/upgrade8.html')
-rw-r--r-- | httemplate/docs/upgrade8.html | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index bbb528cda..c4d023a58 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -128,7 +128,7 @@ 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 ); CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum ); CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum ); @@ -139,7 +139,10 @@ CREATE TABLE part_bill_event ( event varchar(80) not null, eventcode text null, seconds int null, - disabled char(1) null, + weight int not null, + plan varchar(80) null, + plandata text null, + disabled char(1) null ); CREATE INDEX part_bill_event1 ON part_bill_event ( payby ); |