SQL - you can find thread/comments on ‘drive/volume manipulation in database’ in the forum! Simple work, piece of cake. The thread was about drive (volume) change. However, its describe data tables and similar. I think just find the folder name, and re-type manually (to the new folder).
I find it for you for Mac - @platypus describe quite well.
Mine SQL script under Windows (its also handle folder name change as i remember):
I hope its helps. I dont have Mac, cant test for you.
Note: As far as i remember, someone once post the ‘whole’ Mac data table, field stuffs, and may the table/fields naming difference PC vs Mac db, but i not find it.