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