Monday, November 10, 2008

PHP Mysql Shopping cart Database table

CREATE TABLE tbl_order (

id int(10) unsigned NOT NULL auto_increment,
date datetime default NULL,
last_update datetime NOT NULL default '0000-00-00 00:00:00',
status enum('New', 'Paid', 'Shipped','Completed','Cancelled') NOT NULL default 'New',
memo varchar(255) NOT NULL default '',
shipping_first_name varchar(50) NOT NULL default '',
shipping_last_name varchar(50) NOT NULL default '',
shipping_address1 varchar(100) NOT NULL default '',
shipping_address2 varchar(100) NOT NULL default '',
shipping_phone varchar(32) NOT NULL default '',
shipping_city varchar(100) NOT NULL default '',
shipping_state varchar(32) NOT NULL default '',
shipping_postal_code varchar(10) NOT NULL default '',
shipping_cost decimal(5,2) default '0.00',
payment_first_name varchar(50) NOT NULL default '',
payment_last_name varchar(50) NOT NULL default '',
payment_address1 varchar(100) NOT NULL default '',
payment_address2 varchar(100) NOT NULL default '',
payment_phone varchar(32) NOT NULL default '',
payment_city varchar(100) NOT NULL default '',
payment_state varchar(32) NOT NULL default '',
payment_postal_code varchar(10) NOT NULL default '',
PRIMARY KEY ( id)
) TYPE=MyISAM AUTO_INCREMENT=1001 ;

No comments: