Difference between revisions of "Database Table: acctcode"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format, needs desc, definition)
(Robot: Updating: Format)
Line 1: Line 1:
{{Database Table|name=acctcode|table type=global|need desc=1}}
+
{{Database Table|name=acctcode|table type=global|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">

Revision as of 15:58, 22 July 2010

This is a global table.

Definition

CREATE TABLE acctcode (
    acid    INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    userid  INT UNSIGNED NOT NULL,
    rcptid  INT UNSIGNED NOT NULL DEFAULT 0,
    auth    CHAR(13) NOT NULL,
    timegenerate INT UNSIGNED NOT NULL,
    timesent INT UNSIGNED,
    email   VARCHAR(255),
    reason  VARCHAR(255),
 
    INDEX (userid),
    INDEX (rcptid)
)

Relationships

Outgoing

  • Foreign key: userid to user.userid