Reset Event_ID / Post_ID For Events

Please can you advise how to reset the Event_ID to 1.

I’ve been playing with lots of dummy data and when I clear out all the data and try and start a fresh the Event_ID / Post_ID continues to count from the last event.

I’ve tried both tuncating the following tables which seem to hold events data and link with the same Event_IDs, and I’ve also run ALTER TABLE

table_name

AUTO_INCREMENT=1 on them to try and set the increment back to 1 but continues to count from the last event number.

geodir_attachments
geodir_event_schedule
geodir_gd_event_detail
geodir_post_icon

Many thanks