# Table structure for table `address_book`
#

CREATE TABLE address_book (
  customers_id int(5) NOT NULL default '0',
address_book_id int(5) NOT NULL default '1',
entry_gender char(1) NOT NULL default '',
entry_company varchar(32) default NULL,
entry_firstname varchar(32) NOT NULL default '',
entry_lastname varchar(32) NOT NULL default '',
entry_street_address varchar(64) NOT NULL default '',
entry_suburb varchar(32) default NULL,
entry_postcode varchar(10) NOT NULL default '',
entry_city varchar(32) NOT NULL default '',
entry_state varchar(32) default NULL,
entry_country_id int(5) NOT NULL default '0',
entry_zone_id int(5) NOT NULL default '0',
PRIMARY KEY  (address_book_id,customers_id)
) TYPE=MyISAM

#