nBill Tables on Innodb

[Brock Palen]

I was switching all my tables in my DB to innodb so I can use mysqldump --single-transaction --flush-logs to get consistant backups where I can recovery with the binary log.

In the process though all large segment of the Nbill tables failed to convert with the error:

alter table `preifx_nbill_client_credit` ENGINE=InnoDB;
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key


Are there any chance that nbill schema should be converted to work with innodb?  If so any plans to resolve this issue?

[netshine]

Actually, the entity_id column should not auto increment - you can remove that flag. I will update on the next release.

[Brock Palen]

Got it thanks!