Database Table: acctcode_promo

From Dreamwidth Notes
Revision as of 06:58, 28 January 2010 by Exor674Bot (Talk | contribs)

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_promo (
    code VARCHAR(20) NOT NULL,
    max_count INT(10) UNSIGNED NOT NULL DEFAULT 0,
    current_count INT(10) UNSIGNED NOT NULL DEFAULT 0,
    active enum('1','0') NOT NULL DEFAULT 1,
    suggest_journalid INT UNSIGNED,
 
    PRIMARY KEY ( code )
)

Relationships

Outgoing

  • Foreign key: suggest_journalid to user.userid