id's

[ediww]

hi there,

a quick lame q:

are the topic/message ID's really unique? i mean, do they reuse if the topic/post is deleted or really only increment? (do mysql auto_increment ensures this?). if i do delete half of the posts do i eventually end up with sme message or topic id?

wwell edi

[Thantos]

Unless you make some db changes they are not reused.  AUTO_INCREMENT does ensure this.

[ediww]

just to clarify - unless i do really intentionally make changes?
(as described in the comments here, for example:
http://dev.mysql.com/doc/refman/4.1/en/example-auto-increment.html
)
edit: does the same apply to the users, or boards? and futuremore, i hope it will not change in some future version (the id's will be _really uniqie_ id's even when deleted)? i am not talking about autoincrement, but the way SMF reconizes the id's. i do ask if i can rely on them.

[Thantos]

Basically if you don't open up something like PHPMYADMIN and do an ALTER TABLE you can safely assume that no ID will be reused.  And yes this applies to all tables that use an its own ID field

[ediww]

Basically if you don't open up something like PHPMYADMIN and do an ALTER TABLE you can safely assume that no ID will be reused.  And yes this applies to all tables that use an its own ID field

big 10x.