[ejabberd] somes Few Questions about the Sql Way to do it :)

Badlop badlop at gmail.com
Fri Apr 25 13:56:13 MSD 2008


2008/4/24, Badlop <badlop at gmail.com>:
> 2008/4/24, Sig <ejabberd at sighq.net>:
>  >  - i see there is two tables : rostersusers and rostergroups , strangely the rostersgroups only have one field more
>  >  (grp) than rosterusers and a common keyfield,  isn't it possible to join the two tables in one ?
>
>
> It seems that was the data structure of jabberd14 database. When
>  Alexey implemented SQL support in ejabberd, he wanted to make the
>  migration from jabberd14 to ejabberd easy.

There is another good reason to allow a single roster contact to have
several items in the rostergroups table (as pointed by Jérôme Sautret,
Alexey Shchepin and Sergei Golovan): in Jabber it is allowed to have a
contact in several groups.

It's shown, for example, in
http://www.xmpp.org/rfcs/rfc3921.html#rfc.section.7.5

---


More information about the ejabberd mailing list