Database Table: jabpresence

From Dreamwidth Notes
Revision as of 13:15, 2 October 2009 by Exor674Bot (Talk | contribs)

Jump to: navigation, search

Definition

CREATE TABLE jabpresence (
  userid     INT UNSIGNED NOT NULL,
  reshash    CHAR(22) BINARY,
  PRIMARY KEY (userid, reshash),
  resource   VARCHAR(255) NOT NULL,
  client     VARCHAR(255),
  clusterid  INT UNSIGNED NOT NULL,
  presence   BLOB,
  flags      INT UNSIGNED NOT NULL,
  priority   INT UNSIGNED,
  ctime      INT UNSIGNED NOT NULL,
  mtime      INT UNSIGNED NOT NULL,
  remoteip   VARCHAR(255)
)

Relationships