======LogDB.Messages table======
The [[LogDB]].Messages table contains a record of all messages logged by VPOP3. A message is logged when a message is sent/received/etc.

=====Columns=====
  * msgid -  this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]] sequential value which identifies the message uniquely in the database
  * sessid - this is a bigint value linking this message to a [[logdb sessions|session]] (or 0 if it is not linked to a session)
  * subject - the subject of the message
  * fromaddr - the from address of the message
  * authsender - the authenticated sender (if any) of the message
  * size - the size of the message (in bytes)
  * datetime - this is the date/time when the message was processed (in UTC)
  * spam - boolean value indicating whether the message was marked as spam or not
  * triggeredrule - contains the name of a download/SMTP rule which was triggered by this message (if any)
  * errorcode - this is text containing any error detail about the session (eg invalid password etc)
  * processtime - the time taken to process this message (in seconds)