| @@ -1,12 +1,12 @@
CREATE TABLE `quarantine_log` (
`id` int(11) NOT NULL auto_increment,
- `nowtime` varchar(150) collate latin1_german1_ci NOT NULL default '',
- `returnpath` varchar(80) collate latin1_german1_ci NOT NULL default '',
- `receips` varchar(80) collate latin1_german1_ci NOT NULL default '',
+ `nowtime` varchar(150) collate latin1_german1_ci NOT NULL default '',
+ `returnpath` varchar(80) collate latin1_german1_ci NOT NULL default '',
+ `receips` varchar(80) collate latin1_german1_ci NOT NULL default '',
`subject` varchar(255) collate latin1_german1_ci NOT NULL default '',
- `description` varchar(50) collate latin1_german1_ci NOT NULL default '',
- `scaninfo` varchar(100) collate latin1_german1_ci NOT NULL default '',
- UNIQUE KEY `id` (`id`),
+ `description` varchar(50) collate latin1_german1_ci NOT NULL default '',
+ `scaninfo` varchar(100) collate latin1_german1_ci NOT NULL default '',
+ UNIQUE KEY `id` (`id`),
KEY `quarIdx` (`nowtime`,`returnpath`,`receips`,`description`,`scaninfo`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
+) ENGINE=INNODB;
|
