Has anyone considered the option to use UUIDs for our PK? I'm pretty sure DBIx::Class supports them. I'm not sure how SQL::Abstract handles them, but I know MySQL provides the uuid() function.
This way we could get rid of this auto increment problem... and get new ones of course :-P
I'm just wondering if there's been any discussion about that.
Regards