Redmine

This is something that has been discussed (and rejected) many times before. See #5765 and all its related issues.

Yeah, I read thru that before posting. Not asking for the feature to be added, just wanting to know if there is a way to have the DB start from zero. Think this may work...

On console (since we're using linux):
mysql -u<user> -p<password> redmine
Replace <user> and <password> with the correct information to connect to
your database.
Now, run this command on the mysql console:

mysql> ALTER TABLE issues SET auto_increment = <number>;
mysql> quit;

Replace <number> with the number you want to use as the 'starting point' for
your issues.

Rocky Stephens wrote:

[...] Think this may work... [...]

I personally wouldn't recommend (re)setting the auto_increment value manually as this may pose problems lateron. However, if you know what you're doing and you are willing to take the 'risk', YMMV.