We plan to switch to OpenProject. We used a different project planning system before, which also auto-created ID numbers. Because we include these numbers for instance in our commit messages, it would be great, if we could set the start value of the ID numbers of freshly created work packages in OpenProject. By default OpenProject starts with #0, which means, that we get collisions with our existing branch names and commit messages.
Of course we can create 10000 work packages and delete them afterwards in order to increase the counter. ;-)
But isn’t there a better way to set the ID counter to a certain start value?

Hi Ralf!

To my knowledge, this is not possible through the User interface.

If you use MySQL as a database you can alter the auto_increment for the id-column in the work_packages table.

Should be something along the lines of:

ALTER TABLE work_packages AUTO_INCREMENT=10001

For PostgreSQL you would have to update the sequence associated with the work_packages table’s id column.

Great. Thank you.