phpMyAdmin for db mgmt?

We just set up an RT test instance and have been testing on it, getting
ready to move a production RT onto the new box. I also installed phpMyAdmin
on this server to easily manage MySQL. I used phpMyAdmin to select
status=deleted and removed those tickets; and then emptied the tickets
table and everything seemed to go fine.

I also deleted everything from the Transaction table, but the next ticket
picked up the next ticket #, it did not start over at 1. How can I start at
1 again?

Joe Micciche