Difference between revisions of "Database Table: spamreports"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: This table needs a description.)
m (Robot: Updating: Format, definition)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Database Table|name=spamreports|table type=global}}
+
{{Database Table|name=spamreports|table type=global|need desc=1|repo=dw-free}}
[[Category:Database Tables Needing Description]]
+
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE spamreports (
 
CREATE TABLE spamreports (
Line 11: Line 9:
 
     subject    VARCHAR(255) BINARY,
 
     subject    VARCHAR(255) BINARY,
 
     body        BLOB NOT NULL,
 
     body        BLOB NOT NULL,
 +
    client      VARCHAR(255),
 +
 
     PRIMARY KEY (reporttime, journalid),
 
     PRIMARY KEY (reporttime, journalid),
 
     INDEX      (ip),
 
     INDEX      (ip),
     INDEX      (posterid)
+
     INDEX      (posterid),
 +
    INDEX      (client)
 
)
 
)
 
</source>
 
</source>
 
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 04:04, 8 June 2013

This is a global table.

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,
    client      VARCHAR(255),
 
    PRIMARY KEY (reporttime, journalid),
    INDEX       (ip),
    INDEX       (posterid),
    INDEX       (client)
)

Relationships