[rt-users] forcibly incrementing ticket numbers once tostart out

[Gabriel Cadieux]

many thanks :)

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com]On Behalf Of Hans
Dieter Pearcey
Sent: Wednesday, October 29, 2008 12:05 PM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] forcibly incrementing ticket numbers once
tostart out


On Wed, Oct 29, 2008 at 11:25:39AM -0400, Gabriel Cadieux wrote:
> i just want to increment my ticket numbers up to #1000 or something
> to start off at a higher number (just to look more normal/professional
> than giving out "your ticket is #3" or something)...

ALTER TABLE Tickets AUTO_INCREMENT = 1000

hdp.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales at bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com