summaryrefslogtreecommitdiff
path: root/httemplate/docs/upgrade8.html
diff options
context:
space:
mode:
authorivan <ivan>2002-01-29 17:42:46 +0000
committerivan <ivan>2002-01-29 17:42:46 +0000
commitc5c0ba135749164ec8ba75d18f76c29625e1bc7e (patch)
tree6c855b5b5e0a4774d7f6737fc46bf357042e6d3c /httemplate/docs/upgrade8.html
parent6991d4986df7fb3a6c7c49b5ae1b3713e87a16c4 (diff)
weight, plan and plandata fields in part_bill_event
Diffstat (limited to 'httemplate/docs/upgrade8.html')
-rw-r--r--httemplate/docs/upgrade8.html7
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 );