1
2
3
4
5
6
7
8

CREATE TABLE `spamfilter_preferences` (
  `prefid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `spamfilter_id` int(10) unsigned NOT NULL,
  `preference` varchar(30) CHARACTER SET ascii NOT NULL DEFAULT '',
  `value` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`prefid`),
  KEY `spamfilter_id` (`spamfilter_id`,`preference`,`value`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1

CREATE TABLE `spamfilter_preferences` ( `prefid` int(10) unsigned NOT NULL AUTO_INCREMENT, `spamfilter_id` int(10) unsigned NOT NULL, `preference` varchar(30) CHARACTER SET ascii NOT NULL DEFAULT '', `value` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', PRIMARY KEY (`prefid`), KEY `spamfilter_id` (`spamfilter_id`,`preference`,`value`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1