All pastes #469243 Raw Edit

Mine

public text v1 · immutable
·published 2007-05-03 17:01 UTC
rendered paste body
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