Difference between revisions of "Database Table: supportpointsum"

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

Revision as of 18:07, 22 March 2009

Definition

CREATE TABLE supportpointsum (
  userid INT UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (userid),
  totpoints MEDIUMINT UNSIGNED DEFAULT 0,
  lastupdate  INT UNSIGNED NOT NULL,
  INDEX (totpoints, lastupdate),
  INDEX (lastupdate)
)

Relationships

Location

Global database