FUDforum: How To » Do auto_increment ids ever get changed?

Home » FUDforum » How To » Do auto_increment ids ever get changed?

Show: Today's Messages :: Polls :: Message Navigator

Do auto_increment ids ever get changed? [message #15934]

Sat, 10 January 2004 02:12

Wild_Cat

Messages: 144
Registered: November 2002
Location: Odessa, Ukraine

Karma:

Senior Member

Well, that's probably a stupid question since I don't know perfectly if this is possible at all, but if mySQL presents such a possibility of reindexing the auto-increment primary keys (such as IDs in FUD tables), does it ever happen in FUD (optimization of whatever)? And if yes, in which cases does it happen?

The reason I need this answer for is a try for writing a few hacks where I need to add tables referencing to other tables with user or thread or message ids, so I would like to know in advance if I need to make a kind of similar re-checking for my additional tables?

I did get my user_id changed once in some upgrade process, when another user registered with login admin (I installed the forum with different initial login) and he bacame user id=2 and me user id=9 (the next auto_increment num for the time)... but that could be a unique case due to the name specified, I guess. Or not?

For now I'm concretely interested in msg_id (the id in fud_msg table), but in close perspective in ids from _users and _threads and perhaps even _forums tables too, if it's not too fuzzy a question... (just to not ask twice or thrice) please?

Lady of Avalon

Report message to a moderator

[Message index]

		Do auto_increment ids ever get changed? By: Wild_Cat on Sat, 10 January 2004 02:12
		Re: Do auto_increment ids ever get changed? By: Ilia on Sat, 10 January 2004 02:17
		Re: Do auto_increment ids ever get changed? By: Wild_Cat on Sat, 10 January 2004 13:11
		Re: Do auto_increment ids ever get changed? By: wfjmueller on Sat, 10 January 2004 14:36

Previous Topic:	Which script modify to receive mail notify about all posts?
Next Topic:	header tmpl too easy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 10:19:58 GMT 2024

Total time taken to generate the page: 0.04044 seconds