Auto column & defining key help

[circpros]

I'm trying to create a table from a forum modification with this command:

 

CREATE TABLE `phpbb_ina_cat` ( 
                    `cat_id` mediumint(8) NOT NULL auto_increment, 
                    `mod_id` mediumint(8) default NULL, 
                    `cat_name` varchar(100) default NULL, 
                    `cat_desc` text, 
                    `icon` varchar(255) default NULL, 
                    `special_play` smallint(5) NOT NULL default '0', 
                    `last_game` varchar(25) default NULL, 
                    `last_player` mediumint(8) default NULL, 
                    `last_time` int(11) default NULL ); 

 

And it gives me this error:

 

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

 

I'm new to using mysql, and I'm not certain how to define the key. I'm also not seeing where I am defininf multiple auto colums.

 

I'm hoping someone more experienced than I can point out the problem for me.... Thanks in advance.

[circpros]

Got it... Missing the "PRIMARY KEY ( `cat_id` )".

 

I knew it had to be an easy fix, but the error syntax was leading me to belive it was more intricate.