1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
-- $Horde: sam/scripts/sql/amavisd_sql.mysql.sql,v 1.3 2005/07/01 01:10:50 selsky Exp $
-- local users
CREATE TABLE users (
id INT UNSIGNED NOT NULL auto_increment,
policy_id INT UNSIGNED DEFAULT '1' NOT NULL,
email VARCHAR(255) NOT NULL,
PRIMARY KEY (id),
KEY email (email)
);
CREATE UNIQUE INDEX users_idx_email ON users(email);
-- any e-mail address, external or local, used as senders in wblist
CREATE TABLE mailaddr (
id INT UNSIGNED NOT NULL auto_increment,
email VARCHAR(255) NOT NULL,
PRIMARY KEY (id),
KEY email (email)
);
CREATE UNIQUE INDEX mailaddr_idx_email ON mailaddr(email);
-- per-recipient whitelist and/or blacklist,
-- puts sender and recipient in relation wb (white or blacklisted sender)
CREATE TABLE wblist (
rid INT UNSIGNED NOT NULL, -- recipient: users.id
sid INT UNSIGNED NOT NULL, -- sender: mailaddr.id
wb CHAR(1) NOT NULL, -- W or Y / B or N
PRIMARY KEY (rid,sid)
);
CREATE TABLE policy (
id INT UNSIGNED NOT NULL auto_increment,
policy_name VARCHAR(255), -- not used by amavisd-new
virus_lover CHAR(1), -- Y/N
spam_lover CHAR(1), -- Y/N (optional field)
banned_files_lover CHAR(1), -- Y/N (optional field)
bad_header_lover CHAR(1), -- Y/N (optional field)
bypass_virus_checks CHAR(1), -- Y/N
bypass_spam_checks CHAR(1), -- Y/N
bypass_banned_checks CHAR(1), -- Y/N (optional field)
bypass_header_checks CHAR(1), -- Y/N (optional field)
spam_modifies_subj CHAR(1), -- Y/N (optional field)
spam_quarantine_to VARCHAR(64) DEFAULT NULL, -- (optional field)
spam_tag_level FLOAT, -- higher score inserts spam info headers
spam_tag2_level FLOAT DEFAULT NULL, -- higher score inserts
-- 'declared spam' info header fields
spam_kill_level FLOAT, -- higher score activates evasive actions, e.g.
-- reject/drop, quarantine, ...
-- (subject to final_spam_destiny setting)
addr_extension_spam VARCHAR(32), -- extension to add to the localpart of an
-- address for detected spam
addr_extension_virus VARCHAR(32), -- extension to add to the localpart of an
-- address for detected viruses
addr_extension_banned VARCHAR(32), -- extension to add to the localpart of an
-- address for detected banned files
PRIMARY KEY (id)
);
CREATE UNIQUE INDEX policy_idx_policy_name ON policy(policy_name);
|
