The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

managing the image_id numbers in the database dbi file

Discussion in 'General Discussion' started by audrey, Feb 5, 2009.

  1. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    I have a question about managing the id numbers in my main VSP table,
    im_main2.

    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?
     
Loading...

Share This Page