Where did your thread disappear?
Anyway, here's your script (no paren's on the date type):
CREATE TABLE customer (
cust_id int(5) NOT NULL auto_increment,
surname varchar(50) NOT NULL,
firstname varchar(50) NOT NULL,
title varchar(10),
address1 varchar(50) NOT NULL,
address2 varchar(50) NOT NULL,
city varchar(20) NOT NULL,
state varchar(20) NOT NULL,
zipcode varchar(5) NOT NULL,
country varchar(30) NOT NULL,
phone varchar(15) NOT NULL,
fax varchar(20),
email varchar(50) NOT NULL,
birth_date date,
PRIMARY KEY (cust_id),
KEY names (surname,firstname,zipcode)
);
