Database Table: acctcode_request

From Dreamwidth Notes
Revision as of 12:28, 27 January 2010 by Exor674 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a global table.

Definition

CREATE TABLE acctcode_request (
    reqid   INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    userid  INT UNSIGNED NOT NULL,
    STATUS ENUM('accepted','rejected', 'outstanding') NOT NULL DEFAULT 'outstanding',
    reason VARCHAR(255),
    timegenerate    INT UNSIGNED NOT NULL,
    timeprocessed   INT UNSIGNED,
 
    INDEX (userid)
)

Relationships

Outgoing

  • Foreign key: userid to user.userid