summaryrefslogtreecommitdiff
path: root/network/spamassassin/spamassassin-db.sql
diff options
context:
space:
mode:
Diffstat (limited to 'network/spamassassin/spamassassin-db.sql')
-rw-r--r--network/spamassassin/spamassassin-db.sql64
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;