Table address_book

Table 

Table Type: InnoDB

Field Type Default Description
id auto_increment N/A PRIMARY KEY - unique id assigned to each account entry

CREATE TABLE address_book (
  address_id int(11) NOT NULL auto_increment,
  ref_id int(11) NOT NULL default '0',
  type char(2) NOT NULL default '',
  primary_name varchar(32) NOT NULL default '',
  contact varchar(32) NOT NULL default '',
  address1 varchar(32) NOT NULL default '',
  address2 varchar(32) NOT NULL default '',
  city_town varchar(24) NOT NULL default '',
  state_province varchar(24) NOT NULL default '',
  postal_code varchar(10) NOT NULL default '',
  country_code char(3) NOT NULL default '',
  notes varchar(64) NOT NULL default '',
  PRIMARY KEY  (address_id),
  KEY customer_id (ref_id,type)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;