X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=httemplate%2Fdocs%2Fupgrade8.html;h=874a9de7e2ef716d316c083ef972a980b5d21409;hb=239484572a9191100993bb1e85ffe8834689feb0;hp=61d956ce81443bf112402fc77929573a08a6e82e;hpb=7e3eb82f87c371785544b706b7347c7edde2b593;p=freeside.git
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 61d956ce8..874a9de7e 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, 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,
@@ -157,14 +162,14 @@ CREATE TABLE part_export (
CREATE INDEX part_export1 ON part_export ( machine );
CREATE INDEX part_export2 ON part_export ( exporttype );
-CREATE INDEX part_export_option (
+CREATE TABLE 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;
@@ -183,6 +188,8 @@ 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;
+ALTER TABLE cust_bill_event ADD status varchar(80);
+ALTER TABLE cust_bill_event ADD statustext text NULL;
CREATE INDEX cust_main3 ON cust_main ( referral_custnum );
CREATE INDEX cust_credit_bill1 ON cust_credit_bill ( crednum );
CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum );
@@ -298,6 +305,8 @@ ALTER TABLE cust_refund DROP COLUMN crednum;
IMPORTANT: After applying the second set of database changes, run bin/dbdef-create again.
+ IMPORTANT: run bin/create-history-tables
+ IMPORTANT: After running bin/create-history-tables, run bin/dbdef-create again.
set the user_policy configuration value as appropriate for your site.
Create the `/usr/local/etc/freeside/cache.datasrc' directory
(ownded by the freeside user).