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
|
-- $Id: mysql_objects-4.1.sql,v 1.43 2011/05/09 22:58:48 sbajic Exp $
--
-- This file contains statements for creating the DSPAM
-- database objects for MySQL 4.1 or greater.
--
create table dspam_token_data (
uid int unsigned not null,
token bigint unsigned not null,
spam_hits bigint unsigned not null,
innocent_hits bigint unsigned not null,
last_hit date not null
) engine=MyISAM default charset=latin1 collate=latin1_general_ci pack_keys=1;
create unique index id_token_data_01 on dspam_token_data(uid,token);
create table dspam_signature_data (
uid int unsigned not null,
signature char(32) COLLATE latin1_general_ci not null,
data longblob not null,
length int unsigned not null,
created_on date not null
) engine=MyISAM default charset=latin1 collate=latin1_general_ci max_rows=2500000 avg_row_length=8096;
create unique index id_signature_data_01 on dspam_signature_data(uid,signature);
create index id_signature_data_02 on dspam_signature_data(created_on);
create table dspam_stats (
uid int unsigned primary key,
spam_learned bigint unsigned not null,
innocent_learned bigint unsigned not null,
spam_misclassified bigint unsigned not null,
innocent_misclassified bigint unsigned not null,
spam_corpusfed bigint unsigned not null,
innocent_corpusfed bigint unsigned not null,
spam_classified bigint unsigned not null,
innocent_classified bigint unsigned not null
) engine=MyISAM default charset=latin1 collate=latin1_general_ci;
create table dspam_preferences (
uid int unsigned not null,
preference varchar(32) COLLATE latin1_general_ci not null,
value varchar(64) COLLATE latin1_general_ci not null
) engine=MyISAM default charset=latin1 collate=latin1_general_ci;
create unique index id_preferences_01 on dspam_preferences(uid, preference);
|
