Making an sql table x2 error

[keyboard]

Hi everyone,,,


CREATE TABLE jenChat_Users (
UserID int(10) unsigned NOT NULL auto_increment,
UserName varchar(20) NOT NULL default '',
LastUpdate timestamp(14) NOT NULL,
PRIMARY KEY (UserID)
);
CREATE TABLE jenChat_Messages (
MessageID int(10) unsigned NOT NULL auto_increment,
UserID int(10) unsigned NOT NULL default '0',
Posted timestamp(14) NOT NULL,
Message varchar(255) NOT NULL default '',
PRIMARY KEY (MessageID)
);

That code is causing this error




Error
SQL query:

CREATE TABLE jenChat_Users(

UserID int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
UserName varchar( 20 ) NOT NULL default '',
LastUpdatetimestamp( 14 ) NOT NULL ,
PRIMARY KEY ( UserID ) );



MySQL said:

#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 '(14) NOT NULL,
PRIMARY KEY (UserID)
)' at line 4





Any help would be great!

[traq]

I've never defined a size for a TIMESTAMP column. In any case, 14 is too few characters for a mysql timestamp. just write `LastUpdate` TIMESTAMP NOT NULL.