X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fupgrade8.html;h=dfbe6a2535c63362b919e3d5815865c2c9206ab5;hp=1a5c998c6b2a513a4477c32772fecca377cfc2f2;hb=5e99168da38e7616fc726242ce7d85e140f22c6f;hpb=4d513ff5a17bd3b697502b54c9516577a0a8d3e4 diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 1a5c998c6..dfbe6a253 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -82,7 +82,8 @@ ALTER TABLE part_svc ADD svc_forward__dstsvc integer NULL; ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL; ALTER TABLE part_svc ADD svc_forward__dst integer NULL; ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL; - +ALTER TABLE cust_main ADD referral_custnum integer NULL; +CREATE INDEX cust_main3 ON cust_main ( referral_custnum );
  • If you are using PostgreSQL, apply the following changes to your database: @@ -129,12 +130,15 @@ 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 varchar NULL;
     
    +
  • 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.
  • create a service based on svc_forward
  • Run bin/fs-migrate-svc_acct_sm