4 messages in com.mysql.lists.eventum-usersRe: issue counter
FromSent OnAttachments
Maria Oberg13 Dec 2005 06:42 
Bryan Alsdorf19 Dec 2005 00:11 
Maria Oberg19 Dec 2005 06:47 
Bryan Alsdorf19 Dec 2005 06:57 
Subject:Re: issue counter
From:Bryan Alsdorf (bry@mysql.com)
Date:12/19/2005 12:11:36 AM
List:com.mysql.lists.eventum-users

Hi Maria,

Maria Oberg wrote:

Hi, I have a question regarding issue id.

I want to set upp two projects in Eventum. I wish then to separate the counters for the two projects so both projects will have different counters for issue id. Is this possible when it comes to the database Mysql? I know it's not a question of configuration of Eventum.

What version of MySQL are you using? With MySQL 5 I believe it would be possibly to use triggers to accomplish this. If I understand you correctly, you want one project to be numbered say 10,000-20,000 and the other project numbered 20,001-30,000. Correct?

If this is the case, and you are using MySQL 5 let me know and I can get you more details on this. If you are not using MySQL 5, this would be more complex (requiring changes in Eventum).

Best Regards,

-- Bryan Alsdorf, Software Engineer MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification