I need sequences because I've made a change to my blog's database schema: an entry and a comment are now the same thing. Each has a unique ID and references the ID of a their parent. Top level entries are their own parents while comments may have a comment as a parent or an entry. I decided to combine the tables since they were almost the same table. The only difference was that the comment table originally had two extra fields: ParentID and ParentType. ParentType was an enum that would determin if ParentID referenced the entry table or the comment table. This sucked because I couldnt use ON DELETE CASCADE with that.
The reason I need a sequence is that in order to create a parent that references itself I need to get its ID before I insert it into the table which means I can use MySQL's ability to get the last value from AUTO_INCREMENT because it would be worthless.
Hopefully this wont be a hard change. I've abstracted the database enough that I should only have to change the class and then possibly a couple of my queries. The only ones I'm worried about are my paging queries because they use LIMIT. Of course I'll have to change my table to no longer use AUTO_INCREMENT as well.
