1# $Id: mysql_objects-space.sql,v 1.32 2011/05/09 22:46:09 sbajic Exp $
2
3-- ---------------------------------------------------------------------------
4--  ! ! ! ! ! ! ! THIS FILE SHOULD ONLY BE USED ON MYSQL < 4.1 ! ! ! ! ! ! !
5--  ! ! ! ! ! FOR MYSQL 4.1+ PLEASE USE mysql_objects-4.1.sql FILE ! ! ! ! !
6-- ---------------------------------------------------------------------------
7
8create table dspam_token_data (
9  uid int unsigned not null,
10  token varchar(20) not null,
11  spam_hits bigint unsigned not null,
12  innocent_hits bigint unsigned not null,
13  last_hit date not null
14) engine=MyISAM;
15
16create unique index id_token_data_01 on dspam_token_data(uid,token);
17
18create table dspam_signature_data (
19  uid int unsigned not null,
20  signature varchar(32) not null,
21  data longblob not null,
22  length int unsigned not null,
23  created_on date not null
24) engine=MyISAM;
25
26create unique index id_signature_data_01 on dspam_signature_data(uid,signature);
27create index id_signature_data_02 on dspam_signature_data(created_on);
28
29create table dspam_stats (
30  uid int unsigned primary key not null,
31  spam_learned bigint unsigned not null,
32  innocent_learned bigint unsigned not null,
33  spam_misclassified bigint unsigned not null,
34  innocent_misclassified bigint unsigned not null,
35  spam_corpusfed bigint unsigned not null,
36  innocent_corpusfed bigint unsigned not null,
37  spam_classified bigint unsigned not null,
38  innocent_classified bigint unsigned not null
39) engine=MyISAM;
40
41create table dspam_preferences (
42  uid int unsigned not null,
43  preference varchar(32) not null,
44  value varchar(64) not null
45) engine=MyISAM;
46
47create unique index id_preferences_01 on dspam_preferences(uid, preference);
48