Difference between revisions of "Database Table: spamreports"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use semantic mediawiki form.)
Line 1: Line 1:
 +
{{#set:name=spamreports|clustered=false}}
 
= Definition =
 
= Definition =
  
Line 15: Line 16:
 
</source>
 
</source>
  
= Relationships =
+
{{Database Table Footer}}
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|spamreports]]
+

Revision as of 13:21, 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