Database Table: shop_carts

From Dreamwidth Notes
Revision as of 12:39, 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 shop_carts (
    cartid INT UNSIGNED NOT NULL,
    starttime INT UNSIGNED NOT NULL,
    userid INT UNSIGNED,
    email VARCHAR(255),
    uniq VARCHAR(15) NOT NULL,
    state INT UNSIGNED NOT NULL,
    paymentmethod INT UNSIGNED NOT NULL,
    nextscan INT UNSIGNED NOT NULL DEFAULT 0,
    authcode VARCHAR(20) NOT NULL,
 
    cartblob MEDIUMBLOB NOT NULL,
 
    PRIMARY KEY (cartid),
    INDEX (userid),
    INDEX (uniq)
)

Relationships