X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=b0d1e3fe2e597c87887e59000ea09c0ca2199d87;hb=5364c3dfb131a502b0613eb59a0451165f09c267;hp=022d1f6ae237a9a277d0edfbf40c4a19dc269201;hpb=d9d79aeecc2c0d79bd1d066a702252ffd683661e;p=freeside.git
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 022d1f6ae..b0d1e3fe2 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -7,7 +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 Time-Duration, Tie-IxHash and HTML-Widgets-SelectLayers.
Install Apache::ASP or HTML::Mason.
+ Install rsync
@@ -104,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,
@@ -114,6 +120,14 @@ CREATE TABLE queue_arg (
);
CREATE INDEX queue_arg1 ON queue_arg ( jobnum );
+CREATE TABLE queue_depend (
+ dependnum int primary key,
+ jobnum int not null,
+ depend_jobnum int not null
+);
+CREATE INDEX queue_depend1 ON queue_depend ( jobnum );
+CREATE INDEX queue_depend2 ON queue_depend ( depend_jobnum );
+
CREATE TABLE part_pop_local (
localnum int primary key,
popnum int not null,
@@ -146,9 +160,17 @@ CREATE TABLE part_bill_event (
);
CREATE INDEX part_bill_event1 ON part_bill_event ( payby );
+CREATE TABLE export_svc (
+ exportsvcnum int primary key,
+ exportnum int not null,
+ svcpart int not null
+);
+CREATE UNIQUE INDEX export_svc1 ON export_svc ( exportnum, svcpart );
+CREATE INDEX export_svc2 ON export_svc ( exportnum );
+CREATE INDEX export_svc3 ON export_svc ( svcpart );
+
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
@@ -156,14 +178,40 @@ 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 );
+
+CREATE TABLE radius_usergroup (
+ usergroupnum int primary key,
+ svcnum int not null,
+ groupname varchar(80) not null
+);
+CREATE INDEX radius_usergroup1 ON radius_usergroup ( svcnum );
+CREATE INDEX radius_usergroup2 ON radius_usergroup ( groupname );
+
+CREATE TABLE msgcat (
+ msgnum int primary key,
+ msgcode varchar(80) not null,
+ locale varchar(16) not null,
+ msg text not null
+);
+CREATE INDEX msgcat1 ON msgcat ( msgcode, locale );
+
+CREATE TABLE cust_tax_exempt (
+ exemptnum int primary key,
+ custnum int not null,
+ taxnum int not null,
+ year int not null,
+ month int not null,
+ amount decimal(10,2)
+);
+CREATE UNIQUE INDEX cust_tax_exempt1 ON cust_tax_exempt ( taxnum, year, month );
ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
ALTER TABLE svc_domain ADD catchall integer NULL;
@@ -182,6 +230,12 @@ 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;
+ALTER TABLE svc_acct ADD sec_phrase varchar(80) NULL;
+ALTER TABLE part_pkg ADD taxclass varchar(80) NULL;
+ALTER TABLE cust_main_county ADD taxclass varchar(80) NULL;
+ALTER TABLE cust_main_county ADD exempt_amount decimal(10,2);
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 );
@@ -191,6 +245,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:
@@ -294,10 +351,33 @@ 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.
+ As the freeside UNIX user, run bin/populate-msgcat username to populate the message catalog, passing the username of a Freeside user you c
+reated above:
+
+$ su freeside
+$ bin/populate-msgcat username
+
set the user_policy configuration value as appropriate for your site.
+ set the locale configuration value to en_US.
+ the mxmachines, nsmachines, arecords and cnamerecords configuration values have been deprecated. Set the defaultrecords configuration value instead.
Create the `/usr/local/etc/freeside/cache.datasrc' directory
- (ownded by the freeside user).
+ (owned 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.
+ If you would like Freeside to notify your customers when their credit
+ cards and other billing arrangements are about to expire, arrange for
+ freeside-expiration-alerter to be run daily by cron or similar
+ facility. The message it sends can be configured from the
+ Configuration choice of the main menu as alerter_template.
+ Export has been rewritten. If you were using the icradiusmachines,
+ icradius_mysqldest, icradius_mysqlsource, or icradius_secrets files, add
+ an appropriate "sqlradius" export to all relevant Service Definitions
+ instead. Use MySQL replication or
+ point the "sqlradius" export directly at your external ICRADIUS or FreeRADIUS
+ database (or through an SSL-necrypting proxy...)