Difference between revisions of "Database Table: jabpresence"

From Dreamwidth Notes
Jump to: navigation, search
m (right category, reformat)
m (Robot: Converting database table to use semantic mediawiki form.)
Line 1: Line 1:
 +
{{#set:name=jabpresence|clustered=false}}
 
= Definition =
 
= Definition =
  
Line 18: Line 19:
 
</source>
 
</source>
  
= Relationships =
+
{{Database Table Footer}}
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|jabpresence]]
+

Revision as of 13:15, 2 October 2009

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