Manitou-Mail Home

15.  Table: import_mbox

This is a staging table with an entry for each mailbox currently being imported in a controlled way by the user interface. The actual mail contents are in import_message.

Structure of import_mbox

import_id

serial PRIMARY KEY

tag_id
integer

ID of the optional tag to assign to all messages from this mailbox.

mail_status
smallint

status to apply to messages from this mailbox. The value will be copied to mail.status

apply_filters

character

'Y' if the filters for incoming mail should be applied when importing this mailbox, 'N' or NULL otherwise.

completion

real

Completion ratio between 0 and 1.

status

smallint

Status of the import. Values are 0=not started, 1=running, 2=aborted, 3=finished.

filename

text

The filename of the mailbox at the client side. This is for information only. The filename is not used to process the actual import, since the contents have already been uploaded to the database.

auto_purge

character

'Y' if the entries in import_mbox and import_message should be deleted immediately upon completion, 'N' otherwise. Keeping the entry lets the user interface view the import in a finished state.