Difference between revisions of "Database Table: spamreports"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'spamreports =Definition= <source lang="sql"> CREATE TABLE spamreports ( reporttime INT(10) UNSIGNED NOT NULL, ip VARCHAR(15), j...')
 
Line 1: Line 1:
[[Category: Database Table|spamreports]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE spamreports (
 
CREATE TABLE spamreports (
Line 15: Line 15:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=Location=
 
 
[[Global database]]
 
[[Global database]]
 +
 +
[[Category: Database Tables|spamreports]]

Revision as of 15:38, 31 March 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

Location

Global database