worked fine for me, just cut and pasted it and worked first time.
Database changed
mysql> CREATE TABLE `address_book` (
-> `address_book_id` int(11) NOT NULL auto_increment,
-> `customers_id` int(11) NOT NULL default '0',
-> `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(11) NOT NULL default '0',
-> `entry_zone_id` int(11) NOT NULL default '0',
-> PRIMARY KEY (`address_book_id`),
-> KEY `idx_address_book_customers_id` (`customers_id`)
-> ) TYPE=MyISAM AUTO_INCREMENT=6 ;
Query OK, 0 rows affected, 1 warning (0.20 sec)
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information