X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=e110416824f62338bb449e06eee649f69e8a88f8;hb=6caffaefb96e25c68866825e2211816355a656aa;hp=daf73a1a348df065df478791fcaa22fd285fd01a;hpb=65f2a86b2c239782f209b481744915f858530598;p=freeside.git
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index daf73a1a3..e11041682 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -7,8 +7,9 @@
If migrating from less than 1.3.1, see these instructions first.
Backup your database and current Freeside installation. (with PostgreSQL) (with MySQL)
mod_perl is now required.
- Install Archive-Tar, Time-Duration, DBIx-DataSource, and Tie-IxHash
+ Install Time-Duration, and Tie-IxHash
Install Apache::ASP or HTML::Mason.
+ Install rsync
@@ -105,8 +106,12 @@ CREATE TABLE queue (
jobnum int primary key,
job text not null,
_date int not null,
- status varchar(80) not null
+ status varchar(80) not null,
+ statustext text null,
+ svcnum int null
);
+CREATE INDEX queue1 ON queue ( svcnum );
+CREATE INDEX queue2 ON queue ( status );
CREATE TABLE queue_arg (
argnum int primary key,
@@ -160,11 +165,11 @@ CREATE INDEX part_export2 ON part_export ( exporttype );
CREATE INDEX part_export_option (
optionnum int primary key,
exportnum int not null,
- option varchar(80) 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 ( option );
+CREATE INDEX part_export_option2 ON part_export_option ( optionname );
ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
ALTER TABLE svc_domain ADD catchall integer NULL;
@@ -192,6 +197,9 @@ CREATE INDEX cust_credit_refund1 ON cust_credit_refund ( crednum );
CREATE INDEX cust_credit_refund2 ON cust_credit_refund ( refundnum );
CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum );
CREATE UNIQUE INDEX part_svc_column1 ON part_svc_column ( svcpart, columnname );
+CREATE INDEX cust_pay2 ON cust_pay ( paynum );
+CREATE INDEX cust_pay3 ON cust_pay ( custnum );
+CREATE INDEX cust_pay4 ON cust_pay ( paybatch );
If you are using PostgreSQL, apply the following changes to your database:
@@ -299,6 +307,7 @@ ALTER TABLE cust_refund DROP COLUMN crednum;
Create the `/usr/local/etc/freeside/cache.datasrc' directory
(ownded by the freeside user).
freeside-queued was installed with the Perl modules. Start it now and ensure that is run upon system startup.
- Set appropriate invoice events for your site. 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.
+ Set appropriate invoice events for your site. 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.
+ Use freeside-daily instead of freeside-bill.