managing the image_id numbers in the database dbi file


Well-Known Member
Oct 18, 2006
I have a question about managing the id numbers in my main VSP table,

The image_id numbers get added in the interface dbi file, by looking at
the highest number and adding 1.

Periodically I deactivate entries in order to provide the best interface. And then I might go in and remove
the entries.

That means that gaps get left in the numbering and the id numbers get unnecessarily large.

Is there any way, using cpanel or shell or cgi scripts, to go into that table and prune the id numbers back to a pure sequential series?