# Table structure for table `customers`
#

CREATE TABLE customers (
customers_id int(5) NOT NULL auto_increment,
customers_gender char(1) NOT NULL default '',
customers_firstname varchar(32) NOT NULL default '',
customers_lastname varchar(32) NOT NULL default '',
customers_dob datetime NOT NULL default '0000-00-00 00:00:00',
customers_email_address varchar(96) NOT NULL default '',
customers_default_address_id int(5) NOT NULL default '1',
customers_telephone varchar(32) NOT NULL default '',
customers_fax varchar(32) default NULL,
customers_password varchar(40) NOT NULL default '',
customers_newsletter char(1) default NULL,
PRIMARY KEY  (customers_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#