Database Table: counter

From Dreamwidth Notes
Revision as of 16:01, 22 July 2010 by Exor674Bot (Talk | contribs)

Jump to: navigation, search

This is a global table. Stores user counters. See also usercounter, which stores related information at the cluster level.

Definition

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

Relationships