projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
weight, plan and plandata fields in part_bill_event
[freeside.git]
/
httemplate
/
docs
/
upgrade8.html
diff --git
a/httemplate/docs/upgrade8.html
b/httemplate/docs/upgrade8.html
index
144242b
..
c4d023a
100644
(file)
--- 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,
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 );
);
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,
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 );
);
CREATE INDEX part_bill_event1 ON part_bill_event ( payby );
@@
-175,6
+178,10
@@
ALTER TABLE part_pkg ADD setuptax char(1) NULL;
ALTER TABLE part_pkg ADD recurtax char(1) NULL;
ALTER TABLE part_pkg ADD disabled char(1) NULL;
ALTER TABLE part_svc ADD disabled char(1) NULL;
ALTER TABLE part_pkg ADD recurtax char(1) NULL;
ALTER TABLE part_pkg ADD disabled char(1) NULL;
ALTER TABLE part_svc ADD disabled char(1) NULL;
+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;
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 );
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 );