What's up with this MySQL syntax?

Code:
CREATE TABLE users (
ID int NOT NULL, 
Alias varchar(40) NOT NULL, 
Team varchar NOT NULL, 
FName varchar NOT NULL, 
SName varchar NOT NULL, 
DOB date NOT NULL, 
Gender tinyint(1) NOT NULL, 
Password varchar NOT NULL, 
Email varchar NOT NULL, 
ICQ varchar NULL, 
MSN varchar NULL, 
AIM varchar NULL, 
YIM varchar NULL, 
Showemail tinyint(1) NOT NULL, 
ShowIM tinyint(1) NOT NULL, 
Mobile varchar NULL, 
CountryID INT NOT NULL, 
State varchar NOT NULL, 
Bio varchar NULL, 
NewPassword varchar NOT NULL, 
NewEmail varchar NOT NULL, 
PicID tinyint NOT NULL,
PRIMARY KEY (ID)
);
TIA