Difference between revisions of "Database Table: usercounter"

From Dreamwidth Notes
Jump to: navigation, search
(New page: See also counter)
 
(Robot: Updating: Format)
 
(9 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 +
{{Database Table|name=usercounter|table type=global|need desc=1|repo=dw-free}}
 
See also [[Database Table: counter|counter]]
 
See also [[Database Table: counter|counter]]
 +
= Definition =
 +
<source lang="sql">
 +
CREATE TABLE usercounter (
 +
    journalid  INT UNSIGNED NOT NULL,
 +
    area      CHAR(1) NOT NULL,
 +
    PRIMARY KEY (journalid, area),
 +
    max        INT UNSIGNED NOT NULL
 +
)
 +
</source>
 +
{{Database Table Footer}}

Latest revision as of 16:02, 22 July 2010

This is a global table. See also counter

Definition

CREATE TABLE usercounter (
    journalid  INT UNSIGNED NOT NULL,
    area       CHAR(1) NOT NULL,
    PRIMARY KEY (journalid, area),
    MAX        INT UNSIGNED NOT NULL
)

Relationships