The following code - from my book - is not working...

Code MySQL:
CREATE TABLE `orders`(
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT UNSIGNED NOT NULL,
`transaction_id` VARCHAR(19) NOT NULL,
`payment_status` VARCHAR(15) NOT NULL,
`payment_amount` DECIMAL(6,2) UNSIGNED NOT NULL,
`payment_date_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY_KEY(`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

phpMyAdmin says there is an error around "KEY"...

What is KEY??

And any ideas why this query won't work?

Thanks,


TomTees