Pilot ID help

[OT1999]

Hi,

i have recently set up a VA and we made a few test accounts and have deleted them, now when we get new members it makes their Pilot ID way higher than the previous one.

for example, our highest member id we had was 008 and i had changed him to a lower number to maintain consistency. And today we had someone sign up and the id went to 016. is there any way so that the next person will automatically be set to 009?

thanks in advance

Oli Trehearne

[flyalaska]

go to phpmyadmin, go in the pilots table. Click on the operations tab. In the Auto Increment field, change the currant number to 1. Since you have a new pilot since you deleted the others, there is nothing you can do now. You

[OT1999]

i have done that, thanks, now to wait for a new member to join to test it.