Mysql persistense, reset and rename items

Tags: #<Tag:0x00007f616f55f640>

Hello,

I have two questions. Is there a way to set the new Item# number. Reason I ask is that due to an access problem my current new Item# has jumped far off my existing numbers.

Secondly, can I re-number items by altering the Items table with a new Item# table name id?

Kind regards,
Bastiaan van Haastrecht

Anyone?