Difference between revisions of "Database Table: spamreports"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use semantic mediawiki form.)
m (Robot: Converting database table to use semantic mediawiki form.)
Line 1: Line 1:
{{#set:name=spamreports|clustered=false}}
+
{{#set:name=spamreports|table type=global}}
 
= Definition =
 
= Definition =
  

Revision as of 18:46, 2 October 2009

Definition

CREATE TABLE spamreports (
    reporttime  INT(10) UNSIGNED NOT NULL,
    ip          VARCHAR(15),
    journalid   INT(10) UNSIGNED NOT NULL,
    posterid    INT(10) UNSIGNED NOT NULL DEFAULT 0,
    subject     VARCHAR(255) BINARY,
    body        BLOB NOT NULL,
    PRIMARY KEY (reporttime, journalid),
    INDEX       (ip),
    INDEX       (posterid)
)

Relationships