The flags table

flags records IMAP message flags.

Message flags are binary variables which IMAP clients may set or clear on messages. For example, the IMAP \seen flag is set or cleared by most clients in order to remember whether a message has been read or not.

When the flag is set, a flags row exists. When the flag is cleared, the row is removed. Archiveopteryx also increases mailbox_messages.modseq when a flag is changed.

mailbox and uid identify the message to which this flag applies.

flag identifies the flag by reference to flag_names. 


create table flags (
    -- Grant: select, insert, delete
    mailbox     integer not null,
    uid         integer not null,
    flag        integer not null references flag_names(id),
    foreign key (mailbox, uid)
                references mailbox_messages(mailbox, uid)
                on delete cascade
);

The flags table was introduced in version 0.93.

In case of questions, please write to info@oryx.com.

Relevant links

About this page

Last modified: 2008-08-25
Location: aox.org/db/flags