On Sun, 1 Aug 2010 21:03:10 +0200 (CEST)
"Imposit.com - webmaster" <[email protected]> wrote:
>
>
> 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
It's strange. I don't see any constrains. I just created the tables on a test
instance and applied those constrains and then executed the commands and this
is the output I get:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
mysql> show create table admin_dspam.dspam_preferences\G;
*************************** 1. row ***************************
Table: dspam_preferences
Create Table: 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
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show create table admin_dspam.dspam_signature_data\G;
*************************** 1. row ***************************
Table: dspam_signature_data
Create Table: CREATE TABLE `dspam_signature_data` (
`uid` int(10) unsigned NOT NULL,
`signature` varchar(32) COLLATE latin1_general_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`),
CONSTRAINT `dspam_signature_data_ibfk_1` FOREIGN KEY (`uid`) REFERENCES
`dspam_virtual_uids` (`uid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
MAX_ROWS=2500000 AVG_ROW_LENGTH=8096
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show create table admin_dspam.dspam_stats\G;
*************************** 1. row ***************************
Table: dspam_stats
Create Table: 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`),
CONSTRAINT `dspam_stats_ibfk_1` FOREIGN KEY (`uid`) REFERENCES
`dspam_virtual_uids` (`uid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show create table admin_dspam.dspam_token_data\G;
*************************** 1. row ***************************
Table: dspam_token_data
Create Table: CREATE TABLE `dspam_token_data` (
`uid` int(10) unsigned NOT NULL,
`token` bigint(20) unsigned 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`),
CONSTRAINT `dspam_token_data_ibfk_1` FOREIGN KEY (`uid`) REFERENCES
`dspam_virtual_uids` (`uid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci PACK_KEYS=1
1 row in set (0.00 sec)
ERROR:
No query specified
mysql> show create table admin_dspam.dspam_virtual_uids\G;
*************************** 1. row ***************************
Table: dspam_virtual_uids
Create Table: CREATE TABLE `dspam_virtual_uids` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `id_virtual_uids_01` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci
1 row in set (0.00 sec)
ERROR:
No query specified
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-devel
