Poblem with a create table Query

[Zulfi Khan]

Hi,
I am using windows 7. I have written a following query but its not working. It gives error saying check your manual.
mysql> create table Users(Id int(10) unsigned NOT NULL auto_increment, emailaddr
varchar(128) NOT NULL default '',Password varchar(128) NOT NULL default '', fir
stname varchar(128) NOT NULL default '', lastname varchar Not NULL default '', a
vflag int(2) unsigned, dob varchar (10) NOT NULL default '', propic varchar (12
8) NOT NULL default '', aboutme varchar (128) NOT NULL default '', Primary key(I
d));

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'Not N
ULL default '', avflag int(2) unsigned, dob varchar (10) NOT NULL default ' at
line 1
mysql>


Somebody please guide me with this error.

Zulfi.