use auto_increment value for create table. refs #1741
keep auto_increment value if latest record is deleted. refs #1738