Comment 30 for bug 602211

OK I think we can just add 1 column that links to the new uri in the uri table so it becomes

id | uri | new_id

so i i have a uri xxx

1 | xxx | 1

if its moved or renamed from xxx to yyy we have

1 | xxx | 2
2 | yyy | 2

OR we can do it the other way round by having the new column reference to its old_uri

1 | xxx | 1
2 | yyy | 1

ideas anyone ?