Michael Posted May 18, 2010 Report Share Posted May 18, 2010 Quick question, I apologize if this has already been addressed, but I'm curious to know if I can reset the Pilot ID's to start back at 0002. I created two test pilots to see if the registration emails showed okay (which they did, yay), and I noticed it assigned the second test pilot 0003, even though I had deleted 0002. Any way? Alternatively, I can reassign these numbers to future members of staff, but will it re-use the numbers that it initially assigns them when they sign up? Thanks! Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted May 18, 2010 Report Share Posted May 18, 2010 If you go into phpAdmin and then into the phpVMS_Pilots Table you can click on the OPERATIONS tab. You will be presented with a screen with the following on it. The AUTO_INCREMENT field is the next number to be assigned. So if you only have 1 pilot you can set this to 2. Quote Link to comment Share on other sites More sharing options...
Michael Posted May 18, 2010 Author Report Share Posted May 18, 2010 Will do! Thanks a bunch. Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted May 18, 2010 Report Share Posted May 18, 2010 You are very welcome. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.