Changing Case ID number

[k2colo]

We are migrating from an existing ticketing system and would like to keep the assigned number sequence in tact. We are using 4.2.0 Open source. My question is this, is there a config setting somewhere that we can use to change the Case number assingment sequence from 1, 2, 3 etc to 1000, 1001, 1002 etc?

Thanks in Advance....

[andyd]

Hi k2colo, our Case (and Bug and, in Sugar Pro/Ent flavors, Quote) IDs are auto-increments in MySQL. To change the next Case to 1000, use:

ALTER TABLE cases AUTO_INCREMENT = 1000;

This works on MySQL 5. I haven't checked earlier versions of MySQL.

Hope this helps.

Andy

[k2colo]

Thanks Andy...I'll give it a try.....