[rt-users] Setting initial ticket number (auto_increment)

[Mike Friedman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 15 Sep 2005 at 11:46 (-0500), Mahoney, Tim wrote:

> AFAIK, AUTO INCREMENT is useful only in MyISAM tables not InnoDB.  My 
> system automatically updates the AUTO INCREMENT setting for the next 
> ticket number, anyway (currently at 9609).  If you initially set it for 
> 60000, create a ticket, check to make sure AUTO INCREMENT has advanced 
> to the next number, then restart your server, what happens?

Tim,

Your point is well-taken and had occurred to me as well, but I was 
reluctant to experiment.

So, I did as you suggest and, sure enough, the first ticket had ID 60000 
and, even after restarting the mysql server, subsequent tickets had IDs of 
60001, 60002, etc.  (I also restarted Apache and the incrementing 
continued properly from there).

Anyway, I guess it's working as I want, so the initial advice on how to 
set auto_increment was correct.  I don't quite know what you meant by 
'AUTO INCREMENT is useful only in MyISAM tables not InnoDB'.  It sure 
proved useful to me for my purpose.

Thanks.

Mike

_____________________________________________________________________
Mike Friedman                   System and Network Security
mikef at ack.Berkeley.EDU          2484 Shattuck Avenue
1-510-642-1410                  University of California at Berkeley
http://ack.Berkeley.EDU/~mikef  http://security.berkeley.edu
_____________________________________________________________________

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBQym5Vq0bf1iNr4mCEQKQ4QCggxhleUNWM+4aYl0zjF2IHAY3M3QAn3w+
4eTnht6Luf1V0ltbKgGS93J6
=+Dfe
-----END PGP SIGNATURE-----