1 the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8
3 if you're upgrading from 1.3.1 follow the instructions in
4 httemplate/docs/upgrade8.html instead
6 if you're upgradeing from before 1.4.0pre4, see
7 http://cleanwhisker.420.am/cgi-bin/cvsweb/freeside/Attic/
11 install Time::Duration and Tie::IxHash
13 install the FS perl modules and httemplate as per install.html or upgrade8.html
15 ALTER TABLE part_pkg ADD disabled char(1) NULL;
16 ALTER TABLE part_svc ADD disabled char(1) NULL;
18 CREATE TABLE cust_bill_event (
19 eventnum int primary key,
21 eventpart int not null,
24 CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum );
25 CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum );
27 CREATE TABLE part_bill_event (
28 eventpart int primary key,
29 payby char(4) not null,
30 event varchar(80) not null,
34 plan varchar(80) null,
38 CREATE INDEX part_bill_event1 ON part_bill_event ( payby );
40 CREATE TABLE part_export (
41 exportnum int primary key,
43 machine varchar(80) not null,
44 exporttype varchar(80) not null,
47 CREATE INDEX part_export1 ON part_export ( machine );
48 CREATE INDEX part_export2 ON part_export ( exporttype );
50 CREATE TABLE part_export_option (
51 optionnum int primary key,
52 exportnum int not null,
53 optionname varchar(80) not null,
56 CREATE INDEX part_export_option1 ON part_export_option ( exportnum );
57 CREATE INDEX part_export_option2 ON part_export_option ( optionname );
59 ALTER TABLE cust_bill ADD closed char(1) NULL;
60 ALTER TABLE cust_pay ADD closed char(1) NULL;
61 ALTER TABLE cust_credit ADD closed char(1) NULL;
62 ALTER TABLE cust_refund ADD closed char(1) NULL;
66 Restart Apache and freeside-queued
68 Go to the new "View/Edit Invoice events" in the web interface and add the
69 appropriate events. At the very least, you'll want to set some invoice events
70 "After 0 days": a BILL invoice event to print invoices, a CARD invoice event to
71 batch or run cards real-time, and a COMP invoice event to "pay" complimentary
72 customers. If you were using the -i option to freeside-bill it should be