| @@ -0,0 +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 '',
+ `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`),
+ KEY `quarIdx` (`nowtime`,`returnpath`,`receips`,`description`,`scaninfo`)
+ ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci;
+
|
