I need help please,

Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated.

• ID - integer with range 0 to 65 thousand, auto increment, primary key

• RegisteredName - variable-length string with max 15 chars, not NULL

• Breed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred

• Height - number with 3 significant digits and 1 decimal place, must be 10.0 and 20.0

• BirthDate - date, must be Jan 1, 2015

Note: Not all constraints can be tested due to current limitations of MySQL.

My code:

-- CREATE TABLE Horse( ID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, RegisteredName VARCHAR(15) NOT NULL, Breed VARCHAR(20) CHECK (Breed IN ('Egyptian Arab', 'Holsteiner', 'Quarter Horse', 'Paint', 'Saddlebred')), Height DECIMAL(3,1) CHECK (Height between 10.0 AND 20.0), BirthDate DATE CHECK (BirthDate >= '2015-01-01') );

After this input I keep getting this error:

ERROR 1064 (42000) at line 2: 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 'ID SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, RegisteredName VARCHAR(15) NOT ' at line 1