Difference between revisions of "Database Table: userusage"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'userusage =Definition= <source lang="sql"> CREATE TABLE userusage ( userid INT UNSIGNED NOT NULL, PRIMARY KEY (userid), timecreate DATETIME ...')
(No difference)

Revision as of 18:26, 22 March 2009

Definition

CREATE TABLE userusage
(
   userid INT UNSIGNED NOT NULL,
   PRIMARY KEY (userid),
   timecreate DATETIME NOT NULL,
   timeupdate DATETIME,
   timecheck DATETIME,
   lastitemid INT UNSIGNED NOT NULL DEFAULT '0',
   INDEX (timeupdate)
)

Relationships

Location

Global database