Database Table: loginlog

From Dreamwidth Notes
Revision as of 20:19, 31 March 2009 by Twentyfourhours (Talk | contribs)

Jump to: navigation, search

Definition

CREATE TABLE loginlog (
   userid    INT UNSIGNED NOT NULL,
   logintime INT UNSIGNED NOT NULL,
   INDEX     (userid, logintime),
   sessid    MEDIUMINT UNSIGNED NOT NULL,
   ip        VARCHAR(15),
   ua        VARCHAR(100)
)

Relationships

Location

Clustered database