Difference between revisions of "Database Table: logkwsum"

From Dreamwidth Notes
Jump to: navigation, search
m
m (Robot: Changing Category:Database Tables)
Line 1: Line 1:
 
 
= Definition =
 
= Definition =
  
Line 19: Line 18:
 
[[Clustered database]]
 
[[Clustered database]]
  
[[Category: Database Tables|logkwsum]]
+
[[Category:Database Tables Needing Conversion|logkwsum]]

Revision as of 14:02, 2 October 2009

Definition

CREATE TABLE logkwsum (
    journalid INT UNSIGNED NOT NULL,
    kwid      INT UNSIGNED NOT NULL,
    security  BIGINT UNSIGNED NOT NULL,
    entryct   INT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (journalid, kwid, security),
    KEY (journalid, security)
)

Relationships

Location

Clustered database