issue id configuration

Post about your customizations to share with others.

Moderators: Developer, Contributor

Post Reply
minnu
Posts: 18
Joined: 16 Oct 2007, 10:45

issue id configuration

Post by minnu »

I created a database with 10 projects.
For the database as a whole i configure starting of bug id with 100 as below
ALTER TABLE mantis_bug_table AUTO_INCREMENT=100

But i don't know how to make it unique for each project in database,like for project 1 issue id shoul start from 10,for project 2 issue id shoul start from 1000,ie. to apply a relational ALTER command.

Is it really possible by relating the field project_id to the query above.
Or any problem since issue id is a primary key
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Re: issue id configuration

Post by vboctor »

It is not possible to have an ID range per project or have the issue #s for each project start from 1. The only way to do that is to a separate Mantis instance per project. You can have a single Mantis installation that depending on the URL uses a different configuration and connects to a different database. However, such model is not idea for developers to manage their workload.
Migrate your MantisBT to the MantisHub Cloud
Post Reply