source: npl/mailserver/dspam/initdb.sql @ 83b7f2b

#mysql_objects-4.1.sql:
create database dspamdb;
use dspamdb;

create table dspam_token_data (
  uid smallint unsigned not null,
  token bigint unsigned not null,
  spam_hits int not null,
  innocent_hits int not null,
  last_hit date not null
) ENGINE=MyISAM PACK_KEYS=1;

create unique index id_token_data_01 on dspam_token_data(uid,token);

create table dspam_signature_data (
  uid smallint unsigned not null,
  signature char(32) not null,
  data blob not null,
  length smallint not null,
  created_on date not null
) ENGINE=MyISAM 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 smallint unsigned primary key,
  spam_learned int not null,
  innocent_learned int not null,
  spam_misclassified int not null,
  innocent_misclassified int not null,
  spam_corpusfed int not null,
  innocent_corpusfed int not null,
  spam_classified int not null,
  innocent_classified int not null
) ENGINE=MyISAM;

create table dspam_preferences (
  uid smallint unsigned not null,
  preference varchar(32) not null,
  value varchar(64) not null
) ENGINE=MyISAM;

create unique index id_preferences_01 on dspam_preferences(uid, preference);


#virtual_users.sql:
create table dspam_virtual_uids (
  uid smallint unsigned primary key AUTO_INCREMENT,
  username varchar(128)
) ENGINE=MyISAM;

create unique index id_virtual_uids_01 on dspam_virtual_uids(username);


#de global user:
INSERT INTO `dspam_virtual_uids` VALUES (1,'global');