I am building a web application (php/mysql). There will potentially be many users (managers). There is a table (let's call it "gurus") into which a manager/user will enter lists of gurus. These lists are used 1 time and then cleared out so the manager/user can start a new guru list. My instinct is to create 1 table that includes a userid field that will link the gurus to the manager/user that entered it. This guru table has an auto-increment ID field in it also. The other alternative would be to create a new table for each user (but I am guessing that's a bad idea).
If I stay with 1 table, is there any need (or way) to "reset" the auto-increment field in the guru table? Will it ever break if it's not able to continue auto-incrementing?
I hope this is clear and thanks for any guidance.