[rt-users] starting ticket number

[Jim Archer]

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.



--On Monday, June 06, 2005 11:36 AM -0400 "Nathan J. Mehl" 
<rtusers at memory.blank.org> wrote:

>
> I could have sworn that this was in the FAQ once upon a time, but
> repeated searching of the wiki hasn't turned up anything...
>
> Is there a simple way to set RT's starting ticket number to something
> higher than 1?
>
> -n
>
> ------------------------------------------------------<memory at blank.org>
> "The problem with defending the purity of the English language is that
> English is about as pure as a cribhouse whore. We don't just borrow
> words; on occasion, English has pursued other languages down alleyways
> to beat them unconscious and rifle their pockets for new vocabulary."
> (--James D. Nicoll)
> <http://blank.org/memory/>----------------------------------------------
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com