<!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">
I've reset it on MySQL with InnoDB by simply adding a ticket with the
appropriate number via phpmyadmin, then editing the Primary Index. this
updates the starting number. <br>
<br>
Chris wrote:
<blockquote
cite="mid20050606214534.6E52A4D80B4@diesel.bestpractical.com"
type="cite">
<pre wrap="">And is there any way to change this after the installation?
Chris
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>
[<a class="moz-txt-link-freetext" href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] On Behalf Of Anya Figlin
Sent: Monday, June 06, 2005 12:40 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
Subject: [rt-users] Re: starting ticket number
There is a sequence "tickets_id_seq" that you can define to start with
any number you like.
-anya
On Mon, 2005-06-06 at 12:00 -0400, rt-users-
<a class="moz-txt-link-abbreviated" href="mailto:request@lists.bestpractical.com">request@lists.bestpractical.com</a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Message: 5
Date: Mon, 6 Jun 2005 11:36:54 -0400
From: "Nathan J. Mehl" <a class="moz-txt-link-rfc2396E" href="mailto:rtusers@memory.blank.org"><rtusers@memory.blank.org></a>
Subject: [rt-users] starting ticket number
To: <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:20050606153654.GP25845@blank.org"><20050606153654.GP25845@blank.org></a>
Content-Type: text/plain; charset=us-ascii
I could have sworn that this was in the FAQ once upon a time, but
repeated searching of the wiki hasn't turned up anything...
Is there a simple way to set RT's starting ticket number to something
higher than 1?
-n
</pre>
</blockquote>
<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>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Adrian Carter
Technical Manager
Leading Edge Internet
Web <a class="moz-txt-link-freetext" href="http://www.lei.net.au">http://www.lei.net.au</a> <a class="moz-txt-link-freetext" href="http://support.lei.net.au">http://support.lei.net.au</a>
Direct +61 2 6163 6162 Support 1 300 662 415
E-mail <a class="moz-txt-link-abbreviated" href="mailto:cartera@lei.net.au">cartera@lei.net.au</a>
</pre>
</body>
</html>