diff options
Diffstat (limited to 'README.1.4.0pre8')
-rw-r--r-- | README.1.4.0pre8 | 74 |
1 files changed, 74 insertions, 0 deletions
diff --git a/README.1.4.0pre8 b/README.1.4.0pre8 new file mode 100644 index 000000000..7ddd7e292 --- /dev/null +++ b/README.1.4.0pre8 @@ -0,0 +1,74 @@ +the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8 + +if you're upgrading from 1.3.1 follow the instructions in +httemplate/docs/upgrade8.html instead + +if you're upgradeing from before 1.4.0pre4, see +http://cleanwhisker.420.am/cgi-bin/cvsweb/freeside/Attic/ + +----- + +install Time::Duration and Tie::IxHash + +install the FS perl modules and httemplate as per install.html or upgrade8.html + +ALTER TABLE part_pkg ADD disabled char(1) NULL; +ALTER TABLE part_svc ADD disabled char(1) NULL; + +CREATE TABLE cust_bill_event ( + eventnum int primary key, + invnum int not null, + eventpart 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 TABLE part_bill_event ( + eventpart int primary key, + payby char(4) not null, + event varchar(80) not null, + eventcode text null, + seconds int 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 TABLE part_export ( + exportnum int primary key, + svcpart int not null, + machine varchar(80) not null, + exporttype varchar(80) not null, + nodomain char(1) NULL +); +CREATE INDEX part_export1 ON part_export ( machine ); +CREATE INDEX part_export2 ON part_export ( exporttype ); + +CREATE TABLE part_export_option ( + optionnum int primary key, + exportnum int not null, + optionname varchar(80) not null, + optionvalue text NULL +); +CREATE INDEX part_export_option1 ON part_export_option ( exportnum ); +CREATE INDEX part_export_option2 ON part_export_option ( optionname ); + +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; + +Run bin/dbdef-create + +Restart Apache and freeside-queued + +Go to the new "View/Edit Invoice events" in the web interface and add the +appropriate events. At the very least, you'll want to set some invoice events +"After 0 days": a BILL invoice event to print invoices, a CARD invoice event to +batch or run cards real-time, and a COMP invoice event to "pay" complimentary +customers. If you were using the -i option to freeside-bill it should be +removed. + |