Added support for relaying to mmsmtpd(8). Did not however write mmrelayd(8)
[mmondor.git] / mmsoftware / mmmail / scripts / upgrade-0.0.24.sql
1 # $Id: upgrade-0.0.24.sql,v 1.5 2004/11/09 05:31:14 mmondor Exp $
2 #
3 # You should execute this script if you are upgrading mmmail from 0.0.21 or
4 # later to 0.0.24 or later. This adds the new mail_file field for those using
5 # file message body storage, and modifies the glob field to allow NULL values.
6 # It also adds the filter table for optional per-box allow filters, and
7 # introduces support for optional relaying and related security.
8 #
9
10 ALTER TABLE mail MODIFY COLUMN mail_data longtext;
11 ALTER TABLE mail ADD COLUMN mail_file varchar(255);
12 ALTER TABLE box ADD COLUMN box_filter tinyint(1) NOT NULL default '0';
13
14 CREATE TABLE filter (
15 filter_address varchar(64) NOT NULL default '',
16 filter_allow varchar(64) NOT NULL default '',
17 KEY filter_address (filter_address),
18 KEY filter_allow (filter_allow)
19 ) TYPE=MyISAM;
20
21 #
22 # Table structure for table 'relayqueue'
23 #
24
25 CREATE TABLE relayqueue (
26 relayqueue_id bigint(20) NOT NULL auto_increment,
27 relayqueue_from varchar(64) NOT NULL default '',
28 relayqueue_ipaddr varchar(16) NOT NULL default '0.0.0.0',
29 relayqueue_to varchar(64) NOT NULL default '',
30 relayqueue_size int(11) NOT NULL default '0',
31 relayqueue_file varchar(255) NOT NULL default '',
32 relayqueue_queued datetime NOT NULL default '0000-00-00 00:00:00',
33 relayqueue_lasttry datetime NOT NULL default '0000-00-00 00:00:00',
34 relayqueue_expire datetime NOT NULL default '0000-00-00 00:00:00',
35 relayqueue_tries int(11) NOT NULL default '0',
36 relayqueue_lasterror int(11) NOT NULL default '0',
37 PRIMARY KEY (relayqueue_id)
38 ) TYPE=MyISAM;
39
40 #
41 # Table structure for table 'relaylocal'
42 #
43
44 CREATE TABLE relaylocal (
45 relaylocal_pattern varchar(64) NOT NULL default '',
46 PRIMARY KEY (relaylocal_pattern)
47 ) TYPE=MyISAM;
48
49 #
50 # Table structure for table 'relayfrom'
51 #
52
53 CREATE TABLE relayfrom (
54 relayfrom_pattern varchar(64) NOT NULL default '',
55 PRIMARY KEY (relayfrom_pattern)
56 ) TYPE=MyISAM;