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 ?
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 ?