The subscriptions table

The subscriptions table records IMAP subscriptions. A lightly used table.

The existence of a row indicates that the row's owner has issued the IMAP subscribe command for the mailbox in question. The mailbox may have been deleted subsequently. 


create table subscriptions (
    -- Grant: select, insert, delete
    id          serial primary key,
    owner       integer not null references users(id)
                on delete cascade,
    mailbox     integer not null references mailboxes(id),
    unique(owner, mailbox)
);

The subscriptions table was introduced in version 0.93.

In case of questions, please write to info@aox.org.

Relevant links

About this page

Last modified: 2010-11-19
Location: aox.org/db/subscriptions