[rt-users] setting starting ticket number - the answer

[Judson Main]

I thought this newbie would post something useful.  I dug around the
archives and found that a couple people on this list had asked this
question before with no answer forthcoming.

 From the commandline, get into mysql:

% mysql -u username rt3

mysql>alter table tickets auto_increment=1000;


That's all there is to it folks.  It won't affect the tickets currently in the 
database, but every ticket generated thereafter will start at 1000 and
auto increment upwards.

Hope this helps,

Jud.