fixed numbering issue by creating as MyISAM then switching to InnoDB