Database Table: clientusage
From Dreamwidth Notes
Revision as of 05:19, 21 March 2009 by SlowSculpture (Talk | contribs)
This table is populated at login.
Definition
CREATE TABLE clientusage ( userid INT(10) UNSIGNED NOT NULL DEFAULT '0', clientid SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', lastlogin datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (clientid,userid), UNIQUE KEY userid (userid,clientid) )
Relationships
Foreign key userid to user.userid
Foreign key clientid to clients.clientid