Moderators joeri Posted September 30, 2009 Moderators Report Share Posted September 30, 2009 is there a way to reuse deleted pilot id lets say pilot 15 (TAY0015) is deleted new pilot regestration normaly the next pilot id wil be used (TAY0030). now my questions is there a way to reuse the TAY0015 becouse i have a few pilots that don't fly and i want to delete them but the pilot id counter keeps getting higher is there a code to let it check for an number not in use. gr joeri Quote Link to comment Share on other sites More sharing options...
AJM101 Posted September 30, 2009 Report Share Posted September 30, 2009 I think this should be in the feature request. I have always thought about this feature and it would be a good idea to have a system where when a pilot is deleted his pilot ID is automatically assigned to the next pilot to register. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted October 1, 2009 Administrators Report Share Posted October 1, 2009 I don't assign ID's, the database does. As for reusing, MySQL doesn't re-use auto-increment ID's, it just goes to the highest + 1. I don't think this can be changed 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.