Database Table: spamreports

From Dreamwidth Notes
Revision as of 15:38, 31 March 2009 by Dreamnestia (Talk | contribs)

Jump to: navigation, search

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

Location

Global database