[rt-users] Altering ticket id #

[Ruslan U. Zakirov]

For MySQL
 > ALTER TABLE tbl_name AUTO_INCREMENT = value;

is right thing to do.
			Regards. Ruslan.

Adrian Carter wrote:
> Got it all solved - You need to add an entry via an insert not just 
> update an existing one.
> 
> Adding one with the new seed ticket and then deleting it changed the id 
> to 10001.
> 
> Thanks!
> 
> Niels Bakker wrote:
> 
>> * cartera at lei.net.au (Adrian Carter) [Wed 17 Nov 2004, 17:18 CET]:
>>  
>>
>>> I've rebuilt our RT onto a new platform with better queues etc.. but I
>>> want to reset the Ticket Id to be something like 10000+ so it doesn't
>>> clash with old-rt tickets.
>>>
>>> Can someone point me in the right direction? im checking the Wiki stuff
>>> now, but can't find anything.
>>>   
>>
>>
>> What database do you use?
>>
>> For PostgreSQL, connect to the RT database and issue this a few
>> gazillion times:
>>
>>   select nextval ('tickets_id_seq');
>>
>> For MySQL, you can set the sequence number to arbitrary values; I've
>> only used phpMyAdmin to do so.
>>
>>
>>     -- Niels.
>>
>>  
>>
>