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