diff options
| author | LukenShiro <lukenshiro@ngi.it> | 2010-05-13 00:38:18 +0200 |
|---|---|---|
| committer | David Somero <xgizzmo@slackbuilds.org> | 2010-05-13 00:38:18 +0200 |
| commit | d755c90cf3358b54b62b671972259ff9a3757882 (patch) | |
| tree | 31880758f690482c076de243e6dd25503b824d44 /network/spamassassin/spamassassin-db.sql | |
| parent | cd3c2891edd50e9b4536626c6955715621f0a791 (diff) | |
| download | slackbuilds-d755c90cf3358b54b62b671972259ff9a3757882.tar.gz | |
network/spamassassin: Updated for version 3.3.0
Diffstat (limited to 'network/spamassassin/spamassassin-db.sql')
| -rw-r--r-- | network/spamassassin/spamassassin-db.sql | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/network/spamassassin/spamassassin-db.sql b/network/spamassassin/spamassassin-db.sql new file mode 100644 index 0000000000..44b9818eba --- /dev/null +++ b/network/spamassassin/spamassassin-db.sql @@ -0,0 +1,64 @@ +CREATE TABLE awl ( + username varchar(100) NOT NULL default '', + email varchar(255) NOT NULL default '', + ip varchar(40) NOT NULL default '', + count int(11) NOT NULL default '0', + totscore float NOT NULL default '0', + signedby varchar(255) NOT NULL default '', + PRIMARY KEY (username,email,signedby,ip) +) TYPE=InnoDB; + +CREATE TABLE userpref ( + username varchar(100) NOT NULL default '', + preference varchar(50) NOT NULL default '', + value varchar(100) NOT NULL default '', + prefid int(11) NOT NULL auto_increment, + PRIMARY KEY (prefid), + KEY username (username) +) TYPE=InnoDB; + +CREATE TABLE bayes_expire ( + id int(11) NOT NULL default '0', + runtime int(11) NOT NULL default '0', + KEY bayes_expire_idx1 (id) +) TYPE=InnoDB; + +CREATE TABLE bayes_global_vars ( + variable varchar(30) NOT NULL default '', + value varchar(200) NOT NULL default '', + PRIMARY KEY (variable) +) TYPE=InnoDB; + +INSERT INTO bayes_global_vars VALUES ('VERSION','3'); + +CREATE TABLE bayes_seen ( + id int(11) NOT NULL default '0', + msgid varchar(200) binary NOT NULL default '', + flag char(1) NOT NULL default '', + PRIMARY KEY (id,msgid) +) TYPE=InnoDB; + +CREATE TABLE bayes_token ( + id int(11) NOT NULL default '0', + token char(5) NOT NULL default '', + spam_count int(11) NOT NULL default '0', + ham_count int(11) NOT NULL default '0', + atime int(11) NOT NULL default '0', + PRIMARY KEY (id, token), + INDEX bayes_token_idx1 (id, atime) +) TYPE=InnoDB; + +CREATE TABLE bayes_vars ( + id int(11) NOT NULL AUTO_INCREMENT, + username varchar(200) NOT NULL default '', + spam_count int(11) NOT NULL default '0', + ham_count int(11) NOT NULL default '0', + token_count int(11) NOT NULL default '0', + last_expire int(11) NOT NULL default '0', + last_atime_delta int(11) NOT NULL default '0', + last_expire_reduce int(11) NOT NULL default '0', + oldest_token_age int(11) NOT NULL default '2147483647', + newest_token_age int(11) NOT NULL default '0', + PRIMARY KEY (id), + UNIQUE bayes_vars_idx1 (username) +) TYPE=InnoDB; |