Difference between revisions of "Database Table: clustertrack2"
From Dreamwidth Notes
m |
m |
||
Line 21: | Line 21: | ||
[[Clustered database]] | [[Clustered database]] | ||
− | [[Category: Database | + | [[Category: Database Tables|clustertrack2]] |
Revision as of 16:13, 30 March 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