Database Table: clustertrack2

From Dreamwidth Notes
Revision as of 16:13, 30 March 2009 by Twentyfourhours (Talk | contribs)

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