Subscription status table

Guillermo Roditi groditi at gmail.com
Fri Jul 7 16:12:43 UTC 2006


I am trying to write a wroster class and I was looking in sqllite
roster storage. i came accross this, which im still wrapping my head
around since everything seems to be a jidmap entry. anyways, i guess
my question boils down to, what the hell is substates and where is the
definition for it?

i just ran accross hookdocs.pm which is making my life a lot less
miserable, but this one is still outstanding

CREATE TABLE jidmap (
              jidid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
              jid   VARCHAR(255) NOT NULL,
              UNIQUE (jid)
             )

CREATE TABLE roster (
              userid        INTEGER REFERENCES jidmap NOT NULL,
              contactid     INTEGER REFERENCES jidmap NOT NULL,
              name          VARCHAR(255),
              subscription  INTEGER NOT NULL REFERENCES substates DEFAULT 0,
              PRIMARY KEY (userid, contactid)
             )

CREATE TABLE rostergroup (
              groupid       INTEGER PRIMARY KEY REFERENCES jidmap NOT NULL,
              userid        INTEGER REFERENCES jidmap NOT NULL,
              name          VARCHAR(255),
              UNIQUE (userid, name)
             )

CREATE TABLE groupitem (
              groupid       INTEGER REFERENCES jidmap NOT NULL,
              contactid     INTEGER REFERENCES jidmap NOT NULL,
              PRIMARY KEY (groupid, contactid)
             )


More information about the Djabberd mailing list