Difference between revisions of "Database Table: clientusage"

From Dreamwidth Notes
Jump to: navigation, search
m
(Robot: Updating: Format)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{#set:name=clientusage|Table type=global}}
+
{{Database Table|name=clientusage|table type=global|repo=dw-free}}
 
[[Description::This table is populated at login.]]
 
[[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}}
 
{{Database Table Footer}}

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