Massive Version and Target milestone changes

[Julien BETI]

Hello,

I'm working on a little program that will massively update Versions and 
Target Milestones on a regular expression matching basis.
I just like to check with you guys that in order to do this without 
wipeout my preciiiiouuuus Bugzilla database, I have to:
 - Check that version length < 64 chrs. and Target Milestone length < 20 
chrs
 - Check that the target name does not already exist for the given product
 - update bugs set version = <new_version> where version = <old_version> 
and product_id = <product_id>
 - update versions set value = <new_version> where value = <old_version> 
and product_id = <product_id>
 - do the same as 2 points above for Target Milestone

Do I miss something? I'll of course make a backup before playing, but I 
do not want to discover 6 months later that something was missing in my 
process :p

Thanks,

Julien.

-- 
Motofix
La route est longue, mais la voie est libre...
http://www.jujunie.com