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.