[rt-users] Ticket numbering to start at 2000

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

Hi,

It worked perfectly.
Many thanks.

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

-----Message d'origine-----
De : ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] De la part de Ruslan Zakirov
Envoyé : mercredi 27 avril 2011 18:59
À : CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR **
Cc : rt-users at lists.bestpractical.com
Objet : Re: [rt-users] Ticket numbering to start at 2000

http://requesttracker.wikia.com/wiki/SetStartingId

On Wed, Apr 27, 2011 at 3:23 PM, CALLEJA-ALBILLOS, FRANCK (FRANCK)**
CTR ** <Franck.Calleja-Albillos at alcatel-lucent.com> wrote:
> 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
>
>
>
> 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
>
>



-- 
Best regards, Ruslan.