[ejabberd] schema description

Badlop badlop at gmail.com
Thu Dec 3 23:25:06 MSK 2009

2009/12/2 Mark <mark at mitsein.net>:
> Is there a description of the ejabberd database schema someplace?  Right now
> I am specifically looking for the possible values for all columns in
> rosterusers and what they mean.

This isn't documented. You can add some test contacts, and
see how they are reflected in the table.

Without much investigation, maybe the meanings are:
    username varchar(250) NOT NULL, -- owner of the roster item
    jid varchar(250) NOT NULL, -- the contact's jid
    nick text NOT NULL, -- the contact's nickname
    subscription character(1) NOT NULL, -- subscription type
    ask character(1) NOT NULL, -- wether this is a fake roster item
used to keep a subscribe request
    askmessage text NOT NULL, -- message included in the subscribe request
    server character(1) NOT NULL, -- no idea
    subscribe text NOT NULL, -- no idea

Possible values of subscription and ask:
B = both
N = none
F = from
T = to
for the meaning, see http://www.xmpp.org/rfcs/rfc3921.html#roster


More information about the ejabberd mailing list