Begin;

alter table company add column xfer_rec_url varchar(256) NOT NULL DEFAULT '',
                    add column xfer_rec_host varchar(128) NOT NULL DEFAULT '',
                    add column xfer_rec_user varchar(32) NOT NULL DEFAULT '',
                    add column xfer_rec_pwd  varchar(32) NOT NULL DEFAULT '',
                    add column xfer_rec_dir varchar(256) NOT NULL DEFAULT '.',
                    add column xfer_rec_sched varchar(8) NOT NULL DEFAULT 'daily'
                       CHECK (xfer_rec_sched IN ('monthly', 'weekly', 'daily'));

Commit;

