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...') |
(→Relationships) |
||
| Line 15: | Line 15: | ||
=Relationships= | =Relationships= | ||
Foreign key userid to [[Database Table: user|user]].userid | Foreign key userid to [[Database Table: user|user]].userid | ||
| + | |||
Foreign key clientid to [[Database Table: clients|clients]].clientid | Foreign key clientid to [[Database Table: clients|clients]].clientid | ||
=Location= | =Location= | ||
[[Global database]] | [[Global database]] | ||
Revision as of 05:19, 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
