CREATE TABLE 'shop_order' (
'id' int(10) unsigned NOT NULL auto_increment,
'customer_id' int(10) unsigned default NULL,
'order_code' varchar(10) NOT NULL default '',
'order_date' datetime NOT NULL default '0000-00-00 00:00:00',
'order_status' enum('new','processed') NOT NULL default 'new',
'ccnumber' varchar(100) NOT NULL default '',
'cc_type_id' int(10) NOT NULL default '0',
'cc_name' varchar(255) NOT NULL default '',
'cc_expire_date' date NOT NULL default '0000-00-00',
'cvv2' varchar(255) NOT NULL default '',
'tax_amount' float(10,4) NOT NULL default '0.0000',
'delivery_amount' float(10,4) NOT NULL default '0.0000',
'discount_amount' float(10,4) NOT NULL default '0.0000',
'total_amount' float(10,4) NOT NULL default '0.0000',
'bill_fname' varchar(50) NOT NULL default '',
'bill_lname' varchar(50) NOT NULL default '',
'bill_phone' varchar(50) NOT NULL default '',
'bill_fax' varchar(50) NOT NULL default '',
'bill_address1' varchar(255) NOT NULL default '',
'bill_address2' varchar(255) NOT NULL default '',
'bill_city' varchar(100) NOT NULL default '0',
'bill_country_id' int(10) unsigned NOT NULL default '0',
'bill_state_id' int(10) unsigned NOT NULL default '0',
'bill_zip' varchar(5) NOT NULL default '',
'ship_fname' varchar(50) NOT NULL default '',
'ship_lname' varchar(50) NOT NULL default '',
'ship_email' varchar(255) NOT NULL default '',
'ship_phone' varchar(50) NOT NULL default '',
'ship_fax' varchar(50) NOT NULL default '',
'ship_address1' varchar(255) NOT NULL default '',
'ship_address2' varchar(255) NOT NULL default '',
'ship_city' varchar(100) NOT NULL default '0',
'ship_country_id' int(10) unsigned NOT NULL default '0',
'ship_state_id' int(10) unsigned NOT NULL default '0',
'ship_zip' varchar(5) NOT NULL default '',
'is_deleted' tinyint(1) NOT NULL default '0',
'usps' tinyint(1) NOT NULL default '0',
'cc_encrypted_number' text NOT NULL,
'bill_email' varchar(255) NOT NULL default '',
'aid' varchar(50) NOT NULL default '',
'sid' varchar(50) NOT NULL default '',
'cid' varchar(50) NOT NULL default '',
'pid' varchar(50) NOT NULL default '',
'delivery_method' varchar(255) NOT NULL default '',
'delivery_package' varchar(255) NOT NULL default '',
'wantspam' tinyint(1) NOT NULL default '0',
'couponCode' varchar(255) NOT NULL default '',
'discountType' varchar(255) NOT NULL default '',
'couponCodeType' tinyint(1) NOT NULL default '0',
'couponDiscount' varchar(255) NOT NULL default '',
PRIMARY KEY ('id'),
KEY 'customer_id' ('customer_id','order_status')
) TYPE=MyISAM AUTO_INCREMENT=49 ;
|