ID Consistency

[provocating]

I am having difficulty grasping a concept in the database. If you do a packet collect, and then the SQL is generated it may have something like this at the top. This is from a GFAY generated SQL.

set @StartingNPCTypeID = 54000;
set @StartingSpawnGroupID = 54000;
set @StartingSpawnEntryID = 54000;
set @StartingSpawn2ID = 54000;
set @StartingGridID = 54000;
set @StartingMerchantID = 54000;
set @BaseDoorID = 0;
set @StartingGroundSpawnID = 54000;
set @StartingObjectID = 54000;

DELETE from npc_types where id >= @StartingNPCTypeID and id <= @StartingNPCTypeID + 999 and version = 0;
DELETE from spawngroup where id >= @StartingSpawnGroupID and id <= @StartingSpawnGroupID + 999;
DELETE from spawnentry where spawngroupID >= @StartingSpawnEntryID and spawngroupID <= @StartingSpawnEntryID + 999;
DELETE from spawn2 where id >= @StartingSpawn2ID and id <= @StartingSpawn2ID + 999 and version = 0;

So this would lead me to believe the spawnentry ID's for all GFAY NPC's would be in the 54000-54999 range right ? Trying this query....

SELECT * FROM spawnentry WHERE npcid>54000 AND npcid<54999;

spawngroupID 	npcID 	chance
1488 	54048 	100
1489 	54046 	100
1490 	54049 	100
1491 	54050 	100
1492 	54041 	20
1492 	54051 	20
1492 	54238 	20
1492 	54239 	20
1492 	54251 	20
1493 	54052 	100
1494 	54007 	100

I get this odd numbering in a lot of places. It makes it hard to add things. I will find the odd NPC in live that is not in the DB, but I cannot seem to trust putting it in, because I may step on the *&*() of another zone. I am thinking this has to be me and something I am doing wrong.

Or maybe this....

SELECT max(id) FROM npc_types WHERE id>54000 AND id<54999;

Yields this result.

pID 	npcID 	chance
54001 	268167 	100
54002 	268144 	100
54003 	268177 	100
54004 	268180 	100
54005 	268181 	100
54006 	268182 	100
54007 	268170 	100
54008 	268172 	100
54009 	268183 	100
54010 	268176 	100
54011 	268179 	100
54012 	268168 	100
54013 	268184 	100
54014 	268185 	100
54015 	268174 	100
54016 	268178 	100
54017 	268186 	10

So this is showing spawns in zone 268 ?