[ejabberd] Rosterusers MySQL table

lasek lasek88 at gmail.com
Wed Aug 3 13:21:46 MSD 2011


Hi all, is possible to have more information about fields in rostusers
table using MySQL?
In particular for the following fields : ask, server, subscribe and type.

Thanks

CREATE TABLE rosterusers (
    username varchar(250) NOT NULL,
    jid varchar(250) NOT NULL,
    nick text NOT NULL,
    subscription character(1) NOT NULL,
    ask character(1) NOT NULL,
    askmessage text NOT NULL,
    server character(1) NOT NULL,
    subscribe text NOT NULL,
    type text,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP




More information about the ejabberd mailing list