+++ /dev/null
-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.
-