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

Sig ejabberd at sighq.net
Fri Apr 25 17:01:40 MSD 2008




Ok ! Now i understand why !! :)

> 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
>
> ---
>


sighq


More information about the ejabberd mailing list