Reset the id column for registrants

I want to reset the id column on my eb_registrants table so it starts from 1, I still have people signing up to the event so will nave to correct the Auto Increment count also. My concern is that the eb_field_values table will then be incorrect, is there a way to solve this?

The reason I want to do this is so I can use the registrant ID to match a bib number for the running event which they've signed up for.

Thanks,

Hi Simon

You should not do that because as you can see, the data in #__eb_field_values table will be mismatched. Why don't you create a separate field in #__eb_registrants and populate it's data with bib number field you are taking about?

Tuan