mysql error

[bidsea]

hello, im trying to install the 2checkout module but i get this error =

Error
SQL query:

CREATE TABLE `2checkout` (

`2co_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`start_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`finish_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
`return_md5` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
`amount` FLOAT NOT NULL DEFAULT '0',
`2co_order_id` INT( 11 ) NOT NULL DEFAULT '0',
`session_id` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_general_ci

MySQL said:

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

[BlindSide]

I don't know anything about the module, but you could add the following line to the SQl query...

PRIMARY KEY  (2co_id)

so the end code would look like this...

CREATE TABLE `2checkout` (
`2co_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`start_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`finish_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
`return_md5` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL ,
`amount` FLOAT NOT NULL DEFAULT '0',
`2co_order_id` INT( 11 ) NOT NULL DEFAULT '0',
`session_id` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
PRIMARY KEY  (2co_id)
) ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_general_ci

/edit: I recommend you visit the support thread for this module before you do any editing, however.

[bidsea]

y but im not good at this i dont understand how to make PRIMARY KEY (2co_id)