<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks Frank... I will give that a try!!<br>
<br>
Jason<br>
<br>
Frank Pater wrote:
<blockquote cite="mid20051118154501.GL23284@staff.dca.net" type="cite">
<pre wrap="">Hi Jason,
I was able to do this for my Postgres-based RT installation with the following SQL:
select setval('tickets_id_seq', <starting-ticket-number>);
I'm sure there is similar code that works for MySQL.
Frank
On Fri, Nov 18, 2005 at 10:11:31AM -0500, Jason Bachman wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> I have a related question to this one.....
Is it possible to change the starting ticket number? The boss would like
the ticket numbers to be something like 1001, 1002, 1003... instead of
1,2,3...
Thanks,
Jason
Walmach, Joe wrote:
Is it possible to reset the tickets back to zero? We're finished with
our testing and want to go live but it would be good to erase all the
test tickets first. Deleting them still holds them in the data base with
the counter leaving off with the last ticket number. Truncating the
ticket table in mysql (Linux) brought me back to zero but all new
tickets include the original data in the history view. For example,
ticket number 1 shows what transpired in the original ticket #1. I hope
I'm not asking a question that's already been answered. I've searched
the archives and only found one incident of this question which went
unanswered. Any help would be appreciated.
Thanks,
Joe
------------------------------------------------------------------
_______________________________________________
[1]<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Be sure to check out the RT Wiki at [2]<a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Download a free sample chapter of RT Essentials from O'Reilly Media at [3]<a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at [4]<a class="moz-txt-link-freetext" href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>
References
Visible links
1. <a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
2. <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com/">http://wiki.bestpractical.com/</a>
3. <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com/">http://rtbook.bestpractical.com/</a>
4. <a class="moz-txt-link-freetext" href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
<blockquote type="cite">
<pre wrap="">_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Be sure to check out the RT Wiki at <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Download a free sample chapter of RT Essentials from O'Reilly Media at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at <a class="moz-txt-link-freetext" href="http://bestpractical.com/services/training.html">http://bestpractical.com/services/training.html</a>
</pre>
</blockquote>
<pre wrap=""><!---->Frank Pater
DCANet
<a class="moz-txt-link-freetext" href="http://www.dca.net">http://www.dca.net</a>
voice: 888-4-DCANET (888-432-2638)
fax: 302-426-6386
</pre>
</blockquote>
</body>
</html>