ejabberd - Comments for "ejabberd MySql schema question" https://www.ejabberd.im/node/1451 en They mean: None, Both, From https://www.ejabberd.im/node/1451#comment-59014 <p>They mean: None, Both, From and To.</p> Mon, 27 Aug 2012 15:12:56 +0000 mfoss comment 59014 at https://www.ejabberd.im Hello @jabber4me, What did https://www.ejabberd.im/node/1451#comment-58882 <p>Hello @jabber4me,</p> <p>What did you find out about the meaning of the states "N, B, F and T"? I will appreciate it if you could point me in the right direction.</p> Thu, 19 Jul 2012 22:33:03 +0000 sujoyg comment 58882 at https://www.ejabberd.im jabber4me wrote: Hi, Is https://www.ejabberd.im/node/1451#comment-3474 <div class="quote-msg"> <div class="quote-author"><em>jabber4me</em> wrote:</div> <p>Hi,<br /> Is there a schema definition document I can reference so I can see all possible states for the column "subscription" in the table rosterusers?</p> <p>The current states I have seen are N, B ,F, T. I have worked out what these states mean but wish to confirm this as well as identify any others.</p> <p>I would also like to understand when (if at all) some of the other tables are used:<br /> i.e</p> <p>| privacy_default_list |<br /> | privacy_list |<br /> | privacy_list_data |<br /> | private_storage |<br /> | spool |</p> <p>Any documentation about this would be gratefully received.</p> <p>Finally do you know which parts of the erl code governs the executed sql as eventually I may wish to adapt the code so that it is possible to manipulate the current schema to fit my needs.</p></div> <p>I think I've found the document :(</p> <p><noindex><a href="http://www.xmpp.org/rfcs/rfc3921.html" title="http://www.xmpp.org/rfcs/rfc3921.html" rel="nofollow" >http://www.xmpp.org/rfcs/rfc3921.html</a></noindex></p> Thu, 05 Apr 2007 11:48:35 +0000 jabber4me comment 3474 at https://www.ejabberd.im