CREATE TABLE `track_policy_request` (
    `id`                            INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `state`                         ENUM ('received', 'processed') NOT NULL DEFAULT 'received',
    
        -- Fields set when request is received
    `received_timestamp`            TIMESTAMP NULL DEFAULT NULL,
    
    `request`                       VARCHAR(255) DEFAULT NULL,
    `protocol_state`                VARCHAR(255) DEFAULT NULL,
    `protocol_name`                 VARCHAR(255) DEFAULT NULL,
    `helo_name`                     VARCHAR(255) DEFAULT NULL,
    `queue_id`                      VARCHAR(255) DEFAULT NULL,
    `sender_local`                  VARCHAR(255) DEFAULT NULL,
    `sender_reverse_domain`         VARCHAR(255) DEFAULT NULL,
    `recipient_local`               VARCHAR(255) DEFAULT NULL,
    `recipient_reverse_domain`      VARCHAR(255) DEFAULT NULL,
    `recipient_count`               INT UNSIGNED DEFAULT NULL,
    `client_address`                VARCHAR(255) DEFAULT NULL,
    `client_name`                   VARCHAR(255) DEFAULT NULL,
    `reverse_client_name`           VARCHAR(255) DEFAULT NULL,
    `instance`                      VARCHAR(255) DEFAULT NULL,
    `sasl_method`                   VARCHAR(255) DEFAULT NULL,
    `sasl_username`                 VARCHAR(255) DEFAULT NULL,
    `sasl_sender`                   VARCHAR(255) DEFAULT NULL,
    `size`                          INT UNSIGNED DEFAULT NULL,
    `ccert_subject`                 VARCHAR(255) DEFAULT NULL,
    `ccert_issuer`                  VARCHAR(255) DEFAULT NULL,
    `ccert_fingerprint`             VARCHAR(255) DEFAULT NULL,
    `encryption_protocol`           VARCHAR(255) DEFAULT NULL,
    `encryption_cipher`             VARCHAR(255) DEFAULT NULL,
    `encryption_keysize`            INT UNSIGNED DEFAULT NULL,
    `etrn_domain`                   VARCHAR(255) DEFAULT NULL,
    `stress`                        VARCHAR(255) DEFAULT NULL,
    
        -- Fields set when request is processed
    `processed_timestamp`           TIMESTAMP NULL DEFAULT NULL,

    `ch_wbl`                        ENUM ('none', 'whitelist', 'blacklist', 'tempfailure') DEFAULT NULL,
    `spam_traps`                    ENUM ('yes', 'no') DEFAULT NULL,
    `wbl`                           ENUM ('none', 'group_pass', 'group_reject', 'group_discard',
                                          'acl_sender', 'acl_recipient', 'spam_whitelist', 'blacklist') DEFAULT NULL,
    `spf`                           ENUM ('invalid', 'neutral', 'pass', 'fail', 'softfail', 'none',
                                          'temperror', 'permerror') DEFAULT NULL,
    `rbl`                           ENUM ('yes', 'no', 'error') DEFAULT NULL,
    `rbl_site`                      VARCHAR(255) DEFAULT NULL,
    `rbl_reason`                    VARCHAR(1024) DEFAULT NULL,
    `greylist`                      ENUM ('first_seen', 'blocked', 'auth', 'callback') DEFAULT NULL,
    `error_text`                    VARCHAR(1024) DEFAULT NULL,
    
    `decision`                      ENUM ('scan', 'reject', 'reject_disconnect', 'temp_failure',
                                          'discard', 'mark_header', 'ignore') DEFAULT NULL,
    `decision_text`                 VARCHAR(1024) DEFAULT NULL,
    
    PRIMARY KEY                     (`id`),
    INDEX                           (`received_timestamp`),
    INDEX                           (`instance`),
    INDEX                           (`processed_timestamp`)
)  CHARSET=latin1 ENGINE=INNODB;