急 mysql 建表语句，一直1064错误， 可就是看不出来

create table match (
matchID int unsigned not null auto_increment primary key,
hostTeamID int not null default *0*,
guestTeamID int not null default *0*,
matchResult varchar(20) not null default *(0:0)*,
matchTime date not null default *0000-00-00*
)engine myisam charset utf8;