mysql> CREATE TABLE twatch_ippages ( -> dt int(11) NOT NULL default '0', -> ip char(15) NOT NULL default '', -> ord smallint(5) unsigned NOT NULL auto_increment, -> page int(10) unsigned NOT NULL default '0', -> pagedt int(10) unsigned NOT NULL default '0', -> UNIQUE KEY dt (dt,ip,ord) -> ) ENGINE=innodb; ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key