-- sql/configuration.sql
-- This file is part of Decimail; see http://decimail.org
-- (C) 2004-2007 Philip Endecott
 
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 2 of the License, or
-- any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

drop table configuration;

begin;


-- The configuration table stores settings for the daemons.  Some of
-- these must be set, others may be set to override the defaults.

create table configuration (
	variable	text	not null,
	type		text	not null,
	value		text	not null
);


-- Port number that the SMTP daemon listens on.  Default is 25; set
-- this if you want it to listen on a different port.  You might want to
-- set this if you are using Decimail alongside another MTA.

-- insert into configuration (variable,type,value)
-- 	values ('smtpd_incoming_port', 'number', '2525');


-- "Smart host" for outgoing messages.  The Decimail smtpd forwards
-- all messages for non-local recipients to this host on port 25.
-- There is no default, you must set this.

insert into configuration (variable,type,value)
	values ('smtpd_outgoing_smarthost', 'hostname', 'smtp.ntlworld.com');


-- Port number that the IMAP daemon listens on.  Default is 143; set
-- this if you want it to listen on a different port.  You might want to
-- set this if you are using Decimail alongside another IMAP server.

-- insert into configuration (variable,type,value)
-- 	values ('imapd_port', 'number', '2525');


-- Enable IMAP logging?  This is useful for debugging IMAP protocol
-- problems, but otherwise uses vast amounts of syslog space.

-- insert into configuration (variable,type,value)
-- 	values ('imapd_log_imap', 'boolean', 'true');


-- Enable SMTP logging for incoming messages?  Ditto.

-- insert into configuration (variable,type,value)
-- 	values ('smtpd_log_conversation', 'boolean', 'true');


-- Directiory for storing message backups.  You must set  this.
-- The pathname must end in a /.

insert into configuration (variable,type,value)
	values ('message_backup_dir','pathname','/var/local/decimail/messages');


end;