DEDECMS database Structure table name: dede_shops_orders

DEDECMS database Structure table name: Dede_shops_orders field description is as follows:

Table Name: Dede_shops_orders
(ENGINE=MYISAM/CHARSET=GBK) Description: Order Information table field name description describes specific parameters IP logon IP char ("NOT NULL"), price order prices float (13,2) not null DEFAULT ' 0.00 ', OID order number varchar NOT NULL, USERID consumer ID int (a) not NULL, PayType http://www.aliyun.com/zixun/aggregation/10694.html " > Payment Method tinyint (2) NOT null default ' 1 ', state status tinyint (1) NOT null default ' 0 ', dprice distribution fee float (13,2) NOT null default ' 0.0 0 ', cartcount purchase quantity int (a) NOT null default ' 0 ', pricecount Total price float (13,2) not NULL, PID distribution mode int (a) NOT null default ' 0 ', STI Me next single time int (a) not NULL default ' 0 ', index:
KEY ' stime ' (' stime '),
KEY ' userid ' (' userid '),
KEY ' oid ' (' oid ')