Difference between revisions of "Database Table: supportpointsum"
From Dreamwidth Notes
(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) )