Difference between revisions of "Database Table: counter"
From Dreamwidth Notes
Foxfirefey (Talk | contribs) |
|||
| Line 1: | Line 1: | ||
| − | See also [[Database Table: usercounter|usercounter]] | + | Stores user counters. See also [[Database Table: usercounter|usercounter]], which stores related information at the cluster level. |
| − | [[Category: Database | + | [[Category: Database Table|counter]] |
| + | =Definition= | ||
| + | <source lang="sql"> | ||
| + | CREATE TABLE counter ( | ||
| + | journalid INT UNSIGNED NOT NULL, | ||
| + | area CHAR(1) NOT NULL, | ||
| + | PRIMARY KEY (journalid, area), | ||
| + | max MEDIUMINT UNSIGNED NOT NULL | ||
| + | ) | ||
| + | </source> | ||
| + | |||
| + | =Relationships= | ||
| + | |||
| + | =Location= | ||
| + | [[Global database]] | ||
Revision as of 07:02, 21 March 2009
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 )
