Difference between revisions of "Database Table: jabpresence"

From Dreamwidth Notes
Jump to: navigation, search
m (right category, reformat)
(Robot: Updating: Format)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
{{Database Table|name=jabpresence|table type=global|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE jabpresence (
 
CREATE TABLE jabpresence (
  userid    INT UNSIGNED NOT NULL,
+
    userid    INT UNSIGNED NOT NULL,
  reshash    CHAR(22) BINARY,
+
    reshash    CHAR(22) BINARY,
  PRIMARY KEY (userid, reshash),
+
    PRIMARY KEY (userid, reshash),
  resource  VARCHAR(255) NOT NULL,
+
    resource  VARCHAR(255) NOT NULL,
  client    VARCHAR(255),
+
    client    VARCHAR(255),
  clusterid  INT UNSIGNED NOT NULL,
+
    clusterid  INT UNSIGNED NOT NULL,
  presence  BLOB,
+
    presence  BLOB,
  flags      INT UNSIGNED NOT NULL,
+
    flags      INT UNSIGNED NOT NULL,
  priority  INT UNSIGNED,
+
    priority  INT UNSIGNED,
  ctime      INT UNSIGNED NOT NULL,
+
    ctime      INT UNSIGNED NOT NULL,
  mtime      INT UNSIGNED NOT NULL,
+
    mtime      INT UNSIGNED NOT NULL,
  remoteip  VARCHAR(255)
+
    remoteip  VARCHAR(255)
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer}}
= Relationships =
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|jabpresence]]
+

Latest revision as of 15:58, 22 July 2010

This is a global table.

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