Mysql table build syntax error

I don't know if this is the same error that a previous post was about, but there is an extra comma in the mysql table creation function below. I removed the comma at the end of the messageid field creation statement and the tables built fine.

function chatblock_install() {
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
db_query("CREATE TABLE {chatblock} (
message varchar(255),
username varchar(60),
timestamp int(10),
messageid int(10) NOT NULL auto_increment,
PRIMARY KEY messageid
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;"

Thanks and keep up the good work,
Scott Wagner