The users table

The users table holds one row per Archiveopteryx user. The user has a login (which may contain '@' or anything else) and a secret (a password). The user also has a mailbox namespace, decided by the parentspace and login name. If the parentspace points to "/users" (it always does in practice) and the login in "alice", then the user owns /users/alice and all mailboxes matching /users/alice/*.

The users table is bound to many other tables via its id, and to one table via its login, namely permissions. 


create table users (
    id          serial primary key,
    login       text,
    secret      text,
    parentspace integer not null references namespaces(id)
);

The users 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-20
Location: aox.org/db/users