Database Table: dw payments

From Dreamwidth Notes
Revision as of 20:12, 21 March 2009 by SlowSculpture (Talk | contribs)

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

Definition

CREATE TABLE dw_payments (
    paymentid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    paydate INT UNSIGNED NOT NULL,
    pp_token VARCHAR(20) NOT NULL,
    from_userid INT UNSIGNED,
    target_userid INT UNSIGNED,
    target_username VARCHAR(15),
    typeid SMALLINT UNSIGNED NOT NULL,
    duration SMALLINT UNSIGNED NOT NULL,
    amount SMALLINT UNSIGNED NOT NULL,
    STATUS VARCHAR(20) NOT NULL,
 
    PRIMARY KEY (paymentid),
    INDEX (paydate, pp_token),
    INDEX (from_userid),
    INDEX (target_userid),
    INDEX (STATUS)
)

Relationships

Location

Global database