http://requesttracker.wikia.com/wiki/SetStartingId
On Wed, Apr 27, 2011 at 3:23 PM, CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR ** <franck.calleja-albil...@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-albil...@alcatel-lucent.com > > > > De : rt-users-boun...@lists.bestpractical.com > [mailto:rt-users-boun...@lists.bestpractical.com] De la part de > CALLEJA-ALBILLOS, FRANCK (FRANCK)** CTR ** > Envoyé : mercredi 27 avril 2011 13:06 > À : 'rt-users@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-albil...@alcatel-lucent.com > > -- Best regards, Ruslan.
