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 ;