Re: During 6.3→7.0: Two SQL statements return errors
I have 4 tables with error: "Incorrect table definition; there can be only one auto column and it must be defined as a key"
(tiki_acct_journal , tiki_acct_stack , tiki_acct_statement , tiki_acct_tax )
To solve it I had to add ENGINE=MyISAM
Like:
CREATE TABLE IF NOT EXISTS tiki_acct_tax (
taxBookId int(10) unsigned NOT NULL,
taxId int(10) unsigned NOT NULL AUTO_INCREMENT,
taxText varchar(63) NOT NULL,
taxAmount double NOT NULL DEFAULT '0',
taxIsFix enum('y','n') NOT NULL DEFAULT 'n',
PRIMARY KEY (taxBookId,taxId)
) ENGINE=MyISAM