Difference between revisions of "Database Table: dw payments"

From Dreamwidth Notes
Jump to: navigation, search
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{Database Table|name=dw_payments|table type=global|repo=dw-free|removed=1|removed in=446f75a17f85}}
 +
[[description::Designed for DW Payment system but never used.]]
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE dw_payments (
 
CREATE TABLE dw_payments (
Line 21: Line 22:
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer|removed=1}}
= Relationships =
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|dw_payments]]
+

Latest revision as of 16:24, 22 July 2010

Note: This table is removed and no longer used. This table was removed in dw-free changeset 446f75a17f85 [1]
This is a global table. Designed for DW Payment system but never used.

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)
)