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 the perl modules and httemplate as per install.html or upgrade8.html
13 ALTER TABLE part_pkg ADD disabled char(1) NULL;
14 ALTER TABLE part_svc ADD disabled char(1) NULL;
16 CREATE TABLE cust_bill_event (
17 eventnum int primary key,
19 eventpart int not null,
22 CREATE UNIQUE INDEX cust_bill_events1 ON cust_bill_events ( eventpart, invnum );
23 CREATE INDEX cust_bill_events2 ON cust_bill_events ( invnum );
25 CREATE TABLE part_bill_event (
26 eventpart int primary key,
27 payby char(4) not null,
28 event varchar(80) not null,
31 disabled char(1) null,
33 CREATE INDEX part_bill_events1 ON part_bill_events ( payby );
35 CREATE TABLE part_export (
36 exportnum int primary key,
38 machine varchar(80) not null,
39 exporttype varchar(80) not null,
42 CREATE INDEX part_export1 ON part_export ( machine );
43 CREATE INDEX part_export2 ON part_export ( exporttype );
45 CREATE INDEX part_export_option (
46 optionnum int primary key,
47 exportnum int not null,
48 option varchar(80) not null,
51 CREATE INDEX part_export_option1 ON part_export ( exportnum );
52 CREATE INDEX part_export_option2 ON part_export ( option );
54 ALTER TABLE cust_bill ADD closed char(1) NULL;
55 ALTER TABLE cust_pay ADD closed char(1) NULL;
56 ALTER TABLE cust_credit ADD closed char(1) NULL;
57 ALTER TABLE cust_refund ADD closed char(1) NULL;
61 Restart Apache and freeside-queued