From 4d513ff5a17bd3b697502b54c9516577a0a8d3e4 Mon Sep 17 00:00:00 2001 From: jeff Date: Sun, 12 Aug 2001 19:41:26 +0000 Subject: merging vpopmail support branch --- httemplate/docs/upgrade8.html | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) (limited to 'httemplate/docs/upgrade8.html') diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html index 702da5a1b..1a5c998c6 100644 --- a/httemplate/docs/upgrade8.html +++ b/httemplate/docs/upgrade8.html @@ -61,6 +61,30 @@ $ perl Makefile.PL $ make $ su # make install UNINST=1 +
  • Apply the following changes to your database: +
    +CREATE TABLE svc_forward (
    +  svcnum int NOT NULL,
    +  srcsvc int NOT NULL,
    +  dstsvc int NOT NULL,
    +  dst varchar(80),
    +  PRIMARY KEY (svcnum)
    +);
    +ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
    +ALTER TABLE svc_domain ADD catchall integer;
    +ALTER TABLE part_svc ADD svc_acct__domsvc integer NULL;
    +ALTER TABLE part_svc ADD svc_acct__domsvc_flag char(1) NULL;
    +ALTER TABLE part_svc ADD svc_domain__catchall integer NULL;
    +ALTER TABLE part_svc ADD svc_domain__catchall_flag char(1) NULL;
    +ALTER TABLE part_svc ADD svc_forward__srcsvc integer NULL;
    +ALTER TABLE part_svc ADD svc_forward__srcsvc_flag char(1) NULL;
    +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;
    +
    +
    +
  • If you are using PostgreSQL, apply the following changes to your database:
     CREATE UNIQUE INDEX agent_pkey ON agent ( agentnum );
    @@ -112,4 +136,7 @@ ALTER TABLE cust_main ADD COLUMN ship_fax varchar(12) NULL;
     ALTER TABLE cust_main ADD COLUMN comments varchar NULL;
     
  • Run bin/dbdef-create. +
  • create a service based on svc_forward +
  • Run bin/fs-migrate-svc_acct_sm +
  • create the conf.dbsrc/user_policy as appropriate for your site -- cgit v1.2.1