#1064 - You have an error in your SQL syntax; ~ Help

[slj90]

I am trying to create a table with the following code:

 

CREATE TABLE tbl_product ( 
pd_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, 
cat_id INTEGER UNSIGNED NOT NULL, 

pd_name VARCHAR(100) NOT NULL DEFAULT '', 
pd_description TEXT NOT NULL DEFAULT '', 
pd_price DECIMAL(7,2) NOT NULL DEFAULT 0.00, 
pd_qty SMALLINT UNSIGNED NOT NULL DEFAULT 0, 
pd_image VARCHAR(200), 
pd_thumbnail VARCHAR(200), 
pd_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', 
pd_last_update DATE TIME NOT NULL DEFAULT '0000-00-00 00:00:00', 

PRIMARY KEY (pd_id), 
INDEX (cat_id), 
INDEX (pd_name) 
); 

 

However, I get the following error:

 

#1064 - 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 'TIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (pd_id), IN' at line 12 

 

Please help?

 

Thank you

[premiso]

You have a space in between DATE TIME on this line:

 

pd_last_update DATE TIME NOT NULL 

 

It should be DATETIME.