[rt-users] Altering the ticket-number in RT

[Joerg Herbert]

Hi all,

I found a possible solution for the problem of altering the ticket-
Number.

I know this is by no way RT-Specific, but the info I found is 
outdated (1), so I thought, do an Wiki-Article after testing it, but 
this doesnt work:

USE rt32;
BEGIN WORK;
LOCK TABLES Tickets WRITE;
INSERT INTO Tickets (id) VALUES 
DATE_FORMAT(CURRENT_DATE,'%Y%m%d000'));
DELETE FROM Tickets where id = DATE_FORMAT(CURRENT_DATE,'%Y%m%d000');
UNLOCK TABLES;
COMMIT;

the value is created, but not 20050126000 as expected. 


(1)http://web.archive.org/web/20030415214945/fsck.com/rtfm/article.htm
l?id=5

I would be pleased if anybody could help. An wiki-article with the 
working version will follow.
-- 
Bye for now, 
Bis denne,
                   Joerg