Difference between revisions of "Database Table: clientusage"

From Dreamwidth Notes
Jump to: navigation, search
m
(Robot: Updating: Format)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This table is populated at login.
+
{{Database Table|name=clientusage|table type=global|repo=dw-free}}
 
+
[[Description::This table is populated at login.]]
 
+
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE clientusage (
 
CREATE TABLE clientusage (
  userid int(10) unsigned NOT NULL default '0',
+
    userid int(10) unsigned NOT NULL default '0',
  clientid smallint(5) unsigned NOT NULL default '0',
+
    clientid smallint(5) unsigned NOT NULL default '0',
  lastlogin datetime NOT NULL default '0000-00-00 00:00:00',
+
    lastlogin datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (clientid,userid),
+
 
  UNIQUE KEY userid (userid,clientid)
+
    PRIMARY KEY  (clientid,userid),
 +
    UNIQUE KEY userid (userid,clientid)
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer}}
= Relationships =
+
 
+
Foreign key userid to [[Database Table: user|user]].userid
+
 
+
Foreign key clientid to [[Database Table: clients|clients]].clientid
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|clientusage]]
+

Latest revision as of 15:59, 22 July 2010

This is a global table. 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

Outgoing

  • Foreign key: clientid to clients.clientid
  • Foreign key: userid to user.userid