Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. [Solved] Setting start value of work package IDs

[Solved] Setting start value of work package IDs

Added by Ralf Weinbrecher about 10 years ago

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?


Replies (2)

RE: Setting start value of work package IDs - Added by Florian Kraft about 10 years ago

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.

RE: Setting start value of work package IDs - Added by Ralf Weinbrecher about 10 years ago

Great. Thank you.

  • (1 - 2/2)
Loading...