Difference between revisions of "Database Table: shop carts"
From Dreamwidth Notes
(Created page with '{{Database Table|name=shop_carts|table type=global}} Category:Database Tables Needing Description = Definition = <source lang="sql"> CREATE TABLE shop_carts ( cartid INT …') |
Exor674Bot (Talk | contribs) (Robot: Updating: Format, needs desc) |
||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=shop_carts|table type=global}} | + | {{Database Table|name=shop_carts|table type=global|need desc=1}} |
| − | + | ||
= Definition = | = Definition = | ||
<source lang="sql"> | <source lang="sql"> | ||
Revision as of 07:09, 28 January 2010
"{{{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) )
