@@ -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,9 +220,12 @@ 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;
ALTER TABLE cust_pay ADD custnum integer;
ALTER TABLE cust_pay_batch ADD paybatchnum integer;
ALTER TABLE cust_refund ADD custnum integer;
@@ -233,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);
@@ -276,7 +288,6 @@ CREATE UNIQUE INDEX svc_acct_pop_pkey ON svc_acct_pop ( popnum );
CREATE UNIQUE INDEX svc_acct_sm_pkey ON svc_acct_sm ( svcnum );
CREATE UNIQUE INDEX svc_domain_pkey ON svc_domain ( svcnum );
CREATE UNIQUE INDEX svc_www_pkey ON svc_www ( svcnum );
-CREATE UNIQUE INDEX type_pkgs_pkey ON type_pkgs ( typenum );
- If you wish to enable service/shipping addresses, apply the following
changes to your database:
@@ -294,23 +305,24 @@ ALTER TABLE cust_main ADD COLUMN ship_country char(2) NULL;
ALTER TABLE cust_main ADD COLUMN ship_daytime varchar(20) NULL;
ALTER TABLE cust_main ADD COLUMN ship_night varchar(20) NULL;
ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL;
-CREATE INDEX cust_main1 ON cust_main ( ship_last );
-CREATE INDEX cust_main2 ON cust_main ( ship_company );
-
-
- If you wish to enable customer comments, apply the following change to
- your database:
-
-ALTER TABLE cust_main ADD COLUMN comments text NULL;
+CREATE INDEX cust_main4 ON cust_main ( ship_last );
+CREATE INDEX cust_main5 ON cust_main ( ship_company );
- If you are using the signup server, reinstall it according to the instructions. The 1.3.x signup server is not compatible with 1.4.x.
-
- Run bin/dbdef-create.
+
- Run bin/dbdef-create username
- If you have svc_acct_sm records or service definitions:
- Create a service definition with table svc_forward
-
- Run bin/fs-migrate-svc_acct_sm
+
- 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-payref
-
- Run bin/fs-migrate-part_svc
+
- Run bin/fs-migrate-payrefusername
+
- Run bin/fs-migrate-part_svcusername
- After running bin/fs-migrate-payref, apply the following changes to your database:
PostgreSQL | MySQL, others |
@@ -322,9 +334,10 @@ CREATE TABLE cust_pay_temp (
_date int null,
payby char(4) not null,
payinfo varchar(16) null,
- paybatch varchar(80) null
+ paybatch varchar(80) null,
+ closed char(1) null
);
-INSERT INTO cust_pay_temp SELECT * from cust_pay;
+INSERT INTO cust_pay_temp SELECT paynum, custnum, paid, _date, payby, payinfo, paybatch, closed FROM cust_pay;
DROP TABLE cust_pay;
ALTER TABLE cust_pay_temp RENAME TO cust_pay;
CREATE UNIQUE INDEX cust_pay1 ON cust_pay (paynum);
@@ -337,9 +350,10 @@ CREATE TABLE cust_refund_temp (
reason varchar(80) not null,
payby char(4) not null,
payinfo varchar(16) null,
- paybatch varchar(80) null
+ paybatch varchar(80) null,
+ closed char(1) null
);
-INSERT INTO cust_refund_temp SELECT * from cust_refund;
+INSERT INTO cust_refund_temp SELECT refundnum, custnum, _date, refund, otaker, reason, payby, payinfo, '', closed from cust_refund;
DROP TABLE cust_refund;
ALTER TABLE cust_refund_temp RENAME TO cust_refund;
CREATE UNIQUE INDEX cust_refund1 ON cust_refund (refundnum);
@@ -350,17 +364,12 @@ ALTER TABLE cust_pay DROP COLUMN invnum;
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.
+
- IMPORTANT: After applying the second set of database changes, run bin/dbdef-create username again.
+
- IMPORTANT: run bin/create-history-tables username
+
- 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 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
|