1 the following is necessary to upgrade from 1.4.0pre (4 thru 7) to 1.4.0pre8
3 install the perl modules and httemplate as per install.html or upgrade8.html
5 ALTER TABLE part_pkg ADD disabled char(1) NULL;
6 ALTER TABLE part_svc ADD disabled char(1) NULL;
8 CREATE TABLE cust_bill_events (
9 eventnum int primary key,
11 eventpart int not null,
14 CREATE UNIQUE INDEX cust_bill_events1 ON cust_bill_events ( eventpart, invnum );
15 CREATE INDEX cust_bill_events2 ON cust_bill_events ( invnum );
17 CREATE TABLE part_bill_events (
18 eventpart int primary key,
19 payby char(4) not null,
20 event varchar(80) not null,
23 disabled char(1) null,
25 CREATE INDEX part_bill_events1 ON part_bill_events ( payby );
29 Restart Apache and freeside-queued