date_fields is used to store the date of all messages.
The date stored is specified by the message sender. There is precisely one date per message. If a message contains two dates (as e.g. forwarded messages often do), then the outer date is used (the forwarding message's date rather than the forwarded messages's date).
A date is stored as a native PostgreSQL timestamp. Archiveopteryx converts back and forth between SQL and email formats as needed.
create table date_fields ( -- Grant: select, insert message integer not null references messages(id) on delete cascade, value timestamp with time zone );
The date_fields table was introduced in version 1.08.
In case of questions, please write to info@aox.org.
Last modified: 2010-11-19
Location: aox.org/db/date_fields