Database Table: spamreports

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)
)