Difference between revisions of "Database Table: jabpresence"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use semantic mediawiki form.)
m (Robot: Converting database table to use database table header template.)
Line 1: Line 1:
{{#set:name=jabpresence|table type=global}}
+
{{Database Table|name=jabpresence|table type=global}}
 
= Definition =
 
= Definition =
  

Revision as of 11:26, 27 January 2010

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. 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