mirror of
https://git.proxmox.com/git/proxmox-spamassassin
synced 2025-04-29 12:36:23 +00:00
47 lines
1.4 KiB
SQL
47 lines
1.4 KiB
SQL
|
|
CREATE TABLE bayes_expire (
|
|
id int(11) NOT NULL default '0',
|
|
runtime int(11) NOT NULL default '0',
|
|
PRIMARY KEY (id)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE bayes_global_vars (
|
|
variable varchar(30) NOT NULL default '',
|
|
value varchar(200) NOT NULL default '',
|
|
PRIMARY KEY (variable)
|
|
) ENGINE=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)
|
|
) ENGINE=InnoDB;
|
|
|
|
CREATE TABLE bayes_token (
|
|
id int(11) NOT NULL default '0',
|
|
token binary(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)
|
|
) ENGINE=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)
|
|
) ENGINE=InnoDB;
|