@@ -36,6 +36,7 @@ PerlSetVar Global /usr/local/etc/freeside/asp-global/
+ - (use version 1.0x - Freeside is not yet compatible with version 1.1x)
- Run make masondocs
- Copy masondocs/ to your web server's document space.
- Copy htetc/handler.pl to your web server's configuration directory.
@@ -69,6 +70,12 @@ CREATE TABLE svc_forward (
dst varchar(80),
PRIMARY KEY (svcnum)
);
+ALTER TABLE part_svc ADD svc_forward__srcsvc varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_forward__srcsvc_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_forward__dstsvc varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL;
+ALTER TABLE part_svc ADD svc_forward__dst varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL;
CREATE TABLE cust_credit_bill (
creditbillnum int primary key,
@@ -213,7 +220,9 @@ CREATE TABLE cust_tax_exempt (
);
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_acct ADD domsvc integer NULL;
+ALTER TABLE part_svc ADD svc_acct__domsvc varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL;
ALTER TABLE svc_domain ADD catchall integer NULL;
ALTER TABLE cust_main ADD referral_custnum integer NULL;
ALTER TABLE cust_main ADD comments text NULL;
@@ -234,6 +243,8 @@ 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_svc ADD svc_acct__sec_phrase varchar(80) NULL;
+ALTER TABLE part_svc ADD svc_acct__sec_phrase_flag char(1) 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);
@@ -304,6 +315,12 @@ CREATE INDEX cust_main5 ON cust_main ( ship_company );
- Create a service definition with table svc_forward
- Run bin/fs-migrate-svc_acct_sm username
+ Or if you just have svc_acct records:
+
+ - Order and provision a package for your default domain and note down the Service # or svcnum.
+
- UPDATE svc_acct SET domsvc = svcnum
+
- Update your service definitions to have default (or fixed) domsvc.
+
Run bin/fs-migrate-payrefusername
Run bin/fs-migrate-part_svcusername
After running bin/fs-migrate-payref, apply the following changes to your database:
@@ -352,7 +369,7 @@ ALTER TABLE cust_refund DROP COLUMN crednum;
IMPORTANT: After running bin/create-history-tables, run bin/dbdef-create username again.
As the freeside UNIX user, run bin/populate-msgcat username to populate the message catalog
- 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
|