Mantis Bug Tracker - Forums

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

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.