Database Table: clustertrack2

From Dreamwidth Notes
Revision as of 05:41, 21 March 2009 by SlowSculpture (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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