[rt-users] Ticket numbering to start at 2000

[CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR **]

It is using MYSQL database. Is it possible just to setup the auto_increment like described here :


It depends on what database you are using. Look for the file called
schema.Pg for postgres or schema.mysql, or whatever. You'll see a line
that says something like:

CREATE SEQUENCE tickets_id_seq;

That's for Postgres. I changed it to:

CREATE SEQUENCE tickets_id_seq MINVALUE 8000;

Then I initialized my database.

Cdt,

Franck CALLEJA-ALBILLOS
TREFLE pour Alcatel-Lucent
Centre de Compétences Managed Services - IP/MPLS

Tél. : +33 1 30 77 1362
Email : franck.calleja-albillos at alcatel-lucent.com<mailto:franck.calleja-albillos at alcatel-lucent.com>

De : rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] De la part de CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR **
Envoyé : mercredi 27 avril 2011 13:06
À : 'rt-users at lists.bestpractical.com'
Objet : [rt-users] Ticket numbering to start at 2000

Hi,

I've setup a new installation of RT without migrating data from a previous installation : reason is that new queues/custom fields are defined in the new installation.

So the old installation has reached ticket number 1853.
To avoid having trouble/confusion with my external partner (to whom we are giving our ticket number for reference), I would like to start ticket numbering to 2000 or 3000.

I can't imagine create and close 1999 tickets then use RT Schredder.
Is there another easy way to do this ?

Cdt,

Franck CALLEJA-ALBILLOS
Email : franck.calleja-albillos at alcatel-lucent.com<mailto:franck.calleja-albillos at alcatel-lucent.com>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110427/b07b12f0/attachment.htm>