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<mailto: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<mailto:franck.calleja-albil...@alcatel-lucent.com>