Difference between revisions of "Database Table: clustertrack2"

From Dreamwidth Notes
Jump to: navigation, search
m
m (Robot: Changing Category:Database Tables)
Line 21: Line 21:
 
[[Clustered database]]
 
[[Clustered database]]
  
[[Category: Database Tables|clustertrack2]]
+
[[Category:Database Tables Needing Conversion|clustertrack2]]

Revision as of 14:01, 2 October 2009

This table on each clustered database tracks users on that cluster.

Definition

CREATE TABLE clustertrack2 (
    userid INT UNSIGNED NOT NULL,
    PRIMARY KEY (userid),
    timeactive INT UNSIGNED NOT NULL,
    clusterid SMALLINT UNSIGNED,
    INDEX (timeactive, clusterid)
)

Relationships

Foreign key userid to user.userid

Location

Clustered database