A Database Error Occurred

Error Number: 1075
Incorrect table definition; there can be only one auto column and it must be defined as a key
CREATE TABLE IF NOT EXISTS `config` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`option` varchar(255) NOT NULL,
`value` text NOT NULL,
`comment` text NOT NULL
) DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci
Filename: core/MY_Config.php
Line Number: 242