X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=a7b5853b3bdc50688fe6c9a3701c44c05d85b256;hp=bbb528cdae4497af826f8d831b3eaa8ee7e270c2;hb=87af741da0dd5f6a76bbb566b4d6c54cd5b15315;hpb=1aa750eba2b9b73b4f09f28b9acd748ee3669bd4 diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index bbb528cda..a7b5853b3 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -6,7 +6,10 @@ @@ -33,7 +36,6 @@ PerlSetVar Global /usr/local/etc/freeside/asp-global/
    -
  • NOTE: Mason support is still a bit buggy in the 1.4.0 prereleases. This will be fixed before 1.4.0. You have been warned.
  • Run make masondocs
  • Copy masondocs/ to your web server's document space.
  • Copy htetc/handler.pl to your web server's configuration directory. @@ -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, @@ -128,7 +134,7 @@ CREATE TABLE cust_bill_event ( eventnum int primary key, invnum int not null, eventpart int not null, - _date 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 ); @@ -139,7 +145,10 @@ CREATE TABLE part_bill_event ( event varchar(80) not null, eventcode text null, seconds int null, - disabled char(1) 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 ); @@ -153,14 +162,30 @@ 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 ( exportnum ); -CREATE INDEX part_export_option2 ON part_export ( option ); +CREATE INDEX part_export_option1 ON part_export_option ( exportnum ); +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 ); ALTER TABLE svc_acct ADD domsvc integer NOT NULL; ALTER TABLE svc_domain ADD catchall integer NULL; @@ -179,6 +204,9 @@ 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; 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 ); @@ -188,6 +216,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: @@ -291,9 +322,25 @@ 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. +
  • 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. 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...)