Difference between revisions of "Database Table: active user summary"

From Dreamwidth Notes
Jump to: navigation, search
m
m (Robot: Changing ...)
Line 1: Line 1:
 +
{{#set:name=active_user_summary|clustered=false}}
 
= Definition =
 
= Definition =
  
Line 14: Line 15:
 
</source>
 
</source>
  
= Relationships =
+
{{Database Table Footer}}
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|active_user_summary]]
+

Revision as of 13:12, 2 October 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

Outgoing