Skip to content
This repository was archived by the owner on Feb 12, 2019. It is now read-only.

Sqltablesdoc

Jump to bottom
cervajs edited this page May 31, 2012 · 12 revisions

Table of Contents

active

Stores date/time upon which each account first became active.

Used by: core 

 collection-owner - owner JID 
 object-sequence  -  auto increment number
 time  - Stores date/time upon which each account first became active

example 

 mysql> select * from active;
 +---------------------------+-----------------+------------+
 | collection-owner          | object-sequence | time       |
 +---------------------------+-----------------+------------+
 | someone@example.org       |               1 | 1320703315 |
 +---------------------------+-----------------+------------+

authreg

c2s authentication/registration table. Contains authentication information, including username, realm and password. 

 username - login name
 realm    - domain
 password - clear text password

example 

 mysql> select * from authreg;
 +----------+------------------+----------+
 | username | realm            | password |
 +----------+------------------+----------+
 | someone  | example.org      | secret   |
 +----------+------------------+----------+

disco-items (DEPRECATED?)

Stores persistent discovery information so that it is available for offline retrieval.

logout

Stores JID and timestamp for most recent user log out.

Used by: mod_iq_last 

 collection-owner - owner JID 
 object-sequence  - auto increment number
 time             - logout time

motd-message

Stores message of the day (MOTD) in XML format.

motd-times

Records JID's and timestamps for receipt of MOTD.

privacy-default

Stores the name of the current list in use for a user so it can be made active on startup.

privacy-items

Stores user privacy lists (blacklists/whitelists).

private

Provides private XML storage for uses such as user preferences or bookmarks. Private storage JEP.

Client may store chunks of XML in a given namespace. 

 collection-owner - owner JID 
 object-sequence  - auto increment number
 ns               - namespace
 xml              - XML

queue

Offline message queue. Stores queued messages in XML format.

Used by: mod_offline 

 collection-owner -  owner JID 
 object-sequence  -  auto increment number
 xml              -  Stores queued messages in XML format.

roster-groups

Stores user roster items only for those roster items that have an assigned group.

Used by: mod_roster 

 collection-owner -  owner JID 
 object-sequence  -  auto increment number
 jid              -  JID contact person 
 group            -  group which belongs to

example 

 mysql> select * from `roster-groups`;
 +------------------+-----------------+-----------------------+------------+
 | collection-owner | object-sequence | jid                   | group      |
 +------------------+-----------------+-----------------------+------------+
 | me@there.org     |            5461 | alabama@holiday.pl    | Friend     |
 | me@there.org     |            5460 | goodworker@athome.cz  | Workers    |
 | neo@outside.org  |            5462 | alabama@holiday.pl    | Friend     |
 | neo@outside.org  |            5463 | goodworker@athome.cz  | Workers    |

roster-items

Stores user roster items, including authorization status.

Used by: mod_roster 

 collection-owner -  owner JID 
 object-sequence  -  auto increment number
 jid              -  JID contact person
 name             -  name of the person
 to               - authorization to
 from             - authorization from
 ask              - ask authorization

example 

 mysql> select * from `roster-items`;
 +------------------+-----------------+-----------------------+-----------------------+------+------+------+
 | collection-owner | object-sequence | jid                   | name                  | to   | from | ask  |
 +------------------+-----------------+-----------------------+-----------------------+------+------+------+
 | neo@example.org |            5704 | bunny@matrix.cz        |  Jitka Mala           |    1 |    1 |    0 |
 | neo@example.org |            5712 | orfeus@dot.com         |  Ivan Mladek          |    1 |    1 |    0 |
 | neo@example.org |            5711 | andrea@example.org     |  Andrea Farna         |    1 |    1 |    0 |

status

Users statuses

Used by: mod_status 

 collection-owner -  owner JID 
 object-sequence  -  auto increment number
 status           - jabber status (online,offline,...)
 show             - ?
 last-login       - last login time
 last-logout      - last logout time
 xml              - data

example 

 mysql> select * from status\G;
 collection-owner: josef.novak@nekde.cz
  object-sequence: 1858
           status: offline
             show:
       last-login: 1318318357
      last-logout: 1318318489
              xml: NAD<route xmlns='http://jabberd.jabberstudio.org/ns/component/1.0' to='sm' from='c2s'> <presence xmlns='jabber:client' xmlns:sc='http://jabberd.jabberstudio.org/ns/session/1.0' type='unavailable' id='81' sc:c2s='14' sc:sm='ajskdajskd'><x xmlns='vcard-temp:x:update'><photo/></x></presence></route>

vacation-settings (OBSOLETED)

Handles vacation settings, including start, end and message.

Used by: mod_vacation 

 collection-owner - owner JID 
 object-sequence  - auto increment number
 start            - start date of vacation
 end              - end of vacation
 message          - vacation message

vcard

Stores vcard information. User profile information

Used by: mod_iq_vcard 

 collection-owner - owner JID 
 object-sequence  - auto increment number
 fn               - full name
 nickname         - nickname
 url              - homepage
 tel              - telephone number
 email            - email address
 jabberid         - ?
 mailer           - ?
 title            - title
 role             - ?
 bday             - birthday
 tz               - timezone
 n-family         - 
 n-given          -
 n-middle         -
 n-prefix         -
 n-suffix         -
 adr-street       - street address
 adr-extadd       -
 adr-pobox        - P.O. Box
 adr-locality     - Locality
 adr-region       - Region
 adr-pcode        -  
 adr-country      - Country
 geo-lat          - geo latitude
 geo-lon          - geo longitude
 org-orgname      - organization name
 org-orgunit      - organization unit
 agent-extval     - ?
 sort-string      - ?
 desc             - description
 note             - note
 uid              - linux uid?
 photo-type       - photo-type (image/jpeg,...)
 photo-binval     - base64 coded image
 photo-extval     - ?
 logo-type        - ?
 logo-binval      - ?
 logo-extval      - ?
 sound-phonetic   - ?
 sound-binval     - ?
 sound-extval     - ?
 key-type         -
 key-cred         -
 rev              -

Clone this wiki locally