Hi
There is a system in my game that randomly creates an enemy and inserts it into database before fight but I need an unique ID for each enemy. I found a way to do it; first I decresadly list ID in db and take the biggest ID then I increment it and write the new enemy on db but there is a problem, what if 2 operations take the same "maxID" from db?
Is there a way to autoincrement ID?