Hi,
>you tryed them? Have you applied them?
Shure i did.
>Could you please run and post the output of:
Here we go
CREATE TABLE `dspam_preferences` (
`uid` int(10) unsigned NOT NULL,
`preference` varchar(32) COLLATE latin1_general_ci NOT NULL,
`value` varchar(64) COLLATE latin1_general_ci NOT NULL,
UNIQUE KEY `id_preferences_01` (`uid`,`preference`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
CREATE TABLE `dspam_signature_data` (
`uid` int(10) unsigned NOT NULL,
`signature` char(32) COLLATE utf8_unicode_ci NOT NULL,
`data` longblob NOT NULL,
`length` int(10) unsigned NOT NULL,
`created_on` date NOT NULL,
UNIQUE KEY `id_signature_data_01` (`uid`,`signature`),
KEY `id_signature_data_02` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE `dspam_stats` (
`uid` int(10) unsigned NOT NULL,
`spam_learned` bigint(20) unsigned NOT NULL,
`innocent_learned` bigint(20) unsigned NOT NULL,
`spam_misclassified` bigint(20) unsigned NOT NULL,
`innocent_misclassified` bigint(20) unsigned NOT NULL,
`spam_corpusfed` bigint(20) unsigned NOT NULL,
`innocent_corpusfed` bigint(20) unsigned NOT NULL,
`spam_classified` bigint(20) unsigned NOT NULL,
`innocent_classified` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE `dspam_token_data` (
`uid` int(10) unsigned NOT NULL,
`token` char(20) COLLATE utf8_unicode_ci NOT NULL,
`spam_hits` bigint(20) unsigned NOT NULL,
`innocent_hits` bigint(20) unsigned NOT NULL,
`last_hit` date NOT NULL,
UNIQUE KEY `id_token_data_01` (`uid`,`token`),
KEY `spam_hits` (`spam_hits`,`innocent_hits`),
KEY `last_hit` (`last_hit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
dspam_virtual_uids CREATE TABLE `dspam_virtual_uids` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(128) COLLATE latin1_general_ci DEFAULT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `id_virtual_uids_01` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Dspam-devel mailing list
Dspam-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-devel
