Difference between revisions of "Database Table: clientusage"
From Dreamwidth Notes
(Created page with 'This table is populated at login. clientusage =Definition= <source lang="sql"> CREATE TABLE clientusage ( userid int(10) unsigned NOT NULL default...') |
(No difference)
|
Revision as of 05:18, 21 March 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