# Table structure for table `orders`
#

CREATE TABLE orders (
orders_id int(5) NOT NULL auto_increment,
customers_id int(5) NOT NULL default '0',
customers_name varchar(64) NOT NULL default '',
customers_street_address varchar(64) NOT NULL default '',
customers_suburb varchar(32) default NULL,
customers_city varchar(32) NOT NULL default '',
customers_postcode varchar(10) NOT NULL default '',
customers_state varchar(32) default NULL,
customers_country varchar(32) NOT NULL default '',
customers_telephone varchar(32) NOT NULL default '',
customers_email_address varchar(96) NOT NULL default '',
customers_address_format_id int(5) NOT NULL default '0',
delivery_name varchar(64) NOT NULL default '',
delivery_street_address varchar(64) NOT NULL default '',
delivery_suburb varchar(32) default NULL,
delivery_city varchar(32) NOT NULL default '',
delivery_postcode varchar(10) NOT NULL default '',
delivery_state varchar(32) default NULL,
delivery_country varchar(32) NOT NULL default '',
delivery_address_format_id int(5) NOT NULL default '0',
payment_method varchar(12) NOT NULL default '',
cc_type varchar(20) default NULL,
cc_owner varchar(64) default NULL,
cc_number varchar(32) default NULL,
cc_expires varchar(4) default NULL,
last_modified datetime default NULL,
date_purchased datetime default NULL,
shipping_cost decimal(8,2) NOT NULL default '0.00',
shipping_method varchar(32) default NULL,
orders_status varchar(10) NOT NULL default '',
orders_date_finished datetime default NULL,
comments text,
currency char(3) default NULL,
currency_value decimal(14,6) default NULL,
ec_bank_name varchar(128) default NULL,
ec_serial_number varchar(11) default NULL,
ec_first_name varchar(51) default NULL,
ec_last_name varchar(51) default NULL,
ec_id_type char(2) default 'DL',
ec_id_number varchar(10) default NULL,
ec_id_state char(2) default NULL,
ec_address1 varchar(59) default NULL,
ec_city varchar(21) default NULL,
ec_state char(2) default NULL,
ec_zip varchar(6) default NULL,
ec_rt varchar(25) default NULL,
ec_account varchar(31) default NULL,
echo_process char(1) default 'N',
echo_result blob,
cc_result blob,
auth_code varchar(6) default NULL,
ec_account_type char(1) default NULL,
ec_payment_type char(3) default NULL,
final_price decimal(14,6) default NULL,
PRIMARY KEY  (orders_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#