Difference between revisions of "Database Table: active user summary"
From Dreamwidth Notes
(Created page with 'active_user_summary =Definition= <source lang="sql"> CREATE TABLE active_user_summary ( year SMALLINT NOT NULL, month TINYINT NOT NU...') |
Foxfirefey (Talk | contribs) m (reformat, right category) |
||
| Line 1: | Line 1: | ||
| − | + | = Definition = | |
| − | =Definition= | + | |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE active_user_summary ( | CREATE TABLE active_user_summary ( | ||
| Line 14: | Line 14: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
| + | = Location = | ||
| − | |||
Global db | Global db | ||
| + | |||
| + | [[Category: Database Tables|active_user_summary]] | ||
Revision as of 08:04, 25 March 2009
Definition
CREATE TABLE active_user_summary ( YEAR SMALLINT NOT NULL, MONTH TINYINT NOT NULL, DAY TINYINT NOT NULL, HOUR TINYINT NOT NULL, clusterid TINYINT UNSIGNED NOT NULL, TYPE CHAR(1) NOT NULL, COUNT INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (YEAR, MONTH, DAY, HOUR, clusterid, TYPE) )
Relationships
Location
Global db
