...
- hack around with auto_increment such as setting the auto_increment initial value to a larger number like 10000 so that MFI additions will not collide with changes to the default configuration
- encapsulate lookup value creation in a stored procedure
- try rearranging the inserts so that IDs can be found using select statements rather than using absolute ID values
One way or anther, it would be worthwhile to move away from absolute id references-- though doing so would be a big job.
– Main.vanmh - 01 Jun 2007