-- MySQL dump 9.11
--
-- Host: localhost    Database: system
-- ------------------------------------------------------
-- Server version	4.0.22-log

--
-- Table structure for table `log_mail_postfix`
--

CREATE TABLE `log_mail_postfix` (
  `id` int(11) NOT NULL auto_increment,
  `created` datetime default NULL,
  `hostname` varchar(255) default NULL,
  `log_level` varchar(10) default NULL,
  `process_name` varchar(14) default NULL,
  `pid` smallint(5) unsigned NOT NULL default '0',
  `postfix_key` varchar(12) default NULL,
  `new_postfix_key` varchar(12) default NULL,
  `client_hostname` varchar(255) default NULL,
  `client_ip` varchar(15) default NULL,
  `client_uid` smallint(5) unsigned default NULL,
  `message_id` varchar(255) default NULL,
  `resent_message_id` varchar(255) default NULL,
  `mail_from` varchar(255) default NULL,
  `mail_to` varchar(255) default NULL,
  `mail_size` int(10) unsigned default NULL,
  `mail_nrcpt` int(10) unsigned default NULL,
  `relay` varchar(255) default NULL,
  `delay` int(10) unsigned default NULL,
  `status` varchar(10) default NULL,
  `proto` varchar(10) default NULL,
  `helo` varchar(255) default NULL,
  `sasl_method` varchar(10) default NULL,
  `sasl_username` varchar(255) default NULL,
  `amavis_id` varchar(12) default NULL,
  `amavis_counter` int(10) unsigned default NULL,
  `amavis_virus_name` varchar(255) default NULL,
  `amavis_banned_file` varchar(255) default NULL,
  `amavis_quarantine` varchar(255) default NULL,
  `amavis_SA_score` float default NULL,
  `message` text,
  PRIMARY KEY  (`id`),
  KEY `created_key` (`created`),
  KEY `process_name_key` (`process_name`),
  KEY `pid_key` (`pid`),
  KEY `postfix_key_key` (`postfix_key`),
  KEY `new_postfix_key_key` (`new_postfix_key`),
  KEY `client_hostname_key` (`client_hostname`),
  KEY `client_ip_key` (`client_ip`),
  KEY `client_uid_key` (`client_uid`),
  KEY `message_id_key` (`message_id`),
  KEY `resent_message_id_key` (`resent_message_id`),
  KEY `mail_from_key` (`mail_from`),
  KEY `mail_to_key` (`mail_to`),
  KEY `mail_size_key` (`mail_size`),
  KEY `mail_nrcpt_key` (`mail_nrcpt`),
  KEY `relay_key` (`relay`),
  KEY `delay_key` (`delay`),
  KEY `status_key` (`status`),
  KEY `proto_key` (`proto`),
  KEY `helo_key` (`helo`),
  KEY `sasl_method_key` (`sasl_method`),
  KEY `sasl_username_key` (`sasl_username`),
  KEY `amavis_id_key` (`amavis_id`),
  KEY `amavis_counter_key` (`amavis_counter`),
  KEY `amavis_virus_name_key` (`amavis_virus_name`),
  KEY `amavis_banned_file_key` (`amavis_banned_file`),
  KEY `amavis_quarantine_key` (`amavis_quarantine`),
  KEY `amavis_SA_score_key` (`amavis_SA_score`)
) TYPE=MyISAM;