Difference between revisions of "Database Table: clustermove inprogress"
From Dreamwidth Notes
m |
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
||
| Line 24: | Line 24: | ||
[[Global database]] | [[Global database]] | ||
| − | [[Category: Database Tables|clustermove_inprogress]] | + | [[Category:Database Tables Needing Conversion|clustermove_inprogress]] |
Revision as of 14:01, 2 October 2009
This table is used by the ljbackup and ljumover daemons to track the transitions of users between clusters.
Definition
CREATE TABLE clustermove_inprogress ( userid INT UNSIGNED NOT NULL, locktime INT UNSIGNED NOT NULL, dstclust SMALLINT UNSIGNED NOT NULL, moverhost INT UNSIGNED NOT NULL, moverport SMALLINT UNSIGNED NOT NULL, moverinstance CHAR(22) NOT NULL, # base64ed MD5 hash PRIMARY KEY (userid) )
Relationships
Foreign key userid to user.userid
moverinstance identifies an instance of the ljumover daemon.
