Do you have any real reasons for using a separate table for ids and not using autoincrement?
I'm trying to write my own frontend and updating `ids` table and assigning new ids is someting that database engine should do, not my application.