Difference between revisions of "Database Table: clientusage"
From Dreamwidth Notes
m |
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
||
| Line 24: | Line 24: | ||
[[Global database]] | [[Global database]] | ||
| − | [[Category: Database Tables|clientusage]] | + | [[Category:Database Tables Needing Conversion|clientusage]] |
Revision as of 14:00, 2 October 2009
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
