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;